Colmic


27,44Lei

MIRROR SHAD COLMIC 3.2" 8.1cm GHOST

arhkeh04
Livrare 48-72 ore

35,47Lei

Maner Minciog Colmic Dragon Carp 3.1m

gxdr01a
Livrare 48-72 ore

325,36Lei

GHOST SHAD COLMIC 10cm BLACK IMPACT

arhkau10
Livrare 48-72 ore

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

Mulineta Colmic Rayton FD 4500 10+1BB

mulra45
Livrare 48-72 ore

534,82Lei

TURBO GRUB COLMIC 14cm BLACK RED FLK

arhkcv03
Livrare 48-72 ore

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

Pluta Colmic Hybrid Carp 3 0.75g

gahyb3075
Livrare 48-72 ore

19,30Lei

PLUMBI COLMIC SFERA CALIBRATA 20.00gr

posfe20
Livrare 48-72 ore

36,59Lei

Pluta Colmic Plovdiv 1.5g

gaploa2
Livrare 48-72 ore

12,18Lei

15,74Lei

448,39Lei

460,01Lei(-24%) 351,80Lei

51,74Lei

FIR FEEDER COLMIC PRO AT70 250M 0.208MM

nyfep0208
Livrare imediată!

50,82Lei

99,63Lei

758,52Lei

324,34Lei

PLUTA COLMIC MALAGA 1.00 GR

gamal01c
Livrare imediată!

13,71Lei

Mulineta Colmic Ispanic FD 3000

mulisp30
Livrare 48-72 ore

335,53Lei

641,49Lei

Afişare 121 - 140 din 2647 (133 pagini)
Queries: 7, Total time: 134.901 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = 'cf368b02fd5616e0e8ddae9c76'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Colmic'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.101)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (45.403)
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 = '0' AND p.manufacturer_id = '115'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (88.994)
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 = '0' AND p.manufacturer_id = '115' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.115)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37