FL.


COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 2.50M

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 2.50M

3102-2503
Livrare imediată!

99,00Lei

LANSETA CRAP FL EXCIA FAST CARP HI STREGHTH 3.60M 3.5LBS 3SEGMENTE

LANSETA CRAP FL EXCIA FAST CARP HI STREGHTH 3.60M 3.5LBS 3SEGMENTE

3501-3603
Livrare imediată!

199,90Lei

Lanseta FL Feeder Force Active 3.60 M 60-180 Gr

Lanseta FL Feeder Force Active 3.60 M 60-180 Gr

6427559015011
Livrare imediată!

149,90Lei

Lanseta BOLOGNEZA PRO FL POWER ESPIRIT 40-90G 6MT

Lanseta BOLOGNEZA PRO FL POWER ESPIRIT 40-90G 6MT

64-5045
Livrare imediată!

379,90Lei

MULINETA FL HP 6000 7RULMENTI

MULINETA FL HP 6000 7RULMENTI

64-35095
Livrare imediată!

90,90Lei

Momitor, METHOD, FEEDER, PRO, FL, Arc, FLAT, 50G, , ak-af50, Momitoare Method Feeder, Momitoare Method Feeder FL., FL.
STARLIGHT FL 4.5MM 5BUC/PLIC

STARLIGHT FL 4.5MM 5BUC/PLIC

6942546200190
Livrare imediată!

2,50Lei

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

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

2101-3603
Livrare imediată!

215,90Lei

MULINETA PRO FL MT 14000 MOSTERUS CARP 10RULMENTI

MULINETA PRO FL MT 14000 MOSTERUS CARP 10RULMENTI

mt-14000
Livrare imediată!

329,90Lei

CAP SUPORT Feeder V PRO FL ROSU

CAP SUPORT Feeder V PRO FL ROSU

64-26406
Livrare imediată!

18,90Lei

MONTURA, INLINE, LEADCORE, FL, PLUMB, LONG, CAST, 80G, CARLIG, NR, 2, 64-0380, Monturi Crap, Monturi Crap FL., Monturi FL., Crap FL., FL.
CARLIGE LEGATE FL V-CURVE FEEDER CU SPIN 8/SET CARLIG NR 8

CARLIGE LEGATE FL V-CURVE FEEDER CU SPIN 8/SET CARLIG NR 8

64-19996
Livrare imediată!

19,90Lei

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

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

64-45353
Livrare imediată!

171,90Lei

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

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

64-7109-xl-60
Livrare imediată!

27,91Lei

MONTURA FL FEEDER MFS CU SPIN 30G CARLIG NR 10 SPIN 7MM

MONTURA FL FEEDER MFS CU SPIN 30G CARLIG NR 10 SPIN 7MM

ak-mfs30/10
Livrare imediată!

15,90Lei

MULINETA, PRO, FL, ULTIMATE, FEEDER, FD, 7000, 7183249439251, Mulinete Match, Mulinete Match FL., Mulinete FL., Match FL., Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., FL.
BOLOGNEZA FL RANGER 10-30G 4M

BOLOGNEZA FL RANGER 10-30G 4M

65-46371
Livrare imediată!

62,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 3.5G, CULOARE, 07, 64-80606, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Avertizor FL JY 16

Avertizor FL JY 16

8242180966116
Livrare imediată!

51,90Lei

Vobler, FL, FL122, Floating, 40mm, 2.7g, Depth, 0.2-0.8m, Colour, 266, fl122-floating-0.2-0.8m-40mm-2.7g-266, Voblere Floating, Voblere Floating FL., FL.
Afişare 1 - 20 din 1619 (81 pagini)
Queries: 7, Total time: 88.225 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = 'c6fdd2be3f1da1e4d7ffcc9139'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.685)
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 = '2' AND p.manufacturer_id = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (53.068)
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 = '2' 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.095)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38