Load Time	1482 ms
Querying Time	314 ms
Queries	816
Memory Peak Usage	35.2 Mb
Included Files	1264 files - 11.89 Mb
PrestaShop Cache	- Mb
Global vars	0.19 Mb
- global $_MODULES	164k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $ignored_params	2k
- global $jprestaWebpConverterOptions	2k
- global $_MODULE	2k

PrestaShop Version	8.1.2
PHP Version	8.1.25
MySQL Version	10.6.16-MariaDB
Memory Limit	2048M
Max Execution Time	3600s
Smarty Cache	enabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	5.411 ms	5.411 ms	8.54 Mb	9.2 Mb
__construct	8.502 ms	13.913 ms	1.73 Mb	11.9 Mb
config	24.186 ms	38.099 ms	1.21 Mb	11.9 Mb
__construct	0.019 ms	38.118 ms	- Mb	11.9 Mb
init	31.062 ms	69.180 ms	2.13 Mb	14.8 Mb
checkAccess	0.002 ms	69.182 ms	- Mb	14.8 Mb
setMedia	2.709 ms	71.891 ms	0.26 Mb	14.8 Mb
postProcess	0.001 ms	71.892 ms	- Mb	14.8 Mb
initHeader	0.002 ms	71.894 ms	- Mb	14.8 Mb
initContent	919 ms	991 ms	9.38 Mb	24.2 Mb
initFooter	0.003 ms	991 ms	- Mb	24.2 Mb
display	491.561 ms	1482 ms	11.27 Mb	35.2 Mb

Hook	Time	Memory Usage
displayProductListReviews	58.738 ms	1.33 Mb
=> productcomments (widget)	21.328 ms	1.28 Mb
=> productcomments (widget)	1.547 ms	- Mb
=> productcomments (widget)	1.423 ms	- Mb
=> productcomments (widget)	1.618 ms	- Mb
=> productcomments (widget)	1.491 ms	- Mb
=> productcomments (widget)	1.536 ms	- Mb
=> productcomments (widget)	1.499 ms	- Mb
=> productcomments (widget)	1.622 ms	- Mb
=> productcomments (widget)	1.619 ms	- Mb
=> productcomments (widget)	1.574 ms	- Mb
=> productcomments (widget)	1.467 ms	- Mb
=> productcomments (widget)	1.622 ms	- Mb
=> productcomments (widget)	1.596 ms	- Mb
=> productcomments (widget)	1.612 ms	- Mb
=> productcomments (widget)	1.583 ms	- Mb
=> productcomments (widget)	1.864 ms	- Mb
=> productcomments (widget)	1.829 ms	- Mb
=> productcomments (widget)	1.647 ms	- Mb
=> productcomments (widget)	1.738 ms	- Mb
=> productcomments (widget)	1.516 ms	- Mb
=> productcomments (widget)	1.645 ms	- Mb
=> productcomments (widget)	1.748 ms	- Mb
=> productcomments (widget)	1.754 ms	- Mb
=> productcomments (widget)	1.860 ms	- Mb
ActionOutputHTMLBefore	52.942 ms	0.15 Mb
=> jprestaspeedpack	52.942 ms	0.15 Mb
ActionDispatcherBefore	35.360 ms	3.09 Mb
=> jprestaspeedpack	35.360 ms	3.09 Mb
displayLeftColumn	24.057 ms	0.74 Mb
=> ps_categorytree (widget)	24.057 ms	0.74 Mb
displayTop	15.832 ms	0.20 Mb
=> ps_searchbar (widget)	1.598 ms	0.05 Mb
=> ps_customersignin (widget)	3.498 ms	0.06 Mb
=> ps_shoppingcart (widget)	10.736 ms	0.09 Mb
DisplayBeforeBodyClosingTag	14.306 ms	0.27 Mb
=> statsdata	6.743 ms	0.25 Mb
=> ps_googleanalytics	7.563 ms	0.02 Mb
DisplayFooter	11.887 ms	0.11 Mb
=> zonethememanager	0.002 ms	- Mb
=> blockwishlist	11.885 ms	0.11 Mb
ActionDispatcher	8.726 ms	0.70 Mb
=> jprestaspeedpack	8.726 ms	0.70 Mb
displayFooterRight	3.892 ms	0.07 Mb
=> ps_emailsubscription (widget)	3.892 ms	0.07 Mb
DisplayHeader	3.022 ms	0.06 Mb
=> jprestaspeedpack	0.166 ms	- Mb
=> ps_shoppingcart	0.034 ms	- Mb
=> ps_searchbar	0.154 ms	- Mb
=> productcomments	0.083 ms	- Mb
=> ps_googleanalytics	0.116 ms	- Mb
=> zonecolorsfonts	1.069 ms	0.03 Mb
=> zonemegamenu	0.874 ms	0.01 Mb
=> zonethememanager	0.448 ms	0.01 Mb
=> prestastripe	0.009 ms	- Mb
=> prestaadvanceloyaltyprogram	0.069 ms	- Mb
DisplayLeftColumn	1.518 ms	0.02 Mb
=> ps_facetedsearch	1.190 ms	- Mb
=> zonecolumnblocks	0.328 ms	0.01 Mb
ActionFrontControllerSetVariables	1.480 ms	0.06 Mb
=> zonethememanager	1.480 ms	0.06 Mb
displayNav2	1.356 ms	0.08 Mb
=> ps_languageselector (widget)	0.897 ms	0.04 Mb
=> ps_currencyselector (widget)	0.459 ms	0.04 Mb
displayFooterLeft	0.987 ms	0.06 Mb
=> ps_socialfollow (widget)	0.987 ms	0.06 Mb
DisplayOutsideMainPage	0.935 ms	0.03 Mb
=> zonepopupnewsletter	0.328 ms	0.01 Mb
=> zonecolorsfonts	0.342 ms	0.01 Mb
=> zonethememanager	0.265 ms	0.01 Mb
ActionFrontControllerSetMedia	0.697 ms	0.01 Mb
=> blockreassurance	0.143 ms	- Mb
=> blockwishlist	0.211 ms	- Mb
=> ps_emailsubscription	0.047 ms	- Mb
=> ps_socialfollow	0.045 ms	- Mb
=> ps_emailalerts	0.080 ms	- Mb
=> prestaadvanceloyaltyprogram	0.171 ms	- Mb
DisplayFooterAfter	0.458 ms	0.01 Mb
=> zonethememanager	0.458 ms	0.01 Mb
DisplayFooterLeft	0.450 ms	0.01 Mb
=> zonethememanager	0.450 ms	0.01 Mb
DisplayBanner	0.389 ms	0.01 Mb
=> zonethememanager	0.389 ms	0.01 Mb
DisplayFooterRight	0.388 ms	0.01 Mb
=> zonethememanager	0.388 ms	0.01 Mb
DisplaySidebarNavigation	0.361 ms	- Mb
=> zonethememanager	0.361 ms	- Mb
ProductSearchProvider	0.358 ms	- Mb
=> ps_facetedsearch	0.358 ms	- Mb
DisplayNavFullWidth	0.314 ms	0.01 Mb
=> zonemegamenu	0.314 ms	0.01 Mb
DisplayNav1	0.244 ms	0.01 Mb
=> zonethememanager	0.244 ms	0.01 Mb
ActionObjectAddAfter	0.045 ms	- Mb
=> jprestaspeedpack	0.037 ms	- Mb
=> jprestaspeedpack	0.004 ms	- Mb
=> jprestaspeedpack	0.004 ms	- Mb
ModuleRoutes	0.023 ms	0.02 Mb
=> prestaadvanceloyaltyprogram	0.009 ms	0.01 Mb
=> prestaadvanceloyaltyprogram	0.014 ms	0.01 Mb
ActionFrontControllerInitAfter	0.019 ms	- Mb
=> prestaadvanceloyaltyprogram	0.019 ms	- Mb
DisplayAfterBodyOpeningTag	0.012 ms	- Mb
=> blockreassurance	0.012 ms	- Mb
DisplayFooterBefore	0.012 ms	- Mb
=> blockreassurance	0.012 ms	- Mb
29 hook(s)	238.807 ms	7.08 Mb

