mysql limit 偏移量过大效率解决方式 转贴

原文地址：https://www.jianshu.com/p/f8d81df7ab28

SELECT * FROM product 
WHERE ID > =(select id from product limit 866613, 1) limit 20

SELECT * FROM product a 
JOIN (select id from product limit 866613, 20) b ON a.ID = b.id