军哥咨询个数据库查询缓慢的问题

zzuyanan1

目前记录数400万，执行下面的语句都需要60-70秒之间，太慢了，能给点优化方案吗？Copying to tmp table                                                  | SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND (
  wp_term_relationships.term_taxonomy_id IN (39620)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 98136, 24


explain 分析 如插入图片所示

licess

这个不大了解