The spécialist in high-quality fittings since 1965

+33 (0)4 86 30 70 70

Language:

Valves
Brass fittings
Cast iron and steel fittings
Plastic fittings
Sealing

Claw couplings
Quick-connect fittings
Connectors
Hose clamps
Valves
Camelock

Camelock

No products available yet

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

Load Time	710.752 ms
Querying Time	547 ms
Queries	503
Memory Peak Usage	11.5 Mb
Included Files	984 files - 11.73 Mb
PrestaShop Cache	- Mb
Global vars	0.04 Mb
- global $_MODULES	15k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- 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	10.859 ms	10.859 ms	2.44 Mb	2.7 Mb
__construct	0.017 ms	10.876 ms	- Mb	2.7 Mb
init	157.476 ms	168.352 ms	1.98 Mb	4.6 Mb
checkAccess	0.002 ms	168.354 ms	- Mb	4.6 Mb
setMedia	1.293 ms	169.647 ms	0.06 Mb	4.6 Mb
postProcess	0.001 ms	169.648 ms	- Mb	4.6 Mb
initHeader	0.001 ms	169.649 ms	- Mb	4.6 Mb
initContent	393.812 ms	563.461 ms	2.42 Mb	9.0 Mb
initFooter	0.002 ms	563.463 ms	- Mb	9.0 Mb
display	147.289 ms	710.752 ms	4.46 Mb	11.5 Mb

