Load Time	760.337 ms
Querying Time	218 ms
Queries	607
Memory Peak Usage	29.9 Mb
Included Files	1262 files - 11.88 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	disabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	5.716 ms	5.716 ms	8.53 Mb	9.2 Mb
__construct	8.295 ms	14.011 ms	1.73 Mb	11.9 Mb
config	31.148 ms	45.159 ms	1.21 Mb	11.9 Mb
__construct	0.019 ms	45.178 ms	- Mb	11.9 Mb
init	27.866 ms	73.044 ms	2.11 Mb	14.8 Mb
checkAccess	0.001 ms	73.045 ms	- Mb	14.8 Mb
setMedia	2.570 ms	75.615 ms	0.26 Mb	14.8 Mb
postProcess	0.001 ms	75.616 ms	- Mb	14.8 Mb
initHeader	0.001 ms	75.617 ms	- Mb	14.8 Mb
initContent	230.972 ms	306.589 ms	8.33 Mb	22.2 Mb
initFooter	0.002 ms	306.591 ms	- Mb	22.2 Mb
display	453.746 ms	760.337 ms	7.04 Mb	29.9 Mb

Hook	Time	Memory Usage
displayProductListReviews	70.629 ms	1.32 Mb
=> productcomments (widget)	18.271 ms	1.27 Mb
=> productcomments (widget)	2.447 ms	- Mb
=> productcomments (widget)	1.767 ms	- Mb
=> productcomments (widget)	1.689 ms	- Mb
=> productcomments (widget)	1.788 ms	- Mb
=> productcomments (widget)	1.231 ms	- Mb
=> productcomments (widget)	1.652 ms	- Mb
=> productcomments (widget)	1.721 ms	- Mb
=> productcomments (widget)	1.584 ms	- Mb
=> productcomments (widget)	1.573 ms	- Mb
=> productcomments (widget)	1.644 ms	- Mb
=> productcomments (widget)	1.736 ms	- Mb
=> productcomments (widget)	1.686 ms	- Mb
=> productcomments (widget)	1.654 ms	- Mb
=> productcomments (widget)	1.619 ms	- Mb
=> productcomments (widget)	15.208 ms	- Mb
=> productcomments (widget)	2.032 ms	- Mb
=> productcomments (widget)	1.431 ms	- Mb
=> productcomments (widget)	1.486 ms	- Mb
=> productcomments (widget)	1.647 ms	- Mb
=> productcomments (widget)	1.759 ms	- Mb
=> productcomments (widget)	1.777 ms	- Mb
=> productcomments (widget)	1.619 ms	- Mb
=> productcomments (widget)	1.609 ms	- Mb
ActionOutputHTMLBefore	44.030 ms	0.14 Mb
=> jprestaspeedpack	44.030 ms	0.14 Mb
ActionDispatcherBefore	42.103 ms	3.09 Mb
=> jprestaspeedpack	42.103 ms	3.09 Mb
DisplayHeader	40.065 ms	0.88 Mb
=> jprestaspeedpack	0.126 ms	- Mb
=> ps_shoppingcart	0.035 ms	- Mb
=> ps_searchbar	0.136 ms	- Mb
=> productcomments	0.080 ms	- Mb
=> ps_googleanalytics	0.039 ms	- Mb
=> zonecolorsfonts	37.343 ms	0.84 Mb
=> zonemegamenu	0.835 ms	0.01 Mb
=> zonethememanager	1.403 ms	0.01 Mb
=> prestastripe	0.010 ms	- Mb
=> prestaadvanceloyaltyprogram	0.058 ms	- Mb
displayLeftColumn	23.822 ms	0.74 Mb
=> ps_categorytree (widget)	23.822 ms	0.74 Mb
DisplayBeforeBodyClosingTag	20.294 ms	0.21 Mb
=> statsdata	6.958 ms	0.19 Mb
=> ps_googleanalytics	13.336 ms	0.02 Mb
displayTop	16.363 ms	0.20 Mb
=> ps_searchbar (widget)	1.524 ms	0.05 Mb
=> ps_customersignin (widget)	3.959 ms	0.06 Mb
=> ps_shoppingcart (widget)	10.880 ms	0.09 Mb
DisplayFooterRight	11.450 ms	0.24 Mb
=> zonethememanager	11.450 ms	0.24 Mb
DisplayFooter	11.316 ms	0.11 Mb
=> zonethememanager	0.002 ms	- Mb
=> blockwishlist	11.314 ms	0.11 Mb
ActionDispatcher	9.609 ms	0.70 Mb
=> jprestaspeedpack	9.609 ms	0.70 Mb
DisplayNavFullWidth	5.025 ms	0.07 Mb
=> zonemegamenu	5.025 ms	0.07 Mb
DisplayLeftColumn	4.889 ms	0.04 Mb
=> ps_facetedsearch	1.061 ms	- Mb
=> zonecolumnblocks	3.828 ms	0.04 Mb
DisplayOutsideMainPage	4.544 ms	0.06 Mb
=> zonepopupnewsletter	1.576 ms	0.03 Mb
=> zonecolorsfonts	1.035 ms	0.01 Mb
=> zonethememanager	1.933 ms	0.03 Mb
displayFooterRight	3.447 ms	0.07 Mb
=> ps_emailsubscription (widget)	3.447 ms	0.07 Mb
displayFooterLeft	2.325 ms	0.06 Mb
=> ps_socialfollow (widget)	2.325 ms	0.06 Mb
DisplayBanner	2.144 ms	0.06 Mb
=> zonethememanager	2.144 ms	0.06 Mb
DisplayFooterAfter	1.504 ms	0.03 Mb
=> zonethememanager	1.504 ms	0.03 Mb
DisplayFooterLeft	1.454 ms	0.03 Mb
=> zonethememanager	1.454 ms	0.03 Mb
DisplayNav1	1.407 ms	0.04 Mb
=> zonethememanager	1.407 ms	0.04 Mb
ActionFrontControllerSetVariables	1.249 ms	0.06 Mb
=> zonethememanager	1.249 ms	0.06 Mb
ActionFrontControllerSetMedia	0.808 ms	0.01 Mb
=> blockreassurance	0.170 ms	- Mb
=> blockwishlist	0.205 ms	- Mb
=> ps_emailsubscription	0.057 ms	- Mb
=> ps_socialfollow	0.101 ms	- Mb
=> ps_emailalerts	0.053 ms	- Mb
=> prestaadvanceloyaltyprogram	0.222 ms	- Mb
displayNav2	0.803 ms	0.08 Mb
=> ps_languageselector (widget)	0.445 ms	0.04 Mb
=> ps_currencyselector (widget)	0.358 ms	0.04 Mb
DisplaySidebarNavigation	0.723 ms	- Mb
=> zonethememanager	0.723 ms	- Mb
ProductSearchProvider	0.238 ms	- Mb
=> ps_facetedsearch	0.238 ms	- Mb
ActionObjectAddAfter	0.056 ms	- Mb
=> jprestaspeedpack	0.050 ms	- Mb
=> jprestaspeedpack	0.003 ms	- Mb
=> jprestaspeedpack	0.003 ms	- Mb
DisplayAfterBodyOpeningTag	0.030 ms	- Mb
=> blockreassurance	0.030 ms	- Mb
ModuleRoutes	0.023 ms	0.02 Mb
=> prestaadvanceloyaltyprogram	0.010 ms	0.01 Mb
=> prestaadvanceloyaltyprogram	0.013 ms	0.01 Mb
ActionFrontControllerInitAfter	0.011 ms	- Mb
=> prestaadvanceloyaltyprogram	0.011 ms	- Mb
DisplayFooterBefore	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
29 hook(s)	320.368 ms	8.27 Mb

