FL.


VOBLER, FL, SINKING, 13.5CM, 20G, ARTICULAT, CULOARE, 006, 64-3338x, Voblere Sinking, Voblere Sinking FL., FL.
LANSETA SPINNING FL REWIN 2.20M, 1-10G, 2SEG

LANSETA SPINNING FL REWIN 2.20M, 1-10G, 2SEG

64-4006
Livrare imediată!

152,90Lei

Adaos Nada Chinezeasca Nor Novac, 200g, Punga Verde

Adaos Nada Chinezeasca Nor Novac, 200g, Punga Verde

400-8821 573-verde
Livrare imediată!

19,90Lei

MONTURA, FL, MOMITOR, 50G, CARLIG, NR, 6, LEADCORE, 60CM, RIG, 9CM, 4182361917022, Monturi Crap, Monturi Crap FL., Monturi FL., Crap FL., FL.
Montura, FL, Leadcore, Plumb, Pierdut, Grippa, Plumb, 80, Gr, Carlig, KRANK, Nr, 6, 64-0109, Monturi Crap, Monturi Crap FL., Monturi FL., Crap FL., FL.
CARLIGE PRO FL CAT FISH HOOK TEFLONATE NR 5/0 10BUC

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

64-26321
Livrare imediată!

10,90Lei

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

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

64-71086-xl-70
Livrare imediată!

29,90Lei

Lanseta, Feeder, FL, Strategist, Distance, MH, 4.50M, 80-150G, 3Seg, 64-4082, Lansete Feeder, Lansete Feeder FL., Lansete FL., Feeder FL., FL.
Momeala Chinezeasca Caras Gold Edition 2 300g

Momeala Chinezeasca Caras Gold Edition 2 300g

10301191
Livrare imediată!

21,90Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 11, 64-80514, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Pichet Telescopic FL Subtire Negru Fara Bughiu

Pichet Telescopic FL Subtire Negru Fara Bughiu

1231205906326
Livrare imediată!

24,20Lei

Mulineta FL LJ 5000

Mulineta FL LJ 5000

2272203513719
Livrare imediată!

107,90Lei

UNDITA PRO FL EPOCA TRAVEL 5-30G 10 SECTIUNI 69CM 5.40M

UNDITA PRO FL EPOCA TRAVEL 5-30G 10 SECTIUNI 69CM 5.40M

64-4101
Livrare imediată!

159,90Lei

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

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

2153218229492
Livrare imediată!

249,90Lei

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

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

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

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.12MM, 150M, 10KG, 64-4496, 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 989

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

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

17,10Lei

LANSETA, FEEDER, PRO, FL, ULTRA, FEEDER, 120-180G, 3.90M, 64-89029, Lansete Feeder, Lansete Feeder FL., Lansete FL., Feeder FL., FL.
Tambur de Rezerva Pentru FL Strategist TX 7000 Black Edition

Tambur de Rezerva Pentru FL Strategist TX 7000 Black Edition

8178214993172
Livrare imediată!

51,80Lei

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ALB ROSU

SISTEM COMPLET ZIG RIG PRO FL PT LICHID ALB ROSU

64-65924
Livrare imediată!

20,90Lei

Afişare 101 - 120 din 1618 (81 pagini)
Queries: 7, Total time: 89.701 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = '6437d66bef09b701998dca0201'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.060)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.105)
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 (34.914)
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 (54.300)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.135)
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