Savage Gear

Savage Gear

Sortare după:

Fir SAVAGE GEAR Soft Fluoro Carbon Transparent, 0.92mm, 40.5kg-89lbs, 15m

Fir SAVAGE GEAR Soft Fluoro Carbon Transparent, 0.92mm, 40.5kg-89lbs, 15m

svs54858

Livrare 7-14 zile

125,05Lei

Shad SAVAGE GEAR Collapser, Hot Bleak, 12g, 14cm, 3buc/pac

Shad SAVAGE GEAR Collapser, Hot Bleak, 12g, 14cm, 3buc/pac

1623201

Livrare 7-14 zile

33,54Lei

SHAD SAVAGE GEAR CRAFT 10CM 6G BLUE PEARL 5BUC/PLIC

SHAD SAVAGE GEAR CRAFT 10CM 6G BLUE PEARL 5BUC/PLIC

f1.sg.72418

Livrare imediată!

38,73Lei(-44%) 21,61Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Fluor Yellow Tiger, 11.5cm, 28g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Fluor Yellow Tiger, 11.5cm, 28g, 1buc/pac

1634460

Livrare 7-14 zile

45,74Lei

Protectie ancora Savage Gear Treble Hook Protectors XLarge

Protectie ancora Savage Gear Treble Hook Protectors XLarge

svs72329

Livrare imediată!

23,37Lei

Lanseta SAVAGE GEAR SG8 Salmonoid, 7-23g, 2.79m, 4seg

Lanseta SAVAGE GEAR SG8 Salmonoid, 7-23g, 2.79m, 4seg

1601786

Livrare 7-14 zile

1.926,83Lei

TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.L

svs73651

Livrare 7-14 zile

101,66Lei

Lingurita Rotativa SAGAVE GEAR Caviar, Gold, Nr.2, 6g, 1buc/pac

Lingurita Rotativa SAGAVE GEAR Caviar, Gold, Nr.2, 6g, 1buc/pac

svs40959

Livrare 7-14 zile

22,49Lei(-50%) 11,16Lei

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.XL

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.XL

svs76464

Livrare imediată!

76,24Lei

Shad SAVAGE GEAR CRAFT 8.8CM/4,6G CLEAR WATER MIX 5BUC/PL

Shad SAVAGE GEAR CRAFT 8.8CM/4,6G CLEAR WATER MIX 5BUC/PL

f1.sg.74096

Livrare 24-48 ore

38,56Lei

Swimbait SAVAGE GEAR Shad SS02, Albino, 23g, 12.5cm, 1buc/pac

Swimbait SAVAGE GEAR Shad SS02, Albino, 23g, 12.5cm, 1buc/pac

svs61796

Livrare imediată!

57,93Lei

SHAD SAVAGE GEAR SHAD CRAFT MOTOR OIL 7.2CM 2.6G 4BUC/PLIC

SHAD SAVAGE GEAR SHAD CRAFT MOTOR OIL 7.2CM 2.6G 4BUC/PLIC

f1.sg.74081

Livrare 24-48 ore

28,50Lei(-53%) 13,52Lei

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.L

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.L

a8.sg.73890

Livrare 24-48 ore

134,10Lei(-38%) 83,73Lei

LINGURITA ROTATIVA SAVAGE GEAR ROTEX NR.3 FLUO ORANGE SILVE 8G

LINGURITA ROTATIVA SAVAGE GEAR ROTEX NR.3 FLUO ORANGE SILVE 8G

f.sg.42126

Livrare 24-48 ore

17,73Lei

Naluca Savage Gear Fat Tail NL 6.5cm 12.5g Fire Tiger

Naluca Savage Gear Fat Tail NL 6.5cm 12.5g Fire Tiger

svs77079

Livrare imediată!

35,57Lei

Shad Savage Gear Cannibal, Olive Hot Orange, 8cm, 5g, 5buc/pac

Shad Savage Gear Cannibal, Olive Hot Orange, 8cm, 5g, 5buc/pac

f1.sg.77134

Livrare imediată!

21,80Lei

Shad Savage Gear Fat Minnow T-Tail, Smelt, 9cm, 7g, 5buc/pac

Shad Savage Gear Fat Minnow T-Tail, Smelt, 9cm, 7g, 5buc/pac

f1.sg.76988

Livrare 24-48 ore

30,79Lei(-53%) 14,44Lei

Vobler Savage Gear Deviator Swim, Slow Sinking, Firetiger, 10.5cm, 35g

Vobler Savage Gear Deviator Swim, Slow Sinking, Firetiger, 10.5cm, 35g

sg.69869

Livrare 24-48 ore

52,64Lei

Shad Savage Gear Craft Bleak, Clear Water Mix, 7.0cm, 2.5g, 5buc/pac

Shad Savage Gear Craft Bleak, Clear Water Mix, 7.0cm, 2.5g, 5buc/pac

1609141

Livrare 7-14 zile

26,41Lei

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 58g, 10cm, 1buc/pac

Vobler Savage Gear Fat Vibers XL, Sinking, Bream, 58g, 10cm, 1buc/pac

1608966

Livrare 7-14 zile

66,08Lei

Afişare 561 - 580 din 1788 (90 pagini)

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

1 (0.132)

SELECT data
FROM `oc_session`
WHERE session_id = '9a45fef09d4ed7d50bc17454fb'

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

2 (0.105)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.129)

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

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

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

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

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

7 (0.146)

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