Colmic


LANSETA COLMIC GHEMON YOUNG 2.70M 300GR

LANSETA COLMIC GHEMON YOUNG 2.70M 300GR

cagh60b
Livrare 48-72 ore

657,86Lei

Lanseta Bolognesa Colmic Arkana, 6m, 25g, 6seg

Lanseta Bolognesa Colmic Arkana, 6m, 25g, 6seg

caar80b
Livrare imediată!

915,11Lei

FIR FEEDER COLMIC PRO AT70 250M 0.188MM

FIR FEEDER COLMIC PRO AT70 250M 0.188MM

nyfep0188
Livrare 48-72 ore

43,71Lei

FIR TEXTIL COLMIC WEPER X8 GREY 40lbs 150yds 137m 0.25mm

FIR TEXTIL COLMIC WEPER X8 GREY 40lbs 150yds 137m 0.25mm

nywex8240
Livrare 48-72 ore

130,14Lei

Mulineta Colmic Ispanic FD 1000

Mulineta Colmic Ispanic FD 1000

mulisp10
Livrare 48-72 ore

305,03Lei

FIR COLMIC YELLOW DRAGON 600M 20LB 0.40mm

FIR COLMIC YELLOW DRAGON 600M 20LB 0.40mm

nyyd20
Livrare 48-72 ore

106,75Lei

LIGHEAN COLMIC NADA 13 L

LIGHEAN COLMIC NADA 13 L

sec11a
Livrare 48-72 ore

71,16Lei

Lanseta COLMIC Joker Boat 2.70m, 150g, 2seg

Lanseta COLMIC Joker Boat 2.70m, 150g, 2seg

cajo01c
Livrare 48-72 ore

233,84Lei

LANSETA COLMIC VOYAGER SUPREME 3 sec. 7' 3/16-5/8 Medium

LANSETA COLMIC VOYAGER SUPREME 3 sec. 7' 3/16-5/8 Medium

cahkvs01
Livrare 48-72 ore

641,49Lei

SUPORT COLMIC MATCH 4 PICIOARE 12 POSTURI

SUPORT COLMIC MATCH 4 PICIOARE 12 POSTURI

ap00011
Livrare 48-72 ore

707,68Lei

Matrita COLMIC Method Feeder TPC, Blue, Marime S

Matrita COLMIC Method Feeder TPC, Blue, Marime S

fed00s
Livrare 48-72 ore

28,45Lei

MOMITOR COLMIC METHOD FEEDER IN-LINE 30gr

MOMITOR COLMIC METHOD FEEDER IN-LINE 30gr

fed40b
Livrare 48-72 ore

26,41Lei

Lingura oscilanta Colmic Herakles Monster Keeper 45g Hot Tiger

Lingura oscilanta Colmic Herakles Monster Keeper 45g Hot Tiger

arhklz09
Livrare 48-72 ore

48,69Lei

Plumbi COLMIC Picatura In-Line, 18.00g, 3buc/pac

Plumbi COLMIC Picatura In-Line, 18.00g, 3buc/pac

poledr22
Livrare 48-72 ore

28,45Lei

FIR COLMIC MIMETIX 50M 0.064mm

FIR COLMIC MIMETIX 50M 0.064mm

nymi064
Livrare 48-72 ore

31,50Lei

LINGURITA OSCILANTA COLMIC HIVE 2.4gr Golden Trout -23%

LINGURITA OSCILANTA COLMIC HIVE 2.4gr Golden Trout

arhkhiv28
Livrare 48-72 ore

20,90Lei(-23%) 16,15Lei

Pluta COLMIC Bismark Inline, 1.50g

Pluta COLMIC Bismark Inline, 1.50g

gabism150
Livrare 48-72 ore

16,25Lei

FIR COLMIC FLUOROCARBON ZAYO 50M 0.36mm

FIR COLMIC FLUOROCARBON ZAYO 50M 0.36mm

nyza36
Livrare 48-72 ore

96,58Lei

LINGURITA OSCILANTA COLMIC HERAKLES VENTO GOLD 3.5gr Chartreuse Orange Gold -28%

LINGURITA OSCILANTA COLMIC HERAKLES VENTO GOLD 3.5gr Chartreuse Orange Gold

arhkven38
Livrare 48-72 ore

21,90Lei(-28%) 15,85Lei

Pluta COLMIC Zeus Inline, 6.00g

Pluta COLMIC Zeus Inline, 6.00g

gazeu600
Livrare 48-72 ore

16,25Lei

Afişare 681 - 700 din 2613 (131 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 148.611 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '8e9971e7dc9b676b90b0e599d1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.087)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '115' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (57.320)
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 = '115'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (90.792)
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 = '115' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 680,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