Savage Gear

Savage Gear

Sortare după:

STRUNA SAVAGE BLACK7 TRACE 30CM 045MM 11KG 3BUC PL

STRUNA SAVAGE BLACK7 TRACE 30CM 045MM 11KG 3BUC PL

svs54863

Livrare imediată!

16,01Lei

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ă!

18,73Lei

Tricou Savage Gear Simply Savage Camo Mar. S

Tricou Savage Gear Simply Savage Camo Mar. S

a8.sg.59133

Livrare 24-48 ore

94,07Lei(-20%) 75,26Lei

Broasca Savage Gear 3D Walk Frog, Culoare 62032, 5.5cm, 14g

Broasca Savage Gear 3D Walk Frog, Culoare 62032, 5.5cm, 14g

svs62032

Livrare imediată!

40,00Lei

Shad Savage Gear Bleak Paddle Tail, Green Pearl Silver, 10cm, 4buc/plic

Shad Savage Gear Bleak Paddle Tail, Green Pearl Silver, 10cm, 4buc/plic

f1.sg.61830

Livrare imediată!

27,11Lei

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

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

f1.sg.63662

Livrare 24-48 ore

31,38Lei

VOBLER SAVAGE 3D SMASH TAIL 13.5CM/38G PERCH

VOBLER SAVAGE 3D SMASH TAIL 13.5CM/38G PERCH

sg.62000

Livrare 24-48 ore

73,48Lei

Pantofi Sport Savage Urban, Marime 42

Pantofi Sport Savage Urban, Marime 42

a8.sg.64954

Livrare 24-48 ore

236,23Lei(-35%) 154,14Lei

Breloc SAVAGE GEAR pescuit la musca RETRACTOR MP

Breloc SAVAGE GEAR pescuit la musca RETRACTOR MP

svs71896

Livrare imediată!

38,00Lei

Spinnerbait Savage Gear Da Bush Motor Oil 14cm 21g

Spinnerbait Savage Gear Da Bush Motor Oil 14cm 21g

sg.71756

Livrare imediată!

41,79Lei(-40%) 25,07Lei

Chatterbait SAVAGE GEAR Crazy Swim Jig, Motor Oil, 20g, 12.5cm, 1buc/pac

Chatterbait SAVAGE GEAR Crazy Swim Jig, Motor Oil, 20g, 12.5cm, 1buc/pac

svs76744

Livrare 7-14 zile

40,00Lei

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Green Silver UV

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Green Silver UV

f1.sg.71813

Livrare imediată!

29,86Lei(-40%) 17,92Lei

Ochelari polarizati Savage Gear Savage 1 Black

Ochelari polarizati Savage Gear Savage 1 Black

a8.sg.72247

Livrare 24-48 ore

133,15Lei

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 18000FD

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 18000FD

svs73128

Livrare 7-14 zile

164,95Lei(-48%) 85,41Lei

Shad Savage Gear Minnow WL Lemon Back 12.5cm 28g 3buc

Shad Savage Gear Minnow WL Lemon Back 12.5cm 28g 3buc

f1.sg.72448

Livrare 24-48 ore

54,67Lei(-20%) 43,74Lei

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

76,01Lei

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

34,00Lei

CREATURA SAVAGE REACTION CRAYFISH 7,3CM/4G PLUM 5BUC/PLIC

CREATURA SAVAGE REACTION CRAYFISH 7,3CM/4G PLUM 5BUC/PLIC

f1.sg.74101

Livrare 24-48 ore

29,32Lei(-50%) 14,66Lei

LANSETA SAVAGE GEAR SG4 LIGHT GAME 2.15M 5-18G 4SEG

LANSETA SAVAGE GEAR SG4 LIGHT GAME 2.15M 5-18G 4SEG

o.sg.72196

Livrare 24-48 ore

464,28Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 9.8cm, 23cm, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Green Siver, 9.8cm, 23cm, 1buc/pac

svs55348

Livrare 7-14 zile

28,00Lei

Afişare 1821 - 1840 din 1906 (96 pagini)

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

1 (0.138)

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

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

2 (0.111)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.134)

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

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

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

5 (41.442)

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

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

6 (64.457)

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 = '3' 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.103)

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

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