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

253 produits

Grille

Grille-2

Liste

Liste-2

Catalogue

Trier par :

Candy CY-18RAIN + CY-18RAOUT Mural Pura

751,20 €

Candy CY-18RAIN + CY-18RAOUT Mural Pura

751,20 €

Candy CY-18RAIN + CY-18RAOUT Mural Pura

Climatisation Mono-Split Candy

Kit climatiseur mural Mono-Split inverter réversible 5 kW

751,20 €

Load Time	1674 ms
Querying Time	1360 ms
Queries	1515
Memory Peak Usage	52.9 Mb
Included Files	1286 files - 14.54 Mb
PrestaShop Cache	- Mb
Global vars	0.96 Mb
- global $_MODULES	577k
- global $context	377k
- global $__composer_autoload_files	10k
- global $_SERVER	8k
- global $exportPhpConfigFile	4k
- global $config	3k
- global $jprestaWebpConverterOptions	2k
- global $_COOKIE	1k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	21 ms	21 ms	7.32 Mb	8.8 Mb
__construct	0 ms	21 ms	- Mb	8.8 Mb
init	20 ms	41 ms	1.75 Mb	9.2 Mb
checkAccess	0 ms	41 ms	- Mb	9.2 Mb
setMedia	1 ms	42 ms	0.08 Mb	9.2 Mb
postProcess	0 ms	42 ms	- Mb	9.2 Mb
initHeader	0 ms	42 ms	- Mb	9.2 Mb
initContent	1332 ms	1374 ms	15.44 Mb	24.7 Mb
initFooter	0 ms	1374 ms	- Mb	24.7 Mb
display	300 ms	1674 ms	27.73 Mb	52.9 Mb

