Savage Gear

Savage Gear

Sortare după:

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6CM/6G SINKING GREEN PUMPKIN

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6CM/6G SINKING GREEN PUMPKIN

f1.sg.76838

Livrare 24-48 ore

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

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

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

sg.77406

Livrare 24-48 ore

38,96Lei

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

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

svs78205

Livrare 7-14 zile

47,77Lei

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 11.5cm, 40g, 1buc/pac

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 11.5cm, 40g, 1buc/pac

svs78178

Livrare 7-14 zile

53,87Lei

Pilker SAVAGE GEAR Squid Dealer 3.0, Phantom, 14.3g, 10cm, 1buc/pac

Pilker SAVAGE GEAR Squid Dealer 3.0, Phantom, 14.3g, 10cm, 1buc/pac

svs78083

Livrare 7-14 zile

43,71Lei

Pilker SAVAGE GEAR 3D Sinking Sandeel, Motor Oil, 11g, 8.5cm, 1buc/pac

Pilker SAVAGE GEAR 3D Sinking Sandeel, Motor Oil, 11g, 8.5cm, 1buc/pac

svs62182

Livrare imediată!

41,67Lei

Teaser Savage Gear Trace Marime S, 1.00mm, 36kg, 60cm, 2buc/pac

Teaser Savage Gear Trace Marime S, 1.00mm, 36kg, 60cm, 2buc/pac

sg.1611092

Livrare 24-48 ore

33,80Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Perch, 20cm, 137g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Perch, 20cm, 137g

1624950

Livrare 7-14 zile

62,01Lei

ATRACTANT SAVAGE GEAR GARLIC SHRIMP TROUT MEAT

ATRACTANT SAVAGE GEAR GARLIC SHRIMP TROUT MEAT

a0.sg.48813

Livrare imediată!

39,00Lei(-12%) 34,45Lei

Cap Jig SAVAGE GEAR Corkscrew, 150g, 1buc/pac

Cap Jig SAVAGE GEAR Corkscrew, 150g, 1buc/pac

svs71927

Livrare 7-14 zile

37,61Lei

SHAD SAVAGE BLEAK PADDLE TAIL 8CM/4G/08 5BUC/PL

SHAD SAVAGE BLEAK PADDLE TAIL 8CM/4G/08 5BUC/PL

f1.sg.57496

Livrare 24-48 ore

28,93Lei(-12%) 25,43Lei

Fir Struna Savage 7x7 Carbon49, Grey, 0.70mm, 23kg, 10m

Fir Struna Savage 7x7 Carbon49, Grey, 0.70mm, 23kg, 10m

a.sg.54897

Livrare 24-48 ore

81,61Lei

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Roach, 16cm, 28g, 2buc/pac

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Roach, 16cm, 28g, 2buc/pac

f1.sg.57460

Livrare 24-48 ore

41,82Lei

Inele Despicate SAVAGE GEAR Stainless SR Forged SS, 14mm, 73kg, 20buc/pac

Inele Despicate SAVAGE GEAR Stainless SR Forged SS, 14mm, 73kg, 20buc/pac

svs72140

Livrare 7-14 zile

19,30Lei

STRUNA SAVAGE TITANIUM7 TRACE 20CM 030MM/7KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 20CM 030MM/7KG 2BUC/PL

a7.sg.61769

Livrare 24-48 ore

42,84Lei(-40%) 25,70Lei

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

svs54894

Livrare imediată!

78,27Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/GOLDEN AMBULANCE 5BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/GOLDEN AMBULANCE 5BUC/PLIC

f1.sg.69953

Livrare imediată!

20,19Lei(-22%) 15,69Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Perch

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Perch

f1.sg.71798

Livrare imediată!

28,51Lei(-42%) 16,40Lei

Lanseta Savage Gear SG2 Light Game 221cm 5-18g 2seg

Lanseta Savage Gear SG2 Light Game 221cm 5-18g 2seg

o.sg.72149

Livrare 24-48 ore

275,67Lei

Chatterbait SAVAGE GEAR Crazy Swim Jig, Silver Yellow White, 20g, 12.5cm, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, Silver Yellow White, 20g, 12.5cm, 1buc/pac

svs76742

Livrare 7-14 zile

41,67Lei

Afişare 2101 - 2120 din 2169 (109 pagini)

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

1 (0.133)

SELECT data
FROM `oc_session`
WHERE session_id = '64af3124cb26dafe2cc896a797'

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

2 (0.098)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.131)

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.120)

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 (45.683)

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 (78.861)

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 2100,20

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

7 (0.179)

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