ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90d27d86c3: POST https://beta.jinchangxiao.com/vue/analysis/sales-product-brand-histogram at 2025-09-16 03:09:27 pm by 114.244.128.96

Database Queries

总计6条数据
TimeDurationTypeQuery
  
15:09:27.9154.4 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1011

[+] Explain
15:09:27.9201.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

[+] Explain
15:09:27.92610.3 msSELECTSELECT ex.id, ex.name, 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_product_brands" "ex" RIGHT JOIN (SELECT p.product_brand, sum(sub.amount) as amount, sum(sub.cost) as cost, sum(number) as number FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN (SELECT product_id, COALESCE(sum(amount * number), 0) as amount, COALESCE(sum(cost * number)) as cost, COALESCE(sum(number)) as number FROM "a57be577deb434"."tbl_project_product_rels" "ppr" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON ppr.project_id = project.id WHERE (ppr.amount is not null) AND (ppr.cost is not null) AND (ppr.number is not null) AND ("project"."created_by" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("project"."bargain_date" >= '2025-01-01 00:00:00') AND ("project"."bargain_date" <= '2025-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 "ppr"."product_id") "sub" ON sub.product_id = p.id GROUP BY "p"."product_brand") "sub" ON sub.product_brand = ex.id GROUP BY "ex"."id", "sub"."product_brand" HAVING sum(sub.amount) != 0

[+] Explain
15:09:27.9386.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=23) AND ("visit_date"='2025-09-16')

[+] Explain
15:09:27.9460.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=64, "last_visit_at"='now()' WHERE "id"=56587

