Mysql 百万数据limit 查询

SELECT * FROM db_storage limit 1085031,20
查询时间为0.486s

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

SELECT a.* FROM db_storage a INNER JOIN (SELECT id FROM db_storage LIMIT 1085031,20) b ON a.id = b.id;