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;
    }
}