FL.


CUTIE PLUMBI CULISANTI FL 1-5G

CUTIE PLUMBI CULISANTI FL 1-5G

64-16285
Livrare imediată!

7,50Lei

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

64-45766
Livrare imediată!

72,90Lei

SET 3 CARLIGE LEGATE PLUS CROSETA SI OPRITOARE NR 4 15LB PRO FL

SET 3 CARLIGE LEGATE PLUS CROSETA SI OPRITOARE NR 4 15LB PRO FL

64-48613
Livrare imediată!

11,90Lei

MONTURA, INLINE, LEADCORE, FL, PLUMB, INTERSCHIMBABIL, PLAT, 80G, CARLIG, NR, 2, 64-0383, Monturi Crap, Monturi Crap FL., Monturi FL., Crap FL., FL.
CARLIGE, LEGATE, FL, WIDE, GAPE, FEEDER, CU, SPIN, 8/SET, CARLIG, NR, 10, 64-19965, Carlige Legate Feeder, Carlige Legate Feeder FL., FL.
HANGER, FL, ILUMINAT, CULOARE, Rosu, fl-sw-11-red, Swingere Hangere, Swingere Hangere FL., FL.

HANGER, FL, ILUMINAT, CULOARE, Rosu, fl-sw-11-red, Swingere Hangere, Swingere Hangere FL., FL.

fl-sw-11-red
Livrare imediată!

21,90Lei

SET 2BUC PRO FL METHOD FEEDER DOUBLE CHANCE 60G

SET 2BUC PRO FL METHOD FEEDER DOUBLE CHANCE 60G

64-26468
Livrare imediată!

23,90Lei

MONTURA FL FEEDER MFM CU SPIN 45G CARLIG NR 10 SPIN 7MM

MONTURA FL FEEDER MFM CU SPIN 45G CARLIG NR 10 SPIN 7MM

ak-mfm45/10
Livrare imediată!

17,90Lei

MULINETA PRO FL PIONER LAC 3000

MULINETA PRO FL PIONER LAC 3000

4183247026104
Livrare imediată!

92,90Lei

LANSETA PRO FL FALCONS FEEDER 3.90M 180G

LANSETA PRO FL FALCONS FEEDER 3.90M 180G

6253246320379
Livrare imediată!

166,90Lei

LINGURITA PRO FL PASTRAV 3CM 3G CULOARE N005

LINGURITA PRO FL PASTRAV 3CM 3G CULOARE N005

64-80408
Livrare imediată!

11,90Lei

Cosulet Feeder FL CS4 30

Cosulet Feeder FL CS4 30

cs4-30
Livrare imediată!

5,20Lei

Lanseta Feeder FL Black Force 3.90M 60-180Gr 2Segmente

Lanseta Feeder FL Black Force 3.90M 60-180Gr 2Segmente

6224243599044
Livrare imediată!

196,90Lei

Lanseta Feeder FL Strategist River HH 4,20M 100-200G 3Seg

Lanseta Feeder FL Strategist River HH 4,20M 100-200G 3Seg

2153211485352
Livrare imediată!

308,20Lei

CLESTE PENTRU FIR TEXTIL PRO FL BRAID SCISSORS LUMINOS TEFLON

CLESTE PENTRU FIR TEXTIL PRO FL BRAID SCISSORS LUMINOS TEFLON

64-65658
Livrare imediată!

64,90Lei

Vobler, FL, FL137B, Floating, 78mm, 8.8g, Depth, 1.5m, Colour, 282, fl137b-floating-1.5m-78mm-8.8g-282, Voblere Floating, Voblere Floating FL., FL.
Vobler, FL, FL510, Floating, 36mm, 4.0g, Depth, 1.0m, Colour, 837, fl510-floating-1.0m-36mm-4.0g-837, Voblere Floating, Voblere Floating FL., FL.
CARLIGE PRO FL RADICAL 10BUC TEFLONATE NR 2

CARLIGE PRO FL RADICAL 10BUC TEFLONATE NR 2

64-66266
Livrare imediată!

14,90Lei

SET 2 BATERII CU SISTEM DE INCARCARE Pentru Plute Inteligente sau AVERTIZOARE LUMINOASE

SET 2 BATERII CU SISTEM DE INCARCARE Pentru Plute Inteligente sau AVERTIZOARE LUMINOASE

6105247946341
Livrare imediată!

26,91Lei

SISTEM ANTITANGLE FEEDER PRO FL 3BUC

SISTEM ANTITANGLE FEEDER PRO FL 3BUC

64-65986
Livrare imediată!

10,90Lei

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 115.235 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '542d95d7c06e6c4e8b5114f96f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.122)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.124)
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 (59.703)
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:1661
6 (54.972)
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.141)
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