ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3ba4e4613a1: POST https://beta.jinchangxiao.com/v2/task/of-client at 2026-06-24 05:35:32 pm by 110.81.108.78

Database Queries

总计29条数据
TimeDurationTypeQuery
  
17:35:32.4046.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'

[+] Explain
17:35:32.4171.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
17:35:32.4192.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='3459') AND ("deleted"=FALSE)

[+] Explain
17:35:32.4378.5 msSELECTSELECT COUNT(*) FROM (SELECT s.*, COALESCE(s.weight, 0) AS weight, COALESCE(s.progress, 0) AS progress, target_completed_at - now() as remain FROM "a57be577deb434"."tbl_task_groups" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_task_group_user_relationships" "turs" ON s.id = turs.task_group_id LEFT JOIN "a57be577deb434"."tbl_task_group_head_of_relationships" "thrs" ON s.id = thrs.task_group_id LEFT JOIN "a57be577deb434"."tbl_users" "thu" ON thu.id = thrs.user_id WHERE (true) AND ("s"."client_id"=3459) GROUP BY "s"."id" ORDER BY "s"."created_at" DESC) "c"

[+] Explain
17:35:32.4476.7 msSELECTSELECT s.*, COALESCE(s.weight, 0) AS weight, COALESCE(s.progress, 0) AS progress, target_completed_at - now() as remain FROM "a57be577deb434"."tbl_task_groups" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_task_group_user_relationships" "turs" ON s.id = turs.task_group_id LEFT JOIN "a57be577deb434"."tbl_task_group_head_of_relationships" "thrs" ON s.id = thrs.task_group_id LEFT JOIN "a57be577deb434"."tbl_users" "thu" ON thu.id = thrs.user_id WHERE (true) AND ("s"."client_id"=3459) GROUP BY "s"."id" ORDER BY "s"."created_at" DESC LIMIT 10

[+] Explain
17:35:32.4552.5 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3459

[+] Explain
17:35:32.4580.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1000) AND ("task_group_id"=203)

[+] Explain
17:35:32.4580.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:35:32.4590.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
17:35:32.45941.0 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=102) AND ("object_id"=203) GROUP BY "object_id"

[+] Explain
17:35:32.50126.0 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=102) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=203) GROUP BY "object_id"

[+] Explain
17:35:32.5271.5 msSELECTSELECT "remain_task"."task_group_id", count(*) as remain FROM "a57be577deb434"."tbl_tasks" "remain_task" WHERE ("status" != 1) AND (NOT EXISTS (SELECT 1 FROM a57be577deb434.tbl_tasks child_task WHERE child_task.parent_id = remain_task.id)) AND ("task_group_id"=203) GROUP BY "remain_task"."task_group_id"

[+] Explain
17:35:32.5290.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:35:32.5300.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
17:35:32.5300.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
17:35:32.5310.6 msSELECTSELECT "user_id", "task_group_id" FROM "a57be577deb434"."tbl_task_group_user_relationships" "c" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "c"."user_id" WHERE "c"."task_group_id"=203 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

[+] Explain
17:35:32.5320.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5016, 1001, 5461, 5064)

[+] Explain
17:35:32.5330.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064, 5250, 5016, 5461))

[+] Explain
17:35:32.5330.5 msSELECTSELECT "user_id", "task_group_id" FROM "a57be577deb434"."tbl_task_group_head_of_relationships" "c" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "c"."user_id" WHERE "c"."task_group_id"=203 ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

[+] Explain
17:35:32.5340.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5016, 1001, 5461, 5064)

[+] Explain
17:35:32.5350.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064, 5250, 5016, 5461))

[+] Explain
17:35:32.5350.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=203

[+] Explain
17:35:32.5360.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 1001, 5064, 5250, 5016, 5461)

[+] Explain
17:35:32.5360.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064, 5250, 5016, 5461))

[+] Explain
17:35:32.5370.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=203

[+] Explain
17:35:32.5370.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5016, 1001, 5461, 5064)

[+] Explain
17:35:32.5380.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064, 5250, 5016, 5461))

[+] Explain
17:35:32.5381.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=203)

