Optimize top-level group MR list endpoint performance
## Goal
Improve the performance of the top-level group merge request list endpoint to reduce error budget spend and increase system reliability.
`GET /api/:version/groups/:id/merge_requests`
## Context
The top-level group MR list endpoint is the primary driver of error budget consumption for the Code Review group.
- https://gitlab.com/gitlab-org/gitlab/-/issues/552376+
- https://gitlab.com/gitlab-org/gitlab/-/issues/581541#note_2915869688 (internal)
Previous optimization efforts in https://gitlab.com/groups/gitlab-org/-/epics/17943 have addressed low-hanging fruit to improve the baseline, this epic targets deeper performance improvements needed for meaningful gains.
## Success Criteria
<!-- start roadmap:success_metrics -->
* Improved apdex score for the endpoint
* Decreased error budget spend for Code Review group
<!-- end roadmap:success_metrics -->
### Internal Roadmap Information
<!-- start roadmap:details -->
https://gitlab.com/groups/gitlab-org/-/epics/20250#note_2951853280
<!-- end roadmap:details -->
epic