Savage Gear

Savage Gear

Sortare după:

Broasca Savage Gear 3D Pop Frog, Maro, 7cm, 20g

Broasca Savage Gear 3D Pop Frog, Maro, 7cm, 20g

f1.sg.62030

Livrare 24-48 ore

46,28Lei(-20%) 37,02Lei

Shad Savage Gear Bleak Paddle Tail, Green Pearl Silver, 10cm, 4buc/plic

Shad Savage Gear Bleak Paddle Tail, Green Pearl Silver, 10cm, 4buc/plic

f1.sg.61830

Livrare imediată!

27,11Lei

SHAD SAVAGE LB 4D HERRING 11CM/9G/RED HEAD 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 11CM/9G/RED HEAD 4BUC/PLIC

f1.sg.63662

Livrare 24-48 ore

31,38Lei

VOBLER SAVAGE 3D SMASH TAIL 13.5CM/38G PERCH

VOBLER SAVAGE 3D SMASH TAIL 13.5CM/38G PERCH

sg.62000

Livrare 24-48 ore

73,48Lei

Pantofi Sport Savage Urban, Marime 44

Pantofi Sport Savage Urban, Marime 44

a8.sg.64956

Livrare 24-48 ore

236,23Lei(-35%) 154,14Lei

PENSA SAVAGE GEAR MP LONG BEND NOSE 27.5CM

PENSA SAVAGE GEAR MP LONG BEND NOSE 27.5CM

a.sg.71900

Livrare 24-48 ore

62,57Lei

Spinnerbait Savage Gear Da Bush Pink Flash 14cm, 21g

Spinnerbait Savage Gear Da Bush Pink Flash 14cm, 21g

sg.71757

Livrare 24-48 ore

41,79Lei(-40%) 25,07Lei

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

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

f1.sg.71814

Livrare imediată!

29,86Lei(-40%) 17,92Lei

Paleta SAVAGE GEAR Spinner Screwin Teaser, Marimea S, Red-Silver, 3buc/pac

Paleta SAVAGE GEAR Spinner Screwin Teaser, Marimea S, Red-Silver, 3buc/pac

svs72286

Livrare 7-14 zile

20,00Lei

Ochelari polarizati Savage Gear Savage2 Black

Ochelari polarizati Savage Gear Savage2 Black

a8.sg.72251

Livrare 24-48 ore

133,15Lei

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf Waders, Marime L 42-44

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf Waders, Marime L 42-44

1608942

Livrare 7-14 zile

1.855,00Lei

Shad Savage Gear Minnow WL Pink Pearl Silver 12.5cm 28g 3buc

Shad Savage Gear Minnow WL Pink Pearl Silver 12.5cm 28g 3buc

f1.sg.72449

Livrare 24-48 ore

54,67Lei(-20%) 43,74Lei

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr1/0, 10.6g, 2buc/pac

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr1/0, 10.6g, 2buc/pac

svs82283

Livrare 7-14 zile

40,00Lei

Lanseta Savage Gear SG2 Light Game 1.98m 5-18g 2SEG

Lanseta Savage Gear SG2 Light Game 1.98m 5-18g 2SEG

o.sg.72147

Livrare 24-48 ore

281,28Lei

Pilker SAVAGE GEAR Powerglow EGI, Culoare Blue, 17.2g, 10cm, 1buc/pac

Pilker SAVAGE GEAR Powerglow EGI, Culoare Blue, 17.2g, 10cm, 1buc/pac

svs78093

Livrare 7-14 zile

46,01Lei

MINCIOG SAVAGE GEAR FOLDING DLX L 65X50X50CM 84CM

MINCIOG SAVAGE GEAR FOLDING DLX L 65X50X50CM 84CM

svs71104

Livrare imediată!

225,01Lei

CUTIE SAVAGE DUBLA PT.NALUCI 29,5X20,5X6,2CM

CUTIE SAVAGE DUBLA PT.NALUCI 29,5X20,5X6,2CM

svs74223

Livrare imediată!

66,00Lei

Minciog Pliabil Savage Gear M 52x45x43cm 64CM

Minciog Pliabil Savage Gear M 52x45x43cm 64CM

svs71111

Livrare imediată!

172,00Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 8CM 18G SINKING BLACK SILVER

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 8CM 18G SINKING BLACK SILVER

sg.76817

Livrare 24-48 ore

44,03Lei(-30%) 30,82Lei

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN M

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN M

a8.sg.76533

Livrare 24-48 ore

245,62Lei

Afişare 1481 - 1500 din 1907 (96 pagini)

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

1 (0.189)

SELECT data
FROM `oc_session`
WHERE session_id = '505f9399681dd3534c304ee06c'

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

2 (0.107)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.140)

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

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

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

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

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

7 (0.134)

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