ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a3bd02552e57: POST https://beta.jinchangxiao.com/v2/task/list-group at 2026-06-24 08:40:05 pm by 117.176.187.29

Database Queries

总计27条数据
TimeDurationTypeQuery
  
20:40:05.3451.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'

[+] Explain
20:40:05.3480.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
20:40:05.3563.3 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 ("thu"."department_id"='10') AND ("thrs"."user_id"='1000') AND ((lower(client.name) LIKE '%bug%') OR ("client"."pinyin_shortcut" LIKE '%bug%') OR (lower(s.title) LIKE '%bug%') OR (lower(s.description) LIKE '%bug%')) GROUP BY "s"."id" ORDER BY "s"."created_at" DESC) "c"

[+] Explain
20:40:05.3602.9 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 ("thu"."department_id"='10') AND ("thrs"."user_id"='1000') AND ((lower(client.name) LIKE '%bug%') OR ("client"."pinyin_shortcut" LIKE '%bug%') OR (lower(s.title) LIKE '%bug%') OR (lower(s.description) LIKE '%bug%')) GROUP BY "s"."id" ORDER BY "s"."created_at" DESC LIMIT 10

[+] Explain
20:40:05.3640.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1000) AND ("task_group_id"=30)

[+] Explain
20:40:05.3640.4 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

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

[+] Explain
20:40:05.36637.8 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=102) AND ("object_id"=30) GROUP BY "object_id"

[+] Explain
20:40:05.40433.1 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"=30) GROUP BY "object_id"

[+] Explain
20:40:05.4381.6 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"=30) GROUP BY "remain_task"."task_group_id"

[+] Explain
20:40:05.4400.6 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

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

[+] Explain
20:40:05.4420.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
20:40:05.4431.0 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"=30 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
20:40:05.4450.6 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5030, 5016, 1001, 5029, 5064)

[+] Explain
20:40:05.4460.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064, 5029, 5016, 5030))

[+] Explain
20:40:05.4460.8 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"=30 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
20:40:05.4480.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

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

[+] Explain
20:40:05.4490.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=30

[+] Explain
20:40:05.4490.4 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5030, 1001, 1000, 5029, 5016, 5064)

[+] Explain
20:40:05.4500.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 5064, 5029, 5016, 5030))

[+] Explain
20:40:05.4510.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=30

[+] Explain
20:40:05.4510.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

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

[+] Explain
20:40:05.4520.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=30)

