Savage Gear

Savage Gear

Sortare după:

LANSETA SPINNING SAVAGE GEAR 2BUC. SGS2 ALL-AROUND F 2,74M/15-50G

LANSETA SPINNING SAVAGE GEAR 2BUC. SGS2 ALL-AROUND F 2,74M/15-50G

o.sg.74885

Livrare imediată!

511,94Lei

Shad SAVAGE GEAR CRAFT 10CM/6G ROACH 4BUC/PL

Shad SAVAGE GEAR CRAFT 10CM/6G ROACH 4BUC/PL

f1.sg.74089

Livrare 24-48 ore

33,25Lei(-60%) 13,30Lei

Swimbait SAVAGE GEAR 4D LT PT Trout SS, Perch, 20cm, 102g

Swimbait SAVAGE GEAR 4D LT PT Trout SS, Perch, 20cm, 102g

svs69365

Livrare imediată!

84,00Lei

Manusi Savage Gear All Weather Marime M

Manusi Savage Gear All Weather Marime M

a8.sg.76456

Livrare 24-48 ore

91,53Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Shiny Firetiger, 8.3cm, 11g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Shiny Firetiger, 8.3cm, 11g, 1buc/pac

1610626

Livrare 7-14 zile

36,00Lei

Vobler SAVAGE GEAR Deviator Swim SS Glider, Bleu Chrome, 10.5cm, 35g, 1buc/pac

Vobler SAVAGE GEAR Deviator Swim SS Glider, Bleu Chrome, 10.5cm, 35g, 1buc/pac

1625286

Livrare 7-14 zile

52,00Lei

Creatura SAVAGE GEAR Craft Crawler, Chart Pumpkin, 12.5cm, 6.4g, 6buc/pac

Creatura SAVAGE GEAR Craft Crawler, Chart Pumpkin, 12.5cm, 6.4g, 6buc/pac

svs69841

Livrare 7-14 zile

28,00Lei

TRICOU SAVAGE GEAR NIGHT UV BLACK WATERPRINT MAR.XXL

TRICOU SAVAGE GEAR NIGHT UV BLACK WATERPRINT MAR.XXL

a8.sg.73902

Livrare 24-48 ore

148,63Lei(-50%) 74,32Lei

TRICOU SAVAGE GEAR JUNIOR BLACK INK MARIME 12-14 Ani

TRICOU SAVAGE GEAR JUNIOR BLACK INK MARIME 12-14 Ani

a8.sg.76687

Livrare imediată!

63,80Lei(-30%) 44,66Lei

Naluca Savage Gear Fat Tail NL 5.5cm 6.6g Silver Fluo

Naluca Savage Gear Fat Tail NL 5.5cm 6.6g Silver Fluo

sg.77047

Livrare 24-48 ore

35,25Lei(-40%) 21,15Lei

Shad Savage Gear Cannibal, Motor Oil UV, 17.5cm, 52g, 2buc/pac

Shad Savage Gear Cannibal, Motor Oil UV, 17.5cm, 52g, 2buc/pac

f1.sg.77169

Livrare imediată!

37,66Lei

Shad Savage Gear Fat Minnow T-Tail, Motor Oil UV, 13cm, 20g, 5buc/pac

Shad Savage Gear Fat Minnow T-Tail, Motor Oil UV, 13cm, 20g, 5buc/pac

f1.sg.77003

Livrare 24-48 ore

51,90Lei(-60%) 20,77Lei

Vobler Savage Gear Gravity Minnow Pink Head, 5cm, 8g

Vobler Savage Gear Gravity Minnow Pink Head, 5cm, 8g

sg.73519

Livrare 24-48 ore

40,31Lei

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.4, 9.1g

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.4, 9.1g

sg.82247

Livrare 24-48 ore

31,01Lei

Shad Savage Gear Craft Bleak, Dark Water Mix, 710.00cm, 6.8g, 5buc/pac

Shad Savage Gear Craft Bleak, Dark Water Mix, 710.00cm, 6.8g, 5buc/pac

f1.sg.1609144

Livrare 24-48 ore

32,09Lei

Lanseta Savage Gear Revange SG6 UL, 4-11g, 2.03m, 1+1seg

Lanseta Savage Gear Revange SG6 UL, 4-11g, 2.03m, 1+1seg

o.sg.1601799

Livrare 24-48 ore

811,08Lei

Shad SAVAGE GEAR 3D Herring Shad, Herring, 17.5cm, 35g, 2buc/pac

Shad SAVAGE GEAR 3D Herring Shad, Herring, 17.5cm, 35g, 2buc/pac

1610700

Livrare 7-14 zile

48,00Lei

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Roach, 15cm, 27g, 2buc/pac

Shad SAVAGE GEAR 3D Whitefish Shad Lure, Roach, 15cm, 27g, 2buc/pac

1632092

Livrare 7-14 zile

40,00Lei

Manusi SAVAGE GEAR All Weather Glove, XL, Black

Manusi SAVAGE GEAR All Weather Glove, XL, Black

svs76458

Livrare imediată!

99,00Lei

Swimbait SAVAGE GEAR 4D Trout Rattleshad, Lemon Trout, 80g, 17cm, 1buc/pac

Swimbait SAVAGE GEAR 4D Trout Rattleshad, Lemon Trout, 80g, 17cm, 1buc/pac

svs74002

Livrare 7-14 zile

52,00Lei

Afişare 501 - 520 din 2017 (101 pagini)

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

1 (0.108)

SELECT data
FROM `oc_session`
WHERE session_id = '70d025ca0b399a7ce573a12f3f'

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

2 (0.098)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.137)

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

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

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

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

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

7 (0.133)

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