Home

Subcategories

Alpro Barista
Coffee Pods

Coffee Pods

On Caffè Diem you'll find all the Original ESE Espresso Coffee Pods 44mm that you need for your Espresso Machine. Order Borbone, illy, Lollo, Lavazza, Molinari, Donna Regina and others ESE Pods. Good ESE Coffee Pods always ON SALEe, Big Variety, Quick Delivery, Safe and Secure Online Shopping.
Coffee Capsules

Buy and Order Online Coffee Capsules on Caffè Diem.

On Caffè Diem you'll find all the Original or Compatible Coffee Capsules that you need for your Espresso Machine. Order Nescafé Dolce Gusto, Bialetti, Borbone, illy, Lollo, Lavazza, Molinari, Donna Regina and others. Good Coffee Capsules always ON SALE, Big Variety, Quick Delivery, Safe and Secure Online Shopping.
Coffee Beans

Coffee Beans

Roasted Coffee Bean ready to Grind for your Espresso Coffee Machine for Home and Office. Buy and Order Online on Caffè Diem.

Borbone, Lavazza, illy, Donna Regina, Bourbon, Molinari, Lollo and others Authentic Italian Coffee Bean Brands.
Coffee Machine

Espresso Coffee Machine

Capsules, ESE Pods, Bean, Filter, Ground, Coffeemaker, Bean-To-Cup Machine available Online on Caffè Diem !

All the Best Italians Coffee and Cappuccino Machine Brands: Didiesse, Lavazza, illy, Nespresso, Nescafè Dolce Gusto, Lollo, La Piccola, Nespresso. 2 YEAR WARRANTY.
Coffee Accessories

Discover all the Coffee Accessories you need to Enjoy your Coffee Break on Caffè Diem!

On Caffè Diem you can find Sugar Bags, Plastic Spoons, Espresso Plastic Cups, Espresso Cups, Cappuccino Mugs, Milk Frother and Tea or Cappuccino Cup to Enjoy your Relaxing Coffee Break or your Breakfast.

A lot of New Item Selected for You to heighten and Complement your Coffee Pause.

A Must Have for Coffee, Tea or Cappuccino Lovers.
Ground Coffee

Ground Coffee
DAMMANN Frères
Sal De Riso
Agrimontana

Agrimontana

Agrimontana preserves, compotes and marmalades have a high fruit content. They are prepared with simple recipes, just a few ingredients and essential processes: the cooking of the fruit, the addition of cane sugar, low temperature concentration and lastly, the filling of the jar while still hot, followed by rapid cooling.
illy Cold Brew
Ristora Solubili
Vending Distribuzione...
Prodotti in promozione
Offerte da non perdere
Macchina caffè

COVIM COVIM OROCREMA CAPSULE CIALDE COMPATIBILI LAVAZZA A MODO MIO

Offerte

53.90

In Stock 493 Products

COVIM COVIM GRANBAR CAPSULE CIALDE COMPATIBILI LAVAZZA A MODO MIO

Offerte

54.90

In Stock 244 Products

RISTORA Cioccolata Polvere Solubile Ristora 1Kg

Offerte

10.90

In Stock 54 Products

COVIM GOLD ARABICA CAPSULE CIALDE COMPATIBILI LAVAZZA A MODO MIO

Out-of-Stock

COVIM COVIM GOLD ARABICA CAPSULE CIALDE COMPATIBILI LAVAZZA A MODO MIO

Offerte

COVIM GOLD ARABICA CAPSULE CIALDE COMPATIBILI LAVAZZA A MODO MIO

58.90

Out of Stock

RISTORA The al Limone Polvere Solubile Ristora 1Kg

Offerte

9.90

In Stock 61 Products

COVIM Covim 96 Capsule Compatibili Lavazza A Modo Mio Decaffeinato

Offerte

COVIM DECA DEK DECAFFEINATO CAPSULE CIALDE COMPATIBILI LAVAZZA A MODO MIO

58.90

In Stock 99 Products

RISTORA Ginseng Polvere Solubile Ristora 1Kg

Offerte

12.90

In Stock 151 Products

Out-of-Stock

CAFFE TOSTINI Coffee Beans Tostini Dek Decaf 1 Kg

Offerte

Tostini Coffee Beans DEK BAR 1KG - Domestic or Work Coffee Machine.

23.90

Out of Stock

RISTORA Latte Polvere Solubile Ristora 1 Kg

Offerte

Latte Polvere Solubile Ristora 1 Kg

14.90

In Stock 118 Products

RISTORA Barley Polvere Solubile Ristora 1Kg

Offerte

Barley Polvere Solubile Ristora 1Kg

12.90

In Stock 74 Products

Load Time	334.752 ms
Querying Time	177 ms
Queries	989
Memory Peak Usage	28.1 Mb
Included Files	779 files - 10.09 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	7k
- global $smarty	5k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- 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	1.926 ms	1.926 ms	2.16 Mb	2.6 Mb
__construct	0.022 ms	1.948 ms	- Mb	2.6 Mb
init	26.850 ms	28.798 ms	0.68 Mb	3.0 Mb
checkAccess	0.013 ms	28.811 ms	- Mb	3.0 Mb
setMedia	2.705 ms	31.516 ms	0.18 Mb	3.0 Mb
postProcess	0.002 ms	31.518 ms	- Mb	3.0 Mb
initHeader	0.002 ms	31.520 ms	- Mb	3.0 Mb
initContent	131.744 ms	163.264 ms	4.50 Mb	7.6 Mb
initFooter	0.002 ms	163.266 ms	- Mb	7.6 Mb
display	171.486 ms	334.752 ms	19.40 Mb	28.1 Mb

