Colmic

Colmic

Sortare după:

VOBLER COLMIC MOTH TROUT AREA F 3.7cm 2.2gr Kobura

VOBLER COLMIC MOTH TROUT AREA F 3.7cm 2.2gr Kobura

arhkmot21

Livrare 48-72 ore

60,90Lei(-27%) 44,62Lei

VOBLER COLMIC HELIX TOPWATER 11.5cm 16gr SHAD

VOBLER COLMIC HELIX TOPWATER 11.5cm 16gr SHAD

arhkiw05

Livrare 48-72 ore

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

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

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

gmhksp25

Livrare imediată!

12,08Lei

VOBLER COLMIC DOGO 110SP 11cm 19gr SHAD

VOBLER COLMIC DOGO 110SP 11cm 19gr SHAD

arhkdq01

Livrare 48-72 ore

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

VOBLER Colmic Herakles BULLET 85SK 8.5cm 24.5gr Live Ina

VOBLER Colmic Herakles BULLET 85SK 8.5cm 24.5gr Live Ina

arhkbu807

Livrare 48-72 ore

65,97Lei

VOBLER COLMIC DARKO-S 14.5cm 60gr Holo Clown

VOBLER COLMIC DARKO-S 14.5cm 60gr Holo Clown

arhkdv06

Livrare 48-72 ore

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

VOBLER COLMIC IDROFLAT 200 7.5cm-18gr Bolsena Secret

VOBLER COLMIC IDROFLAT 200 7.5cm-18gr Bolsena Secret

aridro2001

Livrare 48-72 ore

46,90Lei(-46%) 25,30Lei

KILLER FLIP COLMIC 4" 10cm GREEN PUMPKIN

KILLER FLIP COLMIC 4" 10cm GREEN PUMPKIN

arhkfn03

Livrare 48-72 ore

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

Tub Lansete Prisma Cast Herakles 215cmx50mm

Tub Lansete Prisma Cast Herakles 215cmx50mm

tubr215

Livrare imediată!

58,96Lei

VIBER GRUB COLMIC 4.5" 11.4cm SMOKE GOLD BLACK FLK

VIBER GRUB COLMIC 4.5" 11.4cm SMOKE GOLD BLACK FLK

arhkcz06

Livrare 48-72 ore

31,90Lei(-35%) 20,82Lei

Lanseta Colmic Dexter Match 390 5-20gr

Lanseta Colmic Dexter Match 390 5-20gr

cbde01a

Livrare 48-72 ore

566,34Lei

SHAD COLMIC BENJO 3" 7.5cm MAGIC SHAD

SHAD COLMIC BENJO 3" 7.5cm MAGIC SHAD

arhkia07

Livrare 48-72 ore

21,24Lei

Fir Inaintas Colmic Xilo Advanced Monofilament 50m, 0.104mm 1.520 kg

Fir Inaintas Colmic Xilo Advanced Monofilament 50m, 0.104mm 1.520 kg

nyxiad104

Livrare 48-72 ore

27,44Lei

FIR COLMIC HERAKLES XS SPINNING NX50 150M 0.230mm

FIR COLMIC HERAKLES XS SPINNING NX50 150M 0.230mm

nyhkxs023

Livrare 48-72 ore

34,45Lei

Lanseta Colmic Herakles Kiar Eclisse HKEC2-800M 2.45m 7-28g

Lanseta Colmic Herakles Kiar Eclisse HKEC2-800M 2.45m 7-28g

cahkkec05

Livrare 48-72 ore

855,02Lei

GHOST SHAD COLMIC 5cm GREEN SHAD

GHOST SHAD COLMIC 5cm GREEN SHAD

arhkba07

Livrare 48-72 ore

28,35Lei

Mulineta Colmic Mars FD 5000 7+1BB

Mulineta Colmic Mars FD 5000 7+1BB

mulmars50

Livrare 48-72 ore

367,05Lei

GHOST SHAD COLMIC 13cm GREEN SHAD

GHOST SHAD COLMIC 13cm GREEN SHAD

arhkct07

Livrare 48-72 ore

41,90Lei(-36%) 26,93Lei

Pluta Colmic Catania 3g

Pluta Colmic Catania 3g

gacat030

Livrare 48-72 ore

8,63Lei

LANSETA JAXON IMPRESS GTX SPIN 2.70M/2SEG 15-40GR

LANSETA JAXON IMPRESS GTX SPIN 2.70M/2SEG 15-40GR

wj-imx27040

Livrare 48-72 ore

511,00Lei(-29%) 364,00Lei

Afişare 1781 - 1800 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: 137.291 ms [By time] [By id] [By file]

1 (0.191)

SELECT data
FROM `oc_session`
WHERE session_id = '5f3dc309d919ab6064bcceeed2'

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

2 (0.106)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.107)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.108)

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

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

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

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

7 (0.204)

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