Reduce the number of queries hitting db, or cache queries or template fragments.

[amschaal]

There are some queries that can probably be optimized, including by joining tables instead of running multiple selects.

Other places, we probably don't need to query the database every request to see if there are bad paths, or new shares shared with the user, etc.

[amschaal]

Logs API is producing a ton of SQL queries. Seemingly one for each log. Fix this.