Module	Time	Memory Usage
prestaadvanceloyaltyprogram	5.003 ms	0.54 Mb
__construct	4.672 ms	0.51 Mb
hookModuleRoutes	0.016 ms	0.01 Mb
hookActionFrontControllerInitAfter	0.015 ms	- Mb
hookActionFrontControllerSetMedia	0.224 ms	- Mb
hookDisplayHeader	0.060 ms	- Mb
hookModuleRoutes	0.016 ms	0.01 Mb
jprestaspeedpack	96.924 ms	3.99 Mb
__construct	0.974 ms	0.06 Mb
hookActionDispatcherBefore	42.108 ms	3.09 Mb
hookActionDispatcher	9.613 ms	0.70 Mb
hookDisplayHeader	0.128 ms	- Mb
hookActionObjectAddAfter	0.055 ms	- Mb
hookActionObjectAddAfter	0.006 ms	- Mb
hookActionObjectAddAfter	0.007 ms	- Mb
hookActionOutputHTMLBefore	44.033 ms	0.14 Mb
blockreassurance	1.059 ms	0.09 Mb
__construct	0.821 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.172 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.055 ms	- Mb
hookDisplayFooterBefore	0.011 ms	- Mb
blockwishlist	11.605 ms	0.13 Mb
__construct	0.081 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.207 ms	- Mb
hookDisplayFooter	11.317 ms	0.11 Mb
ps_emailsubscription	3.621 ms	0.10 Mb
__construct	0.112 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.059 ms	- Mb
displayFooterRight	3.450 ms	0.07 Mb
ps_socialfollow	2.502 ms	0.08 Mb
__construct	0.072 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.102 ms	- Mb
displayFooterLeft	2.328 ms	0.06 Mb
ps_emailalerts	0.182 ms	0.09 Mb
__construct	0.127 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.055 ms	- Mb
zonethememanager	32.507 ms	1.63 Mb
__construct	9.210 ms	1.12 Mb
hookActionFrontControllerSetVariables	1.252 ms	0.06 Mb
hookDisplayHeader	1.405 ms	0.01 Mb
hookDisplaySidebarNavigation	0.726 ms	- Mb
hookDisplayBanner	2.147 ms	0.06 Mb
hookDisplayNav1	1.410 ms	0.04 Mb
hookDisplayFooterLeft	1.458 ms	0.03 Mb
hookDisplayFooterRight	11.453 ms	0.24 Mb
hookDisplayFooter	0.004 ms	- Mb
hookDisplayFooterAfter	1.507 ms	0.03 Mb
hookDisplayOutsideMainPage	1.935 ms	0.03 Mb
ps_shoppingcart	11.032 ms	0.11 Mb
__construct	0.112 ms	0.02 Mb
hookDisplayHeader	0.037 ms	- Mb
displayTop	10.883 ms	0.09 Mb
ps_searchbar	1.768 ms	0.14 Mb
__construct	0.088 ms	0.08 Mb
hookDisplayHeader	0.153 ms	- Mb
displayTop	1.527 ms	0.05 Mb
productcomments	70.899 ms	1.36 Mb
__construct	0.121 ms	0.03 Mb
hookDisplayHeader	0.082 ms	- Mb
displayProductListReviews	18.276 ms	1.27 Mb
displayProductListReviews	2.451 ms	- Mb
displayProductListReviews	1.769 ms	- Mb
displayProductListReviews	1.691 ms	- Mb
displayProductListReviews	1.791 ms	- Mb
displayProductListReviews	1.234 ms	- Mb
displayProductListReviews	1.655 ms	- Mb
displayProductListReviews	1.723 ms	- Mb
displayProductListReviews	1.587 ms	- Mb
displayProductListReviews	1.575 ms	- Mb
displayProductListReviews	1.647 ms	- Mb
displayProductListReviews	1.739 ms	- Mb
displayProductListReviews	1.688 ms	- Mb
displayProductListReviews	1.657 ms	- Mb
displayProductListReviews	1.622 ms	- Mb
displayProductListReviews	15.212 ms	- Mb
displayProductListReviews	2.035 ms	- Mb
displayProductListReviews	1.433 ms	- Mb
displayProductListReviews	1.488 ms	- Mb
displayProductListReviews	1.650 ms	- Mb
displayProductListReviews	1.761 ms	- Mb
displayProductListReviews	1.780 ms	- Mb
displayProductListReviews	1.622 ms	- Mb
displayProductListReviews	1.611 ms	- Mb
ps_googleanalytics	13.523 ms	0.05 Mb
__construct	0.142 ms	0.03 Mb
hookDisplayHeader	0.040 ms	- Mb
hookDisplayBeforeBodyClosingTag	13.341 ms	0.02 Mb
zonecolorsfonts	38.591 ms	0.87 Mb
__construct	0.207 ms	0.02 Mb
hookDisplayHeader	37.346 ms	0.85 Mb
hookDisplayOutsideMainPage	1.038 ms	0.01 Mb
zonemegamenu	6.144 ms	0.12 Mb
__construct	0.278 ms	0.03 Mb
hookDisplayHeader	0.838 ms	0.01 Mb
hookDisplayNavFullWidth	5.028 ms	0.07 Mb
prestastripe	1.218 ms	0.02 Mb
__construct	1.206 ms	0.02 Mb
hookDisplayHeader	0.012 ms	- Mb
ps_facetedsearch	1.602 ms	0.10 Mb
__construct	0.298 ms	0.10 Mb
hookProductSearchProvider	0.240 ms	- Mb
hookDisplayLeftColumn	1.064 ms	- Mb
ps_languageselector	0.608 ms	0.06 Mb
__construct	0.160 ms	0.02 Mb
displayNav2	0.448 ms	0.04 Mb
ps_currencyselector	0.474 ms	0.06 Mb
__construct	0.114 ms	0.02 Mb
displayNav2	0.360 ms	0.04 Mb
ps_customersignin	4.063 ms	0.08 Mb
__construct	0.101 ms	0.02 Mb
displayTop	3.962 ms	0.06 Mb
ps_categorytree	24.074 ms	0.75 Mb
__construct	0.248 ms	0.02 Mb
displayLeftColumn	23.826 ms	0.74 Mb
zonecolumnblocks	4.101 ms	0.13 Mb
__construct	0.271 ms	0.09 Mb
hookDisplayLeftColumn	3.830 ms	0.04 Mb
zonepopupnewsletter	1.823 ms	0.11 Mb
__construct	0.244 ms	0.08 Mb
hookDisplayOutsideMainPage	1.579 ms	0.03 Mb
statsdata	7.109 ms	0.21 Mb
__construct	0.148 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	6.961 ms	0.19 Mb
23 module(s)	340.432 ms	10.83 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
168	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>=118 AND c.nright<=119 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	9.656 ms	13664674816	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)
605	INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (76653,803264849),(76653,3974931321),(76653,1289214159),(76653,1785617407),(76653,2936477779),(76653,1727466530),(76653,1432532875),(76653,1025009294),(76653,1804081323),(76653,3479716883),(76653,66301815),(76653,537553573),(76653,3045727500),(76653,3231073010),(76653,1825096520),(76653,3225262556),(76653,2645763144),(76653,2027619899),(76653,786864081),(76653,1849360992),(76653,294428854),(76653,3774376179),(76653,2880678980),(76653,114155291),(76653,2929321318),(76653,2087307803),(76653,2369020978),(76653,1152186767),(76653,4222788516),(76653,2858566420),(76653,848840972),(76653,4147554351),(76653,770698498),(76653,2244011448),(76653,477004582),(76653,3610318732),(76653,1070190107),(76653,937307692),(76653,25761885),(76653,3366890060),(76653,3483396593),(76653,392306519),(76653,909258745),(76653,179865882),(76653,3099645137),(76653,3371246540),(76653,2390640699),(76653,501027234),(76653,3032495894),(76653,2100541971),(76653,2793494280),(76653,180908336),(76653,1192985740),(76653,1972034646),(76653,2419117650),(76653,3803768817),(76653,4265874642),(76653,67723771),(76653,3423129237),(76653,3399895114),(76653,3221089548),(76653,2990154896),(76653,2728213885),(76653,933991437),(76653,2513627470),(76653,468067826),(76653,4137721533),(76653,1552016987),(76653,4080301755),(76653,4245349388),(76653,1973472416),(76653,1839057912),(76653,3745041382),(76653,3035734567),(76653,3719469943),(76653,3466131047),(76653,679558129),(76653,462819688),(76653,4267553191),(76653,518809702),(76653,3303811122),(76653,2883778317),(76653,1694893476),(76653,3287268691),(76653,3711637102),(76653,698879415),(76653,885817714),(76653,125306139),(76653,1634619674),(76653,58280175),(76653,3363778289),(76653,1161663254),(76653,201135304),(76653,288600709),(76653,1021330335),(76653,2858809635),(76653,2763627026),(76653,3717400459),(76653,4125370705),(76653,3997906175),(76653,4162316513),(76653,3219397995),(76653,2539165674),(76653,1046234598),(76653,787652129),(76653,1595426297),(76653,4184932827),(76653,1985552396),(76653,1944795689),(76653,3799916950),(76653,1827123668),(76653,1447744642),(76653,1636796806),(76653,2645405926),(76653,1474595477),(76653,3375525138),(76653,3902077767),(76653,3507415422),(76653,2781072282),(76653,2002273313),(76653,3164880625),(76653,2490789905),(76653,1000843653),(76653,48947005),(76653,3883347157),(76653,3700474777),(76653,4264269047),(76653,2125390191),(76653,4270481046),(76653,1693150473),(76653,343450730),(76653,381351735),(76653,2863449446),(76653,3772294966),(76653,3877457961),(76653,1492116830),(76653,4041511410),(76653,828132466),(76653,4090211224),(76653,2185737194),(76653,3517149926),(76653,647687838),(76653,733479784),(76653,1440916471),(76653,3262261204),(76653,1872100372),(76653,2092461357),(76653,3357609169),(76653,2365529006),(76653,1263061406),(76653,2296732656),(76653,534196217),(76653,482025419),(76653,2811467352),(76653,2488480532),(76653,3501473861),(76653,1917272649),(76653,1878317490),(76653,1789511633),(76653,956713705),(76653,89981727),(76653,1143557322),(76653,2749361789),(76653,3857194488),(76653,1024086260),(76653,26040876),(76653,1804243295),(76653,2165251395),(76653,1281618245),(76653,2793993627),(76653,426054238),(76653,3398682121),(76653,1025101115),(76653,2974984653),(76653,2214325187),(76653,997821910),(76653,2005463392),(76653,3252396061),(76653,942332382),(76653,3816934055),(76653,1661692647),(76653,975758589),(76653,2301364099),(76653,855746680),(76653,637832447),(76653,3938675492),(76653,508940865),(76653,911480697),(76653,1283363269),(76653,3552869238),(76653,2961923901),(76653,3747234531),(76653,3155646160),(76653,3164668199),(76653,2271068282),(76653,84354396),(76653,2915068863),(76653,4064530110),(76653,3216991891),(76653,2045363644),(76653,2664176477),(76653,1076722390),(76653,505410826),(76653,3544422162),(76653,2506779464),(76653,2552384108),(76653,876907216),(76653,82980331),(76653,3890150098),(76653,3475437886),(76653,2302280848),(76653,1133144647),(76653,801167173),(76653,2059315716),(76653,3139619822),(76653,2937007520),(76653,1589371182),(76653,693370988),(76653,2708427394),(76653,1007456900),(76653,610735313),(76653,3846627131),(76653,2031830639),(76653,1908602231),(76653,1401333655),(76653,378101424),(76653,996218346),(76653,660881695),(76653,2938384267),(76653,4250264855),(76653,1895305721),(76653,502965417),(76653,1982471117),(76653,2524144246),(76653,2774996218),(76653,1068709096),(76653,4077513867),(76653,2900588200),(76653,465472731),(76653,4139839450),(76653,2360011682),(76653,4211248848),(76653,283341417),(76653,4165214622),(76653,3508523596),(76653,234404923),(76653,2782693783),(76653,3413880379),(76653,3540168379),(76653,861653603),(76653,3160995915),(76653,1391251310),(76653,2106651858),(76653,3572623339),(76653,4629984),(76653,2488722736),(76653,3486510944),(76653,2675016634),(76653,2165907305),(76653,136687257),(76653,3540179561),(76653,2792526429),(76653,2220600372),(76653,2914585448),(76653,3882733113),(76653,1688090355),(76653,3534950496),(76653,1182870252),(76653,412601709),(76653,574969182),(76653,2970413814),(76653,1487282505),(76653,3228977345),(76653,2023459642),(76653,3291711134),(76653,2792891444),(76653,3335276918),(76653,502111155),(76653,1347492703),(76653,2832080533),(76653,1215320197),(76653,2317239205),(76653,1931846913),(76653,1721014625),(76653,738600257),(76653,2998338424),(76653,1207945902),(76653,734241479),(76653,3324570843),(76653,4126771257),(76653,1712456575),(76653,3169253733),(76653,1160958045),(76653,1130949510),(76653,3116084871),(76653,269178051),(76653,24773614),(76653,3204450510),(76653,3468662336),(76653,1808444077),(76653,4095410992),(76653,1012520131),(76653,2367920745),(76653,2603361072),(76653,2741539031),(76653,607507456),(76653,616165826),(76653,2288576869),(76653,4252798532),(76653,2692385638),(76653,4100315394),(76653,3061254709),(76653,1657292258),(76653,2148967437),(76653,1248236410),(76653,2457219175),(76653,1920985790),(76653,1340703149),(76653,1618471777),(76653,4160689201),(76653,1822364967),(76653,479188821),(76653,1661785323),(76653,4137484009),(76653,2636427258),(76653,1499247737),(76653,2061922205),(76653,665830591),(76653,916194615),(76653,495595719),(76653,3026469794),(76653,1845449656),(76653,4078122428),(76653,2044505385),(76653,3156749269),(76653,3919036276),(76653,204613135),(76653,605377709),(76653,766051911),(76653,30400764),(76653,4211022030),(76653,715827285),(76653,1092948871),(76653,610201349),(76653,1023110113),(76653,3379323545),(76653,2591028766),(76653,1994095466),(76653,33157726),(76653,198243957),(76653,94201498),(76653,2540831776),(76653,1707019604),(76653,2730046909),(76653,4101073252),(76653,207761914),(76653,2750534087),(76653,980926717),(76653,377071036),(76653,2983490672),(76653,584353846),(76653,1743688562),(76653,3223058413),(76653,1665991311),(76653,3093731065),(76653,1095877807),(76653,1085889875),(76653,2059985562),(76653,3618062925),(76653,592374860),(76653,4217863027),(76653,3425247989),(76653,1636391408),(76653,1698766782),(76653,2162739858),(76653,1538367880),(76653,3760626336),(76653,1987713032),(76653,2338874856),(76653,4206689645),(76653,1723372602),(76653,2788329276),(76653,2095305502),(76653,3135330775),(76653,2402748468),(76653,24058172),(76653,4000683245),(76653,315670382),(76653,2558276906),(76653,1745365471),(76653,2782569384),(76653,3422117706),(76653,552626444),(76653,1506232339),(76653,2933163456),(76653,1483801350),(76653,1400586123),(76653,3746875726),(76653,2604810181),(76653,2905930158),(76653,803588046),(76653,1651400661),(76653,1431243585),(76653,1586185269),(76653,4110009762),(76653,3647374073),(76653,4196158832),(76653,644435096),(76653,1862966990),(76653,2098775956),(76653,4045847707),(76653,3122054119),(76653,1971194991),(76653,2149367276),(76653,1888540635),(76653,2660577125),(76653,2508340497),(76653,196341346),(76653,1790101800),(76653,1054130805),(76653,2741947598),(76653,1292400575),(76653,545037028),(76653,1516477184),(76653,2706799993),(76653,562470873),(76653,2591346466),(76653,613023703),(76653,2725609989),(76653,2082081559),(76653,572560232),(76653,2833489058),(76653,1999611979),(76653,1938789650),(76653,2958717166),(76653,1035708154),(76653,2025067287),(76653,3804047398),(76653,248028803),(76653,4243412966),(76653,628124381),(76653,1271215494),(76653,2140466223),(76653,1298495884),(76653,3585931255),(76653,532975694),(76653,892763084),(76653,203145038),(76653,470924714),(76653,1460516495),(76653,2732318442),(76653,3996868778),(76653,862206445),(76653,3193479021),(76653,3382171736),(76653,3362897893),(76653,3598913121),(76653,1342337107),(76653,3202829344),(76653,1335223071),(76653,270790954),(76653,1086966479),(76653,484642328),(76653,4274468042),(76653,1740107684),(76653,2117688527),(76653,1393082718),(76653,366510022),(76653,341328174),(76653,1469264429),(76653,968691010),(76653,3210232788),(76653,809700252),(76653,3705477223),(76653,1639200307),(76653,3585776886),(76653,3305319229),(76653,1052899681),(76653,2176267881),(76653,357387863),(76653,451177334),(76653,677589039),(76653,1181390953),(76653,898241702),(76653,3480303789),(76653,1736215096),(76653,2511740146),(76653,2560762429),(76653,1570623991),(76653,897080848),(76653,891021207),(76653,2807843172),(76653,411231410),(76653,2413680770),(76653,519468981),(76653,1898829954),(76653,4274422817),(76653,2781196321),(76653,433695516),(76653,1652336127),(76653,4200438598),(76653,3032893805),(76653,1435170492),(76653,341146430),(76653,755973553),(76653,2183774725),(76653,3967614532),(76653,1589097164),(76653,2441764320),(76653,745126750),(76653,348450311),(76653,2084175962),(76653,3357611772),(76653,1654631620),(76653,3098454302),(76653,2029227635),(76653,1731761366),(76653,2444253995),(76653,2906032508),(76653,872274856),(76653,4282856364),(76653,3328013593),(76653,4184469063),(76653,1074477927),(76653,475878802),(76653,1341972790),(76653,2770374005),(76653,4237489391),(76653,2818813526),(76653,3131100007),(76653,4267621199),(76653,1031922959),(76653,1616292706),(76653,630426110),(76653,1846388513),(76653,2239793094),(76653,1660370824),(76653,3321716633),(76653,2551727033),(76653,1836172154),(76653,1870881122),(76653,3324207484),(76653,1065867023),(76653,1459310880),(76653,1395112921),(76653,893552556),(76653,1795813847),(76653,2544364435),(76653,4188602229),(76653,1437064809),(76653,922605498),(76653,4180843510),(76653,2554784265),(76653,3798404205),(76653,1216801552),(76653,225525148),(76653,274058040),(76653,3206796234),(76653,610255635),(76653,3139895407),(76653,3993594441),(76653,2078652070),(76653,3340749058),(76653,2282248923),(76653,3201099700),(76653,3944887276),(76653,887478137),(76653,620965629),(76653,53639561),(76653,687854272),(76653,4204526813),(76653,3434636086),(76653,3859247582),(76653,2160451939),(76653,419013317),(76653,488655959),(76653,2224381764),(76653,857621694),(76653,593880699),(76653,1743569168),(76653,747100668),(76653,2627272664),(76653,1477316791),(76653,852002855),(76653,3813191394),(76653,3206482767),(76653,2935275735),(76653,825997452),(76653,4128572079),(76653,4149399208),(76653,2432005645),(76653,945310979),(76653,206553734),(76653,3381625344),(76653,2613891474),(76653,1285565060),(76653,725086502),(76653,2181279565),(76653,2136294074),(76653,531227063),(76653,3291030245),(76653,3423892574),(76653,1818418110),(76653,1175554195),(76653,231365613),(76653,3071984169),(76653,1510809703),(76653,2304894647),(76653,724387218),(76653,3702122266),(76653,3105745802),(76653,3598888791),(76653,40599425),(76653,4256434691),(76653,1198380170),(76653,3549401556),(76653,2300237909),(76653,484124464),(76653,3042798728),(76653,767973032),(76653,4146324303),(76653,1493350341),(76653,2166736334),(76653,3061340275),(76653,1468811388),(76653,714571165),(76653,1958965990),(76653,2146366302),(76653,2212338847),(76653,2088651590),(76653,2684538463),(76653,2292708505),(76653,571001464),(76653,608126571),(76653,2736309071),(76653,1479333754),(76653,1794660366),(76653,2319975337),(76653,1093438481),(76653,2975864804),(76653,2504416172),(76653,3531750290),(76653,219666672),(76653,4219072870),(76653,1053258155),(76653,2382983142),(76653,1006288562),(76653,1770263986),(76653,3089735283),(76653,3689334927),(76653,2901629603),(76653,2019277020),(76653,2853333944),(76653,1110695191),(76653,3884283185),(76653,4268093708),(76653,159799075),(76653,1715997742),(76653,1009155269),(76653,3922001006),(76653,3916338789),(76653,1085252167),(76653,207705430),(76653,1190601026),(76653,1441004396),(76653,1567147586),(76653,964098054),(76653,1385174189),(76653,3607427007),(76653,4065177061),(76653,1552830538),(76653,3778287701),(76653,3986294473),(76653,4127238085),(76653,1865170325),(76653,2161789419),(76653,2889615117),(76653,785261358),(76653,3873733217),(76653,2600209543),(76653,3958092558),(76653,4143434528),(76653,3225228598),(76653,3451063310),(76653,810085901),(76653,1502204888),(76653,2931931582),(76653,1339720903),(76653,4093703382),(76653,1016897830),(76653,1186809094),(76653,2269117600),(76653,813555736),(76653,733475850),(76653,305814753),(76653,2720553993),(76653,212227262),(76653,1328958432),(76653,3903742053),(76653,2617942920),(76653,4254367326),(76653,2895836413),(76653,1090341105),(76653,3174277595),(76653,639084285),(76653,4064195579),(76653,2134315289),(76653,608843276),(76653,4190247440),(76653,1090444753),(76653,2554275840),(76653,2758076506),(76653,2518001916),(76653,3620157415),(76653,1195920681),(76653,1822840633),(76653,1087551238),(76653,235508323),(76653,1139244570),(76653,810960133),(76653,425550269),(76653,1767940144),(76653,1488780247),(76653,1250541405),(76653,1715845038),(76653,3777612587),(76653,2285237154),(76653,802817926),(76653,4280998710),(76653,1108258121),(76653,1107026853),(76653,2913745362),(76653,1129101120),(76653,2454813183),(76653,1690919006),(76653,23973636),(76653,293370743),(76653,1041759778),(76653,3142497267),(76653,2920365983),(76653,2300359472),(76653,885232682),(76653,1995817456),(76653,3443377157),(76653,863919144),(76653,1324348692),(76653,4019216150),(76653,443752815),(76653,4223293),(76653,1182491637),(76653,4257294915),(76653,3629776934),(76653,582958316),(76653,3061655453),(76653,1665355533),(76653,1929899841),(76653,1033949851),(76653,2010879266),(76653,1872304779),(76653,1282102725),(76653,3589651214),(76653,4095654001),(76653,2447713556),(76653,2543494532),(76653,2069898435),(76653,3286503857),(76653,2662939963),(76653,93111834),(76653,3160936308),(76653,261262800),(76653,141197408),(76653,1904512268),(76653,3001025754),(76653,2247670246),(76653,535154833),(76653,3476002757),(76653,3806439314),(76653,1819793014),(76653,3545273473),(76653,3957652542),(76653,3018295592),(76653,1367893712),(76653,1034338066),(76653,3229510223),(76653,4276953245),(76653,3363858574),(76653,2870596766),(76653,648526699),(76653,3627085975),(76653,1585047995),(76653,1960922033),(76653,748737253),(76653,1175066615),(76653,1318322018),(76653,260367662),(76653,643741484),(76653,1013706048),(76653,1726352130),(76653,2222354404),(76653,1327031463),(76653,1131865044),(76653,839200087),(76653,1407668396),(76653,3548333318),(76653,237845721),(76653,3056051791),(76653,747235328),(76653,172675174),(76653,2781705803),(76653,2111348799),(76653,3067187587),(76653,618638032),(76653,3369756381),(76653,2232055662),(76653,55113216),(76653,3939915090),(76653,2586983921),(76653,3286008345),(76653,1956055310),(76653,740042513),(76653,2282536358),(76653,1863122946),(76653,1296880981),(76653,2589434346),(76653,1621393368),(76653,39250009),(76653,72263924),(76653,1587391050),(76653,847186998),(76653,2455499024),(76653,859347884),(76653,2244795234),(76653,64890532),(76653,2396876497),(76653,816477050),(76653,854639805),(76653,22155579),(76653,2974186391),(76653,2647341758),(76653,2099931378),(76653,1498878833),(76653,1569858340),(76653,612299607),(76653,2378739320),(76653,4194211811),(76653,1920811832),(76653,1850919567),(76653,3345708374),(76653,42449643),(76653,2672005996),(76653,526640306),(76653,3718234029),(76653,2254746877),(76653,2481445158),(76653,2113031430),(76653,1279304602),(76653,1378955633),(76653,3924888977),(76653,1697117306),(76653,3406763364),(76653,1129505049) ON DUPLICATE KEY UPDATE id=id	8.616 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)
528	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.046 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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
119	UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1;	7.360 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)
169	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>=118 AND c.nright<=119 GROUP BY p.id_product) p	6.912 ms	13664674816			/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)
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`)	3.235 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)
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.341 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)
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.333 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)
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	1.891 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)
606	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	1.819 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)
171	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-11-30 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 (2071,2149,5942,8816,8969,9315,11461,11606,13864,15633,21802,35047,48894,57182,57185,81314,84364,93440,94957,95494,98429,100475,100585,100600)	1.553 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)
602	INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 388923780, 'https://cadeaufou.com/261-cadeaux-pour-soins-personnels', 1, 2, 1, 261, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0;	1.345 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)
593	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.189 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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
598	INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('894973', '', 'cadeaufou.com/261-cadeaux-pour-soins-personnels', '', '2023-11-30 12:01:56')	1.102 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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
597	INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('897262', '7376', '752115218', '', '1', '1', '2023-11-30 12:01:56')	1.004 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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1)	0.968 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)
533	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 (2149) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.840 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
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` = 261 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.832 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)
529	SELECT SQL_NO_CACHE * FROM `ps21_zcolumnblock` b LEFT JOIN `ps21_zcolumnblock_lang` bl ON b.`id_zcolumnblock` = bl.`id_zcolumnblock` WHERE b.`id_shop` = 1 AND `id_lang` = 1 AND `active` = 1 GROUP BY b.`id_zcolumnblock` ORDER BY b.`position` ASC	0.769 ms	16	Yes	Yes	/modules/zonecolumnblocks/classes/ZColumnBlock.php:116 /modules/zonecolumnblocks/zonecolumnblocks.php:1041 (getList) /modules/zonecolumnblocks/zonecolumnblocks.php:1084 (preProcess) /classes/Hook.php:1043 (hookDisplayLeftColumn) /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: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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook`	0.762 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)
530	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 (2071) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.706 ms	1	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_65686ba3cc3507_51240897) /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/d5/ea/f9/d5eaf97eefd45774f942385f18dfc63e3a4e67b0_2.file.productlist.tpl.php:37 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
324	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` = 57182 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` = 57182 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.704 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)
576	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 (100475) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.680 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
451	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` = 8969 ORDER BY `position`	0.667 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)
575	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 (98429) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.667 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
564	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 (57185) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.660 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
570	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 (81314) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.657 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
537	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 (9315) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.647 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
571	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 (84364) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.641 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
545	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 (13864) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.634 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
296	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` = 35047 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` = 35047 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.632 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)
574	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 (95494) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.621 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
572	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 (93440) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.619 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
577	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 (100585) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.615 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
53	SELECT SQL_NO_CACHE tr.* FROM `ps21_tax_rule` tr JOIN `ps21_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 8 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	0.614 ms	1			/classes/tax/TaxRulesTaxManager.php:109 /modules/jprestaspeedpack/classes/JprestaUtilsTaxManager.php:111 (getTaxCalculator) /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)
546	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 (15633) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.613 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
472	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` = 35047 ORDER BY `position`	0.612 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)
559	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 (57182) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.609 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)
486	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` = 84364) AND (b.`id_shop` = 1) LIMIT 1	0.608 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)
534	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 (5942) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.602 ms	1	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_65686ba3cc3507_51240897) /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_65686ba3ca6dd5_00002801) /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_65686ba3c9f947_11575467) /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_65686ba3a05f82_35948576) /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_65686ba39e5a81_49339471) /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_65686ba39dfd22_44578763) /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_65686ba39cd201_71121601) /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)

Cadeaux pour Soins Personnels