ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c92f067fc57: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit-cost at 2025-09-16 05:33:58 pm by 114.244.128.96

Performance Profiling

Total processing time: 80 ms; Peak memory: 5.802 MB. Show Profiling Timeline

总计83条数据
TimeDurationCategoryInfo
  
17:33:58.5262.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:33:58.5472.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4072)
17:33:58.5442.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4072)
17:33:58.5241.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:33:58.5581.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id"=2381)
17:33:58.5571.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id"=2381)
17:33:58.5501.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4072)
17:33:58.5521.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4072)
17:33:58.5301.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:33:58.5991.5 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/purchase-contract/save-edit-cost', '{"PurchaseContracts":{"id":"4072","supplier_id":"289","amount":"80000","handler":"1011","serial_no":"EBJ02507293121709","signed_at":"2025-07-30","description":"boss\u76f4\u8058\u4e00\u5e74\u8d26\u53f7\u6743\u9650\n\u7f16\u8f91\u62d2\u7edd\u540e\u53d8\u54738000","including_tax":"1","contractScans":["27169"],"contractFileList":{"27169":"\u5408\u540c.pdf"},"receiptScans":"","purchaseClientRels":"","PurchaseContractInvoices":{"2381":{"amount":"8000","from_date":"2025-07-30","id":"2381","description":"","files":["27170"]}},"costContractAmounts":[{"id":"356","amount":"80000","description":"Boss\u8d26\u53f7","parent_id":"307"}]},"web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-16 17:33:58') RETURNING "id"
17:33:58.5381.2 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, 'amount', 4072, 13, 1001, 'now()', '["80000\u5143"]', '["8000\u5143"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["8000\u5143 <b>\u53d8\u4e3a<\/b> 80000\u5143"]}')
17:33:58.5611.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=289, "amount"='80000', "handler"=1011, "updated_at"='now()', "including_tax"=TRUE WHERE "id"=4072
17:33:58.5431.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 8, 356, '80000', 'Boss账号', 4072, 307)
17:33:58.5621.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\PurchaseContracts', 4072, 'a:1:{s:6:"amount";i:80000;}', '', 1001, '114.244.128.96')
17:33:58.5491.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (108, 4072, 27169)
17:33:58.5411.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, 'costContractAmounts', 4072, 13, 1001, 'now()', '[["\u529e\u516c\u7528\u54c1:80000\u5143"]]', '[["\u529e\u516c\u7528\u54c1:8000\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u529e\u516c\u7528\u54c1:8000\u5143; <b>\u53d8\u4e3a<\/b> \u529e\u516c\u7528\u54c1:80000\u5143;"]}')
17:33:58.5650.9 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5))
17:33:58.5920.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" ("erp_purchase_cost_id", "user_id", "status") VALUES (4, 1001, 0)
17:33:58.5800.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 289, 12, 4072, 13, 1001, '[4072]', '[4072]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:EBJ02507293121709"]}') RETURNING "id"
17:33:58.5940.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "status"=5, "next_stop_verify_user"=1001, "amount"='80000', "updated_at"='now()' WHERE "id"=4
17:33:58.5750.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4072
17:33:58.5350.8 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='EBJ02507293121709' LIMIT 2
17:33:58.5900.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 13, 356, '80000', 'Boss账号', 4, 307)
17:33:58.5670.8 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
17:33:58.5870.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "stop_at"='now()' WHERE "id"=4
17:33:58.5820.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\ErpPurchaseCosts', 4, 'a:0:{}', '', 1001, '114.244.128.96')
17:33:58.5790.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\PurchaseContractPaymentCollectionRemindDates', 808, 'a:1:{s:12:"overdue_days";N;}', '', 1001, '114.244.128.96')
17:33:58.5860.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE "erp_purchase_cost_id"=4
17:33:58.5730.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\ErpPurchaseCosts', 4, 'a:0:{}', '', 1001, '114.244.128.96')
17:33:58.5980.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 (11, 'status', 4, 20022, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u8d39\u7528\u8ba2\u5355\u7533\u8bf7","d4":""}')
17:33:58.5710.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\PurchaseContracts', 4072, 'a:1:{s:20:"erp_un_settle_amount";i:72000;}', '', 1001, '114.244.128.96')
17:33:58.5810.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', 570639, 'a:13:{s:2:"id";i:570639;s:9:"object_id";i:289;s:11:"object_type";i:12;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:137:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:EBJ02507293121709"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.128.96')
17:33:58.5700.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='8000', "erp_un_settle_amount"='72000' WHERE "id"=4072
17:33:58.5840.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "is_verify"=TRUE WHERE "id"=4072
17:33:58.5780.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='8000', "overdue_days"=0, "status"=1 WHERE "id"=808
17:33:58.5680.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"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5))
17:33:58.5950.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\ErpPurchaseCosts', 4, 'a:3:{s:6:"status";i:5;s:6:"amount";i:80000;s:21:"next_stop_verify_user";i:1001;}', '', 1001, '114.244.128.96')
17:33:58.5970.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\ErpPurchaseCosts', 4, 'a:0:{}', '', 1001, '114.244.128.96')
17:33:58.5420.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4072) AND ("term_id"=18) AND ("object_type"=8)
17:33:58.5890.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4) AND ("term_id"=18) AND ("object_type"=13)
17:33:58.5330.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4072'
17:33:58.5840.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\PurchaseContracts', 4072, 'a:0:{}', '', 1001, '114.244.128.96')
17:33:58.5880.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\ErpPurchaseCosts', 4, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '114.244.128.96')
17:33:58.5720.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4072
17:33:58.5660.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE)
17:33:58.5910.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id)
17:33:58.5400.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=4072) ORDER BY "id"
17:33:58.5770.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4072) AND (amount > paid_amount) ORDER BY "remind_date"
17:33:58.5630.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='289'
17:33:58.5560.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=2381
17:33:58.5770.5 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))
17:33:58.5360.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='289')
17:33:58.5690.4 msyii\db\Command::querySELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1))
17:33:58.5700.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"."purchase_contract_id"=4072) AND ("t"."status"=1)
17:33:58.5550.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4072
17:33:58.5540.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4072
17:33:58.5400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=356
17:33:58.5690.3 msyii\db\Command::querySELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1))
17:33:58.5540.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4072
17:33:58.5760.3 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))
17:33:58.5910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=21
17:33:58.5950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
17:33:58.5980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:33:58.5760.3 msyii\db\Command::querySELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1))
17:33:58.5970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:33:58.5800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4072 ORDER BY "id"
17:33:58.5860.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" SET "status"=3 WHERE ("erp_purchase_cost_id"=4) AND ("status"=0)
17:33:58.5640.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072
17:33:58.5370.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')
17:33:58.5740.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072
17:33:58.5850.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=4072) ORDER BY "id"
17:33:58.5830.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_projects" WHERE "erp_purchase_cost_id"=4
17:33:58.5370.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
17:33:58.5720.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=289
17:33:58.5550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4072
17:33:58.5600.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1
17:33:58.5930.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("erp_purchase_cost_id"=4) AND ("status"=0) ORDER BY "id"
17:33:58.5850.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='289'
17:33:58.5960.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_cost_id"=4) ORDER BY "id"
17:33:58.5540.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4072
17:33:58.5960.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_cost_id"=4) ORDER BY "id"
17:33:58.5410.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='356'
17:33:58.5600.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1