Warning: Trying to access array offset on null in /var/www/vhosts/santehdom.net/httpdocs/var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/4c/9c/c2/4c9cc26a77575249173f0169f27b1b952f7bc929_2.file.category-header.tpl.php on line 27

Warning: Trying to access array offset on null in /var/www/vhosts/santehdom.net/httpdocs/var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/4c/9c/c2/4c9cc26a77575249173f0169f27b1b952f7bc929_2.file.category-header.tpl.php on line 27

Home

Подкатегории

Товаров: 488.

Сортировать по:

Load Time	776.250 ms
Querying Time	485 ms
Queries	777
Memory Peak Usage	21.7 Mb
Included Files	1051 files - 9.99 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $_MODULES	1k
- global $__composer_autoload_files	1k

PrestaShop Version	8.2.8
PHP Version	8.3.35
MySQL Version	10.3.39-MariaDB-0ubuntu0.20.04.2
Memory Limit	256M
Max Execution Time	120s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	43.788 ms	43.788 ms	1.95 Mb	1.9 Mb
__construct	1.329 ms	45.117 ms	- Mb	2.5 Mb
init	14.196 ms	59.313 ms	0.84 Mb	2.9 Mb
checkAccess	0.001 ms	59.314 ms	- Mb	2.9 Mb
setMedia	5.981 ms	65.295 ms	0.35 Mb	3.1 Mb
postProcess	0.001 ms	65.296 ms	- Mb	3.1 Mb
initHeader	0.001 ms	65.297 ms	- Mb	3.1 Mb
initContent	565.001 ms	630.298 ms	10.63 Mb	16.7 Mb
initFooter	0.002 ms	630.300 ms	- Mb	16.7 Mb
display	145.950 ms	776.250 ms	6.30 Mb	21.7 Mb

