ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4c9ac87a5a0: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-bank-view at 2026-07-07 02:20:56 pm by 39.156.194.178

Performance Profiling

Total processing time: 44 ms; Peak memory: 5.055 MB. Show Profiling Timeline

总计23条数据
TimeDurationCategoryInfo
  
14:20:56.5381.9 msyii\db\Command::queryINSERT 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":"5","in_out":"in","keyword":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"code":2000,"result":{"list":[{"id":1563,"object_id":23,"ticket_type":20017,"serial_no":"ZKD-20260311-00001","erp_bank_id":5,"wrote_date":"2026-03-11","status":2,"amount":"11000","in_amount":"11000","out_amount":"","balance_amount":"1038568.54","supplier_id":"","client_id":"","contact_id":"","user_id":"","abstract":"\u5e74\u4f1a\u7528\u73b0\u91d1\uff08\u5f00\u5de5\u7ea2\u5305\uff09\u4ece\u62d3\u5b9e\u5de5\u4f1a\u8d26\u6237\u8f6c\u5230\u62db\u884c\u5361","description":"","settle_at":"2026-03-11 17:12:23.502455+08","verify_at":"2026-03-11 18:05:13","created_by":5252,"created_at":"2026-03-11 17:12:23","updated_at":"2026-03-11 18:05:13","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":"","client":"","user":"","contact":"","erpBank":{"id":5,"key":5,"name":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"},"handlers":[],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u8f6c\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":"","settleTickets":[]},{"id":1469,"object_id":21,"ticket_type":20017,"serial_no":"ZKD-20260210-00001","erp_bank_id":5,"wrote_date":"2026-02-10","status":2,"amount":"5151.6","in_amount":"5151.6","out_amount":"","balance_amount":"1279765.4","supplier_id":"","client_id":"","contact_id":"","user_id":"","abstract":"\u4ee3\u59da\u96ea\u7eaf\u652f\u4ed8\u81ea\u5982\u623f\u79df","description":"","settle_at":"2026-02-10 14:46:54.935189+08","verify_at":"2026-02-10 15:16:31","created_by":5252,"created_at":"2026-02-10 14:46:54","updated_at":"2026-02-10 15:16:31","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":"","client":"","user":"","contact":"","erpBank":{"id":5,"key":5,"name":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"},"handlers":[],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u8f6c\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":"","settleTickets":[]},{"id":1417,"object_id":2160,"ticket_type":20013,"serial_no":"SKD-20260130-00001","erp_bank_id":5,"wrote_date":"2026-01-30","status":2,"amount":"300000","in_amount":"300000","out_amount":"","balance_amount":"1316829.9","supplier_id":"","client_id":"","contact_id":4136,"user_id":"","abstract":"","description":"","settle_at":"2026-01-30 15:21:53.451265+08","verify_at":"2026-01-30 15:36:42","created_by":1013,"created_at":"2026-01-30 15:21:53","updated_at":"2026-01-30 15:36:42","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"supplier":"","client":"","user":"","contact":{"id":4136,"key":4136,"name":"\u9f9a\u957f\u6625"},"erpBank":{"id":5,"key":5,"name":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"},"handlers":[{"id":1180,"erp_bank_amount_change_log_id":1417,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":4136,"key":4136,"name":"\u9f9a\u957f\u6625"},"contract_no":"","settleTickets":[{"type_display":"\u5176\u4ed6\u5e94\u6536\u5355","serial_no":"QTYSD-20260128-00001","created_at":"2026-01-28 09:39:32"}]},{"id":1300,"object_id":2144,"ticket_type":20013,"serial_no":"SKD-20260115-00001","erp_bank_id":5,"wrote_date":"2026-01-15","status":2,"amount":"269168","in_amount":"269168","out_amount":"","balance_amount":"1118261.9","supplier_id":"","client_id":"","contact_id":4136,"user_id":"","abstract":"","description":"","settle_at":"2026-01-15 11:38:12.742066+08","verify_at":"2026-01-15 15:00:54","created_by":1013,"created_at":"2026-01-15 11:38:12","updated_at":"2026-01-15 15:00:54","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"supplier":"","client":"","user":"","contact":{"id":4136,"key":4136,"name":"\u9f9a\u957f\u6625"},"erpBank":{"id":5,"key":5,"name":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"},"handlers":[{"id":1082,"erp_bank_amount_change_log_id":1300,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":4136,"key":4136,"name":"\u9f9a\u957f\u6625"},"contract_no":"","settleTickets":[{"type_display":"\u5176\u4ed6\u5e94\u6536\u5355","serial_no":"QTYSD-20260112-00001","created_at":"2026-01-12 14:45:14"}]},{"id":1278,"object_id":39,"ticket_type":20020,"serial_no":"QTYFD-20260106-00001","erp_bank_id":5,"wrote_date":"2026-01-06","status":2,"amount":"30000","in_amount":"30000","out_amount":"","balance_amount":"904868.9","supplier_id":161,"client_id":"","contact_id":"","user_id":"","abstract":"\u62db\u884c\u5361\u6536\u5609\u8fd0\u8fbe\u53f6\u7b11\u7b11\u4ed8\u6295\u6807\u4fdd\u8bc1\u91d1","description":"","settle_at":"2026-01-06 15:20:09.035426+08","verify_at":"2026-01-06 15:58:59","created_by":5388,"created_at":"2026-01-06 15:20:08","updated_at":"2026-01-06 15:58:59","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":{"id":161,"key":161,"name":"\u5317\u4eac\u5609\u8fd0\u8fbe\u79d1\u6280\u5f00\u53d1\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","erpBank":{"id":5,"key":5,"name":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062"},"handlers":[{"id":1065,"erp_bank_amount_change_log_id":1278,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":161,"key":161,"name":"\u5317\u4eac\u5609\u8fd0\u8fbe\u79d1\u6280\u5f00\u53d1\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"contract_no":"","settleTickets":[]}],"in_amount":"615319.6","out_amount":"","pagenation":{"totalcount":5,"thispage":1,"pagesize":40}},"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-07 14:20:56', 35953920) RETURNING "id"
14:20:56.5171.8 msyii\db\Command::querySELECT 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"='5') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id" ORDER BY settle_at DESC) "c"
14:20:56.5331.6 msyii\db\Command::querySELECT 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"='5') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id") "c"
14:20:56.5191.6 msyii\db\Command::querySELECT "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"='5') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id" ORDER BY settle_at DESC LIMIT 40
14:20:56.5351.5 msyii\db\Command::querySELECT 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"='5') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id") "c"
14:20:56.5301.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=47
14:20:56.5060.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:20:56.5280.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2160 ORDER BY "id"
14:20:56.5270.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2160
14:20:56.5090.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:20:56.5100.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:20:56.5320.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2144 ORDER BY "id"
14:20:56.5060.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:20:56.5250.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" WHERE "erp_bank_amount_change_log_id" IN (1563, 1469, 1417, 1300, 1278)
14:20:56.5330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=44
14:20:56.5230.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5388, 1013, 5252))
14:20:56.5220.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1013, 5388)
14:20:56.5310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2144
14:20:56.5260.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013, 5252)
14:20:56.5250.3 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=5
14:20:56.5240.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=4136
14:20:56.5240.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=161
14:20:56.5230.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (6, 7)