List of products by brand ILLY

ILLY illy iperespresso 108 Coffee Capsules - Tasting Kit

Offerte

Capsule illy iperespresso 108 caffè KIT DEGUSTAZIONE

93.90

In Stock 191 Products

illy ESE Paper Pods 44mm MEDIUM ROAST 100% Arabica - Pack of 18 Coffee Pods

ILLY illy ESE Paper Pods 44mm MEDIUM ROAST 100% Arabica - Pack of...

Offerte

Original illy ESE Paper Pods 44 mm MEDIUM ROAST 100% Arabica

100% Compatible with all the machines using the universal paper pods 44mm system

30.90

In Stock 141 Products

ILLY illy iperespresso 108 Coffee Capsules Arabica Selection

Offerte

Capsule illy iperespresso 108 caffè KIT DEGUSTAZIONE

93.90

In Stock 236 Products

illy ESE Paper Pods 44mm DARK ROAST 100% Arabica - Pack of 18 Coffee Pods

ILLY illy ESE Paper Pods 44mm DARK ROAST 100% Arabica - Pack of 18...

Offerte

Original illy ESE Paper Pods 44 mm DARK ROAST 100% Arabica

100% Compatible with all the machines using the universal paper pods 44mm system

30.90

In Stock 160 Products

illy ESE Paper Pods 44mm EXTRA ROAST 100% Arabica - Pack of 18 Coffee Pods

ILLY illy ESE Paper Pods 44mm EXTRA ROAST 100% Arabica - Pack of 18...

Offerte

Original illy ESE Paper Pods 44 mm MEDIUM ROAST 100% Arabica

100% Compatible with all the machines using the universal paper pods 44mm system

30.90

In Stock 35 Products

illy iperespresso Coffee Capsules Medium Roast

ILLY illy iperespresso Coffee Capsules CLASSICO Roast

Offerte

Original illy iperespresso Coffee Capsules CLASSICO Roast (Red Box) in cube of 18 capsules!

93.90

In Stock 812 Products

illy ESE Paper Pods 44mm DECAFFEINATED 100% Arabica - Pack of 18 Coffee Pods

ILLY illy ESE Paper Pods 44mm DECAFFEINATED 100% Arabica - Pack of...

Offerte

Original illy ESE Paper Pods 44 mm DECAFFEINATED 100% Arabica

100% Compatible with all the machines using the universal paper pods 44mm system

30.90

In Stock 80 Products

ILLY KIT DEGUSTAZIONE ASSAGGIO Cialde caffè illy 108

Offerte

Original illy ESE Paper Pods 44 mm Tasting Kit 100% Arabica

100% Compatible with all the machines using the universal paper pods 44mm system

31.90

In Stock 133 Products

ILLY illy iperespresso Coffee Capsules INTENSO Roast

Offerte

Original illy iperespresso Coffee Capsules INTENSO Roast in cube of 18 capsules

93.90

In Stock 510 Products

ILLY illy iperespresso Coffee Capsules FORTE Roast

Offerte

Original illy iperespresso Coffee Capsules FORTE Roast (Black Box) in cube of 18 capsules

93.90

In Stock 232 Products

Illy iperespresso Coffee Capsules Decaffeinated Dek

ILLY illy iperespresso Coffee Capsules Decaffeinated

Offerte

Original illy iperespresso Coffee Capsules Decaffeinated Decaf (Light Blue Box) in cube of 18 capsules

93.90

In Stock 496 Products

illy iperEspresso 18 Coffee Capsules Lungo Long Blue Box 100% Arabica

ILLY illy iperEspresso 18 Coffee Capsules Lungo Long Blue Box 100%...

Offerte

illy iperEspresso Coffee Capsules Lungo in Box of 18 100% Arabica

93.90

In Stock 1542 Products

Load Time	1032 ms
Querying Time	249 ms
Queries	1043
Memory Peak Usage	29.3 Mb
Included Files	775 files - 10.07 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	8k
- global $smarty	5k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- global $_COOKIE	2k
- global $__composer_autoload_files	1k

PrestaShop Version	8.1.7
PHP Version	8.1.34
MySQL Version	11.4.10-MariaDB-log
Memory Limit	2048M
Max Execution Time	300s
Smarty Cache	disabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	2.310 ms	2.310 ms	2.16 Mb	2.6 Mb
__construct	0.016 ms	2.326 ms	- Mb	2.6 Mb
init	25.304 ms	27.630 ms	0.43 Mb	3.0 Mb
checkAccess	0.002 ms	27.632 ms	- Mb	3.0 Mb
setMedia	3.204 ms	30.836 ms	0.18 Mb	3.0 Mb
postProcess	0.002 ms	30.838 ms	- Mb	3.0 Mb
initHeader	0.002 ms	30.840 ms	- Mb	3.0 Mb
initContent	140.720 ms	171.560 ms	4.94 Mb	7.8 Mb
initFooter	0.004 ms	171.564 ms	- Mb	7.8 Mb
display	861 ms	1032 ms	20.61 Mb	29.3 Mb

