Inicio

POLVO INSTANTANEO LEDEVIT X 250 g

$ 3.996,00

EN POLVO LEDEVIT PASTELERA - CHANTILLI - MERENGUE - CHOCOLATE - FRUTILLA PRODUCTO LIBRE DE GLUTEN Fácil de preparar y...

Lista de deseos

Comparar

Load Time	1657 ms
Querying Time	767 ms
Queries	687
Memory Peak Usage	55.2 Mb
Included Files	852 files - 11.35 Mb
PrestaShop Cache	- Mb
Global vars	0.99 Mb
- global $_MODULES	587k
- global $context	352k
- 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	77.230 ms	77.230 ms	19.18 Mb	19.5 Mb
__construct	8.524 ms	85.754 ms	1.89 Mb	22.5 Mb
init	195.554 ms	281.308 ms	6.05 Mb	28.2 Mb
checkAccess	0.002 ms	281.310 ms	- Mb	28.2 Mb
setMedia	75.586 ms	356.896 ms	0.74 Mb	28.2 Mb
postProcess	0.001 ms	356.897 ms	- Mb	28.2 Mb
initHeader	0.001 ms	356.898 ms	- Mb	28.2 Mb
initContent	828 ms	1185 ms	19.25 Mb	47.2 Mb
initFooter	0.002 ms	1185 ms	- Mb	47.2 Mb
display	471.654 ms	1657 ms	7.83 Mb	55.2 Mb

