Savage Gear

Savage Gear

Sortare după:

Lanterna Cap Frontala Savage Gear UV Zoom 5W 400 Lumeni

Lanterna Cap Frontala Savage Gear UV Zoom 5W 400 Lumeni

svs70777

Livrare imediată!

92,50Lei

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(-24%) 29,09Lei

BLUZA SAVAGE SIGNATURE LOGO LONG SLEEVE BLACK CAVIAR MAR.S

svs73908

Livrare 7-14 zile

101,66Lei

Jig Savage Gear Rac Nr.2/0, 5g, 3buc/pac

Jig Savage Gear Rac Nr.2/0, 5g, 3buc/pac

f2.sg.74415

Livrare 24-48 ore

33,80Lei

Swimbait SAVAGE GEAR 3D Trout Rattle Shad Lure, Clear Rainbow, 17cm, 90g

Swimbait SAVAGE GEAR 3D Trout Rattle Shad Lure, Clear Rainbow, 17cm, 90g

1625336

Livrare 7-14 zile

53,87Lei

FIR SAVAGE SOFT FLUOROCARBON 060MM 21.6KG 20M

FIR SAVAGE SOFT FLUOROCARBON 060MM 21.6KG 20M

svs54855

Livrare imediată!

80,31Lei

FIR METALIC SAVAGE GEAR CARBON49 060MM/16KG/10M

FIR METALIC SAVAGE GEAR CARBON49 060MM/16KG/10M

a.sg.54896

Livrare 24-48 ore

81,61Lei

Minciog SAVAGE GEAR Full Frame Oval Landing Net, 2 Tronsoane, 99-150cm, 55x47x53cm

Minciog SAVAGE GEAR Full Frame Oval Landing Net, 2 Tronsoane, 99-150cm, 55x47x53cm

svs57578

Livrare imediată!

229,78Lei

Vobler Savage Gear Cicada 3D, Culoare 61987, 3.3cm, 3.5g

Vobler Savage Gear Cicada 3D, Culoare 61987, 3.3cm, 3.5g

svs61987

Livrare imediată!

37,61Lei

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

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

svs77309

Livrare 7-14 zile

74,21Lei

SHAD SAVAGE LB 4D HERRING 9CM/5G FIRETIGER 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 9CM/5G FIRETIGER 4BUC/PLIC

f1.sg.63654

Livrare 24-48 ore

33,78Lei

NALUCA SAVAGE GEAR 4D REAL EEL 20CM/38G FIRETIGER PHP

NALUCA SAVAGE GEAR 4D REAL EEL 20CM/38G FIRETIGER PHP

svs63767

Livrare imediată!

66,08Lei

Pilker SAVAGE GEAR Powerglow EGI, Culoare Orange, 22.8g, 11cm, 1buc/pac

Pilker SAVAGE GEAR Powerglow EGI, Culoare Orange, 22.8g, 11cm, 1buc/pac

svs78089

Livrare 7-14 zile

47,77Lei

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

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

f1.sg.71821

Livrare imediată!

19,05Lei

Shad Savage Gear Minnow WL KHAKI 12.5cm 28g 3buc

Shad Savage Gear Minnow WL KHAKI 12.5cm 28g 3buc

f1.sg.72445

Livrare 24-48 ore

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

Set Cleme Savage Gear Easyon BUZZER BAIT ARM Silver L 2buc

Set Cleme Savage Gear Easyon BUZZER BAIT ARM Silver L 2buc

a.sg.72292

Livrare 24-48 ore

24,61Lei(-41%) 14,44Lei

CREATURA SAVAGE REACTION CRAYFISH 9.1CM/7.5G BLACK N BLUE 5BUC/PLIC

CREATURA SAVAGE REACTION CRAYFISH 9.1CM/7.5G BLACK N BLUE 5BUC/PLIC

f1.sg.74108

Livrare 24-48 ore

31,33Lei(-43%) 17,84Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 8.3CM 10G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 8.3CM 10G

sg.74123

Livrare 24-48 ore

43,28Lei(-35%) 28,31Lei

KIT SAVAGE GEAR EASYON SPINNER BAIT SILVER MARIME L 2BUC/PLIC

KIT SAVAGE GEAR EASYON SPINNER BAIT SILVER MARIME L 2BUC/PLIC

a.sg.72290

Livrare 24-48 ore

22,30Lei(-20%) 17,79Lei

CUTIE SAVAGE GEAR KIT CUTIE PT.ACCESORII 1 SMOKE COMBI 13,8X7,7X3,1CM 3PCS

CUTIE SAVAGE GEAR KIT CUTIE PT.ACCESORII 1 SMOKE COMBI 13,8X7,7X3,1CM 3PCS

svs74229

Livrare imediată!

59,97Lei

Afişare 901 - 920 din 1523 (77 pagini)

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

1 (0.082)

SELECT data
FROM `oc_session`
WHERE session_id = '4a6cb68b603efbd2edb9dfd007'

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

2 (0.067)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.090)

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

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

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

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

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

7 (0.146)

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