Savage Gear

Savage Gear

Sortare după:

CLESTE SAVAGE ALU PRO M 17.5CM

CLESTE SAVAGE ALU PRO M 17.5CM

a.sg.71887

Livrare 24-48 ore

198,44Lei(-18%) 163,33Lei

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Olive Pearl Hot Orange

Shad Savage Gear Craft Cannibal Paddletail 12.5cm 20g 3buc/plic Olive Pearl Hot Orange

f1.sg.71824

Livrare imediată!

17,74Lei(-13%) 15,43Lei

Ochelari polarizati Savage Gear Savage 1 Brown

Ochelari polarizati Savage Gear Savage 1 Brown

svs72246

Livrare imediată!

146,40Lei

Shad Savage Gear Minnow WL Lemon Back 12.5cm 28g 3buc

Shad Savage Gear Minnow WL Lemon Back 12.5cm 28g 3buc

f1.sg.72448

Livrare 24-48 ore

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

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 9.5CM 15G

VOBLER SAVAGE GEAR GRAVITY TWITCH SUSPENDING MR PERCH 9.5CM 15G

sg.74129

Livrare 24-48 ore

40,89Lei

MINCIOG SAVAGE GEAR FOLDING DLX L 65X50X50CM 84CM

MINCIOG SAVAGE GEAR FOLDING DLX L 65X50X50CM 84CM

svs71104

Livrare imediată!

229,78Lei

KIT SAVAGE GEAR NALUCI ACC GRAVITY STICK 30 19BUC

KIT SAVAGE GEAR NALUCI ACC GRAVITY STICK 30 19BUC

svs71865

Livrare imediată!

190,13Lei

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL

NALUCA SAVAGE GEAR SKIRT FLIRT JIG 6.5CM/10G SINKING WHITE PEARL

f1.sg.76853

Livrare 24-48 ore

30,84Lei(-53%) 14,46Lei

Sapca Savage Gear Catch One Size Olive Green Melange

Sapca Savage Gear Catch One Size Olive Green Melange

svs76691

Livrare imediată!

76,24Lei

Vobler Savage Gear Freestyler V2, Slow Sinking, Firetiger, 11cm, 28g

Vobler Savage Gear Freestyler V2, Slow Sinking, Firetiger, 11cm, 28g

sg.77073

Livrare 24-48 ore

52,64Lei

MANUSI SAVAGE GEAR SHIELD MARIME XL

MANUSI SAVAGE GEAR SHIELD MARIME XL

a8.sg.49412

Livrare 24-48 ore

115,95Lei(-37%) 72,65Lei

Bride Savage Gear 100 buc plic

Bride Savage Gear 100 buc plic

svs54900

Livrare imediată!

19,30Lei

NALUCA SOFT SAVAGE GEAR 3D PVC MAYFLY, BROWN GLITTER, 5CM, 8BUC/PLIC

NALUCA SOFT SAVAGE GEAR 3D PVC MAYFLY, BROWN GLITTER, 5CM, 8BUC/PLIC

svs55114

Livrare imediată!

35,57Lei

Cagula Savage Gear Skull Balaclava

Cagula Savage Gear Skull Balaclava

svs59214

Livrare imediată!

76,24Lei

Broasca Savage Gear 3D Pop Frog, Verde, 5.5cm, 14g

Broasca Savage Gear 3D Pop Frog, Verde, 5.5cm, 14g

svs62026

Livrare imediată!

41,67Lei

Pilker SAVAGE GEAR Swimsquid Inchiku, Blue Pink Glow, 9.7cm, 150g, 1buc/pac

Pilker SAVAGE GEAR Swimsquid Inchiku, Blue Pink Glow, 9.7cm, 150g, 1buc/pac

svs77312

Livrare 7-14 zile

78,27Lei

SHAD SAVAGE LB CANNIBAL 6.8CM/PIKE 5BUC/PLIC

SHAD SAVAGE LB CANNIBAL 6.8CM/PIKE 5BUC/PLIC

f1.sg.69954

Livrare 24-48 ore

20,19Lei(-19%) 16,29Lei

Pilker SAVAGE GEAR Seeker ISP Sinking, Red Black, 10cm, 28g, 1buc/pac

Pilker SAVAGE GEAR Seeker ISP Sinking, Red Black, 10cm, 28g, 1buc/pac

svs55355

Livrare 7-14 zile

31,50Lei

Shad SAVAGE GEAR LB Cannibal, Perch, 6.8cm, 3g, 80buc/pac

Shad SAVAGE GEAR LB Cannibal, Perch, 6.8cm, 3g, 80buc/pac

svs58985

Livrare 7-14 zile

276,55Lei

Spinnerbait Savage Gear Da Bush Yellow Silver Holo Flame 14cm 21g

Spinnerbait Savage Gear Da Bush Yellow Silver Holo Flame 14cm 21g

sg.71753

Livrare 24-48 ore

27,41Lei

Afişare 1141 - 1160 din 1522 (77 pagini)

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

1 (0.094)

SELECT data
FROM `oc_session`
WHERE session_id = '865f37e77d38f371247987f759'

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

2 (0.129)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.172)

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

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

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

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

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

7 (0.142)

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