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


BAZZY BUG COLMIC HERAKLES 8cm Watermelon Red Flakes -23%
Exclusiv online!

BAZZY BUG COLMIC HERAKLES 8cm Watermelon Red Flakes

arhkbaz01
Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

BAZZY BUG COLMIC HERAKLES 8cm Black Red Flakes -23%
Exclusiv online!

BAZZY BUG COLMIC HERAKLES 8cm Black Red Flakes

arhkbaz11
Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

CAVE CRAW COLMIC HERAKLES 9.6cm Watermelon Red Flakes -23%
Exclusiv online!

CAVE CRAW COLMIC HERAKLES 9.6cm Watermelon Red Flakes

arhkcav01
Livrare 48-72 ore

23,90Lei(-23%) 18,30Lei

Lingura Oscilanta Colmic Herakles Ammer 1.1gr Orange Red Flakes
Exclusiv online!

Lingura Oscilanta Colmic Herakles Ammer 1.1gr Orange Red Flakes

arhkamf18
Livrare 48-72 ore

25,30Lei

GRUB COLMIC HERAKLES MATO WORM 16.5cm Pumpkin Purple Flakes -23%
Exclusiv online!

GRUB COLMIC HERAKLES MATO WORM 16.5cm Pumpkin Purple Flakes

arhkmat26
Livrare 48-72 ore

22,91Lei(-23%) 17,57Lei

GRUB COLMIC HERAKLES LEFTAIL WORM 12cm Watermelon Red Flakes
Exclusiv online!

GRUB COLMIC HERAKLES LEFTAIL WORM 12cm Watermelon Red Flakes

arhklew01
Livrare 48-72 ore

39,54Lei

GRUB COLMIC HERAKLES LEFTAIL WORM 12cm Black Red Flakes
Exclusiv online!

GRUB COLMIC HERAKLES LEFTAIL WORM 12cm Black Red Flakes

arhklew11
Livrare 48-72 ore

39,54Lei

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Orange Red Flakes -22%
Exclusiv online!

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Orange Red Flakes

arhkll18
Livrare 48-72 ore

18,90Lei(-22%) 14,73Lei

Vobler Colmic Herakles Popper Area Kiro Ghost Blue Flakes, 2.7cm, 1.8g
Exclusiv online!

Vobler Colmic Herakles Popper Area Kiro Ghost Blue Flakes, 2.7cm, 1.8g

arhkki2740
Livrare 48-72 ore

58,85Lei

Creatura Lucky John Bug Orange Gold Flakes 6.3cm 8buc/plic
Exclusiv online!

Creatura Lucky John Bug Orange Gold Flakes 6.3cm 8buc/plic

140169-s68
Livrare 48-72ore

21,34Lei

Creature Lucky John Bug Orange Gold Flakes 8.9cm 6buc/plic
Exclusiv online!

Creature Lucky John Bug Orange Gold Flakes 8.9cm 6buc/plic

140170-s68
Livrare 48-72ore

21,34Lei

Aditiv Praf Feeder Bait Cerealier Pentru Nada Din Porumb, Corn Flakes, 400g
Exclusiv online!

Aditiv Praf Feeder Bait Cerealier Pentru Nada Din Porumb, Corn Flakes, 400g

fb34-6
Livrare 48-72 ore

25,44Lei

CAVE CRAW COLMIC HERAKLES 9.6cm Black Red Flakes -23%

CAVE CRAW COLMIC HERAKLES 9.6cm Black Red Flakes

arhkcav11
Stoc epuizat

23,90Lei(-23%) 18,30Lei

GRUB COLMIC HERAKLES MATO WORM 16.5cm Watermelon Red Flakes -24%

GRUB COLMIC HERAKLES MATO WORM 16.5cm Watermelon Red Flakes

arhkmat01
Stoc epuizat

22,00Lei(-24%) 16,66Lei

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA KITE 1.2gr Orange Red Flakes -24%

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA KITE 1.2gr Orange Red Flakes

arhklo18
Stoc epuizat

10,60Lei(-24%) 8,02Lei

Shad Lucky John Nayada 5cm -S21 (All Star Flakes) 9buc/plic -31%

Shad Lucky John Nayada 5cm -S21 (All Star Flakes) 9buc/plic

140154-s21
Stoc epuizat

20,00Lei(-31%) 13,72Lei

Shad Lucky John Baby Rockfish, All Star Flakes, 3.5cm, 20buc/plic -25%

Shad Lucky John Baby Rockfish, All Star Flakes, 3.5cm, 20buc/plic

140149-s21
Stoc epuizat

19,00Lei(-25%) 14,23Lei

Creatura Zeck Edward 7.1cm Smoke Blue Flake 8buc/plic
Exclusiv online!

Creatura Zeck Edward 7.1cm Smoke Blue Flake 8buc/plic

131905220407
Livrare 48-72 ore

36,32Lei

Vierme Colmic Herakles Tremors 6.8cm Smoked Gold Black Flake -19%
Exclusiv online!

Vierme Colmic Herakles Tremors 6.8cm Smoked Gold Black Flake

arhkit05
Livrare 48-72 ore

12,90Lei(-19%) 10,45Lei

