ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a2694f537dbe: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-list at 2026-06-08 06:09:57 pm by 221.216.117.119

Performance Profiling

Total processing time: 146 ms; Peak memory: 6.482 MB. Show Profiling Timeline

总计19条数据
TimeDurationCategoryInfo
  
18:09:57.3269.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".*, COALESCE(max(eipv.inventory_occupied_verifying), 0) as inventory_occupied_verifying 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 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id" ORDER BY p.in_out_at DESC nulls last, p.updated_at DESC) "c"
18:09:57.3578.8 msyii\db\Command::querySELECT sum(sub.inventory_occupied_verifying) as inventory_occupied_verifying, sum(sub.total_amount_occupied_verifying) as total_amount_occupied_verifying FROM (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE ((("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1))) AND ("eip"."product_id" IN (SELECT p.id 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 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id")) GROUP BY "eip"."product_id") "sub"
18:09:57.3358.2 msyii\db\Command::querySELECT "p".*, COALESCE(max(eipv.inventory_occupied_verifying), 0) as inventory_occupied_verifying 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 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id" ORDER BY p.in_out_at DESC nulls last, p.updated_at DESC LIMIT 20
18:09:57.3515.7 msyii\db\Command::querySELECT sum(inventory) as inventory_available, sum(actual_amount * inventory) as total_amount_available FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "eip"."product_id" IN (SELECT p.id 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 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "pp" ON pp.id = epips.project_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = epips.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eids" ON eids.id = eip.erp_inventory_disassemble_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eios" ON eios.id = eip.erp_inventory_overflow_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" ON eip.id = esosps.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON esos.id = esosps.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_projects" "sp" ON sp.id = esos.project_id LEFT JOIN (SELECT eip.product_id, sum(eips.outbound) as inventory_occupied_verifying, sum(eips.actual_total_amount) as total_amount_occupied_verifying FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eips.erp_inventory_product_id = eip.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "esos" ON eips.erp_sales_outbound_id = esos.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON eips.erp_sales_gift_id = esg.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eips.erp_inventory_lost_id = eil.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eips.erp_inventory_build_spent_id = eib.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eips.erp_inventory_disassemble_spent_id = eid.id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("esos"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) GROUP BY "eip"."product_id") "eipv" ON eipv.product_id = p.id WHERE "eip"."inventory" > 0 GROUP BY "p"."id")
18:09:57.3702.4 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-inventory-product/product-list', '{"Filter":{"name":"in_out_at","sort":"DESC"},"ErpProductSearch":{"erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":"","sales_rep":"","number_range_to":"","number_range_from":"","inventory":"1"},"page":"1","web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":{"stores":[{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}],"list":[{"id":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","product_type":7,"product_component":139,"product_brand":12,"product_serie":1730,"product_misc":"","product_qa":"","pn":"","description":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0\uff08\u7eaf\u8f6f\u7248\uff09\n\u4e91\u7aef\u667a\u80fd\u5927\u8111\u8f6f\u4ef6\uff0c\u5305\u542b\u4ee5\u4e0b\u80fd\u529b\uff1a\n1. 7*24H\u5168\u6808\u5728\u7ebf\u76d1\u6d4b\uff0c\u5305\u62ec\u670d\u52a1\u5668\u786c\u4ef6\u3001\u4e91\u5e73\u53f0\u3001\u4e91\u4e3b\u673aOS\u7b49\uff1b\n2. \u98ce\u9669\u4e3b\u52a8\u9884\u6d4b\uff0c\u5305\u62ec\u786c\u76d8\u5361\u6162\/\u574f\u9053\u3001SDD\u5bff\u547d\u3001\u5185\u5b58ECC\u9519\u8bef\u3001\u5e73\u53f0HA\u5931\u6548\u7b49\u98ce\u9669\u63d0\u524d\u9884\u8b66\uff1b\n3. \u98ce\u9669\/\u6545\u969c\u53ca\u65f6\u544a\u8b66\uff0c\u652f\u6301\u5c0f\u7a0b\u5e8f\u3001\u77ed\u4fe1\u3001\u90ae\u4ef6\u3001\u8bed\u97f3\u3001\u4f01\u4e1a\u5fae\u4fe1\/\u9489\u9489\/\u98de\u4e66\u673a\u5668\u4eba\u7b49\u591a\u901a\u8def\u901a\u77e5\uff1b\n4. \u4e91\u7aef\u667a\u80fd\u8fd0\u7ef4\uff0c\u652f\u6301\u544a\u8b66\u964d\u566a\u3001\u6839\u56e0\u5206\u6790\u548c\u5f71\u54cd\u9762\u8bc4\u4f30\uff0c\u63d0\u5347\u95ee\u9898\u5b9a\u4f4d\u6392\u969c\u6548\u7387\uff1b\n5. \u8fd0\u7ef4\u62a5\u544a\u8ba2\u9605\uff0c\u5e73\u53f0\u652f\u6301\u751f\u6210\u8fd0\u7ef4\u62a5\u544a\uff0c\u5305\u62ec\u5e73\u53f0\u670d\u52a1\u5668\u5065\u5eb7\u98ce\u9669\u9884\u6d4b\u548c\u8bc4\u4f30\uff08\u5982\uff1aCPU\/\u5185\u5b58\/\u786c\u76d8\/Raid\u5361\/\u7f51\u5361\u7b49\uff09\u3001\u4e91\u4e3b\u673a\u8fd0\u884c\u72b6\u6001\uff08\u5982\uff1aCPU\/\u5185\u5b58\/\u7f51\u7edc\u7b49\uff09\u98ce\u9669\u8bc4\u4f30\u7b49\uff1b\n\u914d\u5957\u670d\u52a1\u5982\u4e0b\uff1a\n\u8f6f\u4ef6\u5347\u7ea7\uff0c\u5305\u62ec\uff1a\u4e3b\u7ebf\u7248\u672c\/R\u7248\u672c\/SP\u7248\u672c\u7b49\u5728\u7ebf\u5347\u7ea7\u548c\u5b9a\u671f\u8865\u4e01\u66f4\u65b0\uff1b","created_by":1013,"created_at":"2025-11-28 11:49:14","updated_at":"2026-06-08 17:53:31","pinyin_shortcut":"sxfSDDCjcywrjV10","product_unit":2,"is_renew":false,"in_out_at":"2026-06-08 17:53:31.738476+08","inventory_occupied_verifying":"1","everyStoreErpInventoryCount":[{"product_id":2177,"erp_store_id":1,"outbound":"12","number":"12","inventory":"0","avg_amount":"29895.980000000000","avg_total_amount":"0.00000000000000000000"},{"product_id":2177,"erp_store_id":2,"outbound":"1","number":"2","inventory":"1","avg_amount":"888.0000000000000000","avg_total_amount":"444.0000000000000000"}],"erpInventoryCount":{"product_id":2177,"outbound":"13","number":"14","inventory":"1","avg_amount":"25061.316666666667","avg_total_amount":"74.0000000000000000","amount":"888.00","inventory_available":2,"inventory_occupied_verifying":"1"},"erpInventoryCount2":{"product_id":2177,"inventory":"1","avg_amount":888,"amount":888},"erpInventoryCount3":[{"id":506,"product_id":2177,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"2","outbound":"1","inventory":"1","amount":"888","total_amount":"1776.00","actual_amount":"888","actual_total_amount":"888","is_build":false,"created_at":"2026-05-20 14:04:06","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"0","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"0","erp_inventory_overflow_id":4,"erp_inventory_overflow_product_id":4}],"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":139,"key":139,"name":"\u8d85\u878d\u5408\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1730,"key":1730,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2177,"erp_store_id":1,"outbound":"12","number":"12","inventory":"0","avg_amount":"29895.980000000000","avg_total_amount":"0.00000000000000000000"},"everyStoreErpInventoryCount2":{"product_id":2177,"erp_store_id":2,"outbound":"1","number":"2","inventory":"1","avg_amount":"888.0000000000000000","avg_total_amount":"444.0000000000000000"}},{"id":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_type":7,"product_component":159,"product_brand":270,"product_serie":1724,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-11-24 16:16:45","updated_at":"2026-05-25 11:18:07","pinyin_shortcut":"jcxCRMrjfw","product_unit":2,"is_renew":false,"in_out_at":"2026-05-25 11:18:07.594762+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2171,"erp_store_id":2,"outbound":"1","number":"1","inventory":"0","avg_amount":"1.00000000000000000000","avg_total_amount":"0.00000000000000000000"},{"product_id":2171,"erp_store_id":1,"outbound":"2","number":"3","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":2171,"outbound":"3","number":"4","inventory":"1","avg_amount":"0.25000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":1,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2171,"inventory":"1","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":487,"product_id":2171,"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-30","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-30 13:38:29","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"0","sales_outbound":"0","erp_purchase_gift_id":21,"erp_purchase_gift_product_id":23,"sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":270,"key":270,"name":"\u91d1\u7545\u900d"},"productSerie":{"id":1724,"key":1724,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount2":{"product_id":2171,"erp_store_id":2,"outbound":"1","number":"1","inventory":"0","avg_amount":"1.00000000000000000000","avg_total_amount":"0.00000000000000000000"},"everyStoreErpInventoryCount1":{"product_id":2171,"erp_store_id":1,"outbound":"2","number":"3","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}},{"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-05-21 18:10:51","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-05-21 18:10:51.145864+08","inventory_occupied_verifying":"6","everyStoreErpInventoryCount":[{"product_id":2261,"erp_store_id":1,"outbound":"12","number":"66","inventory":"54","avg_amount":"7952.3561111111111111","avg_total_amount":"350.1111111111111111"},{"product_id":2261,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}],"erpInventoryCount":{"product_id":2261,"outbound":"12","number":"67","inventory":"55","avg_amount":"7157.2205000000000000","avg_total_amount":"315.2000000000000000","amount":"3152.000","inventory_available":61,"inventory_occupied_verifying":"6"},"erpInventoryCount2":{"product_id":2261,"inventory":"55","avg_amount":180.4,"amount":3152},"erpInventoryCount3":[{"id":494,"product_id":2261,"erp_purchase_inbound_id":212,"erp_purchase_order_id":2212,"erp_purchase_inbound_product_id":431,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"1","outbound":"0","inventory":"1","amount":"222","total_amount":"222.00","actual_amount":"222","actual_total_amount":"222","is_build":false,"created_at":"2026-05-09 17:09:10","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":502,"product_id":2261,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":5,"erp_inventory_overflow_product_id":6},{"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":"5","inventory":"51","amount":"45","total_amount":"2520","actual_amount":"45","actual_total_amount":"2295","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":"4","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":509,"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-05-20","number":"1","outbound":"0","inventory":"1","amount":"200","total_amount":"200.00","actual_amount":"200","actual_total_amount":"200","is_build":false,"created_at":"2026-05-21 16:54:55","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":6,"erp_inventory_overflow_product_id":10},{"id":510,"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-05-21","number":"1","outbound":"0","inventory":"1","amount":"434","total_amount":"434.00","actual_amount":"434","actual_total_amount":"434","is_build":false,"created_at":"2026-05-21 17:10:01","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":9,"erp_inventory_overflow_product_id":13}],"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2261,"erp_store_id":1,"outbound":"12","number":"66","inventory":"54","avg_amount":"7952.3561111111111111","avg_total_amount":"350.1111111111111111"},"everyStoreErpInventoryCount2":{"product_id":2261,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}},{"id":2262,"name":"PAN-SFP-PLUS-SR","product_type":5,"product_component":157,"product_brand":8,"product_serie":1781,"product_misc":"","product_qa":"","pn":"","description":"SFP+ form factor, SR 10Gb optical transceiver, short reach 300m, OM3 MMF, duplex LC, IEEE 802.3ae 10GBASE-SR compliant","created_by":1013,"created_at":"2026-03-17 14:26:23","updated_at":"2026-05-20 14:04:02","pinyin_shortcut":"PANSFPPLUSSR","product_unit":3,"is_renew":false,"in_out_at":"2026-05-20 14:04:02.191655+08","inventory_occupied_verifying":"1","everyStoreErpInventoryCount":[{"product_id":2262,"erp_store_id":1,"outbound":"1","number":"3","inventory":"2","avg_amount":"9540.8500000000000000","avg_total_amount":"9540.8500000000000000"},{"product_id":2262,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}],"erpInventoryCount":{"product_id":2262,"outbound":"1","number":"4","inventory":"3","avg_amount":"6360.9000000000000000","avg_total_amount":"6360.9000000000000000","amount":"19082.70","inventory_available":4,"inventory_occupied_verifying":"1"},"erpInventoryCount2":{"product_id":2262,"inventory":"3","avg_amount":4770.93,"amount":19082.7},"erpInventoryCount3":[{"id":505,"product_id":2262,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":5,"erp_inventory_overflow_product_id":9},{"id":493,"product_id":2262,"erp_purchase_inbound_id":211,"erp_purchase_order_id":2204,"erp_purchase_inbound_product_id":430,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"2","outbound":"0","inventory":"2","amount":"9540.85","total_amount":"19081.70","actual_amount":"9540.85","actual_total_amount":"19081.7","is_build":false,"created_at":"2026-04-30 14:34:15","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1781,"key":1781,"name":"\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2262,"erp_store_id":1,"outbound":"1","number":"3","inventory":"2","avg_amount":"9540.8500000000000000","avg_total_amount":"9540.8500000000000000"},"everyStoreErpInventoryCount2":{"product_id":2262,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000"}},{"id":2269,"name":"HAT5320-24T","product_type":3,"product_component":15,"product_brand":27,"product_serie":1786,"product_misc":"","product_qa":"","pn":"","description":"24T 3.5\" 7.2K SATA HDD","created_by":1013,"created_at":"2026-03-23 09:37:57","updated_at":"2026-05-20 14:04:02","pinyin_shortcut":"HAT532024T","product_unit":4,"is_renew":false,"in_out_at":"2026-05-20 14:04:02.191655+08","inventory_occupied_verifying":"10","everyStoreErpInventoryCount":[{"product_id":2269,"erp_store_id":2,"outbound":"4","number":"5","inventory":"1","avg_amount":"0.50000000000000000000","avg_total_amount":"0.50000000000000000000"},{"product_id":2269,"erp_store_id":1,"outbound":"69","number":"77","inventory":"8","avg_amount":"4517.6923076923076923","avg_total_amount":"7010.2307692307692308"}],"erpInventoryCount":{"product_id":2269,"outbound":"73","number":"82","inventory":"9","avg_amount":"3915.4000000000000000","avg_total_amount":"6075.6000000000000000","amount":"91134","inventory_available":19,"inventory_occupied_verifying":"10"},"erpInventoryCount2":{"product_id":2269,"inventory":"9","avg_amount":7594.83,"amount":91134},"erpInventoryCount3":[{"id":474,"product_id":2269,"erp_purchase_inbound_id":206,"erp_purchase_order_id":2208,"erp_purchase_inbound_product_id":421,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-08","number":"2","outbound":"0","inventory":"2","amount":"2323","total_amount":"4646","actual_amount":"2323","actual_total_amount":"4646","is_build":false,"created_at":"2026-04-08 11:02: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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":482,"product_id":2269,"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-09","number":"2","outbound":"1","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-09 10:28:25","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"1","sales_outbound":"0","erp_purchase_gift_id":19,"erp_purchase_gift_product_id":21,"sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":495,"product_id":2269,"erp_purchase_inbound_id":214,"erp_purchase_order_id":2209,"erp_purchase_inbound_product_id":433,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-05-12","number":"1","outbound":"0","inventory":"1","amount":"3","total_amount":"3.00","actual_amount":"3","actual_total_amount":"3","is_build":false,"created_at":"2026-05-12 14:24:10","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":484,"product_id":2269,"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-23","number":"2","outbound":"0","inventory":"2","amount":"43242","total_amount":"86484.00","actual_amount":"43242","actual_total_amount":"86484","is_build":false,"created_at":"2026-04-23 16:16:15","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"0","sales_outbound":"0","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"0","erp_inventory_disassemble_id":2,"erp_inventory_disassemble_product_id":3,"disassemble_spent_outbound":"0","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":504,"product_id":2269,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-05-20","number":"1","outbound":"0","inventory":"1","amount":"1","total_amount":"1.00","actual_amount":"1","actual_total_amount":"1","is_build":false,"created_at":"2026-05-20 14:04:02","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":5,"erp_inventory_overflow_product_id":8},{"id":481,"product_id":2269,"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-09","number":"2","outbound":"0","inventory":"2","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-09 10:27:35","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"0","sales_outbound":"0","erp_purchase_gift_id":18,"erp_purchase_gift_product_id":20,"sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"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":1786,"key":1786,"name":"HAT5300 \u7cfb\u5217\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"},"everyStoreErpInventoryCount2":{"product_id":2269,"erp_store_id":2,"outbound":"4","number":"5","inventory":"1","avg_amount":"0.50000000000000000000","avg_total_amount":"0.50000000000000000000"},"everyStoreErpInventoryCount1":{"product_id":2269,"erp_store_id":1,"outbound":"69","number":"77","inventory":"8","avg_amount":"4517.6923076923076923","avg_total_amount":"7010.2307692307692308"}},{"id":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":"","product_qa":"","pn":"","description":"PA-3400,PA-1400, ION 5200 and ION 9200 450W spare power supply","created_by":1013,"created_at":"2024-04-15 15:40:42","updated_at":"2026-04-30 14:34:15","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"in_out_at":"2026-04-30 14:34:15.937971+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1562,"erp_store_id":1,"outbound":"2","number":"4","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000"}],"erpInventoryCount":{"product_id":1562,"outbound":"2","number":"4","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000","amount":"19081.70","inventory_available":2,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1562,"inventory":"2","avg_amount":9540.85,"amount":19081.7},"erpInventoryCount3":[{"id":490,"product_id":1562,"erp_purchase_inbound_id":211,"erp_purchase_order_id":2204,"erp_purchase_inbound_product_id":427,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"2","outbound":"0","inventory":"2","amount":"9540.85","total_amount":"19081.70","actual_amount":"9540.85","actual_total_amount":"19081.7","is_build":false,"created_at":"2026-04-30 14:34:15","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"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":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":1562,"erp_store_id":1,"outbound":"2","number":"4","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000"}},{"id":1584,"name":"PAN-SVC-BKLN-1420","product_type":5,"product_component":35,"product_brand":8,"product_serie":1358,"product_misc":"","product_qa":"","pn":"","description":"PA-1420, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2024-04-26 09:33:52","updated_at":"2026-04-30 14:34:15","pinyin_shortcut":"PANSVCBKLN1420","product_unit":2,"is_renew":false,"in_out_at":"2026-04-30 14:34:15.937971+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1584,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"21681.660000000000","avg_total_amount":"43363.320000000000"}],"erpInventoryCount":{"product_id":1584,"outbound":"0","number":"2","inventory":"2","avg_amount":"21681.660000000000","avg_total_amount":"43363.320000000000","amount":"43363.32","inventory_available":2,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1584,"inventory":"2","avg_amount":21681.66,"amount":43363.32},"erpInventoryCount3":[{"id":491,"product_id":1584,"erp_purchase_inbound_id":211,"erp_purchase_order_id":2204,"erp_purchase_inbound_product_id":428,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-04-30","number":"2","outbound":"0","inventory":"2","amount":"21681.66","total_amount":"43363.32","actual_amount":"21681.66","actual_total_amount":"43363.32","is_build":false,"created_at":"2026-04-30 14:34:15","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1358,"key":1358,"name":"PA-1420\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":1584,"erp_store_id":1,"outbound":"0","number":"2","inventory":"2","avg_amount":"21681.660000000000","avg_total_amount":"43363.320000000000"}},{"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-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1372,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"},{"product_id":1372,"erp_store_id":1,"outbound":"34","number":"48","inventory":"14","avg_amount":"22.1666666666666667","avg_total_amount":"55.5000000000000000"}],"erpInventoryCount":{"product_id":1372,"outbound":"34","number":"49","inventory":"15","avg_amount":"19.0000000000000000","avg_total_amount":"47.5714285714285714","amount":"333","inventory_available":15,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1372,"inventory":"15","avg_amount":16.6,"amount":333},"erpInventoryCount3":[{"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":""},{"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":"1","inventory":"9","amount":"25","total_amount":"250","actual_amount":"25","actual_total_amount":"225","is_build":false,"created_at":"2025-08-27 13:18:21","lost_outbound":"0","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"1","sales_outbound":"0","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"0","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":486,"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":"2026-04-22","number":"1","outbound":"0","inventory":"1","amount":"33","total_amount":"33.00","actual_amount":"33","actual_total_amount":"33","is_build":false,"created_at":"2026-04-23 16:19:02","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":"","erp_inventory_disassemble_id":1,"erp_inventory_disassemble_product_id":2,"disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":479,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":2,"wrote_date":"2026-04-08","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-08 16:24:05","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":17,"erp_purchase_gift_product_id":18,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""},{"id":480,"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":"2026-04-08","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2026-04-08 16:24:05","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":17,"erp_purchase_gift_product_id":19,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"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"},"everyStoreErpInventoryCount2":{"product_id":1372,"erp_store_id":2,"outbound":"0","number":"1","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"},"everyStoreErpInventoryCount1":{"product_id":1372,"erp_store_id":1,"outbound":"34","number":"48","inventory":"14","avg_amount":"22.1666666666666667","avg_total_amount":"55.5000000000000000"}},{"id":2242,"name":"CB-992F","product_type":21,"product_component":227,"product_brand":278,"product_serie":1767,"product_misc":"","product_qa":"","pn":"","description":"\u9ad8\u6e05\u5206\u8fa8\u73871920*1080\u3001\u5bf9\u6bd4\u5ea616000:1\u30014000\u6d41\u660e\uff0c\u767d\u5929\u76f4\u6295","created_by":1013,"created_at":"2026-01-29 14:25:19","updated_at":"2026-03-31 17:15:49","pinyin_shortcut":"CB992F","product_unit":1,"is_renew":false,"in_out_at":"2026-03-31 17:15:49.970866+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2242,"erp_store_id":1,"outbound":"6","number":"10","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333"}],"erpInventoryCount":{"product_id":2242,"outbound":"6","number":"10","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333","amount":"178180","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2242,"inventory":"4","avg_amount":44545,"amount":178180},"erpInventoryCount3":[{"id":465,"product_id":2242,"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-03-31","number":"4","outbound":"0","inventory":"4","amount":"44545","total_amount":"178180.00","actual_amount":"44545","actual_total_amount":"178180","is_build":false,"created_at":"2026-03-31 16:41:14","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":5,"erp_inventory_build_product_id":5,"build_spent_outbound":"","sales_outbound":"","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":""}],"productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":227,"key":227,"name":"\u6295\u5f71\u673a"},"productBrand":{"id":278,"key":278,"name":"\u7231\u666e\u751f"},"productSerie":{"id":1767,"key":1767,"name":"\u9ad8\u4eae\u5546\u6559\u6295\u5f71\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"everyStoreErpInventoryCount1":{"product_id":2242,"erp_store_id":1,"outbound":"6","number":"10","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333"}},{"id":2255,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6\u8f85\u6599","product_type":21,"product_component":229,"product_brand":134,"product_serie":1776,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-02-04 16:29:24","updated_at":"2026-03-20 15:12:53","pinyin_shortcut":"tyyazpjfl","product_unit":2,"is_renew":false,"in_out_at":"2026-03-20 15:12:53.544213+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2255,"erp_store_id":1,"outbound":"0","number":"4","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000"}],"erpInventoryCount":{"product_id":2255,"outbound":"0","number":"4","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000","amount":"1140","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2255,"inventory":"4","avg_amount":285,"amount":1140},"erpInventoryCount3":[{"id":457,"product_id":2255,"erp_purchase_inbound_id":195,"erp_purchase_order_id":2188,"erp_purchase_inbound_product_id":402,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-20","number":"4","outbound":"0","inventory":"4","amount":"285","total_amount":"1140.00","actual_amount":"285","actual_total_amount":"1140","is_build":false,"created_at":"2026-03-20 15:12:53","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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1776,"key":1776,"name":"\u6295\u5f71\u4eea\u5b89\u88c5\u914d\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"},"everyStoreErpInventoryCount1":{"product_id":2255,"erp_store_id":1,"outbound":"0","number":"4","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.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":"2026-03-16 13:47:44","pinyin_shortcut":"lsyjxdlbptj","product_unit":11,"is_renew":false,"in_out_at":"2026-03-16 13:47:44.809959+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2074,"erp_store_id":1,"outbound":"24","number":"48","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000"}],"erpInventoryCount":{"product_id":2074,"outbound":"24","number":"48","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000","amount":"3600","inventory_available":24,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2074,"inventory":"24","avg_amount":150,"amount":3600},"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":"24","inventory":"24","amount":"150","total_amount":"7200","actual_amount":"150","actual_total_amount":"3600","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":"24","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":""}],"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":"24","number":"48","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000"}},{"id":1234,"name":"\u56fd\u7a961573 52%vol\uff08500mL \uff09","product_type":23,"product_component":194,"product_brand":196,"product_serie":818,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 17:09:38","updated_at":"2026-03-09 14:17:13","pinyin_shortcut":"gj157352vol500mL","product_unit":11,"is_renew":false,"in_out_at":"2026-03-09 14:17:13.804067+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1234,"erp_store_id":1,"outbound":"9","number":"13","inventory":"4","avg_amount":"889.5105555555333333","avg_total_amount":"1182.8022222221333333"}],"erpInventoryCount":{"product_id":1234,"outbound":"9","number":"13","inventory":"4","avg_amount":"889.5105555555333333","avg_total_amount":"1182.8022222221333333","amount":"3548.4066666664","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1234,"inventory":"4","avg_amount":887.1,"amount":3548.41},"erpInventoryCount3":[{"id":446,"product_id":1234,"erp_purchase_inbound_id":188,"erp_purchase_order_id":2195,"erp_purchase_inbound_product_id":389,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-03","number":"6","outbound":"2","inventory":"4","amount":"887.1016666666","total_amount":"5322.61","actual_amount":"887.1016666666","actual_total_amount":"3548.4066666664","is_build":false,"created_at":"2026-03-03 14:57:55","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":"2","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":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":196,"key":196,"name":"\u6cf8\u5dde\u8001\u7a96"},"productSerie":{"id":818,"key":818,"name":"\u56fd\u7a961573 52%vol"},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"everyStoreErpInventoryCount1":{"product_id":1234,"erp_store_id":1,"outbound":"9","number":"13","inventory":"4","avg_amount":"889.5105555555333333","avg_total_amount":"1182.8022222221333333"}},{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":941,"erp_store_id":1,"outbound":"24","number":"25","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":941,"outbound":"24","number":"25","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":1,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":941,"inventory":"1","avg_amount":0,"amount":0},"erpInventoryCount3":[{"id":309,"product_id":941,"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-12-17","number":"10","outbound":"9","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2025-12-17 16:59:42","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":"9","erp_purchase_gift_id":11,"erp_purchase_gift_product_id":12,"sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"everyStoreErpInventoryCount1":{"product_id":941,"erp_store_id":1,"outbound":"24","number":"25","inventory":"1","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}},{"id":1224,"name":"\u98de\u5929\u8305\u53f0\u9152 53%vol\uff08500ml\uff09","product_type":23,"product_component":194,"product_brand":187,"product_serie":809,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 16:04:37","updated_at":"2026-02-04 17:35:47","pinyin_shortcut":"ftmtj53vol500ml","product_unit":11,"is_renew":false,"in_out_at":"2026-02-04 17:35:47.741012+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":1224,"erp_store_id":1,"outbound":"6","number":"10","inventory":"4","avg_amount":"1829.3275000000000000","avg_total_amount":"3599.3100000000000000"}],"erpInventoryCount":{"product_id":1224,"outbound":"6","number":"10","inventory":"4","avg_amount":"1829.3275000000000000","avg_total_amount":"3599.3100000000000000","amount":"7198.620","inventory_available":4,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":1224,"inventory":"4","avg_amount":1799.66,"amount":7198.62},"erpInventoryCount3":[{"id":430,"product_id":1224,"erp_purchase_inbound_id":177,"erp_purchase_order_id":2185,"erp_purchase_inbound_product_id":371,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-02-03","number":"6","outbound":"2","inventory":"4","amount":"1799.655","total_amount":"10797.93","actual_amount":"1799.655","actual_total_amount":"7198.62","is_build":false,"created_at":"2026-02-03 18:08:45","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":"2","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":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":187,"key":187,"name":"\u8305\u53f0"},"productSerie":{"id":809,"key":809,"name":"\u98de\u5929\u8305\u53f0\u9152 53%vol"},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"everyStoreErpInventoryCount1":{"product_id":1224,"erp_store_id":1,"outbound":"6","number":"10","inventory":"4","avg_amount":"1829.3275000000000000","avg_total_amount":"3599.3100000000000000"}},{"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":"2026-01-12 14:43:53","pinyin_shortcut":"sdbzysbwbbhl","product_unit":3,"is_renew":false,"in_out_at":"2026-01-12 14:43:53.491388+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2078,"erp_store_id":1,"outbound":"12","number":"25","inventory":"13","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}],"erpInventoryCount":{"product_id":2078,"outbound":"12","number":"25","inventory":"13","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0","inventory_available":13,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2078,"inventory":"13","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":"12","inventory":"13","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":"12","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":""}],"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":"12","number":"25","inventory":"13","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000"}},{"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":"2026-01-12 14:43:53","pinyin_shortcut":"sdbdgsrkfchkffhhz21k2g","product_unit":9,"is_renew":false,"in_out_at":"2026-01-12 14:43:53.491388+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2073,"erp_store_id":1,"outbound":"17","number":"66","inventory":"49","avg_amount":"63.9800000000000000","avg_total_amount":"3135.0200000000000000"}],"erpInventoryCount":{"product_id":2073,"outbound":"17","number":"66","inventory":"49","avg_amount":"63.9800000000000000","avg_total_amount":"3135.0200000000000000","amount":"3135.02","inventory_available":49,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2073,"inventory":"49","avg_amount":63.98,"amount":3135.02},"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":"17","inventory":"49","amount":"63.98","total_amount":"4222.68","actual_amount":"63.98","actual_total_amount":"3135.02","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":"17","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":""}],"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":"17","number":"66","inventory":"49","avg_amount":"63.9800000000000000","avg_total_amount":"3135.0200000000000000"}},{"id":2080,"name":"\u7231\u56fd\u8005 8GB U\u76d8","product_type":23,"product_component":193,"product_brand":258,"product_serie":1681,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:35:49","updated_at":"2025-09-26 13:59:35","pinyin_shortcut":"agz8GBUp","product_unit":3,"is_renew":false,"in_out_at":"2025-09-26 13:59:35+08","inventory_occupied_verifying":"0","everyStoreErpInventoryCount":[{"product_id":2080,"erp_store_id":1,"outbound":"1","number":"9","inventory":"8","avg_amount":"15.4100000000000000","avg_total_amount":"123.2800000000000000"}],"erpInventoryCount":{"product_id":2080,"outbound":"1","number":"9","inventory":"8","avg_amount":"15.4100000000000000","avg_total_amount":"123.2800000000000000","amount":"123.28","inventory_available":8,"inventory_occupied_verifying":"0"},"erpInventoryCount2":{"product_id":2080,"inventory":"8","avg_amount":15.41,"amount":123.28},"erpInventoryCount3":[{"id":33,"product_id":2080,"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":"9","outbound":"1","inventory":"8","amount":"15.41","total_amount":"138.69","actual_amount":"15.41","actual_total_amount":"123.28","is_build":false,"created_at":"2025-08-08 17:36:13","lost_outbound":"","erp_inventory_start_id":22,"erp_inventory_start_product_id":33,"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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":193,"key":193,"name":"\u6570\u7801\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":258,"key":258,"name":"\u7231\u56fd\u8005"},"productSerie":{"id":1681,"key":1681,"name":"U\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"everyStoreErpInventoryCount1":{"product_id":2080,"erp_store_id":1,"outbound":"1","number":"9","inventory":"8","avg_amount":"15.4100000000000000","avg_total_amount":"123.2800000000000000"}},{"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,"in_out_at":"2025-08-08 18:11:19+08","inventory_occupied_verifying":"0","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","inventory_available":2,"inventory_occupied_verifying":"0"},"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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"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,"in_out_at":"2025-08-08 17:55:30+08","inventory_occupied_verifying":"0","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","inventory_available":3,"inventory_occupied_verifying":"0"},"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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"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,"in_out_at":"2025-08-08 17:53:59+08","inventory_occupied_verifying":"0","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","inventory_available":3,"inventory_occupied_verifying":"0"},"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":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":""}],"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"}}],"pagenation":{"totalcount":32,"thispage":1,"pagesize":20},"can_create_inventory_lost":true,"can_create_inventory_overflow":true,"can_create_inventory_build":true,"can_create_inventory_disassemble":true,"count":{"inventory":"307","total_amount":541804.61166667,"inventory_available":325,"total_amount_available":"453832.5566666664","inventory_occupied_verifying":"18","total_amount_occupied_verifying":"87972.055"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-08 18:09:57', 140549120) RETURNING "id"
18:09:57.3440.6 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 (2177, 2171, 2261, 2262, 2269, 1562, 1584, 1372, 2242, 2255, 2074, 1234, 941, 1224, 2078, 2073, 2080, 1025, 2086, 2085) GROUP BY "product_id", "erp_store_id"
18:09:57.2550.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:09:57.3450.6 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 (2177, 2171, 2261, 2262, 2269, 1562, 1584, 1372, 2242, 2255, 2074, 1234, 941, 1224, 2078, 2073, 2080, 1025, 2086, 2085)) GROUP BY "product_id"
18:09:57.3450.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" IN (2177, 2171, 2261, 2262, 2269, 1562, 1584, 1372, 2242, 2255, 2074, 1234, 941, 1224, 2078, 2073, 2080, 1025, 2086, 2085) GROUP BY "eip"."product_id"
18:09:57.3460.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (2177, 2171, 2261, 2262, 2269, 1562, 1584, 1372, 2242, 2255, 2074, 1234, 941, 1224, 2078, 2073, 2080, 1025, 2086, 2085))
18:09:57.2570.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:09:57.2600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:09:57.3510.3 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
18:09:57.3480.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1730, 1724, 1769, 1781, 1786, 1244, 1358, 1047, 1767, 1776, 1676, 818, 592, 809, 1679, 1675, 1681, 714, 1686, 1685)
18:09:57.3470.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (139, 159, 52, 157, 15, 36, 35, 43, 227, 229, 194, 151, 220, 195, 193, 5, 154)
18:09:57.2550.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:09:57.3470.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 270, 4, 8, 27, 134, 278, 256, 196, 133, 187, 255, 258, 152, 5, 2)
18:09:57.3470.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 4, 5, 3, 21, 23, 19, 2, 11)
18:09:57.3480.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 3, 4, 6, 1, 11, 7, 9)