Inicio

Colorante Amarillo, en pasta. Varias tonalidades

$ 1.674,17

Colorante en pasta, comestible. REFERENCIAS: Amarillo: color brillante usado para comunión. - SI NO HAY FLEIBOR VA BLOCH Amarillo...

Lista de deseos

Comparar

Load Time	1019 ms
Querying Time	448 ms
Queries	301
Memory Peak Usage	47.5 Mb
Included Files	854 files - 11.39 Mb
PrestaShop Cache	- Mb
Global vars	0.87 Mb
- global $_MODULES	567k
- global $context	251k
- global $_MODULE	48k
- global $_SERVER	11k
- global $smarty	4k
- global $exportPhpConfigFile	4k
- global $__composer_autoload_files	3k
- global $config	3k

PrestaShop Version	8.0.4
PHP Version	8.0.30
MySQL Version	10.4.34-MariaDB
Memory Limit	1024M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	17.990 ms	17.990 ms	18.41 Mb	18.7 Mb
__construct	73.153 ms	91.143 ms	1.82 Mb	21.7 Mb
init	199.225 ms	290.368 ms	6.05 Mb	27.5 Mb
checkAccess	0.001 ms	290.369 ms	- Mb	27.5 Mb
setMedia	7.381 ms	297.750 ms	0.80 Mb	27.5 Mb
postProcess	0.001 ms	297.751 ms	- Mb	27.5 Mb
initHeader	0.001 ms	297.752 ms	- Mb	27.5 Mb
initContent	605.355 ms	903 ms	14.73 Mb	42.0 Mb
initFooter	0.001 ms	903 ms	- Mb	42.0 Mb
display	115.916 ms	1019 ms	5.54 Mb	47.5 Mb

