Savage Gear

Savage Gear

Sortare după:

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G GREEN SILVER AYU

CICADA SAVAGE GEAR VIB BLADE 4.5CM/8.5G GREEN SILVER AYU

svs71441

Livrare imediată!

37,61Lei

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

Chatterbait SAVAGE GEAR Crazy Swim Jig, Skin Motor Oil, 10cm, 8.5g, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, Skin Motor Oil, 10cm, 8.5g, 1buc/pac

svs76736

Livrare imediată!

37,61Lei

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

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

f1.sg.71798

Livrare imediată!

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

Lanseta Savage Gear SG2 Light Game 221cm 5-18g 2seg

Lanseta Savage Gear SG2 Light Game 221cm 5-18g 2seg

o.sg.72149

Livrare 24-48 ore

275,67Lei

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

MULINETA SAVAGE GEAR SGS6 8000

MULINETA SAVAGE GEAR SGS6 8000

o.sg.74756

Livrare 24-48 ore

556,38Lei(-39%) 341,37Lei

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.45mm 10.70kg 50m

Fir fluorocarbon Savage Gear Super Hard Fluorocarbon 0.45mm 10.70kg 50m

svs74489

Livrare imediată!

80,31Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 6C DEEP 36X22.5X5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 6C DEEP 36X22.5X5CM

svs76781

Livrare imediată!

59,97Lei

KIT SAVAGE GEAR NALUCI ACC GRAVITY STICK 30 19BUC

KIT SAVAGE GEAR NALUCI ACC GRAVITY STICK 30 19BUC

svs71865

Livrare imediată!

190,13Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL

f1.sg.76853

Livrare 24-48 ore

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

Sapca Savage Gear Catch One Size Olive Green Melange

Sapca Savage Gear Catch One Size Olive Green Melange

svs76691

Livrare imediată!

76,24Lei

Vobler Savage Gear Freestyler V2, Slow Sinking, Firetiger, 11cm, 28g

Vobler Savage Gear Freestyler V2, Slow Sinking, Firetiger, 11cm, 28g

sg.77073

Livrare 24-48 ore

52,64Lei

MANUSI SAVAGE GEAR SHIELD MARIME XL

MANUSI SAVAGE GEAR SHIELD MARIME XL

a8.sg.49412

Livrare 24-48 ore

115,95Lei(-37%) 72,65Lei

Bride Savage Gear 100 buc plic

Bride Savage Gear 100 buc plic

svs54900

Livrare imediată!

19,30Lei

NALUCA SOFT SAVAGE GEAR 3D PVC MAYFLY, BROWN GLITTER, 5CM, 8BUC/PLIC

NALUCA SOFT SAVAGE GEAR 3D PVC MAYFLY, BROWN GLITTER, 5CM, 8BUC/PLIC

svs55114

Livrare imediată!

35,57Lei

Cagula Savage Gear Skull Balaclava

Cagula Savage Gear Skull Balaclava

svs59214

Livrare imediată!

76,24Lei

Broasca Savage Gear 3D Pop Frog, Verde, 5.5cm, 14g

Broasca Savage Gear 3D Pop Frog, Verde, 5.5cm, 14g

svs62026

Livrare imediată!

41,67Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, Blue Pink Glow, 9.7cm, 150g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, Blue Pink Glow, 9.7cm, 150g, 1buc/pac

svs77312

Livrare 7-14 zile

78,27Lei

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

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

f1.sg.63659

Livrare 24-48 ore

38,60Lei

Afişare 1041 - 1060 din 1522 (77 pagini)

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

1 (0.109)

SELECT data
FROM `oc_session`
WHERE session_id = '4238ce0e795dddb158eea5946e'

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.135)

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

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

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

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

7 (0.107)

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