Load Time	1436 ms
Querying Time	167 ms
Queries	124
Memory Peak Usage	44.9 Mb
Included Files	1024 files - 10.48 Mb
PrestaShop Cache	1.22 Mb
Global vars	0.36 Mb
- global $_MODULES	234k
- global $context	93k
- global $__composer_autoload_files	14k
- global $_SERVER	13k
- global $exportPhpConfigFile	4k
- global $config	3k
- global $_MODULE	3k
- global $_COOKIE	1k

PrestaShop Version	1.7.8.10
PHP Version	7.4.9
MySQL Version	11.6.2-MariaDB
Memory Limit	1024M
Max Execution Time	0s
Smarty Cache	enabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	50 ms	50 ms	15.33 Mb	16.6 Mb
__construct	0 ms	50 ms	- Mb	16.6 Mb
init	393 ms	443 ms	8.45 Mb	24.4 Mb
checkAccess	0 ms	443 ms	- Mb	24.4 Mb
setMedia	14 ms	457 ms	0.94 Mb	24.9 Mb
postProcess	0 ms	457 ms	- Mb	24.9 Mb
initHeader	0 ms	457 ms	- Mb	24.9 Mb
initContent	487 ms	945 ms	15.63 Mb	40.4 Mb
initFooter	0 ms	945 ms	- Mb	40.4 Mb
display	491 ms	1436 ms	4.34 Mb	44.9 Mb

Hook	Time	Memory Usage
Header	71 ms	2.26 Mb
=> paypal	53 ms	2.07 Mb
=> eicaptcha	0 ms	- Mb
=> doofinder	7 ms	0.02 Mb
=> advanceseo	11 ms	0.17 Mb
displayTop	54 ms	0.21 Mb
=> ps_searchbar (widget)	8 ms	0.05 Mb
=> ps_customersignin (widget)	8 ms	0.06 Mb
=> ps_shoppingcart (widget)	37 ms	0.09 Mb
displayLeftColumn	50 ms	0.86 Mb
=> ps_categorytree (widget)	50 ms	0.86 Mb
DisplayHeader	36 ms	0.72 Mb
=> ps_searchbar	2 ms	0.29 Mb
=> emarketing	6 ms	0.06 Mb
=> seoexpert	0 ms	- Mb
=> ps_googleanalytics	16 ms	0.07 Mb
=> htmlboxpro	0 ms	- Mb
=> mailchimppro	0 ms	- Mb
=> netreviews	1 ms	0.14 Mb
=> zonecolorsfonts	7 ms	0.09 Mb
=> zonethememanager	3 ms	0.04 Mb
=> ps_shoppingcart	1 ms	0.03 Mb
displayFooterRight	33 ms	0.42 Mb
=> ps_emailsubscription (widget)	33 ms	0.42 Mb
DisplayTop	15 ms	0.04 Mb
=> advanceseo	13 ms	0.04 Mb
=> pagesnotfound	2 ms	0.01 Mb
DisplayBeforeBodyClosingTag	15 ms	0.19 Mb
=> statsdata	3 ms	0.08 Mb
=> htmlboxpro	0 ms	- Mb
=> ps_googleanalytics	12 ms	0.11 Mb
ProductSearchProvider	11 ms	0.60 Mb
=> ps_facetedsearch	11 ms	0.60 Mb
DisplayGDPRConsent	11 ms	0.11 Mb
=> psgdpr	11 ms	0.11 Mb
DisplayLeftColumn	10 ms	0.02 Mb
=> ps_facetedsearch	6 ms	- Mb
=> zonecolumnblocks	4 ms	0.02 Mb
=> doofinder	0 ms	- Mb
DisplayOutsideMainPage	8 ms	0.05 Mb
=> zonepopupnewsletter	3 ms	0.02 Mb
=> zonecolorsfonts	3 ms	0.02 Mb
=> zonethememanager	3 ms	0.02 Mb
DisplayNewsletterRegistration	8 ms	0.02 Mb
=> eicaptcha	8 ms	0.02 Mb
DisplayNavFullWidth	8 ms	0.07 Mb
=> zonemegamenu	3 ms	0.02 Mb
=> paypal	4 ms	0.05 Mb
displaySearch	6 ms	0.01 Mb
=> ps_searchbar (widget)	6 ms	0.01 Mb
ActionFrontControllerSetMedia	4 ms	0.32 Mb
=> blockreassurance	3 ms	0.22 Mb
=> ps_emailsubscription	0 ms	0.03 Mb
=> ps_socialfollow	1 ms	0.07 Mb
DisplaySidebarNavigation	4 ms	0.02 Mb
=> zonethememanager	4 ms	0.02 Mb
DisplayFooterLeft	3 ms	0.02 Mb
=> zonethememanager	3 ms	0.02 Mb
DisplayFooterRight	3 ms	0.02 Mb
=> zonethememanager	3 ms	0.02 Mb
DisplayBanner	3 ms	0.02 Mb
=> zonethememanager	3 ms	0.02 Mb
displayFooterLeft	3 ms	0.06 Mb
=> ps_socialfollow (widget)	3 ms	0.06 Mb
DisplayNav1	3 ms	0.02 Mb
=> zonethememanager	3 ms	0.02 Mb
DisplayFooterAfter	2 ms	0.02 Mb
=> zonethememanager	2 ms	0.02 Mb
ActionFrontControllerSetVariables	2 ms	0.07 Mb
=> zonethememanager	2 ms	0.07 Mb
displayNav2	1 ms	0.10 Mb
=> ps_languageselector (widget)	1 ms	0.05 Mb
=> ps_currencyselector (widget)	1 ms	0.04 Mb
FilterCategoryContent	1 ms	- Mb
=> advanceseo	1 ms	- Mb
ActionDispatcherBefore	0 ms	- Mb
=> ps_mbo	0 ms	- Mb
ModuleRoutes	0 ms	- Mb
=> mailchimppro	0 ms	- Mb
DisplayFooter	0 ms	- Mb
=> doofinder	0 ms	- Mb
28 hook(s)	365 ms	6.23 Mb

