ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4debc7f28fd: POST https://beta.jinchangxiao.com/vue/project/product-list at 2026-07-08 02:18:47 pm by 114.244.130.20

Performance Profiling

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

总计19条数据
TimeDurationCategoryInfo
  
14:18:48.0233.4 msyii\db\Command::querySELECT DISTINCT ON (lp.product_id) lp.product_id AS product_id, "ppr"."amount" AS "amount" FROM (SELECT DISTINCT ON (ppr.product_id) ppr.product_id AS product_id, "p"."id" AS "project_id" FROM "a57be577deb434"."tbl_project_product_rels" "ppr" INNER JOIN "a57be577deb434"."tbl_projects" "p" ON ppr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON p.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id WHERE (("ppr"."product_id" IN (1562, 994, 1339, 2233, 1340, 1584, 2262, 2171, 2266, 2268, 2270, 2091, 2090, 1241, 1528, 2242, 2263, 2264, 2255, 2074)) AND ("p"."project_status"=3)) AND (ppr.amount is not null) ORDER BY "ppr"."product_id", "p"."created_at" DESC, "p"."id" DESC) "lp" INNER JOIN "a57be577deb434"."tbl_project_product_rels" "ppr" ON ppr.project_id = lp.project_id AND ppr.product_id = lp.product_id WHERE ppr.amount is not null ORDER BY "lp"."product_id", "ppr"."id" DESC
14:18:48.0293.1 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/project/product-list', '{"page":"2","web_access_token":"--xxX6Gmp9PXF1XHWWwlXiYIP9-yVx7F"}', '{"code":2000,"result":{"list":[{"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-06-26 17:28:49","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","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"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1562,"erp_store_id":1,"outbound":"2","number":"4","purchase_inbound":"4","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1562,"outbound":"2","number":"4","purchase_inbound":"4","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"2","avg_amount":"9606.9250000000000000","avg_total_amount":"9540.8500000000000000","amount":"19081.70"},"bgcolor":"#89c541","last_amount":"2323","can_update":true,"can_delete":true},{"id":994,"name":"PAN-SVC-BKLN-1410-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":803,"product_misc":"","product_qa":"","pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2023-08-09 17:40:22","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANSVCBKLN14103YR","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","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":803,"key":803,"name":"PA-1410\u4e09\u5e74\u670d\u52a1"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":994,"erp_store_id":1,"outbound":"2","number":"2","purchase_inbound":"2","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"34350.000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":994,"outbound":"2","number":"2","purchase_inbound":"2","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"34350.000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"50297","can_update":true,"can_delete":true},{"id":1339,"name":"PAN-SVC-BKLN-460-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":1011,"product_misc":"","product_qa":"","pn":"","description":"PA-460, Partner enabled premium support, 3 years (36months), term. ","created_by":1013,"created_at":"2024-01-25 09:25:01","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANSVCBKLN4603YR","product_unit":8,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","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":1011,"key":1011,"name":"PA-460\u4e09\u5e74\u670d\u52a1"},"productMisc":{},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1339,"erp_store_id":1,"outbound":"2","number":"2","purchase_inbound":"2","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"18156.0000000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1339,"outbound":"2","number":"2","purchase_inbound":"2","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"18156.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"27234","can_update":true,"can_delete":true},{"id":2233,"name":"PAN-PA-460-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1004,"product_misc":"","product_qa":"","pn":"","description":"PA-460, Precision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, Advanced DNS Security and Advanced SD-WAN ), 3 years (36 months) term","created_by":1013,"created_at":"2026-01-12 11:22:00","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPA460BNDCORESEC3YR","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","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":1004,"key":1004,"name":"PA460\u8f6f\u4ef6\u6388\u6743"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2233,"erp_store_id":1,"outbound":"2","number":"2","purchase_inbound":"2","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"41797.000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2233,"outbound":"2","number":"2","purchase_inbound":"2","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"41797.000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"62695","can_update":true,"can_delete":true},{"id":1340,"name":"PAN-PWR-50W-AC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":"","product_qa":"","pn":"","description":"50W AC power adapter for PA-440 PA-450 and PA-460","created_by":1013,"created_at":"2024-01-25 09:26:04","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPWR50WAC","product_unit":3,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","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":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1340,"erp_store_id":1,"outbound":"3","number":"3","purchase_inbound":"3","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"961.5000000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1340,"outbound":"3","number":"3","purchase_inbound":"3","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"961.5000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"1384","can_update":true,"can_delete":true},{"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-06-26 14:39:52","pinyin_shortcut":"PANSVCBKLN1420","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 14:39:52.094142+08","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"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1584,"erp_store_id":1,"outbound":"0","number":"0","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"21681.660000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1584,"outbound":"0","number":"0","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"21681.660000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"24091.89","can_update":true,"can_delete":true},{"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-06-26 14:39:52","pinyin_shortcut":"PANSFPPLUSSR","product_unit":3,"is_renew":false,"in_out_at":"2026-06-26 14:39:52.094142+08","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"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2262,"erp_store_id":2,"outbound":"0","number":"1","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"1","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000","erpStore":{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}},{"product_id":2262,"erp_store_id":1,"outbound":"1","number":"3","purchase_inbound":"3","sales_outbound":"0","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"1","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"2","avg_amount":"9540.8500000000000000","avg_total_amount":"9540.8500000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2262,"outbound":"1","number":"4","purchase_inbound":"3","sales_outbound":"0","overflow_inbound":"1","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"1","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"3","avg_amount":"6360.9000000000000000","avg_total_amount":"6360.9000000000000000","amount":"19082.70"},"bgcolor":"#89c541","last_amount":"10600","can_update":true,"can_delete":true},{"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-06-23 13:48:49","pinyin_shortcut":"jcxCRMrjfw","product_unit":2,"is_renew":false,"in_out_at":"2026-06-23 13:48:49.894578+08","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"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2171,"erp_store_id":1,"outbound":"2","number":"4","purchase_inbound":"1","sales_outbound":"2","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"2","avg_amount":"150.0000000000000000","avg_total_amount":"150.0000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}},{"product_id":2171,"erp_store_id":2,"outbound":"0","number":"1","purchase_inbound":"0","sales_outbound":"0","overflow_inbound":"1","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"1","avg_amount":"1.00000000000000000000","avg_total_amount":"1.00000000000000000000","erpStore":{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}}],"erpInventoryCount":{"product_id":2171,"outbound":"2","number":"5","purchase_inbound":"1","sales_outbound":"2","overflow_inbound":"1","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"3","avg_amount":"120.2000000000000000","avg_total_amount":"120.2000000000000000","amount":"601"},"bgcolor":"#89c541","last_amount":"18000","can_update":true,"can_delete":true},{"id":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_type":23,"product_component":221,"product_brand":286,"product_serie":1783,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:38:56","updated_at":"2026-06-08 18:13:58","pinyin_shortcut":"sxddtxdxfhminibxkCM20","product_unit":3,"is_renew":false,"in_out_at":"2026-06-08 18:13:58.834274+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":286,"key":286,"name":"\u677e\u4e0b"},"productSerie":{"id":1783,"key":1783,"name":"\u7535\u52a8\u5243\u987b\u5200"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2266,"erp_store_id":1,"outbound":"20","number":"20","purchase_inbound":"20","sales_outbound":"20","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"278.0440000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2266,"outbound":"20","number":"20","purchase_inbound":"20","sales_outbound":"20","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"278.0440000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.000"},"bgcolor":"#89c541","last_amount":"54","can_update":true,"can_delete":true},{"id":2268,"name":"DS1825+","product_type":3,"product_component":14,"product_brand":27,"product_serie":1785,"product_misc":"","product_qa":"","pn":"","description":"\u63cf\u8ff0\uff1aDS1825+\u662f\u2f00\u6b3e\u591a\u529f\u80fd\u76848\u6258\u67b6\u5b58\u50a8\uff0cCPU\uff1aAMD Ryzen V1500B 4\u6838\u5fc3 64\u4f4d \u4e3b\u98912.2GHz\uff0c\u5185\u5b58\uff1a8 GB DDR4 ECC SODIMM\uff0c\u6700\u5927\u5185\u5b58\u5bb9\u91cf\uff1a32 GB\uff0816 GB x 2\uff09\uff0c8\u4e2a\u786c\u76d8\u69fd\u4f4d\uff0c2\u4e2aM.2 NVME\u786c\u76d8\u69fd\u4f4d\uff0c\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff0c2\u4e2aRJ-45 2.5GbE \u2f79\u2f1d\uff0c3\u4e2aUSB 3.2 Gen 1 \u7aef\u2f1d\uff0c3\u5e74\u786c\u4ef6\u4fdd\u4fee","created_by":1013,"created_at":"2026-03-23 09:31:52","updated_at":"2026-06-08 18:13:18","pinyin_shortcut":"DS1825","product_unit":1,"is_renew":false,"in_out_at":"2026-06-08 18:13:18.8309+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1785,"key":1785,"name":"DS1825+ NAS\u5b58\u50a8"},"productMisc":{},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2268,"erp_store_id":1,"outbound":"1","number":"1","purchase_inbound":"1","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"1","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"7760.0000000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2268,"outbound":"1","number":"1","purchase_inbound":"1","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"1","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"7760.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"4555","can_update":true,"can_delete":true},{"id":2270,"name":"\u4e2d\u56fd","product_type":2,"product_component":49,"product_brand":50,"product_serie":"","product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2026-04-30 13:28:48","updated_at":"2026-04-30 13:28:48","pinyin_shortcut":"zg","product_unit":1,"is_renew":false,"in_out_at":"","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":49,"key":49,"name":"\u670d\u52a1\u5668\u786c\u76d8\u6269\u5c55\u5957\u4ef6"},"productBrand":{"id":50,"key":50,"name":"\u5b8f\u6749"},"productSerie":{},"productMisc":{},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"productQa":"","everyStoreErpInventoryCount":[],"erpInventoryCount":"","bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":2091,"name":"\u5bc6\u5c01\u7f50\u73bb\u7483\u74f6\u5b50","product_type":23,"product_component":195,"product_brand":134,"product_serie":"","product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-11 18:00:03","updated_at":"2026-04-08 09:36:25","pinyin_shortcut":"mfgblpz","product_unit":3,"is_renew":false,"in_out_at":"2026-04-08 09:36:25.476911+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2091,"erp_store_id":1,"outbound":"10","number":"10","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"9.3300000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2091,"outbound":"10","number":"10","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"9.3300000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":2090,"name":"\u53e4\u8d8a\u9f99\u5c71\u9ec4\u9152\u5e93\u85cf\u91d1\u516b\u5e74","product_type":23,"product_component":195,"product_brand":134,"product_serie":"","product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-11 17:59:31","updated_at":"2026-04-08 09:36:25","pinyin_shortcut":"gylshjkcjbn","product_unit":11,"is_renew":false,"in_out_at":"2026-04-08 09:36:25.476911+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{},"productMisc":{},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2090,"erp_store_id":1,"outbound":"2","number":"2","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"49.5900000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2090,"outbound":"2","number":"2","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"49.5900000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":1241,"name":"\u7eaf\u624b\u5de5\u9e7f\u89d2\u9f9f\u7532\u818f\uff08250ml\uff09","product_type":23,"product_component":195,"product_brand":199,"product_serie":825,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 17:46:44","updated_at":"2026-04-08 09:36:25","pinyin_shortcut":"csgljgjg250ml","product_unit":11,"is_renew":false,"in_out_at":"2026-04-08 09:36:25.476911+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":199,"key":199,"name":"\u624b\u5de5\u52a0\u5de5"},"productSerie":{"id":825,"key":825,"name":"\u9e7f\u89d2\u9f9f\u7532\u818f"},"productMisc":{},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1241,"erp_store_id":1,"outbound":"3","number":"3","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"120.0000000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1241,"outbound":"3","number":"3","purchase_inbound":"0","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"120.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":1528,"name":"\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6V6.0","product_type":7,"product_component":29,"product_brand":12,"product_serie":525,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-03-26 15:30:32","updated_at":"2026-03-31 17:17:16","pinyin_shortcut":"sxfjsfwqxnhrjV60","product_unit":2,"is_renew":false,"in_out_at":"2026-03-31 17:17:16.259159+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":29,"key":29,"name":"\u865a\u62df\u5316\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":525,"key":525,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u8f6f\u4ef6"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1528,"erp_store_id":1,"outbound":"17","number":"17","purchase_inbound":"17","sales_outbound":"17","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"13405.330000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1528,"outbound":"17","number":"17","purchase_inbound":"17","sales_outbound":"17","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"13405.330000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"210000","can_update":true,"can_delete":true},{"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","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"},"productMisc":{},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2242,"erp_store_id":1,"outbound":"6","number":"10","purchase_inbound":"6","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"4","build_spent_outbound":"6","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2242,"outbound":"6","number":"10","purchase_inbound":"6","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"4","build_spent_outbound":"6","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"17028.333333333333","avg_total_amount":"59393.333333333333","amount":"178180"},"bgcolor":"#89c541","last_amount":"7500","can_update":true,"can_delete":true},{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2263,"erp_store_id":1,"outbound":"3","number":"3","purchase_inbound":"3","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"164.0000000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2263,"outbound":"3","number":"3","purchase_inbound":"3","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"164.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","last_amount":"35435","can_update":true,"can_delete":true},{"id":2264,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e0372\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:27","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb72c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2264,"erp_store_id":1,"outbound":"1","number":"1","purchase_inbound":"1","sales_outbound":"1","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"152.5400000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2264,"outbound":"1","number":"1","purchase_inbound":"1","sales_outbound":"1","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"152.5400000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"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","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"},"productMisc":{},"productUnit":{"id":2,"key":2,"name":"\u5957"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2255,"erp_store_id":1,"outbound":"0","number":"4","purchase_inbound":"4","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2255,"outbound":"0","number":"4","purchase_inbound":"4","sales_outbound":"","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"285.0000000000000000","avg_total_amount":"1140.0000000000000000","amount":"1140"},"bgcolor":"#89c541","last_amount":"0","can_update":true,"can_delete":true},{"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","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"},"productMisc":{},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2074,"erp_store_id":1,"outbound":"24","number":"48","purchase_inbound":"0","sales_outbound":"24","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2074,"outbound":"24","number":"48","purchase_inbound":"0","sales_outbound":"24","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"24","avg_amount":"150.0000000000000000","avg_total_amount":"3600.0000000000000000","amount":"3600"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true}],"can_create":true,"can_update":true,"can_delete":true,"can_manage":true,"pagenation":{"totalcount":2080,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.0.0 Safari\/537.36"}', FALSE, '2026-07-08 14:18:48', 34420992) RETURNING "id"
14:18:48.0072.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id ORDER BY "updated_at" DESC) "c"
14:18:48.0101.3 msyii\db\Command::querySELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id ORDER BY "updated_at" DESC LIMIT 20 OFFSET 20
14:18:48.0171.0 msyii\db\Command::querySELECT product_id, erp_store_id, sum(outbound) as outbound, sum(number) as number, sum(CASE WHEN erp_purchase_inbound_id IS NOT NULL THEN number ELSE 0 END) as purchase_inbound, sum(sales_outbound) as sales_outbound, sum(CASE WHEN erp_inventory_overflow_id IS NOT NULL THEN number ELSE 0 END) as overflow_inbound, sum(lost_outbound) as lost_outbound, sum(CASE WHEN erp_inventory_disassemble_id IS NOT NULL THEN number ELSE 0 END) as disassemble_inbound, sum(disassemble_spent_outbound) as disassemble_spent_outbound, sum(sales_gift_outbound) as sales_gift_outbound, sum(CASE WHEN erp_inventory_build_id IS NOT NULL THEN number ELSE 0 END) as build_inbound, sum(build_spent_outbound) as build_spent_outbound, sum(CASE WHEN erp_inventory_transfer_id IS NOT NULL THEN number ELSE 0 END) as transfer_inbound, sum(transfer_spent_outbound) as transfer_spent_outbound, 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 (1562, 994, 1339, 2233, 1340, 1584, 2262, 2171, 2266, 2268, 2270, 2091, 2090, 1241, 1528, 2242, 2263, 2264, 2255, 2074) GROUP BY "product_id", "erp_store_id"
14:18:48.0190.9 msyii\db\Command::querySELECT eip.product_id, sum(outbound) as outbound, sum(number) as number, sum(CASE WHEN eip.erp_purchase_inbound_id IS NOT NULL THEN eip.number ELSE 0 END) as purchase_inbound, sum(sales_outbound) as sales_outbound, sum(CASE WHEN eip.erp_inventory_overflow_id IS NOT NULL THEN eip.number ELSE 0 END) as overflow_inbound, sum(lost_outbound) as lost_outbound, sum(CASE WHEN eip.erp_inventory_disassemble_id IS NOT NULL THEN eip.number ELSE 0 END) as disassemble_inbound, sum(disassemble_spent_outbound) as disassemble_spent_outbound, sum(sales_gift_outbound) as sales_gift_outbound, sum(CASE WHEN eip.erp_inventory_build_id IS NOT NULL THEN eip.number ELSE 0 END) as build_inbound, sum(build_spent_outbound) as build_spent_outbound, sum(CASE WHEN eip.erp_inventory_transfer_id IS NOT NULL THEN eip.number ELSE 0 END) as transfer_inbound, sum(transfer_spent_outbound) as transfer_spent_outbound, 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 (1562, 994, 1339, 2233, 1340, 1584, 2262, 2171, 2266, 2268, 2270, 2091, 2090, 1241, 1528, 2242, 2263, 2264, 2255, 2074) GROUP BY "eip"."product_id"
14:18:47.9980.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5461
14:18:48.0000.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:18:48.0020.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:18:48.0130.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1244, 803, 1011, 1004, 1012, 1358, 1781, 1724, 1783, 1785, 825, 525, 1767, 1782, 1776, 1676)
14:18:47.9970.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:18:48.0120.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (36, 35, 157, 159, 221, 14, 49, 195, 29, 227, 229, 194)
14:18:48.0120.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 7, 23, 3, 2, 21)
14:18:48.0130.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 270, 286, 27, 50, 134, 199, 12, 278, 285, 256)
14:18:48.0160.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1013, 1001))
14:18:48.0150.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001)
14:18:48.0180.3 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id" IN (1, 2)
14:18:48.0140.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 3, 1, 11)
14:18:48.0160.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (7, 4)