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

179 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par :

1 472,40 €

Load Time	1154 ms
Querying Time	874 ms
Queries	1456
Memory Peak Usage	51.8 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	13 ms	13 ms	7.32 Mb	8.8 Mb
__construct	0 ms	13 ms	- Mb	8.8 Mb
init	17 ms	30 ms	1.75 Mb	9.2 Mb
checkAccess	0 ms	30 ms	- Mb	9.2 Mb
setMedia	1 ms	31 ms	0.08 Mb	9.2 Mb
postProcess	0 ms	31 ms	- Mb	9.2 Mb
initHeader	0 ms	31 ms	- Mb	9.2 Mb
initContent	826 ms	856 ms	15.23 Mb	24.5 Mb
initFooter	0 ms	856 ms	- Mb	24.5 Mb
display	298 ms	1154 ms	26.89 Mb	51.8 Mb

Hook	Time	Memory Usage
DisplayHeader	161 ms	5.59 Mb
=> jprestaspeedpack	0 ms	- Mb
=> tvcmscustomsetting	0 ms	0.01 Mb
=> tvcmstabproducts	0 ms	- Mb
=> tvcmsbestsellerproducts	0 ms	- Mb
=> tvcmsbrandlist	0 ms	- Mb
=> tvcmscookiesnotice	0 ms	- Mb
=> tvcmscustomerservices	0 ms	- Mb
=> tvcmsfeaturedproducts	0 ms	- Mb
=> tvcmsfooterlogo	0 ms	- Mb
=> tvcmsmultibanner1	0 ms	- Mb
=> tvcmsnewproducts	0 ms	- Mb
=> tvcmsnewsletterpopup	0 ms	- Mb
=> tvcmspaymenticon	0 ms	- Mb
=> tvcmsproductcomments	0 ms	- Mb
=> tvcmsproductcompare	0 ms	- Mb
=> tvcmssearch	0 ms	- Mb
=> tvcmssingleblock	0 ms	- Mb
=> tvcmsslider	0 ms	- Mb
=> tvcmsspecialproducts	0 ms	- Mb
=> tvcmstestimonial	0 ms	- Mb
=> tvcmsthemeoptions	0 ms	- Mb
=> tvcmswishlist	0 ms	- Mb
=> ps_shoppingcart	0 ms	- Mb
=> ps_searchbar	0 ms	0.06 Mb
=> ets_cfultimate	1 ms	0.05 Mb
=> lggoogleanalytics	156 ms	5.32 Mb
=> ets_promotion	2 ms	0.13 Mb
=> payplug	1 ms	- Mb
=> recaptchapro	0 ms	0.01 Mb
DisplayReviewProductList	95 ms	9.93 Mb
=> tvcmsproductcomments	1 ms	0.14 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	9 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	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	9 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	60 ms	3.68 Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	0.03 Mb
=> tvcmsnewproducts	58 ms	3.47 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	0 ms	0.09 Mb
DisplayWishlistBtnProductList	23 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	22 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
DisplayMegamenu	9 ms	1.30 Mb
=> tvcmsmegamenu	9 ms	1.30 Mb
DisplayProductListStockIndicator	4 ms	0.52 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.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.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.03 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.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
DisplayNavSearchBlock	3 ms	0.86 Mb
=> tvcmssearch	3 ms	0.86 Mb
displayNavLanguageBlock	2 ms	0.28 Mb
=> ps_languageselector (widget)	2 ms	0.28 Mb
DisplayCustomsocialblock	2 ms	0.28 Mb
=> tvcmscustomsetting	2 ms	0.28 Mb
Header	2 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
DisplayBanner	2 ms	0.27 Mb
=> ets_promotion	2 ms	0.27 Mb
displayNewslettersubscription	2 ms	0.24 Mb
=> ps_emailsubscription (widget)	2 ms	0.24 Mb
DisplayProductPriceBlock	1 ms	0.11 Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
displayNavShoppingCartBlock	1 ms	0.14 Mb
=> ps_shoppingcart (widget)	1 ms	0.14 Mb
displayFooterPart2	1 ms	0.09 Mb
=> ps_linklist (widget)	1 ms	0.09 Mb
DisplayNavWishlistBlocksticky	1 ms	0.06 Mb
=> tvcmswishlist	1 ms	0.06 Mb
displayNav1	1 ms	0.09 Mb
=> ps_contactinfo (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
DisplayNavWishlistBlock	1 ms	0.05 Mb
=> tvcmswishlist	1 ms	0.05 Mb
DisplayFooterAfter	1 ms	0.12 Mb
=> salesgullcustom	0 ms	0.02 Mb
=> ets_promotion	1 ms	0.10 Mb
displayContactCinfo	1 ms	0.04 Mb
=> ps_contactinfo (widget)	1 ms	0.04 Mb
DisplayFooter	1 ms	0.05 Mb
=> ets_cfultimate	1 ms	0.05 Mb
displayNavCustomerSignInBlock	1 ms	- Mb
=> ps_customersignin (widget)	1 ms	- Mb
displayFooterPart1	1 ms	0.06 Mb
=> ps_linklist (widget)	1 ms	0.06 Mb
DisplayNav1	1 ms	0.10 Mb
=> ets_promotion	1 ms	0.10 Mb
DisplayProductComparesticky	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayFooterPart2	0 ms	0.03 Mb
=> tvcmsfooterlogo	0 ms	0.03 Mb
DisplayNavProductCompareBlock	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0 ms	0.01 Mb
=> tvcmscookiesnotice	0 ms	0.01 Mb
ProductSearchProvider	0 ms	0.01 Mb
=> ps_facetedsearch	0 ms	0.01 Mb
DisplayFacetedSearchBlock	0 ms	0.09 Mb
=> ps_facetedsearch	0 ms	0.09 Mb
ActionDispatcher	0 ms	- Mb
=> recaptchapro	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ActionFrontControllerSetMedia	0 ms	- Mb
=> ps_emailsubscription	0 ms	- Mb
=> ps_emailalerts	0 ms	- Mb
ActionOutputHTMLBefore	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ActionDispatcherBefore	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ModuleRoutes	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
DisplayTopOfferText	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
DisplayCustomJs	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayCustomCss	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayBodyBackgroundBody	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
DisplayOverrideTemplate	0 ms	- Mb
=> ets_promotion	0 ms	- Mb
43 hook(s)	400 ms	26.05 Mb

Module	Time	Memory Usage
payplug	5 ms	0.68 Mb
__construct	3 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	105375 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	42691 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 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 (26228, 32379, 26233, 26248, 26256))) 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	41566 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 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY p.id_manufacturer	36469 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	33460 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	33310 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	33159 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	33138 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	32999 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	32944 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	31620 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 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 (26228, 32379, 26233, 26248, 26256))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122	21876 ms	941184			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57<br>/modules/ps_facetedsearch/src/Filters/Block.php:250<br>/modules/ps_facetedsearch/src/Filters/Block.php:131<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	19732 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	19697 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	18176 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 (26228, 32379, 26233, 26248, 26256))) 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 (26228, 32379, 26233, 26248, 26256))) GROUP BY fp.id_feature_value	17914 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 (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` = 1625 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	8829 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:213 /modules/tvcmsproductcomments/tvcmsproductcomments.php:922<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/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:32<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.`available_date` FROM `prstshp_product` p LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 4588 AND pa.`id_product` = 4588 AND pa.`id_product_attribute` = 7824 LIMIT 1	8224 ms	1			/classes/Product.php:1135 /classes/Product.php:5753<br>/classes/Product.php:5866<br>/classes/Product.php:3096<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 (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` = 4587 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	8048 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:213 /modules/tvcmsproductcomments/tvcmsproductcomments.php:922<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_salesgull/71/c1/07/71c1072fd10a49ebdc9f8bdaaa1f0736a679be1e_2.file.side-product.tpl.php:120<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_salesgull/71/c1/07/71c1072fd10a49ebdc9f8bdaaa1f0736a679be1e_2.file.side-product.tpl.php:26<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_salesgull/86/e0/6f/86e06f85fc11b279fe80623aceb721c1207c5048_2.module.tvcmsnewproductsviewstemp.php:32<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_salesgull/ee/91/ed/ee91ed138212b785145e5969e2ec25ac2f1d8520_2.file.display_left.tpl.php:26<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/SmartyCustomTemplate.php:44<br>/classes/module/Module.php:2449<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:260<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 COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `prstshp_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1	5418 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	5108 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 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`)	3274 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 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	3211 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	2499 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	2100 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 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`	1907 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 1 FROM `prstshp_specific_price` WHERE id_product = 4590 LIMIT 1	1130 ms	5			/classes/SpecificPrice.php:420 /classes/SpecificPrice.php:508<br>/classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Product.php:3096<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 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	870 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 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	861 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 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 (1625) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	688 ms	1	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` = 6 ORDER BY vl.`value` ASC	678 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 lower(name) as name FROM `prstshp_hook` h WHERE (h.active = 1)	636 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 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	603 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 *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 2664 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	555 ms	5	Yes		/classes/SpecificPrice.php:561 /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 *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4590 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	539 ms	5	Yes		/classes/SpecificPrice.php:561 /classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Product.php:3096<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 *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4588 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	527 ms	5	Yes		/classes/SpecificPrice.php:561 /classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Product.php:3096<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 *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 3761 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	521 ms	6	Yes		/classes/SpecificPrice.php:561 /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 *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4587 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	518 ms	5	Yes		/classes/SpecificPrice.php:561 /classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Product.php:3096<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 *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 2, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 2) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 4590 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-21 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	516 ms	5	Yes		/classes/SpecificPrice.php:561 /classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5668<br>/classes/Product.php:5866<br>/classes/Product.php:3096<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 `id_hook`, `name` FROM `prstshp_hook`	515 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

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>
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>
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>
55 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>
55 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>
55 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>
52 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>
51 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>
51 queries	SELECT * FROM `prstshp_product` a LEFT JOIN `prstshp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = <span style="color:blue">XX</span> LEFT JOIN `prstshp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_product` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
51 queries	SELECT 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>)
51 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>
51 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>
51 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>
51 queries	SELECT COUNT(*) FROM `prstshp_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
51 queries	SELECT * FROM prstshp_product_attachment pa LEFT JOIN prstshp_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN prstshp_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = <span style="color:blue">XX</span>) WHERE pa.id_product = <span style="color:blue">XX</span>
49 queries	SELECT *, ( IF (`id_group` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_country` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_currency` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_shop` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) + IF (`id_customer` = <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>)) AS `score` FROM `prstshp_specific_price` WHERE `id_shop` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_currency` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_country` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_group` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND `id_product` = <span style="color:blue">XX</span> AND `id_customer` = <span style="color:blue">XX</span> AND `id_product_attribute` = <span style="color:blue">XX</span> AND `id_cart` = <span style="color:blue">XX</span> AND (`from` = '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' OR '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' >= `from`) AND (`to` = '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' OR '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>' <= `to`) AND IF(`from_quantity` > <span style="color:blue">XX</span>, `from_quantity`, <span style="color:blue">XX</span>) <= <span style="color:blue">XX</span> ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT <span style="color:blue">XX</span>
48 queries	SELECT `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>
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
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`
28 queries	SELECT `id_product_attribute` FROM `prstshp_product_attribute` WHERE `id_product` = <span style="color:blue">XX</span>
28 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `prstshp_tvcmsproduct_comment` pc WHERE `id_product` = <span style="color:blue">XX</span> AND `validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
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>
14 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = <span style="color:blue">XX</span>) WHERE v.`id_feature` = <span style="color:blue">XX</span> ORDER BY vl.`value` ASC
12 queries	SELECT * FROM `prstshp_category` a LEFT JOIN `prstshp_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = <span style="color:blue">XX</span> LEFT JOIN `prstshp_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_category` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
10 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, <span style="color:blue">XX</span>) = sa.id_product_attribute AND sa.id_shop = <span style="color:blue">XX</span> AND sa.id_shop_group = <span style="color:blue">XX</span> ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = <span style="color:blue">XX</span> AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=<span style="color:blue">XX</span>) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ps.id_shop='<span style="color:blue">XX</span>' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='<span style="color:blue">XX</span>' AND c.nleft>=<span style="color:blue">XX</span> AND c.nright<=<span style="color:blue">XX</span> GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature=<span style="color:blue">XX</span>)) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) GROUP BY fp.id_feature_value
6 queries	SELECT `id_lang` FROM `prstshp_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT <span style="color:blue">XX</span>
5 queries	SELECT * FROM prstshp_hook_module WHERE `id_hook` = <span style="color:blue">XX</span> AND `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span>
4 queries	SELECT id_meta FROM prstshp_meta WHERE page = "category" LIMIT <span style="color:blue">XX</span>
4 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>
4 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>
4 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>
4 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>
4 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>
4 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>
4 queries	SELECT id_category FROM prstshp_category_lang WHERE link_rewrite = "climatisation" AND id_lang = <span style="color:blue">XX</span> AND id_shop = <span style="color:blue">XX</span> LIMIT <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	409	/config/config.inc.php [249] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37]
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	73	/classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /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] /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	51	/classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802]
Country	7	/config/config.inc.php [157] /classes/AddressFormat.php [404] /classes/controller/FrontController.php [1677] /classes/AddressFormat.php [404] /modules/ps_contactinfo/ps_contactinfo.php [105] /classes/AddressFormat.php [404] /modules/ps_contactinfo/ps_contactinfo.php [105]
Address	6	/modules/payplug/src/application/adapter/AddressAdapter.php [38] /classes/shop/Shop.php [469] /classes/Product.php [3654] /classes/Product.php [3764] /classes/Product.php [5840] /modules/payplug/src/application/adapter/AddressAdapter.php [38]
Currency	5	/src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /classes/Tools.php [700] /modules/lggoogleanalytics/lggoogleanalytics.php [1679]
Configuration	4	/src/Core/Addon/Theme/Theme.php [42] /modules/payplug/src/application/adapter/ConfigurationAdapter.php [38] /src/Core/Addon/Theme/Theme.php [42] /modules/payplug/src/application/adapter/ConfigurationAdapter.php [38]
AddressFormat	3	/classes/controller/FrontController.php [1671] /modules/ps_contactinfo/ps_contactinfo.php [91] /modules/ps_contactinfo/ps_contactinfo.php [91]
Cart	3	/modules/payplug/src/application/adapter/CartAdapter.php [38] /classes/controller/FrontController.php [443] /modules/payplug/src/application/adapter/CartAdapter.php [38]
State	3	/classes/controller/FrontController.php [1676] /modules/ps_contactinfo/ps_contactinfo.php [94] /modules/ps_contactinfo/ps_contactinfo.php [94]
OrderState	2	/modules/payplug/src/application/adapter/OrderStateAdapter.php [38] /modules/payplug/src/application/adapter/OrderStateAdapter.php [38]
Language	2	/config/config.inc.php [222] /classes/Tools.php [581]
Carrier	2	/modules/payplug/src/application/adapter/CarrierAdapter.php [45] /modules/payplug/src/application/adapter/CarrierAdapter.php [45]
Tax	2	/classes/tax/TaxRulesTaxManager.php [116] /classes/tax/TaxRulesTaxManager.php [116]
CartRule	2	/modules/payplug/src/application/adapter/CartRuleAdapter.php [38] /modules/payplug/src/application/adapter/CartRuleAdapter.php [38]
Shop	1	/config/config.inc.php [128]
Risk	1	/classes/controller/FrontController.php [1609]
Gender	1	/classes/controller/FrontController.php [1606]
Group	1	/classes/Cart.php [248]
ShopGroup	1	/classes/shop/Shop.php [557]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php [1365]

