Savage Gear


Shad Savage Gear Craft Bleak, PL Roach, 10.0cm, 6.8g, 5buc/pac

Shad Savage Gear Craft Bleak, PL Roach, 10.0cm, 6.8g, 5buc/pac

1609124
Livrare 7-14 zile

34,55Lei

Spinnertail SAVAGE GEAR Fat Tail, Dirty Roach, 6.5cm, 16g

Spinnertail SAVAGE GEAR Fat Tail, Dirty Roach, 6.5cm, 16g

sg.77063
Livrare 24-48 ore

33,63Lei

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

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

1610713
Livrare 7-14 zile

41,67Lei

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Pike, 15cm, 27g, 2buc/pac

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Pike, 15cm, 27g, 2buc/pac

1632095
Livrare 7-14 zile

41,67Lei

Vobler SAVAGE GEAR Wander Jerk Minnow Floating, Sardine, 20.5g, 14.2cm, 1buc/pac

Vobler SAVAGE GEAR Wander Jerk Minnow Floating, Sardine, 20.5g, 14.2cm, 1buc/pac

1623194
Livrare 7-14 zile

66,08Lei

Swimbait SAVAGE GEAR 3D Hybrid Pike, Lemon Pike, 47g, 17cm, 1buc/pac

Swimbait SAVAGE GEAR 3D Hybrid Pike, Lemon Pike, 47g, 17cm, 1buc/pac

svs76805
Livrare 7-14 zile

86,41Lei

Swimbait SAVAGE GEAR 3D Burbot FS, Burbot, 75g, 25cm, 1buc/pac

Swimbait SAVAGE GEAR 3D Burbot FS, Burbot, 75g, 25cm, 1buc/pac

svs53823
Livrare 7-14 zile

99,63Lei

Swimbait SAVAGE GEAR 4D Trout Rattleshad, Lemon Trout, 120g, 20.5cm, 1buc/pac

Swimbait SAVAGE GEAR 4D Trout Rattleshad, Lemon Trout, 120g, 20.5cm, 1buc/pac

svs74004
Livrare 7-14 zile

66,08Lei

Caciula SAVAGE GEAR Fold Up One, Orange

Caciula SAVAGE GEAR Fold Up One, Orange

svs73742
Livrare imediată!

52,86Lei

Spinnerbait SAVAGE GEAR Da Bush Sinking, Red Head Silver, 14cm, 21g, 1buc/pac

Spinnerbait SAVAGE GEAR Da Bush Sinking, Red Head Silver, 14cm, 21g, 1buc/pac

svs72607
Livrare imediată!

57,93Lei

Lanseta SAVAGE GEAR SG2 Medium Game Travel M, 2.15m, 10-40g, 4seg

Lanseta SAVAGE GEAR SG2 Medium Game Travel M, 2.15m, 10-40g, 4seg

svs72160
Livrare 7-14 zile

353,83Lei

Lanseta SAVAGE GEAR SGS6 All-Around ML, 7-35g, 2.74m, 2seg

Lanseta SAVAGE GEAR SGS6 All-Around ML, 7-35g, 2.74m, 2seg

svs74927
Livrare 7-14 zile

1.204,91Lei

Vobler SAVAGE GEAR 3D Sticklebait Pencil Sinking, BTS, 10.5g, 6.5cm, 1buc/pac

Vobler SAVAGE GEAR 3D Sticklebait Pencil Sinking, BTS, 10.5g, 6.5cm, 1buc/pac

svs74026
Livrare 7-14 zile

49,82Lei

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.3, Cooper, 8g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.3, Cooper, 8g, 1buc/pac

svs42124
Livrare imediată!

16,25Lei

Vobler Savage Gear Gravity Crank MR Blue Chrome 7.3cm 19g

Vobler Savage Gear Gravity Crank MR Blue Chrome 7.3cm 19g

svs71685
Livrare imediată!

37,61Lei

Vobler SAVAGE GEAR Freestyler V2 Slow Sinking, Golden Ambulane, 13cm, 46g, 1buc/pac

Vobler SAVAGE GEAR Freestyler V2 Slow Sinking, Golden Ambulane, 13cm, 46g, 1buc/pac

svs77037
Livrare 7-14 zile

62,01Lei

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Chub, 6.7cm, 7g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Chub, 6.7cm, 7g, 1buc/pac

1608962
Livrare imediată!

33,54Lei

Swimbait Articulat SAVAGE GEAR 4D Trout S, Golden Albino, 193g, 25cm, 1buc/pac

Swimbait Articulat SAVAGE GEAR 4D Trout S, Golden Albino, 193g, 25cm, 1buc/pac

svs57400
Livrare 7-14 zile

103,70Lei

SHAD SAVAGE GEAR CRAFT 10CM 6G BLUE PEARL 5BUC/PLIC -57%

SHAD SAVAGE GEAR CRAFT 10CM 6G BLUE PEARL 5BUC/PLIC

f1.sg.72418
Livrare imediată!

38,73Lei(-57%) 16,76Lei

Protectie ancora Savage Gear Treble Hook Protectors Large

Protectie ancora Savage Gear Treble Hook Protectors Large

a.sg.72328
Livrare 24-48 ore

22,13Lei

Afişare 1181 - 1200 din 2104 (106 pagini)
Queries: 7, Total time: 157.817 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'a2a83837f97e61f58974ea4d2c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.138)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.153)
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.135)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (57.662)
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 = '85'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (99.440)
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 = '0' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.186)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37