Gama variata de produse

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

Transport Gratuit

Comenzile peste 400 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 - Foarfeci

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

-26%

Foarfeca ENERGOTEAM CUDA TITANIUM BONDED SNIPS 23cm

80950825

Stoc epuizat

79,00Lei(-26%) 58,31Lei

Foarfeca Victorinox Uz casnic 15.3cm, Lama 6.5cm, Metal, Argintiu

8.1016.13

Stoc epuizat

67,90Lei

-31%

Forfecuta Retractabila Rapala 9cm

rcdrrls

Stoc epuizat

59,00Lei(-31%) 40,46Lei

-54%

RETRACTOR CU UNGHIERA DAIWA

a.dzcci

Stoc epuizat

101,58Lei(-54%) 46,91Lei

CLESTE PENTRU FIR TEXTIL PRO FL BRAID SNIPS

64-65672

Stoc epuizat

32,90Lei

-29%

Foarfeca Tip Cleste DAM Effzett Effzett Side Cutter

425090002

Stoc epuizat

28,71Lei(-29%) 20,38Lei

-32%

Foarfeca Pentru Fire Carp Expert 127mm

79591567

Stoc epuizat

7,00Lei(-32%) 4,76Lei

-41%

Foarfeca Pentru Fir Textil Solar Serrated Braid Scissors

sss

Stoc epuizat

49,94Lei(-41%) 29,61Lei

Foarfeca Bucatarie Victorinox Professional Poultry Shears, 25 cm, Inox, Negru

7.6344

Stoc epuizat

220,90Lei

Foarfeca Victorinox Pentru Uz Casnic si Hobby, 19cm, Manere Negre

8.0987.19

Stoc epuizat

67,90Lei

Foarfeca Victorinox Sweden Uz Casnic, 15.3cm, Lama 6.5cm, Metal, Argintiu

8.1016.15

Stoc epuizat

74,90Lei

-23%

FOARFECA POINTED STRATEGY 10 CM PENTRU FIR TEXTIL

008013-00201-00000

Stoc epuizat

74,51Lei(-23%) 57,26Lei

-40%

Unghiera Rapture Multi-Pliers Line Clipper

101-47-740

Stoc epuizat

25,89Lei(-40%) 15,47Lei

-31%

Combo dispozitiv ascutit carlige + dispozitiv taiat fir textil + debavurator jiguri Rapala

rclp-1

Stoc epuizat

79,00Lei(-31%) 54,74Lei

-28%

Foarfeca Multifunctionala tip Cleste Pole Position Smart Multi Scissors

008036-00300-00000

Stoc epuizat

69,00Lei(-28%) 49,56Lei

-47%

Foarfeca Browning Taiat Viermi Blade Worm Scissors

6531002

Stoc epuizat

49,28Lei(-47%) 26,36Lei

Exclusiv online!

FOARFECA RAME MAVER

m134

Livrare 48-72 ore

32,90Lei

Exclusiv online!

Foarfeca Victorinox Pentru Unghii, 9.3cm, Otel, Argintiu

8.1681.09

Livrare 48-72ore

100,90Lei

Foarfeca Carp Expert SI Degorjor + Toc

79591571

Livrare imediată!

20,90Lei

Exclusiv online!

FOARFECA COLMIC TRIPLA TRITON

st796

Livrare 48-72 ore

57,00Lei

Afişare 161 - 180 din 224 (12 pagini)

Queries: 18, Total time: 3.411 ms [By time] [By id] [By file]

1 (0.132)

SELECT data
FROM `oc_session`
WHERE session_id = '3ae63c515560c2c2092e985034'

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

2 (0.082)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.096)

SELECT *
FROM oc_url_alias
WHERE keyword = 'search'

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

4 (0.132)

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

