List of products by brand CAFFE TOSTINI

CAFFE TOSTINI Coffee Beans Tostini Cremoso 3 Kg

Offerte

Tostini Coffee Beans Cremoso 1KG - Domestic or Work Coffee Machine.

45.90

In Stock 55 Products

Out-of-Stock

CAFFE TOSTINI Offer 300 Coffee Pods Caffè Tostini 8 Grams

300 Coffee Pods Caffè Tostini, 2 Box of 150 Coffee Pods!

50.90

Out of Stock

CAFFE TOSTINI 100 Capsule Nespresso Tostini Caffe Miscela Red

Offerte

21.90

Out of Stock

CAFFE TOSTINI Coffee Beans Tostini Cremoso 6 Kg

Tostini Coffee Beans Cremoso 6KG - Domestic or Work Coffee Machine.

85.90

In Stock 20 Products

Out-of-Stock

CAFFE TOSTINI 100 Capsule Nespresso Tostini Caffe Miscela Black

Offerte

19.90

Out of Stock

CAFFE TOSTINI 150 Coffee Pods Caffè Tostini 8 Grams

Offerte

150 Coffee Pods Caffè Tostini, Box of 150 Coffee Pods!

27.90

In Stock 88 Products

CAFFE TOSTINI Coffee Beans Tostini Cremoso 12 Kg

Tostini Coffee Beans Cremoso 12KG - Domestic or Work Coffee Machine.

164.90

In Stock 29 Products

150 Coffee Pods Caffè Tostini Black 8 Grams

Out-of-Stock

CAFFE TOSTINI 150 Coffee Pods Caffè Tostini BLACK 8 Grams

Offerte

150 Coffee Pods Caffè Tostini, Box of 150 Coffee Pods!

28.90

Out of Stock

Out-of-Stock

CAFFE TOSTINI Coffee Beans Tostini Desirèe 3 Kg

Tostini Coffee Beans Desirèe 1KG - Domestic or Work Coffee Machine.

72.00

Out of Stock

CAFFE TOSTINI 150 Coffee Pods Caffè Tostini DEK 8 Grams

Offerte

150 Coffee Pods Caffè Tostini DEK 8 Grams

35.90

In Stock 72 Products

CAFFE TOSTINI 300 Coffee Pods Caffè Tostini 8 Grams

300 Coffee Pods Caffè Tostini, Box of 150 Coffee Pods!

49.90

In Stock 8 Products

Out-of-Stock

CAFFE TOSTINI Coffee Beans Tostini MAX 3 Kg

Offerte

Tostini Coffee Beans Desirèe 1KG - Domestic or Work Coffee Machine.

47.90

Out of Stock

Load Time	477.913 ms
Querying Time	260 ms
Queries	951
Memory Peak Usage	27.2 Mb
Included Files	775 files - 10.07 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	8k
- global $smarty	5k
- global $config	5k
- global $context	4k
- global $exportPhpConfigFile	4k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k

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

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	1.985 ms	1.985 ms	2.16 Mb	2.6 Mb
__construct	0.014 ms	1.999 ms	- Mb	2.6 Mb
init	24.178 ms	26.177 ms	0.43 Mb	3.0 Mb
checkAccess	0.001 ms	26.178 ms	- Mb	3.0 Mb
setMedia	3.324 ms	29.502 ms	0.18 Mb	3.0 Mb
postProcess	0.002 ms	29.504 ms	- Mb	3.0 Mb
initHeader	0.002 ms	29.506 ms	- Mb	3.0 Mb
initContent	154.448 ms	183.954 ms	4.56 Mb	7.4 Mb
initFooter	0.004 ms	183.958 ms	- Mb	7.4 Mb
display	293.955 ms	477.913 ms	18.95 Mb	27.2 Mb

