FL.


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

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

64-26291
Livrare imediată!

10,90Lei

Husa FL pentru 5 Lansete cu Mulinete, 210cm

Husa FL pentru 5 Lansete cu Mulinete, 210cm

6193214485894
Livrare imediată!

349,90Lei

Maner Mincioc FL Carbon 3K 1.80 2Seg

Maner Mincioc FL Carbon 3K 1.80 2Seg

1177201370924
Livrare imediată!

120,80Lei

SET, PRO, FL, 2BUC, IN-LINE, METHOD, FEEDER, MARIME, L, 60G, 64-71031-l-60, Momitoare Method Feeder, Momitoare Method Feeder FL., Momitoare FL., Method FL., Feeder FL., FL.
MONTURA FL FEEDER MFD CU SPIN 50G CARLIG NR 8 SPIN 7MM

MONTURA FL FEEDER MFD CU SPIN 50G CARLIG NR 8 SPIN 7MM

ak-mfd50/8
Livrare imediată!

13,90Lei

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

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 01

64-80415
Livrare imediată!

11,90Lei

Mulineta FL DECENY 4000

Mulineta FL DECENY 4000

8242186396672
Livrare imediată!

142,35Lei

VARGA PRO FL SUPREME POLE 8.00M 40G

VARGA PRO FL SUPREME POLE 8.00M 40G

64-4094
Livrare imediată!

255,90Lei

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, fl147-floating-0.5m-40mm-2.1g-413, Voblere Floating, Voblere Floating FL., FL.
FIR, TEXTIL, SPINNING, PRO, FL, UPGRADE, PE, X8, 150M, 0.18MM, 22KG, , 64-4649, Fire Textile Rapitori, Fire Textile Rapitori FL., Fire FL., Textile FL., Rapitori FL., FL.
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

CUTIE PLUMBI DESPICATI PRO FL 0.3-2.5G

64-81429
Livrare imediată!

9,90Lei

LANSETA, CASTING, PRO, FL, VORTEX, 10-45G, 2.10M, 64-1985, Lansete Rapitori, Lansete Rapitori FL., Lansete FL., Rapitori FL., FL.
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

Afişare 1 - 20 din 1618 (81 pagini)
Queries: 7, Total time: 88.809 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '0d8779d1ef12ec49f2e568705f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.140)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.422)
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 = '2' AND p.manufacturer_id = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (52.721)
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 = '2' 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.163)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38