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

Carlige Fanatik FK-1026 No.4 Carp Profi 8buc/plic -33%

Carlige Fanatik FK-1026 No.4 Carp Profi 8buc/plic

120513fk10264
Livrare imediată!

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

Carlige, Fanatik, FK-10091, No.5, 8buc/plic, 120713fk100915, Carlige Rapitor, Carlige Rapitor Fanatik, Carlige Fanatik, Rapitor Fanatik, Carlige Stationar, Carlige Stationar Fanatik, Carlige Fanatik, Stationar Fanatik, Fanatik
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 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 -29%

Carlige Fanatik FK-1118 No.2 Gardon 8 buc/plic

120113fk11182
Livrare imediată!

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

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 -33%

Carlige Fanatik FK-1127 No.4 Super 8buc/plic

120113fk11274
Livrare imediată!

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

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

Carlige Fanatik FK-9115 No.12 Goby 8buc/plic

120713fk911512
Livrare 48-72 ore

5,50Lei

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, 120113fk10006r3, Carlige Stationar, Carlige Stationar Fanatik, Carlige Fanatik, Stationar Fanatik, Fanatik -27%
Carlig, Fanatik, FK-1092, No.4, Aji-Feeder, 8buc/plic, 120113fk10924, Carlige Feeder, Carlige Feeder Fanatik, Fanatik
Carlige Fanatik FK-1014 No.4 Joker 8buc/plic -29%

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

120113fk10144
Livrare imediată!

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

Carlige, Fanatik, FK-1011, No.13, Carp, 8buc/plic, 120513fk101113, Carlige Crap, Carlige Crap Fanatik, Fanatik

Carlige, Fanatik, FK-1011, No.13, Carp, 8buc/plic, 120513fk101113, Carlige Crap, Carlige Crap Fanatik, Fanatik

120513fk101113
Livrare imediată!

5,50Lei

Carlige Fanatik FX-31 No.12 Worm 8buc/plic

Carlige Fanatik FX-31 No.12 Worm 8buc/plic

120713ff3112
Livrare imediată!

5,50Lei

Afişare 1 - 20 din 218 (11 pagini)
Queries: 8, Total time: 57.621 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '11671e0ad85c595c975e822ea3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fanatik.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (22.884)
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 = '2' AND p.manufacturer_id = '493'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (34.102)
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 = '2' 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.125)
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.114)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38