3 https://bugs.launchpad.net/bugs/cve/2010-4080/+index (Cve:+index)
OOPS-1906C1974
3 https://launchpad.net/bugs/cve/2009-0745/+index (Cve:+index)
OOPS-1906D1997
Still doing lazy lookups:
1 67 433 6 427 SQL-launchpad-main-master
SELECT Distribution.answers_usage,
Distribution.blueprints_usage,
Distribution.translations_usage,
Distribution.bug_reported_acknowledgement,
Distribution.bug_reporting_guidelines,
Distribution.bug_supervisor,
Distribution.date_created,
Distribution.description,
Distribution.displayname,
Distribution.domainname,
Distribution.driver,
Distribution.enable_bug_expiration,
Distribution.homepage_content,
Distribution.icon,
Distribution.id,
Distribution.language_pack_admin,
Distribution.logo,
Distribution.max_bug_heat,
Distribution.members,
Distribution.mirror_admin,
Distribution.mugshot,
Distribution.name,
Distribution.official_answers,
Distribution.official_blueprints,
Distribution.official_malone,
Distribution.official_rosetta,
Distribution.OWNER, Distribution.security_contact,
Distribution.summary,
Distribution.title,
Distribution.translation_focus,
Distribution.translationgroup,
Distribution.translationpermission
FROM Distribution
WHERE id IN ($INT)
ORDER BY Distribution.name
2 54 942 17 925 SQL-launchpad-main-master
SELECT Milestone.active, Milestone.codename, Milestone.dateexpected, Milestone.distribution, Milestone.distroseries, Milestone.id, Milestone.name, Milestone.product, Milestone.productseries, Milestone.summary
FROM Milestone
WHERE Milestone.distroseries = $INT
AND Milestone.active = TRUE
ORDER BY milestone_sort_key(Milestone.dateexpected, Milestone.name) DESC
3 53 442 8 434 SQL-launchpad-main-master
SELECT SourcePackagePublishingHistory.ancestor,
SourcePackagePublishingHistory.archive,
SourcePackagePublishingHistory.component,
SourcePackagePublishingHistory.datecreated,
SourcePackagePublishingHistory.datemadepending,
SourcePackagePublishingHistory.datepublished,
SourcePackagePublishingHistory.dateremoved,
SourcePackagePublishingHistory.datesuperseded,
SourcePackagePublishingHistory.distroseries,
SourcePackagePublishingHistory.id,
SourcePackagePublishingHistory.pocket,
SourcePackagePublishingHistory.removal_comment,
SourcePackagePublishingHistory.removed_by,
SourcePackagePublishingHistory.scheduleddeletiondate,
SourcePackagePublishingHistory.section,
SourcePackagePublishingHistory.sourcepackagerelease,
SourcePackagePublishingHistory.status,
SourcePackagePublishingHistory.supersededby
FROM SourcePackagePublishingHistory
WHERE distroseries = $INT
AND archive IN ($INT, $INT)
AND sourcepackagerelease = $INT
ORDER BY SourcePackagePublishingHistory.datecreated DESC LIMIT $INT
406->58 queries for the first url, times out cold on qastaging, 5 seconds hot.
506->??? for the second url - I couldn't get it to render. it doesn't on prod either though so strictly an improvement.