Nouvelle Switch 2 : le jeu passe à la vitesse supérieure...🎮⚡

Apple à St-Barth : vivez connectés, même au paradis !🌴

Protégez votre maison à St-Barth - Ring garde l’œil 🏝️🔒, où que vous soyez

Nouvelle Switch 2 : le jeu passe à la vitesse supérieure...🎮⚡

Apple à St-Barth : vivez connectés, même au paradis !🌴

Protégez votre maison à St-Barth - Ring garde l’œil 🏝️🔒, où que vous soyez

Nouvelle Switch 2 : le jeu passe à la vitesse supérieure...🎮⚡

Apple à St-Barth : vivez connectés, même au paradis !🌴

Ring garde l’œil 🏝️🔒, où que vous soyez

Protégez votre maison à St-Barth

Montres

Affichage 1-6 de 6 article(s)

Promotion

GARMIN

MONTRE FEMME LILY CLASSIC SMARTWATCH CUIR NOIR ET OR

269,00 €

215,20 €

Promotion

GARMIN

MONTRE ENFANT CONNECTEE VIVOFIT JR 3 FITNESS LEOPARD PECHE

119,00 €

95,20 €

Indisponible

APPLE

APPLE WATCH ULTRA 2 GPS + CELLULAR INDIGO ALPINE LOOP M 49MM TITANE

899,00 €

Indisponible

APPLE

APPLE WATCH ULTRA 2 GPS + CELLULAR INDIGO ALPINE LOOP S 49MM TITANE

899,00 €

Indisponible

APPLE

APPLE WATCH ULTRA 2 GPS + CELLULAR BLUE ALPINE LOOP M 49MM TITANIUM

899,00 €

APPLE

APPLE WATCH ULTRA 2 GPS + CELLULAR, 49MM TITANIUM CASE WITH BLUE ALPI

899,00 €

Service Client & SAV

Réactif et aux petits soins !

Retours

Simples et faciles sous 14 jours !

Solutions de paiement

Faites-vous plaisir en 3X ou 4X

Retrait Drive ou Casiers

Rapidité et discrétion, 24/24

Ce site Web utilise ses propres cookies et ceux de tiers pour améliorer nos services et vous montrer des publicités liées à vos préférences en analysant vos habitudes de navigation. Pour donner votre consentement à son utilisation, appuyez sur le bouton Accepter.

Politique de cookies Personnaliser les cookies

Cookies fonctionnels

Non

Oui

Description et des cookies

Les cookies fonctionnels sont strictement nécessaires pour fournir les services de la boutique, ainsi que pour son bon fonctionnement, il n'est donc pas possible de refuser leur utilisation. Ils permettent à l'utilisateur de naviguer sur notre site web et d'utiliser les différentes options ou services qui y sont proposés.


PHP_SESSID	stbarthelectronique.com	Le cookie PHPSESSID est natif de PHP et permet aux sites web de stocker des données d'état sérialisées. Sur le site web, il est utilisé pour établir une session d'utilisateur et pour transmettre des données d'état par le biais d'un cookie temporaire, communément appelé cookie de session. Ces cookies ne resteront sur votre ordinateur que jusqu'à ce que vous fermiez votre navigateur.	Session
PrestaShop-#	stbarthelectronique.com	Il s'agit d'un cookie utilisé par Prestashop pour stocker des informations et garder la session de l'utilisateur ouverte. Il stocke des informations telles que la devise, la langue, l'identifiant du client, entre autres données nécessaires au bon fonctionnement de la boutique.	480 heures

Cookies publicitaires

Non

Oui

Description

Il s'agit de cookies qui collectent des informations sur les publicités montrées aux utilisateurs du site web. Elles peuvent être anonymes, si elles ne collectent que des informations sur les espaces publicitaires affichés sans identifier l'utilisateur, ou personnalisées, si elles collectent des informations personnelles sur l'utilisateur de la boutique par un tiers, pour la personnalisation de ces espaces publicitaires.

