Colmic

Colmic

Sortare după:

FIR COLMIC METHOD FEEDER 250M 0.16mm

FIR COLMIC METHOD FEEDER 250M 0.16mm

nyme016

Livrare imediată!

31,00Lei(-15%) 26,32Lei

POPPER COLMIC HERAKLES POP-EY 7cm 9.5gr Baby Bass

POPPER COLMIC HERAKLES POP-EY 7cm 9.5gr Baby Bass

arherak07g

Livrare 48-72 ore

40,90Lei(-26%) 30,40Lei

FIR COLMIC X-5000 150M 0.20mm

FIR COLMIC X-5000 150M 0.20mm

nyx520

Livrare 48-72 ore

38,62Lei

SHAD COLMIC HERAKLES ISPANIC 11.4cm Blue Shad

SHAD COLMIC HERAKLES ISPANIC 11.4cm Blue Shad

arhkisp29

Livrare 48-72 ore

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

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 16

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 16

amhw26

Livrare 48-72 ore

15,25Lei

Grub Colmic Herakles Viber 6.2cm WHITE

Grub Colmic Herakles Viber 6.2cm WHITE

arhklq06

Livrare 48-72 ore

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

CARLIGE COLMIC NUCLEAR N957 NR 18

CARLIGE COLMIC NUCLEAR N957 NR 18

amm18

Livrare imediată!

14,00Lei(-22%) 10,96Lei

SHAD COLMIC HERAKLES T-SHAD CHARTREUSE BLOODY 12CM 2BUCATI/PLIC

SHAD COLMIC HERAKLES T-SHAD CHARTREUSE BLOODY 12CM 2BUCATI/PLIC

arhkbb05

Livrare imediată!

35,47Lei

CARLIGE COLMIC NUCLEAR MR200 NR 8

CARLIGE COLMIC NUCLEAR MR200 NR 8

am0508

Livrare 48-72 ore

17,77Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.128mm 50m

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.128mm 50m

nysc128

Livrare 48-72 ore

106,75Lei

CARLIGE COLMIC LEGATE N957 NR 12-0.14 70CM

CARLIGE COLMIC LEGATE N957 NR 12-0.14 70CM

al31214

Livrare 48-72 ore

22,35Lei

Geanta Colmic Superior Class Lisabona XL

Geanta Colmic Superior Class Lisabona XL

bo1001d

Livrare 48-72 ore

333,50Lei

PLUTA COLMIC EDY GR 6.0

PLUTA COLMIC EDY GR 6.0

gaedyva

Livrare 48-72 ore

12,69Lei

Galeata Colmic Official Team 25L

Galeata Colmic Official Team 25L

sec31a

Livrare 48-72 ore

90,48Lei

PLUTA COLMIC SENNA INLINE GR 4x18

PLUTA COLMIC SENNA INLINE GR 4x18

gasenkb

Livrare imediată!

11,68Lei

Lanseta Colmic Herakles Black Weapon Revenge Spin 2.05m

Lanseta Colmic Herakles Black Weapon Revenge Spin 2.05m

cahkbwr03

Livrare 48-72 ore

917,03Lei

HUSA COLMIC LANSETE SCOGLIERA SERIA RED 160cm

HUSA COLMIC LANSETE SCOGLIERA SERIA RED 160cm

pr208

Livrare 48-72 ore

514,49Lei

Lingura Oscilanta Colmic Herakles Sbam 2.3g Viola Glow

Lingura Oscilanta Colmic Herakles Sbam 2.3g Viola Glow

arhksbb47

Livrare 48-72 ore

26,32Lei

ANTENA COLMIC PLUTE 1.5mm

ANTENA COLMIC PLUTE 1.5mm

ant1555

Livrare imediată!

13,71Lei

Lingura Oscilanta Colmic Herakles Hive 2.4g Salamon

Lingura Oscilanta Colmic Herakles Hive 2.4g Salamon

arhkhiv49

Livrare 48-72 ore

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

Afişare 1401 - 1420 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: 122.959 ms [By time] [By id] [By file]

1 (0.070)

SELECT data
FROM `oc_session`
WHERE session_id = '3d5198d4ec9ad96b0564c846c3'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.072)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.098)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.152)

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.505)

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 (75.934)

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 1400,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.128)

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