Skip to content

Instantly share code, notes, and snippets.

@nathanpitman
Created September 16, 2014 13:19
Show Gist options
  • Save nathanpitman/4d8512b78f03bbbe9cb7 to your computer and use it in GitHub Desktop.
Save nathanpitman/4d8512b78f03bbbe9cb7 to your computer and use it in GitHub Desktop.
Slow EE Category Query
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