Home

To give you the best possible experience, this site uses cookies. Using your site means your agree to our use of cookies. We have published a new cookies policy, which you should need to find out more about the cookies we use. View Cookies Policy.

Emsibeth: La Scienza Italiana al Servizio della Salute e della Bellezza dei Tuoi Capelli

Apr ,

2025

Emsibeth: La Scienza Italiana al Servizio della Salute e della Bellezza dei Tuoi Capelli

Se sei alla ricerca di soluzioni specifiche e performanti per la cura dei tuoi capelli e del cuoio capelluto, sei nel posto giusto! Noi di Hair ...

Insight: La Natura al Servizio della Bellezza Autentica dei Tuoi Capelli

Apr ,

2025

Insight: La Natura al Servizio della Bellezza Autentica dei Tuoi Capelli

Sei alla ricerca di un haircare che rispetti la natura dei tuoi capelli e del pianeta? Noi di Hair Saloon siamo entusiasti di presentarti la ...

Framesi: L'Eccellenza Italiana per Capelli che Ispirano

Mar ,

2025

Framesi: L'Eccellenza Italiana per Capelli che Ispirano

Se cerchi risultati professionali direttamente a casa tua, sei nel posto giusto! Noi di Hair Saloon siamo entusiasti di presentarti la nostra ...

Davines: La Bellezza Sostenibile che Nutre i Tuoi Capelli (e il Pianeta!)

Mar ,

2025

Davines: La Bellezza Sostenibile che Nutre i Tuoi Capelli (e il Pianeta!)

Noi di Hair Saloon siamo fieri di essere il tuo punto di riferimento per l'intera gamma di prodotti Davines. Abbiamo selezionato con cura ogni ...

Load Time	2430 ms
Querying Time	1700 ms
Queries	1417
Memory Peak Usage	41.7 Mb
Included Files	1391 files - 18.04 Mb
PrestaShop Cache	- Mb
Global vars	1.31 Mb
- global $_MODULES	1274k
- global $_MODULE	37k
- global $_SERVER	14k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k

PrestaShop Version	8.2.1
PHP Version	8.1.32
MySQL Version	8.0.18-9
Memory Limit	256M
Max Execution Time	180s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	71.613 ms	71.613 ms	3.69 Mb	3.9 Mb
__construct	0.043 ms	71.656 ms	- Mb	3.9 Mb
init	26.208 ms	97.864 ms	0.92 Mb	4.6 Mb
checkAccess	0.003 ms	97.867 ms	- Mb	4.6 Mb
setMedia	58.781 ms	156.648 ms	0.24 Mb	5.2 Mb
postProcess	0.005 ms	156.653 ms	- Mb	5.2 Mb
initHeader	0.003 ms	156.656 ms	- Mb	5.2 Mb
initContent	914 ms	1070 ms	6.03 Mb	10.9 Mb
initFooter	0.003 ms	1070 ms	- Mb	10.9 Mb
display	1360 ms	2430 ms	29.98 Mb	41.7 Mb

108 queries	SELECT `id_tvcmsposts` FROM `ps_tvcmsposts_view` where `id_tvcmsposts` = XX
108 queries	SELECT xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `ps_tvcms_category_post` xcp INNER JOIN `ps_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `ps_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = XX) INNER JOIN `ps_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = XX) WHERE xcp.`id_post` = XX AND xcp.`type` = "tag"
108 queries	SELECT COUNT(id_tvcms_comments) AS total_comment FROM `ps_tvcms_comments` xc WHERE xc.`id_post` = XX
71 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
70 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)
70 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
57 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
57 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
57 queries	SELECT product_attribute_shop.id_product_attribute 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 LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
48 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
39 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
38 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
35 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(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_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
30 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
30 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
30 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
30 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`
26 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_product_attribute = XX 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 IN (XX)
21 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 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
12 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
10 queries	SELECT quantity, reserved_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
7 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
7 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`
5 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
5 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
5 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
5 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` 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_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 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
5 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
5 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
5 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
5 queries	SELECT cg.`id_group` FROM `ps_category_group` cg WHERE (cg.`id_category` = XX)
4 queries	SELECT 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` = XX) 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` = XX) 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 = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT 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, cp.position 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, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) WHERE ((sa.quantity>XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='XX' AND c.nleft>=XX AND c.nright<=XX 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) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) WHERE ((a.id_attribute_group=XX)) AND ((sa_XX.quantity>XX)) GROUP BY pac.id_attribute
4 queries	SELECT id_shop FROM `ps_employee_shop` WHERE `id_employee` = XX
4 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
4 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
4 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`
4 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
3 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
3 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_dynamic_last_product_not_ordered` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `last_product_ordered` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
3 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'it-it' OR `language_code` = 'it-it' LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `id_module` FROM `ps_module` WHERE `name` = "ps_accounts" LIMIT XX
2 queries	SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_country_lang` WHERE `id_country` = XX
2 queries	BEGIN
2 queries	SHOW TABLES LIKE "ps_gmcp_XX"
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_reporting` (`id_reporting` int(XX) NOT NULL AUTO_INCREMENT,`iso_feed` LONGTEXT NOT NULL, `reporting_content` LONGTEXT NOT NULL,`id_shop` int(XX) NOT NULL,`date_add` datetime NOT NULL,`date_upd` datetime NOT NULL,PRIMARY KEY (`id_reporting`)) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_feeds` (`id_feed` int(XX) NOT NULL AUTO_INCREMENT,`iso_lang` LONGTEXT NOT NULL,`iso_country` LONGTEXT NOT NULL,`iso_currency` LONGTEXT NOT NULL, `taxonomy` LONGTEXT NOT NULL, `id_shop` int(XX) NOT NULL,`date_add` datetime NOT NULL,`date_upd` datetime NOT NULL,PRIMARY KEY (`id_feed`)) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_price_range` (`id_tag` int(XX) NOT NULL, `price_min` CHAR(XX) NOT NULL, `price_max` CHAR(XX), `id_product` CHAR(XX), UNIQUE KEY `tag_price_range` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tmp_rules`(`id` int(XX) NOT NULL AUTO_INCREMENT, `id_shop` int(XX) NOT NULL DEFAULT "XX",`type` char(XX) NOT NULL, `exclusion_values` longtext NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX AUTO_INCREMENT=XX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_dynamic_last_product_ordered` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `last_product_ordered` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags_dynamic_promotion` (`id_tag` int(XX) NOT NULL,`start_date` DATETIME, `end_date` DATETIME, `id_product` CHAR(XX), UNIQUE KEY `promotion` (`id_tag`, `id_product`)) ENGINE=InnoDB DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_discount_association` (`id_association` int(XX) NOT NULL AUTO_INCREMENT, `id_discount` int(XX) NOT NULL, `id_product` int(XX) NOT NULL, `channel` CHAR(XX) NOT NULL DEFAULT "SHOPPING_ADS", PRIMARY KEY (`id_association`) ) ENGINE=MyISAM DEFAULT CHARSET=utfXX;
2 queries	CREATE TABLE IF NOT EXISTS `ps_gmcp_tags` (`id_tag` int(XX) NOT NULL AUTO_INCREMENT, `id_shop` int(XX) NOT NULL DEFAULT "XX", `name` char(XX) NOT NULL, `type` char(XX) NOT NULL, `active` TINYINT NOT NULL, `position` INT NOT NULL, `end_date` DATE, PRIMARY KEY (`id_tag`)) ENGINE=MyISAM DEFAULT CHARSET=utfXX AUTO_INCREMENT=XX ;
2 queries	COMMIT
2 queries	SELECT `name` FROM `ps_country_lang` WHERE `id_lang` = XX AND `id_country` = 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 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="module:tvcmsproductpopup/views/templates/hook/tvcmsproductpopup_footer\|XX\|XX" AND compile_id="child_vXX_swert_smell_XX" LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute 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_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE (product_shop.`active` = XX) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) ORDER BY product_shop.`date_add` DESC LIMIT XX
2 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
2 queries	SELECT count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
2 queries	SELECT * FROM `ps_tvcms_image_type` WHERE active = XX AND id_shop = XX

