一、优化
select * from test a inner join (select id from test where val=4 limit 300000,5) b on a.id=b.id;
https://zhuanlan.zhihu.com/p/214377808
二、limit 10000,20前面几万条数据都不是我们要的,为啥也要回表
https://segmentfault.com/q/1010000038665420?utm_source=tag-newest