Colmic

Colmic

Sortare după:

VARF COLMIC PRO FEEDER 1oz ORANGE

VARF COLMIC PRO FEEDER 1oz ORANGE

catip02b

Livrare 48-72 ore

50,82Lei

LINGURITA OSCILANTA COLMIC AMMER 2.5gr Black Chartreuse

LINGURITA OSCILANTA COLMIC AMMER 2.5gr Black Chartreuse

arhkamm32

Livrare 48-72 ore

26,32Lei

Plumbi COLMIC Sfera In-Line, 3.50g, 5buc/pac

Plumbi COLMIC Sfera In-Line, 3.50g, 5buc/pac

poleba06

Livrare 48-72 ore

24,39Lei

FIR COLMIC MIMETIX 50M 0.190mm

FIR COLMIC MIMETIX 50M 0.190mm

nymi190

Livrare 48-72 ore

30,90Lei

LINGURITA OSCILANTA COLMIC LDS 3.6gr Golden Trout

LINGURITA OSCILANTA COLMIC LDS 3.6gr Golden Trout

arhklds28

Livrare 48-72 ore

22,91Lei(-23%) 17,57Lei

Pluta COLMIC Doria Inline, 1.50g

Pluta COLMIC Doria Inline, 1.50g

gador150

Livrare 48-72 ore

16,25Lei

FIR COLMIC OKY 150M 0.16mm

FIR COLMIC OKY 150M 0.16mm

nyok016

Livrare 48-72 ore

12,69Lei

LINGURITA OSCILANTA COLMIC HERAKLES KEEPER TROUT 2.5gr Pink Brown

LINGURITA OSCILANTA COLMIC HERAKLES KEEPER TROUT 2.5gr Pink Brown

arhkfd25

Livrare 48-72 ore

19,40Lei(-27%) 14,12Lei

FIR COLMIC PROJECT 360 NX30 100M 0.40mm

FIR COLMIC PROJECT 360 NX30 100M 0.40mm

nypr10040

Livrare 48-72 ore

21,34Lei

VOBLER COLMIC HERAKLES FLATT JERK FUDE SS 12cm 21.4gr Sexy Chartreuse

VOBLER COLMIC HERAKLES FLATT JERK FUDE SS 12cm 21.4gr Sexy Chartreuse

arhkfud07

Livrare 48-72 ore

51,74Lei

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

Afişare 1301 - 1320 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: 124.336 ms [By time] [By id] [By file]

1 (0.074)

SELECT data
FROM `oc_session`
WHERE session_id = '544df6e8b0d99170ca224a2dd4'

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

2 (0.115)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.129)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.126)

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

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

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

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

7 (0.221)

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