N+1 query in loading vulnerability policy
Found that when loading instance security vulnerabilities report (.../-/security/vulnerabilities) as part of this
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
License Load (0.6ms) SELECT "licenses".* FROM "licenses" ORDER BY "licenses"."id" DESC LIMIT 100 /*application:web,correlation_id:01F7SKHM8TMG94ZPFYV5CWMXTZ,endpoint_id:GraphqlController#execute,line:/ee/app/models/license.rb:302:in `load_license'*/
↳ ee/app/models/license.rb:302:in `load_license'
Group Load (3.1ms) SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = 'Group' AND "namespaces"."id" = 1 LIMIT 1 /*application:web,correlation_id:01F7SKHM8TMG94ZPFYV5CWMXTZ,endpoint_id:GraphqlController#execute,line:/ee/app/policies/ee/project_policy.rb:311:in `block (2 levels) in <module:ProjectPolicy>'*/
↳ ee/app/policies/ee/project_policy.rb:311:in `block (2 levels) in <module:ProjectPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
CACHE Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 12 LIMIT 1
↳ ee/app/policies/vulnerability_policy.rb:4:in `block in <class:VulnerabilityPolicy>'
Edited by Subashis Chakraborty