Clientes
Ingreso Registrarse Olvidó su contraseña?

Mi carrito - 0 item(s)

0 item(s) en su carrito

Transmisión para bicicletas

-59%
OFF!

Schwalbe

Cubierta Schwalbe Rocket Ron EVO 26 TL READY

EN STOCK $2.431.-
$5.929 59% OFF

-50%
OFF!

Orbea

Cuadro Orbea Orca OMP 14

EN STOCK $58.769.-
$117.538 50% OFF

-40%
OFF!

Puños 3T LTD

EN STOCK $1.198.-
$1.997 40% OFF

-40%
OFF!

SRAM

Combo horquilla Rock Shox RS1 con ruedas SRAM Roam 50 29er

EN STOCK $59.990.-
$99.983 40% OFF

-40%
OFF!

SRAM

Ruedas SRAM Roam 50 29er

EN STOCK $57.587.-
$95.979 40% OFF

-40%
OFF!

SRAM

Ruedas SRAM Roam 40 27 5

EN STOCK $36.714.-
$61.190 40% OFF

-39%
OFF!

Puños 3T Team

EN STOCK $971.-
$1.592 39% OFF

-30%
OFF!

Orbea

Cuadro Orbea Alma OMP 27 5 15

EN STOCK $58.421.-
$83.459 30% OFF

Horquilla FOX Float 32 Performance Boost Rod 29

-26%
OFF!

Fox

Horquilla FOX Float 32 Performance Boost Rod 29

EN STOCK $44.777.-
$60.510 26% OFF

-23%
OFF!

Ruedas 3T Mercurio LTD tubulares CeramicSpeed

EN STOCK $111.782.-
$145.171 23% OFF

-22%
OFF!

Ruedas 3T Mercurio LTD tubulares

EN STOCK $92.953.-
$119.170 22% OFF

Horquilla FOX Float 32 Factory RL 100 Rod 29

-20%
OFF!

Fox

Horquilla FOX Float 32 Factory RL 100 Rod 29

EN STOCK $60.086.-
$75.108 20% OFF

-20%
OFF!

Horquilla rígida 3T 29er fibra de carbono

EN STOCK $26.284.-
$32.855 20% OFF

-20%
OFF!

Manubrio de mountain bike 3T 720 Pro aluminio

EN STOCK $3.632.-
$4.540 20% OFF

-20%
OFF!

Manubrio de mountain bike 3T 720 Team carbono

EN STOCK $6.779.-
$8.474 20% OFF

-20%
OFF!

Manubrio de mountain 3T 720 LTD carbono

EN STOCK $7.507.-
$9.384 20% OFF

-19%
OFF!

Rock Shox

Horquilla Rock Shox RS1

EN STOCK $54.660.-
$67.481 19% OFF

Horquilla FOX Float 32 Factory RL BOOST Rod 29

-17%
OFF!

Fox

Horquilla FOX Float 32 Factory RL BOOST Rod 29

EN STOCK $64.298.-
$77.468 17% OFF

Shimano

Shimano HG701 HG-X SIL-TEC 11V

EN STOCK $2.604.-

Shimano

Shimano HG601 HG-X SIL-TEC 11V

EN STOCK $2.101.-

Shimano

Pedal Look Keo 2 Max

EN STOCK $7.066.-