Hook	Time	Memory Usage
displayHeaderCenter	43.133 ms	6.32 Mb
=> cp_blocksearch (widget)	43.133 ms	6.32 Mb
DisplayProductListReviews	32.418 ms	5.95 Mb
=> pla	5.862 ms	1.20 Mb
=> pla	3.155 ms	0.51 Mb
=> pla	5.927 ms	0.74 Mb
=> pla	3.349 ms	0.52 Mb
=> pla	2.803 ms	0.48 Mb
=> pla	2.318 ms	0.53 Mb
=> pla	2.168 ms	0.48 Mb
=> pla	2.448 ms	0.52 Mb
=> pla	2.188 ms	0.48 Mb
=> pla	2.200 ms	0.48 Mb
DisplayBeforeBodyClosingTag	11.247 ms	0.39 Mb
=> statsdata	6.748 ms	0.15 Mb
=> ps_googleanalytics	4.499 ms	0.24 Mb
DisplayCpHoverImage	7.695 ms	0.35 Mb
=> cp_imagehover	1.126 ms	0.04 Mb
=> cp_imagehover	0.908 ms	0.04 Mb
=> cp_imagehover	0.605 ms	0.03 Mb
=> cp_imagehover	1.098 ms	0.04 Mb
=> cp_imagehover	1.050 ms	0.04 Mb
=> cp_imagehover	0.750 ms	0.04 Mb
=> cp_imagehover	0.776 ms	0.04 Mb
=> cp_imagehover	0.468 ms	0.03 Mb
=> cp_imagehover	0.435 ms	0.03 Mb
=> cp_imagehover	0.479 ms	0.03 Mb
displayNavFullWidth	6.977 ms	1.01 Mb
=> cp_sideverticalmenu (widget)	5.306 ms	0.78 Mb
=> ps_mainmenu (widget)	0.921 ms	0.16 Mb
=> cp_headercms2 (widget)	0.750 ms	0.06 Mb
DisplayStCompareButton	6.634 ms	0.02 Mb
=> stfeature	0.436 ms	0.01 Mb
=> stfeature	0.289 ms	- Mb
=> stfeature	0.370 ms	- Mb
=> stfeature	0.284 ms	- Mb
=> stfeature	0.374 ms	- Mb
=> stfeature	0.500 ms	- Mb
=> stfeature	0.422 ms	- Mb
=> stfeature	0.316 ms	- Mb
=> stfeature	0.414 ms	- Mb
=> stfeature	0.268 ms	- Mb
=> stfeature	0.319 ms	- Mb
=> stfeature	0.294 ms	- Mb
=> stfeature	0.317 ms	- Mb
=> stfeature	0.257 ms	- Mb
=> stfeature	0.314 ms	- Mb
=> stfeature	0.282 ms	- Mb
=> stfeature	0.311 ms	- Mb
=> stfeature	0.268 ms	- Mb
=> stfeature	0.321 ms	- Mb
=> stfeature	0.277 ms	- Mb
DisplayStWishlistButton	5.244 ms	0.03 Mb
=> stfeature	0.375 ms	0.01 Mb
=> stfeature	0.256 ms	- Mb
=> stfeature	0.292 ms	- Mb
=> stfeature	0.230 ms	- Mb
=> stfeature	0.274 ms	- Mb
=> stfeature	0.325 ms	- Mb
=> stfeature	0.254 ms	- Mb
=> stfeature	0.272 ms	- Mb
=> stfeature	0.299 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.241 ms	- Mb
=> stfeature	0.235 ms	- Mb
=> stfeature	0.263 ms	- Mb
=> stfeature	0.251 ms	- Mb
=> stfeature	0.254 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.229 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.234 ms	- Mb
=> stfeature	0.231 ms	- Mb
displayLeftColumn	4.732 ms	0.34 Mb
=> ps_categorytree (widget)	2.360 ms	0.23 Mb
=> cp_leftbanner1 (widget)	1.320 ms	0.03 Mb
=> cp_sidebarfeaturedproducts (widget)	1.052 ms	0.08 Mb
displayFooter	4.519 ms	0.69 Mb
=> ps_linklist (widget)	3.819 ms	0.61 Mb
=> cp_themeoptions (widget)	0.700 ms	0.08 Mb
DisplayFooter	3.601 ms	0.45 Mb
=> cpcouponpop	0.006 ms	0.06 Mb
=> cp_salenotification	3.595 ms	0.39 Mb
Header	2.872 ms	0.10 Mb
=> pla	0.547 ms	- Mb
=> cp_blocksearch	0.521 ms	- Mb
=> cp_salenotification	0.163 ms	- Mb
=> cp_themeoptions	1.285 ms	0.08 Mb
=> stfeature	0.356 ms	0.01 Mb
displayNav2	2.622 ms	0.20 Mb
=> ps_languageselector (widget)	0.811 ms	0.05 Mb
=> ps_currencyselector (widget)	1.189 ms	0.11 Mb
=> ps_customersignin (widget)	0.622 ms	0.04 Mb
displayHeaderRight	2.058 ms	0.13 Mb
=> ps_shoppingcart (widget)	2.058 ms	0.13 Mb
displaySide	1.764 ms	0.06 Mb
=> ps_currencyselector (widget)	0.808 ms	0.03 Mb
=> ps_languageselector (widget)	0.466 ms	0.01 Mb
=> cp_headercms1 (widget)	0.490 ms	0.02 Mb
DisplayHeader	1.647 ms	0.01 Mb
=> ps_shoppingcart	0.068 ms	- Mb
=> ps_googleanalytics	0.124 ms	- Mb
=> cp_imageslider	0.205 ms	- Mb
=> cp_categorylist	0.107 ms	- Mb
=> cp_categoryproductsslider	0.168 ms	- Mb
=> cpcouponpop	0.003 ms	- Mb
=> cp_countdown	0.173 ms	- Mb
=> ets_blog	0.692 ms	0.01 Mb
=> cp_sideverticalmenu	0.106 ms	- Mb
DisplayStCompareTopLink	1.217 ms	0.06 Mb
=> stfeature	0.653 ms	0.04 Mb
=> stfeature	0.564 ms	0.03 Mb
displayFooterleft	1.194 ms	0.10 Mb
=> ps_contactinfo (widget)	0.657 ms	0.06 Mb
=> ps_socialfollow (widget)	0.537 ms	0.04 Mb
displayNav1	1.098 ms	0.09 Mb
=> cp_headercms1 (widget)	1.098 ms	0.09 Mb
ProductSearchProvider	1.055 ms	- Mb
=> ps_facetedsearch	1.055 ms	- Mb
DisplayStWishlistTopLink	0.890 ms	0.04 Mb
=> stfeature	0.601 ms	0.03 Mb
=> stfeature	0.289 ms	- Mb
displayFooterAfter	0.779 ms	0.06 Mb
=> cp_footercms1 (widget)	0.779 ms	0.06 Mb
ActionFrontControllerSetMedia	0.711 ms	0.01 Mb
=> blockreassurance	0.391 ms	0.01 Mb
=> ps_emailsubscription	0.082 ms	- Mb
=> ps_socialfollow	0.103 ms	- Mb
=> ps_emailalerts	0.135 ms	- Mb
displayFooterbefore	0.648 ms	0.05 Mb
=> ps_emailsubscription (widget)	0.648 ms	0.05 Mb
DisplayFooterAfter	0.431 ms	0.04 Mb
=> cp_themeoptions	0.431 ms	0.04 Mb
Footer	0.336 ms	0.02 Mb
=> cp_cookie	0.336 ms	0.02 Mb
displayCustomerSide	0.301 ms	- Mb
=> ps_customersignin (widget)	0.301 ms	- Mb
DisplayLeftColumn	0.300 ms	0.08 Mb
=> ps_facetedsearch	0.300 ms	0.08 Mb
ModuleRoutes	0.022 ms	0.01 Mb
=> ets_blog	0.022 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.009 ms	- Mb
=> blockreassurance	0.009 ms	- Mb
29 hook(s)	146.152 ms	16.61 Mb

