FL.


MULINETA PRO FL CHASER LA5000

MULINETA PRO FL CHASER LA5000

64-13536
Livrare imediată!

113,89Lei

LINGURITA, PRO, FL, PASTRAV, SPIRAL, SPOON, 2.5G, CULOARE, 01, 64-80415, Lingurite Pastrav, Lingurite Pastrav FL., FL.
Mulineta FL DECENY 4000

Mulineta FL DECENY 4000

8242186396672
Livrare imediată!

142,35Lei

VARGA, PRO, FL, SUPREME, POLE, 8.00M, 40G, 64-4094, Vergi 8 Metri, Vergi 8 Metri FL., Vergi FL., Metri FL., FL.
Buzz Bar FL Aluminiu Negru 2021 2 Posturi

Buzz Bar FL Aluminiu Negru 2021 2 Posturi

7153212766769
Livrare imediată!

38,00Lei

Vobler FL FL147 Floating 40mm 2.1g Depth 0.5m Colour 413

Vobler FL FL147 Floating 40mm 2.1g Depth 0.5m Colour 413

fl147-floating-0.5m-40mm-2.1g-413
Livrare imediată!

17,10Lei

FIR TEXTIL SPINNING PRO FL UPGRADE PE X8 150M 0.18MM 22KG

FIR TEXTIL SPINNING PRO FL UPGRADE PE X8 150M 0.18MM 22KG

64-4649
Livrare imediată!

51,90Lei

Vobler, FL, FL512, Floating, 33mm, 4.7g, Depth, 0.6-1.8m, Colour, 338, fl512-floating-0.6-1.8m-33mm-4.7g-338, Voblere Floating, Voblere Floating FL., FL.
CARLIGE PRO FL CURVE SHANK 10BUC TEFLONATE NR 6

CARLIGE PRO FL CURVE SHANK 10BUC TEFLONATE NR 6

64-66150
Livrare imediată!

14,90Lei

LANSETA CRAP PRO FL CARP ATTACK 3SEGMENTE 3.90M 3.5LBS

LANSETA CRAP PRO FL CARP ATTACK 3SEGMENTE 3.90M 3.5LBS

64-89098
Livrare imediată!

109,90Lei

Mulineta FL Team Feeder TF 5000

Mulineta FL Team Feeder TF 5000

64-0974
Livrare imediată!

139,90Lei

CUTIE, PLUMBI, DESPICATI, PRO, FL, 0.3-2.5G, 64-81429, Plumbi Stationar, Plumbi Stationar FL., Plumbi FL., Stationar FL., FL.
LANSETA CASTING PRO FL VORTEX 10-45G 2.10M

LANSETA CASTING PRO FL VORTEX 10-45G 2.10M

64-1985
Livrare imediată!

115,89Lei

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Super Nr 8 6Buc/Set

Carlige Legate FL Method Feeder Cu Spin 7mm Carlig Super Nr 8 6Buc/Set

64-0918
Livrare imediată!

12,38Lei

HUSA FL 2022 4 COMPARTIMENTE 150CM

HUSA FL 2022 4 COMPARTIMENTE 150CM

5552248978047
Livrare imediată!

139,90Lei

Montura FL Plumb Pasta Cu Tija 80g Carlig Nr 8

Montura FL Plumb Pasta Cu Tija 80g Carlig Nr 8

64-2813
Livrare imediată!

13,90Lei

Sac Pastrare FL Cu Catarama Material Gros 100 x 120 cm

Sac Pastrare FL Cu Catarama Material Gros 100 x 120 cm

64-2062
Livrare imediată!

77,65Lei

MONTURA, FEEDER, FL, METHOD, FARA, TIJA, 30G, CARLIG, NR, 10, SPIN, 10MM, CU, PORUMB, FLOTANT, E, M, 64-1968-30-10, Monturi Complete Feeder, Monturi Complete Feeder FL., Monturi FL., Complete FL., Feeder FL., FL.
PUNGA PVA SOLUBILA FL Slow MELT 60X120 10BUC

PUNGA PVA SOLUBILA FL Slow MELT 60X120 10BUC

64-19361
Livrare imediată!

9,90Lei

HUSA FL 3 COMPARTIMENTE 600D 1.45MT -19%

HUSA FL 3 COMPARTIMENTE 600D 1.45MT

2241022618868
Livrare imediată!

111,00Lei(-19%) 89,90Lei

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 93.319 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = '50ad4891003d1dee695b4b438f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.192)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.131)
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 (34.037)
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 (58.591)
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.116)
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