Hook	Time	Memory Usage
DisplayHeader	223 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	216 ms	5.32 Mb
=> ets_promotion	2 ms	0.13 Mb
=> payplug	1 ms	- Mb
=> recaptchapro	0 ms	0.01 Mb
DisplayReviewProductList	88 ms	9.93 Mb
=> tvcmsproductcomments	1 ms	0.14 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.12 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	8 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
=> tvcmsproductcomments	1 ms	0.13 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.09 Mb
=> tvcmsproductcomments	1 ms	0.08 Mb
DisplayLeftColumn	43 ms	3.63 Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	0.03 Mb
=> tvcmsnewproducts	40 ms	3.42 Mb
=> tvcmsspecialproducts	0 ms	- Mb
=> tvcmsfeaturedproducts	0 ms	- Mb
=> tvcmstestimonial	1 ms	0.07 Mb
=> tvcmsbestsellerproducts	0 ms	- Mb
=> ets_cfultimate	0 ms	0.02 Mb
=> ets_promotion	1 ms	0.09 Mb
DisplayWishlistBtnProductList	24 ms	1.00 Mb
=> tvcmswishlist	0 ms	0.02 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	0.01 Mb
=> tvcmswishlist	0 ms	- Mb
DisplayProductCompareProductList	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
DisplayProductListStockIndicator	11 ms	1.38 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	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.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.03 Mb
=> tvcmsstockinfo	0 ms	0.01 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	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.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
=> tvcmsstockinfo	0 ms	0.05 Mb
DisplayMegamenu	10 ms	1.28 Mb
=> tvcmsmegamenu	10 ms	1.28 Mb
DisplayNavSearchBlock	3 ms	0.86 Mb
=> tvcmssearch	3 ms	0.86 Mb
displayNavLanguageBlock	3 ms	0.31 Mb
=> ps_languageselector (widget)	3 ms	0.31 Mb
DisplayBanner	3 ms	0.26 Mb
=> ets_promotion	3 ms	0.26 Mb
Header	3 ms	0.10 Mb
=> tvcmsstockinfo	0 ms	- Mb
=> tvcmsinfinitescroll	2 ms	0.09 Mb
=> tvcmsofferbanner	0 ms	- Mb
=> tvcmssliderofferbanner	0 ms	- Mb
=> tvcmsverticalmenu	0 ms	- Mb
=> tvcmsleftsideofferbanner	0 ms	- Mb
=> tvcmstwoofferbanner	0 ms	- Mb
=> tvcmsmegamenu	0 ms	- Mb
DisplayCustomsocialblock	2 ms	0.28 Mb
=> tvcmscustomsetting	2 ms	0.28 Mb
displayNewslettersubscription	2 ms	0.24 Mb
=> ps_emailsubscription (widget)	2 ms	0.24 Mb
displayNavShoppingCartBlock	1 ms	0.14 Mb
=> ps_shoppingcart (widget)	1 ms	0.14 Mb
DisplayProductPriceBlock	1 ms	0.11 Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
=> payplug	0 ms	- Mb
displayFooterPart2	1 ms	0.09 Mb
=> ps_linklist (widget)	1 ms	0.09 Mb
displayNav1	1 ms	0.09 Mb
=> ps_contactinfo (widget)	1 ms	0.09 Mb
DisplayNavWishlistBlocksticky	1 ms	0.06 Mb
=> tvcmswishlist	1 ms	0.06 Mb
displayMyaccountcblock	1 ms	0.09 Mb
=> ps_customeraccountlinks (widget)	1 ms	0.09 Mb
DisplayNavWishlistBlock	1 ms	0.05 Mb
=> tvcmswishlist	1 ms	0.05 Mb
DisplayGDPRConsent	1 ms	0.11 Mb
=> psgdpr	1 ms	0.11 Mb
DisplayFooterAfter	1 ms	0.12 Mb
=> salesgullcustom	0 ms	0.02 Mb
=> ets_promotion	1 ms	0.10 Mb
displayContactCinfo	1 ms	0.04 Mb
=> ps_contactinfo (widget)	1 ms	0.04 Mb
DisplayFooter	1 ms	0.05 Mb
=> ets_cfultimate	1 ms	0.05 Mb
displayNavCustomerSignInBlock	1 ms	- Mb
=> ps_customersignin (widget)	1 ms	- Mb
displayFooterPart1	1 ms	0.06 Mb
=> ps_linklist (widget)	1 ms	0.06 Mb
DisplayNav1	1 ms	0.10 Mb
=> ets_promotion	1 ms	0.10 Mb
DisplayAfterBodyOpeningTag	0 ms	0.01 Mb
=> tvcmscookiesnotice	0 ms	0.01 Mb
DisplayNavProductCompareBlock	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
ProductSearchProvider	0 ms	0.01 Mb
=> ps_facetedsearch	0 ms	0.01 Mb
DisplayProductComparesticky	0 ms	0.01 Mb
=> tvcmsproductcompare	0 ms	0.01 Mb
DisplayFooterPart2	0 ms	0.03 Mb
=> tvcmsfooterlogo	0 ms	0.03 Mb
DisplayFacetedSearchBlock	0 ms	0.09 Mb
=> ps_facetedsearch	0 ms	0.09 Mb
ActionDispatcher	0 ms	- Mb
=> recaptchapro	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ActionFrontControllerSetMedia	0 ms	- Mb
=> ps_emailsubscription	0 ms	- Mb
=> ps_emailalerts	0 ms	- Mb
ActionDispatcherBefore	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ActionOutputHTMLBefore	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
=> jprestaspeedpack	0 ms	- Mb
ModuleRoutes	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
=> ets_cfultimate	0 ms	- Mb
DisplayTopOfferText	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
DisplayCustomJs	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayCustomCss	0 ms	- Mb
=> tvcmscustomcssjs	0 ms	- Mb
DisplayBodyBackgroundBody	0 ms	- Mb
=> tvcmscustomsetting	0 ms	- Mb
DisplayOverrideTemplate	0 ms	- Mb
=> ets_promotion	0 ms	- Mb
43 hook(s)	451 ms	26.85 Mb

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