Module	Time	Memory Usage
prestaadvanceloyaltyprogram	5.052 ms	0.54 Mb
__construct	4.751 ms	0.51 Mb
hookModuleRoutes	0.013 ms	0.01 Mb
hookActionFrontControllerInitAfter	0.025 ms	- Mb
hookActionFrontControllerSetMedia	0.173 ms	- Mb
hookDisplayHeader	0.070 ms	- Mb
hookModuleRoutes	0.020 ms	0.01 Mb
jprestaspeedpack	98.193 ms	4.02 Mb
__construct	0.928 ms	0.06 Mb
hookActionDispatcherBefore	35.365 ms	3.09 Mb
hookActionDispatcher	8.729 ms	0.70 Mb
hookDisplayHeader	0.168 ms	- Mb
hookActionObjectAddAfter	0.041 ms	- Mb
hookActionObjectAddAfter	0.007 ms	- Mb
hookActionObjectAddAfter	0.006 ms	- Mb
hookActionOutputHTMLBefore	52.949 ms	0.15 Mb
blockreassurance	1.088 ms	0.09 Mb
__construct	0.908 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.147 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.017 ms	- Mb
hookDisplayFooterBefore	0.016 ms	- Mb
blockwishlist	12.213 ms	0.13 Mb
__construct	0.102 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.213 ms	- Mb
hookDisplayFooter	11.898 ms	0.11 Mb
ps_emailsubscription	4.109 ms	0.10 Mb
__construct	0.164 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.049 ms	- Mb
displayFooterRight	3.896 ms	0.07 Mb
ps_socialfollow	1.179 ms	0.07 Mb
__construct	0.143 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.046 ms	- Mb
displayFooterLeft	0.990 ms	0.06 Mb
ps_emailalerts	0.213 ms	0.09 Mb
__construct	0.131 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.082 ms	- Mb
zonethememanager	14.890 ms	1.30 Mb
__construct	10.381 ms	1.15 Mb
hookActionFrontControllerSetVariables	1.484 ms	0.06 Mb
hookDisplayHeader	0.451 ms	0.01 Mb
hookDisplaySidebarNavigation	0.364 ms	- Mb
hookDisplayBanner	0.392 ms	0.01 Mb
hookDisplayNav1	0.246 ms	0.01 Mb
hookDisplayFooterLeft	0.452 ms	0.01 Mb
hookDisplayFooterRight	0.390 ms	0.02 Mb
hookDisplayFooter	0.004 ms	- Mb
hookDisplayFooterAfter	0.460 ms	0.01 Mb
hookDisplayOutsideMainPage	0.267 ms	0.01 Mb
ps_shoppingcart	10.904 ms	0.11 Mb
__construct	0.131 ms	0.02 Mb
hookDisplayHeader	0.035 ms	- Mb
displayTop	10.738 ms	0.09 Mb
ps_searchbar	1.839 ms	0.14 Mb
__construct	0.082 ms	0.08 Mb
hookDisplayHeader	0.156 ms	- Mb
displayTop	1.601 ms	0.05 Mb
productcomments	59.008 ms	1.37 Mb
__construct	0.113 ms	0.03 Mb
hookDisplayHeader	0.085 ms	- Mb
displayProductListReviews	21.333 ms	1.28 Mb
displayProductListReviews	1.550 ms	- Mb
displayProductListReviews	1.425 ms	- Mb
displayProductListReviews	1.621 ms	- Mb
displayProductListReviews	1.494 ms	- Mb
displayProductListReviews	1.538 ms	- Mb
displayProductListReviews	1.502 ms	- Mb
displayProductListReviews	1.624 ms	- Mb
displayProductListReviews	1.622 ms	- Mb
displayProductListReviews	1.577 ms	- Mb
displayProductListReviews	1.470 ms	- Mb
displayProductListReviews	1.625 ms	- Mb
displayProductListReviews	1.599 ms	- Mb
displayProductListReviews	1.614 ms	- Mb
displayProductListReviews	1.586 ms	- Mb
displayProductListReviews	1.867 ms	- Mb
displayProductListReviews	1.832 ms	- Mb
displayProductListReviews	1.650 ms	- Mb
displayProductListReviews	1.741 ms	- Mb
displayProductListReviews	1.519 ms	- Mb
displayProductListReviews	1.648 ms	- Mb
displayProductListReviews	1.751 ms	- Mb
displayProductListReviews	1.758 ms	- Mb
displayProductListReviews	1.864 ms	- Mb
ps_googleanalytics	7.790 ms	0.05 Mb
__construct	0.106 ms	0.03 Mb
hookDisplayHeader	0.117 ms	- Mb
hookDisplayBeforeBodyClosingTag	7.567 ms	0.02 Mb
zonecolorsfonts	1.618 ms	0.06 Mb
__construct	0.203 ms	0.02 Mb
hookDisplayHeader	1.071 ms	0.03 Mb
hookDisplayOutsideMainPage	0.344 ms	0.01 Mb
zonemegamenu	1.404 ms	0.06 Mb
__construct	0.211 ms	0.03 Mb
hookDisplayHeader	0.876 ms	0.01 Mb
hookDisplayNavFullWidth	0.317 ms	0.01 Mb
prestastripe	2.914 ms	0.02 Mb
__construct	2.902 ms	0.02 Mb
hookDisplayHeader	0.012 ms	- Mb
ps_facetedsearch	2.016 ms	0.10 Mb
__construct	0.462 ms	0.10 Mb
hookProductSearchProvider	0.360 ms	- Mb
hookDisplayLeftColumn	1.194 ms	- Mb
ps_languageselector	1.025 ms	0.06 Mb
__construct	0.124 ms	0.02 Mb
displayNav2	0.901 ms	0.04 Mb
ps_currencyselector	0.624 ms	0.06 Mb
__construct	0.163 ms	0.02 Mb
displayNav2	0.461 ms	0.04 Mb
ps_customersignin	3.653 ms	0.08 Mb
__construct	0.153 ms	0.02 Mb
displayTop	3.500 ms	0.06 Mb
ps_categorytree	24.194 ms	0.75 Mb
__construct	0.133 ms	0.02 Mb
displayLeftColumn	24.061 ms	0.74 Mb
zonecolumnblocks	0.651 ms	0.11 Mb
__construct	0.321 ms	0.09 Mb
hookDisplayLeftColumn	0.330 ms	0.01 Mb
zonepopupnewsletter	0.579 ms	0.03 Mb
__construct	0.248 ms	0.02 Mb
hookDisplayOutsideMainPage	0.331 ms	0.01 Mb
statsdata	6.899 ms	0.27 Mb
__construct	0.154 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	6.745 ms	0.25 Mb
23 module(s)	262.057 ms	9.61 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
811	INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (434,803264849),(434,1693150473),(434,3517149926),(434,1289214159),(434,1785617407),(434,2936477779),(434,1727466530),(434,1432532875),(434,1025009294),(434,1804081323),(434,3479716883),(434,66301815),(434,537553573),(434,3045727500),(434,3231073010),(434,1825096520),(434,3225262556),(434,2645763144),(434,2027619899),(434,786864081),(434,1849360992),(434,294428854),(434,3774376179),(434,2880678980),(434,114155291),(434,2929321318),(434,2087307803),(434,2369020978),(434,1152186767),(434,4222788516),(434,2858566420),(434,848840972),(434,4147554351),(434,770698498),(434,2244011448),(434,477004582),(434,3610318732),(434,1070190107),(434,937307692),(434,25761885),(434,3366890060),(434,3483396593),(434,392306519),(434,909258745),(434,179865882),(434,3099645137),(434,3371246540),(434,2390640699),(434,501027234),(434,3032495894),(434,2100541971),(434,2793494280),(434,180908336),(434,1192985740),(434,1972034646),(434,2419117650),(434,3803768817),(434,4265874642),(434,67723771),(434,3423129237),(434,3399895114),(434,3221089548),(434,2990154896),(434,2728213885),(434,933991437),(434,2513627470),(434,468067826),(434,4137721533),(434,1552016987),(434,4080301755),(434,4245349388),(434,1973472416),(434,1839057912),(434,3745041382),(434,3035734567),(434,3719469943),(434,3466131047),(434,679558129),(434,462819688),(434,4267553191),(434,518809702),(434,3303811122),(434,2883778317),(434,1694893476),(434,3287268691),(434,3711637102),(434,698879415),(434,885817714),(434,125306139),(434,1634619674),(434,58280175),(434,3363778289),(434,1161663254),(434,201135304),(434,288600709),(434,1021330335),(434,2858809635),(434,2763627026),(434,3717400459),(434,4125370705),(434,3997906175),(434,4162316513),(434,3219397995),(434,2539165674),(434,1046234598),(434,787652129),(434,1595426297),(434,4184932827),(434,1985552396),(434,1944795689),(434,3799916950),(434,1827123668),(434,1447744642),(434,1636796806),(434,2645405926),(434,1474595477),(434,3375525138),(434,3902077767),(434,3507415422),(434,2781072282),(434,2002273313),(434,3164880625),(434,2490789905),(434,1000843653),(434,48947005),(434,3883347157),(434,3700474777),(434,4264269047),(434,2125390191),(434,4270481046),(434,343450730),(434,381351735),(434,2863449446),(434,3772294966),(434,3877457961),(434,1492116830),(434,4041511410),(434,828132466),(434,4090211224),(434,2185737194),(434,647687838),(434,733479784),(434,1440916471),(434,3262261204),(434,1872100372),(434,2092461357),(434,3357609169),(434,2365529006),(434,1263061406),(434,2296732656),(434,534196217),(434,482025419),(434,2811467352),(434,2488480532),(434,3501473861),(434,1917272649),(434,1878317490),(434,1789511633),(434,956713705),(434,89981727),(434,1143557322),(434,2749361789),(434,3857194488),(434,1024086260),(434,26040876),(434,1804243295),(434,2165251395),(434,1281618245),(434,2793993627),(434,426054238),(434,3398682121),(434,1025101115),(434,2974984653),(434,2214325187),(434,997821910),(434,2005463392),(434,3252396061),(434,942332382),(434,3816934055),(434,1661692647),(434,975758589),(434,3974931321),(434,2301364099),(434,855746680),(434,637832447),(434,3938675492),(434,508940865),(434,911480697),(434,1283363269),(434,3552869238),(434,2961923901),(434,3747234531),(434,3155646160),(434,3164668199),(434,2271068282),(434,84354396),(434,2915068863),(434,4064530110),(434,3216991891),(434,2045363644),(434,2664176477),(434,1076722390),(434,505410826),(434,3544422162),(434,2506779464),(434,2552384108),(434,876907216),(434,82980331),(434,3890150098),(434,3475437886),(434,2302280848),(434,1133144647),(434,801167173),(434,2059315716),(434,3139619822),(434,2937007520),(434,1589371182),(434,693370988),(434,2708427394),(434,1007456900),(434,610735313),(434,3846627131),(434,2031830639),(434,1908602231),(434,1401333655),(434,378101424),(434,996218346),(434,660881695),(434,2938384267),(434,4250264855),(434,1895305721),(434,502965417),(434,1982471117),(434,2524144246),(434,2774996218),(434,1068709096),(434,4077513867),(434,2900588200),(434,465472731),(434,4139839450),(434,2360011682),(434,4211248848),(434,283341417),(434,4165214622),(434,3508523596),(434,234404923),(434,2782693783),(434,3413880379),(434,3540168379),(434,861653603),(434,3160995915),(434,1391251310),(434,2106651858),(434,3572623339),(434,4629984),(434,2488722736),(434,3486510944),(434,2675016634),(434,2165907305),(434,136687257),(434,3540179561),(434,2792526429),(434,2220600372),(434,2914585448),(434,3882733113),(434,1688090355),(434,3534950496),(434,1182870252),(434,412601709),(434,574969182),(434,2970413814),(434,1487282505),(434,3228977345),(434,2023459642),(434,3291711134),(434,2792891444),(434,3335276918),(434,502111155),(434,1347492703),(434,2832080533),(434,1215320197),(434,2317239205),(434,1931846913),(434,1721014625),(434,738600257),(434,2998338424),(434,1207945902),(434,734241479),(434,3324570843),(434,4126771257),(434,1712456575),(434,3169253733),(434,1160958045),(434,1130949510),(434,3116084871),(434,269178051),(434,24773614),(434,3204450510),(434,3468662336),(434,1808444077),(434,4095410992),(434,1012520131),(434,2367920745),(434,2603361072),(434,2741539031),(434,607507456),(434,616165826),(434,2288576869),(434,4252798532),(434,2692385638),(434,4100315394),(434,3061254709),(434,1657292258),(434,2148967437),(434,1248236410),(434,2457219175),(434,1920985790),(434,1340703149),(434,1618471777),(434,4160689201),(434,1822364967),(434,479188821),(434,1661785323),(434,4137484009),(434,2636427258),(434,1499247737),(434,2061922205),(434,665830591),(434,916194615),(434,495595719),(434,3026469794),(434,1845449656),(434,4078122428),(434,2044505385),(434,3156749269),(434,3919036276),(434,204613135),(434,605377709),(434,766051911),(434,30400764),(434,4211022030),(434,715827285),(434,1092948871),(434,610201349),(434,1023110113),(434,3379323545),(434,2591028766),(434,1994095466),(434,33157726),(434,198243957),(434,94201498),(434,2540831776),(434,1707019604),(434,2730046909),(434,4101073252),(434,207761914),(434,2750534087),(434,980926717),(434,377071036),(434,2983490672),(434,584353846),(434,1743688562),(434,3223058413),(434,1665991311),(434,3093731065),(434,1095877807),(434,1085889875),(434,2059985562),(434,3618062925),(434,592374860),(434,4217863027),(434,3425247989),(434,1636391408),(434,1698766782),(434,2162739858),(434,1538367880),(434,3760626336),(434,1987713032),(434,2338874856),(434,4206689645),(434,1723372602),(434,2788329276),(434,2095305502),(434,3135330775),(434,2402748468),(434,24058172),(434,4000683245),(434,315670382),(434,2558276906),(434,1745365471),(434,2782569384),(434,3422117706),(434,552626444),(434,1506232339),(434,2933163456),(434,1483801350),(434,1400586123),(434,3746875726),(434,2604810181),(434,2905930158),(434,803588046),(434,1651400661),(434,1431243585),(434,1586185269),(434,4110009762),(434,3647374073),(434,4196158832),(434,644435096),(434,1862966990),(434,2098775956),(434,4045847707),(434,3122054119),(434,1971194991),(434,2149367276),(434,1888540635),(434,2660577125),(434,2508340497),(434,196341346),(434,1790101800),(434,1054130805),(434,2741947598),(434,1292400575),(434,545037028),(434,1516477184),(434,2706799993),(434,562470873),(434,2591346466),(434,613023703),(434,2725609989),(434,2082081559),(434,572560232),(434,2833489058),(434,1999611979),(434,1938789650),(434,2958717166),(434,1035708154),(434,2025067287),(434,3804047398),(434,248028803),(434,4243412966),(434,628124381),(434,1271215494),(434,2140466223),(434,1298495884),(434,3585931255),(434,532975694),(434,892763084),(434,203145038),(434,470924714),(434,1460516495),(434,2732318442),(434,3996868778),(434,862206445),(434,3193479021),(434,3382171736),(434,3362897893),(434,3598913121),(434,1342337107),(434,3202829344),(434,1335223071),(434,270790954),(434,1086966479),(434,484642328),(434,4274468042),(434,1740107684),(434,2117688527),(434,1393082718),(434,366510022),(434,341328174),(434,1469264429),(434,968691010),(434,3210232788),(434,809700252),(434,3705477223),(434,1639200307),(434,3585776886),(434,3305319229),(434,1052899681),(434,2176267881),(434,357387863),(434,451177334),(434,677589039),(434,1181390953),(434,898241702),(434,3480303789),(434,1736215096),(434,2511740146),(434,2560762429),(434,1570623991),(434,897080848),(434,891021207),(434,2807843172),(434,411231410),(434,2413680770),(434,519468981),(434,1898829954),(434,4274422817),(434,2781196321),(434,433695516),(434,1652336127),(434,4200438598),(434,3032893805),(434,1435170492),(434,341146430),(434,755973553),(434,2183774725),(434,3967614532),(434,1589097164),(434,2441764320),(434,745126750),(434,348450311),(434,2084175962),(434,3357611772),(434,1654631620),(434,3098454302),(434,2029227635),(434,1731761366),(434,2444253995),(434,2906032508),(434,872274856),(434,4282856364),(434,3328013593),(434,4184469063),(434,1074477927),(434,475878802),(434,1341972790),(434,2770374005),(434,4237489391),(434,2818813526),(434,3131100007),(434,4267621199),(434,1031922959),(434,1616292706),(434,630426110),(434,1846388513),(434,2239793094),(434,1660370824),(434,3321716633),(434,2551727033),(434,1836172154),(434,1870881122),(434,3324207484),(434,1065867023),(434,1459310880),(434,1395112921),(434,893552556),(434,1795813847),(434,2544364435),(434,4188602229),(434,1437064809),(434,922605498),(434,4180843510),(434,2554784265),(434,3798404205),(434,1216801552),(434,225525148),(434,274058040),(434,3206796234),(434,610255635),(434,3139895407),(434,3993594441),(434,2078652070),(434,3340749058),(434,2282248923),(434,3201099700),(434,3944887276),(434,887478137),(434,620965629),(434,53639561),(434,687854272),(434,4204526813),(434,3434636086),(434,3859247582),(434,2160451939),(434,419013317),(434,488655959),(434,2224381764),(434,857621694),(434,593880699),(434,1743569168),(434,747100668),(434,2627272664),(434,1477316791),(434,852002855),(434,3813191394),(434,3206482767),(434,2935275735),(434,825997452),(434,4128572079),(434,4149399208),(434,2432005645),(434,945310979),(434,206553734),(434,3381625344),(434,2613891474),(434,1285565060),(434,725086502),(434,2181279565),(434,2136294074),(434,531227063),(434,3291030245),(434,3423892574),(434,1818418110),(434,1175554195),(434,231365613),(434,3071984169),(434,1510809703),(434,2304894647),(434,724387218),(434,3702122266),(434,3105745802),(434,3598888791),(434,40599425),(434,4256434691),(434,1198380170),(434,3549401556),(434,2300237909),(434,484124464),(434,3042798728),(434,767973032),(434,4146324303),(434,1493350341),(434,2166736334),(434,3061340275),(434,1468811388),(434,714571165),(434,1958965990),(434,2146366302),(434,2212338847),(434,2088651590),(434,2684538463),(434,2292708505),(434,571001464),(434,608126571),(434,2736309071),(434,1479333754),(434,1794660366),(434,2319975337),(434,1093438481),(434,2975864804),(434,2504416172),(434,3531750290),(434,219666672),(434,4219072870),(434,1053258155),(434,2382983142),(434,1006288562),(434,1770263986),(434,3089735283),(434,3689334927),(434,2901629603),(434,2019277020),(434,2853333944),(434,1110695191),(434,3884283185),(434,4268093708),(434,159799075),(434,1715997742),(434,1009155269),(434,3922001006),(434,3916338789),(434,1085252167),(434,207705430),(434,1190601026),(434,1441004396),(434,1567147586),(434,964098054),(434,1385174189),(434,3607427007),(434,4065177061),(434,1552830538),(434,3778287701),(434,3986294473),(434,4127238085),(434,1865170325),(434,2161789419),(434,2889615117),(434,785261358),(434,3873733217),(434,2600209543),(434,3958092558),(434,4143434528),(434,3225228598),(434,3451063310),(434,810085901),(434,1502204888),(434,2931931582),(434,1339720903),(434,4093703382),(434,1016897830),(434,1186809094),(434,2269117600),(434,813555736),(434,733475850),(434,305814753),(434,2720553993),(434,212227262),(434,1328958432),(434,3903742053),(434,2617942920),(434,4254367326),(434,2895836413),(434,1090341105),(434,3174277595),(434,639084285),(434,4064195579),(434,2134315289),(434,608843276),(434,4190247440),(434,1090444753),(434,2554275840),(434,2758076506),(434,2518001916),(434,3620157415),(434,1195920681),(434,1822840633),(434,1087551238),(434,235508323),(434,1139244570),(434,810960133),(434,425550269),(434,1767940144),(434,1488780247),(434,1250541405),(434,1715845038),(434,3777612587),(434,2285237154),(434,802817926),(434,4280998710),(434,1108258121),(434,1107026853),(434,2913745362),(434,1129101120),(434,2454813183),(434,1690919006),(434,23973636),(434,293370743),(434,1041759778),(434,3142497267),(434,2920365983),(434,2300359472),(434,885232682),(434,1995817456),(434,3443377157),(434,863919144),(434,1324348692),(434,4019216150),(434,443752815),(434,4223293),(434,1182491637),(434,4257294915),(434,3629776934),(434,582958316),(434,3061655453),(434,1665355533),(434,1929899841),(434,1033949851),(434,2010879266),(434,1872304779),(434,1282102725),(434,3589651214),(434,4095654001),(434,2447713556),(434,2543494532),(434,2069898435),(434,3286503857),(434,2662939963),(434,93111834),(434,3160936308),(434,261262800),(434,141197408),(434,1904512268),(434,3001025754),(434,2247670246),(434,535154833),(434,3476002757),(434,3806439314),(434,1819793014),(434,3545273473),(434,3957652542),(434,3018295592),(434,1367893712),(434,1034338066),(434,3229510223),(434,4276953245),(434,3363858574),(434,2870596766),(434,648526699),(434,3627085975),(434,1585047995),(434,1960922033),(434,748737253),(434,1175066615),(434,1318322018),(434,260367662),(434,643741484),(434,1013706048),(434,1726352130),(434,2222354404),(434,1327031463),(434,1131865044),(434,839200087),(434,1407668396),(434,3548333318),(434,237845721),(434,3056051791),(434,747235328),(434,172675174),(434,2781705803),(434,2111348799),(434,3067187587),(434,618638032),(434,3369756381),(434,2232055662),(434,55113216),(434,3939915090),(434,2586983921),(434,3286008345),(434,1956055310),(434,740042513),(434,2282536358),(434,1863122946),(434,1296880981),(434,2589434346),(434,1621393368),(434,39250009),(434,72263924),(434,1587391050),(434,847186998),(434,2455499024),(434,859347884),(434,2244795234),(434,64890532),(434,601524522),(434,650041729),(434,2556244668),(434,231411009),(434,985524584),(434,1048511531),(434,995825448),(434,2083157957),(434,518992674),(434,4032854537),(434,448287589),(434,1589153583),(434,1001467745),(434,3154685901),(434,403257031),(434,3025581153),(434,1339596678),(434,1130528513),(434,1420673894),(434,1620800650),(434,1013410457),(434,812212380),(434,459581012),(434,2299158843),(434,3924888977),(434,1697117306),(434,3406763364),(434,1129505049) ON DUPLICATE KEY UPDATE id=id	17.662 ms	1			/modules/jprestaspeedpack/classes/JprestaUtils.php:710 /modules/jprestaspeedpack/classes/PageCacheDAO.php:948 (dbExecuteSQL) /modules/jprestaspeedpack/jprestaspeedpack.php:4049 (insert) /modules/jprestaspeedpack/jprestaspeedpack.php:1363 (cacheThis) /classes/Hook.php:1043 (hookActionOutputHTMLBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:721 (exec) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
624	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps21_category` c INNER JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps21_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 1669 AND c.id_category IN ( SELECT id_category FROM `ps21_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	8.068 ms	835	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:1054 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:309 (__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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:401 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40dbae8_02744823) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/a9/1a/c7a91aae82205c80d890787185478fd59f0c5c99_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40bd597_09551420) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40b7c91_69106534) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0a/7f/5f/0a7f5fc78275ce5f4fadd85f9ec8c9a21db308a6_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40a49a3_02619627) /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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	5.810 ms	1298			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:38 (require)
812	SELECT SQL_NO_CACHE * FROM `ps21_jm_pagecache` WHERE ((id_controller=1 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=2 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=3 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=4 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=5 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=6 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=7 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=8 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR id_controller=9 OR (id_controller=10 AND last_gen < (NOW() - INTERVAL 691200 SECOND)) OR (id_controller=11 AND last_gen < (NOW() - INTERVAL 691200 SECOND))) ORDER BY last_gen ASC LIMIT 2	3.325 ms	11	Yes		/modules/jprestaspeedpack/classes/PageCacheDAO.php:335 /modules/jprestaspeedpack/jprestaspeedpack.php:4052 (getCachedPages) /modules/jprestaspeedpack/jprestaspeedpack.php:1363 (cacheThis) /classes/Hook.php:1043 (hookActionOutputHTMLBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:721 (exec) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
165	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_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 ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_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>=55 AND c.nright<=56 GROUP BY p.id_product) p INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 24	3.273 ms	206087648	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
166	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_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 ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_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>=55 AND c.nright<=56 GROUP BY p.id_product) p	2.766 ms	206087648			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Products.php:94 (count) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
51	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps21_hook_alias` ha INNER JOIN `ps21_hook` h ON ha.name = h.name	2.343 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /modules/jprestaspeedpack/classes/JprestaUtilsTaxManager.php:109 (getManager) /modules/jprestaspeedpack/jprestaspeedpack.php:1578 (toJson) /modules/jprestaspeedpack/jprestaspeedpack.php:2599 (getTaxManagerDetails) /modules/jprestaspeedpack/jprestaspeedpack.php:2351 (getCacheKeyInfos) /modules/jprestaspeedpack/jprestaspeedpack.php:1401 (displayCacheIfExists) /classes/Hook.php:1043 (hookActionDispatcherBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/Dispatcher.php:351 (exec) /index.php:39 (dispatch)
15	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.175 ms	148	Yes	Yes	/classes/Hook.php:1233 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:39 (getInstance)
52	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.005 ms	386			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /modules/jprestaspeedpack/classes/JprestaUtilsTaxManager.php:109 (getManager) /modules/jprestaspeedpack/jprestaspeedpack.php:1578 (toJson) /modules/jprestaspeedpack/jprestaspeedpack.php:2599 (getTaxManagerDetails) /modules/jprestaspeedpack/jprestaspeedpack.php:2351 (getCacheKeyInfos) /modules/jprestaspeedpack/jprestaspeedpack.php:1401 (displayCacheIfExists) /classes/Hook.php:1043 (hookActionDispatcherBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/Dispatcher.php:351 (exec) /index.php:39 (dispatch)
168	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-12-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1225,4190,5809,9671,15838,15857,15861,30669,39322,95505,101727,172740,173984,188915,188916,188917,188918,188919,251404,310992,312182,313757,332196,332200)	1.748 ms	24			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
808	INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 3741340264, 'https://cadeaufou.com/263-chaussons-de-maison', 1, 2, 1, 263, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0;	1.475 ms	1			/modules/jprestaspeedpack/classes/JprestaUtils.php:710 /modules/jprestaspeedpack/classes/PageCacheDAO.php:894 (dbExecuteSQL) /modules/jprestaspeedpack/jprestaspeedpack.php:4049 (insert) /modules/jprestaspeedpack/jprestaspeedpack.php:1363 (cacheThis) /classes/Hook.php:1043 (hookActionOutputHTMLBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:721 (exec) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
799	INSERT INTO `ps21_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')	1.371 ms	1			/classes/ObjectModel.php:622 /classes/ObjectModel.php:576 (add) /classes/Guest.php:251 (save) /modules/statsdata/statsdata.php:82 (setNewGuest) /modules/statsdata/statsdata.php:73 (getScriptPlugins) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:534 (__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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40dbae8_02744823) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/a9/1a/c7a91aae82205c80d890787185478fd59f0c5c99_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40bd597_09551420) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40b7c91_69106534) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0a/7f/5f/0a7f5fc78275ce5f4fadd85f9ec8c9a21db308a6_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40a49a3_02619627) /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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
804	INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('915672', '', 'cadeaufou.com/263-chaussons-de-maison', '', '2023-12-01 09:52:36')	1.239 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:534 (__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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40dbae8_02744823) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/a9/1a/c7a91aae82205c80d890787185478fd59f0c5c99_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40bd597_09551420) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40b7c91_69106534) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0a/7f/5f/0a7f5fc78275ce5f4fadd85f9ec8c9a21db308a6_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40a49a3_02619627) /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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
813	DELETE FROM `ps21_jm_pagecache` WHERE id IN (100928)	1.118 ms	1			/modules/jprestaspeedpack/classes/JprestaUtils.php:710 /modules/jprestaspeedpack/classes/PageCacheDAO.php:353 (dbExecuteSQL) /modules/jprestaspeedpack/jprestaspeedpack.php:4052 (deleteCachedPages) /modules/jprestaspeedpack/jprestaspeedpack.php:1363 (cacheThis) /classes/Hook.php:1043 (hookActionOutputHTMLBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:721 (exec) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1)	1.078 ms	880			/classes/Hook.php:1332 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:39 (getInstance)
119	UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1;	1.060 ms	1			/modules/jprestaspeedpack/classes/JprestaUtils.php:710 /modules/jprestaspeedpack/classes/PageCacheDAO.php:442 (dbExecuteSQL) /modules/jprestaspeedpack/jprestaspeedpack.php:2400 (incrementCountBot) /modules/jprestaspeedpack/jprestaspeedpack.php:1401 (displayCacheIfExists) /classes/Hook.php:1043 (hookActionDispatcherBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/Dispatcher.php:351 (exec) /index.php:39 (dispatch)
803	INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('917963', '439', '751134203', '', '1', '1', '2023-12-01 09:52:36')	1.033 ms	1			/classes/ObjectModel.php:622 /classes/Connection.php:188 (add) /classes/Connection.php:97 (setNewConnection) /modules/statsdata/statsdata.php:118 (setPageConnection) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:534 (__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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:155 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40dbae8_02744823) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/a9/1a/c7a91aae82205c80d890787185478fd59f0c5c99_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40bd597_09551420) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40b7c91_69106534) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0a/7f/5f/0a7f5fc78275ce5f4fadd85f9ec8c9a21db308a6_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40a49a3_02619627) /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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
593	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 251404 ORDER BY `position`	1.011 ms	7	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
139	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps21_category` c INNER JOIN ps21_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps21_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 263 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.947 ms	1	Yes	Yes	/classes/Category.php:921 /controllers/front/listing/CategoryController.php:229 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
602	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 313757 ORDER BY `position`	0.881 ms	6	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
794	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (332200) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.836 ms	4	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:117 (offsetGet) /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/ZOneThemelayouts_layout_left_column_tpl/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:265 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed43498e4_27938246) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/d5/ea/f9/d5eaf97eefd45774f942385f18dfc63e3a4e67b0_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed432db23_75735363) /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) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/74/18/c0/7418c0215f4280c45140c8ac3c6227c5280401f1_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed4326084_12686259) /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) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:119 (_subTemplateRender) /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/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:216 (instanceBlock) /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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40dbae8_02744823) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/a9/1a/c7a91aae82205c80d890787185478fd59f0c5c99_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40bd597_09551420) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40b7c91_69106534) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0a/7f/5f/0a7f5fc78275ce5f4fadd85f9ec8c9a21db308a6_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40a49a3_02619627) /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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
786	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps21_product_attribute` pa INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps21_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps21_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps21_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (332196) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.821 ms	3	Yes	Yes	/classes/Product.php:4504 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:527 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:117 (offsetGet) /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/ZOneThemelayouts_layout_left_column_tpl/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:265 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed43498e4_27938246) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/d5/ea/f9/d5eaf97eefd45774f942385f18dfc63e3a4e67b0_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed432db23_75735363) /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) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/74/18/c0/7418c0215f4280c45140c8ac3c6227c5280401f1_2.file.products.tpl.php:31 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed4326084_12686259) /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) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:119 (_subTemplateRender) /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/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:216 (instanceBlock) /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:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:340 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:406 (instanceBlock) /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/ZOneThemelayouts_layout_left_column_tpl/7f/9a/0c/7f9a0cf1127f64505a2ae2190424db8e04f96bf8_2.file.layout-both-columns.tpl.php:106 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40dbae8_02744823) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/c7/a9/1a/c7a91aae82205c80d890787185478fd59f0c5c99_2.file.layout-left-column.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40bd597_09551420) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/ce/a7/1c/cea71c80189a70c6be5d76369aee39eab43f9448_2.file.product-list.tpl.php:48 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40b7c91_69106534) /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:116 (_subTemplateRender) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/0a/7f/5f/0a7f5fc78275ce5f4fadd85f9ec8c9a21db308a6_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65699ed40a49a3_02619627) /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:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
294	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 30669 AND pac.`id_product_attribute` = 6094 AND agl.`id_lang` = 1	0.808 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
0	SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps21_shop_url su LEFT JOIN ps21_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'cadeaufou.com' OR su.domain_ssl = 'cadeaufou.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	0.806 ms	1	Yes		/classes/shop/Shop.php:1364 /classes/shop/Shop.php:355 (findShopByHost) /config/config.inc.php:117 (initialize) /index.php:38 (require)
202	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 4190 AND pac.`id_product_attribute` = 1474 AND agl.`id_lang` = 1	0.784 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
572	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 172740 ORDER BY `position`	0.782 ms	9	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook`	0.777 ms	880			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:39 (getInstance)
807	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.774 ms	46	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /modules/jprestaspeedpack/classes/JprestaUtilsDispatcher.php:22 (__construct) /modules/jprestaspeedpack/classes/JprestaUtils.php:91 (getPageCacheInstance) /modules/jprestaspeedpack/classes/JprestaUtils.php:37 (parseLinks) /modules/jprestaspeedpack/jprestaspeedpack.php:4034 (parseLinks) /modules/jprestaspeedpack/jprestaspeedpack.php:1363 (cacheThis) /classes/Hook.php:1043 (hookActionOutputHTMLBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:721 (exec) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
575	SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 173984) AND (b.`id_shop` = 1) LIMIT 1	0.769 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
310	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 39322 ORDER BY f.position ASC	0.768 ms	1	Yes		/classes/Product.php:5993 /classes/Product.php:5794 (getFrontFeaturesStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
466	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 82094 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 310992 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 82094 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 310992 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.764 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5784 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
328	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 95505 AND pac.`id_product_attribute` = 15710 AND agl.`id_lang` = 1	0.761 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
464	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 310992 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 310992 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.754 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5773 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
306	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 39322 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 39322 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.748 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5773 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
386	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 188915 AND pac.`id_product_attribute` = 33747 AND agl.`id_lang` = 1	0.745 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
323	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 95505 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 95505 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.742 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5773 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
449	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps21_cart_product` cp WHERE cp.`id_product_attribute` = 52828 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 251404 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps21_cart_product` cp JOIN `ps21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps21_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 52828 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 251404 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.736 ms	0			/classes/Cart.php:1410 /classes/Product.php:4339 (getProductQuantity) /classes/Product.php:5784 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
452	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 251404 AND pac.`id_product_attribute` = 52828 AND agl.`id_lang` = 1	0.736 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
554	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 15857 ORDER BY `position`	0.733 ms	20	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
311	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 39322 AND pac.`id_product_attribute` = 7841 AND agl.`id_lang` = 1	0.731 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)

Chaussons de maison