En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de Cookies pour vous proposer des publicités ciblées adaptées à vos centres d'intérêts et réaliser des statistiques de visites. En savoir plus.

❄️ Ajoutez un multi-split Mitsubishi à votre panier, et obtenez 25€ de réduction pour chaque unité intérieure ajoutée. Simple et immédiat !❄️

❄️ Ajoutez. Équipez. Économisez. Avec le multi-split Mitsubishi, chaque unité intérieure ajoutée vous fait économiser davantage.❄️

Saisissez notre offre unique : Pour l’achat d’une unité extérieure multi-split Mitsubishi, bénéficiez d’une réduction de 25€ pour chaque unité intérieure ajoutée.

✅ Un confort sur mesure dans chaque espace
✅ Technologie Mitsubishi de pointe
✅ Economies sur votre installation

Modernisez votre climatisation et profitez d'avantages exclusifs ! Offre en ligne, stocks limités, valable jusqu'au 31/05/2025.

Daikin FHA71A9 Plafonnier

Climatisation Multi-Split Daikin

1 378,80 €

Daikin FHA50A9 Plafonnier

Climatisation Multi-Split Daikin

1 236,00 €

Daikin FHA35A9 Plafonnier

Climatisation Multi-Split Daikin

1 227,60 €

Daikin FHA60A9 Plafonnier

Climatisation Multi-Split Daikin

1 240,80 €

Tous les nouveaux produits

Climatisation

Achetez Climatiseurs en Ligne

Trouvez le climatiseur parfait avec notre large sélection, idéale pour les résidences, espaces commerciaux et environnements industriels. Nos systèmes offrent chauffage et refroidissement efficaces, assurant un confort toute l'année, avec des technologies avancées comme le contrôle par Wi-Fi et le fonctionnement silencieux, tout en économisant de l'énergie.

Explorez des modèles variés, tels que les unités split, systèmes de gainable, cassettes et consoles, adaptés à tous les environnements. Que ce soit pour votre maison, bureau ou espace industriel, nous avons ce qu'il vous faut, avec des marques comme Daikin, Mitsubishi, Samsung et Toshiba.

En choisissant notre boutique en ligne, bénéficiez de prix compétitifs, d'un support spécialisé, d'une livraison rapide et d'une garantie de satisfaction. Trouvez dès aujourd'hui le climatiseur idéal pour votre espace et profitez de nos offres exclusives!

Sous-catégorie

Climatiseur Mono-Split

Climatisation Multi-Split

Climatisation Tertiaire et Industrielle

Climatiseur sans unité extérieure

97 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par :

Daitsu ABD12KDB Plafonnier Atlas

1 186,80 €

Daitsu ABD12KDB Plafonnier Atlas

1 186,80 €

Daitsu ABD12KDB Plafonnier Atlas

Climatisation Tertiaire Split Daitsu

Kit climatiseur plafonnier monophasé 3.5 kW

1 186,80 €

Load Time	2732 ms
Querying Time	2404 ms
Queries	1612
Memory Peak Usage	53.6 Mb
Included Files	1286 files - 14.54 Mb
PrestaShop Cache	- Mb
Global vars	0.96 Mb
- global $_MODULES	577k
- global $context	376k
- global $__composer_autoload_files	10k
- global $_SERVER	8k
- global $exportPhpConfigFile	4k
- global $config	3k
- global $jprestaWebpConverterOptions	2k
- global $_COOKIE	1k

PrestaShop Version	1.7.8.6
PHP Version	7.4.33
MySQL Version	5.7.44
Memory Limit	3072M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	58 ms	58 ms	7.32 Mb	8.8 Mb
__construct	0 ms	58 ms	- Mb	8.8 Mb
init	54 ms	112 ms	1.75 Mb	9.2 Mb
checkAccess	0 ms	112 ms	- Mb	9.2 Mb
setMedia	1 ms	113 ms	0.08 Mb	9.2 Mb
postProcess	0 ms	113 ms	- Mb	9.2 Mb
initHeader	0 ms	113 ms	- Mb	9.2 Mb
initContent	2310 ms	2423 ms	16.16 Mb	25.4 Mb
initFooter	0 ms	2423 ms	- Mb	25.4 Mb
display	309 ms	2732 ms	27.75 Mb	53.6 Mb

