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	781.566 ms
Querying Time	540 ms
Queries	519
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	8.085 ms	8.085 ms	2.43 Mb	2.7 Mb
__construct	0.016 ms	8.101 ms	- Mb	2.7 Mb
init	87.171 ms	95.272 ms	2.07 Mb	4.6 Mb
checkAccess	0.002 ms	95.274 ms	- Mb	4.6 Mb
setMedia	1.097 ms	96.371 ms	0.06 Mb	4.6 Mb
postProcess	0.001 ms	96.372 ms	- Mb	4.6 Mb
initHeader	0.001 ms	96.373 ms	- Mb	4.6 Mb
initContent	446.735 ms	543.108 ms	2.44 Mb	9.0 Mb
initFooter	0.002 ms	543.110 ms	- Mb	9.0 Mb
display	238.456 ms	781.566 ms	4.61 Mb	11.8 Mb

Hook	Time	Memory Usage
displayFooter	33.978 ms	0.80 Mb
=> ps_linklist (widget)	31.387 ms	0.75 Mb
=> customhtml (widget)	2.591 ms	0.05 Mb
renderWidget	15.767 ms	0.48 Mb
=> ps_categorytree (widget)	15.767 ms	0.48 Mb
DisplayHeader	15.568 ms	0.17 Mb
=> ps_shoppingcart	0.095 ms	- Mb
=> ps_searchbar	0.087 ms	- Mb
=> ps_imageslider	0.046 ms	- Mb
=> ps_googleanalytics	7.446 ms	0.12 Mb
=> customfieldgroups	7.155 ms	0.04 Mb
=> ets_cfultimate	0.339 ms	- Mb
=> ets_blog	0.400 ms	0.01 Mb
FilterCategoryContent	13.244 ms	0.30 Mb
=> customfieldgroups	10.026 ms	0.27 Mb
=> customfieldgroups	3.218 ms	0.03 Mb
displayNavFullWidth	12.623 ms	0.83 Mb
=> customhtml (widget)	1.900 ms	0.03 Mb
=> ps_mainmenu (widget)	10.723 ms	0.80 Mb
displayNav2	10.367 ms	0.16 Mb
=> ps_contactinfo (widget)	1.990 ms	0.07 Mb
=> ps_languageselector (widget)	4.992 ms	0.06 Mb
=> customhtml (widget)	3.385 ms	0.03 Mb
DisplayFooterBefore	10.271 ms	0.28 Mb
=> customfieldgroups	0.755 ms	0.03 Mb
=> tgf_global_reassurance	9.510 ms	0.25 Mb
=> ets_blog	0.006 ms	- Mb
displaySearch	8.289 ms	0.11 Mb
=> ps_searchbar (widget)	1.335 ms	0.05 Mb
=> customhtml (widget)	2.898 ms	0.03 Mb
=> ps_searchbar (widget)	0.919 ms	0.01 Mb
=> customhtml (widget)	3.137 ms	0.03 Mb
DisplayBeforeBodyClosingTag	6.998 ms	0.05 Mb
=> ps_googleanalytics	2.109 ms	0.02 Mb
=> customfieldgroups	4.889 ms	0.02 Mb
displayFooterLeft	5.842 ms	0.11 Mb
=> ps_emailsubscription (widget)	2.716 ms	0.06 Mb
=> ps_socialfollow (widget)	3.126 ms	0.05 Mb
displayLeftColumn	4.669 ms	0.03 Mb
=> customhtml (widget)	4.669 ms	0.03 Mb
displayTop	4.617 ms	0.08 Mb
=> customhtml (widget)	2.101 ms	0.03 Mb
=> ps_shoppingcart (widget)	2.516 ms	0.05 Mb
DisplayFooterAfter	4.319 ms	0.03 Mb
=> customfieldgroups	4.319 ms	0.03 Mb
DisplayFooter	4.317 ms	0.05 Mb
=> customfieldgroups	3.315 ms	0.03 Mb
=> ets_cfultimate	1.002 ms	0.02 Mb
displayFooterBefore	4.130 ms	0.07 Mb
=> customhtml (widget)	3.251 ms	0.03 Mb
=> productdata (widget)	0.879 ms	0.04 Mb
displayWrapperTop	3.922 ms	0.02 Mb
=> customhtml (widget)	3.922 ms	0.02 Mb
ActionFrontControllerSetVariables	3.886 ms	0.06 Mb
=> customfieldgroups	0.005 ms	- Mb
=> tgf_wishlist	0.022 ms	- Mb
=> tgf_connector	0.004 ms	- Mb
=> tgf_carrier_extender	3.855 ms	0.06 Mb
DisplayTop	3.378 ms	0.06 Mb
=> tgf_fastorder	2.769 ms	0.03 Mb
=> customfieldgroups	0.598 ms	0.03 Mb
=> ets_cfultimate	0.011 ms	- Mb
displayNav1	3.354 ms	0.16 Mb
=> customhtml (widget)	3.354 ms	0.16 Mb
DisplayNav1	3.154 ms	0.03 Mb
=> customfieldgroups	3.154 ms	0.03 Mb
ActionPresentCart	3.046 ms	0.17 Mb
=> tgf_customcart	0.049 ms	- Mb
=> tgf_connector	2.997 ms	0.17 Mb
DisplayLeftColumn	2.778 ms	0.03 Mb
=> ps_facetedsearch	2.062 ms	0.01 Mb
=> customfieldgroups	0.700 ms	0.02 Mb
=> ets_cfultimate	0.012 ms	- Mb
=> ets_blog	0.004 ms	- Mb
DisplaySearch	1.728 ms	0.05 Mb
=> customfieldgroups	0.584 ms	0.03 Mb
=> customfieldgroups	1.144 ms	0.03 Mb
displayFooterAfter	1.721 ms	0.03 Mb
=> customhtml (widget)	1.721 ms	0.03 Mb
Header	1.593 ms	0.09 Mb
=> doofinder	1.541 ms	0.09 Mb
=> tgf_devis	0.052 ms	- Mb
DisplayBanner	1.396 ms	0.02 Mb
=> customfieldgroups	1.396 ms	0.02 Mb
DisplayNavFullWidth	1.169 ms	0.03 Mb
=> customfieldgroups	1.169 ms	0.03 Mb
DisplayFooterCategory	0.976 ms	0.02 Mb
=> customfieldgroups	0.976 ms	0.02 Mb
DisplayAfterBodyOpeningTag	0.950 ms	0.02 Mb
=> customfieldgroups	0.950 ms	0.02 Mb
DisplayNotFound	0.847 ms	0.03 Mb
=> customfieldgroups	0.847 ms	0.03 Mb
DisplayWrapperTop	0.836 ms	0.02 Mb
=> customfieldgroups	0.836 ms	0.02 Mb
DisplayNav2	0.625 ms	0.03 Mb
=> customfieldgroups	0.610 ms	0.03 Mb
=> ets_cfultimate	0.015 ms	- Mb
DisplayContentWrapperBottom	0.518 ms	0.02 Mb
=> customfieldgroups	0.518 ms	0.02 Mb
DisplayContentWrapperTop	0.502 ms	0.02 Mb
=> customfieldgroups	0.502 ms	0.02 Mb
DisplayWrapperBottom	0.435 ms	0.02 Mb
=> tgf_fastorder	0.011 ms	- Mb
=> customfieldgroups	0.422 ms	0.02 Mb
=> tgf_wishlist	0.002 ms	- Mb
DisplayHeaderCategory	0.407 ms	0.02 Mb
=> customfieldgroups	0.407 ms	0.02 Mb
ActionFrontControllerSetMedia	0.289 ms	0.01 Mb
=> ps_emailsubscription	0.145 ms	- Mb
=> ps_socialfollow	0.044 ms	- Mb
=> ps_emailalerts	0.037 ms	- Mb
=> combinationtable	0.016 ms	- Mb
=> productdata	0.001 ms	- Mb
=> customfieldgroups	0.025 ms	- Mb
=> tgf_global_reassurance	0.021 ms	- Mb
FilterProductSearch	0.222 ms	- Mb
=> customfieldgroups	0.222 ms	- Mb
ProductSearchProvider	0.198 ms	- Mb
=> ps_facetedsearch	0.198 ms	- Mb
ModuleRoutes	0.037 ms	0.01 Mb
=> doofinder	0.006 ms	- Mb
=> tgf_wishlist	0.002 ms	- Mb
=> ets_cfultimate	0.020 ms	- Mb
=> ets_blog	0.009 ms	0.01 Mb
ActionOutputHTMLBefore	0.020 ms	- Mb
=> ets_cfultimate	0.020 ms	- Mb
ActionDispatcherBefore	0.004 ms	- Mb
=> etsloginascustomer	0.004 ms	- Mb
ActionDispatcher	0.003 ms	- Mb
=> tgf_redirection	0.003 ms	- Mb
43 hook(s)	192.993 ms	4.50 Mb

