Colmic

Colmic

Sortare după:

LINGURITA OSCILANTA COLMIC DRIBBLE SPOON 6gr Gold

LINGURITA OSCILANTA COLMIC DRIBBLE SPOON 6gr Gold

arhkir05

Livrare 48-72 ore

18,90Lei(-27%) 13,81Lei

VOBLER COLMIC MOTH SINKING 3.7cm 2.4gr Pink

VOBLER COLMIC MOTH SINKING 3.7cm 2.4gr Pink

arhkmos16

Livrare 48-72 ore

53,91Lei(-26%) 39,64Lei

VOBLER COLMIC HYPNO-SR F 5.6cm 11.5gr Matt Sunny

VOBLER COLMIC HYPNO-SR F 5.6cm 11.5gr Matt Sunny

arhkdh02

Livrare 48-72 ore

61,92Lei

Inele Despicate Colmic Herakles Area Flat Split 3.5mm 20buc/plic

Inele Despicate Colmic Herakles Area Flat Split 3.5mm 20buc/plic

gmhksp35

Livrare imediată!

12,08Lei

VOBLER COLMIC DOGO 110SP 11cm 19gr Skull

VOBLER COLMIC DOGO 110SP 11cm 19gr Skull

arhkdq04

Livrare 48-72 ore

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

VOBLER Colmic Herakles BULLET 85SK 8.5cm 24.5gr Pink Silver

VOBLER Colmic Herakles BULLET 85SK 8.5cm 24.5gr Pink Silver

arhkbu809

Livrare 48-72 ore

65,97Lei

VOBLER COLMIC DARKO-S 14.5cm 60gr Pinky

VOBLER COLMIC DARKO-S 14.5cm 60gr Pinky

arhkdv05

Livrare 48-72 ore

48,90Lei(-36%) 31,21Lei

FLAT FROG COLMIC DARK BLUE

FLAT FROG COLMIC DARK BLUE

arhkes04

Livrare 48-72 ore

38,51Lei

KILLER FLIP COLMIC 4" 10cm ROOTBEAR

KILLER FLIP COLMIC 4" 10cm ROOTBEAR

arhkfn05

Livrare 48-72 ore

37,90Lei(-35%) 24,49Lei

Lanseta Bologneza Colmic Alexa Bolo Project 5m 20gr

Lanseta Bologneza Colmic Alexa Bolo Project 5m 20gr

caale01a

Livrare 48-72 ore

799,19Lei

RAZOR GRUB COLMIC 4.5" 11.4cm SMART GREEN

RAZOR GRUB COLMIC 4.5" 11.4cm SMART GREEN

arhkcu03

Livrare 48-72 ore

20,90Lei(-32%) 14,12Lei

Elastic Tubular Colmic Royal 3mt 4.00mm

Elastic Tubular Colmic Royal 3mt 4.00mm

ele400

Livrare 48-72 ore

46,75Lei

SHAD COLMIC BENJO 3" 7.5cm MOTOR PEPPER

SHAD COLMIC BENJO 3" 7.5cm MOTOR PEPPER

arhkia09

Livrare 48-72 ore

21,24Lei

Fir Inaintas Colmic Xilo Advanced Monofilament 50m, 0.128mm

Fir Inaintas Colmic Xilo Advanced Monofilament 50m, 0.128mm

nyxiad128

Livrare imediată!

27,44Lei

FIR COLMIC HERAKLES XS SPINNING NX50 150M 0.300mm

FIR COLMIC HERAKLES XS SPINNING NX50 150M 0.300mm

nyhkxs030

Livrare 48-72 ore

41,58Lei

Lanseta Colmic Herakles Kiar Eclisse HKEC2-900HF 2.75m 15-50g

Lanseta Colmic Herakles Kiar Eclisse HKEC2-900HF 2.75m 15-50g

cahkkec08

Livrare 48-72 ore

946,53Lei

JIG COLMIC CORNER MICRO 2gr

JIG COLMIC CORNER MICRO 2gr

amhkab01

Livrare imediată!

16,25Lei

Mulineta Colmic Mars FD 7000 7+1BB

Mulineta Colmic Mars FD 7000 7+1BB

mulmars70

Livrare 48-72 ore

453,48Lei

ZIGGY SHAD COLMIC 5.5cm PINK IMPACT

ZIGGY SHAD COLMIC 5.5cm PINK IMPACT

arhkei03

Livrare 48-72 ore

14,90Lei(-30%) 10,45Lei

Pluta Colmic Chioggia 2g

Pluta Colmic Chioggia 2g

gachi020

Livrare 48-72 ore

9,14Lei

Afişare 541 - 560 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: 121.533 ms [By time] [By id] [By file]

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = 'ce47ea23bc39023ed77bba9eaf'

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

2 (0.066)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.083)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.083)

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

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

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

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

7 (0.138)

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