Hook	Time	Memory Usage
displayHeaderCenter	73.456 ms	6.69 Mb
=> cp_blocksearch (widget)	73.456 ms	6.69 Mb
DisplayProductListReviews	64.744 ms	6.54 Mb
=> pla	8.774 ms	1.22 Mb
=> pla	5.357 ms	0.55 Mb
=> pla	5.649 ms	0.51 Mb
=> pla	4.535 ms	0.42 Mb
=> pla	4.752 ms	0.42 Mb
=> pla	5.231 ms	0.52 Mb
=> pla	3.781 ms	0.43 Mb
=> pla	4.093 ms	0.42 Mb
=> pla	6.424 ms	0.51 Mb
=> pla	5.327 ms	0.52 Mb
=> pla	4.405 ms	0.51 Mb
=> pla	6.416 ms	0.51 Mb
DisplayCpHoverImage	12.455 ms	0.44 Mb
=> cp_imagehover	1.210 ms	0.04 Mb
=> cp_imagehover	0.929 ms	0.04 Mb
=> cp_imagehover	0.662 ms	0.03 Mb
=> cp_imagehover	0.979 ms	0.04 Mb
=> cp_imagehover	1.191 ms	0.04 Mb
=> cp_imagehover	1.027 ms	0.04 Mb
=> cp_imagehover	0.925 ms	0.04 Mb
=> cp_imagehover	0.968 ms	0.04 Mb
=> cp_imagehover	1.055 ms	0.04 Mb
=> cp_imagehover	1.381 ms	0.04 Mb
=> cp_imagehover	1.035 ms	0.04 Mb
=> cp_imagehover	1.093 ms	0.04 Mb
DisplayStCompareButton	8.821 ms	0.03 Mb
=> stfeature	0.647 ms	0.01 Mb
=> stfeature	0.313 ms	- Mb
=> stfeature	0.326 ms	- Mb
=> stfeature	0.532 ms	- Mb
=> stfeature	0.420 ms	- Mb
=> stfeature	0.368 ms	- Mb
=> stfeature	0.330 ms	- Mb
=> stfeature	0.316 ms	- Mb
=> stfeature	0.346 ms	- Mb
=> stfeature	0.299 ms	- Mb
=> stfeature	0.334 ms	- Mb
=> stfeature	0.304 ms	- Mb
=> stfeature	0.406 ms	- Mb
=> stfeature	0.306 ms	- Mb
=> stfeature	0.404 ms	- Mb
=> stfeature	0.283 ms	- Mb
=> stfeature	0.331 ms	- Mb
=> stfeature	0.494 ms	- Mb
=> stfeature	0.371 ms	- Mb
=> stfeature	0.324 ms	- Mb
=> stfeature	0.363 ms	- Mb
=> stfeature	0.326 ms	- Mb
=> stfeature	0.377 ms	- Mb
=> stfeature	0.301 ms	- Mb
displayNavFullWidth	8.208 ms	1.01 Mb
=> cp_sideverticalmenu (widget)	5.806 ms	0.78 Mb
=> ps_mainmenu (widget)	1.356 ms	0.16 Mb
=> cp_headercms2 (widget)	1.046 ms	0.06 Mb
DisplayBeforeBodyClosingTag	7.302 ms	0.32 Mb
=> statsdata	3.139 ms	0.04 Mb
=> ps_googleanalytics	4.163 ms	0.27 Mb
displayFooter	7.067 ms	0.69 Mb
=> ps_linklist (widget)	6.260 ms	0.61 Mb
=> cp_themeoptions (widget)	0.807 ms	0.08 Mb
DisplayStWishlistButton	6.442 ms	0.03 Mb
=> stfeature	0.521 ms	0.01 Mb
=> stfeature	0.258 ms	- Mb
=> stfeature	0.277 ms	- Mb
=> stfeature	0.314 ms	- Mb
=> stfeature	0.251 ms	- Mb
=> stfeature	0.248 ms	- Mb
=> stfeature	0.255 ms	- Mb
=> stfeature	0.252 ms	- Mb
=> stfeature	0.238 ms	- Mb
=> stfeature	0.230 ms	- Mb
=> stfeature	0.250 ms	- Mb
=> stfeature	0.227 ms	- Mb
=> stfeature	0.256 ms	- Mb
=> stfeature	0.231 ms	- Mb
=> stfeature	0.234 ms	- Mb
=> stfeature	0.221 ms	- Mb
=> stfeature	0.228 ms	- Mb
=> stfeature	0.297 ms	- Mb
=> stfeature	0.316 ms	- Mb
=> stfeature	0.236 ms	- Mb
=> stfeature	0.331 ms	- Mb
=> stfeature	0.266 ms	- Mb
=> stfeature	0.271 ms	- Mb
=> stfeature	0.233 ms	- Mb
displayLeftColumn	5.937 ms	0.33 Mb
=> ps_categorytree (widget)	2.880 ms	0.23 Mb
=> cp_leftbanner1 (widget)	1.666 ms	0.03 Mb
=> cp_sidebarfeaturedproducts (widget)	1.391 ms	0.08 Mb
DisplayFooter	5.450 ms	0.40 Mb
=> cpcouponpop	0.009 ms	- Mb
=> cp_salenotification	5.441 ms	0.40 Mb
displayNav2	5.429 ms	0.20 Mb
=> ps_languageselector (widget)	1.323 ms	0.05 Mb
=> ps_currencyselector (widget)	3.071 ms	0.11 Mb
=> ps_customersignin (widget)	1.035 ms	0.04 Mb
Header	2.975 ms	0.04 Mb
=> pla	0.570 ms	- Mb
=> cp_blocksearch	0.559 ms	- Mb
=> cp_salenotification	0.163 ms	- Mb
=> cp_themeoptions	1.363 ms	0.02 Mb
=> stfeature	0.320 ms	0.01 Mb
displayHeaderRight	2.335 ms	0.13 Mb
=> ps_shoppingcart (widget)	2.335 ms	0.13 Mb
displaySide	2.005 ms	0.06 Mb
=> ps_currencyselector (widget)	0.894 ms	0.03 Mb
=> ps_languageselector (widget)	0.526 ms	0.01 Mb
=> cp_headercms1 (widget)	0.585 ms	0.02 Mb
displayFooterleft	1.751 ms	0.10 Mb
=> ps_contactinfo (widget)	0.929 ms	0.06 Mb
=> ps_socialfollow (widget)	0.822 ms	0.04 Mb
displayNav1	1.674 ms	0.09 Mb
=> cp_headercms1 (widget)	1.674 ms	0.09 Mb
DisplayHeader	1.568 ms	0.01 Mb
=> ps_shoppingcart	0.078 ms	- Mb
=> ps_googleanalytics	0.150 ms	- Mb
=> cp_imageslider	0.214 ms	- Mb
=> cp_categorylist	0.121 ms	- Mb
=> cp_categoryproductsslider	0.164 ms	- Mb
=> cpcouponpop	0.004 ms	- Mb
=> cp_countdown	0.186 ms	- Mb
=> ets_blog	0.536 ms	- Mb
=> cp_sideverticalmenu	0.114 ms	- Mb
DisplayStCompareTopLink	1.244 ms	0.06 Mb
=> stfeature	0.663 ms	0.04 Mb
=> stfeature	0.581 ms	0.03 Mb
ProductSearchProvider	1.093 ms	- Mb
=> ps_facetedsearch	1.093 ms	- Mb
DisplayStWishlistTopLink	0.944 ms	0.04 Mb
=> stfeature	0.658 ms	0.03 Mb
=> stfeature	0.286 ms	- Mb
displayFooterAfter	0.905 ms	0.09 Mb
=> cp_footercms1 (widget)	0.905 ms	0.09 Mb
displayFooterbefore	0.784 ms	0.05 Mb
=> ps_emailsubscription (widget)	0.784 ms	0.05 Mb
ActionFrontControllerSetMedia	0.745 ms	0.01 Mb
=> blockreassurance	0.364 ms	- Mb
=> ps_emailsubscription	0.117 ms	- Mb
=> ps_socialfollow	0.124 ms	- Mb
=> ps_emailalerts	0.140 ms	- Mb
DisplayFooterAfter	0.439 ms	0.04 Mb
=> cp_themeoptions	0.439 ms	0.04 Mb
Footer	0.393 ms	0.09 Mb
=> cp_cookie	0.393 ms	0.09 Mb
displayCustomerSide	0.367 ms	- Mb
=> ps_customersignin (widget)	0.367 ms	- Mb
DisplayLeftColumn	0.300 ms	0.03 Mb
=> ps_facetedsearch	0.300 ms	0.03 Mb
ModuleRoutes	0.017 ms	0.01 Mb
=> ets_blog	0.017 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.012 ms	- Mb
=> blockreassurance	0.012 ms	- Mb
29 hook(s)	224.862 ms	17.52 Mb

