ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3a361b2c7a2: POST https://beta.jinchangxiao.com/v2/task/list-file at 2026-06-23 03:30:35 pm by 39.156.194.178

Database Queries

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

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

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

[+] Explain
15:30:35.1930.9 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:30:35.1940.8 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

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

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

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

[+] Explain
15:30:35.19823.2 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 (134, 133, 132, 131, 130, 129, 128, 127, 126, 125)) GROUP BY "object_id"

[+] Explain
15:30:35.2220.5 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32746, 32745, 32744, 32743, 32742, 32741, 32740, 32739, 32738, 32737)

[+] Explain
15:30:35.22234.6 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=103) AND ("object_id" IN (134, 133, 132, 131, 130, 129, 128, 127, 126, 125)) GROUP BY "object_id"

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

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

[+] Explain
15:30:35.2672.9 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, 6, 177, 'v2/task/list-file', '{"task_group_id":"106","page":"1","pagesize":"10","posttime":"1782199834","access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"6","version_code":"177","token":"5a9dc6e566882f42a19e21647ca9fd6f"}', '{"code":200,"data":{"list":[{"id":134,"attachment_id":32746,"task_group_id":106,"created_by":1000,"title":"32","description":"","created_at":"2026-06-23 10:05:21","updated_at":"2026-06-23 10:05:21","file_url":"\u5404\u4f4d\u4e0e\u4ed6\u4eba\u4e00\u540c","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":32746,"key":32746,"name":"a577c4f3-a832-3ae4-aa58-93dc121cf652","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/a577c4f3-a832-3ae4-aa58-93dc121cf652\/website-banner-white-river-business-specialists.jpg","orig_name":"website-banner-white-river-business-specialists.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":133,"attachment_id":32745,"task_group_id":106,"created_by":1000,"title":"31","description":"","created_at":"2026-06-23 10:05:04","updated_at":"2026-06-23 10:05:04","file_url":"\u8303\u5fb7\u8428\u7684\u6492","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":32745,"key":32745,"name":"8b9f0577-2fa7-3342-aae9-0bcc0437a171","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/8b9f0577-2fa7-3342-aae9-0bcc0437a171\/wallup-26387.jpg","orig_name":"wallup-26387.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":132,"attachment_id":32744,"task_group_id":106,"created_by":1000,"title":"30","description":"","created_at":"2026-06-23 10:04:49","updated_at":"2026-06-23 10:04:49","file_url":"\u7ed9\u5bf9\u65b9\u597d\u53cb","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":32744,"key":32744,"name":"f1ec387f-c3a0-3e7d-9e35-6739051489f7","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/f1ec387f-c3a0-3e7d-9e35-6739051489f7\/wallup-5989.jpg","orig_name":"wallup-5989.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":131,"attachment_id":32743,"task_group_id":106,"created_by":1000,"title":"29","description":"","created_at":"2026-06-23 10:04:35","updated_at":"2026-06-23 10:04:35","file_url":"\u8303\u5fb7\u8428","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":32743,"key":32743,"name":"829616d1-230c-3705-b7ce-4607a08202f2","extension":"png","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/829616d1-230c-3705-b7ce-4607a08202f2\/ubuntu_tech_wallpaper_by_indigo196.png","orig_name":"ubuntu_tech_wallpaper_by_indigo196.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":130,"attachment_id":32742,"task_group_id":106,"created_by":1000,"title":"28","description":"","created_at":"2026-06-23 10:04:21","updated_at":"2026-06-23 10:04:21","file_url":"\u5bbe\u9986\u996d\u5e97","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":32742,"key":32742,"name":"9c321469-4c1b-33a3-8334-012374e8a181","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/9c321469-4c1b-33a3-8334-012374e8a181\/the-future.jpg","orig_name":"the-future.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":129,"attachment_id":32741,"task_group_id":106,"created_by":1000,"title":"27","description":"","created_at":"2026-06-23 10:04:07","updated_at":"2026-06-23 10:04:07","file_url":"\u8303\u5fb7\u8428","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":32741,"key":32741,"name":"d400b5ae-2f8b-3be6-9ed4-9b862a19396a","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/d400b5ae-2f8b-3be6-9ed4-9b862a19396a\/th (1).jpg","orig_name":"th (1).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":128,"attachment_id":32740,"task_group_id":106,"created_by":1000,"title":"26","description":"","created_at":"2026-06-23 10:03:48","updated_at":"2026-06-23 10:03:48","file_url":"\u521a\u597d\u501f\u53e4\u8bbd\u4eca","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":32740,"key":32740,"name":"8f8307b6-d0af-3235-9ec9-7ebd01d0e38c","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/8f8307b6-d0af-3235-9ec9-7ebd01d0e38c\/texture_349_by_sirius_sdz-d6g5hx5.jpg","orig_name":"texture_349_by_sirius_sdz-d6g5hx5.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":127,"attachment_id":32739,"task_group_id":106,"created_by":1000,"title":"25","description":"","created_at":"2026-06-23 10:03:26","updated_at":"2026-06-23 10:03:26","file_url":"\u4ed6\u7684\u65b9\u6cd5","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":32739,"key":32739,"name":"eec4e98c-4402-3af4-a614-6f91007c0fbf","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/eec4e98c-4402-3af4-a614-6f91007c0fbf\/texture_328_by_sirius_sdz-d6665gz.jpg","orig_name":"texture_328_by_sirius_sdz-d6665gz.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":126,"attachment_id":32738,"task_group_id":106,"created_by":1000,"title":"24","description":"","created_at":"2026-06-23 10:03:05","updated_at":"2026-06-23 10:03:05","file_url":"\u5feb\u56de\u590d","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":32738,"key":32738,"name":"417e9e9e-c985-345a-aa1c-4311a025183e","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/417e9e9e-c985-345a-aa1c-4311a025183e\/texture_303_by_sirius_sdz-d5l5p6b.jpg","orig_name":"texture_303_by_sirius_sdz-d5l5p6b.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":125,"attachment_id":32737,"task_group_id":106,"created_by":1000,"title":"23","description":"","created_at":"2026-06-23 10:02:51","updated_at":"2026-06-23 10:02:51","file_url":"\u6050\u614c\u611f","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":32737,"key":32737,"name":"f9dcb65a-4cdd-3b70-a631-4fa87eb052de","extension":"jpg","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/f9dcb65a-4cdd-3b70-a631-4fa87eb052de\/Sydney_City_Business_District.jpg","orig_name":"Sydney_City_Business_District.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}],"pagenation":{"totalcount":32,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/1.0.41 (HUAWEI Mate 60 BRA-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-06-23 15:30:35', 83860992) RETURNING "id"

[+] Explain