FL.

FL.

Sortare după:

Fir Textil FL Spin X4 Yellow 150m 8.00Kg 0.14mm

Fir Textil FL Spin X4 Yellow 150m 8.00Kg 0.14mm

4721751871560

Livrare imediată!

29,37Lei

Lanseta Telescopica FL Fibra Sticla 3.00m

Lanseta Telescopica FL Fibra Sticla 3.00m

3255195346113

Livrare 24-48 ore

37,81Lei

Set Swinger 4 Buc FL MKM-3 Cu Conector Rapid 4 Color JY-SW-15TS + Cofret

Set Swinger 4 Buc FL MKM-3 Cu Conector Rapid 4 Color JY-SW-15TS + Cofret

jy-sw-15ts

Livrare imediată!

375,90Lei(-8%) 344,58Lei

LANSETA FL CATFISH PASSION PRO 2.40M 300-600G

LANSETA FL CATFISH PASSION PRO 2.40M 300-600G

6427559016094

Livrare 24-48 ore

215,44Lei

ANCORE PRO FL CULOARE BRONZE MARIME 4/0 4BUC

ANCORE PRO FL CULOARE BRONZE MARIME 4/0 4BUC

fl-900-4/0bronze

Livrare imediată!

14,12Lei

Lanseta FL Strong Match 4.50M/50-150Gr

Lanseta FL Strong Match 4.50M/50-150Gr

5153170743484

Livrare 24-48 ore

264,55Lei

Swinger FL MKM-3 Verde

Swinger FL MKM-3 Verde

8243165015515

Livrare imediată!

49,01Lei(-5%) 46,65Lei

Fir Monofilament FL Feeder Competition 150M 9.02Kg 0.25mm

Fir Monofilament FL Feeder Competition 150M 9.02Kg 0.25mm

2721778471585

Livrare 24-48 ore

26,62Lei

Mulineta FL SWR 9000

Mulineta FL SWR 9000

2262190573308

Livrare imediată!

196,84Lei

Mulineta Fl Strategist 2000s

Mulineta Fl Strategist 2000s

64-8029

Livrare imediată!

123,81Lei

BOLOGNEZA PRO FL COGJIEREA BLX 10-40G 5.00M

BOLOGNEZA PRO FL COGJIEREA BLX 10-40G 5.00M

a8049-5

Livrare imediată!

83,26Lei

SWINGER PRO FL SW36 ILUMINATED CULOARE Galben

SWINGER PRO FL SW36 ILUMINATED CULOARE Galben

fl-sw-36-galben

Livrare imediată!

57,84Lei

SUPORT TELESCOPIC PENTRU UNDITA FL CULOARE ALBASTRA

SUPORT TELESCOPIC PENTRU UNDITA FL CULOARE ALBASTRA

6105237443751

Livrare 24-48 ore

38,51Lei

LANSETA PRO FL CHAMPION TELE MATCH 4.20M, 20-80G

LANSETA PRO FL CHAMPION TELE MATCH 4.20M, 20-80G

64-4017

Livrare imediată!

204,26Lei

Husa FL Camuflaj 1.35m 2 Compartimente

Husa FL Camuflaj 1.35m 2 Compartimente

7777034

Livrare 24-48 ore

40,66Lei

Lanseta FL Ultra Team 3.90M 3.75Lbs 2Seg

Lanseta FL Ultra Team 3.90M 3.75Lbs 2Seg

5811670306119

Livrare 24-48 ore

245,94Lei

Fir Textil FL Teflonat Fire Line Strong 20M 6.80Kg 0.12mm

Fir Textil FL Teflonat Fire Line Strong 20M 6.80Kg 0.12mm

4721732780126

Livrare imediată!

15,54Lei

Lanseta FL Drop Carp 3.60M 3.50Lbs 2Seg Sakana Hanta

Lanseta FL Drop Carp 3.60M 3.50Lbs 2Seg Sakana Hanta

2153178730557

Livrare imediată!

350,00Lei(-30%) 244,93Lei

Umbrela Cu Parasolar FL Camo Inchidere Totala Cu Ferestre 300cm

Umbrela Cu Parasolar FL Camo Inchidere Totala Cu Ferestre 300cm

2304202331039

Livrare imediată!

560,04Lei

Set Avertizoare FL 3 + Statie JY12

Set Avertizoare FL 3 + Statie JY12

jy-12-3

Livrare imediată!

357,91Lei(-8%) 329,33Lei

Afişare 1821 - 1840 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: 111.771 ms [By time] [By id] [By file]

1 (0.125)

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

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

2 (0.106)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.125)

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

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

4 (0.124)

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

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

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 1820,20

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

7 (0.140)

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