Elenco dei prodotti per la marca LAVAZZA

Lavazza Caffè in Cialda e Capsule Point, Blue in Black, A Modo Mio in Offerta.

Capsule e Cialde Lavazza Originali al miglio prezzo, in offerta, con trasporto Gratuito in Italia. DISTRIBUTORI UFFICIALI CAMPANIA!

Lavazza Espresso Point Capsule Crema Aroma

Non disponibile

LAVAZZA Capsule Lavazza Espresso Point 100 Crema e Aroma

Offerte

Lavazza Crema & Aroma in Capsule Originali Espresso Point. Capsule e Cialde Lavazza Espresso Point Crema e Aroma!

106,90 €

Out of Stock

Caffè Lavazza Espresso Point Capsule 100 Aroma Club

Non disponibile

LAVAZZA Capsule Lavazza Espresso Point 100 Aroma Club

Offerte

Lavazza Aroma Club 100% Arabica in Capsule Originali Espresso Point. Capsule e Cialde Lavazza Espresso Point Aroma Club 100% Arabica!

109,90 €

Out of Stock

Caffè Lavazza Espresso Point Capsule 100 Aroma Point

Non disponibile

LAVAZZA Capsule Lavazza Espresso Point 100 Aroma Point

Offerte

Lavazza Aroma Point in Capsula Originale Espresso Point

108,90 €

Out of Stock

Caffè in grani Lavazza Vending Gusto forte

LAVAZZA Caffè in Grani Lavazza Espresso Gusto Forte 3Kg

Offerte

Lavazza Caffè in Grani Chicchi miscela Forte, in offerta al miglior prezzo! Caffè in grani Lavazza miscela Forte un buste da 1 chilo!

189,90 €

In Stock 159 Products

Caffè Lavazza Espresso Point Capsule 100 Tierra

Non disponibile

LAVAZZA Capsule Lavazza Espresso Point 100 Tierra

Offerte

Lavazza Tierra in Capsula Originale Espresso Point

112,00 €

Out of Stock

Caffè Lavazza Espresso Point Capsule 100 Forte e Deciso

Non disponibile

LAVAZZA Capsule Lavazza Espresso Point 100 Forte e Deciso

Offerte

Lavazza Forte e Deciso in Capsula Originale Espresso Point.

91,00 €

Out of Stock

Capsule Lavazza Espresso Point Aroma e Gusto

Non disponibile

LAVAZZA Capsule Lavazza Espresso Point 100 Aroma e Gusto

Offerte

Lavazza Aroma e Gusto in Capsule Originali Espresso Point. Capsule e Cialde Lavazza Espresso Point Aroma e Gusto!

84,00 €

Out of Stock

LAVAZZA Caffè in Grani Lavazza Pieno 3 Chili

Offerte

Lavazza Caffè a Chicchi Gusto Pieno busta da 1 Kg. Caffè in grani Lavazza Gusto Pieno, per casa, bar e distributori automatici!

224,90 €

In Stock 142 Products

LAVAZZA Caffè in Grani Lavazza Crema e Aroma 3 Kg

Offerte

Caffe in Grani Lavazza miscela Crema & Aroma, in offerta! Lavazza Caffè in grani pronto da macinare, per uso domestico e professionale!

217,90 €

In Stock 58 Products

Caffè Lavazza in Grani Aroma Top Arabica

LAVAZZA Caffè in Grani Lavazza Aroma Top 100% Arabica 3 Kg

Offerte

Caffe in Grani Lavazza miscela Aroma Top, in offerta! Lavazza Caffè in grani pronto da macinare, per uso domestico e professionale!

256,90 €

In Stock 58 Products

LAVAZZA Caffè in Grani Lavazza Crema Ricca 3 Kg

Offerte

Caffe in Grani Lavazza miscela Crema Ricca, in offerta! Lavazza Caffè in grani pronto da macinare, per uso domestico e professionale!

229,90 €

In Stock 58 Products

LAVAZZA Caffè in Grani Lavazza Crema Classica 3 Kg

Offerte

Caffe in Grani Lavazza miscela Crema Classica, in offerta! Lavazza Caffè in grani pronto da macinare, per uso domestico e professionale!

217,90 €

In Stock 42 Products

