Nume cookie	Furnizor	Scop	Expirare
apc_popup_session	https://www.hometel.ro	Used to know if it is a new browser session.	Sesiune
cookiesplus	https://www.hometel.ro	Reține preferințele dvs. legate de modulele cookie.	1 an
laravel_session	https://www.hometel.ro	Cookie folosit pentru a identifica o instanță de sesiune pentru utilizator.	1 zi
PHP_SESSID	https://www.hometel.ro	Acest cookie este originar din PHP și permite site-urilor web să stocheze date de stare serializate. Este utilizat pentru a stabili o sesiune de utilizator și pentru a transmite date de stare printr-un cookie temporar, care este denumit în mod obișnuit un cookie de sesiune.	Sesiune
PrestaShop-#	https://www.hometel.ro	Acest cookie ajută la menținerea sesiunilor utilizatorului deschise în timp ce vizitează un site web și îi ajută să facă comenzi și multe alte operațiuni, cum ar fi: data adăugării cookie-ului, limba selectată, moneda utilizată, ultima categorie de produse vizitate, ultimele produse văzute, identificarea clientului, numele, prenume, parolă criptată, e-mail conectat la cont, identificare coș de cumpărături.	480 ore
rc::a	Google	Acest cookie este utilizat pentru a distinge oamenii de roboți. Acest lucru este benefic pentru site-ul web pentru a crea rapoarte valabile cu privire la utilizarea site-ului lor.	Persistent
rc::c	Google	Acest cookie este utilizat pentru a distinge între oameni și roboți..	Persistent
__cfduid		Cookie-uri tehnice solicitate de furnizorul CDN Cloudflare.	30 de zile

Nume cookie	Furnizor	Scop	Expirare
collect	Google	Este folosit pentru a trimite date către Google Analytics despre dispozitivul vizitatorului și comportamentul acestuia. Urmăriți vizitatorul pe dispozitive și canale de marketing.	Sesiune
r/collect	Google	Este folosit pentru a trimite date către Google Analytics despre dispozitivul vizitatorului și comportamentul acestuia. Urmăriți vizitatorul pe dispozitive și canale de marketing.	Sesiune
_ga	Google	Înregistrează un ID unic care este utilizat pentru a genera date statistice despre modul în care vizitatorul folosește site-ul web.	2 ani
_gat	Google	Folosit de Google Analytics pentru a restrânge rata solicitării	1 zi
_gat_gtag_UA_*	Google	Folosit pentru a limita rata de solicitare.	1 minut
_ga_#	Google	Used by Google Analytics to collect data on the number of times a user has visited the website as well as dates for the first and most recent visit.	2 ani
_gd#	Google	Acesta este un cookie de sesiune Google Analytics utilizat pentru a genera date statistice despre modul în care utilizați site-ul web, care este eliminat atunci când părăsiți browserul.	Sesiune
_gid	Google	Înregistrează un ID unic care este utilizat pentru a genera date statistice despre modul în care vizitatorul folosește site-ul web.	1 zi

Nume cookie	Furnizor	Scop	Expirare
ads/ga-audiences	Google	Aceste cookie-uri sunt utilizate de Google AdWords pentru a re-atrage vizitatori care ar putea converti la clienți pe baza comportamentului online al vizitatorului pe site-uri web.	Sesiune
NID	Google	Înregistrează un ID unic care identifică dispozitivul unui utilizator care se întoarce. ID-ul este utilizat pentru reclame direcționate.	6 luni

Load Time	308.257 ms
Querying Time	233 ms
Queries	349
Memory Peak Usage	16.1 Mb
Included Files	931 files - 12.95 Mb
PrestaShop Cache	- Mb
Global vars	0.10 Mb
- global $_MODULES	40k
- global $_MODULE	40k
- global $_SERVER	8k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	2k
- global $__composer_autoload_files	1k

PrestaShop Version	8.2.1
PHP Version	8.1.32
MySQL Version	8.0.41-0ubuntu0.24.04.1
Memory Limit	512M
Max Execution Time	60s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	17.276 ms	17.276 ms	4.79 Mb	4.9 Mb
__construct	0.013 ms	17.289 ms	- Mb	4.9 Mb
init	11.143 ms	28.432 ms	0.78 Mb	5.6 Mb
checkAccess	0.017 ms	28.449 ms	- Mb	5.6 Mb
setMedia	3.470 ms	31.919 ms	0.18 Mb	5.8 Mb
postProcess	0.001 ms	31.920 ms	- Mb	5.8 Mb
initHeader	0.001 ms	31.921 ms	- Mb	5.8 Mb
initContent	233.623 ms	265.544 ms	7.41 Mb	13.2 Mb
initFooter	0.004 ms	265.548 ms	- Mb	13.2 Mb
display	42.709 ms	308.257 ms	2.63 Mb	16.1 Mb

