分页优化

参考文章
现在有400w条数据，要查询390w后面10条

-- 一般的分页查询
SELECT * FROM test ORDER BY id DESC LIMIT 3900000,10; -- 1.241s

SELECT * FROM test WHERE id BETWEEN 3900000 AND 3900009; -- 0.001s 只能适用于自增主键, id必须存在

-- limitid型
SELECT * FROM test WHERE id >= (SELECT id FROM test LIMIT 3900000,1) ORDER BY id DESC LIMIT 10; -- 0.865s

-- 延迟关联 推荐
SELECT * FROM test t1 JOIN (SELECT id FROM test LIMIT 3900000,10) t2 ON t1.id = t2.id ORDER BY t1.id DESC; -- 0.862s

图解：