Savage Gear

Savage Gear

Sortare după:

SHAD SAVAGE LB CANNIBAL 12.5CM/20G/RED HEAD 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/20G/RED HEAD 3BUC/PLIC

svs69067-bucxxx

Livrare imediată!

22,49Lei

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Dirty Roach

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Dirty Roach

f1.sg.71820

Livrare 24-48 ore

31,23Lei(-40%) 18,64Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G MOTOR OIL

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G MOTOR OIL

f1.sg.72598

Livrare 24-48 ore

32,43Lei(-27%) 23,61Lei

Husa Savage Gear Neopren Mulineta Marime L

Husa Savage Gear Neopren Mulineta Marime L

svs74803

Livrare imediată!

48,00Lei

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.855,00Lei

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 3.5g, 3buc/pac

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 3.5g, 3buc/pac

svs82280

Livrare 7-14 zile

32,00Lei

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 2.51M 12-35G 2SEG

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 2.51M 12-35G 2SEG

o.sg.72202

Livrare 24-48 ore

481,22Lei

MONTURA SAVAGE GEAR CORKSCREW STINGER Nr.1 35kg 2BUC/PLIC

MONTURA SAVAGE GEAR CORKSCREW STINGER Nr.1 35kg 2BUC/PLIC

a.sg.72276

Livrare 24-48 ore

36,14Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

svs75805

Livrare 7-14 zile

597,55Lei(-20%) 478,03Lei

GRUB SAVAGE GEAR 5CM 0.8G GREEN PUMPKIN 8BUC/PLIC

GRUB SAVAGE GEAR 5CM 0.8G GREEN PUMPKIN 8BUC/PLIC

f1.sg.74312

Livrare 24-48 ore

13,30Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING BLACK SILVER

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING BLACK SILVER

sg.76812

Livrare 24-48 ore

39,37Lei(-28%) 28,45Lei

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

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

svs78219

Livrare 7-14 zile

46,01Lei

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 14.5cm, 80g, 1buc/pac

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 14.5cm, 80g, 1buc/pac

svs78180

Livrare 7-14 zile

64,00Lei

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

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

svs78080

Livrare 7-14 zile

42,00Lei

Vobler Savage Gear Freestyler V2, Slow Sinking, Firetiger, 11cm, 28g

Vobler Savage Gear Freestyler V2, Slow Sinking, Firetiger, 11cm, 28g

sg.77073

Livrare 24-48 ore

50,78Lei

Lanseta Spinning Savage Gear Revange SG6 Light Game 2.26m, 4-15g, 2seg

Lanseta Spinning Savage Gear Revange SG6 Light Game 2.26m, 4-15g, 2seg

o.sg.1601801

Livrare 24-48 ore

773,38Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 17.5cm, 96g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 17.5cm, 96g

1624948

Livrare 7-14 zile

52,00Lei

FIR FLUOROCARBON SAVAGE GEAR 026MM/4,7KG/50M

FIR FLUOROCARBON SAVAGE GEAR 026MM/4,7KG/50M

svs54849

Livrare imediată!

54,00Lei

NALUCA SAVAGE GEAR SUICIDE DUCK 10.5CM 28GR 01 3D

NALUCA SAVAGE GEAR SUICIDE DUCK 10.5CM 28GR 01 3D

svs53730

Livrare imediată!

68,00Lei

HANORAC SAVAGE GEAR SIMPLY SAVAGE ZIP MARIMEA 2XL

HANORAC SAVAGE GEAR SIMPLY SAVAGE ZIP MARIMEA 2XL

a8.sg.57044

Livrare 24-48 ore

236,80Lei(-60%) 95,62Lei

Afişare 2061 - 2080 din 2143 (108 pagini)

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

1 (0.155)

SELECT data
FROM `oc_session`
WHERE session_id = '72dbeacaedcf9ec313776fb61c'

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

2 (0.087)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.133)

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

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

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

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

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

7 (0.137)

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