Module	Time	Memory Usage
mailchimppro	12 ms	0.26 Mb
__construct	12 ms	0.26 Mb
hookModuleRoutes	0 ms	- Mb
hookDisplayHeader	0 ms	- Mb
ps_mbo	37 ms	2.50 Mb
__construct	37 ms	2.49 Mb
hookActionDispatcherBefore	0 ms	- Mb
advanceseo	31 ms	0.65 Mb
__construct	7 ms	0.44 Mb
hookFilterCategoryContent	1 ms	- Mb
hookHeader	11 ms	0.17 Mb
hookDisplayTop	13 ms	0.04 Mb
blockreassurance	6 ms	0.32 Mb
__construct	3 ms	0.10 Mb
hookActionFrontControllerSetMedia	3 ms	0.22 Mb
ps_emailsubscription	37 ms	0.67 Mb
__construct	3 ms	0.22 Mb
hookActionFrontControllerSetMedia	0 ms	0.03 Mb
displayFooterRight	33 ms	0.42 Mb
ps_socialfollow	5 ms	0.20 Mb
__construct	1 ms	0.06 Mb
hookActionFrontControllerSetMedia	1 ms	0.07 Mb
displayFooterLeft	3 ms	0.06 Mb
zonethememanager	42 ms	1.41 Mb
__construct	16 ms	1.17 Mb
hookActionFrontControllerSetVariables	2 ms	0.07 Mb
hookDisplayHeader	3 ms	0.04 Mb
hookDisplaySidebarNavigation	4 ms	0.02 Mb
hookDisplayBanner	3 ms	0.02 Mb
hookDisplayNav1	3 ms	0.02 Mb
hookDisplayFooterLeft	3 ms	0.02 Mb
hookDisplayFooterRight	3 ms	0.03 Mb
hookDisplayFooterAfter	2 ms	0.02 Mb
hookDisplayOutsideMainPage	3 ms	0.02 Mb
paypal	82 ms	3.11 Mb
__construct	25 ms	0.99 Mb
hookHeader	53 ms	2.07 Mb
hookDisplayNavFullWidth	4 ms	0.05 Mb
ps_searchbar	17 ms	0.38 Mb
__construct	1 ms	0.03 Mb
hookDisplayHeader	2 ms	0.29 Mb
displayTop	8 ms	0.06 Mb
displaySearch	6 ms	0.01 Mb
emarketing	7 ms	0.09 Mb
__construct	1 ms	0.04 Mb
hookDisplayHeader	6 ms	0.06 Mb
seoexpert	15 ms	3.09 Mb
__construct	15 ms	3.09 Mb
hookDisplayHeader	0 ms	- Mb
ps_googleanalytics	30 ms	0.23 Mb
__construct	2 ms	0.05 Mb
hookDisplayHeader	16 ms	0.07 Mb
hookDisplayBeforeBodyClosingTag	12 ms	0.11 Mb
htmlboxpro	8 ms	0.44 Mb
__construct	8 ms	0.43 Mb
hookDisplayHeader	0 ms	- Mb
hookDisplayBeforeBodyClosingTag	0 ms	- Mb
netreviews	13 ms	0.74 Mb
__construct	11 ms	0.59 Mb
hookDisplayHeader	1 ms	0.14 Mb
zonecolorsfonts	14 ms	0.29 Mb
__construct	4 ms	0.19 Mb
hookDisplayHeader	7 ms	0.09 Mb
hookDisplayOutsideMainPage	3 ms	0.02 Mb
eicaptcha	10 ms	0.12 Mb
__construct	2 ms	0.10 Mb
hookHeader	0 ms	- Mb
hookDisplayNewsletterRegistration	8 ms	0.02 Mb
doofinder	20 ms	0.64 Mb
__construct	13 ms	0.62 Mb
hookHeader	7 ms	0.02 Mb
hookDisplayLeftColumn	0 ms	- Mb
hookDisplayFooter	0 ms	- Mb
ps_shoppingcart	39 ms	0.16 Mb
__construct	1 ms	0.04 Mb
hookDisplayHeader	1 ms	0.03 Mb
displayTop	37 ms	0.09 Mb
ps_facetedsearch	33 ms	1.00 Mb
__construct	17 ms	0.40 Mb
hookProductSearchProvider	11 ms	0.60 Mb
hookDisplayLeftColumn	6 ms	0.01 Mb
ps_languageselector	2 ms	0.08 Mb
__construct	1 ms	0.02 Mb
displayNav2	1 ms	0.05 Mb
ps_currencyselector	2 ms	0.13 Mb
__construct	1 ms	0.09 Mb
displayNav2	1 ms	0.04 Mb
ps_customersignin	9 ms	0.08 Mb
__construct	1 ms	0.02 Mb
displayTop	8 ms	0.06 Mb
pagesnotfound	3 ms	0.05 Mb
__construct	1 ms	0.05 Mb
hookDisplayTop	2 ms	0.01 Mb
zonemegamenu	12 ms	0.38 Mb
__construct	8 ms	0.35 Mb
hookDisplayNavFullWidth	3 ms	0.02 Mb
ps_categorytree	52 ms	0.93 Mb
__construct	2 ms	0.06 Mb
displayLeftColumn	50 ms	0.87 Mb
zonecolumnblocks	9 ms	0.22 Mb
__construct	5 ms	0.20 Mb
hookDisplayLeftColumn	4 ms	0.02 Mb
psgdpr	15 ms	0.32 Mb
__construct	4 ms	0.21 Mb
hookDisplayGDPRConsent	11 ms	0.11 Mb
zonepopupnewsletter	8 ms	0.09 Mb
__construct	5 ms	0.07 Mb
hookDisplayOutsideMainPage	3 ms	0.02 Mb
statsdata	5 ms	0.20 Mb
__construct	1 ms	0.11 Mb
hookDisplayBeforeBodyClosingTag	3 ms	0.08 Mb
29 module(s)	574 ms	18.78 Mb