Module	Time	Memory Usage
ets_blog	5.079 ms	0.01 Mb
__construct	4.359 ms	- Mb
hookModuleRoutes	0.027 ms	0.01 Mb
hookDisplayHeader	0.693 ms	0.01 Mb
blockreassurance	0.955 ms	0.09 Mb
__construct	0.549 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.394 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.012 ms	- Mb
ps_emailsubscription	0.832 ms	0.12 Mb
__construct	0.099 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.083 ms	- Mb
displayFooterbefore	0.650 ms	0.05 Mb
ps_socialfollow	0.710 ms	0.05 Mb
__construct	0.068 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.104 ms	- Mb
displayFooterleft	0.538 ms	0.04 Mb
ps_emailalerts	0.278 ms	0.01 Mb
__construct	0.142 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.136 ms	- Mb
ps_shoppingcart	2.228 ms	0.14 Mb
__construct	0.099 ms	0.01 Mb
hookDisplayHeader	0.070 ms	- Mb
displayHeaderRight	2.059 ms	0.13 Mb
ps_googleanalytics	4.734 ms	0.24 Mb
__construct	0.108 ms	0.01 Mb
hookDisplayHeader	0.125 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.501 ms	0.24 Mb
cp_imageslider	0.486 ms	0.01 Mb
__construct	0.280 ms	0.01 Mb
hookDisplayHeader	0.206 ms	- Mb
cp_categorylist	0.262 ms	0.01 Mb
__construct	0.154 ms	0.01 Mb
hookDisplayHeader	0.108 ms	- Mb
cp_categoryproductsslider	0.321 ms	0.01 Mb
__construct	0.152 ms	0.01 Mb
hookDisplayHeader	0.169 ms	- Mb
cpcouponpop	0.239 ms	0.07 Mb
__construct	0.228 ms	0.01 Mb
hookDisplayHeader	0.004 ms	- Mb
hookDisplayFooter	0.007 ms	0.06 Mb
cp_countdown	0.336 ms	0.01 Mb
__construct	0.162 ms	0.01 Mb
hookDisplayHeader	0.174 ms	- Mb
pla	33.285 ms	5.96 Mb
__construct	0.289 ms	0.01 Mb
hookHeader	0.548 ms	- Mb
hookDisplayProductListReviews	5.864 ms	1.20 Mb
hookDisplayProductListReviews	3.158 ms	0.51 Mb
hookDisplayProductListReviews	5.935 ms	0.74 Mb
hookDisplayProductListReviews	3.353 ms	0.52 Mb
hookDisplayProductListReviews	2.805 ms	0.48 Mb
hookDisplayProductListReviews	2.320 ms	0.53 Mb
hookDisplayProductListReviews	2.170 ms	0.48 Mb
hookDisplayProductListReviews	2.451 ms	0.52 Mb
hookDisplayProductListReviews	2.190 ms	0.48 Mb
hookDisplayProductListReviews	2.202 ms	0.48 Mb
cp_blocksearch	43.853 ms	6.33 Mb
__construct	0.194 ms	0.01 Mb
hookHeader	0.523 ms	- Mb
displayHeaderCenter	43.136 ms	6.32 Mb
cp_sideverticalmenu	5.659 ms	0.79 Mb
__construct	0.245 ms	0.01 Mb
hookDisplayHeader	0.107 ms	- Mb
displayNavFullWidth	5.307 ms	0.78 Mb
cp_salenotification	3.833 ms	0.40 Mb
__construct	0.073 ms	0.01 Mb
hookHeader	0.163 ms	- Mb
hookDisplayFooter	3.597 ms	0.39 Mb
cp_themeoptions	2.775 ms	0.23 Mb
__construct	0.355 ms	0.03 Mb
hookHeader	1.287 ms	0.08 Mb
displayFooter	0.701 ms	0.08 Mb
hookDisplayFooterAfter	0.432 ms	0.04 Mb
stfeature	14.682 ms	0.19 Mb
__construct	0.266 ms	0.01 Mb
hookHeader	0.357 ms	0.01 Mb
hookDisplayStCompareTopLink	0.656 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.603 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.291 ms	- Mb
hookDisplayStCompareTopLink	0.567 ms	0.03 Mb
hookDisplayStCompareButton	0.438 ms	0.01 Mb
hookDisplayStWishlistButton	0.377 ms	0.01 Mb
hookDisplayStCompareButton	0.290 ms	- Mb
hookDisplayStWishlistButton	0.258 ms	- Mb
hookDisplayStCompareButton	0.372 ms	- Mb
hookDisplayStWishlistButton	0.294 ms	- Mb
hookDisplayStCompareButton	0.286 ms	- Mb
hookDisplayStWishlistButton	0.231 ms	- Mb
hookDisplayStCompareButton	0.376 ms	- Mb
hookDisplayStWishlistButton	0.275 ms	- Mb
hookDisplayStCompareButton	0.504 ms	- Mb
hookDisplayStWishlistButton	0.328 ms	- Mb
hookDisplayStCompareButton	0.425 ms	- Mb
hookDisplayStWishlistButton	0.255 ms	- Mb
hookDisplayStCompareButton	0.318 ms	- Mb
hookDisplayStWishlistButton	0.274 ms	- Mb
hookDisplayStCompareButton	0.417 ms	- Mb
hookDisplayStWishlistButton	0.300 ms	- Mb
hookDisplayStCompareButton	0.269 ms	- Mb
hookDisplayStWishlistButton	0.245 ms	- Mb
hookDisplayStCompareButton	0.321 ms	- Mb
hookDisplayStWishlistButton	0.242 ms	- Mb
hookDisplayStCompareButton	0.295 ms	- Mb
hookDisplayStWishlistButton	0.235 ms	- Mb
hookDisplayStCompareButton	0.319 ms	- Mb
hookDisplayStWishlistButton	0.264 ms	- Mb
hookDisplayStCompareButton	0.259 ms	- Mb
hookDisplayStWishlistButton	0.252 ms	- Mb
hookDisplayStCompareButton	0.316 ms	- Mb
hookDisplayStWishlistButton	0.255 ms	- Mb
hookDisplayStCompareButton	0.283 ms	- Mb
hookDisplayStWishlistButton	0.244 ms	- Mb
hookDisplayStCompareButton	0.313 ms	- Mb
hookDisplayStWishlistButton	0.230 ms	- Mb
hookDisplayStCompareButton	0.269 ms	- Mb
hookDisplayStWishlistButton	0.244 ms	- Mb
hookDisplayStCompareButton	0.322 ms	- Mb
hookDisplayStWishlistButton	0.235 ms	- Mb
hookDisplayStCompareButton	0.279 ms	- Mb
hookDisplayStWishlistButton	0.232 ms	- Mb
ps_facetedsearch	2.642 ms	0.10 Mb
__construct	1.283 ms	0.01 Mb
hookProductSearchProvider	1.057 ms	- Mb
hookDisplayLeftColumn	0.302 ms	0.08 Mb
cp_headercms1	1.838 ms	0.12 Mb
__construct	0.244 ms	0.01 Mb
displayNav1	1.102 ms	0.09 Mb
displaySide	0.492 ms	0.02 Mb
ps_languageselector	1.380 ms	0.06 Mb
__construct	0.100 ms	0.01 Mb
displayNav2	0.813 ms	0.05 Mb
displaySide	0.467 ms	0.01 Mb
ps_currencyselector	2.095 ms	0.15 Mb
__construct	0.094 ms	0.01 Mb
displayNav2	1.191 ms	0.11 Mb
displaySide	0.810 ms	0.03 Mb
ps_customersignin	1.022 ms	0.05 Mb
__construct	0.095 ms	0.01 Mb
displayNav2	0.624 ms	0.04 Mb
displayCustomerSide	0.303 ms	- Mb
ps_mainmenu	1.090 ms	0.17 Mb
__construct	0.168 ms	0.01 Mb
displayNavFullWidth	0.922 ms	0.17 Mb
cp_headercms2	0.959 ms	0.07 Mb
__construct	0.208 ms	0.01 Mb
displayNavFullWidth	0.751 ms	0.07 Mb
ps_categorytree	2.450 ms	0.23 Mb
__construct	0.089 ms	0.01 Mb
displayLeftColumn	2.361 ms	0.23 Mb
cp_leftbanner1	1.522 ms	0.04 Mb
__construct	0.200 ms	0.01 Mb
displayLeftColumn	1.322 ms	0.03 Mb
cp_sidebarfeaturedproducts	1.229 ms	0.15 Mb
__construct	0.175 ms	0.07 Mb
displayLeftColumn	1.054 ms	0.08 Mb
cp_imagehover	7.894 ms	0.36 Mb
__construct	0.172 ms	0.01 Mb
hookDisplayCpHoverImage	1.129 ms	0.04 Mb
hookDisplayCpHoverImage	0.911 ms	0.04 Mb
hookDisplayCpHoverImage	0.607 ms	0.03 Mb
hookDisplayCpHoverImage	1.102 ms	0.04 Mb
hookDisplayCpHoverImage	1.054 ms	0.04 Mb
hookDisplayCpHoverImage	0.752 ms	0.04 Mb
hookDisplayCpHoverImage	0.779 ms	0.04 Mb
hookDisplayCpHoverImage	0.470 ms	0.03 Mb
hookDisplayCpHoverImage	0.437 ms	0.03 Mb
hookDisplayCpHoverImage	0.481 ms	0.03 Mb
ps_contactinfo	0.767 ms	0.07 Mb
__construct	0.108 ms	0.01 Mb
displayFooterleft	0.659 ms	0.06 Mb
ps_linklist	4.555 ms	0.62 Mb
__construct	0.733 ms	0.01 Mb
displayFooter	3.822 ms	0.61 Mb
cp_cookie	0.520 ms	0.03 Mb
__construct	0.183 ms	0.01 Mb
hookFooter	0.337 ms	0.02 Mb
cp_footercms1	0.982 ms	0.07 Mb
__construct	0.202 ms	0.01 Mb
displayFooterAfter	0.780 ms	0.06 Mb
statsdata	6.840 ms	0.16 Mb
__construct	0.090 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	6.750 ms	0.15 Mb
34 module(s)	158.331 ms	17.09 Mb

