---

Debug:
REGION:00053Cats
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, %Getaway Country%, published)[0][11]
query1->0.017949
query3->0.025246 -->0.0589
(53)
query3->0.039458 -->0.098358
(53)
query3->0.008782 -->0.10714
(53)
query3->0.044305 -->0.151445
(53)
query3->0.532759 -->0.684204
(53)
query3->0.053912 -->0.738116
(53)
query3->0.008514 -->0.74663
(53)
query3->0.049344 -->0.795974
(53)
query3->0.065079 -->0.861053
(53)
query3->0.027468 -->0.888521
(53)
query3->0.063187 -->0.951708
(53)+
runtime(1.036452)