Performance Profiling

Total processing time: 41 ms; Peak memory: 5.095 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

15:36:38.847	3.1 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', '[]', '{"code":2000,"result":{"list":[{"id":1,"title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","amount":"2875779.6","balance_amount":"1476232.71","description":"","sort":1,"type":0,"is_system":true,"is_delete":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 18:50:15","erp_un_settle_amount":"","serial_no":"100201","erp_account_caption_id":71,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":2,"title":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","amount":"632136.5","balance_amount":"23097.26","description":"","sort":2,"type":0,"is_system":false,"is_delete":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-18 17:24:17","erp_un_settle_amount":"","serial_no":"100202","erp_account_caption_id":72,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":4,"title":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","amount":"93723.6","balance_amount":"55209.98","description":"","sort":3,"type":0,"is_system":false,"is_delete":false,"created_by":5064,"created_at":"2025-08-08 15:34:38","updated_at":"2025-08-11 19:33:40","erp_un_settle_amount":"","serial_no":"100203","erp_account_caption_id":101,"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_update":false,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":3,"title":"\u73b0\u91d1","amount":"3480","balance_amount":"8610","description":"","sort":4,"type":1,"is_system":true,"is_delete":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 15:39:57","erp_un_settle_amount":"","serial_no":"100101","erp_account_caption_id":73,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":5,"title":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","amount":"458031.1","balance_amount":"789952.68","description":"","sort":5,"type":1,"is_system":false,"is_delete":false,"created_by":5064,"created_at":"2025-08-08 15:35:40","updated_at":"2025-08-08 15:37:37","erp_un_settle_amount":"","serial_no":"100102","erp_account_caption_id":102,"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_update":false,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":6,"title":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","amount":"19445.25","balance_amount":"345.48","description":"","sort":6,"type":1,"is_system":false,"is_delete":false,"created_by":5064,"created_at":"2025-08-08 15:36:06","updated_at":"2025-12-16 17:12:36","erp_un_settle_amount":"","serial_no":"100103","erp_account_caption_id":103,"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_update":false,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":7,"title":"\u6dd8\u5b9d\u7f51","amount":"258.78","balance_amount":"0","description":"","sort":7,"type":1,"is_system":false,"is_delete":true,"created_by":1001,"created_at":"2025-08-08 17:47:02","updated_at":"2025-12-29 17:52:40","erp_un_settle_amount":"","serial_no":"100104","erp_account_caption_id":104,"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"}},"can_update":false,"can_delete":true,"can_stop":false,"can_start":true,"bgcolor":"#89c541"}],"countArr":{"total_amount":"4082854.83"},"can_create":true,"pagenation":{"totalcount":7,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"66.249.68.3","ua":"Mozilla\/5.0 (Linux; Android 6.0.1; Nexus 5X Build\/MMB29P) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.7778.96 Mobile Safari\/537.36 (compatible; GoogleOther)"}', FALSE, '2026-06-19 15:36:38', 31972864) RETURNING "id"
15:36:38.834	2.0 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_banks" ORDER BY "is_delete", "sort") "c"
15:36:38.841	1.4 ms	yii\db\Command::query	SELECT MAX(date) FROM "a57be577deb434"."tbl_erp_settles" WHERE "is_settle"=TRUE
15:36:38.822	1.1 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:36:38.821	1.0 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:36:38.838	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
15:36:38.825	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:36:38.843	0.5 ms	yii\db\Command::query	SELECT sum(amount) as total_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_banks" ORDER BY "is_delete", "sort") "sub"
15:36:38.836	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_banks" ORDER BY "is_delete", "sort" LIMIT 20
15:36:38.837	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001)
15:36:38.838	0.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 (1000, 5064, 1001))