Accueil

Silencieux & accessoires

PLATINE DE BRIDE D'ÉCHAPPEMENT STAGE6 R/T 95

(La revue0)

11,00 €

Silencieux & accessoires

BRIDE D'ÉCHAPPEMENT STAGE6 R/T BIG BORE 95CC

(La revue0)

29,00 €35,00 €-6,00 € off

Pot d’échappement

POT D'ÉCHAPPEMENT STAGE6 R/T 95 MBK NITRO

(La revue0)

429,00 €476,00 €-47,00 € off

Pot d’échappement

Pot D'échappement 2FAST 100cc FLR 12" ( PIAGGIO )

(La revue0)

465,00 €

Atelier

Montage - Préparation -Optimisation

Au sein de notre atelier, nous préparons chaque véhicule pour des performances optimales, alliant expertise et passion afin de répondre aux exigences de la compétition.

Vente

Vente / Conseille

Nous proposons une sélection de pièces haut de gamme exclusivement dédiées à la compétition, testées et approuvées sur piste et dans nos ateliers pour garantir performance et qualité. Notre expertise est là pour vous conseiller au mieux.

Developpement

Développement de Pièces

Fort de plusieurs années d\\\'expérience en compétition, notre pôle développement conçoit sous notre propre marque des pièces innovantes et performantes. Nous réalisons également des pièces sur mesure pour répondre aux besoins spécifiques de chaque pilote.

Load Time	501.030 ms
Querying Time	314 ms
Queries	705
Memory Peak Usage	47.5 Mb
Included Files	1467 files - 13.88 Mb
PrestaShop Cache	- Mb
Global vars	0.74 Mb
- global $_MODULES	482k
- global $smarty	219k
- global $context	30k
- global $_SERVER	7k
- global $config	5k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $legacyContainer	1k

PrestaShop Version	8.1.7
PHP Version	8.0.30
MySQL Version	11.8.6-MariaDB-log
Memory Limit	1536M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	3.318 ms	3.318 ms	12.05 Mb	13.6 Mb
__construct	0.011 ms	3.329 ms	- Mb	13.6 Mb
init	44.064 ms	47.393 ms	5.00 Mb	17.5 Mb
checkAccess	0.001 ms	47.394 ms	- Mb	17.5 Mb
setMedia	20.250 ms	67.644 ms	2.05 Mb	19.2 Mb
postProcess	0.002 ms	67.646 ms	- Mb	19.2 Mb
initHeader	0.000 ms	67.646 ms	- Mb	19.2 Mb
initContent	165.398 ms	233.044 ms	9.11 Mb	28.4 Mb
initFooter	0.002 ms	233.046 ms	- Mb	28.4 Mb
display	267.984 ms	501.030 ms	18.11 Mb	47.5 Mb

80 queries	SELECT * FROM `sXXeXX_category` a LEFT JOIN `sXXeXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `sXXeXX_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
52 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `sXXeXX_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
52 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `sXXeXX_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
21 queries	SELECT SUM(quantity) FROM `sXXeXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
21 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 `sXXeXX_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 `sXXeXX_cart_product` cp JOIN `sXXeXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `sXXeXX_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
21 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `sXXeXX_image` i INNER JOIN sXXeXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `sXXeXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
21 queries	SELECT `id_product_attribute` FROM `sXXeXX_product_attribute` WHERE `id_product` = XX
18 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `sXXeXX_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` IN (XX, 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
17 queries	SELECT `id_module` FROM `sXXeXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
17 queries	SELECT image_shop.`id_image` FROM `sXXeXX_image` i INNER JOIN sXXeXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
17 queries	SELECT name FROM sXXeXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
17 queries	SELECT * FROM `sXXeXX_product` a LEFT JOIN `sXXeXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `sXXeXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
17 queries	SELECT `priority`, `id_specific_price_priority` FROM `sXXeXX_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
17 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `sXXeXX_product` p INNER JOIN `sXXeXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `sXXeXX_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
17 queries	SELECT `id_tax_rules_group` FROM `sXXeXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
17 queries	SELECT `reduction` FROM `sXXeXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
17 queries	SELECT COUNT(*) FROM `sXXeXX_pack` WHERE id_product_pack = XX LIMIT XX
17 queries	SELECT product_type FROM `sXXeXX_product` WHERE id_product = XX LIMIT XX
17 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM sXXeXX_feature_product pf LEFT JOIN sXXeXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN sXXeXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN sXXeXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN sXXeXX_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
16 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `sXXeXX_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX
12 queries	SELECT mr.* FROM sXXeXX_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `sXXeXX_product_attribute` pa INNER JOIN sXXeXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `sXXeXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `sXXeXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `sXXeXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `sXXeXX_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
9 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 sXXeXX_product p LEFT JOIN sXXeXX_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN sXXeXX_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN sXXeXX_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
7 queries	SELECT cl.`link_rewrite` FROM `sXXeXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
6 queries	SELECT `id_lang` FROM `sXXeXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
5 queries	SELECT quantity, reserved_quantity FROM `sXXeXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `sXXeXX_module` m LEFT JOIN `sXXeXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
4 queries	SELECT `need_identification_number` FROM `sXXeXX_country` WHERE `id_country` = XX LIMIT XX
4 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `sXXeXX_attribute_group` ag INNER JOIN `sXXeXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `sXXeXX_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `sXXeXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN sXXeXX_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 sXXeXX_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `sXXeXX_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM sXXeXX_product p LEFT JOIN sXXeXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sXXeXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sXXeXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN sXXeXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sXXeXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sXXeXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN sXXeXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN sXXeXX_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN sXXeXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sXXeXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN sXXeXX_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
4 queries	SELECT product_attribute_shop.`price` FROM `sXXeXX_product_attribute` pa INNER JOIN sXXeXX_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
4 queries	SELECT pa.`available_date` FROM `sXXeXX_product` p LEFT JOIN `sXXeXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN sXXeXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN sXXeXX_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
4 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `sXXeXX_attribute` a LEFT JOIN `sXXeXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `sXXeXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `sXXeXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN sXXeXX_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 `sXXeXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `sXXeXX_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
4 queries	SELECT * FROM `sXXeXX_product_attribute` a LEFT JOIN `sXXeXX_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
4 queries	SELECT * FROM `sXXeXX_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT * FROM `sXXeXX_currency` a LEFT JOIN `sXXeXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `sXXeXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
3 queries	SELECT `name` FROM `sXXeXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 queries	SELECT tr.* FROM `sXXeXX_tax_rule` tr JOIN `sXXeXX_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `id_category` FROM `sXXeXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT XX FROM `sXXeXX_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT * FROM `sXXeXX_shop_url` aXX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `sXXeXX_manufacturer` m INNER JOIN sXXeXX_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `sXXeXX_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT 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, cp.position FROM sXXeXX_product p LEFT JOIN sXXeXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN sXXeXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN sXXeXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN sXXeXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN sXXeXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN sXXeXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN sXXeXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN sXXeXX_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN sXXeXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `sXXeXX_product_attribute_image` pai LEFT JOIN `sXXeXX_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `sXXeXX_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`
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `sXXeXX_product_attribute_image` pai LEFT JOIN `sXXeXX_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `sXXeXX_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 p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute FROM `sXXeXX_product` p INNER JOIN sXXeXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `sXXeXX_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `sXXeXX_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 `sXXeXX_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `sXXeXX_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `sXXeXX_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 sXXeXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE (product_shop.`active` = XX) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) AND (EXISTS(SELECT XX FROM `sXXeXX_category_product` cp JOIN `sXXeXX_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT XX

