ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90335064e7: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit-cost at 2025-09-16 02:27:01 pm by 114.244.128.96

Performance Profiling

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

总计84条数据
TimeDurationCategoryInfo
  
14:27:01.0292.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
14:27:01.0492.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4087)
14:27:01.0472.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4087)
14:27:01.0271.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:27:01.0531.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4087)
14:27:01.0611.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id"=2398)
14:27:01.0591.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id"=2398)
14:27:01.0551.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4087)
14:27:01.0321.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
14:27:01.0401.3 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', 4087, 13, 1011, 'now()', '["660\u5143"]', '["66\u5143"]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["66\u5143 <b>\u53d8\u4e3a<\/b> 660\u5143"]}')
14:27:01.0641.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=262, "amount"='660', "handler"=1011, "updated_at"='now()', "including_tax"=TRUE WHERE "id"=4087
14:27:01.0461.1 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, '660', '', 4087, 307)
14:27:01.0521.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (108, 4087, 27458)
14:27:01.0951.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" ("erp_purchase_cost_id", "user_id", "status") VALUES (5, 1011, 0), (5, 1001, 0)
14:27:01.1021.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', 1011, 5, 'vue/purchase-contract/save-edit-cost', '{"PurchaseContracts":{"id":"4087","supplier_id":"262","amount":"660","handler":"1011","serial_no":"\u8ba2\u5355\u53f7\uff1a 320414542363","signed_at":"2025-08-11","description":"\u6280\u672f\u90e8\u81ea\u75282\u76d210\u7247*8X \u5149\u76d8","including_tax":"1","contractScans":["27458"],"contractFileList":{"27458":"image.png"},"receiptScans":"","purchaseClientRels":"","PurchaseContractInvoices":{"2398":{"amount":"66","from_date":"2025-08-11","id":"2398","description":"","files":["27459"]}},"costContractAmounts":[{"id":"356","amount":"660","description":"","parent_id":"307"}]},"web_access_token":"3M9IHFflx5fM6tRnS_F7r08k8HZ6t6eP"}', '{"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 14:27:01') RETURNING "id"
14:27:01.0651.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', 4087, 'a:1:{s:6:"amount";i:660;}', '', 1011, '114.244.128.96')
14:27:01.0861.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\ErpPurchaseCosts', 5, 'a:0:{}', '', 1011, '114.244.128.96')
14:27:01.0680.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"=4087) AND ("t"."status" IN (2, 5))
14:27:01.0790.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4087
14:27:01.0970.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "status"=5, "next_stop_verify_user"=1011, "amount"='660', "updated_at"='now()' WHERE "id"=5
14:27:01.0380.8 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='订单号： 320414542363' LIMIT 2
14:27:01.0440.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, 'costContractAmounts', 4087, 13, 1011, 'now()', '[["\u529e\u516c\u7528\u54c1:660\u5143"]]', '[["\u529e\u516c\u7528\u54c1:66\u5143"]]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u529e\u516c\u7528\u54c1:66\u5143; <b>\u53d8\u4e3a<\/b> \u529e\u516c\u7528\u54c1:660\u5143;"]}')
14:27:01.0700.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"=4087) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
14:27:01.0840.8 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', 262, 12, 4087, 13, 1011, '[4087]', '[4087]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8ba2\u5355\u53f7\uff1a 320414542363"]}') RETURNING "id"
14:27:01.0760.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "is_done"=FALSE WHERE "id"=5
14:27:01.0740.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\PurchaseContracts', 4087, 'a:1:{s:20:"erp_un_settle_amount";i:594;}', '', 1011, '114.244.128.96')
14:27:01.1010.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 (11, 'status', 5, 20022, 1011, 'now()', '["\u97e9\u96c5\u82b3"]', '[]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u7f16\u8f91\u4e86","d3":"\u8d39\u7528\u8ba2\u5355\u7533\u8bf7","d4":""}')
14:27:01.0880.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\PurchaseContracts', 4087, 'a:0:{}', '', 1011, '114.244.128.96')
14:27:01.0770.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', 5, 'a:1:{s:7:"is_done";b:1;}', '', 1011, '114.244.128.96')
14:27:01.0830.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\PurchaseContractPaymentCollectionRemindDates', 827, 'a:3:{s:11:"paid_amount";s:1:"0";s:12:"overdue_days";d:3;s:6:"status";i:0;}', '', 1011, '114.244.128.96')
14:27:01.0730.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='66', "erp_un_settle_amount"='594' WHERE "id"=4087
14:27:01.0930.7 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, '660', '', 5, 307)
14:27:01.0850.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', 565514, 'a:13:{s:2:"id";i:565514;s:9:"object_id";i:262;s:11:"object_type";i:12;s:9:"target_id";i:4087;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4087]";s:9:"new_value";s:6:"[4087]";s:11:"description";s:157:"{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u8ba2\u5355\u53f7\uff1a 320414542363"]}";s:10:"created_by";i:1011;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1011, '114.244.128.96')
14:27:01.0910.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "stop_at"='now()' WHERE "id"=5
14:27:01.0870.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contracts" SET "is_verify"=TRUE WHERE "id"=4087
14:27:01.0710.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"=4087) AND ("t"."status" IN (2, 5))
14:27:01.0820.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='66', "overdue_days"=3, "status"=1 WHERE "id"=827
14:27:01.0450.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4087) AND ("term_id"=18) AND ("object_type"=8)
14:27:01.0690.7 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"=4087) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE)
14:27:01.0980.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', 5, 'a:1:{s:6:"amount";i:660;}', '', 1011, '114.244.128.96')
14:27:01.0940.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id" IN ('1011', '1001')) AND ("user_status"='1') ORDER BY array_position(array[1011,1001], id)
14:27:01.1000.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', 5, 'a:0:{}', '', 1011, '114.244.128.96')
14:27:01.0920.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', 5, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1011, '114.244.128.96')
14:27:01.0750.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4087
14:27:01.0420.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=4087) ORDER BY "id"
14:27:01.0350.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4087'
14:27:01.0590.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=2398
14:27:01.0660.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='262'
14:27:01.0390.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='262')
14:27:01.0720.5 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"=4087) AND ("t"."status"=1))
14:27:01.0810.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"=4087) AND ("t"."status" IN (2, 5, 1))
14:27:01.0810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4087) AND (amount > paid_amount) ORDER BY "remind_date"
14:27:01.0580.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4087
14:27:01.0730.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"=4087) AND ("t"."status"=1)
14:27:01.0430.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=356
14:27:01.0560.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4087
14:27:01.0570.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4087
14:27:01.0710.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"=4087) AND ("t"."status"=1))
14:27:01.0940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=21
14:27:01.0800.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"=4087) AND ("t"."status" IN (2, 5, 1))
14:27:01.0800.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"=4087) AND ("t"."status" IN (2, 5, 1))
14:27:01.1010.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
14:27:01.0990.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
14:27:01.1000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
14:27:01.0900.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" SET "status"=3 WHERE ("erp_purchase_cost_id"=5) AND ("status"=0)
14:27:01.0840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4087 ORDER BY "id"
14:27:01.0670.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4087
14:27:01.0900.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=4087) ORDER BY "id"
14:27:01.0900.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE "erp_purchase_cost_id"=5
14:27:01.0390.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011')
14:27:01.0870.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_projects" WHERE "erp_purchase_cost_id"=5
14:27:01.0780.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4087
14:27:01.0400.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
14:27:01.0580.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4087
14:27:01.0750.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=262
14:27:01.0890.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='262'
14:27:01.0570.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4087
14:27:01.0960.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("erp_purchase_cost_id"=5) AND ("status"=0) ORDER BY "id"
14:27:01.0630.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1
14:27:01.0990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_cost_id"=5) ORDER BY "id"
14:27:01.0990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_cost_id"=5) ORDER BY "id"
14:27:01.0440.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='356'
14:27:01.0920.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=5) AND ("term_id"=18) AND ("object_type"=13)
14:27:01.0630.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1