Accueil

Update Design est votre référence en éclairage design en Tunisie, spécialisée dans les luminaires modernes et les solutions de décoration intérieure haut de gamme. Nous proposons une sélection soignée de luminaires contemporains adaptés aussi bien aux espaces résidentiels qu’aux projets professionnels.

Notre collection comprend des suspensions design, lampes modernes, appliques murales, éclairages LED et accessoires décoratifs pensés pour sublimer chaque intérieur. Que vous recherchiez un style moderne, minimaliste ou élégant, nos luminaires design répondent aux exigences esthétiques et fonctionnelles les plus élevées.

Chez update Design, nous accordons une importance particulière à la qualité des matériaux, à l’efficacité énergétique et au design contemporain. Nos solutions d’éclairage moderne ainsi que les solutions de décorations d'intérieur et extérieur en Tunisie sont idéales pour les salons, cuisines, bureaux, hôtels et espaces commerciaux.

Faites confiance à notre expertise en design intérieur et éclairage décoratif pour créer des ambiances uniques et chaleureuses. Découvrez dès maintenant nos luminaires modernes en Tunisie et donnez du caractère à vos espaces avec un éclairage à la fois esthétique et performant

Aucun produit disponible pour le moment

Restez à l'écoute ! D'autres produits seront affichés ici au fur et à mesure qu'ils seront ajoutés.

Load Time	647.074 ms
Querying Time	134 ms
Queries	135
Memory Peak Usage	7.3 Mb
Included Files	1102 files - 13.14 Mb
PrestaShop Cache	1.16 Mb
Global vars	0.57 Mb
- global $_MODULES	542k
- global $_MODULE	9k
- global $_SERVER	7k
- global $config	5k
- global $__composer_autoload_files	4k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k

PrestaShop Version	8.1.0
PHP Version	8.3.17
MySQL Version	11.4.5-MariaDB-ubu2404-log
Memory Limit	512M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	13.963 ms	13.963 ms	2.43 Mb	2.9 Mb
__construct	0.967 ms	14.930 ms	- Mb	3.0 Mb
init	73.205 ms	88.135 ms	0.70 Mb	3.5 Mb
checkAccess	0.002 ms	88.137 ms	- Mb	3.5 Mb
setMedia	27.622 ms	115.759 ms	0.04 Mb	3.8 Mb
postProcess	0.002 ms	115.761 ms	- Mb	3.8 Mb
initHeader	0.002 ms	115.763 ms	- Mb	3.8 Mb
initContent	360.215 ms	475.978 ms	1.84 Mb	5.6 Mb
initFooter	0.006 ms	475.984 ms	- Mb	5.6 Mb
display	171.090 ms	647.074 ms	1.79 Mb	7.3 Mb

