Savage Gear

Savage Gear

Sortare după:

Lanseta SAVAGE GEAR Fury SG6 Boat Spinning Rod EH, 150-400g, 2.13m, 1+1seg

Lanseta SAVAGE GEAR Fury SG6 Boat Spinning Rod EH, 150-400g, 2.13m, 1+1seg

1601715

Livrare 7-14 zile

1.044,24Lei

SAVAGE GEAR VOBLER GRAVITY TWITCH SR 8,3CM/10G FIRETIGER

SAVAGE GEAR VOBLER GRAVITY TWITCH SR 8,3CM/10G FIRETIGER

svs71654

Livrare imediată!

37,61Lei

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 3, Dirty Silver, 9.1g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Sticklebait Spinner 3, Dirty Silver, 9.1g, 1buc/pac

svs82244

Livrare 7-14 zile

29,48Lei

Vobler Savage Gear Gravity Twitch SR Dirty Roach 8.3cm 10g

Vobler Savage Gear Gravity Twitch SR Dirty Roach 8.3cm 10g

sg.71656

Livrare 24-48 ore

35,53Lei

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Black Red Black, Nr.1, 3.8g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Black Red Black, Nr.1, 3.8g, 1buc/pac

svs82464

Livrare 7-14 zile

24,39Lei

LINGURITA ROTATIVA SAVAGE CAVIAR NR.2 GOLD 6G

LINGURITA ROTATIVA SAVAGE CAVIAR NR.2 GOLD 6G

f.sg.40959

Livrare 24-48 ore

22,31Lei

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 90g, 12.5cm, 1buc/pac

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 90g, 12.5cm, 1buc/pac

1608972

Livrare 7-14 zile

78,27Lei

Vobler Articulat SAVAGE GEAR 4Play V2 Swim & Jerk, Roach, 20g, 13.5cm, 1buc/pac

Vobler Articulat SAVAGE GEAR 4Play V2 Swim & Jerk, Roach, 20g, 13.5cm, 1buc/pac

svs61726

Livrare 7-14 zile

66,08Lei

Swimbait SAVAGE GEAR Sandeel V2 Sinking, White Pearl Silver, 33g, 14cm, 1+2buc/pac

Swimbait SAVAGE GEAR Sandeel V2 Sinking, White Pearl Silver, 33g, 14cm, 1+2buc/pac

svs72496

Livrare 7-14 zile

39,64Lei

Mulineta SAVAGE GEAR Real Casting SG6 300 BC RH 5P1BB 5.6

Mulineta SAVAGE GEAR Real Casting SG6 300 BC RH 5P1BB 5.6

svs76079

Livrare 7-14 zile

999,94Lei(-70%) 302,66Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FIRETIGER

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FIRETIGER

sg.72324

Livrare 24-48 ore

46,00Lei(-28%) 33,21Lei

Suruburi SAVAGE GEAR Screwin Weight Spike, 3.5g, 12buc/pac

Suruburi SAVAGE GEAR Screwin Weight Spike, 3.5g, 12buc/pac

svs61954

Livrare 7-14 zile

31,50Lei

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Horny Squid, 160g, 25cm, 1buc/pac

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Horny Squid, 160g, 25cm, 1buc/pac

svs78163

Livrare 7-14 zile

70,14Lei

Shad SAVAGE GEAR CRAFT 7,2CM/2,6G GREEN SILVER 4BUC/PL

Shad SAVAGE GEAR CRAFT 7,2CM/2,6G GREEN SILVER 4BUC/PL

f1.sg.74076

Livrare 24-48 ore

28,50Lei(-56%) 12,58Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING MINNOW

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING MINNOW

sg.74112

Livrare 24-48 ore

44,98Lei(-16%) 37,59Lei

Swimbait SAVAGE GEAR 4D Trout Line, Golden Albino MS02, 15cm, 40g

Swimbait SAVAGE GEAR 4D Trout Line, Golden Albino MS02, 15cm, 40g

svs57386

Livrare imediată!

57,93Lei

GEANTA SAVAGE GEAR BOAT&BANK 24L 36X23X28CM

GEANTA SAVAGE GEAR BOAT&BANK 24L 36X23X28CM

svs74158

Livrare 7-14 zile

333,50Lei

Shad SAVAGE GEAR Collapser, Purple Ghost, 44g, 22cm, 2buc/pac

Shad SAVAGE GEAR Collapser, Purple Ghost, 44g, 22cm, 2buc/pac

1623214

Livrare 7-14 zile

49,82Lei

GRIP SAVAGE GEAR LIGHT LIP ALU 16,5CM

GRIP SAVAGE GEAR LIGHT LIP ALU 16,5CM

svs71160

Livrare 7-14 zile

166,92Lei

Vobler SAVAGE GEAR Petit G Crank SR Floating, Goldmine, 4cm, 4.3g, 1buc/pac

Vobler SAVAGE GEAR Petit G Crank SR Floating, Goldmine, 4cm, 4.3g, 1buc/pac

1610669

Livrare 7-14 zile

37,61Lei

Afişare 1081 - 1100 din 2104 (106 pagini)

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

1 (0.098)

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

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

2 (0.082)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.100)

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

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

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

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

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

7 (0.216)

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