Load Time	930 ms
Querying Time	343 ms
Queries	503
Memory Peak Usage	27.9 Mb
Included Files	1263 files - 11.89 Mb
PrestaShop Cache	- Mb
Global vars	0.19 Mb
- global $_MODULES	164k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $ignored_params	2k
- global $jprestaWebpConverterOptions	2k
- global $_MODULE	2k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	7.986 ms	7.986 ms	8.54 Mb	9.2 Mb
__construct	15.647 ms	23.633 ms	1.73 Mb	11.9 Mb
config	28.195 ms	51.828 ms	1.21 Mb	11.9 Mb
__construct	0.054 ms	51.882 ms	- Mb	11.9 Mb
init	30.064 ms	81.946 ms	2.13 Mb	14.8 Mb
checkAccess	0.001 ms	81.947 ms	- Mb	14.8 Mb
setMedia	2.491 ms	84.438 ms	0.26 Mb	14.8 Mb
postProcess	0.001 ms	84.439 ms	- Mb	14.8 Mb
initHeader	0.001 ms	84.440 ms	- Mb	14.8 Mb
initContent	467.098 ms	551.538 ms	7.69 Mb	22.5 Mb
initFooter	0.003 ms	551.541 ms	- Mb	22.5 Mb
display	377.975 ms	930 ms	5.59 Mb	27.9 Mb