Name	Instances	Source
Product	66	/classes/Link.php:113 (__construct) [id: 3] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 5] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 22] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 23] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 24] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 25] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 27] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 28] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 29] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 31] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 32] /classes/Link.php:113 (__construct) [id: 3] /classes/Link.php:113 (__construct) [id: 4] /classes/Link.php:113 (__construct) [id: 22] /classes/Link.php:113 (__construct) [id: 23] /classes/Link.php:113 (__construct) [id: 32] /classes/Link.php:113 (__construct) [id: 986] /classes/Link.php:113 (__construct) [id: 985] /classes/Link.php:113 (__construct) [id: 984] /classes/Link.php:113 (__construct) [id: 983] /classes/Link.php:113 (__construct) [id: 982] /classes/Link.php:113 (__construct) [id: 978] /classes/Link.php:113 (__construct) [id: 977] /classes/Link.php:113 (__construct) [id: 976] /classes/Link.php:113 (__construct) [id: 975] /classes/Link.php:113 (__construct) [id: 974] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 986] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 985] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 984] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 983] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 982] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 978] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 977] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 976] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 975] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 974] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 986] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 985] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 984] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 983] /classes/Link.php:113 (__construct) [id: 972] /classes/Link.php:113 (__construct) [id: 971] /classes/Link.php:113 (__construct) [id: 970] /classes/Link.php:113 (__construct) [id: 952] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 972] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 971] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 970] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 952] /classes/Link.php:113 (__construct) [id: 100] /classes/Link.php:113 (__construct) [id: 469] /classes/Link.php:113 (__construct) [id: 919] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 100] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 27] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 469] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 919] /classes/Link.php:113 (__construct) [id: 256] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 256] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 23] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 32] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 29] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 4] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 22] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 23] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 32]
Category	44	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 9] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 58] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 51] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 73] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 140] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 153] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 169] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 170] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /classes/Meta.php:380 (__construct) [id: 2] /modules/ets_seo/ets_seo.php:2594 (__construct) [id: 2] /modules/ets_seo/ets_seo.php:2775 (__construct) [id: 2] /classes/Link.php:402 (__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/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 21] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 21] /classes/Link.php:402 (__construct) [id: 21] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 21] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 58] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 58] /classes/Link.php:402 (__construct) [id: 58] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 58] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 51] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 51] /classes/Link.php:402 (__construct) [id: 51] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 51] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 153] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 153] /classes/Link.php:402 (__construct) [id: 153] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 153] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 20] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 20] /classes/Link.php:402 (__construct) [id: 20] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 20] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2]
Country	11	/config/config.inc.php:146 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /classes/controller/FrontController.php:1779 (__construct) [id: 10] /modules/paypal/paypal.php:350 (__construct) [id: 10] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 10] /modules/gmerchantcenterpro/lib/moduleTools.php:211 (__construct) [id: 19] /classes/AddressFormat.php:404 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 10] /modules/ets_whatsapp/ets_whatsapp.php:466 (__construct) [id: 10]
State	8	/classes/AddressFormat.php:404 (__construct) [id: 128] /classes/controller/FrontController.php:1778 (__construct) [id: 128] /classes/AddressFormat.php:404 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 128] /classes/AddressFormat.php:404 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 128] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 128]
Combination	5	/classes/Product.php:5912 (__construct) [id: 86] /classes/Product.php:5912 (__construct) [id: 100] /classes/Product.php:5912 (__construct) [id: 47] /classes/Product.php:5912 (__construct) [id: 98] /classes/Product.php:5912 (__construct) [id: 56]
TvcmsCategoryClass	4	/modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 0] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:775 (__construct) [id: 1]
Language	4	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:206 (__construct) [id: 1]
Employee	4	/modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5] /modules/tvcmsblog/classes/tvcmspostsclass.php:729 (__construct) [id: 5]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1] /modules/gmerchantcenterpro/lib/moduleTools.php:216 (__construct) [id: 1]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Hook	Time	Memory Usage
DisplayLeftColumn	757.206 ms	16.52 Mb
=> tvcmsnewproducts	17.630 ms	0.55 Mb
=> tvcmscustomerservices	0.266 ms	0.02 Mb
=> tvcmsspecialproducts	266.986 ms	7.11 Mb
=> tvcmsfeaturedproducts	125.383 ms	1.40 Mb
=> tvcmsbestsellerproducts	71.729 ms	0.82 Mb
=> tvcmsblogdisplayposts	271.387 ms	6.58 Mb
=> tvcmstestimonial	3.825 ms	0.04 Mb
DisplayAfterBodyOpeningTag	239.994 ms	4.20 Mb
=> tvcmscookiesnotice	0.890 ms	0.02 Mb
=> tvcmsproductpopup	239.104 ms	4.18 Mb
DisplayReviewProductList	61.691 ms	3.84 Mb
=> tvcmsproductcomments	15.854 ms	0.12 Mb
=> tvcmsproductcomments	1.159 ms	0.07 Mb
=> tvcmsproductcomments	0.990 ms	0.07 Mb
=> tvcmsproductcomments	1.072 ms	0.07 Mb
=> tvcmsproductcomments	1.646 ms	0.11 Mb
=> tvcmsproductcomments	0.975 ms	0.07 Mb
=> tvcmsproductcomments	0.613 ms	0.07 Mb
=> tvcmsproductcomments	0.934 ms	0.07 Mb
=> tvcmsproductcomments	1.116 ms	0.11 Mb
=> tvcmsproductcomments	0.941 ms	0.07 Mb
=> tvcmsproductcomments	0.733 ms	0.07 Mb
=> tvcmsproductcomments	0.810 ms	0.07 Mb
=> tvcmsproductcomments	0.983 ms	0.11 Mb
=> tvcmsproductcomments	0.683 ms	0.07 Mb
=> tvcmsproductcomments	0.736 ms	0.07 Mb
=> tvcmsproductcomments	0.721 ms	0.07 Mb
=> tvcmsproductcomments	1.514 ms	0.11 Mb
=> tvcmsproductcomments	1.037 ms	0.07 Mb
=> tvcmsproductcomments	0.510 ms	0.07 Mb
=> tvcmsproductcomments	0.707 ms	0.07 Mb
=> tvcmsproductcomments	1.654 ms	0.11 Mb
=> tvcmsproductcomments	1.237 ms	0.07 Mb
=> tvcmsproductcomments	0.911 ms	0.07 Mb
=> tvcmsproductcomments	1.447 ms	0.07 Mb
=> tvcmsproductcomments	2.142 ms	0.11 Mb
=> tvcmsproductcomments	1.203 ms	0.07 Mb
=> tvcmsproductcomments	1.175 ms	0.07 Mb
=> tvcmsproductcomments	0.778 ms	0.07 Mb
=> tvcmsproductcomments	1.182 ms	0.11 Mb
=> tvcmsproductcomments	0.573 ms	0.07 Mb
=> tvcmsproductcomments	0.564 ms	0.07 Mb
=> tvcmsproductcomments	1.104 ms	0.07 Mb
=> tvcmsproductcomments	1.437 ms	0.11 Mb
=> tvcmsproductcomments	1.153 ms	0.07 Mb
=> tvcmsproductcomments	0.915 ms	0.07 Mb
=> tvcmsproductcomments	0.774 ms	0.07 Mb
=> tvcmsproductcomments	1.053 ms	0.11 Mb
=> tvcmsproductcomments	0.757 ms	0.07 Mb
=> tvcmsproductcomments	0.668 ms	0.07 Mb
=> tvcmsproductcomments	0.911 ms	0.07 Mb
=> tvcmsproductcomments	1.369 ms	0.11 Mb
=> tvcmsproductcomments	0.727 ms	0.07 Mb
=> tvcmsproductcomments	0.867 ms	0.07 Mb
=> tvcmsproductcomments	0.654 ms	0.07 Mb
=> tvcmsproductcomments	0.854 ms	0.11 Mb
=> tvcmsproductcomments	0.581 ms	0.07 Mb
=> tvcmsproductcomments	0.626 ms	0.07 Mb
=> tvcmsproductcomments	0.643 ms	0.07 Mb
ActionFrontControllerSetMedia	56.850 ms	0.19 Mb
=> ps_emailalerts	0.064 ms	- Mb
=> ps_socialfollow	0.075 ms	- Mb
=> ps_emailsubscription	0.178 ms	- Mb
=> klaviyopsautomation	0.010 ms	- Mb
=> ps_checkout	56.138 ms	0.18 Mb
=> ps_facebook	0.254 ms	- Mb
=> fermopoint	0.131 ms	- Mb
DisplayHeader	22.601 ms	0.44 Mb
=> lgcookieslaw	0.571 ms	- Mb
=> ps_shoppingcart	0.080 ms	- Mb
=> ps_searchbar	0.252 ms	- Mb
=> ps_imageslider	0.171 ms	- Mb
=> ps_facebook	3.056 ms	0.07 Mb
=> ps_googleanalytics	0.019 ms	- Mb
=> psxmarketingwithgoogle	0.370 ms	0.01 Mb
=> tvcmsbestsellerproducts	0.168 ms	0.01 Mb
=> tvcmsblog	0.319 ms	0.05 Mb
=> tvcmsblogdisplayposts	0.221 ms	0.03 Mb
=> tvcmsbrandlist	0.157 ms	0.02 Mb
=> tvcmscategorychainslider	0.153 ms	- Mb
=> tvcmscategoryslider	0.154 ms	- Mb
=> tvcmscookiesnotice	0.166 ms	- Mb
=> tvcmscustomerservices	0.169 ms	- Mb
=> tvcmscustomsetting	0.883 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.125 ms	- Mb
=> tvcmsfooterlogo	0.003 ms	- Mb
=> tvcmsfooterproduct	0.084 ms	- Mb
=> tvcmsnewproducts	0.074 ms	- Mb
=> tvcmsnewsletterpopup	0.208 ms	- Mb
=> tvcmspaymenticon	0.002 ms	- Mb
=> tvcmsproductcomments	0.348 ms	- Mb
=> tvcmsproductcompare	0.118 ms	- Mb
=> tvcmsproductpopup	0.123 ms	- Mb
=> tvcmssearch	0.270 ms	- Mb
=> tvcmssingleblock	0.119 ms	- Mb
=> tvcmssizechart	0.115 ms	- Mb
=> tvcmsslider	0.114 ms	- Mb
=> tvcmsspecialproducts	0.084 ms	- Mb
=> tvcmsstoretime	0.117 ms	- Mb
=> tvcmstabproducts	0.157 ms	- Mb
=> tvcmstestimonial	0.122 ms	- Mb
=> tvcmsthemeoptions	0.315 ms	0.01 Mb
=> tvcmsvideoblock	0.123 ms	- Mb
=> tvcmswishlist	0.151 ms	- Mb
=> ets_promotion	5.332 ms	0.06 Mb
=> ets_affiliatemarketing	0.515 ms	0.01 Mb
=> ets_reviews	0.100 ms	- Mb
=> ets_seo	3.138 ms	0.10 Mb
=> fermopoint	0.005 ms	- Mb
=> ets_whatsapp	0.150 ms	- Mb
=> gmerchantcenterpro	3.680 ms	0.01 Mb
DisplayMegamenu	14.829 ms	0.49 Mb
=> tvcmsmegamenu	14.829 ms	0.49 Mb
displayLeftColumn	12.263 ms	0.59 Mb
=> ps_categorytree (widget)	7.179 ms	0.45 Mb
=> ps_brandlist (widget)	3.132 ms	0.07 Mb
=> ps_supplierlist (widget)	1.952 ms	0.07 Mb
DisplayProductCompareProductList	10.160 ms	0.11 Mb
=> tvcmsproductcompare	1.551 ms	0.01 Mb
=> tvcmsproductcompare	0.406 ms	- Mb
=> tvcmsproductcompare	0.331 ms	- Mb
=> tvcmsproductcompare	0.330 ms	- Mb
=> tvcmsproductcompare	0.248 ms	- Mb
=> tvcmsproductcompare	0.357 ms	- Mb
=> tvcmsproductcompare	0.232 ms	- Mb
=> tvcmsproductcompare	0.188 ms	- Mb
=> tvcmsproductcompare	0.183 ms	- Mb
=> tvcmsproductcompare	0.194 ms	- Mb
=> tvcmsproductcompare	0.178 ms	- Mb
=> tvcmsproductcompare	0.150 ms	- Mb
=> tvcmsproductcompare	0.224 ms	- Mb
=> tvcmsproductcompare	0.130 ms	- Mb
=> tvcmsproductcompare	0.139 ms	- Mb
=> tvcmsproductcompare	0.120 ms	- Mb
=> tvcmsproductcompare	0.184 ms	- Mb
=> tvcmsproductcompare	0.155 ms	- Mb
=> tvcmsproductcompare	0.129 ms	- Mb
=> tvcmsproductcompare	0.140 ms	- Mb
=> tvcmsproductcompare	0.331 ms	- Mb
=> tvcmsproductcompare	0.205 ms	- Mb
=> tvcmsproductcompare	0.174 ms	- Mb
=> tvcmsproductcompare	0.212 ms	- Mb
=> tvcmsproductcompare	0.193 ms	- Mb
=> tvcmsproductcompare	0.345 ms	- Mb
=> tvcmsproductcompare	0.142 ms	- Mb
=> tvcmsproductcompare	0.208 ms	- Mb
=> tvcmsproductcompare	0.157 ms	- Mb
=> tvcmsproductcompare	0.180 ms	- Mb
=> tvcmsproductcompare	0.131 ms	- Mb
=> tvcmsproductcompare	0.118 ms	- Mb
=> tvcmsproductcompare	0.170 ms	- Mb
=> tvcmsproductcompare	0.128 ms	- Mb
=> tvcmsproductcompare	0.133 ms	- Mb
=> tvcmsproductcompare	0.122 ms	- Mb
=> tvcmsproductcompare	0.123 ms	- Mb
=> tvcmsproductcompare	0.121 ms	- Mb
=> tvcmsproductcompare	0.128 ms	- Mb
=> tvcmsproductcompare	0.158 ms	- Mb
=> tvcmsproductcompare	0.140 ms	- Mb
=> tvcmsproductcompare	0.128 ms	- Mb
=> tvcmsproductcompare	0.121 ms	- Mb
=> tvcmsproductcompare	0.128 ms	- Mb
=> tvcmsproductcompare	0.204 ms	- Mb
=> tvcmsproductcompare	0.137 ms	- Mb
=> tvcmsproductcompare	0.128 ms	- Mb
=> tvcmsproductcompare	0.127 ms	- Mb
DisplayWishlistBtnProductList	8.483 ms	0.10 Mb
=> tvcmswishlist	1.049 ms	0.01 Mb
=> tvcmswishlist	0.334 ms	- Mb
=> tvcmswishlist	0.294 ms	- Mb
=> tvcmswishlist	0.297 ms	- Mb
=> tvcmswishlist	0.161 ms	- Mb
=> tvcmswishlist	0.310 ms	- Mb
=> tvcmswishlist	0.210 ms	- Mb
=> tvcmswishlist	0.162 ms	- Mb
=> tvcmswishlist	0.177 ms	- Mb
=> tvcmswishlist	0.144 ms	- Mb
=> tvcmswishlist	0.162 ms	- Mb
=> tvcmswishlist	0.144 ms	- Mb
=> tvcmswishlist	0.132 ms	- Mb
=> tvcmswishlist	0.118 ms	- Mb
=> tvcmswishlist	0.140 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> tvcmswishlist	0.121 ms	- Mb
=> tvcmswishlist	0.112 ms	- Mb
=> tvcmswishlist	0.116 ms	- Mb
=> tvcmswishlist	0.171 ms	- Mb
=> tvcmswishlist	0.184 ms	- Mb
=> tvcmswishlist	0.177 ms	- Mb
=> tvcmswishlist	0.160 ms	- Mb
=> tvcmswishlist	0.188 ms	- Mb
=> tvcmswishlist	0.162 ms	- Mb
=> tvcmswishlist	0.339 ms	- Mb
=> tvcmswishlist	0.146 ms	- Mb
=> tvcmswishlist	0.136 ms	- Mb
=> tvcmswishlist	0.131 ms	- Mb
=> tvcmswishlist	0.145 ms	- Mb
=> tvcmswishlist	0.129 ms	- Mb
=> tvcmswishlist	0.115 ms	- Mb
=> tvcmswishlist	0.118 ms	- Mb
=> tvcmswishlist	0.107 ms	- Mb
=> tvcmswishlist	0.127 ms	- Mb
=> tvcmswishlist	0.106 ms	- Mb
=> tvcmswishlist	0.167 ms	- Mb
=> tvcmswishlist	0.143 ms	- Mb
=> tvcmswishlist	0.109 ms	- Mb
=> tvcmswishlist	0.157 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> tvcmswishlist	0.106 ms	- Mb
=> tvcmswishlist	0.103 ms	- Mb
=> tvcmswishlist	0.173 ms	- Mb
=> tvcmswishlist	0.138 ms	- Mb
=> tvcmswishlist	0.115 ms	- Mb
=> tvcmswishlist	0.111 ms	- Mb
=> tvcmswishlist	0.118 ms	- Mb
DisplayCustomsocialblock	5.999 ms	0.17 Mb
=> tvcmscustomsetting	5.999 ms	0.17 Mb
displayNewslettersubscription	5.797 ms	0.12 Mb
=> ps_emailsubscription (widget)	5.797 ms	0.12 Mb
DisplayNavWishlistBlock	5.007 ms	0.04 Mb
=> tvcmswishlist	5.007 ms	0.04 Mb
Header	4.771 ms	0.07 Mb
=> tvcmsstockinfo	0.136 ms	- Mb
=> paypal	0.988 ms	0.03 Mb
=> tvcmsinfinitescroll	2.767 ms	0.04 Mb
=> tvcmstwoofferbanner	0.208 ms	- Mb
=> tvcmscategoryproduct	0.275 ms	- Mb
=> tvcmsmegamenu	0.218 ms	- Mb
=> tvcmsofferbanner	0.179 ms	- Mb
DisplayNavSearchBlock	4.354 ms	0.35 Mb
=> tvcmssearch	4.354 ms	0.35 Mb
DisplayBeforeBodyClosingTag	4.163 ms	0.05 Mb
=> statsdata	4.158 ms	0.05 Mb
=> tvcmsblog	0.005 ms	- Mb
ModuleRoutes	3.471 ms	0.03 Mb
=> klaviyopsautomation	0.007 ms	- Mb
=> ps_checkout	0.002 ms	- Mb
=> tvcmsblog	0.041 ms	0.01 Mb
=> ets_reviews	3.421 ms	0.02 Mb
displayNavShoppingCartBlock	3.345 ms	0.09 Mb
=> ps_shoppingcart (widget)	3.345 ms	0.09 Mb
DisplayNavWishlistBlocksticky	3.064 ms	0.05 Mb
=> tvcmswishlist	3.064 ms	0.05 Mb
DisplayPaymentIcon	2.866 ms	0.05 Mb
=> tvcmspaymenticon	2.866 ms	0.05 Mb
DisplayGDPRConsent	2.808 ms	0.03 Mb
=> psgdpr	2.808 ms	0.03 Mb
displayFooter	2.168 ms	0.09 Mb
=> ps_linklist (widget)	2.168 ms	0.09 Mb
DisplayFooter	1.479 ms	0.02 Mb
=> lgcookieslaw	0.117 ms	- Mb
=> ps_facebook	0.482 ms	- Mb
=> ets_affiliatemarketing	0.021 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_whatsapp	0.857 ms	0.02 Mb
displayNavCustomerSignInBlock	1.473 ms	0.05 Mb
=> ps_customersignin (widget)	1.473 ms	0.05 Mb
displayNav1	1.368 ms	0.09 Mb
=> ps_contactinfo (widget)	1.368 ms	0.09 Mb
DisplayAfterTitleTag	1.312 ms	0.01 Mb
=> lgcookieslaw	1.312 ms	0.01 Mb
displayContactCinfo	1.145 ms	0.03 Mb
=> ps_contactinfo (widget)	1.145 ms	0.03 Mb
DisplayFooterPart2	0.829 ms	0.02 Mb
=> tvcmsfooterlogo	0.829 ms	0.02 Mb
displayNavLanguageBlock	0.703 ms	0.05 Mb
=> ps_languageselector (widget)	0.703 ms	0.05 Mb
ProductSearchProvider	0.475 ms	- Mb
=> ps_facetedsearch	0.475 ms	- Mb
displayNavCurrencyBlock	0.413 ms	0.05 Mb
=> ps_currencyselector (widget)	0.413 ms	0.05 Mb
DisplayProductListStockIndicator	0.376 ms	0.01 Mb
=> tvcmsstockinfo	0.047 ms	- Mb
=> tvcmsstockinfo	0.026 ms	- Mb
=> tvcmsstockinfo	0.025 ms	- Mb
=> tvcmsstockinfo	0.015 ms	- Mb
=> tvcmsstockinfo	0.015 ms	- Mb
=> tvcmsstockinfo	0.011 ms	- Mb
=> tvcmsstockinfo	0.019 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.016 ms	- Mb
=> tvcmsstockinfo	0.010 ms	- Mb
=> tvcmsstockinfo	0.027 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.020 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.014 ms	- Mb
=> tvcmsstockinfo	0.010 ms	- Mb
=> tvcmsstockinfo	0.015 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.013 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
DisplayNavProductCompareBlock	0.335 ms	0.01 Mb
=> tvcmsproductcompare	0.335 ms	0.01 Mb
DisplayFacetedSearchBlock	0.285 ms	0.02 Mb
=> ps_facetedsearch	0.285 ms	0.02 Mb
DisplayProductComparesticky	0.232 ms	0.02 Mb
=> tvcmsproductcompare	0.232 ms	0.02 Mb
DisplayProductPriceBlock	0.229 ms	0.06 Mb
=> ets_reviews	0.010 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.006 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.007 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.004 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.006 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.003 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
=> ets_reviews	0.002 ms	- Mb
=> ets_reviews	0.001 ms	- Mb
=> ets_reviews	0.000 ms	- Mb
ActionObjectAddAfter	0.067 ms	- Mb
=> ets_seo	0.067 ms	- Mb
DisplayFooterStoreTime	0.037 ms	0.01 Mb
=> tvcmsstoretime	0.037 ms	0.01 Mb
DisplayTopOfferText	0.035 ms	- Mb
=> tvcmscustomsetting	0.028 ms	- Mb
=> tvcmscustomsetting	0.007 ms	- Mb
ActionDispatcherBefore	0.032 ms	- Mb
=> psassistant	0.023 ms	- Mb
=> ets_seo	0.009 ms	- Mb
ActionDispatcher	0.024 ms	- Mb
=> psassistant	0.014 ms	- Mb
=> fermopoint	0.010 ms	- Mb
ActionFrontControllerInitAfter	0.018 ms	- Mb
=> klaviyopsautomation	0.010 ms	- Mb
=> ets_affiliatemarketing	0.008 ms	- Mb
DisplayCustomCss	0.015 ms	- Mb
=> tvcmscustomcssjs	0.015 ms	- Mb
DisplayCustomJs	0.012 ms	- Mb
=> tvcmscustomcssjs	0.012 ms	- Mb
DisplayOverrideTemplate	0.011 ms	- Mb
=> ets_promotion	0.009 ms	- Mb
=> ets_seo	0.002 ms	- Mb
DisplayCopyRightText	0.011 ms	- Mb
=> tvcmscustomsetting	0.011 ms	- Mb
DisplayDownloadApps	0.005 ms	- Mb
=> tvcmscustomsetting	0.005 ms	- Mb
ActionObjectAddBefore	0.005 ms	- Mb
=> ets_seo	0.005 ms	- Mb
47 hook(s)	1243 ms	28.07 Mb

