SQL监控列表
GET
/system/watcher/query
请求参数
Query 参数
Header 参数
返回响应
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request GET 'http://127.0.0.1:8000/system/watcher/query?date=&pageSize=¤t=' \
--header 'Authorization: Bearer '响应示例响应示例
{
"data": {
"data": [
{
"connection": "mysql",
"sql": "select * from `personal_access_tokens` where `personal_access_tokens`.`id` = '9' limit 1",
"time": "1.85",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Http\\Middleware\\AllowCrossDomain.php",
"line": 18,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:16:30"
},
{
"connection": "mysql",
"sql": "select * from `sys_user` where `sys_user`.`id` = 1 and `sys_user`.`deleted_at` is null limit 1",
"time": "1.56",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Http\\Middleware\\AllowCrossDomain.php",
"line": 18,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:16:30"
},
{
"connection": "mysql",
"sql": "update `personal_access_tokens` set `last_used_at` = '2025-09-13 07:16:30', `personal_access_tokens`.`updated_at` = '2025-09-13 07:16:30' where `id` = 9",
"time": "2.47",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Http\\Middleware\\AllowCrossDomain.php",
"line": 18,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:16:30"
},
{
"connection": "mysql",
"sql": "select count(*) as aggregate from `sys_rule`",
"time": "2.49",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Repositories\\Repository.php",
"line": 146,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:16:30"
},
{
"connection": "mysql",
"sql": "select * from `sys_rule` limit 10 offset 0",
"time": "0.26",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Repositories\\Repository.php",
"line": 146,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:16:30"
},
{
"connection": "mysql",
"sql": "select * from `personal_access_tokens` where `personal_access_tokens`.`id` = '9' limit 1",
"time": "0.49",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Http\\Middleware\\AllowCrossDomain.php",
"line": 18,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:19:51"
},
{
"connection": "mysql",
"sql": "select * from `sys_user` where `sys_user`.`id` = 1 and `sys_user`.`deleted_at` is null limit 1",
"time": "0.45",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Http\\Middleware\\AllowCrossDomain.php",
"line": 18,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:19:51"
},
{
"connection": "mysql",
"sql": "update `personal_access_tokens` set `last_used_at` = '2025-09-13 07:19:51', `personal_access_tokens`.`updated_at` = '2025-09-13 07:19:51' where `id` = 9",
"time": "1.02",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Http\\Middleware\\AllowCrossDomain.php",
"line": 18,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:19:51"
},
{
"connection": "mysql",
"sql": "select count(*) as aggregate from `sys_rule`",
"time": "0.67",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Repositories\\Repository.php",
"line": 146,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:19:51"
},
{
"connection": "mysql",
"sql": "select * from `sys_rule` limit 10 offset 0",
"time": "0.26",
"slow": false,
"file": "D:\\UserData\\Desktop\\XinAdmin\\xin-laravel\\app\\Repositories\\Repository.php",
"line": 146,
"host_name": "W10-20250902325",
"recorded_at": "2025-09-13 07:19:51"
}
],
"total": 97,
"pageSize": 10,
"current": 1
},
"success": true,
"msg": "ok",
"showType": 0
}修改于 2025-09-13 08:24:19