Savage Gear


Vobler Savage Gear Fat Vibes Dirty Roach 5.1cm, 11g -26%

Vobler Savage Gear Fat Vibes Dirty Roach 5.1cm, 11g

sg.71668
Livrare imediată!

41,64Lei(-26%) 30,90Lei

LINGURITA Rotativa Savage Gear Caviar Firetiger Nr.2 6g

LINGURITA Rotativa Savage Gear Caviar Firetiger Nr.2 6g

f.sg.40961
Livrare imediată!

21,31Lei

Fir Monofilament Savage Gear Silencer 0.15mm 1.80kg 300m -20%

Fir Monofilament Savage Gear Silencer 0.15mm 1.80kg 300m

a.sg.72425
Livrare 24-48 ore

26,37Lei(-20%) 21,10Lei

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.L

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.L

a8.sg.76463
Livrare 24-48 ore

71,05Lei

Shad, SAVAGE, GEAR, CRAFT, 10CM/6G, DARK, WATER, MIX, 5BUC/P, f1.sg.74099, Shad-uri, Shad-uri Savage Gear, Savage Gear
SHAD, SAVAGE, GEAR, SHAD, CRAFT, MOTOR, OIL, 7.2CM, 2.6G, 4BUC/PLIC, f1.sg.74081, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%

SHAD, SAVAGE, GEAR, SHAD, CRAFT, MOTOR, OIL, 7.2CM, 2.6G, 4BUC/PLIC, f1.sg.74081, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.74081
Livrare 24-48 ore

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

TRICOU SAVAGE GEAR NIGHT UV BLACK WATERPRINT MAR.S -40%

TRICOU SAVAGE GEAR NIGHT UV BLACK WATERPRINT MAR.S

a8.sg.73898
Livrare 24-48 ore

148,63Lei(-40%) 89,18Lei

SHAD SAVAGE GEAR GOBSTER 9CM 9G SMELT 5BUC/PLIC -40%

SHAD SAVAGE GEAR GOBSTER 9CM 9G SMELT 5BUC/PLIC

f1.sg.76940
Livrare 24-48 ore

24,54Lei(-40%) 14,72Lei

JACHETA SAVAGE GEAR SOFTSHELL REFLECTION HYBRID L

JACHETA SAVAGE GEAR SOFTSHELL REFLECTION HYBRID L

a8.sg.76561
Livrare 24-48 ore

473,74Lei

Naluca, Savage, Gear, Fat, Tail, NL, 6.5cm, 12.5g, Dirty, Silver, sg.77052, Spinnertails, Spinnertails Savage Gear, Savage Gear -30%
Shad, Savage, Gear, Cannibal,, Motor, Oil, UV,, 12.5cm,, 20g,, 4buc/pac, f1.sg.77159, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Fat, Minnow, T-Tail,, Holo, Baitfish,, 10.5cm,, 11g,, 5buc/pac, f1.sg.76999, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%
Lingurita Rotativa Savage Gear Spinner Grub, Sinking, Black Red Black, Nr.0, 2.2g

Lingurita Rotativa Savage Gear Spinner Grub, Sinking, Black Red Black, Nr.0, 2.2g

sg.82458
Livrare 24-48 ore

21,82Lei

Minciong Wizard Mxt Street 1000, 50x45x40cm

Minciong Wizard Mxt Street 1000, 50x45x40cm

71061600
Livrare 24-48 ore

191,89Lei

Shad, Savage, Gear, Craft, Bleak,, Olive, Hot, Orange,, 8.5cm,, 4.2g,, 5buc/pac, f1.sg.1609119, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
SAVAGE GEAR FAT TAIL 8CM/24G SINKING BLUE SILVER PINK

SAVAGE GEAR FAT TAIL 8CM/24G SINKING BLUE SILVER PINK

sg.71772
Livrare imediată!

39,64Lei

Vobler Savage Gear Gravity Twitch SR Ayu Chrome 8.3cm 10g

Vobler Savage Gear Gravity Twitch SR Ayu Chrome 8.3cm 10g

sg.71657
Livrare 24-48 ore

44,03Lei

Vobler, Savage, Gear, 3D, Goby, Crank, SR, Blue, Silver, 4cm, 3g, sg.71728, Voblere Floating, Voblere Floating Savage Gear, Savage Gear
SHAD SAVAGE GEAR CRAFT 10CM 6G PERCH 5BUC/PLIC -40%

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

f1.sg.72416
Livrare 24-48 ore

38,73Lei(-40%) 23,24Lei

Fir Monofilament Savage Gear Silencer 0.31mm 7.17kg 300m -40%

Fir Monofilament Savage Gear Silencer 0.31mm 7.17kg 300m

a.sg.72268
Livrare 24-48 ore

45,37Lei(-40%) 27,23Lei

Afişare 1 - 20 din 1428 (72 pagini)
Queries: 7, Total time: 98.431 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = 'c66c112f5c72e443a23cbcf863'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.128)
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.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
5 (43.230)
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:1661
6 (54.618)
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:438
7 (0.127)
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