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

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Activator Senzor XXL Capsuna 250ml

snz99691

Livrare imediată!

10,00Lei

Activator Senzor XXL Miere 250ml

snz99689

Livrare imediată!

10,00Lei

Activator Senzor XXL Usturoi 250ml

snz99688

Livrare imediată!

10,00Lei

Activator Senzor XXL Faina Peste 250ml

snz99690

Livrare imediată!

10,00Lei

Aditiv Senzor Green Betain 250ml

snz99694

Livrare imediată!

13,00Lei

Aditiv Senzor Cascaval 250ml

snz99695

Livrare imediată!

13,00Lei

Exclusiv online!

Fir monofilament Zebco Trophy Pike Green 0.40mm 12.7kg 250m

2003040

Livrare 7-14 zile

26,78Lei

Activator Select Baits Meat Fish 250ml

sc0125

Livrare imediată!

56,00Lei

Exclusiv online!

Fir monofilament Zebco Trophy Carp Dark Camo 0.40mm 12.7kg 250m

2001040

Livrare 7-14 zile

26,78Lei

Exclusiv online!

Pop-Up, Mainline, Balanced, Wafter, High, Leakage, Pineapple, 18mm, 250ml, a0.m.m23080, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Mainline, Mainline

a0.m.m23080

Livrare 24-48 ore

51,74Lei

Exclusiv online!

Pop-Up, Mainline, Balanced, Wafter, Banoffe, 12mm, 250ml, a0.m.m23073, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Mainline, Mainline

a0.m.m23073

Livrare 24-48 ore

51,74Lei

-25%

Fir Zebco Fluo Manie 0.30mm 250m 6.9kg

2008030

Livrare imediată!

26,78Lei(-25%) 20,10Lei

Fir Textil Filfishing TITAN CATFISH CAMO X 8 BRAID 0.50 MM 250M 56KG

fil7997

Livrare imediată!

92,00Lei

Aditiv lichid 220 Baits Supreme Scopex & Betaina - 250ml

5278214834772

Livrare imediată!

30,00Lei

Aditiv lichid 220 Baits Supreme Usturoi & Betaina - 250ml

6278214595108

Livrare imediată!

30,00Lei

Aditiv Lichid 220 Baits Supreme, Sweet Corn, 250ml

3278214657441

Livrare imediată!

24,55Lei

Aditiv lichid 220 Baits Supreme Choco & Orange - 250ml

7278219400819

Livrare imediată!

30,00Lei

Aditiv lichid 220 Baits Supreme Squid & Tutti Frutti - 250ml

5278216848241

Livrare imediată!

30,00Lei

Fir Monofilament Katran Crypton Symbios 0.234mm, 4.33kg, 1250m

2500000214110

Livrare imediată!

168,00Lei

Aditiv, Cpk, Baza, Groundbait,, Crap, &, Caras,, 250ml, 1000811, Aditivi Lichizi / Arome / Dip-uri, Aditivi Lichizi / Arome / Dip-uri CPK, CPK

1000811

Livrare imediată!

10,00Lei

Afişare 1 - 20 din 391 (20 pagini)

Queries: 11, Total time: 1,025.859 ms [By time] [By id] [By file]

1 (0.152)

SELECT data
FROM `oc_session`
WHERE session_id = 'a2c1f582b46876b9c916b6b312'

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

2 (0.134)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.083)

SELECT `trigger`, `action`
FROM oc_event

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

4 (484.318)

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 = '3' AND (pd.tag LIKE "%250m%") 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

5 (360.892)

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 = '3' AND (pd.tag LIKE "%250m%") 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 0, 20

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

6 (176.228)

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 = '3' AND (pd.tag LIKE "%250m%") 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

7 (0.186)

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

8 (3.486)

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

9 (0.149)

SELECT *
FROM oc_platforma_promovari

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

10 (0.112)

SELECT *
FROM oc_platforma_promovari

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

11 (0.119)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' 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

Produse ce potrivesc criteriilor de căutare