Savage Gear

Savage Gear

Sortare după:

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Roach, 16cm, 28g, 2buc/pac

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Roach, 16cm, 28g, 2buc/pac

f1.sg.57460

Livrare 24-48 ore

39,25Lei

STRUNA SAVAGE TITANIUM7 TRACE 30CM 040MM/13KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 30CM 040MM/13KG 2BUC/PL

svs61770

Livrare imediată!

43,99Lei

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

svs54894

Livrare imediată!

76,01Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/BLUE PEARL 5BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/BLUE PEARL 5BUC/PLIC

f1.sg.69950

Livrare 24-48 ore

20,19Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Firetiger

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Firetiger

f1.sg.71801

Livrare imediată!

23,72Lei(-40%) 14,23Lei

Lanseta Savage Gear SG2 Light Game 221cm 5-18g 2seg

Lanseta Savage Gear SG2 Light Game 221cm 5-18g 2seg

o.sg.72149

Livrare 24-48 ore

269,23Lei

BLUZA SAVAGE GEAR MARINE UV LONG SLEEVE TEE SEA BLUE MARIME L

BLUZA SAVAGE GEAR MARINE UV LONG SLEEVE TEE SEA BLUE MARIME L

a8.sg.73666

Livrare 24-48 ore

158,14Lei

Degetar SAVAGE GEAR Casting Sea Blue, 1buc/pac

Degetar SAVAGE GEAR Casting Sea Blue, 1buc/pac

svs73943

Livrare imediată!

51,00Lei

Shad Savage Gear Minnow WL KHAKI 10cm 16g 3buc

Shad Savage Gear Minnow WL KHAKI 10cm 16g 3buc

f1.sg.72439

Livrare 24-48 ore

50,13Lei(-20%) 40,10Lei

Cizme Piept SAVAGE GEAR Sg8 Chest Sf XXLS, Marime 45-47

Cizme Piept SAVAGE GEAR Sg8 Chest Sf XXLS, Marime 45-47

1608957

Livrare 7-14 zile

1.726,00Lei

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 14000FD

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 14000FD

svs73127

Livrare 7-14 zile

149,95Lei(-43%) 85,41Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, Orange Gold Glow, 9.7cm, 150g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, Orange Gold Glow, 9.7cm, 150g, 1buc/pac

svs77311

Livrare 7-14 zile

76,01Lei

Pilker SAVAGE GEAR Surf Seeker S, Black Pearl, 11cm, 40g, 1buc/pac

Pilker SAVAGE GEAR Surf Seeker S, Black Pearl, 11cm, 40g, 1buc/pac

svs71792

Livrare 7-14 zile

38,00Lei

LANSETA SAVAGE GEAR SG4 CAST CRANK VIB SPECIALIST TRIGGER 2.30M 7-24G 2SEG

LANSETA SAVAGE GEAR SG4 CAST CRANK VIB SPECIALIST TRIGGER 2.30M 7-24G 2SEG

svs72234

Livrare imediată!

599,95Lei(-69%) 188,97Lei

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.36mm 8.40kg 40m

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.36mm 8.40kg 40m

svs72240

Livrare imediată!

62,00Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 2 A 16.1X9.1X3.1CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 2 A 16.1X9.1X3.1CM

svs76769

Livrare imediată!

21,00Lei

SET CUTII SAVAGE GEAR PT.NALUCI 21,4X1,8X4,5CM 3BUC

SET CUTII SAVAGE GEAR PT.NALUCI 21,4X1,8X4,5CM 3BUC

svs74232

Livrare imediată!

107,00Lei

Pilker SAVAGE GEAR Powerglow EGI, Culoare Bule, 22.8g, 11cm, 1buc/pac

Pilker SAVAGE GEAR Powerglow EGI, Culoare Bule, 22.8g, 11cm, 1buc/pac

svs78088

Livrare 7-14 zile

46,01Lei

Jig Savage Gear Stand-Up nr.3/0 25g 3buc/plic

Jig Savage Gear Stand-Up nr.3/0 25g 3buc/plic

f2.sg.76762

Livrare 24-48 ore

32,01Lei(-50%) 16,01Lei

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

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

sg.76819

Livrare 24-48 ore

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

Afişare 1241 - 1260 din 2027 (102 pagini)

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

1 (0.100)

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

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

2 (0.073)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.098)

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

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

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

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

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

7 (0.109)

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