ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6944c821020d4: POST https://beta.jinchangxiao.com/vue/project/product-list at 2025-12-19 11:36:01 am by 223.72.15.22

Log Messages

总计44条数据
TimeLevelCategoryMessage
 
11:36:01.008traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
11:36:01.008traceyii\base\Module::getModuleLoading module: debug
11:36:01.008traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
11:36:01.008traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
11:36:01.008traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
11:36:01.009traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.009traceyii\base\Module::getModuleLoading module: gii
11:36:01.009traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
11:36:01.009traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
11:36:01.009traceyii\web\Application::handleRequestRoute requested: 'vue/project/product-list'
11:36:01.009traceyii\base\Module::getModuleLoading module: vue
11:36:01.013infoyii\web\Session::openSession started
11:36:01.014infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:36:01.014infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:36:01.021traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.022traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:36:01.022infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:36:01.023traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.023traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:36:01.024infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:36:01.027traceyii\base\Controller::runActionRoute to run: vue/project/product-list
11:36:01.027traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.031traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
11:36:01.031traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionProductList()
11:36:01.031traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.031traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:36:01.033infoyii\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"
11:36:01.036infoyii\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
11:36:01.038infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 22, 4, 3, 23, 7, 19)
11:36:01.039infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (36, 205, 43, 157, 35, 26, 15, 194, 195, 188, 191, 160, 153, 189, 151)
11:36:01.039infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 219, 150, 12, 6, 256, 255, 127, 137, 134)
11:36:01.040infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1382, 1500, 716, 1012, 103, 999, 801, 784, 75, 1676, 1675, 743, 741, 1723, 598, 1702, 593)
11:36:01.041infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 6, 3, 1, 8, 4, 11, 9, 7)
11:36:01.041infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001)
11:36:01.042infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1013))
11:36:01.043infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 7)
11:36:01.044infoyii\db\Command::querySELECT "product_id", sum(outbound) as outbound, sum(number) as number, 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" WHERE "product_id" IN (1624, 1774, 2166, 1340, 1191, 1471, 849, 1107, 936, 2074, 2073, 2008, 1190, 2162, 2165, 2161, 2164, 952, 2127, 942) GROUP BY "product_id"
11:36:01.046traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.047traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.049traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.050traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
11:36:01.050infoyii\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/project/product-list', '{"page":"1","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"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-12-18 15:18:39","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"in_out_at":"2025-12-18 15:18:39.404857+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":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\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":"","erpInventoryCount":{"product_id":1624,"outbound":"101","number":"235","inventory":"134","avg_amount":"1253.9000000000000000","avg_total_amount":"33902.000000000000","amount":"135608.0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","product_type":22,"product_component":205,"product_brand":219,"product_serie":1500,"product_misc":"","product_qa":"","pn":"","description":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248\uff0cFastone Compute Cloud-Enterprise Edition (\u4ee5\u4e0b\u7b80\u79f0FCC-E)\u4e91\u670d\u52a1","created_by":1013,"created_at":"2024-09-02 15:13:25","updated_at":"2025-12-18 15:11:03","pinyin_shortcut":"ssjsyfwqyb","product_unit":2,"is_renew":false,"in_out_at":"2025-12-18 15:11:03.126354+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":205,"key":205,"name":"\u5b89\u88c5\u670d\u52a1"},"productBrand":{"id":219,"key":219,"name":"\u901f\u77f3"},"productSerie":{"id":1500,"key":1500,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"},"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":"","erpInventoryCount":{"product_id":1774,"outbound":"105","number":"152","inventory":"47","avg_amount":"31243.648000000000","avg_total_amount":"7826.8000000000000000","amount":"39134.00"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2166,"name":"Q28-100G-A5H","product_type":4,"product_component":43,"product_brand":150,"product_serie":716,"product_misc":"","product_qa":"","pn":"","description":"Q28 100G AOC 5M","created_by":1013,"created_at":"2025-11-11 15:22:56","updated_at":"2025-12-18 15:08:05","pinyin_shortcut":"Q28100GA5H","product_unit":6,"is_renew":false,"in_out_at":"2025-12-18 15:08:05.883041+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":150,"key":150,"name":"\u7eb3\u591a\u5fb7"},"productSerie":{"id":716,"key":716,"name":"\u7ebf\u7f06"},"productMisc":{},"productUnit":{"id":6,"key":6,"name":"\u6761"},"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":"","erpInventoryCount":{"product_id":2166,"outbound":"1","number":"4","inventory":"3","avg_amount":"135.2000000000000000","avg_total_amount":"208.8000000000000000","amount":"1044"},"bgcolor":"#89c541","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":"2025-12-04 09:28:07","pinyin_shortcut":"PANPWR50WAC","product_unit":3,"is_renew":false,"in_out_at":"2025-12-04 09:28:07.966181+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":"","erpInventoryCount":{"product_id":1340,"outbound":"1","number":"2","inventory":"1","avg_amount":"12191.7500000000000000","avg_total_amount":"10858.5000000000000000","amount":"43434"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":1191,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-FH1600B\uff09","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":"","product_qa":"","pn":"","description":"\u4ea7\u54c1\u51fa\u5382\u9ed8\u8ba4\u81ea\u5e26\u529f\u80fd\uff0c\u5305\u62ecACL\u63a7\u5236\u3001\u5e94\u7528\u8bc6\u522b\u4e0e\u6d41\u63a7\u3001\u5165\u4fb5\u9632\u5fa1\u3001\u50f5\u5c38\u7f51\u7edc\u68c0\u6d4b\u7b49\u529f\u80fd","created_by":1013,"created_at":"2024-01-09 14:59:50","updated_at":"2025-12-01 13:19:04","pinyin_shortcut":"sxffhqrjV80syyAF1000FH1600B","product_unit":2,"is_renew":false,"in_out_at":"2025-12-01 13:19:04.281517+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\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":"","erpInventoryCount":{"product_id":1191,"outbound":"2","number":"2","inventory":"0","avg_amount":"3265.4600000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":1471,"name":"PAN-PA-440-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":999,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Core Security Subscription Bundle\n(Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN), 3 years (36 months)term","created_by":1013,"created_at":"2024-03-01 17:41:36","updated_at":"2025-11-28 11:27:23","pinyin_shortcut":"PANPA440BNDCORESEC3YR","product_unit":2,"is_renew":false,"in_out_at":"2025-11-28 11:27:23.453624+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":999,"key":999,"name":"PA440\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":"","erpInventoryCount":{"product_id":1471,"outbound":"0","number":"1","inventory":"1","avg_amount":"10329.0000000000000000","avg_total_amount":"5164.5000000000000000","amount":"10329"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":849,"name":"PAN-PA-440","product_type":5,"product_component":26,"product_brand":8,"product_serie":801,"product_misc":"","product_qa":"","pn":"","description":"Palo Alto Networks PA-440","created_by":1013,"created_at":"2022-07-25 15:54:45","updated_at":"2025-11-28 11:27:23","pinyin_shortcut":"PANPA440","product_unit":1,"is_renew":false,"in_out_at":"2025-11-28 11:27:23.453624+08","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":801,"key":801,"name":"PA-440\u9632\u706b\u5899\u4e3b\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":"","erpInventoryCount":{"product_id":849,"outbound":"0","number":"1","inventory":"1","avg_amount":"5932.0000000000000000","avg_total_amount":"2966.0000000000000000","amount":"5932"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":1107,"name":"PAN-SVC-BKLN-440-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":784,"product_misc":"","product_qa":"","pn":"","description":"PA-440, Premium support, 3 years (36 months), term.","created_by":1013,"created_at":"2023-11-29 13:34:57","updated_at":"2025-11-28 11:27:23","pinyin_shortcut":"PANSVCBKLN4403YR","product_unit":8,"is_renew":false,"in_out_at":"2025-11-28 11:27:23.453624+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":784,"key":784,"name":"PA440\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":"","erpInventoryCount":{"product_id":1107,"outbound":"0","number":"1","inventory":"1","avg_amount":"4219.0000000000000000","avg_total_amount":"2109.5000000000000000","amount":"4219"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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-11-12 14:47:33","pinyin_shortcut":"X377A","product_unit":4,"is_renew":false,"in_out_at":"2025-11-12 14:47:33.469689+08","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"},"productMisc":{},"productUnit":{"id":4,"key":4,"name":"\u5757"},"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":"","erpInventoryCount":{"product_id":936,"outbound":"7","number":"7","inventory":"0","avg_amount":"2900.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","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":"2025-11-11 13:14:29","pinyin_shortcut":"lsyjxdlbptj","product_unit":11,"is_renew":false,"in_out_at":"2025-11-11 13:14:29.341213+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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"productQa":"","erpInventoryCount":{"product_id":2074,"outbound":"21","number":"48","inventory":"27","avg_amount":"150.0000000000000000","avg_total_amount":"4050.0000000000000000","amount":"4050"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2073,"name":"\u4e09\u987f\u534a\u51bb\u5e72\u901f\u6eb6\u5496\u5561\u7eaf\u9ed1\u5496\u5561\u7c89\u6df7\u5408\u88c5 21\u9897*2g","product_type":23,"product_component":195,"product_brand":255,"product_serie":1675,"product_misc":"","product_qa":"","pn":"","description":"\u4e09\u987f\u534a\u51bb\u5e72\u901f\u6eb6\u5496\u5561\u7eaf\u9ed1\u5496\u5561\u7c89\u6df7\u5408\u88c5 21\u9897*2g","created_by":1001,"created_at":"2025-08-08 16:42:19","updated_at":"2025-11-11 10:28:19","pinyin_shortcut":"sdbdgsrkfchkffhhz21k2g","product_unit":9,"is_renew":false,"in_out_at":"2025-11-11 10:28:19.934294+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":255,"key":255,"name":"\u4e09\u987f\u534a"},"productSerie":{"id":1675,"key":1675,"name":"\u5496\u5561"},"productMisc":{},"productUnit":{"id":9,"key":9,"name":"\u76d2"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"productQa":"","erpInventoryCount":{"product_id":2073,"outbound":"14","number":"66","inventory":"52","avg_amount":"63.9800000000000000","avg_total_amount":"3326.9600000000000000","amount":"3326.96"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2008,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08AF-1000-FH1600B\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-06-16 11:40:41","updated_at":"2025-11-11 09:19:56","pinyin_shortcut":"sxfaqynyzdyrjV80AF1000FH1600B","product_unit":2,"is_renew":false,"in_out_at":"2025-11-11 09:19:56.035739+08","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"},"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":"","erpInventoryCount":{"product_id":2008,"outbound":"2","number":"2","inventory":"0","avg_amount":"809.0800000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":1190,"name":"AF-1000-FH1600B","product_type":5,"product_component":191,"product_brand":12,"product_serie":741,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff1a4G\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a2G\uff0c\u9632\u75c5\u6bd2\u541e\u5410\u91cf\uff1a600M\uff0cIPS\u541e\u5410\u91cf\uff1a600M\uff0c\u5168\u5a01\u80c1\u541e\u5410\u91cf\uff1a450M\uff0c\u5e76\u53d1\u8fde\u63a5\u6570\uff1a200\u4e07\uff0cHTTP\u65b0\u5efa\u8fde\u63a5\u6570\uff1a6\u4e07\uff0cSSL VPN\u63a8\u8350\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a20\uff0cSSL VPN\u6700\u5927\u7528\u6237\u6570\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a60\uff0cSSL VPN\u6700\u5927\u7406\u8bba\u52a0\u5bc6\u6d41\u91cf\uff08\u5355\u72ec\u8d2d\u4e70\uff09\uff1a160M\uff0cIPSec VPN \u6700\u5927\u63a5\u5165\u6570\uff1a300\uff0cIPSec VPN\u541e\u5410\u91cf\uff1a270M\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a4G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a8\u5343\u5146\u7535\u53e3+2\u5343\u5146\u5149\u53e3SFP\u3002","created_by":1013,"created_at":"2024-01-09 14:58:07","updated_at":"2025-11-11 09:19:56","pinyin_shortcut":"AF1000FH1600B","product_unit":1,"is_renew":false,"in_out_at":"2025-11-11 09:19:56.035739+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":191,"key":191,"name":"\u6df1\u4fe1\u670dAF-1000\u9632\u706b\u5899"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":741,"key":741,"name":"\u6df1\u4fe1\u670dAF-1000-FH1600B\u6807\u51c6\u4ea7\u54c1"},"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":"","erpInventoryCount":{"product_id":1190,"outbound":"2","number":"2","inventory":"0","avg_amount":"2004.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2162,"name":"\u5353\u8c6a\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf 7\u4e2a\u5e94\u7528\u7ba1\u7406\u6765\u6e90\u7684\u5e74\u79df\u8d39","product_type":7,"product_component":160,"product_brand":127,"product_serie":1723,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-10-30 10:46:56","updated_at":"2025-11-11 09:19:48","pinyin_shortcut":"zhrzfxxt7gyygllydnzf","product_unit":8,"is_renew":true,"in_out_at":"2025-11-11 09:19:48.520586+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":160,"key":160,"name":"\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf"},"productBrand":{"id":127,"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09"},"productSerie":{"id":1723,"key":1723,"name":"Eventlog Analyzer V12"},"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":"","erpInventoryCount":{"product_id":2162,"outbound":"1","number":"1","inventory":"0","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2165,"name":"\u5353\u8c6a\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf 2\u4e2aMS SQL\u670d\u52a1\u5668\u5e74\u79df\u8d39","product_type":7,"product_component":160,"product_brand":127,"product_serie":1723,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-10-30 10:48:50","updated_at":"2025-11-11 09:19:48","pinyin_shortcut":"zhrzfxxt2gMSSQLfwqnzf","product_unit":8,"is_renew":true,"in_out_at":"2025-11-11 09:19:48.520586+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":160,"key":160,"name":"\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf"},"productBrand":{"id":127,"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09"},"productSerie":{"id":1723,"key":1723,"name":"Eventlog Analyzer V12"},"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":"","erpInventoryCount":{"product_id":2165,"outbound":"1","number":"1","inventory":"0","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2161,"name":"\u5353\u8c6a\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf 12\u4e2a\u8bbe\u5907\u7684\u5e74\u79df\u8d39","product_type":7,"product_component":160,"product_brand":127,"product_serie":1723,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-10-30 10:46:18","updated_at":"2025-11-11 09:19:48","pinyin_shortcut":"zhrzfxxt12gsbdnzf","product_unit":8,"is_renew":true,"in_out_at":"2025-11-11 09:19:48.520586+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":160,"key":160,"name":"\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf"},"productBrand":{"id":127,"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09"},"productSerie":{"id":1723,"key":1723,"name":"Eventlog Analyzer V12"},"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":"","erpInventoryCount":{"product_id":2161,"outbound":"1","number":"1","inventory":"0","avg_amount":"20000.000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2164,"name":"\u5353\u8c6a\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf 10\u4e2aWindows\u670d\u52a1\u5668\u7684\u5e74\u79df\u8d39","product_type":7,"product_component":160,"product_brand":127,"product_serie":1723,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-10-30 10:48:13","updated_at":"2025-11-11 09:19:48","pinyin_shortcut":"zhrzfxxt10gWindowsfwqdnzf","product_unit":8,"is_renew":true,"in_out_at":"2025-11-11 09:19:48.520586+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":160,"key":160,"name":"\u65e5\u5fd7\u5206\u6790\u7cfb\u7edf"},"productBrand":{"id":127,"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09"},"productSerie":{"id":1723,"key":1723,"name":"Eventlog Analyzer V12"},"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":"","erpInventoryCount":{"product_id":2164,"outbound":"1","number":"1","inventory":"0","avg_amount":"0.00000000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":952,"name":"\u52a8\u6001\u4ee4\u724c","product_type":7,"product_component":153,"product_brand":137,"product_serie":598,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:34:36","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"dtlp","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":598,"key":598,"name":"\u52a8\u6001\u4ee4\u724c"},"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":"","erpInventoryCount":{"product_id":952,"outbound":"5000","number":"5000","inventory":"0","avg_amount":"40.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2127,"name":"\u5b81\u76fe\u6280\u672f\u652f\u6301\u670d\u52a1","product_type":22,"product_component":189,"product_brand":137,"product_serie":1702,"product_misc":"","product_qa":"","pn":"","description":"\u514d\u8d39\u63d0\u4f9b\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u53ca\u63d0\u4f9b\u65e5\u5e38\u5de1\u68c0\u30015*8\u7684\u6280\u672f\u4fdd\u969c\uff0c\u5e38\u89c4\u4e8b\u4ef6\u54cd\u5e94\u65f6\u95f4\uff081\u5c0f\u65f6\u7684\u7535\u8bdd\u54cd\u5e94\uff0c2\u5c0f\u65f6\u5185\u627e\u51fa\u89e3\u51b3\u65b9\u6848\uff09\u3001\u7d27\u6025\u6545\u969c\u5e743\u6b21\u73b0\u573a\u670d\u52a1\u3002","created_by":1013,"created_at":"2025-09-03 11:04:41","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"ndjszcfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1702,"key":1702,"name":"\u539f\u5382\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\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":"","erpInventoryCount":{"product_id":2127,"outbound":"1","number":"1","inventory":"0","avg_amount":"24000.000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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":"2025-11-10 11:30:48","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","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"},"productMisc":{},"productUnit":{"id":7,"key":7,"name":"\u6b21"},"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":"","erpInventoryCount":{"product_id":942,"outbound":"9","number":"9","inventory":"0","avg_amount":"2685.7142857142857143","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","can_update":true,"can_delete":true}],"can_create":true,"can_update":true,"can_delete":true,"can_manage":true,"pagenation":{"totalcount":1977,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-19 11:36:01') RETURNING "id"
11:36:01.053traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11:36:01.054traceyii\redis\Connection::executeCommandExecuting Redis Command: SET