Ingrijirea parului

ALPECIN SAMPON SENSITIV S1 250ML

ALPECIN SAMPON SENSITIV S1 250ML

Formula blanda, atat pentru scalp cat si pentru par. Complexul de ingrediente active pe baza de c..

29,85Lei Fără TVA: 25,08Lei

CHELSTOP LOTIUNE 200ML

CHELSTOP LOTIUNE 200ML

200 mlPrezentare:Se spală părul cu săpun moale vegetal. Se usucă părul și apoi se frecționează p..

16,50Lei Fără TVA: 13,87Lei

FARMEC ARGAN PLUS SAMPON JOJOBA 250ML 3500

FARMEC ARGAN PLUS SAMPON JOJOBA 250ML 3500

..

15,77Lei Fără TVA: 13,25Lei

FARMEC ARGAN PLUS SAMPON KERATINA 250ML 3510

FARMEC ARGAN PLUS SAMPON KERATINA 250ML 3510

..

15,77Lei Fără TVA: 13,25Lei

FARMEC ARGAN PLUS SAMPON ULEI MASLINE 250ML 3530

FARMEC ARGAN PLUS SAMPON ULEI MASLINE 250ML 3530

..

15,77Lei Fără TVA: 13,25Lei

FARMEC GEROVITAL TRATAMENT EXPERT-BALSAM NUTRITIV CU KERATINA  150ML 11050
FARMEC GEROVITAL TRATAMENT EXPERT-BALSAM PENTRU VOLUM    250ML 11590
FARMEC GEROVITAL TRATAMENT EXPERT-LOTIUNE REGENERANTA CU PETROLEUM  100ML 11440
FARMEC GEROVITAL TRATAMENT EXPERT-SAMPON ANTICADERE    250ML 11400
FARMEC GEROVITAL TRATAMENT EXPERT-SAMPON ANTIMATREATA  400ML 11520
FARMEC GEROVITAL TRATAMENT EXPERT-SAMPON REGENERANT    400ML 11060
FARMEC GEROVITAL TRATAMENT EXPERT-SAMPON REGENERANT   250ML 11470
FARMEC GEROVITAL TRATAMENT EXPERT-SAMPON REVITALIZANT CO WASH  150ML 11040
FARMEC GP SAMPON HIDRATANT 200ML  4700

FARMEC GP SAMPON HIDRATANT 200ML 4700

..

13,98Lei Fără TVA: 11,75Lei

Afişare 1 - 15 din 33 (3 pagini)
Queries: 96, Total time: 69.553 ms [By time] [By id] [By file]
1 (0.535)
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.057)
SELECT `data`
FROM `ochs_session`
WHERE session_id = '6b460e2d66e30657e4e85a04b9' AND expire > 1618397720
/home/farmaciileremedi/public_html/system/library/session/db.php:21
3 (0.413)
SELECT *
FROM ochs_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://farmaciileremedia.ro/'
/home/farmaciileremedi/public_html/catalog/controller/startup/startup.php:6
4 (3.340)
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.586)
SELECT *
FROM ochs_language
WHERE status = '1'
ORDER BY sort_order, name
/home/farmaciileremedi/public_html/catalog/model/localisation/language.php:15
6 (0.611)
SELECT *
FROM ochs_currency
/home/farmaciileremedi/public_html/system/library/cart/currency.php:10
7 (1.430)
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.587)
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.482)
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.407)
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.940)
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 (0.833)
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.404)
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.595)
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.703)
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 = '100898' 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 (1.004)
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 = '100898' 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 (3.491)
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 = '100898'
/home/farmaciileremedi/public_html/catalog/model/catalog/product.php:513
18 (6.085)
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 = '100898' 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 (2.268)
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 = '1199' 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 (1.316)
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 = '531' 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 (2.069)
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 = '1112' 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 (0.784)
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 = '1113' 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 (0.748)
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 = '1116' 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 (0.809)
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 = '1371' 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 (0.773)
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 = '1378' 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.823)
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 = '1375' 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
27 (0.775)
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 = '1374' 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
28 (0.768)
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 = '1377' 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
29 (0.784)
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 = '1372' 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
30 (0.809)
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 = '1376' 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
31 (0.795)
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 = '2682' 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
32 (0.809)
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 = '1373' 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
33 (0.705)
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 = '1189' 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
34 (0.590)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100898' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
35 (0.330)
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
36 (0.296)
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
37 (0.224)
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
38 (1.462)
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
39 (1.724)
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
40 (0.548)
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
41 (0.549)
SELECT *
FROM ochs_module
WHERE module_id = '30'
/home/farmaciileremedi/public_html/catalog/model/setting/module.php:4
42 (0.810)
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
43 (0.363)
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
44 (0.439)
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
45 (0.331)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100898' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
46 (0.333)
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.318)
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
48 (0.345)
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
49 (0.248)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100898' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
50 (0.261)
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
51 (0.435)
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
52 (0.362)
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
53 (0.242)
SELECT *
FROM ochs_category_to_layout
WHERE category_id = '100898' AND store_id = '0'
/home/farmaciileremedi/public_html/catalog/model/catalog/category.php:55
54 (0.248)
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
55 (0.233)
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
56 (0.283)
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
57 (0.261)
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
58 (1.473)
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
59 (0.325)
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
60 (0.357)
SELECT *
FROM ochs_extension
WHERE `type` = 'analytics'
/home/farmaciileremedi/public_html/catalog/model/setting/extension.php:4
61 (0.239)
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
62 (0.261)
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
63 (0.285)
SELECT *
FROM ochs_language
WHERE status = '1'
ORDER BY sort_order, name
/home/farmaciileremedi/public_html/catalog/model/localisation/language.php:15
64 (0.257)
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
65 (0.275)
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
66 (0.312)
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
67 (0.340)
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
68 (0.297)
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
69 (0.304)
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
70 (0.348)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6b460e2d66e30657e4e85a04b9'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
71 (0.291)
SELECT *
FROM ochs_extension
WHERE `type` = 'total'
/home/farmaciileremedi/public_html/catalog/model/setting/extension.php:4
72 (0.256)
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
73 (0.325)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6b460e2d66e30657e4e85a04b9'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
74 (0.394)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6b460e2d66e30657e4e85a04b9'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
75 (0.349)
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
76 (0.314)
SELECT SUM(amount) AS total
FROM ochs_customer_transaction
WHERE customer_id = '0'
/home/farmaciileremedi/public_html/system/library/cart/customer.php:122
77 (0.267)
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
78 (0.363)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6b460e2d66e30657e4e85a04b9'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
79 (0.262)
SELECT *
FROM ochs_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '6b460e2d66e30657e4e85a04b9'
/home/farmaciileremedi/public_html/system/library/cart/cart.php:36
80 (0.277)
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
81 (0.338)
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
82 (1.920)
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
83 (0.676)
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
84 (1.060)
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
85 (0.650)
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
86 (0.593)
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
87 (0.700)
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
88 (0.719)
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
89 (0.925)
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
90 (0.686)
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
91 (0.583)
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
92 (0.256)
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
93 (0.251)
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
94 (0.679)
SELECT *
FROM ochs_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/farmaciileremedi/public_html/catalog/model/setting/setting.php:6
95 (0.266)
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
96 (0.307)
SELECT *
FROM ochs_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/farmaciileremedi/public_html/catalog/model/setting/setting.php:6