--原
select id,name from user limit 500000,10

--优化后：
select id,name from user u inner join (select id from user limit 500000,10)as tmp 
on tmp.id = u.id