Savage Gear

Savage Gear

Sortare după:

Vobler SAVAGE GEAR Suspending Lure 3D Shrimp Twitch DR, BSH, 5.2cm, 6.5g, 1buc/pac

Vobler SAVAGE GEAR Suspending Lure 3D Shrimp Twitch DR, BSH, 5.2cm, 6.5g, 1buc/pac

svs77033

Livrare 7-14 zile

36,00Lei

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.1, Dirty Silver, 3.5g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.1, Dirty Silver, 3.5g, 1buc/pac

svs42113

Livrare 7-14 zile

15,01Lei

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

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

svs77035

Livrare 7-14 zile

60,00Lei

Vobler Savage Gear Fat Vibes Firetiger 6.6cm 22g

Vobler Savage Gear Fat Vibes Firetiger 6.6cm 22g

svs71672

Livrare 7-14 zile

43,99Lei

Spinnertail SAVAGE GEAR Fat Tail NL, Lemon BF, 6.5cm, 12.5g, 1buc/pac

Spinnertail SAVAGE GEAR Fat Tail NL, Lemon BF, 6.5cm, 12.5g, 1buc/pac

svs77054

Livrare 7-14 zile

34,00Lei

Paravan SAVAGE GEAR MP Left, Marime L, 1buc/pac

Paravan SAVAGE GEAR MP Left, Marime L, 1buc/pac

svs43085

Livrare 7-14 zile

131,00Lei

Lanseta SAVAGE GEAR SG4 Medium Game Baitcast M, 10-30g, 2.13m, 2seg

Lanseta SAVAGE GEAR SG4 Medium Game Baitcast M, 10-30g, 2.13m, 2seg

svs72204

Livrare 7-14 zile

470,00Lei

HANORAC SAVAGE GEAR CLASSIC ZIP GREY MELANGE MARIME S

HANORAC SAVAGE GEAR CLASSIC ZIP GREY MELANGE MARIME S

a8.sg.73692

Livrare 24-48 ore

199,82Lei

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Pink Glow, 90g, 18cm, 1buc/pac

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Pink Glow, 90g, 18cm, 1buc/pac

svs78157

Livrare 7-14 zile

56,00Lei

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.M

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.M

svs76462

Livrare 7-14 zile

73,99Lei

Swimbait SAVAGE GEAR 4D LT PT Trout SS, Perch, 20cm, 102g

Swimbait SAVAGE GEAR 4D LT PT Trout SS, Perch, 20cm, 102g

svs69365

Livrare imediată!

84,00Lei

Shad SAVAGE GEAR CRAFT 10CM/6G CLEAR WATER MIX 5BUC/PL

Shad SAVAGE GEAR CRAFT 10CM/6G CLEAR WATER MIX 5BUC/PL

f1.sg.74098

Livrare 24-48 ore

39,92Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Smelt, 11.5cm, 28g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Smelt, 11.5cm, 28g, 1buc/pac

1634464

Livrare 7-14 zile

43,99Lei

Swimbait SAVAGE GEAR 4D Line Thru Pulse Tail Trout SS, Lemon Trout, 16cm, 51g, 1buc/pac

Swimbait SAVAGE GEAR 4D Line Thru Pulse Tail Trout SS, Lemon Trout, 16cm, 51g, 1buc/pac

svs73994

Livrare 7-14 zile

76,01Lei

PENAR JIGURI SAVAGE GEAR ROLL UP 32X13CM

PENAR JIGURI SAVAGE GEAR ROLL UP 32X13CM

svs77322

Livrare imediată!

68,00Lei

PANTALONI SAVAGE GEAR REGENERATOR KOMBU GREEN XL

PANTALONI SAVAGE GEAR REGENERATOR KOMBU GREEN XL

a8.sg.76541

Livrare 24-48 ore

245,62Lei

Naluca Savage Gear Fat Tail NL 6.5cm 12.5g Sinking Dirty Roach

Naluca Savage Gear Fat Tail NL 6.5cm 12.5g Sinking Dirty Roach

sg.77055

Livrare 24-48 ore

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

Shad Savage Gear Cannibal, Purple Glitter Bomb, 10cm, 9g, 5buc/pac

Shad Savage Gear Cannibal, Purple Glitter Bomb, 10cm, 9g, 5buc/pac

f1.sg.77150

Livrare 24-48 ore

21,50Lei

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

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

f1.sg.77013

Livrare 24-48 ore

48,20Lei(-20%) 38,56Lei

Vobler Savage Gear Deviator Swim, Slow Sinking, Firetiger, 10.5cm, 35g

Vobler Savage Gear Deviator Swim, Slow Sinking, Firetiger, 10.5cm, 35g

sg.69869

Livrare 24-48 ore

49,88Lei

Afişare 441 - 460 din 1899 (95 pagini)

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

1 (0.126)

SELECT data
FROM `oc_session`
WHERE session_id = 'ad0a0ee7aff6c049eb5ea4c9e6'

/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.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.125)

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

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

5 (40.244)

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 = '2' AND p.manufacturer_id = '85'

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

6 (61.884)

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 = '2' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 440,20

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

7 (0.126)

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

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