Hook	Time	Memory Usage
Header	194.994 ms	2.68 Mb
=> leoslideshow	0.343 ms	- Mb
=> leofeature	0.514 ms	0.02 Mb
=> leoquicklogin	0.190 ms	- Mb
=> eicaptcha	0.009 ms	- Mb
=> leopopupsale	193.254 ms	2.62 Mb
=> xmlfeeds	0.500 ms	0.03 Mb
=> mercadopago	0.184 ms	- Mb
DisplayHeader	97.039 ms	2.15 Mb
=> ps_shoppingcart	0.059 ms	- Mb
=> ps_searchbar	0.182 ms	- Mb
=> ps_googleanalytics	0.120 ms	0.01 Mb
=> leobootstrapmenu	0.980 ms	0.05 Mb
=> appagebuilder	94.618 ms	1.99 Mb
=> ets_contactform7	0.006 ms	- Mb
=> whatsappchat	1.074 ms	0.10 Mb
displayTop	79.844 ms	2.00 Mb
=> ps_searchbar (widget)	0.268 ms	0.01 Mb
=> ps_customersignin (widget)	0.465 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.227 ms	0.01 Mb
=> appagebuilder (widget)	78.884 ms	1.96 Mb
ProductSearchProvider	75.943 ms	0.16 Mb
=> ps_facetedsearch	75.943 ms	0.16 Mb
DisplayBeforeBodyClosingTag	7.171 ms	0.48 Mb
=> ps_googleanalytics	1.828 ms	0.13 Mb
=> leofeature	0.467 ms	0.01 Mb
=> leoquicklogin	1.316 ms	0.10 Mb
=> whatsappchat	3.560 ms	0.23 Mb
DisplayLeoProfileProduct	4.972 ms	0.56 Mb
=> appagebuilder	4.972 ms	0.56 Mb
displayLeftColumn	2.765 ms	0.16 Mb
=> ps_categorytree (widget)	2.493 ms	0.15 Mb
=> appagebuilder (widget)	0.272 ms	0.01 Mb
DisplayFooter	1.321 ms	0.13 Mb
=> leoslideshow	0.328 ms	0.05 Mb
=> leoquicklogin	0.006 ms	- Mb
=> ets_contactform7	0.231 ms	0.02 Mb
=> whatsappchat	0.752 ms	0.05 Mb
=> leopopupsale	0.004 ms	- Mb
ActionFrontControllerSetMedia	1.201 ms	0.18 Mb
=> ps_emailsubscription	1.040 ms	0.18 Mb
=> ps_socialfollow	0.076 ms	- Mb
=> ps_emailalerts	0.085 ms	- Mb
DisplayNav2	1.037 ms	0.10 Mb
=> leoslideshow	0.408 ms	0.05 Mb
=> leoquicklogin	0.009 ms	- Mb
=> ets_contactform7	0.233 ms	0.02 Mb
=> whatsappchat	0.387 ms	0.03 Mb
DisplayLeftColumn	0.782 ms	0.11 Mb
=> ps_facetedsearch	0.191 ms	0.06 Mb
=> leoslideshow	0.354 ms	0.03 Mb
=> leoquicklogin	0.009 ms	- Mb
=> ets_contactform7	0.228 ms	0.02 Mb
DisplayNav1	0.778 ms	0.08 Mb
=> leoslideshow	0.381 ms	0.05 Mb
=> leoquicklogin	0.010 ms	- Mb
=> whatsappchat	0.387 ms	0.03 Mb
DisplayLeoCartButton	0.760 ms	0.05 Mb
=> leofeature	0.760 ms	0.05 Mb
DisplayFooterAfter	0.656 ms	0.07 Mb
=> leoslideshow	0.339 ms	0.05 Mb
=> leoquicklogin	0.008 ms	- Mb
=> leopopupsale	0.309 ms	0.02 Mb
displayBanner	0.643 ms	0.06 Mb
=> appagebuilder (widget)	0.643 ms	0.06 Mb
DisplayTop	0.540 ms	0.08 Mb
=> leoslideshow	0.334 ms	0.05 Mb
=> leoquicklogin	0.009 ms	- Mb
=> ets_contactform7	0.197 ms	0.02 Mb
DisplayBanner	0.474 ms	0.03 Mb
=> whatsappchat	0.474 ms	0.03 Mb
DisplayWrapperBottom	0.472 ms	0.02 Mb
=> whatsappchat	0.472 ms	0.02 Mb
ModuleRoutes	0.430 ms	0.06 Mb
=> appagebuilder	0.416 ms	0.06 Mb
=> ets_contactform7	0.014 ms	- Mb
PagebuilderConfig	0.379 ms	0.05 Mb
=> appagebuilder	0.172 ms	0.02 Mb
=> appagebuilder	0.207 ms	0.03 Mb
Top	0.368 ms	0.03 Mb
=> whatsappchat	0.368 ms	0.03 Mb
DisplayLeoWishlistButton	0.341 ms	0.03 Mb
=> leofeature	0.341 ms	0.03 Mb
DisplayFooterBefore	0.341 ms	0.05 Mb
=> leoslideshow	0.332 ms	0.05 Mb
=> leoquicklogin	0.009 ms	- Mb
LeftColumn	0.336 ms	0.02 Mb
=> whatsappchat	0.336 ms	0.02 Mb
displayFooterAfter	0.314 ms	0.05 Mb
=> appagebuilder (widget)	0.314 ms	0.05 Mb
displayNav1	0.305 ms	0.01 Mb
=> appagebuilder (widget)	0.305 ms	0.01 Mb
DisplayNavFullWidth	0.292 ms	0.05 Mb
=> leoslideshow	0.284 ms	0.05 Mb
=> leoquicklogin	0.008 ms	- Mb
displayFooterBefore	0.276 ms	0.02 Mb
=> appagebuilder (widget)	0.276 ms	0.02 Mb
displayNav2	0.276 ms	0.01 Mb
=> appagebuilder (widget)	0.276 ms	0.01 Mb
displayNavFullWidth	0.243 ms	0.01 Mb
=> appagebuilder (widget)	0.243 ms	0.01 Mb
displayFooter	0.238 ms	0.01 Mb
=> appagebuilder (widget)	0.238 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.237 ms	0.01 Mb
=> leoquicklogin	0.237 ms	0.01 Mb
DisplayLeoCompareButton	0.212 ms	0.01 Mb
=> leofeature	0.212 ms	0.01 Mb
FilterCategoryContent	0.155 ms	0.01 Mb
=> appagebuilder	0.155 ms	0.01 Mb
ActionOutputHTMLBefore	0.082 ms	- Mb
=> appagebuilder	0.066 ms	- Mb
=> ets_contactform7	0.016 ms	- Mb
DisplayWrapperTop	0.018 ms	- Mb
=> mercadopago	0.018 ms	- Mb
FilterHtmlContent	0.009 ms	- Mb
=> appagebuilder	0.004 ms	- Mb
=> appagebuilder	0.003 ms	- Mb
=> appagebuilder	0.002 ms	- Mb
37 hook(s)	476.245 ms	9.55 Mb

