ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a28196ce0006: POST https://beta.jinchangxiao.com/v2/task/list-group at 2026-06-09 09:47:24 pm by 117.176.186.63

Performance Profiling

Total processing time: 62 ms; Peak memory: 5.527 MB. Show Profiling Timeline

总计28条数据
TimeDurationCategoryInfo
  
21:47:24.92720.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=102) AND ("object_id" IN (43, 13, 12)) GROUP BY "object_id"
21:47:24.94718.4 msyii\db\Command::querySELECT "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" IN (43, 13, 12)) GROUP BY "object_id"
21:47:24.9761.7 msyii\db\Command::queryINSERT 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, 1159, 'v2/task/list-group', '{"TaskGroupSearch":{"department_id":"9","filter":"my","head_of":"","status":""},"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","posttime":"1781012864","token":"96321eb960a70e4a0f816bc42ce8514e","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":43,"title":"OMS\u8f6f\u8457\u7533\u8bf7","description":"\u8ba1\u5212\uff1a\r\n7\u670830\u65e5-8\u67083\u65e5\r\n\u5408\u540c\u7b7e\u8ba2\uff08\u5ba1\u5408\u540c\uff0c\u76d6\u7ae0\uff09\u5408\u540c\u989d\uff1a600\u5143\r\n\u652f\u4ed8\u9884\u4ed8\u6b3e\uff08\u8bf7\u6b3e\u3001\u4ed8\u6b3e\uff09\uff1a120\u5143\r\n\u8f6f\u8457\u6750\u6599\u51c6\u5907\uff08\u4ee3\u7801\u524d30\u3001\u4ee3\u7801\u540e30\u3001\u64cd\u4f5c\u8bf4\u660e\u3001\u8425\u4e1a\u6267\u7167\uff09\r\n\r\n9\u670824\u65e5-9\u670828\u65e5\r\n\u8bc1\u4e66\u6536\u53d6\r\n\u652f\u4ed8\u5c3e\u6b3e\uff1a480\u5143\r\n\u53d1\u7968\r\n\u8f6f\u8457\u5907\u6848\r\n","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-10-10 18:00:00","completed_at":"2018-10-08 16:19:51","created_by":5063,"created_at":"2018-07-30 10:43:33","updated_at":"2018-11-07 11:45:37","situation":"\u5df2\u9a8c\u6536","start_at":"","project_id":null,"complete_description":null,"progress":null,"weight":100,"remain":"-2799 days -03:47:24.925131","client":null,"isHeadOf":null,"headOf":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}},"commentCount":{"object_id":43,"comment":3},"unreadComments":null,"remainCount":null,"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","department_id":9,"avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"taskGroupHeadOfRelationships":[{"user_id":5063,"task_group_id":43,"user":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}}}],"project":null,"taskGroupUsers":[{"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":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":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}}],"taskGroupHeads":[{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}}],"tasks":[{"id":374,"task_group_id":43,"title":"\uff085\uff09\u8f6f\u8457\u7533\u8bf7\u4e66\u3001\u516c\u53f8\u8425\u4e1a\u6267\u7167\u76d6\u7ae0\u90ae\u5bc4","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-08-08 13:00:00","completed_at":"2018-08-06 17:44:19","created_by":5063,"created_at":"2018-07-30 10:51:50","updated_at":"2018-08-06 17:44:19","is_important":0,"complete_description":null,"weight":0,"tree_path":"374","progress":100,"start_at":"2018-07-30 00:00:00","end_at":"2018-08-08 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":370,"task_group_id":43,"title":"\uff081\uff09\u5408\u540c\u7b7e\u7f72\r\n","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-08-01 13:00:00","completed_at":"2018-07-31 11:13:30","created_by":5063,"created_at":"2018-07-30 10:44:32","updated_at":"2018-07-31 11:13:30","is_important":0,"complete_description":null,"weight":0,"tree_path":"370","progress":100,"start_at":"2018-07-30 00:00:00","end_at":"2018-08-01 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":372,"task_group_id":43,"title":"\uff083\uff09\u4ee3\u7801\u524d35\u9875\uff1b\r\n\u4ee3\u7801\u540e35\u9875\uff1b\r\n\u4ee3\u7801\u603b\u884c\u7edf\u8ba1\uff1b\r\n\u8f6f\u4ef6\u8fd0\u884c\u7684\u8f6f\/\u786c\u4ef6\u73af\u5883\uff1b\r\n\u7f16\u7a0b\u8bed\u8a00;","description":"\u672c\u5468\u4e94\u6c47\u603b\u6750\u6599","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-08-03 18:00:00","completed_at":"2018-07-31 18:13:38","created_by":5063,"created_at":"2018-07-30 10:48:32","updated_at":"2018-07-31 18:13:38","is_important":0,"complete_description":null,"weight":0,"tree_path":"372","progress":100,"start_at":"2018-07-30 00:00:00","end_at":"2018-08-03 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":373,"task_group_id":43,"title":"\uff084\uff09\u64cd\u4f5c\u624b\u518c\u7f16\u5199\u3001\u7533\u8bf7\u4e66\u7f16\u5199","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-08-01 17:00:00","completed_at":"2018-08-01 14:19:27","created_by":5063,"created_at":"2018-07-30 10:50:17","updated_at":"2018-08-01 14:19:27","is_important":0,"complete_description":null,"weight":0,"tree_path":"373","progress":100,"start_at":"2018-07-30 00:00:00","end_at":"2018-08-01 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":371,"task_group_id":43,"title":"\uff082\uff09\u534f\u8c03\u652f\u4ed8\u9884\u4ed8\u6b3e\r\n\u5408\u540c\u603b\u989d\uff1a600\u5143\r\n\u9884\u4ed8\u6b3e\uff1a120\u5143\r\n","description":"\u4eca\u5929\u4e1c\u5ba1\u5c06\u76d6\u597d\u7ae0\u7684\u5408\u540c\u5bc4\u51fa","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-08-03 18:00:00","completed_at":"2018-08-03 15:43:43","created_by":5063,"created_at":"2018-07-30 10:46:56","updated_at":"2018-08-03 15:43:43","is_important":0,"complete_description":null,"weight":0,"tree_path":"371","progress":100,"start_at":"2018-07-30 00:00:00","end_at":"2018-08-03 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":375,"task_group_id":43,"title":"\uff086\uff09\u8f6f\u8457\u5907\u6848\u3001\u652f\u4ed8\u5c3e\u6b3e\u3001\u53d1\u7968\u63d0\u4ea4","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-10-10 18:00:00","completed_at":"2018-10-08 16:19:39","created_by":5063,"created_at":"2018-07-30 11:14:47","updated_at":"2018-10-08 16:19:39","is_important":0,"complete_description":null,"weight":0,"tree_path":"375","progress":100,"start_at":"2018-07-30 00:00:00","end_at":"2018-10-10 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},{"id":13,"title":"\u9ad8\u65b0\u6280\u672f\u8ba4\u8bc1\u8bc1\u4e66---\u91d1\u7545\u900d","description":"\u9ad8\u65b0\u6280\u672f\u8ba4\u8bc1\u8bc1\u4e66\u7533\u8bf7\r\n1.\u8bc6\u522b\u54ea\u4e9b\u4e0d\u6ee1\u8db3\r\n2.\u4e0e\u4ee3\u7406\u673a\u6784\u6c9f\u901a\uff0c\u786e\u8ba4\u4ee3\u7406\u65b9\u6848\r\n3.\u516c\u53f8\u5185\u90e8\u8c03\u6574\uff08\u6d89\u53ca\u90e8\u95e8\uff1a\u8d22\u52a1\u3001\u7814\u53d1\u3001\u9879\u76ee\u3001\u603b\u7ecf\u7406\uff09\r\n4.\u7ed3\u5408\u8f6f\u8457\uff0c\u8fbe\u6807\u540e\u5f00\u59cb\u7533\u8bf7\r\n\u98ce\u9669\uff1a\u6301\u7eed\u65f6\u95f4\u4e0d\u5b9a\uff0c\u9700\u8981\u8d44\u6e90\u6295\u5165\uff0c\u5404\u90e8\u95e8\u914d\u5408\uff0c\u8d44\u91d1\u6295\u5165\u4e0d\u786e\u5b9a","client_id":null,"head_of":5063,"status":2,"target_completed_at":"2020-05-29 18:00:00","completed_at":"2018-06-14 20:42:44","created_by":5063,"created_at":"2018-05-24 10:54:39","updated_at":"2018-06-14 20:42:44","situation":null,"start_at":"","project_id":null,"complete_description":null,"progress":null,"weight":100,"remain":"-2202 days -03:47:24.925131","client":null,"isHeadOf":null,"headOf":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}},"commentCount":null,"unreadComments":null,"remainCount":null,"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","department_id":9,"avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"taskGroupHeadOfRelationships":[{"user_id":5063,"task_group_id":13,"user":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}}}],"project":null,"taskGroupUsers":[{"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":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":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":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.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":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":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}}],"tasks":[{"id":93,"task_group_id":13,"title":"CNN\u5154\u5154\u54ed\u4e86\u6a21\u5757\u5feb\u4e50\u54c8\uff1f\u6211\u4e5f\u4e0d\u77e5\u9053\u600e\u4e48\u56de\u4e86\u5417\uff01\u6211\u5728\u4f60\u5fc3\u91cc\u662f\u600e\u4e48\u4e86\uff1f\u6211\u4eec\u8981\u5b66\u4f1a\u611f\u6069\u56de\u9988\u65b0\u987e\u5ba2\u90fd\u77e5\u9053\u7684\u662f\u6211\u6700\u597d\u662f\u7684\u4e00","description":"","client_id":null,"head_of":1001,"status":1,"target_completed_at":"","completed_at":"2018-06-13 12:41:26","created_by":1001,"created_at":"2018-06-02 07:03:11","updated_at":"2018-06-13 12:41:26","is_important":0,"complete_description":null,"weight":0,"tree_path":"93","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":59,"task_group_id":13,"title":"\u9ad8\u65b0\u6280\u672f\u8ba4\u8bc1\u6761\u4ef6\u8bc4\u4f30\r\n\u6c9f\u901a\u786e\u8ba4\u6267\u884c\u65b9\u6848","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-15 10:00:00","completed_at":"2018-06-14 20:42:18","created_by":5063,"created_at":"2018-05-24 10:58:26","updated_at":"2018-06-14 20:42:18","is_important":0,"complete_description":null,"weight":0,"tree_path":"59","progress":100,"start_at":"2018-05-24 00:00:00","end_at":"2018-06-15 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":60,"task_group_id":13,"title":"\u4e0b\u5468\u4e8c\u4e0b\u5348\u7ea6\u8c08\uff0c\u8bc4\u4f30\u9ad8\u65b0\u8ba4\u8bc1\u53ef\u884c\u6027","description":"\u9700\u8981\u66f9\u6c38\u751f\u3001\u6731\u65ed\u9896\u53c2\u52a0","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-19 18:00:00","completed_at":"2018-05-30 10:04:58","created_by":5063,"created_at":"2018-05-24 15:45:04","updated_at":"2018-05-30 10:04:58","is_important":0,"complete_description":null,"weight":0,"tree_path":"60","progress":100,"start_at":"2018-05-24 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":87,"task_group_id":13,"title":"\u6d4b\u8bd5","description":"","client_id":null,"head_of":5064,"status":1,"target_completed_at":"2018-06-03 20:00:00","completed_at":"2018-06-04 18:33:48","created_by":5064,"created_at":"2018-06-01 20:01:29","updated_at":"2018-06-04 18:33:48","is_important":0,"complete_description":null,"weight":0,"tree_path":"87","progress":100,"start_at":"2018-06-01 00:00:00","end_at":"2018-06-03 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":81,"task_group_id":13,"title":"\u51b3\u5b9a\u6279\u51c6\u8d44\u91d1\u9ad8\u65b0\u8ba4\u8bc1\u8d39\u752823000\u5143\uff0c\u5305\u542b\u5982\u4e0b\uff1a\r\n\u9ad8\u65b0\u4ee3\u7406\u8d39\uff1a12000\u5143\u3002\r\n3\u5e74\u4f1a\u8ba1\u62a5\u8868\u5ba1\u8ba1\u62a5\u544a\uff1a5000\u5143\r\n2\u5e74\u9ad8\u65b0\u4e13\u9879\u5ba1\u8ba1\u62a5\u544a\uff1a6000\u5143\r\n\u6267\u884c\u5468\u671f\uff1a\u6700\u5feb\u4e00\u5e74\u534a\u3002\r\n\u5982\u4e0d\u6279\u51c6\uff0c\u4efb\u52a1\u4e2d\u6b62\uff0c\u91ca\u653e\u6240\u6709\u8d44\u6e90\u3002","description":"","client_id":null,"head_of":1001,"status":1,"target_completed_at":"2018-06-30 18:00:00","completed_at":"2018-11-09 11:29:37","created_by":5063,"created_at":"2018-05-30 17:43:46","updated_at":"2018-11-09 11:29:37","is_important":0,"complete_description":null,"weight":0,"tree_path":"81","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-06-30 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":"#414141","status_display":"\u5df2\u4e2d\u6b62","overdue_task":0},{"id":12,"title":"\u8f6f\u4ef6\u8457\u4f5c\u6743\u7533\u8bf7\u51719\u4e2a\uff0c\u52062\u6279\uff0c\u7b2c\u4e00\u6279\u5148\u6574\u74065\u4e2a\u5df2\u5b8c\u5907\u7684\uff0c\u7b2c\u4e8c\u6279\u518d\u6574\u7406\u4e0d\u5b8c\u5907\u7684\u3002","description":"\u9700\u8981\u7533\u8bf79\u4e2a\u8f6f\u4ef6\u8457\u4f5c\u6743\r\n1.\u91d1\u7545\u900dIOS\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n2.\u91d1\u7545\u900dIOS\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n3.\u91d1\u7545\u900dIOS\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n4.\u91d1\u7545\u900dAndroid\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n5.\u91d1\u7545\u900dAndroid\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n6.\u91d1\u7545\u900dAndroid\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n7.\u91d1\u7545\u900dWeb\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n8.\u91d1\u7545\u900dWeb\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n9.\u91d1\u7545\u900dWeb\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-09-05 18:00:00","completed_at":"2018-09-10 09:29:20","created_by":5063,"created_at":"2018-05-24 10:43:29","updated_at":"2018-11-07 11:45:58","situation":"\u5df2\u9a8c\u6536","start_at":"","project_id":null,"complete_description":null,"progress":null,"weight":100,"remain":"-2834 days -03:47:24.925131","client":null,"isHeadOf":null,"headOf":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}},"commentCount":{"object_id":12,"comment":7},"unreadComments":null,"remainCount":null,"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","department_id":9,"avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"taskGroupHeadOfRelationships":[{"user_id":5063,"task_group_id":12,"user":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}}}],"project":null,"taskGroupUsers":[{"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":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":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}},{"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":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","avatar":{"id":14,"user_id":1014,"name":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.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":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":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","avatar":{"id":36,"user_id":5063,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}}],"tasks":[{"id":132,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a15\uff09\u91d1\u7545\u900dIOS\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\uff0c\u603b\u4ee3\u7801\u884c\u7edf\u8ba1\u3002 \u5728\uff08\u5e8f\u53f7\uff1a14\uff09\u5b8c\u6210\u4e4b\u540e","description":"\u9700\u8981IOS-\u4e01\u6842\u987a\u534f\u52a9\u622a\u53d6","client_id":null,"head_of":1000,"status":1,"target_completed_at":"","completed_at":"2018-06-05 18:06:46","created_by":5063,"created_at":"2018-06-05 09:13:43","updated_at":"2018-06-05 18:06:46","is_important":0,"complete_description":null,"weight":0,"tree_path":"132","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":65,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a3\uff09\u91d1\u7545\u900dWeb\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\u4ee3\u7801\u540e35\u9875\u3002 \r\n\u6bcf\u9875\u4ee3\u780150\u884c\u3002\r\n\u9700\u8981\u5728\uff08\u5e8f\u53f7\uff1a2\uff09\u5b8c\u6210\u540e\u8fdb\u884c\u622a\u4ee3\u7801","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-01 18:00:00","completed_at":"2018-05-30 11:03:18","created_by":5063,"created_at":"2018-05-28 10:51:33","updated_at":"2018-05-30 11:03:18","is_important":0,"complete_description":null,"weight":0,"tree_path":"65","progress":100,"start_at":"2018-05-28 00:00:00","end_at":"2018-06-01 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":67,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a6\uff09\u91d1\u7545\u900dWeb\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\u4ee3\u7801\u603b\u884c\u6570\u548c\u6280\u672f\u7279\u70b9\r\n","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-01 18:00:00","completed_at":"2018-06-01 20:23:43","created_by":5063,"created_at":"2018-05-28 11:03:50","updated_at":"2018-06-01 20:23:43","is_important":0,"complete_description":null,"weight":0,"tree_path":"67","progress":100,"start_at":"2018-05-28 00:00:00","end_at":"2018-06-01 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":76,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a9\uff09\u91d1\u7545\u900dWeb\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\uff0c\u603b\u4ee3\u7801\u884c\u3002\r\n\u5728\uff08\u5e8f\u53f7\uff1a7\uff09\u5b8c\u6210\u4e4b\u540e\u3002","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-01 18:00:00","completed_at":"2018-06-01 20:23:56","created_by":5063,"created_at":"2018-05-30 13:11:32","updated_at":"2018-06-01 20:23:56","is_important":0,"complete_description":null,"weight":0,"tree_path":"76","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-06-01 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":78,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a11\uff09\u91d1\u7545\u900dWeb\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u7f16\u5199\u64cd\u4f5c\u624b\u518c\uff0c\u6280\u672f\u7279\u70b9\u3002\r\n\u5728\uff08\u5e8f\u53f7\uff1a10\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-06 18:00:00","completed_at":"2018-06-05 10:13:52","created_by":5063,"created_at":"2018-05-30 13:17:57","updated_at":"2018-06-05 10:13:52","is_important":0,"complete_description":null,"weight":0,"tree_path":"78","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-06-06 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":64,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a4\uff09\u91d1\u7545\u900dWeb\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\u4ee3\u7801\u524d35\u9875\u3002\r\n\u6bcf\u9875\u4ee3\u780150\u884c\u3002\r\n\u9700\u8981\u5728\uff08\u5e8f\u53f7\uff1a2\uff09\u7ed3\u675f\u540e\u622a\u4ee3\u7801","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-01 18:00:00","completed_at":"2018-05-30 11:03:19","created_by":5063,"created_at":"2018-05-28 10:50:47","updated_at":"2018-05-30 11:03:19","is_important":0,"complete_description":null,"weight":0,"tree_path":"64","progress":100,"start_at":"2018-05-28 00:00:00","end_at":"2018-06-01 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":66,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a5\uff09\u91d1\u7545\u900dWeb\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\u4f7f\u7528\u8bf4\u660e\u4e66\r\n\u9700\u8981\u5728\uff08\u5e8f\u53f7\uff1a2\uff09\u5b8c\u6210\u540e\u518d\u8fdb\u884c\u7f16\u8f91","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-05 10:00:00","completed_at":"2018-05-30 13:04:28","created_by":5063,"created_at":"2018-05-28 10:53:11","updated_at":"2018-05-30 13:04:28","is_important":0,"complete_description":null,"weight":0,"tree_path":"66","progress":100,"start_at":"2018-05-28 00:00:00","end_at":"2018-06-05 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":75,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a8\uff09\u91d1\u7545\u900dWeb\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\u64cd\u4f5c\u624b\u518c\u7f16\u5199\uff0c\u6280\u672f\u7279\u70b9\u7f16\u5199\r\n\u5728\uff08\u5e8f\u53f7\uff1a7\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-01 18:00:00","completed_at":"2018-05-30 16:59:50","created_by":5063,"created_at":"2018-05-30 13:10:23","updated_at":"2018-05-30 16:59:50","is_important":0,"complete_description":null,"weight":0,"tree_path":"75","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-06-01 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":74,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a7\uff09\u91d1\u7545\u900dWeb\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u51c6\u5907\u5de5\u4f5c\uff1a\u6309\u7167\u4ee5\u4e0b\u529f\u80fd\u5206\u914d\u8d26\u53f7\uff0c\u6574\u4e2a\u7cfb\u7edf\u68c0\u67e5\u6d41\u7545\u6027\uff0c\u6709\u8d70\u4e0d\u901a\u7684\u53ca\u65f6\u4e0e\u7814\u53d1\u6c9f\u901a\uff0c\u4fee\u6539\u3002\u7edf\u8ba1\u5206\u6790\uff08\u8db3\u8ff9\u5730\u56fe\uff09\u3001\u5f85\u529e\u4e8b\u9879\u3001\u901a\u8baf\u5f55\u3001\u6295\u7968\u6d4b\u8bc4\u3001\u8003\u52e4\u6253\u5361\u3001\u5916\u52e4\u8bb0\u5f55\u3001\u6587\u6863\u7ba1\u7406\u3001\u5458\u5de5\u7ba1\u7406\u3001\u6d88\u606f\u901a\u77e5\r\n\u5728\uff08\u5e8f\u53f7\uff1a6\uff09\u5b8c\u6210\u4e4b\u540e","description":"\u9700\u8981\u7814\u53d1\u8f85\u52a9\u5b8c\u5584","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-05-31 18:00:00","completed_at":"2018-05-30 15:00:38","created_by":5063,"created_at":"2018-05-30 13:08:06","updated_at":"2018-05-30 15:00:38","is_important":0,"complete_description":null,"weight":0,"tree_path":"74","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-05-31 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":63,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a2\uff09\u51c6\u5907\u5de5\u4f5c\uff1a\u91d1\u7545\u900dWeb\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\u8bbe\u7f6e\u8bf4\u660e\r\n1.\t\u767b\u5f55\u754c\u9762\uff0c\u4e3b\u754c\u9762\uff0c\u529f\u80fd\u754c\u9762Logo\u3001\u516c\u53f8\u540d\u5b57\u9700\u8981\u6539\u6210\u91d1\u7545\u900d\u3002\r\n2.\t\u9700\u8981\u5e2e\u6211\u53e6\u5f00\u4e00\u4e2a\u91d1\u7545\u900d\u7684\u8d26\u6237\uff0c\u65b9\u4fbf\u622a\u56fe\u64cd\u4f5c\u3002\r\n3.\t\u6240\u6709\u754c\u9762\u4e0d\u80fd\u663e\u793a\u6709\u522b\u7684\u516c\u53f8\u3001\u673a\u6784\u3001\u96c6\u56e2\u7684\u540d\u79f0\u548c\u5546\u6807\u3002\r\n","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-05-29 18:00:00","completed_at":"2018-06-01 17:07:56","created_by":5063,"created_at":"2018-05-28 10:48:46","updated_at":"2018-06-01 17:07:56","is_important":0,"complete_description":null,"weight":0,"tree_path":"63","progress":100,"start_at":"2018-05-28 00:00:00","end_at":"2018-05-29 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":77,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a10\uff09\u91d1\u7545\u900dWeb\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u51c6\u5907\u5de5\u4f5c\u5206\u914d\u8d26\u53f7\uff0c\u5305\u542b\u529f\u80fd\uff1a\u5de5\u7a0b\u5e08\u65e5\u5fd7\u3001\u9879\u76ee\u4fe1\u606f\u3001\u552e\u524d\u8bb0\u5f55\u3001\u5b9e\u65bd\u8bb0\u5f55\u3001\u4efb\u52a1\u7ba1\u7406\u3001\u5458\u5de5\u7ba1\u7406\u3001\u6d88\u606f\u901a\u77e5\u3001\u56de\u8bbf\u8bb0\u5f55\u3001\u7edf\u8ba1\u5206\u6790\uff08\u552e\u524d\u6570\u636e\u3001\u5b9e\u65bd\u6570\u636e\uff09\uff0c\u8fc7\u7a0b\u5168\u8dd1\u901a\u3002\r\n\u5728\uff08\u5e8f\u53f7\uff1a9\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-05 18:00:00","completed_at":"2018-06-05 10:13:45","created_by":5063,"created_at":"2018-05-30 13:14:09","updated_at":"2018-06-05 10:13:45","is_important":0,"complete_description":null,"weight":0,"tree_path":"77","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-06-05 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":131,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a14\uff09\u91d1\u7545\u900dIOS\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u7f16\u5199\u64cd\u4f5c\u624b\u518c\uff0c\u6280\u672f\u7279\u70b9\u3002 \u5728\uff08\u5e8f\u53f7\uff1a13\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-07 14:00:00","completed_at":"2018-06-05 16:55:55","created_by":5063,"created_at":"2018-06-05 09:12:27","updated_at":"2018-06-05 16:55:55","is_important":0,"complete_description":null,"weight":0,"tree_path":"131","progress":100,"start_at":"2018-06-05 00:00:00","end_at":"2018-06-07 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":134,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a18\uff09\u91d1\u7545\u900dAndroid\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\uff0c\u603b\u4ee3\u7801\u884c\u7edf\u8ba1\u3002 \u5728\uff08\u5e8f\u53f7\uff1a17\uff09\u5b8c\u6210\u4e4b\u540e","description":"\u9700\u8981Android\u534f\u52a9","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-11 17:00:00","completed_at":"2018-06-05 18:06:41","created_by":5063,"created_at":"2018-06-05 09:18:35","updated_at":"2018-06-05 18:06:41","is_important":0,"complete_description":null,"weight":0,"tree_path":"134","progress":100,"start_at":"2018-06-05 00:00:00","end_at":"2018-06-11 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":230,"task_group_id":12,"title":"\uff0831\uff09\u91d1\u7545\u900dAndroid\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\n\u4ee3\u7801\u884c\u7edf\u8ba1\n\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\n\u5b8c\u6210\u6807\u51c6\uff1a\u6750\u6599\u4ea4\u4ed8\u674e\u73ca\u73ca","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-27 18:45:00","completed_at":"2018-06-21 19:28:22","created_by":5063,"created_at":"2018-06-19 18:49:56","updated_at":"2018-06-21 19:28:22","is_important":0,"complete_description":null,"weight":0,"tree_path":"230","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-27 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":224,"task_group_id":12,"title":"\uff0825\uff09\u91d1\u7545\u900dAndroid\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u4f7f\u7528\u624b\u518c\u7f16\u5199","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-21 18:30:00","completed_at":"2018-06-21 16:54:24","created_by":5063,"created_at":"2018-06-19 18:34:19","updated_at":"2018-06-21 16:54:24","is_important":0,"complete_description":null,"weight":0,"tree_path":"224","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-21 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":221,"task_group_id":12,"title":"\uff0822\uff09\u91d1\u7545\u900dIOS\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u5185\u5bb9\u6a21\u5757\u8bbe\u7f6e\uff0c\u8bd5\u901a","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-21 18:00:00","completed_at":"2018-06-21 15:24:40","created_by":5063,"created_at":"2018-06-19 18:30:33","updated_at":"2018-06-21 15:24:40","is_important":0,"complete_description":null,"weight":0,"tree_path":"221","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-21 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":79,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a12\uff09\u91d1\u7545\u900dWeb\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\uff0c\u603b\u4ee3\u7801\u884c\u7edf\u8ba1\u3002\r\n\u5728\uff08\u5e8f\u53f7\uff1a10\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-06 18:00:00","completed_at":"2018-06-07 09:19:07","created_by":5063,"created_at":"2018-05-30 13:19:28","updated_at":"2018-06-07 09:19:07","is_important":0,"complete_description":null,"weight":0,"tree_path":"79","progress":100,"start_at":"2018-05-30 00:00:00","end_at":"2018-06-06 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":135,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a17\uff09\u91d1\u7545\u900dAndroid\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u7f16\u5199\u64cd\u4f5c\u624b\u518c\uff0c\u6280\u672f\u7279\u70b9\u3002 \u5728\uff08\u5e8f\u53f7\uff1a16\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-08 18:00:00","completed_at":"2018-06-05 16:56:08","created_by":5063,"created_at":"2018-06-05 09:19:59","updated_at":"2018-06-05 16:56:08","is_important":0,"complete_description":null,"weight":0,"tree_path":"135","progress":100,"start_at":"2018-06-05 00:00:00","end_at":"2018-06-08 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":147,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a20\uff095\u4efd\u7eb8\u8d28\u7533\u8bf7\u4e66\u53ca\u8425\u4e1a\u6267\u7167\u76d6\u7ae0\u90ae\u5bc4\u3002","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-07 18:00:00","completed_at":"2018-06-07 14:38:42","created_by":5063,"created_at":"2018-06-06 17:19:00","updated_at":"2018-06-07 14:38:42","is_important":0,"complete_description":null,"weight":0,"tree_path":"147","progress":100,"start_at":"2018-06-06 00:00:00","end_at":"2018-06-07 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":228,"task_group_id":12,"title":"\uff0829\uff09\u91d1\u7545\u900dIOS\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u4ee3\u7801\u884c\u7edf\u8ba1\n\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\n\u5b8c\u6210\u6807\u51c6\uff1a\u6750\u6599\u8f6c\u4ea4\u674e\u73ca\u73ca","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-26 18:45:00","completed_at":"2018-06-21 19:28:19","created_by":5063,"created_at":"2018-06-19 18:45:23","updated_at":"2018-06-21 19:28:19","is_important":0,"complete_description":null,"weight":0,"tree_path":"228","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-26 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":222,"task_group_id":12,"title":"\uff0823\uff09\u91d1\u7545\u900dIOS\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u4f7f\u7528\u8bf4\u660e\u7f16\u5199","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-21 18:00:00","completed_at":"2018-06-21 16:53:30","created_by":5063,"created_at":"2018-06-19 18:31:20","updated_at":"2018-06-21 16:53:30","is_important":0,"complete_description":null,"weight":0,"tree_path":"222","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-21 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":225,"task_group_id":12,"title":"\uff0824\uff09\u91d1\u7545\u900dAndroid\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u4ee3\u7801\u884c\u6570\u7edf\u8ba1\r\n\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\r\n\u5b8c\u6210\u6807\u51c6\uff1a\u6750\u6599\u4ea4\u4ed8\u674e\u73ca\u73ca","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-22 18:00:00","completed_at":"2018-06-21 19:28:16","created_by":5063,"created_at":"2018-06-19 18:35:33","updated_at":"2018-06-21 19:28:16","is_important":0,"complete_description":null,"weight":0,"tree_path":"225","progress":100,"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":130,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a13\uff09\u91d1\u7545\u900dIOS\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u51c6\u5907\u5de5\u4f5c\u5206\u914d\u8d26\u53f7\uff0c\u5305\u542b\u529f\u80fd\uff1a\u5ba2\u6237\u4fe1\u606f\u3001\u4f9b\u5e94\u5546\u3001\u5458\u5de5\u7ba1\u7406\u3001\u6d88\u606f\u901a\u77e5\u3001\u8f6c\u79fb\u5ba2\u6237\u3001\u4e2a\u4eba\u4fe1\u606f\u3001\u9500\u552e\u65e5\u5fd7\u3001\u9500\u552e\u8bb0\u5f55\u3001\u9500\u552e\u5408\u540c\u3001\u91c7\u8d2d\u5408\u540c\u3001\u7edf\u8ba1\u5206\u6790\uff08\u9500\u552e\u6570\u636e\u3001\u5ba2\u6237\u5206\u6790\u3001\u5ba2\u6237\u5730\u56fe\uff09\uff0c\u8fc7\u7a0b\u5168\u8dd1\u901a\u3002 \u5728\uff08\u5e8f\u53f7\uff1a12\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-06 18:00:00","completed_at":"2018-06-05 15:13:06","created_by":5063,"created_at":"2018-06-05 09:11:28","updated_at":"2018-06-05 15:13:06","is_important":0,"complete_description":null,"weight":0,"tree_path":"130","progress":100,"start_at":"2018-06-05 00:00:00","end_at":"2018-06-06 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":133,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a16\uff09\u91d1\u7545\u900dAndroid\u7248\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u8f6f\u4ef6V1.0\uff0c\u51c6\u5907\u5de5\u4f5c\u5206\u914d\u8d26\u53f7\uff0c\u5305\u542b\u529f\u80fd\uff1a\u5ba2\u6237\u4fe1\u606f\u3001\u4f9b\u5e94\u5546\u3001\u5458\u5de5\u7ba1\u7406\u3001\u6d88\u606f\u901a\u77e5\u3001\u8f6c\u79fb\u5ba2\u6237\u3001\u4e2a\u4eba\u4fe1\u606f\u3001\u9500\u552e\u65e5\u5fd7\u3001\u9500\u552e\u8bb0\u5f55\u3001\u9500\u552e\u5408\u540c\u3001\u91c7\u8d2d\u5408\u540c\u3001\u7edf\u8ba1\u5206\u6790\uff08\u9500\u552e\u6570\u636e\u3001\u5ba2\u6237\u5206\u6790\u3001\u5ba2\u6237\u5730\u56fe\uff09\uff0c\u8fc7\u7a0b\u5168\u8dd1\u901a\u3002 \u5728\uff08\u5e8f\u53f7\uff1a15\uff09\u5b8c\u6210\u4e4b\u540e","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-08 12:00:00","completed_at":"2018-06-05 15:13:11","created_by":5063,"created_at":"2018-06-05 09:17:24","updated_at":"2018-06-05 15:13:11","is_important":0,"complete_description":null,"weight":0,"tree_path":"133","progress":100,"start_at":"2018-06-05 00:00:00","end_at":"2018-06-08 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":223,"task_group_id":12,"title":"\uff0826\uff09\u91d1\u7545\u900dIOS\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u4ee3\u7801\u884c\u6570\u7edf\u8ba1\r\n\u4ee3\u7801\u524d35\u9875\uff0c\u4ee3\u7801\u540e35\u9875\r\n\u5b8c\u6210\u6807\u51c6\uff1a\u6750\u6599\u8f6c\u7ed9\u674e\u73ca\u73ca","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-22 18:00:00","completed_at":"2018-06-21 19:28:17","created_by":5063,"created_at":"2018-06-19 18:33:21","updated_at":"2018-06-21 19:28:17","is_important":0,"complete_description":null,"weight":0,"tree_path":"223","progress":100,"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":187,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a21\uff09\u524d5\u4e2a\u8bc1\u4e66\u6536\u53d6\r\n\u626b\u63cf\u3001\u4e0a\u4f20BMS\u5907\u6848\uff0c\u539f\u4ef6\u4ea4\u7531\u8d22\u52a1\u5907\u6848\u3002","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-08-10 18:00:00","completed_at":"2018-08-10 20:03:56","created_by":5063,"created_at":"2018-06-13 11:42:12","updated_at":"2018-08-10 20:03:56","is_important":0,"complete_description":null,"weight":0,"tree_path":"187","progress":100,"start_at":"2018-06-13 00:00:00","end_at":"2018-08-10 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":226,"task_group_id":12,"title":"\uff0827\uff09\u91d1\u7545\u900dIOS\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u6a21\u5757\u8c03\u6574\uff0c\u8bd5\u901a","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-22 18:30:00","completed_at":"2018-06-21 15:24:54","created_by":5063,"created_at":"2018-06-19 18:42:24","updated_at":"2018-06-21 15:24:54","is_important":0,"complete_description":null,"weight":0,"tree_path":"226","progress":100,"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":232,"task_group_id":12,"title":"\uff0833\uff09\u540e4\u4e2a\u8f6f\u8457\u8bc1\u4e66\u6536\u53d6\uff0c\u626b\u63cf\uff0c\u4ea4\u8d22\u52a1\u5907\u6848","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-08-29 18:15:00","completed_at":"2018-08-30 11:08:32","created_by":5063,"created_at":"2018-06-19 18:54:24","updated_at":"2018-08-30 11:08:32","is_important":0,"complete_description":null,"weight":0,"tree_path":"232","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-08-29 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":142,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a19\uff09\u5f00\u53d1\u5b8c\u6210\u786e\u8ba4\u3002\r\n\u91d1\u7545\u900dIOS\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u91d1\u7545\u900dIOS\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u91d1\u7545\u900dAndroid\u7248\u529e\u516c\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u91d1\u7545\u900dAndroid\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-06-29 18:00:00","completed_at":"2018-06-21 19:28:08","created_by":5063,"created_at":"2018-06-06 13:45:22","updated_at":"2018-06-21 19:28:08","is_important":0,"complete_description":null,"weight":0,"tree_path":"142","progress":100,"start_at":"2018-06-06 00:00:00","end_at":"2018-06-29 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":227,"task_group_id":12,"title":"\uff0828\uff09\u91d1\u7545\u900dIOS\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\r\n\u4f7f\u7528\u624b\u518c\u7f16\u5199","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-22 18:30:00","completed_at":"2018-06-22 13:56:33","created_by":5063,"created_at":"2018-06-19 18:43:40","updated_at":"2018-06-22 13:56:33","is_important":0,"complete_description":null,"weight":0,"tree_path":"227","progress":100,"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":229,"task_group_id":12,"title":"\uff0830\uff09\u91d1\u7545\u900dAndroid\u7248\u9879\u76ee\u7ba1\u7406\u8f6f\u4ef6V1.0\n\u4f7f\u7528\u624b\u518c\u7f16\u5199","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-26 18:45:00","completed_at":"2018-06-22 13:56:35","created_by":5063,"created_at":"2018-06-19 18:48:00","updated_at":"2018-06-22 13:56:35","is_important":0,"complete_description":null,"weight":0,"tree_path":"229","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-26 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":231,"task_group_id":12,"title":"\uff0832\uff09\u6750\u6599\u63d0\u4ea4\u540e\uff0c\u6536\u53d6\u7533\u8bf7\u4e66\uff0c\u6253\u5370\uff0c\u76d6\u7ae0\uff0c\u90ae\u5bc4","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-06-29 18:45:00","completed_at":"2018-06-25 11:19:32","created_by":5063,"created_at":"2018-06-19 18:52:14","updated_at":"2018-06-25 11:19:32","is_important":0,"complete_description":null,"weight":0,"tree_path":"231","progress":100,"start_at":"2018-06-19 00:00:00","end_at":"2018-06-29 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":260,"task_group_id":12,"title":"\uff0834\uff09\u6536\u53d6\u8f6f\u8457\u4ee3\u7406\u53d1\u7968\uff0c\u544a\u77e5\u8d22\u52a1\u4ed8\u6b3e\u3002\r\n","description":"","client_id":null,"head_of":5063,"status":1,"target_completed_at":"2018-09-05 18:00:00","completed_at":"2018-09-10 09:29:08","created_by":5063,"created_at":"2018-06-26 13:52:19","updated_at":"2018-09-10 09:29:08","is_important":0,"complete_description":null,"weight":0,"tree_path":"260","progress":100,"start_at":"2018-06-26 00:00:00","end_at":"2018-09-05 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":58,"task_group_id":12,"title":"\uff08\u5e8f\u53f7\uff1a1\uff09\u672c\u5468\u9700\u8981\u786e\u8ba4\u8f6f\u8457\u4fe1\u606f\r\n\u9700\u8981\u7814\u53d1\u63d0\u4f9b\u786e\u8ba4\r\n","description":"","client_id":null,"head_of":1000,"status":1,"target_completed_at":"2018-05-25 18:00:00","completed_at":"2018-05-30 10:19:18","created_by":5063,"created_at":"2018-05-24 10:45:53","updated_at":"2018-05-30 10:19:18","is_important":0,"complete_description":"\u8fd9\u662f\u6211\u7684\u5b8c\u6210\u603b\u7ed3\uff0c\u54c8\u54c8\u54c8\u54c8","weight":0,"tree_path":"58","progress":100,"start_at":"2018-05-24 00:00:00","end_at":"2018-05-25 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":3,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"117.176.186.63","ua":"jinchangxiao\/2.3.156 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-09 21:47:24', 58497024) RETURNING "id"
21:47:24.9231.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, COALESCE(s.weight, 0) AS weight, 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" "u" ON u.id = s.head_of WHERE (true) AND ("u"."department_id"='9') AND ("turs"."user_id"=1000) GROUP BY "s"."id" ORDER BY "s"."created_at" DESC) "c"
21:47:24.9241.2 msyii\db\Command::querySELECT s.*, COALESCE(s.weight, 0) AS weight, 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" "u" ON u.id = s.head_of WHERE (true) AND ("u"."department_id"='9') AND ("turs"."user_id"=1000) GROUP BY "s"."id" ORDER BY "s"."created_at" DESC LIMIT 10
21:47:24.9720.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id" IN (43, 13, 12))
21:47:24.9190.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
21:47:24.9670.5 msyii\db\Command::querySELECT "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" IN (43, 13, 12) 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
21:47:24.9660.5 msyii\db\Command::querySELECT "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" IN (43, 13, 12)) GROUP BY "remain_task"."task_group_id"
21:47:24.9690.4 msyii\db\Command::querySELECT "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" IN (43, 13, 12) 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
21:47:24.9200.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
21:47:24.9680.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5030, 5016, 5063, 1001, 5029, 5064, 1014)
21:47:24.9260.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1000) AND ("task_group_id" IN (43, 13, 12))
21:47:24.9670.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5063)
21:47:24.9690.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5063, 5029, 1014, 5016, 5030))
21:47:24.9270.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5063)
21:47:24.9710.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5063, 5029, 1014, 5016, 5030))
21:47:24.9710.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5063, 1014, 5030, 1000, 5016, 5064, 5029)
21:47:24.9190.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:47:24.9700.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id" IN (43, 13, 12)
21:47:24.9660.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5063
21:47:24.9700.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5063
21:47:24.9700.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5063)
21:47:24.9260.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5063
21:47:24.9720.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5063)
21:47:24.9710.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id" IN (43, 13, 12)
21:47:24.9710.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5063
21:47:24.9670.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=9