shop by category

Home

Left Banner

Home

Subcategories

Alpro Barista

Coffee Pods

Coffee Pods

Coffee Capsules

Coffee Beans

Coffee Beans

Coffee Machine

Espresso Coffee Machine

Coffee Accessories

Discover all the Coffee Accessories you need to Enjoy your Coffee Break on Caffè Diem!

Ground Coffee

Ground Coffee

DAMMANN Frères

Sal De Riso

Agrimontana

Agrimontana

illy Cold Brew

Ristora Solubili

Vending Distribuzione...

Prodotti in promozione

Offerte da non perdere

Macchina caffè

Contact us

Products

Our company

Stopwatch SQL - 989 queries

Doubles

Tables stress

ObjectModel instances

Included Files

143 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
53 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
43 queries	SELECT `id_image` FROM `vtny_image` WHERE `id_product` = XX AND `cover` = XX ORDER BY position ASC LIMIT XX, XX
21 queries	SELECT `id_module` FROM `vtny_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
20 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
20 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`
20 queries	SELECT `id_product_attribute` FROM `vtny_product_attribute` WHERE `id_product` = XX
16 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
11 queries	SELECT XX FROM `vtny_specific_price` WHERE id_product = XX LIMIT XX
10 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
10 queries	SELECT name FROM vtny_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
10 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
10 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)
10 queries	SELECT `id_tax_rules_group` FROM `vtny_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
10 queries	SELECT `reduction` FROM `vtny_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
10 queries	SELECT COUNT(*) FROM `vtny_pack` WHERE id_product_pack = XX LIMIT XX
10 queries	SELECT product_type FROM `vtny_product` WHERE id_product = XX LIMIT XX
10 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
10 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
10 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
10 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
10 queries	SELECT * FROM `vtny_product_attribute_lang` WHERE `id_product_attribute` = XX
10 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `vtny_product_attribute_image` pai LEFT JOIN `vtny_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `vtny_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
10 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
10 queries	SELECT * FROM `vtny_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
10 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`
10 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;
10 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
10 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
10 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
10 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
10 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
10 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
10 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
10 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`
10 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
10 queries	SELECT * FROM `vtny_attribute_lang` WHERE `id_attribute` = XX
10 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 cl.`link_rewrite` FROM `vtny_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
8 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `vtny_product_attribute_image` pai LEFT JOIN `vtny_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `vtny_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
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 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) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
5 queries	SELECT * FROM `vtny_cms` a LEFT JOIN `vtny_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
5 queries	SELECT * FROM `vtny_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
4 queries	SELECT `id_lang` FROM `vtny_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
4 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `vtny_product_attribute_combination` pac LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
3 queries	SELECT `name` FROM `vtny_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
3 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
3 queries	SELECT * FROM `vtny_cpheadercmsXXblockinfo_lang` WHERE `id_lang` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT * FROM `vtny_lang` a LEFT JOIN `vtny_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `vtny_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `vtny_module` m LEFT JOIN `vtny_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT * FROM `vtny_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 `id_category` FROM `vtny_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM vtny_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT 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 * FROM `vtny_category` a LEFT JOIN `vtny_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_tax` a WHERE (a.`id_tax` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_tax_lang` WHERE `id_tax` = XX
2 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`
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
99	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 c.nleft>=2 AND c.nright<=341 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	30.289 ms	6804	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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	REPLACE INTO vtny_layered_filter_block (hash, data) VALUES ("b6deb23e1bbaa2d77a389c5233df032f", "a:1:{s:7:\"filters\";a:8:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:8;}i:0;a:2:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:2;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:24;s:3:\"min\";d:9;s:4:\"unit\";s:0:\"\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:0:\"\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:10;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:4:{i:104;a:2:{s:4:\"name\";s:32:\"Covim A Modo Mio Coffee Capsules\";s:3:\"nbr\";i:4;}i:183;a:2:{s:4:\"name\";s:20:\"Grani Caffè Tostini\";s:3:\"nbr\";i:1;}i:187;a:2:{s:4:\"name\";s:32:\"Vending Distribuzione Automatica\";s:3:\"nbr\";i:5;}i:191;a:2:{s:4:\"name\";s:16:\"Ristora Solubili\";s:3:\"nbr\";i:5;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:2;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:5;s:4:\"name\";s:5:\"Offer\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:53:{i:64;a:4:{s:4:\"name\";s:10:\"21 capsule\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:83;a:4:{s:4:\"name\";s:17:\"24 Filrti Dammann\";s:3:\"nbr\";i:24;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:76;a:4:{s:4:\"name\";s:10:\"32 Capsule\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:79;a:4:{s:4:\"name\";s:10:\"40 Capsule\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:84;a:4:{s:4:\"name\";s:17:\"48 Filtri Dammann\";s:3:\"nbr\";i:24;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:78;a:4:{s:4:\"name\";s:10:\"50 Capsule\";s:3:\"nbr\";i:10;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:77;a:4:{s:4:\"name\";s:10:\"64 Capsule\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:66;a:4:{s:4:\"name\";s:10:\"80 Capsule\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:71;a:4:{s:4:\"name\";s:11:\"90 Capsules\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:103;a:4:{s:4:\"name\";s:10:\"96 Capsule\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:85;a:4:{s:4:\"name\";s:17:\"96 Filtri Dammann\";s:3:\"nbr\";i:24;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:33;a:4:{s:4:\"name\";s:11:\"100 Capsule\";s:3:\"nbr\";i:115;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:4:{s:4:\"name\";s:12:\"108 Capsules\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:98;a:4:{s:4:\"name\";s:11:\"120 Capsule\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:63;a:4:{s:4:\"name\";s:11:\"126 capsule\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:61;a:4:{s:4:\"name\";s:11:\"128 Capsule\";s:3:\"nbr\";i:25;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:67;a:4:{s:4:\"name\";s:11:\"160 Capsule\";s:3:\"nbr\";i:13;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:68;a:4:{s:4:\"name\";s:12:\"180 Capsules\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:99;a:4:{s:4:\"name\";s:11:\"192 Capsule\";s:3:\"nbr\";i:4;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:115;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:26;a:4:{s:4:\"name\";s:12:\"216 Capsules\";s:3:\"nbr\";i:17;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:86;a:4:{s:4:\"name\";s:12:\"240 Capsules\";s:3:\"nbr\";i:7;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:62;a:4:{s:4:\"name\";s:11:\"256 Capsule\";s:3:\"nbr\";i:24;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:72;a:4:{s:4:\"name\";s:12:\"270 Capsules\";s:3:\"nbr\";i:8;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:100;a:5:{s:4:\"name\";s:11:\"288 Capsule\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:35;a:4:{s:4:\"name\";s:11:\"300 Capsule\";s:3:\"nbr\";i:93;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:87;a:4:{s:4:\"name\";s:12:\"320 Capsules\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:27;a:4:{s:4:\"name\";s:12:\"324 Capsules\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:69;a:4:{s:4:\"name\";s:11:\"360 Capsule\";s:3:\"nbr\";i:12;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:101;a:5:{s:4:\"name\";s:11:\"384 Capsule\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:36;a:4:{s:4:\"name\";s:11:\"400 Capsule\";s:3:\"nbr\";i:82;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:81;a:4:{s:4:\"name\";s:11:\"432 Capsule\";s:3:\"nbr\";i:13;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:37;a:4:{s:4:\"name\";s:11:\"500 Capsule\";s:3:\"nbr\";i:30;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:82;a:4:{s:4:\"name\";s:11:\"540 Capsule\";s:3:\"nbr\";i:13;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:38;a:4:{s:4:\"name\";s:11:\"600 Capsule\";s:3:\"nbr\";i:74;s:8:\"url_name\";N;s:10:\"meta_title\";N;}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:56;a:4:{s:4:\"name\";s:10:\"108 Cialde\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:32;a:4:{s:4:\"name\";s:8:\"150 Pods\";s:3:\"nbr\";i:58;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:8:\"300 Pods\";s:3:\"nbr\";i:61;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:8:\"450 Pods\";s:3:\"nbr\";i:58;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:102;a:4:{s:4:\"name\";s:11:\"480 Capsule\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:31;a:4:{s:4:\"name\";s:8:\"600 Pods\";s:3:\"nbr\";i:61;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:60;a:5:{s:4:\"name\";s:4:\"1 Kg\";s:3:\"nbr\";i:6;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:94;a:4:{s:4:\"name\";s:4:\"2 Kg\";s:3:\"nbr\";i:1;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:60;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:59;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:59;a:4:{s:4:\"name\";s:5:\"12 Kg\";s:3:\"nbr\";i:59;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:80;a:4:{s:4:\"name\";s:10:\"216 Cialde\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:95;a:4:{s:4:\"name\";s:7:\"1 Litro\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:96;a:4:{s:4:\"name\";s:7:\"8 Litri\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:97;a:4:{s:4:\"name\";s:8:\"16 Litri\";s:3:\"nbr\";i:4;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";i:10;}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:3:{i:8;a:2:{s:4:\"name\";s:5:\"COVIM\";s:3:\"nbr\";i:4;}i:13;a:2:{s:4:\"name\";s:7:\"RISTORA\";s:3:\"nbr\";i:5;}i:41;a:2:{s:4:\"name\";s:13:\"CAFFE TOSTINI\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:1;s:3:\"min\";d:1;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:10;}}}")	3.035 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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
971	INSERT INTO `vtny_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')	2.644 ms	1			/classes/ObjectModel.php:622 /classes/ObjectModel.php:576 (add) /classes/Guest.php:251 (save) /modules/statsdata/statsdata.php:82 (setNewGuest) /modules/statsdata/statsdata.php:73 (getScriptPlugins) /classes/Hook.php: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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
979	SELECT SQL_NO_CACHE 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` = 1 ) WHERE pac.`id_product_attribute` = 2350 ORDER BY ag.`position` ASC, a.`position` ASC	1.979 ms	1	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:241 /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:178 (getProductVariant) /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:73 (prepareItemFromProduct) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:81 (prepareItemListFromProductList) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:57 (renderProductListing) /modules/ps_googleanalytics/ps_googleanalytics.php:109 (run) /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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
117	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.390 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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
976	INSERT INTO `vtny_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('7401', '', 'caffe.solnetwork.it/en/2-home?q=Offer-384+Capsule-1+Kg-288+Capsule', '', '2026-04-01 20:08:35')	1.278 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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `vtny_module` m INNER JOIN vtny_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `vtny_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `vtny_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `vtny_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.081 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)
102	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60))) GROUP BY p.id_manufacturer	1.068 ms	84	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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
975	INSERT INTO `vtny_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('7343', '369', '3628718299', '', '1', '1', '2026-04-01 20:08:35')	1.035 ms	1			/classes/ObjectModel.php:622 /classes/Connection.php:188 (add) /classes/Connection.php:97 (setNewConnection) /modules/statsdata/statsdata.php:118 (setPageConnection) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php: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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
98	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<341 GROUP BY cp.id_category	1.028 ms	168	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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60))) GROUP BY p.condition	1.019 ms	84	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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
645	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `vtny_category` c INNER JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `vtny_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND nleft >= 2 AND nright <= 341 AND c.id_category IN ( SELECT id_category FROM `vtny_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	0.997 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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
105	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60))) GROUP BY pac.id_attribute	0.947 ms	84	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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
90	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60)))	0.944 ms	84			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
118	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `vtny_hook_module` hm STRAIGHT_JOIN `vtny_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `vtny_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.922 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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60)))	0.880 ms	84			/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/CategoryController.php:139 (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.878 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)
92	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60)))	0.839 ms	84			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60))) AND p.date_add>'2026-03-13 00:00:00'	0.778 ms	84			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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	0.745 ms	4704	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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 (100, 101, 60)))	0.738 ms	84			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
43	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `vtny_category` c INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `vtny_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.737 ms	18	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:230 (getSubCategories) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-04-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM vtny_product p LEFT JOIN vtny_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN vtny_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN vtny_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (334,333,891,335,892,336,893,1075,894,1304)	0.707 ms	10			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
101	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `vtny_manufacturer` m INNER JOIN vtny_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `vtny_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.640 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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341 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 20:08:34' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-04-01 20:08:34' <= 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 (100, 101, 60)))	0.610 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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `vtny_attribute_group` ag INNER JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `vtny_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN vtny_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `vtny_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC	0.582 ms	64	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
754	SELECT SQL_NO_CACHE * FROM `vtny_product` a LEFT JOIN `vtny_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 335) LIMIT 1	0.526 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) /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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
951	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE c.`id_category` IN (SELECT DISTINCT `id_category` FROM `vtny_category_product` WHERE 1) AND c.`active` = 1 AND cl.`id_lang` = 1	0.507 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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
83	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `vtny_attribute_group` ag INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `vtny_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.503 ms	2	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
103	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341	0.502 ms	28			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
715	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 333 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.502 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
96	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 (100, 101, 60))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=341	0.490 ms	28			/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/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
762	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (335) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.485 ms	5	Yes	Yes	/classes/Product.php:4520 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:45 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
730	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (891) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.480 ms	4	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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
5	SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `vtny_lang` l LEFT JOIN `vtny_lang_shop` ls ON (l.id_lang = ls.id_lang)	0.479 ms	2			/classes/Language.php:1080 /config/config.inc.php:143 (loadLanguages) /index.php:27 (require)
787	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (892) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.477 ms	4	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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
82	SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM vtny_layered_category WHERE controller = 'category' AND id_category = 2 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	0.468 ms	11	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:61 /modules/ps_facetedsearch/src/Filters/Converter.php:263 (getFiltersForQuery) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
772	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 335 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.463 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
705	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (333) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.451 ms	5	Yes	Yes	/classes/Product.php:4520 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:45 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /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)
740	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 891 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.449 ms	4	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/b0/b2/78/b0b278eaffb27e6ea2ecd9765ee8cfaebab6e519_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28d7845_32523573) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