Module	Time	Memory Usage
ets_blog	5.559 ms	0.01 Mb
__construct	4.999 ms	- Mb
hookModuleRoutes	0.023 ms	0.01 Mb
hookDisplayHeader	0.537 ms	- Mb
blockreassurance	1.152 ms	0.08 Mb
__construct	0.767 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.367 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.018 ms	- Mb
ps_emailsubscription	1.023 ms	0.06 Mb
__construct	0.117 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.119 ms	- Mb
displayFooterbefore	0.787 ms	0.05 Mb
ps_socialfollow	1.028 ms	0.05 Mb
__construct	0.078 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.125 ms	- Mb
displayFooterleft	0.825 ms	0.04 Mb
ps_emailalerts	0.285 ms	0.07 Mb
__construct	0.144 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.141 ms	- Mb
ps_shoppingcart	2.533 ms	0.14 Mb
__construct	0.117 ms	0.01 Mb
hookDisplayHeader	0.081 ms	- Mb
displayHeaderRight	2.335 ms	0.13 Mb
ps_googleanalytics	4.448 ms	0.28 Mb
__construct	0.132 ms	0.01 Mb
hookDisplayHeader	0.151 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.165 ms	0.27 Mb
cp_imageslider	0.503 ms	0.01 Mb
__construct	0.288 ms	0.01 Mb
hookDisplayHeader	0.215 ms	- Mb
cp_categorylist	0.278 ms	0.01 Mb
__construct	0.156 ms	0.01 Mb
hookDisplayHeader	0.122 ms	- Mb
cp_categoryproductsslider	0.329 ms	0.01 Mb
__construct	0.164 ms	0.01 Mb
hookDisplayHeader	0.165 ms	- Mb
cpcouponpop	0.272 ms	0.01 Mb
__construct	0.257 ms	0.01 Mb
hookDisplayHeader	0.005 ms	- Mb
hookDisplayFooter	0.010 ms	- Mb
cp_countdown	0.353 ms	0.01 Mb
__construct	0.166 ms	0.01 Mb
hookDisplayHeader	0.187 ms	- Mb
pla	65.664 ms	6.55 Mb
__construct	0.296 ms	0.01 Mb
hookHeader	0.572 ms	- Mb
hookDisplayProductListReviews	8.776 ms	1.22 Mb
hookDisplayProductListReviews	5.365 ms	0.55 Mb
hookDisplayProductListReviews	5.654 ms	0.51 Mb
hookDisplayProductListReviews	4.539 ms	0.42 Mb
hookDisplayProductListReviews	4.755 ms	0.42 Mb
hookDisplayProductListReviews	5.234 ms	0.52 Mb
hookDisplayProductListReviews	3.785 ms	0.43 Mb
hookDisplayProductListReviews	4.096 ms	0.42 Mb
hookDisplayProductListReviews	6.431 ms	0.51 Mb
hookDisplayProductListReviews	5.331 ms	0.52 Mb
hookDisplayProductListReviews	4.410 ms	0.51 Mb
hookDisplayProductListReviews	6.420 ms	0.51 Mb
cp_blocksearch	74.308 ms	6.71 Mb
__construct	0.286 ms	0.01 Mb
hookHeader	0.561 ms	- Mb
displayHeaderCenter	73.461 ms	6.70 Mb
cp_sideverticalmenu	6.209 ms	0.79 Mb
__construct	0.286 ms	0.01 Mb
hookDisplayHeader	0.116 ms	- Mb
displayNavFullWidth	5.807 ms	0.78 Mb
cp_salenotification	5.699 ms	0.40 Mb
__construct	0.091 ms	0.01 Mb
hookHeader	0.164 ms	- Mb
hookDisplayFooter	5.444 ms	0.40 Mb
cp_themeoptions	2.978 ms	0.17 Mb
__construct	0.362 ms	0.03 Mb
hookHeader	1.366 ms	0.02 Mb
displayFooter	0.810 ms	0.08 Mb
hookDisplayFooterAfter	0.440 ms	0.04 Mb
stfeature	18.175 ms	0.19 Mb
__construct	0.293 ms	0.01 Mb
hookHeader	0.321 ms	0.01 Mb
hookDisplayStCompareTopLink	0.667 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.659 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.287 ms	- Mb
hookDisplayStCompareTopLink	0.582 ms	0.03 Mb
hookDisplayStCompareButton	0.651 ms	0.01 Mb
hookDisplayStWishlistButton	0.524 ms	0.01 Mb
hookDisplayStCompareButton	0.314 ms	- Mb
hookDisplayStWishlistButton	0.259 ms	- Mb
hookDisplayStCompareButton	0.328 ms	- Mb
hookDisplayStWishlistButton	0.279 ms	- Mb
hookDisplayStCompareButton	0.536 ms	- Mb
hookDisplayStWishlistButton	0.317 ms	- Mb
hookDisplayStCompareButton	0.424 ms	- Mb
hookDisplayStWishlistButton	0.252 ms	- Mb
hookDisplayStCompareButton	0.372 ms	- Mb
hookDisplayStWishlistButton	0.251 ms	- Mb
hookDisplayStCompareButton	0.333 ms	- Mb
hookDisplayStWishlistButton	0.256 ms	- Mb
hookDisplayStCompareButton	0.317 ms	- Mb
hookDisplayStWishlistButton	0.253 ms	- Mb
hookDisplayStCompareButton	0.349 ms	- Mb
hookDisplayStWishlistButton	0.240 ms	- Mb
hookDisplayStCompareButton	0.300 ms	- Mb
hookDisplayStWishlistButton	0.231 ms	- Mb
hookDisplayStCompareButton	0.336 ms	- Mb
hookDisplayStWishlistButton	0.251 ms	- Mb
hookDisplayStCompareButton	0.305 ms	- Mb
hookDisplayStWishlistButton	0.228 ms	- Mb
hookDisplayStCompareButton	0.410 ms	- Mb
hookDisplayStWishlistButton	0.258 ms	- Mb
hookDisplayStCompareButton	0.308 ms	- Mb
hookDisplayStWishlistButton	0.232 ms	- Mb
hookDisplayStCompareButton	0.407 ms	- Mb
hookDisplayStWishlistButton	0.235 ms	- Mb
hookDisplayStCompareButton	0.284 ms	- Mb
hookDisplayStWishlistButton	0.222 ms	- Mb
hookDisplayStCompareButton	0.333 ms	- Mb
hookDisplayStWishlistButton	0.229 ms	- Mb
hookDisplayStCompareButton	0.498 ms	- Mb
hookDisplayStWishlistButton	0.301 ms	- Mb
hookDisplayStCompareButton	0.374 ms	- Mb
hookDisplayStWishlistButton	0.318 ms	- Mb
hookDisplayStCompareButton	0.326 ms	- Mb
hookDisplayStWishlistButton	0.237 ms	- Mb
hookDisplayStCompareButton	0.365 ms	- Mb
hookDisplayStWishlistButton	0.332 ms	- Mb
hookDisplayStCompareButton	0.329 ms	- Mb
hookDisplayStWishlistButton	0.269 ms	- Mb
hookDisplayStCompareButton	0.380 ms	- Mb
hookDisplayStWishlistButton	0.274 ms	- Mb
hookDisplayStCompareButton	0.303 ms	- Mb
hookDisplayStWishlistButton	0.236 ms	- Mb
ps_facetedsearch	2.667 ms	0.05 Mb
__construct	1.271 ms	0.01 Mb
hookProductSearchProvider	1.095 ms	- Mb
hookDisplayLeftColumn	0.301 ms	0.03 Mb
cp_headercms1	2.572 ms	0.12 Mb
__construct	0.307 ms	0.01 Mb
displayNav1	1.679 ms	0.09 Mb
displaySide	0.586 ms	0.02 Mb
ps_languageselector	1.969 ms	0.06 Mb
__construct	0.116 ms	0.01 Mb
displayNav2	1.326 ms	0.05 Mb
displaySide	0.527 ms	0.01 Mb
ps_currencyselector	4.099 ms	0.15 Mb
__construct	0.123 ms	0.01 Mb
displayNav2	3.080 ms	0.11 Mb
displaySide	0.896 ms	0.03 Mb
ps_customersignin	1.610 ms	0.05 Mb
__construct	0.201 ms	0.01 Mb
displayNav2	1.039 ms	0.04 Mb
displayCustomerSide	0.370 ms	- Mb
ps_mainmenu	1.547 ms	0.17 Mb
__construct	0.188 ms	0.01 Mb
displayNavFullWidth	1.359 ms	0.17 Mb
cp_headercms2	1.408 ms	0.07 Mb
__construct	0.359 ms	0.01 Mb
displayNavFullWidth	1.049 ms	0.07 Mb
ps_categorytree	3.002 ms	0.23 Mb
__construct	0.119 ms	0.01 Mb
displayLeftColumn	2.883 ms	0.23 Mb
cp_leftbanner1	1.882 ms	0.03 Mb
__construct	0.214 ms	0.01 Mb
displayLeftColumn	1.668 ms	0.03 Mb
cp_sidebarfeaturedproducts	1.559 ms	0.09 Mb
__construct	0.166 ms	0.01 Mb
displayLeftColumn	1.393 ms	0.08 Mb
cp_imagehover	12.682 ms	0.45 Mb
__construct	0.191 ms	0.01 Mb
hookDisplayCpHoverImage	1.213 ms	0.04 Mb
hookDisplayCpHoverImage	0.932 ms	0.04 Mb
hookDisplayCpHoverImage	0.665 ms	0.03 Mb
hookDisplayCpHoverImage	0.983 ms	0.04 Mb
hookDisplayCpHoverImage	1.194 ms	0.04 Mb
hookDisplayCpHoverImage	1.030 ms	0.04 Mb
hookDisplayCpHoverImage	0.927 ms	0.04 Mb
hookDisplayCpHoverImage	0.971 ms	0.04 Mb
hookDisplayCpHoverImage	1.057 ms	0.04 Mb
hookDisplayCpHoverImage	1.385 ms	0.04 Mb
hookDisplayCpHoverImage	1.037 ms	0.04 Mb
hookDisplayCpHoverImage	1.097 ms	0.04 Mb
ps_contactinfo	1.074 ms	0.07 Mb
__construct	0.143 ms	0.01 Mb
displayFooterleft	0.931 ms	0.06 Mb
ps_linklist	7.463 ms	0.62 Mb
__construct	1.200 ms	0.01 Mb
displayFooter	6.263 ms	0.61 Mb
cp_cookie	0.616 ms	0.09 Mb
__construct	0.221 ms	0.01 Mb
hookFooter	0.395 ms	0.09 Mb
cp_footercms1	1.141 ms	0.10 Mb
__construct	0.233 ms	0.01 Mb
displayFooterAfter	0.908 ms	0.09 Mb
statsdata	3.276 ms	0.05 Mb
__construct	0.135 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.141 ms	0.05 Mb
34 module(s)	239.363 ms	17.94 Mb