Daikin FHA71A9 Plafonnier

Daikin FHA50A9 Plafonnier

Daikin FHA35A9 Plafonnier

Daikin FHA60A9 Plafonnier

Climatisation

Achetez Climatiseurs en Ligne

Daitsu ABD24KDB Plafonnier Atlas

Daitsu ABD24KDB Plafonnier Atlas

Daitsu ABD24KDB Plafonnier Atlas

Daitsu ABD24KDB Plafonnier Atlas

Daitsu ABD30KDB Plafonnier Atlas

Daitsu ABD30KDB Plafonnier Atlas

Daitsu ABD30KDB Plafonnier Atlas

Daitsu ABD30KDB Plafonnier Atlas

Haier AS50XCAHRA + 1U50S2SJ2FA Expert Plus

Haier AS50XCAHRA + 1U50S2SJ2FA Expert Plus

Haier AS50XCAHRA + 1U50S2SJ2FA Expert Plus

Haier AS50XCAHRA + 1U50S2SJ2FA Expert Plus

Daitsu AUD30KDB Cassette Atlas

Daitsu AUD30KDB Cassette Atlas

Daitsu AUD30KDB Cassette Atlas

Daitsu AUD30KDB Cassette Atlas

Haier AF35S2SD1FA(D) + 1U35S2SM1FA-2 Console Blanc

