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


Exclusiv online!

56,82Lei

12,08Lei

11,17Lei

Exclusiv online!

12,08Lei

9,99Lei(-10%) 9,03Lei

Vobler Sakura Notobug 22F, DR Albastru, 1.4g, 2.2cm

80234saplb503922dr
Livrare imediată!

45,74Lei

Vobler Sakura Notobug 30F, DR Albastru, 3.5g, 3cm

80234saplb503930dr
Livrare imediată!

49,80Lei

Exclusiv online!

CARLIGE TRABUCCO HISASHI HOOK 3282 nr 2

024-14-020
Livrare 48-72 ore

14,12Lei

Exclusiv online!

54,56Lei(-35%) 35,21Lei

Exclusiv online!

Vobler JACKALL Chubby 38F MR, Ayu, 3.8cm, 4.2g

ja.807177909
Livrare 24-48 ore

94,37Lei

Exclusiv online!

Vobler JACKALL Chubby 38F MR, Bone, 3.8cm, 4.2g

ja.807177923
Livrare 24-48 ore

94,37Lei

Carlige Mivardi M-325, 10buc/plic Nr.18

m-hm32518
Livrare imediată!

9,14Lei

54,56Lei(-37%) 34,28Lei

46,04Lei(-45%) 25,33Lei

Vobler Rapture Bayliner DR SF, BIW, 10.6g, 7.8cm

180-45-324
Livrare imediată!

39,64Lei

CARLIGE TRABUCCO AKURA 6001 NR 2 15BUC/PLIC

025-10-020
Livrare imediată!

9,03Lei

CARLIGE TRABUCCO AKURA 145BN NR 2 15BUC/PLIC

026-45-020
Livrare imediată!

14,12Lei

Exclusiv online!

CARLIGE TRABUCCO AKURA 535N NR 2 15BUC/PLIC

025-45-020
Livrare 48-72 ore

12,08Lei

Exclusiv online!

CARLIGE TRABUCCO AKURA 200BN NR 2 15BUC/PLIC

025-70-020
Livrare 48-72 ore

13,10Lei

Exclusiv online!

CARLIGE TRABUCCO AKURA 220BR NR 2 15BUC/PLIC

025-95-020
Livrare 48-72 ore

10,06Lei