Module	Time	Memory Usage
appagebuilder	266.526 ms	7.62 Mb
__construct	84.414 ms	2.79 Mb
hookModuleRoutes	0.420 ms	0.06 Mb
hookFilterHtmlContent	0.007 ms	- Mb
hookFilterCategoryContent	0.157 ms	0.01 Mb
hookFilterHtmlContent	0.005 ms	- Mb
hookFilterHtmlContent	0.005 ms	- Mb
hookDisplayHeader	94.622 ms	1.99 Mb
displayBanner	0.646 ms	0.06 Mb
displayNav1	0.307 ms	0.02 Mb
displayNav2	0.278 ms	0.02 Mb
displayTop	78.886 ms	1.96 Mb
displayNavFullWidth	0.245 ms	0.02 Mb
displayLeftColumn	0.274 ms	0.02 Mb
hookPagebuilderConfig	0.175 ms	0.02 Mb
hookPagebuilderConfig	0.209 ms	0.03 Mb
hookDisplayLeoProfileProduct	4.973 ms	0.57 Mb
displayFooterBefore	0.278 ms	0.02 Mb
displayFooter	0.239 ms	0.02 Mb
displayFooterAfter	0.317 ms	0.05 Mb
hookActionOutputHTMLBefore	0.069 ms	- Mb
ets_contactform7	14.379 ms	2.50 Mb
__construct	13.440 ms	2.41 Mb
hookModuleRoutes	0.017 ms	- Mb
hookDisplayHeader	0.008 ms	- Mb
hookDisplayNav2	0.234 ms	0.02 Mb
hookDisplayTop	0.199 ms	0.02 Mb
hookDisplayLeftColumn	0.230 ms	0.02 Mb
hookDisplayFooter	0.233 ms	0.02 Mb
hookActionOutputHTMLBefore	0.018 ms	- Mb
ps_emailsubscription	3.726 ms	0.47 Mb
__construct	2.683 ms	0.29 Mb
hookActionFrontControllerSetMedia	1.043 ms	0.18 Mb
ps_socialfollow	0.662 ms	0.06 Mb
__construct	0.582 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.080 ms	- Mb
ps_emailalerts	2.506 ms	0.25 Mb
__construct	2.418 ms	0.25 Mb
hookActionFrontControllerSetMedia	0.088 ms	- Mb
ps_shoppingcart	0.709 ms	0.05 Mb
__construct	0.418 ms	0.04 Mb
hookDisplayHeader	0.062 ms	- Mb
displayTop	0.229 ms	0.01 Mb
ps_searchbar	0.664 ms	0.04 Mb
__construct	0.209 ms	0.03 Mb
hookDisplayHeader	0.184 ms	- Mb
displayTop	0.271 ms	0.01 Mb
ps_googleanalytics	2.372 ms	0.20 Mb
__construct	0.419 ms	0.05 Mb
hookDisplayHeader	0.122 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.831 ms	0.13 Mb
leobootstrapmenu	10.019 ms	1.01 Mb
__construct	9.036 ms	0.96 Mb
hookDisplayHeader	0.983 ms	0.05 Mb
leoslideshow	74.055 ms	1.12 Mb
__construct	70.930 ms	0.71 Mb
hookHeader	0.346 ms	0.01 Mb
hookDisplayNav1	0.384 ms	0.05 Mb
hookDisplayNav2	0.411 ms	0.05 Mb
hookDisplayTop	0.337 ms	0.05 Mb
hookDisplayNavFullWidth	0.286 ms	0.05 Mb
hookDisplayLeftColumn	0.356 ms	0.03 Mb
hookDisplayFooterBefore	0.334 ms	0.05 Mb
hookDisplayFooter	0.330 ms	0.06 Mb
hookDisplayFooterAfter	0.341 ms	0.05 Mb
leofeature	6.624 ms	2.02 Mb
__construct	4.317 ms	1.90 Mb
hookHeader	0.517 ms	0.02 Mb
hookDisplayLeoCartButton	0.763 ms	0.05 Mb
hookDisplayLeoWishlistButton	0.344 ms	0.03 Mb
hookDisplayLeoCompareButton	0.214 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	0.469 ms	0.01 Mb
leoquicklogin	4.742 ms	0.47 Mb
__construct	2.908 ms	0.36 Mb
hookHeader	0.193 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.242 ms	0.01 Mb
hookDisplayNav1	0.012 ms	- Mb
hookDisplayNav2	0.010 ms	- Mb
hookDisplayTop	0.010 ms	- Mb
hookDisplayNavFullWidth	0.010 ms	- Mb
hookDisplayLeftColumn	0.010 ms	- Mb
hookDisplayFooterBefore	0.011 ms	- Mb
hookDisplayFooter	0.008 ms	- Mb
hookDisplayFooterAfter	0.009 ms	- Mb
hookDisplayBeforeBodyClosingTag	1.319 ms	0.10 Mb
eicaptcha	1.012 ms	0.10 Mb
__construct	1.001 ms	0.10 Mb
hookHeader	0.011 ms	- Mb
whatsappchat	11.100 ms	0.93 Mb
__construct	3.268 ms	0.40 Mb
hookDisplayHeader	1.078 ms	0.10 Mb
hookDisplayBanner	0.477 ms	0.03 Mb
hookDisplayNav1	0.389 ms	0.03 Mb
hookDisplayNav2	0.389 ms	0.03 Mb
hookTop	0.370 ms	0.03 Mb
hookLeftColumn	0.338 ms	0.02 Mb
hookDisplayWrapperBottom	0.474 ms	0.02 Mb
hookDisplayFooter	0.754 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	3.563 ms	0.23 Mb
leopopupsale	194.937 ms	2.76 Mb
__construct	1.363 ms	0.12 Mb
hookHeader	193.258 ms	2.62 Mb
hookDisplayFooter	0.005 ms	- Mb
hookDisplayFooterAfter	0.311 ms	0.02 Mb
xmlfeeds	4.531 ms	0.53 Mb
__construct	4.028 ms	0.49 Mb
hookHeader	0.503 ms	0.04 Mb
mercadopago	7.234 ms	0.94 Mb
__construct	7.025 ms	0.93 Mb
hookHeader	0.189 ms	- Mb
hookDisplayWrapperTop	0.020 ms	- Mb
ps_facetedsearch	79.966 ms	0.67 Mb
__construct	3.824 ms	0.45 Mb
hookProductSearchProvider	75.949 ms	0.16 Mb
hookDisplayLeftColumn	0.193 ms	0.06 Mb
ps_customersignin	0.668 ms	0.05 Mb
__construct	0.199 ms	0.02 Mb
displayTop	0.469 ms	0.03 Mb
ps_categorytree	2.972 ms	0.22 Mb
__construct	0.476 ms	0.07 Mb
displayLeftColumn	2.496 ms	0.15 Mb
20 module(s)	689.404 ms	22.02 Mb

