## 原sqlSELECT a.empno,a.empname,a.job,a.sal,b.depno,b.depname
from emp a leftjoin dep b on a.depno = b.depno orderby a.id desclimit4800000,25;## 使用索引覆盖+子查询优化SELECT a.empno,a.empname,a.job,a.sal,b.depno,b.depname
from emp a leftjoin dep b on a.depno = b.depno
where a.id >=(select id from emp orderby id limit4800000,1)orderby a.id limit25;## 记住上次查询的末尾 局限性:需要根据唯一主键进行处理,并且分页查询连续查询下一页SELECT a.id,a.empno,a.empname,a.job,a.sal,b.depno,b.depname
from emp a leftjoin dep b on a.depno = b.depno
where a.id >4800000orderby a.id limit25;
mybatis文章目录mybatismybatis分页问题#和$符号的区别mybatis分页问题采用全量查询进行list分页 // 方式一 List<String> data = new ArrayList<>(); List<List<String>> partition = Lists.partition(data, pageSize); List<String> list = parti