MyBatis-Plus 为什么我分页查询的时候有两个查询总数的sql ,然后我查询的时候，拼接了两个 limit

当前使用版本(必填,否则不予处理)

3.4.2

该问题是如何引起的？(确定最新版也有问题再提!!!)

升级版本之后发生的问题

重现步骤(如果有就写完整)

报错信息

2021-06-03 19:42:14.361 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Rule Type: sharding 2021-06-03 19:42:14.362 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Logic SQL: SELECT COUNT(1) FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 2021-06-03 19:42:14.362 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=a, alias=Optional.of(bpr)), Table(name=b, alias=Optional.of(bp))]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=a, quoteCharacter=NONE, schemaNameLength=0), TableToken(tableName=b, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=1, logicSQL=SELECT COUNT(1) FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0)), containStar=false, firstSelectItemStartIndex=7, selectListStopIndex=14, groupByLastIndex=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(1), alias=Optional.absent(), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=null, subqueryStatement=null, subqueryStatements=[], subqueryConditions=[]) 2021-06-03 19:42:14.362 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Actual SQL: master ::: SELECT COUNT(1) FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 ::: [0] 2021-06-03 19:42:14.483 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Rule Type: sharding 2021-06-03 19:42:14.483 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Logic SQL: SELECT COUNT() FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? 2021-06-03 19:42:14.483 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=a, alias=Optional.of(bpr)), Table(name=b, alias=Optional.of(bp))]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=a, quoteCharacter=NONE, schemaNameLength=0), TableToken(tableName=b, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=2, logicSQL=SELECT COUNT() FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ?)), containStar=false, firstSelectItemStartIndex=7, selectListStopIndex=14, groupByLastIndex=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(), alias=Optional.absent(), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=Limit(offset=null, rowCount=LimitValue(value=-1, index=1, boundOpened=false)), subqueryStatement=null, subqueryStatements=[], subqueryConditions=[]) 2021-06-03 19:42:14.483 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Actual SQL: master ::: SELECT COUNT() FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? ::: [0, 15] 2021-06-03 19:42:14.547 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Rule Type: sharding 2021-06-03 19:42:14.547 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Logic SQL: SELECT COUNT(1) FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? 2021-06-03 19:42:14.547 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=a, alias=Optional.of(bpr)), Table(name=b, alias=Optional.of(bp))]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=a, quoteCharacter=NONE, schemaNameLength=0), TableToken(tableName=b, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=2, logicSQL=SELECT COUNT(1) FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ?)), containStar=false, firstSelectItemStartIndex=7, selectListStopIndex=14, groupByLastIndex=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(1), alias=Optional.absent(), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=Limit(offset=null, rowCount=LimitValue(value=-1, index=1, boundOpened=false)), subqueryStatement=null, subqueryStatements=[], subqueryConditions=[]) 2021-06-03 19:42:14.547 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Actual SQL: master ::: SELECT COUNT(1) FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? ::: [0, 15] 2021-06-03 19:42:14.704 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Rule Type: sharding 2021-06-03 19:42:14.705 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Logic SQL: SELECT bpr.id, bpr.update_date, bpr.create_date, bpr.is_deleted, bpr.org_id, bpr.is_cancellation, bpr.org_internal_code, bpr.claim_user, bpr.claim_date, bpr.latest_service_time, bpr.is_service_personnel, bp.required_total + bpr.required_total required_total, bp.no_required_total + bpr.no_required_total no_required_total, bp.img_total + bpr.img_total img_total, bp.id AS bp_id, bp.create_date AS bp_create_date, bp.create_user AS bp_create_user, bp.update_date AS bp_update_date, bp.update_user AS bp_update_user, bp.is_deleted AS bp_is_deleted, bp.cardid, bp.id_type, bp.people_type, bp.name, bp.used_name, bp.sex, bp.residence_addr_rk, bp.inhabited_area, bp.birth_day, bp.birth_place, bp.org_grid_cs, bp.telephone, bp.national, bp.education, bp.martial_rkfs, bp.political_rkfs, bp.spouse_cardid, bp.military, bp.native_place, bp.height, bp.health_rkfs, bp.blood_type, bp.religious, bp.email, bp.yxbz, bp.pic, bp.data_from, bp.death, bp.is_standard, bp.longitude, bp.latitude, bp.education, bp.martial_rkfs FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? LIMIT ? 2021-06-03 19:42:14.705 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=a, alias=Optional.of(bpr)), Table(name=b, alias=Optional.of(bp))]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=a, quoteCharacter=NONE, schemaNameLength=0), TableToken(tableName=b, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=2, logicSQL=SELECT bpr.id, bpr.update_date, bpr.create_date, bpr.is_deleted, bpr.org_id, bpr.is_cancellation, bpr.org_internal_code, bpr.claim_user, bpr.claim_date, bpr.latest_service_time, bpr.is_service_personnel, bp.required_total + bpr.required_total required_total, bp.no_required_total + bpr.no_required_total no_required_total, bp.img_total + bpr.img_total img_total, bp.id AS bp_id, bp.create_date AS bp_create_date, bp.create_user AS bp_create_user, bp.update_date AS bp_update_date, bp.update_user AS bp_update_user, bp.is_deleted AS bp_is_deleted, bp.cardid, bp.id_type, bp.people_type, bp.name, bp.used_name, bp.sex, bp.residence_addr_rk, bp.inhabited_area, bp.birth_day, bp.birth_place, bp.org_grid_cs, bp.telephone, bp.national, bp.education, bp.martial_rkfs, bp.political_rkfs, bp.spouse_cardid, bp.military, bp.native_place, bp.height, bp.health_rkfs, bp.blood_type, bp.religious, bp.email, bp.yxbz, bp.pic, bp.data_from, bp.death, bp.is_standard, bp.longitude, bp.latitude, bp.education, bp.martial_rkfs FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? LIMIT ?)), containStar=false, firstSelectItemStartIndex=7, selectListStopIndex=1007, groupByLastIndex=0, items=[CommonSelectItem(expression=bpr.id, alias=Optional.absent()), CommonSelectItem(expression=bpr.update_date, alias=Optional.absent()), CommonSelectItem(expression=bpr.create_date, alias=Optional.absent()), CommonSelectItem(expression=bpr.is_deleted, alias=Optional.absent()), CommonSelectItem(expression=bpr.org_id, alias=Optional.absent()), CommonSelectItem(expression=bpr.is_cancellation, alias=Optional.absent()), CommonSelectItem(expression=bpr.org_internal_code, alias=Optional.absent()), CommonSelectItem(expression=bpr.claim_user, alias=Optional.absent()), CommonSelectItem(expression=bpr.claim_date, alias=Optional.absent()), CommonSelectItem(expression=bpr.latest_service_time, alias=Optional.absent()), CommonSelectItem(expression=bpr.is_service_personnel, alias=Optional.absent()), CommonSelectItem(expression=bp.required_total+bpr.required_totalrequired_total, alias=Optional.of(required_total)), CommonSelectItem(expression=bp.no_required_total+bpr.no_required_totalno_required_total, alias=Optional.of(no_required_total)), CommonSelectItem(expression=bp.img_total+bpr.img_totalimg_total, alias=Optional.of(img_total)), CommonSelectItem(expression=bp.id, alias=Optional.of(bp_id)), CommonSelectItem(expression=bp.create_date, alias=Optional.of(bp_create_date)), CommonSelectItem(expression=bp.create_user, alias=Optional.of(bp_create_user)), CommonSelectItem(expression=bp.update_date, alias=Optional.of(bp_update_date)), CommonSelectItem(expression=bp.update_user, alias=Optional.of(bp_update_user)), CommonSelectItem(expression=bp.is_deleted, alias=Optional.of(bp_is_deleted)), CommonSelectItem(expression=bp.cardid, alias=Optional.absent()), CommonSelectItem(expression=bp.id_type, alias=Optional.absent()), CommonSelectItem(expression=bp.people_type, alias=Optional.absent()), CommonSelectItem(expression=bp.name, alias=Optional.absent()), CommonSelectItem(expression=bp.used_name, alias=Optional.absent()), CommonSelectItem(expression=bp.sex, alias=Optional.absent()), CommonSelectItem(expression=bp.residence_addr_rk, alias=Optional.absent()), CommonSelectItem(expression=bp.inhabited_area, alias=Optional.absent()), CommonSelectItem(expression=bp.birth_day, alias=Optional.absent()), CommonSelectItem(expression=bp.birth_place, alias=Optional.absent()), CommonSelectItem(expression=bp.org_grid_cs, alias=Optional.absent()), CommonSelectItem(expression=bp.telephone, alias=Optional.absent()), CommonSelectItem(expression=bp.national, alias=Optional.absent()), CommonSelectItem(expression=bp.education, alias=Optional.absent()), CommonSelectItem(expression=bp.martial_rkfs, alias=Optional.absent()), CommonSelectItem(expression=bp.political_rkfs, alias=Optional.absent()), CommonSelectItem(expression=bp.spouse_cardid, alias=Optional.absent()), CommonSelectItem(expression=bp.military, alias=Optional.absent()), CommonSelectItem(expression=bp.native_place, alias=Optional.absent()), CommonSelectItem(expression=bp.height, alias=Optional.absent()), CommonSelectItem(expression=bp.health_rkfs, alias=Optional.absent()), CommonSelectItem(expression=bp.blood_type, alias=Optional.absent()), CommonSelectItem(expression=bp.religious, alias=Optional.absent()), CommonSelectItem(expression=bp.email, alias=Optional.absent()), CommonSelectItem(expression=bp.yxbz, alias=Optional.absent()), CommonSelectItem(expression=bp.pic, alias=Optional.absent()), CommonSelectItem(expression=bp.data_from, alias=Optional.absent()), CommonSelectItem(expression=bp.death, alias=Optional.absent()), CommonSelectItem(expression=bp.is_standard, alias=Optional.absent()), CommonSelectItem(expression=bp.longitude, alias=Optional.absent()), CommonSelectItem(expression=bp.latitude, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=Limit(offset=null, rowCount=LimitValue(value=-1, index=1, boundOpened=false)), subqueryStatement=null, subqueryStatements=[], subqueryConditions=[]) 2021-06-03 19:42:14.705 INFO 8612 --- [ XNIO-2 task-1] ShardingSphere-SQL : Actual SQL: master ::: SELECT bpr.id, bpr.update_date, bpr.create_date, bpr.is_deleted, bpr.org_id, bpr.is_cancellation, bpr.org_internal_code, bpr.claim_user, bpr.claim_date, bpr.latest_service_time, bpr.is_service_personnel, bp.required_total + bpr.required_total required_total, bp.no_required_total + bpr.no_required_total no_required_total, bp.img_total + bpr.img_total img_total, bp.id AS bp_id, bp.create_date AS bp_create_date, bp.create_user AS bp_create_user, bp.update_date AS bp_update_date, bp.update_user AS bp_update_user, bp.is_deleted AS bp_is_deleted, bp.cardid, bp.id_type, bp.people_type, bp.name, bp.used_name, bp.sex, bp.residence_addr_rk, bp.inhabited_area, bp.birth_day, bp.birth_place, bp.org_grid_cs, bp.telephone, bp.national, bp.education, bp.martial_rkfs, bp.political_rkfs, bp.spouse_cardid, bp.military, bp.native_place, bp.height, bp.health_rkfs, bp.blood_type, bp.religious, bp.email, bp.yxbz, bp.pic, bp.data_from, bp.death, bp.is_standard, bp.longitude, bp.latitude, bp.education, bp.martial_rkfs FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? LIMIT ? ::: [0, 15, 15] 2021-06-03 19:42:14.853 ERROR 8612 --- [ XNIO-2 task-1] c.t.p.c.e.ExceptionHandlerContrller : 运行时异常：----------------{}

org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 15' at line 1 The error may exist in file [D:\workSpace\baseData\population-service\target\classes\mapper\BasePplResidenceMapper.xml] The error may involve defaultParameterMap The error occurred while setting parameters SQL: SELECT bpr.id, bpr.update_date, bpr.create_date, bpr.is_deleted, bpr.org_id, bpr.is_cancellation, bpr.org_internal_code, bpr.claim_user, bpr.claim_date, bpr.latest_service_time, bpr.is_service_personnel, bp.required_total + bpr.required_total required_total, bp.no_required_total + bpr.no_required_total no_required_total, bp.img_total + bpr.img_total img_total, bp.id AS bp_id, bp.create_date AS bp_create_date, bp.create_user AS bp_create_user, bp.update_date AS bp_update_date, bp.update_user AS bp_update_user, bp.is_deleted AS bp_is_deleted, bp.cardid, bp.id_type, bp.people_type, bp.name, bp.used_name, bp.sex, bp.residence_addr_rk, bp.inhabited_area, bp.birth_day, bp.birth_place, bp.org_grid_cs, bp.telephone, bp.national, bp.education, bp.martial_rkfs, bp.political_rkfs, bp.spouse_cardid, bp.military, bp.native_place, bp.height, bp.health_rkfs, bp.blood_type, bp.religious, bp.email, bp.yxbz, bp.pic, bp.data_from, bp.death, bp.is_standard, bp.longitude, bp.latitude, bp.education, bp.martial_rkfs FROM a bpr LEFT JOIN b bp ON bpr.base_ppl_id = bp.id WHERE bpr.org_id IN ('1013931449465716737') AND bpr.claim_status = ? AND bp.death = 0 AND bpr.is_cancellation = 0 AND bpr.is_deleted = 0 LIMIT ? LIMIT ? Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 15' at line 1 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 15' at line 1 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy202.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:122) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:86) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy203.selectForPage(Unknown Source) at com.tianque.population.service.impl.BasePplResidenceServiceImpl.selectForPage(BasePplResidenceServiceImpl.java:200) at com.tianque.population.service.impl.BasePplResidenceServiceImpl$$FastClassBySpringCGLIB$$68ec6b7a.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.tianque.doraemon.core.aspect.DoraemonValidateAspect.serviceParamCheckAround(DoraemonValidateAspect.java:64) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.tianque.population.service.impl.BasePplResidenceServiceImpl$$EnhancerBySpringCGLIB$$f4f8207.selectForPage() at com.tianque.population.service.impl.BasePplUnifyServiceImpl.selectPageForPopulation(BasePplUnifyServiceImpl.java:411) at com.tianque.population.service.impl.BasePplUnifyServiceImpl$$FastClassBySpringCGLIB$$cfb5f61d.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at com.tianque.doraemon.core.aspect.DoraemonValidateAspect.serviceParamCheckAround(DoraemonValidateAspect.java:64) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.tianque.population.service.impl.BasePplUnifyServiceImpl$$EnhancerBySpringCGLIB$$9cfa5fd0.selectPageForPopulation() at com.tianque.population.controller.actual.BasePplUnifyController.pageForPopulation(BasePplUnifyController.java:65) at com.tianque.population.controller.actual.BasePplUnifyController$$FastClassBySpringCGLIB$$c00b857.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.tianque.population.controller.actual.BasePplUnifyController$$EnhancerBySpringCGLIB$$9156c2c4.pageForPopulation() at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:517) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:584) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) at com.tianque.doraemon.log.filter.LogTraceFilter.doFilter(LogTraceFilter.java:25) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:109) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:111) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 15' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) at org.apache.shardingsphere.shardingjdbc.executor.SQLExecuteCallbackFactory$2.executeSQL(SQLExecuteCallbackFactory.java:65) at org.apache.shardingsphere.shardingjdbc.executor.SQLExecuteCallbackFactory$2.executeSQL(SQLExecuteCallbackFactory.java:61) at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:69) at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:58) at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:126) at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.parallelExecute(ShardingExecuteEngine.java:103) at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:83) at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:73) at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:56) at org.apache.shardingsphere.shardingjdbc.executor.AbstractStatementExecutor.executeCallback(AbstractStatementExecutor.java:128) at org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor.execute(PreparedStatementExecutor.java:156) at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:172) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy415.query(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy415.query(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy415.query(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy415.query(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:69) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy414.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 130 common frames omitted

2021-06-03 19:42:14.916 WARN 8612 --- [ XNIO-2 task-1] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.springframework.jdbc.BadSqlGrammarException:

Comment From: lisen0921

肯定是有引入了一个通用的组件儿, 注入了一次Interceptor, 而在当前项目又注入了一次Interceptor

Comment From: qmdx

分页插件注入了2次了

Comment From: liuchao007

那为什么注入两次呢，怎么解决呢------------------ 原始邮件 ------------------ @.> 发送时间: 2021年6月7日(星期一) 中午11:19 @.>; @.**@.**>; 主题: Re: [baomidou/mybatis-plus] 为什么我分页查询的时候有两个查询总数的sql ,然后我查询的时候，拼接了两个 limit (#3589)

Comment From: lisen0921

那为什么注入两次呢，怎么解决呢------------------ 原始邮件 ------------------ @.> 发送时间: 2021年6月7日(星期一) 中午11:19 @.>; @.**@.**>; 主题: Re: [baomidou/mybatis-plus] 为什么我分页查询的时候有两个查询总数的sql ,然后我查询的时候，拼接了两个 limit (#3589)

在你的当前项目不要注入分页插件儿就行了