Decoraciòn

¡En oferta!

Quick view

ADORNO MARIPOSA 3D

$ 1.524,34

Lista de deseos

Comparar

Quick view

MICRO CEREAL CON CHOCOLATE BLANCO COLOREADO

$ 2.750,81

DIFERENTES COLORES (IMAGEN ILUSTRATIVA) ENTRAR A LA IMAGEN Y SELECCIONAR EL COLOR PREFERIDO

Lista de deseos

Comparar

Quick view

Flor de azucar

$ 1.366,20

*PREGUNTAR POR DISPONIBILIDAD DE COLORES*

Lista de deseos

Comparar

Quick view

BENGALA CON GIBRE

$ 720,00

Lista de deseos

Comparar

Quick view

BENGALAS MAGICAS X UNID

$ 399,74

Lista de deseos

Comparar

Quick view

GRANAS X 100 g

$ 480,66

Potes de granas por 100 g de colores ideal para d ecorar cupcakes , tortas , masitas, trufas .. y mas ......

Lista de deseos

Comparar

Quick view

MARCADOR COMESTIBLE X UNIDAD

$ 1.080,86

COLORES EN STOCK : AMARILLO NARANJA ROJO AZUL VERDE NEGRO PIEL VIOLETA CELESTE MARRON VERDE OSCURO ROSA

Lista de deseos

Comparar

Load Time	1521 ms
Querying Time	529 ms
Queries	521
Memory Peak Usage	52.9 Mb
Included Files	854 files - 11.39 Mb
PrestaShop Cache	- Mb
Global vars	0.90 Mb
- global $_MODULES	567k
- global $context	273k
- 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	98.156 ms	98.156 ms	18.41 Mb	18.7 Mb
__construct	6.835 ms	104.991 ms	1.82 Mb	21.7 Mb
init	211.658 ms	316.649 ms	5.99 Mb	27.5 Mb
checkAccess	0.002 ms	316.651 ms	- Mb	27.5 Mb
setMedia	76.354 ms	393.005 ms	0.80 Mb	27.5 Mb
postProcess	0.001 ms	393.006 ms	- Mb	27.5 Mb
initHeader	0.001 ms	393.007 ms	- Mb	27.5 Mb
initContent	821 ms	1214 ms	16.20 Mb	43.4 Mb
initFooter	0.002 ms	1214 ms	- Mb	43.4 Mb
display	307.095 ms	1521 ms	9.52 Mb	52.9 Mb

