68c90d897df49: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit at 2025-09-16 03:11:05 pm by 114.244.128.96
Performance Profiling
Total processing time: 67 ms; Peak memory: 5.856 MB. Show Profiling Timeline
总计54条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 15:11:05.533 | 4.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4141) |
| 15:11:05.543 | 3.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4141) |
| 15:11:05.550 | 3.2 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_purchase_client_rels" ("contract_id", "client_id", "project_id") VALUES (4141, 1661, 1791) RETURNING "id" |
| 15:11:05.540 | 3.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4141) |
| 15:11:05.538 | 2.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4141) |
| 15:11:05.519 | 2.3 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1011 |
| 15:11:05.517 | 1.9 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:11:05.522 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 15:11:05.530 | 1.5 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='而特热舞' LIMIT 2 |
| 15:11:05.556 | 1.2 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_supplier_rels" ("contract_id", "supplier_id", "purchase_id") VALUES (1558, 431, 4141) RETURNING "id" |
| 15:11:05.573 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='45', "erp_un_settle_amount"='10257' WHERE "id"=4141 |
| 15:11:05.553 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseClientRels', 3808, 'a:4:{s:2:"id";i:3808;s:11:"contract_id";i:4141;s:9:"client_id";s:4:"1661";s:10:"project_id";s:4:"1791";}', '', 1011, '114.244.128.96') |
| 15:11:05.580 | 1.0 ms | yii\db\Command::query | INSERT 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', '{"PurchaseContracts":{"id":"4141","supplier_id":"431","is_draft":"0","amount":"10302","handler":"1011","contract_type":"1","serial_no":"\u800c\u7279\u70ed\u821e","signed_at":"2025-09-12","description":"","including_tax":"1","product_number":"3","product_amount":"10302","purchaseContractProductRels":{"99":{"product_id":"1040","number":"3","amount":"3434","total_amount":"10302.00","erp_store_id":"","description":""}},"contractScans":"","receiptScans":"","purchaseClientRels":[{"client_id":"1661","project_id":"1791"}],"PurchaseContractInvoices":""},"web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"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 15:11:05') RETURNING "id" |
| 15:11:05.574 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 4141, 'a:0:{}', '', 1011, '114.244.128.96') |
| 15:11:05.560 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=431, "contract_type"=1, "handler"=1011, "updated_at"='now()', "including_tax"=TRUE, "is_draft"=FALSE WHERE "id"=4141 |
| 15:11:05.549 | 0.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4141 |
| 15:11:05.566 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContractProductRels', 99, 'a:0:{}', '', 1011, '114.244.128.96') |
| 15:11:05.555 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"='1791' |
| 15:11:05.567 | 0.8 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5)) |
| 15:11:05.548 | 0.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4141 |
| 15:11:05.569 | 0.8 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 15:11:05.557 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesSupplierRels', 3212, 'a:4:{s:2:"id";i:3212;s:11:"contract_id";i:1558;s:11:"supplier_id";s:3:"431";s:11:"purchase_id";i:4141;}', '', 1011, '114.244.128.96') |
| 15:11:05.561 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 4141, 'a:1:{s:8:"is_draft";s:1:"0";}', '', 1011, '114.244.128.96') |
| 15:11:05.570 | 0.7 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5)) |
| 15:11:05.565 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_product_rels" SET "product_id"=1040 WHERE "id"=99 |
| 15:11:05.568 | 0.7 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE) |
| 15:11:05.525 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4141' |
| 15:11:05.531 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431') |
| 15:11:05.578 | 0.5 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5, 1)) |
| 15:11:05.547 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4141 |
| 15:11:05.563 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1040 |
| 15:11:05.572 | 0.4 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status"=1)) |
| 15:11:05.579 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4141) AND (amount > paid_amount) ORDER BY "remind_date" |
| 15:11:05.575 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4141 |
| 15:11:05.558 | 0.4 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4141 |
| 15:11:05.572 | 0.4 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status"=1) |
| 15:11:05.562 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431' |
| 15:11:05.577 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4141 |
| 15:11:05.532 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 15:11:05.578 | 0.3 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5, 1)) |
| 15:11:05.577 | 0.3 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status" IN (2, 5, 1)) |
| 15:11:05.571 | 0.3 ms | yii\db\Command::query | SELECT 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"=4141) AND ("t"."status"=1)) |
| 15:11:05.562 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4141 |
| 15:11:05.533 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 15:11:05.567 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4141 |
| 15:11:05.576 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4141 |
| 15:11:05.559 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4141 |
| 15:11:05.564 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1040' |
| 15:11:05.575 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 15:11:05.559 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 15:11:05.564 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "id"=99 |
| 15:11:05.564 | 0.1 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4141 |
| 15:11:05.559 | 0.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 15:11:05.567 | 0.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE 0=1 |