ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2b6bb8ee431: POST https://beta.jinchangxiao.com/vue/erp-analysis/sales-product-histogram at 2026-06-12 10:15:20 am by 221.216.117.119

Database Queries

总计5条数据
TimeDurationTypeQuery
  
10:15:21.0706.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:15:21.0830.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
10:15:21.09010.5 msSELECTSELECT p.id, p.name, p.product_unit, sum(sub.amount) as budget, sum(sub.amount - sub.cost) as profits, sum(sub.number) as number, CASE WHEN sum(sub.amount) != 0 THEN (sum(sub.amount) - sum(sub.cost)) / sum(sub.amount) * 100 ELSE 0 END as profit_pct FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN (SELECT esosps.product_id, sum(eipss.total_amount) as amount, sum(eipss.actual_total_amount) as cost, COALESCE(sum(esosps.number)) as number FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("t"."status"=2) AND ("project"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("project"."bargain_date" >= '2026-01-01 00:00:00') AND ("project"."bargain_date" <= '2026-12-31 23:59:59') AND (((project.budget > project.collected) AND ("project"."project_status" IN ('3', '-1'))) OR ((project.budget <= project.collected) AND ("project"."project_status"=3))) GROUP BY "esosps"."product_id") "sub" ON sub.product_id = p.id GROUP BY "p"."id" HAVING sum(sub.amount) != 0

[+] Explain
10:15:21.1010.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (6, 2, 3, 1, 8, 4, 7)

[+] Explain
10:15:21.1042.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/sales-product-histogram', '{"produect":"product_name","series":"seriesBudget","project_status":["3","-1"],"period":"currentfascalyear","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"category":{"budgetCategory":["MK-MC300","WS-S1-MD","ZB-W8G40PXL","WS-S1-SNGIO","PAN-PA-3440-ATP-3YR","XMS1000","PAN-PA-3440","PAN-PA-1410-BND-CORESEC-3YR","PAN-SVC-BKLN-3440-3YR","WS-S1-AIS","PAN-PA-1420","PAN-PA-460-BND-CORESEC-3YR","PAN-PA-1410","PAN-SVC-BKLN-1410-3YR","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","PAN-PA-460","V-FDNVUL-0I-SU1AR-00","PAN-SVC-BKLN-460-3YR","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","PAN-PWR-450W-AC","V-FDNVUL-0I-SU1YP-00","X343A-R6","Q100","\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","Thinkplus MK-MC500+","SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09","PAN-PA-400-RACKTRAY","\u672c\u5730\u7f51\u5173\u6740\u6bd2\u7eed\u8d39\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","DRZ32-W3 V1.0","PAN-PWR-50W-AC","X423A-R5","SAS Cable,12Gb,Mini SAS HD,2m,-C","LIS-F1000-AK-URL-1Y","PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09","LIS-F1000-AK-IPS-1Y","LIS-F1000-AK-AV-1Y","AJ737A\uff08480939-001\uff09","\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09","HID-600RO RO\u53cd\u6e17\u900f\u819c","\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09","\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09"],"profitsCategory":["MK-MC300","PAN-PA-3440-ATP-3YR","PAN-PA-3440","\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","PAN-SVC-BKLN-3440-3YR","PAN-PA-1410-BND-CORESEC-3YR","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","WS-S1-MD","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","XMS1000","PAN-PA-460-BND-CORESEC-3YR","ZB-W8G40PXL","V-FDNVUL-0I-SU1AR-00","PAN-PA-1410","PAN-SVC-BKLN-1410-3YR","PAN-PA-460","WS-S1-SNGIO","PAN-SVC-BKLN-460-3YR","PAN-PA-1420","\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","PAN-PWR-450W-AC","DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","WS-S1-AIS","X343A-R6","Q100","V-FDNVUL-0I-SU1YP-00","PAN-PA-400-RACKTRAY","\u672c\u5730\u7f51\u5173\u6740\u6bd2\u7eed\u8d39\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","X423A-R5","\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09","PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","PAN-PWR-50W-AC","LIS-F1000-AK-URL-1Y","SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09","LIS-F1000-AK-IPS-1Y","DRZ32-W3 V1.0","LIS-F1000-AK-AV-1Y","\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09","AJ737A\uff08480939-001\uff09","SAS Cable,12Gb,Mini SAS HD,2m,-C","HID-600RO RO\u53cd\u6e17\u900f\u819c","\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09","\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09","Thinkplus MK-MC500+"],"profitsPctCategory":["\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","MK-MC300","\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09","\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","X423A-R5","PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","\u672c\u5730\u7f51\u5173\u6740\u6bd2\u7eed\u8d39\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","V-FDNVUL-0I-SU1AR-00","\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09","PAN-PA-400-RACKTRAY","\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","LIS-F1000-AK-URL-1Y","LIS-F1000-AK-IPS-1Y","PAN-PA-3440-ATP-3YR","PAN-SVC-BKLN-3440-3YR","PAN-PA-3440","HID-600RO RO\u53cd\u6e17\u900f\u819c","PAN-PA-460","PAN-SVC-BKLN-460-3YR","PAN-PA-460-BND-CORESEC-3YR","PAN-PWR-50W-AC","PAN-SVC-BKLN-1410-3YR","PAN-PWR-450W-AC","PAN-PA-1410-BND-CORESEC-3YR","PAN-PA-1410","AJ737A\uff08480939-001\uff09","LIS-F1000-AK-AV-1Y","Q100","X343A-R6","\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09","DRZ32-W3 V1.0","XMS1000","SAS Cable,12Gb,Mini SAS HD,2m,-C","PAN-PA-1420","V-FDNVUL-0I-SU1YP-00","ZB-W8G40PXL","WS-S1-MD","WS-S1-AIS","WS-S1-SNGIO","Thinkplus MK-MC500+","\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09","\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09"]},"seriesBudget":[{"key":2261,"name":"MK-MC300","number":"5\u4e2a","y":"1270.31"},{"key":2238,"name":"WS-S1-MD","number":"2\u5957","y":"175.96"},{"key":2237,"name":"ZB-W8G40PXL","number":"2\u53f0","y":"122.01"},{"key":2240,"name":"WS-S1-SNGIO","number":"2\u5957","y":"67.80"},{"key":2231,"name":"PAN-PA-3440-ATP-3YR","number":"1\u5957","y":"39.95"},{"key":2241,"name":"XMS1000","number":"1\u5957","y":"31.20"},{"key":2230,"name":"PAN-PA-3440","number":"1\u53f0","y":"27.56"},{"key":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","number":"2\u5957","y":"26.00"},{"key":2232,"name":"PAN-SVC-BKLN-3440-3YR","number":"1\u5957","y":"21.04"},{"key":2239,"name":"WS-S1-AIS","number":"2\u5957","y":"17.93"},{"key":1558,"name":"PAN-PA-1420","number":"2\u53f0","y":"17.64"},{"key":2233,"name":"PAN-PA-460-BND-CORESEC-3YR","number":"2\u5957","y":"12.54"},{"key":969,"name":"PAN-PA-1410","number":"2\u53f0","y":"10.63"},{"key":994,"name":"PAN-SVC-BKLN-1410-3YR","number":"2\u5957","y":"10.06"},{"key":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","number":"8\u5957","y":"9.03"},{"key":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","number":"4\u6b21","y":"8.33"},{"key":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","number":"1\u5957","y":"6.38"},{"key":851,"name":"PAN-PA-460","number":"2\u53f0","y":"6.31"},{"key":1511,"name":"V-FDNVUL-0I-SU1AR-00","number":"2\u5957","y":"5.82"},{"key":1339,"name":"PAN-SVC-BKLN-460-3YR","number":"2\u5e74","y":"5.45"},{"key":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","number":"2\u5957","y":"4.78"},{"key":2236,"name":"DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","number":"1\u53f0","y":"3.89"},{"key":1007,"name":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","number":"120\u5957","y":"2.86"},{"key":1562,"name":"PAN-PWR-450W-AC","number":"2\u5957","y":"2.82"},{"key":1890,"name":"V-FDNVUL-0I-SU1YP-00","number":"2\u5957","y":"2.79"},{"key":1780,"name":"X343A-R6","number":"6\u4e2a","y":"1.86"},{"key":2243,"name":"Q100","number":"10\u53f0","y":"1.25"},{"key":1928,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"1.05"},{"key":2244,"name":"Thinkplus MK-MC500+","number":"10\u4e2a","y":"0.94"},{"key":1925,"name":"SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09","number":"1\u5957","y":"0.43"},{"key":989,"name":"PAN-PA-400-RACKTRAY","number":"1\u5957","y":"0.36"},{"key":1927,"name":"\u672c\u5730\u7f51\u5173\u6740\u6bd2\u7eed\u8d39\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"0.30"},{"key":1929,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"0.30"},{"key":2253,"name":"DRZ32-W3 V1.0","number":"1\u53f0","y":"0.30"},{"key":1340,"name":"PAN-PWR-50W-AC","number":"2\u4e2a","y":"0.28"},{"key":41,"name":"X423A-R5","number":"2\u5757","y":"0.20"},{"key":2235,"name":"SAS Cable,12Gb,Mini SAS HD,2m,-C","number":"4\u6761","y":"0.16"},{"key":868,"name":"LIS-F1000-AK-URL-1Y","number":"1\u5e74","y":"0.14"},{"key":984,"name":"PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","number":"2\u4e2a","y":"0.14"},{"key":2260,"name":"\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09","number":"1\u5e74","y":"0.14"},{"key":867,"name":"LIS-F1000-AK-IPS-1Y","number":"1\u5e74","y":"0.13"},{"key":870,"name":"LIS-F1000-AK-AV-1Y","number":"1\u5e74","y":"0.12"},{"key":1275,"name":"AJ737A\uff08480939-001\uff09","number":"1\u5757","y":"0.07"},{"key":2258,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09","number":"1\u5e74","y":"0.06"},{"key":2224,"name":"HID-600RO RO\u53cd\u6e17\u900f\u819c","number":"1\u4e2a","y":"0.03"},{"key":2259,"name":"\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09","number":"1\u5e74","y":"0.03"},{"key":2257,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09","number":"1\u5e74","y":"0.01"}],"seriesProfits":[{"key":2261,"name":"MK-MC300","number":"5\u4e2a","y":"1270.23"},{"key":2231,"name":"PAN-PA-3440-ATP-3YR","number":"1\u5957","y":"15.59"},{"key":2230,"name":"PAN-PA-3440","number":"1\u53f0","y":"10.61"},{"key":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","number":"4\u6b21","y":"8.33"},{"key":2232,"name":"PAN-SVC-BKLN-3440-3YR","number":"1\u5957","y":"8.21"},{"key":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","number":"2\u5957","y":"8.19"},{"key":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","number":"8\u5957","y":"5.57"},{"key":2238,"name":"WS-S1-MD","number":"2\u5957","y":"5.28"},{"key":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","number":"2\u5957","y":"4.78"},{"key":2241,"name":"XMS1000","number":"1\u5957","y":"4.77"},{"key":2233,"name":"PAN-PA-460-BND-CORESEC-3YR","number":"2\u5957","y":"4.18"},{"key":2237,"name":"ZB-W8G40PXL","number":"2\u53f0","y":"3.66"},{"key":1511,"name":"V-FDNVUL-0I-SU1AR-00","number":"2\u5957","y":"3.46"},{"key":969,"name":"PAN-PA-1410","number":"2\u53f0","y":"3.30"},{"key":994,"name":"PAN-SVC-BKLN-1410-3YR","number":"2\u5957","y":"3.19"},{"key":851,"name":"PAN-PA-460","number":"2\u53f0","y":"2.10"},{"key":2240,"name":"WS-S1-SNGIO","number":"2\u5957","y":"2.03"},{"key":1339,"name":"PAN-SVC-BKLN-460-3YR","number":"2\u5e74","y":"1.82"},{"key":1558,"name":"PAN-PA-1420","number":"2\u53f0","y":"1.76"},{"key":1007,"name":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","number":"120\u5957","y":"1.42"},{"key":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","number":"1\u5957","y":"1.23"},{"key":1928,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"0.91"},{"key":1562,"name":"PAN-PWR-450W-AC","number":"2\u5957","y":"0.89"},{"key":2236,"name":"DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","number":"1\u53f0","y":"0.69"},{"key":2239,"name":"WS-S1-AIS","number":"2\u5957","y":"0.54"},{"key":1780,"name":"X343A-R6","number":"6\u4e2a","y":"0.36"},{"key":2243,"name":"Q100","number":"10\u53f0","y":"0.32"},{"key":1890,"name":"V-FDNVUL-0I-SU1YP-00","number":"2\u5957","y":"0.27"},{"key":989,"name":"PAN-PA-400-RACKTRAY","number":"1\u5957","y":"0.19"},{"key":1927,"name":"\u672c\u5730\u7f51\u5173\u6740\u6bd2\u7eed\u8d39\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"0.19"},{"key":1929,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"0.19"},{"key":41,"name":"X423A-R5","number":"2\u5757","y":"0.15"},{"key":2260,"name":"\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09","number":"1\u5e74","y":"0.13"},{"key":984,"name":"PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","number":"2\u4e2a","y":"0.10"},{"key":1340,"name":"PAN-PWR-50W-AC","number":"2\u4e2a","y":"0.09"},{"key":868,"name":"LIS-F1000-AK-URL-1Y","number":"1\u5e74","y":"0.07"},{"key":1925,"name":"SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09","number":"1\u5957","y":"0.07"},{"key":867,"name":"LIS-F1000-AK-IPS-1Y","number":"1\u5e74","y":"0.05"},{"key":2253,"name":"DRZ32-W3 V1.0","number":"1\u53f0","y":"0.05"},{"key":870,"name":"LIS-F1000-AK-AV-1Y","number":"1\u5e74","y":"0.03"},{"key":2258,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09","number":"1\u5e74","y":"0.03"},{"key":1275,"name":"AJ737A\uff08480939-001\uff09","number":"1\u5757","y":"0.02"},{"key":2235,"name":"SAS Cable,12Gb,Mini SAS HD,2m,-C","number":"4\u6761","y":"0.02"},{"key":2224,"name":"HID-600RO RO\u53cd\u6e17\u900f\u819c","number":"1\u4e2a","y":"0.01"},{"key":2259,"name":"\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09","number":"1\u5e74","y":"-0.04"},{"key":2257,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09","number":"1\u5e74","y":"-0.05"},{"key":2244,"name":"Thinkplus MK-MC500+","number":"10\u4e2a","y":"-0.36"}],"seriesProfitsPct":[{"key":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","number":"4\u6b21","y":"100.00"},{"key":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","number":"2\u5957","y":"100.00"},{"key":2261,"name":"MK-MC300","number":"5\u4e2a","y":"99.99"},{"key":2260,"name":"\u516c\u6709\u4e91 \u4e13\u4eab\u670d\u52a1-\u8d34\u5fc3\u670d\u52a1\uff08\u6807\u51c6\u7248-M\uff09","number":"1\u5e74","y":"93.88"},{"key":1928,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"87.38"},{"key":41,"name":"X423A-R5","number":"2\u5757","y":"74.00"},{"key":984,"name":"PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","number":"2\u4e2a","y":"72.86"},{"key":1927,"name":"\u672c\u5730\u7f51\u5173\u6740\u6bd2\u7eed\u8d39\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"64.83"},{"key":1929,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0\uff08\u9002\u7528\u4e8eAF-1000-B1180\uff09","number":"1\u5957","y":"64.83"},{"key":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","number":"8\u5957","y":"61.66"},{"key":1511,"name":"V-FDNVUL-0I-SU1AR-00","number":"2\u5957","y":"59.39"},{"key":2258,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 \u9ad8\u6027\u80fd\u5757\u5b58\u50a8\uff08\u6807\u51c6\u578b\uff09","number":"1\u5e74","y":"55.72"},{"key":989,"name":"PAN-PA-400-RACKTRAY","number":"1\u5957","y":"52.16"},{"key":1007,"name":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf","number":"120\u5957","y":"49.58"},{"key":868,"name":"LIS-F1000-AK-URL-1Y","number":"1\u5e74","y":"49.07"},{"key":867,"name":"LIS-F1000-AK-IPS-1Y","number":"1\u5e74","y":"40.23"},{"key":2231,"name":"PAN-PA-3440-ATP-3YR","number":"1\u5957","y":"39.02"},{"key":2232,"name":"PAN-SVC-BKLN-3440-3YR","number":"1\u5957","y":"39.02"},{"key":2230,"name":"PAN-PA-3440","number":"1\u53f0","y":"38.48"},{"key":2224,"name":"HID-600RO RO\u53cd\u6e17\u900f\u819c","number":"1\u4e2a","y":"34.33"},{"key":851,"name":"PAN-PA-460","number":"2\u53f0","y":"33.33"},{"key":1339,"name":"PAN-SVC-BKLN-460-3YR","number":"2\u5e74","y":"33.33"},{"key":2233,"name":"PAN-PA-460-BND-CORESEC-3YR","number":"2\u5957","y":"33.33"},{"key":1340,"name":"PAN-PWR-50W-AC","number":"2\u4e2a","y":"33.31"},{"key":994,"name":"PAN-SVC-BKLN-1410-3YR","number":"2\u5957","y":"31.71"},{"key":1562,"name":"PAN-PWR-450W-AC","number":"2\u5957","y":"31.50"},{"key":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","number":"2\u5957","y":"31.49"},{"key":969,"name":"PAN-PA-1410","number":"2\u53f0","y":"31.02"},{"key":1275,"name":"AJ737A\uff08480939-001\uff09","number":"1\u5757","y":"30.56"},{"key":870,"name":"LIS-F1000-AK-AV-1Y","number":"1\u5e74","y":"27.17"},{"key":2243,"name":"Q100","number":"10\u53f0","y":"25.90"},{"key":1780,"name":"X343A-R6","number":"6\u4e2a","y":"19.35"},{"key":1774,"name":"\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248","number":"1\u5957","y":"19.29"},{"key":2236,"name":"DS212C\uff084TB*6\u5757\u786c\u76d8\uff09","number":"1\u53f0","y":"17.74"},{"key":1925,"name":"SASE-SWG\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1-\u5206\u652f\u7248(100M\u5e26\u5bbd\uff09","number":"1\u5957","y":"16.89"},{"key":2253,"name":"DRZ32-W3 V1.0","number":"1\u53f0","y":"16.67"},{"key":2241,"name":"XMS1000","number":"1\u5957","y":"15.29"},{"key":2235,"name":"SAS Cable,12Gb,Mini SAS HD,2m,-C","number":"4\u6761","y":"12.50"},{"key":1558,"name":"PAN-PA-1420","number":"2\u53f0","y":"10.00"},{"key":1890,"name":"V-FDNVUL-0I-SU1YP-00","number":"2\u5957","y":"9.77"},{"key":2237,"name":"ZB-W8G40PXL","number":"2\u53f0","y":"3.00"},{"key":2238,"name":"WS-S1-MD","number":"2\u5957","y":"3.00"},{"key":2239,"name":"WS-S1-AIS","number":"2\u5957","y":"3.00"},{"key":2240,"name":"WS-S1-SNGIO","number":"2\u5957","y":"3.00"},{"key":2244,"name":"Thinkplus MK-MC500+","number":"10\u4e2a","y":"-38.13"},{"key":2259,"name":"\u7f51\u7edc\u4e0eCDN \u7535\u4fe1\u5e26\u5bbd\u3001IP\u4f18\u60e0\u5305-\u6e56\u5357\uff08\u957f\u6c99\u4e00\u533a\uff09","number":"1\u5e74","y":"-140.00"},{"key":2257,"name":"\u516c\u6709\u4e91 \u4e91\u4e3b\u673a\uff08\u5357\u533a\uff09\u670d\u52a1\u8d39 ecs.c6.large\uff082\u68384G\uff09","number":"1\u5e74","y":"-490.60"}],"totalCount":{"totalBudget":1917.39,"totalProfits":1374.63,"pct":0.7169}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-12 10:15:21', 126259968) RETURNING "id"

[+] Explain