ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a267f3903829: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-analysis-list at 2026-06-08 04:37:13 pm by 221.216.117.119

Performance Profiling

Total processing time: 46 ms; Peak memory: 5.767 MB. Show Profiling Timeline

总计12条数据
TimeDurationCategoryInfo
  
16:37:13.03516.3 msyii\db\Command::querySELECT p.*, sum(tmp1.number) AS inbound_number, sum(tmp1.amount) AS inbound_amount, sum(tmp1.inventory) AS inventory_number, sum(tmp1.inventory_amount) AS inventory_amount, sum(tmp2.outbound) AS outbound_number, sum(tmp2.amount) AS outbound_amount, sum(tmp3.number) AS inventory_start_number, sum(tmp3.amount) AS inventory_start_amount, sum(tmp4.number) AS inventory_lost_number, sum(tmp4.amount) AS inventory_lost_amount, sum(tmp5.number) AS inventory_overflow_number, sum(tmp5.amount) AS inventory_overflow_amount FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN (SELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, sum(amount * inventory) as inventory_amount, sum(amount * number) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "sub1" GROUP BY "sub1"."product_id") "tmp1" ON p.id = tmp1.product_id LEFT JOIN (SELECT "e"."product_id", sum(p.outbound) as outbound, sum(p.actual_total_amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "e" ON p.erp_inventory_product_id = e.id GROUP BY "e"."product_id") "tmp2" ON p.id = tmp2.product_id LEFT JOIN (SELECT p.product_id, sum(p.outbound) as outbound, sum(p.number - COALESCE(p.cancel_number, 0)) as number, sum((p.number - COALESCE(p.cancel_number, 0)) * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_start_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "e" ON p.erp_inventory_start_id = e.id GROUP BY "product_id") "tmp3" ON p.id = tmp3.product_id LEFT JOIN (SELECT "p"."product_id", sum(p.number) as number, sum(p.number * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_lost_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "e" ON p.erp_inventory_lost_id = e.id WHERE "e"."status" IN (2, 5) GROUP BY "product_id") "tmp4" ON p.id = tmp4.product_id LEFT JOIN (SELECT "p"."product_id", sum(p.number) as number, sum(p.number * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "e" ON p.erp_inventory_overflow_id = e.id WHERE "e"."status" IN (2, 5) GROUP BY "product_id") "tmp5" ON p.id = tmp5.product_id WHERE "p"."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 GROUP BY "p"."id") GROUP BY "p"."id" ORDER BY inventory_number DESC NULLS LAST, p.updated_at DESC, p.updated_at DESC LIMIT 20
16:37:13.02113.2 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, sum(tmp1.number) AS inbound_number, sum(tmp1.amount) AS inbound_amount, sum(tmp1.inventory) AS inventory_number, sum(tmp1.inventory_amount) AS inventory_amount, sum(tmp2.outbound) AS outbound_number, sum(tmp2.amount) AS outbound_amount, sum(tmp3.number) AS inventory_start_number, sum(tmp3.amount) AS inventory_start_amount, sum(tmp4.number) AS inventory_lost_number, sum(tmp4.amount) AS inventory_lost_amount, sum(tmp5.number) AS inventory_overflow_number, sum(tmp5.amount) AS inventory_overflow_amount FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN (SELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, sum(amount * inventory) as inventory_amount, sum(amount * number) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "sub1" GROUP BY "sub1"."product_id") "tmp1" ON p.id = tmp1.product_id LEFT JOIN (SELECT "e"."product_id", sum(p.outbound) as outbound, sum(p.actual_total_amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "e" ON p.erp_inventory_product_id = e.id GROUP BY "e"."product_id") "tmp2" ON p.id = tmp2.product_id LEFT JOIN (SELECT p.product_id, sum(p.outbound) as outbound, sum(p.number - COALESCE(p.cancel_number, 0)) as number, sum((p.number - COALESCE(p.cancel_number, 0)) * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_start_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "e" ON p.erp_inventory_start_id = e.id GROUP BY "product_id") "tmp3" ON p.id = tmp3.product_id LEFT JOIN (SELECT "p"."product_id", sum(p.number) as number, sum(p.number * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_lost_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "e" ON p.erp_inventory_lost_id = e.id WHERE "e"."status" IN (2, 5) GROUP BY "product_id") "tmp4" ON p.id = tmp4.product_id LEFT JOIN (SELECT "p"."product_id", sum(p.number) as number, sum(p.number * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "e" ON p.erp_inventory_overflow_id = e.id WHERE "e"."status" IN (2, 5) GROUP BY "product_id") "tmp5" ON p.id = tmp5.product_id WHERE "p"."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 GROUP BY "p"."id") GROUP BY "p"."id" ORDER BY inventory_number DESC NULLS LAST, p.updated_at DESC, p.updated_at DESC) "c"
16:37:13.0561.9 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-analysis-list', '{"Filter":{"name":"inventory_number","sort":"DESC"},"ErpProductSearch":{"wrote_date_period":"","erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":""},"page":"1","web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":{"list":[{"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","inbound_number":"67","inbound_amount":"110039.410","inventory_number":"55","inventory_amount":"3152.000","outbound_number":"12","outbound_amount":"106887.410","inventory_start_number":"56","inventory_start_amount":"2520","inventory_lost_number":"1","inventory_lost_amount":"35345","inventory_overflow_number":"3","inventory_overflow_amount":"635","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"}},{"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","inbound_number":"66","inbound_amount":"4222.68","inventory_number":"49","inventory_amount":"3135.02","outbound_number":"17","outbound_amount":"1087.66","inventory_start_number":"66","inventory_start_amount":"4222.68","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"id":2076,"name":"\u4eac\u4e1c\u4eac\u9020\u4e13\u7528\u65e0\u7ef3\u5ba4\u5185\u5065\u8eab\u8df3\u7ef3","product_type":23,"product_component":193,"product_brand":242,"product_serie":"","product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 16:52:54","updated_at":"2025-08-08 16:53:17","pinyin_shortcut":"jdjzzywssnjsts","product_unit":6,"is_renew":false,"in_out_at":"2025-08-08 16:53:17+08","inbound_number":"34","inbound_amount":"1005.38","inventory_number":"34","inventory_amount":"1005.38","outbound_number":"","outbound_amount":"","inventory_start_number":"34","inventory_start_amount":"1005.38","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":193,"key":193,"name":"\u6570\u7801\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":242,"key":242,"name":"\u4eac\u4e1c"},"productSerie":{},"productUnit":{"id":6,"key":6,"name":"\u6761"}},{"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","inbound_number":"48","inbound_amount":"7200","inventory_number":"24","inventory_amount":"3600","outbound_number":"24","outbound_amount":"3600","inventory_start_number":"48","inventory_start_amount":"7200","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"id":2083,"name":"HP \u9ed1\u9cb8 \u65e0\u7ebf\u9f20\u6807","product_type":11,"product_component":179,"product_brand":2,"product_serie":1683,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:44:09","updated_at":"2025-08-08 17:45:31","pinyin_shortcut":"HPhjwxsb","product_unit":3,"is_renew":false,"in_out_at":"2025-08-08 17:45:31+08","inbound_number":"17","inbound_amount":"834.36","inventory_number":"17","inventory_amount":"834.36","outbound_number":"","outbound_amount":"","inventory_start_number":"17","inventory_start_amount":"834.36","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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":1683,"key":1683,"name":"\u9f20\u6807"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"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,"in_out_at":"2025-08-08 17:45:31+08","inbound_number":"17","inbound_amount":"1202.75","inventory_number":"17","inventory_amount":"1202.75","outbound_number":"","outbound_amount":"","inventory_start_number":"17","inventory_start_amount":"1202.75","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"49","inbound_amount":"1183","inventory_number":"15","inventory_amount":"333","outbound_number":"34","outbound_amount":"850","inventory_start_number":"32","inventory_start_amount":"800","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"25","inbound_amount":"0","inventory_number":"13","inventory_amount":"0","outbound_number":"12","outbound_amount":"0","inventory_start_number":"25","inventory_start_amount":"0","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"id":1245,"name":"\u751a\u5143\u9738\u6c14\u818f\u7f50\u5934360\u514b\uff0812\u514bx30\uff09","product_type":23,"product_component":195,"product_brand":200,"product_serie":829,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 17:59:15","updated_at":"2025-08-08 16:45:38","pinyin_shortcut":"sybqggt360k12kx30","product_unit":9,"is_renew":false,"in_out_at":"2025-08-08 16:45:38+08","inbound_number":"13","inbound_amount":"4550","inventory_number":"13","inventory_amount":"4550","outbound_number":"","outbound_amount":"","inventory_start_number":"13","inventory_start_amount":"4550","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":200,"key":200,"name":"\u80e1\u5e86\u4f59\u5802"},"productSerie":{"id":829,"key":829,"name":"\u751a\u5143\u9738\u6c14\u818f\u7f50\u5934"},"productUnit":{"id":9,"key":9,"name":"\u76d2"}},{"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","inbound_number":"82","inbound_amount":"142769","inventory_number":"9","inventory_amount":"91134","outbound_number":"73","outbound_amount":"51635","inventory_start_number":"55","inventory_start_amount":"2475","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"1","inventory_overflow_amount":"1","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"}},{"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","inbound_number":"9","inbound_amount":"138.69","inventory_number":"8","inventory_amount":"123.28","outbound_number":"1","outbound_amount":"15.41","inventory_start_number":"9","inventory_start_amount":"138.69","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"id":1238,"name":"\u666e\u6d31\u8336\uff08\u719f\u8336\uff09\u6563\u8336\uff0850\u514b\uff09","product_type":23,"product_component":194,"product_brand":198,"product_serie":822,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 17:34:06","updated_at":"2025-08-08 16:57:21","pinyin_shortcut":"pecscsc50k","product_unit":13,"is_renew":false,"in_out_at":"2025-08-08 16:57:21+08","inbound_number":"6","inbound_amount":"0","inventory_number":"6","inventory_amount":"0","outbound_number":"","outbound_amount":"","inventory_start_number":"6","inventory_start_amount":"0","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":198,"key":198,"name":"\u5c0f\u7f50\u8336"},"productSerie":{"id":822,"key":822,"name":"\u666e\u6d31\u8336\uff08\u719f\u8336\uff09\u6563\u8336"},"productUnit":{"id":13,"key":13,"name":"\u7f50"}},{"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","inbound_number":"10","inbound_amount":"217420","inventory_number":"4","inventory_amount":"178180","outbound_number":"6","outbound_amount":"39240","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"4","inbound_amount":"1140","inventory_number":"4","inventory_amount":"1140","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"13","inbound_amount":"11579.2599999996","inventory_number":"4","inventory_amount":"3548.4066666664","outbound_number":"9","outbound_amount":"8030.8533333332","inventory_start_number":"5","inventory_start_amount":"4489.65","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"10","inbound_amount":"18233.930","inventory_number":"4","inventory_amount":"7198.620","outbound_number":"6","outbound_amount":"11035.31","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"4","inbound_amount":"28623.55","inventory_number":"3","inventory_amount":"19082.70","outbound_number":"1","outbound_amount":"9540.85","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"1","inventory_overflow_amount":"1","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"}},{"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","inbound_number":"3","inbound_amount":"2700","inventory_number":"3","inventory_amount":"2700","outbound_number":"","outbound_amount":"","inventory_start_number":"3","inventory_start_amount":"2700","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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","inbound_number":"3","inbound_amount":"1860","inventory_number":"3","inventory_amount":"1860","outbound_number":"","outbound_amount":"","inventory_start_number":"3","inventory_start_amount":"1860","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}},{"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,"in_out_at":"2025-08-08 17:47:38+08","inbound_number":"3","inbound_amount":"0","inventory_number":"3","inventory_amount":"0","outbound_number":"","outbound_amount":"","inventory_start_number":"3","inventory_start_amount":"0","inventory_lost_number":"","inventory_lost_amount":"","inventory_overflow_number":"","inventory_overflow_amount":"","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"}}],"pagenation":{"totalcount":2080,"thispage":1,"pagesize":20},"can_create_inventory_lost":true,"can_create_inventory_overflow":true,"can_create_inventory_build":true,"can_create_inventory_disassemble":true},"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 16:37:13', 41205248) RETURNING "id"
16:37:13.0160.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:37:13.0170.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:37:13.0180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:37:13.0530.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1769, 1675, 1676, 1683, 1684, 1047, 1679, 829, 1786, 1681, 822, 1767, 1776, 818, 809, 1781, 1686, 1685, 80)
16:37:13.0530.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 9, 6, 11, 4, 13, 1, 2)
16:37:13.0520.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (52, 195, 193, 194, 179, 43, 220, 15, 227, 229, 157, 5, 154, 21)
16:37:13.0520.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (4, 255, 242, 256, 2, 134, 200, 27, 258, 198, 278, 196, 187, 8, 5, 3)
16:37:13.0520.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 23, 11, 3, 21, 5, 2)
16:37:13.0160.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta