Investigate slowness in top GraphQL operations

Context & goal

Similarly to #562586 (closed), let's investigate the other top slow GraphQL operations for groupcode review and see if there are low hanging fruits we can resolve (like fetching data that isn't needed).