Savage Gear

Savage Gear

Sortare după:

Fir Savage Gear Regenerator 050MM/14.5KG/30M

Fir Savage Gear Regenerator 050MM/14.5KG/30M

svs54839

Livrare 7-14 zile

25,40Lei

Jacheta Savage Gear Camo Masura S

Jacheta Savage Gear Camo Masura S

a8.sg.57920

Livrare 24-48 ore

605,06Lei(-49%) 309,53Lei

Shad Savage Gear Fat Minnow T-Tail, YR Fluo, 9cm, 4buc/plic

Shad Savage Gear Fat Minnow T-Tail, YR Fluo, 9cm, 4buc/plic

f1.sg.61812

Livrare imediată!

21,51Lei

Carlige Offset Savage Gear EWG Nr.10/0 5g 2buc

Carlige Offset Savage Gear EWG Nr.10/0 5g 2buc

f2.sg.61779

Livrare 24-48 ore

41,68Lei

SHAD SAVAGE 4D LINE THRU PULSETAIL TROUT 16CM/51G RAINBOW

SHAD SAVAGE 4D LINE THRU PULSETAIL TROUT 16CM/51G RAINBOW

svs61975

Livrare imediată!

78,27Lei

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/PERCH 3BUC/PLIC

f1.sg.69972

Livrare imediată!

15,84Lei

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

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

svs82288

Livrare 7-14 zile

33,54Lei

Spinnerbait Savage Gear Da Bush Motor Oil 14cm 21g

Spinnerbait Savage Gear Da Bush Motor Oil 14cm 21g

sg.71756

Livrare imediată!

41,79Lei(-37%) 26,49Lei

Pilker SAVAGE GEAR Surf Seeker S, White Pearl, 10.5cm, 35g, 1buc/pac

Pilker SAVAGE GEAR Surf Seeker S, White Pearl, 10.5cm, 35g, 1buc/pac

svs71787

Livrare 7-14 zile

37,61Lei

Shad Savage Gear Craft Cannibal Paddletail Firetiger, 10.5cm, 12g, 4buc/pac

Shad Savage Gear Craft Cannibal Paddletail Firetiger, 10.5cm, 12g, 4buc/pac

f1.sg.71817

Livrare imediată!

29,86Lei(-33%) 20,13Lei

Shad Savage Gear Minnow WL BLUE PEARL SILVER 10cm 16g 3buc

Shad Savage Gear Minnow WL BLUE PEARL SILVER 10cm 16g 3buc

f1.sg.72441

Livrare imediată!

50,13Lei(-15%) 42,69Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Black Pearl, 10cm, 28g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Black Pearl, 10cm, 28g, 1buc/pac

svs55356

Livrare 7-14 zile

31,50Lei

Fir Fluorocarbon SAVAGE GEAR Super Hard, Clear, 25.70kg, 0.77mm, 50m

Fir Fluorocarbon SAVAGE GEAR Super Hard, Clear, 25.70kg, 0.77mm, 50m

svs74494

Livrare 7-14 zile

173,86Lei

Shad SAVAGE GEAR LB Cannibal, Perch, 6.8cm, 3g, 80buc/pac

Shad SAVAGE GEAR LB Cannibal, Perch, 6.8cm, 3g, 80buc/pac

svs58985

Livrare 7-14 zile

276,55Lei

LANSETA SAVAGE GEAR SG2 CAST MEDIUM GAME TRIGGER 2.13M 10-30G 2SEG

LANSETA SAVAGE GEAR SG2 CAST MEDIUM GAME TRIGGER 2.13M 10-30G 2SEG

o.sg.72159

Livrare 24-48 ore

387,19Lei(-28%) 277,50Lei

Shad Savage Gear Cannibal Shad 6.8cm 3g Chartreus

Shad Savage Gear Cannibal Shad 6.8cm 3g Chartreus

f1.sg.74528

Livrare 24-48 ore

20,52Lei

GEANTA SAVAGE GEAR SPECIALIST LURE 25X35X14CM INCL.6 CUTII

GEANTA SAVAGE GEAR SPECIALIST LURE 25X35X14CM INCL.6 CUTII

svs74234

Livrare imediată!

312,14Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G DARK WATER MIX 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G DARK WATER MIX 4BUC/PLIC

f1.sg.74309

Livrare 24-48 ore

47,69Lei

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

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

sg.76818

Livrare 24-48 ore

44,03Lei(-24%) 33,25Lei

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Albino Roach, 12cm, 34g

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Albino Roach, 12cm, 34g

1625352

Livrare 7-14 zile

41,67Lei

Afişare 1241 - 1260 din 1786 (90 pagini)

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

1 (0.132)

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

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

2 (0.114)

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

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

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

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

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

7 (0.144)

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