Colmic


CARLIGE, COLMIC, NUCLEAR, N900, NR, 12, , aml12, Carlige Stationar, Carlige Stationar Colmic, Carlige Feeder, Carlige Feeder Colmic, Colmic
CICADA, , COLMIC, HERAKLES, METAL, FIRE, 5.2CM, 12GR, Baitfish, jhkai06, Cicade, Cicade Colmic, Colmic
CARLIGE COLMIC NUCLEAR MR66 NR 1

CARLIGE COLMIC NUCLEAR MR66 NR 1

am0310
Livrare 48-72 ore

21,50Lei

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Alburno Tiger

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Alburno Tiger

arhkbi09
Livrare 48-72 ore

48,00Lei

CARLIGE, COLMIC, LEGATE, N600, NR, 6-0.18, 70CM, al20618, Monturi Crap, Monturi Crap Colmic, Carlige Legate Stationar, Carlige Legate Stationar Colmic, Colmic
POPPER, COLMIC, HERAKLES, POP-EY, 7cm, 9.5gr, Bandit, arherak07e, Voblere Floating, Voblere Floating Colmic, Colmic -30%

POPPER, COLMIC, HERAKLES, POP-EY, 7cm, 9.5gr, Bandit, arherak07e, Voblere Floating, Voblere Floating Colmic, Colmic

arherak07e
Livrare 48-72 ore

40,00Lei(-30%) 28,00Lei

PLUTA COLMIC BLINDO CARP 3 GR 0.75

PLUTA COLMIC BLINDO CARP 3 GR 0.75

gablic301e
Livrare 48-72 ore

13,49Lei

CAVE CRAW COLMIC HERAKLES 9.6cm Green Pumpkin Purple Flk -30%

CAVE CRAW COLMIC HERAKLES 9.6cm Green Pumpkin Purple Flk

arhkcav26
Livrare 48-72 ore

23,00Lei(-30%) 16,10Lei

PLUTA COLMIC BOGA GR 2.00

PLUTA COLMIC BOGA GR 2.00

gabogqa
Livrare 48-72 ore

6,50Lei

Grub, Colmic, Herakles, Viber, 6.2cm, Live, Pellet, arhklq01, Grub-uri, Grub-uri Colmic, Colmic -40%

Grub, Colmic, Herakles, Viber, 6.2cm, Live, Pellet, arhklq01, Grub-uri, Grub-uri Colmic, Colmic

arhklq01
Livrare 48-72 ore

11,00Lei(-40%) 6,60Lei

PLUTA, COLMIC, TEVERE, GR, 2.00, gatevqa, Plute Stationar, Plute Stationar Colmic, Colmic

PLUTA, COLMIC, TEVERE, GR, 2.00, gatevqa, Plute Stationar, Plute Stationar Colmic, Colmic

gatevqa
Livrare 48-72 ore

9,00Lei

Plumbi Colmic Herakles MDJ Sinker 9.5gr

Plumbi Colmic Herakles MDJ Sinker 9.5gr

pohkmd04
Livrare 48-72 ore

15,01Lei

BLUZA COLMIC MICRO FLEECE 3XL -40%

BLUZA COLMIC MICRO FLEECE 3XL

abf004f
Livrare 48-72 ore

118,00Lei(-40%) 71,00Lei

Lanseta Bolognesa Colmic Seven Key 7.00m 20g

Lanseta Bolognesa Colmic Seven Key 7.00m 20g

case50c
Livrare 48-72 ore

843,00Lei

CUPA COLMIC DE NADIT DUBLA 250ml

CUPA COLMIC DE NADIT DUBLA 250ml

cou05
Livrare imediată!

51,00Lei

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.405mm 50m

Fir Fluorocarbon Colmic Seaguar Secol PowerF 0.405mm 50m

nysc405
Livrare 48-72 ore

134,01Lei

PLUMBI COLMIC OLIVETA JAZ 0.20gr

PLUMBI COLMIC OLIVETA JAZ 0.20gr

toj0020
Livrare imediată!

21,00Lei

GEANTA, COLMIC, LION, L, boxeva307c, Genti Accesorii, Genti Accesorii Colmic, Colmic

GEANTA, COLMIC, LION, L, boxeva307c, Genti Accesorii, Genti Accesorii Colmic, Colmic

boxeva307c
Livrare 48-72 ore

165,01Lei

PLUMBI COLMIC OLIVETA SUPREME 5.00gr

PLUMBI COLMIC OLIVETA SUPREME 5.00gr

tos0500
Livrare imediată!

22,00Lei

Lanseta Colmic Herakles Calida Ego HCE2-70MH 2.13m 7-21g

Lanseta Colmic Herakles Calida Ego HCE2-70MH 2.13m 7-21g

cahkce03
Livrare 48-72 ore

485,00Lei

Afişare 101 - 120 din 2612 (131 pagini)
Queries: 7, Total time: 123.725 ms [By time] [By id] [By file]
1 (0.159)
SELECT data
FROM `oc_session`
WHERE session_id = '574c3f77ed2cbde99e767f8fcd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.131)
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 (41.908)
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:1667
6 (81.140)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.147)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38