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

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

Товаров: 116.

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

Load Time	596.741 ms
Querying Time	369 ms
Queries	775
Memory Peak Usage	18.2 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	44.337 ms	44.337 ms	1.95 Mb	1.9 Mb
__construct	1.320 ms	45.657 ms	- Mb	2.5 Mb
init	12.248 ms	57.905 ms	0.84 Mb	2.9 Mb
setMedia	4.268 ms	62.173 ms	0.35 Mb	3.1 Mb
postProcess	0.001 ms	62.174 ms	- Mb	3.1 Mb
initHeader	0.000 ms	62.174 ms	- Mb	3.1 Mb
initContent	417.588 ms	479.762 ms	8.18 Mb	13.6 Mb
initFooter	0.002 ms	479.764 ms	- Mb	13.6 Mb
display	116.977 ms	596.741 ms	6.01 Mb	18.2 Mb

Hook	Time	Memory Usage
displayProductListReviews	21.634 ms	0.32 Mb
=> productcomments (widget)	10.839 ms	0.25 Mb
=> productcomments (widget)	0.464 ms	- Mb
=> productcomments (widget)	0.458 ms	- Mb
=> productcomments (widget)	0.453 ms	- Mb
=> productcomments (widget)	0.436 ms	- Mb
=> productcomments (widget)	0.430 ms	- Mb
=> productcomments (widget)	0.444 ms	- Mb
=> productcomments (widget)	0.458 ms	- Mb
=> productcomments (widget)	0.451 ms	- Mb
=> productcomments (widget)	0.454 ms	- Mb
=> productcomments (widget)	0.440 ms	- Mb
=> productcomments (widget)	0.447 ms	- Mb
=> productcomments (widget)	0.441 ms	- Mb
=> productcomments (widget)	0.445 ms	- Mb
=> productcomments (widget)	0.448 ms	- Mb
=> productcomments (widget)	0.449 ms	- Mb
=> productcomments (widget)	0.451 ms	- Mb
=> productcomments (widget)	0.443 ms	- Mb
=> productcomments (widget)	0.439 ms	- Mb
=> productcomments (widget)	0.589 ms	- Mb
=> productcomments (widget)	0.566 ms	- Mb
=> productcomments (widget)	0.571 ms	- Mb
=> productcomments (widget)	0.581 ms	- Mb
=> productcomments (widget)	0.437 ms	- Mb
RotatorImg	13.382 ms	1.33 Mb
=> posrotatorimg	0.739 ms	0.07 Mb
=> posrotatorimg	0.592 ms	0.06 Mb
=> posrotatorimg	0.543 ms	0.05 Mb
=> posrotatorimg	0.494 ms	0.05 Mb
=> posrotatorimg	0.508 ms	0.05 Mb
=> posrotatorimg	0.473 ms	0.05 Mb
=> posrotatorimg	0.483 ms	0.05 Mb
=> posrotatorimg	0.583 ms	0.05 Mb
=> posrotatorimg	0.597 ms	0.05 Mb
=> posrotatorimg	0.617 ms	0.05 Mb
=> posrotatorimg	0.524 ms	0.05 Mb
=> posrotatorimg	0.525 ms	0.05 Mb
=> posrotatorimg	0.515 ms	0.05 Mb
=> posrotatorimg	0.524 ms	0.05 Mb
=> posrotatorimg	0.648 ms	0.05 Mb
=> posrotatorimg	0.603 ms	0.05 Mb
=> posrotatorimg	0.581 ms	0.05 Mb
=> posrotatorimg	0.602 ms	0.05 Mb
=> posrotatorimg	0.529 ms	0.05 Mb
=> posrotatorimg	0.553 ms	0.05 Mb
=> posrotatorimg	0.543 ms	0.05 Mb
=> posrotatorimg	0.539 ms	0.05 Mb
=> posrotatorimg	0.542 ms	0.05 Mb
=> posrotatorimg	0.525 ms	0.05 Mb
displayLeftColumn	10.894 ms	1.41 Mb
=> ps_categorytree (widget)	9.739 ms	1.36 Mb
=> ps_advertising (widget)	1.155 ms	0.05 Mb
DisplayMegamenu	9.967 ms	0.04 Mb
=> posmegamenu	9.967 ms	0.04 Mb
DisplayProductListFunctionalButtons	9.520 ms	0.10 Mb
=> blockwishlist	0.471 ms	- Mb
=> blockwishlist	0.394 ms	- Mb
=> blockwishlist	0.388 ms	- Mb
=> blockwishlist	0.414 ms	- Mb
=> blockwishlist	0.392 ms	- Mb
=> blockwishlist	0.389 ms	- Mb
=> blockwishlist	0.387 ms	- Mb
=> blockwishlist	0.387 ms	- Mb
=> blockwishlist	0.394 ms	- Mb
=> blockwishlist	0.385 ms	- Mb
=> blockwishlist	0.485 ms	- Mb
=> blockwishlist	0.388 ms	- Mb
=> blockwishlist	0.373 ms	- Mb
=> blockwishlist	0.383 ms	- Mb
=> blockwishlist	0.387 ms	- Mb
=> blockwishlist	0.395 ms	- Mb
=> blockwishlist	0.387 ms	- Mb
=> blockwishlist	0.388 ms	- Mb
=> blockwishlist	0.387 ms	- Mb
=> blockwishlist	0.385 ms	- Mb
=> blockwishlist	0.404 ms	- Mb
=> blockwishlist	0.385 ms	- Mb
=> blockwishlist	0.386 ms	- Mb
=> blockwishlist	0.387 ms	- Mb
displayTop	8.140 ms	0.71 Mb
=> posstaticblocks (widget)	0.900 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.983 ms	0.07 Mb
=> poscompare (widget)	0.598 ms	0.04 Mb
=> possearchproducts (widget)	5.659 ms	0.57 Mb
displayProductListCompare	7.754 ms	0.03 Mb
=> poscompare (widget)	0.337 ms	- Mb
=> poscompare (widget)	0.322 ms	- Mb
=> poscompare (widget)	0.331 ms	- Mb
=> poscompare (widget)	0.320 ms	- Mb
=> poscompare (widget)	0.377 ms	- Mb
=> poscompare (widget)	0.330 ms	- Mb
=> poscompare (widget)	0.315 ms	- Mb
=> poscompare (widget)	0.314 ms	- Mb
=> poscompare (widget)	0.317 ms	- Mb
=> poscompare (widget)	0.322 ms	- Mb
=> poscompare (widget)	0.322 ms	- Mb
=> poscompare (widget)	0.318 ms	- Mb
=> poscompare (widget)	0.308 ms	- Mb
=> poscompare (widget)	0.316 ms	- Mb
=> poscompare (widget)	0.323 ms	- Mb
=> poscompare (widget)	0.319 ms	- Mb
=> poscompare (widget)	0.323 ms	- Mb
=> poscompare (widget)	0.317 ms	- Mb
=> poscompare (widget)	0.316 ms	- Mb
=> poscompare (widget)	0.317 ms	- Mb
=> poscompare (widget)	0.320 ms	- Mb
=> poscompare (widget)	0.319 ms	- Mb
=> poscompare (widget)	0.318 ms	- Mb
=> poscompare (widget)	0.332 ms	- Mb
DisplayFooter	2.722 ms	0.13 Mb
=> blockwishlist	2.278 ms	0.12 Mb
=> rozershowall	0.442 ms	0.01 Mb
=> rozerhomereviews	0.002 ms	- Mb
DisplayHeader	2.677 ms	0.04 Mb
=> ps_shoppingcart	0.056 ms	- Mb
=> productcomments	0.333 ms	- Mb
=> ps_googleanalytics	0.127 ms	- Mb
=> posslideshows	0.334 ms	- Mb
=> poslistcategories	0.158 ms	- Mb
=> poslogo	0.083 ms	- Mb
=> poslistcateproduct	0.564 ms	0.01 Mb
=> posrecommendedproducts	0.060 ms	- Mb
=> rozeroneclick	0.001 ms	- Mb
=> rozershowall	0.169 ms	- Mb
=> rozerhomereviews	0.002 ms	- Mb
=> posrotatorimg	0.790 ms	0.02 Mb
displayNav	2.358 ms	0.16 Mb
=> ps_languageselector (widget)	0.740 ms	0.05 Mb
=> ps_currencyselector (widget)	0.159 ms	0.04 Mb
=> ps_customersignin (widget)	0.556 ms	0.04 Mb
=> posstaticblocks (widget)	0.903 ms	0.03 Mb
displayBanner	1.693 ms	0.12 Mb
=> posstaticblocks (widget)	1.693 ms	0.12 Mb
Header	1.508 ms	0.08 Mb
=> poscompare	0.170 ms	- Mb
=> possearchproducts	0.464 ms	- Mb
=> posthemeoptions	0.213 ms	0.07 Mb
=> posmegamenu	0.238 ms	- Mb
=> posvegamenu	0.242 ms	- Mb
=> posfeaturedproducts	0.057 ms	- Mb
=> posnewproducts	0.057 ms	- Mb
=> postabproductslider	0.067 ms	- Mb
displayFooter	1.127 ms	0.08 Mb
=> posstaticfooter (widget)	1.127 ms	0.08 Mb
ActionFrontControllerSetMedia	0.990 ms	0.01 Mb
=> blockreassurance	0.305 ms	- Mb
=> blockwishlist	0.444 ms	- Mb
=> ps_emailsubscription	0.071 ms	- Mb
=> ps_socialfollow	0.114 ms	- Mb
=> ps_emailalerts	0.056 ms	- Mb
displayFooterAfter	0.905 ms	0.03 Mb
=> posstaticfooter (widget)	0.905 ms	0.03 Mb
ProductSearchProvider	0.793 ms	- Mb
=> ps_facetedsearch	0.793 ms	- Mb
DisplayLeftColumn	0.547 ms	0.20 Mb
=> ps_facetedsearch	0.547 ms	0.20 Mb
DisplayTop	0.477 ms	- Mb
=> blockwishlist	0.477 ms	- Mb
displayBeforeBodyClosingTag	0.370 ms	0.01 Mb
=> poscompare (widget)	0.370 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.002 ms	- Mb
=> productcomments	0.002 ms	- Mb
22 hook(s)	97.465 ms	4.81 Mb