Name	Instances	Source
Customer	141	/config/config.inc.php:264 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ] /override/classes/tax/TaxCalculator.php:36 (__construct) [id: ]
Category	93	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 30] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 3] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 31] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 40] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 44] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 51] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 61] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 71] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 78] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 26] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 93] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 94] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 96] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 97] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 98] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 100] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 101] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 102] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 103] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 104] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 105] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 106] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 107] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 108] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 110] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 111] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 114] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 115] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 116] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 117] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 118] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 119] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 120] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 121] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 123] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 124] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 125] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 126] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 128] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 178] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 204] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 261] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 268] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 283] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 284] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 285] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 294] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 363] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 429] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 430] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 431] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 432] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 433] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 434] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 435] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 436] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 437] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 438] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 439] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 440] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 442] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 443] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 444] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 445] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 446] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 447] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 448] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 449] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 450] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 451] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 452] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 453] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 455] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 457] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 458] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 459] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 476] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 478] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 483] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 2] /classes/Link.php:402 (__construct) [id: 294] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 294] /classes/Link.php:402 (__construct) [id: 476] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 476] /classes/Link.php:402 (__construct) [id: 478] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1699 (__construct) [id: 478] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Product	54	/classes/Link.php:113 (__construct) [id: 17026] /classes/Link.php:113 (__construct) [id: 17027] /classes/Link.php:113 (__construct) [id: 16801] /classes/Link.php:113 (__construct) [id: 13040] /classes/Link.php:113 (__construct) [id: 13132] /classes/Link.php:113 (__construct) [id: 16277] /classes/Link.php:113 (__construct) [id: 16278] /classes/Link.php:113 (__construct) [id: 16279] /classes/Link.php:113 (__construct) [id: 16295] /classes/Link.php:113 (__construct) [id: 16296] /classes/Link.php:113 (__construct) [id: 16297] /classes/Link.php:113 (__construct) [id: 16298] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17026] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17027] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16801] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 13040] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 13132] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16277] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16278] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16279] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16295] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16296] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16297] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16298] /classes/Link.php:113 (__construct) [id: 17026] /classes/Link.php:113 (__construct) [id: 17027] /classes/Link.php:113 (__construct) [id: 16801] /classes/Link.php:113 (__construct) [id: 13040] /classes/Link.php:113 (__construct) [id: 13132] /classes/Link.php:113 (__construct) [id: 16277] /classes/Link.php:113 (__construct) [id: 16278] /classes/Link.php:113 (__construct) [id: 16279] /classes/Link.php:113 (__construct) [id: 16295] /classes/Link.php:113 (__construct) [id: 16296] /classes/Link.php:113 (__construct) [id: 16297] /classes/Link.php:113 (__construct) [id: 16298] /classes/Link.php:113 (__construct) [id: 17247] /classes/Link.php:113 (__construct) [id: 17246] /classes/Link.php:113 (__construct) [id: 17245] /classes/Link.php:113 (__construct) [id: 17244] /classes/Link.php:113 (__construct) [id: 17243] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17247] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17246] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17245] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17244] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17243] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17247] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17246] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17245] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 17244] /classes/Link.php:113 (__construct) [id: 17247] /classes/Link.php:113 (__construct) [id: 17246] /classes/Link.php:113 (__construct) [id: 17245] /classes/Link.php:113 (__construct) [id: 17244]
Country	9	/config/config.inc.php:146 (__construct) [id: 3] /classes/AddressFormat.php:404 (__construct) [id: 3] /classes/controller/FrontController.php:1767 (__construct) [id: 3] /classes/AddressFormat.php:404 (__construct) [id: 3] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 3] /classes/AddressFormat.php:404 (__construct) [id: 3] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 3] /classes/AddressFormat.php:404 (__construct) [id: 3] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 3]
MolCustomer	6	:0 (__construct) [id: ] :0 (__construct) [id: ] :0 (__construct) [id: ] :0 (__construct) [id: ] :0 (__construct) [id: ] :0 (__construct) [id: ]
ShopUrl	4	/classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 2]
Combination	4	/classes/Product.php:5908 (__construct) [id: 148] /classes/Product.php:5908 (__construct) [id: 153] /classes/Product.php:5908 (__construct) [id: 159] /classes/Product.php:5908 (__construct) [id: 164]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5960 (__construct) [id: ]
AddressFormat	4	/classes/controller/FrontController.php:1761 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
State	4	/classes/controller/FrontController.php:1766 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Language	2	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:560 (__construct) [id: 2]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 53]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
MolPaymentMethod	1	/classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Hook	Time	Memory Usage
DisplayAfterBodyOpeningTag	80.498 ms	2.71 Mb
=> tvcmscookiesnotice	0.021 ms	- Mb
=> blockreassurance	0.003 ms	- Mb
=> tvcmsproductpopup	80.474 ms	2.71 Mb
DisplayLeftColumn	68.878 ms	2.16 Mb
=> tvcmsnewproducts	67.528 ms	2.08 Mb
=> tvcmscustomerservices	0.029 ms	0.01 Mb
=> tvcmsspecialproducts	0.042 ms	- Mb
=> tvcmsfeaturedproducts	0.026 ms	- Mb
=> tvcmsbestsellerproducts	0.023 ms	- Mb
=> tvcmstestimonial	1.230 ms	0.07 Mb
DisplayReviewProductList	37.396 ms	5.37 Mb
=> tvcmsproductcomments	0.959 ms	0.20 Mb
=> tvcmsproductcomments	0.874 ms	0.12 Mb
=> tvcmsproductcomments	0.823 ms	0.12 Mb
=> tvcmsproductcomments	0.798 ms	0.12 Mb
=> tvcmsproductcomments	0.814 ms	0.13 Mb
=> tvcmsproductcomments	0.693 ms	0.09 Mb
=> tvcmsproductcomments	0.668 ms	0.09 Mb
=> tvcmsproductcomments	0.658 ms	0.09 Mb
=> tvcmsproductcomments	0.811 ms	0.12 Mb
=> tvcmsproductcomments	0.635 ms	0.09 Mb
=> tvcmsproductcomments	0.632 ms	0.09 Mb
=> tvcmsproductcomments	0.638 ms	0.09 Mb
=> tvcmsproductcomments	0.806 ms	0.12 Mb
=> tvcmsproductcomments	0.661 ms	0.09 Mb
=> tvcmsproductcomments	0.618 ms	0.09 Mb
=> tvcmsproductcomments	0.644 ms	0.09 Mb
=> tvcmsproductcomments	0.833 ms	0.12 Mb
=> tvcmsproductcomments	0.653 ms	0.09 Mb
=> tvcmsproductcomments	0.674 ms	0.09 Mb
=> tvcmsproductcomments	0.660 ms	0.09 Mb
=> tvcmsproductcomments	0.809 ms	0.12 Mb
=> tvcmsproductcomments	0.855 ms	0.09 Mb
=> tvcmsproductcomments	0.708 ms	0.09 Mb
=> tvcmsproductcomments	0.666 ms	0.09 Mb
=> tvcmsproductcomments	0.930 ms	0.12 Mb
=> tvcmsproductcomments	0.668 ms	0.09 Mb
=> tvcmsproductcomments	0.627 ms	0.09 Mb
=> tvcmsproductcomments	0.776 ms	0.09 Mb
=> tvcmsproductcomments	0.818 ms	0.12 Mb
=> tvcmsproductcomments	0.681 ms	0.09 Mb
=> tvcmsproductcomments	0.636 ms	0.09 Mb
=> tvcmsproductcomments	0.678 ms	0.09 Mb
=> tvcmsproductcomments	0.786 ms	0.12 Mb
=> tvcmsproductcomments	0.658 ms	0.09 Mb
=> tvcmsproductcomments	0.641 ms	0.09 Mb
=> tvcmsproductcomments	0.660 ms	0.09 Mb
=> tvcmsproductcomments	0.797 ms	0.12 Mb
=> tvcmsproductcomments	0.659 ms	0.09 Mb
=> tvcmsproductcomments	0.648 ms	0.09 Mb
=> tvcmsproductcomments	0.657 ms	0.09 Mb
=> tvcmsproductcomments	0.899 ms	0.12 Mb
=> tvcmsproductcomments	0.643 ms	0.09 Mb
=> tvcmsproductcomments	0.621 ms	0.09 Mb
=> tvcmsproductcomments	0.641 ms	0.09 Mb
=> tvcmsproductcomments	0.851 ms	0.12 Mb
=> tvcmsproductcomments	0.639 ms	0.09 Mb
=> tvcmsproductcomments	0.628 ms	0.09 Mb
=> tvcmsproductcomments	0.705 ms	0.09 Mb
=> tvcmsproductcomments	0.894 ms	0.12 Mb
=> tvcmsproductcomments	0.671 ms	0.09 Mb
=> tvcmsproductcomments	0.641 ms	0.09 Mb
=> tvcmsproductcomments	0.653 ms	0.09 Mb
ActionFrontControllerSetMedia	18.894 ms	1.67 Mb
=> blockreassurance	0.126 ms	- Mb
=> blockwishlist	0.131 ms	- Mb
=> ps_emailsubscription	0.038 ms	- Mb
=> ps_socialfollow	0.034 ms	- Mb
=> bpostshm	0.007 ms	- Mb
=> ps_checkout	7.059 ms	1.04 Mb
=> mondialrelay	0.006 ms	- Mb
=> clicktopay	1.018 ms	0.11 Mb
=> mollie	10.439 ms	0.52 Mb
=> ps_emailalerts	0.033 ms	- Mb
=> linkedsalesconditions	0.002 ms	- Mb
displayLeftColumn	11.595 ms	1.15 Mb
=> ps_categorytree (widget)	10.143 ms	1.04 Mb
=> ps_brandlist (widget)	0.748 ms	0.05 Mb
=> ps_supplierlist (widget)	0.704 ms	0.06 Mb
DisplayWishlistBtnProductList	11.438 ms	0.96 Mb
=> tvcmswishlist	0.290 ms	0.03 Mb
=> tvcmswishlist	0.247 ms	0.02 Mb
=> tvcmswishlist	0.238 ms	0.02 Mb
=> tvcmswishlist	0.240 ms	0.02 Mb
=> tvcmswishlist	0.238 ms	0.02 Mb
=> tvcmswishlist	0.251 ms	0.02 Mb
=> tvcmswishlist	0.238 ms	0.02 Mb
=> tvcmswishlist	0.234 ms	0.02 Mb
=> tvcmswishlist	0.229 ms	0.02 Mb
=> tvcmswishlist	0.235 ms	0.02 Mb
=> tvcmswishlist	0.235 ms	0.02 Mb
=> tvcmswishlist	0.246 ms	0.02 Mb
=> tvcmswishlist	0.228 ms	0.02 Mb
=> tvcmswishlist	0.232 ms	0.02 Mb
=> tvcmswishlist	0.239 ms	0.02 Mb
=> tvcmswishlist	0.230 ms	0.02 Mb
=> tvcmswishlist	0.226 ms	0.02 Mb
=> tvcmswishlist	0.236 ms	0.02 Mb
=> tvcmswishlist	0.236 ms	0.02 Mb
=> tvcmswishlist	0.253 ms	0.02 Mb
=> tvcmswishlist	0.230 ms	0.02 Mb
=> tvcmswishlist	0.250 ms	0.02 Mb
=> tvcmswishlist	0.280 ms	0.02 Mb
=> tvcmswishlist	0.237 ms	0.02 Mb
=> tvcmswishlist	0.230 ms	0.02 Mb
=> tvcmswishlist	0.230 ms	0.02 Mb
=> tvcmswishlist	0.233 ms	0.02 Mb
=> tvcmswishlist	0.239 ms	0.02 Mb
=> tvcmswishlist	0.265 ms	0.02 Mb
=> tvcmswishlist	0.232 ms	0.02 Mb
=> tvcmswishlist	0.232 ms	0.02 Mb
=> tvcmswishlist	0.233 ms	0.02 Mb
=> tvcmswishlist	0.226 ms	0.02 Mb
=> tvcmswishlist	0.229 ms	0.02 Mb
=> tvcmswishlist	0.230 ms	0.02 Mb
=> tvcmswishlist	0.229 ms	0.02 Mb
=> tvcmswishlist	0.225 ms	0.02 Mb
=> tvcmswishlist	0.230 ms	0.02 Mb
=> tvcmswishlist	0.238 ms	0.02 Mb
=> tvcmswishlist	0.231 ms	0.02 Mb
=> tvcmswishlist	0.226 ms	0.02 Mb
=> tvcmswishlist	0.232 ms	0.02 Mb
=> tvcmswishlist	0.247 ms	0.02 Mb
=> tvcmswishlist	0.255 ms	0.02 Mb
=> tvcmswishlist	0.241 ms	0.02 Mb
=> tvcmswishlist	0.246 ms	0.02 Mb
=> tvcmswishlist	0.233 ms	0.02 Mb
=> tvcmswishlist	0.229 ms	0.02 Mb
DisplayProductCompareProductList	10.532 ms	0.69 Mb
=> tvcmsproductcompare	0.322 ms	0.02 Mb
=> tvcmsproductcompare	0.219 ms	0.01 Mb
=> tvcmsproductcompare	0.219 ms	0.01 Mb
=> tvcmsproductcompare	0.215 ms	0.01 Mb
=> tvcmsproductcompare	0.209 ms	0.01 Mb
=> tvcmsproductcompare	0.255 ms	0.01 Mb
=> tvcmsproductcompare	0.210 ms	0.01 Mb
=> tvcmsproductcompare	0.219 ms	0.01 Mb
=> tvcmsproductcompare	0.210 ms	0.01 Mb
=> tvcmsproductcompare	0.212 ms	0.01 Mb
=> tvcmsproductcompare	0.211 ms	0.01 Mb
=> tvcmsproductcompare	0.209 ms	0.01 Mb
=> tvcmsproductcompare	0.208 ms	0.01 Mb
=> tvcmsproductcompare	0.215 ms	0.01 Mb
=> tvcmsproductcompare	0.214 ms	0.01 Mb
=> tvcmsproductcompare	0.210 ms	0.01 Mb
=> tvcmsproductcompare	0.210 ms	0.01 Mb
=> tvcmsproductcompare	0.217 ms	0.01 Mb
=> tvcmsproductcompare	0.214 ms	0.01 Mb
=> tvcmsproductcompare	0.218 ms	0.01 Mb
=> tvcmsproductcompare	0.212 ms	0.01 Mb
=> tvcmsproductcompare	0.290 ms	0.01 Mb
=> tvcmsproductcompare	0.211 ms	0.01 Mb
=> tvcmsproductcompare	0.227 ms	0.01 Mb
=> tvcmsproductcompare	0.211 ms	0.01 Mb
=> tvcmsproductcompare	0.209 ms	0.01 Mb
=> tvcmsproductcompare	0.209 ms	0.01 Mb
=> tvcmsproductcompare	0.208 ms	0.01 Mb
=> tvcmsproductcompare	0.208 ms	0.01 Mb
=> tvcmsproductcompare	0.211 ms	0.01 Mb
=> tvcmsproductcompare	0.212 ms	0.01 Mb
=> tvcmsproductcompare	0.212 ms	0.01 Mb
=> tvcmsproductcompare	0.207 ms	0.01 Mb
=> tvcmsproductcompare	0.216 ms	0.01 Mb
=> tvcmsproductcompare	0.213 ms	0.01 Mb
=> tvcmsproductcompare	0.206 ms	0.01 Mb
=> tvcmsproductcompare	0.315 ms	0.01 Mb
=> tvcmsproductcompare	0.206 ms	0.01 Mb
=> tvcmsproductcompare	0.205 ms	0.01 Mb
=> tvcmsproductcompare	0.213 ms	0.01 Mb
=> tvcmsproductcompare	0.214 ms	0.01 Mb
=> tvcmsproductcompare	0.210 ms	0.01 Mb
=> tvcmsproductcompare	0.218 ms	0.01 Mb
=> tvcmsproductcompare	0.215 ms	0.01 Mb
=> tvcmsproductcompare	0.212 ms	0.01 Mb
=> tvcmsproductcompare	0.232 ms	0.08 Mb
=> tvcmsproductcompare	0.209 ms	0.01 Mb
=> tvcmsproductcompare	0.205 ms	0.01 Mb
DisplayHeader	3.689 ms	0.16 Mb
=> ps_shoppingcart	0.033 ms	- Mb
=> ps_searchbar	0.134 ms	- Mb
=> ps_imageslider	0.123 ms	- Mb
=> productcomments	0.071 ms	- Mb
=> ps_googleanalytics	0.058 ms	- Mb
=> tvcmsadvanceblock	0.063 ms	- Mb
=> tvcmsattrsearch	0.056 ms	- Mb
=> tvcmsthemeoptions	0.195 ms	- Mb
=> tvcmsbannerslider	0.056 ms	- Mb
=> tvcmstabproducts	0.090 ms	- Mb
=> tvcmssingleblock	0.061 ms	- Mb
=> tvcmsbestsellerproducts	0.042 ms	- Mb
=> tvcmsblog	0.117 ms	- Mb
=> tvcmsblogdisplayposts	0.068 ms	- Mb
=> tvcmsbrandlist	0.059 ms	- Mb
=> tvcmscategorychainslider	0.055 ms	- Mb
=> tvcmscategoryslider	0.057 ms	- Mb
=> tvcmscookiesnotice	0.064 ms	- Mb
=> tvcmscustomerinquiry	0.055 ms	- Mb
=> tvcmscustomerservices	0.057 ms	- Mb
=> tvcmscustomsetting	0.421 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.047 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.039 ms	- Mb
=> tvcmsmap	0.059 ms	- Mb
=> tvcmsnewproducts	0.040 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsproductcomments	0.279 ms	- Mb
=> tvcmsproductcompare	0.060 ms	- Mb
=> tvcmsproductpopup	0.052 ms	- Mb
=> tvcmssearch	0.119 ms	- Mb
=> tvcmssizechart	0.057 ms	- Mb
=> tvcmsspecialproducts	0.045 ms	- Mb
=> tvcmsstoretime	0.054 ms	- Mb
=> tvcmstestimonial	0.063 ms	- Mb
=> tvcmswishlist	0.083 ms	- Mb
=> clicktopay	0.052 ms	0.06 Mb
=> sendcloudv2	0.003 ms	- Mb
=> mollie	0.002 ms	- Mb
=> sendinblue	0.537 ms	0.02 Mb
=> sgpmachinerental	0.001 ms	- Mb
=> tvcmsslider	0.097 ms	- Mb
=> tvcmsmultibanner1	0.063 ms	- Mb
DisplayNavSearchBlock	3.616 ms	0.82 Mb
=> tvcmssearch	3.616 ms	0.82 Mb
DisplayMegamenu	2.661 ms	0.39 Mb
=> tvcmsmegamenu	2.661 ms	0.39 Mb
DisplayFooter	1.839 ms	0.13 Mb
=> blockwishlist	1.839 ms	0.13 Mb
displayContactCinfo	1.573 ms	0.16 Mb
=> ps_contactinfo (widget)	1.573 ms	0.16 Mb
displayNav1	1.475 ms	0.13 Mb
=> ps_contactinfo (widget)	0.916 ms	0.09 Mb
=> ps_contactinfo (widget)	0.559 ms	0.04 Mb
Header	1.381 ms	0.14 Mb
=> tvcmsstockinfo	0.063 ms	- Mb
=> tvcmsinfinitescroll	1.244 ms	0.14 Mb
=> tvcmsmegamenu	0.074 ms	- Mb
DisplayBeforeBodyClosingTag	1.107 ms	0.07 Mb
=> statsdata	1.105 ms	0.07 Mb
=> tvcmsblog	0.002 ms	- Mb
displayNavShoppingCartBlock	1.064 ms	0.14 Mb
=> ps_shoppingcart (widget)	1.064 ms	0.14 Mb
DisplayCustomsocialblock	0.985 ms	0.14 Mb
=> tvcmscustomsetting	0.985 ms	0.14 Mb
displayFooterPart1	0.844 ms	0.07 Mb
=> ps_linklist (widget)	0.844 ms	0.07 Mb
displaySocialMediaBlock	0.836 ms	0.10 Mb
=> ps_socialfollow (widget)	0.836 ms	0.10 Mb
displayMyaccountcblock	0.751 ms	0.07 Mb
=> ps_customeraccountlinks (widget)	0.751 ms	0.07 Mb
displayNavCustomerSignInBlock	0.693 ms	0.07 Mb
=> ps_customersignin (widget)	0.693 ms	0.07 Mb
DisplayNavWishlistBlock	0.613 ms	0.06 Mb
=> tvcmswishlist	0.613 ms	0.06 Mb
DisplayFooterPart2	0.473 ms	0.05 Mb
=> tvcmsfooterlogo	0.473 ms	0.05 Mb
displayNavCurrencyBlock	0.332 ms	0.05 Mb
=> ps_currencyselector (widget)	0.332 ms	0.05 Mb
displayNavLanguageBlock	0.309 ms	0.05 Mb
=> ps_languageselector (widget)	0.309 ms	0.05 Mb
DisplayPaymentIcon	0.306 ms	0.03 Mb
=> tvcmspaymenticon	0.306 ms	0.03 Mb
DisplayFacetedSearchBlock	0.303 ms	0.03 Mb
=> ps_facetedsearch	0.303 ms	0.03 Mb
DisplayNavProductCompareBlock	0.280 ms	0.01 Mb
=> tvcmsproductcompare	0.280 ms	0.01 Mb
ProductSearchProvider	0.254 ms	0.01 Mb
=> ps_facetedsearch	0.254 ms	0.01 Mb
DisplayShowMap	0.229 ms	0.03 Mb
=> tvcmsmap	0.229 ms	0.03 Mb
DisplayMapInformation	0.198 ms	0.02 Mb
=> tvcmsmap	0.198 ms	0.02 Mb
DisplayProductListStockIndicator	0.184 ms	0.01 Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.009 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.006 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.006 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.006 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
=> tvcmsstockinfo	0.006 ms	- Mb
=> tvcmsstockinfo	0.012 ms	- Mb
=> tvcmsstockinfo	0.007 ms	- Mb
ActionObjectAddAfter	0.142 ms	- Mb
=> sendcloudv2	0.142 ms	- Mb
DisplayProductPriceBlock	0.103 ms	0.05 Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.002 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.000 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
=> hellotvasmarge	0.001 ms	- Mb
DisplayCustomCss	0.028 ms	0.06 Mb
=> tvcmscustomcssjs	0.028 ms	0.06 Mb
DisplayHeaderStoreTime	0.025 ms	- Mb
=> tvcmsstoretime	0.025 ms	- Mb
ModuleRoutes	0.018 ms	0.01 Mb
=> tvcmsblog	0.016 ms	0.01 Mb
=> ps_checkout	0.002 ms	- Mb
DisplayTopOfferText	0.016 ms	0.02 Mb
=> tvcmscustomsetting	0.013 ms	0.02 Mb
=> tvcmscustomsetting	0.003 ms	- Mb
DisplayCustomJs	0.014 ms	0.02 Mb
=> tvcmscustomcssjs	0.014 ms	0.02 Mb
ActionFrontControllerInitBefore	0.012 ms	- Mb
=> bpostshm	0.012 ms	- Mb
ActionFrontControllerInitAfter	0.011 ms	- Mb
=> bpostshm	0.008 ms	- Mb
=> mollie	0.003 ms	- Mb
DisplayCopyRightText	0.006 ms	- Mb
=> tvcmscustomsetting	0.006 ms	- Mb
DisplayNavFullWidth	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
ActionDispatcher	0.002 ms	- Mb
=> sgpmachinerental	0.002 ms	- Mb
44 hook(s)	265.608 ms	17.82 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
416	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2026-06-24 00:00:00", INTERVAL 60 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `s3e4_product` p INNER JOIN s3e4_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `s3e4_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 LEFT JOIN `s3e4_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 `s3e4_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2 LEFT JOIN `s3e4_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `s3e4_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 s3e4_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2026-06-24 00:00:00", INTERVAL 60 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `s3e4_category_product` cp JOIN `s3e4_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 5	52.952 ms	15432	Yes		/classes/Product.php:3110 /modules/tvcmsproductpopup/tvcmsproductpopup.php:371 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:256 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:550 (prevHook) /classes/Hook.php:1077 (hookdisplayAfterBodyOpeningTag) /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:117 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030f0d32_38673273) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/94/77/e7/9477e706465ff705556887f418a9bfe581bdb4e5_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030d2763_09718991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/16/a4/26/16a426ff1f41256d5f858cd5cca43b827de37e78_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030a7fa7_22400913) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/43/40/3d/43403ddc66f64984f48b059b6bfad5ea584b3b8e_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af203095f58_63648641) /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/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
540	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2026-06-24 00:00:00", INTERVAL 60 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `s3e4_product` p INNER JOIN s3e4_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `s3e4_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 LEFT JOIN `s3e4_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 `s3e4_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2 LEFT JOIN `s3e4_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `s3e4_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 s3e4_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2026-06-24 00:00:00", INTERVAL 60 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `s3e4_category_product` cp JOIN `s3e4_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	52.012 ms	15432	Yes		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php: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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030f0d32_38673273) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/94/77/e7/9477e706465ff705556887f418a9bfe581bdb4e5_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030d2763_09718991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/16/a4/26/16a426ff1f41256d5f858cd5cca43b827de37e78_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030a7fa7_22400913) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/43/40/3d/43403ddc66f64984f48b059b6bfad5ea584b3b8e_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af203095f58_63648641) /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/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
168	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	43.905 ms	1484770672	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
536	SELECT SQL_NO_CACHE c., cl. FROM `s3e4_category` c INNER JOIN s3e4_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `s3e4_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `s3e4_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `s3e4_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 7 AND `id_lang` = 2 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	5.764 ms	432	Yes	Yes	/classes/Category.php:799 /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030f0d32_38673273) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/94/77/e7/9477e706465ff705556887f418a9bfe581bdb4e5_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030d2763_09718991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/16/a4/26/16a426ff1f41256d5f858cd5cca43b827de37e78_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030a7fa7_22400913) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/43/40/3d/43403ddc66f64984f48b059b6bfad5ea584b3b8e_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af203095f58_63648641) /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/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:3 (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 `s3e4_configuration` c LEFT JOIN `s3e4_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	5.497 ms	7308			/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:2 (require)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `s3e4_module` m INNER JOIN s3e4_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 `s3e4_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `s3e4_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `s3e4_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`	3.141 ms	1408	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) /classes/Dispatcher.php:201 (__construct) /index.php:3 (getInstance)
509	SELECT SQL_NO_CACHE c., cl. FROM `s3e4_category` c INNER JOIN s3e4_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `s3e4_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	2.530 ms	432	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:213 (getAllCategories) /classes/Hook.php:1077 (hookdisplayNavSearchBlock) /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/d5/64/8f/d5648f0f6a3ba6514eabf2b369f93eba8644a3da_2.file.desk-header-2.tpl.php:33 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2033d1d93_02182111) /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/33/b8/90/33b8901311641a41f5db1c8b22f1f7d44a866e92_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2033b9ba7_33357095) /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/ed/ea/39/edea393b198acf1023da5dfb8ec34e17cb43f9f2_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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/ed/ea/39/edea393b198acf1023da5dfb8ec34e17cb43f9f2_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2033b15c1_80795621) /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:147 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:65 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030f0d32_38673273) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/94/77/e7/9477e706465ff705556887f418a9bfe581bdb4e5_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030d2763_09718991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/16/a4/26/16a426ff1f41256d5f858cd5cca43b827de37e78_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030a7fa7_22400913) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/43/40/3d/43403ddc66f64984f48b059b6bfad5ea584b3b8e_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af203095f58_63648641) /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/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
46	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `s3e4_category` c INNER JOIN s3e4_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `s3e4_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `s3e4_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.860 ms	432	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
192	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 `s3e4_hook_module` hm STRAIGHT_JOIN `s3e4_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `s3e4_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.504 ms	708			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
191	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `s3e4_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `s3e4_hook_alias` ha INNER JOIN `s3e4_hook` h ON ha.name = h.name	1.502 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) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
154	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1.344 ms	1792	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:189 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
157	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<863 GROUP BY cp.id_category	1.336 ms	1792	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
161	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN s3e4_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute	1.332 ms	3360	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
165	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	1.230 ms	12544			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
169	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p GROUP BY p.condition	1.230 ms	1792	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
164	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	1.221 ms	12544			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
166	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.quantity>0))	1.118 ms	12544			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
156	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `s3e4_category` c INNER JOIN s3e4_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `s3e4_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.nleft, c.position	1.108 ms	432	Yes		/classes/Category.php:724 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
570	SELECT SQL_NO_CACHE mainTable.id_tvcmstestimonial AS code, mainTable.image, mainTable.signature_image, mainTable.signature_text, mainTable.link, subTable.title, subTable.designation, subTable.short_description, subTable.description FROM `s3e4_tvcmstestimonial` mainTable LEFT JOIN s3e4_tvcmstestimonial_lang subTable ON mainTable.id_tvcmstestimonial = subTable.id_tvcmstestimonial WHERE mainTable.id_shop_group = 1 AND mainTable.id_shop = 1 AND mainTable.status = 1 AND subTable.id_lang = 2 ORDER BY `position`	0.842 ms	3	Yes		/modules/tvcmstestimonial/tvcmstestimonial.php:533 /modules/tvcmstestimonial/tvcmstestimonial.php:1228 (showFrontData) /modules/tvcmstestimonial/tvcmstestimonial.php:1248 (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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:195 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:75 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030f0d32_38673273) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/94/77/e7/9477e706465ff705556887f418a9bfe581bdb4e5_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030d2763_09718991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/16/a4/26/16a426ff1f41256d5f858cd5cca43b827de37e78_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030a7fa7_22400913) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/43/40/3d/43403ddc66f64984f48b059b6bfad5ea584b3b8e_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af203095f58_63648641) /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/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
16	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `s3e4_hook`	0.760 ms	995			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:3 (getInstance)
159	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN s3e4_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	0.754 ms	56	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
177	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-06-24 00:00:00', INTERVAL 60 DAY ) ) > 0) as new FROM s3e4_product p LEFT JOIN s3e4_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN s3e4_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN s3e4_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (17026,17027,16801,13040,13132,16277,16278,16279,16295,16296,16297,16298)	0.747 ms	12			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
173	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN s3e4_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute	0.672 ms	42	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
20	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `s3e4_meta` m LEFT JOIN `s3e4_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.637 ms	244	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:3 (getInstance)
175	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN s3e4_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	0.636 ms	56	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
317	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_currency` = 2, 4, 0) + IF (`id_country` = 3, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `s3e4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` IN (0, 16295) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.595 ms	2	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
303	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_currency` = 2, 4, 0) + IF (`id_country` = 3, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `s3e4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` IN (0, 16279) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.589 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
13	SELECT SQL_NO_CACHE lower(name) as name FROM `s3e4_hook` h WHERE (h.active = 1)	0.565 ms	995			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:3 (getInstance)
162	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, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p INNER JOIN s3e4_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value	0.557 ms	7			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
188	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_currency` = 2, 4, 0) + IF (`id_country` = 3, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `s3e4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17026) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.532 ms	2	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
171	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM s3e4_product p INNER JOIN s3e4_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 3) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863	0.519 ms	16			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
163	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, cp.position FROM s3e4_product p LEFT JOIN s3e4_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN s3e4_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN s3e4_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN s3e4_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN s3e4_category_product cp ON (p.id_product = cp.id_product) INNER JOIN s3e4_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN s3e4_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN s3e4_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (11, 22, 27) AND c.nleft>=2 AND c.nright<=863 GROUP BY p.id_product) p INNER JOIN s3e4_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	0.511 ms	7			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
151	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `s3e4_manufacturer` m INNER JOIN s3e4_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `s3e4_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.488 ms	70	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Converter.php:286 (getManufacturers) /modules/ps_facetedsearch/src/Product/SearchProvider.php:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
167	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `s3e4_manufacturer` m INNER JOIN s3e4_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `s3e4_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.485 ms	70	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
423	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_currency` = 2, 4, 0) + IF (`id_country` = 3, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `s3e4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` IN (0, 17247) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.482 ms	2	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/Product.php:5986 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /modules/tvcmsproductpopup/tvcmsproductpopup.php:371 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:256 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:550 (prevHook) /classes/Hook.php:1077 (hookdisplayAfterBodyOpeningTag) /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/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:117 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/8c/dc/d3/8cdcd3db977e65aa410598bd4cd7b707f9fb5ac2_2.file.layout-both-columns.tpl.php:55 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030f0d32_38673273) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/94/77/e7/9477e706465ff705556887f418a9bfe581bdb4e5_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030d2763_09718991) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/16/a4/26/16a426ff1f41256d5f858cd5cca43b827de37e78_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af2030a7fa7_22400913) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v2_autotrics_14layouts_layout_left_column_tpl/43/40/3d/43403ddc66f64984f48b059b6bfad5ea584b3b8e_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a3af203095f58_63648641) /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/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
263	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_currency` = 2, 4, 0) + IF (`id_country` = 3, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `s3e4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` IN (0, 13132) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.476 ms	2	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
290	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_currency` = 2, 4, 0) + IF (`id_country` = 3, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `s3e4_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` IN (0, 16278) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-06-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.467 ms	3	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
17	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `s3e4_module` m LEFT JOIN `s3e4_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.465 ms	128			/classes/module/Module.php:345 /modules/tvcmsblog/tvcmsblog.php:125 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:3 (getInstance)
310	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `s3e4_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 16279 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `s3e4_cart_product` cp JOIN `s3e4_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `s3e4_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 16279 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.463 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5798 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (dispatch)
149	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `s3e4_attribute_group` ag INNER JOIN s3e4_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `s3e4_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `s3e4_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `s3e4_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 2) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.455 ms	23	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:3 (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-intl-normalizer/bootstrap.php
12	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/polyfill-mbstring/bootstrap.php
15	/vendor/symfony/polyfill-mbstring/bootstrap80.php
16	/vendor/symfony/polyfill-php80/bootstrap.php
17	/vendor/symfony/polyfill-ctype/bootstrap.php
18	/vendor/symfony/polyfill-ctype/bootstrap80.php
19	/vendor/symfony/deprecation-contracts/function.php
20	/vendor/guzzlehttp/promises/src/functions_include.php
21	/vendor/guzzlehttp/promises/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ralouphie/getallheaders/src/getallheaders.php
24	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
25	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
26	/vendor/guzzlehttp/guzzle/src/functions_include.php
27	/vendor/guzzlehttp/guzzle/src/functions.php
28	/vendor/symfony/polyfill-php81/bootstrap.php
29	/vendor/symfony/polyfill-php73/bootstrap.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/lcobucci/jwt/compat/class-aliases.php
32	/vendor/lcobucci/jwt/src/Token.php
33	/vendor/lcobucci/jwt/src/Signature.php
34	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
35	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
36	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
37	/vendor/jakeasmith/http_build_url/src/http_build_url.php
38	/vendor/prestashop/laminas-code-lts/polyfill/ReflectionEnumPolyfill.php
39	/vendor/ircmaxell/password-compat/lib/password.php

PLATINE DE BRIDE D'ÉCHAPPEMENT STAGE6 R/T 95

BRIDE D'ÉCHAPPEMENT STAGE6 R/T BIG BORE 95CC

POT D'ÉCHAPPEMENT STAGE6 R/T 95 MBK NITRO

Pot D'échappement 2FAST 100cc FLR 12" ( PIAGGIO )

Kit complet de train avant pour Pour Malamute F12, Fourche JF-1

Panier

PLATINE DE BRIDE D'ÉCHAPPEMENT STAGE6 R/T 95

BRIDE D'ÉCHAPPEMENT STAGE6 R/T BIG BORE 95CC

POT D'ÉCHAPPEMENT STAGE6 R/T 95 MBK NITRO

Pot D'échappement 2FAST 100cc FLR 12" ( PIAGGIO )

PMT RAIN 100/90R12

PMT RAIN 100/90R12

PMT RAIN 100/90R12

PMT RAIN 100/90R12

PMT RAIN 120/80R12

PMT RAIN 120/80R12

PMT RAIN 120/80R12

PMT RAIN 120/80R12

Kit cylindre LMR 70cc FL

Kit cylindre LMR 70cc FL

Kit cylindre LMR 70cc FL

Kit cylindre LMR 70cc FL

PMT Slic 100/90R12

PMT Slic 100/90R12

PMT Slic 100/90R12

PMT Slic 100/90R12

Manchon pipe d'admission 360° Top Perf d. 35mm PWK

Manchon pipe d'admission 360° Top Perf d. 35mm PWK

Manchon pipe d'admission 360° Top Perf d. 35mm PWK

Manchon pipe d'admission 360° Top Perf d. 35mm PWK

KIT CYLINDRE TOP PERF ALU 86 MBK NITRO

KIT CYLINDRE TOP PERF ALU 86 MBK NITRO

KIT CYLINDRE TOP PERF ALU 86 MBK NITRO

KIT CYLINDRE TOP PERF ALU 86 MBK NITRO

VILEBREQUIN TOP PERFORMANCES “RACING” COURSE 44MM / BIELLE 85MM AXE 12MM MBK NITRO / AEROX

VILEBREQUIN TOP PERFORMANCES “RACING” COURSE 44MM / BIELLE 85MM AXE 12MM MBK NITRO / AEROX

VILEBREQUIN TOP PERFORMANCES “RACING” COURSE 44MM / BIELLE 85MM AXE 12MM MBK NITRO / AEROX

VILEBREQUIN TOP PERFORMANCES “RACING” COURSE 44MM / BIELLE 85MM AXE 12MM MBK NITRO / AEROX

PACK MOTEUR 86CC TOP PERFORMANCES + VILEBREQUIN COURSE 44MM MBK NITRO / AEROX

PACK MOTEUR 86CC TOP PERFORMANCES + VILEBREQUIN COURSE 44MM MBK NITRO / AEROX

PACK MOTEUR 86CC TOP PERFORMANCES + VILEBREQUIN COURSE 44MM MBK NITRO / AEROX

PACK MOTEUR 86CC TOP PERFORMANCES + VILEBREQUIN COURSE 44MM MBK NITRO / AEROX

PMT Slic 120/80R12

PMT Slic 120/80R12

PMT Slic 120/80R12

PMT Slic 120/80R12

PMT Blackfire 100/90R12

PMT Blackfire 100/90R12

PMT Blackfire 100/90R12

PMT Blackfire 100/90R12

PMT blackfire 120/80R12

PMT blackfire 120/80R12

PMT blackfire 120/80R12

PMT blackfire 120/80R12

PMT Slic 140/60R13

PMT Slic 140/60R13

PMT Slic 140/60R13

PMT Slic 140/60R13

Stopwatch SQL - 705 queries

Doubles

Tables stress

ObjectModel instances

Included Files