FL.


Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 854

fl158-sinking-allround-70mm-9.6g-854
Livrare imediată!

18,39Lei

Vobler FL FL512 Floating 33mm 4.7g Depth 0.6-1.8m Colour 993

fl512-floating-0.6-1.8m-33mm-4.7g-993
Livrare imediată!

19,40Lei

53,77Lei

UNDITA PRO FL PRADO 115CM 170G 5.00M

1224242953118
Livrare imediată!

144,27Lei

62,92Lei

Mulineta FL SW 4000

3271120209063
Livrare imediată!

102,58Lei

7,77Lei

Scaun Feeder PRO FL cu Accesorii Marime XL

fl-tfc080
Livrare 24-48 ore

1.000,00Lei(-19%) 814,45Lei

Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

flx9-3603
Livrare 24-48 ore

213,77Lei

143,25Lei

LANSETA SPINNING FL SUPAPULL - JACK 2.70M 15-45G

4552272873074
Livrare 24-48 ore

134,10Lei

MULINETA PRO FL CARBON GT MARIME 2500S

cg-2500s
Livrare imediată!

336,44Lei

8,02Lei

LINE ALIGNER POP-UP PRO FL 17MM

64-66921
Livrare imediată!

10,06Lei

73,08Lei

14,12Lei

15,13Lei

UNDITA PRO FL AQUA MINI POLE 4.50M 10-45G

64-1376
Livrare imediată!

83,26Lei

Prastie FL Catapult Large

4262194358756
Livrare imediată!

24,79Lei

114,78Lei

Afişare 1241 - 1260 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: 121.416 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '982779ddfc9864f2c8a24ca901'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.117)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.109)
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 (53.914)
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 (66.930)
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 1240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.144)
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