Features Brands

Suspensii și Amortizoare

Suspensia este un sistem esențial în construcția motocicletelor, scuterelor și ATV-urilor, care are rolul de a absorbi șocurile și vibrațiile produse pe drumuri denivelate sau în timpul manevrelor intense. Acesta contribuie la confortul și controlul vehiculului, dar și la siguranța și performanța generală a acestuia.

Scopul și Funcțiile Suspensiei

Absorbirea șocurilor: Suspensia are rolul de a reduce impactul șocurilor produse atunci când vehiculul trece peste denivelări, gropi sau obstacole pe drum.
Îmbunătățirea controlului: Prin menținerea roților în contact constant cu solul, suspensia ajută la îmbunătățirea aderenței și a manevrabilității vehiculului.
Confortul motociclistului: Suspensia reduce vibrațiile resimțite de motociclist, sporind confortul în timpul călătoriei.
Stabilitatea vehiculului: Ajută la menținerea stabilității vehiculului în timpul frânărilor, accelerărilor și virajelor, reducând riscurile de pierdere a controlului.

Componentele Principale ale Suspensiei

Suspensia vehiculului este formată din mai multe componente care lucrează împreună pentru a absorbi șocurile și a menține stabilitatea. Printre acestea se numără:

1. Furca (la motociclete și scutere)

Descriere: Furca este partea din față a vehiculului care susține roata din față. Aceasta este echipată cu un sistem de suspensie (fie pe bază de arcuri, fie pe bază de ulei și gaze) care absoarbe șocurile.
Funcție: Furca permite mișcarea roții în sus și în jos, absorbind impactul și asigurând o direcție stabilă și controlată.
Tipuri: Furcile pot fi telescopice (cele mai comune) sau cu brațe oscilante.

2. Amortizoarele (Spate)

Descriere: Amortizoarele din spate sunt situate de obicei între cadrul vehiculului și roata din spate. Acestea pot fi echipate cu o suspensie pe bază de ulei, gaze sau cu arcuri.
Funcție: Amortizoarele absorb șocurile de la roata din spate și mențin vehiculul stabil în timpul deplasării, oferind un confort sporit în condiții dificile de drum.
Tipuri: Amortizoarele pot fi monoamortizoare (un singur amortizor pe spate) sau duale (două amortizoare pentru fiecare parte a roții din spate).

3. Arcuri

Descriere: Arcurile sunt componente care sunt utilizate pentru a sprijini greutatea vehiculului și a vehiculului în mișcare. Acestea se comprimă la impact și se extind când presiunea dispare.
Funcție: Arcurile ajută la absorbirea șocurilor, dar și la restabilirea poziției vehiculului după ce au fost comprimate.

4. Reglaje de suspensie

Descriere: Multe sisteme de suspensie permit reglarea durității și a înălțimii. Aceste reglaje se fac de obicei prin ajustarea arcurilor sau a amortizoarelor.
Funcție: Reglajele permit motociclistului să adapteze suspensia în funcție de condițiile de drum, de greutatea vehiculului sau de stilul de conducere (de exemplu, pe teren accidentat sau pe drum drept).

5. Brațele Oscilante

Descriere: Brațele oscilante sunt un element esențial în suspensia din spate, care se leagă de roata din spate și de cadru. Acestea permit mișcarea roții în sus și în jos, asigurând o suspensie lină.
Funcție: Brațele oscilante ajută la distribuirea șocurilor și asigură o stabilitate adecvată vehiculului în timpul mersului pe teren accidentat.

Tipuri de Suspensie

Suspensia poate fi de mai multe tipuri, în funcție de designul și scopul vehiculului:

1. Suspensie Telescopică (la motociclete și scutere)

Descriere: Este tipul cel mai frecvent întâlnit la motocicletele standard și scutere. Suspensia telescopică este un sistem de suspensie pe bază de furcă, echipat cu amortizoare.
Funcție: Oferă un control bun la drumuri drepte și denivelate. Furca telescopică absoarbe șocurile și menține stabilitatea direcțională.

2. Suspensie cu Braț Oscilant

Descriere: Suspensia cu braț oscilant este des utilizată pe motocicletele sportive și off-road. Aceasta este o suspensie dublă care utilizează amortizoare și arcuri montate pe un braț oscilant care leagă roata din spate de cadru.
Funcție: Oferă o performanță mai bună pe teren accidentat și o manevrabilitate excelentă în condiții de teren dificil.

3. Suspensie cu Arcuri și Amortizoare

Descriere: Acest sistem combină arcuri și amortizoare, folosit adesea pe vehicule mai mari (cum ar fi ATV-urile) pentru a absorbi șocurile intense și a asigura confortul și siguranța.
Funcție: Absorb impacturile mari și permit vehiculului să rămână stabil în terenuri accidentate.

4. Suspensie cu Amortizoare Reglabile

Descriere: Suspensia reglabilă permite ajustarea durității și a înălțimii pentru a se adapta la diferite condiții de drum și la greutatea vehiculului. Este adesea întâlnită pe motocicletele de performanță și off-road.
Funcție: Reglajele permit personalizarea suspensiei în funcție de preferințele motociclistului și de tipul de teren pe care se circulă.

5. Suspensie pe Aer sau Pe Gaz

Descriere: Unele vehicule utilizează suspensii pe bază de aer sau gaz (de exemplu, suspensii cu amortizoare pe gaz). Acestea utilizează presiunea aerului sau a gazului pentru a absorbi șocurile și a oferi o suspendare mai lină.
Funcție: Aceste sisteme sunt eficiente în a oferi un control mai fin și o performanță îmbunătățită în terenuri variate.

Importanța Întreținerii Suspensiei

Suspensia, fiind expusă la șocuri și forțe mari, necesită o întreținere periodică pentru a funcționa corespunzător. Iată câteva aspecte importante:

Verificarea nivelului de ulei sau gaze: Uleiul sau gazele din amortizoare pot scădea în timp, iar un nivel scăzut poate afecta performanța suspensiei. Verificarea acestora la intervale regulate este esențială.
Reglarea suspensiei: Este important să reglezi suspensia în funcție de condițiile de drum și de greutatea vehiculului. Dacă suspensia nu este reglată corect, vehiculul poate deveni instabil.
Verificarea arcurilor și amortizoarelor: Arcurile și amortizoarele se pot uza în timp. Verifică-le pentru eventuale semne de uzură sau fisuri.
Curățarea suspensiei: Suspensia trebuie curățată regulat, în special după utilizarea vehiculului pe terenuri murdare sau pline de praf, pentru a preveni uzura prematură.
Verificarea și înlocuirea pieselor deteriorate: Piesele deteriorate (cum ar fi brațele oscilante sau furcile) trebuie înlocuite imediat pentru a preveni accidentele și pentru a menține performanța vehiculului.

