Wysoka jakość

Szybka wysyłka

Bezpieczne zakupy

toppasek

infolinialeft

POTRZEBUJESZ POMOCY?

Nasza infolinia jest do Twojej dyspozycji od pon. do pt. w godz. 7:00-15:00

504 132 011

Koszt połączenia według taryfy operatora

infoliniaright

Ekspresowa wysyłka

Wszystkie produkty mamy we własnych magazynach, dlatego zamówienia złożone i opłacone do 12:00 wysyłamy już tego samego dnia, pozostałe w 24 godziny.

Zawsze bezpiecznie

Nasz cel to udane i pewne zakupy. Płatności i dane są u nas bezpieczne. Dzięki mocnym kartonom przesyłka przyjdzie nienaruszona.

Bezproblemowe zwroty

Na zwrot zakupionego towaru, bez podania przyczyny, dajemy aż 30 dni. Pamiętaj odesłać towar w nienaruszonym stanie, z dowodem zakupu.

Zapraszamy do współpracy hurtowej

E-mail: hurt@pakojeans.pl
kom. 504 132 014

toppasek

infolinialeft

POTRZEBUJESZ POMOCY?

Nasza infolinia jest do Twojej dyspozycji od pon. do pt. w godz. 7:00-15:00

504 132 011

Koszt połączenia według taryfy operatora

infoliniaright

Ekspresowa wysyłka

Wszystkie produkty mamy we własnych magazynach, dlatego zamówienia złożone i opłacone do 12:00 wysyłamy już tego samego dnia, pozostałe w 24 godziny.

Zawsze bezpiecznie

Nasz cel to udane i pewne zakupy. Płatności i dane są u nas bezpieczne. Dzięki mocnym kartonom przesyłka przyjdzie nienaruszona.

Bezproblemowe zwroty

Na zwrot zakupionego towaru, bez podania przyczyny, dajemy aż 30 dni. Pamiętaj odesłać towar w nienaruszonym stanie, z dowodem zakupu.

Zapraszamy do współpracy hurtowej

E-mail: hurt@pakojeans.pl
kom. 504 132 014

Ulubione

Nakrycia głowy

Podkategoria

Niezwykły duet składający się z kaszkietu męskiego i szalika to esencja elegancji i stylu dla mężczyzn. Kaszkiet wykonany ze skóry ekologicznej nie tylko dodaje modowego sznytu, ale także spełnia praktyczne funkcje, podkreślając indywidualny gust noszącego. Szalik, będący nie...

DODAJ PODGLĄD

Load Time	2006 ms - You'd better run your shop on a toaster
Querying Time	667 ms
Queries	1334
Memory Peak Usage	43.5 Mb
Included Files	1160 files - 11.84 Mb
PrestaShop Cache	- Mb
Global vars	0.88 Mb
- global $_MODULES	552k
- global $smarty	159k
- global $_MODULE	142k
- global $context	16k
- global $__composer_autoload_files	13k
- global $_SERVER	6k
- global $exportPhpConfigFile	4k
- global $config	3k

PrestaShop Version	1.7.6.9
PHP Version	7.2.34 (OK)
MySQL Version	10.6.17-MariaDB-cll-lve (OK)
Memory Limit	128M
Max Execution Time	180s
Smarty Cache	enabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	41 ms	41 ms	4.04 Mb	4.07 Mb
__construct	0 ms	41 ms	- Mb	4.07 Mb
init	29 ms	70 ms	1.76 Mb	5.85 Mb
checkAccess	0 ms	70 ms	- Mb	5.85 Mb
setMedia	6 ms	77 ms	0.41 Mb	6.22 Mb
postProcess	0 ms	77 ms	- Mb	6.22 Mb
initHeader	0 ms	77 ms	- Mb	6.22 Mb
initContent	732 ms	809 ms	18.53 Mb	24.88 Mb
initFooter	0 ms	809 ms	- Mb	24.88 Mb
display	1197 ms	2006 ms	17.81 Mb	43.51 Mb

