--原 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