Shimano


Lanseta Shimano FX XT MH 2.40m/14-40g -36%

Lanseta Shimano FX XT MH 2.40m/14-40g

fxxt24mh
Livrare imediată!

189,99Lei(-36%) 122,00Lei

Mulineta Shimano Aero Technium MgS XTD 14000 -9%

Mulineta Shimano Aero Technium MgS XTD 14000

artcmgs14000xtd
Livrare imediată!

3.750,00Lei(-9%) 3.399,89Lei

Lanseta SHIMANO TX 4A Crap Intensity 3.66m, 3.50lbs, 2seg

Lanseta SHIMANO TX 4A Crap Intensity 3.66m, 3.50lbs, 2seg

sh.tx4a12int
Livrare 24-48 ore

820,55Lei

FIR TEXTIL SHIMANO KAIRIKI 8 BRAIDED LINE YELLOW 150M 0.13MM -28%

FIR TEXTIL SHIMANO KAIRIKI 8 BRAIDED LINE YELLOW 150M 0.13MM

59wpla58r32
Livrare imediată!

99,80Lei(-28%) 71,67Lei

Fir Monofilament SHIMANO Technium, Gri, 8.5kg, 0.305mm, 650m

Fir Monofilament SHIMANO Technium, Gri, 8.5kg, 0.305mm, 650m

tec65030pb
Livrare imediată!

78,90Lei

Tricou Shimano Tactical Pique Polo marime XXL -3%

Tricou Shimano Tactical Pique Polo marime XXL

shttw17xxl
Livrare imediată!

114,80Lei(-3%) 111,93Lei

Mulineta SHIMANO Aero BB 4000, 0.35mm/130m, 4.7:1, 3+1rul -28%

Mulineta SHIMANO Aero BB 4000, 0.35mm/130m, 4.7:1, 3+1rul

aerobb4000
Livrare imediată!

439,99Lei(-28%) 315,89Lei

Lanseta SHIMANO Zodias 268L, 3-10g, 2.03m, 1+1seg -17%

Lanseta SHIMANO Zodias 268L, 3-10g, 2.03m, 1+1seg

20zodias268ls
Livrare imediată!

991,18Lei(-17%) 825,00Lei

Lanseta Shimano Bassterra LRF 2.44m 3-15g

Lanseta Shimano Bassterra LRF 2.44m 3-15g

bstrlrf80lp
Livrare imediată!

382,05Lei

Lanseta Shimano TX-2A Carp Intensity, 3.05m, 3.00lbs, 2seg

Lanseta Shimano TX-2A Carp Intensity, 3.05m, 3.00lbs, 2seg

tx2a10300
Livrare imediată!

536,90Lei

FIR TEXTIL SHIMANO KAIRIKI 8 BRAIDED LINE YELLOW 150M 0.10MM -28%

FIR TEXTIL SHIMANO KAIRIKI 8 BRAIDED LINE YELLOW 150M 0.10MM

59wpla58r31
Livrare imediată!

99,90Lei(-28%) 71,66Lei

Fir Monofilament SHIMANO Technium, Gri, 7.5kg, 0.285mm, 200m

Fir Monofilament SHIMANO Technium, Gri, 7.5kg, 0.285mm, 200m

tec20028
Livrare imediată!

38,90Lei

Lanseta Shimano Aero X5 Distance Heavy Power Feeder Rod 14ft 4.27m 150g 3+3buc -24%

Lanseta Shimano Aero X5 Distance Heavy Power Feeder Rod 14ft 4.27m 150g 3+3buc

aex5dhpfdr14
Livrare imediată!

1.264,99Lei(-24%) 964,93Lei

Lanseta SHIMANO Zodias 268ML, 4-12g, 2.03m, 1+1seg -15%

Lanseta SHIMANO Zodias 268ML, 4-12g, 2.03m, 1+1seg

20zodias268ml
Livrare imediată!

974,99Lei(-15%) 824,99Lei

Husa Shimano Tactical 13ft Rod Sleeve

Husa Shimano Tactical 13ft Rod Sleeve

shtxl19
Livrare imediată!

114,88Lei

Umbrela Shimano Aero Pro 50in Nylon Umbrella, Diam=250cm -25%

Umbrela Shimano Aero Pro 50in Nylon Umbrella, Diam=250cm

sharpumb01
Livrare imediată!

699,99Lei(-25%) 521,59Lei

Mulineta Shimano Exsence A Saltwater Spinning Fishing Reel C 3000 MHGA -9%

Mulineta Shimano Exsence A Saltwater Spinning Fishing Reel C 3000 MHGA

exsc3000mhga
Livrare imediată!

2.749,99Lei(-9%) 2.504,99Lei

Lanseta SHIMNAO Aero X7A Distance Feeder, 130g, 4.11m, 3+3seg -6%

Lanseta SHIMNAO Aero X7A Distance Feeder, 130g, 4.11m, 3+3seg

aex7adfdr136
Livrare imediată!

1.652,32Lei(-6%) 1.561,00Lei

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ă!

392,05Lei

Lanseta SHIMANO Stradic Spinning Rod M, 7-21g, 2.23m, 2seg

Lanseta SHIMANO Stradic Spinning Rod M, 7-21g, 2.23m, 2seg

sstr74mlfe
Livrare 48-72ore

846,99Lei

Afişare 1 - 20 din 69 (4 pagini)
Queries: 8, Total time: 66.688 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = 'c6ab2f58c2bebceb63690aa368'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.066)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Shimano'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.094)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.690)
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 = '16'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (31.434)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 = '16' 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:440
7 (0.111)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.077)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37