Corpuri de Iluminat

Aplică exterior led, pe senzori cu design felinar modern

-80%

Limited special offer

(0)

APLICĂ EXTERIOR

399,00 lei
79,80 lei (inclusiv TVA)

Aplică de exterior cu design tip felinar, LANT-CLOE/AP1B

Adauga in cos

-60%

Limited special offer

(0)

APLICĂ EXTERIOR CU SENZORI

399,00 lei
159,60 lei (inclusiv TVA)

Aplică de exterior cu design tip felinar, LANT-CLOE/AP1A

Adauga in cos

Lampă de grădină, ornamentala în stil felinar

-40%

Limited special offer

(0)

LAMPĂ DE GRĂDINĂ

299,00 lei
179,40 lei (inclusiv TVA)

Lampă de grădină tip felinar, LANT-CLOE/L1

Adauga in cos

-60%

Limited special offer

(0)

LAMPĂ DE MASĂ LED

71,00 lei
28,40 lei (inclusiv TVA)

Lampa de masa LED Heaven aduce un plus de stil oricarui spatiu, combiannd eleganta cu functionalitatea. Designul sau curvat si iluminarea circulara creeaza atmosfera moderna si relaxanta.

Adauga in cos

Veioză modernă de masă din silicon – Design flexibil și inovator

-80%

Limited special offer

(0)

VEIOZĂ DE MASĂ ALBĂ

299,00 lei
59,80 lei (inclusiv TVA)

Veioză Modernă de Masă din Silicon, Stil Contemporan, I-DRUM/L BCO

Adauga in cos

-80%

Limited special offer

(0)

VEIOZĂ DE MASĂ ALBASTRĂ

299,00 lei
59,80 lei (inclusiv TVA)

Veioză Modernă de Masă din Silicon, Stil Contemporan, I-DRUM/L BLU

Adauga in cos

Veioză Modernă Albă cu Abajur din Sticlă Transparentă – Design Elegant pentru Orice Interior

-60%

Limited special offer

(0)

VEIOZĂ NEOCLASICĂ ALBĂ

299,00 lei
119,60 lei (inclusiv TVA)

Veioză neoclasică, alb cromată, cu 1 bec, I-AURORA-L1 BCO

Adauga in cos

Veioză Modernă Transparenta cu Abajur din Sticlă – Design Elegant pentru Orice Interior

-60%

Limited special offer

(0)

VEIOZĂ NEOCLASICĂ TRANSPARENTĂ

299,00 lei
119,60 lei (inclusiv TVA)

Veioză neoclasică, alb cromată, cu 1 bec, I-AURORA-L1 TR

Adauga in cos

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	804 ms
Querying Time	373 ms
Queries	475
Memory Peak Usage	18.0 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 $smarty	1k
- 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

APLICĂ EXTERIOR

APLICĂ EXTERIOR CU SENZORI

LAMPĂ DE GRĂDINĂ

LAMPĂ DE MASĂ LED

VEIOZĂ DE MASĂ ALBĂ

VEIOZĂ DE MASĂ ALBASTRĂ

VEIOZĂ NEOCLASICĂ ALBĂ

VEIOZĂ NEOCLASICĂ TRANSPARENTĂ

Meniu

Cautare

Stopwatch SQL - 475 queries

Doubles

Tables stress

ObjectModel instances

Included Files

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	22.526 ms	22.526 ms	4.79 Mb	4.9 Mb
__construct	0.019 ms	22.545 ms	- Mb	4.9 Mb
init	11.279 ms	33.824 ms	0.78 Mb	5.6 Mb
checkAccess	0.002 ms	33.826 ms	- Mb	5.6 Mb
setMedia	3.256 ms	37.082 ms	0.18 Mb	5.8 Mb
postProcess	0.001 ms	37.083 ms	- Mb	5.8 Mb
initHeader	0.002 ms	37.085 ms	- Mb	5.8 Mb
initContent	406.056 ms	443.141 ms	9.14 Mb	15.0 Mb
initFooter	0.003 ms	443.144 ms	- Mb	15.0 Mb
display	361.297 ms	804 ms	2.78 Mb	18.0 Mb

