Shimano


SALOPETA IMPERMEABILA SHIMANO BIBBRACE ROYAL BLUE MARIME XL -19%

SALOPETA IMPERMEABILA SHIMANO BIBBRACE ROYAL BLUE MARIME XL

shbib18rbxl
Livrare imediată!

384,75Lei(-19%) 309,90Lei

Lanseta Shimano NEXAVE 611L MOD-FAST 2.11m 3-14g

Lanseta Shimano NEXAVE 611L MOD-FAST 2.11m 3-14g

nex611lmfc
Livrare imediată!

364,75Lei

Lanseta Shimano Sedona 68ML Split Grip EVA 2.03m 7-21g 2SEG

Lanseta Shimano Sedona 68ML Split Grip EVA 2.03m 7-21g 2SEG

sed68mlfe
Livrare imediată!

384,00Lei

Lanseta Shimano FX XT M 2.40m/10-30g -37%

Lanseta Shimano FX XT M 2.40m/10-30g

fxxt24m
Livrare imediată!

190,00Lei(-37%) 119,00Lei

MULINETA SHIMANO SIENNA 4000 FG -38%

MULINETA SHIMANO SIENNA 4000 FG

sn4000fg
Livrare imediată!

200,00Lei(-38%) 125,00Lei

Mulineta Shimano Sedona FI 500 3+1rul -14%

Mulineta Shimano Sedona FI 500 3+1rul

se500fi
Livrare imediată!

268,00Lei(-14%) 229,90Lei

Husa Magnetica Shimano Sync Small Magnetic Pouch

Husa Magnetica Shimano Sync Small Magnetic Pouch

shtsc31
Livrare imediată!

9,90Lei

Minciog Shimano TX Extreme Landing Net 185cm -5%

Minciog Shimano TX Extreme Landing Net 185cm

txelnp42
Livrare imediată!

721,22Lei(-5%) 685,00Lei

Mulineta Shimano Nexave 2500 FI -38%

Mulineta Shimano Nexave 2500 FI

nex2500fi
Livrare imediată!

325,00Lei(-38%) 203,00Lei

Mulineta Shimano Soare BB C2000SS PG A, 4.6:1, 6rul

Mulineta Shimano Soare BB C2000SS PG A, 4.6:1, 6rul

soabbc2000sspga
Livrare imediată!

841,00Lei

GEANTA SHIMANO TRIBAL XTR 1 4 POUCH

GEANTA SHIMANO TRIBAL XTR 1 4 POUCH

shtrxtr102
Livrare imediată!

65,00Lei

Minciog Shimano Tribal TX Plus 190cm

Minciog Shimano Tribal TX Plus 190cm

txpln42
Livrare imediată!

548,99Lei

Mulineta, Shimano, Ultegra, FC, 2500, ult2500fc, Mulinete Rapitori, Mulinete Rapitori Shimano, Shimano -25%

Mulineta, Shimano, Ultegra, FC, 2500, ult2500fc, Mulinete Rapitori, Mulinete Rapitori Shimano, Shimano

ult2500fc
Livrare imediată!

825,00Lei(-25%) 618,00Lei

Mulineta, Shimano, Big, Baitrunner, XTB, CI4+, Longast, 14000, bbtrci4xtblc, Mulinete Crap, Mulinete Crap Shimano, Mulinete Feeder, Mulinete Feeder Shimano, Shimano -5%
MULINETA, SHIMANO, BAITRUNNER, ST, 10000, RB, btrst10000rb, Mulinete Crap, Mulinete Crap Shimano, Shimano -23%

MULINETA, SHIMANO, BAITRUNNER, ST, 10000, RB, btrst10000rb, Mulinete Crap, Mulinete Crap Shimano, Shimano

btrst10000rb
Livrare imediată!

440,00Lei(-23%) 339,00Lei

Lanseta, Shimano, Sedona, 70MH, 2.13m/14-42g, sed70mhfe, Lansete Rapitori, Lansete Rapitori Shimano, Shimano -15%

Lanseta, Shimano, Sedona, 70MH, 2.13m/14-42g, sed70mhfe, Lansete Rapitori, Lansete Rapitori Shimano, Shimano

sed70mhfe
Livrare imediată!

399,99Lei(-15%) 339,00Lei

HUSA MULTIFUNCTIONALA SHIMANO TRENCH STINK AND STICK BAG 140X23CM -21%

HUSA MULTIFUNCTIONALA SHIMANO TRENCH STINK AND STICK BAG 140X23CM

shttg11
Livrare imediată!

239,80Lei(-21%) 189,00Lei

Mulineta Shimano Ultegra FC 4000 -25%

Mulineta Shimano Ultegra FC 4000

ult4000fc
Livrare imediată!

875,00Lei(-25%) 656,00Lei

Mulineta Shimano Stella 2500FK -13%

Mulineta Shimano Stella 2500FK

stl2500fk
Livrare imediată!

3.800,00Lei(-13%) 3.323,00Lei

Mulineta Shimano Aerlex Spod 10000 XTB -31%

Mulineta Shimano Aerlex Spod 10000 XTB

alx10000xtbsp
Livrare imediată!

600,00Lei(-31%) 412,00Lei

Afişare 21 - 40 din 82 (5 pagini)
Queries: 7, Total time: 119.636 ms [By time] [By id] [By file]
1 (0.460)
SELECT data
FROM `oc_session`
WHERE session_id = 'b8a46908fc462198324aedfcc8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.264)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.331)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shimano'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.275)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '16' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (56.929)
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 = '16'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (61.202)
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 = '16' 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.175)
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