Name	Instances	Source
Category	183	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 190] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 14] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 110] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 18] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 19] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 20] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 109] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 123] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 128] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 113] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 175] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 191] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 187] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 193] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 194] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 195] /classes/Meta.php:380 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__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] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 2] /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:271 (__construct) [id: 10]
AttributeGroupCore	86	/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	57	/classes/Link.php:113 (__construct) [id: 1075] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 334] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 333] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 891] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 335] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 892] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 336] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 893] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1075] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 894] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1304] /classes/Link.php:113 (__construct) [id: 334] /classes/Link.php:113 (__construct) [id: 333] /classes/Link.php:113 (__construct) [id: 891] /classes/Link.php:113 (__construct) [id: 335] /classes/Link.php:113 (__construct) [id: 892] /classes/Link.php:113 (__construct) [id: 336] /classes/Link.php:113 (__construct) [id: 893] /classes/Link.php:113 (__construct) [id: 1075] /classes/Link.php:113 (__construct) [id: 894] /classes/Link.php:113 (__construct) [id: 1304] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 334] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 334] /modules/pla/pla.php:1578 (__construct) [id: 334] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 333] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 333] /modules/pla/pla.php:1578 (__construct) [id: 333] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 891] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 891] /modules/pla/pla.php:1578 (__construct) [id: 891] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 335] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 335] /modules/pla/pla.php:1578 (__construct) [id: 335] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 892] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 892] /modules/pla/pla.php:1578 (__construct) [id: 892] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 336] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 336] /modules/pla/pla.php:1578 (__construct) [id: 336] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 893] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 893] /modules/pla/pla.php:1578 (__construct) [id: 893] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1075] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1075] /modules/pla/pla.php:1578 (__construct) [id: 1075] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 894] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 894] /modules/pla/pla.php:1578 (__construct) [id: 894] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1304] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1304] /modules/pla/pla.php:1578 (__construct) [id: 1304] /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	43	/modules/pla/pla.php:1639 (__construct) [id: 103] /modules/pla/pla.php:1639 (__construct) [id: 99] /modules/pla/pla.php:1639 (__construct) [id: 100] /modules/pla/pla.php:1639 (__construct) [id: 101] /modules/pla/pla.php:1639 (__construct) [id: 102] /modules/pla/pla.php:1639 (__construct) [id: 103] /modules/pla/pla.php:1639 (__construct) [id: 99] /modules/pla/pla.php:1639 (__construct) [id: 100] /modules/pla/pla.php:1639 (__construct) [id: 101] /modules/pla/pla.php:1639 (__construct) [id: 102] /modules/pla/pla.php:1639 (__construct) [id: 60] /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: 103] /modules/pla/pla.php:1639 (__construct) [id: 99] /modules/pla/pla.php:1639 (__construct) [id: 100] /modules/pla/pla.php:1639 (__construct) [id: 101] /modules/pla/pla.php:1639 (__construct) [id: 102] /modules/pla/pla.php:1639 (__construct) [id: 60] /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: 103] /modules/pla/pla.php:1639 (__construct) [id: 99] /modules/pla/pla.php:1639 (__construct) [id: 100] /modules/pla/pla.php:1639 (__construct) [id: 101] /modules/pla/pla.php:1639 (__construct) [id: 102] /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: 60] /modules/pla/pla.php:1639 (__construct) [id: 60] /modules/pla/pla.php:1639 (__construct) [id: 94] /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: 60] /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: 60]
Address	14	/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: ]
AttributeGroup	10	/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]
Combination	10	/classes/Product.php:5908 (__construct) [id: 2350] /classes/Product.php:5908 (__construct) [id: 2355] /classes/Product.php:5908 (__construct) [id: 1791] /classes/Product.php:5908 (__construct) [id: 2367] /classes/Product.php:5908 (__construct) [id: 1795] /classes/Product.php:5908 (__construct) [id: 2360] /classes/Product.php:5908 (__construct) [id: 1802] /classes/Product.php:5908 (__construct) [id: 1955] /classes/Product.php:5908 (__construct) [id: 1806] /classes/Product.php:5908 (__construct) [id: 2236]
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:695 (getCurrencyInstance) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:641 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
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]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
AddressFormat	2	/classes/controller/FrontController.php:1761 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 2]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

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

shop by category

Home  

Left Banner  

Home

Subcategories

Coffee Pods

Coffee Beans

Espresso Coffee Machine

Discover all the Coffee Accessories you need to Enjoy your Coffee Break on Caffè Diem!

Ground Coffee

Agrimontana

Home

Left Banner