ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c3d2af852b4: POST https://beta.jinchangxiao.com/vue/product/list at 2025-09-12 03:58:39 pm by 114.246.237.213

Performance Profiling

Total processing time: 31 ms; Peak memory: 5.067 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
15:58:39.5673.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=25) AND ("visit_date"='2025-09-12')
15:58:39.5492.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:58:39.5552.2 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id ORDER BY "updated_at" DESC) "c"
15:58:39.5471.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:58:39.5721.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/product/list', '{"page":"1","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"list":[{"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,"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"},"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":1040,"outbound":"8","number":"12","inventory":"4","avg_amount":"18.0000000000000000","avg_total_amount":"36.0000000000000000","amount":"72"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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":"13","number":"14","inventory":"1","avg_amount":"1393.0000000000000000","avg_total_amount":"1393.0000000000000000","amount":"1393"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":2095,"outbound":"4","number":"104","inventory":"100","avg_amount":"849.0000000000000000","avg_total_amount":"28300.000000000000","amount":"84900"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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":{},"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":2100,"outbound":"1","number":"1","inventory":"0","avg_amount":"6700.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":2097,"outbound":"0","number":"4","inventory":"4","avg_amount":"2130.0000000000000000","avg_total_amount":"8520.0000000000000000","amount":"8520"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":2098,"outbound":"0","number":"2","inventory":"2","avg_amount":"1278.0000000000000000","avg_total_amount":"2556.0000000000000000","amount":"2556"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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-08-29 11:30:38","pinyin_shortcut":"RKS02","product_unit":2,"is_renew":false,"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"},"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":1812,"outbound":"0","number":"2","inventory":"2","avg_amount":"550.0000000000000000","avg_total_amount":"1100.0000000000000000","amount":"1100"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":2096,"outbound":"0","number":"20","inventory":"20","avg_amount":"2990.0000000000000000","avg_total_amount":"59800.000000000000","amount":"59800"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":"","bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":"","bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":"","bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":"","bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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":"","bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":"","bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":"","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-08-28 10:02:49","pinyin_shortcut":"lsyjxdlbptj","product_unit":11,"is_renew":false,"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":"6","number":"48","inventory":"42","avg_amount":"150.0000000000000000","avg_total_amount":"6300.0000000000000000","amount":"6300"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":2116,"outbound":"2","number":"2","inventory":"0","avg_amount":"390.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"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-08-27 13:27:43","pinyin_shortcut":"X377A","product_unit":4,"is_renew":false,"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":"1","number":"1","inventory":"0","avg_amount":"2900.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"id":2117,"name":"16A \u4e09\u63d2\u5934\u8f6cC19 1.5\u7c73\u7535\u6e90\u7ebf","product_type":18,"product_component":201,"product_brand":249,"product_serie":1641,"product_misc":"","product_qa":"","pn":"","description":"\u5e7f\u660c\u5174\uff08G.C.X\uff09PDU\u8fde\u63a5\u670d\u52a1\u5668\u7535\u6e90\u7ebf16a\u4e09\u63d2\u5934\u8f6cc19\u5b54 3*2.5\u5e73\u65b9 1.5\u7c73 \u5927\u529f\u7387\u4e3b\u673a\u901a\u7528 \u65e0\u6c27\u94dc\u56fd\u68073C\u8ba4\u8bc1","created_by":1013,"created_at":"2025-08-26 17:53:52","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"16AsctzC1915mdyx","product_unit":6,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":201,"key":201,"name":"\u673a\u623f\u7406\u7ebf\u6750\u6599\u5de5\u5177"},"productBrand":{"id":249,"key":249,"name":"\u5e7f\u660c\u5174"},"productSerie":{"id":1641,"key":1641,"name":"\u7535\u6e90\u7ebf"},"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":2117,"outbound":"6","number":"6","inventory":"0","avg_amount":"38.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true},{"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,"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"},"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":1943,"outbound":"22","number":"22","inventory":"0","avg_amount":"15.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"},"bgcolor":"#89c541","can_update":true,"can_delete":true}],"can_import":true,"can_create":true,"can_update":true,"can_delete":true,"can_manage":true,"pagenation":{"totalcount":1940,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 15:58:39') RETURNING "id"
15:58:39.5521.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:58:39.5580.9 msyii\db\Command::querySELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id ORDER BY "updated_at" DESC LIMIT 20
15:58:39.5710.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=56550
15:58:39.5630.8 msyii\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 (1040, 1624, 2095, 2100, 2097, 2098, 1812, 2096, 2125, 2124, 2123, 2122, 2121, 2119, 2118, 2074, 2116, 936, 2117, 1943) GROUP BY "product_id"
15:58:39.5620.7 msyii\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))
15:58:39.5600.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (633, 1382, 1691, 1693, 1578, 1523, 1692, 1700, 1699, 1640, 742, 743, 1033, 1698, 1676, 531, 75, 1641, 813)
15:58:39.5630.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 7)
15:58:39.5590.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 5, 3, 22, 4, 23, 18)
15:58:39.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001)
15:58:39.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 3, 11, 4, 6)
15:58:39.5600.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (137, 8, 27, 261, 12, 256, 20, 6, 249, 191)
15:58:39.5600.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (32, 36, 14, 159, 15, 39, 200, 157, 188, 26, 43, 194, 21, 201)