Solaires homme

- -20%
Tom Ford Jameson TF752 55V

Verkaufspreis 336,00 CHF -20% Preis 268,80 CHF
- -20%
Dior CD Diamond S2I 10A0

Verkaufspreis 648,00 CHF -20% Preis 518,40 CHF
- -20%
Dior CD Diamond S5I 10A0

Verkaufspreis 598,00 CHF -20% Preis 478,40 CHF

Load Time	2534 ms
Querying Time	611 ms
Queries	683
Memory Peak Usage	35.1 Mb
Included Files	1002 files - 9.89 Mb
PrestaShop Cache	- Mb
Global vars	0.16 Mb
- global $_MODULES	63k
- global $_MODULE	63k
- global $_SERVER	8k
- global $_ENV	8k
- global $config	6k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k
- global $_REQUEST	2k

PrestaShop Version	9.1.4
PHP Version	8.4.21
MySQL Version	10.6.17-MariaDB-1:10.6.17+maria~deb11-log
Memory Limit	2048M
Max Execution Time	3600s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	26.705 ms	26.705 ms	2.71 Mb	3.7 Mb
__construct	8.723 ms	35.428 ms	1.72 Mb	4.5 Mb
init	635.363 ms	670.791 ms	0.66 Mb	5.5 Mb
checkAccess	0.002 ms	670.793 ms	- Mb	5.5 Mb
setMedia	1608 ms	2278 ms	22.33 Mb	28.7 Mb
postProcess	0.003 ms	2278 ms	- Mb	28.7 Mb
initHeader	0.003 ms	2278 ms	- Mb	28.7 Mb
initContent	122.182 ms	2400 ms	2.19 Mb	29.7 Mb
initFooter	0.003 ms	2400 ms	- Mb	29.7 Mb
display	133.252 ms	2534 ms	5.31 Mb	35.1 Mb

Hook	Time	Memory Usage
displayTop	51.858 ms	2.70 Mb
=> ps_mainmenu (widget)	51.858 ms	2.70 Mb
DisplayBeforeBodyClosingTag	20.699 ms	0.32 Mb
=> statsdata	16.813 ms	0.14 Mb
=> ps_googleanalytics	3.886 ms	0.18 Mb
displayFooter	16.803 ms	0.70 Mb
=> ps_linklist (widget)	12.693 ms	0.57 Mb
=> ps_customeraccountlinks (widget)	2.509 ms	0.07 Mb
=> ps_contactinfo (widget)	1.601 ms	0.06 Mb
displayNav2	7.599 ms	0.43 Mb
=> ps_searchbar (widget)	0.809 ms	0.05 Mb
=> ps_languageselector (widget)	1.243 ms	0.05 Mb
=> ps_currencyselector (widget)	3.247 ms	0.21 Mb
=> ps_customersignin (widget)	0.809 ms	0.05 Mb
=> ps_shoppingcart (widget)	1.491 ms	0.08 Mb
displayFooterBefore	6.890 ms	0.28 Mb
=> ps_emailsubscription (widget)	4.377 ms	0.21 Mb
=> ps_socialfollow (widget)	2.513 ms	0.06 Mb
ActionFrontControllerSetMedia	4.520 ms	0.06 Mb
=> blockreassurance	0.170 ms	- Mb
=> ps_emailsubscription	0.076 ms	- Mb
=> ps_emailalerts	0.025 ms	- Mb
=> ps_socialfollow	0.036 ms	- Mb
=> saferpayofficial	4.213 ms	0.06 Mb
displayLeftColumn	4.390 ms	0.17 Mb
=> ps_categorytree (widget)	4.390 ms	0.17 Mb
displayTopSlider	4.169 ms	0.16 Mb
=> ps_imageslider (widget)	4.169 ms	0.16 Mb
DisplayHeader	1.123 ms	0.02 Mb
=> ps_searchbar	0.419 ms	0.01 Mb
=> ps_shoppingcart	0.038 ms	- Mb
=> ps_imageslider	0.076 ms	- Mb
=> ps_googleanalytics	0.590 ms	0.01 Mb
DisplayGDPRConsent	1.103 ms	0.03 Mb
=> psgdpr	1.103 ms	0.03 Mb
ProductSearchProvider	0.497 ms	- Mb
=> ps_facetedsearch	0.497 ms	- Mb
DisplayLeftColumn	0.175 ms	0.02 Mb
=> ps_facetedsearch	0.175 ms	0.02 Mb
12 hook(s)	119.825 ms	4.90 Mb

