Начало

Мойсанит – диамантен блясък от Космоса до бижутата

<p>Когато говорим за скъпоценни камъни, диамантите обикновено са първата асоциация, която изниква в съзнанието ни. В последно време обаче, своето ...

Защо камъните на бижутата изпадат и как да го предотвратим?

Feb 27

Венета Асенова

Защо камъните на бижутата изпадат и как да го предотвратим?

<p>Симбиозата между блясъка на среброто и красотата на различни цветни камъни създава от всяко бижу шедьовър. Такъв тип украшения са чудесен избор ...

Защо среброто потъмнява? Как да почистим сребърните бижута?

Feb 27

Венета Асенова

Защо среброто потъмнява? Как да почистим сребърните бижута?

<p>Още от древността сребърните украшения са били предпочитани заради красотата и елегантността си. Неслучайно латинското наименование на среброто ...

Load Time	1594 ms
Querying Time	410 ms
Queries	634
Memory Peak Usage	20.2 Mb
Included Files	1259 files - 15.09 Mb
PrestaShop Cache	- Mb
Global vars	0.12 Mb
- global $_MODULES	95k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k

PrestaShop Version	8.2.0
PHP Version	8.2.28
MySQL Version	10.6.21-MariaDB-0ubuntu0.22.04.2
Memory Limit	256M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	23.450 ms	23.450 ms	3.49 Mb	3.7 Mb
__construct	0.016 ms	23.466 ms	- Mb	3.7 Mb
init	41.883 ms	65.349 ms	0.61 Mb	4.4 Mb
checkAccess	0.002 ms	65.351 ms	- Mb	4.4 Mb
setMedia	0.890 ms	66.241 ms	0.05 Mb	4.4 Mb
postProcess	0.002 ms	66.243 ms	- Mb	4.4 Mb
initHeader	0.001 ms	66.244 ms	- Mb	4.4 Mb
initContent	251.368 ms	317.612 ms	4.07 Mb	8.3 Mb
initFooter	0.003 ms	317.615 ms	- Mb	8.3 Mb
display	1277 ms	1594 ms	11.63 Mb	20.2 Mb

81 queries	SELECT xcp.`id_category`,xcl.`name`,xcl.`link_rewrite` FROM `cfXX_tvcms_category_post` xcp INNER JOIN `cfXX_tvcmscategory` xc ON (xcp.`id_category` = xc.`id_tvcmscategory` AND xc.`category_type` = "tag") INNER JOIN `cfXX_tvcmscategory_lang` xcl ON (xcp.`id_category` = xcl.`id_tvcmscategory` AND xcl.`id_lang` = XX) INNER JOIN `cfXX_tvcmscategory_shop` xcs ON (xcp.`id_category` = xcs.`id_tvcmscategory` AND xcs.`id_shop` = XX) WHERE xcp.`id_post` = XX AND xcp.`type` = "tag"
81 queries	SELECT COUNT(id_tvcms_comments) AS total_comment FROM `cfXX_tvcms_comments` xc WHERE xc.`id_post` = XX
29 queries	SELECT SUM(quantity) FROM `cfXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
22 queries	SELECT `id_module` FROM `cfXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
15 queries	SELECT * FROM `cfXX_category` a LEFT JOIN `cfXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `cfXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
14 queries	SELECT 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 `cfXX_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 `cfXX_cart_product` cp JOIN `cfXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cfXX_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
10 queries	SELECT * FROM `cfXX_category` a LEFT JOIN `cfXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
10 queries	SELECT * FROM `cfXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
8 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `cfXX_module` m LEFT JOIN `cfXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
8 queries	SELECT image_shop.`id_image` FROM `cfXX_image` i INNER JOIN cfXX_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
8 queries	SELECT name FROM cfXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
8 queries	SELECT * FROM `cfXX_product` a LEFT JOIN `cfXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `cfXX_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
8 queries	SELECT `priority`, `id_specific_price_priority` FROM `cfXX_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
8 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 `cfXX_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
8 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 `cfXX_product` p INNER JOIN `cfXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `cfXX_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)
8 queries	SELECT `id_tax_rules_group` FROM `cfXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
8 queries	SELECT `reduction` FROM `cfXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
8 queries	SELECT COUNT(*) FROM `cfXX_pack` WHERE id_product_pack = XX LIMIT XX
8 queries	SELECT product_type FROM `cfXX_product` WHERE id_product = XX LIMIT XX
8 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM cfXX_feature_product pf LEFT JOIN cfXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN cfXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN cfXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN cfXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
8 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `cfXX_image` i INNER JOIN cfXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `cfXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
8 queries	SELECT `id_product_attribute` FROM `cfXX_product_attribute` WHERE `id_product` = XX
7 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `cfXX_category` c LEFT JOIN `cfXX_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN cfXX_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
7 queries	SELECT cg.`id_group` FROM `cfXX_category_group` cg WHERE (cg.`id_category` = XX)
6 queries	SELECT product_attribute_shop.`price` FROM `cfXX_product_attribute` pa INNER JOIN cfXX_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
6 queries	SELECT pa.`available_date` FROM `cfXX_product` p LEFT JOIN `cfXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN cfXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN cfXX_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
6 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 `cfXX_attribute` a LEFT JOIN `cfXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `cfXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `cfXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN cfXX_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 `cfXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `cfXX_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
6 queries	SELECT * FROM `cfXX_product_attribute` a LEFT JOIN `cfXX_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
6 queries	SELECT * FROM `cfXX_product_attribute_lang` WHERE `id_product_attribute` = XX
4 queries	SELECT `id_lang` FROM `cfXX_lang` WHERE `locale` = 'bg-bg' OR `language_code` = 'bg-bg' LIMIT XX
4 queries	SELECT cl.`link_rewrite` FROM `cfXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT * FROM `cfXX_product` a LEFT JOIN `cfXX_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 `cfXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
4 queries	SELECT DISTINCT pl.name as name FROM `cfXX_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
4 queries	SELECT pac.`id_product_attribute`, al.`name` AS attribute_name FROM `cfXX_product_attribute_combination` pac LEFT JOIN `cfXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `cfXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `cfXX_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX
4 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 cfXX_product p LEFT JOIN cfXX_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN cfXX_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX AND sa.id_product_attribute = XX AND sa.id_shop_group = XX LEFT JOIN cfXX_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
4 queries	SELECT pa., product_attribute_shop. FROM `cfXX_product_attribute` pa INNER JOIN cfXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
3 queries	SELECT `need_identification_number` FROM `cfXX_country` WHERE `id_country` = XX LIMIT XX
3 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 `cfXX_attribute_group` ag INNER JOIN `cfXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `cfXX_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `cfXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN cfXX_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 cfXX_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `cfXX_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
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `cfXX_product_attribute_image` pai LEFT JOIN `cfXX_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `cfXX_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT id_shop FROM `cfXX_employee_shop` WHERE `id_employee` = XX
3 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `cfXX_product_attribute_combination` pac LEFT JOIN `cfXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `cfXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `cfXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `cfXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
2 queries	SELECT * FROM `cfXX_currency` a LEFT JOIN `cfXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `cfXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT `id_category` FROM `cfXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, XX) 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("XX-XX-XX XX:XX:XX", INTERVAL XX DAY)) > XX AS new, product_shop.price AS orderprice FROM `cfXX_category_product` cp LEFT JOIN `cfXX_product` p ON p.`id_product` = cp.`id_product` INNER JOIN cfXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `cfXX_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 cfXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop_group = XX AND stock.id_shop = XX ) LEFT JOIN `cfXX_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = XX ) LEFT JOIN `cfXX_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX ) LEFT JOIN `cfXX_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 `cfXX_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX) LEFT JOIN `cfXX_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = XX AND cp.`id_category` = XX AND product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT XX,XX
2 queries	SELECT c.id_category, cl.name, cl.link_rewrite FROM cfXX_category c LEFT JOIN cfXX_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN cfXX_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = XX )WHERE c.nleft <= XX AND c.nright >= XX AND c.nleft >= XX AND c.nright <= XX AND cl.id_lang = XX AND c.level_depth > XX ORDER BY c.level_depth ASC
2 queries	SELECT XX FROM `cfXX_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 pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `cfXX_product_attribute_image` pai LEFT JOIN `cfXX_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `cfXX_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
2 queries	SELECT `value` FROM cfXX_ce_meta WHERE `id` = XX AND `name` = "_elementor_page_settings" LIMIT XX
2 queries	SELECT * FROM `cfXX_tvcms_image_type` WHERE active = XX AND id_shop = XX
2 queries	SELECT * FROM `cfXX_employee` a LEFT JOIN `cfXX_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = XX WHERE (a.`id_employee` = XX) LIMIT XX

