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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Vobler Rapala Jointed Shad Rap, Culoare P, 4cm, 5g
Exclusiv online!

Vobler Rapala Jointed Shad Rap, Culoare P, 4cm, 5g

jsr04 p
Livrare 48-72ore

44,62Lei

TWISTER RELAX STANDARD TS304 3CM 8BUC/PLIC
Exclusiv online!

TWISTER RELAX STANDARD TS304 3CM 8BUC/PLIC

vr34-ts304-b
Livrare 48-72ore

7,10Lei

Shad Relax Stinger Standard SS004, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS004, 5cm, 1g, 8buc/plic

ss2-ss004-b
Livrare imediată!

12,18Lei

Carlige KORDA Kamakura Wide Gape Barbless Nr.8, 10buc/pac

Carlige KORDA Kamakura Wide Gape Barbless Nr.8, 10buc/pac

kam04
Livrare imediată!

45,70Lei

Carlige KORDA Spinner Nr.4, 10buc/pac

Carlige KORDA Spinner Nr.4, 10buc/pac

kspr4
Livrare imediată!

33,90Lei

VOBLER RAPALA G ULTRA LIGHT MINNOW
Exclusiv online!

VOBLER RAPALA G ULTRA LIGHT MINNOW

ulm04 g
Livrare 48-72ore

45,64Lei

Swinger Mikado Bite Indicator, Blue
Exclusiv online!

Swinger Mikado Bite Indicator, Blue

ams04-led-b
Livrare 48-72 ore

72,07Lei

Swinger Mikado Bite Indicator, Green
Exclusiv online!

Swinger Mikado Bite Indicator, Green

ams04-led-g
Livrare 48-72 ore

72,07Lei

VARTEJ MONOLIT CU CARABINA SPIRAL NR 4 JAXON -16%

VARTEJ MONOLIT CU CARABINA SPIRAL NR 4 JAXON

aj-kaa04
Livrare imediată!

8,00Lei(-16%) 6,69Lei

CARLIGE JAXON SUMATO OFFSET HX NR 4
Exclusiv online!

CARLIGE JAXON SUMATO OFFSET HX NR 4

hy-dsa04
Livrare 48-72 ore

8,12Lei

CARLIGE JAXON SUMATO OFFSET CX NR 4

CARLIGE JAXON SUMATO OFFSET CX NR 4

hy-dsc04
Livrare imediată!

4,05Lei

Carlige Korda Kamakura Wide Gape Nr 8 10buc/cutie

Carlige Korda Kamakura Wide Gape Nr 8 10buc/cutie

kam01
Livrare imediată!

45,70Lei

CARLIGE JAXON SUMATO KAIZU NR 4 10/PLIC
Exclusiv online!

CARLIGE JAXON SUMATO KAIZU NR 4 10/PLIC

hy-hsa04
Livrare 48-72 ore

5,07Lei

CARLIG KORDA KAMAKURA CHODDY MICROBARBED NR.6 10BUC/PL

CARLIG KORDA KAMAKURA CHODDY MICROBARBED NR.6 10BUC/PL

kam14
Livrare imediată!

45,70Lei

Carlige Korda Kamakura Wide Gape Nr 6 10buc/cutie

Carlige Korda Kamakura Wide Gape Nr 6 10buc/cutie

kam02
Livrare imediată!

45,70Lei

Carlige Korda Kamakura Wide Gape Nr 4 10buc/cutie

Carlige Korda Kamakura Wide Gape Nr 4 10buc/cutie

kam03
Livrare imediată!

45,70Lei

Carlige KORDA Kamakura Wide Gape Barbless Nr.4, 10buc/pac
Exclusiv online!

Carlige KORDA Kamakura Wide Gape Barbless Nr.4, 10buc/pac

kam06
Livrare 7-14 zile

49,25Lei

Carlige KORDA Kamakura Wide Gape Barbless Nr.6, 10buc/pac
Exclusiv online!

Carlige KORDA Kamakura Wide Gape Barbless Nr.6, 10buc/pac

kam05
Livrare 7-14 zile

49,25Lei

Bride pentru Monturi Korda Krimps, 0.7mm (L), 50buc/cutie

Bride pentru Monturi Korda Krimps, 0.7mm (L), 50buc/cutie

ksk07
Livrare imediată!

30,72Lei

Fir Textil KORDA N-Trap Semi Stiff Coated, Weedy Green, 15lbs, 20m

Fir Textil KORDA N-Trap Semi Stiff Coated, Weedy Green, 15lbs, 20m

knt04
Livrare imediată!

93,10Lei

Afişare 1 - 20 din 26 (2 pagini)
Queries: 15, Total time: 2.489 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = 'a8f57d10cb8ac34d40cc4a7e98'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.159)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.117)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("98625", "2", "1000", "117", "1", "36.880000000000", "1"),("149149", "1", "1000", "48", "1", "5.870000000000", "2"),("174713", "1", "1005", "48", "1", "10.070000000000", "3"),("145013", "2", "1006", "73", "1", "37.770000000000", "4"),("228471", "1", "1006", "73", "1", "28.020000000000", "5"),("10305", "2", "1000", "117", "1", "37.720000000000", "6"),("201275", "2", "1000", "224", "1", "59.560000000000", "7"),("201277", "2", "1000", "224", "1", "59.560000000000", "8"),("17356", "2", "1", "42", "1", "5.530000000000", "9"),("40530", "2", "1000", "42", "1", "6.710000000000", "10"),("50384", "2", "2", "42", "1", "3.350000000000", "11"),("77998", "2", "1004", "73", "1", "37.770000000000", "12"),("65620", "2", "1000", "42", "1", "4.190000000000", "13"),("93966", "2", "16", "73", "1", "37.770000000000", "14"),("77997", "2", "5", "73", "1", "37.770000000000", "15"),("77996", "2", "3", "73", "1", "37.770000000000", "16"),("240922", "2", "1000", "73", "1", "40.700000000000", "17"),("240926", "2", "1000", "73", "1", "40.700000000000", "18"),("21979", "2", "1010", "73", "1", "25.390000000000", "19"),("228463", "2", "1006", "73", "1", "76.940000000000", "20"),("31607", "2", "1000", "42", "1", "8.390000000000", "21"),("39742", "2", "1000", "42", "1", "49.560000000000", "22"),("39768", "2", "1000", "42", "1", "47.880000000000", "23"),("39778", "2", "1000", "42", "1", "45.360000000000", "24"),("142743", "1", "0", "48", "1", "3.361300000000", "25"),("40545", "2", "0", "42", "1", "4.400000000000", "26")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.164)
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:1593
6 (0.278)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.143)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.091)
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.130)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.131)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=10305'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
11 (0.222)
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:1393
12 (0.125)
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:1415
13 (0.087)
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:1180
14 (0.532)
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:1094
15 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37