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


Starlita Mivardi Aurora - 3mm

m-lsauro3
Livrare imediată!

2,50Lei

Ciorapi Norfin T4A MERINO MIDWEIGHT M

303804-02m
Livrare imediată!

78,00Lei(-31%) 53,90Lei

Exclusiv online!

Ciorapi Norfin T3A NORDIC MERINO LIGHT - M

303902-02m
Livrare 48-72ore

49,00Lei

Exclusiv online!

Hanorac Lucky John Hoodie Marime M

am-8001-02m
Livrare 48-72ore

178,00Lei

Exclusiv online!

Tricou Lucky John Polo T-Shirt Marime M

am-7501-02m
Livrare 48-72ore

68,00Lei

NGT BANDA PVA 20 m

ngt-fpva-tape-20m
Livrare imediată!

10,00Lei

17,00Lei

Exclusiv online!

Lingura Oscilanta - Shallow Monster 30G-10Cm - Gold

pmb-wshm-30-g
Livrare 48-72 ore

24,00Lei

10,00Lei

13,30Lei

13,30Lei

13,30Lei

19,10Lei

19,10Lei

19,10Lei

Exclusiv online!

10,00Lei

Exclusiv online!

10,00Lei

10,00Lei

10,00Lei

Exclusiv online!

10,00Lei