Sunt 68 produse.

Filtrează după:

Se afișează 1-12 din 68 produs(e)

Load Time	2175 ms
Querying Time	1531 ms
Queries	559
Memory Peak Usage	60.2 Mb
Included Files	1097 files - 13.63 Mb
PrestaShop Cache	- Mb
Global vars	0.08 Mb
- global $_MODULES	47k
- global $_SERVER	5k
- global $__composer_autoload_files	5k
- global $config	5k
- global $smarty	4k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_MODULE	2k

PrestaShop Version	9.0.1
PHP Version	8.4.20
MySQL Version	10.6.25-MariaDB-cll-lve
Memory Limit	512M
Max Execution Time	5000s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	242.336 ms	242.336 ms	25.23 Mb	25.6 Mb
__construct	0.042 ms	242.378 ms	- Mb	25.6 Mb
init	42.079 ms	284.457 ms	3.53 Mb	28.8 Mb
checkAccess	0.003 ms	284.460 ms	- Mb	28.8 Mb
setMedia	17.817 ms	302.277 ms	1.01 Mb	30.1 Mb
postProcess	0.003 ms	302.280 ms	- Mb	30.1 Mb
initHeader	0.005 ms	302.285 ms	- Mb	30.1 Mb
initContent	1677 ms	1979 ms	19.27 Mb	49.2 Mb
initFooter	0.002 ms	1979 ms	- Mb	49.2 Mb
display	196.183 ms	2175 ms	10.20 Mb	60.2 Mb

