A PHP Error was encountered

Severity: Notice

Message: Constant URL_LANG already defined

Filename: libraries/MY_Controller.php

Line Number: 359

Bontrager: Bontrager Stems

Bontrager Stems

Strong first, light second and often not cheap, Bontrager has never cut corners when it comes to something as important for safety as a stem. Not content to offer only a small number of options, Bontrager develops stems in many different lengths and rises. No matter what your style of riding is, you will find the stem you are looking for.

31.8 Clamp

Bontrager XXX OS Carbon

Bontrager XXX OS Carbon

$249.99

Shave weight, create a stiffer interface, and dress-up any road or mountain bike with this elegant carbon fiber stem. Constructed of a high compression molded carbon body with a cold forged X-Band handlebar clamp, the XXX Lite features a flip-flop positive or negative 12 degree rise and a universal 31.8 clamp.

Bontrager RXL OS

Bontrager RXL OS

$89.99

Light enough for the road but strong enough for the mountain, the forged 7050-T6 aluminum alloy X Lite stem features a flip-flop 7 or 17 degree rise and 31.8 clamp that help make it a study in lightweight versatility.

Bontrager RL OS

Bontrager RL OS

$69.99

Forged from 6061-T6 aluminum alloy, the Race Lite features a flip-flop 7 or 17 degree rise and a trick CNC stem clamp cut-out that saves 10 grams.

BONTRAGER BIG EARL OS FREERIDE

BONTRAGER BIG EARL OS FREERIDE

$59.99

With an internal steerer clamp design that gives incredible lateral stiffness, this top-quality freeride stem is ready to take on whatever big hits, big drops, and big air you throw its way. Forged and then CNC-machined 6061-T6 aluminum, the Big Earl stem features an innovative bar clamp design that utilizes Bontrager's Tangent Technology to eliminate point-loading and more evenly distribute forces on the handlebar.

BONTRAGER SELECT OS

BONTRAGER SELECT OS

$39.99

Bontrager quality and durability at an attractive price. Forged 6061-T6 aluminum body and faceplate.

BONTRAGER EARL OS FREERIDE

BONTRAGER EARL OS FREERIDE

$29.99

Built to withstand the punishing rigours of freeriding, Bontrager's stout Earl stem is cold forged from 6061-T6 aluminum for strength. A four-bolt faceplate securely grips the bar to the stem and helps to distribute loads evenly.

BONTRAGER SELECT

BONTRAGER SELECT

$29.99

Bontrager quality and durability at an attractive price. Forged 6061-T6 aluminum body and faceplate.

25.4 Clamp

BONTRAGER SATELLITE PLUS ADJUSTABLE

BONTRAGER SATELLITE PLUS ADJUSTABLE

$69.99

Quickly and easily adjust your stem height with Bontrager's Satellite Adjustable stem. A unique flip-lever makes it easy to adjust both stem height and bar angle, all without tools. A removable faceplate makes bar swaps or other service adjustments hassle-free.

BONTRAGER RACE

BONTRAGER RACE

$49.99

3D forged for strength, and available in flip-flop 10 degree or 25 degree rises, the Race stem features a 2-bolt, removable B-dot face plate that makes bar removal, adjustment, and service easy.

BONTRAGER ADJUSTABLE

BONTRAGER ADJUSTABLE

$29.99

With over 30 degrees of adjustment, Bontrager's Adjustable stem offers a wide range of hand positions, making it easy for just about any rider to dial-in the perfect riding position. Two-bolt removable faceplate makes bar swaps or other service adjustments hassle-free.


  MEMORY USAGE  
2,491,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0332
Controller Execution Time ( Products / Subcategories )  0.2265
Total Execution Time  0.2604
  URI STRING  
