Le spécialiste des raccords de haute qualité depuis 1965

+33 (0)4 86 30 70 70

Langue :

Robinetterie
Raccords Laiton
Raccords fonte et acier
Raccords plastique
Etanchéité

Clapets
Filtres
Anti bélier
Soupapes de sécurité
Réducteurs de pression
Robinets à flotteur
Vannes à opercule
Robinets à soupape

Clapets

Aucun produit disponible pour le moment

Restez à l'écoute ! D'autres produits seront affichés ici au fur et à mesure qu'ils seront ajoutés.

Load Time	793.369 ms
Querying Time	236 ms
Queries	547
Memory Peak Usage	12.1 Mb
Included Files	985 files - 11.84 Mb
PrestaShop Cache	- Mb
Global vars	0.13 Mb
- global $_MODULES	104k
- global $_SERVER	7k
- global $config	5k
- global $_MODULE	4k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k

PrestaShop Version	8.1.1
PHP Version	8.1.34
MySQL Version	8.0.44-0ubuntu0.24.04.2
Memory Limit	1024M
Max Execution Time	300s
Smarty Cache	disabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	4.109 ms	4.109 ms	2.47 Mb	2.7 Mb
__construct	0.012 ms	4.121 ms	- Mb	2.7 Mb
init	64.580 ms	68.701 ms	2.24 Mb	4.9 Mb
checkAccess	0.002 ms	68.703 ms	- Mb	4.9 Mb
setMedia	1.008 ms	69.711 ms	0.06 Mb	4.9 Mb
postProcess	0.002 ms	69.713 ms	- Mb	4.9 Mb
initHeader	0.000 ms	69.713 ms	- Mb	4.9 Mb
initContent	197.628 ms	267.341 ms	2.43 Mb	9.2 Mb
initFooter	0.002 ms	267.343 ms	- Mb	9.2 Mb
display	526.026 ms	793.369 ms	4.69 Mb	12.1 Mb

Hook	Time	Memory Usage
FilterCategoryContent	11.014 ms	0.30 Mb
=> customfieldgroups	7.666 ms	0.27 Mb
=> customfieldgroups	3.348 ms	0.03 Mb
displayFooter	10.836 ms	0.79 Mb
=> ps_linklist (widget)	9.572 ms	0.76 Mb
=> customhtml (widget)	1.264 ms	0.03 Mb
DisplayHeader	9.686 ms	0.17 Mb
=> ps_shoppingcart	0.092 ms	- Mb
=> ps_searchbar	0.092 ms	- Mb
=> ps_imageslider	0.044 ms	- Mb
=> ps_googleanalytics	7.431 ms	0.12 Mb
=> customfieldgroups	1.387 ms	0.04 Mb
=> ets_cfultimate	0.435 ms	- Mb
=> ets_blog	0.204 ms	0.01 Mb
renderWidget	7.463 ms	0.51 Mb
=> ps_categorytree (widget)	7.463 ms	0.51 Mb
displayNavFullWidth	7.235 ms	0.84 Mb
=> customhtml (widget)	1.273 ms	0.03 Mb
=> ps_mainmenu (widget)	5.962 ms	0.81 Mb
DisplayFooterBefore	5.967 ms	0.29 Mb
=> customfieldgroups	0.472 ms	0.03 Mb
=> tgf_global_reassurance	5.490 ms	0.26 Mb
=> ets_blog	0.005 ms	- Mb
displayNav2	5.694 ms	0.16 Mb
=> ps_contactinfo (widget)	1.439 ms	0.07 Mb
=> ps_languageselector (widget)	2.901 ms	0.06 Mb
=> customhtml (widget)	1.354 ms	0.03 Mb
displaySearch	4.485 ms	0.11 Mb
=> ps_searchbar (widget)	1.169 ms	0.05 Mb
=> customhtml (widget)	1.381 ms	0.03 Mb
=> ps_searchbar (widget)	0.723 ms	0.01 Mb
=> customhtml (widget)	1.212 ms	0.03 Mb
ActionFrontControllerSetVariables	3.721 ms	0.06 Mb
=> customfieldgroups	0.006 ms	- Mb
=> tgf_wishlist	0.020 ms	- Mb
=> tgf_connector	0.002 ms	- Mb
=> tgf_carrier_extender	3.693 ms	0.06 Mb
displayFooterLeft	3.199 ms	0.11 Mb
=> ps_emailsubscription (widget)	1.794 ms	0.06 Mb
=> ps_socialfollow (widget)	1.405 ms	0.05 Mb
ActionPresentCart	2.916 ms	0.17 Mb
=> tgf_customcart	0.031 ms	- Mb
=> tgf_connector	2.885 ms	0.17 Mb
displayNav1	1.900 ms	0.16 Mb
=> customhtml (widget)	1.900 ms	0.16 Mb
DisplayBeforeBodyClosingTag	1.829 ms	0.05 Mb
=> ps_googleanalytics	1.359 ms	0.02 Mb
=> customfieldgroups	0.470 ms	0.02 Mb
displayTop	1.720 ms	0.07 Mb
=> customhtml (widget)	1.302 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.418 ms	0.04 Mb
DisplayTop	1.662 ms	0.06 Mb
=> tgf_fastorder	1.104 ms	0.03 Mb
=> customfieldgroups	0.550 ms	0.03 Mb
=> ets_cfultimate	0.008 ms	- Mb
displayFooterBefore	1.635 ms	0.07 Mb
=> customhtml (widget)	1.250 ms	0.03 Mb
=> productdata (widget)	0.385 ms	0.04 Mb
Header	1.447 ms	0.09 Mb
=> doofinder	1.402 ms	0.09 Mb
=> tgf_devis	0.045 ms	- Mb
DisplayLeftColumn	1.347 ms	0.03 Mb
=> ps_facetedsearch	0.818 ms	0.01 Mb
=> customfieldgroups	0.517 ms	0.02 Mb
=> ets_cfultimate	0.009 ms	- Mb
=> ets_blog	0.003 ms	- Mb
displayWrapperTop	1.263 ms	0.02 Mb
=> customhtml (widget)	1.263 ms	0.02 Mb
displayFooterAfter	1.200 ms	0.03 Mb
=> customhtml (widget)	1.200 ms	0.03 Mb
displayLeftColumn	1.196 ms	0.03 Mb
=> customhtml (widget)	1.196 ms	0.03 Mb
DisplaySearch	1.047 ms	0.05 Mb
=> customfieldgroups	0.559 ms	0.03 Mb
=> customfieldgroups	0.488 ms	0.03 Mb
DisplayFooter	0.895 ms	0.05 Mb
=> customfieldgroups	0.518 ms	0.03 Mb
=> ets_cfultimate	0.377 ms	0.02 Mb
DisplayNavFullWidth	0.593 ms	0.03 Mb
=> customfieldgroups	0.593 ms	0.03 Mb
DisplayNav2	0.592 ms	0.03 Mb
=> customfieldgroups	0.581 ms	0.03 Mb
=> ets_cfultimate	0.011 ms	- Mb
DisplayAfterBodyOpeningTag	0.540 ms	0.02 Mb
=> customfieldgroups	0.540 ms	0.02 Mb
DisplayWrapperTop	0.522 ms	0.02 Mb
=> customfieldgroups	0.522 ms	0.02 Mb
DisplayWrapperBottom	0.509 ms	0.02 Mb
=> tgf_fastorder	0.011 ms	- Mb
=> customfieldgroups	0.496 ms	0.02 Mb
=> tgf_wishlist	0.002 ms	- Mb
DisplayNav1	0.490 ms	0.03 Mb
=> customfieldgroups	0.490 ms	0.03 Mb
DisplayBanner	0.456 ms	0.02 Mb
=> customfieldgroups	0.456 ms	0.02 Mb
DisplayNotFound	0.431 ms	0.03 Mb
=> customfieldgroups	0.431 ms	0.03 Mb
DisplayFooterAfter	0.428 ms	0.03 Mb
=> customfieldgroups	0.428 ms	0.03 Mb
DisplayFooterCategory	0.426 ms	0.02 Mb
=> customfieldgroups	0.426 ms	0.02 Mb
DisplayContentWrapperTop	0.420 ms	0.02 Mb
=> customfieldgroups	0.420 ms	0.02 Mb
DisplayContentWrapperBottom	0.353 ms	0.02 Mb
=> customfieldgroups	0.353 ms	0.02 Mb
DisplayHeaderCategory	0.336 ms	0.02 Mb
=> customfieldgroups	0.336 ms	0.02 Mb
ActionFrontControllerSetMedia	0.240 ms	0.01 Mb
=> ps_emailsubscription	0.100 ms	- Mb
=> ps_socialfollow	0.035 ms	- Mb
=> ps_emailalerts	0.036 ms	- Mb
=> combinationtable	0.018 ms	- Mb
=> productdata	0.002 ms	- Mb
=> customfieldgroups	0.027 ms	- Mb
=> tgf_global_reassurance	0.022 ms	- Mb
FilterProductSearch	0.186 ms	- Mb
=> customfieldgroups	0.186 ms	- Mb
ProductSearchProvider	0.140 ms	- Mb
=> ps_facetedsearch	0.140 ms	- Mb
ModuleRoutes	0.037 ms	0.01 Mb
=> doofinder	0.005 ms	- Mb
=> tgf_wishlist	0.002 ms	- Mb
=> ets_cfultimate	0.017 ms	- Mb
=> ets_blog	0.013 ms	0.01 Mb
ActionOutputHTMLBefore	0.020 ms	- Mb
=> ets_cfultimate	0.020 ms	- Mb
ActionDispatcherBefore	0.003 ms	- Mb
=> etsloginascustomer	0.003 ms	- Mb
ActionDispatcher	0.002 ms	- Mb
=> tgf_redirection	0.002 ms	- Mb
43 hook(s)	96.080 ms	4.54 Mb

Module	Time	Memory Usage
doofinder	2.598 ms	0.08 Mb
__construct	1.185 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookHeader	1.405 ms	0.09 Mb
tgf_wishlist	0.578 ms	0.02 Mb
__construct	0.551 ms	0.01 Mb
hookModuleRoutes	0.004 ms	- Mb
hookActionFrontControllerSetVariables	0.021 ms	- Mb
hookDisplayWrapperBottom	0.002 ms	- Mb
ets_cfultimate	1.518 ms	0.12 Mb
__construct	0.633 ms	0.08 Mb
hookModuleRoutes	0.018 ms	- Mb
hookDisplayHeader	0.437 ms	0.01 Mb
hookDisplayNav2	0.012 ms	- Mb
hookDisplayTop	0.009 ms	- Mb
hookDisplayLeftColumn	0.009 ms	- Mb
hookDisplayFooter	0.379 ms	0.02 Mb
hookActionOutputHTMLBefore	0.021 ms	- Mb
ets_blog	1.078 ms	0.01 Mb
__construct	0.849 ms	- Mb
hookModuleRoutes	0.015 ms	0.01 Mb
hookDisplayHeader	0.205 ms	0.01 Mb
hookDisplayLeftColumn	0.004 ms	- Mb
hookDisplayFooterBefore	0.005 ms	- Mb
etsloginascustomer	0.480 ms	0.02 Mb
__construct	0.476 ms	0.01 Mb
hookActionDispatcherBefore	0.004 ms	- Mb
tgf_redirection	0.544 ms	0.06 Mb
__construct	0.540 ms	0.06 Mb
hookActionDispatcher	0.004 ms	- Mb
customfieldgroups	22.421 ms	0.84 Mb
__construct	0.085 ms	0.01 Mb
hookFilterCategoryContent	7.670 ms	0.27 Mb
hookFilterCategoryContent	3.351 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.028 ms	- Mb
hookActionFrontControllerSetVariables	0.009 ms	- Mb
hookDisplayHeader	1.390 ms	0.04 Mb
hookFilterProductSearch	0.189 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.542 ms	0.02 Mb
hookDisplayBanner	0.459 ms	0.02 Mb
hookDisplayNav1	0.492 ms	0.03 Mb
hookDisplayNav2	0.585 ms	0.03 Mb
hookDisplaySearch	0.562 ms	0.03 Mb
hookDisplayTop	0.553 ms	0.03 Mb
hookDisplayNavFullWidth	0.596 ms	0.03 Mb
hookDisplayWrapperTop	0.524 ms	0.02 Mb
hookDisplayLeftColumn	0.520 ms	0.02 Mb
hookDisplayContentWrapperTop	0.422 ms	0.02 Mb
hookDisplayHeaderCategory	0.338 ms	0.02 Mb
hookDisplaySearch	0.491 ms	0.03 Mb
hookDisplayNotFound	0.434 ms	0.03 Mb
hookDisplayFooterCategory	0.428 ms	0.02 Mb
hookDisplayContentWrapperBottom	0.356 ms	0.02 Mb
hookDisplayWrapperBottom	0.499 ms	0.02 Mb
hookDisplayFooterBefore	0.475 ms	0.03 Mb
hookDisplayFooter	0.520 ms	0.03 Mb
hookDisplayFooterAfter	0.430 ms	0.03 Mb
hookDisplayBeforeBodyClosingTag	0.473 ms	0.02 Mb
ps_emailsubscription	2.002 ms	0.07 Mb
__construct	0.103 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.102 ms	- Mb
displayFooterLeft	1.797 ms	0.06 Mb
ps_socialfollow	1.550 ms	0.06 Mb
__construct	0.106 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.036 ms	- Mb
displayFooterLeft	1.408 ms	0.05 Mb
ps_emailalerts	0.119 ms	0.01 Mb
__construct	0.082 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.037 ms	- Mb
combinationtable	0.092 ms	0.01 Mb
__construct	0.073 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.019 ms	- Mb
productdata	0.436 ms	0.05 Mb
__construct	0.047 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.002 ms	- Mb
displayFooterBefore	0.387 ms	0.04 Mb
tgf_global_reassurance	5.565 ms	0.26 Mb
__construct	0.048 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.023 ms	- Mb
hookDisplayFooterBefore	5.494 ms	0.26 Mb
tgf_customcart	0.108 ms	0.01 Mb
__construct	0.074 ms	0.01 Mb
hookActionPresentCart	0.034 ms	- Mb
tgf_connector	2.946 ms	0.18 Mb
__construct	0.055 ms	0.01 Mb
hookActionPresentCart	2.888 ms	0.17 Mb
hookActionFrontControllerSetVariables	0.003 ms	- Mb
tgf_carrier_extender	3.796 ms	0.06 Mb
__construct	0.099 ms	0.01 Mb
hookActionFrontControllerSetVariables	3.697 ms	0.06 Mb
tgf_technical_information	0.113 ms	0.01 Mb
__construct	0.113 ms	0.01 Mb
ps_shoppingcart	0.569 ms	0.05 Mb
__construct	0.055 ms	0.01 Mb
hookDisplayHeader	0.094 ms	- Mb
displayTop	0.420 ms	0.04 Mb
ps_searchbar	2.035 ms	0.06 Mb
__construct	0.042 ms	0.01 Mb
hookDisplayHeader	0.094 ms	- Mb
displaySearch	1.172 ms	0.05 Mb
displaySearch	0.727 ms	0.01 Mb
ps_imageslider	0.093 ms	0.01 Mb
__construct	0.049 ms	0.01 Mb
hookDisplayHeader	0.044 ms	- Mb
ps_googleanalytics	8.851 ms	0.15 Mb
__construct	0.055 ms	0.01 Mb
hookDisplayHeader	7.434 ms	0.12 Mb
hookDisplayBeforeBodyClosingTag	1.362 ms	0.02 Mb
ps_featuredproducts	0.063 ms	- Mb
__construct	0.063 ms	- Mb
tgf_devis	0.152 ms	0.01 Mb
__construct	0.106 ms	0.01 Mb
hookHeader	0.046 ms	- Mb
ps_facetedsearch	1.177 ms	0.02 Mb
__construct	0.216 ms	0.01 Mb
hookProductSearchProvider	0.141 ms	- Mb
hookDisplayLeftColumn	0.820 ms	0.01 Mb
customhtml	14.809 ms	0.51 Mb
__construct	0.180 ms	0.06 Mb
displayNav1	1.903 ms	0.16 Mb
displayNav2	1.358 ms	0.03 Mb
displaySearch	1.386 ms	0.03 Mb
displayTop	1.305 ms	0.03 Mb
displayNavFullWidth	1.276 ms	0.03 Mb
displayWrapperTop	1.266 ms	0.03 Mb
displayLeftColumn	1.199 ms	0.03 Mb
displaySearch	1.215 ms	0.03 Mb
displayFooterBefore	1.252 ms	0.03 Mb
displayFooter	1.267 ms	0.03 Mb
displayFooterAfter	1.202 ms	0.03 Mb
ps_contactinfo	1.515 ms	0.08 Mb
__construct	0.072 ms	0.01 Mb
displayNav2	1.443 ms	0.07 Mb
ps_languageselector	2.974 ms	0.07 Mb
__construct	0.070 ms	0.01 Mb
displayNav2	2.904 ms	0.07 Mb
tgf_fastorder	1.672 ms	0.09 Mb
__construct	0.553 ms	0.05 Mb
hookDisplayTop	1.107 ms	0.03 Mb
hookDisplayWrapperBottom	0.012 ms	- Mb
ps_mainmenu	6.060 ms	0.82 Mb
__construct	0.095 ms	0.01 Mb
displayNavFullWidth	5.965 ms	0.81 Mb
ps_categorytree	7.553 ms	0.52 Mb
__construct	0.087 ms	0.01 Mb
renderWidget	7.466 ms	0.51 Mb
ps_linklist	9.758 ms	0.77 Mb
__construct	0.184 ms	0.01 Mb
displayFooter	9.574 ms	0.76 Mb
31 module(s)	103.224 ms	5.00 Mb

Clapets

Aucun produit disponible pour le moment

Stopwatch SQL - 547 queries

Doubles

Tables stress

ObjectModel instances

Included Files

198 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
33 queries	SELECT v.value FROM ps_cfg_field_value v WHERE v.id_entity=XX AND v.id_field_group=XX AND v.id_shop=XX LIMIT XX
16 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
13 queries	SELECT state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
11 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
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
6 queries	SELECT COUNT(p.id_product) 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) WHERE p.id_product = XX AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
6 queries	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
6 queries	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT location FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT c.description FROM ps_carrier_extender c WHERE id_carrier = XX AND id_lang = XX AND id_shop = XX LIMIT XX
6 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
5 queries	SELECT * FROM ps_cfg_file f WHERE f.id_file=XX LIMIT XX
5 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
5 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
4 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
4 queries	SELECT g.*, gl.name, f.id_field, f.data, f.type FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON g.id_field_group=s.id_field_group LEFT JOIN ps_cfg_field_group_lang gl ON gl.id_field_group=g.id_field_group AND gl.id_lang=XX LEFT JOIN ps_cfg_field_group_field gf ON g.id_field_group=gf.id_field_group LEFT JOIN ps_cfg_field f ON gf.id_field=f.id_field WHERE gf.id_field_group IN (XX,XX,XX)
4 queries	SELECT product_attribute_shop.id_product_attribute 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 LIMIT XX
4 queries	SELECT product_attribute_shop.id_product_attribute 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 product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
4 queries	SELECT product_attribute_shop.id_product_attribute 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 LIMIT XX
4 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)
4 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
4 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
4 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
4 queries	SELECT * FROM `ps_feature` a LEFT JOIN `ps_feature_lang` `b` ON a.`id_feature` = b.`id_feature` AND b.`id_lang` = XX LEFT JOIN `ps_feature_shop` `c` ON a.`id_feature` = c.`id_feature` AND c.`id_shop` = XX WHERE (a.`id_feature` = XX) LIMIT XX
3 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT g.id_field_group FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group WHERE g.entity="category" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT g.*, gl.name, f.id_field, f.data, f.type FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON g.id_field_group=s.id_field_group LEFT JOIN ps_cfg_field_group_lang gl ON gl.id_field_group=g.id_field_group AND gl.id_lang=XX LEFT JOIN ps_cfg_field_group_field gf ON g.id_field_group=gf.id_field_group LEFT JOIN ps_cfg_field f ON gf.id_field=f.id_field WHERE gf.id_field_group IN (XX,XX,XX,XX) AND s.id_shop=XX
2 queries	SELECT g.*, gl.name, f.id_field, f.data, f.type FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON g.id_field_group=s.id_field_group LEFT JOIN ps_cfg_field_group_lang gl ON gl.id_field_group=g.id_field_group AND gl.id_lang=XX LEFT JOIN ps_cfg_field_group_field gf ON g.id_field_group=gf.id_field_group LEFT JOIN ps_cfg_field f ON gf.id_field=f.id_field WHERE gf.id_field_group IN (XX,XX)
2 queries	SELECT l., f., fgf.position FROM ps_cfg_field f LEFT JOIN ps_cfg_field_lang l ON l.id_field = f.id_field AND l.id_lang=XX LEFT JOIN ps_cfg_field_group_field fgf ON fgf.id_field = f.id_field WHERE f.id_field IN (XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX)
2 queries	SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = XX AND `active` = XX AND cg.`id_group` =XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 queries	SELECT * FROM `ps_category` aXX LEFT JOIN `ps_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='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_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT tmai.tempmini_min, MIN(tempmini_min) as min, MAX(tempmini_max) as max FROM ps_product p INNER JOIN ps_layered_temperature_index tmai ON (tmai.id_product = p.id_product AND tmai.id_shop = XX) 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX
2 queries	SELECT tmai.tempmaxi_min, MIN(tempmaxi_min) as min, MAX(tempmaxi_max) as max FROM ps_product p INNER JOIN ps_layered_temperature_index tmai ON (tmai.id_product = p.id_product AND tmai.id_shop = XX) 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX
2 queries	SELECT * FROM ps_customhtmlblock AS psb LEFT JOIN ps_customhtmlblock_lang AS psl ON psb.id_customhtmlblock = psl.id_customhtmlblock LEFT JOIN ps_customhtmlblock_shop AS pss ON psb.id_customhtmlblock = pss.id_customhtmlblock WHERE id_shop =XX AND id_lang =XX AND `hook_position` = "displayNavXX" AND `showhook` = XX ORDER BY `position` ASC
2 queries	SELECT l., s., g.* FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_position p ON p.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_lang l ON l.id_field_group = g.id_field_group AND l.id_lang=XX WHERE p.position="displayNavXX" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT * FROM ps_customhtmlblock AS psb LEFT JOIN ps_customhtmlblock_lang AS psl ON psb.id_customhtmlblock = psl.id_customhtmlblock LEFT JOIN ps_customhtmlblock_shop AS pss ON psb.id_customhtmlblock = pss.id_customhtmlblock WHERE id_shop =XX AND id_lang =XX AND `hook_position` = "displaySearch" AND `showhook` = XX ORDER BY `position` ASC
2 queries	SELECT l., s., g.* FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_position p ON p.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_lang l ON l.id_field_group = g.id_field_group AND l.id_lang=XX WHERE p.position="displaySearch" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT * FROM `ps_link_block` a LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_link_block_lang` WHERE `id_link_block` = XX

Name	Instances	Source
Category	42	/override/controllers/front/listing/CategoryController.php:45 (__construct) [id: 267] /controllers/front/listing/CategoryController.php:78 (__construct) [id: 267] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 267] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 267] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 1] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 2] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 13] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 2] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 96] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 266] /classes/Meta.php:380 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:379 (__construct) [id: 267] /modules/ps_facetedsearch/src/Filters/Block.php:197 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 267] /override/modules/ps_categorytree/ps_categorytree.php:107 (__construct) [id: 267] /override/modules/ps_categorytree/ps_categorytree.php:113 (__construct) [id: 266] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 267] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 268] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 269] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 270] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 271] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 272] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 273] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 274]
Product	12	/modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19590] /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19591] /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19587] /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19579] /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19591] /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19590] /modules/tgf_carrierfee/src/Manager/FeeProductManager.php:38 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Manager/FeeProductManager.php:38 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Manager/FeeProductManager.php:38 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) [id: 19588]
Address	9	/classes/Product.php:741 (__construct) [id: ] /classes/Product.php:6830 (initialize) [id: ] /classes/Product.php:3794 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/shop/Shop.php:486 (__construct) [id: ]
Feature	8	/modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 35] /modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 36] /modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 43] /modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 44] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 35] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 36] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 43] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 44]
CMS	6	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 12] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 13] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 11] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 9] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 10] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 14]
Country	5	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1722 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:684 (getCurrencyInstance) [id: 1] /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:49 (__construct) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:640 (__construct) [id: 1] /classes/Tools.php:559 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:427 (__construct) [id: ] /classes/controller/FrontController.php:497 (__construct) [id: ]
AddressFormat	2	/classes/controller/FrontController.php:1716 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
State	2	/classes/controller/FrontController.php:1721 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
PrestaShop\Module\LinkList\Model\LinkBlock	2	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 1] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1646 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1649 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
CustomHtmlBlock	1	/modules/customhtml/customhtml.php:26 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
440	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("e7406f39b329d76a19132c4a76a5a7ba", "a:1:{s:7:\"filters\";a:8:{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:11:\"Catégories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:43;s:4:\"name\";s:2:\"Ø\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:32308;a:4:{s:4:\"name\";s:2:\"2\"\";s:3:\"nbr\";i: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\";i:0;}i:2;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:82;s:4:\"name\";s:2:\"DN\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:42101;a:5:{s:4:\"name\";s:2:\"50\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:3;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:93;s:4:\"name\";s:8:\"Longueur\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:42244;a:4:{s:4:\"name\";s:3:\"150\";s:3:\"nbr\";i: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\";i:0;}i:4;a:12:{s:9:\"type_lite\";s:8:\"tempmini\";s:4:\"type\";s:8:\"tempmini\";s:6:\"id_key\";i:35;s:4:\"name\";s:9:\"Temp mini\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##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:0;s:5:\"value\";N;}i:5;a:12:{s:9:\"type_lite\";s:8:\"tempmaxi\";s:4:\"type\";s:8:\"tempmaxi\";s:6:\"id_key\";i:36;s:4:\"name\";s:9:\"Temp maxi\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##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:0;s:5:\"value\";N;}i:6;a:12:{s:9:\"type_lite\";s:8:\"tempmini\";s:4:\"type\";s:8:\"tempmini\";s:6:\"id_key\";i:43;s:4:\"name\";s:8:\"T°C min\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##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:0;s:5:\"value\";N;}i:7;a:12:{s:9:\"type_lite\";s:8:\"tempmaxi\";s:4:\"type\";s:8:\"tempmaxi\";s:6:\"id_key\";i:44;s:4:\"name\";s:8:\"T°C max\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##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:0;s:5:\"value\";N;}}}")	4.269 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:496 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
273	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 43 ORDER BY agl.`name` ASC, a.`position` ASC	3.921 ms	536	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
232	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 82 ORDER BY agl.`name` ASC, a.`position` ASC	3.252 ms	91	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:512 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
431	SELECT SQL_NO_CACHE pac.id_attribute, a.id_attribute_group, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=83)) AND ((pac_1.id_attribute=42101)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=130 AND c.nright<=131 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group IN (1, 3, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 204, 205))) AND ((fp_1.id_feature_value=83)) AND ((pac_2.id_attribute=42101)) GROUP BY pac.id_attribute, a.id_attribute_group	3.043 ms	477792	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Filters/Block.php:395 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
274	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 44 ORDER BY agl.`name` ASC, a.`position` ASC	2.523 ms	314	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
18	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.367 ms	17504	Yes	Yes	/classes/Hook.php:1183 /classes/Hook.php:699 (getAllHookRegistrations) /classes/Hook.php:803 (getHookModuleExecList) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
215	SELECT SQL_NO_CACHE c.description FROM ps_carrier_extender c WHERE id_carrier = 47 AND id_lang = 1 AND id_shop = 1 LIMIT 1	2.167 ms	0			/modules/tgf_carrier_extender/src/Util/CarrierConfiguration.php:39 /modules/tgf_carrier_extender/src/Util/CarrierConfiguration.php:81 (getDescription) /modules/tgf_carrier_extender/tgf_carrier_extender.php:97 (getAllCarrierDescriptions) /classes/Hook.php:993 (hookActionFrontControllerSetVariables) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /classes/controller/FrontController.php:526 (exec) /classes/controller/FrontController.php:569 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
250	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 18 ORDER BY agl.`name` ASC, a.`position` ASC	2.121 ms	0			/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.014 ms	2403			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
355	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 128 ORDER BY agl.`name` ASC, a.`position` ASC	1.853 ms	8	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
230	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag 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 = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	1.612 ms	166	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:498 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
346	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 119 ORDER BY agl.`name` ASC, a.`position` ASC	1.569 ms	208	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
344	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 117 ORDER BY agl.`name` ASC, a.`position` ASC	1.534 ms	192	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
234	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=83)) AND ((pac_1.id_attribute=42152)) AND ((pac_2.id_attribute=42101)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=130 AND c.nright<=131 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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 0) ASC, p.position ASC, p.id_product DESC	1.499 ms	3024	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
277	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 47 ORDER BY agl.`name` ASC, a.`position` ASC	1.482 ms	10	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
305	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 78 ORDER BY agl.`name` ASC, a.`position` ASC	1.476 ms	126	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	1.432 ms	0			/classes/Hook.php:1242 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6833 (getManager) /classes/Product.php:741 (getTaxesRate) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:105 (adaptFieldData) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:153 (adapt) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:105 (adaptFieldData) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:173 (adapt) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:108 (getProperties) /override/controllers/front/listing/CategoryController.php:84 (get) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
405	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 178 ORDER BY agl.`name` ASC, a.`position` ASC	1.379 ms	46	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.372 ms	475			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6833 (getManager) /classes/Product.php:741 (getTaxesRate) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:105 (adaptFieldData) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:153 (adapt) /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:105 (adaptFieldData) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:173 (adapt) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:108 (getProperties) /override/controllers/front/listing/CategoryController.php:84 (get) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
278	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 48 ORDER BY agl.`name` ASC, a.`position` ASC	1.325 ms	94	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
231	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 81 ORDER BY agl.`name` ASC, a.`position` ASC	1.252 ms	40	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:512 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
235	SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="e7406f39b329d76a19132c4a76a5a7ba" LIMIT 1	1.235 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:471 /modules/ps_facetedsearch/src/Product/SearchProvider.php:210 (getFromCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
332	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 105 ORDER BY agl.`name` ASC, a.`position` ASC	1.218 ms	2	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
435	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=83)) AND ((pac_1.id_attribute=42152)) AND ((pac_2.id_attribute=42101)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=130 AND c.nright<=131 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=83)) AND ((pac_1.id_attribute=42152)) AND ((pac_2.id_attribute=42101)) AND cg.id_group='1' AND c.level_depth<=6 AND c.nleft>130 AND c.nright<131 GROUP BY cp.id_category	1.202 ms	1296	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:817 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:1407 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:198 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
432	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=83)) AND ((pac_1.id_attribute=42152)) AND ((pac_2.id_attribute=42101)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=130 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((fp.id_feature IN (28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 41, 42, 45, 46, 47))) AND ((fp_1.id_feature_value=83)) AND ((pac_2.id_attribute=42152)) AND ((pac_3.id_attribute=42101)) GROUP BY fp.id_feature_value	1.190 ms	2592	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:817 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:269 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:157 (getFeaturesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
434	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` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	1.158 ms	585	Yes		/classes/Category.php:721 /modules/ps_facetedsearch/src/Filters/Block.php:1401 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:198 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
333	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 106 ORDER BY agl.`name` ASC, a.`position` ASC	1.126 ms	109	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
433	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_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) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=83)) AND ((pac_1.id_attribute=42152)) AND ((pac_2.id_attribute=42101)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=130 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((fp.id_feature IN (28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 41, 42, 45, 46, 47))) AND ((fp_1.id_feature_value=83)) AND ((pac_2.id_attribute=42152)) AND ((pac_3.id_attribute=42101)) GROUP BY fp.id_feature_value	1.117 ms	2592	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Filters/Block.php:292 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:157 (getFeaturesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
272	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 42 ORDER BY agl.`name` ASC, a.`position` ASC	1.077 ms	0			/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
369	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 142 ORDER BY agl.`name` ASC, a.`position` ASC	1.065 ms	24	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
370	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 143 ORDER BY agl.`name` ASC, a.`position` ASC	1.058 ms	5	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
334	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 107 ORDER BY agl.`name` ASC, a.`position` ASC	1.034 ms	112	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
354	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 127 ORDER BY agl.`name` ASC, a.`position` ASC	1.014 ms	32	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
399	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 172 ORDER BY agl.`name` ASC, a.`position` ASC	1.008 ms	48	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
262	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 32 ORDER BY agl.`name` ASC, a.`position` ASC	0.991 ms	0			/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
394	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 167 ORDER BY agl.`name` ASC, a.`position` ASC	0.991 ms	40	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
280	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 50 ORDER BY agl.`name` ASC, a.`position` ASC	0.988 ms	86	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
397	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 170 ORDER BY agl.`name` ASC, a.`position` ASC	0.982 ms	25	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
353	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 126 ORDER BY agl.`name` ASC, a.`position` ASC	0.975 ms	104	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
396	SELECT SQL_NO_CACHE 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` = 1) 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` = 1) 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 = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 169 ORDER BY agl.`name` ASC, a.`position` ASC	0.971 ms	32	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (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