Load Time	511.670 ms
Querying Time	292 ms
Queries	1063
Memory Peak Usage	30.0 Mb
Included Files	775 files - 10.08 Mb
PrestaShop Cache	- Mb
Global vars	0.05 Mb
- global $_MODULES	17k
- global $_SERVER	8k
- global $smarty	5k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- global $_COOKIE	1k
- 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.306 ms	2.306 ms	2.15 Mb	2.6 Mb
__construct	0.024 ms	2.330 ms	- Mb	2.6 Mb
init	23.918 ms	26.248 ms	0.43 Mb	2.9 Mb
checkAccess	0.001 ms	26.249 ms	- Mb	2.9 Mb
setMedia	3.294 ms	29.543 ms	0.18 Mb	2.9 Mb
postProcess	0.002 ms	29.545 ms	- Mb	2.9 Mb
initHeader	0.002 ms	29.547 ms	- Mb	2.9 Mb
initContent	166.019 ms	195.566 ms	4.82 Mb	7.6 Mb
initFooter	0.002 ms	195.568 ms	- Mb	7.6 Mb
display	316.102 ms	511.670 ms	21.45 Mb	30.0 Mb

Hook	Time	Memory Usage
displayHeaderCenter	103.081 ms	6.80 Mb
=> cp_blocksearch (widget)	103.081 ms	6.80 Mb
DisplayProductListReviews	69.103 ms	6.97 Mb
=> pla	10.420 ms	1.32 Mb
=> pla	5.496 ms	0.55 Mb
=> pla	5.700 ms	0.55 Mb
=> pla	4.999 ms	0.65 Mb
=> pla	3.837 ms	0.55 Mb
=> pla	5.924 ms	0.55 Mb
=> pla	7.106 ms	0.56 Mb
=> pla	4.829 ms	0.45 Mb
=> pla	6.277 ms	0.45 Mb
=> pla	5.348 ms	0.45 Mb
=> pla	5.539 ms	0.45 Mb
=> pla	3.628 ms	0.45 Mb
DisplayCpHoverImage	12.602 ms	0.41 Mb
=> cp_imagehover	1.072 ms	0.03 Mb
=> cp_imagehover	1.143 ms	0.04 Mb
=> cp_imagehover	0.935 ms	0.03 Mb
=> cp_imagehover	1.275 ms	0.04 Mb
=> cp_imagehover	0.770 ms	0.03 Mb
=> cp_imagehover	0.650 ms	0.03 Mb
=> cp_imagehover	0.770 ms	0.03 Mb
=> cp_imagehover	1.326 ms	0.04 Mb
=> cp_imagehover	1.096 ms	0.04 Mb
=> cp_imagehover	1.381 ms	0.04 Mb
=> cp_imagehover	1.265 ms	0.04 Mb
=> cp_imagehover	0.919 ms	0.03 Mb
displayNavFullWidth	10.836 ms	1.00 Mb
=> cp_sideverticalmenu (widget)	8.336 ms	0.77 Mb
=> ps_mainmenu (widget)	1.107 ms	0.16 Mb
=> cp_headercms2 (widget)	1.393 ms	0.06 Mb
DisplayStCompareButton	10.051 ms	0.03 Mb
=> stfeature	0.497 ms	0.01 Mb
=> stfeature	0.298 ms	- Mb
=> stfeature	0.363 ms	- Mb
=> stfeature	0.452 ms	- Mb
=> stfeature	0.527 ms	- Mb
=> stfeature	0.352 ms	- Mb
=> stfeature	0.427 ms	- Mb
=> stfeature	0.416 ms	- Mb
=> stfeature	0.392 ms	- Mb
=> stfeature	0.318 ms	- Mb
=> stfeature	0.383 ms	- Mb
=> stfeature	0.404 ms	- Mb
=> stfeature	0.514 ms	- Mb
=> stfeature	0.354 ms	- Mb
=> stfeature	0.561 ms	- Mb
=> stfeature	0.625 ms	- Mb
=> stfeature	0.412 ms	- Mb
=> stfeature	0.386 ms	- Mb
=> stfeature	0.414 ms	- Mb
=> stfeature	0.374 ms	- Mb
=> stfeature	0.396 ms	- Mb
=> stfeature	0.437 ms	- Mb
=> stfeature	0.413 ms	- Mb
=> stfeature	0.336 ms	- Mb
displayFooter	7.787 ms	0.73 Mb
=> ps_linklist (widget)	6.636 ms	0.65 Mb
=> cp_themeoptions (widget)	1.151 ms	0.08 Mb
DisplayStWishlistButton	7.548 ms	0.03 Mb
=> stfeature	0.414 ms	0.01 Mb
=> stfeature	0.274 ms	- Mb
=> stfeature	0.276 ms	- Mb
=> stfeature	0.314 ms	- Mb
=> stfeature	0.422 ms	- Mb
=> stfeature	0.266 ms	- Mb
=> stfeature	0.270 ms	- Mb
=> stfeature	0.293 ms	- Mb
=> stfeature	0.250 ms	- Mb
=> stfeature	0.237 ms	- Mb
=> stfeature	0.287 ms	- Mb
=> stfeature	0.281 ms	- Mb
=> stfeature	0.472 ms	- Mb
=> stfeature	0.332 ms	- Mb
=> stfeature	0.303 ms	- Mb
=> stfeature	0.451 ms	- Mb
=> stfeature	0.259 ms	- Mb
=> stfeature	0.247 ms	- Mb
=> stfeature	0.357 ms	- Mb
=> stfeature	0.297 ms	- Mb
=> stfeature	0.349 ms	- Mb
=> stfeature	0.305 ms	- Mb
=> stfeature	0.271 ms	- Mb
=> stfeature	0.321 ms	- Mb
DisplayBeforeBodyClosingTag	7.467 ms	0.32 Mb
=> statsdata	2.649 ms	0.04 Mb
=> ps_googleanalytics	4.818 ms	0.27 Mb
DisplayFooter	6.597 ms	0.40 Mb
=> cpcouponpop	0.009 ms	- Mb
=> cp_salenotification	6.588 ms	0.40 Mb
displayLeftColumn	5.909 ms	0.41 Mb
=> ps_categorytree (widget)	3.210 ms	0.38 Mb
=> cp_leftbanner1 (widget)	1.504 ms	- Mb
=> cp_sidebarfeaturedproducts (widget)	1.195 ms	0.08 Mb
displayNav2	3.541 ms	0.20 Mb
=> ps_languageselector (widget)	1.041 ms	0.05 Mb
=> ps_currencyselector (widget)	1.596 ms	0.11 Mb
=> ps_customersignin (widget)	0.904 ms	0.04 Mb
displaySide	3.473 ms	0.06 Mb
=> ps_currencyselector (widget)	1.593 ms	0.03 Mb
=> ps_languageselector (widget)	0.935 ms	0.01 Mb
=> cp_headercms1 (widget)	0.945 ms	0.02 Mb
displayHeaderRight	3.253 ms	0.13 Mb
=> ps_shoppingcart (widget)	3.253 ms	0.13 Mb
Header	2.787 ms	0.04 Mb
=> pla	0.576 ms	- Mb
=> cp_blocksearch	0.506 ms	- Mb
=> cp_salenotification	0.156 ms	- Mb
=> cp_themeoptions	1.261 ms	0.02 Mb
=> stfeature	0.288 ms	0.01 Mb
displayFooterleft	2.023 ms	0.10 Mb
=> ps_contactinfo (widget)	1.135 ms	0.06 Mb
=> ps_socialfollow (widget)	0.888 ms	0.04 Mb
DisplayStCompareTopLink	1.983 ms	0.06 Mb
=> stfeature	1.189 ms	0.04 Mb
=> stfeature	0.794 ms	0.03 Mb
DisplayHeader	1.752 ms	0.01 Mb
=> ps_shoppingcart	0.151 ms	- Mb
=> ps_googleanalytics	0.159 ms	- Mb
=> cp_imageslider	0.229 ms	- Mb
=> cp_categorylist	0.129 ms	- Mb
=> cp_categoryproductsslider	0.171 ms	- Mb
=> cpcouponpop	0.009 ms	- Mb
=> cp_countdown	0.221 ms	- Mb
=> ets_blog	0.572 ms	- Mb
=> cp_sideverticalmenu	0.111 ms	- Mb
DisplayStWishlistTopLink	1.244 ms	0.04 Mb
=> stfeature	0.859 ms	0.03 Mb
=> stfeature	0.385 ms	- Mb
displayFooterAfter	1.242 ms	0.06 Mb
=> cp_footercms1 (widget)	1.242 ms	0.06 Mb
displayNav1	1.208 ms	0.09 Mb
=> cp_headercms1 (widget)	1.208 ms	0.09 Mb
displayFooterbefore	1.025 ms	0.05 Mb
=> ps_emailsubscription (widget)	1.025 ms	0.05 Mb
ProductSearchProvider	0.993 ms	- Mb
=> ps_facetedsearch	0.993 ms	- Mb
ActionFrontControllerSetMedia	0.785 ms	0.01 Mb
=> blockreassurance	0.400 ms	- Mb
=> ps_emailsubscription	0.104 ms	- Mb
=> ps_socialfollow	0.118 ms	- Mb
=> ps_emailalerts	0.163 ms	- Mb
displayCustomerSide	0.590 ms	- Mb
=> ps_customersignin (widget)	0.590 ms	- Mb
DisplayFooterAfter	0.515 ms	0.04 Mb
=> cp_themeoptions	0.515 ms	0.04 Mb
Footer	0.479 ms	0.09 Mb
=> cp_cookie	0.479 ms	0.09 Mb
DisplayLeftColumn	0.276 ms	0.04 Mb
=> ps_facetedsearch	0.276 ms	0.04 Mb
ModuleRoutes	0.015 ms	0.01 Mb
=> ets_blog	0.015 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.010 ms	- Mb
=> blockreassurance	0.010 ms	- Mb
29 hook(s)	268.176 ms	18.11 Mb

