Performance Profiling

Total processing time: 56 ms; Peak memory: 3.356 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

10:20:08.401	11.9 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/client/view-clients', '{"id":"982"}', '{"code":2000,"result":{"list":[{"profit":"5729331.1000000000000000","budget":"12804392","edate":"2026","display":"","display2":"","arrow":1,"arrow2":1},{"profit":0,"budget":0,"edate":2025,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2024,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2023,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2022,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2021,"display":"","display2":"","arrow":0,"arrow2":0},{"profit":0,"budget":0,"edate":2020,"display":"-100","display2":"-100","arrow":-1,"arrow2":-1},{"profit":"373027.500000000000","budget":"2486850","edate":"2019","display":"","display2":"","arrow":1,"arrow2":1}],"years":[{"key":"all","name":"\u5168\u90e8"},{"key":2019,"name":"2019\u5e74"},{"key":2020,"name":"2020\u5e74"},{"key":2021,"name":"2021\u5e74"},{"key":2022,"name":"2022\u5e74"},{"key":2023,"name":"2023\u5e74"},{"key":2024,"name":"2024\u5e74"},{"key":2025,"name":"2025\u5e74"},{"key":2026,"name":"2026\u5e74"}],"analysis":[{"name":"all","data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","y":83.09},{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","y":16.26},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","y":0.34},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","y":0.23},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","y":0.04},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","y":0.03},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","y":0.02}]},{"name":2019,"data":[{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","edate":"2019","y":100}]},{"name":2020,"data":[]},{"name":2021,"data":[]},{"name":2022,"data":[]},{"name":2023,"data":[]},{"name":2024,"data":[]},{"name":2025,"data":[]},{"name":2026,"data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","edate":"2026","y":99.23},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","edate":"2026","y":0.4},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","edate":"2026","y":0.28},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","edate":"2026","y":0.04},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","edate":"2026","y":0.04},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","edate":"2026","y":0.02}]}],"analysis2":[{"name":"all","data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","y":93.68},{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","y":6.11},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","y":0.09},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","y":0.06},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","y":0.01},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","y":0.05},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","y":0}]},{"name":2019,"data":[{"product_type_id":96,"name":"\u89c6\u9891","sum":"2486850","sum2":"373027.5","edate":"2019","y":100}]},{"name":2020,"data":[]},{"name":2021,"data":[]},{"name":2022,"data":[]},{"name":2023,"data":[]},{"name":2024,"data":[]},{"name":2025,"data":[]},{"name":2026,"data":[{"product_type_id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum":"12705272","sum2":"5716762.4","edate":"2026","y":99.78},{"product_type_id":7,"name":"\u8f6f\u4ef6","sum":"51364","sum2":"5196.75","edate":"2026","y":0.09},{"product_type_id":21,"name":"\u6570\u7801\u8bbe\u5907","sum":"35435","sum2":"3543.5","edate":"2026","y":0.06},{"product_type_id":23,"name":"\u793c\u54c1","sum":"5443","sum2":"544.3","edate":"2026","y":0.01},{"product_type_id":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum":"4555","sum2":"3051.85","edate":"2026","y":0.05},{"product_type_id":5,"name":"\u5b89\u5168\u8bbe\u5907","sum":"2323","sum2":"232.3","edate":"2026","y":0}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-01 10:20:08', 21046016) RETURNING "id"
10:20:08.393	4.7 ms	yii\db\Command::query	SELECT product_type_id, ppt.name, sum(ppt.budget) as sum, sum(ppt.budget * ppt.pct / 100) as sum2, to_date(to_char(bargain_date, 'yyyy'), 'yyyy') as edate FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_product_types" "ppt" ON ppt.project_id = p.id WHERE ("project_status"='3') AND ("client_id"=982) AND (ppt.budget is not null) GROUP BY "edate", "product_type_id", "ppt"."name"
10:20:08.399	1.1 ms	yii\db\Command::query	SELECT product_type_id, ppt.name, sum(ppt.budget) as sum, sum(ppt.budget * ppt.pct / 100) as sum2 FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_product_types" "ppt" ON ppt.project_id = p.id WHERE ("project_status"='3') AND ("client_id"=982) AND (ppt.budget is not null) GROUP BY "product_type_id", "ppt"."name"
10:20:08.392	1.0 ms	yii\db\Command::query	SELECT sum(p.budget * p.profit_pct / 100) AS profit, sum(p.budget) AS budget, to_date(to_char(bargain_date, 'yyyy'), 'yyyy') as edate FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."client_id"=982) AND ("p"."project_status"=3) GROUP BY "edate"
10:20:08.391	1.0 ms	yii\db\Command::query	SELECT min(bargain_date) as min FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"=982) AND ("project_status"=3) GROUP BY "client_id"
10:20:08.383	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:20:08.385	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:20:08.389	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE ("c"."id"='982') AND ("deleted"=FALSE)
10:20:08.382	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta