Ingrijire masculina

FARMEC GEROVITAL H3 DEO ANTIPERSPIRANT FRESH MEN SPRAY 150ML 37910
FARMEC GEROVITAL H3 MEN BALSAM DUPA RAS 50ML 3710

FARMEC GEROVITAL H3 MEN BALSAM DUPA RAS 50ML 3710

Actiune: Bisabololul alaturi de sootex actioneaza in profunzime, calmeaza imediat pielea dupa bar..

20,20Lei Fără TVA: 16,97Lei

FARMEC GEROVITAL H3 MEN LOTIUNE DUPA RAS 100ML  3760

FARMEC GEROVITAL H3 MEN LOTIUNE DUPA RAS 100ML 3760

Descriere:Loțiunea conține Bisabolol ce acționează în profunzime, calmează pielea după bărbierit, ..

19,73Lei Fără TVA: 16,58Lei

FARMEC GEROVITAL H3 MEN SAMPON ANTICADERE 250ML 3730

FARMEC GEROVITAL H3 MEN SAMPON ANTICADERE 250ML 3730

Descriere:Acționând ca un booster de energie asupra celulelor foliculului pilos, Șamponul Anticăder..

14,38Lei Fără TVA: 12,08Lei

FARMEC GEROVITAL H3 MEN SAMPON REGENERANT 400ML 3790

FARMEC GEROVITAL H3 MEN SAMPON REGENERANT 400ML 3790

Descriere:Șamponul conține keratină hidrolizată ce are ca acțiune refacerea nivelul de keratină di..

17,75Lei Fără TVA: 14,92Lei

FARMEC GEROVITAL H3 MEN SPUMA DE RAS 200ML 37950

FARMEC GEROVITAL H3 MEN SPUMA DE RAS 200ML 37950

Acțiune: Spuma de ras este îmbogățită cu extract vegetal de Boswellia Serrata și Alantoină av..

13,59Lei Fără TVA: 11,42Lei

VICHY HOMME SPUMA RAS ANTI-IRITATII 200ML M6634103

VICHY HOMME SPUMA RAS ANTI-IRITATII 200ML M6634103

Proprietăți:- are o textură densă şi onctuoasă ce asigură o alunecare optimă a lamei, pentru un ras ..

38,58Lei Fără TVA: 32,42Lei

