ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68b141958de37: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-analysis-list at 2025-08-29 01:58:45 pm by 115.171.251.24

Database Queries

总计10条数据
TimeDurationTypeQuery
  
13:58:45.5842.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:58:45.5871.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
13:58:45.5916.3 msSELECTSELECT 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 created_at ASC nulls last, p.updated_at DESC) "c"

[+] Explain
13:58:45.5988.9 msSELECTSELECT 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 created_at ASC nulls last, p.updated_at DESC LIMIT 20

[+] Explain
13:58:45.6070.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 7, 3, 5)

[+] Explain
13:58:45.6080.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (2, 11, 5, 3, 6, 10, 9, 30, 17, 14, 32, 26, 35, 12, 7)

[+] Explain
13:58:45.6080.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (2, 16, 6, 4, 18, 8, 3)

[+] Explain
13:58:45.6084.9 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (3, 57, 892, 14, 44, 909, 58, 1051, 346, 63, 64, 1182, 66, 59, 60, 792, 780, 52, 53)

[+] Explain
13:58:45.6130.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 3, 4, 2, 8)

[+] Explain
13:58:45.6161.6 msINSERTINSERT 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":"created_at","sort":"ASC"},"ErpProductSearch":{"wrote_date_period":"","erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":""},"page":"1","web_access_token":"HeB87gSAu510bf8x6dfUJ9l8lA4Eoolw"}', '{"code":2000,"result":{"list":[{"id":2,"name":"816820-AA1","product_type":2,"product_component":2,"product_brand":2,"product_serie":3,"product_misc":2,"product_qa":4,"pn":"793318-AA1","description":"","created_by":1013,"created_at":"2017-02-09 10:19:31","updated_at":"2024-03-11 15:20:25","pinyin_shortcut":"816820AA1","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":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":3,"key":3,"name":"DL580G9\u670d\u52a1\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":3,"name":"788360-B21","product_type":2,"product_component":11,"product_brand":2,"product_serie":57,"product_misc":8,"product_qa":4,"pn":"788360-B21","description":"","created_by":1013,"created_at":"2017-02-09 10:34:53","updated_at":"2024-01-22 10:44:05","pinyin_shortcut":"788360B21","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":11,"key":11,"name":"\u670d\u52a1\u5668CPU\u5185\u5b58\u6269\u5c55\u677f"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":57,"key":57,"name":"HP DL580G9\u5185\u5b58\u6269\u5c55\u677f"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":4,"name":"713827-B21","product_type":2,"product_component":5,"product_brand":2,"product_serie":892,"product_misc":8,"product_qa":2,"pn":"781516-B21","description":"","created_by":1013,"created_at":"2017-02-09 11:45:04","updated_at":"2024-01-18 14:06:33","pinyin_shortcut":"713827B21","product_unit":4,"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":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":892,"key":892,"name":"600G 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":5,"name":"E7-4830V3","product_type":2,"product_component":3,"product_brand":2,"product_serie":14,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-02-09 11:47:34","updated_at":"2023-08-14 10:34:39","pinyin_shortcut":"E74830V3","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":3,"key":3,"name":"\u670d\u52a1\u5668CPU"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":14,"key":14,"name":"E7"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":6,"name":"656364-B21","product_type":2,"product_component":6,"product_brand":2,"product_serie":44,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-09 14:01:58","updated_at":"2024-01-19 15:42:55","pinyin_shortcut":"656364B21","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":6,"key":6,"name":"\u670d\u52a1\u5668\u7535\u6e90"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":44,"key":44,"name":"GEN8 1200W\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":7,"name":"AJ764A","product_type":2,"product_component":10,"product_brand":2,"product_serie":909,"product_misc":8,"product_qa":2,"pn":"AK344A","description":"","created_by":1013,"created_at":"2017-02-09 14:36:33","updated_at":"2024-01-22 10:35:45","pinyin_shortcut":"AJ764A","product_unit":4,"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":909,"key":909,"name":"HP 82Q 8Gb Dual-port PCI-e FC HBA"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":8,"name":"727055-B21","product_type":2,"product_component":9,"product_brand":2,"product_serie":58,"product_misc":8,"product_qa":2,"pn":"665249-B21","description":"","created_by":1013,"created_at":"2017-02-09 14:42:20","updated_at":"2024-01-22 10:27:11","pinyin_shortcut":"727055B21","product_unit":4,"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":9,"key":9,"name":"\u670d\u52a1\u5668\u7f51\u5361"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":58,"key":58,"name":"HP 10Gb 2-port 560SFP \u4e07\u5146 \u7f51\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":9,"name":"V-FDNVUL-0I- SU1YP-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1051,"product_misc":5,"product_qa":2,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 10 instance pack. 1 Year Subscription Upfront Billing & Production (24\/7) Support. ","created_by":1013,"created_at":"2017-02-09 17:00:55","updated_at":"2024-01-26 17:18:42","pinyin_shortcut":"VFDNVUL0ISU1YP00","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":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1051,"key":1051,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":10,"name":"Netapp DS2246\u6269\u5c55\u67dc","product_type":3,"product_component":17,"product_brand":6,"product_serie":346,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-09 17:36:46","updated_at":"2024-02-01 15:14:48","pinyin_shortcut":"NetappDS2246kzg","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":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":346,"key":346,"name":"Netapp DS2246\u6269\u5c55\u67dc"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":11,"name":"FAS2554-R6","product_type":3,"product_component":14,"product_brand":6,"product_serie":63,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-09 17:38:12","updated_at":"2024-02-01 16:15:09","pinyin_shortcut":"FAS2554R6","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":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":63,"key":63,"name":"NETAPP FAS2554 \u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":12,"name":"42D0501","product_type":2,"product_component":10,"product_brand":4,"product_serie":64,"product_misc":4,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-02-09 17:42:19","updated_at":"2024-02-19 13:00:11","pinyin_shortcut":"42D0501","product_unit":4,"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":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":64,"key":64,"name":"\u8054\u60f3 8Gb\u5355\u7aef\u53e3 PCI-E FC\u5149\u7ea4\u901a\u9053\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":13,"name":"49Y4232","product_type":2,"product_component":9,"product_brand":4,"product_serie":1182,"product_misc":8,"product_qa":2,"pn":"00AG510","description":"","created_by":1013,"created_at":"2017-02-09 17:49:49","updated_at":"2024-02-19 10:59:39","pinyin_shortcut":"49Y4232","product_unit":4,"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":9,"key":9,"name":"\u670d\u52a1\u5668\u7f51\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1182,"key":1182,"name":"\u8054\u60f3 I340-T2\u53cc\u53e3\u5343\u5146\u7f51\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":14,"name":"\u4e9a\u4fe1 Deep Security Manager Entry-Perconsile \u7ba1\u7406\u63a7\u5236\u53f0","product_type":7,"product_component":32,"product_brand":18,"product_serie":66,"product_misc":5,"product_qa":2,"pn":"","description":"12\u5ba2\u6237\u7aef\uff0c6CPU","created_by":1013,"created_at":"2017-02-09 17:56:55","updated_at":"2023-08-14 11:17:24","pinyin_shortcut":"yxDeepSecurityManagerEntryPerconsileglkzt","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":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":66,"key":66,"name":"\u4e9a\u4fe1\u5b89\u5168\u9632\u62a4 Deep Security\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":15,"name":"\u4e9a\u4fe1 Deep Security 9.x AV-Per CPU \u65e0\u4ee3\u7406\u9632\u75c5\u6bd2\u6a21\u5757","product_type":7,"product_component":32,"product_brand":18,"product_serie":66,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-02-09 17:57:49","updated_at":"2023-08-14 11:17:28","pinyin_shortcut":"yxDeepSecurity9xAVPerCPUwdlfbdmk","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":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":18,"key":18,"name":"\u4e9a\u4fe1"},"productSerie":{"id":66,"key":66,"name":"\u4e9a\u4fe1\u5b89\u5168\u9632\u62a4 Deep Security\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":16,"name":"PAN-PA-500","product_type":5,"product_component":26,"product_brand":8,"product_serie":59,"product_misc":5,"product_qa":4,"pn":"PAN-PA-500","description":"","created_by":1013,"created_at":"2017-02-10 09:34:49","updated_at":"2024-01-12 14:52:04","pinyin_shortcut":"PANPA500","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":59,"key":59,"name":"PA-500\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":17,"name":"PAN-SVC-BKLN-500-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":60,"product_misc":5,"product_qa":2,"pn":"PAN-SVC-BKLN-500","description":"Partner enabled premium support renewal, PA-500","created_by":1013,"created_at":"2017-02-10 09:36:21","updated_at":"2024-01-12 14:51:39","pinyin_shortcut":"PANSVCBKLN500R","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":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":60,"key":60,"name":"PA-500\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},{"id":18,"name":"PAN-PA-500-TP","product_type":5,"product_component":35,"product_brand":8,"product_serie":792,"product_misc":5,"product_qa":2,"pn":"PAN-PA-500-TP","description":"Threat prevention subscription year 1, PA-500","created_by":1013,"created_at":"2017-02-10 09:37:50","updated_at":"2024-01-12 14:49:35","pinyin_shortcut":"PANPA500TP","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":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":792,"key":792,"name":"PA-500\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":19,"name":"UCS-SP-MINI-AC2","product_type":2,"product_component":12,"product_brand":3,"product_serie":780,"product_misc":5,"product_qa":4,"pn":"UCSB-5108-AC2-UPG","description":"","created_by":1013,"created_at":"2017-02-10 09:42:29","updated_at":"2024-01-12 13:24:13","pinyin_shortcut":"UCSSPMINIAC2","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":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":12,"key":12,"name":"\u670d\u52a1\u5668\u5200\u7247\u673a\u7bb1"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":780,"key":780,"name":"\u601d\u79d1UCS5108MINI\u5200\u7247\u673a\u7bb1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":20,"name":"UCSC-MRAID12G","product_type":2,"product_component":7,"product_brand":3,"product_serie":52,"product_misc":4,"product_qa":4,"pn":"UCSC-MRAID12G","description":"","created_by":1013,"created_at":"2017-02-10 09:53:55","updated_at":"2024-01-12 13:20:37","pinyin_shortcut":"UCSCMRAID12G","product_unit":4,"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":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":52,"key":52,"name":"\u601d\u79d1 12G SAS MODULAR RAID \u9635\u5217\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":21,"name":"UCSC-MRAID12G-1GB","product_type":2,"product_component":7,"product_brand":3,"product_serie":53,"product_misc":4,"product_qa":4,"pn":"UCSC-MRAID12G-1GB","description":"","created_by":1013,"created_at":"2017-02-10 09:54:59","updated_at":"2024-01-12 13:19:03","pinyin_shortcut":"UCSCMRAID12G1GB","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":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":53,"key":53,"name":"\u601d\u79d1 12G SAS 1GB FBWC\u7f13\u5b58"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}],"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:58:45') RETURNING "id"

[+] Explain