Fanatik


Fir textil Fanatik Feeder PE Braided Green 0.10mm 4.5kg 140m

Fir textil Fanatik Feeder PE Braided Green 0.10mm 4.5kg 140m

110813fpex414004g
Livrare imediată!

49,96Lei

Fir textil Fanatik Feeder PE Braided Green 0.12mm 5.4kg 140m

Fir textil Fanatik Feeder PE Braided Green 0.12mm 5.4kg 140m

110813fpex414006g
Livrare 48-72 ore

49,96Lei

Fir textil Fanatik Feeder PE Braided Green 0.14mm 6.8kg 140m

Fir textil Fanatik Feeder PE Braided Green 0.14mm 6.8kg 140m

110813fpex414008g
Livrare 48-72 ore

49,96Lei

Grub Fanatik Viper 2.9 74mm 008 Purple Nebula

Grub Fanatik Viper 2.9 74mm 008 Purple Nebula

801134008
Livrare imediată!

9,88Lei

Carlige, Fanatik, , FK-1118, No.2, Gardon, 8, buc/plic, 120113fk11182, Carlige Stationar, Carlige Stationar Fanatik, Carlige Fanatik, Stationar Fanatik, Fanatik -29%
Carlige Fanatik FF-22 No.8 Feeder 9buc/plic -33%

Carlige Fanatik FF-22 No.8 Feeder 9buc/plic

120113ff228
Stoc epuizat

5,50Lei(-33%) 3,67Lei

Carlige, Fanatik, FK-1127, No.4, Super, 8buc/plic, 120113fk11274, Carlige Stationar, Carlige Stationar Fanatik, Fanatik -33%

Carlige, Fanatik, FK-1127, No.4, Super, 8buc/plic, 120113fk11274, Carlige Stationar, Carlige Stationar Fanatik, Fanatik

120113fk11274
Livrare imediată!

5,50Lei(-33%) 3,67Lei

Carlige, Fanatik, FK-1026, No.4, Carp, Profi, 8buc/plic, 120513fk10264, Carlige Crap, Carlige Crap Fanatik, Carlige Stationar, Carlige Stationar Fanatik, Fanatik -33%
Carlige Fanatik FK-10091 No.5 8buc/plic

Carlige Fanatik FK-10091 No.5 8buc/plic

120713fk100915
Livrare imediată!

5,50Lei

Creatura Fanatik Lobster 008 Purple Nebula 0.84gr 5.6cm 8buc/plic

Creatura Fanatik Lobster 008 Purple Nebula 0.84gr 5.6cm 8buc/plic

801131708
Livrare imediată!

11,75Lei

Grub Fanatik Boxer 3 75mm 005 Moss Green

Grub Fanatik Boxer 3 75mm 005 Moss Green

801132005
Livrare 48-72 ore

9,88Lei

Carlige Fanatik FK-1003 No.4 Killer Karas 9 buc/plic

Carlige Fanatik FK-1003 No.4 Killer Karas 9 buc/plic

120113fk10034
Livrare imediată!

5,50Lei

Carlige Fanatik FK-10006R No.3 Sode Red 8 buc/plic -27%

Carlige Fanatik FK-10006R No.3 Sode Red 8 buc/plic

120113fk10006r3
Livrare imediată!

5,50Lei(-27%) 4,01Lei

Carlig, Fanatik, FK-1092, No.4, Aji-Feeder, 8buc/plic, 120113fk10924, Carlige Feeder, Carlige Feeder Fanatik, Fanatik
Carlige Fanatik FK-1014 No.13 Joker 8buc/plic

Carlige Fanatik FK-1014 No.13 Joker 8buc/plic

120113fk101413
Livrare imediată!

5,50Lei

Carlige Fanatik FK-1078 No.6 Fart 8buc/plic -29%

Carlige Fanatik FK-1078 No.6 Fart 8buc/plic

120513fk10786
Livrare imediată!

5,50Lei(-29%) 3,90Lei

Carlige, Fanatik, FK-9115, No.12, Goby, , 8buc/plic, 120713fk911512, Carlige Rapitor, Carlige Rapitor Fanatik, Carlige Stationar, Carlige Stationar Fanatik, Fanatik
Shad Fanatik Classic 1.7 43mm 021 Plum UV

Shad Fanatik Classic 1.7 43mm 021 Plum UV

801131421
Livrare 48-72 ore

9,88Lei

Carlige Fanatik FK-10006 No.5 Sode 10buc/plic -33%

Carlige Fanatik FK-10006 No.5 Sode 10buc/plic

120113fk100065
Livrare imediată!

5,50Lei(-33%) 3,67Lei

Carlige, Fanatik, FK-1093, No.4, Aji, 8buc/plic, 120113fk10934, Carlige Stationar, Carlige Stationar Fanatik, Fanatik
Afişare 1 - 20 din 218 (11 pagini)
Queries: 8, Total time: 48.918 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'd380f7e5c983570afabc964049'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fanatik.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '493' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (22.200)
SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '493'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (26.073)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '493' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.134)
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
8 (0.124)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38