Savage Gear

Savage Gear

Sortare după:

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

Protecite Lansete SAVAGE GEAR Neoprene Rod Tip/Butt Protector

Protecite Lansete SAVAGE GEAR Neoprene Rod Tip/Butt Protector

1622901

Livrare 7-14 zile

66,08Lei

ATRACTANT SAVAGE GEAR GARLIC SHRIMP TROUT MEAT

ATRACTANT SAVAGE GEAR GARLIC SHRIMP TROUT MEAT

a0.sg.48813

Livrare imediată!

39,00Lei(-12%) 34,45Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/FIRETIGER/4BUC/PL

SHAD SAVAGE LB CANNIBAL 6.8CM/3G/FIRETIGER/4BUC/PL

svs58984-bucxxx4

Livrare imediată!

15,23Lei

Fir Struna Savage 7x7 Carbon49, Grey, 0.70mm, 23kg, 10m

Fir Struna Savage 7x7 Carbon49, Grey, 0.70mm, 23kg, 10m

a.sg.54897

Livrare 24-48 ore

81,61Lei

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Roach, 16cm, 28g, 2buc/pac

Shad SAVAGE GEAR XX Shad Savage 4D Herring, Roach, 16cm, 28g, 2buc/pac

f1.sg.57460

Livrare 24-48 ore

41,82Lei

STRUNA SAVAGE TITANIUM7 TRACE 20CM 030MM/7KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 20CM 030MM/7KG 2BUC/PL

a7.sg.61769

Livrare 24-48 ore

42,84Lei(-40%) 25,70Lei

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

svs54894

Livrare imediată!

78,27Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/GOLDEN AMBULANCE 5BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/GOLDEN AMBULANCE 5BUC/PLIC

f1.sg.69953

Livrare imediată!

20,19Lei(-22%) 15,69Lei

Hanorac SAVAGE GEAR Tec Foam Zip, Dark Grey Melange, Marimea XL

Hanorac SAVAGE GEAR Tec Foam Zip, Dark Grey Melange, Marimea XL

svs76588

Livrare 7-14 zile

314,18Lei

Pilker SAVAGE GEAR Surf Seeker S, Green Silver, 11cm, 40g, 1buc/pac

Pilker SAVAGE GEAR Surf Seeker S, Green Silver, 11cm, 40g, 1buc/pac

svs71789

Livrare 7-14 zile

39,64Lei

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Dirty Roach

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Dirty Roach

f1.sg.71812

Livrare 24-48 ore

29,86Lei(-43%) 17,10Lei

Fir Fluorocarbon Savage Gear Semi Soft LRF 0.19mm 30m 2.22kg

Fir Fluorocarbon Savage Gear Semi Soft LRF 0.19mm 30m 2.22kg

svs74497

Livrare imediată!

27,44Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Black Pearl, 8.7cm, 16g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Black Pearl, 8.7cm, 16g, 1buc/pac

svs55346

Livrare 7-14 zile

29,48Lei

Afişare 1321 - 1340 din 1785 (90 pagini)

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

1 (0.111)

SELECT data
FROM `oc_session`
WHERE session_id = '64c5a8a19dd180baa09ae7d5c0'

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.138)

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

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

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

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

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

7 (0.125)

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