mysql 分页查询用子查询优化 1.使用between 优于 limit(limit偏移量变大,会越来越慢,可以如下解决) select * from t_product where id >= (select id from t_product order by id limit 10000, 1) limit 10