Module	Time	Memory Usage
ets_blog	4.979 ms	0.01 Mb
__construct	4.389 ms	- Mb
hookModuleRoutes	0.017 ms	0.01 Mb
hookDisplayHeader	0.573 ms	- Mb
blockreassurance	1.144 ms	0.08 Mb
__construct	0.728 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.403 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.013 ms	- Mb
ps_emailsubscription	1.262 ms	0.06 Mb
__construct	0.128 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.105 ms	- Mb
displayFooterbefore	1.029 ms	0.05 Mb
ps_socialfollow	1.091 ms	0.05 Mb
__construct	0.081 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.119 ms	- Mb
displayFooterleft	0.891 ms	0.04 Mb
ps_emailalerts	0.408 ms	0.07 Mb
__construct	0.244 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.164 ms	- Mb
ps_shoppingcart	3.531 ms	0.14 Mb
__construct	0.121 ms	0.01 Mb
hookDisplayHeader	0.155 ms	- Mb
displayHeaderRight	3.255 ms	0.13 Mb
ps_googleanalytics	5.116 ms	0.28 Mb
__construct	0.134 ms	0.01 Mb
hookDisplayHeader	0.160 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.822 ms	0.27 Mb
cp_imageslider	0.548 ms	0.01 Mb
__construct	0.318 ms	0.01 Mb
hookDisplayHeader	0.230 ms	- Mb
cp_categorylist	0.281 ms	0.01 Mb
__construct	0.152 ms	0.01 Mb
hookDisplayHeader	0.129 ms	- Mb
cp_categoryproductsslider	0.353 ms	0.01 Mb
__construct	0.181 ms	0.01 Mb
hookDisplayHeader	0.172 ms	- Mb
cpcouponpop	0.274 ms	0.01 Mb
__construct	0.254 ms	0.01 Mb
hookDisplayHeader	0.010 ms	- Mb
hookDisplayFooter	0.010 ms	- Mb
cp_countdown	0.393 ms	0.01 Mb
__construct	0.172 ms	0.01 Mb
hookDisplayHeader	0.221 ms	- Mb
pla	70.096 ms	6.98 Mb
__construct	0.346 ms	0.01 Mb
hookHeader	0.577 ms	- Mb
hookDisplayProductListReviews	10.423 ms	1.32 Mb
hookDisplayProductListReviews	5.505 ms	0.55 Mb
hookDisplayProductListReviews	5.706 ms	0.55 Mb
hookDisplayProductListReviews	5.004 ms	0.65 Mb
hookDisplayProductListReviews	3.842 ms	0.55 Mb
hookDisplayProductListReviews	5.933 ms	0.55 Mb
hookDisplayProductListReviews	7.110 ms	0.56 Mb
hookDisplayProductListReviews	4.835 ms	0.45 Mb
hookDisplayProductListReviews	6.283 ms	0.45 Mb
hookDisplayProductListReviews	5.354 ms	0.45 Mb
hookDisplayProductListReviews	5.545 ms	0.45 Mb
hookDisplayProductListReviews	3.632 ms	0.45 Mb
cp_blocksearch	103.828 ms	6.81 Mb
__construct	0.233 ms	0.01 Mb
hookHeader	0.508 ms	- Mb
displayHeaderCenter	103.087 ms	6.80 Mb
cp_sideverticalmenu	8.743 ms	0.78 Mb
__construct	0.293 ms	0.01 Mb
hookDisplayHeader	0.113 ms	- Mb
displayNavFullWidth	8.337 ms	0.77 Mb
cp_salenotification	6.834 ms	0.41 Mb
__construct	0.085 ms	0.01 Mb
hookHeader	0.157 ms	- Mb
hookDisplayFooter	6.592 ms	0.40 Mb
cp_themeoptions	3.373 ms	0.17 Mb
__construct	0.440 ms	0.03 Mb
hookHeader	1.263 ms	0.02 Mb
displayFooter	1.154 ms	0.08 Mb
hookDisplayFooterAfter	0.516 ms	0.04 Mb
stfeature	21.561 ms	0.21 Mb
__construct	0.300 ms	0.02 Mb
hookHeader	0.288 ms	0.01 Mb
hookDisplayStCompareTopLink	1.193 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.861 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.388 ms	- Mb
hookDisplayStCompareTopLink	0.798 ms	0.03 Mb
hookDisplayStCompareButton	0.499 ms	0.01 Mb
hookDisplayStWishlistButton	0.416 ms	0.01 Mb
hookDisplayStCompareButton	0.300 ms	- Mb
hookDisplayStWishlistButton	0.275 ms	- Mb
hookDisplayStCompareButton	0.365 ms	- Mb
hookDisplayStWishlistButton	0.278 ms	- Mb
hookDisplayStCompareButton	0.455 ms	- Mb
hookDisplayStWishlistButton	0.318 ms	- Mb
hookDisplayStCompareButton	0.532 ms	- Mb
hookDisplayStWishlistButton	0.427 ms	- Mb
hookDisplayStCompareButton	0.356 ms	- Mb
hookDisplayStWishlistButton	0.269 ms	- Mb
hookDisplayStCompareButton	0.430 ms	- Mb
hookDisplayStWishlistButton	0.272 ms	- Mb
hookDisplayStCompareButton	0.419 ms	- Mb
hookDisplayStWishlistButton	0.295 ms	- Mb
hookDisplayStCompareButton	0.394 ms	- Mb
hookDisplayStWishlistButton	0.252 ms	- Mb
hookDisplayStCompareButton	0.319 ms	- Mb
hookDisplayStWishlistButton	0.238 ms	- Mb
hookDisplayStCompareButton	0.386 ms	- Mb
hookDisplayStWishlistButton	0.288 ms	- Mb
hookDisplayStCompareButton	0.408 ms	- Mb
hookDisplayStWishlistButton	0.284 ms	- Mb
hookDisplayStCompareButton	0.518 ms	- Mb
hookDisplayStWishlistButton	0.475 ms	- Mb
hookDisplayStCompareButton	0.358 ms	- Mb
hookDisplayStWishlistButton	0.334 ms	- Mb
hookDisplayStCompareButton	0.565 ms	- Mb
hookDisplayStWishlistButton	0.305 ms	- Mb
hookDisplayStCompareButton	0.630 ms	- Mb
hookDisplayStWishlistButton	0.455 ms	- Mb
hookDisplayStCompareButton	0.415 ms	- Mb
hookDisplayStWishlistButton	0.260 ms	- Mb
hookDisplayStCompareButton	0.389 ms	- Mb
hookDisplayStWishlistButton	0.250 ms	- Mb
hookDisplayStCompareButton	0.418 ms	- Mb
hookDisplayStWishlistButton	0.360 ms	- Mb
hookDisplayStCompareButton	0.376 ms	- Mb
hookDisplayStWishlistButton	0.299 ms	- Mb
hookDisplayStCompareButton	0.399 ms	- Mb
hookDisplayStWishlistButton	0.351 ms	- Mb
hookDisplayStCompareButton	0.440 ms	- Mb
hookDisplayStWishlistButton	0.309 ms	- Mb
hookDisplayStCompareButton	0.417 ms	- Mb
hookDisplayStWishlistButton	0.273 ms	- Mb
hookDisplayStCompareButton	0.339 ms	- Mb
hookDisplayStWishlistButton	0.323 ms	- Mb
ps_facetedsearch	2.475 ms	0.06 Mb
__construct	1.203 ms	0.01 Mb
hookProductSearchProvider	0.995 ms	- Mb
hookDisplayLeftColumn	0.277 ms	0.04 Mb
cp_headercms1	2.424 ms	0.12 Mb
__construct	0.264 ms	0.01 Mb
displayNav1	1.211 ms	0.09 Mb
displaySide	0.949 ms	0.02 Mb
ps_languageselector	2.087 ms	0.06 Mb
__construct	0.105 ms	0.01 Mb
displayNav2	1.044 ms	0.05 Mb
displaySide	0.938 ms	0.01 Mb
ps_currencyselector	3.296 ms	0.15 Mb
__construct	0.101 ms	0.01 Mb
displayNav2	1.598 ms	0.11 Mb
displaySide	1.597 ms	0.03 Mb
ps_customersignin	1.621 ms	0.05 Mb
__construct	0.120 ms	0.01 Mb
displayNav2	0.907 ms	0.04 Mb
displayCustomerSide	0.594 ms	- Mb
ps_mainmenu	1.349 ms	0.17 Mb
__construct	0.239 ms	0.01 Mb
displayNavFullWidth	1.110 ms	0.17 Mb
cp_headercms2	1.621 ms	0.07 Mb
__construct	0.226 ms	0.01 Mb
displayNavFullWidth	1.395 ms	0.07 Mb
ps_categorytree	3.355 ms	0.39 Mb
__construct	0.143 ms	0.01 Mb
displayLeftColumn	3.212 ms	0.38 Mb
cp_leftbanner1	1.712 ms	- Mb
__construct	0.206 ms	0.01 Mb
displayLeftColumn	1.506 ms	- Mb
cp_sidebarfeaturedproducts	1.366 ms	0.09 Mb
__construct	0.169 ms	0.01 Mb
displayLeftColumn	1.197 ms	0.08 Mb
cp_imagehover	12.973 ms	0.42 Mb
__construct	0.320 ms	0.01 Mb
hookDisplayCpHoverImage	1.075 ms	0.03 Mb
hookDisplayCpHoverImage	1.146 ms	0.04 Mb
hookDisplayCpHoverImage	0.942 ms	0.03 Mb
hookDisplayCpHoverImage	1.279 ms	0.04 Mb
hookDisplayCpHoverImage	0.773 ms	0.03 Mb
hookDisplayCpHoverImage	0.652 ms	0.03 Mb
hookDisplayCpHoverImage	0.775 ms	0.03 Mb
hookDisplayCpHoverImage	1.331 ms	0.04 Mb
hookDisplayCpHoverImage	1.100 ms	0.04 Mb
hookDisplayCpHoverImage	1.386 ms	0.04 Mb
hookDisplayCpHoverImage	1.270 ms	0.04 Mb
hookDisplayCpHoverImage	0.924 ms	0.03 Mb
ps_contactinfo	1.312 ms	0.07 Mb
__construct	0.173 ms	0.01 Mb
displayFooterleft	1.139 ms	0.06 Mb
ps_linklist	7.834 ms	0.65 Mb
__construct	1.194 ms	0.01 Mb
displayFooter	6.640 ms	0.65 Mb
cp_cookie	0.768 ms	0.09 Mb
__construct	0.287 ms	0.01 Mb
hookFooter	0.481 ms	0.09 Mb
cp_footercms1	1.513 ms	0.07 Mb
__construct	0.267 ms	0.01 Mb
displayFooterAfter	1.246 ms	0.06 Mb
statsdata	2.779 ms	0.05 Mb
__construct	0.126 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	2.653 ms	0.05 Mb
34 module(s)	282.298 ms	18.54 Mb

