FL.


MULINETA FL SQUADRON PRO 5000

MULINETA FL SQUADRON PRO 5000

2211022066792
Livrare imediată!

113,89Lei

LANSETA, FL, STRATEGIST, FEEDER, DISTANCE, MH, 2.70M, 80-150G, 64-1787, Lansete Feeder, Lansete Feeder FL., FL.
Fir Textil Cu Camasa FL Xtreme Stiff Skin 10m 15 Lb -22%

Fir Textil Cu Camasa FL Xtreme Stiff Skin 10m 15 Lb

64-1509
Livrare imediată!

33,00Lei(-22%) 25,89Lei

Lanseta, FL, FLX30, Carp, Model, 2023, 4, LB, , 3.90, M, 4006-39602, Lansete Crap, Lansete Crap FL., FL.

Lanseta, FL, FLX30, Carp, Model, 2023, 4, LB, , 3.90, M, 4006-39602, Lansete Crap, Lansete Crap FL., FL.

4006-39602
Livrare imediată!

366,50Lei

MULINETA FL LH 5000 6RULMENTI

MULINETA FL LH 5000 6RULMENTI

64-1018
Livrare imediată!

86,91Lei

FEEDER GUM MARO FL 10M 0.6MM

FEEDER GUM MARO FL 10M 0.6MM

65-25796
Livrare imediată!

8,90Lei

PLUTA, CHINEZASCA, INTELIGENTA, FL, CU, BATERIE, 3G,, 40CM,, CULOARE, ALBA, A001, 64-45001, Plute Stationar, Plute Stationar FL., Plute FL., Stationar FL., FL.
VOBLER, FL, FLOATING, BUG, 0.5-1M, 3.8CM, 4.1G, CULOARE, 004, 64-3313x, Voblere Floating, Voblere Floating FL., FL.
UNDITA PRO FL TEMPTATION 10-30G, 7.00M

UNDITA PRO FL TEMPTATION 10-30G, 7.00M

64-4040
Livrare imediată!

142,90Lei

CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 5/0 10BUC

CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 5/0 10BUC

64-26321
Livrare imediată!

10,90Lei

SET PRO FL 2BUC IN-LINE METHOD FEEDER MARIME XL 70G

SET PRO FL 2BUC IN-LINE METHOD FEEDER MARIME XL 70G

64-71086-xl-70
Livrare imediată!

29,90Lei

Lanseta, Feeder, FL, Strategist, Distance, MH, 4.50M, 80-150G, 3Seg, 64-4082, Lansete Feeder, Lansete Feeder FL., Lansete FL., Feeder FL., FL.
Momeala, Chinezeasca, Caras, Gold, Edition, 2, 300g, 10301191, Aditivi Praf / Arome / Colanti, Aditivi Praf / Arome / Colanti FL., Aditivi FL., Praf FL., Arome FL., Colanti FL., FL.
LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 11, 64-80514, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Pichet Telescopic FL Subtire Negru Fara Bughiu

Pichet Telescopic FL Subtire Negru Fara Bughiu

1231205906326
Livrare imediată!

24,20Lei

Mulineta FL LJ 5000

Mulineta FL LJ 5000

2272203513719
Livrare imediată!

107,90Lei

UNDITA PRO FL EPOCA TRAVEL 5-30G 10 SECTIUNI 69CM 5.40M

UNDITA PRO FL EPOCA TRAVEL 5-30G 10 SECTIUNI 69CM 5.40M

64-4101
Livrare imediată!

159,90Lei

Minciog FL Strategist 180K Coada 1 Segment Carbon 3K 1.80M Deschidere 1M

Minciog FL Strategist 180K Coada 1 Segment Carbon 3K 1.80M Deschidere 1M

2153218229492
Livrare imediată!

249,90Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 788

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 788

fl158-sinking-allround-70mm-9.6g-788
Livrare imediată!

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.12MM, 150M, 10KG, 64-4496, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder FL., Fire FL., Textile FL., Monofilament FL., Feeder FL., FL.
Afişare 21 - 40 din 1618 (81 pagini)
Queries: 7, Total time: 114.459 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '81a018b699cb807c3a5585e67a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.147)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.141)
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 (58.704)
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:1667
6 (55.112)
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 = '0' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.147)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38