/products/mountain/stems/en
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  QUERIES (6)  
0.0013  SELECT cs.region, cs.currency, cs.currency_text, cs.pricing, cs.site_code, cs.default_language AS site_lang, cs.id AS site_id, cs.catalog_id FROM catalog_sites cs INNER JOIN catalog_site_countries css ON css.site_id = cs.id WHERE css.country_code = 'US'
0.0037  SELECT sec.title AS section_title, c.id, c.created, c.title, LOWER(c.alias) AS alias, c.title_alias, c.introtext, c.fulltext, c.sectionid, c.catid, c.state, c.publish_up, c.publish_down, c.metakey, c.metadesc, c.ordering, c.images, c.alt_img_txt, c.media_id, c.section_head, c.template, sec.alias AS section, languages.code as lang FROM (`jos_sections` sec) JOIN `jos_content` c ON sec.alias = 'dealers' AND c.alias = 'intro' AND sec.id = c.sectionid JOIN `osc_languages` languages ON languages.languages_id = c.langid WHERE languages.code = 'en' AND c.state >= 2 AND c.publish_up <= NOW() AND (c.publish_down >= NOW() OR c.publish_down = '0000-00-00 00:00:00') AND ( ! (c.introtext = '' AND c.fulltext = '') ) LIMIT 1
0.1531  SELECT STRAIGHT_JOIN cat.categories_id AS id, 4 AS catalog_type, cat_d.categories_name AS categoryname, sitecat.parent_id, sitemodel.categories_id AS sid, sub_d.categories_name AS sname, model.uri_name, model_d.categories_name AS name, model_d.categories_description AS description, model.media_id AS media_id, price.price_string FROM catalog_categories sitegrand INNER JOIN catalog_categories sitecat ON sitecat.parent_id = sitegrand.categories_id INNER JOIN catalog_categories sitesub ON sitesub.parent_id = sitecat.categories_id INNER JOIN catalog_categories sitemodel ON sitemodel.parent_id = sitesub.categories_id INNER JOIN osc_categories grand ON grand.categories_id = sitegrand.categories_id INNER JOIN osc_categories cat ON cat.categories_id = sitecat.categories_id INNER JOIN osc_categories model ON model.categories_id = sitemodel.categories_id INNER JOIN osc_categories_description cat_d ON cat_d.categories_id = cat.categories_id AND cat_d.language_id = 1 INNER JOIN osc_categories_description sub_d ON sub_d.categories_id = sitesub.categories_id AND sub_d.language_id = 1 INNER JOIN osc_categories_description model_d ON model_d.categories_id = model.categories_id AND model_d.language_id = 1 LEFT JOIN catalog_category_pricing price ON price.categories_id = model.categories_id AND price.site_id = 1 WHERE grand.uri_name = 'mountain' AND cat.uri_name = 'stems' ORDER BY sitecat.sequence, sitesub.sequence, price.max_price DESC
0.0025  SELECT cat.categories_id FROM (`osc_categories` cat) JOIN `catalog_categories` sitecat ON sitecat.categories_id = cat.categories_id JOIN `osc_categories` parent ON parent.categories_id = cat.parent_id WHERE cat.uri_name = 'stems' AND parent.uri_name = 'mountain'
0.0043  SELECT cat.media_id, cat_d.categories_description as consumer_copy FROM (`osc_categories` cat) JOIN `catalog_categories` sitecat ON sitecat.categories_id = cat.categories_id AND sitecat.catalog_id = 1 JOIN `osc_categories` parent ON parent.categories_id = cat.parent_id JOIN `osc_categories_description` AS cat_d ON cat_d.categories_id = cat.categories_id JOIN `osc_languages` lang ON lang.languages_id = cat_d.language_id WHERE sitecat.catalog_id = '1' AND lang.code = 'en' AND cat.uri_name = 'stems' AND parent.uri_name = 'mountain'
0.0037  SELECT DISTINCT(c.id) AS id, sec.title AS section_title, c.created, c.title, LOWER(c.alias) AS alias, c.title_alias, c.introtext, c.fulltext, c.sectionid, c.catid, c.state, c.publish_up, c.metakey, c.metadesc, c.ordering, c.images, c.alt_img_txt, c.media_id, c.section_head, c.template, sec.alias AS section, languages.code as lang FROM (`jos_content` c) JOIN `bont_catalog_article_map` map ON c.id = map.article_id JOIN `jos_sections` sec ON sec.id = c.sectionid JOIN `osc_languages` languages ON languages.languages_id = c.langid WHERE c.state >= 2 AND c.publish_up <= NOW() AND (c.publish_down >= NOW() OR c.publish_down = '0000-00-00 00:00:00') AND ( ! (c.introtext = '' AND c.fulltext = '') ) AND (map.category_id = 21 OR map.category_id IN (SELECT model.categories_id FROM catalog_categories cat INNER JOIN osc_categories sub ON cat.categories_id = sub.categories_id INNER JOIN osc_categories model ON model.parent_id = sub.categories_id WHERE cat.parent_id = 21)) ORDER BY c.publish_up desc