Optimise the worst 5 SQL queries from production

We should look at the cumulative times for our SQL queries across some of our production boxes (over say, a week), and optimise where we can. For instance, extra indexes, more caching. I can see that HApplicationConfiguration gets hit a lot, for instance, and should benefit from caching because it changes rarely.