Module	Time	Memory Usage
blockreassurance	1600 ms	21.93 Mb
__construct	1600 ms	21.93 Mb
hookActionFrontControllerSetMedia	0.174 ms	- Mb
ps_emailsubscription	4.572 ms	0.22 Mb
__construct	0.115 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.078 ms	- Mb
displayFooterBefore	4.379 ms	0.22 Mb
ps_emailalerts	0.137 ms	0.01 Mb
__construct	0.111 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.026 ms	- Mb
ps_socialfollow	2.619 ms	0.13 Mb
__construct	0.064 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.037 ms	- Mb
displayFooterBefore	2.518 ms	0.07 Mb
saferpayofficial	4.457 ms	0.12 Mb
__construct	0.235 ms	0.06 Mb
hookActionFrontControllerSetMedia	4.222 ms	0.06 Mb
ps_searchbar	1.381 ms	0.06 Mb
__construct	0.143 ms	0.01 Mb
hookDisplayHeader	0.425 ms	0.01 Mb
displayNav2	0.813 ms	0.05 Mb
ps_shoppingcart	1.623 ms	0.09 Mb
__construct	0.089 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
displayNav2	1.494 ms	0.08 Mb
ps_imageslider	4.374 ms	0.16 Mb
__construct	0.123 ms	0.01 Mb
hookDisplayHeader	0.078 ms	- Mb
displayTopSlider	4.173 ms	0.16 Mb
ps_googleanalytics	4.580 ms	0.20 Mb
__construct	0.097 ms	0.01 Mb
hookDisplayHeader	0.592 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.891 ms	0.18 Mb
ps_facetedsearch	1.155 ms	0.04 Mb
__construct	0.477 ms	0.01 Mb
hookProductSearchProvider	0.500 ms	- Mb
hookDisplayLeftColumn	0.178 ms	0.02 Mb
ps_mainmenu	52.023 ms	2.70 Mb
__construct	0.158 ms	0.01 Mb
displayTop	51.865 ms	2.70 Mb
ps_languageselector	1.372 ms	0.06 Mb
__construct	0.125 ms	0.01 Mb
displayNav2	1.247 ms	0.05 Mb
ps_currencyselector	3.372 ms	0.22 Mb
__construct	0.122 ms	0.01 Mb
displayNav2	3.250 ms	0.21 Mb
ps_customersignin	0.903 ms	0.05 Mb
__construct	0.091 ms	0.01 Mb
displayNav2	0.812 ms	0.05 Mb
ps_categorytree	4.492 ms	0.17 Mb
__construct	0.098 ms	0.01 Mb
displayLeftColumn	4.394 ms	0.17 Mb
psgdpr	2.313 ms	0.10 Mb
__construct	1.203 ms	0.07 Mb
hookDisplayGDPRConsent	1.110 ms	0.03 Mb
ps_linklist	13.731 ms	0.66 Mb
__construct	1.030 ms	0.09 Mb
displayFooter	12.701 ms	0.57 Mb
ps_customeraccountlinks	2.773 ms	0.08 Mb
__construct	0.257 ms	0.01 Mb
displayFooter	2.516 ms	0.07 Mb
ps_contactinfo	1.751 ms	0.07 Mb
__construct	0.146 ms	0.01 Mb
displayFooter	1.605 ms	0.06 Mb
statsdata	16.940 ms	0.15 Mb
__construct	0.119 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	16.821 ms	0.14 Mb
20 module(s)	1725 ms	27.22 Mb

