Savage Gear

Savage Gear

Sortare după:

Creatura SAVAGE GEAR Salamander Floating, Mojito, 7.5cm, 3g, 5buc/pac

Creatura SAVAGE GEAR Salamander Floating, Mojito, 7.5cm, 3g, 5buc/pac

svs77423

Livrare 7-14 zile

32,00Lei

Stinger SAVAGE GEAR Spinning Rig, 13cm, Nr.2/0, 2buc/pac

Stinger SAVAGE GEAR Spinning Rig, 13cm, Nr.2/0, 2buc/pac

1610837

Livrare 7-14 zile

28,00Lei

Lanseta SAVAGE GEAR SGS2 B.GAME XH, 200-600g, 1.90m, 2seg

Lanseta SAVAGE GEAR SGS2 B.GAME XH, 200-600g, 1.90m, 2seg

svs75624

Livrare imediată!

306,00Lei

Lanseta SAVAGE GEAR SG2 Light Game Spinning Rod L, 5-18g, 1.98m, 2seg

Lanseta SAVAGE GEAR SG2 Light Game Spinning Rod L, 5-18g, 1.98m, 2seg

svs72147

Livrare 7-14 zile

237,00Lei

Lanseta SAVAGE GEAR SGS6 All-Around MH, 12-42g, 2.74m, 2seg

Lanseta SAVAGE GEAR SGS6 All-Around MH, 12-42g, 2.74m, 2seg

svs74928

Livrare 7-14 zile

1.184,00Lei

Vobler SAVAGE GEAR 3D Sticklebait Pencil Sinking, BTS, 10.5g, 6.5cm, 1buc/pac

Vobler SAVAGE GEAR 3D Sticklebait Pencil Sinking, BTS, 10.5g, 6.5cm, 1buc/pac

svs74026

Livrare 7-14 zile

48,00Lei

LANSETA SPINNING SAVAGE GEAR 2BUC. SGS2 ALL-AROUND MF 2,51M/7-25G

LANSETA SPINNING SAVAGE GEAR 2BUC. SGS2 ALL-AROUND MF 2,51M/7-25G

o.sg.74880

Livrare imediată!

430,15Lei(-20%) 344,12Lei

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Gold Black, Nr.2, 5.8g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Grub Spinners, Gold Black, Nr.2, 5.8g, 1buc/pac

svs82469

Livrare imediată!

25,00Lei

Vobler SAVAGE GEAR Freestyler V2 Slow Sinking, Dirty Roach, 13cm, 46g, 1buc/pac

Vobler SAVAGE GEAR Freestyler V2 Slow Sinking, Dirty Roach, 13cm, 46g, 1buc/pac

svs77039

Livrare 7-14 zile

60,00Lei

Vobler Savage Gear Gravity Crank MR Firetiger 7.3cm 19g

Vobler Savage Gear Gravity Crank MR Firetiger 7.3cm 19g

svs71686

Livrare imediată!

36,00Lei

Spinnertail SAVAGE GEAR Fat Tail NL, AYU, 5.5cm, 6.5g, 1buc/pac

Spinnertail SAVAGE GEAR Fat Tail NL, AYU, 5.5cm, 6.5g, 1buc/pac

svs77046

Livrare 7-14 zile

32,00Lei

Swimbait SAVAGE GEAR Sandeel V2 Sinking, Lemon Back, 22g, 12cm, 1+2buc/pac

Swimbait SAVAGE GEAR Sandeel V2 Sinking, Lemon Back, 22g, 12cm, 1+2buc/pac

svs72492

Livrare 7-14 zile

34,00Lei

Mulineta SAVAGE GEAR Real Casting SG6 300 BC RH 5P1BB 7.3

Mulineta SAVAGE GEAR Real Casting SG6 300 BC RH 5P1BB 7.3

svs76080

Livrare 7-14 zile

999,95Lei(-70%) 296,67Lei

SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G PERCH 5BUC/PLIC

SHAD SAVAGE GEAR CRAFT 8.8CM/4.2G PERCH 5BUC/PLIC

f1.sg.72410

Livrare 24-48 ore

36,85Lei(-50%) 18,43Lei

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.4, Dirty Silver, 11g, 1buc/pac

Lingurtia Rotativa SAVAGE GEAR Rotex Spinner, Nr.4, Dirty Silver, 11g, 1buc/pac

svs42128

Livrare imediată!

17,01Lei

HANORAC SAVAGE GEAR MEGA JAW SUN ORANGE MARIME L

HANORAC SAVAGE GEAR MEGA JAW SUN ORANGE MARIME L

a8.sg.73866

Livrare 24-48 ore

202,73Lei(-30%) 141,91Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FLUO ORANGE COPPER

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 6.5CM 9.4G FLUO ORANGE COPPER

sg.72323

Livrare 24-48 ore

46,01Lei

Lanseta SAVAGE GEAR SGS4 Boat Game MF XXH, 150-400g, 2.93m, 2seg

Lanseta SAVAGE GEAR SGS4 Boat Game MF XXH, 150-400g, 2.93m, 2seg

svs75811

Livrare 7-14 zile

699,99Lei(-54%) 321,99Lei

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Goldmine, 8.3cm, 11g, 1buc/pac

Vobler SAVAGE GEAR Gravity Twitch DR Suspending, Sp Goldmine, 8.3cm, 11g, 1buc/pac

1610629

Livrare 7-14 zile

36,00Lei

Lanseta SAVAGE GEAR Revenge SG8 Finesse, 2.43m, 4-18g, 2buc

Lanseta SAVAGE GEAR Revenge SG8 Finesse, 2.43m, 4-18g, 2buc

1601819

Livrare 7-14 zile

1.302,00Lei

Afişare 601 - 620 din 1907 (96 pagini)

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

1 (0.076)

SELECT data
FROM `oc_session`
WHERE session_id = '1ee6c2b03683af03c4b72b0a40'

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

2 (0.107)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.133)

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

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 = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (40.917)

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 = '3' AND p.manufacturer_id = '85'

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

6 (60.598)

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

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

7 (0.152)

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

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