ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68ca2f3cf0dd6: POST https://beta.jinchangxiao.com/vue/erp-other-income-ticket/save-edit at 2025-09-17 11:47:08 am by 114.244.128.96

Performance Profiling

Total processing time: 99 ms; Peak memory: 5.594 MB. Show Profiling Timeline

总计117条数据
TimeDurationCategoryInfo
  
11:47:09.0783.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-17')
11:47:09.0352.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)
11:47:08.9902.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:47:09.0122.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20027) AND ("object_id"=17)
11:47:08.9881.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:47:09.0601.8 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)
11:47:09.0151.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20027) AND ("object_id"=17)
11:47:08.9931.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0031.4 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, 'serial_no', 17, 20015, 1001, 'now()', '["QTSR-20250917-00004"]', '["QTSR-20250917-00003"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7f16\u53f7","d4":["QTSR-20250917-00003 <b>\u53d8\u4e3a<\/b> QTSR-20250917-00004"]}'), (2, 'sales_contract_id', 17, 20015, 1001, 'now()', '["TSKJ20200602-HYF-004"]', '[null]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> TSKJ20200602-HYF-004"]}')
11:47:09.0751.4 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, 20015, 'QTSR-20250917-00004', '2025-09-17', '', '', '9000', 1661, NULL, NULL, NULL, 1001, '2025-09-17 11:47:09', '2025-09-17 11:47:09', 17, '2025-09-17 11:47:09.056504+08') RETURNING "id"
11:47:09.0401.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)
11:47:09.0071.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "serial_no"='QTSR-20250917-00004', "client_id"=1661, "sales_contract_id"=1558, "supplier_id"=NULL, "purchase_contract_id"=NULL, "status"=1, "created_at"='now()', "need_handler"=FALSE WHERE "id"=17
11:47:09.0221.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "in_amount", "value", "object_id", "extra_int") VALUES (20, 14, 399, '9000', '', 17, 398)
11:47:09.0831.0 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-other-income-ticket/save-edit', '{"ErpOtherIncomeTickets":{"id":"17","auto_id":"1661","auto_name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","auto_type":"client","need_handler":"0","auto_search_id":"1558","auto_search_name":"TSKJ20200602-HYF-004(2020-06-23)","wrote_date":"2025-09-17","serial_no":"QTSR-20250917-00003","abstract":"","description":"","client_id":"1661","client_name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_contract_id":"1558","sales_contract_name":"TSKJ20200602-HYF-004(2020-06-23)","supplier_id":"","supplier_name":"","purchase_contract_id":"","purchase_contract_name":"","files":"","erpOtherIncomeTicketVerifyRels":"","erpOtherIncomeTicketAmounts":[{"id":"399","amount":"9000","description":"","parent_id":"398"}],"erpOtherIncomeTicketBankIns":[{"amount":"21","id":"1","description":""}],"erpOtherIncomeTicketHandlers":"","erpOtherIncomeTicketPurchaseContractSettles":""},"web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5176\u4ed6\u6536\u5165\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-17 11:47:09') RETURNING "id"
11:47:09.0090.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\ErpOtherIncomeTickets', 17, 'a:3:{s:9:"serial_no";s:19:"QTSR-20250917-00004";s:9:"client_id";s:4:"1661";s:17:"sales_contract_id";s:4:"1558";}', '', 1001, '114.244.128.96')
11:47:08.9980.9 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "serial_no"='QTSR-20250917-00003' LIMIT 2
11:47:09.0260.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" ("erp_other_income_ticket_id", "erp_bank_id", "amount", "description") VALUES (17, 1, '21', '')
11:47:09.0530.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "settle_amount"='0' WHERE "id"=17
11:47:09.0470.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='30.999999999767' WHERE "id"=1
11:47:09.0110.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 17, 20015, 1001, '2025-09-17 11:47:09', '{"id":17,"serial_no":"QTSR-20250917-00004","wrote_date":"2025-09-17","client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-17 11:47:09","updated_at":"2025-09-17 11:45:23","paid_amount":null,"need_handler":false}', '{"id":17,"serial_no":"QTSR-20250917-00004","wrote_date":"2025-09-17","client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-17 11:47:09","updated_at":"2025-09-17 11:45:23","paid_amount":null,"need_handler":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5176\u4ed6\u6536\u5165\u5355\u7533\u8bf7","d4":[]}') RETURNING "id"
11:47:09.0670.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\ErpBanks', 1, 'a:1:{s:14:"balance_amount";d:51.999999999767169;}', '', 1001, '114.244.128.96')
11:47:09.0480.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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.244.128.96')
11:47:09.0060.8 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, 'unit', 17, 20015, 1001, 'now()', '["\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"]', '[""]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5f80\u6765\u5355\u4f4d","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"]}')
11:47:09.0500.8 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
11:47:09.0720.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "settle_amount"='21' WHERE "id"=17
11:47:09.0250.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, 'erpOtherIncomeTicketBankIns', 17, 20015, 1001, 'now()', '[["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:21\u5143"]]', '[["(\u672a\u8bbe\u7f6e):\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u4fe1\u606f","d4":["(\u672a\u8bbe\u7f6e):\u5143; <b>\u53d8\u4e3a<\/b> \u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:21\u5143;"]}')
11:47:09.0200.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, 'erpOtherIncomeTicketAmounts', 17, 20015, 1001, 'now()', '[["\u5229\u606f\u6536\u5165:9000\u5143"]]', '[["(\u672a\u8bbe\u7f6e):\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u7c7b\u578b","d4":["(\u672a\u8bbe\u7f6e):\u5143; <b>\u53d8\u4e3a<\/b> \u5229\u606f\u6536\u5165:9000\u5143;"]}')
11:47:09.0290.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\ErpOtherIncomeTickets', 17, 'a:1:{s:6:"amount";i:9000;}', '', 1001, '114.244.128.96')
11:47:09.0310.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\ErpOtherIncomeTickets', 17, 'a:0:{}', '', 1001, '114.244.128.96')
11:47:09.0560.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=17
11:47:09.0820.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=419, "last_visit_at"='now()' WHERE "id"=56609
11:47:09.0120.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\ObjectChangeLogs', 570673, 'a:13:{s:2:"id";i:570673;s:9:"object_id";i:17;s:11:"object_type";i:20015;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:553:"{"id":17,"serial_no":"QTSR-20250917-00004","wrote_date":"2025-09-17","client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-17 11:47:09","updated_at":"2025-09-17 11:45:23","paid_amount":null,"need_handler":false}";s:9:"new_value";s:553:"{"id":17,"serial_no":"QTSR-20250917-00004","wrote_date":"2025-09-17","client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-17 11:47:09","updated_at":"2025-09-17 11:45:23","paid_amount":null,"need_handler":false}";s:11:"description";s:111:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5176\u4ed6\u6536\u5165\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-17 11:47:09";s:9:"is_delete";N;}', '', 1001, '114.244.128.96')
11:47:09.0510.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.244.128.96')
11:47:09.0300.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "updated_at"='now()' WHERE "id"=17
11:47:09.0280.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "amount"='9000' WHERE "id"=17
11:47:09.0530.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_income_ticket_id"=17) AND ("t"."status" IN (2, 5))
11:47:09.0380.7 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)
11:47:09.0660.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='51.999999999767' WHERE "id"=1
11:47:09.0730.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\ErpOtherIncomeTickets', 17, 'a:1:{s:13:"settle_amount";i:21;}', '', 1001, '114.244.128.96')
11:47:09.0630.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)
11:47:09.0690.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:1:{s:14:"balance_amount";s:15:"51.999999999767";}', '', 1001, '114.244.128.96')
11:47:09.0700.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.244.128.96')
11:47:09.0760.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', 586, 'a:17:{s:2:"id";i:586;s:9:"serial_no";s:19:"QTSR-20250917-00004";s:11:"ticket_type";i:20015;s:10:"wrote_date";s:10:"2025-09-17";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:1661;s:8:"abstract";s:0:"";s:11:"description";s:0:"";s:9:"verify_at";s:29:"2025-09-17 11:47:09.056504+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-17 11:47:09";s:10:"updated_at";s:19:"2025-09-17 11:47:09";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:4:"9000";s:9:"object_id";i:17;}', '', 1001, '114.244.128.96')
11:47:09.0390.7 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))
11:47:09.0690.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_account_captions" SET "balance_amount"='51.999999999767', "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71
11:47:09.0210.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=17) AND ("term_id"=20) AND ("object_type"=14)
11:47:09.0520.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.244.128.96')
11:47:09.0570.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\ErpOtherIncomeTickets', 17, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.244.128.96')
11:47:09.0390.7 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))
11:47:09.0540.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\ErpOtherIncomeTickets', 17, 'a:0:{}', '', 1001, '114.244.128.96')
11:47:09.0420.7 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))
11:47:09.0250.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=17
11:47:09.0050.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661'
11:47:08.9970.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_other_income_ticket_id"=17) ORDER BY "id"
11:47:09.0430.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)
11:47:09.0340.6 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))
11:47:09.0440.6 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)
11:47:09.0460.6 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))
11:47:08.9990.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='1661')
11:47:09.0450.6 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)
11:47:09.0010.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE ("created_at" >= '2025-09-17 00:00:00') AND ("created_at" <= '2025-09-17 23:59:59') AND ("serial_no" ILIKE '%QTSR-20250917-%') AND (LENGTH(serial_no) = 19) ORDER BY "serial_no" DESC
11:47:09.0330.6 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))
11:47:09.0440.6 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)
11:47:08.9960.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "id"='17'
11:47:09.0180.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=20) AND ("object_type"=14) AND ("object_id"=17) ORDER BY "id"
11:47:09.0030.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='1558'
11:47:09.0720.4 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_income_ticket_id"=17) AND ("t"."status" IN (2, 5))
11:47:09.0490.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
11:47:09.0000.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='1558')
11:47:09.0240.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1'
11:47:09.0340.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))
11:47:09.0640.4 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))
11:47:09.0190.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='399'
11:47:09.0020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0580.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))
11:47:09.0060.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0620.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)
11:47:09.0630.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))
11:47:09.0230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0200.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0620.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))
11:47:09.0550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0590.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))
11:47:09.0240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0100.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:09.0590.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))
11:47:09.0640.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)
11:47:09.0660.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))
11:47:09.0650.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)
11:47:09.0650.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)
11:47:09.0650.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)
11:47:09.0180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" WHERE "erp_other_income_ticket_id"=17
11:47:09.0170.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_carbon_copy_rels" WHERE "erp_other_income_ticket_id"=17
11:47:09.0010.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
11:47:09.0740.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "id"=17
11:47:09.0100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "id"=17
11:47:09.0320.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "id"=17
11:47:09.0490.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
11:47:09.0680.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
11:47:09.0160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0330.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
11:47:09.0300.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("erp_other_income_ticket_id"=17) AND ("status"=0) ORDER BY "id"
11:47:09.0560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("status"=0) AND ("erp_other_income_ticket_id"=17) ORDER BY "id"
11:47:09.0580.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0320.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0580.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0680.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
11:47:09.0580.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
11:47:09.0320.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=17 ORDER BY "id"
11:47:09.0710.1 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=17
11:47:09.0710.1 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=17
11:47:09.0740.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" WHERE "erp_other_income_ticket_id"=17
11:47:09.0180.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" WHERE "erp_other_income_ticket_id"=17
11:47:09.0280.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=17
11:47:09.0170.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE "erp_other_income_ticket_id"=17
11:47:09.0170.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_carbon_copy_rels" WHERE "erp_other_income_ticket_id"=17