FL.

FL.

Sortare după:

CARLIGE FL LONG SHANK BAITHOLDER 10BUC/PLIC MARIME 4/0

CARLIGE FL LONG SHANK BAITHOLDER 10BUC/PLIC MARIME 4/0

6101200501367

Livrare 24-48 ore

9,12Lei

LANSETA SPINNING PRO FL VETERAN R9 2.40N 15-40G

LANSETA SPINNING PRO FL VETERAN R9 2.40N 15-40G

64-4117

Livrare 24-48 ore

185,96Lei

LANSETA FL BLADE FAST SPIN 2.25M 4-18G

LANSETA FL BLADE FAST SPIN 2.25M 4-18G

64-1652

Livrare imediată!

131,06Lei

HUSA FL 2COMPARTIMENTE 600D 1.45MT

HUSA FL 2COMPARTIMENTE 600D 1.45MT

2241022550496

Livrare imediată!

101,66Lei

Undita chinezeasca FL Must Kill Carp Putere 7kg, 7.2m

Undita chinezeasca FL Must Kill Carp Putere 7kg, 7.2m

3642329991101

Livrare imediată!

450,00Lei(-27%) 326,28Lei

AVERTIZOR INDIVIDUAL FL JY-75 CULOARE Rosu

AVERTIZOR INDIVIDUAL FL JY-75 CULOARE Rosu

fl-jy-75-rosu

Livrare 24-48 ore

47,90Lei(-5%) 45,64Lei

POP UP ARTIFICIAL 10MM PRO FL 10BUC CULOARE Mov

POP UP ARTIFICIAL 10MM PRO FL 10BUC CULOARE Mov

64-68338

Livrare imediată!

9,03Lei

PLUTA CHINEZASCA INTELIGENTA FL CU BATERIE 4G, 40CM, CULOARE ROSIE

PLUTA CHINEZASCA INTELIGENTA FL CU BATERIE 4G, 40CM, CULOARE ROSIE

64-45179

Livrare imediată!

31,40Lei

Cosulet Feeder FL Patrat cu Pini 80g

Cosulet Feeder FL Patrat cu Pini 80g

65-03391

Livrare imediată!

8,63Lei

UNDITA PRO FL SCOGLIERA BLX 6.00M

UNDITA PRO FL SCOGLIERA BLX 6.00M

a8050-6m

Livrare 24-48 ore

92,41Lei

VOBLER FL SINKING 10CM 15.5G ARTICULAT CULOARE 001

VOBLER FL SINKING 10CM 15.5G ARTICULAT CULOARE 001

64-3324x

Livrare imediată!

18,17Lei

LANSETA SPINNING FL GREAT 2.20M, 1-10G, 2SEG

LANSETA SPINNING FL GREAT 2.20M, 1-10G, 2SEG

64-4000

Livrare 24-48 ore

137,15Lei

MULINETA PRO FL METHOD FEEDER 6000

MULINETA PRO FL METHOD FEEDER 6000

64-0990

Livrare imediată!

139,17Lei

CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 2/0 10BUC

CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 2/0 10BUC

64-26352

Livrare imediată!

12,08Lei

HANGER FL ILUMINAT CULOARE Rosu

HANGER FL ILUMINAT CULOARE Rosu

fl-sw-11-red

Livrare imediată!

22,25Lei

SET 2BUC PRO FL METHOD FEEDER DOUBLE CHANCE 30G

SET 2BUC PRO FL METHOD FEEDER DOUBLE CHANCE 30G

64-26437

Livrare imediată!

19,20Lei

MONTURA FL FEEDER MFS CU SPIN 30G CARLIG NR 8 SPIN 7MM

MONTURA FL FEEDER MFS CU SPIN 30G CARLIG NR 8 SPIN 7MM

ak-mfs30/8

Livrare imediată!

17,17Lei

MULINETA PRO FL ULTIMATE FEEDER FD 4000

MULINETA PRO FL ULTIMATE FEEDER FD 4000

8183248367875

Livrare imediată!

180,87Lei

VARGA FL RANGER POLE 10-30G 4M

VARGA FL RANGER POLE 10-30G 4M

65-46401

Livrare imediată!

57,84Lei

Montura FL Leadcore Momitor MV2 55 Gr Cu Porumb Carlig Wide Gape Nr 8

Montura FL Leadcore Momitor MV2 55 Gr Cu Porumb Carlig Wide Gape Nr 8

clm216205

Livrare 24-48 ore

17,27Lei

Afişare 961 - 980 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: 98.242 ms [By time] [By id] [By file]

1 (0.155)

SELECT data
FROM `oc_session`
WHERE session_id = '943ee7864612b677c148142df3'

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

2 (0.076)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.094)

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

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

4 (0.091)

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.192)

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

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 960,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