689d7ab7d2faf: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit-cost at 2025-08-14 01:57:11 pm by 124.64.23.198
Database Queries
总计80条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 13:57:11.867 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 13:57:11.870 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:57:11.873 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4081' |
| 13:57:11.876 | 0.8 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='测试方式地方读书' LIMIT 2 |
| 13:57:11.877 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431') |
| 13:57:11.878 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 13:57:11.878 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5388) |
| 13:57:11.879 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'amount', 4081, 13, 1001, 'now()', '["53453\u5143"]', '["534530\u5143"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["534530\u5143 <b>\u53d8\u4e3a<\/b> 53453\u5143"]}'), (2, 'description', 4081, 13, 1001, 'now()', '["\u7a81\u71361"]', '["\u7a81\u7136"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5907\u6ce8","d4":["\u7a81\u71361"]}') |
| 13:57:11.881 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=4081) ORDER BY "id" |
| 13:57:11.882 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386 |
| 13:57:11.882 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='386' |
| 13:57:11.882 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'costContractAmounts', 4081, 13, 1001, 'now()', '[["\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:53453\u5143"]]', '[["\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:534530\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u4fe1\u606f","d4":["\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:534530\u5143; <b>\u53d8\u4e3a<\/b> \u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:53453\u5143;"]}') |
| 13:57:11.883 | 0.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4081) AND ("term_id"=18) AND ("object_type"=8) |
| 13:57:11.884 | 1.0 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, 386, '53453', '', 4081, 385) |
| 13:57:11.885 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4081) |
| 13:57:11.888 | 1.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4081) |
| 13:57:11.889 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4081) |
| 13:57:11.891 | 1.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4081) |
| 13:57:11.893 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4081 |
| 13:57:11.894 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4081 |
| 13:57:11.894 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4081 |
| 13:57:11.895 | 0.4 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4081 |
| 13:57:11.895 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4081 |
| 13:57:11.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=2390 |
| 13:57:11.896 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id"=2390) |
| 13:57:11.898 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id"=2390) |
| 13:57:11.900 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 13:57:11.900 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 13:57:11.900 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=431, "amount"='53453', "handler"=1011, "description"='突然1', "updated_at"='now()', "including_tax"=TRUE WHERE "id"=4081 |
| 13:57:11.901 | 1.0 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', 4081, 'a:2:{s:6:"amount";i:53453;s:11:"description";s:7:"突然1";}', '', 1001, '124.64.23.198') |
| 13:57:11.903 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431' |
| 13:57:11.903 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4081 |
| 13:57:11.904 | 0.8 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.905 | 0.6 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.906 | 0.7 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.907 | 0.7 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.907 | 0.3 ms | SELECT | 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"=4081) AND ("t"."status"=1)) |
| 13:57:11.908 | 0.4 ms | SELECT | 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"=4081) AND ("t"."status"=1)) |
| 13:57:11.908 | 0.4 ms | SELECT | 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"=4081) AND ("t"."status"=1) |
| 13:57:11.909 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='11', "erp_un_settle_amount"='53442' WHERE "id"=4081 |
| 13:57:11.910 | 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', 4081, 'a:1:{s:20:"erp_un_settle_amount";i:53442;}', '', 1001, '124.64.23.198') |
| 13:57:11.911 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 13:57:11.911 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4081 |
| 13:57:11.912 | 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\ErpPurchaseCosts', 6, 'a:0:{}', '', 1001, '124.64.23.198') |
| 13:57:11.913 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4081 |
| 13:57:11.913 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4081 |
| 13:57:11.914 | 0.3 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.915 | 0.3 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.915 | 0.4 ms | SELECT | 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"=4081) AND ("t"."status" IN (2, 5, 1)) |
| 13:57:11.916 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4081) AND (amount > paid_amount) ORDER BY "remind_date" |
| 13:57:11.917 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='11', "status"=1 WHERE "id"=827 |
| 13:57:11.918 | 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\PurchaseContractPaymentCollectionRemindDates', 827, 'a:2:{s:11:"paid_amount";s:1:"0";s:6:"status";i:1;}', '', 1001, '124.64.23.198') |
| 13:57:11.918 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4081 ORDER BY "id" |
| 13:57:11.919 | 0.8 ms | INSERT | INSERT 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', 431, 12, 4081, 13, 1001, '[4081]', '[4081]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u6d4b\u8bd5\u65b9\u5f0f\u5730\u65b9\u8bfb\u4e66"]}') RETURNING "id" |
| 13:57:11.920 | 0.7 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\ObjectChangeLogs', 553697, 'a:13:{s:2:"id";i:553697;s:9:"object_id";i:431;s:11:"object_type";i:12;s:9:"target_id";i:4081;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4081]";s:9:"new_value";s:6:"[4081]";s:11:"description";s:168:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u8d39\u7528\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:\u6d4b\u8bd5\u65b9\u5f0f\u5730\u65b9\u8bfb\u4e66"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '124.64.23.198') |
| 13:57:11.921 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_projects" WHERE "erp_purchase_cost_id"=6 |
| 13:57:11.921 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "is_verify"=TRUE WHERE "id"=4081 |
| 13:57:11.922 | 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', 4081, 'a:0:{}', '', 1001, '124.64.23.198') |
| 13:57:11.923 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431' |
| 13:57:11.923 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=8) AND ("object_id"=4081) ORDER BY "id" |
| 13:57:11.924 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" SET "status"=3 WHERE ("erp_purchase_cost_id"=6) AND ("status"=0) |
| 13:57:11.924 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE "erp_purchase_cost_id"=6 |
| 13:57:11.925 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "stop_at"='now()' WHERE "id"=6 |
| 13:57:11.926 | 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\ErpPurchaseCosts', 6, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '124.64.23.198') |
| 13:57:11.927 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=6) AND ("term_id"=18) AND ("object_type"=13) |
| 13:57:11.927 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 13, 386, '53453', '', 6, 385) |
| 13:57:11.928 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=21 |
| 13:57:11.929 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id) |
| 13:57:11.929 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" ("erp_purchase_cost_id", "user_id", "status") VALUES (6, 1001, 0) |
| 13:57:11.931 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("erp_purchase_cost_id"=6) AND ("status"=0) ORDER BY "id" |
| 13:57:11.931 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_purchase_costs" SET "status"=5, "next_stop_verify_user"=1001, "amount"='587983', "updated_at"='now()' WHERE "id"=6 |
| 13:57:11.932 | 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\ErpPurchaseCosts', 6, 'a:3:{s:6:"status";i:5;s:6:"amount";i:587983;s:21:"next_stop_verify_user";i:1001;}', '', 1001, '124.64.23.198') |
| 13:57:11.933 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5388 |
| 13:57:11.933 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_cost_id"=6) ORDER BY "id" |
| 13:57:11.934 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_cost_id"=6) ORDER BY "id" |
| 13:57:11.934 | 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\ErpPurchaseCosts', 6, 'a:0:{}', '', 1001, '124.64.23.198') |
| 13:57:11.935 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:57:11.935 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:57:11.936 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (11, 'status', 6, 20022, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u8d39\u7528\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 13:57:11.937 | 2.7 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":"4081","supplier_id":"431","amount":"53453","handler":"1011","serial_no":"\u6d4b\u8bd5\u65b9\u5f0f\u5730\u65b9\u8bfb\u4e66","signed_at":"2025-08-12","description":"\u7a81\u71361","including_tax":"1","contractScans":"","receiptScans":"","purchaseClientRels":"","PurchaseContractInvoices":{"2390":{"amount":"11","from_date":"2025-08-05","id":"2390","description":"","files":""}},"costContractAmounts":[{"id":"386","amount":"53453","description":"","parent_id":"385"}]},"web_access_token":"sV2F29tsogQonulyxXoXQL59i2Ir83nH"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-14 13:57:11') RETURNING "id" |