Colmic

Colmic

Sortare după:

Vobler Colmic Herakles WT-Dog 85 8.5cm 9.5g Ghost Sarda Glow

Vobler Colmic Herakles WT-Dog 85 8.5cm 9.5g Ghost Sarda Glow

arwtd8507

Livrare 48-72 ore

51,90Lei(-26%) 38,22Lei

Fir Monofilament Colmic Axial, Portocaliu, 300m, 0.20mm

Fir Monofilament Colmic Axial, Portocaliu, 300m, 0.20mm

nyax20

Livrare imediată!

22,00Lei(-13%) 19,20Lei

FIR TEXTIL COLMIC WEPER X4 GREY 33lbs 150yds 137m 0.20mm

FIR TEXTIL COLMIC WEPER X4 GREY 33lbs 150yds 137m 0.20mm

nywex4233

Livrare 48-72 ore

96,58Lei

Fir Fluorocarbon Colmic C3 Maxx 50m, 0.255mm, 6.24kg

Fir Fluorocarbon Colmic C3 Maxx 50m, 0.255mm, 6.24kg

nyc3ma25

Livrare 48-72 ore

53,87Lei

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

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

caca02c

Livrare imediată!

783,93Lei

SET CUTII COLMIC MASURA OFICIALA

SET CUTII COLMIC MASURA OFICIALA

sc02

Livrare 48-72 ore

119,97Lei

CARABINA SNAP COLMIC CU VARTEJ 12

CARABINA SNAP COLMIC CU VARTEJ 12

gm300312

Livrare 48-72 ore

10,15Lei

MOMITOR COLMIC PELLETFEEDER LARGE 25gr

MOMITOR COLMIC PELLETFEEDER LARGE 25gr

fed50c

Livrare imediată!

20,32Lei

ARGILA COLMIC DRY GRAY 1kg

ARGILA COLMIC DRY GRAY 1kg

pcbel50e

Livrare 48-72 ore

30,49Lei

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

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

poledr09

Livrare 48-72 ore

28,45Lei

VARF LANSETA COLMIC ARATON PRO CARBON LH GALBEN

VARF LANSETA COLMIC ARATON PRO CARBON LH GALBEN

caar02m

Livrare imediată!

113,87Lei

LINGURITA OSCILANTA COLMIC AMMER 3.5gr Pink Pellet

LINGURITA OSCILANTA COLMIC AMMER 3.5gr Pink Pellet

arhkamb36

Livrare 48-72 ore

26,32Lei

Plumbi COLMIC Sfera In-Line, 25.00g, 2buc/pac

Plumbi COLMIC Sfera In-Line, 25.00g, 2buc/pac

poleba17

Livrare 48-72 ore

24,39Lei

FIR COLMIC FLUOROCARBON WIND 50M 0.62mm

FIR COLMIC FLUOROCARBON WIND 50M 0.62mm

nywin62

Livrare 48-72 ore

169,79Lei

LINGURITA OSCILANTA COLMIC RACE 1.5gr Yellowstone

LINGURITA OSCILANTA COLMIC RACE 1.5gr Yellowstone

arhkrac33

Livrare 48-72 ore

25,30Lei

Pluta COLMIC Karbon, 2.00g

Pluta COLMIC Karbon, 2.00g

gakar200

Livrare 48-72 ore

16,25Lei

FIR COLMIC ATOMIC 100M 0.16mm

FIR COLMIC ATOMIC 100M 0.16mm

nyat016

Livrare 48-72 ore

9,64Lei

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Black Chartreuse

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Black Chartreuse

arhkll23

Livrare 48-72 ore

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

FIR COLMIC ALL ROUND NX50 150M 0.189mm

FIR COLMIC ALL ROUND NX50 150M 0.189mm

nyal150189

Livrare imediată!

25,00Lei(-15%) 21,24Lei

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Ghost Ayu

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Ghost Ayu

arhkbi02

Livrare 48-72 ore

50,72Lei

Afişare 2041 - 2060 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: 130.895 ms [By time] [By id] [By file]

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = '585f024849d80f66e1addd0424'

/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.093)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.091)

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

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

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

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

7 (0.113)

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