Hook	Time	Memory Usage
Header	209.493 ms	2.70 Mb
=> leoslideshow	0.322 ms	- Mb
=> leofeature	0.491 ms	0.02 Mb
=> leoquicklogin	0.198 ms	- Mb
=> eicaptcha	0.007 ms	- Mb
=> leopopupsale	207.673 ms	2.64 Mb
=> xmlfeeds	0.463 ms	0.03 Mb
=> mercadopago	0.339 ms	- Mb
DisplayHeader	179.020 ms	2.14 Mb
=> ps_shoppingcart	0.065 ms	- Mb
=> ps_searchbar	0.201 ms	- Mb
=> ps_googleanalytics	0.128 ms	0.01 Mb
=> leobootstrapmenu	0.839 ms	0.05 Mb
=> appagebuilder	100.228 ms	1.98 Mb
=> ets_contactform7	0.007 ms	- Mb
=> whatsappchat	77.552 ms	0.10 Mb
DisplayLeoProfileProduct	109.628 ms	4.42 Mb
=> appagebuilder	6.294 ms	0.68 Mb
=> appagebuilder	5.852 ms	0.47 Mb
=> appagebuilder	5.759 ms	0.70 Mb
=> appagebuilder	74.533 ms	0.78 Mb
=> appagebuilder	4.493 ms	0.40 Mb
=> appagebuilder	6.389 ms	0.70 Mb
=> appagebuilder	6.308 ms	0.70 Mb
ProductSearchProvider	73.933 ms	0.16 Mb
=> ps_facetedsearch	73.933 ms	0.16 Mb
DisplayLeoWishlistButton	71.015 ms	0.15 Mb
=> leofeature	0.415 ms	0.03 Mb
=> leofeature	0.705 ms	0.02 Mb
=> leofeature	0.301 ms	0.02 Mb
=> leofeature	68.479 ms	0.02 Mb
=> leofeature	0.376 ms	0.02 Mb
=> leofeature	0.388 ms	0.02 Mb
=> leofeature	0.351 ms	0.02 Mb
displayTop	18.277 ms	2.01 Mb
=> ps_searchbar (widget)	0.327 ms	0.01 Mb
=> ps_customersignin (widget)	0.547 ms	0.03 Mb
=> ps_shoppingcart (widget)	0.307 ms	0.01 Mb
=> appagebuilder (widget)	17.096 ms	1.97 Mb
DisplayBeforeBodyClosingTag	9.574 ms	0.63 Mb
=> ps_googleanalytics	3.721 ms	0.27 Mb
=> leofeature	0.513 ms	0.01 Mb
=> leoquicklogin	1.443 ms	0.12 Mb
=> whatsappchat	3.897 ms	0.23 Mb
DisplayLeoCartButton	6.221 ms	0.30 Mb
=> leofeature	1.012 ms	0.05 Mb
=> leofeature	1.033 ms	0.04 Mb
=> leofeature	0.702 ms	0.04 Mb
=> leofeature	0.931 ms	0.04 Mb
=> leofeature	0.813 ms	0.04 Mb
=> leofeature	0.893 ms	0.04 Mb
=> leofeature	0.837 ms	0.04 Mb
displayLeftColumn	1.888 ms	0.10 Mb
=> ps_categorytree (widget)	1.612 ms	0.08 Mb
=> appagebuilder (widget)	0.276 ms	0.01 Mb
DisplayLeoCompareButton	1.680 ms	- Mb
=> leofeature	0.245 ms	0.01 Mb
=> leofeature	0.355 ms	- Mb
=> leofeature	0.180 ms	- Mb
=> leofeature	0.229 ms	- Mb
=> leofeature	0.241 ms	- Mb
=> leofeature	0.224 ms	- Mb
=> leofeature	0.206 ms	- Mb
DisplayFooter	1.406 ms	0.13 Mb
=> leoslideshow	0.377 ms	0.05 Mb
=> leoquicklogin	0.023 ms	- Mb
=> ets_contactform7	0.239 ms	0.02 Mb
=> whatsappchat	0.762 ms	0.05 Mb
=> leopopupsale	0.005 ms	- Mb
ActionFrontControllerSetMedia	1.101 ms	0.18 Mb
=> ps_emailsubscription	0.956 ms	0.18 Mb
=> ps_socialfollow	0.053 ms	- Mb
=> ps_emailalerts	0.092 ms	- Mb
DisplayNav2	1.080 ms	0.10 Mb
=> leoslideshow	0.409 ms	0.05 Mb
=> leoquicklogin	0.011 ms	- Mb
=> ets_contactform7	0.247 ms	0.02 Mb
=> whatsappchat	0.413 ms	0.03 Mb
DisplayNav1	0.980 ms	0.08 Mb
=> leoslideshow	0.439 ms	0.05 Mb
=> leoquicklogin	0.012 ms	- Mb
=> whatsappchat	0.529 ms	0.03 Mb
displayBanner	0.846 ms	0.06 Mb
=> appagebuilder (widget)	0.846 ms	0.06 Mb
DisplayLeftColumn	0.831 ms	0.11 Mb
=> ps_facetedsearch	0.234 ms	0.04 Mb
=> leoslideshow	0.347 ms	0.05 Mb
=> leoquicklogin	0.010 ms	- Mb
=> ets_contactform7	0.240 ms	0.02 Mb
DisplayTop	0.695 ms	0.08 Mb
=> leoslideshow	0.407 ms	0.05 Mb
=> leoquicklogin	0.012 ms	- Mb
=> ets_contactform7	0.276 ms	0.02 Mb
DisplayFooterAfter	0.685 ms	0.07 Mb
=> leoslideshow	0.364 ms	0.05 Mb
=> leoquicklogin	0.011 ms	- Mb
=> leopopupsale	0.310 ms	0.02 Mb
ModuleRoutes	0.483 ms	0.06 Mb
=> appagebuilder	0.469 ms	0.06 Mb
=> ets_contactform7	0.014 ms	- Mb
Top	0.474 ms	0.03 Mb
=> whatsappchat	0.474 ms	0.03 Mb
DisplayWrapperBottom	0.474 ms	0.02 Mb
=> whatsappchat	0.474 ms	0.02 Mb
DisplayFooterBefore	0.466 ms	0.05 Mb
=> leoslideshow	0.452 ms	0.05 Mb
=> leoquicklogin	0.014 ms	- Mb
DisplayBanner	0.434 ms	0.03 Mb
=> whatsappchat	0.434 ms	0.03 Mb
PagebuilderConfig	0.412 ms	0.05 Mb
=> appagebuilder	0.210 ms	0.02 Mb
=> appagebuilder	0.202 ms	0.03 Mb
DisplayNavFullWidth	0.390 ms	0.05 Mb
=> leoslideshow	0.378 ms	0.05 Mb
=> leoquicklogin	0.012 ms	- Mb
LeftColumn	0.378 ms	0.02 Mb
=> whatsappchat	0.378 ms	0.02 Mb
displayFooterAfter	0.357 ms	0.05 Mb
=> appagebuilder (widget)	0.357 ms	0.05 Mb
displayNav1	0.349 ms	0.01 Mb
=> appagebuilder (widget)	0.349 ms	0.01 Mb
displayNavFullWidth	0.346 ms	0.01 Mb
=> appagebuilder (widget)	0.346 ms	0.01 Mb
displayNav2	0.336 ms	0.01 Mb
=> appagebuilder (widget)	0.336 ms	0.01 Mb
displayFooter	0.325 ms	0.01 Mb
=> appagebuilder (widget)	0.325 ms	0.01 Mb
displayFooterBefore	0.316 ms	0.02 Mb
=> appagebuilder (widget)	0.316 ms	0.02 Mb
DisplayAfterBodyOpeningTag	0.269 ms	0.01 Mb
=> leoquicklogin	0.269 ms	0.01 Mb
FilterCategoryContent	0.160 ms	0.01 Mb
=> appagebuilder	0.160 ms	0.01 Mb
ActionOutputHTMLBefore	0.096 ms	- Mb
=> appagebuilder	0.076 ms	- Mb
=> ets_contactform7	0.020 ms	- Mb
FilterHtmlContent	0.011 ms	- Mb
=> appagebuilder	0.003 ms	- Mb
=> appagebuilder	0.004 ms	- Mb
=> appagebuilder	0.004 ms	- Mb
DisplayWrapperTop	0.007 ms	- Mb
=> mercadopago	0.007 ms	- Mb
37 hook(s)	694.436 ms	13.87 Mb

