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

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

Compressed air and quick couplings

No products available yet

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

Load Time	3837 ms
Querying Time	739 ms
Queries	520
Memory Peak Usage	11.8 Mb
Included Files	984 files - 11.73 Mb
PrestaShop Cache	- Mb
Global vars	0.04 Mb
- global $_MODULES	15k
- global $_SERVER	7k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	19.163 ms	19.163 ms	2.44 Mb	2.7 Mb
__construct	0.019 ms	19.182 ms	- Mb	2.7 Mb
init	241.209 ms	260.391 ms	2.07 Mb	4.7 Mb
checkAccess	0.002 ms	260.393 ms	- Mb	4.7 Mb
setMedia	3.616 ms	264.009 ms	0.06 Mb	4.7 Mb
postProcess	0.001 ms	264.010 ms	- Mb	4.7 Mb
initHeader	0.001 ms	264.011 ms	- Mb	4.7 Mb
initContent	521.062 ms	785.073 ms	2.42 Mb	9.1 Mb
initFooter	0.003 ms	785.076 ms	- Mb	9.1 Mb
display	3052 ms	3837 ms	4.61 Mb	11.8 Mb

Hook	Time	Memory Usage
FilterCategoryContent	36.634 ms	0.30 Mb
=> customfieldgroups	27.359 ms	0.27 Mb
=> customfieldgroups	9.275 ms	0.03 Mb
DisplayHeader	18.296 ms	0.17 Mb
=> ps_shoppingcart	0.095 ms	- Mb
=> ps_searchbar	0.088 ms	- Mb
=> ps_imageslider	0.045 ms	- Mb
=> ps_googleanalytics	11.061 ms	0.12 Mb
=> customfieldgroups	5.237 ms	0.04 Mb
=> ets_cfultimate	1.565 ms	- Mb
=> ets_blog	0.205 ms	0.01 Mb
ActionPresentCart	16.916 ms	0.17 Mb
=> tgf_customcart	0.034 ms	- Mb
=> tgf_connector	16.882 ms	0.17 Mb
displayFooter	12.484 ms	0.80 Mb
=> ps_linklist (widget)	10.799 ms	0.77 Mb
=> customhtml (widget)	1.685 ms	0.03 Mb
renderWidget	9.929 ms	0.48 Mb
=> ps_categorytree (widget)	9.929 ms	0.48 Mb
ActionFrontControllerSetVariables	8.446 ms	0.06 Mb
=> customfieldgroups	0.004 ms	- Mb
=> tgf_wishlist	0.024 ms	- Mb
=> tgf_connector	0.003 ms	- Mb
=> tgf_carrier_extender	8.415 ms	0.06 Mb
displayNavFullWidth	8.349 ms	0.83 Mb
=> customhtml (widget)	1.451 ms	0.03 Mb
=> ps_mainmenu (widget)	6.898 ms	0.80 Mb
DisplayFooterBefore	6.787 ms	0.28 Mb
=> customfieldgroups	0.622 ms	0.03 Mb
=> tgf_global_reassurance	6.159 ms	0.25 Mb
=> ets_blog	0.006 ms	- Mb
Header	6.644 ms	0.09 Mb
=> doofinder	6.607 ms	0.09 Mb
=> tgf_devis	0.037 ms	- Mb
displayNav2	6.614 ms	0.16 Mb
=> ps_contactinfo (widget)	1.868 ms	0.07 Mb
=> ps_languageselector (widget)	3.360 ms	0.06 Mb
=> customhtml (widget)	1.386 ms	0.03 Mb
displaySearch	5.101 ms	0.11 Mb
=> ps_searchbar (widget)	1.286 ms	0.05 Mb
=> customhtml (widget)	1.364 ms	0.03 Mb
=> ps_searchbar (widget)	0.787 ms	0.01 Mb
=> customhtml (widget)	1.664 ms	0.03 Mb
displayFooterLeft	3.863 ms	0.11 Mb
=> ps_emailsubscription (widget)	2.260 ms	0.06 Mb
=> ps_socialfollow (widget)	1.603 ms	0.05 Mb
displayTop	2.451 ms	0.07 Mb
=> customhtml (widget)	1.873 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.578 ms	0.04 Mb
displayNav1	2.335 ms	0.16 Mb
=> customhtml (widget)	2.335 ms	0.16 Mb
DisplayBeforeBodyClosingTag	2.056 ms	0.05 Mb
=> ps_googleanalytics	1.551 ms	0.02 Mb
=> customfieldgroups	0.505 ms	0.02 Mb
DisplayTop	2.018 ms	0.06 Mb
=> tgf_fastorder	1.373 ms	0.03 Mb
=> customfieldgroups	0.636 ms	0.03 Mb
=> ets_cfultimate	0.009 ms	- Mb
displayFooterBefore	1.965 ms	0.07 Mb
=> customhtml (widget)	1.481 ms	0.03 Mb
=> productdata (widget)	0.484 ms	0.04 Mb
DisplayLeftColumn	1.825 ms	0.03 Mb
=> ps_facetedsearch	1.274 ms	0.01 Mb
=> customfieldgroups	0.537 ms	0.02 Mb
=> ets_cfultimate	0.011 ms	- Mb
=> ets_blog	0.003 ms	- Mb
displayFooterAfter	1.500 ms	0.03 Mb
=> customhtml (widget)	1.500 ms	0.03 Mb
displayLeftColumn	1.418 ms	0.03 Mb
=> customhtml (widget)	1.418 ms	0.03 Mb
displayWrapperTop	1.305 ms	0.02 Mb
=> customhtml (widget)	1.305 ms	0.02 Mb
DisplaySearch	1.192 ms	0.05 Mb
=> customfieldgroups	0.514 ms	0.03 Mb
=> customfieldgroups	0.678 ms	0.03 Mb
DisplayFooter	0.931 ms	0.05 Mb
=> customfieldgroups	0.545 ms	0.03 Mb
=> ets_cfultimate	0.386 ms	0.02 Mb
DisplayNav2	0.708 ms	0.03 Mb
=> customfieldgroups	0.695 ms	0.03 Mb
=> ets_cfultimate	0.013 ms	- Mb
DisplayAfterBodyOpeningTag	0.695 ms	0.02 Mb
=> customfieldgroups	0.695 ms	0.02 Mb
DisplayContentWrapperTop	0.668 ms	0.02 Mb
=> customfieldgroups	0.668 ms	0.02 Mb
DisplayContentWrapperBottom	0.666 ms	0.02 Mb
=> customfieldgroups	0.666 ms	0.02 Mb
DisplayNotFound	0.654 ms	0.03 Mb
=> customfieldgroups	0.654 ms	0.03 Mb
DisplayHeaderCategory	0.636 ms	0.02 Mb
=> customfieldgroups	0.636 ms	0.02 Mb
DisplayNavFullWidth	0.593 ms	0.03 Mb
=> customfieldgroups	0.593 ms	0.03 Mb
DisplayWrapperTop	0.593 ms	0.02 Mb
=> customfieldgroups	0.593 ms	0.02 Mb
DisplayFooterAfter	0.573 ms	0.03 Mb
=> customfieldgroups	0.573 ms	0.03 Mb
DisplayBanner	0.526 ms	0.02 Mb
=> customfieldgroups	0.526 ms	0.02 Mb
DisplayNav1	0.480 ms	0.03 Mb
=> customfieldgroups	0.480 ms	0.03 Mb
DisplayFooterCategory	0.434 ms	0.02 Mb
=> customfieldgroups	0.434 ms	0.02 Mb
DisplayWrapperBottom	0.420 ms	0.02 Mb
=> tgf_fastorder	0.011 ms	- Mb
=> customfieldgroups	0.407 ms	0.02 Mb
=> tgf_wishlist	0.002 ms	- Mb
ActionFrontControllerSetMedia	0.369 ms	0.01 Mb
=> ps_emailsubscription	0.086 ms	- Mb
=> ps_socialfollow	0.027 ms	- Mb
=> ps_emailalerts	0.170 ms	- Mb
=> combinationtable	0.031 ms	- Mb
=> productdata	0.001 ms	- Mb
=> customfieldgroups	0.030 ms	- Mb
=> tgf_global_reassurance	0.024 ms	- Mb
FilterProductSearch	0.198 ms	- Mb
=> customfieldgroups	0.198 ms	- Mb
ProductSearchProvider	0.146 ms	- Mb
=> ps_facetedsearch	0.146 ms	- Mb
ModuleRoutes	0.032 ms	0.01 Mb
=> doofinder	0.004 ms	- Mb
=> tgf_wishlist	0.001 ms	- Mb
=> ets_cfultimate	0.017 ms	- Mb
=> ets_blog	0.010 ms	0.01 Mb
ActionOutputHTMLBefore	0.016 ms	- Mb
=> ets_cfultimate	0.016 ms	- Mb
ActionDispatcherBefore	0.003 ms	- Mb
=> etsloginascustomer	0.003 ms	- Mb
ActionDispatcher	0.002 ms	- Mb
=> tgf_redirection	0.002 ms	- Mb
43 hook(s)	167.470 ms	4.50 Mb