Inicio

Inicio

Colorante Amarillo, en pasta. Varias tonalidades

ENTREGA RÁPIDA

OFERTAS PERMANENTES

PAGO SEGURO

SITIO SEGURO

Contáctenos

Horarios

Información

Mi cuenta

Stopwatch SQL - 301 queries

Doubles

Tables stress

ObjectModel instances

Included Files

#	Query	Time (ms)	Rows	Filesort	Group By	Location
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	75.676 ms	1073			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:309 (get) /classes/shop/Shop.php:394 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
42	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 600) AND (b.`id_shop` = 1) LIMIT 1	70.496 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:201 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:215 (array_map) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 6110 LIMIT 1	68.487 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
196	SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = 6103 AND image_shop.`cover`= 1 LIMIT 1	67.499 ms	1			/classes/Image.php:353 /modules/leopopupsale/leopopupsale.php:937 (getCover) /modules/leopopupsale/leopopupsale.php:663 (getImageProduct) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
255	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1	64.217 ms	1			/classes/module/Module.php:2631 /classes/module/Module.php:2103 (getModuleIdByName) /modules/appagebuilder/classes/shortcodes/ApModule.php:178 (isEnabled) /modules/appagebuilder/classes/shortcodes.php:511 (prepareFontContent) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/shortcodes.php:384 (doShortcode) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/shortcodes.php:384 (doShortcode) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/ApShortCodesBuilder.php:366 (doShortcode) /modules/appagebuilder/classes/ApPageBuilderModel.php:171 (parse) /modules/appagebuilder/appagebuilder.php:2583 (parseData) /modules/appagebuilder/appagebuilder.php:2556 (getWidgetVariables) /classes/Hook.php:994 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:938 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/e5/23/7e/e5237e4dbadf3bf58e1ab51d195a819bc154e51a_2.file.header.tpl.php:118 (__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/papeleralayouts_layout_left_column_tpl/e5/23/7e/e5237e4dbadf3bf58e1ab51d195a819bc154e51a_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26cf6b67_41985362) /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/papeleralayouts_layout_left_column_tpl/f0/44/82/f0448200bca35588ed707ccb1ee91851c78d989b_2.file.layout-both-columns.tpl.php:208 (_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/papeleralayouts_layout_left_column_tpl/f0/44/82/f0448200bca35588ed707ccb1ee91851c78d989b_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b502b8_31248582) /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/papeleralayouts_layout_left_column_tpl/ca/bb/8e/cabb8e44e9d2f8bc77fac639edeca249e60a9761_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b3ceb9_10854253) /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/papeleralayouts_layout_left_column_tpl/3a/e8/55/3ae8554488471a7139eef7d5cbbc93d628622a74_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b38d75_38764331) /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/papeleralayouts_layout_left_column_tpl/36/02/eb/3602eb0e69ee82fe6009d7187b98c2c16b9cf9d1_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b27691_17811505) /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:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
214	SELECT SQL_NO_CACHE pac.id_attribute, 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 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_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) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (63, 72, 11, 19) AND c.nleft>=2 AND c.nright<=137 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) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	7.907 ms	142	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
215	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("b5ef11df26d92bc2164c03ef1cce4125", "a:1:{s:7:\"filters\";a:5:{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:1:{i:100;a:2:{s:4:\"name\";s:12:\"Repostería \";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;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:1:{i:63;a:3:{s:4:\"name\";s:7:\"Fleibor\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Peso\";s:3:\"max\";d:0.194000000000000005773159728050814010202884674072265625;s:3:\"min\";d:0.194000000000000005773159728050814010202884674072265625;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:1;}i:3;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:1675;s:3:\"min\";d:1674;s:4:\"unit\";s:1:\"$\";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:\"ARS\";s:14:\"currencySymbol\";s:1:\"$\";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:1;s:5:\"value\";N;}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\";s:1:\"1\";s:4:\"name\";s:7:\"Colores\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:41:{i:8;a:4:{s:4:\"name\";s:6:\"VERDE \";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:27;a:4:{s:4:\"name\";s:9:\"Amarillo \";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:32;a:4:{s:4:\"name\";s:4:\"Azul\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:42;a:4:{s:4:\"name\";s:7:\"Naranja\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:54;a:4:{s:4:\"name\";s:4:\"Rosa\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:63;a:4:{s:4:\"name\";s:7:\"Violeta\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:78;a:4:{s:4:\"name\";s:7:\"Celeste\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:19;a:4:{s:4:\"name\";s:6:\"Rojo B\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20;a:4:{s:4:\"name\";s:6:\"Rojo M\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:28;a:5:{s:4:\"name\";s:10:\"Amarillo H\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:29;a:4:{s:4:\"name\";s:10:\"Amarillo L\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:30;a:4:{s:4:\"name\";s:10:\"Amarillo P\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:31;a:4:{s:4:\"name\";s:11:\"Amarillo RT\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:33;a:4:{s:4:\"name\";s:6:\"Azul F\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:34;a:4:{s:4:\"name\";s:6:\"Azul M\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:35;a:4:{s:4:\"name\";s:6:\"Azul T\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:43;a:4:{s:4:\"name\";s:9:\"Naranja P\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:44;a:4:{s:4:\"name\";s:9:\"Naranja B\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:55;a:4:{s:4:\"name\";s:6:\"Rosa N\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:58;a:4:{s:4:\"name\";s:6:\"Rosa B\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:61;a:4:{s:4:\"name\";s:6:\"Rosa C\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:62;a:4:{s:4:\"name\";s:6:\"Rosa X\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:64;a:4:{s:4:\"name\";s:9:\"Violeta L\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:65;a:4:{s:4:\"name\";s:9:\"Violeta B\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:66;a:4:{s:4:\"name\";s:9:\"Naranja S\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:67;a:4:{s:4:\"name\";s:7:\"Verde W\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:68;a:4:{s:4:\"name\";s:7:\"Verde M\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:69;a:4:{s:4:\"name\";s:7:\"Verde Y\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:70;a:4:{s:4:\"name\";s:7:\"Verde A\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:71;a:4:{s:4:\"name\";s:7:\"Verde H\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:72;a:4:{s:4:\"name\";s:7:\"Verde N\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:73;a:4:{s:4:\"name\";s:9:\"Marron CH\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:74;a:4:{s:4:\"name\";s:8:\"Marron B\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:75;a:4:{s:4:\"name\";s:8:\"Marron C\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:76;a:4:{s:4:\"name\";s:8:\"Marron O\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:77;a:4:{s:4:\"name\";s:8:\"Marron Y\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:79;a:4:{s:4:\"name\";s:9:\"Celeste B\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:80;a:4:{s:4:\"name\";s:9:\"Celeste N\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:81;a:4:{s:4:\"name\";s:9:\"Celeste C\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1;a:4:{s:4:\"name\";s:6:\"Rojo R\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:887;a:4:{s:4:\"name\";s:9:\"Violeta N\";s:3:\"nbr\";s:1:\"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\";s:1:\"0\";}}}")	7.555 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
197	SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = 6102 AND image_shop.`cover`= 1 LIMIT 1	2.931 ms	1			/classes/Image.php:353 /modules/leopopupsale/leopopupsale.php:937 (getCover) /modules/leopopupsale/leopopupsale.php:663 (getImageProduct) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	2.336 ms	0			/classes/Hook.php:1231 /classes/Hook.php:218 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3851 (getManager) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
209	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 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_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) WHERE ((pac.id_attribute=28)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (63, 72, 11, 19) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute=28)) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<137 GROUP BY cp.id_category	2.217 ms	8	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0	2.177 ms	974			/classes/SpecificPrice.php:310 /classes/SpecificPrice.php:360 (filterOutField) /classes/SpecificPrice.php:548 (computeExtraConditions) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
211	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, pa.id_product_attribute 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_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) WHERE ((pac.id_attribute=28)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=137 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) WHERE ((pac.id_attribute=28)) GROUP BY p.id_manufacturer	2.142 ms	16	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.971 ms	463			/classes/Hook.php:447 /classes/Hook.php:484 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3851 (getManager) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
207	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 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_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) WHERE ((pac.id_attribute=28)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (63, 72, 11, 19) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature=2)) AND ((pac_1.id_attribute=28)) GROUP BY fp.id_feature_value	1.655 ms	32	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	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` INNER JOIN `ps_module_shop` `mshop` ON mshop.`id_module` = m.`id_module` 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`	1.551 ms	116	Yes	Yes	/classes/Hook.php:1172 /classes/Hook.php:689 (getAllHookRegistrations) /classes/Hook.php:793 (getHookModuleExecList) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
72	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-06-13 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` DESC LIMIT 0,10	1.356 ms	4323			/classes/Category.php:1035 /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
205	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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 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_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) WHERE ((pac.id_attribute=28)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (63, 72, 11, 19) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) GROUP BY p.id_product ORDER BY p.date_add DESC, p.id_product DESC	1.081 ms	16	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (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` = 1) 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` = 1) 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` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	0.931 ms	71	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
268	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 137 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	0.879 ms	69	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:994 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:938 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/f0/44/82/f0448200bca35588ed707ccb1ee91851c78d989b_2.file.layout-both-columns.tpl.php:267 (__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/papeleralayouts_layout_left_column_tpl/f0/44/82/f0448200bca35588ed707ccb1ee91851c78d989b_2.file.layout-both-columns.tpl.php:92 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b502b8_31248582) /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/papeleralayouts_layout_left_column_tpl/ca/bb/8e/cabb8e44e9d2f8bc77fac639edeca249e60a9761_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b3ceb9_10854253) /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/papeleralayouts_layout_left_column_tpl/3a/e8/55/3ae8554488471a7139eef7d5cbbc93d628622a74_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b38d75_38764331) /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/papeleralayouts_layout_left_column_tpl/36/02/eb/3602eb0e69ee82fe6009d7187b98c2c16b9cf9d1_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b4a26b27691_17811505) /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:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
212	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p 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_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) WHERE ((pac.id_attribute=28)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (63, 72, 11, 19) AND c.nleft>=2 AND c.nright<=137	0.857 ms	4			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:744 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
37	SELECT SQL_NO_CACHE 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 = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.818 ms	9	Yes	Yes	/classes/Category.php:897 /controllers/front/listing/CategoryController.php:215 (getSubCategories) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
210	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_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	0.802 ms	74	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
203	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.793 ms	66	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
208	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_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	0.760 ms	67	Yes		/classes/Category.php:697 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1	0.754 ms	974			/classes/SpecificPrice.php:297 /classes/SpecificPrice.php:360 (filterOutField) /classes/SpecificPrice.php:548 (computeExtraConditions) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
202	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_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	0.707 ms	74	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Converter.php:286 (getManufacturers) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
213	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_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 = 44) 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_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) WHERE ((pac.id_attribute=28)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (63, 72, 11, 19) AND c.nleft>=2 AND c.nright<=137	0.707 ms	4			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.696 ms	1008			/classes/Hook.php:1231 /classes/Hook.php:218 (getAllHookIds) /classes/Hook.php:802 (getIdByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
45	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.610 ms	84			/classes/module/Module.php:344 /modules/ps_emailsubscription/ps_emailsubscription.php:96 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1230 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1209 (coreLoadModule) /classes/Hook.php:903 (getInstanceByName) /classes/controller/FrontController.php:925 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.599 ms	1008			/classes/Hook.php:1271 /classes/Hook.php:764 (getHookStatusByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
43	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 700) AND (b.`id_shop` = 1) LIMIT 1	0.573 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:201 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:215 (array_map) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
123	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 6108 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 6108 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.550 ms	0			/classes/Cart.php:1407 /classes/Product.php:4241 (getProductQuantity) /classes/Product.php:5642 (getQuantity) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
61	SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang FROM ps_appagebuilder p LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1) LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder) WHERE pl.id_lang=1 AND ps.id_shop=1 AND p.id_appagebuilder_positions IN (7,12,13,4) ORDER BY p.id_appagebuilder	0.533 ms	90			/modules/appagebuilder/classes/ApPageBuilderModel.php:302 /modules/appagebuilder/appagebuilder.php:2061 (getAllItems) /classes/Hook.php:983 (hookdisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
216	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2024-06-13 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product = 556 LIMIT 1	0.529 ms	6			/classes/ProductAssembler.php:106 /classes/ProductAssembler.php:125 (addMissingProductFields) /classes/controller/ProductListingFrontController.php:80 (assembleProduct) :undefined (prepareProductForTemplate) /classes/controller/ProductListingFrontController.php:102 (array_map) /classes/controller/ProductListingFrontController.php:357 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 44, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 44) AND `id_group` IN (0, 1) AND `id_product` = 6107 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-06-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-06-13 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.514 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
135	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 6107 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 6107 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.504 ms	0			/classes/Cart.php:1407 /classes/Product.php:4241 (getProductQuantity) /classes/Product.php:5642 (getQuantity) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 6106 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 6106 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.484 ms	0			/classes/Cart.php:1407 /classes/Product.php:4241 (getProductQuantity) /classes/Product.php:5642 (getQuantity) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
113	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 6109 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 6109 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.474 ms	0			/classes/Cart.php:1407 /classes/Product.php:4241 (getProductQuantity) /classes/Product.php:5642 (getQuantity) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
142	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 44, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 44) AND `id_group` IN (0, 1) AND `id_product` = 6106 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-06-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-06-13 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.468 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
157	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 6105 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 6105 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.468 ms	0			/classes/Cart.php:1407 /classes/Product.php:4241 (getProductQuantity) /classes/Product.php:5642 (getQuantity) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