Haier AF35S2SD1FA(D) + 1U35S2SM1FA-2 Console Blanc

Haier AF35S2SD1FA(D) + 1U35S2SM1FA-2 Console Blanc

Haier AF35S2SD1FA(D) + 1U35S2SM1FA-2 Console Blanc

Haier AF50S2SD1FA(D) + 1U50S2SJ2FA-2 Console Blanc

Haier AF50S2SD1FA(D) + 1U50S2SJ2FA-2 Console Blanc

Haier AF50S2SD1FA(D) + 1U50S2SJ2FA-2 Console Blanc

Haier AF50S2SD1FA(D) + 1U50S2SJ2FA-2 Console Blanc

Haier AF42S2SD1FA(D) + 1U42S2SM1FA Console Blanc

Haier AF42S2SD1FA(D) + 1U42S2SM1FA Console Blanc

Haier AF42S2SD1FA(D) + 1U42S2SM1FA Console Blanc

Haier AF42S2SD1FA(D) + 1U42S2SM1FA Console Blanc

Daikin FTXJ42AW + RXJ42A Série Emura 3 Blanc

Daikin FTXJ42AW + RXJ42A Série Emura 3 Blanc

Daikin FTXJ42AW + RXJ42A Série Emura 3 Blanc

Daikin FTXJ42AW + RXJ42A Série Emura 3 Blanc

