Product catalog featuring t-shirts, custom apparel, and accessories. Curated t-shirt selection by Kobronaif

By continuing use this site, you agree to the Terms & Conditions and our use of cookies.

Explore our full catalog of t-shirts, hoodies, and unique accessories. From streetwear essentials to original graphics, every item is designed to express your style. Quality, creativity, and bold design for an authentic look. Shop now and refresh your wardrobe with standout pieces.

Subcategory

View Left Column

1124 products

Grid

Grid-2

List

List-2

Catelog

Sort by:

T-shirt Rollins band the end of silence

€13.00

T-shirt Rollins band the end of silence

€13.00

T-shirt Rollins band the end of silence

Rollins band

T-shirt Rollins band the end of silence, rock alternative metal premium cotton shirt, perfect for casual wear and fans of music, movies, and pop culture. Unique comfort and style in a durable, high-quality garment

€13.00

T-shirt Rollins band the end of silence

Rollins band

€13.00

T-shirt REO speedwagon hi infidelity

€13.00

T-shirt REO speedwagon hi infidelity

€13.00

T-shirt REO speedwagon hi infidelity

REO

T-shirt REO speedwagon hi infidelity, rock premium cotton shirt, perfect for casual wear and fans of music, movies, and pop culture. Unique comfort and style in a durable, high-quality garment

€13.00

T-shirt REO speedwagon hi infidelity

REO

T-shirt REO speedwagon hi infidelity, rock premium cotton shirt, perfect for casual wear and fans of music, movies, and pop culture. Unique comfort and style in a durable, high-quality garment

€13.00

T-shirt Ramones 4 faces

€13.00

T-shirt Ramones 4 faces

€13.00

T-shirt Ramones 4 faces

Ramones

T-shirt Ramones 4 faces, punk premium cotton shirt, perfect for casual wear and fans of music, movies, and pop culture. Unique comfort and style in a durable, high-quality garment

€13.00

T-shirt Ramones 4 faces

Ramones

T-shirt Ramones 4 faces, punk premium cotton shirt, perfect for casual wear and fans of music, movies, and pop culture. Unique comfort and style in a durable, high-quality garment

€13.00

T-shirt Rage Against The Machine

€13.00

T-shirt Rage Against The Machine

€13.00

T-shirt Rage Against The Machine

Rage Against The Machine RATM

T-shirt Rage Against The Machine, metal crossover alternative premium cotton shirt, perfect for casual wear and fans of music, movies, and pop culture. Unique comfort and style in a durable, high-quality garment

€13.00

T-shirt Rage Against The Machine

Rage Against The Machine RATM

€13.00

Load Time	892 ms
Querying Time	483 ms
Queries	863
Memory Peak Usage	34.6 Mb
Included Files	1513 files - 14.60 Mb
PrestaShop Cache	- Mb
Global vars	0.19 Mb
- global $_MODULES	165k
- global $_SERVER	7k
- global $config	5k
- global $smarty	4k
- global $_MODULE	4k
- global $context	3k
- global $__composer_autoload_files	3k
- global $exportPhpConfigFile	3k

