*:+bugs timeouts searching for tags

[Robert Collins]

  6 SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... ING)) AND Bug.private = FALSE ORDER BY BugTask.importance DESC, BugTask.id LIMIT $INT OFFSET $INT:
   GET: 6 Robots: 0 Local: 5
      3 https://bugs.launchpad.net/bugs/+bugs (MaloneApplication:+bugs)
       OOPS-1948AV219, OOPS-1948AW270, OOPS-1948CC233

[Robert Collins (lifeless)]

 SELECT COUNT(*)
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active
JOIN Bug ON BugTask.bug = Bug.id
WHERE Bug.id = BugTask.bug
  AND ((BugTask.status = 10)
       OR (BugTask.status = 15)
       OR (BugTask.status = 20)
       OR (BugTask.status = 21)
       OR (BugTask.status = 22)
       OR (BugTask.status = 25))
  AND Bug.duplicateof IS NULL
  AND (Bug.fti @@ ftq('firefox'))
  AND (Bugtask.product IS NULL
       OR Product.active = TRUE)
  AND Bug.private = FALSE;

is 1.7s on staging, so not trivially explicable in prod

[Robert Collins (lifeless)]

Bah, somewhere along the line I went crazy apparently; this bug wasn't tag related. However, all the dupes are; and this bug is a one-off, so I'm going to subsume it.

[Launchpad QA Bot (lpqabot)]

Fixed in stable r15188 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/15188>.