Savage Gear

Savage Gear

Sortare după:

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR AYU CHROME 9.5CM 15G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR AYU CHROME 9.5CM 15G

sg.74131

Livrare 24-48 ore

38,33Lei

MONTURA SAVAGE GEAR CORKSCREW STINGER Nr.2/0 35kg 2BUC/PLIC

MONTURA SAVAGE GEAR CORKSCREW STINGER Nr.2/0 35kg 2BUC/PLIC

a.sg.72278

Livrare 24-48 ore

43,14Lei

GRUB SAVAGE GEAR 5CM 0.8G LUNEBUG 8BUC/PLIC

GRUB SAVAGE GEAR 5CM 0.8G LUNEBUG 8BUC/PLIC

f1.sg.74313

Livrare 24-48 ore

12,41Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING BLACK RED

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 6.5CM 9G SINKING BLACK RED

sg.76810

Livrare 24-48 ore

38,19Lei(-30%) 26,73Lei

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

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

svs78205

Livrare 7-14 zile

46,01Lei

Sapca Savage Gear Catch One Size Olive Green Melange

Sapca Savage Gear Catch One Size Olive Green Melange

svs76691

Livrare imediată!

73,99Lei

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 13cm, 60g, 1buc/pac

Pilker SAVAGE GEAR Sardine Slider XS, UV BGO, 13cm, 60g, 1buc/pac

svs78179

Livrare 7-14 zile

56,00Lei

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

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

svs78083

Livrare 7-14 zile

42,00Lei

Lanseta Spinning SAVAGE GEAR Orange LTD Medium Game 2.21m, 15-45g, 2seg

Lanseta Spinning SAVAGE GEAR Orange LTD Medium Game 2.21m, 15-45g, 2seg

o.sg.1609545

Livrare 24-48 ore

480,33Lei

MANUSI SAVAGE GEAR SHIELD MARIME XL

MANUSI SAVAGE GEAR SHIELD MARIME XL

a8.sg.49412

Livrare 24-48 ore

115,95Lei(-40%) 69,57Lei

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 17.5cm, 96g

Swimbait SAVAGE GEAR 3D Perch RTF Lure, Ghost Silver, 17.5cm, 96g

1624948

Livrare 7-14 zile

52,00Lei

STRUNA SAVAGE BLACK7 TRACE 30CM 045MM 11KG 3BUC PL

STRUNA SAVAGE BLACK7 TRACE 30CM 045MM 11KG 3BUC PL

svs54863

Livrare imediată!

16,01Lei

Fir Savage Gear Regenerator 081MM/33KG/30M

Fir Savage Gear Regenerator 081MM/33KG/30M

svs54842

Livrare 7-14 zile

29,00Lei

Jig SAVAGE GEAR Ball Jighead Bulk, Nr.5/0, 25g, 25buc/pac

Jig SAVAGE GEAR Ball Jighead Bulk, Nr.5/0, 25g, 25buc/pac

1622900

Livrare 7-14 zile

153,00Lei

INEL DESPICAT SAVAGE PT MONTURI 9MM 20BUC/PL

INEL DESPICAT SAVAGE PT MONTURI 9MM 20BUC/PL

a.sg.54929

Livrare imediată!

16,26Lei

Naluca Savage Gear Perch Shad, SS02, 12.5cm, 23g

Naluca Savage Gear Perch Shad, SS02, 12.5cm, 23g

f1.sg.61795

Livrare 24-48 ore

54,80Lei

JIG SAVAGE BALL JIG HEAD TOURNAMENT NR 4/0 5G 25BUC

JIG SAVAGE BALL JIG HEAD TOURNAMENT NR 4/0 5G 25BUC

f2.sg.61921

Livrare 24-48 ore

51,18Lei

Shad Savage Gear LB Cannibal, Blue Pearl, 10cm, 9g, 4buc/plic

Shad Savage Gear LB Cannibal, Blue Pearl, 10cm, 9g, 4buc/plic

f1.sg.61853

Livrare imediată!

20,15Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/DIRTY ROACH 4BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/DIRTY ROACH 4BUC/PLIC

f1.sg.63798

Livrare imediată!

16,66Lei(-20%) 13,33Lei

Agrafa Cu Vartej Cu Rulment SAVAGE GEAR Snaps Medium, Nr.2, 24kg, 6buc/pac

Agrafa Cu Vartej Cu Rulment SAVAGE GEAR Snaps Medium, Nr.2, 24kg, 6buc/pac

svs54925

Livrare 7-14 zile

32,00Lei

Afişare 2101 - 2120 din 2179 (109 pagini)

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

1 (0.107)

SELECT data
FROM `oc_session`
WHERE session_id = '3b823e759b0fe46ced320807b4'

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

2 (0.108)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.087)

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

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

5 (41.863)

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:1699

6 (61.755)

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 = '0' AND p.manufacturer_id = '85' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 2100,20

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

7 (0.140)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37