Colmic

Colmic

Sortare după:

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

ROLA FIR JAXON STRUNA 5M 6KG

ROLA FIR JAXON STRUNA 5M 6KG

ak-pr11506b

Livrare 48-72 ore

45,74Lei

Pluta Colmic Multibeta 2g

Pluta Colmic Multibeta 2g

gamube200

Livrare 48-72 ore

12,18Lei

VOBLER COLMIC WT-DOG 125 F 12.5cm 27gr TRI SHAD COLMIC

VOBLER COLMIC WT-DOG 125 F 12.5cm 27gr TRI SHAD COLMIC

arherak09c

Livrare 48-72 ore

33,60Lei(-25%) 25,20Lei

Shad Colmic Herakles Shad-Ow70 7cm Clear Water, 8buc/plic

Shad Colmic Herakles Shad-Ow70 7cm Clear Water, 8buc/plic

arso7066

Livrare 48-72 ore

28,35Lei

Momitor Colmic Standard Cage Feeder 25gr 20x25mm

Momitor Colmic Standard Cage Feeder 25gr 20x25mm

fed65c

Livrare 48-72 ore

13,71Lei

Vobler Colmic Herakles Hypno-DD F 6.3cm 20.5g Fire Tiger Matt

Vobler Colmic Herakles Hypno-DD F 6.3cm 20.5g Fire Tiger Matt

arhkdm13

Livrare 48-72 ore

72,07Lei

Lanseta Colmic Calibra 2.10m, 70-300g, 2seg

Lanseta Colmic Calibra 2.10m, 70-300g, 2seg

caca02a

Livrare imediată!

572,45Lei

Lanseta Bolognesa Colmic Arkana, 7m, 25g, 7seg

Lanseta Bolognesa Colmic Arkana, 7m, 25g, 7seg

caar80c

Livrare 48-72 ore

1.068,65Lei

FIR COLMIC BLADE SINKING AT70 150M 0.168MM

FIR COLMIC BLADE SINKING AT70 150M 0.168MM

nybl0168

Livrare imediată!

28,00Lei(-13%) 24,28Lei

Afişare 1281 - 1300 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: 134.782 ms [By time] [By id] [By file]

1 (0.198)

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

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

2 (0.104)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.137)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.130)

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

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

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

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

7 (0.134)

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