Performance Profiling

Total processing time: 29 ms; Peak memory: 3.434 MB. Show Profiling Timeline

总计16条数据

Time	Duration	Category	Info

17:10:24.004	4.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-12-18')
17:10:23.987	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:10:24.000	2.1 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (1079, 4853)
17:10:23.985	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:10:23.995	1.6 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT r. FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id WHERE "rvr"."user_id"='1001' GROUP BY "r"."id" ORDER BY r.created_at DESC) "c"
17:10:24.009	1.4 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/erp-dashboard/list-log', '{"ErpTicketChangeLogSearch":{"created_by":["1001"],"created_at_period":"","status":""},"page":"3","pageSize":"40","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":194,"serial_no":"XSDD-20250819-00001","ticket_type":20007,"wrote_date":"2025-08-19","status":2,"supplier_id":"","client_id":2845,"abstract":"","description":"","verify_at":"2025-08-20 14:58:35","created_by":1001,"created_at":"2025-08-19 17:45:00","updated_at":"2025-08-20 14:58:35","contact_id":"","user_id":"","amount":"15340","object_id":1566,"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"}},"supplier":{},"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"},"user":{},"contact":{},"handlers":[{"id":1452,"erp_ticket_change_log_id":194,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"}},{"id":182,"serial_no":"FYZSRD-20250818-00001","ticket_type":20016,"wrote_date":"2025-08-18","status":2,"supplier_id":"","client_id":"","abstract":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6\u8d39\u75287\u6708","description":"","verify_at":"2025-08-19 11:18:03","created_by":5388,"created_at":"2025-08-19 10:20:49","updated_at":"2025-08-19 11:18:03","contact_id":"","user_id":"","amount":"21110","object_id":1,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":1358,"erp_ticket_change_log_id":182,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1359,"erp_ticket_change_log_id":182,"user_id":5087,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":1360,"erp_ticket_change_log_id":182,"user_id":5300,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":1361,"erp_ticket_change_log_id":182,"user_id":5295,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":1362,"erp_ticket_change_log_id":182,"user_id":1004,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},{"id":1363,"erp_ticket_change_log_id":182,"user_id":1005,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}}],"ticket_type_display":"\u8d39\u7528\u8f6c\u6536\u5165\u5355","unit":{}},{"id":160,"serial_no":"QTYFD-20250818-00019","ticket_type":20020,"wrote_date":"2025-08-18","status":2,"supplier_id":"","client_id":"","abstract":"\u79ef\u5206","description":"","verify_at":"2025-08-18 14:21:35","created_by":1001,"created_at":"2025-08-18 14:21:35","updated_at":"2025-08-18 14:21:35","contact_id":1079,"user_id":"","amount":"20000","object_id":19,"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"}},"supplier":{},"client":{},"user":{},"contact":{"id":1079,"key":1079,"name":"\u5168\u52c7\u7537"},"handlers":[{"id":1345,"erp_ticket_change_log_id":160,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","unit":{"id":1079,"key":1079,"name":"\u5168\u52c7\u7537"}},{"id":148,"serial_no":"QTYFD-20250818-00008","ticket_type":20020,"wrote_date":"2025-08-18","status":2,"supplier_id":"","client_id":"","abstract":"\u79ef\u5206","description":"","verify_at":"2025-08-18 14:16:18","created_by":1001,"created_at":"2025-08-18 14:16:18","updated_at":"2025-08-18 14:16:18","contact_id":4853,"user_id":"","amount":"27700","object_id":8,"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"}},"supplier":{},"client":{},"user":{},"contact":{"id":4853,"key":4853,"name":"\u9a6c\u6653\u5149"},"handlers":[{"id":1447,"erp_ticket_change_log_id":148,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","unit":{"id":4853,"key":4853,"name":"\u9a6c\u6653\u5149"}}],"pagenation":{"totalcount":84,"thispage":3,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 17:10:24') RETURNING "id"
17:10:23.991	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:10:24.008	1.0 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1313, "last_visit_at"='now()' WHERE "id"=59588
17:10:23.996	0.9 ms	yii\db\Command::query	SELECT r.* FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id WHERE "rvr"."user_id"='1001' GROUP BY "r"."id" ORDER BY r.created_at DESC LIMIT 40 OFFSET 80
17:10:23.998	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" IN (1001, 5388))
17:10:23.990	0.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:10:24.000	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2845
17:10:23.999	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 6)
17:10:23.998	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5388)
17:10:24.003	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_ticket_change_log_handlers" WHERE "erp_ticket_change_log_id" IN (194, 182, 160, 148)
17:10:24.003	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 5300, 5295, 1004, 1005)