Savage Gear

Savage Gear

Sortare după:

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Firetiger, 6.7cm, 7g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch Suspending MR Floating, Firetiger, 6.7cm, 7g, 1buc/pac

1608961

Livrare 7-14 zile

32,00Lei

Carlige Savage Gear Offset Swimbait Weedless BLN nr.6/0 3g 4buc

Carlige Savage Gear Offset Swimbait Weedless BLN nr.6/0 3g 4buc

f2.sg.71794

Livrare imediată!

27,79Lei

Swimbait Articulat SAVAGE GEAR 4D Trout SS, Fire Trout, 98g, 20cm, 1buc/pac

Swimbait Articulat SAVAGE GEAR 4D Trout SS, Fire Trout, 98g, 20cm, 1buc/pac

svs63752

Livrare 7-14 zile

72,00Lei

Fir Fluorocarbon SAVAGE GEAR Semi Soft Sea Bass Clear, 3.66kg, 0.25mm, 30m

Fir Fluorocarbon SAVAGE GEAR Semi Soft Sea Bass Clear, 3.66kg, 0.25mm, 30m

svs74484

Livrare 7-14 zile

30,00Lei

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G ROACH 5BUC/PLIC

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G ROACH 5BUC/PLIC

f1.sg.72403

Livrare imediată!

20,94Lei

Jacheta SAVAGE GEAR SG4 Wading, Olive Green, Marime S

Jacheta SAVAGE GEAR SG4 Wading, Olive Green, Marime S

svs73723

Livrare 7-14 zile

1.099,95Lei(-55%) 489,89Lei

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME XL

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME XL

svs73700

Livrare imediată!

215,00Lei

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Green Eye, 90g, 18cm, 1buc/pac

Naluca SAVAGE GEAR Swim Squid RTF Sinking, Green Eye, 90g, 18cm, 1buc/pac

svs78156

Livrare 7-14 zile

56,00Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 4.5CM 4G FIRETIGER

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 4.5CM 4G FIRETIGER

sg.72312

Livrare 24-48 ore

38,33Lei

Fes Savage Gear Reflex One Size Black Reflex

Fes Savage Gear Reflex One Size Black Reflex

svs73740

Livrare imediată!

51,00Lei

MANUSI SAVAGE GEAR CU DEGETE TAIATE WIND PRO BLACK MAR.L

MANUSI SAVAGE GEAR CU DEGETE TAIATE WIND PRO BLACK MAR.L

a8.sg.76472

Livrare 24-48 ore

66,47Lei(-50%) 33,22Lei

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

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Clear Wagasaki, 11.5cm, 28g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Clear Wagasaki, 11.5cm, 28g, 1buc/pac

1634463

Livrare 7-14 zile

43,99Lei

Lanseta SAVAGE GEAR Revenge SG8 Medium Game Baitcast, 1.90m, 8-33g, 1+1seg

Lanseta SAVAGE GEAR Revenge SG8 Medium Game Baitcast, 1.90m, 8-33g, 1+1seg

1601731

Livrare 7-14 zile

1.460,00Lei

Lingurita Rotativa SAGAVE GEAR Caviar, Gold, Nr.2, 6g, 1buc/pac

Lingurita Rotativa SAGAVE GEAR Caviar, Gold, Nr.2, 6g, 1buc/pac

svs40959

Livrare 7-14 zile

22,49Lei(-56%) 9,98Lei

HANORAC SAVAGE GEAR TEC FOAM ZIP DARK GREY MELANGE L

HANORAC SAVAGE GEAR TEC FOAM ZIP DARK GREY MELANGE L

a8.sg.76587

Livrare 24-48 ore

385,07Lei(-20%) 308,06Lei

Shad Savage Gear Cannibal, Chartreuse Pumpkin, 6.8cm, 3g, 5buc/pac

Shad Savage Gear Cannibal, Chartreuse Pumpkin, 6.8cm, 3g, 5buc/pac

f1.sg.77126

Livrare 24-48 ore

15,68Lei

Shad Savage Gear Cannibal, White Flash, 6.8cm, 3g, 5buc/pac

Shad Savage Gear Cannibal, White Flash, 6.8cm, 3g, 5buc/pac

f1.sg.77127

Livrare 24-48 ore

15,68Lei

Shad Savage Gear Craft Bleak, Clear Water Mix, 7.0cm, 2.5g, 5buc/pac

Shad Savage Gear Craft Bleak, Clear Water Mix, 7.0cm, 2.5g, 5buc/pac

f1.sg.1609141

Livrare 24-48 ore

26,26Lei

Lingurita Rotativa SAGAVE GEAR Caviar, Fluo Orange, Nr.2, 6g

Lingurita Rotativa SAGAVE GEAR Caviar, Fluo Orange, Nr.2, 6g

f.sg.42309

Livrare 24-48 ore

21,31Lei

Afişare 841 - 860 din 1907 (96 pagini)

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

1 (0.070)

SELECT data
FROM `oc_session`
WHERE session_id = 'ecff128a44334aae5dda5acf3a'

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

2 (0.103)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.089)

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

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

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

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

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

7 (0.096)

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