Colmic

Colmic

Sortare după:

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Golden Trout

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Golden Trout

arhkcle28

Livrare imediată!

12,08Lei

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 Spotted Brown

LINGURITA OSCILANTA COLMIC SPIKE 1.0gr Spotted Brown

arhkspi26

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 Silver Red

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 2.5gr Silver Red

arhklm16

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 Smoke Gold

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Smoke Gold

arhkbi06

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

POPPER COLMIC HERAKLES POP-EY 7cm 9.5gr Bandit

POPPER COLMIC HERAKLES POP-EY 7cm 9.5gr Bandit

arherak07e

Livrare 48-72 ore

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

FIR COLMIC X-5000 150M 0.16mm

FIR COLMIC X-5000 150M 0.16mm

nyx516

Livrare imediată!

38,62Lei

SHAD COLMIC HERAKLES ISPANIC 11.4cm Baby Bass Special

SHAD COLMIC HERAKLES ISPANIC 11.4cm Baby Bass Special

arhkisp02

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 LIGHT MOTOROIL

Grub Colmic Herakles Viber 6.2cm LIGHT MOTOROIL

arhklq03

Livrare 48-72 ore

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

CARLIGE COLMIC NUCLEAR N900 NR 18

CARLIGE COLMIC NUCLEAR N900 NR 18

aml18

Livrare imediată!

21,84Lei

Role Colmic EVA pentru monturi 9cm

Role Colmic EVA pentru monturi 9cm

eva05

Livrare imediată!

6,07Lei

CARLIGE COLMIC NUCLEAR MR200 NR 4

CARLIGE COLMIC NUCLEAR MR200 NR 4

am0504

Livrare 48-72 ore

19,81Lei

Mulineta Colmic Amunk FD 4500

Mulineta Colmic Amunk FD 4500

mulamu45

Livrare 48-72 ore

614,14Lei

Afişare 1081 - 1100 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: 134.886 ms [By time] [By id] [By file]

1 (0.130)

SELECT data
FROM `oc_session`
WHERE session_id = 'aff0009167367fda5385cee097'

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

2 (0.086)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.137)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.132)

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

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

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

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

7 (0.152)

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