Repostería

Colorante Celeste, en pasta. Varias tonalidades

$ 1.501,35

Colorante en pasta, comestible. REFERENCIAS: Celeste: color pastel, ideal para prendas de bebé. Celeste B: color pastel, celeste...

Lista de deseos

Comparar

Quick view

Colorante Verde, en pasta. Varias tonalidades

$ 1.674,17

Colorante en pasta, comestible. REFERENCIAS: Verde: color oscuro, verde esmeralda. Verde W: color pastel, verde agua. Verde M:...

Lista de deseos

Comparar

Quick view

Colorante Azul, en pasta. Varias tonalidades

$ 1.674,17

Colorante en pasta, comestible. REFERENCIAS: Azul: color intenso, azul tradicional. Azul F: color brillante, azul francia Azul M:...

Lista de deseos

Comparar

Load Time	1327 ms
Querying Time	445 ms
Queries	382
Memory Peak Usage	49.8 Mb
Included Files	865 files - 11.60 Mb
PrestaShop Cache	- Mb
Global vars	0.90 Mb
- global $_MODULES	587k
- global $context	262k
- 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	156.022 ms	156.022 ms	19.18 Mb	19.5 Mb
__construct	42.124 ms	198.146 ms	1.89 Mb	22.5 Mb
init	122.327 ms	320.473 ms	6.11 Mb	28.2 Mb
checkAccess	0.001 ms	320.474 ms	- Mb	28.2 Mb
setMedia	7.220 ms	327.694 ms	0.74 Mb	28.2 Mb
postProcess	0.001 ms	327.695 ms	- Mb	28.2 Mb
initHeader	0.002 ms	327.697 ms	- Mb	28.2 Mb
initContent	790.458 ms	1118 ms	15.32 Mb	43.3 Mb
initFooter	0.001 ms	1118 ms	- Mb	43.3 Mb
display	208.914 ms	1327 ms	6.45 Mb	49.8 Mb

