limit  的基数比较大时使用  between
例如：select * from admin order by admin_id limit 100000,10
优化为：select * from admin where admin_id between 100000 and 100010 order by admin_id

占座0000000000000000000