Savage Gear

Savage Gear

Sortare după:

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G BROWN ORANGE

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G BROWN ORANGE

f1.sg.72595

Livrare 24-48 ore

32,43Lei(-23%) 25,01Lei

Husa Savage Gear Neopren Mulineta Marime XL

Husa Savage Gear Neopren Mulineta Marime XL

svs74804

Livrare 7-14 zile

64,95Lei(-45%) 35,43Lei

MULINETA SAVAGE GEAR SG4 4000 FD 8+1BB/150M/028MM/5,2:1/

MULINETA SAVAGE GEAR SG4 4000 FD 8+1BB/150M/028MM/5,2:1/

o.sg.74728

Livrare imediată!

243,59Lei(-49%) 124,84Lei

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.36mm 8.40kg 40m

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.36mm 8.40kg 40m

svs72240

Livrare imediată!

64,05Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

svs76774

Livrare imediată!

39,64Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 8CM 5G DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 8CM 5G DIRTY ROACH 4BUC/PLIC

f1.sg.74283

Livrare 24-48 ore

34,98Lei

Lanterna Cap Frontala Savage Gear UV Zoom 5W 400 Lumeni

Lanterna Cap Frontala Savage Gear UV Zoom 5W 400 Lumeni

svs70777

Livrare imediată!

92,50Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING BLACK RED

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING BLACK RED

sg.76810

Livrare 24-48 ore

38,19Lei(-24%) 29,09Lei

BLUZA SAVAGE SIGNATURE LOGO LONG SLEEVE BLACK CAVIAR MAR.S

svs73908

Livrare 7-14 zile

101,66Lei

Jig Savage Gear Rac Nr.2/0, 5g, 3buc/pac

Jig Savage Gear Rac Nr.2/0, 5g, 3buc/pac

f2.sg.74415

Livrare 24-48 ore

33,80Lei

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.60mm 18.90kg 50m

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.60mm 18.90kg 50m

a.sg.74492

Livrare 24-48 ore

114,48Lei(-39%) 69,59Lei

Spinnerbait SAVAGE GEAR, Red Silver, Nr.3, 32g

Spinnerbait SAVAGE GEAR, Red Silver, Nr.3, 32g

sg.43640

Livrare 24-48 ore

54,56Lei(-35%) 35,21Lei

STRUNA SAVAGE TITANIUM7 TRACE 35CM 040MM 15KG 2BUC PLIC

STRUNA SAVAGE TITANIUM7 TRACE 35CM 040MM 15KG 2BUC PLIC

svs54876

Livrare imediată!

62,01Lei

GEANTA SAVAGE GEAR DE UMAR, 20X31X15CM

GEANTA SAVAGE GEAR DE UMAR, 20X31X15CM

a8.sg.54780

Livrare 24-48 ore

227,12Lei(-28%) 163,57Lei

JACHETA SAVAGE HEATLITE THERMO MARIMEA M

JACHETA SAVAGE HEATLITE THERMO MARIMEA M

svs59125

Livrare 7-14 zile

500,25Lei

Broasca Savage Gear 3D Walk Frog, Culoare 62036, 7cm, 20g

Broasca Savage Gear 3D Walk Frog, Culoare 62036, 7cm, 20g

f1.sg.62036

Livrare 24-48 ore

46,28Lei(-15%) 39,55Lei

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

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

f1.sg.63654

Livrare 24-48 ore

33,78Lei

NALUCA SAVAGE GEAR 4D REAL EEL 20CM/38G FIRETIGER PHP

NALUCA SAVAGE GEAR 4D REAL EEL 20CM/38G FIRETIGER PHP

svs63767

Livrare imediată!

66,08Lei

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

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

svs78089

Livrare 7-14 zile

47,77Lei

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Green Silver

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Green Silver

f1.sg.71821

Livrare imediată!

19,05Lei

Afişare 841 - 860 din 1523 (77 pagini)

Queries: 8, Total time: 137.931 ms [By time] [By id] [By file]

1 (0.161)

SELECT data
FROM `oc_session`
WHERE session_id = '287af58a8fa7bf37d903ad6e4c'

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

2 (0.101)

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

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

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

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

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

7 (0.128)

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=185567'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169

8 (0.135)

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