Savage Gear

Savage Gear

Sortare după:

SHAD SAVAGE CANNIBAL 10CM/9G/FIRETIGER/4BUC/PL

SHAD SAVAGE CANNIBAL 10CM/9G/FIRETIGER/4BUC/PL

svs61852-bucxxx4

Livrare imediată!

21,33Lei

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 14000FD

Tambur Rezerva SAVAGE GEAR SGS8 FD Spare Spool, 14000FD

svs73127

Livrare imediată!

149,96Lei(-41%) 87,85Lei

Carlige Savage Gear Offset EWG, NR6/0/3G 3BUC/PL

Carlige Savage Gear Offset EWG, NR6/0/3G 3BUC/PL

svs61777

Livrare imediată!

41,67Lei

Minciog Telescopic SAVAGE GEAR Full Frame Net XL Rubber Mesh, 50-65x95x150cm

Minciog Telescopic SAVAGE GEAR Full Frame Net XL Rubber Mesh, 50-65x95x150cm

svs57576

Livrare imediată!

291,82Lei

SHAD SAVAGE LB CANNIBAL 12.5CM/20G/RED HEAD 3BUC/PLIC

SHAD SAVAGE LB CANNIBAL 12.5CM/20G/RED HEAD 3BUC/PLIC

svs69067-bucxxx

Livrare imediată!

23,87Lei

Pilker SAVAGE GEAR 3D Line Thru Sandeel Sinking, BS UV, 25g, 11cm, 1buc/pac

Pilker SAVAGE GEAR 3D Line Thru Sandeel Sinking, BS UV, 25g, 11cm, 1buc/pac

svs63837

Livrare imediată!

45,74Lei

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Firetiger

Shad Savage Gear Craft Cannibal Paddletail 8.5cm 7g 4buc/plic Firetiger

f1.sg.71809

Livrare imediată!

25,42Lei(-35%) 16,50Lei

Fir Fluorocarbon Savage Gear Soft Seabass 0.32mm 30m 5.51kg

Fir Fluorocarbon Savage Gear Soft Seabass 0.32mm 30m 5.51kg

svs74486

Livrare imediată!

37,61Lei

MONTURA SAVAGE GEAR CORKSCREW STINGER 3G NR.1X1/0 35KG RED BN 2BUC/PLIC

MONTURA SAVAGE GEAR CORKSCREW STINGER 3G NR.1X1/0 35KG RED BN 2BUC/PLIC

a.sg.72277

Livrare 24-48 ore

39,72Lei

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 2.21M 7-23G 2SEG

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 2.21M 7-23G 2SEG

o.sg.72199

Livrare 24-48 ore

469,92Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

svs75805

Livrare 7-14 zile

597,55Lei(-18%) 487,07Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G FIRETIGER 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G FIRETIGER 4BUC/PLIC

f1.sg.74288

Livrare 24-48 ore

38,97Lei

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING GREEN SILVER AYU

SPINNER SAVAGE GEAR 3D STICKLEBAIT TAILSPIN 7.3CM 13G SINKING GREEN SILVER AYU

sg.76813

Livrare 24-48 ore

39,37Lei(-24%) 29,94Lei

SAVAGE GEAR PANTALON JOGGERS DARK GREY MELANGE MAR.L

SAVAGE GEAR PANTALON JOGGERS DARK GREY MELANGE MAR.L

a8.sg.76700

Livrare 24-48 ore

279,91Lei(-18%) 229,61Lei

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 40X50X50CM

MINCIOG SAVAGE FINEZZE PLASA CAUCIUCATA 40X50X50CM

a2.sg.50802

Livrare 24-48 ore

111,37Lei

CANTAR DIGITAR SAVAGE GEAR 30KG

CANTAR DIGITAR SAVAGE GEAR 30KG

a.sg.45212

Livrare imediată!

144,57Lei

OCHELARI POLARIZATI SAVAGE GEAR SHADES AMBER

OCHELARI POLARIZATI SAVAGE GEAR SHADES AMBER

svs57573

Livrare imediată!

146,40Lei

JACHETA SAVAGE HEATLITE THERMO MARIMEA XXL

JACHETA SAVAGE HEATLITE THERMO MARIMEA XXL

svs59128

Livrare 7-14 zile

500,25Lei

Vobler Savage Gear 3D Smash Tail, Roach, 10cm, 17g

Vobler Savage Gear 3D Smash Tail, Roach, 10cm, 17g

svs61993

Livrare imediată!

49,82Lei

SHAD SAVAGE LB 4D HERRING 11CM/9G/GOLDEN AMBULANCE 4BUC/PLIC

SHAD SAVAGE LB 4D HERRING 11CM/9G/GOLDEN AMBULANCE 4BUC/PLIC

f1.sg.63683

Livrare 24-48 ore

36,98Lei(-24%) 28,23Lei

Afişare 1021 - 1040 din 1522 (77 pagini)

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

1 (0.086)

SELECT data
FROM `oc_session`
WHERE session_id = '8b4a85c69e3f04e741123452a5'

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

2 (0.119)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.103)

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

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

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

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

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

7 (0.140)

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