ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68ca2e991c5d2: POST https://beta.jinchangxiao.com/vue/erp-cost-convert-ticket/save-edit at 2025-09-17 11:44:25 am by 114.244.128.96

Database Queries

总计50条数据
TimeDurationTypeQuery
  
11:44:25.1192.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:44:25.1221.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1250.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "id"='15'

[+] Explain
11:44:25.1260.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_cost_convert_ticket_id"=15) ORDER BY "id"

[+] Explain
11:44:25.1280.9 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "serial_no"='FYZSRD-20250917-00012' LIMIT 2

[+] Explain
11:44:25.1290.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
11:44:25.1290.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1300.9 msUPDATEUPDATE "a57be577deb434"."tbl_erp_cost_convert_tickets" SET "client_id"=NULL, "sales_contract_id"=NULL, "supplier_id"=NULL, "purchase_contract_id"=NULL WHERE "id"=15

[+] Explain
11:44:25.1311.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpCostConvertTickets', 15, 'a:0:{}', '', 1001, '114.244.128.96')

[+] Explain
11:44:25.1322.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20029) AND ("object_id"=15)

[+] Explain
11:44:25.1341.7 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20029) AND ("object_id"=15)

[+] Explain
11:44:25.1360.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE "erp_cost_convert_ticket_id"=15 ORDER BY "id"

[+] Explain
11:44:25.1370.7 msDELETEDELETE FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE "erp_cost_convert_ticket_id"=15

[+] Explain
11:44:25.1380.9 msINSERTINSERT INTO "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" ("erp_cost_convert_ticket_id", "user_id", "status") VALUES (15, 1001, 0)

[+] Explain
11:44:25.1390.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_carbon_copy_rels" WHERE "erp_cost_convert_ticket_id"=15

[+] Explain
11:44:25.1390.1 msDELETEDELETE FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_carbon_copy_rels" WHERE "erp_cost_convert_ticket_id"=15

[+] Explain
11:44:25.1390.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" WHERE "erp_cost_convert_ticket_id"=15

[+] Explain
11:44:25.1400.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1400.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001'

[+] Explain
11:44:25.1410.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5332'

[+] Explain
11:44:25.1410.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1421.0 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpCostConvertTicketHandlers', 15, 20016, 1001, 'now()', '[["\u5218\u4eba\u8bda:3\u5143","\u970d\u536b\u8d85:5\u5143"]]', '[["\u5218\u4eba\u8bda:3\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7ecf\u624b\u4eba","d4":["\u5218\u4eba\u8bda:3\u5143; <b>\u53d8\u4e3a<\/b> \u5218\u4eba\u8bda:3\u5143;\u970d\u536b\u8d85:5\u5143;"]}')

[+] Explain
11:44:25.1430.6 msDELETEDELETE FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" WHERE "erp_cost_convert_ticket_id"=15

[+] Explain
11:44:25.1431.0 msINSERTINSERT INTO "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" ("erp_cost_convert_ticket_id", "user_id", "amount", "pct") VALUES (15, 1001, '3', '37.5'), (15, 5332, '5', '62.5')

[+] Explain
11:44:25.1450.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=10) AND ("object_id"=15) ORDER BY "id"

[+] Explain
11:44:25.1460.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386

[+] Explain
11:44:25.1460.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='386'

[+] Explain
11:44:25.1460.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1470.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpCostConvertTicketAmounts', 15, 20016, 1001, 'now()', '[["\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:8\u5143"]]', '[["\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u7c7b\u578b","d4":["\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5\u5143; <b>\u53d8\u4e3a<\/b> \u8d44\u4ea7\u5904\u7f6e\u635f\u76ca:8\u5143;"]}')

[+] Explain
11:44:25.1480.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=15) AND ("term_id"=18) AND ("object_type"=10)

[+] Explain
11:44:25.1491.1 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "in_amount", "value", "object_id", "extra_int") VALUES (18, 10, 386, '8', '修复BUG 其他收入 费用转收入 收入科目冲突问题 影响范围 其他收入 费用转收入 增删改查', 15, 385)

