Colmic


FIR COLMIC IRIDE PT50 300M 0.22mm Orange Fluo

FIR COLMIC IRIDE PT50 300M 0.22mm Orange Fluo

nyir022
Livrare 48-72 ore

46,75Lei

VOBLER COLMIC HERAKLES MOTH TROUT AREA F 3.7cm 2.2gr Crawler -26%

VOBLER COLMIC HERAKLES MOTH TROUT AREA F 3.7cm 2.2gr Crawler

arhkmot08
Livrare 48-72 ore

53,91Lei(-26%) 39,64Lei

FIR COLMIC X-5000 150M 0.12mm

FIR COLMIC X-5000 150M 0.12mm

nyx512
Livrare imediată!

35,57Lei

CAVE CRAW COLMIC HERAKLES 9.6cm Sumer Craw -24%

CAVE CRAW COLMIC HERAKLES 9.6cm Sumer Craw

arhkcav09
Livrare 48-72 ore

27,90Lei(-24%) 21,13Lei

CARLIGE COLMIC NUCLEAR N500 NR 12

CARLIGE COLMIC NUCLEAR N500 NR 12

amh12
Livrare 48-72 ore

18,30Lei

Grub Colmic Herakles Viber 6.2cm Live Pellet -27%

Grub Colmic Herakles Viber 6.2cm Live Pellet

arhklq01
Livrare 48-72 ore

11,89Lei(-27%) 8,63Lei

CARLIGE COLMIC NUCLEAR N900 NR 14

CARLIGE COLMIC NUCLEAR N900 NR 14

aml14
Livrare imediată!

21,84Lei

ROLE COLMIC EVA DIAMETRU 6CM

ROLE COLMIC EVA DIAMETRU 6CM

eva03
Livrare imediată!

4,05Lei

CARLIGE COLMIC NUCLEAR MR66 NR 6

CARLIGE COLMIC NUCLEAR MR66 NR 6

am0360
Livrare 48-72 ore

28,96Lei

Mulineta Colmic VRZ FD 3500 -24%

Mulineta Colmic VRZ FD 3500

mulvrz35
Livrare 48-72 ore

370,01Lei(-24%) 282,66Lei

CARLIGE COLMIC LEGATE N600 NR 10-0.18 70CM

CARLIGE COLMIC LEGATE N600 NR 10-0.18 70CM

al21018
Livrare 48-72 ore

22,35Lei

Ochelari Polarizati Colmic Cruna Sea

Ochelari Polarizati Colmic Cruna Sea

sun04
Livrare 48-72 ore

168,77Lei

PLUTA COLMIC EDY GR 2.50

PLUTA COLMIC EDY GR 2.50

gaedyra
Livrare 48-72 ore

12,18Lei

Bac Colmic Micro Magic Net 140mm

Bac Colmic Micro Magic Net 140mm

sc100c
Livrare 48-72 ore

54,89Lei

PLUTA COLMIC ROVEZZANO GR 3.00

PLUTA COLMIC ROVEZZANO GR 3.00

garovsa
Livrare 48-72 ore

14,22Lei

Lanseta Colmic Herakles Kiar Reef 2.30m 15 45g -22%

Lanseta Colmic Herakles Kiar Reef 2.30m 15 45g

cahkkr04
Livrare imediată!

910,00Lei(-22%) 712,67Lei

HUSA COLMIC LANSETE BOLO 004 RED SERIES 170x50x13cm

HUSA COLMIC LANSETE BOLO 004 RED SERIES 170x50x13cm

pr213c
Livrare 48-72 ore

580,58Lei

Lingura Oscilanta Colmic Herakles Sbam 1.3g Pink Pellet

Lingura Oscilanta Colmic Herakles Sbam 1.3g Pink Pellet

arhksba36
Livrare 48-72 ore

23,27Lei

DEGORJOR COLMIC EURO MEDIU

DEGORJOR COLMIC EURO MEDIU

sla02
Livrare imediată!

10,15Lei

Lingura Oscilanta Colmic Herakles Ruck Spoon 2g Orange Gold -22%

Lingura Oscilanta Colmic Herakles Ruck Spoon 2g Orange Gold

arhkfe30
Livrare 48-72 ore

17,90Lei(-22%) 14,02Lei

Afişare 1841 - 1860 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: 127.857 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = 'ca653c4bace5955b46c90cf9ef'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.094)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
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 (46.016)
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 (81.334)
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 1840,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.112)
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