Module	Time	Memory Usage
klaviyopsautomation	1.141 ms	- Mb
__construct	1.101 ms	- Mb
hookModuleRoutes	0.012 ms	- Mb
hookActionFrontControllerInitAfter	0.017 ms	- Mb
hookActionFrontControllerSetMedia	0.011 ms	- Mb
ps_checkout	57.832 ms	0.38 Mb
__construct	1.678 ms	0.19 Mb
hookModuleRoutes	0.006 ms	- Mb
hookActionFrontControllerSetMedia	56.148 ms	0.18 Mb
tvcmsblog	51.930 ms	0.08 Mb
__construct	51.554 ms	0.03 Mb
hookModuleRoutes	0.049 ms	0.01 Mb
hookDisplayHeader	0.321 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	0.006 ms	- Mb
ets_reviews	6.378 ms	0.34 Mb
__construct	2.382 ms	0.20 Mb
hookModuleRoutes	3.431 ms	0.02 Mb
hookDisplayHeader	0.102 ms	- Mb
hookDisplayProductPriceBlock	0.016 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.009 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.010 ms	- Mb
hookDisplayProductPriceBlock	0.008 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.007 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.011 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb

#	Query	Time (ms)	Rows	Filesort	Location
168	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND c.nleft>=2 AND c.nright<=283 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) 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 ) WHERE ((sa.quantity>0)) GROUP BY p.id_manufacturer	75.309 ms	25960	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
162	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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_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 ) WHERE ((sa.quantity>0)) AND c.level_depth<=2 AND c.nleft>2 AND c.nright<283 GROUP BY cp.id_category	72.138 ms	129800	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
154	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) 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_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	68.392 ms	25960		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
395	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 984 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 984 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	61.686 ms	0		/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:117 (__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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
359	SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"	60.566 ms	1		/classes/CartRule.php:423 /override/classes/CartRule.php:27 (getCustomerCartRules) /classes/CartRule.php:578 (getCustomerCartRules) /classes/Cart.php:522 (getCustomerHighlightedDiscounts) /src/Adapter/Presenter/Cart/CartLazyArray.php:396 (getDiscounts) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getDiscounts) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/03/46/1a/03461a2365221812cfd712a45cfe5499c721e451_2.file.javascript.tpl.php:54 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e842817820_12858624) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/36/16/ae/3616aebfc06afdbd53cd54c6139c7386068aed79_2.file.head.tpl.php:296 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/36/16/ae/3616aebfc06afdbd53cd54c6139c7386068aed79_2.file.head.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69418878_86644367) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:103 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:41 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
462	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 974)	59.547 ms	1		/classes/Product.php:3860 /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:117 (__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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
157	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((p.on_sale=1)) AND ((sa_1.quantity>0))	58.426 ms	25960		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
334	SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 27) AND (b.`id_shop` = 1) LIMIT 1	54.108 ms	1		/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
136	SELECT SQL_NO_CACHE `name` FROM `ps_country_lang` WHERE `id_lang` = 1 AND `id_country` = 19 LIMIT 1	51.394 ms	1		/classes/Country.php:252 /modules/gmerchantcenterpro/lib/moduleTools.php:210 (getNameById) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
61	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_accounts" LIMIT 1	49.507 ms	1		/src/Adapter/Module/ModuleDataProvider.php:257 /src/Adapter/Module/ModuleDataProvider.php:228 (getModuleIdByName) /src/Core/Module/ModuleManager.php:329 (isInstalled) /modules/klaviyopsautomation/vendor/prestashop/prestashop-accounts-installer/src/Installer/Installer.php:83 (isInstalled) /modules/klaviyopsautomation/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php:44 (isModuleInstalled) /modules/klaviyopsautomation/vendor/prestashop/prestashop-accounts-installer/src/Installer/Facade/PsAccounts.php:62 (getService) /modules/ps_checkout/src/Repository/PsAccountRepository.php:46 (getPsAccountsService) /var/cache/prod/Ps_checkout8440FrontContainer.php:1149 (__construct) /var/cache/prod/Ps_checkout8440FrontContainer.php:1239 (getPsAccountRepositoryService) /var/cache/prod/Ps_checkout8440FrontContainer.php:1229 (getMerchantValidatorService) /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php:257 (getFrontControllerValidatorService) /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php:231 (make) /modules/klaviyopsautomation/vendor/prestashop/module-lib-service-container/src/DependencyInjection/ServiceContainer.php:64 (get) /modules/ps_checkout/ps_checkout.php:1519 (getService) /modules/ps_checkout/ps_checkout.php:913 (getService) /classes/Hook.php:1083 (hookActionFrontControllerSetMedia) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /classes/controller/FrontController.php:1004 (exec) /tools/profiling/Controller.php:48 (setMedia) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pm_advancedpack" LIMIT 1	49.300 ms	0		/classes/module/Module.php:2664 /classes/module/Module.php:2112 (getModuleIdByName) /modules/gmerchantcenterpro/lib/moduleTools.php:543 (isInstalled) /modules/gmerchantcenterpro/gmerchantcenterpro.php:186 (isInstalled) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
242	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 23 AND id_shop=1 LIMIT 1	49.097 ms	1		/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
554	SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute 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) WHERE pa.id_product = 3 LIMIT 1	35.707 ms	1		/classes/Product.php:1106 /classes/Product.php:3817 (getDefaultAttribute) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
884	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 469 AND id_shop=1 LIMIT 1	34.757 ms	1		/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1171	SELECT SQL_NO_CACHE xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `ps_tvcms_category_post` xcp INNER JOIN `ps_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `ps_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = 1) INNER JOIN `ps_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = 1) WHERE xcp.`id_post` = 2 AND xcp.`type` = "tag"	30.328 ms	1		/modules/tvcmsblog/classes/tvcmspostsclass.php:577 /modules/tvcmsblog/classes/tvcmspostsclass.php:747 (getPostTagsResults) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:418 (getCategoryPosts) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:483 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
909	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 256 AND image_shop.`cover` = 1 LIMIT 1	29.700 ms	1		/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /classes/Product.php:5990 (getProductProperties) /classes/ProductSale.php:161 (getProductsProperties) /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1048	SELECT SQL_NO_CACHE xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `ps_tvcms_category_post` xcp INNER JOIN `ps_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `ps_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = 1) INNER JOIN `ps_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = 1) WHERE xcp.`id_post` = 3 AND xcp.`type` = "tag"	23.378 ms	1		/modules/tvcmsblog/classes/tvcmspostsclass.php:577 /modules/tvcmsblog/classes/tvcmspostsclass.php:747 (getPostTagsResults) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:418 (getCategoryPosts) /modules/tvcmsblogdisplayposts/tvcmsblogdisplayposts.php:483 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
863	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("2025-05-15 00:00:00", INTERVAL 1000 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 RAND() LIMIT 4	17.952 ms	649	Yes	/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
155	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) 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 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	16.715 ms	25960		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
908	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-05-15 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT 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_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`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 10 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) 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 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' ORDER BY `sales` DESC LIMIT 0, 4	16.402 ms	649	Yes	/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
166	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, cp.position 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) GROUP BY pac.id_attribute	15.865 ms	25960	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
152	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	15.464 ms	64900	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
836	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 971 AND image_shop.`cover` = 1 LIMIT 1	13.234 ms	1		/classes/Product.php:3570 /classes/Product.php:5643 (getCover) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3404 (getProductsProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) 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 ) WHERE ((sa.quantity>0)) GROUP BY p.condition	13.124 ms	25960	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:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
159	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 10) AND sp.id_group IN (0, 3) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-05-15 15:35:27' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-15 15:35:27' <= sp.to) ) 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_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0))	11.042 ms	25960		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
158	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) 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 ) WHERE ((sa.quantity>0)) AND p.date_add>'2022-08-20 00:00:00'	10.808 ms	25960		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
156	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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_category_product cp ON (p.id_product = cp.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 c ON (cp.id_category = c.id_category AND c.active=1) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283 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) 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 ) WHERE ((sa.quantity>0))	10.741 ms	25960		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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`)	8.171 ms	1258		/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
163	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	7.173 ms	0		/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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
160	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 = 10) 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_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 ) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283	7.100 ms	6490		/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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
543	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-05-15 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_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` 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 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-05-15 00:00:00", INTERVAL 1000 DAY ) ) > 0) ORDER BY product_shop.`date_add` DESC LIMIT 4	6.926 ms	4		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	SHOW TABLES LIKE "ps_gmcp_1800"	6.622 ms	1		/modules/gmerchantcenterpro/lib/moduleUpdate.php:88 :undefined (updateTables) /modules/gmerchantcenterpro/lib/moduleUpdate.php:61 (call_user_func_array) /modules/gmerchantcenterpro/lib/moduleTools.php:193 (run) /modules/gmerchantcenterpro/gmerchantcenterpro.php:197 (getLangCurrencyCountry) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1263 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1242 (coreLoadModule) /classes/Hook.php:972 (getInstanceByName) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
192	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	4.963 ms	0		/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
170	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_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 ) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND p.id_manufacturer='1' AND c.nleft>=2 AND c.nright<=283	4.852 ms	6490		/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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
364	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-05-15 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_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` 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 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-05-15 00:00:00", INTERVAL 1000 DAY ) ) > 0) ORDER BY product_shop.`date_add` DESC LIMIT 10	4.840 ms	10		/classes/Product.php:3110 /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1083 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:117 (__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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
876	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) 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 = 1) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 100 AND pac.`id_product_attribute` = 56 AND agl.`id_lang` = 1	4.610 ms	1		/classes/Product.php:7535 /classes/Product.php:5857 (getAttributesParams) /classes/Product.php:5990 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:1083 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1285	SELECT SQL_NO_CACHE 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` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (86,87) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	4.457 ms	2		/classes/Product.php:2752 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/93/32/1f/93321fb1217b4da40b0c68f53e9d1d8119efa71f_2.file.product-grid-view.tpl.php:45 (offsetGet) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/93/32/1f/93321fb1217b4da40b0c68f53e9d1d8119efa71f_2.file.product-grid-view.tpl.php:123 (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:156 (process) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/93/32/1f/93321fb1217b4da40b0c68f53e9d1d8119efa71f_2.file.product-grid-view.tpl.php:30 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e84249dab4_80159344) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/a7/4f/31/a74f31d330c252bd4ab758afbae73b95e77966ba_2.file.product.tpl.php:50 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/a7/4f/31/a74f31d330c252bd4ab758afbae73b95e77966ba_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f6a33f757_21038833) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/09/95/97/0995979556a841d015025874a9d1a08b2f5a687c_2.file.products.tpl.php:50 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/09/95/97/0995979556a841d015025874a9d1a08b2f5a687c_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e8447fb6d6_69724085) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:78 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:133 (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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:70 (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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:77 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
526	SELECT SQL_NO_CACHE count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=0 LIMIT 1	4.414 ms	3		/modules/tvcmswishlist/tvcmswishlist.php:278 /modules/tvcmswishlist/tvcmswishlist.php:223 (headerData) /classes/Hook.php:1083 (hookdisplayNavWishlistBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/d7/8c/52/d78c525e835956275175baed0dc1961dd1dd5470_2.file.desk-header-4.tpl.php:39 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e84411ed33_73816054) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/1d/d8/d3/1dd8d30d11b8305632e1713f0fc527bbff25834f_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69e35258_98697214) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/d0/c8/99/d0c899298e2c7cf95202bfd50ba7a6f767510e61_2.file.header.tpl.php:55 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/d0/c8/99/d0c899298e2c7cf95202bfd50ba7a6f767510e61_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69e0cc59_18739253) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:147 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:65 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
353	SELECT SQL_NO_CACHE r.,rl.name,a. FROM `ps_ets_pr_rule` r INNER JOIN `ps_ets_pr_action_rule` a ON (r.id_ets_pr_rule = a.id_ets_pr_rule) LEFT JOIN `ps_ets_pr_rule_lang` rl ON (r.id_ets_pr_rule=rl.id_ets_pr_rule AND rl.id_lang="1") LEFT JOIN `ps_ets_pr_cart_rule` cr ON (cr.id_ets_pr_rule=r.id_ets_pr_rule AND cr.id_cart="0") WHERE r.active=1 AND a.code!="" AND (r.from_date ="0000-00-00 00:00:00" or r.from_date <="2025-05-15 15:35:27") AND (r.to_date ="0000-00-00 00:00:00" or r.to_date >="2025-05-15 15:35:27") AND r.id_shop = "1"	4.320 ms	1		/modules/ets_promotion/classes/ets_pr_rule.php:2085 /modules/ets_promotion/ets_promotion.php:1793 (getCustomerCartRules) /override/classes/CartRule.php:28 (getCustomerCartRules) /classes/Cart.php:3079 (getCustomerCartRules) /classes/Cart.php:3463 (getDeliveryOptionList) /classes/Cart.php:3536 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2201 (processCalculation) /override/classes/Cart.php:30 (getOrderTotal) /src/Adapter/Presenter/Cart/CartLazyArray.php:185 (getOrderTotal) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getTotals) /src/Adapter/Presenter/AbstractLazyArray.php:129 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/prod/smarty/compile/child_v4_swert_smell_70layouts_layout_left_column_tpl/03/46/1a/03461a2365221812cfd712a45cfe5499c721e451_2.file.javascript.tpl.php:54 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e842817820_12858624) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/36/16/ae/3616aebfc06afdbd53cd54c6139c7386068aed79_2.file.head.tpl.php:296 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/36/16/ae/3616aebfc06afdbd53cd54c6139c7386068aed79_2.file.head.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69418878_86644367) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:103 (_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/child_v4_swert_smell_70layouts_layout_left_column_tpl/8f/37/95/8f3795b4a93d48b203ec4f57dbf6538087b26c3f_2.file.layout-both-columns.tpl.php:41 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69396bf4_25173037) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/2c/f3/59/2cf359a4bde30a497bd3846c4e7eed28bd416158_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f693498d1_48637902) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/06/96/b8/0696b8dda42afe8abc39c0ae77760a155a97487a_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_681b4f69318f69_46238223) /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/child_v4_swert_smell_70layouts_layout_left_column_tpl/e9/63/70/e963706bc093b6c72ec0976bcd7f9787d22154f2_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6825e843ab5c66_97590843) /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/Smarty/SmartyCustom.php:112 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
171	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 = 3 ORDER BY agl.`name` ASC, a.`position` ASC	4.115 ms	0		/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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (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/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.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/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php

Kit Insight Anti-Frizz Shampoo 900ml + Conditioner 900ml

Kit Insight Anti-Frizz Shampoo 350ml + Conditioner 350ml

Kit Insight Anti-Frizz Shampoo 900ml + Maschera 400ml

Kit Insight Anti-Frizz Shampoo 350ml + Maschera 200ml

Kit Insight Anti-Frizz Shampoo 75ml + Maschera 75ml

Insight Dry Hair Shampoo 900ml + Conditioner capelli nutriente 900ml

Insight Dry Hair Shampoo 900ml + Maschera capelli nutriente 400ml

Insight Dry Hair Shampoo 100ml + Maschera capelli nutriente 75ml

Insight Dry Hair Shampoo 350ml + Maschera capelli nutriente 200ml

Insight Dry Hair Shampoo 350ml + Conditioner capelli nutriente 350ml

Carrello

Emsibeth: La Scienza Italiana al Servizio della Salute e della Bellezza dei Tuoi Capelli

Insight: La Natura al Servizio della Bellezza Autentica dei Tuoi Capelli

Framesi: L'Eccellenza Italiana per Capelli che Ispirano

Davines: La Bellezza Sostenibile che Nutre i Tuoi Capelli (e il Pianeta!)

DAVINES OI KIT MILK 135ML + OIL 135ML

DAVINES OI KIT MILK 135ML + OIL 135ML

DAVINES OI KIT MILK 135ML + OIL 135ML

DAVINES OI KIT MILK 135ML + OIL 135ML

DAVINES OI SHAMPOO 280ML

DAVINES OI SHAMPOO 280ML

DAVINES OI SHAMPOO 280ML

DAVINES OI SHAMPOO 280ML

DAVINES OI ALL IN ONE MILK 135ML

DAVINES OI ALL IN ONE MILK 135ML

DAVINES OI ALL IN ONE MILK 135ML

DAVINES OI ALL IN ONE MILK 135ML

DAVINES OI CONDITIONER 250ML

DAVINES OI CONDITIONER 250ML

DAVINES OI CONDITIONER 250ML

DAVINES OI CONDITIONER 250ML

DAVINES OI BUTTER 250ML

DAVINES OI BUTTER 250ML

DAVINES OI BUTTER 250ML

DAVINES OI BUTTER 250ML

DAVINES OI HAND BALM 75ML - CREMA MANI

DAVINES OI HAND BALM 75ML - CREMA MANI

DAVINES OI HAND BALM 75ML - CREMA MANI

DAVINES OI HAND BALM 75ML - CREMA MANI

DAVINES OI BODY WASH 280ML

DAVINES OI BODY WASH 280ML

DAVINES OI BODY WASH 280ML

DAVINES OI BODY WASH 280ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + ALL IN ONE MILK 135ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + ALL IN ONE MILK 135ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + ALL IN ONE MILK 135ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + ALL IN ONE MILK 135ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + OI OIL 50ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + OI OIL 50ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + OI OIL 50ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML + OI OIL 50ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML

DAVINES OI KIT SHAMPOO 280ML + CONDITIONER 250ML

DAVINES OI OIL 135ML

DAVINES OI OIL 135ML

DAVINES OI OIL 135ML

DAVINES OI OIL 135ML

DAVINES ANTICADUTA NATURALTECH ENERGIZING SHAMPOO 250ML

DAVINES ANTICADUTA NATURALTECH ENERGIZING SHAMPOO 250ML

DAVINES ANTICADUTA NATURALTECH ENERGIZING SHAMPOO 250ML

DAVINES ANTICADUTA NATURALTECH ENERGIZING SHAMPOO 250ML

Stopwatch SQL - 1417 queries

Doubles

Tables stress

ObjectModel instances

Included Files