Name	Instances	Source
Category	76	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 13] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 28] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 46] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 51] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/facebookproductad/lib/pixel/pixelCategory.php:46 (__construct) [id: 2] /modules/facebookproductad/lib/moduleTools.php:468 (__construct) [id: 2] /modules/facebookproductad/lib/pixel/pixelCategory.php:46 (__construct) [id: 2] /modules/facebookproductad/lib/moduleTools.php:468 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Meta.php:380 (__construct) [id: 2] /modules/ets_seo/ets_seo.php:2593 (__construct) [id: 2] /modules/ets_seo/ets_seo.php:2774 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 51] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1384 (__construct) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 51] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 51] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 51] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 2] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 10] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 10] /classes/Link.php:402 (__construct) [id: 10] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 10] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 11] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 11] /classes/Link.php:402 (__construct) [id: 11] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 11] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 12] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 12] /classes/Link.php:402 (__construct) [id: 12] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 12] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 13] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 13] /classes/Link.php:402 (__construct) [id: 13] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 13] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 46] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 46] /classes/Link.php:402 (__construct) [id: 46] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 46] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1395 (__construct) [id: 28] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1774 (__construct) [id: 28] /classes/Link.php:402 (__construct) [id: 28] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 28] /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/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 10] /classes/Link.php:402 (__construct) [id: 10] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 14] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 15] /classes/Link.php:402 (__construct) [id: 15] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 16] /classes/Link.php:402 (__construct) [id: 16] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 17] /classes/Link.php:402 (__construct) [id: 17] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 18] /classes/Link.php:402 (__construct) [id: 18] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 19] /classes/Link.php:402 (__construct) [id: 19] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 20] /classes/Link.php:402 (__construct) [id: 20]
Product	28	/classes/Link.php:113 (__construct) [id: 887] /classes/Link.php:113 (__construct) [id: 877] /classes/Link.php:113 (__construct) [id: 875] /classes/Link.php:113 (__construct) [id: 873] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 887] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 877] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 875] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 873] /classes/Link.php:113 (__construct) [id: 887] /classes/Link.php:113 (__construct) [id: 877] /classes/Link.php:113 (__construct) [id: 875] /classes/Link.php:113 (__construct) [id: 873] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 887] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 877] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 875] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 873] /classes/Link.php:113 (__construct) [id: 326] /classes/Link.php:113 (__construct) [id: 300] /classes/Link.php:113 (__construct) [id: 299] /classes/Link.php:113 (__construct) [id: 329] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 326] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 300] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 299] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 329] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 887] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 877] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 875] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 873]
Combination	10	/classes/Product.php:5912 (__construct) [id: 614] /classes/Product.php:5912 (__construct) [id: 600] /classes/Product.php:5912 (__construct) [id: 593] /classes/Product.php:5912 (__construct) [id: 585] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 614] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 600] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 593] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:72 (__construct) [id: 585] /classes/Product.php:5912 (__construct) [id: 303] /classes/Product.php:5912 (__construct) [id: 497]
Country	7	/config/config.inc.php:146 (__construct) [id: 233] /classes/AddressFormat.php:404 (__construct) [id: 233] /classes/controller/FrontController.php:1779 (__construct) [id: 233] /classes/AddressFormat.php:404 (__construct) [id: 233] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 233] /classes/AddressFormat.php:404 (__construct) [id: 233] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 233]
Language	5	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/facebookproductad/lib/hook/hookDisplay.php:91 (__construct) [id: 1] /modules/facebookproductad/lib/pixel/pixelCategory.php:39 (__construct) [id: 1] /modules/facebookproductad/lib/pixel/pixelCategory.php:39 (__construct) [id: 1]
CETemplate	5	/modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 8] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 8] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 8] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 8] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 8]
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: ]
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: ]
TvcmsCategoryClass	3	/modules/tvcmsblog/classes/tvcmspostsclass.php:801 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:801 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:801 (__construct) [id: 1]
Employee	3	/modules/tvcmsblog/classes/tvcmspostsclass.php:755 (__construct) [id: 1] /modules/tvcmsblog/classes/tvcmspostsclass.php:755 (__construct) [id: 8] /modules/tvcmsblog/classes/tvcmspostsclass.php:755 (__construct) [id: 8]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
State	3	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
CETheme	3	/modules/creativeelements/creativeelements.php:666 (__construct) [id: ] /modules/creativeelements/creativeelements.php:666 (__construct) [id: ] /modules/creativeelements/creativeelements.php:666 (__construct) [id: ]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Group	2	/classes/Cart.php:249 (getCurrent) [id: 1] /modules/ets_abandonedcart/classes/EtsAbancartCampaign.php:376 (__construct) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Meta	1	/modules/ets_seo/classes/dispatcher/EtsSeoDispatcher.php:559 (__construct) [id: 0]
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: ]

Мойсанит – диамантен блясък от Космоса до бижутата

Защо камъните на бижутата изпадат и как да го предотвратим?

Защо среброто потъмнява? Как да почистим сребърните бижута?

Обеци Розов блян

Обеци Розов блян

Обеци Розов блян

Обеци Розов блян

Обеци Шарена висота

Обеци Шарена висота

Обеци Шарена висота

Обеци Шарена висота

Обеци Цветно чувство

Обеци Цветно чувство

Обеци Цветно чувство

Обеци Цветно чувство

Обеци Цветна плетка

