2011-03-14 10:12:07 |
Robert Collins |
description |
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 |
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 |
|