Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare - Savage

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Tricou Kumu Origins Tee, Marimea M

tso102

Livrare imediată!

131,99Lei

Tricou Kumu Rising Sun, Marimea S

tsrs101

Livrare imediată!

131,99Lei

Tricou Kumu Rising Sun, Marimea XXL

tsrs105

Livrare imediată!

131,99Lei

Tricou Kumu Take Flight, Marimea M

tstf102

Livrare imediată!

130,00Lei

Exclusiv online!

Tricou Zeck Catfish 23 T-Shirt, Marimea XXL

80805281547

Livrare 48-72 ore

157,02Lei

Exclusiv online!

Vesta Treesco Percussion Wild Boar Republic, Kaki, Marimea 2XL

bt.1294.2xl

Livrare 24-48 ore

277,72Lei

Hanorac, Kumu, Deception,, Marimea, L, hddc103, Hanorace, Hanorace Kumu, Hanorace Kumu, Kumu

hddc103

Livrare imediată!

330,00Lei

Hanorac Kumu Make Your Own Luck, Marimea L

hdmyol103

Livrare imediată!

300,00Lei

Exclusiv online!

Hanorac, Mikado, Sicario,, Grey,, Marimea, L, UMB-02-XL, Hanorace, Hanorace Mikado, Hanorace Mikado, Mikado

umb-02-xl

Livrare 48-72 ore

226,00Lei

Exclusiv online!

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea L

80305170226

Livrare 48-72 ore

263,53Lei

Exclusiv online!

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea M

80305170225

Livrare 48-72 ore

263,53Lei

Exclusiv online!

Jacheta Ploaie Zeck Rain Jachet Catfish, Gri, Marimea XL

80305170227

Livrare 48-72 ore

263,53Lei

Exclusiv online!

Pantaloni Scurti Garbolino Squadra, Marimea M

80430gomcm2057-m

Livrare 48-72 ore

196,03Lei

Exclusiv online!

Pantaloni Scurti Zeck Summer Shorts, Marimea L

80405281496

Livrare 48-72 ore

215,79Lei

Exclusiv online!

Pantaloni Scurti Zeck Summer Shorts, Marimea M

80405281495

Livrare 48-72 ore

215,79Lei

Exclusiv online!

Pantaloni Scurti Zeck Summer Shorts, Marimea XL

80405281497

Livrare 48-72 ore

215,79Lei

Exclusiv online!

Pantaloni Scurti Zeck Summer Shorts, Marimea XXL

80405281498

Livrare 48-72 ore

215,79Lei

Exclusiv online!

Pantalonii Verney-Carron Ibex Pro, Kaki, Marimea 52

lvc.phpn020.52

Livrare 24-48 ore

578,24Lei

Exclusiv online!

Tricou Korda Birdsnest Tee Burgundy, Marimea M

a8.kcl944

Livrare 24-48 ore

138,88Lei

Tricou Kumu Origins Tee, Marimea XL

tso104

Livrare imediată!

131,99Lei

Afişare 141 - 160 din 555 (28 pagini)

Queries: 12, Total time: 958.718 ms [By time] [By id] [By file]

1 (0.096)

SELECT data
FROM `oc_session`
WHERE session_id = '6e85f79d93788938793d00fccd'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.129)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.093)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (0.113)

SELECT *
FROM oc_url_alias
WHERE keyword = 'search'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

5 (406.462)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%marimea%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555

6 (360.866)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%marimea%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 140, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

7 (185.777)

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%marimea%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:697

8 (0.225)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066

9 (4.586)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911

10 (0.147)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

11 (0.102)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

12 (0.122)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare - Savage

Produse ce potrivesc criteriilor de căutare