Cookies d'analyse

Non

Oui

Description

Collecter des informations sur la navigation de l'utilisateur dans la boutique, généralement de manière anonyme, bien que parfois elles permettent également d'identifier l'utilisateur de manière unique et sans équivoque afin d'obtenir des rapports sur les intérêts de l'utilisateur pour les produits ou services proposés par la boutique.

Cookies de performance

Non

Oui

Description

Ils sont utilisés pour améliorer l'expérience de navigation et optimiser le fonctionnement de la boutique.

Autres cookies

Non

Oui

Description

Il s'agit de cookies sans finalité claire ou de ceux que nous sommes encore en train de classifier.

Inscrivez-vous à notre newsletter et rejoignez la communauté St-Barth Électronique ! Bénéficiez d'un accès exclusif en avant-première à nos derniers produits high-tech, à des conseils pratiques, et à des offres exclusives sur vos marques préférées : Apple, Samsung, Sony et bien d'autres encore !

Load Time	740.479 ms
Querying Time	100 ms
Queries	349
Memory Peak Usage	21.6 Mb
Included Files	1505 files - 18.93 Mb
PrestaShop Cache	- Mb
Global vars	1.37 Mb
- global $_MODULES	1268k
- global $_MODULE	85k
- global $_SERVER	15k
- global $config	5k
- global $ls_filter	5k
- global $smarty	4k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $ls_action	3k
- global $ls_style	3k
- global $ls_script	3k
- global $_COOKIE	2k
- global $_ENV	1k

PrestaShop Version	8.2.0
PHP Version	8.2.29
MySQL Version	10.11.13-MariaDB-0ubuntu0.24.04.1
Memory Limit	4196M
Max Execution Time	4000s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	10.933 ms	10.933 ms	2.98 Mb	3.0 Mb
__construct	0.015 ms	10.948 ms	- Mb	3.0 Mb
init	12.312 ms	23.260 ms	0.92 Mb	3.9 Mb
checkAccess	0.002 ms	23.262 ms	- Mb	3.9 Mb
setMedia	2.928 ms	26.190 ms	0.13 Mb	4.2 Mb
postProcess	0.001 ms	26.191 ms	- Mb	4.2 Mb
initHeader	0.002 ms	26.193 ms	- Mb	4.2 Mb
initContent	134.256 ms	160.449 ms	4.93 Mb	9.3 Mb
initFooter	0.002 ms	160.451 ms	- Mb	9.3 Mb
display	580.028 ms	740.479 ms	11.31 Mb	21.6 Mb

