Improve loading times for sitemaps

[timobrembeck]

Motivation

Our sitemaps are loading very slow and probably do a bunch of database queries which can be optimized.

Proposed Solution

Investigate what is taking so long and try to reduce database queries similar to how we do it for the API - make use of prefetched translations and cache tree operations.

Alternatives

Additional Context