ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3a2f2bce565: POST https://beta.jinchangxiao.com/v2/task/list-file at 2026-06-23 03:00:59 pm by 223.104.40.22

Database Queries

总计14条数据
TimeDurationTypeQuery
  
15:00:59.8501.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'

[+] Explain
15:00:59.8530.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
15:00:59.8550.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='106'

[+] Explain
15:00:59.8571.2 msSELECTSELECT COUNT(*) FROM (SELECT s.* FROM "a57be577deb434"."tbl_task_files" "s" WHERE "task_group_id"='106' GROUP BY "s"."id" ORDER BY "s"."created_by" DESC, "s"."created_at" DESC) "c"

[+] Explain
15:00:59.8580.6 msSELECTSELECT s.* FROM "a57be577deb434"."tbl_task_files" "s" WHERE "task_group_id"='106' GROUP BY "s"."id" ORDER BY "s"."created_by" DESC, "s"."created_at" DESC LIMIT 10 OFFSET 10

[+] Explain
15:00:59.8600.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
15:00:59.8610.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
15:00:59.8610.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
15:00:59.86242.7 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=103) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (124, 123, 122, 121, 120, 119, 118, 117, 116, 115)) GROUP BY "object_id"

[+] Explain
15:00:59.9051.1 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32736, 32735, 32734, 32733, 32732, 32731, 32730, 32729, 32728, 32727)

[+] Explain
15:00:59.90738.3 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=103) AND ("object_id" IN (124, 123, 122, 121, 120, 119, 118, 117, 116, 115)) GROUP BY "object_id"

[+] Explain
15:00:59.9450.6 msSELECTSELECT "id", "id" AS "key", "title" AS "name", "client_id", "head_of", "status" FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106

[+] Explain
15:00:59.9460.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1000) AND ("task_group_id"=106)

