Spring boot +mybatis plus输出sql日志的两种方式

第一种
配置类型
# 配置slq打印日志
logging.level.com.lawt.repository.mapper=debug
打印出来:
如果只需要打印
第二种
java代码类型
/**
* 打印 sql
*/
@Bean
public PerformanceInterceptor performanceInterceptor() {
PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
//格式化sql语句
Properties properties = new Properties();
properties.setProperty("format", "false");
performanceInterceptor.setProperties(properties);
return performanceInterceptor;
}
打印:
Time:21 ms - ID:com.lawt.repository.mapper.UserInfoMapper.selectById
Execute SQL:SELECT id,user_name FROM user_info WHERE id=111