packagecom.pannk.demo.config;importcom.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;importcom.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;importorg.springframework.context.annotation.Bean;importorg.springframework.context.annotation.Configuration;/** * Created by wolf on 20-11-10. */@ConfigurationpublicclassMyBatisPlusConfig{@BeanpublicPaginationInterceptorpaginationInterceptor(){PaginationInterceptorpaginationInterceptor=newPaginationInterceptor();// 设置请求的页面大于最大页后操作, true调回到首页,false 继续请求 默认false// paginationInterceptor.setOverflow(false);// 设置最大单页限制数量,默认 500 条,-1 不受限制// paginationInterceptor.setLimit(500);// 开启 count 的 join 优化,只针对部分 left joinpaginationInterceptor.setCountSqlParser(newJsqlParserCountOptimize(true));returnpaginationInterceptor;}}