关于MySQL大量数据分页查询优化

select * form user id in(select id from user limit 1000000,10);