Hook	Time	Memory Usage
FilterCategoryContent	25.085 ms	0.30 Mb
=> customfieldgroups	18.651 ms	0.27 Mb
=> customfieldgroups	6.434 ms	0.03 Mb
DisplayHeader	20.729 ms	0.23 Mb
=> ps_shoppingcart	0.098 ms	- Mb
=> ps_searchbar	0.087 ms	- Mb
=> ps_imageslider	0.052 ms	- Mb
=> ps_googleanalytics	13.234 ms	0.12 Mb
=> customfieldgroups	6.743 ms	0.04 Mb
=> ets_cfultimate	0.228 ms	0.07 Mb
=> ets_blog	0.287 ms	0.01 Mb
displayFooter	12.559 ms	0.79 Mb
=> ps_linklist (widget)	10.926 ms	0.76 Mb
=> customhtml (widget)	1.633 ms	0.03 Mb
renderWidget	11.457 ms	0.35 Mb
=> ps_categorytree (widget)	11.457 ms	0.35 Mb
ActionPresentCart	8.060 ms	0.11 Mb
=> tgf_customcart	0.037 ms	- Mb
=> tgf_connector	8.023 ms	0.11 Mb
displayNavFullWidth	8.018 ms	0.83 Mb
=> customhtml (widget)	1.370 ms	0.03 Mb
=> ps_mainmenu (widget)	6.648 ms	0.81 Mb
displayNav2	7.571 ms	0.16 Mb
=> ps_contactinfo (widget)	1.743 ms	0.07 Mb
=> ps_languageselector (widget)	3.681 ms	0.06 Mb
=> customhtml (widget)	2.147 ms	0.03 Mb
DisplayFooterBefore	7.151 ms	0.27 Mb
=> customfieldgroups	0.530 ms	0.03 Mb
=> tgf_global_reassurance	6.616 ms	0.24 Mb
=> ets_blog	0.005 ms	- Mb
displaySearch	6.708 ms	0.11 Mb
=> ps_searchbar (widget)	2.379 ms	0.05 Mb
=> customhtml (widget)	2.336 ms	0.03 Mb
=> ps_searchbar (widget)	0.733 ms	0.01 Mb
=> customhtml (widget)	1.260 ms	0.03 Mb
displayNav1	4.173 ms	0.16 Mb
=> customhtml (widget)	4.173 ms	0.16 Mb
ActionFrontControllerSetVariables	4.150 ms	0.06 Mb
=> customfieldgroups	0.004 ms	- Mb
=> tgf_wishlist	0.023 ms	- Mb
=> tgf_connector	0.003 ms	- Mb
=> tgf_carrier_extender	4.120 ms	0.06 Mb
displayFooterLeft	3.491 ms	0.11 Mb
=> ps_emailsubscription (widget)	1.832 ms	0.06 Mb
=> ps_socialfollow (widget)	1.659 ms	0.05 Mb
DisplayAfterBodyOpeningTag	2.964 ms	0.02 Mb
=> customfieldgroups	2.964 ms	0.02 Mb
displayLeftColumn	2.428 ms	0.03 Mb
=> customhtml (widget)	2.428 ms	0.03 Mb
displayFooterBefore	2.241 ms	0.07 Mb
=> customhtml (widget)	1.811 ms	0.03 Mb
=> productdata (widget)	0.430 ms	0.04 Mb
DisplayLeftColumn	2.107 ms	0.03 Mb
=> ps_facetedsearch	1.341 ms	0.01 Mb
=> customfieldgroups	0.751 ms	0.02 Mb
=> ets_cfultimate	0.010 ms	- Mb
=> ets_blog	0.005 ms	- Mb
DisplayBeforeBodyClosingTag	1.907 ms	0.05 Mb
=> ps_googleanalytics	1.378 ms	0.02 Mb
=> customfieldgroups	0.529 ms	0.02 Mb
Header	1.884 ms	0.03 Mb
=> doofinder	1.449 ms	0.02 Mb
=> tgf_devis	0.435 ms	- Mb
displayTop	1.838 ms	0.07 Mb
=> customhtml (widget)	1.438 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.400 ms	0.04 Mb
DisplayNav1	1.568 ms	0.03 Mb
=> customfieldgroups	1.568 ms	0.03 Mb
DisplayTop	1.538 ms	0.06 Mb
=> tgf_fastorder	1.007 ms	0.03 Mb
=> customfieldgroups	0.523 ms	0.03 Mb
=> ets_cfultimate	0.008 ms	- Mb
displayWrapperTop	1.503 ms	0.02 Mb
=> customhtml (widget)	1.503 ms	0.02 Mb
DisplaySearch	1.271 ms	0.05 Mb
=> customfieldgroups	0.697 ms	0.03 Mb
=> customfieldgroups	0.574 ms	0.03 Mb
displayFooterAfter	1.233 ms	0.03 Mb
=> customhtml (widget)	1.233 ms	0.03 Mb
DisplayFooter	1.128 ms	0.05 Mb
=> customfieldgroups	0.537 ms	0.03 Mb
=> ets_cfultimate	0.591 ms	0.02 Mb
DisplayBanner	0.928 ms	0.02 Mb
=> customfieldgroups	0.928 ms	0.02 Mb
DisplayNav2	0.785 ms	0.03 Mb
=> customfieldgroups	0.775 ms	0.03 Mb
=> ets_cfultimate	0.010 ms	- Mb
DisplayContentWrapperTop	0.666 ms	0.02 Mb
=> customfieldgroups	0.666 ms	0.02 Mb
DisplayNavFullWidth	0.618 ms	0.03 Mb
=> customfieldgroups	0.618 ms	0.03 Mb
DisplayWrapperTop	0.559 ms	0.02 Mb
=> customfieldgroups	0.559 ms	0.02 Mb
DisplayFooterAfter	0.487 ms	0.03 Mb
=> customfieldgroups	0.487 ms	0.03 Mb
DisplayFooterCategory	0.474 ms	0.02 Mb
=> customfieldgroups	0.474 ms	0.02 Mb
DisplayNotFound	0.423 ms	0.03 Mb
=> customfieldgroups	0.423 ms	0.03 Mb
DisplayContentWrapperBottom	0.405 ms	0.02 Mb
=> customfieldgroups	0.405 ms	0.02 Mb
DisplayWrapperBottom	0.376 ms	0.02 Mb
=> tgf_fastorder	0.012 ms	- Mb
=> customfieldgroups	0.362 ms	0.02 Mb
=> tgf_wishlist	0.002 ms	- Mb
DisplayHeaderCategory	0.361 ms	0.02 Mb
=> customfieldgroups	0.361 ms	0.02 Mb
ActionFrontControllerSetMedia	0.278 ms	0.01 Mb
=> ps_emailsubscription	0.117 ms	- Mb
=> ps_socialfollow	0.031 ms	- Mb
=> ps_emailalerts	0.032 ms	- Mb
=> combinationtable	0.028 ms	- Mb
=> productdata	0.003 ms	- Mb
=> customfieldgroups	0.038 ms	- Mb
=> tgf_global_reassurance	0.029 ms	- Mb
FilterProductSearch	0.210 ms	- Mb
=> customfieldgroups	0.210 ms	- Mb
ProductSearchProvider	0.150 ms	- Mb
=> ps_facetedsearch	0.150 ms	- Mb
ModuleRoutes	0.034 ms	0.01 Mb
=> doofinder	0.005 ms	- Mb
=> tgf_wishlist	0.002 ms	- Mb
=> ets_cfultimate	0.016 ms	- Mb
=> ets_blog	0.011 ms	0.01 Mb
ActionOutputHTMLBefore	0.016 ms	- Mb
=> ets_cfultimate	0.016 ms	- Mb
ActionDispatcherBefore	0.005 ms	- Mb
=> etsloginascustomer	0.005 ms	- Mb
ActionDispatcher	0.002 ms	- Mb
=> tgf_redirection	0.002 ms	- Mb
43 hook(s)	149.541 ms	4.29 Mb

