Fix N+1 queries in the root level `issues` query
What does this MR do and why?
Recently the vue_issues_dashboard
feature flag was enabled by default. Looking at the logs in https://log.gprd.gitlab.net/app/discover#/view/431e9180-a0f2-11ed-85ed-e7557b0a598c?_g=(filters%3A!()%2CrefreshInterval%3A(pause%3A!t%2Cvalue%3A0)%2Ctime%3A(from%3Anow-7d%2Fd%2Cto%3Anow)) I noticed we are making too many DB queries on the root level GraphQL issues
query
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #377514 (closed)