Creatura Owner Getnet Juster Hog 58mm 05 Cinnamon Blue Flake
Exclusiv online!

Creatura Owner Getnet Juster Hog 58mm 05 Cinnamon Blue Flake

13013782916-05
Livrare 48-72 ore

34,59Lei

Afişare 1 - 20 din 494 (25 pagini)
Queries: 17, Total time: 8.638 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = '9739bf31bf4c4d2416543347f2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.148)
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 (1.276)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("52990", "2", "1000", "115", "1", "13.930000000000", "1"),("52993", "2", "1000", "115", "1", "13.930000000000", "2"),("52997", "2", "1000", "115", "1", "15.120000000000", "3"),("85953", "2", "1000", "115", "1", "20.910000000000", "4"),("52988", "2", "1000", "115", "1", "14.520000000000", "5"),("53017", "2", "1000", "115", "1", "32.680000000000", "6"),("53019", "2", "1000", "115", "1", "32.680000000000", "7"),("52819", "2", "1000", "115", "1", "12.170000000000", "8"),("169174", "2", "1000", "115", "1", "48.640000000000", "9"),("134604", "2", "1000", "193", "1", "17.640000000000", "10"),("134743", "2", "1000", "193", "1", "17.640000000000", "11"),("201709", "1", "1000", "487", "1", "22.920000000000", "12"),("52999", "2", "0", "115", "1", "15.120000000000", "13"),("52985", "2", "0", "115", "1", "13.770000000000", "14"),("52798", "2", "0", "115", "1", "6.630000000000", "15"),("75978", "2", "0", "193", "1", "11.340000000000", "16"),("167089", "2", "0", "193", "1", "11.760000000000", "17"),("170783", "1", "1000", "656", "1", "30.020000000000", "18"),("93551", "2", "1000", "115", "1", "8.640000000000", "19"),("103319", "2", "1000", "15", "1", "28.590000000000", "20"),("182125", "1", "1000", "656", "1", "31.790000000000", "21"),("221748", "2", "1000", "459", "1", "64.610000000000", "22"),("188561", "1", "1002", "656", "1", "4.190000000000", "23"),("53261", "2", "1000", "115", "1", "8.050000000000", "24"),("153045", "2", "1000", "150", "1", "20.930000000000", "25"),("153047", "2", "1000", "150", "1", "20.930000000000", "26"),("212079", "2", "1000", "11", "1", "39.190000000000", "27"),("188565", "1", "1", "656", "1", "3.340000000000", "28"),("103326", "2", "1000", "15", "1", "28.590000000000", "29"),("103332", "2", "1000", "15", "1", "28.590000000000", "30"),("167394", "2", "1000", "483", "1", "28.470000000000", "31"),("153019", "2", "1000", "150", "1", "20.930000000000", "32"),("153035", "2", "1000", "150", "1", "20.930000000000", "33"),("134231", "2", "1000", "150", "1", "30.620000000000", "34"),("238782", "2", "1000", "656", "1", "30.690000000000", "35"),("216403", "2", "3", "102", "1", "11.750000000000", "36"),("115662", "2", "1", "483", "1", "28.470000000000", "37"),("115664", "2", "1", "483", "1", "28.470000000000", "38"),("87736", "2", "1002", "310", "1", "18.900000000000", "39"),("87745", "2", "1001", "310", "1", "18.890000000000", "40"),("172071", "1", "1001", "658", "1", "45.740000000000", "41"),("153011", "2", "1000", "150", "1", "21.550000000000", "42"),("153013", "2", "1000", "150", "1", "21.550000000000", "43"),("128505", "2", "1000", "150", "1", "19.630000000000", "44"),("231935", "1", "1000", "224", "1", "35.200000000000", "45"),("87744", "2", "1008", "310", "1", "18.890000000000", "46"),("87752", "2", "1006", "310", "1", "18.890000000000", "47"),("87756", "2", "1006", "310", "1", "18.890000000000", "48"),("87725", "2", "1005", "310", "1", "18.890000000000", "49"),("87730", "2", "1005", "310", "1", "18.900000000000", "50"),("87732", "2", "1005", "310", "1", "18.900000000000", "51"),("87739", "2", "1005", "310", "1", "18.890000000000", "52"),("87743", "2", "1005", "310", "1", "18.890000000000", "53"),("87765", "2", "1004", "310", "1", "18.890000000000", "54"),("87737", "2", "1003", "310", "1", "18.900000000000", "55"),("87748", "2", "1002", "310", "1", "18.900000000000", "56"),("87754", "2", "1001", "310", "1", "18.900000000000", "57"),("87757", "2", "1001", "310", "1", "18.890000000000", "58"),("87749", "2", "1000", "310", "1", "16.230000000000", "59"),("87755", "2", "1000", "310", "1", "16.230000000000", "60"),("87740", "2", "6", "310", "1", "14.190000000000", "61"),("87727", "2", "5", "310", "1", "18.900000000000", "62"),("87729", "2", "4", "310", "1", "18.890000000000", "63"),("87734", "2", "3", "310", "1", "18.900000000000", "64"),("87746", "2", "3", "310", "1", "18.900000000000", "65"),("87753", "2", "3", "310", "1", "18.900000000000", "66"),("87728", "2", "2", "310", "1", "18.900000000000", "67"),("87741", "2", "2", "310", "1", "18.890000000000", "68"),("77283", "2", "1000", "279", "1", "51.170000000000", "69"),("87747", "2", "1006", "310", "1", "18.900000000000", "70"),("87726", "2", "1005", "310", "1", "16.230000000000", "71"),("87738", "2", "1005", "310", "1", "18.900000000000", "72"),("87763", "2", "1003", "310", "1", "18.900000000000", "73"),("87733", "2", "4", "310", "1", "18.900000000000", "74"),("87758", "2", "1", "310", "1", "18.890000000000", "75"),("172070", "1", "1002", "658", "1", "45.740000000000", "76"),("46529", "2", "1001", "340", "1", "24.360000000000", "77"),("94558", "2", "1000", "288", "1", "9.900000000000", "78"),("223502", "2", "1000", "459", "1", "30.160000000000", "79"),("223521", "2", "1000", "459", "1", "40.240000000000", "80"),("223534", "2", "1000", "459", "1", "30.160000000000", "81"),("223552", "2", "1000", "459", "1", "30.160000000000", "82"),("182737", "1", "1000", "701", "1", "40.240000000000", "83"),("164832", "1", "4", "593", "1", "28.020000000000", "84"),("87742", "2", "1004", "310", "1", "18.900000000000", "85"),("161857", "1", "1002", "310", "1", "30.400000000000", "86"),("66464", "2", "1000", "279", "1", "51.170000000000", "87"),("77255", "2", "1000", "279", "1", "51.170000000000", "88"),("77268", "2", "1000", "279", "1", "51.170000000000", "89"),("77269", "2", "1000", "279", "1", "51.170000000000", "90"),("77280", "2", "1000", "279", "1", "51.170000000000", "91"),("77306", "2", "1000", "279", "1", "51.170000000000", "92"),("77318", "2", "1000", "279", "1", "51.170000000000", "93"),("77279", "2", "1", "279", "1", "25.120000000000", "94"),("150157", "1", "1002", "310", "1", "18.890000000000", "95"),("150153", "1", "3", "310", "1", "35.200000000000", "96"),("134245", "2", "1005", "150", "1", "23.660000000000", "97"),("223489", "2", "1000", "459", "1", "43.600000000000", "98"),("106199", "1", "1007", "310", "1", "18.890000000000", "99"),("150173", "1", "1005", "310", "1", "18.890000000000", "100"),("150179", "1", "1005", "310", "1", "18.890000000000", "101"),("150167", "1", "1004", "310", "1", "18.890000000000", "102"),("150177", "1", "1004", "310", "1", "18.890000000000", "103"),("150171", "1", "1003", "310", "1", "18.890000000000", "104"),("150161", "1", "1002", "310", "1", "18.890000000000", "105"),("150165", "1", "1002", "310", "1", "18.890000000000", "106"),("150175", "1", "1002", "310", "1", "18.890000000000", "107"),("150159", "1", "1001", "310", "1", "18.890000000000", "108"),("106200", "1", "1000", "310", "1", "19.230000000000", "109"),("161861", "1", "1000", "310", "1", "18.890000000000", "110"),("150163", "1", "7", "310", "1", "14.190000000000", "111"),("150151", "1", "2", "310", "1", "35.200000000000", "112"),("150147", "1", "1", "310", "1", "35.200000000000", "113"),("150149", "1", "1", "310", "1", "35.200000000000", "114"),("161855", "1", "1000", "310", "1", "35.200000000000", "115"),("29040", "2", "1021", "168", "1", "53.740000000000", "116"),("66465", "2", "1000", "279", "1", "51.170000000000", "117"),("66466", "2", "1000", "279", "1", "51.170000000000", "118"),("77264", "2", "1000", "279", "1", "51.170000000000", "119"),("77271", "2", "1000", "279", "1", "51.170000000000", "120"),("184013", "1", "1000", "701", "1", "36.030000000000", "121"),("106198", "1", "1000", "310", "1", "19.230000000000", "122"),("182931", "1", "1002", "701", "1", "30.240000000000", "123"),("183113", "1", "1002", "701", "1", "34.440000000000", "124"),("183229", "1", "1000", "701", "1", "36.880000000000", "125"),("184003", "1", "1000", "701", "1", "36.030000000000", "126"),("229026", "1", "1000", "117", "1", "36.030000000000", "127"),("122635", "2", "1001", "67", "1", "15.360000000000", "128"),("188015", "1", "1000", "54", "1", "61.330000000000", "129"),("188017", "1", "1000", "54", "1", "61.330000000000", "130"),("168826", "2", "14", "54", "1", "6.440000000000", "131"),("182943", "1", "1002", "701", "1", "30.240000000000", "132"),("182951", "1", "1002", "701", "1", "31.080000000000", "133"),("182985", "1", "1002", "701", "1", "34.440000000000", "134"),("182991", "1", "1002", "701", "1", "34.440000000000", "135"),("183129", "1", "1002", "701", "1", "34.440000000000", "136"),("182933", "1", "1001", "701", "1", "30.240000000000", "137"),("183167", "1", "1000", "701", "1", "36.880000000000", "138"),("183221", "1", "1000", "701", "1", "36.880000000000", "139"),("183975", "1", "1000", "701", "1", "36.030000000000", "140"),("246173", "1", "1000", "224", "1", "28.470000000000", "141"),("182929", "1", "2", "701", "1", "30.240000000000", "142"),("183947", "1", "2", "701", "1", "35.280000000000", "143"),("183963", "1", "2", "701", "1", "35.280000000000", "144"),("188019", "1", "1000", "54", "1", "61.330000000000", "145"),("182949", "1", "1002", "701", "1", "31.080000000000", "146"),("182953", "1", "1002", "701", "1", "31.080000000000", "147"),("182963", "1", "1002", "701", "1", "31.080000000000", "148"),("182987", "1", "1002", "701", "1", "34.440000000000", "149"),("182999", "1", "1002", "701", "1", "34.440000000000", "150"),("183169", "1", "1000", "701", "1", "36.880000000000", "151"),("183219", "1", "1000", "701", "1", "36.880000000000", "152"),("184027", "1", "2", "701", "1", "35.280000000000", "153"),("245047", "1", "1000", "54", "1", "61.330000000000", "154"),("245050", "1", "1000", "54", "1", "61.330000000000", "155"),("245055", "1", "1000", "54", "1", "74.780000000000", "156"),("245061", "1", "1000", "54", "1", "74.780000000000", "157"),("245304", "2", "1000", "54", "1", "145.360000000000", "158"),("245312", "2", "1000", "54", "1", "336.120000000000", "159"),("245320", "2", "1000", "54", "1", "369.740000000000", "160"),("245328", "2", "1000", "54", "1", "336.120000000000", "161"),("245332", "2", "1000", "54", "1", "285.700000000000", "162"),("245334", "2", "1000", "54", "1", "285.700000000000", "163"),("245454", "2", "1000", "54", "1", "145.360000000000", "164"),("245455", "2", "1000", "54", "1", "145.360000000000", "165"),("245460", "2", "1000", "54", "1", "336.120000000000", "166"),("245469", "2", "1000", "54", "1", "369.740000000000", "167"),("245470", "2", "1000", "54", "1", "369.740000000000", "168"),("245475", "2", "1000", "54", "1", "336.120000000000", "169"),("245476", "2", "1000", "54", "1", "336.120000000000", "170"),("86485", "4", "5", "469", "1", "5.790000000000", "171"),("86483", "4", "3", "469", "1", "5.790000000000", "172"),("86481", "4", "1", "469", "1", "5.790000000000", "173"),("183189", "1", "1000", "701", "1", "36.880000000000", "174"),("183193", "1", "1000", "701", "1", "36.880000000000", "175"),("182971", "1", "2", "701", "1", "31.080000000000", "176"),("182969", "1", "1", "701", "1", "31.080000000000", "177"),("245052", "1", "1000", "54", "1", "61.330000000000", "178"),("245058", "1", "1000", "54", "1", "74.780000000000", "179"),("245059", "1", "1000", "54", "1", "74.780000000000", "180"),("245063", "1", "1000", "54", "1", "74.780000000000", "181"),("245299", "2", "1000", "54", "1", "145.360000000000", "182"),("245300", "2", "1000", "54", "1", "145.360000000000", "183"),("245301", "2", "1000", "54", "1", "145.360000000000", "184"),("245302", "2", "1000", "54", "1", "145.360000000000", "185"),("245303", "2", "1000", "54", "1", "145.360000000000", "186"),("245306", "2", "1000", "54", "1", "336.120000000000", "187"),("245307", "2", "1000", "54", "1", "336.120000000000", "188"),("245308", "2", "1000", "54", "1", "336.120000000000", "189"),("245309", "2", "1000", "54", "1", "336.120000000000", "190"),("245310", "2", "1000", "54", "1", "336.120000000000", "191"),("245311", "2", "1000", "54", "1", "336.120000000000", "192"),("245313", "2", "1000", "54", "1", "345.520000000000", "193"),("245314", "2", "1000", "54", "1", "369.740000000000", "194"),("245316", "2", "1000", "54", "1", "369.740000000000", "195"),("245317", "2", "1000", "54", "1", "369.740000000000", "196"),("245318", "2", "1000", "54", "1", "369.740000000000", "197"),("245319", "2", "1000", "54", "1", "369.740000000000", "198"),("245321", "2", "1000", "54", "1", "360.510000000000", "199"),("245322", "2", "1000", "54", "1", "336.120000000000", "200"),("245324", "2", "1000", "54", "1", "336.120000000000", "201"),("245326", "2", "1000", "54", "1", "336.120000000000", "202"),("245327", "2", "1000", "54", "1", "336.120000000000", "203"),("245329", "2", "1000", "54", "1", "360.510000000000", "204"),("245330", "2", "1000", "54", "1", "285.700000000000", "205"),("245331", "2", "1000", "54", "1", "285.700000000000", "206"),("245333", "2", "1000", "54", "1", "285.700000000000", "207"),("245453", "2", "1000", "54", "1", "180.510000000000", "208"),("245456", "2", "1000", "54", "1", "145.360000000000", "209"),("245459", "2", "1000", "54", "1", "345.520000000000", "210"),("245464", "2", "1000", "54", "1", "336.120000000000", "211"),("245467", "2", "1000", "54", "1", "360.510000000000", "212"),("245472", "2", "1000", "54", "1", "369.740000000000", "213"),("245477", "2", "1000", "54", "1", "336.120000000000", "214"),("249095", "1", "1000", "54", "1", "61.330000000000", "215"),("249099", "1", "1000", "54", "1", "74.780000000000", "216"),("183019", "1", "1002", "701", "1", "34.440000000000", "217"),("149947", "10", "1000", "315", "1", "211.220000000000", "218"),("170199", "2", "4", "191", "1", "41.170000000000", "219"),("245064", "1", "1000", "54", "1", "74.780000000000", "220"),("249096", "1", "1000", "54", "1", "61.330000000000", "221"),("249097", "1", "1000", "54", "1", "61.330000000000", "222"),("249098", "1", "1000", "54", "1", "61.330000000000", "223"),("249100", "1", "1000", "54", "1", "74.780000000000", "224"),("249102", "1", "1000", "54", "1", "74.780000000000", "225"),("249103", "1", "1000", "54", "1", "74.780000000000", "226"),("172788", "2", "1001", "105", "1", "30.240000000000", "227"),("172789", "2", "1001", "105", "1", "29.400000000000", "228"),("95224", "2", "1000", "58", "1", "333.510000000000", "229"),("95223", "2", "1", "58", "1", "236.030000000000", "230"),("215839", "2", "1002", "459", "1", "61.330000000000", "231"),("199713", "1", "1001", "58", "1", "286.540000000000", "232"),("66971", "2", "1000", "58", "1", "304.110000000000", "233"),("112246", "1", "1000", "85", "1", "22.650000000000", "234"),("119131", "2", "1000", "105", "1", "19.230000000000", "235"),("226819", "2", "1000", "459", "1", "67.970000000000", "236"),("236003", "2", "1000", "224", "1", "81.410000000000", "237"),("236004", "2", "1000", "224", "1", "83.930000000000", "238"),("236147", "2", "1000", "54", "1", "87.300000000000", "239"),("236148", "2", "1000", "54", "1", "76.370000000000", "240"),("236149", "2", "1000", "54", "1", "84.780000000000", "241"),("243089", "1", "1000", "54", "1", "195.790000000000", "242"),("243091", "1", "1000", "54", "1", "1313.430000000000", "243"),("243093", "1", "1000", "54", "1", "98.310000000000", "244"),("243095", "1", "1000", "54", "1", "195.790000000000", "245"),("243097", "1", "1000", "54", "1", "1313.430000000000", "246"),("243099", "1", "1000", "54", "1", "98.310000000000", "247"),("243100", "1", "1000", "54", "1", "98.310000000000", "248"),("243102", "1", "1000", "54", "1", "1313.430000000000", "249"),("243104", "1", "1000", "54", "1", "195.790000000000", "250"),("243107", "1", "1000", "54", "1", "1313.430000000000", "251"),("243108", "1", "1000", "54", "1", "195.790000000000", "252"),("243112", "1", "1000", "54", "1", "98.310000000000", "253"),("243114", "1", "1000", "54", "1", "1313.430000000000", "254"),("243117", "1", "1000", "54", "1", "195.790000000000", "255"),("243121", "1", "1000", "54", "1", "1313.430000000000", "256"),("243126", "1", "1000", "54", "1", "195.790000000000", "257"),("243129", "1", "1000", "54", "1", "195.790000000000", "258"),("243132", "1", "1000", "54", "1", "1313.430000000000", "259"),("243133", "1", "1000", "54", "1", "98.310000000000", "260"),("243139", "1", "1000", "54", "1", "1313.430000000000", "261"),("243142", "1", "1000", "54", "1", "195.790000000000", "262"),("215993", "2", "2", "459", "1", "58.810000000000", "263"),("216101", "1", "1000", "749", "1", "102.420000000000", "264"),("148841", "2", "1006", "54", "1", "72.260000000000", "265"),("237990", "2", "1004", "54", "1", "72.260000000000", "266"),("148839", "2", "1003", "54", "1", "72.260000000000", "267"),("150743", "2", "1001", "58", "1", "252.090000000000", "268"),("168836", "2", "1000", "54", "1", "89.060000000000", "269"),("154109", "1", "1000", "575", "1", "25.950000000000", "270"),("156749", "1", "1000", "575", "1", "25.950000000000", "271"),("115196", "2", "1000", "85", "1", "22.650000000000", "272"),("119091", "2", "1000", "105", "1", "22.600000000000", "273"),("233641", "2", "1000", "285", "1", "15.920000000000", "274"),("197245", "2", "1000", "122", "1", "178.140000000000", "275"),("197261", "2", "1000", "122", "1", "178.140000000000", "276"),("237469", "2", "1000", "11", "1", "60.850000000000", "277"),("237471", "2", "1000", "11", "1", "60.850000000000", "278"),("237991", "2", "4", "54", "1", "140.320000000000", "279"),("238012", "2", "1004", "54", "1", "72.260000000000", "280"),("238011", "2", "1002", "54", "1", "124.360000000000", "281"),("170601", "1", "1001", "58", "1", "353.770000000000", "282"),("170602", "1", "1001", "58", "1", "446.210000000000", "283"),("95431", "2", "1000", "58", "1", "336.880000000000", "284"),("170603", "1", "1000", "58", "1", "552.000000000000", "285"),("154089", "1", "1000", "575", "1", "29.310000000000", "286"),("154257", "1", "1000", "575", "1", "29.310000000000", "287"),("123765", "1", "1000", "575", "1", "29.310000000000", "288"),("118758", "2", "1000", "105", "1", "30.160000000000", "289"),("119074", "2", "1000", "105", "1", "15.020000000000", "290"),("229784", "1", "1000", "117", "1", "36.030000000000", "291"),("229790", "1", "1000", "117", "1", "36.030000000000", "292"),("230793", "1", "1000", "117", "1", "36.030000000000", "293"),("170836", "2", "1000", "119", "1", "329.160000000000", "294"),("26139", "2", "1", "62", "1", "19.250000000000", "295"),("42734", "2", "1000", "105", "1", "22.600000000000", "296"),("123395", "1", "1000", "575", "1", "29.310000000000", "297"),("123543", "1", "1000", "575", "1", "29.310000000000", "298"),("123597", "1", "1000", "575", "1", "29.310000000000", "299"),("158717", "1", "1000", "123", "1", "27.820000000000", "300"),("174483", "2", "1000", "185", "1", "46.930000000000", "301"),("9433", "2", "1", "62", "1", "38.440000000000", "302"),("235801", "2", "1000", "224", "1", "104.110000000000", "303"),("237472", "2", "1000", "11", "1", "60.850000000000", "304"),("95204", "2", "2", "58", "1", "210.830000000000", "305"),("95215", "2", "1", "58", "1", "206.630000000000", "306"),("223625", "2", "1000", "364", "1", "4202.420000000000", "307"),("230807", "1", "1000", "117", "1", "36.030000000000", "308"),("221368", "1", "1000", "117", "1", "36.030000000000", "309"),("147007", "1", "1001", "109", "1", "67.210000000000", "310"),("193599", "1", "1001", "727", "1", "253.130000000000", "311"),("193601", "1", "1001", "727", "1", "274.080000000000", "312"),("193603", "1", "1001", "727", "1", "295.150000000000", "313"),("68566", "2", "1000", "62", "1", "18.390000000000", "314"),("100477", "1", "1000", "62", "1", "28.350000000000", "315"),("147001", "1", "1000", "109", "1", "33.510000000000", "316"),("147003", "1", "1000", "109", "1", "42.760000000000", "317"),("147005", "1", "1000", "109", "1", "50.320000000000", "318"),("220649", "2", "1000", "603", "1", "68.050000000000", "319"),("220663", "2", "1000", "603", "1", "65.530000000000", "320"),("243163", "1", "1000", "54", "1", "98.310000000000", "321"),("243164", "1", "1000", "54", "1", "1313.430000000000", "322"),("243166", "1", "1000", "54", "1", "195.790000000000", "323"),("169500", "2", "1000", "603", "1", "65.530000000000", "324"),("169504", "2", "1000", "603", "1", "68.050000000000", "325"),("159917", "2", "1000", "49", "1", "36.880000000000", "326"),("159919", "2", "1000", "49", "1", "41.080000000000", "327"),("159921", "2", "1000", "49", "1", "51.170000000000", "328"),("159923", "2", "1000", "49", "1", "59.560000000000", "329"),("159925", "2", "1000", "49", "1", "75.530000000000", "330"),("159927", "2", "1000", "49", "1", "62.090000000000", "331"),("159929", "2", "1000", "49", "1", "71.330000000000", "332"),("159931", "2", "1000", "49", "1", "84.780000000000", "333"),("159933", "2", "1000", "49", "1", "98.220000000000", "334"),("174496", "2", "1000", "185", "1", "39.360000000000", "335"),("174497", "2", "1000", "185", "1", "39.360000000000", "336"),("174498", "2", "1000", "185", "1", "41.260000000000", "337"),("174499", "2", "1000", "185", "1", "41.260000000000", "338"),("174564", "2", "1000", "185", "1", "43.150000000000", "339"),("174565", "2", "1000", "185", "1", "43.150000000000", "340"),("179480", "2", "1000", "603", "1", "65.530000000000", "341"),("179482", "2", "1000", "603", "1", "68.050000000000", "342"),("220664", "2", "1000", "603", "1", "65.530000000000", "343"),("93956", "2", "1", "141", "1", "32.920000000000", "344"),("237474", "2", "1000", "11", "1", "60.850000000000", "345"),("219458", "1", "1015", "30", "1", "15.120000000000", "346"),("32610", "2", "1000", "50", "1", "27.640000000000", "347"),("32611", "2", "1000", "50", "1", "27.640000000000", "348"),("32612", "2", "1000", "50", "1", "27.640000000000", "349"),("169503", "2", "1000", "603", "1", "65.530000000000", "350"),("222960", "1", "1000", "459", "1", "62.090000000000", "351"),("223089", "1", "1000", "459", "1", "57.040000000000", "352"),("223395", "1", "1000", "459", "1", "57.040000000000", "353"),("179481", "2", "1000", "603", "1", "65.530000000000", "354"),("179483", "2", "1000", "603", "1", "68.050000000000", "355"),("248637", "2", "1000", "54", "1", "72.260000000000", "356"),("248638", "2", "1000", "54", "1", "72.260000000000", "357"),("248639", "2", "1000", "54", "1", "72.260000000000", "358"),("248641", "2", "1000", "54", "1", "72.260000000000", "359"),("248642", "2", "1000", "54", "1", "72.260000000000", "360"),("248643", "2", "1000", "54", "1", "78.980000000000", "361"),("248670", "2", "1000", "54", "1", "124.360000000000", "362"),("248671", "2", "1000", "54", "1", "124.360000000000", "363"),("248672", "2", "1000", "54", "1", "124.360000000000", "364"),("248673", "2", "1000", "54", "1", "124.360000000000", "365"),("248675", "2", "1000", "54", "1", "124.360000000000", "366"),("248676", "2", "1000", "54", "1", "124.360000000000", "367"),("248678", "2", "1000", "54", "1", "140.320000000000", "368"),("248809", "2", "1000", "54", "1", "826.030000000000", "369"),("248810", "2", "1000", "54", "1", "826.030000000000", "370"),("248811", "2", "1000", "54", "1", "826.030000000000", "371"),("248812", "2", "1000", "54", "1", "826.030000000000", "372"),("248813", "2", "1000", "54", "1", "826.030000000000", "373"),("248814", "2", "1000", "54", "1", "826.030000000000", "374"),("248815", "2", "1000", "54", "1", "826.030000000000", "375"),("248816", "2", "1000", "54", "1", "938.640000000000", "376"),("179097", "1", "1003", "13", "1", "210.830000000000", "377"),("215979", "2", "1002", "459", "1", "61.330000000000", "378"),("221340", "2", "1001", "30", "1", "241.920000000000", "379"),("179095", "1", "1000", "13", "1", "186.450000000000", "380"),("193717", "1", "1000", "87", "1", "284.860000000000", "381"),("194011", "1", "1000", "87", "1", "249.560000000000", "382"),("218974", "1", "1000", "30", "1", "18.240000000000", "383"),("221341", "2", "1000", "30", "1", "262.090000000000", "384"),("221342", "2", "1000", "30", "1", "274.690000000000", "385"),("221343", "2", "1000", "30", "1", "278.890000000000", "386"),("221346", "2", "1000", "30", "1", "315.950000000000", "387"),("218978", "1", "1000", "30", "1", "18.240000000000", "388"),("179096", "1", "1000", "13", "1", "197.380000000000", "389"),("221344", "2", "1000", "30", "1", "283.100000000000", "390"),("221345", "2", "999", "30", "1", "304.110000000000", "391"),("146971", "2", "1001", "113", "1", "291.500000000000", "392"),("146973", "2", "1001", "113", "1", "278.890000000000", "393"),("150775", "2", "1000", "58", "1", "106.630000000000", "394"),("217243", "1", "1000", "751", "1", "197.590000000000", "395"),("218971", "1", "1000", "30", "1", "16.710000000000", "396"),("218973", "1", "1000", "30", "1", "18.240000000000", "397"),("218977", "1", "1000", "30", "1", "18.240000000000", "398"),("218979", "1", "1000", "30", "1", "18.240000000000", "399"),("218976", "1", "1000", "30", "1", "18.240000000000", "400"),("32448", "2", "11", "178", "1", "31.180000000000", "401"),("218975", "1", "1005", "30", "1", "18.240000000000", "402"),("218968", "1", "1004", "30", "1", "18.240000000000", "403"),("210607", "10", "1001", "751", "1", "110.900000000000", "404"),("218969", "1", "1000", "30", "1", "18.240000000000", "405"),("218970", "1", "1000", "30", "1", "18.240000000000", "406"),("218972", "1", "1000", "30", "1", "18.240000000000", "407"),("210621", "2", "1", "751", "1", "138.020000000000", "408"),("244487", "1", "1000", "54", "1", "72.260000000000", "409"),("244488", "1", "1000", "54", "1", "72.260000000000", "410"),("244490", "1", "1000", "54", "1", "72.260000000000", "411"),("244491", "1", "1000", "54", "1", "72.260000000000", "412"),("244492", "1", "1000", "54", "1", "72.260000000000", "413"),("244494", "1", "1000", "54", "1", "72.260000000000", "414"),("244511", "1", "1000", "54", "1", "863.850000000000", "415"),("225945", "2", "0", "59", "1", "270.580000000000", "416"),("225941", "2", "0", "59", "1", "270.580000000000", "417"),("225943", "2", "0", "59", "1", "270.580000000000", "418"),("235176", "2", "0", "59", "1", "72.880000000000", "419"),("172320", "1", "0", "656", "1", "21.730000000000", "420"),("115661", "2", "0", "483", "1", "24.000000000000", "421"),("87724", "2", "0", "310", "1", "11.830000000000", "422"),("87731", "2", "0", "310", "1", "11.820000000000", "423"),("165766", "2", "0", "349", "1", "16.810000000000", "424"),("167712", "2", "0", "469", "1", "57.240000000000", "425"),("36278", "2", "0", "310", "1", "21.900000000000", "426"),("196069", "1", "0", "88", "1", "149.560000000000", "427"),("144429", "2", "0", "480", "1", "20.940000000000", "428"),("183227", "1", "0", "701", "1", "27.000000000000", "429"),("167727", "1", "0", "469", "1", "16.500000000000", "430"),("167731", "1", "0", "469", "1", "20.500000000000", "431"),("167733", "1", "0", "469", "1", "20.170000000000", "432"),("183141", "1", "0", "701", "1", "26.000000000000", "433"),("86482", "4", "0", "469", "1", "10.070000000000", "434"),("86484", "4", "0", "469", "1", "5.790000000000", "435"),("86486", "4", "0", "469", "1", "5.200000000000", "436"),("86487", "2", "0", "469", "1", "5.790000000000", "437"),("245051", "1", "0", "54", "1", "37.260000000000", "438"),("245062", "1", "0", "54", "1", "44.760000000000", "439"),("245335", "2", "0", "54", "1", "218.670000000000", "440"),("245462", "2", "0", "54", "1", "257.280000000000", "441"),("122633", "2", "0", "67", "1", "10.390000000000", "442"),("245048", "1", "0", "54", "1", "37.260000000000", "443"),("245057", "1", "0", "54", "1", "44.760000000000", "444"),("245305", "2", "0", "54", "1", "119.790000000000", "445"),("245315", "2", "0", "54", "1", "282.980000000000", "446"),("245474", "2", "0", "54", "1", "239.790000000000", "447"),("245323", "2", "0", "54", "1", "257.280000000000", "448"),("245325", "2", "0", "54", "1", "257.280000000000", "449"),("146063", "10", "0", "315", "1", "3329.140000000000", "450"),("95225", "2", "0", "58", "1", "272.000000000000", "451"),("243106", "1", "0", "54", "1", "77.160000000000", "452"),("243118", "1", "0", "54", "1", "77.160000000000", "453"),("243127", "1", "0", "54", "1", "77.160000000000", "454"),("237468", "2", "0", "11", "1", "45.590000000000", "455"),("95381", "2", "0", "58", "1", "225.000000000000", "456"),("92551", "2", "0", "62", "1", "20.480000000000", "457"),("110514", "2", "0", "62", "1", "20.480000000000", "458"),("95205", "2", "0", "58", "1", "215.000000000000", "459"),("95216", "2", "0", "58", "1", "215.000000000000", "460"),("26122", "2", "0", "62", "1", "15.700000000000", "461"),("159935", "2", "0", "49", "1", "82.000000000000", "462"),("220648", "2", "0", "603", "1", "53.000000000000", "463"),("169505", "2", "0", "603", "1", "53.000000000000", "464"),("223285", "1", "0", "459", "1", "42.000000000000", "465"),("217219", "1", "0", "751", "1", "152.000000000000", "466"),("248640", "2", "0", "54", "1", "56.600000000000", "467"),("193713", "1", "0", "87", "1", "216.340000000000", "468"),("194013", "1", "0", "87", "1", "176.790000000000", "469"),("193711", "1", "0", "87", "1", "258.370000000000", "470"),("193715", "1", "0", "87", "1", "225.720000000000", "471"),("32450", "2", "0", "178", "1", "24.000000000000", "472"),("150777", "2", "0", "58", "1", "95.000000000000", "473"),("150701", "2", "0", "58", "1", "170.000000000000", "474"),("244486", "1", "0", "54", "1", "45.930000000000", "475"),("244489", "1", "0", "54", "1", "56.600000000000", "476"),("244498", "1", "0", "54", "1", "75.930000000000", "477"),("244499", "1", "0", "54", "1", "90.390000000000", "478"),("244500", "1", "0", "54", "1", "90.390000000000", "479"),("244502", "1", "0", "54", "1", "90.390000000000", "480"),("244503", "1", "0", "54", "1", "90.390000000000", "481"),("244505", "1", "0", "54", "1", "90.390000000000", "482"),("244506", "1", "0", "54", "1", "90.390000000000", "483"),("244507", "1", "0", "54", "1", "90.390000000000", "484"),("244510", "1", "0", "54", "1", "484.380000000000", "485"),("244512", "1", "0", "54", "1", "484.380000000000", "486"),("244513", "1", "0", "54", "1", "484.380000000000", "487"),("244514", "1", "0", "54", "1", "484.380000000000", "488"),("244515", "1", "0", "54", "1", "484.380000000000", "489"),("244517", "1", "0", "54", "1", "484.380000000000", "490"),("244518", "1", "0", "54", "1", "484.380000000000", "491"),("244520", "1", "0", "54", "1", "484.380000000000", "492"),("244521", "1", "0", "54", "1", "484.380000000000", "493"),("244522", "1", "0", "54", "1", "484.380000000000", "494")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.176)
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.237)
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.130)
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.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
9 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.103)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.122)
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
12 (0.125)
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
13 (0.552)
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
14 (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:1415
15 (0.150)
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
16 (4.962)
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
17 (0.126)
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