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

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	6.167 ms	6.167 ms	8.54 Mb	9.2 Mb
__construct	9.449 ms	15.616 ms	1.73 Mb	11.9 Mb
config	29.393 ms	45.009 ms	1.21 Mb	11.9 Mb
__construct	0.023 ms	45.032 ms	- Mb	11.9 Mb
init	31.909 ms	76.941 ms	2.13 Mb	14.8 Mb
checkAccess	0.002 ms	76.943 ms	- Mb	14.8 Mb
setMedia	2.718 ms	79.661 ms	0.26 Mb	14.8 Mb
postProcess	0.002 ms	79.663 ms	- Mb	14.8 Mb
initHeader	0.001 ms	79.664 ms	- Mb	14.8 Mb
initContent	591.833 ms	671.497 ms	7.71 Mb	22.5 Mb
initFooter	0.003 ms	671.500 ms	- Mb	22.5 Mb
display	405.786 ms	1077 ms	5.60 Mb	27.9 Mb

Hook	Time	Memory Usage
displayProductListReviews	60.114 ms	1.33 Mb
=> productcomments (widget)	20.803 ms	1.28 Mb
=> productcomments (widget)	1.959 ms	- Mb
=> productcomments (widget)	1.708 ms	- Mb
=> productcomments (widget)	1.642 ms	- Mb
=> productcomments (widget)	1.985 ms	- Mb
=> productcomments (widget)	2.221 ms	- Mb
=> productcomments (widget)	1.775 ms	- Mb
=> productcomments (widget)	1.732 ms	- Mb
=> productcomments (widget)	1.664 ms	- Mb
=> productcomments (widget)	1.646 ms	- Mb
=> productcomments (widget)	1.539 ms	- Mb
=> productcomments (widget)	1.617 ms	- Mb
=> productcomments (widget)	1.581 ms	- Mb
=> productcomments (widget)	1.645 ms	- Mb
=> productcomments (widget)	1.707 ms	- Mb
=> productcomments (widget)	1.742 ms	- Mb
=> productcomments (widget)	1.608 ms	- Mb
=> productcomments (widget)	1.565 ms	- Mb
=> productcomments (widget)	1.535 ms	- Mb
=> productcomments (widget)	1.649 ms	- Mb
=> productcomments (widget)	1.640 ms	- Mb
=> productcomments (widget)	1.730 ms	- Mb
=> productcomments (widget)	1.699 ms	- Mb
=> productcomments (widget)	1.723 ms	- Mb
ActionOutputHTMLBefore	44.985 ms	0.14 Mb
=> jprestaspeedpack	44.985 ms	0.14 Mb
ActionDispatcherBefore	42.167 ms	3.09 Mb
=> jprestaspeedpack	42.167 ms	3.09 Mb
displayLeftColumn	27.951 ms	0.74 Mb
=> ps_categorytree (widget)	27.951 ms	0.74 Mb
displayTop	17.602 ms	0.20 Mb
=> ps_searchbar (widget)	1.880 ms	0.05 Mb
=> ps_customersignin (widget)	3.890 ms	0.06 Mb
=> ps_shoppingcart (widget)	11.832 ms	0.09 Mb
DisplayBeforeBodyClosingTag	15.540 ms	0.27 Mb
=> statsdata	7.768 ms	0.25 Mb
=> ps_googleanalytics	7.772 ms	0.02 Mb
DisplayFooter	12.956 ms	0.11 Mb
=> zonethememanager	0.002 ms	- Mb
=> blockwishlist	12.954 ms	0.11 Mb
ActionDispatcher	10.831 ms	0.70 Mb
=> jprestaspeedpack	10.831 ms	0.70 Mb
displayFooterRight	4.933 ms	0.07 Mb
=> ps_emailsubscription (widget)	4.933 ms	0.07 Mb
DisplayHeader	3.953 ms	0.06 Mb
=> jprestaspeedpack	0.161 ms	- Mb
=> ps_shoppingcart	0.040 ms	- Mb
=> ps_searchbar	0.163 ms	- Mb
=> productcomments	0.089 ms	- Mb
=> ps_googleanalytics	0.025 ms	- Mb
=> zonecolorsfonts	0.998 ms	0.03 Mb
=> zonemegamenu	1.915 ms	0.01 Mb
=> zonethememanager	0.456 ms	0.01 Mb
=> prestastripe	0.014 ms	- Mb
=> prestaadvanceloyaltyprogram	0.091 ms	- Mb
ActionFrontControllerSetVariables	1.752 ms	0.06 Mb
=> zonethememanager	1.752 ms	0.06 Mb
DisplayLeftColumn	1.638 ms	0.02 Mb
=> ps_facetedsearch	1.273 ms	- Mb
=> zonecolumnblocks	0.365 ms	0.01 Mb
displayFooterLeft	1.072 ms	0.06 Mb
=> ps_socialfollow (widget)	1.072 ms	0.06 Mb
displayNav2	1.037 ms	0.08 Mb
=> ps_languageselector (widget)	0.638 ms	0.04 Mb
=> ps_currencyselector (widget)	0.399 ms	0.04 Mb
DisplayOutsideMainPage	0.810 ms	0.03 Mb
=> zonepopupnewsletter	0.274 ms	0.01 Mb
=> zonecolorsfonts	0.291 ms	0.01 Mb
=> zonethememanager	0.245 ms	0.01 Mb
ActionFrontControllerSetMedia	0.688 ms	0.01 Mb
=> blockreassurance	0.128 ms	- Mb
=> blockwishlist	0.223 ms	- Mb
=> ps_emailsubscription	0.048 ms	- Mb
=> ps_socialfollow	0.048 ms	- Mb
=> ps_emailalerts	0.054 ms	- Mb
=> prestaadvanceloyaltyprogram	0.187 ms	- Mb
DisplayFooterRight	0.591 ms	0.01 Mb
=> zonethememanager	0.591 ms	0.01 Mb
DisplayFooterAfter	0.416 ms	0.01 Mb
=> zonethememanager	0.416 ms	0.01 Mb
DisplayFooterLeft	0.375 ms	0.01 Mb
=> zonethememanager	0.375 ms	0.01 Mb
DisplayNavFullWidth	0.343 ms	0.01 Mb
=> zonemegamenu	0.343 ms	0.01 Mb
DisplayBanner	0.341 ms	0.01 Mb
=> zonethememanager	0.341 ms	0.01 Mb
DisplaySidebarNavigation	0.323 ms	- Mb
=> zonethememanager	0.323 ms	- Mb
DisplayNav1	0.270 ms	0.01 Mb
=> zonethememanager	0.270 ms	0.01 Mb
ProductSearchProvider	0.270 ms	- Mb
=> ps_facetedsearch	0.270 ms	- Mb
ActionObjectAddAfter	0.048 ms	- Mb
=> jprestaspeedpack	0.040 ms	- Mb
=> jprestaspeedpack	0.005 ms	- Mb
=> jprestaspeedpack	0.003 ms	- Mb
ModuleRoutes	0.025 ms	0.02 Mb
=> prestaadvanceloyaltyprogram	0.010 ms	0.01 Mb
=> prestaadvanceloyaltyprogram	0.015 ms	0.01 Mb
ActionFrontControllerInitAfter	0.021 ms	- Mb
=> prestaadvanceloyaltyprogram	0.021 ms	- Mb
DisplayFooterBefore	0.014 ms	- Mb
=> blockreassurance	0.014 ms	- Mb
DisplayAfterBodyOpeningTag	0.014 ms	- Mb
=> blockreassurance	0.014 ms	- Mb
29 hook(s)	251.080 ms	7.07 Mb

