Product:+filebug timeouts

 OOPS-1875O1575, OOPS-1875O1569
https://bugs.launchpad.net/ubuntu-tweak/+filebug

Revno: 12399
SQL time: 15359 ms
Non-sql time: 247 ms
Total time: 15606 ms
Statement Count: 29

 15038.0 1 SQL-launchpad-main-master
SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
  AND BugTask.product = $INT
  AND Bug.fti @@ ftq($STRING)
  AND (Bug.private = FALSE
       OR EXISTS
         (SELECT BugSubscription.bug
          FROM BugSubscription,
               TeamParticipation
          WHERE TeamParticipation.person = $INT
            AND TeamParticipation.team = BugSubscription.person
            AND BugSubscription.bug = Bug.id
          UNION SELECT BugTask.bug
          FROM BugTask,
               TeamParticipation
          WHERE TeamParticipation.person = $INT
            AND TeamParticipation.team = BugTask.assignee
            AND BugTask.bug = Bug.id))
ORDER BY -rank(Bug.fti, ftq($STRING)), BugTask.bug LIMIT $INT
OFFSET $INT

with a nuts long search string. Its not clear why we do that search during the filebug POST.