Savage Gear

Savage Gear

Sortare după:

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

ANCORA DERIVA PARASUTA SAVAGE GEAR TEXTIL 120CMX120CM

ANCORA DERIVA PARASUTA SAVAGE GEAR TEXTIL 120CMX120CM

svs43831

Livrare imediată!

159,62Lei

JIG SAVAGE MICRO DART 1.2G 5BUC PL

JIG SAVAGE MICRO DART 1.2G 5BUC PL

svs55129

Livrare imediată!

25,40Lei

FIR METALIC SAVAGE GEAR CARBON49 060MM/16KG/10M

FIR METALIC SAVAGE GEAR CARBON49 060MM/16KG/10M

a.sg.54896

Livrare 24-48 ore

81,61Lei

Jacheta Savage Gear Softshell Negru Masura XL

Jacheta Savage Gear Softshell Negru Masura XL

a8.sg.59112

Livrare imediată!

430,55Lei

TWISTER SAVAGE LB CANNIBAL CURLTAIL 10CM/5G/PIKE 4BUC/PL

TWISTER SAVAGE LB CANNIBAL CURLTAIL 10CM/5G/PIKE 4BUC/PL

f1.sg.61870

Livrare imediată!

17,81Lei

SPINNERBAIT SAVAGE GEAR DA BUSH NR.3/32G WHITE SILVER

SPINNERBAIT SAVAGE GEAR DA BUSH NR.3/32G WHITE SILVER

sg.42147

Livrare 24-48 ore

52,60Lei(-35%) 34,01Lei

SHAD SAVAGE LB 4D HERRING 9CM/5G ROACH 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 9CM/5G ROACH 4BUC/PLIC

f1.sg.63651

Livrare 24-48 ore

33,95Lei(-13%) 29,52Lei

Naluca Savage Gear 3D Pulse Tail Roach Roach 10cm 17.5g 2buc/plic

Naluca Savage Gear 3D Pulse Tail Roach Roach 10cm 17.5g 2buc/plic

f1.sg.63719

Livrare 24-48 ore

57,64Lei

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 Pink Flash 14cm, 21g

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

sg.71757

Livrare 24-48 ore

41,79Lei(-34%) 27,41Lei

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 10.5cm 12g 4buc/plic Golden Ambulance

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

f1.sg.71818

Livrare imediată!

29,86Lei(-43%) 17,10Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, White Pearl, 9.8cm, 23cm, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, White Pearl, 9.8cm, 23cm, 1buc/pac

svs55352

Livrare 7-14 zile

29,48Lei

Afişare 1721 - 1740 din 1788 (90 pagini)

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

1 (0.101)

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

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

2 (0.094)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.117)

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

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

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

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

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

7 (0.130)

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