Savage Gear

Savage Gear

Sortare după:

Lingurita Rotativa SAGAVE GEAR Caviar, Gold, Nr.2, 6g, 1buc/pac

Lingurita Rotativa SAGAVE GEAR Caviar, Gold, Nr.2, 6g, 1buc/pac

svs40959

Livrare 7-14 zile

22,49Lei(-50%) 11,16Lei

Vobler SAVAGE GEAR Sandeel Pencil, Sandeel Ghost, 13g, 9cm, 1buc/pac

Vobler SAVAGE GEAR Sandeel Pencil, Sandeel Ghost, 13g, 9cm, 1buc/pac

svs71424

Livrare imediată!

39,64Lei

Vobler Savage Gear Gravity Crank MR Roach 7.3cm 19g

Vobler Savage Gear Gravity Crank MR Roach 7.3cm 19g

sg.71684

Livrare 24-48 ore

43,46Lei(-37%) 27,44Lei

SHAD SAVAGE GEAR CRAFT 10CM 6G FIRETIGER 5BUC/PLIC

SHAD SAVAGE GEAR CRAFT 10CM 6G FIRETIGER 5BUC/PLIC

f1.sg.72417

Livrare 24-48 ore

38,73Lei(-44%) 21,61Lei

MANUSI SAVAGE GEAR CU DEGETE TAIATE WIND PRO BLACK MAR.XL

MANUSI SAVAGE GEAR CU DEGETE TAIATE WIND PRO BLACK MAR.XL

a8.sg.76473

Livrare 24-48 ore

66,47Lei(-46%) 35,70Lei

COSTUM SAVAGE GEAR SG2 THERMAL BLUENIGHTS/BLACK XXXL

COSTUM SAVAGE GEAR SG2 THERMAL BLUENIGHTS/BLACK XXXL

a8.sg.76595

Livrare 24-48 ore

970,46Lei(-39%) 593,98Lei

Shad Savage Gear Cannibal, Flou Yellow Glow, 12.5cm, 20g, 4buc/pac

Shad Savage Gear Cannibal, Flou Yellow Glow, 12.5cm, 20g, 4buc/pac

f1.sg.77158

Livrare 24-48 ore

25,82Lei

Shad Savage Gear Fat Minnow T-Tail, Chartreuse Pumpkin, 10.5cm, 11g, 5buc/pac

Shad Savage Gear Fat Minnow T-Tail, Chartreuse Pumpkin, 10.5cm, 11g, 5buc/pac

f1.sg.76998

Livrare 24-48 ore

40,47Lei(-55%) 18,38Lei

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Cooper Red, Nr.1, 4.5g

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Cooper Red, Nr.1, 4.5g

sg.82234

Livrare 24-48 ore

27,73Lei

Lanseta Savage Gear Revange SG6 L, 5-18g, 2.13m, 2seg

Lanseta Savage Gear Revange SG6 L, 5-18g, 2.13m, 2seg

o.sg.1601798

Livrare 24-48 ore

748,13Lei

Shad SAVAGE GEAR 3D Herring Shad, Clear Rudd, 21.5cm, 65g, 1buc/pac

Shad SAVAGE GEAR 3D Herring Shad, Clear Rudd, 21.5cm, 65g, 1buc/pac

1610711

Livrare 7-14 zile

41,67Lei

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Lemon Tiger, 15cm, 27g, 2buc/pac

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Lemon Tiger, 15cm, 27g, 2buc/pac

1632100

Livrare 7-14 zile

41,67Lei

Swimbait SAVAGE GEAR 4D Herring Big Shad, Mackerel Php, 200g, 22cm, 1+2buc/pac

Swimbait SAVAGE GEAR 4D Herring Big Shad, Mackerel Php, 200g, 22cm, 1+2buc/pac

svs71904

Livrare 7-14 zile

98,62Lei

Montura SAVAGE GEAR Spinning T Stinger, Nr.2, 2buc/pac

Montura SAVAGE GEAR Spinning T Stinger, Nr.2, 2buc/pac

1612332

Livrare 7-14 zile

41,67Lei

Lanseta SAVAGE GEAR SG4 Power Game XH, 2.59m, 50-110g, 2seg

Lanseta SAVAGE GEAR SG4 Power Game XH, 2.59m, 50-110g, 2seg

svs72213

Livrare 7-14 zile

542,96Lei

Spinnerbait SAVAGE GEAR DA Bush, Blue Silver, 32g, 16cm, 1buc/pac

Spinnerbait SAVAGE GEAR DA Bush, Blue Silver, 32g, 16cm, 1buc/pac

svs72611

Livrare imediată!

66,08Lei

Vobler Articulat SAVAGE GEAR 4Play V2 Swim & Jerk, Rudd, 35g, 16.5cm, 1buc/pac

Vobler Articulat SAVAGE GEAR 4Play V2 Swim & Jerk, Rudd, 35g, 16.5cm, 1buc/pac

svs61740

Livrare 7-14 zile

78,27Lei

Spirale SAVAGE GEAR Corckscrew, Medium, 8buc/pac

Spirale SAVAGE GEAR Corckscrew, Medium, 8buc/pac

svs55140

Livrare imediată!

25,40Lei

Shad Savage Gear Craft Bleak, Lemon Glow Firetail, 7.0cm, 2.5g, 5buc/pac

Shad Savage Gear Craft Bleak, Lemon Glow Firetail, 7.0cm, 2.5g, 5buc/pac

1609107

Livrare imediată!

26,41Lei

Vobler SAVAGE GEAR Surf Walker Lure 2.0 Floating, BR Mullet, 17g, 15.5cm, 1buc/pac

Vobler SAVAGE GEAR Surf Walker Lure 2.0 Floating, BR Mullet, 17g, 15.5cm, 1buc/pac

svs78122

Livrare 7-14 zile

47,77Lei

Afişare 461 - 480 din 1442 (73 pagini)

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

1 (0.094)

SELECT data
FROM `oc_session`
WHERE session_id = '8089391548af38a7933a5c16bc'

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.112)

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

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

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

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

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

7 (0.124)

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