FL.


Montura Crap Plumb Pierdut Leadcore 45 Lbs Carlig Hayabusa Nr 4 Grippa 130 Gr

Montura Crap Plumb Pierdut Leadcore 45 Lbs Carlig Hayabusa Nr 4 Grippa 130 Gr

clm226198
Livrare imediată!

12,80Lei

Lanseta FL FLX9 3.90M 3.75Lbs 3Seg

Lanseta FL FLX9 3.90M 3.75Lbs 3Seg

flx9-3903
Livrare imediată!

249,90Lei

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ORANGE ROZ -40%

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ORANGE ROZ

64-65900
Livrare imediată!

25,00Lei(-40%) 14,90Lei

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

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

4552275566904
Livrare imediată!

86,91Lei

Montura FL Plumb Pasta Cu Tija 80g Carlig Nr 6

Montura FL Plumb Pasta Cu Tija 80g Carlig Nr 6

64-2806
Livrare imediată!

13,90Lei

Mulineta FL Tempo 5000 S

Mulineta FL Tempo 5000 S

64-8070
Livrare imediată!

144,94Lei

SET METHOD FEEDER FL 2BUC PLUS MATRITA SI TIJA RIGIDA 100G

SET METHOD FEEDER FL 2BUC PLUS MATRITA SI TIJA RIGIDA 100G

8259246705008
Livrare imediată!

30,90Lei

MONTURA PRO FL DISTANCE SWIVEL LEADCORE PLUMB PIERDUT DISTANCE 85G CARLIG NR 8

MONTURA PRO FL DISTANCE SWIVEL LEADCORE PLUMB PIERDUT DISTANCE 85G CARLIG NR 8

64-67140
Livrare imediată!

24,89Lei

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E A

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 6 SPIN 10MM CU PORUMB FLOTANT E A

64-1970-30-6
Livrare imediată!

12,90Lei

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

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

6101200501350
Livrare imediată!

7,98Lei

MULINETA PRO FL FLX 14000 ULTRA CAST CARBON

MULINETA PRO FL FLX 14000 ULTRA CAST CARBON

flx14000-carbon
Livrare imediată!

379,90Lei

LANSETA FL BLADE LIGHT SPIN 2.08M 2-9G

LANSETA FL BLADE LIGHT SPIN 2.08M 2-9G

64-1648
Livrare imediată!

117,91Lei

HUSA FL 3 COMPARTIMENTE 600D 1.35MT

HUSA FL 3 COMPARTIMENTE 600D 1.35MT

6241022315435
Livrare imediată!

105,90Lei

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

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

3642329991101
Livrare imediată!

450,00Lei(-29%) 319,90Lei

Varga PRO FL IRON POLE 20-60G 7MT

Varga PRO FL IRON POLE 20-60G 7MT

64-4063
Livrare imediată!

396,90Lei

AVERTIZOR INDIVIDUAL FL JY-70 CULOARE GALBENA -10%

AVERTIZOR INDIVIDUAL FL JY-70 CULOARE GALBENA

fl-jy70-galben
Livrare imediată!

47,90Lei(-10%) 42,90Lei

CUTIE PLUMBI CULISANTI FL 1-5G

CUTIE PLUMBI CULISANTI FL 1-5G

64-16285
Livrare imediată!

7,50Lei

Momitor METHOD FEEDER FL BANJO 35G

Momitor METHOD FEEDER FL BANJO 35G

ak-fl35
Livrare imediată!

9,90Lei

LANSETA FEEDER FL POWER SLAM 3.30M, 40-120G, 3 VARFURI

LANSETA FEEDER FL POWER SLAM 3.30M, 40-120G, 3 VARFURI

2101-3303
Livrare imediată!

209,90Lei

MULINETA PRO FL STRATEGIST RIVER FEEDER&CRAP 6000S

MULINETA PRO FL STRATEGIST RIVER FEEDER&CRAP 6000S

8185238614013
Livrare 48-72 ore

189,90Lei

Afişare 1 - 20 din 1973 (99 pagini)
Queries: 7, Total time: 102.567 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = 'ebceede601bd9269979cdfa4e6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.128)
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.350)
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.650)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.125)
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