Hook	Time	Memory Usage
DisplayHeader	165.020 ms	0.60 Mb
=> ps_shoppingcart	0.509 ms	- Mb
=> ps_searchbar	3.290 ms	- Mb
=> ps_imageslider	1.632 ms	- Mb
=> ps_googleanalytics	3.505 ms	0.01 Mb
=> psxmarketingwithgoogle	5.970 ms	- Mb
=> leobootstrapmenu	8.696 ms	0.01 Mb
=> ps_facebook	93.115 ms	0.33 Mb
=> blockgrouptop	0.815 ms	0.01 Mb
=> appagebuilder	36.561 ms	0.20 Mb
=> leofeature	10.927 ms	0.02 Mb
displayTop	76.327 ms	0.67 Mb
=> ps_shoppingcart (widget)	1.138 ms	- Mb
=> ps_customersignin (widget)	6.073 ms	0.01 Mb
=> ps_searchbar (widget)	1.553 ms	- Mb
=> appagebuilder (widget)	67.563 ms	0.66 Mb
displayLeftColumn	13.465 ms	0.35 Mb
=> ps_categorytree (widget)	11.523 ms	0.35 Mb
=> leobootstrapmenu (widget)	0.013 ms	- Mb
=> appagebuilder (widget)	1.929 ms	0.01 Mb
Header	10.370 ms	0.07 Mb
=> leoslideshow	4.271 ms	0.06 Mb
=> leoquicklogin	1.757 ms	0.01 Mb
=> everpsquotation	0.623 ms	- Mb
=> askforquote	1.933 ms	- Mb
=> konnect	1.786 ms	- Mb
DisplayBeforeBodyClosingTag	6.718 ms	0.07 Mb
=> ps_googleanalytics	1.953 ms	0.03 Mb
=> leoquicklogin	4.733 ms	0.04 Mb
=> leofeature	0.032 ms	- Mb
displayBanner	5.635 ms	0.05 Mb
=> appagebuilder (widget)	5.635 ms	0.05 Mb
ActionFrontControllerSetMedia	5.628 ms	0.01 Mb
=> blockreassurance	2.589 ms	- Mb
=> ps_emailsubscription	0.641 ms	- Mb
=> ps_socialfollow	1.145 ms	- Mb
=> ps_emailalerts	0.563 ms	- Mb
=> ps_facebook	0.690 ms	- Mb
ProductSearchProvider	4.911 ms	- Mb
=> ps_facetedsearch	4.911 ms	- Mb
DisplayNavFullWidth	4.630 ms	0.05 Mb
=> blockreassurance	0.007 ms	- Mb
=> leoslideshow	4.604 ms	0.05 Mb
=> leoquicklogin	0.019 ms	- Mb
DisplayLeftColumn	4.448 ms	0.08 Mb
=> ps_facetedsearch	3.145 ms	0.03 Mb
=> leoslideshow	1.290 ms	0.05 Mb
=> leoquicklogin	0.013 ms	- Mb
DisplayAfterBodyOpeningTag	3.629 ms	- Mb
=> leoquicklogin	3.614 ms	- Mb
=> blockreassurance	0.015 ms	- Mb
displayNavFullWidth	1.806 ms	0.01 Mb
=> leobootstrapmenu (widget)	0.015 ms	- Mb
=> appagebuilder (widget)	1.791 ms	0.01 Mb
DisplayFooterBefore	1.540 ms	0.05 Mb
=> leoslideshow	1.527 ms	0.05 Mb
=> leoquicklogin	0.013 ms	- Mb
displaySearch	1.362 ms	- Mb
=> ps_searchbar (widget)	1.362 ms	- Mb
displayNav1	1.359 ms	0.01 Mb
=> appagebuilder (widget)	1.359 ms	0.01 Mb
displayNav2	1.333 ms	0.01 Mb
=> appagebuilder (widget)	1.333 ms	0.01 Mb
DisplayFooter	1.142 ms	0.05 Mb
=> leoslideshow	1.131 ms	0.05 Mb
=> leoquicklogin	0.011 ms	- Mb
DisplayFooterAfter	1.121 ms	0.05 Mb
=> blockreassurance	0.006 ms	- Mb
=> leoslideshow	1.106 ms	0.05 Mb
=> leoquicklogin	0.009 ms	- Mb
displayFooterBefore	0.986 ms	0.01 Mb
=> leobootstrapmenu (widget)	0.012 ms	- Mb
=> appagebuilder (widget)	0.974 ms	0.01 Mb
displayFooter	0.892 ms	0.02 Mb
=> leobootstrapmenu (widget)	0.008 ms	- Mb
=> appagebuilder (widget)	0.884 ms	0.02 Mb
displayFooterAfter	0.883 ms	0.01 Mb
=> leobootstrapmenu (widget)	0.008 ms	- Mb
=> appagebuilder (widget)	0.875 ms	0.01 Mb
ModuleRoutes	0.646 ms	0.02 Mb
=> appagebuilder	0.646 ms	0.02 Mb
FilterCategoryContent	0.396 ms	0.01 Mb
=> appagebuilder	0.396 ms	0.01 Mb
ActionOutputHTMLBefore	0.120 ms	- Mb
=> appagebuilder	0.120 ms	- Mb
FilterHtmlContent	0.039 ms	- Mb
=> appagebuilder	0.009 ms	- Mb
=> appagebuilder	0.006 ms	- Mb
=> appagebuilder	0.024 ms	- Mb
ActionDispatcher	0.025 ms	- Mb
=> psassistant	0.014 ms	- Mb
=> mbeshipping	0.011 ms	- Mb
DisplayNav1	0.021 ms	- Mb
=> leoquicklogin	0.021 ms	- Mb
ActionDispatcherBefore	0.018 ms	- Mb
=> psassistant	0.018 ms	- Mb
DisplayNav2	0.012 ms	- Mb
=> leoquicklogin	0.012 ms	- Mb
DisplayTop	0.012 ms	- Mb
=> leoquicklogin	0.012 ms	- Mb
30 hook(s)	314.493 ms	2.23 Mb

