P6spy日志问题为什么每条sql打印两遍

最新推荐文章于 2024-06-27 16:57:11 发布

aliveClass

最新推荐文章于 2024-06-27 16:57:11 发布

阅读量3k

点赞数

文章标签： P6spy log 日志 java sql

本文链接：https://blog.csdn.net/aya19880214/article/details/12967557

版权

在使用P6spy进行数据库监控时，发现每条SQL语句被打印两次。经排查，发现是由于'useprefix'配置项设置导致。通过在'spy.properties'中将'useprefix'设置为true，可以解决SQL重复打印的问题。

摘要由CSDN通过智能技术生成

Hibernate: select tgoodsinfo0_.goodsId as goodsId3_ .....
10:18:49|54|1|statement|select tgoodsinfo0_.goodsId......desc|select tgoodsinfo0_......_.sale=1 order by tgoodsinfo0_.operDate desc
10:18:49|54|6|statement|select tgoodsinfo0_.goodsId......desc|select tgoodsinfo0_......_.sale=1 order by tgoodsinfo0_.operDate desc
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 1
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 1
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 2
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 2
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 3
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|goodsId3_ = 3
10:18:49|-1||resultset|select tgoodsinfo0_.goodsId ......desc|good