Load Time	1177 ms
Querying Time	643 ms
Queries	544
Memory Peak Usage	28.4 Mb
Included Files	1265 files - 11.89 Mb
PrestaShop Cache	- Mb
Global vars	0.19 Mb
- global $_MODULES	164k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k
- global $ignored_params	2k
- global $jprestaWebpConverterOptions	2k
- global $_MODULE	2k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	5.596 ms	5.596 ms	8.54 Mb	9.2 Mb
__construct	8.619 ms	14.215 ms	1.73 Mb	11.9 Mb
config	24.660 ms	38.875 ms	1.21 Mb	11.9 Mb
__construct	0.019 ms	38.894 ms	- Mb	11.9 Mb
init	29.064 ms	67.958 ms	2.29 Mb	14.8 Mb
checkAccess	0.001 ms	67.959 ms	- Mb	14.8 Mb
setMedia	2.226 ms	70.185 ms	0.26 Mb	14.8 Mb
postProcess	0.002 ms	70.187 ms	- Mb	14.8 Mb
initHeader	0.001 ms	70.188 ms	- Mb	14.8 Mb
initContent	730.228 ms	800 ms	7.83 Mb	22.8 Mb
initFooter	0.002 ms	800 ms	- Mb	22.8 Mb
display	376.209 ms	1177 ms	5.85 Mb	28.4 Mb

