N+1 query in Vulnerabilities::ProjectsGrade
Found that when loading instance security dashabord (.../-/security/dashboard) as part of this
↳ ee/app/models/vulnerabilities/projects_grade.rb:33:in `map'
Project Load (0.9ms) SELECT "projects".* FROM "projects" LEFT JOIN project_features ON projects.id = project_features.project_id WHERE "projects"."id" IN (SELECT "users_security_dashboard_projects"."project_id" FROM "users_security_dashboard_projects" WHERE "users_security_dashboard_projects"."user_id" = 1) AND ("project_features"."security_and_compliance_access_level" > 0 OR "project_features"."security_and_compliance_access_level" IS NULL) AND "projects"."id" = 12 ORDER BY "projects"."id" DESC LIMIT 100 /*application:web,correlation_id:01F7SMAJGKVCV02V5W3N1GWTW2,endpoint_id:GraphqlController#execute,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'*/
↳ lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'
Vulnerabilities::Statistic Load (0.2ms) SELECT "vulnerability_statistics".* FROM "vulnerability_statistics" WHERE "vulnerability_statistics"."project_id" = 12 /*application:web,correlation_id:01F7SMAJGKVCV02V5W3N1GWTW2,endpoint_id:GraphqlController#execute,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'*/
↳ lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'
Route Load (0.2ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Project' AND "routes"."source_id" = 12 /*application:web,correlation_id:01F7SMAJGKVCV02V5W3N1GWTW2,endpoint_id:GraphqlController#execute,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'*/
↳ lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'
Namespace Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" = 1 /*application:web,correlation_id:01F7SMAJGKVCV02V5W3N1GWTW2,endpoint_id:GraphqlController#execute,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'*/
↳ lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'
Route Load (0.3ms) SELECT "routes".* FROM "routes" WHERE "routes"."source_type" = 'Namespace' AND "routes"."source_id" = 1 /*application:web,correlation_id:01F7SMAJGKVCV02V5W3N1GWTW2,endpoint_id:GraphqlController#execute,line:/lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'*/
↳ lib/gitlab/graphql/pagination/keyset/connection.rb:108:in `nodes'
Group Load (0.3ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 1 LIMIT 1 /*application:web,correlation_id:01F7SMAJGKVCV02V5W3N1GWTW2,endpoint_id:GraphqlController#execute,line:/ee/app/policies/ee/project_policy.rb:315:in `block (2 levels) in <module:ProjectPolicy>'*/