Hook	Time	Memory Usage
DisplayLeoProfileProduct	84.271 ms	3.72 Mb
=> appagebuilder	18.974 ms	0.78 Mb
=> appagebuilder	8.734 ms	0.41 Mb
=> appagebuilder	6.949 ms	0.43 Mb
=> appagebuilder	5.276 ms	0.20 Mb
=> appagebuilder	6.023 ms	0.20 Mb
=> appagebuilder	4.583 ms	0.20 Mb
=> appagebuilder	5.185 ms	0.20 Mb
=> appagebuilder	8.176 ms	0.34 Mb
=> appagebuilder	4.889 ms	0.20 Mb
=> appagebuilder	4.956 ms	0.23 Mb
=> appagebuilder	6.285 ms	0.34 Mb
=> appagebuilder	4.241 ms	0.20 Mb
DisplayHeader	80.597 ms	6.52 Mb
=> ets_superspeed	2.102 ms	0.06 Mb
=> ps_searchbar	0.469 ms	0.01 Mb
=> leopartsfilter	0.233 ms	- Mb
=> ps_imageslider	0.113 ms	- Mb
=> leoblog	0.136 ms	- Mb
=> leofeature	0.502 ms	0.01 Mb
=> leoquicklogin	0.271 ms	- Mb
=> ps_facebook	43.161 ms	3.98 Mb
=> leoslideshow	0.450 ms	- Mb
=> ps_googleanalytics	0.249 ms	0.01 Mb
=> psxmarketingwithgoogle	1.407 ms	0.15 Mb
=> leobootstrapmenu	0.966 ms	0.02 Mb
=> leoproductsearch	0.393 ms	- Mb
=> blockgrouptop	0.088 ms	- Mb
=> facebookpixelinstaller	0.513 ms	0.02 Mb
=> msiliunas_googletagmanager	0.321 ms	0.01 Mb
=> ps_shoppingcart	0.080 ms	- Mb
=> appagebuilder	29.143 ms	2.23 Mb
DisplayLeoCartButton	31.841 ms	1.62 Mb
=> leofeature	6.146 ms	0.21 Mb
=> leofeature	2.439 ms	0.16 Mb
=> leofeature	2.156 ms	0.12 Mb
=> leofeature	2.472 ms	0.12 Mb
=> leofeature	2.649 ms	0.12 Mb
=> leofeature	2.207 ms	0.12 Mb
=> leofeature	2.454 ms	0.12 Mb
=> leofeature	2.653 ms	0.12 Mb
=> leofeature	2.117 ms	0.12 Mb
=> leofeature	2.429 ms	0.15 Mb
=> leofeature	1.918 ms	0.12 Mb
=> leofeature	2.201 ms	0.12 Mb
ActionOutputHTMLBefore	19.704 ms	0.14 Mb
=> appagebuilder	0.129 ms	- Mb
=> ets_superspeed	19.575 ms	0.13 Mb
displayNav2	18.065 ms	1.53 Mb
=> appagebuilder (widget)	18.065 ms	1.53 Mb
DisplayBeforeBodyClosingTag	16.079 ms	0.77 Mb
=> statsdata	4.468 ms	0.26 Mb
=> ps_googleanalytics	8.606 ms	0.32 Mb
=> leofeature	0.041 ms	- Mb
=> leoquicklogin	2.964 ms	0.18 Mb
displayLeftColumn	9.326 ms	0.93 Mb
=> ps_categorytree (widget)	8.618 ms	0.89 Mb
=> appagebuilder (widget)	0.329 ms	0.01 Mb
=> ps_supplierlist (widget)	0.379 ms	0.03 Mb
displayNav1	9.105 ms	0.59 Mb
=> ps_customersignin (widget)	0.740 ms	0.04 Mb
=> ps_languageselector (widget)	0.007 ms	- Mb
=> ps_currencyselector (widget)	0.016 ms	- Mb
=> appagebuilder (widget)	7.767 ms	0.54 Mb
=> ps_shoppingcart (widget)	0.575 ms	0.01 Mb
DisplayLeoCompareButton	8.222 ms	0.03 Mb
=> leofeature	0.742 ms	0.01 Mb
=> leofeature	0.803 ms	- Mb
=> leofeature	0.457 ms	- Mb
=> leofeature	0.202 ms	- Mb
=> leofeature	0.293 ms	- Mb
=> leofeature	0.311 ms	- Mb
=> leofeature	0.333 ms	- Mb
=> leofeature	0.322 ms	- Mb
=> leofeature	0.415 ms	- Mb
=> leofeature	0.236 ms	- Mb
=> leofeature	0.286 ms	- Mb
=> leofeature	0.236 ms	- Mb
=> leofeature	0.345 ms	- Mb
=> leofeature	0.240 ms	- Mb
=> leofeature	0.539 ms	- Mb
=> leofeature	0.306 ms	- Mb
=> leofeature	0.300 ms	- Mb
=> leofeature	0.252 ms	- Mb
=> leofeature	0.307 ms	- Mb
=> leofeature	0.201 ms	- Mb
=> leofeature	0.360 ms	- Mb
=> leofeature	0.264 ms	- Mb
=> leofeature	0.277 ms	- Mb
=> leofeature	0.195 ms	- Mb
DisplayApSC	6.495 ms	0.20 Mb
=> appagebuilder	6.495 ms	0.20 Mb
ModuleRoutes	6.279 ms	- Mb
=> leoblog	5.328 ms	- Mb
=> appagebuilder	0.951 ms	0.02 Mb
DisplayLeoProductListReview	6.204 ms	0.22 Mb
=> leofeature	0.840 ms	0.01 Mb
=> leofeature	0.526 ms	0.01 Mb
=> leofeature	0.479 ms	0.08 Mb
=> leofeature	0.579 ms	0.01 Mb
=> leofeature	0.653 ms	0.01 Mb
=> leofeature	0.426 ms	0.01 Mb
=> leofeature	0.477 ms	0.01 Mb
=> leofeature	0.506 ms	0.01 Mb
=> leofeature	0.426 ms	0.01 Mb
=> leofeature	0.553 ms	0.01 Mb
=> leofeature	0.392 ms	0.01 Mb
=> leofeature	0.347 ms	0.01 Mb
displayTop	5.231 ms	0.16 Mb
=> ps_searchbar (widget)	0.353 ms	0.01 Mb
=> appagebuilder (widget)	4.878 ms	0.15 Mb
ProductSearchProvider	2.752 ms	0.16 Mb
=> ps_facetedsearch	2.752 ms	0.16 Mb
DisplayAfterBodyOpeningTag	1.952 ms	0.11 Mb
=> blockreassurance	1.439 ms	0.08 Mb
=> leoquicklogin	0.310 ms	0.01 Mb
=> msiliunas_googletagmanager	0.203 ms	0.01 Mb
ActionFrontControllerSetMedia	1.828 ms	0.07 Mb
=> blockreassurance	1.235 ms	0.07 Mb
=> ps_emailsubscription	0.224 ms	- Mb
=> ps_socialfollow	0.108 ms	- Mb
=> ps_facebook	0.168 ms	- Mb
=> ps_emailalerts	0.093 ms	- Mb
displayBanner	1.301 ms	0.05 Mb
=> appagebuilder (widget)	1.301 ms	0.05 Mb
DisplayLeftColumn	0.813 ms	0.12 Mb
=> ps_facetedsearch	0.352 ms	0.08 Mb
=> leoquicklogin	0.013 ms	- Mb
=> leoslideshow	0.448 ms	0.04 Mb
DisplayNav2	0.791 ms	0.06 Mb
=> leoquicklogin	0.018 ms	- Mb
=> leoslideshow	0.773 ms	0.06 Mb
DisplayFooterBefore	0.698 ms	0.06 Mb
=> leoquicklogin	0.014 ms	- Mb
=> leoslideshow	0.684 ms	0.06 Mb
DisplayFooterAfter	0.652 ms	0.06 Mb
=> blockreassurance	0.020 ms	- Mb
=> leoslideshow	0.620 ms	0.06 Mb
=> leoquicklogin	0.012 ms	- Mb
DisplayTop	0.612 ms	0.06 Mb
=> leoslideshow	0.597 ms	0.06 Mb
=> leoquicklogin	0.015 ms	- Mb
PagebuilderConfig	0.582 ms	0.05 Mb
=> appagebuilder	0.020 ms	- Mb
=> appagebuilder	0.005 ms	- Mb
=> appagebuilder	0.004 ms	- Mb
=> appagebuilder	0.003 ms	- Mb
=> appagebuilder	0.004 ms	- Mb
=> appagebuilder	0.300 ms	0.02 Mb
=> appagebuilder	0.246 ms	0.02 Mb
DisplayNavFullWidth	0.580 ms	0.06 Mb
=> blockreassurance	0.006 ms	- Mb
=> leoquicklogin	0.005 ms	- Mb
=> leoslideshow	0.569 ms	0.06 Mb
DisplayFooter	0.529 ms	0.06 Mb
=> leoquicklogin	0.012 ms	- Mb
=> leoslideshow	0.517 ms	0.06 Mb
FilterCategoryContent	0.450 ms	0.01 Mb
=> appagebuilder	0.450 ms	0.01 Mb
displayFooter	0.436 ms	0.01 Mb
=> appagebuilder (widget)	0.436 ms	0.01 Mb
displayFooterBefore	0.424 ms	0.03 Mb
=> appagebuilder (widget)	0.424 ms	0.03 Mb
displayFooterAfter	0.344 ms	0.01 Mb
=> appagebuilder (widget)	0.344 ms	0.01 Mb
displayNavFullWidth	0.320 ms	0.01 Mb
=> appagebuilder (widget)	0.320 ms	0.01 Mb
ActionBuildFrontEndObject	0.176 ms	- Mb
=> ets_superspeed	0.176 ms	- Mb
DisplayLeoWishlistButton	0.129 ms	0.01 Mb
=> leofeature	0.010 ms	- Mb
=> leofeature	0.012 ms	- Mb
=> leofeature	0.011 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.005 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.005 ms	- Mb
=> leofeature	0.006 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.003 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.005 ms	- Mb
=> leofeature	0.005 ms	- Mb
=> leofeature	0.010 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.005 ms	- Mb
=> leofeature	0.003 ms	- Mb
=> leofeature	0.006 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.004 ms	- Mb
=> leofeature	0.003 ms	- Mb
ActionDispatcherBefore	0.029 ms	- Mb
=> psassistant	0.029 ms	- Mb
ActionDispatcher	0.024 ms	- Mb
=> psassistant	0.024 ms	- Mb
ActionObjectAddAfter	0.019 ms	- Mb
=> ets_superspeed	0.008 ms	- Mb
=> ets_superspeed	0.006 ms	- Mb
=> ets_superspeed	0.005 ms	- Mb
LeftColumn	0.018 ms	- Mb
=> leoblog	0.018 ms	- Mb
FilterHtmlContent	0.015 ms	- Mb
=> appagebuilder	0.008 ms	- Mb
=> appagebuilder	0.007 ms	- Mb
DisplayNav1	0.012 ms	- Mb
=> leoquicklogin	0.012 ms	- Mb
ActionObjectUpdateAfter	0.010 ms	- Mb
=> ets_superspeed	0.010 ms	- Mb
39 hook(s)	316.916 ms	17.09 Mb

