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


Shad Nomura Mini Real Pluse Red Head Black 5cm 5buc/plic
Exclusiv online!

Shad Nomura Mini Real Pluse Red Head Black 5cm 5buc/plic

f1.nm.73406205
Livrare 24-48 ore

37,95Lei

Shad Nomura Koi Fuxia 5cm 0.97g 10buc -26%
Exclusiv online!

Shad Nomura Koi Fuxia 5cm 0.97g 10buc

f1.nm.71802305
Livrare 24-48 ore

20,31Lei(-26%) 15,12Lei

SHAD NOMURA REAL PULS 7.5CM 2.5G 5BUC/PLIC -28%
Exclusiv online!

SHAD NOMURA REAL PULS 7.5CM 2.5G 5BUC/PLIC

f1.nm.76104807
Livrare 24-48 ore

40,84Lei(-28%) 29,49Lei

SHAD NOMURA ORIGINAL 10CM 7.8G RED TAIL 8BUC/PLIC
Exclusiv online!

SHAD NOMURA ORIGINAL 10CM 7.8G RED TAIL 8BUC/PLIC

f1.nm.76306510
Livrare 24-48 ore

33,49Lei

SHAD NOMURA SOFT MINI 076 5.5CM 2G 5BUC/PLIC -28%
Exclusiv online!

SHAD NOMURA SOFT MINI 076 5.5CM 2G 5BUC/PLIC

f1.nm.73707605
Livrare 24-48 ore

38,23Lei(-28%) 27,66Lei

SHAD LINEAEFFE NOMURA KOI 5CM/0,97G GLITTER GREEN 10BUC/PL -26%
Exclusiv online!

SHAD LINEAEFFE NOMURA KOI 5CM/0,97G GLITTER GREEN 10BUC/PL

f1.nm.71802805
Livrare 24-48 ore

20,31Lei(-26%) 15,12Lei

Shad Nomura Mini Real Pluse Multi Tiger 5cm 5buc/plic
Exclusiv online!

Shad Nomura Mini Real Pluse Multi Tiger 5cm 5buc/plic

f1.nm.73404805
Livrare 24-48 ore

37,95Lei

Shad Nomura Mini Real Pluse Sexy Blue 5cm 5buc/plic
Exclusiv online!

Shad Nomura Mini Real Pluse Sexy Blue 5cm 5buc/plic

f1.nm.73406805
Livrare 24-48 ore

37,95Lei

Shad Nomura Mini Real Pluse Dark Yellow 5cm 5buc/plic
Exclusiv online!

Shad Nomura Mini Real Pluse Dark Yellow 5cm 5buc/plic

f1.nm.73411805
Livrare 24-48 ore

37,95Lei

SHAD NOMURA MINI REAL PULSE 5CM 0.7G TIGER BACK 5BUC/PLIC
Exclusiv online!

SHAD NOMURA MINI REAL PULSE 5CM 0.7G TIGER BACK 5BUC/PLIC

f1.nm.73407605
Livrare 24-48 ore

37,95Lei

SHAD NOMURA MINI 5.5CM 2G 5BUC/PLIC -28%
Exclusiv online!

SHAD NOMURA MINI 5.5CM 2G 5BUC/PLIC

f1.nm.73707005
Livrare 24-48 ore

38,23Lei(-28%) 27,66Lei

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G CHART YELLOW RED
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G CHART YELLOW RED

f1.nm.76301607
Livrare 24-48 ore

34,62Lei

SHAD LINEAEFFE NOMURA ROCKET 7.5CM/2.2G MULTISHAD 8BUC/PL -27%
Exclusiv online!

SHAD LINEAEFFE NOMURA ROCKET 7.5CM/2.2G MULTISHAD 8BUC/PL

f1.nm.70404707
Livrare 24-48 ore

31,04Lei(-27%) 22,62Lei

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G BEE COLOR 10BUC/PL -28%
Exclusiv online!

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G BEE COLOR 10BUC/PL

f1.nm.70000107
Livrare 24-48 ore

36,60Lei(-28%) 26,53Lei

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G CHART GREEN 10BUC/PL -27%
Exclusiv online!