Hook	Time	Memory Usage
displayProductListReviews	71.579 ms	1.33 Mb
=> productcomments (widget)	21.848 ms	1.28 Mb
=> productcomments (widget)	1.878 ms	- Mb
=> productcomments (widget)	1.719 ms	- Mb
=> productcomments (widget)	1.606 ms	- Mb
=> productcomments (widget)	1.676 ms	- Mb
=> productcomments (widget)	1.645 ms	- Mb
=> productcomments (widget)	1.630 ms	- Mb
=> productcomments (widget)	1.587 ms	- Mb
=> productcomments (widget)	1.605 ms	- Mb
=> productcomments (widget)	1.646 ms	- Mb
=> productcomments (widget)	1.738 ms	- Mb
=> productcomments (widget)	1.579 ms	- Mb
=> productcomments (widget)	1.527 ms	- Mb
=> productcomments (widget)	12.992 ms	- Mb
=> productcomments (widget)	2.050 ms	- Mb
=> productcomments (widget)	1.786 ms	- Mb
=> productcomments (widget)	1.618 ms	- Mb
=> productcomments (widget)	1.737 ms	- Mb
=> productcomments (widget)	1.635 ms	- Mb
=> productcomments (widget)	1.584 ms	- Mb
=> productcomments (widget)	1.523 ms	- Mb
=> productcomments (widget)	1.544 ms	- Mb
=> productcomments (widget)	1.672 ms	- Mb
=> productcomments (widget)	1.755 ms	- Mb
ActionDispatcherBefore	48.026 ms	3.09 Mb
=> jprestaspeedpack	48.026 ms	3.09 Mb
ActionOutputHTMLBefore	39.663 ms	0.14 Mb
=> jprestaspeedpack	39.663 ms	0.14 Mb
displayLeftColumn	26.053 ms	0.74 Mb
=> ps_categorytree (widget)	26.053 ms	0.74 Mb
displayTop	15.213 ms	0.20 Mb
=> ps_searchbar (widget)	1.619 ms	0.05 Mb
=> ps_customersignin (widget)	3.357 ms	0.06 Mb
=> ps_shoppingcart (widget)	10.237 ms	0.09 Mb
DisplayBeforeBodyClosingTag	14.154 ms	0.27 Mb
=> statsdata	6.243 ms	0.25 Mb
=> ps_googleanalytics	7.911 ms	0.02 Mb
ActionDispatcher	10.550 ms	0.70 Mb
=> jprestaspeedpack	10.550 ms	0.70 Mb
DisplayFooter	10.494 ms	0.11 Mb
=> zonethememanager	0.002 ms	- Mb
=> blockwishlist	10.492 ms	0.11 Mb
displayFooterRight	3.565 ms	0.07 Mb
=> ps_emailsubscription (widget)	3.565 ms	0.07 Mb
DisplayHeader	2.867 ms	0.06 Mb
=> jprestaspeedpack	0.123 ms	- Mb
=> ps_shoppingcart	0.034 ms	- Mb
=> ps_searchbar	0.184 ms	- Mb
=> productcomments	0.107 ms	- Mb
=> ps_googleanalytics	0.062 ms	- Mb
=> zonecolorsfonts	0.984 ms	0.03 Mb
=> zonemegamenu	0.847 ms	0.01 Mb
=> zonethememanager	0.447 ms	0.01 Mb
=> prestastripe	0.010 ms	- Mb
=> prestaadvanceloyaltyprogram	0.069 ms	- Mb
DisplayLeftColumn	1.630 ms	0.02 Mb
=> ps_facetedsearch	1.132 ms	- Mb
=> zonecolumnblocks	0.498 ms	0.01 Mb
ActionFrontControllerSetVariables	1.361 ms	0.06 Mb
=> zonethememanager	1.361 ms	0.06 Mb
displayNav2	0.924 ms	0.08 Mb
=> ps_languageselector (widget)	0.581 ms	0.04 Mb
=> ps_currencyselector (widget)	0.343 ms	0.04 Mb
DisplayOutsideMainPage	0.842 ms	0.03 Mb
=> zonepopupnewsletter	0.310 ms	0.01 Mb
=> zonecolorsfonts	0.289 ms	0.01 Mb
=> zonethememanager	0.243 ms	0.01 Mb
displayFooterLeft	0.818 ms	0.06 Mb
=> ps_socialfollow (widget)	0.818 ms	0.06 Mb
ActionFrontControllerSetMedia	0.659 ms	0.01 Mb
=> blockreassurance	0.131 ms	- Mb
=> blockwishlist	0.190 ms	- Mb
=> ps_emailsubscription	0.043 ms	- Mb
=> ps_socialfollow	0.045 ms	- Mb
=> ps_emailalerts	0.054 ms	- Mb
=> prestaadvanceloyaltyprogram	0.196 ms	- Mb
DisplayFooterLeft	0.432 ms	0.01 Mb
=> zonethememanager	0.432 ms	0.01 Mb
DisplayFooterAfter	0.387 ms	0.01 Mb
=> zonethememanager	0.387 ms	0.01 Mb
DisplayFooterRight	0.375 ms	0.01 Mb
=> zonethememanager	0.375 ms	0.01 Mb
DisplayNavFullWidth	0.345 ms	0.01 Mb
=> zonemegamenu	0.345 ms	0.01 Mb
DisplayNav1	0.336 ms	0.01 Mb
=> zonethememanager	0.336 ms	0.01 Mb
ProductSearchProvider	0.314 ms	- Mb
=> ps_facetedsearch	0.314 ms	- Mb
DisplayBanner	0.310 ms	0.01 Mb
=> zonethememanager	0.310 ms	0.01 Mb
DisplaySidebarNavigation	0.304 ms	- Mb
=> zonethememanager	0.304 ms	- Mb
ActionObjectAddAfter	0.041 ms	- Mb
=> jprestaspeedpack	0.034 ms	- Mb
=> jprestaspeedpack	0.004 ms	- Mb
=> jprestaspeedpack	0.003 ms	- Mb
ModuleRoutes	0.025 ms	0.02 Mb
=> prestaadvanceloyaltyprogram	0.013 ms	0.01 Mb
=> prestaadvanceloyaltyprogram	0.012 ms	0.01 Mb
ActionFrontControllerInitAfter	0.012 ms	- Mb
=> prestaadvanceloyaltyprogram	0.012 ms	- Mb
DisplayAfterBodyOpeningTag	0.012 ms	- Mb
=> blockreassurance	0.012 ms	- Mb
DisplayFooterBefore	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
29 hook(s)	251.301 ms	7.07 Mb

