+editstatus timeout

[Micah Gersten]

https://bugs.edge.launchpad.net/ubuntu/+source/xulrunner/+bug/612847/+editstatus
OOPS-1676ED2697

SQL time: 14238 ms
Non-sql time: 277 ms
Total time: 14515 ms
Statement Count: 30

14001 ms of this is a single query, constructed by Distribution.guessPackageNames:

SELECT PublishedPackage.archive,
    PublishedPackage.binarypackagedescription,
    PublishedPackage.binarypackagename,
    PublishedPackage.binarypackagerelease,
    PublishedPackage.binarypackagesummary,
    PublishedPackage.binarypackageversion,
    PublishedPackage.build,
    PublishedPackage.component,
    PublishedPackage.datebuilt,
    PublishedPackage.distribution,
    PublishedPackage.distroarchseries,
    PublishedPackage.distroseries,
    PublishedPackage.distroseriesname,
    PublishedPackage.id,
    PublishedPackage.packagepublishingstatus,
    PublishedPackage.processorfamily,
    PublishedPackage.processorfamilyname,
    PublishedPackage.section,
    PublishedPackage.sourcepackagename,
    PublishedPackage.sourcepackagerelease,
    PublishedPackage.sourcepackagereleaseversion
    FROM PublishedPackage WHERE
        PublishedPackage.sourcepackagename = 'xulrunner-1.9.2'
        AND PublishedPackage.binarypackagename = 'xulrunner-1.9.2'
        AND PublishedPackage.distribution = 1
        AND PublishedPackage.archive IN (1, 534)
        ORDER BY PublishedPackage.id DESC LIMIT 1;