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 imediată!

49,96Lei

Grub Fanatik Viper 2.9 74mm 003 Maple Syrup

Grub Fanatik Viper 2.9 74mm 003 Maple Syrup

801134003
Livrare 48-72 ore

9,88Lei

Carlige Fanatik FK-1010 No.14 Chika 8 buc/plic -52%

Carlige Fanatik FK-1010 No.14 Chika 8 buc/plic

120113fk101014
Livrare imediată!

5,50Lei(-52%) 2,64Lei

Carlig Fanatik FK-1092 No.5 Aji-Feeder 8buc/plic -52%

Carlig Fanatik FK-1092 No.5 Aji-Feeder 8buc/plic

120113fk10925
Livrare imediată!

5,50Lei(-52%) 2,64Lei

Carlige Fanatik FK-9501 No.10 Classik 8buc/plic -29%

Carlige Fanatik FK-9501 No.10 Classik 8buc/plic

120113fk950110
Livrare imediată!

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

Carlige Fanatik FX-31 No.2 Worm 6 buc/plic -29%

Carlige Fanatik FX-31 No.2 Worm 6 buc/plic

120713fx312
Livrare imediată!

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

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

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

120113fk11182
Livrare imediată!

5,50Lei(-52%) 2,64Lei

Carlig Fanatik FF-22G No.6 Feeder Gold 8buc/plic

Carlig Fanatik FF-22G No.6 Feeder Gold 8buc/plic

120113ff22g6
Livrare imediată!

5,50Lei

Carlige Fanatik FK-1014 No.11 Joker 8buc/plic -52%

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

120113fk101411
Livrare imediată!

5,50Lei(-52%) 2,64Lei

Carlige Fanatik FK-1074 No.4, 10buc/pac

Carlige Fanatik FK-1074 No.4, 10buc/pac

120713fk1074bl4
Livrare imediată!

5,50Lei

Cap Jig Articulat Fanatik Vezdekhod 5gr Pink 5buc/plic

Cap Jig Articulat Fanatik Vezdekhod 5gr Pink 5buc/plic

41713cfv00805
Livrare imediată!

6,74Lei

Shad Fanatik Classic 2.9 74mm 006 Green Pumpkin Brown

Shad Fanatik Classic 2.9 74mm 006 Green Pumpkin Brown

801131506
Livrare 48-72 ore

9,88Lei

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

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

120113fk10006r7
Livrare imediată!

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

Carlige Fanatik FK-9200 No.10 8buc/plic -33%

Carlige Fanatik FK-9200 No.10 8buc/plic

120113fk9200bl10
Livrare imediată!

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

Carlige Fanatik FK-9005 No.10 Universal 8buc/plic -33%

Carlige Fanatik FK-9005 No.10 Universal 8buc/plic

120513fk900510
Livrare imediată!

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

Creatura Fanatik Lobster 001 Swamp Green 0.84gr 5.6cm 8buc/plic

Creatura Fanatik Lobster 001 Swamp Green 0.84gr 5.6cm 8buc/plic

801131701
Livrare imediată!

14,54Lei

Grub Fanatik Viper 2.9 74mm 005 Moss Green

Grub Fanatik Viper 2.9 74mm 005 Moss Green

801134005
Livrare imediată!

9,88Lei

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

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

120113fk100068
Livrare imediată!

5,50Lei

Carlige Fanatik FK-1127 No.5 Super 8buc/plic -27%

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

120113fk11275
Livrare imediată!

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

Afişare 1 - 20 din 161 (9 pagini)
Queries: 7, Total time: 50.443 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = 'b7096c3d034469c891393541c4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fanatik.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.089)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (22.282)
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 = '3' AND p.manufacturer_id = '493'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (27.717)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 = '3' 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:440
7 (0.110)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37