Sample 3

EXCEPTEUR OCCAECAT

Solaires homme

Solaires homme

Tom Ford Jameson TF752 55V

Dior CD Diamond S2I 10A0

Dior CD Diamond S5I 10A0

Stopwatch SQL - 683 queries

Doubles

Tables stress

ObjectModel instances

Included Files

177 queries	SELECT `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = XX AND theme IS NULL
172 queries	SELECT `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = XX AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = XX)
53 queries	SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = XX LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = XX WHERE (a.`id_manufacturer` = XX) LIMIT XX
20 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
20 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
13 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'de-de' OR `language_code` = 'de-de' LIMIT XX
6 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
5 queries	SELECT c., cl. FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = XX LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` cXX ON cXX.`id_category` = XX AND c.`nleft` >= cXX.`nleft` AND c.`nright` <= cXX.`nright` WHERE XX AND `id_lang` = XX AND cg.`id_group` IN (XX) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC
4 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
4 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
4 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
3 queries	SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `ps_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 * FROM `ps_currency` a LEFT JOIN `ps_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 * FROM `ps_currency_lang` WHERE `id_currency` = XX
3 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
3 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
3 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
3 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
3 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
3 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
3 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
3 queries	SELECT * FROM `ps_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
3 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN ps_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
3 queries	SELECT al.`name` AS attribute_name FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
2 queries	SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 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, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND 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 ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((fp_XX.id_feature_value=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY pac.id_attribute
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT * FROM `ps_link_block` a LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_link_block_lang` WHERE `id_link_block` = XX
2 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
2 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX

Name	Instances	Source
Manufacturer	53	/modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 3] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 17] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 7] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 8] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 9] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 33] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 34] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 35] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 37] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 39] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 40] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 41] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 42] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 43] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 5] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 48] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 45] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 16] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 4] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 69] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 68] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 18] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 57] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 6] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 53] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 10] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 31] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 66] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 36] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 60] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 38] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 64] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 63] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 52] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 62] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 55] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 44] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 61] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 54] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 56] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 46] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 51] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 14] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 20] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 15] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 22] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 12] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 27] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 13] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 28] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 21] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 24] /modules/ps_mainmenu/ps_mainmenu.php:624 (__construct) [id: 19]
Category	40	/controllers/front/listing/CategoryController.php:67 (__construct) [id: 40] /classes/Meta.php:344 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:365 (__construct) [id: 40] /modules/ps_facetedsearch/src/Filters/Block.php:158 (__construct) [id: 40] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 35] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 37] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 38] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 36] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 39] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 40] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 41] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 43] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 12] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 14] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 30] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 13] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 15] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 16] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 31] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 24] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 32] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 33] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 25] /modules/ps_mainmenu/ps_mainmenu.php:768 (__construct) [id: 29] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /classes/Link.php:396 (__construct) [id: 40] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Product	10	/src/Adapter/Image/ImageRetriever.php:48 (__construct) [id: 1291] /src/Adapter/Image/ImageRetriever.php:48 (__construct) [id: 1308] /src/Adapter/Image/ImageRetriever.php:48 (__construct) [id: 1309] /classes/Link.php:94 (__construct) [id: 1291] /classes/Link.php:94 (__construct) [id: 1291] /classes/Link.php:94 (__construct) [id: 1291] /classes/Link.php:94 (__construct) [id: 1308] /classes/Link.php:94 (__construct) [id: 1308] /classes/Link.php:94 (__construct) [id: 1309] /classes/Link.php:94 (__construct) [id: 1309]
Currency	6	/src/Adapter/Currency/CurrencyDataProvider.php:81 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:81 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:81 (__construct) [id: 2] /classes/Tools.php:688 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 3] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2]
Country	5	/config/config.inc.php:135 (__construct) [id: 19] /classes/AddressFormat.php:382 (__construct) [id: 19] /classes/controller/FrontController.php:1750 (__construct) [id: 19] /classes/AddressFormat.php:382 (__construct) [id: 19] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 19]
Address	4	/classes/shop/Shop.php:467 (__construct) [id: ] /classes/Product.php:3431 (initialize) [id: ] /classes/Product.php:3550 (__construct) [id: ] /classes/Product.php:5706 (__construct) [id: ]
CMS	3	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 3] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 4]
Language	3	/config/config.inc.php:200 (__construct) [id: 1] /classes/Tools.php:639 (__construct) [id: 2] /classes/Tools.php:533 (__construct) [id: 2]
Combination	3	/classes/Product.php:5654 (__construct) [id: 127748] /classes/Product.php:5654 (__construct) [id: 127772] /classes/Product.php:5654 (__construct) [id: 127773]
Tax	2	/classes/tax/TaxRulesTaxManager.php:93 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:93 (__construct) [id: 1]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 35] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 35]
PrestaShop\Module\LinkList\Model\LinkBlock	2	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 1] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2]
AddressFormat	2	/classes/controller/FrontController.php:1744 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
State	2	/classes/controller/FrontController.php:1749 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Shop	1	/config/config.inc.php:103 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1670 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1667 (__construct) [id: 0]
Group	1	/classes/Cart.php:262 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:441 (__construct) [id: ]
Customer	1	/config/config.inc.php:253 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:542 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Location
674	SELECT SQL_NO_CACHE `id_date_range`, `time_end` FROM `ps_date_range` WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1	5.562 ms	71622369		/classes/DateRange.php:37 /classes/Page.php:102 (getCurrentRange) /modules/statsdata/statsdata.php:121 (setPageViewed) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1234 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:15 (coreCallHook) /classes/Hook.php:447 (coreCallHook) /classes/Hook.php:1125 (callHookOn) /config/smarty.config.inc.php:193 (exec) /classes/Smarty/SmartyLazyRegister.php:61 (smartyHook) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:370 (__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/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:116 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8fb5c0_09524138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/36/85/32/368532e0aa560aa8c9f739f71e0c11947ade7364_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e7cd8_94420354) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/df/85/d2/df85d29cc7f96289bd69ed77aa14303c1c1646a5_2.file.product-list.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e2302_56838144) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3a/5b/90/3a5b906aca20a8e1b9c2756762ced8bbcbc78e3d_2.file.category.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8d7d18_64220542) /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:20 (fetch) /classes/controller/FrontController.php:764 (fetch) /classes/controller/FrontController.php:748 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
434	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (7, 9, 48) AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=5)) AND ((fp_1.id_feature_value=14)) AND ((pac_2.id_attribute IN (8, 11))) GROUP BY fp.id_feature_value	4.840 ms	456488108032	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:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
430	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) GROUP BY p.id_manufacturer	4.184 ms	569184	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:662 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:147 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
425	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (7, 9, 48) AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	4.113 ms	2638659584	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:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
672	INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('6779481', '1091', '2026-06-08 17:35:32')	3.549 ms	1		/classes/Connection.php:93 /modules/statsdata/statsdata.php:118 (setPageConnection) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1234 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:15 (coreCallHook) /classes/Hook.php:447 (coreCallHook) /classes/Hook.php:1125 (callHookOn) /config/smarty.config.inc.php:193 (exec) /classes/Smarty/SmartyLazyRegister.php:61 (smartyHook) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:370 (__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/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:116 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8fb5c0_09524138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/36/85/32/368532e0aa560aa8c9f739f71e0c11947ade7364_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e7cd8_94420354) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/df/85/d2/df85d29cc7f96289bd69ed77aa14303c1c1646a5_2.file.product-list.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e2302_56838144) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3a/5b/90/3a5b906aca20a8e1b9c2756762ced8bbcbc78e3d_2.file.category.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8d7d18_64220542) /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:20 (fetch) /classes/controller/FrontController.php:764 (fetch) /classes/controller/FrontController.php:748 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
433	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (7, 9, 48) AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=3)) AND ((fp_1.id_feature_value=14)) AND ((pac_2.id_attribute IN (8, 11))) GROUP BY pac.id_attribute	3.281 ms	15224	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:738 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
428	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (7, 9, 48) AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>12 AND c.nright<13 GROUP BY cp.id_category	3.189 ms	2679424	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:993 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:159 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
436	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (7, 9, 48) AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((pac_1.id_attribute IN (8, 11))) GROUP BY fp.id_feature_value	2.751 ms	2679424	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:856 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:155 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
131	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.525 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
129	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.490 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
384	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.410 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
3	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.288 ms	792		/classes/Configuration.php:162 /classes/Configuration.php:210 (loadConfiguration) /classes/Configuration.php:283 (get) /classes/shop/Shop.php:379 (getMultiShopValues) /config/config.inc.php:103 (initialize) /index.php:20 (require_once)
457	SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1	2.196 ms	1		/src/Adapter/EntityMapper.php:54 /classes/ObjectModel.php:197 (load) /tools/profiling/ObjectModel.php:12 (__construct) /classes/tax/TaxRulesTaxManager.php:93 (__construct) /classes/Product.php:3672 (getTaxCalculator) /classes/Product.php:3462 (priceCalculation) /classes/Product.php:5462 (getPriceStatic) /classes/ProductAssembler.php:194 (getProductProperties) /classes/controller/ProductListingFrontController.php:86 (assembleProducts) /classes/controller/ProductListingFrontController.php:356 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
386	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.195 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
133	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.190 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
235	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.181 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
385	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.173 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
675	UPDATE `ps_page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = 8464 AND `id_page` = 1091 AND `id_shop` = 1	2.117 ms	1		/classes/Page.php:111 /modules/statsdata/statsdata.php:121 (setPageViewed) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1234 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:15 (coreCallHook) /classes/Hook.php:447 (coreCallHook) /classes/Hook.php:1125 (callHookOn) /config/smarty.config.inc.php:193 (exec) /classes/Smarty/SmartyLazyRegister.php:61 (smartyHook) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:370 (__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/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:116 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8fb5c0_09524138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/36/85/32/368532e0aa560aa8c9f739f71e0c11947ade7364_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e7cd8_94420354) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/df/85/d2/df85d29cc7f96289bd69ed77aa14303c1c1646a5_2.file.product-list.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e2302_56838144) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3a/5b/90/3a5b906aca20a8e1b9c2756762ced8bbcbc78e3d_2.file.category.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8d7d18_64220542) /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:20 (fetch) /classes/controller/FrontController.php:764 (fetch) /classes/controller/FrontController.php:748 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
454	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	2.093 ms	0		/classes/Hook.php:1565 /classes/Hook.php:244 (getAllHookIds) /classes/tax/TaxManagerFactory.php:43 (getIdByName) /classes/tax/TaxManagerFactory.php:22 (execHookTaxManagerFactory) /classes/Product.php:3671 (getManager) /classes/Product.php:3462 (priceCalculation) /classes/Product.php:5462 (getPriceStatic) /classes/ProductAssembler.php:194 (getProductProperties) /classes/controller/ProductListingFrontController.php:86 (assembleProducts) /classes/controller/ProductListingFrontController.php:356 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
147	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.086 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
241	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.073 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
442	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("cd2470ee2b931fc7ad6e0ef3e8dffc96", "a:1:{s:7:\"filters\";a:6:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Kategorien\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marke\";s:6:\"values\";a:3:{i:7;a:3:{s:4:\"name\";s:16:\"1.Christian Dior\";s:3:\"nbr\";i:2;s:7:\"checked\";b:1;}i:48;a:3:{s:4:\"name\";s:10:\"1.Tom Ford\";s:3:\"nbr\";i:1;s:7:\"checked\";b:1;}i:57;a:2:{s:4:\"name\";s:7:\"Céline\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Preis\";s:3:\"max\";d:648;s:3:\"min\";d:268;s:4:\"unit\";s:3:\"CHF\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"·\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"CHF\";s:14:\"currencySymbol\";s:3:\"CHF\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"·\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:3;s:5:\"value\";N;}i:3;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:5;s:6:\"values\";a:2:{i:23;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"Gerundet\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:27;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:21:\"Rechteckig / Wayfarer\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\" Bilden\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:1;s:6:\"values\";a:2:{i:15;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Metall\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:7:\"Plastik\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:15:\"Zusammensetzung\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:2;s:4:\"name\";s:5:\"Farbe\";s:14:\"is_color_group\";b:1;s:6:\"values\";a:4:{i:11;a:6:{s:4:\"name\";s:7:\"Schwarz\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#434A54\";s:7:\"checked\";b:1;}i:14;a:5:{s:4:\"name\";s:4:\"Blau\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#5D9CEC\";}i:301;a:5:{s:4:\"name\";s:20:\"Brun écaille/Havana\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:332;a:5:{s:4:\"name\";s:11:\"Army (vert)\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#555800\";}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	2.073 ms	1		/modules/ps_facetedsearch/src/Filters/Block.php:210 /modules/ps_facetedsearch/src/Product/SearchProvider.php:220 (insertIntoCache) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
77	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.068 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
75	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.064 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
79	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	2.061 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
422	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 2) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC	2.058 ms	39	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:166 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
421	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 2) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 2) WHERE v.`id_feature` = 1 ORDER BY vl.`value` ASC	2.050 ms	5	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Converter.php:402 (getFeatureValues) /modules/ps_facetedsearch/src/Product/SearchProvider.php:166 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
71	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.995 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
371	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.981 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
673	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('6779481', '', 'optishops.ch/de/40-solaires-homme?q=Marke-1.Christian+Dior-1.Emporio+Armani-1.Tom+Ford%2FFarbe-Wei%C3%9F-Schwarz%2FZusammensetzung-Plastik', '', '2026-06-08 17:35:32')	1.959 ms	1		/classes/ObjectModel.php:524 /classes/ConnectionsSource.php:86 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1234 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:15 (coreCallHook) /classes/Hook.php:447 (coreCallHook) /classes/Hook.php:1125 (callHookOn) /config/smarty.config.inc.php:193 (exec) /classes/Smarty/SmartyLazyRegister.php:61 (smartyHook) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:370 (__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/multi_sportlayouts_layout_left_column_tpl/3f/8d/34/3f8d34c8b06ac1af4785c36fdc711bb91f94127e_2.file.layout-both-columns.tpl.php:116 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8fb5c0_09524138) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/36/85/32/368532e0aa560aa8c9f739f71e0c11947ade7364_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e7cd8_94420354) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/df/85/d2/df85d29cc7f96289bd69ed77aa14303c1c1646a5_2.file.product-list.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8e2302_56838144) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/multi_sportlayouts_layout_left_column_tpl/3a/5b/90/3a5b906aca20a8e1b9c2756762ced8bbcbc78e3d_2.file.category.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a26e0df8d7d18_64220542) /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:20 (fetch) /classes/controller/FrontController.php:764 (fetch) /classes/controller/FrontController.php:748 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
63	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.932 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
65	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.931 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
67	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.929 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
103	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.917 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
57	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.908 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
69	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.908 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
144	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IS NULL	1.874 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
499	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) WHERE i.`id_product` = 1291 ORDER BY `position`	1.872 ms	2	Yes	/classes/Product.php:3262 /src/Adapter/Image/ImageRetriever.php:55 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:933 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:118 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:30 (__construct) /classes/controller/ProductListingFrontController.php:94 (present) /classes/controller/ProductListingFrontController.php:356 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
441	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((fp.id_feature_value=14)) AND ((pac_1.id_attribute IN (8, 11))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (7, 9, 48) AND c.nleft>=12 AND c.nright<=13 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=16)) AND ((fp_1.id_feature_value=14)) AND ((pac_2.id_attribute IN (8, 11))) GROUP BY pac.id_attribute	1.856 ms	38192	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:738 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:151 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:218 (getFilterBlock) /classes/controller/ProductListingFrontController.php:334 (runQuery) /classes/controller/ProductListingFrontController.php:630 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:164 (doProductSearch) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:468 (run) /index.php:66 (dispatch)
243	SELECT SQL_NO_CACHE `key`, `translation`, `domain` FROM `ps_translation` WHERE `id_lang` = 2 AND theme IN (SELECT `theme` FROM `ps_shop` WHERE `active` = 1)	1.833 ms	1163		/src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:73 /vendor/symfony/translation/Translator.php:362 (load) /vendor/symfony/translation/Translator.php:256 (doLoadCatalogue) /vendor/symfony/translation/Translator.php:290 (initializeCatalogue) /vendor/symfony/translation/Translator.php:275 (dumpCatalogue) /vendor/symfony/config/ConfigCacheFactory.php:39 ({closure:Symfony\Component\Translation\Translator::initializeCacheCatalogue():274}) /vendor/symfony/translation/Translator.php:273 (cache) /vendor/symfony/translation/Translator.php:244 (initializeCacheCatalogue) /vendor/symfony/translation/Translator.php:215 (loadCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:158 (getCatalogue) /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php:38 (shouldFallbackToLegacyModuleTranslation) /classes/module/Module.php:3536 (trans) /modules/blockreassurance/blockreassurance.php:108 (trans) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:104 (newInstance) /src/Core/Foundation/IoC/Container.php:134 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:147 (doMake) /src/Adapter/ServiceLocator.php:50 (make) /classes/module/Module.php:1386 (get) /tools/profiling/Module.php:15 (coreLoadModule) /classes/module/Module.php:1365 (coreLoadModule) /classes/Hook.php:1105 (getInstanceByName) /classes/controller/FrontController.php:999 (exec) /tools/profiling/Controller.php:33 (setMedia) /classes/Dispatcher.php:468 (run) /index.php:66 (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/autoload_static.php
9	/vendor/symfony/deprecation-contracts/function.php
10	/vendor/symfony/polyfill-mbstring/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap80.php
12	/vendor/symfony/polyfill-ctype/bootstrap.php
13	/vendor/symfony/polyfill-ctype/bootstrap80.php
14	/vendor/symfony/polyfill-php83/bootstrap.php
15	/vendor/symfony/var-dumper/Resources/functions/dump.php
16	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
18	/vendor/twig/twig/src/Resources/core.php
19	/vendor/twig/twig/src/Resources/debug.php
20	/vendor/twig/twig/src/Resources/escaper.php
21	/vendor/twig/twig/src/Resources/string_loader.php
22	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.php
24	/vendor/symfony/string/Resources/functions.php
25	/vendor/symfony/polyfill-intl-idn/bootstrap.php
26	/vendor/symfony/clock/Resources/now.php
27	/vendor/symfony/polyfill-php80/bootstrap.php
28	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
29	/vendor/jakeasmith/http_build_url/src/http_build_url.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/symfony/polyfill-php84/bootstrap.php
32	/vendor/ircmaxell/password-compat/lib/password.php
33	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
34	/vendor/symfony/polyfill-php73/bootstrap.php
35	/vendor/symfony/translation/Resources/functions.php
36	/src/Core/Version.php
37	/config/alias.php
38	/vendor/prestashop/autoload/src/PrestashopAutoload.php
39	/vendor/prestashop/autoload/src/LegacyClassLoader.php