Caffè Lucaffè Venturelli Gianluca

Lucaffè Lucaffè 150 cialde Ese 44mm Miscela Classic Compostabili

Offerte

Cialde Ese di Carta Lucaffè Miscela Classica Universali e Compostabili

40,00 €

In Stock 54 Products

Non disponibile

Lucaffè Lucaffè 150 cialde Ese 44mm Miscela Mamma Lucia Compostabili

Offerte

Cialde Ese di Carta Lucaffè Miscela Mamma Lucia Universali e Compostabili

38,00 €

Out of Stock

Lucaffè Lucaffè 150 cialde Ese 44mm Miscela Mr. Exclusive 100% Arabica

Offerte

Cialde Ese di Carta Lucaffè Miscela 150 Arabica Universali e Compostabili

55,00 €

In Stock 67 Products

Load Time	273.658 ms
Querying Time	138 ms
Queries	625
Memory Peak Usage	19.6 Mb
Included Files	773 files - 10.08 Mb
PrestaShop Cache	- Mb
Global vars	0.06 Mb
- global $_MODULES	26k
- global $_SERVER	8k
- global $config	5k
- global $context	4k
- global $smarty	4k
- global $exportPhpConfigFile	4k
- global $_COOKIE	2k
- global $__composer_autoload_files	1k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	1.789 ms	1.789 ms	2.15 Mb	2.6 Mb
__construct	0.016 ms	1.805 ms	- Mb	2.6 Mb
init	24.902 ms	26.707 ms	0.43 Mb	2.9 Mb
checkAccess	0.001 ms	26.708 ms	- Mb	2.9 Mb
setMedia	3.200 ms	29.908 ms	0.18 Mb	2.9 Mb
postProcess	0.003 ms	29.911 ms	- Mb	2.9 Mb
initHeader	0.001 ms	29.912 ms	- Mb	2.9 Mb
initContent	85.257 ms	115.169 ms	2.64 Mb	5.4 Mb
initFooter	0.003 ms	115.172 ms	- Mb	5.4 Mb
display	158.486 ms	273.658 ms	13.50 Mb	19.6 Mb