Hook	Time	Memory Usage
displayProductListReviews	29.084 ms	0.32 Mb
=> productcomments (widget)	16.494 ms	0.25 Mb
=> productcomments (widget)	0.475 ms	- Mb
=> productcomments (widget)	0.488 ms	- Mb
=> productcomments (widget)	0.486 ms	- Mb
=> productcomments (widget)	0.471 ms	- Mb
=> productcomments (widget)	0.496 ms	- Mb
=> productcomments (widget)	0.729 ms	- Mb
=> productcomments (widget)	0.728 ms	- Mb
=> productcomments (widget)	0.470 ms	- Mb
=> productcomments (widget)	0.469 ms	- Mb
=> productcomments (widget)	0.473 ms	- Mb
=> productcomments (widget)	0.466 ms	- Mb
=> productcomments (widget)	0.513 ms	- Mb
=> productcomments (widget)	0.468 ms	- Mb
=> productcomments (widget)	0.475 ms	- Mb
=> productcomments (widget)	0.474 ms	- Mb
=> productcomments (widget)	0.468 ms	- Mb
=> productcomments (widget)	0.466 ms	- Mb
=> productcomments (widget)	0.480 ms	- Mb
=> productcomments (widget)	0.879 ms	- Mb
=> productcomments (widget)	0.884 ms	- Mb
=> productcomments (widget)	0.626 ms	- Mb
=> productcomments (widget)	0.469 ms	- Mb
=> productcomments (widget)	0.637 ms	- Mb
DisplayMegamenu	23.185 ms	0.04 Mb
=> posmegamenu	23.185 ms	0.04 Mb
RotatorImg	15.818 ms	1.33 Mb
=> posrotatorimg	0.711 ms	0.07 Mb
=> posrotatorimg	0.765 ms	0.06 Mb
=> posrotatorimg	0.680 ms	0.05 Mb
=> posrotatorimg	0.703 ms	0.05 Mb
=> posrotatorimg	0.660 ms	0.05 Mb
=> posrotatorimg	0.655 ms	0.05 Mb
=> posrotatorimg	0.821 ms	0.05 Mb
=> posrotatorimg	0.815 ms	0.05 Mb
=> posrotatorimg	0.599 ms	0.05 Mb
=> posrotatorimg	0.603 ms	0.05 Mb
=> posrotatorimg	0.603 ms	0.05 Mb
=> posrotatorimg	0.608 ms	0.05 Mb
=> posrotatorimg	0.591 ms	0.05 Mb
=> posrotatorimg	0.579 ms	0.05 Mb
=> posrotatorimg	0.584 ms	0.05 Mb
=> posrotatorimg	0.579 ms	0.05 Mb
=> posrotatorimg	0.678 ms	0.05 Mb
=> posrotatorimg	0.674 ms	0.05 Mb
=> posrotatorimg	0.679 ms	0.05 Mb
=> posrotatorimg	0.718 ms	0.05 Mb
=> posrotatorimg	0.712 ms	0.05 Mb
=> posrotatorimg	0.553 ms	0.05 Mb
=> posrotatorimg	0.629 ms	0.05 Mb
=> posrotatorimg	0.619 ms	0.05 Mb
displayLeftColumn	11.893 ms	1.40 Mb
=> ps_categorytree (widget)	10.839 ms	1.35 Mb
=> ps_advertising (widget)	1.054 ms	0.05 Mb
DisplayProductListFunctionalButtons	10.087 ms	0.10 Mb
=> blockwishlist	0.454 ms	- Mb
=> blockwishlist	0.375 ms	- Mb
=> blockwishlist	0.373 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.372 ms	- Mb
=> blockwishlist	0.563 ms	- Mb
=> blockwishlist	0.558 ms	- Mb
=> blockwishlist	0.580 ms	- Mb
=> blockwishlist	0.372 ms	- Mb
=> blockwishlist	0.373 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.372 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.378 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.474 ms	- Mb
=> blockwishlist	0.576 ms	- Mb
=> blockwishlist	0.557 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
displayProductListCompare	8.176 ms	0.03 Mb
=> poscompare (widget)	0.326 ms	- Mb
=> poscompare (widget)	0.312 ms	- Mb
=> poscompare (widget)	0.306 ms	- Mb
=> poscompare (widget)	0.304 ms	- Mb
=> poscompare (widget)	0.310 ms	- Mb
=> poscompare (widget)	0.458 ms	- Mb
=> poscompare (widget)	0.456 ms	- Mb
=> poscompare (widget)	0.338 ms	- Mb
=> poscompare (widget)	0.304 ms	- Mb
=> poscompare (widget)	0.303 ms	- Mb
=> poscompare (widget)	0.314 ms	- Mb
=> poscompare (widget)	0.303 ms	- Mb
=> poscompare (widget)	0.305 ms	- Mb
=> poscompare (widget)	0.304 ms	- Mb
=> poscompare (widget)	0.309 ms	- Mb
=> poscompare (widget)	0.305 ms	- Mb
=> poscompare (widget)	0.310 ms	- Mb
=> poscompare (widget)	0.303 ms	- Mb
=> poscompare (widget)	0.456 ms	- Mb
=> poscompare (widget)	0.456 ms	- Mb
=> poscompare (widget)	0.465 ms	- Mb
=> poscompare (widget)	0.304 ms	- Mb
=> poscompare (widget)	0.306 ms	- Mb
=> poscompare (widget)	0.319 ms	- Mb
displayTop	8.023 ms	0.71 Mb
=> posstaticblocks (widget)	0.873 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.870 ms	0.07 Mb
=> poscompare (widget)	0.565 ms	0.04 Mb
=> possearchproducts (widget)	5.715 ms	0.57 Mb
DisplayFooter	2.446 ms	0.13 Mb
=> blockwishlist	2.005 ms	0.12 Mb
=> rozershowall	0.438 ms	0.01 Mb
=> rozerhomereviews	0.003 ms	- Mb
displayNav	2.364 ms	0.16 Mb
=> ps_languageselector (widget)	0.741 ms	0.05 Mb
=> ps_currencyselector (widget)	0.193 ms	0.04 Mb
=> ps_customersignin (widget)	0.553 ms	0.04 Mb
=> posstaticblocks (widget)	0.877 ms	0.03 Mb
DisplayHeader	2.343 ms	0.04 Mb
=> ps_shoppingcart	0.039 ms	- Mb
=> productcomments	0.226 ms	- Mb
=> ps_googleanalytics	0.086 ms	- Mb
=> posslideshows	0.226 ms	- Mb
=> poslistcategories	0.106 ms	- Mb
=> poslogo	0.056 ms	- Mb
=> poslistcateproduct	0.567 ms	0.01 Mb
=> posrecommendedproducts	0.061 ms	- Mb
=> rozeroneclick	0.002 ms	- Mb
=> rozershowall	0.168 ms	- Mb
=> rozerhomereviews	0.002 ms	- Mb
=> posrotatorimg	0.804 ms	0.02 Mb
displayBanner	1.691 ms	0.12 Mb
=> posstaticblocks (widget)	1.691 ms	0.12 Mb
ActionFrontControllerSetMedia	1.505 ms	0.01 Mb
=> blockreassurance	0.452 ms	- Mb
=> blockwishlist	0.693 ms	- Mb
=> ps_emailsubscription	0.107 ms	- Mb
=> ps_socialfollow	0.170 ms	- Mb
=> ps_emailalerts	0.083 ms	- Mb
Header	1.503 ms	0.08 Mb
=> poscompare	0.172 ms	- Mb
=> possearchproducts	0.450 ms	- Mb
=> posthemeoptions	0.215 ms	0.07 Mb
=> posmegamenu	0.239 ms	- Mb
=> posvegamenu	0.244 ms	- Mb
=> posfeaturedproducts	0.057 ms	- Mb
=> posnewproducts	0.056 ms	- Mb
=> postabproductslider	0.070 ms	- Mb
displayFooter	1.209 ms	0.08 Mb
=> posstaticfooter (widget)	1.209 ms	0.08 Mb
displayFooterAfter	0.868 ms	0.03 Mb
=> posstaticfooter (widget)	0.868 ms	0.03 Mb
ProductSearchProvider	0.785 ms	- Mb
=> ps_facetedsearch	0.785 ms	- Mb
DisplayLeftColumn	0.580 ms	0.60 Mb
=> ps_facetedsearch	0.580 ms	0.60 Mb
DisplayTop	0.444 ms	- Mb
=> blockwishlist	0.444 ms	- Mb
displayBeforeBodyClosingTag	0.362 ms	0.01 Mb
=> poscompare (widget)	0.362 ms	0.01 Mb
FilterProductSearch	0.003 ms	- Mb
=> rozershowall	0.003 ms	- Mb
ActionProductSearchProviderRunQueryBefore	0.002 ms	- Mb
=> rozershowall	0.002 ms	- Mb
ActionFrontControllerSetVariables	0.001 ms	- Mb
=> productcomments	0.001 ms	- Mb
22 hook(s)	122.371 ms	5.20 Mb

