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

108 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par :

1 334,40 €

Load Time	1558 ms
Querying Time	1216 ms
Queries	1580
Memory Peak Usage	53.0 Mb
Included Files	1286 files - 14.54 Mb
PrestaShop Cache	- Mb
Global vars	0.96 Mb
- global $_MODULES	577k
- global $context	377k
- 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	21 ms	21 ms	7.32 Mb	8.8 Mb
__construct	0 ms	21 ms	- Mb	8.8 Mb
init	30 ms	51 ms	1.75 Mb	9.2 Mb
checkAccess	0 ms	51 ms	- Mb	9.2 Mb
setMedia	1 ms	52 ms	0.08 Mb	9.2 Mb
postProcess	0 ms	52 ms	- Mb	9.2 Mb
initHeader	0 ms	52 ms	- Mb	9.2 Mb
initContent	1206 ms	1258 ms	16.08 Mb	25.4 Mb
initFooter	0 ms	1258 ms	- Mb	25.4 Mb
display	300 ms	1558 ms	27.21 Mb	53.0 Mb

Hook	Time	Memory Usage
DisplayHeader	216 ms	5.59 Mb
=> jprestaspeedpack	0 ms	- Mb
=> tvcmscustomsetting	1 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	1 ms	0.05 Mb
=> lggoogleanalytics	209 ms	5.32 Mb
=> ets_promotion	2 ms	0.13 Mb
=> payplug	1 ms	- Mb
=> recaptchapro	0 ms	0.01 Mb
DisplayReviewProductList	76 ms	9.90 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.09 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	1 ms	0.08 Mb
DisplayLeftColumn	37 ms	3.11 Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	0.03 Mb
=> tvcmsnewproducts	35 ms	2.90 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	22 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	21 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.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.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.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.03 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.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.01 Mb
=> tvcmsstockinfo	0 ms	0.01 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
DisplayBanner	3 ms	0.27 Mb
=> ets_promotion	3 ms	0.27 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
displayNavLanguageBlock	3 ms	0.28 Mb
=> ps_languageselector (widget)	3 ms	0.28 Mb
DisplayCustomsocialblock	2 ms	0.28 Mb
=> tvcmscustomsetting	2 ms	0.28 Mb
displayNewslettersubscription	1 ms	0.24 Mb
=> ps_emailsubscription (widget)	1 ms	0.24 Mb
displayNavShoppingCartBlock	1 ms	0.14 Mb
=> ps_shoppingcart (widget)	1 ms	0.14 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
displayNav1	1 ms	0.09 Mb
=> ps_contactinfo (widget)	1 ms	0.09 Mb
DisplayNavWishlistBlock	1 ms	0.05 Mb
=> tvcmswishlist	1 ms	0.05 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
DisplayGDPRConsent	1 ms	0.11 Mb
=> psgdpr	1 ms	0.11 Mb
displayNavCustomerSignInBlock	1 ms	- Mb
=> ps_customersignin (widget)	1 ms	- Mb
DisplayFooterAfter	1 ms	0.12 Mb
=> salesgullcustom	0 ms	0.02 Mb
=> ets_promotion	0 ms	0.10 Mb
DisplayNavWishlistBlocksticky	1 ms	0.06 Mb
=> tvcmswishlist	1 ms	0.06 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
DisplayNav1	0 ms	0.10 Mb
=> ets_promotion	0 ms	0.10 Mb
displayFooterPart1	0 ms	0.06 Mb
=> ps_linklist (widget)	0 ms	0.06 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
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
DisplayProductComparesticky	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
ActionDispatcher	0 ms	- Mb
=> recaptchapro	0 ms	- Mb
=> jprestaspeedpack	0 ms	- 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
DisplayCustomCss	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayCustomJs	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)	419 ms	26.35 Mb