Module	Time	Memory Usage
doofinder	12.959 ms	0.08 Mb
__construct	6.340 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookHeader	6.611 ms	0.09 Mb
tgf_wishlist	1.757 ms	0.02 Mb
__construct	1.724 ms	0.01 Mb
hookModuleRoutes	0.003 ms	- Mb
hookActionFrontControllerSetVariables	0.027 ms	- Mb
hookDisplayWrapperBottom	0.003 ms	- Mb
ets_cfultimate	6.794 ms	0.05 Mb
__construct	4.764 ms	0.01 Mb
hookModuleRoutes	0.018 ms	- Mb
hookDisplayHeader	1.570 ms	0.01 Mb
hookDisplayNav2	0.014 ms	- Mb
hookDisplayTop	0.010 ms	- Mb
hookDisplayLeftColumn	0.012 ms	- Mb
hookDisplayFooter	0.388 ms	0.02 Mb
hookActionOutputHTMLBefore	0.018 ms	- Mb
ets_blog	3.732 ms	0.04 Mb
__construct	3.503 ms	0.03 Mb
hookModuleRoutes	0.013 ms	0.01 Mb
hookDisplayHeader	0.206 ms	0.01 Mb
hookDisplayLeftColumn	0.004 ms	- Mb
hookDisplayFooterBefore	0.006 ms	- Mb
etsloginascustomer	0.561 ms	0.02 Mb
__construct	0.556 ms	0.01 Mb
hookActionDispatcherBefore	0.005 ms	- Mb
tgf_redirection	0.625 ms	0.06 Mb
__construct	0.619 ms	0.06 Mb
hookActionDispatcher	0.006 ms	- Mb
customfieldgroups	53.930 ms	0.84 Mb
__construct	0.100 ms	0.01 Mb
hookFilterCategoryContent	27.362 ms	0.27 Mb
hookFilterCategoryContent	9.278 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.031 ms	- Mb
hookActionFrontControllerSetVariables	0.008 ms	- Mb
hookDisplayHeader	5.241 ms	0.04 Mb
hookFilterProductSearch	0.201 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.698 ms	0.02 Mb
hookDisplayBanner	0.529 ms	0.02 Mb
hookDisplayNav1	0.482 ms	0.03 Mb
hookDisplayNav2	0.699 ms	0.03 Mb
hookDisplaySearch	0.516 ms	0.03 Mb
hookDisplayTop	0.638 ms	0.03 Mb
hookDisplayNavFullWidth	0.596 ms	0.03 Mb
hookDisplayWrapperTop	0.595 ms	0.02 Mb
hookDisplayLeftColumn	0.540 ms	0.02 Mb
hookDisplayContentWrapperTop	0.671 ms	0.02 Mb
hookDisplayHeaderCategory	0.638 ms	0.02 Mb
hookDisplaySearch	0.681 ms	0.03 Mb
hookDisplayNotFound	0.658 ms	0.03 Mb
hookDisplayFooterCategory	0.436 ms	0.02 Mb
hookDisplayContentWrapperBottom	0.670 ms	0.02 Mb
hookDisplayWrapperBottom	0.409 ms	0.02 Mb
hookDisplayFooterBefore	0.624 ms	0.03 Mb
hookDisplayFooter	0.547 ms	0.03 Mb
hookDisplayFooterAfter	0.575 ms	0.03 Mb
hookDisplayBeforeBodyClosingTag	0.508 ms	0.02 Mb
ps_emailsubscription	2.452 ms	0.07 Mb
__construct	0.099 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.088 ms	- Mb
displayFooterLeft	2.265 ms	0.06 Mb
ps_socialfollow	1.682 ms	0.06 Mb
__construct	0.048 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.028 ms	- Mb
displayFooterLeft	1.606 ms	0.05 Mb
ps_emailalerts	2.757 ms	0.01 Mb
__construct	1.308 ms	0.01 Mb
hookActionFrontControllerSetMedia	1.449 ms	- Mb
combinationtable	0.120 ms	0.01 Mb
__construct	0.088 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.032 ms	- Mb
productdata	0.541 ms	0.05 Mb
__construct	0.052 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.002 ms	- Mb
displayFooterBefore	0.487 ms	0.04 Mb
tgf_global_reassurance	6.235 ms	0.25 Mb
__construct	0.048 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.025 ms	- Mb
hookDisplayFooterBefore	6.162 ms	0.25 Mb
tgf_customcart	0.124 ms	0.01 Mb
__construct	0.089 ms	0.01 Mb
hookActionPresentCart	0.035 ms	- Mb
tgf_connector	16.945 ms	0.18 Mb
__construct	0.055 ms	0.01 Mb
hookActionPresentCart	16.886 ms	0.17 Mb
hookActionFrontControllerSetVariables	0.004 ms	- Mb
tgf_carrier_extender	8.521 ms	0.06 Mb
__construct	0.101 ms	0.01 Mb
hookActionFrontControllerSetVariables	8.420 ms	0.06 Mb
tgf_technical_information	0.113 ms	0.01 Mb
__construct	0.113 ms	0.01 Mb
ps_shoppingcart	0.733 ms	0.05 Mb
__construct	0.055 ms	0.01 Mb
hookDisplayHeader	0.096 ms	- Mb
displayTop	0.582 ms	0.04 Mb
ps_searchbar	2.211 ms	0.06 Mb
__construct	0.041 ms	0.01 Mb
hookDisplayHeader	0.090 ms	- Mb
displaySearch	1.289 ms	0.05 Mb
displaySearch	0.791 ms	0.01 Mb
ps_imageslider	0.097 ms	0.01 Mb
__construct	0.051 ms	0.01 Mb
hookDisplayHeader	0.046 ms	- Mb
ps_googleanalytics	12.663 ms	0.15 Mb
__construct	0.046 ms	0.01 Mb
hookDisplayHeader	11.064 ms	0.12 Mb
hookDisplayBeforeBodyClosingTag	1.553 ms	0.02 Mb
ps_featuredproducts	0.069 ms	- Mb
__construct	0.069 ms	- Mb
tgf_devis	0.168 ms	0.01 Mb
__construct	0.129 ms	0.01 Mb
hookHeader	0.039 ms	- Mb
ps_facetedsearch	1.618 ms	0.02 Mb
__construct	0.191 ms	0.01 Mb
hookProductSearchProvider	0.148 ms	- Mb
hookDisplayLeftColumn	1.279 ms	0.01 Mb
customhtml	17.667 ms	0.47 Mb
__construct	0.153 ms	0.02 Mb
displayNav1	2.338 ms	0.16 Mb
displayNav2	1.389 ms	0.03 Mb
displaySearch	1.368 ms	0.03 Mb
displayTop	1.876 ms	0.03 Mb
displayNavFullWidth	1.453 ms	0.03 Mb
displayWrapperTop	1.308 ms	0.03 Mb
displayLeftColumn	1.421 ms	0.03 Mb
displaySearch	1.668 ms	0.03 Mb
displayFooterBefore	1.503 ms	0.03 Mb
displayFooter	1.688 ms	0.03 Mb
displayFooterAfter	1.502 ms	0.03 Mb
ps_contactinfo	1.956 ms	0.08 Mb
__construct	0.084 ms	0.01 Mb
displayNav2	1.872 ms	0.07 Mb
ps_languageselector	3.440 ms	0.07 Mb
__construct	0.076 ms	0.01 Mb
displayNav2	3.364 ms	0.06 Mb
tgf_fastorder	1.957 ms	0.08 Mb
__construct	0.568 ms	0.05 Mb
hookDisplayTop	1.377 ms	0.03 Mb
hookDisplayWrapperBottom	0.012 ms	- Mb
ps_mainmenu	7.013 ms	0.81 Mb
__construct	0.110 ms	0.01 Mb
displayNavFullWidth	6.903 ms	0.80 Mb
ps_categorytree	10.043 ms	0.48 Mb
__construct	0.111 ms	0.01 Mb
renderWidget	9.932 ms	0.48 Mb
ps_linklist	11.015 ms	0.78 Mb
__construct	0.213 ms	0.01 Mb
displayFooter	10.802 ms	0.77 Mb
31 module(s)	190.497 ms	4.89 Mb