43 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
37 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
35 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
34 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
34 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
34 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
34 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)
34 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
34 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
34 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
24 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
24 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`
24 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
24 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;
16 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
16 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 * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
8 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 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
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
4 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 queries	SELECT `name` FROM `ps_hook` WHERE `id_hook` = 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 * 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 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 page from `ps_appagebuilder_page` where id_category = 'XX' AND id_shop = 'XX' LIMIT XX
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT 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) 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) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute

Name	Instances	Source
Product	119	/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: 705] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 705] /classes/Link.php:113 (__construct) [id: 630] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 630] /classes/Link.php:113 (__construct) [id: 496] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 496] /classes/Link.php:113 (__construct) [id: 501] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 501] /classes/Link.php:113 (__construct) [id: 461] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 461] /classes/Link.php:113 (__construct) [id: 361] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 361] /classes/Link.php:113 (__construct) [id: 360] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 360] /classes/Link.php:113 (__construct) [id: 359] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 359] /classes/Link.php:113 (__construct) [id: 358] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 358] /classes/Link.php:113 (__construct) [id: 356] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 356] /classes/Link.php:113 (__construct) [id: 354] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 354] /classes/Link.php:113 (__construct) [id: 316] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 316] /classes/Link.php:113 (__construct) [id: 313] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 313] /classes/Link.php:113 (__construct) [id: 291] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 291] /classes/Link.php:113 (__construct) [id: 268] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 268] /classes/Link.php:113 (__construct) [id: 266] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 266] /classes/Link.php:113 (__construct) [id: 247] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 247] /classes/Link.php:113 (__construct) [id: 236] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 236] /classes/Link.php:113 (__construct) [id: 228] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 228] /classes/Link.php:113 (__construct) [id: 226] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 226] /classes/Link.php:113 (__construct) [id: 225] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 225] /classes/Link.php:113 (__construct) [id: 224] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 224] /classes/Link.php:113 (__construct) [id: 223] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 223] /classes/Link.php:113 (__construct) [id: 213] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 213] /classes/Link.php:113 (__construct) [id: 705] /classes/Link.php:113 (__construct) [id: 630] /classes/Link.php:113 (__construct) [id: 496] /classes/Link.php:113 (__construct) [id: 501] /classes/Link.php:113 (__construct) [id: 461] /classes/Link.php:113 (__construct) [id: 361] /classes/Link.php:113 (__construct) [id: 360] /classes/Link.php:113 (__construct) [id: 359] /classes/Link.php:113 (__construct) [id: 358] /classes/Link.php:113 (__construct) [id: 356] /classes/Link.php:113 (__construct) [id: 354] /classes/Link.php:113 (__construct) [id: 316] /classes/Link.php:113 (__construct) [id: 313] /classes/Link.php:113 (__construct) [id: 291] /classes/Link.php:113 (__construct) [id: 268] /classes/Link.php:113 (__construct) [id: 266] /classes/Link.php:113 (__construct) [id: 247] /classes/Link.php:113 (__construct) [id: 236] /classes/Link.php:113 (__construct) [id: 228] /classes/Link.php:113 (__construct) [id: 226] /classes/Link.php:113 (__construct) [id: 225] /classes/Link.php:113 (__construct) [id: 224] /classes/Link.php:113 (__construct) [id: 223] /classes/Link.php:113 (__construct) [id: 213] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 705] /classes/Link.php:113 (__construct) [id: 705] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 630] /classes/Link.php:113 (__construct) [id: 630] /classes/Link.php:113 (__construct) [id: 496] /classes/Link.php:113 (__construct) [id: 501] /classes/Link.php:113 (__construct) [id: 461] /classes/Link.php:113 (__construct) [id: 361] /classes/Link.php:113 (__construct) [id: 360] /classes/Link.php:113 (__construct) [id: 359] /classes/Link.php:113 (__construct) [id: 358] /classes/Link.php:113 (__construct) [id: 356] /classes/Link.php:113 (__construct) [id: 354] /classes/Link.php:113 (__construct) [id: 316] /classes/Link.php:113 (__construct) [id: 313] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 291] /classes/Link.php:113 (__construct) [id: 291] /classes/Link.php:113 (__construct) [id: 268] /classes/Link.php:113 (__construct) [id: 266] /classes/Link.php:113 (__construct) [id: 247] /classes/Link.php:113 (__construct) [id: 236] /classes/Link.php:113 (__construct) [id: 228] /classes/Link.php:113 (__construct) [id: 226] /classes/Link.php:113 (__construct) [id: 225] /classes/Link.php:113 (__construct) [id: 224] /classes/Link.php:113 (__construct) [id: 223] /classes/Link.php:113 (__construct) [id: 213]
Country	18	/config/config.inc.php:146 (__construct) [id: 44] /classes/controller/FrontController.php:345 (__construct) [id: 44] /classes/AddressFormat.php:404 (__construct) [id: 44] /classes/controller/FrontController.php:1652 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44] /modules/whatsappchat/classes/WhatsappChatBlock.php:157 (__construct) [id: 44]
Address	18	/classes/shop/Shop.php:479 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /classes/Product.php:3622 (initialize) [id: ] /classes/Product.php:3730 (__construct) [id: ] /classes/Product.php:5797 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:145 (__construct) [id: 0]
Customer	15	/config/config.inc.php:264 (__construct) [id: ] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0] /modules/whatsappchat/classes/WhatsappChatBlock.php:155 (__construct) [id: 0]
WhatsappChatBlockAgent	15	/modules/whatsappchat/whatsappchat.php:290 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:550 (__construct) [id: ]
Category	14	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 100] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 200] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 300] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 400] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 600] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 700] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 852] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/leopopupsale/leopopupsale.php:659 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 2]
WhatsappChatBlock	14	/modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ] /modules/whatsappchat/whatsappchat.php:549 (__construct) [id: ]
Combination	3	/classes/Product.php:5743 (__construct) [id: 365] /classes/Product.php:5743 (__construct) [id: 653] /classes/Product.php:5743 (__construct) [id: 719]
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: ]

Hook	Time	Memory Usage
Header	192.895 ms	2.68 Mb
=> leoslideshow	0.367 ms	- Mb
=> leofeature	0.456 ms	0.02 Mb
=> leoquicklogin	0.186 ms	- Mb
=> eicaptcha	0.008 ms	- Mb
=> leopopupsale	191.407 ms	2.62 Mb
=> xmlfeeds	0.359 ms	0.03 Mb
=> mercadopago	0.112 ms	- Mb
DisplayLeoProfileProduct	130.293 ms	3.82 Mb
=> appagebuilder	5.218 ms	0.56 Mb
=> appagebuilder	3.926 ms	0.32 Mb
=> appagebuilder	2.202 ms	0.12 Mb
=> appagebuilder	2.349 ms	0.12 Mb
=> appagebuilder	2.117 ms	0.12 Mb
=> appagebuilder	2.102 ms	0.12 Mb
=> appagebuilder	2.155 ms	0.12 Mb
=> appagebuilder	77.245 ms	0.12 Mb
=> appagebuilder	2.037 ms	0.12 Mb
=> appagebuilder	2.003 ms	0.12 Mb
=> appagebuilder	2.170 ms	0.12 Mb
=> appagebuilder	1.952 ms	0.12 Mb
=> appagebuilder	2.030 ms	0.12 Mb
=> appagebuilder	3.908 ms	0.36 Mb
=> appagebuilder	2.139 ms	0.12 Mb
=> appagebuilder	2.110 ms	0.12 Mb
=> appagebuilder	2.023 ms	0.12 Mb
=> appagebuilder	1.971 ms	0.12 Mb
=> appagebuilder	2.068 ms	0.12 Mb
=> appagebuilder	1.900 ms	0.12 Mb
=> appagebuilder	1.901 ms	0.13 Mb
=> appagebuilder	1.665 ms	0.12 Mb
=> appagebuilder	1.567 ms	0.12 Mb
=> appagebuilder	1.536 ms	0.12 Mb
DisplayHeader	97.703 ms	2.08 Mb
=> ps_shoppingcart	0.067 ms	- Mb
=> ps_searchbar	0.199 ms	- Mb
=> leoblog	0.086 ms	- Mb
=> ps_googleanalytics	0.145 ms	0.01 Mb
=> leobootstrapmenu	1.036 ms	0.05 Mb
=> appagebuilder	95.297 ms	1.98 Mb

Module	Time	Memory Usage
leoblog	8.395 ms	- Mb
__construct	7.049 ms	0.61 Mb
hookModuleRoutes	1.250 ms	- Mb
hookDisplayHeader	0.088 ms	- Mb
hookLeftColumn	0.008 ms	- Mb
appagebuilder	262.679 ms	10.45 Mb
__construct	25.013 ms	3.55 Mb
hookModuleRoutes	0.478 ms	0.05 Mb
hookFilterHtmlContent	0.009 ms	- Mb
hookFilterCategoryContent	0.177 ms	0.01 Mb
hookFilterHtmlContent	0.007 ms	- Mb
hookFilterHtmlContent	0.006 ms	- Mb
hookDisplayHeader	95.300 ms	1.98 Mb
displayBanner	0.709 ms	0.06 Mb
displayNav1	0.323 ms	0.02 Mb
displayNav2	0.318 ms	0.02 Mb
displayTop	8.101 ms	0.77 Mb
displayNavFullWidth	0.278 ms	0.02 Mb
displayLeftColumn	0.269 ms	0.02 Mb
hookPagebuilderConfig	0.345 ms	0.02 Mb
hookPagebuilderConfig	0.217 ms	0.03 Mb
hookDisplayLeoProfileProduct	5.219 ms	0.57 Mb
hookDisplayLeoProfileProduct	3.928 ms	0.32 Mb
hookDisplayLeoProfileProduct	2.204 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.350 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.119 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.103 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.156 ms	0.12 Mb
hookDisplayLeoProfileProduct	77.245 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.039 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.004 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.172 ms	0.12 Mb
hookDisplayLeoProfileProduct	1.954 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.031 ms	0.12 Mb
hookDisplayLeoProfileProduct	3.909 ms	0.36 Mb
hookDisplayLeoProfileProduct	2.140 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.112 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.025 ms	0.13 Mb
hookDisplayLeoProfileProduct	1.973 ms	0.12 Mb
hookDisplayLeoProfileProduct	2.069 ms	0.12 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
218	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 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>=2 AND c.nright<=137 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	141.711 ms	34987225	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)
684	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 `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position	77.332 ms	1	Yes		/modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71 /modules/whatsappchat/whatsappchat.php:611 (getWhatsappChatAgents) /modules/whatsappchat/whatsappchat.php:384 (displayBlock) /classes/Hook.php:983 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /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:391 (__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:135 (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)
214	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 FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (29, 1, 31, 6, 57) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	74.294 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)
69	SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang FROM ps_appagebuilder p LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1) LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder) WHERE pl.id_lang=1 AND ps.id_shop=1 AND p.id_appagebuilder_positions IN (7,12,13,4) ORDER BY p.id_appagebuilder	74.135 ms	90			/modules/appagebuilder/classes/ApPageBuilderModel.php:302 /modules/appagebuilder/appagebuilder.php:2061 (getAllItems) /classes/Hook.php:983 (hookdisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 6110 LIMIT 1	73.400 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /modules/leopopupsale/leopopupsale.php:662 (getProducts) /classes/Hook.php:983 (hookHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /classes/controller/FrontController.php:563 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
200	SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = 6108 AND image_shop.`cover`= 1 LIMIT 1	68.545 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)
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`	35.482 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)
508	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` = 228 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	33.945 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /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)
297	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 501) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	10.359 ms	1			/classes/stock/StockAvailable.php:452 /classes/Product.php:4235 (getQuantityAvailableByProduct) /classes/Product.php:5642 (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)
223	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("9f9744f181afd0ba3ef294046f0b482d", "a:1:{s:7:\"filters\";a:4:{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:2:{i:100;a:2:{s:4:\"name\";s:12:\"Repostería \";s:3:\"nbr\";s:2:\"20\";}i:400;a:2:{s:4:\"name\";s:9:\"Golosinas\";s:3:\"nbr\";s:2:\"21\";}}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:47:{i:1;a:3:{s:4:\"name\";s:5:\"ARCOR\";s:3:\"nbr\";s:2:\"20\";s:7:\"checked\";b:1;}i:2;a:2:{s:4:\"name\";s:8:\"MONDELEZ\";s:3:\"nbr\";s:2:\"15\";}i:4;a:2:{s:4:\"name\";s:9:\"LHERITIER\";s:3:\"nbr\";s:1:\"6\";}i:5;a:2:{s:4:\"name\";s:4:\"LIPO\";s:3:\"nbr\";s:1:\"2\";}i:6;a:3:{s:4:\"name\";s:9:\"GEORGALOS\";s:3:\"nbr\";s:1:\"2\";s:7:\"checked\";b:1;}i:11;a:2:{s:4:\"name\";s:17:\"Freedom Wars Corp\";s:3:\"nbr\";s:1:\"2\";}i:14;a:2:{s:4:\"name\";s:7:\"FERRERO\";s:3:\"nbr\";s:1:\"2\";}i:18;a:2:{s:4:\"name\";s:10:\"GUAYMALLEN\";s:3:\"nbr\";s:1:\"4\";}i:19;a:2:{s:4:\"name\";s:7:\"JORGITO\";s:3:\"nbr\";s:1:\"3\";}i:24;a:2:{s:4:\"name\";s:7:\"vacalin\";s:3:\"nbr\";s:1:\"3\";}i:26;a:2:{s:4:\"name\";s:5:\"mapsa\";s:3:\"nbr\";s:2:\"11\";}i:27;a:2:{s:4:\"name\";s:5:\"dewey\";s:3:\"nbr\";s:1:\"1\";}i:28;a:2:{s:4:\"name\";s:7:\"lodiser\";s:3:\"nbr\";s:1:\"4\";}i:29;a:3:{s:4:\"name\";s:5:\"alzol\";s:3:\"nbr\";s:2:\"14\";s:7:\"checked\";b:1;}i:30;a:2:{s:4:\"name\";s:5:\"circe\";s:3:\"nbr\";s:1:\"5\";}i:31;a:3:{s:4:\"name\";s:9:\"argenfrut\";s:3:\"nbr\";s:1:\"1\";s:7:\"checked\";b:1;}i:32;a:2:{s:4:\"name\";s:6:\"ciotti\";s:3:\"nbr\";s:1:\"2\";}i:33;a:2:{s:4:\"name\";s:6:\"NESTLE\";s:3:\"nbr\";s:1:\"1\";}i:36;a:2:{s:4:\"name\";s:6:\"AGUILA\";s:3:\"nbr\";s:1:\"3\";}i:38;a:2:{s:4:\"name\";s:7:\"FELFORT\";s:3:\"nbr\";s:1:\"4\";}i:39;a:2:{s:4:\"name\";s:8:\"BONAFIDE\";s:3:\"nbr\";s:1:\"1\";}i:40;a:2:{s:4:\"name\";s:8:\"GEORGALO\";s:3:\"nbr\";s:1:\"2\";}i:42;a:2:{s:4:\"name\";s:6:\"OBLITA\";s:3:\"nbr\";s:1:\"4\";}i:43;a:2:{s:4:\"name\";s:6:\"KINDER\";s:3:\"nbr\";s:1:\"1\";}i:45;a:2:{s:4:\"name\";s:9:\"TERRABUSI\";s:3:\"nbr\";s:1:\"4\";}i:47;a:2:{s:4:\"name\";s:9:\"INTERLINK\";s:3:\"nbr\";s:1:\"2\";}i:48;a:2:{s:4:\"name\";s:16:\"DECOR CAKE&CRAFT\";s:3:\"nbr\";s:2:\"15\";}i:49;a:2:{s:4:\"name\";s:5:\"EMETH\";s:3:\"nbr\";s:1:\"5\";}i:50;a:2:{s:4:\"name\";s:10:\"EXQUISITA \";s:3:\"nbr\";s:1:\"6\";}i:52;a:2:{s:4:\"name\";s:8:\"CODELAND\";s:3:\"nbr\";s:1:\"1\";}i:53;a:2:{s:4:\"name\";s:6:\"PARPEN\";s:3:\"nbr\";s:2:\"12\";}i:54;a:2:{s:4:\"name\";s:8:\"TELGOPOR\";s:3:\"nbr\";s:1:\"5\";}i:55;a:2:{s:4:\"name\";s:11:\"DOÑA CLARA\";s:3:\"nbr\";s:1:\"5\";}i:56;a:2:{s:4:\"name\";s:5:\"coral\";s:3:\"nbr\";s:1:\"1\";}i:57;a:3:{s:4:\"name\";s:8:\"LEDEVIT \";s:3:\"nbr\";s:1:\"4\";s:7:\"checked\";b:1;}i:58;a:2:{s:4:\"name\";s:11:\"BACI GALUPO\";s:3:\"nbr\";s:1:\"3\";}i:59;a:2:{s:4:\"name\";s:9:\"PASTEL AR\";s:3:\"nbr\";s:1:\"3\";}i:61;a:2:{s:4:\"name\";s:6:\"Cooper\";s:3:\"nbr\";s:1:\"2\";}i:62;a:2:{s:4:\"name\";s:18:\"Reposteria Caseros\";s:3:\"nbr\";s:2:\"13\";}i:63;a:2:{s:4:\"name\";s:7:\"Fleibor\";s:3:\"nbr\";s:2:\"39\";}i:64;a:2:{s:4:\"name\";s:7:\"DESSERT\";s:3:\"nbr\";s:1:\"8\";}i:66;a:2:{s:4:\"name\";s:5:\"BLOCH\";s:3:\"nbr\";s:1:\"2\";}i:68;a:2:{s:4:\"name\";s:9:\"La botica\";s:3:\"nbr\";s:1:\"5\";}i:70;a:2:{s:4:\"name\";s:7:\"EXTERSA\";s:3:\"nbr\";s:1:\"1\";}i:72;a:2:{s:4:\"name\";s:6:\"Flogus\";s:3:\"nbr\";s:1:\"6\";}i:73;a:2:{s:4:\"name\";s:9:\"Dripcolor\";s:3:\"nbr\";s:1:\"9\";}i:76;a:2:{s:4:\"name\";s:12:\"ChoPackaging\";s:3:\"nbr\";s:2:\"11\";}}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:41;}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:63000;s:3:\"min\";d:643;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:41;s:5:\"value\";N;}}}")	6.308 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)
222	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 FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (29, 1, 31, 6, 57) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	5.080 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)
216	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 FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (29, 1, 31, 6, 57) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<137 GROUP BY cp.id_category	3.167 ms	4624	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)
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`)	2.953 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`)	2.894 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)
212	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (29, 1, 31, 6, 57) AND c.nleft>=2 AND c.nright<=137 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_add DESC, p.id_product DESC	2.057 ms	4624	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)
89	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	1.995 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)
90	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.874 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)
112	SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0	1.838 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)
80	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.449 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)
219	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) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (29, 1, 31, 6, 57) AND c.nleft>=2 AND c.nright<=137	1.130 ms	68			/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)
220	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) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (29, 1, 31, 6, 57) AND c.nleft>=2 AND c.nright<=137	1.120 ms	68			/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)
618	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 137 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	1.028 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)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.881 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)
221	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/Block.php:731 (getAttributes) /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)
194	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6101) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	0.740 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)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	0.739 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` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.731 ms	9	Yes	Yes	/classes/Category.php:897 /controllers/front/listing/CategoryController.php:215 (getSubCategories) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
677	SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `ps_category_product` cp LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category) LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (705,630,496,501,461,361,360,359,358,356,354,316,313,291,268,266,247,236,228,226,225,224,223,213) AND cl.`id_lang` = 1 ORDER BY c.`level_depth` DESC	0.690 ms	71	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109 /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:68 (loadCategories) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:81 (prepareItemListFromProductList) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:57 (renderProductListing) /modules/ps_googleanalytics/ps_googleanalytics.php:109 (run) /classes/Hook.php:983 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /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:391 (__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:135 (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)
211	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.654 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)
224	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 = 705 LIMIT 1	0.594 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)
210	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.589 ms	74	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Converter.php:286 (getManufacturers) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
215	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.526 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)
547	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 = 224 LIMIT 1	0.523 ms	1			/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)
642	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 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 = 1) 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` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (501) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.520 ms	1	Yes	Yes	/classes/Product.php:4407 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:523 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/47/26/78/47267873e5f7a9585c71298a2935d5cf04f63489_2.file.plist1537116924.tpl.php:47 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b0991b75e31_08117584) /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) /modules/appagebuilder/appagebuilder.php:2621 (fetch) /classes/Hook.php:983 (hookDisplayLeoProfileProduct) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/ce/fd/d2/cefdd2553efb977443e8eeff7a1bd3889ff89cfd_2.file.leo_col_products.tpl.php:195 (__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/ce/fd/d2/cefdd2553efb977443e8eeff7a1bd3889ff89cfd_2.file.leo_col_products.tpl.php:140 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b0991b57207_07401568) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/69/4f/82/694f829c9c9349db6e9ca5b62e637e7f15af100c_2.file.products.tpl.php:32 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_666b0991a5af23_12807202) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/3a/e8/55/3ae8554488471a7139eef7d5cbbc93d628622a74_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/3a/e8/55/3ae8554488471a7139eef7d5cbbc93d628622a74_2.file.product-list.tpl.php:216 (instanceBlock) /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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/papeleralayouts_layout_left_column_tpl/ca/bb/8e/cabb8e44e9d2f8bc77fac639edeca249e60a9761_2.file.layout-left-column.tpl.php:84 (instanceBlock) /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:186 (process) /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:97 (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)
501	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 = 228 LIMIT 1	0.519 ms	1			/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)
43	SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)	0.511 ms	1			/classes/module/Module.php:2013 /classes/Hook.php:871 (getExceptionsStatic) /src/Adapter/Presenter/Object/ObjectPresenter.php:97 (exec) /src/Adapter/Presenter/Object/ObjectPresenter.php:70 (filterHtmlContent) /controllers/front/listing/CategoryController.php:187 (present) /controllers/front/listing/CategoryController.php:99 (getTemplateVarCategory) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
373	SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 400 LIMIT 1	0.508 ms	1			/classes/Product.php:5517 /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)
217	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.493 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)
517	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 = 226 LIMIT 1	0.491 ms	1			/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)
345	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 = 359 LIMIT 1	0.488 ms	1			/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)

#	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