Savage Gear

Savage Gear

Sortare după:

Jig Savage Gear Rac Nr.1, 7g, 3buc/pac

Jig Savage Gear Rac Nr.1, 7g, 3buc/pac

f2.sg.74412

Livrare 24-48 ore

33,80Lei

Manusi SAVAGE GEAR Aqua Guard Glove XL, Black

Manusi SAVAGE GEAR Aqua Guard Glove XL, Black

svs51645

Livrare 7-14 zile

128,10Lei

Ascutitor pentru Carlige Savage Gear

Ascutitor pentru Carlige Savage Gear

svs48831

Livrare 7-14 zile

66,08Lei

NALUCA SAVAGE 3D HOLLOW DUCKLING 10CM/40G 02

NALUCA SAVAGE 3D HOLLOW DUCKLING 10CM/40G 02

f1.sg.57612

Livrare 24-48 ore

49,27Lei(-15%) 41,99Lei

Montura Savage Gear Carbon Ancora Nr. 1/20 Cm

Montura Savage Gear Carbon Ancora Nr. 1/20 Cm

a.sg.57403

Livrare 24-48 ore

30,67Lei(-53%) 14,39Lei

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XL

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XL

svs59131

Livrare imediată!

387,39Lei

Vobler Savage Gear 3D Smash Tail, Black Ghost, 10cm, 17g

Vobler Savage Gear 3D Smash Tail, Black Ghost, 10cm, 17g

sg.61997

Livrare 24-48 ore

48,70Lei

Shad SAVAGE GEAR 4D Line Thru Pulsetail Trout, Fire Trout, 15cm, 35g

Shad SAVAGE GEAR 4D Line Thru Pulsetail Trout, Fire Trout, 15cm, 35g

svs63750

Livrare imediată!

57,93Lei

Naluca SAVAGE GEAR 3D Suicide Duck, Natural, 15cm, 70g, 1buc/pac

Naluca SAVAGE GEAR 3D Suicide Duck, Natural, 15cm, 70g, 1buc/pac

svs53733

Livrare 7-14 zile

78,27Lei

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G FIRETIGER

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G FIRETIGER

svs71444

Livrare imediată!

37,61Lei

Geanta Impermeabila SAVAGE GEAR Roll-Up 5L, 24x16cm

Geanta Impermeabila SAVAGE GEAR Roll-Up 5L, 24x16cm

svs62410

Livrare imediată!

78,27Lei

Degetar SAVAGE GEAR Casting Sea Blue, 1buc/pac

Degetar SAVAGE GEAR Casting Sea Blue, 1buc/pac

svs73943

Livrare imediată!

52,86Lei

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 18000FD

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 18000FD

svs73128

Livrare imediată!

164,95Lei(-47%) 87,85Lei

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(-35%) 15,48Lei

Lanseta Savage Gear SG4 Ultra Light Game, 1.98m, 2-8g, 2buc

Lanseta Savage Gear SG4 Ultra Light Game, 1.98m, 2-8g, 2buc

o.sg.72190

Livrare imediată!

408,00Lei

SAPCA SAVAGE GEAR CLASSIC JAW ONE SIZE GREY MALANGE

SAPCA SAVAGE GEAR CLASSIC JAW ONE SIZE GREY MALANGE

svs73707

Livrare imediată!

76,24Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING WHITE SILVER

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING WHITE SILVER

sg.72603

Livrare 24-48 ore

42,54Lei(-45%) 23,53Lei

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS BG, 14cm, 80g, 1buc/pac

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, FS BG, 14cm, 80g, 1buc/pac

svs78207

Livrare 7-14 zile

55,91Lei

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 14.5cm, 80g, 1buc/pac

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 14.5cm, 80g, 1buc/pac

svs78180

Livrare 7-14 zile

66,08Lei

Chatterbait SAVAGE GEAR Crazy Swim Jig, Black N Red, 10cm, 8.5g, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, Black N Red, 10cm, 8.5g, 1buc/pac

svs76735

Livrare imediată!

37,61Lei

Afişare 1401 - 1420 din 1788 (90 pagini)

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

1 (0.147)

SELECT data
FROM `oc_session`
WHERE session_id = '2e39d500693b9841cce4e7e3d9'

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

2 (0.100)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.092)

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

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

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

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

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

7 (0.141)

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