(default) 13 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `181024_bike`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'da4ndf6fvcoov9d26kmf2gcne5' LIMIT 1	0	0	1
2	BEGIN	0	0	0
3	INSERT INTO `181024_bike`.`visits` (`convert`, `order`, `cart`, `contact`, `register`, `news`, `device_id`, `browser_id`, `os_id`, `channel`, `amount`, `cart_amount`, `user_id`, `order_id`, `auto_location`, `ip`, `referer`, `land`, `utm_source`, `utm_medium`, `utm_campaign`, `search`, `social_id`, `modified`, `created`) VALUES (0, 0, 0, 0, 0, 0, 3, 0, 0, 4, 0, 0, NULL, NULL, 'Seattle / United States', '54.87.61.215', '/', 'https://www.thebikecompany.com.ar/productos/transmision.html', '', '', '', '', 8, '2019-05-20 23:08:41', '2019-05-20 23:08:41')	1	1	0
4	COMMIT	0	0	0
5	SELECT `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`, `Categoria`.`descripcion` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`slug` IN ('transmision', 'html') LIMIT 1	1	1	0
6	SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`id` = 17 LIMIT 1	1	1	0
7	SELECT `Categoria`.`id`, `Categoria`.`parent_id`, `Categoria`.`lft`, `Categoria`.`rght`, `Categoria`.`nivel`, `Categoria`.`leaf`, `Categoria`.`habilitada`, `Categoria`.`distribucion`, `Categoria`.`destacada`, `Categoria`.`borrada`, `Categoria`.`lista`, `Categoria`.`paquete_id`, `Categoria`.`slide_id`, `Categoria`.`top_id`, `Categoria`.`nombre`, `Categoria`.`slug`, `Categoria`.`portada`, `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`, `Categoria`.`descripcion` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`lft` <= 55 AND `Categoria`.`rght` >= 90 ORDER BY `Categoria`.`lft` asc	1	1	0
8	SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`id` = 17 LIMIT 1	1	1	0
9	SELECT `Categoria`.`id`, `Categoria`.`leaf` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`rght` < 90 AND `Categoria`.`lft` > 55 ORDER BY `Categoria`.`lft` asc	17	17	0
10	SELECT `Articulo`.`id`, `Articulo`.`published`, `Articulo`.`curva_id`, `Articulo`.`curva2_id`, `Articulo`.`associated_curva_id`, `Articulo`.`categoria_id`, `Articulo`.`marca_id`, `Articulo`.`habilitado`, `Articulo`.`destacado`, `Articulo`.`borrado`, `Articulo`.`oferta`, `Articulo`.`oferta_dist`, `Articulo`.`hot_off`, `Articulo`.`delay_off`, `Articulo`.`oferta_2u`, `Articulo`.`promo`, `Articulo`.`envio_gratis`, `Articulo`.`codigo`, `Articulo`.`slug`, `Articulo`.`nombre`, `Articulo`.`precio`, `Articulo`.`precio_dist`, `Articulo`.`precio_dist_real`, `Articulo`.`rango`, `Articulo`.`precio_min`, `Articulo`.`precio_max`, `Articulo`.`meta_title`, `Articulo`.`meta_description`, `Articulo`.`nuevo`, `Articulo`.`stock_id`, `Articulo`.`stock_id_dist`, `Articulo`.`stock`, `Articulo`.`stock_dist`, `Articulo`.`img1_list`, `Articulo`.`img2_list`, `Articulo`.`colores`, `Articulo`.`score`, `Articulo`.`valoraciones`, `Articulo`.`distribucion`, `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 `181024_bike`.`articulos` AS `Articulo` WHERE `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`oferta` DESC, `Articulo`.`destacado` DESC LIMIT 36	36	36	0
11	SELECT COUNT(*) AS `count` FROM `181024_bike`.`articulos` AS `Articulo` WHERE `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)))	1	1	0
12	SELECT `Categoria`.`id`, `Categoria`.`nivel`, `Categoria`.`slug`, `Categoria`.`nombre`, `Categoria`.`meta_title`, `Categoria`.`portada`, `Categoria`.`icon`, `Categoria`.`leaf` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`habilitada` = 1 AND `Categoria`.`borrada` = 0 AND `Categoria`.`parent_id` = (17) ORDER BY `Categoria`.`lft` ASC	11	11	0
13	SELECT 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 `181024_bike`.`articulos` AS `Articulo` LEFT JOIN `181024_bike`.`marcas` AS `Marca` ON (`Articulo`.`marca_id` = `Marca`.`id`) WHERE ((`Articulo`.`categoria_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC	25	25	0

(default) 13 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `181024_bike`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'da4ndf6fvcoov9d26kmf2gcne5' LIMIT 1

BEGIN

INSERT INTO `181024_bike`.`visits` (`convert`, `order`, `cart`, `contact`, `register`, `news`, `device_id`, `browser_id`, `os_id`, `channel`, `amount`, `cart_amount`, `user_id`, `order_id`, `auto_location`, `ip`, `referer`, `land`, `utm_source`, `utm_medium`, `utm_campaign`, `search`, `social_id`, `modified`, `created`) VALUES (0, 0, 0, 0, 0, 0, 3, 0, 0, 4, 0, 0, NULL, NULL, 'Seattle / United States', '54.87.61.215', '/', 'https://www.thebikecompany.com.ar/productos/transmision.html', '', '', '', '', 8, '2019-05-20 23:08:41', '2019-05-20 23:08:41')

COMMIT

SELECT `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`, `Categoria`.`descripcion` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`slug` IN ('transmision', 'html') LIMIT 1

SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`id` = 17 LIMIT 1

