FL.


Maner Minciog Carbon FL Toreador Telescopic 3.5M

Maner Minciog Carbon FL Toreador Telescopic 3.5M

5153211303417
Livrare imediată!

119,90Lei

Vobler FL FL505 Floating 50mm 9.8g Depth 2.5m Colour 117 -19%

Vobler FL FL505 Floating 50mm 9.8g Depth 2.5m Colour 117

fl505-floating-2.5m-50mm-9.8g-117
Livrare imediată!

17,10Lei(-19%) 13,90Lei

Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 105 -19%

Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 105

fl602-sinking-allround-55mm-10.5g-105
Livrare imediată!

17,10Lei(-19%) 13,90Lei

UNDITA PRO FL PRADO 115CM 300G 7.00M

UNDITA PRO FL PRADO 115CM 300G 7.00M

5224246695201
Livrare imediată!

215,90Lei

Montura, FL, Leadcore, Plumb, Pierdut, Grippa, Plumb, 100, Gr, Carlig, C, Nr, 8, 64-0260, Monturi Crap, Monturi Crap FL., FL.
PICHET PRO FL NEGRU MAT CU FILET 60-100CM

PICHET PRO FL NEGRU MAT CU FILET 60-100CM

4235249164367
Livrare imediată!

44,90Lei

Mulineta FL Sparkler Feeder 2021 5000

Mulineta FL Sparkler Feeder 2021 5000

64-0967
Stoc epuizat

91,50Lei

JUVELNIC PRO FL ROTUND 300CM

JUVELNIC PRO FL ROTUND 300CM

yh45307
Livrare imediată!

119,90Lei

Momitor, Method, Feeder, Inline, FL, L, 60g, 1Buc/plic, 64-2561, Momitoare Method Feeder, Momitoare Method Feeder FL., FL.
Lanseta Feeder FL FLX River 3.60M/100-250GR/3Seg

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

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

319,90Lei

Geanta Accesorii FL Large

Geanta Accesorii FL Large

64-2060
Livrare imediată!

109,90Lei

MONTURA, FEEDER, FL, METHOD, CU, TIJA, 40G, CARLIG, NR, 10, SPIN, 10MM, CU, PORUMB, FLOTANT, E, G, 64-1972-40-10, Monturi Complete Feeder, Monturi Complete Feeder FL., Monturi FL., Complete FL., Feeder FL., FL.
CARLIGE FL CATFISH 10BUC/PLIC MARIME 6/0

CARLIGE FL CATFISH 10BUC/PLIC MARIME 6/0

8211022792923
Livrare imediată!

7,98Lei

MULINETA, FL, SQUADRON, PRO, 5000, 2211022066792, Mulinete Rapitori, Mulinete Rapitori FL., Mulinete FL., Rapitori FL., Mulinete Match, Mulinete Match FL., Mulinete FL., Match FL., Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., FL.
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, 64-1018, Mulinete Rapitori, Mulinete Rapitori FL., Mulinete FL., Rapitori FL., Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., Mulinete Crap, Mulinete Crap FL., Mulinete FL., Crap FL., FL.
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

PLUTA CHINEZASCA INTELIGENTA FL CU BATERIE 3G, 40CM, CULOARE ALBA A001

64-45001
Livrare imediată!

29,90Lei

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 94.529 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'c816303eff58d8e01934ff94f7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.115)
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 (39.183)
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 (54.791)
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.112)
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