Module	Time	Memory Usage
appagebuilder	126.354 ms	1.24 Mb
__construct	6.169 ms	0.22 Mb
hookModuleRoutes	0.652 ms	0.02 Mb
hookFilterHtmlContent	0.014 ms	- Mb
hookFilterCategoryContent	0.401 ms	0.01 Mb
hookFilterHtmlContent	0.012 ms	- Mb
hookFilterHtmlContent	0.029 ms	- Mb
hookDisplayHeader	36.569 ms	0.21 Mb
displayBanner	5.641 ms	0.05 Mb
displayNav1	1.365 ms	0.01 Mb
displayNav2	1.338 ms	0.01 Mb
displayTop	67.569 ms	0.66 Mb
displayNavFullWidth	1.798 ms	0.01 Mb
displayLeftColumn	1.934 ms	0.01 Mb
displayFooterBefore	0.976 ms	0.01 Mb
displayFooter	0.887 ms	0.02 Mb
displayFooterAfter	0.878 ms	0.01 Mb
hookActionOutputHTMLBefore	0.123 ms	- Mb
psassistant	4.121 ms	0.18 Mb
__construct	4.077 ms	0.18 Mb
hookActionDispatcherBefore	0.023 ms	- Mb
hookActionDispatcher	0.021 ms	- Mb
mbeshipping	6.260 ms	0.10 Mb
__construct	6.244 ms	0.10 Mb
hookActionDispatcher	0.016 ms	- Mb
blockreassurance	5.303 ms	0.02 Mb
__construct	2.672 ms	0.01 Mb
hookActionFrontControllerSetMedia	2.596 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.019 ms	- Mb
hookDisplayNavFullWidth	0.009 ms	- Mb
hookDisplayFooterAfter	0.007 ms	- Mb
ps_emailsubscription	3.015 ms	0.01 Mb
__construct	2.368 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.647 ms	- Mb
ps_socialfollow	2.854 ms	0.01 Mb
__construct	1.705 ms	0.01 Mb
hookActionFrontControllerSetMedia	1.149 ms	- Mb
ps_emailalerts	2.663 ms	0.01 Mb
__construct	2.095 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.568 ms	- Mb
ps_facebook	103.579 ms	0.33 Mb
__construct	9.761 ms	- Mb
hookActionFrontControllerSetMedia	0.695 ms	- Mb
hookDisplayHeader	93.123 ms	0.33 Mb
ps_shoppingcart	3.636 ms	0.01 Mb
__construct	1.975 ms	0.01 Mb
hookDisplayHeader	0.515 ms	- Mb
displayTop	1.146 ms	- Mb
ps_searchbar	8.105 ms	0.02 Mb
__construct	1.886 ms	0.01 Mb
hookDisplayHeader	3.297 ms	- Mb
displayTop	1.557 ms	- Mb
displaySearch	1.365 ms	- Mb
ps_imageslider	3.415 ms	0.01 Mb
__construct	1.776 ms	0.01 Mb
hookDisplayHeader	1.639 ms	- Mb
ps_googleanalytics	7.651 ms	0.05 Mb
__construct	2.183 ms	0.01 Mb
hookDisplayHeader	3.511 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.957 ms	0.03 Mb
psxmarketingwithgoogle	8.966 ms	0.01 Mb
__construct	2.987 ms	0.01 Mb
hookDisplayHeader	5.979 ms	- Mb
leobootstrapmenu	11.295 ms	0.05 Mb
__construct	2.524 ms	0.04 Mb
hookDisplayHeader	8.704 ms	0.01 Mb
displayNavFullWidth	0.018 ms	- Mb
displayLeftColumn	0.015 ms	- Mb
displayFooterBefore	0.014 ms	- Mb
displayFooter	0.010 ms	- Mb
displayFooterAfter	0.010 ms	- Mb
ps_accounts	3.648 ms	- Mb
__construct	3.648 ms	- Mb
leoslideshow	17.078 ms	0.35 Mb
__construct	3.122 ms	0.04 Mb
hookHeader	4.276 ms	0.06 Mb
hookDisplayNavFullWidth	4.612 ms	0.05 Mb
hookDisplayLeftColumn	1.293 ms	0.05 Mb
hookDisplayFooterBefore	1.530 ms	0.05 Mb
hookDisplayFooter	1.135 ms	0.05 Mb
hookDisplayFooterAfter	1.110 ms	0.05 Mb
blockgrouptop	1.566 ms	- Mb
__construct	0.747 ms	- Mb
hookDisplayHeader	0.819 ms	0.01 Mb
leoquicklogin	13.774 ms	0.13 Mb
__construct	3.528 ms	0.07 Mb
hookHeader	1.761 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	3.621 ms	- Mb
hookDisplayNav1	0.024 ms	- Mb
hookDisplayNav2	0.015 ms	- Mb
hookDisplayTop	0.016 ms	- Mb
hookDisplayNavFullWidth	0.021 ms	- Mb
hookDisplayLeftColumn	0.014 ms	- Mb
hookDisplayFooterBefore	0.014 ms	- Mb
hookDisplayFooter	0.012 ms	- Mb
hookDisplayFooterAfter	0.010 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.738 ms	0.04 Mb
leofeature	12.947 ms	0.04 Mb
__construct	1.979 ms	0.02 Mb
hookDisplayHeader	10.934 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.034 ms	- Mb
everpsquotation	4.113 ms	0.04 Mb
__construct	3.483 ms	0.04 Mb
hookHeader	0.630 ms	- Mb
askforquote	3.901 ms	- Mb
__construct	1.963 ms	- Mb
hookHeader	1.938 ms	- Mb
konnect	4.533 ms	0.03 Mb
__construct	2.741 ms	0.03 Mb
hookHeader	1.792 ms	- Mb
ps_facetedsearch	14.217 ms	0.05 Mb
__construct	6.150 ms	0.02 Mb
hookProductSearchProvider	4.918 ms	- Mb
hookDisplayLeftColumn	3.149 ms	0.03 Mb
ps_customersignin	7.256 ms	0.01 Mb
__construct	1.177 ms	0.01 Mb
displayTop	6.079 ms	0.01 Mb
ps_categorytree	12.454 ms	0.35 Mb
__construct	0.925 ms	0.01 Mb
displayLeftColumn	11.529 ms	0.35 Mb
25 module(s)	392.704 ms	3.06 Mb

