offset大的时候的比较
SELECT * FROM persons LIMIT 200000,10;
耗时0.078s
SELECT *
FROM persons WHERE id>=(
SELECT id FROM persons
ORDER BY id LIMIT 200000,1
) LIMIT 10
耗时0.109s
2021-07-12 14:46:13
SELECT * FROM persons LIMIT 200000,10;
耗时0.078s
SELECT *
FROM persons WHERE id>=(
SELECT id FROM persons
ORDER BY id LIMIT 200000,1
) LIMIT 10
耗时0.109s