Mysql 分页查询sql优化

先查下数据表的总条数：

SELECT COUNT(id) FROM ts_translation_send_address

执行分页界SQL 查看使用时间2.210s

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

把sql语句优化后查询

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

看看执行计划