0
0 item(s) en su carrito

Mochilas de Ataque - de 30 a 50 litros

Naturehike Bolso Ultra Liviano Comprimible
Naturehike

Naturehike Bolso Ultra Liviano Comprimible

$2.133.-  |  $1.885.-
Marmot Rock Gear Hauler Nuevo
Marmot

Marmot Rock Gear Hauler

$7.843.-  |  $6.931.-
Patagonia Lightweight Black Hole Duffel 45L
Patagonia

Patagonia Lightweight Black Hole Duffel 45L

$7.981.-  |  $7.053.-
Edelweiss Transport Bag T45
Edelweiss

Edelweiss Transport Bag T45

$9.732.-  |  $8.601.-
Patagonia Black Hole Duffel 45L
Patagonia

Patagonia Black Hole Duffel 45L

$9.920.-  |  $8.767.-
Edelrid Gear Bag - Bolso porta equipo M 40 L
Edelrid

Edelrid Gear Bag - Bolso porta equipo M 40 L

$10.008.-  |  $8.845.-
Osprey Hikelite 32L Nuevo
Osprey

Osprey Hikelite 32L

$10.138.-  |  $8.960.-
Naturehike Trekking 45L
Naturehike

Naturehike Trekking 45L

$11.390.-  |  $10.067.-
Altus Aventura 32L
Altus

Altus Aventura 32L

$11.599.-  |  $10.251.-
Lowe Alpine Peak Ascent 32
Lowe Alpine

Lowe Alpine Peak Ascent 32

$12.144.-  |  $10.733.-
Edelrid Canyoneer Bag 45L
Edelrid

Edelrid Canyoneer Bag 45L

$12.355.-  |  $10.919.-
Altus Aventura 40L
Altus

Altus Aventura 40L

$12.617.-  |  $11.151.-
Osprey Talon 44
Osprey

Osprey Talon 44

$13.702.-  |  $12.110.-
Altus Fitz Roy 45 L
Altus

Altus Fitz Roy 45 L

$14.013.-  |  $12.385.-
Lowe Alpine Air Zone Trail 25
Lowe Alpine

Lowe Alpine Air Zone Trail 25

$14.969.-  |  $13.229.-
Osprey Rook 50L
Osprey

Osprey Rook 50L

$15.224.-  |  $13.455.-
Osprey Farpoint 40
Osprey

Osprey Farpoint 40

$15.932.-  |  $14.080.-
Altus Khumbu 40L
Altus

Altus Khumbu 40L

$19.055.-  |  $16.840.-
Altus Lhotse 50L
Altus

Altus Lhotse 50L

$19.621.-  |  $17.341.-
Lowe Alpine Air Zone Trek+ 35:45
Lowe Alpine

Lowe Alpine Air Zone Trek+ 35:45

$23.159.-  |  $20.467.-
Petzl Transport 45L
Petzl

Petzl Transport 45L

No disponible
Petzl Bucket 35L
Petzl

Petzl Bucket 35L

No disponible
Osprey Talon 33
Osprey

Osprey Talon 33

No disponible
Lowe Alpine Peak Ascent 42
Lowe Alpine

Lowe Alpine Peak Ascent 42

No disponible
 
(default) 4 queries took 152 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `190717_naka`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '4l6nv3v7ijlt25acg4ugprpfro' LIMIT 1002
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` = (97)) OR (`Articulo`.`categoria_sec_id` = (97)) OR (`Articulo`.`categoria_ter_id` = (97)) OR (`Articulo`.`categoria_cuar_id` = (97))) ORDER BY `Articulo`.`stock_id` ASC, `Articulo`.`precio_real` ASC, `Articulo`.`destacado` DESC LIMIT 24242441
3SELECT COUNT(*) AS `count` FROM `190717_naka`.`articulos` AS `Articulo` WHERE `Articulo`.`habilitado` = 1 AND ((`Articulo`.`categoria_id` = (97)) OR (`Articulo`.`categoria_sec_id` = (97)) OR (`Articulo`.`categoria_ter_id` = (97)) OR (`Articulo`.`categoria_cuar_id` = (97)))1143
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` = (97)) OR (`Articulo`.`categoria_sec_id` = (97)) OR (`Articulo`.`categoria_ter_id` = (97)) OR (`Articulo`.`categoria_cuar_id` = (97))) GROUP BY `Articulo`.`marca_id` ORDER BY `Marca`.`nombre` ASC9966