select a.a,b.b ,,,
from a
left join b on a.id=b.aid
left join ....on ...
...
limit 24000,1000
问题:当limit偏移量越来越大时,耗时越来越大。原因:先大集合关联、计算,再偏移返回
优化:
select a.a,b.b ,,,
from (select * from a limit 24000,1000)a
left join b on a.id=b.aid
left join ....on ...
...
先查询出小集合,再外关联、计算,返回。