[Optimization] - speed up database

[chpy04]

Description

Some of our database calls are taking way too long, and putting lots of stress on the database and slowing things down. No database queries should exceed 1000ms (1 second) on the seed data. We should also be warning developers when queries are over that amount so future queries don't have the same issue

Acceptance Criteria

Under regular usage with the seed data, no query should exceed 1000ms. Additionally, any query that does should warn the developer in the console, and suggest making some kind of optimization.

Proposed Solution

Most of the speed issues appear to be from running massive nested queries. and then filtering data afterwards. Queries should be more specific to only include necessary information.

Mocks

No response