ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6943aa01206d5: POST https://beta.jinchangxiao.com/vue/erp-sales-gift/save-new-sn at 2025-12-18 03:15:13 pm by 223.72.15.22

Database Queries

总计39条数据
TimeDurationTypeQuery
  
15:15:13.1586.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:15:13.1746.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:15:13.1832.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
15:15:13.1951.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"='226'

[+] Explain
15:15:13.1970.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=171

[+] Explain
15:15:13.20011.9 msINSERTINSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (171, '阿文企鹅')

[+] Explain
15:15:13.2130.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=87

[+] Explain
15:15:13.2140.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_inbound_id"=87

[+] Explain
15:15:13.2150.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=171

[+] Explain
15:15:13.2161.2 msUPDATEUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='142', "inventory"='142', "total_amount"='143704' WHERE "id"=226

[+] Explain
15:15:13.2181.4 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 226, 'a:1:{s:9:"inventory";s:3:"139";}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2190.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=171

[+] Explain
15:15:13.2200.6 msDELETEDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=226) AND ("erp_purchase_inbound_product_sn_id" NOT IN (13, 16))

[+] Explain
15:15:13.2210.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=226

[+] Explain
15:15:13.2222.8 msINSERTINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (226, 16, '阿文企鹅') RETURNING "id"

[+] Explain
15:15:13.2250.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSns', 19, 'a:21:{s:2:"id";i:19;s:24:"erp_inventory_product_id";i:226;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:16;s:2:"sn";s:12:"阿文企鹅";s:7:"is_used";N;s:11:"description";N;s:22:"erp_inventory_start_id";N;s:33:"erp_inventory_start_product_sn_id";N;s:22:"erp_inventory_build_id";N;s:33:"erp_inventory_build_product_sn_id";N;s:26:"used_erp_inventory_lost_id";N;s:27:"used_erp_inventory_build_id";N;s:37:"used_erp_inventory_lost_product_sn_id";N;s:44:"used_erp_inventory_build_spent_product_sn_id";N;s:26:"used_erp_sales_outbound_id";N;s:43:"used_erp_sales_outbound_spent_product_sn_id";N;s:31:"erp_purchase_gift_product_sn_id";N;s:20:"erp_purchase_gift_id";N;s:22:"used_erp_sales_gift_id";N;s:39:"used_erp_sales_gift_spent_product_sn_id";N;}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2260.6 msSELECTSELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=226

[+] Explain
15:15:13.2271.1 msUPDATEUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='139' WHERE "id"=226

[+] Explain
15:15:13.2280.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 226, 'a:1:{s:9:"inventory";d:139;}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2291.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'

[+] Explain
15:15:13.2310.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'

[+] Explain
15:15:13.2311.0 msUPDATEUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='140668' WHERE "id"=226

[+] Explain
15:15:13.2320.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 226, 'a:0:{}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2340.9 msUPDATEUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='3', "inventory"='139' WHERE "id"=171

[+] Explain
15:15:13.2350.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 171, 'a:0:{}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2361.8 msUPDATEUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id"=1624

[+] Explain
15:15:13.2380.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInbounds', 87, 'a:0:{}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2390.3 msUPDATEUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0' WHERE ("erp_purchase_inbound_id"=87) AND ("erp_purchase_inbound_product_id"<>171)

[+] Explain
15:15:13.2401.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2094

[+] Explain
15:15:13.2433.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2094

[+] Explain
15:15:13.2470.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id"=185

[+] Explain
15:15:13.2490.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=87

[+] Explain
15:15:13.2503.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id"=171

[+] Explain
15:15:13.2533.3 msUPDATEUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='142' WHERE "id"=185

[+] Explain
15:15:13.2572.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 185, 'a:0:{}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2594.2 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrders', 2094, 'a:0:{}', '', 1001, '223.72.15.22')

[+] Explain
15:15:13.2668.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-12-18')

[+] Explain
15:15:13.2772.6 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1056, "last_visit_at"='now()' WHERE "id"=59588

[+] Explain
15:15:13.2802.8 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-sales-gift/save-new-sn', '{"id":"226","sns":["\u963f\u6587\u4f01\u9e45"],"web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 15:15:13') RETURNING "id"

[+] Explain