2011-03-09 05:00:22 |
Robert Collins |
description |
SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... e AND BugTask.bug = Bug.id )) ORDER BY BugTask.importance DESC, BugTask.id LIMIT $INT OFFSET $INT:
5 https://bugs.launchpad.net/bugs/+bugs (MaloneApplication:+bugs)
OOPS-1866B2679, OOPS-1866C1888, OOPS-1866D3198, OOPS-1866E1851, OOPS-1866H2996
Branch: launchpad-rev-12335
Revno: 12335
SQL time: 16290 ms
Non-sql time: 602 ms
Total time: 16892 ms
Statement Count: 25 |
SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... e AND BugTask.bug = Bug.id )) ORDER BY BugTask.importance DESC, BugTask.id LIMIT $INT OFFSET $INT:
5 https://bugs.launchpad.net/bugs/+bugs (MaloneApplication:+bugs)
OOPS-1866B2679, OOPS-1866C1888, OOPS-1866D3198, OOPS-1866E1851, OOPS-1866H2996
Branch: launchpad-rev-12335
Revno: 12335
SQL time: 16290 ms
Non-sql time: 602 ms
Total time: 16892 ms
Statement Count: 25
4. 105 11338ms SQL-launchpad-main-slave
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)
AND (Bug.date_last_message IS NOT NULL
AND BugTask.date_incomplete <= Bug.date_last_message)
OR (BugTask.status = 15)
AND (Bug.date_last_message IS NULL
OR BugTask.date_incomplete > Bug.date_last_message)
OR (BugTask.status = 17)
OR (BugTask.status = 18)
OR (BugTask.status = 19)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25)
OR (BugTask.status = 30))
AND Bug.duplicateof IS NULL
AND (Bug.fti @@ ftq('race')
OR BugTask.fti @@ ftq('race'))
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE |
|