ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689b08d4ced07: POST https://beta.jinchangxiao.com/vue/client/list-document at 2025-08-12 05:26:44 pm by 124.64.23.198

Database Queries

总计17条数据
TimeDurationTypeQuery
  
17:26:44.8963.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

[+] Explain
17:26:44.9002.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
17:26:44.9051.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3343'

[+] Explain
17:26:44.9091.0 msSELECTSELECT COUNT(*) FROM (SELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"=3343 GROUP BY "cd"."id" ORDER BY "created_at" DESC) "c"

[+] Explain
17:26:44.9100.4 msSELECTSELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"=3343 GROUP BY "cd"."id" ORDER BY "created_at" DESC LIMIT 20

[+] Explain
17:26:44.9120.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1022, 1011, 1023)

[+] Explain
17:26:44.9120.8 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1022, 1023))

[+] Explain
17:26:44.9130.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 2)

[+] Explain
17:26:44.9140.5 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27163, 27042, 26539)

[+] Explain
17:26:44.91419.9 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=104) AND ("object_id" IN (972, 965, 914)) GROUP BY "object_id"

[+] Explain
17:26:44.93416.3 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=104) AND (remind_user_id = 5016 AND is_read = false) AND ("object_id" IN (972, 965, 914)) GROUP BY "object_id"

[+] Explain
17:26:44.9510.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3343

[+] Explain
17:26:44.9510.5 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3841

[+] Explain
17:26:44.9520.3 msSELECTSELECT "id", "id" AS "key", "case_no" AS "name" FROM "a57be577deb434"."tbl_cases" WHERE "id" IN (8659, 8532)

[+] Explain
17:26:44.9555.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=10) AND ("visit_date"='2025-08-12')

[+] Explain
17:26:44.9602.3 msINSERTINSERT INTO "a57be577deb434"."tbl_visit_module_histories" ("user_id", "object_type", "visit_date", "num", "last_visit_at") VALUES (5016, 10, '2025-08-12', 1, 'now()') RETURNING "id"

[+] Explain
17:26:44.9631.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/client/list-document', '{"page":"1","client_id":"3343","web_access_token":"Qh5JmDJfMeK5UOS8NiY7gNZQ_QK3W6g2"}', '{"code":2000,"result":{"list":[{"id":972,"attachment_id":27163,"client_id":3343,"title":"\u4e2d\u90fd\u7269\u6d41\u9632\u706b\u5899\u66ff\u6362\u5b9e\u65bd\u65b9\u6848-v1.2.pdf","description":"","created_by":1022,"created_at":"2025-07-29 17:00:46","updated_at":"2025-07-29 17:00:46","project_id":3841,"case_id":8659,"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M","department_id":2,"avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":27163,"key":27163,"name":"c1d24291-885e-3120-acff-decb0fac97c3","extension":"pdf","path":"\/vue\/attachment\/preview\/c1d24291-885e-3120-acff-decb0fac97c3\/\u4e2d\u90fd\u7269\u6d41\u9632\u706b\u5899\u66ff\u6362\u5b9e\u65bd\u65b9\u6848-v1.2.pdf","orig_name":"\u4e2d\u90fd\u7269\u6d41\u9632\u706b\u5899\u66ff\u6362\u5b9e\u65bd\u65b9\u6848-v1.2.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09"},"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362"},"case":{"id":8659,"key":8659,"name":"IM250729001"},"unread":0,"can_update":true,"can_delete":true},{"id":965,"attachment_id":27042,"client_id":3343,"title":"\u7b7e\u6536\u5355","description":"","created_by":1011,"created_at":"2025-07-23 11:29:30","updated_at":"2025-07-23 11:29:30","project_id":3841,"case_id":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{"id":27042,"key":27042,"name":"8bb634a1-0724-31d0-9780-c1dfe1cc3f0c","extension":"docx","path":"\/vue\/attachment\/preview\/8bb634a1-0724-31d0-9780-c1dfe1cc3f0c\/\u5317\u6c7d\u79d1\u670d-\u7b7e\u6536\u5355.docx","orig_name":"\u5317\u6c7d\u79d1\u670d-\u7b7e\u6536\u5355.docx"},"commentCount":{},"unreadComments":null,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09"},"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362"},"case":null,"unread":0,"can_update":true,"can_delete":true},{"id":914,"attachment_id":26539,"client_id":3343,"title":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8\u670d\u52a1\u65b9\u6848-v1.docx","description":"","created_by":1023,"created_at":"2025-06-24 22:56:02","updated_at":"2025-06-24 22:56:02","project_id":null,"case_id":8532,"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":26539,"key":26539,"name":"c6c39914-bf84-393a-ad00-e783052c6dc8","extension":"docx","path":"\/vue\/attachment\/preview\/c6c39914-bf84-393a-ad00-e783052c6dc8\/\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8\u670d\u52a1\u65b9\u6848-v1.docx","orig_name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8\u670d\u52a1\u65b9\u6848-v1.docx"},"commentCount":{},"unreadComments":null,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09"},"project":null,"case":{"id":8532,"key":8532,"name":"IM250624004"},"unread":0,"can_update":true,"can_delete":true}],"can_create":true,"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-12 17:26:44') RETURNING "id"

[+] Explain