Performance Profiling

Total processing time: 107 ms; Peak memory: 5.363 MB. Show Profiling Timeline

总计160条数据
TimeDurationCategoryInfo
  
21:40:20.0832.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1462.6 msyii\db\Command::queryINSERT 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/confirm-scan-sn', '{"ErpSalesOutbounds":{"erpSalesOutboundProducts":{"new":[{"product_id":"2261","number":"21","amount":"44433443","total_amount":"933102303.00","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":"","sns":""},{"product_id":"1372","number":"1","amount":"53445","total_amount":"53445.00","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":""},{"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":""}]}},"sns":[{"erp_inventory_product_sn_id":"68","erp_inventory_product_id":"44","sn":"\u6211\u8fd8\u6709\u70b9\u4e0d\u6562\u8bf4"},{"erp_inventory_product_sn_id":"89","erp_inventory_product_id":"470","sn":"123"},{"erp_inventory_product_sn_id":"86","erp_inventory_product_id":"470","sn":"000"}],"erp_sales_outbound_id":"","web_access_token":"wx4hXh9V-DIrZeBjtGStxgwx5HvDWnxk"}', '{"code":2000,"result":{"erpSalesOutboundProducts":[{"product_id":"2261","number":23,"amount":"44433443","total_amount":1021969189,"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":2,"id":"","erp_sales_outbound_id":"","erp_sales_outbound_product_id":"","product_id":"2261","description":"","amount":"44433443","total_amount":88866886,"cancel_number":"","cancel_amount":"","cancel_total_amount":"","product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-04 21:38:26","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-04 21:38:26.500733+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":52,"name":"\u534f\u4f5c","product_type":4,"order":16,"description":"","created_by":1013,"created_at":"2018-01-09 15:39:40","updated_at":"2018-01-09 15:39:40","pinyin_shortcut":"xz"},"productBrand":{"id":4,"name":"\u8054\u60f3","order":31,"description":"","created_by":1013,"created_at":"2017-02-08 16:43:46","updated_at":"2017-02-08 16:43:46","pinyin_shortcut":"lx"},"productSerie":{"id":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce","product_component":52,"product_brand":4,"order":1580,"description":"","created_by":1013,"created_at":"2026-01-29 14:34:00","updated_at":"2026-01-29 14:34:00","pinyin_shortcut":"qxmkf"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2261,"outbound":"17","number":"67","inventory":"50","avg_amount":"7157.2205000000000000","avg_total_amount":"292.7000000000000000","amount":"2927.000"}},"erpInventoryProduct":{"id":470,"product_id":2261,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-08","number":"56","outbound":"10","inventory":"46","amount":"45","total_amount":"2520","actual_amount":"45","actual_total_amount":"2070","is_build":false,"created_at":"2026-04-08 09:35:32","lost_outbound":"0","erp_inventory_start_id":32,"erp_inventory_start_product_id":49,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"1","sales_outbound":"5","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"4","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":"","product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-04 21:38:26","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-04 21:38:26.500733+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":52,"name":"\u534f\u4f5c","product_type":4,"order":16,"description":"","created_by":1013,"created_at":"2018-01-09 15:39:40","updated_at":"2018-01-09 15:39:40","pinyin_shortcut":"xz"},"productBrand":{"id":4,"name":"\u8054\u60f3","order":31,"description":"","created_by":1013,"created_at":"2017-02-08 16:43:46","updated_at":"2017-02-08 16:43:46","pinyin_shortcut":"lx"},"productSerie":{"id":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce","product_component":52,"product_brand":4,"order":1580,"description":"","created_by":1013,"created_at":"2026-01-29 14:34:00","updated_at":"2026-01-29 14:34:00","pinyin_shortcut":"qxmkf"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2261,"outbound":"17","number":"67","inventory":"50","avg_amount":"7157.2205000000000000","avg_total_amount":"292.7000000000000000","amount":"2927.000"}},"erpStore":{"id":1,"title":"\u62d3\u5b9e\u4ed3\u5e93","description":"","sort":1,"is_system":true,"is_delete":false,"created_by":1000,"created_at":"2025-08-01 23:14:16","updated_at":"2025-08-08 14:35:40"},"erpPurchaseInbound":{},"erpPurchaseGift":{},"erpInventoryStart":{"id":32,"serial_no":"QCKC-20260408-00001","wrote_date":"2026-04-08","handler":1001,"supplier_id":431,"erp_store_id":1,"status":0,"abstract":"","description":"\u6d4b\u8bd5\u4eba\u4e0e\u4eba\u4e0e\u4eba\u8c08\u4e00\u8c08\u4eba\u5458","number":"111","amount":"4995","cancel_number":"","cancel_amount":"","created_by":1001,"is_used":true,"is_settle":false,"created_at":"2026-04-08 09:35:32","updated_at":"2026-04-09 10:26:46","print_times":""},"erpInventoryBuild":{},"erpInventoryDisassemble":{},"erpInventoryOverflow":{}},"erpSalesOutboundSpentProductSns":[],"sns":[{"erp_inventory_product_sn_id":89,"erp_inventory_product_id":470,"sn":"123","id":"","erp_sales_outbound_spent_product_id":"","erp_sales_outbound_spent_product_sn_id":"","description":"","is_cancel":false},{"erp_inventory_product_sn_id":86,"erp_inventory_product_id":470,"sn":"000","id":"","erp_sales_outbound_spent_product_id":"","erp_sales_outbound_spent_product_sn_id":"","description":"","is_cancel":false}],"spent":{}}],"sns":[{"erp_inventory_product_sn_id":89,"erp_inventory_product_id":470,"sn":"123"},{"erp_inventory_product_sn_id":86,"erp_inventory_product_id":470,"sn":"000"}],"auto_outbound_number":21,"id":"","is_new":true,"erp_sales_outbound_id":"","erp_sales_order_id":1715,"outbound":"","erpSalesOutboundProductSns":[],"product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-04 21:38:26","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-04 21:38:26.500733+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":52,"name":"\u534f\u4f5c","product_type":4,"order":16,"description":"","created_by":1013,"created_at":"2018-01-09 15:39:40","updated_at":"2018-01-09 15:39:40","pinyin_shortcut":"xz"},"productBrand":{"id":4,"name":"\u8054\u60f3","order":31,"description":"","created_by":1013,"created_at":"2017-02-08 16:43:46","updated_at":"2017-02-08 16:43:46","pinyin_shortcut":"lx"},"productSerie":{"id":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce","product_component":52,"product_brand":4,"order":1580,"description":"","created_by":1013,"created_at":"2026-01-29 14:34:00","updated_at":"2026-01-29 14:34:00","pinyin_shortcut":"qxmkf"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2261,"outbound":"17","number":"67","inventory":"50","avg_amount":"7157.2205000000000000","avg_total_amount":"292.7000000000000000","amount":"2927.000"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"erpSalesOrderProduct":{"id":2251,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2261,"description":"","number":"22","outbound":"1","amount":"44433443","total_amount":"977535746","last_number":"22","last_amount":"44433443","last_total_amount":"977535746","cost":"45","total_cost":"45","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-04 21:38:26","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-04 21:38:26.500733+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":52,"name":"\u534f\u4f5c","product_type":4,"order":16,"description":"","created_by":1013,"created_at":"2018-01-09 15:39:40","updated_at":"2018-01-09 15:39:40","pinyin_shortcut":"xz"},"productBrand":{"id":4,"name":"\u8054\u60f3","order":31,"description":"","created_by":1013,"created_at":"2017-02-08 16:43:46","updated_at":"2017-02-08 16:43:46","pinyin_shortcut":"lx"},"productSerie":{"id":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce","product_component":52,"product_brand":4,"order":1580,"description":"","created_by":1013,"created_at":"2026-01-29 14:34:00","updated_at":"2026-01-29 14:34:00","pinyin_shortcut":"qxmkf"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2261,"outbound":"17","number":"67","inventory":"50","avg_amount":"7157.2205000000000000","avg_total_amount":"292.7000000000000000","amount":"2927.000"}},"un_outbound":44,"un_outbound_amount":"977535746"},"spent_total_amount":0,"avg_spent_amount":0,"pct":"","need_sn":21},{"product_id":"1372","number":2,"amount":"53445","total_amount":106890,"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":[{"erp_inventory_product_id":44,"number":1,"id":"","erp_sales_outbound_id":"","erp_sales_outbound_product_id":"","product_id":"1372","description":"","amount":"53445","total_amount":53445,"cancel_number":"","cancel_amount":"","cancel_total_amount":"","product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-04 21:25:19","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 21:25:19.277799+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6","product_type":4,"order":24,"description":"","created_by":1013,"created_at":"2017-03-23 12:04:19","updated_at":"2017-03-23 12:04:19","pinyin_shortcut":"wlsbpj"},"productBrand":{"id":134,"name":"\u7b2c\u4e09\u65b9","order":68,"description":"","created_by":1013,"created_at":"2023-08-03 09:20:44","updated_at":"2023-08-03 09:20:44","pinyin_shortcut":"dsf"},"productSerie":{"id":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_component":43,"product_brand":134,"order":868,"description":"","created_by":1013,"created_at":"2024-01-26 16:47:45","updated_at":"2024-01-26 16:47:45","pinyin_shortcut":"LCLCgxx5m"},"productUnit":{"id":6,"name":"\u6761","order":6,"description":"","created_by":1013,"created_at":"2023-08-11 16:00:58","updated_at":"2023-08-11 16:00:58"},"erpInventoryCount":{"product_id":1372,"outbound":"34","number":"49","inventory":"15","avg_amount":"19.0000000000000000","avg_total_amount":"47.5714285714285714","amount":"333"}},"erpInventoryProduct":{"id":44,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"13","outbound":"10","inventory":"3","amount":"25","total_amount":"325","actual_amount":"25","actual_total_amount":"75","is_build":false,"created_at":"2025-08-08 18:11:19","lost_outbound":"","erp_inventory_start_id":30,"erp_inventory_start_product_id":44,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"10","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":"","product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-04 21:25:19","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 21:25:19.277799+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6","product_type":4,"order":24,"description":"","created_by":1013,"created_at":"2017-03-23 12:04:19","updated_at":"2017-03-23 12:04:19","pinyin_shortcut":"wlsbpj"},"productBrand":{"id":134,"name":"\u7b2c\u4e09\u65b9","order":68,"description":"","created_by":1013,"created_at":"2023-08-03 09:20:44","updated_at":"2023-08-03 09:20:44","pinyin_shortcut":"dsf"},"productSerie":{"id":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_component":43,"product_brand":134,"order":868,"description":"","created_by":1013,"created_at":"2024-01-26 16:47:45","updated_at":"2024-01-26 16:47:45","pinyin_shortcut":"LCLCgxx5m"},"productUnit":{"id":6,"name":"\u6761","order":6,"description":"","created_by":1013,"created_at":"2023-08-11 16:00:58","updated_at":"2023-08-11 16:00:58"},"erpInventoryCount":{"product_id":1372,"outbound":"34","number":"49","inventory":"15","avg_amount":"19.0000000000000000","avg_total_amount":"47.5714285714285714","amount":"333"}},"erpStore":{"id":1,"title":"\u62d3\u5b9e\u4ed3\u5e93","description":"","sort":1,"is_system":true,"is_delete":false,"created_by":1000,"created_at":"2025-08-01 23:14:16","updated_at":"2025-08-08 14:35:40"},"erpPurchaseInbound":{},"erpPurchaseGift":{},"erpInventoryStart":{"id":30,"serial_no":"QCKC-20250808-00030","wrote_date":"2025-08-08","handler":1011,"supplier_id":478,"erp_store_id":1,"status":0,"abstract":"","description":"","number":"15","amount":"345","cancel_number":"","cancel_amount":"","created_by":1001,"is_used":true,"is_settle":true,"created_at":"2025-08-08 18:11:18","updated_at":"2025-08-08 18:11:19","print_times":""},"erpInventoryBuild":{},"erpInventoryDisassemble":{},"erpInventoryOverflow":{}},"erpSalesOutboundSpentProductSns":[],"sns":[{"erp_inventory_product_sn_id":68,"erp_inventory_product_id":44,"sn":"\u6211\u8fd8\u6709\u70b9\u4e0d\u6562\u8bf4","id":"","erp_sales_outbound_spent_product_id":"","erp_sales_outbound_spent_product_sn_id":"","description":"","is_cancel":false}],"spent":{}}],"sns":[{"erp_inventory_product_sn_id":68,"erp_inventory_product_id":44,"sn":"\u6211\u8fd8\u6709\u70b9\u4e0d\u6562\u8bf4"}],"auto_outbound_number":1,"id":"","is_new":true,"erp_sales_outbound_id":"","erp_sales_order_id":1715,"outbound":"","erpSalesOutboundProductSns":[],"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-04 21:25:19","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 21:25:19.277799+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6","product_type":4,"order":24,"description":"","created_by":1013,"created_at":"2017-03-23 12:04:19","updated_at":"2017-03-23 12:04:19","pinyin_shortcut":"wlsbpj"},"productBrand":{"id":134,"name":"\u7b2c\u4e09\u65b9","order":68,"description":"","created_by":1013,"created_at":"2023-08-03 09:20:44","updated_at":"2023-08-03 09:20:44","pinyin_shortcut":"dsf"},"productSerie":{"id":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_component":43,"product_brand":134,"order":868,"description":"","created_by":1013,"created_at":"2024-01-26 16:47:45","updated_at":"2024-01-26 16:47:45","pinyin_shortcut":"LCLCgxx5m"},"productUnit":{"id":6,"name":"\u6761","order":6,"description":"","created_by":1013,"created_at":"2023-08-11 16:00:58","updated_at":"2023-08-11 16:00:58"},"erpInventoryCount":{"product_id":1372,"outbound":"34","number":"49","inventory":"15","avg_amount":"19.0000000000000000","avg_total_amount":"47.5714285714285714","amount":"333"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"erpSalesOrderProduct":{"id":2252,"erp_sales_order_id":1715,"erp_store_id":"","product_id":1372,"description":"","number":"1","outbound":"0","amount":"53445","total_amount":"53445","last_number":"1","last_amount":"53445","last_total_amount":"53445","cost":"","total_cost":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-04 21:25:19","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 21:25:19.277799+08","productType":{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false},"productComponent":{"id":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6","product_type":4,"order":24,"description":"","created_by":1013,"created_at":"2017-03-23 12:04:19","updated_at":"2017-03-23 12:04:19","pinyin_shortcut":"wlsbpj"},"productBrand":{"id":134,"name":"\u7b2c\u4e09\u65b9","order":68,"description":"","created_by":1013,"created_at":"2023-08-03 09:20:44","updated_at":"2023-08-03 09:20:44","pinyin_shortcut":"dsf"},"productSerie":{"id":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_component":43,"product_brand":134,"order":868,"description":"","created_by":1013,"created_at":"2024-01-26 16:47:45","updated_at":"2024-01-26 16:47:45","pinyin_shortcut":"LCLCgxx5m"},"productUnit":{"id":6,"name":"\u6761","order":6,"description":"","created_by":1013,"created_at":"2023-08-11 16:00:58","updated_at":"2023-08-11 16:00:58"},"erpInventoryCount":{"product_id":1372,"outbound":"34","number":"49","inventory":"15","avg_amount":"19.0000000000000000","avg_total_amount":"47.5714285714285714","amount":"333"}},"un_outbound":3,"un_outbound_amount":"53445"},"spent_total_amount":0,"avg_spent_amount":0,"pct":"","need_sn":1},{"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":[],"auto_outbound_number":0,"id":"","is_new":true,"erp_sales_outbound_id":"","erp_sales_order_id":1715,"outbound":"","erpSalesOutboundProductSns":[],"product":{"id":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:34:40","updated_at":"2026-06-08 18:13:58","pinyin_shortcut":"olwlOlivoilagly500MLx2jxlh","product_unit":9,"is_renew":false,"in_out_at":"2026-06-08 18:13:58.834274+08","productType":{"id":23,"name":"\u793c\u54c1","order":21,"description":"","created_by":1013,"created_at":"2024-01-10 18:13:20","updated_at":"2024-01-10 18:13:20","pinyin_shortcut":"lp","is_delete":false},"productComponent":{"id":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865","product_type":23,"order":127,"description":"","created_by":1013,"created_at":"2024-01-10 18:16:50","updated_at":"2024-01-10 18:16:50","pinyin_shortcut":"yyspzb"},"productBrand":{"id":284,"name":"\u6b27\u4e3d\u8587\u5170","order":215,"description":"","created_by":1013,"created_at":"2026-02-03 09:28:37","updated_at":"2026-02-03 09:28:37","pinyin_shortcut":"olwl"},"productSerie":{"id":1775,"name":"\u98df\u7528\u6cb9","product_component":195,"product_brand":284,"order":1586,"description":"","created_by":1013,"created_at":"2026-02-03 09:29:21","updated_at":"2026-02-03 09:29:21","pinyin_shortcut":"syy"},"productUnit":{"id":9,"name":"\u76d2","order":9,"description":"","created_by":1013,"created_at":"2024-01-11 10:01:00","updated_at":"2024-01-11 10:01:00"},"erpInventoryCount":{"product_id":2265,"outbound":"50","number":"50","inventory":"0","avg_amount":"99.9000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.0"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"erpSalesOrderProduct":{"id":2253,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2265,"description":"","number":"1","outbound":"0","amount":"53534","total_amount":"53534","last_number":"1","last_amount":"53534","last_total_amount":"53534","cost":"","total_cost":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","product":{"id":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:34:40","updated_at":"2026-06-08 18:13:58","pinyin_shortcut":"olwlOlivoilagly500MLx2jxlh","product_unit":9,"is_renew":false,"in_out_at":"2026-06-08 18:13:58.834274+08","productType":{"id":23,"name":"\u793c\u54c1","order":21,"description":"","created_by":1013,"created_at":"2024-01-10 18:13:20","updated_at":"2024-01-10 18:13:20","pinyin_shortcut":"lp","is_delete":false},"productComponent":{"id":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865","product_type":23,"order":127,"description":"","created_by":1013,"created_at":"2024-01-10 18:16:50","updated_at":"2024-01-10 18:16:50","pinyin_shortcut":"yyspzb"},"productBrand":{"id":284,"name":"\u6b27\u4e3d\u8587\u5170","order":215,"description":"","created_by":1013,"created_at":"2026-02-03 09:28:37","updated_at":"2026-02-03 09:28:37","pinyin_shortcut":"olwl"},"productSerie":{"id":1775,"name":"\u98df\u7528\u6cb9","product_component":195,"product_brand":284,"order":1586,"description":"","created_by":1013,"created_at":"2026-02-03 09:29:21","updated_at":"2026-02-03 09:29:21","pinyin_shortcut":"syy"},"productUnit":{"id":9,"name":"\u76d2","order":9,"description":"","created_by":1013,"created_at":"2024-01-11 10:01:00","updated_at":"2024-01-11 10:01:00"},"erpInventoryCount":{"product_id":2265,"outbound":"50","number":"50","inventory":"0","avg_amount":"99.9000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.0"}},"un_outbound":1,"un_outbound_amount":"53534"},"spent_total_amount":0,"avg_spent_amount":0,"pct":"","need_sn":0},{"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":[],"auto_outbound_number":0,"id":"","is_new":true,"erp_sales_outbound_id":"","erp_sales_order_id":1715,"outbound":"","erpSalesOutboundProductSns":[],"product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"name":"\u6570\u7801\u8bbe\u5907","order":19,"description":"","created_by":1013,"created_at":"2023-11-13 10:46:10","updated_at":"2023-11-13 10:46:10","pinyin_shortcut":"smsb","is_delete":false},"productComponent":{"id":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6","product_type":21,"order":159,"description":"","created_by":1013,"created_at":"2026-02-04 16:28:04","updated_at":"2026-02-04 16:28:04","pinyin_shortcut":"smsbpj"},"productBrand":{"id":285,"name":"\u867e\u76ae","order":216,"description":"","created_by":1013,"created_at":"2026-03-20 14:29:01","updated_at":"2026-03-20 14:29:01","pinyin_shortcut":"xp"},"productSerie":{"id":1782,"name":"\u6295\u5f71\u5e55\u5e03","product_component":229,"product_brand":285,"order":1593,"description":"","created_by":1013,"created_at":"2026-03-20 14:30:57","updated_at":"2026-03-20 14:30:57","pinyin_shortcut":"tymb"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2263,"outbound":"3","number":"3","inventory":"0","avg_amount":"164.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"erpSalesOrderProduct":{"id":2254,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2263,"description":"","number":"1","outbound":"0","amount":"44","total_amount":"44","last_number":"1","last_amount":"44","last_total_amount":"44","cost":"","total_cost":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"name":"\u6570\u7801\u8bbe\u5907","order":19,"description":"","created_by":1013,"created_at":"2023-11-13 10:46:10","updated_at":"2023-11-13 10:46:10","pinyin_shortcut":"smsb","is_delete":false},"productComponent":{"id":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6","product_type":21,"order":159,"description":"","created_by":1013,"created_at":"2026-02-04 16:28:04","updated_at":"2026-02-04 16:28:04","pinyin_shortcut":"smsbpj"},"productBrand":{"id":285,"name":"\u867e\u76ae","order":216,"description":"","created_by":1013,"created_at":"2026-03-20 14:29:01","updated_at":"2026-03-20 14:29:01","pinyin_shortcut":"xp"},"productSerie":{"id":1782,"name":"\u6295\u5f71\u5e55\u5e03","product_component":229,"product_brand":285,"order":1593,"description":"","created_by":1013,"created_at":"2026-03-20 14:30:57","updated_at":"2026-03-20 14:30:57","pinyin_shortcut":"tymb"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2263,"outbound":"3","number":"3","inventory":"0","avg_amount":"164.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"}},"un_outbound":1,"un_outbound_amount":"44"},"spent_total_amount":0,"avg_spent_amount":0,"pct":"","need_sn":0},{"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":[],"auto_outbound_number":0,"id":"","is_new":true,"erp_sales_outbound_id":"","erp_sales_order_id":1715,"outbound":"","erpSalesOutboundProductSns":[],"product":{"id":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_type":23,"product_component":221,"product_brand":286,"product_serie":1783,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:38:56","updated_at":"2026-06-08 18:13:58","pinyin_shortcut":"sxddtxdxfhminibxkCM20","product_unit":3,"is_renew":false,"in_out_at":"2026-06-08 18:13:58.834274+08","productType":{"id":23,"name":"\u793c\u54c1","order":21,"description":"","created_by":1013,"created_at":"2024-01-10 18:13:20","updated_at":"2024-01-10 18:13:20","pinyin_shortcut":"lp","is_delete":false},"productComponent":{"id":221,"name":"\u7535\u5b50\u4ea7\u54c1","product_type":23,"order":151,"description":"","created_by":1001,"created_at":"2025-08-08 17:41:30","updated_at":"2025-08-08 17:41:30","pinyin_shortcut":"dzcp"},"productBrand":{"id":286,"name":"\u677e\u4e0b","order":217,"description":"","created_by":1013,"created_at":"2026-03-20 14:35:51","updated_at":"2026-03-20 14:35:51","pinyin_shortcut":"sx"},"productSerie":{"id":1783,"name":"\u7535\u52a8\u5243\u987b\u5200","product_component":221,"product_brand":286,"order":1594,"description":"","created_by":1013,"created_at":"2026-03-20 14:37:29","updated_at":"2026-03-20 14:37:29","pinyin_shortcut":"ddtxd"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2266,"outbound":"20","number":"20","inventory":"0","avg_amount":"278.0440000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.000"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"erpSalesOrderProduct":{"id":2255,"erp_sales_order_id":1715,"erp_store_id":"","product_id":2266,"description":"","number":"1","outbound":"0","amount":"54","total_amount":"54","last_number":"1","last_amount":"54","last_total_amount":"54","cost":"","total_cost":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","product":{"id":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_type":23,"product_component":221,"product_brand":286,"product_serie":1783,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:38:56","updated_at":"2026-06-08 18:13:58","pinyin_shortcut":"sxddtxdxfhminibxkCM20","product_unit":3,"is_renew":false,"in_out_at":"2026-06-08 18:13:58.834274+08","productType":{"id":23,"name":"\u793c\u54c1","order":21,"description":"","created_by":1013,"created_at":"2024-01-10 18:13:20","updated_at":"2024-01-10 18:13:20","pinyin_shortcut":"lp","is_delete":false},"productComponent":{"id":221,"name":"\u7535\u5b50\u4ea7\u54c1","product_type":23,"order":151,"description":"","created_by":1001,"created_at":"2025-08-08 17:41:30","updated_at":"2025-08-08 17:41:30","pinyin_shortcut":"dzcp"},"productBrand":{"id":286,"name":"\u677e\u4e0b","order":217,"description":"","created_by":1013,"created_at":"2026-03-20 14:35:51","updated_at":"2026-03-20 14:35:51","pinyin_shortcut":"sx"},"productSerie":{"id":1783,"name":"\u7535\u52a8\u5243\u987b\u5200","product_component":221,"product_brand":286,"order":1594,"description":"","created_by":1013,"created_at":"2026-03-20 14:37:29","updated_at":"2026-03-20 14:37:29","pinyin_shortcut":"ddtxd"},"productUnit":{"id":3,"name":"\u4e2a","order":3,"description":"","created_by":1013,"created_at":"2023-08-11 15:55:07","updated_at":"2023-08-11 15:55:07"},"erpInventoryCount":{"product_id":2266,"outbound":"20","number":"20","inventory":"0","avg_amount":"278.0440000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.000"}},"un_outbound":1,"un_outbound_amount":"54"},"spent_total_amount":0,"avg_spent_amount":0,"pct":"","need_sn":0}]},"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 21:40:20', 96816896) RETURNING "id"
21:40:20.0520.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
21:40:20.0550.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
21:40:20.0990.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"='2251'
21:40:20.0960.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=52
21:40:20.0570.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:40:20.1080.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_starts" WHERE "id"=32
21:40:20.0970.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1769
21:40:20.0580.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"='68'
21:40:20.0980.5 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2261 GROUP BY "eip"."product_id"
21:40:20.0590.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=44
21:40:20.1030.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2261 GROUP BY "eip"."product_id"
21:40:20.1070.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2261 GROUP BY "eip"."product_id"
21:40:20.0520.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:40:20.1120.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=1372 GROUP BY "eip"."product_id"
21:40:20.0610.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372
21:40:20.1310.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2263 GROUP BY "eip"."product_id"
21:40:20.1200.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=1372 GROUP BY "eip"."product_id"
21:40:20.1280.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2265 GROUP BY "eip"."product_id"
21:40:20.1240.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2265 GROUP BY "eip"."product_id"
21:40:20.0750.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=89
21:40:20.1160.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=1372 GROUP BY "eip"."product_id"
21:40:20.1350.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2263 GROUP BY "eip"."product_id"
21:40:20.0870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=89
21:40:20.1380.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2266 GROUP BY "eip"."product_id"
21:40:20.1420.4 msyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id"=2266 GROUP BY "eip"."product_id"
21:40:20.0620.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
21:40:20.0640.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=68
21:40:20.0900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=44
21:40:20.1170.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=44
21:40:20.0800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.0880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.0650.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.0630.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.0760.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.1040.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.0700.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=44
21:40:20.0680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.0780.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=86
21:40:20.0820.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.0670.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=89
21:40:20.0810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=89
21:40:20.0880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.0900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=86
21:40:20.1050.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.0920.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=44
21:40:20.0940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=68
21:40:20.0990.3 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
21:40:20.0780.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=470
21:40:20.1290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21
21:40:20.0870.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=86
21:40:20.1330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21
21:40:20.0640.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"='89'
21:40:20.0820.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.0910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=68
21:40:20.1320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"='2254'
21:40:20.0690.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=86
21:40:20.0810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.0950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.0910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372
21:40:20.0790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.0980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.0830.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.0670.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"='86'
21:40:20.1320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2263
21:40:20.0690.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.0920.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372
21:40:20.0940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2261'
21:40:20.1150.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
21:40:20.0650.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.0890.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"='2253'
21:40:20.1000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.1110.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
21:40:20.1090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1372'
21:40:20.0660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1210.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_starts" WHERE "id"=30
21:40:20.1180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
21:40:20.1080.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
21:40:20.1130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372
21:40:20.0930.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
21:40:20.0700.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "id"=68
21:40:20.0800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"='2252'
21:40:20.1350.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2266'
21:40:20.1010.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.1070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1769
21:40:20.1270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1775
21:40:20.0770.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1280.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2263'
21:40:20.1390.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2266
21:40:20.1110.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1047
21:40:20.1330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=229
21:40:20.0790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1060.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=52
21:40:20.0680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.1050.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.0710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372
21:40:20.0760.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
21:40:20.1410.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=286
21:40:20.1260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=284
21:40:20.1020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1170.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372
21:40:20.1360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=221
21:40:20.1100.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1390.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"='2255'
21:40:20.1010.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=52
21:40:20.0890.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.0960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1140.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=43
21:40:20.1220.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23
21:40:20.0930.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1220.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=284
21:40:20.1340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=285
21:40:20.0660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1140.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1210.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2265'
21:40:20.1390.3 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
21:40:20.1060.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
21:40:20.1250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2265
21:40:20.0710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134
21:40:20.1370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1783
21:40:20.1400.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=221
21:40:20.1250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23
21:40:20.1340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.1200.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
21:40:20.1400.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23
21:40:20.1410.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1783
21:40:20.1300.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1782
21:40:20.1370.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=286
21:40:20.1020.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1769
21:40:20.1230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1775
21:40:20.1100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=43
21:40:20.1190.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1047
21:40:20.1260.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=195
21:40:20.1300.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.1380.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.0770.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1290.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=229
21:40:20.1150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1047
21:40:20.1360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23
21:40:20.1420.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.0720.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=43
21:40:20.0690.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
21:40:20.1310.2 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
21:40:20.1110.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6
21:40:20.1220.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_components" WHERE "id"=195
21:40:20.1300.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=285
21:40:20.1070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
21:40:20.1190.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6
21:40:20.1230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=9
21:40:20.1340.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1782
21:40:20.1120.2 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
21:40:20.1270.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=9
21:40:20.1240.2 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"='1'
21:40:20.1160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6