ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7b6a40518f: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-analysis-list at 2025-09-15 02:48:04 pm by 115.171.251.67

Log Messages

总计43条数据
TimeLevelCategoryMessage
 
14:48:04.020traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:48:04.020traceyii\base\Module::getModuleLoading module: debug
14:48:04.020traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:48:04.020traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:48:04.021traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:48:04.021traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.021traceyii\base\Module::getModuleLoading module: gii
14:48:04.021traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:48:04.021traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:48:04.021traceyii\web\Application::handleRequestRoute requested: 'vue/erp-inventory-product/product-analysis-list'
14:48:04.021traceyii\base\Module::getModuleLoading module: vue
14:48:04.021infoyii\web\Session::openSession started
14:48:04.022infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
14:48:04.022infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:48:04.026traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.026traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:48:04.027traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.027traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:48:04.027infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
14:48:04.029traceyii\base\Controller::runActionRoute to run: vue/erp-inventory-product/product-analysis-list
14:48:04.029traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.030traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:48:04.030traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpInventoryProductController::actionProductAnalysisList()
14:48:04.030traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.030traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:48:04.031infoyii\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(amount * inventory) as inventory_amount, sum(amount * number) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "sub1" GROUP BY "sub1"."product_id") "tmp1" ON p.id = tmp1.product_id LEFT JOIN (SELECT "e"."product_id", sum(p.outbound) as outbound, sum(p.actual_total_amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "e" ON p.erp_inventory_product_id = e.id GROUP BY "e"."product_id") "tmp2" ON p.id = tmp2.product_id LEFT JOIN (SELECT p.product_id, sum(p.outbound) as outbound, sum(p.number - COALESCE(p.cancel_number, 0)) as number, sum((p.number - COALESCE(p.cancel_number, 0)) * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_start_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "e" ON p.erp_inventory_start_id = e.id GROUP BY "product_id") "tmp3" ON p.id = tmp3.product_id LEFT JOIN (SELECT "p"."product_id", sum(p.number) as number, sum(p.number * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_lost_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "e" ON p.erp_inventory_lost_id = e.id WHERE "e"."status" IN (2, 5) GROUP BY "product_id") "tmp4" ON p.id = tmp4.product_id 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 DESC nulls last, p.updated_at DESC) "c"
14:48:04.038infoyii\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(amount * inventory) as inventory_amount, sum(amount * number) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "sub1" GROUP BY "sub1"."product_id") "tmp1" ON p.id = tmp1.product_id LEFT JOIN (SELECT "e"."product_id", sum(p.outbound) as outbound, sum(p.actual_total_amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "e" ON p.erp_inventory_product_id = e.id GROUP BY "e"."product_id") "tmp2" ON p.id = tmp2.product_id LEFT JOIN (SELECT p.product_id, sum(p.outbound) as outbound, sum(p.number - COALESCE(p.cancel_number, 0)) as number, sum((p.number - COALESCE(p.cancel_number, 0)) * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_start_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "e" ON p.erp_inventory_start_id = e.id GROUP BY "product_id") "tmp3" ON p.id = tmp3.product_id LEFT JOIN (SELECT "p"."product_id", sum(p.number) as number, sum(p.number * p.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_lost_products" "p" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "e" ON p.erp_inventory_lost_id = e.id WHERE "e"."status" IN (2, 5) GROUP BY "product_id") "tmp4" ON p.id = tmp4.product_id 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 DESC nulls last, p.updated_at DESC LIMIT 20
14:48:04.047infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 3, 7, 5, 22, 23)
14:48:04.048infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (23, 39, 32, 36, 14, 159, 15, 200, 157, 188, 26, 43, 194, 21)
14:48:04.048infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 27, 137, 8, 261, 256, 20, 6, 191)
14:48:04.049infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (172, 1523, 633, 1382, 1691, 1692, 1578, 1693, 1700, 1699, 1640, 742, 743, 1033, 1698, 1676, 531, 75, 813)
14:48:04.049infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 3, 11, 4, 6)
14:48:04.050traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.050traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.052traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.052traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:48:04.052infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
14:48:04.056traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.056traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:48:04.056infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=63, "last_visit_at"='now()' WHERE "id"=56565
14:48:04.057infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/erp-inventory-product/product-analysis-list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpProductSearch":{"wrote_date_period":"","erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":""},"page":"1","web_access_token":"zACaxwY58DCRigSw1MlM3KllVvnv2n5E"}', '{"code":2000,"result":{"list":[{"id":2105,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:34:25","updated_at":"2025-09-15 10:47:16","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B1500","product_unit":2,"is_renew":false,"inbound_number":"2","inbound_amount":"67405.68","inventory_number":"1","inventory_amount":"33702.84","outbound_number":"1","outbound_amount":"33702.84","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":1812,"name":"RKS-02","product_type":3,"product_component":39,"product_brand":27,"product_serie":1523,"product_misc":"","product_qa":"","pn":"","description":"Synology RKS-02 \u53ef\u673a\u67b6\u5b89\u88c5 \u9f7f\u8f68 \u7528\u4e8e \u670d\u52a1\u5668","created_by":1013,"created_at":"2024-10-09 11:33:47","updated_at":"2025-09-15 10:46:14","pinyin_shortcut":"RKS02","product_unit":2,"is_renew":false,"inbound_number":"2","inbound_amount":"1100","inventory_number":"1","inventory_amount":"550","outbound_number":"1","outbound_amount":"550","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1523,"key":1523,"name":"\u673a\u67b6\u5bfc\u8f68\u5957\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-12 15:58:12","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"inbound_number":"12","inbound_amount":"108","inventory_number":"4","inventory_amount":"72","outbound_number":"8","outbound_amount":"36","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":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"inbound_number":"14","inbound_amount":"19502","inventory_number":"1","inventory_amount":"1393","outbound_number":"13","outbound_amount":"18109","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","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":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":"","product_qa":"","pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"inbound_number":"104","inbound_amount":"233100","inventory_number":"100","inventory_amount":"84900","outbound_number":"4","outbound_amount":"75524.75","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":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":2100,"name":"Adobe\u5168\u5bb6\u6876","product_type":7,"product_component":159,"product_brand":261,"product_serie":"","product_misc":"","product_qa":"","pn":"","description":"Creative Cloud for teams All Apps 12 months \u5168\u5bb6\u6876","created_by":1013,"created_at":"2025-08-15 14:51:48","updated_at":"2025-09-04 09:08:12","pinyin_shortcut":"Adobeqjt","product_unit":2,"is_renew":false,"inbound_number":"1","inbound_amount":"6700","inventory_number":"0","inventory_amount":"0","outbound_number":"1","outbound_amount":"6700","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":261,"key":261,"name":"Adobe"},"productSerie":{},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":2096,"name":"HAT5300-12T","product_type":3,"product_component":15,"product_brand":27,"product_serie":1692,"product_misc":"","product_qa":"","pn":"","description":"12TB 3.5\" SATA HDD","created_by":1013,"created_at":"2025-08-14 09:07:32","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"HAT530012T","product_unit":3,"is_renew":false,"inbound_number":"20","inbound_amount":"59800","inventory_number":"20","inventory_amount":"59800","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":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1692,"key":1692,"name":"12TB 3.5\" SATA \u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":2098,"name":"M2D20","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":"","product_qa":"","pn":"","description":"M.2 SSD \u9002\u914d\u5668","created_by":1013,"created_at":"2025-08-14 09:09:02","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"M2D20","product_unit":3,"is_renew":false,"inbound_number":"2","inbound_amount":"2556","inventory_number":"2","inventory_amount":"2556","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":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":2097,"name":"SNV3510-800G","product_type":3,"product_component":15,"product_brand":27,"product_serie":1693,"product_misc":"","product_qa":"","pn":"","description":"800G M.2 NVMe SSD","created_by":1013,"created_at":"2025-08-14 09:08:19","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"SNV3510800G","product_unit":3,"is_renew":false,"inbound_number":"4","inbound_amount":"8520","inventory_number":"4","inventory_amount":"8520","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":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1693,"key":1693,"name":"800G SSD\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":2125,"name":"\u6df1\u4fe1\u670d\u7ef4\u4fdd\u670d\u52a1\uff08\u6807\u51c6\u7248\uff09","product_type":22,"product_component":200,"product_brand":12,"product_serie":1700,"product_misc":"","product_qa":"","pn":"","description":"1\u3001\u6df1\u4fe1\u670d\u5c06\u63d0\u4f9b\u786c\u4ef6\u8bbe\u5907\u6545\u969c\u8fd4\u5382\u7ef4\u4fee\u670d\u52a1\uff0c\u7ef4\u4fee\u5c06\u5728 30 \u4e2a\u81ea\u7136\u65e5\u5185\u5b8c\u6210\u5e76\u5bc4\u56de\u8bbe\u5907\n2\u3001\u63d0\u4f9b\u8d2d\u4e70\u8bbe\u5907\u7684\u8f6f\u4ef6\u5347\u7ea7\u6388\u6743\uff0c\u8f6f\u4ef6\u5b9a\u671f\u66f4\u65b0\uff0c\u6301\u7eed\u83b7\u5f97\u6700\u65b0\u7684\u529f\u80fd\u7279\u6027\u548c\u9632\u62a4\u80fd\u529b","created_by":1013,"created_at":"2025-08-29 10:10:57","updated_at":"2025-08-29 10:10:57","pinyin_shortcut":"sxfwbfwbzb","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":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1700,"key":1700,"name":"\u6df1\u4fe1\u670d\u7ef4\u4fdd\u670d\u52a1\uff08\u6807\u51c6\u7248\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":2124,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e9040\/60W","product_type":5,"product_component":157,"product_brand":12,"product_serie":1699,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 10:01:17","updated_at":"2025-08-29 10:01:17","pinyin_shortcut":"dzryjldy4060W","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":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1699,"key":1699,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e9040\/60W"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"id":2123,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":1640,"product_misc":"","product_qa":"","pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u60a8\u5c06\u83b7\u5f97\u4ee5\u4e0b\u80fd\u529b\uff1a\n\u3010\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u89c4\u5219\u5e93\uff0c\u5931\u9677\u5916\u8054\u5b9e\u65f6\u68c0\u6d4b\u4e0e\u62e6\u622a\u3011\u901a\u8fc7\u672c\u5730&\u4e91\u7aef\u767e\u4ebf\u7ea7\u5a01\u80c1\u60c5\u62a5\u548c\u5168\u56fd30+\u8fd0\u8425\u5546POP\u8282\u70b9 \uff0c\u5b9e\u65f6\u963b\u65ad\u4e3b\u673a\/PC\u5931\u9677\u5916\u8054\u3001\u6316\u77ff\u3001URL\u9493\u9c7c\u7b49\u98ce\u9669\uff1b\n\u3010\u65b0\u5a01\u80c1\/\u672a\u77e5\u5a01\u80c15min\u5185\u540c\u6b65\u3011\u83b7\u53d6\u4e91\u7aefAI\u667a\u80fd\u5f15\u64ce\u68c0\u6d4b\u80fd\u529b\uff0c\u672c\u5730\u9632\u706b\u5899\u89c4\u5219\u5e93\u6bcf5\u5206\u949f\u66f4\u65b0\u4e00\u6b21\uff0c\u540c\u6b65\u6700\u65b0\u7684\u672a\u77e5\u5a01\u80c1\u60c5\u62a5\u81f3\u5ba2\u6237\u672c\u5730\uff0c\u5b9e\u65f6\u83b7\u53d6\u672a\u77e5\u5a01\u80c1\u7684\u9632\u5fa1\u80fd\u529b\uff08\u5982\u6f0f\u6d1e\\\u6076\u610fIP\\\u9493\u9c7cURL\u7b49\uff09\u907f\u514d\u6210\u4e3a\u65b0\u578b\u5a01\u80c1\u7684\u9996\u6279\u53d7\u5bb3\u8005\uff1b\n\u3010\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u3011\u63d0\u4f9b\u672c\u5730\u8bbe\u5907\u7f51\u7edc\u6740\u6bd2\u529f\u80fd\u4e0e\u66f4\u65b0\u670d\u52a1\uff0c\u672a\u77e5\u6587\u4ef6MD5\u503c\u5b9e\u65f6\u4e91\u67e5\u529f\u80fd\u3002","created_by":1013,"created_at":"2025-08-29 09:58:18","updated_at":"2025-08-29 09:58:18","pinyin_shortcut":"sxfywxqbwgrjV80syyAF1000FH2150B","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":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1640,"key":1640,"name":"\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":2122,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":742,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 09:56:09","updated_at":"2025-08-29 09:56:09","pinyin_shortcut":"sxffhqrjV80syyAF1000FH2150B","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":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":742,"key":742,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":2121,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH2150B\uff09","product_type":7,"product_component":188,"product_brand":12,"product_serie":743,"product_misc":"","product_qa":"","pn":"","description":"\u6309\u5e74\u6536\u8d39\uff0c\u5305\u62ecWEB\u5e94\u7528\u9632\u62a4\u8bc6\u522b\u5e93\u3001IPS\u7279\u5f81\u5e93\u3001\u50f5\u5c38\u7f51\u7edc\u9632\u62a4\u5e93\u3001\u5b9e\u65f6\u6f0f\u6d1e\u5206\u6790\u8bc6\u522b\u5e93\u548cURL&\u5e94\u7528\u8bc6\u522b\u5e93\u5b9a\u671f\u66f4\u65b0\uff0c\u4fdd\u6301\u8bbe\u5907\u5177\u5907\u68c0\u6d4b\u9632\u5fa1\u6700\u65b0\u5a01\u80c1\u7684\u80fd\u529b\u3002","created_by":1013,"created_at":"2025-08-29 09:55:04","updated_at":"2025-08-29 09:55:04","pinyin_shortcut":"sxfaqynyzdyrjV80syyAF1000FH2150B","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":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":743,"key":743,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},{"id":2119,"name":"AF-1000-FH2150B","product_type":5,"product_component":26,"product_brand":12,"product_serie":1033,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff1a20G\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a10G\uff0c\u9632\u75c5\u6bd2\u541e\u5410\u91cf\uff1a1.5G\uff0cIPS\u541e\u5410\u91cf\uff1a1.5G\uff0c\u5168\u5a01\u80c1\u541e\u5410\u91cf\uff08\u4e0d\u542bWAF\uff09\uff1a1G\uff0c\u5e76\u53d1\u8fde\u63a5\u6570\uff1a300\u4e07\uff0cHTTP\u65b0\u5efa\u8fde\u63a5\u6570\uff1a9\u4e07\uff0cSSL VPN\u63a8\u8350\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a30\uff0cSSL VPN\u6700\u5927\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a80\uff0cSSL VPN\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a250M\uff0cIPSec VPN \u6700\u5927\u63a5\u5165\u6570\uff1a1000\uff0cIPSec VPN\u541e\u5410\u91cf\uff1a700M\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a8\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u4e0b\u4e00\u4ee3\u9632\u706b\u5899\u4ee5\u4fdd\u969c\u7528\u6237\u6838\u5fc3\u8d44\u4ea7\u4e3a\u76ee\u6807\uff0c\u63d0\u4f9bL2-L7\u5c42\u5404\u7c7b\u5a01\u80c1\u7684\u68c0\u6d4b\u548c\u9632\u62a4\uff0c\u662f\u4e00\u6b3e\u80fd\u591f\u6709\u6548\u5e94\u5bf9\u4f20\u7edf\u7f51\u7edc\u653b\u51fb\u548c\u672a\u77e5\u5a01\u80c1\u653b\u51fb\u7684\u7f51\u7edc\u5b89\u5168\u4ea7\u54c1\u3002","created_by":1013,"created_at":"2025-08-29 09:49:49","updated_at":"2025-08-29 09:49:49","pinyin_shortcut":"AF1000FH2150B","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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1033,"key":1033,"name":"\u6df1\u4fe1\u670d AF-1000\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":2118,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e90150W","product_type":4,"product_component":43,"product_brand":12,"product_serie":1698,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-29 09:46:49","updated_at":"2025-08-29 09:46:49","pinyin_shortcut":"dzryjldy150W","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":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1698,"key":1698,"name":"\u5b9a\u5236\u5197\u4f59\u4ea4\u6d41\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},{"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":"2025-08-28 10:02:49","pinyin_shortcut":"lsyjxdlbptj","product_unit":11,"is_renew":false,"inbound_number":"48","inbound_amount":"7200","inventory_number":"42","inventory_amount":"6300","outbound_number":"6","outbound_amount":"900","inventory_start_number":"48","inventory_start_amount":"7200","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":256,"key":256,"name":"\u4e50\u4e8b\u5370\u52a0"},"productSerie":{"id":1676,"key":1676,"name":"\u7ea2\u9152"},"productUnit":{"id":11,"key":11,"name":"\u74f6"}},{"id":2116,"name":"EWP-WA6522H-LI-FIT","product_type":4,"product_component":21,"product_brand":20,"product_serie":531,"product_misc":"","product_qa":"","pn":"","description":"\u5343\u5146\u53cc\u9891 WIFI6\u9762\u677f \u65e0\u7ebfAP","created_by":1013,"created_at":"2025-08-26 13:51:29","updated_at":"2025-08-27 15:51:12","pinyin_shortcut":"EWPWA6522HLIFIT","product_unit":1,"is_renew":false,"inbound_number":"2","inbound_amount":"780","inventory_number":"0","inventory_amount":"0","outbound_number":"2","outbound_amount":"780","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":21,"key":21,"name":"\u65e0\u7ebfAP"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":531,"key":531,"name":"WA6522H-HI Wi-Fi 6\u65e0\u7ebf\u63a5\u5165\u8bbe\u5907"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},{"id":936,"name":"X377A","product_type":3,"product_component":15,"product_brand":6,"product_serie":75,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-07-28 09:46:45","updated_at":"2025-08-27 13:27:43","pinyin_shortcut":"X377A","product_unit":4,"is_renew":false,"inbound_number":"1","inbound_amount":"2900","inventory_number":"0","inventory_amount":"0","outbound_number":"1","outbound_amount":"2900","inventory_start_number":"","inventory_start_amount":"","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":75,"key":75,"name":"10T 10K 3.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},{"id":1943,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 5M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:21","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"cllwx5M","product_unit":6,"is_renew":false,"inbound_number":"22","inbound_amount":"330","inventory_number":"0","inventory_amount":"0","outbound_number":"22","outbound_amount":"330","inventory_start_number":"12","inventory_start_amount":"180","inventory_lost_number":"","inventory_lost_amount":"","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}}],"pagenation":{"totalcount":1940,"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-09-15 14:48:04') RETURNING "id"
14:48:04.059traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:48:04.059traceyii\redis\Connection::executeCommandExecuting Redis Command: SET