Savage Gear

Savage Gear

Sortare după:

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR BLUE CHROME 8.3CM 10G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR BLUE CHROME 8.3CM 10G

sg.74121

Livrare 24-48 ore

43,28Lei(-49%) 22,13Lei

VESTA SAVAGE GEAR PRO-TACT SPINNING

VESTA SAVAGE GEAR PRO-TACT SPINNING

svs77665

Livrare 7-14 zile

571,43Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G DIRTY ROACH 4BUC/PLIC

f1.sg.74289

Livrare 24-48 ore

37,44Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING BROWN TROUT

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING BROWN TROUT

sg.76811

Livrare 24-48 ore

38,19Lei(-36%) 24,30Lei

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

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

svs78213

Livrare 7-14 zile

47,77Lei

BLUZA SAVAGE SIGNATURE LOGO LONG SLEEVE BLACK CAVIAR MAR.M

svs73909

Livrare 7-14 zile

101,66Lei

Pilker SAVAGE GEAR Squid Dealer 3.5, Green Shrimp, 18.8g, 11cm, 1buc/pac

Pilker SAVAGE GEAR Squid Dealer 3.5, Green Shrimp, 18.8g, 11cm, 1buc/pac

svs78075

Livrare 7-14 zile

47,77Lei

Jig Savage Gear Rac Nr.2/0, 5g, 3buc/pac

Jig Savage Gear Rac Nr.2/0, 5g, 3buc/pac

f2.sg.74415

Livrare 24-48 ore

32,36Lei

MANUSI SAVAGE GEAR SHIELD MARIME XL

MANUSI SAVAGE GEAR SHIELD MARIME XL

a8.sg.49412

Livrare 24-48 ore

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

Cap Jig SAVAGE GEAR Corkscrew, 80g, 1buc/pac

Cap Jig SAVAGE GEAR Corkscrew, 80g, 1buc/pac

svs71925

Livrare 7-14 zile

27,44Lei

Bride Savage Gear 100 buc plic

Bride Savage Gear 100 buc plic

svs54900

Livrare imediată!

19,30Lei

SHAD SOFT BAIT GUNKI PEPS, WHITE FLASH, 9CM, 5.3G, 5BUC/PLIC

SHAD SOFT BAIT GUNKI PEPS, WHITE FLASH, 9CM, 5.3G, 5BUC/PLIC

f1.spm.35103

Livrare 24-48 ore

27,94Lei

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 Gear LB Cannibal, Pike, 8cm, 5g, 4buc/plic

Shad Savage Gear LB Cannibal, Pike, 8cm, 5g, 4buc/plic

f1.sg.58988

Livrare imediată!

16,44Lei

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

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

f1.sg.63660

Livrare 24-48 ore

38,01Lei(-36%) 24,19Lei

Vobler Savage Gear 3D Goby Crank Culoare 62161 4cm 3.5g

Vobler Savage Gear 3D Goby Crank Culoare 62161 4cm 3.5g

sg.62161

Livrare imediată!

43,81Lei

MONTURA SAVAGE PUNCH 15G 3BUC/PLIC

MONTURA SAVAGE PUNCH 15G 3BUC/PLIC

a.sg.63821

Livrare 24-48 ore

22,68Lei(-45%) 12,54Lei

LANSETA SAVAGE GEAR SPINNING 2SEG SG2 LIGHT GAME 2.51M 5-18G

LANSETA SAVAGE GEAR SPINNING 2SEG SG2 LIGHT GAME 2.51M 5-18G

o.sg.72151

Livrare 24-48 ore

311,64Lei

Cleste Savage Gear Pro L 20Cm

Cleste Savage Gear Pro L 20Cm

a.sg.71888

Livrare 24-48 ore

264,55Lei(-50%) 133,28Lei

Afişare 1461 - 1480 din 2105 (106 pagini)

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

1 (0.207)

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

/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.122)

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

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

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

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

7 (0.144)

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