FL.


LANSETA CRAP FL FLX22 FAST 3.96M 4.0LBS

LANSETA CRAP FL FLX22 FAST 3.96M 4.0LBS

4004-3902
Livrare imediată!

538,89Lei

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

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

64-26390
Livrare imediată!

12,08Lei

SET 4 SWINGERE 4 CULORI FL CU LUMINA SI TENSIONARE -8%

SET 4 SWINGERE 4 CULORI FL CU LUMINA SI TENSIONARE

fl-jy-sw-27t
Livrare 48-72 ore

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

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

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

64-71062-xl-50
Livrare imediată!

27,35Lei

SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 12

SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 12

64-26604
Livrare 48-72 ore

21,24Lei

MULINETA PRO FL STRATEGIST FEEDER PRO Red 8000

MULINETA PRO FL STRATEGIST FEEDER PRO Red 8000

7183247492364
Livrare 48-72 ore

296,79Lei

Set Swinger 4 Buc FL MKM-3 Plus Cofret -8%

Set Swinger 4 Buc FL MKM-3 Plus Cofret

3243168337176
Livrare imediată!

223,90Lei(-8%) 205,28Lei

UNDITA CHINEZEASCA PRO FL PATRIOT 7.2M

UNDITA CHINEZEASCA PRO FL PATRIOT 7.2M

4253243509045
Livrare imediată!

328,31Lei

Mulineta FL RS 9000

Mulineta FL RS 9000

4224200522476
Livrare 48-72 ore

205,28Lei

LINGURITA PRO FL PASTRAV SPIRAL SPOON 3.5G CULOARE 05

LINGURITA PRO FL PASTRAV SPIRAL SPOON 3.5G CULOARE 05

64-80583
Livrare imediată!

13,10Lei

Fir Monofilament FL Advance 1200M 0.30mm

Fir Monofilament FL Advance 1200M 0.30mm

5231206260119
Livrare 48-72 ore

54,69Lei

Minciog FL Strategist 200K Coada 2 Segmente Carbon 3K 2M Deschidere 1M

Minciog FL Strategist 200K Coada 2 Segmente Carbon 3K 2M Deschidere 1M

5153213113250
Livrare imediată!

288,96Lei

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

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

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

CARLIGE PRO FL APE-X CURVE SHAK 10BUC TEFLONATE NR 6

CARLIGE PRO FL APE-X CURVE SHAK 10BUC TEFLONATE NR 6

64-66242
Livrare imediată!

16,15Lei

Mulineta FL Team Feeder TF 7000

Mulineta FL Team Feeder TF 7000

64-0976
Livrare 48-72 ore

131,87Lei

MULINETA PRO FL ULTRA CAST CARP FLX SPOD MARKER I

MULINETA PRO FL ULTRA CAST CARP FLX SPOD MARKER I

64-13451
Livrare 48-72 ore

356,88Lei

Montura FL Leadcore Plumb Inline Pasta Tip Fox 80 Gr Carlig C(classic boilie) Nr 4

Montura FL Leadcore Plumb Inline Pasta Tip Fox 80 Gr Carlig C(classic boilie) Nr 4

64-3513
Livrare imediată!

16,76Lei

SET MOMELI FLOTANTE PRO FL 155BUC PLUS CUTIE

SET MOMELI FLOTANTE PRO FL 155BUC PLUS CUTIE

64-65979
Livrare imediată!

38,51Lei

Momitor Feeder In-Line FL Hybrid M 50 g 1Buc/Plic

Momitor Feeder In-Line FL Hybrid M 50 g 1Buc/Plic

ak-wm50
Livrare imediată!

11,07Lei

Afişare 1081 - 1100 din 2114 (106 pagini)
Queries: 7, Total time: 107.911 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = 'b8598fe263cec3d313bda8f5e7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 (40.329)
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 (67.001)
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 1080,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.113)
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