BranchSet:CollectionResource:#branches timeouts

17 SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Pe ... Person.verbose_bugnotifications, Person.visibility FROM Person WHERE Person.id = $INT LIMIT $INT:
   GET: 17 Robots: 2 Local: 2
      5 https://api.launchpad.net/1.0/branches (BranchSet:CollectionResource:#branches)
       OOPS-1898E1410, OOPS-1898G1864, OOPS-1898G1918, OOPS-1898G26, OOPS-1898G884

Branch: launchpad-rev-12568
Revno: 12568
SQL time: 7939 ms
Non-sql time: 5269 ms
Total time: 13208 ms
Statement Count: 191

still lots of lazy-loaded persons etc

1 65 2680 41 2639 SQL-launchpad-main-master
SELECT Person.account,
       Person.creation_comment,
       Person.creation_rationale,
       Person.datecreated,
       Person.defaultmembershipperiod,
       Person.defaultrenewalperiod,
       Person.displayname,
       Person.hide_email_addresses,
       Person.homepage_content,
       Person.icon,
       Person.id,
       Person.logo,
       Person.mailing_list_auto_subscribe_policy,
       Person.merged,
       Person.mugshot,
       Person.name,
       Person.personal_standing,
       Person.personal_standing_reason,
       Person.registrant,
       Person.renewal_policy,
       Person.subscriptionpolicy,
       Person.teamdescription,
       Person.teamowner,
       Person.verbose_bugnotifications,
       Person.visibility
FROM Person
WHERE Person.id = $INTLIMIT $INT
2 50 1183 23 1160 SQL-launchpad-main-master
SELECT CodeImport.assignee,
       CodeImport.branch,
       CodeImport.cvs_module,
       CodeImport.cvs_root,
       CodeImport.date_created,
       CodeImport.date_last_successful,
       CodeImport.id,
       CodeImport.OWNER, CodeImport.rcs_type,
                         CodeImport.registrant,
                         CodeImport.review_status,
                         CodeImport.update_interval,
                         CodeImport.url
FROM CodeImport
WHERE CodeImport.branch = $INT
ORDER BY CodeImport.id
3 42 897 21 876 SQL-launchpad-main-master
SELECT Product.answers_usage,
       Product.blueprints_usage,
       Product.OWNER, Product.translations_usage,
                      Product.active,
                      Product.autoupdate,
                      Product.bug_reported_acknowledgement,
                      Product.bug_reporting_guidelines,
                      Product.bug_supervisor,
                      Product.bugtracker,
                      Product.date_next_suggest_packaging,
                      Product.datecreated,
                      Product.description,
                      Product.development_focus,
                      Product.displayname,
                      Product.downloadurl,
                      Product.driver,
                      Product.enable_bug_expiration,
                      Product.enable_bugfiling_duplicate_search,
                      Product.freshmeatproject,
                      Product.homepage_content,
                      Product.homepageurl,
                      Product.icon,
                      Product.id,
                      Product.lastdoap,
                      Product.license_approved,
                      Product.license_info,
                      Product.reviewed,
                      Product.logo,
                      Product.max_bug_heat,
                      Product.mugshot,
                      Product.name,
                      Product.official_answers,
                      Product.official_blueprints,
                      Product.official_malone,
                      Product.official_rosetta,
                      Product.private_bugs,
                      Product.programminglang,
                      Product.project,
                      Product.registrant,
                      Product.remote_product,
                      Product.reviewer_whiteboard,
                      Product.screenshotsurl,
                      Product.security_contact,
                      Product.sourceforgeproject,
                      Product.summary,
                      Product.title,
                      Product.translation_focus,
                      Product.translationgroup,
                      Product.translationpermission,
                      Product.wikiurl
FROM Product
WHERE Product.id = $INTLIMIT $INT
4 13 2131 163 1968 SQL-launchpad-main-master
SELECT Branch.branch_format,
       Branch.branch_type,
       Branch.metadir_format,
       Branch.date_created,
       Branch.date_last_modified,
       Branch.summary,
       Branch.distroseries,
       Branch.id,
       Branch.last_mirror_attempt,
       Branch.last_mirrored,
       Branch.last_mirrored_id,
       Branch.last_scanned,
       Branch.last_scanned_id,
       Branch.lifecycle_status,
       Branch.merge_queue_config,
       Branch.merge_queue,
       Branch.mirror_failures,
       Branch.mirror_status_message,
       Branch.name,
       Branch.next_mirror_time,
       Branch.OWNER, Branch.owner_name,
                     Branch.private,
                     Branch.product,
                     Branch.registrant,
                     Branch.repository_format,
                     Branch.reviewer,
                     Branch.revision_count,
                     Branch.sourcepackagename,
                     Branch.stacked_on,
                     Branch.target_suffix,
                     Branch.unique_name,
                     Branch.url,
                     Branch.whiteboard
FROM Branch
WHERE Branch.id = $INTLIMIT $INT