68673b9c064cd: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit-cost at 2025-07-04 10:25:32 am by 114.254.1.137
Database Queries
总计37条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:25:32.029 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:25:32.032 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:25:32.035 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3851' |
| 10:25:32.038 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689') |
| 10:25:32.038 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 10:25:32.039 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 10:25:32.039 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=3851) ORDER BY "id" |
| 10:25:32.040 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=372 |
| 10:25:32.041 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='372' |
| 10:25:32.041 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3851) AND ("term_id"=18) AND ("object_type"=8) |
| 10:25:32.042 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 8, 372, '867867', '', 3851, 183) |
| 10:25:32.043 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=3851) |
| 10:25:32.045 | 1.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=3851) |
| 10:25:32.046 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=3851) |
| 10:25:32.047 | 1.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=3851) |
| 10:25:32.048 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851 |
| 10:25:32.049 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851 |
| 10:25:32.050 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=3851 |
| 10:25:32.050 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_purchase_client_rels" ("contract_id", "client_id", "project_id") VALUES (3851, 982, 1018) RETURNING "id" |
| 10:25:32.052 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseClientRels', 3144, 'a:4:{s:2:"id";i:3144;s:11:"contract_id";i:3851;s:9:"client_id";s:3:"982";s:10:"project_id";s:4:"1018";}', '', 1001, '114.254.1.137') |
| 10:25:32.054 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"='1018' |
| 10:25:32.055 | 0.5 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=3851 |
| 10:25:32.055 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=3851 |
| 10:25:32.055 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 10:25:32.056 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 10:25:32.056 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689') |
| 10:25:32.056 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 10:25:32.057 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 10:25:32.057 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=689, "amount"='867867', "handler"=1011, "updated_at"='now()', "including_tax"=TRUE WHERE "id"=3851 |
| 10:25:32.058 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 3851, 'a:0:{}', '', 1001, '114.254.1.137') |
| 10:25:32.059 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689' |
| 10:25:32.059 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689') |
| 10:25:32.060 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 10:25:32.060 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 10:25:32.060 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 3851, 'a:0:{}', '', 1001, '114.254.1.137') |
| 10:25:32.061 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='689' |
| 10:25:32.062 | 1.0 ms | INSERT | INSERT 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":"3851","supplier_id":"689","amount":"867867","handler":"1011","serial_no":"","signed_at":"2025-07-04","description":"","including_tax":"1","contractScans":"","receiptScans":"","purchaseClientRels":[{"client_id":"982","project_id":"1018"}],"PurchaseContractInvoices":"","costContractAmounts":[{"id":"372","amount":"867867","description":"","parent_id":"183"}]},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-07-04 10:25:32') RETURNING "id" |