ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a62c643c98: POST https://beta.jinchangxiao.com/vue/erp-other-collect-ticket/payment at 2026-06-11 03:24:54 pm by 221.216.117.119

Performance Profiling

Total processing time: 205 ms; Peak memory: 6.418 MB. Show Profiling Timeline

总计83条数据
TimeDurationCategoryInfo
  
15:24:54.38114.0 msyii\db\Command::querySELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20013::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20013 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "t" ON t.erp_collect_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null)) "sub") UNION ALL ( SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20015::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20015 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20017::varchar || 1::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "t" ON t.erp_bank_transfer_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20017::varchar || 2::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "t" ON t.erp_bank_transfer_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "t" ON t.erp_cash_cost_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "t" ON t.erp_advance_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20020 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, t.amount as in_amount, null::numeric as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "t" ON t.erp_other_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "t" ON t.erp_other_collect_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (r.bank_settle_at IS NOT NULL) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "t" ON t.erp_wage_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "t" ON t.erp_social_insurance_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "t" ON t.erp_provident_fund_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "t" ON t.erp_personal_tax_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, t.erp_bank_id, null::numeric as in_amount, t.amount as out_amount, bank_settle_at, t.settle_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "t" ON t.erp_wage_prize_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) )) "sub" WHERE ("sub"."id2"=59) AND ("sub"."ticket_type"=20021) ORDER BY "settle_at"
15:24:54.3985.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_bank_amount_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at", "settle_at", "in_amount", "out_amount", "erp_bank_id", "balance_amount") VALUES (2, 20021, 'QTYSD-20260611-00003', '2026-06-11', NULL, NULL, '100', NULL, 431, NULL, NULL, 1001, '2026-06-11 15:20:16', '2026-06-11 15:24:54', 59, '2026-06-11 15:23:24.594578+08', '2026-06-11 15:24:54.297415+08', NULL, '100', 1, '1484333.72') RETURNING "id"
15:24:54.3015.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20037) AND ("object_id"=59)
15:24:54.4074.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" ("erp_bank_amount_change_log_id", "user_id") VALUES (1751, 1001)
15:24:54.4144.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4423.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.3073.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (20037, 59, 32710)
15:24:54.2941.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
15:24:54.3001.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" ("erp_other_collect_ticket_id", "erp_bank_id", "amount", "description", "settle_at", "settle_by") VALUES (59, 1, '100', '测试', 'now()', 1001)
15:24:54.4211.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4231.2 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4481.2 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4761.1 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-other-collect-ticket/payment', '{"ErpOtherCollectTickets":{"id":"59","erpOtherCollectTicketBankOuts":[{"amount":"100","id":"1","description":"\u6d4b\u8bd5"}],"erpOtherCollectTicketPayments":"","files":["32710"]},"web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u4ed8\u6b3e\u6210\u529f","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:24:54', 198003968) RETURNING "id"
15:24:54.4581.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpBanks', 1, 'a:0:{}', '', 1001, '221.216.117.119')
15:24:54.4501.0 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4620.9 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (2, 5))
15:24:54.4600.9 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (2, 5))
15:24:54.4040.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpBankAmountChangeLogs', 1751, 'a:22:{s:2:"id";i:1751;s:9:"object_id";i:59;s:11:"ticket_type";i:20021;s:9:"serial_no";s:20:"QTYSD-20260611-00003";s:11:"erp_bank_id";i:1;s:10:"wrote_date";s:10:"2026-06-11";s:6:"status";i:2;s:6:"amount";s:3:"100";s:9:"in_amount";N;s:10:"out_amount";s:3:"100";s:14:"balance_amount";d:1484333.72;s:11:"supplier_id";i:431;s:9:"client_id";N;s:10:"contact_id";N;s:7:"user_id";N;s:8:"abstract";N;s:11:"description";N;s:9:"settle_at";s:29:"2026-06-11 15:24:54.297415+08";s:9:"verify_at";s:29:"2026-06-11 15:23:24.594578+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-11 15:20:16";s:10:"updated_at";s:19:"2026-06-11 15:24:54";}', '', 1001, '221.216.117.119')
15:24:54.4360.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
15:24:54.2820.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:24:54.4730.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (9, 'status', 59, 20021, 1001, 'now()', '["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:\uffe5100;"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ed8\u6b3e\u4fe1\u606f","d4":["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:\uffe5100;"]}')
15:24:54.4630.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (2, 5))
15:24:54.4640.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (2, 5))
15:24:54.4680.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_collect_tickets" SET "settle_amount"='0', "all_settle_amount"='0' WHERE "id"=59
15:24:54.4650.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (1, 2, 5))
15:24:54.2900.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" WHERE "erp_other_collect_ticket_id"=59 ORDER BY "id"
15:24:54.2840.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:24:54.2980.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_collect_tickets" SET "bank_settle_at"=now(), "updated_at"=now() WHERE ("id"=59) AND ("status"=2) AND ("bank_settle_at" IS NULL)
15:24:54.2880.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"='59'
15:24:54.4570.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71
15:24:54.2910.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" WHERE "erp_other_collect_ticket_id"=59 ORDER BY "id"
15:24:54.4120.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4540.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='1484333.72' WHERE "id"=1
15:24:54.4130.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4130.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4200.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND (t.bank_settle_at IS NOT NULL)
15:24:54.4200.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4240.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4260.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4270.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4190.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4280.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='1484333.72' WHERE "id"=1
15:24:54.4270.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4250.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.3960.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=59
15:24:54.4410.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4480.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND (t.bank_settle_at IS NOT NULL)
15:24:54.4650.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (1, 2, 5))
15:24:54.4530.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4660.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (1, 2, 5))
15:24:54.4520.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4520.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4710.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:24:54.4510.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4670.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_other_collect_ticket_id"=59) AND ("t"."status" IN (1, 2, 5))
15:24:54.4420.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4470.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.4290.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpBanks', 1, 'a:1:{s:14:"balance_amount";d:1484333.72;}', '', 1001, '221.216.117.119')
15:24:54.4410.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5))
15:24:54.3110.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=59
15:24:54.4460.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4580.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '221.216.117.119')
15:24:54.4550.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpBanks', 1, 'a:0:{}', '', 1001, '221.216.117.119')
15:24:54.4380.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_account_captions" SET "balance_amount"='1484333.72', "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71
15:24:54.4690.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=59
15:24:54.4530.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
15:24:54.4390.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpBanks', 1, 'a:0:{}', '', 1001, '221.216.117.119')
15:24:54.2810.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:24:54.3950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks"
15:24:54.4380.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpAccountCaptions', 71, 'a:1:{s:14:"balance_amount";s:10:"1484333.72";}', '', 1001, '221.216.117.119')
15:24:54.4560.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
15:24:54.4690.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpOtherCollectTickets', 59, 'a:0:{}', '', 1001, '221.216.117.119')
15:24:54.4560.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
15:24:54.4700.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" WHERE "erp_other_collect_ticket_id"=59 ORDER BY "id"
15:24:54.4290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
15:24:54.4700.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
15:24:54.4600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" WHERE "erp_other_collect_ticket_id"=59 ORDER BY "id"
15:24:54.4390.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" WHERE "erp_other_collect_ticket_id"=59 ORDER BY "id"
15:24:54.2980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
15:24:54.2970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" WHERE "erp_other_collect_ticket_id"=59
15:24:54.2990.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" WHERE "erp_other_collect_ticket_id"=59
15:24:54.4400.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
15:24:54.2980.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" WHERE "erp_other_collect_ticket_id"=59