2011-02-21 20:48:59 |
Robert Collins |
description |
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 |
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. |
|