Hook	Time	Memory Usage
ActionStAssemble	93.411 ms	1.16 Mb
=> stthemeeditor	2.740 ms	0.01 Mb
=> sthoverimage	0.371 ms	0.01 Mb
=> stcompare	0.008 ms	- Mb
=> ststickers	14.241 ms	0.18 Mb
=> stwishlist	0.318 ms	0.01 Mb
=> stproductcomments	0.319 ms	0.01 Mb
=> stthemeeditor	0.446 ms	0.01 Mb
=> sthoverimage	0.367 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	10.425 ms	0.11 Mb
=> stwishlist	0.300 ms	0.01 Mb
=> stproductcomments	0.321 ms	0.01 Mb
=> stthemeeditor	0.491 ms	0.01 Mb
=> sthoverimage	0.350 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	10.226 ms	0.13 Mb
=> stwishlist	3.059 ms	0.01 Mb
=> stproductcomments	0.381 ms	0.01 Mb
=> stthemeeditor	0.530 ms	0.01 Mb
=> sthoverimage	0.364 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	7.276 ms	0.11 Mb
=> stwishlist	0.372 ms	0.01 Mb
=> stproductcomments	1.136 ms	0.01 Mb
=> stthemeeditor	0.463 ms	0.01 Mb
=> sthoverimage	1.565 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	7.436 ms	0.09 Mb
=> stwishlist	0.271 ms	0.01 Mb
=> stproductcomments	0.286 ms	0.01 Mb
=> stthemeeditor	0.415 ms	0.01 Mb
=> sthoverimage	0.351 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	8.550 ms	0.09 Mb
=> stwishlist	0.308 ms	0.01 Mb
=> stproductcomments	0.314 ms	0.01 Mb
=> stthemeeditor	0.481 ms	0.01 Mb
=> sthoverimage	0.372 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	8.174 ms	0.09 Mb
=> stwishlist	0.282 ms	0.01 Mb
=> stproductcomments	0.342 ms	0.01 Mb
=> stthemeeditor	0.474 ms	0.01 Mb
=> sthoverimage	0.338 ms	0.01 Mb
=> stcompare	0.003 ms	- Mb
=> ststickers	8.317 ms	0.09 Mb
=> stwishlist	0.294 ms	0.01 Mb
=> stproductcomments	0.316 ms	0.01 Mb
DisplayHeader	14.809 ms	0.83 Mb
=> stthemeeditor	3.502 ms	0.24 Mb
=> ps_googleanalytics	0.208 ms	0.01 Mb
=> stcustomersignin	0.705 ms	0.02 Mb
=> stmultilink	0.522 ms	0.01 Mb
=> stsearchbar	0.352 ms	0.01 Mb
=> stshoppingcart	0.370 ms	0.01 Mb
=> stmegamenu	0.305 ms	0.01 Mb
=> stswiper	0.217 ms	0.07 Mb
=> stowlcarousel	0.260 ms	0.01 Mb
=> steasycontent	0.312 ms	0.03 Mb
=> stfeaturedslider	0.296 ms	0.01 Mb
=> stfeaturedcategories	0.288 ms	0.01 Mb
=> stblogeditor	0.251 ms	0.01 Mb
=> stblogfeaturedarticles	0.218 ms	0.01 Mb
=> stbanner	0.214 ms	0.01 Mb
=> stbrandsslider	0.201 ms	0.01 Mb
=> stspecialslider	0.299 ms	0.01 Mb
=> stblogrecentarticles	0.200 ms	0.01 Mb
=> stnewsletter	0.233 ms	0.01 Mb
=> stblogarchives	0.016 ms	- Mb
=> stblogcomments	0.061 ms	- Mb
=> stblogrelatedarticles	0.234 ms	0.01 Mb
=> stcountdown	0.270 ms	0.01 Mb
=> sthoverimage	0.070 ms	- Mb
=> stinstagram	0.464 ms	0.04 Mb
=> stcompare	0.385 ms	0.01 Mb
=> stnotification	0.218 ms	0.01 Mb
=> stpagebanner	0.247 ms	0.01 Mb
=> stproductcategoriesslider	0.348 ms	0.01 Mb
=> strelatedproducts	0.287 ms	0.01 Mb
=> stsidebar	0.250 ms	0.01 Mb
=> ststickers	0.906 ms	0.09 Mb
=> stvideo	0.221 ms	0.01 Mb
=> stwishlist	0.386 ms	0.02 Mb
=> stproductcomments	0.412 ms	0.01 Mb
=> stproductsasattrs	0.281 ms	0.01 Mb
=> sturls	0.055 ms	- Mb
=> cookiesplus	0.641 ms	0.02 Mb
=> ets_recaptcha_free	0.012 ms	- Mb
=> ets_whatsapp	0.092 ms	- Mb
DisplayBeforeBodyClosingTag	6.097 ms	0.48 Mb
=> ps_googleanalytics	1.417 ms	0.07 Mb
=> statsdata	0.668 ms	0.06 Mb
=> stwishlist	0.161 ms	- Mb
=> cookiesplus	3.851 ms	0.34 Mb
displayLeftColumn	3.349 ms	0.15 Mb
=> ps_categorytree (widget)	3.349 ms	0.15 Mb
DisplaySideBar	3.325 ms	0.16 Mb
=> stsidebar	0.810 ms	0.02 Mb
=> stnewsletter	0.669 ms	0.02 Mb
=> stmegamenu	0.350 ms	0.03 Mb
=> stwishlist	0.891 ms	0.06 Mb
=> stsearchbar	0.257 ms	0.01 Mb
=> stshoppingcart	0.348 ms	0.03 Mb
displayTop	3.151 ms	0.14 Mb
=> stcustomersignin (widget)	2.618 ms	0.13 Mb
=> stshoppingcart (widget)	0.533 ms	0.01 Mb
displayBanner	2.473 ms	0.17 Mb
=> stnotification (widget)	1.499 ms	0.09 Mb
=> steasycontent (widget)	0.974 ms	0.08 Mb
ActionFrontControllerSetMedia	2.191 ms	0.05 Mb
=> ps_emailalerts	0.039 ms	- Mb
=> cookiesplus	2.152 ms	0.05 Mb
ActionOutputHTMLBefore	1.698 ms	0.01 Mb
=> cookiesplus	1.508 ms	0.01 Mb
=> stswiper	0.049 ms	- Mb
=> stbanner	0.089 ms	- Mb
=> stinstagram	0.052 ms	- Mb
DisplayMobileBar	1.476 ms	0.03 Mb
=> stsidebar	1.476 ms	0.03 Mb
DisplayMobileBarLeft	1.317 ms	0.14 Mb
=> stsidebar	1.317 ms	0.14 Mb
DisplayMainMenu	1.309 ms	0.03 Mb
=> stmegamenu	1.309 ms	0.03 Mb
DisplayMobileBarCenter	1.156 ms	- Mb
=> stsidebar	1.156 ms	- Mb
DisplayFooter	1.049 ms	0.08 Mb
=> ets_whatsapp	0.244 ms	0.02 Mb
=> stnewsletter	0.278 ms	0.02 Mb
=> stmultilink	0.267 ms	0.02 Mb
=> steasycontent	0.260 ms	0.02 Mb
ActionDispatcherBefore	1.001 ms	0.01 Mb
=> sturls	0.992 ms	0.01 Mb
=> ets_delete_order	0.009 ms	- Mb
displayHeaderCenter	0.955 ms	0.03 Mb
=> stsearchbar (widget)	0.955 ms	0.03 Mb
displayBeforeBodyClosingTag	0.923 ms	0.02 Mb
=> stnotification (widget)	0.923 ms	0.02 Mb
displayFullWidthTop	0.833 ms	0.05 Mb
=> stswiper (widget)	0.817 ms	0.05 Mb
=> steasycontent (widget)	0.016 ms	- Mb
ActionProductSearchAfter	0.830 ms	0.02 Mb
=> stthemeeditor	0.008 ms	- Mb
=> stcountdown	0.014 ms	- Mb
=> stcompare	0.050 ms	- Mb
=> ststickers	0.723 ms	0.01 Mb
=> stwishlist	0.035 ms	- Mb
DisplayCategoryHeader	0.726 ms	0.03 Mb
=> stswiper	0.213 ms	0.01 Mb
=> stowlcarousel	0.249 ms	0.01 Mb
=> stbanner	0.264 ms	0.01 Mb
DisplayLeftColumn	0.565 ms	0.13 Mb
=> ps_facetedsearch	0.233 ms	0.12 Mb
=> stmegamenu	0.332 ms	0.01 Mb
DisplayRightBar	0.424 ms	0.04 Mb
=> stsidebar	0.424 ms	0.04 Mb
DisplayBreadcrumb	0.377 ms	0.01 Mb
=> stpagebanner	0.377 ms	0.01 Mb
DisplayFooterAfter	0.294 ms	0.01 Mb
=> stmultilink	0.294 ms	0.01 Mb
DisplayNav2	0.263 ms	0.01 Mb
=> stmultilink	0.263 ms	0.01 Mb
DisplayNav1	0.229 ms	0.02 Mb
=> stmultilink	0.229 ms	0.02 Mb
ProductSearchProvider	0.198 ms	- Mb
=> ps_facetedsearch	0.198 ms	- Mb
DisplayMobileBarBottom	0.179 ms	- Mb
=> stsidebar	0.179 ms	- Mb
ModuleRoutes	0.067 ms	0.01 Mb
=> stblog	0.005 ms	- Mb
=> stblogarchives	0.001 ms	- Mb
=> stblogsearch	0.002 ms	- Mb
=> sturls	0.034 ms	0.01 Mb
=> cookiesplus	0.025 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.010 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.003 ms	- Mb
=> stblog	0.004 ms	- Mb
DisplayAfterBodyOpeningTag	0.010 ms	- Mb
=> cookiesplus	0.010 ms	- Mb
DisplayFullWidthBottom	0.005 ms	- Mb
=> stblogfeaturedarticles	0.005 ms	- Mb
FilterProductSearch	0.004 ms	- Mb
=> stsearchbar	0.004 ms	- Mb
DisplayFullWidthTop	0.003 ms	- Mb
=> stfeaturedslider	0.002 ms	- Mb
=> stproductcategoriesslider	0.001 ms	- Mb
36 hook(s)	144.741 ms	3.83 Mb

