Savage Gear

Savage Gear

Sortare după:

Jig Offset SAVAGE GEAR Weedlees EWG Hooks, Nr.8/0, 3buc/pac

Jig Offset SAVAGE GEAR Weedlees EWG Hooks, Nr.8/0, 3buc/pac

svs61778

Livrare 7-14 zile

41,67Lei

MANUSI SAVAGE GEAR SHIELD MARIME XL

MANUSI SAVAGE GEAR SHIELD MARIME XL

a8.sg.49412

Livrare 24-48 ore

115,95Lei(-38%) 71,74Lei

Bride Savage Gear 100 buc plic

Bride Savage Gear 100 buc plic

svs54900

Livrare imediată!

19,30Lei

SHAD SOFT BAIT GUNKI PEPS, WHITE FLASH, 7CM, 2.5G, 7BUC/PLIC

SHAD SOFT BAIT GUNKI PEPS, WHITE FLASH, 7CM, 2.5G, 7BUC/PLIC

f1.spm.35003

Livrare imediată!

20,62Lei

Cagula Savage Gear Skull Balaclava

Cagula Savage Gear Skull Balaclava

svs59214

Livrare imediată!

76,24Lei

Broasca Savage Gear 3D Pop Frog, Maro, 7cm, 20g

Broasca Savage Gear 3D Pop Frog, Maro, 7cm, 20g

f1.sg.62030

Livrare 24-48 ore

46,28Lei(-37%) 29,23Lei

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

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

f1.sg.63679

Livrare 24-48 ore

32,34Lei

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G BLUE PINK SMOLT

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G BLUE PINK SMOLT

sg.63743

Livrare 24-48 ore

33,09Lei(-46%) 17,82Lei

MONTURA SAVAGE CARBON49 T-TREBLE SPIKE 2/0 11.5CM 2BUC/PLIC

MONTURA SAVAGE CARBON49 T-TREBLE SPIKE 2/0 11.5CM 2BUC/PLIC

a7.sg.69780

Livrare 24-48 ore

44,00Lei(-47%) 23,37Lei

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(-16%) 35,62Lei

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Green Silver

Shad Savage Gear Craft Cannibal Paddletail 6.5cm 4g 4buc/plic Green Silver

f1.sg.71797

Livrare imediată!

30,00Lei

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

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

1608947

Livrare 7-14 zile

1.887,18Lei

Savage Gear Craft Cannibal Paddletail DARK WATER Mix 12.5cm 20g 4buc/plic

Savage Gear Craft Cannibal Paddletail DARK WATER Mix 12.5cm 20g 4buc/plic

f1.sg.71834

Livrare 24-48 ore

44,98Lei(-27%) 33,01Lei

Hanorac SAVAGE GEAR Tec Foam, Dark Grey Melange, Marimea M

Hanorac SAVAGE GEAR Tec Foam, Dark Grey Melange, Marimea M

svs76694

Livrare 7-14 zile

291,82Lei

CICADA STRIKE PRO CYBER VIBE 3CM 3.5G

CICADA STRIKE PRO CYBER VIBE 3CM 3.5G

sp.jg020c.022pe

Livrare 24-48 ore

26,83Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING SEXY SHAD

SPINNERBAIT SAVAGE GEAR DA BUSH 14CM 21G SINKING SEXY SHAD

sg.72606

Livrare 24-48 ore

42,54Lei(-47%) 22,63Lei

HUSA SAVAGE GEAR 1 LANSETA 140CM

HUSA SAVAGE GEAR 1 LANSETA 140CM

svs74150

Livrare 7-14 zile

171,82Lei

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

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

svs78214

Livrare 7-14 zile

51,84Lei

Fir fluorocarbon Savage Gear Soft Fluorocarbon EGI 0.25mm 4.66kg 25m

Fir fluorocarbon Savage Gear Soft Fluorocarbon EGI 0.25mm 4.66kg 25m

svs74481

Livrare imediată!

35,57Lei

Shad SAVAGE GEAR Soft Lure Monster Slug, White Fish, 50g, 25cm, 2buc/pac

Shad SAVAGE GEAR Soft Lure Monster Slug, White Fish, 50g, 25cm, 2buc/pac

svs69794

Livrare 7-14 zile

47,77Lei

Afişare 1821 - 1840 din 1873 (94 pagini)

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

1 (0.106)

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

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

2 (0.080)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.101)

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

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

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

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

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

7 (0.183)

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