MySQL Order by 查询效率 遇到问题 使用 order by 之后查询效率特别慢 sql语句如下: -- 注:索引:create_time :Key、 id: Primary Key -- wx_user 6000万条数据 select id from wx_user where create_time>='2022-01-29 00:00:00' and create_time<='2022-01-30 00:00:00' order by id limit 1; -- 执行耗时60s+ Explain: select_typetabletypepossible_keyskeykey_lenrefrowExtraSIMPLEwx_userindexctPRIMARY4null273Using where 猜测 order by id 导致where条件的 create_time索引没有使用而使用了主键扫描 解决方案1 修改 order by 使用where 条件 select id from wx_user where create_time>='2022-01-29 00:00:00' and create_time<='2022-01-30 00:00:00' order by create_time limit 1; Explain: select_typetabletypepossible_keyskeykey_lenrefrowExtraSIMPLEwx_userrangectct5null208754Using where; Using index 解决方案2:order by 强制使用索引,则用FORCE INDEX(索引名)。 select id from wx_user where create_time>='2022-01-29' and create_time<='2022-01-30 ' FORCE INDEX(ct) order by id limit 1; explain 参考文档 https://cloud.tencent.com/developer/article/1176479?from=article.detail.1093229