1.安装mybatis log plugin
2.logback格式不要加[]
%date{yyyy-MM-dd HH:mm:ss.SSS} %level %thread %logger{56}.%method:%L - %msg%n
3.tools->mybatis log plugin就可以看到完整sql
select id, role_id, permission, add_time, update_time, deleted
FROM table
WHERE ( role_id in ( 1 ) and deleted = false );