Hook	Time	Memory Usage
Header	289.473 ms	2.68 Mb
=> leoslideshow	0.364 ms	- Mb
=> leofeature	0.454 ms	0.02 Mb
=> leoquicklogin	0.203 ms	- Mb
=> eicaptcha	0.007 ms	- Mb
=> leopopupsale	287.815 ms	2.62 Mb
=> xmlfeeds	0.463 ms	0.03 Mb
=> mercadopago	0.167 ms	- Mb
DisplayHeader	87.053 ms	2.08 Mb
=> ps_shoppingcart	0.058 ms	- Mb
=> ps_searchbar	0.183 ms	- Mb
=> leoblog	0.113 ms	- Mb
=> ps_googleanalytics	0.135 ms	0.01 Mb
=> leobootstrapmenu	0.958 ms	0.05 Mb
=> appagebuilder	84.293 ms	1.98 Mb
=> ets_contactform7	0.007 ms	- Mb
=> whatsappchat	1.306 ms	0.04 Mb
ModuleRoutes	42.276 ms	0.46 Mb
=> leoblog	1.522 ms	- Mb
=> appagebuilder	36.032 ms	0.05 Mb
=> ets_contactform7	4.722 ms	1.05 Mb
displayTop	19.056 ms	2.02 Mb
=> ps_searchbar (widget)	0.310 ms	0.01 Mb
=> ps_customersignin (widget)	0.509 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.268 ms	0.01 Mb
=> appagebuilder (widget)	17.969 ms	1.97 Mb
DisplayLeoProfileProduct	13.326 ms	1.44 Mb
=> appagebuilder	4.650 ms	0.53 Mb
=> appagebuilder	4.626 ms	0.51 Mb
=> appagebuilder	4.050 ms	0.40 Mb
DisplayBeforeBodyClosingTag	7.325 ms	0.58 Mb
=> ps_googleanalytics	2.143 ms	0.24 Mb
=> leofeature	0.473 ms	0.02 Mb
=> leoquicklogin	1.376 ms	0.10 Mb
=> whatsappchat	3.333 ms	0.23 Mb
displayLeftColumn	2.425 ms	0.12 Mb
=> ps_categorytree (widget)	2.090 ms	0.10 Mb
=> appagebuilder (widget)	0.335 ms	0.01 Mb
DisplayLeoCartButton	2.134 ms	0.13 Mb
=> leofeature	0.700 ms	0.05 Mb
=> leofeature	0.753 ms	0.04 Mb
=> leofeature	0.681 ms	0.04 Mb
ProductSearchProvider	2.111 ms	0.22 Mb
=> ps_facetedsearch	2.111 ms	0.22 Mb
ActionFrontControllerSetMedia	1.258 ms	0.12 Mb
=> ps_emailsubscription	1.121 ms	0.12 Mb
=> ps_socialfollow	0.058 ms	- Mb
=> ps_emailalerts	0.079 ms	- Mb
DisplayFooter	1.223 ms	0.13 Mb
=> leoslideshow	0.285 ms	0.05 Mb
=> leoquicklogin	0.007 ms	- Mb
=> ets_contactform7	0.215 ms	0.02 Mb
=> whatsappchat	0.711 ms	0.05 Mb
=> leopopupsale	0.005 ms	- Mb
DisplayNav2	0.973 ms	0.10 Mb
=> leoslideshow	0.337 ms	0.05 Mb
=> leoquicklogin	0.010 ms	- Mb
=> ets_contactform7	0.230 ms	0.02 Mb
=> whatsappchat	0.396 ms	0.03 Mb
DisplayLeoWishlistButton	0.936 ms	0.07 Mb
=> leofeature	0.310 ms	0.03 Mb
=> leofeature	0.308 ms	0.02 Mb
=> leofeature	0.318 ms	0.02 Mb
displayBanner	0.850 ms	0.06 Mb
=> appagebuilder (widget)	0.850 ms	0.06 Mb
DisplayLeftColumn	0.828 ms	0.12 Mb
=> ps_facetedsearch	0.193 ms	0.06 Mb
=> leoslideshow	0.382 ms	0.04 Mb
=> leoquicklogin	0.011 ms	- Mb
=> ets_contactform7	0.242 ms	0.02 Mb
DisplayNav1	0.757 ms	0.08 Mb
=> leoslideshow	0.357 ms	0.05 Mb
=> leoquicklogin	0.010 ms	- Mb
=> whatsappchat	0.390 ms	0.03 Mb
DisplayTop	0.642 ms	0.08 Mb
=> leoslideshow	0.396 ms	0.05 Mb
=> leoquicklogin	0.010 ms	- Mb
=> ets_contactform7	0.236 ms	0.02 Mb
DisplayFooterAfter	0.609 ms	0.07 Mb
=> leoslideshow	0.317 ms	0.05 Mb
=> leoquicklogin	0.009 ms	- Mb
=> leopopupsale	0.283 ms	0.02 Mb
DisplayLeoCompareButton	0.598 ms	0.01 Mb
=> leofeature	0.219 ms	0.01 Mb
=> leofeature	0.191 ms	- Mb
=> leofeature	0.188 ms	- Mb
DisplayBanner	0.541 ms	0.03 Mb
=> whatsappchat	0.541 ms	0.03 Mb
Top	0.431 ms	0.03 Mb
=> whatsappchat	0.431 ms	0.03 Mb
DisplayWrapperBottom	0.423 ms	0.02 Mb
=> whatsappchat	0.423 ms	0.02 Mb
LeftColumn	0.400 ms	0.02 Mb
=> leoblog	0.005 ms	- Mb
=> whatsappchat	0.395 ms	0.02 Mb
PagebuilderConfig	0.372 ms	0.05 Mb
=> appagebuilder	0.174 ms	0.02 Mb
=> appagebuilder	0.198 ms	0.03 Mb
DisplayNavFullWidth	0.359 ms	0.05 Mb
=> leoslideshow	0.349 ms	0.05 Mb
=> leoquicklogin	0.010 ms	- Mb
DisplayFooterBefore	0.317 ms	0.05 Mb
=> leoslideshow	0.309 ms	0.05 Mb
=> leoquicklogin	0.008 ms	- Mb
displayNav1	0.315 ms	0.01 Mb
=> appagebuilder (widget)	0.315 ms	0.01 Mb
displayNav2	0.312 ms	0.01 Mb
=> appagebuilder (widget)	0.312 ms	0.01 Mb
displayFooterBefore	0.297 ms	0.02 Mb
=> appagebuilder (widget)	0.297 ms	0.02 Mb
displayFooterAfter	0.291 ms	0.05 Mb
=> appagebuilder (widget)	0.291 ms	0.05 Mb
displayNavFullWidth	0.285 ms	0.01 Mb
=> appagebuilder (widget)	0.285 ms	0.01 Mb
displayFooter	0.273 ms	0.01 Mb
=> appagebuilder (widget)	0.273 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.265 ms	0.01 Mb
=> leoquicklogin	0.265 ms	0.01 Mb
FilterCategoryContent	0.200 ms	0.01 Mb
=> appagebuilder	0.200 ms	0.01 Mb
ActionOutputHTMLBefore	0.146 ms	- Mb
=> appagebuilder	0.077 ms	- Mb
=> ets_contactform7	0.069 ms	- Mb
FilterHtmlContent	0.009 ms	- Mb
=> appagebuilder	0.003 ms	- Mb
=> appagebuilder	0.004 ms	- Mb
=> appagebuilder	0.002 ms	- Mb
DisplayWrapperTop	0.005 ms	- Mb
=> mercadopago	0.005 ms	- Mb
37 hook(s)	479.094 ms	10.95 Mb

