BugTask:+index timeouts - distributions and milestones being late evaluation loaded - repeatedly - on bug 230350

OOPS-1895K1459
OOPS-1895C1447
 OOPS-1927B436

https://launchpad.net/bugs/230350

74 milestone lookups:
2 74 723 9 714 SQL-launchpad-main-slave
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.distribution = $INT
  AND Milestone.active = TRUE
ORDER BY milestone_sort_key(Milestone.dateexpected, Milestone.name) DESC

73 distribution lookups:
3 73 496 6 490 SQL-launchpad-main-slave
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