Afişare 1 - 20 din 368 (19 pagini)
Queries: 11, Total time: 5.848 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = 'a88f9c25977bb7754477a77a46'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.127)
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.939)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("162903", "1", "1000", "462", "1", "46.960000000000", "1"),("108439", "1", "1001", "58", "1", "9.980000000000", "2"),("95991", "2", "1002", "58", "1", "9.230000000000", "3"),("95993", "2", "1000", "58", "1", "9.980000000000", "4"),("95990", "2", "4", "58", "1", "7.460000000000", "5"),("199281", "2", "1002", "123", "1", "37.800000000000", "6"),("199287", "2", "1001", "123", "1", "41.160000000000", "7"),("94177", "2", "1000", "58", "1", "11.670000000000", "8"),("37330", "2", "1000", "85", "1", "29.100000000000", "9"),("228567", "1", "1000", "150", "1", "77.990000000000", "10"),("228568", "1", "1000", "150", "1", "77.990000000000", "11"),("96504", "2", "2", "98", "1", "7.550000000000", "12"),("37334", "2", "2", "85", "1", "28.330000000000", "13"),("70669", "2", "1004", "85", "1", "20.930000000000", "14"),("199679", "1", "1002", "105", "1", "32.760000000000", "15"),("104923", "2", "1001", "58", "1", "7.460000000000", "16"),("105043", "2", "1001", "58", "1", "11.670000000000", "17"),("104996", "2", "1000", "58", "1", "9.980000000000", "18"),("105006", "2", "1000", "58", "1", "10.830000000000", "19"),("105023", "2", "1000", "58", "1", "8.310000000000", "20"),("105029", "2", "1000", "58", "1", "10.830000000000", "21"),("37308", "2", "1000", "85", "1", "28.110000000000", "22"),("228566", "1", "1000", "150", "1", "77.990000000000", "23"),("228569", "1", "1000", "150", "1", "77.990000000000", "24"),("104914", "2", "6", "58", "1", "7.460000000000", "25"),("92960", "2", "1000", "85", "1", "28.110000000000", "26"),("105040", "2", "1000", "58", "1", "9.980000000000", "27"),("177679", "1", "1000", "58", "1", "23.430000000000", "28"),("240743", "1", "1000", "192", "1", "1454.520000000000", "29"),("228570", "1", "1000", "150", "1", "77.990000000000", "30"),("36720", "2", "1003", "19", "1", "25.810000000000", "31"),("237298", "1", "1000", "19", "1", "28.810000000000", "32"),("237299", "1", "1000", "19", "1", "28.810000000000", "33"),("237300", "1", "1000", "19", "1", "28.810000000000", "34"),("65238", "2", "6", "103", "1", "14.360000000000", "35"),("65239", "2", "5", "103", "1", "12.840000000000", "36"),("65240", "2", "5", "103", "1", "12.840000000000", "37"),("65237", "2", "4", "103", "1", "13.600000000000", "38"),("30673", "2", "1000", "49", "1", "11.670000000000", "39"),("176854", "1", "1000", "42", "1", "21.830000000000", "40"),("176860", "1", "1000", "42", "1", "22.680000000000", "41"),("65428", "2", "1", "103", "1", "18.810000000000", "42"),("9140", "2", "1003", "105", "1", "8.310000000000", "43"),("9141", "2", "1003", "105", "1", "9.150000000000", "44"),("30669", "2", "1001", "49", "1", "26.790000000000", "45"),("19309", "2", "1001", "42", "1", "7.970000000000", "46"),("9142", "2", "1000", "105", "1", "9.150000000000", "47"),("9143", "2", "1000", "105", "1", "10.830000000000", "48"),("9144", "2", "1000", "105", "1", "10.830000000000", "49"),("19275", "2", "1000", "42", "1", "7.130000000000", "50"),("19282", "2", "1000", "42", "1", "7.970000000000", "51"),("65430", "2", "3", "103", "1", "18.810000000000", "52"),("65431", "2", "2", "103", "1", "18.810000000000", "53"),("119595", "2", "1000", "58", "1", "13.770000000000", "54"),("79618", "2", "1000", "42", "1", "8.390000000000", "55"),("51225", "2", "1000", "42", "1", "9.230000000000", "56"),("51244", "2", "1000", "42", "1", "7.130000000000", "57"),("51257", "2", "1000", "42", "1", "8.390000000000", "58"),("119274", "2", "1002", "105", "1", "8.310000000000", "59"),("119275", "2", "1000", "105", "1", "9.140000000000", "60"),("119276", "2", "1000", "105", "1", "9.150000000000", "61"),("119277", "2", "1000", "105", "1", "10.830000000000", "62"),("119278", "2", "1000", "105", "1", "10.830000000000", "63"),("30691", "2", "1000", "49", "1", "15.700000000000", "64"),("107664", "1", "4", "58", "1", "7.460000000000", "65"),("42359", "2", "1001", "67", "1", "8.730000000000", "66"),("64428", "2", "5", "103", "1", "17.340000000000", "67"),("64443", "2", "4", "103", "1", "20.320000000000", "68"),("64430", "2", "2", "103", "1", "17.340000000000", "69"),("169978", "2", "1001", "224", "1", "13.350000000000", "70"),("169972", "2", "1000", "224", "1", "12.500000000000", "71"),("169973", "2", "1000", "224", "1", "12.500000000000", "72"),("169974", "2", "1000", "224", "1", "12.500000000000", "73"),("93766", "2", "1000", "58", "1", "11.670000000000", "74"),("94175", "2", "1000", "58", "1", "12.880000000000", "75"),("176287", "2", "1000", "423", "1", "11.750000000000", "76"),("176288", "2", "1000", "423", "1", "14.940000000000", "77"),("176294", "2", "1000", "423", "1", "11.750000000000", "78"),("176295", "2", "1000", "423", "1", "14.940000000000", "79"),("176301", "2", "1000", "423", "1", "11.750000000000", "80"),("94173", "2", "4", "58", "1", "9.980000000000", "81"),("94172", "2", "3", "58", "1", "13.350000000000", "82"),("94174", "2", "2", "58", "1", "9.980000000000", "83"),("94180", "2", "1005", "58", "1", "9.150000000000", "84"),("94179", "2", "1003", "58", "1", "8.390000000000", "85"),("104621", "1", "1001", "58", "1", "15.020000000000", "86"),("8918", "2", "1000", "58", "1", "14.190000000000", "87"),("8919", "2", "1000", "58", "1", "14.190000000000", "88"),("94176", "2", "1000", "58", "1", "12.500000000000", "89"),("94178", "2", "1000", "58", "1", "11.670000000000", "90"),("94181", "2", "1000", "58", "1", "9.150000000000", "91"),("104622", "1", "1000", "58", "1", "15.020000000000", "92"),("104623", "1", "1000", "58", "1", "15.020000000000", "93"),("104624", "1", "1000", "58", "1", "15.020000000000", "94"),("104625", "1", "1000", "58", "1", "15.020000000000", "95"),("108302", "1", "1000", "58", "1", "20.070000000000", "96"),("108353", "1", "1000", "58", "1", "30.990000000000", "97"),("5497", "2", "5", "103", "1", "15.830000000000", "98"),("48147", "2", "1034", "58", "1", "13.430000000000", "99"),("48148", "2", "1030", "58", "1", "13.430000000000", "100"),("48149", "2", "1023", "58", "1", "13.430000000000", "101"),("108438", "1", "1021", "58", "1", "13.430000000000", "102"),("48160", "2", "1015", "58", "1", "13.430000000000", "103"),("104976", "2", "1014", "58", "1", "9.150000000000", "104"),("48152", "2", "1014", "58", "1", "13.430000000000", "105"),("190201", "1", "1014", "58", "1", "13.770000000000", "106"),("105021", "2", "1012", "58", "1", "6.630000000000", "107"),("104618", "1", "1010", "58", "1", "15.120000000000", "108"),("104917", "2", "1010", "58", "1", "7.460000000000", "109"),("108437", "1", "1010", "58", "1", "13.430000000000", "110"),("104920", "2", "1009", "58", "1", "7.460000000000", "111"),("104936", "2", "1009", "58", "1", "7.460000000000", "112"),("48154", "2", "1009", "58", "1", "13.430000000000", "113"),("48166", "2", "1009", "58", "1", "13.430000000000", "114"),("104918", "2", "1008", "58", "1", "7.460000000000", "115"),("104935", "2", "1008", "58", "1", "7.460000000000", "116"),("105016", "2", "1008", "58", "1", "6.630000000000", "117"),("105018", "2", "1008", "58", "1", "6.630000000000", "118"),("104934", "2", "1006", "58", "1", "7.460000000000", "119"),("105003", "2", "1006", "58", "1", "7.460000000000", "120"),("48153", "2", "1006", "58", "1", "13.430000000000", "121"),("104626", "1", "1005", "58", "1", "15.020000000000", "122"),("104977", "2", "1005", "58", "1", "9.150000000000", "123"),("48165", "2", "1005", "58", "1", "13.430000000000", "124"),("177038", "2", "1005", "289", "1", "19.310000000000", "125"),("104630", "1", "1004", "58", "1", "14.270000000000", "126"),("104855", "2", "1004", "58", "1", "15.020000000000", "127"),("104988", "2", "1004", "58", "1", "8.310000000000", "128"),("48163", "2", "1004", "58", "1", "13.430000000000", "129"),("104629", "1", "1003", "58", "1", "15.020000000000", "130"),("104849", "2", "1003", "58", "1", "15.020000000000", "131"),("104919", "2", "1003", "58", "1", "7.460000000000", "132"),("104921", "2", "1003", "58", "1", "7.460000000000", "133"),("104922", "2", "1003", "58", "1", "7.460000000000", "134"),("105002", "2", "1003", "58", "1", "7.460000000000", "135"),("105005", "2", "1003", "58", "1", "7.460000000000", "136"),("48164", "2", "1003", "58", "1", "14.190000000000", "137"),("104615", "1", "1002", "58", "1", "15.870000000000", "138"),("104628", "1", "1002", "58", "1", "14.270000000000", "139"),("104845", "2", "1002", "58", "1", "15.020000000000", "140"),("104851", "2", "1002", "58", "1", "15.020000000000", "141"),("104915", "2", "1002", "58", "1", "7.460000000000", "142"),("105044", "2", "1002", "58", "1", "9.980000000000", "143"),("48146", "2", "1002", "58", "1", "13.430000000000", "144"),("48167", "2", "1002", "58", "1", "14.190000000000", "145"),("48168", "2", "1002", "58", "1", "14.190000000000", "146"),("104610", "1", "1001", "58", "1", "15.020000000000", "147"),("104614", "1", "1001", "58", "1", "15.870000000000", "148"),("104617", "1", "1001", "58", "1", "15.870000000000", "149"),("104627", "1", "1001", "58", "1", "14.270000000000", "150"),("104846", "2", "1001", "58", "1", "15.020000000000", "151"),("104856", "2", "1001", "58", "1", "15.020000000000", "152"),("104926", "2", "1001", "58", "1", "7.460000000000", "153"),("104986", "2", "1001", "58", "1", "9.980000000000", "154"),("105004", "2", "1001", "58", "1", "7.460000000000", "155"),("105011", "2", "1001", "58", "1", "9.150000000000", "156"),("105046", "2", "1001", "58", "1", "9.150000000000", "157"),("222594", "1", "1001", "58", "1", "16.710000000000", "158"),("222595", "1", "1001", "58", "1", "16.710000000000", "159"),("104611", "1", "1000", "58", "1", "15.020000000000", "160"),("104612", "1", "1000", "58", "1", "15.020000000000", "161"),("104613", "1", "1000", "58", "1", "15.870000000000", "162"),("104616", "1", "1000", "58", "1", "15.870000000000", "163"),("104620", "1", "1000", "58", "1", "15.870000000000", "164"),("104633", "2", "1000", "58", "1", "16.710000000000", "165"),("104634", "2", "1000", "58", "1", "16.710000000000", "166"),("104635", "2", "1000", "58", "1", "15.870000000000", "167"),("104636", "2", "1000", "58", "1", "15.870000000000", "168"),("104637", "2", "1000", "58", "1", "15.020000000000", "169"),("104843", "2", "1000", "58", "1", "15.020000000000", "170"),("104844", "2", "1000", "58", "1", "15.020000000000", "171"),("104847", "2", "1000", "58", "1", "15.020000000000", "172"),("104848", "2", "1000", "58", "1", "15.020000000000", "173"),("104850", "2", "1000", "58", "1", "15.020000000000", "174"),("104854", "2", "1000", "58", "1", "15.020000000000", "175"),("104924", "2", "1000", "58", "1", "7.460000000000", "176"),("104927", "2", "1000", "58", "1", "7.460000000000", "177"),("104928", "2", "1000", "58", "1", "8.310000000000", "178"),("104929", "2", "1000", "58", "1", "8.310000000000", "179"),("104930", "2", "1000", "58", "1", "7.460000000000", "180"),("104931", "2", "1000", "58", "1", "7.460000000000", "181"),("104932", "2", "1000", "58", "1", "7.460000000000", "182"),("104938", "2", "1000", "58", "1", "7.460000000000", "183"),("104960", "2", "1000", "58", "1", "7.460000000000", "184"),("104964", "2", "1000", "58", "1", "7.460000000000", "185"),("104968", "2", "1000", "58", "1", "9.980000000000", "186"),("104969", "2", "1000", "58", "1", "9.980000000000", "187"),("104970", "2", "1000", "58", "1", "9.980000000000", "188"),("104978", "2", "1000", "58", "1", "9.150000000000", "189"),("104989", "2", "1000", "58", "1", "8.310000000000", "190"),("104995", "2", "1000", "58", "1", "9.980000000000", "191"),("104997", "2", "1000", "58", "1", "9.980000000000", "192"),("104998", "2", "1000", "58", "1", "9.150000000000", "193"),("104999", "2", "1000", "58", "1", "9.150000000000", "194"),("105000", "2", "1000", "58", "1", "9.150000000000", "195"),("105009", "2", "1000", "58", "1", "9.980000000000", "196"),("105010", "2", "1000", "58", "1", "9.980000000000", "197"),("105012", "2", "1000", "58", "1", "9.150000000000", "198"),("105015", "2", "1000", "58", "1", "6.630000000000", "199"),("105020", "2", "1000", "58", "1", "6.630000000000", "200"),("105022", "2", "1000", "58", "1", "8.310000000000", "201"),("105028", "2", "1000", "58", "1", "10.830000000000", "202"),("105030", "2", "1000", "58", "1", "10.830000000000", "203"),("105031", "2", "1000", "58", "1", "10.830000000000", "204"),("105034", "2", "1000", "58", "1", "9.980000000000", "205"),("105045", "2", "1000", "58", "1", "9.150000000000", "206"),("177034", "2", "1000", "289", "1", "19.310000000000", "207"),("177036", "2", "1000", "289", "1", "19.310000000000", "208"),("177037", "2", "1000", "289", "1", "19.310000000000", "209"),("119571", "2", "1000", "58", "1", "13.770000000000", "210"),("119572", "2", "1000", "58", "1", "13.770000000000", "211"),("119573", "2", "1000", "58", "1", "13.770000000000", "212"),("119574", "2", "1000", "58", "1", "13.770000000000", "213"),("108585", "1", "1000", "58", "1", "26.790000000000", "214"),("222596", "1", "1000", "58", "1", "16.710000000000", "215"),("222597", "1", "1000", "58", "1", "16.710000000000", "216"),("222598", "1", "1000", "58", "1", "16.710000000000", "217"),("222599", "1", "1000", "58", "1", "16.710000000000", "218"),("222600", "1", "1000", "58", "1", "16.710000000000", "219"),("222601", "1", "1000", "58", "1", "16.710000000000", "220"),("222602", "1", "1000", "58", "1", "16.710000000000", "221"),("222603", "1", "1000", "58", "1", "16.710000000000", "222"),("104975", "2", "10", "58", "1", "9.150000000000", "223"),("105017", "2", "8", "58", "1", "5.870000000000", "224"),("104937", "2", "6", "58", "1", "7.460000000000", "225"),("104619", "1", "4", "58", "1", "15.120000000000", "226"),("104974", "2", "3", "58", "1", "9.150000000000", "227"),("104925", "2", "1", "58", "1", "7.460000000000", "228"),("104961", "2", "1", "58", "1", "7.460000000000", "229"),("95989", "2", "1004", "58", "1", "13.430000000000", "230"),("95987", "2", "1003", "58", "1", "14.190000000000", "231"),("104861", "2", "1002", "58", "1", "15.020000000000", "232"),("104862", "2", "1001", "58", "1", "15.020000000000", "233"),("105049", "2", "1001", "58", "1", "13.350000000000", "234"),("95988", "2", "1000", "58", "1", "14.190000000000", "235"),("96857", "2", "1000", "58", "1", "11.670000000000", "236"),("104857", "2", "1000", "58", "1", "15.020000000000", "237"),("104858", "2", "1000", "58", "1", "15.020000000000", "238"),("104859", "2", "1000", "58", "1", "15.020000000000", "239"),("104860", "2", "1000", "58", "1", "15.020000000000", "240"),("104913", "2", "1000", "58", "1", "11.670000000000", "241"),("104981", "2", "1000", "58", "1", "11.670000000000", "242"),("105042", "2", "1000", "58", "1", "9.980000000000", "243"),("105048", "2", "1000", "58", "1", "18.390000000000", "244"),("105050", "2", "1000", "58", "1", "12.600000000000", "245"),("177680", "1", "1000", "58", "1", "20.070000000000", "246"),("177681", "1", "1000", "58", "1", "19.230000000000", "247"),("177682", "1", "1000", "58", "1", "18.390000000000", "248"),("177683", "1", "1000", "58", "1", "18.390000000000", "249"),("177684", "1", "1000", "58", "1", "18.390000000000", "250"),("177685", "1", "1000", "58", "1", "18.390000000000", "251"),("108275", "1", "1000", "58", "1", "17.550000000000", "252"),("108294", "1", "1000", "58", "1", "11.670000000000", "253"),("108298", "1", "1000", "58", "1", "15.020000000000", "254"),("119189", "2", "1000", "105", "1", "9.560000000000", "255"),("5498", "2", "5", "103", "1", "15.830000000000", "256"),("5499", "2", "4", "103", "1", "15.830000000000", "257"),("107828", "1", "1004", "58", "1", "17.550000000000", "258"),("104911", "2", "1002", "58", "1", "9.980000000000", "259"),("246827", "1", "1002", "809", "1", "26.030000000000", "260"),("104910", "2", "1000", "58", "1", "9.980000000000", "261"),("104912", "2", "1000", "58", "1", "9.980000000000", "262"),("105037", "2", "1000", "58", "1", "11.670000000000", "263"),("105051", "2", "1000", "58", "1", "15.020000000000", "264"),("105054", "2", "1000", "58", "1", "15.020000000000", "265"),("35454", "2", "1000", "105", "1", "23.430000000000", "266"),("105036", "2", "14", "58", "1", "11.670000000000", "267"),("136971", "2", "2", "67", "1", "17.130000000000", "268"),("96293", "2", "1", "67", "1", "16.290000000000", "269"),("125659", "2", "1002", "289", "1", "13.430000000000", "270"),("161781", "1", "1000", "58", "1", "12.420000000000", "271"),("233937", "1", "1000", "104", "1", "13.350000000000", "272"),("125701", "2", "2", "289", "1", "13.430000000000", "273"),("125705", "2", "2", "289", "1", "13.430000000000", "274"),("8921", "2", "1", "58", "1", "12.600000000000", "275"),("125681", "2", "1", "289", "1", "13.430000000000", "276"),("48171", "2", "1007", "58", "1", "13.430000000000", "277"),("48169", "2", "1005", "58", "1", "13.430000000000", "278"),("48170", "2", "1003", "58", "1", "13.430000000000", "279"),("150205", "1", "1000", "58", "1", "15.020000000000", "280"),("150207", "1", "1000", "58", "1", "15.020000000000", "281"),("107812", "1", "1000", "58", "1", "15.870000000000", "282"),("200071", "2", "1000", "224", "1", "12.090000000000", "283"),("158185", "2", "1007", "58", "1", "14.270000000000", "284"),("158189", "2", "1007", "58", "1", "14.270000000000", "285"),("158187", "2", "1006", "58", "1", "14.270000000000", "286"),("107831", "1", "1001", "58", "1", "7.970000000000", "287"),("158191", "2", "1000", "58", "1", "15.020000000000", "288"),("158199", "2", "1011", "58", "1", "10.320000000000", "289"),("158193", "2", "1009", "58", "1", "15.020000000000", "290"),("119585", "2", "1006", "58", "1", "13.430000000000", "291"),("119596", "2", "1006", "58", "1", "13.430000000000", "292"),("158197", "2", "1004", "58", "1", "15.020000000000", "293"),("119580", "2", "1004", "58", "1", "13.430000000000", "294"),("119584", "2", "1004", "58", "1", "13.430000000000", "295"),("119583", "2", "1003", "58", "1", "13.430000000000", "296"),("119575", "2", "1000", "58", "1", "13.770000000000", "297"),("119576", "2", "1000", "58", "1", "13.770000000000", "298"),("119577", "2", "1000", "58", "1", "13.770000000000", "299"),("119578", "2", "1000", "58", "1", "13.770000000000", "300"),("119579", "2", "1000", "58", "1", "13.770000000000", "301"),("119581", "2", "1000", "58", "1", "14.190000000000", "302"),("119582", "2", "1000", "58", "1", "14.190000000000", "303"),("119586", "2", "1000", "58", "1", "14.190000000000", "304"),("119587", "2", "1000", "58", "1", "14.190000000000", "305"),("119588", "2", "1000", "58", "1", "13.770000000000", "306"),("119597", "2", "1000", "58", "1", "14.190000000000", "307"),("200229", "1", "1000", "224", "1", "6.630000000000", "308"),("200243", "2", "1000", "224", "1", "11.670000000000", "309"),("158195", "2", "1000", "58", "1", "13.450000000000", "310"),("107716", "1", "1009", "58", "1", "8.310000000000", "311"),("119589", "2", "1000", "58", "1", "14.190000000000", "312"),("119590", "2", "1000", "58", "1", "14.190000000000", "313"),("119591", "2", "1000", "58", "1", "14.190000000000", "314"),("119592", "2", "1000", "58", "1", "14.190000000000", "315"),("119593", "2", "1000", "58", "1", "14.190000000000", "316"),("119594", "2", "1000", "58", "1", "13.770000000000", "317"),("107709", "1", "1000", "58", "1", "8.310000000000", "318"),("48144", "2", "1015", "58", "1", "13.430000000000", "319"),("48145", "2", "1008", "58", "1", "13.430000000000", "320"),("48151", "2", "1001", "58", "1", "14.270000000000", "321"),("48150", "2", "18", "58", "1", "13.430000000000", "322"),("107699", "1", "1000", "58", "1", "18.390000000000", "323"),("119599", "2", "1001", "58", "1", "13.770000000000", "324"),("119598", "2", "1000", "58", "1", "14.190000000000", "325"),("246414", "1", "1000", "224", "1", "81.410000000000", "326"),("246416", "1", "1000", "224", "1", "77.210000000000", "327"),("94171", "2", "0", "58", "1", "9.000000000000", "328"),("96499", "2", "0", "98", "1", "4.800000000000", "329"),("5472", "2", "0", "103", "1", "7.500000000000", "330"),("65429", "2", "0", "103", "1", "12.000000000000", "331"),("130605", "1", "0", "285", "1", "70.490000000000", "332"),("104667", "2", "0", "42", "1", "6.000000000000", "333"),("95492", "2", "0", "19", "1", "10.730000000000", "334"),("42361", "2", "0", "67", "1", "6.350000000000", "335"),("169979", "2", "0", "224", "1", "7.100000000000", "336"),("93768", "2", "0", "58", "1", "11.670000000000", "337"),("94170", "2", "0", "58", "1", "9.000000000000", "338"),("34363", "2", "0", "289", "1", "8.660000000000", "339"),("108313", "1", "0", "58", "1", "17.000000000000", "340"),("108339", "1", "0", "58", "1", "15.000000000000", "341"),("108347", "1", "0", "58", "1", "16.000000000000", "342"),("189411", "2", "0", "58", "1", "8.320000000000", "343"),("104962", "2", "0", "58", "1", "6.710000000000", "344"),("104963", "2", "0", "58", "1", "6.710000000000", "345"),("105001", "2", "0", "58", "1", "8.310000000000", "346"),("105025", "2", "0", "58", "1", "8.310000000000", "347"),("105026", "2", "0", "58", "1", "8.310000000000", "348"),("105035", "2", "0", "58", "1", "5.800000000000", "349"),("167670", "1", "0", "58", "1", "7.600000000000", "350"),("119187", "2", "0", "105", "1", "6.800000000000", "351"),("105041", "2", "0", "58", "1", "4.110000000000", "352"),("105038", "2", "0", "58", "1", "4.940000000000", "353"),("105055", "2", "0", "58", "1", "12.600000000000", "354"),("105056", "2", "0", "58", "1", "12.600000000000", "355"),("202195", "2", "0", "67", "1", "15.950000000000", "356"),("202197", "2", "0", "67", "1", "16.790000000000", "357"),("171406", "2", "0", "648", "1", "13.430000000000", "358"),("125677", "2", "0", "289", "1", "9.134000000000", "359"),("125679", "2", "0", "289", "1", "8.660000000000", "360"),("125683", "2", "0", "289", "1", "9.134000000000", "361"),("125707", "2", "0", "289", "1", "8.660000000000", "362"),("125723", "2", "0", "289", "1", "8.660000000000", "363"),("125725", "2", "0", "289", "1", "8.660000000000", "364"),("200061", "2", "0", "224", "1", "6.520000000000", "365"),("231454", "1", "0", "224", "1", "5.750000000000", "366"),("200237", "2", "0", "224", "1", "9.980000000000", "367"),("200245", "2", "0", "224", "1", "11.670000000000", "368")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.123)
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.198)
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.493)
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.101)
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 (3.399)
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.123)
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