Hook	Time	Memory Usage
displayHeaderCenter	67.739 ms	6.79 Mb
=> cp_blocksearch (widget)	67.739 ms	6.79 Mb
DisplayProductListReviews	16.691 ms	2.07 Mb
=> pla	8.191 ms	1.11 Mb
=> pla	4.642 ms	0.48 Mb
=> pla	3.858 ms	0.48 Mb
displayFooter	7.693 ms	0.70 Mb
=> ps_linklist (widget)	6.367 ms	0.61 Mb
=> cp_themeoptions (widget)	1.326 ms	0.09 Mb
displayNavFullWidth	6.629 ms	1.00 Mb
=> cp_sideverticalmenu (widget)	4.932 ms	0.77 Mb
=> ps_mainmenu (widget)	0.948 ms	0.16 Mb
=> cp_headercms2 (widget)	0.749 ms	0.06 Mb
DisplayBeforeBodyClosingTag	6.465 ms	0.15 Mb
=> statsdata	3.490 ms	0.04 Mb
=> ps_googleanalytics	2.975 ms	0.11 Mb
DisplayFooter	5.542 ms	0.40 Mb
=> cpcouponpop	0.010 ms	- Mb
=> cp_salenotification	5.532 ms	0.40 Mb
displayLeftColumn	4.872 ms	0.41 Mb
=> ps_categorytree (widget)	2.501 ms	0.38 Mb
=> cp_leftbanner1 (widget)	1.371 ms	- Mb
=> cp_sidebarfeaturedproducts (widget)	1.000 ms	0.08 Mb
displayNav2	2.944 ms	0.20 Mb
=> ps_languageselector (widget)	1.056 ms	0.05 Mb
=> ps_currencyselector (widget)	1.289 ms	0.11 Mb
=> ps_customersignin (widget)	0.599 ms	0.04 Mb
Header	2.861 ms	0.04 Mb
=> pla	0.555 ms	- Mb
=> cp_blocksearch	0.545 ms	- Mb
=> cp_salenotification	0.180 ms	- Mb
=> cp_themeoptions	1.280 ms	0.02 Mb
=> stfeature	0.301 ms	0.01 Mb
DisplayStCompareButton	2.546 ms	0.01 Mb
=> stfeature	0.411 ms	0.01 Mb
=> stfeature	0.531 ms	- Mb
=> stfeature	0.474 ms	- Mb
=> stfeature	0.376 ms	- Mb
=> stfeature	0.366 ms	- Mb
=> stfeature	0.388 ms	- Mb
displayFooterleft	2.520 ms	0.10 Mb
=> ps_contactinfo (widget)	1.636 ms	0.06 Mb
=> ps_socialfollow (widget)	0.884 ms	0.04 Mb
DisplayCpHoverImage	2.472 ms	0.10 Mb
=> cp_imagehover	0.628 ms	0.03 Mb
=> cp_imagehover	1.103 ms	0.03 Mb
=> cp_imagehover	0.741 ms	0.03 Mb
displayHeaderRight	1.950 ms	0.13 Mb
=> ps_shoppingcart (widget)	1.950 ms	0.13 Mb
DisplayStWishlistButton	1.894 ms	0.01 Mb
=> stfeature	0.356 ms	0.01 Mb
=> stfeature	0.367 ms	- Mb
=> stfeature	0.341 ms	- Mb
=> stfeature	0.258 ms	- Mb
=> stfeature	0.241 ms	- Mb
=> stfeature	0.331 ms	- Mb
displaySide	1.828 ms	0.06 Mb
=> ps_currencyselector (widget)	0.772 ms	0.03 Mb
=> ps_languageselector (widget)	0.516 ms	0.01 Mb
=> cp_headercms1 (widget)	0.540 ms	0.02 Mb
displayFooterAfter	1.798 ms	0.06 Mb
=> cp_footercms1 (widget)	1.798 ms	0.06 Mb
DisplayHeader	1.698 ms	0.01 Mb
=> ps_shoppingcart	0.078 ms	- Mb
=> ps_googleanalytics	0.136 ms	- Mb
=> cp_imageslider	0.283 ms	- Mb
=> cp_categorylist	0.118 ms	- Mb
=> cp_categoryproductsslider	0.177 ms	- Mb
=> cpcouponpop	0.005 ms	- Mb
=> cp_countdown	0.190 ms	- Mb
=> ets_blog	0.592 ms	- Mb
=> cp_sideverticalmenu	0.119 ms	- Mb
displayNav1	1.496 ms	0.09 Mb
=> cp_headercms1 (widget)	1.496 ms	0.09 Mb
ProductSearchProvider	1.005 ms	- Mb
=> ps_facetedsearch	1.005 ms	- Mb
DisplayStCompareTopLink	0.990 ms	0.06 Mb
=> stfeature	0.599 ms	0.04 Mb
=> stfeature	0.391 ms	0.03 Mb
displayFooterbefore	0.902 ms	0.05 Mb
=> ps_emailsubscription (widget)	0.902 ms	0.05 Mb
DisplayStWishlistTopLink	0.841 ms	0.04 Mb
=> stfeature	0.546 ms	0.03 Mb
=> stfeature	0.295 ms	- Mb
ActionFrontControllerSetMedia	0.685 ms	0.01 Mb
=> blockreassurance	0.329 ms	- Mb
=> ps_emailsubscription	0.091 ms	- Mb
=> ps_socialfollow	0.110 ms	- Mb
=> ps_emailalerts	0.155 ms	- Mb
DisplayFooterAfter	0.619 ms	0.04 Mb
=> cp_themeoptions	0.619 ms	0.04 Mb
Footer	0.470 ms	0.02 Mb
=> cp_cookie	0.470 ms	0.02 Mb
displayCustomerSide	0.298 ms	- Mb
=> ps_customersignin (widget)	0.298 ms	- Mb
DisplayLeftColumn	0.271 ms	0.02 Mb
=> ps_facetedsearch	0.271 ms	0.02 Mb
ModuleRoutes	0.017 ms	0.01 Mb
=> ets_blog	0.017 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.012 ms	- Mb
=> blockreassurance	0.012 ms	- Mb
29 hook(s)	145.747 ms	12.58 Mb