Module	Time	Memory Usage
leoblog	77.660 ms	- Mb
__construct	76.012 ms	0.61 Mb
hookModuleRoutes	1.527 ms	- Mb
hookDisplayHeader	0.114 ms	- Mb
hookLeftColumn	0.007 ms	- Mb
appagebuilder	249.742 ms	9.26 Mb
__construct	94.452 ms	3.55 Mb
hookModuleRoutes	36.036 ms	0.05 Mb
hookFilterHtmlContent	0.006 ms	- Mb
hookFilterCategoryContent	0.202 ms	0.01 Mb
hookFilterHtmlContent	0.007 ms	- Mb
hookFilterHtmlContent	0.005 ms	- Mb
hookDisplayHeader	84.296 ms	1.98 Mb
displayBanner	0.854 ms	0.06 Mb
displayNav1	0.318 ms	0.02 Mb
displayNav2	0.314 ms	0.02 Mb
displayTop	17.972 ms	1.97 Mb
displayNavFullWidth	0.287 ms	0.02 Mb
displayLeftColumn	0.338 ms	0.02 Mb
hookPagebuilderConfig	0.177 ms	0.02 Mb
hookPagebuilderConfig	0.200 ms	0.03 Mb
hookDisplayLeoProfileProduct	4.652 ms	0.53 Mb
hookDisplayLeoProfileProduct	4.628 ms	0.51 Mb
hookDisplayLeoProfileProduct	4.051 ms	0.40 Mb
displayFooterBefore	0.299 ms	0.02 Mb
displayFooter	0.275 ms	0.02 Mb
displayFooterAfter	0.293 ms	0.05 Mb
hookActionOutputHTMLBefore	0.080 ms	- Mb
ets_contactform7	19.938 ms	2.91 Mb
__construct	14.202 ms	1.77 Mb
hookModuleRoutes	4.726 ms	1.05 Mb
hookDisplayHeader	0.009 ms	- Mb
hookDisplayNav2	0.232 ms	0.02 Mb
hookDisplayTop	0.238 ms	0.02 Mb
hookDisplayLeftColumn	0.244 ms	0.02 Mb
hookDisplayFooter	0.217 ms	0.02 Mb
hookActionOutputHTMLBefore	0.070 ms	- Mb
ps_emailsubscription	3.591 ms	0.41 Mb
__construct	2.466 ms	0.29 Mb
hookActionFrontControllerSetMedia	1.125 ms	0.12 Mb
ps_socialfollow	0.601 ms	0.06 Mb
__construct	0.540 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.061 ms	- Mb
ps_emailalerts	2.475 ms	0.25 Mb
__construct	2.393 ms	0.25 Mb
hookActionFrontControllerSetMedia	0.082 ms	- Mb
ps_shoppingcart	0.738 ms	0.05 Mb
__construct	0.407 ms	0.04 Mb
hookDisplayHeader	0.061 ms	- Mb
displayTop	0.270 ms	0.01 Mb
ps_searchbar	0.706 ms	0.04 Mb
__construct	0.207 ms	0.03 Mb
hookDisplayHeader	0.185 ms	- Mb
displayTop	0.314 ms	0.01 Mb
ps_googleanalytics	2.744 ms	0.30 Mb
__construct	0.461 ms	0.05 Mb
hookDisplayHeader	0.137 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	2.146 ms	0.24 Mb
leobootstrapmenu	9.075 ms	1.01 Mb
__construct	8.113 ms	0.95 Mb
hookDisplayHeader	0.962 ms	0.05 Mb
leoslideshow	9.047 ms	2.38 Mb
__construct	5.928 ms	1.95 Mb
hookHeader	0.368 ms	0.01 Mb
hookDisplayNav1	0.360 ms	0.05 Mb
hookDisplayNav2	0.340 ms	0.05 Mb
hookDisplayTop	0.399 ms	0.05 Mb
hookDisplayNavFullWidth	0.351 ms	0.05 Mb
hookDisplayLeftColumn	0.384 ms	0.04 Mb
hookDisplayFooterBefore	0.311 ms	0.05 Mb
hookDisplayFooter	0.287 ms	0.06 Mb
hookDisplayFooterAfter	0.319 ms	0.05 Mb
leofeature	9.344 ms	0.84 Mb
__construct	4.718 ms	0.58 Mb
hookHeader	0.462 ms	0.02 Mb
hookDisplayLeoCartButton	0.702 ms	0.05 Mb
hookDisplayLeoWishlistButton	0.313 ms	0.03 Mb
hookDisplayLeoCompareButton	0.221 ms	0.01 Mb
hookDisplayLeoCartButton	0.756 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.310 ms	0.02 Mb
hookDisplayLeoCompareButton	0.193 ms	- Mb
hookDisplayLeoCartButton	0.684 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.320 ms	0.02 Mb
hookDisplayLeoCompareButton	0.190 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.475 ms	0.02 Mb
leoquicklogin	5.000 ms	0.53 Mb
__construct	3.057 ms	0.42 Mb
hookHeader	0.207 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.269 ms	0.01 Mb
hookDisplayNav1	0.012 ms	- Mb
hookDisplayNav2	0.012 ms	- Mb
hookDisplayTop	0.012 ms	- Mb
hookDisplayNavFullWidth	0.011 ms	- Mb
hookDisplayLeftColumn	0.013 ms	- Mb
hookDisplayFooterBefore	0.009 ms	- Mb
hookDisplayFooter	0.009 ms	- Mb
hookDisplayFooterAfter	0.010 ms	- Mb
hookDisplayBeforeBodyClosingTag	1.379 ms	0.10 Mb
eicaptcha	0.869 ms	0.10 Mb
__construct	0.859 ms	0.10 Mb
hookHeader	0.010 ms	- Mb
whatsappchat	11.576 ms	0.87 Mb
__construct	3.625 ms	0.40 Mb
hookDisplayHeader	1.309 ms	0.04 Mb
hookDisplayBanner	0.544 ms	0.03 Mb
hookDisplayNav1	0.393 ms	0.03 Mb
hookDisplayNav2	0.399 ms	0.03 Mb
hookTop	0.433 ms	0.03 Mb
hookLeftColumn	0.397 ms	0.02 Mb
hookDisplayWrapperBottom	0.426 ms	0.02 Mb
hookDisplayFooter	0.713 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	3.337 ms	0.23 Mb
leopopupsale	289.587 ms	2.76 Mb
__construct	1.475 ms	0.12 Mb
hookHeader	287.820 ms	2.62 Mb
hookDisplayFooter	0.007 ms	- Mb
hookDisplayFooterAfter	0.285 ms	0.02 Mb
xmlfeeds	4.839 ms	0.59 Mb
__construct	4.372 ms	0.55 Mb
hookHeader	0.467 ms	0.04 Mb
mercadopago	85.527 ms	0.94 Mb
__construct	85.350 ms	0.94 Mb
hookHeader	0.170 ms	- Mb
hookDisplayWrapperTop	0.007 ms	- Mb
ps_facetedsearch	6.240 ms	0.67 Mb
__construct	3.929 ms	0.38 Mb
hookProductSearchProvider	2.116 ms	0.22 Mb
hookDisplayLeftColumn	0.195 ms	0.06 Mb
ps_customersignin	0.728 ms	0.05 Mb
__construct	0.216 ms	0.02 Mb
displayTop	0.512 ms	0.03 Mb
ps_categorytree	75.777 ms	0.17 Mb
__construct	73.683 ms	0.07 Mb
displayLeftColumn	2.094 ms	0.10 Mb
21 module(s)	866 ms	24.15 Mb

