Performance Profiling

Total processing time: 236 ms; Peak memory: 5.385 MB. Show Profiling Timeline

总计19条数据

Time	Duration	Category	Info

17:40:52.677	41.4 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=104) AND ("object_id" IN (1108, 1107, 1106, 1105, 1104, 1103)) GROUP BY "object_id"
17:40:52.719	24.4 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=104) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (1108, 1107, 1106, 1105, 1104, 1103)) GROUP BY "object_id"
17:40:52.755	8.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10) AND ("visit_date"='2025-12-18')
17:40:52.646	3.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:40:52.649	3.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:40:52.660	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:40:52.765	2.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/client/list-document', '{"page":"1","client_id":"1661","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":1108,"attachment_id":29820,"client_id":1661,"title":"777","description":"","created_by":1001,"created_at":"2025-11-28 11:43:58","updated_at":"2025-11-28 11:43:58","project_id":1791,"case_id":8965,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{"id":29820,"key":29820,"name":"3f52de7e-45a3-36e6-9c11-f10f0ad91b3f","extension":"png","path":"\/vue\/attachment\/preview\/3f52de7e-45a3-36e6-9c11-f10f0ad91b3f\/\u622a\u5c4f2025-11-27 15.11.13.png","orig_name":"\u622a\u5c4f2025-11-27 15.11.13.png"},"commentCount":{},"unreadComments":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee"},"case":{"id":8965,"key":8965,"name":"PS251128001"},"unread":0,"can_update":true,"can_delete":true},{"id":1107,"attachment_id":29819,"client_id":1661,"title":"5","description":"55","created_by":1001,"created_at":"2025-11-28 11:43:37","updated_at":"2025-11-28 11:43:37","project_id":1791,"case_id":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{"id":29819,"key":29819,"name":"9129bee8-286c-3f8e-b76c-2d422349027f","extension":"png","path":"\/vue\/attachment\/preview\/9129bee8-286c-3f8e-b76c-2d422349027f\/\u622a\u5c4f2025-11-27 13.45.37.png","orig_name":"\u622a\u5c4f2025-11-27 13.45.37.png"},"commentCount":{},"unreadComments":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee"},"case":null,"unread":0,"can_update":true,"can_delete":true},{"id":1106,"attachment_id":29818,"client_id":1661,"title":"66","description":"","created_by":1001,"created_at":"2025-11-28 11:43:10","updated_at":"2025-11-28 11:43:10","project_id":null,"case_id":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{"id":29818,"key":29818,"name":"0834b20b-ff69-3a51-abef-0d41fc7b6232","extension":"png","path":"\/vue\/attachment\/preview\/0834b20b-ff69-3a51-abef-0d41fc7b6232\/\u622a\u5c4f2025-11-27 15.11.13.png","orig_name":"\u622a\u5c4f2025-11-27 15.11.13.png"},"commentCount":{},"unreadComments":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":null,"case":null,"unread":0,"can_update":true,"can_delete":true},{"id":1105,"attachment_id":29817,"client_id":1661,"title":"\u5730\u65b9","description":"","created_by":1001,"created_at":"2025-11-28 11:06:52","updated_at":"2025-11-28 11:06:52","project_id":1791,"case_id":8965,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{"id":29817,"key":29817,"name":"147e7daf-fd83-3352-938b-3092cc4de232","extension":"png","path":"\/vue\/attachment\/preview\/147e7daf-fd83-3352-938b-3092cc4de232\/\u622a\u5c4f2025-11-27 15.11.13.png","orig_name":"\u622a\u5c4f2025-11-27 15.11.13.png"},"commentCount":{},"unreadComments":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee"},"case":{"id":8965,"key":8965,"name":"PS251128001"},"unread":0,"can_update":true,"can_delete":true},{"id":1104,"attachment_id":29815,"client_id":1661,"title":"\u5546\u673a\u6587\u6863","description":"","created_by":1001,"created_at":"2025-11-28 11:05:40","updated_at":"2025-11-28 11:05:40","project_id":1791,"case_id":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{"id":29815,"key":29815,"name":"be10c6ec-5453-3565-b29d-9e1d6beb394c","extension":"png","path":"\/vue\/attachment\/preview\/be10c6ec-5453-3565-b29d-9e1d6beb394c\/\u622a\u5c4f2025-11-27 15.11.13.png","orig_name":"\u622a\u5c4f2025-11-27 15.11.13.png"},"commentCount":{},"unreadComments":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee"},"case":null,"unread":0,"can_update":true,"can_delete":true},{"id":1103,"attachment_id":29814,"client_id":1661,"title":"\u5ba2\u6237\u6587\u6863","description":"","created_by":1001,"created_at":"2025-11-28 11:05:14","updated_at":"2025-11-28 11:05:14","project_id":null,"case_id":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{"id":29814,"key":29814,"name":"46a8c0b6-5687-3de8-adc1-f7b7149a1928","extension":"png","path":"\/vue\/attachment\/preview\/46a8c0b6-5687-3de8-adc1-f7b7149a1928\/\u622a\u5c4f2025-11-27 15.11.13.png","orig_name":"\u622a\u5c4f2025-11-27 15.11.13.png"},"commentCount":{},"unreadComments":null,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":null,"case":null,"unread":0,"can_update":true,"can_delete":true}],"can_create":true,"pagenation":{"totalcount":6,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"59.108.56.210","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/18.5 Safari\/605.1.15"}', FALSE, '2025-12-18 17:40:52') RETURNING "id"
17:40:52.666	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661'
17:40:52.675	1.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (29820, 29819, 29818, 29817, 29815, 29814)
17:40:52.669	1.5 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT cd. FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"=1661 GROUP BY "cd"."id" ORDER BY "created_at" DESC) "c"
17:40:52.744	1.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=1791
17:40:52.764	1.2 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=4, "last_visit_at"='now()' WHERE "id"=59597
17:40:52.673	1.1 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)
17:40:52.655	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:40:52.671	0.6 ms	yii\db\Command::query	SELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"=1661 GROUP BY "cd"."id" ORDER BY "created_at" DESC LIMIT 20
17:40:52.674	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
17:40:52.746	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "case_no" AS "name" FROM "a57be577deb434"."tbl_cases" WHERE "id"=8965
17:40:52.744	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
17:40:52.672	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001