Module	Time	Memory Usage
blockreassurance	1.640 ms	0.14 Mb
__construct	1.186 ms	0.13 Mb
hookActionFrontControllerSetMedia	0.454 ms	0.01 Mb
blockwishlist	13.561 ms	0.24 Mb
__construct	0.295 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.695 ms	- Mb
hookDisplayTop	0.446 ms	0.01 Mb
hookDisplayProductListFunctionalButtons	0.455 ms	0.01 Mb
hookDisplayProductListFunctionalButtons	0.376 ms	- Mb
hookDisplayProductListFunctionalButtons	0.374 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.373 ms	- Mb
hookDisplayProductListFunctionalButtons	0.565 ms	- Mb
hookDisplayProductListFunctionalButtons	0.560 ms	- Mb
hookDisplayProductListFunctionalButtons	0.582 ms	- Mb
hookDisplayProductListFunctionalButtons	0.373 ms	- Mb
hookDisplayProductListFunctionalButtons	0.375 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.373 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.379 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.475 ms	- Mb
hookDisplayProductListFunctionalButtons	0.578 ms	- Mb
hookDisplayProductListFunctionalButtons	0.559 ms	- Mb
hookDisplayProductListFunctionalButtons	0.373 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayFooter	2.006 ms	0.12 Mb
ps_emailsubscription	0.342 ms	0.01 Mb
__construct	0.234 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.108 ms	- Mb
ps_socialfollow	0.391 ms	0.01 Mb
__construct	0.220 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.171 ms	- Mb
ps_emailalerts	0.367 ms	0.01 Mb
__construct	0.283 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.084 ms	- Mb
productcomments	29.510 ms	0.34 Mb
__construct	0.169 ms	0.01 Mb
hookActionFrontControllerSetVariables	0.002 ms	- Mb
hookDisplayHeader	0.227 ms	- Mb
displayProductListReviews	16.497 ms	0.25 Mb
displayProductListReviews	0.476 ms	- Mb
displayProductListReviews	0.489 ms	- Mb
displayProductListReviews	0.487 ms	- Mb
displayProductListReviews	0.472 ms	- Mb
displayProductListReviews	0.497 ms	- Mb
displayProductListReviews	0.731 ms	- Mb
displayProductListReviews	0.730 ms	- Mb
displayProductListReviews	0.471 ms	- Mb
displayProductListReviews	0.470 ms	- Mb
displayProductListReviews	0.474 ms	- Mb
displayProductListReviews	0.467 ms	- Mb
displayProductListReviews	0.514 ms	- Mb
displayProductListReviews	0.469 ms	- Mb
displayProductListReviews	0.476 ms	- Mb
displayProductListReviews	0.475 ms	- Mb
displayProductListReviews	0.469 ms	- Mb
displayProductListReviews	0.467 ms	- Mb
displayProductListReviews	0.481 ms	- Mb
displayProductListReviews	0.881 ms	- Mb
displayProductListReviews	0.885 ms	- Mb
displayProductListReviews	0.627 ms	- Mb
displayProductListReviews	0.470 ms	- Mb
displayProductListReviews	0.638 ms	- Mb
ps_shoppingcart	1.062 ms	0.08 Mb
__construct	0.151 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
displayTop	0.871 ms	0.07 Mb
ps_googleanalytics	0.178 ms	0.01 Mb
__construct	0.091 ms	0.01 Mb
hookDisplayHeader	0.087 ms	- Mb
posslideshows	0.422 ms	0.02 Mb
__construct	0.195 ms	0.02 Mb
hookDisplayHeader	0.227 ms	- Mb
poslistcategories	0.288 ms	0.01 Mb
__construct	0.181 ms	0.01 Mb
hookDisplayHeader	0.107 ms	- Mb
poslogo	0.236 ms	0.01 Mb
__construct	0.179 ms	0.01 Mb
hookDisplayHeader	0.057 ms	- Mb
poslistcateproduct	0.748 ms	0.02 Mb
__construct	0.180 ms	0.01 Mb
hookDisplayHeader	0.568 ms	0.01 Mb
posrecommendedproducts	0.212 ms	0.01 Mb
__construct	0.151 ms	0.01 Mb
hookDisplayHeader	0.061 ms	- Mb
rozeroneclick	0.050 ms	0.01 Mb
__construct	0.048 ms	- Mb
hookDisplayHeader	0.002 ms	- Mb
rozershowall	0.662 ms	0.02 Mb
__construct	0.046 ms	- Mb
hookDisplayHeader	0.169 ms	- Mb
hookActionProductSearchProviderRunQueryBefore	0.003 ms	- Mb
hookFilterProductSearch	0.005 ms	- Mb
hookDisplayFooter	0.439 ms	0.01 Mb
rozerhomereviews	0.053 ms	0.01 Mb
__construct	0.047 ms	- Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayFooter	0.003 ms	- Mb
poscompare	9.473 ms	0.10 Mb
__construct	0.169 ms	0.01 Mb
hookHeader	0.173 ms	- Mb
displayTop	0.566 ms	0.04 Mb
displayProductListCompare	0.327 ms	- Mb
displayProductListCompare	0.313 ms	- Mb
displayProductListCompare	0.307 ms	- Mb
displayProductListCompare	0.305 ms	- Mb
displayProductListCompare	0.311 ms	- Mb
displayProductListCompare	0.460 ms	- Mb
displayProductListCompare	0.457 ms	- Mb
displayProductListCompare	0.339 ms	- Mb
displayProductListCompare	0.305 ms	- Mb
displayProductListCompare	0.304 ms	- Mb
displayProductListCompare	0.315 ms	- Mb
displayProductListCompare	0.304 ms	- Mb
displayProductListCompare	0.306 ms	- Mb
displayProductListCompare	0.305 ms	- Mb
displayProductListCompare	0.310 ms	- Mb
displayProductListCompare	0.306 ms	- Mb
displayProductListCompare	0.311 ms	- Mb
displayProductListCompare	0.304 ms	- Mb
displayProductListCompare	0.457 ms	- Mb
displayProductListCompare	0.458 ms	- Mb
displayProductListCompare	0.466 ms	- Mb
displayProductListCompare	0.305 ms	- Mb
displayProductListCompare	0.307 ms	- Mb
displayProductListCompare	0.320 ms	- Mb
displayBeforeBodyClosingTag	0.363 ms	0.01 Mb
posrotatorimg	16.811 ms	1.37 Mb
__construct	0.158 ms	0.01 Mb
hookDisplayHeader	0.806 ms	0.02 Mb
hookRotatorImg	0.712 ms	0.07 Mb
hookRotatorImg	0.767 ms	0.06 Mb
hookRotatorImg	0.681 ms	0.06 Mb
hookRotatorImg	0.704 ms	0.06 Mb
hookRotatorImg	0.661 ms	0.06 Mb
hookRotatorImg	0.656 ms	0.06 Mb
hookRotatorImg	0.823 ms	0.06 Mb
hookRotatorImg	0.816 ms	0.06 Mb
hookRotatorImg	0.600 ms	0.06 Mb
hookRotatorImg	0.604 ms	0.06 Mb
hookRotatorImg	0.604 ms	0.06 Mb
hookRotatorImg	0.609 ms	0.06 Mb
hookRotatorImg	0.592 ms	0.06 Mb
hookRotatorImg	0.580 ms	0.06 Mb
hookRotatorImg	0.585 ms	0.06 Mb
hookRotatorImg	0.580 ms	0.06 Mb
hookRotatorImg	0.679 ms	0.06 Mb
hookRotatorImg	0.675 ms	0.06 Mb
hookRotatorImg	0.681 ms	0.06 Mb
hookRotatorImg	0.720 ms	0.06 Mb
hookRotatorImg	0.714 ms	0.06 Mb
hookRotatorImg	0.554 ms	0.06 Mb
hookRotatorImg	0.630 ms	0.06 Mb
hookRotatorImg	0.620 ms	0.06 Mb
possearchproducts	6.335 ms	0.58 Mb
__construct	0.168 ms	0.01 Mb
hookHeader	0.451 ms	- Mb
displayTop	5.716 ms	0.57 Mb
posthemeoptions	0.368 ms	0.07 Mb
__construct	0.152 ms	0.01 Mb
hookHeader	0.216 ms	0.07 Mb
posmegamenu	23.659 ms	0.06 Mb
__construct	0.231 ms	0.01 Mb
hookHeader	0.240 ms	- Mb
hookDisplayMegamenu	23.188 ms	0.05 Mb
posvegamenu	0.476 ms	0.01 Mb
__construct	0.231 ms	- Mb
hookHeader	0.245 ms	- Mb
posfeaturedproducts	0.217 ms	0.01 Mb
__construct	0.159 ms	0.01 Mb
hookHeader	0.058 ms	- Mb
posnewproducts	0.215 ms	0.01 Mb
__construct	0.158 ms	0.01 Mb
hookHeader	0.057 ms	- Mb
postabproductslider	0.238 ms	0.01 Mb
__construct	0.167 ms	0.01 Mb
hookHeader	0.071 ms	- Mb
ps_facetedsearch	2.224 ms	0.62 Mb
__construct	0.856 ms	0.01 Mb
hookProductSearchProvider	0.786 ms	- Mb
hookDisplayLeftColumn	0.582 ms	0.60 Mb
posstaticblocks	3.658 ms	0.19 Mb
__construct	0.211 ms	0.01 Mb
displayBanner	1.693 ms	0.12 Mb
displayNav	0.879 ms	0.03 Mb
displayTop	0.875 ms	0.03 Mb
ps_languageselector	0.900 ms	0.05 Mb
__construct	0.158 ms	0.01 Mb
displayNav	0.742 ms	0.05 Mb
ps_currencyselector	0.347 ms	0.05 Mb
__construct	0.153 ms	0.01 Mb
displayNav	0.194 ms	0.04 Mb
ps_customersignin	0.705 ms	0.05 Mb
__construct	0.151 ms	0.01 Mb
displayNav	0.554 ms	0.04 Mb
ps_categorytree	11.076 ms	1.35 Mb
__construct	0.235 ms	0.01 Mb
displayLeftColumn	10.841 ms	1.35 Mb
ps_advertising	1.376 ms	0.06 Mb
__construct	0.320 ms	0.01 Mb
displayLeftColumn	1.056 ms	0.05 Mb
posstaticfooter	2.216 ms	0.13 Mb
__construct	0.135 ms	0.01 Mb
displayFooter	1.211 ms	0.08 Mb
displayFooterAfter	0.870 ms	0.04 Mb
33 module(s)	130.015 ms	5.62 Mb

