FL.


LANSETA FL STRATEGIST RIVER TELE FEEDER 3.60M 100-200G

LANSETA FL STRATEGIST RIVER TELE FEEDER 3.60M 100-200G

64-4022
Livrare imediată!

232,89Lei

Cutie FL Feeder Water Pro L351 x W250 x H 80 MM Fara Accesorii

Cutie FL Feeder Water Pro L351 x W250 x H 80 MM Fara Accesorii

2572361778440
Livrare imediată!

159,90Lei

UNDITA CHINEZEASCA X POWER JIA LUN 5.4M 6H 5KG REZISTENTA PLUS VARF DE REZERVA

UNDITA CHINEZEASCA X POWER JIA LUN 5.4M 6H 5KG REZISTENTA PLUS VARF DE REZERVA

4182373076533
Livrare imediată!

299,90Lei

LANSETA PRO FL TELE EXCLUSIVE TROUT 4.60M 10-40G

LANSETA PRO FL TELE EXCLUSIVE TROUT 4.60M 10-40G

64-4012
Livrare imediată!

209,90Lei

Lanseta FL Strong River Tele Carp 3.30 M 3.50LB

Lanseta FL Strong River Tele Carp 3.30 M 3.50LB

2153198183982
Livrare imediată!

163,90Lei

Momitor, METHOD, FL, IN-LINE, DURA, FLAT, XL, 40G, ak-xl40, Momitoare Method Feeder, Momitoare Method Feeder FL., Momitoare FL., Method FL., Feeder FL., FL.
SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 6

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

64-26574
Livrare imediată!

18,90Lei

MULINETA, PRO, FL, STRATEGIST, FEEDER, PRO, Red, 8000, 7183247492364, Mulinete Crap, Mulinete Crap FL., Mulinete FL., Crap FL., Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., FL.
UNDITA CHINEZEASCA PRO FL PATRIOT 7.2M

UNDITA CHINEZEASCA PRO FL PATRIOT 7.2M

4253243509045
Livrare imediată!

321,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 3.5G, CULOARE, 10, 64-80637, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Montura FL Textil Momitor MV2 55 Gr Cu Porumb Carlig Wide Gape Nr 2

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

clm216298
Livrare imediată!

12,99Lei

Lanseta FL Rock Fish Tele Spin 3.60M

Lanseta FL Rock Fish Tele Spin 3.60M

3153179007343
Livrare imediată!

112,21Lei

JUVELNIC ROTUND PRO FL 2.5M 7 INELE

JUVELNIC ROTUND PRO FL 2.5M 7 INELE

yh40257h
Livrare imediată!

70,90Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 257

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 257

fl115-floating-0.6-1.2m-100mm-15.5g-257
Livrare imediată!

17,10Lei

BRIDE PRO FL CRIMP 0.7MM 50buc/pac

BRIDE PRO FL CRIMP 0.7MM 50buc/pac

64-65726
Livrare imediată!

9,90Lei

Vobler, FL, FL509, Floating, 45mm, 6.5g, Depth, 0.5m, Colour, 485, fl509-floating-0.5m-45mm-6.5g-485, Voblere Floating, Voblere Floating FL., FL.
CARLIGE, PRO, FL, WIDE, GAPE, 10BUC, TEFLONATE, NR, 10, 64-66228, Carlige Crap, Carlige Crap FL., Carlige FL., Crap FL., FL.
Momitor Method Feeder FL Tija Interschimbabila Marime M 45g

Momitor Method Feeder FL Tija Interschimbabila Marime M 45g

ak-im45
Livrare imediată!

14,30Lei

TRIPOD FEEDER PRO FL 30-80CM

TRIPOD FEEDER PRO FL 30-80CM

fl-rp135-1
Livrare imediată!

50,90Lei

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

Lanseta Spinning FL Strategist 2.10M 150G 2Segmente

4311211443613
Livrare imediată!

308,20Lei(-29%) 220,15Lei

Afişare 561 - 580 din 1618 (81 pagini)
Queries: 7, Total time: 104.486 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = 'b6111bdcc0841efdff5d086027'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.109)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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 (42.590)
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 (61.391)
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 560,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.108)
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