Korda


PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

a.kpb41
Livrare imediată!

18,54Lei

Plumb Tungsten Korda Dark Matter Balancing 0.50g

Plumb Tungsten Korda Dark Matter Balancing 0.50g

a.kdmw06
Livrare 24-48 ore

32,30Lei

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.S

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.S

a8.kcl424
Livrare 24-48 ore

632,16Lei

SAPCA KORDA KORE FLEECE WATERPROOF OLIVE

SAPCA KORDA KORE FLEECE WATERPROOF OLIVE

a8.kbc20
Livrare imediată!

106,48Lei

Tricou Korda Tie Dye Slate Grey, Marime M

Tricou Korda Tie Dye Slate Grey, Marime M

a8.kcl497
Livrare 24-48 ore

138,88Lei

Tricou, Korda, Outline, Tee, Black,, Marime, XL, a8.kcl746, Tricouri, Tricouri Korda, Tricouri Korda, Korda
MONOFILAMENT, KORDA, LONGCHUCK, 0.27-0.47MM,, 300M,, 4.5-13.6KG, a.kdcm08, Fire Monofilament Inaintas, Fire Monofilament Inaintas Korda, Korda
GEANTA KORDA COMPAC GOO MAR.S

GEANTA KORDA COMPAC GOO MAR.S

a8.klug42
Livrare 24-48 ore

111,11Lei

HANORAC KORDA LE LIGHTWEIGHT LIGHT KAMO MAR.XXL -23%

HANORAC KORDA LE LIGHTWEIGHT LIGHT KAMO MAR.XXL

a8.kcl374
Livrare imediată!

301,82Lei(-23%) 232,89Lei

Montura cu Vartej si Anou Korda Kable Ring Swivel, Gravel Brown, 50cm

Montura cu Vartej si Anou Korda Kable Ring Swivel, Gravel Brown, 50cm

a.kll003
Livrare 24-48 ore

37,00Lei

Tub Termocontractabil Select Baits Shrink Tube 1.5mm, 5cm, 10buc/pac

Tub Termocontractabil Select Baits Shrink Tube 1.5mm, 5cm, 10buc/pac

sel-217993
Livrare imediată!

6,00Lei

Palarie Korda Digi Camo

Palarie Korda Digi Camo

a8.kbh17
Livrare imediată!

83,34Lei

ATRACTANT KORDA RED ENERGY SUPREME 115ML

ATRACTANT KORDA RED ENERGY SUPREME 115ML

a0.goo40
Livrare imediată!

95,58Lei

KORDA GEANTA COMPAC MARIME S -23%

KORDA GEANTA COMPAC MARIME S

a8.klug29
Livrare imediată!

394,76Lei(-23%) 303,90Lei

GEANTA KORDA COMPAC DRY MARIME S

GEANTA KORDA COMPAC DRY MARIME S

a8.klug56
Livrare 24-48 ore

157,43Lei

VESTA KORDA KORE FLEECE OLIVE MAR.M

VESTA KORDA KORE FLEECE OLIVE MAR.M

a8.kcl595
Livrare 24-48 ore

209,11Lei

PANTALON KORDA LITE JOGGER OLIVE MAR.XXL -18%

PANTALON KORDA LITE JOGGER OLIVE MAR.XXL

a8.kcl434
Livrare imediată!

232,30Lei(-18%) 189,90Lei

ATRACTANT KORDA GOO DRAGON S BREATH SUPREME 115ML

ATRACTANT KORDA GOO DRAGON S BREATH SUPREME 115ML

a0.goo46
Livrare imediată!

103,31Lei

Ochelari, Korda, Ronnie, Black, a8.k4d19, Ochelari Polarizati, Ochelari Polarizati Korda, Ochelari Korda, Polarizati Korda, Korda
MONTURA KORDA N-TRAP DF WIDE GAPE B NR.6/15LB

MONTURA KORDA N-TRAP DF WIDE GAPE B NR.6/15LB

a.kcr035
Livrare imediată!

15,29Lei

Afişare 1 - 20 din 704 (36 pagini)
Queries: 7, Total time: 71.843 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = 'b88ce651714254f5c7a74cc276'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.146)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '73' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (31.337)
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 = '0' AND p.manufacturer_id = '73'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (39.831)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '0' AND p.manufacturer_id = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.135)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38