Module	Time	Memory Usage
sturls	2.076 ms	0.06 Mb
__construct	0.964 ms	0.04 Mb
hookModuleRoutes	0.035 ms	0.01 Mb
hookActionDispatcherBefore	0.995 ms	0.01 Mb
hookActionDispatcher	0.025 ms	- Mb
hookDisplayHeader	0.057 ms	- Mb
stblog	1.667 ms	0.10 Mb
__construct	1.631 ms	0.09 Mb
hookModuleRoutes	0.011 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.006 ms	- Mb
hookOverrideLayoutTemplate	0.014 ms	- Mb
stblogarchives	0.751 ms	0.03 Mb
__construct	0.730 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
hookDisplayHeader	0.017 ms	- Mb
stblogsearch	0.821 ms	0.03 Mb
__construct	0.817 ms	0.03 Mb
hookModuleRoutes	0.004 ms	- Mb
cookiesplus	9.214 ms	0.52 Mb
__construct	1.008 ms	0.09 Mb
hookModuleRoutes	0.027 ms	- Mb
hookActionFrontControllerSetMedia	2.155 ms	0.05 Mb
hookDisplayHeader	0.644 ms	0.02 Mb
hookDisplayAfterBodyOpeningTag	0.013 ms	- Mb
hookDisplayBeforeBodyClosingTag	3.855 ms	0.34 Mb
hookActionOutputHTMLBefore	1.512 ms	0.01 Mb
ets_delete_order	0.799 ms	0.14 Mb
__construct	0.788 ms	0.14 Mb
hookActionDispatcherBefore	0.011 ms	- Mb
ps_emailalerts	0.799 ms	0.12 Mb
__construct	0.757 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.042 ms	- Mb
stthemeeditor	9.912 ms	0.45 Mb
__construct	0.332 ms	0.09 Mb
hookDisplayHeader	3.505 ms	0.24 Mb
hookActionStAssemble	2.747 ms	0.02 Mb
hookActionStAssemble	0.449 ms	0.01 Mb
hookActionStAssemble	0.494 ms	0.01 Mb
hookActionStAssemble	0.533 ms	0.01 Mb
hookActionStAssemble	0.466 ms	0.01 Mb
hookActionStAssemble	0.417 ms	0.01 Mb
hookActionStAssemble	0.483 ms	0.01 Mb
hookActionStAssemble	0.477 ms	0.01 Mb
hookActionProductSearchAfter	0.009 ms	- Mb
ps_googleanalytics	1.724 ms	0.11 Mb
__construct	0.093 ms	0.03 Mb
hookDisplayHeader	0.211 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.420 ms	0.07 Mb
stcustomersignin	3.450 ms	0.18 Mb
__construct	0.121 ms	0.02 Mb
hookDisplayHeader	0.708 ms	0.02 Mb
displayTop	2.621 ms	0.13 Mb
stmultilink	1.802 ms	0.13 Mb
__construct	0.214 ms	0.05 Mb
hookDisplayHeader	0.525 ms	0.01 Mb
hookDisplayNav1	0.231 ms	0.02 Mb
hookDisplayNav2	0.266 ms	0.01 Mb
hookDisplayFooter	0.269 ms	0.02 Mb
hookDisplayFooterAfter	0.297 ms	0.01 Mb
stsearchbar	1.737 ms	0.09 Mb
__construct	0.156 ms	0.03 Mb
hookDisplayHeader	0.355 ms	0.01 Mb
displayHeaderCenter	0.959 ms	0.03 Mb
hookFilterProductSearch	0.007 ms	- Mb
hookDisplaySideBar	0.260 ms	0.01 Mb
stshoppingcart	1.395 ms	0.14 Mb
__construct	0.137 ms	0.08 Mb
hookDisplayHeader	0.372 ms	0.01 Mb
displayTop	0.536 ms	0.01 Mb
hookDisplaySideBar	0.350 ms	0.03 Mb
stmegamenu	2.535 ms	0.14 Mb
__construct	0.226 ms	0.06 Mb
hookDisplayHeader	0.308 ms	0.01 Mb
hookDisplayMainMenu	1.313 ms	0.03 Mb
hookDisplayLeftColumn	0.335 ms	0.01 Mb
hookDisplaySideBar	0.353 ms	0.03 Mb
stswiper	1.586 ms	0.23 Mb
__construct	0.280 ms	0.09 Mb
hookDisplayHeader	0.219 ms	0.07 Mb
displayFullWidthTop	0.820 ms	0.05 Mb
hookDisplayCategoryHeader	0.216 ms	0.01 Mb
hookActionOutputHTMLBefore	0.051 ms	- Mb
stowlcarousel	0.725 ms	0.08 Mb
__construct	0.209 ms	0.06 Mb
hookDisplayHeader	0.264 ms	0.01 Mb
hookDisplayCategoryHeader	0.252 ms	0.01 Mb
steasycontent	2.045 ms	0.31 Mb
__construct	0.459 ms	0.17 Mb
hookDisplayHeader	0.315 ms	0.03 Mb
displayBanner	0.977 ms	0.08 Mb
displayFullWidthTop	0.017 ms	- Mb
displayFullWidthTop2	0.015 ms	- Mb
hookDisplayFooter	0.262 ms	0.02 Mb
stfeaturedslider	0.507 ms	0.08 Mb
__construct	0.204 ms	0.07 Mb
hookDisplayHeader	0.299 ms	0.01 Mb
hookDisplayFullWidthTop	0.004 ms	- Mb
stfeaturedcategories	0.428 ms	0.05 Mb
__construct	0.138 ms	0.04 Mb
hookDisplayHeader	0.290 ms	0.01 Mb
stblogeditor	0.344 ms	0.05 Mb
__construct	0.091 ms	0.03 Mb
hookDisplayHeader	0.253 ms	0.01 Mb
stblogfeaturedarticles	0.334 ms	0.13 Mb
__construct	0.105 ms	0.11 Mb
hookDisplayHeader	0.221 ms	0.01 Mb
hookDisplayFullWidthBottom	0.008 ms	- Mb
stbanner	0.812 ms	0.09 Mb
__construct	0.238 ms	0.06 Mb
hookDisplayHeader	0.217 ms	0.01 Mb
hookDisplayCategoryHeader	0.267 ms	0.01 Mb
hookActionOutputHTMLBefore	0.090 ms	- Mb
stbrandsslider	0.327 ms	0.04 Mb
__construct	0.123 ms	0.03 Mb
hookDisplayHeader	0.204 ms	0.01 Mb
stspecialslider	0.450 ms	0.04 Mb
__construct	0.147 ms	0.03 Mb
hookDisplayHeader	0.303 ms	0.01 Mb
stblogrecentarticles	0.292 ms	0.04 Mb
__construct	0.090 ms	0.03 Mb
hookDisplayHeader	0.202 ms	0.01 Mb
stnewsletter	1.347 ms	0.16 Mb
__construct	0.158 ms	0.11 Mb
hookDisplayHeader	0.236 ms	0.01 Mb
hookDisplayFooter	0.281 ms	0.02 Mb
hookDisplaySideBar	0.672 ms	0.02 Mb
stblogcomments	0.193 ms	0.04 Mb
__construct	0.129 ms	0.04 Mb
hookDisplayHeader	0.064 ms	- Mb
stblogrelatedarticles	0.323 ms	0.04 Mb
__construct	0.087 ms	0.03 Mb
hookDisplayHeader	0.236 ms	0.01 Mb
stcountdown	0.406 ms	0.04 Mb
__construct	0.117 ms	0.03 Mb
hookDisplayHeader	0.273 ms	0.02 Mb
hookActionProductSearchAfter	0.016 ms	- Mb
sthoverimage	4.310 ms	0.09 Mb
__construct	0.136 ms	0.03 Mb
hookDisplayHeader	0.072 ms	- Mb
hookActionStAssemble	0.375 ms	0.01 Mb
hookActionStAssemble	0.370 ms	0.01 Mb
hookActionStAssemble	0.353 ms	0.01 Mb
hookActionStAssemble	0.367 ms	0.01 Mb
hookActionStAssemble	1.568 ms	0.01 Mb
hookActionStAssemble	0.353 ms	0.01 Mb
hookActionStAssemble	0.375 ms	0.01 Mb
hookActionStAssemble	0.341 ms	0.01 Mb
stinstagram	0.822 ms	0.17 Mb
__construct	0.302 ms	0.13 Mb
hookDisplayHeader	0.467 ms	0.04 Mb
hookActionOutputHTMLBefore	0.053 ms	- Mb
stcompare	0.629 ms	0.06 Mb
__construct	0.153 ms	0.03 Mb
hookDisplayHeader	0.388 ms	0.01 Mb
hookActionStAssemble	0.009 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionStAssemble	0.004 ms	- Mb
hookActionProductSearchAfter	0.051 ms	- Mb
stnotification	2.816 ms	0.18 Mb
__construct	0.167 ms	0.05 Mb
hookDisplayHeader	0.220 ms	0.01 Mb
displayBanner	1.503 ms	0.09 Mb
displayBeforeBodyClosingTag	0.926 ms	0.02 Mb
stpagebanner	0.826 ms	0.06 Mb
__construct	0.196 ms	0.04 Mb
hookDisplayHeader	0.250 ms	0.01 Mb
hookDisplayBreadcrumb	0.380 ms	0.01 Mb
stproductcategoriesslider	0.872 ms	0.15 Mb
__construct	0.519 ms	0.14 Mb
hookDisplayHeader	0.351 ms	0.01 Mb
hookDisplayFullWidthTop	0.002 ms	- Mb
strelatedproducts	0.443 ms	0.04 Mb
__construct	0.153 ms	0.03 Mb
hookDisplayHeader	0.290 ms	0.01 Mb
stsidebar	5.888 ms	0.30 Mb
__construct	0.253 ms	0.05 Mb
hookDisplayHeader	0.253 ms	0.01 Mb
hookDisplayMobileBarLeft	1.321 ms	0.14 Mb
hookDisplayMobileBarCenter	1.160 ms	- Mb
hookDisplayMobileBar	1.479 ms	0.03 Mb
hookDisplayMobileBarBottom	0.182 ms	- Mb
hookDisplaySideBar	0.813 ms	0.02 Mb
hookDisplayRightBar	0.427 ms	0.04 Mb
ststickers	76.572 ms	1.04 Mb
__construct	0.265 ms	0.06 Mb
hookDisplayHeader	0.909 ms	0.09 Mb
hookActionStAssemble	14.244 ms	0.18 Mb
hookActionStAssemble	10.428 ms	0.11 Mb
hookActionStAssemble	10.231 ms	0.13 Mb
hookActionStAssemble	7.279 ms	0.11 Mb
hookActionStAssemble	7.439 ms	0.09 Mb
hookActionStAssemble	8.554 ms	0.09 Mb
hookActionStAssemble	8.177 ms	0.09 Mb
hookActionStAssemble	8.321 ms	0.09 Mb
hookActionProductSearchAfter	0.726 ms	0.02 Mb
stvideo	0.464 ms	0.06 Mb
__construct	0.240 ms	0.05 Mb
hookDisplayHeader	0.224 ms	0.01 Mb
stwishlist	6.987 ms	0.19 Mb
__construct	0.269 ms	0.05 Mb
hookDisplayHeader	0.389 ms	0.02 Mb
hookActionStAssemble	0.321 ms	0.01 Mb
hookActionStAssemble	0.302 ms	0.01 Mb
hookActionStAssemble	3.062 ms	0.01 Mb
hookActionStAssemble	0.375 ms	0.01 Mb
hookActionStAssemble	0.273 ms	0.01 Mb
hookActionStAssemble	0.321 ms	0.01 Mb
hookActionStAssemble	0.285 ms	0.01 Mb
hookActionStAssemble	0.296 ms	0.01 Mb
hookActionProductSearchAfter	0.037 ms	- Mb
hookDisplaySideBar	0.894 ms	0.06 Mb
hookDisplayBeforeBodyClosingTag	0.163 ms	- Mb
stproductcomments	4.104 ms	0.20 Mb
__construct	0.252 ms	0.13 Mb
hookDisplayHeader	0.415 ms	0.01 Mb
hookActionStAssemble	0.322 ms	0.01 Mb
hookActionStAssemble	0.323 ms	0.01 Mb
hookActionStAssemble	0.384 ms	0.01 Mb
hookActionStAssemble	1.138 ms	0.01 Mb
hookActionStAssemble	0.289 ms	0.01 Mb
hookActionStAssemble	0.317 ms	0.01 Mb
hookActionStAssemble	0.345 ms	0.01 Mb
hookActionStAssemble	0.319 ms	0.01 Mb
stproductsasattrs	0.446 ms	0.06 Mb
__construct	0.163 ms	0.04 Mb
hookDisplayHeader	0.283 ms	0.02 Mb
ets_recaptcha_free	0.165 ms	0.03 Mb
__construct	0.151 ms	0.03 Mb
hookDisplayHeader	0.014 ms	- Mb
ets_whatsapp	0.457 ms	0.04 Mb
__construct	0.115 ms	0.02 Mb
hookDisplayHeader	0.095 ms	- Mb
hookDisplayFooter	0.247 ms	0.02 Mb
ps_facetedsearch	0.692 ms	0.16 Mb
__construct	0.255 ms	0.04 Mb
hookProductSearchProvider	0.201 ms	- Mb
hookDisplayLeftColumn	0.236 ms	0.12 Mb
ps_categorytree	3.483 ms	0.17 Mb
__construct	0.114 ms	0.02 Mb
displayLeftColumn	3.369 ms	0.15 Mb
statsdata	0.806 ms	0.08 Mb
__construct	0.135 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	0.671 ms	0.06 Mb
47 module(s)	159.584 ms	6.69 Mb