Module	Time	Memory Usage
prestaadvanceloyaltyprogram	5.368 ms	0.54 Mb
__construct	5.025 ms	0.51 Mb
hookModuleRoutes	0.016 ms	0.01 Mb
hookActionFrontControllerInitAfter	0.026 ms	- Mb
hookActionFrontControllerSetMedia	0.189 ms	- Mb
hookDisplayHeader	0.092 ms	- Mb
hookModuleRoutes	0.020 ms	0.01 Mb
jprestaspeedpack	99.220 ms	4.00 Mb
__construct	0.998 ms	0.06 Mb
hookActionDispatcherBefore	42.171 ms	3.09 Mb
hookActionDispatcher	10.837 ms	0.70 Mb
hookDisplayHeader	0.163 ms	- Mb
hookActionObjectAddAfter	0.045 ms	- Mb
hookActionObjectAddAfter	0.008 ms	- Mb
hookActionObjectAddAfter	0.006 ms	- Mb
hookActionOutputHTMLBefore	44.992 ms	0.14 Mb
blockreassurance	1.196 ms	0.09 Mb
__construct	1.026 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.130 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.021 ms	- Mb
hookDisplayFooterBefore	0.019 ms	- Mb
blockwishlist	13.309 ms	0.13 Mb
__construct	0.103 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.247 ms	- Mb
hookDisplayFooter	12.959 ms	0.11 Mb
ps_emailsubscription	5.115 ms	0.10 Mb
__construct	0.125 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.050 ms	- Mb
displayFooterRight	4.940 ms	0.07 Mb
ps_socialfollow	1.226 ms	0.07 Mb
__construct	0.101 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.049 ms	- Mb
displayFooterLeft	1.076 ms	0.06 Mb
ps_emailalerts	0.190 ms	0.09 Mb
__construct	0.134 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.056 ms	- Mb
zonethememanager	16.058 ms	1.30 Mb
__construct	11.255 ms	1.15 Mb
hookActionFrontControllerSetVariables	1.757 ms	0.06 Mb
hookDisplayHeader	0.459 ms	0.01 Mb
hookDisplaySidebarNavigation	0.326 ms	- Mb
hookDisplayBanner	0.345 ms	0.01 Mb
hookDisplayNav1	0.273 ms	0.01 Mb
hookDisplayFooterLeft	0.377 ms	0.01 Mb
hookDisplayFooterRight	0.596 ms	0.02 Mb
hookDisplayFooter	0.004 ms	- Mb
hookDisplayFooterAfter	0.419 ms	0.01 Mb
hookDisplayOutsideMainPage	0.247 ms	0.01 Mb
ps_shoppingcart	12.024 ms	0.11 Mb
__construct	0.145 ms	0.02 Mb
hookDisplayHeader	0.042 ms	- Mb
displayTop	11.837 ms	0.09 Mb
ps_searchbar	2.141 ms	0.14 Mb
__construct	0.093 ms	0.08 Mb
hookDisplayHeader	0.165 ms	- Mb
displayTop	1.883 ms	0.05 Mb
productcomments	60.391 ms	1.37 Mb
__construct	0.107 ms	0.03 Mb
hookDisplayHeader	0.091 ms	- Mb
displayProductListReviews	20.809 ms	1.28 Mb
displayProductListReviews	1.964 ms	- Mb
displayProductListReviews	1.711 ms	- Mb
displayProductListReviews	1.645 ms	- Mb
displayProductListReviews	1.989 ms	- Mb
displayProductListReviews	2.225 ms	- Mb
displayProductListReviews	1.778 ms	- Mb
displayProductListReviews	1.735 ms	- Mb
displayProductListReviews	1.667 ms	- Mb
displayProductListReviews	1.649 ms	- Mb
displayProductListReviews	1.542 ms	- Mb
displayProductListReviews	1.620 ms	- Mb
displayProductListReviews	1.584 ms	- Mb
displayProductListReviews	1.648 ms	- Mb
displayProductListReviews	1.709 ms	- Mb
displayProductListReviews	1.745 ms	- Mb
displayProductListReviews	1.611 ms	- Mb
displayProductListReviews	1.568 ms	- Mb
displayProductListReviews	1.538 ms	- Mb
displayProductListReviews	1.652 ms	- Mb
displayProductListReviews	1.643 ms	- Mb
displayProductListReviews	1.733 ms	- Mb
displayProductListReviews	1.702 ms	- Mb
displayProductListReviews	1.727 ms	- Mb
ps_googleanalytics	7.934 ms	0.05 Mb
__construct	0.130 ms	0.03 Mb
hookDisplayHeader	0.026 ms	- Mb
hookDisplayBeforeBodyClosingTag	7.778 ms	0.02 Mb
zonecolorsfonts	1.511 ms	0.06 Mb
__construct	0.216 ms	0.02 Mb
hookDisplayHeader	1.001 ms	0.03 Mb
hookDisplayOutsideMainPage	0.294 ms	0.01 Mb
zonemegamenu	2.476 ms	0.06 Mb
__construct	0.211 ms	0.03 Mb
hookDisplayHeader	1.919 ms	0.01 Mb
hookDisplayNavFullWidth	0.346 ms	0.01 Mb
prestastripe	0.982 ms	0.02 Mb
__construct	0.965 ms	0.02 Mb
hookDisplayHeader	0.017 ms	- Mb
ps_facetedsearch	1.921 ms	0.10 Mb
__construct	0.371 ms	0.10 Mb
hookProductSearchProvider	0.273 ms	- Mb
hookDisplayLeftColumn	1.277 ms	- Mb
ps_languageselector	0.814 ms	0.06 Mb
__construct	0.173 ms	0.02 Mb
displayNav2	0.641 ms	0.04 Mb
ps_currencyselector	0.516 ms	0.06 Mb
__construct	0.115 ms	0.02 Mb
displayNav2	0.401 ms	0.04 Mb
ps_customersignin	3.989 ms	0.08 Mb
__construct	0.095 ms	0.02 Mb
displayTop	3.894 ms	0.06 Mb
ps_categorytree	28.105 ms	0.75 Mb
__construct	0.147 ms	0.02 Mb
displayLeftColumn	27.958 ms	0.74 Mb
zonecolumnblocks	0.666 ms	0.11 Mb
__construct	0.298 ms	0.09 Mb
hookDisplayLeftColumn	0.368 ms	0.01 Mb
zonepopupnewsletter	0.626 ms	0.03 Mb
__construct	0.349 ms	0.02 Mb
hookDisplayOutsideMainPage	0.277 ms	0.01 Mb
statsdata	7.948 ms	0.27 Mb
__construct	0.177 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	7.771 ms	0.25 Mb
23 module(s)	273.726 ms	9.59 Mb

