6899dd230d6ca: POST https://beta.jinchangxiao.com/vue/erp-cash-cost-ticket/save-edit at 2025-08-11 08:08:03 pm by 114.246.236.177
Database Queries
总计45条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 20:08:03.058 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 20:08:03.061 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:08:03.064 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"='7333' |
| 20:08:03.066 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_cash_cost_ticket_id"=7333) ORDER BY "id" |
| 20:08:03.069 | 1.8 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "serial_no"='XJFYD-20250811-00001' LIMIT 2 |
| 20:08:03.071 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431') |
| 20:08:03.072 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4080') |
| 20:08:03.072 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:08:03.073 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:08:03.073 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "client_id"=NULL, "sales_contract_id"=NULL, "supplier_id"=431, "purchase_contract_id"=4080 WHERE "id"=7333 |
| 20:08:03.075 | 3.4 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\ErpCashCostTickets', 7333, 'a:0:{}', '', 1001, '114.246.236.177') |
| 20:08:03.078 | 2.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=7333) |
| 20:08:03.080 | 1.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=7333) |
| 20:08:03.082 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id" |
| 20:08:03.084 | 1.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.085 | 2.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" ("erp_cash_cost_ticket_id", "user_id", "status") VALUES (7333, 1001, 0) |
| 20:08:03.088 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_carbon_copy_rels" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.088 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_carbon_copy_rels" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.088 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.089 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:08:03.090 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001' |
| 20:08:03.090 | 1.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.091 | 2.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" ("erp_cash_cost_ticket_id", "user_id", "amount", "pct") VALUES (7333, 1001, '111', '100') |
| 20:08:03.094 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=11) AND ("object_id"=7333) ORDER BY "id" |
| 20:08:03.094 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386 |
| 20:08:03.095 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='386' |
| 20:08:03.095 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7333) AND ("term_id"=18) AND ("object_type"=11) |
| 20:08:03.096 | 2.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 11, 386, '111', '', 7333, 385) |
| 20:08:03.099 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id" |
| 20:08:03.100 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 20:08:03.100 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1' |
| 20:08:03.101 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.101 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" ("erp_cash_cost_ticket_id", "erp_bank_id", "amount", "description") VALUES (7333, 1, '111', '') |
| 20:08:03.102 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id" |
| 20:08:03.103 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.103 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id" |
| 20:08:03.104 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4080 |
| 20:08:03.104 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4080' |
| 20:08:03.105 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333 |
| 20:08:03.106 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" ("erp_cash_cost_ticket_id", "purchase_contract_id", "amount") VALUES (7333, 4080, '111') RETURNING "id" |
| 20:08:03.107 | 1.3 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\ErpCashCostTicketPurchaseContractSettles', 10, 'a:5:{s:2:"id";i:10;s:23:"erp_cash_cost_ticket_id";i:7333;s:20:"purchase_contract_id";s:4:"4080";s:6:"amount";s:3:"111";s:11:"description";N;}', '', 1001, '114.246.236.177') |
| 20:08:03.108 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "amount"='111' WHERE "id"=7333 |
| 20:08:03.109 | 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\ErpCashCostTickets', 7333, 'a:0:{}', '', 1001, '114.246.236.177') |
| 20:08:03.110 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=7333 |
| 20:08:03.111 | 1.1 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/erp-cash-cost-ticket/save-edit', '{"ErpCashCostTickets":{"id":"7333","auto_id":"431","auto_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","auto_type":"supplier","auto_search_id":"4080","auto_search_name":"222222","wrote_date":"2025-08-11","serial_no":"XJFYD-20250811-00001","erpCashCostTicketVerifyRels":["1001"],"abstract":"\u65b9\u5f0f\u5730\u65b9","description":"","client_id":"","client_name":"","sales_contract_id":"","sales_contract_name":"","supplier_id":"431","supplier_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","purchase_contract_id":"4080","purchase_contract_name":"222222","files":"","erpCashCostTicketAmounts":[{"id":"386","amount":"111","description":"","parent_id":"385"}],"erpCashCostTicketBankOuts":[{"amount":"111","id":"1","description":""}],"erpCashCostTicketHandlers":[{"user_id":"1001","amount":"111","pct":"100"}],"erpCashCostTicketSalesContractSettles":"","erpCashCostTicketPurchaseContractSettles":[{"id":"","purchase_contract_id":"4080","amount":"111"}]},"web_access_token":"J23LUPtW6VCG7IfkCPCVdqFa_zEBghkd"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u73b0\u91d1\u8d39\u7528\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-11 20:08:03') RETURNING "id" |