Performance Profiling

Total processing time: 32 ms; Peak memory: 5.005 MB. Show Profiling Timeline

总计14条数据

Time	Duration	Category	Info

15:32:57.851	1.9 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT "l". FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id" ORDER BY settle_at DESC) "c"
15:32:57.864	1.7 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/erp-analysis/list-bank-view', '{"created_at_period":"currentfascalyear","not_zero":"","is_delete":"","erp_bank_id":"2","keyword":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"id":1646,"object_id":37,"ticket_type":20015,"serial_no":"QTSRD-20260320-00001","erp_bank_id":2,"wrote_date":"2026-03-20","status":2,"amount":"703.6","in_amount":"703.6","out_amount":"","balance_amount":"23097.26","supplier_id":100,"client_id":"","contact_id":"","user_id":"","abstract":"\u6536PA\u8fd4\u70b9\u6536\u5165\u7f8e\u5143102.49*6.865048","description":"","settle_at":"2026-03-20 15:10:12.595528+08","verify_at":"2026-03-20 15:12:48","created_by":5252,"created_at":"2026-03-20 15:10:12","updated_at":"2026-03-20 15:12:48","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"client":"","user":"","contact":"","erpBank":{"id":2,"key":2,"name":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495"},"handlers":[{"user":{"name":"\u516c\u53f8\u6536\u5165"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u6536\u5165\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"contract_no":"","settleTickets":[]}],"in_amount":"703.6","out_amount":"","pagenation":{"totalcount":1,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 15:32:57', 26012928) RETURNING "id"
15:32:57.859	1.6 ms	yii\db\Command::query	SELECT SUM(in_amount) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id") "c"
15:32:57.854	1.5 ms	yii\db\Command::query	SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id" ORDER BY settle_at DESC LIMIT 40
15:32:57.841	1.4 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:32:57.861	1.4 ms	yii\db\Command::query	SELECT SUM(out_amount) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id") "c"
15:32:57.845	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:32:57.840	0.7 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:32:57.857	0.3 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"=5252)
15:32:57.856	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
15:32:57.858	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" WHERE "erp_bank_amount_change_log_id"=1646
15:32:57.858	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100
15:32:57.857	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
15:32:57.858	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=2