#	Query	Time (ms)	Rows	Filesort	Group By	Location
165	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=339 AND c.nright<=340 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	13.210 ms	13664674816	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
166	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps21_product p LEFT JOIN ps21_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps21_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps21_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps21_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps21_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps21_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps21_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps21_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=339 AND c.nright<=340 GROUP BY p.id_product) p	11.526 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)
506	INSERT INTO `ps21_jm_pagecache_bl` (`id`, `backlink_key`) VALUES (401,803264849),(401,3544422162),(401,2900588200),(401,1289214159),(401,1785617407),(401,2936477779),(401,1727466530),(401,1432532875),(401,1025009294),(401,1804081323),(401,3479716883),(401,66301815),(401,537553573),(401,3045727500),(401,3231073010),(401,1825096520),(401,3225262556),(401,2645763144),(401,2027619899),(401,786864081),(401,1849360992),(401,294428854),(401,3774376179),(401,2880678980),(401,114155291),(401,2929321318),(401,2087307803),(401,2369020978),(401,1152186767),(401,4222788516),(401,2858566420),(401,848840972),(401,4147554351),(401,770698498),(401,2244011448),(401,477004582),(401,3610318732),(401,1070190107),(401,937307692),(401,25761885),(401,3366890060),(401,3483396593),(401,392306519),(401,909258745),(401,179865882),(401,3099645137),(401,3371246540),(401,2390640699),(401,501027234),(401,3032495894),(401,2100541971),(401,2793494280),(401,180908336),(401,1192985740),(401,1972034646),(401,2419117650),(401,3803768817),(401,4265874642),(401,67723771),(401,3423129237),(401,3399895114),(401,3221089548),(401,2990154896),(401,2728213885),(401,933991437),(401,2513627470),(401,468067826),(401,4137721533),(401,1552016987),(401,4080301755),(401,4245349388),(401,1973472416),(401,1839057912),(401,3745041382),(401,3035734567),(401,3719469943),(401,3466131047),(401,679558129),(401,462819688),(401,4267553191),(401,518809702),(401,3303811122),(401,2883778317),(401,1694893476),(401,3287268691),(401,3711637102),(401,698879415),(401,885817714),(401,125306139),(401,1634619674),(401,58280175),(401,3363778289),(401,1161663254),(401,201135304),(401,288600709),(401,1021330335),(401,2858809635),(401,2763627026),(401,3717400459),(401,4125370705),(401,3997906175),(401,4162316513),(401,3219397995),(401,2539165674),(401,1046234598),(401,787652129),(401,1595426297),(401,4184932827),(401,1985552396),(401,1944795689),(401,3799916950),(401,1827123668),(401,1447744642),(401,1636796806),(401,2645405926),(401,1474595477),(401,3375525138),(401,3902077767),(401,3507415422),(401,2781072282),(401,2002273313),(401,3164880625),(401,2490789905),(401,1000843653),(401,48947005),(401,3883347157),(401,3700474777),(401,4264269047),(401,2125390191),(401,4270481046),(401,1693150473),(401,343450730),(401,381351735),(401,2863449446),(401,3772294966),(401,3877457961),(401,1492116830),(401,4041511410),(401,828132466),(401,4090211224),(401,2185737194),(401,3517149926),(401,647687838),(401,733479784),(401,1440916471),(401,3262261204),(401,1872100372),(401,2092461357),(401,3357609169),(401,2365529006),(401,1263061406),(401,2296732656),(401,534196217),(401,482025419),(401,2811467352),(401,2488480532),(401,3501473861),(401,1917272649),(401,1878317490),(401,1789511633),(401,956713705),(401,89981727),(401,1143557322),(401,2749361789),(401,3857194488),(401,1024086260),(401,26040876),(401,1804243295),(401,2165251395),(401,1281618245),(401,2793993627),(401,426054238),(401,3398682121),(401,1025101115),(401,2974984653),(401,2214325187),(401,997821910),(401,2005463392),(401,3252396061),(401,942332382),(401,3816934055),(401,1661692647),(401,975758589),(401,3974931321),(401,2301364099),(401,855746680),(401,637832447),(401,3938675492),(401,508940865),(401,911480697),(401,1283363269),(401,3552869238),(401,2961923901),(401,3747234531),(401,3155646160),(401,3164668199),(401,2271068282),(401,84354396),(401,2915068863),(401,4064530110),(401,3216991891),(401,2045363644),(401,2664176477),(401,1076722390),(401,505410826),(401,2506779464),(401,2552384108),(401,876907216),(401,82980331),(401,3890150098),(401,3475437886),(401,2302280848),(401,1133144647),(401,801167173),(401,2059315716),(401,3139619822),(401,2937007520),(401,1589371182),(401,693370988),(401,2708427394),(401,1007456900),(401,610735313),(401,3846627131),(401,2031830639),(401,1908602231),(401,1401333655),(401,378101424),(401,996218346),(401,660881695),(401,2938384267),(401,4250264855),(401,1895305721),(401,502965417),(401,1982471117),(401,2524144246),(401,2774996218),(401,1068709096),(401,4077513867),(401,465472731),(401,4139839450),(401,2360011682),(401,4211248848),(401,283341417),(401,4165214622),(401,3508523596),(401,234404923),(401,2782693783),(401,3413880379),(401,3540168379),(401,861653603),(401,3160995915),(401,1391251310),(401,2106651858),(401,3572623339),(401,4629984),(401,2488722736),(401,3486510944),(401,2675016634),(401,2165907305),(401,136687257),(401,3540179561),(401,2792526429),(401,2220600372),(401,2914585448),(401,3882733113),(401,1688090355),(401,3534950496),(401,1182870252),(401,412601709),(401,574969182),(401,2970413814),(401,1487282505),(401,3228977345),(401,2023459642),(401,3291711134),(401,2792891444),(401,3335276918),(401,502111155),(401,1347492703),(401,2832080533),(401,1215320197),(401,2317239205),(401,1931846913),(401,1721014625),(401,738600257),(401,2998338424),(401,1207945902),(401,734241479),(401,3324570843),(401,4126771257),(401,1712456575),(401,3169253733),(401,1160958045),(401,1130949510),(401,3116084871),(401,269178051),(401,24773614),(401,3204450510),(401,3468662336),(401,1808444077),(401,4095410992),(401,1012520131),(401,2367920745),(401,2603361072),(401,2741539031),(401,607507456),(401,616165826),(401,2288576869),(401,4252798532),(401,2692385638),(401,4100315394),(401,3061254709),(401,1657292258),(401,2148967437),(401,1248236410),(401,2457219175),(401,1920985790),(401,1340703149),(401,1618471777),(401,4160689201),(401,1822364967),(401,479188821),(401,1661785323),(401,4137484009),(401,2636427258),(401,1499247737),(401,2061922205),(401,665830591),(401,916194615),(401,495595719),(401,3026469794),(401,1845449656),(401,4078122428),(401,2044505385),(401,3156749269),(401,3919036276),(401,204613135),(401,605377709),(401,766051911),(401,30400764),(401,4211022030),(401,715827285),(401,1092948871),(401,610201349),(401,1023110113),(401,3379323545),(401,2591028766),(401,1994095466),(401,33157726),(401,198243957),(401,94201498),(401,2540831776),(401,1707019604),(401,2730046909),(401,4101073252),(401,207761914),(401,2750534087),(401,980926717),(401,377071036),(401,2983490672),(401,584353846),(401,1743688562),(401,3223058413),(401,1665991311),(401,3093731065),(401,1095877807),(401,1085889875),(401,2059985562),(401,3618062925),(401,592374860),(401,4217863027),(401,3425247989),(401,1636391408),(401,1698766782),(401,2162739858),(401,1538367880),(401,3760626336),(401,1987713032),(401,2338874856),(401,4206689645),(401,1723372602),(401,2788329276),(401,2095305502),(401,3135330775),(401,2402748468),(401,24058172),(401,4000683245),(401,315670382),(401,2558276906),(401,1745365471),(401,2782569384),(401,3422117706),(401,552626444),(401,1506232339),(401,2933163456),(401,1483801350),(401,1400586123),(401,3746875726),(401,2604810181),(401,2905930158),(401,803588046),(401,1651400661),(401,1431243585),(401,1586185269),(401,4110009762),(401,3647374073),(401,4196158832),(401,644435096),(401,1862966990),(401,2098775956),(401,4045847707),(401,3122054119),(401,1971194991),(401,2149367276),(401,1888540635),(401,2660577125),(401,2508340497),(401,196341346),(401,1790101800),(401,1054130805),(401,2741947598),(401,1292400575),(401,545037028),(401,1516477184),(401,2706799993),(401,562470873),(401,2591346466),(401,613023703),(401,2725609989),(401,2082081559),(401,572560232),(401,2833489058),(401,1999611979),(401,1938789650),(401,2958717166),(401,1035708154),(401,2025067287),(401,3804047398),(401,248028803),(401,4243412966),(401,628124381),(401,1271215494),(401,2140466223),(401,1298495884),(401,3585931255),(401,532975694),(401,892763084),(401,203145038),(401,470924714),(401,1460516495),(401,2732318442),(401,3996868778),(401,862206445),(401,3193479021),(401,3382171736),(401,3362897893),(401,3598913121),(401,1342337107),(401,3202829344),(401,1335223071),(401,270790954),(401,1086966479),(401,484642328),(401,4274468042),(401,1740107684),(401,2117688527),(401,1393082718),(401,366510022),(401,341328174),(401,1469264429),(401,968691010),(401,3210232788),(401,809700252),(401,3705477223),(401,1639200307),(401,3585776886),(401,3305319229),(401,1052899681),(401,2176267881),(401,357387863),(401,451177334),(401,677589039),(401,1181390953),(401,898241702),(401,3480303789),(401,1736215096),(401,2511740146),(401,2560762429),(401,1570623991),(401,897080848),(401,891021207),(401,2807843172),(401,411231410),(401,2413680770),(401,519468981),(401,1898829954),(401,4274422817),(401,2781196321),(401,433695516),(401,1652336127),(401,4200438598),(401,3032893805),(401,1435170492),(401,341146430),(401,755973553),(401,2183774725),(401,3967614532),(401,1589097164),(401,2441764320),(401,745126750),(401,348450311),(401,2084175962),(401,3357611772),(401,1654631620),(401,3098454302),(401,2029227635),(401,1731761366),(401,2444253995),(401,2906032508),(401,872274856),(401,4282856364),(401,3328013593),(401,4184469063),(401,1074477927),(401,475878802),(401,1341972790),(401,2770374005),(401,4237489391),(401,2818813526),(401,3131100007),(401,4267621199),(401,1031922959),(401,1616292706),(401,630426110),(401,1846388513),(401,2239793094),(401,1660370824),(401,3321716633),(401,2551727033),(401,1836172154),(401,1870881122),(401,3324207484),(401,1065867023),(401,1459310880),(401,1395112921),(401,893552556),(401,1795813847),(401,2544364435),(401,4188602229),(401,1437064809),(401,922605498),(401,4180843510),(401,2554784265),(401,3798404205),(401,1216801552),(401,225525148),(401,274058040),(401,3206796234),(401,610255635),(401,3139895407),(401,3993594441),(401,2078652070),(401,3340749058),(401,2282248923),(401,3201099700),(401,3944887276),(401,887478137),(401,620965629),(401,53639561),(401,687854272),(401,4204526813),(401,3434636086),(401,3859247582),(401,2160451939),(401,419013317),(401,488655959),(401,2224381764),(401,857621694),(401,593880699),(401,1743569168),(401,747100668),(401,2627272664),(401,1477316791),(401,852002855),(401,3813191394),(401,3206482767),(401,2935275735),(401,825997452),(401,4128572079),(401,4149399208),(401,2432005645),(401,945310979),(401,206553734),(401,3381625344),(401,2613891474),(401,1285565060),(401,725086502),(401,2181279565),(401,2136294074),(401,531227063),(401,3291030245),(401,3423892574),(401,1818418110),(401,1175554195),(401,231365613),(401,3071984169),(401,1510809703),(401,2304894647),(401,724387218),(401,3702122266),(401,3105745802),(401,3598888791),(401,40599425),(401,4256434691),(401,1198380170),(401,3549401556),(401,2300237909),(401,484124464),(401,3042798728),(401,767973032),(401,4146324303),(401,1493350341),(401,2166736334),(401,3061340275),(401,1468811388),(401,714571165),(401,1958965990),(401,2146366302),(401,2212338847),(401,2088651590),(401,2684538463),(401,2292708505),(401,571001464),(401,608126571),(401,2736309071),(401,1479333754),(401,1794660366),(401,2319975337),(401,1093438481),(401,2975864804),(401,2504416172),(401,3531750290),(401,219666672),(401,4219072870),(401,1053258155),(401,2382983142),(401,1006288562),(401,1770263986),(401,3089735283),(401,3689334927),(401,2901629603),(401,2019277020),(401,2853333944),(401,1110695191),(401,3884283185),(401,4268093708),(401,159799075),(401,1715997742),(401,1009155269),(401,3922001006),(401,3916338789),(401,1085252167),(401,207705430),(401,1190601026),(401,1441004396),(401,1567147586),(401,964098054),(401,1385174189),(401,3607427007),(401,4065177061),(401,1552830538),(401,3778287701),(401,3986294473),(401,4127238085),(401,1865170325),(401,2161789419),(401,2889615117),(401,785261358),(401,3873733217),(401,2600209543),(401,3958092558),(401,4143434528),(401,3225228598),(401,3451063310),(401,810085901),(401,1502204888),(401,2931931582),(401,1339720903),(401,4093703382),(401,1016897830),(401,1186809094),(401,2269117600),(401,813555736),(401,733475850),(401,305814753),(401,2720553993),(401,212227262),(401,1328958432),(401,3903742053),(401,2617942920),(401,4254367326),(401,2895836413),(401,1090341105),(401,3174277595),(401,639084285),(401,4064195579),(401,2134315289),(401,608843276),(401,4190247440),(401,1090444753),(401,2554275840),(401,2758076506),(401,2518001916),(401,3620157415),(401,1195920681),(401,1822840633),(401,1087551238),(401,235508323),(401,1139244570),(401,810960133),(401,425550269),(401,1767940144),(401,1488780247),(401,1250541405),(401,1715845038),(401,3777612587),(401,2285237154),(401,802817926),(401,4280998710),(401,1108258121),(401,1107026853),(401,2913745362),(401,1129101120),(401,2454813183),(401,1690919006),(401,23973636),(401,293370743),(401,1041759778),(401,3142497267),(401,2920365983),(401,2300359472),(401,885232682),(401,1995817456),(401,3443377157),(401,863919144),(401,1324348692),(401,4019216150),(401,443752815),(401,4223293),(401,1182491637),(401,4257294915),(401,3629776934),(401,582958316),(401,3061655453),(401,1665355533),(401,1929899841),(401,1033949851),(401,2010879266),(401,1872304779),(401,1282102725),(401,3589651214),(401,4095654001),(401,2447713556),(401,2543494532),(401,2069898435),(401,3286503857),(401,2662939963),(401,93111834),(401,3160936308),(401,261262800),(401,141197408),(401,1904512268),(401,3001025754),(401,2247670246),(401,535154833),(401,3476002757),(401,3806439314),(401,1819793014),(401,3545273473),(401,3957652542),(401,3018295592),(401,1367893712),(401,1034338066),(401,3229510223),(401,4276953245),(401,3363858574),(401,2870596766),(401,648526699),(401,3627085975),(401,1585047995),(401,1960922033),(401,748737253),(401,1175066615),(401,1318322018),(401,260367662),(401,643741484),(401,1013706048),(401,1726352130),(401,2222354404),(401,1327031463),(401,1131865044),(401,839200087),(401,1407668396),(401,3548333318),(401,237845721),(401,3056051791),(401,747235328),(401,172675174),(401,2781705803),(401,2111348799),(401,3067187587),(401,618638032),(401,3369756381),(401,2232055662),(401,55113216),(401,3939915090),(401,2586983921),(401,3286008345),(401,1956055310),(401,740042513),(401,2282536358),(401,1863122946),(401,1296880981),(401,2589434346),(401,1621393368),(401,39250009),(401,72263924),(401,1587391050),(401,847186998),(401,2455499024),(401,859347884),(401,2244795234),(401,64890532),(401,2852552174),(401,1937485844),(401,1553076312),(401,49680851),(401,3262502459),(401,1863152826),(401,2946797211),(401,4205660694),(401,276146628),(401,4286283936),(401,2843690236),(401,1173455291),(401,916659877),(401,2606976998),(401,2186709370),(401,2263342167),(401,1318094494),(401,2508411678),(401,225441583),(401,468555185),(401,1812959715),(401,296862773),(401,1148601668),(401,1200623512),(401,3924888977),(401,1697117306),(401,3406763364),(401,1129505049) ON DUPLICATE KEY UPDATE id=id	10.553 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)
463	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.997 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_6569a7e1a53573_58008451) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a32f67_93380173) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a2d029_07569066) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a17c46_76931054) /vendor/smarty/smarty/libs/sysplugins/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.580 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)
170	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2023-12-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM ps21_product p LEFT JOIN ps21_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps21_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps21_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (191,656,2236,3127,5302,8279,12538,12550,12674,12881,13074,13171,17345,18705,18707,20690,21926,22735,26459,29337,34462,36409,47123,52395)	2.703 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)
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.618 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.362 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)
494	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.112 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_6569a7e1a53573_58008451) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a32f67_93380173) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a2d029_07569066) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a17c46_76931054) /vendor/smarty/smarty/libs/sysplugins/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)
507	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	2.018 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)
52	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps21_hook_module` hm STRAIGHT_JOIN `ps21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps21_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.006 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.870 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)
161	SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 339) AND (a0.`nright` > 340) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc	1.512 ms	835	Yes		/classes/PrestaShopCollection.php:383 /classes/PrestaShopCollection.php:440 (getAll) /controllers/front/listing/CategoryController.php:245 (rewind) /classes/controller/FrontController.php:1822 (getBreadcrumbLinks) /modules/zonemegamenu/zonemegamenu.php:1542 (getBreadcrumb) /classes/Hook.php:1043 (hookDisplayHeader) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/controller/FrontController.php:580 (exec) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
154	SELECT SQL_NO_CACHE * FROM `ps21_category` a0 LEFT JOIN `ps21_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 339) AND (a0.`nright` > 340) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1) ORDER BY a0.`nleft` asc	1.468 ms	835	Yes		/classes/PrestaShopCollection.php:383 /classes/PrestaShopCollection.php:440 (getAll) /controllers/front/listing/CategoryController.php:245 (rewind) /classes/controller/FrontController.php:1822 (getBreadcrumbLinks) /classes/controller/FrontController.php:514 (getBreadcrumb) /classes/controller/FrontController.php:572 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
503	INSERT INTO `ps21_jm_pagecache` (`cache_key`, `url`, `id_context`, `id_controller`, `id_shop`, `id_object`, `count_missed`, `count_hit`) VALUES ( 808305937, 'https://cadeaufou.com/151-balances', 1, 2, 1, 151, 1, 0) ON DUPLICATE KEY UPDATE `count_missed`=`count_missed` + 1, last_gen = CURRENT_TIMESTAMP, `deleted` = 0;	1.449 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)
169	REPLACE INTO ps21_layered_filter_block (hash, data) VALUES ("09117acba1e8b33d969990121b6e6dae", "a:1:{s:7:\"filters\";a:0:{}}")	1.198 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /override/classes/controller/ProductListingFrontController.php:19 (doProductSearch) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
499	INSERT INTO `ps21_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('916331', '', 'cadeaufou.com/151-balances', '', '2023-12-01 10:31:14')	1.167 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_6569a7e1a53573_58008451) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a32f67_93380173) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a2d029_07569066) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a17c46_76931054) /vendor/smarty/smarty/libs/sysplugins/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)
498	INSERT INTO `ps21_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('918622', '639', '751134203', '', '1', '1', '2023-12-01 10:31:14')	1.128 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_6569a7e1a53573_58008451) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a32f67_93380173) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a2d029_07569066) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a17c46_76931054) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/controller/FrontController.php:718 (fetch) /classes/controller/FrontController.php:700 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
139	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps21_category` c INNER JOIN ps21_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps21_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps21_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 151 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	1.100 ms	1	Yes	Yes	/classes/Category.php:921 /controllers/front/listing/CategoryController.php:229 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:39 (dispatch)
14	SELECT SQL_NO_CACHE lower(name) as name FROM `ps21_hook` h WHERE (h.active = 1)	1.088 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)
420	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` = 18707) AND (b.`id_shop` = 1) LIMIT 1	0.987 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)
17	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps21_hook`	0.893 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)
408	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` = 13074) AND (b.`id_shop` = 1) LIMIT 1	0.880 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)
417	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` = 18705) AND (b.`id_shop` = 1) LIMIT 1	0.845 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)
358	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` = 36409 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` = 36409 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.837 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)
367	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` = 47123 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` = 47123 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.834 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)
181	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` = 191 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` = 191 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.831 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)
283	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` = 17345 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` = 17345 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.829 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)
274	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` = 13171 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` = 13171 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.817 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)
233	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` = 12538 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` = 12538 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.799 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)
467	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 (656) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.798 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_6569a7e1d1bab3_28421793) /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_6569a7e1cfa600_76663251) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1cf29f2_36954600) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a53573_58008451) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a32f67_93380173) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a2d029_07569066) /vendor/smarty/smarty/libs/sysplugins/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_6569a7e1a17c46_76931054) /vendor/smarty/smarty/libs/sysplugins/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)
216	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` = 5302 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` = 5302 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.797 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)
249	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` = 12674 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` = 12674 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.797 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)
241	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` = 12550 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` = 12550 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.794 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)
350	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` = 34462 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` = 34462 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.787 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)
376	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` = 52395 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` = 52395 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.786 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)
207	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` = 3127 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` = 3127 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.779 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)
266	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` = 13074 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` = 13074 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.770 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)
198	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` = 2236 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` = 2236 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.766 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)
341	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` = 29337 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` = 29337 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.766 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)

Balances