PrestaShop Version	9.0.0
PHP Version	8.1.33
MySQL Version	10.5.26-MariaDB
Memory Limit	512M
Max Execution Time	1000s
Smarty Cache	disabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	269.352 ms	269.352 ms	7.06 Mb	7.6 Mb
__construct	0.013 ms	269.365 ms	- Mb	7.6 Mb
init	9.036 ms	278.401 ms	0.58 Mb	7.9 Mb
checkAccess	0.001 ms	278.402 ms	- Mb	7.9 Mb
setMedia	7.173 ms	285.575 ms	0.27 Mb	8.1 Mb
postProcess	0.001 ms	285.576 ms	- Mb	8.1 Mb
initHeader	0.000 ms	285.576 ms	- Mb	8.1 Mb
initContent	351.004 ms	636.580 ms	4.64 Mb	12.6 Mb
initFooter	0.002 ms	636.582 ms	- Mb	12.6 Mb
display	255.493 ms	892 ms	21.39 Mb	34.6 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	86.609 ms	4.35 Mb
=> tvcmsnewproducts	15.791 ms	0.62 Mb
=> tvcmscustomerservices	0.318 ms	0.02 Mb
=> tvcmsspecialproducts	1.467 ms	0.08 Mb
=> tvcmsfeaturedproducts	42.837 ms	1.83 Mb
=> tvcmstestimonial	0.733 ms	0.03 Mb
=> tvcmsbestsellerproducts	25.463 ms	1.78 Mb
DisplayAfterBodyOpeningTag	45.872 ms	4.36 Mb
=> tvcmscookiesnotice	0.198 ms	0.01 Mb
=> tvcmsproductpopup	45.674 ms	4.35 Mb
DisplayReviewProductList	29.904 ms	4.22 Mb
=> tvcmsproductcomments	0.776 ms	0.09 Mb
=> tvcmsproductcomments	0.633 ms	0.08 Mb
=> tvcmsproductcomments	0.800 ms	0.08 Mb
=> tvcmsproductcomments	0.657 ms	0.08 Mb
=> tvcmsproductcomments	0.611 ms	0.08 Mb
=> tvcmsproductcomments	0.689 ms	0.11 Mb
=> tvcmsproductcomments	0.543 ms	0.07 Mb
=> tvcmsproductcomments	0.488 ms	0.07 Mb
=> tvcmsproductcomments	0.465 ms	0.07 Mb
=> tvcmsproductcomments	0.679 ms	0.11 Mb
=> tvcmsproductcomments	0.521 ms	0.07 Mb
=> tvcmsproductcomments	0.445 ms	0.07 Mb
=> tvcmsproductcomments	0.465 ms	0.07 Mb
=> tvcmsproductcomments	0.665 ms	0.11 Mb
=> tvcmsproductcomments	0.473 ms	0.07 Mb
=> tvcmsproductcomments	0.491 ms	0.07 Mb
=> tvcmsproductcomments	0.448 ms	0.07 Mb
=> tvcmsproductcomments	0.640 ms	0.11 Mb
=> tvcmsproductcomments	0.473 ms	0.07 Mb
=> tvcmsproductcomments	0.470 ms	0.07 Mb
=> tvcmsproductcomments	0.459 ms	0.07 Mb
=> tvcmsproductcomments	0.733 ms	0.11 Mb
=> tvcmsproductcomments	0.518 ms	0.07 Mb
=> tvcmsproductcomments	0.481 ms	0.07 Mb
=> tvcmsproductcomments	0.448 ms	0.07 Mb
=> tvcmsproductcomments	0.656 ms	0.11 Mb
=> tvcmsproductcomments	0.500 ms	0.07 Mb
=> tvcmsproductcomments	0.472 ms	0.07 Mb
=> tvcmsproductcomments	0.441 ms	0.07 Mb
=> tvcmsproductcomments	0.662 ms	0.11 Mb
=> tvcmsproductcomments	0.498 ms	0.07 Mb
=> tvcmsproductcomments	0.455 ms	0.07 Mb
=> tvcmsproductcomments	0.425 ms	0.07 Mb
=> tvcmsproductcomments	0.776 ms	0.11 Mb
=> tvcmsproductcomments	0.516 ms	0.07 Mb
=> tvcmsproductcomments	0.475 ms	0.07 Mb
=> tvcmsproductcomments	0.465 ms	0.07 Mb
=> tvcmsproductcomments	0.659 ms	0.11 Mb
=> tvcmsproductcomments	0.522 ms	0.07 Mb
=> tvcmsproductcomments	0.452 ms	0.07 Mb
=> tvcmsproductcomments	0.447 ms	0.07 Mb
=> tvcmsproductcomments	0.612 ms	0.11 Mb
=> tvcmsproductcomments	0.955 ms	0.07 Mb
=> tvcmsproductcomments	0.544 ms	0.07 Mb
=> tvcmsproductcomments	0.505 ms	0.07 Mb
=> tvcmsproductcomments	0.740 ms	0.11 Mb
=> tvcmsproductcomments	0.562 ms	0.07 Mb
=> tvcmsproductcomments	0.498 ms	0.07 Mb
=> tvcmsproductcomments	0.478 ms	0.07 Mb
=> tvcmsproductcomments	0.806 ms	0.11 Mb
=> tvcmsproductcomments	0.631 ms	0.07 Mb
=> tvcmsproductcomments	0.561 ms	0.07 Mb
=> tvcmsproductcomments	0.520 ms	0.07 Mb
FilterProductSearch	16.141 ms	0.44 Mb
=> trustpilot	16.141 ms	0.44 Mb
displayLeftColumn	14.828 ms	1.03 Mb
=> ps_categorytree (widget)	12.256 ms	0.90 Mb
=> ps_brandlist (widget)	2.572 ms	0.13 Mb
DisplayHeader	6.182 ms	0.26 Mb
=> ps_shoppingcart	0.032 ms	- Mb
=> ps_searchbar	0.263 ms	0.01 Mb
=> ps_googleanalytics	0.329 ms	0.08 Mb
=> ps_facebook	1.484 ms	0.06 Mb
=> psxmarketingwithgoogle	0.329 ms	0.01 Mb
=> tvcmsbestsellerproducts	0.050 ms	- Mb
=> tvcmsblog	0.117 ms	- Mb
=> tvcmsblogdisplayposts	0.057 ms	- Mb
=> tvcmsbrandlist	0.046 ms	- Mb
=> tvcmscategorychainslider	0.046 ms	- Mb
=> tvcmscategoryslider	0.042 ms	- Mb
=> tvcmscookiesnotice	0.069 ms	- Mb
=> tvcmscustomerservices	0.049 ms	- Mb
=> tvcmscustomsetting	0.298 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.040 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsinfinitescroll	1.130 ms	0.04 Mb
=> tvcmsmegamenu	0.072 ms	- Mb
=> tvcmsmultibanner1	0.047 ms	- Mb
=> tvcmsnewproducts	0.037 ms	- Mb
=> tvcmsnewsletterpopup	0.095 ms	- Mb
=> tvcmspaymenticon	0.002 ms	- Mb
=> tvcmsproductcomments	0.394 ms	- Mb
=> tvcmsproductpopup	0.042 ms	- Mb
=> tvcmssearch	0.399 ms	- Mb
=> tvcmssingleblock	0.041 ms	- Mb
=> tvcmssizechart	0.039 ms	- Mb
=> tvcmsslider	0.041 ms	- Mb
=> tvcmsspecialproducts	0.034 ms	- Mb
=> tvcmsstockinfo	0.046 ms	- Mb
=> tvcmsstoretime	0.038 ms	- Mb
=> tvcmstabproducts	0.065 ms	- Mb
=> tvcmstestimonial	0.040 ms	- Mb
=> tvcmsthemeoptions	0.114 ms	- Mb
=> trustpilot	0.174 ms	0.01 Mb
=> tvcmscategoryproduct	0.079 ms	- Mb
displayFooterPart1	5.279 ms	0.81 Mb
=> ps_linklist (widget)	5.279 ms	0.81 Mb
ActionFrontControllerSetMedia	4.668 ms	0.13 Mb
=> blockreassurance	0.100 ms	- Mb
=> ps_emailsubscription	0.053 ms	- Mb
=> ps_socialfollow	0.032 ms	- Mb
=> ps_emailalerts	0.020 ms	- Mb
=> ps_facebook	0.051 ms	- Mb
=> ps_checkout	4.381 ms	0.12 Mb
=> inpost	0.031 ms	- Mb
DisplayNavSearchBlock	4.268 ms	0.88 Mb
=> tvcmssearch	4.268 ms	0.88 Mb
DisplayBeforeBodyClosingTag	3.888 ms	0.15 Mb
=> statsdata	3.674 ms	0.15 Mb
=> tvcmsblog	0.004 ms	- Mb
=> trustpilot	0.210 ms	- Mb
DisplayFooterCategory	3.314 ms	0.33 Mb
=> tvcmsfootercategory	3.314 ms	0.33 Mb
DisplayMegamenu	3.177 ms	0.44 Mb
=> tvcmsmegamenu	3.177 ms	0.44 Mb
displayMyaccountcblock	0.960 ms	0.07 Mb
=> ps_customeraccountlinks (widget)	0.960 ms	0.07 Mb
displaySocialMediaBlock	0.935 ms	0.08 Mb
=> ps_socialfollow (widget)	0.572 ms	0.08 Mb
=> ps_socialfollow (widget)	0.363 ms	- Mb
displayFooterBefore	0.845 ms	0.06 Mb
=> ps_emailsubscription (widget)	0.845 ms	0.06 Mb
displayNavShoppingCartBlock	0.802 ms	0.10 Mb
=> ps_shoppingcart (widget)	0.802 ms	0.10 Mb
displayContactCinfo	0.786 ms	0.08 Mb
=> ps_contactinfo (widget)	0.786 ms	0.08 Mb
DisplayCustomsocialblock	0.779 ms	0.11 Mb
=> tvcmscustomsetting	0.779 ms	0.11 Mb
displayNavLanguageBlock	0.720 ms	0.06 Mb
=> ps_languageselector (widget)	0.720 ms	0.06 Mb
displayNavCustomerSignInBlock	0.466 ms	0.06 Mb
=> ps_customersignin (widget)	0.466 ms	0.06 Mb
displayFooter	0.455 ms	- Mb
=> ps_linklist (widget)	0.455 ms	- Mb
ProductSearchProvider	0.335 ms	- Mb
=> ps_facetedsearch	0.335 ms	- Mb
DisplayPaymentIcon	0.306 ms	0.03 Mb
=> tvcmspaymenticon	0.306 ms	0.03 Mb
displayNavCurrencyBlock	0.285 ms	0.06 Mb
=> ps_currencyselector (widget)	0.285 ms	0.06 Mb
DisplayFacetedSearch	0.235 ms	0.01 Mb
=> ps_facetedsearch	0.235 ms	0.01 Mb
DisplayFooterStoreTime	0.191 ms	0.02 Mb
=> tvcmsstoretime	0.191 ms	0.02 Mb
DisplayFooterPart2	0.190 ms	0.01 Mb
=> tvcmsfooterlogo	0.190 ms	0.01 Mb
DisplayMyAccountBlock	0.185 ms	0.01 Mb
=> ps_emailalerts	0.185 ms	0.01 Mb
DisplayCopyRightText	0.148 ms	0.01 Mb
=> tvcmscustomsetting	0.148 ms	0.01 Mb
DisplayProductListStockIndicator	0.075 ms	0.01 Mb
=> tvcmsstockinfo	0.006 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.005 ms	- Mb
=> tvcmsstockinfo	0.002 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.003 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
=> tvcmsstockinfo	0.004 ms	- Mb
DisplayTopOfferText	0.023 ms	- Mb
=> tvcmscustomsetting	0.017 ms	- Mb
=> tvcmscustomsetting	0.006 ms	- Mb
ModuleRoutes	0.022 ms	0.01 Mb
=> tvcmsblog	0.020 ms	0.01 Mb
=> ps_checkout	0.002 ms	- Mb
DisplayCustomCss	0.010 ms	- Mb
=> tvcmscustomcssjs	0.010 ms	- Mb
DisplayCustomJs	0.007 ms	- Mb
=> tvcmscustomcssjs	0.007 ms	- Mb
34 hook(s)	232.889 ms	18.17 Mb