Обеци Цветна плетка

Обеци Цветна плетка

Обеци Цветна плетка

Stopwatch SQL - 634 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Hook	Time	Memory Usage
DisplayLeftColumn	103.240 ms	6.26 Mb
=> tvcmsnewproducts	0.114 ms	- Mb
=> tvcmscustomerservices	0.238 ms	0.02 Mb
=> tvcmsspecialproducts	2.031 ms	0.10 Mb
=> tvcmsfeaturedproducts	0.103 ms	- Mb
=> tvcmsbestsellerproducts	45.518 ms	2.46 Mb
=> tvcmstestimonial	0.857 ms	0.03 Mb
=> tvcmsblogdisplayposts	54.379 ms	3.65 Mb
DisplayHeader	27.216 ms	0.78 Mb
=> creativeelements	2.890 ms	0.25 Mb
=> ps_shoppingcart	0.420 ms	- Mb
=> ps_searchbar	0.232 ms	- Mb
=> tvcmsblog	0.260 ms	- Mb
=> tvcmsadvanceblock	0.048 ms	- Mb
=> tvcmsbestsellerproducts	0.052 ms	- Mb
=> tvcmsblogdisplayposts	0.059 ms	- Mb
=> tvcmsbrandlist	0.038 ms	- Mb
=> tvcmscategorychainslider	0.058 ms	- Mb
=> tvcmscategoryslider	0.040 ms	- Mb
=> tvcmscookiesnotice	0.042 ms	- Mb
=> tvcmscustomerservices	0.043 ms	- Mb
=> tvcmscustomsetting	0.327 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.048 ms	- Mb
=> tvcmsfooterlogo	0.002 ms	- Mb
=> tvcmsfooterproduct	0.032 ms	- Mb
=> tvcmsmultibanner1	0.036 ms	- Mb
=> tvcmsnewproducts	0.050 ms	- Mb
=> tvcmsnewsletterpopup	0.079 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmssearch	0.086 ms	- Mb
=> tvcmssizechart	0.037 ms	- Mb
=> tvcmsslider	0.039 ms	- Mb
=> tvcmsspecialproducts	0.036 ms	- Mb
=> tvcmstabproducts	0.063 ms	- Mb
=> tvcmstestimonial	0.050 ms	- Mb
=> tvcmsthemeoptions	0.122 ms	- Mb
=> cdc_googletagmanager	0.043 ms	- Mb
=> facebookproductad	8.575 ms	0.20 Mb
=> ets_promotion	3.672 ms	0.17 Mb
=> productcomments	0.086 ms	- Mb
=> ets_onepagecheckout	0.037 ms	- Mb
=> ets_abandonedcart	8.064 ms	0.08 Mb
=> ets_seo	1.550 ms	0.03 Mb
DisplayMegamenu	16.087 ms	0.58 Mb
=> tvcmsmegamenu	16.087 ms	0.58 Mb
DisplayAfterTitleTag	15.314 ms	0.70 Mb
=> cdc_googletagmanager	15.314 ms	0.70 Mb
OverrideLayoutTemplate	9.735 ms	0.08 Mb
=> creativeelements	0.007 ms	- Mb
=> creativeelements	0.007 ms	- Mb
=> creativeelements	9.716 ms	0.08 Mb
=> creativeelements	0.005 ms	- Mb
DisplayFooterCategory	9.101 ms	0.73 Mb
=> tvcmsfootercategory	9.101 ms	0.73 Mb
displayLeftColumn	8.680 ms	0.29 Mb
=> ps_categorytree (widget)	6.388 ms	0.14 Mb
=> ps_brandlist (widget)	1.236 ms	0.07 Mb
=> ps_supplierlist (widget)	1.056 ms	0.07 Mb
displayNavShoppingCartBlock	7.488 ms	0.09 Mb
=> ps_shoppingcart (widget)	7.488 ms	0.09 Mb
DisplayBeforeBodyClosingTag	2.774 ms	0.12 Mb
=> statsdata	2.770 ms	0.12 Mb
=> tvcmsblog	0.004 ms	- Mb
DisplayNavSearchBlock	2.240 ms	0.13 Mb
=> tvcmssearch	2.240 ms	0.13 Mb
FilterProductSearch	2.011 ms	0.01 Mb
=> creativeelements	2.011 ms	0.01 Mb
displayNav1	1.422 ms	0.04 Mb
=> ps_contactinfo (widget)	1.422 ms	0.04 Mb
DisplayCustomsocialblock	1.198 ms	0.12 Mb
=> tvcmscustomsetting	1.198 ms	0.12 Mb
displayMyaccountcblock	1.181 ms	0.10 Mb
=> ps_customeraccountlinks (widget)	1.181 ms	0.10 Mb
displayFooterPart1	1.153 ms	0.10 Mb
=> ps_linklist (widget)	1.153 ms	0.10 Mb
displaySocialMediaBlock	1.143 ms	0.10 Mb
=> ps_socialfollow (widget)	1.143 ms	0.10 Mb
displayNewslettersubscription	0.902 ms	0.06 Mb
=> ps_emailsubscription (widget)	0.902 ms	0.06 Mb
DisplayPaymentIcon	0.873 ms	0.04 Mb
=> tvcmspaymenticon	0.873 ms	0.04 Mb
Header	0.730 ms	0.02 Mb
=> tvcmsstockinfo	0.047 ms	- Mb
=> tvcmsinfinitescroll	0.350 ms	0.01 Mb
=> tvcmsofferbanner	0.094 ms	- Mb
=> tvcmscategoryproduct	0.125 ms	- Mb
=> tvcmsmegamenu	0.114 ms	- Mb
displayContactCinfo	0.687 ms	0.03 Mb
=> ps_contactinfo (widget)	0.687 ms	0.03 Mb
displayNavCustomerSignInBlock	0.526 ms	0.06 Mb
=> ps_customersignin (widget)	0.526 ms	0.06 Mb
displayNavCurrencyBlock	0.491 ms	0.09 Mb
=> ps_currencyselector (widget)	0.491 ms	0.09 Mb
displayNavLanguageBlock	0.362 ms	0.06 Mb
=> ps_languageselector (widget)	0.362 ms	0.06 Mb
ProductSearchProvider	0.340 ms	- Mb
=> ps_facetedsearch	0.340 ms	- Mb
DisplayAfterBodyOpeningTag	0.267 ms	0.02 Mb
=> tvcmscookiesnotice	0.261 ms	0.02 Mb
=> blockreassurance	0.006 ms	- Mb
DisplayFacetedSearchBlock	0.233 ms	0.03 Mb
=> ps_facetedsearch	0.233 ms	0.03 Mb
ActionFrontControllerSetMedia	0.205 ms	0.01 Mb
=> blockreassurance	0.105 ms	- Mb
=> ps_emailsubscription	0.045 ms	- Mb
=> ps_socialfollow	0.027 ms	- Mb
=> ps_emailalerts	0.028 ms	- Mb
DisplayCopyRightText	0.182 ms	0.01 Mb
=> tvcmscustomsetting	0.182 ms	0.01 Mb
DisplayProductListStockIndicator	0.125 ms	- Mb
=> tvcmsstockinfo	0.025 ms	- Mb
=> tvcmsstockinfo	0.014 ms	- Mb
=> tvcmsstockinfo	0.017 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.016 ms	- Mb
=> tvcmsstockinfo	0.011 ms	- Mb
=> tvcmsstockinfo	0.018 ms	- Mb
=> tvcmsstockinfo	0.011 ms	- Mb
DisplayProductPriceBlock	0.077 ms	0.02 Mb
=> cdc_googletagmanager	0.005 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.005 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.004 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
ActionObjectAddAfter	0.061 ms	0.06 Mb
=> ets_seo	0.061 ms	0.06 Mb
ActionDispatcherBefore	0.041 ms	- Mb
=> psassistant	0.007 ms	- Mb
=> ets_onepagecheckout	0.003 ms	- Mb
=> ets_productmanager	0.003 ms	- Mb
=> ets_abandonedcart	0.025 ms	- Mb
=> ets_seo	0.003 ms	- Mb
ModuleRoutes	0.036 ms	0.01 Mb
=> tvcmsblog	0.029 ms	0.01 Mb
=> ets_abandonedcart	0.007 ms	0.01 Mb
ActionFrontControllerInitAfter	0.028 ms	- Mb
=> creativeelements	0.028 ms	- Mb
DisplayFooter	0.028 ms	- Mb
=> ets_abandonedcart	0.028 ms	- Mb
DisplayTopOfferText	0.021 ms	- Mb
=> tvcmscustomsetting	0.015 ms	- Mb
=> tvcmscustomsetting	0.006 ms	- Mb
DisplayDownloadApps	0.014 ms	- Mb
=> tvcmscustomsetting	0.014 ms	- Mb
DisplayCustomCss	0.013 ms	- Mb
=> tvcmscustomcssjs	0.013 ms	- Mb
DisplayOverrideTemplate	0.009 ms	- Mb
=> creativeelements	0.004 ms	- Mb
=> ets_promotion	0.003 ms	- Mb
=> ets_seo	0.002 ms	- Mb
ActionDispatcher	0.008 ms	- Mb
=> psassistant	0.008 ms	- Mb
DisplayCustomJs	0.008 ms	- Mb
=> tvcmscustomcssjs	0.008 ms	- Mb
DisplayNavFullWidth	0.007 ms	- Mb
=> blockreassurance	0.007 ms	- Mb
ActionObjectAddBefore	0.004 ms	- Mb
=> ets_seo	0.004 ms	- Mb
43 hook(s)	216.260 ms	10.76 Mb