Hook	Time	Memory Usage
OverrideLayoutTemplate	550.939 ms	8.12 Mb
=> creativeelements	0.006 ms	- Mb
=> creativeelements	550.930 ms	8.12 Mb
=> creativeelements	0.003 ms	- Mb
DisplayHeader	26.721 ms	1.01 Mb
=> lgcookieslaw	1.990 ms	0.03 Mb
=> creativeelements	7.455 ms	0.31 Mb
=> ps_shoppingcart	0.124 ms	- Mb
=> ps_searchbar	0.413 ms	- Mb
=> ps_imageslider	0.201 ms	- Mb
=> productcomments	0.203 ms	- Mb
=> ps_facebook	2.518 ms	0.09 Mb
=> ps_googleanalytics	0.034 ms	- Mb
=> psxmarketingwithgoogle	0.354 ms	- Mb
=> sendinblue	0.395 ms	0.02 Mb
=> securitypro	0.145 ms	0.01 Mb
=> ambjolisearch	4.326 ms	0.25 Mb
=> productquotation	1.623 ms	0.07 Mb
=> prestatilldrive	1.376 ms	- Mb
=> himobilevalidator	2.650 ms	0.15 Mb
=> layerslider	2.414 ms	0.05 Mb
=> addvance	0.260 ms	- Mb
=> cdc_googletagmanager	0.235 ms	0.01 Mb
=> preorder	0.005 ms	- Mb
DisplayAfterTitleTag	9.892 ms	0.80 Mb
=> psxdesign	0.122 ms	0.01 Mb
=> lgcookieslaw	0.728 ms	0.02 Mb
=> cdc_googletagmanager	9.042 ms	0.77 Mb
ActionDispatcherBefore	6.285 ms	0.36 Mb
=> psassistant	0.007 ms	- Mb
=> psxdesign	0.173 ms	0.01 Mb
=> ps_eventbus	6.105 ms	0.35 Mb
DisplayBeforeBodyClosingTag	5.966 ms	0.19 Mb
=> ps_googleanalytics	0.765 ms	0.03 Mb
=> statsdata	4.496 ms	0.15 Mb
=> lgcookieslaw	0.413 ms	- Mb
=> ambjolisearch	0.279 ms	0.01 Mb
=> cdc_googletagmanager	0.013 ms	- Mb
DisplayFooter	3.510 ms	0.11 Mb
=> lgcookieslaw	3.510 ms	0.11 Mb
ActionObjectAddAfter	1.568 ms	0.09 Mb
=> dgcontenttranslation	0.830 ms	0.06 Mb
=> dgtranslationall	0.738 ms	0.03 Mb
ProductSearchProvider	1.208 ms	- Mb
=> ambjolisearch	0.030 ms	- Mb
=> ps_facetedsearch	1.178 ms	- Mb
ActionDispatcher	1.021 ms	- Mb
=> psassistant	0.009 ms	- Mb
=> securitypro	1.012 ms	- Mb
ActionFrontControllerSetMedia	1.010 ms	0.05 Mb
=> blockreassurance	0.252 ms	0.02 Mb
=> blockwishlist	0.340 ms	0.03 Mb
=> ps_emailsubscription	0.080 ms	- Mb
=> ps_socialfollow	0.095 ms	- Mb
=> ps_facebook	0.091 ms	- Mb
=> psxdesign	0.061 ms	- Mb
=> klaviyopsautomation	0.008 ms	- Mb
=> sherlocks	0.008 ms	- Mb
=> addvance	0.010 ms	- Mb
=> teamwantwebpavif	0.065 ms	- Mb
ActionOutputHTMLBefore	0.886 ms	0.01 Mb
=> layerslider	0.532 ms	- Mb
=> teamwantwebpavif	0.354 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.580 ms	0.01 Mb
=> blockreassurance	0.007 ms	- Mb
=> lgcookieslaw	0.444 ms	0.01 Mb
=> cdc_googletagmanager	0.129 ms	0.01 Mb
FilterProductSearch	0.267 ms	0.01 Mb
=> creativeelements	0.267 ms	0.01 Mb
DisplayProductPriceBlock	0.043 ms	0.01 Mb
=> cdc_googletagmanager	0.005 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> cdc_googletagmanager	0.003 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> cdc_googletagmanager	0.002 ms	- Mb
ActionFrontControllerInitAfter	0.031 ms	- Mb
=> creativeelements	0.028 ms	- Mb
=> klaviyopsautomation	0.003 ms	- Mb
ActionPresentCart	0.029 ms	- Mb
=> addvance	0.029 ms	- Mb
ModuleRoutes	0.008 ms	- Mb
=> klaviyopsautomation	0.005 ms	- Mb
=> productquotation	0.003 ms	- Mb
DisplayOverrideTemplate	0.003 ms	- Mb
=> creativeelements	0.003 ms	- Mb
18 hook(s)	609.966 ms	10.79 Mb

