MySQL性能优化 - 分页查询越来越慢

正常的sql

select * from bd_user limit 3000000, 20; 

优化的sql

select * from bd_user where id>=3000000 order by id limit 0, 20;