Savage Gear

Savage Gear

Sortare după:

Lanseta SAVAGE GEAR SG4 Crankbait Specialist BC ML, 10-27g, 2.30m

Lanseta SAVAGE GEAR SG4 Crankbait Specialist BC ML, 10-27g, 2.30m

svs75804

Livrare 7-14 zile

624,95Lei(-54%) 288,63Lei

Fir Monofilament Savage Gear Silencer 0.465mm 15.56kg 300m

Fir Monofilament Savage Gear Silencer 0.465mm 15.56kg 300m

a.sg.72272

Livrare 24-48 ore

65,85Lei(-40%) 39,53Lei

TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.S

a8.sg.73649

Livrare 24-48 ore

98,06Lei(-20%) 78,44Lei

GEANTA SAVAGE GEAR L 5.4L

GEANTA SAVAGE GEAR L 5.4L

a8.sg.74155

Livrare 24-48 ore

91,11Lei

Shad SAVAGE GEAR CRAFT 10CM/6G BLUE PEARL 4BUC/PL

Shad SAVAGE GEAR CRAFT 10CM/6G BLUE PEARL 4BUC/PL

f1.sg.74092

Livrare imediată!

33,25Lei(-60%) 13,30Lei

Lanseta SAVAGE GEAR SGS4 Boat Game MF XXH, 150-400g, 2.93m, 2seg

Lanseta SAVAGE GEAR SGS4 Boat Game MF XXH, 150-400g, 2.93m, 2seg

svs75811

Livrare 7-14 zile

699,99Lei(-54%) 321,99Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Clear Wagasaki, 9.5cm, 16.5g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Clear Wagasaki, 9.5cm, 16.5g, 1buc/pac

1610638

Livrare 7-14 zile

40,00Lei

Vobler SAVAGE GEAR Deviator Swim SS Glider, Chrome Perch, 12.5cm, 50g, 1buc/pac

Vobler SAVAGE GEAR Deviator Swim SS Glider, Chrome Perch, 12.5cm, 50g, 1buc/pac

1625293

Livrare 7-14 zile

64,00Lei

Creatura SAVAGE GEAR Craft Crawler, Motoroil UV, 12.5cm, 6.4g, 6buc/pac

Creatura SAVAGE GEAR Craft Crawler, Motoroil UV, 12.5cm, 6.4g, 6buc/pac

svs69837

Livrare 7-14 zile

28,00Lei

Lanseta SAVAGE GEAR SG4 Fast Game BC Trigger Travel Rod, 30-80g, 2.21m, 4seg

Lanseta SAVAGE GEAR SG4 Fast Game BC Trigger Travel Rod, 30-80g, 2.21m, 4seg

1609921

Livrare 7-14 zile

592,00Lei

Naluca Savage Gear Fat Tail NL 6.5cm 12.5g Sinking Ayu

Naluca Savage Gear Fat Tail NL 6.5cm 12.5g Sinking Ayu

sg.77051

Livrare 24-48 ore

37,41Lei(-40%) 22,46Lei

Shad Savage Gear Cannibal, Olive Hot Orange, 12.5cm, 20g, 4buc/pac

Shad Savage Gear Cannibal, Olive Hot Orange, 12.5cm, 20g, 4buc/pac

f1.sg.77154

Livrare 24-48 ore

23,51Lei

Shad Savage Gear Fat Minnow T-Tail, Smelt, 13cm, 20g, 5buc/pac

Shad Savage Gear Fat Minnow T-Tail, Smelt, 13cm, 20g, 5buc/pac

f1.sg.77000

Livrare 24-48 ore

51,90Lei(-60%) 20,77Lei

Genta Accesorii SAVAGE GEAR System Box 12ltr

Genta Accesorii SAVAGE GEAR System Box 12ltr

svs74242

Livrare imediată!

306,00Lei

Minciong Wizard Mxt Street 1150, 60x50x65cm

Minciong Wizard Mxt Street 1150, 60x50x65cm

71061610

Livrare 24-48 ore

233,04Lei

Shad Savage Gear Craft Bleak, Holo Baitfish, 10.0cm, 6.8g, 5buc/pac

Shad Savage Gear Craft Bleak, Holo Baitfish, 10.0cm, 6.8g, 5buc/pac

f1.sg.1609125

Livrare 24-48 ore

32,09Lei

Spinnertail SAVAGE GEAR Fat Tail, Black Magic, 6.5cm, 16g

Spinnertail SAVAGE GEAR Fat Tail, Black Magic, 6.5cm, 16g

sg.77065

Livrare 24-48 ore

32,62Lei

Shad SAVAGE GEAR 3D Herring Shad, Bream, 21.5cm, 65g, 1buc/pac

Shad SAVAGE GEAR 3D Herring Shad, Bream, 21.5cm, 65g, 1buc/pac

1610719

Livrare 7-14 zile

40,00Lei

Swimbait Savage Gear Conger EEL, Ocean Flash, 160g, 22cm, 1buc/pac

Swimbait Savage Gear Conger EEL, Ocean Flash, 160g, 22cm, 1buc/pac

1623234

Livrare 7-14 zile

68,00Lei

Swimbait SAVAGE GEAR Hard EEL, Blue Silver, 17cm, 50g, 1buc/pac

Swimbait SAVAGE GEAR Hard EEL, Blue Silver, 17cm, 50g, 1buc/pac

svs74132

Livrare 7-14 zile

76,01Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 2027 (102 pagini)

Queries: 7, Total time: 106.712 ms [By time] [By id] [By file]

1 (0.082)

SELECT data
FROM `oc_session`
WHERE session_id = '60335bf05dbe8ad277abf6a17d'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.086)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.093)

SELECT *
FROM oc_url_alias
WHERE keyword = 'savage-gear.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.092)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '85' AND m2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (42.500)

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 = '85'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (63.730)

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 = '3' AND p.manufacturer_id = '85' 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.129)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37