Optimize summary history queries

Summary queries for bug history are the most expensive queries.
Rewrite the queries for open/resolve count to be performed in a single
query.