FL.


12,08Lei

229,00Lei(-8%) 210,36Lei

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

64-71062-xl-50
Livrare imediată!

27,35Lei

21,24Lei

MULINETA PRO FL STRATEGIST FEEDER PRO Red 8000

7183247492364
Livrare imediată!

296,79Lei

UNDITA CHINEZEASCA PRO FL PATRIOT 7.2M

4253243509045
Livrare imediată!

328,31Lei

17,27Lei

13,10Lei

Mulineta FL TB12 6000

4262195805990
Livrare 24-48 ore

171,90Lei

Lanseta FL Master Feeder 3.60M/50-100Gr/3Seg/2Vf

8153173591379
Livrare 24-48 ore

174,77Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 257

fl115-floating-0.6-1.2m-100mm-15.5g-257
Livrare imediată!

18,39Lei

Vobler FL FL509 Floating 45mm 6.5g Depth 0.5m Colour 485

fl509-floating-0.5m-45mm-6.5g-485
Livrare imediată!

18,39Lei

16,15Lei

Mulineta FL Strategist TX 7000 Black Edition

5282170855276
Livrare 24-48 ore

340,82Lei

MULINETA PRO FL ULTRA CAST CARP FLX 16000

64-13444
Livrare imediată!

347,63Lei

Mulineta FL Sparkler Feeder 2021 4000

64-0966
Livrare 24-48 ore

102,58Lei

LANSETA PRO FL X POWER FEEDER 60-180G 4.50M

65-46272
Livrare imediată!

244,93Lei

14,60Lei

33,44Lei

HUSA FL 2022 4 COMPARTIMENTE 150CM

5552248978047
Livrare 24-48 ore

144,27Lei

Afişare 61 - 80 din 2129 (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: 100.169 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '89637fa8c7223dbe23ac8a0b92'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.130)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.314)
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 = '2' AND p.manufacturer_id = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (60.248)
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 = '2' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.131)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37