Module	Time	Memory Usage
tvcmsblog	1.719 ms	0.10 Mb
__construct	1.571 ms	0.09 Mb
hookModuleRoutes	0.024 ms	0.01 Mb
hookDisplayHeader	0.119 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.005 ms	- Mb
ps_checkout	5.063 ms	0.17 Mb
__construct	0.676 ms	0.05 Mb
hookModuleRoutes	0.003 ms	- Mb
hookActionFrontControllerSetMedia	4.384 ms	0.12 Mb
blockreassurance	0.822 ms	0.08 Mb
__construct	0.720 ms	0.07 Mb
hookActionFrontControllerSetMedia	0.102 ms	- Mb
ps_emailsubscription	0.997 ms	0.07 Mb
__construct	0.095 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.054 ms	- Mb
displayFooterBefore	0.848 ms	0.06 Mb
ps_socialfollow	1.073 ms	0.09 Mb
__construct	0.099 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.033 ms	- Mb
displaySocialMediaBlock	0.575 ms	0.08 Mb
displaySocialMediaBlock	0.366 ms	- Mb
ps_emailalerts	0.319 ms	0.01 Mb
__construct	0.110 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.021 ms	- Mb
hookDisplayMyAccountBlock	0.188 ms	0.01 Mb
ps_facebook	2.114 ms	0.08 Mb
__construct	0.575 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.053 ms	- Mb
hookDisplayHeader	1.486 ms	0.06 Mb
ps_accounts	0.210 ms	0.01 Mb
__construct	0.210 ms	0.01 Mb
inpost	0.122 ms	0.01 Mb
__construct	0.090 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.032 ms	- Mb
ps_shoppingcart	0.922 ms	0.11 Mb
__construct	0.083 ms	0.01 Mb
hookDisplayHeader	0.034 ms	- Mb
displayNavShoppingCartBlock	0.805 ms	0.10 Mb
ps_searchbar	0.363 ms	0.01 Mb
__construct	0.098 ms	0.01 Mb
hookDisplayHeader	0.265 ms	0.01 Mb
ps_googleanalytics	0.416 ms	0.08 Mb
__construct	0.084 ms	0.01 Mb
hookDisplayHeader	0.332 ms	0.08 Mb
psxmarketingwithgoogle	0.448 ms	0.01 Mb
__construct	0.117 ms	0.01 Mb
hookDisplayHeader	0.331 ms	0.01 Mb
tvcmsbestsellerproducts	25.660 ms	1.78 Mb
__construct	0.141 ms	0.01 Mb
hookDisplayHeader	0.051 ms	- Mb
hookDisplayLeftColumn	25.468 ms	1.78 Mb
tvcmsblogdisplayposts	0.165 ms	0.01 Mb
__construct	0.107 ms	0.01 Mb
hookDisplayHeader	0.058 ms	- Mb
tvcmsbrandlist	0.155 ms	0.01 Mb
__construct	0.108 ms	0.01 Mb
hookDisplayHeader	0.047 ms	- Mb
tvcmscategorychainslider	0.158 ms	0.01 Mb
__construct	0.111 ms	0.01 Mb
hookDisplayHeader	0.047 ms	- Mb
tvcmscategoryslider	0.146 ms	0.01 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.043 ms	- Mb
tvcmscookiesnotice	0.396 ms	0.02 Mb
__construct	0.126 ms	0.01 Mb
hookDisplayHeader	0.070 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.200 ms	0.01 Mb
tvcmscustomerservices	0.496 ms	0.03 Mb
__construct	0.124 ms	0.01 Mb
hookDisplayHeader	0.050 ms	- Mb
hookDisplayLeftColumn	0.322 ms	0.02 Mb
tvcmscustomsetting	1.393 ms	0.14 Mb
__construct	0.133 ms	0.01 Mb
hookDisplayHeader	0.299 ms	0.01 Mb
hookDisplayTopOfferText	0.019 ms	- Mb
hookDisplayTopOfferText	0.010 ms	- Mb
hookDisplayCustomsocialblock	0.781 ms	0.11 Mb
hookDisplayCopyRightText	0.151 ms	0.02 Mb
tvcmsfeaturedproducts	42.996 ms	1.84 Mb
__construct	0.114 ms	0.01 Mb
hookDisplayHeader	0.041 ms	- Mb
hookDisplayLeftColumn	42.841 ms	1.83 Mb
tvcmsfooterlogo	0.297 ms	0.02 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayFooterPart2	0.192 ms	0.01 Mb
tvcmsinfinitescroll	1.223 ms	0.05 Mb
__construct	0.090 ms	- Mb
hookDisplayHeader	1.133 ms	0.04 Mb
tvcmsmegamenu	3.402 ms	0.44 Mb
__construct	0.149 ms	0.01 Mb
hookDisplayHeader	0.073 ms	- Mb
hookDisplayMegamenu	3.180 ms	0.44 Mb
tvcmsmultibanner1	0.161 ms	0.01 Mb
__construct	0.113 ms	0.01 Mb
hookDisplayHeader	0.048 ms	- Mb
tvcmsnewproducts	15.934 ms	0.62 Mb
__construct	0.100 ms	0.01 Mb
hookDisplayHeader	0.038 ms	- Mb
hookDisplayLeftColumn	15.796 ms	0.62 Mb
tvcmsnewsletterpopup	0.199 ms	0.01 Mb
__construct	0.103 ms	0.01 Mb
hookDisplayHeader	0.096 ms	- Mb
tvcmspaymenticon	0.625 ms	0.04 Mb
__construct	0.314 ms	0.01 Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayPaymentIcon	0.308 ms	0.03 Mb
tvcmsproductcomments	30.554 ms	4.25 Mb
__construct	0.134 ms	0.01 Mb
hookDisplayHeader	0.396 ms	- Mb
hookDisplayReviewProductList	0.780 ms	0.09 Mb
hookDisplayReviewProductList	0.653 ms	0.08 Mb
hookDisplayReviewProductList	0.804 ms	0.08 Mb
hookDisplayReviewProductList	0.660 ms	0.08 Mb
hookDisplayReviewProductList	0.614 ms	0.08 Mb
hookDisplayReviewProductList	0.692 ms	0.11 Mb
hookDisplayReviewProductList	0.545 ms	0.07 Mb
hookDisplayReviewProductList	0.491 ms	0.07 Mb
hookDisplayReviewProductList	0.467 ms	0.07 Mb
hookDisplayReviewProductList	0.680 ms	0.11 Mb
hookDisplayReviewProductList	0.523 ms	0.07 Mb
hookDisplayReviewProductList	0.447 ms	0.07 Mb
hookDisplayReviewProductList	0.467 ms	0.07 Mb
hookDisplayReviewProductList	0.667 ms	0.11 Mb
hookDisplayReviewProductList	0.474 ms	0.07 Mb
hookDisplayReviewProductList	0.493 ms	0.07 Mb
hookDisplayReviewProductList	0.449 ms	0.07 Mb
hookDisplayReviewProductList	0.642 ms	0.11 Mb
hookDisplayReviewProductList	0.474 ms	0.07 Mb
hookDisplayReviewProductList	0.471 ms	0.07 Mb
hookDisplayReviewProductList	0.460 ms	0.07 Mb
hookDisplayReviewProductList	0.735 ms	0.11 Mb
hookDisplayReviewProductList	0.520 ms	0.07 Mb
hookDisplayReviewProductList	0.483 ms	0.07 Mb
hookDisplayReviewProductList	0.450 ms	0.07 Mb
hookDisplayReviewProductList	0.657 ms	0.11 Mb
hookDisplayReviewProductList	0.502 ms	0.07 Mb
hookDisplayReviewProductList	0.473 ms	0.07 Mb
hookDisplayReviewProductList	0.442 ms	0.07 Mb
hookDisplayReviewProductList	0.663 ms	0.11 Mb
hookDisplayReviewProductList	0.499 ms	0.07 Mb
hookDisplayReviewProductList	0.457 ms	0.07 Mb
hookDisplayReviewProductList	0.426 ms	0.07 Mb
hookDisplayReviewProductList	0.778 ms	0.11 Mb
hookDisplayReviewProductList	0.518 ms	0.07 Mb
hookDisplayReviewProductList	0.476 ms	0.07 Mb
hookDisplayReviewProductList	0.466 ms	0.07 Mb
hookDisplayReviewProductList	0.661 ms	0.11 Mb
hookDisplayReviewProductList	0.523 ms	0.07 Mb
hookDisplayReviewProductList	0.453 ms	0.07 Mb
hookDisplayReviewProductList	0.449 ms	0.07 Mb
hookDisplayReviewProductList	0.613 ms	0.11 Mb
hookDisplayReviewProductList	0.959 ms	0.07 Mb
hookDisplayReviewProductList	0.547 ms	0.07 Mb
hookDisplayReviewProductList	0.507 ms	0.07 Mb
hookDisplayReviewProductList	0.742 ms	0.11 Mb
hookDisplayReviewProductList	0.565 ms	0.07 Mb
hookDisplayReviewProductList	0.500 ms	0.07 Mb
hookDisplayReviewProductList	0.479 ms	0.07 Mb
hookDisplayReviewProductList	0.809 ms	0.11 Mb
hookDisplayReviewProductList	0.633 ms	0.07 Mb
hookDisplayReviewProductList	0.564 ms	0.07 Mb
hookDisplayReviewProductList	0.523 ms	0.07 Mb
tvcmsproductpopup	45.787 ms	4.36 Mb
__construct	0.067 ms	0.01 Mb
hookDisplayHeader	0.044 ms	- Mb
hookDisplayAfterBodyOpeningTag	45.676 ms	4.35 Mb
tvcmssearch	4.738 ms	0.89 Mb
__construct	0.066 ms	0.01 Mb
hookDisplayHeader	0.401 ms	- Mb
hookDisplayNavSearchBlock	4.271 ms	0.88 Mb
tvcmssingleblock	0.151 ms	0.01 Mb
__construct	0.109 ms	0.01 Mb
hookDisplayHeader	0.042 ms	- Mb
tvcmssizechart	0.126 ms	0.01 Mb
__construct	0.086 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
tvcmsslider	0.155 ms	0.01 Mb
__construct	0.113 ms	0.01 Mb
hookDisplayHeader	0.042 ms	- Mb
tvcmsspecialproducts	1.591 ms	0.08 Mb
__construct	0.086 ms	0.01 Mb
hookDisplayHeader	0.035 ms	- Mb
hookDisplayLeftColumn	1.470 ms	0.08 Mb
tvcmsstockinfo	0.266 ms	0.03 Mb
__construct	0.109 ms	0.01 Mb
hookDisplayHeader	0.048 ms	- Mb
hookDisplayProductListStockIndicator	0.008 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.003 ms	- Mb
hookDisplayProductListStockIndicator	0.008 ms	- Mb
hookDisplayProductListStockIndicator	0.004 ms	- Mb
hookDisplayProductListStockIndicator	0.006 ms	- Mb
hookDisplayProductListStockIndicator	0.005 ms	- Mb
hookDisplayProductListStockIndicator	0.006 ms	- Mb
hookDisplayProductListStockIndicator	0.006 ms	- Mb
tvcmsstoretime	0.311 ms	0.03 Mb
__construct	0.079 ms	0.01 Mb
hookDisplayHeader	0.039 ms	- Mb
hookDisplayFooterStoreTime	0.193 ms	0.02 Mb
tvcmstabproducts	0.123 ms	0.01 Mb
__construct	0.057 ms	0.01 Mb
hookDisplayHeader	0.066 ms	- Mb
tvcmstestimonial	0.868 ms	0.04 Mb
__construct	0.091 ms	0.01 Mb
hookDisplayHeader	0.041 ms	- Mb
hookDisplayLeftColumn	0.736 ms	0.03 Mb
tvcmsthemeoptions	0.183 ms	0.07 Mb
__construct	0.067 ms	0.07 Mb
hookDisplayHeader	0.116 ms	- Mb
trustpilot	16.703 ms	0.47 Mb
__construct	0.170 ms	0.01 Mb
hookDisplayHeader	0.176 ms	0.01 Mb
hookFilterProductSearch	16.145 ms	0.45 Mb
hookDisplayBeforeBodyClosingTag	0.212 ms	- Mb
tvcmscategoryproduct	0.205 ms	0.01 Mb
__construct	0.124 ms	0.01 Mb
hookDisplayHeader	0.081 ms	- Mb
ps_facetedsearch	0.997 ms	0.03 Mb
__construct	0.421 ms	0.01 Mb
hookProductSearchProvider	0.337 ms	- Mb
hookDisplayFacetedSearch	0.239 ms	0.01 Mb
tvcmscustomcssjs	0.179 ms	0.01 Mb
__construct	0.158 ms	0.01 Mb
hookDisplayCustomCss	0.012 ms	- Mb
hookDisplayCustomJs	0.009 ms	- Mb
ps_languageselector	0.851 ms	0.07 Mb
__construct	0.128 ms	0.01 Mb
displayNavLanguageBlock	0.723 ms	0.06 Mb
ps_currencyselector	0.390 ms	0.06 Mb
__construct	0.103 ms	0.01 Mb
displayNavCurrencyBlock	0.287 ms	0.06 Mb
ps_customersignin	0.557 ms	0.07 Mb
__construct	0.089 ms	0.01 Mb
displayNavCustomerSignInBlock	0.468 ms	0.06 Mb
ps_categorytree	12.417 ms	0.91 Mb
__construct	0.156 ms	0.01 Mb
displayLeftColumn	12.261 ms	0.90 Mb
ps_brandlist	2.678 ms	0.14 Mb
__construct	0.103 ms	0.01 Mb
displayLeftColumn	2.575 ms	0.13 Mb
ps_contactinfo	0.889 ms	0.08 Mb
__construct	0.100 ms	0.01 Mb
displayContactCinfo	0.789 ms	0.08 Mb
tvcmsfootercategory	3.479 ms	0.33 Mb
__construct	0.162 ms	0.01 Mb
hookDisplayFooterCategory	3.317 ms	0.33 Mb
ps_customeraccountlinks	1.042 ms	0.08 Mb
__construct	0.081 ms	0.01 Mb
displayMyaccountcblock	0.961 ms	0.07 Mb
ps_linklist	6.200 ms	0.90 Mb
__construct	0.462 ms	0.09 Mb
displayFooterPart1	5.281 ms	0.82 Mb
displayFooter	0.457 ms	- Mb
statsdata	3.785 ms	0.15 Mb
__construct	0.107 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	3.678 ms	0.15 Mb
55 module(s)	243.218 ms	18.95 Mb