Module	Time	Memory Usage
tvcmsblog	3.795 ms	0.02 Mb
__construct	3.495 ms	0.01 Mb
hookModuleRoutes	0.033 ms	0.01 Mb
hookDisplayHeader	0.261 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.006 ms	- Mb
ets_abandonedcart	9.164 ms	0.10 Mb
__construct	1.029 ms	0.02 Mb
hookModuleRoutes	0.010 ms	0.01 Mb
hookActionDispatcherBefore	0.026 ms	- Mb
hookDisplayHeader	8.069 ms	0.08 Mb
hookDisplayFooter	0.030 ms	- Mb
psassistant	1.087 ms	0.02 Mb
__construct	1.068 ms	0.02 Mb
hookActionDispatcherBefore	0.009 ms	- Mb
hookActionDispatcher	0.010 ms	- Mb
ps_eventbus	1.613 ms	0.01 Mb
__construct	1.613 ms	0.01 Mb
ets_onepagecheckout	1.641 ms	0.07 Mb
__construct	1.596 ms	0.06 Mb
hookActionDispatcherBefore	0.006 ms	- Mb
hookDisplayHeader	0.039 ms	- Mb
ets_productmanager	1.047 ms	0.03 Mb
__construct	1.042 ms	0.03 Mb
hookActionDispatcherBefore	0.005 ms	- Mb
ets_seo	3.114 ms	0.09 Mb
__construct	1.482 ms	- Mb
hookActionDispatcherBefore	0.005 ms	- Mb
hookDisplayHeader	1.553 ms	0.03 Mb
hookDisplayOverrideTemplate	0.002 ms	- Mb
hookActionObjectAddBefore	0.007 ms	- Mb
hookActionObjectAddAfter	0.065 ms	0.06 Mb
creativeelements	16.050 ms	0.46 Mb
__construct	1.354 ms	0.11 Mb
hookActionFrontControllerInitAfter	0.030 ms	- Mb
hookOverrideLayoutTemplate	0.010 ms	- Mb
hookDisplayHeader	2.894 ms	0.25 Mb
hookOverrideLayoutTemplate	0.010 ms	- Mb
hookFilterProductSearch	2.015 ms	0.01 Mb
hookDisplayOverrideTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	9.720 ms	0.08 Mb
hookOverrideLayoutTemplate	0.011 ms	- Mb
blockreassurance	0.227 ms	0.02 Mb
__construct	0.104 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.107 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.008 ms	- Mb
hookDisplayNavFullWidth	0.008 ms	- Mb
ps_emailsubscription	1.012 ms	0.07 Mb
__construct	0.059 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.047 ms	- Mb
displayNewslettersubscription	0.906 ms	0.06 Mb
ps_socialfollow	1.222 ms	0.11 Mb
__construct	0.046 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.029 ms	- Mb
displaySocialMediaBlock	1.147 ms	0.10 Mb
ps_emailalerts	0.133 ms	0.01 Mb
__construct	0.102 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.031 ms	- Mb
ps_shoppingcart	7.998 ms	0.10 Mb
__construct	0.083 ms	0.01 Mb
hookDisplayHeader	0.423 ms	- Mb
displayNavShoppingCartBlock	7.492 ms	0.09 Mb
ps_searchbar	0.306 ms	0.01 Mb
__construct	0.072 ms	0.01 Mb
hookDisplayHeader	0.234 ms	- Mb
tvcmsadvanceblock	0.172 ms	0.08 Mb
__construct	0.123 ms	0.07 Mb
hookDisplayHeader	0.049 ms	- Mb
tvcmsbestsellerproducts	45.642 ms	2.47 Mb
__construct	0.067 ms	0.01 Mb
hookDisplayHeader	0.053 ms	- Mb
hookDisplayLeftColumn	45.522 ms	2.46 Mb
tvcmsblogdisplayposts	54.641 ms	3.64 Mb
__construct	0.197 ms	- Mb
hookDisplayHeader	0.060 ms	- Mb
hookDisplayLeftColumn	54.384 ms	3.65 Mb
tvcmsbrandlist	0.119 ms	0.01 Mb
__construct	0.080 ms	0.01 Mb
hookDisplayHeader	0.039 ms	- Mb
tvcmscategorychainslider	0.132 ms	0.01 Mb
__construct	0.072 ms	0.01 Mb
hookDisplayHeader	0.060 ms	- Mb
tvcmscategoryslider	0.135 ms	0.01 Mb
__construct	0.093 ms	0.01 Mb
hookDisplayHeader	0.042 ms	- Mb
tvcmscookiesnotice	0.373 ms	0.03 Mb
__construct	0.065 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.265 ms	0.02 Mb
tvcmscustomerservices	0.346 ms	0.03 Mb
__construct	0.062 ms	0.01 Mb
hookDisplayHeader	0.044 ms	- Mb
hookDisplayLeftColumn	0.240 ms	0.02 Mb
tvcmscustomsetting	1.828 ms	0.16 Mb
__construct	0.070 ms	0.01 Mb
hookDisplayHeader	0.329 ms	0.01 Mb
hookDisplayTopOfferText	0.017 ms	- Mb
hookDisplayTopOfferText	0.009 ms	- Mb
hookDisplayCustomsocialblock	1.202 ms	0.12 Mb
hookDisplayDownloadApps	0.016 ms	- Mb
hookDisplayCopyRightText	0.185 ms	0.01 Mb
tvcmsfeaturedproducts	0.227 ms	0.01 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayHeader	0.049 ms	- Mb
hookDisplayLeftColumn	0.105 ms	- Mb
tvcmsfooterlogo	0.088 ms	0.01 Mb
__construct	0.085 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
tvcmsfooterproduct	0.094 ms	0.01 Mb
__construct	0.060 ms	0.01 Mb
hookDisplayHeader	0.034 ms	- Mb
tvcmsmultibanner1	0.100 ms	0.01 Mb
__construct	0.062 ms	0.01 Mb
hookDisplayHeader	0.038 ms	- Mb
tvcmsnewproducts	0.233 ms	0.01 Mb
__construct	0.065 ms	0.01 Mb
hookDisplayHeader	0.052 ms	- Mb
hookDisplayLeftColumn	0.116 ms	- Mb
tvcmsnewsletterpopup	0.151 ms	0.01 Mb
__construct	0.071 ms	0.01 Mb
hookDisplayHeader	0.080 ms	- Mb
tvcmspaymenticon	0.944 ms	0.05 Mb
__construct	0.065 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayPaymentIcon	0.877 ms	0.05 Mb
tvcmssearch	2.382 ms	0.14 Mb
__construct	0.050 ms	0.01 Mb
hookDisplayHeader	0.087 ms	- Mb
hookDisplayNavSearchBlock	2.245 ms	0.13 Mb
tvcmssizechart	0.102 ms	0.01 Mb
__construct	0.064 ms	0.01 Mb
hookDisplayHeader	0.038 ms	- Mb
tvcmsslider	0.123 ms	0.01 Mb
__construct	0.083 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
tvcmsspecialproducts	2.138 ms	0.11 Mb
__construct	0.065 ms	0.01 Mb
hookDisplayHeader	0.037 ms	- Mb
hookDisplayLeftColumn	2.036 ms	0.10 Mb
tvcmsstockinfo	0.252 ms	0.02 Mb
__construct	0.060 ms	0.01 Mb
hookHeader	0.049 ms	- Mb
hookDisplayProductListStockIndicator	0.028 ms	- Mb
hookDisplayProductListStockIndicator	0.017 ms	- Mb
hookDisplayProductListStockIndicator	0.019 ms	- Mb
hookDisplayProductListStockIndicator	0.014 ms	- Mb
hookDisplayProductListStockIndicator	0.018 ms	- Mb
hookDisplayProductListStockIndicator	0.013 ms	- Mb
hookDisplayProductListStockIndicator	0.020 ms	- Mb
hookDisplayProductListStockIndicator	0.013 ms	- Mb
tvcmstabproducts	0.122 ms	0.01 Mb
__construct	0.057 ms	0.01 Mb
hookDisplayHeader	0.065 ms	- Mb
tvcmstestimonial	1.075 ms	0.04 Mb
__construct	0.162 ms	0.01 Mb
hookDisplayHeader	0.052 ms	- Mb
hookDisplayLeftColumn	0.861 ms	0.03 Mb
tvcmsthemeoptions	0.216 ms	0.02 Mb
__construct	0.093 ms	0.01 Mb
hookDisplayHeader	0.123 ms	- Mb
cdc_googletagmanager	15.730 ms	0.76 Mb
__construct	0.200 ms	0.02 Mb
hookDisplayHeader	0.044 ms	- Mb
hookDisplayAfterTitleTag	15.319 ms	0.70 Mb
hookDisplayProductPriceBlock	0.009 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.008 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.007 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.006 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
facebookproductad	9.818 ms	0.28 Mb
__construct	1.239 ms	0.09 Mb
hookDisplayHeader	8.579 ms	0.20 Mb
ets_promotion	3.854 ms	0.18 Mb
__construct	0.173 ms	0.01 Mb
hookDisplayHeader	3.677 ms	0.17 Mb
hookDisplayOverrideTemplate	0.004 ms	- Mb
productcomments	0.361 ms	0.01 Mb
__construct	0.272 ms	0.01 Mb
hookDisplayHeader	0.089 ms	- Mb
tvcmsinfinitescroll	0.518 ms	0.02 Mb
__construct	0.164 ms	0.01 Mb
hookHeader	0.354 ms	0.01 Mb
tvcmsofferbanner	0.249 ms	0.01 Mb
__construct	0.153 ms	0.01 Mb
hookHeader	0.096 ms	- Mb
tvcmscategoryproduct	0.256 ms	0.01 Mb
__construct	0.128 ms	0.01 Mb
hookHeader	0.128 ms	- Mb
tvcmsmegamenu	16.568 ms	0.58 Mb
__construct	0.359 ms	0.01 Mb
hookHeader	0.116 ms	- Mb
hookDisplayMegamenu	16.093 ms	0.58 Mb
ps_facetedsearch	0.808 ms	0.04 Mb
__construct	0.228 ms	0.01 Mb
hookProductSearchProvider	0.344 ms	- Mb
hookDisplayFacetedSearchBlock	0.236 ms	0.03 Mb
tvcmscustomcssjs	0.231 ms	0.01 Mb
__construct	0.206 ms	0.01 Mb
hookDisplayCustomCss	0.015 ms	- Mb
hookDisplayCustomJs	0.010 ms	- Mb
ps_contactinfo	2.213 ms	0.08 Mb
__construct	0.097 ms	0.01 Mb
displayNav1	1.426 ms	0.04 Mb
displayContactCinfo	0.690 ms	0.03 Mb
ps_languageselector	0.445 ms	0.07 Mb
__construct	0.080 ms	0.01 Mb
displayNavLanguageBlock	0.365 ms	0.06 Mb
ps_currencyselector	0.569 ms	0.09 Mb
__construct	0.075 ms	0.01 Mb
displayNavCurrencyBlock	0.494 ms	0.09 Mb
ps_customersignin	0.591 ms	0.07 Mb
__construct	0.063 ms	0.01 Mb
displayNavCustomerSignInBlock	0.528 ms	0.06 Mb
ps_categorytree	6.471 ms	0.15 Mb
__construct	0.079 ms	0.01 Mb
displayLeftColumn	6.392 ms	0.14 Mb
ps_brandlist	1.337 ms	0.08 Mb
__construct	0.097 ms	0.01 Mb
displayLeftColumn	1.240 ms	0.07 Mb
ps_supplierlist	1.156 ms	0.14 Mb
__construct	0.096 ms	0.07 Mb
displayLeftColumn	1.060 ms	0.07 Mb
tvcmsfootercategory	9.278 ms	0.74 Mb
__construct	0.173 ms	0.01 Mb
hookDisplayFooterCategory	9.105 ms	0.74 Mb
ps_linklist	1.327 ms	0.11 Mb
__construct	0.170 ms	0.01 Mb
displayFooterPart1	1.157 ms	0.10 Mb
ps_customeraccountlinks	1.265 ms	0.10 Mb
__construct	0.081 ms	0.01 Mb
displayMyaccountcblock	1.184 ms	0.10 Mb
statsdata	2.874 ms	0.12 Mb
__construct	0.102 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	2.772 ms	0.12 Mb
59 module(s)	235.962 ms	11.64 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
121	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' GROUP BY p.id_product) p INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<57 GROUP BY cp.id_category	12.054 ms	48039602	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
220	SELECT SQL_NO_CACHE * FROM `cf4_product_attribute` a LEFT JOIN `cf4_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 585) LIMIT 1	9.165 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:5912 (__construct) /classes/Product.php:5875 (computeUnitPriceRatio) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
148	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `cf4_hook_module` hm STRAIGHT_JOIN `cf4_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `cf4_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	8.653 ms	879			/classes/Hook.php:452 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /override/classes/Product.php:57 (priceCalculation) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5691 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
219	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 `cf4_attribute` a LEFT JOIN `cf4_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `cf4_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `cf4_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN cf4_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 `cf4_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `cf4_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 873 AND pac.`id_product_attribute` = 585 AND agl.`id_lang` = 1	6.841 ms	1			/classes/Product.php:7516 /classes/Product.php:5857 (getAttributesParams) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `cf4_module` m INNER JOIN cf4_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `cf4_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `cf4_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `cf4_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	6.577 ms	258	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:48 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
204	SELECT SQL_NO_CACHE * FROM `cf4_product` a LEFT JOIN `cf4_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `cf4_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 873) AND (b.`id_shop` = 1) LIMIT 1	6.518 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5660 (getProductLink) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
117	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, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND p.date_add>'2025-02-11 00:00:00'	6.326 ms	26			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
125	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) WHERE ((sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN cf4_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN cf4_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_group = 1 AND sa_1.id_shop = 0 ) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity>0)) GROUP BY pac.id_attribute	5.925 ms	164	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
64	SELECT SQL_NO_CACHE `id_module` FROM `cf4_module` WHERE `name` = "ps_legalcompliance" LIMIT 1	5.867 ms	0			/classes/module/Module.php:2659 /classes/module/Module.php:2131 (getModuleIdByName) /classes/controller/FrontController.php:1669 (isEnabled) /classes/controller/FrontController.php:1813 (getDisplayTaxesLabel) /controllers/front/listing/CategoryController.php:276 (getTemplateVarPage) /classes/controller/FrontController.php:562 (getTemplateVarPage) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
207	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 233, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `cf4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 233) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-11 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	5.556 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /override/classes/Product.php:57 (priceCalculation) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5691 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (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 `cf4_configuration` c LEFT JOIN `cf4_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	5.538 ms	2453			/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)
294	SELECT SQL_NO_CACHE `id_module` FROM `cf4_module_shop` WHERE `id_module` = 9 AND `id_shop` = 1 LIMIT 1	5.400 ms	1			/classes/module/Module.php:2132 /classes/Hook.php:1083 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/1a/20/a5/1a20a5631f2129930e1a01b221c87b785d86bf0d_2.file.desk-header-7.tpl.php:50 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55c10b95_50470653) /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/v1_ceramic_42layouts_layout_left_column_tpl/fe/c6/62/fec6620ce8dc17f642a22a2456a443808d306053_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bfb581_32958368) /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/v1_ceramic_42layouts_layout_left_column_tpl/5b/94/39/5b94398fe957f0b6e32b7ed8d0a4020ef7aba178_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/v1_ceramic_42layouts_layout_left_column_tpl/5b/94/39/5b94398fe957f0b6e32b7ed8d0a4020ef7aba178_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bf57a7_33095869) /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/v1_ceramic_42layouts_layout_left_column_tpl/4c/46/94/4c4694a0094f13bfdc743fddc3ea8d718f186f9b_2.file.header.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bcd679_01625808) /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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:145 (_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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
23	SELECT SQL_NO_CACHE * FROM cf4_meta m LEFT JOIN cf4_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "module-ets_seo-sitemap" OR m.page = "moduleets_seositemap" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1	5.049 ms	2			/classes/Meta.php:184 /modules/ets_seo/classes/dispatcher/EtsSeoDispatcher.php:783 (getMetaByPage) /modules/ets_seo/classes/dispatcher/EtsSeoDispatcher.php:754 (mergeSitemapRoute) /override/classes/Dispatcher.php:49 (mergeRssRoute) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
65	SELECT SQL_NO_CACHE `id_module` FROM `cf4_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1	3.995 ms	0			/classes/module/Module.php:2132 /classes/controller/FrontController.php:1669 (isEnabled) /classes/controller/FrontController.php:1813 (getDisplayTaxesLabel) /controllers/front/listing/CategoryController.php:276 (getTemplateVarPage) /classes/controller/FrontController.php:562 (getTemplateVarPage) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
215	SELECT SQL_NO_CACHE SUM(quantity) FROM `cf4_stock_available` WHERE (id_product = 873) AND (id_product_attribute = 585) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1	3.868 ms	1			/classes/stock/StockAvailable.php:453 /classes/Product.php:4349 (getQuantityAvailableByProduct) /classes/Product.php:5809 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
298	SELECT SQL_NO_CACHE c., cl. FROM `cf4_category` c INNER JOIN cf4_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `cf4_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `cf4_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `cf4_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 2 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	3.797 ms	29	Yes	Yes	/classes/Category.php:785 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:193 (__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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
41	SELECT SQL_NO_CACHE * FROM `cf4_currency` a LEFT JOIN `cf4_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `cf4_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1	3.763 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Currency.php:246 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cf4_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `cf4_hook_alias` ha INNER JOIN `cf4_hook` h ON ha.name = h.name	3.598 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /override/classes/Product.php:57 (priceCalculation) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5691 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
290	SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `cf4_smarty_lazy_cache` WHERE `template_hash`='f17cbc7b703e45236bac963ff24705ac' AND cache_id="tvcmsmegamenu\|1\|1\|1\|233" AND compile_id="v1_ceramic_42" LIMIT 1	3.335 ms	1			/classes/Smarty/SmartyCustom.php:216 /classes/Smarty/SmartyCustom.php:154 (is_in_lazy_cache) /classes/Smarty/SmartyCustom.php:122 (check_template_invalidation) /classes/module/Module.php:2285 (createTemplate) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1369 (fetch) /classes/Hook.php:1077 (hookdisplayMegamenu) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/1a/20/a5/1a20a5631f2129930e1a01b221c87b785d86bf0d_2.file.desk-header-7.tpl.php:44 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55c10b95_50470653) /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/v1_ceramic_42layouts_layout_left_column_tpl/fe/c6/62/fec6620ce8dc17f642a22a2456a443808d306053_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bfb581_32958368) /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/v1_ceramic_42layouts_layout_left_column_tpl/5b/94/39/5b94398fe957f0b6e32b7ed8d0a4020ef7aba178_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/v1_ceramic_42layouts_layout_left_column_tpl/5b/94/39/5b94398fe957f0b6e32b7ed8d0a4020ef7aba178_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bf57a7_33095869) /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/v1_ceramic_42layouts_layout_left_column_tpl/4c/46/94/4c4694a0094f13bfdc743fddc3ea8d718f186f9b_2.file.header.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bcd679_01625808) /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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:145 (_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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
123	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN cf4_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN cf4_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_group = 1 AND sa_1.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (119, 149, 166))) GROUP BY pac.id_attribute	3.310 ms	134017	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
206	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `cf4_specific_price_priority` WHERE `id_product` = 873 ORDER BY `id_specific_price_priority` DESC LIMIT 1	3.108 ms	1			/classes/SpecificPrice.php:256 /classes/SpecificPrice.php:239 (getPriority) /classes/SpecificPrice.php:565 (_getScoreQuery) /classes/Product.php:3826 (getSpecificPrice) /override/classes/Product.php:57 (priceCalculation) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5691 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	SELECT SQL_NO_CACHE name, alias FROM `cf4_hook_alias`	3.100 ms	88			/classes/Hook.php:339 /classes/Hook.php:154 (getCanonicalHookNames) /classes/Hook.php:363 (normalizeHookName) /classes/Hook.php:386 (getAllKnownNames) /classes/Hook.php:974 (isHookCallableOn) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:48 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
256	SELECT SQL_NO_CACHE pac.`id_product_attribute`, al.`name` AS attribute_name FROM `cf4_product_attribute_combination` pac LEFT JOIN `cf4_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `cf4_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `cf4_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) WHERE pac.`id_product_attribute` = 593	2.961 ms	1			/modules/cdc_googletagmanager/services/PrestashopUtils.php:72 /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:98 (getAttributeSmall) /modules/cdc_googletagmanager/classes/DataLayer.php:67 (__construct) /modules/cdc_googletagmanager/classes/DataLayer.php:145 (addItem) /modules/cdc_googletagmanager/classes/DataLayer.php:166 (addProductList) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1559 (addCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:1056 (displayCategory) /modules/cdc_googletagmanager/cdc_googletagmanager.php:645 (generateEnhancedEcommerce) /classes/Hook.php:1077 (hookDisplayAfterTitleTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/a6/1b/d0/a61bd0095cdacbd691d375935b1aac84ef79527f_2.file.head.tpl.php:116 (__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/v1_ceramic_42layouts_layout_left_column_tpl/a6/1b/d0/a61bd0095cdacbd691d375935b1aac84ef79527f_2.file.head.tpl.php:219 (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/v1_ceramic_42layouts_layout_left_column_tpl/a6/1b/d0/a61bd0095cdacbd691d375935b1aac84ef79527f_2.file.head.tpl.php:32 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb550d58f7_16501998) /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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
128	REPLACE INTO cf4_layered_filter_block (hash, data) VALUES ("d7864df90624b96c9e3a90abc9d2c283", "a:1:{s:7:\"filters\";a:6:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:18:\"Наличност\";s:6:\"values\";a:2:{i:2;a:3:{s:4:\"name\";s:21:\"В наличност\";s:3:\"nbr\";i:4;s:7:\"checked\";b:1;}i:0;a:2:{s:4:\"name\";s:27:\"Няма наличност\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Избрани\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:15:\"На склад\";s:3:\"nbr\";i:0;}s:3:\"new\";a:3:{s:4:\"name\";s:21:\"Нов продукт\";s:3:\"nbr\";i:4;s:7:\"checked\";b:1;}s:8:\"discount\";a:2:{s:4:\"name\";s:14:\"Намален\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Цена\";s:3:\"max\";d:27;s:3:\"min\";d:20;s:4:\"unit\";s:5:\"лв.\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"BGN\";s:14:\"currencySymbol\";s:5:\"лв.\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:8:\"0.00 ¤\";s:15:\"negativePattern\";s:9:\"-0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:0;s:16:\"primaryGroupSize\";i:1;s:18:\"secondaryGroupSize\";i:1;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:4;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:18:\"Категории\";s:6:\"values\";a:1:{i:51;a:3:{s:4:\"name\";s:13:\"За деца\";s:3:\"nbr\";s:1:\"4\";s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";s:1:\"2\";s:4:\"name\";s:8:\"Цвят\";s:14:\"is_color_group\";b:1;s:6:\"values\";a:12:{i:58;a:5:{s:4:\"name\";s:16:\"Сребърен\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#C0C0C0\";}i:104;a:5:{s:4:\"name\";s:12:\"Розово\";s:3:\"nbr\";s:2:\"10\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ff59f1\";}i:105;a:5:{s:4:\"name\";s:12:\"Лилаво\";s:3:\"nbr\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ae51ff\";}i:106;a:5:{s:4:\"name\";s:12:\"Зелено\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#148100\";}i:111;a:5:{s:4:\"name\";s:6:\"Бял\";s:3:\"nbr\";s:1:\"8\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffffff\";}i:119;a:6:{s:4:\"name\";s:10:\"Черен\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#000000\";s:7:\"checked\";b:1;}i:128;a:5:{s:4:\"name\";s:6:\"Син\";s:3:\"nbr\";s:1:\"4\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#0010f8\";}i:149;a:6:{s:4:\"name\";s:14:\"Червено\";s:3:\"nbr\";s:1:\"3\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#e11c00\";s:7:\"checked\";b:1;}i:154;a:5:{s:4:\"name\";s:16:\"Праскова\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffcfb1\";}i:155;a:5:{s:4:\"name\";s:23:\"Морско синьо\";s:3:\"nbr\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#65a9ff\";}i:166;a:6:{s:4:\"name\";s:14:\"Оранжев\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#fc9e00\";s:7:\"checked\";b:1;}i:167;a:5:{s:4:\"name\";s:12:\"Шарено\";s:3:\"nbr\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ff216e\";}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"3\";s:6:\"values\";a:1:{i:11;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:16:\"Сребро 925\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:16:\"Материал\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	2.812 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:209 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
373	SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb FROM `cf4_product_sale` ps LEFT JOIN `cf4_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN cf4_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE product_shop.`active` = 1 LIMIT 1	2.783 ms	513			/classes/ProductSale.php:60 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:79 (getNbSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2878 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:193 (__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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
42	SELECT SQL_NO_CACHE `id_lang` FROM `cf4_lang` WHERE `locale` = 'bg-bg' OR `language_code` = 'bg-bg' LIMIT 1	2.768 ms	1			/classes/Language.php:880 /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:115 (getIdByLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
304	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-04-11 00:00:00", INTERVAL 60 DAY)) > 0 AS new FROM `cf4_product_sale` ps LEFT JOIN `cf4_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN cf4_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `cf4_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 `cf4_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `cf4_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 `cf4_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `cf4_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `cf4_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 233 AND tr.`id_state` = 0 LEFT JOIN `cf4_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN cf4_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `cf4_category_product` cp JOIN `cf4_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	2.733 ms	841			/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:69 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2878 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:193 (__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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
283	SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `cf4_category` c LEFT JOIN `cf4_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN cf4_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 46 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	2.677 ms	2	Yes	Yes	/classes/Category.php:1151 /modules/tvcmsmegamenu/tvcmsmegamenu.php:1782 (getChildren) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1396 (getRespCategories) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1362 (getWidgetVariables) /classes/Hook.php:1077 (hookdisplayMegamenu) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/1a/20/a5/1a20a5631f2129930e1a01b221c87b785d86bf0d_2.file.desk-header-7.tpl.php:44 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55c10b95_50470653) /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/v1_ceramic_42layouts_layout_left_column_tpl/fe/c6/62/fec6620ce8dc17f642a22a2456a443808d306053_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bfb581_32958368) /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/v1_ceramic_42layouts_layout_left_column_tpl/5b/94/39/5b94398fe957f0b6e32b7ed8d0a4020ef7aba178_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/v1_ceramic_42layouts_layout_left_column_tpl/5b/94/39/5b94398fe957f0b6e32b7ed8d0a4020ef7aba178_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bf57a7_33095869) /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/v1_ceramic_42layouts_layout_left_column_tpl/4c/46/94/4c4694a0094f13bfdc743fddc3ea8d718f186f9b_2.file.header.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb55bcd679_01625808) /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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:145 (_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/v1_ceramic_42layouts_layout_left_column_tpl/3e/51/6e/3e516e133bf8bf9b05247ccc4d334392b49b49a5_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54e1d7f0_17407020) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/24/34/a2/2434a28cfb015d97daf95bf02b81a903d785e440_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d9c0a2_96484232) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/38/70/e4/3870e4f3fc939e2a9592d77062be7b5f39e0e918_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54d4c569_73028199) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/0a/c7/3e/0ac73eaa68a3b4e45d25f065d9bb71095b6d1b7b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c62ce3_82391433) /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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/v1_ceramic_42layouts_layout_left_column_tpl/ba/b0/91/bab09116eab8435e8087a3960fb7a0e78283b544_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67f8cb54c09ca6_26164786) /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)
40	SELECT SQL_NO_CACHE c.id_currency FROM `cf4_currency` c WHERE (iso_code = 'BGN') LIMIT 1	2.584 ms	1			/classes/Currency.php:893 /src/Adapter/Currency/CurrencyDataProvider.php:92 (getIdByIsoCode) /src/Adapter/Currency/CurrencyDataProvider.php:114 (getCurrencyByIsoCode) /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php:102 (getCurrencyByIsoCodeAndLocale) /src/Core/Data/Layer/AbstractDataLayer.php:91 (doRead) /src/Core/Data/Layer/AbstractDataLayer.php:150 (read) /src/Core/Data/Layer/AbstractDataLayer.php:95 (propagateRead) /src/Core/Localization/Currency/CurrencyDataSource.php:67 (read) /src/Core/Localization/Currency/CurrencyDataSource.php:109 (getLocalizedCurrencyData) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (formatCurrenciesData) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
24	SELECT SQL_NO_CACHE * FROM cf4_meta m LEFT JOIN cf4_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "module-ets_seo-rss" OR m.page = "moduleets_seorss" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1	2.534 ms	2			/classes/Meta.php:184 /modules/ets_seo/classes/dispatcher/EtsSeoDispatcher.php:760 (getMetaByPage) /override/classes/Dispatcher.php:49 (mergeRssRoute) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
126	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p INNER JOIN cf4_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa_1.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=3)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (119, 149, 166))) GROUP BY fp.id_feature_value	2.521 ms	2197	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
118	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, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_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, 233) AND sp.id_group IN (0, 1) 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-04-11 10:58:11' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-11 10:58:11' <= sp.to) ) LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa_1.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity>0)) AND ((pac_2.id_attribute IN (119, 149, 166)))	2.450 ms	4			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE `name`, `alias` FROM `cf4_hook_alias`	2.375 ms	88			/classes/Hook.php:287 /classes/Hook.php:318 (getAllHookAliases) /classes/Hook.php:746 (getHookAliasesFor) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:48 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
228	SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `cf4_product_attribute_image` pai LEFT JOIN `cf4_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `cf4_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (596, 597, 598, 599, 600) AND il.`id_lang` = 1 ORDER by i.`position`	2.340 ms	5	Yes		/classes/Product.php:2915 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /classes/controller/ProductListingFrontController.php:116 (present) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
226	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `cf4_image` i INNER JOIN cf4_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `cf4_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 877 ORDER BY `position`	2.282 ms	5	Yes		/classes/Product.php:3539 /override/classes/Product.php:143 (getImages) /override/classes/Product.php:114 (coreGetImages) /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /classes/controller/ProductListingFrontController.php:116 (present) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 1) DESC, p.date_add DESC, p.id_product DESC	2.268 ms	169	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:186 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
115	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, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166)))	2.127 ms	2197			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
113	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, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_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_group = 1 AND sa_1.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (119, 149, 166)))	2.107 ms	2197			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	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, pa.id_product_attribute FROM cf4_product p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cf4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cf4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cf4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cf4_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (119, 149, 166))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.date_add>'2025-02-11 00:00:00' AND cp.id_category='51' GROUP BY p.id_product) p LEFT JOIN cf4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cf4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cf4_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_group = 1 AND sa.id_shop = 0 ) LEFT JOIN cf4_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (119, 149, 166)))	2.070 ms	2197			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
38	SELECT SQL_NO_CACHE * FROM `cf4_currency` c ORDER BY `iso_code` ASC	1.970 ms	1	Yes		/classes/Currency.php:708 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:208 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:41 (init) /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

Кошница с артикули

Мойсанит – диамантен блясък от Космоса до бижутата

Защо камъните на бижутата изпадат и как да го предотвратим?

Защо среброто потъмнява? Как да почистим сребърните бижута?

Обеци Розов блян

Обеци Розов блян

Обеци Розов блян

Обеци Розов блян

Обеци Шарена висота

Обеци Шарена висота

Обеци Шарена висота

Обеци Шарена висота

Обеци Цветно чувство

Обеци Цветно чувство

Обеци Цветно чувство

Обеци Цветно чувство

Обеци Цветна плетка

Обеци Цветна плетка

Обеци Цветна плетка

Обеци Цветна плетка

Stopwatch SQL - 634 queries

Doubles

Tables stress

ObjectModel instances

Included Files