ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7bd6ad7073: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-list at 2025-09-15 03:16:58 pm by 115.171.251.67

Performance Profiling

Total processing time: 58 ms; Peak memory: 5.249 MB. Show Profiling Timeline

总计19条数据
TimeDurationCategoryInfo
  
15:16:58.9245.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
15:16:58.9303.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=147, "last_visit_at"='now()' WHERE "id"=56565
15:16:58.9142.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (172, 1523, 633, 1382, 1691, 1578, 1692, 1693, 1676, 1047, 1675, 1679, 714, 1686, 1685, 80, 421, 1684)
15:16:58.8972.9 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id" ORDER BY updated_at DESC nulls last) "c"
15:16:58.9342.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/erp-inventory-product/product-list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpProductSearch":{"erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":"","number_range_to":"","number_range_from":"","inventory":"1"},"page":"1","web_access_token":"zACaxwY58DCRigSw1MlM3KllVvnv2n5E"}', '{"code":2000,"result":{"stores":[{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}],"list":[{"id":2105,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:34:25","updated_at":"2025-09-15 10:47:16","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B1500","product_unit":2,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2105,"erp_store_id":1,"outbound":"1","number":"2","inventory":"1","avg_amount":"33702.840000000000","avg_total_amount":"33702.840000000000"}],"erpInventoryCount":{"product_id":2105,"outbound":"1","number":"2","inventory":"1","avg_amount":"33702.840000000000","avg_total_amount":"33702.840000000000","amount":"33702.84"},"erpInventoryCount2":{"product_id":2105,"inventory":"1","avg_amount":33702.84,"amount":33702.84},"erpInventoryCount3":[{"id":80,"product_id":2105,"erp_purchase_inbound_id":22,"erp_purchase_order_id":2019,"erp_purchase_inbound_product_id":35,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-21","number":"2","outbound":"1","inventory":"1","amount":"33702.84","total_amount":"67405.68","actual_amount":"33702.84","actual_total_amount":"33702.84","is_build":false,"created_at":"2025-08-21 17:31:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2105,"erp_store_id":1,"outbound":"1","number":"2","inventory":"1","avg_amount":"33702.840000000000","avg_total_amount":"33702.840000000000"}},{"id":1812,"name":"RKS-02","product_type":3,"product_component":39,"product_brand":27,"product_serie":1523,"product_misc":"","product_qa":"","pn":"","description":"Synology RKS-02 \u53ef\u673a\u67b6\u5b89\u88c5 \u9f7f\u8f68 \u7528\u4e8e \u670d\u52a1\u5668","created_by":1013,"created_at":"2024-10-09 11:33:47","updated_at":"2025-09-15 10:46:14","pinyin_shortcut":"RKS02","product_unit":2,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":1812,"erp_store_id":1,"outbound":"1","number":"2","inventory":"1","avg_amount":"550.0000000000000000","avg_total_amount":"550.0000000000000000"}],"erpInventoryCount":{"product_id":1812,"outbound":"1","number":"2","inventory":"1","avg_amount":"550.0000000000000000","avg_total_amount":"550.0000000000000000","amount":"550"},"erpInventoryCount2":{"product_id":1812,"inventory":"1","avg_amount":550,"amount":550},"erpInventoryCount3":[{"id":102,"product_id":1812,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":54,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"2","outbound":"1","inventory":"1","amount":"550","total_amount":"1100","actual_amount":"550","actual_total_amount":"550","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1523,"key":1523,"name":"\u673a\u67b6\u5bfc\u8f68\u5957\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":1812,"erp_store_id":1,"outbound":"1","number":"2","inventory":"1","avg_amount":"550.0000000000000000","avg_total_amount":"550.0000000000000000"}},{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-12 15:58:12","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":1040,"erp_store_id":1,"outbound":"8","number":"12","inventory":"4","avg_amount":"9.0000000000000000","avg_total_amount":"36.0000000000000000"}],"erpInventoryCount":{"product_id":1040,"outbound":"8","number":"12","inventory":"4","avg_amount":"18.0000000000000000","avg_total_amount":"36.0000000000000000","amount":"72"},"erpInventoryCount2":{"product_id":1040,"inventory":"4","avg_amount":18,"amount":72},"erpInventoryCount3":[{"id":107,"product_id":1040,"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-09-05","number":"6","outbound":"2","inventory":"4","amount":"18","total_amount":"108","actual_amount":"18","actual_total_amount":"72","is_build":false,"created_at":"2025-09-05 15:11:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":2,"erp_inventory_build_product_id":2,"build_spent_outbound":"","sales_outbound":"2","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":1040,"erp_store_id":1,"outbound":"8","number":"12","inventory":"4","avg_amount":"9.0000000000000000","avg_total_amount":"36.0000000000000000"}},{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":1624,"erp_store_id":1,"outbound":"13","number":"14","inventory":"1","avg_amount":"1393.0000000000000000","avg_total_amount":"1393.0000000000000000"}],"erpInventoryCount":{"product_id":1624,"outbound":"13","number":"14","inventory":"1","avg_amount":"1393.0000000000000000","avg_total_amount":"1393.0000000000000000","amount":"1393"},"erpInventoryCount2":{"product_id":1624,"inventory":"1","avg_amount":1393,"amount":1393},"erpInventoryCount3":[{"id":97,"product_id":1624,"erp_purchase_inbound_id":31,"erp_purchase_order_id":2038,"erp_purchase_inbound_product_id":49,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"14","outbound":"13","inventory":"1","amount":"1393","total_amount":"19502","actual_amount":"1393","actual_total_amount":"1393","is_build":false,"created_at":"2025-08-28 14:12:06","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"13","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":1624,"erp_store_id":1,"outbound":"13","number":"14","inventory":"1","avg_amount":"1393.0000000000000000","avg_total_amount":"1393.0000000000000000"}},{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":"","product_qa":"","pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2095,"erp_store_id":1,"outbound":"4","number":"104","inventory":"100","avg_amount":"37216.666666666667","avg_total_amount":"28300.000000000000"}],"erpInventoryCount":{"product_id":2095,"outbound":"4","number":"104","inventory":"100","avg_amount":"849.0000000000000000","avg_total_amount":"28300.000000000000","amount":"84900"},"erpInventoryCount2":{"product_id":2095,"inventory":"100","avg_amount":849,"amount":84900},"erpInventoryCount3":[{"id":104,"product_id":2095,"erp_purchase_inbound_id":34,"erp_purchase_order_id":2043,"erp_purchase_inbound_product_id":57,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-09-03","number":"100","outbound":"1","inventory":"99","amount":"100","total_amount":"10000","actual_amount":"849","actual_total_amount":"84051","is_build":false,"created_at":"2025-09-03 17:15:27","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""},{"id":103,"product_id":2095,"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-29","number":"2","outbound":"1","inventory":"1","amount":"75000","total_amount":"150000","actual_amount":"849","actual_total_amount":"849","is_build":false,"created_at":"2025-08-29 12:32:29","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":1,"erp_inventory_build_product_id":1,"build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":2095,"erp_store_id":1,"outbound":"4","number":"104","inventory":"100","avg_amount":"37216.666666666667","avg_total_amount":"28300.000000000000"}},{"id":2098,"name":"M2D20","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":"","product_qa":"","pn":"","description":"M.2 SSD \u9002\u914d\u5668","created_by":1013,"created_at":"2025-08-14 09:09:02","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"M2D20","product_unit":3,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2098,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"1278.0000000000000000","avg_total_amount":"2556.0000000000000000"}],"erpInventoryCount":{"product_id":2098,"outbound":"0","number":"2","inventory":"2","avg_amount":"1278.0000000000000000","avg_total_amount":"2556.0000000000000000","amount":"2556"},"erpInventoryCount2":{"product_id":2098,"inventory":"2","avg_amount":1278,"amount":2556},"erpInventoryCount3":[{"id":101,"product_id":2098,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":53,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"2","outbound":"0","inventory":"2","amount":"1278","total_amount":"2556","actual_amount":"1278","actual_total_amount":"2556","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2098,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"1278.0000000000000000","avg_total_amount":"2556.0000000000000000"}},{"id":2096,"name":"HAT5300-12T","product_type":3,"product_component":15,"product_brand":27,"product_serie":1692,"product_misc":"","product_qa":"","pn":"","description":"12TB 3.5\" SATA HDD","created_by":1013,"created_at":"2025-08-14 09:07:32","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"HAT530012T","product_unit":3,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2096,"erp_store_id":1,"outbound":"0","number":"20","inventory":"20","avg_amount":"2990.0000000000000000","avg_total_amount":"59800.000000000000"}],"erpInventoryCount":{"product_id":2096,"outbound":"0","number":"20","inventory":"20","avg_amount":"2990.0000000000000000","avg_total_amount":"59800.000000000000","amount":"59800"},"erpInventoryCount2":{"product_id":2096,"inventory":"20","avg_amount":2990,"amount":59800},"erpInventoryCount3":[{"id":99,"product_id":2096,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":51,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"20","outbound":"0","inventory":"20","amount":"2990","total_amount":"59800","actual_amount":"2990","actual_total_amount":"59800","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1692,"key":1692,"name":"12TB 3.5\" SATA \u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2096,"erp_store_id":1,"outbound":"0","number":"20","inventory":"20","avg_amount":"2990.0000000000000000","avg_total_amount":"59800.000000000000"}},{"id":2097,"name":"SNV3510-800G","product_type":3,"product_component":15,"product_brand":27,"product_serie":1693,"product_misc":"","product_qa":"","pn":"","description":"800G M.2 NVMe SSD","created_by":1013,"created_at":"2025-08-14 09:08:19","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"SNV3510800G","product_unit":3,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2097,"erp_store_id":1,"outbound":"0","number":"4","inventory":"4","avg_amount":"2130.0000000000000000","avg_total_amount":"8520.0000000000000000"}],"erpInventoryCount":{"product_id":2097,"outbound":"0","number":"4","inventory":"4","avg_amount":"2130.0000000000000000","avg_total_amount":"8520.0000000000000000","amount":"8520"},"erpInventoryCount2":{"product_id":2097,"inventory":"4","avg_amount":2130,"amount":8520},"erpInventoryCount3":[{"id":100,"product_id":2097,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":52,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"4","outbound":"0","inventory":"4","amount":"2130","total_amount":"8520","actual_amount":"2130","actual_total_amount":"8520","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1693,"key":1693,"name":"800G SSD\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2097,"erp_store_id":1,"outbound":"0","number":"4","inventory":"4","avg_amount":"2130.0000000000000000","avg_total_amount":"8520.0000000000000000"}},{"id":2074,"name":"\u4e50\u4e8b\u5370\u52a0\u971e\u591a\u4e3d\u767d\u8461\u8404\u9152","product_type":23,"product_component":194,"product_brand":256,"product_serie":1676,"product_misc":"","product_qa":"","pn":"","description":"705ML","created_by":1001,"created_at":"2025-08-08 16:47:20","updated_at":"2025-08-28 10:02:49","pinyin_shortcut":"lsyjxdlbptj","product_unit":11,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2074,"erp_store_id":1,"outbound":"6","number":"48","inventory":"42","avg_amount":"150.0000000000000000","avg_total_amount":"6300.0000000000000000"}],"erpInventoryCount":{"product_id":2074,"outbound":"6","number":"48","inventory":"42","avg_amount":"150.0000000000000000","avg_total_amount":"6300.0000000000000000","amount":"6300"},"erpInventoryCount2":{"product_id":2074,"inventory":"42","avg_amount":150,"amount":6300},"erpInventoryCount3":[{"id":12,"product_id":2074,"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":"48","outbound":"6","inventory":"42","amount":"150","total_amount":"7200","actual_amount":"150","actual_total_amount":"6300","is_build":false,"created_at":"2025-08-08 16:47:56","lost_outbound":"","erp_inventory_start_id":6,"erp_inventory_start_product_id":12,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"6","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":256,"key":256,"name":"\u4e50\u4e8b\u5370\u52a0"},"productSerie":{"id":1676,"key":1676,"name":"\u7ea2\u9152"},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"everyStoreErpInventoryCount1":{"product_id":2074,"erp_store_id":1,"outbound":"6","number":"48","inventory":"42","avg_amount":"150.0000000000000000","avg_total_amount":"6300.0000000000000000"}},{"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":"2025-08-27 13:24:36","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":1372,"erp_store_id":1,"outbound":"29","number":"42","inventory":"13","avg_amount":"25.0000000000000000","avg_total_amount":"108.3333333333333333"}],"erpInventoryCount":{"product_id":1372,"outbound":"29","number":"42","inventory":"13","avg_amount":"25.0000000000000000","avg_total_amount":"108.3333333333333333","amount":"325"},"erpInventoryCount2":{"product_id":1372,"inventory":"13","avg_amount":25,"amount":325},"erpInventoryCount3":[{"id":95,"product_id":1372,"erp_purchase_inbound_id":26,"erp_purchase_order_id":2042,"erp_purchase_inbound_product_id":44,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-27","number":"10","outbound":"0","inventory":"10","amount":"25","total_amount":"250","actual_amount":"25","actual_total_amount":"250","is_build":false,"created_at":"2025-08-27 13:18:21","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""},{"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":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"everyStoreErpInventoryCount1":{"product_id":1372,"erp_store_id":1,"outbound":"29","number":"42","inventory":"13","avg_amount":"25.0000000000000000","avg_total_amount":"108.3333333333333333"}},{"id":2073,"name":"\u4e09\u987f\u534a\u51bb\u5e72\u901f\u6eb6\u5496\u5561\u7eaf\u9ed1\u5496\u5561\u7c89\u6df7\u5408\u88c5 21\u9897*2g","product_type":23,"product_component":195,"product_brand":255,"product_serie":1675,"product_misc":"","product_qa":"","pn":"","description":"\u4e09\u987f\u534a\u51bb\u5e72\u901f\u6eb6\u5496\u5561\u7eaf\u9ed1\u5496\u5561\u7c89\u6df7\u5408\u88c5 21\u9897*2g","created_by":1001,"created_at":"2025-08-08 16:42:19","updated_at":"2025-08-25 16:58:11","pinyin_shortcut":"sdbdgsrkfchkffhhz21k2g","product_unit":9,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2073,"erp_store_id":1,"outbound":"4","number":"66","inventory":"62","avg_amount":"63.9800000000000000","avg_total_amount":"3966.7600000000000000"}],"erpInventoryCount":{"product_id":2073,"outbound":"4","number":"66","inventory":"62","avg_amount":"63.9800000000000000","avg_total_amount":"3966.7600000000000000","amount":"3966.76"},"erpInventoryCount2":{"product_id":2073,"inventory":"62","avg_amount":63.98,"amount":3966.76},"erpInventoryCount3":[{"id":8,"product_id":2073,"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":"66","outbound":"4","inventory":"62","amount":"63.98","total_amount":"4222.68","actual_amount":"63.98","actual_total_amount":"3966.76","is_build":false,"created_at":"2025-08-08 16:42:55","lost_outbound":"","erp_inventory_start_id":4,"erp_inventory_start_product_id":8,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"4","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":255,"key":255,"name":"\u4e09\u987f\u534a"},"productSerie":{"id":1675,"key":1675,"name":"\u5496\u5561"},"productUnit":{"id":9,"key":9,"name":"\u76d2"},"everyStoreErpInventoryCount1":{"product_id":2073,"erp_store_id":1,"outbound":"4","number":"66","inventory":"62","avg_amount":"63.9800000000000000","avg_total_amount":"3966.7600000000000000"}},{"id":2078,"name":"\u4e09\u987f\u534a \u76f4\u996e\u5f0f\u4fdd\u6e29\u676f\uff08\u8584\u8377\u7eff\uff09","product_type":23,"product_component":220,"product_brand":255,"product_serie":1679,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 16:59:20","updated_at":"2025-08-25 16:58:11","pinyin_shortcut":"sdbzysbwbbhl","product_unit":3,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2078,"erp_store_id":1,"outbound":"4","number":"25","inventory":"21","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":2078,"outbound":"4","number":"25","inventory":"21","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"erpInventoryCount2":{"product_id":2078,"inventory":"21","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":20,"product_id":2078,"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":"25","outbound":"4","inventory":"21","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2025-08-08 16:59:36","lost_outbound":"","erp_inventory_start_id":14,"erp_inventory_start_product_id":20,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"4","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":220,"key":220,"name":"\u676f\u5b50"},"productBrand":{"id":255,"key":255,"name":"\u4e09\u987f\u534a"},"productSerie":{"id":1679,"key":1679,"name":"\u676f\u5b50"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2078,"erp_store_id":1,"outbound":"4","number":"25","inventory":"21","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":2106,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:35:15","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B1500","product_unit":2,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2106,"erp_store_id":1,"outbound":"0","number":"6","inventory":"6","avg_amount":"3927.7200000000000000","avg_total_amount":"23566.320000000000"}],"erpInventoryCount":{"product_id":2106,"outbound":"0","number":"6","inventory":"6","avg_amount":"3927.7200000000000000","avg_total_amount":"23566.320000000000","amount":"23566.32"},"erpInventoryCount2":{"product_id":2106,"inventory":"6","avg_amount":3927.72,"amount":23566.32},"erpInventoryCount3":[{"id":81,"product_id":2106,"erp_purchase_inbound_id":22,"erp_purchase_order_id":2019,"erp_purchase_inbound_product_id":36,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-21","number":"6","outbound":"0","inventory":"6","amount":"3927.72","total_amount":"23566.32","actual_amount":"3927.72","actual_total_amount":"23566.32","is_build":false,"created_at":"2025-08-21 17:31:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2106,"erp_store_id":1,"outbound":"0","number":"6","inventory":"6","avg_amount":"3927.7200000000000000","avg_total_amount":"23566.320000000000"}},{"id":2099,"name":"AC-1000-B1500","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff08\u5927\u5305\uff09\uff1a5.8Gb\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a750Mb\uff0c\u5e26\u5bbd\u6027\u80fd\uff1a500Mb\uff0cIPSEC VPN\u52a0\u5bc6\u6027\u80fd\uff08\u6700\u9ad8\u6027\u80fd\uff09\uff1a120Mb\uff0c\u652f\u6301\u7528\u6237\u6570\uff1a4000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a2000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\u7684\u6269\u5bb9\u4e0a\u9650\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a4000\uff0c\u9632\u6cc4\u5bc6\u7ec8\u7aef\u6570\u4e0a\u9650(\u9700\u5355\u72ec\u6536\u8d39)\uff1a8000\uff0c\u5305\u8f6c\u53d1\u7387\uff1a90Kpps\uff0c\u6bcf\u79d2\u65b0\u5efa\u8fde\u63a5\u6570\uff1a10000\uff0c\u6700\u5927\u5e76\u53d1\u8fde\u63a5\u6570\uff1a500000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD+960G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a6\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u805a\u7126\u4f01\u4e8b\u4e1a\u7ec4\u7ec7\u7f51\u7edc\u884c\u4e3a\u5b89\u5168\uff0c\u5b9e\u73b0\u5168\u7f51\u8d44\u4ea7\u3001\u8eab\u4efd\u3001\u884c\u4e3a\u53ef\u89c6\u53ef\u63a7\uff0c\u667a\u80fd\u611f\u77e5\u5185\u90e8\u5a01\u80c1\u98ce\u9669\uff0c\u5e2e\u52a9\u7528\u6237\u6784\u5efa\u6709\u6548\u9632\u5fa1\u4f53\u7cfb\u3002","created_by":1013,"created_at":"2025-08-14 09:11:10","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"AC1000B1500","product_unit":1,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2099,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"5014.0000000000000000","avg_total_amount":"10028.0000000000000000"}],"erpInventoryCount":{"product_id":2099,"outbound":"0","number":"2","inventory":"2","avg_amount":"5014.0000000000000000","avg_total_amount":"10028.0000000000000000","amount":"10028"},"erpInventoryCount2":{"product_id":2099,"inventory":"2","avg_amount":5014,"amount":10028},"erpInventoryCount3":[{"id":79,"product_id":2099,"erp_purchase_inbound_id":22,"erp_purchase_order_id":2019,"erp_purchase_inbound_product_id":34,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-21","number":"2","outbound":"0","inventory":"2","amount":"5014","total_amount":"10028","actual_amount":"5014","actual_total_amount":"10028","is_build":false,"created_at":"2025-08-21 17:31:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":2099,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"5014.0000000000000000","avg_total_amount":"10028.0000000000000000"}},{"id":1025,"name":"FOC-1010","product_type":4,"product_component":43,"product_brand":152,"product_serie":714,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-05 11:10:11","updated_at":"2025-08-08 18:11:19","pinyin_shortcut":"FOC1010","product_unit":6,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":1025,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"10.0000000000000000","avg_total_amount":"20.0000000000000000"}],"erpInventoryCount":{"product_id":1025,"outbound":"0","number":"2","inventory":"2","avg_amount":"10.0000000000000000","avg_total_amount":"20.0000000000000000","amount":"20"},"erpInventoryCount2":{"product_id":1025,"inventory":"2","avg_amount":10,"amount":20},"erpInventoryCount3":[{"id":45,"product_id":1025,"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":"2","outbound":"0","inventory":"2","amount":"10","total_amount":"20","actual_amount":"10","actual_total_amount":"20","is_build":false,"created_at":"2025-08-08 18:11:19","lost_outbound":"","erp_inventory_start_id":30,"erp_inventory_start_product_id":45,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":152,"key":152,"name":"\u80dc\u4e3a"},"productSerie":{"id":714,"key":714,"name":"\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC 1\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"},"everyStoreErpInventoryCount1":{"product_id":1025,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"10.0000000000000000","avg_total_amount":"20.0000000000000000"}},{"id":2086,"name":"INTEL S3520 \u7cfb\u5217\u56fa\u6001\u786c\u76d82.5\u82f1\u5bf8 240G","product_type":2,"product_component":5,"product_brand":5,"product_serie":1686,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:55:14","updated_at":"2025-08-08 17:55:30","pinyin_shortcut":"INTELS3520xlgtyp25yc240G","product_unit":3,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2086,"erp_store_id":1,"outbound":"0","number":"3","inventory":"3","avg_amount":"900.0000000000000000","avg_total_amount":"2700.0000000000000000"}],"erpInventoryCount":{"product_id":2086,"outbound":"0","number":"3","inventory":"3","avg_amount":"900.0000000000000000","avg_total_amount":"2700.0000000000000000","amount":"2700"},"erpInventoryCount2":{"product_id":2086,"inventory":"3","avg_amount":900,"amount":2700},"erpInventoryCount3":[{"id":41,"product_id":2086,"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":"3","outbound":"0","inventory":"3","amount":"900","total_amount":"2700","actual_amount":"900","actual_total_amount":"2700","is_build":false,"created_at":"2025-08-08 17:55:30","lost_outbound":"","erp_inventory_start_id":28,"erp_inventory_start_product_id":41,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":5,"key":5,"name":"\u82f1\u7279\u5c14"},"productSerie":{"id":1686,"key":1686,"name":"\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2086,"erp_store_id":1,"outbound":"0","number":"3","inventory":"3","avg_amount":"900.0000000000000000","avg_total_amount":"2700.0000000000000000"}},{"id":2085,"name":"HP P22 G4 \u5546\u7528\u6db2\u6676\u663e\u793a\u5668","product_type":11,"product_component":154,"product_brand":2,"product_serie":1685,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:53:41","updated_at":"2025-08-08 17:53:59","pinyin_shortcut":"HPP22G4syyjxsq","product_unit":1,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2085,"erp_store_id":1,"outbound":"0","number":"3","inventory":"3","avg_amount":"620.0000000000000000","avg_total_amount":"1860.0000000000000000"}],"erpInventoryCount":{"product_id":2085,"outbound":"0","number":"3","inventory":"3","avg_amount":"620.0000000000000000","avg_total_amount":"1860.0000000000000000","amount":"1860"},"erpInventoryCount2":{"product_id":2085,"inventory":"3","avg_amount":620,"amount":1860},"erpInventoryCount3":[{"id":40,"product_id":2085,"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":"3","outbound":"0","inventory":"3","amount":"620","total_amount":"1860","actual_amount":"620","actual_total_amount":"1860","is_build":false,"created_at":"2025-08-08 17:53:59","lost_outbound":"","erp_inventory_start_id":27,"erp_inventory_start_product_id":40,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":154,"key":154,"name":"\u663e\u793a\u5668"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1685,"key":1685,"name":"P22 G4"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":2085,"erp_store_id":1,"outbound":"0","number":"3","inventory":"3","avg_amount":"620.0000000000000000","avg_total_amount":"1860.0000000000000000"}},{"id":39,"name":"AIR-AP1832I-H-K9","product_type":4,"product_component":21,"product_brand":3,"product_serie":80,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-13 11:01:04","updated_at":"2025-08-08 17:47:38","pinyin_shortcut":"AIRAP1832IHK9","product_unit":1,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":39,"erp_store_id":1,"outbound":"0","number":"3","inventory":"3","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":39,"outbound":"0","number":"3","inventory":"3","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"erpInventoryCount2":{"product_id":39,"inventory":"3","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":39,"product_id":39,"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":"3","outbound":"0","inventory":"3","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2025-08-08 17:47:38","lost_outbound":"","erp_inventory_start_id":26,"erp_inventory_start_product_id":39,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":21,"key":21,"name":"\u65e0\u7ebfAP"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":80,"key":80,"name":"\u601d\u79d1AIR-AP1832I-H-K9\u65e0\u7ebfAP"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":39,"erp_store_id":1,"outbound":"0","number":"3","inventory":"3","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":672,"name":"FAS9000","product_type":3,"product_component":14,"product_brand":6,"product_serie":421,"product_misc":5,"product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2020-03-03 13:43:05","updated_at":"2025-08-08 17:46:44","pinyin_shortcut":"FAS9000","product_unit":2,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":672,"erp_store_id":1,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":672,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"erpInventoryCount2":{"product_id":672,"inventory":"1","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":38,"product_id":672,"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":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2025-08-08 17:46:44","lost_outbound":"","erp_inventory_start_id":25,"erp_inventory_start_product_id":38,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":421,"key":421,"name":"NETAPP FAS9000 \u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":672,"erp_store_id":1,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":2084,"name":"HP\u7b14\u8bb0\u672c\u53cc\u80a9\u80cc\u5305","product_type":11,"product_component":179,"product_brand":2,"product_serie":1684,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:44:52","updated_at":"2025-08-08 17:45:31","pinyin_shortcut":"HPbjbsjbb","product_unit":3,"is_renew":false,"everyStoreErpInventoryCount":[{"product_id":2084,"erp_store_id":1,"outbound":"0","number":"17","inventory":"17","avg_amount":"70.7500000000000000","avg_total_amount":"1202.7500000000000000"}],"erpInventoryCount":{"product_id":2084,"outbound":"0","number":"17","inventory":"17","avg_amount":"70.7500000000000000","avg_total_amount":"1202.7500000000000000","amount":"1202.75"},"erpInventoryCount2":{"product_id":2084,"inventory":"17","avg_amount":70.75,"amount":1202.75},"erpInventoryCount3":[{"id":37,"product_id":2084,"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":"17","outbound":"0","inventory":"17","amount":"70.75","total_amount":"1202.75","actual_amount":"70.75","actual_total_amount":"1202.75","is_build":false,"created_at":"2025-08-08 17:45:31","lost_outbound":"","erp_inventory_start_id":24,"erp_inventory_start_product_id":37,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":""}],"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1684,"key":1684,"name":"\u80cc\u5305"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2084,"erp_store_id":1,"outbound":"0","number":"17","inventory":"17","avg_amount":"70.7500000000000000","avg_total_amount":"1202.7500000000000000"}}],"pagenation":{"totalcount":42,"thispage":1,"pagesize":20},"can_create_inventory_lost":true,"can_create_inventory_build":true,"count":{"inventory":"486","total_amount":"560515.46"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 15:16:58') RETURNING "id"
15:16:58.8842.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
15:16:58.8822.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:16:58.9041.8 msyii\db\Command::querySELECT "product_id", "erp_store_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(amount) as avg_amount, avg(amount * inventory) as avg_total_amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (2105, 1812, 1040, 1624, 2095, 2098, 2096, 2097, 2074, 1372, 2073, 2078, 2106, 2099, 1025, 2086, 2085, 39, 672, 2084) GROUP BY "product_id", "erp_store_id"
15:16:58.9081.7 msyii\db\Command::querySELECT "product_id", sum(inventory) as inventory, avg(actual_amount) as avg_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (2105, 1812, 1040, 1624, 2095, 2098, 2096, 2097, 2074, 1372, 2073, 2078, 2106, 2099, 1025, 2086, 2085, 39, 672, 2084)) GROUP BY "product_id"
15:16:58.8881.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
15:16:58.9001.4 msyii\db\Command::querySELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id" ORDER BY updated_at DESC nulls last LIMIT 20
15:16:58.9211.0 msyii\db\Command::querySELECT sum(inventory) as inventory, sum(total_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id") "sub"
15:16:58.9130.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 27, 137, 8, 256, 134, 255, 152, 5, 2, 3, 6)
15:16:58.9120.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (23, 39, 32, 36, 14, 15, 194, 43, 195, 220, 5, 154, 21, 179)
15:16:58.9070.5 msyii\db\Command::querySELECT "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" WHERE "product_id" IN (2105, 1812, 1040, 1624, 2095, 2098, 2096, 2097, 2074, 1372, 2073, 2078, 2106, 2099, 1025, 2086, 2085, 39, 672, 2084) GROUP BY "product_id"
15:16:58.9100.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (2105, 1812, 1040, 1624, 2095, 2098, 2096, 2097, 2074, 1372, 2073, 2078, 2106, 2099, 1025, 2086, 2085, 39, 672, 2084))
15:16:58.9210.4 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
15:16:58.9170.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 3, 11, 6, 9)
15:16:58.9110.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 3, 7, 5, 23, 2, 11)