Module	Time	Memory Usage
ets_blog	5.196 ms	0.01 Mb
__construct	4.580 ms	- Mb
hookModuleRoutes	0.023 ms	0.01 Mb
hookDisplayHeader	0.593 ms	- Mb
blockreassurance	1.098 ms	0.08 Mb
__construct	0.746 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.333 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.019 ms	- Mb
ps_emailsubscription	1.104 ms	0.06 Mb
__construct	0.107 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.092 ms	- Mb
displayFooterbefore	0.905 ms	0.05 Mb
ps_socialfollow	1.073 ms	0.05 Mb
__construct	0.076 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.110 ms	- Mb
displayFooterleft	0.887 ms	0.04 Mb
ps_emailalerts	0.305 ms	0.07 Mb
__construct	0.149 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.156 ms	- Mb
ps_shoppingcart	2.139 ms	0.14 Mb
__construct	0.107 ms	0.01 Mb
hookDisplayHeader	0.081 ms	- Mb
displayHeaderRight	1.951 ms	0.13 Mb
ps_googleanalytics	3.216 ms	0.11 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.136 ms	- Mb
hookDisplayBeforeBodyClosingTag	2.977 ms	0.11 Mb
cp_imageslider	0.592 ms	0.01 Mb
__construct	0.308 ms	0.01 Mb
hookDisplayHeader	0.284 ms	- Mb
cp_categorylist	0.287 ms	0.01 Mb
__construct	0.168 ms	0.01 Mb
hookDisplayHeader	0.119 ms	- Mb
cp_categoryproductsslider	0.353 ms	0.01 Mb
__construct	0.176 ms	0.01 Mb
hookDisplayHeader	0.177 ms	- Mb
cpcouponpop	0.272 ms	0.01 Mb
__construct	0.254 ms	0.01 Mb
hookDisplayHeader	0.006 ms	- Mb
hookDisplayFooter	0.012 ms	- Mb
cp_countdown	0.375 ms	0.01 Mb
__construct	0.184 ms	0.01 Mb
hookDisplayHeader	0.191 ms	- Mb
pla	17.583 ms	2.09 Mb
__construct	0.320 ms	0.01 Mb
hookHeader	0.557 ms	- Mb
hookDisplayProductListReviews	8.199 ms	1.11 Mb
hookDisplayProductListReviews	4.645 ms	0.48 Mb
hookDisplayProductListReviews	3.862 ms	0.48 Mb
cp_blocksearch	68.482 ms	6.80 Mb
__construct	0.189 ms	0.01 Mb
hookHeader	0.547 ms	- Mb
displayHeaderCenter	67.746 ms	6.79 Mb
cp_sideverticalmenu	5.329 ms	0.78 Mb
__construct	0.275 ms	0.01 Mb
hookDisplayHeader	0.121 ms	- Mb
displayNavFullWidth	4.933 ms	0.77 Mb
cp_salenotification	5.785 ms	0.40 Mb
__construct	0.068 ms	0.01 Mb
hookHeader	0.181 ms	- Mb
hookDisplayFooter	5.536 ms	0.40 Mb
cp_themeoptions	3.575 ms	0.18 Mb
__construct	0.343 ms	0.03 Mb
hookHeader	1.281 ms	0.02 Mb
displayFooter	1.330 ms	0.09 Mb
hookDisplayFooterAfter	0.621 ms	0.04 Mb
stfeature	6.899 ms	0.16 Mb
__construct	0.284 ms	0.02 Mb
hookHeader	0.302 ms	0.01 Mb
hookDisplayStCompareTopLink	0.601 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.547 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.296 ms	- Mb
hookDisplayStCompareTopLink	0.392 ms	0.03 Mb
hookDisplayStCompareButton	0.413 ms	0.01 Mb
hookDisplayStWishlistButton	0.357 ms	0.01 Mb
hookDisplayStCompareButton	0.536 ms	- Mb
hookDisplayStWishlistButton	0.371 ms	- Mb
hookDisplayStCompareButton	0.478 ms	- Mb
hookDisplayStWishlistButton	0.346 ms	- Mb
hookDisplayStCompareButton	0.379 ms	- Mb
hookDisplayStWishlistButton	0.260 ms	- Mb
hookDisplayStCompareButton	0.369 ms	- Mb
hookDisplayStWishlistButton	0.242 ms	- Mb
hookDisplayStCompareButton	0.391 ms	- Mb
hookDisplayStWishlistButton	0.334 ms	- Mb
ps_facetedsearch	2.465 ms	0.04 Mb
__construct	1.185 ms	0.01 Mb
hookProductSearchProvider	1.007 ms	- Mb
hookDisplayLeftColumn	0.273 ms	0.02 Mb
cp_headercms1	2.428 ms	0.12 Mb
__construct	0.384 ms	0.01 Mb
displayNav1	1.503 ms	0.09 Mb
displaySide	0.541 ms	0.02 Mb
ps_languageselector	1.731 ms	0.06 Mb
__construct	0.157 ms	0.01 Mb
displayNav2	1.057 ms	0.05 Mb
displaySide	0.517 ms	0.01 Mb
ps_currencyselector	2.164 ms	0.15 Mb
__construct	0.100 ms	0.01 Mb
displayNav2	1.291 ms	0.11 Mb
displaySide	0.773 ms	0.03 Mb
ps_customersignin	1.004 ms	0.05 Mb
__construct	0.104 ms	0.01 Mb
displayNav2	0.600 ms	0.04 Mb
displayCustomerSide	0.300 ms	- Mb
ps_mainmenu	1.133 ms	0.17 Mb
__construct	0.184 ms	0.01 Mb
displayNavFullWidth	0.949 ms	0.17 Mb
cp_headercms2	0.962 ms	0.07 Mb
__construct	0.212 ms	0.01 Mb
displayNavFullWidth	0.750 ms	0.07 Mb
ps_categorytree	2.598 ms	0.39 Mb
__construct	0.095 ms	0.01 Mb
displayLeftColumn	2.503 ms	0.38 Mb
cp_leftbanner1	1.578 ms	- Mb
__construct	0.205 ms	0.01 Mb
displayLeftColumn	1.373 ms	- Mb
cp_sidebarfeaturedproducts	1.171 ms	0.09 Mb
__construct	0.170 ms	0.01 Mb
displayLeftColumn	1.001 ms	0.08 Mb
cp_imagehover	2.666 ms	0.10 Mb
__construct	0.181 ms	0.01 Mb
hookDisplayCpHoverImage	0.630 ms	0.03 Mb
hookDisplayCpHoverImage	1.110 ms	0.03 Mb
hookDisplayCpHoverImage	0.745 ms	0.03 Mb
ps_contactinfo	1.820 ms	0.07 Mb
__construct	0.181 ms	0.01 Mb
displayFooterleft	1.639 ms	0.06 Mb
ps_linklist	7.633 ms	0.62 Mb
__construct	1.262 ms	0.01 Mb
displayFooter	6.371 ms	0.62 Mb
cp_cookie	0.789 ms	0.03 Mb
__construct	0.316 ms	0.01 Mb
hookFooter	0.473 ms	0.02 Mb
cp_footercms1	2.128 ms	0.13 Mb
__construct	0.325 ms	0.07 Mb
displayFooterAfter	1.803 ms	0.06 Mb
statsdata	3.661 ms	0.05 Mb
__construct	0.166 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.495 ms	0.05 Mb
34 module(s)	159.592 ms	13.05 Mb

