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

218 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par :

Exclusivité web !

Daitsu ACD42KDB Gainable Atlas

2 322,00 €

Exclusivité web !

Daitsu ACD42KDB Gainable Atlas

2 322,00 €

Exclusivité web !

Daitsu ACD42KDB Gainable Atlas

Climatisation Tertiaire Split Daitsu

Kit climatiseur gainable monophasé 12 kW

2 322,00 €

Load Time	4751 ms
Querying Time	2791 ms
Queries	1526
Memory Peak Usage	52.6 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	72 ms	72 ms	7.32 Mb	8.8 Mb
__construct	0 ms	72 ms	- Mb	8.8 Mb
init	40 ms	113 ms	1.75 Mb	9.2 Mb
checkAccess	0 ms	113 ms	- Mb	9.2 Mb
setMedia	1 ms	113 ms	0.08 Mb	9.2 Mb
postProcess	0 ms	113 ms	- Mb	9.2 Mb
initHeader	0 ms	113 ms	- Mb	9.2 Mb
initContent	2464 ms	2577 ms	15.65 Mb	24.9 Mb
initFooter	0 ms	2577 ms	- Mb	24.9 Mb
display	2174 ms	4751 ms	27.23 Mb	52.6 Mb

Hook	Time	Memory Usage
DisplayHeader	378 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	370 ms	5.32 Mb
=> ets_promotion	2 ms	0.13 Mb
=> payplug	1 ms	- Mb
=> recaptchapro	0 ms	0.01 Mb
DisplayReviewProductList	186 ms	9.95 Mb
=> tvcmsproductcomments	4 ms	0.14 Mb
=> tvcmsproductcomments	2 ms	0.12 Mb
=> tvcmsproductcomments	2 ms	0.12 Mb
=> tvcmsproductcomments	2 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	11 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	10 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	11 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	12 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	11 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.10 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	12 ms	0.13 Mb
=> tvcmsproductcomments	7 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	3 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	5 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	5 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	4 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	4 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	4 ms	0.08 Mb
=> tvcmsproductcomments	5 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	4 ms	0.13 Mb
=> tvcmsproductcomments	4 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	4 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
DisplayLeftColumn	97 ms	3.63 Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	0.03 Mb
=> tvcmsnewproducts	76 ms	3.42 Mb
=> tvcmsspecialproducts	0 ms	- Mb
=> tvcmsfeaturedproducts	0 ms	- Mb
=> tvcmstestimonial	11 ms	0.07 Mb
=> tvcmsbestsellerproducts	0 ms	- Mb
=> ets_cfultimate	10 ms	0.02 Mb
=> ets_promotion	0 ms	0.09 Mb
DisplayWishlistBtnProductList	25 ms	1.00 Mb
=> tvcmswishlist	0 ms	0.02 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
DisplayProductListStockIndicator	23 ms	0.93 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.05 Mb
=> tvcmsstockinfo	10 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	6 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	1 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
DisplayProductCompareProductList	23 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	18 ms	1.27 Mb
=> tvcmsmegamenu	18 ms	1.27 Mb
DisplayBanner	12 ms	0.27 Mb
=> ets_promotion	12 ms	0.27 Mb
displayNavLanguageBlock	6 ms	0.28 Mb
=> ps_languageselector (widget)	6 ms	0.28 Mb
DisplayNavWishlistBlock	4 ms	0.05 Mb
=> tvcmswishlist	4 ms	0.05 Mb
DisplayFooter	4 ms	0.05 Mb
=> ets_cfultimate	4 ms	0.05 Mb
displayMyaccountcblock	4 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	4 ms	0.09 Mb
DisplayNavSearchBlock	3 ms	0.86 Mb
=> tvcmssearch	3 ms	0.86 Mb
DisplayFooterAfter	3 ms	0.12 Mb
=> salesgullcustom	0 ms	0.02 Mb
=> ets_promotion	3 ms	0.10 Mb
displayNavShoppingCartBlock	3 ms	0.14 Mb
=> ps_shoppingcart (widget)	3 ms	0.14 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
displayNavCustomerSignInBlock	2 ms	- Mb
=> ps_customersignin (widget)	2 ms	- Mb
displayNewslettersubscription	2 ms	0.24 Mb
=> ps_emailsubscription (widget)	2 ms	0.24 Mb
displayNav1	2 ms	0.09 Mb
=> ps_contactinfo (widget)	2 ms	0.09 Mb
DisplayNav1	1 ms	0.10 Mb
=> ets_promotion	1 ms	0.10 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
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
DisplayGDPRConsent	1 ms	0.11 Mb
=> psgdpr	1 ms	0.11 Mb
displayContactCinfo	1 ms	0.04 Mb
=> ps_contactinfo (widget)	1 ms	0.04 Mb
displayFooterPart1	1 ms	0.06 Mb
=> ps_linklist (widget)	1 ms	0.06 Mb
ActionDispatcher	0 ms	- Mb
=> recaptchapro	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
DisplayAfterBodyOpeningTag	0 ms	0.01 Mb
=> tvcmscookiesnotice	0 ms	0.01 Mb
DisplayProductComparesticky	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
ProductSearchProvider	0 ms	0.01 Mb
=> ps_facetedsearch	0 ms	0.01 Mb
DisplayNavProductCompareBlock	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayFooterPart2	0 ms	0.03 Mb
=> tvcmsfooterlogo	0 ms	0.03 Mb
DisplayFacetedSearchBlock	0 ms	0.09 Mb
=> ps_facetedsearch	0 ms	0.09 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)	808 ms	26.39 Mb

