Clientes
Ingreso Registrarse Olvidó su contraseña?

Mi carrito - 0 item(s)

0 item(s) en su carrito

Transmisión para bicicletas

-60%
OFF!

Schwalbe

Cubierta Schwalbe Rocket Ron EVO 26 TL READY

EN STOCK $2.156.-
$5.390 60% OFF

-50%
OFF!

Orbea

Cuadro Orbea Orca OMP 14

EN STOCK $58.769.-
$117.538 50% OFF

-45%
OFF!

SRAM

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

EN STOCK $76.505.-
$139.100 45% OFF

-40%
OFF!

Puños 3T LTD

EN STOCK $1.089.-
$1.815 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

-30%
OFF!

Orbea

Cuadro Orbea Alma OMP 27 5 15

EN STOCK $58.421.-
$83.459 30% OFF

-25%
OFF!

SRAM

Freno a disco hidraulico SRAM GUIDE R delantero

EN STOCK $8.382.-
$11.176 25% OFF

-25%
OFF!

SRAM

Freno a disco hidraulico SRAM GUIDE R trasero

EN STOCK $8.382.-
$11.176 25% OFF

-23%
OFF!

Ruedas 3T Mercurio LTD tubulares CeramicSpeed

EN STOCK $101.620.-
$131.974 23% OFF

Horquilla FOX Float 32 Performance Boost Rod 29

-22%
OFF!

Fox

Horquilla FOX Float 32 Performance Boost Rod 29

EN STOCK $42.907.-
$55.009 22% OFF

-22%
OFF!

Ruedas 3T Mercurio LTD tubulares

EN STOCK $84.502.-
$108.336 22% OFF

-20%
OFF!

Horquilla rígida 3T 29er fibra de carbono

EN STOCK $23.894.-
$29.868 20% OFF

-20%
OFF!

SRAM

Freno a disco hidraulico SRAM GUIDE RSC trasero

EN STOCK $14.010.-
$17.512 20% OFF

-20%
OFF!

SRAM

Freno a disco hidraulico SRAM GUIDE RSC delantero

EN STOCK $14.010.-
$17.512 20% OFF

-20%
OFF!

Manubrio de mountain bike 3T 720 Pro aluminio

EN STOCK $3.302.-
$4.127 20% OFF

-20%
OFF!

Manubrio de mountain bike 3T 720 Team carbono

EN STOCK $6.163.-
$7.704 20% OFF

-20%
OFF!

Manubrio de mountain 3T 720 LTD carbono

EN STOCK $6.825.-
$8.531 20% OFF

Horquilla FOX Float 32 Factory RL 100 Rod 29

-18%
OFF!

Fox

Horquilla FOX Float 32 Factory RL 100 Rod 29

EN STOCK $55.990.-
$68.280 18% OFF

Horquilla FOX Float 32 Factory RL BOOST Rod 29

-18%
OFF!

Fox

Horquilla FOX Float 32 Factory RL BOOST Rod 29

EN STOCK $57.749.-
$70.425 18% OFF

Horquilla FOX Float 32 Factory RL Rod 29

-18%
OFF!

Fox

Horquilla FOX Float 32 Factory RL Rod 29

EN STOCK $57.749.-
$70.425 18% OFF

Shimano

Shimano HG701 HG-X SIL-TEC 11V

EN STOCK $2.367.-

Shimano

Shimano HG601 HG-X SIL-TEC 11V

EN STOCK $1.910.-

Shimano

Pedales Shimano 105 5800

EN STOCK $7.385.-

(default) 13 queries took 48 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` = 'es3nds7srcgfkmu5oq0dpko6r1' 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, 'Houston / United States', '34.229.97.16', '/', 'https://www.thebikecompany.com.ar/productos/transmision.html', '', '', '', '', 8, '2019-03-21 18:20:26', '2019-03-21 18:20:26')	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` <= 51 AND `Categoria`.`rght` >= 84 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` < 84 AND `Categoria`.`lft` > 51 ORDER BY `Categoria`.`lft` asc	16	16	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, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`oferta` DESC, `Articulo`.`destacado` DESC LIMIT 36	36	36	37
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, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)))	1	1	10
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, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC	24	24	0

(default) 13 queries took 48 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` = 'es3nds7srcgfkmu5oq0dpko6r1' 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, 'Houston / United States', '34.229.97.16', '/', 'https://www.thebikecompany.com.ar/productos/transmision.html', '', '', '', '', 8, '2019-03-21 18:20:26', '2019-03-21 18:20:26')

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` <= 51 AND `Categoria`.`rght` >= 84 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` < 84 AND `Categoria`.`lft` > 51 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, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 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, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_cuar_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_quin_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_sex_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 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, 33)) OR (`Articulo`.`categoria_sec_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 33)) OR (`Articulo`.`categoria_ter_id` IN (17, 7, 46, 10, 49, 36, 59, 62, 25, 23, 24, 34, 44, 68, 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

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

Puños 3T Pro

Puños 3T Team

Puños 3T LTD

Ruedas SRAM Roam 50 29er

Ruedas SRAM Roam 40 27 5

Cuadro Orbea Alma OMP 27 5 15

Freno a disco hidraulico SRAM GUIDE R delantero

Freno a disco hidraulico SRAM GUIDE R trasero

Ruedas 3T Mercurio LTD tubulares CeramicSpeed

Horquilla FOX Float 32 Performance Boost Rod 29

Ruedas 3T Mercurio LTD tubulares

Horquilla rígida 3T 29er fibra de carbono

Freno a disco hidraulico SRAM GUIDE RSC trasero

Freno a disco hidraulico SRAM GUIDE RSC delantero

Manubrio de mountain bike 3T 720 Pro aluminio

Manubrio de mountain bike 3T 720 Team carbono

Manubrio de mountain 3T 720 LTD carbono

Horquilla FOX Float 32 Factory RL 100 Rod 29

Horquilla FOX Float 32 Factory RL BOOST Rod 29

Horquilla FOX Float 32 Factory RL 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