shop by category

Home

Left Banner

List of products by brand ILLY

Original illy ESE Paper Pods 44 mm MEDIUM ROAST 100% Arabica

Original illy ESE Paper Pods 44 mm DARK ROAST 100% Arabica

Original illy ESE Paper Pods 44 mm MEDIUM ROAST 100% Arabica

Original illy ESE Paper Pods 44 mm DECAFFEINATED 100% Arabica

Original illy ESE Paper Pods 44 mm Tasting Kit 100% Arabica

illy iperEspresso Coffee Capsules Lungo in Box of 18 100% Arabica

Contact us

Products

Our company

Stopwatch SQL - 1043 queries

Doubles

Tables stress

ObjectModel instances

Included Files

142 queries	SELECT * FROM `vtny_category` a LEFT JOIN `vtny_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `vtny_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
142 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
57 queries	SELECT SUM(quantity) FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
45 queries	SELECT `id_image` FROM `vtny_image` WHERE `id_product` = XX AND `cover` = XX ORDER BY position ASC LIMIT XX, XX
24 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `vtny_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `vtny_cart_product` cp JOIN `vtny_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `vtny_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
24 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `vtny_image` i INNER JOIN vtny_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `vtny_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
24 queries	SELECT `id_product_attribute` FROM `vtny_product_attribute` WHERE `id_product` = XX
21 queries	SELECT `id_module` FROM `vtny_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
18 queries	SELECT * FROM `vtny_product` a LEFT JOIN `vtny_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `vtny_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
14 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `vtny_product_attribute_image` pai LEFT JOIN `vtny_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `vtny_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
13 queries	SELECT XX FROM `vtny_specific_price` WHERE id_product = XX LIMIT XX
12 queries	SELECT image_shop.`id_image` FROM `vtny_image` i INNER JOIN vtny_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
12 queries	SELECT name FROM vtny_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
12 queries	SELECT product_attribute_shop.`price` FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
12 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `vtny_product` p INNER JOIN `vtny_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `vtny_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
12 queries	SELECT `id_tax_rules_group` FROM `vtny_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12 queries	SELECT `reduction` FROM `vtny_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
12 queries	SELECT COUNT(*) FROM `vtny_pack` WHERE id_product_pack = XX LIMIT XX
12 queries	SELECT product_type FROM `vtny_product` WHERE id_product = XX LIMIT XX
12 queries	SELECT pa.`available_date` FROM `vtny_product` p LEFT JOIN `vtny_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN vtny_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
12 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM vtny_feature_product pf LEFT JOIN vtny_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN vtny_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN vtny_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN vtny_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
12 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `vtny_attribute` a LEFT JOIN `vtny_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `vtny_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `vtny_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `vtny_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `vtny_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
12 queries	SELECT * FROM `vtny_product_attribute` a LEFT JOIN `vtny_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
12 queries	SELECT * FROM `vtny_product_attribute_lang` WHERE `id_product_attribute` = XX
12 queries	SELECT * FROM `vtny_product` a LEFT JOIN `vtny_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
12 queries	SELECT * FROM `vtny_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
12 queries	SELECT pa., product_attribute_shop. FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
12 queries	SELECT COUNT(p.id_product) FROM `vtny_product` p INNER JOIN vtny_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE p.id_product = XX AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
12 queries	SELECT product_attribute_shop.id_product_attribute FROM vtny_product_attribute pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
12 queries	SELECT product_attribute_shop.id_product_attribute FROM vtny_product_attribute pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX
12 queries	SELECT t.`id_lang`, t.`name` FROM vtny_tag t LEFT JOIN vtny_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
12 queries	SELECT out_of_stock FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT depends_on_stock FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT location FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, XX)) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
12 queries	SELECT al.`name` AS attribute_name FROM `vtny_product_attribute_combination` pac LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
10 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `vtny_product_attribute_image` pai LEFT JOIN `vtny_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `vtny_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
7 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `vtny_product_attribute_combination` pac LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
7 queries	SELECT * FROM `vtny_attribute` a LEFT JOIN `vtny_attribute_shop` `c` ON a.`id_attribute` = c.`id_attribute` AND c.`id_shop` = XX WHERE (a.`id_attribute` = XX) LIMIT XX
7 queries	SELECT * FROM `vtny_attribute_lang` WHERE `id_attribute` = XX
6 queries	SELECT * FROM `vtny_image_shop` image_shop WHERE image_shop.`id_product` = XX AND image_shop.`cover`= XX LIMIT XX
5 queries	SELECT cl.`link_rewrite` FROM `vtny_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
5 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `vtny_product_attribute_combination` pac LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
5 queries	SELECT * FROM `vtny_cms` a LEFT JOIN `vtny_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
5 queries	SELECT * FROM `vtny_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
4 queries	SELECT `id_lang` FROM `vtny_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
3 queries	SELECT * FROM `vtny_cpheadercmsXXblockinfo_lang` WHERE `id_lang` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT * FROM `vtny_lang` a LEFT JOIN `vtny_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `vtny_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `vtny_module` m LEFT JOIN `vtny_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT * FROM `vtny_manufacturer` a LEFT JOIN `vtny_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = XX LEFT JOIN `vtny_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = XX WHERE (a.`id_manufacturer` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_currency` a LEFT JOIN `vtny_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `vtny_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_currency` a LEFT JOIN `vtny_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_currency_lang` WHERE `id_currency` = XX
2 queries	SELECT XX FROM `vtny_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT `need_identification_number` FROM `vtny_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `vtny_attribute_group` ag INNER JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `vtny_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN vtny_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `vtny_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
2 queries	SELECT tr.* FROM `vtny_tax_rule` tr JOIN `vtny_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `id_module` FROM `vtny_module` WHERE `name` = "cp_headercmsXX" LIMIT XX
2 queries	SELECT * FROM `vtny_currency` c INNER JOIN vtny_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE c.`deleted` = XX AND c.`active` = XX ORDER BY `iso_code` ASC
2 queries	SELECT DISTINCT `id_product` FROM `vtny_stfeature_compare` c LEFT JOIN `vtny_stfeature_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = XX
2 queries	SELECT * FROM `vtny_link_block` a LEFT JOIN `vtny_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_link_block_lang` WHERE `id_link_block` = XX

#	Query	Time (ms)	Rows	Filesort	Group By	Location
75	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_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 p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN vtny_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=5)) GROUP BY pac.id_attribute	3.385 ms	259200	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1028	INSERT INTO `vtny_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('8008', '', 'caffe.solnetwork.it/en/brand/5-illy?q=Offer-216+Capsules-108+Cialde', '', '2026-04-01 21:27:34')	2.199 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:1077 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:400 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:134 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
74	SELECT SQL_NO_CACHE cp.id_category, 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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (26, 56))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<341 GROUP BY cp.id_category	1.780 ms	11616	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
126	SELECT SQL_NO_CACHE pa.`available_date` FROM `vtny_product` p LEFT JOIN `vtny_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN vtny_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 12 AND pa.`id_product` = 12 AND pa.`id_product_attribute` = 619 LIMIT 1	1.763 ms	1			/classes/Product.php:1209 /classes/Product.php:5814 (getAvailableDate) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
123	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 SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `vtny_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 12 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `vtny_cart_product` cp JOIN `vtny_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `vtny_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 12 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	1.665 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5798 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE p.condition, 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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (26, 56))) GROUP BY p.condition	1.572 ms	3872	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	REPLACE INTO vtny_layered_filter_block (hash, data) VALUES ("d0e0175bd657424aefaed0c18320bcb4", "a:1:{s:7:\"filters\";a:8:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:20;}i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:50;s:3:\"min\";d:30;s:4:\"unit\";s:0:\"\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:0:\"\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:21;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:2:{i:25;a:2:{s:4:\"name\";s:33:\"illy Iperespresso Coffee Capsules\";s:3:\"nbr\";i:16;}i:76;a:2:{s:4:\"name\";s:22:\"illy Coffee Paper Pods\";s:3:\"nbr\";i:5;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:2;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:5;s:4:\"name\";s:5:\"Offer\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:12:{i:64;a:4:{s:4:\"name\";s:10:\"21 capsule\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:33;a:4:{s:4:\"name\";s:11:\"100 Capsule\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:4:{s:4:\"name\";s:12:\"108 Capsules\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:63;a:4:{s:4:\"name\";s:11:\"126 capsule\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:34;a:4:{s:4:\"name\";s:11:\"200 Capsule\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:26;a:5:{s:4:\"name\";s:12:\"216 Capsules\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:35;a:4:{s:4:\"name\";s:11:\"300 Capsule\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:27;a:4:{s:4:\"name\";s:12:\"324 Capsules\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:81;a:4:{s:4:\"name\";s:11:\"432 Capsule\";s:3:\"nbr\";i:13;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:82;a:4:{s:4:\"name\";s:11:\"540 Capsule\";s:3:\"nbr\";i:13;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:56;a:5:{s:4:\"name\";s:10:\"108 Cialde\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:80;a:4:{s:4:\"name\";s:10:\"216 Cialde\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";i:21;}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:1:{i:5;a:2:{s:4:\"name\";s:4:\"ILLY\";s:3:\"nbr\";i:21;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:2.5;s:3:\"min\";d:0.26500000000000001332267629550187848508358001708984375;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:21;}}}")	1.513 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) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
65	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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) LEFT JOIN vtny_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2))) AND ((pac_1.id_attribute IN (26, 56)))	1.493 ms	3872			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `vtny_module` m INNER JOIN vtny_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 `vtny_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `vtny_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `vtny_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`	1.472 ms	392	Yes	Yes	/classes/Hook.php:1267 /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:28 (getInstance)
93	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `vtny_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `vtny_hook_alias` ha INNER JOIN `vtny_hook` h ON ha.name = h.name	1.471 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
63	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1.420 ms	11616	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
675	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `vtny_category` c INNER JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `vtny_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 nleft >= 2 AND nright <= 341 AND c.id_category IN ( SELECT id_category FROM `vtny_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	1.362 ms	171	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:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:285 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
67	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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.quantity>0)) AND ((pac_1.id_attribute IN (26, 56)))	1.353 ms	3872			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
66	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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0)) AND ((pac_1.id_attribute IN (26, 56)))	1.241 ms	3872			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE p.id_manufacturer, 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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (26, 56))) GROUP BY p.id_manufacturer	1.233 ms	3872	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
69	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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (26, 56))) AND p.date_add>'2026-03-13 00:00:00'	1.142 ms	3872			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
68	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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((p.on_sale=1)) AND ((pac_1.id_attribute IN (26, 56)))	1.112 ms	3872			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
895	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 13 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	1.039 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
769	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1001 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.947 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	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 `vtny_hook_module` hm STRAIGHT_JOIN `vtny_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `vtny_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.936 ms	425			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
70	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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 2) AND sp.id_country IN (0, 10) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2026-04-01 21:27:33' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-04-01 21:27:33' <= sp.to) ) LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((sp.reduction>0)) AND ((pac_1.id_attribute IN (26, 56)))	0.881 ms	36			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
77	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `vtny_manufacturer` m INNER JOIN vtny_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `vtny_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.840 ms	38	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-04-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM vtny_product p LEFT JOIN vtny_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN vtny_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN vtny_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (709,12,1001,8,910,18,15,293,13,388,9,16)	0.830 ms	12			/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) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1007	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE c.`id_category` IN (SELECT DISTINCT `id_category` FROM `vtny_category_product` WHERE 1) AND c.`active` = 1 AND cl.`id_lang` = 1	0.820 ms	6248			/modules/cp_salenotification/cp_salenotification.php:479 /modules/cp_salenotification/cp_salenotification.php:361 (getCategory) /classes/Hook.php:1077 (hookdisplayFooter) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/79/2b/15/792b152cfc1ff0b7b26ad1325bfe97dc8a5fba4c_2.file.footer.tpl.php:83 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/79/2b/15/792b152cfc1ff0b7b26ad1325bfe97dc8a5fba4c_2.file.footer.tpl.php:46 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a423c747b4_14960322) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:364 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:123 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
832	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 18 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.800 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
810	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 910 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.785 ms	2	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
920	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 388 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.779 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
970	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 16 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.772 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	SELECT SQL_NO_CACHE pac.id_attribute, 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, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_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 vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN vtny_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN vtny_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((a.id_attribute_group=3)) AND ((pac_1.id_attribute IN (26, 56))) GROUP BY pac.id_attribute	0.768 ms	3872	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
791	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 8 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.763 ms	2	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
71	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM vtny_product p INNER JOIN vtny_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 10) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (26, 56))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='5'	0.761 ms	44			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
873	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 293 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.746 ms	2	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
778	SELECT SQL_NO_CACHE pa., product_attribute_shop. FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 8 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`	0.739 ms	2	Yes	Yes	/classes/Product.php:2734 /src/Adapter/Presenter/Product/ProductLazyArray.php:667 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/5a/fc/ed/5afced99b8fa46df71fafd616254c72b97e9ace0_2.file.product-flags.tpl.php:44 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/5a/fc/ed/5afced99b8fa46df71fafd616254c72b97e9ace0_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b67b11_56470283) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
23	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `vtny_meta` m LEFT JOIN `vtny_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.723 ms	96	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
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 `vtny_configuration` c LEFT JOIN `vtny_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	0.679 ms	1176			/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:27 (require)
704	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 709 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.676 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
885	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 `vtny_product_attribute` pa INNER JOIN vtny_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 `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (13) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.632 ms	5	Yes	Yes	/classes/Product.php:4520 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:45 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
797	SELECT SQL_NO_CACHE pa., product_attribute_shop. FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 910 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`	0.631 ms	2	Yes	Yes	/classes/Product.php:2734 /src/Adapter/Presenter/Product/ProductLazyArray.php:667 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/5a/fc/ed/5afced99b8fa46df71fafd616254c72b97e9ace0_2.file.product-flags.tpl.php:44 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/5a/fc/ed/5afced99b8fa46df71fafd616254c72b97e9ace0_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b67b11_56470283) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
61	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `vtny_attribute_group` ag INNER JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `vtny_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN vtny_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `vtny_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC	0.628 ms	64	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
854	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 15 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.625 ms	2	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/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/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/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/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

Name	Instances	Source
Category	145	/modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 1] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 2] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 190] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 14] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 131] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 71] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 138] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 72] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 73] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 76] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 146] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 75] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 116] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 124] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 137] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 74] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 162] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 166] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 139] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 178] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 167] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 110] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 12] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 101] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 25] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 192] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 24] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 23] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 22] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 26] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 27] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 185] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 13] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 32] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 151] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 47] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 104] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 147] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 48] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 143] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 51] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 136] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 168] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 140] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 120] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 158] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 171] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 159] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 37] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 70] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 177] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 31] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 38] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 103] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 39] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 41] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 40] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 45] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 34] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 62] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 63] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 35] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 149] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 108] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 66] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 119] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 68] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 144] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 170] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 33] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 153] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 53] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 55] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 172] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 148] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 58] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 54] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 56] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 163] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 57] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 169] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 179] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 141] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 132] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 36] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 160] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 117] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 118] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 134] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 135] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 161] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 18] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 152] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 79] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 184] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 80] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 83] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 81] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 127] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 107] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 180] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 114] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 173] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 188] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 82] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 157] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 181] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 183] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 186] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 19] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 122] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 125] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 126] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 142] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 91] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 155] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 94] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 165] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 176] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 98] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 99] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 164] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 189] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 20] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 86] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 87] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 88] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 89] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 109] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 115] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 174] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 123] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 128] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 129] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 130] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 113] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 175] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 191] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 187] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 193] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 194] /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) [id: 195] /modules/ps_categorytree/ps_categorytree.php:340 (__construct) [id: 2] /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:271 (__construct) [id: 10]
AttributeGroupCore	90	/modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5]
Product	67	/classes/Link.php:113 (__construct) [id: 293] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 709] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 12] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1001] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 910] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 18] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 15] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 293] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 13] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 388] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 16] /classes/Link.php:113 (__construct) [id: 709] /classes/Link.php:113 (__construct) [id: 12] /classes/Link.php:113 (__construct) [id: 1001] /classes/Link.php:113 (__construct) [id: 8] /classes/Link.php:113 (__construct) [id: 910] /classes/Link.php:113 (__construct) [id: 18] /classes/Link.php:113 (__construct) [id: 15] /classes/Link.php:113 (__construct) [id: 293] /classes/Link.php:113 (__construct) [id: 13] /classes/Link.php:113 (__construct) [id: 388] /classes/Link.php:113 (__construct) [id: 9] /classes/Link.php:113 (__construct) [id: 16] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 709] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 709] /modules/pla/pla.php:1578 (__construct) [id: 709] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 12] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 12] /modules/pla/pla.php:1578 (__construct) [id: 12] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1001] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1001] /modules/pla/pla.php:1578 (__construct) [id: 1001] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 8] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 8] /modules/pla/pla.php:1578 (__construct) [id: 8] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 910] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 910] /modules/pla/pla.php:1578 (__construct) [id: 910] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 18] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 18] /modules/pla/pla.php:1578 (__construct) [id: 18] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 15] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 15] /modules/pla/pla.php:1578 (__construct) [id: 15] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 293] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 293] /modules/pla/pla.php:1578 (__construct) [id: 293] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 13] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 13] /modules/pla/pla.php:1578 (__construct) [id: 13] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 388] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 388] /modules/pla/pla.php:1578 (__construct) [id: 388] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 9] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 9] /modules/pla/pla.php:1578 (__construct) [id: 9] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 16] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 16] /modules/pla/pla.php:1578 (__construct) [id: 16] /classes/Link.php:113 (__construct) [id: 340] /classes/Link.php:113 (__construct) [id: 717] /classes/Link.php:113 (__construct) [id: 946] /classes/Link.php:113 (__construct) [id: 1045] /classes/Link.php:113 (__construct) [id: 361] /classes/Link.php:113 (__construct) [id: 1369]
ProductAttribute	45	/modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 56] /modules/pla/pla.php:1639 (__construct) [id: 80] /modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 56] /modules/pla/pla.php:1639 (__construct) [id: 80] /modules/pla/pla.php:1639 (__construct) [id: 80] /modules/pla/pla.php:1639 (__construct) [id: 56] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82] /modules/pla/pla.php:1639 (__construct) [id: 56] /modules/pla/pla.php:1639 (__construct) [id: 80] /modules/pla/pla.php:1639 (__construct) [id: 80] /modules/pla/pla.php:1639 (__construct) [id: 56] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82] /modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82] /modules/pla/pla.php:1639 (__construct) [id: 25] /modules/pla/pla.php:1639 (__construct) [id: 26] /modules/pla/pla.php:1639 (__construct) [id: 27] /modules/pla/pla.php:1639 (__construct) [id: 81] /modules/pla/pla.php:1639 (__construct) [id: 82]
Manufacturer	20	/controllers/front/listing/ManufacturerController.php:65 (__construct) [id: 5] /classes/Meta.php:421 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5] /classes/Link.php:657 (__construct) [id: 5]
Address	16	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5960 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ]
Combination	12	/classes/Product.php:5908 (__construct) [id: 1472] /classes/Product.php:5908 (__construct) [id: 619] /classes/Product.php:5908 (__construct) [id: 1885] /classes/Product.php:5908 (__construct) [id: 617] /classes/Product.php:5908 (__construct) [id: 1834] /classes/Product.php:5908 (__construct) [id: 37] /classes/Product.php:5908 (__construct) [id: 621] /classes/Product.php:5908 (__construct) [id: 624] /classes/Product.php:5908 (__construct) [id: 21] /classes/Product.php:5908 (__construct) [id: 968] /classes/Product.php:5908 (__construct) [id: 13] /classes/Product.php:5908 (__construct) [id: 29]
AttributeGroup	12	/modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5]
CMS	6	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 1] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 2] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 3] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 4] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 5]
Country	5	/config/config.inc.php:146 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /classes/controller/FrontController.php:1767 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 10]
State	4	/classes/AddressFormat.php:404 (__construct) [id: 0] /classes/controller/FrontController.php:1766 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /classes/AddressFormat.php:404 (__construct) [id: 0]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:641 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
AddressFormat	2	/classes/controller/FrontController.php:1761 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45]
PrestaShop\Module\LinkList\Model\LinkBlock	2	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 1] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
12	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/polyfill-mbstring/bootstrap.php
15	/vendor/symfony/polyfill-mbstring/bootstrap80.php
16	/vendor/symfony/polyfill-php80/bootstrap.php
17	/vendor/symfony/polyfill-ctype/bootstrap.php
18	/vendor/symfony/polyfill-ctype/bootstrap80.php
19	/vendor/symfony/deprecation-contracts/function.php
20	/vendor/guzzlehttp/promises/src/functions_include.php
21	/vendor/guzzlehttp/promises/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ralouphie/getallheaders/src/getallheaders.php
24	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
25	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
26	/vendor/guzzlehttp/guzzle/src/functions_include.php
27	/vendor/guzzlehttp/guzzle/src/functions.php
28	/vendor/symfony/polyfill-php81/bootstrap.php
29	/vendor/symfony/polyfill-php73/bootstrap.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/lcobucci/jwt/compat/class-aliases.php
32	/vendor/lcobucci/jwt/src/Token.php
33	/vendor/lcobucci/jwt/src/Signature.php
34	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
35	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
36	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
37	/vendor/jakeasmith/http_build_url/src/http_build_url.php
38	/vendor/prestashop/laminas-code-lts/polyfill/ReflectionEnumPolyfill.php
39	/vendor/ircmaxell/password-compat/lib/password.php

shop by category

Home  

Left Banner  

List of products by brand ILLY

Original illy ESE Paper Pods 44 mm MEDIUM ROAST 100% Arabica

Original illy ESE Paper Pods 44 mm DARK ROAST 100% Arabica

Original illy ESE Paper Pods 44 mm MEDIUM ROAST 100% Arabica

Original illy ESE Paper Pods 44 mm DECAFFEINATED 100% Arabica

Original illy ESE Paper Pods 44 mm Tasting Kit 100% Arabica

illy iperEspresso Coffee Capsules Lungo in Box of 18 100% Arabica

Stopwatch SQL - 1043 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Home

Left Banner