Afişare 1 - 20 din 473 (24 pagini)
Queries: 17, Total time: 11.306 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '2a768686030fd9036d05452832'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
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.238)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("12684", "2", "1002", "98", "1", "2.100000000000", "1"),("56299", "2", "1", "332", "1", "45.290000000000", "2"),("65896", "2", "1000", "332", "1", "41.180000000000", "3"),("129885", "1", "1000", "193", "1", "149.580000000000", "4"),("129875", "1", "1000", "193", "1", "57.140000000000", "5"),("35511", "2", "3", "287", "1", "8.400000000000", "6"),("51698", "2", "12", "69", "1", "19.968000000000", "7"),("210543", "1", "1000", "224", "1", "20.170000000000", "8"),("35385", "2", "1", "297", "1", "8.400000000000", "9"),("146395", "2", "1004", "68", "1", "11.180000000000", "10"),("146397", "2", "1004", "68", "1", "11.180000000000", "11"),("146399", "2", "1002", "68", "1", "11.180000000000", "12"),("146403", "2", "1008", "68", "1", "16.050000000000", "13"),("146405", "2", "1007", "68", "1", "16.050000000000", "14"),("146401", "2", "1005", "68", "1", "16.050000000000", "15"),("43177", "2", "1000", "297", "1", "8.400000000000", "16"),("43189", "2", "1000", "297", "1", "8.400000000000", "17"),("43190", "2", "2", "297", "1", "8.400000000000", "18"),("43179", "2", "1002", "297", "1", "8.400000000000", "19"),("43161", "2", "1000", "297", "1", "8.400000000000", "20"),("43162", "2", "1000", "297", "1", "8.400000000000", "21"),("43163", "2", "1000", "297", "1", "8.400000000000", "22"),("43168", "2", "1000", "297", "1", "8.400000000000", "23"),("43174", "2", "1000", "297", "1", "8.400000000000", "24"),("43175", "2", "1000", "297", "1", "8.400000000000", "25"),("43176", "2", "1000", "297", "1", "8.400000000000", "26"),("43180", "2", "1000", "297", "1", "8.400000000000", "27"),("43186", "2", "1000", "297", "1", "8.400000000000", "28"),("43188", "2", "1000", "297", "1", "8.400000000000", "29"),("43185", "2", "1000", "297", "1", "8.400000000000", "30"),("10630", "2", "1002", "185", "1", "32.770000000000", "31"),("10632", "2", "1000", "185", "1", "33.610000000000", "32"),("162066", "2", "1000", "368", "1", "2079.800000000000", "33"),("91177", "1", "1001", "42", "1", "29.363200000000", "34"),("220197", "2", "1000", "138", "1", "5.880000000000", "35"),("173534", "1", "1000", "191", "1", "567.230000000000", "36"),("37751", "2", "1000", "73", "1", "97.590000000000", "37"),("162146", "2", "1000", "368", "1", "317.600000000000", "38"),("162147", "2", "1000", "368", "1", "362.980000000000", "39"),("162148", "2", "1000", "368", "1", "453.760000000000", "40"),("189857", "1", "1000", "528", "1", "16.390000000000", "41"),("87245", "2", "37", "469", "1", "3.280000000000", "42"),("3795", "2", "1003", "73", "1", "105.030000000000", "43"),("3797", "2", "1000", "73", "1", "97.480000000000", "44"),("59588", "2", "11", "28", "1", "28.185600000000", "45"),("21977", "2", "6", "73", "1", "15.430000000000", "46"),("161473", "2", "1", "428", "1", "3.280000000000", "47"),("80107", "2", "1009", "42", "1", "4.620000000000", "48"),("60794", "2", "1004", "39", "1", "6.720000000000", "49"),("60798", "2", "1003", "39", "1", "6.720000000000", "50"),("149139", "1", "1003", "48", "1", "3.780000000000", "51"),("149133", "1", "1003", "48", "1", "5.040000000000", "52"),("60797", "2", "1003", "39", "1", "6.720000000000", "53"),("149145", "1", "1002", "48", "1", "3.780000000000", "54"),("149147", "1", "1002", "48", "1", "3.780000000000", "55"),("149151", "1", "1002", "48", "1", "5.040000000000", "56"),("149131", "1", "1002", "48", "1", "5.040000000000", "57"),("149135", "1", "1002", "48", "1", "3.780000000000", "58"),("149153", "1", "1002", "48", "1", "3.780000000000", "59"),("149141", "1", "1002", "48", "1", "5.040000000000", "60"),("51000", "2", "1001", "42", "1", "23.450000000000", "61"),("80104", "2", "1001", "42", "1", "4.620000000000", "62"),("51004", "2", "1001", "42", "1", "29.410000000000", "63"),("149155", "1", "1001", "48", "1", "5.040000000000", "64"),("60793", "2", "1001", "39", "1", "6.720000000000", "65"),("10810", "2", "1001", "190", "1", "26.890000000000", "66"),("50999", "2", "1000", "42", "1", "29.410000000000", "67"),("51001", "2", "1000", "42", "1", "29.410000000000", "68"),("51003", "2", "1000", "42", "1", "29.410000000000", "69"),("51005", "2", "1000", "42", "1", "29.410000000000", "70"),("51006", "2", "1000", "42", "1", "29.410000000000", "71"),("51007", "2", "1000", "42", "1", "29.410000000000", "72"),("80102", "2", "1000", "42", "1", "4.620000000000", "73"),("80103", "2", "1000", "42", "1", "4.620000000000", "74"),("80105", "2", "1000", "42", "1", "4.620000000000", "75"),("149137", "1", "1000", "48", "1", "5.040000000000", "76"),("149149", "1", "1000", "48", "1", "5.040000000000", "77"),("42785", "2", "1000", "163", "1", "12.280000000000", "78"),("67776", "2", "1000", "11", "1", "35.760000000000", "79"),("31310", "2", "1000", "117", "1", "36.130000000000", "80"),("36613", "2", "11", "12", "1", "20.130000000000", "81"),("51002", "2", "1", "42", "1", "23.450000000000", "82"),("141689", "2", "1012", "48", "1", "7.560000000000", "83"),("141727", "2", "1010", "48", "1", "7.560000000000", "84"),("141921", "2", "1010", "48", "1", "7.560000000000", "85"),("141909", "2", "1009", "48", "1", "7.560000000000", "86"),("141675", "2", "1009", "48", "1", "7.560000000000", "87"),("172795", "2", "1002", "105", "1", "29.410000000000", "88"),("172796", "2", "1002", "105", "1", "28.570000000000", "89"),("235017", "1", "1002", "28", "1", "170.278400000000", "90"),("32157", "2", "1001", "42", "1", "25.715200000000", "91"),("51013", "2", "1001", "42", "1", "23.450000000000", "92"),("172789", "2", "1001", "105", "1", "28.570000000000", "93"),("172799", "2", "1001", "105", "1", "28.570000000000", "94"),("141703", "2", "1001", "48", "1", "5.880000000000", "95"),("141913", "2", "1001", "48", "1", "7.560000000000", "96"),("24595", "2", "1001", "161", "1", "3.040000000000", "97"),("179142", "2", "1001", "13", "1", "15.040000000000", "98"),("172788", "2", "1001", "105", "1", "29.410000000000", "99"),("24593", "2", "1001", "161", "1", "2.900000000000", "100"),("141681", "2", "1001", "48", "1", "5.880000000000", "101"),("24550", "2", "1000", "161", "1", "11.980000000000", "102"),("51011", "2", "1000", "42", "1", "29.410000000000", "103"),("51012", "2", "1000", "42", "1", "29.410000000000", "104"),("51014", "2", "1000", "42", "1", "29.410000000000", "105"),("51015", "2", "1000", "42", "1", "29.410000000000", "106"),("123147", "1", "1000", "50", "1", "63.030000000000", "107"),("123161", "1", "1000", "50", "1", "74.790000000000", "108"),("123169", "1", "1000", "50", "1", "83.190000000000", "109"),("141665", "2", "1000", "48", "1", "5.880000000000", "110"),("141683", "2", "1000", "48", "1", "6.050000000000", "111"),("141701", "2", "1000", "48", "1", "5.880000000000", "112"),("141717", "2", "1000", "48", "1", "5.880000000000", "113"),("141719", "2", "1000", "48", "1", "5.880000000000", "114"),("141723", "2", "1000", "48", "1", "5.880000000000", "115"),("141725", "2", "1000", "48", "1", "5.880000000000", "116"),("141885", "2", "1000", "48", "1", "5.880000000000", "117"),("141891", "2", "1000", "48", "1", "5.880000000000", "118"),("141903", "2", "1000", "48", "1", "5.880000000000", "119"),("141905", "2", "1000", "48", "1", "5.880000000000", "120"),("141907", "2", "1000", "48", "1", "5.880000000000", "121"),("141915", "2", "1000", "48", "1", "5.880000000000", "122"),("141923", "2", "1000", "48", "1", "5.880000000000", "123"),("141929", "2", "1000", "48", "1", "5.880000000000", "124"),("141931", "2", "1000", "48", "1", "5.880000000000", "125"),("141935", "2", "1000", "48", "1", "5.880000000000", "126"),("141937", "2", "1000", "48", "1", "5.880000000000", "127"),("141711", "2", "1000", "48", "1", "5.880000000000", "128"),("141911", "2", "1000", "48", "1", "7.560000000000", "129"),("92296", "2", "1000", "11", "1", "28.000000000000", "130"),("92297", "2", "1000", "11", "1", "31.980000000000", "131"),("24548", "2", "1000", "161", "1", "11.770000000000", "132"),("24552", "2", "1000", "161", "1", "12.190000000000", "133"),("93383", "2", "1000", "42", "1", "20.170000000000", "134"),("231294", "2", "1000", "203", "1", "125.210000000000", "135"),("213335", "1", "1000", "224", "1", "25.210000000000", "136"),("239757", "1", "1000", "160", "1", "3357.140000000000", "137"),("141707", "2", "1000", "48", "1", "5.880000000000", "138"),("24594", "2", "1000", "161", "1", "3.040000000000", "139"),("231290", "2", "1000", "203", "1", "125.210000000000", "140"),("231291", "2", "1000", "203", "1", "125.210000000000", "141"),("231292", "2", "1000", "203", "1", "125.210000000000", "142"),("231293", "2", "1000", "203", "1", "125.210000000000", "143"),("231295", "2", "1000", "203", "1", "125.210000000000", "144"),("231760", "2", "1000", "203", "1", "187.390000000000", "145"),("231761", "2", "1000", "203", "1", "125.210000000000", "146"),("18558", "10", "1000", "104", "1", "2.680000000000", "147"),("141679", "2", "1000", "48", "1", "5.880000000000", "148"),("141687", "2", "1000", "48", "1", "5.880000000000", "149"),("141693", "2", "1000", "48", "1", "5.880000000000", "150"),("141877", "2", "1000", "48", "1", "7.560000000000", "151"),("141917", "2", "1000", "48", "1", "5.880000000000", "152"),("141925", "2", "1000", "48", "1", "5.880000000000", "153"),("63443", "2", "8", "98", "1", "7.560000000000", "154"),("179542", "1", "5", "573", "1", "34.060800000000", "155"),("24590", "2", "2", "161", "1", "3.240000000000", "156"),("141879", "2", "2", "48", "1", "7.560000000000", "157"),("32151", "2", "1", "42", "1", "32.883200000000", "158"),("51016", "2", "1", "42", "1", "29.410000000000", "159"),("22035", "2", "1006", "73", "1", "31.100000000000", "160"),("137043", "1", "1005", "487", "1", "29.120000000000", "161"),("165812", "1", "1005", "324", "1", "8.400000000000", "162"),("22029", "2", "1003", "73", "1", "25.260000000000", "163"),("172794", "2", "1002", "105", "1", "28.570000000000", "164"),("172804", "2", "1001", "105", "1", "28.570000000000", "165"),("172790", "2", "1001", "105", "1", "29.410000000000", "166"),("172792", "2", "1001", "105", "1", "29.410000000000", "167"),("172791", "2", "1001", "105", "1", "28.570000000000", "168"),("63747", "2", "1001", "11", "1", "23.550000000000", "169"),("51397", "2", "1000", "42", "1", "32.883200000000", "170"),("119349", "2", "1000", "105", "1", "243.700000000000", "171"),("119350", "2", "1000", "105", "1", "243.700000000000", "172"),("91135", "2", "1000", "42", "1", "34.060800000000", "173"),("91138", "2", "1000", "42", "1", "34.060800000000", "174"),("91139", "2", "1000", "42", "1", "34.060800000000", "175"),("176155", "1", "1000", "487", "1", "19.750000000000", "176"),("241808", "2", "1000", "725", "1", "14.880000000000", "177"),("241809", "2", "1000", "725", "1", "14.880000000000", "178"),("231281", "2", "1000", "203", "1", "156.300000000000", "179"),("231282", "2", "1000", "203", "1", "156.300000000000", "180"),("231284", "2", "1000", "203", "1", "149.580000000000", "181"),("231287", "2", "1000", "203", "1", "140.340000000000", "182"),("231288", "2", "1000", "203", "1", "140.340000000000", "183"),("52543", "2", "1000", "115", "1", "42.860000000000", "184"),("241805", "2", "1000", "725", "1", "14.880000000000", "185"),("79345", "2", "1", "56", "1", "15.130000000000", "186"),("91144", "2", "1", "42", "1", "34.060800000000", "187"),("79343", "2", "1", "56", "1", "15.130000000000", "188"),("197793", "2", "1010", "48", "1", "7.560000000000", "189"),("197809", "2", "1010", "48", "1", "7.560000000000", "190"),("197813", "2", "1010", "48", "1", "7.560000000000", "191"),("197815", "2", "1010", "48", "1", "7.560000000000", "192"),("197827", "2", "1010", "48", "1", "7.560000000000", "193"),("197843", "2", "1010", "48", "1", "7.560000000000", "194"),("197849", "2", "1010", "48", "1", "7.560000000000", "195"),("197853", "2", "1010", "48", "1", "7.560000000000", "196"),("241658", "2", "1010", "48", "1", "7.560000000000", "197"),("241659", "2", "1010", "48", "1", "7.560000000000", "198"),("35851", "2", "1006", "75", "1", "12.520000000000", "199"),("110876", "2", "1002", "50", "1", "47.060000000000", "200"),("47180", "2", "1002", "341", "1", "18.070000000000", "201"),("14532", "2", "1001", "115", "1", "50.420000000000", "202"),("47182", "2", "1001", "341", "1", "18.070000000000", "203"),("47191", "2", "1001", "341", "1", "18.070000000000", "204"),("197857", "2", "1001", "48", "1", "7.560000000000", "205"),("24555", "2", "1001", "161", "1", "19.120000000000", "206"),("24557", "2", "1001", "161", "1", "26.800000000000", "207"),("137045", "1", "1001", "487", "1", "27.596800000000", "208"),("14531", "2", "1000", "115", "1", "42.860000000000", "209"),("24556", "2", "1000", "161", "1", "26.800000000000", "210"),("47202", "2", "1000", "341", "1", "18.070000000000", "211"),("107873", "1", "1000", "58", "1", "21.010000000000", "212"),("107874", "1", "1000", "58", "1", "24.370000000000", "213"),("119351", "2", "1000", "105", "1", "243.700000000000", "214"),("119357", "2", "1000", "105", "1", "132.770000000000", "215"),("119358", "2", "1000", "105", "1", "132.770000000000", "216"),("119360", "2", "1000", "105", "1", "132.770000000000", "217"),("119361", "2", "1000", "105", "1", "132.770000000000", "218"),("119362", "2", "1000", "105", "1", "132.770000000000", "219"),("91137", "2", "1000", "42", "1", "34.060800000000", "220"),("91142", "2", "1000", "42", "1", "34.060800000000", "221"),("91143", "2", "1000", "42", "1", "34.060800000000", "222"),("91145", "2", "1000", "42", "1", "34.060800000000", "223"),("91146", "2", "1000", "42", "1", "34.060800000000", "224"),("91147", "2", "1000", "42", "1", "34.060800000000", "225"),("91151", "2", "1000", "42", "1", "34.060800000000", "226"),("91152", "2", "1000", "42", "1", "34.060800000000", "227"),("197797", "2", "1000", "48", "1", "6.050000000000", "228"),("197821", "2", "1000", "48", "1", "7.560000000000", "229"),("197823", "2", "1000", "48", "1", "7.560000000000", "230"),("197825", "2", "1000", "48", "1", "7.560000000000", "231"),("197829", "2", "1000", "48", "1", "7.560000000000", "232"),("197831", "2", "1000", "48", "1", "7.560000000000", "233"),("197833", "2", "1000", "48", "1", "7.560000000000", "234"),("197839", "2", "1000", "48", "1", "7.560000000000", "235"),("197847", "2", "1000", "48", "1", "7.560000000000", "236"),("197851", "2", "1000", "48", "1", "7.560000000000", "237"),("197855", "2", "1000", "48", "1", "7.560000000000", "238"),("197859", "2", "1000", "48", "1", "6.050000000000", "239"),("197795", "2", "1000", "48", "1", "6.050000000000", "240"),("197803", "2", "1000", "48", "1", "6.050000000000", "241"),("197819", "2", "1000", "48", "1", "7.560000000000", "242"),("24554", "2", "1000", "161", "1", "19.120000000000", "243"),("237050", "1", "1000", "629", "1", "58.820000000000", "244"),("237787", "2", "1000", "401", "1", "8.070000000000", "245"),("24553", "2", "1000", "161", "1", "18.820000000000", "246"),("96982", "2", "1000", "97", "1", "18.490000000000", "247"),("242628", "1", "1000", "73", "1", "50.380000000000", "248"),("197799", "2", "1000", "48", "1", "6.050000000000", "249"),("197811", "2", "1000", "48", "1", "6.050000000000", "250"),("197835", "2", "1000", "48", "1", "7.560000000000", "251"),("197837", "2", "1000", "48", "1", "7.560000000000", "252"),("197845", "2", "1000", "48", "1", "7.560000000000", "253"),("174445", "1", "2", "487", "1", "25.210000000000", "254"),("174448", "1", "2", "487", "1", "25.210000000000", "255"),("110880", "2", "1", "50", "1", "37.650000000000", "256"),("174446", "1", "1", "487", "1", "25.210000000000", "257"),("120078", "2", "1004", "11", "1", "13.870000000000", "258"),("47177", "2", "1003", "341", "1", "18.070000000000", "259"),("47179", "2", "1001", "341", "1", "18.070000000000", "260"),("47190", "2", "1001", "341", "1", "18.070000000000", "261"),("175474", "2", "1001", "178", "1", "23.530000000000", "262"),("203661", "2", "1001", "224", "1", "11.760000000000", "263"),("47181", "2", "1000", "341", "1", "18.070000000000", "264"),("47196", "2", "1000", "341", "1", "18.070000000000", "265"),("108166", "1", "1000", "58", "1", "18.490000000000", "266"),("119352", "2", "1000", "105", "1", "289.920000000000", "267"),("119353", "2", "1000", "105", "1", "132.770000000000", "268"),("119354", "2", "1000", "105", "1", "132.770000000000", "269"),("119355", "2", "1000", "105", "1", "132.770000000000", "270"),("222408", "1", "1000", "370", "1", "8.230000000000", "271"),("210513", "1", "1000", "224", "1", "23.530000000000", "272"),("213299", "1", "1000", "224", "1", "23.530000000000", "273"),("120077", "2", "1000", "11", "1", "12.550000000000", "274"),("120076", "2", "1000", "11", "1", "16.500000000000", "275"),("175475", "2", "1000", "178", "1", "23.530000000000", "276"),("162180", "2", "10", "69", "1", "19.968000000000", "277"),("47187", "2", "1", "341", "1", "18.070000000000", "278"),("123027", "2", "1", "469", "1", "5.800000000000", "279"),("47199", "2", "1", "341", "1", "18.070000000000", "280"),("154561", "2", "1005", "224", "1", "8.400000000000", "281"),("154563", "2", "1004", "224", "1", "10.920000000000", "282"),("178524", "1", "1003", "11", "1", "60.700000000000", "283"),("178526", "1", "1003", "11", "1", "86.960000000000", "284"),("47185", "2", "1001", "341", "1", "18.070000000000", "285"),("178525", "1", "1001", "11", "1", "58.740000000000", "286"),("203657", "2", "1001", "224", "1", "11.760000000000", "287"),("170553", "1", "1001", "138", "1", "6.720000000000", "288"),("108169", "1", "1001", "58", "1", "18.490000000000", "289"),("119356", "2", "1000", "105", "1", "132.770000000000", "290"),("167641", "2", "1000", "341", "1", "18.070000000000", "291"),("109404", "1", "1000", "163", "1", "60.070000000000", "292"),("109405", "1", "1000", "163", "1", "71.220000000000", "293"),("109406", "1", "1000", "163", "1", "91.050000000000", "294"),("175477", "1", "1000", "178", "1", "23.530000000000", "295"),("241815", "2", "1000", "119", "1", "145.190000000000", "296"),("106325", "1", "1010", "75", "1", "22.310400000000", "297"),("106324", "1", "1006", "75", "1", "22.310400000000", "298"),("106328", "1", "1006", "75", "1", "22.310400000000", "299"),("106326", "1", "1003", "75", "1", "22.310400000000", "300"),("117965", "2", "1001", "22", "1", "15.550000000000", "301"),("106327", "1", "1001", "75", "1", "22.310400000000", "302"),("49371", "2", "1000", "50", "1", "137.820000000000", "303"),("49372", "2", "1000", "50", "1", "137.820000000000", "304"),("51697", "2", "11", "69", "1", "19.968000000000", "305"),("88908", "2", "1004", "423", "1", "36.130000000000", "306"),("143321", "2", "1004", "11", "1", "7.260000000000", "307"),("143319", "2", "1004", "11", "1", "7.150000000000", "308"),("88905", "2", "1002", "423", "1", "36.130000000000", "309"),("88907", "2", "1000", "423", "1", "36.130000000000", "310"),("176597", "1", "13", "625", "1", "35.225600000000", "311"),("148835", "1", "12", "625", "1", "31.705600000000", "312"),("237498", "1", "10", "625", "1", "38.758400000000", "313"),("142749", "2", "1000", "531", "1", "34.450000000000", "314"),("142751", "2", "1000", "531", "1", "40.340000000000", "315"),("142755", "2", "1000", "531", "1", "40.340000000000", "316"),("142757", "2", "1000", "531", "1", "48.740000000000", "317"),("244153", "2", "1000", "11", "1", "2558.140000000000", "318"),("224394", "1", "4", "772", "1", "22.195200000000", "319"),("238637", "1", "1005", "455", "1", "39.660000000000", "320"),("108229", "1", "1000", "104", "1", "47.900000000000", "321"),("108231", "1", "1000", "104", "1", "38.660000000000", "322"),("220647", "1", "17", "749", "1", "2.520000000000", "323"),("148829", "1", "13", "625", "1", "35.225600000000", "324"),("220646", "1", "9", "749", "1", "2.520000000000", "325"),("220645", "1", "8", "749", "1", "2.520000000000", "326"),("220644", "1", "6", "749", "1", "2.520000000000", "327"),("4583", "2", "2", "95", "1", "62.100000000000", "328"),("4582", "2", "1", "95", "1", "62.100000000000", "329"),("104279", "1", "1005", "104", "1", "15.710000000000", "330"),("232830", "2", "1003", "785", "1", "15.880000000000", "331"),("104278", "1", "1003", "104", "1", "15.970000000000", "332"),("104275", "1", "1002", "104", "1", "15.970000000000", "333"),("104277", "1", "1002", "104", "1", "15.970000000000", "334"),("104276", "1", "1001", "104", "1", "15.970000000000", "335"),("104265", "1", "1001", "104", "1", "21.010000000000", "336"),("104267", "1", "1000", "104", "1", "23.530000000000", "337"),("104266", "1", "1000", "104", "1", "21.010000000000", "338"),("215783", "1", "1010", "648", "1", "13.450000000000", "339"),("215785", "1", "1009", "648", "1", "13.450000000000", "340"),("127675", "1", "1000", "50", "1", "150.420000000000", "341"),("127697", "1", "1000", "50", "1", "150.420000000000", "342"),("62944", "2", "1", "189", "1", "11.760000000000", "343"),("222397", "1", "1010", "96", "1", "6.470000000000", "344"),("108218", "1", "1000", "104", "1", "48.740000000000", "345"),("108219", "1", "1000", "104", "1", "52.940000000000", "346"),("108220", "1", "1000", "104", "1", "54.620000000000", "347"),("108221", "1", "1000", "104", "1", "48.740000000000", "348"),("108222", "1", "1000", "104", "1", "39.500000000000", "349"),("108223", "1", "1000", "104", "1", "54.620000000000", "350"),("108224", "1", "1000", "104", "1", "52.940000000000", "351"),("108225", "1", "1000", "104", "1", "52.940000000000", "352"),("108226", "1", "1000", "104", "1", "47.900000000000", "353"),("108227", "1", "1000", "104", "1", "52.830000000000", "354"),("108228", "1", "1000", "104", "1", "52.830000000000", "355"),("104269", "1", "1000", "104", "1", "15.130000000000", "356"),("104270", "1", "1000", "104", "1", "15.130000000000", "357"),("104274", "1", "1000", "104", "1", "15.130000000000", "358"),("191907", "2", "0", "332", "1", "25.000000000000", "359"),("96719", "2", "0", "98", "1", "27.610000000000", "360"),("96720", "2", "0", "98", "1", "27.610000000000", "361"),("116988", "2", "0", "280", "1", "6.140000000000", "362"),("96716", "2", "0", "98", "1", "25.000000000000", "363"),("178859", "1", "0", "193", "1", "95.000000000000", "364"),("35387", "2", "0", "297", "1", "5.920000000000", "365"),("35388", "2", "0", "297", "1", "5.920000000000", "366"),("35389", "2", "0", "297", "1", "5.920000000000", "367"),("43148", "2", "0", "297", "1", "5.920000000000", "368"),("172434", "2", "0", "120", "1", "3.290000000000", "369"),("162145", "2", "0", "368", "1", "239.950000000000", "370"),("87248", "2", "0", "469", "1", "5.880000000000", "371"),("72265", "2", "0", "459", "1", "44.000000000000", "372"),("161539", "2", "0", "428", "1", "1.950000000000", "373"),("161565", "2", "0", "428", "1", "2.450000000000", "374"),("133871", "2", "0", "341", "1", "12.440000000000", "375"),("224729", "1", "0", "725", "1", "21.530000000000", "376"),("36614", "2", "0", "12", "1", "14.380000000000", "377"),("32546", "2", "0", "50", "1", "202.350000000000", "378"),("94322", "2", "0", "12", "1", "5.830000000000", "379"),("93382", "2", "0", "42", "1", "14.000000000000", "380"),("51010", "2", "0", "42", "1", "23.000000000000", "381"),("79346", "2", "0", "56", "1", "10.800000000000", "382"),("24591", "2", "0", "161", "1", "2.900000000000", "383"),("100349", "1", "0", "47", "1", "6.640000000000", "384"),("123139", "1", "0", "50", "1", "40.000000000000", "385"),("141673", "2", "0", "48", "1", "3.780000000000", "386"),("141677", "2", "0", "48", "1", "3.780000000000", "387"),("141697", "2", "0", "48", "1", "3.780000000000", "388"),("141715", "2", "0", "48", "1", "3.780000000000", "389"),("141875", "2", "0", "48", "1", "3.780000000000", "390"),("141883", "2", "0", "48", "1", "3.780000000000", "391"),("172798", "2", "0", "105", "1", "18.400000000000", "392"),("24549", "2", "0", "161", "1", "8.560000000000", "393"),("141899", "2", "0", "48", "1", "3.780000000000", "394"),("141901", "2", "0", "48", "1", "3.780000000000", "395"),("141691", "2", "0", "48", "1", "3.780000000000", "396"),("141699", "2", "0", "48", "1", "3.780000000000", "397"),("141705", "2", "0", "48", "1", "3.780000000000", "398"),("141713", "2", "0", "48", "1", "3.780000000000", "399"),("141721", "2", "0", "48", "1", "3.780000000000", "400"),("141729", "2", "0", "48", "1", "3.780000000000", "401"),("141881", "2", "0", "48", "1", "3.780000000000", "402"),("141893", "2", "0", "48", "1", "7.560000000000", "403"),("141895", "2", "0", "48", "1", "3.780000000000", "404"),("141897", "2", "0", "48", "1", "3.780000000000", "405"),("141695", "2", "0", "48", "1", "3.780000000000", "406"),("51009", "2", "0", "42", "1", "23.000000000000", "407"),("141685", "2", "0", "48", "1", "3.780000000000", "408"),("123165", "1", "0", "50", "1", "46.000000000000", "409"),("24551", "2", "0", "161", "1", "8.700000000000", "410"),("51008", "2", "0", "42", "1", "23.000000000000", "411"),("154803", "2", "0", "224", "1", "8.320000000000", "412"),("189469", "1", "0", "128", "1", "14.290000000000", "413"),("91130", "2", "0", "42", "1", "26.240000000000", "414"),("79347", "2", "0", "56", "1", "10.800000000000", "415"),("123007", "2", "0", "469", "1", "7.320000000000", "416"),("109206", "2", "0", "12", "1", "82.460000000000", "417"),("231283", "2", "0", "203", "1", "132.190000000000", "418"),("172801", "2", "0", "105", "1", "18.400000000000", "419"),("102654", "2", "0", "294", "1", "2.930000000000", "420"),("96466", "2", "0", "98", "1", "5.400000000000", "421"),("96467", "2", "0", "98", "1", "5.400000000000", "422"),("96468", "2", "0", "98", "1", "5.400000000000", "423"),("96469", "2", "0", "98", "1", "5.400000000000", "424"),("96470", "2", "0", "98", "1", "5.400000000000", "425"),("96471", "2", "0", "98", "1", "5.400000000000", "426"),("63748", "2", "0", "11", "1", "16.820000000000", "427"),("231286", "2", "0", "203", "1", "126.900000000000", "428"),("231289", "2", "0", "203", "1", "118.950000000000", "429"),("48664", "2", "0", "288", "1", "6.120000000000", "430"),("79344", "2", "0", "56", "1", "10.800000000000", "431"),("174447", "1", "0", "487", "1", "15.000000000000", "432"),("178450", "1", "0", "487", "1", "20.480000000000", "433"),("197805", "2", "0", "48", "1", "4.000000000000", "434"),("197801", "2", "0", "48", "1", "4.000000000000", "435"),("197817", "2", "0", "48", "1", "4.000000000000", "436"),("197807", "2", "0", "48", "1", "5.040000000000", "437"),("47183", "2", "0", "341", "1", "12.440000000000", "438"),("123017", "2", "0", "469", "1", "4.960000000000", "439"),("123021", "2", "0", "469", "1", "4.960000000000", "440"),("123031", "2", "0", "469", "1", "4.510000000000", "441"),("47197", "2", "0", "341", "1", "12.440000000000", "442"),("47209", "2", "0", "341", "1", "12.440000000000", "443"),("47212", "2", "0", "341", "1", "12.440000000000", "444"),("47213", "2", "0", "341", "1", "12.440000000000", "445"),("47217", "2", "0", "341", "1", "12.440000000000", "446"),("47219", "2", "0", "341", "1", "12.440000000000", "447"),("112359", "1", "0", "469", "1", "14.440000000000", "448"),("166824", "1", "0", "469", "1", "9.630000000000", "449"),("166826", "1", "0", "469", "1", "9.630000000000", "450"),("123029", "2", "0", "469", "1", "4.960000000000", "451"),("123023", "2", "0", "469", "1", "4.920000000000", "452"),("123019", "2", "0", "469", "1", "5.320000000000", "453"),("47189", "2", "0", "341", "1", "12.440000000000", "454"),("166822", "1", "0", "469", "1", "9.630000000000", "455"),("123025", "2", "0", "469", "1", "5.320000000000", "456"),("47178", "2", "0", "341", "1", "12.440000000000", "457"),("119022", "2", "0", "469", "1", "5.840000000000", "458"),("204263", "1", "0", "487", "1", "35.225600000000", "459"),("47184", "2", "0", "341", "1", "12.440000000000", "460"),("47188", "2", "0", "341", "1", "12.440000000000", "461"),("47198", "2", "0", "341", "1", "12.440000000000", "462"),("47207", "2", "0", "341", "1", "12.440000000000", "463"),("47210", "2", "0", "341", "1", "12.440000000000", "464"),("47220", "2", "0", "341", "1", "12.440000000000", "465"),("222816", "1", "0", "370", "1", "19.710000000000", "466"),("142753", "2", "0", "531", "1", "28.570000000000", "467"),("5829", "2", "0", "42", "1", "40.000000000000", "468"),("220643", "1", "0", "749", "1", "2.520000000000", "469"),("192809", "1", "0", "121", "1", "59.450000000000", "470"),("192811", "1", "0", "121", "1", "59.450000000000", "471"),("127669", "1", "0", "50", "1", "226.000000000000", "472"),("127671", "1", "0", "50", "1", "135.000000000000", "473")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.101)
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.190)
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.095)
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.112)
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.097)
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.120)
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
11 (0.096)
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.097)
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.921)
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.095)
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.166)
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 (7.546)
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.132)
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