ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7aee9c5db6: POST https://beta.jinchangxiao.com/vue/erp-other-income-ticket/save-edit at 2025-09-15 02:15:05 pm by 114.246.237.213

Performance Profiling

Total processing time: 81 ms; Peak memory: 6.765 MB. Show Profiling Timeline

总计74条数据
TimeDurationCategoryInfo
  
14:15:05.8823.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
14:15:05.8582.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)
14:15:05.8142.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:15:05.8292.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20027) AND ("object_id"=8)
14:15:05.8462.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=8
14:15:05.8251.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "client_id"=2133, "sales_contract_id"=NULL, "supplier_id"=NULL, "purchase_contract_id"=NULL, "need_handler"=FALSE WHERE "id"=8
14:15:05.8121.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:15:05.8311.9 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20027) AND ("object_id"=8)
14:15:05.8761.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "settle_amount"='0' WHERE "id"=8
14:15:05.8171.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:15:05.8861.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=854, "last_visit_at"='now()' WHERE "id"=56557
14:15:05.8741.5 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')
14:15:05.8881.2 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":"8","auto_id":"2133","auto_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","auto_type":"client","need_handler":"0","auto_search_id":"","auto_search_name":"","wrote_date":"2025-09-15","serial_no":"QTSR-20250915-00002","erpOtherIncomeTicketVerifyRels":["1001"],"abstract":"","description":"","client_id":"2133","client_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_contract_id":"","sales_contract_name":"","supplier_id":"","supplier_name":"","purchase_contract_id":"","purchase_contract_name":"","files":"","erpOtherIncomeTicketAmounts":[{"id":"399","amount":"65","description":"","parent_id":"398"}],"erpOtherIncomeTicketBankIns":[{"amount":"65","id":"1","description":""}],"erpOtherIncomeTicketHandlers":"","erpOtherIncomeTicketPurchaseContractSettles":""},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"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-15 14:15:05') RETURNING "id"
14:15:05.8281.1 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', 8, 'a:0:{}', '', 1001, '114.246.237.213')
14:15:05.8421.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8) AND ("term_id"=20)
14:15:05.8351.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" ("erp_other_income_ticket_id", "user_id", "status") VALUES (8, 1001, 0)
14:15:05.8431.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "in_amount", "value", "object_id", "extra_int") VALUES (20, 399, '65', '', 8, 398)
14:15:05.8381.0 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, 'erpOtherIncomeTicketHandlers', 8, 20015, 1001, 'now()', '[["\u516c\u53f8\u6536\u5165"]]', '[["\u5218\u4eba\u8bda:65\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7ecf\u624b\u4eba","d4":["\u5218\u4eba\u8bda:65\u5143; <b>\u53d8\u4e3a<\/b> \u516c\u53f8\u6536\u5165;"]}')
14:15:05.8481.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" ("erp_other_income_ticket_id", "erp_bank_id", "amount", "description") VALUES (8, 1, '65', '')
14:15:05.8531.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\ErpOtherIncomeTickets', 8, 'a:0:{}', '', 1001, '114.246.237.213')
14:15:05.8720.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\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '114.246.237.213')
14:15:05.8220.9 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "serial_no"='QTSR-20250915-00002' LIMIT 2
14:15:05.8680.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115432.97' WHERE "id"=1
14:15:05.8780.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\ErpOtherIncomeTickets', 8, 'a:0:{}', '', 1001, '114.246.237.213')
14:15:05.8690.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.246.237.213')
14:15:05.8510.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\ErpOtherIncomeTickets', 8, 'a:0:{}', '', 1001, '114.246.237.213')
14:15:05.8500.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "amount"='65' WHERE "id"=8
14:15:05.8520.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_other_income_tickets" SET "updated_at"='now()' WHERE "id"=8
14:15:05.8720.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
14:15:05.8630.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)
14:15:05.8340.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE "erp_other_income_ticket_id"=8
14:15:05.8390.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" WHERE "erp_other_income_ticket_id"=8
14:15:05.8620.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))
14:15:05.8640.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))
14:15:05.8210.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_other_income_ticket_id"=8) ORDER BY "id"
14:15:05.8600.6 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)
14:15:05.8550.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))
14:15:05.8750.6 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"=8) AND ("t"."status" IN (2, 5))
14:15:05.8240.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2133')
14:15:05.8610.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))
14:15:05.8680.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))
14:15:05.8650.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)
14:15:05.8710.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71
14:15:05.8670.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)
14:15:05.8560.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))
14:15:05.8650.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)
14:15:05.8660.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)
14:15:05.8200.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "id"='8'
14:15:05.8400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=20) AND ("object_id"=8) ORDER BY "id"
14:15:05.8570.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))
14:15:05.8410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=399
14:15:05.8450.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
14:15:05.8790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:15:05.8490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=8 ORDER BY "id"
14:15:05.8370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:15:05.8250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:15:05.8380.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:15:05.8440.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=8 ORDER BY "id"
14:15:05.8360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_carbon_copy_rels" WHERE "erp_other_income_ticket_id"=8
14:15:05.8360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" WHERE "erp_other_income_ticket_id"=8
14:15:05.8540.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_tickets" WHERE "id"=8
14:15:05.8240.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
14:15:05.8810.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("status"=0) AND ("erp_other_income_ticket_id"=8) ORDER BY "id"
14:15:05.8520.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("erp_other_income_ticket_id"=8) AND ("status"=0) ORDER BY "id"
14:15:05.8420.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='399'
14:15:05.8330.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE "erp_other_income_ticket_id"=8 ORDER BY "id"
14:15:05.8790.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" WHERE ("status"=0) AND ("erp_other_income_ticket_id"=8) ORDER BY "id"
14:15:05.8550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
14:15:05.8540.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=8 ORDER BY "id"
14:15:05.8700.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
14:15:05.8460.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1'
14:15:05.8550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_other_income_ticket_id"=8 ORDER BY "id"
14:15:05.8500.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" WHERE "erp_other_income_ticket_id"=8
14:15:05.8360.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_other_income_ticket_carbon_copy_rels" WHERE "erp_other_income_ticket_id"=8