Colmic

Colmic

Sortare după:

LINGURITA OSCILANTA COLMIC HIVE 2.4gr Chartreuse Impact

LINGURITA OSCILANTA COLMIC HIVE 2.4gr Chartreuse Impact

arhkhiv34

Livrare 48-72 ore

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

Pluta COLMIC Bismark Inline, 4.00g

Pluta COLMIC Bismark Inline, 4.00g

gabism400

Livrare 48-72 ore

16,25Lei

FIR COLMIC FLUOROCARBON ZAYO 50M 0.47mm

FIR COLMIC FLUOROCARBON ZAYO 50M 0.47mm

nyza47

Livrare 48-72 ore

119,97Lei

LINGURITA OSCILANTA COLMIC HERAKLES DRIBBLE SPOON 2.5gr Pink Brown

LINGURITA OSCILANTA COLMIC HERAKLES DRIBBLE SPOON 2.5gr Pink Brown

arhkiq25

Livrare 48-72 ore

17,90Lei(-26%) 13,20Lei

Agrafa Costlock cu Vartej COLMIC Seria Orange, Nr.2, 22kg, 6buc/pac

Agrafa Costlock cu Vartej COLMIC Seria Orange, Nr.2, 22kg, 6buc/pac

gmg01002

Livrare 48-72 ore

37,61Lei

FIR COLMIC ATOMIC 500M 0.45mm

FIR COLMIC ATOMIC 500M 0.45mm

nyat645

Livrare 48-72 ore

44,72Lei

POPPER COLMIC HERAKLES SKYWALK 13cm 27.5gr Herakles Shiner

POPPER COLMIC HERAKLES SKYWALK 13cm 27.5gr Herakles Shiner

arhklv06

Livrare 48-72 ore

60,89Lei

FIR COLMIC F1 SPIDER NX80 100M 0.116mm

FIR COLMIC F1 SPIDER NX80 100M 0.116mm

nysp116

Livrare 48-72 ore

27,44Lei

VOBLER COLMIC HERAKLES JEKO 125SS 12.5cm 16.8gr Pink Head

VOBLER COLMIC HERAKLES JEKO 125SS 12.5cm 16.8gr Pink Head

arhkin04

Livrare 48-72 ore

60,90Lei(-27%) 44,62Lei

FIR COLMIC ARWEN MATCH SINNKING 150M 0.20mm

FIR COLMIC ARWEN MATCH SINNKING 150M 0.20mm

nying20

Livrare 48-72 ore

28,45Lei

VOBLER COLMIC HERAKLES RABID 130SP 13cm 21gr Clown

VOBLER COLMIC HERAKLES RABID 130SP 13cm 21gr Clown

arhkbm07

Livrare 48-72 ore

58,90Lei(-27%) 43,20Lei

FIR COLMIC FENDREEL 150M 0.185mm

FIR COLMIC FENDREEL 150M 0.185mm

nyfe18

Livrare imediată!

44,72Lei

CREATURE BAIT COLMIC HERAKLES VIBER CRAW 8.9cm BAMA BUG

CREATURE BAIT COLMIC HERAKLES VIBER CRAW 8.9cm BAMA BUG

arhkcg10

Livrare 48-72 ore

42,89Lei(-36%) 27,54Lei

CARLIGE COLMIC NUCLEAR N1000 NR 8

CARLIGE COLMIC NUCLEAR N1000 NR 8

amll08

Livrare 48-72 ore

18,79Lei

SHAD COLMIC HERAKLES BENJO SHAD XX 14.5cm Firetiger

SHAD COLMIC HERAKLES BENJO SHAD XX 14.5cm Firetiger

arhkbxx04

Livrare 48-72 ore

11,07Lei

CARLIGE COLMIC NUCLEAR NK800 NICKEL NR 10

CARLIGE COLMIC NUCLEAR NK800 NICKEL NR 10

amo10

Livrare 48-72 ore

18,30Lei

Lanseta Colmic Sanset Tele Boat 2.40m 50 150g

Lanseta Colmic Sanset Tele Boat 2.40m 50 150g

casa80b

Livrare imediată!

199,27Lei

CARLIGE COLMIC NUCLEAR MR300 NR 16

CARLIGE COLMIC NUCLEAR MR300 NR 16

am0616

Livrare 48-72 ore

25,40Lei

Fir Fluorocarbon Colmic Seaguar Secol Match 0.128mm 50m

Fir Fluorocarbon Colmic Seaguar Secol Match 0.128mm 50m

nyscm12

Livrare 48-72 ore

104,71Lei

CARLIGE COLMIC LEGATE NK800 NR 8-0.18 70CM

CARLIGE COLMIC LEGATE NK800 NR 8-0.18 70CM

al40818

Livrare 48-72 ore

22,35Lei

Afişare 301 - 320 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: 136.616 ms [By time] [By id] [By file]

1 (0.195)

SELECT data
FROM `oc_session`
WHERE session_id = '082faaeff386cb1ec41fa1bf5d'

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

2 (0.094)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.121)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.125)

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

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

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

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

7 (0.102)

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