Review database queries in /dungeon_record/record

[SapiensAnatis]

Aspire is showing we make dozens of queries in this endpoint and some of them appear to be the exact same - we may have a potential N+1 issue here so worth checking if we can cut this down