[+] Explain
20:40:05.4592.1 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-group', '{"TaskGroupSearch":{"department_id":"10","filter":"","head_of":"1000","keyword":"Bug","status":""},"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","posttime":"1782304768","token":"955c76b1ee2d0536071fec355225f82b","version_code":"1160"}', '{"code":200,"data":{"list":[{"id":30,"title":"2018\u5e7425\u5468\u5f00\u53d1\u4efb\u52a1","description":"\u672c\u5468\u4e3b\u8981\u4efb\u52a1\uff1a\napp bug\u4fee\u6539\n\u5185\u5bb9\u5e73\u53f0\u8bbe\u8ba1\u4e0e\u89c4\u5212","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-22 18:00:00","completed_at":"2018-11-09 11:15:57","created_by":1000,"created_at":"2018-06-15 18:21:31","updated_at":"2018-11-09 11:15:57","situation":null,"start_at":"","project_id":null,"complete_description":null,"progress":60,"weight":100,"remain":"-2924 days -02:40:05.360949","client":null,"isHeadOf":{"id":9,"task_group_id":30,"user_id":1000},"headOf":{"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"}},"commentCount":{"object_id":30,"comment":3},"unreadComments":null,"remainCount":{"task_group_id":30,"remain":6},"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"}},"taskGroupHeadOfRelationships":[{"user_id":1000,"task_group_id":30,"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"}}}],"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":5029,"key":5029,"name":"\u8c2d\u660e\u661f","sex":"M","avatar":{"id":37,"user_id":5029,"name":"\/files\/cdn\/a57be577deb434\/avatar\/553f1da6-8573-3f5f-9e98-686b018fcf1a.jpg"}},{"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":5030,"key":5030,"name":"\u4e01\u6842\u987a","sex":"M","avatar":{"id":30,"user_id":5030,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d0b4f2f-938d-3b41-a671-9d73162cbc45.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"}}],"tasks":[{"id":234,"task_group_id":30,"title":"\u6d4b\u8bd5","description":"","client_id":null,"head_of":1001,"status":1,"target_completed_at":"","completed_at":"2018-06-20 17:51:26","created_by":1001,"created_at":"2018-06-20 17:51:17","updated_at":"2018-06-20 17:51:26","is_important":0,"complete_description":null,"weight":0,"tree_path":"234","progress":100,"start_at":"","end_at":"","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":236,"task_group_id":30,"title":"\u5ba2\u6237\u4fe1\u606f\u91cc\u52a0\uff0c\u4efb\u52a1\u5217\u8868\u3002","description":"","client_id":null,"head_of":1001,"status":2,"target_completed_at":"2018-06-22 18:00:00","completed_at":"","created_by":1001,"created_at":"2018-06-21 22:15:34","updated_at":"2018-11-09 09:41:07","is_important":0,"complete_description":null,"weight":0,"tree_path":"236","progress":0,"start_at":"2018-06-21 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":215,"task_group_id":30,"title":"\u5185\u5bb9\u53d1\u5e03\u7ba1\u7406\u7cfb\u7edf\u67b6\u6784\u8bbe\u8ba1","description":"","client_id":null,"head_of":1000,"status":2,"target_completed_at":"2018-06-22 18:00:00","completed_at":"","created_by":1000,"created_at":"2018-06-19 08:04:09","updated_at":"2018-06-19 08:04:09","is_important":0,"complete_description":null,"weight":0,"tree_path":"215","progress":0,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":241,"task_group_id":30,"title":"\u5f85\u529e\u4e8b\u9879\uff0c\u5982\u679c\u8bbe\u7f6e\u4e86\u63d0\u9192\u65f6\u95f4\uff0c\u8981\u5728\u5217\u8868\u9875\uff0c\u663e\u793a\u3002","description":"","client_id":null,"head_of":1001,"status":2,"target_completed_at":"2018-06-22 18:00:00","completed_at":"","created_by":1001,"created_at":"2018-06-21 22:33:08","updated_at":"2018-11-09 09:41:07","is_important":0,"complete_description":null,"weight":0,"tree_path":"241","progress":0,"start_at":"2018-06-21 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":238,"task_group_id":30,"title":"\u641c\u7d22\u4f18\u5316","description":"","client_id":null,"head_of":1001,"status":2,"target_completed_at":"2018-06-22 18:00:00","completed_at":"","created_by":1001,"created_at":"2018-06-21 22:19:03","updated_at":"2018-11-09 09:41:08","is_important":0,"complete_description":null,"weight":0,"tree_path":"238","progress":0,"start_at":"2018-06-21 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":237,"task_group_id":30,"title":"\u5f85\u529e\u4e8b\u9879\u52a0\uff0c\u79c1\u4eba\uff0c\u5171\u4eab\u3002","description":"","client_id":null,"head_of":1001,"status":2,"target_completed_at":"2018-06-22 18:00:00","completed_at":"","created_by":1001,"created_at":"2018-06-21 22:16:09","updated_at":"2018-11-09 09:41:07","is_important":0,"complete_description":null,"weight":0,"tree_path":"237","progress":0,"start_at":"2018-06-21 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":235,"task_group_id":30,"title":"\u7edf\u8ba1\u5206\u6790\u52a0\u9500\u552e\u6d88\u8017\u5de5\u5206\u3002","description":"","client_id":null,"head_of":1001,"status":2,"target_completed_at":"2018-06-22 18:00:00","completed_at":"","created_by":1001,"created_at":"2018-06-21 22:14:59","updated_at":"2018-10-22 14:42:53","is_important":0,"complete_description":null,"weight":0,"tree_path":"235","progress":0,"start_at":"2018-06-21 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":216,"task_group_id":30,"title":"\u5347\u7ea7\u5b89\u8054\u901a\u7f51\u7ad9","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-20 18:00:00","completed_at":"2018-06-21 19:27:54","created_by":1000,"created_at":"2018-06-19 08:04:45","updated_at":"2018-06-21 19:27:54","is_important":0,"complete_description":null,"weight":0,"tree_path":"216","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-20 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":233,"task_group_id":30,"title":"\u6d4b\u8bd5","description":"","client_id":null,"head_of":1001,"status":1,"target_completed_at":"2018-06-22 15:15:00","completed_at":"2018-11-09 11:29:36","created_by":1001,"created_at":"2018-06-20 15:25:22","updated_at":"2018-11-09 11:29:36","is_important":0,"complete_description":null,"weight":0,"tree_path":"233","progress":100,"start_at":"2018-06-20 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":218,"task_group_id":30,"title":"\u4fee\u6539\u6709\u6548\u671f\u5230\u4e09\u4e2a\u6708","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-19 18:00:00","completed_at":"2018-06-19 18:20:35","created_by":1000,"created_at":"2018-06-19 08:57:07","updated_at":"2018-06-19 18:20:35","is_important":0,"complete_description":null,"weight":0,"tree_path":"218","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-19 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":219,"task_group_id":30,"title":"\u521d\u59cb\u5316\u201c\u670d\u52a1\u76ee\u5f55\u201d\u6570\u636e","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-19 18:00:00","completed_at":"2018-06-19 13:24:16","created_by":1000,"created_at":"2018-06-19 09:23:21","updated_at":"2018-06-19 13:24:16","is_important":0,"complete_description":null,"weight":0,"tree_path":"219","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-19 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":213,"task_group_id":30,"title":"\u5347\u7ea7\u6b23\u6cc9\u7f51\u7ad9\u4ee3\u7801","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-19 18:00:00","completed_at":"2018-06-19 18:20:33","created_by":1000,"created_at":"2018-06-19 08:02:47","updated_at":"2018-06-19 18:20:33","is_important":0,"complete_description":null,"weight":0,"tree_path":"213","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-19 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":217,"task_group_id":30,"title":"\u5347\u7ea7\u5b89\u8054\u901a\u624b\u673a\u5e94\u7528","description":"","client_id":null,"head_of":5030,"status":1,"target_completed_at":"2018-06-19 18:00:00","completed_at":"2018-06-19 18:04:57","created_by":1000,"created_at":"2018-06-19 08:05:39","updated_at":"2018-06-19 18:04:57","is_important":0,"complete_description":null,"weight":0,"tree_path":"217","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-19 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":214,"task_group_id":30,"title":"\u5347\u7ea7\u65e5\u4fe1\u7f51\u7ad9","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-19 18:00:00","completed_at":"2018-06-19 18:20:34","created_by":1000,"created_at":"2018-06-19 08:03:11","updated_at":"2018-06-19 18:20:34","is_important":0,"complete_description":null,"weight":0,"tree_path":"214","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-19 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null},{"id":242,"task_group_id":30,"title":"\u589e\u52a0\u6b23\u6cc9\u8d26\u53f7\u6570\u5230200","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-22 18:00:00","completed_at":"2018-06-22 10:42:48","created_by":1000,"created_at":"2018-06-22 09:08:25","updated_at":"2018-06-22 10:42:48","is_important":0,"complete_description":null,"weight":0,"tree_path":"242","progress":100,"start_at":"2018-06-22 00:00:00","end_at":"2018-06-22 00:00:00","parent_id":null,"is_end_out":null,"is_start_out":null,"is_child_end_out":null,"is_child_start_out":null,"end_out_value":null,"start_out_value":null,"child_end_out_value":null,"child_start_out_value":null}],"remain_time":"","target_completed_at_display":"","unread":0,"can_update":true,"can_delete":true,"can_complete":false,"can_stop":false,"can_recover":true,"bgcolor":"#21943A","status_display":"\u5df2\u5b8c\u6210","overdue_task":0}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"117.176.187.29","ua":"jinchangxiao\/2.3.157 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-24 20:40:05', 117755136) RETURNING "id"

[+] Explain