Savage Gear


Vobler, Savage, Gear, Gravity, Twitch, SR, Blue, Chrome, 9.5cm, 15g, sg.71659, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler, Savage, Gear, 3D, Goby, Crank, SR, UV, Orange, 5cm, 6.5g, sg.71731, Voblere Floating, Voblere Floating Savage Gear, Savage Gear
TRICOU SAVAGE CANNIBAL INK GREY MELANGE MARIME XL

TRICOU SAVAGE CANNIBAL INK GREY MELANGE MARIME XL

a8.sg.71601
Livrare imediată!

83,59Lei

SHAD, SAVAGE, GEAR, CRAFT, 10CM, 6G, BLUE, PEARL, 5BUC/PLIC, f1.sg.72418, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%

SHAD, SAVAGE, GEAR, CRAFT, 10CM, 6G, BLUE, PEARL, 5BUC/PLIC, f1.sg.72418, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.72418
Livrare 24-48 ore

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

Fir Monofilament Savage Gear Silencer 0.405mm 11.92kg 300m -40%

Fir Monofilament Savage Gear Silencer 0.405mm 11.92kg 300m

a.sg.72270
Livrare 24-48 ore

58,44Lei(-40%) 35,06Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FIRETIGER

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FIRETIGER

sg.72324
Livrare 24-48 ore

48,49Lei

Jacheta Savage Gear SG2 Hybrid Slate Green Marime S -40%

Jacheta Savage Gear SG2 Hybrid Slate Green Marime S

a8.sg.73718
Livrare 24-48 ore

586,38Lei(-40%) 351,83Lei

Shad, SAVAGE, GEAR, CRAFT, 10CM/6G, PERCH, 4BUC/PL, f1.sg.74090, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%

Shad, SAVAGE, GEAR, CRAFT, 10CM/6G, PERCH, 4BUC/PL, f1.sg.74090, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.74090
Livrare 24-48 ore

32,53Lei(-40%) 19,52Lei

TRICOU, SAVAGE, GEAR, FIGHTER, STRETCH, BURNT, OLIVE, MELANGE, MAR.L, a8.sg.73890, Tricouri, Tricouri Savage Gear, Savage Gear -20%

TRICOU, SAVAGE, GEAR, FIGHTER, STRETCH, BURNT, OLIVE, MELANGE, MAR.L, a8.sg.73890, Tricouri, Tricouri Savage Gear, Savage Gear

a8.sg.73890
Livrare 24-48 ore

134,10Lei(-20%) 107,28Lei

Hanorac Savage Gear Junior Logo Black Ink 12-14 ani -20%

Hanorac Savage Gear Junior Logo Black Ink 12-14 ani

a8.sg.76681
Livrare imediată!

236,70Lei(-20%) 189,00Lei

Shad, Savage, Gear, Cannibal,, Flou, Yellow, Glow,, 12.5cm,, 20g,, 4buc/pac, f1.sg.77158, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad, Savage, Gear, Cannibal,, Clearwater, Mix,, 10cm,, 9g, +, 10g,, Nr.3/0,, 4buc/pac, f1.sg.77184, Shad-uri, Shad-uri Savage Gear, Savage Gear
Shad Savage Gear Fat Minnow T-Tail, Dark Water Mix, 10.5cm, 11g, 5buc/pac -20%

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

f1.sg.77010
Livrare imediată!

39,73Lei(-20%) 31,78Lei

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

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

sg.77024
Livrare 24-48 ore

39,64Lei

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.1, 4.5g

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.1, 4.5g

sg.82235
Livrare 24-48 ore

28,60Lei

Shad, Savage, Gear, Craft, Bleak,, Firecracker,, 7.0cm,, 2.5g,, 5buc/pac, f1.sg.1609101, Shad-uri, Shad-uri Savage Gear, Shad-uri Savage Gear, Savage Gear
SAVAGE GEAR FAT TAIL 6,5CM/16G SINKING WHITE SILVER

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

sg.71763
Livrare imediată!

37,41Lei

Vobler, Savage, Gear, Gravity, Twitch, SR, Perch, 6.7cm, 6g, sg.71649, Voblere Suspending, Voblere Suspending Savage Gear, Savage Gear
Vobler Savage Gear Gravity Crank MR Firetiger 7.3cm 19g -40%

Vobler Savage Gear Gravity Crank MR Firetiger 7.3cm 19g

sg.71686
Livrare 24-48 ore

43,46Lei(-40%) 26,07Lei

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

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

f1.sg.72409
Livrare 24-48 ore

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

Afişare 201 - 220 din 1427 (72 pagini)
Queries: 11, Total time: 88.444 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '843bcb63ed5b9f9fae43dd8a15'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.134)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.213)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
4 (0.217)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
5 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
6 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'savage-gear.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
7 (0.084)
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
8 (34.622)
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:1650
9 (52.625)
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 = '0' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
10 (0.116)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38