Performance Profiling

Total processing time: 80 ms; Peak memory: 5.115 MB. Show Profiling Timeline

总计22条数据

Time	Duration	Category	Info

09:46:52.973	21.3 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=22) AND ("object_id" IN (129, 126, 120, 119)) GROUP BY "object_id"
09:46:52.995	17.4 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=22) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (129, 126, 120, 119)) GROUP BY "object_id"
09:46:53.016	3.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=22) AND ("visit_date"='2025-09-18')
09:46:52.950	3.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:46:52.947	3.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:46:52.957	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:46:53.020	1.2 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_visit_module_histories" ("user_id", "object_type", "visit_date", "num", "last_visit_at") VALUES (1001, 22, '2025-09-18', 1, 'now()') RETURNING "id"
09:46:53.021	1.2 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/operation/list', '{"OperationTaskSearch":{"head_of":"1001","is_complete":""},"Filter":{"name":"created_at","sort":"DESC"},"page":"1","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"list":[{"id":129,"title":"\u9001\u793c","target":"\u7ea6\u89c1\u62dc\u8bbf","action":"\u7535\u8bdd","result":"","script":"","is_complete":false,"description":"","complete_at":"","head_of":1001,"created_by":1001,"created_at":"2023-09-13 17:59:22","updated_at":"","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{"operation_task_id":129,"count":1},"unCompleteContact":{"operation_task_id":129,"count":97},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":129,"count":99},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":false,"can_update":true,"can_delete":true,"bgcolor":"#4993d0"},{"id":126,"title":"\u5411\u5ba2\u6237\u63a8\u8350MSS","target":"\u8bdd\u672f","action":"\u7535\u8bdd","result":"","script":"\u8bdd\u672f","is_complete":false,"description":"","complete_at":"","head_of":1001,"created_by":1001,"created_at":"2023-05-23 11:48:44","updated_at":"2023-05-23 11:53:33","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{},"unCompleteContact":{"operation_task_id":126,"count":46},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":126,"count":48},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":true,"can_update":true,"can_delete":true,"bgcolor":"#4993d0"},{"id":120,"title":"\u62dc\u8bbf\u5ba2\u6237","target":"\u9001\u793c\u7269","action":"\u6253\u7535\u8bdd","result":"","script":"\u54c8\u54c8","is_complete":true,"description":"","complete_at":"2022-05-26 21:20:57","head_of":1001,"created_by":1001,"created_at":"2022-05-26 21:20:13","updated_at":"2022-05-26 21:20:57","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{},"unCompleteContact":{"operation_task_id":120,"count":47},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":120,"count":50},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":false,"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":119,"title":"\u516c\u53f8\u4ecb\u7ecd","target":"\u6253\u901a\u7535\u8bdd","action":"\u6253\u901a\u7535\u8bdd","result":"","script":"","is_complete":true,"description":"","complete_at":"2022-05-25 18:41:54","head_of":1001,"created_by":1001,"created_at":"2022-05-25 18:33:49","updated_at":"2022-05-25 18:41:54","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{},"unCompleteContact":{"operation_task_id":119,"count":21},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":119,"count":25},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":false,"can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-18 09:46:53') RETURNING "id"
09:46:53.012	1.0 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "operation_task_id" FROM "a57be577deb434"."tbl_operation_task_remind_receivers" WHERE "operation_task_id" IN (129, 126, 120, 119)
09:46:52.963	1.0 ms	yii\db\Command::query	SELECT "head_of" FROM "a57be577deb434"."tbl_operation_tasks" "s" GROUP BY "s"."id" ORDER BY "head_of"
09:46:52.968	1.0 ms	yii\db\Command::query	SELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE ("has_follow"=TRUE) AND ("operation_task_id" IN (129, 126, 120, 119)) GROUP BY "operation_task_id"
09:46:52.969	0.8 ms	yii\db\Command::query	SELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE (("is_complete"=FALSE) OR (is_complete IS NULL)) AND ("operation_task_id" IN (129, 126, 120, 119)) GROUP BY "operation_task_id"
09:46:52.970	0.8 ms	yii\db\Command::query	SELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE ("is_achieve"=FALSE) AND ("operation_task_id" IN (129, 126, 120, 119)) GROUP BY "operation_task_id"
09:46:52.972	0.8 ms	yii\db\Command::query	SELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE "operation_task_id" IN (129, 126, 120, 119) GROUP BY "operation_task_id"
09:46:52.968	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
09:46:52.964	0.7 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT s. FROM "a57be577deb434"."tbl_operation_tasks" "s" WHERE "s"."head_of"='1001' GROUP BY "s"."id" ORDER BY "s"."created_at" DESC) "c"
09:46:52.965	0.4 ms	yii\db\Command::query	SELECT s.* FROM "a57be577deb434"."tbl_operation_tasks" "s" WHERE "s"."head_of"='1001' GROUP BY "s"."id" ORDER BY "s"."created_at" DESC LIMIT 20
09:46:52.967	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
09:46:52.966	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:46:52.971	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:46:52.972	0.2 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
09:46:52.972	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4