Two ways to count SQL runtime in Mybatis

import ;
import .*;
import ;
import ;
import ;
import ;

import ;
import ;

@Intercepts({
    @Signature(type = , method = "query", args = {, }),
    @Signature(type = , method = "update", args = {}),
    @Signature(type = , method = "batch", args = {})
})
public class SqlExecutionInterceptor implements Interceptor {

    private static final Log logger = ();

    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        // Get SQL statement        StatementHandler statementHandler = (StatementHandler) ();
        BoundSql boundSql = ();
        String sql = ().replaceAll("\\s+", " ").trim();

        // Record the start time        long startTime = ();

        // Execute SQL        Object result = ();

        // Calculate execution time        long endTime = ();
        long executionTime = endTime - startTime;

        // Record SQL statements and execution time        ("SQL: " + sql);
        ("Execution time: " + executionTime + " ms");

        return result;
    }

    @Override
    public Object plugin(Object target) {
        return (target, this);
    }

    @Override
    public void setProperties(Properties properties) {
        // Parameters can be passed to the interceptor through the configuration file    }
}

@Configuration
public class MyBatisConfig {
    @Bean
    public SqlExecutionInterceptor sqlExecutionInterceptor() {
        return new SqlExecutionInterceptor();
    }
}

<dependency>
    <groupId></groupId>
    <artifactId>druid</artifactId>
    <version>1.2.8</version> <!-- Use the latest version number -->
</dependency>

spring:
  datasource:
    druid:
      url: jdbc:mysql://localhost:3306/your_database
      username: your_username
      password: your_password
      driver-class-name: 
      # Enable Druid monitoring function      filters: stat
      # Configure slow SQL records      maxActive: 20
      initialSize: 1
      minIdle: 1
      maxWait: 60000
      # Set the slow query threshold in milliseconds      slowSqlMillis: 2000
      logSlowSql: true

import ;
import ;
import ;
import ;
import ;
import ;

@Configuration
public class DruidConfig {

    // Register Druid's monitoring Servlet    @Bean
    public ServletRegistrationBean<StatViewServlet> druidServlet() {
        ServletRegistrationBean<StatViewServlet> servletRegistrationBean = 
                new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        // Set the login username and password        ("loginUsername", "admin");
        ("loginPassword", "admin123");
        return servletRegistrationBean;
    }

    // Register Druid's monitoring filter    @Bean
    public FilterRegistrationBean<WebStatFilter> filterRegistrationBean() {
        FilterRegistrationBean<WebStatFilter> filterRegistrationBean = 
                new FilterRegistrationBean<>(new WebStatFilter());
        // Set filtered URL mode        ("/*");
        // Ignored resources        ("exclusions", "*.js,*.css,/druid/*");
        return filterRegistrationBean;
    }
}

 <dependency>
    <groupId></groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.8</version>
</dependency>

############# Monitoring configuration# Whether to enable StatFilter, the default value is false=true
# Set the url pattern for monitoring intercepting. If you do not configure the default, all requests will be intercepted.-pattern=/*
# Set unintercepted urls, separated by English commas=/druid/*
# Whether to enable Session statistics function, the default value is true-stat-enable=true
# Set the maximum number of session statistics, -1 means no limit, the default value is 1000-stat-max-count=1000
# Set the Principal name of Session statistics, the default value is "sessionStat"-session-name=sessionStat
# Set the cookie name that saves the Session ID, the default value is "sessionStatMaxCount"-cookie-name=sessionStatMaxCount
# Whether to enable the profile, if it is enabled, you need to configure the filter for Druid monitoring: profile-enable=true

######### StatViewServlet Configuration# Whether to enable StatViewServlet, the default value is false (considering security issues, it is recommended to set passwords or whitelists to ensure security if you need to enable)=true
# Set the access path of the monitoring page, default is /druid/*-pattern=/druid/*
# Whether to allow resetting of monitoring data, the default value is true-enable=true
# Set the login username of the monitoring page, which is empty by default (if the login username and password are set, the login box will pop up when accessing the monitoring page)-username=admin
# Set the login password for the monitoring page, which is empty by default (if the login username and password are set, the login box will pop up when accessing the monitoring page)-password=123456
# Set the IP address list that allows access to the monitoring page. Multiple IP addresses are separated by English commas, and the default is empty (if a whitelist is set, only the IP addresses in the whitelist can access the monitoring page)=127.0.0.1,192.168.1.1
# Set the IP address list that prohibits access to the monitoring page. Multiple IP addresses are separated by English commas, and the default is empty (if a blacklist is set, the IP addresses in the blacklist cannot access the monitoring page)=192.168.1.2

#### Slow sql# Enable Druid monitoring filter=true
# Is it slow to record SQL query-slow-sql=true
# Database type, here is MySQL-type=mysql
# Define the threshold for slow SQL queries in milliseconds-sql-millis=1000

 <!--   slowsql   -->
    <appender name="slowSqlLog" class="">
        <File>${}/slow_sql-${}.log</File>
        <!--Scrolling strategy，Scroll by time TimeBasedRollingPolicy-->
        <rollingPolicy class="">
            <!--File path,Defines the way to split the logs——Archives the logs of each day into a file,To prevent logs from filling the entire disk space-->
            <FileNamePattern>${}/arch/slow_sql/slow_sql.%d{yyyy-MM-dd}.%</FileNamePattern>
            <!-- The most single log files 100MB -->
            <maxFileSize>100MB</maxFileSize>
            <!--Keep only the most recent10Day's log-->
            <maxHistory>10</maxHistory>
            <!--Used to specify the upper limit size of the log file，Then this value，The old log will be deleted-->
            <totalSizeCap>1GB</totalSizeCap>
        </rollingPolicy>
        <!--Log output encoding format-->
        <encoder>
            <charset>UTF-8</charset>
            <pattern>[%d{yyyy-MM-dd HH:mm:ss}|%mdc{traceId}|] - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="" level="info" additivity="false">
        <appender-ref ref="slowSqlLog"/>
    </logger>