🐛 [Bug] reports query is too expensive and times out often

Created by: Tirokk

Authored by mattwr18 Dec 6, 2019 Closed Dec 9, 2019

---

🐛 Bugreport

The reports query fetches all reports, which have nested FiledReports, nested reviews, nested resources, which have nested attributes as well. This makes it an extremely expensive request. Leading to time outs.

Steps to reproduce the behavior

1. log in as admin
2. go to /moderation
3. see if the reports load
4. ...
5. Profit

Expected behavior

We'd expect that reports would be shown

Additional context

@roschaefer suggested we could do eager loading of certain resources. We could also try pagination