SQL耗时统计方法

方案1：AOP

@Aspect
@Component
@Slf4j
public class MapperAspect {
   

  @AfterReturning("execution(* cn.xbmchina.mybatissqltime.mapper.*Mapper.*(..))")
  public void logServiceAccess(JoinPoint joinPoint) {
   
    log.info("Completed: " + joinPoint);
  }


  /**
   *Monitor all public methods of cn.xbmchina.mybatissqltime.mapper.. * mapper package and its subpackages
   */
  @Pointcut("execution(* cn.xbmchina.mybatissqltime.mapper.*Mapper.*(..))")
  private void pointCutMethod() {
   
  }

  /**
   *Announcement surround notification
   *
   * @param pjp
   * @return
   * @throws Throwable
   */
  @Around("pointCutMethod()")
  public Object doAround(ProceedingJoinPoint pjp) throws Throwable {
   
    long begin = System.nanoTime();
    Object obj = pjp.proceed();
    long end = System.nanoTime();

    Log.info ("calling mapper method: {}, parameter: {}, execution time: {} nanoseconds, time: {} milliseconds",
        pjp.getSignature().toString(), Arrays.toString(pjp.getArgs()),
        (end - begin), (end - begin) / 1000000);
    return obj;
  }
}

方案2：Mybatis插件

import org