ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a26be9437c08: POST https://beta.jinchangxiao.com/v2/task/get-edit-group at 2026-06-08 09:07:32 pm by 125.78.86.146

Performance Profiling

Total processing time: 86 ms; Peak memory: 5.230 MB. Show Profiling Timeline

总计32条数据
TimeDurationCategoryInfo
  
21:07:32.27031.3 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=102) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=205) GROUP BY "object_id"
21:07:32.24525.0 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=102) AND ("object_id"=205) GROUP BY "object_id"
21:07:32.3101.3 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', 1001, 7, 176, 'v2/task/get-edit-group', '{"id":"205","posttime":"1780924051","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"176","token":"4f5e2a1326e95d9e0662d70884d98554"}', '{"code":200,"data":{"model":{"id":205,"title":"\u5443\u5443\u5443\u5443\u5443","description":"","client_id":3082,"head_of":1001,"status":0,"target_completed_at":"","completed_at":"","created_by":1001,"created_at":"2026-06-08 20:02:25","updated_at":"2026-06-08 20:05:28","situation":"www","start_at":"","project_id":null,"complete_description":null,"progress":0,"weight":0,"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"}},"isHeadOf":null,"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"}},"client":{"id":3082,"key":3082,"name":"\u5317\u4eac\u6c49\u738b\u9e4f\u82af\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1013},"project":null,"taskGroupHeadOfRelationships":[{"user_id":5016,"task_group_id":205,"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"}}}],"taskGroupUsers":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},{"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":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}],"taskGroupHeads":[{"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"}}],"tasks":[],"remainCount":null,"commentCount":null,"unreadComments":null,"remain_time":"","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":0},"options":[{"key":"TaskGroups[department_id]","name":"\u90e8\u95e8","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","users":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"checked":false}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","users":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"checked":true},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"checked":false},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"checked":false},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"checked":false},{"id":5476,"key":5476,"name":"\u6768\u5dcd","department_id":1,"checked":false},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"checked":false},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","department_id":1,"checked":false}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","users":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"checked":true},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"checked":false},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"checked":false},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"checked":false},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"checked":false}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","users":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"checked":false},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"checked":false}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","users":[{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","department_id":9,"checked":false}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","users":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"checked":false}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","users":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"checked":false}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","users":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"checked":false}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","users":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"checked":false},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"checked":true},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"checked":true},{"id":5461,"key":5461,"name":"\u8096\u5e05","department_id":10,"checked":false},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"checked":false}]}]},{"key":"TaskGroups[head_of]","name":"\u8d1f\u8d23\u4eba","value":[{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2},{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"125.78.86.146","ua":"jinchangxiao\/1.0.40 (emulator emulator; HarmonyOS 6.1.0)"}', FALSE, '2026-06-08 21:07:32', 81288960) RETURNING "id"
21:07:32.3070.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)) 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:07:32.2300.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
21:07:32.2370.7 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"=205 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:07:32.2440.7 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"=205) GROUP BY "remain_task"."task_group_id"
21:07:32.2430.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=205)
21:07:32.2390.6 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"=205 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:07:32.2420.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=205
21:07:32.3090.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" IN (5085, 5250, 5332, 5016)) 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:07:32.2320.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:07:32.3060.4 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"='205'
21:07:32.3070.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" ORDER BY "order"
21:07:32.2330.3 msyii\db\Command::querySELECT *, COALESCE(weight, 0) AS weight FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='205'
21:07:32.2380.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 5016, 5085, 5332)
21:07:32.2340.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:07:32.2350.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
21:07:32.2410.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5085, 5250, 5332, 5016)
21:07:32.2390.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 (5085, 5250, 5016, 5332))
21:07:32.2300.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:07:32.2360.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
21:07:32.2400.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
21:07:32.2420.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 (5085, 5250, 5016, 5332))
21:07:32.2370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3082
21:07:32.2430.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)
21:07:32.2400.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)
21:07:32.2410.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=205
21:07:32.2360.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:07:32.2350.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1001) AND ("task_group_id"=205)
21:07:32.2430.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
21:07:32.2360.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4