FORMITAS DECORMAGIC x50g...

Placa bombon diamantes "La...

PALA REBATIBLE B.J

Repostería

Repostería

Colorante Celeste, en pasta. Varias tonalidades

Colorante Verde, en pasta. Varias tonalidades

Colorante Azul, en pasta. Varias tonalidades

ENTREGA RÁPIDA

OFERTAS PERMANENTES

PAGO SEGURO

SITIO SEGURO

Contáctenos

Horarios

Información

Mi cuenta

Stopwatch SQL - 382 queries

Doubles

Tables stress

ObjectModel instances

Included Files

#	Query	Time (ms)	Rows	Filesort	Group By	Location
145	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	78.523 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)
181	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6103) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	76.205 ms	1			/classes/stock/StockAvailable.php:452 /classes/Product.php:4235 (getQuantityAvailableByProduct) /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)
97	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	68.429 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)
63	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1	57.650 ms	0			/classes/module/Module.php:2631 /classes/module/Module.php:2103 (getModuleIdByName) /classes/controller/FrontController.php:1543 (isEnabled) /classes/controller/FrontController.php:1686 (getDisplayTaxesLabel) /controllers/front/listing/CategoryController.php:258 (getTemplateVarPage) /classes/controller/FrontController.php:492 (getTemplateVarPage) /classes/controller/FrontController.php:555 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE p., ps.,pl.* FROM ps_appagebuilder_profiles p INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles) INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles) WHERE id_shop=1 AND id_lang=1	35.874 ms	12			/modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:137 /modules/appagebuilder/appagebuilder.php:3350 (getAllProfileByShop) /classes/Hook.php:983 (hookModuleRoutes) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
232	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("08d23fcb2ce77366ffdedd6ea82d62c5", "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:108;a:2:{s:4:\"name\";s:10:\"Colorantes\";s:3:\"nbr\";s:1:\"3\";}}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:\"3\";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;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:3;}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:1501;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:3;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:5:{s:4:\"name\";s:4:\"Azul\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}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:4:{s:4:\"name\";s:10:\"Amarillo H\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}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:5:{s:4:\"name\";s:7:\"Verde Y\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}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:5:{s:4:\"name\";s:9:\"Celeste C\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}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.677 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)
180	SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6103 AND `id_group` = 1 LIMIT 1	4.283 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3916 (getValueForProduct) /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)
146	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) 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 = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 6107)	3.862 ms	1			/classes/Product.php:3786 /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)
119	SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0	3.724 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)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	3.691 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)
27	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	3.201 ms	1073			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /modules/ets_contactform7/ets_contactform7.php:972 (get) /classes/Hook.php:983 (hookModuleRoutes) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
152	SELECT SQL_NO_CACHE 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 = 1) WHERE i.`id_product` = 6106 AND image_shop.`cover` = 1 LIMIT 1	2.892 ms	1			/classes/Product.php:3501 /classes/Product.php:5501 (getCover) /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)
228	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 IN (32, 69, 81))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=46 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 IN (32, 69, 81))) GROUP BY p.id_manufacturer	2.864 ms	2916	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)
231	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='63' AND c.nleft>=3 AND c.nright<=46 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	2.784 ms	2209	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)
226	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 IN (32, 69, 81))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='63' AND c.nleft>=3 AND c.nright<=46 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 IN (32, 69, 81))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>3 AND c.nright<46 GROUP BY cp.id_category	2.628 ms	58320	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)
96	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.067 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)
224	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 IN (32, 69, 81))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='63' AND c.nleft>=3 AND c.nright<=46 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 IN (32, 69, 81))) GROUP BY fp.id_feature_value	1.881 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: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.689 ms	116	Yes	Yes	/classes/Hook.php:1172 /classes/Hook.php:689 (getAllHookRegistrations) /classes/Hook.php:793 (getHookModuleExecList) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
222	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 IN (32, 69, 81))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='63' AND c.nleft>=3 AND c.nright<=46 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.565 ms	2916	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)
7	SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1	1.293 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:554 (__construct) /config/config.inc.php:171 (getGroup) /index.php:27 (require)
87	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.241 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)
230	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 IN (32, 69, 81))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='63' AND c.nleft>=3 AND c.nright<=46	1.083 ms	54			/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)
4	SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1	0.976 ms	1			/classes/shop/Shop.php:215 /classes/shop/Shop.php:145 (setUrl) /classes/shop/Shop.php:425 (__construct) /config/config.inc.php:117 (initialize) /index.php:27 (require)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.961 ms	1008			/classes/Hook.php:1271 /classes/Hook.php:764 (getHookStatusByName) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
329	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` <= 6 AND nleft >= 3 AND nright <= 46 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.876 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_666b09906c80c8_30491260) /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_666b09906a92b1_94491144) /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_666b09906a30a4_68393111) /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_666b09905586d1_88505258) /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)
219	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.858 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)
218	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.818 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)
229	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 IN (32, 69, 81))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='63' AND c.nleft>=3 AND c.nright<=46	0.806 ms	54			/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)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.746 ms	1008			/classes/Hook.php:1231 /classes/Hook.php:218 (getAllHookIds) /classes/Hook.php:802 (getIdByName) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
45	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` = 100 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.709 ms	14	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)
24	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.704 ms	84			/classes/module/Module.php:344 /modules/appagebuilder/appagebuilder.php:62 (__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) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
153	SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1	0.673 ms	1			/classes/Product.php:5517 /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)
150	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.665 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)
3	SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1	0.643 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:142 (__construct) /classes/shop/Shop.php:425 (__construct) /config/config.inc.php:117 (initialize) /index.php:27 (require)
157	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.576 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)
16	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.575 ms	84			/classes/module/Module.php:344 /modules/leoblog/leoblog.php:43 (__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) /override/classes/Dispatcher.php:28 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
227	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.550 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)
80	SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `active` = 1 ORDER BY position	0.538 ms	1	Yes		/modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71 /modules/whatsappchat/whatsappchat.php:291 (getWhatsappChatAgents) /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)
225	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.537 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)
182	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` = 6103 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` = 6103 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.515 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)