Module	Time	Memory Usage
leoblog	37.315 ms	2.90 Mb
__construct	31.809 ms	3.27 Mb
hookModuleRoutes	5.348 ms	- Mb
hookDisplayHeader	0.138 ms	- Mb
hookLeftColumn	0.020 ms	- Mb
appagebuilder	187.014 ms	11.08 Mb
__construct	30.998 ms	2.48 Mb
hookModuleRoutes	0.960 ms	0.02 Mb
hookFilterCategoryContent	0.459 ms	0.01 Mb
hookFilterHtmlContent	0.014 ms	- Mb
hookFilterHtmlContent	0.012 ms	- Mb
hookDisplayHeader	29.156 ms	2.23 Mb
displayBanner	1.304 ms	0.05 Mb
displayNav1	7.770 ms	0.54 Mb
displayNav2	18.071 ms	1.53 Mb
displayTop	4.881 ms	0.15 Mb
displayNavFullWidth	0.322 ms	0.01 Mb
hookPagebuilderConfig	0.022 ms	- Mb
hookPagebuilderConfig	0.006 ms	- Mb
hookPagebuilderConfig	0.004 ms	- Mb
hookPagebuilderConfig	0.003 ms	- Mb
hookPagebuilderConfig	0.004 ms	- Mb
hookDisplayApSC	6.500 ms	0.20 Mb
displayLeftColumn	0.331 ms	0.01 Mb
hookPagebuilderConfig	0.304 ms	0.02 Mb
hookPagebuilderConfig	0.248 ms	0.02 Mb
hookDisplayLeoProfileProduct	18.978 ms	0.78 Mb
hookDisplayLeoProfileProduct	8.736 ms	0.41 Mb
hookDisplayLeoProfileProduct	6.951 ms	0.43 Mb
hookDisplayLeoProfileProduct	5.278 ms	0.20 Mb
hookDisplayLeoProfileProduct	6.025 ms	0.20 Mb
hookDisplayLeoProfileProduct	4.585 ms	0.20 Mb
hookDisplayLeoProfileProduct	5.187 ms	0.20 Mb
hookDisplayLeoProfileProduct	8.178 ms	0.34 Mb
hookDisplayLeoProfileProduct	4.891 ms	0.20 Mb
hookDisplayLeoProfileProduct	4.958 ms	0.23 Mb
hookDisplayLeoProfileProduct	6.287 ms	0.34 Mb
hookDisplayLeoProfileProduct	4.243 ms	0.20 Mb
displayFooterBefore	0.428 ms	0.04 Mb
displayFooter	0.440 ms	0.02 Mb
displayFooterAfter	0.347 ms	0.01 Mb
hookActionOutputHTMLBefore	0.133 ms	- Mb
psassistant	3.415 ms	0.05 Mb
__construct	3.346 ms	0.04 Mb
hookActionDispatcherBefore	0.037 ms	- Mb
hookActionDispatcher	0.032 ms	- Mb
blockreassurance	5.525 ms	0.30 Mb
__construct	2.805 ms	0.15 Mb
hookActionFrontControllerSetMedia	1.245 ms	0.07 Mb
hookDisplayAfterBodyOpeningTag	1.444 ms	0.08 Mb
hookDisplayNavFullWidth	0.008 ms	- Mb
hookDisplayFooterAfter	0.023 ms	- Mb
ps_emailsubscription	3.601 ms	0.28 Mb
__construct	3.368 ms	0.28 Mb
hookActionFrontControllerSetMedia	0.233 ms	- Mb
ps_socialfollow	1.265 ms	0.06 Mb
__construct	1.150 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.115 ms	- Mb
ps_facebook	45.972 ms	4.16 Mb
__construct	2.625 ms	0.18 Mb
hookActionFrontControllerSetMedia	0.174 ms	- Mb
hookDisplayHeader	43.173 ms	3.98 Mb
ps_emailalerts	3.879 ms	0.25 Mb
__construct	3.779 ms	0.25 Mb
hookActionFrontControllerSetMedia	0.100 ms	- Mb
ets_superspeed	44.713 ms	2.04 Mb
__construct	22.789 ms	1.84 Mb
hookActionBuildFrontEndObject	0.185 ms	- Mb
hookDisplayHeader	2.112 ms	0.06 Mb
hookActionObjectAddAfter	0.012 ms	- Mb
hookActionObjectAddAfter	0.009 ms	- Mb
hookActionObjectAddAfter	0.007 ms	- Mb
hookActionObjectUpdateAfter	0.015 ms	- Mb
hookActionOutputHTMLBefore	19.584 ms	0.13 Mb
ps_searchbar	1.295 ms	0.04 Mb
__construct	0.465 ms	0.03 Mb
hookDisplayHeader	0.474 ms	0.01 Mb
displayTop	0.356 ms	0.01 Mb
leopartsfilter	4.053 ms	0.40 Mb
__construct	3.814 ms	0.39 Mb
hookDisplayHeader	0.239 ms	- Mb
ps_imageslider	2.439 ms	0.21 Mb
__construct	2.321 ms	0.21 Mb
hookDisplayHeader	0.118 ms	- Mb
leofeature	53.751 ms	2.61 Mb
__construct	6.571 ms	0.69 Mb
hookDisplayHeader	0.509 ms	0.01 Mb
hookDisplayLeoWishlistButton	0.016 ms	- Mb
hookDisplayLeoCompareButton	0.750 ms	0.01 Mb
hookDisplayLeoProductListReview	0.845 ms	0.01 Mb
hookDisplayLeoCartButton	6.160 ms	0.21 Mb
hookDisplayLeoCompareButton	0.810 ms	- Mb
hookDisplayLeoWishlistButton	0.018 ms	- Mb
hookDisplayLeoWishlistButton	0.017 ms	- Mb
hookDisplayLeoCompareButton	0.460 ms	- Mb
hookDisplayLeoProductListReview	0.529 ms	0.01 Mb
hookDisplayLeoCartButton	2.442 ms	0.16 Mb
hookDisplayLeoCompareButton	0.205 ms	- Mb
hookDisplayLeoWishlistButton	0.005 ms	- Mb
hookDisplayLeoWishlistButton	0.007 ms	- Mb
hookDisplayLeoCompareButton	0.296 ms	- Mb
hookDisplayLeoProductListReview	0.482 ms	0.08 Mb
hookDisplayLeoCartButton	2.159 ms	0.12 Mb
hookDisplayLeoCompareButton	0.313 ms	- Mb
hookDisplayLeoWishlistButton	0.006 ms	- Mb
hookDisplayLeoWishlistButton	0.006 ms	- Mb
hookDisplayLeoCompareButton	0.336 ms	- Mb
hookDisplayLeoProductListReview	0.583 ms	0.01 Mb
hookDisplayLeoCartButton	2.477 ms	0.12 Mb
hookDisplayLeoCompareButton	0.325 ms	- Mb
hookDisplayLeoWishlistButton	0.007 ms	- Mb
hookDisplayLeoWishlistButton	0.010 ms	- Mb
hookDisplayLeoCompareButton	0.419 ms	- Mb
hookDisplayLeoProductListReview	0.657 ms	0.01 Mb
hookDisplayLeoCartButton	2.654 ms	0.12 Mb
hookDisplayLeoCompareButton	0.239 ms	- Mb
hookDisplayLeoWishlistButton	0.005 ms	- Mb
hookDisplayLeoWishlistButton	0.005 ms	- Mb
hookDisplayLeoCompareButton	0.289 ms	- Mb
hookDisplayLeoProductListReview	0.429 ms	0.01 Mb
hookDisplayLeoCartButton	2.211 ms	0.12 Mb
hookDisplayLeoCompareButton	0.238 ms	- Mb
hookDisplayLeoWishlistButton	0.005 ms	- Mb
hookDisplayLeoWishlistButton	0.007 ms	- Mb
hookDisplayLeoCompareButton	0.348 ms	- Mb
hookDisplayLeoProductListReview	0.479 ms	0.01 Mb
hookDisplayLeoCartButton	2.459 ms	0.12 Mb
hookDisplayLeoCompareButton	0.243 ms	- Mb
hookDisplayLeoWishlistButton	0.006 ms	- Mb
hookDisplayLeoWishlistButton	0.017 ms	- Mb
hookDisplayLeoCompareButton	0.543 ms	- Mb
hookDisplayLeoProductListReview	0.509 ms	0.01 Mb
hookDisplayLeoCartButton	2.656 ms	0.12 Mb
hookDisplayLeoCompareButton	0.310 ms	- Mb
hookDisplayLeoWishlistButton	0.006 ms	- Mb
hookDisplayLeoWishlistButton	0.007 ms	- Mb
hookDisplayLeoCompareButton	0.303 ms	- Mb
hookDisplayLeoProductListReview	0.429 ms	0.01 Mb
hookDisplayLeoCartButton	2.120 ms	0.12 Mb
hookDisplayLeoCompareButton	0.254 ms	- Mb
hookDisplayLeoWishlistButton	0.005 ms	- Mb
hookDisplayLeoWishlistButton	0.007 ms	- Mb
hookDisplayLeoCompareButton	0.310 ms	- Mb
hookDisplayLeoProductListReview	0.557 ms	0.01 Mb
hookDisplayLeoCartButton	2.433 ms	0.16 Mb
hookDisplayLeoCompareButton	0.203 ms	- Mb
hookDisplayLeoWishlistButton	0.004 ms	- Mb
hookDisplayLeoWishlistButton	0.009 ms	- Mb
hookDisplayLeoCompareButton	0.363 ms	- Mb
hookDisplayLeoProductListReview	0.395 ms	0.01 Mb
hookDisplayLeoCartButton	1.921 ms	0.12 Mb
hookDisplayLeoCompareButton	0.266 ms	- Mb
hookDisplayLeoWishlistButton	0.005 ms	- Mb
hookDisplayLeoWishlistButton	0.006 ms	- Mb
hookDisplayLeoCompareButton	0.279 ms	- Mb
hookDisplayLeoProductListReview	0.350 ms	0.01 Mb
hookDisplayLeoCartButton	2.203 ms	0.12 Mb
hookDisplayLeoCompareButton	0.197 ms	- Mb
hookDisplayLeoWishlistButton	0.004 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.042 ms	- Mb
leoquicklogin	7.200 ms	0.49 Mb
__construct	3.529 ms	0.28 Mb
hookDisplayHeader	0.278 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.312 ms	0.01 Mb
hookDisplayNav1	0.014 ms	- Mb
hookDisplayNav2	0.019 ms	- Mb
hookDisplayTop	0.016 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
hookDisplayLeftColumn	0.014 ms	- Mb
hookDisplayFooterBefore	0.015 ms	- Mb
hookDisplayFooter	0.014 ms	- Mb
hookDisplayFooterAfter	0.013 ms	- Mb
hookDisplayBeforeBodyClosingTag	2.970 ms	0.18 Mb
ps_accounts	2.055 ms	0.10 Mb
__construct	2.055 ms	0.10 Mb
leoslideshow	11.818 ms	1.10 Mb
__construct	7.130 ms	0.69 Mb
hookDisplayHeader	0.459 ms	0.01 Mb
hookDisplayNav2	0.776 ms	0.06 Mb
hookDisplayTop	0.601 ms	0.06 Mb
hookDisplayNavFullWidth	0.571 ms	0.06 Mb
hookDisplayLeftColumn	0.450 ms	0.04 Mb
hookDisplayFooterBefore	0.688 ms	0.06 Mb
hookDisplayFooter	0.520 ms	0.06 Mb
hookDisplayFooterAfter	0.623 ms	0.06 Mb
ps_googleanalytics	9.392 ms	0.38 Mb
__construct	0.525 ms	0.05 Mb
hookDisplayHeader	0.253 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	8.614 ms	0.32 Mb
psxmarketingwithgoogle	1.992 ms	0.20 Mb
__construct	0.580 ms	0.05 Mb
hookDisplayHeader	1.412 ms	0.15 Mb
leobootstrapmenu	10.826 ms	0.93 Mb
__construct	9.852 ms	0.91 Mb
hookDisplayHeader	0.974 ms	0.02 Mb
leoproductsearch	2.084 ms	0.13 Mb
__construct	1.686 ms	0.13 Mb
hookDisplayHeader	0.398 ms	0.01 Mb
blockgrouptop	0.992 ms	0.06 Mb
__construct	0.901 ms	0.06 Mb
hookDisplayHeader	0.091 ms	- Mb
facebookpixelinstaller	1.253 ms	0.08 Mb
__construct	0.736 ms	0.06 Mb
hookDisplayHeader	0.517 ms	0.02 Mb
msiliunas_googletagmanager	1.016 ms	0.05 Mb
__construct	0.486 ms	0.03 Mb
hookDisplayHeader	0.325 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.205 ms	0.01 Mb
ps_shoppingcart	1.170 ms	0.06 Mb
__construct	0.506 ms	0.04 Mb
hookDisplayHeader	0.083 ms	- Mb
displayNav1	0.581 ms	0.01 Mb
ps_facetedsearch	10.245 ms	0.69 Mb
__construct	7.128 ms	0.45 Mb
hookProductSearchProvider	2.762 ms	0.16 Mb
hookDisplayLeftColumn	0.355 ms	0.09 Mb
ps_customersignin	1.062 ms	0.08 Mb
__construct	0.318 ms	0.04 Mb
displayNav1	0.744 ms	0.04 Mb
ps_languageselector	0.265 ms	0.02 Mb
__construct	0.256 ms	0.02 Mb
displayNav1	0.009 ms	- Mb
ps_currencyselector	0.360 ms	0.09 Mb
__construct	0.342 ms	0.09 Mb
displayNav1	0.018 ms	- Mb
ps_categorytree	9.201 ms	0.95 Mb
__construct	0.577 ms	0.06 Mb
displayLeftColumn	8.624 ms	0.89 Mb
ps_supplierlist	0.936 ms	0.08 Mb
__construct	0.554 ms	0.04 Mb
displayLeftColumn	0.382 ms	0.03 Mb
statsdata	5.056 ms	0.31 Mb
__construct	0.586 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	4.470 ms	0.27 Mb
31 module(s)	471.159 ms	30.19 Mb

