analyze queries involved in serving an update request

[bhearsum]

While investigating #1337 I was looking at query logs for a single update request and it looked like we may be doing a lot of extra queries (even uncached ones) when serving an update request. For example, I saw a lot of queries to required signoff tables that appeared to happen as part of an update request. This needs further investigation. I think the right way forward is to enable query logging on a local instance, disable the agent, and see exactly what runs (and what gets cached across subsequent requests). My investigation was done in stage, so there was potentially other things running at the same time.