Module	Time	Memory Usage
payplug	10 ms	0.68 Mb
__construct	7 ms	0.50 Mb
hookDisplayHeader	1 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb
hookDisplayProductPriceBlock	0 ms	- Mb

Query	Time (ms)	Rows	Filesort	Location
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (13335, 13336))) GROUP BY fp.id_feature_value	432791 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	180439 ms	6536	Yes	/classes/Category.php:1057 /modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=28)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	153726 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=50)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	137837 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=22)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	126911 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=32)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	117567 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=34)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	108283 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=46)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	86291 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=23)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	84104 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=40)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	81102 ms	1084243968	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY p.id_manufacturer	61198 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) WHERE ((fp.id_feature_value IN (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=24)) AND ((fp_1.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	49925 ms	7529472	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	47784 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN prstshp_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=47)) AND ((fp_1.id_feature_value IN (13335, 13336))) AND ((fp_2.id_feature_value IN (26229, 26234, 26246, 26255))) GROUP BY fp.id_feature_value	44849 ms	1084243968	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM prstshp_product p INNER JOIN prstshp_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 8) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122	44105 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 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 (26229, 26234, 26246, 26255))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 0) ASC, p.position ASC, p.id_product DESC	43502 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 m.page, ml.url_rewrite, ml.id_lang FROM `prstshp_meta` m LEFT JOIN `prstshp_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	37928 ms	108	Yes	/override/classes/Dispatcher.php:212 /classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 22 ORDER BY vl.`value` ASC	31959 ms	12	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 34 ORDER BY vl.`value` ASC	20485 ms	25	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 23 ORDER BY vl.`value` ASC	19939 ms	5	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE 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` = 46 ORDER BY vl.`value` ASC	17191 ms	5	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position FROM prstshp_feature_product pf LEFT JOIN prstshp_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN prstshp_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN prstshp_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 2656 ORDER BY f.position ASC	12821 ms	18	Yes	/classes/Product.php:5897 /classes/Product.php:5759<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE * FROM `prstshp_currency` c ORDER BY `iso_code` ASC	11374 ms	3	Yes	/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84<br>/src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90<br>/src/Core/Localization/Currency/CurrencyDataSource.php:96<br>/src/Core/Localization/Currency/Repository.php:87<br>/src/Core/Localization/Locale/Repository.php:207<br>/src/Core/Localization/Locale/Repository.php:150<br>/classes/controller/Controller.php:196<br>/classes/controller/FrontController.php:303<br>/controllers/front/listing/CategoryController.php:92<br>/override/controllers/front/CategoryController.php:54<br>/tools/profiling/Controller.php:41<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 50 ORDER BY vl.`value` ASC	11303 ms	6	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = 4507 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	11177 ms	1		/modules/tvcmsproductcomments/tvcmsproductcomment.php:225 /modules/tvcmsproductcomments/tvcmsproductcomments.php:916<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/7c/ea/50/7cea5081043f9339ffdf34c1ebf0d43ccdd395cd_2.file.product-catelog-view.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:54<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `prstshp_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1	11072 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_tax_rules_group` FROM `prstshp_product_shop` WHERE `id_product` = 2591 AND id_shop=1 LIMIT 1	10771 ms	1		/classes/Product.php:6751 /classes/Product.php:3885<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE mainTable.id_tvcmstestimonial AS code, mainTable.image, mainTable.signature_image, mainTable.signature_text, mainTable.link, subTable.title, subTable.designation, subTable.short_description, subTable.description FROM `prstshp_tvcmstestimonial` mainTable LEFT JOIN prstshp_tvcmstestimonial_lang subTable ON mainTable.id_tvcmstestimonial = subTable.id_tvcmstestimonial WHERE mainTable.id_shop_group = 1 AND mainTable.id_shop = 1 AND mainTable.status = 1 AND subTable.id_lang = 3 ORDER BY `position`	10704 ms	1	Yes	/modules/tvcmstestimonial/tvcmstestimonial.php:536 /modules/tvcmstestimonial/tvcmstestimonial.php:1230<br>/modules/tvcmstestimonial/tvcmstestimonial.php:1253<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 name, alias FROM `prstshp_hook_alias`	10596 ms	88		/classes/Hook.php:353 /classes/Hook.php:158<br>/classes/Hook.php:377<br>/classes/Hook.php:400<br>/classes/Hook.php:933<br>/override/classes/Dispatcher.php:176<br>/classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 32 ORDER BY vl.`value` ASC	10575 ms	3	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `prstshp_cart_product` cp WHERE cp.`id_product_attribute` = 4281 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 848 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `prstshp_cart_product` cp JOIN `prstshp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prstshp_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 4281 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 848 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	10314 ms	0		/classes/Cart.php:1429 /classes/Product.php:4277<br>/classes/Product.php:5749<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE 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 (3127) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	10185 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 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 (3125) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	10180 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: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/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: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/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `prstshp_product_shop` WHERE `id_product` = 3755 AND id_shop=1 LIMIT 1	10051 ms	1		/classes/Product.php:6751 /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 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 (3488) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	9936 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 (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = 4496 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	9845 ms	1		/modules/tvcmsproductcomments/tvcmsproductcomment.php:225 /modules/tvcmsproductcomments/tvcmsproductcomments.php:916<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/68/a3/96/68a396aeb56e298dacea825decf9e0373b31f959_2.file.product-grid-view.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: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/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `prstshp_product_shop` WHERE `id_product` = 3077 AND id_shop=1 LIMIT 1	9844 ms	1		/classes/Product.php:6751 /classes/Product.php:3885<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/ProductAssembler.php:117<br>/classes/controller/ProductListingFrontController.php:54<br>:undefined<br>/classes/controller/ProductListingFrontController.php:76<br>/classes/controller/ProductListingFrontController.php:333<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = 3132 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	9815 ms	1		/modules/tvcmsproductcomments/tvcmsproductcomment.php:225 /modules/tvcmsproductcomments/tvcmsproductcomments.php:916<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/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 p.,pl.,r.,rl.name,a. FROM `prstshp_ets_pr_rule` r INNER JOIN `prstshp_ets_pr_action_rule` a ON (r.id_ets_pr_rule = a.id_ets_pr_rule) INNER JOIN `prstshp_ets_pr_promote_rule` p ON (r.id_ets_pr_rule = p.id_ets_pr_rule AND p.way_to_promote="display_highlight_bar" ) LEFT JOIN `prstshp_ets_pr_promote_rule_lang` pl ON (p.id_ets_pr_promote_rule = pl.id_ets_pr_promote_rule AND pl.id_lang="3") LEFT JOIN `prstshp_ets_pr_rule_lang` rl ON (r.id_ets_pr_rule=rl.id_ets_pr_rule AND rl.id_lang="3") WHERE r.active=1 AND (r.from_date ="0000-00-00 00:00:00" or r.from_date <="2025-04-21 19:13:33") AND (r.to_date ="0000-00-00 00:00:00" or r.to_date >="2025-04-21 19:13:33") AND r.id_shop = "1"	9786 ms	28		/modules/ets_promotion/classes/ets_pr_rule.php:142 /modules/ets_promotion/ets_promotion.php:533<br>/modules/ets_promotion/ets_promotion.php:415<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/6f/9e/f5/6f9ef54d45cdcd7619c1ab6ce0a0fa4f18acb53a_2.file.header.tpl.php:43<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: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>/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 (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = 3126 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	9755 ms	1		/modules/tvcmsproductcomments/tvcmsproductcomment.php:225 /modules/tvcmsproductcomments/tvcmsproductcomments.php:916<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/68/a3/96/68a396aeb56e298dacea825decf9e0373b31f959_2.file.product-grid-view.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: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/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39

100 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = <span style="color:blue">XX</span> AND pc.`deleted` = <span style="color:blue">XX</span> AND pc.`validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
100 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = <span style="color:blue">XX</span> AND pc.`deleted` = <span style="color:blue">XX</span> AND pc.`validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
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>
62 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>
62 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>
62 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>
53 queries	SELECT <span style="color:blue">XX</span> FROM `prstshp_specific_price` WHERE id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,<span style="color:blue">XX</span>) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `prstshp_product` p INNER JOIN `prstshp_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) WHERE (p.`id_product` = <span style="color:blue">XX</span>)
52 queries	SELECT * 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>
52 queries	SELECT name FROM prstshp_category_lang WHERE id_shop = <span style="color:blue">XX</span> AND id_lang = <span style="color:blue">XX</span> AND id_category = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT `reduction` FROM `prstshp_product_group_reduction_cache` WHERE `id_product` = <span style="color:blue">XX</span> AND `id_group` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT `id_tax_rules_group` FROM `prstshp_product_shop` WHERE `id_product` = <span style="color:blue">XX</span> AND id_shop=<span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT image_shop.`id_image` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = <span style="color:blue">XX</span>) WHERE i.`id_product` = <span style="color:blue">XX</span> AND image_shop.`cover` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
52 queries	SELECT COUNT(*) FROM `prstshp_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
49 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>
48 queries	SELECT name, value, pf.id_feature, f.position FROM prstshp_feature_product pf LEFT JOIN prstshp_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>) LEFT JOIN prstshp_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = <span style="color:blue">XX</span>) LEFT JOIN prstshp_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = <span style="color:blue">XX</span>) WHERE pf.id_product = <span style="color:blue">XX</span> ORDER BY f.position ASC
46 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>
45 queries	SELECT `priority`, `id_specific_price_priority` FROM `prstshp_specific_price_priority` WHERE `id_product` = <span style="color:blue">XX</span> ORDER BY `id_specific_price_priority` DESC LIMIT <span style="color:blue">XX</span>
28 queries	SELECT `id_product_attribute` FROM `prstshp_product_attribute` WHERE `id_product` = <span style="color:blue">XX</span>
28 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `prstshp_tvcmsproduct_comment` pc WHERE `id_product` = <span style="color:blue">XX</span> AND `validate` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
28 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `prstshp_image` i INNER JOIN prstshp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = <span style="color:blue">XX</span>) WHERE i.`id_product` = <span style="color:blue">XX</span> ORDER BY `position`
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>
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>
12 queries	select count(pa.`id_product_attribute`) as `total` from `prstshp_product_attribute` pa inner join `prstshp_product_attribute_shop` pas on pa.id_product_attribute = pas.id_product_attribute where pas.`id_shop` = <span style="color:blue">XX</span> and pa.`id_product` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
10 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, <span style="color:blue">XX</span>) = sa.id_product_attribute AND sa.id_shop = <span style="color:blue">XX</span> AND sa.id_shop_group = <span style="color:blue">XX</span> ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = <span style="color:blue">XX</span> AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=<span style="color:blue">XX</span>) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ps.id_shop='<span style="color:blue">XX</span>' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='<span style="color:blue">XX</span>' AND c.nleft>=<span style="color:blue">XX</span> AND c.nright<=<span style="color:blue">XX</span> GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature=<span style="color:blue">XX</span>)) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) GROUP BY fp.id_feature_value
10 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>
10 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>
10 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>
10 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>
10 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>
7 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `prstshp_product_attribute_image` pai LEFT JOIN `prstshp_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `prstshp_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>) AND il.`id_lang` = <span style="color:blue">XX</span> ORDER by i.`position`
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_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	417	/config/config.inc.php [249] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37] /override/classes/tax/TaxCalculator.php [37]
Category	103	/controllers/front/listing/CategoryController.php [89] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /classes/Meta.php [380] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/ps_facetedsearch/src/Product/Search.php [364] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmssearch/tvcmssearch.php [101] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98]
Product	80	/classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /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] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114]
Combination	52	/classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802] /classes/Product.php [5802]
Country	7	/config/config.inc.php [157] /classes/AddressFormat.php [404] /classes/controller/FrontController.php [1677] /classes/AddressFormat.php [404] /modules/ps_contactinfo/ps_contactinfo.php [105] /classes/AddressFormat.php [404] /modules/ps_contactinfo/ps_contactinfo.php [105]
Address	6	/modules/payplug/src/application/adapter/AddressAdapter.php [38] /classes/shop/Shop.php [469] /classes/Product.php [3654] /classes/Product.php [3764] /classes/Product.php [5840] /modules/payplug/src/application/adapter/AddressAdapter.php [38]
Currency	5	/src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /src/Adapter/Currency/CurrencyDataProvider.php [101] /classes/Tools.php [700] /modules/lggoogleanalytics/lggoogleanalytics.php [1679]
Configuration	4	/src/Core/Addon/Theme/Theme.php [42] /modules/payplug/src/application/adapter/ConfigurationAdapter.php [38] /src/Core/Addon/Theme/Theme.php [42] /modules/payplug/src/application/adapter/ConfigurationAdapter.php [38]
AddressFormat	3	/classes/controller/FrontController.php [1671] /modules/ps_contactinfo/ps_contactinfo.php [91] /modules/ps_contactinfo/ps_contactinfo.php [91]
Cart	3	/modules/payplug/src/application/adapter/CartAdapter.php [38] /classes/controller/FrontController.php [443] /modules/payplug/src/application/adapter/CartAdapter.php [38]
State	3	/classes/controller/FrontController.php [1676] /modules/ps_contactinfo/ps_contactinfo.php [94] /modules/ps_contactinfo/ps_contactinfo.php [94]
OrderState	2	/modules/payplug/src/application/adapter/OrderStateAdapter.php [38] /modules/payplug/src/application/adapter/OrderStateAdapter.php [38]
Language	2	/config/config.inc.php [222] /classes/Tools.php [581]
Carrier	2	/modules/payplug/src/application/adapter/CarrierAdapter.php [45] /modules/payplug/src/application/adapter/CarrierAdapter.php [45]
Tax	2	/classes/tax/TaxRulesTaxManager.php [116] /classes/tax/TaxRulesTaxManager.php [116]
CartRule	2	/modules/payplug/src/application/adapter/CartRuleAdapter.php [38] /modules/payplug/src/application/adapter/CartRuleAdapter.php [38]
Shop	1	/config/config.inc.php [128]
Risk	1	/classes/controller/FrontController.php [1609]
Gender	1	/classes/controller/FrontController.php [1606]
Group	1	/classes/Cart.php [248]
ShopGroup	1	/classes/shop/Shop.php [557]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php [1365]

Daikin FHA71A9 Plafonnier

Daikin FHA50A9 Plafonnier

Daikin FHA35A9 Plafonnier

Daikin FHA60A9 Plafonnier

Climatisation

Achetez Climatiseurs en Ligne

Daitsu ACD42KDB Gainable Atlas

Daitsu ACD42KDB Gainable Atlas

Daitsu ACD42KDB Gainable Atlas

Daitsu ACD42KDB Gainable Atlas

Daitsu ACD42TKDB Gainable Atlas Triphasé

Daitsu ACD42TKDB Gainable Atlas Triphasé

Daitsu ACD42TKDB Gainable Atlas Triphasé

Daitsu ACD42TKDB Gainable Atlas Triphasé

Daitsu ACD48KDB Gainable Atlas

Daitsu ACD48KDB Gainable Atlas

Daitsu ACD48KDB Gainable Atlas

Daitsu ACD48KDB Gainable Atlas

Daitsu ACD48TKDB Gainable Atlas Triphasé

Daitsu ACD48TKDB Gainable Atlas Triphasé

Daitsu ACD48TKDB Gainable Atlas Triphasé

Daitsu ACD48TKDB Gainable Atlas Triphasé

Daitsu ACD60TKDB Gainable Atlas Triphasé

Daitsu ACD60TKDB Gainable Atlas Triphasé

Daitsu ACD60TKDB Gainable Atlas Triphasé

Daitsu ACD60TKDB Gainable Atlas Triphasé

Daitsu AUD24KDB Cassette Atlas

Daitsu AUD24KDB Cassette Atlas

Daitsu AUD24KDB Cassette Atlas

Daitsu AUD24KDB Cassette Atlas

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daitsu AUD60TKDB Cassette Atlas Triphasé

Daikin FTXM50A + RXM50A9 Perfera All Seasons

Daikin FTXM50A + RXM50A9 Perfera All Seasons

Daikin FTXM50A + RXM50A9 Perfera All Seasons

Daikin FTXM50A + RXM50A9 Perfera All Seasons

Daikin FVXM25B + RXM25A9 Série Perfera

Daikin FVXM25B + RXM25A9 Série Perfera

Daikin FVXM25B + RXM25A9 Série Perfera

Daikin FVXM25B + RXM25A9 Série Perfera

Daikin FVXM50B + RXM50A9 Série Perfera

Daikin FVXM50B + RXM50A9 Série Perfera

Daikin FVXM50B + RXM50A9 Série Perfera

Daikin FVXM50B + RXM50A9 Série Perfera

Daikin FTXP50N + RXP50N Série Comfora

Daikin FTXP50N + RXP50N Série Comfora

Daikin FTXP50N + RXP50N Série Comfora

Daikin FTXP50N + RXP50N Série Comfora

Daikin FTXF42E + RXF42E Série Sensira

Daikin FTXF42E + RXF42E Série Sensira

Daikin FTXF42E + RXF42E Série Sensira

Daikin FTXF42E + RXF42E Série Sensira

Daikin FTXM50A Perfera All Seasons

Daikin FTXM50A Perfera All Seasons

Daikin FTXM50A Perfera All Seasons

Daikin FTXM50A Perfera All Seasons

Daikin CVXM20A9 Série Perfera

Daikin CVXM20A9 Série Perfera

Daikin CVXM20A9 Série Perfera

Daikin CVXM20A9 Série Perfera

Daikin FVXM50B Série Perfera

Daikin FVXM50B Série Perfera

Daikin FVXM50B Série Perfera

Daikin FVXM50B Série Perfera

Daikin FDXM25F9

Daikin FDXM25F9

Daikin FDXM25F9

Daikin FDXM25F9

Daikin FDXM35F9

Daikin FDXM35F9

Daikin FDXM35F9

Daikin FDXM35F9

Daikin FFA50A9 Série Fully Flat

Daikin FFA50A9 Série Fully Flat

Daikin FFA50A9 Série Fully Flat

Daikin FFA50A9 Série Fully Flat

Daikin FCAG35B Série Round Flow

Daikin FCAG35B Série Round Flow