43 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzoXXb_product p LEFT JOIN wzoXXb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzoXXb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzoXXb_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 wzoXXb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzoXXb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzoXXb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN wzoXXb_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN wzoXXb_category_group cg ON (cg.id_category = c.id_category) WHERE 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 wzoXXb_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
35 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 `wzoXXb_attribute_group` ag INNER JOIN `wzoXXb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `wzoXXb_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `wzoXXb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN wzoXXb_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 wzoXXb_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `wzoXXb_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
35 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, cp.position FROM wzoXXb_product p LEFT JOIN wzoXXb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzoXXb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzoXXb_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 wzoXXb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzoXXb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzoXXb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN wzoXXb_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN wzoXXb_category_group cg ON (cg.id_category = c.id_category) WHERE 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 wzoXXb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzoXXb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzoXXb_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
29 queries	SELECT SUM(quantity) FROM `wzoXXb_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
22 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 `wzoXXb_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 `wzoXXb_cart_product` cp JOIN `wzoXXb_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `wzoXXb_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
13 queries	SELECT XX FROM `wzoXXb_specific_price` WHERE id_product = XX LIMIT XX
12 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 `wzoXXb_product` p INNER JOIN `wzoXXb_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `wzoXXb_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)
12 queries	SELECT `reduction` FROM `wzoXXb_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
12 queries	SELECT * FROM `wzoXXb_product` a LEFT JOIN `wzoXXb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `wzoXXb_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
12 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `wzoXXb_image` i INNER JOIN wzoXXb_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `wzoXXb_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `wzoXXb_product_attribute` pa INNER JOIN wzoXXb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `wzoXXb_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `wzoXXb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `wzoXXb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `wzoXXb_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
12 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM wzoXXb_feature_product pf LEFT JOIN wzoXXb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN wzoXXb_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN wzoXXb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN wzoXXb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN wzoXXb_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, fvl.value ASC
12 queries	SELECT name FROM wzoXXb_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
11 queries	SELECT `id_module` FROM `wzoXXb_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries	SELECT pa.`available_date` FROM `wzoXXb_product` p LEFT JOIN `wzoXXb_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN wzoXXb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN wzoXXb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
10 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `wzoXXb_attribute` a LEFT JOIN `wzoXXb_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `wzoXXb_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `wzoXXb_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN wzoXXb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `wzoXXb_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `wzoXXb_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
10 queries	SELECT * FROM `wzoXXb_product_attribute` a LEFT JOIN `wzoXXb_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
10 queries	SELECT * FROM `wzoXXb_product_attribute_lang` WHERE `id_product_attribute` = XX
10 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `wzoXXb_product_attribute_image` pai LEFT JOIN `wzoXXb_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `wzoXXb_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
10 queries	SELECT product_attribute_shop.`price` FROM `wzoXXb_product_attribute` pa INNER JOIN wzoXXb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
10 queries	SELECT al.`name` AS attribute_name FROM `wzoXXb_product_attribute_combination` pac LEFT JOIN `wzoXXb_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `wzoXXb_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `wzoXXb_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
8 queries	SELECT cl.`link_rewrite` FROM `wzoXXb_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
5 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 `wzoXXb_feature_value` v LEFT JOIN `wzoXXb_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `wzoXXb_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
5 queries	SELECT * FROM `wzoXXb_product` a LEFT JOIN `wzoXXb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
5 queries	SELECT * FROM `wzoXXb_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
5 queries	SELECT pa., product_attribute_shop. FROM `wzoXXb_product_attribute` pa INNER JOIN wzoXXb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
4 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `wzoXXb_module` m LEFT JOIN `wzoXXb_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
4 queries	SELECT `id_lang` FROM `wzoXXb_lang` WHERE `locale` = 'ro-ro' OR `language_code` = 'ro-ro' LIMIT XX
4 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `wzoXXb_product_attribute_combination` pac LEFT JOIN `wzoXXb_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `wzoXXb_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `wzoXXb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `wzoXXb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
4 queries	SELECT `name` FROM `wzoXXb_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 queries	SELECT tr.* FROM `wzoXXb_tax_rule` tr JOIN `wzoXXb_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
2 queries	SELECT 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 `wzoXXb_configuration` c LEFT JOIN `wzoXXb_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2 queries	SELECT value FROM `wzoXXb_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
2 queries	SELECT * FROM `wzoXXb_currency` a LEFT JOIN `wzoXXb_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `wzoXXb_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `wzoXXb_category` a LEFT JOIN `wzoXXb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `wzoXXb_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
2 queries	SELECT `id_category` FROM `wzoXXb_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT page from `wzoXXb_appagebuilder_page` where id_category = 'XX' AND id_shop = 'XX' LIMIT XX
2 queries	INSERT IGNORE INTO `wzoXXb_ets_superspeed_cache_page_hook` set id_cache_page="XX", hook_name="displayNavXX"