Afişare 1 - 7 din 7 (1 pagini)
Queries: 89, Total time: 78.870 ms [By time] [By id] [By file]
1 (1.034)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
2 (1.687)
SELECT `data`
FROM `ochs_session`
WHERE session_id = '27fd5ac65cf89cbd085e7d08cd' AND expire > 1624020612
/home/farmaciileremedi/public_html/system/library/session/db.php:21
3 (0.353)
SELECT *
FROM ochs_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://farmaciileremedia.ro/'
/home/farmaciileremedi/public_html/catalog/controller/startup/startup.php:6
4 (4.639)
SELECT *
FROM `ochs_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/farmaciileremedi/public_html/catalog/controller/startup/startup.php:25
5 (0.690)
SELECT *
FROM ochs_language
WHERE status = '1'
ORDER BY sort_order, name
/home/farmaciileremedi/public_html/catalog/model/localisation/language.php:15
6 (0.844)
SELECT *
FROM ochs_currency
/home/farmaciileremedi/public_html/system/library/cart/currency.php:10
7 (2.155)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ochs_tax_rule tr1
LEFT JOIN ochs_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ochs_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ochs_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ochs_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2701')
ORDER BY tr1.priority ASC
/home/farmaciileremedi/public_html/system/library/cart/tax.php:16
8 (0.607)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ochs_tax_rule tr1
LEFT JOIN ochs_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ochs_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ochs_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ochs_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2701')
ORDER BY tr1.priority ASC
/home/farmaciileremedi/public_html/system/library/cart/tax.php:44
9 (0.915)
SELECT *
FROM ochs_weight_class wc
LEFT JOIN ochs_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/farmaciileremedi/public_html/system/library/cart/weight.php:10
10 (0.623)
SELECT *
FROM ochs_length_class mc
LEFT JOIN ochs_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/farmaciileremedi/public_html/system/library/cart/length.php:10
11 (0.800)
DELETE
FROM ochs_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/farmaciileremedi/public_html/system/library/cart/cart.php:15
12 (1.307)
SELECT *
FROM `ochs_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/farmaciileremedi/public_html/catalog/model/setting/event.php:4
13 (0.368)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
14 (1.022)
SELECT DISTINCT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '100830' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:4
15 (0.440)
SELECT DISTINCT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '100894' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:4
16 (0.731)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100894' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
17 (1.554)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM ochs_product_to_category p2c
LEFT JOIN ochs_product p ON (p2c.product_id = p.product_id)
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '100894'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:513
18 (3.649)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM ochs_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 ochs_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
FROM ochs_product_to_category p2c
LEFT JOIN ochs_product p ON (p2c.product_id = p.product_id)
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '100894' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:200
19 (3.241)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1110' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
20 (2.645)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2681' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
21 (1.771)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1160' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
22 (1.894)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1109' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
23 (1.831)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1161' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
24 (1.710)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1111' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
25 (1.392)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ochs_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 ochs_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, (SELECT points
FROM ochs_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM ochs_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ochs_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM ochs_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM ochs_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM ochs_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ochs_product p
LEFT JOIN ochs_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ochs_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ochs_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '918' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:8
26 (0.599)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100894' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
27 (0.601)
SELECT *
FROM ochs_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:4
28 (0.798)
SELECT *
FROM ochs_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:14
29 (0.289)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/category' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
30 (2.400)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
31 (2.339)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100830' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
32 (0.533)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'extension/module/category'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
33 (0.513)
SELECT *
FROM ochs_module
WHERE module_id = '30'
/home/farmaciileremedi/public_html/catalog/model/setting/module.php:4
34 (0.665)
SELECT *
FROM ochs_banner b
LEFT JOIN ochs_banner_image bi ON (b.banner_id = bi.banner_id)
WHERE b.banner_id = '6' AND b.status = '1' AND bi.language_id = '2'
ORDER BY bi.sort_order ASC
/home/farmaciileremedi/public_html/catalog/model/design/banner.php:4
35 (0.333)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'extension/module/banner'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
36 (0.398)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_left'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
37 (0.308)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100894' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
38 (0.377)
SELECT *
FROM ochs_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:4
39 (0.270)
SELECT *
FROM ochs_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:14
40 (0.293)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_right'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
41 (0.323)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100894' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
42 (0.335)
SELECT *
FROM ochs_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:4
43 (0.245)
SELECT *
FROM ochs_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:14
44 (0.322)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_top'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
45 (0.310)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100894' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
46 (0.354)
SELECT *
FROM ochs_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:4
47 (0.273)
SELECT *
FROM ochs_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/home/farmaciileremedi/public_html/catalog/model/design/layout.php:14
48 (0.316)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_bottom'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
49 (0.375)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
50 (1.897)
SELECT *
FROM ochs_information i
LEFT JOIN ochs_information_description id ON (i.information_id = id.information_id)
LEFT JOIN ochs_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/farmaciileremedi/public_html/catalog/model/catalog/information.php:10
51 (0.457)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/footer'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
52 (0.558)
SELECT *
FROM ochs_extension
WHERE `type` = 'analytics'
/home/farmaciileremedi/public_html/catalog/model/setting/extension.php:4
53 (0.300)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
54 (0.330)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
55 (0.357)
SELECT *
FROM ochs_language
WHERE status = '1'
ORDER BY sort_order, name
/home/farmaciileremedi/public_html/catalog/model/localisation/language.php:15
56 (0.460)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/language'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
57 (0.362)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
58 (0.428)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/currency'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
59 (0.362)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
60 (0.345)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/search'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
61 (0.419)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
62 (0.364)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '27fd5ac65cf89cbd085e7d08cd'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
63 (0.214)
SELECT *
FROM ochs_extension
WHERE `type` = 'total'
/home/farmaciileremedi/public_html/catalog/model/setting/extension.php:4
64 (0.318)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
65 (0.335)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '27fd5ac65cf89cbd085e7d08cd'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
66 (0.373)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '27fd5ac65cf89cbd085e7d08cd'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
67 (0.344)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/credit' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
68 (0.422)
SELECT SUM(amount) AS total
FROM ochs_customer_transaction
WHERE customer_id = '0'
/home/farmaciileremedi/public_html/system/library/cart/customer.php:122
69 (0.352)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
70 (0.357)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '27fd5ac65cf89cbd085e7d08cd'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
71 (0.370)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '27fd5ac65cf89cbd085e7d08cd'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
72 (0.342)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/cart'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
73 (0.384)
SELECT *
FROM ochs_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'ro-ro')
/home/farmaciileremedi/public_html/catalog/model/design/translation.php:6
74 (2.370)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
75 (1.098)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100834' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
76 (1.902)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100830' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
77 (1.059)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100842' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
78 (1.008)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100840' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
79 (1.279)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100810' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
80 (1.412)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100814' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
81 (1.788)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100836' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
82 (1.088)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100832' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
83 (0.961)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100838' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
84 (0.709)
SELECT *
FROM ochs_category c
LEFT JOIN ochs_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ochs_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '117306' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:10
85 (0.298)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/menu'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
86 (0.447)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/header'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
87 (0.531)
SELECT *
FROM ochs_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/farmaciileremedi/public_html/catalog/model/setting/setting.php:6
88 (0.350)
SELECT *
FROM ochs_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'product/category'
/home/farmaciileremedi/public_html/catalog/model/design/theme.php:4
89 (0.650)
SELECT *
FROM ochs_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/farmaciileremedi/public_html/catalog/model/setting/setting.php:6