Mysql 分页查询sql优化

COUNT(id) FROM ts_translation_send_address

EXPLAIN SELECT *  FROM   ts_translation_send_address ORDER BY id LIMIT 2000000,10;

SELECT * from ts_translation_send_address t INNER JOIN ( SELECT ID FROM ts_translation_send_address  ORDER BY id limit 200000,10) as temp on t.id = temp.ID

看看执行计划

 

Mysql 分页查询sql优化

标签：color   select   http   image   ESS   com   info   order   sele