Accueil

Accueil

Lighting

Décoration d'intérieur

Décoration d'extérieur

devis

Aucun produit disponible pour le moment

LIVRAISON RAPIDE

REMISE SPÉCIALE

Qualité de produits garanti

Politique de retour

SERVICE CLIENTS

L'entreprise

Catégories

Stopwatch SQL - 135 queries

Doubles

Tables stress

ObjectModel instances

Included Files

8 queries	SELECT state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT XX
8 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
5 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
5 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
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 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, p.reference 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_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity<=XX AND sa_XX.out_of_stock IN (XX, 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 c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN ps_stock_available sa_XX_XX ON (p.id_product = sa_XX_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX_XX.id_product_attribute AND sa_XX_XX.id_shop = XX AND sa_XX_XX.id_shop_group = XX ) 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 ((sa_XX.quantity<=XX AND sa_XX_XX.out_of_stock IN (XX, XX))) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY pac.id_attribute
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference 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_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((sa.quantity<=XX AND sa_XX.out_of_stock IN (XX, 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 c.nleft>=XX AND c.nright<=XX 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 ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa_XX ON (p.id_product = sa_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX.id_product_attribute AND sa_XX.id_shop = XX AND sa_XX.id_shop_group = XX ) LEFT JOIN ps_stock_available sa_XX_XX ON (p.id_product = sa_XX_XX.id_product AND IFNULL(pac.id_product_attribute, XX) = sa_XX_XX.id_product_attribute AND sa_XX_XX.id_shop = XX AND sa_XX_XX.id_shop_group = XX ) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((fp.id_feature=XX)) AND ((sa_XX.quantity<=XX AND sa_XX_XX.out_of_stock IN (XX, XX))) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY fp.id_feature_value

Name	Instances	Source
Category	10	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:207 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:207 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:207 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:207 (__construct) [id: 40] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Country	3	/config/config.inc.php:146 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /classes/controller/FrontController.php:1722 (__construct) [id: 208]
ApPageBuilderModel	2	/modules/appagebuilder/appagebuilder.php:2065 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2581 (__construct) [id: ]
Configuration	2	/modules/ps_accounts/src/Adapter/Configuration.php:224 (__construct) [id: 963] /modules/appagebuilder/appagebuilder.php:2268 (__construct) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:559 (__construct) [id: 1]
LeoWidget	2	/modules/leobootstrapmenu/leobootstrapmenu.php:88 (__construct) [id: ] /modules/leobootstrapmenu/leobootstrapmenu.php:88 (__construct) [id: ]
ApPageBuilderProfilesModel	2	/modules/appagebuilder/appagebuilder.php:3357 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2875 (__construct) [id: ]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:684 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:427 (__construct) [id: ] /classes/controller/FrontController.php:497 (__construct) [id: ]
AddressFormat	1	/classes/controller/FrontController.php:1716 (generateAddress) [id: ]
State	1	/classes/controller/FrontController.php:1721 (__construct) [id: 0]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Address	1	/classes/shop/Shop.php:486 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1649 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1646 (__construct) [id: 0]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
97	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=2)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) GROUP BY pac.id_attribute	14.130 ms	6740160	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
108	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("9b202c6d45f56d7fe354f3b0c2679947", "a:1:{s:7:\"filters\";a:8:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilité\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"En stock\";s:3:\"nbr\";i:5;}i:0;a:3:{s:4:\"name\";s:14:\"Non disponible\";s:3:\"nbr\";i:0;s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Sélections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:8:\"En promo\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:15:\"Nouveau produit\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:8:\"Remisés\";s:3:\"nbr\";i:0;}}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:4:\"Prix\";s:3:\"max\";d:0;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"TND\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:\"TND\";s:14:\"currencySymbol\";s:3:\"TND\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";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:3;s:17:\"minFractionDigits\";i:3;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:0;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Catégories\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:2;s:4:\"name\";s:7:\"Couleur\";s:14:\"is_color_group\";b:1;s:6:\"values\";a:23:{i:8;a:5:{s:4:\"name\";s:5:\"Blanc\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffffff\";}i:11;a:5:{s:4:\"name\";s:4:\"Noir\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#434A54\";}i:63;a:5:{s:4:\"name\";s:13:\"TEXTURE MB033\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:72;a:5:{s:4:\"name\";s:4:\"2003\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:73;a:5:{s:4:\"name\";s:4:\"2023\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:74;a:5:{s:4:\"name\";s:4:\"2039\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:75;a:5:{s:4:\"name\";s:4:\"2403\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:76;a:5:{s:4:\"name\";s:4:\"2419\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:77;a:5:{s:4:\"name\";s:4:\"4023\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffffff\";}i:78;a:5:{s:4:\"name\";s:4:\"4047\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:79;a:5:{s:4:\"name\";s:4:\"4048\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:80;a:5:{s:4:\"name\";s:4:\"4051\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:81;a:5:{s:4:\"name\";s:4:\"4067\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:82;a:5:{s:4:\"name\";s:4:\"4071\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:83;a:5:{s:4:\"name\";s:4:\"4075\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:84;a:5:{s:4:\"name\";s:4:\"4079\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:85;a:5:{s:4:\"name\";s:4:\"4080\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:89;a:5:{s:4:\"name\";s:4:\"8027\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:96;a:5:{s:4:\"name\";s:10:\"GOLD ROSE \";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:97;a:5:{s:4:\"name\";s:5:\"CHROM\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:104;a:5:{s:4:\"name\";s:10:\"MARON CAFE\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:0:\"\";}i:122;a:5:{s:4:\"name\";s:10:\"VERT FONCE\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#002815\";}i:160;a:5:{s:4:\"name\";s:13:\"CRISTAL CLAIR\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#ffffff\";}}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:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"État\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:4:\"Neuf\";s:3:\"nbr\";i:0;}s:4:\"used\";a:2:{s:4:\"name\";s:8:\"Utilisé\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:14:\"Reconditionné\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:0:{}}}")	9.856 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:209 /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (insertIntoCache) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
125	SELECT SQL_NO_CACHE 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 = 1) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	5.860 ms	33	Yes	Yes	/classes/Category.php:782 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:281 (__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/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6965205172e067_57638876) /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/at_lotionlayouts_layout_left_column_tpl/24/a4/14/24a414324e04fbc187a594938bedce0016c6ece0_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516f3e79_25639306) /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/at_lotionlayouts_layout_left_column_tpl/99/a1/55/99a155e82017766f0a7eedda55a698a6d781e229_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516dc000_23598845) /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/at_lotionlayouts_layout_left_column_tpl/83/ce/b1/83ceb19aad504160d1bc1c589c1bd54912fc056d_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516a8709_34211755) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	4.596 ms	354	Yes	Yes	/classes/Hook.php:1183 /classes/Hook.php:699 (getAllHookRegistrations) /classes/Hook.php:803 (getHookModuleExecList) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
105	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) 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 ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159))) GROUP BY pac.id_attribute	3.882 ms	162	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
41	SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 10) AND (b.`id_shop` = 1) LIMIT 1	3.688 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:282 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:207 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:206 (array_map) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
122	SELECT SQL_NO_CACHE * FROM ps_leoslideshow_groups gr WHERE gr.id_shop = 1 AND gr.hook = "displayNavFullWidth" AND gr.`active` = 1 ORDER BY gr.id_leoslideshow_groups LIMIT 1	3.241 ms	1			/modules/leoslideshow/classes/LeoSlideshowGroup.php:175 /modules/leoslideshow/leoslideshow.php:1970 (getActiveGroupByHook) /modules/leoslideshow/leoslideshow.php:2200 (_prepareHook) /modules/leoslideshow/leoslideshow.php:2250 (_processHook) /classes/Hook.php:993 (hookDisplayNavFullWidth) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:124 (__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/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520518e4a80_07081837) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:222 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6965205172e067_57638876) /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/at_lotionlayouts_layout_left_column_tpl/24/a4/14/24a414324e04fbc187a594938bedce0016c6ece0_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516f3e79_25639306) /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/at_lotionlayouts_layout_left_column_tpl/99/a1/55/99a155e82017766f0a7eedda55a698a6d781e229_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516dc000_23598845) /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/at_lotionlayouts_layout_left_column_tpl/83/ce/b1/83ceb19aad504160d1bc1c589c1bd54912fc056d_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516a8709_34211755) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	3.013 ms	2640			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
117	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.990 ms	0			/classes/Hook.php:1242 /classes/Hook.php:225 (getAllHookIds) /modules/appagebuilder/classes/shortcodes/ApModule.php:200 (getIdByName) /modules/appagebuilder/classes/shortcodes/ApModule.php:179 (execModuleHook) /modules/appagebuilder/classes/shortcodes.php:515 (prepareFontContent) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/shortcodes.php:388 (doShortcode) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/shortcodes.php:388 (doShortcode) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/ApShortCodesBuilder.php:366 (doShortcode) /modules/appagebuilder/classes/ApPageBuilderModel.php:171 (parse) /modules/appagebuilder/appagebuilder.php:2590 (parseData) /modules/appagebuilder/appagebuilder.php:2563 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:118 (__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/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520518e4a80_07081837) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:222 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6965205172e067_57638876) /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/at_lotionlayouts_layout_left_column_tpl/24/a4/14/24a414324e04fbc187a594938bedce0016c6ece0_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516f3e79_25639306) /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/at_lotionlayouts_layout_left_column_tpl/99/a1/55/99a155e82017766f0a7eedda55a698a6d781e229_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516dc000_23598845) /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/at_lotionlayouts_layout_left_column_tpl/83/ce/b1/83ceb19aad504160d1bc1c589c1bd54912fc056d_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516a8709_34211755) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) GROUP BY p.id_manufacturer	2.934 ms	162	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
102	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) GROUP BY p.condition	2.853 ms	162	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
99	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 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 ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=2)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159))) GROUP BY fp.id_feature_value	2.802 ms	162	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
110	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "appagebuilder" LIMIT 1	2.771 ms	1			/classes/module/Module.php:2633 /classes/module/Module.php:2105 (getModuleIdByName) /classes/Hook.php:999 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:54 (__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/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520518e4a80_07081837) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:222 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6965205172e067_57638876) /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/at_lotionlayouts_layout_left_column_tpl/24/a4/14/24a414324e04fbc187a594938bedce0016c6ece0_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516f3e79_25639306) /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/at_lotionlayouts_layout_left_column_tpl/99/a1/55/99a155e82017766f0a7eedda55a698a6d781e229_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516dc000_23598845) /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/at_lotionlayouts_layout_left_column_tpl/83/ce/b1/83ceb19aad504160d1bc1c589c1bd54912fc056d_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516a8709_34211755) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159))) GROUP BY pac.id_attribute	2.707 ms	56	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 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 ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=1)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159))) GROUP BY fp.id_feature_value	2.335 ms	162	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:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 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_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<65 GROUP BY cp.id_category	2.247 ms	252	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=1)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159))) GROUP BY pac.id_attribute	1.942 ms	162	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
40	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.933 ms	4	Yes	Yes	/classes/Category.php:913 /controllers/front/listing/CategoryController.php:223 (getSubCategories) /controllers/front/listing/CategoryController.php:117 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((p.on_sale=1)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159)))	1.865 ms	162			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 208) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2026-01-16 21:08:30' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-01-16 21:08:30' <= sp.to) ) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((sp.reduction>0)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2))) AND ((pac_2.id_attribute IN (87, 159)))	1.848 ms	162			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
89	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND p.date_add>'2025-12-18 00:00:00'	1.781 ms	162			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
86	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (87, 159)))	1.585 ms	162			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC	1.570 ms	140	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:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`	1.530 ms	1049			/classes/Hook.php:1242 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:812 (getIdByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	1.505 ms	1049			/classes/Hook.php:1282 /classes/Hook.php:774 (getHookStatusByName) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
120	SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1	1.478 ms	1			/classes/module/Module.php:2633 /classes/module/Module.php:2105 (getModuleIdByName) /modules/appagebuilder/classes/shortcodes/ApModule.php:178 (isEnabled) /modules/appagebuilder/classes/shortcodes.php:515 (prepareFontContent) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/shortcodes.php:388 (doShortcode) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/shortcodes.php:388 (doShortcode) /modules/appagebuilder/classes/ApShortCodesBuilder.php:77 (fontContent) :undefined (doShortcodeTag) /modules/appagebuilder/classes/ApShortCodesBuilder.php:55 (preg_replace_callback) /modules/appagebuilder/classes/ApShortCodesBuilder.php:366 (doShortcode) /modules/appagebuilder/classes/ApPageBuilderModel.php:171 (parse) /modules/appagebuilder/appagebuilder.php:2590 (parseData) /modules/appagebuilder/appagebuilder.php:2563 (getWidgetVariables) /classes/Hook.php:1004 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:118 (__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/at_lotionlayouts_layout_left_column_tpl/dd/77/6c/dd776cd6ba3eebf9ff1d039ef759cf05bd98d590_2.file.header.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520518e4a80_07081837) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:222 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6965205172e067_57638876) /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/at_lotionlayouts_layout_left_column_tpl/24/a4/14/24a414324e04fbc187a594938bedce0016c6ece0_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516f3e79_25639306) /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/at_lotionlayouts_layout_left_column_tpl/99/a1/55/99a155e82017766f0a7eedda55a698a6d781e229_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516dc000_23598845) /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/at_lotionlayouts_layout_left_column_tpl/83/ce/b1/83ceb19aad504160d1bc1c589c1bd54912fc056d_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516a8709_34211755) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (87, 159)))	1.418 ms	162			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM ps_product p INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65	1.389 ms	18			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:774 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
85	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159)))	1.376 ms	162			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:787 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	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, p.reference FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) GROUP BY p.id_product ORDER BY p.reference ASC, p.id_product DESC	1.259 ms	2268	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:188 (getProductByFilters) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	1.254 ms	1	Yes		/classes/Manufacturer.php:201 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC	1.237 ms	140	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	1.235 ms	27	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
124	SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 23 AND `id_shop` = 1 LIMIT 1	1.231 ms	1			/classes/module/Module.php:2106 /classes/Hook.php:999 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:948 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:281 (__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/at_lotionlayouts_layout_left_column_tpl/c6/c1/e2/c6c1e2b0b23bb5400e3a695cd9a66f37f35b92da_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6965205172e067_57638876) /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/at_lotionlayouts_layout_left_column_tpl/24/a4/14/24a414324e04fbc187a594938bedce0016c6ece0_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516f3e79_25639306) /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/at_lotionlayouts_layout_left_column_tpl/99/a1/55/99a155e82017766f0a7eedda55a698a6d781e229_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516dc000_23598845) /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/at_lotionlayouts_layout_left_column_tpl/83/ce/b1/83ceb19aad504160d1bc1c589c1bd54912fc056d_2.file.category.tpl.php:39 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_696520516a8709_34211755) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:715 (fetch) /classes/controller/FrontController.php:697 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 208) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (87, 159))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=65	1.151 ms	18			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	1.069 ms	14	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:122 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:634 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:133 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
19	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	1.049 ms	156	Yes		/classes/Dispatcher.php:633 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
23	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.846 ms	90			/classes/module/Module.php:340 /modules/mbeshipping/mbeshipping.php:98 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1232 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1211 (coreLoadModule) /classes/Hook.php:913 (getInstanceByName) /classes/Dispatcher.php:507 (exec) /index.php:28 (dispatch)
21	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	0.792 ms	90			/classes/module/Module.php:340 /modules/psassistant/psassistant.php:73 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1232 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1211 (coreLoadModule) /classes/Hook.php:913 (getInstanceByName) /classes/Dispatcher.php:351 (exec) /index.php:28 (dispatch)
71	SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang FROM ps_appagebuilder p LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1) LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder) WHERE pl.id_lang=1 AND ps.id_shop=1 AND p.id_appagebuilder_positions IN (34,48,28,29) ORDER BY p.id_appagebuilder	0.760 ms	99			/modules/appagebuilder/classes/ApPageBuilderModel.php:302 /modules/appagebuilder/appagebuilder.php:2066 (getAllItems) /classes/Hook.php:993 (hookdisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:928 (callHookOn) /classes/controller/FrontController.php:577 (exec) /controllers/front/listing/CategoryController.php:126 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php