FL.


LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 10

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 10

64-80507
Livrare imediată!

11,90Lei

MINCIOG PRO FL COADA TELESCOPICA 160CM DESCHIDERE 70X55CM

MINCIOG PRO FL COADA TELESCOPICA 160CM DESCHIDERE 70X55CM

6427559061049
Livrare imediată!

109,90Lei

Mulineta FL LJ 6000

Mulineta FL LJ 6000

4272205717687
Livrare imediată!

109,90Lei

LANSETA SPINNING PRO FL MEBARU 1.98M 0.5-5G

LANSETA SPINNING PRO FL MEBARU 1.98M 0.5-5G

64-7409
Livrare imediată!

137,90Lei

Minciog FL Strategist 200K Coada 2 Segmente Carbon 3K 2M Deschidere 1M

Minciog FL Strategist 200K Coada 2 Segmente Carbon 3K 2M Deschidere 1M

5153213113250
Livrare imediată!

283,20Lei

SET PRO FL PVA CU TUB SI PLUNGER 25MM 7M

SET PRO FL PVA CU TUB SI PLUNGER 25MM 7M

64-65627
Livrare imediată!

49,90Lei

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

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

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

17,10Lei

FIR, TEXTIL, FEEDER, PRO, FL, SINKNKING, X8, 0.14MM, 150M, 15KG, 64-4502, 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, 993, fl512-floating-0.6-1.8m-33mm-4.7g-993, Voblere Floating, Voblere Floating FL., FL.
SPINI MOMEALA PRO FL 5MM 25buc/plic

SPINI MOMEALA PRO FL 5MM 25buc/plic

64-26710
Livrare imediată!

8,90Lei

Montura, FL, Leadcore, Plumb, Pierdut, Long, Cast, Plumb, 100, Gr, Carlig, BNR, Nr, 4, 64-0185, Monturi Crap, Monturi Crap FL., FL.
LANSETA, FEEDER, PRO, FL, ULTRA, FEEDER, 120-180G, 4.20M, 64-89036, Lansete Feeder, Lansete Feeder FL., Lansete FL., Feeder FL., FL.
Momitor Method Feeder FL Tija Interschimbabila Dura Flat Marime M 40g

Momitor Method Feeder FL Tija Interschimbabila Dura Flat Marime M 40g

64-0697
Livrare imediată!

8,90Lei

LANSETA, PRO, FL, X, POWER, FEEDER, 60-180G, 4.50M, 65-46272, Lansete Feeder, Lansete Feeder FL., Lansete FL., Feeder FL., FL.
Set 4 Conectori Rapizi Coonor Inox

Set 4 Conectori Rapizi Coonor Inox

3832215666330
Livrare imediată!

79,90Lei

Mulineta FL Tempo 6000 S

Mulineta FL Tempo 6000 S

64-8071
Livrare imediată!

148,39Lei

MONTURA, FEEDER, FL, METHOD, FARA, TIJA, 40G, CARLIG, NR, 8, SPIN, 10MM, CU, PORUMB, FLOTANT, E, G, 64-1969-40-8, Monturi Complete Feeder, Monturi Complete Feeder FL., Monturi FL., Complete FL., Feeder FL., FL.
VARGA FL AVENTADOR TLS 8M

VARGA FL AVENTADOR TLS 8M

64-1780
Livrare imediată!

449,90Lei

LANSETA CRAP FL TOURNAMENT 2022 3.90M 3.5LBS 3SEGMENTE

LANSETA CRAP FL TOURNAMENT 2022 3.90M 3.5LBS 3SEGMENTE

64-1670
Livrare imediată!

189,00Lei

Set Avertizoare FL Cu Clips Lanseta 2buc/Set

Set Avertizoare FL Cu Clips Lanseta 2buc/Set

5129196926088
Livrare imediată!

19,00Lei

Afişare 21 - 40 din 1618 (81 pagini)
Queries: 7, Total time: 90.511 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'c498da4781bbaaf890cc21eb71'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
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.128)
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 (35.468)
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.410)
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 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.125)
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