0
0 item(s) en su carrito

Cintas express

 

Fixe Express Alambre-Nylon 18cm Nuevo
Fixe

Fixe Express Alambre-Nylon 18cm

$1.435.-  |  $1.268.-
Fixe Cinta Exprés 180mm
Fixe

Fixe Cinta Exprés 180mm

$1.588.-  |  $1.404.-
Edelweiss Top Evo 12cm
Edelweiss

Edelweiss Top Evo 12cm

$1.998.-  |  $1.765.-
Edelrid Slash Wire Express
Edelrid

Edelrid Slash Wire Express

$2.002.-  |  $1.769.-
Edelweiss Top Evo 17cm
Edelweiss

Edelweiss Top Evo 17cm

$2.016.-  |  $1.782.-
Altus Pegaso Dyneema 11cm
Altus

Altus Pegaso Dyneema 11cm

$2.086.-  |  $1.844.-
Edelweiss Sonic 12cm Dyneema - Recto Alambre
Edelweiss

Edelweiss Sonic 12cm Dyneema - Recto Alambre

$2.090.-  |  $1.847.-
Edelrid Slash Set Express 10cm
Edelrid

Edelrid Slash Set Express 10cm

$2.335.-  |  $2.064.-
Edelrid Pure Slim Wire Express -15%
OFF!
Edelrid

Edelrid Pure Slim Wire Express

$2.102.-
$2.473  15% OFF
Edelrid Slash Set Express 18cm
Edelrid

Edelrid Slash Set Express 18cm

$2.421.-  |  $2.140.-
Edelrid Pure Slim Express -15%
OFF!
Edelrid

Edelrid Pure Slim Express

$2.213.-
$2.603  15% OFF
Edelrid Nineteen Express 10cm -15%
OFF!
Edelrid

Edelrid Nineteen Express 10cm

$2.655.-
$3.123  15% OFF
Edelrid Mission Express
Edelrid

Edelrid Mission Express

$3.003.-  |  $2.654.-
Edelrid Mission Express 11cm
Edelrid

Edelrid Mission Express 11cm

$3.003.-  |  $2.654.-
Petzl Ange Finesse S+L 17cm
Petzl

Petzl Ange Finesse S+L 17cm

$3.047.-  |  $2.692.-
Petzl Ange Finesse L+L 17cm
Petzl

Petzl Ange Finesse L+L 17cm

$3.051.-  |  $2.697.-
Edelrid Nineteen Express 18cm -15%
OFF!
Edelrid

Edelrid Nineteen Express 18cm

$2.763.-
$3.251  15% OFF
Edelrid Mission Set Express 25cm
Edelrid

Edelrid Mission Set Express 25cm

$3.127.-  |  $2.763.-
Petzl Spirit Express Nuevo
Petzl

Petzl Spirit Express

$3.317.-  |  $2.932.-
Edelrid Mission Express 60cm
Edelrid

Edelrid Mission Express 60cm

$3.522.-  |  $3.113.-
Edelrid Bulletproof Cintas Express 18cm Nuevo
Edelrid

Edelrid Bulletproof Cintas Express 18cm

$3.754.-  |  $3.318.-
Edelrid Bulletproof Cintas Express 12cm Nuevo
Edelrid

Edelrid Bulletproof Cintas Express 12cm

$3.754.-  |  $3.318.-
 
(default) 4 queries took 142 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `190717_naka`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '0dlv9chu4guenijg8qihtu93pi' LIMIT 1000
2SELECT `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`.`sku`, `Articulo`.`slug`, `Articulo`.`nombre`, `Articulo`.`precio`, `Articulo`.`precio_real`, `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`.`pedido_minimo_dist`, `Articulo`.`stock`, `Articulo`.`stock_dist`, `Articulo`.`img1_list`, `Articulo`.`img2_list`, `Articulo`.`colores`, `Articulo`.`score`, `Articulo`.`valoraciones`, `Articulo`.`distribucion`, `Articulo`.`peso`, `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`, `Articulo`.`thumb6`, `Articulo`.`small_thumb6`, `Articulo`.`thumb7`, `Articulo`.`small_thumb7`, `Articulo`.`thumb8`, `Articulo`.`small_thumb8`, `Articulo`.`thumb9`, `Articulo`.`small_thumb9`, `Articulo`.`thumb10`, `Articulo`.`small_thumb10`, `Articulo`.`thumb11`, `Articulo`.`small_thumb11`, `Articulo`.`thumb12`, `Articulo`.`small_thumb12`, `Articulo`.`thumb13`, `Articulo`.`small_thumb13`, `Articulo`.`thumb14`, `Articulo`.`small_thumb14`, `Articulo`.`thumb15`, `Articulo`.`small_thumb15` FROM `190717_naka`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_sec_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_ter_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_cuar_id` IN (185, 114, 115, 229))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`precio_real` ASC, `Articulo`.`destacado` DESC LIMIT 24242453
3SELECT COUNT(*) AS `count` FROM `190717_naka`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_sec_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_ter_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_cuar_id` IN (185, 114, 115, 229)))1142
4SELECT 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 `190717_naka`.`articulos` AS `Articulo` LEFT JOIN `190717_naka`.`marcas` AS `Marca` ON (`Articulo`.`marca_id` = `Marca`.`id`) WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_sec_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_ter_id` IN (185, 114, 115, 229)) OR (`Articulo`.`categoria_cuar_id` IN (185, 114, 115, 229))) GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC5547