Performance Profiling

Total processing time: 64 ms; Peak memory: 5.224 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

10:09:05.859	21.2 ms	yii\db\Command::query	SELECT 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 (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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) 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
10:09:05.886	5.9 ms	yii\db\Command::query	select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_product_brands' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:09:05.881	4.4 ms	yii\db\Command::query	SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /int2/ THEN 16 WHEN 23 /int4/ THEN 32 WHEN 20 /int8/ THEN 64 WHEN 1700 /numeric/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /float4/ THEN 24 /FLT_MANT_DIG/ WHEN 701 /float8/ THEN 53 /DBL_MANT_DIG/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_product_brands' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
10:09:05.894	3.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-22')
10:09:05.849	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:09:05.899	1.9 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-product-brand-histogram', '[]', '{"code":2000,"result":{"category":{"budgetCategory":["Paloalto","\u6df1\u4fe1\u670d","\u5947\u5b89\u4fe1","\u8fdc\u9274","\u62d3\u5b9e","NetAPP","\u8054\u60f3","\u9752\u85e4","\u665f\u6e90","ZStack","\u601d\u79d1","\u6d6a\u6f6e","\u98de\u5854","\u58f9\u8fdb\u5236","\u7b2c\u4e09\u65b9","\u534e\u4e3a","\u6234\u5c14\uff08DELL\uff09","H3C","\u7eb3\u591a\u5fb7","\u7fa4\u6656","Veeam","\u5b89\u6052","NVIDIA","\u9f50\u6cbb","\u7f51\u5fa1","\u5929\u878d\u4fe1","\u795e\u901a","\u901f\u77f3","HP","\u5b89\u76df\u534e\u5fa1","\u5b81\u7545","\u4e1c\u65b9\u901a","\u5409\u5927\u6b63\u5143","\u79d1\u529b\u9510","\u4e09\u672a\u4fe1\u5b89","\u5317\u4eac\u6570\u5b57\u8ba4\u8bc1","\u4fe1\u9510","\u5408\u4f17","\u5317\u4fe1\u6e90","\u4eba\u5927\u91d1\u4ed3","\u5353\u8c6a\uff08ZOHO\uff09","\u8d5b\u95e8\u94c1\u514b","\u4ebf\u8d5b\u901a","\u4e2d\u671b","\u9f0e\u7532\u79d1\u6280","\u5929\u5927\u6e05\u6e90","\u7231\u6570","\u94f6\u6cb3\u9e92\u9e9f","\u4e9a\u4fe1","\u5b89\u5fbd\u548c\u80fd","\u4e09\u661f","\u4e2d\u5b5a","\u76db\u90a6\u5b89\u5168","\u7ef4\u8c1b","Toast","\u8fbe\u68a6","\u91d1\u5c71","\u5662\u6613\u4e91","\u798f\u6615","Vmware","\u5b81\u76fe","\u91d1\u5c71\u529e\u516c","\u4ebf\u8054","\u4efb\u5b50\u884c","\u5954\u56fe","\u6570\u79d1\u7f51\u7ef4","\u795e\u57fa","\u827e\u6bd4\u68ee","\u5c71\u7279","Solarflare","\u7eff\u76df","\u745e\u661f","\u4f73\u80fd","\u6d77\u8bfa\u6cf0","\u8010\u666e","\u79d1\u534e","\u4e1c\u829d","\u5927\u4e3a","\u9510\u6377","\u5e0c\u6377","\u6d1b\u5b9d\u6765","\u9ea6\u5149","\u4e09\u6c5f","\u6e05\u534e\u540c\u65b9","\u5fae\u8f6f","\u5b89\u817e","\u7d22\u5c3c","\u8fc8\u7edc\u601d","\u56fe\u817e","\u6b63\u5929\u9f50","\u7edf\u4fe1","\u6587\u6714","\u8d62\u8fbe\u4fe1","\u529b\u738b","\u521b\u84dd","\u80dc\u4e3a","\u82f1\u7279\u5c14","\u6fb3\u5929","\u6817\u8f69","\u5927\u534e","\u5b8f\u6749","\u519b\u4e91","BBNEW","\u68b5\u60f3","netLINK"],"profitsCategory":["\u62d3\u5b9e","\u6df1\u4fe1\u670d","Paloalto","NetAPP","\u8054\u60f3","\u9752\u85e4","\u601d\u79d1","\u665f\u6e90","\u6d6a\u6f6e","\u58f9\u8fdb\u5236","ZStack","\u98de\u5854","\u7eb3\u591a\u5fb7","\u6234\u5c14\uff08DELL\uff09","Veeam","\u7fa4\u6656","\u534e\u4e3a","\u5947\u5b89\u4fe1","\u9f50\u6cbb","H3C","\u7f51\u5fa1","\u901f\u77f3","\u8fdc\u9274","\u5929\u878d\u4fe1","\u5b89\u6052","\u4e1c\u65b9\u901a","\u4fe1\u9510","\u5929\u5927\u6e05\u6e90","HP","\u5353\u8c6a\uff08ZOHO\uff09","\u5409\u5927\u6b63\u5143","Toast","\u795e\u901a","\u9f0e\u7532\u79d1\u6280","\u5b81\u7545","\u5317\u4fe1\u6e90","\u4e9a\u4fe1","\u4e2d\u5b5a","\u4eba\u5927\u91d1\u4ed3","\u7ef4\u8c1b","\u7231\u6570","\u5662\u6613\u4e91","\u5317\u4eac\u6570\u5b57\u8ba4\u8bc1","\u5b81\u76fe","\u4e2d\u671b","\u798f\u6615","\u8fbe\u68a6","\u94f6\u6cb3\u9e92\u9e9f","Vmware","\u5b89\u5fbd\u548c\u80fd","\u7eff\u76df","\u745e\u661f","\u6570\u79d1\u7f51\u7ef4","Solarflare","NVIDIA","\u91d1\u5c71","\u4ebf\u8054","\u79d1\u529b\u9510","\u4e1c\u829d","\u5408\u4f17","\u4efb\u5b50\u884c","\u5927\u4e3a","\u9ea6\u5149","\u795e\u57fa","\u5b89\u76df\u534e\u5fa1","\u91d1\u5c71\u529e\u516c","\u9510\u6377","\u6d1b\u5b9d\u6765","\u5c71\u7279","\u5fae\u8f6f","\u6d77\u8bfa\u6cf0","\u6e05\u534e\u540c\u65b9","\u8d5b\u95e8\u94c1\u514b","\u8010\u666e","\u79d1\u534e","\u4e09\u6c5f","\u5b89\u817e","\u8fc8\u7edc\u601d","\u529b\u738b","\u76db\u90a6\u5b89\u5168","\u6587\u6714","\u6b63\u5929\u9f50","\u6fb3\u5929","\u5e0c\u6377","\u521b\u84dd","BBNEW","\u827e\u6bd4\u68ee","\u7edf\u4fe1","\u6817\u8f69","\u5b8f\u6749","\u5927\u534e","\u7d22\u5c3c","\u82f1\u7279\u5c14","\u68b5\u60f3","\u519b\u4e91","\u4ebf\u8d5b\u901a","netLINK","\u56fe\u817e","\u4f73\u80fd","\u80dc\u4e3a","\u8d62\u8fbe\u4fe1","\u5954\u56fe","\u4e09\u661f","\u4e09\u672a\u4fe1\u5b89","\u7b2c\u4e09\u65b9"],"profitsPctCategory":["Toast","\u62d3\u5b9e","\u5929\u5927\u6e05\u6e90","NetAPP","BBNEW","\u5662\u6613\u4e91","\u4e2d\u5b5a","\u7ef4\u8c1b","\u5b81\u76fe","\u9f0e\u7532\u79d1\u6280","\u9ea6\u5149","\u6df1\u4fe1\u670d","\u6fb3\u5929","\u4e9a\u4fe1","Veeam","\u5353\u8c6a\uff08ZOHO\uff09","\u7eff\u76df","\u745e\u661f","\u4e1c\u829d","\u5927\u4e3a","\u4fe1\u9510","\u9f50\u6cbb","\u521b\u84dd","\u798f\u6615","\u7f51\u5fa1","\u4e1c\u65b9\u901a","\u529b\u738b","\u7eb3\u591a\u5fb7","\u601d\u79d1","Solarflare","\u5b8f\u6749","\u6817\u8f69","\u9752\u85e4","\u901f\u77f3","\u5fae\u8f6f","\u7231\u6570","\u8054\u60f3","Vmware","\u8fc8\u7edc\u601d","\u6e05\u534e\u540c\u65b9","\u6d1b\u5b9d\u6765","\u6570\u79d1\u7f51\u7ef4","\u6d6a\u6f6e","\u58f9\u8fdb\u5236","\u5409\u5927\u6b63\u5143","\u5317\u4fe1\u6e90","\u8fbe\u68a6","\u9510\u6377","\u6234\u5c14\uff08DELL\uff09","\u6587\u6714","\u5929\u878d\u4fe1","\u5927\u534e","\u7fa4\u6656","\u665f\u6e90","\u5b89\u817e","Paloalto","\u4ebf\u8054","\u4eba\u5927\u91d1\u4ed3","\u6b63\u5929\u9f50","ZStack","\u4e09\u6c5f","\u91d1\u5c71","\u7edf\u4fe1","\u5b81\u7545","\u534e\u4e3a","\u82f1\u7279\u5c14","\u4efb\u5b50\u884c","\u68b5\u60f3","\u6d77\u8bfa\u6cf0","\u98de\u5854","HP","\u8010\u666e","\u795e\u57fa","H3C","\u4e2d\u671b","\u5b89\u6052","\u5b89\u5fbd\u548c\u80fd","\u94f6\u6cb3\u9e92\u9e9f","\u5c71\u7279","\u79d1\u534e","\u795e\u901a","\u5317\u4eac\u6570\u5b57\u8ba4\u8bc1","\u91d1\u5c71\u529e\u516c","\u519b\u4e91","\u5e0c\u6377","\u7d22\u5c3c","\u5408\u4f17","\u79d1\u529b\u9510","\u827e\u6bd4\u68ee","\u8d5b\u95e8\u94c1\u514b","\u76db\u90a6\u5b89\u5168","\u5947\u5b89\u4fe1","NVIDIA","\u5b89\u76df\u534e\u5fa1","\u8fdc\u9274","\u4ebf\u8d5b\u901a","netLINK","\u56fe\u817e","\u4f73\u80fd","\u5954\u56fe","\u4e09\u661f","\u8d62\u8fbe\u4fe1","\u4e09\u672a\u4fe1\u5b89","\u80dc\u4e3a","\u7b2c\u4e09\u65b9"]},"seriesBudget":[{"key":8,"name":"Paloalto","number":"7987","y":"1865.88"},{"key":12,"name":"\u6df1\u4fe1\u670d","number":"1431","y":"1324.54"},{"key":163,"name":"\u5947\u5b89\u4fe1","number":"36","y":"1135.66"},{"key":230,"name":"\u8fdc\u9274","number":"23","y":"854.29"},{"key":133,"name":"\u62d3\u5b9e","number":"198","y":"829.79"},{"key":6,"name":"NetAPP","number":"59","y":"698.58"},{"key":4,"name":"\u8054\u60f3","number":"509","y":"631.94"},{"key":153,"name":"\u9752\u85e4","number":"7","y":"513.80"},{"key":136,"name":"\u665f\u6e90","number":"7","y":"513.19"},{"key":138,"name":"ZStack","number":"895","y":"479.69"},{"key":3,"name":"\u601d\u79d1","number":"445","y":"406.16"},{"key":24,"name":"\u6d6a\u6f6e","number":"41","y":"398.71"},{"key":40,"name":"\u98de\u5854","number":"91","y":"385.51"},{"key":227,"name":"\u58f9\u8fdb\u5236","number":"10","y":"366.40"},{"key":134,"name":"\u7b2c\u4e09\u65b9","number":"227","y":"261.53"},{"key":7,"name":"\u534e\u4e3a","number":"423","y":"177.40"},{"key":9,"name":"\u6234\u5c14\uff08DELL\uff09","number":"34","y":"163.02"},{"key":20,"name":"H3C","number":"289","y":"152.75"},{"key":150,"name":"\u7eb3\u591a\u5fb7","number":"1","y":"151.20"},{"key":27,"name":"\u7fa4\u6656","number":"180","y":"137.09"},{"key":16,"name":"Veeam","number":"61","y":"97.17"},{"key":129,"name":"\u5b89\u6052","number":"4","y":"80.41"},{"key":208,"name":"NVIDIA","number":"25","y":"74.24"},{"key":35,"name":"\u9f50\u6cbb","number":"6","y":"67.74"},{"key":243,"name":"\u7f51\u5fa1","number":"12","y":"62.30"},{"key":11,"name":"\u5929\u878d\u4fe1","number":"5","y":"60.50"},{"key":165,"name":"\u795e\u901a","number":"6","y":"55.56"},{"key":219,"name":"\u901f\u77f3","number":"377","y":"53.34"},{"key":2,"name":"HP","number":"99","y":"49.84"},{"key":215,"name":"\u5b89\u76df\u534e\u5fa1","number":"2","y":"44.00"},{"key":211,"name":"\u5b81\u7545","number":"2","y":"35.19"},{"key":167,"name":"\u4e1c\u65b9\u901a","number":"7","y":"30.60"},{"key":148,"name":"\u5409\u5927\u6b63\u5143","number":"122","y":"29.32"},{"key":224,"name":"\u79d1\u529b\u9510","number":"2","y":"27.87"},{"key":248,"name":"\u4e09\u672a\u4fe1\u5b89","number":"5","y":"24.85"},{"key":170,"name":"\u5317\u4eac\u6570\u5b57\u8ba4\u8bc1","number":"1","y":"24.80"},{"key":88,"name":"\u4fe1\u9510","number":"65","y":"23.62"},{"key":177,"name":"\u5408\u4f17","number":"1","y":"22.98"},{"key":157,"name":"\u5317\u4fe1\u6e90","number":"3","y":"21.40"},{"key":226,"name":"\u4eba\u5927\u91d1\u4ed3","number":"3","y":"20.94"},{"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09","number":"14","y":"19.03"},{"key":23,"name":"\u8d5b\u95e8\u94c1\u514b","number":"1851","y":"18.23"},{"key":169,"name":"\u4ebf\u8d5b\u901a","number":"5","y":"17.00"},{"key":175,"name":"\u4e2d\u671b","number":"19","y":"16.15"},{"key":244,"name":"\u9f0e\u7532\u79d1\u6280","number":"1","y":"14.36"},{"key":172,"name":"\u5929\u5927\u6e05\u6e90","number":"22","y":"13.60"},{"key":241,"name":"\u7231\u6570","number":"1","y":"13.49"},{"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f","number":"27","y":"13.40"},{"key":18,"name":"\u4e9a\u4fe1","number":"28","y":"12.92"},{"key":176,"name":"\u5b89\u5fbd\u548c\u80fd","number":"4","y":"12.00"},{"key":10,"name":"\u4e09\u661f","number":"221","y":"11.94"},{"key":147,"name":"\u4e2d\u5b5a","number":"3","y":"9.60"},{"key":139,"name":"\u76db\u90a6\u5b89\u5168","number":"2","y":"8.78"},{"key":124,"name":"\u7ef4\u8c1b","number":"5","y":"8.68"},{"key":33,"name":"Toast","number":"1","y":"8.31"},{"key":213,"name":"\u8fbe\u68a6","number":"1","y":"8.00"},{"key":155,"name":"\u91d1\u5c71","number":"1","y":"7.12"},{"key":164,"name":"\u5662\u6613\u4e91","number":"2","y":"7.00"},{"key":166,"name":"\u798f\u6615","number":"21","y":"6.62"},{"key":15,"name":"Vmware","number":"14","y":"6.33"},{"key":137,"name":"\u5b81\u76fe","number":"31","y":"6.13"},{"key":160,"name":"\u91d1\u5c71\u529e\u516c","number":"120","y":"5.94"},{"key":39,"name":"\u4ebf\u8054","number":"150","y":"5.90"},{"key":135,"name":"\u4efb\u5b50\u884c","number":"2","y":"5.80"},{"key":132,"name":"\u5954\u56fe","number":"19","y":"5.20"},{"key":159,"name":"\u6570\u79d1\u7f51\u7ef4","number":"120","y":"5.16"},{"key":158,"name":"\u795e\u57fa","number":"1","y":"5.00"},{"key":201,"name":"\u827e\u6bd4\u68ee","number":"1","y":"4.40"},{"key":221,"name":"\u5c71\u7279","number":"18","y":"4.35"},{"key":225,"name":"Solarflare","number":"2","y":"4.26"},{"key":49,"name":"\u7eff\u76df","number":"1","y":"4.00"},{"key":168,"name":"\u745e\u661f","number":"1","y":"3.68"},{"key":162,"name":"\u4f73\u80fd","number":"1","y":"3.37"},{"key":130,"name":"\u6d77\u8bfa\u6cf0","number":"33","y":"3.12"},{"key":222,"name":"\u8010\u666e","number":"45","y":"3.00"},{"key":231,"name":"\u79d1\u534e","number":"2","y":"2.98"},{"key":43,"name":"\u4e1c\u829d","number":"87","y":"2.76"},{"key":140,"name":"\u5927\u4e3a","number":"12","y":"2.52"},{"key":54,"name":"\u9510\u6377","number":"6","y":"2.48"},{"key":21,"name":"\u5e0c\u6377","number":"22","y":"2.42"},{"key":146,"name":"\u6d1b\u5b9d\u6765","number":"12","y":"2.27"},{"key":246,"name":"\u9ea6\u5149","number":"35","y":"1.93"},{"key":223,"name":"\u4e09\u6c5f","number":"1","y":"1.91"},{"key":121,"name":"\u6e05\u534e\u540c\u65b9","number":"7","y":"1.78"},{"key":29,"name":"\u5fae\u8f6f","number":"4","y":"1.76"},{"key":174,"name":"\u5b89\u817e","number":"2","y":"1.60"},{"key":161,"name":"\u7d22\u5c3c","number":"1","y":"1.51"},{"key":47,"name":"\u8fc8\u7edc\u601d","number":"13","y":"1.19"},{"key":149,"name":"\u56fe\u817e","number":"3","y":"1.19"},{"key":220,"name":"\u6b63\u5929\u9f50","number":"41","y":"1.07"},{"key":212,"name":"\u7edf\u4fe1","number":"2","y":"0.93"},{"key":143,"name":"\u6587\u6714","number":"5","y":"0.90"},{"key":247,"name":"\u8d62\u8fbe\u4fe1","number":"100","y":"0.80"},{"key":142,"name":"\u529b\u738b","number":"180","y":"0.76"},{"key":131,"name":"\u521b\u84dd","number":"1","y":"0.50"},{"key":152,"name":"\u80dc\u4e3a","number":"158","y":"0.44"},{"key":5,"name":"\u82f1\u7279\u5c14","number":"3","y":"0.42"},{"key":216,"name":"\u6fb3\u5929","number":"1","y":"0.42"},{"key":144,"name":"\u6817\u8f69","number":"5","y":"0.41"},{"key":253,"name":"\u5927\u534e","number":"5","y":"0.36"},{"key":50,"name":"\u5b8f\u6749","number":"1","y":"0.32"},{"key":141,"name":"\u519b\u4e91","number":"25","y":"0.32"},{"key":145,"name":"BBNEW","number":"5","y":"0.32"},{"key":228,"name":"\u68b5\u60f3","number":"16","y":"0.25"},{"key":245,"name":"netLINK","number":"2","y":"0.03"}],"seriesProfits":[{"key":133,"name":"\u62d3\u5b9e","number":"198","y":"829.69"},{"key":12,"name":"\u6df1\u4fe1\u670d","number":"1431","y":"663.97"},{"key":8,"name":"Paloalto","number":"7987","y":"464.65"},{"key":6,"name":"NetAPP","number":"59","y":"430.98"},{"key":4,"name":"\u8054\u60f3","number":"509","y":"209.91"},{"key":153,"name":"\u9752\u85e4","number":"7","y":"174.39"},{"key":3,"name":"\u601d\u79d1","number":"445","y":"154.22"},{"key":136,"name":"\u665f\u6e90","number":"7","y":"133.70"},{"key":24,"name":"\u6d6a\u6f6e","number":"41","y":"124.06"},{"key":227,"name":"\u58f9\u8fdb\u5236","number":"10","y":"111.75"},{"key":138,"name":"ZStack","number":"895","y":"104.02"},{"key":40,"name":"\u98de\u5854","number":"91","y":"71.71"},{"key":150,"name":"\u7eb3\u591a\u5fb7","number":"1","y":"57.55"},{"key":9,"name":"\u6234\u5c14\uff08DELL\uff09","number":"34","y":"46.05"},{"key":16,"name":"Veeam","number":"61","y":"44.98"},{"key":27,"name":"\u7fa4\u6656","number":"180","y":"36.16"},{"key":7,"name":"\u534e\u4e3a","number":"423","y":"34.23"},{"key":163,"name":"\u5947\u5b89\u4fe1","number":"36","y":"28.97"},{"key":35,"name":"\u9f50\u6cbb","number":"6","y":"27.48"},{"key":20,"name":"H3C","number":"289","y":"27.19"},{"key":243,"name":"\u7f51\u5fa1","number":"12","y":"23.90"},{"key":219,"name":"\u901f\u77f3","number":"377","y":"17.85"},{"key":230,"name":"\u8fdc\u9274","number":"23","y":"17.09"},{"key":11,"name":"\u5929\u878d\u4fe1","number":"5","y":"16.00"},{"key":129,"name":"\u5b89\u6052","number":"4","y":"13.58"},{"key":167,"name":"\u4e1c\u65b9\u901a","number":"7","y":"11.70"},{"key":88,"name":"\u4fe1\u9510","number":"65","y":"10.10"},{"key":172,"name":"\u5929\u5927\u6e05\u6e90","number":"22","y":"10.00"},{"key":2,"name":"HP","number":"99","y":"9.08"},{"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09","number":"14","y":"8.80"},{"key":148,"name":"\u5409\u5927\u6b63\u5143","number":"122","y":"8.80"},{"key":33,"name":"Toast","number":"1","y":"8.31"},{"key":165,"name":"\u795e\u901a","number":"6","y":"7.56"},{"key":244,"name":"\u9f0e\u7532\u79d1\u6280","number":"1","y":"7.36"},{"key":211,"name":"\u5b81\u7545","number":"2","y":"6.85"},{"key":157,"name":"\u5317\u4fe1\u6e90","number":"3","y":"6.42"},{"key":18,"name":"\u4e9a\u4fe1","number":"28","y":"6.35"},{"key":147,"name":"\u4e2d\u5b5a","number":"3","y":"5.20"},{"key":226,"name":"\u4eba\u5927\u91d1\u4ed3","number":"3","y":"4.84"},{"key":124,"name":"\u7ef4\u8c1b","number":"5","y":"4.64"},{"key":241,"name":"\u7231\u6570","number":"1","y":"4.49"},{"key":164,"name":"\u5662\u6613\u4e91","number":"2","y":"4.00"},{"key":170,"name":"\u5317\u4eac\u6570\u5b57\u8ba4\u8bc1","number":"1","y":"3.30"},{"key":137,"name":"\u5b81\u76fe","number":"31","y":"3.23"},{"key":175,"name":"\u4e2d\u671b","number":"19","y":"2.85"},{"key":166,"name":"\u798f\u6615","number":"21","y":"2.65"},{"key":213,"name":"\u8fbe\u68a6","number":"1","y":"2.40"},{"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f","number":"27","y":"2.17"},{"key":15,"name":"Vmware","number":"14","y":"2.09"},{"key":176,"name":"\u5b89\u5fbd\u548c\u80fd","number":"4","y":"2.00"},{"key":49,"name":"\u7eff\u76df","number":"1","y":"1.80"},{"key":168,"name":"\u745e\u661f","number":"1","y":"1.66"},{"key":159,"name":"\u6570\u79d1\u7f51\u7ef4","number":"120","y":"1.61"},{"key":225,"name":"Solarflare","number":"2","y":"1.60"},{"key":208,"name":"NVIDIA","number":"25","y":"1.59"},{"key":155,"name":"\u91d1\u5c71","number":"1","y":"1.51"},{"key":39,"name":"\u4ebf\u8054","number":"150","y":"1.44"},{"key":224,"name":"\u79d1\u529b\u9510","number":"2","y":"1.39"},{"key":43,"name":"\u4e1c\u829d","number":"87","y":"1.23"},{"key":177,"name":"\u5408\u4f17","number":"1","y":"1.18"},{"key":135,"name":"\u4efb\u5b50\u884c","number":"2","y":"1.10"},{"key":140,"name":"\u5927\u4e3a","number":"12","y":"1.08"},{"key":246,"name":"\u9ea6\u5149","number":"35","y":"0.98"},{"key":158,"name":"\u795e\u57fa","number":"1","y":"0.90"},{"key":215,"name":"\u5b89\u76df\u534e\u5fa1","number":"2","y":"0.88"},{"key":160,"name":"\u91d1\u5c71\u529e\u516c","number":"120","y":"0.78"},{"key":54,"name":"\u9510\u6377","number":"6","y":"0.72"},{"key":146,"name":"\u6d1b\u5b9d\u6765","number":"12","y":"0.71"},{"key":221,"name":"\u5c71\u7279","number":"18","y":"0.61"},{"key":29,"name":"\u5fae\u8f6f","number":"4","y":"0.59"},{"key":130,"name":"\u6d77\u8bfa\u6cf0","number":"33","y":"0.58"},{"key":121,"name":"\u6e05\u534e\u540c\u65b9","number":"7","y":"0.57"},{"key":23,"name":"\u8d5b\u95e8\u94c1\u514b","number":"1851","y":"0.55"},{"key":222,"name":"\u8010\u666e","number":"45","y":"0.55"},{"key":231,"name":"\u79d1\u534e","number":"2","y":"0.42"},{"key":223,"name":"\u4e09\u6c5f","number":"1","y":"0.41"},{"key":174,"name":"\u5b89\u817e","number":"2","y":"0.40"},{"key":47,"name":"\u8fc8\u7edc\u601d","number":"13","y":"0.39"},{"key":142,"name":"\u529b\u738b","number":"180","y":"0.29"},{"key":139,"name":"\u76db\u90a6\u5b89\u5168","number":"2","y":"0.26"},{"key":143,"name":"\u6587\u6714","number":"5","y":"0.25"},{"key":220,"name":"\u6b63\u5929\u9f50","number":"41","y":"0.24"},{"key":216,"name":"\u6fb3\u5929","number":"1","y":"0.21"},{"key":21,"name":"\u5e0c\u6377","number":"22","y":"0.20"},{"key":131,"name":"\u521b\u84dd","number":"1","y":"0.20"},{"key":145,"name":"BBNEW","number":"5","y":"0.20"},{"key":201,"name":"\u827e\u6bd4\u68ee","number":"1","y":"0.20"},{"key":212,"name":"\u7edf\u4fe1","number":"2","y":"0.19"},{"key":144,"name":"\u6817\u8f69","number":"5","y":"0.15"},{"key":50,"name":"\u5b8f\u6749","number":"1","y":"0.12"},{"key":253,"name":"\u5927\u534e","number":"5","y":"0.10"},{"key":161,"name":"\u7d22\u5c3c","number":"1","y":"0.09"},{"key":5,"name":"\u82f1\u7279\u5c14","number":"3","y":"0.08"},{"key":228,"name":"\u68b5\u60f3","number":"16","y":"0.05"},{"key":141,"name":"\u519b\u4e91","number":"25","y":"0.03"},{"key":169,"name":"\u4ebf\u8d5b\u901a","number":"5","y":"0.00"},{"key":245,"name":"netLINK","number":"2","y":"0.00"},{"key":149,"name":"\u56fe\u817e","number":"3","y":"-0.03"},{"key":162,"name":"\u4f73\u80fd","number":"1","y":"-0.11"},{"key":152,"name":"\u80dc\u4e3a","number":"158","y":"-0.18"},{"key":247,"name":"\u8d62\u8fbe\u4fe1","number":"100","y":"-0.20"},{"key":132,"name":"\u5954\u56fe","number":"19","y":"-0.28"},{"key":10,"name":"\u4e09\u661f","number":"221","y":"-1.08"},{"key":248,"name":"\u4e09\u672a\u4fe1\u5b89","number":"5","y":"-8.65"},{"key":134,"name":"\u7b2c\u4e09\u65b9","number":"227","y":"-152.75"}],"seriesProfitsPct":[{"key":33,"name":"Toast","number":"1","y":"100.00"},{"key":133,"name":"\u62d3\u5b9e","number":"198","y":"99.99"},{"key":172,"name":"\u5929\u5927\u6e05\u6e90","number":"22","y":"73.53"},{"key":6,"name":"NetAPP","number":"59","y":"61.69"},{"key":145,"name":"BBNEW","number":"5","y":"61.66"},{"key":164,"name":"\u5662\u6613\u4e91","number":"2","y":"57.14"},{"key":147,"name":"\u4e2d\u5b5a","number":"3","y":"54.17"},{"key":124,"name":"\u7ef4\u8c1b","number":"5","y":"53.50"},{"key":137,"name":"\u5b81\u76fe","number":"31","y":"52.65"},{"key":244,"name":"\u9f0e\u7532\u79d1\u6280","number":"1","y":"51.24"},{"key":246,"name":"\u9ea6\u5149","number":"35","y":"50.91"},{"key":12,"name":"\u6df1\u4fe1\u670d","number":"1431","y":"50.13"},{"key":216,"name":"\u6fb3\u5929","number":"1","y":"50.00"},{"key":18,"name":"\u4e9a\u4fe1","number":"28","y":"49.17"},{"key":16,"name":"Veeam","number":"61","y":"46.29"},{"key":127,"name":"\u5353\u8c6a\uff08ZOHO\uff09","number":"14","y":"46.27"},{"key":49,"name":"\u7eff\u76df","number":"1","y":"45.00"},{"key":168,"name":"\u745e\u661f","number":"1","y":"45.00"},{"key":43,"name":"\u4e1c\u829d","number":"87","y":"44.64"},{"key":140,"name":"\u5927\u4e3a","number":"12","y":"42.86"},{"key":88,"name":"\u4fe1\u9510","number":"65","y":"42.75"},{"key":35,"name":"\u9f50\u6cbb","number":"6","y":"40.56"},{"key":131,"name":"\u521b\u84dd","number":"1","y":"40.00"},{"key":166,"name":"\u798f\u6615","number":"21","y":"39.98"},{"key":243,"name":"\u7f51\u5fa1","number":"12","y":"38.37"},{"key":167,"name":"\u4e1c\u65b9\u901a","number":"7","y":"38.24"},{"key":142,"name":"\u529b\u738b","number":"180","y":"38.10"},{"key":150,"name":"\u7eb3\u591a\u5fb7","number":"1","y":"38.06"},{"key":3,"name":"\u601d\u79d1","number":"445","y":"37.97"},{"key":225,"name":"Solarflare","number":"2","y":"37.56"},{"key":50,"name":"\u5b8f\u6749","number":"1","y":"37.50"},{"key":144,"name":"\u6817\u8f69","number":"5","y":"36.71"},{"key":153,"name":"\u9752\u85e4","number":"7","y":"33.94"},{"key":219,"name":"\u901f\u77f3","number":"377","y":"33.46"},{"key":29,"name":"\u5fae\u8f6f","number":"4","y":"33.37"},{"key":241,"name":"\u7231\u6570","number":"1","y":"33.28"},{"key":4,"name":"\u8054\u60f3","number":"509","y":"33.22"},{"key":15,"name":"Vmware","number":"14","y":"32.98"},{"key":47,"name":"\u8fc8\u7edc\u601d","number":"13","y":"32.98"},{"key":121,"name":"\u6e05\u534e\u540c\u65b9","number":"7","y":"31.96"},{"key":146,"name":"\u6d1b\u5b9d\u6765","number":"12","y":"31.30"},{"key":159,"name":"\u6570\u79d1\u7f51\u7ef4","number":"120","y":"31.16"},{"key":24,"name":"\u6d6a\u6f6e","number":"41","y":"31.11"},{"key":227,"name":"\u58f9\u8fdb\u5236","number":"10","y":"30.50"},{"key":148,"name":"\u5409\u5927\u6b63\u5143","number":"122","y":"30.00"},{"key":157,"name":"\u5317\u4fe1\u6e90","number":"3","y":"30.00"},{"key":213,"name":"\u8fbe\u68a6","number":"1","y":"30.00"},{"key":54,"name":"\u9510\u6377","number":"6","y":"29.00"},{"key":9,"name":"\u6234\u5c14\uff08DELL\uff09","number":"34","y":"28.25"},{"key":143,"name":"\u6587\u6714","number":"5","y":"27.37"},{"key":11,"name":"\u5929\u878d\u4fe1","number":"5","y":"26.45"},{"key":253,"name":"\u5927\u534e","number":"5","y":"26.40"},{"key":27,"name":"\u7fa4\u6656","number":"180","y":"26.38"},{"key":136,"name":"\u665f\u6e90","number":"7","y":"26.05"},{"key":174,"name":"\u5b89\u817e","number":"2","y":"25.00"},{"key":8,"name":"Paloalto","number":"7987","y":"24.90"},{"key":39,"name":"\u4ebf\u8054","number":"150","y":"24.43"},{"key":226,"name":"\u4eba\u5927\u91d1\u4ed3","number":"3","y":"23.11"},{"key":220,"name":"\u6b63\u5929\u9f50","number":"41","y":"22.07"},{"key":138,"name":"ZStack","number":"895","y":"21.69"},{"key":223,"name":"\u4e09\u6c5f","number":"1","y":"21.38"},{"key":155,"name":"\u91d1\u5c71","number":"1","y":"21.17"},{"key":212,"name":"\u7edf\u4fe1","number":"2","y":"20.26"},{"key":211,"name":"\u5b81\u7545","number":"2","y":"19.46"},{"key":7,"name":"\u534e\u4e3a","number":"423","y":"19.30"},{"key":5,"name":"\u82f1\u7279\u5c14","number":"3","y":"19.03"},{"key":135,"name":"\u4efb\u5b50\u884c","number":"2","y":"18.97"},{"key":228,"name":"\u68b5\u60f3","number":"16","y":"18.87"},{"key":130,"name":"\u6d77\u8bfa\u6cf0","number":"33","y":"18.63"},{"key":40,"name":"\u98de\u5854","number":"91","y":"18.60"},{"key":2,"name":"HP","number":"99","y":"18.23"},{"key":222,"name":"\u8010\u666e","number":"45","y":"18.20"},{"key":158,"name":"\u795e\u57fa","number":"1","y":"18.00"},{"key":20,"name":"H3C","number":"289","y":"17.80"},{"key":175,"name":"\u4e2d\u671b","number":"19","y":"17.65"},{"key":129,"name":"\u5b89\u6052","number":"4","y":"16.88"},{"key":176,"name":"\u5b89\u5fbd\u548c\u80fd","number":"4","y":"16.67"},{"key":151,"name":"\u94f6\u6cb3\u9e92\u9e9f","number":"27","y":"16.19"},{"key":221,"name":"\u5c71\u7279","number":"18","y":"14.04"},{"key":231,"name":"\u79d1\u534e","number":"2","y":"13.98"},{"key":165,"name":"\u795e\u901a","number":"6","y":"13.61"},{"key":170,"name":"\u5317\u4eac\u6570\u5b57\u8ba4\u8bc1","number":"1","y":"13.31"},{"key":160,"name":"\u91d1\u5c71\u529e\u516c","number":"120","y":"13.13"},{"key":141,"name":"\u519b\u4e91","number":"25","y":"10.32"},{"key":21,"name":"\u5e0c\u6377","number":"22","y":"8.12"},{"key":161,"name":"\u7d22\u5c3c","number":"1","y":"6.03"},{"key":177,"name":"\u5408\u4f17","number":"1","y":"5.13"},{"key":224,"name":"\u79d1\u529b\u9510","number":"2","y":"5.00"},{"key":201,"name":"\u827e\u6bd4\u68ee","number":"1","y":"4.55"},{"key":23,"name":"\u8d5b\u95e8\u94c1\u514b","number":"1851","y":"3.00"},{"key":139,"name":"\u76db\u90a6\u5b89\u5168","number":"2","y":"3.00"},{"key":163,"name":"\u5947\u5b89\u4fe1","number":"36","y":"2.55"},{"key":208,"name":"NVIDIA","number":"25","y":"2.14"},{"key":215,"name":"\u5b89\u76df\u534e\u5fa1","number":"2","y":"2.00"},{"key":230,"name":"\u8fdc\u9274","number":"23","y":"2.00"},{"key":169,"name":"\u4ebf\u8d5b\u901a","number":"5","y":"0.00"},{"key":245,"name":"netLINK","number":"2","y":"0.00"},{"key":149,"name":"\u56fe\u817e","number":"3","y":"-2.11"},{"key":162,"name":"\u4f73\u80fd","number":"1","y":"-3.19"},{"key":132,"name":"\u5954\u56fe","number":"19","y":"-5.44"},{"key":10,"name":"\u4e09\u661f","number":"221","y":"-9.07"},{"key":247,"name":"\u8d62\u8fbe\u4fe1","number":"100","y":"-25.00"},{"key":248,"name":"\u4e09\u672a\u4fe1\u5b89","number":"5","y":"-34.79"},{"key":152,"name":"\u80dc\u4e3a","number":"158","y":"-41.63"},{"key":134,"name":"\u7b2c\u4e09\u65b9","number":"227","y":"-58.41"}],"totalCount":{"totalBudget":12692.22,"totalProfits":3876.08,"pct":0.3054}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-22 10:09:05') RETURNING "id"
10:09:05.847	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:09:05.852	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:09:05.898	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=55362