Clientes
Ingreso Registrarse Olvidó su contraseña?

Mi carrito - 0 item(s)

0 item(s) en su carrito

Calzas, maillots y guantes.Fox, Magenta.

-25%
OFF!

Gaerne

Casco de ruta o tria aero BBB Tithon

EN STOCK $5.296.-

FOX indumentaria

Orbea Endurance M2

STOCK BAJO $3.289.-
$4.698 30% OFF

-30%
OFF!

Orbea

Casco Orbea Endurance M1

STOCK BAJO $4.289.-
$6.127 30% OFF

-25%
OFF!

Gaerne

Zapatillas Gaerne Rappa

STOCK BAJO $8.993.-
$11.990 25% OFF

-25%
OFF!

Gaerne

Zapatillas Gaerne Laser

STOCK BAJO $6.518.-
$8.690 25% OFF

-25%
OFF!

Gaerne

Zapatillas Gaerne Laser Lady

STOCK BAJO $6.518.-
$8.690 25% OFF

-25%
OFF!

Gaerne

Zapatillas Gaerne Rappa Silver

STOCK BAJO $8.993.-
$11.990 25% OFF

-22%
OFF!

Gaerne

Zapatillas Gaerne Sincro Compo

STOCK BAJO $15.358.-
$19.690 22% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Carbon Sincro

STOCK BAJO $17.517.-
$21.896 20% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Carbon Stilo

STOCK BAJO $17.517.-
$21.896 20% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Carbon Chrono

STOCK BAJO $13.734.-
$17.168 20% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Chrono Compo Carbon

STOCK BAJO $12.015.-
$15.019 20% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Fast Plus

STOCK BAJO $10.297.-
$12.871 20% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Kobra Compo

STOCK BAJO $13.047.-
$16.309 20% OFF

-20%
OFF!

Gaerne

Zapatillas Gaerne Kobra Carbon

STOCK BAJO $15.092.-
$18.865 20% OFF

-10%
OFF!

Bern

Casco Bern Macon

STOCK BAJO $3.423.-
$3.803 10% OFF

-10%
OFF!

Bern

Casco de competición Orbea Odin

STOCK BAJO $6.860.-

Orbea

Zapatillas Gaerne Record

STOCK BAJO $6.687.-

(default) 13 queries took 29 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` = '8t746rjsi42miafqdq8qgqote1' LIMIT 1	0	0	2
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.198.92.22', '/', 'https://www.thebikecompany.com.ar/productos/indumentaria.html', '', '', '', '', 8, '2019-03-23 17:16:20', '2019-03-23 17:16:20')	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 ('indumentaria', 'html') LIMIT 1	1	1	0
6	SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`id` = 11 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` <= 85 AND `Categoria`.`rght` >= 96 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` = 11 LIMIT 1	1	1	0
9	SELECT `Categoria`.`id`, `Categoria`.`leaf` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`rght` < 96 AND `Categoria`.`lft` > 85 ORDER BY `Categoria`.`lft` asc	5	5	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 (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sec_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_ter_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_cuar_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_quin_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sex_id` IN (11, 12, 32, 5, 63, 43))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`oferta` DESC, `Articulo`.`destacado` DESC LIMIT 36	36	36	10
11	SELECT COUNT(*) AS `count` FROM `181024_bike`.`articulos` AS `Articulo` WHERE `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sec_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_ter_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_cuar_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_quin_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sex_id` IN (11, 12, 32, 5, 63, 43)))	1	1	8
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` = (11) ORDER BY `Categoria`.`lft` ASC	5	5	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 (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sec_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_ter_id` IN (11, 12, 32, 5, 63, 43))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC	10	10	9

(default) 13 queries took 29 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` = '8t746rjsi42miafqdq8qgqote1' 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.198.92.22', '/', 'https://www.thebikecompany.com.ar/productos/indumentaria.html', '', '', '', '', 8, '2019-03-23 17:16:20', '2019-03-23 17:16:20')

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 ('indumentaria', 'html') LIMIT 1

SELECT `Categoria`.`lft`, `Categoria`.`rght` FROM `181024_bike`.`categorias` AS `Categoria` WHERE `Categoria`.`id` = 11 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` <= 85 AND `Categoria`.`rght` >= 96 ORDER BY `Categoria`.`lft` asc

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

SELECT `Categoria`.`id`, `Categoria`.`leaf` FROM `181024_bike`.`categorias` AS `Categoria` WHERE 1 = 1 AND `Categoria`.`rght` < 96 AND `Categoria`.`lft` > 85 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 (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sec_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_ter_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_cuar_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_quin_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sex_id` IN (11, 12, 32, 5, 63, 43))) 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 (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sec_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_ter_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_cuar_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_quin_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sex_id` IN (11, 12, 32, 5, 63, 43)))

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` = (11) 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 (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_sec_id` IN (11, 12, 32, 5, 63, 43)) OR (`Articulo`.`categoria_ter_id` IN (11, 12, 32, 5, 63, 43))) AND `Articulo`.`borrado` = 0 AND `Articulo`.`habilitado` = 1 GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC

Calzas, maillots y guantes.Fox, Magenta.

Zapatillas Gaerne Cosmo

Casco Bern Bandita

Casco Bern Bandito

Casco Bern Brentwood

Casco Crazy Safety

Guantes Fox Ripley Dama

Guantes Fox Ripley Gel Dama

Zapatillas Shimano TR500 dama

Calza Fox Ascent

Casco de ruta o tria aero BBB Tithon

Casco FOX Metah

Orbea Endurance M2

Casco Orbea Endurance M1

Zapatillas Gaerne Rappa

Zapatillas Gaerne Laser

Zapatillas Gaerne Laser Lady

Zapatillas Gaerne Rappa Silver

Zapatillas Gaerne Sincro Compo

Zapatillas Gaerne Carbon Sincro

Zapatillas Gaerne Carbon Stilo

Zapatillas Gaerne Carbon Chrono

Zapatillas Gaerne Chrono Compo Carbon

Zapatillas Gaerne Fast Plus

Zapatillas Gaerne Kobra Compo

Zapatillas Gaerne Kobra Carbon

Casco Bern Macon

Casco Bern Watts

Casco de competición Orbea Odin

Casco Orbea Thor

Casco Orbea R10

Casco Orbea R50

Casco Orbea Sport City

Casco Orbea Kids

Casco Orbea Youth

Casco Orbea H10

Zapatillas Gaerne Record