Name	Instances	Source
Product	52	/src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 3584] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 1584] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4950] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 5452] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 2249] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 5505] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4761] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 4152] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 564] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 2885] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 563] /src/Adapter/Image/ImageRetriever.php:68 (__construct) [id: 555] /classes/Link.php:114 (__construct) [id: 3584] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 3584] /classes/Link.php:114 (__construct) [id: 3584] /classes/Link.php:114 (__construct) [id: 3584] /classes/Link.php:114 (__construct) [id: 1584] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1584] /classes/Link.php:114 (__construct) [id: 1584] /classes/Link.php:114 (__construct) [id: 1584] /classes/Link.php:114 (__construct) [id: 4950] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 4950] /classes/Link.php:114 (__construct) [id: 4950] /classes/Link.php:114 (__construct) [id: 4950] /classes/Link.php:114 (__construct) [id: 5452] /classes/Link.php:114 (__construct) [id: 5452] /classes/Link.php:114 (__construct) [id: 5452] /classes/Link.php:114 (__construct) [id: 2249] /classes/Link.php:114 (__construct) [id: 2249] /classes/Link.php:114 (__construct) [id: 2249] /classes/Link.php:114 (__construct) [id: 5505] /classes/Link.php:114 (__construct) [id: 5505] /classes/Link.php:114 (__construct) [id: 5505] /classes/Link.php:114 (__construct) [id: 4761] /classes/Link.php:114 (__construct) [id: 4761] /classes/Link.php:114 (__construct) [id: 4152] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 4152] /classes/Link.php:114 (__construct) [id: 4152] /classes/Link.php:114 (__construct) [id: 4152] /classes/Link.php:114 (__construct) [id: 564] /classes/Link.php:114 (__construct) [id: 564] /classes/Link.php:114 (__construct) [id: 564] /classes/Link.php:114 (__construct) [id: 2885] /classes/Link.php:114 (__construct) [id: 2885] /classes/Link.php:114 (__construct) [id: 2885] /classes/Link.php:114 (__construct) [id: 563] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 563] /classes/Link.php:114 (__construct) [id: 563] /classes/Link.php:114 (__construct) [id: 563] /classes/Link.php:114 (__construct) [id: 555] /classes/Link.php:114 (__construct) [id: 555] /classes/Link.php:114 (__construct) [id: 555]
Combination	10	/classes/Product.php:5623 (__construct) [id: 14552] /classes/Product.php:5623 (__construct) [id: 14222] /classes/Product.php:5623 (__construct) [id: 14578] /classes/Product.php:5623 (__construct) [id: 14583] /classes/Product.php:5623 (__construct) [id: 14584] /classes/Product.php:5623 (__construct) [id: 10246] /classes/Product.php:5623 (__construct) [id: 14585] /classes/Product.php:5623 (__construct) [id: 10250] /classes/Product.php:5623 (__construct) [id: 14586] /classes/Product.php:5623 (__construct) [id: 14587]
Category	9	/controllers/front/listing/CategoryController.php:89 (__construct) [id: 5927] /classes/Meta.php:364 (__construct) [id: 5927] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 5927] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /src/Adapter/Presenter/Category/CategoryLazyArray.php:112 (__construct) [id: 5927]
ApPageBuilderModel	4	/modules/appagebuilder/appagebuilder.php:2085 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2601 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2601 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2601 (__construct) [id: ]
Country	4	/config/config.inc.php:154 (__construct) [id: 36] /classes/controller/FrontController.php:317 (__construct) [id: 36] /classes/AddressFormat.php:402 (__construct) [id: 36] /classes/controller/FrontController.php:1707 (__construct) [id: 36]
Address	4	/classes/shop/Shop.php:487 (__construct) [id: ] /classes/Product.php:3437 (initialize) [id: ] /classes/Product.php:3547 (__construct) [id: ] /classes/Product.php:5675 (__construct) [id: ]
LeoWidget	3	/modules/leobootstrapmenu/leobootstrapmenu.php:92 (__construct) [id: ] /modules/leobootstrapmenu/leobootstrapmenu.php:92 (__construct) [id: ] /modules/leobootstrapmenu/leobootstrapmenu.php:92 (__construct) [id: ]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:685 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:430 (__construct) [id: ] /modules/ets_superspeed/ets_superspeed.php:382 (__construct) [id: ]
Group	2	/classes/Cart.php:272 (getCurrent) [id: 1] /modules/leoproductsearch/leoproductsearch.php:467 (__construct) [id: 1]
Configuration	2	/modules/ps_accounts/src/Adapter/Configuration.php:224 (__construct) [id: 899] /modules/appagebuilder/appagebuilder.php:2288 (__construct) [id: ]
ApPageBuilderProfilesModel	2	/modules/appagebuilder/appagebuilder.php:3377 (__construct) [id: ] /modules/appagebuilder/appagebuilder.php:2895 (__construct) [id: ]
State	2	/classes/AddressFormat.php:402 (__construct) [id: 358] /classes/controller/FrontController.php:1706 (__construct) [id: 358]
Language	2	/config/config.inc.php:219 (__construct) [id: 2] /classes/Tools.php:550 (__construct) [id: 2]
Tax	2	/classes/tax/TaxRulesTaxManager.php:113 (__construct) [id: 36] /classes/tax/TaxRulesTaxManager.php:113 (__construct) [id: 36]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
Shop	1	/config/config.inc.php:122 (initialize) [id: 1]
LeopartsfilterMake	1	/modules/leopartsfilter/leopartsfilter.php:58 (__construct) [id: ]
LeopartsfilterLevellast	1	/modules/leopartsfilter/leopartsfilter.php:62 (__construct) [id: ]
LeopartsfilterDevice	1	/modules/leopartsfilter/leopartsfilter.php:61 (__construct) [id: ]
LeopartsfilterYear	1	/modules/leopartsfilter/leopartsfilter.php:60 (__construct) [id: ]
LeopartsfilterModel	1	/modules/leopartsfilter/leopartsfilter.php:59 (__construct) [id: ]
AddressFormat	1	/classes/controller/FrontController.php:1701 (generateAddress) [id: ]
Risk	1	/classes/controller/FrontController.php:1627 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1624 (__construct) [id: 0]
Customer	1	/config/config.inc.php:272 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:562 (__construct) [id: 1]
Ets_superspeed_cache_page	1	/modules/ets_superspeed/classes/cache.php:275 (__construct) [id: 1219]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
159	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute	449.162 ms	880	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
142	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=56)) GROUP BY pac.id_attribute	139.703 ms	128	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
94	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute	96.435 ms	848	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
146	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=58)) GROUP BY pac.id_attribute	62.098 ms	128	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
98	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=14)) GROUP BY pac.id_attribute	54.637 ms	912	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
144	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=57)) GROUP BY pac.id_attribute	48.377 ms	304	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
198	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=52)) GROUP BY fp.id_feature_value	45.010 ms	692	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
100	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=15)) GROUP BY pac.id_attribute	39.972 ms	704	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
199	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=53)) GROUP BY fp.id_feature_value	31.548 ms	456	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
200	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=54)) GROUP BY fp.id_feature_value	29.420 ms	530	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
197	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=51)) GROUP BY fp.id_feature_value	25.435 ms	420	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
203	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=56)) GROUP BY fp.id_feature_value	19.741 ms	248	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
96	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=11)) GROUP BY pac.id_attribute	17.950 ms	464	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
204	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=57)) GROUP BY fp.id_feature_value	16.017 ms	232	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
210	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=64)) GROUP BY fp.id_feature_value	13.880 ms	214	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
205	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=58)) GROUP BY fp.id_feature_value	13.463 ms	242	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
122	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=46)) GROUP BY pac.id_attribute	12.886 ms	576	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
196	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	11.012 ms	1088	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
136	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=53)) GROUP BY pac.id_attribute	9.676 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
138	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=54)) GROUP BY pac.id_attribute	8.978 ms	96	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
90	SELECT SQL_NO_CACHE p.id_product, sa.out_of_stock FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY IFNULL(p.quantity, 0) <= 0, IFNULL(p.quantity, 0) <= 0 AND FIELD(sa.out_of_stock, 0) ASC, p.position ASC, p.id_product DESC	8.788 ms	5308416	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:188 (getProductByFilters) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
110	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=37)) GROUP BY pac.id_attribute	8.396 ms	448	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
118	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=43)) GROUP BY pac.id_attribute	8.331 ms	96	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
134	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=52)) GROUP BY pac.id_attribute	8.249 ms	320	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
120	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=45)) GROUP BY pac.id_attribute	6.557 ms	608	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
112	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=38)) GROUP BY pac.id_attribute	6.211 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
126	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=48)) GROUP BY pac.id_attribute	5.263 ms	480	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
174	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=32)) GROUP BY fp.id_feature_value	5.012 ms	144	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
148	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=59)) GROUP BY pac.id_attribute	4.985 ms	288	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
211	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=65)) GROUP BY fp.id_feature_value	4.854 ms	64	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
163	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=17)) GROUP BY fp.id_feature_value	4.025 ms	52	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
411	SELECT SQL_NO_CACHE c., cl. FROM `wzo2b_category` c INNER JOIN wzo2b_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `wzo2b_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `wzo2b_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `wzo2b_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	3.985 ms	134	Yes	Yes	/classes/Category.php:815 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1248 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1174 (coreRenderWidget) /config/smarty.config.inc.php:213 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/at_edmartlayouts_layout_left_column_tpl/0c/2f/c7/0c2fc778ec302c18c3d041124d6072c03558345d_2.file.layout-both-columns.tpl.php:288 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/at_edmartlayouts_layout_left_column_tpl/0c/2f/c7/0c2fc778ec302c18c3d041124d6072c03558345d_2.file.layout-both-columns.tpl.php:112 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a02eb6b0dcc25_60632030) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/at_edmartlayouts_layout_left_column_tpl/92/0e/1c/920e1cd1f37ee6ff1de6e634df29e82e1dac33f2_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a02eb6b0c8186_54636810) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/at_edmartlayouts_layout_left_column_tpl/f3/42/33/f34233656c08deaacee62d509a19f15784a81b5f_2.file.product-list.tpl.php:37 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a02eb6b0c1557_32520392) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/prod/smarty/compile/at_edmartlayouts_layout_left_column_tpl/6e/5a/60/6e5a60297f24b0a9d08b6f18953252ef3f277514_2.file.category.tpl.php:34 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6a02eb6b0b7364_83070112) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
106	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=33)) GROUP BY pac.id_attribute	3.751 ms	224	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
166	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p INNER JOIN wzo2b_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=20)) GROUP BY fp.id_feature_value	3.717 ms	186	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (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:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
114	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=39)) GROUP BY pac.id_attribute	3.645 ms	192	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
140	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN wzo2b_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=55)) GROUP BY pac.id_attribute	3.519 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
194	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM wzo2b_product p LEFT JOIN wzo2b_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN wzo2b_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN wzo2b_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 wzo2b_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	3.384 ms	5308416	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
27	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 `wzo2b_configuration` c LEFT JOIN `wzo2b_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	3.209 ms	1012			/classes/Configuration.php:182 /classes/Configuration.php:230 (loadConfiguration) /classes/Dispatcher.php:667 (get) /classes/Dispatcher.php:235 (loadRoutes) /classes/Dispatcher.php:193 (__construct) /index.php:78 (getInstance)
92	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM wzo2b_product p INNER JOIN wzo2b_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 36) INNER JOIN wzo2b_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN wzo2b_category_product cp ON (p.id_product = cp.id_product) INNER JOIN wzo2b_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN wzo2b_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=120 AND c.nright<=131	3.064 ms	2304			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (dispatch)
87	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `wzo2b_feature` f INNER JOIN wzo2b_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `wzo2b_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 2) LEFT JOIN `wzo2b_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `wzo2b_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 2) ORDER BY f.`position` ASC	3.008 ms	1656	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:159 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:354 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:179 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:484 (run) /index.php:78 (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/autoload_static.php
9	/vendor/symfony/deprecation-contracts/function.php
10	/vendor/symfony/polyfill-mbstring/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap80.php
12	/vendor/symfony/polyfill-ctype/bootstrap.php
13	/vendor/symfony/polyfill-ctype/bootstrap80.php
14	/vendor/symfony/polyfill-php83/bootstrap.php
15	/vendor/symfony/var-dumper/Resources/functions/dump.php
16	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
18	/vendor/twig/twig/src/Resources/core.php
19	/vendor/twig/twig/src/Resources/debug.php
20	/vendor/twig/twig/src/Resources/escaper.php
21	/vendor/twig/twig/src/Resources/string_loader.php
22	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.php
24	/vendor/symfony/string/Resources/functions.php
25	/vendor/symfony/polyfill-intl-idn/bootstrap.php
26	/vendor/symfony/clock/Resources/now.php
27	/vendor/symfony/polyfill-php80/bootstrap.php
28	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
29	/vendor/jakeasmith/http_build_url/src/http_build_url.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/ircmaxell/password-compat/lib/password.php
32	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/translation/Resources/functions.php
35	/src/Core/Version.php
36	/config/alias.php
37	/vendor/prestashop/autoload/src/PrestashopAutoload.php
38	/vendor/prestashop/autoload/src/LegacyClassLoader.php
39	/vendor/symfony/filesystem/Filesystem.php