Savage Gear

Savage Gear

Sortare după:

CICADA SAVAGE GEAR VIB BLADE 5.5CM/14.5G GREEN SILVER AYU

CICADA SAVAGE GEAR VIB BLADE 5.5CM/14.5G GREEN SILVER AYU

sg.71446

Livrare imediată!

41,31Lei

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

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

f1.sg.71798

Livrare imediată!

28,51Lei(-42%) 16,40Lei

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

275,67Lei

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

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

svs76742

Livrare 7-14 zile

41,67Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G RED UV

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G RED UV

f1.sg.72596

Livrare 24-48 ore

32,43Lei(-43%) 18,40Lei

Husa Savage Gear Neopren Mulineta Marime L

Husa Savage Gear Neopren Mulineta Marime L

svs74803

Livrare imediată!

49,82Lei

Ghete SAVAGE GEAR Sg8 Wading Boot Cleat Cleat, Nr.43

Ghete SAVAGE GEAR Sg8 Wading Boot Cleat Cleat, Nr.43

1601855

Livrare 7-14 zile

571,43Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 8.3CM 10G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 8.3CM 10G

sg.74123

Livrare 24-48 ore

43,28Lei(-35%) 28,31Lei

KIT SAVAGE GEAR EASYON SPINNER BAIT SILVER MARIME L 2BUC/PLIC

KIT SAVAGE GEAR EASYON SPINNER BAIT SILVER MARIME L 2BUC/PLIC

a.sg.72290

Livrare 24-48 ore

22,30Lei(-20%) 17,79Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

svs75805

Livrare 7-14 zile

597,55Lei(-18%) 487,07Lei

GRUB SAVAGE GEAR 5CM 0.8G LUNEBUG 8BUC/PLIC

GRUB SAVAGE GEAR 5CM 0.8G LUNEBUG 8BUC/PLIC

f1.sg.74313

Livrare 24-48 ore

14,53Lei

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(-24%) 33,25Lei

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

Pilker SAVAGE GEAR Super Cast EGI ND3.0, Boops, 19g, 10.5cm, 1buc/pac

Pilker SAVAGE GEAR Super Cast EGI ND3.0, Boops, 19g, 10.5cm, 1buc/pac

svs78069

Livrare 7-14 zile

62,01Lei

Pilker SAVAGE GEAR Sandeel Pencil Sinking, Black Silver, 13g, 9cm, 1buc/pac

Pilker SAVAGE GEAR Sandeel Pencil Sinking, Black Silver, 13g, 9cm, 1buc/pac

svs71425

Livrare imediată!

39,64Lei

Lanseta Spinning Savage Gear Revange SG6 Light Game 1.98m, 7-21g, 1seg

Lanseta Spinning Savage Gear Revange SG6 Light Game 1.98m, 7-21g, 1seg

o.sg.1601796

Livrare 24-48 ore

787,38Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Blue Perch, 17.5cm, 96g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Blue Perch, 17.5cm, 96g

1624949

Livrare 7-14 zile

53,87Lei

Pantofi Casual CoolFit Savage Gear Marimea 45

Pantofi Casual CoolFit Savage Gear Marimea 45

a8.sg.51149

Livrare imediată!

210,53Lei

SAPCA SAVAGE SIMPLY SAVAGE LOGO 3D

a8.sg.57051

Livrare imediată!

54,10Lei

Montura Savage Gear Carbon Ancore Nr. 1/9 Cm

Montura Savage Gear Carbon Ancore Nr. 1/9 Cm

a.sg.54881

Livrare imediată!

29,26Lei

Afişare 2061 - 2080 din 2169 (109 pagini)

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

1 (0.110)

SELECT data
FROM `oc_session`
WHERE session_id = '18cd80d3b2a2bdc8c193aa5edd'

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

2 (0.156)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.311)

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

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

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

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

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

7 (0.247)

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