Module	Time	Memory Usage
appagebuilder	328.628 ms	11.48 Mb
__construct	97.332 ms	2.79 Mb
hookModuleRoutes	0.475 ms	0.06 Mb
hookFilterHtmlContent	0.006 ms	- Mb
hookFilterCategoryContent	0.162 ms	0.01 Mb
hookFilterHtmlContent	0.007 ms	- Mb
hookFilterHtmlContent	0.007 ms	- Mb
hookDisplayHeader	100.232 ms	1.98 Mb
displayBanner	0.850 ms	0.06 Mb
displayNav1	0.352 ms	0.02 Mb
displayNav2	0.339 ms	0.02 Mb
displayTop	17.100 ms	1.97 Mb
displayNavFullWidth	0.349 ms	0.02 Mb
displayLeftColumn	0.278 ms	0.02 Mb
hookPagebuilderConfig	0.213 ms	0.02 Mb
hookPagebuilderConfig	0.203 ms	0.03 Mb
hookDisplayLeoProfileProduct	6.295 ms	0.68 Mb
hookDisplayLeoProfileProduct	5.853 ms	0.47 Mb
hookDisplayLeoProfileProduct	5.761 ms	0.70 Mb
hookDisplayLeoProfileProduct	74.534 ms	0.78 Mb
hookDisplayLeoProfileProduct	4.495 ms	0.40 Mb
hookDisplayLeoProfileProduct	6.390 ms	0.70 Mb
hookDisplayLeoProfileProduct	6.310 ms	0.70 Mb
displayFooterBefore	0.319 ms	0.02 Mb
displayFooter	0.328 ms	0.02 Mb
displayFooterAfter	0.359 ms	0.05 Mb
hookActionOutputHTMLBefore	0.079 ms	- Mb
ets_contactform7	94.544 ms	2.50 Mb
__construct	93.487 ms	2.41 Mb
hookModuleRoutes	0.017 ms	- Mb
hookDisplayHeader	0.008 ms	- Mb
hookDisplayNav2	0.249 ms	0.02 Mb
hookDisplayTop	0.278 ms	0.02 Mb
hookDisplayLeftColumn	0.242 ms	0.02 Mb
hookDisplayFooter	0.241 ms	0.02 Mb
hookActionOutputHTMLBefore	0.022 ms	- Mb
ps_emailsubscription	73.203 ms	0.47 Mb
__construct	72.244 ms	0.29 Mb
hookActionFrontControllerSetMedia	0.959 ms	0.18 Mb
ps_socialfollow	0.563 ms	0.06 Mb
__construct	0.508 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.055 ms	- Mb
ps_emailalerts	2.128 ms	0.25 Mb
__construct	2.034 ms	0.25 Mb
hookActionFrontControllerSetMedia	0.094 ms	- Mb
ps_shoppingcart	0.786 ms	0.05 Mb
__construct	0.408 ms	0.04 Mb
hookDisplayHeader	0.068 ms	- Mb
displayTop	0.310 ms	0.01 Mb
ps_searchbar	0.743 ms	0.04 Mb
__construct	0.209 ms	0.03 Mb
hookDisplayHeader	0.203 ms	- Mb
displayTop	0.331 ms	0.01 Mb
ps_googleanalytics	4.247 ms	0.33 Mb
__construct	0.391 ms	0.05 Mb
hookDisplayHeader	0.131 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.725 ms	0.27 Mb
leobootstrapmenu	82.524 ms	1.00 Mb
__construct	81.682 ms	0.95 Mb
hookDisplayHeader	0.842 ms	0.05 Mb
leoslideshow	9.334 ms	1.14 Mb
__construct	5.811 ms	0.71 Mb
hookHeader	0.325 ms	0.01 Mb
hookDisplayNav1	0.442 ms	0.05 Mb
hookDisplayNav2	0.412 ms	0.05 Mb
hookDisplayTop	0.411 ms	0.05 Mb
hookDisplayNavFullWidth	0.381 ms	0.05 Mb
hookDisplayLeftColumn	0.349 ms	0.05 Mb
hookDisplayFooterBefore	0.456 ms	0.05 Mb
hookDisplayFooter	0.380 ms	0.06 Mb
hookDisplayFooterAfter	0.367 ms	0.05 Mb
leofeature	85.252 ms	2.38 Mb
__construct	5.262 ms	1.90 Mb
hookHeader	0.494 ms	0.02 Mb
hookDisplayLeoCartButton	1.016 ms	0.05 Mb
hookDisplayLeoWishlistButton	0.419 ms	0.03 Mb
hookDisplayLeoCompareButton	0.247 ms	0.01 Mb
hookDisplayLeoCartButton	1.038 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.708 ms	0.02 Mb
hookDisplayLeoCompareButton	0.359 ms	- Mb
hookDisplayLeoCartButton	0.705 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.303 ms	0.02 Mb
hookDisplayLeoCompareButton	0.182 ms	- Mb
hookDisplayLeoCartButton	0.934 ms	0.04 Mb
hookDisplayLeoWishlistButton	68.482 ms	0.02 Mb
hookDisplayLeoCompareButton	0.232 ms	- Mb
hookDisplayLeoCartButton	0.817 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.379 ms	0.02 Mb
hookDisplayLeoCompareButton	0.244 ms	- Mb
hookDisplayLeoCartButton	0.897 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.390 ms	0.02 Mb
hookDisplayLeoCompareButton	0.226 ms	- Mb
hookDisplayLeoCartButton	0.840 ms	0.04 Mb
hookDisplayLeoWishlistButton	0.354 ms	0.02 Mb
hookDisplayLeoCompareButton	0.208 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.516 ms	0.01 Mb
leoquicklogin	5.400 ms	0.49 Mb
__construct	3.363 ms	0.35 Mb
hookHeader	0.202 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.274 ms	0.01 Mb
hookDisplayNav1	0.013 ms	- Mb
hookDisplayNav2	0.012 ms	- Mb
hookDisplayTop	0.013 ms	- Mb
hookDisplayNavFullWidth	0.013 ms	- Mb
hookDisplayLeftColumn	0.011 ms	- Mb
hookDisplayFooterBefore	0.015 ms	- Mb
hookDisplayFooter	0.025 ms	- Mb
hookDisplayFooterAfter	0.012 ms	- Mb
hookDisplayBeforeBodyClosingTag	1.447 ms	0.12 Mb
eicaptcha	1.089 ms	0.10 Mb
__construct	1.079 ms	0.10 Mb
hookHeader	0.010 ms	- Mb
whatsappchat	88.471 ms	0.93 Mb
__construct	3.530 ms	0.40 Mb
hookDisplayHeader	77.556 ms	0.10 Mb
hookDisplayBanner	0.437 ms	0.03 Mb
hookDisplayNav1	0.533 ms	0.03 Mb
hookDisplayNav2	0.415 ms	0.03 Mb
hookTop	0.477 ms	0.03 Mb
hookLeftColumn	0.380 ms	0.02 Mb
hookDisplayWrapperBottom	0.477 ms	0.02 Mb
hookDisplayFooter	0.765 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	3.901 ms	0.23 Mb
leopopupsale	209.301 ms	2.78 Mb
__construct	1.306 ms	0.12 Mb
hookHeader	207.677 ms	2.64 Mb
hookDisplayFooter	0.006 ms	- Mb
hookDisplayFooterAfter	0.312 ms	0.02 Mb
xmlfeeds	5.509 ms	0.53 Mb
__construct	5.042 ms	0.49 Mb
hookHeader	0.467 ms	0.04 Mb
mercadopago	7.311 ms	0.94 Mb
__construct	6.960 ms	0.93 Mb
hookHeader	0.342 ms	- Mb
hookDisplayWrapperTop	0.009 ms	- Mb
ps_facetedsearch	78.385 ms	0.65 Mb
__construct	4.212 ms	0.45 Mb
hookProductSearchProvider	73.937 ms	0.16 Mb
hookDisplayLeftColumn	0.236 ms	0.04 Mb
ps_customersignin	0.784 ms	0.05 Mb
__construct	0.233 ms	0.02 Mb
displayTop	0.551 ms	0.03 Mb
ps_categorytree	72.280 ms	0.15 Mb
__construct	70.665 ms	0.07 Mb
displayLeftColumn	1.615 ms	0.08 Mb
20 module(s)	1150 ms	26.35 Mb

