Colmic


Fir Monofilament COLMIC Hunt, Green, 10.74kg, 0.30mm, 150m

Fir Monofilament COLMIC Hunt, Green, 10.74kg, 0.30mm, 150m

nyhun300
Livrare 48-72 ore

40,00Lei

VOBLER HERAKLES DEEP-J F 3.1mm 3.5gr Cherry Blood

VOBLER HERAKLES DEEP-J F 3.1mm 3.5gr Cherry Blood

arhkdee18
Livrare 48-72 ore

59,87Lei

Lanseta Bolognesa COLMIC Sonika 300, Up To 30g, 6.00m, 6seg

Lanseta Bolognesa COLMIC Sonika 300, Up To 30g, 6.00m, 6seg

caso03c
Livrare 48-72 ore

439,00Lei

Lanseta Bolognesa COLMIC Futura Z-4000, Up To 20g, 6.00m, 6seg

Lanseta Bolognesa COLMIC Futura Z-4000, Up To 20g, 6.00m, 6seg

cafu21b
Livrare 48-72 ore

811,99Lei

LINGURITA COLMIC HERAKLES OSCILANTA AMMER 3.5gr Clown

LINGURITA COLMIC HERAKLES OSCILANTA AMMER 3.5gr Clown

arhkamb60
Livrare 48-72 ore

26,32Lei

BORSETA COLMIC MULINETA EVA 20/30 -28%

BORSETA COLMIC MULINETA EVA 20/30

bo704
Livrare 48-72 ore

45,00Lei(-28%) 32,52Lei

Varga COLMIC Velox Speial Alborella Pole, 3.5m, 3seg

Varga COLMIC Velox Speial Alborella Pole, 3.5m, 3seg

cave91d
Livrare 48-72 ore

291,01Lei

SUPORT COLMIC FEEDER 12 POSTURI CU BLOCAJ

SUPORT COLMIC FEEDER 12 POSTURI CU BLOCAJ

ap00023a
Livrare 48-72 ore

142,34Lei

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 7.5cm 8.5gr FLASH GOLD -25%

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 7.5cm 8.5gr FLASH GOLD

arhkie01
Livrare 48-72 ore

37,90Lei(-25%) 28,25Lei

CAP SUPORT COLMIC LIONE HAIR ROD REST

CAP SUPORT COLMIC LIONE HAIR ROD REST

ap42
Livrare imediată!

24,39Lei

Cap Suport Feeder COLMIC Rod Rest Valencia

Cap Suport Feeder COLMIC Rod Rest Valencia

ap51
Livrare 48-72 ore

24,39Lei

Fir Monofilament COLMIC Hunt, Green, 2.94kg, 0.148mm, 150m

Fir Monofilament COLMIC Hunt, Green, 2.94kg, 0.148mm, 150m

nyhun148
Livrare 48-72 ore

28,00Lei

VOBLER COLMIC HERAKLES STUNT 90SP 9.0cm 12.5 g Green Tiger

VOBLER COLMIC HERAKLES STUNT 90SP 9.0cm 12.5 g Green Tiger

arhkdg04
Livrare imediată!

76,24Lei

TUB COLMIC SILICON HIGH-TECH ROSU 0.50mm

TUB COLMIC SILICON HIGH-TECH ROSU 0.50mm

silht02
Livrare 48-72 ore

32,52Lei

Mulineta Colmic Taslon FD 2000

Mulineta Colmic Taslon FD 2000

multas20
Livrare 48-72 ore

325,36Lei

CAP MINCIOG COLMIC RUBBER MATCH CAUCIUCAT 45x55cm

CAP MINCIOG COLMIC RUBBER MATCH CAUCIUCAT 45x55cm

guzh08a
Livrare 48-72 ore

130,14Lei

PLUMBI COLMIC OLIVETA SUPREME 6.00gr

PLUMBI COLMIC OLIVETA SUPREME 6.00gr

tos0600
Livrare 48-72 ore

23,37Lei

Lanseta Bolognesa COLMIC Fiume WR T-6000 Bolo, 5.00m, 20g, 5seg

Lanseta Bolognesa COLMIC Fiume WR T-6000 Bolo, 5.00m, 20g, 5seg

cafi101za
Livrare 48-72 ore

1.190,66Lei

Degetar Colmic

Degetar Colmic

salv01
Livrare 48-72 ore

51,84Lei

SUPORT COLMIC PRO 4 PICIOARE 9 POSTURI CU BLOCAJ

SUPORT COLMIC PRO 4 PICIOARE 9 POSTURI CU BLOCAJ

ap00018
Livrare 48-72 ore

438,23Lei

Afişare 101 - 120 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: 133.271 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '313319557db3f30e6e1dc7c781'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
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.093)
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 (61.230)
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 (71.571)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.107)
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