简单直接,在需要返回查询的接口前后添加代码即可
1、开启相关配置
DB::connection()->enableQueryLog();
2、写入sql信息到日志里面
info('查询SQL数据425:', DB::getQueryLog());
4、日志信息
{
"request_id": "ed3a4a5e-25cc-47ba-8145-13362b202c62",
"sapi": "CGI",
"app_id": "lumen",
"env": "dev",
"instance_id": "project-dev-03",
"time": "2023-04-26 10:59:47.530443",
"level": "INFO",
"message": "查询SQL数据425:",
"context": [ // 查询返回sql
{
"query": "select * from `ka_audience_new` where `audience_id` = ? and `ka_audience_new`.`deleted_at` is null and `ka_audience_new`.`domain` = ? limit 1",
"bindings": [ // sql条件
2,
"chaofandashi"
],
"time": 56.86 // 毫秒
},
{
"query": "select `member_id`, `job_number`, `is_purchaser` from `ka_member` where (`member_id` = ?) and `ka_member`.`deleted_at` is null and `ka_member`.`domain` = ? limit 1",
"bindings": [
154044,
"chaofandashi"
],
"time": 56.5
},
{
"query": "select `ka_store_member`.`store_code`, `ka_store_member`.`identity`, `ka_store`.`onedata_code` from `ka_store_member` left join `ka_store` on `ka_store_member`.`store_code` = `ka_store`.`store_code` where `ka_store_member`.`job_number` = ? and `ka_store`.`domain` = ? and `ka_store`.`deleted_at` is null and `ka_store_member`.`deleted_at` is null and `ka_store_member`.`domain` = ? order by `ka_store_member`.`identity` desc limit 1",
"bindings": [
"YSU1653381124",
"chaofandashi",
"chaofandashi"
],
"time": 57.03
},
{
"query": "select * from `ka_audience_new_identity` where `audience_id` = ? and (`identity` = ? or `identity` = ?) and `ka_audience_new_identity`.`deleted_at` is null and `ka_audience_new_identity`.`domain` = ? limit 1",
"bindings": [
2,
2,
3,
"chaofandashi"
],
"time": 56.68
}
]
}
实例:
推荐