68678b801ae20: GET https://beta.jinchangxiao.com/andy/get-log?DateRange%5Bfrom%5D=2025-07-04&DateRange%5Bto%5D=2025-07-04&request=&response=&url=v2&SearchForm%5Bkeyword%5D=&pass=27d683631efebd89729c8e205b633151 at 2025-07-04 04:06:24 pm by 114.254.1.137
Database Queries
总计5条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:06:24.118 | 73.2 ms | SELECT | SELECT code AS key, CASE WHEN code = 200 THEN '正常'||'('|| code||')' ELSE '错误'||'('|| code||')' END AS name FROM "global"."tbl_api_log" "a" WHERE a.code IS NOT NULL GROUP BY "code" ORDER BY "code" |
| 16:06:24.209 | 41.9 ms | SELECT | SELECT COUNT(*) FROM "global"."tbl_api_log" "a" LEFT JOIN "global"."tbl_logins" "u" ON u.id = a.user_id WHERE ("a"."url" ILIKE '%v2%') AND ((a.time >= '2025-07-04 00:00:00') AND (a.time < TIMESTAMP '2025-07-04 23:59:59' + INTERVAL '1 second')) |
| 16:06:24.251 | 8.9 ms | SELECT | SELECT a.* FROM "global"."tbl_api_log" "a" LEFT JOIN "global"."tbl_logins" "u" ON u.id = a.user_id WHERE ("a"."url" ILIKE '%v2%') AND ((a.time >= '2025-07-04 00:00:00') AND (a.time < TIMESTAMP '2025-07-04 23:59:59' + INTERVAL '1 second')) ORDER BY "id" DESC LIMIT 20 |
| 16:06:24.260 | 2.7 ms | SELECT | SELECT * FROM "global"."tbl_logins" WHERE "id"=1000 |
| 16:06:24.264 | 1.7 ms | SELECT | SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2 |