ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a213306484d1: POST https://beta.jinchangxiao.com/vue/analysis/project-data at 2026-06-04 04:10:46 pm by 221.216.117.119

Performance Profiling

Total processing time: 163 ms; Peak memory: 5.297 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
16:10:46.4337.9 msyii\db\Command::querySELECT taxonomy_id as key, tt.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_term_taxonomies" "tt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.taxonomy_id = tt.id LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "uclient"."client_type" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "uclient" ON p.used_client = uclient.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id", "c"."client_industry", "c"."client_type", "uclient"."client_industry", "uclient"."client_type") "sub" ON ttr.object_id = sub.id WHERE "tt"."term_id"=9 GROUP BY "tt"."id", "ttr"."taxonomy_id"
16:10:46.4056.3 msyii\db\Command::querySELECT count(*) as count, sum(budget), "project_status" FROM (SELECT sum(bgt.budget) as budget, CASE WHEN project_status = 3 and p.budget <= collected THEN -1 WHEN project_status = 3 and p.budget > collected THEN 3 ELSE project_status END as project_status FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id") "sub" GROUP BY "project_status"
16:10:46.3874.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:10:46.4153.6 msyii\db\Command::querySELECT product_type_id as key, name, sum(budget) as sum_budget, sum(budget * pct / 100) as sum_profit FROM "a57be577deb434"."tbl_project_product_types" "pt" WHERE "project_id" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id") GROUP BY "product_type_id", "name"
16:10:46.3963.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:10:46.3913.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:10:46.4212.7 msyii\db\Command::querySELECT ci.id as key, ci.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_industries" "ci" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "c"."client_industry" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id", "c"."client_industry") "sub" ON ci.id = sub.client_industry GROUP BY "ci"."id"
16:10:46.4482.5 msyii\db\Command::querySELECT "client_id" AS "id", "c"."name" AS "name", count(distinct p.id) as projects, sum(budget) as budget, sum(profits) as profits FROM (SELECT "p"."id", "p"."client_id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id") "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id GROUP BY "client_id", "c"."id"
16:10:46.4122.4 msyii\db\Command::querySELECT count(id) as projects, sum(budget) as budget, sum(profits) as profits, count(distinct client_id) as clients FROM (SELECT p.id, p.budget, (p.budget / 100 * p.profit_pct) as profits, p.client_id FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id") "sub"
16:10:46.4272.3 msyii\db\Command::querySELECT ci.id as key, ci.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_industries" "ci" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "uclient"."client_industry" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "uclient" ON p.used_client = uclient.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id", "c"."client_industry", "c"."client_type", "uclient"."client_industry") "sub" ON ci.id = sub.client_industry GROUP BY "ci"."id"
16:10:46.4242.3 msyii\db\Command::querySELECT ct.id as key, ct.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_types" "ct" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "c"."client_type" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id", "c"."client_industry", "c"."client_type") "sub" ON ct.id = sub.client_type GROUP BY "ct"."id"
16:10:46.4302.2 msyii\db\Command::querySELECT ct.id as key, ct.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_types" "ct" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "uclient"."client_type" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "uclient" ON p.used_client = uclient.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id", "c"."client_industry", "c"."client_type", "uclient"."client_industry", "uclient"."client_type") "sub" ON ct.id = sub.client_type GROUP BY "ct"."id"
16:10:46.4522.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/project-data', '{"period":"currentfascalyear","created_at_period":"","dataUserId":"1001","client_industry":"","client_type":"","projectProductTypes":"","web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":{"statusCount":[{"count":0,"key":1,"name":"\u9690\u6027\u9700\u6c42","sum":0},{"count":5,"key":2,"name":"\u660e\u786e\u9700\u6c42","sum":"165789"},{"count":16,"key":3,"name":"\u5546\u673a\u6210\u4ea4","sum":14947071.78},{"count":0,"key":4,"name":"\u5546\u673a\u5931\u8d25","sum":0},{"count":2,"key":5,"name":"\u5546\u673a\u6401\u7f6e","sum":"420800"},{"count":2,"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210","sum":"29800"}],"counts":{"projects":23,"budget":"15533660.78","profits":"5859940.86443400000000000000","clients":14},"circle":{"budgetCounts":[{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum_budget":"12711072","sum_profit":"5717230.4","y":81.83},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907","sum_budget":"2194751.78","sum_profit":"49403.174434","y":14.13},{"key":7,"name":"\u8f6f\u4ef6","sum_budget":"582297","sum_profit":"86150.64","y":3.75},{"key":21,"name":"\u6570\u7801\u8bbe\u5907","sum_budget":"35435","sum_profit":"3543.5","y":0.23},{"key":23,"name":"\u793c\u54c1","sum_budget":"5443","sum_profit":"544.3","y":0.04},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum_budget":"4555","sum_profit":"3051.85","y":0.03},{"key":2,"name":"\u670d\u52a1\u5668","sum_budget":"107","sum_profit":"17","y":0}],"profitCounts":[{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum_budget":"12711072","sum_profit":"5717230.4","y":97.56},{"key":7,"name":"\u8f6f\u4ef6","sum_budget":"582297","sum_profit":"86150.64","y":1.47},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907","sum_budget":"2194751.78","sum_profit":"49403.174434","y":0.84},{"key":21,"name":"\u6570\u7801\u8bbe\u5907","sum_budget":"35435","sum_profit":"3543.5","y":0.06},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum_budget":"4555","sum_profit":"3051.85","y":0.05},{"key":23,"name":"\u793c\u54c1","sum_budget":"5443","sum_profit":"544.3","y":0.01},{"key":2,"name":"\u670d\u52a1\u5668","sum_budget":"107","sum_profit":"17","y":0}],"statusCounts":[{"key":3,"projects":16,"name":"\u5546\u673a\u6210\u4ea4","y":69.57},{"key":2,"projects":5,"name":"\u660e\u786e\u9700\u6c42","y":21.74},{"key":5,"projects":2,"name":"\u5546\u673a\u6401\u7f6e","y":8.7}],"industryCounts":[{"key":4,"name":"\u901a\u4fe1","sum_budget":"12804399","sum_profit":"5729338.10000000000000000000","y":82.43},{"key":13,"name":"SI\/ISV","sum_budget":"2113428.78","sum_profit":"99032.87443400000000000000","y":13.61},{"key":57,"name":"EDA\/CAE","sum_budget":"593433","sum_profit":"16729.890000000000000000","y":3.82},{"key":18,"name":"\u5a92\u4f53","sum_budget":"21600","sum_profit":"14760.0000000000000000","y":0.14},{"key":10,"name":"\u91d1\u878d","sum_budget":"800","sum_profit":"80.0000000000000000","y":0.01}],"usedClientIndustryCounts":[],"typeCounts":[{"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","sum_budget":"12806099","sum_profit":"5729508.10000000000000000000","y":82.44},{"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","sum_budget":"2134128.78","sum_profit":"113702.87443400000000000000","y":13.74},{"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005","sum_budget":"560100","sum_profit":"5730.000000000000000000","y":3.61},{"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","sum_budget":"33333","sum_profit":"10999.89000000000000000000","y":0.21}],"usedClientTypeCounts":[],"purchaseTypeCounts":[{"key":128,"name":"\u516c\u5f00\u62db\u6807","sum_budget":"12829170","sum_profit":"5736799.14000000000000000000","y":82.59},{"key":165,"name":"\u534f\u8bae\u4f9b\u8d27","sum_budget":"2114908.78","sum_profit":"114877.16443400000000000000","y":13.62},{"key":130,"name":"\u7ade\u4e89\u8c08\u5224","sum_budget":"588782","sum_profit":"8184.560000000000000000","y":3.79},{"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7","sum_budget":"800","sum_profit":"80.0000000000000000","y":0.01},{"key":129,"name":"\u7279\u7ea6\u9080\u6807","sum_budget":"","sum_profit":"","y":0},{"key":182,"name":"\u56f4\u6807","sum_budget":"","sum_profit":"","y":0}]},"histogram":{"category":{"budgetCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>"],"profitsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>"],"clientsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>"],"projectsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>"]},"seriesBudget":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"15533660.78"}],"seriesProfits":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"5859940.86"}],"seriesClients":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":14}],"seriesProjects":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":23}]},"histogramSingle":{"category":{"budgetCategory":["\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5927\u59d1\u8bf4\u7684\u98ce\u683c"],"profitsCategory":["\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5927\u59d1\u8bf4\u7684\u98ce\u683c"],"projectsCategory":["\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","\u5927\u59d1\u8bf4\u7684\u98ce\u683c"]},"seriesBudget":[{"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","y":"12804399"},{"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"1630000"},{"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","y":"560100"},{"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","y":"334107.78"},{"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"88221"},{"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","y":"33333"},{"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"29800"},{"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"29800"},{"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":"20700"},{"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"1400"},{"key":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","y":"900"},{"key":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"800"},{"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"100"},{"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","y":"0"}],"seriesProfits":[{"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","y":"5729338.10000000000000000000"},{"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"28036.00000000000000"},{"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"27714.0000000000000000"},{"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"27714.0000000000000000"},{"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":"14670.0000000000000000"},{"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","y":"10999.8900000000000000"},{"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"8822.1000000000000000"},{"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","y":"6708.774434000000000000"},{"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","y":"5730.000000000000000000"},{"key":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","y":"90.0000000000000000"},{"key":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"80.0000000000000000"},{"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"28.0000000000000000"},{"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"10.00000000000000000000"},{"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","y":"0.00000000000000000000"}],"seriesProjects":[{"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","y":6},{"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":3},{"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","y":2},{"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","y":2},{"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":1},{"key":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","y":1},{"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":1},{"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":1},{"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","y":1},{"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","y":1}]}},"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-04 16:10:46', 151875072) RETURNING "id"
16:10:46.4451.9 msyii\db\Command::querySELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(budget) as budget, sum(profits) as profits, "created_by" FROM (SELECT "p"."id", "p"."client_id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id") "p" GROUP BY "created_by"
16:10:46.4191.8 msyii\db\Command::querySELECT sub.project_status as key, count('sub.id') as projects FROM (SELECT "p"."id", "p"."project_status" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."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 ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id", "p"."project_status") "sub" WHERE sub.project_status != 1 GROUP BY "sub"."project_status"
16:10:46.4431.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
16:10:46.4420.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"='1001' ORDER BY "created_at"