[+] Explain
15:00:59.9563.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1160, 'v2/task/list-file', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","page":"2","posttime":"1782198016","task_group_id":"106","token":"68f04b0151caff653f0dac6ebff8324d","version_code":"1160"}', '{"code":200,"data":{"list":[{"id":124,"attachment_id":32736,"task_group_id":106,"created_by":1000,"title":"22","description":"","created_at":"2026-06-23 10:02:34","updated_at":"2026-06-23 10:02:34","file_url":"\u4e0b\u6b21v\u597d","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32736,"key":32736,"name":"7bd6597c-4769-3219-8a57-b0d7319d9976","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/7bd6597c-4769-3219-8a57-b0d7319d9976\/Sky-Sunset.jpg","orig_name":"Sky-Sunset.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":123,"attachment_id":32735,"task_group_id":106,"created_by":1000,"title":"21","description":"","created_at":"2026-06-23 10:02:16","updated_at":"2026-06-23 10:02:16","file_url":"\u55f7\u55f7\u8bed\u8a00","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32735,"key":32735,"name":"e20f0ba9-8797-3486-a334-c48c198c9ee2","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/e20f0ba9-8797-3486-a334-c48c198c9ee2\/Sado_from_the_sea.jpg","orig_name":"Sado_from_the_sea.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":122,"attachment_id":32734,"task_group_id":106,"created_by":1000,"title":"20","description":"","created_at":"2026-06-23 10:01:58","updated_at":"2026-06-23 10:01:58","file_url":"\u4ece\u6b64v","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32734,"key":32734,"name":"d92c9236-38f4-31dd-a330-cac480d55048","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/d92c9236-38f4-31dd-a330-cac480d55048\/inspirational-smll-business-quotes.jpg","orig_name":"inspirational-smll-business-quotes.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":121,"attachment_id":32733,"task_group_id":106,"created_by":1000,"title":"19","description":"","created_at":"2026-06-23 10:01:42","updated_at":"2026-06-23 10:01:42","file_url":"\u8303\u5fb7\u8428\u5929","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32733,"key":32733,"name":"263e4c64-4f4c-3f32-84c6-57c8165e7fae","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/263e4c64-4f4c-3f32-84c6-57c8165e7fae\/HH_meetingsevents4.jpg","orig_name":"HH_meetingsevents4.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":120,"attachment_id":32732,"task_group_id":106,"created_by":1000,"title":"18","description":"","created_at":"2026-06-23 10:01:23","updated_at":"2026-06-23 10:01:23","file_url":"v\u4e0d\u80fd","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32732,"key":32732,"name":"40a8f21b-7798-3480-aa60-93fd6e15427c","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/40a8f21b-7798-3480-aa60-93fd6e15427c\/Grass-Morning-Dew.jpg","orig_name":"Grass-Morning-Dew.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":119,"attachment_id":32731,"task_group_id":106,"created_by":1000,"title":"17","description":"","created_at":"2026-06-23 10:01:05","updated_at":"2026-06-23 10:01:05","file_url":"\u6536\u5230\u98ce\u683c","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32731,"key":32731,"name":"4d161daa-f133-3cf5-9383-fdbb711e375d","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/4d161daa-f133-3cf5-9383-fdbb711e375d\/Cooperation-Electronic-Discovery.jpg","orig_name":"Cooperation-Electronic-Discovery.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":118,"attachment_id":32730,"task_group_id":106,"created_by":1000,"title":"16","description":"","created_at":"2026-06-23 10:00:46","updated_at":"2026-06-23 10:00:46","file_url":"\u4ed6\u53d1\u7684","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32730,"key":32730,"name":"94f8ed19-7aa8-3cc8-bebe-1e2fa5d5e238","extension":"png","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/94f8ed19-7aa8-3cc8-bebe-1e2fa5d5e238\/Children-404_logo.png","orig_name":"Children-404_logo.png"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":117,"attachment_id":32729,"task_group_id":106,"created_by":1000,"title":"15","description":"","created_at":"2026-06-23 10:00:31","updated_at":"2026-06-23 10:00:31","file_url":"\u5199\u9519","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32729,"key":32729,"name":"61e17c7c-8f78-3a06-92e6-4e6d16426787","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/61e17c7c-8f78-3a06-92e6-4e6d16426787\/Chess_board_and_pieces_at_Colony_Club_aboard_Radiance_Of_The_Seas.jpg","orig_name":"Chess_board_and_pieces_at_Colony_Club_aboard_Radiance_Of_The_Seas.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":116,"attachment_id":32728,"task_group_id":106,"created_by":1000,"title":"14","description":"","created_at":"2026-06-23 10:00:14","updated_at":"2026-06-23 10:00:14","file_url":"\u9633\u5149\u623f","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32728,"key":32728,"name":"9e3d5c00-dcf0-3c5f-84c8-e8b6cf03f495","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/9e3d5c00-dcf0-3c5f-84c8-e8b6cf03f495\/business-success.jpg","orig_name":"business-success.jpg"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0},{"id":115,"attachment_id":32727,"task_group_id":106,"created_by":1000,"title":"13","description":"","created_at":"2026-06-23 09:59:56","updated_at":"2026-06-23 09:59:56","file_url":"\u653e\u7684\u5730\u65b9","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"unreadComments":null,"attachment":{"id":32727,"key":32727,"name":"bba0c964-cb0f-3ee5-b6c1-8c002f4e003b","extension":"png","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/bba0c964-cb0f-3ee5-b6c1-8c002f4e003b\/blue_bokeh_by_creativewebsites-d5qhvhn.png","orig_name":"blue_bokeh_by_creativewebsites-d5qhvhn.png"},"commentCount":null,"taskGroup":{"id":106,"key":106,"name":"2020\u5e742\u6708\u5f00\u53d1\u90e8\u4efb\u52a1","client_id":982,"head_of":1000,"status":0,"isHeadOf":{"id":612,"task_group_id":106,"user_id":1000}},"can_update":true,"can_delete":true,"unread":0}],"pagenation":{"totalcount":32,"thispage":2,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.104.40.22","ua":"jinchangxiao\/2.3.157 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-23 15:00:59', 109036032) RETURNING "id"

[+] Explain