关于大表查询最后几页过慢的原因

select * from test_user where id>9900000 limit 0,10;
select * from test_user limit 9900000,10;
select * from test_user where id in (select b.id from (select id from test_user where id>9900000 limit 0,10) as b); //子查询

[SQL]select * from test_user where id>9900000 limit 0,10;
受影响的行: 0
时间: 0.019s


[SQL]
select * from test_user limit 9900000,10;
受影响的行: 0
时间: 1.147s


[SQL]
select * from test_user where id in (select b.id from (select id from test_user where id>9900000 limit 0,10) as b);
受影响的行: 0
时间: 0.001s