687075427139b: POST https://beta.jinchangxiao.com/v2/implement/list at 2025-07-11 10:21:54 am by 223.104.40.121
Database Queries
总计6条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:21:54.626 | 3.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
| 10:21:54.631 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:21:54.634 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_cases" WHERE "id"='8260' |
| 10:21:54.637 | 3.5 ms | SELECT | SELECT COUNT(*) FROM (SELECT i.*, i.left_at - i.arrived_at AS hours_spent FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id WHERE "case_id"=8260 GROUP BY "i"."id" ORDER BY "is_draft" DESC, "i"."has_following_work" DESC, "i"."left_at" DESC) "c" |
| 10:21:54.640 | 5.1 ms | SELECT | SELECT i.*, i.left_at - i.arrived_at AS hours_spent FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id WHERE "case_id"=8260 GROUP BY "i"."id" ORDER BY "is_draft" DESC, "i"."has_following_work" DESC, "i"."left_at" DESC LIMIT 10 |
| 10:21:54.648 | 4.7 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/implement/list', '{"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","id":"8260","posttime":"1752200576","token":"62e9ced09394103652a53d712862521b","version_code":"1141"}', '{"code":200,"data":{"list":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":10},"can_create":false},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-11 10:21:54') RETURNING "id" |