如何把执行的 SQL 语句打印到控制台,从而方便调试?
一、logback-spring.xml 里改为了 DEBUG
[pre]
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<include resource="org/springframework/boot/logging/logback/base.xml" />
<logger name="org.springframework.web" level="DEBUG"/>
<logger name="org.springboot.sample" level="DEBUG" />
<!-- 开发、测试环境 -->
<springProfile name="dev,test">
<logger name="org.springframework.web" level="DEBUG"/>
<logger name="org.springboot.sample" level="DEBUG" />
<logger name="io.renren" level="DEBUG" />
</springProfile>
<!-- 生产环境 -->
<springProfile name="prod">
<logger name="org.springframework.web" level="ERROR"/>
<logger name="org.springboot.sample" level="ERROR" />
<logger name="io.renren" level="ERROR" />
</springProfile>
</configuration>
[/pre]
二、log-slow-sql 也改为了 true
[pre]
filter:
stat:
log-slow-sql: true
slow-sql-millis: 1
merge-sql: false
wall:
config:
multi-statement-allow: true
[/pre]
做了以上两步的修改,仍然看不到 SQL 语句,如图:
img[//cdn.renren.io/70228202102050927316111.png]