SHAD LINEAEFFE NOMURA GATOR 7,5CM/2,5G CHART GREEN 10BUC/PL

f1.nm.70001407
Livrare 24-48 ore

35,60Lei(-27%) 25,82Lei

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G PURPLE SILVER 8BUC/PL
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G PURPLE SILVER 8BUC/PL

f1.nm.76305907
Livrare 24-48 ore

34,62Lei

SHAD LINEAEFFE NOMURA ORIGINAL 10CM/7,8G PURPLE SILVER 6BUC/PL
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL 10CM/7,8G PURPLE SILVER 6BUC/PL

f1.nm.76305910
Livrare 24-48 ore

33,49Lei

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G RED TAIL 8BUC/PL
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G RED TAIL 8BUC/PL

f1.nm.76306507
Livrare 24-48 ore

34,62Lei

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G TRANSPARENT BLACK 8BUC/PL
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL 7CM/3G TRANSPARENT BLACK 8BUC/PL

f1.nm.76307707
Livrare 24-48 ore

34,62Lei

SHAD LINEAEFFE NOMURA ORIGINAL 10CM/7,8G TRANSPARENT BL 6BUC/PL
Exclusiv online!

SHAD LINEAEFFE NOMURA ORIGINAL 10CM/7,8G TRANSPARENT BL 6BUC/PL

f1.nm.76307710
Livrare 24-48 ore

33,49Lei

Afişare 1 - 20 din 33 (2 pagini)
Queries: 11, Total time: 1.944 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '7af9c3bd02da838177e4345bf3'
/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.145)
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.158)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("109586", "2", "1000", "554", "1", "31.890000000000", "1"),("118881", "2", "1000", "554", "1", "12.710000000000", "2"),("118408", "2", "1000", "554", "1", "24.780000000000", "3"),("115082", "2", "1000", "554", "1", "28.140000000000", "4"),("144425", "2", "1000", "554", "1", "23.240000000000", "5"),("42829", "2", "1000", "554", "1", "12.710000000000", "6"),("109585", "2", "1000", "554", "1", "31.890000000000", "7"),("109587", "2", "1000", "554", "1", "31.890000000000", "8"),("109588", "2", "1000", "554", "1", "31.890000000000", "9"),("115092", "2", "1000", "554", "1", "31.890000000000", "10"),("118407", "2", "1000", "554", "1", "23.240000000000", "11"),("36954", "2", "1000", "163", "1", "29.090000000000", "12"),("84528", "2", "1000", "163", "1", "19.010000000000", "13"),("36942", "2", "1000", "163", "1", "22.290000000000", "14"),("36943", "2", "1000", "163", "1", "21.700000000000", "15"),("36959", "2", "1000", "163", "1", "29.090000000000", "16"),("36961", "2", "1000", "163", "1", "28.140000000000", "17"),("36962", "2", "1000", "163", "1", "29.090000000000", "18"),("36963", "2", "1000", "163", "1", "29.090000000000", "19"),("36968", "2", "1000", "163", "1", "28.140000000000", "20"),("42830", "2", "1000", "163", "1", "12.710000000000", "21"),("84523", "2", "1000", "163", "1", "29.440000000000", "22"),("84527", "2", "1000", "163", "1", "22.290000000000", "23"),("36956", "2", "1000", "163", "1", "28.140000000000", "24"),("84524", "2", "1000", "163", "1", "31.510000000000", "25"),("169240", "2", "1000", "115", "1", "22.610000000000", "26"),("169229", "2", "1000", "115", "1", "33.530000000000", "27"),("169241", "2", "1000", "115", "1", "22.610000000000", "28"),("169254", "2", "1000", "115", "1", "27.650000000000", "29"),("142997", "1", "4", "611", "1", "20.920000000000", "30"),("36950", "2", "0", "163", "1", "18.620000000000", "31"),("42828", "2", "0", "163", "1", "18.250000000000", "32"),("36946", "2", "0", "163", "1", "20.940000000000", "33")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.138)
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.227)
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.242)
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
8 (0.133)
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
9 (0.106)
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
10 (0.480)
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
11 (0.120)
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