Performance Profiling

Total processing time: 40 ms; Peak memory: 5.195 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

13:23:06.937	5.0 ms	yii\db\Command::query	SELECT count() as count, sum(case when "sub".project_status=3 AND "sub".budget <= collected then 1 else 0 end) countStatus6, sum(case when "sub".project_status=1 then 1 else 0 end) countStatus1, sum(case when "sub".project_status=2 then 1 else 0 end) countStatus2, sum(case when "sub".project_status=3 AND "sub".budget > collected then 1 else 0 end) countStatus3, sum(case when "sub".project_status=4 then 1 else 0 end) countStatus4, sum(case when "sub".project_status=5 then 1 else 0 end) countStatus5 FROM (SELECT FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (SELECT project_id FROM "a57be577deb434"."tbl_sources" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" WHERE (("client"."sales_rep"='1001') OR ("s"."sales_rep"='1001')) AND ((("client"."sales_rep" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL)) OR (("s"."sales_rep" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("s"."sales_rep" IS NULL)) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (project_id IS NOT NULL) GROUP BY "project_id")) "sub"
13:23:06.922	3.1 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:23:06.925	3.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:23:06.945	2.9 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT s. FROM "a57be577deb434"."tbl_sources" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" WHERE (("client"."sales_rep"='1001') OR ("s"."sales_rep"='1001')) AND ((("client"."sales_rep" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL)) OR (("s"."sales_rep" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("s"."sales_rep" IS NULL)) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) GROUP BY "s"."id") "c"
13:23:06.949	2.7 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT s. FROM "a57be577deb434"."tbl_sources" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON "p"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON "u"."id" = "s"."created_by" WHERE ((("client"."sales_rep" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL)) OR (("s"."sales_rep" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("s"."sales_rep" IS NULL)) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("s"."status"=0) GROUP BY "s"."id") "c"
13:23:06.954	2.4 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/source/get-tabs', '{"SourceSearch":{"period":"","status":"","sourceProductTypes":"","projects_opportunity_from":"","created_by":"","distribute_by":"","sales_rep":"1001"},"Filter":{"name":"","sort":"DESC"},"page":"1"}', '{"code":2000,"result":{"countArr":[{"key":"","title":"\u7ebf\u7d22","count":6,"color":"#920783"},{"key":"0","title":"\u5f85\u5206\u914d","count":0,"color":"#00B7EE"}],"statusArr":[{"key":1,"title":"\u9690\u6027\u9700\u6c42","count":0,"color":"#ffc000"},{"key":2,"title":"\u660e\u786e\u9700\u6c42","count":1,"color":"#0064ec"},{"key":3,"title":"\u5546\u673a\u6210\u4ea4","count":0,"color":"#53cd02"},{"key":4,"title":"\u5546\u673a\u5931\u8d25","count":0,"color":"#e5000a"},{"key":5,"title":"\u5546\u673a\u6401\u7f6e","count":5,"color":"#222222"},{"key":-1,"title":"\u6536\u6b3e\u5b8c\u6210","count":0,"color":"#7b33c5"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 13:23:06') RETURNING "id"
13:23:06.929	1.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:23:06.943	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_statuses" ORDER BY "order"