ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7c7ed843ad: POST https://beta.jinchangxiao.com/vue/erp-advance-payment-ticket/save-edit at 2025-09-15 04:01:49 pm by 114.246.237.213

Performance Profiling

Total processing time: 109 ms; Peak memory: 7.291 MB. Show Profiling Timeline

总计123条数据
TimeDurationCategoryInfo
  
16:01:49.6433.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
16:01:49.6393.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (534, 1001)
16:01:49.6353.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_ticket_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") VALUES (2, 20019, 'YFKD-20250915-00001', '2025-09-15', '三分大赛', 'f史蒂夫', '22.97', 2133, NULL, NULL, NULL, 1001, '2025-09-15 16:00:55', '2025-09-15 16:01:49', 2, '2025-09-15 16:01:49.604228+08') RETURNING "id"
16:01:49.5612.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20033) AND ("object_id"=2)
16:01:49.5812.3 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)
16:01:49.5452.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:01:49.5592.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20033) AND ("object_id"=2)
16:01:49.6071.9 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)
16:01:49.5431.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:01:49.5671.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 (2, 'erpAdvancePaymentTicketVerifyRels', 2, 20019, 1001, 'now()', '[[]]', '[["\u5218\u4eba\u8bda"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u5218\u4eba\u8bda; <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}')
16:01:49.5481.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.6301.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2, '20019', 191363, 1013), (2, '20019', 191363, 5388)
16:01:49.5561.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "handler"=1001, "client_id"=2133, "supplier_id"=NULL WHERE "id"=2
16:01:49.5581.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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.6281.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20019', 2, '刘人诚通过了这个审批', TRUE, 'YFKD-20250915-00001') RETURNING "id"
16:01:49.5640.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (20033, 2, 28158)
16:01:49.5530.9 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "serial_no"='YFKD-20250915-00001' LIMIT 2
16:01:49.6480.9 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-advance-payment-ticket/save-edit', '{"ErpAdvancePaymentTickets":{"id":"2","auto_id":"2133","auto_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","auto_type":"client","handler":"1001","from_date":"2025-09-15","serial_no":"YFKD-20250915-00001","abstract":"f\u53f2\u8482\u592b","files":["28158"],"attachmentFile":{"28158":"\u56fe\u7247.png"},"description":"\u4e09\u5206\u5927\u8d5b","client_id":"2133","client_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","supplier_id":"","supplier_name":"","erpAdvancePaymentTicketVerifyRels":"","erpAdvancePaymentTicketBankOuts":[{"amount":"22.97","id":"1","description":""}],"erpAdvancePaymentTicketApprovePaymentSettles":""},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9884\u4ed8\u6b3e\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-15 16:01:49') RETURNING "id"
16:01:49.5720.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" ("erp_advance_payment_ticket_id", "erp_bank_id", "amount", "description") VALUES (2, 1, '22.97', '')
16:01:49.5750.9 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.5920.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115322.97' WHERE "id"=1
16:01:49.5790.8 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))
16:01:49.5990.8 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.5930.7 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, '114.246.237.213')
16:01:49.5960.7 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, '114.246.237.213')
16:01:49.5960.7 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, '114.246.237.213')
16:01:49.6470.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1438, "last_visit_at"='now()' WHERE "id"=56557
16:01:49.5760.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "next_verify_user"=NULL, "updated_at"='now()' WHERE "id"=2
16:01:49.5770.7 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.5950.7 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
16:01:49.5980.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "settle_amount"='0' WHERE "id"=2
16:01:49.6010.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "paid_amount"='0', "un_paid_amount"='22.97' WHERE "id"=2
16:01:49.5860.7 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)
16:01:49.6160.7 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
16:01:49.6040.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=2
16:01:49.6220.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "paid_amount"='0', "un_paid_amount"='22.97' WHERE "id"=2
16:01:49.6140.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115322.97' WHERE "id"=1
16:01:49.6020.7 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.5740.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "amount"='22.97' WHERE "id"=2
16:01:49.6190.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "settle_amount"='0' WHERE "id"=2
16:01:49.6150.7 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, '114.246.237.213')
16:01:49.6040.7 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\ErpAdvancePaymentTickets', 2, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.246.237.213')
16:01:49.6230.7 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.6290.7 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\Comments', 191363, 'a:11:{s:2:"id";i:191363;s:9:"object_id";i:2;s:11:"object_type";s:5:"20019";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:19:"YFKD-20250915-00001";}', '', 1001, '114.246.237.213')
16:01:49.6170.7 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, '114.246.237.213')
16:01:49.6180.7 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, '114.246.237.213')
16:01:49.6200.7 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213')
16:01:49.6380.7 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\ErpTicketChangeLogs', 534, 'a:17:{s:2:"id";i:534;s:9:"serial_no";s:19:"YFKD-20250915-00001";s:11:"ticket_type";i:20019;s:10:"wrote_date";s:10:"2025-09-15";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:2133;s:8:"abstract";s:10:"f史蒂夫";s:11:"description";s:12:"三分大赛";s:9:"verify_at";s:29:"2025-09-15 16:01:49.604228+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 16:00:55";s:10:"updated_at";s:19:"2025-09-15 16:01:49";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:5:"22.97";s:9:"object_id";i:2;}', '', 1001, '114.246.237.213')
16:01:49.5710.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.5840.6 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))
16:01:49.5680.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.5850.6 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))
16:01:49.6330.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2133
16:01:49.5520.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_advance_payment_ticket_id"=2) ORDER BY "id"
16:01:49.5870.6 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))
16:01:49.5880.6 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)
16:01:49.5510.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"='2'
16:01:49.5540.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2133')
16:01:49.5940.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
16:01:49.5910.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))
16:01:49.5890.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)
16:01:49.5900.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)
16:01:49.5800.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))
16:01:49.5890.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)
16:01:49.6000.5 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_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.6000.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.5810.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))
16:01:49.6110.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)
16:01:49.5700.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.5840.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)
16:01:49.6110.3 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))
16:01:49.6100.3 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))
16:01:49.5560.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.6320.3 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1013, 5388)) AND ("id" != 1001) AND (channel_id IS NOT NULL)
16:01:49.5650.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.6100.3 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))
16:01:49.6220.3 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_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.6100.3 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)
16:01:49.6030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.6320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.6070.3 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))
16:01:49.6060.3 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))
16:01:49.5700.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.6130.3 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)
16:01:49.6240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.5660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:01:49.6210.3 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5))
16:01:49.6120.3 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)
16:01:49.6250.3 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name"='Treasurer'
16:01:49.5730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.6070.3 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))
16:01:49.6140.3 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))
16:01:49.6120.3 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)
16:01:49.6130.3 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)
16:01:49.6340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.6280.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:01:49.5690.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.6270.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.6240.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.6210.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.6190.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.5550.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:01:49.5780.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.5550.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001')
16:01:49.5970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.5990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2
16:01:49.6160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
16:01:49.5750.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("erp_advance_payment_ticket_id"=2) AND ("status"=0) ORDER BY "id"
16:01:49.6060.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.6030.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("status"=0) AND ("erp_advance_payment_ticket_id"=2) ORDER BY "id"
16:01:49.6250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.5780.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.6160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.5790.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.5650.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.6060.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.6050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.5710.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1'
16:01:49.5930.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
16:01:49.5780.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id"
16:01:49.6250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.5730.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2
16:01:49.5690.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2