Hook	Time	Memory Usage
displayProductListReviews	57.582 ms	1.33 Mb
=> productcomments (widget)	18.022 ms	1.28 Mb
=> productcomments (widget)	1.522 ms	- Mb
=> productcomments (widget)	1.494 ms	- Mb
=> productcomments (widget)	1.451 ms	- Mb
=> productcomments (widget)	1.528 ms	- Mb
=> productcomments (widget)	1.493 ms	- Mb
=> productcomments (widget)	1.520 ms	- Mb
=> productcomments (widget)	1.452 ms	- Mb
=> productcomments (widget)	1.516 ms	- Mb
=> productcomments (widget)	1.543 ms	- Mb
=> productcomments (widget)	6.550 ms	- Mb
=> productcomments (widget)	1.471 ms	- Mb
=> productcomments (widget)	1.498 ms	- Mb
=> productcomments (widget)	1.584 ms	- Mb
=> productcomments (widget)	1.491 ms	- Mb
=> productcomments (widget)	1.436 ms	- Mb
=> productcomments (widget)	1.499 ms	- Mb
=> productcomments (widget)	1.516 ms	- Mb
=> productcomments (widget)	1.430 ms	- Mb
=> productcomments (widget)	1.531 ms	- Mb
=> productcomments (widget)	1.557 ms	- Mb
=> productcomments (widget)	1.531 ms	- Mb
=> productcomments (widget)	1.476 ms	- Mb
=> productcomments (widget)	1.470 ms	- Mb
ActionOutputHTMLBefore	37.066 ms	0.14 Mb
=> jprestaspeedpack	37.066 ms	0.14 Mb
ActionDispatcherBefore	36.056 ms	3.09 Mb
=> jprestaspeedpack	36.056 ms	3.09 Mb
displayLeftColumn	25.754 ms	0.74 Mb
=> ps_categorytree (widget)	25.754 ms	0.74 Mb
displayTop	16.845 ms	0.20 Mb
=> ps_searchbar (widget)	1.769 ms	0.05 Mb
=> ps_customersignin (widget)	3.668 ms	0.06 Mb
=> ps_shoppingcart (widget)	11.408 ms	0.09 Mb
DisplayBeforeBodyClosingTag	13.410 ms	0.27 Mb
=> statsdata	7.068 ms	0.25 Mb
=> ps_googleanalytics	6.342 ms	0.02 Mb
DisplayFooter	9.974 ms	0.11 Mb
=> zonethememanager	0.002 ms	- Mb
=> blockwishlist	9.972 ms	0.11 Mb
ActionDispatcher	9.005 ms	0.70 Mb
=> jprestaspeedpack	9.005 ms	0.70 Mb
displayFooterRight	3.172 ms	0.07 Mb
=> ps_emailsubscription (widget)	3.172 ms	0.07 Mb
DisplayHeader	2.359 ms	0.06 Mb
=> jprestaspeedpack	0.158 ms	- Mb
=> ps_shoppingcart	0.034 ms	- Mb
=> ps_searchbar	0.131 ms	- Mb
=> productcomments	0.076 ms	- Mb
=> ps_googleanalytics	0.020 ms	- Mb
=> zonecolorsfonts	0.837 ms	0.03 Mb
=> zonemegamenu	0.630 ms	0.01 Mb
=> zonethememanager	0.402 ms	0.01 Mb
=> prestastripe	0.008 ms	- Mb
=> prestaadvanceloyaltyprogram	0.063 ms	- Mb
DisplayLeftColumn	1.467 ms	0.02 Mb
=> ps_facetedsearch	1.072 ms	- Mb
=> zonecolumnblocks	0.395 ms	0.01 Mb
displayNav2	1.363 ms	0.08 Mb
=> ps_languageselector (widget)	0.881 ms	0.04 Mb
=> ps_currencyselector (widget)	0.482 ms	0.04 Mb
ActionFrontControllerSetVariables	1.089 ms	0.06 Mb
=> zonethememanager	1.089 ms	0.06 Mb
displayFooterLeft	0.751 ms	0.05 Mb
=> ps_socialfollow (widget)	0.751 ms	0.05 Mb
DisplayOutsideMainPage	0.662 ms	0.03 Mb
=> zonepopupnewsletter	0.225 ms	0.01 Mb
=> zonecolorsfonts	0.236 ms	0.01 Mb
=> zonethememanager	0.201 ms	0.01 Mb
ActionFrontControllerSetMedia	0.592 ms	0.01 Mb
=> blockreassurance	0.124 ms	- Mb
=> blockwishlist	0.190 ms	- Mb
=> ps_emailsubscription	0.043 ms	- Mb
=> ps_socialfollow	0.042 ms	- Mb
=> ps_emailalerts	0.043 ms	- Mb
=> prestaadvanceloyaltyprogram	0.150 ms	- Mb
DisplayNavFullWidth	0.397 ms	0.01 Mb
=> zonemegamenu	0.397 ms	0.01 Mb
DisplayFooterLeft	0.343 ms	0.01 Mb
=> zonethememanager	0.343 ms	0.01 Mb
DisplaySidebarNavigation	0.335 ms	- Mb
=> zonethememanager	0.335 ms	- Mb
DisplayBanner	0.331 ms	0.01 Mb
=> zonethememanager	0.331 ms	0.01 Mb
ProductSearchProvider	0.292 ms	- Mb
=> ps_facetedsearch	0.292 ms	- Mb
DisplayFooterAfter	0.282 ms	0.01 Mb
=> zonethememanager	0.282 ms	0.01 Mb
DisplayFooterRight	0.278 ms	0.01 Mb
=> zonethememanager	0.278 ms	0.01 Mb
DisplayNav1	0.211 ms	0.01 Mb
=> zonethememanager	0.211 ms	0.01 Mb
ActionObjectAddAfter	0.031 ms	- Mb
=> jprestaspeedpack	0.026 ms	- Mb
=> jprestaspeedpack	0.003 ms	- Mb
=> jprestaspeedpack	0.002 ms	- Mb
ModuleRoutes	0.018 ms	0.02 Mb
=> prestaadvanceloyaltyprogram	0.009 ms	0.01 Mb
=> prestaadvanceloyaltyprogram	0.009 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.014 ms	- Mb
=> blockreassurance	0.014 ms	- Mb
ActionFrontControllerInitAfter	0.011 ms	- Mb
=> prestaadvanceloyaltyprogram	0.011 ms	- Mb
DisplayFooterBefore	0.008 ms	- Mb
=> blockreassurance	0.008 ms	- Mb
29 hook(s)	219.697 ms	7.06 Mb