Module	Time	Memory Usage
klaviyopsautomation	0.693 ms	- Mb
__construct	0.671 ms	- Mb
hookModuleRoutes	0.008 ms	- Mb
hookActionFrontControllerInitAfter	0.005 ms	- Mb
hookActionFrontControllerSetMedia	0.009 ms	- Mb
productquotation	2.726 ms	0.11 Mb
__construct	1.094 ms	0.04 Mb
hookModuleRoutes	0.005 ms	- Mb
hookDisplayHeader	1.627 ms	0.07 Mb
psassistant	0.543 ms	0.02 Mb
__construct	0.522 ms	0.02 Mb
hookActionDispatcherBefore	0.009 ms	- Mb
hookActionDispatcher	0.012 ms	- Mb
psxdesign	1.299 ms	0.03 Mb
__construct	0.936 ms	0.01 Mb
hookActionDispatcherBefore	0.175 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.063 ms	- Mb
hookDisplayAfterTitleTag	0.125 ms	0.01 Mb
ps_eventbus	6.731 ms	0.36 Mb
__construct	0.622 ms	0.02 Mb
hookActionDispatcherBefore	6.109 ms	0.35 Mb
ps_accounts	0.702 ms	0.01 Mb
__construct	0.702 ms	0.01 Mb
securitypro	1.737 ms	0.17 Mb
__construct	0.575 ms	0.16 Mb
hookActionDispatcher	1.015 ms	- Mb
hookDisplayHeader	0.147 ms	0.01 Mb
creativeelements	559.010 ms	8.57 Mb
__construct	0.297 ms	0.12 Mb
hookActionFrontControllerInitAfter	0.031 ms	- Mb
hookOverrideLayoutTemplate	0.008 ms	- Mb
hookDisplayHeader	7.459 ms	0.32 Mb
hookFilterProductSearch	0.270 ms	0.01 Mb
hookDisplayOverrideTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	550.934 ms	8.12 Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
blockreassurance	0.395 ms	0.04 Mb
__construct	0.131 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.254 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.010 ms	- Mb
blockwishlist	0.417 ms	0.03 Mb
__construct	0.075 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.342 ms	0.03 Mb
ps_emailsubscription	0.161 ms	0.01 Mb
__construct	0.079 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.082 ms	- Mb
ps_socialfollow	0.162 ms	0.01 Mb
__construct	0.065 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.097 ms	- Mb
ps_facebook	2.921 ms	0.03 Mb
__construct	0.307 ms	- Mb
hookActionFrontControllerSetMedia	0.093 ms	- Mb
hookDisplayHeader	2.521 ms	0.09 Mb
sherlocks	0.269 ms	0.07 Mb
__construct	0.259 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.010 ms	- Mb
addvance	0.496 ms	- Mb
__construct	0.188 ms	- Mb
hookActionFrontControllerSetMedia	0.012 ms	- Mb
hookActionPresentCart	0.032 ms	- Mb
hookDisplayHeader	0.264 ms	- Mb
teamwantwebpavif	0.531 ms	0.01 Mb
__construct	0.108 ms	- Mb
hookActionFrontControllerSetMedia	0.067 ms	- Mb
hookActionOutputHTMLBefore	0.356 ms	0.01 Mb
lgcookieslaw	7.597 ms	0.32 Mb
__construct	0.498 ms	0.15 Mb
hookDisplayHeader	1.993 ms	0.03 Mb
hookDisplayFooter	3.514 ms	0.11 Mb
hookDisplayAfterTitleTag	0.730 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.446 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	0.416 ms	- Mb
ps_shoppingcart	0.221 ms	0.01 Mb
__construct	0.095 ms	0.01 Mb
hookDisplayHeader	0.126 ms	- Mb
ps_searchbar	0.488 ms	0.01 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayHeader	0.415 ms	- Mb
ps_imageslider	0.280 ms	0.01 Mb
__construct	0.077 ms	0.01 Mb
hookDisplayHeader	0.203 ms	- Mb
productcomments	0.272 ms	0.01 Mb
__construct	0.067 ms	0.01 Mb
hookDisplayHeader	0.205 ms	- Mb
ps_googleanalytics	0.896 ms	0.04 Mb
__construct	0.092 ms	0.01 Mb
hookDisplayHeader	0.036 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.768 ms	0.03 Mb
psxmarketingwithgoogle	0.531 ms	- Mb
__construct	0.174 ms	- Mb
hookDisplayHeader	0.357 ms	- Mb
sendinblue	0.544 ms	0.04 Mb
__construct	0.147 ms	0.02 Mb
hookDisplayHeader	0.397 ms	0.02 Mb
ambjolisearch	5.031 ms	0.30 Mb
__construct	0.385 ms	0.03 Mb
hookDisplayHeader	4.331 ms	0.26 Mb
hookProductSearchProvider	0.033 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.282 ms	0.01 Mb
prestatilldrive	1.661 ms	0.18 Mb
__construct	0.282 ms	0.17 Mb
hookDisplayHeader	1.379 ms	0.01 Mb
himobilevalidator	2.890 ms	0.25 Mb
__construct	0.236 ms	0.10 Mb
hookDisplayHeader	2.654 ms	0.15 Mb
layerslider	3.035 ms	0.06 Mb
__construct	0.082 ms	0.01 Mb
hookDisplayHeader	2.418 ms	0.05 Mb
hookActionOutputHTMLBefore	0.535 ms	- Mb
cdc_googletagmanager	10.102 ms	0.81 Mb
__construct	0.588 ms	0.01 Mb
hookDisplayHeader	0.238 ms	0.01 Mb
hookDisplayProductPriceBlock	0.008 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.004 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.005 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayAfterTitleTag	9.049 ms	0.77 Mb
hookDisplayAfterBodyOpeningTag	0.131 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	0.015 ms	- Mb
preorder	0.077 ms	0.01 Mb
__construct	0.069 ms	0.01 Mb
hookDisplayHeader	0.008 ms	- Mb
ps_facetedsearch	1.704 ms	0.01 Mb
__construct	0.522 ms	0.01 Mb
hookProductSearchProvider	1.182 ms	- Mb
xmc_sbsfunctions	0.128 ms	0.01 Mb
__construct	0.128 ms	0.01 Mb
psgdpr	0.260 ms	0.02 Mb
__construct	0.260 ms	0.02 Mb
ps_mainmenu	0.128 ms	0.01 Mb
__construct	0.128 ms	0.01 Mb
statsdata	4.586 ms	0.15 Mb
__construct	0.088 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	4.498 ms	0.15 Mb
dgcontenttranslation	1.156 ms	0.07 Mb
__construct	0.323 ms	0.01 Mb
hookActionObjectAddAfter	0.833 ms	0.07 Mb
dgtranslationall	0.984 ms	0.04 Mb
__construct	0.243 ms	0.01 Mb
hookActionObjectAddAfter	0.741 ms	0.03 Mb
37 module(s)	621.366 ms	11.75 Mb

