[merge requests GraphQL] Investigate and improve getState query performance

Background

In #429145 (closed), it was found out that getState GraphQL query can take a long time specifically on detailedMergeStatus field specifically the CheckApprovedService.

More info in discussion: #429145 (comment 1615739974).

Proposal

Investigate what is making it slow and what we can do to improve it.