Performance Profiling

Total processing time: 20 ms; Peak memory: 3.177 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

13:23:05.171	1.2 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, count(distinct p.used_client) as used_clients, 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 "o6a13e2c574d5a"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."client_id"=1) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year"
13:23:05.174	1.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, 'o6a13e2c574d5a', 5495, 5, 'vue/client/view-client-histogram', '{"to":"","from":"","user_id":"","project_status":"3","alert":"false","id":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"category":{"budgetCategory":["2026\u8d22\u5e74"],"profitsCategory":["2026\u8d22\u5e74"],"clientCategory":["2026\u8d22\u5e74"],"projectCategory":["2026\u8d22\u5e74"],"usedClientCategory":["2026\u8d22\u5e74"]},"seriesBudget":[{"key":"fascal2026","name":"2026\u8d22\u5e74","arrow":0,"arrowNum":"","y":"10000.00"}],"seriesProfits":[{"key":"fascal2026","name":"2026\u8d22\u5e74","arrow":0,"arrowNum":"","y":"6000.00"}],"seriesClients":[{"key":"fascal2026","name":"2026\u8d22\u5e74","arrow":0,"arrowNum":"","y":1}],"seriesProjects":[{"key":"fascal2026","name":"2026\u8d22\u5e74","arrow":0,"arrowNum":"","y":1}],"seriesUsedClients":[{"key":"fascal2026","name":"2026\u8d22\u5e74","arrow":0,"arrowNum":"","y":0}],"totalBudget":10000,"totalProfits":6000,"totalClients":1,"totalProjects":1,"totalUsedClients":0,"avg":{"avg_client":"1.00","avg_used_client":"0.00","avg_project":"1.00","avg_budget":"10000.00","avg_profit":"6000.00"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 13:23:05', 13026816) RETURNING "id"
13:23:05.163	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5495
13:23:05.162	0.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:23:05.169	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=312
13:23:05.167	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_clients" "c" WHERE ("c"."id"='1') AND ("deleted"=FALSE)
13:23:05.165	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
13:23:05.173	0.5 ms	yii\db\Command::query	SELECT count(distinct p.client_id) as avg_client, count(distinct p.used_client) as avg_used_client, count(distinct p.id) as avg_project, sum(p.budget) AS avg_budget, sum(p.budget /100 * profit_pct) AS avg_profit FROM "o6a13e2c574d5a"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."client_id"=1)
13:23:05.177	0.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko/20100101 Firefox/151.0'
13:23:05.170	0.4 ms	yii\db\Command::query	SELECT MIN(bargain_date) FROM "o6a13e2c574d5a"."tbl_projects"
13:23:05.178	0.2 ms	yii\db\Command::execute	UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=11000 WHERE "id"=285