Savage Gear


Shad, Savage, Gear, Cannibal,, Flou, Yellow, Glow,, 6.8cm,, 3g,, 5buc/pac, f1.sg.77128, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Cannibal,, Clearwater, Mix,, 8cm,, 5g, +, 7.5g,, Nr.2/0,, 4buc/pac, f1.sg.77182, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad Savage Gear Fat Minnow T-Tail, Dark Water Mix, 13cm, 20g, 5buc/pac -20%

Shad Savage Gear Fat Minnow T-Tail, Dark Water Mix, 13cm, 20g, 5buc/pac

f1.sg.77012
Livrare 24-48 ore

50,96Lei(-20%) 40,77Lei

Vobler Savage Gear Shrimp Twith SR Orange, 5.2cm, 5.5g

Vobler Savage Gear Shrimp Twith SR Orange, 5.2cm, 5.5g

sg.77025
Livrare 24-48 ore

39,64Lei

Lingurita, Rotativa, Savage, Gear, Spinner, Sticklebait,, Sinking,, Minnow, Gold, Red,, Nr.1,, 4.5g, sg.82236, Lingurite Rotative, Lingurite Rotative Savage Gear, Savage Gear
Shad, Savage, Gear, Craft, Bleak,, Green, Pearl, Yellow,, 7.0cm,, 2.5g,, 5buc/pac, f1.sg.1609102, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING AYU

SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING AYU

sg.71764
Livrare imediată!

37,41Lei

Vobler, Savage, Gear, Gravity, Twitch, SR, Dirty, Roach, 6.7cm, 6g, sg.71650, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler Savage Gear Gravity Crank MR Perch 7.3cm 19g -42%

Vobler Savage Gear Gravity Crank MR Perch 7.3cm 19g

sg.71687
Livrare 24-48 ore

43,46Lei(-42%) 25,10Lei

SHAD, SAVAGE, GEAR, CRAFT, 8.8CM/4.2G, PERCH, 5BUC/PLIC, f1.sg.72410, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%

SHAD, SAVAGE, GEAR, CRAFT, 8.8CM/4.2G, PERCH, 5BUC/PLIC, f1.sg.72410, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.72410
Livrare 24-48 ore

36,85Lei(-40%) 22,11Lei

MANUSI SAVAGE GEAR AQUA MESH SEA BLUE MAR.L -30%

MANUSI SAVAGE GEAR AQUA MESH SEA BLUE MAR.L

a8.sg.76484
Livrare 24-48 ore

92,53Lei(-30%) 64,77Lei

Maneci Bluza Savage Gear Protectie Soare Marine UV Sea Blue One Size

Maneci Bluza Savage Gear Protectie Soare Marine UV Sea Blue One Size

a8.sg.73676
Livrare imediată!

61,04Lei

SHORT SAVAGE GEAR MARINE SEA BLUE MAR.L -20%

SHORT SAVAGE GEAR MARINE SEA BLUE MAR.L

a8.sg.73916
Livrare 24-48 ore

189,94Lei(-20%) 151,95Lei

SHAD, SAVAGE, GEAR, GOBSTER, 11.5CM, 16G, FIRECRACKER, 5BUC/PLIC, f1.sg.76948, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%

SHAD, SAVAGE, GEAR, GOBSTER, 11.5CM, 16G, FIRECRACKER, 5BUC/PLIC, f1.sg.76948, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.76948
Livrare 24-48 ore

30,70Lei(-40%) 18,42Lei

COSTUM SAVAGE GEAR SG2 THERMAL BLUENIGHTS/BLACK XL -20%

COSTUM SAVAGE GEAR SG2 THERMAL BLUENIGHTS/BLACK XL

a8.sg.76593
Livrare 24-48 ore

970,46Lei(-20%) 776,37Lei

Shad Savage Gear Cannibal, Chartreuse Pumpkin, 12.5cm, 20g, 4buc/pac

Shad Savage Gear Cannibal, Chartreuse Pumpkin, 12.5cm, 20g, 4buc/pac

f1.sg.77156
Livrare 24-48 ore

26,91Lei

Shad, Savage, Gear, Cannibal,, Purple, Glitter, Bomb,, 10cm,, 9g,, 5buc/pac, f1.sg.77150, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad Savage Gear Fat Minnow T-Tail, Smelt, 10.5cm, 11g, 5buc/pac -40%

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

f1.sg.76994
Livrare imediată!

40,48Lei(-40%) 24,29Lei

Lingurita Rotativa Savage Gear Spinner Grub, Sinking, Silver Red Yellow, Nr.2, 5.8g

Lingurita Rotativa Savage Gear Spinner Grub, Sinking, Silver Red Yellow, Nr.2, 5.8g

sg.82466
Livrare 24-48 ore

28,60Lei

Shad, Savage, Gear, Craft, Bleak,, Green, Pearl, Yellow,, 10.0cm,, 6.8g,, 5buc/pac, f1.sg.1609122, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
Afişare 41 - 60 din 1427 (72 pagini)
Queries: 9, Total time: 90.571 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = 'e5a7b0a9d1abb901226ca75ef4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.145)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.139)
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.133)
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 (36.009)
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 (53.655)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.095)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.118)
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