Savage Gear

Savage Gear

Sortare după:

Fir Savage Gear Regenerator 040MM/10KG/30M

Fir Savage Gear Regenerator 040MM/10KG/30M

a.sg.54838

Livrare 24-48 ore

27,73Lei

INEL DESPICAT SAVAGE PT MONTURI 9MM 20BUC/PL

INEL DESPICAT SAVAGE PT MONTURI 9MM 20BUC/PL

a.sg.54929

Livrare imediată!

17,53Lei

Manusi SAVAGE GEAR Aqua Guard Glove M, Black

Manusi SAVAGE GEAR Aqua Guard Glove M, Black

svs51643

Livrare 7-14 zile

128,10Lei

Shad Savage Gear Fat Minnow T-Tail, Minnow, 7.5cm, 4buc/plic

Shad Savage Gear Fat Minnow T-Tail, Minnow, 7.5cm, 4buc/plic

f1.sg.61808

Livrare imediată!

19,01Lei

AGRAFA SAVAGE CROSSLOCK EGG SNAP M 10BUC/PL

AGRAFA SAVAGE CROSSLOCK EGG SNAP M 10BUC/PL

svs61781

Livrare imediată!

17,27Lei

SHAD SAVAGE LB ROACH PADDLE TAIL 12.5CM/22.0G FIRETIGER 3BUC/PLIC

SHAD SAVAGE LB ROACH PADDLE TAIL 12.5CM/22.0G FIRETIGER 3BUC/PLIC

f1.sg.61886

Livrare 24-48 ore

30,33Lei(-33%) 20,42Lei

SHAD SAVAGE LB CANNIBAL 12.5CM/ROACH 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/ROACH 3BUC/PLIC

f1.sg.69971

Livrare imediată!

24,32Lei(-31%) 16,75Lei

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Dirty Roach

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Dirty Roach

f1.sg.71812

Livrare 24-48 ore

29,86Lei(-43%) 17,10Lei

Fir Fluorocarbon Savage Gear Soft Seabass 0.35mm 30m 6.72kg

Fir Fluorocarbon Savage Gear Soft Seabass 0.35mm 30m 6.72kg

a.sg.74487

Livrare 24-48 ore

39,72Lei

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

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

1608944

Livrare 7-14 zile

1.887,18Lei

MULINETA SAVAGE GEAR SGS6 8000

MULINETA SAVAGE GEAR SGS6 8000

o.sg.74756

Livrare 24-48 ore

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

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 2.6g, 3buc/pac

Jig SAVAGE GEAR Tungsten Ball Jighead, Nr.1/0, 2.6g, 3buc/pac

svs82279

Livrare 7-14 zile

27,44Lei

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

HUSA SAVAGE GEAR TWIN 140CM PT 2 LANSETE

HUSA SAVAGE GEAR TWIN 140CM PT 2 LANSETE

svs74253

Livrare 7-14 zile

246,05Lei

GRUB SAVAGE GEAR 5CM 0.8G RED&BLACK 8BUC/PLIC

GRUB SAVAGE GEAR 5CM 0.8G RED&BLACK 8BUC/PLIC

f1.sg.74316

Livrare 24-48 ore

14,53Lei

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 3.8CM 5G S HOLO WHITE GLOW

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 3.8CM 5G S HOLO WHITE GLOW

sg.77394

Livrare 24-48 ore

35,08Lei

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN XXL

BLUZA SAVAGE GEAR REGENERATOR FLEECE KOMBU GREEN XXL

a8.sg.76536

Livrare 24-48 ore

266,84Lei

Pilker SAVAGE GEAR Powerglow EGI, Culoare White, 17.2g, 10cm, 1buc/pac

Pilker SAVAGE GEAR Powerglow EGI, Culoare White, 17.2g, 10cm, 1buc/pac

svs78095

Livrare 7-14 zile

47,77Lei

Pilker SAVAGE GEAR Super Cast EGI ND3.0, Ocean Candy, 17g, 10.5cm, 1buc/pac

Pilker SAVAGE GEAR Super Cast EGI ND3.0, Ocean Candy, 17g, 10.5cm, 1buc/pac

svs78066

Livrare 7-14 zile

62,01Lei

Lanseta Spinning Savage Gear Revange SG6 Light Game 2.26m, 4-15g, 2seg

Lanseta Spinning Savage Gear Revange SG6 Light Game 2.26m, 4-15g, 2seg

o.sg.1601801

Livrare 24-48 ore

787,38Lei

Afişare 2021 - 2040 din 2169 (109 pagini)

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

1 (0.124)

SELECT data
FROM `oc_session`
WHERE session_id = '7128c2fa936007865ac6003fbb'

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

2 (0.096)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.124)

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

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (65.642)

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 = '0' AND p.manufacturer_id = '85'

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

6 (80.089)

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 = '0' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 2020,20

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

7 (0.133)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37