wordpress，发现 mysql 执行这条语句时间太长了，咋优化啊？

This topic created in 3156 days ago, the information mentioned may be changed or developed.

语句如下： 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 (749) ) 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 0, 24 |

这似乎是在检索某个分类下的最新的文章，但是执行时间高达 103 秒，难道是数据量太大，大约 600 万文章吧，那也不至于这么慢？ vps 配置也不低啊，6 核 8G 内存，ssd 硬盘。请教各位了！

wp_posts

语句

and

post_date

4 replies • 2017-10-23 19:35:53 +08:00