Colmic


Pluta COLMIC Apollo Inline 0.50g

Pluta COLMIC Apollo Inline 0.50g

gaapo050
Livrare 48-72 ore

16,25Lei

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.16mm

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.16mm

nysh16
Livrare 48-72 ore

56,92Lei

LINGURITA OSCILANTA COLMIC SPIKE 1.0gr Silver Red

LINGURITA OSCILANTA COLMIC SPIKE 1.0gr Silver Red

arhkspi16
Livrare 48-72 ore

25,30Lei

Pluta COLMIC Pescara, 1.50g

Pluta COLMIC Pescara, 1.50g

gapes015
Livrare 48-72 ore

8,63Lei

FIR COLMIC ATOMIC 100M 0.30mm

FIR COLMIC ATOMIC 100M 0.30mm

nyat030
Livrare imediată!

11,68Lei

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr Black Orange -23%

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr Black Orange

arhklm15
Livrare 48-72 ore

22,91Lei(-23%) 17,57Lei

FIR COLMIC ALL ROUND NX50 150M 0.350mm

FIR COLMIC ALL ROUND NX50 150M 0.350mm

nyal150350
Livrare 48-72 ore

38,62Lei

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Herakles Magic

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Herakles Magic

arhkbi05
Livrare 48-72 ore

50,72Lei

Umbrela Cort COLMIC Beach, 250m

Umbrela Cort COLMIC Beach, 250m

omh14b
Livrare 48-72 ore

729,00Lei

FIR COLMIC FEEDER PRO AT70 250M 0.300mm

FIR COLMIC FEEDER PRO AT70 250M 0.300mm

nyfep0300
Livrare imediată!

67,09Lei

VOBLER COLMIC HERAKLES ASTRO F 9.5cm 16gr Black Louis -25%

VOBLER COLMIC HERAKLES ASTRO F 9.5cm 16gr Black Louis

arhkaa10
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

FIR COLMIC X-5000 150M 0.16mm

FIR COLMIC X-5000 150M 0.16mm

nyx516
Livrare imediată!

38,62Lei

CAVE CRAW COLMIC HERAKLES 9.6cm Green Pumpkin Purple Flk -23%

CAVE CRAW COLMIC HERAKLES 9.6cm Green Pumpkin Purple Flk

arhkcav26
Livrare 48-72 ore

23,90Lei(-23%) 18,30Lei

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 12

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 12

amhw22
Livrare 48-72 ore

15,25Lei

Grub Colmic Herakles Viber 6.2cm ORANGE GOLD FLK -27%

Grub Colmic Herakles Viber 6.2cm ORANGE GOLD FLK

arhklq02
Livrare 48-72 ore

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

CARLIGE COLMIC NUCLEAR N900 NR 16

CARLIGE COLMIC NUCLEAR N900 NR 16

aml16
Livrare imediată!

21,84Lei

Role Colmic EVA pentru monturi 7cm

Role Colmic EVA pentru monturi 7cm

eva04
Livrare imediată!

5,07Lei

CARLIGE COLMIC NUCLEAR MR66 NR 8

CARLIGE COLMIC NUCLEAR MR66 NR 8

am0380
Livrare 48-72 ore

28,45Lei

Mulineta Colmic Amunk FD 3500

Mulineta Colmic Amunk FD 3500

mulamu35
Livrare 48-72 ore

603,97Lei

CARLIGE COLMIC LEGATE N600 NR 14-0.16 70CM

CARLIGE COLMIC LEGATE N600 NR 14-0.16 70CM

al21416
Livrare 48-72 ore

22,35Lei

Afişare 141 - 160 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.161 ms [By time] [By id] [By file]
1 (0.199)
SELECT data
FROM `oc_session`
WHERE session_id = '313319557db3f30e6e1dc7c781'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.142)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.147)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'
/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 = '115' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (61.151)
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.244)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.144)
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