Category "mysql-slow-query-log"

Getting slow query from SELECT COUNT(*) on WordPress

I have the query below and it gives me a count of 32,000. SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationsh