From cd4748a35e265d8e4b0c3dafa40cc29ac7bfe4f4 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Wed, 01 Apr 2026 22:26:37 +0800
Subject: [PATCH] feat(mybatis): 添加分页插件的 SQL 计数优化功能
---
src/main/java/cc/mrbird/febs/common/configure/MybatisPlusConfigure.java | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/common/configure/MybatisPlusConfigure.java b/src/main/java/cc/mrbird/febs/common/configure/MybatisPlusConfigure.java
index 5a7b1d6..df88d9e 100644
--- a/src/main/java/cc/mrbird/febs/common/configure/MybatisPlusConfigure.java
+++ b/src/main/java/cc/mrbird/febs/common/configure/MybatisPlusConfigure.java
@@ -5,6 +5,7 @@
import com.baomidou.mybatisplus.core.parser.ISqlParser;
import com.baomidou.mybatisplus.extension.parsers.BlockAttackSqlParser;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
+import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.annotation.Order;
@@ -45,6 +46,9 @@
List<ISqlParser> sqlParserList = new ArrayList<>();
sqlParserList.add(new BlockAttackSqlParser());
paginationInterceptor.setSqlParserList(sqlParserList);
+ // 开启 count 的 join 优化，支持带 group by 的 sql
+ paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
+
return paginationInterceptor;
}
}
--
Gitblit v1.9.1