Hook	Time	Memory Usage
DisplayHeader	539 ms	5.59 Mb
=> jprestaspeedpack	0 ms	- Mb
=> tvcmscustomsetting	0 ms	0.01 Mb
=> tvcmstabproducts	0 ms	- Mb
=> tvcmsbestsellerproducts	0 ms	- Mb
=> tvcmsbrandlist	0 ms	- Mb
=> tvcmscookiesnotice	0 ms	- Mb
=> tvcmscustomerservices	0 ms	- Mb
=> tvcmsfeaturedproducts	0 ms	- Mb
=> tvcmsfooterlogo	0 ms	- Mb
=> tvcmsmultibanner1	0 ms	- Mb
=> tvcmsnewproducts	0 ms	- Mb
=> tvcmsnewsletterpopup	0 ms	- Mb
=> tvcmspaymenticon	0 ms	- Mb
=> tvcmsproductcomments	0 ms	- Mb
=> tvcmsproductcompare	0 ms	- Mb
=> tvcmssearch	0 ms	- Mb
=> tvcmssingleblock	0 ms	- Mb
=> tvcmsslider	0 ms	- Mb
=> tvcmsspecialproducts	0 ms	- Mb
=> tvcmstestimonial	0 ms	- Mb
=> tvcmsthemeoptions	0 ms	- Mb
=> tvcmswishlist	0 ms	- Mb
=> ps_shoppingcart	0 ms	- Mb
=> ps_searchbar	0 ms	0.06 Mb
=> ets_cfultimate	4 ms	0.05 Mb
=> lggoogleanalytics	527 ms	5.32 Mb
=> ets_promotion	4 ms	0.13 Mb
=> payplug	1 ms	- Mb
=> recaptchapro	0 ms	0.01 Mb
DisplayReviewProductList	92 ms	9.93 Mb
=> tvcmsproductcomments	1 ms	0.14 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	10 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
DisplayLeftColumn	44 ms	3.63 Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	0.03 Mb
=> tvcmsnewproducts	42 ms	3.42 Mb
=> tvcmsspecialproducts	0 ms	- Mb
=> tvcmsfeaturedproducts	0 ms	- Mb
=> tvcmstestimonial	1 ms	0.07 Mb
=> tvcmsbestsellerproducts	0 ms	- Mb
=> ets_cfultimate	0 ms	0.02 Mb
=> ets_promotion	1 ms	0.09 Mb
DisplayWishlistBtnProductList	25 ms	1.00 Mb
=> tvcmswishlist	0 ms	0.02 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
DisplayProductCompareProductList	24 ms	1.09 Mb
=> tvcmsproductcompare	0 ms	0.02 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.07 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayProductListStockIndicator	11 ms	1.45 Mb
=> tvcmsstockinfo	0 ms	0.04 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.06 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
DisplayMegamenu	10 ms	1.28 Mb
=> tvcmsmegamenu	10 ms	1.28 Mb
DisplayNavSearchBlock	3 ms	0.86 Mb
=> tvcmssearch	3 ms	0.86 Mb
displayNavLanguageBlock	3 ms	0.28 Mb
=> ps_languageselector (widget)	3 ms	0.28 Mb
DisplayBanner	3 ms	0.26 Mb
=> ets_promotion	3 ms	0.26 Mb
DisplayCustomsocialblock	3 ms	0.28 Mb
=> tvcmscustomsetting	3 ms	0.28 Mb
Header	3 ms	0.10 Mb
=> tvcmsstockinfo	0 ms	- Mb
=> tvcmsinfinitescroll	2 ms	0.09 Mb
=> tvcmsofferbanner	0 ms	- Mb
=> tvcmssliderofferbanner	0 ms	- Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	- Mb
=> tvcmstwoofferbanner	0 ms	- Mb
=> tvcmsmegamenu	0 ms	- Mb
displayNewslettersubscription	2 ms	0.24 Mb
=> ps_emailsubscription (widget)	2 ms	0.24 Mb
DisplayProductPriceBlock	1 ms	0.11 Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
displayNavShoppingCartBlock	1 ms	0.14 Mb
=> ps_shoppingcart (widget)	1 ms	0.14 Mb
displayNav1	1 ms	0.09 Mb
=> ps_contactinfo (widget)	1 ms	0.09 Mb
displayFooterPart2	1 ms	0.09 Mb
=> ps_linklist (widget)	1 ms	0.09 Mb
displayMyaccountcblock	1 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1 ms	0.09 Mb
DisplayNavWishlistBlocksticky	1 ms	0.06 Mb
=> tvcmswishlist	1 ms	0.06 Mb
DisplayGDPRConsent	1 ms	0.11 Mb
=> psgdpr	1 ms	0.11 Mb
DisplayNavWishlistBlock	1 ms	0.05 Mb
=> tvcmswishlist	1 ms	0.05 Mb
DisplayFooterAfter	1 ms	0.12 Mb
=> salesgullcustom	0 ms	0.02 Mb
=> ets_promotion	1 ms	0.10 Mb
DisplayFooter	1 ms	0.05 Mb
=> ets_cfultimate	1 ms	0.05 Mb
displayContactCinfo	1 ms	0.04 Mb
=> ps_contactinfo (widget)	1 ms	0.04 Mb
ActionDispatcher	1 ms	- Mb
=> recaptchapro	1 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
displayNavCustomerSignInBlock	1 ms	- Mb
=> ps_customersignin (widget)	1 ms	- Mb
displayFooterPart1	1 ms	0.06 Mb
=> ps_linklist (widget)	1 ms	0.06 Mb
DisplayNav1	1 ms	0.10 Mb
=> ets_promotion	1 ms	0.10 Mb
ProductSearchProvider	0 ms	0.01 Mb
=> ps_facetedsearch	0 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0 ms	0.01 Mb
=> tvcmscookiesnotice	0 ms	0.01 Mb
DisplayProductComparesticky	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayNavProductCompareBlock	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayFacetedSearchBlock	0 ms	0.09 Mb
=> ps_facetedsearch	0 ms	0.09 Mb
DisplayFooterPart2	0 ms	0.03 Mb
=> tvcmsfooterlogo	0 ms	0.03 Mb
ActionFrontControllerSetMedia	0 ms	- Mb
=> ps_emailsubscription	0 ms	- Mb
=> ps_emailalerts	0 ms	- Mb
ActionDispatcherBefore	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ActionOutputHTMLBefore	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ModuleRoutes	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
DisplayTopOfferText	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
DisplayCustomJs	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayCustomCss	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayBodyBackgroundBody	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
DisplayOverrideTemplate	0 ms	- Mb
=> ets_promotion	0 ms	- Mb
43 hook(s)	775 ms	26.89 Mb

