Savage Gear

Savage Gear

Sortare după:

Pilker SAVAGE GEAR Seeker ISP Sinking, Fluo Green Yellow, 9.8cm, 23cm, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Fluo Green Yellow, 9.8cm, 23cm, 1buc/pac

svs55349

Livrare 7-14 zile

29,48Lei

MONTURA SAVAGE GEAR CORKSCREW STINGER 3G NR.1X1/0 35KG RED BN 2BUC/PLIC

MONTURA SAVAGE GEAR CORKSCREW STINGER 3G NR.1X1/0 35KG RED BN 2BUC/PLIC

a.sg.72277

Livrare 24-48 ore

39,72Lei

Chatterbait SAVAGE GEAR Crazy Swim Jig, White Silver, 10cm, 8.5g, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, White Silver, 10cm, 8.5g, 1buc/pac

svs76733

Livrare imediată!

37,61Lei

MULINETA SAVAGE GEAR SGS6 5000 FD 6+1BB

MULINETA SAVAGE GEAR SGS6 5000 FD 6+1BB

o.sg.74754

Livrare 24-48 ore

511,87Lei(-39%) 314,20Lei

Sapca SAGAVE GEAR Baseball, One Size, Black Ink

Sapca SAGAVE GEAR Baseball, One Size, Black Ink

svs73709

Livrare imediată!

76,24Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 2 A 16.1X9.1X3.1CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 2 A 16.1X9.1X3.1CM

svs76769

Livrare imediată!

22,35Lei

CUTIE SAVAGE GEAR PT.ACCESORII SMOKE 23X11X3,5CM 2PCS

CUTIE SAVAGE GEAR PT.ACCESORII SMOKE 23X11X3,5CM 2PCS

svs74233

Livrare imediată!

59,97Lei

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

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

f1.sg.76850

Livrare imediată!

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

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

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

f2.sg.74411

Livrare imediată!

33,80Lei

NALUCA SAVAGE MAYFLY NYMPH 5CM/2,5G 01

NALUCA SAVAGE MAYFLY NYMPH 5CM/2,5G 01

svs50671

Livrare 7-14 zile

27,44Lei

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 01

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 01

svs57391

Livrare 7-14 zile

41,67Lei

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

PANTALONI SAVAGE GREY MARIMEA S

PANTALONI SAVAGE GREY MARIMEA S

a8.sg.59114

Livrare imediată!

384,77Lei(-29%) 274,88Lei

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

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

sg.61995

Livrare 24-48 ore

48,70Lei

SHAD SAVAGE 4D LINE THRU PULSETAIL ROACH 18CM/90G FIRETIGER

SHAD SAVAGE 4D LINE THRU PULSETAIL ROACH 18CM/90G FIRETIGER

f1.sg.63729

Livrare 24-48 ore

79,99Lei(-16%) 66,99Lei

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G BLUE PINK STRIPES

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G BLUE PINK STRIPES

sg.71443

Livrare 24-48 ore

37,75Lei

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 8000FD

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 8000FD

svs73125

Livrare imediată!

134,95Lei(-45%) 74,69Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Olive Pearl Silver Smolt

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Olive Pearl Silver Smolt

f1.sg.71799

Livrare 24-48 ore

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

Lanseta Savage Gear SG2 Vertical Specialist 1.98m 12-35g 2seg

Lanseta Savage Gear SG2 Vertical Specialist 1.98m 12-35g 2seg

o.sg.72153

Livrare imediată!

163,75Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G PURPLE HAZE GHOST

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 6.7CM 2.9G PURPLE HAZE GHOST

f1.sg.72599

Livrare 24-48 ore

32,43Lei(-23%) 25,01Lei

Afişare 1621 - 1640 din 1788 (90 pagini)

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

1 (0.106)

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

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

2 (0.108)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.134)

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

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

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

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

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

7 (0.110)

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