By using metrics provided in [Provide metrics that would help us to detect the potential N+1 CACHED SQL calls](https://gitlab.com/gitlab-org/gitlab/-/issues/259007) we should: - investigate and try to reduce several calls that potentialy have N+1 cached queries - improve those endpoints (if possible) - measure the performance improvements - add specs using QueryRecorder, and use them as an example for other teams.