FL.


UNDITA PRO FL STRATEGIST FORCE 7MT 40-100G UP TO 4.5KG

UNDITA PRO FL STRATEGIST FORCE 7MT 40-100G UP TO 4.5KG

64-4073
Livrare imediată!

469,00Lei

Momeala Chinezeasca Mix Seminte Special Crap 800g

Momeala Chinezeasca Mix Seminte Special Crap 800g

x782
Livrare imediată!

21,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 05, 64-80453, Lingurite Pastrav, Lingurite Pastrav FL., FL.
MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 40CM CU FLOATOARE

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

6427559061025
Livrare imediată!

69,00Lei

Mulineta FL SF 2000

Mulineta FL SF 2000

3262199005946
Livrare imediată!

89,90Lei

Lanseta FL Eternity Tele Carp 3.90M

Lanseta FL Eternity Tele Carp 3.90M

5153171225965
Livrare imediată!

149,90Lei

LANSETA SPINNING PRO FL MURROW 2.08M 0.2-6G

LANSETA SPINNING PRO FL MURROW 2.08M 0.2-6G

64-4104
Livrare imediată!

143,89Lei

Maner Minciog FL Strategist 180K 1 Segment 1.80M

Maner Minciog FL Strategist 180K 1 Segment 1.80M

3153211821333
Livrare imediată!

132,90Lei

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

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

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

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.23MM, 150M, 34KG, 64-4540, 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 18

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 18

fl601-sinking-deepwater-70mm-16.0g-18
Livrare imediată!

17,10Lei

Montura, FL, Leadcore, Plumb, Pierdut, Long, Cast, Plumb, 100, Gr, Carlig, YN, Nr, 6, 64-0161, Monturi Crap, Monturi Crap FL., FL.
Mulineta, FL, Sparkler, Feeder, 2021, 1000, 64-0963, Mulinete Rapitori, Mulinete Rapitori FL., Mulinete Bolognese, Mulinete Bolognese FL., Mulinete Match, Mulinete Match FL., Mulinete Feeder, Mulinete Feeder FL., FL.
CILINDRi, PENTRU, SPUMA, ZIG, RIG, PRO, FL, LIQUID, BOOSTER, ORANGE/TRANSPARENT, 64-65955, Alte Accesorii Monturi Crap, Alte Accesorii Monturi Crap FL., Alte FL., Accesorii FL., Monturi FL., Crap FL., FL.
Scaun Feeder PRO FL cu Accesorii Marime XL -20%

Scaun Feeder PRO FL cu Accesorii Marime XL

fl-tfc080
Livrare imediată!

1.000,00Lei(-20%) 799,00Lei

Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

flx9-3603
Livrare imediată!

208,25Lei

LANSETA SPINNING FL SUPAPULL - JACK 2.70M 15-45G

LANSETA SPINNING FL SUPAPULL - JACK 2.70M 15-45G

4552272873074
Livrare imediată!

129,90Lei

Porumb Artificial Flotant FL 20Buc/Plic Marime S Rosu

Porumb Artificial Flotant FL 20Buc/Plic Marime S Rosu

6427559019507
Livrare imediată!

5,71Lei

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

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

64-1971-30-6
Livrare imediată!

13,90Lei

CARLIGE FL CATFISH 10BUC/PLIC MARIME 1/0

CARLIGE FL CATFISH 10BUC/PLIC MARIME 1/0

6101200501190
Livrare imediată!

7,98Lei

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 90.014 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = '8f2e1c54cf23f22aedd4ded28d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.430)
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 = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (53.910)
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 = '3' 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.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38