mysql 分页优化

分页优化

 

select * from employees e inner join (select id from employees order by name limit 90000,5) ed

on e.id = ed.id;

 

90001

90002

.....