Savage Gear


KIT SHAD SAVAGE 3D ROACH S&J 7.5CM/19G/3BUC/PL

KIT SHAD SAVAGE 3D ROACH S&J 7.5CM/19G/3BUC/PL

f1.sg.57444
Livrare 24-48 ore

40,87Lei

Fir Monofilament Savage Gear Regenerator 0.70mm 26kg 30m

Fir Monofilament Savage Gear Regenerator 0.70mm 26kg 30m

svs54841
Livrare imediată!

30,49Lei

Inele Despicate SAVAGE GEAR Stainless SR Forged SS, 12mm, 62kg, 20buc/pac

Inele Despicate SAVAGE GEAR Stainless SR Forged SS, 12mm, 62kg, 20buc/pac

svs72139
Livrare 7-14 zile

19,30Lei

Montura Savage Gear Titan Corkscrew, 2 Ancore, Nr.1/0

Montura Savage Gear Titan Corkscrew, 2 Ancore, Nr.1/0

a.sg.61774
Livrare imediată!

44,87Lei

Inele Despicate SAVAGE GEAR Broken Rings Splitring, 4mm, 11kg, 10buc/pac

Inele Despicate SAVAGE GEAR Broken Rings Splitring, 4mm, 11kg, 10buc/pac

svs73951
Livrare 7-14 zile

13,20Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/BLUE PEARL 5BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/BLUE PEARL 5BUC/PLIC

f1.sg.69950
Livrare 24-48 ore

22,45Lei

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Olive Hot Orange -35%

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Olive Hot Orange

f1.sg.71808
Livrare imediată!

25,42Lei(-35%) 16,50Lei

Broasca SAVAGE GEAR Hop Walker Frog, Gill, 5.5cm, 15g, 1buc/pac

Broasca SAVAGE GEAR Hop Walker Frog, Gill, 5.5cm, 15g, 1buc/pac

svs77437
Livrare 7-14 zile

45,74Lei

CICADA STRIKE PRO ASTRO BLADE 5.5CM 17.7G X10E

CICADA STRIKE PRO ASTRO BLADE 5.5CM 17.7G X10E

sp.pjg005bc.x10e
Livrare imediată!

37,09Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 16CM 32G SINKING BLUE SILVER -46%

SPINNERBAIT SAVAGE GEAR DA BUSH 16CM 32G SINKING BLUE SILVER

sg.72611
Livrare 24-48 ore

54,60Lei(-46%) 29,67Lei

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf Waders, Marime XXLS 45-47

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf Waders, Marime XXLS 45-47

1608947
Livrare 7-14 zile

1.887,18Lei

HUSA SAVAGE GEAR 1 LANSETA 140CM

HUSA SAVAGE GEAR 1 LANSETA 140CM

svs74150
Livrare 7-14 zile

171,82Lei

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 7.2g, 2buc/pac

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 7.2g, 2buc/pac

svs82282
Livrare 7-14 zile

31,50Lei

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.92mm 40.5kg 15M

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.92mm 40.5kg 15M

a.sg.54858
Livrare 24-48 ore

127,38Lei

SET CUTII SAVAGE GEAR PT.NALUCI 10.5X6.8X2.6CM 3BUC

SET CUTII SAVAGE GEAR PT.NALUCI 10.5X6.8X2.6CM 3BUC

svs74228
Livrare imediată!

26,41Lei

SET CUTII SAVAGE GEAR PT.NALUCI 16,1X9,1X3,1CM 3BUC

SET CUTII SAVAGE GEAR PT.NALUCI 16,1X9,1X3,1CM 3BUC

svs74230
Livrare imediată!

68,11Lei

Broasca Savage Gear Hop Walker Gill 5.5cm 15g

Broasca Savage Gear Hop Walker Gill 5.5cm 15g

f1.sg.77437
Livrare 24-48 ore

45,71Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6CM/4G SINKING WHITE PEARL -53%

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6CM/4G SINKING WHITE PEARL

f1.sg.76837
Livrare 24-48 ore

28,44Lei(-53%) 13,49Lei

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 5.6CM 15G S HOLO PINK GLOW

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 5.6CM 15G S HOLO PINK GLOW

sg.77404
Livrare 24-48 ore

38,96Lei

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS PF, 10cm, 40g, 1buc/pac

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS PF, 10cm, 40g, 1buc/pac

svs78217
Livrare 7-14 zile

47,77Lei

Afişare 1761 - 1780 din 2170 (109 pagini)
Queries: 7, Total time: 128.378 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = 'b7b0ee7d18817a0177d6602199'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.083)
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.080)
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 (58.761)
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 (69.130)
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 1760,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
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