16 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
12 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
12 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
11 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
11 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
11 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
11 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)
11 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
11 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
11 queries	SELECT name, value, pf.id_feature, f.position FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
10 queries	SELECT * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = XX AND image_shop.`cover`= XX LIMIT XX
8 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
8 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
4 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
4 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
3 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
3 queries	SELECT `name` FROM `ps_hook` WHERE `id_hook` = 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 `id_lang` FROM `ps_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT XX
2 queries	SELECT page from `ps_appagebuilder_page` where id_category = 'XX' AND id_shop = 'XX' LIMIT XX
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT * FROM ps_leoslideshow_groups gr WHERE gr.id_shop = XX AND gr.hook = "displayNavXX" AND gr.`active` = XX ORDER BY gr.id_leoslideshow_groups LIMIT XX
2 queries	SELECT * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = XX) WHERE `id_hook` = "hookDisplayNavXX" AND `id_shop` = XX AND `active` = XX ORDER BY position DESC;

Name	Instances	Source
Product	25	/classes/Link.php:113 (__construct) [id: 6111] /classes/Link.php:113 (__construct) [id: 6110] /classes/Link.php:113 (__construct) [id: 6109] /classes/Link.php:113 (__construct) [id: 6108] /classes/Link.php:113 (__construct) [id: 6107] /classes/Link.php:113 (__construct) [id: 6106] /classes/Link.php:113 (__construct) [id: 6105] /classes/Link.php:113 (__construct) [id: 6103] /classes/Link.php:113 (__construct) [id: 6102] /classes/Link.php:113 (__construct) [id: 6101] /classes/Link.php:113 (__construct) [id: 6111] /classes/Link.php:113 (__construct) [id: 6110] /classes/Link.php:113 (__construct) [id: 6109] /classes/Link.php:113 (__construct) [id: 6108] /classes/Link.php:113 (__construct) [id: 6107] /classes/Link.php:113 (__construct) [id: 6106] /classes/Link.php:113 (__construct) [id: 6105] /classes/Link.php:113 (__construct) [id: 6103] /classes/Link.php:113 (__construct) [id: 6102] /classes/Link.php:113 (__construct) [id: 6101] /classes/Link.php:113 (__construct) [id: 556] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 556] /classes/Link.php:113 (__construct) [id: 556] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 556] /classes/Link.php:113 (__construct) [id: 556]
Country	18	/config/config.inc.php:146 (__construct) [id: 44] /classes/controller/FrontController.php:345 (__construct) [id: 44] /classes/AddressFormat.php:404 (__construct) [id: 44] /classes/controller/FrontController.php:1652 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44]
Address	18	/classes/shop/Shop.php:479 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /classes/Product.php:3622 (initialize) [id: ] /classes/Product.php:3730 (__construct) [id: ] /classes/Product.php:5797 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0]
Customer	15	/config/config.inc.php:264 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0]
WhatsappChatBlockAgent	15	/modules/whatsappchat/whatsappchat.php:290 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ]
Category	14	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 100] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 200] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 300] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 400] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 600] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 700] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 852] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/leopopupsale/leopopupsale.php:659 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 2]
WhatsappChatBlock	14	/modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ]
ApPageBuilderModel	2	/modules/appagebuilder/appagebuilder.php:2060 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2574 (__construct) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:577 (__construct) [id: 1]
ApPageBuilderProfilesModel	2	/modules/appagebuilder/appagebuilder.php:3349 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2868 (__construct) [id: ]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:700 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:414 (__construct) [id: ] /classes/controller/FrontController.php:484 (__construct) [id: ]
State	2	/classes/AddressFormat.php:404 (__construct) [id: 0] /classes/controller/FrontController.php:1651 (__construct) [id: 0]
LeoWidget	2	/modules/leobootstrapmenu/leobootstrapmenu.php:85 (__construct) [id: ] /modules/leobootstrapmenu/leobootstrapmenu.php:85 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Configuration	1	/modules/appagebuilder/appagebuilder.php:2263 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1579 (__construct) [id: ]
AddressFormat	1	/classes/controller/FrontController.php:1646 (generateAddress) [id: ]
Gender	1	/classes/controller/FrontController.php:1576 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
ShopGroup	1	/classes/shop/Shop.php:554 (__construct) [id: 1]
Combination	1	/classes/Product.php:5743 (__construct) [id: 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/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/ralouphie/getallheaders/src/getallheaders.php
17	/vendor/symfony/deprecation-contracts/function.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/guzzlehttp/promises/src/functions_include.php
21	/vendor/guzzlehttp/promises/src/functions.php
22	/vendor/symfony/polyfill-php80/bootstrap.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/swiftmailer/swiftmailer/lib/swift_required.php
29	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/symfony/polyfill-php73/bootstrap.php
32	/vendor/symfony/polyfill-php81/bootstrap.php
33	/vendor/ircmaxell/password-compat/lib/password.php
34	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
35	/vendor/prestashop/laminas-code-lts/polyfill/ReflectionEnumPolyfill.php
36	/app/AppKernel.php
37	/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
38	/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
39	/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php