5 (0.996)

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("73227", "2", "1000", "464", "1", "46.970000000000", "1"),("180354", "2", "1000", "464", "1", "17.560000000000", "2"),("180353", "2", "1000", "680", "1", "46.970000000000", "3"),("9623", "2", "1002", "160", "1", "34.150000000000", "4"),("11784", "2", "1001", "115", "1", "15.130000000000", "5"),("108150", "2", "1000", "119", "1", "30.220000000000", "6"),("106949", "1", "1000", "50", "1", "48.660000000000", "7"),("165984", "1", "1000", "224", "1", "227.650000000000", "8"),("246880", "1", "1005", "809", "1", "13.450000000000", "9"),("246879", "1", "1004", "809", "1", "10.080000000000", "10"),("246629", "2", "1000", "168", "1", "27.710000000000", "11"),("14464", "2", "1001", "115", "1", "29.410000000000", "12"),("65728", "2", "1014", "73", "1", "34.160000000000", "13"),("5838", "2", "1013", "42", "1", "10.920000000000", "14"),("65864", "2", "1004", "423", "1", "10.920000000000", "15"),("14465", "2", "1002", "115", "1", "20.170000000000", "16"),("148315", "1", "1002", "357", "1", "22.660000000000", "17"),("110662", "2", "1002", "20", "1", "22.790000000000", "18"),("164817", "2", "1001", "18", "1", "10.680000000000", "19"),("16924", "2", "1000", "42", "1", "21.850000000000", "20"),("108151", "2", "1000", "119", "1", "17.030000000000", "21"),("149715", "2", "1000", "20", "1", "57.190000000000", "22"),("150731", "1", "2", "54", "1", "38.660000000000", "23"),("7250", "2", "1", "115", "1", "81.510000000000", "24"),("246881", "1", "1004", "809", "1", "33.610000000000", "25"),("236978", "1", "1009", "44", "1", "26.050000000000", "26"),("96661", "2", "1004", "368", "1", "22.660000000000", "27"),("16923", "2", "1001", "42", "1", "28.570000000000", "28"),("80551", "2", "1000", "115", "1", "32.770000000000", "29"),("205771", "1", "1000", "476", "1", "29.370000000000", "30"),("179058", "1", "1000", "507", "1", "12.610000000000", "31"),("115380", "2", "1000", "20", "1", "9.920000000000", "32"),("66619", "2", "1000", "109", "1", "37.730000000000", "33"),("34106", "2", "6", "287", "1", "10.080000000000", "34"),("237171", "1", "3", "469", "1", "13.360000000000", "35"),("189973", "1", "1", "528", "1", "7.560000000000", "36"),("92585", "2", "1011", "11", "1", "18.050000000000", "37"),("9768", "2", "1009", "42", "1", "11.760000000000", "38"),("181229", "1", "1007", "13", "1", "11.680000000000", "39"),("123469", "2", "1006", "423", "1", "13.950000000000", "40"),("214063", "1", "1006", "13", "1", "13.360000000000", "41"),("149171", "2", "1006", "11", "1", "24.750000000000", "42"),("31662", "2", "1005", "42", "1", "16.810000000000", "43"),("127649", "1", "1004", "73", "1", "21.440000000000", "44"),("236632", "1", "1004", "715", "1", "25.210000000000", "45"),("40686", "2", "1002", "45", "1", "18.400000000000", "46"),("168351", "1", "1000", "603", "1", "52.940000000000", "47"),("201919", "2", "1000", "11", "1", "24.750000000000", "48"),("220554", "1", "1000", "749", "1", "110.000000000000", "49"),("229498", "1", "1000", "20", "1", "65.590000000000", "50"),("229500", "1", "1000", "20", "1", "40.910000000000", "51"),("177920", "-100", "17", "570", "1", "50.340000000000", "52"),("112400", "2", "3", "85", "1", "25.210000000000", "53"),("97074", "2", "2", "98", "1", "55.460000000000", "54"),("10296", "2", "1000", "117", "1", "32.770000000000", "55"),("33249", "2", "1000", "117", "1", "24.370000000000", "56"),("101016", "2", "1000", "117", "1", "68.910000000000", "57"),("148821", "2", "2", "54", "1", "50.420000000000", "58"),("226776", "1", "1019", "13", "1", "17.560000000000", "59"),("225863", "1", "1006", "370", "1", "28.210000000000", "60"),("230382", "1", "1002", "285", "1", "16.230000000000", "61"),("119366", "2", "1001", "105", "1", "41.180000000000", "62"),("104125", "2", "1000", "42", "1", "19.330000000000", "63"),("174371", "1", "1000", "656", "1", "50.980000000000", "64"),("168346", "1", "1000", "603", "1", "52.940000000000", "65"),("230383", "1", "1000", "285", "1", "18.870000000000", "66"),("232936", "1", "1000", "727", "1", "42.510000000000", "67"),("9170", "2", "1000", "104", "1", "12.190000000000", "68"),("108706", "2", "1000", "75", "1", "25.130000000000", "69"),("108707", "2", "1000", "75", "1", "31.010000000000", "70"),("219652", "1", "1000", "749", "1", "208.320000000000", "71"),("70064", "2", "1000", "292", "1", "67.980000000000", "72"),("207493", "1", "1000", "224", "1", "15.880000000000", "73"),("96233", "2", "4", "467", "1", "12.770000000000", "74"),("57118", "2", "2", "124", "1", "43.610000000000", "75"),("16915", "2", "1002", "42", "1", "19.330000000000", "76"),("66322", "2", "1000", "115", "1", "26.050000000000", "77"),("101008", "2", "1000", "117", "1", "16.810000000000", "78"),("231151", "2", "1000", "723", "1", "75.630000000000", "79"),("231150", "2", "1000", "723", "1", "52.940000000000", "80"),("115378", "2", "1003", "85", "1", "31.930000000000", "81"),("123475", "2", "1003", "540", "1", "33.280000000000", "82"),("108705", "2", "1002", "75", "1", "18.400000000000", "83"),("119364", "2", "1001", "105", "1", "49.580000000000", "84"),("153577", "1", "1000", "389", "1", "15.870000000000", "85"),("238602", "1", "1000", "203", "1", "64.710000000000", "86"),("166947", "1", "1000", "423", "1", "20.170000000000", "87"),("187821", "1", "1000", "75", "1", "15.040000000000", "88"),("229495", "1", "1000", "20", "1", "59.390000000000", "89"),("229496", "1", "1000", "20", "1", "57.360000000000", "90"),("229497", "1", "1000", "20", "1", "66.650000000000", "91"),("229499", "1", "1000", "20", "1", "50.200000000000", "92"),("66156", "2", "1000", "67", "1", "20.080000000000", "93"),("211837", "1", "8", "370", "1", "14.220000000000", "94"),("63515", "2", "3", "96", "1", "18.490000000000", "95"),("175228", "1", "1", "528", "1", "67.140000000000", "96"),("29054", "2", "1023", "168", "1", "32.110000000000", "97"),("156377", "2", "1000", "629", "1", "22.610000000000", "98"),("205285", "1", "1000", "224", "1", "39.410000000000", "99"),("4642", "2", "10", "95", "1", "50.410000000000", "100"),("105219", "1", "1013", "360", "1", "26.440000000000", "101"),("103578", "1", "1009", "401", "1", "17.560000000000", "102"),("166946", "1", "1006", "423", "1", "26.890000000000", "103"),("123473", "2", "1004", "362", "1", "14.710000000000", "104"),("135163", "1", "1002", "193", "1", "10.920000000000", "105"),("217915", "1", "1002", "476", "1", "38.340000000000", "106"),("146821", "1", "1001", "58", "1", "55.380000000000", "107"),("165192", "1", "1000", "15", "1", "82.990000000000", "108"),("165193", "1", "1000", "15", "1", "82.990000000000", "109"),("241811", "1", "1000", "725", "1", "51.340000000000", "110"),("103579", "1", "1000", "401", "1", "11.260000000000", "111"),("237589", "1", "1000", "20", "1", "41.380000000000", "112"),("81643", "2", "1", "67", "1", "23.530000000000", "113"),("213157", "2", "1004", "749", "1", "52.650000000000", "114"),("108769", "2", "1000", "50", "1", "48.660000000000", "115"),("202503", "1", "1000", "224", "1", "62.940000000000", "116"),("164834", "1", "1011", "455", "1", "64.250000000000", "117"),("111404", "2", "1004", "484", "1", "37.820000000000", "118"),("123471", "2", "1000", "484", "1", "13.450000000000", "119"),("231823", "1", "1000", "224", "1", "38.150000000000", "120"),("9169", "2", "1000", "104", "1", "33.540000000000", "121"),("29040", "2", "1022", "168", "1", "52.910000000000", "122"),("218229", "1", "1000", "224", "1", "33.300000000000", "123"),("108704", "2", "1000", "75", "1", "17.560000000000", "124"),("202501", "1", "1000", "224", "1", "38.570000000000", "125"),("230332", "1", "1005", "294", "1", "37.780000000000", "126"),("165189", "1", "1000", "15", "1", "75.500000000000", "127"),("165191", "1", "1000", "15", "1", "75.500000000000", "128"),("165247", "1", "1000", "354", "1", "23.450000000000", "129"),("178481", "1", "9", "625", "1", "22.690000000000", "130"),("178480", "1", "2", "625", "1", "10.080000000000", "131"),("135165", "1", "2", "193", "1", "16.810000000000", "132"),("212895", "1", "1001", "755", "1", "44.800000000000", "133"),("214061", "1", "1010", "13", "1", "54.540000000000", "134"),("165200", "2", "1000", "15", "1", "38.060000000000", "135"),("165201", "2", "1000", "15", "1", "38.060000000000", "136"),("154377", "1", "1003", "224", "1", "31.010000000000", "137"),("62541", "2", "1", "189", "1", "29.330000000000", "138"),("165583", "1", "1001", "193", "1", "33.610000000000", "139"),("145567", "2", "0", "469", "1", "5.530000000000", "140"),("106952", "1", "0", "469", "1", "9.160000000000", "141"),("110729", "2", "0", "12", "1", "5.840000000000", "142"),("219680", "1", "0", "749", "1", "162.940000000000", "143"),("116913", "1", "0", "280", "1", "3.060000000000", "144"),("33003", "2", "0", "20", "1", "19.660000000000", "145"),("235253", "1", "0", "59", "1", "28.560000000000", "146"),("220552", "1", "0", "749", "1", "101.600000000000", "147"),("62537", "2", "0", "24", "1", "12.000000000000", "148"),("156379", "1", "0", "629", "1", "24.700000000000", "149"),("219651", "1", "0", "749", "1", "72.180000000000", "150"),("151311", "1", "0", "121", "1", "11.760000000000", "151"),("37762", "2", "0", "47", "1", "39.210000000000", "152"),("48840", "2", "0", "11", "1", "14.930000000000", "153"),("68108", "2", "0", "47", "1", "24.590000000000", "154"),("114515", "2", "0", "27", "1", "5.530000000000", "155"),("231149", "1", "0", "723", "1", "47.550000000000", "156"),("64244", "2", "0", "358", "1", "34.540000000000", "157"),("119194", "2", "0", "105", "1", "8.500000000000", "158"),("107878", "1", "0", "469", "1", "22.680000000000", "159"),("26544", "2", "0", "75", "1", "19.000000000000", "160"),("114848", "2", "0", "24", "1", "49.000000000000", "161"),("220555", "1", "0", "749", "1", "57.060000000000", "162"),("96218", "2", "0", "117", "1", "34.000000000000", "163"),("22179", "2", "0", "11", "1", "39.420000000000", "164"),("214355", "1", "0", "13", "1", "27.650000000000", "165"),("35179", "2", "0", "124", "1", "17.130000000000", "166"),("103577", "1", "0", "27", "1", "4.000000000000", "167"),("86841", "2", "0", "173", "1", "24.880000000000", "168"),("219645", "1", "0", "749", "1", "185.630000000000", "169"),("219684", "1", "0", "749", "1", "57.060000000000", "170"),("219697", "1", "0", "749", "1", "62.940000000000", "171"),("41230", "2", "0", "71", "1", "48.120000000000", "172"),("177695", "1", "0", "469", "1", "13.000000000000", "173"),("10175", "2", "0", "117", "1", "46.000000000000", "174"),("165491", "1", "0", "523", "1", "41.650000000000", "175"),("70709", "2", "0", "222", "1", "22.150000000000", "176"),("27934", "2", "1000", "49", "1", "27.650000000000", "177"),("219725", "1", "1000", "749", "1", "84.790000000000", "178"),("114516", "2", "1002", "27", "1", "17.560000000000", "179"),("14466", "2", "1000", "115", "1", "47.900000000000", "180"),("50709", "2", "1000", "42", "1", "17.650000000000", "181"),("223575", "2", "1000", "768", "1", "134.370000000000", "182"),("50710", "2", "1001", "42", "1", "20.170000000000", "183"),("196709", "10", "1004", "360", "1", "56.690000000000", "184"),("154397", "10", "1001", "224", "1", "33.530000000000", "185"),("229020", "10", "1000", "423", "1", "21.850000000000", "186"),("101005", "2", "1000", "117", "1", "74.790000000000", "187"),("96843", "2", "3", "528", "1", "23.520000000000", "188"),("65647", "2", "1004", "12", "1", "26.970000000000", "189"),("233811", "2", "1003", "353", "1", "83.160000000000", "190"),("26547", "2", "1000", "75", "1", "31.850000000000", "191"),("219901", "1", "1000", "749", "1", "2452.020000000000", "192"),("165582", "2", "6", "324", "1", "44.450000000000", "193"),("65648", "2", "1", "12", "1", "26.970000000000", "194"),("229332", "1", "1000", "540", "1", "67.140000000000", "195"),("229333", "1", "1000", "540", "1", "87.390000000000", "196"),("222652", "1", "1000", "370", "1", "18.260000000000", "197"),("229471", "1", "1000", "540", "1", "27.820000000000", "198"),("229481", "1", "1000", "540", "1", "43.700000000000", "199"),("222651", "1", "1000", "370", "1", "16.570000000000", "200"),("164976", "2", "1000", "455", "1", "68.790000000000", "201"),("145705", "2", "3", "45", "1", "20.170000000000", "202"),("189985", "1", "2", "528", "1", "20.170000000000", "203"),("154807", "1", "1001", "224", "1", "25.130000000000", "204"),("222654", "1", "1003", "370", "1", "18.260000000000", "205"),("230237", "1", "1000", "285", "1", "18.870000000000", "206"),("229526", "1", "1000", "540", "1", "54.620000000000", "207"),("229527", "1", "1000", "540", "1", "29.500000000000", "208"),("238576", "1", "1000", "85", "1", "147.900000000000", "209"),("222653", "1", "1000", "370", "1", "16.570000000000", "210"),("229479", "1", "1000", "540", "1", "43.700000000000", "211"),("130435", "2", "4", "75", "1", "21.850000000000", "212"),("163807", "2", "1004", "13", "1", "20.920000000000", "213"),("70104", "2", "1000", "441", "1", "67.140000000000", "214"),("97043", "2", "1", "287", "1", "16.810000000000", "215"),("181231", "2", "1016", "13", "1", "25.130000000000", "216"),("246539", "2", "1000", "389", "1", "41.280000000000", "217"),("31669", "2", "1000", "42", "1", "61.340000000000", "218"),("31670", "2", "1000", "42", "1", "65.550000000000", "219"),("56572", "2", "8", "287", "1", "22.690000000000", "220"),("59574", "2", "1", "287", "1", "29.410000000000", "221"),("11511", "10", "0", "49", "1", "32.000000000000", "222"),("220689", "1", "0", "749", "1", "866.300000000000", "223"),("114853", "2", "0", "24", "1", "51.000000000000", "224")

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

6 (0.150)

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

7 (0.731)

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 160, 20

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

8 (0.126)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'