打印单条sql
在操作前加Debug(), 相当于将临时将日志级别改为Info
DB.Debug().Where("ID = ?"...只打印慢查询
slowLogger := logger.New(
//将标准输出作为Writer
log.New(os.Stdout, "\r\n", log.LstdFlags...,只有Warn和Info级别会输出慢查询日志
LogLevel: logger.Warn,
},
)
DB, err = gorm.Open(mysql.Open(dsn), &gorm.Config...{
Logger:slowLogger,
})
//输出类似
//2021/05/14 11:36:28 /home/ballqiu/go/gorm/mydb.go:98 SLOW SQL >...age`,`is_admin`,`is_valid`,`login_time`) VALUES ('ball',0,true,false,'2021-05-14 11:36:28.436')
说明:
默认的SlowThreshold