FL.


LANSETA CRAP FL FLX22 FAST 3.96M 4.0LBS

LANSETA CRAP FL FLX22 FAST 3.96M 4.0LBS

4004-3902
Livrare imediată!

529,00Lei

CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 6/0 10BUC

CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 6/0 10BUC

64-26390
Livrare imediată!

10,90Lei

LANSETA CRAP PRO FL POWER TELE CARP 3.30M 160-360G

LANSETA CRAP PRO FL POWER TELE CARP 3.30M 160-360G

64-45421
Livrare imediată!

152,90Lei

MONTURA FL FEEDER MFD CU SPIN 50G CARLIG NR 10 SPIN 7MM

MONTURA FL FEEDER MFD CU SPIN 50G CARLIG NR 10 SPIN 7MM

ak-mfd50/10
Livrare imediată!

14,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 04, 64-80446, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Montura FL Leadcore Plumb Pierdut Grippa Plumb 80 Gr Carlig YN Nr 4

Montura FL Leadcore Plumb Pierdut Grippa Plumb 80 Gr Carlig YN Nr 4

clm216175
Livrare imediată!

15,01Lei

Mulineta FL SF 5000

Mulineta FL SF 5000

6262198935616
Livrare imediată!

105,90Lei

Lanseta Bolognesa FL Strategist 7M

Lanseta Bolognesa FL Strategist 7M

5177204231860
Livrare imediată!

399,80Lei

HUSA RIGIDA SIMPLA PRO FL 135CM

HUSA RIGIDA SIMPLA PRO FL 135CM

7224249870412
Livrare imediată!

60,90Lei

Maner Minciog Carbon FL Toreador Telescopic 2.5M

Maner Minciog Carbon FL Toreador Telescopic 2.5M

8153219062788
Livrare imediată!

99,90Lei

Vobler FL FL504 Floating 40mm 5.5g Depth 1.5m Colour 96

Vobler FL FL504 Floating 40mm 5.5g Depth 1.5m Colour 96

fl504-floating-1.5m-40mm-5.5g-96
Livrare imediată!

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.28MM, 150M, 43KG, 64-4564, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder FL., Fire FL., Textile FL., Monofilament FL., Feeder FL., FL.
Vobler, FL, FL601, Sinking, 70mm, 16.0g, Depth, Deepwater, Colour, 356, fl601-sinking-deepwater-70mm-16.0g-356, Voblere Sinking, Voblere Sinking FL., FL.
UNDITA PRO FL PRADO 115CM 170G 5.00M

UNDITA PRO FL PRADO 115CM 170G 5.00M

1224242953118
Livrare imediată!

139,90Lei

Montura, FL, Leadcore, Plumb, Pierdut, Grippa, Plumb, 100, Gr, Carlig, C, Nr, 4, 64-0246, Monturi Crap, Monturi Crap FL., FL.
Mulineta FL Sparkler Feeder 2021 3000

Mulineta FL Sparkler Feeder 2021 3000

64-0965
Livrare imediată!

84,50Lei

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 14 CU SPIN

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 14 CU SPIN

64-65092
Livrare imediată!

17,90Lei

Momitor Method Feeder Inline FL L 20g 1Buc/plic

Momitor Method Feeder Inline FL L 20g 1Buc/plic

64-1991
Livrare imediată!

6,90Lei

Lanseta Feeder FL FLX River 4.20M/100-250GR/3Seg

Lanseta Feeder FL FLX River 4.20M/100-250GR/3Seg

flx-river-feeder-420-100-250
Livrare imediată!

349,90Lei

Porumb, Artificial, Flotant, FL, 20Buc/Plic, Marime, S, Verde, 6427559019484, Porumb Artificial, Porumb Artificial FL., Porumb FL., Artificial FL., FL.
Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 98.593 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '3c6947385ad737e7aefbfda747'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (43.701)
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 = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (54.265)
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 = '13' 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.126)
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