[+] Explain
17:35:32.5472.3 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, 0, 274, 'v2/task/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"0","version_code":"274","id":"3459","page":"1","token":"60ceed2f804d04c41bdcb0f45b3cfdd6","posttime":"1782293732","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":203,"title":"\u9879\u76ee","description":"","client_id":3459,"head_of":1001,"status":0,"target_completed_at":"2026-06-07 00:00:00","completed_at":"","created_by":1001,"created_at":"2026-06-03 10:44:20","updated_at":"2026-06-24 17:30:51","situation":"\u6d4b\u8bd5","start_at":"2026-06-04 00:00:00","project_id":null,"complete_description":null,"progress":75,"weight":10,"remain":"-17 days -17:35:32.453298","client":{"id":3459,"key":3459,"name":"\u6d4b\u8bd5","sales_rep":null},"isHeadOf":{"id":616,"task_group_id":203,"user_id":1000},"headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"commentCount":{"object_id":203,"comment":1},"unreadComments":null,"remainCount":{"task_group_id":203,"remain":6},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"taskGroupHeadOfRelationships":[{"user_id":1000,"task_group_id":203,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}}},{"user_id":5250,"task_group_id":203,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}},{"user_id":5016,"task_group_id":203,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}},{"user_id":1001,"task_group_id":203,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"user_id":5461,"task_group_id":203,"user":{"id":5461,"key":5461,"name":"\u8096\u5e05","sex":"M","avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"}}},{"user_id":5064,"task_group_id":203,"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}}],"project":null,"taskGroupUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5461,"key":5461,"name":"\u8096\u5e05","sex":"M","avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"}}],"taskGroupHeads":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5461,"key":5461,"name":"\u8096\u5e05","sex":"M","avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"}}],"tasks":[{"id":1669,"task_group_id":203,"title":"6","description":null,"client_id":null,"head_of":1001,"status":1,"target_completed_at":"","completed_at":"2026-06-12 17:52:40","created_by":1001,"created_at":"2026-06-04 13:03:14","updated_at":"2026-06-12 17:52:40","is_important":0,"complete_description":"Ok","weight":null,"tree_path":"1669","progress":100,"start_at":"","end_at":"","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1668,"task_group_id":203,"title":"5","description":null,"client_id":null,"head_of":5250,"status":0,"target_completed_at":"","completed_at":"","created_by":1001,"created_at":"2026-06-04 13:02:56","updated_at":"2026-06-04 13:02:56","is_important":0,"complete_description":null,"weight":null,"tree_path":"1668","progress":0,"start_at":"","end_at":"","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1666,"task_group_id":203,"title":"\u6d4b\u8bd5","description":null,"client_id":null,"head_of":1001,"status":1,"target_completed_at":"","completed_at":"2026-06-04 13:00:07","created_by":1001,"created_at":"2026-06-04 12:59:45","updated_at":"2026-06-04 13:00:07","is_important":0,"complete_description":null,"weight":null,"tree_path":"1666","progress":100,"start_at":"2026-06-04 00:00:00","end_at":"2026-06-07 00:00:00","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1670,"task_group_id":203,"title":"\u6d4b\u8bd5","description":null,"client_id":null,"head_of":1000,"status":1,"target_completed_at":"","completed_at":"2026-06-06 11:06:03","created_by":1001,"created_at":"2026-06-04 16:03:58","updated_at":"2026-06-06 11:06:03","is_important":0,"complete_description":"\u56de\u5230\u5bb6","weight":null,"tree_path":"1670","progress":100,"start_at":"","end_at":"","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1658,"task_group_id":203,"title":"\u6d4b\u8bd5","description":"","client_id":null,"head_of":1001,"status":1,"target_completed_at":"","completed_at":"2026-06-04 13:00:47","created_by":1001,"created_at":"2026-06-03 10:45:04","updated_at":"2026-06-04 13:00:47","is_important":0,"complete_description":null,"weight":10,"tree_path":"1658","progress":100,"start_at":"2026-06-02 00:00:00","end_at":"2026-06-02 00:00:00","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1664,"task_group_id":203,"title":"\u6492\u5730\u65b9\u662f\u5426","description":"","client_id":null,"head_of":1001,"status":1,"target_completed_at":"","completed_at":"2026-06-04 13:01:34","created_by":1001,"created_at":"2026-06-03 22:43:47","updated_at":"2026-06-04 13:01:34","is_important":0,"complete_description":null,"weight":0,"tree_path":"1664","progress":100,"start_at":"2026-06-01 00:00:00","end_at":"2026-06-01 00:00:00","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1671,"task_group_id":203,"title":"tarter","description":null,"client_id":null,"head_of":1000,"status":1,"target_completed_at":"","completed_at":"2026-06-06 11:06:17","created_by":1001,"created_at":"2026-06-04 16:49:37","updated_at":"2026-06-06 11:06:17","is_important":0,"complete_description":"\u5357\u65b9\u57fa\u91d1","weight":null,"tree_path":"1671","progress":100,"start_at":"","end_at":"","parent_id":null,"is_end_out":false,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":1667,"task_group_id":203,"title":"4","description":null,"client_id":null,"head_of":1001,"status":0,"target_completed_at":"","completed_at":"","created_by":1001,"created_at":"2026-06-04 13:02:36","updated_at":"2026-06-04 13:02:36","is_important":0,"complete_description":null,"weight":null,"tree_path":"1667","progress":0,"start_at":"2026-06-04 00:00:00","end_at":"2026-06-30 00:00:00","parent_id":null,"is_end_out":true,"is_start_out":false,"is_child_end_out":false,"is_child_start_out":false,"end_out_value":23,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null}],"remain_time":"\u8d85\u65f6","target_completed_at_display":"","unread":0,"can_update":true,"can_delete":true,"can_complete":true,"can_stop":true,"can_recover":false,"bgcolor":"#FF7300","status_display":"\u8fdb\u884c\u4e2d","overdue_task":3}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"110.81.108.78","ua":"jinchangxiao\/2.3.174 (XiaomiMi 10; Android 13)"}', FALSE, '2026-06-24 17:35:32', 146973184) RETURNING "id"

[+] Explain