Colmic

Colmic

Sortare după:

Lanseta COLMIC Jakal Telematch, 20-100g, 4.30m, 6seg

Lanseta COLMIC Jakal Telematch, 20-100g, 4.30m, 6seg

caja10d

Livrare 48-72 ore

369,00Lei

FIR COLMIC F1 SPIDER NX80 100M 0.229mm

FIR COLMIC F1 SPIDER NX80 100M 0.229mm

nysp229

Livrare 48-72 ore

36,59Lei

VOBLER COLMIC HERAKLES DOGO 110SP 11cm 19gr Alburno Flash

VOBLER COLMIC HERAKLES DOGO 110SP 11cm 19gr Alburno Flash

arhkdq10

Livrare 48-72 ore

83,90Lei(-27%) 60,98Lei

FIR COLMIC FORMER 150M 0.35mm

FIR COLMIC FORMER 150M 0.35mm

nyfo35

Livrare 48-72 ore

32,52Lei

VOBLER COLMIC HERAKLES RABID 130SP 13cm 21gr Alburno Chrome

VOBLER COLMIC HERAKLES RABID 130SP 13cm 21gr Alburno Chrome

arhkbm13

Livrare 48-72 ore

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

Fir Monofilament Colmic Axial, Portocaliu, 300m, 0.18mm

Fir Monofilament Colmic Axial, Portocaliu, 300m, 0.18mm

nyax18

Livrare 48-72 ore

30,00Lei(-25%) 22,35Lei

Creature Bait Herakles Hypervibe 8.9cm Bama Bug

Creature Bait Herakles Hypervibe 8.9cm Bama Bug

arhkdt09

Livrare 48-72 ore

39,91Lei(-36%) 25,71Lei

CARLIGE COLMIC NUCLEAR N1000 NR 22

CARLIGE COLMIC NUCLEAR N1000 NR 22

amll22

Livrare imediată!

19,30Lei

Fir fluorocarbon Colmic Herakles Area XF 0.110mm 30m

Fir fluorocarbon Colmic Herakles Area XF 0.110mm 30m

nyhkar111

Livrare 48-72 ore

79,19Lei

CARLIGE COLMIC NUCLEAR DK800 GOLD NR 08

CARLIGE COLMIC NUCLEAR DK800 GOLD NR 08

amq08

Livrare 48-72 ore

23,37Lei

Lanseta Colmic Sea Dream Boat 2.50m 250g

Lanseta Colmic Sea Dream Boat 2.50m 250g

casea14a

Livrare 48-72 ore

343,66Lei

CARLIGE COLMIC LEGATE N500 NR 4-0.20 70CM

CARLIGE COLMIC LEGATE N500 NR 4-0.20 70CM

al10420

Livrare imediată!

24,39Lei

Antene Pluta Colmic 3mm 70mm

Antene Pluta Colmic 3mm 70mm

ant3070

Livrare imediată!

18,30Lei

CARLIGE COLMIC LEGATE NK800 NR 12-0.16 70CM

CARLIGE COLMIC LEGATE NK800 NR 12-0.16 70CM

al41216

Livrare 48-72 ore

22,35Lei

Geanta Colmic Jaguar L

Geanta Colmic Jaguar L

boxeva308b

Livrare 48-72 ore

443,31Lei

PLUTA COLMIC MENTA GR 1.50

PLUTA COLMIC MENTA GR 1.50

gamengoa

Livrare 48-72 ore

14,22Lei

Protectie Rubesiana Colmic RBS PROTECTOR SERIA 01 11.5M

Protectie Rubesiana Colmic RBS PROTECTOR SERIA 01 11.5M

ccxp005

Livrare 48-72 ore

167,75Lei

WAGLER COLMIC SINFLEX IBERIA GR 10

WAGLER COLMIC SINFLEX IBERIA GR 10

gciv0210

Livrare 48-72 ore

22,35Lei

Lingura Oscilanta Colmic Herakles Leaf 0.9g Golden Trout

Lingura Oscilanta Colmic Herakles Leaf 0.9g Golden Trout

arhklea28

Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

PROSOP COLMIC 50x60cm

PROSOP COLMIC 50x60cm

ashb4060

Livrare 48-72 ore

93,53Lei

Afişare 821 - 840 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: 127.496 ms [By time] [By id] [By file]

1 (0.106)

SELECT data
FROM `oc_session`
WHERE session_id = '8dc9e9c21cf8ca76f0bc80f248'

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

2 (0.085)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.097)

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

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

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

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

7 (0.110)

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