Module	Time	Memory Usage
prestaadvanceloyaltyprogram	7.955 ms	0.54 Mb
__construct	7.636 ms	0.51 Mb
hookModuleRoutes	0.019 ms	0.01 Mb
hookActionFrontControllerInitAfter	0.016 ms	- Mb
hookActionFrontControllerSetMedia	0.197 ms	- Mb
hookDisplayHeader	0.071 ms	- Mb
hookModuleRoutes	0.016 ms	0.01 Mb
jprestaspeedpack	99.715 ms	4.00 Mb
__construct	1.289 ms	0.06 Mb
hookActionDispatcherBefore	48.032 ms	3.09 Mb
hookActionDispatcher	10.553 ms	0.70 Mb
hookDisplayHeader	0.125 ms	- Mb
hookActionObjectAddAfter	0.037 ms	- Mb
hookActionObjectAddAfter	0.006 ms	- Mb
hookActionObjectAddAfter	0.005 ms	- Mb
hookActionOutputHTMLBefore	39.668 ms	0.14 Mb
blockreassurance	1.024 ms	0.09 Mb
__construct	0.859 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.133 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.019 ms	- Mb
hookDisplayFooterBefore	0.013 ms	- Mb
blockwishlist	10.817 ms	0.13 Mb
__construct	0.130 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.192 ms	- Mb
hookDisplayFooter	10.495 ms	0.11 Mb
ps_emailsubscription	3.723 ms	0.10 Mb
__construct	0.105 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.044 ms	- Mb
displayFooterRight	3.574 ms	0.07 Mb
ps_socialfollow	0.942 ms	0.07 Mb
__construct	0.076 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.046 ms	- Mb
displayFooterLeft	0.820 ms	0.06 Mb
ps_emailalerts	0.186 ms	0.09 Mb
__construct	0.130 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.056 ms	- Mb
zonethememanager	14.422 ms	1.30 Mb
__construct	10.160 ms	1.15 Mb
hookActionFrontControllerSetVariables	1.366 ms	0.06 Mb
hookDisplayHeader	0.472 ms	0.01 Mb
hookDisplaySidebarNavigation	0.306 ms	- Mb
hookDisplayBanner	0.313 ms	0.01 Mb
hookDisplayNav1	0.338 ms	0.01 Mb
hookDisplayFooterLeft	0.434 ms	0.01 Mb
hookDisplayFooterRight	0.377 ms	0.02 Mb
hookDisplayFooter	0.003 ms	- Mb
hookDisplayFooterAfter	0.408 ms	0.01 Mb
hookDisplayOutsideMainPage	0.245 ms	0.01 Mb
ps_shoppingcart	10.380 ms	0.11 Mb
__construct	0.105 ms	0.02 Mb
hookDisplayHeader	0.036 ms	- Mb
displayTop	10.239 ms	0.09 Mb
ps_searchbar	1.905 ms	0.14 Mb
__construct	0.097 ms	0.08 Mb
hookDisplayHeader	0.186 ms	- Mb
displayTop	1.622 ms	0.05 Mb
productcomments	71.896 ms	1.37 Mb
__construct	0.124 ms	0.03 Mb
hookDisplayHeader	0.108 ms	- Mb
displayProductListReviews	21.854 ms	1.28 Mb
displayProductListReviews	1.882 ms	- Mb
displayProductListReviews	1.722 ms	- Mb
displayProductListReviews	1.609 ms	- Mb
displayProductListReviews	1.679 ms	- Mb
displayProductListReviews	1.663 ms	- Mb
displayProductListReviews	1.633 ms	- Mb
displayProductListReviews	1.590 ms	- Mb
displayProductListReviews	1.607 ms	- Mb
displayProductListReviews	1.649 ms	- Mb
displayProductListReviews	1.741 ms	- Mb
displayProductListReviews	1.582 ms	- Mb
displayProductListReviews	1.530 ms	- Mb
displayProductListReviews	12.996 ms	- Mb
displayProductListReviews	2.052 ms	- Mb
displayProductListReviews	1.788 ms	- Mb
displayProductListReviews	1.621 ms	- Mb
displayProductListReviews	1.740 ms	- Mb
displayProductListReviews	1.637 ms	- Mb
displayProductListReviews	1.586 ms	- Mb
displayProductListReviews	1.526 ms	- Mb
displayProductListReviews	1.547 ms	- Mb
displayProductListReviews	1.674 ms	- Mb
displayProductListReviews	1.757 ms	- Mb
ps_googleanalytics	8.066 ms	0.05 Mb
__construct	0.088 ms	0.03 Mb
hookDisplayHeader	0.063 ms	- Mb
hookDisplayBeforeBodyClosingTag	7.915 ms	0.02 Mb
zonecolorsfonts	1.446 ms	0.06 Mb
__construct	0.168 ms	0.02 Mb
hookDisplayHeader	0.987 ms	0.03 Mb
hookDisplayOutsideMainPage	0.291 ms	0.01 Mb
zonemegamenu	1.382 ms	0.06 Mb
__construct	0.185 ms	0.03 Mb
hookDisplayHeader	0.850 ms	0.01 Mb
hookDisplayNavFullWidth	0.347 ms	0.01 Mb
prestastripe	2.711 ms	0.02 Mb
__construct	2.699 ms	0.02 Mb
hookDisplayHeader	0.012 ms	- Mb
ps_facetedsearch	1.881 ms	0.10 Mb
__construct	0.429 ms	0.10 Mb
hookProductSearchProvider	0.317 ms	- Mb
hookDisplayLeftColumn	1.135 ms	- Mb
ps_languageselector	0.735 ms	0.06 Mb
__construct	0.151 ms	0.02 Mb
displayNav2	0.584 ms	0.04 Mb
ps_currencyselector	0.479 ms	0.06 Mb
__construct	0.134 ms	0.02 Mb
displayNav2	0.345 ms	0.04 Mb
ps_customersignin	3.443 ms	0.08 Mb
__construct	0.084 ms	0.02 Mb
displayTop	3.359 ms	0.06 Mb
ps_categorytree	26.164 ms	0.75 Mb
__construct	0.106 ms	0.02 Mb
displayLeftColumn	26.058 ms	0.74 Mb
zonecolumnblocks	0.905 ms	0.11 Mb
__construct	0.403 ms	0.09 Mb
hookDisplayLeftColumn	0.502 ms	0.01 Mb
zonepopupnewsletter	0.563 ms	0.03 Mb
__construct	0.250 ms	0.02 Mb
hookDisplayOutsideMainPage	0.313 ms	0.01 Mb
statsdata	6.370 ms	0.27 Mb
__construct	0.125 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	6.245 ms	0.25 Mb
23 module(s)	277.111 ms	9.59 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
165	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=285 AND c.nright<=286 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	80.327 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)
166	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=285 AND c.nright<=286 GROUP BY p.id_product) p	71.678 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)
501	INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (547,803264849),(547,3544422162),(547,2506779464),(547,1289214159),(547,1785617407),(547,2936477779),(547,1727466530),(547,1432532875),(547,1025009294),(547,1804081323),(547,3479716883),(547,66301815),(547,537553573),(547,3045727500),(547,3231073010),(547,1825096520),(547,3225262556),(547,2645763144),(547,2027619899),(547,786864081),(547,1849360992),(547,294428854),(547,3774376179),(547,2880678980),(547,114155291),(547,2929321318),(547,2087307803),(547,2369020978),(547,1152186767),(547,4222788516),(547,2858566420),(547,848840972),(547,4147554351),(547,770698498),(547,2244011448),(547,477004582),(547,3610318732),(547,1070190107),(547,937307692),(547,25761885),(547,3366890060),(547,3483396593),(547,392306519),(547,909258745),(547,179865882),(547,3099645137),(547,3371246540),(547,2390640699),(547,501027234),(547,3032495894),(547,2100541971),(547,2793494280),(547,180908336),(547,1192985740),(547,1972034646),(547,2419117650),(547,3803768817),(547,4265874642),(547,67723771),(547,3423129237),(547,3399895114),(547,3221089548),(547,2990154896),(547,2728213885),(547,933991437),(547,2513627470),(547,468067826),(547,4137721533),(547,1552016987),(547,4080301755),(547,4245349388),(547,1973472416),(547,1839057912),(547,3745041382),(547,3035734567),(547,3719469943),(547,3466131047),(547,679558129),(547,462819688),(547,4267553191),(547,518809702),(547,3303811122),(547,2883778317),(547,1694893476),(547,3287268691),(547,3711637102),(547,698879415),(547,885817714),(547,125306139),(547,1634619674),(547,58280175),(547,3363778289),(547,1161663254),(547,201135304),(547,288600709),(547,1021330335),(547,2858809635),(547,2763627026),(547,3717400459),(547,4125370705),(547,3997906175),(547,4162316513),(547,3219397995),(547,2539165674),(547,1046234598),(547,787652129),(547,1595426297),(547,4184932827),(547,1985552396),(547,1944795689),(547,3799916950),(547,1827123668),(547,1447744642),(547,1636796806),(547,2645405926),(547,1474595477),(547,3375525138),(547,3902077767),(547,3507415422),(547,2781072282),(547,2002273313),(547,3164880625),(547,2490789905),(547,1000843653),(547,48947005),(547,3883347157),(547,3700474777),(547,4264269047),(547,2125390191),(547,4270481046),(547,1693150473),(547,343450730),(547,381351735),(547,2863449446),(547,3772294966),(547,3877457961),(547,1492116830),(547,4041511410),(547,828132466),(547,4090211224),(547,2185737194),(547,3517149926),(547,647687838),(547,733479784),(547,1440916471),(547,3262261204),(547,1872100372),(547,2092461357),(547,3357609169),(547,2365529006),(547,1263061406),(547,2296732656),(547,534196217),(547,482025419),(547,2811467352),(547,2488480532),(547,3501473861),(547,1917272649),(547,1878317490),(547,1789511633),(547,956713705),(547,89981727),(547,1143557322),(547,2749361789),(547,3857194488),(547,1024086260),(547,26040876),(547,1804243295),(547,2165251395),(547,1281618245),(547,2793993627),(547,426054238),(547,3398682121),(547,1025101115),(547,2974984653),(547,2214325187),(547,997821910),(547,2005463392),(547,3252396061),(547,942332382),(547,3816934055),(547,1661692647),(547,975758589),(547,3974931321),(547,2301364099),(547,855746680),(547,637832447),(547,3938675492),(547,508940865),(547,911480697),(547,1283363269),(547,3552869238),(547,2961923901),(547,3747234531),(547,3155646160),(547,3164668199),(547,2271068282),(547,84354396),(547,2915068863),(547,4064530110),(547,3216991891),(547,2045363644),(547,2664176477),(547,1076722390),(547,505410826),(547,2552384108),(547,876907216),(547,82980331),(547,3890150098),(547,3475437886),(547,2302280848),(547,1133144647),(547,801167173),(547,2059315716),(547,3139619822),(547,2937007520),(547,1589371182),(547,693370988),(547,2708427394),(547,1007456900),(547,610735313),(547,3846627131),(547,2031830639),(547,1908602231),(547,1401333655),(547,378101424),(547,996218346),(547,660881695),(547,2938384267),(547,4250264855),(547,1895305721),(547,502965417),(547,1982471117),(547,2524144246),(547,2774996218),(547,1068709096),(547,4077513867),(547,2900588200),(547,465472731),(547,4139839450),(547,2360011682),(547,4211248848),(547,283341417),(547,4165214622),(547,3508523596),(547,234404923),(547,2782693783),(547,3413880379),(547,3540168379),(547,861653603),(547,3160995915),(547,1391251310),(547,2106651858),(547,3572623339),(547,4629984),(547,2488722736),(547,3486510944),(547,2675016634),(547,2165907305),(547,136687257),(547,3540179561),(547,2792526429),(547,2220600372),(547,2914585448),(547,3882733113),(547,1688090355),(547,3534950496),(547,1182870252),(547,412601709),(547,574969182),(547,2970413814),(547,1487282505),(547,3228977345),(547,2023459642),(547,3291711134),(547,2792891444),(547,3335276918),(547,502111155),(547,1347492703),(547,2832080533),(547,1215320197),(547,2317239205),(547,1931846913),(547,1721014625),(547,738600257),(547,2998338424),(547,1207945902),(547,734241479),(547,3324570843),(547,4126771257),(547,1712456575),(547,3169253733),(547,1160958045),(547,1130949510),(547,3116084871),(547,269178051),(547,24773614),(547,3204450510),(547,3468662336),(547,1808444077),(547,4095410992),(547,1012520131),(547,2367920745),(547,2603361072),(547,2741539031),(547,607507456),(547,616165826),(547,2288576869),(547,4252798532),(547,2692385638),(547,4100315394),(547,3061254709),(547,1657292258),(547,2148967437),(547,1248236410),(547,2457219175),(547,1920985790),(547,1340703149),(547,1618471777),(547,4160689201),(547,1822364967),(547,479188821),(547,1661785323),(547,4137484009),(547,2636427258),(547,1499247737),(547,2061922205),(547,665830591),(547,916194615),(547,495595719),(547,3026469794),(547,1845449656),(547,4078122428),(547,2044505385),(547,3156749269),(547,3919036276),(547,204613135),(547,605377709),(547,766051911),(547,30400764),(547,4211022030),(547,715827285),(547,1092948871),(547,610201349),(547,1023110113),(547,3379323545),(547,2591028766),(547,1994095466),(547,33157726),(547,198243957),(547,94201498),(547,2540831776),(547,1707019604),(547,2730046909),(547,4101073252),(547,207761914),(547,2750534087),(547,980926717),(547,377071036),(547,2983490672),(547,584353846),(547,1743688562),(547,3223058413),(547,1665991311),(547,3093731065),(547,1095877807),(547,1085889875),(547,2059985562),(547,3618062925),(547,592374860),(547,4217863027),(547,3425247989),(547,1636391408),(547,1698766782),(547,2162739858),(547,1538367880),(547,3760626336),(547,1987713032),(547,2338874856),(547,4206689645),(547,1723372602),(547,2788329276),(547,2095305502),(547,3135330775),(547,2402748468),(547,24058172),(547,4000683245),(547,315670382),(547,2558276906),(547,1745365471),(547,2782569384),(547,3422117706),(547,552626444),(547,1506232339),(547,2933163456),(547,1483801350),(547,1400586123),(547,3746875726),(547,2604810181),(547,2905930158),(547,803588046),(547,1651400661),(547,1431243585),(547,1586185269),(547,4110009762),(547,3647374073),(547,4196158832),(547,644435096),(547,1862966990),(547,2098775956),(547,4045847707),(547,3122054119),(547,1971194991),(547,2149367276),(547,1888540635),(547,2660577125),(547,2508340497),(547,196341346),(547,1790101800),(547,1054130805),(547,2741947598),(547,1292400575),(547,545037028),(547,1516477184),(547,2706799993),(547,562470873),(547,2591346466),(547,613023703),(547,2725609989),(547,2082081559),(547,572560232),(547,2833489058),(547,1999611979),(547,1938789650),(547,2958717166),(547,1035708154),(547,2025067287),(547,3804047398),(547,248028803),(547,4243412966),(547,628124381),(547,1271215494),(547,2140466223),(547,1298495884),(547,3585931255),(547,532975694),(547,892763084),(547,203145038),(547,470924714),(547,1460516495),(547,2732318442),(547,3996868778),(547,862206445),(547,3193479021),(547,3382171736),(547,3362897893),(547,3598913121),(547,1342337107),(547,3202829344),(547,1335223071),(547,270790954),(547,1086966479),(547,484642328),(547,4274468042),(547,1740107684),(547,2117688527),(547,1393082718),(547,366510022),(547,341328174),(547,1469264429),(547,968691010),(547,3210232788),(547,809700252),(547,3705477223),(547,1639200307),(547,3585776886),(547,3305319229),(547,1052899681),(547,2176267881),(547,357387863),(547,451177334),(547,677589039),(547,1181390953),(547,898241702),(547,3480303789),(547,1736215096),(547,2511740146),(547,2560762429),(547,1570623991),(547,897080848),(547,891021207),(547,2807843172),(547,411231410),(547,2413680770),(547,519468981),(547,1898829954),(547,4274422817),(547,2781196321),(547,433695516),(547,1652336127),(547,4200438598),(547,3032893805),(547,1435170492),(547,341146430),(547,755973553),(547,2183774725),(547,3967614532),(547,1589097164),(547,2441764320),(547,745126750),(547,348450311),(547,2084175962),(547,3357611772),(547,1654631620),(547,3098454302),(547,2029227635),(547,1731761366),(547,2444253995),(547,2906032508),(547,872274856),(547,4282856364),(547,3328013593),(547,4184469063),(547,1074477927),(547,475878802),(547,1341972790),(547,2770374005),(547,4237489391),(547,2818813526),(547,3131100007),(547,4267621199),(547,1031922959),(547,1616292706),(547,630426110),(547,1846388513),(547,2239793094),(547,1660370824),(547,3321716633),(547,2551727033),(547,1836172154),(547,1870881122),(547,3324207484),(547,1065867023),(547,1459310880),(547,1395112921),(547,893552556),(547,1795813847),(547,2544364435),(547,4188602229),(547,1437064809),(547,922605498),(547,4180843510),(547,2554784265),(547,3798404205),(547,1216801552),(547,225525148),(547,274058040),(547,3206796234),(547,610255635),(547,3139895407),(547,3993594441),(547,2078652070),(547,3340749058),(547,2282248923),(547,3201099700),(547,3944887276),(547,887478137),(547,620965629),(547,53639561),(547,687854272),(547,4204526813),(547,3434636086),(547,3859247582),(547,2160451939),(547,419013317),(547,488655959),(547,2224381764),(547,857621694),(547,593880699),(547,1743569168),(547,747100668),(547,2627272664),(547,1477316791),(547,852002855),(547,3813191394),(547,3206482767),(547,2935275735),(547,825997452),(547,4128572079),(547,4149399208),(547,2432005645),(547,945310979),(547,206553734),(547,3381625344),(547,2613891474),(547,1285565060),(547,725086502),(547,2181279565),(547,2136294074),(547,531227063),(547,3291030245),(547,3423892574),(547,1818418110),(547,1175554195),(547,231365613),(547,3071984169),(547,1510809703),(547,2304894647),(547,724387218),(547,3702122266),(547,3105745802),(547,3598888791),(547,40599425),(547,4256434691),(547,1198380170),(547,3549401556),(547,2300237909),(547,484124464),(547,3042798728),(547,767973032),(547,4146324303),(547,1493350341),(547,2166736334),(547,3061340275),(547,1468811388),(547,714571165),(547,1958965990),(547,2146366302),(547,2212338847),(547,2088651590),(547,2684538463),(547,2292708505),(547,571001464),(547,608126571),(547,2736309071),(547,1479333754),(547,1794660366),(547,2319975337),(547,1093438481),(547,2975864804),(547,2504416172),(547,3531750290),(547,219666672),(547,4219072870),(547,1053258155),(547,2382983142),(547,1006288562),(547,1770263986),(547,3089735283),(547,3689334927),(547,2901629603),(547,2019277020),(547,2853333944),(547,1110695191),(547,3884283185),(547,4268093708),(547,159799075),(547,1715997742),(547,1009155269),(547,3922001006),(547,3916338789),(547,1085252167),(547,207705430),(547,1190601026),(547,1441004396),(547,1567147586),(547,964098054),(547,1385174189),(547,3607427007),(547,4065177061),(547,1552830538),(547,3778287701),(547,3986294473),(547,4127238085),(547,1865170325),(547,2161789419),(547,2889615117),(547,785261358),(547,3873733217),(547,2600209543),(547,3958092558),(547,4143434528),(547,3225228598),(547,3451063310),(547,810085901),(547,1502204888),(547,2931931582),(547,1339720903),(547,4093703382),(547,1016897830),(547,1186809094),(547,2269117600),(547,813555736),(547,733475850),(547,305814753),(547,2720553993),(547,212227262),(547,1328958432),(547,3903742053),(547,2617942920),(547,4254367326),(547,2895836413),(547,1090341105),(547,3174277595),(547,639084285),(547,4064195579),(547,2134315289),(547,608843276),(547,4190247440),(547,1090444753),(547,2554275840),(547,2758076506),(547,2518001916),(547,3620157415),(547,1195920681),(547,1822840633),(547,1087551238),(547,235508323),(547,1139244570),(547,810960133),(547,425550269),(547,1767940144),(547,1488780247),(547,1250541405),(547,1715845038),(547,3777612587),(547,2285237154),(547,802817926),(547,4280998710),(547,1108258121),(547,1107026853),(547,2913745362),(547,1129101120),(547,2454813183),(547,1690919006),(547,23973636),(547,293370743),(547,1041759778),(547,3142497267),(547,2920365983),(547,2300359472),(547,885232682),(547,1995817456),(547,3443377157),(547,863919144),(547,1324348692),(547,4019216150),(547,443752815),(547,4223293),(547,1182491637),(547,4257294915),(547,3629776934),(547,582958316),(547,3061655453),(547,1665355533),(547,1929899841),(547,1033949851),(547,2010879266),(547,1872304779),(547,1282102725),(547,3589651214),(547,4095654001),(547,2447713556),(547,2543494532),(547,2069898435),(547,3286503857),(547,2662939963),(547,93111834),(547,3160936308),(547,261262800),(547,141197408),(547,1904512268),(547,3001025754),(547,2247670246),(547,535154833),(547,3476002757),(547,3806439314),(547,1819793014),(547,3545273473),(547,3957652542),(547,3018295592),(547,1367893712),(547,1034338066),(547,3229510223),(547,4276953245),(547,3363858574),(547,2870596766),(547,648526699),(547,3627085975),(547,1585047995),(547,1960922033),(547,748737253),(547,1175066615),(547,1318322018),(547,260367662),(547,643741484),(547,1013706048),(547,1726352130),(547,2222354404),(547,1327031463),(547,1131865044),(547,839200087),(547,1407668396),(547,3548333318),(547,237845721),(547,3056051791),(547,747235328),(547,172675174),(547,2781705803),(547,2111348799),(547,3067187587),(547,618638032),(547,3369756381),(547,2232055662),(547,55113216),(547,3939915090),(547,2586983921),(547,3286008345),(547,1956055310),(547,740042513),(547,2282536358),(547,1863122946),(547,1296880981),(547,2589434346),(547,1621393368),(547,39250009),(547,72263924),(547,1587391050),(547,847186998),(547,2455499024),(547,859347884),(547,2244795234),(547,64890532),(547,3513292693),(547,3289903540),(547,4163340559),(547,2453670429),(547,2949486487),(547,1818171890),(547,3479220851),(547,17127774),(547,3814767419),(547,446148700),(547,1718530958),(547,4097907501),(547,3301124160),(547,3299587500),(547,795837926),(547,1039660854),(547,3190584208),(547,3069872579),(547,3225663737),(547,427588548),(547,146118935),(547,2226851532),(547,1533583199),(547,1502012539),(547,3924888977),(547,1697117306),(547,3406763364),(547,1129505049) ON DUPLICATE KEY UPDATE id=id	10.549 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)
458	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.623 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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps21_configuration` c LEFT JOIN `ps21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	6.171 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`	3.507 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.475 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	2.140 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)
502	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.869 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)
170	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-12-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (120,125,144,261,263,264,265,266,268,269,756,909,1184,2052,2302,3272,3316,3688,3827,3946,4138,4171,4615,4620)	1.767 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)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1)	1.516 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)
498	INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 3282457509, 'https://cadeaufou.com/111-tables-et-chaises', 1, 2, 1, 111, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0;	1.414 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)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook`	1.287 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)
494	INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('916210', '', 'cadeaufou.com/111-tables-et-chaises', '', '2023-12-01 10:23:14')	1.285 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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
489	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.233 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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
169	REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("8128c8961856a34d907d7f2863d1dc50", "a:1:{s:7:\"filters\";a:0:{}}")	1.129 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /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)
119	UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1;	1.082 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)
493	INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('918501', '580', '751134203', '', '1', '1', '2023-12-01 10:23:14')	1.019 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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
339	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` = 3946 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` = 3946 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.933 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)
459	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 (120) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.876 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_6569a602befc05_24455543) /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_6569a602bd3370_12709354) /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_6569a602bcbdb4_91982382) /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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
280	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` = 1184 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` = 1184 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.860 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)
322	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` = 3688 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` = 3688 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.833 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)
475	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 (2302) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.793 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_6569a602befc05_24455543) /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_6569a602bd3370_12709354) /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_6569a602bcbdb4_91982382) /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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
347	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` = 4138 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` = 4138 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.792 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)
462	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 (125) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.792 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_6569a602befc05_24455543) /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_6569a602bd3370_12709354) /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_6569a602bcbdb4_91982382) /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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
476	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 (3272) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.760 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_6569a602befc05_24455543) /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_6569a602bd3370_12709354) /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_6569a602bcbdb4_91982382) /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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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` = 111 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.756 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)
388	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` = 264) AND (b.`id_shop` = 1) LIMIT 1	0.741 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)
363	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` = 4615 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` = 4615 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.733 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)
343	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps21_product` p INNER JOIN `ps21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 4138)	0.712 ms	1			/classes/Product.php:3857 /classes/Product.php:3714 (priceCalculation) /classes/Product.php:5664 (getPriceStatic) /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)
332	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM ps21_feature_product pf LEFT JOIN ps21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps21_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 3827 ORDER BY f.position ASC	0.703 ms	1	Yes		/classes/Product.php:5993 /classes/Product.php:5794 (getFrontFeaturesStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
497	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.693 ms	46	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /modules/jprestaspeedpack/classes/JprestaUtilsDispatcher.php:22 (__construct) /modules/jprestaspeedpack/classes/JprestaUtils.php:91 (getPageCacheInstance) /modules/jprestaspeedpack/classes/JprestaUtils.php:37 (parseLinks) /modules/jprestaspeedpack/jprestaspeedpack.php:4034 (parseLinks) /modules/jprestaspeedpack/jprestaspeedpack.php:1363 (cacheThis) /classes/Hook.php:1043 (hookActionOutputHTMLBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:721 (exec) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
355	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` = 4171 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` = 4171 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.688 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)
331	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` = 3827 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` = 3827 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.673 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)
477	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 (3316) 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_6569a602befc05_24455543) /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_6569a602bd3370_12709354) /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_6569a602bcbdb4_91982382) /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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
484	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 (4620) 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_6569a602befc05_24455543) /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_6569a602bd3370_12709354) /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_6569a602bcbdb4_91982382) /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_6569a602982236_65458918) /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_6569a602964fb3_03272248) /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_6569a60295fb66_28492498) /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_6569a60294d761_19433665) /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)
341	SELECT SQL_NO_CACHE image_shop.`id_image` 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) WHERE i.`id_product` = 4138 AND image_shop.`cover` = 1 LIMIT 1	0.655 ms	8			/classes/Product.php:3570 /classes/Product.php:5623 (getCover) /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)
442	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` = 4620) AND (b.`id_shop` = 1) LIMIT 1	0.653 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)
371	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` = 4620 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` = 4620 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.647 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)
20	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps21_meta` m LEFT JOIN `ps21_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.644 ms	46	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:39 (getInstance)

Tables et chaises