Module	Time	Memory Usage
prestaadvanceloyaltyprogram	4.687 ms	0.54 Mb
__construct	4.431 ms	0.51 Mb
hookModuleRoutes	0.013 ms	0.01 Mb
hookActionFrontControllerInitAfter	0.014 ms	- Mb
hookActionFrontControllerSetMedia	0.152 ms	- Mb
hookDisplayHeader	0.064 ms	- Mb
hookModuleRoutes	0.013 ms	0.01 Mb
jprestaspeedpack	83.305 ms	4.00 Mb
__construct	0.968 ms	0.06 Mb
hookActionDispatcherBefore	36.061 ms	3.09 Mb
hookActionDispatcher	9.008 ms	0.70 Mb
hookDisplayHeader	0.160 ms	- Mb
hookActionObjectAddAfter	0.028 ms	- Mb
hookActionObjectAddAfter	0.005 ms	- Mb
hookActionObjectAddAfter	0.005 ms	- Mb
hookActionOutputHTMLBefore	37.070 ms	0.14 Mb
blockreassurance	0.873 ms	0.09 Mb
__construct	0.713 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.127 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.021 ms	- Mb
hookDisplayFooterBefore	0.012 ms	- Mb
blockwishlist	10.252 ms	0.13 Mb
__construct	0.086 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.192 ms	- Mb
hookDisplayFooter	9.974 ms	0.11 Mb
ps_emailsubscription	3.367 ms	0.10 Mb
__construct	0.149 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.044 ms	- Mb
displayFooterRight	3.174 ms	0.07 Mb
ps_socialfollow	0.877 ms	0.07 Mb
__construct	0.079 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.044 ms	- Mb
displayFooterLeft	0.754 ms	0.06 Mb
ps_emailalerts	0.208 ms	0.09 Mb
__construct	0.163 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.045 ms	- Mb
zonethememanager	13.321 ms	1.30 Mb
__construct	9.823 ms	1.15 Mb
hookActionFrontControllerSetVariables	1.092 ms	0.06 Mb
hookDisplayHeader	0.404 ms	0.01 Mb
hookDisplaySidebarNavigation	0.338 ms	- Mb
hookDisplayBanner	0.335 ms	0.01 Mb
hookDisplayNav1	0.213 ms	0.01 Mb
hookDisplayFooterLeft	0.345 ms	0.01 Mb
hookDisplayFooterRight	0.280 ms	0.02 Mb
hookDisplayFooter	0.003 ms	- Mb
hookDisplayFooterAfter	0.285 ms	0.01 Mb
hookDisplayOutsideMainPage	0.203 ms	0.01 Mb
ps_shoppingcart	11.550 ms	0.11 Mb
__construct	0.101 ms	0.02 Mb
hookDisplayHeader	0.036 ms	- Mb
displayTop	11.413 ms	0.09 Mb
ps_searchbar	2.002 ms	0.14 Mb
__construct	0.097 ms	0.08 Mb
hookDisplayHeader	0.133 ms	- Mb
displayTop	1.772 ms	0.05 Mb
productcomments	57.836 ms	1.37 Mb
__construct	0.116 ms	0.03 Mb
hookDisplayHeader	0.078 ms	- Mb
displayProductListReviews	18.027 ms	1.28 Mb
displayProductListReviews	1.525 ms	- Mb
displayProductListReviews	1.496 ms	- Mb
displayProductListReviews	1.453 ms	- Mb
displayProductListReviews	1.531 ms	- Mb
displayProductListReviews	1.495 ms	- Mb
displayProductListReviews	1.523 ms	- Mb
displayProductListReviews	1.455 ms	- Mb
displayProductListReviews	1.519 ms	- Mb
displayProductListReviews	1.545 ms	- Mb
displayProductListReviews	6.552 ms	- Mb
displayProductListReviews	1.474 ms	- Mb
displayProductListReviews	1.500 ms	- Mb
displayProductListReviews	1.586 ms	- Mb
displayProductListReviews	1.493 ms	- Mb
displayProductListReviews	1.438 ms	- Mb
displayProductListReviews	1.502 ms	- Mb
displayProductListReviews	1.519 ms	- Mb
displayProductListReviews	1.432 ms	- Mb
displayProductListReviews	1.534 ms	- Mb
displayProductListReviews	1.559 ms	- Mb
displayProductListReviews	1.533 ms	- Mb
displayProductListReviews	1.479 ms	- Mb
displayProductListReviews	1.472 ms	- Mb
ps_googleanalytics	6.450 ms	0.05 Mb
__construct	0.084 ms	0.03 Mb
hookDisplayHeader	0.021 ms	- Mb
hookDisplayBeforeBodyClosingTag	6.345 ms	0.02 Mb
zonecolorsfonts	1.270 ms	0.06 Mb
__construct	0.193 ms	0.02 Mb
hookDisplayHeader	0.839 ms	0.03 Mb
hookDisplayOutsideMainPage	0.238 ms	0.01 Mb
zonemegamenu	1.237 ms	0.06 Mb
__construct	0.205 ms	0.03 Mb
hookDisplayHeader	0.632 ms	0.01 Mb
hookDisplayNavFullWidth	0.400 ms	0.01 Mb
prestastripe	0.789 ms	0.02 Mb
__construct	0.779 ms	0.02 Mb
hookDisplayHeader	0.010 ms	- Mb
ps_facetedsearch	1.876 ms	0.10 Mb
__construct	0.506 ms	0.10 Mb
hookProductSearchProvider	0.295 ms	- Mb
hookDisplayLeftColumn	1.075 ms	- Mb
ps_languageselector	1.045 ms	0.06 Mb
__construct	0.160 ms	0.02 Mb
displayNav2	0.885 ms	0.04 Mb
ps_currencyselector	0.597 ms	0.06 Mb
__construct	0.113 ms	0.02 Mb
displayNav2	0.484 ms	0.04 Mb
ps_customersignin	3.757 ms	0.08 Mb
__construct	0.086 ms	0.02 Mb
displayTop	3.671 ms	0.06 Mb
ps_categorytree	25.899 ms	0.75 Mb
__construct	0.140 ms	0.02 Mb
displayLeftColumn	25.759 ms	0.74 Mb
zonecolumnblocks	0.694 ms	0.11 Mb
__construct	0.297 ms	0.09 Mb
hookDisplayLeftColumn	0.397 ms	0.01 Mb
zonepopupnewsletter	0.440 ms	0.03 Mb
__construct	0.213 ms	0.02 Mb
hookDisplayOutsideMainPage	0.227 ms	0.01 Mb
statsdata	7.172 ms	0.27 Mb
__construct	0.102 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	7.070 ms	0.25 Mb
23 module(s)	239.504 ms	9.59 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
179	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>=154 AND c.nright<=181 GROUP BY p.id_product) p	233.174 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)
178	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>=154 AND c.nright<=181 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	229.970 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)
542	INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (942,803264849),(942,3544422162),(942,1289214159),(942,1785617407),(942,2936477779),(942,1727466530),(942,1432532875),(942,1025009294),(942,1804081323),(942,3479716883),(942,66301815),(942,537553573),(942,3045727500),(942,3231073010),(942,1825096520),(942,3225262556),(942,2645763144),(942,2027619899),(942,786864081),(942,1849360992),(942,294428854),(942,3774376179),(942,2880678980),(942,114155291),(942,2929321318),(942,2087307803),(942,2369020978),(942,1152186767),(942,4222788516),(942,2858566420),(942,848840972),(942,4147554351),(942,770698498),(942,2244011448),(942,477004582),(942,3610318732),(942,1070190107),(942,937307692),(942,25761885),(942,3366890060),(942,3483396593),(942,392306519),(942,909258745),(942,179865882),(942,3099645137),(942,3371246540),(942,2390640699),(942,501027234),(942,3032495894),(942,2100541971),(942,2793494280),(942,180908336),(942,1192985740),(942,1972034646),(942,2419117650),(942,3803768817),(942,4265874642),(942,67723771),(942,3423129237),(942,3399895114),(942,3221089548),(942,2990154896),(942,2728213885),(942,933991437),(942,2513627470),(942,468067826),(942,4137721533),(942,1552016987),(942,4080301755),(942,4245349388),(942,1973472416),(942,1839057912),(942,3745041382),(942,3035734567),(942,3719469943),(942,3466131047),(942,679558129),(942,462819688),(942,4267553191),(942,518809702),(942,3303811122),(942,2883778317),(942,1694893476),(942,3287268691),(942,3711637102),(942,698879415),(942,885817714),(942,125306139),(942,1634619674),(942,58280175),(942,3363778289),(942,1161663254),(942,201135304),(942,288600709),(942,1021330335),(942,2858809635),(942,2763627026),(942,3717400459),(942,4125370705),(942,3997906175),(942,4162316513),(942,3219397995),(942,2539165674),(942,1046234598),(942,787652129),(942,1595426297),(942,4184932827),(942,1985552396),(942,1944795689),(942,3799916950),(942,1827123668),(942,1447744642),(942,1636796806),(942,2645405926),(942,1474595477),(942,3375525138),(942,3902077767),(942,3507415422),(942,2781072282),(942,2002273313),(942,3164880625),(942,2490789905),(942,1000843653),(942,48947005),(942,3883347157),(942,3700474777),(942,4264269047),(942,2125390191),(942,4270481046),(942,1693150473),(942,343450730),(942,381351735),(942,2863449446),(942,3772294966),(942,3877457961),(942,1492116830),(942,4041511410),(942,828132466),(942,4090211224),(942,2185737194),(942,3517149926),(942,647687838),(942,733479784),(942,1440916471),(942,3262261204),(942,1872100372),(942,2092461357),(942,3357609169),(942,2365529006),(942,1263061406),(942,2296732656),(942,534196217),(942,482025419),(942,2811467352),(942,2488480532),(942,3501473861),(942,1917272649),(942,1878317490),(942,1789511633),(942,956713705),(942,89981727),(942,1143557322),(942,2749361789),(942,3857194488),(942,1024086260),(942,26040876),(942,1804243295),(942,2165251395),(942,1281618245),(942,2793993627),(942,426054238),(942,3398682121),(942,1025101115),(942,2974984653),(942,2214325187),(942,997821910),(942,2005463392),(942,3252396061),(942,942332382),(942,3816934055),(942,1661692647),(942,975758589),(942,3974931321),(942,2301364099),(942,855746680),(942,637832447),(942,3938675492),(942,508940865),(942,911480697),(942,1283363269),(942,3552869238),(942,2961923901),(942,3747234531),(942,3155646160),(942,3164668199),(942,2271068282),(942,84354396),(942,2915068863),(942,4064530110),(942,3216991891),(942,2045363644),(942,2664176477),(942,1076722390),(942,505410826),(942,2506779464),(942,2552384108),(942,876907216),(942,82980331),(942,3890150098),(942,3475437886),(942,2302280848),(942,1133144647),(942,801167173),(942,2059315716),(942,3139619822),(942,2937007520),(942,1589371182),(942,693370988),(942,2708427394),(942,1007456900),(942,610735313),(942,3846627131),(942,2031830639),(942,1908602231),(942,1401333655),(942,378101424),(942,996218346),(942,660881695),(942,2938384267),(942,4250264855),(942,1895305721),(942,502965417),(942,1982471117),(942,2524144246),(942,2774996218),(942,1068709096),(942,4077513867),(942,2900588200),(942,465472731),(942,4139839450),(942,2360011682),(942,4211248848),(942,283341417),(942,4165214622),(942,3508523596),(942,234404923),(942,2782693783),(942,3413880379),(942,3540168379),(942,861653603),(942,3160995915),(942,1391251310),(942,2106651858),(942,3572623339),(942,4629984),(942,2488722736),(942,3486510944),(942,2675016634),(942,2165907305),(942,136687257),(942,3540179561),(942,2792526429),(942,2220600372),(942,2914585448),(942,3882733113),(942,1688090355),(942,3534950496),(942,1182870252),(942,412601709),(942,574969182),(942,2970413814),(942,1487282505),(942,3228977345),(942,2023459642),(942,3291711134),(942,2792891444),(942,3335276918),(942,502111155),(942,1347492703),(942,2832080533),(942,1215320197),(942,2317239205),(942,1931846913),(942,1721014625),(942,738600257),(942,2998338424),(942,1207945902),(942,734241479),(942,3324570843),(942,4126771257),(942,1712456575),(942,3169253733),(942,1160958045),(942,1130949510),(942,3116084871),(942,269178051),(942,24773614),(942,3204450510),(942,3468662336),(942,1808444077),(942,4095410992),(942,1012520131),(942,2367920745),(942,2603361072),(942,2741539031),(942,607507456),(942,616165826),(942,2288576869),(942,4252798532),(942,2692385638),(942,4100315394),(942,3061254709),(942,1657292258),(942,2148967437),(942,1248236410),(942,2457219175),(942,1920985790),(942,1340703149),(942,1618471777),(942,4160689201),(942,1822364967),(942,479188821),(942,1661785323),(942,4137484009),(942,2636427258),(942,1499247737),(942,2061922205),(942,665830591),(942,916194615),(942,495595719),(942,3026469794),(942,1845449656),(942,4078122428),(942,2044505385),(942,3156749269),(942,3919036276),(942,204613135),(942,605377709),(942,766051911),(942,30400764),(942,4211022030),(942,715827285),(942,1092948871),(942,610201349),(942,1023110113),(942,3379323545),(942,2591028766),(942,1994095466),(942,33157726),(942,198243957),(942,94201498),(942,2540831776),(942,1707019604),(942,2730046909),(942,4101073252),(942,207761914),(942,2750534087),(942,980926717),(942,377071036),(942,2983490672),(942,584353846),(942,1743688562),(942,3223058413),(942,1665991311),(942,3093731065),(942,1095877807),(942,1085889875),(942,2059985562),(942,3618062925),(942,592374860),(942,4217863027),(942,3425247989),(942,1636391408),(942,1698766782),(942,2162739858),(942,1538367880),(942,3760626336),(942,1987713032),(942,2338874856),(942,4206689645),(942,1723372602),(942,2788329276),(942,2095305502),(942,3135330775),(942,2402748468),(942,24058172),(942,4000683245),(942,315670382),(942,2558276906),(942,1745365471),(942,2782569384),(942,3422117706),(942,552626444),(942,1506232339),(942,2933163456),(942,1483801350),(942,1400586123),(942,3746875726),(942,2604810181),(942,2905930158),(942,803588046),(942,1651400661),(942,1431243585),(942,1586185269),(942,4110009762),(942,3647374073),(942,4196158832),(942,644435096),(942,1862966990),(942,2098775956),(942,4045847707),(942,3122054119),(942,1971194991),(942,2149367276),(942,1888540635),(942,2660577125),(942,2508340497),(942,196341346),(942,1790101800),(942,1054130805),(942,2741947598),(942,1292400575),(942,545037028),(942,1516477184),(942,2706799993),(942,562470873),(942,2591346466),(942,613023703),(942,2725609989),(942,2082081559),(942,572560232),(942,2833489058),(942,1999611979),(942,1938789650),(942,2958717166),(942,1035708154),(942,2025067287),(942,3804047398),(942,248028803),(942,4243412966),(942,628124381),(942,1271215494),(942,2140466223),(942,1298495884),(942,3585931255),(942,532975694),(942,892763084),(942,203145038),(942,470924714),(942,1460516495),(942,2732318442),(942,3996868778),(942,862206445),(942,3193479021),(942,3382171736),(942,3362897893),(942,3598913121),(942,1342337107),(942,3202829344),(942,1335223071),(942,270790954),(942,1086966479),(942,484642328),(942,4274468042),(942,1740107684),(942,2117688527),(942,1393082718),(942,366510022),(942,341328174),(942,1469264429),(942,968691010),(942,3210232788),(942,809700252),(942,3705477223),(942,1639200307),(942,3585776886),(942,3305319229),(942,1052899681),(942,2176267881),(942,357387863),(942,451177334),(942,677589039),(942,1181390953),(942,898241702),(942,3480303789),(942,1736215096),(942,2511740146),(942,2560762429),(942,1570623991),(942,897080848),(942,891021207),(942,2807843172),(942,411231410),(942,2413680770),(942,519468981),(942,1898829954),(942,4274422817),(942,2781196321),(942,433695516),(942,1652336127),(942,4200438598),(942,3032893805),(942,1435170492),(942,341146430),(942,755973553),(942,2183774725),(942,3967614532),(942,1589097164),(942,2441764320),(942,745126750),(942,348450311),(942,2084175962),(942,3357611772),(942,1654631620),(942,3098454302),(942,2029227635),(942,1731761366),(942,2444253995),(942,2906032508),(942,872274856),(942,4282856364),(942,3328013593),(942,4184469063),(942,1074477927),(942,475878802),(942,1341972790),(942,2770374005),(942,4237489391),(942,2818813526),(942,3131100007),(942,4267621199),(942,1031922959),(942,1616292706),(942,630426110),(942,1846388513),(942,2239793094),(942,1660370824),(942,3321716633),(942,2551727033),(942,1836172154),(942,1870881122),(942,3324207484),(942,1065867023),(942,1459310880),(942,1395112921),(942,893552556),(942,1795813847),(942,2544364435),(942,4188602229),(942,1437064809),(942,922605498),(942,4180843510),(942,2554784265),(942,3798404205),(942,1216801552),(942,225525148),(942,274058040),(942,3206796234),(942,610255635),(942,3139895407),(942,3993594441),(942,2078652070),(942,3340749058),(942,2282248923),(942,3201099700),(942,3944887276),(942,887478137),(942,620965629),(942,53639561),(942,687854272),(942,4204526813),(942,3434636086),(942,3859247582),(942,2160451939),(942,419013317),(942,488655959),(942,2224381764),(942,857621694),(942,593880699),(942,1743569168),(942,747100668),(942,2627272664),(942,1477316791),(942,852002855),(942,3813191394),(942,3206482767),(942,2935275735),(942,825997452),(942,4128572079),(942,4149399208),(942,2432005645),(942,945310979),(942,206553734),(942,3381625344),(942,2613891474),(942,1285565060),(942,725086502),(942,2181279565),(942,2136294074),(942,531227063),(942,3291030245),(942,3423892574),(942,1818418110),(942,1175554195),(942,231365613),(942,3071984169),(942,1510809703),(942,2304894647),(942,724387218),(942,3702122266),(942,3105745802),(942,3598888791),(942,40599425),(942,4256434691),(942,1198380170),(942,3549401556),(942,2300237909),(942,484124464),(942,3042798728),(942,767973032),(942,4146324303),(942,1493350341),(942,2166736334),(942,3061340275),(942,1468811388),(942,714571165),(942,1958965990),(942,2146366302),(942,2212338847),(942,2088651590),(942,2684538463),(942,2292708505),(942,571001464),(942,608126571),(942,2736309071),(942,1479333754),(942,1794660366),(942,2319975337),(942,1093438481),(942,2975864804),(942,2504416172),(942,3531750290),(942,219666672),(942,4219072870),(942,1053258155),(942,2382983142),(942,1006288562),(942,1770263986),(942,3089735283),(942,3689334927),(942,2901629603),(942,2019277020),(942,2853333944),(942,1110695191),(942,3884283185),(942,4268093708),(942,159799075),(942,1715997742),(942,1009155269),(942,3922001006),(942,3916338789),(942,1085252167),(942,207705430),(942,1190601026),(942,1441004396),(942,1567147586),(942,964098054),(942,1385174189),(942,3607427007),(942,4065177061),(942,1552830538),(942,3778287701),(942,3986294473),(942,4127238085),(942,1865170325),(942,2161789419),(942,2889615117),(942,785261358),(942,3873733217),(942,2600209543),(942,3958092558),(942,4143434528),(942,3225228598),(942,3451063310),(942,810085901),(942,1502204888),(942,2931931582),(942,1339720903),(942,4093703382),(942,1016897830),(942,1186809094),(942,2269117600),(942,813555736),(942,733475850),(942,305814753),(942,2720553993),(942,212227262),(942,1328958432),(942,3903742053),(942,2617942920),(942,4254367326),(942,2895836413),(942,1090341105),(942,3174277595),(942,639084285),(942,4064195579),(942,2134315289),(942,608843276),(942,4190247440),(942,1090444753),(942,2554275840),(942,2758076506),(942,2518001916),(942,3620157415),(942,1195920681),(942,1822840633),(942,1087551238),(942,235508323),(942,1139244570),(942,810960133),(942,425550269),(942,1767940144),(942,1488780247),(942,1250541405),(942,1715845038),(942,3777612587),(942,2285237154),(942,802817926),(942,4280998710),(942,1108258121),(942,1107026853),(942,2913745362),(942,1129101120),(942,2454813183),(942,1690919006),(942,23973636),(942,293370743),(942,1041759778),(942,3142497267),(942,2920365983),(942,2300359472),(942,885232682),(942,1995817456),(942,3443377157),(942,863919144),(942,1324348692),(942,4019216150),(942,443752815),(942,4223293),(942,1182491637),(942,4257294915),(942,3629776934),(942,582958316),(942,3061655453),(942,1665355533),(942,1929899841),(942,1033949851),(942,2010879266),(942,1872304779),(942,1282102725),(942,3589651214),(942,4095654001),(942,2447713556),(942,2543494532),(942,2069898435),(942,3286503857),(942,2662939963),(942,93111834),(942,3160936308),(942,261262800),(942,141197408),(942,1904512268),(942,3001025754),(942,2247670246),(942,535154833),(942,3476002757),(942,3806439314),(942,1819793014),(942,3545273473),(942,3957652542),(942,3018295592),(942,1367893712),(942,1034338066),(942,3229510223),(942,4276953245),(942,3363858574),(942,2870596766),(942,648526699),(942,3627085975),(942,1585047995),(942,1960922033),(942,748737253),(942,1175066615),(942,1318322018),(942,260367662),(942,643741484),(942,1013706048),(942,1726352130),(942,2222354404),(942,1327031463),(942,1131865044),(942,839200087),(942,1407668396),(942,3548333318),(942,237845721),(942,3056051791),(942,747235328),(942,172675174),(942,2781705803),(942,2111348799),(942,3067187587),(942,618638032),(942,3369756381),(942,2232055662),(942,55113216),(942,3939915090),(942,2586983921),(942,3286008345),(942,1956055310),(942,740042513),(942,2282536358),(942,1863122946),(942,1296880981),(942,2589434346),(942,1621393368),(942,39250009),(942,72263924),(942,1587391050),(942,847186998),(942,2455499024),(942,859347884),(942,2244795234),(942,64890532),(942,2083009897),(942,881985288),(942,1020829472),(942,1698996054),(942,4185556067),(942,528680816),(942,2176544959),(942,2974940077),(942,165848561),(942,3609898364),(942,2565974659),(942,2086128323),(942,540000247),(942,68003141),(942,1618729518),(942,2966443067),(942,3625832962),(942,3456374186),(942,287364972),(942,4240439720),(942,564522115),(942,393999121),(942,3760410825),(942,3283719785),(942,3924888977),(942,1697117306),(942,3406763364),(942,1129505049) ON DUPLICATE KEY UPDATE id=id	9.101 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)
494	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.847 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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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`)	3.069 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)
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.304 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /modules/jprestaspeedpack/classes/JprestaUtilsTaxManager.php:109 (getManager) /modules/jprestaspeedpack/jprestaspeedpack.php:1578 (toJson) /modules/jprestaspeedpack/jprestaspeedpack.php:2599 (getTaxManagerDetails) /modules/jprestaspeedpack/jprestaspeedpack.php:2351 (getCacheKeyInfos) /modules/jprestaspeedpack/jprestaspeedpack.php:1401 (displayCacheIfExists) /classes/Hook.php:1043 (hookActionDispatcherBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/Dispatcher.php:351 (exec) /index.php:39 (dispatch)
15	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps21_module` m INNER JOIN ps21_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps21_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps21_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps21_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	2.103 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)
530	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')	2.024 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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
52	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.959 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)
119	UPDATE `ps21_jm_pagecache_contexts` SET count_bot=count_bot+1 WHERE id=1;	1.866 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)
181	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 (90280,3543,2367,2119,1951,899,780,107,49,92087,55080,12972,4667,3553,3238,2973,1465,783,50,92091,12984,10681,5119,3736)	1.783 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)
543	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.634 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)
534	INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('920156', '538', '751134203', '', '1', '1', '2023-12-01 11:52:36')	1.481 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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
539	INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 1368053932, 'https://cadeaufou.com/62-linge-de-maison', 1, 2, 1, 62, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0;	1.321 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)
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` = 62 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.112 ms	13	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)
535	INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('917865', '', 'cadeaufou.com/62-linge-de-maison', '', '2023-12-01 11:52:36')	1.099 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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1)	1.011 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)
210	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` = 3543 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` = 3543 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.806 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)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook`	0.800 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)
436	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` = 92087) AND (b.`id_shop` = 1) LIMIT 1	0.791 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)
412	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` = 3543) AND (b.`id_shop` = 1) LIMIT 1	0.762 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)
211	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 = 3543 ORDER BY f.position ASC	0.736 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)
505	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 (2119) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.688 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_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
503	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 (3543) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.682 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_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
495	SELECT SQL_NO_CACHE * FROM `ps21_product` a LEFT JOIN `ps21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 90280) LIMIT 1	0.673 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/Presenter/Product/ProductLazyArray.php:661 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:504 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/prod/smarty/compile/ZOneThemelayouts_layout_left_column_tpl/a3/b1/85/a3b185d6b524f0e1ea4573ed6b41c55f52eb734f_2.file.product-flags.tpl.php:46 (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/a3/b1/85/a3b185d6b524f0e1ea4573ed6b41c55f52eb734f_2.file.product-flags.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6569baf4888724_90296657) /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/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:235 (_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/cf/95/35/cf95354376b96a997c80508a844397324a757387_2.file.product.tpl.php:35 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
199	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `ps21_attribute` a LEFT JOIN `ps21_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps21_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps21_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps21_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps21_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `ps21_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 90280 AND pac.`id_product_attribute` = 13325 AND agl.`id_lang` = 1	0.655 ms	1			/classes/Product.php:7506 /classes/Product.php:5827 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
427	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` = 780) AND (b.`id_shop` = 1) LIMIT 1	0.648 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)
469	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` = 12984) AND (b.`id_shop` = 1) LIMIT 1	0.643 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)
507	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 (899) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.639 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_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
454	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` = 2973) AND (b.`id_shop` = 1) LIMIT 1	0.637 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)
374	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` = 92091 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` = 92091 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.625 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)
194	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` = 90280 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` = 90280 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.619 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)
519	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 (783) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.618 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_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
500	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 (90280) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.617 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_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
457	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` = 1465) AND (b.`id_shop` = 1) LIMIT 1	0.610 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)
538	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.604 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)
437	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps21_image` i INNER JOIN ps21_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 92087 ORDER BY `position`	0.600 ms	4	Yes		/classes/Product.php:3545 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
430	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` = 107) AND (b.`id_shop` = 1) LIMIT 1	0.588 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)
521	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 (92091) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.586 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_6569baf4864430_82840616) /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_6569baf4849287_22065984) /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_6569baf4842622_21979031) /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_6569baf45b87c4_40333489) /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_6569baf45972f2_49360628) /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_6569baf4590c42_71948584) /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_6569baf457c791_66495449) /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)
366	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` = 50 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` = 50 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.580 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)

Linge de Maison

Sous-catégories