Comment 13 for bug 691478

Dropping the prejoins makes it 380ms:
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 SourcePackageName, SourcePackageRelease, SourcePackagePublishingHistory WHERE SourcePackagePublishingHistory.archive = 20931 AND SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = SourcePackageName.id AND SourcePackagePublishingHistory.status IN (1, 2) AND SourcePackagePublishingHistory.distroseries = 104 AND (1=1) ORDER BY SourcePackageName.name, SourcePackageRelease.version DESC, SourcePackagePublishingHistory.id DESC LIMIT 51 OFFSET 0;