108	SELECT * FROM `pr_jxmegalayout_items` a WHERE (a.`id_item` = XX) LIMIT XX
86	SELECT * FROM `pr_category` a LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
54	SELECT SUM(quantity) FROM `pr_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
54	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `pr_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `pr_cart_product` cp JOIN `pr_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pr_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
48	SELECT c., cl. FROM `pr_category` c INNER JOIN pr_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `pr_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = XX RIGHT JOIN `pr_category` cXX ON cXX.`id_category` = XX AND c.`nleft` >= cXX.`nleft` AND c.`nright` <= cXX.`nright` WHERE XX AND `id_lang` = XX AND c.`active` = XX ORDER BY c.`level_depth` ASC , category_shop.`position` ASC
47	SELECT XX FROM `pr_specific_price` WHERE id_product = XX LIMIT XX
47	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `pr_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
46	SELECT name FROM pr_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
46	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `pr_product_attribute` pa INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN pr_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
46	SELECT product_attribute_shop.id_product_attribute FROM pr_product_attribute pa INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
46	SELECT `id_product_attribute` FROM `pr_product_attribute` WHERE `id_product` = XX
46	SELECT p., pl., sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM pr_product p LEFT JOIN pr_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN pr_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX WHERE p.id_product = XX
46	SELECT name, value, pf.id_feature, f.position FROM pr_feature_product pf LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN pr_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
46	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `pr_image` i INNER JOIN pr_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
46	SELECT COUNT(*) FROM `pr_pack` WHERE id_product_pack = XX LIMIT XX
46	SELECT * FROM `pr_product` a LEFT JOIN `pr_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `pr_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
46	SELECT `reduction` FROM `pr_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
46	SELECT `id_tax_rules_group` FROM `pr_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
46	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `pr_product` p INNER JOIN `pr_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `pr_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
46	SELECT `priority`, `id_specific_price_priority` FROM `pr_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
21	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category='XX' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY fp.id_feature_value
18	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `pr_attribute_group` ag INNER JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `pr_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN pr_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN pr_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `pr_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
18	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND cp.id_category='XX' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY pac.id_attribute
14	SELECT jeh., jehl. FROM pr_jxmegalayout_extra_html jeh LEFT JOIN pr_jxmegalayout_extra_html_lang jehl ON(jeh.`id_extra_html` = jehl.`id_extra_html`) WHERE jeh.`id_extra_html` = XX AND jehl.`id_lang` = XX LIMIT XX
9	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `pr_feature_value` v LEFT JOIN `pr_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `pr_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
8	SELECT product_attribute_shop.id_product_attribute FROM pr_product_attribute pa INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
8	SELECT product_attribute_shop.`price` FROM `pr_product_attribute` pa INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
8	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc` FROM `pr_attribute` a LEFT JOIN `pr_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `pr_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `pr_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `pr_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
8	SELECT `settings` FROM pr_jxmegamenu_items WHERE `id_tab` = XX
8	SELECT * FROM `pr_product_attribute` a LEFT JOIN `pr_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
8	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `pr_product_attribute_image` pai LEFT JOIN `pr_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `pr_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
8	SELECT pa.`available_date` FROM `pr_product` p LEFT JOIN `pr_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN pr_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
5	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `pr_module` m LEFT JOIN `pr_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
4	SELECT * FROM pr_jxmegamenu_items WHERE `id_tab` = XX AND `row` = XX AND `is_mega` = XX ORDER BY `col`
4	SELECT `row` FROM pr_jxmegamenu_items WHERE `id_tab` = XX AND `is_mega` = XX ORDER BY `id`
4	SELECT * FROM pr_jxmegamenu WHERE `id_shop` =XX AND `id_item` = XX AND `is_simple` = XX
3	SELECT `need_identification_number` FROM `pr_country` WHERE `id_country` = XX LIMIT XX
2	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `pr_module` m LEFT JOIN `pr_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "jxblog" AND ms.`id_shop` IN (XX) LIMIT XX
2	SELECT psgdpr.active FROM `pr_psgdpr_consent` psgdpr WHERE psgdpr.id_module = XX LIMIT XX
2	(SELECT XX FROM `pr_cart_rule` WHERE date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `pr_cart_rule` WHERE date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `pr_cart_rule` WHERE date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX) LIMIT XX
2	SELECT tr.* FROM `pr_tax_rule` tr JOIN `pr_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX-XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX-XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2	SELECT jx.*, jxl.`title`, jxl.`badge`, jxl.`url` FROM `pr_jxmegamenu` jx LEFT JOIN `pr_jxmegamenu_lang` jxl ON (jx.`id_item` = jxl.`id_item`) WHERE jx.`id_shop` = XX AND jx.`hook_name` = "displayTop" AND jxl.`id_lang` = XX AND jx.`active` = XX ORDER BY jx.`sort_order`
2	SELECT * FROM `pr_hook_alias`
2	SELECT * FROM pr_jxmegalayout_items WHERE `id_layout` = XX
2	SELECT `id_module` FROM `pr_module` WHERE `name` = "jxblog" LIMIT XX
2	SELECT `id_module` FROM `pr_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
2	SELECT psgdprl.message FROM `pr_psgdpr_consent` psgdpr LEFT JOIN pr_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent) WHERE psgdpr.id_module = XX AND psgdprl.id_lang =XX LIMIT XX
2	(SELECT SQL_NO_CACHE * FROM `pr_cart_rule` cr LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`id_customer` = XX AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = XX AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `pr_cart_rule` cr LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = XX) WHERE cr.`group_restriction` = XX AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = XX AND cr.`quantity` > XX AND highlight = XX AND code NOT LIKE "BO_ORDER_%")

Name	Instances	Source
Product	138	/classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /src/Adapter/Image/ImageRetriever.php [63] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106] /classes/Link.php [106]
JXMegaLayoutItems	108	/modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888] /modules/jxmegalayout/jxmegalayout.php [2888]
Category	100	/controllers/front/listing/CategoryController.php [85] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /controllers/front/listing/CategoryController.php [200] /classes/Meta.php [379] /classes/Link.php [386] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /modules/jxsearch/jxsearch.php [516] /modules/ps_facetedsearch/src/Filters/Block.php [157] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386] /classes/Link.php [386]
Combination	46	/classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948] /classes/Product.php [4948]
Language	6	/config/config.inc.php [194] /classes/Tools.php [579] /modules/jxblog/jxblog.php [69] /modules/jxblog/jxblog.php [69] /modules/jxblogcomment/jxblogcomment.php [61] /modules/jxblog/jxblog.php [69]
Country	6	/config/config.inc.php [141] /classes/controller/FrontController.php [341] /classes/AddressFormat.php [357] /classes/controller/FrontController.php [1623] /classes/AddressFormat.php [357] /modules/ps_contactinfo/ps_contactinfo.php [99]
Address	4	/classes/shop/Shop.php [467] /classes/Product.php [3201] /classes/Product.php [3310] /classes/Product.php [4970]
AddressFormat	3	/classes/controller/FrontController.php [1617] /modules/jxheaderaccount/jxheaderaccount.php [744] /modules/ps_contactinfo/ps_contactinfo.php [93]
MegaMenu	2	/modules/jxmegamenu/jxmegamenu.php [92] /modules/jxmegamenu/jxmegamenu.php [2795]
State	2	/classes/controller/FrontController.php [1622] /modules/ps_contactinfo/ps_contactinfo.php [98]
Tax	2	/classes/tax/TaxRulesTaxManager.php [115] /classes/tax/TaxRulesTaxManager.php [115]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php [101] /classes/Tools.php [703]
Customer	2	/config/config.inc.php [220] /modules/jxheaderaccount/jxheaderaccount.php [911]
MegaMenuVideo	1	/modules/jxmegamenu/jxmegamenu.php [96]
CustomerAddress	1	/classes/Address.php [165]
Guest	1	/modules/statsdata/statsdata.php [83]
MegaMenuMap	1	/modules/jxmegamenu/jxmegamenu.php [97]
Shop	1	/config/config.inc.php [119]
MegaMenuBanner	1	/modules/jxmegamenu/jxmegamenu.php [95]
MegaMenuLink	1	/modules/jxmegamenu/jxmegamenu.php [94]
MegaMenuHtml	1	/modules/jxmegamenu/jxmegamenu.php [93]
Risk	1	/classes/controller/FrontController.php [1587]
Gender	1	/classes/controller/FrontController.php [1584]
Group	1	/classes/Cart.php [245]
Cart	1	/classes/controller/FrontController.php [410]
ShopGroup	1	/classes/shop/Shop.php [551]
Connection	1	/modules/statsdata/statsdata.php [117]

Query	Time (ms)	Rows	Filesort	Group By	Location
SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' GROUP BY p.id_product) p INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>155 AND c.nright<196 GROUP BY cp.id_category	16.1	72576	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:992 /modules/ps_facetedsearch/src/Filters/Block.php:158 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=8)) GROUP BY fp.id_feature_value	12.5	1790	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=3)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	8.8	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_add DESC, p.id_product DESC LIMIT 0, 96	7.4	1239040000	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 /modules/ps_facetedsearch/src/Product/SearchProvider.php:188 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=9)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	7.2	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((fp_1.id_feature_value IN (239, 31)))	6.2	664			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 /modules/ps_facetedsearch/src/Filters/Block.php:480 /modules/ps_facetedsearch/src/Filters/Block.php:140 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31)))	6.1	664			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 /modules/ps_facetedsearch/src/Filters/Products.php:94 /modules/ps_facetedsearch/src/Product/SearchProvider.php:188 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	6	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=27)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	5.9	1408	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `pr_specific_price` WHERE `id_product` != 0 LIMIT 1	5.3	2447			/classes/SpecificPrice.php:283 /classes/SpecificPrice.php:341 /classes/SpecificPrice.php:529 /classes/Product.php:3342 /classes/Product.php:3242 /classes/Product.php:4787 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:56 :undefined /classes/controller/ProductListingFrontController.php:78 /classes/controller/ProductListingFrontController.php:326 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=4)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	5.1	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((fp_1.id_feature_value IN (239, 31)))	4.9	664			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 /modules/ps_facetedsearch/src/Filters/Block.php:494 /modules/ps_facetedsearch/src/Filters/Block.php:140 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) GROUP BY p.condition	4.7	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:394 /modules/ps_facetedsearch/src/Filters/Block.php:137 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=7)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	4.6	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `pr_module` m INNER JOIN pr_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `pr_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `pr_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `pr_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	4.4	206	Yes	Yes	/classes/Hook.php:670 /classes/Hook.php:775 /classes/Dispatcher.php:593 /classes/Dispatcher.php:249 /classes/Dispatcher.php:207 /index.php:28
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value IN (239, 31)))	4.3	664			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 /modules/ps_facetedsearch/src/Filters/Block.php:505 /modules/ps_facetedsearch/src/Filters/Block.php:140 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) GROUP BY p.id_manufacturer	3.9	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:661 /modules/ps_facetedsearch/src/Filters/Block.php:146 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=10)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	3.6	2832	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	3.5	2600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=5)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	3.4	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE c., cl. FROM `pr_category` c INNER JOIN pr_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `pr_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 RIGHT JOIN `pr_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	3.3	109	Yes		/classes/Category.php:783 /modules/jxsearch/jxsearch.php:517 /modules/jxsearch/jxsearch.php:673 /classes/Hook.php:970 /override/classes/Hook.php:25 /classes/Hook.php:359 /classes/Hook.php:907 /classes/controller/FrontController.php:556 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	3.2	2032	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=23)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	3.2	1872	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM pr_product p INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125'	3.2	35200			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:751 /modules/ps_facetedsearch/src/Filters/Block.php:339 /modules/ps_facetedsearch/src/Filters/Block.php:134 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=11)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	3	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `pr_configuration` c LEFT JOIN `pr_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.9	923			/classes/Configuration.php:160 /classes/Configuration.php:209 /classes/Configuration.php:289 /classes/shop/Shop.php:382 /config/config.inc.php:119 /index.php:27
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=8)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	2.7	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=5)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	2.7	1880	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=7)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	2.7	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=1)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	2.5	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=19)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	2.5	720	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=2)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	2.3	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active FROM `pr_hook_module` hm STRAIGHT_JOIN `pr_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `pr_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.2	589			/classes/Hook.php:407 /classes/Hook.php:449 /classes/tax/TaxManagerFactory.php:67 /classes/tax/TaxManagerFactory.php:46 /classes/Product.php:3421 /classes/Product.php:3242 /classes/Product.php:4787 /classes/ProductAssembler.php:112 /classes/controller/ProductListingFrontController.php:56 :undefined /classes/controller/ProductListingFrontController.php:78 /classes/controller/ProductListingFrontController.php:326 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=6)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	2.1	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=16)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	2.1	488	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE * FROM `pr_jxmegalayout_items` a WHERE (a.`id_item` = 296) LIMIT 1	2	1			/src/Adapter/EntityMapper.php:75 /classes/ObjectModel.php:264 /tools/profiling/ObjectModel.php:33 /modules/jxmegalayout/jxmegalayout.php:2888 /modules/jxmegalayout/jxmegalayout.php:2971 /classes/Hook.php:970 /override/classes/Hook.php:25 /classes/Hook.php:359 /classes/Hook.php:907 /classes/controller/FrontController.php:556 /controllers/front/listing/CategoryController.php:130 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM pr_product p INNER JOIN pr_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 14) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125'	1.9	35200			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 /modules/ps_facetedsearch/src/Filters/Block.php:250 /modules/ps_facetedsearch/src/Filters/Block.php:131 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=17)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	1.9	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pr_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((a.id_attribute_group=20)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY pac.id_attribute	1.9	664	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:737 /modules/ps_facetedsearch/src/Filters/Block.php:150 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM pr_product p LEFT JOIN pr_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pr_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pr_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pr_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pr_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pr_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pr_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pr_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pr_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (239, 31))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='1125' GROUP BY p.id_product) p INNER JOIN pr_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pr_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (239, 31))) GROUP BY fp.id_feature_value	1.8	424	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 /modules/ps_facetedsearch/src/Filters/Block.php:855 /modules/ps_facetedsearch/src/Filters/Block.php:154 /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 /classes/controller/ProductListingFrontController.php:309 /classes/controller/ProductListingFrontController.php:581 /controllers/front/listing/CategoryController.php:137 /tools/profiling/Controller.php:233 /classes/Dispatcher.php:515 /index.php:28

