ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a647921845: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-bank at 2026-06-11 03:32:09 pm by 221.216.117.119

Performance Profiling

Total processing time: 351 ms; Peak memory: 5.003 MB. Show Profiling Timeline

总计14条数据
TimeDurationCategoryInfo
  
15:32:09.22044.7 msyii\db\Command::querySELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub" LIMIT 40
15:32:09.40218.7 msyii\db\Command::querySELECT SUM(out_count) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.30816.7 msyii\db\Command::querySELECT SUM(n_out_amount) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.35013.7 msyii\db\Command::querySELECT SUM(l_in_amount) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.28412.8 msyii\db\Command::querySELECT SUM(n_in_amount) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.44112.7 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', '{"created_at_period":"currentfascalyear","not_zero":"","is_delete":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"id":1,"title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","amount":"2875779.6","balance_amount":"1484433.72","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,"n_amount":"1484432.72","n_in_amount":"10672907.84","n_out_amount":"9830863.75","l_amount":"642388.63","l_in_amount":"14232723.10","l_out_amount":"16466114.07","in_count":"71","out_count":"352"},{"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,"n_amount":"23097.26","n_in_amount":"703.6","n_out_amount":"","l_amount":"22393.66","l_in_amount":"2154093.16","l_out_amount":"2763836.00","in_count":"1","out_count":""},{"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,"n_amount":"55209.98","n_in_amount":"54600","n_out_amount":"100","l_amount":"709.98","l_in_amount":"34217.30","l_out_amount":"127230.92","in_count":"1","out_count":"1"},{"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,"n_amount":"8610","n_in_amount":"55000","n_out_amount":"50850","l_amount":"4460","l_in_amount":"52560","l_out_amount":"51580","in_count":"2","out_count":"15"},{"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,"n_amount":"789952.68","n_in_amount":"615319.6","n_out_amount":"858925.65","l_amount":"1033558.73","l_in_amount":"2712443.54","l_out_amount":"2136915.91","in_count":"5","out_count":"38"},{"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,"n_amount":"345.48","n_in_amount":"0.23","n_out_amount":"20","l_amount":"365.25","l_in_amount":"","l_out_amount":"19080","in_count":"1","out_count":"1"},{"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,"n_amount":"0.00","n_in_amount":"","n_out_amount":"","l_amount":"0.00","l_in_amount":"","l_out_amount":"258.78","in_count":"","out_count":""}],"n_amount":"2361648.12","n_in_amount":"11398531.27","n_out_amount":"10740759.40","l_amount":"1703876.25","l_in_amount":"19186037.10","l_out_amount":"21565015.68","in_count":"81","out_count":"407","pagenation":{"totalcount":7,"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:09', 297628928) RETURNING "id"
15:32:09.38311.8 msyii\db\Command::querySELECT SUM(in_count) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.26911.1 msyii\db\Command::querySELECT SUM(n_amount) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.33210.6 msyii\db\Command::querySELECT SUM(l_amount) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.14910.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:32:09.3698.7 msyii\db\Command::querySELECT SUM(l_out_amount) FROM (SELECT * FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub") "s"
15:32:09.2088.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT b.*, COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as n_amount, sum(n.in_amount) as n_in_amount, sum(n.out_amount) as n_out_amount, COALESCE(sum(ba.amount), 0) + COALESCE(sum(l.in_amount), 0) - COALESCE(sum(l.out_amount), 0) as l_amount, sum(l.in_amount) as l_in_amount, sum(l.out_amount) as l_out_amount, sum(isb.count) as in_count, sum(osb.count) as out_count FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "n" ON n.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-01-01 00:00:00') "s" GROUP BY "s"."erp_bank_id") "l" ON l.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.in_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "isb" ON isb.erp_bank_id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", count(*) as count FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE (t.out_amount is not null) AND ("t"."settle_at" >= '2026-01-01 00:00:00') AND ("t"."settle_at" <= '2026-12-31 23:59:59')) "s" GROUP BY "s"."erp_bank_id") "osb" ON osb.erp_bank_id = b.id GROUP BY "b"."id" ORDER BY "is_delete", "sort") "sub"
15:32:09.1796.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:32:09.1471.7 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta