FL.


CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 5/0 10BUC

CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 5/0 10BUC

64-26321
Livrare imediată!

12,08Lei

Juvelnic FL Ultra Competitie Plasa Super Fina Plastifiata Rosu -Negru(Aluminiu)3M

Juvelnic FL Ultra Competitie Plasa Super Fina Plastifiata Rosu -Negru(Aluminiu)3M

7234218090451
Livrare 48-72 ore

159,62Lei

Momitor METHOD FL IN-LINE DURA FLAT XL 35G

Momitor METHOD FL IN-LINE DURA FLAT XL 35G

ak-xl35
Livrare imediată!

11,07Lei

LANSETA CRAP PRO FL POWER TELE CARP 3.90M 160-360G

LANSETA CRAP PRO FL POWER TELE CARP 3.90M 160-360G

64-45445
Livrare 48-72 ore

176,81Lei

LANSETA CRAP PRO FL Legend Carp 3.90M 3.75LBS 3SEGMENTE

LANSETA CRAP PRO FL Legend Carp 3.90M 3.75LBS 3SEGMENTE

7722499821494
Livrare 48-72 ore

176,81Lei

Mulineta FL Strategist TX 14000 Black Edition

Mulineta FL Strategist TX 14000 Black Edition

1252200018654
Livrare 48-72 ore

479,81Lei

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 08

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 08

64-80484
Livrare imediată!

13,10Lei

Cosulet Feeder FL CS4 30

Cosulet Feeder FL CS4 30

cs4-30
Livrare 48-72 ore

7,30Lei

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 40CM CU FLOATOARE

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 40CM CU FLOATOARE

6427559061025
Livrare imediată!

71,16Lei

Lanseta Feeder FL AQUA River Feeder 3.60M 100-200Gr 3Seg

Lanseta Feeder FL AQUA River Feeder 3.60M 100-200Gr 3Seg

3153217149066
Livrare 48-72 ore

256,12Lei

Vobler FL FL147 Floating 40mm 2.1g Depth 0.5m Colour 273

Vobler FL FL147 Floating 40mm 2.1g Depth 0.5m Colour 273

fl147-floating-0.5m-40mm-2.1g-273
Livrare imediată!

19,40Lei

Lanseta Crap PRO FL FLX9 3.60m, 3.75lbs, 2seg

Lanseta Crap PRO FL FLX9 3.60m, 3.75lbs, 2seg

1224244653153
Livrare 48-72 ore

204,26Lei

Vobler FL FL510 Floating 36mm 4.0g Depth 1.0m Colour 840

Vobler FL FL510 Floating 36mm 4.0g Depth 1.0m Colour 840

fl510-floating-1.0m-36mm-4.0g-840
Livrare 48-72 ore

18,39Lei

Husa FL Kaki 3 Compartimente 135cm

Husa FL Kaki 3 Compartimente 135cm

6752115248863
Livrare 48-72 ore

68,72Lei

UNDITA PRO FL PRADO 115CM 300G 7.00M

UNDITA PRO FL PRADO 115CM 300G 7.00M

5224246695201
Livrare imediată!

221,55Lei

Lanseta Spinning FL Strategist 2.10M 150G 2Segmente -27%

Lanseta Spinning FL Strategist 2.10M 150G 2Segmente

4311211443613
Livrare imediată!

308,20Lei(-27%) 224,85Lei

Momitor Feeder Inline Fl Sticky Maggots L 30g 1buc/plic

Momitor Feeder Inline Fl Sticky Maggots L 30g 1buc/plic

64-2493
Livrare imediată!

9,03Lei

Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

flx9-3603
Livrare 48-72 ore

213,77Lei

FOARFECA PRO FL BRAID SCISSORS CARP

FOARFECA PRO FL BRAID SCISSORS CARP

64-66822
Livrare imediată!

22,25Lei

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

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

4552272873074
Livrare 48-72 ore

134,10Lei

Afişare 601 - 620 din 2139 (107 pagini)
Queries: 7, Total time: 115.002 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = '2ec7cb9c1646cb1e358593d3f7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.104)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.097)
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 (51.134)
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 (63.339)
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 600,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.115)
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