Sorbete de Papel...

ESPATULA SCRAPER ACERO N4...

MOL. TORT .ALTA DESMONT N°1...

Decoraciòn

Decoraciòn

ADORNO MARIPOSA 3D

MICRO CEREAL CON CHOCOLATE BLANCO COLOREADO

Flor de azucar

BENGALA CON GIBRE

BENGALAS MAGICAS X UNID

GRANAS X 100 g

MARCADOR COMESTIBLE X UNIDAD

ENTREGA RÁPIDA

OFERTAS PERMANENTES

PAGO SEGURO

SITIO SEGURO

Contáctenos

Horarios

Información

Mi cuenta

Stopwatch SQL - 521 queries

Doubles

Tables stress

ObjectModel instances

Included Files

#	Query	Time (ms)	Rows	Filesort	Group By	Location
103	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` = 6109 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.698 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)
61	SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "header" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;	76.789 ms	1	Yes		/modules/whatsappchat/classes/WhatsappChatBlock.php:130 /modules/whatsappchat/whatsappchat.php:551 (getWhatsappChatByHook) /modules/whatsappchat/whatsappchat.php:306 (displayBlock) /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)
171	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6102) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	70.601 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)
299	SELECT SQL_NO_CACHE * 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` = 1 WHERE (a.`id_product_attribute` = 312) LIMIT 1	64.602 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:5743 (__construct) /classes/Product.php:5706 (computeUnitPriceRatio) /classes/ProductAssembler.php:130 (getProductProperties) /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)
210	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 c.nleft>=12 AND c.nright<=15 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	57.449 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)
211	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("9c9573349db52e0f1bae208c59ccb571", "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:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:0:{}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:2751;s:3:\"min\";d:399;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:7;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:29:{i:8;a:4:{s:4:\"name\";s:6:\"VERDE \";s:3:\"nbr\";s:1:\"3\";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:\"5\";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:\"7\";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:\"3\";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:\"6\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:63;a:5:{s:4:\"name\";s:7:\"Violeta\";s:3:\"nbr\";s:1:\"4\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:78;a:4:{s:4:\"name\";s:7:\"Celeste\";s:3:\"nbr\";s:1:\"6\";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:\"2\";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:\"2\";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:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:68;a:5:{s:4:\"name\";s:7:\"Verde M\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}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: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:80;a:4:{s:4:\"name\";s:9:\"Celeste N\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:119;a:4:{s:4:\"name\";s:4:\"ROJO\";s:3:\"nbr\";s:1:\"4\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:120;a:4:{s:4:\"name\";s:5:\"PIEL \";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:121;a:4:{s:4:\"name\";s:6:\"NEGRO \";s:3:\"nbr\";s:1:\"5\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:122;a:4:{s:4:\"name\";s:6:\"Blanco\";s:3:\"nbr\";s:1:\"7\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:123;a:4:{s:4:\"name\";s:11:\"MULTICOLOR \";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:124;a:4:{s:4:\"name\";s:8:\"SURTIDO \";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:125;a:5:{s:4:\"name\";s:7:\"DORADA \";s:3:\"nbr\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:126;a:4:{s:4:\"name\";s:9:\"PLATEADO \";s:3:\"nbr\";s:1:\"4\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:538;a:5:{s:4:\"name\";s:7:\"SURTIDO\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:645;a:4:{s:4:\"name\";s:6:\"MARRON\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:500;a:4:{s:4:\"name\";s:4:\"lila\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:375;a:4:{s:4:\"name\";s:7:\"fuccia \";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:\"2\";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\";}}}")	17.688 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)
3	SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1	8.796 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)
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`)	6.585 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)
205	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 (63, 68, 125, 538))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=15 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 (63, 68, 125, 538))) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>12 AND c.nright<15 GROUP BY cp.id_category	3.440 ms	76313	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)
0	SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.papelerapitti.com.ar' OR su.domain_ssl = 'www.papelerapitti.com.ar') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	3.339 ms	1	Yes		/classes/shop/Shop.php:1356 /classes/shop/Shop.php:351 (findShopByHost) /config/config.inc.php:117 (initialize) /index.php:27 (require)
207	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 (63, 68, 125, 538))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=15 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 (63, 68, 125, 538))) GROUP BY p.id_manufacturer	2.699 ms	4489	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)
1	SELECT SQL_NO_CACHE gs., s., gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name	2.380 ms	1	Yes		/classes/shop/Shop.php:708 /classes/shop/Shop.php:767 (cacheShops) /classes/Configuration.php:306 (getShops) /classes/shop/Shop.php:394 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
104	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` = 6109)	2.334 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)
76	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.181 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)
99	SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0	2.164 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)
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	2.127 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)
201	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 (63, 68, 125, 538))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=15 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	2.018 ms	4489	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)
186	SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = 6109 AND image_shop.`cover`= 1 LIMIT 1	1.914 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)
77	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.838 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)
108	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	1.823 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)
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.645 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)
203	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 (63, 68, 125, 538))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=15 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 (63, 68, 125, 538))) GROUP BY fp.id_feature_value	1.511 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)
279	SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 767	1.484 ms	11			/classes/Product.php:2833 /src/Adapter/Image/ImageRetriever.php:75 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:672 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:88 (present) :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)
209	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 (63, 68, 125, 538))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=15	1.454 ms	1139			/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)
208	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 (63, 68, 125, 538))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=15	1.310 ms	1139			/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)
67	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.299 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)
198	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.827 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)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.773 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)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.760 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)
197	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.736 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)
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` = 106 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.735 ms	1	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)
5	SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)	0.729 ms	1			/classes/Language.php:1049 /config/config.inc.php:143 (loadLanguages) /index.php:27 (require)
395	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` <= 7 AND nleft >= 12 AND nright <= 15 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.673 ms	6	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)
137	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.654 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)
360	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 680) AND (id_product_attribute = 166) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	0.579 ms	1			/classes/stock/StockAvailable.php:452 /classes/Product.php:4235 (getQuantityAvailableByProduct) /classes/Product.php:5652 (getQuantity) /classes/ProductAssembler.php:130 (getProductProperties) /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)
206	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.576 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)
303	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 = 689 LIMIT 1	0.530 ms	5			/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)
236	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 = 4695 LIMIT 1	0.526 ms	7			/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)
204	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.523 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)
122	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6107) AND (b.`id_shop` = 1) LIMIT 1	0.522 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:720 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5518 (getProductLink) /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)