[+] Explain
15:09:27.9471.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/analysis/sales-product-brand-histogram', '{"produect":"product_brand","series":"seriesBudget","project_status":["3","-1"],"period":"currentfascalyear","web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":{"category":{"budgetCategory":["\u5b81\u76fe","\u58f9\u8fdb\u5236","\u8fdc\u9274","NVIDIA","Paloalto","\u62d3\u5b9e","NetAPP","\u6df1\u4fe1\u670d","\u8054\u60f3","\u601d\u79d1","\u6d6a\u6f6e","\u7fa4\u6656","ZStack","\u4e09\u672a\u4fe1\u5b89","\u5854\u4e07","\u7b2c\u4e09\u65b9","Veeam","\u4eba\u5927\u91d1\u4ed3","\u4e09\u661f","H3C","\u94f6\u6cb3\u9e92\u9e9f","\u5353\u8c6a\uff08ZOHO\uff09","\u4e9a\u4fe1","\u6234\u5c14\uff08DELL\uff09","\u5929\u878d\u4fe1","\u4e1c\u829d","HP","\u534e\u4e3a","\u5c71\u7279","\u5e0c\u6377","\u98de\u5854","\u9510\u6377","\u79d1\u534e","\u8d62\u8fbe\u4fe1","Adobe","\u901f\u77f3","\u5927\u534e","\u5b8f\u6749","\u7ef4\u8c1b","\u82f1\u7279\u5c14"],"profitsCategory":["\u5b81\u76fe","\u62d3\u5b9e","NetAPP","\u58f9\u8fdb\u5236","Paloalto","NVIDIA","\u6df1\u4fe1\u670d","\u8054\u60f3","\u601d\u79d1","\u7fa4\u6656","ZStack","\u5854\u4e07","\u6d6a\u6f6e","\u8fdc\u9274","Veeam","\u5353\u8c6a\uff08ZOHO\uff09","\u4eba\u5927\u91d1\u4ed3","\u4e9a\u4fe1","H3C","\u4e09\u661f","\u94f6\u6cb3\u9e92\u9e9f","\u6234\u5c14\uff08DELL\uff09","HP","\u4e1c\u829d","\u5929\u878d\u4fe1","\u5c71\u7279","\u98de\u5854","\u5b8f\u6749","\u9510\u6377","\u79d1\u534e","\u901f\u77f3","\u5927\u534e","\u7ef4\u8c1b","Adobe","\u5e0c\u6377","\u82f1\u7279\u5c14","\u8d62\u8fbe\u4fe1","\u7b2c\u4e09\u65b9","\u534e\u4e3a","\u4e09\u672a\u4fe1\u5b89"],"profitsPctCategory":["\u62d3\u5b9e","\u5b81\u76fe","NetAPP","HP","\u4e1c\u829d","\u4e9a\u4fe1","\u5854\u4e07","\u5353\u8c6a\uff08ZOHO\uff09","\u5929\u878d\u4fe1","Veeam","\u5b8f\u6749","\u8054\u60f3","\u7fa4\u6656","\u601d\u79d1","ZStack","Paloalto","\u58f9\u8fdb\u5236","\u5927\u534e","\u6df1\u4fe1\u670d","H3C","\u6234\u5c14\uff08DELL\uff09","\u4eba\u5927\u91d1\u4ed3","NVIDIA","\u7ef4\u8c1b","\u94f6\u6cb3\u9e92\u9e9f","\u6d6a\u6f6e","\u82f1\u7279\u5c14","\u4e09\u661f","\u901f\u77f3","\u98de\u5854","\u5c71\u7279","\u9510\u6377","\u79d1\u534e","Adobe","\u5e0c\u6377","\u8fdc\u9274","\u7b2c\u4e09\u65b9","\u8d62\u8fbe\u4fe1","\u4e09\u672a\u4fe1\u5b89","\u534e\u4e3a"]},"seriesBudget":[{"key":137,"name":"\u5b81\u76fe","number":"4","y":"351.89"},{"key":227,"name":"\u58f9\u8fdb\u5236","number":"9","y":"310.40"},{"key":230,"name":"\u8fdc\u9274","number":"3","y":"304.82"},{"key":208,"name":"NVIDIA","number":"10","y":"278.40"},{"key":8,"name":"Paloalto","number":"145","y":"242.73"},{"key":133,"name":"\u62d3\u5b9e","number":"57","y":"236.76"},{"key":6,"name":"NetAPP","number":"10","y":"180.29"},{"key":12,"name":"\u6df1\u4fe1\u670d","number":"398","y":"153.69"},{"key":4,"name":"\u8054\u60f3","number":"45","y":"85.06"},{"key":3,"name":"\u601d\u79d1","number":"65","y":"43.14"},{"key":24,"name":"\u6d6a\u6f6e","number":"13","y":"42.06"},{"key":27,"name":"\u7fa4\u6656","number":"34","y":"34.41"},{"key":138,"name":"ZStack","number":"366","y":"32.64"},{"key":248,"name":"\u4e09\u672a\u4fe1\u5b89","number":"5","y":"24.85"},{"key":254,"name":"\u5854\u4e07","number":"1","y":"20.00"},{"key":134,"name":"\u7b2c\u4e09\u65b9","number":"57","y":"16.60"},{"key":16,"name":"Veeam","number":"9","y":"15.32"},{"key":226,"name":"\u4eba\u5927\u91d1\u4ed3","number":"2","y":"13.94"},{"key":10,"name":"\u4e09\u661f","number":"95","y":"11.11"},{"key":20,"name":"H3C","number":"81","y":"8.86"},{"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f","number":"17","y":"7.99"},{"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09","number":"4","y":"7.42"},{"key":18,"name":"\u4e9a\u4fe1","number":"14","y":"5.81"},{"key":9,"name":"\u6234\u5c14\uff08DELL\uff09","number":"2","y":"5.78"},{"key":11,"name":"\u5929\u878d\u4fe1","number":"1","y":"2.50"},{"key":43,"name":"\u4e1c\u829d","number":"58","y":"1.89"},{"key":2,"name":"HP","number":"19","y":"1.85"},{"key":7,"name":"\u534e\u4e3a","number":"6","y":"1.50"},{"key":221,"name":"\u5c71\u7279","number":"16","y":"1.46"},{"key":21,"name":"\u5e0c\u6377","number":"10","y":"1.24"},{"key":40,"name":"\u98de\u5854","number":"1","y":"1.00"},{"key":54,"name":"\u9510\u6377","number":"3","y":"1.00"},{"key":231,"name":"\u79d1\u534e","number":"1","y":"0.98"},{"key":247,"name":"\u8d62\u8fbe\u4fe1","number":"100","y":"0.80"},{"key":261,"name":"Adobe","number":"1","y":"0.73"},{"key":219,"name":"\u901f\u77f3","number":"1","y":"0.59"},{"key":253,"name":"\u5927\u534e","number":"5","y":"0.36"},{"key":50,"name":"\u5b8f\u6749","number":"1","y":"0.32"},{"key":124,"name":"\u7ef4\u8c1b","number":"1","y":"0.28"},{"key":5,"name":"\u82f1\u7279\u5c14","number":"1","y":"0.09"}],"seriesProfits":[{"key":137,"name":"\u5b81\u76fe","number":"4","y":"351.87"},{"key":133,"name":"\u62d3\u5b9e","number":"57","y":"236.76"},{"key":6,"name":"NetAPP","number":"10","y":"118.88"},{"key":227,"name":"\u58f9\u8fdb\u5236","number":"9","y":"87.65"},{"key":8,"name":"Paloalto","number":"145","y":"73.24"},{"key":208,"name":"NVIDIA","number":"10","y":"64.86"},{"key":12,"name":"\u6df1\u4fe1\u670d","number":"398","y":"41.27"},{"key":4,"name":"\u8054\u60f3","number":"45","y":"31.62"},{"key":3,"name":"\u601d\u79d1","number":"65","y":"13.95"},{"key":27,"name":"\u7fa4\u6656","number":"34","y":"11.91"},{"key":138,"name":"ZStack","number":"366","y":"10.12"},{"key":254,"name":"\u5854\u4e07","number":"1","y":"10.00"},{"key":24,"name":"\u6d6a\u6f6e","number":"13","y":"8.33"},{"key":230,"name":"\u8fdc\u9274","number":"3","y":"6.10"},{"key":16,"name":"Veeam","number":"9","y":"6.07"},{"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09","number":"4","y":"3.58"},{"key":226,"name":"\u4eba\u5927\u91d1\u4ed3","number":"2","y":"3.34"},{"key":18,"name":"\u4e9a\u4fe1","number":"14","y":"3.10"},{"key":20,"name":"H3C","number":"81","y":"2.37"},{"key":10,"name":"\u4e09\u661f","number":"95","y":"2.07"},{"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f","number":"17","y":"1.63"},{"key":9,"name":"\u6234\u5c14\uff08DELL\uff09","number":"2","y":"1.44"},{"key":2,"name":"HP","number":"19","y":"1.08"},{"key":43,"name":"\u4e1c\u829d","number":"58","y":"1.03"},{"key":11,"name":"\u5929\u878d\u4fe1","number":"1","y":"1.00"},{"key":221,"name":"\u5c71\u7279","number":"16","y":"0.19"},{"key":40,"name":"\u98de\u5854","number":"1","y":"0.16"},{"key":50,"name":"\u5b8f\u6749","number":"1","y":"0.12"},{"key":54,"name":"\u9510\u6377","number":"3","y":"0.12"},{"key":231,"name":"\u79d1\u534e","number":"1","y":"0.11"},{"key":219,"name":"\u901f\u77f3","number":"1","y":"0.10"},{"key":253,"name":"\u5927\u534e","number":"5","y":"0.10"},{"key":124,"name":"\u7ef4\u8c1b","number":"1","y":"0.06"},{"key":261,"name":"Adobe","number":"1","y":"0.06"},{"key":21,"name":"\u5e0c\u6377","number":"10","y":"0.04"},{"key":5,"name":"\u82f1\u7279\u5c14","number":"1","y":"0.02"},{"key":247,"name":"\u8d62\u8fbe\u4fe1","number":"100","y":"-0.20"},{"key":134,"name":"\u7b2c\u4e09\u65b9","number":"57","y":"-2.44"},{"key":7,"name":"\u534e\u4e3a","number":"6","y":"-8.02"},{"key":248,"name":"\u4e09\u672a\u4fe1\u5b89","number":"5","y":"-8.65"}],"seriesProfitsPct":[{"key":133,"name":"\u62d3\u5b9e","number":"57","y":"100.00"},{"key":137,"name":"\u5b81\u76fe","number":"4","y":"100.00"},{"key":6,"name":"NetAPP","number":"10","y":"65.94"},{"key":2,"name":"HP","number":"19","y":"58.56"},{"key":43,"name":"\u4e1c\u829d","number":"58","y":"54.62"},{"key":18,"name":"\u4e9a\u4fe1","number":"14","y":"53.31"},{"key":254,"name":"\u5854\u4e07","number":"1","y":"50.00"},{"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09","number":"4","y":"48.27"},{"key":11,"name":"\u5929\u878d\u4fe1","number":"1","y":"40.00"},{"key":16,"name":"Veeam","number":"9","y":"39.62"},{"key":50,"name":"\u5b8f\u6749","number":"1","y":"37.50"},{"key":4,"name":"\u8054\u60f3","number":"45","y":"37.17"},{"key":27,"name":"\u7fa4\u6656","number":"34","y":"34.62"},{"key":3,"name":"\u601d\u79d1","number":"65","y":"32.34"},{"key":138,"name":"ZStack","number":"366","y":"31.00"},{"key":8,"name":"Paloalto","number":"145","y":"30.17"},{"key":227,"name":"\u58f9\u8fdb\u5236","number":"9","y":"28.24"},{"key":253,"name":"\u5927\u534e","number":"5","y":"27.50"},{"key":12,"name":"\u6df1\u4fe1\u670d","number":"398","y":"26.85"},{"key":20,"name":"H3C","number":"81","y":"26.80"},{"key":9,"name":"\u6234\u5c14\uff08DELL\uff09","number":"2","y":"24.87"},{"key":226,"name":"\u4eba\u5927\u91d1\u4ed3","number":"2","y":"23.96"},{"key":208,"name":"NVIDIA","number":"10","y":"23.30"},{"key":124,"name":"\u7ef4\u8c1b","number":"1","y":"21.43"},{"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f","number":"17","y":"20.43"},{"key":24,"name":"\u6d6a\u6f6e","number":"13","y":"19.81"},{"key":5,"name":"\u82f1\u7279\u5c14","number":"1","y":"18.89"},{"key":10,"name":"\u4e09\u661f","number":"95","y":"18.65"},{"key":219,"name":"\u901f\u77f3","number":"1","y":"17.00"},{"key":40,"name":"\u98de\u5854","number":"1","y":"15.83"},{"key":221,"name":"\u5c71\u7279","number":"16","y":"13.19"},{"key":54,"name":"\u9510\u6377","number":"3","y":"12.08"},{"key":231,"name":"\u79d1\u534e","number":"1","y":"11.68"},{"key":261,"name":"Adobe","number":"1","y":"8.22"},{"key":21,"name":"\u5e0c\u6377","number":"10","y":"3.27"},{"key":230,"name":"\u8fdc\u9274","number":"3","y":"2.00"},{"key":134,"name":"\u7b2c\u4e09\u65b9","number":"57","y":"-14.70"},{"key":247,"name":"\u8d62\u8fbe\u4fe1","number":"100","y":"-25.00"},{"key":248,"name":"\u4e09\u672a\u4fe1\u5b89","number":"5","y":"-34.79"},{"key":7,"name":"\u534e\u4e3a","number":"6","y":"-534.45"}],"totalCount":{"totalBudget":2450.56,"totalProfits":1075.04,"pct":0.4387}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 15:09:27') RETURNING "id"

[+] Explain