#	Filename
1	/index.php
2	/config/config.inc.php
3	/config/defines.inc.php
4	/config/autoload.php
5	/vendor/autoload.php
6	/vendor/composer/autoload_real.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-ctype/bootstrap.php
11	/vendor/react/promise/src/functions_include.php
12	/vendor/react/promise/src/functions.php
13	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
14	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
15	/vendor/paragonie/random_compat/lib/random.php
16	/vendor/symfony/polyfill-php70/bootstrap.php
17	/vendor/symfony/polyfill-php56/bootstrap.php
18	/vendor/symfony/polyfill-mbstring/bootstrap.php
19	/vendor/symfony/polyfill-intl-icu/bootstrap.php
20	/vendor/symfony/polyfill-apcu/bootstrap.php
21	/vendor/markbaker/matrix/classes/src/functions/adjoint.php
22	/vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
23	/vendor/markbaker/matrix/classes/src/functions/cofactors.php
24	/vendor/markbaker/matrix/classes/src/functions/determinant.php
25	/vendor/markbaker/matrix/classes/src/functions/diagonal.php
26	/vendor/markbaker/matrix/classes/src/functions/identity.php
27	/vendor/markbaker/matrix/classes/src/functions/inverse.php
28	/vendor/markbaker/matrix/classes/src/functions/minors.php
29	/vendor/markbaker/matrix/classes/src/functions/trace.php
30	/vendor/markbaker/matrix/classes/src/functions/transpose.php
31	/vendor/markbaker/matrix/classes/src/operations/add.php
32	/vendor/markbaker/matrix/classes/src/operations/directsum.php
33	/vendor/markbaker/matrix/classes/src/operations/subtract.php
34	/vendor/markbaker/matrix/classes/src/operations/multiply.php
35	/vendor/markbaker/matrix/classes/src/operations/divideby.php
36	/vendor/markbaker/matrix/classes/src/operations/divideinto.php
37	/vendor/markbaker/complex/classes/src/functions/abs.php
38	/vendor/markbaker/complex/classes/src/functions/acos.php
39	/vendor/markbaker/complex/classes/src/functions/acosh.php
40	/vendor/markbaker/complex/classes/src/functions/acot.php

POTRZEBUJESZ POMOCY?

Newsletter

POTRZEBUJESZ POMOCY?

Zaloguj się

Utwórz konto

Nie pamiętasz hasła?

Nakrycia głowy

Podkategoria

Włączone filtry:

Popularne kategorie: