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

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

Товаров: 260.

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

Load Time	872 ms
Querying Time	597 ms
Queries	874
Memory Peak Usage	20.6 Mb
Included Files	1053 files - 10.00 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	47.732 ms	47.732 ms	1.95 Mb	1.9 Mb
__construct	1.326 ms	49.058 ms	- Mb	2.5 Mb
init	13.636 ms	62.694 ms	0.84 Mb	2.9 Mb
checkAccess	0.001 ms	62.695 ms	- Mb	2.9 Mb
setMedia	5.902 ms	68.597 ms	0.35 Mb	3.1 Mb
postProcess	0.001 ms	68.598 ms	- Mb	3.1 Mb
initHeader	0.000 ms	68.598 ms	- Mb	3.1 Mb
initContent	660.472 ms	729.070 ms	9.25 Mb	14.6 Mb
initFooter	0.001 ms	729.071 ms	- Mb	14.6 Mb
display	142.501 ms	872 ms	7.36 Mb	20.6 Mb

Hook	Time	Memory Usage
displayProductListReviews	25.500 ms	0.34 Mb
=> productcomments (widget)	10.327 ms	0.27 Mb
=> productcomments (widget)	0.459 ms	- Mb
=> productcomments (widget)	0.458 ms	- Mb
=> productcomments (widget)	0.474 ms	- Mb
=> productcomments (widget)	0.632 ms	- Mb
=> productcomments (widget)	0.596 ms	- Mb
=> productcomments (widget)	0.525 ms	- Mb
=> productcomments (widget)	0.696 ms	- Mb
=> productcomments (widget)	0.690 ms	- Mb
=> productcomments (widget)	0.900 ms	- Mb
=> productcomments (widget)	0.587 ms	- Mb
=> productcomments (widget)	0.592 ms	- Mb
=> productcomments (widget)	0.586 ms	- Mb
=> productcomments (widget)	0.585 ms	- Mb
=> productcomments (widget)	0.909 ms	- Mb
=> productcomments (widget)	0.876 ms	- Mb
=> productcomments (widget)	0.599 ms	- Mb
=> productcomments (widget)	0.587 ms	- Mb
=> productcomments (widget)	0.581 ms	- Mb
=> productcomments (widget)	0.876 ms	- Mb
=> productcomments (widget)	0.898 ms	- Mb
=> productcomments (widget)	0.886 ms	- Mb
=> productcomments (widget)	0.593 ms	- Mb
=> productcomments (widget)	0.588 ms	- Mb
RotatorImg	15.909 ms	1.33 Mb
=> posrotatorimg	0.982 ms	0.07 Mb
=> posrotatorimg	0.594 ms	0.06 Mb
=> posrotatorimg	0.607 ms	0.05 Mb
=> posrotatorimg	0.579 ms	0.05 Mb
=> posrotatorimg	0.576 ms	0.05 Mb
=> posrotatorimg	0.607 ms	0.05 Mb
=> posrotatorimg	0.549 ms	0.05 Mb
=> posrotatorimg	0.705 ms	0.05 Mb
=> posrotatorimg	0.724 ms	0.05 Mb
=> posrotatorimg	0.752 ms	0.05 Mb
=> posrotatorimg	0.602 ms	0.05 Mb
=> posrotatorimg	0.542 ms	0.05 Mb
=> posrotatorimg	0.615 ms	0.05 Mb
=> posrotatorimg	0.633 ms	0.05 Mb
=> posrotatorimg	0.821 ms	0.05 Mb
=> posrotatorimg	0.699 ms	0.05 Mb
=> posrotatorimg	0.616 ms	0.05 Mb
=> posrotatorimg	0.537 ms	0.05 Mb
=> posrotatorimg	0.618 ms	0.05 Mb
=> posrotatorimg	0.634 ms	0.05 Mb
=> posrotatorimg	0.794 ms	0.05 Mb
=> posrotatorimg	0.800 ms	0.05 Mb
=> posrotatorimg	0.702 ms	0.05 Mb
=> posrotatorimg	0.621 ms	0.05 Mb
displayLeftColumn	14.805 ms	1.40 Mb
=> ps_categorytree (widget)	13.490 ms	1.35 Mb
=> ps_advertising (widget)	1.315 ms	0.05 Mb
DisplayProductListFunctionalButtons	10.857 ms	0.10 Mb
=> blockwishlist	0.446 ms	- Mb
=> blockwishlist	0.381 ms	- Mb
=> blockwishlist	0.374 ms	- Mb
=> blockwishlist	0.377 ms	- Mb
=> blockwishlist	0.380 ms	- Mb
=> blockwishlist	0.375 ms	- Mb
=> blockwishlist	0.565 ms	- Mb
=> blockwishlist	0.563 ms	- Mb
=> blockwishlist	0.562 ms	- Mb
=> blockwishlist	0.562 ms	- Mb
=> blockwishlist	0.374 ms	- Mb
=> blockwishlist	0.373 ms	- Mb
=> blockwishlist	0.374 ms	- Mb
=> blockwishlist	0.545 ms	- Mb
=> blockwishlist	0.560 ms	- Mb
=> blockwishlist	0.560 ms	- Mb
=> blockwishlist	0.382 ms	- Mb
=> blockwishlist	0.375 ms	- Mb
=> blockwishlist	0.374 ms	- Mb
=> blockwishlist	0.559 ms	- Mb
=> blockwishlist	0.569 ms	- Mb
=> blockwishlist	0.485 ms	- Mb
=> blockwishlist	0.371 ms	- Mb
=> blockwishlist	0.372 ms	- Mb
DisplayMegamenu	9.407 ms	0.05 Mb
=> posmegamenu	9.407 ms	0.05 Mb
displayProductListCompare	8.792 ms	0.03 Mb
=> poscompare (widget)	0.318 ms	- Mb
=> poscompare (widget)	0.310 ms	- Mb
=> poscompare (widget)	0.314 ms	- Mb
=> poscompare (widget)	0.306 ms	- Mb
=> poscompare (widget)	0.304 ms	- Mb
=> poscompare (widget)	0.311 ms	- Mb
=> poscompare (widget)	0.458 ms	- Mb
=> poscompare (widget)	0.473 ms	- Mb
=> poscompare (widget)	0.471 ms	- Mb
=> poscompare (widget)	0.477 ms	- Mb
=> poscompare (widget)	0.306 ms	- Mb
=> poscompare (widget)	0.305 ms	- Mb
=> poscompare (widget)	0.307 ms	- Mb
=> poscompare (widget)	0.457 ms	- Mb
=> poscompare (widget)	0.457 ms	- Mb
=> poscompare (widget)	0.458 ms	- Mb
=> poscompare (widget)	0.317 ms	- Mb
=> poscompare (widget)	0.305 ms	- Mb
=> poscompare (widget)	0.307 ms	- Mb
=> poscompare (widget)	0.457 ms	- Mb
=> poscompare (widget)	0.459 ms	- Mb
=> poscompare (widget)	0.305 ms	- Mb
=> poscompare (widget)	0.305 ms	- Mb
=> poscompare (widget)	0.304 ms	- Mb
displayTop	8.433 ms	0.71 Mb
=> posstaticblocks (widget)	0.863 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.857 ms	0.07 Mb
=> poscompare (widget)	0.559 ms	0.04 Mb
=> possearchproducts (widget)	6.154 ms	0.57 Mb
DisplayFooter	2.451 ms	0.13 Mb
=> blockwishlist	2.007 ms	0.12 Mb
=> rozershowall	0.441 ms	0.01 Mb
=> rozerhomereviews	0.003 ms	- Mb
displayNav	2.379 ms	0.16 Mb
=> ps_languageselector (widget)	0.741 ms	0.05 Mb
=> ps_currencyselector (widget)	0.187 ms	0.04 Mb
=> ps_customersignin (widget)	0.563 ms	0.04 Mb
=> posstaticblocks (widget)	0.888 ms	0.03 Mb
DisplayHeader	2.249 ms	0.04 Mb
=> ps_shoppingcart	0.039 ms	- Mb
=> productcomments	0.227 ms	- Mb
=> ps_googleanalytics	0.086 ms	- Mb
=> posslideshows	0.226 ms	- Mb
=> poslistcategories	0.105 ms	- Mb
=> poslogo	0.056 ms	- Mb
=> poslistcateproduct	0.484 ms	0.01 Mb
=> posrecommendedproducts	0.061 ms	- Mb
=> rozeroneclick	0.001 ms	- Mb
=> rozershowall	0.171 ms	- Mb
=> rozerhomereviews	0.001 ms	- Mb
=> posrotatorimg	0.792 ms	0.02 Mb
displayBanner	1.626 ms	0.12 Mb
=> posstaticblocks (widget)	1.626 ms	0.12 Mb
Header	1.505 ms	0.08 Mb
=> poscompare	0.171 ms	- Mb
=> possearchproducts	0.454 ms	- Mb
=> posthemeoptions	0.212 ms	0.07 Mb
=> posmegamenu	0.244 ms	- Mb
=> posvegamenu	0.244 ms	- Mb
=> posfeaturedproducts	0.057 ms	- Mb
=> posnewproducts	0.056 ms	- Mb
=> postabproductslider	0.067 ms	- Mb
ActionFrontControllerSetMedia	1.486 ms	0.01 Mb
=> blockreassurance	0.451 ms	- Mb
=> blockwishlist	0.700 ms	- Mb
=> ps_emailsubscription	0.106 ms	- Mb
=> ps_socialfollow	0.171 ms	- Mb
=> ps_emailalerts	0.058 ms	- Mb
displayFooter	1.208 ms	0.08 Mb
=> posstaticfooter (widget)	1.208 ms	0.08 Mb
displayFooterAfter	0.865 ms	0.03 Mb
=> posstaticfooter (widget)	0.865 ms	0.03 Mb
ProductSearchProvider	0.786 ms	- Mb
=> ps_facetedsearch	0.786 ms	- Mb
DisplayLeftColumn	0.785 ms	0.18 Mb
=> ps_facetedsearch	0.785 ms	0.18 Mb
DisplayTop	0.445 ms	- Mb
=> blockwishlist	0.445 ms	- Mb
displayBeforeBodyClosingTag	0.371 ms	0.01 Mb
=> poscompare (widget)	0.371 ms	0.01 Mb
FilterProductSearch	0.003 ms	- Mb
=> rozershowall	0.003 ms	- Mb
ActionFrontControllerSetVariables	0.002 ms	- Mb
=> productcomments	0.002 ms	- Mb
ActionProductSearchProviderRunQueryBefore	0.002 ms	- Mb
=> rozershowall	0.002 ms	- Mb
22 hook(s)	109.866 ms	4.79 Mb

