数据管理后台翻页查看数据越来越慢
SELECT * FROM tablename WHERE ID > =(select id from product limit 866613, 1) limit 20
查询时间为0.2秒,简直是一个质的飞跃啊,哈哈
另一种写法
SELECT * FROM tablename a JOIN (select id from tablename limit 866613, 20) b ON a.ID = b.id
查询时间也很短,赞!