---

Debug:

Build HierarchyQUERY
SELECT l.*, t2.* FROM cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id JOIN ( SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id) t2 ON t2.hierarchy_id = h.hierarchy_id WHERE status = ? AND l.listing_date < now() group by l.id order by t2.max desc, t2.name asc, l.listing_date desc
SELECT tmp.hierarchy_id, h.name, max( listing_date ) AS max, h.extra1 as link, count(tmp.id) as count FROM ( SELECT h.hierarchy_id, l.id, l.listing_date from cms_module_listings l JOIN cms_module_listings_prodtohier h ON l.id = h.listing_id WHERE status = ? AND l.listing_date < now() GROUP BY l.id ) tmp JOIN cms_module_listings_hierarchy h on tmp.hierarchy_id = h.id where upper(h.long_name) LIKE upper(?) group by tmp.hierarchy_id order by max desc, h.name asc
(published, %Vancouver Island / Gulf Islands%, published)[0][14]
query1->0.032318
query3->0.020544 -->0.082496
(33)
query3->0.102561 -->0.185057
(33)
query3->0.050035 -->0.235092
(33)
query3->0.053378 -->0.28847
(33)
query3->0.043578 -->0.332048
(33)
query3->0.047088 -->0.379136
(33)
query3->0.05556 -->0.434696
(33)
query3->0.048329 -->0.483025
(33)
query3->0.053437 -->0.536462
(33)
query3->0.052005 -->0.588467
(33)
query3->0.058938 -->0.647405
(33)
query3->0.06322 -->0.710625
(33)
query3->0.061991 -->0.772616
(33)
query3->0.008039 -->0.780655
(33)+
runtime(0.820928)