使用id全为排序字段。
或如下优化,10W数据
SELECT * FROM `wx_login` ORDER BY id DESC LIMIT 100500,20; #0.186
优化后:
SELECT a.* FROM wx_login a inner join (select id from `wx_login` ORDER BY id DESC LIMIT 100500,20) b using(id); #0.074
这个优化不明显
如果时间排序:
SELECT a.* FROM wx_login a ORDER BY a.followdate LIMIT 100000 ,20; #0.248
SELECT a.* FROM wx_login a JOIN (SELECT id FROM wx_login ORDER BY followdate) AS t ON t.id = a.id LIMIT 100000 ,20 ; #0.267