FL.


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 imediată!

171,90Lei

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

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

1722426605384
Livrare imediată!

161,90Lei

LINGURITA PRO FL PASTRAV SPIRAL SPOON 3.5G CULOARE 13

LINGURITA PRO FL PASTRAV SPIRAL SPOON 3.5G CULOARE 13

64-80668
Livrare imediată!

11,90Lei

Montura FL Textil Feeder Cosulet Patrat 50 Gr Cu Porumb Carlig Wide Gape Nr 8

Montura FL Textil Feeder Cosulet Patrat 50 Gr Cu Porumb Carlig Wide Gape Nr 8

clm216274
Livrare imediată!

12,00Lei

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

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

64-02158
Livrare imediată!

15,01Lei

Mulineta FL TB12 5000

Mulineta FL TB12 5000

8262193564765
Livrare imediată!

144,89Lei

Lanseta FL FLX21 3.96M 4.00Lbs 2Seg

Lanseta FL FLX21 3.96M 4.00Lbs 2Seg

5289202790925
Livrare imediată!

399,80Lei

HUSA RIGIDA DUBLA PRO FL 135CM

HUSA RIGIDA DUBLA PRO FL 135CM

5224248231346
Livrare imediată!

121,90Lei

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

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

fl510-floating-1.0m-36mm-4.0g-637
Livrare imediată!

17,10Lei

Vobler, FL, FL505, Floating, 50mm, 9.8g, Depth, 2.5m, Colour, 696, fl505-floating-2.5m-50mm-9.8g-696, Voblere Floating, Voblere Floating FL., FL.
Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 113

Vobler FL FL602 Sinking 55mm 10.5g Depth All Round Colour 113

fl602-sinking-allround-55mm-10.5g-113
Livrare imediată!

17,10Lei

UNDITA PRO FL PRADO 115CM 300G 7.00M

UNDITA PRO FL PRADO 115CM 300G 7.00M

5224246695201
Livrare imediată!

215,90Lei

Montura, FL, Leadcore, Plumb, Pierdut, Grippa, Plumb, 100, Gr, Carlig, YN, Nr, 4, 64-0215, Monturi Crap, Monturi Crap FL., FL.
PICHET PRO FL NEGRU MAT CU FILET 60-100CM

PICHET PRO FL NEGRU MAT CU FILET 60-100CM

4235249164367
Livrare imediată!

44,90Lei

Mulineta FL Sparkler Feeder 2021 6000

Mulineta FL Sparkler Feeder 2021 6000

64-0968
Livrare imediată!

109,90Lei

JUVELNIC PRO FL ROTUND 300CM

JUVELNIC PRO FL ROTUND 300CM

yh45307
Livrare imediată!

119,90Lei

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

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

64-2493
Livrare imediată!

7,90Lei

Lanseta Feeder FL FLX River 3.60M/100-250GR/3Seg

Lanseta Feeder FL FLX River 3.60M/100-250GR/3Seg

flx-river-feeder-360-100-250
Livrare imediată!

319,90Lei

Geanta Accesorii FL Large

Geanta Accesorii FL Large

64-2060
Livrare imediată!

109,90Lei

MONTURA FEEDER FL METHOD CU TIJA 40G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT E G

MONTURA FEEDER FL METHOD CU TIJA 40G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT E G

64-1972-40-10
Livrare imediată!

13,90Lei

Afişare 1 - 20 din 1620 (81 pagini)
Queries: 7, Total time: 90.286 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '48cc0b7e23401a6115da24c925'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.138)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.301)
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 = '0' AND p.manufacturer_id = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (54.353)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '0' AND p.manufacturer_id = '13' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.121)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38