Module	Time	Memory Usage
doofinder	4.230 ms	0.01 Mb
__construct	2.770 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookHeader	1.452 ms	0.03 Mb
tgf_wishlist	1.063 ms	0.02 Mb
__construct	1.033 ms	0.01 Mb
hookModuleRoutes	0.003 ms	- Mb
hookActionFrontControllerSetVariables	0.024 ms	- Mb
hookDisplayWrapperBottom	0.003 ms	- Mb
ets_cfultimate	2.262 ms	0.11 Mb
__construct	1.369 ms	0.01 Mb
hookModuleRoutes	0.018 ms	- Mb
hookDisplayHeader	0.232 ms	0.07 Mb
hookDisplayNav2	0.011 ms	- Mb
hookDisplayTop	0.009 ms	- Mb
hookDisplayLeftColumn	0.011 ms	- Mb
hookDisplayFooter	0.594 ms	0.02 Mb
hookActionOutputHTMLBefore	0.018 ms	- Mb
ets_blog	2.455 ms	0.04 Mb
__construct	2.142 ms	0.03 Mb
hookModuleRoutes	0.013 ms	0.01 Mb
hookDisplayHeader	0.289 ms	0.01 Mb
hookDisplayLeftColumn	0.005 ms	- Mb
hookDisplayFooterBefore	0.006 ms	- Mb
etsloginascustomer	1.044 ms	0.02 Mb
__construct	1.035 ms	0.01 Mb
hookActionDispatcherBefore	0.009 ms	- Mb
tgf_redirection	1.504 ms	0.06 Mb
__construct	1.500 ms	0.06 Mb
hookActionDispatcher	0.004 ms	- Mb
customfieldgroups	46.981 ms	0.84 Mb
__construct	0.092 ms	0.01 Mb
hookFilterCategoryContent	18.655 ms	0.27 Mb
hookFilterCategoryContent	6.438 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.040 ms	- Mb
hookActionFrontControllerSetVariables	0.007 ms	- Mb
hookDisplayHeader	6.747 ms	0.04 Mb
hookFilterProductSearch	0.213 ms	- Mb
hookDisplayAfterBodyOpeningTag	2.968 ms	0.02 Mb
hookDisplayBanner	0.931 ms	0.02 Mb
hookDisplayNav1	1.571 ms	0.03 Mb
hookDisplayNav2	0.779 ms	0.03 Mb
hookDisplaySearch	0.700 ms	0.03 Mb
hookDisplayTop	0.526 ms	0.03 Mb
hookDisplayNavFullWidth	0.622 ms	0.03 Mb
hookDisplayWrapperTop	0.562 ms	0.02 Mb
hookDisplayLeftColumn	0.754 ms	0.02 Mb
hookDisplayContentWrapperTop	0.669 ms	0.02 Mb
hookDisplayHeaderCategory	0.363 ms	0.02 Mb
hookDisplaySearch	0.578 ms	0.03 Mb
hookDisplayNotFound	0.425 ms	0.03 Mb
hookDisplayFooterCategory	0.477 ms	0.02 Mb
hookDisplayContentWrapperBottom	0.407 ms	0.02 Mb
hookDisplayWrapperBottom	0.364 ms	0.02 Mb
hookDisplayFooterBefore	0.533 ms	0.03 Mb
hookDisplayFooter	0.539 ms	0.03 Mb
hookDisplayFooterAfter	0.489 ms	0.03 Mb
hookDisplayBeforeBodyClosingTag	0.532 ms	0.02 Mb
ps_emailsubscription	2.073 ms	0.07 Mb
__construct	0.118 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.120 ms	- Mb
displayFooterLeft	1.835 ms	0.06 Mb
ps_socialfollow	1.740 ms	0.06 Mb
__construct	0.046 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.033 ms	- Mb
displayFooterLeft	1.661 ms	0.05 Mb
ps_emailalerts	0.095 ms	0.01 Mb
__construct	0.062 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.033 ms	- Mb
combinationtable	0.086 ms	0.01 Mb
__construct	0.057 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.029 ms	- Mb
productdata	0.485 ms	0.05 Mb
__construct	0.048 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.004 ms	- Mb
displayFooterBefore	0.433 ms	0.04 Mb
tgf_global_reassurance	6.715 ms	0.25 Mb
__construct	0.066 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.030 ms	- Mb
hookDisplayFooterBefore	6.619 ms	0.24 Mb
tgf_customcart	0.138 ms	0.01 Mb
__construct	0.099 ms	0.01 Mb
hookActionPresentCart	0.039 ms	- Mb
tgf_connector	8.100 ms	0.12 Mb
__construct	0.070 ms	0.01 Mb
hookActionPresentCart	8.027 ms	0.11 Mb
hookActionFrontControllerSetVariables	0.003 ms	- Mb
tgf_carrier_extender	4.230 ms	0.06 Mb
__construct	0.104 ms	0.01 Mb
hookActionFrontControllerSetVariables	4.126 ms	0.06 Mb
tgf_technical_information	0.118 ms	0.01 Mb
__construct	0.118 ms	0.01 Mb
ps_shoppingcart	0.557 ms	0.05 Mb
__construct	0.054 ms	0.01 Mb
hookDisplayHeader	0.100 ms	- Mb
displayTop	0.403 ms	0.04 Mb
ps_searchbar	3.247 ms	0.06 Mb
__construct	0.040 ms	0.01 Mb
hookDisplayHeader	0.088 ms	- Mb
displaySearch	2.383 ms	0.05 Mb
displaySearch	0.736 ms	0.01 Mb
ps_imageslider	0.114 ms	0.01 Mb
__construct	0.061 ms	0.01 Mb
hookDisplayHeader	0.053 ms	- Mb
ps_googleanalytics	14.677 ms	0.15 Mb
__construct	0.059 ms	0.01 Mb
hookDisplayHeader	13.237 ms	0.12 Mb
hookDisplayBeforeBodyClosingTag	1.381 ms	0.02 Mb
ps_featuredproducts	0.084 ms	- Mb
__construct	0.084 ms	- Mb
tgf_devis	1.138 ms	0.01 Mb
__construct	0.701 ms	0.01 Mb
hookHeader	0.437 ms	- Mb
ps_facetedsearch	1.732 ms	0.02 Mb
__construct	0.236 ms	0.01 Mb
hookProductSearchProvider	0.152 ms	- Mb
hookDisplayLeftColumn	1.344 ms	0.01 Mb
customhtml	21.687 ms	0.47 Mb
__construct	0.320 ms	0.02 Mb
displayNav1	4.176 ms	0.16 Mb
displayNav2	2.150 ms	0.03 Mb
displaySearch	2.339 ms	0.03 Mb
displayTop	1.441 ms	0.03 Mb
displayNavFullWidth	1.374 ms	0.03 Mb
displayWrapperTop	1.506 ms	0.03 Mb
displayLeftColumn	2.432 ms	0.03 Mb
displaySearch	1.264 ms	0.03 Mb
displayFooterBefore	1.814 ms	0.03 Mb
displayFooter	1.636 ms	0.03 Mb
displayFooterAfter	1.235 ms	0.03 Mb
ps_contactinfo	1.841 ms	0.08 Mb
__construct	0.095 ms	0.01 Mb
displayNav2	1.746 ms	0.07 Mb
ps_languageselector	3.785 ms	0.07 Mb
__construct	0.099 ms	0.01 Mb
displayNav2	3.686 ms	0.07 Mb
tgf_fastorder	1.558 ms	0.08 Mb
__construct	0.535 ms	0.05 Mb
hookDisplayTop	1.010 ms	0.03 Mb
hookDisplayWrapperBottom	0.013 ms	- Mb
ps_mainmenu	6.746 ms	0.81 Mb
__construct	0.095 ms	0.01 Mb
displayNavFullWidth	6.651 ms	0.81 Mb
ps_categorytree	11.551 ms	0.35 Mb
__construct	0.091 ms	0.01 Mb
renderWidget	11.460 ms	0.35 Mb
ps_linklist	11.145 ms	0.77 Mb
__construct	0.215 ms	0.01 Mb
displayFooter	10.930 ms	0.76 Mb
31 module(s)	163.180 ms	4.68 Mb

