A PHP Error was encountered

Severity: Notice

Message: Constant URL_LANG already defined

Filename: libraries/MY_Controller.php

Line Number: 359

Bontrager: Bontrager Road Stems

Bontrager Road 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 Road

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 XXX CARBON ROAD

BONTRAGER XXX CARBON ROAD

$249.99

Lightweight, strong, and gentle on today's ultra-light handlebars and sensitive carbon steerers, Bontrager's XXX Lite Carbon Road Stem will dress-up any road bike. Designed and tested to exceed CEN standards, the XXX Lite Road features a four-bolt face plate and two opposing steerer clamp bolts to help distribute clamping forces evenly. +/- 7 degree rise. 31.8mm 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 SELECT OS

BONTRAGER SELECT OS

$39.99

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

BONTRAGER SELECT

BONTRAGER SELECT

$29.99

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

26.0 Quill Stems

BONTRAGER SELECT ROAD

BONTRAGER SELECT ROAD

$29.99

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


  MEMORY USAGE  
2,484,572 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0392
Controller Execution Time ( Products / Subcategories )  0.2648
Total Execution Time  0.3049
  URI STRING  
/products/road/stems/en
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  QUERIES (6)  
0.0057  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.0038  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.1599  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 = 'road' AND cat.uri_name = 'stems' ORDER BY sitecat.sequence, sitesub.sequence, price.max_price DESC
0.0026  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 = 'road'
0.0030  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 = 'road'
0.0034  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 = 10 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 = 10)) ORDER BY c.publish_up desc