Module	Time	Memory Usage
blockreassurance	1.619 ms	0.14 Mb
__construct	1.165 ms	0.13 Mb
hookActionFrontControllerSetMedia	0.454 ms	0.01 Mb
blockwishlist	14.343 ms	0.24 Mb
__construct	0.295 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.702 ms	- Mb
hookDisplayTop	0.446 ms	0.01 Mb
hookDisplayProductListFunctionalButtons	0.447 ms	0.01 Mb
hookDisplayProductListFunctionalButtons	0.382 ms	- Mb
hookDisplayProductListFunctionalButtons	0.375 ms	- Mb
hookDisplayProductListFunctionalButtons	0.378 ms	- Mb
hookDisplayProductListFunctionalButtons	0.382 ms	- Mb
hookDisplayProductListFunctionalButtons	0.376 ms	- Mb
hookDisplayProductListFunctionalButtons	0.567 ms	- Mb
hookDisplayProductListFunctionalButtons	0.565 ms	- Mb
hookDisplayProductListFunctionalButtons	0.564 ms	- Mb
hookDisplayProductListFunctionalButtons	0.563 ms	- Mb
hookDisplayProductListFunctionalButtons	0.375 ms	- Mb
hookDisplayProductListFunctionalButtons	0.374 ms	- Mb
hookDisplayProductListFunctionalButtons	0.375 ms	- Mb
hookDisplayProductListFunctionalButtons	0.546 ms	- Mb
hookDisplayProductListFunctionalButtons	0.562 ms	- Mb
hookDisplayProductListFunctionalButtons	0.562 ms	- Mb
hookDisplayProductListFunctionalButtons	0.384 ms	- Mb
hookDisplayProductListFunctionalButtons	0.376 ms	- Mb
hookDisplayProductListFunctionalButtons	0.375 ms	- Mb
hookDisplayProductListFunctionalButtons	0.561 ms	- Mb
hookDisplayProductListFunctionalButtons	0.571 ms	- Mb
hookDisplayProductListFunctionalButtons	0.486 ms	- Mb
hookDisplayProductListFunctionalButtons	0.372 ms	- Mb
hookDisplayProductListFunctionalButtons	0.373 ms	- Mb
hookDisplayFooter	2.008 ms	0.12 Mb
ps_emailsubscription	0.340 ms	0.01 Mb
__construct	0.233 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.107 ms	- Mb
ps_socialfollow	0.392 ms	0.01 Mb
__construct	0.220 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.172 ms	- Mb
ps_emailalerts	0.309 ms	0.01 Mb
__construct	0.251 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.058 ms	- Mb
productcomments	25.939 ms	0.36 Mb
__construct	0.171 ms	0.01 Mb
hookActionFrontControllerSetVariables	0.002 ms	- Mb
hookDisplayHeader	0.227 ms	- Mb
displayProductListReviews	10.329 ms	0.27 Mb
displayProductListReviews	0.461 ms	- Mb
displayProductListReviews	0.459 ms	- Mb
displayProductListReviews	0.475 ms	- Mb
displayProductListReviews	0.633 ms	- Mb
displayProductListReviews	0.598 ms	- Mb
displayProductListReviews	0.526 ms	- Mb
displayProductListReviews	0.698 ms	- Mb
displayProductListReviews	0.693 ms	- Mb
displayProductListReviews	0.901 ms	- Mb
displayProductListReviews	0.589 ms	- Mb
displayProductListReviews	0.593 ms	- Mb
displayProductListReviews	0.587 ms	- Mb
displayProductListReviews	0.586 ms	- Mb
displayProductListReviews	0.910 ms	- Mb
displayProductListReviews	0.878 ms	- Mb
displayProductListReviews	0.601 ms	- Mb
displayProductListReviews	0.589 ms	- Mb
displayProductListReviews	0.583 ms	- Mb
displayProductListReviews	0.878 ms	- Mb
displayProductListReviews	0.900 ms	- Mb
displayProductListReviews	0.888 ms	- Mb
displayProductListReviews	0.594 ms	- Mb
displayProductListReviews	0.590 ms	- Mb
ps_shoppingcart	1.049 ms	0.08 Mb
__construct	0.151 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
displayTop	0.858 ms	0.07 Mb
ps_googleanalytics	0.179 ms	0.01 Mb
__construct	0.092 ms	0.01 Mb
hookDisplayHeader	0.087 ms	- Mb
posslideshows	0.422 ms	0.02 Mb
__construct	0.196 ms	0.02 Mb
hookDisplayHeader	0.226 ms	- Mb
poslistcategories	0.286 ms	0.01 Mb
__construct	0.180 ms	0.01 Mb
hookDisplayHeader	0.106 ms	- Mb
poslogo	0.230 ms	0.01 Mb
__construct	0.174 ms	0.01 Mb
hookDisplayHeader	0.056 ms	- Mb
poslistcateproduct	0.667 ms	0.02 Mb
__construct	0.182 ms	0.01 Mb
hookDisplayHeader	0.485 ms	0.01 Mb
posrecommendedproducts	0.217 ms	0.01 Mb
__construct	0.155 ms	0.01 Mb
hookDisplayHeader	0.062 ms	- Mb
rozeroneclick	0.049 ms	0.01 Mb
__construct	0.048 ms	- Mb
hookDisplayHeader	0.001 ms	- Mb
rozershowall	0.669 ms	0.02 Mb
__construct	0.049 ms	- Mb
hookDisplayHeader	0.172 ms	- Mb
hookActionProductSearchProviderRunQueryBefore	0.003 ms	- Mb
hookFilterProductSearch	0.004 ms	- Mb
hookDisplayFooter	0.442 ms	0.01 Mb
rozerhomereviews	0.054 ms	0.01 Mb
__construct	0.048 ms	- Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayFooter	0.004 ms	- Mb
poscompare	10.091 ms	0.10 Mb
__construct	0.164 ms	0.01 Mb
hookHeader	0.172 ms	- Mb
displayTop	0.560 ms	0.04 Mb
displayProductListCompare	0.319 ms	- Mb
displayProductListCompare	0.311 ms	- Mb
displayProductListCompare	0.315 ms	- Mb
displayProductListCompare	0.307 ms	- Mb
displayProductListCompare	0.305 ms	- Mb
displayProductListCompare	0.312 ms	- Mb
displayProductListCompare	0.459 ms	- Mb
displayProductListCompare	0.475 ms	- Mb
displayProductListCompare	0.473 ms	- Mb
displayProductListCompare	0.478 ms	- Mb
displayProductListCompare	0.307 ms	- Mb
displayProductListCompare	0.306 ms	- Mb
displayProductListCompare	0.308 ms	- Mb
displayProductListCompare	0.459 ms	- Mb
displayProductListCompare	0.459 ms	- Mb
displayProductListCompare	0.460 ms	- Mb
displayProductListCompare	0.318 ms	- Mb
displayProductListCompare	0.306 ms	- Mb
displayProductListCompare	0.308 ms	- Mb
displayProductListCompare	0.459 ms	- Mb
displayProductListCompare	0.461 ms	- Mb
displayProductListCompare	0.306 ms	- Mb
displayProductListCompare	0.306 ms	- Mb
displayProductListCompare	0.305 ms	- Mb
displayBeforeBodyClosingTag	0.372 ms	0.01 Mb
posrotatorimg	16.889 ms	1.36 Mb
__construct	0.157 ms	0.01 Mb
hookDisplayHeader	0.793 ms	0.02 Mb
hookRotatorImg	0.984 ms	0.07 Mb
hookRotatorImg	0.595 ms	0.06 Mb
hookRotatorImg	0.609 ms	0.06 Mb
hookRotatorImg	0.580 ms	0.06 Mb
hookRotatorImg	0.577 ms	0.06 Mb
hookRotatorImg	0.608 ms	0.06 Mb
hookRotatorImg	0.550 ms	0.06 Mb
hookRotatorImg	0.707 ms	0.06 Mb
hookRotatorImg	0.726 ms	0.06 Mb
hookRotatorImg	0.753 ms	0.06 Mb
hookRotatorImg	0.603 ms	0.06 Mb
hookRotatorImg	0.543 ms	0.06 Mb
hookRotatorImg	0.616 ms	0.06 Mb
hookRotatorImg	0.634 ms	0.06 Mb
hookRotatorImg	0.822 ms	0.06 Mb
hookRotatorImg	0.701 ms	0.06 Mb
hookRotatorImg	0.617 ms	0.06 Mb
hookRotatorImg	0.539 ms	0.06 Mb
hookRotatorImg	0.619 ms	0.06 Mb
hookRotatorImg	0.635 ms	0.06 Mb
hookRotatorImg	0.796 ms	0.06 Mb
hookRotatorImg	0.801 ms	0.06 Mb
hookRotatorImg	0.703 ms	0.06 Mb
hookRotatorImg	0.622 ms	0.06 Mb
possearchproducts	6.778 ms	0.58 Mb
__construct	0.168 ms	0.01 Mb
hookHeader	0.455 ms	- Mb
displayTop	6.155 ms	0.57 Mb
posthemeoptions	0.366 ms	0.07 Mb
__construct	0.153 ms	0.01 Mb
hookHeader	0.213 ms	0.07 Mb
posmegamenu	9.886 ms	0.06 Mb
__construct	0.232 ms	0.01 Mb
hookHeader	0.245 ms	- Mb
hookDisplayMegamenu	9.409 ms	0.05 Mb
posvegamenu	0.478 ms	0.01 Mb
__construct	0.233 ms	- Mb
hookHeader	0.245 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.158 ms	0.01 Mb
hookHeader	0.057 ms	- Mb
postabproductslider	0.227 ms	0.01 Mb
__construct	0.159 ms	0.01 Mb
hookHeader	0.068 ms	- Mb
ps_facetedsearch	2.448 ms	0.20 Mb
__construct	0.873 ms	0.01 Mb
hookProductSearchProvider	0.787 ms	- Mb
hookDisplayLeftColumn	0.788 ms	0.18 Mb
posstaticblocks	3.594 ms	0.19 Mb
__construct	0.212 ms	0.01 Mb
displayBanner	1.628 ms	0.12 Mb
displayNav	0.889 ms	0.03 Mb
displayTop	0.865 ms	0.03 Mb
ps_languageselector	0.898 ms	0.05 Mb
__construct	0.155 ms	0.01 Mb
displayNav	0.743 ms	0.05 Mb
ps_currencyselector	0.342 ms	0.05 Mb
__construct	0.154 ms	0.01 Mb
displayNav	0.188 ms	0.04 Mb
ps_customersignin	0.714 ms	0.05 Mb
__construct	0.150 ms	0.01 Mb
displayNav	0.564 ms	0.04 Mb
ps_categorytree	13.747 ms	1.35 Mb
__construct	0.254 ms	0.01 Mb
displayLeftColumn	13.493 ms	1.35 Mb
ps_advertising	1.740 ms	0.06 Mb
__construct	0.423 ms	0.01 Mb
displayLeftColumn	1.317 ms	0.05 Mb
posstaticfooter	2.213 ms	0.13 Mb
__construct	0.137 ms	0.01 Mb
displayFooter	1.210 ms	0.08 Mb
displayFooterAfter	0.866 ms	0.04 Mb
33 module(s)	117.607 ms	5.21 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) LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) WHERE ((sp.reduction>XX)) AND 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) LEFT JOIN ps_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) WHERE ((fp.id_feature=XX)) AND ((sp_XX.reduction>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) LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) WHERE ((sp.reduction>XX)) AND 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) LEFT JOIN ps_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) WHERE ((a.id_attribute_group=XX)) AND ((sp_XX.reduction>XX)) GROUP BY pac.id_attribute
64 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
26 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
25 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
25 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC 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 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;
23 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
16 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
12 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'ru-ru' OR `language_code` = 'ru-ru' LIMIT XX
5 queries	SELECT ps.* FROM ps_posmegamenu_submenu ps WHERE ps.`id_posmegamenu_item` = XX LIMIT XX
4 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
3 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
3 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 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
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 product_attribute_shop.`price` 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) WHERE pa.`id_product_attribute` = XX LIMIT XX
2 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) 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) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) 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) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
2 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
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
2 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
2 queries	SELECT pa., product_attribute_shop. 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) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`

Name	Instances	Source
Product	74	/classes/Link.php:113 (__construct) [id: 11267] /classes/Link.php:113 (__construct) [id: 11266] /classes/Link.php:113 (__construct) [id: 11264] /classes/Link.php:113 (__construct) [id: 11261] /classes/Link.php:113 (__construct) [id: 11244] /classes/Link.php:113 (__construct) [id: 11243] /classes/Link.php:113 (__construct) [id: 11012] /classes/Link.php:113 (__construct) [id: 11009] /classes/Link.php:113 (__construct) [id: 10779] /classes/Link.php:113 (__construct) [id: 9911] /classes/Link.php:113 (__construct) [id: 9910] /classes/Link.php:113 (__construct) [id: 9909] /classes/Link.php:113 (__construct) [id: 9908] /classes/Link.php:113 (__construct) [id: 9907] /classes/Link.php:113 (__construct) [id: 9906] /classes/Link.php:113 (__construct) [id: 9905] /classes/Link.php:113 (__construct) [id: 9904] /classes/Link.php:113 (__construct) [id: 9903] /classes/Link.php:113 (__construct) [id: 9902] /classes/Link.php:113 (__construct) [id: 9901] /classes/Link.php:113 (__construct) [id: 9900] /classes/Link.php:113 (__construct) [id: 9899] /classes/Link.php:113 (__construct) [id: 9898] /classes/Link.php:113 (__construct) [id: 9897] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11267] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11266] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11264] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11261] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11244] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11243] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11012] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 11009] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 10779] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9911] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9910] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9909] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9908] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9907] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9906] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9905] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9904] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9903] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9902] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9901] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9900] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9899] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9898] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 9897] /classes/Link.php:113 (__construct) [id: 11267] /classes/Link.php:113 (__construct) [id: 11266] /classes/Link.php:113 (__construct) [id: 11264] /classes/Link.php:113 (__construct) [id: 11261] /classes/Link.php:113 (__construct) [id: 11244] /classes/Link.php:113 (__construct) [id: 11243] /classes/Link.php:113 (__construct) [id: 11012] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 11012] /classes/Link.php:113 (__construct) [id: 11009] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 11009] /classes/Link.php:113 (__construct) [id: 10779] /classes/Link.php:113 (__construct) [id: 9911] /classes/Link.php:113 (__construct) [id: 9910] /classes/Link.php:113 (__construct) [id: 9909] /classes/Link.php:113 (__construct) [id: 9908] /classes/Link.php:113 (__construct) [id: 9907] /classes/Link.php:113 (__construct) [id: 9906] /classes/Link.php:113 (__construct) [id: 9905] /classes/Link.php:113 (__construct) [id: 9904] /classes/Link.php:113 (__construct) [id: 9903] /classes/Link.php:113 (__construct) [id: 9902] /classes/Link.php:113 (__construct) [id: 9901] /classes/Link.php:113 (__construct) [id: 9900] /classes/Link.php:113 (__construct) [id: 9899] /classes/Link.php:113 (__construct) [id: 9898] /classes/Link.php:113 (__construct) [id: 9897]
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: 37] /classes/Link.php:1574 (__construct) [id: 37] /classes/Link.php:1574 (__construct) [id: 37] /classes/Link.php:1574 (__construct) [id: 37] /classes/Link.php:1574 (__construct) [id: 37] /classes/Link.php:1574 (__construct) [id: 37] /classes/Link.php:1574 (__construct) [id: 5] /classes/Link.php:1574 (__construct) [id: 5] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22] /classes/Link.php:1574 (__construct) [id: 22]
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: ]
Combination	2	/classes/Product.php:5923 (__construct) [id: 109922] /classes/Product.php:5923 (__construct) [id: 109890]
Slideshow	1	/modules/posslideshows/posslideshows.php:39 (__construct) [id: ]
PosMegamenuClass	1	/modules/posmegamenu/posmegamenu.php:745 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
State	1	/classes/controller/FrontController.php:1768 (__construct) [id: 361]
AddressFormat	1	/classes/controller/FrontController.php:1763 (generateAddress) [id: ]
Gender	1	/classes/controller/FrontController.php:1692 (__construct) [id: 0]
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]
Risk	1	/classes/controller/FrontController.php:1695 (__construct) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=57)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	30.527 ms	14464320	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)
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 (70, 22, 73, 5, 46, 37) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0))	22.531 ms	628849			/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)
325	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("a894ba107e7fa3ad570fa1a556561f7f", "a:1:{s:7:\"filters\";a:36:{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:4:{i:3;a:2:{s:4:\"name\";s:10:\"Ванны\";s:3:\"nbr\";s:2:\"20\";}i:14;a:2:{s:4:\"name\";s:18:\"Смесители\";s:3:\"nbr\";s:1:\"6\";}i:20;a:2:{s:4:\"name\";s:32:\"Мебель для ванной\";s:3:\"nbr\";s:3:\"122\";}i:115;a:2:{s:4:\"name\";s:26:\"Акции и скидки\";s:3:\"nbr\";s:1:\"6\";}}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:260;}}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:\"260\";}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:15:{i:5;a:3:{s:4:\"name\";s:5:\"Ravak\";s:3:\"nbr\";s:2:\"10\";s:7:\"checked\";b:1;}i:6;a:2:{s:4:\"name\";s:11:\"Vagnerplast\";s:3:\"nbr\";s:1:\"3\";}i:9;a:2:{s:4:\"name\";s:8:\"Atlantis\";s:3:\"nbr\";s:1:\"1\";}i:22;a:3:{s:4:\"name\";s:7:\"Juventa\";s:3:\"nbr\";s:3:\"232\";s:7:\"checked\";b:1;}i:24;a:2:{s:4:\"name\";s:7:\"Imprese\";s:3:\"nbr\";s:2:\"21\";}i:33;a:2:{s:4:\"name\";s:27:\"MDD grop (Мойдодыр)\";s:3:\"nbr\";s:3:\"172\";}i:37;a:3:{s:4:\"name\";s:5:\"Volle\";s:3:\"nbr\";s:2:\"12\";s:7:\"checked\";b:1;}i:44;a:2:{s:4:\"name\";s:4:\"SWAN\";s:3:\"nbr\";s:2:\"44\";}i:47;a:2:{s:4:\"name\";s:12:\"Fancy Marble\";s:3:\"nbr\";s:1:\"3\";}i:59;a:2:{s:4:\"name\";s:7:\"Polimat\";s:3:\"nbr\";s:3:\"117\";}i:69;a:2:{s:4:\"name\";s:10:\"BOTTICELLI\";s:3:\"nbr\";s:2:\"67\";}i:70;a:3:{s:4:\"name\";s:5:\"AM PM\";s:3:\"nbr\";s:1:\"6\";s:7:\"checked\";b:1;}i:72;a:2:{s:4:\"name\";s:5:\"Dusel\";s:3:\"nbr\";s:1:\"5\";}i:84;a:2:{s:4:\"name\";s:4:\"Qtap\";s:3:\"nbr\";s:2:\"37\";}i:86;a:2:{s:4:\"name\";s:4:\"Lidz\";s:3:\"nbr\";s:2:\"14\";}}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:22770;s:3:\"min\";d:3250;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:260;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:60;}s:3:\"new\";a:2:{s:4:\"name\";s:21:\"Новый товар\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:3:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:260;s:7:\"checked\";b:1;}}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:1:\"2\";s:4:\"name\";s:12:\"Размер\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:5:{i:341;a:4:{s:4:\"name\";s:6:\"150x70\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:346;a:4:{s:4:\"name\";s:6:\"160x70\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:344;a:4:{s:4:\"name\";s:6:\"160x75\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:345;a:4:{s:4:\"name\";s:6:\"170x75\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:343;a:4:{s:4:\"name\";s:6:\"180x80\";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:9;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:\"23\";s:4:\"name\";s:18:\"Подсветка\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:2:{i:90;a:4:{s:4:\"name\";s:6:\"Нет\";s:3:\"nbr\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:91;a:4:{s:4:\"name\";s:4:\"Да\";s:3:\"nbr\";s:1:\"3\";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:10;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:\"47\";s:4:\"name\";s:35:\"Фронтальная панель\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:2:{i:340;a:4:{s:4:\"name\";s:19:\"Без панели\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:339;a:4:{s:4:\"name\";s:16:\"C панелью\";s:3:\"nbr\";s:1:\"1\";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:11;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:\"52\";s:4:\"name\";s:27:\"Боковая панель\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:2:{i:409;a:4:{s:4:\"name\";s:19:\"Без панели\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:410;a:4:{s:4:\"name\";s:17:\"С панелью\";s:3:\"nbr\";s:1:\"1\";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:12;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:\"61\";s:4:\"name\";s:37:\"Наличие умывальника\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:3:{i:481;a:4:{s:4:\"name\";s:29:\"Без умывальника\";s:3:\"nbr\";s:2:\"12\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:480;a:4:{s:4:\"name\";s:27:\"С умывальником\";s:3:\"nbr\";s:2:\"12\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:488;a:4:{s:4:\"name\";s:27:\"Со столешницей\";s:3:\"nbr\";s:2:\"12\";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:13;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:4:{i:6;a:5:{s:3:\"nbr\";s:1:\"7\";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:\"4\";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:2:\"11\";s:4:\"name\";s:3:\"170\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:55;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"180\";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:14;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:17:{i:213;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:2:\"30\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42336;a:5:{s:3:\"nbr\";s:2:\"21\";s:4:\"name\";s:2:\"33\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:214;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"35\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:210;a:5:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:2:\"40\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:377;a:5:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:3:\"45 \";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:10;a:5:{s:3:\"nbr\";s:2:\"28\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:11;a:5:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:2:\"55\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12;a:5:{s:3:\"nbr\";s:2:\"32\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:13;a:5:{s:3:\"nbr\";s:2:\"21\";s:4:\"name\";s:2:\"65\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:14;a:5:{s:3:\"nbr\";s:2:\"38\";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:2:\"14\";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:\"36\";s:4:\"name\";s:2:\"80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3298;a:5:{s:3:\"nbr\";s:2:\"13\";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:1:\"5\";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:\"9\";s:4:\"name\";s:3:\"100\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:22;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"105\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:23;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"110\";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:15;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:31:{i:42449;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:74179;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:2:\"11\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38390;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:4:\"11,7\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:74407;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:2:\"13\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:41996;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:2:\"15\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37577;a:5:{s:3:\"nbr\";s:2:\"19\";s:4:\"name\";s:2:\"16\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:374;a:5:{s:3:\"nbr\";s:2:\"20\";s:4:\"name\";s:2:\"25\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3455;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:2:\"30\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38429;a:5:{s:3:\"nbr\";s:2:\"13\";s:4:\"name\";s:2:\"32\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42372;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:2:\"33\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3453;a:5:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:2:\"35\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:75042;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:2:\"37\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:73747;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:2:\"38\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:211;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:60946;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"40\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3452;a:5:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:2:\"42\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3459;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:2:\"43\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:76960;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"43\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77003;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"43\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77014;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"43\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:319;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"44\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:332;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"44,5\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3456;a:5:{s:3:\"nbr\";s:2:\"73\";s:4:\"name\";s:2:\"45\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60957;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:77057;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:77065;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:77069;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:337;a:5:{s:3:\"nbr\";s:2:\"15\";s:4:\"name\";s:2:\"46\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:356;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:2:\"49\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:360;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60962;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: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:16;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:18:{i:77004;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"165\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:66738;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"170\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:349;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"180\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:28347;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"185\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:51536;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"185\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:29027;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"195\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:76961;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"195\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60948;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"200\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77017;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"200\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77059;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"200\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:50958;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"215\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60959;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"215\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77067;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"215\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60964;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;}i:77023;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;}i:20817;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"225\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:343;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"230\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77071;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"240\";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:17;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:38:{i:60947;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"44\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60958;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:60963;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"46\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:2636;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:38428;a:5:{s:3:\"nbr\";s:2:\"14\";s:4:\"name\";s:2:\"50\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3476;a:5:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:2:\"55\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:38387;a:5:{s:3:\"nbr\";s:2:\"20\";s:4:\"name\";s:2:\"57\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:336;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"58\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:51385;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"58\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:59664;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"58\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:68358;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"58\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:76830;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"58\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:18115;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"59\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:331;a:5:{s:3:\"nbr\";s:2:\"33\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77016;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77022;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77058;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77066;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77070;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"60\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:361;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"64 \";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:318;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:2:\"65\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:205;a:5:{s:3:\"nbr\";s:2:\"30\";s:4:\"name\";s:2:\"70\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:315;a:5:{s:3:\"nbr\";s:2:\"13\";s:4:\"name\";s:2:\"75\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42188;a:5:{s:3:\"nbr\";s:1:\"8\";s:4:\"name\";s:2:\"80\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42373;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"81\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:33408;a:5:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:2:\"82\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37574;a:5:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:2:\"83\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37603;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"84.5\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3299;a:5:{s:3:\"nbr\";s:2:\"30\";s:4:\"name\";s:2:\"85\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3473;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:3:\"100\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:75039;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"114\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37568;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:3:\"120\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:75038;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"135\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:54140;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:37429;a:5:{s:3:\"nbr\";s:2:\"19\";s:4:\"name\";s:3:\"170\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3216;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"180\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3217;a:5:{s:3:\"nbr\";s:1:\"3\";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:\"2\";s:4:\"name\";s:3:\"190\";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:18;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:7:{i:3671;a:5:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:29:\"Без умывальника\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:8985;a:5:{s:3:\"nbr\";s:3:\"230\";s:4:\"name\";s:17:\"Для ванны\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:12240;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;}i:41705;a:5:{s:3:\"nbr\";s:2:\"18\";s:4:\"name\";s:14:\"Зеркало\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42269;a:5:{s:3:\"nbr\";s:2:\"36\";s:4:\"name\";s:55:\"Зеркальный шкаф (шкаф-зеркало)\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3670;a:5:{s:3:\"nbr\";s:3:\"130\";s:4:\"name\";s:27:\"С умывальником\";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:19;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"7\";s:6:\"values\";a:2:{i:1332;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:19:\"Для ванной\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:1333;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:29:\"Душевая колонна\";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:20;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:2:{i:25966;a:5:{s:3:\"nbr\";s:1:\"4\";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:1:\"2\";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:21;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"10\";s:6:\"values\";a:13:{i:73087;a:5:{s:3:\"nbr\";s:2:\"16\";s:4:\"name\";s:16:\"Антрацит\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:24311;a:5:{s:3:\"nbr\";s:2:\"94\";s:4:\"name\";s:10:\"Белый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:32204;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:16:\"Бордовый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:32182;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:6:\"Дуб\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:73088;a:5:{s:3:\"nbr\";s:2:\"36\";s:4:\"name\";s:17:\"Дуб вотан\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:24349;a:5:{s:3:\"nbr\";s:2:\"44\";s:4:\"name\";s:20:\"Зеркальный\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:61115;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"Изумруд\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:39976;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:61143;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:12:\"Оливка\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:24312;a:5:{s:3:\"nbr\";s:2:\"23\";s:4:\"name\";s:10:\"Серый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:32199;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:10:\"Синий\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42453;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:14:\"Трюфель\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:32189;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: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:22;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"11\";s:6:\"values\";a:3:{i:3284;a:5:{s:3:\"nbr\";s:2:\"30\";s:4:\"name\";s:18:\"Напольный\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3285;a:5:{s:3:\"nbr\";s:3:\"157\";s:4:\"name\";s:18:\"Подвесной\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:73062;a:5:{s:3:\"nbr\";s:2:\"44\";s:4:\"name\";s:26:\"Универсальный\";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:23;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:9836;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:16:\"Германия\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3403;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:14:\"Испания\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:14943;a:5:{s:3:\"nbr\";s:3:\"225\";s:4:\"name\";s:14:\"Украина\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:9798;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:10:\"Чехия\";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:24;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"15\";s:6:\"values\";a:3:{i:23147;a:5:{s:3:\"nbr\";s:2:\"52\";s:4:\"name\";s:14:\"Зеркало\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:23148;a:5:{s:3:\"nbr\";s:2:\"48\";s:4:\"name\";s:10:\"Пенал\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3681;a:5:{s:3:\"nbr\";s:3:\"131\";s:4:\"name\";s:10:\"Тумба\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:19:\"Вид мебели\";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:\"17\";s:6:\"values\";a:1:{i:3696;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:29:\"Зеркальный шкаф\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:22:\"Конструкция\";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:\"18\";s:6:\"values\";a:2:{i:3961;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:26:\"Асимметричная\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:3700;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: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:27;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:12:{i:60966;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"1507050 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77005;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"150х70х43 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77060;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"150х100х45см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77015;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:17:\"160х70х43 см.\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77068;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:17:\"160х100х45 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60961;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"1707045 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:50960;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"1707046 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:76962;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"170х70х43\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77018;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"170х75х43 см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77072;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"170х110х45см\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:77024;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"180х80х43\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60950;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"1500700400мм\";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:28;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"21\";s:6:\"values\";a:1:{i:3960;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:10:\"Белый\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}}s:4:\"name\";s:8:\"Цвет\";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:\"24\";s:6:\"values\";a:1:{i:3955;a:5:{s:3:\"nbr\";s:2:\"19\";s:4:\"name\";s:10:\"Акрил\";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:30;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:2:\"20\";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:31;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:2:\"20\";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:32;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:7:{i:9799;a:5:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:8:\"5 лет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:50959;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"7 лет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60949;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"7 лет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60960;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"7 лет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:60965;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:9:\"7 лет\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:7339;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:81:\"10 лет официальной гарантии от производителя\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:42950;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:15:\"24 месяца\";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:33;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:\"4\";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:34;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:5:{i:37566;a:5:{s:3:\"nbr\";s:3:\"230\";s:4:\"name\";s:7:\"JUVENTA\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:37567;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:9:\"JUVENTA 1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:27991;a:5:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:5:\"Ravak\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:36557;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:5:\"VOLLE\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:27978;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:6:\"VOLLE \";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:35;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"98\";s:6:\"values\";a:2:{i:48908;a:5:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:39:\"Искусственный камень\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:0;}i:41646;a:5:{s:3:\"nbr\";s:3:\"114\";s:4:\"name\";s:16:\"Керамика\";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\";}}}")	19.926 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)
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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=62)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	18.811 ms	22077120	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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<625 GROUP BY cp.id_category	13.258 ms	1008	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:994 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND 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 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) GROUP BY p.id_manufacturer	13.169 ms	1932	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)
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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=64)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	12.570 ms	384	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp_1.to) ) WHERE ((a.id_attribute_group=2)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	11.890 ms	33496320	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)
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	11.063 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)
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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp_1.to) ) WHERE ((a.id_attribute_group=35)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	8.963 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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=58)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	8.939 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
208	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=59)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	8.904 ms	384	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
738	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	7.728 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)
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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=48)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	7.017 ms	960	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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	6.981 ms	628849	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)
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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=53)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	6.934 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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=54)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	6.901 ms	384	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
291	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=54)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	6.875 ms	628849	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)
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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=55)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	6.527 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)
87	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.condition FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) GROUP BY p.condition	6.128 ms	1932	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:390 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:133 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.date_add 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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND p.date_add>'2026-09-20 00:00:00'	5.632 ms	1932			/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:583 (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)
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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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 ) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp_1.to) ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((sp_1.reduction>0))	5.510 ms	10690433			/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)
92	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.on_sale FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) AND c.nleft>=2 AND c.nright<=625 GROUP BY p.id_product) p WHERE ((p.on_sale=1))	4.624 ms	628849			/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:561 (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)
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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp_1.to) ) WHERE ((a.id_attribute_group=3)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	4.345 ms	576	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
216	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((a.id_attribute_group=63)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	4.321 ms	21380866	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)
244	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=11)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.308 ms	628849	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
235	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=6)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.273 ms	628849	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)
227	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=2)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.228 ms	628849	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)
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) 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:14:54' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:54' <= sp_1.to) ) WHERE ((a.id_attribute_group=1)) AND ((sp_1.reduction>0)) GROUP BY pac.id_attribute	4.208 ms	768	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)
242	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=10)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.188 ms	628849	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)
298	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=63)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.188 ms	628849	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
229	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=3)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.184 ms	628849	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)
246	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=12)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.183 ms	628849	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)
249	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=15)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.183 ms	628849	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
233	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=5)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.172 ms	628849	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
225	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=1)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.093 ms	628849	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)
237	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=7)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.093 ms	628849	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)
260	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=24)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.067 ms	628849	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:986 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
239	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=8)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.063 ms	628849	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)
253	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) 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:14:55' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp.to) ) WHERE ((sp.reduction>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (70, 22, 73, 5, 46, 37) 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) LEFT JOIN ps_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 214) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2026-10-09 21:14:55' <= sp_1.to) ) WHERE ((fp.id_feature=18)) AND ((sp_1.reduction>0)) GROUP BY fp.id_feature_value	4.063 ms	628849	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