Savage Gear

Savage Gear

Sortare după:

SPINNERBAIT SAVAGE DA BUSH PINK FLASH, NR.3, 32G

SPINNERBAIT SAVAGE DA BUSH PINK FLASH, NR.3, 32G

sg.57609

Livrare imediată!

46,04Lei(-45%) 25,33Lei

SHAD SAVAGE CANNIBAL 10CM/9G/FIRETIGER/4BUC/PL

SHAD SAVAGE CANNIBAL 10CM/9G/FIRETIGER/4BUC/PL

svs61852-bucxxx4

Livrare imediată!

21,33Lei

Shad Savage Gear LB Cannibal, Pike, 6.8cm, 3g, 4buc/plic

Shad Savage Gear LB Cannibal, Pike, 6.8cm, 3g, 4buc/plic

f1.sg.61843

Livrare imediată!

17,94Lei

SHAD SAVAGE LB 4D HERRING 11CM/9G/DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 11CM/9G/DIRTY ROACH 4BUC/PLIC

f1.sg.63682

Livrare 24-48 ore

36,98Lei(-13%) 31,99Lei

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G OLIVE SMOLT

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G OLIVE SMOLT

sg.63747

Livrare 24-48 ore

34,34Lei(-33%) 22,86Lei

SHAD SAVAGE LB 4D HERRING 13CM 17G GREEN SILVER 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 13CM 17G GREEN SILVER 4BUC/PLIC

f1.sg.63667

Livrare 24-48 ore

42,57Lei(-14%) 36,54Lei

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf W, Marime XXLS 45-47

Cizme Piept SAVAGE GEAR Sg8 Zip Chest Sf W, Marime XXLS 45-47

1608943

Livrare 7-14 zile

1.887,18Lei

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

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

f1.sg.71796

Livrare 24-48 ore

29,65Lei(-43%) 16,99Lei

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

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

f1.sg.71832

Livrare 24-48 ore

36,45Lei(-13%) 31,56Lei

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

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

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

svs78206

Livrare 7-14 zile

51,84Lei

Husa Savage Gear Neopren Mulineta Marime L

Husa Savage Gear Neopren Mulineta Marime L

svs74803

Livrare imediată!

49,82Lei

Lanseta SAVAGE GEAR Defiance SG4 Inshore Spin 2.13m, 6-32g, 2seg

Lanseta SAVAGE GEAR Defiance SG4 Inshore Spin 2.13m, 6-32g, 2seg

o.sg.1601741

Livrare 24-48 ore

591,06Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 9.5CM 15G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 9.5CM 15G

sg.74129

Livrare 24-48 ore

40,89Lei

MINCIOG SAVAGE GEAR TELE FOLDING L 65X50X60CM 98-161CM

MINCIOG SAVAGE GEAR TELE FOLDING L 65X50X60CM 98-161CM

a2.sg.71101

Livrare imediată!

332,37Lei

SET CUTII SAVAGE GEAR PT.NALUCI 21,4X1,8X4,5CM 3BUC

SET CUTII SAVAGE GEAR PT.NALUCI 21,4X1,8X4,5CM 3BUC

svs74232

Livrare imediată!

109,80Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 1B SMOKE 13,8X7,7X3,1CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 1B SMOKE 13,8X7,7X3,1CM

svs76768

Livrare imediată!

18,30Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/7.5G SINKING GREEN PUMPKIN

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/7.5G SINKING GREEN PUMPKIN

f1.sg.76846

Livrare 24-48 ore

30,84Lei(-53%) 14,46Lei

Swimbait SAVAGE GEAR 3D Trout Rattle Shad Lure, Clear Albino, 17cm, 90g

Swimbait SAVAGE GEAR 3D Trout Rattle Shad Lure, Clear Albino, 17cm, 90g

1625332

Livrare 7-14 zile

53,87Lei

Afişare 1441 - 1460 din 1788 (90 pagini)

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

1 (0.118)

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

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

2 (0.115)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.107)

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

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

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

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

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

7 (0.122)

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