spring.datasource.dynamic.p6spy 修改后不生效

  1. spring.datasource.dynamic.p6spy 设置修改为需要重启服务才能生效。

    2021-10-27 11:47:25 INFO  Hyperion-Novel-Qa-Admin http-nio-10141-exec-1 p6spy 2021-10-27 11:47:25 | 耗时 0 ms | SQL 语句：
SELECT id,account_code,account_name,owner,status,create_user_id,create_user_name,create_time,update_user_id,update_user_name,update_time FROM qa_promotion_account LIMIT 10;

  2. 另一种 SQL 日志是由于 mapper 的日志级别被默认设置为 DEBUG 而打印出来的。

    2021-10-27 11:49:37 DEBUG Hyperion-Novel-Qa-Admin http-nio-10141-exec-7 com.mokasz.zhyx.hyperion.novel.qa.dao.mapper.PromotionAccountMapper.selectPage_mpCount ==>  Preparing: SELECT COUNT(*) FROM qa_promotion_account
2021-10-27 11:49:37 DEBUG Hyperion-Novel-Qa-Admin http-nio-10141-exec-7 com.mokasz.zhyx.hyperion.novel.qa.dao.mapper.PromotionAccountMapper.selectPage_mpCount ==> Parameters: 
2021-10-27 11:49:37 DEBUG Hyperion-Novel-Qa-Admin http-nio-10141-exec-7 com.mokasz.zhyx.hyperion.novel.qa.dao.mapper.PromotionAccountMapper.selectPage_mpCount <==      Total: 1
2021-10-27 11:49:37 DEBUG Hyperion-Novel-Qa-Admin http-nio-10141-exec-7 com.mokasz.zhyx.hyperion.novel.qa.dao.mapper.PromotionAccountMapper.selectPage ==>  Preparing: SELECT id,account_code,account_name,owner,status,create_user_id,create_user_name,create_time,update_user_id,update_user_name,update_time FROM qa_promotion_account LIMIT ?
2021-10-27 11:49:37 DEBUG Hyperion-Novel-Qa-Admin http-nio-10141-exec-7 com.mokasz.zhyx.hyperion.novel.qa.dao.mapper.PromotionAccountMapper.selectPage ==> Parameters: 10(Long)
2021-10-27 11:49:37 DEBUG Hyperion-Novel-Qa-Admin http-nio-10141-exec-7 com.mokasz.zhyx.hyperion.novel.qa.dao.mapper.PromotionAccountMapper.selectPage <==      Total: 1