FL.


Undita Chinezeasca FL High Carbon Putere 5kg 7.2m

Undita Chinezeasca FL High Carbon Putere 5kg 7.2m

3642360344683
Livrare imediată!

357,00Lei

AVERTIZOR INDIVIDUAL FL JY-75 CULOARE Albastru

AVERTIZOR INDIVIDUAL FL JY-75 CULOARE Albastru

fl-jy-75-albastru
Livrare imediată!

47,90Lei

PLUTA CHINEZASCA INTELIGENTA FL CU BATERIE 5G, 40CM, CULOARE ALBA A002

PLUTA CHINEZASCA INTELIGENTA FL CU BATERIE 5G, 40CM, CULOARE ALBA A002

64-45063
Livrare imediată!

29,90Lei

VOBLER, FL, SINKING, 10CM, 15.5G, ARTICULAT, CULOARE, 002, 64-3325x, Voblere Sinking, Voblere Sinking FL., FL.
LANSETA SPINNING FL GREAT 2.40M, 3-20G, 2SEG

LANSETA SPINNING FL GREAT 2.40M, 3-20G, 2SEG

64-4005
Livrare imediată!

154,90Lei

Adaos Nada Chinezeasca Nor Novac, 100g, Punga Alba

Adaos Nada Chinezeasca Nor Novac, 100g, Punga Alba

400-8821 573-alb
Livrare imediată!

14,90Lei

Montura, FL, Leadcore, Plumb, Pierdut, Long, Cast, Plumb, 80, Gr, Carlig, Wide, Gape, Nr, 8, 64-0086, Monturi Crap, Monturi Crap FL., Monturi FL., Crap FL., FL.
CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 4/0 10BUC

CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 4/0 10BUC

64-26314
Livrare imediată!

10,90Lei

Sistem, Balama, Pentru, Plute, FL, S, 10/set, 3452165688154, Plute Stationar, Plute Stationar FL., Plute FL., Stationar FL., FL.
Varga FL Fine Special 6M

Varga FL Fine Special 6M

1244151595766
Livrare imediată!

145,91Lei

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

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

64-71055-xl-40
Livrare imediată!

23,90Lei

MONTURA FL FEEDER MFD CU SPIN 80G CARLIG NR 10 SPIN 7MM

MONTURA FL FEEDER MFD CU SPIN 80G CARLIG NR 10 SPIN 7MM

ak-mfd80/10
Livrare imediată!

14,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 09, 64-80491, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Mulineta FL LJ 4000

Mulineta FL LJ 4000

1272205401831
Livrare imediată!

91,50Lei

UNDITA PRO FL EPOCA TRAVEL 5-30G 9 SECTIUNI 69CM 4.80M

UNDITA PRO FL EPOCA TRAVEL 5-30G 9 SECTIUNI 69CM 4.80M

64-4100
Livrare imediată!

139,90Lei

Minciog FL Strategist 180 Coada 1 Segment Carbon 1.80M Deschidere 1M

Minciog FL Strategist 180 Coada 1 Segment Carbon 1.80M Deschidere 1M

4153212542182
Livrare imediată!

199,90Lei

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 784

Vobler FL FL158 Sinking 70mm 9.6g Depth All Round Colour 784

fl158-sinking-allround-70mm-9.6g-784
Livrare imediată!

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.10MM, 150M, 7KG, 64-4489, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder FL., Fire FL., Textile FL., Monofilament FL., Feeder FL., FL.
Vobler FL FL512 Floating 33mm 4.7g Depth 0.6-1.8m Colour 783

Vobler FL FL512 Floating 33mm 4.7g Depth 0.6-1.8m Colour 783

fl512-floating-0.6-1.8m-33mm-4.7g-783
Livrare imediată!

17,10Lei

CARLIGE, PRO, FL, CURVE, SHANK, 10BUC, TEFLONATE, NR, 10, 64-66174, Carlige Crap, Carlige Crap FL., Carlige FL., Crap FL., FL.
Afişare 81 - 100 din 1618 (81 pagini)
Queries: 7, Total time: 124.468 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = 'e01c8a2386afbbf83efbee73aa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.111)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.103)
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 (66.873)
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 (57.022)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.158)
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