Compressed air and quick couplings

No products available yet

Stopwatch SQL - 520 queries

Doubles

Tables stress

ObjectModel instances

Included Files

197 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
29 queries	SELECT v.value FROM ps_cfg_field_value v WHERE v.id_entity=XX AND v.id_field_group=XX AND v.id_shop=XX LIMIT XX
26 queries	SELECT state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
18 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
16 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT c.description FROM ps_carrier_extender c WHERE id_carrier = XX AND id_lang = XX AND id_shop = XX LIMIT XX
6 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
5 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
5 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5 queries	SELECT * FROM ps_cfg_file f WHERE f.id_file=XX LIMIT XX
4 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
4 queries	SELECT g.*, gl.name, f.id_field, f.data, f.type FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON g.id_field_group=s.id_field_group LEFT JOIN ps_cfg_field_group_lang gl ON gl.id_field_group=g.id_field_group AND gl.id_lang=XX LEFT JOIN ps_cfg_field_group_field gf ON g.id_field_group=gf.id_field_group LEFT JOIN ps_cfg_field f ON gf.id_field=f.id_field WHERE gf.id_field_group IN (XX,XX,XX)
4 queries	SELECT * FROM `ps_feature` a LEFT JOIN `ps_feature_lang` `b` ON a.`id_feature` = b.`id_feature` AND b.`id_lang` = XX LEFT JOIN `ps_feature_shop` `c` ON a.`id_feature` = c.`id_feature` AND c.`id_shop` = XX WHERE (a.`id_feature` = XX) LIMIT XX
3 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
3 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
3 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT g.id_field_group FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group WHERE g.entity="category" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT g.*, gl.name, f.id_field, f.data, f.type FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON g.id_field_group=s.id_field_group LEFT JOIN ps_cfg_field_group_lang gl ON gl.id_field_group=g.id_field_group AND gl.id_lang=XX LEFT JOIN ps_cfg_field_group_field gf ON g.id_field_group=gf.id_field_group LEFT JOIN ps_cfg_field f ON gf.id_field=f.id_field WHERE gf.id_field_group IN (XX,XX,XX,XX) AND s.id_shop=XX
2 queries	SELECT g.*, gl.name, f.id_field, f.data, f.type FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON g.id_field_group=s.id_field_group LEFT JOIN ps_cfg_field_group_lang gl ON gl.id_field_group=g.id_field_group AND gl.id_lang=XX LEFT JOIN ps_cfg_field_group_field gf ON g.id_field_group=gf.id_field_group LEFT JOIN ps_cfg_field f ON gf.id_field=f.id_field WHERE gf.id_field_group IN (XX,XX)
2 queries	SELECT l., f., fgf.position FROM ps_cfg_field f LEFT JOIN ps_cfg_field_lang l ON l.id_field = f.id_field AND l.id_lang=XX LEFT JOIN ps_cfg_field_group_field fgf ON fgf.id_field = f.id_field WHERE f.id_field IN (XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX)
2 queries	SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = XX AND `active` = XX AND cg.`id_group` =XX GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
2 queries	SELECT * FROM `ps_category` aXX LEFT JOIN `ps_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc
2 queries	SELECT COUNT(p.id_product) FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE p.id_product = XX AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
2 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
2 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
2 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
2 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
2 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
2 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
2 queries	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
2 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT location FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((pac.id_attribute 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	52	/override/controllers/front/listing/CategoryController.php:45 (__construct) [id: 157] /controllers/front/listing/CategoryController.php:78 (__construct) [id: 157] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 157] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 158] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 183] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 185] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 187] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 186] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 182] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 157] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 1] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 2] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 13] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 2] /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:179 (__construct) [id: 94] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 158] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 183] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 185] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 187] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 186] /controllers/front/listing/CategoryController.php:209 (__construct) [id: 182] /classes/Meta.php:380 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:379 (__construct) [id: 157] /modules/ps_facetedsearch/src/Filters/Block.php:197 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:107 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:113 (__construct) [id: 94] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 220] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 181] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 95] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 137] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 140] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 219] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 157] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 225] /override/modules/ps_categorytree/ps_categorytree.php:129 (__construct) [id: 156]
Feature	8	/modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 35] /modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 36] /modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 43] /modules/ps_facetedsearch/src/Filters/Converter.php:458 (__construct) [id: 44] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 35] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 36] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 43] /modules/ps_facetedsearch/src/Filters/Block.php:560 (__construct) [id: 44]
Product	8	/modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19591] /modules/customfieldgroups/src/Adapter/FieldGroupDataAdapter.php:202 (__construct) [id: 19590] /modules/tgf_carrierfee/src/Manager/FeeProductManager.php:38 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Manager/FeeProductManager.php:38 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Manager/FeeProductManager.php:38 (__construct) [id: 19588] /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) [id: 19588]
CMS	6	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 12] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 13] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 11] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 9] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 10] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 14]
Country	5	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1722 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Address	5	/classes/Product.php:741 (__construct) [id: ] /classes/Product.php:6830 (initialize) [id: ] /classes/Product.php:3794 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/shop/Shop.php:486 (__construct) [id: ]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:684 (getCurrencyInstance) [id: 1] /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:49 (__construct) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 3] /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`	9.551 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)
246	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 43 ORDER BY agl.`name` ASC, a.`position` ASC	8.949 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)
34	SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC	7.389 ms	2	Yes		/classes/Currency.php:711 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:282 (init) /controllers/front/listing/CategoryController.php:81 (init) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	SELECT SQL_NO_CACHE 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=1 AND g.enable=1	7.318 ms	71			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:612 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:155 (getFieldGroupsByEntityOptimized) /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)
247	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 44 ORDER BY agl.`name` ASC, a.`position` ASC	7.217 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)
199	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 2) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 28 ORDER BY vl.`value` ASC	6.699 ms	127	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Converter.php:487 (getFeatureValues) /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)
206	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 = 200 ORDER BY agl.`name` ASC, a.`position` ASC	6.603 ms	11	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)
78	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=157 AND v.id_field_group=32 AND v.id_shop=1 LIMIT 1	6.569 ms	1048			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:1120 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:165 (getFieldGroupValues) /modules/customfieldgroups/customfieldgroups.php:296 (getProperties) /classes/Hook.php:993 (__call) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /override/controllers/front/listing/CategoryController.php:76 (exec) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
10	SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 3) LIMIT 1	6.364 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /config/config.inc.php:211 (__construct) /index.php:27 (require)
205	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 119 ORDER BY agl.`name` ASC, a.`position` ASC	6.268 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)
140	SELECT SQL_NO_CACHE 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 = 1) WHERE p.id_product = 19590 AND DATEDIFF("2026-01-22 00:00:00", product_shop.`date_add`) < 20 LIMIT 1	5.912 ms	0			/classes/Product.php:1725 /classes/Product.php:743 (isNew) /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)
119	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	5.862 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)
91	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=1 AND v.id_field_group=290 AND v.id_shop=1 LIMIT 1	5.822 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)
255	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 = 52 ORDER BY agl.`name` ASC, a.`position` ASC	5.804 ms	35	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)
204	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	5.633 ms	166	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:498 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
307	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 107 ORDER BY agl.`name` ASC, a.`position` ASC	5.606 ms	112	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
370	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 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 = 170 ORDER BY agl.`name` ASC, a.`position` ASC	5.568 ms	25	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
57	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=157 AND v.id_field_group=26 AND v.id_shop=1 LIMIT 1	5.539 ms	1048			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:1120 /modules/customfieldgroups/src/Facade/DataRetrieverFacade.php:165 (getFieldGroupValues) /modules/customfieldgroups/customfieldgroups.php:296 (getProperties) /classes/Hook.php:993 (__call) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /controllers/front/listing/CategoryController.php:109 (exec) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
21	SELECT SQL_NO_CACHE 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` = 1	5.424 ms	94			/classes/module/Module.php:345 /modules/doofinder/doofinder.php:48 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1232 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1211 (coreLoadModule) /classes/Hook.php:913 (getInstanceByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
48	SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1	5.393 ms	1			/classes/ObjectModel.php:1728 /classes/Group.php:400 (isAssociatedToShop) /classes/Cart.php:249 (getCurrent) /classes/Cart.php:222 (setTaxCalculationMethod) /classes/controller/FrontController.php:427 (__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)
405	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (43007, 43273, 43430))) AND ((pac_1.id_attribute=45086)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=249 AND c.nright<=276 GROUP BY p.id_product) p 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_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature IN (28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 41, 42, 45, 46, 47))) AND ((pac_1.id_attribute IN (43007, 43273, 43430))) AND ((pac_2.id_attribute=45086)) GROUP BY fp.id_feature_value	5.341 ms	144	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:817 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:269 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:157 (getFeaturesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 19588) AND (b.`id_shop` = 1) LIMIT 1	5.257 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /modules/tgf_carrierfee/src/Provider/FeeProductProvider.php:27 (__construct) /modules/tgf_connector/tgf_connector.php:407 (get) /classes/Hook.php:993 (hookActionPresentCart) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /src/Adapter/Presenter/Cart/CartPresenter.php:491 (exec) /classes/controller/FrontController.php:501 (present) /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)
89	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=1 AND v.id_field_group=32 AND v.id_shop=1 LIMIT 1	5.254 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)
28	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	4.894 ms	126	Yes		/classes/Dispatcher.php:633 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
413	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("2afafa55495ef3f2f86a6ff1dde6429d", "a:1:{s:7:\"filters\";a:8:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:148;s:4:\"name\";s:11:\"Ø in. pipe\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43314;a:4:{s:4:\"name\";s:1:\"9\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:200;s:4:\"name\";s:5:\"REF.2\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:45086;a:5:{s:4:\"name\";s:8:\"ST 389 M\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:3;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:201;s:4:\"name\";s:9:\"Nut 3269U\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:58465;a:4:{s:4:\"name\";s:4:\"3/8\"\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:12:{s:9:\"type_lite\";s:8:\"tempmini\";s:4:\"type\";s:8:\"tempmini\";s:6:\"id_key\";i:35;s:4:\"name\";s:9:\"Temp mini\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:0;s:5:\"value\";N;}i:5;a:12:{s:9:\"type_lite\";s:8:\"tempmaxi\";s:4:\"type\";s:8:\"tempmaxi\";s:6:\"id_key\";i:36;s:4:\"name\";s:9:\"Temp maxi\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:0;s:5:\"value\";N;}i:6;a:12:{s:9:\"type_lite\";s:8:\"tempmini\";s:4:\"type\";s:8:\"tempmini\";s:6:\"id_key\";i:43;s:4:\"name\";s:8:\"T°C min\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:0;s:5:\"value\";N;}i:7;a:12:{s:9:\"type_lite\";s:8:\"tempmaxi\";s:4:\"type\";s:8:\"tempmaxi\";s:6:\"id_key\";i:44;s:4:\"name\";s:8:\"T°C max\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"°C\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"°C\";s:14:\"currencySymbol\";s:3:\"°C\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:11:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:12:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:0;s:5:\"value\";N;}}}")	4.887 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:496 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
317	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 117 ORDER BY agl.`name` ASC, a.`position` ASC	4.798 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)
260	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 = 60 ORDER BY agl.`name` ASC, a.`position` ASC	4.771 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)
70	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 187) AND (b.`id_shop` = 1) LIMIT 1	4.770 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:209 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:223 (array_map) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
408	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (43007, 43273, 43430))) AND ((pac_1.id_attribute=45086)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=249 AND c.nright<=276 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_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_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (43007, 43273, 43430))) AND ((pac_1.id_attribute=45086)) AND cg.id_group='1' AND c.level_depth<=5 AND c.nleft>249 AND c.nright<276 GROUP BY cp.id_category	4.651 ms	72	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:817 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:1407 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:198 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
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`)	4.553 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)
290	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	4.482 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)
24	SELECT SQL_NO_CACHE 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` = 1	4.469 ms	94			/classes/module/Module.php:345 /modules/ets_cfultimate/ets_cfultimate.php:78 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1227 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1211 (coreLoadModule) /classes/Hook.php:913 (getInstanceByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
7	SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)	4.405 ms	9			/classes/Language.php:1049 /config/config.inc.php:143 (loadLanguages) /index.php:27 (require)
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 = 79 ORDER BY agl.`name` ASC, a.`position` ASC	4.243 ms	39	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
109	SELECT SQL_NO_CACHE v.value FROM ps_cfg_field_value v WHERE v.id_entity=2 AND v.id_field_group=290 AND v.id_shop=1 LIMIT 1	4.218 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)
64	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 158) AND (b.`id_shop` = 1) LIMIT 1	4.153 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:209 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:223 (array_map) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /override/controllers/front/listing/CategoryController.php:48 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
173	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tgf_hreflang" LIMIT 1	4.151 ms	1			/classes/module/Module.php:2633 /classes/module/Module.php:2105 (getModuleIdByName) /override/classes/controller/FrontController.php:39 (isEnabled) /classes/controller/FrontController.php:1564 (getAlternativeLangsUrl) /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)
164	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tgf_carrierfee" LIMIT 1	4.139 ms	1			/classes/module/Module.php:2633 /classes/module/Module.php:2105 (getModuleIdByName) /modules/tgf_connector/tgf_connector.php:407 (isEnabled) /classes/Hook.php:993 (hookActionPresentCart) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /src/Adapter/Presenter/Cart/CartPresenter.php:491 (exec) /classes/controller/FrontController.php:501 (present) /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)
319	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 119 ORDER BY agl.`name` ASC, a.`position` ASC	4.029 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)
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 (454,462)	3.982 ms	20			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:878 /modules/customfieldgroups/src/Repository/FieldGroupRepository.php:924 (getRecursiveFieldGroups) /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)

#	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