Hook	Time	Memory Usage
displayHeaderCenter	113.338 ms	6.69 Mb
=> cp_blocksearch (widget)	113.338 ms	6.69 Mb
DisplayProductListReviews	49.816 ms	5.99 Mb
=> pla	8.009 ms	0.99 Mb
=> pla	4.070 ms	0.29 Mb
=> pla	7.031 ms	0.86 Mb
=> pla	3.096 ms	0.29 Mb
=> pla	5.513 ms	0.51 Mb
=> pla	4.707 ms	0.75 Mb
=> pla	2.115 ms	0.29 Mb
=> pla	2.381 ms	0.48 Mb
=> pla	1.592 ms	0.29 Mb
=> pla	3.134 ms	0.48 Mb
=> pla	2.357 ms	0.29 Mb
=> pla	5.811 ms	0.45 Mb
DisplayCpHoverImage	11.597 ms	0.40 Mb
=> cp_imagehover	1.028 ms	0.03 Mb
=> cp_imagehover	1.678 ms	0.04 Mb
=> cp_imagehover	1.130 ms	0.03 Mb
=> cp_imagehover	0.807 ms	0.03 Mb
=> cp_imagehover	0.846 ms	0.03 Mb
=> cp_imagehover	1.444 ms	0.04 Mb
=> cp_imagehover	0.630 ms	0.03 Mb
=> cp_imagehover	0.841 ms	0.03 Mb
=> cp_imagehover	0.538 ms	0.03 Mb
=> cp_imagehover	0.772 ms	0.04 Mb
=> cp_imagehover	1.153 ms	0.04 Mb
=> cp_imagehover	0.730 ms	0.03 Mb
DisplayStCompareButton	10.159 ms	0.04 Mb
=> stfeature	0.613 ms	0.01 Mb
=> stfeature	0.502 ms	- Mb
=> stfeature	0.394 ms	- Mb
=> stfeature	0.638 ms	- Mb
=> stfeature	0.568 ms	- Mb
=> stfeature	0.432 ms	- Mb
=> stfeature	0.459 ms	- Mb
=> stfeature	0.397 ms	- Mb
=> stfeature	0.482 ms	- Mb
=> stfeature	0.503 ms	- Mb
=> stfeature	0.377 ms	- Mb
=> stfeature	0.338 ms	- Mb
=> stfeature	0.506 ms	- Mb
=> stfeature	0.278 ms	0.02 Mb
=> stfeature	0.331 ms	- Mb
=> stfeature	0.300 ms	- Mb
=> stfeature	0.333 ms	- Mb
=> stfeature	0.293 ms	- Mb
=> stfeature	0.320 ms	- Mb
=> stfeature	0.389 ms	- Mb
=> stfeature	0.387 ms	- Mb
=> stfeature	0.397 ms	- Mb
=> stfeature	0.437 ms	- Mb
=> stfeature	0.485 ms	- Mb
displayNavFullWidth	9.978 ms	1.01 Mb
=> cp_sideverticalmenu (widget)	7.322 ms	0.78 Mb
=> ps_mainmenu (widget)	1.416 ms	0.16 Mb
=> cp_headercms2 (widget)	1.240 ms	0.06 Mb
DisplayStWishlistButton	8.563 ms	0.03 Mb
=> stfeature	0.440 ms	0.01 Mb
=> stfeature	0.458 ms	- Mb
=> stfeature	0.358 ms	- Mb
=> stfeature	0.408 ms	- Mb
=> stfeature	0.401 ms	- Mb
=> stfeature	0.418 ms	- Mb
=> stfeature	0.438 ms	- Mb
=> stfeature	0.431 ms	- Mb
=> stfeature	0.472 ms	- Mb
=> stfeature	0.393 ms	- Mb
=> stfeature	0.354 ms	- Mb
=> stfeature	0.333 ms	- Mb
=> stfeature	0.326 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.334 ms	- Mb
=> stfeature	0.265 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.263 ms	- Mb
=> stfeature	0.294 ms	- Mb
=> stfeature	0.339 ms	- Mb
=> stfeature	0.321 ms	- Mb
=> stfeature	0.339 ms	- Mb
=> stfeature	0.381 ms	- Mb
=> stfeature	0.311 ms	- Mb
DisplayBeforeBodyClosingTag	7.876 ms	0.22 Mb
=> statsdata	3.672 ms	0.04 Mb
=> ps_googleanalytics	4.204 ms	0.18 Mb
DisplayFooter	7.271 ms	0.39 Mb
=> cpcouponpop	0.010 ms	- Mb
=> cp_salenotification	7.261 ms	0.39 Mb
displayFooter	7.192 ms	0.69 Mb
=> ps_linklist (widget)	6.098 ms	0.61 Mb
=> cp_themeoptions (widget)	1.094 ms	0.08 Mb
displayLeftColumn	7.107 ms	0.33 Mb
=> ps_categorytree (widget)	3.554 ms	0.23 Mb
=> cp_leftbanner1 (widget)	1.932 ms	0.03 Mb
=> cp_sidebarfeaturedproducts (widget)	1.621 ms	0.08 Mb
displayNav2	4.021 ms	0.20 Mb
=> ps_languageselector (widget)	1.062 ms	0.05 Mb
=> ps_currencyselector (widget)	2.161 ms	0.11 Mb
=> ps_customersignin (widget)	0.798 ms	0.04 Mb
Header	4.012 ms	0.04 Mb
=> pla	0.771 ms	- Mb
=> cp_blocksearch	0.756 ms	- Mb
=> cp_salenotification	0.213 ms	- Mb
=> cp_themeoptions	1.777 ms	0.02 Mb
=> stfeature	0.495 ms	0.01 Mb
displayHeaderRight	3.050 ms	0.13 Mb
=> ps_shoppingcart (widget)	3.050 ms	0.13 Mb
displaySide	2.647 ms	0.06 Mb
=> ps_currencyselector (widget)	1.323 ms	0.03 Mb
=> ps_languageselector (widget)	0.526 ms	0.01 Mb
=> cp_headercms1 (widget)	0.798 ms	0.02 Mb
displayFooterleft	2.239 ms	0.10 Mb
=> ps_contactinfo (widget)	1.350 ms	0.06 Mb
=> ps_socialfollow (widget)	0.889 ms	0.04 Mb
DisplayHeader	2.169 ms	0.01 Mb
=> ps_shoppingcart	0.185 ms	- Mb
=> ps_googleanalytics	0.240 ms	- Mb
=> cp_imageslider	0.299 ms	- Mb
=> cp_categorylist	0.118 ms	- Mb
=> cp_categoryproductsslider	0.200 ms	- Mb
=> cpcouponpop	0.014 ms	- Mb
=> cp_countdown	0.244 ms	- Mb
=> ets_blog	0.735 ms	- Mb
=> cp_sideverticalmenu	0.134 ms	- Mb
displayNav1	1.824 ms	0.09 Mb
=> cp_headercms1 (widget)	1.824 ms	0.09 Mb
DisplayStCompareTopLink	1.695 ms	0.06 Mb
=> stfeature	0.948 ms	0.04 Mb
=> stfeature	0.747 ms	0.03 Mb
ProductSearchProvider	1.411 ms	- Mb
=> ps_facetedsearch	1.411 ms	- Mb
displayFooterAfter	1.408 ms	0.06 Mb
=> cp_footercms1 (widget)	1.408 ms	0.06 Mb
displayFooterbefore	1.191 ms	0.05 Mb
=> ps_emailsubscription (widget)	1.191 ms	0.05 Mb
DisplayStWishlistTopLink	1.187 ms	0.04 Mb
=> stfeature	0.857 ms	0.03 Mb
=> stfeature	0.330 ms	- Mb
ActionFrontControllerSetMedia	0.715 ms	0.01 Mb
=> blockreassurance	0.377 ms	- Mb
=> ps_emailsubscription	0.099 ms	- Mb
=> ps_socialfollow	0.104 ms	- Mb
=> ps_emailalerts	0.135 ms	- Mb
DisplayFooterAfter	0.549 ms	0.04 Mb
=> cp_themeoptions	0.549 ms	0.04 Mb
displayCustomerSide	0.405 ms	- Mb
=> ps_customersignin (widget)	0.405 ms	- Mb
Footer	0.383 ms	0.09 Mb
=> cp_cookie	0.383 ms	0.09 Mb
DisplayLeftColumn	0.368 ms	0.03 Mb
=> ps_facetedsearch	0.368 ms	0.03 Mb
DisplayAfterBodyOpeningTag	0.014 ms	- Mb
=> blockreassurance	0.014 ms	- Mb
ModuleRoutes	0.013 ms	0.01 Mb
=> ets_blog	0.013 ms	0.01 Mb
29 hook(s)	262.198 ms	16.82 Mb