Query	Time (ms)	Rows	Filesort	Group By	Location
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122 GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (13335, 13336))) GROUP BY fp.id_feature_value	216366 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	89130 ms	6536	Yes		/classes/Category.php:1057 /modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE p.id_product, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26233, 26235, 26237))) 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	61211 ms	60235776	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:187<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	56713 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY p.id_manufacturer	56572 ms	1084243968	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:661<br>/modules/ps_facetedsearch/src/Filters/Block.php:146<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (13335, 13336))) AND ((fp_1.id_feature_value IN (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	56285 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	55294 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	54295 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	53602 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	53152 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	52372 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	51713 ms	1084243968	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778<br>/modules/ps_facetedsearch/src/Filters/Block.php:855<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	49430 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	46394 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 (26233, 26235, 26237))) 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 (26233, 26235, 26237))) GROUP BY fp.id_feature_value	43837 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 (26233, 26235, 26237))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=122	26734 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 COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `prstshp_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1	10237 ms	2022084			/classes/SpecificPrice.php:287 /classes/SpecificPrice.php:345<br>/classes/SpecificPrice.php:533<br>/classes/Product.php:3787<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE `id_product` FROM prstshp_product_lang WHERE `link_rewrite` = "climatisation" AND `id_lang` = 3 AND `id_shop` = 1 LIMIT 1	8172 ms	3269			/override/classes/Dispatcher.php:1050 /override/classes/Dispatcher.php:339<br>/classes/Dispatcher.php:352<br>/index.php:39
SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `prstshp_tvcmsproduct_comment` pc WHERE pc.`id_product` = 2656 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	7120 ms	1			/modules/tvcmsproductcomments/tvcmsproductcomment.php:213 /modules/tvcmsproductcomments/tvcmsproductcomments.php:922<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/48/38/2b/48382bab7fdad5e5b5abd1e01952c3faafa682d3_2.file.product-list-view.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:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:53<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 c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `prstshp_configuration` c LEFT JOIN `prstshp_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	6043 ms	2752			/classes/Configuration.php:160 /classes/Configuration.php:209<br>/classes/Configuration.php:297<br>/classes/shop/Shop.php:384<br>/config/config.inc.php:128<br>/index.php:38
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `prstshp_hook_module` hm STRAIGHT_JOIN `prstshp_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `prstshp_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	3219 ms	726			/classes/Hook.php:504 /classes/Hook.php:544<br>/classes/tax/TaxManagerFactory.php:67<br>/classes/tax/TaxManagerFactory.php:46<br>/classes/Product.php:3885<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `prstshp_module` m INNER JOIN prstshp_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `prstshp_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `prstshp_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `prstshp_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `prstshp_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3172 ms	5715	Yes	Yes	/classes/Hook.php:1183 /classes/Hook.php:731<br>/classes/Hook.php:815<br>/override/classes/Dispatcher.php:176<br>/classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prstshp_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `prstshp_hook_alias` ha INNER JOIN `prstshp_hook` h ON ha.name = h.name	2455 ms	0			/classes/Hook.php:1243 /classes/Hook.php:222<br>/classes/tax/TaxManagerFactory.php:67<br>/classes/tax/TaxManagerFactory.php:46<br>/classes/Product.php:3885<br>/classes/Product.php:3675<br>/classes/Product.php:5632<br>/classes/Product.php:5866<br>/classes/Category.php:1069<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1089<br>/modules/lggoogleanalytics/lggoogleanalytics.php:1278<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/classes/controller/FrontController.php:598<br>/controllers/front/listing/CategoryController.php:137<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE c., cl. FROM `prstshp_category` c INNER JOIN prstshp_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `prstshp_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 3 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	2209 ms	117	Yes		/classes/Category.php:793 /modules/tvcmssearch/tvcmssearch.php:101<br>/modules/tvcmssearch/tvcmssearch.php:211<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/30/cc/c4/30ccc41b2f5bb6197b1ba4812974474a1b1c53d4_2.file.desk-header-1.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/82/16/18/8216187c37a36e2dc5d2ce9a48d7e9e1077572d5_2.file.desktop-header.tpl.php:25<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/6f/9e/f5/6f9ef54d45cdcd7619c1ab6ce0a0fa4f18acb53a_2.file.header.tpl.php:72<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/6f/9e/f5/6f9ef54d45cdcd7619c1ab6ce0a0fa4f18acb53a_2.file.header.tpl.php:30<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:147<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:63<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE lower(name) as name FROM `prstshp_hook` h WHERE (h.active = 1)	1024 ms	879			/classes/Hook.php:1283 /classes/Hook.php:786<br>/override/classes/Dispatcher.php:176<br>/classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
SELECT SQL_NO_CACHE 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 (3505) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	932 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:52<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-04-21 00:00:00", INTERVAL 200 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `prstshp_product` p INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 3 AND pl.id_shop = 1 LEFT JOIN `prstshp_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `prstshp_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3 LEFT JOIN `prstshp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `prstshp_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2024-10-03") AND (EXISTS(SELECT 1 FROM `prstshp_category_product` cp JOIN `prstshp_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	858 ms	600			/classes/Product.php:3079 /modules/tvcmstabproducts/tvcmstabproducts.php:2769<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:152<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:258<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:195<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:73<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `prstshp_feature` f INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `prstshp_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `prstshp_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 3) ORDER BY f.`position` ASC	845 ms	61	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prstshp_hook`	805 ms	879			/classes/Hook.php:1243 /classes/Hook.php:222<br>/classes/Hook.php:824<br>/override/classes/Dispatcher.php:176<br>/classes/Dispatcher.php:249<br>/override/classes/Dispatcher.php:27<br>/classes/Dispatcher.php:207<br>/index.php:39
SELECT SQL_NO_CACHE 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 (3469) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	803 ms	360	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 (3461) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	779 ms	360	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 (3459) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	745 ms	360	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 (3462) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	732 ms	360	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:52<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 6 ORDER BY vl.`value` ASC	702 ms	80	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864<br>/modules/ps_facetedsearch/src/Filters/Block.php:154<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:215<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 3) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 3) WHERE v.`id_feature` = 6 ORDER BY vl.`value` ASC	661 ms	80	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Converter.php:402<br>/modules/ps_facetedsearch/src/Product/SearchProvider.php:163<br>/classes/controller/ProductListingFrontController.php:311<br>/classes/controller/ProductListingFrontController.php:589<br>/override/classes/controller/ProductListingFrontController.php:13<br>/controllers/front/listing/CategoryController.php:148<br>/tools/profiling/Controller.php:60<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE id_product, name, value, pf.id_feature FROM prstshp_feature_product pf LEFT JOIN prstshp_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3) LEFT JOIN prstshp_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3) LEFT JOIN prstshp_feature f ON (f.id_feature = pf.id_feature) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE `id_product` IN (4590,4589,4588,4587) ORDER BY f.position ASC	643 ms	56	Yes		/classes/Product.php:4831 /classes/Product.php:3094<br>/modules/tvcmstabproducts/tvcmstabproducts.php:2769<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:152<br>/modules/tvcmsnewproducts/tvcmsnewproducts.php:258<br>/classes/Hook.php:1007<br>/tools/profiling/Hook.php:35<br>/classes/Hook.php:431<br>/classes/Hook.php:944<br>/config/smarty.config.inc.php:167<br>/classes/Smarty/SmartyLazyRegister.php:83<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:195<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:73<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE 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 (4509) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	598 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:52<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `prstshp_product_attribute` pa INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `prstshp_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `prstshp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (849) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	598 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:52<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `prstshp_product_attribute` pa INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `prstshp_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `prstshp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (2515) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	587 ms	120	Yes		/classes/Product.php:4479 /src/Adapter/Product/ProductColorsRetriever.php:43<br>/src/Adapter/Presenter/Product/ProductLazyArray.php:518<br>/src/Adapter/Presenter/AbstractLazyArray.php:257<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:200<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/1d/62/62/1d62626e36a4651e3c711b362bb92f2aaaffcabb_2.file.product-grid-view2.tpl.php:37<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:52<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/a0/4e/f9/a04ef9b4fd1b8a51c931f4cb7a5456f0978021ef_2.file.product.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:383<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:50<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/11/ba/90/11ba9077e740414f5be81e485b39033d3a02ceb2_2.file.products.tpl.php:34<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:78<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:132<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:70<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/29/e0/d1/29e0d1ddc870dc11403b055f58c3b1f12703b90c_2.file.layout-both-columns.tpl.php:75<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/e8/9c/33/e89c334e157a2674fd692e38051c96fbfc009ef6_2.file.layout-left-column.tpl.php:28<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/fb/c2/6d/fbc26d394332cde5d96ab13dfd7fb45b298801d3_2.file.product-list.tpl.php:33<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116<br>/var/cache/prod/smarty/compile/tv_electronic_salesgulllayouts_layout_left_column_tpl/ab/7e/2e/ab7e2e7c3afe33b4dfa7b2ca98e1a6a745dcc9a1_2.file.category.tpl.php:27<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123<br>/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:232<br>/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116<br>/classes/Smarty/SmartyCustom.php:112<br>/classes/controller/FrontController.php:727<br>/override/classes/controller/FrontController.php:27<br>/classes/controller/FrontController.php:709<br>/tools/profiling/Controller.php:106<br>/tools/profiling/Controller.php:83<br>/classes/Dispatcher.php:518<br>/index.php:39
SELECT SQL_NO_CACHE 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:14:18") AND (r.to_date ="0000-00-00 00:00:00" or r.to_date >="2025-04-21 19:14:18") AND r.id_shop = "1"	565 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

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 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>
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>
47 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>
46 queries	SELECT COUNT(*) FROM `prstshp_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
46 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>
46 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>)
46 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>
46 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>
46 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>
46 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>
45 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 * 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>
44 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>
42 queries	SELECT name, value, pf.id_feature, f.position FROM prstshp_feature_product pf LEFT JOIN prstshp_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>) LEFT JOIN prstshp_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = <span style="color:blue">XX</span>) LEFT JOIN prstshp_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>) INNER JOIN prstshp_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = <span style="color:blue">XX</span>) WHERE pf.id_product = <span style="color:blue">XX</span> ORDER BY f.position ASC
28 queries	SELECT 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 `id_product_attribute` FROM `prstshp_product_attribute` WHERE `id_product` = <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 position FROM `prstshp_category_product` WHERE id_category = <span style="color:blue">XX</span> AND id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
24 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > <span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `prstshp_product_attribute` pa INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN prstshp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, <span style="color:blue">XX</span>) AND stock.id_shop = <span style="color:blue">XX</span> AND stock.id_shop_group = <span style="color:blue">XX</span> ) JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `prstshp_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `prstshp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = <span style="color:blue">XX</span>) JOIN `prstshp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (<span style="color:blue">XX</span>) AND ag.`is_color_group` = <span style="color:blue">XX</span> GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > <span style="color:blue">XX</span> ORDER BY a.`position` ASC;
24 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>
19 queries	SELECT `id_module` FROM `prstshp_module_shop` WHERE `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
16 queries	SELECT mr.* FROM prstshp_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = <span style="color:blue">XX</span> AND mr.id_tvcmsmegamenu = <span style="color:blue">XX</span> AND mr.`active` = <span style="color:blue">XX</span>
16 queries	SELECT product_attribute_shop.`price` FROM `prstshp_product_attribute` pa INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) WHERE pa.`id_product_attribute` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
16 queries	SELECT pa.`available_date` FROM `prstshp_product` p LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN prstshp_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = <span style="color:blue">XX</span>) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) WHERE p.`id_product` = <span style="color:blue">XX</span> AND pa.`id_product` = <span style="color:blue">XX</span> AND pa.`id_product_attribute` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
16 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean<span style="color:blue">XX</span>`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `prstshp_attribute` a LEFT JOIN `prstshp_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `prstshp_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN prstshp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = <span style="color:blue">XX</span>) WHERE pa.`id_product` = <span style="color:blue">XX</span> AND pac.`id_product_attribute` = <span style="color:blue">XX</span> AND agl.`id_lang` = <span style="color:blue">XX</span>
16 queries	SELECT * FROM `prstshp_product_attribute` a LEFT JOIN `prstshp_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_product_attribute` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
16 queries	SELECT location FROM `prstshp_stock_available` WHERE (id_product = <span style="color:blue">XX</span>) AND (id_product_attribute = <span style="color:blue">XX</span>) AND (id_shop = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
14 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `prstshp_feature_value` v LEFT JOIN `prstshp_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = <span style="color:blue">XX</span>) LEFT JOIN `prstshp_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = <span style="color:blue">XX</span>) WHERE v.`id_feature` = <span style="color:blue">XX</span> ORDER BY vl.`value` ASC
12 queries	SELECT * FROM `prstshp_category` a LEFT JOIN `prstshp_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = <span style="color:blue">XX</span> LEFT JOIN `prstshp_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = <span style="color:blue">XX</span> WHERE (a.`id_category` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
10 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM prstshp_product p LEFT JOIN prstshp_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN prstshp_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN prstshp_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, <span style="color:blue">XX</span>) = sa.id_product_attribute AND sa.id_shop = <span style="color:blue">XX</span> AND sa.id_shop_group = <span style="color:blue">XX</span> ) LEFT JOIN prstshp_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN prstshp_category_product cp ON (p.id_product = cp.id_product) INNER JOIN prstshp_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = <span style="color:blue">XX</span> AND ps.active = TRUE) INNER JOIN prstshp_category c ON (cp.id_category = c.id_category AND c.active=<span style="color:blue">XX</span>) LEFT JOIN prstshp_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ps.id_shop='<span style="color:blue">XX</span>' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='<span style="color:blue">XX</span>' AND c.nleft>=<span style="color:blue">XX</span> AND c.nright<=<span style="color:blue">XX</span> GROUP BY p.id_product) p INNER JOIN prstshp_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) LEFT JOIN prstshp_feature_product fp_<span style="color:blue">XX</span> ON (p.id_product = fp_<span style="color:blue">XX</span>.id_product) WHERE ((fp.id_feature=<span style="color:blue">XX</span>)) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) AND ((fp_<span style="color:blue">XX</span>.id_feature_value IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>, <span style="color:blue">XX</span>))) GROUP BY fp.id_feature_value
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>
5 queries	SELECT cl.`link_rewrite` FROM `prstshp_category_lang` cl WHERE `id_lang` = <span style="color:blue">XX</span> AND cl.id_shop = <span style="color:blue">XX</span> AND cl.`id_category` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
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	369	/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]
Category	103	/controllers/front/listing/CategoryController.php [89] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /controllers/front/listing/CategoryController.php [211] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /classes/Meta.php [380] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /classes/PrestaShopCollection.php [383] /classes/PrestaShopCollection.php [383] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/ps_facetedsearch/src/Product/Search.php [364] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmssearch/tvcmssearch.php [101] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /modules/tvcmsmegamenu/tvcmsmegamenu.php [1674] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [32] /override/classes/Link.php [98] /override/classes/Link.php [98] /override/classes/Link.php [98]
Product	86	/classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /classes/Link.php [114] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /src/Adapter/Image/ImageRetriever.php [66] /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] /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] /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	46	/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

Candy CY-18RAIN + CY-18RAOUT Mural Pura

Candy CY-18RAIN + CY-18RAOUT Mural Pura

Candy CY-18RAIN + CY-18RAOUT Mural Pura

Candy CY-18RAIN + CY-18RAOUT Mural Pura

Haier AS50S2SF2FA-3 + 1U50S2SJ2FA Flair Plus

Haier AS50S2SF2FA-3 + 1U50S2SJ2FA Flair Plus

Haier AS50S2SF2FA-3 + 1U50S2SJ2FA Flair Plus

Haier AS50S2SF2FA-3 + 1U50S2SJ2FA Flair Plus

Haier AS71S2SF2FA-3 + 1U71S2SR2FA Flair Plus

Haier AS71S2SF2FA-3 + 1U71S2SR2FA Flair Plus

Haier AS71S2SF2FA-3 + 1U71S2SR2FA Flair Plus

Haier AS71S2SF2FA-3 + 1U71S2SR2FA Flair Plus

Candy CY-18QBIN + CY-18QBOUT Mural Aria

Candy CY-18QBIN + CY-18QBOUT Mural Aria

Candy CY-18QBIN + CY-18QBOUT Mural Aria

Candy CY-18QBIN + CY-18QBOUT Mural Aria

Haier AS50RCBHRA-4 + 1U50MERDRA-4 Revive Plus

Haier AS50RCBHRA-4 + 1U50MERDRA-4 Revive Plus

Haier AS50RCBHRA-4 + 1U50MERDRA-4 Revive Plus

Haier AS50RCBHRA-4 + 1U50MERDRA-4 Revive Plus

Haier AS50TDDHRA-THC + 1U50MEMFRA-C Geos Plus

Haier AS50TDDHRA-THC + 1U50MEMFRA-C Geos Plus

Haier AS50TDDHRA-THC + 1U50MEMFRA-C Geos Plus

Haier AS50TDDHRA-THC + 1U50MEMFRA-C Geos Plus

Haier AS68TDRHRA-THC + 1U68WEGRA-C Geos Plus

Haier AS68TDRHRA-THC + 1U68WEGRA-C Geos Plus

Haier AS68TDRHRA-THC + 1U68WEGRA-C Geos Plus

Haier AS68TDRHRA-THC + 1U68WEGRA-C Geos Plus

Haier AS50S2SF1FA-WH + 1U50S2SJ2FA Flexis Plus Blanc

Haier AS50S2SF1FA-WH + 1U50S2SJ2FA Flexis Plus Blanc

Haier AS50S2SF1FA-WH + 1U50S2SJ2FA Flexis Plus Blanc

Haier AS50S2SF1FA-WH + 1U50S2SJ2FA Flexis Plus Blanc

Haier AS50S2SF1FA-BH + 1U50S2SJ2FA Flexis Plus Noir Mat

Haier AS50S2SF1FA-BH + 1U50S2SJ2FA Flexis Plus Noir Mat

Haier AS50S2SF1FA-BH + 1U50S2SJ2FA Flexis Plus Noir Mat

Haier AS50S2SF1FA-BH + 1U50S2SJ2FA Flexis Plus Noir Mat

Daikin FTXM60A + RXM60A Perfera All Seasons

Daikin FTXM60A + RXM60A Perfera All Seasons

Daikin FTXM60A + RXM60A Perfera All Seasons

Daikin FTXM60A + RXM60A Perfera All Seasons

Daikin FTXP60N + RXP60N Série Comfora

Daikin FTXP60N + RXP60N Série Comfora

Daikin FTXP60N + RXP60N Série Comfora

Daikin FTXP60N + RXP60N Série Comfora

Daikin FTXM60A Perfera All Seasons

Daikin FTXM60A Perfera All Seasons

Daikin FTXM60A Perfera All Seasons

Daikin FTXM60A Perfera All Seasons

Daikin FDXM50F9

Daikin FDXM50F9

Daikin FDXM50F9

Daikin FDXM50F9

Daikin FDXM60F9

Daikin FDXM60F9

Daikin FDXM60F9

Daikin FDXM60F9

Daikin FCAG60B Série Round Flow

Daikin FCAG60B Série Round Flow

Daikin FCAG60B Série Round Flow

Daikin FCAG60B Série Round Flow

Daikin FCAG71B Série Round Flow

Daikin FCAG71B Série Round Flow

Daikin FCAG71B Série Round Flow

Daikin FCAG71B Série Round Flow

Daikin FTXM60A + RZAG60B Série Perfera Sky Air Alpha Series

Daikin FTXM60A + RZAG60B Série Perfera Sky Air Alpha Series

Daikin FTXM60A + RZAG60B Série Perfera Sky Air Alpha Series

Daikin FTXM60A + RZAG60B Série Perfera Sky Air Alpha Series

Daikin FCAG71B + RZAG71NY1 Cassette Round Flow Sky Air Alpha Series Triphasé

Daikin FCAG71B + RZAG71NY1 Cassette Round Flow Sky Air Alpha Series Triphasé

Daikin FCAG71B + RZAG71NY1 Cassette Round Flow Sky Air Alpha Series Triphasé

Daikin FCAG71B + RZAG71NY1 Cassette Round Flow Sky Air Alpha Series Triphasé

Daikin FCAG71B + RZAG71NV1 Cassette Round Flow Sky Air Alpha Series

Daikin FCAG71B + RZAG71NV1 Cassette Round Flow Sky Air Alpha Series