p6spy输出完整sql
引入依赖!-- p6spy 核心包 --dependencygroupIdp6spy/groupIdartifactIdp6spy/artifactIdversion3.9.1/version/dependency配置日志spy.properties# 自定义日志格式化logMessageFormatcom.p6spy.engine.spy.appender.CustomLineFormat# 输出格式customLogMessageFormatConsume Time%(executionTime)ms %(currentTime)\nExecute SQL%(sqlSingleLine)# 输出到项目统一slf4j日志logback控制台appendercom.p6spy.engine.spy.appender.Slf4JLogger# 动态数据源自动代理无需url加p6spy前缀必须falseuseprefixfalse# 过滤无关日志只打印执行SQLexcludecategoriesinfo,debug,result,batch,commit,rollback,resultset# 时间格式dateformatyyyy-MM-dd HH:mm:ss# SQL单行输出sqlSingleLinetrue# 真实驱动多数据源自动识别driverlistcom.mysql.cj.jdbc.Driver# 关闭多余模块modulelistcom.p6spy.engine.outage.P6OutageFactory修改 application.yml 开启动态数据源 P6Spyspring: datasource: dynamic: # 开启多数据源内置p6spy代理不用改数据库url、driver p6spy: true mybatis-plus: configuration: # 注释/删除该行或改为不输出日志 # log-impl: org.apache.ibatis.logging.stdout.StdOutImpl其它生产环境需要关闭p6spy需要消耗性能
