---

Debug:
REGION:00003Cats
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, %British Columbia%, published)[0][44]
query1->0.05891
query3->0.057968 -->0.135115
(34)
query3->0.032636 -->0.167751
(34)
query3->0.051018 -->0.218769
(34)
query3->0.074261 -->0.29303
(34)
query3->0.086592 -->0.379622
(34)
query3->0.066601 -->0.446223
(34)
query3->0.111214 -->0.557437
(34)
query3->0.091701 -->0.649138
(34)
query3->0.117939 -->0.767077
(34)
query3->0.115983 -->0.88306
(34)
query3->0.03646 -->0.91952
(34)
query3->0.15312 -->1.07264
(34)
query3->0.098459 -->1.171099
(33)
query3->0.09672 -->1.267819
(33)
query3->0.256426 -->1.524245
(33)
query3->0.054394 -->1.578639
(33)
query3->0.046156 -->1.624795
(33)
query3->0.028643 -->1.653438
(33)
query3->0.068215 -->1.721653
(33)
query3->0.123949 -->1.845602
(33)
query3->0.065003 -->1.910605
(33)
query3->0.070114 -->1.980719
(33)
query3->0.032124 -->2.012843
(33)
query3->0.054844 -->2.067687
(33)
query3->0.038641 -->2.106328
(33)
query3->0.053773 -->2.160101
(33)
query3->0.022742 -->2.182843
(33)
query3->0.095733 -->2.278576
(35)
query3->0.074783 -->2.353359
(35)
query3->0.091481 -->2.44484
(35)
query3->0.017086 -->2.461926
(35)
query3->0.089015 -->2.550941
(35)
query3->0.056033 -->2.606974
(35)
query3->0.055001 -->2.661975
(35)
query3->0.123799 -->2.785774
(35)
query3->0.169129 -->2.954903
(35)
query3->0.07716 -->3.032063
(35)
query3->0.063158 -->3.095221
(35)
query3->0.056728 -->3.151949
(35)
query3->0.06866 -->3.220609
(35)
query3->0.019307 -->3.239916
(35)
query3->0.030149 -->3.270065
(35)
query3->0.019338 -->3.289403
(35)
query3->0.049494 -->3.338897
(35)+
runtime(3.51716)