Created
September 16, 2014 13:19
-
-
Save nathanpitman/4d8512b78f03bbbe9cb7 to your computer and use it in GitHub Desktop.
Slow EE Category Query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Time: 0.1710 | |
SELECT DISTINCT(exp_categories.cat_id), parent_id FROM exp_categories | |
LEFT JOIN exp_category_posts ON exp_categories.cat_id = exp_category_posts.cat_id | |
LEFT JOIN exp_channel_titles ON exp_category_posts.entry_id = exp_channel_titles.entry_id | |
WHERE group_id IN ('13','13','13') AND exp_category_posts.cat_id IS NOT NULL AND exp_channel_titles.channel_id IN ('1','8','5','6','10','11','13','18','14','15','16','19','20','22','41','42','30','31','33','34','35','36','37','39','40','43','44') AND exp_channel_titles.status != 'closed' AND exp_channel_titles.entry_date < 1410873364 AND (exp_channel_titles.expiration_date = 0 OR exp_channel_titles.expiration_date > 1410873364) AND parent_id = 0 ORDER BY group_id, parent_id, cat_order | |
#APP/libraries/Template.php L:1559 Channel::categories() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment