The spécialist in high-quality fittings since 1965

+33 (0)4 86 30 70 70

Language:

Compression
Multilayer system
Bsp threaded
Socket welding
Copper-brass
Copper fittings
Compressed air and quick couplings
Push-fit
Garden hose

Compressed air and quick couplings

No products available yet

Stay tuned! More products will be shown here as they are added.

Load Time	608.476 ms
Querying Time	491 ms
Queries	520
Memory Peak Usage	11.8 Mb
Included Files	985 files - 11.73 Mb
PrestaShop Cache	- Mb
Global vars	0.04 Mb
- global $_MODULES	15k
- global $_SERVER	7k
- global $config	5k
- 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	15.571 ms	15.571 ms	2.44 Mb	2.7 Mb
__construct	0.015 ms	15.586 ms	- Mb	2.7 Mb
init	152.203 ms	167.789 ms	2.07 Mb	4.7 Mb
checkAccess	0.003 ms	167.792 ms	- Mb	4.7 Mb
setMedia	0.877 ms	168.669 ms	0.06 Mb	4.7 Mb
postProcess	0.002 ms	168.671 ms	- Mb	4.7 Mb
initHeader	0.001 ms	168.672 ms	- Mb	4.7 Mb
initContent	331.901 ms	500.573 ms	2.46 Mb	9.1 Mb
initFooter	0.002 ms	500.575 ms	- Mb	9.1 Mb
display	107.901 ms	608.476 ms	4.62 Mb	11.8 Mb

Hook	Time	Memory Usage
FilterCategoryContent	18.602 ms	0.30 Mb
=> customfieldgroups	14.224 ms	0.27 Mb
=> customfieldgroups	4.378 ms	0.03 Mb
DisplayHeader	15.814 ms	0.17 Mb
=> ps_shoppingcart	0.115 ms	- Mb
=> ps_searchbar	0.087 ms	- Mb
=> ps_imageslider	0.046 ms	- Mb
=> ps_googleanalytics	9.847 ms	0.12 Mb
=> customfieldgroups	4.595 ms	0.04 Mb
=> ets_cfultimate	0.921 ms	- Mb
=> ets_blog	0.203 ms	0.01 Mb
displayFooter	11.226 ms	0.73 Mb
=> ps_linklist (widget)	9.632 ms	0.70 Mb
=> customhtml (widget)	1.594 ms	0.03 Mb
ActionPresentCart	9.328 ms	0.17 Mb
=> tgf_customcart	0.032 ms	- Mb
=> tgf_connector	9.296 ms	0.17 Mb
displayNavFullWidth	7.365 ms	0.83 Mb
=> customhtml (widget)	1.210 ms	0.03 Mb
=> ps_mainmenu (widget)	6.155 ms	0.80 Mb
renderWidget	7.086 ms	0.48 Mb
=> ps_categorytree (widget)	7.086 ms	0.48 Mb
DisplayFooterBefore	6.119 ms	0.28 Mb
=> customfieldgroups	0.492 ms	0.03 Mb
=> tgf_global_reassurance	5.621 ms	0.25 Mb
=> ets_blog	0.006 ms	- Mb
ActionFrontControllerSetVariables	5.399 ms	0.06 Mb
=> customfieldgroups	0.005 ms	- Mb
=> tgf_wishlist	0.022 ms	- Mb
=> tgf_connector	0.002 ms	- Mb
=> tgf_carrier_extender	5.370 ms	0.06 Mb
displayNav2	5.109 ms	0.16 Mb
=> ps_contactinfo (widget)	1.488 ms	0.07 Mb
=> ps_languageselector (widget)	2.402 ms	0.06 Mb
=> customhtml (widget)	1.219 ms	0.03 Mb
displaySearch	4.624 ms	0.11 Mb
=> ps_searchbar (widget)	1.095 ms	0.05 Mb
=> customhtml (widget)	1.372 ms	0.03 Mb
=> ps_searchbar (widget)	0.816 ms	0.01 Mb
=> customhtml (widget)	1.342 ms	0.03 Mb
displayFooterLeft	4.262 ms	0.11 Mb
=> ps_emailsubscription (widget)	2.510 ms	0.06 Mb
=> ps_socialfollow (widget)	1.752 ms	0.05 Mb
displayNav1	2.016 ms	0.10 Mb
=> customhtml (widget)	2.016 ms	0.10 Mb
DisplayBeforeBodyClosingTag	1.966 ms	0.05 Mb
=> ps_googleanalytics	1.423 ms	0.02 Mb
=> customfieldgroups	0.543 ms	0.02 Mb
displayFooterAfter	1.811 ms	0.03 Mb
=> customhtml (widget)	1.811 ms	0.03 Mb
displayFooterBefore	1.755 ms	0.07 Mb
=> customhtml (widget)	1.379 ms	0.03 Mb
=> productdata (widget)	0.376 ms	0.04 Mb
displayTop	1.605 ms	0.07 Mb
=> customhtml (widget)	1.249 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.356 ms	0.04 Mb
DisplayTop	1.513 ms	0.06 Mb
=> tgf_fastorder	1.012 ms	0.03 Mb
=> customfieldgroups	0.494 ms	0.03 Mb
=> ets_cfultimate	0.007 ms	- Mb
Header	1.494 ms	0.09 Mb
=> doofinder	1.456 ms	0.09 Mb
=> tgf_devis	0.038 ms	- Mb
DisplayLeftColumn	1.432 ms	0.04 Mb
=> ps_facetedsearch	0.918 ms	0.01 Mb
=> customfieldgroups	0.502 ms	0.02 Mb
=> ets_cfultimate	0.009 ms	- Mb
=> ets_blog	0.003 ms	- Mb
displayLeftColumn	1.328 ms	0.03 Mb
=> customhtml (widget)	1.328 ms	0.03 Mb
displayWrapperTop	1.273 ms	0.02 Mb
=> customhtml (widget)	1.273 ms	0.02 Mb
DisplaySearch	1.020 ms	0.05 Mb
=> customfieldgroups	0.512 ms	0.03 Mb
=> customfieldgroups	0.508 ms	0.03 Mb
DisplayFooter	0.893 ms	0.05 Mb
=> customfieldgroups	0.485 ms	0.03 Mb
=> ets_cfultimate	0.408 ms	0.02 Mb
DisplayFooterAfter	0.636 ms	0.03 Mb
=> customfieldgroups	0.636 ms	0.03 Mb
DisplayNavFullWidth	0.573 ms	0.03 Mb
=> customfieldgroups	0.573 ms	0.03 Mb
DisplayWrapperTop	0.571 ms	0.02 Mb
=> customfieldgroups	0.571 ms	0.02 Mb
DisplayAfterBodyOpeningTag	0.569 ms	0.02 Mb
=> customfieldgroups	0.569 ms	0.02 Mb
DisplayNav1	0.568 ms	0.03 Mb
=> customfieldgroups	0.568 ms	0.03 Mb
DisplayNav2	0.560 ms	0.03 Mb
=> customfieldgroups	0.550 ms	0.03 Mb
=> ets_cfultimate	0.010 ms	- Mb
DisplayBanner	0.493 ms	0.02 Mb
=> customfieldgroups	0.493 ms	0.02 Mb
DisplayContentWrapperTop	0.418 ms	0.02 Mb
=> customfieldgroups	0.418 ms	0.02 Mb
DisplayFooterCategory	0.414 ms	0.02 Mb
=> customfieldgroups	0.414 ms	0.02 Mb
DisplayNotFound	0.408 ms	0.03 Mb
=> customfieldgroups	0.408 ms	0.03 Mb
DisplayContentWrapperBottom	0.389 ms	0.02 Mb
=> customfieldgroups	0.389 ms	0.02 Mb
DisplayWrapperBottom	0.369 ms	0.02 Mb
=> tgf_fastorder	0.012 ms	- Mb
=> customfieldgroups	0.356 ms	0.02 Mb
=> tgf_wishlist	0.001 ms	- Mb
DisplayHeaderCategory	0.327 ms	0.02 Mb
=> customfieldgroups	0.327 ms	0.02 Mb
ActionFrontControllerSetMedia	0.217 ms	0.01 Mb
=> ps_emailsubscription	0.097 ms	- Mb
=> ps_socialfollow	0.025 ms	- Mb
=> ps_emailalerts	0.032 ms	- Mb
=> combinationtable	0.016 ms	- Mb
=> productdata	0.001 ms	- Mb
=> customfieldgroups	0.024 ms	- Mb
=> tgf_global_reassurance	0.022 ms	- Mb
FilterProductSearch	0.191 ms	- Mb
=> customfieldgroups	0.191 ms	- Mb
ProductSearchProvider	0.143 ms	- Mb
=> ps_facetedsearch	0.143 ms	- Mb
ModuleRoutes	0.037 ms	0.01 Mb
=> doofinder	0.005 ms	- Mb
=> tgf_wishlist	0.002 ms	- Mb
=> ets_cfultimate	0.020 ms	- Mb
=> ets_blog	0.010 ms	0.01 Mb
ActionOutputHTMLBefore	0.020 ms	- Mb
=> ets_cfultimate	0.020 ms	- Mb
ActionDispatcherBefore	0.004 ms	- Mb
=> etsloginascustomer	0.004 ms	- Mb
ActionDispatcher	0.004 ms	- Mb
=> tgf_redirection	0.004 ms	- Mb
43 hook(s)	119.952 ms	4.38 Mb

Module	Time	Memory Usage
doofinder	4.548 ms	0.08 Mb
__construct	3.081 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookHeader	1.459 ms	0.09 Mb
tgf_wishlist	0.706 ms	0.02 Mb
__construct	0.678 ms	0.01 Mb
hookModuleRoutes	0.003 ms	- Mb
hookActionFrontControllerSetVariables	0.023 ms	- Mb
hookDisplayWrapperBottom	0.002 ms	- Mb
ets_cfultimate	3.076 ms	0.05 Mb
__construct	1.653 ms	0.01 Mb
hookModuleRoutes	0.022 ms	- Mb
hookDisplayHeader	0.925 ms	0.01 Mb
hookDisplayNav2	0.011 ms	- Mb
hookDisplayTop	0.008 ms	- Mb
hookDisplayLeftColumn	0.010 ms	- Mb
hookDisplayFooter	0.411 ms	0.02 Mb
hookActionOutputHTMLBefore	0.036 ms	- Mb
ets_blog	2.949 ms	0.04 Mb
__construct	2.724 ms	0.03 Mb
hookModuleRoutes	0.011 ms	0.01 Mb
hookDisplayHeader	0.204 ms	0.01 Mb
hookDisplayLeftColumn	0.004 ms	- Mb
hookDisplayFooterBefore	0.006 ms	- Mb
etsloginascustomer	0.904 ms	0.02 Mb
__construct	0.898 ms	0.01 Mb
hookActionDispatcherBefore	0.006 ms	- Mb
tgf_redirection	1.602 ms	0.06 Mb
__construct	1.595 ms	0.06 Mb
hookActionDispatcher	0.007 ms	- Mb
customfieldgroups	33.387 ms	0.84 Mb
__construct	0.092 ms	0.01 Mb
hookFilterCategoryContent	14.228 ms	0.27 Mb
hookFilterCategoryContent	4.381 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.025 ms	- Mb
hookActionFrontControllerSetVariables	0.007 ms	- Mb
hookDisplayHeader	4.599 ms	0.04 Mb
hookFilterProductSearch	0.194 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.573 ms	0.02 Mb
hookDisplayBanner	0.496 ms	0.02 Mb
hookDisplayNav1	0.571 ms	0.03 Mb
hookDisplayNav2	0.553 ms	0.03 Mb
hookDisplaySearch	0.515 ms	0.03 Mb
hookDisplayTop	0.496 ms	0.03 Mb
hookDisplayNavFullWidth	0.577 ms	0.03 Mb
hookDisplayWrapperTop	0.574 ms	0.02 Mb
hookDisplayLeftColumn	0.505 ms	0.02 Mb
hookDisplayContentWrapperTop	0.420 ms	0.02 Mb
hookDisplayHeaderCategory	0.329 ms	0.02 Mb
hookDisplaySearch	0.511 ms	0.03 Mb
hookDisplayNotFound	0.410 ms	0.03 Mb
hookDisplayFooterCategory	0.416 ms	0.02 Mb
hookDisplayContentWrapperBottom	0.391 ms	0.02 Mb
hookDisplayWrapperBottom	0.358 ms	0.02 Mb
hookDisplayFooterBefore	0.494 ms	0.03 Mb
hookDisplayFooter	0.487 ms	0.03 Mb
hookDisplayFooterAfter	0.640 ms	0.03 Mb
hookDisplayBeforeBodyClosingTag	0.546 ms	0.02 Mb
ps_emailsubscription	2.709 ms	0.07 Mb
__construct	0.095 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.099 ms	- Mb
displayFooterLeft	2.515 ms	0.06 Mb
ps_socialfollow	1.823 ms	0.06 Mb
__construct	0.042 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.026 ms	- Mb
displayFooterLeft	1.755 ms	0.05 Mb
ps_emailalerts	0.094 ms	0.01 Mb
__construct	0.061 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.033 ms	- Mb
combinationtable	0.074 ms	0.01 Mb
__construct	0.057 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.017 ms	- Mb
productdata	0.425 ms	0.05 Mb
__construct	0.045 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.002 ms	- Mb
displayFooterBefore	0.378 ms	0.04 Mb
tgf_global_reassurance	5.692 ms	0.25 Mb
__construct	0.045 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.023 ms	- Mb
hookDisplayFooterBefore	5.624 ms	0.25 Mb
tgf_customcart	0.125 ms	0.01 Mb
__construct	0.091 ms	0.01 Mb
hookActionPresentCart	0.034 ms	- Mb
tgf_connector	9.368 ms	0.18 Mb
__construct	0.066 ms	0.01 Mb
hookActionPresentCart	9.299 ms	0.17 Mb
hookActionFrontControllerSetVariables	0.003 ms	- Mb
tgf_carrier_extender	5.475 ms	0.06 Mb
__construct	0.101 ms	0.01 Mb
hookActionFrontControllerSetVariables	5.374 ms	0.06 Mb
tgf_technical_information	0.107 ms	0.01 Mb
__construct	0.107 ms	0.01 Mb
ps_shoppingcart	0.532 ms	0.05 Mb
__construct	0.056 ms	0.01 Mb
hookDisplayHeader	0.118 ms	- Mb
displayTop	0.358 ms	0.04 Mb
ps_searchbar	2.052 ms	0.06 Mb
__construct	0.047 ms	0.01 Mb
hookDisplayHeader	0.089 ms	- Mb
displaySearch	1.097 ms	0.05 Mb
displaySearch	0.819 ms	0.01 Mb
ps_imageslider	0.093 ms	0.01 Mb
__construct	0.047 ms	0.01 Mb
hookDisplayHeader	0.046 ms	- Mb
ps_googleanalytics	11.321 ms	0.15 Mb
__construct	0.045 ms	0.01 Mb
hookDisplayHeader	9.851 ms	0.12 Mb
hookDisplayBeforeBodyClosingTag	1.425 ms	0.02 Mb
ps_featuredproducts	0.063 ms	- Mb
__construct	0.063 ms	- Mb
tgf_devis	0.157 ms	0.01 Mb
__construct	0.117 ms	0.01 Mb
hookHeader	0.040 ms	- Mb
ps_facetedsearch	1.260 ms	0.03 Mb
__construct	0.195 ms	0.01 Mb
hookProductSearchProvider	0.145 ms	- Mb
hookDisplayLeftColumn	0.920 ms	0.02 Mb
customhtml	15.953 ms	0.41 Mb
__construct	0.132 ms	0.02 Mb
displayNav1	2.018 ms	0.10 Mb
displayNav2	1.221 ms	0.03 Mb
displaySearch	1.374 ms	0.03 Mb
displayTop	1.251 ms	0.03 Mb
displayNavFullWidth	1.212 ms	0.03 Mb
displayWrapperTop	1.276 ms	0.03 Mb
displayLeftColumn	1.331 ms	0.03 Mb
displaySearch	1.346 ms	0.03 Mb
displayFooterBefore	1.382 ms	0.03 Mb
displayFooter	1.597 ms	0.03 Mb
displayFooterAfter	1.813 ms	0.03 Mb
ps_contactinfo	1.573 ms	0.08 Mb
__construct	0.082 ms	0.01 Mb
displayNav2	1.491 ms	0.07 Mb
ps_languageselector	2.474 ms	0.07 Mb
__construct	0.070 ms	0.01 Mb
displayNav2	2.404 ms	0.06 Mb
tgf_fastorder	1.550 ms	0.08 Mb
__construct	0.523 ms	0.05 Mb
hookDisplayTop	1.014 ms	0.03 Mb
hookDisplayWrapperBottom	0.013 ms	- Mb
ps_mainmenu	6.235 ms	0.81 Mb
__construct	0.077 ms	0.01 Mb
displayNavFullWidth	6.158 ms	0.80 Mb
ps_categorytree	7.178 ms	0.48 Mb
__construct	0.089 ms	0.01 Mb
renderWidget	7.089 ms	0.48 Mb
ps_linklist	9.826 ms	0.78 Mb
__construct	0.191 ms	0.07 Mb
displayFooter	9.635 ms	0.70 Mb
31 module(s)	133.331 ms	4.83 Mb

Compressed air and quick couplings

No products available yet

Stopwatch SQL - 520 queries

Doubles

Tables stress

ObjectModel instances

Included Files

197 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
29 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
26 queries	SELECT state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
18 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
16 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `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 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_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
5 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5 queries	SELECT * FROM ps_cfg_file f WHERE f.id_file=XX LIMIT XX
4 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' 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 * 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 * 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
3 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = 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 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
2 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
2 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
2 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
2 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)
2 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
2 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
2 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
2 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
2 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
2 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
2 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
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_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((pac.id_attribute=XX)) AND ((pac_XX.id_attribute IN (XX, XX, 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_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 ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute IN (XX, XX, 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_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_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((pac.id_attribute=XX)) AND ((pac_XX.id_attribute IN (XX, XX, 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_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_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((pac.id_attribute=XX)) AND ((pac_XX.id_attribute IN (XX, XX, 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	52	/override/controllers/front/listing/CategoryController.php:45 (__construct) [id: 157] /controllers/front/listing/CategoryController.php:78 (__construct) [id: 157] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 157] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 158] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 183] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 185] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 187] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 186] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 182] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 157] /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: 94] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 158] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 183] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 185] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 187] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 186] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 182] /classes/Meta.php:380 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /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: 157] /modules/ps_facetedsearch/src/Filters/Block.php:197 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:107 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:113 (__construct) [id: 94] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 220] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 181] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 95] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 137] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 140] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 219] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 225] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 156]
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]
Product	8	/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]
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]
Address	5	/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/shop/Shop.php:486 (__construct) [id: ]
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: 1] /classes/Tools.php:640 (__construct) [id: 2] /classes/Tools.php:559 (__construct) [id: 2]
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]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
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
246	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 43 ORDER BY agl.`name` ASC, a.`position` ASC	8.583 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)
207	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_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute=42147)) AND ((pac_1.id_attribute IN (42986, 43234, 43375))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=249 AND c.nright<=276 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	6.938 ms	1512	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)
294	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 94 ORDER BY agl.`name` ASC, a.`position` ASC	6.425 ms	1	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)
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`)	6.321 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)
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`	6.039 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)
205	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 82 ORDER BY agl.`name` ASC, a.`position` ASC	5.283 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)
204	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` = 2) 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` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	4.800 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)
288	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 88 ORDER BY agl.`name` ASC, a.`position` ASC	4.518 ms	7	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)
34	SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC	4.225 ms	2	Yes		/classes/Currency.php:711 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:282 (init) /controllers/front/listing/CategoryController.php:81 (init) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
22	SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`	4.182 ms	88			/classes/Hook.php:339 /classes/Hook.php:154 (getCanonicalHookNames) /classes/Hook.php:363 (normalizeHookName) /classes/Hook.php:386 (getAllKnownNames) /classes/Hook.php:921 (isHookCallableOn) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
313	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 113 ORDER BY agl.`name` ASC, a.`position` ASC	3.909 ms	7	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)
319	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 119 ORDER BY agl.`name` ASC, a.`position` ASC	3.895 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)
317	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 117 ORDER BY agl.`name` ASC, a.`position` ASC	3.870 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)
241	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 38 ORDER BY agl.`name` ASC, a.`position` ASC	3.858 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)
281	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 81 ORDER BY agl.`name` ASC, a.`position` ASC	3.809 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)
413	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("2234ad4c09f4596f3a0919f91ee92b34", "a:1:{s:7:\"filters\";a:13:{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:10:\"Categories\";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:42202;a:4:{s:4:\"name\";s:2:\"42\";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:119;s:4:\"name\";s:4:\"Type\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:3:{i:42986;a:5:{s:4:\"name\";s:8:\"ESA 12 I\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:43234;a:5:{s:4:\"name\";s:4:\"V32N\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:43375;a:5:{s:4:\"name\";s:5:\"VST42\";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:145;s:4:\"name\";s:7:\"Ø base\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:42965;a:4:{s:4:\"name\";s:2:\"53\";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:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:146;s:4:\"name\";s:11:\"Male thread\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:58159;a:4:{s:4:\"name\";s:11:\"Rd32 x 1/8\"\";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:5;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:147;s:4:\"name\";s:13:\"Female thread\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:58145;a:4:{s:4:\"name\";s:5:\"G1/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:6;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:150;s:4:\"name\";s:7:\"Ø in. \";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43091;a:4:{s:4:\"name\";s:2:\"42\";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:7;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:154;s:4:\"name\";s:7:\"Hexagon\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43198;a:4:{s:4:\"name\";s:2:\"32\";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:8;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:156;s:4:\"name\";s:4:\"Cone\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43236;a:4:{s:4:\"name\";s:3:\"1:3\";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:9;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:10;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:11;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:12;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;}}}")	3.763 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)
307	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 107 ORDER BY agl.`name` ASC, a.`position` ASC	3.623 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)
88	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=1 AND v.id_field_group=26 AND v.id_shop=1 LIMIT 1	3.513 ms	1048			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:1120 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:165 (getFieldGroupValues) /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)
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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 28 ORDER BY agl.`name` ASC, a.`position` ASC	3.401 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)
320	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 120 ORDER BY agl.`name` ASC, a.`position` ASC	3.395 ms	6	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)
310	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 110 ORDER BY agl.`name` ASC, a.`position` ASC	3.393 ms	20	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)
109	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=2 AND v.id_field_group=290 AND v.id_shop=1 LIMIT 1	3.238 ms	1048			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:1120 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:165 (getFieldGroupValues) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:108 (getProperties) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:184 (get) /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)
14	SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1	3.208 ms	3			/classes/Language.php:823 /classes/Tools.php:626 (getIdByIso) /classes/Dispatcher.php:236 (switchLanguage) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
213	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 8 ORDER BY agl.`name` ASC, a.`position` ASC	3.205 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)
119	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	3.182 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)
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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 72 ORDER BY agl.`name` ASC, a.`position` ASC	3.156 ms	12	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)
222	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 17 ORDER BY agl.`name` ASC, a.`position` ASC	3.088 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)
325	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 125 ORDER BY agl.`name` ASC, a.`position` ASC	3.043 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)
314	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 114 ORDER BY agl.`name` ASC, a.`position` ASC	2.976 ms	43	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)
33	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 157) AND (b.`id_shop` = 1) LIMIT 1	2.874 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /override/controllers/front/listing/CategoryController.php:45 (__construct) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
37	SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2 LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1	2.813 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Currency.php:246 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:282 (init) /controllers/front/listing/CategoryController.php:81 (init) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
58	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=157 AND v.id_field_group=32 AND v.id_shop=1 LIMIT 1	2.791 ms	1048			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:1120 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:165 (getFieldGroupValues) /modules/customfieldgroups/customfieldgroups.php:296 (getProperties) /classes/Hook.php:993 (__call) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /controllers/front/listing/CategoryController.php:109 (exec) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
316	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 116 ORDER BY agl.`name` ASC, a.`position` ASC	2.753 ms	47	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)
300	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 100 ORDER BY agl.`name` ASC, a.`position` ASC	2.703 ms	3	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)
108	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=2 AND v.id_field_group=78 AND v.id_shop=1 LIMIT 1	2.660 ms	1048			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:1120 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:165 (getFieldGroupValues) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:108 (getProperties) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:184 (get) /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)
9	SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1	2.600 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:561 (__construct) /config/config.inc.php:171 (getGroup) /index.php:27 (require)
247	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 44 ORDER BY agl.`name` ASC, a.`position` ASC	2.572 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)
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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 62 ORDER BY agl.`name` ASC, a.`position` ASC	2.514 ms	14	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)
186	SELECT SQL_NO_CACHE c.*, cl.delay FROM `ps_carrier` c LEFT JOIN `ps_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `ps_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`) INNER JOIN ps_carrier_shop carrier_shop ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 AND c.is_module = 0 GROUP BY c.`id_carrier` ORDER BY c.`position` ASC	2.507 ms	24	Yes	Yes	/classes/Carrier.php:573 /modules/tgf_carrier_extender/src/Util/CarrierConfiguration.php:80 (getCarriers) /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)
318	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 118 ORDER BY agl.`name` ASC, a.`position` ASC	2.504 ms	18	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