Savage Gear

Savage Gear

Sortare după:

Shad Savage Gear LB Cannibal, Pike, 6.8cm, 3g, 4buc/plic

Shad Savage Gear LB Cannibal, Pike, 6.8cm, 3g, 4buc/plic

f1.sg.61843

Livrare imediată!

17,94Lei

SWIMBAIT SAVAGE GEAR 4D PERCH SHAD 12.5CM/23G LEMON SS05

SWIMBAIT SAVAGE GEAR 4D PERCH SHAD 12.5CM/23G LEMON SS05

f1.sg.71466

Livrare imediată!

30,73Lei

SAPCA SAVAGE SALT UV

SAPCA SAVAGE SALT UV

a8.sg.62279

Livrare 24-48 ore

84,68Lei

Paleta SAVAGE GEAR Spinner Screwin Teaser, Marimea S, Red-Silver, 3buc/pac

Paleta SAVAGE GEAR Spinner Screwin Teaser, Marimea S, Red-Silver, 3buc/pac

svs72286

Livrare 7-14 zile

21,34Lei

CLESTE SAVAGE GEAR MP CUT CRIMP S 22.5CM

CLESTE SAVAGE GEAR MP CUT CRIMP S 22.5CM

svs71892

Livrare imediată!

70,14Lei

Ghete SAVAGE GEAR Sg8 Wading Boot Cleat Cleat, Nr.47

Ghete SAVAGE GEAR Sg8 Wading Boot Cleat Cleat, Nr.47

1601844

Livrare 7-14 zile

571,43Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, Orange Gold Glow, 9cm, 120g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, Orange Gold Glow, 9cm, 120g, 1buc/pac

svs77307

Livrare 7-14 zile

74,21Lei

ORIGINAL BUFF SAVAGE TEC TUBE BLACK CAPTUSITA FLEECE

ORIGINAL BUFF SAVAGE TEC TUBE BLACK CAPTUSITA FLEECE

a8.sg.50838

Livrare 24-48 ore

56,77Lei(-36%) 36,55Lei

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Perch

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Perch

f1.sg.71822

Livrare 24-48 ore

31,23Lei(-36%) 19,95Lei

Shad Savage Gear Minnow WL WHITE PEARL SILVER 12.5cm 28g 3buc

Shad Savage Gear Minnow WL WHITE PEARL SILVER 12.5cm 28g 3buc

f1.sg.72446

Livrare 24-48 ore

54,67Lei(-15%) 46,39Lei

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, Saddled Bream, 10cm, 40g, 1buc/pac

Pilker SAVAGE GEAR 3D Slim Jig Minnow Fast Sinking, Saddled Bream, 10cm, 40g, 1buc/pac

svs78201

Livrare 7-14 zile

47,77Lei

Pilker SAVAGE GEAR Squid Dealer 3.0, Fire Shrimp, 14.3g, 10cm, 1buc/pac

Pilker SAVAGE GEAR Squid Dealer 3.0, Fire Shrimp, 14.3g, 10cm, 1buc/pac

svs78080

Livrare 7-14 zile

43,71Lei

CREATURA SAVAGE REACTION CRAYFISH 7,3CM/4G GREEN PUMPKIN 5BUC/PLIC

CREATURA SAVAGE REACTION CRAYFISH 7,3CM/4G GREEN PUMPKIN 5BUC/PLIC

f1.sg.74104

Livrare 24-48 ore

35,25Lei(-44%) 19,84Lei

LANSETA SAVAGE GEAR SG2 MEDIUM GAME 2.51M 7-23G 2SEG

LANSETA SAVAGE GEAR SG2 MEDIUM GAME 2.51M 7-23G 2SEG

o.sg.72156

Livrare imediată!

309,38Lei

NALUCA SAVAGE GEAR 3D SUICIDE DUCK UGLY DUCKLING 10.5CM 28G

NALUCA SAVAGE GEAR 3D SUICIDE DUCK UGLY DUCKLING 10.5CM 28G

f1.sg.71866

Livrare 24-48 ore

69,55Lei

GRUB SAVAGE GEAR 5CM 0.8G RED&BLACK 8BUC/PLIC

GRUB SAVAGE GEAR 5CM 0.8G RED&BLACK 8BUC/PLIC

f1.sg.74316

Livrare 24-48 ore

14,53Lei

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 4.5CM 8G S HOLO PINK GLOW

PILKER JIG SAVAGE GEAR PENCIL MICRO Z 4.5CM 8G S HOLO PINK GLOW

sg.77396

Livrare 24-48 ore

37,03Lei

Jig Savage Gear Tungsten Ball Jighead, Matt Black, Nr.4/0, 28g, 1buc/pac

Jig Savage Gear Tungsten Ball Jighead, Matt Black, Nr.4/0, 28g, 1buc/pac

f2.sg.82300

Livrare 24-48 ore

52,39Lei(-56%) 23,22Lei

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Bream, 18cm, 104g

Swimbait SAVAGE GEAR 3D Roach RTF Lure, Bream, 18cm, 104g

1625370

Livrare 7-14 zile

62,01Lei

MANUSI SAVAGE GEAR PRO TEC CU DEGETE TAIATE MARIME L

MANUSI SAVAGE GEAR PRO TEC CU DEGETE TAIATE MARIME L

a8.sg.43849

Livrare 24-48 ore

85,08Lei

Afişare 1261 - 1280 din 1786 (90 pagini)

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

1 (0.090)

SELECT data
FROM `oc_session`
WHERE session_id = '52caebdcbc49660d78125e1b87'

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

2 (0.092)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.109)

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

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

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

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

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

7 (0.114)

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