Hook	Time	Memory Usage
ActionStAssemble	26.185 ms	0.63 Mb
=> stthemeeditor	0.584 ms	0.01 Mb
=> sthoverimage	0.388 ms	0.01 Mb
=> stcompare	0.006 ms	- Mb
=> ststickers	5.591 ms	0.14 Mb
=> stwishlist	0.334 ms	0.01 Mb
=> stproductcomments	0.396 ms	0.01 Mb
=> stthemeeditor	0.458 ms	0.01 Mb
=> sthoverimage	0.440 ms	0.01 Mb
=> stcompare	0.002 ms	- Mb
=> ststickers	3.798 ms	0.09 Mb
=> stwishlist	0.310 ms	0.01 Mb
=> stproductcomments	0.317 ms	0.01 Mb
=> stthemeeditor	0.487 ms	0.01 Mb
=> sthoverimage	0.338 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	6.018 ms	0.14 Mb
=> stwishlist	0.334 ms	0.01 Mb
=> stproductcomments	0.365 ms	0.01 Mb
=> stthemeeditor	0.456 ms	0.01 Mb
=> sthoverimage	0.392 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	4.435 ms	0.11 Mb
=> stwishlist	0.357 ms	0.01 Mb
=> stproductcomments	0.373 ms	0.01 Mb
DisplayHeader	14.475 ms	0.83 Mb
=> stthemeeditor	3.402 ms	0.24 Mb
=> ps_googleanalytics	0.204 ms	0.01 Mb
=> stcustomersignin	0.767 ms	0.02 Mb
=> stmultilink	0.250 ms	0.01 Mb
=> stsearchbar	0.289 ms	0.01 Mb
=> stshoppingcart	0.403 ms	0.01 Mb
=> stmegamenu	0.297 ms	0.01 Mb
=> stswiper	0.224 ms	0.07 Mb
=> stowlcarousel	0.280 ms	0.01 Mb
=> steasycontent	0.284 ms	0.03 Mb
=> stfeaturedslider	0.279 ms	0.01 Mb
=> stfeaturedcategories	0.254 ms	0.01 Mb
=> stblogeditor	0.251 ms	0.01 Mb
=> stblogfeaturedarticles	0.215 ms	0.01 Mb
=> stbanner	0.228 ms	0.01 Mb
=> stbrandsslider	0.226 ms	0.01 Mb
=> stspecialslider	0.286 ms	0.01 Mb
=> stblogrecentarticles	0.238 ms	0.01 Mb
=> stnewsletter	0.251 ms	0.01 Mb
=> stblogarchives	0.015 ms	- Mb
=> stblogcomments	0.045 ms	- Mb
=> stblogrelatedarticles	0.251 ms	0.01 Mb
=> stcountdown	0.267 ms	0.01 Mb
=> sthoverimage	0.054 ms	- Mb
=> stinstagram	0.438 ms	0.04 Mb
=> stcompare	0.371 ms	0.01 Mb
=> stnotification	0.226 ms	0.01 Mb
=> stpagebanner	0.261 ms	0.01 Mb
=> stproductcategoriesslider	0.315 ms	0.01 Mb
=> strelatedproducts	0.268 ms	0.01 Mb
=> stsidebar	0.226 ms	0.01 Mb
=> ststickers	0.921 ms	0.09 Mb
=> stvideo	0.290 ms	0.01 Mb
=> stwishlist	0.366 ms	0.02 Mb
=> stproductcomments	0.402 ms	0.01 Mb
=> stproductsasattrs	0.264 ms	0.01 Mb
=> sturls	0.054 ms	- Mb
=> cookiesplus	0.709 ms	0.02 Mb
=> ets_recaptcha_free	0.012 ms	- Mb
=> ets_whatsapp	0.093 ms	- Mb
DisplayBeforeBodyClosingTag	6.391 ms	0.47 Mb
=> ps_googleanalytics	1.452 ms	0.06 Mb
=> statsdata	0.661 ms	0.06 Mb
=> stwishlist	0.204 ms	- Mb
=> cookiesplus	4.073 ms	0.34 Mb
DisplaySideBar	3.523 ms	0.16 Mb
=> stsidebar	0.692 ms	0.02 Mb
=> stnewsletter	0.709 ms	0.02 Mb
=> stmegamenu	0.386 ms	0.03 Mb
=> stwishlist	1.104 ms	0.06 Mb
=> stsearchbar	0.248 ms	0.01 Mb
=> stshoppingcart	0.384 ms	0.03 Mb
displayLeftColumn	3.365 ms	0.15 Mb
=> ps_categorytree (widget)	3.365 ms	0.15 Mb
displayTop	2.577 ms	0.16 Mb
=> stcustomersignin (widget)	2.057 ms	0.13 Mb
=> stshoppingcart (widget)	0.520 ms	0.03 Mb
displayBanner	2.533 ms	0.16 Mb
=> stnotification (widget)	1.504 ms	0.09 Mb
=> steasycontent (widget)	1.029 ms	0.06 Mb
ActionFrontControllerSetMedia	2.387 ms	0.05 Mb
=> ps_emailalerts	0.038 ms	- Mb
=> cookiesplus	2.349 ms	0.05 Mb
ActionOutputHTMLBefore	1.652 ms	- Mb
=> cookiesplus	1.494 ms	- Mb
=> stswiper	0.041 ms	- Mb
=> stbanner	0.071 ms	- Mb
=> stinstagram	0.046 ms	- Mb
DisplayMobileBarLeft	1.364 ms	0.14 Mb
=> stsidebar	1.364 ms	0.14 Mb
DisplayFooter	1.155 ms	0.08 Mb
=> ets_whatsapp	0.259 ms	0.02 Mb
=> stnewsletter	0.272 ms	0.02 Mb
=> stmultilink	0.307 ms	0.02 Mb
=> steasycontent	0.317 ms	0.02 Mb
displayHeaderCenter	0.956 ms	0.03 Mb
=> stsearchbar (widget)	0.956 ms	0.03 Mb
displayFullWidthTop	0.938 ms	0.05 Mb
=> stswiper (widget)	0.922 ms	0.05 Mb
=> steasycontent (widget)	0.016 ms	- Mb
DisplayMainMenu	0.937 ms	0.03 Mb
=> stmegamenu	0.937 ms	0.03 Mb
ActionDispatcherBefore	0.919 ms	0.01 Mb
=> sturls	0.911 ms	0.01 Mb
=> ets_delete_order	0.008 ms	- Mb
DisplayCategoryHeader	0.838 ms	0.03 Mb
=> stswiper	0.250 ms	0.01 Mb
=> stowlcarousel	0.323 ms	0.01 Mb
=> stbanner	0.265 ms	0.01 Mb
ActionProductSearchAfter	0.819 ms	0.02 Mb
=> stthemeeditor	0.006 ms	- Mb
=> stcountdown	0.011 ms	- Mb
=> stcompare	0.032 ms	- Mb
=> ststickers	0.737 ms	0.01 Mb
=> stwishlist	0.033 ms	- Mb
DisplayMobileBar	0.705 ms	0.03 Mb
=> stsidebar	0.705 ms	0.03 Mb
displayBeforeBodyClosingTag	0.701 ms	0.02 Mb
=> stnotification (widget)	0.701 ms	0.02 Mb
DisplayLeftColumn	0.595 ms	0.09 Mb
=> ps_facetedsearch	0.261 ms	0.08 Mb
=> stmegamenu	0.334 ms	0.01 Mb
DisplayRightBar	0.357 ms	0.04 Mb
=> stsidebar	0.357 ms	0.04 Mb
DisplayBreadcrumb	0.357 ms	0.01 Mb
=> stpagebanner	0.357 ms	0.01 Mb
DisplayFooterAfter	0.282 ms	0.01 Mb
=> stmultilink	0.282 ms	0.01 Mb
DisplayNav1	0.281 ms	0.02 Mb
=> stmultilink	0.281 ms	0.02 Mb
DisplayNav2	0.233 ms	0.01 Mb
=> stmultilink	0.233 ms	0.01 Mb
ProductSearchProvider	0.231 ms	- Mb
=> ps_facetedsearch	0.231 ms	- Mb
DisplayMobileBarCenter	0.182 ms	- Mb
=> stsidebar	0.182 ms	- Mb
DisplayMobileBarBottom	0.169 ms	- Mb
=> stsidebar	0.169 ms	- Mb
ModuleRoutes	0.062 ms	0.01 Mb
=> stblog	0.004 ms	- Mb
=> stblogarchives	0.002 ms	- Mb
=> stblogsearch	0.001 ms	- Mb
=> sturls	0.031 ms	0.01 Mb
=> cookiesplus	0.024 ms	- Mb
ActionDispatcher	0.022 ms	- Mb
=> sturls	0.022 ms	- Mb
displayFullWidthTop2	0.013 ms	- Mb
=> steasycontent (widget)	0.013 ms	- Mb
OverrideLayoutTemplate	0.008 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.002 ms	- Mb
DisplayAfterBodyOpeningTag	0.008 ms	- Mb
=> cookiesplus	0.008 ms	- Mb
DisplayFullWidthBottom	0.004 ms	- Mb
=> stblogfeaturedarticles	0.004 ms	- Mb
DisplayFullWidthTop	0.004 ms	- Mb
=> stfeaturedslider	0.003 ms	- Mb
=> stproductcategoriesslider	0.001 ms	- Mb
FilterProductSearch	0.003 ms	- Mb
=> stsearchbar	0.003 ms	- Mb
36 hook(s)	75.229 ms	3.24 Mb

