FL.

FL.

Sortare după:

Mulineta FL LF 2000

Mulineta FL LF 2000

5272205403756

Livrare 24-48 ore

87,94Lei

Swinger FL MKM-3 Cu Conector Rapid Verde

Swinger FL MKM-3 Cu Conector Rapid Verde

8208210115732

Livrare imediată!

62,90Lei(-6%) 58,85Lei

TELEMATCH FL SUPER STAR MATCH SUPER STRONG 4.20M 20-50G

TELEMATCH FL SUPER STAR MATCH SUPER STRONG 4.20M 20-50G

6427559017565

Livrare 24-48 ore

230,80Lei

SALTEA RECEPTIE PRO FL CRADLE NEO 8

SALTEA RECEPTIE PRO FL CRADLE NEO 8

fl-neo08

Livrare imediată!

376,10Lei

ANCORE PRO FL CULOARE BRONZE MARIME 1/0 6BUC

ANCORE PRO FL CULOARE BRONZE MARIME 1/0 6BUC

fl-900-1/0bronze

Livrare imediată!

14,12Lei

LANSETA PRO FL STRATEGIST CATFISH 2.50M PUTERE 500G 3SEGMENTE

LANSETA PRO FL STRATEGIST CATFISH 2.50M PUTERE 500G 3SEGMENTE

2301-2503

Livrare imediată!

234,76Lei

Lanseta FL Ultra Team 3.00m, 3.75lb, 2seg

Lanseta FL Ultra Team 3.00m, 3.75lb, 2seg

5185215002621

Livrare 24-48 ore

179,85Lei

Lanseta Somn FL Breakline Pilk 2.70M 100-300Gr 2Seg

Lanseta Somn FL Breakline Pilk 2.70M 100-300Gr 2Seg

1153161353597

Livrare imediată!

167,65Lei

Mulineta Feeder FL Feeder Wind 200R

Mulineta Feeder FL Feeder Wind 200R

2186149168073

Livrare imediată!

92,21Lei

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

SUPORT TELESCOPIC PENTRU UNDITA FL CULOARE Rosie

SUPORT TELESCOPIC PENTRU UNDITA FL CULOARE Rosie

8105230012945

Livrare 24-48 ore

37,50Lei

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

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

64-4013

Livrare imediată!

201,21Lei

Lanseta FL Strong Match 4.20M/40-120Gr

Lanseta FL Strong Match 4.20M/40-120Gr

6153171373948

Livrare imediată!

246,66Lei

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

Afişare 1941 - 1960 din 2127 (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: 127.323 ms [By time] [By id] [By file]

1 (0.131)

SELECT data
FROM `oc_session`
WHERE session_id = '5a3c7c6fdbf5d3c04e3cf8e4a4'

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

2 (0.180)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.154)

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

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

4 (0.113)

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

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 (68.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, 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 1940,20

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

7 (0.126)

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