Colmic

Colmic

Sortare după:

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Live Pellet

LINGURITA OSCILANTA COLMIC HERAKLES TROUT AREA LOSKO 1.6gr Live Pellet

arhkll19

Livrare 48-72 ore

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

FIR COLMIC ALL ROUND NX50 150M 0.149mm

FIR COLMIC ALL ROUND NX50 150M 0.149mm

nyal150149

Livrare 48-72 ore

24,39Lei

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Levander Tiger

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Levander Tiger

arhkfq06

Livrare 48-72 ore

40,55Lei

Umbrela Cort COLMIC, 220m

Umbrela Cort COLMIC, 220m

omh14c

Livrare 48-72 ore

499,00Lei

FIR COLMIC IRIDE PT50 300M 0.14mm Orange Fluo

FIR COLMIC IRIDE PT50 300M 0.14mm Orange Fluo

nyir014

Livrare imediată!

22,00Lei(-14%) 18,91Lei

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Ghost

POPPER COLMIC HERAKLES HI-POP 14.5cm 58gr Ghost

arhklt11

Livrare 48-72 ore

76,90Lei(-27%) 56,01Lei

FIR COLMIC RBS 100M 0.25mm

FIR COLMIC RBS 100M 0.25mm

nyrb25

Livrare 48-72 ore

36,59Lei

BAZZY BUG COLMIC HERAKLES 8cm Black Red Flakes

BAZZY BUG COLMIC HERAKLES 8cm Black Red Flakes

arhkbaz11

Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

CARLIGE COLMIC NUCLEAR B900 NR 18

CARLIGE COLMIC NUCLEAR B900 NR 18

amc18

Livrare imediată!

21,84Lei

Rotor Worm Colmic Herakles 2.8cm ORANGE FLUO

Rotor Worm Colmic Herakles 2.8cm ORANGE FLUO

arhkls02

Livrare 48-72 ore

10,90Lei(-17%) 9,03Lei

CARLIGE COLMIC NUCLEAR N600 NR 14

CARLIGE COLMIC NUCLEAR N600 NR 14

amk14

Livrare imediată!

20,82Lei

Plumbi Colmic Herakles Texas Bullet Matt Black 1.0g

Plumbi Colmic Herakles Texas Bullet Matt Black 1.0g

pohktb01

Livrare imediată!

18,17Lei

CARLIGE COLMIC NUCLEAR MR66 NR 2/0

CARLIGE COLMIC NUCLEAR MR66 NR 2/0

am0304

Livrare 48-72 ore

27,95Lei

Lanseta Bolognesa Colmic Dark Power 5.00m 100g

Lanseta Bolognesa Colmic Dark Power 5.00m 100g

cadar01a

Livrare 48-72 ore

814,45Lei

CARLIGE COLMIC LEGATE N600 NR 6-0.20 70CM

CARLIGE COLMIC LEGATE N600 NR 6-0.20 70CM

al20620

Livrare 48-72 ore

22,35Lei

Juvelnic Colmic Start Net 1.5m

Juvelnic Colmic Start Net 1.5m

nacr97a

Livrare 48-72 ore

107,76Lei

PLUTA COLMIC EDY GR 0.75

PLUTA COLMIC EDY GR 0.75

gaedyka

Livrare 48-72 ore

12,18Lei

Cutie Colmic Bait Box 0.60L

Cutie Colmic Bait Box 0.60L

sc10b

Livrare 48-72 ore

24,39Lei

PLUTA COLMIC MENTA-PISA GR 1.50

PLUTA COLMIC MENTA-PISA GR 1.50

gamepgc

Livrare 48-72 ore

14,73Lei

Lanseta Colmic Herakles Area Elisium-J HAS2 UL 1.95m 0.8-2.5g

Lanseta Colmic Herakles Area Elisium-J HAS2 UL 1.95m 0.8-2.5g

cahkej02

Livrare 48-72 ore

664,87Lei

Afişare 921 - 940 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: 124.375 ms [By time] [By id] [By file]

1 (0.111)

SELECT data
FROM `oc_session`
WHERE session_id = '92742ae9f81a5169b4fa7573cc'

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

2 (0.065)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.099)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'

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

4 (0.094)

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

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

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

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

7 (0.230)

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