VARIOS

Subcategorías

TAMPONES

MENSTRUACIÓN

HIGIENE PERSONAL

TEST CORPORAL

PARA REGALAR

COPAS MENSTRUALES

AMBIENTADORES

AROMATIZADORES

CUBITERAS

No hay productos disponibles

Stopwatch SQL - 124 queries

Doubles

Tables stress

ObjectModel instances

Included Files

11 queries	SELECT * FROM `sx_category` a LEFT JOIN `sx_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = <span style="color:blue">XX</span> LEFT JOIN `sx_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_category` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
10 queries	SELECT `id_module` FROM `sx_module_shop` WHERE `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `sx_module` m LEFT JOIN `sx_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = <span style="color:blue">XX</span>
2 queries	(SELECT <span style="color:blue">XX</span> FROM `sx_cart_rule` WHERE date_to >= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND date_to <= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND `id_customer` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>)UNION ALL (SELECT <span style="color:blue">XX</span> FROM `sx_cart_rule` WHERE date_from >= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND date_from <= "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND `id_customer` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>)UNION ALL (SELECT <span style="color:blue">XX</span> FROM `sx_cart_rule` WHERE date_from < "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND date_to > "<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>" AND `id_customer` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries	SELECT `id_lang` FROM `sx_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT <span style="color:blue">XX</span>
2 queries	SELECT `name` FROM `sx_category_lang` WHERE `id_category` = <span style="color:blue">XX</span> AND `id_lang` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries	SELECT cl.`name` as `cname` FROM `sx_category` AS c INNER JOIN `sx_category_lang` AS cl ON (cl.`id_category` = c.`id_parent`) WHERE c.`id_category` = <span style="color:blue">XX</span> AND cl.`id_lang` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `sx_manufacturer` m INNER JOIN sx_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = <span style="color:blue">XX</span>)INNER JOIN `sx_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = <span style="color:blue">XX</span>)WHERE <span style="color:blue">XX</span> AND m.`active` = <span style="color:blue">XX</span> ORDER BY m.`name` ASC

Name	Instances	Source
Category	18	/controllers/front/listing/CategoryController.php [89] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /controllers/front/listing/CategoryController.php [211] /classes/Meta.php [380] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /classes/Meta.php [380] /modules/ps_facetedsearch/src/Product/Search.php [364] /modules/ps_facetedsearch/src/Filters/Block.php [157] /modules/ps_categorytree/ps_categorytree.php [371] /modules/ps_categorytree/ps_categorytree.php [364]
Country	5	/config/config.inc.php [157] /classes/AddressFormat.php [404] /classes/controller/FrontController.php [1677] /modules/paypal/paypal.php [352] /modules/paypal/classes/AbstractMethodPaypal.php [100]
Language	2	/config/config.inc.php [222] /classes/Tools.php [581]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php [101] /classes/Tools.php [701]
State	2	/classes/AddressFormat.php [404] /classes/controller/FrontController.php [1676]
Shop	1	/config/config.inc.php [128]
ShopGroup	1	/classes/shop/Shop.php [557]
Customer	1	/config/config.inc.php [271]
Cart	1	/classes/controller/FrontController.php [443]
Group	1	/classes/Cart.php [248]
SeoInternalLinkingModel	1	/modules/advanceseo/advanceseo.php [1702]
Gender	1	/classes/controller/FrontController.php [1606]
Risk	1	/classes/controller/FrontController.php [1609]
Address	1	/classes/shop/Shop.php [469]
AddressFormat	1	/classes/controller/FrontController.php [1671]
ZManager	1	/modules/zonethememanager/zonethememanager.php [1933]

Query	Time (ms)	Rows	Filesort	Group By	Location
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `sx_manufacturer` m INNER JOIN sx_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `sx_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	24016 ms	374	Yes		/classes/Manufacturer.php:207 /modules/ps_facetedsearch/src/Filters/Converter.php:286<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `sx_manufacturer` m INNER JOIN sx_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `sx_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	19754 ms	374	Yes		/classes/Manufacturer.php:207 /modules/ps_facetedsearch/src/Filters/Block.php:652<br>/modules/ps_facetedsearch/src/Filters/Block.php:146<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE c., cl. FROM `sx_category` c INNER JOIN sx_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `sx_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `sx_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `sx_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	17953 ms	228	Yes	Yes	/classes/Category.php:793 /modules/ps_categorytree/ps_categorytree.php:141<br>/modules/ps_categorytree/ps_categorytree.php:298<br>/modules/ps_categorytree/ps_categorytree.php:266<br>/classes/Hook.php:1017<br>/tools/profiling/Hook.php:64<br>/classes/Hook.php:964<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:307<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:399<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:104<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/34/8a/b4/348ab45902abd4b393424896fb22a5c73a00de09_2.file.layout-left-column.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/04/15/a0/0415a065031e828d2ef5fd35111e59d56e0e921a_2.file.product-list.tpl.php:48<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/3a/a5/0d/3aa50deee0e3bc21d240e77bb21f1db3ba557fd1_2.file.category.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyDev.php:40<br>/classes/controller/FrontController.php:727<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `sx_category` c INNER JOIN sx_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `sx_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `sx_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 8 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	15015 ms	9	Yes	Yes	/classes/Category.php:919 /controllers/front/listing/CategoryController.php:225<br>/controllers/front/listing/CategoryController.php:128<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
REPLACE INTO sx_layered_filter_block (hash, data) VALUES ("0b534a0fcfdfecb8d66476f3d3a3fe75", "a:1:{s:7:\"filters\";a:6:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Categorías\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilidad\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:0;}i:0;a:2:{s:4:\"name\";s:13:\"No disponible\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Estado\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuevo\";s:3:\"nbr\";i:0;}s:4:\"used\";a:2:{s:4:\"name\";s:9:\"Utilizado\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:15:\"Reacondicionado\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:0:{}i:5;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Precio\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";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:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";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:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##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;}}}")	7616 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE COUNT(1) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = "sexshopmix" AND TABLE_NAME = "sx_tab" AND COLUMN_NAME = "hide_host_mode" LIMIT 1	5229 ms	0			/modules/seoexpert/seoexpert.php:375 /modules/seoexpert/seoexpert.php:99<br>:undefined<br>/src/Core/Foundation/IoC/Container.php:123<br>/src/Core/Foundation/IoC/Container.php:153<br>/src/Core/Foundation/IoC/Container.php:166<br>/src/Adapter/ServiceLocator.php:65<br>/classes/module/Module.php:1191<br>/tools/profiling/Module.php:35<br>/classes/module/Module.php:1170<br>/classes/Hook.php:921<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `sx_attribute_group` ag INNER JOIN sx_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `sx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `sx_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `sx_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	4352 ms	1	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE cl.`name` as `cname` FROM `sx_category` AS c INNER JOIN `sx_category_lang` AS cl ON (cl.`id_category` = c.`id_parent`) WHERE c.`id_category` = 8 AND cl.`id_lang` = 1 LIMIT 1	4108 ms	4			/modules/advanceseo/advanceseo.php:1430 /modules/advanceseo/advanceseo.php:1342<br>/modules/advanceseo/advanceseo.php:1055<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `sx_configuration` c LEFT JOIN `sx_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	3889 ms	941			/classes/Configuration.php:160 /classes/Configuration.php:209<br>/classes/Configuration.php:297<br>/classes/shop/Shop.php:384<br>/config/config.inc.php:128<br>/index.php:27
SELECT SQL_NO_CACHE * FROM `sx_group_lang` WHERE `id_group` = 1	3240 ms	4			/src/Adapter/EntityMapper.php:84 /classes/ObjectModel.php:265<br>/tools/profiling/ObjectModel.php:32<br>/classes/Group.php:81<br>/classes/Group.php:397<br>/classes/Cart.php:248<br>/classes/Cart.php:221<br>/classes/controller/FrontController.php:443<br>/controllers/front/listing/CategoryController.php:92<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `sx_module` m INNER JOIN sx_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 `sx_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `sx_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `sx_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `sx_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`	2985 ms	462	Yes	Yes	/classes/Hook.php:1183 /classes/Hook.php:731<br>/classes/Hook.php:815<br>/classes/Dispatcher.php:603<br>/classes/Dispatcher.php:256<br>/classes/Dispatcher.php:214<br>/index.php:28
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM sx_layered_category WHERE controller = 'category' AND id_category = 8 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	2838 ms	12	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:61 /modules/ps_facetedsearch/src/Filters/Converter.php:263<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE `name` FROM `sx_category_lang` WHERE `id_category` = 8 AND `id_lang` = 1 LIMIT 1	2133 ms	4			/modules/advanceseo/advanceseo.php:1419 /modules/advanceseo/advanceseo.php:1341<br>/modules/advanceseo/advanceseo.php:1055<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE gs., s., gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM sx_shop_group gs LEFT JOIN sx_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN sx_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name	1792 ms	1	Yes		/classes/shop/Shop.php:711 /classes/shop/Shop.php:770<br>/classes/Configuration.php:294<br>/classes/shop/Shop.php:384<br>/config/config.inc.php:128<br>/index.php:27
SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `sx_category` c INNER JOIN sx_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `sx_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	1670 ms	228	Yes		/classes/Category.php:718 /modules/ps_facetedsearch/src/Filters/Block.php:986<br>/modules/ps_facetedsearch/src/Filters/Block.php:158<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE * FROM `sx_currency` a LEFT JOIN `sx_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1	1603 ms	1			/src/Adapter/EntityMapper.php:76 /classes/ObjectModel.php:265<br>/tools/profiling/ObjectModel.php:32<br>/classes/Currency.php:246<br>/classes/Currency.php:1079<br>/classes/Tools.php:701<br>/classes/controller/FrontController.php:384<br>/controllers/front/listing/CategoryController.php:92<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE `id_lang` FROM `sx_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT 1	1466 ms	4			/classes/Language.php:853 /src/Adapter/Currency/CurrencyDataProvider.php:112<br>/src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102<br>/src/Core/Data/Layer/AbstractDataLayer.php:91<br>/src/Core/Data/Layer/AbstractDataLayer.php:150<br>/src/Core/Data/Layer/AbstractDataLayer.php:95<br>/src/Core/Localization/Currency/CurrencyDataSource.php:67<br>/src/Core/Localization/Currency/CurrencyDataSource.php:109<br>/src/Core/Localization/Currency/CurrencyDataSource.php:96<br>/src/Core/Localization/Currency/Repository.php:87<br>/src/Core/Localization/Locale/Repository.php:207<br>/src/Core/Localization/Locale/Repository.php:150<br>/classes/controller/Controller.php:196<br>/classes/controller/FrontController.php:303<br>/controllers/front/listing/CategoryController.php:92<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `sx_hook`	1441 ms	847			/classes/Hook.php:1243 /classes/Hook.php:222<br>/classes/Hook.php:824<br>/classes/Dispatcher.php:603<br>/classes/Dispatcher.php:256<br>/classes/Dispatcher.php:214<br>/index.php:28
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `sx_meta` m LEFT JOIN `sx_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	1282 ms	49	Yes		/classes/Dispatcher.php:650 /classes/Dispatcher.php:256<br>/classes/Dispatcher.php:214<br>/index.php:28
SELECT SQL_NO_CACHE p.id_product 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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1255 ms	2	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:187<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=3 AND c.nleft>379 AND c.nright<398 GROUP BY cp.id_category	1194 ms	2	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:992<br>/modules/ps_facetedsearch/src/Filters/Block.php:158<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE lower(name) as name FROM `sx_hook` h WHERE (h.active = 1)	1158 ms	847			/classes/Hook.php:1283 /classes/Hook.php:786<br>/classes/Dispatcher.php:603<br>/classes/Dispatcher.php:256<br>/classes/Dispatcher.php:214<br>/index.php:28
SELECT SQL_NO_CACHE p.condition, 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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p GROUP BY p.condition	1139 ms	2	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:394<br>/modules/ps_facetedsearch/src/Filters/Block.php:137<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE 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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	1136 ms	2			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Adapter/MySQL.php:757<br>/modules/ps_facetedsearch/src/Filters/Block.php:480<br>/modules/ps_facetedsearch/src/Filters/Block.php:140<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE 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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	1040 ms	2			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Adapter/MySQL.php:757<br>/modules/ps_facetedsearch/src/Filters/Block.php:494<br>/modules/ps_facetedsearch/src/Filters/Block.php:140<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE 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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 ) WHERE ((sa.quantity>0))	1018 ms	2			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Adapter/MySQL.php:757<br>/modules/ps_facetedsearch/src/Filters/Block.php:505<br>/modules/ps_facetedsearch/src/Filters/Block.php:140<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE DISTINCT c.* FROM `sx_category` c LEFT JOIN `sx_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1) WHERE `level_depth` = 1	993 ms	4			/classes/Category.php:2233 /classes/Category.php:1544<br>/modules/ps_categorytree/ps_categorytree.php:364<br>/modules/ps_categorytree/ps_categorytree.php:147<br>/modules/ps_categorytree/ps_categorytree.php:298<br>/modules/ps_categorytree/ps_categorytree.php:266<br>/classes/Hook.php:1017<br>/tools/profiling/Hook.php:64<br>/classes/Hook.php:964<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:307<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:399<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:104<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/34/8a/b4/348ab45902abd4b393424896fb22a5c73a00de09_2.file.layout-left-column.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/04/15/a0/0415a065031e828d2ef5fd35111e59d56e0e921a_2.file.product-list.tpl.php:48<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/3a/a5/0d/3aa50deee0e3bc21d240e77bb21f1db3ba557fd1_2.file.category.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyDev.php:40<br>/classes/controller/FrontController.php:727<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE p.id_manufacturer, 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, cp.position FROM sx_product p LEFT JOIN sx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sx_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 sx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=379 AND c.nright<=398 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	974 ms	2	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:661<br>/modules/ps_facetedsearch/src/Filters/Block.php:146<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE * FROM `sx_group` a LEFT JOIN `sx_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1	959 ms	1			/src/Adapter/EntityMapper.php:76 /classes/ObjectModel.php:265<br>/tools/profiling/ObjectModel.php:32<br>/classes/Group.php:81<br>/classes/Group.php:397<br>/classes/Cart.php:248<br>/classes/Cart.php:221<br>/classes/controller/FrontController.php:443<br>/controllers/front/listing/CategoryController.php:92<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
(SELECT 1 FROM `sx_cart_rule` WHERE date_to >= "2025-05-07 00:00:00" AND date_to <= "2025-05-07 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sx_cart_rule` WHERE date_from >= "2025-05-07 00:00:00" AND date_from <= "2025-05-07 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `sx_cart_rule` WHERE date_from < "2025-05-07 00:00:00" AND date_to > "2025-05-07 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1	761 ms	1			/classes/CartRule.php:383 /classes/CartRule.php:416<br>/classes/Cart.php:3021<br>/classes/Cart.php:3395<br>/classes/Cart.php:3468<br>/src/Core/Cart/Fees.php:95<br>/src/Core/Cart/Calculator.php:354<br>/src/Core/Cart/Calculator.php:155<br>/classes/Cart.php:2190<br>/src/Adapter/Presenter/Cart/CartPresenter.php:335<br>/classes/controller/FrontController.php:524<br>/classes/controller/FrontController.php:590<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `sx_module` m LEFT JOIN `sx_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	734 ms	95			/classes/module/Module.php:340 /modules/mailchimppro/mailchimppro.php:216<br>:undefined<br>/src/Core/Foundation/IoC/Container.php:123<br>/src/Core/Foundation/IoC/Container.php:153<br>/src/Core/Foundation/IoC/Container.php:166<br>/src/Adapter/ServiceLocator.php:65<br>/classes/module/Module.php:1191<br>/tools/profiling/Module.php:35<br>/classes/module/Module.php:1170<br>/classes/Hook.php:921<br>/classes/Dispatcher.php:603<br>/classes/Dispatcher.php:256<br>/classes/Dispatcher.php:214<br>/index.php:28
SELECT SQL_NO_CACHE * FROM `sx_category` a LEFT JOIN `sx_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `sx_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1	690 ms	1			/src/Adapter/EntityMapper.php:76 /classes/ObjectModel.php:265<br>/tools/profiling/ObjectModel.php:32<br>/classes/Category.php:160<br>/modules/ps_categorytree/ps_categorytree.php:371<br>/modules/ps_categorytree/ps_categorytree.php:276<br>/modules/ps_categorytree/ps_categorytree.php:266<br>/classes/Hook.php:1017<br>/tools/profiling/Hook.php:64<br>/classes/Hook.php:964<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:307<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:399<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:104<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/34/8a/b4/348ab45902abd4b393424896fb22a5c73a00de09_2.file.layout-left-column.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/04/15/a0/0415a065031e828d2ef5fd35111e59d56e0e921a_2.file.product-list.tpl.php:48<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/3a/a5/0d/3aa50deee0e3bc21d240e77bb21f1db3ba557fd1_2.file.category.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyDev.php:40<br>/classes/controller/FrontController.php:727<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE id_zthememanager FROM `sx_zthememanager` m WHERE m.`id_shop` = 1 LIMIT 1	686 ms	1			/modules/zonethememanager/classes/ZManager.php:177 /modules/zonethememanager/zonethememanager.php:1933<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:547<br>/classes/controller/FrontController.php:590<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `sx_module` m LEFT JOIN `sx_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	642 ms	95			/classes/module/Module.php:340 /modules/advanceseo/advanceseo.php:39<br>:undefined<br>/src/Core/Foundation/IoC/Container.php:123<br>/src/Core/Foundation/IoC/Container.php:153<br>/src/Core/Foundation/IoC/Container.php:166<br>/src/Adapter/ServiceLocator.php:65<br>/classes/module/Module.php:1191<br>/tools/profiling/Module.php:35<br>/classes/module/Module.php:1170<br>/classes/Hook.php:921<br>/controllers/front/listing/CategoryController.php:120<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM sx_product p INNER JOIN sx_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 6) INNER JOIN sx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN sx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN sx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (357, 366, 177, 79, 294, 359, 35) AND c.nleft>=379 AND c.nright<=398	613 ms	1			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57<br>/modules/ps_facetedsearch/src/Filters/Block.php:250<br>/modules/ps_facetedsearch/src/Filters/Block.php:131<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE * FROM `sx_currency` c ORDER BY `iso_code` ASC	609 ms	1	Yes		/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84<br>/src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90<br>/src/Core/Localization/Currency/CurrencyDataSource.php:96<br>/src/Core/Localization/Currency/Repository.php:87<br>/src/Core/Localization/Locale/Repository.php:207<br>/src/Core/Localization/Locale/Repository.php:150<br>/classes/controller/Controller.php:196<br>/classes/controller/FrontController.php:303<br>/controllers/front/listing/CategoryController.php:92<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `sx_module` m LEFT JOIN `sx_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	582 ms	95			/classes/module/Module.php:340 /modules/ps_mbo/ps_mbo.php:189<br>:undefined<br>/src/Core/Foundation/IoC/Container.php:123<br>/src/Core/Foundation/IoC/Container.php:153<br>/src/Core/Foundation/IoC/Container.php:166<br>/src/Adapter/ServiceLocator.php:65<br>/classes/module/Module.php:1191<br>/tools/profiling/Module.php:35<br>/classes/module/Module.php:1170<br>/classes/Hook.php:921<br>/classes/Dispatcher.php:364<br>/index.php:28
SELECT SQL_NO_CACHE id_shop FROM `sx_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1	575 ms	1			/classes/ObjectModel.php:1647 /classes/Group.php:400<br>/classes/Cart.php:248<br>/classes/Cart.php:221<br>/classes/controller/FrontController.php:443<br>/controllers/front/listing/CategoryController.php:92<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:525<br>/index.php:28
SELECT SQL_NO_CACHE `id_module` FROM `sx_module` WHERE `name` = "ps_categorytree" LIMIT 1	574 ms	1			/classes/module/Module.php:2840 /classes/module/Module.php:2327<br>/classes/Hook.php:1013<br>/tools/profiling/Hook.php:64<br>/classes/Hook.php:964<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:307<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:399<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/8e/52/09/8e5209820be80bced2aac96fbb6f4046f9e202cd_2.file.layout-both-columns.tpl.php:104<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/34/8a/b4/348ab45902abd4b393424896fb22a5c73a00de09_2.file.layout-left-column.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/04/15/a0/0415a065031e828d2ef5fd35111e59d56e0e921a_2.file.product-list.tpl.php:48<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/dev/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/3a/a5/0d/3aa50deee0e3bc21d240e77bb21f1db3ba557fd1_2.file.category.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyDev.php:40<br>/classes/controller/FrontController.php:727<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:525<br>/index.php:28
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 `sx_feature` f INNER JOIN sx_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `sx_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `sx_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `sx_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	549 ms	1	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:525<br>/index.php:28

#	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/react/promise/src/functions_include.php
11	/vendor/react/promise/src/functions.php
12	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
13	/vendor/symfony/polyfill-php72/bootstrap.php
14	/vendor/symfony/polyfill-intl-idn/bootstrap.php
15	/vendor/symfony/polyfill-ctype/bootstrap.php
16	/vendor/symfony/polyfill-mbstring/bootstrap.php
17	/vendor/symfony/polyfill-php73/bootstrap.php
18	/vendor/symfony/polyfill-iconv/bootstrap.php
19	/vendor/jakeasmith/http_build_url/src/http_build_url.php
20	/vendor/markbaker/complex/classes/src/functions/abs.php
21	/vendor/markbaker/complex/classes/src/functions/acos.php
22	/vendor/markbaker/complex/classes/src/functions/acosh.php
23	/vendor/markbaker/complex/classes/src/functions/acot.php
24	/vendor/markbaker/complex/classes/src/functions/acoth.php
25	/vendor/markbaker/complex/classes/src/functions/acsc.php
26	/vendor/markbaker/complex/classes/src/functions/acsch.php
27	/vendor/markbaker/complex/classes/src/functions/argument.php
28	/vendor/markbaker/complex/classes/src/functions/asec.php
29	/vendor/markbaker/complex/classes/src/functions/asech.php
30	/vendor/markbaker/complex/classes/src/functions/asin.php
31	/vendor/markbaker/complex/classes/src/functions/asinh.php
32	/vendor/markbaker/complex/classes/src/functions/atan.php
33	/vendor/markbaker/complex/classes/src/functions/atanh.php
34	/vendor/markbaker/complex/classes/src/functions/conjugate.php
35	/vendor/markbaker/complex/classes/src/functions/cos.php
36	/vendor/markbaker/complex/classes/src/functions/cosh.php
37	/vendor/markbaker/complex/classes/src/functions/cot.php
38	/vendor/markbaker/complex/classes/src/functions/coth.php
39	/vendor/markbaker/complex/classes/src/functions/csc.php