select * from s_user order by id  limit 100000,10
select s_user.* from s_user join (select id from s_user order by id limit 100000,10) as tmp on s_user.id = tmp.id

超过10w是有稍微明细的加快