ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68b141a5f1aad: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-analysis-list at 2025-08-29 01:59:01 pm by 221.194.148.30

Performance Profiling

Total processing time: 49 ms; Peak memory: 5.229 MB. Show Profiling Timeline

总计11条数据
TimeDurationCategoryInfo
  
13:59:02.00813.7 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 FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN (SELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, sum(actual_amount * inventory) as inventory_amount, sum(actual_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 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 GROUP BY "p"."id") GROUP BY "p"."id" ORDER BY updated_at ASC nulls last, p.updated_at DESC LIMIT 20
13:59:02.0007.6 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 FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN (SELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, sum(actual_amount * inventory) as inventory_amount, sum(actual_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 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 GROUP BY "p"."id") GROUP BY "p"."id" ORDER BY updated_at ASC nulls last, p.updated_at DESC) "c"
13:59:02.0342.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-inventory-product/product-analysis-list', '{"Filter":{"name":"updated_at","sort":"ASC"},"ErpProductSearch":{"wrote_date_period":"","erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":""},"page":"1","web_access_token":"0jSj1j1zfu5hwB0xpQULAh1cJmt2onlX"}', '{"code":2000,"result":{"list":[{"id":995,"name":"W1000-RWAF-H0800A","product_type":4,"product_component":66,"product_brand":139,"product_serie":617,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-10 16:31:06","updated_at":"2023-08-11 15:54:27","pinyin_shortcut":"W1000RWAFH0800A","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":66,"key":66,"name":"\u7f51\u7edc\u5165\u4fb5\u9632\u62a4\u7cfb\u7edf"},"productBrand":{"id":139,"key":139,"name":"\u76db\u90a6\u5b89\u5168"},"productSerie":{"id":617,"key":617,"name":"W1000-RWAF-H0800A"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":960,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u63a2\u9488\u7279\u5f81\u5e93\u8f6f\u4ef6V2.0","product_type":4,"product_component":51,"product_brand":12,"product_serie":602,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-04 11:07:29","updated_at":"2023-08-11 15:59:57","pinyin_shortcut":"sxfaqgzxttztzkrjV20","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":602,"key":602,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u611f\u77e5\u7cfb\u7edf\u63a2\u9488\u7279\u5f81\u5e93\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":959,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-04 10:54:20","updated_at":"2023-08-11 16:00:02","pinyin_shortcut":"sxfURLxtrj","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":950,"name":"\u4e8c\u4ee3\u8bc1\u751f\u4ea7\u81ea\u52a8\u5316\u8bbe\u5907","product_type":18,"product_component":152,"product_brand":136,"product_serie":596,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:25:49","updated_at":"2023-08-11 16:01:35","pinyin_shortcut":"edzsczdhsb","product_unit":5,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":152,"key":152,"name":"\u751f\u4ea7\u8f66\u95f4\u8bbe\u5907"},"productBrand":{"id":136,"key":136,"name":"\u665f\u6e90"},"productSerie":{"id":596,"key":596,"name":"\u81ea\u52a8\u5316\u8f66\u95f4\u751f\u4ea7\u8bbe\u5907"},"productUnit":{"id":5,"key":5,"name":"\u6279"}},{"id":948,"name":"HP 82Q 8Gb Dual Port PCI-e FC HBA","product_type":2,"product_component":10,"product_brand":2,"product_serie":56,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:10:50","updated_at":"2023-08-11 16:01:47","pinyin_shortcut":"HP82Q8GbDualPortPCIeFCHBA","product_unit":3,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":10,"key":10,"name":"\u670d\u52a1\u5668HBA\u5361"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":56,"key":56,"name":"HP 81Q 8Gb PCI-e \u5355\u901a\u9053\u5149\u7ea4\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":946,"name":"\u4efb\u5b50\u884c\u7f51\u7edc\u5b89\u5168\u5ba1\u8ba1\u7cfb\u7edf","product_type":4,"product_component":55,"product_brand":135,"product_serie":594,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 11:11:04","updated_at":"2023-08-11 16:02:02","pinyin_shortcut":"rzxwlaqsjxt","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":55,"key":55,"name":"\u63a2\u9488"},"productBrand":{"id":135,"key":135,"name":"\u4efb\u5b50\u884c"},"productSerie":{"id":594,"key":594,"name":"\u7f51\u7edc\u5b89\u5168\u6001\u52bf\u611f\u77e5\u4e0e\u7ba1\u63a7\u5e73\u53f0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":943,"name":"VCS8-STD-G-SSS-C","product_type":7,"product_component":29,"product_brand":15,"product_serie":88,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 10:28:44","updated_at":"2023-08-11 16:02:10","pinyin_shortcut":"VCS8STDGSSSC","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":29,"key":29,"name":"\u865a\u62df\u5316\u8f6f\u4ef6"},"productBrand":{"id":15,"key":15,"name":"Vmware"},"productSerie":{"id":88,"key":88,"name":"\u670d\u52a1\u53ca\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":944,"name":"VS8-STD-G-SSS-C","product_type":7,"product_component":29,"product_brand":15,"product_serie":88,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 10:29:30","updated_at":"2023-08-11 16:02:14","pinyin_shortcut":"VS8STDGSSSC","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":29,"key":29,"name":"\u865a\u62df\u5316\u8f6f\u4ef6"},"productBrand":{"id":15,"key":15,"name":"Vmware"},"productSerie":{"id":88,"key":88,"name":"\u670d\u52a1\u53ca\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},{"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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","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"}},{"id":932,"name":"Paloalto Software NGFW\u865a\u62df\u9632\u706b\u5899","product_type":5,"product_component":26,"product_brand":8,"product_serie":339,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-07-12 09:44:29","updated_at":"2023-08-11 16:03:42","pinyin_shortcut":"PaloaltoSoftwareNGFWxnfhq","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":339,"key":339,"name":"PA\u865a\u62df\u7aef\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":923,"name":"\u6df1\u4fe1\u670d\u6f0f\u6d1e\u626b\u63cf\u7eed\u4fdd\u670d\u52a1","product_type":4,"product_component":47,"product_brand":12,"product_serie":582,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:13:05","updated_at":"2023-08-11 16:04:39","pinyin_shortcut":"sxfldsmxbfw","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":582,"key":582,"name":"\u6f0f\u6d1e\u626b\u63cf\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":921,"name":"\u6df1\u4fe1\u670d\u6570\u636e\u5e93\u5b89\u5168\u5ba1\u8ba1\u7cfb\u7edf\u7eed\u4fdd\u670d\u52a1","product_type":4,"product_component":47,"product_brand":12,"product_serie":581,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:08:40","updated_at":"2023-08-11 16:04:49","pinyin_shortcut":"sxfsjkaqsjxtxbfw","product_unit":2,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":581,"key":581,"name":"\u5b89\u5168\u5ba1\u8ba1\u7cfb\u7edf\u7eed\u4fdd"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":918,"name":"\u6df1\u4fe1\u670d\u5821\u5792\u673a\u7eed\u4fdd\u670d\u52a1","product_type":4,"product_component":47,"product_brand":12,"product_serie":578,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-05-08 11:52:53","updated_at":"2023-08-11 16:05:15","pinyin_shortcut":"sxfbljxbfw","product_unit":8,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":47,"key":47,"name":"\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":578,"key":578,"name":"\u5821\u5792\u673a\u7eed\u4fdd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},{"id":915,"name":"64GB PC4-2933\u5185\u5b58","product_type":2,"product_component":4,"product_brand":4,"product_serie":29,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-03-23 15:58:26","updated_at":"2023-08-11 16:05:33","pinyin_shortcut":"64GBPC42933nc","product_unit":6,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":29,"key":29,"name":"DDR4"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},{"id":914,"name":"PH3120KS","product_type":14,"product_component":149,"product_brand":130,"product_serie":576,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-03-14 15:25:08","updated_at":"2023-08-11 16:05:43","pinyin_shortcut":"PH3120KS","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":14,"key":14,"name":"UPS"},"productComponent":{"id":149,"key":149,"name":"\u9ad8\u6027\u80fdUPS"},"productBrand":{"id":130,"key":130,"name":"\u6d77\u8bfa\u6cf0"},"productSerie":{"id":576,"key":576,"name":"PH\u7cfb\u52171-20KVA\u9ad8\u6027\u80fdUPS"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":913,"name":"PH1110KS","product_type":14,"product_component":149,"product_brand":130,"product_serie":576,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-03-14 15:24:32","updated_at":"2023-08-11 16:05:48","pinyin_shortcut":"PH1110KS","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":14,"key":14,"name":"UPS"},"productComponent":{"id":149,"key":149,"name":"\u9ad8\u6027\u80fdUPS"},"productBrand":{"id":130,"key":130,"name":"\u6d77\u8bfa\u6cf0"},"productSerie":{"id":576,"key":576,"name":"PH\u7cfb\u52171-20KVA\u9ad8\u6027\u80fdUPS"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":912,"name":"SIP-Logger-A600","product_type":4,"product_component":148,"product_brand":12,"product_serie":575,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-03-14 15:13:20","updated_at":"2023-08-11 16:05:58","pinyin_shortcut":"SIPLoggerA600","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":148,"key":148,"name":"\u65e5\u5fd7\u5206\u6790\u7ba1\u7406\u7cfb\u7edf"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":575,"key":575,"name":"SIP-Logger-A600"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":911,"name":"OSM-1000-B2100","product_type":4,"product_component":59,"product_brand":12,"product_serie":574,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-03-14 15:09:22","updated_at":"2023-08-11 16:06:02","pinyin_shortcut":"OSM1000B2100","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":59,"key":59,"name":"\u5821\u5792\u673a"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":574,"key":574,"name":"OSM-1000"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":910,"name":"EDR-1000-C600","product_type":4,"product_component":147,"product_brand":12,"product_serie":573,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-03-14 15:06:45","updated_at":"2023-08-11 16:06:08","pinyin_shortcut":"EDR1000C600","product_unit":1,"is_renew":false,"inbound_number":"","inbound_amount":"","inventory_number":"","inventory_amount":"","outbound_number":"","outbound_amount":"","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":147,"key":147,"name":"\u7ec8\u7aef\u75c5\u6bd2\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":573,"key":573,"name":"EDR-1000"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}],"pagenation":{"totalcount":1886,"thispage":1,"pagesize":20},"can_create_inventory_lost":true,"can_create_inventory_build":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-29 13:59:02') RETURNING "id"
13:59:01.9932.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:59:01.9911.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:59:01.9961.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:59:02.0290.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 18, 2, 7, 19, 5, 14)
13:59:02.0310.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (617, 602, 231, 596, 56, 594, 88, 593, 592, 339, 582, 581, 578, 29, 576, 575, 574, 573)
13:59:02.0310.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 2, 5, 3, 7, 8, 6)
13:59:02.0300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (66, 51, 152, 10, 55, 29, 151, 26, 47, 4, 149, 148, 59, 147)
13:59:02.0310.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (139, 12, 136, 2, 135, 15, 134, 133, 8, 4, 130)