Camelock

No products available yet

Stopwatch SQL - 503 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
33 queries	SELECT v.value FROM ps_cfg_field_value v WHERE v.id_entity=XX AND v.id_field_group=XX AND v.id_shop=XX LIMIT XX
16 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 queries	SELECT state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
9 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
6 queries	SELECT c.description FROM ps_carrier_extender c WHERE id_carrier = XX AND id_lang = XX AND id_shop = XX LIMIT XX
6 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
5 queries	SELECT * FROM ps_cfg_file f WHERE f.id_file=XX LIMIT XX
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_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = 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 IN (XX, XX, XX))) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_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 IN (XX, XX, XX))) AND ((pac_XX.id_attribute=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT tmai.tempmini_min, MIN(tempmini_min) as min, MAX(tempmini_max) as max FROM ps_product p INNER JOIN ps_layered_temperature_index tmai ON (tmai.id_product = p.id_product AND tmai.id_shop = XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_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 IN (XX, XX, XX))) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX
2 queries	SELECT tmai.tempmaxi_min, MIN(tempmaxi_min) as min, MAX(tempmaxi_max) as max FROM ps_product p INNER JOIN ps_layered_temperature_index tmai ON (tmai.id_product = p.id_product AND tmai.id_shop = XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_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 IN (XX, XX, XX))) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX
2 queries	SELECT * FROM ps_customhtmlblock AS psb LEFT JOIN ps_customhtmlblock_lang AS psl ON psb.id_customhtmlblock = psl.id_customhtmlblock LEFT JOIN ps_customhtmlblock_shop AS pss ON psb.id_customhtmlblock = pss.id_customhtmlblock WHERE id_shop =XX AND id_lang =XX AND `hook_position` = "displayNavXX" AND `showhook` = XX ORDER BY `position` ASC
2 queries	SELECT l., s., g.* FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_position p ON p.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_lang l ON l.id_field_group = g.id_field_group AND l.id_lang=XX WHERE p.position="displayNavXX" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT * FROM ps_customhtmlblock AS psb LEFT JOIN ps_customhtmlblock_lang AS psl ON psb.id_customhtmlblock = psl.id_customhtmlblock LEFT JOIN ps_customhtmlblock_shop AS pss ON psb.id_customhtmlblock = pss.id_customhtmlblock WHERE id_shop =XX AND id_lang =XX AND `hook_position` = "displaySearch" AND `showhook` = XX ORDER BY `position` ASC
2 queries	SELECT l., s., g.* FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_position p ON p.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_lang l ON l.id_field_group = g.id_field_group AND l.id_lang=XX WHERE p.position="displaySearch" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT * FROM `ps_link_block` a LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_link_block_lang` WHERE `id_link_block` = XX

Name	Instances	Source
Category	40	/override/controllers/front/listing/CategoryController.php:45 (__construct) [id: 182] /controllers/front/listing/CategoryController.php:78 (__construct) [id: 182] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 182] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 182] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 1] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 2] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 13] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 2] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 94] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 157] /classes/Meta.php:380 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:379 (__construct) [id: 182] /modules/ps_facetedsearch/src/Filters/Block.php:197 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 182] /override/modules/ps_categorytree/ps_categorytree.php:107 (__construct) [id: 182] /override/modules/ps_categorytree/ps_categorytree.php:113 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 158] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 183] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 185] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 187] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 186] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 182]
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	6	/config/config.inc.php:146 (__construct) [id: 8] /classes/controller/FrontController.php:350 (__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:687 (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
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`	10.031 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)
306	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	6.461 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)
235	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	6.163 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)
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 = 136 ORDER BY agl.`name` ASC, a.`position` ASC	5.855 ms	9	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)
284	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 = 95 ORDER BY agl.`name` ASC, a.`position` ASC	5.392 ms	29	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)
3	SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1	5.074 ms	1			/classes/shop/Shop.php:1183 /classes/Configuration.php:236 (isFeatureActive) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
309	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	4.896 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)
297	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 = 108 ORDER BY agl.`name` ASC, a.`position` ASC	4.789 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)
194	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	4.671 ms	208	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)
81	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 1) LIMIT 1	4.590 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) /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)
315	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 = 126 ORDER BY agl.`name` ASC, a.`position` ASC	4.496 ms	104	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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 = 127 ORDER BY agl.`name` ASC, a.`position` ASC	4.427 ms	32	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
236	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	4.298 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)
251	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	4.227 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)
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 = 99 ORDER BY agl.`name` ASC, a.`position` ASC	4.166 ms	48	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
109	SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('13340' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '13340'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	4.022 ms	1	Yes		/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:6834 (getTaxCalculator) /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)
301	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 = 112 ORDER BY agl.`name` ASC, a.`position` ASC	3.966 ms	60	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)
98	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.951 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)
304	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 = 115 ORDER BY agl.`name` ASC, a.`position` ASC	3.831 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)
283	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	3.659 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)
43	SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1	3.634 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/controller/FrontController.php:350 (__construct) /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)
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 = 131 ORDER BY agl.`name` ASC, a.`position` ASC	3.541 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)
79	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=1 AND v.id_field_group=78 AND v.id_shop=1 LIMIT 1	3.486 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)
329	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 = 140 ORDER BY agl.`name` ASC, a.`position` ASC	3.475 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)
125	SELECT SQL_NO_CACHE depends_on_stock FROM `ps_stock_available` WHERE (id_product = 19591) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	3.453 ms	1			/classes/stock/StockAvailable.php:753 /classes/Product.php:7803 (dependsOnStock) /classes/Product.php:751 (loadStockData) /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)
362	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 = 173 ORDER BY agl.`name` ASC, a.`position` ASC	3.423 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)
279	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 = 90 ORDER BY agl.`name` ASC, a.`position` ASC	3.414 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)
331	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 = 142 ORDER BY agl.`name` ASC, a.`position` ASC	3.341 ms	24	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	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.262 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)
345	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 = 156 ORDER BY agl.`name` ASC, a.`position` ASC	3.078 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)
168	SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC	3.043 ms	7	Yes		/classes/ImageType.php:109 /src/Adapter/Image/ImageRetriever.php:368 (getImagesTypes) /classes/controller/FrontController.php:1571 (getNoPictureImage) /classes/controller/FrontController.php:1697 (getTemplateVarUrls) /classes/controller/FrontController.php:507 (getTemplateVarShop) /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)
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`)	3.031 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)
196	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 IN (43363, 43366, 43373))) AND ((pac_1.id_attribute=58190)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=274 AND c.nright<=275 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	3.011 ms	504	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)
237	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 = 45 ORDER BY agl.`name` ASC, a.`position` ASC	3.010 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)
54	SELECT SQL_NO_CACHE 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=2 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 (453,461,256)	2.948 ms	10			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:878 /modules/customfieldgroups/src/Repository/FieldGroupRepository.php:924 (getRecursiveFieldGroups) /modules/customfieldgroups/src/Repository/FieldGroupRepository.php:620 (getRecursiveFieldGroups) /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:155 (getFieldGroupsByEntityOptimized) /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)
77	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	2.890 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)
341	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 = 152 ORDER BY agl.`name` ASC, a.`position` ASC	2.863 ms	63	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)
148	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=157 AND v.id_field_group=290 AND v.id_shop=1 LIMIT 1	2.843 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)
308	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	2.830 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)
276	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 = 87 ORDER BY agl.`name` ASC, a.`position` ASC	2.821 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)

#	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