Module	Time	Memory Usage
ets_blog	5.350 ms	0.01 Mb
__construct	4.597 ms	- Mb
hookModuleRoutes	0.016 ms	0.01 Mb
hookDisplayHeader	0.737 ms	- Mb
blockreassurance	1.159 ms	0.08 Mb
__construct	0.757 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.382 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.020 ms	- Mb
ps_emailsubscription	1.402 ms	0.06 Mb
__construct	0.107 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.100 ms	- Mb
displayFooterbefore	1.195 ms	0.05 Mb
ps_socialfollow	1.066 ms	0.05 Mb
__construct	0.069 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.104 ms	- Mb
displayFooterleft	0.893 ms	0.04 Mb
ps_emailalerts	0.291 ms	0.07 Mb
__construct	0.156 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.135 ms	- Mb
ps_shoppingcart	3.472 ms	0.14 Mb
__construct	0.228 ms	0.01 Mb
hookDisplayHeader	0.193 ms	- Mb
displayHeaderRight	3.051 ms	0.13 Mb
ps_googleanalytics	4.619 ms	0.19 Mb
__construct	0.167 ms	0.01 Mb
hookDisplayHeader	0.242 ms	- Mb
hookDisplayBeforeBodyClosingTag	4.210 ms	0.18 Mb
cp_imageslider	0.745 ms	0.01 Mb
__construct	0.445 ms	0.01 Mb
hookDisplayHeader	0.300 ms	- Mb
cp_categorylist	0.384 ms	0.01 Mb
__construct	0.264 ms	0.01 Mb
hookDisplayHeader	0.120 ms	- Mb
cp_categoryproductsslider	0.412 ms	0.01 Mb
__construct	0.210 ms	0.01 Mb
hookDisplayHeader	0.202 ms	- Mb
cpcouponpop	0.431 ms	0.01 Mb
__construct	0.403 ms	0.01 Mb
hookDisplayHeader	0.016 ms	- Mb
hookDisplayFooter	0.012 ms	- Mb
cp_countdown	0.492 ms	0.01 Mb
__construct	0.247 ms	0.01 Mb
hookDisplayHeader	0.245 ms	- Mb
pla	51.137 ms	6.01 Mb
__construct	0.497 ms	0.01 Mb
hookHeader	0.774 ms	- Mb
hookDisplayProductListReviews	8.013 ms	0.99 Mb
hookDisplayProductListReviews	4.080 ms	0.29 Mb
hookDisplayProductListReviews	7.035 ms	0.86 Mb
hookDisplayProductListReviews	3.101 ms	0.29 Mb
hookDisplayProductListReviews	5.516 ms	0.51 Mb
hookDisplayProductListReviews	4.709 ms	0.75 Mb
hookDisplayProductListReviews	2.118 ms	0.29 Mb
hookDisplayProductListReviews	2.383 ms	0.48 Mb
hookDisplayProductListReviews	1.595 ms	0.29 Mb
hookDisplayProductListReviews	3.136 ms	0.48 Mb
hookDisplayProductListReviews	2.360 ms	0.29 Mb
hookDisplayProductListReviews	5.820 ms	0.45 Mb
cp_blocksearch	114.425 ms	6.71 Mb
__construct	0.299 ms	0.01 Mb
hookHeader	0.777 ms	- Mb
displayHeaderCenter	113.349 ms	6.70 Mb
cp_sideverticalmenu	7.830 ms	0.79 Mb
__construct	0.370 ms	0.01 Mb
hookDisplayHeader	0.137 ms	- Mb
displayNavFullWidth	7.323 ms	0.78 Mb
cp_salenotification	7.609 ms	0.40 Mb
__construct	0.130 ms	0.01 Mb
hookHeader	0.214 ms	- Mb
hookDisplayFooter	7.265 ms	0.39 Mb
cp_themeoptions	4.032 ms	0.17 Mb
__construct	0.589 ms	0.03 Mb
hookHeader	1.781 ms	0.02 Mb
displayFooter	1.112 ms	0.08 Mb
hookDisplayFooterAfter	0.550 ms	0.04 Mb
stfeature	22.653 ms	0.21 Mb
__construct	0.414 ms	0.01 Mb
hookHeader	0.498 ms	0.01 Mb
hookDisplayStCompareTopLink	0.953 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.860 ms	0.04 Mb
hookDisplayStWishlistTopLink	0.332 ms	- Mb
hookDisplayStCompareTopLink	0.750 ms	0.03 Mb
hookDisplayStCompareButton	0.616 ms	0.01 Mb
hookDisplayStWishlistButton	0.441 ms	0.01 Mb
hookDisplayStCompareButton	0.505 ms	- Mb
hookDisplayStWishlistButton	0.463 ms	- Mb
hookDisplayStCompareButton	0.396 ms	- Mb
hookDisplayStWishlistButton	0.360 ms	- Mb
hookDisplayStCompareButton	0.643 ms	- Mb
hookDisplayStWishlistButton	0.413 ms	- Mb
hookDisplayStCompareButton	0.571 ms	- Mb
hookDisplayStWishlistButton	0.405 ms	- Mb
hookDisplayStCompareButton	0.436 ms	- Mb
hookDisplayStWishlistButton	0.421 ms	- Mb
hookDisplayStCompareButton	0.462 ms	- Mb
hookDisplayStWishlistButton	0.441 ms	- Mb
hookDisplayStCompareButton	0.401 ms	- Mb
hookDisplayStWishlistButton	0.434 ms	- Mb
hookDisplayStCompareButton	0.486 ms	- Mb
hookDisplayStWishlistButton	0.476 ms	- Mb
hookDisplayStCompareButton	0.506 ms	- Mb
hookDisplayStWishlistButton	0.395 ms	- Mb
hookDisplayStCompareButton	0.379 ms	- Mb
hookDisplayStWishlistButton	0.356 ms	- Mb
hookDisplayStCompareButton	0.340 ms	- Mb
hookDisplayStWishlistButton	0.335 ms	- Mb
hookDisplayStCompareButton	0.508 ms	- Mb
hookDisplayStWishlistButton	0.327 ms	- Mb
hookDisplayStCompareButton	0.280 ms	0.02 Mb
hookDisplayStWishlistButton	0.244 ms	- Mb
hookDisplayStCompareButton	0.333 ms	- Mb
hookDisplayStWishlistButton	0.336 ms	- Mb
hookDisplayStCompareButton	0.302 ms	- Mb
hookDisplayStWishlistButton	0.266 ms	- Mb
hookDisplayStCompareButton	0.335 ms	- Mb
hookDisplayStWishlistButton	0.244 ms	- Mb
hookDisplayStCompareButton	0.295 ms	- Mb
hookDisplayStWishlistButton	0.265 ms	- Mb
hookDisplayStCompareButton	0.322 ms	- Mb
hookDisplayStWishlistButton	0.296 ms	- Mb
hookDisplayStCompareButton	0.391 ms	- Mb
hookDisplayStWishlistButton	0.340 ms	- Mb
hookDisplayStCompareButton	0.389 ms	- Mb
hookDisplayStWishlistButton	0.323 ms	- Mb
hookDisplayStCompareButton	0.399 ms	- Mb
hookDisplayStWishlistButton	0.341 ms	- Mb
hookDisplayStCompareButton	0.440 ms	- Mb
hookDisplayStWishlistButton	0.384 ms	- Mb
hookDisplayStCompareButton	0.491 ms	- Mb
hookDisplayStWishlistButton	0.314 ms	- Mb
ps_facetedsearch	3.383 ms	0.05 Mb
__construct	1.598 ms	0.01 Mb
hookProductSearchProvider	1.415 ms	- Mb
hookDisplayLeftColumn	0.370 ms	0.03 Mb
cp_headercms1	2.967 ms	0.12 Mb
__construct	0.339 ms	0.01 Mb
displayNav1	1.828 ms	0.09 Mb
displaySide	0.800 ms	0.02 Mb
ps_languageselector	1.721 ms	0.06 Mb
__construct	0.130 ms	0.01 Mb
displayNav2	1.064 ms	0.05 Mb
displaySide	0.527 ms	0.01 Mb
ps_currencyselector	3.590 ms	0.15 Mb
__construct	0.102 ms	0.01 Mb
displayNav2	2.162 ms	0.11 Mb
displaySide	1.326 ms	0.03 Mb
ps_customersignin	1.310 ms	0.05 Mb
__construct	0.103 ms	0.01 Mb
displayNav2	0.799 ms	0.04 Mb
displayCustomerSide	0.408 ms	- Mb
ps_mainmenu	1.728 ms	0.17 Mb
__construct	0.308 ms	0.01 Mb
displayNavFullWidth	1.420 ms	0.17 Mb
cp_headercms2	1.564 ms	0.07 Mb
__construct	0.320 ms	0.01 Mb
displayNavFullWidth	1.244 ms	0.07 Mb
ps_categorytree	3.689 ms	0.23 Mb
__construct	0.132 ms	0.01 Mb
displayLeftColumn	3.557 ms	0.23 Mb
cp_leftbanner1	2.219 ms	0.03 Mb
__construct	0.284 ms	0.01 Mb
displayLeftColumn	1.935 ms	0.03 Mb
cp_sidebarfeaturedproducts	1.827 ms	0.09 Mb
__construct	0.203 ms	0.01 Mb
displayLeftColumn	1.624 ms	0.08 Mb
cp_imagehover	11.873 ms	0.41 Mb
__construct	0.227 ms	0.01 Mb
hookDisplayCpHoverImage	1.031 ms	0.03 Mb
hookDisplayCpHoverImage	1.683 ms	0.04 Mb
hookDisplayCpHoverImage	1.138 ms	0.03 Mb
hookDisplayCpHoverImage	0.811 ms	0.03 Mb
hookDisplayCpHoverImage	0.851 ms	0.03 Mb
hookDisplayCpHoverImage	1.449 ms	0.04 Mb
hookDisplayCpHoverImage	0.633 ms	0.03 Mb
hookDisplayCpHoverImage	0.845 ms	0.04 Mb
hookDisplayCpHoverImage	0.541 ms	0.03 Mb
hookDisplayCpHoverImage	0.774 ms	0.04 Mb
hookDisplayCpHoverImage	1.156 ms	0.04 Mb
hookDisplayCpHoverImage	0.734 ms	0.03 Mb
ps_contactinfo	1.567 ms	0.07 Mb
__construct	0.214 ms	0.01 Mb
displayFooterleft	1.353 ms	0.06 Mb
ps_linklist	7.362 ms	0.62 Mb
__construct	1.260 ms	0.01 Mb
displayFooter	6.102 ms	0.61 Mb
cp_cookie	0.650 ms	0.09 Mb
__construct	0.266 ms	0.01 Mb
hookFooter	0.384 ms	0.09 Mb
cp_footercms1	1.711 ms	0.07 Mb
__construct	0.299 ms	0.01 Mb
displayFooterAfter	1.412 ms	0.06 Mb
statsdata	3.839 ms	0.05 Mb
__construct	0.163 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.676 ms	0.05 Mb
34 module(s)	278.509 ms	17.24 Mb