shop by category

Home

Stendardo di sinistra

Elenco dei prodotti per la marca LAVAZZA

Lavazza Caffè in Cialda e Capsule Point, Blue in Black, A Modo Mio in Offerta.

Capsule e Cialde Lavazza Originali al miglio prezzo, in offerta, con trasporto Gratuito in Italia. DISTRIBUTORI UFFICIALI CAMPANIA!

Contattaci

Prodotti

La nostra azienda

Stopwatch SQL - 1063 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
66 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
54 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
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 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, XX) AND il.`id_lang` = XX ORDER by i.`position`
12 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) AND il.`id_lang` = XX ORDER by i.`position`
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
9 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
9 queries	SELECT * FROM `vtny_attribute_lang` WHERE `id_attribute` = XX
6 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,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
6 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) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
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 * 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` = 'it-it' OR `language_code` = 'it-it' LIMIT XX
3 queries	SELECT * FROM `vtny_cpheadercmsXXblockinfo_lang` 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
63	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59)))	2.091 ms	551120			/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)
73	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='6' 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	2.089 ms	399618	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)
80	REPLACE INTO vtny_layered_filter_block (hash, data) VALUES ("cb44ef75e38fd64e12b42ac9526e8daa", "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:14:\"Disponibilità\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:12:\"In magazzino\";s:3:\"nbr\";i:6;}i:0;a:2:{s:4:\"name\";s:15:\"Non disponibile\";s:3:\"nbr\";i:8;}}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:9:\"Selezioni\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:8:\"In saldo\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuovo prodotto\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:8:\"Scontato\";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:6:\"Prezzo\";s:3:\"max\";d:68;s:3:\"min\";d:21;s:4:\"unit\";s:3:\"€\";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:3:\"€\";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:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##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:14;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:9:\"Categorie\";s:6:\"values\";a:2:{i:22;a:2:{s:4:\"name\";s:31:\"Capsule Lavazza Espresso Point \";s:3:\"nbr\";i:6;}i:114;a:2:{s:4:\"name\";s:13:\"Grani Lavazza\";s:3:\"nbr\";i:8;}}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:7:\"Offerta\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:18:{i:33;a:4:{s:4:\"name\";s:11:\"100 Capsule\";s:3:\"nbr\";i:18;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:68;a:4:{s:4:\"name\";s:11:\"180 Capsule\";s:3:\"nbr\";i:8;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:18;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:35;a:4:{s:4:\"name\";s:11:\"300 Capsule\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:69;a:4:{s:4:\"name\";s:11:\"360 Capsule\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:36;a:4:{s:4:\"name\";s:11:\"400 Capsule\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:37;a:5:{s:4:\"name\";s:11:\"500 Capsule\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:38;a:5:{s:4:\"name\";s:11:\"600 Capsule\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:73;a:4:{s:4:\"name\";s:10:\"100 Cialde\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:32;a:4:{s:4:\"name\";s:10:\"150 Cialde\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:74;a:4:{s:4:\"name\";s:10:\"200 Cialde\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:29;a:4:{s:4:\"name\";s:10:\"300 Cialde\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:75;a:4:{s:4:\"name\";s:10:\"400 Cialde\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:30;a:4:{s:4:\"name\";s:10:\"450 Cialde\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:31;a:4:{s:4:\"name\";s:10:\"600 Cialde\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:58;a:4:{s:4:\"name\";s:4:\"3 Kg\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:57;a:4:{s:4:\"name\";s:4:\"6 Kg\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:59;a:5:{s:4:\"name\";s:5:\"12 Kg\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}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:10:\"Condizione\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuovo\";s:3:\"nbr\";i:14;}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usati\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:14:\"imesso a nuovo\";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:\"Marca\";s:6:\"values\";a:1:{i:6;a:2:{s:4:\"name\";s:7:\"LAVAZZA\";s:3:\"nbr\";i:14;}}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:4:\"Peso\";s:3:\"max\";d:3;s:3:\"min\";d:1.3899999999999999023003738329862244427204132080078125;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:14;}}}")	1.931 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)
64	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59)))	1.888 ms	551120			/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)
61	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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.851 ms	296808	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)
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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59)))	1.736 ms	551120			/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)
74	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59))) GROUP BY p.condition	1.653 ms	148404	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)
91	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.634 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)
72	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<341 GROUP BY cp.id_category	1.500 ms	296808	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)
673	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` = 2 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.451 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)
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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59)))	1.360 ms	551120			/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)
69	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6'	1.323 ms	894			/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)
1048	INSERT INTO `vtny_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('7035', '', 'caffe.solnetwork.it/it/brand/6-lavazza?q=Offerta-600+Capsule-12+Kg-500+Capsule', '', '2026-04-01 19:39:00')	1.317 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)
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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59))) AND p.date_add>'2026-03-13 00:00:00'	1.247 ms	551120			/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)
92	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	1.216 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)
76	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59))) GROUP BY p.id_manufacturer	1.174 ms	148404	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)
14	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.139 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)
929	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` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) 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` = 795 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.995 ms	3	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)
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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 19:39:00' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-04-01 19:39:00' <= 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 (37, 38, 59)))	0.931 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)
971	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` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) 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` = 838 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.904 ms	3	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)
1027	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` = 2	0.871 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)
77	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM vtny_product p 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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6'	0.857 ms	332			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:744 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /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)
21	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.852 ms	96	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
950	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` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) 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` = 798 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.836 ms	3	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)
75	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` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.811 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)
874	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` = 2) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (98) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.789 ms	6	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)
157	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` = 305 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` = 305 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.758 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)
79	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 (37, 38, 59))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='6' 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 (37, 38, 59))) GROUP BY pac.id_attribute	0.757 ms	697200	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)
775	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` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) 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` = 95 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.743 ms	6	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 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 = 2 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 (93,94,95,305,96,97,98,598,795,798,838,843)	0.740 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)
436	SELECT SQL_NO_CACHE 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 = 1 ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 2 AND c.`id_parent` = 185 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.739 ms	1	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (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/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:137 (__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/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4239401d8_62880707) /vendor/smarty/smarty/libs/sysplugins/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:206 (_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:58 (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)
193	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` = 97 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` = 97 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.737 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)
748	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` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) 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` = 94 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.719 ms	6	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)
247	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` = 795 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` = 795 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.718 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)
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.717 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)
229	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` = 598 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` = 598 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.687 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)
476	SELECT SQL_NO_CACHE 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 = 1 ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 2 AND c.`id_parent` = 31 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.673 ms	10	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (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/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:137 (__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/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4239401d8_62880707) /vendor/smarty/smarty/libs/sysplugins/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:206 (_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:58 (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)
571	SELECT SQL_NO_CACHE * FROM `vtny_category` a LEFT JOIN `vtny_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2 LEFT JOIN `vtny_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 107) AND (b.`id_shop` = 1) LIMIT 1	0.670 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /modules/cp_blocksearch/cp_blocksearch.php:167 (__construct) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (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/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:137 (__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/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4239401d8_62880707) /vendor/smarty/smarty/libs/sysplugins/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:206 (_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:58 (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)
915	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` = 795 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`	0.655 ms	3	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)
122	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` = 166 AND cp.`id_cart` = 0 AND cp.`id_product` = 94 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` = 166 AND cp.`id_cart` = 0 AND p.`id_product_item` = 94 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.653 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5810 (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)

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	108	/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] /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	66	/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 93] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 94] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 95] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 305] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 96] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 97] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 98] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 598] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 795] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 838] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 843] /classes/Link.php:113 (__construct) [id: 93] /classes/Link.php:113 (__construct) [id: 94] /classes/Link.php:113 (__construct) [id: 95] /classes/Link.php:113 (__construct) [id: 305] /classes/Link.php:113 (__construct) [id: 96] /classes/Link.php:113 (__construct) [id: 97] /classes/Link.php:113 (__construct) [id: 98] /classes/Link.php:113 (__construct) [id: 598] /classes/Link.php:113 (__construct) [id: 795] /classes/Link.php:113 (__construct) [id: 798] /classes/Link.php:113 (__construct) [id: 838] /classes/Link.php:113 (__construct) [id: 843] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 93] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 93] /modules/pla/pla.php:1578 (__construct) [id: 93] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 94] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 94] /modules/pla/pla.php:1578 (__construct) [id: 94] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 95] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 95] /modules/pla/pla.php:1578 (__construct) [id: 95] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 305] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 305] /modules/pla/pla.php:1578 (__construct) [id: 305] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 96] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 96] /modules/pla/pla.php:1578 (__construct) [id: 96] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 97] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 97] /modules/pla/pla.php:1578 (__construct) [id: 97] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 98] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 98] /modules/pla/pla.php:1578 (__construct) [id: 98] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 598] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 598] /modules/pla/pla.php:1578 (__construct) [id: 598] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 795] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 795] /modules/pla/pla.php:1578 (__construct) [id: 795] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 798] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 798] /modules/pla/pla.php:1578 (__construct) [id: 798] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 838] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 838] /modules/pla/pla.php:1578 (__construct) [id: 838] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 843] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 843] /modules/pla/pla.php:1578 (__construct) [id: 843] /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	54	/modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 37] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 37] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 37] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 58] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 37] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 37] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 37] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 58] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 58] /modules/pla/pla.php:1639 (__construct) [id: 58] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 58] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 58]
Manufacturer	20	/controllers/front/listing/ManufacturerController.php:65 (__construct) [id: 6] /classes/Meta.php:421 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6] /classes/Link.php:657 (__construct) [id: 6]
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: 160] /classes/Product.php:5908 (__construct) [id: 166] /classes/Product.php:5908 (__construct) [id: 172] /classes/Product.php:5908 (__construct) [id: 642] /classes/Product.php:5908 (__construct) [id: 184] /classes/Product.php:5908 (__construct) [id: 178] /classes/Product.php:5908 (__construct) [id: 491] /classes/Product.php:5908 (__construct) [id: 1315] /classes/Product.php:5908 (__construct) [id: 1555] /classes/Product.php:5908 (__construct) [id: 1565] /classes/Product.php:5908 (__construct) [id: 1629] /classes/Product.php:5908 (__construct) [id: 1635]
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: 2] /classes/Tools.php:560 (__construct) [id: 2]
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  

Stendardo di sinistra  

Elenco dei prodotti per la marca LAVAZZA

Lavazza Caffè in Cialda e Capsule Point, Blue in Black, A Modo Mio in Offerta.

Capsule e Cialde Lavazza Originali al miglio prezzo, in offerta, con trasporto Gratuito in Italia. DISTRIBUTORI UFFICIALI CAMPANIA!

Stopwatch SQL - 1063 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Home

Stendardo di sinistra