---

Debug:
REGION:00050Cats
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, %Toronto Area%, published)[0][13]
query1->0.021388
query3->0.033819 -->0.068519
(50)
query3->0.013883 -->0.082402
(50)
query3->0.010438 -->0.09284
(50)
query3->0.024067 -->0.116907
(50)
query3->0.018935 -->0.135842
(50)
query3->0.009087 -->0.144929
(50)
query3->0.01753 -->0.162459
(50)
query3->0.022006 -->0.184465
(50)
query3->0.015131 -->0.199596
(50)
query3->0.010781 -->0.210377
(50)
query3->0.023349 -->0.233726
(50)
query3->0.012217 -->0.245943
(50)
query3->0.014719 -->0.260662
(50)+
runtime(0.373516)