Savage Gear

Savage Gear

Sortare după:

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN L

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN L

svs76534

Livrare 7-14 zile

269,44Lei

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/GOLDEN AMBULANCE 4BUC/PLIC

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

f1.sg.63680

Livrare 24-48 ore

34,03Lei

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G BLUE PINK SMOLT

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G BLUE PINK SMOLT

sg.63743

Livrare 24-48 ore

33,09Lei(-33%) 22,09Lei

MONTURA SAVAGE CARBON49 T-TREBLE SPIKE 1/0 11CM 2BUC/PLIC

MONTURA SAVAGE CARBON49 T-TREBLE SPIKE 1/0 11CM 2BUC/PLIC

a7.sg.69779

Livrare 24-48 ore

42,66Lei(-35%) 27,94Lei

Chatterbait SAVAGE GEAR Crazy Swim Jig, Yellow White, 12.5cm, 14.5g, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, Yellow White, 12.5cm, 14.5g, 1buc/pac

svs76738

Livrare imediată!

37,61Lei

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

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

f1.sg.71795

Livrare 24-48 ore

23,72Lei(-41%) 13,98Lei

Savage Gear Craft Cannibal Paddletail CLEAR WATER Mix 10.5cm 12g 4buc/plic

Savage Gear Craft Cannibal Paddletail CLEAR WATER Mix 10.5cm 12g 4buc/plic

f1.sg.71831

Livrare 24-48 ore

36,32Lei(-13%) 31,46Lei

CAGULA SAVAGE GEAR UV MARINE

CAGULA SAVAGE GEAR UV MARINE

a8.sg.73674

Livrare imediată!

56,31Lei

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

Afişare 881 - 900 din 1523 (77 pagini)

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

1 (0.151)

SELECT data
FROM `oc_session`
WHERE session_id = '227aee14ec91cebe6035fd2417'

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

2 (0.107)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.118)

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

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

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

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

7 (0.117)

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

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