28 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
16 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
14 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
14 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
13 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
13 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
13 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
13 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)
13 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
13 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
13 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 `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 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
6 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
4 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
3 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product = XX LIMIT XX
3 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
3 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
3 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
3 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
3 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` 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) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
3 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
3 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
3 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
3 queries	SELECT pa., product_attribute_shop. FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
3 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
3 queries	SELECT al.`name` AS attribute_name FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
2 queries	SELECT 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`)
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'es-es' OR `language_code` = 'es-es' LIMIT XX
2 queries	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX 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 * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = 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 pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
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

Name	Instances	Source
Product	35	/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: 566] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 566] /classes/Link.php:113 (__construct) [id: 564] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 564] /classes/Link.php:113 (__construct) [id: 558] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 558] /classes/Link.php:113 (__construct) [id: 566] /classes/Link.php:113 (__construct) [id: 564] /classes/Link.php:113 (__construct) [id: 558] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 566] /classes/Link.php:113 (__construct) [id: 566] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 564] /classes/Link.php:113 (__construct) [id: 564] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 558] /classes/Link.php:113 (__construct) [id: 558]
Category	21	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 100] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 101] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 102] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 104] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 105] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 106] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 107] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 108] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 109] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 110] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 111] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 810] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 818] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 843] /classes/Meta.php:380 (__construct) [id: 100] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/leopopupsale/leopopupsale.php:659 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 100] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 100] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 100]
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: ]
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: ]
Combination	3	/classes/Product.php:5743 (__construct) [id: 84] /classes/Product.php:5743 (__construct) [id: 72] /classes/Product.php:5743 (__construct) [id: 32]
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: ]
Configuration	1	/modules/appagebuilder/appagebuilder.php:2263 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
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]
Risk	1	/classes/controller/FrontController.php:1579 (__construct) [id: ]

#	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