FL.


Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

Lanseta FL FLX9 3.60M 3.75Lbs 3Seg

flx9-3603
Livrare imediată!

208,25Lei

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

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

4552272873074
Livrare imediată!

129,90Lei

Porumb, Artificial, Flotant, FL, 20Buc/Plic, Marime, S, Rosu, 6427559019507, Porumb Artificial, Porumb Artificial FL., Porumb FL., Artificial FL., FL.
MONTURA, FEEDER, FL, METHOD, CU, TIJA, 30G, CARLIG, NR, 6, SPIN, 10MM, CU, PORUMB, FLOTANT, 64-1971-30-6, Monturi Complete Feeder, Monturi Complete Feeder FL., Monturi FL., Complete FL., Feeder FL., FL.
CARLIGE FL CATFISH 10BUC/PLIC MARIME 1/0

CARLIGE FL CATFISH 10BUC/PLIC MARIME 1/0

6101200501190
Livrare imediată!

7,98Lei

LANSETA FL BLADE FAST SPIN 2.25M 4-18G

LANSETA FL BLADE FAST SPIN 2.25M 4-18G

64-1652
Livrare imediată!

127,90Lei

Minciog, FL, Telescopic, Cu, Plasa, Cauciucata, 50, x, 65, CM, 64-2300, Mincioguri Rapitor, Mincioguri Rapitor FL., FL. -20%

Minciog, FL, Telescopic, Cu, Plasa, Cauciucata, 50, x, 65, CM, 64-2300, Mincioguri Rapitor, Mincioguri Rapitor FL., FL.

64-2300
Livrare imediată!

175,00Lei(-20%) 139,90Lei

Undita Chinezeasca FL Ying Huali Putere 2kg, 5.4m

Undita Chinezeasca FL Ying Huali Putere 2kg, 5.4m

3642396083952
Livrare imediată!

205,30Lei

MULINETA, FL, LH, 1000, 6RULMENTI, 64-1014, Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., Mulinete Rapitori, Mulinete Rapitori FL., Mulinete FL., Rapitori FL., Mulinete Bolognese, Mulinete Bolognese FL., Mulinete FL., Bolognese FL., Mulinete Match, Mulinete Match FL., Mulinete FL., Match FL., FL.
FEEDER GUM TRANSPARENT FL 10M 1MM

FEEDER GUM TRANSPARENT FL 10M 1MM

65-25789
Livrare imediată!

8,90Lei

PLUTA, CHINEZASCA, INTELIGENTA, FL, CU, BATERIE, 5G,, 40CM,, CULOARE, ALBA, A003, 64-45100, Plute Stationar, Plute Stationar FL., Plute FL., Stationar FL., FL.
Set 5 Varfuri Feeder FL Carbon, Grosime 2.9mm, 120g/150g/180g/200g/250g

Set 5 Varfuri Feeder FL Carbon, Grosime 2.9mm, 120g/150g/180g/200g/250g

64-1336
Livrare imediată!

85,89Lei

VOBLER, FL, SINKING, 13.5CM, 20G, ARTICULAT, CULOARE, 005, 64-3337x, Voblere Sinking, Voblere Sinking FL., FL.
UNDITA PRO FL PHENOMENON 10-30G, 4.00M

UNDITA PRO FL PHENOMENON 10-30G, 4.00M

64-4031
Livrare imediată!

76,90Lei

Undita Chinezeasca FL Create Miracles 5.4m

Undita Chinezeasca FL Create Miracles 5.4m

7962380654064
Livrare imediată!

295,91Lei

METHOD DURA FEEDER INLINE PRO FL X-LARGE 50G

METHOD DURA FEEDER INLINE PRO FL X-LARGE 50G

64-19767
Livrare imediată!

11,90Lei

MULINETA, PRO, FL, FEEDER, ZONE, 5000, fz-5000, Mulinete Crap, Mulinete Crap FL., Mulinete FL., Crap FL., Mulinete Feeder, Mulinete Feeder FL., Mulinete FL., Feeder FL., FL.
CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 4/0 10BUC

CARLIGE PRO FL OCTOPUS BEAK HOOK TEFLONATE NR 4/0 10BUC

64-26376
Livrare imediată!

10,90Lei

Cap Minciog FL, Plasa Naylon, 40x50cm

Cap Minciog FL, Plasa Naylon, 40x50cm

8177206687648
Livrare imediată!

55,20Lei

Juvelnic Pro FL Ultra Match Plus Competition 50x40 4.00m

Juvelnic Pro FL Ultra Match Plus Competition 50x40 4.00m

64-23382
Livrare imediată!

225,90Lei

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 91.022 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '737dbe8842d191a12790165f38'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.139)
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 (35.863)
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:1667
6 (54.555)
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 = '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:438
7 (0.130)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38