FL.


Cosulet Feeder FL CS6 30

Cosulet Feeder FL CS6 30

cs6-30
Livrare 48-72 ore

5,20Lei

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 05

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 05

64-80453
Livrare imediată!

11,90Lei

Lanseta Feeder FL Strategist Distance MH 3.90M 80-150G 3Seg

Lanseta Feeder FL Strategist Distance MH 3.90M 80-150G 3Seg

6153210490711
Livrare 48-72 ore

299,90Lei

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 50CM CU FLOATOARE

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 50CM CU FLOATOARE

6427559061032
Livrare imediată!

76,90Lei

Vobler FL FL137B Floating 78mm 8.8g Depth 1.5m Colour 697

Vobler FL FL137B Floating 78mm 8.8g Depth 1.5m Colour 697

fl137b-floating-1.5m-78mm-8.8g-697
Livrare imediată!

17,10Lei

Vobler FL FL510 Floating 36mm 4.0g Depth 1.0m Colour 839

Vobler FL FL510 Floating 36mm 4.0g Depth 1.0m Colour 839

fl510-floating-1.0m-36mm-4.0g-839
Livrare 48-72 ore

17,10Lei

GEANTA PRO FL CU 4 CUTII PLASTIC

GEANTA PRO FL CU 4 CUTII PLASTIC

64-6412
Livrare imediată!

169,90Lei

Momitor Method Feeder FL Tija Interschimbabila Marime M 35g

Momitor Method Feeder FL Tija Interschimbabila Marime M 35g

ak-im35
Livrare imediată!

13,30Lei

FIR TEXTIL FEEDER PRO FL SINKNKING X8 0.28MM 150M 43KG

FIR TEXTIL FEEDER PRO FL SINKNKING X8 0.28MM 150M 43KG

64-4564
Livrare imediată!

51,90Lei

Croseta FL Leadcore Needle Fine 1.27mm

Croseta FL Leadcore Needle Fine 1.27mm

ak-k1.27
Livrare imediată!

6,90Lei

UNDITA PRO FL PRADO 115CM 170G 5.00M

UNDITA PRO FL PRADO 115CM 170G 5.00M

1224242953118
Livrare 48-72 ore

139,90Lei

LANSETA FEEDER PRO FL ULTRA FEEDER 120-180G 3.60M

LANSETA FEEDER PRO FL ULTRA FEEDER 120-180G 3.60M

64-89012
Livrare imediată!

185,90Lei

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Method Barbed Nr 8 6Buc/Set

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Method Barbed Nr 8 6Buc/Set

64-0833
Livrare imediată!

12,38Lei

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ALB ROSU -40%

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ALB ROSU

64-65924
Livrare imediată!

25,00Lei(-40%) 14,90Lei

MULINETA PRO FL STRATEGIST FEEDER PRO AND BAITRUNNER SFB8000

MULINETA PRO FL STRATEGIST FEEDER PRO AND BAITRUNNER SFB8000

64-13635
Livrare 48-72 ore

269,90Lei

Varga FL Tele Success 6 M

Varga FL Tele Success 6 M

309-600
Livrare 48-72 ore

185,90Lei

MONTURA PRO FL LEADCORE INLINE DISTANCE 85G CARLIG NR 8

MONTURA PRO FL LEADCORE INLINE DISTANCE 85G CARLIG NR 8

64-67058
Livrare imediată!

23,90Lei

Pluta Chinezeasca Individuala X-07 Nr 1 2.40Gr

Pluta Chinezeasca Individuala X-07 Nr 1 2.40Gr

7261020083951
Livrare imediată!

37,96Lei

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E M

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E M

64-1968-30-6
Livrare imediată!

12,90Lei

LINGURA PRO FL DEVIL SPOON 16G S002

LINGURA PRO FL DEVIL SPOON 16G S002

64-98434
Livrare imediată!

18,90Lei

Afişare 521 - 540 din 2056 (103 pagini)
Queries: 7, Total time: 101.831 ms [By time] [By id] [By file]
1 (0.164)
SELECT data
FROM `oc_session`
WHERE session_id = '412298807c34258b4b2ea8dde0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.142)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.149)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '13' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (40.089)
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 = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (60.964)
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 = '0' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 520,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.210)
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