Korda


OPRITOR TIP CAPSA PENTRU BOILIES KORDA FLOSS CAPS, 20BUC/PLIC ALB/ROSU

OPRITOR TIP CAPSA PENTRU BOILIES KORDA FLOSS CAPS, 20BUC/PLIC ALB/ROSU

a.kflc2
Livrare 24-48 ore

13,90Lei

Carlige Korda Kamakura Wide Gape Nr 6 10buc/cutie

Carlige Korda Kamakura Wide Gape Nr 6 10buc/cutie

k.kam02
Livrare imediată!

41,78Lei

FIR TEXTIL KORDA SUB BRAID SINKING 0.30mm 15LBS/450M

FIR TEXTIL KORDA SUB BRAID SINKING 0.30mm 15LBS/450M

a.sbb1
Livrare 24-48 ore

255,35Lei

Carlige Korda Kamakura Wide Gape X Nr 8 10buc/cutie

Carlige Korda Kamakura Wide Gape X Nr 8 10buc/cutie

k.kam28
Livrare imediată!

41,77Lei

TUB, CONIC, KORDA, HYBRID, TAIL, RUBBER, 10BUC/PLIC, Gravel/Clay, a.khrcg, Conuri Antitangle, Conuri Antitangle Korda, Korda
CUTIE KORDA ACCESORII TACKLE BOX BUNDLE DEAL

CUTIE KORDA ACCESORII TACKLE BOX BUNDLE DEAL

a4.kbox16
Livrare imediată!

371,53Lei

Porumb, Artificial, Korda, Pop-Up, Citrus, Zing, Orange, 12buc/plic, a.kpb44, Porumb Artificial, Porumb Artificial Korda, Porumb Korda, Artificial Korda, Korda
Vartej Rapid cu Anou Korda Spinner Ring XX, Nr.11, 10buc/pac

Vartej Rapid cu Anou Korda Spinner Ring XX, Nr.11, 10buc/pac

a.kmw011
Livrare 24-48 ore

23,11Lei

CLIPS PLUMB PIERDUT KORDA 10 BUC CLAY

CLIPS PLUMB PIERDUT KORDA 10 BUC CLAY

a.kqrcg
Livrare imediată!

25,51Lei

ANOU LINK LOOP KORDA 15BUC/PL

ANOU LINK LOOP KORDA 15BUC/PL

a.khll
Livrare 24-48 ore

26,12Lei

PLUMB KORDA DISTANCE CU VARTEJ 112G

PLUMB KORDA DISTANCE CU VARTEJ 112G

a3.kdcs4
Livrare 24-48 ore

11,50Lei

Carlige KORDA WIDE GAPE X NR.2 10BUC/PLIC

Carlige KORDA WIDE GAPE X NR.2 10BUC/PLIC

k.kwgx2
Livrare 24-48 ore

30,15Lei

OPRITOR KORDA CAUCIUC 20BUC/PL

OPRITOR KORDA CAUCIUC 20BUC/PL

a.khb
Livrare imediată!

17,14Lei

KIT PLASA SOLUBILA PVA KORDA NEW BOILIE FUNNEL WEB SYSTEM 7M

KIT PLASA SOLUBILA PVA KORDA NEW BOILIE FUNNEL WEB SYSTEM 7M

a.kbfw
Livrare imediată!

65,01Lei

Carlige Korda Kurv Shank Barbless Nr6 10buc/plic

Carlige Korda Kurv Shank Barbless Nr6 10buc/plic

k.kksb6
Livrare imediată!

30,15Lei

Riguri Korda Loops Krank Micro-Barbed Nr4 18lbs 3buc/blister

Riguri Korda Loops Krank Micro-Barbed Nr4 18lbs 3buc/blister

a.kcr114
Livrare imediată!

25,51Lei

Montura Korda Hinge Rig Barbed, Nr.4, 20lbs, 1buc/blister

Montura Korda Hinge Rig Barbed, Nr.4, 20lbs, 1buc/blister

a.kcr088
Livrare imediată!

17,15Lei

Kit Korda Plumb Culisant Flying Back Leads 5buc/blister + 5 Rubber Beads 3g

Kit Korda Plumb Culisant Flying Back Leads 5buc/blister + 5 Rubber Beads 3g

a3.kfb1
Livrare 24-48 ore

39,45Lei

Fir, Monofilament, Korda, Basix, Mainline, 0.35mm,, 12lb,, 1000m, a.kbx044, Fire Monofilament Crap, Fire Monofilament Crap Korda, Korda -23%
TRICOU KORDA LE MANDALA TEE BLACK MARIME XXL -0%

TRICOU KORDA LE MANDALA TEE BLACK MARIME XXL

a8.kcl699
Livrare imediată!

130,10Lei(-0%) 130,07Lei

Afişare 381 - 400 din 706 (36 pagini)
Queries: 7, Total time: 88.822 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = '05a10e8ff8595d16b8db412798'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.142)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.134)
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.390)
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 (56.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 380,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.122)
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