We can further simplify the display query when using the paginator because we don't need to include the filter clauses that are used to restrict the rows returned. The paginator returns a list of ids that have already been so restricted so the filter clauses are redundant in the display query.
Switched views for filtered queries that return a bug assigned to a particular user. The workflow views invoked in these queries simply do not scale well. This needs to be addressed fundamentally in workwflow at some point but hacking bug-tracker seems easiest for now.