慢sql日志

pang.jiabao

2024-10-25 f5834172b9583cd727382bd4084df09b8a520a78

慢sql日志

 pom.xml

@@ -108,6 +108,10 @@
            <artifactId>truelicense-core</artifactId>
            <version>1.33</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>
    </dependencies>

    <build>

 src/main/java/com/zy/common/config/SqlExecutionTimeAspect.java

New file
@@ -0,0 +1,33 @@
package com.zy.common.config;

/**
 * @author pang.jiabao
 * @description
 * @createDate 2024/10/25 16:18
 */
import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.annotation.Around;
import org.aspectj.lang.annotation.Aspect;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Component;

@Aspect
@Component
public class SqlExecutionTimeAspect {

    private static final Logger logger = LoggerFactory.getLogger(SqlExecutionTimeAspect.class);

    @Around("execution(* com.zy.asrs.mapper..*(..))") // 替换为你的Mapper包路径
    public Object logSqlExecutionTime(ProceedingJoinPoint joinPoint) throws Throwable {
        long startTime = System.currentTimeMillis();
        Object result = joinPoint.proceed();
        long duration = System.currentTimeMillis() - startTime;

        if (duration > 500) { // 设置阈值
            logger.error("慢SQL: {}，执行时间: {}毫秒", joinPoint.getSignature(), duration);
        }

        return result;
    }
}