Notice (8): Undefined offset: 1 [APP/Controller/AppController.php, line 1897]
Shimano y Sram, grupos completos o componentes sueltos. - The Bike Company - Tienda online de bicicletas de montaña, ruta y urbanas.
  0
0 item(s) en su carrito

Shimano y Sram, grupos completos o componentes sueltos.

Shimano HG900 HG-X SIL-TEC 11V EN STOCK
Shimano CN-HG53 9 vel EN STOCK
Shimano CN-HG54 10 vel EN STOCK
Shimano HG701 HG-X SIL-TEC 11V EN STOCK
Shimano CN-7901 10 vel EN STOCK
Shimano CN-6701 10 vel EN STOCK
Shimano CN-HG95 10 vel EN STOCK
Sram PC Red22 EN STOCK

Sram PC Red22

$3.399.-
Sram PC XX1 EN STOCK

Sram PC XX1

$3.268.-
Sram PC X1 EN STOCK

Sram PC X1

$1.496.-
Sram PC 1071 EN STOCK

Sram PC 1071

$1.696.-
Sram PC 1031 EN STOCK

Sram PC 1031

$868.-
Sram PC 951 EN STOCK

Sram PC 951

$615.-
Caja pedalera Sram Pressfit 30 EN STOCK
Sram Pressfit GXP BB92 EN STOCK
Caja pedalera Sram GXP EN STOCK
Piñón Sram PG950 9 v EN STOCK
Piñón Sram PG1050 11-32 10v EN STOCK
Plato Sram XX1 32 dientes 11V EN STOCK
Plato Sram XX1 30 dientes 11V EN STOCK
Cadena Sram PC 1051 10v EN STOCK
Shimano Bike Center
(default) 15 queries took 101 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `263016_bike`.`cake_sessions` AS `Session` WHERE `id` = 'spvkcng6vsq8mbrmihkhcdacs2' LIMIT 10038
2BEGIN0038
3INSERT INTO `263016_bike`.`visits` (`convert`, `order`, `cart`, `contact`, `register`, `news`, `device_id`, `browser_id`, `os_id`, `channel`, `amount`, `user_id`, `order_id`, `auto_location`, `ip`, `referer`, `land`, `utm_source`, `utm_medium`, `utm_campaign`, `search`, `social_id`, `created`) VALUES (0, 0, 0, 0, 0, 0, 3, 0, 0, 4, 0, NULL, NULL, 'Woodbridge / United States', '54.167.196.208', '/', 'https://www.thebikecompany.com.ar/productos/componentes-trasmision.html', '', '', '', '', 8, '2018-04-24 03:16:42')110
4COMMIT110
5SELECT `Categoria`.`id`, `Categoria`.`redirect`, `Categoria`.`redirect_url`, `Categoria`.`habilitada`, `Categoria`.`slide_id`, `Categoria`.`parent_id`, `Categoria`.`top_id`, `Categoria`.`nombre`, `Categoria`.`slug`, `Categoria`.`meta_title`, `Categoria`.`meta_keys`, `Categoria`.`meta_description`, `Categoria`.`nivel`, `Categoria`.`leaf` FROM `263016_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`slug` IN ('componentes-trasmision', 'html') LIMIT 1110
6SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `263016_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`id` = 45 LIMIT 1110
7SELECT `Categoria`.`id`, `Categoria`.`parent_id`, `Categoria`.`lft`, `Categoria`.`rght`, `Categoria`.`nivel`, `Categoria`.`leaf`, `Categoria`.`habilitada`, `Categoria`.`destacada`, `Categoria`.`borrada`, `Categoria`.`lista`, `Categoria`.`paquete_id`, `Categoria`.`slide_id`, `Categoria`.`top_id`, `Categoria`.`nombre`, `Categoria`.`slug`, `Categoria`.`imagen`, `Categoria`.`thumb`, `Categoria`.`icon`, `Categoria`.`meta_keys`, `Categoria`.`meta_description`, `Categoria`.`meta_title`, `Categoria`.`pie_articulo`, `Categoria`.`top_articulo`, `Categoria`.`redirect`, `Categoria`.`redirect_url`, `Categoria`.`ml_id`, `Categoria`.`gs_id` FROM `263016_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`lft` <= 70 AND `Categoria`.`rght` >= 101 ORDER BY `Categoria`.`lft` asc220
8SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `263016_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`id` = 45 LIMIT 1110
9SELECT `Categoria`.`id`, `Categoria`.`parent_id`, `Categoria`.`lft`, `Categoria`.`rght`, `Categoria`.`nivel`, `Categoria`.`leaf`, `Categoria`.`habilitada`, `Categoria`.`destacada`, `Categoria`.`borrada`, `Categoria`.`lista`, `Categoria`.`paquete_id`, `Categoria`.`slide_id`, `Categoria`.`top_id`, `Categoria`.`nombre`, `Categoria`.`slug`, `Categoria`.`imagen`, `Categoria`.`thumb`, `Categoria`.`icon`, `Categoria`.`meta_keys`, `Categoria`.`meta_description`, `Categoria`.`meta_title`, `Categoria`.`pie_articulo`, `Categoria`.`top_articulo`, `Categoria`.`redirect`, `Categoria`.`redirect_url`, `Categoria`.`ml_id`, `Categoria`.`gs_id` FROM `263016_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`rght` < 101 AND `Categoria`.`lft` > 70 ORDER BY `Categoria`.`lft` asc15150
10SELECT `Articulo`.`id`, `Articulo`.`published`, `Articulo`.`curva_id`, `Articulo`.`categoria_id`, `Articulo`.`marca_id`, `Articulo`.`habilitado`, `Articulo`.`destacado`, `Articulo`.`borrado`, `Articulo`.`oferta`, `Articulo`.`hot_off`, `Articulo`.`delay_off`, `Articulo`.`oferta_2u`, `Articulo`.`promo`, `Articulo`.`envio_gratis`, `Articulo`.`codigo`, `Articulo`.`slug`, `Articulo`.`nombre`, `Articulo`.`precio`, `Articulo`.`rango`, `Articulo`.`precio_min`, `Articulo`.`precio_max`, `Articulo`.`meta_title`, `Articulo`.`meta_description`, `Articulo`.`nuevo`, `Articulo`.`stock_id`, `Articulo`.`stock`, `Articulo`.`img1_list`, `Articulo`.`img2_list`, `Articulo`.`colores`, `Articulo`.`thumb1`, `Articulo`.`small_thumb1`, `Articulo`.`thumb2`, `Articulo`.`small_thumb2`, `Articulo`.`thumb3`, `Articulo`.`small_thumb3`, `Articulo`.`thumb4`, `Articulo`.`small_thumb4`, `Articulo`.`thumb5`, `Articulo`.`small_thumb5` FROM `263016_bike`.`articulos` AS `Articulo` WHERE ((`Articulo`.`categoria_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_sec_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_ter_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_cuar_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_quin_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_sex_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 ORDER BY `Articulo`.`destacado` DESC, `Articulo`.`stock_id` ASC, `Articulo`.`oferta` DESC LIMIT 36363621
11SELECT COUNT(*) AS `count` FROM `263016_bike`.`articulos` AS `Articulo` WHERE ((`Articulo`.`categoria_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_sec_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_ter_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_cuar_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_quin_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_sex_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1112
12SELECT `Categoria`.`id`, `Categoria`.`nivel`, `Categoria`.`slug`, `Categoria`.`nombre`, `Categoria`.`meta_title`, `Categoria`.`imagen`, `Categoria`.`icon` FROM `263016_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`habilitada` = 1 AND `Categoria`.`borrada` = 0 AND `Categoria`.`parent_id` = 45 ORDER BY `Categoria`.`lft` ASC990
13SELECT COUNT(DISTINCT Articulo.id) as count, COUNT(DISTINCT Articulo.categoria_id) as categ_count, `Marca`.`id`, `Marca`.`nombre`, `Marca`.`meta_title`, `Marca`.`slug`, `Marca`.`imagen` FROM `263016_bike`.`articulos` AS `Articulo` LEFT JOIN `263016_bike`.`marcas` AS `Marca` ON (`Articulo`.`marca_id` = `Marca`.`id`) WHERE ((`Articulo`.`categoria_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_sec_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54)) OR (`Articulo`.`categoria_ter_id` IN (45, 18, 21, 20, 19, 50, 26, 28, 27, 38, 39, 29, 35, 47, 48, 54))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC442
14SELECT `Banner`.`id`, `Banner`.`tipo`, `Banner`.`file`, `Banner`.`url`, `Banner`.`nombre`, `Banner`.`codigo`, `Banner`.`popup` FROM `263016_bike`.`banners` AS `Banner` WHERE `Banner`.`layout` = 'smile' AND `Banner`.`habilitado` = 1 AND `Banner`.`posicion_id` = 2 AND ((`Banner`.`categoria_id` = 45) OR (`Banner`.`destacado` = 1)) ORDER BY `Banner`.`lft` ASC550
15SELECT `Banner`.`id`, `Banner`.`tipo`, `Banner`.`file`, `Banner`.`url`, `Banner`.`nombre`, `Banner`.`codigo`, `Banner`.`popup` FROM `263016_bike`.`banners` AS `Banner` WHERE `Banner`.`layout` = 'smile' AND `Banner`.`habilitado` = 1 AND `Banner`.`posicion_id` = 2 ORDER BY `Banner`.`lft` ASC660