Performance Profiling

Total processing time: 53 ms; Peak memory: 5.470 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

17:54:10.252	6.7 ms	yii\db\Command::query	SELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, CASE WHEN p.bargain_date >= (to_char(p.bargain_date,'YYYY-') \|\| '01-01') :: DATE THEN to_char( P.bargain_date, 'YYYY')::INTEGER ELSE to_char( P.bargain_date, 'YYYY')::INTEGER - 1 END AS bargain_year FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."created_by" IN (1001, 5049, 5500, 5301, 5499, 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.bargain_date IS NOT NULL) GROUP BY "bargain_year"
17:54:10.227	5.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:54:10.263	4.0 ms	yii\db\Command::query	INSERT 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/sales-year-histogram', '{"user_id":"","project_status":"3","alert":"false","web_access_token":"sHKfFzpC6AXRHThWzDm5OfadRXFFX-oO"}', '{"code":2000,"result":{"category":{"budgetCategory":["2026\u8d22\u5e74","2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"profitsCategory":["2026\u8d22\u5e74","2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"clientCategory":["2026\u8d22\u5e74","2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"projectCategory":["2026\u8d22\u5e74","2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"]},"seriesBudget":[{"key":"fascal2026","name":"2026\u8d22\u5e74","y":"1024670326.37"},{"key":"fascal2025","name":"2025\u8d22\u5e74","y":"35423437.79"},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":"65729653.70"},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":"34874669.59"},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":"35385429.58"},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":"32576503.80"},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":"44169012.80"},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":"48005880.55"},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":"45825636.94"},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":"32376587.50"}],"seriesProfits":[{"key":"fascal2026","name":"2026\u8d22\u5e74","y":"257746918.09"},{"key":"fascal2025","name":"2025\u8d22\u5e74","y":"6124150.51"},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":"8482319.22"},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":"3958090.63"},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":"8547919.01"},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":"7325996.21"},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":"9592543.48"},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":"13310849.09"},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":"8404778.14"},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":"6781289.89"}],"seriesClients":[{"key":"fascal2026","name":"2026\u8d22\u5e74","y":36},{"key":"fascal2025","name":"2025\u8d22\u5e74","y":100},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":110},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":111},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":87},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":79},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":66},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":78},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":87},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":55}],"seriesProjects":[{"key":"fascal2026","name":"2026\u8d22\u5e74","y":44},{"key":"fascal2025","name":"2025\u8d22\u5e74","y":237},{"key":"fascal2024","name":"2024\u8d22\u5e74","y":254},{"key":"fascal2023","name":"2023\u8d22\u5e74","y":205},{"key":"fascal2022","name":"2022\u8d22\u5e74","y":156},{"key":"fascal2021","name":"2021\u8d22\u5e74","y":139},{"key":"fascal2020","name":"2020\u8d22\u5e74","y":146},{"key":"fascal2019","name":"2019\u8d22\u5e74","y":167},{"key":"fascal2018","name":"2018\u8d22\u5e74","y":205},{"key":"fascal2017","name":"2017\u8d22\u5e74","y":140}],"avg":{"avg_client":"37.50","avg_project":"170.30","avg_budget":"140031493.26","avg_profit":"33059624.59"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-07 17:54:10', 42251008) RETURNING "id"
17:54:10.232	3.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5252
17:54:10.259	2.2 ms	yii\db\Command::query	SELECT count(distinct p.client_id) as avg_client, count(distinct p.id) as avg_project, sum(p.budget) AS avg_budget, sum(p.budget /100 * profit_pct) AS avg_profit FROM "a57be577deb434"."tbl_projects" "p" WHERE "project_status"=3
17:54:10.239	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:54:10.246	1.8 ms	yii\db\Command::query	SELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects"
17:54:10.237	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:54:10.245	0.5 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2