Colmic

Colmic

Sortare după:

FIR COLMIC HERAKLES XF FLUOROCARBON 70M 0.260mm

FIR COLMIC HERAKLES XF FLUOROCARBON 70M 0.260mm

nyhexf26

Livrare 48-72 ore

115,80Lei

SUPORT COLMIC EVA 6 POSTURI 36cm

SUPORT COLMIC EVA 6 POSTURI 36cm

ap00021

Livrare 48-72 ore

77,26Lei

Lanseta COLMIC Leopard F1, 2.40m, 150g, 2+2seg

Lanseta COLMIC Leopard F1, 2.40m, 150g, 2+2seg

caleo01c

Livrare 48-72 ore

468,73Lei

MOMITOR COLMIC OPEN PELLET FEEDER MEDIUM 30gr

MOMITOR COLMIC OPEN PELLET FEEDER MEDIUM 30gr

fed55a

Livrare imediată!

12,69Lei

Spinnerbait Colmic Herakles Flatter Tandem 7g Killer Ayu

Spinnerbait Colmic Herakles Flatter Tandem 7g Killer Ayu

arhkis07

Livrare 48-72 ore

36,91Lei(-25%) 27,54Lei

Plumbi COLMIC Picatura In-Line, 12.00g, 4buc/pac

Plumbi COLMIC Picatura In-Line, 12.00g, 4buc/pac

poledr19

Livrare 48-72 ore

28,45Lei

FIR COLMIC XILO 50M 0.165mm

FIR COLMIC XILO 50M 0.165mm

nyxi165

Livrare 48-72 ore

28,45Lei

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Chartreuse Orange Gold

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Chartreuse Orange Gold

arhkcle38

Livrare imediată!

12,08Lei

Pluta COLMIC Apollo Inline 4.00g

Pluta COLMIC Apollo Inline 4.00g

gaapo400

Livrare 48-72 ore

16,25Lei

FIR COLMIC FLUOROCARBON ZAYO 50M 0.255mm

FIR COLMIC FLUOROCARBON ZAYO 50M 0.255mm

nyza25

Livrare 48-72 ore

87,43Lei

LINGURITA OSCILANTA COLMIC SPIKE 1.0gr Chartreuse Orange Gold

LINGURITA OSCILANTA COLMIC SPIKE 1.0gr Chartreuse Orange Gold

arhkspi38

Livrare 48-72 ore

25,30Lei

Pluta COLMIC Zeus Inline, 3.00g

Pluta COLMIC Zeus Inline, 3.00g

gazeu300

Livrare 48-72 ore

16,25Lei

FIR COLMIC ATOMIC 500M 0.20mm

FIR COLMIC ATOMIC 500M 0.20mm

nyat620

Livrare 48-72 ore

25,40Lei

CICADA COLMIC HERAKLES METAL FIRE 5.2CM 12GR Blue Back Chartreuse

CICADA COLMIC HERAKLES METAL FIRE 5.2CM 12GR Blue Back Chartreuse

jhkai03

Livrare 48-72 ore

36,49Lei

Cap Minciog Head COLMIC Gumma Carp, 50x40cm

Cap Minciog Head COLMIC Gumma Carp, 50x40cm

gukgum07a

Livrare 48-72 ore

185,00Lei

FIR COLMIC STEEL RESISTANCE NX80 150M 0.22mm

FIR COLMIC STEEL RESISTANCE NX80 150M 0.22mm

nyst15022

Livrare imediată!

44,72Lei

VOBLER COLMIC HERAKLES STRIKE 90SK 9cm 11gr Rainbow

VOBLER COLMIC HERAKLES STRIKE 90SK 9cm 11gr Rainbow

arhkbl03

Livrare 48-72 ore

50,72Lei

FIR COLMIC METHOD FEEDER 250M 0.25mm

FIR COLMIC METHOD FEEDER 250M 0.25mm

nyme025

Livrare 48-72 ore

36,59Lei

VOBLER COLMIC HERAKLES LIP 95S 9.5cm 12gr Sardina Chartreuse

VOBLER COLMIC HERAKLES LIP 95S 9.5cm 12gr Sardina Chartreuse

arhkat07

Livrare 48-72 ore

46,90Lei(-26%) 34,65Lei

FIR COLMIC FENDREEL POWER 200M 0.35mm

FIR COLMIC FENDREEL POWER 200M 0.35mm

nypo35

Livrare 48-72 ore

28,00Lei(-25%) 20,93Lei

Afişare 281 - 300 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: 135.373 ms [By time] [By id] [By file]

1 (0.165)

SELECT data
FROM `oc_session`
WHERE session_id = '980007b981ad180dfc242d6e98'

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

2 (0.165)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.134)

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

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

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

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

7 (0.197)

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