Savage Gear

Savage Gear

Sortare după:

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 XXL

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XXL

svs59132

Livrare imediată!

387,39Lei

Pantofi Savage Sport Gear Sneakers MAR. 44

Pantofi Savage Sport Gear Sneakers MAR. 44

a8.sg.62318

Livrare 24-48 ore

373,06Lei(-49%) 191,58Lei

Pilker SAVAGE GEAR Surf Seeker S, Black Pearl, 10cm, 30g, 1buc/pac

Pilker SAVAGE GEAR Surf Seeker S, Black Pearl, 10cm, 30g, 1buc/pac

svs71784

Livrare 7-14 zile

35,57Lei

Shad Savage Gear LB Cannibal, Blue Pearl, 10cm, 9g, 4buc/plic

Shad Savage Gear LB Cannibal, Blue Pearl, 10cm, 9g, 4buc/plic

f1.sg.61853

Livrare imediată!

22,40Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/DIRTY ROACH 4BUC/PLIC

f1.sg.63798

Livrare imediată!

16,66Lei(-7%) 15,48Lei

Cutie Savage Gear pentru Naluci NR.2 16.1x9.1x3.1cm

Cutie Savage Gear pentru Naluci NR.2 16.1x9.1x3.1cm

a4.sg.42665

Livrare imediată!

21,45Lei

Clip SAVAGE pentru Sticla

Clip SAVAGE pentru Sticla

svs71895

Livrare imediată!

31,50Lei

Savage Gear Craft Cannibal Paddletail DARK WATER Mix 8.5cm 7g 4buc/plic

Savage Gear Craft Cannibal Paddletail DARK WATER Mix 8.5cm 7g 4buc/plic

f1.sg.71830

Livrare 24-48 ore

32,67Lei(-13%) 28,50Lei

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 5.5CM 1.6G PURPLE HAZE GHOST

NALUCA SAVAGE GEAR 3D CRAYFISH RATTLING 5.5CM 1.6G PURPLE HAZE GHOST

f1.sg.72594

Livrare 24-48 ore

31,24Lei(-23%) 24,14Lei

Husa Savage Gear Neopren Mulineta Marime L

Husa Savage Gear Neopren Mulineta Marime L

svs74803

Livrare imediată!

49,82Lei

MULINETA SAVAGE GEAR SG2 4000 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL

MULINETA SAVAGE GEAR SG2 4000 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL

o.sg.74721

Livrare 24-48 ore

202,08Lei(-38%) 125,20Lei

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.92mm 40.5kg 15M

FIR FLUOROCARBON SAVAGE GEAR SOFT 0.92mm 40.5kg 15M

a.sg.54858

Livrare 24-48 ore

127,38Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4A 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4A 21.4X11.8X4.5CM

svs76773

Livrare imediată!

39,64Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 8CM 5G FIRETIGER 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 8CM 5G FIRETIGER 4BUC/PLIC

f1.sg.74282

Livrare 24-48 ore

34,98Lei

BROASCA SAVAGE GEAR HOP POPPER FROG GILL 5.5CM 15G

BROASCA SAVAGE GEAR HOP POPPER FROG GILL 5.5CM 15G

f1.sg.77441

Livrare 24-48 ore

45,71Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING FIRETIGER

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING FIRETIGER

sg.76809

Livrare 24-48 ore

38,19Lei(-24%) 29,09Lei

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

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

f2.sg.74413

Livrare 24-48 ore

33,80Lei

SPINNERBAIT SAVAGE DA BUSH NR.3/32G YELLOW SILVER

SPINNERBAIT SAVAGE DA BUSH NR.3/32G YELLOW SILVER

sg.42148

Livrare 24-48 ore

52,60Lei(-35%) 34,01Lei

STRUNA SAVAGE REGENERATOR TRACE 50CM 085MM 20KG 3BUC PLIC

STRUNA SAVAGE REGENERATOR TRACE 50CM 085MM 20KG 3BUC PLIC

svs54870

Livrare imediată!

17,27Lei

Afişare 981 - 1000 din 1523 (77 pagini)

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

1 (0.112)

SELECT data
FROM `oc_session`
WHERE session_id = '0c468e822f8f16dbb811c4df81'

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

2 (0.143)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.157)

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

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

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

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 980,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