Daikin FTXJ42AS + RXJ42A Série Emura 3 Argent

Daikin FTXJ42AS + RXJ42A Série Emura 3 Argent

Daikin FTXJ42AS + RXJ42A Série Emura 3 Argent

Daikin FTXJ42AS + RXJ42A Série Emura 3 Argent

Daikin FTXJ42AB + RXJ42A Série Emura 3 Noir mat

Daikin FTXJ42AB + RXJ42A Série Emura 3 Noir mat

Daikin FTXJ42AB + RXJ42A Série Emura 3 Noir mat

Daikin FTXJ42AB + RXJ42A Série Emura 3 Noir mat

Daikin FTXM42A + RXM42A Perfera All Seasons

Daikin FTXM42A + RXM42A Perfera All Seasons

Daikin FTXM42A + RXM42A Perfera All Seasons

Daikin FTXM42A + RXM42A Perfera All Seasons

Daikin FTXA42CW + RXA42B9 Série Stylish Blanc

Daikin FTXA42CW + RXA42B9 Série Stylish Blanc

Daikin FTXA42CW + RXA42B9 Série Stylish Blanc

Daikin FTXA42CW + RXA42B9 Série Stylish Blanc

Daikin FTXA42CS + RXA42B9 Série Stylish Argent

Daikin FTXA42CS + RXA42B9 Série Stylish Argent