Module	Time	Memory Usage
sturls	1.986 ms	0.06 Mb
__construct	0.960 ms	0.04 Mb
hookModuleRoutes	0.032 ms	0.01 Mb
hookActionDispatcherBefore	0.914 ms	0.01 Mb
hookActionDispatcher	0.024 ms	- Mb
hookDisplayHeader	0.056 ms	- Mb
stblog	1.610 ms	0.10 Mb
__construct	1.587 ms	0.09 Mb
hookModuleRoutes	0.008 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.005 ms	- Mb
hookOverrideLayoutTemplate	0.004 ms	- Mb
stblogarchives	0.724 ms	0.03 Mb
__construct	0.704 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.016 ms	- Mb
stblogsearch	0.756 ms	0.03 Mb
__construct	0.753 ms	0.03 Mb
hookModuleRoutes	0.003 ms	- Mb
cookiesplus	9.581 ms	0.51 Mb
__construct	0.906 ms	0.09 Mb
hookModuleRoutes	0.026 ms	- Mb
hookActionFrontControllerSetMedia	2.352 ms	0.05 Mb
hookDisplayHeader	0.712 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.012 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.076 ms	0.34 Mb
hookActionOutputHTMLBefore	1.497 ms	- Mb
ets_delete_order	0.879 ms	0.14 Mb
__construct	0.868 ms	0.14 Mb
hookActionDispatcherBefore	0.011 ms	- Mb
ps_emailalerts	0.817 ms	0.12 Mb
__construct	0.776 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.041 ms	- Mb
stthemeeditor	5.730 ms	0.39 Mb
__construct	0.318 ms	0.09 Mb
hookDisplayHeader	3.405 ms	0.24 Mb
hookActionStAssemble	0.590 ms	0.02 Mb
hookActionStAssemble	0.461 ms	0.01 Mb
hookActionStAssemble	0.490 ms	0.01 Mb
hookActionStAssemble	0.459 ms	0.01 Mb
hookActionProductSearchAfter	0.007 ms	- Mb
ps_googleanalytics	1.771 ms	0.10 Mb
__construct	0.109 ms	0.03 Mb
hookDisplayHeader	0.207 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.455 ms	0.06 Mb
stcustomersignin	3.050 ms	0.18 Mb
__construct	0.220 ms	0.02 Mb
hookDisplayHeader	0.770 ms	0.02 Mb
displayTop	2.060 ms	0.13 Mb
stmultilink	1.581 ms	0.13 Mb
__construct	0.182 ms	0.05 Mb
hookDisplayHeader	0.252 ms	0.01 Mb
hookDisplayNav1	0.284 ms	0.02 Mb
hookDisplayNav2	0.252 ms	0.01 Mb
hookDisplayFooter	0.326 ms	0.02 Mb
hookDisplayFooterAfter	0.285 ms	0.01 Mb
stsearchbar	1.632 ms	0.09 Mb
__construct	0.123 ms	0.03 Mb
hookDisplayHeader	0.292 ms	0.01 Mb
displayHeaderCenter	0.960 ms	0.03 Mb
hookFilterProductSearch	0.006 ms	- Mb
hookDisplaySideBar	0.251 ms	0.01 Mb
stshoppingcart	1.471 ms	0.15 Mb
__construct	0.139 ms	0.08 Mb
hookDisplayHeader	0.422 ms	0.01 Mb
displayTop	0.523 ms	0.03 Mb
hookDisplaySideBar	0.387 ms	0.03 Mb
stmegamenu	2.173 ms	0.14 Mb
__construct	0.189 ms	0.06 Mb
hookDisplayHeader	0.300 ms	0.01 Mb
hookDisplayMainMenu	0.941 ms	0.03 Mb
hookDisplayLeftColumn	0.336 ms	0.01 Mb
hookDisplaySideBar	0.407 ms	0.03 Mb
stswiper	1.755 ms	0.23 Mb
__construct	0.306 ms	0.09 Mb
hookDisplayHeader	0.227 ms	0.07 Mb
displayFullWidthTop	0.926 ms	0.05 Mb
hookDisplayCategoryHeader	0.253 ms	0.01 Mb
hookActionOutputHTMLBefore	0.043 ms	- Mb
stowlcarousel	0.802 ms	0.08 Mb
__construct	0.193 ms	0.06 Mb
hookDisplayHeader	0.283 ms	0.01 Mb
hookDisplayCategoryHeader	0.326 ms	0.01 Mb
steasycontent	2.123 ms	0.29 Mb
__construct	0.453 ms	0.17 Mb
hookDisplayHeader	0.287 ms	0.03 Mb
displayBanner	1.032 ms	0.06 Mb
displayFullWidthTop	0.018 ms	- Mb
displayFullWidthTop2	0.014 ms	- Mb
hookDisplayFooter	0.319 ms	0.02 Mb
stfeaturedslider	0.484 ms	0.08 Mb
__construct	0.197 ms	0.07 Mb
hookDisplayHeader	0.282 ms	0.01 Mb
hookDisplayFullWidthTop	0.005 ms	- Mb
stfeaturedcategories	0.395 ms	0.05 Mb
__construct	0.139 ms	0.04 Mb
hookDisplayHeader	0.256 ms	0.01 Mb
stblogeditor	0.340 ms	0.05 Mb
__construct	0.087 ms	0.03 Mb
hookDisplayHeader	0.253 ms	0.01 Mb
stblogfeaturedarticles	0.329 ms	0.13 Mb
__construct	0.105 ms	0.11 Mb
hookDisplayHeader	0.217 ms	0.01 Mb
hookDisplayFullWidthBottom	0.007 ms	- Mb
stbanner	0.778 ms	0.09 Mb
__construct	0.207 ms	0.06 Mb
hookDisplayHeader	0.231 ms	0.01 Mb
hookDisplayCategoryHeader	0.267 ms	0.01 Mb
hookActionOutputHTMLBefore	0.073 ms	- Mb
stbrandsslider	0.373 ms	0.04 Mb
__construct	0.144 ms	0.03 Mb
hookDisplayHeader	0.229 ms	0.01 Mb
stspecialslider	0.454 ms	0.04 Mb
__construct	0.165 ms	0.03 Mb
hookDisplayHeader	0.289 ms	0.01 Mb
stblogrecentarticles	0.350 ms	0.04 Mb
__construct	0.109 ms	0.03 Mb
hookDisplayHeader	0.241 ms	0.01 Mb
stnewsletter	1.410 ms	0.16 Mb
__construct	0.170 ms	0.11 Mb
hookDisplayHeader	0.254 ms	0.01 Mb
hookDisplayFooter	0.274 ms	0.02 Mb
hookDisplaySideBar	0.712 ms	0.02 Mb
stblogcomments	0.188 ms	0.04 Mb
__construct	0.141 ms	0.04 Mb
hookDisplayHeader	0.047 ms	- Mb
stblogrelatedarticles	0.360 ms	0.04 Mb
__construct	0.107 ms	0.03 Mb
hookDisplayHeader	0.253 ms	0.01 Mb
stcountdown	0.403 ms	0.04 Mb
__construct	0.121 ms	0.03 Mb
hookDisplayHeader	0.270 ms	0.02 Mb
hookActionProductSearchAfter	0.012 ms	- Mb
sthoverimage	1.774 ms	0.06 Mb
__construct	0.147 ms	0.03 Mb
hookDisplayHeader	0.056 ms	- Mb
hookActionStAssemble	0.392 ms	0.01 Mb
hookActionStAssemble	0.443 ms	0.01 Mb
hookActionStAssemble	0.341 ms	0.01 Mb
hookActionStAssemble	0.395 ms	0.01 Mb
stinstagram	0.787 ms	0.17 Mb
__construct	0.299 ms	0.13 Mb
hookDisplayHeader	0.441 ms	0.04 Mb
hookActionOutputHTMLBefore	0.047 ms	- Mb
stcompare	0.592 ms	0.05 Mb
__construct	0.150 ms	0.03 Mb
hookDisplayHeader	0.374 ms	0.01 Mb
hookActionStAssemble	0.007 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionProductSearchAfter	0.049 ms	- Mb
stnotification	2.619 ms	0.18 Mb
__construct	0.162 ms	0.05 Mb
hookDisplayHeader	0.229 ms	0.01 Mb
displayBanner	1.523 ms	0.09 Mb
displayBeforeBodyClosingTag	0.705 ms	0.02 Mb
stpagebanner	0.768 ms	0.06 Mb
__construct	0.144 ms	0.04 Mb
hookDisplayHeader	0.264 ms	0.01 Mb
hookDisplayBreadcrumb	0.360 ms	0.01 Mb
stproductcategoriesslider	0.843 ms	0.15 Mb
__construct	0.523 ms	0.14 Mb
hookDisplayHeader	0.318 ms	0.01 Mb
hookDisplayFullWidthTop	0.002 ms	- Mb
strelatedproducts	0.427 ms	0.04 Mb
__construct	0.156 ms	0.03 Mb
hookDisplayHeader	0.271 ms	0.01 Mb
stsidebar	3.987 ms	0.30 Mb
__construct	0.271 ms	0.05 Mb
hookDisplayHeader	0.229 ms	0.01 Mb
hookDisplayMobileBarLeft	1.367 ms	0.14 Mb
hookDisplayMobileBarCenter	0.185 ms	- Mb
hookDisplayMobileBar	0.708 ms	0.03 Mb
hookDisplayMobileBarBottom	0.172 ms	- Mb
hookDisplaySideBar	0.695 ms	0.02 Mb
hookDisplayRightBar	0.360 ms	0.04 Mb
ststickers	21.791 ms	0.65 Mb
__construct	0.269 ms	0.06 Mb
hookDisplayHeader	0.924 ms	0.09 Mb
hookActionStAssemble	5.594 ms	0.14 Mb
hookActionStAssemble	3.802 ms	0.09 Mb
hookActionStAssemble	6.022 ms	0.14 Mb
hookActionStAssemble	4.439 ms	0.11 Mb
hookActionProductSearchAfter	0.741 ms	0.02 Mb
stvideo	0.539 ms	0.06 Mb
__construct	0.246 ms	0.05 Mb
hookDisplayHeader	0.293 ms	0.01 Mb
stwishlist	3.274 ms	0.16 Mb
__construct	0.208 ms	0.05 Mb
hookDisplayHeader	0.369 ms	0.02 Mb
hookActionStAssemble	0.337 ms	0.01 Mb
hookActionStAssemble	0.313 ms	0.01 Mb
hookActionStAssemble	0.337 ms	0.01 Mb
hookActionStAssemble	0.360 ms	0.01 Mb
hookActionProductSearchAfter	0.035 ms	- Mb
hookDisplaySideBar	1.108 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	0.207 ms	- Mb
stproductcomments	2.137 ms	0.17 Mb
__construct	0.269 ms	0.13 Mb
hookDisplayHeader	0.405 ms	0.01 Mb
hookActionStAssemble	0.399 ms	0.01 Mb
hookActionStAssemble	0.320 ms	0.01 Mb
hookActionStAssemble	0.368 ms	0.01 Mb
hookActionStAssemble	0.376 ms	0.01 Mb
stproductsasattrs	0.425 ms	0.06 Mb
__construct	0.158 ms	0.04 Mb
hookDisplayHeader	0.267 ms	0.02 Mb
ets_recaptcha_free	0.147 ms	0.03 Mb
__construct	0.134 ms	0.03 Mb
hookDisplayHeader	0.013 ms	- Mb
ets_whatsapp	0.484 ms	0.04 Mb
__construct	0.127 ms	0.02 Mb
hookDisplayHeader	0.095 ms	- Mb
hookDisplayFooter	0.262 ms	0.02 Mb
ps_facetedsearch	0.730 ms	0.12 Mb
__construct	0.231 ms	0.04 Mb
hookProductSearchProvider	0.234 ms	- Mb
hookDisplayLeftColumn	0.265 ms	0.08 Mb
ps_categorytree	3.489 ms	0.16 Mb
__construct	0.121 ms	0.02 Mb
displayLeftColumn	3.368 ms	0.15 Mb
statsdata	0.749 ms	0.08 Mb
__construct	0.085 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.664 ms	0.06 Mb
47 module(s)	89.869 ms	6.09 Mb

