Comment 1 for bug 609667

170 10450ms launchpad-main-master 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 = 'firefox-3.0' AND PublishedPackage.binarypackagename = 'firefox-3.0' AND PublishedPackage.distribution = 1 AND PublishedPackage.archive IN (1, 534) ORDER BY PublishedPackage.id DESC LIMIT 1

is the culprit query

SQL time: 12811 ms
Non-sql time: 1498 ms
Total time: 14309 ms
Statement Count: 271

ubuntu_firefox.actions.save: Save Changes
ubuntu_firefox.assignee:
ubuntu_firefox.assignee.option: ubuntu_firefox.assignee.assign_to_nobody
ubuntu_firefox.comment_on_change: Thank you for the update. Can you please try setting gfx.color_management.mode to 2?
ubuntu_firefox.importance: Undecided
ubuntu_firefox.importance-empty-marker: 1
ubuntu_firefox.milestone:
ubuntu_firefox.milestone-empty-marker: 1
ubuntu_firefox.sourcepackagename: firefox-3.0
ubuntu_firefox.status: Incomplete
ubuntu_firefox.status-empty-marker: 1