[+] Explain
11:44:25.1500.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=20) AND ("object_type"=10) AND ("object_id"=15) ORDER BY "id"

[+] Explain
11:44:25.1500.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=402

[+] Explain
11:44:25.1500.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='402'

[+] Explain
11:44:25.1510.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1510.9 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpCostConvertTicketCollectAmounts', 15, 20016, 1001, 'now()', '[["\u8c03\u8d26\u6536\u5165:8\u5143"]]', '[["\u8c03\u8d26\u6536\u5165:\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u7c7b\u578b","d4":["\u8c03\u8d26\u6536\u5165:\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5\u5143; <b>\u53d8\u4e3a<\/b> \u8c03\u8d26\u6536\u5165:8\u5143;"]}')

[+] Explain
11:44:25.1520.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=15) AND ("term_id"=20) AND ("object_type"=10)

[+] Explain
11:44:25.1530.8 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (20, 10, 402, '8', '修复BUG 其他收入 费用转收入 收入科目冲突问题 影响范围 其他收入 费用转收入 增删改查', 15, 398)

[+] Explain
11:44:25.1540.7 msUPDATEUPDATE "a57be577deb434"."tbl_erp_cost_convert_tickets" SET "amount"='8' WHERE "id"=15

[+] Explain
11:44:25.1550.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpCostConvertTickets', 15, 'a:1:{s:6:"amount";i:8;}', '', 1001, '114.244.128.96')

[+] Explain
11:44:25.1550.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("erp_cost_convert_ticket_id"=15) AND ("status"=0) ORDER BY "id"

[+] Explain
11:44:25.1560.7 msUPDATEUPDATE "a57be577deb434"."tbl_erp_cost_convert_tickets" SET "updated_at"='now()' WHERE "id"=15

[+] Explain
11:44:25.1570.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpCostConvertTickets', 15, 'a:0:{}', '', 1001, '114.244.128.96')

[+] Explain
11:44:25.1570.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "id"=15

[+] Explain
11:44:25.1580.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:44:25.1580.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_convert_ticket_id"=15) ORDER BY "id"

[+] Explain
11:44:25.1600.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_convert_ticket_id"=15) ORDER BY "id"

[+] Explain
11:44:25.1613.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-17')

[+] Explain
11:44:25.1650.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=354, "last_visit_at"='now()' WHERE "id"=56609

[+] Explain
11:44:25.1661.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-cost-convert-ticket/save-edit', '{"ErpCostConvertTickets":{"id":"15","auto_id":"","auto_name":"","auto_type":"","auto_search_id":"","auto_search_name":"","wrote_date":"2025-09-17","serial_no":"FYZSRD-20250917-00012","erpCostConvertTicketVerifyRels":["1001"],"abstract":"\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \n\u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5","description":"\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \n\u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5","is_only_handler":"1","client_id":"","client_name":"","sales_contract_id":"","sales_contract_name":"","supplier_id":"","supplier_name":"","purchase_contract_id":"","purchase_contract_name":"","files":"","erpCostConvertTicketAmounts":[{"id":"386","amount":"8","description":"\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5","parent_id":"385"}],"erpCostConvertTicketCollectAmounts":[{"id":"402","amount":"8","description":"\u4fee\u590dBUG \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u6536\u5165\u79d1\u76ee\u51b2\u7a81\u95ee\u9898 \u5f71\u54cd\u8303\u56f4 \u5176\u4ed6\u6536\u5165 \u8d39\u7528\u8f6c\u6536\u5165 \u589e\u5220\u6539\u67e5","parent_id":"398"}],"erpCostConvertTicketHandlers":[{"user_id":"1001","amount":"3","pct":"37.5"},{"user_id":"5332","amount":"5","pct":"62.5"}]},"web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-17 11:44:25') RETURNING "id"

[+] Explain