77 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX, XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
65 queries	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 `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_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 ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_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
65 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX, XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
47 queries	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 `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_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
25 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
24 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
24 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
24 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_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
24 queries	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, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_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)
24 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
24 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
24 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 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
24 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_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
24 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
24 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
24 queries	SELECT * FROM `ps_image` img LEFT JOIN `ps_image_shop` imgs ON img.id_image = imgs.id_image where imgs.`id_shop` =XX AND img.`id_product` =XX AND imgs.`rotator` =XX
24 queries	SELECT * FROM `ps_image` img where img.`rotator` =XX AND img.`id_product` =XX
24 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_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` ORDER BY a.`position` ASC;
16 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_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
12 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'ru-ru' OR `language_code` = 'ru-ru' LIMIT XX
5 queries	SELECT ps.* FROM ps_posmegamenu_submenu ps WHERE ps.`id_posmegamenu_item` = XX LIMIT XX
3 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
3 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_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' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT pi., pl. FROM ps_posmegamenu_item pi LEFT JOIN `ps_posmegamenu_item_lang` pl ON pl.`id_posmegamenu_item` = pi.`id_posmegamenu_item` LEFT JOIN `ps_posmegamenu_item_shop` ps ON ps.`id_posmegamenu_item` = pi.`id_posmegamenu_item` WHERE pi.active = XX AND ps.id_shop = XX AND pl.id_lang=XX ORDER BY pi.position ASC, pi.id_posmegamenu_item ASC
2 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
2 queries	SELECT sr.* FROM ps_posmegamenu_submenu_row sr WHERE sr.id_posmegamenu_item = XX AND sr.`active` = XX ORDER BY sr.position ASC

Name	Instances	Source
Product	72	/classes/Link.php:113 (__construct) [id: 9978] /classes/Link.php:113 (__construct) [id: 10299] /classes/Link.php:113 (__construct) [id: 14544] /classes/Link.php:113 (__construct) [id: 14543] /classes/Link.php:113 (__construct) [id: 14542] /classes/Link.php:113 (__construct) [id: 14541] /classes/Link.php:113 (__construct) [id: 14538] /classes/Link.php:113 (__construct) [id: 14537] /classes/Link.php:113 (__construct) [id: 13830] /classes/Link.php:113 (__construct) [id: 13829] /classes/Link.php:113 (__construct) [id: 12977] /classes/Link.php:113 (__construct) [id: 12976] /classes/Link.php:113 (__construct) [id: 12975] /classes/Link.php:113 (__construct) [id: 12974] /classes/Link.php:113 (__construct) [id: 12897] /classes/Link.php:113 (__construct) [id: 12896] /classes/Link.php:113 (__construct) [id: 12895] /classes/Link.php:113 (__construct) [id: 12894] /classes/Link.php:113 (__construct) [id: 12892] /classes/Link.php:113 (__construct) [id: 12891] /classes/Link.php:113 (__construct) [id: 12890] /classes/Link.php:113 (__construct) [id: 12889] /classes/Link.php:113 (__construct) [id: 12875] /classes/Link.php:113 (__construct) [id: 12874] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9978] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10299] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14544] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14543] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14542] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14541] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14538] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14537] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 13830] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 13829] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12977] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12976] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12975] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12974] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12897] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12896] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12895] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12894] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12892] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12891] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12890] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12889] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12875] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12874] /classes/Link.php:113 (__construct) [id: 9978] /classes/Link.php:113 (__construct) [id: 10299] /classes/Link.php:113 (__construct) [id: 14544] /classes/Link.php:113 (__construct) [id: 14543] /classes/Link.php:113 (__construct) [id: 14542] /classes/Link.php:113 (__construct) [id: 14541] /classes/Link.php:113 (__construct) [id: 14538] /classes/Link.php:113 (__construct) [id: 14537] /classes/Link.php:113 (__construct) [id: 13830] /classes/Link.php:113 (__construct) [id: 13829] /classes/Link.php:113 (__construct) [id: 12977] /classes/Link.php:113 (__construct) [id: 12976] /classes/Link.php:113 (__construct) [id: 12975] /classes/Link.php:113 (__construct) [id: 12974] /classes/Link.php:113 (__construct) [id: 12897] /classes/Link.php:113 (__construct) [id: 12896] /classes/Link.php:113 (__construct) [id: 12895] /classes/Link.php:113 (__construct) [id: 12894] /classes/Link.php:113 (__construct) [id: 12892] /classes/Link.php:113 (__construct) [id: 12891] /classes/Link.php:113 (__construct) [id: 12890] /classes/Link.php:113 (__construct) [id: 12889] /classes/Link.php:113 (__construct) [id: 12875] /classes/Link.php:113 (__construct) [id: 12874]
Category	30	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 8] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 9] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 3] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 7] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 64] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 98] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 228] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 20] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 384] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 76] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 105] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 115] /classes/Meta.php:379 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:393 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:153 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/possearchproducts/possearchproducts.php:218 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 115] /modules/posmegamenu/posmegamenu.php:811 (__construct) [id: 115] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Manufacturer	24	/classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46] /classes/Link.php:1574 (__construct) [id: 46]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /classes/Tools.php:770 (getCurrencyInstance) [id: 1]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5975 (__construct) [id: ]
Language	3	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:721 (__construct) [id: 2] /classes/Tools.php:640 (__construct) [id: 2]
Country	3	/config/config.inc.php:146 (__construct) [id: 214] /classes/AddressFormat.php:404 (__construct) [id: 214] /classes/controller/FrontController.php:1769 (__construct) [id: 214]
CMS	2	/classes/Link.php:555 (__construct) [id: 4] /modules/posmegamenu/posmegamenu.php:822 (__construct) [id: 4]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
State	1	/classes/controller/FrontController.php:1768 (__construct) [id: 361]
PosMegamenuClass	1	/modules/posmegamenu/posmegamenu.php:745 (__construct) [id: ]
Slideshow	1	/modules/posslideshows/posslideshows.php:39 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1763 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1695 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1692 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
89	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	26.588 ms	56310016	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:657 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:142 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
204	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=57)) GROUP BY pac.id_attribute	15.772 ms	10214400	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
218	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=64)) GROUP BY pac.id_attribute	12.972 ms	384	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<625 GROUP BY cp.id_category	11.335 ms	1008	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:994 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
214	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=62)) GROUP BY pac.id_attribute	11.149 ms	15590400	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
162	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=35)) GROUP BY pac.id_attribute	10.912 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
208	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=59)) GROUP BY pac.id_attribute	10.829 ms	384	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
206	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=58)) GROUP BY pac.id_attribute	10.779 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
188	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=48)) GROUP BY pac.id_attribute	7.455 ms	960	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
198	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=54)) GROUP BY pac.id_attribute	7.401 ms	384	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
196	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=53)) GROUP BY pac.id_attribute	7.322 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
80	SELECT SQL_NO_CACHE p.id_product, cp.position FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY ISNULL(MIN(IF(cp.id_category = 2, cp.position, NULL))) ASC, MIN(IF(cp.id_category = 2, cp.position, NULL)) ASC, p.id_product DESC	7.209 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:99 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:190 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
200	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=55)) GROUP BY pac.id_attribute	6.915 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
690	SELECT SQL_NO_CACHE c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	6.109 ms	317	Yes	Yes	/classes/Category.php:785 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/32/0a/b7/320ab7a5acae5b854943816a837e618d9cedfa72_2.file.layout-both-columns.tpl.php:289 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/32/0a/b7/320ab7a5acae5b854943816a837e618d9cedfa72_2.file.layout-both-columns.tpl.php:104 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8bef248_49227126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/00/c2/ef/00c2efb3fa55439ea974cbfd1b2f41fb444f771e_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8be07d9_16933122) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/d1/2b/28/d12b284fefdfdd7d015055c4b2bc20baf03b129e_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8bdbea8_65339284) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/2a/5c/ba/2a5cba1f13a30a1095134d5db6b1fd969eb71e22_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8bd5cd7_98331723) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.condition FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p GROUP BY p.condition	5.853 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:390 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:133 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE STRAIGHT_JOIN COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pa.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pa.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	5.496 ms	5331200			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:965 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:476 (count) /modules/ps_facetedsearch/src/Filters/Block.php:136 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute	5.118 ms	576	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
85	SELECT SQL_NO_CACHE STRAIGHT_JOIN COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pa.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	4.113 ms	5331200			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:965 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:490 (count) /modules/ps_facetedsearch/src/Filters/Block.php:136 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
86	SELECT SQL_NO_CACHE STRAIGHT_JOIN COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pa.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.quantity>0))	4.034 ms	5331200			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:965 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:501 (count) /modules/ps_facetedsearch/src/Filters/Block.php:136 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
216	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=63)) GROUP BY pac.id_attribute	3.602 ms	10662400	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute	3.575 ms	10662400	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
671	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 4 AND nleft >= 2 AND nright <= 625 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	3.475 ms	226	Yes		/modules/possearchproducts/possearchproducts.php:253 /modules/possearchproducts/possearchproducts.php:224 (getCategories) /modules/possearchproducts/possearchproducts.php:236 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/a5/ff/38/a5ff3827f4b326a676d1ba5e19c2e2b5f86e8abe_2.file.header.tpl.php:160 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/a5/ff/38/a5ff3827f4b326a676d1ba5e19c2e2b5f86e8abe_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8c26d00_17202189) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/32/0a/b7/320ab7a5acae5b854943816a837e618d9cedfa72_2.file.layout-both-columns.tpl.php:230 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/32/0a/b7/320ab7a5acae5b854943816a837e618d9cedfa72_2.file.layout-both-columns.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8bef248_49227126) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/00/c2/ef/00c2efb3fa55439ea974cbfd1b2f41fb444f771e_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8be07d9_16933122) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/d1/2b/28/d12b284fefdfdd7d015055c4b2bc20baf03b129e_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8bdbea8_65339284) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/theme_rozer2layouts_layout_left_column_tpl/2a/5c/ba/2a5cba1f13a30a1095134d5db6b1fd969eb71e22_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6ac92ee8bd5cd7_98331723) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
227	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	3.442 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
225	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value	3.420 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
233	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=5)) GROUP BY fp.id_feature_value	3.403 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
318	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=63)) GROUP BY fp.id_feature_value	3.397 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
247	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=12)) GROUP BY fp.id_feature_value	3.355 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
292	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=45)) GROUP BY fp.id_feature_value	3.349 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
268	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=27)) GROUP BY fp.id_feature_value	3.341 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
320	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=64)) GROUP BY fp.id_feature_value	3.329 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
288	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=43)) GROUP BY fp.id_feature_value	3.327 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
241	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=9)) GROUP BY fp.id_feature_value	3.325 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
300	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=50)) GROUP BY fp.id_feature_value	3.325 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
239	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=8)) GROUP BY fp.id_feature_value	3.317 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
306	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=54)) GROUP BY fp.id_feature_value	3.315 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
235	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=6)) GROUP BY fp.id_feature_value	3.309 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
254	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=18)) GROUP BY fp.id_feature_value	3.297 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
294	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=47)) GROUP BY fp.id_feature_value	3.295 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
262	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=24)) GROUP BY fp.id_feature_value	3.286 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
229	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_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 p.id_manufacturer IN (70, 71, 47, 17, 7, 18, 46) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=3)) GROUP BY fp.id_feature_value	3.238 ms	313600	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php