shop by category

Home

Stendardo di sinistra

Elenco dei prodotti per la marca Lucaffè

Cialde di Carta Ese 44mm Lucaffè su Caffè Diem!

La gamma delle cialde Originali Lucaffe è formata da 11 miscele di Caffè: Blucaffè, Caffè Verde, Classic, Colombia, Decaffeinato, Exquisit, Jamaica Blue Mountain, Mamma Lucia, Mr. Exclusive - 100% Arabica, Nocciola e Pulcinella.

Cialde Ese di Carta Lucaffè Miscela Mamma Lucia Universali e Compostabili

Cialde Ese di Carta Lucaffè Miscela 150 Arabica Universali e Compostabili

Contattaci

Prodotti

La nostra azienda

Stopwatch SQL - 625 queries

Doubles

Tables stress

ObjectModel instances

Included Files

142 queries	SELECT * FROM `vtny_category` a LEFT JOIN `vtny_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `vtny_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
142 queries	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = XX ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = XX) WHERE `id_lang` = XX AND c.`id_parent` = XX AND `active` = XX GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
21 queries	SELECT `id_module` FROM `vtny_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
15 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
12 queries	SELECT `id_image` FROM `vtny_image` WHERE `id_product` = XX AND `cover` = XX ORDER BY position ASC LIMIT XX, XX
9 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
6 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
6 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`
6 queries	SELECT `id_product_attribute` FROM `vtny_product_attribute` WHERE `id_product` = XX
6 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`
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 * FROM `vtny_cms` a LEFT JOIN `vtny_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
5 queries	SELECT * FROM `vtny_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
4 queries	SELECT `id_lang` FROM `vtny_lang` WHERE `locale` = 'it-it' OR `language_code` = 'it-it' LIMIT XX
4 queries	SELECT XX FROM `vtny_specific_price` WHERE id_product = XX LIMIT XX
4 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
4 queries	SELECT * FROM `vtny_attribute_lang` WHERE `id_attribute` = XX
3 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
3 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
3 queries	SELECT name FROM vtny_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
3 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
3 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)
3 queries	SELECT `id_tax_rules_group` FROM `vtny_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
3 queries	SELECT `reduction` FROM `vtny_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3 queries	SELECT COUNT(*) FROM `vtny_pack` WHERE id_product_pack = XX LIMIT XX
3 queries	SELECT product_type FROM `vtny_product` WHERE id_product = XX LIMIT XX
3 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
3 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
3 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
3 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
3 queries	SELECT * FROM `vtny_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT * FROM `vtny_cpheadercmsXXblockinfo_lang` WHERE `id_lang` = XX AND `id_shop` = XX LIMIT XX
3 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
3 queries	SELECT * FROM `vtny_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
3 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`
3 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
3 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;
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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`
3 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
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `vtny_module` m LEFT JOIN `vtny_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT * FROM `vtny_manufacturer` a LEFT JOIN `vtny_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = XX LEFT JOIN `vtny_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = XX WHERE (a.`id_manufacturer` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_currency` a LEFT JOIN `vtny_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `vtny_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_currency` a LEFT JOIN `vtny_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_currency_lang` WHERE `id_currency` = XX
2 queries	SELECT XX FROM `vtny_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT `need_identification_number` FROM `vtny_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `vtny_attribute_group` ag INNER JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `vtny_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN vtny_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `vtny_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
2 queries	SELECT tr.* FROM `vtny_tax_rule` tr JOIN `vtny_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT `id_module` FROM `vtny_module` WHERE `name` = "cp_headercmsXX" LIMIT XX
2 queries	SELECT * FROM `vtny_currency` c INNER JOIN vtny_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE c.`deleted` = XX AND c.`active` = XX ORDER BY `iso_code` ASC
2 queries	SELECT DISTINCT `id_product` FROM `vtny_stfeature_compare` c LEFT JOIN `vtny_stfeature_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = XX
2 queries	SELECT * FROM `vtny_link_block` a LEFT JOIN `vtny_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `vtny_link_block_lang` WHERE `id_link_block` = XX

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

#	Query	Time (ms)	Rows	Filesort	Group By	Location
619	INSERT INTO `vtny_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('6227', '', 'caffe.solnetwork.it/it/brand/27-lucaffe?q=Offerta-300+Cialde-150+Cialde', '', '2026-04-01 17:09:49')	2.084 ms	1			/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1077 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:400 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:134 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
80	REPLACE INTO vtny_layered_filter_block (hash, data) VALUES ("e5d5e533e39619df6d7b93491f8c7663", "a:1:{s:7:\"filters\";a:8:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:14:\"Disponibilità\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:12:\"In magazzino\";s:3:\"nbr\";i:2;}i:0;a:2:{s:4:\"name\";s:15:\"Non disponibile\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Selezioni\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:8:\"In saldo\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:14:\"Nuovo prodotto\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:8:\"Scontato\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Prezzo\";s:3:\"max\";d:55;s:3:\"min\";d:38;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:1:\".\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:3;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Categorie\";s:6:\"values\";a:1:{i:124;a:2:{s:4:\"name\";s:21:\"Cialde Caffè Lucaffe\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:2;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:5;s:4:\"name\";s:7:\"Offerta\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:7:{i:32;a:5:{s:4:\"name\";s:10:\"150 Cialde\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:29;a:5:{s:4:\"name\";s:10:\"300 Cialde\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:30;a:4:{s:4:\"name\";s:10:\"450 Cialde\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:31;a:4:{s:4:\"name\";s:10:\"600 Cialde\";s:3:\"nbr\";i:3;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:5;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:5;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:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Condizione\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:5:\"Nuovo\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:5:\"Usati\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:14:\"imesso a nuovo\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Marca\";s:6:\"values\";a:1:{i:27;a:2:{s:4:\"name\";s:8:\"Lucaffè\";s:3:\"nbr\";i:3;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Peso\";s:3:\"max\";d:1.5100000000000000088817841970012523233890533447265625;s:3:\"min\";d:1.5100000000000000088817841970012523233890533447265625;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:3;}}}")	1.830 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `vtny_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `vtny_hook_alias` ha INNER JOIN `vtny_hook` h ON ha.name = h.name	1.805 ms	0			/classes/Hook.php:1326 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29))) GROUP BY p.id_manufacturer	1.605 ms	3042	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
61	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' GROUP BY p.id_product) p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	1.451 ms	6084	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29))) GROUP BY pac.id_attribute	1.415 ms	3042	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
63	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29)))	1.221 ms	3042			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:480 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `vtny_hook_module` hm STRAIGHT_JOIN `vtny_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `vtny_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.166 ms	425			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
474	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `vtny_category` c INNER JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) INNER JOIN `vtny_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND nleft >= 2 AND nright <= 341 AND c.id_category IN ( SELECT id_category FROM `vtny_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	1.101 ms	171	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:285 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:95 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `vtny_module` m INNER JOIN vtny_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `vtny_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `vtny_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `vtny_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	1.088 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)
72	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<341 GROUP BY cp.id_category	1.010 ms	6084	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
65	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29)))	0.996 ms	3042			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:505 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
64	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29)))	0.975 ms	3042			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:494 (count) /modules/ps_facetedsearch/src/Filters/Block.php:140 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
73	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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	0.944 ms	3042	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
74	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29))) GROUP BY p.condition	0.856 ms	3042	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:394 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:137 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
75	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `vtny_manufacturer` m INNER JOIN vtny_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `vtny_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.775 ms	38	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-04-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM vtny_product p LEFT JOIN vtny_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN vtny_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN vtny_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (239,241,240)	0.737 ms	3			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
621	SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `vtny_category_product` cp LEFT JOIN `vtny_category` c ON (c.id_category = cp.id_category) LEFT JOIN `vtny_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (239,241,240) AND cl.`id_lang` = 2 ORDER BY c.`level_depth` DESC	0.724 ms	3	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109 /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:68 (loadCategories) /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/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
68	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 17:09:49' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-04-01 17:09:49' <= 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 (32, 29)))	0.700 ms	36			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `vtny_cart_product` cp WHERE cp.`id_product_attribute` = 418 AND cp.`id_cart` = 0 AND cp.`id_product` = 239 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `vtny_cart_product` cp JOIN `vtny_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `vtny_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 418 AND cp.`id_cart` = 0 AND p.`id_product_item` = 239 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.675 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5810 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
66	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29)))	0.664 ms	3042			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:565 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
77	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM vtny_product p INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27'	0.638 ms	78			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:744 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:339 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:134 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
181	SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 2 AND c.`id_parent` = 14 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.629 ms	19	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:137 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4239401d8_62880707) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:206 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:58 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
598	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE c.`id_category` IN (SELECT DISTINCT `id_category` FROM `vtny_category_product` WHERE 1) AND c.`active` = 1 AND cl.`id_lang` = 2	0.596 ms	6248			/modules/cp_salenotification/cp_salenotification.php:479 /modules/cp_salenotification/cp_salenotification.php:361 (getCategory) /classes/Hook.php:1077 (hookdisplayFooter) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/79/2b/15/792b152cfc1ff0b7b26ad1325bfe97dc8a5fba4c_2.file.footer.tpl.php:83 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/79/2b/15/792b152cfc1ff0b7b26ad1325bfe97dc8a5fba4c_2.file.footer.tpl.php:46 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a423c747b4_14960322) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:364 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:123 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
67	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM vtny_product p LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN vtny_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN vtny_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27' 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 (32, 29))) AND p.date_add>'2026-03-13 00:00:00'	0.584 ms	3042			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:757 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:587 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
152	SELECT SQL_NO_CACHE * FROM `vtny_product` a LEFT JOIN `vtny_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2 LEFT JOIN `vtny_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 241) AND (b.`id_shop` = 1) LIMIT 1	0.575 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /classes/controller/ProductListingFrontController.php:119 (present) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
521	SELECT SQL_NO_CACHE 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 = 1) LEFT JOIN `vtny_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2) WHERE i.`id_product` = 241 ORDER BY `position`	0.571 ms	1	Yes		/classes/Product.php:3545 /modules/cp_imagehover/cp_imagehover.php:70 (getImages) /classes/Hook.php:1077 (hookDisplayCpHoverImage) /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:153 (__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:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
102	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity FROM `vtny_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 239 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `vtny_cart_product` cp JOIN `vtny_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `vtny_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 239 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.570 ms	0			/classes/Cart.php:1426 /classes/Product.php:4357 (getProductQuantity) /classes/Product.php:5798 (getQuantity) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `vtny_configuration` c LEFT JOIN `vtny_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	0.565 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)
6	SELECT SQL_NO_CACHE * FROM `vtny_country` a LEFT JOIN `vtny_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2 LEFT JOIN `vtny_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 10) LIMIT 1	0.564 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /config/config.inc.php:146 (__construct) /index.php:27 (require)
548	SELECT SQL_NO_CACHE 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` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pac.id_product_attribute IN (426,427,428,429) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	0.555 ms	4			/classes/Product.php:2752 /src/Adapter/Presenter/Product/ProductLazyArray.php:667 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/5a/fc/ed/5afced99b8fa46df71fafd616254c72b97e9ace0_2.file.product-flags.tpl.php:44 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/5a/fc/ed/5afced99b8fa46df71fafd616254c72b97e9ace0_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b67b11_56470283) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	SELECT SQL_NO_CACHE 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` = 1 AND tr.`id_country` = 10 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	0.548 ms	1			/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3926 (getTaxCalculator) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5688 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
69	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM vtny_product p INNER JOIN vtny_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 2 AND psi.id_country = 10) INNER JOIN vtny_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN vtny_category_product cp ON (p.id_product = cp.id_product) INNER JOIN vtny_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN vtny_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN vtny_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN vtny_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (32, 29))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='27'	0.547 ms	78			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	0.542 ms	10	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
179	SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 2 AND c.`id_parent` = 190 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.531 ms	1	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:137 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4239401d8_62880707) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:206 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:58 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
620	SELECT SQL_NO_CACHE data FROM `vtny_ganalytics_data` WHERE id_cart = 0 AND id_shop = 1 LIMIT 1	0.525 ms	0			/modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43 /modules/ps_googleanalytics/classes/Handler/GanalyticsDataHandler.php:53 (findDataByCartIdAndShopId) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:267 (readData) /modules/ps_googleanalytics/classes/Hook/HookDisplayBeforeBodyClosingTag.php:54 (outputStoredEvents) /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/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
125	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `vtny_attribute` a LEFT JOIN `vtny_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) 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 = 1) LEFT JOIN `vtny_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 241 AND pac.`id_product_attribute` = 434 AND agl.`id_lang` = 2	0.520 ms	1			/classes/Product.php:7530 /classes/Product.php:5853 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
107	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `vtny_attribute` a LEFT JOIN `vtny_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) 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 = 1) LEFT JOIN `vtny_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2) LEFT JOIN `vtny_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 239 AND pac.`id_product_attribute` = 418 AND agl.`id_lang` = 2	0.504 ms	1			/classes/Product.php:7530 /classes/Product.php:5853 (getAttributesParams) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
59	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` = 2) 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` = 2) 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` = 2) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC	0.498 ms	64	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	SELECT SQL_NO_CACHE 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 = 1) WHERE i.`id_product` = 239 AND image_shop.`cover` = 1 LIMIT 1	0.492 ms	1			/classes/Product.php:3570 /classes/Product.php:5639 (getCover) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

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

shop by category

Home  

Stendardo di sinistra  

Elenco dei prodotti per la marca Lucaffè

Cialde di Carta Ese 44mm Lucaffè su Caffè Diem!

La gamma delle cialde Originali Lucaffe è formata da 11 miscele di Caffè: Blucaffè, Caffè Verde, Classic, Colombia, Decaffeinato, Exquisit, Jamaica Blue Mountain, Mamma Lucia, Mr. Exclusive - 100% Arabica, Nocciola e Pulcinella.

Cialde Ese di Carta Lucaffè Miscela Mamma Lucia Universali e Compostabili

Cialde Ese di Carta Lucaffè Miscela 150 Arabica Universali e Compostabili

Stopwatch SQL - 625 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Home

Stendardo di sinistra