Colmic

Colmic

Sortare după:

GHOST SHAD COLMIC 10cm SMOKE / PINK SHAD

GHOST SHAD COLMIC 10cm SMOKE / PINK SHAD

arhkau03

Livrare 48-72 ore

34,90Lei(-35%) 22,66Lei

Lingurita Oscilanta Colmic Herakles K1 Fat 175, 2.1g

Lingurita Oscilanta Colmic Herakles K1 Fat 175, 2.1g

arhkk121f175

Livrare 48-72 ore

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

SHAD COLMIC BIG DOUBLE 15cm TROUT

SHAD COLMIC BIG DOUBLE 15cm TROUT

arhkeq01

Livrare 48-72 ore

36,91Lei(-25%) 27,54Lei

Pluta Colmic Hybrid River 5g

Pluta Colmic Hybrid River 5g

gahyr050

Livrare 48-72 ore

20,32Lei

MOTH WORM COLMIC HERAKLES 2.5CM LIVE PELLET 18/PLIC

MOTH WORM COLMIC HERAKLES 2.5CM LIVE PELLET 18/PLIC

arhklr01

Livrare imediată!

11,57Lei

Pluta Colmic Plovdiv 1g

Pluta Colmic Plovdiv 1g

gaploa1

Livrare 48-72 ore

12,18Lei

CON CU EXTRACTOR POLE BUNG L COLMIC

CON CU EXTRACTOR POLE BUNG L COLMIC

dib9

Livrare 48-72 ore

34,55Lei

Shad Colmic Herakles Shad-Ow85 8.9cm Flash Minnow, 10buc/plic

Shad Colmic Herakles Shad-Ow85 8.9cm Flash Minnow, 10buc/plic

arhkso0847

Livrare 48-72 ore

34,45Lei

Momitor Colmic Standard Cage Feeder 40gr 25x25mm

Momitor Colmic Standard Cage Feeder 40gr 25x25mm

fed67c

Livrare 48-72 ore

13,71Lei

Vobler Colmic Herakles Hypno-MR F 5.6cm 14.5g Sexy Shad

Vobler Colmic Herakles Hypno-MR F 5.6cm 14.5g Sexy Shad

arhkdi11

Livrare 48-72 ore

64,96Lei

LANSETA COLMIC GHEMON YOUNG 3.00M 300GR

LANSETA COLMIC GHEMON YOUNG 3.00M 300GR

cagh60c

Livrare 48-72 ore

707,68Lei

Lanseta Feeder Colmic Mirage S31 StillWater ML, 3.60m, 50g, 3+3seg

Lanseta Feeder Colmic Mirage S31 StillWater ML, 3.60m, 50g, 3+3seg

cami81b

Livrare 48-72 ore

905,96Lei

FIR FEEDER COLMIC PRO AT70 250M 0.208MM

FIR FEEDER COLMIC PRO AT70 250M 0.208MM

nyfep0208

Livrare imediată!

50,82Lei

FIR TEXTIL COLMIC WEPER X8 GREY 65lbs 150yds 137m 0.35mm

FIR TEXTIL COLMIC WEPER X8 GREY 65lbs 150yds 137m 0.35mm

nywex8265

Livrare 48-72 ore

101,66Lei

Mulineta Colmic Ispanic FD 2000

Mulineta Colmic Ispanic FD 2000

mulisp20

Livrare 48-72 ore

316,21Lei

FIR COLMIC YELLOW DRAGON 800M 80LB 0.88mm

FIR COLMIC YELLOW DRAGON 800M 80LB 0.88mm

nyyd80

Livrare 48-72 ore

324,34Lei

MIXER NADA COLMIC CONIC 8 PALETI

MIXER NADA COLMIC CONIC 8 PALETI

mix310

Livrare imediată!

226,73Lei

Lanseta COLMIC Joker Boat 2.10m, 200g, 2seg

Lanseta COLMIC Joker Boat 2.10m, 200g, 2seg

cajo01d

Livrare 48-72 ore

193,18Lei

LANSETA COLMIC PREMIUM INDYO CAST 7" 1/4-3/4 Medium Heavy

LANSETA COLMIC PREMIUM INDYO CAST 7" 1/4-3/4 Medium Heavy

cahkpr04

Livrare 48-72 ore

1.359,89Lei(-29%) 968,90Lei

SUPORT COLMIC EASY 4 PICIOARE 9 POSTURI

SUPORT COLMIC EASY 4 PICIOARE 9 POSTURI

ap00013

Livrare 48-72 ore

544,98Lei

Afişare 421 - 440 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: 120.180 ms [By time] [By id] [By file]

1 (0.133)

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

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

2 (0.116)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.125)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.149)

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

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

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

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

7 (0.145)

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