Montres

Service Client & SAV

Retours

Solutions de paiement

Retrait Drive ou Casiers

À propos

Informations légales

St-Barth Électronique

Newsletter

Stopwatch SQL - 349 queries

Doubles

Tables stress

ObjectModel instances

Included Files

#	Query	Time (ms)	Rows	Filesort	Group By	Location
141	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=80)) AND ((fp_1.id_feature_value=37)) GROUP BY fp.id_feature_value	6.485 ms	13648	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
135	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 = 177) 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_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197	2.997 ms	268			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	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`	2.282 ms	288	Yes	Yes	/classes/Hook.php:1267 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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`)	2.075 ms	1138			/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)
171	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("e8f2fa68cb00214f068c8bb9f3a3f387", "a:1:{s:7:\"filters\";a:19:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Catégories\";s:6:\"values\";a:1:{i:155;a:2:{s:4:\"name\";s:14:\"Montres Garmin\";s:3:\"nbr\";s:1:\"2\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:2:{i:32;a:2:{s:4:\"name\";s:5:\"APPLE\";s:3:\"nbr\";s:1:\"4\";}i:86;a:2:{s:4:\"name\";s:6:\"GARMIN\";s:3:\"nbr\";s:1:\"2\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;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:3;}i:0;a:2:{s:4:\"name\";s:14:\"Non disponible\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;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:899;s:3:\"min\";d:95;s:4:\"unit\";s:3:\"€\";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:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";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:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:6;s:5:\"value\";N;}i:4;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:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:8:\"En solde\";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:12:\"En promotion\";s:3:\"nbr\";i:2;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"63\";s:6:\"values\";a:1:{i:1551;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"iOS et Android\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:15:\"Compatible avec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"80\";s:6:\"values\";a:28:{i:1170;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Anthracite\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:7688;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"Ardoise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:309;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Argent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:40;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Blanc\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1262;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:20:\"Blanc,Titane naturel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:310;a:4:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:4:\"Bleu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1263;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:19:\"Bleu,Titane naturel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:2911;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Bronze\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1019;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Doré\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:312;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Graphite\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:313;a:4:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:4:\"Gris\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3099;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"Gris sidéral\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3336;a:4:{s:3:\"nbr\";s:2:\"12\";s:4:\"name\";s:18:\"Lumière stellaire\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:315;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:6:\"Minuit\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1281;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:11:\"Métallisé\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:316;a:4:{s:3:\"nbr\";s:2:\"28\";s:4:\"name\";s:4:\"Noir\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3338;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Orange\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:1267;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:12:\"Orange,Beige\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:318;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:4:\"Rose\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:3281;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:9:\"Rose gold\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:457;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:5:\"Rouge\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:7690;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"Titane ardoise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1282;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"Titane naturel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1085;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:9:\"Turquoise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:321;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:4:\"Vert\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1269;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:19:\"Vert,Titane naturel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1268;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Vert alpin\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:322;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:6:\"Violet\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Couleur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"48\";s:6:\"values\";a:1:{i:897;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"64 Go\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:21:\"Capacité de stockage\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:8;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:1:{i:1185;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:9:\"Par piles\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:19:\"Source Alimentation\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"24\";s:6:\"values\";a:1:{i:555;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:3:\"Oui\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:22:\"Appels via smartphones\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"30\";s:6:\"values\";a:3:{i:1655;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"1 an et plus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1527;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:7:\"5 jours\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1215;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:9:\"36 heures\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:9:\"Autonomie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"71\";s:6:\"values\";a:3:{i:37;a:5:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:9:\"Bluetooth\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:7682;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:3:\"GPS\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:768;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:4:\"Wifi\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:22:\"Connectivité sans fil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:12;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"128\";s:6:\"values\";a:1:{i:61;a:4:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:3:\"Oui\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Etanche\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"215\";s:6:\"values\";a:6:{i:1359;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"Acier inoxydable\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1195;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Cuir\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:964;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"Nylon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1156;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Silicone\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1273;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:6:\"Titane\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:7706;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"Verre acrylique\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Matière\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:14;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"365\";s:6:\"values\";a:1:{i:7735;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"0.8\"\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:27:\"Taille de l\'écran (pouces)\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:15;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"367\";s:6:\"values\";a:3:{i:7740;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"34 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:7607;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"40 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1233;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"49 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Taille du boitier\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:16;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"368\";s:6:\"values\";a:3:{i:1234;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 mm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1235;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:1:\"M\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1236;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:1:\"S\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:18:\"Taille du bracelet\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"405\";s:6:\"values\";a:3:{i:33;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"LCD\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1242;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:12:\"Rétina OLED\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:682;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:7:\"Tactile\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:13:\"Type d\'écran\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:18;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:3:\"416\";s:6:\"values\";a:1:{i:1245;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:37:\"Câble charge magnétique Apple Watch\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:18:\"Type de connecteur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	1.770 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:209 /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (insertIntoCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
343	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('38713', '', 'stbarthelectronique.com/fr/144-amplificateur-marine?q=Couleur-Bleu%2CTitane+naturel-Dor%C3%A9-Orange%2FConnectivit%C3%A9+sans+fil-Bluetooth', '', '2025-11-06 09:24:58')	1.705 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1077 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/child_classic_home_stbarthelectronique_com_public_html_modules_creativeelements_views_templates_front_theme_layouts_layout_header_footer_tpl/0e/d4/9f/0ed49fda3d3847b48857a7ce2273d6f6a6571600_2.file.layout-header-footer.tpl.php:275 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/child_classic_home_stbarthelectronique_com_public_html_modules_creativeelements_views_templates_front_theme_layouts_layout_header_footer_tpl/0e/d4/9f/0ed49fda3d3847b48857a7ce2273d6f6a6571600_2.file.layout-header-footer.tpl.php:89 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_690c67783977e7_61882112) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/child_classic_home_stbarthelectronique_com_public_html_modules_creativeelements_views_templates_front_theme_layouts_layout_header_footer_tpl/3e/d6/ec/3ed6ecef248d55f0cba91154d9f35bdd72bc3fde_2.file.category.tpl.php:50 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_690c6778378c66_18645816) /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/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
126	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position DESC, p.id_product DESC	1.486 ms	287296	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
152	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=71)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) GROUP BY fp.id_feature_value	1.286 ms	1072	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
128	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` 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 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	1.229 ms	328	Yes		/classes/Category.php:710 /modules/ps_facetedsearch/src/Filters/Block.php:979 (getAllCategoriesName) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
140	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 63 ORDER BY vl.`value` ASC	1.129 ms	320	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
187	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.122 ms	633			/classes/Hook.php:452 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5691 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
156	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=215)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	1.110 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
132	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock=0)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37))	1.109 ms	34304			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
139	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=63)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	1.078 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
131	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) GROUP BY p.id_manufacturer	1.032 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
133	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37))	1.022 ms	34304			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
129	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>172 AND c.nright<197 GROUP BY cp.id_category	1.013 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
150	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=30)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.988 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
186	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	0.977 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5691 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
137	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND p.date_add>'2025-10-18 00:00:00'	0.972 ms	17152			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
154	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=128)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.968 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
166	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=405)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.956 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
136	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((p.on_sale=1)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37))	0.947 ms	17152			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
162	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=367)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.938 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
134	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 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_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37))	0.934 ms	34304			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	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	0.928 ms	482	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
157	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 215 ORDER BY vl.`value` ASC	0.916 ms	247	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
143	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=48)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.909 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
168	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=416)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.904 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
117	SELECT SQL_NO_CACHE cl.,c., cl.`name` country, z.`name` zone FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1) LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`) WHERE 1 AND c.active = 1 ORDER BY cl.name ASC	0.884 ms	241	Yes		/classes/Country.php:143 /modules/himobilevalidator/himobilevalidator.php:425 (getCountries) /classes/Hook.php:1077 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /classes/controller/FrontController.php:633 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
138	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 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, 177) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-11-06 09:24:58' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-11-06 09:24:58' <= sp.to) ) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37))	0.854 ms	17152			/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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
164	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=368)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.834 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
160	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=365)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.807 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=23)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.800 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
148	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=24)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.796 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
145	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=12)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.793 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
159	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=287)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.727 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps_hook` h WHERE (h.active = 1)	0.719 ms	1093			/classes/Hook.php:1366 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
121	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	0.696 ms	169	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
158	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1263, 1019, 3338))) AND ((fp_1.id_feature_value=37)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=172 AND c.nright<=197 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN ps_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=271)) AND ((fp_1.id_feature_value IN (1263, 1019, 3338))) AND ((fp_2.id_feature_value=37)) GROUP BY fp.id_feature_value	0.678 ms	17152	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:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:135 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

22 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `ps_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
16 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value=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_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN ps_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) GROUP BY fp.id_feature_value
9 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
7 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
7 queries	SELECT `id_module` FROM `ps_module` WHERE `name` = "ps_accounts" LIMIT XX
7 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
6 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_accounts" AND ms.`id_shop` IN (XX) LIMIT XX
6 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
6 queries	SELECT `date`, `qte` FROM `ps_xmc_products_in_transit` WHERE `product_id` = XX AND `attribute_id` = XX ORDER BY `date` ASC LIMIT XX LIMIT XX
6 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
6 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
6 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
6 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
6 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
6 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
6 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
6 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
6 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
6 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
6 queries	SELECT `value` FROM ps_ce_meta WHERE `id` = XX AND `name` = "_elementor_page_settings" LIMIT XX
6 queries	SELECT `value` FROM ps_ce_meta WHERE `id` = XX AND `name` = "_elementor_data" LIMIT XX
6 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
6 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
6 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT DISTINCT pl.name as name FROM `ps_product_lang` pl WHERE (pl.id_product = XX) AND (pl.id_lang = XX AND pl.id_shop = XX ) LIMIT XX
5 queries	SELECT `value` FROM ps_ce_meta WHERE `id` = XX AND `name` = "_elementor_css" LIMIT XX
5 queries	SELECT a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code` FROM `ps_lgcookieslaw_cookie` a LEFT JOIN `ps_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = XX) WHERE (a.`id_lgcookieslaw_purpose` = XX) AND (a.`id_shop` = XX) AND (a.`active` = XX) ORDER BY a.`name`
4 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
3 queries	SELECT * FROM `ps_ce_theme` a LEFT JOIN `ps_ce_theme_lang` `b` ON a.`id_ce_theme` = b.`id_ce_theme` AND b.`id_lang` = XX LEFT JOIN `ps_ce_theme_shop` `c` ON a.`id_ce_theme` = c.`id_ce_theme` AND c.`id_shop` = XX WHERE (a.`id_ce_theme` = XX) AND (b.`id_shop` = XX) LIMIT XX
3 queries	SELECT psgdpr.active FROM `ps_psgdpr_consent` psgdpr WHERE psgdpr.id_module = XX LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT `id_category` FROM `ps_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT * FROM `ps_shop_url` aXX
2 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
2 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
2 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

Name	Instances	Source
Category	68	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 144] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 152] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 155] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 44] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 157] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 153] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 132] /controllers/front/listing/CategoryController.php:214 (__construct) [id: 156] /classes/Meta.php:380 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 144] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 144] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 155] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1384 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 22] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 155] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 22] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 333] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 22] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 333] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 22] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 333] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 22] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 333] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 22] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 144] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1333 (__construct) [id: 152] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 144]
CETheme	16	/modules/creativeelements/creativeelements.php:706 (__construct) [id: 12] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 12] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 12] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 12] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 12] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 12] /modules/creativeelements/creativeelements.php:735 (__construct) [id: 4] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 4] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 4] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 4] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 4] /modules/creativeelements/creativeelements.php:735 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:102 (__construct) [id: 2]
Product	12	/src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 7209] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 7101] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 835] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 834] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 833] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 832] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 7209] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 7101] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 835] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 834] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 833] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 832]
CETemplate	5	/modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 2] /modules/creativeelements/classes/wrappers/Post.php:98 (__construct) [id: 2]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:641 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Country	3	/config/config.inc.php:146 (__construct) [id: 177] /classes/AddressFormat.php:404 (__construct) [id: 177] /classes/controller/FrontController.php:1779 (__construct) [id: 177]
ShopUrl	2	/classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
CMS	1	/classes/Link.php:555 (__construct) [id: 3]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
State	1	/classes/controller/FrontController.php:1778 (__construct) [id: 0]
AddressFormat	1	/classes/controller/FrontController.php:1773 (generateAddress) [id: ]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	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

Montres

Catégories

Marque

Disponibilité

Prix

Selections

Compatible avec

Couleur

Capacité de stockage

Source Alimentation

Appels via smartphones

Autonomie

Connectivité sans fil

Matière

Taille de l'écran (pouces)

Taille du boitier

Taille du bracelet

Type d'écran

Type de connecteur

Service Client & SAV

Retours

Solutions de paiement

Retrait Drive ou Casiers

À propos

Informations légales​

St-Barth Électronique​

Newsletter

Stopwatch SQL - 349 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Informations légales

St-Barth Électronique