118 queries	SELECT SUM(quantity) FROM `hpajx_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
53 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `hpajx_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX LIMIT XX
53 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `hpajx_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX LIMIT XX
50 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 `hpajx_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 `hpajx_cart_product` cp JOIN `hpajx_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hpajx_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
29 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `hpajx_image` i INNER JOIN hpajx_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `hpajx_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
29 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `hpajx_product_attribute_image` pai LEFT JOIN `hpajx_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `hpajx_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
28 queries	SELECT cl.`link_rewrite` FROM `hpajx_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
25 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 `hpajx_product` p INNER JOIN `hpajx_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `hpajx_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)
25 queries	SELECT `reduction` FROM `hpajx_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
25 queries	SELECT pa.`available_date` FROM `hpajx_product` p LEFT JOIN `hpajx_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN hpajx_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
25 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `hpajx_attribute` a LEFT JOIN `hpajx_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `hpajx_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN hpajx_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 `hpajx_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `hpajx_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
25 queries	SELECT * FROM `hpajx_product_attribute` a LEFT JOIN `hpajx_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
25 queries	SELECT * FROM `hpajx_product_attribute_lang` WHERE `id_product_attribute` = XX
25 queries	SELECT * FROM `hpajx_product` a LEFT JOIN `hpajx_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `hpajx_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
17 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM hpajx_product p LEFT JOIN hpajx_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN hpajx_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN hpajx_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
17 queries	SELECT * FROM `hpajx_product` a LEFT JOIN `hpajx_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
17 queries	SELECT * FROM `hpajx_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
17 queries	SELECT pa., product_attribute_shop. FROM `hpajx_product_attribute` pa INNER JOIN hpajx_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`
17 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `hpajx_product_attribute_combination` pac LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
17 queries	SELECT COUNT(`id_tvcmsproduct_comment`) AS "nbr" FROM `hpajx_tvcmsproduct_comment` pc WHERE `id_product` = XX LIMIT XX
16 queries	SELECT `id_module` FROM `hpajx_module_shop` WHERE `id_module` = XX AND `id_shop` = 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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `hpajx_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 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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `hpajx_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 name FROM hpajx_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
8 queries	SELECT mr.* FROM hpajx_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
7 queries	SELECT * FROM `hpajx_category` a LEFT JOIN `hpajx_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `hpajx_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
7 queries	SELECT * FROM `hpajx_cms` a LEFT JOIN `hpajx_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
7 queries	SELECT * FROM `hpajx_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
6 queries	SELECT * FROM `hpajx_category` a LEFT JOIN `hpajx_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
6 queries	SELECT * FROM `hpajx_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
5 queries	SELECT quantity, reserved_quantity FROM `hpajx_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `hpajx_module` m LEFT JOIN `hpajx_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 queries	SELECT tr.* FROM `hpajx_tax_rule` tr JOIN `hpajx_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT * FROM `hpajx_country` a LEFT JOIN `hpajx_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `hpajx_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM `hpajx_lang` a LEFT JOIN `hpajx_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX
2 queries	SELECT id_shop FROM `hpajx_lang_shop` WHERE `id_lang` = XX AND id_shop = XX LIMIT XX
2 queries	SELECT `id_lang` FROM `hpajx_lang` WHERE `locale` = 'en-us' OR `language_code` = 'en-us' LIMIT XX
2 queries	SELECT `id_category` FROM `hpajx_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM hpajx_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT `id_module` FROM `hpajx_module` WHERE `name` = "ps_accounts" LIMIT XX
2 queries	SELECT `need_identification_number` FROM `hpajx_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT XX FROM `hpajx_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute FROM `hpajx_product` p INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `hpajx_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `hpajx_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `hpajx_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `hpajx_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `hpajx_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX LEFT JOIN hpajx_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE (product_shop.`active` = XX) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) AND (EXISTS(SELECT XX FROM `hpajx_category_product` cp JOIN `hpajx_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT XX
2 queries	SELECT * FROM `hpajx_manufacturer` a LEFT JOIN `hpajx_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = XX LEFT JOIN `hpajx_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = XX WHERE (a.`id_manufacturer` = XX) LIMIT XX
2 queries	SELECT lb.`id_link_block` FROM hpajx_link_block lb INNER JOIN hpajx_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block` WHERE lb. `id_hook` = XX AND lbs.`id_shop` = XX ORDER by lbs.`position`

Name	Instances	Source
Product	75	/src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1022] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1021] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1020] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1019] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1018] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1017] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1016] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1015] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1014] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1013] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1012] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1011] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1022] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1021] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1020] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1019] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1018] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1017] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1016] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1015] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1014] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1013] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1012] /modules/trustpilot/trustbox.php:104 (__construct) [id: 1011] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1242] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1241] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1240] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1239] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1238] /classes/Link.php:112 (__construct) [id: 1242] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1242] /classes/Link.php:112 (__construct) [id: 1241] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1241] /classes/Link.php:112 (__construct) [id: 1240] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1240] /classes/Link.php:112 (__construct) [id: 1239] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1239] /classes/Link.php:112 (__construct) [id: 1238] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1238] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1242] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1241] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1240] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1239] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 966] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 761] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 955] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1157] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 1067] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 992] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 832] /src/Adapter/Image/ImageRetriever.php:72 (__construct) [id: 792] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1022] /classes/Link.php:112 (__construct) [id: 1022] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1021] /classes/Link.php:112 (__construct) [id: 1021] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1020] /classes/Link.php:112 (__construct) [id: 1020] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1019] /classes/Link.php:112 (__construct) [id: 1019] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1018] /classes/Link.php:112 (__construct) [id: 1018] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1017] /classes/Link.php:112 (__construct) [id: 1017] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1016] /classes/Link.php:112 (__construct) [id: 1016] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1015] /classes/Link.php:112 (__construct) [id: 1015] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1014] /classes/Link.php:112 (__construct) [id: 1014] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1013] /classes/Link.php:112 (__construct) [id: 1013] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1012] /classes/Link.php:112 (__construct) [id: 1012] /src/Adapter/Presenter/Product/ProductLazyArray.php:914 (__construct) [id: 1011] /classes/Link.php:112 (__construct) [id: 1011]
Category	28	/controllers/front/listing/CategoryController.php:89 (__construct) [id: 2] /classes/Meta.php:372 (__construct) [id: 2] /classes/Link.php:397 (__construct) [id: 2] /classes/Link.php:397 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:397 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /classes/Link.php:397 (__construct) [id: 2] /classes/Link.php:397 (__construct) [id: 2] /modules/tvcmssearch/tvcmssearch.php:110 (getNestedCategories) [id: 2] /classes/Link.php:397 (__construct) [id: 26] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1715 (__construct) [id: 26] /classes/Link.php:397 (__construct) [id: 67] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1715 (__construct) [id: 67] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2704 (__construct) [id: 67] /classes/Link.php:397 (__construct) [id: 67] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 10] /classes/Link.php:397 (__construct) [id: 10] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 26] /classes/Link.php:397 (__construct) [id: 26] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 28] /classes/Link.php:397 (__construct) [id: 28] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 29] /classes/Link.php:397 (__construct) [id: 29] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 67] /classes/Link.php:397 (__construct) [id: 67]
Combination	25	/classes/Product.php:5597 (__construct) [id: 11700] /classes/Product.php:5597 (__construct) [id: 11695] /classes/Product.php:5597 (__construct) [id: 11690] /classes/Product.php:5597 (__construct) [id: 11685] /classes/Product.php:5597 (__construct) [id: 11680] /classes/Product.php:5597 (__construct) [id: 11675] /classes/Product.php:5597 (__construct) [id: 11670] /classes/Product.php:5597 (__construct) [id: 11665] /classes/Product.php:5597 (__construct) [id: 11660] /classes/Product.php:5597 (__construct) [id: 11655] /classes/Product.php:5597 (__construct) [id: 11650] /classes/Product.php:5597 (__construct) [id: 11645] /classes/Product.php:5597 (__construct) [id: 12810] /classes/Product.php:5597 (__construct) [id: 12805] /classes/Product.php:5597 (__construct) [id: 12800] /classes/Product.php:5597 (__construct) [id: 12795] /classes/Product.php:5597 (__construct) [id: 12790] /classes/Product.php:5597 (__construct) [id: 11420] /classes/Product.php:5597 (__construct) [id: 10338] /classes/Product.php:5597 (__construct) [id: 11365] /classes/Product.php:5597 (__construct) [id: 12375] /classes/Product.php:5597 (__construct) [id: 11925] /classes/Product.php:5597 (__construct) [id: 11550] /classes/Product.php:5597 (__construct) [id: 10750] /classes/Product.php:5597 (__construct) [id: 10538]
CMS	7	/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] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 6] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 7]
Country	6	/config/config.inc.php:154 (__construct) [id: 10] /classes/controller/FrontController.php:317 (__construct) [id: 10] /classes/AddressFormat.php:402 (__construct) [id: 10] /classes/controller/FrontController.php:1719 (__construct) [id: 10] /classes/AddressFormat.php:402 (__construct) [id: 10] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 10]
State	5	/classes/AddressFormat.php:402 (__construct) [id: 186] /classes/controller/FrontController.php:1718 (__construct) [id: 186] /classes/AddressFormat.php:402 (__construct) [id: 186] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 186] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 186]
Address	4	/classes/shop/Shop.php:490 (__construct) [id: ] /classes/Product.php:3411 (initialize) [id: ] /classes/Product.php:3521 (__construct) [id: ] /classes/Product.php:5649 (__construct) [id: ]
Language	3	/config/config.inc.php:219 (__construct) [id: 1] /classes/Tools.php:631 (__construct) [id: 2] /classes/Tools.php:550 (__construct) [id: 2]
AddressFormat	2	/classes/controller/FrontController.php:1713 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:685 (getCurrencyInstance) [id: 1]
Manufacturer	2	/classes/Link.php:650 (__construct) [id: 4] /classes/Link.php:650 (__construct) [id: 3]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
Hook	1	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 1196]
PrestaShop\Module\LinkList\Model\LinkBlock	1	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2]
Shop	1	/config/config.inc.php:122 (initialize) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1400 (__construct) [id: ]
Risk	1	/classes/controller/FrontController.php:1639 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1636 (__construct) [id: 0]
Group	1	/classes/Cart.php:255 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:430 (__construct) [id: ]
Customer	1	/config/config.inc.php:272 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:565 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
72	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 hpajx_product p LEFT JOIN hpajx_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN hpajx_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN hpajx_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 hpajx_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN hpajx_category_product cp ON (p.id_product = cp.id_product) INNER JOIN hpajx_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN hpajx_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN hpajx_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=621 GROUP BY p.id_product) p INNER JOIN hpajx_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position DESC, p.id_product DESC	245.581 ms	11634921	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:189 (getProductByFilters) /classes/controller/ProductListingFrontController.php:355 (runQuery) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
497	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-09-08 00:00:00", INTERVAL 30 DAY)) > 0 AS new, product_shop.price AS orderprice, psales.`quantity` as sales FROM `hpajx_category_product` cp LEFT JOIN `hpajx_product` p ON p.`id_product` = cp.`id_product` INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `hpajx_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN hpajx_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `hpajx_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `hpajx_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 ) LEFT JOIN `hpajx_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `hpajx_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `hpajx_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `hpajx_product_sale` psales ON psales.`id_product` = p.`id_product` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 67 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	17.599 ms	560	Yes		/classes/Category.php:1064 /src/Adapter/Category/CategoryProductSearchProvider.php:92 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:118 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2729 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:166 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:289 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
480	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-09-08 00:00:00", INTERVAL 30 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `hpajx_product` p INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `hpajx_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 LEFT JOIN `hpajx_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `hpajx_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2 LEFT JOIN `hpajx_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `hpajx_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN hpajx_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-09-08 00:00:00", INTERVAL 30 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `hpajx_category_product` cp JOIN `hpajx_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	5.454 ms	1860			/classes/Product.php:2836 /modules/tvcmstabproducts/tvcmstabproducts.php:2784 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:164 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:273 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
476	SELECT SQL_NO_CACHE c., cl. FROM `hpajx_category` c INNER JOIN hpajx_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `hpajx_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `hpajx_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `hpajx_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 5 AND `id_lang` = 2 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, cl.`name` ASC	4.981 ms	310	Yes	Yes	/classes/Category.php:799 /modules/ps_categorytree/ps_categorytree.php:141 (getNestedCategories) /modules/ps_categorytree/ps_categorytree.php:298 (getCategories) /modules/ps_categorytree/ps_categorytree.php:266 (getWidgetVariables) /classes/Hook.php:1262 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1191 (coreRenderWidget) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
308	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-09-08 00:00:00", INTERVAL 30 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `hpajx_product` p INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `hpajx_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 LEFT JOIN `hpajx_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `hpajx_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2 LEFT JOIN `hpajx_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `hpajx_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN hpajx_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-09-08 00:00:00", INTERVAL 30 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `hpajx_category_product` cp JOIN `hpajx_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 5	3.114 ms	1860			/classes/Product.php:2836 /modules/tvcmsproductpopup/tvcmsproductpopup.php:376 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:264 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:555 (prevHook) /classes/Hook.php:1251 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:162 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:50 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
457	SELECT SQL_NO_CACHE c., cl. FROM `hpajx_category` c INNER JOIN hpajx_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `hpajx_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 2 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	2.851 ms	311	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:110 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:261 (getAllCategories) /classes/Hook.php:1251 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/e6/ab/6a/e6ab6af9bdedc5d4cf98b65b80a37a15ff9cf06d_2.file.desk-header-7.tpl.php:72 (__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/v1_kkillur_3layouts_layout_left_column_tpl/e6/ab/6a/e6ab6af9bdedc5d4cf98b65b80a37a15ff9cf06d_2.file.desk-header-7.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca85a1d49_20802678) /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/v1_kkillur_3layouts_layout_left_column_tpl/87/5c/34/875c34f7f3c89999adba215df17098512ddc05d4_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca85982d5_81251967) /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/v1_kkillur_3layouts_layout_left_column_tpl/8e/05/e1/8e05e1b4b6c07d015c1506abb07daefa87fda29f_2.file.header.tpl.php:57 (_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/v1_kkillur_3layouts_layout_left_column_tpl/8e/05/e1/8e05e1b4b6c07d015c1506abb07daefa87fda29f_2.file.header.tpl.php:31 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8575748_33909769) /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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:190 (_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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:60 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `hpajx_configuration` c LEFT JOIN `hpajx_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	2.790 ms	929			/classes/Configuration.php:182 /classes/Configuration.php:230 (loadConfiguration) /classes/Configuration.php:303 (get) /classes/shop/Shop.php:402 (getMultiShopValues) /config/config.inc.php:122 (initialize) /index.php:40 (require_once)
16	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `hpajx_module` m INNER JOIN hpajx_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `hpajx_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `hpajx_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `hpajx_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`	2.327 ms	210	Yes	Yes	/classes/Hook.php:1514 /classes/Hook.php:824 (getAllHookRegistrations) /classes/Hook.php:966 (getHookModuleExecList) /classes/Dispatcher.php:587 (exec) /classes/Dispatcher.php:238 (loadRoutes) /classes/Dispatcher.php:196 (__construct) /index.php:78 (getInstance)
498	SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `hpajx_product` p INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `hpajx_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 67 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1	1.840 ms	560			/classes/Category.php:991 /src/Adapter/Category/CategoryProductSearchProvider.php:92 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:119 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2729 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:166 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:289 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
76	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `hpajx_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `hpajx_hook_alias` ha INNER JOIN `hpajx_hook` h ON ha.name = h.name	1.612 ms	0			/classes/Hook.php:1582 /classes/Hook.php:251 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3642 (getManager) /classes/Product.php:3434 (priceCalculation) /classes/Product.php:5406 (getPriceStatic) /classes/ProductAssembler.php:217 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
77	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 `hpajx_hook_module` hm STRAIGHT_JOIN `hpajx_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `hpajx_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.596 ms	526			/classes/Hook.php:517 /classes/Hook.php:554 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3642 (getManager) /classes/Product.php:3434 (priceCalculation) /classes/Product.php:5406 (getPriceStatic) /classes/ProductAssembler.php:217 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
560	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-09-08 00:00:00", INTERVAL 30 DAY)) > 0 AS new FROM `hpajx_product_sale` ps LEFT JOIN `hpajx_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `hpajx_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `hpajx_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 LEFT JOIN `hpajx_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `hpajx_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `hpajx_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `hpajx_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 10 AND tr.`id_state` = 0 LEFT JOIN `hpajx_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN hpajx_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `hpajx_category_product` cp JOIN `hpajx_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	1.426 ms	4			/classes/ProductSale.php:150 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:79 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2900 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:163 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:277 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
15	SELECT SQL_NO_CACHE lower(name) as name FROM `hpajx_hook` h WHERE (h.active = 1)	1.117 ms	1223			/classes/Hook.php:1622 /classes/Hook.php:924 (getHookStatusByName) /classes/Dispatcher.php:587 (exec) /classes/Dispatcher.php:238 (loadRoutes) /classes/Dispatcher.php:196 (__construct) /index.php:78 (getInstance)
624	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `hpajx_manufacturer` m INNER JOIN hpajx_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `hpajx_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 AND m.`id_manufacturer` IN (SELECT `id_manufacturer` FROM `hpajx_product`) ORDER BY m.`name` ASC	1.038 ms	4548	Yes		/classes/Manufacturer.php:205 /modules/ps_brandlist/ps_brandlist.php:283 (getManufacturers) /modules/ps_brandlist/ps_brandlist.php:265 (getWidgetVariables) /classes/Hook.php:1262 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1191 (coreRenderWidget) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
200	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `hpajx_attribute` a LEFT JOIN `hpajx_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `hpajx_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN hpajx_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 `hpajx_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 1011 AND pac.`id_product_attribute` = 11645 AND agl.`id_lang` = 2	0.949 ms	1			/classes/Product.php:7155 /classes/Product.php:5542 (getAttributesParams) /classes/ProductAssembler.php:217 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
245	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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `hpajx_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` = 1022 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.911 ms	5	Yes	Yes	/classes/Product.php:2555 /modules/trustpilot/trustbox.php:109 (getAttributeCombinations) /modules/trustpilot/trustbox.php:40 (loadCategoryProductData) /modules/trustpilot/trustpilot.php:443 (setProducts) /classes/Hook.php:1251 (hookFilterProductSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /classes/controller/ProductListingFrontController.php:442 (exec) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
250	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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `hpajx_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` = 1021 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.911 ms	5	Yes	Yes	/classes/Product.php:2555 /modules/trustpilot/trustbox.php:109 (getAttributeCombinations) /modules/trustpilot/trustbox.php:40 (loadCategoryProductData) /modules/trustpilot/trustpilot.php:443 (setProducts) /classes/Hook.php:1251 (hookFilterProductSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /classes/controller/ProductListingFrontController.php:442 (exec) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
20	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `hpajx_hook`	0.876 ms	1223			/classes/Hook.php:1582 /classes/Hook.php:251 (getAllHookIds) /classes/Hook.php:975 (getIdByName) /classes/Dispatcher.php:587 (exec) /classes/Dispatcher.php:238 (loadRoutes) /classes/Dispatcher.php:196 (__construct) /index.php:78 (getInstance)
168	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 `hpajx_cart_product` cp WHERE cp.`id_product_attribute` = 11660 AND cp.`id_cart` = 0 AND cp.`id_product` = 1014 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `hpajx_cart_product` cp JOIN `hpajx_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hpajx_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 11660 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1014 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.860 ms	0			/classes/Cart.php:1421 /classes/Product.php:4078 (getProductQuantity) /classes/Product.php:5528 (getQuantity) /classes/ProductAssembler.php:217 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
41	SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_description` FROM `hpajx_category` c INNER JOIN hpajx_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `hpajx_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `hpajx_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.839 ms	8	Yes	Yes	/classes/Category.php:924 /controllers/front/listing/CategoryController.php:275 (getSubCategories) /controllers/front/listing/CategoryController.php:160 (getTemplateVarSubCategories) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
493	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2025-09-08 00:00:00", INTERVAL 30 DAY ) ) > 0 AS new FROM `hpajx_product` p INNER JOIN hpajx_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `hpajx_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN hpajx_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `hpajx_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 ) LEFT JOIN `hpajx_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `hpajx_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `hpajx_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE product_shop.`active` = 1 AND product_shop.`show_price` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN (0) AND EXISTS(SELECT 1 FROM `hpajx_category_product` cp JOIN `hpajx_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	0.804 ms	0			/classes/Product.php:3113 /modules/tvcmstabproducts/tvcmstabproducts.php:2838 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:165 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:276 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
74	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-09-08 00:00:00', INTERVAL 30 DAY ) ) > 0) as new FROM hpajx_product p LEFT JOIN hpajx_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN hpajx_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN hpajx_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1022,1021,1020,1019,1018,1017,1016,1015,1014,1013,1012,1011)	0.707 ms	12			/classes/ProductAssembler.php:101 /classes/ProductAssembler.php:211 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
484	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-09-08 00:00:00', INTERVAL 30 DAY ) ) > 0) as new FROM hpajx_product p LEFT JOIN hpajx_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN hpajx_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN hpajx_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1241)	0.705 ms	1			/classes/ProductAssembler.php:70 /classes/ProductAssembler.php:189 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (assembleProduct) /modules/tvcmsnewproducts/tvcmsnewproducts.php:164 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:273 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
805	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `hpajx_product_attribute` pa INNER JOIN hpajx_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `hpajx_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1011) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.678 ms	20	Yes	Yes	/classes/Product.php:4241 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:201 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca887af88_53087678) /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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca885c150_57745520) /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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8855cf5_89015575) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:62 (_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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:117 (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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:70 (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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
559	SELECT SQL_NO_CACHE mainTable.id_tvcmstestimonial AS code, mainTable.image, mainTable.signature_image, mainTable.signature_text, mainTable.link, subTable.title, subTable.designation, subTable.short_description, subTable.description FROM `hpajx_tvcmstestimonial` mainTable LEFT JOIN hpajx_tvcmstestimonial_lang subTable ON mainTable.id_tvcmstestimonial = subTable.id_tvcmstestimonial WHERE mainTable.id_shop_group = 1 AND mainTable.id_shop = 1 AND mainTable.status = 1 AND subTable.id_lang = 2 ORDER BY `position`	0.647 ms	9	Yes		/modules/tvcmstestimonial/tvcmstestimonial.php:537 /modules/tvcmstestimonial/tvcmstestimonial.php:1239 (showFrontData) /modules/tvcmstestimonial/tvcmstestimonial.php:1259 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
481	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-09-08 00:00:00', INTERVAL 30 DAY ) ) > 0) as new FROM hpajx_product p LEFT JOIN hpajx_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN hpajx_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN hpajx_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1242)	0.646 ms	1			/classes/ProductAssembler.php:70 /classes/ProductAssembler.php:189 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (assembleProduct) /modules/tvcmsnewproducts/tvcmsnewproducts.php:164 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:273 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
487	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-09-08 00:00:00', INTERVAL 30 DAY ) ) > 0) as new FROM hpajx_product p LEFT JOIN hpajx_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN hpajx_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN hpajx_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (1240)	0.641 ms	1			/classes/ProductAssembler.php:70 /classes/ProductAssembler.php:189 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (assembleProduct) /modules/tvcmsnewproducts/tvcmsnewproducts.php:164 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:273 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
652	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `hpajx_product_attribute` pa INNER JOIN hpajx_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `hpajx_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1021) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.635 ms	20	Yes	Yes	/classes/Product.php:4241 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:201 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca887af88_53087678) /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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca885c150_57745520) /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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8855cf5_89015575) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:62 (_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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:117 (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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:70 (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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
745	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `hpajx_product_attribute` pa INNER JOIN hpajx_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `hpajx_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1015) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.634 ms	20	Yes	Yes	/classes/Product.php:4241 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:201 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca887af88_53087678) /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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca885c150_57745520) /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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8855cf5_89015575) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:62 (_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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:117 (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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:70 (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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
255	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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `hpajx_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` = 1020 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.630 ms	5	Yes	Yes	/classes/Product.php:2555 /modules/trustpilot/trustbox.php:109 (getAttributeCombinations) /modules/trustpilot/trustbox.php:40 (loadCategoryProductData) /modules/trustpilot/trustpilot.php:443 (setProducts) /classes/Hook.php:1251 (hookFilterProductSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /classes/controller/ProductListingFrontController.php:442 (exec) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
156	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 `hpajx_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1015 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `hpajx_cart_product` cp JOIN `hpajx_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hpajx_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1015 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.622 ms	0			/classes/Cart.php:1421 /classes/Product.php:4078 (getProductQuantity) /classes/Product.php:5516 (getQuantity) /classes/ProductAssembler.php:217 (getProductProperties) /classes/controller/ProductListingFrontController.php:106 (assembleProducts) /classes/controller/ProductListingFrontController.php:377 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
715	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `hpajx_product_attribute` pa INNER JOIN hpajx_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `hpajx_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1017) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.618 ms	20	Yes	Yes	/classes/Product.php:4241 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:201 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca887af88_53087678) /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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca885c150_57745520) /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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8855cf5_89015575) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:62 (_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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:117 (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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:70 (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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
570	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `hpajx_attribute` a LEFT JOIN `hpajx_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `hpajx_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN hpajx_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 `hpajx_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) WHERE pa.`id_product` = 1067 AND pac.`id_product_attribute` = 11925 AND agl.`id_lang` = 2	0.580 ms	1			/classes/Product.php:7155 /classes/Product.php:5542 (getAttributesParams) /classes/ProductAssembler.php:194 (getProductProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2933 (assembleProduct) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:163 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:277 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
857	INSERT INTO `hpajx_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')	0.575 ms	1			/classes/ObjectModel.php:543 /classes/ObjectModel.php:497 (add) /classes/Guest.php:256 (save) /modules/statsdata/statsdata.php:82 (setNewGuest) /modules/statsdata/statsdata.php:73 (getScriptPlugins) /classes/Hook.php:1251 (hookDisplayBeforeBodyClosingTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:349 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:135 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
260	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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `hpajx_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` = 1019 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.563 ms	5	Yes	Yes	/classes/Product.php:2555 /modules/trustpilot/trustbox.php:109 (getAttributeCombinations) /modules/trustpilot/trustbox.php:40 (loadCategoryProductData) /modules/trustpilot/trustpilot.php:443 (setProducts) /classes/Hook.php:1251 (hookFilterProductSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /classes/controller/ProductListingFrontController.php:442 (exec) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
499	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-09-08 00:00:00', INTERVAL 30 DAY ) ) > 0) as new FROM hpajx_product p LEFT JOIN hpajx_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 2 LEFT JOIN hpajx_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN hpajx_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (966)	0.558 ms	1			/classes/ProductAssembler.php:70 /classes/ProductAssembler.php:189 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2762 (assembleProduct) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:166 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:289 (showFrontSideResult) /classes/Hook.php:1251 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /config/smarty.config.inc.php:208 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:236 (__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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
790	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `hpajx_product_attribute` pa INNER JOIN hpajx_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `hpajx_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1012) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.555 ms	20	Yes	Yes	/classes/Product.php:4241 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:201 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca887af88_53087678) /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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca885c150_57745520) /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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8855cf5_89015575) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:62 (_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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:117 (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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:70 (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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
280	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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `hpajx_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` = 1015 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.551 ms	5	Yes	Yes	/classes/Product.php:2555 /modules/trustpilot/trustbox.php:109 (getAttributeCombinations) /modules/trustpilot/trustbox.php:40 (loadCategoryProductData) /modules/trustpilot/trustpilot.php:443 (setProducts) /classes/Hook.php:1251 (hookFilterProductSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /classes/controller/ProductListingFrontController.php:442 (exec) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
684	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `hpajx_product_attribute` pa INNER JOIN hpajx_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `hpajx_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `hpajx_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) JOIN `hpajx_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (1019) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.542 ms	20	Yes	Yes	/classes/Product.php:4241 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:788 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:264 (getMainVariants) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:201 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_kkillur_3layouts_layout_left_column_tpl/a0/cc/23/a0cc23172c261a2f03faaa441778c3b4eddb61cf_2.file.product-grid-view.tpl.php:38 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca887af88_53087678) /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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/70/e8/83/70e8831b6e74655a91c9dc08a06e113bc72c4411_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca885c150_57745520) /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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:50 (_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/v1_kkillur_3layouts_layout_left_column_tpl/fd/1c/e1/fd1ce1a3b306f0640ce00c2388568768891a6aed_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca8855cf5_89015575) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:62 (_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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:117 (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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:70 (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/v1_kkillur_3layouts_layout_left_column_tpl/2d/c6/e5/2dc6e51a7c072dcf3367e50425a0de422c900130_2.file.layout-both-columns.tpl.php:71 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca840eaa1_13372379) /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/v1_kkillur_3layouts_layout_left_column_tpl/6d/03/07/6d0307be70b5a4ef1f00e2ed12f4fa9b4311c3ba_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e8598_08528711) /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/v1_kkillur_3layouts_layout_left_column_tpl/7f/38/6f/7f386fff952d2812da7ed432e40f330659fb0e88_2.file.product-list.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83e22f0_40554498) /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/v1_kkillur_3layouts_layout_left_column_tpl/09/4a/71/094a71f872ca5f1b5b48a9f3a645ffab17f41c08_2.file.category.tpl.php:27 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68befca83d1362_91489251) /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:725 (fetch) /classes/controller/FrontController.php:709 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)
290	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 `hpajx_product_attribute` pa INNER JOIN hpajx_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 `hpajx_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `hpajx_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `hpajx_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `hpajx_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2) LEFT JOIN `hpajx_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2) LEFT JOIN `hpajx_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` = 1013 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`	0.537 ms	5	Yes	Yes	/classes/Product.php:2555 /modules/trustpilot/trustbox.php:109 (getAttributeCombinations) /modules/trustpilot/trustbox.php:40 (loadCategoryProductData) /modules/trustpilot/trustpilot.php:443 (setProducts) /classes/Hook.php:1251 (hookFilterProductSearch) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:462 (coreCallHook) /classes/Hook.php:1143 (callHookOn) /classes/controller/ProductListingFrontController.php:442 (exec) /classes/controller/ProductListingFrontController.php:650 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:183 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:487 (run) /index.php:78 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/autoload_static.php
9	/vendor/symfony/deprecation-contracts/function.php
10	/vendor/symfony/polyfill-mbstring/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap80.php
12	/vendor/symfony/polyfill-ctype/bootstrap.php
13	/vendor/symfony/polyfill-ctype/bootstrap80.php
14	/vendor/symfony/polyfill-php83/bootstrap.php
15	/vendor/symfony/polyfill-php83/bootstrap81.php
16	/vendor/symfony/var-dumper/Resources/functions/dump.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
18	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
19	/vendor/twig/twig/src/Resources/core.php
20	/vendor/twig/twig/src/Resources/debug.php
21	/vendor/twig/twig/src/Resources/escaper.php
22	/vendor/twig/twig/src/Resources/string_loader.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
24	/vendor/symfony/string/Resources/functions.php
25	/vendor/symfony/polyfill-intl-idn/bootstrap.php
26	/vendor/symfony/clock/Resources/now.php
27	/vendor/symfony/polyfill-php80/bootstrap.php
28	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
29	/vendor/jakeasmith/http_build_url/src/http_build_url.php
30	/vendor/symfony/polyfill-intl-icu/bootstrap.php
31	/vendor/ircmaxell/password-compat/lib/password.php
32	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/translation/Resources/functions.php
35	/src/Core/Version.php
36	/config/alias.php
37	/vendor/prestashop/autoload/src/PrestashopAutoload.php
38	/vendor/prestashop/autoload/src/LegacyClassLoader.php
39	/vendor/symfony/filesystem/Filesystem.php

T-shirt horror Terrifier

T-shirt Silent Hill 3

T-shirt Ulver Bergtatt

T-shirt Sarcofago INRI

T-shirt Electric wizard dopethrone

Shopping Cart

T-shirt Rollins band the end of silence

T-shirt Rollins band the end of silence

T-shirt Rollins band the end of silence

T-shirt Rollins band the end of silence

T-shirt REO speedwagon hi infidelity

T-shirt REO speedwagon hi infidelity

T-shirt REO speedwagon hi infidelity

T-shirt REO speedwagon hi infidelity

T-shirt Ramones 4 faces

T-shirt Ramones 4 faces

T-shirt Ramones 4 faces

T-shirt Ramones 4 faces

T-shirt Rage Against The Machine

T-shirt Rage Against The Machine

T-shirt Rage Against The Machine

T-shirt Rage Against The Machine

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

T-shirt Radiohead the bends

Stopwatch SQL - 863 queries

Doubles

Tables stress

ObjectModel instances

Included Files