Database Queries

总计7条数据
TimeDurationTypeQuery
  
20:45:34.3441.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5064

20:45:34.3470.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

20:45:34.3490.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

20:45:34.3500.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "sn"='1122'

20:45:34.3521.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id" IN (489, 493, 494, 496)

20:45:34.3530.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2261, 2269, 2262)

20:45:34.3561.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-outbound/check-scan-sn', '{"ErpSalesOutbounds":{"erpSalesOutboundProducts":{"new":[{"product_id":"2266","number":"","amount":"54","total_amount":"","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2255","erp_store_id":"1","is_check":"0","erpSalesOutboundSpentProducts":"","sns":""},{"product_id":"2261","number":"1","amount":"44433443","total_amount":"44433443","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2251","erp_store_id":"1","is_check":"0","erpSalesOutboundSpentProducts":[{"erp_inventory_product_id":"470","number":"1"}],"sns":[{"erp_inventory_product_sn_id":"36","erp_inventory_product_id":"470","sn":"klgjdsf534534"}]},{"product_id":"1372","number":"","amount":"53445","total_amount":"","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2252","erp_store_id":"1","is_check":"0","erpSalesOutboundSpentProducts":"","sns":""},{"product_id":"2265","number":"","amount":"53534","total_amount":"","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2253","erp_store_id":"1","is_check":"0","erpSalesOutboundSpentProducts":"","sns":""},{"product_id":"2263","number":"","amount":"44","total_amount":"","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2254","erp_store_id":"1","is_check":"0","erpSalesOutboundSpentProducts":"","sns":""}]}},"erp_sales_outbound_id":"","scan_sn":"1122","web_access_token":"wx4hXh9V-DIrZeBjtGStxgwx5HvDWnxk"}', '{"code":2000,"result":{"scan_result":{"scan_sn":"1122","status":0,"msg":"SN\u30101122\u3011\u5b58\u5728\u91cd\u590d\uff0c\u8bf7\u68c0\u67e5SN\u6570\u636e"},"scan_list":{"sns":[],"groups":[]}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-07-04 20:45:34', 14932736) RETURNING "id"