SELECT `Categoria`.`id`, `Categoria`.`parent_id`, `Categoria`.`lft`, `Categoria`.`rght`, `Categoria`.`nivel`, `Categoria`.`leaf`, `Categoria`.`habilitada`, `Categoria`.`distribucion`, `Categoria`.`destacada`, `Categoria`.`borrada`, `Categoria`.`lista`, `Categoria`.`paquete_id`, `Categoria`.`slide_id`, `Categoria`.`top_id`, `Categoria`.`nombre`, `Categoria`.`slug`, `Categoria`.`portada`, `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`, `Categoria`.`descripcion` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`lft` <= 55 AND `Categoria`.`rght` >= 90 ORDER BY `Categoria`.`lft` asc

SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`id` = 17 LIMIT 1

SELECT `Categoria`.`id`, `Categoria`.`leaf` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`rght` < 90 AND `Categoria`.`lft` > 55 ORDER BY `Categoria`.`lft` asc

SELECT `Articulo`.`id`, `Articulo`.`published`, `Articulo`.`curva_id`, `Articulo`.`curva2_id`, `Articulo`.`associated_curva_id`, `Articulo`.`categoria_id`, `Articulo`.`marca_id`, `Articulo`.`habilitado`, `Articulo`.`destacado`, `Articulo`.`borrado`, `Articulo`.`oferta`, `Articulo`.`oferta_dist`, `Articulo`.`hot_off`, `Articulo`.`delay_off`, `Articulo`.`oferta_2u`, `Articulo`.`promo`, `Articulo`.`envio_gratis`, `Articulo`.`codigo`, `Articulo`.`slug`, `Articulo`.`nombre`, `Articulo`.`precio`, `Articulo`.`precio_dist`, `Articulo`.`precio_dist_real`, `Articulo`.`rango`, `Articulo`.`precio_min`, `Articulo`.`precio_max`, `Articulo`.`meta_title`, `Articulo`.`meta_description`, `Articulo`.`nuevo`, `Articulo`.`stock_id`, `Articulo`.`stock_id_dist`, `Articulo`.`stock`, `Articulo`.`stock_dist`, `Articulo`.`img1_list`, `Articulo`.`img2_list`, `Articulo`.`colores`, `Articulo`.`score`, `Articulo`.`valoraciones`, `Articulo`.`distribucion`, `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 `181024_bike`.`articulos` AS `Articulo` WHERE `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`oferta` DESC, `Articulo`.`destacado` DESC LIMIT 36

SELECT COUNT(*) AS `count` FROM `181024_bike`.`articulos` AS `Articulo` WHERE `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)))

SELECT `Categoria`.`id`, `Categoria`.`nivel`, `Categoria`.`slug`, `Categoria`.`nombre`, `Categoria`.`meta_title`, `Categoria`.`portada`, `Categoria`.`icon`, `Categoria`.`leaf` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`habilitada` = 1 AND `Categoria`.`borrada` = 0 AND `Categoria`.`parent_id` = (17) ORDER BY `Categoria`.`lft` ASC

SELECT 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 `181024_bike`.`articulos` AS `Articulo` LEFT JOIN `181024_bike`.`marcas` AS `Marca` ON (`Articulo`.`marca_id` = `Marca`.`id`) WHERE ((`Articulo`.`categoria_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 87, 33))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC

Transmisión para bicicletas

Cubierta Schwalbe Rocket Ron EVO 26 TL READY

Cuadro Orbea Orca OMP 14

Puños 3T Pro

Puños 3T LTD

Combo horquilla Rock Shox RS1 con ruedas SRAM Roam 50 29er

Ruedas SRAM Roam 50 29er

Ruedas SRAM Roam 40 27 5

Puños 3T Team

Cuadro Orbea Alma OMP 27 5 15

Horquilla FOX Float 32 Performance Boost Rod 29

Ruedas 3T Mercurio LTD tubulares CeramicSpeed

Ruedas 3T Mercurio LTD tubulares

Horquilla FOX Float 32 Factory RL 100 Rod 29

Horquilla rígida 3T 29er fibra de carbono

Manubrio de mountain bike 3T 720 Pro aluminio

Manubrio de mountain bike 3T 720 Team carbono

Manubrio de mountain 3T 720 LTD carbono

Horquilla Rock Shox RS1

Horquilla FOX Float 32 Factory RL BOOST Rod 29

Pedal Shimano SPD M520

Shimano CN-HG53 9 vel

Shimano CN-HG54 10 vel

Shimano HG701 HG-X SIL-TEC 11V

Shimano HG601 HG-X SIL-TEC 11V

Shimano CN-6701 10 vel

Sram PC Red22

Sram PC XX1

Sram PC X1

Sram PC 1031

Cadena Sram PC 951 9V

Pedal Shimano SPD M505

Pedales Shimano 105 5800

Eggbeater 3

Candy 2

Candy 1

Pedal Look Keo 2 Max