FL.

FL.

Sortare după:

Fir Textil FL Soft X-Power 20M 12.70Kg 0.20mm

Fir Textil FL Soft X-Power 20M 12.70Kg 0.20mm

7721782085988

Livrare imediată!

7,80Lei

Suport Barca FL Metal

Suport Barca FL Metal

5153173660078

Livrare 24-48 ore

63,43Lei

Set 4 Avertizoare Fl cu Statie Jy-39T

Set 4 Avertizoare Fl cu Statie Jy-39T

4310198857246

Livrare 24-48 ore

499,90Lei(-6%) 469,65Lei

Mulineta FL XT 14000 BLACK EDITION

Mulineta FL XT 14000 BLACK EDITION

4149205127177

Livrare imediată!

339,80Lei

Set Swinger 6 Buc FL MKM-3 Cu conector Rapid Black Color JY-SW-15TSB-6 + Cofret

Set Swinger 6 Buc FL MKM-3 Cu conector Rapid Black Color JY-SW-15TSB-6 + Cofret

jy-sw-15tsb-6

Livrare 24-48 ore

375,90Lei(-8%) 345,60Lei

LANSETA FL MAGIC TELE MATCH 4.80M, 40-100G

LANSETA FL MAGIC TELE MATCH 4.80M, 40-100G

64-4015

Livrare imediată!

256,12Lei

Rod Pod FL CZ 4 Posturi 4 Picioare Negru Cadru Dublu

Rod Pod FL CZ 4 Posturi 4 Picioare Negru Cadru Dublu

7157165091664

Livrare 24-48 ore

326,28Lei

Set Avertizoare FL 6 + Statie JY62

Set Avertizoare FL 6 + Statie JY62

7752126900919

Livrare 24-48 ore

589,90Lei(-8%) 540,82Lei

Mulineta Fl Strategist 6000s

Mulineta Fl Strategist 6000s

64-8033

Livrare 24-48 ore

154,44Lei

BOLOGNEZA PRO FL COURAGEOUS 15-40G 5.00M

BOLOGNEZA PRO FL COURAGEOUS 15-40G 5.00M

a8047-5

Livrare 24-48 ore

83,26Lei

SWINGER PRO FL SW321 ILUMINATED CULOARE Albastru

SWINGER PRO FL SW321 ILUMINATED CULOARE Albastru

fl-sw-321-albastru

Livrare imediată!

51,74Lei

Mulineta FL DA 6500 L

Mulineta FL DA 6500 L

1243168200793

Livrare imediată!

113,76Lei

Fir Monofilament FL Feeder Competition 150M 12.60Kg 0.30mm

Fir Monofilament FL Feeder Competition 150M 12.60Kg 0.30mm

2721735405943

Livrare 24-48 ore

11,68Lei

Mulineta Fl Spyder 1000s

Mulineta Fl Spyder 1000s

64-8034

Livrare imediată!

109,78Lei

VARGA FL STRATEGIST 8M ULTRALIGHT STRONGER HIGH TECH 10-40G

VARGA FL STRATEGIST 8M ULTRALIGHT STRONGER HIGH TECH 10-40G

6427559017336

Livrare imediată!

443,31Lei

LANSETA CRAP FL TOURNAMENT 2022 3.90M 3.5LBS 2SEGMENTE

LANSETA CRAP FL TOURNAMENT 2022 3.90M 3.5LBS 2SEGMENTE

64-1669

Livrare 24-48 ore

194,19Lei

BOLOGNEZA PRO FL HUNTER GREEN 5.00M UP TO 40G

BOLOGNEZA PRO FL HUNTER GREEN 5.00M UP TO 40G

a8044-5

Livrare 24-48 ore

79,19Lei

SWINGER PRO FL MINI SW35 Albastru

SWINGER PRO FL MINI SW35 Albastru

fl-sw-35-albastru

Livrare 24-48 ore

38,51Lei

ANCORE PRO FL CULOARE ROSIE MARIME 6 12BUC

ANCORE PRO FL CULOARE ROSIE MARIME 6 12BUC

fl-fl-9651-6red

Livrare imediată!

19,20Lei

Fir Monofilament FL Catfish 200m 14.60 KG 0.35mm

Fir Monofilament FL Catfish 200m 14.60 KG 0.35mm

3721759686839

Livrare 24-48 ore

19,40Lei

Afişare 1861 - 1880 din 2128 (107 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 108.945 ms [By time] [By id] [By file]

1 (0.146)

SELECT data
FROM `oc_session`
WHERE session_id = 'b9e92c081d1ba7c7017e65daab'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.136)

SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.125)

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 (42.344)

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:1699

6 (65.971)

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 = '3' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1860,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.119)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37