Savage Gear


SAVAGE GEAR FAT TAIL 5,5CM/9G SINKING FIRETIGER

SAVAGE GEAR FAT TAIL 5,5CM/9G SINKING FIRETIGER

sg.71760
Livrare imediată!

35,25Lei

Vobler, Savage, Gear, Gravity, Twitch, SR, Roach, 6.7cm, 6g, sg.71646, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler Savage Gear Gravity Crank MR Red Crayfish 5.8cm 9g -40%

Vobler Savage Gear Gravity Crank MR Red Crayfish 5.8cm 9g

sg.71683
Livrare 24-48 ore

41,83Lei(-40%) 25,10Lei

LINGURITA ROTATIVA SAVAGE CAVIAR NR.2 FLUO YELLOW CHART 6G

LINGURITA ROTATIVA SAVAGE CAVIAR NR.2 FLUO YELLOW CHART 6G

f.sg.42310
Livrare 24-48 ore

21,31Lei

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G BLUE PEARL 5BUC/PLIC -40%

SHAD SAVAGE GEAR CRAFT 7.2CM 2.6G BLUE PEARL 5BUC/PLIC

f1.sg.72406
Livrare 24-48 ore

34,90Lei(-40%) 20,94Lei

VOBLER, SAVAGE, GEAR, 3D, STICKLEBAIT, TWITCH, 4.5CM, 4G, GREEN, SILVER, sg.72313, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear
TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.S -20%

TRICOU SAVAGE GEAR SIGNATURE LOGO GREY MELANGE MAR.S

a8.sg.73649
Livrare 24-48 ore

98,06Lei(-20%) 78,44Lei

Lanseta Savage Gear SG4 Shore Game F 2.79cm 7-23g 2seg -20%

Lanseta Savage Gear SG4 Shore Game F 2.79cm 7-23g 2seg

o.sg.75010
Livrare 24-48 ore

573,79Lei(-20%) 459,03Lei

Shad, SAVAGE, GEAR, CRAFT, 7,2CM/2,6G, ROACH, 4BUC/PL, f1.sg.74077, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%

Shad, SAVAGE, GEAR, CRAFT, 7,2CM/2,6G, ROACH, 4BUC/PL, f1.sg.74077, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.74077
Livrare 24-48 ore

29,00Lei(-40%) 17,40Lei

GEANTA SAVAGE GEAR BOAT&BANK 24L 36X23X28CM

GEANTA SAVAGE GEAR BOAT&BANK 24L 36X23X28CM

a8.sg.74158
Livrare 24-48 ore

384,52Lei

Hanorac Savage Gear Junior Jaw Grey Melange 12-14 ani -20%

Hanorac Savage Gear Junior Jaw Grey Melange 12-14 ani

a8.sg.76678
Livrare imediată!

224,20Lei(-20%) 179,36Lei

Shad, Savage, Gear, Cannibal,, Firecracker,, 6.8cm,, 3g,, 5buc/pac, f1.sg.77121, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Cannibal,, White, Flash,, 12.5cm,, 20g,, 4buc/pac, f1.sg.77157, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Fat, Minnow, T-Tail,, Clear, Water, Mix,, 13cm,, 20g,, 5buc/pac, f1.sg.77013, Shad-uri, Shad-uri Savage Gear, Savage Gear -20%
Vobler Savage Gear Gravity Minnow Pink Belly Sardine, 5cm, 8g

Vobler Savage Gear Gravity Minnow Pink Belly Sardine, 5cm, 8g

sg.73514
Livrare 24-48 ore

44,03Lei

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Dirty Silver Red, Nr.1, 4.5g

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Dirty Silver Red, Nr.1, 4.5g

sg.82232
Livrare 24-48 ore

28,60Lei

Shad, Savage, Gear, Craft, Bleak,, Clear, Water, Mix,, 7.0cm,, 2.5g,, 5buc/pac, f1.sg.1609141, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Craft, Bleak,, PL, Roach,, 10.0cm,, 6.8g,, 5buc/pac, f1.sg.1609124, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
Lanterna de Cap Savage Gear 100lm -23%

Lanterna de Cap Savage Gear 100lm

a8.sg.71873
Livrare imediată!

139,50Lei(-23%) 107,90Lei

Shad, SAVAGE, GEAR, CANNIBAL, 12,5CM/20G, OLIVE, SMOLT, UV, 3BUC/PL, f1.sg.71918, Shad-uri, Shad-uri Savage Gear, Savage Gear
Afişare 1 - 20 din 1427 (72 pagini)
Queries: 9, Total time: 94.270 ms [By time] [By id] [By file]
1 (0.153)
SELECT data
FROM `oc_session`
WHERE session_id = '3e5d753a01b8a7dd948e31ed68'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.167)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'savage-gear.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.128)
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
6 (35.067)
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:1650
7 (58.295)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.118)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38