limit 1000,10 和 limit 10一样快吗？

select * from page  where id >=(select id from page  order by id limit 6000000, 1) order by id limit 10;

这种情况也能通过一些方式去优化。比如

select * from page t1, (select id from page order by user_name limit 6000000, 100) t2  WHERE t1.id = t2.id;