Module	Time	Memory Usage
payplug	22 ms	0.68 Mb
__construct	19 ms	0.50 Mb
hookDisplayHeader	1 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb

Query	Time (ms)	Rows	Filesort	Location
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (13335, 13336))) GROUP BY fp.id_feature_value	580536 ms	18823680	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-04-21 00:00:00", INTERVAL 200 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `prstshp_category_product` cp LEFT JOIN `prstshp_product` p ON p.`id_product` = cp.`id_product` INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prstshp_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 3 AND cl.id_shop = 1 ) LEFT JOIN `prstshp_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 ) LEFT JOIN `prstshp_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `prstshp_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3) LEFT JOIN `prstshp_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 163 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,24	246558 ms	6536	Yes	/classes/Category.php:1057 /modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM prstshp_product p INNER JOIN prstshp_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 8) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122	123518 ms	941184		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57<br>/modules/ps_facetedsearch/src/Filters/Block.php:250<br>/modules/ps_facetedsearch/src/Filters/Block.php:131<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=32)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	120286 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=47)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	74500 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE image_shop.`id_image` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 4013 AND image_shop.`cover` = 1 LIMIT 1	53536 ms	3		/classes/Product.php:3533 /classes/Product.php:5598<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=50)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	52899 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=28)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	47216 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=34)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	46690 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=46)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	44072 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE p.id_product, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 ) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 0) ASC, p.position ASC, p.id_product DESC	42088 ms	3801600	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:187<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=23)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	31775 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	28364 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=22)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	20383 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `prstshp_meta` m LEFT JOIN `prstshp_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	20210 ms	108	Yes	/override/classes/Dispatcher.php:212 /classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
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 `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 6 ORDER BY vl.`value` ASC	20053 ms	80	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 50 ORDER BY vl.`value` ASC	19131 ms	6	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE location FROM `prstshp_stock_available` WHERE (id_product = 4472) AND (id_product_attribute = 7166) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	18268 ms	1		/classes/stock/StockAvailable.php:797 /classes/Combination.php:153<br>/classes/Combination.php:140<br>/classes/Product.php:5802<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 28 ORDER BY vl.`value` ASC	15580 ms	12	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=40)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	15377 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY p.id_manufacturer	13713 ms	68428800	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:661<br>/modules/ps_facetedsearch/src/Filters/Block.php:146<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE * FROM `prstshp_currency` c ORDER BY `iso_code` ASC	13251 ms	3	Yes	/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84<br>/src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90<br>/src/Core/Localization/Currency/CurrencyDataSource.php:96<br>/src/Core/Localization/Currency/Repository.php:87<br>/src/Core/Localization/Locale/Repository.php:207<br>/src/Core/Localization/Locale/Repository.php:150<br>/classes/controller/Controller.php:196<br>/classes/controller/FrontController.php:303<br>/controllers/front/listing/CategoryController.php:92<br>/override/controllers/front/CategoryController.php:54<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE * FROM `prstshp_group` a LEFT JOIN `prstshp_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1	12777 ms	1		/src/Adapter/EntityMapper.php:76 /classes/ObjectModel.php:265<br>/tools/profiling/ObjectModel.php:32<br>/classes/Group.php:81<br>/classes/Group.php:397<br>/classes/Cart.php:248<br>/classes/Cart.php:221<br>/modules/payplug/src/application/adapter/CartAdapter.php:38<br>/modules/payplug/src/application/dependencies/PluginInit.php:353<br>/modules/payplug/src/application/dependencies/PluginInit.php:185<br>/modules/payplug/classes/DependenciesClass.php:85<br>/modules/payplug/classes/DependenciesClass.php:73<br>/modules/payplug/classes/PayPlugDependencies.php:65<br>/modules/payplug/classes/PayPlugDependencies.php:55<br>/modules/payplug/payplug.php:597<br>/modules/payplug/payplug.php:92<br>:undefined<br>/src/Core/Foundation/IoC/Container.php:123<br>/src/Core/Foundation/IoC/Container.php:153<br>/src/Core/Foundation/IoC/Container.php:166<br>/src/Adapter/ServiceLocator.php:65<br>/classes/module/Module.php:1191<br>/tools/profiling/Module.php:35<br>/classes/module/Module.php:1170<br>/classes/Hook.php:921<br>/override/classes/Dispatcher.php:176<br>/classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position FROM prstshp_feature_product pf LEFT JOIN prstshp_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN prstshp_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN prstshp_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 3141 ORDER BY f.position ASC	11793 ms	15	Yes	/classes/Product.php:5897 /classes/Product.php:5759<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `prstshp_attribute` a LEFT JOIN `prstshp_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 3) LEFT JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `prstshp_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3) WHERE pa.`id_product` = 2593 AND pac.`id_product_attribute` = 3567 AND agl.`id_lang` = 3	11217 ms	1		/classes/Product.php:7398 /classes/Product.php:5785<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `prstshp_specific_price_priority` WHERE `id_product` = 3077 ORDER BY `id_specific_price_priority` DESC LIMIT 1	11149 ms	1		/classes/SpecificPrice.php:250 /classes/SpecificPrice.php:230<br>/classes/SpecificPrice.php:550<br>/classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_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 prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (26239, 26247, 26251, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=24)) AND ((fp_1.id_feature_value IN (26239, 26247, 26251, 26255))) GROUP BY fp.id_feature_value	11138 ms	586080	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `prstshp_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 3077 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `prstshp_cart_product` cp JOIN `prstshp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prstshp_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 3077 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	11134 ms	0		/classes/Cart.php:1429 /classes/Product.php:4277<br>/classes/Product.php:5739<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `prstshp_product` p INNER JOIN `prstshp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 4513)	10921 ms	12		/classes/Product.php:3820 /classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE image_shop.`id_image` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 2664 AND image_shop.`cover` = 1 LIMIT 1	10833 ms	5		/classes/Product.php:3533 /classes/Product.php:5598<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE * FROM prstshp_product_attachment pa LEFT JOIN prstshp_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN prstshp_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3) WHERE pa.id_product = 3494	10531 ms	1		/classes/Product.php:5928 /classes/Product.php:5763<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `prstshp_cart_product` cp WHERE cp.`id_product_attribute` = 7271 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 4502 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `prstshp_cart_product` cp JOIN `prstshp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prstshp_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 7271 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 4502 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	10494 ms	0		/classes/Cart.php:1429 /classes/Product.php:4277<br>/classes/Product.php:5749<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `prstshp_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1	10250 ms	2022084		/classes/SpecificPrice.php:287 /classes/SpecificPrice.php:345<br>/classes/SpecificPrice.php:533<br>/classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE pa.`available_date` FROM `prstshp_product` p LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 3494 AND pa.`id_product` = 3494 AND pa.`id_product_attribute` = 5500 LIMIT 1	9721 ms	1		/classes/Product.php:1135 /classes/Product.php:5753<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE image_shop.`id_image` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 4502 AND image_shop.`cover` = 1 LIMIT 1	9682 ms	6		/classes/Product.php:3533 /classes/Product.php:5598<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
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 `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 23 ORDER BY vl.`value` ASC	9478 ms	5	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE `id_product` FROM prstshp_product_lang WHERE `link_rewrite` = "climatisation" AND `id_lang` = 3 AND `id_shop` = 1 LIMIT 1	9151 ms	3269		/override/classes/Dispatcher.php:1050 /override/classes/Dispatcher.php:339<br>/classes/Dispatcher.php:352<br>/index.php:39
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = 4472 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	9146 ms	1		/modules/tvcmsproductcomments/tvcmsproductcomment.php:225 /modules/tvcmsproductcomments/tvcmsproductcomments.php:916<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/7c/ea/50/7cea5081043f9339ffdf34c1ebf0d43ccdd395cd_2.file.product-catelog-view.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:54<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE pa.`available_date` FROM `prstshp_product` p LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 3495 AND pa.`id_product` = 3495 AND pa.`id_product_attribute` = 5518 LIMIT 1	8121 ms	1		/classes/Product.php:1135 /classes/Product.php:5753<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE image_shop.`id_image` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 3078 AND image_shop.`cover` = 1 LIMIT 1	7728 ms	3		/classes/Product.php:3533 /classes/Product.php:5598<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39