Module	Time	Memory Usage
doofinder	2.940 ms	0.08 Mb
__construct	1.385 ms	- Mb
hookModuleRoutes	0.010 ms	- Mb
hookHeader	1.545 ms	0.09 Mb
tgf_wishlist	1.017 ms	0.02 Mb
__construct	0.987 ms	0.01 Mb
hookModuleRoutes	0.004 ms	- Mb
hookActionFrontControllerSetVariables	0.023 ms	- Mb
hookDisplayWrapperBottom	0.003 ms	- Mb
ets_cfultimate	3.024 ms	0.05 Mb
__construct	1.592 ms	0.01 Mb
hookModuleRoutes	0.022 ms	- Mb
hookDisplayHeader	0.342 ms	0.01 Mb
hookDisplayNav2	0.016 ms	- Mb
hookDisplayTop	0.012 ms	- Mb
hookDisplayLeftColumn	0.013 ms	- Mb
hookDisplayFooter	1.006 ms	0.02 Mb
hookActionOutputHTMLBefore	0.021 ms	- Mb
ets_blog	1.323 ms	0.04 Mb
__construct	0.898 ms	0.03 Mb
hookModuleRoutes	0.011 ms	0.01 Mb
hookDisplayHeader	0.402 ms	0.01 Mb
hookDisplayLeftColumn	0.005 ms	- Mb
hookDisplayFooterBefore	0.007 ms	- Mb
etsloginascustomer	0.576 ms	0.02 Mb
__construct	0.569 ms	0.01 Mb
hookActionDispatcherBefore	0.007 ms	- Mb
tgf_redirection	1.317 ms	0.06 Mb
__construct	1.312 ms	0.06 Mb
hookActionDispatcher	0.005 ms	- Mb
customfieldgroups	48.943 ms	0.84 Mb
__construct	0.108 ms	0.01 Mb
hookFilterCategoryContent	10.030 ms	0.27 Mb
hookFilterCategoryContent	3.222 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.026 ms	- Mb
hookActionFrontControllerSetVariables	0.007 ms	- Mb
hookDisplayHeader	7.159 ms	0.04 Mb
hookFilterProductSearch	0.225 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.955 ms	0.02 Mb
hookDisplayBanner	1.399 ms	0.02 Mb
hookDisplayNav1	3.158 ms	0.03 Mb
hookDisplayNav2	0.613 ms	0.03 Mb
hookDisplaySearch	0.586 ms	0.03 Mb
hookDisplayTop	0.601 ms	0.03 Mb
hookDisplayNavFullWidth	1.173 ms	0.03 Mb
hookDisplayWrapperTop	0.840 ms	0.02 Mb
hookDisplayLeftColumn	0.704 ms	0.02 Mb
hookDisplayContentWrapperTop	0.506 ms	0.02 Mb
hookDisplayHeaderCategory	0.409 ms	0.02 Mb
hookDisplaySearch	1.150 ms	0.03 Mb
hookDisplayNotFound	0.850 ms	0.03 Mb
hookDisplayFooterCategory	0.981 ms	0.02 Mb
hookDisplayContentWrapperBottom	0.521 ms	0.02 Mb
hookDisplayWrapperBottom	0.424 ms	0.02 Mb
hookDisplayFooterBefore	0.759 ms	0.03 Mb
hookDisplayFooter	3.322 ms	0.03 Mb
hookDisplayFooterAfter	4.323 ms	0.03 Mb
hookDisplayBeforeBodyClosingTag	4.892 ms	0.02 Mb
ps_emailsubscription	2.993 ms	0.07 Mb
__construct	0.126 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.148 ms	- Mb
displayFooterLeft	2.719 ms	0.06 Mb
ps_socialfollow	3.260 ms	0.06 Mb
__construct	0.084 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.046 ms	- Mb
displayFooterLeft	3.130 ms	0.05 Mb
ps_emailalerts	0.136 ms	0.01 Mb
__construct	0.098 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.038 ms	- Mb
combinationtable	0.078 ms	0.01 Mb
__construct	0.061 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.017 ms	- Mb
productdata	0.929 ms	0.05 Mb
__construct	0.045 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.002 ms	- Mb
displayFooterBefore	0.882 ms	0.04 Mb
tgf_global_reassurance	9.586 ms	0.25 Mb
__construct	0.050 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.022 ms	- Mb
hookDisplayFooterBefore	9.514 ms	0.25 Mb
tgf_customcart	0.158 ms	0.01 Mb
__construct	0.106 ms	0.01 Mb
hookActionPresentCart	0.052 ms	- Mb
tgf_connector	3.091 ms	0.18 Mb
__construct	0.086 ms	0.01 Mb
hookActionPresentCart	3.001 ms	0.17 Mb
hookActionFrontControllerSetVariables	0.004 ms	- Mb
tgf_carrier_extender	3.958 ms	0.06 Mb
__construct	0.099 ms	0.01 Mb
hookActionFrontControllerSetVariables	3.859 ms	0.06 Mb
tgf_technical_information	0.096 ms	0.01 Mb
__construct	0.096 ms	0.01 Mb
ps_shoppingcart	2.673 ms	0.05 Mb
__construct	0.057 ms	0.01 Mb
hookDisplayHeader	0.097 ms	- Mb
displayTop	2.519 ms	0.05 Mb
ps_searchbar	2.400 ms	0.06 Mb
__construct	0.040 ms	0.01 Mb
hookDisplayHeader	0.098 ms	- Mb
displaySearch	1.338 ms	0.05 Mb
displaySearch	0.924 ms	0.01 Mb
ps_imageslider	0.098 ms	0.01 Mb
__construct	0.051 ms	0.01 Mb
hookDisplayHeader	0.047 ms	- Mb
ps_googleanalytics	9.609 ms	0.15 Mb
__construct	0.046 ms	0.01 Mb
hookDisplayHeader	7.450 ms	0.12 Mb
hookDisplayBeforeBodyClosingTag	2.113 ms	0.02 Mb
ps_featuredproducts	0.059 ms	- Mb
__construct	0.059 ms	- Mb
tgf_devis	0.163 ms	0.01 Mb
__construct	0.109 ms	0.01 Mb
hookHeader	0.054 ms	- Mb
ps_facetedsearch	2.462 ms	0.02 Mb
__construct	0.196 ms	0.01 Mb
hookProductSearchProvider	0.200 ms	- Mb
hookDisplayLeftColumn	2.066 ms	0.01 Mb
customhtml	33.122 ms	0.49 Mb
__construct	0.153 ms	0.02 Mb
displayNav1	3.357 ms	0.16 Mb
displayNav2	3.389 ms	0.03 Mb
displaySearch	2.903 ms	0.03 Mb
displayTop	2.105 ms	0.03 Mb
displayNavFullWidth	1.903 ms	0.03 Mb
displayWrapperTop	3.925 ms	0.03 Mb
displayLeftColumn	4.673 ms	0.03 Mb
displaySearch	3.142 ms	0.03 Mb
displayFooterBefore	3.254 ms	0.03 Mb
displayFooter	2.594 ms	0.05 Mb
displayFooterAfter	1.725 ms	0.03 Mb
ps_contactinfo	2.090 ms	0.08 Mb
__construct	0.096 ms	0.01 Mb
displayNav2	1.994 ms	0.07 Mb
ps_languageselector	5.109 ms	0.07 Mb
__construct	0.112 ms	0.01 Mb
displayNav2	4.997 ms	0.06 Mb
tgf_fastorder	4.270 ms	0.08 Mb
__construct	1.485 ms	0.05 Mb
hookDisplayTop	2.773 ms	0.03 Mb
hookDisplayWrapperBottom	0.012 ms	- Mb
ps_mainmenu	10.830 ms	0.81 Mb
__construct	0.101 ms	0.01 Mb
displayNavFullWidth	10.729 ms	0.80 Mb
ps_categorytree	15.870 ms	0.48 Mb
__construct	0.099 ms	0.01 Mb
renderWidget	15.771 ms	0.48 Mb
ps_linklist	31.640 ms	0.76 Mb
__construct	0.250 ms	0.01 Mb
displayFooter	31.390 ms	0.75 Mb
31 module(s)	203.820 ms	4.88 Mb

