Performance Profiling

Total processing time: 115 ms; Peak memory: 5.118 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

16:48:35.451	14.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:48:35.496	11.5 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-erp-bank-change-logs', '{"created_at_from":"","created_at_to":"","created_by":"","page":"1","pageSize":"40","listReload":"true"}', '{"code":2000,"result":{"list":[{"id":29,"erp_bank_id":"","description":"\u5220\u9664\u4e86:22222222","created_by":1001,"created_at":"2026-06-29 18:14:27","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"}}},{"id":28,"erp_bank_id":11,"description":"\u521b\u5efa\u4e86:2223","created_by":1001,"created_at":"2026-06-22 14:19:16","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"}}},{"id":27,"erp_bank_id":10,"description":"\u521b\u5efa\u4e86:2222","created_by":1001,"created_at":"2026-06-22 14:18:28","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"}}},{"id":26,"erp_bank_id":9,"description":"\u521b\u5efa\u4e86:222","created_by":1001,"created_at":"2026-06-22 14:13:28","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"}}},{"id":25,"erp_bank_id":"","description":"\u521b\u5efa\u4e86:22222222","created_by":1001,"created_at":"2026-06-22 14:12:00","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"}}},{"id":24,"erp_bank_id":7,"description":"\u505c\u7528\u4e86:\u6dd8\u5b9d\u7f51","created_by":1001,"created_at":"2025-12-29 18:10:11","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"}}},{"id":23,"erp_bank_id":7,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: (\u672a\u8bbe\u7f6e) \u53d8\u4e3a 258.78;","created_by":1001,"created_at":"2025-12-29 17:52:40","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"}}},{"id":22,"erp_bank_id":7,"description":"\u521b\u5efa\u4e86:\u6dd8\u5b9d\u7f51","created_by":1001,"created_at":"2025-12-29 17:47:02","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"}}},{"id":21,"erp_bank_id":6,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: 365.25 \u53d8\u4e3a 19445.25;","created_by":1001,"created_at":"2025-12-16 17:12:35","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"}}},{"id":20,"erp_bank_id":2,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: 62136.5 \u53d8\u4e3a 632136.5;","created_by":1001,"created_at":"2025-08-18 17:24:17","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"}}},{"id":19,"erp_bank_id":4,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: 127923.6 \u53d8\u4e3a 93723.6;","created_by":5064,"created_at":"2025-08-11 19:33:40","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":18,"erp_bank_id":1,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: 13564989.05 \u53d8\u4e3a 2875779.6;","created_by":5064,"created_at":"2025-08-08 18:50:15","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":17,"erp_bank_id":1,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: 1656787.05 \u53d8\u4e3a 13564989.05;","created_by":5064,"created_at":"2025-08-08 18:44:55","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":16,"erp_bank_id":3,"description":"\u4fee\u6539\u4e86:\u6392\u5e8f: 1 \u53d8\u4e3a 4;","created_by":5064,"created_at":"2025-08-08 15:39:57","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":15,"erp_bank_id":1,"description":"\u4fee\u6539\u4e86:\u6392\u5e8f: 4 \u53d8\u4e3a 1;","created_by":5064,"created_at":"2025-08-08 15:39:33","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":14,"erp_bank_id":1,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: (\u672a\u8bbe\u7f6e) \u53d8\u4e3a 1656787.05;","created_by":5064,"created_at":"2025-08-08 15:38:52","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":13,"erp_bank_id":2,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: (\u672a\u8bbe\u7f6e) \u53d8\u4e3a 62136.5;","created_by":5064,"created_at":"2025-08-08 15:38:39","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":12,"erp_bank_id":4,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: (\u672a\u8bbe\u7f6e) \u53d8\u4e3a 127923.6;","created_by":5064,"created_at":"2025-08-08 15:38:26","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":11,"erp_bank_id":5,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: (\u672a\u8bbe\u7f6e) \u53d8\u4e3a 458031.1;","created_by":5064,"created_at":"2025-08-08 15:37:37","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}},{"id":10,"erp_bank_id":6,"description":"\u4fee\u6539\u4e86:\u671f\u521d\u91d1\u989d: (\u672a\u8bbe\u7f6e) \u53d8\u4e3a 365.25;","created_by":5064,"created_at":"2025-08-08 15:37:26","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}}}],"can_create":true,"pagenation":{"totalcount":29,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-06 16:48:35', 59209984) RETURNING "id"
16:48:35.466	3.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:48:35.472	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:48:35.485	1.4 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 (5064, 1001))
16:48:35.481	1.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_bank_change_logs" ORDER BY "created_at" DESC) "c"
16:48:35.487	1.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
16:48:35.511	1.1 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko/20100101 Firefox/152.0'
16:48:35.484	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5064)
16:48:35.483	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_bank_change_logs" ORDER BY "created_at" DESC LIMIT 20
16:48:35.513	0.5 ms	yii\db\Command::execute	UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=6000 WHERE "id"=298