Savage Gear

Savage Gear

Sortare după:

Grub Savage Gear, Motoroil, 6.5cm, 2.0g, 8buc/pac

Grub Savage Gear, Motoroil, 6.5cm, 2.0g, 8buc/pac

svs74319

Livrare 7-14 zile

32,36Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Perch, 17.5cm, 96g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Perch, 17.5cm, 96g

1624945

Livrare 7-14 zile

53,87Lei

Jig Head SAVAGE GEAR Bullet Glow, Nr.5/0, 58g, 1buc/pac

Jig Head SAVAGE GEAR Bullet Glow, Nr.5/0, 58g, 1buc/pac

svs78170

Livrare 7-14 zile

35,57Lei

SPINNERBAIT SAVAGE DA BUSH FIRETIGER, NR.3, 32G

SPINNERBAIT SAVAGE DA BUSH FIRETIGER, NR.3, 32G

sg.44870

Livrare imediată!

54,56Lei(-37%) 34,28Lei

Spirala Savage Gear Cork Screw S, 8buc/pac

Spirala Savage Gear Cork Screw S, 8buc/pac

svs55139

Livrare imediată!

25,40Lei

SHAD SOFT BAIT GUNKI GRUBBY CHICKEN SECRET 6CM, 2G, 10BUC/PLIC

SHAD SOFT BAIT GUNKI GRUBBY CHICKEN SECRET 6CM, 2G, 10BUC/PLIC

f1.spm.39020

Livrare 24-48 ore

38,62Lei

INEL DESPICAT SAVAGE PT MONTURI 9MM 20BUC/PL

INEL DESPICAT SAVAGE PT MONTURI 9MM 20BUC/PL

svs54929

Livrare imediată!

15,83Lei

Shad Savage Gear Fat Minnow T-Tail, YR Fluo, 9cm, 4buc/plic

Shad Savage Gear Fat Minnow T-Tail, YR Fluo, 9cm, 4buc/plic

f1.sg.61812

Livrare imediată!

21,51Lei

Broasca SAVAGE GEAR 3D Walk Frog, Green, 7cm, 20g, 1buc/pac

Broasca SAVAGE GEAR 3D Walk Frog, Green, 7cm, 20g, 1buc/pac

svs62035

Livrare imediată!

45,74Lei

Carlige Offset Savage Gear EWG Nr.10/0 5g 2buc

Carlige Offset Savage Gear EWG Nr.10/0 5g 2buc

f2.sg.61779

Livrare 24-48 ore

40,12Lei

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

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

f1.sg.63652

Livrare 24-48 ore

33,95Lei(-36%) 21,72Lei

Naluca Savage Gear 3D Pulse Tail Roach Roach 10cm 17.5g 2buc/plic

Naluca Savage Gear 3D Pulse Tail Roach Roach 10cm 17.5g 2buc/plic

f1.sg.63719

Livrare 24-48 ore

55,81Lei

CLESTE SAVAGE GEAR MP CUT CRIMP S 22.5CM

CLESTE SAVAGE GEAR MP CUT CRIMP S 22.5CM

svs71892

Livrare imediată!

70,14Lei

Broasca SAVAGE GEAR Hop Walker Frog, Tan, 5.5cm, 15g, 1buc/pac

Broasca SAVAGE GEAR Hop Walker Frog, Tan, 5.5cm, 15g, 1buc/pac

svs77436

Livrare 7-14 zile

45,74Lei

Spinnerbait Savage Gear Da Bush Yellow Silver Holo Flame 14cm 21g

Spinnerbait Savage Gear Da Bush Yellow Silver Holo Flame 14cm 21g

sg.71753

Livrare 24-48 ore

41,79Lei(-57%) 17,99Lei

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Firetiger

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Firetiger

svs71809

Livrare imediată!

25,42Lei(-35%) 16,50Lei

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

Ghete SAVAGE GEAR Sg8 Wading Boot Felt, Nr.47

Ghete SAVAGE GEAR Sg8 Wading Boot Felt, Nr.47

1601853

Livrare 7-14 zile

571,43Lei

SPINNERBAIT SAVAGE GEAR DA BUSH 16CM 32G SINKING BLUE SILVER

SPINNERBAIT SAVAGE GEAR DA BUSH 16CM 32G SINKING BLUE SILVER

sg.72611

Livrare 24-48 ore

54,60Lei(-47%) 28,76Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, Pink Glow, 9cm, 120g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, Pink Glow, 9cm, 120g, 1buc/pac

svs77306

Livrare 7-14 zile

74,21Lei

Afişare 1721 - 1740 din 2160 (108 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

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

1 (0.122)

SELECT data
FROM `oc_session`
WHERE session_id = '160ac35192162f8d1d04cac1eb'

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

2 (0.061)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.082)

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

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

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

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

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

7 (0.138)

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