2011-05-31 08:34:05 |
Robert Collins |
description |
4 SELECT COUNT(*) FROM Archive, ValidPersonOrTeamCache WHERE Archive.purpose = $INT AND Archive.dis ... ValidPersonOrTeamCache.id AND Archive.private = FALSE AND Archive.enabled = TRUE AND ($INT=$INT):
GET: 4 Robots: 0 Local: 4
4 https://launchpad.net/ubuntu/+ppas (Distribution:+ppas)
OOPS-1976AT50, OOPS-1976CF21, OOPS-1976EC31, OOPS-1976O20 |
4 SELECT COUNT(*) FROM Archive, ValidPersonOrTeamCache WHERE Archive.purpose = $INT AND Archive.dis ... ValidPersonOrTeamCache.id AND Archive.private = FALSE AND Archive.enabled = TRUE AND ($INT=$INT):
GET: 4 Robots: 0 Local: 4
4 https://launchpad.net/ubuntu/+ppas (Distribution:+ppas)
OOPS-1976AT50, OOPS-1976CF21, OOPS-1976EC31, OOPS-1976O20
Slow query:
23. 91 8927ms SQL-launchpad-main-master
SELECT COUNT(*)
FROM Archive,
ValidPersonOrTeamCache
WHERE Archive.purpose = 2
AND Archive.distribution = 1
AND Archive.OWNER = ValidPersonOrTeamCache.id
AND Archive.private = FALSE
AND Archive.enabled = TRUE
AND (1=1) |
|