21 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_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) 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 ((sp.reduction>XX) OR (p.on_sale=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (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_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) 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 ((sp_XX.reduction>XX) OR (p.on_sale=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY fp.id_feature_value
20 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
20 queries	SELECT c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = XX LIMIT XX
20 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
18 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
16 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`
13 queries	SELECT `id_module` FROM `mmag_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
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
9 queries	SELECT XX FROM `mmag_specific_price` WHERE id_product = XX LIMIT XX
8 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
8 queries	SELECT name FROM mmag_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
8 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
8 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
8 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
8 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)
8 queries	SELECT `id_tax_rules_group` FROM `mmag_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
8 queries	SELECT `reduction` FROM `mmag_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
8 queries	SELECT COUNT(*) FROM `mmag_pack` WHERE id_product_pack = XX LIMIT XX
8 queries	SELECT product_type FROM `mmag_product` WHERE id_product = XX LIMIT XX
8 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
8 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
8 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
8 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
8 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
8 queries	SELECT * FROM `mmag_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
8 queries	SELECT `id_category` FROM `mmag_category_product` WHERE `id_product` = XX
8 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
8 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
8 queries	SELECT `id_product_attribute` FROM `mmag_product_attribute` WHERE `id_product` = XX
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
5 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
5 queries	SELECT * FROM `mmag_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5 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_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (XX, XX) AND sp.id_currency IN (XX, XX) AND sp.id_country IN (XX, XX) AND sp.id_group IN (XX, XX) AND sp.from_quantity = XX AND sp.reduction > XX AND sp.id_customer = XX AND sp.id_cart = XX AND (sp.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp.from) AND (sp.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp.to) ) 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 ((sp.reduction>XX) OR (p.on_sale=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (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_specific_price sp_XX ON ( sp_XX.id_product = p.id_product AND sp_XX.id_shop IN (XX, XX) AND sp_XX.id_currency IN (XX, XX) AND sp_XX.id_country IN (XX, XX) AND sp_XX.id_group IN (XX, XX) AND sp_XX.from_quantity = XX AND sp_XX.reduction > XX AND sp_XX.id_customer = XX AND sp_XX.id_cart = XX AND (sp_XX.from = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= sp_XX.from) AND (sp_XX.to = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= sp_XX.to) ) 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 ((sp_XX.reduction>XX) OR (p.on_sale=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX))) GROUP BY pac.id_attribute
5 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,%")))
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_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_manufacturer = XX OR id_manufacturer=XX)) OR (location = XX AND (id_category = XX OR id_category IN(XX,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 cl.`link_rewrite` FROM `mmag_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
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	67	/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: 22] /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: 22] /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: 21] /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/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/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/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/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	32	/classes/Link.php:113 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 92] /classes/Link.php:113 (__construct) [id: 94] /classes/Link.php:113 (__construct) [id: 107] /classes/Link.php:113 (__construct) [id: 48] /classes/Link.php:113 (__construct) [id: 49] /classes/Link.php:113 (__construct) [id: 34] /classes/Link.php:113 (__construct) [id: 35] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 93] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 92] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 94] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 107] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 48] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 49] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 34] /modules/ststickers/classes/StStickersMapClass.php:152 (__construct) [id: 35] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 93] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 92] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 94] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 107] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 48] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 49] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 34] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 35] /classes/Link.php:113 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 92] /classes/Link.php:113 (__construct) [id: 94] /classes/Link.php:113 (__construct) [id: 107] /classes/Link.php:113 (__construct) [id: 48] /classes/Link.php:113 (__construct) [id: 49] /classes/Link.php:113 (__construct) [id: 34] /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
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`	8.510 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)
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`)	6.915 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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp.to) ) LEFT JOIN mmag_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) LEFT JOIN mmag_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature=5)) AND ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	6.836 ms	375732	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 `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	4.766 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)
172	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	4.470 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)
173	SELECT SQL_NO_CACHE 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` = 1 AND tr.`id_country` = 36 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 353) AND ('013893' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '013893'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	4.437 ms	2	Yes		/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3926 (getTaxCalculator) /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)
154	REPLACE INTO mmag_layered_filter_block (hash, data) VALUES ("637fed080661e5cc5b246a42948a1399", "a:1:{s:7:\"filters\";a:23:{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:399;s:3:\"min\";d:28;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:8;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:8;}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:3:{s:4:\"name\";s:11:\"La reducere\";s:3:\"nbr\";i:0;s:7:\"checked\";b:1;}s:3:\"new\";a:2:{s:4:\"name\";s:10:\"Produs nou\";s:3:\"nbr\";i:1;}s:8:\"discount\";a:3:{s:4:\"name\";s:5:\"Redus\";s:3:\"nbr\";i:8;s:7:\"checked\";b:1;}}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:3:{i:17;a:2:{s:4:\"name\";s:6:\"Veioze\";s:3:\"nbr\";s:1:\"5\";}i:21;a:2:{s:4:\"name\";s:8:\"Exterior\";s:3:\"nbr\";s:1:\"1\";}i:22;a:2:{s:4:\"name\";s:6:\"Aplice\";s:3:\"nbr\";s:1:\"2\";}}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:711;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:12:\"Policarbonat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:702;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:7:\"Silicon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}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;}}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:790;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"Clasic, modern\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:786;a:4:{s:3:\"nbr\";s:1:\"2\";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:\"3\";}}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:\"8\";}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:2;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:8;}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:1:{i:774;a:4:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:1:\"1\";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:28:{i:1050;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"6 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:949;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"15 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:812;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"16 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:862;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"17.5 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:815;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"20 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:948;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"23 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:816;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"25 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:819;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"29 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:820;a:5:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:14:\"30 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:1047;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"32 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:822;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"35 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:823;a:5:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"37 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:824;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:17:\"37.9 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:825;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"38 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:826;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"42 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:828;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"46 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:829;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"55 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:830;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"59 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:952;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"60 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:831;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:15:\"67 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1133;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"71 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1052;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"72 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1046;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:14:\"77 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:832;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"84 cm inaltime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:808;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"100 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:811;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:15:\"150 cm inaltime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1262;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"180 CM\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:814;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:16:\"190 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:2:{i:743;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:8:\"Exterior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:741;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:8:\"Interior\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}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:3:{i:791;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:3:\"E14\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:794;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"G9\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:795;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:3:\"LED\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}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:4:{i:725;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"Alb\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:732;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:15:\"Alb si albastru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:728;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:5:\"Negru\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:726;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:11:\"Transparent\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}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:3:{i:722;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:8:\"Aluminiu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:715;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:12:\"Metal cromat\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:718;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:16:\"Plastic, Silicon\";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:\"13\";s:6:\"values\";a:3:{i:745;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"12W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1058;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"20W\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:749;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:3:\"40W\";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:16;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:2:{i:693;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:4:\"IP20\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:694;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:4:\"IP44\";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:17;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"15\";s:6:\"values\";a:1:{i:797;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Bec inclus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:20:\"Alte Caracteristici \";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:\"18\";s:6:\"values\";a:1:{i:800;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"4000k\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:22:\"Temperatura de 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:19;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"19\";s:6:\"values\";a:1:{i:1060;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"1660lm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:21:\"Intensitate luminoasa\";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:\"20\";s:6:\"values\";a:2:{i:852;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:13:\"11 cm latime \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:863;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:12:\"17 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:21;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:3:{i:864;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"17 cm lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:919;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:15:\"19,3 cm lungime\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1059;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:13:\"42 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:22;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:1:{i:835;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:14:\"13 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\";}}}")	4.029 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)
426	SELECT SQL_NO_CACHE 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 = 1) LEFT JOIN `mmag_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 49 ORDER BY `position`	3.591 ms	1	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /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)
222	SELECT SQL_NO_CACHE COUNT(*) FROM `mmag_pack` WHERE id_product_pack = 107 LIMIT 1	3.468 ms	1			/classes/Pack.php:89 /classes/Product.php:4344 (isPack) /classes/Product.php:5802 (getQuantity) /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)
396	SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `mmag_category` c WHERE c.`id_category` = 2 LIMIT 1	3.381 ms	1			/classes/Category.php:1591 /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
251	SELECT SQL_NO_CACHE product_type FROM `mmag_product` WHERE id_product = 49 LIMIT 1	3.329 ms	1			/classes/Pack.php:90 /classes/Product.php:4344 (isPack) /classes/Product.php:5802 (getQuantity) /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)
321	SELECT SQL_NO_CACHE id_st_sticker FROM `mmag_st_sticker_map` WHERE active = 1 AND (location = 0 OR (location = 3 AND (id_manufacturer = 0 OR id_manufacturer=15)) OR (location = 2 AND (id_category = 0 OR id_category IN(10,10,2,22,22,10,2,26))) OR (location = 1 AND (id_products LIKE "%,92,%")))	3.272 ms	1			/modules/ststickers/classes/StStickersMapClass.php:183 /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
189	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `mmag_specific_price_priority` WHERE `id_product` = 92 ORDER BY `id_specific_price_priority` DESC LIMIT 1	3.265 ms	0			/classes/SpecificPrice.php:259 /classes/SpecificPrice.php:239 (getPriority) /classes/SpecificPrice.php:565 (_getScoreQuery) /classes/Product.php:3827 (getSpecificPrice) /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)
197	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `mmag_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 92 UNION SELECT 0 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` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 92 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	3.259 ms	0			/classes/Cart.php:1430 /classes/Product.php:4361 (getProductQuantity) /classes/Product.php:5802 (getQuantity) /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)
100	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) AND cg.id_group='1' AND c.level_depth<=3 AND c.nleft>9 AND c.nright<24 GROUP BY cp.id_category	3.017 ms	222264	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)
341	SELECT SQL_NO_CACHE count(0) 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` = 94 AND wh.`id_customer`=0 AND wh.`id_shop`= 1 LIMIT 1	3.016 ms	1			/modules/stwishlist/classes/StWishListClass.php:369 /modules/stwishlist/stwishlist.php:1255 (countProCustomer) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.981 ms	111132	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)
328	SELECT SQL_NO_CACHE `id_category` FROM `mmag_category_product` WHERE `id_product` = 94	2.946 ms	3			/classes/Product.php:3423 /classes/Product.php:3476 (getProductCategories) /modules/ststickers/classes/StStickersMapClass.php:155 (getCategories) /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
367	SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `mmag_category` c LEFT JOIN `mmag_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 17 LIMIT 1	2.944 ms	1			/classes/Category.php:1585 /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
304	SELECT SQL_NO_CACHE id_st_sticker FROM `mmag_st_sticker_map` WHERE active = 1 AND (location = 0 OR (location = 3 AND (id_manufacturer = 0 OR id_manufacturer=15)) OR (location = 2 AND (id_category = 0 OR id_category IN(10,10,2,22,22,10,2,26))) OR (location = 1 AND (id_products LIKE "%,93,%")))	2.920 ms	1			/modules/ststickers/classes/StStickersMapClass.php:183 /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
214	SELECT SQL_NO_CACHE name FROM mmag_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 10 LIMIT 1	2.917 ms	1			/classes/Product.php:5659 /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)
265	SELECT SQL_NO_CACHE product_type FROM `mmag_product` WHERE id_product = 34 LIMIT 1	2.882 ms	1			/classes/Pack.php:90 /classes/Product.php:4344 (isPack) /classes/Product.php:5802 (getQuantity) /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)
105	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.872 ms	111132	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)
94	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795)))	2.836 ms	111132			/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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795)))	2.769 ms	111132			/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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.763 ms	111132	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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.725 ms	111132	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)
93	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795)))	2.723 ms	111132			/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)
238	SELECT SQL_NO_CACHE SUM(quantity) FROM `mmag_stock_available` WHERE (id_product = 48) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	2.720 ms	1			/classes/stock/StockAvailable.php:453 /classes/Product.php:4349 (getQuantityAvailableByProduct) /classes/Product.php:5802 (getQuantity) /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)
384	SELECT SQL_NO_CACHE id_st_sticker FROM `mmag_st_sticker_map` WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(10,10,2,17,17,10,2))) OR (location = 1 AND (id_products LIKE "%,49,%")))	2.716 ms	1			/modules/ststickers/classes/StStickersMapClass.php:183 /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
135	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.714 ms	111132	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.694 ms	111132	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)
143	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.671 ms	111132	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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=7)) AND ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.666 ms	111132	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)
411	SELECT SQL_NO_CACHE c., cl. FROM `mmag_category` c LEFT JOIN `mmag_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 10 AND c.`nright` >= 11 AND c.`nleft` >= 2 AND c.`nright` <= 53 ORDER BY `nleft` DESC	2.647 ms	6			/classes/Category.php:1600 /modules/ststickers/classes/StStickersMapClass.php:168 (getParentsCategories) /modules/ststickers/ststickers.php:1701 (getForProduct) /classes/Hook.php:1083 (hookActionStAssemble) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /override/classes/ProductAssembler.php:57 (exec) /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)
244	SELECT SQL_NO_CACHE 1 FROM `mmag_specific_price` WHERE id_product = 49 LIMIT 1	2.646 ms	4			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.645 ms	111132	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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.645 ms	111132	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)
139	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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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 ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.628 ms	111132	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)
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_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:06' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= 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) WHERE ((sp.reduction>0) OR (p.on_sale=1)) AND ((fp_1.id_feature_value IN (948, 820, 823))) AND ((fp_2.id_feature_value IN (791, 795))) 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_specific_price sp_1 ON ( sp_1.id_product = p.id_product AND sp_1.id_shop IN (0, 1) AND sp_1.id_currency IN (0, 1) AND sp_1.id_country IN (0, 36) AND sp_1.id_group IN (0, 1) AND sp_1.from_quantity = 1 AND sp_1.reduction > 0 AND sp_1.id_customer = 0 AND sp_1.id_cart = 0 AND (sp_1.from = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' >= sp_1.from) AND (sp_1.to = '0000-00-00 00:00:00' OR '2025-04-25 20:01:06' <= sp_1.to) ) 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=10)) AND ((sp_1.reduction>0) OR (p.on_sale=1)) AND ((fp_2.id_feature_value IN (948, 820, 823))) AND ((fp_3.id_feature_value IN (791, 795))) GROUP BY fp.id_feature_value	2.627 ms	111132	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)

#	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