20 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY fp.id_feature_value
17 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 `mmag_feature_value` v LEFT JOIN `mmag_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `mmag_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
13 queries	SELECT `id_module` FROM `mmag_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c LEFT JOIN `mmag_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`id_category` = XX LIMIT XX
10 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = XX LIMIT XX
10 queries	SELECT c., cl. FROM `mmag_category` c LEFT JOIN `mmag_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = XX AND cl.id_shop = XX ) WHERE c.`nleft` <= XX AND c.`nright` >= XX AND c.`nleft` >= XX AND c.`nright` <= XX ORDER BY `nleft` DESC
9 queries	SELECT * FROM `mmag_category` a LEFT JOIN `mmag_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
8 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `mmag_image` i INNER JOIN mmag_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `mmag_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
7 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `mmag_module` m LEFT JOIN `mmag_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
6 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `mmag_attribute_group` ag INNER JOIN `mmag_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `mmag_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `mmag_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN mmag_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN mmag_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `mmag_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
5 queries	SELECT pac.id_attribute, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = XX AND pl.id_lang = XX) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mmag_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY pac.id_attribute
5 queries	SELECT XX FROM `mmag_specific_price` WHERE id_product = XX LIMIT XX
4 queries	SELECT cc.name FROM mmag_cookiesplus_cookie cc LEFT JOIN mmag_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
4 queries	SELECT * FROM `mmag_category` a LEFT JOIN `mmag_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
4 queries	SELECT * FROM `mmag_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
4 queries	SELECT image_shop.`id_image` FROM `mmag_image` i INNER JOIN mmag_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
4 queries	SELECT cl.`link_rewrite` FROM `mmag_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 queries	SELECT name FROM mmag_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
4 queries	SELECT * FROM `mmag_product` a LEFT JOIN `mmag_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `mmag_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
4 queries	SELECT `priority`, `id_specific_price_priority` FROM `mmag_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
4 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `mmag_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
4 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `mmag_product` p INNER JOIN `mmag_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `mmag_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
4 queries	SELECT `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
4 queries	SELECT `reduction` FROM `mmag_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
4 queries	SELECT COUNT(*) FROM `mmag_pack` WHERE id_product_pack = XX LIMIT XX
4 queries	SELECT product_type FROM `mmag_product` WHERE id_product = XX LIMIT XX
4 queries	SELECT SUM(quantity) FROM `mmag_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `mmag_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `mmag_cart_product` cp JOIN `mmag_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mmag_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
4 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM mmag_feature_product pf LEFT JOIN mmag_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN mmag_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN mmag_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN mmag_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
4 queries	SELECT * FROM `mmag_image` i LEFT JOIN `mmag_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER BY i.`position` ASC
4 queries	SELECT * FROM `mmag_product` a LEFT JOIN `mmag_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
4 queries	SELECT * FROM `mmag_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
4 queries	SELECT `id_category` FROM `mmag_category_product` WHERE `id_product` = XX
4 queries	SELECT count(XX) FROM `mmag_st_wishlist_product` whp LEFT JOIN `mmag_st_wishlist` wh ON (wh.`id_st_wishlist`=whp.`id_st_wishlist`) WHERE whp.`id_product` = XX AND wh.`id_customer`=XX AND wh.`id_shop`= XX LIMIT XX
4 queries	SELECT COUNT(XX) as total, (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `mmag_st_product_comment` pc WHERE pc.`id_product` = XX AND pc.`id_parent` = XX AND pc.`id_shop`=XX AND pc.`validate` = XX LIMIT XX
4 queries	SELECT `id_product_attribute` FROM `mmag_product_attribute` WHERE `id_product` = XX
4 queries	SELECT * FROM mmag_cookiesplus_cookie cc LEFT JOIN mmag_cookiesplus_cookie_lang ccl on cc.`id_cookiesplus_cookie` = ccl.`id_cookiesplus_cookie` WHERE `id_cookiesplus_finality` = XX AND ccl.`id_lang` = XX AND cc.`active` = XX AND cc.`id_shop` = XX ORDER BY cc.`name`;
3 queries	SELECT tr.* FROM `mmag_tax_rule` tr JOIN `mmag_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT id_st_sticker FROM `mmag_st_sticker_map` WHERE active = XX AND (location = XX OR (location = XX AND (id_category = XX OR id_category IN(XX,XX,XX,XX,XX,XX,XX))) OR (location = XX AND (id_products LIKE "%,XX,%")))
2 queries	SELECT `id_lang` FROM `mmag_lang` WHERE `locale` = 'ro-ro' OR `language_code` = 'ro-ro' LIMIT XX
2 queries	SELECT `id_category` FROM `mmag_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT s., sl. ,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang FROM `mmag_st_sticker` s LEFT JOIN `mmag_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = XX) LEFT JOIN `mmag_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`) LEFT JOIN `mmag_st_sticker_group` sg ON (s.`id_st_sticker` = sg.`id_st_sticker`) WHERE ss.`id_shop` = XX AND s.`active`=XX AND s.`type` IN (XX,XX,XX,XX,XX,XX,XX) AND sg.`id_group` IN (XX) GROUP BY s.`id_st_sticker` ORDER BY s.`position` ASC, s.`id_st_sticker`
2 queries	SELECT XX FROM `mmag_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT snl., snll. FROM `mmag_st_notification` snl INNER JOIN mmag_st_notification_shop st_notification_shop ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = XX) LEFT JOIN `mmag_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`) WHERE snl.`active`=XX AND snll.`id_lang` = XX ORDER BY snl.`position`
2 queries	SELECT snl., snll. FROM `mmag_st_sidebar` snl INNER JOIN mmag_st_sidebar_shop st_sidebar_shop ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = XX) LEFT JOIN `mmag_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`) WHERE snll.`id_lang` = XX AND snl.`active`=XX ORDER BY snl.`location`, snl.`position`

Name	Instances	Source
Category	47	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 17] /override/classes/Link.php:63 (__construct) [id: 17] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 18] /override/classes/Link.php:63 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 19] /override/classes/Link.php:63 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 21] /override/classes/Link.php:63 (__construct) [id: 21] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 22] /override/classes/Link.php:63 (__construct) [id: 22] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 23] /override/classes/Link.php:63 (__construct) [id: 23] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 27] /override/classes/Link.php:63 (__construct) [id: 27] /classes/Meta.php:380 (__construct) [id: 10] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 10] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 19] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 26] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 10] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ststickers/classes/StStickersMapClass.php:159 (__construct) [id: 17] /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /override/classes/Link.php:63 (__construct) [id: 17] /override/classes/Link.php:63 (__construct) [id: 18] /override/classes/Link.php:63 (__construct) [id: 19] /override/classes/Link.php:63 (__construct) [id: 21] /override/classes/Link.php:63 (__construct) [id: 22] /override/classes/Link.php:63 (__construct) [id: 23] /override/classes/Link.php:63 (__construct) [id: 27] /override/classes/Link.php:63 (__construct) [id: 10]
Product	16	/classes/Link.php:113 (__construct) [id: 36] /classes/Link.php:113 (__construct) [id: 58] /classes/Link.php:113 (__construct) [id: 91] /classes/Link.php:113 (__construct) [id: 35] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 36] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 58] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 91] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 35] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 36] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 58] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 91] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 35] /classes/Link.php:113 (__construct) [id: 36] /classes/Link.php:113 (__construct) [id: 58] /classes/Link.php:113 (__construct) [id: 91] /classes/Link.php:113 (__construct) [id: 35]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
Country	4	/config/config.inc.php:146 (__construct) [id: 36] /classes/AddressFormat.php:404 (__construct) [id: 36] /classes/controller/FrontController.php:1779 (__construct) [id: 36] /modules/ets_whatsapp/ets_whatsapp.php:466 (__construct) [id: 36]
CMS	2	/classes/Link.php:555 (__construct) [id: 11] /classes/Link.php:555 (__construct) [id: 11]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
State	2	/classes/AddressFormat.php:404 (__construct) [id: 353] /classes/controller/FrontController.php:1778 (__construct) [id: 353]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
AddressFormat	1	/classes/controller/FrontController.php:1773 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1705 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
2	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 `mmag_configuration` c LEFT JOIN `mmag_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	16.953 ms	3076			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
132	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=10)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) GROUP BY fp.id_feature_value	4.154 ms	2045652	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
20	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `mmag_module` m INNER JOIN mmag_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 `mmag_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `mmag_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `mmag_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`	2.999 ms	2052	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /override/classes/Dispatcher.php:90 (loadRoutes) /classes/Dispatcher.php:243 (loadRoutes) /override/classes/Dispatcher.php:42 (__construct) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
102	SELECT SQL_NO_CACHE cp.id_category, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>9 AND c.nright<24 GROUP BY cp.id_category	2.981 ms	2151296	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
154	REPLACE INTO mmag_layered_filter_block (hash, data) VALUES ("c910f6a83b934c1da75b79ad79ad6f90", "a:1:{s:7:\"filters\";a:21:{i:0;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Pret\";s:3:\"max\";d:999;s:3:\"min\";d:95;s:4:\"unit\";s:3:\"lei\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"RON\";s:14:\"currencySymbol\";s:3:\"lei\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:4;s:5:\"value\";N;}i:1;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:15:\"Disponibilitate\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:7:\"In stoc\";s:3:\"nbr\";i:4;}i:0;a:2:{s:4:\"name\";s:12:\"Indisponibil\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:2;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Selectii\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:11:\"La reducere\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:10:\"Produs nou\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:5:\"Redus\";s:3:\"nbr\";i:4;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Categorii\";s:6:\"values\";a:2:{i:17;a:2:{s:4:\"name\";s:6:\"Veioze\";s:3:\"nbr\";s:1:\"1\";}i:19;a:2:{s:4:\"name\";s:6:\"Lustre\";s:3:\"nbr\";s:1:\"3\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"1\";s:6:\"values\";a:3:{i:696;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Sticla\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:699;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:36:\"Stofa si cristale pandative acrilice\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:697;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"Textil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Compozitie abajur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"2\";s:6:\"values\";a:2:{i:784;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Clasic\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:786;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:19:\"Modern, contemporan\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:4:\"Stil\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:1:{i:15;a:2:{s:4:\"name\";s:9:\"Faneurope\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Stare\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"Nou\";s:3:\"nbr\";s:1:\"4\";}s:4:\"used\";a:2:{s:4:\"name\";s:7:\"Folosit\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:13:\"Reconditionat\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:8;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:8:\"Greutate\";s:3:\"max\";d:10;s:3:\"min\";d:0.5;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:4;}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"4\";s:6:\"values\";a:5:{i:774;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:1:\"1\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:775;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:1:\"2\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:778;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"5\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:779;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:1:\"6\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:780;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:1:\"8\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:12:\"Numar becuri\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"5\";s:6:\"values\";a:2:{i:823;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"37 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:809;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:15:\"120 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"7\";s:6:\"values\";a:1:{i:741;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:8:\"Interior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:20:\"Domeniu de utilizare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:12;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"9\";s:6:\"values\";a:2:{i:791;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"E14\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:793;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"E27\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Tip bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:13;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"10\";s:6:\"values\";a:12:{i:725;a:4:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:3:\"Alb\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:723;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"Alb si crem\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:733;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Alb si gri\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:730;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"Alb transparent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:737;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:8:\"Argintiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:734;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Crem\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:727;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:4:\"Crom\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:729;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:10:\"Multicolor\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:728;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Negru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:740;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"Negru si auriu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:731;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Portocaliu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:726;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"Transparent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:7:\"Culoare\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:14;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"11\";s:6:\"values\";a:2:{i:713;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"Metal\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:715;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:12:\"Metal cromat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:17:\"Compozitie suport\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:15;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:1:{i:753;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Metal\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:14:\"Material cadru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:16;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"13\";s:6:\"values\";a:1:{i:751;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"60W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Putere bec\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"14\";s:6:\"values\";a:1:{i:693;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:4:\"IP20\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:15:\"Clasa protectie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:18;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"20\";s:6:\"values\";a:2:{i:852;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"11 cm latime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:858;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:12:\"40 cm latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"Latime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:19;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"21\";s:6:\"values\";a:1:{i:834;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"40 cm lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:20;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"22\";s:6:\"values\";a:2:{i:839;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"30 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:844;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"40 cm diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Diametru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	2.847 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
142	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.836 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
149	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=21)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.802 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock=0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726)))	2.735 ms	1075648			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726)))	2.700 ms	1075648			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
109	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=2)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.696 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 36) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:08' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:08' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sp.reduction>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726)))	2.668 ms	3226944			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
97	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((sa.quantity>0)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726)))	2.628 ms	1075648			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=20)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.615 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
126	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=5)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.584 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
153	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=23)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.568 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.554 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
171	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 `mmag_hook_module` hm STRAIGHT_JOIN `mmag_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `mmag_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.526 ms	586			/classes/Hook.php:459 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /override/classes/ProductAssembler.php:55 (assembleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
151	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=22)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.523 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
146	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=19)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.504 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
138	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.498 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
145	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=18)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.487 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((p.on_sale=1)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726)))	2.481 ms	1075648			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
136	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=12)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.470 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
140	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.450 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
112	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) GROUP BY p.id_manufacturer	2.446 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=9)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.439 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
134	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=11)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.431 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
144	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=17)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.428 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	SELECT SQL_NO_CACHE p.id_product 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) GROUP BY p.id_product ORDER BY p.name ASC, p.id_product DESC	2.424 ms	3136	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
99	SELECT SQL_NO_CACHE 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND p.date_add>'2025-04-06 00:00:00'	2.404 ms	1075648			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
113	SELECT SQL_NO_CACHE p.condition, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) GROUP BY p.condition	2.362 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
170	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `mmag_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `mmag_hook_alias` ha INNER JOIN `mmag_hook` h ON ha.name = h.name	2.348 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5692 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /override/classes/ProductAssembler.php:55 (assembleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
119	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=6)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.130 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
118	SELECT SQL_NO_CACHE pac.id_attribute, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=7)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY pac.id_attribute	2.120 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	SELECT SQL_NO_CACHE pac.id_attribute, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=2)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY pac.id_attribute	2.114 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
124	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (741, 1198))) AND ((fp_1.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=4)) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	2.085 ms	21952	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
122	SELECT SQL_NO_CACHE pac.id_attribute, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=4)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY pac.id_attribute	2.028 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE pac.id_attribute, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=1)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY pac.id_attribute	2.003 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
128	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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p INNER JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=7)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) GROUP BY fp.id_feature_value	1.979 ms	21952	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
116	SELECT SQL_NO_CACHE pac.id_attribute, 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, pl.name FROM mmag_product p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mmag_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 mmag_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mmag_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) INNER JOIN mmag_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mmag_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mmag_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mmag_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mmag_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_1.id_feature_value IN (741, 1198))) AND ((fp_2.id_feature_value IN (737, 734, 727, 726))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=9 AND c.nright<=24 GROUP BY p.id_product) p LEFT JOIN mmag_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mmag_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mmag_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mmag_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=6)) AND ((fp_1.id_feature_value IN (1192, 1247, 1239, 1235, 1229, 1220, 1215, 1212, 1206, 1194, 1173, 1155, 774))) AND ((fp_2.id_feature_value IN (741, 1198))) AND ((fp_3.id_feature_value IN (737, 734, 727, 726))) GROUP BY pac.id_attribute	1.972 ms	1075648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /override/controllers/front/listing/CategoryController.php:22 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php

Corpuri de iluminat

Meniu

Cautare