Colmic


LINGURITA OSCILANTA COLMIC AMMER 3.5gr Rainbow

LINGURITA OSCILANTA COLMIC AMMER 3.5gr Rainbow

arhkamb31
Livrare 48-72 ore

26,32Lei

Plumbi COLMIC Sfera In-Line, 15.00g, 3buc/pac

Plumbi COLMIC Sfera In-Line, 15.00g, 3buc/pac

poleba14
Livrare 48-72 ore

24,39Lei

FIR COLMIC FLUOROCARBON WIND 50M 0.409mm

FIR COLMIC FLUOROCARBON WIND 50M 0.409mm

nywin40
Livrare 48-72 ore

81,32Lei

LINGURITA OSCILANTA COLMIC RACE 1.5gr Matt Firetiger Gold

LINGURITA OSCILANTA COLMIC RACE 1.5gr Matt Firetiger Gold

arhkrac29
Livrare 48-72 ore

25,30Lei

Pluta COLMIC Karbon, 0.75g

Pluta COLMIC Karbon, 0.75g

gakar075
Livrare 48-72 ore

16,25Lei

FIR COLMIC OKY 150M 0.45mm

FIR COLMIC OKY 150M 0.45mm

nyok045
Livrare 48-72 ore

19,81Lei

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Orange Red Flakes -22%

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Orange Red Flakes

arhkll18
Livrare 48-72 ore

18,90Lei(-22%) 14,73Lei

FIR COLMIC ALL ROUND NX50 150M 0.129mm

FIR COLMIC ALL ROUND NX50 150M 0.129mm

nyal150129
Livrare imediată!

22,35Lei

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Matt Sunny

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Matt Sunny

arhkfq05
Livrare 48-72 ore

40,55Lei

Umbrela Cort COLMIC, 250m

Umbrela Cort COLMIC, 250m

omh14d
Livrare 48-72 ore

559,00Lei

FIR COLMIC OMEGA PT50 300M 0.30mm Galben Fluo

FIR COLMIC OMEGA PT50 300M 0.30mm Galben Fluo

nyome030
Livrare imediată!

50,82Lei

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Acciuga -27%

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Acciuga

arhklt09
Livrare 48-72 ore

76,90Lei(-27%) 56,01Lei

FIR COLMIC RBS 100M 0.206mm

FIR COLMIC RBS 100M 0.206mm

nyrb20
Livrare 48-72 ore

31,50Lei

BAZZY BUG COLMIC HERAKLES 8cm Sumer Craw -24%

BAZZY BUG COLMIC HERAKLES 8cm Sumer Craw

arhkbaz09
Livrare 48-72 ore

27,90Lei(-24%) 21,13Lei

CARLIGE COLMIC NUCLEAR B900 NR 16

CARLIGE COLMIC NUCLEAR B900 NR 16

amc16
Livrare imediată!

21,84Lei

Shad Colmic Herakles Mirror 10cm culoare VAIRONE

Shad Colmic Herakles Mirror 10cm culoare VAIRONE

arhkmsh10
Livrare 48-72 ore

40,55Lei

CARLIGE COLMIC NUCLEAR N600 NR 12

CARLIGE COLMIC NUCLEAR N600 NR 12

amk12
Livrare imediată!

18,79Lei

Plumbi Colmic Herakles MDJ Sinker 9.5gr

Plumbi Colmic Herakles MDJ Sinker 9.5gr

pohkmd04
Livrare 48-72 ore

17,17Lei

CARLIGE COLMIC NUCLEAR TR99 NR 9

CARLIGE COLMIC NUCLEAR TR99 NR 9

amu09
Livrare 48-72 ore

22,86Lei

Lanseta Bolognesa Colmic Kombat Rock 7.20m 100g

Lanseta Bolognesa Colmic Kombat Rock 7.20m 100g

cako11c
Livrare 48-72 ore

1.455,03Lei

Afişare 1161 - 1180 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.630 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = '25d26930b1cbdc2782cbaad18b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
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 (57.047)
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 (79.003)
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 1160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.126)
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