100 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = <span style="color:blue">XX</span> AND pc.`deleted` = <span style="color:blue">XX</span> AND pc.`validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
100 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = <span style="color:blue">XX</span> AND pc.`deleted` = <span style="color:blue">XX</span> AND pc.`validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
69 queries	SELECT `id_order` FROM `prstshp_orders` WHERE `id_cart` = <span style="color:blue">XX</span> AND id_shop IN (<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
69 queries	SELECT SUM(quantity) FROM `prstshp_stock_available` WHERE (id_product = <span style="color:blue">XX</span>) AND (id_product_attribute = <span style="color:blue">XX</span>) AND (id_shop = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
69 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), <span style="color:blue">XX</span>) as deep_quantity, COALESCE(SUM(first_level_quantity), <span style="color:blue">XX</span>) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, <span style="color:blue">XX</span> as pack_quantity FROM `prstshp_cart_product` cp WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span> AND cp.`id_customization` = <span style="color:blue">XX</span> AND cp.`id_cart` = <span style="color:blue">XX</span> AND cp.`id_product` = <span style="color:blue">XX</span> UNION SELECT <span style="color:blue">XX</span> as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `prstshp_cart_product` cp JOIN `prstshp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prstshp_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span> AND cp.`id_customization` = <span style="color:blue">XX</span> AND cp.`id_cart` = <span style="color:blue">XX</span> AND p.`id_product_item` = <span style="color:blue">XX</span> AND (pr.`pack_stock_type` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) OR ( pr.`pack_stock_type` = <span style="color:blue">XX</span> AND <span style="color:blue">XX</span> = <span style="color:blue">XX</span> ))) as q LIMIT <span style="color:blue">XX</span>
64 queries	SELECT c., cl. FROM `prstshp_category` c LEFT JOIN `prstshp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = <span style="color:blue">XX</span> AND cl.id_shop = <span style="color:blue">XX</span> ) WHERE c.`id_category` = <span style="color:blue">XX</span>
53 queries	SELECT <span style="color:blue">XX</span> FROM `prstshp_specific_price` WHERE id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT name FROM prstshp_category_lang WHERE id_shop = <span style="color:blue">XX</span> AND id_lang = <span style="color:blue">XX</span> AND id_category = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT `reduction` FROM `prstshp_product_group_reduction_cache` WHERE `id_product` = <span style="color:blue">XX</span> AND `id_group` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT `id_tax_rules_group` FROM `prstshp_product_shop` WHERE `id_product` = <span style="color:blue">XX</span> AND id_shop=<span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,<span style="color:blue">XX</span>) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `prstshp_product` p INNER JOIN `prstshp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) WHERE (p.`id_product` = <span style="color:blue">XX</span>)
52 queries	SELECT COUNT(*) FROM `prstshp_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT image_shop.`id_image` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = <span style="color:blue">XX</span>) WHERE i.`id_product` = <span style="color:blue">XX</span> AND image_shop.`cover` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT * FROM `prstshp_product` a LEFT JOIN `prstshp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = <span style="color:blue">XX</span> LEFT JOIN `prstshp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_product` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
51 queries	SELECT * FROM prstshp_product_attachment pa LEFT JOIN prstshp_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN prstshp_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = <span style="color:blue">XX</span>) WHERE pa.id_product = <span style="color:blue">XX</span>
49 queries	SELECT *, ( IF (`id_group` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_country` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_currency` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_shop` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_customer` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_currency` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_country` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_group` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_product` = <span style="color:blue">XX</span> AND `id_customer` = <span style="color:blue">XX</span> AND `id_product_attribute` = <span style="color:blue">XX</span> AND `id_cart` = <span style="color:blue">XX</span> AND (`from` = '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' OR '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' >= `from`) AND (`to` = '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' OR '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' <= `to`) AND IF(`from_quantity` > <span style="color:blue">XX</span>, `from_quantity`, <span style="color:blue">XX</span>) <= <span style="color:blue">XX</span> ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT <span style="color:blue">XX</span>
48 queries	SELECT name, value, pf.id_feature, f.position FROM prstshp_feature_product pf LEFT JOIN prstshp_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>) LEFT JOIN prstshp_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = <span style="color:blue">XX</span>) LEFT JOIN prstshp_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = <span style="color:blue">XX</span>) WHERE pf.id_product = <span style="color:blue">XX</span> ORDER BY f.position ASC
48 queries	SELECT `priority`, `id_specific_price_priority` FROM `prstshp_specific_price_priority` WHERE `id_product` = <span style="color:blue">XX</span> ORDER BY `id_specific_price_priority` DESC LIMIT <span style="color:blue">XX</span>
28 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, <span style="color:blue">XX</span>) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>', INTERVAL <span style="color:blue">XX</span> DAY ) ) > <span style="color:blue">XX</span>) as new FROM prstshp_product p LEFT JOIN prstshp_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = <span style="color:blue">XX</span> AND pl.id_lang = <span style="color:blue">XX</span> LEFT JOIN prstshp_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = <span style="color:blue">XX</span> LEFT JOIN prstshp_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = <span style="color:blue">XX</span> WHERE p.id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
28 queries	SELECT `id_product_attribute` FROM `prstshp_product_attribute` WHERE `id_product` = <span style="color:blue">XX</span>
28 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `prstshp_tvcmsproduct_comment` pc WHERE `id_product` = <span style="color:blue">XX</span> AND `validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
28 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = <span style="color:blue">XX</span>) WHERE i.`id_product` = <span style="color:blue">XX</span> ORDER BY `position`
26 queries	select count(pa.`id_product_attribute`) as `total` from `prstshp_product_attribute` pa inner join `prstshp_product_attribute_shop` pas on pa.id_product_attribute = pas.id_product_attribute where pas.`id_shop` = <span style="color:blue">XX</span> and pa.`id_product` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
24 queries	SELECT position FROM `prstshp_category_product` WHERE id_category = <span style="color:blue">XX</span> AND id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
24 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `prstshp_product_attribute` pa INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, <span style="color:blue">XX</span>) AND stock.id_shop = <span style="color:blue">XX</span> AND stock.id_shop_group = <span style="color:blue">XX</span> ) JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `prstshp_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `prstshp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = <span style="color:blue">XX</span>) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (<span style="color:blue">XX</span>) AND ag.`is_color_group` = <span style="color:blue">XX</span> GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > <span style="color:blue">XX</span> ORDER BY a.`position` ASC;
19 queries	SELECT `id_module` FROM `prstshp_module_shop` WHERE `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
17 queries	SELECT product_attribute_shop.`price` FROM `prstshp_product_attribute` pa INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) WHERE pa.`id_product_attribute` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
17 queries	SELECT pa.`available_date` FROM `prstshp_product` p LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = <span style="color:blue">XX</span>) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) WHERE p.`id_product` = <span style="color:blue">XX</span> AND pa.`id_product` = <span style="color:blue">XX</span> AND pa.`id_product_attribute` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
17 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean<span style="color:blue">XX</span>`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `prstshp_attribute` a LEFT JOIN `prstshp_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = <span style="color:blue">XX</span>) WHERE pa.`id_product` = <span style="color:blue">XX</span> AND pac.`id_product_attribute` = <span style="color:blue">XX</span> AND agl.`id_lang` = <span style="color:blue">XX</span>
17 queries	SELECT * FROM `prstshp_product_attribute` a LEFT JOIN `prstshp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_product_attribute` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
17 queries	SELECT location FROM `prstshp_stock_available` WHERE (id_product = <span style="color:blue">XX</span>) AND (id_product_attribute = <span style="color:blue">XX</span>) AND (id_shop = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
16 queries	SELECT mr.* FROM prstshp_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = <span style="color:blue">XX</span> AND mr.id_tvcmsmegamenu = <span style="color:blue">XX</span> AND mr.`active` = <span style="color:blue">XX</span>
14 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 `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = <span style="color:blue">XX</span>) WHERE v.`id_feature` = <span style="color:blue">XX</span> ORDER BY vl.`value` ASC
12 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `prstshp_product_attribute_image` pai LEFT JOIN `prstshp_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `prstshp_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND il.`id_lang` = <span style="color:blue">XX</span> ORDER by i.`position`
12 queries	SELECT * FROM `prstshp_category` a LEFT JOIN `prstshp_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = <span style="color:blue">XX</span> LEFT JOIN `prstshp_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_category` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
10 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 prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, <span style="color:blue">XX</span>) = sa.id_product_attribute AND sa.id_shop = <span style="color:blue">XX</span> AND sa.id_shop_group = <span style="color:blue">XX</span> ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = <span style="color:blue">XX</span> AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=<span style="color:blue">XX</span>) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ps.id_shop='<span style="color:blue">XX</span>' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='<span style="color:blue">XX</span>' AND c.nleft>=<span style="color:blue">XX</span> AND c.nright<=<span style="color:blue">XX</span> GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature=<span style="color:blue">XX</span>)) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) GROUP BY fp.id_feature_value
6 queries	SELECT `id_lang` FROM `prstshp_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT <span style="color:blue">XX</span>
5 queries	SELECT cl.`link_rewrite` FROM `prstshp_category_lang` cl WHERE `id_lang` = <span style="color:blue">XX</span> AND cl.id_shop = <span style="color:blue">XX</span> AND cl.`id_category` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
5 queries	SELECT * FROM prstshp_hook_module WHERE `id_hook` = <span style="color:blue">XX</span> AND `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span>
4 queries	SELECT id_meta FROM prstshp_meta WHERE page = "category" LIMIT <span style="color:blue">XX</span>

Name	Instances	Source
Customer	417	/config/config.inc.php [249] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37]
Category	103	/controllers/front/listing/CategoryController.php [89] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /classes/Meta.php [380] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/ps_facetedsearch/src/Product/Search.php [364] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmssearch/tvcmssearch.php [101] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98]
Product	86	/classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114]
Combination	52	/classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802]
Country	7	/config/config.inc.php [157] /classes/AddressFormat.php [404] /classes/controller/FrontController.php [1677] /classes/AddressFormat.php [404] /modules/ps_contactinfo/ps_contactinfo.php [105] /classes/AddressFormat.php [404] /modules/ps_contactinfo/ps_contactinfo.php [105]
Address	6	/modules/payplug/src/application/adapter/AddressAdapter.php [38] /classes/shop/Shop.php [469] /classes/Product.php [3654] /classes/Product.php [3764] /classes/Product.php [5840] /modules/payplug/src/application/adapter/AddressAdapter.php [38]
Currency	5	/src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /classes/Tools.php [700] /modules/lggoogleanalytics/lggoogleanalytics.php [1679]
Configuration	4	/src/Core/Addon/Theme/Theme.php [42] /modules/payplug/src/application/adapter/ConfigurationAdapter.php [38] /src/Core/Addon/Theme/Theme.php [42] /modules/payplug/src/application/adapter/ConfigurationAdapter.php [38]
AddressFormat	3	/classes/controller/FrontController.php [1671] /modules/ps_contactinfo/ps_contactinfo.php [91] /modules/ps_contactinfo/ps_contactinfo.php [91]
Cart	3	/modules/payplug/src/application/adapter/CartAdapter.php [38] /classes/controller/FrontController.php [443] /modules/payplug/src/application/adapter/CartAdapter.php [38]
State	3	/classes/controller/FrontController.php [1676] /modules/ps_contactinfo/ps_contactinfo.php [94] /modules/ps_contactinfo/ps_contactinfo.php [94]
OrderState	2	/modules/payplug/src/application/adapter/OrderStateAdapter.php [38] /modules/payplug/src/application/adapter/OrderStateAdapter.php [38]
Language	2	/config/config.inc.php [222] /classes/Tools.php [581]
Carrier	2	/modules/payplug/src/application/adapter/CarrierAdapter.php [45] /modules/payplug/src/application/adapter/CarrierAdapter.php [45]
Tax	2	/classes/tax/TaxRulesTaxManager.php [116] /classes/tax/TaxRulesTaxManager.php [116]
CartRule	2	/modules/payplug/src/application/adapter/CartRuleAdapter.php [38] /modules/payplug/src/application/adapter/CartRuleAdapter.php [38]
Shop	1	/config/config.inc.php [128]
Risk	1	/classes/controller/FrontController.php [1609]
Gender	1	/classes/controller/FrontController.php [1606]
Group	1	/classes/Cart.php [248]
ShopGroup	1	/classes/shop/Shop.php [557]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php [1365]

Daikin FHA71A9 Plafonnier

Daikin FHA50A9 Plafonnier

Daikin FHA35A9 Plafonnier

Daikin FHA60A9 Plafonnier

Climatisation

Achetez Climatiseurs en Ligne

Daitsu ABD12KDB Plafonnier Atlas

Daitsu ABD12KDB Plafonnier Atlas

Daitsu ABD12KDB Plafonnier Atlas

Daitsu ABD12KDB Plafonnier Atlas

Daitsu ABD42KDB Plafonnier Atlas

Daitsu ABD42KDB Plafonnier Atlas

Daitsu ABD42KDB Plafonnier Atlas

Daitsu ABD42KDB Plafonnier Atlas

Daitsu ABD42TKDB Plafonnier Atlas Triphasé

Daitsu ABD42TKDB Plafonnier Atlas Triphasé

Daitsu ABD42TKDB Plafonnier Atlas Triphasé

Daitsu ABD42TKDB Plafonnier Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daikin FTXM71A + RXM71A Perfera All Seasons

Daikin FTXM71A + RXM71A Perfera All Seasons

Daikin FTXM71A + RXM71A Perfera All Seasons

Daikin FTXM71A + RXM71A Perfera All Seasons

Daikin FTXP71N + RXP71N Série Comfora

Daikin FTXP71N + RXP71N Série Comfora

Daikin FTXP71N + RXP71N Série Comfora

Daikin FTXP71N + RXP71N Série Comfora

Daikin FTXM71A Perfera All Seasons

Daikin FTXM71A Perfera All Seasons

Daikin FTXM71A Perfera All Seasons

Daikin FTXM71A Perfera All Seasons

Daikin FFA60A9 Série Fully Flat

Daikin FFA60A9 Série Fully Flat

Daikin FFA60A9 Série Fully Flat

Daikin FFA60A9 Série Fully Flat

Daikin 2MXM50A9

Daikin 2MXM50A9

Daikin 2MXM50A9

Daikin 2MXM50A9

Daikin 2MXM68A9

Daikin 2MXM68A9

Daikin 2MXM68A9

Daikin 2MXM68A9

Daikin 3MXM68A9

Daikin 3MXM68A9

Daikin 3MXM68A9

Daikin 3MXM68A9

Daikin 4MXM68A9

Daikin 4MXM68A9

Daikin 4MXM68A9

Daikin 4MXM68A9

Daikin 4MXM80A9

Daikin 4MXM80A9

Daikin 4MXM80A9

Daikin 4MXM80A9

Daikin FFA60A9 + RXM60A Cassette Extra-plate

Daikin FFA60A9 + RXM60A Cassette Extra-plate

Daikin FFA60A9 + RXM60A Cassette Extra-plate

Daikin FFA60A9 + RXM60A Cassette Extra-plate

Daikin FHA50A9 + RXM50A9 Plafonnier Apparent

Daikin FHA50A9 + RXM50A9 Plafonnier Apparent

Daikin FHA50A9 + RXM50A9 Plafonnier Apparent

Daikin FHA50A9 + RXM50A9 Plafonnier Apparent

Daikin ADEA125A + AZAS125MV Gainable Moyenne Pression Sky Air Active Series

Daikin ADEA125A + AZAS125MV Gainable Moyenne Pression Sky Air Active Series

Daikin ADEA125A + AZAS125MV Gainable Moyenne Pression Sky Air Active Series

Daikin ADEA125A + AZAS125MV Gainable Moyenne Pression Sky Air Active Series

Daikin FBA125A + RZAG125NV1 Gainable Moyenne Pression Sky Air Alpha Series

Daikin FBA125A + RZAG125NV1 Gainable Moyenne Pression Sky Air Alpha Series

Daikin FBA125A + RZAG125NV1 Gainable Moyenne Pression Sky Air Alpha Series

Daikin FBA125A + RZAG125NV1 Gainable Moyenne Pression Sky Air Alpha Series

Daikin FBA125A + RZASG125MV1 Gainable Moyenne Pression Sky Air Advance Series

Daikin FBA125A + RZASG125MV1 Gainable Moyenne Pression Sky Air Advance Series

Daikin FBA125A + RZASG125MV1 Gainable Moyenne Pression Sky Air Advance Series

Daikin FBA125A + RZASG125MV1 Gainable Moyenne Pression Sky Air Advance Series

Daikin ADEA125A + AZAS125MY Gainable Moyenne Pression Sky Air Active Series Triphasé

Daikin ADEA125A + AZAS125MY Gainable Moyenne Pression Sky Air Active Series Triphasé