1 (0.174)
SELECT data
FROM `oc_session`
WHERE session_id = 'cde1dc9332329c7efb602307a2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.156)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.817)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (162.842)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN (192)), 1, 0)) > 0, 1, 0) AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '2' AND p.manufacturer_id = '192' AND (pd.tag LIKE "%1-7gr%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (53.731)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN (192)), 1, 0)) > 0, 1, 0) AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '2' AND p.manufacturer_id = '192' AND (pd.tag LIKE "%1-7gr%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (2,944.196)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, agd.name AS group_name, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN ( SELECT p.*
FROM `oc_product` AS p
WHERE p.manufacturer_id = '192') AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
INNER JOIN `oc_attribute_group` AS ag ON (ag.attribute_group_id = a.attribute_group_id)
INNER JOIN `oc_attribute_group_description` AS agd ON (agd.attribute_group_id = a.attribute_group_id)
INNER JOIN `oc_product_to_store` AS ps ON (p.product_id = ps.product_id)
WHERE agd.language_id = '2' AND ad.language_id = '2' AND av.language_id = '2' AND ps.store_id = '2' AND p.status = 1 GROUP BY av.attribute_value_id
ORDER BY ag.sort_order, ag.attribute_group_id, a.sort_order, ad.name, av.sort_order, av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
7 (0.206)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)),
LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1169
8 (0.160)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '2' AND p.manufacturer_id = '192' AND (pd.tag LIKE "%1-7gr%") AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1000
9 (0.164)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:915
10 (0.108)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:954
11 (0.123)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (6.405)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (2.445)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38