I have a site with 10,000+ posts and probably 10 times that in comments. I see this query over and over in my slow query log.
# Time: 111003 15:20:48
# User@Host: user[user] @ localhost 
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 52156
SELECT count(*) as c FROM wp_posts WHERE ID IN (SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id = 18562) AND ID IN (SELECT post_id FROM wp_postmeta WHERE meta_key = '_menu_item_menu_item_parent' AND meta_value = '40158') ORDER BY menu_order;
It appears that this is part of wordpress and not a plugin. How can I speed this up and fix this issue?
P.S. this is not the only slow query but its the one that shows up the most.