Code review comment for lp:~jcsackett/launchpad/bugtasks-deacitvated-context-632847

Uhm
this is a correlated subquery; generally this about the worst performing thing we can do: it repeats the same work hundreds of thousands of times.

Worse, we're adding a lookup to product for every bug found, even if we're search in a context where this is impossible and irrelevant - e.g. distro or product searches.

I'm going to roll this back out today to avoid blocking deploys : we have massive issues with bug search already.