---

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][15]
query1->0.275592
query3->0.050755 -->0.341921
(33)
query3->0.022981 -->0.364902
(33)
query3->0.219042 -->0.583944
(33)
query3->0.466203 -->1.050147
(33)
query3->0.225182 -->1.275329
(33)
query3->0.011117 -->1.286446
(33)
query3->0.008022 -->1.294468
(33)
query3->0.461041 -->1.755509
(33)
query3->0.590175 -->2.345684
(33)
query3->0.010565 -->2.356249
(33)
query3->0.010546 -->2.366795
(33)
query3->0.209093 -->2.575888
(33)
query3->0.214658 -->2.790546
(33)
query3->0.220243 -->3.010789
(33)
query3->0.252088 -->3.262877
(33)+
runtime(3.663411)