Module	Time	Memory Usage
payplug	7 ms	0.68 Mb
__construct	5 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	Group By	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	196679 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	83754 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 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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	61077 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	53930 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	52276 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	44575 ms	1084243968	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 (26240, 26615, 26618))) 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	40149 ms	60235776	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	38704 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	38443 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	37788 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY p.id_manufacturer	36376 ms	1084243968	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 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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	35989 ms	1084243968	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) WHERE ((fp.id_feature_value IN (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	35605 ms	7529472	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	33192 ms	1084243968	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 (26240, 26615, 26618))) 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 (26240, 26615, 26618))) GROUP BY fp.id_feature_value	33044 ms	1084243968	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 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 (26240, 26615, 26618))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122	22745 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 c., cl. FROM `prstshp_category` c LEFT JOIN `prstshp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 2	10075 ms	1			/override/classes/Link.php:107 /override/classes/Link.php:47<br>/controllers/front/listing/CategoryController.php:253<br>/classes/controller/FrontController.php:1736<br>/override/classes/controller/FrontController.php:68<br>/classes/controller/FrontController.php:590<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 c., cl. FROM `prstshp_category` c LEFT JOIN `prstshp_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3 AND cl.id_shop = 1 ) WHERE c.`id_category` = 163	9316 ms	1			/override/classes/Link.php:107 /override/classes/Link.php:47<br>/controllers/front/listing/CategoryController.php:221<br>:undefined<br>/controllers/front/listing/CategoryController.php:225<br>/controllers/front/listing/CategoryController.php:128<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 COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `prstshp_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1	9141 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 `id_product` FROM prstshp_product_lang WHERE `link_rewrite` = "climatisation" AND `id_lang` = 3 AND `id_shop` = 1 LIMIT 1	8206 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 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	7285 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 c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `prstshp_configuration` c LEFT JOIN `prstshp_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	6288 ms	2752			/classes/Configuration.php:160 /classes/Configuration.php:209<br>/classes/Configuration.php:297<br>/classes/shop/Shop.php:384<br>/config/config.inc.php:128<br>/index.php:38
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	5107 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 h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `prstshp_module` m INNER JOIN prstshp_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `prstshp_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `prstshp_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `prstshp_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `prstshp_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3238 ms	5715	Yes	Yes	/classes/Hook.php:1183 /classes/Hook.php:731<br>/classes/Hook.php:815<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 h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `prstshp_hook_module` hm STRAIGHT_JOIN `prstshp_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `prstshp_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	3218 ms	726			/classes/Hook.php:504 /classes/Hook.php:544<br>/classes/tax/TaxManagerFactory.php:67<br>/classes/tax/TaxManagerFactory.php:46<br>/classes/Product.php:3885<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 `id_hook`, `name` FROM `prstshp_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `prstshp_hook_alias` ha INNER JOIN `prstshp_hook` h ON ha.name = h.name	2524 ms	0			/classes/Hook.php:1243 /classes/Hook.php:222<br>/classes/tax/TaxManagerFactory.php:67<br>/classes/tax/TaxManagerFactory.php:46<br>/classes/Product.php:3885<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 c., cl. FROM `prstshp_category` c INNER JOIN prstshp_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `prstshp_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 3 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	2475 ms	117	Yes		/classes/Category.php:793 /modules/tvcmssearch/tvcmssearch.php:101<br>/modules/tvcmssearch/tvcmssearch.php:211<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/30/cc/c4/30ccc41b2f5bb6197b1ba4812974474a1b1c53d4_2.file.desk-header-1.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>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/82/16/18/8216187c37a36e2dc5d2ce9a48d7e9e1077572d5_2.file.desktop-header.tpl.php:25<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/6f/9e/f5/6f9ef54d45cdcd7619c1ab6ce0a0fa4f18acb53a_2.file.header.tpl.php:72<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/6f/9e/f5/6f9ef54d45cdcd7619c1ab6ce0a0fa4f18acb53a_2.file.header.tpl.php:30<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/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:147<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/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:63<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 lower(name) as name FROM `prstshp_hook` h WHERE (h.active = 1)	985 ms	879			/classes/Hook.php:1283 /classes/Hook.php:786<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 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	958 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 p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-04-21 00:00:00", INTERVAL 200 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `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_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` 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 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2024-10-03") AND (EXISTS(SELECT 1 FROM `prstshp_category_product` cp JOIN `prstshp_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	942 ms	600			/classes/Product.php:3079 /modules/tvcmstabproducts/tvcmstabproducts.php:2769<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:152<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:258<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/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:195<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/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:73<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 `id_hook`, `name` FROM `prstshp_hook`	938 ms	879			/classes/Hook.php:1243 /classes/Hook.php:222<br>/classes/Hook.php:824<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 DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `prstshp_feature` f INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `prstshp_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `prstshp_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 3) ORDER BY f.`position` ASC	851 ms	61	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<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 ctg.`id_group` FROM prstshp_category_group ctg WHERE ctg.`id_category` = 163 AND ctg.`id_group` = 1 LIMIT 1	772 ms	1			/classes/Category.php:1730 /controllers/front/listing/CategoryController.php:101<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 pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) 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` = 3) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4516) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	657 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<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/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<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:52<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 id_product, name, value, pf.id_feature 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) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE `id_product` IN (4590,4589,4588,4587) ORDER BY f.position ASC	657 ms	56	Yes		/classes/Product.php:4831 /classes/Product.php:3094<br>/modules/tvcmstabproducts/tvcmstabproducts.php:2769<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:152<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:258<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/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:195<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/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:73<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 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	652 ms	80	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Converter.php:402<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<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 pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) 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` = 3) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (3747) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	629 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<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/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<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:52<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 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` = 34 ORDER BY vl.`value` ASC	590 ms	25	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 pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) 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` = 3) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (4517) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	588 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<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/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<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:52<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.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) 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 = 1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) 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` = 3) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1385) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	566 ms	3	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<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/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<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:52<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

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>
66 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>
66 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>
66 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>
51 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>
50 queries	SELECT COUNT(*) FROM `prstshp_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
50 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>
50 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>
50 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>)
50 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>
50 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>
50 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>
50 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>
48 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>
47 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
47 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 `id_product_attribute` FROM `prstshp_product_attribute` WHERE `id_product` = <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 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`
27 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>
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 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;
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>
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>
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>
16 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>
16 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>
16 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>
16 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>
16 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>
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
14 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>))) 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>))) GROUP BY fp.id_feature_value
8 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>
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 * 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 m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `prstshp_module` m LEFT JOIN `prstshp_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = <span style="color:blue">XX</span>

Name	Instances	Source
Customer	401	/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]
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	82	/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] /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] /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] /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] /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	50	/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 ABD18KDB Plafonnier Atlas

Daitsu ABD18KDB Plafonnier Atlas

Daitsu ABD18KDB Plafonnier Atlas

Daitsu ABD18KDB Plafonnier Atlas

Haier AS71S2SF1FA-WH + 1U71S2SR2FA Flexis Plus Blanc

Haier AS71S2SF1FA-WH + 1U71S2SR2FA Flexis Plus Blanc

Haier AS71S2SF1FA-WH + 1U71S2SR2FA Flexis Plus Blanc

Haier AS71S2SF1FA-WH + 1U71S2SR2FA Flexis Plus Blanc

Daitsu AUD12KDB Cassette Atlas

Daitsu AUD12KDB Cassette Atlas

Daitsu AUD12KDB Cassette Atlas

Daitsu AUD12KDB Cassette Atlas

Haier AS71S2SF1FA-BH + 1U71S2SR2FA Flexis Plus Noir Mat

Haier AS71S2SF1FA-BH + 1U71S2SR2FA Flexis Plus Noir Mat

Haier AS71S2SF1FA-BH + 1U71S2SR2FA Flexis Plus Noir Mat

Haier AS71S2SF1FA-BH + 1U71S2SR2FA Flexis Plus Noir Mat

Daitsu AUD18KDB Cassette Atlas

Daitsu AUD18KDB Cassette Atlas

Daitsu AUD18KDB Cassette Atlas

Daitsu AUD18KDB Cassette Atlas

Daikin FTXF60D + RXF60D Série Sensira

Daikin FTXF60D + RXF60D Série Sensira

Daikin FTXF60D + RXF60D Série Sensira

Daikin FTXF60D + RXF60D Série Sensira

Daikin FHA60A9 Plafonnier

Daikin FHA60A9 Plafonnier

Daikin FHA60A9 Plafonnier

Daikin FHA60A9 Plafonnier

Daikin FNA35A9 + RXM35A9 Console Non Carrossée

Daikin FNA35A9 + RXM35A9 Console Non Carrossée

Daikin FNA35A9 + RXM35A9 Console Non Carrossée

Daikin FNA35A9 + RXM35A9 Console Non Carrossée

Daikin FNA25A9 + RXM25A9 Console Non Carrossée

Daikin FNA25A9 + RXM25A9 Console Non Carrossée

Daikin FNA25A9 + RXM25A9 Console Non Carrossée

Daikin FNA25A9 + RXM25A9 Console Non Carrossée

Daikin FHA60A9 + RXM60A Plafonnier Apparent

Daikin FHA60A9 + RXM60A Plafonnier Apparent

Daikin FHA60A9 + RXM60A Plafonnier Apparent

Daikin FHA60A9 + RXM60A Plafonnier Apparent

Daikin FNA35A9 + RZAG35B Console Non Carrossée Sky Air Alpha Series

Daikin FNA35A9 + RZAG35B Console Non Carrossée Sky Air Alpha Series

Daikin FNA35A9 + RZAG35B Console Non Carrossée Sky Air Alpha Series

Daikin FNA35A9 + RZAG35B Console Non Carrossée Sky Air Alpha Series

Mitsubishi PCA-M60KA Série Mr.Slim

Mitsubishi PCA-M60KA Série Mr.Slim

Mitsubishi PCA-M60KA Série Mr.Slim

Mitsubishi PCA-M60KA Série Mr.Slim

Mitsubishi MXZ-5F102VF2 R-32

Mitsubishi MXZ-5F102VF2 R-32

Mitsubishi MXZ-5F102VF2 R-32

Mitsubishi MXZ-5F102VF2 R-32

Mitsubishi MXZ-6F120VF2 R-32

Mitsubishi MXZ-6F120VF2 R-32

Mitsubishi MXZ-6F120VF2 R-32

Mitsubishi MXZ-6F120VF2 R-32

Mitsubishi PLA-M125EA2 + PUZ-M125VKA Monophasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-M125VKA Monophasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-M125VKA Monophasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-M125VKA Monophasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-ZM125VKA2 Monophasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-ZM125VKA2 Monophasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-ZM125VKA2 Monophasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-ZM125VKA2 Monophasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-M125YKA Triphasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-M125YKA Triphasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-M125YKA Triphasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-M125YKA Triphasé Cassette 950x950

Mitsubishi PLA-M125EA2 + PUZ-ZM125YKA2 Triphasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-ZM125YKA2 Triphasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-ZM125YKA2 Triphasé Cassette 950x950 Power Inverter

Mitsubishi PLA-M125EA2 + PUZ-ZM125YKA2 Triphasé Cassette 950x950 Power Inverter

Mitsubishi PEAD-M125JA2 + PUZ-ZM125VKA2 Monophasé Gainable Standard Power Inverter

Mitsubishi PEAD-M125JA2 + PUZ-ZM125VKA2 Monophasé Gainable Standard Power Inverter