articole de pescuit Gama variata de produse

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

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport 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 Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Cicada Berkley Powerblade, Tiger Prawn, 4.4cm, 7g

Cicada Berkley Powerblade, Tiger Prawn, 4.4cm, 7g

1595288
Livrare imediată!

33,96Lei

Cicada Berkley Powerblade, Wagasaki, 4.4cm, 7g

Cicada Berkley Powerblade, Wagasaki, 4.4cm, 7g

1595285
Livrare imediată!

33,96Lei

Cicada Jaxon Holo Reflex Vibro Micro 0C 3g
Exclusiv online!

Cicada Jaxon Holo Reflex Vibro Micro 0C 3g

bw-hjk00c
Livrare 48-72 ore

9,50Lei

Cicada Jaxon Holo Reflex Vibro Slim 1B 7g
Exclusiv online!

Cicada Jaxon Holo Reflex Vibro Slim 1B 7g

bw-hjl01b
Livrare 48-72 ore

11,00Lei

Cicada Jaxon Holo Reflex Vibro Slim 1E 7g
Exclusiv online!

Cicada Jaxon Holo Reflex Vibro Slim 1E 7g

bw-hjl01e
Livrare 48-72 ore

11,00Lei

Cicada Jaxon Holo Reflex Vibro Slim 1F 7g
Exclusiv online!

Cicada Jaxon Holo Reflex Vibro Slim 1F 7g

bw-hjl01f
Livrare 48-72 ore

11,00Lei

Cicada Konger Viber Blue Ridge 002, 6g
Exclusiv online!

Cicada Konger Viber Blue Ridge 002, 6g

130606381301002
Livrare 48-72 ore

28,68Lei

Cicada Konger Viber Golden Perch 007, 6g
Exclusiv online!

Cicada Konger Viber Golden Perch 007, 6g

130606381301007
Livrare 48-72 ore

28,68Lei

Cicada Siliconica Percamax Grim Classic 3C, 5.5cm, 13g

Cicada Siliconica Percamax Grim Classic 3C, 5.5cm, 13g

dream-m13-3c
Livrare imediată!

28,00Lei

Cicada Siliconica Percamax Grim Classic BGO, 4.4cm, 8g

Cicada Siliconica Percamax Grim Classic BGO, 4.4cm, 8g

dream-m8-bgo
Livrare imediată!

28,00Lei

Cicada Siliconica Percamax Grim Classic BGR, 4.4cm, 8g
Exclusiv online!

Cicada Siliconica Percamax Grim Classic BGR, 4.4cm, 8g

dream-m8-bgr
Livrare 48-72ore

28,00Lei

Cicada Siliconica Percamax Grim Classic BGR, 5.7cm, 16gr, 1buc/pac

Cicada Siliconica Percamax Grim Classic BGR, 5.7cm, 16gr, 1buc/pac

dream-m16-bgr
Livrare imediată!

28,00Lei

Cicada Siliconica Percamax Grim Classic BGR, 7.5cm, 40gr, 1buc/pac

Cicada Siliconica Percamax Grim Classic BGR, 7.5cm, 40gr, 1buc/pac

dream-m40-bgr
Livrare imediată!

30,00Lei

Cicada Siliconica Percamax Grim Classic BLW, 7.5cm, 30gr, 1buc/pac
Exclusiv online!

Cicada Siliconica Percamax Grim Classic BLW, 7.5cm, 30gr, 1buc/pac

dream-m30-blw
Livrare 48-72ore

28,00Lei

Cicada Siliconica Percamax Grim Classic BLW, 7.5cm, 40gr, 1buc/pac

Cicada Siliconica Percamax Grim Classic BLW, 7.5cm, 40gr, 1buc/pac

dream-m40-blw
Livrare imediată!

30,00Lei

Cicada Siliconica Percamax Grim Classic O, 5.7cm, 16g
Exclusiv online!

Cicada Siliconica Percamax Grim Classic O, 5.7cm, 16g

dream-m16-o
Livrare 48-72ore

28,00Lei

Cicada Siliconica Percamax Grim Classic PHW, 9.5cm, 80g
Exclusiv online!

Cicada Siliconica Percamax Grim Classic PHW, 9.5cm, 80g

dream-m80-phw
Livrare 48-72ore

39,00Lei

Cicada Siliconica Percamax Grim Classic YO, 6.5cm, 20g

Cicada Siliconica Percamax Grim Classic YO, 6.5cm, 20g

dream-m20-yo
Livrare imediată!

28,00Lei

Cicada Siliconica Percamax Grim Classic YW, 7.5cm, 30gr, 1buc/pac

Cicada Siliconica Percamax Grim Classic YW, 7.5cm, 30gr, 1buc/pac

dream-m30-yw
Livrare imediată!

28,00Lei

Cicada Berkley Powerblade, Ayu, 4.4cm, 7g

Cicada Berkley Powerblade, Ayu, 4.4cm, 7g

1595290
Livrare imediată!

33,96Lei

Afişare 501 - 520 din 838 (42 pagini)
Queries: 14, Total time: 31.266 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = 'a16fa1a7984397d05ad14330ee'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.431)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+cicade' IN BOOLEAN MODE)) 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:737
4 (0.205)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (3.193)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
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 match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.655)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
11 (0.113)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
12 (0.217)
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:1035
13 (7.604)
SELECT COUNT(1) 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:949
14 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38