Maver


3.174,35Lei

CARLIGE Maver IT KATANA 1045 BLACK NR 8

1045a008
Livrare 48-72 ore

23,27Lei

CARLIGE Maver IT KATANA 1210 NICKEL NR 20

1210a020
Livrare 48-72 ore

20,22Lei

Lanseta bologneza Maver Zarta 6m

5778600
Livrare 48-72 ore

702,49Lei

21,01Lei(-14%) 18,08Lei

21,24Lei

CARLIGE Maver IT KATANA 1210 NICKEL NR 6

1210a006
Livrare 48-72 ore

20,22Lei

31,40Lei

47,67Lei

1.760,01Lei(-24%) 1.344,10Lei

92,41Lei

21,24Lei

CARLIGE Maver IT KATANA 1095 BLACK NR 12

1095a012
Livrare imediată!

25,30Lei

144,27Lei

2.522,58Lei

CARLIGE Maver IT KATANA 1090 NICKEL NR 17

1090a017
Livrare imediată!

25,30Lei

CARLIGE Maver IT KATANA 1235 NEGRU NR 7/0

1235a7/0
Livrare imediată!

26,32Lei

TRICOU Maver UK TEAM WHITE XXL

n1238
Livrare 48-72 ore

96,49Lei

Bac Maver IT MV-R Maggot Net 14 cm

1083004
Livrare 48-72 ore

86,31Lei

3.032,01Lei

Afişare 1 - 20 din 1750 (88 pagini)
Queries: 7, Total time: 138.947 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = 'f1f03e70503db24f3fe7628860'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '49' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (71.202)
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 = '49'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (67.217)
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 = '49' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.105)
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