shop by category

Home

Left Banner

List of products by brand CAFFE TOSTINI

Contact us

Products

Our company

Stopwatch SQL - 951 queries

Doubles

Tables stress

ObjectModel instances

Included Files

#	Query	Time (ms)	Rows	Filesort	Group By	Location
73	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, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND cg.id_group='1' AND c.nleft>2 AND c.nright<341 GROUP BY cp.id_category	2.606 ms	11664	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)
941	INSERT INTO `vtny_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('6698', '', 'caffe.solnetwork.it/en/brand/41-caffe-tostini?q=Availability-In+stock-Not+available', '', '2026-04-01 18:54:01')	2.281 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)
82	REPLACE INTO vtny_layered_filter_block (hash, data) VALUES ("7f92e69104b5ed5828e1df84349e3c3f", "a:1:{s:7:\"filters\";a:8:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:12:\"Availability\";s:6:\"values\";a:2:{i:2;a:3:{s:4:\"name\";s:8:\"In stock\";s:3:\"nbr\";i:9;s:7:\"checked\";b:1;}i:0;a:3:{s:4:\"name\";s:13:\"Not available\";s:3:\"nbr\";i:10;s:7:\"checked\";b:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:7:\"On sale\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:11:\"New product\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Price\";s:3:\"max\";d:165;s:3:\"min\";d:19;s:4:\"unit\";s:0:\"\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:0:\"\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\".\";i:1;s:1:\",\";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:10:\"¤#,##0.00\";s:15:\"negativePattern\";s:11:\"-¤#,##0.00\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:18;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Categories\";s:6:\"values\";a:3:{i:178;a:2:{s:4:\"name\";s:21:\"Cialde Caffè Tostini\";s:3:\"nbr\";i:10;}i:179;a:2:{s:4:\"name\";s:17:\"Tostini Nespresso\";s:3:\"nbr\";i:2;}i:183;a:2:{s:4:\"name\";s:20:\"Grani Caffè Tostini\";s:3:\"nbr\";i:6;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:2;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:5;s:4:\"name\";s:5:\"Offer\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:14:{i:33;a:4:{s:4:\"name\";s:11:\"100 Capsule\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:34;a:4:{s:4:\"name\";s:11:\"200 Capsule\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:35;a:4:{s:4:\"name\";s:11:\"300 Capsule\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:36;a:4:{s:4:\"name\";s:11:\"400 Capsule\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:38;a:4:{s:4:\"name\";s:11:\"600 Capsule\";s:3:\"nbr\";i:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:32;a:4:{s:4:\"name\";s:8:\"150 Pods\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:29;a:4:{s:4:\"name\";s:8:\"300 Pods\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:30;a:4:{s:4:\"name\";s:8:\"450 Pods\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:31;a:4:{s:4:\"name\";s:8:\"600 Pods\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:60;a:4:{s:4:\"name\";s:4:\"1 Kg\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:94;a:4:{s:4:\"name\";s:4:\"2 Kg\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:58;a:4:{s:4:\"name\";s:4:\"3 Kg\";s:3:\"nbr\";i:3;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:2;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:2;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Condition\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:3:\"New\";s:3:\"nbr\";i:18;}s:4:\"used\";a:2:{s:4:\"name\";s:4:\"Used\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Refurbished\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:5:\"Brand\";s:6:\"values\";a:1:{i:41;a:2:{s:4:\"name\";s:13:\"CAFFE TOSTINI\";s:3:\"nbr\";i:18;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Weight\";s:3:\"max\";d:12;s:3:\"min\";d:1;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:18;}}}")	2.261 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)
62	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' GROUP BY p.id_product) p 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	2.255 ms	3888	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)
75	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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_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_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=5)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2)) OR (sa_1.quantity>0)) GROUP BY pac.id_attribute	2.050 ms	5832	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)
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, 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='41' 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 ) WHERE ((sa.quantity>0))	1.962 ms	5832			/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)
76	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) GROUP BY p.condition	1.833 ms	5832	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)
636	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `vtny_category` c INNER JOIN `vtny_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `vtny_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND nleft >= 2 AND nright <= 341 AND c.id_category IN ( SELECT id_category FROM `vtny_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	1.699 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)
78	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) GROUP BY p.id_manufacturer	1.687 ms	5832	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)
70	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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41'	1.645 ms	108			/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)
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, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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_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_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((p.on_sale=1)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2)) OR (sa_1.quantity>0))	1.612 ms	5832			/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)
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, 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='41' 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)))	1.530 ms	5832			/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)
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, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND p.date_add>'2026-03-13 00:00:00'	1.506 ms	5832			/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)
81	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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_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_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((a.id_attribute_group=3)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2)) OR (sa_1.quantity>0)) GROUP BY pac.id_attribute	1.431 ms	5832	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)
94	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.356 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)
69	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41' 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 18:54:00' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-04-01 18:54:00' <= sp.to) ) 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_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_stock_available sa_1_1 ON (p.id_product = sa_1_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1_1.id_product_attribute AND sa_1_1.id_shop = 1 AND sa_1_1.id_shop_group = 0 ) WHERE ((sp.reduction>0)) AND ((sa_1.quantity<=0 AND sa_1_1.out_of_stock IN (0, 2)) OR (sa_1.quantity>0))	1.270 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)
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, 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='41' 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 ) WHERE ((sa.out_of_stock=1) OR (sa.quantity>0))	1.099 ms	5832			/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)
79	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) 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 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock IN (0, 2)) OR (sa.quantity>0)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer='41'	1.019 ms	108			/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)
74	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `vtny_attribute_group` ag INNER JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `vtny_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN vtny_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `vtny_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC	1.011 ms	64	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)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `vtny_module` m INNER JOIN vtny_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `vtny_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `vtny_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `vtny_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	0.987 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)
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.983 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)
77	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `vtny_manufacturer` m INNER JOIN vtny_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `vtny_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.910 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)
920	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `vtny_category` c LEFT JOIN `vtny_category_lang` cl ON c.`id_category` = cl.`id_category` WHERE c.`id_category` IN (SELECT DISTINCT `id_category` FROM `vtny_category_product` WHERE 1) AND c.`active` = 1 AND cl.`id_lang` = 1	0.908 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)
95	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `vtny_hook_module` hm STRAIGHT_JOIN `vtny_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `vtny_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.845 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)
885	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1056 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.825 ms	3	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
72	SELECT SQL_NO_CACHE c.`id_category`, cl.`name` FROM `vtny_category` c INNER JOIN vtny_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `vtny_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.nleft, c.position	0.799 ms	171	Yes		/classes/Category.php:724 /modules/ps_facetedsearch/src/Filters/Block.php:986 (getAllCategoriesName) /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)
688	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1052 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.790 ms	1	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
278	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` = 1) 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` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 1056 AND pac.`id_product_attribute` = 1951 AND agl.`id_lang` = 1	0.761 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)
83	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-04-01 00:00:00', INTERVAL 20 DAY ) ) > 0) as new FROM vtny_product p LEFT JOIN vtny_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN vtny_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN vtny_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1054,1052,1015,1385,1016,1012,1386,1013,1055,1053,1266,1056)	0.751 ms	12			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
60	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `vtny_attribute_group` ag INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `vtny_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.726 ms	2	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:137 /modules/ps_facetedsearch/src/Filters/Converter.php:413 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
80	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `vtny_attribute_group` ag INNER JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `vtny_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN vtny_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN vtny_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `vtny_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 3 ORDER BY agl.`name` ASC, a.`position` ASC	0.716 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)
663	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1054 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.710 ms	3	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
754	SELECT SQL_NO_CACHE pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 1016 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.705 ms	5	Yes	Yes	/classes/Product.php:2815 /modules/pla/pla.php:1583 (getAttributeCombinations) /modules/pla/pla.php:1522 (prepareTableOptions) /classes/Hook.php:1077 (hookdisplayProductListReviews) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:300 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/17/6a/f1/176af162766eae48220bc598bd019ed3434dcb07_2.file.product-listgrid.tpl.php:63 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b54982_90823021) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/84/71/35/84713549468e657449c88044b526f6156731ebb5_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c2b3b229_30893948) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:100 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
59	SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM vtny_layered_category WHERE controller = 'manufacturer' AND id_category = 0 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC	0.704 ms	176	Yes	Yes	/modules/ps_facetedsearch/src/Filters/Provider.php:61 /modules/ps_facetedsearch/src/Filters/Converter.php:263 (getFiltersForQuery) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/ManufacturerController.php:99 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
467	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` = 1 AND c.`id_parent` = 119 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.684 ms	1	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php: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)
214	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` = 1901 AND cp.`id_cart` = 0 AND cp.`id_product` = 1013 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` = 1901 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1013 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.662 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)
473	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` = 1 AND c.`id_parent` = 170 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.658 ms	1	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php: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)
433	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` = 1 AND c.`id_parent` = 37 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.647 ms	2	Yes	Yes	/classes/Category.php:1151 /modules/cp_blocksearch/cp_blocksearch.php:172 (getChildren) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:185 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:147 (getCategoryOption) /modules/cp_blocksearch/cp_blocksearch.php:160 (getWidgetVariables) /classes/Hook.php:1088 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1019 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:137 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/b0/ac/ca/b0accad9b5d7dd32d9b05135782c9520e2a2313c_2.file.header.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4239401d8_62880707) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:206 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/99/e7/47/99e747e5ae0622f7ca76c5e28857289de22b902b_2.file.layout-both-columns.tpl.php:58 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c3a4238d71b9_04269055) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/a8/92/c2/a892c2754e54e00e17adf57b1ba107be39cb9ebd_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69c488c28fade9_50253098) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS02047layouts_layout_both_columns_tpl/66/a0/34/66a03425a59a661b08198bd0d1ed746be807f48b_2.file.manufacturer.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69cd02bc781396_33061204) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
23	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `vtny_meta` m LEFT JOIN `vtny_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	0.638 ms	96	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
519	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` = 1 AND c.`id_parent` = 18 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	0.636 ms	20	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)

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
40 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
28 queries	SELECT `id_image` FROM `vtny_image` WHERE `id_product` = XX AND `cover` = XX ORDER BY position ASC LIMIT XX, XX
24 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `vtny_image` i INNER JOIN vtny_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `vtny_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
24 queries	SELECT `id_product_attribute` FROM `vtny_product_attribute` WHERE `id_product` = XX
21 queries	SELECT `id_module` FROM `vtny_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
19 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
18 queries	SELECT * FROM `vtny_product` a LEFT JOIN `vtny_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `vtny_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
13 queries	SELECT XX FROM `vtny_specific_price` WHERE id_product = XX LIMIT XX
12 queries	SELECT image_shop.`id_image` FROM `vtny_image` i INNER JOIN vtny_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
12 queries	SELECT name FROM vtny_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
12 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `vtny_product` p INNER JOIN `vtny_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `vtny_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
12 queries	SELECT `id_tax_rules_group` FROM `vtny_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12 queries	SELECT `reduction` FROM `vtny_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
12 queries	SELECT COUNT(*) FROM `vtny_pack` WHERE id_product_pack = XX LIMIT XX
12 queries	SELECT product_type FROM `vtny_product` WHERE id_product = XX LIMIT XX
12 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM vtny_feature_product pf LEFT JOIN vtny_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN vtny_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN vtny_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN vtny_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) JOIN `vtny_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `vtny_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `vtny_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
12 queries	SELECT COUNT(p.id_product) FROM `vtny_product` p INNER JOIN vtny_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE p.id_product = XX AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
12 queries	SELECT product_attribute_shop.id_product_attribute FROM vtny_product_attribute pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
12 queries	SELECT t.`id_lang`, t.`name` FROM vtny_tag t LEFT JOIN vtny_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX
12 queries	SELECT out_of_stock FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT depends_on_stock FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT location FROM `vtny_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
12 queries	SELECT pa., product_attribute_shop., ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location FROM `vtny_product_attribute` pa INNER JOIN vtny_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `vtny_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `vtny_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `vtny_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `vtny_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `vtny_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `vtny_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, XX)) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
12 queries	SELECT * 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
12 queries	SELECT * FROM `vtny_attribute_lang` WHERE `id_attribute` = XX
7 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
7 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
7 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
7 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
7 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
7 queries	SELECT * FROM `vtny_product_attribute_lang` WHERE `id_product_attribute` = XX
7 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
7 queries	SELECT * FROM `vtny_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
7 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`
7 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
7 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
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`

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]
Product	61	/classes/Link.php:113 (__construct) [id: 1054] /classes/Link.php:113 (__construct) [id: 1055] /classes/Link.php:113 (__construct) [id: 1053] /classes/Link.php:113 (__construct) [id: 1056] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1054] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1052] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1015] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1385] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1016] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1012] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1386] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1013] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1055] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1053] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1266] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1056] /classes/Link.php:113 (__construct) [id: 1054] /classes/Link.php:113 (__construct) [id: 1015] /classes/Link.php:113 (__construct) [id: 1016] /classes/Link.php:113 (__construct) [id: 1012] /classes/Link.php:113 (__construct) [id: 1013] /classes/Link.php:113 (__construct) [id: 1055] /classes/Link.php:113 (__construct) [id: 1053] /classes/Link.php:113 (__construct) [id: 1056] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1054] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1054] /modules/pla/pla.php:1578 (__construct) [id: 1054] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1052] /modules/pla/pla.php:1578 (__construct) [id: 1052] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1015] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1015] /modules/pla/pla.php:1578 (__construct) [id: 1015] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1385] /modules/pla/pla.php:1578 (__construct) [id: 1385] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1016] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1016] /modules/pla/pla.php:1578 (__construct) [id: 1016] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1012] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1012] /modules/pla/pla.php:1578 (__construct) [id: 1012] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1386] /modules/pla/pla.php:1578 (__construct) [id: 1386] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1013] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1013] /modules/pla/pla.php:1578 (__construct) [id: 1013] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1055] /modules/pla/pla.php:1578 (__construct) [id: 1055] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1053] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1053] /modules/pla/pla.php:1578 (__construct) [id: 1053] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1266] /modules/pla/pla.php:1578 (__construct) [id: 1266] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 1056] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1056] /modules/pla/pla.php:1578 (__construct) [id: 1056] /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]
AttributeGroupCore	56	/modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5] /modules/pla/pla.php:1597 (__construct) [id: 5] /modules/pla/pla.php:1637 (__construct) [id: 5]
ProductAttribute	28	/modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 58] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 33] /modules/pla/pla.php:1639 (__construct) [id: 34] /modules/pla/pla.php:1639 (__construct) [id: 35] /modules/pla/pla.php:1639 (__construct) [id: 36] /modules/pla/pla.php:1639 (__construct) [id: 38] /modules/pla/pla.php:1639 (__construct) [id: 33] /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] /modules/pla/pla.php:1639 (__construct) [id: 32] /modules/pla/pla.php:1639 (__construct) [id: 57] /modules/pla/pla.php:1639 (__construct) [id: 59] /modules/pla/pla.php:1639 (__construct) [id: 58]
Manufacturer	20	/controllers/front/listing/ManufacturerController.php:65 (__construct) [id: 41] /classes/Meta.php:421 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41] /classes/Link.php:657 (__construct) [id: 41]
Address	16	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5960 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ] /classes/Product.php:741 (__construct) [id: ]
AttributeGroup	7	/modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5] /modules/pla/pla.php:1589 (__construct) [id: 5]
Combination	7	/classes/Product.php:5908 (__construct) [id: 1945] /classes/Product.php:5908 (__construct) [id: 1910] /classes/Product.php:5908 (__construct) [id: 1915] /classes/Product.php:5908 (__construct) [id: 1897] /classes/Product.php:5908 (__construct) [id: 1901] /classes/Product.php:5908 (__construct) [id: 1942] /classes/Product.php:5908 (__construct) [id: 1951]
CMS	6	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 1] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 2] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 3] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 4] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 5]
Country	5	/config/config.inc.php:146 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /classes/controller/FrontController.php:1767 (__construct) [id: 10] /classes/AddressFormat.php:404 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 10]
State	4	/classes/AddressFormat.php:404 (__construct) [id: 0] /classes/controller/FrontController.php:1766 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /classes/AddressFormat.php:404 (__construct) [id: 0]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 2] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1]
Language	3	/config/config.inc.php:211 (__construct) [id: 2] /classes/Tools.php:641 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
AddressFormat	2	/classes/controller/FrontController.php:1761 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45]
PrestaShop\Module\LinkList\Model\LinkBlock	2	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 1] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

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

shop by category

Home  

Left Banner  

List of products by brand CAFFE TOSTINI

Stopwatch SQL - 951 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Home

Left Banner