Daikin FTXA42CS + RXA42B9 Série Stylish Argent

Daikin FTXA42CS + RXA42B9 Série Stylish Argent

Daikin FTXA42CB + RXA42B9 Série Stylish Noir

Daikin FTXA42CB + RXA42B9 Série Stylish Noir

Daikin FTXA42CB + RXA42B9 Série Stylish Noir

Daikin FTXA42CB + RXA42B9 Série Stylish Noir

Daikin FTXA42BT + RXA42B Série Stylish Blackwood

Daikin FTXA42BT + RXA42B Série Stylish Blackwood

Daikin FTXA42BT + RXA42B Série Stylish Blackwood

Daikin FTXA42BT + RXA42B Série Stylish Blackwood

Daikin FTXJ42AW Série Emura 3 Blanc

Daikin FTXJ42AW Série Emura 3 Blanc

Daikin FTXJ42AW Série Emura 3 Blanc

Daikin FTXJ42AW Série Emura 3 Blanc

Daikin FTXJ42AS Série Emura 3 Argent

Daikin FTXJ42AS Série Emura 3 Argent

Daikin FTXJ42AS Série Emura 3 Argent

Daikin FTXJ42AS Série Emura 3 Argent

Daikin FTXJ42AB Série Emura 3 Noir mat

Daikin FTXJ42AB Série Emura 3 Noir mat

Daikin FTXJ42AB Série Emura 3 Noir mat

Daikin FTXJ42AB Série Emura 3 Noir mat

Daikin FTXM42A Perfera All Seasons

Daikin FTXM42A Perfera All Seasons