84 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
24 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
18 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
17 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
17 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
17 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
17 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)
17 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
17 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
17 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
10 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
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
7 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
7 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
7 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
7 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
7 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
7 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`
7 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
7 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
7 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
7 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`
7 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;
7 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
4 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 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
2 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
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 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, XX, XX, XX, XX, 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
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;
2 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation 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) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute

Name	Instances	Source
Product	55	/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: 5376] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 5376] /classes/Link.php:113 (__construct) [id: 4695] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 4695] /classes/Link.php:113 (__construct) [id: 767] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 767] /classes/Link.php:113 (__construct) [id: 697] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 697] /classes/Link.php:113 (__construct) [id: 689] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 689] /classes/Link.php:113 (__construct) [id: 686] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 686] /classes/Link.php:113 (__construct) [id: 680] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 680] /classes/Link.php:113 (__construct) [id: 5376] /classes/Link.php:113 (__construct) [id: 4695] /classes/Link.php:113 (__construct) [id: 767] /classes/Link.php:113 (__construct) [id: 697] /classes/Link.php:113 (__construct) [id: 689] /classes/Link.php:113 (__construct) [id: 686] /classes/Link.php:113 (__construct) [id: 680] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 5376] /classes/Link.php:113 (__construct) [id: 5376] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 4695] /classes/Link.php:113 (__construct) [id: 4695] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 767] /classes/Link.php:113 (__construct) [id: 767] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 697] /classes/Link.php:113 (__construct) [id: 697] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 689] /classes/Link.php:113 (__construct) [id: 689] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 686] /classes/Link.php:113 (__construct) [id: 686] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 680] /classes/Link.php:113 (__construct) [id: 680]
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: ]
Category	10	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 106] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 851] /classes/Meta.php:380 (__construct) [id: 106] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /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: 106] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 106] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 106]
Combination	7	/classes/Product.php:5743 (__construct) [id: 3458] /classes/Product.php:5743 (__construct) [id: 3201] /classes/Product.php:5743 (__construct) [id: 491] /classes/Product.php:5743 (__construct) [id: 312] /classes/Product.php:5743 (__construct) [id: 193] /classes/Product.php:5743 (__construct) [id: 2794] /classes/Product.php:5743 (__construct) [id: 166]
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