Compressed air and quick couplings

No products available yet

Stopwatch SQL - 519 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_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 v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT tmai.tempmini_min, MIN(tempmini_min) as min, MAX(tempmini_max) as max FROM ps_product p INNER JOIN ps_layered_temperature_index tmai ON (tmai.id_product = p.id_product AND tmai.id_shop = XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX
2 queries	SELECT tmai.tempmaxi_min, MIN(tempmaxi_min) as min, MAX(tempmaxi_max) as max FROM ps_product p INNER JOIN ps_layered_temperature_index tmai ON (tmai.id_product = p.id_product AND tmai.id_shop = XX) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX
2 queries	SELECT * FROM ps_customhtmlblock AS psb LEFT JOIN ps_customhtmlblock_lang AS psl ON psb.id_customhtmlblock = psl.id_customhtmlblock LEFT JOIN ps_customhtmlblock_shop AS pss ON psb.id_customhtmlblock = pss.id_customhtmlblock WHERE id_shop =XX AND id_lang =XX AND `hook_position` = "displayNavXX" AND `showhook` = XX ORDER BY `position` ASC
2 queries	SELECT l., s., g.* FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_position p ON p.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_lang l ON l.id_field_group = g.id_field_group AND l.id_lang=XX WHERE p.position="displayNavXX" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT * FROM ps_customhtmlblock AS psb LEFT JOIN ps_customhtmlblock_lang AS psl ON psb.id_customhtmlblock = psl.id_customhtmlblock LEFT JOIN ps_customhtmlblock_shop AS pss ON psb.id_customhtmlblock = pss.id_customhtmlblock WHERE id_shop =XX AND id_lang =XX AND `hook_position` = "displaySearch" AND `showhook` = XX ORDER BY `position` ASC
2 queries	SELECT l., s., g.* FROM ps_cfg_field_group g LEFT JOIN ps_cfg_field_group_shop s ON s.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_position p ON p.id_field_group = g.id_field_group LEFT JOIN ps_cfg_field_group_lang l ON l.id_field_group = g.id_field_group AND l.id_lang=XX WHERE p.position="displaySearch" AND s.id_shop=XX AND g.enable=XX
2 queries	SELECT * FROM `ps_link_block` a LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_link_block_lang` WHERE `id_link_block` = XX

Name	Instances	Source
Category	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: 2] /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
404	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=123)) AND ((pac_1.id_attribute=43432)) AND ((pac_2.id_attribute=43322)) 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((fp.id_feature IN (28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 41, 42, 45, 46, 47))) AND ((fp_1.id_feature_value=123)) AND ((pac_2.id_attribute=43432)) AND ((pac_3.id_attribute=43322)) GROUP BY fp.id_feature_value	8.347 ms	2592	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:817 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:269 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:157 (getFeaturesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
204	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	7.987 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)
412	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("dc473bc7ad1cf082915dfcc82388bd4b", "a:1:{s:7:\"filters\";a:9:{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:82;s:4:\"name\";s:2:\"DN\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43323;a:4:{s:4:\"name\";s:2:\"14\";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:146;s:4:\"name\";s:11:\"Male thread\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:58141;a:4:{s:4:\"name\";s:5:\"G1/2\"\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i: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:148;s:4:\"name\";s:11:\"Ø in. pipe\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43280;a:4:{s:4:\"name\";s:2:\"19\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:158;s:4:\"name\";s:4:\"REF.\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:43322;a:5:{s:4:\"name\";s:6:\"G12 19\";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:5;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:6;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:7;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:8;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;}}}")	7.054 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)
245	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.760 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)
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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=123)) AND ((pac_1.id_attribute=43432)) AND ((pac_2.id_attribute=43322)) 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_3 ON (pa.id_product_attribute = pac_3.id_product_attribute) WHERE ((fp.id_feature IN (28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 41, 42, 45, 46, 47))) AND ((fp_1.id_feature_value=123)) AND ((pac_2.id_attribute=43432)) AND ((pac_3.id_attribute=43322)) GROUP BY fp.id_feature_value	5.394 ms	2592	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Filters/Block.php:292 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:157 (getFeaturesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
392	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 = 193 ORDER BY agl.`name` ASC, a.`position` ASC	5.238 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)
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 = 120 ORDER BY agl.`name` ASC, a.`position` ASC	4.944 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)
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 = 44 ORDER BY agl.`name` ASC, a.`position` ASC	4.819 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)
305	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 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 = 106 ORDER BY agl.`name` ASC, a.`position` ASC	4.675 ms	109	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
326	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.656 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)
407	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=123)) AND ((pac_1.id_attribute=43432)) AND ((pac_2.id_attribute=43322)) 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=123)) AND ((pac_1.id_attribute=43432)) AND ((pac_2.id_attribute=43322)) AND cg.id_group='1' AND c.level_depth<=5 AND c.nleft>249 AND c.nright<276 GROUP BY cp.id_category	4.500 ms	1296	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:817 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:1407 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:198 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	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`	4.373 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)
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 = 171 ORDER BY agl.`name` ASC, a.`position` ASC	4.298 ms	4	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)
318	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 119 ORDER BY agl.`name` ASC, a.`position` ASC	4.252 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)
403	SELECT SQL_NO_CACHE pac.id_attribute, a.id_attribute_group, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=123)) AND ((pac_1.id_attribute=43322)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=249 AND c.nright<=276 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group IN (1, 3, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 204, 205))) AND ((fp_1.id_feature_value=123)) AND ((pac_2.id_attribute=43322)) GROUP BY pac.id_attribute, a.id_attribute_group	4.157 ms	864	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Filters/Block.php:395 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
516	SELECT SQL_NO_CACHE 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=2 WHERE p.position="displayFooterAfter" AND s.id_shop=1 AND g.enable=1	4.038 ms	1			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:544 /modules/customfieldgroups/src/Model/Position.php:176 (getFieldGroupsByDisplayPosition) /modules/customfieldgroups/src/Model/Position.php:153 (getPositionFieldGroups) /modules/customfieldgroups/customfieldgroups.php:341 (processHook) /classes/Hook.php:993 (__call) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:153 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:42 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6972189a1a4689_41343542) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:359 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:115 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899ec6d11_77443835) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/30/53/c9/3053c9fd35549c2882db7838903f724d47a629c4_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eb7a98_34404652) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/37/0a/8b/370a8ba1684a4bd91de1cb83cec606d1f214cc54_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eab1f8_87324761) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/4e/83/4d/4e834dafa5c5de9b4ec41435ac89dd2186d8f8a8_2.file.category.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899e8fa76_26234567) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
153	SELECT SQL_NO_CACHE * FROM `ps_category_lang` WHERE `id_category` = 94 AND `id_shop` = 1	3.946 ms	3			/src/Adapter/EntityMapper.php:79 /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)
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 = 109 ORDER BY agl.`name` ASC, a.`position` ASC	3.851 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)
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 = 126 ORDER BY agl.`name` ASC, a.`position` ASC	3.834 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)
196	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 2) ORDER BY f.`position` ASC	3.786 ms	24	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:473 (getFeatures) /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)
311	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.772 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)
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 = 117 ORDER BY agl.`name` ASC, a.`position` ASC	3.766 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)
347	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 = 148 ORDER BY agl.`name` ASC, a.`position` ASC	3.686 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)
289	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.602 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)
411	SELECT SQL_NO_CACHE 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 = 1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature_value=123)) AND ((pac_1.id_attribute=43432)) AND ((pac_2.id_attribute=43322)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=249 AND c.nright<=276	3.601 ms	18			/modules/ps_facetedsearch/src/Adapter/MySQL.php:100 /modules/ps_facetedsearch/src/Adapter/MySQL.php:72 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:621 (getMinMaxTemperatureValue) /modules/ps_facetedsearch/src/Filters/Block.php:190 (getTemperatureRangeBlock) /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)
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 = 108 ORDER BY agl.`name` ASC, a.`position` ASC	3.488 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)
267	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 = 68 ORDER BY agl.`name` ASC, a.`position` ASC	3.403 ms	94	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
161	SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1	3.399 ms	1			/classes/Cart.php:4191 /classes/Cart.php:4166 (hasProducts) /classes/Cart.php:2117 (isVirtualCart) /src/Adapter/Presenter/Cart/CartPresenter.php:333 (getOrderTotal) /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)
171	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tgf_hreflang" LIMIT 1	3.316 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)
323	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 = 124 ORDER BY agl.`name` ASC, a.`position` ASC	3.291 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)
511	SELECT SQL_NO_CACHE * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "sitemap" OR m.page = "sitemap" ) AND ml.id_lang = 2 AND ml.id_shop = 1 LIMIT 1	3.279 ms	1			/classes/Meta.php:193 /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:192 (getMetaByPage) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:108 (makeStaticLinks) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:66 (makeLinks) /modules/ps_linklist/ps_linklist.php:291 (present) /modules/ps_linklist/ps_linklist.php:277 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:134 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6972189a1a4689_41343542) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:359 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:115 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899ec6d11_77443835) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/30/53/c9/3053c9fd35549c2882db7838903f724d47a629c4_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eb7a98_34404652) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/37/0a/8b/370a8ba1684a4bd91de1cb83cec606d1f214cc54_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eab1f8_87324761) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/4e/83/4d/4e834dafa5c5de9b4ec41435ac89dd2186d8f8a8_2.file.category.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899e8fa76_26234567) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
333	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 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 = 134 ORDER BY agl.`name` ASC, a.`position` ASC	3.264 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)
303	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 = 104 ORDER BY agl.`name` ASC, a.`position` ASC	3.180 ms	8	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
252	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 = 50 ORDER BY agl.`name` ASC, a.`position` ASC	3.175 ms	86	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
377	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 = 178 ORDER BY agl.`name` ASC, a.`position` ASC	3.169 ms	46	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:373 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:156 (getAttributesBlocks) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
501	SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 13) LIMIT 1	3.149 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:100 (makeCmsLinks) /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:66 (makeLinks) /modules/ps_linklist/ps_linklist.php:291 (present) /modules/ps_linklist/ps_linklist.php:277 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:134 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6972189a1a4689_41343542) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:359 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:115 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899ec6d11_77443835) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/30/53/c9/3053c9fd35549c2882db7838903f724d47a629c4_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eb7a98_34404652) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/37/0a/8b/370a8ba1684a4bd91de1cb83cec606d1f214cc54_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eab1f8_87324761) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/4e/83/4d/4e834dafa5c5de9b4ec41435ac89dd2186d8f8a8_2.file.category.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899e8fa76_26234567) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
365	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 = 166 ORDER BY agl.`name` ASC, a.`position` ASC	3.122 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)
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 = 118 ORDER BY agl.`name` ASC, a.`position` ASC	3.091 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)
350	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 = 151 ORDER BY agl.`name` ASC, a.`position` ASC	3.085 ms	15	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)
513	SELECT SQL_NO_CACHE 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=2 WHERE p.position="displayFooter" AND s.id_shop=1 AND g.enable=1	3.016 ms	1			/modules/customfieldgroups/src/Repository/FieldGroupRepository.php:544 /modules/customfieldgroups/src/Model/Position.php:176 (getFieldGroupsByDisplayPosition) /modules/customfieldgroups/src/Model/Position.php:153 (getPositionFieldGroups) /modules/customfieldgroups/customfieldgroups.php:341 (processHook) /classes/Hook.php:993 (__call) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /config/smarty.config.inc.php:205 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:134 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/d9/b0/c2/d9b0c2508385fa3f0f2959899be551d5ff858a4d_2.file.footer.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6972189a1a4689_41343542) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:359 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/35/67/87/356787b3c603d884480b5547c287bd0e0f107483_2.file.layout-both-columns.tpl.php:115 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899ec6d11_77443835) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/30/53/c9/3053c9fd35549c2882db7838903f724d47a629c4_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eb7a98_34404652) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/37/0a/8b/370a8ba1684a4bd91de1cb83cec606d1f214cc54_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899eab1f8_87324761) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/prod/smarty/compile/coditallayouts_layout_left_column_tpl/4e/83/4d/4e834dafa5c5de9b4ec41435ac89dd2186d8f8a8_2.file.category.tpl.php:53 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69721899e8fa76_26234567) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /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