Module	Time	Memory Usage
blockreassurance	1.179 ms	0.14 Mb
__construct	0.872 ms	0.13 Mb
hookActionFrontControllerSetMedia	0.307 ms	0.01 Mb
blockwishlist	12.947 ms	0.24 Mb
__construct	0.197 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.445 ms	- Mb
hookDisplayTop	0.478 ms	0.01 Mb
hookDisplayProductListFunctionalButtons	0.472 ms	0.01 Mb
hookDisplayProductListFunctionalButtons	0.395 ms	- Mb
hookDisplayProductListFunctionalButtons	0.389 ms	- Mb
hookDisplayProductListFunctionalButtons	0.415 ms	- Mb
hookDisplayProductListFunctionalButtons	0.393 ms	- Mb
hookDisplayProductListFunctionalButtons	0.390 ms	- Mb
hookDisplayProductListFunctionalButtons	0.388 ms	- Mb
hookDisplayProductListFunctionalButtons	0.388 ms	- Mb
hookDisplayProductListFunctionalButtons	0.395 ms	- Mb
hookDisplayProductListFunctionalButtons	0.387 ms	- Mb
hookDisplayProductListFunctionalButtons	0.487 ms	- Mb
hookDisplayProductListFunctionalButtons	0.389 ms	- Mb
hookDisplayProductListFunctionalButtons	0.374 ms	- Mb
hookDisplayProductListFunctionalButtons	0.384 ms	- Mb
hookDisplayProductListFunctionalButtons	0.388 ms	- Mb
hookDisplayProductListFunctionalButtons	0.396 ms	- Mb
hookDisplayProductListFunctionalButtons	0.389 ms	- Mb
hookDisplayProductListFunctionalButtons	0.389 ms	- Mb
hookDisplayProductListFunctionalButtons	0.388 ms	- Mb
hookDisplayProductListFunctionalButtons	0.386 ms	- Mb
hookDisplayProductListFunctionalButtons	0.405 ms	- Mb
hookDisplayProductListFunctionalButtons	0.386 ms	- Mb
hookDisplayProductListFunctionalButtons	0.387 ms	- Mb
hookDisplayProductListFunctionalButtons	0.388 ms	- Mb
hookDisplayFooter	2.280 ms	0.12 Mb
ps_emailsubscription	0.229 ms	0.01 Mb
__construct	0.157 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.072 ms	- Mb
ps_socialfollow	0.262 ms	0.01 Mb
__construct	0.147 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.115 ms	- Mb
ps_emailalerts	0.248 ms	0.01 Mb
__construct	0.191 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.057 ms	- Mb
productcomments	22.253 ms	0.34 Mb
__construct	0.251 ms	0.01 Mb
hookActionFrontControllerSetVariables	0.004 ms	- Mb
hookDisplayHeader	0.334 ms	- Mb
displayProductListReviews	10.841 ms	0.25 Mb
displayProductListReviews	0.465 ms	- Mb
displayProductListReviews	0.460 ms	- Mb
displayProductListReviews	0.454 ms	- Mb
displayProductListReviews	0.437 ms	- Mb
displayProductListReviews	0.431 ms	- Mb
displayProductListReviews	0.445 ms	- Mb
displayProductListReviews	0.459 ms	- Mb
displayProductListReviews	0.452 ms	- Mb
displayProductListReviews	0.456 ms	- Mb
displayProductListReviews	0.441 ms	- Mb
displayProductListReviews	0.448 ms	- Mb
displayProductListReviews	0.442 ms	- Mb
displayProductListReviews	0.447 ms	- Mb
displayProductListReviews	0.450 ms	- Mb
displayProductListReviews	0.450 ms	- Mb
displayProductListReviews	0.452 ms	- Mb
displayProductListReviews	0.444 ms	- Mb
displayProductListReviews	0.440 ms	- Mb
displayProductListReviews	0.590 ms	- Mb
displayProductListReviews	0.568 ms	- Mb
displayProductListReviews	0.572 ms	- Mb
displayProductListReviews	0.582 ms	- Mb
displayProductListReviews	0.438 ms	- Mb
ps_shoppingcart	1.265 ms	0.08 Mb
__construct	0.223 ms	0.01 Mb
hookDisplayHeader	0.058 ms	- Mb
displayTop	0.984 ms	0.07 Mb
ps_googleanalytics	0.263 ms	0.01 Mb
__construct	0.134 ms	0.01 Mb
hookDisplayHeader	0.129 ms	- Mb
posslideshows	0.620 ms	0.02 Mb
__construct	0.285 ms	0.02 Mb
hookDisplayHeader	0.335 ms	- Mb
poslistcategories	0.448 ms	0.01 Mb
__construct	0.289 ms	0.01 Mb
hookDisplayHeader	0.159 ms	- Mb
poslogo	0.341 ms	0.01 Mb
__construct	0.256 ms	0.01 Mb
hookDisplayHeader	0.085 ms	- Mb
poslistcateproduct	0.773 ms	0.02 Mb
__construct	0.208 ms	0.01 Mb
hookDisplayHeader	0.565 ms	0.01 Mb
posrecommendedproducts	0.213 ms	0.01 Mb
__construct	0.152 ms	0.01 Mb
hookDisplayHeader	0.061 ms	- Mb
rozeroneclick	0.051 ms	0.01 Mb
__construct	0.049 ms	- Mb
hookDisplayHeader	0.002 ms	- Mb
rozershowall	0.666 ms	0.02 Mb
__construct	0.045 ms	- Mb
hookDisplayHeader	0.170 ms	- Mb
hookActionProductSearchProviderRunQueryBefore	0.003 ms	- Mb
hookFilterProductSearch	0.005 ms	- Mb
hookDisplayFooter	0.443 ms	0.01 Mb
rozerhomereviews	0.053 ms	0.01 Mb
__construct	0.048 ms	- Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayFooter	0.002 ms	- Mb
poscompare	9.084 ms	0.10 Mb
__construct	0.165 ms	0.01 Mb
hookHeader	0.171 ms	- Mb
displayTop	0.599 ms	0.04 Mb
displayProductListCompare	0.338 ms	- Mb
displayProductListCompare	0.323 ms	- Mb
displayProductListCompare	0.332 ms	- Mb
displayProductListCompare	0.321 ms	- Mb
displayProductListCompare	0.378 ms	- Mb
displayProductListCompare	0.331 ms	- Mb
displayProductListCompare	0.316 ms	- Mb
displayProductListCompare	0.315 ms	- Mb
displayProductListCompare	0.318 ms	- Mb
displayProductListCompare	0.323 ms	- Mb
displayProductListCompare	0.323 ms	- Mb
displayProductListCompare	0.319 ms	- Mb
displayProductListCompare	0.309 ms	- Mb
displayProductListCompare	0.317 ms	- Mb
displayProductListCompare	0.324 ms	- Mb
displayProductListCompare	0.320 ms	- Mb
displayProductListCompare	0.324 ms	- Mb
displayProductListCompare	0.318 ms	- Mb
displayProductListCompare	0.317 ms	- Mb
displayProductListCompare	0.318 ms	- Mb
displayProductListCompare	0.321 ms	- Mb
displayProductListCompare	0.320 ms	- Mb
displayProductListCompare	0.319 ms	- Mb
displayProductListCompare	0.333 ms	- Mb
displayBeforeBodyClosingTag	0.371 ms	0.01 Mb
posrotatorimg	14.357 ms	1.37 Mb
__construct	0.157 ms	0.01 Mb
hookDisplayHeader	0.791 ms	0.02 Mb
hookRotatorImg	0.740 ms	0.07 Mb
hookRotatorImg	0.593 ms	0.06 Mb
hookRotatorImg	0.544 ms	0.06 Mb
hookRotatorImg	0.496 ms	0.06 Mb
hookRotatorImg	0.509 ms	0.06 Mb
hookRotatorImg	0.474 ms	0.06 Mb
hookRotatorImg	0.485 ms	0.06 Mb
hookRotatorImg	0.585 ms	0.06 Mb
hookRotatorImg	0.598 ms	0.06 Mb
hookRotatorImg	0.618 ms	0.06 Mb
hookRotatorImg	0.525 ms	0.06 Mb
hookRotatorImg	0.526 ms	0.06 Mb
hookRotatorImg	0.516 ms	0.06 Mb
hookRotatorImg	0.526 ms	0.06 Mb
hookRotatorImg	0.649 ms	0.06 Mb
hookRotatorImg	0.604 ms	0.06 Mb
hookRotatorImg	0.582 ms	0.06 Mb
hookRotatorImg	0.603 ms	0.06 Mb
hookRotatorImg	0.530 ms	0.06 Mb
hookRotatorImg	0.554 ms	0.06 Mb
hookRotatorImg	0.544 ms	0.06 Mb
hookRotatorImg	0.540 ms	0.06 Mb
hookRotatorImg	0.543 ms	0.06 Mb
hookRotatorImg	0.526 ms	0.06 Mb
possearchproducts	6.297 ms	0.58 Mb
__construct	0.170 ms	0.01 Mb
hookHeader	0.465 ms	- Mb
displayTop	5.662 ms	0.57 Mb
posthemeoptions	0.367 ms	0.07 Mb
__construct	0.153 ms	0.01 Mb
hookHeader	0.214 ms	0.07 Mb
posmegamenu	10.446 ms	0.06 Mb
__construct	0.237 ms	0.01 Mb
hookHeader	0.239 ms	- Mb
hookDisplayMegamenu	9.970 ms	0.05 Mb
posvegamenu	0.475 ms	0.01 Mb
__construct	0.232 ms	- Mb
hookHeader	0.243 ms	- Mb
posfeaturedproducts	0.216 ms	0.01 Mb
__construct	0.159 ms	0.01 Mb
hookHeader	0.057 ms	- Mb
posnewproducts	0.215 ms	0.01 Mb
__construct	0.157 ms	0.01 Mb
hookHeader	0.058 ms	- Mb
postabproductslider	0.226 ms	0.01 Mb
__construct	0.158 ms	0.01 Mb
hookHeader	0.068 ms	- Mb
ps_facetedsearch	2.197 ms	0.22 Mb
__construct	0.854 ms	0.01 Mb
hookProductSearchProvider	0.794 ms	- Mb
hookDisplayLeftColumn	0.549 ms	0.20 Mb
posstaticblocks	3.724 ms	0.19 Mb
__construct	0.225 ms	0.01 Mb
displayBanner	1.694 ms	0.12 Mb
displayNav	0.904 ms	0.03 Mb
displayTop	0.901 ms	0.03 Mb
ps_languageselector	0.907 ms	0.05 Mb
__construct	0.166 ms	0.01 Mb
displayNav	0.741 ms	0.05 Mb
ps_currencyselector	0.323 ms	0.05 Mb
__construct	0.163 ms	0.01 Mb
displayNav	0.160 ms	0.04 Mb
ps_customersignin	0.716 ms	0.05 Mb
__construct	0.159 ms	0.01 Mb
displayNav	0.557 ms	0.04 Mb
ps_categorytree	10.000 ms	1.37 Mb
__construct	0.258 ms	0.01 Mb
displayLeftColumn	9.742 ms	1.36 Mb
ps_advertising	1.501 ms	0.06 Mb
__construct	0.344 ms	0.01 Mb
displayLeftColumn	1.157 ms	0.05 Mb
posstaticfooter	2.172 ms	0.13 Mb
__construct	0.137 ms	0.01 Mb
displayFooter	1.128 ms	0.08 Mb
displayFooterAfter	0.907 ms	0.04 Mb
33 module(s)	105.036 ms	5.23 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) 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) 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
37 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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
5 queries	SELECT ps.* FROM ps_posmegamenu_submenu ps WHERE ps.`id_posmegamenu_item` = XX LIMIT XX
4 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
4 queries	SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = XX LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = XX WHERE (a.`id_manufacturer` = 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
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: 14450] /classes/Link.php:113 (__construct) [id: 12371] /classes/Link.php:113 (__construct) [id: 12370] /classes/Link.php:113 (__construct) [id: 12369] /classes/Link.php:113 (__construct) [id: 12368] /classes/Link.php:113 (__construct) [id: 10326] /classes/Link.php:113 (__construct) [id: 10325] /classes/Link.php:113 (__construct) [id: 10324] /classes/Link.php:113 (__construct) [id: 10323] /classes/Link.php:113 (__construct) [id: 10322] /classes/Link.php:113 (__construct) [id: 10320] /classes/Link.php:113 (__construct) [id: 10319] /classes/Link.php:113 (__construct) [id: 10306] /classes/Link.php:113 (__construct) [id: 10304] /classes/Link.php:113 (__construct) [id: 10303] /classes/Link.php:113 (__construct) [id: 10302] /classes/Link.php:113 (__construct) [id: 10301] /classes/Link.php:113 (__construct) [id: 10296] /classes/Link.php:113 (__construct) [id: 10295] /classes/Link.php:113 (__construct) [id: 9053] /classes/Link.php:113 (__construct) [id: 9052] /classes/Link.php:113 (__construct) [id: 9051] /classes/Link.php:113 (__construct) [id: 9050] /classes/Link.php:113 (__construct) [id: 6704] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 14450] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12371] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12370] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12369] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 12368] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10326] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10325] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10324] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10323] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10322] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10320] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10319] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10306] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10304] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10303] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10302] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10301] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10296] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10295] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9053] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9052] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9051] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9050] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 6704] /classes/Link.php:113 (__construct) [id: 14450] /classes/Link.php:113 (__construct) [id: 12371] /classes/Link.php:113 (__construct) [id: 12370] /classes/Link.php:113 (__construct) [id: 12369] /classes/Link.php:113 (__construct) [id: 12368] /classes/Link.php:113 (__construct) [id: 10326] /classes/Link.php:113 (__construct) [id: 10325] /classes/Link.php:113 (__construct) [id: 10324] /classes/Link.php:113 (__construct) [id: 10323] /classes/Link.php:113 (__construct) [id: 10322] /classes/Link.php:113 (__construct) [id: 10320] /classes/Link.php:113 (__construct) [id: 10319] /classes/Link.php:113 (__construct) [id: 10306] /classes/Link.php:113 (__construct) [id: 10304] /classes/Link.php:113 (__construct) [id: 10303] /classes/Link.php:113 (__construct) [id: 10302] /classes/Link.php:113 (__construct) [id: 10301] /classes/Link.php:113 (__construct) [id: 10296] /classes/Link.php:113 (__construct) [id: 10295] /classes/Link.php:113 (__construct) [id: 9053] /classes/Link.php:113 (__construct) [id: 9052] /classes/Link.php:113 (__construct) [id: 9051] /classes/Link.php:113 (__construct) [id: 9050] /classes/Link.php:113 (__construct) [id: 6704]
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: 76] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 104] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 18] /classes/Link.php:1574 (__construct) [id: 13]
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.270 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)
339	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("451d4e0d05113c90fd0ff486563a9900", "a:1:{s:7:\"filters\";a:46:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:18:\"Категории\";s:6:\"values\";a:5:{i:3;a:2:{s:4:\"name\";s:10:\"Ванны\";s:3:\"nbr\";s:1:\"4\";}i:8;a:2:{s:4:\"name\";s:39:\"Гидромассажные боксы\";s:3:\"nbr\";s:2:\"19\";}i:9;a:2:{s:4:\"name\";s:27:\"Душевые кабины\";s:3:\"nbr\";s:2:\"35\";}i:10;a:2:{s:4:\"name\";s:30:\"Керамика и Акрил\";s:3:\"nbr\";s:2:\"22\";}i:64;a:2:{s:4:\"name\";s:25:\"Душевые двери\";s:3:\"nbr\";s:1:\"4\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Наличие\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:19:\"По наличию\";s:3:\"nbr\";i:0;}i:0;a:2:{s:4:\"name\";s:20:\"Недоступно\";s:3:\"nbr\";i:116;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:18:\"Состояние\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:10:\"Новое\";s:3:\"nbr\";s:3:\"116\";}s:4:\"used\";a:2:{s:4:\"name\";s:24:\"Использовано\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:36:\"Отреставрированный\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Бренд\";s:6:\"values\";a:47:{i:5;a:2:{s:4:\"name\";s:5:\"Ravak\";s:3:\"nbr\";s:2:\"37\";}i:6;a:2:{s:4:\"name\";s:11:\"Vagnerplast\";s:3:\"nbr\";s:2:\"42\";}i:7;a:3:{s:4:\"name\";s:4:\"Roca\";s:3:\"nbr\";s:2:\"57\";s:7:\"checked\";b:1;}i:9;a:2:{s:4:\"name\";s:8:\"Atlantis\";s:3:\"nbr\";s:3:\"201\";}i:13;a:3:{s:4:\"name\";s:5:\"Devit\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:16;a:2:{s:4:\"name\";s:9:\"Grandhome\";s:3:\"nbr\";s:1:\"3\";}i:17;a:3:{s:4:\"name\";s:7:\"Miracle\";s:3:\"nbr\";s:2:\"12\";s:7:\"checked\";b:1;}i:18;a:3:{s:4:\"name\";s:5:\"Sansa\";s:3:\"nbr\";s:2:\"31\";s:7:\"checked\";b:1;}i:21;a:2:{s:4:\"name\";s:7:\"Mirater\";s:3:\"nbr\";s:2:\"17\";}i:22;a:2:{s:4:\"name\";s:7:\"Juventa\";s:3:\"nbr\";s:3:\"330\";}i:24;a:2:{s:4:\"name\";s:7:\"Imprese\";s:3:\"nbr\";s:2:\"33\";}i:25;a:2:{s:4:\"name\";s:11:\"Redokss San\";s:3:\"nbr\";s:2:\"59\";}i:28;a:2:{s:4:\"name\";s:9:\"Hansgrohe\";s:3:\"nbr\";s:3:\"212\";}i:32;a:2:{s:4:\"name\";s:7:\"Radaway\";s:3:\"nbr\";s:2:\"50\";}i:33;a:2:{s:4:\"name\";s:27:\"MDD grop (Мойдодыр)\";s:3:\"nbr\";s:3:\"267\";}i:35;a:2:{s:4:\"name\";s:4:\"Kolo\";s:3:\"nbr\";s:1:\"1\";}i:37;a:2:{s:4:\"name\";s:5:\"Volle\";s:3:\"nbr\";s:2:\"98\";}i:38;a:2:{s:4:\"name\";s:6:\"Marsan\";s:3:\"nbr\";s:1:\"9\";}i:39;a:2:{s:4:\"name\";s:13:\"Villeroy&Boch\";s:3:\"nbr\";s:1:\"1\";}i:40;a:2:{s:4:\"name\";s:6:\"Emmevi\";s:3:\"nbr\";s:3:\"118\";}i:41;a:2:{s:4:\"name\";s:3:\"WGT\";s:3:\"nbr\";s:2:\"30\";}i:42;a:2:{s:4:\"name\";s:9:\"AquaWorld\";s:3:\"nbr\";s:2:\"22\";}i:44;a:2:{s:4:\"name\";s:4:\"SWAN\";s:3:\"nbr\";s:2:\"44\";}i:46;a:2:{s:4:\"name\";s:7:\"Veronis\";s:3:\"nbr\";s:3:\"227\";}i:47;a:2:{s:4:\"name\";s:12:\"Fancy Marble\";s:3:\"nbr\";s:3:\"129\";}i:48;a:2:{s:4:\"name\";s:5:\"Grohe\";s:3:\"nbr\";s:2:\"54\";}i:53;a:2:{s:4:\"name\";s:2:\"GM\";s:3:\"nbr\";s:2:\"34\";}i:57;a:2:{s:4:\"name\";s:5:\"BESCO\";s:3:\"nbr\";s:3:\"101\";}i:58;a:2:{s:4:\"name\";s:5:\"KO&PO\";s:3:\"nbr\";s:2:\"95\";}i:59;a:2:{s:4:\"name\";s:7:\"Polimat\";s:3:\"nbr\";s:3:\"117\";}i:61;a:2:{s:4:\"name\";s:7:\"DURAVIT\";s:3:\"nbr\";s:1:\"1\";}i:69;a:2:{s:4:\"name\";s:10:\"BOTTICELLI\";s:3:\"nbr\";s:3:\"105\";}i:70;a:2:{s:4:\"name\";s:5:\"AM PM\";s:3:\"nbr\";s:2:\"19\";}i:71;a:2:{s:4:\"name\";s:7:\"Diamond\";s:3:\"nbr\";s:2:\"13\";}i:72;a:2:{s:4:\"name\";s:5:\"Dusel\";s:3:\"nbr\";s:2:\"89\";}i:73;a:2:{s:4:\"name\";s:7:\"Primera\";s:3:\"nbr\";s:1:\"7\";}i:74;a:2:{s:4:\"name\";s:5:\"Orans\";s:3:\"nbr\";s:1:\"2\";}i:75;a:2:{s:4:\"name\";s:9:\"Riva Pool\";s:3:\"nbr\";s:2:\"11\";}i:76;a:3:{s:4:\"name\";s:6:\"SANTEH\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:77;a:2:{s:4:\"name\";s:5:\"Artex\";s:3:\"nbr\";s:2:\"62\";}i:83;a:2:{s:4:\"name\";s:5:\"VIVIA\";s:3:\"nbr\";s:2:\"77\";}i:84;a:2:{s:4:\"name\";s:4:\"Qtap\";s:3:\"nbr\";s:3:\"153\";}i:86;a:2:{s:4:\"name\";s:4:\"Lidz\";s:3:\"nbr\";s:3:\"226\";}i:88;a:2:{s:4:\"name\";s:10:\"WGT Rialto\";s:3:\"nbr\";s:2:\"34\";}i:104;a:3:{s:4:\"name\";s:7:\"Liberta\";s:3:\"nbr\";s:2:\"14\";s:7:\"checked\";b:1;}i:105;a:2:{s:4:\"name\";s:10:\"Wave Glass\";s:3:\"nbr\";s:2:\"50\";}i:107;a:2:{s:4:\"name\";s:6:\"SHOWER\";s:3:\"nbr\";s:2:\"11\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:4;a:0:{}i:5;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Цена\";s:3:\"max\";d:50549;s:3:\"min\";d:72;s:4:\"unit\";s:3:\"₴\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:16:\"не число\";}s:12:\"currencyCode\";s:3:\"UAH\";s:14:\"currencySymbol\";s:3:\"₴\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:16:\"не число\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:116;s:5:\"value\";N;}i:6;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:17:\"В продаже\";s:3:\"nbr\";i:15;}s:3:\"new\";a:2:{s:4:\"name\";s:21:\"Новый товар\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:7;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";s:1:\"1\";s:4:\"name\";s:10:\"Ножки\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:2:{i:2;a:4:{s:4:\"name\";s:17:\"Без ножек\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1;a:4:{s:4:\"name\";s:16:\"C ножками\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:8;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";s:2:\"57\";s:4:\"name\";s:8:\"Цвет\";s:14:\"is_color_group\";b:1;s:6:\"values\";a:2:{i:447;a:5:{s:4:\"name\";s:10:\"Белый\";s:3:\"nbr\";s:1:\"4\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffffff\";}i:448;a:5:{s:4:\"name\";s:12:\"Черный\";s:3:\"nbr\";s:1:\"4\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#000000\";}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"1\";s:6:\"values\";a:10:{i:168;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:2:\"80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:18;a:5:{s:3:\"nbr\";s:2:\"18\";s:4:\"name\";s:2:\"90\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:1;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:3:\"100\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:2;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"110\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:204;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"115\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:3:\"120\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:152;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"135\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:6;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"150\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:7;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"160\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:8;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:3:\"170\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:10:\"Длина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"2\";s:6:\"values\";a:12:{i:14;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:2:\"70\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:15;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:2:\"75\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:16;a:5:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:2:\"80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"85\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3298;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:2:\"85\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:19;a:5:{s:3:\"nbr\";s:2:\"19\";s:4:\"name\";s:2:\"90\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:21;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:3:\"100\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42391;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"100\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"115\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3450;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"120\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:153;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"135\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:154;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"150\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:12:\"Ширина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"3\";s:6:\"values\";a:1:{i:29533;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"51\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:14:\"Глубина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:12;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"4\";s:6:\"values\";a:1:{i:29534;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"350\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:10:\"Объем\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"5\";s:6:\"values\";a:8:{i:3217;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:3:\"185\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3295;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"190\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:212;a:5:{s:3:\"nbr\";s:2:\"16\";s:4:\"name\";s:3:\"195\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:2539;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:3:\"200\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:170;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"205\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:162;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:3:\"210\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:148;a:5:{s:3:\"nbr\";s:2:\"15\";s:4:\"name\";s:3:\"215\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:149;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"220\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:12:\"Высота\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:14;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"6\";s:6:\"values\";a:4:{i:17547;a:5:{s:3:\"nbr\";s:2:\"19\";s:4:\"name\";s:39:\"Гидромассажные боксы\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12240;a:5:{s:3:\"nbr\";s:2:\"32\";s:4:\"name\";s:27:\"Душевая кабина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:107;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:26:\"Прямоугольная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:106;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"Угловая\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:6:\"Тип\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:15;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"8\";s:6:\"values\";a:5:{i:63675;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"brushed\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12247;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:10:\"Белый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37518;a:5:{s:3:\"nbr\";s:2:\"35\";s:4:\"name\";s:10:\"Сатин\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:25966;a:5:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:8:\"Хром\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17440;a:5:{s:3:\"nbr\";s:2:\"16\";s:4:\"name\";s:12:\"Черный\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:23:\"Цвет профиля\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:16;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"9\";s:6:\"values\";a:5:{i:37427;a:5:{s:3:\"nbr\";s:2:\"13\";s:4:\"name\";s:14:\"Матовый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12249;a:5:{s:3:\"nbr\";s:2:\"23\";s:4:\"name\";s:20:\"Прозрачный\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12248;a:5:{s:3:\"nbr\";s:2:\"13\";s:4:\"name\";s:14:\"Рисунок\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42679;a:5:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:24:\"Тонированные\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:27639;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:46:\"тонированное; прозрачное\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:21:\"Цвет стекла\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:4:{i:3294;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Италия\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:19058;a:5:{s:3:\"nbr\";s:2:\"31\";s:4:\"name\";s:10:\"Китай\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:73710;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Турция\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:14943;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:14:\"Украина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:52:\"Страна-производитель товара\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:18;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"18\";s:6:\"values\";a:5:{i:3961;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:26:\"Асимметричная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3697;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:20:\"Квадратная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:7403;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:23:\"Особая форма\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3700;a:5:{s:3:\"nbr\";s:2:\"21\";s:4:\"name\";s:26:\"Прямоугольная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:7405;a:5:{s:3:\"nbr\";s:2:\"25\";s:4:\"name\";s:14:\"Угловая\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:10:\"Форма\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:19;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"19\";s:6:\"values\";a:3:{i:37407;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:20:\"Раздвижное\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17302;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:20:\"Раздвижные\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3706;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:18:\"Распашные\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:29:\"Открытие дверцы\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:20;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"20\";s:6:\"values\";a:4:{i:42678;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"90x90x205 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63676;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"90х90х210 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38064;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:13:\"100х80х195 \";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:29535;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"510×1200×1800\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:27:\"Размеры (ДхШхГ)\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:21;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"24\";s:6:\"values\";a:2:{i:3955;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Акрил\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12255;a:5:{s:3:\"nbr\";s:2:\"53\";s:4:\"name\";s:12:\"Стекло\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:16:\"Материал\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:22;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"25\";s:6:\"values\";a:1:{i:9099;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:37:\"Докупается отдельно\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:12:\"Панель\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:23;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"26\";s:6:\"values\";a:1:{i:9100;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:37:\"Докупаются отдельно\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:10:\"Ножки\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:24;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"27\";s:6:\"values\";a:2:{i:7339;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:81:\"10 лет официальной гарантии от производителя\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17287;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:49:\"12 месяцев от производителя\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:16:\"Гарантия\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:25;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"36\";s:6:\"values\";a:1:{i:4408;a:5:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:20:\"Пристенная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:18:\"Установка\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:26;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"38\";s:6:\"values\";a:1:{i:7686;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"5 мм\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:33:\"Толщина материала\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:27;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"43\";s:6:\"values\";a:2:{i:12239;a:5:{s:3:\"nbr\";s:2:\"15\";s:4:\"name\";s:21:\"Без поддона\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12238;a:5:{s:3:\"nbr\";s:2:\"39\";s:4:\"name\";s:19:\"С поддоном\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:29:\"Наличие поддона\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:28;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"44\";s:6:\"values\";a:1:{i:12242;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:6:\"Нет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:25:\"Задние стенки\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:29;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"45\";s:6:\"values\";a:2:{i:12243;a:5:{s:3:\"nbr\";s:2:\"41\";s:4:\"name\";s:20:\"Раздвижные\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38705;a:5:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:18:\"Распашная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:10:\"Двери\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:30;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"47\";s:6:\"values\";a:12:{i:27679;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"13 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17290;a:5:{s:3:\"nbr\";s:2:\"15\";s:4:\"name\";s:2:\"15\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:28155;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:2:\"30\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:28247;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:2:\"40\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62903;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"45\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:72837;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"45\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17373;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:2:\"47\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62830;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62849;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62877;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62961;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63085;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:27:\"Высота поддона\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:31;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"48\";s:6:\"values\";a:1:{i:12251;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:26:\"Универсальное\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:24:\"Расположение\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:32;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"49\";s:6:\"values\";a:1:{i:12252;a:5:{s:3:\"nbr\";s:2:\"37\";s:4:\"name\";s:10:\"Акрил\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:31:\"Материал поддона\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:33;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"50\";s:6:\"values\";a:5:{i:12254;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:20:\"Квадратная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12253;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:22:\"Полукруглая\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37039;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:26:\"Прямоугольная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17291;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:24:\"Пятиугольная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38706;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"Угловая\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:23:\"Форма кабины\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:34;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"51\";s:6:\"values\";a:2:{i:12256;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:8:\"Есть\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12257;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:6:\"Нет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:25:\"Наличие крыши\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:35;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"52\";s:6:\"values\";a:1:{i:17997;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:61:\"На заказ. Срок поставки 2 – 28 дней.\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:29:\"Доставка/Оплата\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:36;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"54\";s:6:\"values\";a:5:{i:17932;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"4 мм\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12951;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:6:\"5 мм\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38702;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:1:\"6\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17319;a:5:{s:3:\"nbr\";s:2:\"27\";s:4:\"name\";s:7:\"6 мм.\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42677;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:1:\"8\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:27:\"Толщина стекла\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:37;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"56\";s:6:\"values\";a:1:{i:33228;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:27:\"Душевая кабина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:25:\"Вид смесителя\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:38;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"60\";s:6:\"values\";a:3:{i:13025;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:10:\"Белый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:13026;a:5:{s:3:\"nbr\";s:2:\"17\";s:4:\"name\";s:8:\"Хром\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17441;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:12:\"Черный\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:32:\"Цвет ручек дверей\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:39;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"63\";s:6:\"values\";a:42:{i:27977;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Devit\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:45279;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:7:\"LIBERTA\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62829;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62848;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62876;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62902;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:62960;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63028;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63029;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63082;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63083;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"MIRACLE\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63084;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63086;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:72836;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Miracle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:72628;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"ROCA \";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63245;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63318;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63320;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63321;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63400;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63613;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63670;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63674;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63694;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63734;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63813;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63814;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63816;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63817;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63818;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63819;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63820;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63821;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:64011;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:64026;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:64085;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:64086;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:64150;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:64151;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:74154;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Sansa\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:63588;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Sansa \";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:76285;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"SHOWER\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:26:\"Производитель\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:40;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"64\";s:6:\"values\";a:2:{i:15748;a:5:{s:3:\"nbr\";s:2:\"23\";s:4:\"name\";s:16:\"Глубокий\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:15746;a:5:{s:3:\"nbr\";s:2:\"17\";s:4:\"name\";s:12:\"Мелкий\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:21:\"Тип поддона\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:41;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"65\";s:6:\"values\";a:4:{i:37425;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:12:\"Графит\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37176;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:16:\"Интимато\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17251;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:14:\"Матовый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:15756;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:20:\"Прозрачный\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:32:\"Цвет двери/стенки\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:42;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"67\";s:6:\"values\";a:2:{i:17927;a:5:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:20:\"Раздвижное\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:17928;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:18:\"Распашное\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:20:\"Открывание\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:43;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"69\";s:6:\"values\";a:5:{i:35353;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"80x80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37056;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"90x80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:35139;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"90x90\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:35376;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:6:\"100x80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:35142;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:7:\"100x100\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:12:\"Размер\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:44;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"84\";s:6:\"values\";a:2:{i:41666;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:41632;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:12:\"Дверка\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}i:45;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"86\";s:6:\"values\";a:1:{i:41634;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:10:\"Новое\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:18:\"Состояние\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"2\";}}}")	22.059 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:205 /modules/ps_facetedsearch/src/Product/SearchProvider.php:221 (insertIntoCache) /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)
356	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 14450 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 14450 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	15.388 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5808 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /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 (13, 104, 17, 7, 18, 76) 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	13.300 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)
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 (13, 104, 17, 7, 18, 76) 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	11.030 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)
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 (13, 104, 17, 7, 18, 76) 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	9.763 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)
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 (13, 104, 17, 7, 18, 76) 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.911 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)
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 (13, 104, 17, 7, 18, 76) 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	6.590 ms	318720	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 (13, 104, 17, 7, 18, 76) 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	5.997 ms	796800	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 (13, 104, 17, 7, 18, 76) 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	5.645 ms	318720	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)
685	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	4.823 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)
186	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 (13, 104, 17, 7, 18, 76) 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=47)) GROUP BY pac.id_attribute	4.105 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)
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 (13, 104, 17, 7, 18, 76) 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	4.048 ms	318720	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)
666	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.233 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)
194	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 (13, 104, 17, 7, 18, 76) 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=52)) GROUP BY pac.id_attribute	3.121 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)
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 (13, 104, 17, 7, 18, 76) 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	3.105 ms	478080	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)
220	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 (13, 104, 17, 7, 18, 76) 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=65)) GROUP BY pac.id_attribute	2.363 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)
222	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 (13, 104, 17, 7, 18, 76) 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=66)) GROUP BY pac.id_attribute	2.324 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)
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 (13, 104, 17, 7, 18, 76) 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	2.267 ms	27556	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)
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 (13, 104, 17, 7, 18, 76) 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	2.102 ms	27556	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)
350	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	1.957 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5702 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /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)
224	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 (13, 104, 17, 7, 18, 76) 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=67)) GROUP BY pac.id_attribute	1.871 ms	478080	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)
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 (13, 104, 17, 7, 18, 76) 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)))	1.701 ms	468452			/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)
174	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 (13, 104, 17, 7, 18, 76) 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=41)) GROUP BY pac.id_attribute	1.654 ms	936904	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)
234	SELECT SQL_NO_CACHE 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` = 2) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 5 ORDER BY vl.`value` ASC	1.607 ms	529	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:221 /modules/ps_facetedsearch/src/Filters/Block.php:863 (getFeatureValues) /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)
96	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 (13, 104, 17, 7, 18, 76) 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=1)) GROUP BY pac.id_attribute	1.593 ms	637440	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)
176	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 (13, 104, 17, 7, 18, 76) 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=42)) GROUP BY pac.id_attribute	1.579 ms	936904	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)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	1.508 ms	1088			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
254	SELECT SQL_NO_CACHE 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` = 2) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 20 ORDER BY vl.`value` ASC	1.405 ms	470	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:221 /modules/ps_facetedsearch/src/Filters/Block.php:863 (getFeatureValues) /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)
340	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-10-09 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (14450,12371,12370,12369,12368,10326,10325,10324,10323,10322,10320,10319,10306,10304,10303,10302,10301,10296,10295,9053,9052,9051,9050,6704)	1.330 ms	24			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /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)
82	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` 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 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.nleft, c.position	1.298 ms	269	Yes		/classes/Category.php:710 /modules/ps_facetedsearch/src/Filters/Block.php:981 (getAllCategoriesName) /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)
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 (13, 104, 17, 7, 18, 76) 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))	1.235 ms	468452			/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 (13, 104, 17, 7, 18, 76) 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))	1.221 ms	468452			/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)
190	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 (13, 104, 17, 7, 18, 76) 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=49)) GROUP BY pac.id_attribute	1.190 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)
210	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 (13, 104, 17, 7, 18, 76) 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=60)) GROUP BY pac.id_attribute	1.183 ms	318720	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)
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 (13, 104, 17, 7, 18, 76) 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	1.131 ms	936904	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)
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 (13, 104, 17, 7, 18, 76) 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	1.128 ms	936904	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)
284	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 (13, 104, 17, 7, 18, 76) 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	1.124 ms	27556	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)
94	SELECT SQL_NO_CACHE 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 (13, 104, 17, 7, 18, 76) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 214) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2026-10-09 21:15:05' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:15:05' <= sp.to) ) WHERE ((sp.reduction>0))	1.122 ms	27556			/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:601 (count) /modules/ps_facetedsearch/src/Filters/Block.php:139 (getHighlightsBlock) /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 (13, 104, 17, 7, 18, 76) 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	1.120 ms	27556	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