Kancelárske potreby

Notebooks, agendas, office accessories and more. Everything you need to combine the pleasant and the useful, either at work or at home.

Počet produktov: 3

Zoradiť podľa:

Zobrazuje sa 1-3 z 3 položiek

Rýchly náhľad

Mountain fox notebook

13,10 €

Novinka

Rýchly náhľad

Brown bear notebook

13,10 €

Novinka

Rýchly náhľad

Hummingbird notebook

13,10 €

Novinka

Naspäť hore

Load Time	271.969 ms
Querying Time	63 ms
Queries	190
Memory Peak Usage	8.2 Mb
Included Files	1102 files - 13.13 Mb
PrestaShop Cache	- Mb
Global vars	0.12 Mb
- global $_MODULES	56k
- global $_MODULE	19k
- global $_SERVER	15k
- global $config	5k
- global $_ENV	3k
- global $context	3k
- global $default_country	3k
- global $language	3k
- global $smarty	3k
- global $customer	3k
- global $__composer_autoload_files	3k
- global $legacyContainer	3k
- global $exportPhpConfigFile	3k

PrestaShop Version	9.2.0
PHP Version	8.5.12
MySQL Version	12.3.3-MariaDB
Memory Limit	512M
Max Execution Time	240s
Smarty Cache	disabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	34.241 ms	34.241 ms	2.25 Mb	2.7 Mb
__construct	0.016 ms	34.257 ms	- Mb	2.7 Mb
init	10.977 ms	45.234 ms	0.55 Mb	3.0 Mb
checkAccess	0.002 ms	45.236 ms	- Mb	3.0 Mb
setMedia	4.296 ms	49.532 ms	0.12 Mb	3.0 Mb
postProcess	0.001 ms	49.533 ms	- Mb	3.0 Mb
initHeader	0.002 ms	49.535 ms	- Mb	3.0 Mb
initContent	110.056 ms	159.591 ms	2.94 Mb	5.9 Mb
initFooter	0.002 ms	159.593 ms	- Mb	5.9 Mb
display	112.376 ms	271.969 ms	2.25 Mb	8.2 Mb

Hook	Time	Memory Usage
DisplayHeader	19.464 ms	0.26 Mb
=> ps_googleanalytics	0.069 ms	- Mb
=> ps_imageslider	0.513 ms	- Mb
=> ps_searchbar	2.427 ms	- Mb
=> ps_shoppingcart	0.125 ms	- Mb
=> shaim_recaptcha_v3	0.661 ms	- Mb
=> shaim_baliknapostu	0.011 ms	- Mb
=> ps_facebook	15.643 ms	0.25 Mb
=> customizationpigi	0.003 ms	- Mb
=> shaim_bankwire	0.012 ms	- Mb
displayFooter	13.629 ms	0.54 Mb
=> ps_linklist (widget)	10.067 ms	0.50 Mb
=> ps_contactinfo (widget)	3.562 ms	0.04 Mb
displayLeftColumn	6.424 ms	0.19 Mb
=> ps_categorytree (widget)	6.424 ms	0.19 Mb
displayTop	6.022 ms	0.14 Mb
=> ps_mainmenu (widget)	4.061 ms	0.09 Mb
=> ps_searchbar (widget)	1.961 ms	0.05 Mb
displayNav2	3.839 ms	0.14 Mb
=> ps_currencyselector (widget)	0.943 ms	0.06 Mb
=> ps_shoppingcart (widget)	2.896 ms	0.08 Mb
displayFooterBefore	3.376 ms	0.05 Mb
=> ps_socialfollow (widget)	3.376 ms	0.05 Mb
displayNav1	3.318 ms	0.08 Mb
=> ps_contactinfo (widget)	3.318 ms	0.08 Mb
DisplayBeforeBodyClosingTag	3.240 ms	0.14 Mb
=> ps_googleanalytics	2.251 ms	0.10 Mb
=> statsdata	0.989 ms	0.05 Mb
Header	2.267 ms	0.01 Mb
=> webrotate360	2.267 ms	0.01 Mb
ProductSearchProvider	2.244 ms	0.01 Mb
=> ps_facetedsearch	2.244 ms	0.01 Mb
DisplayLeftColumn	1.497 ms	0.01 Mb
=> ps_facetedsearch	1.497 ms	0.01 Mb
ActionFrontControllerSetMedia	0.684 ms	0.01 Mb
=> ps_emailalerts	0.129 ms	- Mb
=> ps_onepagecheckout	0.004 ms	- Mb
=> ps_socialfollow	0.257 ms	- Mb
=> webrotate360	0.002 ms	- Mb
=> ps_facebook	0.289 ms	- Mb
=> customimagepigi	0.002 ms	- Mb
DisplayFooter	0.171 ms	- Mb
=> ps_facebook	0.164 ms	- Mb
=> customizationpigi	0.005 ms	- Mb
=> customimagepigi	0.002 ms	- Mb
DisplayOverrideTemplate	0.051 ms	- Mb
=> ps_onepagecheckout	0.051 ms	- Mb
DisplayTop	0.013 ms	- Mb
=> pagesnotfound	0.013 ms	- Mb
ActionFrontControllerSetVariables	0.009 ms	- Mb
=> ps_onepagecheckout	0.009 ms	- Mb
ModuleRoutes	0.005 ms	- Mb
=> ps_mcp_server	0.005 ms	- Mb
ActionPresentCart	0.003 ms	- Mb
=> shaim_bankwire	0.003 ms	- Mb
18 hook(s)	66.256 ms	1.58 Mb

Module	Time	Memory Usage
ps_mcp_server	4.208 ms	- Mb
__construct	4.199 ms	- Mb
hookModuleRoutes	0.009 ms	- Mb
ps_emailalerts	0.806 ms	0.06 Mb
__construct	0.674 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.132 ms	- Mb
ps_onepagecheckout	0.203 ms	0.01 Mb
__construct	0.133 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.005 ms	- Mb
hookActionFrontControllerSetVariables	0.012 ms	- Mb
hookDisplayOverrideTemplate	0.053 ms	- Mb
ps_socialfollow	3.742 ms	0.06 Mb
__construct	0.102 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.259 ms	- Mb
displayFooterBefore	3.381 ms	0.05 Mb
webrotate360	2.489 ms	0.02 Mb
__construct	0.214 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.003 ms	- Mb
hookHeader	2.272 ms	0.01 Mb
ps_facebook	16.795 ms	0.26 Mb
__construct	0.689 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.291 ms	- Mb
hookDisplayHeader	15.648 ms	0.25 Mb
hookDisplayFooter	0.167 ms	- Mb
customimagepigi	0.266 ms	0.01 Mb
__construct	0.260 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.003 ms	- Mb
hookDisplayFooter	0.003 ms	- Mb
shaim_bankwire	0.527 ms	0.07 Mb
__construct	0.507 ms	0.07 Mb
hookActionPresentCart	0.006 ms	- Mb
hookDisplayHeader	0.014 ms	- Mb
ps_facetedsearch	4.430 ms	0.03 Mb
__construct	0.682 ms	0.01 Mb
hookProductSearchProvider	2.248 ms	0.01 Mb
hookDisplayLeftColumn	1.500 ms	0.02 Mb
ps_googleanalytics	2.493 ms	0.10 Mb
__construct	0.167 ms	0.01 Mb
hookDisplayHeader	0.071 ms	- Mb
hookDisplayBeforeBodyClosingTag	2.255 ms	0.10 Mb
ps_imageslider	0.641 ms	0.01 Mb
__construct	0.126 ms	0.01 Mb
hookDisplayHeader	0.515 ms	- Mb
ps_searchbar	4.508 ms	0.06 Mb
__construct	0.116 ms	0.01 Mb
hookDisplayHeader	2.429 ms	0.01 Mb
displayTop	1.963 ms	0.05 Mb
ps_shoppingcart	3.131 ms	0.09 Mb
__construct	0.105 ms	0.01 Mb
hookDisplayHeader	0.127 ms	- Mb
displayNav2	2.899 ms	0.08 Mb
shaim_recaptcha_v3	1.003 ms	0.03 Mb
__construct	0.339 ms	0.03 Mb
hookDisplayHeader	0.664 ms	- Mb
shaim_baliknapostu	0.298 ms	0.02 Mb
__construct	0.285 ms	0.02 Mb
hookDisplayHeader	0.013 ms	- Mb
ps_accounts	0.376 ms	0.01 Mb
__construct	0.376 ms	0.01 Mb
customizationpigi	0.275 ms	0.01 Mb
__construct	0.265 ms	0.01 Mb
hookDisplayHeader	0.004 ms	- Mb
hookDisplayFooter	0.006 ms	- Mb
ps_contactinfo	7.057 ms	0.12 Mb
__construct	0.167 ms	0.01 Mb
displayNav1	3.323 ms	0.08 Mb
displayFooter	3.567 ms	0.04 Mb
ps_currencyselector	1.062 ms	0.07 Mb
__construct	0.116 ms	0.01 Mb
displayNav2	0.946 ms	0.06 Mb
ps_mainmenu	4.230 ms	0.10 Mb
__construct	0.166 ms	0.01 Mb
displayTop	4.064 ms	0.09 Mb
pagesnotfound	0.152 ms	0.01 Mb
__construct	0.137 ms	0.01 Mb
hookDisplayTop	0.015 ms	- Mb
ps_categorytree	6.572 ms	0.26 Mb
__construct	0.145 ms	0.07 Mb
displayLeftColumn	6.427 ms	0.19 Mb
ps_linklist	10.486 ms	0.51 Mb
__construct	0.415 ms	0.01 Mb
displayFooter	10.071 ms	0.50 Mb
statsdata	1.149 ms	0.05 Mb
__construct	0.157 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	0.992 ms	0.05 Mb
24 module(s)	76.900 ms	1.92 Mb

Kancelárske potreby

Mountain fox notebook

Brown bear notebook

Hummingbird notebook

Stopwatch SQL - 190 queries

Doubles

Tables stress

ObjectModel instances

Included Files

9 queries	SELECT `id_module` FROM `lXXbas_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6 queries	SELECT SUM(quantity) FROM `lXXbas_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
6 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `lXXbas_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 `lXXbas_cart_product` cp JOIN `lXXbas_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `lXXbas_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
4 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `lXXbas_attribute_group` ag INNER JOIN `lXXbas_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `lXXbas_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `lXXbas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN lXXbas_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN lXXbas_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `lXXbas_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
4 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM lXXbas_product p INNER JOIN lXXbas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN lXXbas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN lXXbas_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN lXXbas_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN lXXbas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN lXXbas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN lXXbas_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=XX)) GROUP BY pac.id_attribute
4 queries	SELECT * FROM `lXXbas_cms` a LEFT JOIN `lXXbas_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
4 queries	SELECT * FROM `lXXbas_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
3 queries	SELECT `need_identification_number` FROM `lXXbas_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `lXXbas_product` p INNER JOIN `lXXbas_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `lXXbas_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
3 queries	SELECT `reduction` FROM `lXXbas_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
3 queries	SELECT pa.`available_date` FROM `lXXbas_product` p LEFT JOIN `lXXbas_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN lXXbas_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN lXXbas_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
3 queries	SELECT 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 `lXXbas_attribute` a LEFT JOIN `lXXbas_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `lXXbas_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `lXXbas_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN lXXbas_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 `lXXbas_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `lXXbas_attribute_group` ag ON (a.`id_attribute_group` = ag.`id_attribute_group`) LEFT JOIN `lXXbas_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 ORDER BY ag.`position` ASC, a.`position` ASC
3 queries	SELECT * FROM `lXXbas_product_attribute` a LEFT JOIN `lXXbas_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
3 queries	SELECT * FROM `lXXbas_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT * FROM `lXXbas_product` a LEFT JOIN `lXXbas_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `lXXbas_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
3 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `lXXbas_image` i INNER JOIN lXXbas_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `lXXbas_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `lXXbas_product_attribute_image` pai LEFT JOIN `lXXbas_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `lXXbas_image` i ON (i.`id_image` = pai.`id_image`) WHERE i.`id_product` = XX AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `lXXbas_product_attribute` pa INNER JOIN lXXbas_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 `lXXbas_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `lXXbas_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `lXXbas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `lXXbas_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
3 queries	SELECT al.`name` AS attribute_name FROM `lXXbas_product_attribute_combination` pac LEFT JOIN `lXXbas_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `lXXbas_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `lXXbas_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `lXXbas_module` m LEFT JOIN `lXXbas_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT * FROM `lXXbas_category` a LEFT JOIN `lXXbas_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `lXXbas_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
2 queries	SELECT `id_lang` FROM `lXXbas_lang` WHERE `locale` = 'sk-sk' OR `language_code` = 'sk-sk' LIMIT XX
2 queries	SELECT value FROM `lXXbas_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT XX
2 queries	SELECT * FROM `lXXbas_category` aXX LEFT JOIN `lXXbas_category_lang` `aXX` ON (aXX.`id_category` = aXX.`id_category`) WHERE (aXX.`nleft` < XX) AND (aXX.`nright` > XX) AND (aXX.`id_lang` = XX) AND (aXX.`id_shop` = XX) ORDER BY aXX.`nleft` asc
2 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM lXXbas_product p INNER JOIN lXXbas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN lXXbas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN lXXbas_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN lXXbas_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN lXXbas_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
2 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `lXXbas_feature_value` v LEFT JOIN `lXXbas_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `lXXbas_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
2 queries	SELECT * FROM `lXXbas_link_block` a LEFT JOIN `lXXbas_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
2 queries	SELECT * FROM `lXXbas_link_block_lang` WHERE `id_link_block` = XX

Name	Instances	Source
Category	13	/controllers/front/listing/CategoryController.php:71 (__construct) [id: 7] /classes/Meta.php:362 (__construct) [id: 7] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:363 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:393 (__construct) [id: 7] /modules/ps_facetedsearch/src/Filters/Block.php:153 (__construct) [id: 7] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2] /src/Adapter/Presenter/Category/CategoryLazyArray.php:97 (__construct) [id: 7]
Country	9	/config/config.inc.php:135 (__construct) [id: 37] /classes/controller/FrontController.php:311 (__construct) [id: 37] /classes/AddressFormat.php:382 (__construct) [id: 37] /classes/controller/FrontController.php:1798 (__construct) [id: 37] /classes/controller/FrontController.php:1983 (__construct) [id: 37] /classes/AddressFormat.php:382 (__construct) [id: 37] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 37] /classes/AddressFormat.php:382 (__construct) [id: 37] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 37]
Product	6	/src/Adapter/Image/ImageRetriever.php:48 (__construct) [id: 16] /src/Adapter/Image/ImageRetriever.php:48 (__construct) [id: 17] /src/Adapter/Image/ImageRetriever.php:48 (__construct) [id: 18] /classes/Link.php:94 (__construct) [id: 16] /classes/Link.php:94 (__construct) [id: 17] /classes/Link.php:94 (__construct) [id: 18]
CMS	5	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 4] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 3] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 1] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 2]
Address	4	/classes/shop/Shop.php:468 (__construct) [id: ] /classes/Product.php:3483 (initialize) [id: ] /classes/Product.php:3602 (__construct) [id: ] /classes/Product.php:5771 (__construct) [id: ]
Combination	3	/classes/Product.php:5723 (__construct) [id: 28] /classes/Product.php:5723 (__construct) [id: 32] /classes/Product.php:5723 (__construct) [id: 36]
AddressFormat	3	/classes/controller/FrontController.php:1792 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
State	3	/classes/controller/FrontController.php:1797 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 0]
Language	2	/config/config.inc.php:207 (__construct) [id: 1] /classes/Tools.php:612 (__construct) [id: 1]
Hook	2	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 50] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 50]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:81 (__construct) [id: 1] /classes/Tools.php:772 (getCurrencyInstance) [id: 1]
PrestaShop\Module\LinkList\Model\LinkBlock	2	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 1] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2]
Shop	1	/config/config.inc.php:103 (initialize) [id: 1]
Configuration	1	/modules/ps_accounts/src/Adapter/Configuration.php:239 (__construct) [id: 352]
Risk	1	/classes/controller/FrontController.php:1718 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1715 (__construct) [id: 0]
Group	1	/classes/Cart.php:264 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:446 (__construct) [id: ]
Customer	1	/config/config.inc.php:260 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:543 (__construct) [id: 1]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
83	REPLACE INTO l4bas_layered_filter_block (hash, data) VALUES ("25ea158a9905bbd5f8a334dee24cb426", "a:1:{s:7:\"filters\";a:10:{i:0;a:7:{s:9:\"type_lite\";s:12:\"availability\";s:4:\"type\";s:12:\"availability\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Dostupnosť\";s:6:\"values\";a:2:{i:2;a:2:{s:4:\"name\";s:9:\"Na sklade\";s:3:\"nbr\";i:3;}i:0;a:2:{s:4:\"name\";s:11:\"Nedostupné\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Výber\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:13:\"Vo výpredaji\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:13:\"Nový produkt\";s:3:\"nbr\";i:3;}s:8:\"discount\";a:2:{s:4:\"name\";s:9:\"Zlacnené\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Cena\";s:3:\"max\";d:16;s:3:\"min\";d:15;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"e\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:2:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"e\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:3;s:5:\"value\";N;}i:3;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Kategórie\";s:6:\"values\";a:0:{}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:1;s:6:\"values\";a:1:{i:5;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:20:\"Recyklovaný kartón\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:4;}}s:4:\"name\";s:9:\"Zloženie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:2;s:6:\"values\";a:1:{i:10;a:5:{s:3:\"nbr\";i:3;s:4:\"name\";s:10:\"120 strán\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:8:\"position\";i:3;}}s:4:\"name\";s:10:\"Vlastnosť\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:0:{}i:7;a:7:{s:9:\"type_lite\";s:9:\"condition\";s:4:\"type\";s:9:\"condition\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Stav\";s:6:\"values\";a:3:{s:3:\"new\";a:2:{s:4:\"name\";s:7:\"Novinka\";s:3:\"nbr\";i:3;}s:4:\"used\";a:2:{s:4:\"name\";s:9:\"Použité\";s:3:\"nbr\";i:0;}s:11:\"refurbished\";a:2:{s:4:\"name\";s:11:\"Repasované\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:8;a:12:{s:9:\"type_lite\";s:6:\"weight\";s:4:\"type\";s:6:\"weight\";s:6:\"id_key\";i:0;s:4:\"name\";s:9:\"Hmotnosť\";s:3:\"max\";d:0.3;s:3:\"min\";d:0.3;s:4:\"unit\";s:2:\"kg\";s:14:\"specifications\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:5:\"value\";N;s:3:\"nbr\";i:3;}i:9;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:4;s:4:\"name\";s:11:\"Typ papiera\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:4:{i:22;a:4:{s:4:\"name\";s:10:\"Linajkové\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:23;a:4:{s:4:\"name\";s:7:\"Čisté\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:24;a:4:{s:4:\"name\";s:14:\"Štvorčekové\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:4:{s:4:\"name\";s:10:\"Bodkované\";s:3:\"nbr\";i:3;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	3.355 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:205 /modules/ps_facetedsearch/src/Product/SearchProvider.php:221 (insertIntoCache) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
86	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `l4bas_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `l4bas_hook_alias` ha INNER JOIN `l4bas_hook` h ON ha.name = h.name	1.288 ms	0			/classes/Hook.php:1547 /classes/Hook.php:244 (getAllHookIds) /classes/tax/TaxManagerFactory.php:43 (getIdByName) /classes/tax/TaxManagerFactory.php:22 (execHookTaxManagerFactory) /classes/Product.php:3723 (getManager) /classes/Product.php:3514 (priceCalculation) /classes/Product.php:5538 (getPriceStatic) /classes/ProductAssembler.php:194 (getProductProperties) /classes/controller/ProductListingFrontController.php:110 (assembleProducts) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
87	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 `l4bas_hook_module` hm STRAIGHT_JOIN `l4bas_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `l4bas_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.937 ms	419			/classes/Hook.php:488 /classes/Hook.php:535 (getHookModuleList) /classes/tax/TaxManagerFactory.php:43 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:22 (execHookTaxManagerFactory) /classes/Product.php:3723 (getManager) /classes/Product.php:3514 (priceCalculation) /classes/Product.php:5538 (getPriceStatic) /classes/ProductAssembler.php:194 (getProductProperties) /classes/controller/ProductListingFrontController.php:110 (assembleProducts) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `l4bas_module` m INNER JOIN l4bas_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1) INNER JOIN `l4bas_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `l4bas_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `l4bas_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	0.857 ms	284	Yes	Yes	/classes/Hook.php:1479 /classes/Hook.php:802 (getAllHookRegistrations) /classes/Hook.php:939 (getHookModuleExecList) /classes/Dispatcher.php:634 (exec) /classes/Dispatcher.php:245 (loadRoutes) /classes/Dispatcher.php:207 (__construct) /index.php:66 (getInstance)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `l4bas_configuration` c LEFT JOIN `l4bas_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	0.854 ms	737			/classes/Configuration.php:162 /classes/Configuration.php:210 (loadConfiguration) /classes/Configuration.php:283 (get) /classes/shop/Shop.php:380 (getMultiShopValues) /config/config.inc.php:103 (initialize) /index.php:20 (require_once)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `l4bas_hook` h WHERE (h.active = 1)	0.696 ms	1258			/classes/Hook.php:1587 /classes/Hook.php:903 (getHookStatusByName) /classes/Dispatcher.php:634 (exec) /classes/Dispatcher.php:245 (loadRoutes) /classes/Dispatcher.php:207 (__construct) /index.php:66 (getInstance)
84	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-11-03 00:00:00', INTERVAL 90 DAY ) ) > 0) as new FROM l4bas_product p LEFT JOIN l4bas_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN l4bas_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN l4bas_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (16,17,18)	0.644 ms	3			/classes/ProductAssembler.php:81 /classes/ProductAssembler.php:191 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:110 (assembleProducts) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
82	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN l4bas_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	0.589 ms	360	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
59	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN l4bas_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 l4bas_stock_available sa_1 ON (p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop = 1 AND sa_1.id_shop_group = 0 ) WHERE ((sa.quantity<=0 AND sa_1.out_of_stock=0))	0.578 ms	1620			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:951 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:476 (count) /modules/ps_facetedsearch/src/Filters/Block.php:136 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
154	SELECT SQL_NO_CACHE c., cl. FROM `l4bas_category` c INNER JOIN l4bas_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `l4bas_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 LEFT JOIN `l4bas_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `l4bas_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND c.`level_depth` <= 4 AND `id_lang` = 1 AND c.`active` = 1 AND cg.`id_group` IN (1) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC, category_shop.`position` ASC	0.573 ms	9	Yes	Yes	/classes/Category.php:795 /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:1223 (renderWidget) /tools/profiling/Hook.php:44 (coreRenderWidget) /classes/Hook.php:1154 (coreRenderWidget) /config/smarty.config.inc.php:193 (exec) /classes/Smarty/SmartyLazyRegister.php:61 (smartyHook) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/ba/65/f1/ba65f1fda3b90083cde94c9ed44f9fd8e6ec3d8b_2.file.layout-both-columns.tpl.php:255 (__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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/ba/65/f1/ba65f1fda3b90083cde94c9ed44f9fd8e6ec3d8b_2.file.layout-both-columns.tpl.php:89 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dab99d7_23789972) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daaca74_04423567) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daa61f4_03242207) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/cd/c5/cc/cdc5cc3270f64abb99a53494e20854f0862c9d18_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204da99787_30770467) /vendor/smarty/smarty/libs/sysplugins/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/SmartyCustom.php:92 (fetch) /classes/controller/FrontController.php:773 (fetch) /classes/controller/FrontController.php:757 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
159	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 `l4bas_product_attribute` pa INNER JOIN l4bas_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 `l4bas_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `l4bas_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `l4bas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `l4bas_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (16) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.565 ms	4	Yes	Yes	/classes/Product.php:4333 /src/Adapter/Product/ProductColorsRetriever.php:23 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:814 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:332 (getMainVariants) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/19/66/29/196629388c7b3b54c8cfedf419138b476dc903f0_2.file.product.tpl.php:249 (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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/19/66/29/196629388c7b3b54c8cfedf419138b476dc903f0_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dbb4a76_49579497) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/47/c1/ac/47c1acf95201bf2fb013531695a9885eee1bfe3f_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204db9ca70_70907405) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/fe/3d/3e/fe3d3e91c03512952f38da21024f26a3b82d6442_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204db96900_01463242) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:84 (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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/ba/65/f1/ba65f1fda3b90083cde94c9ed44f9fd8e6ec3d8b_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dab99d7_23789972) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daaca74_04423567) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daa61f4_03242207) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/cd/c5/cc/cdc5cc3270f64abb99a53494e20854f0862c9d18_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204da99787_30770467) /vendor/smarty/smarty/libs/sysplugins/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/SmartyCustom.php:92 (fetch) /classes/controller/FrontController.php:773 (fetch) /classes/controller/FrontController.php:757 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `l4bas_hook`	0.564 ms	1258			/classes/Hook.php:1547 /classes/Hook.php:244 (getAllHookIds) /classes/Hook.php:944 (getIdByName) /classes/Dispatcher.php:634 (exec) /classes/Dispatcher.php:245 (loadRoutes) /classes/Dispatcher.php:207 (__construct) /index.php:66 (getInstance)
35	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 `l4bas_category` c INNER JOIN l4bas_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `l4bas_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `l4bas_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 7 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.562 ms	1	Yes	Yes	/classes/Category.php:926 /controllers/front/listing/CategoryController.php:265 (getSubCategories) /controllers/front/listing/CategoryController.php:151 (getTemplateVarSubCategories) /tools/profiling/Controller.php:26 (init) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
74	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN l4bas_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	0.546 ms	396			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
60	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN l4bas_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.out_of_stock IN (1, 2)) OR (sa.quantity>0))	0.546 ms	1620			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:951 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:490 (count) /modules/ps_facetedsearch/src/Filters/Block.php:136 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
57	SELECT SQL_NO_CACHE p.id_product, cp.position FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY ISNULL(MIN(IF(cp.id_category = 7, cp.position, NULL))) ASC, MIN(IF(cp.id_category = 7, cp.position, NULL)) ASC, p.id_product DESC	0.533 ms	900	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:99 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:190 (getProductByFilters) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
64	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 37) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2026-11-03 18:56:29' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2026-11-03 18:56:29' <= sp.to) ) WHERE ((sp.reduction>0))	0.503 ms	2			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:951 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:601 (count) /modules/ps_facetedsearch/src/Filters/Block.php:139 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
160	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 `l4bas_product_attribute` pa INNER JOIN l4bas_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 `l4bas_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `l4bas_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `l4bas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `l4bas_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (17) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.487 ms	4	Yes	Yes	/classes/Product.php:4333 /src/Adapter/Product/ProductColorsRetriever.php:23 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:814 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:332 (getMainVariants) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/19/66/29/196629388c7b3b54c8cfedf419138b476dc903f0_2.file.product.tpl.php:249 (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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/19/66/29/196629388c7b3b54c8cfedf419138b476dc903f0_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dbb4a76_49579497) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/47/c1/ac/47c1acf95201bf2fb013531695a9885eee1bfe3f_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204db9ca70_70907405) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/fe/3d/3e/fe3d3e91c03512952f38da21024f26a3b82d6442_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204db96900_01463242) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:84 (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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/ba/65/f1/ba65f1fda3b90083cde94c9ed44f9fd8e6ec3d8b_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dab99d7_23789972) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daaca74_04423567) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daa61f4_03242207) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/cd/c5/cc/cdc5cc3270f64abb99a53494e20854f0862c9d18_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204da99787_30770467) /vendor/smarty/smarty/libs/sysplugins/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/SmartyCustom.php:92 (fetch) /classes/controller/FrontController.php:773 (fetch) /classes/controller/FrontController.php:757 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
76	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `l4bas_manufacturer` m INNER JOIN l4bas_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `l4bas_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	0.486 ms	1	Yes		/classes/Manufacturer.php:175 /modules/ps_facetedsearch/src/Filters/Block.php:648 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:142 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
71	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN l4bas_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=2)) GROUP BY pac.id_attribute	0.486 ms	1260	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
78	SELECT SQL_NO_CACHE MIN(p.weight) as min, MAX(p.weight) as max FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11	0.480 ms	18			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:938 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:335 (getMinMaxValue) /modules/ps_facetedsearch/src/Filters/Block.php:130 (getWeightRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
61	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN l4bas_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) WHERE ((sa.quantity>0))	0.475 ms	1620			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:951 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:501 (count) /modules/ps_facetedsearch/src/Filters/Block.php:136 (getAvailabilitiesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
69	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN l4bas_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	0.475 ms	360	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
53	SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `l4bas_attribute_group` ag INNER JOIN l4bas_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `l4bas_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `l4bas_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `l4bas_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND liaglv.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC	0.470 ms	4	Yes	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:124 /modules/ps_facetedsearch/src/Filters/Converter.php:440 (getAttributesGroups) /modules/ps_facetedsearch/src/Product/SearchProvider.php:167 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
67	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.level_depth<=4 AND c.nleft>10 AND c.nright<11 GROUP BY cp.id_category	0.460 ms	108			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:994 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
80	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p LEFT JOIN l4bas_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN l4bas_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN l4bas_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=3)) GROUP BY pac.id_attribute	0.455 ms	270	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:733 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
161	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 `l4bas_product_attribute` pa INNER JOIN l4bas_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 `l4bas_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `l4bas_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `l4bas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `l4bas_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (18) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;	0.454 ms	4	Yes	Yes	/classes/Product.php:4333 /src/Adapter/Product/ProductColorsRetriever.php:23 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:814 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:332 (getMainVariants) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/19/66/29/196629388c7b3b54c8cfedf419138b476dc903f0_2.file.product.tpl.php:249 (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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/19/66/29/196629388c7b3b54c8cfedf419138b476dc903f0_2.file.product.tpl.php:28 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dbb4a76_49579497) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 (render) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/47/c1/ac/47c1acf95201bf2fb013531695a9885eee1bfe3f_2.file.productlist.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204db9ca70_70907405) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/fe/3d/3e/fe3d3e91c03512952f38da21024f26a3b82d6442_2.file.products.tpl.php:30 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204db96900_01463242) /vendor/smarty/smarty/libs/sysplugins/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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:84 (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/prod/smarty/compile/pigilayouts_layout_left_column_tpl/ba/65/f1/ba65f1fda3b90083cde94c9ed44f9fd8e6ec3d8b_2.file.layout-both-columns.tpl.php:94 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204dab99d7_23789972) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/36/db/5c/36db5c727ec6d6dcd1f77a5e21dd5257c68f122d_2.file.layout-left-column.tpl.php:38 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daaca74_04423567) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/29/88/cc/2988cc1b4305315cd9a957fbd56709f6c73dfe12_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204daa61f4_03242207) /vendor/smarty/smarty/libs/sysplugins/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:115 (_subTemplateRender) /var/cache/prod/smarty/compile/pigilayouts_layout_left_column_tpl/cd/c5/cc/cdc5cc3270f64abb99a53494e20854f0862c9d18_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6aea204da99787_30770467) /vendor/smarty/smarty/libs/sysplugins/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/SmartyCustom.php:92 (fetch) /classes/controller/FrontController.php:773 (fetch) /classes/controller/FrontController.php:757 (smartyOutputContent) /tools/profiling/Controller.php:91 (display) /tools/profiling/Controller.php:68 (displayProfiling) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
72	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p INNER JOIN l4bas_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=1)) GROUP BY fp.id_feature_value	0.428 ms	396			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:854 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
77	SELECT SQL_NO_CACHE p.condition, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.condition FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p GROUP BY p.condition	0.427 ms	324	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:390 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:133 (getConditionsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
65	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM l4bas_product p INNER JOIN l4bas_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 37) INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11	0.422 ms	18			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:246 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:127 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
68	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `l4bas_attribute_group` ag INNER JOIN `l4bas_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `l4bas_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `l4bas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN l4bas_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN l4bas_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `l4bas_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 1 ORDER BY agl.`name` ASC, a.`position` ASC	0.403 ms	4	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:79 /modules/ps_facetedsearch/src/Filters/Block.php:727 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
126	SELECT SQL_NO_CACHE * FROM `l4bas_product` a LEFT JOIN `l4bas_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `l4bas_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 18) AND (b.`id_shop` = 1) LIMIT 1	0.400 ms	1			/src/Adapter/EntityMapper.php:54 /classes/ObjectModel.php:228 (load) /tools/profiling/ObjectModel.php:12 (__construct) /classes/Product.php:697 (__construct) /src/Adapter/Image/ImageRetriever.php:48 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:968 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:124 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:30 (__construct) /classes/controller/ProductListingFrontController.php:118 (present) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
62	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.on_sale FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p WHERE ((p.on_sale=1))	0.399 ms	324			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:951 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:561 (count) /modules/ps_facetedsearch/src/Filters/Block.php:139 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
105	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 `l4bas_attribute` a LEFT JOIN `l4bas_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `l4bas_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `l4bas_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN l4bas_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 `l4bas_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `l4bas_attribute_group` ag ON (a.`id_attribute_group` = ag.`id_attribute_group`) LEFT JOIN `l4bas_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 17 AND pac.`id_product_attribute` = 32 AND agl.`id_lang` = 1 ORDER BY ag.`position` ASC, a.`position` ASC	0.391 ms	1	Yes		/classes/Product.php:7264 /classes/Product.php:5676 (getAttributesParams) /classes/ProductAssembler.php:194 (getProductProperties) /classes/controller/ProductListingFrontController.php:110 (assembleProducts) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
63	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.date_add FROM l4bas_product p INNER JOIN l4bas_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN l4bas_category_product cp ON (p.id_product = cp.id_product) INNER JOIN l4bas_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN l4bas_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>=10 AND c.nright<=11 GROUP BY p.id_product) p WHERE p.date_add>'2026-08-06 00:00:00'	0.389 ms	324			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:972 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:951 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:583 (count) /modules/ps_facetedsearch/src/Filters/Block.php:139 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
75	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `l4bas_feature_value` v LEFT JOIN `l4bas_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `l4bas_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC	0.383 ms	4	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:221 /modules/ps_facetedsearch/src/Filters/Block.php:863 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
70	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `l4bas_attribute_group` ag INNER JOIN `l4bas_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `l4bas_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `l4bas_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN l4bas_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN l4bas_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `l4bas_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 2 ORDER BY agl.`name` ASC, a.`position` ASC	0.383 ms	25	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:79 /modules/ps_facetedsearch/src/Filters/Block.php:727 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:219 (getFilterBlock) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
123	SELECT SQL_NO_CACHE * FROM `l4bas_product` a LEFT JOIN `l4bas_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `l4bas_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17) AND (b.`id_shop` = 1) LIMIT 1	0.381 ms	1			/src/Adapter/EntityMapper.php:54 /classes/ObjectModel.php:228 (load) /tools/profiling/ObjectModel.php:12 (__construct) /classes/Product.php:697 (__construct) /src/Adapter/Image/ImageRetriever.php:48 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:968 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:124 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:30 (__construct) /classes/controller/ProductListingFrontController.php:118 (present) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
118	SELECT SQL_NO_CACHE * FROM `l4bas_product` a LEFT JOIN `l4bas_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `l4bas_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 16) AND (b.`id_shop` = 1) LIMIT 1	0.379 ms	1			/src/Adapter/EntityMapper.php:54 /classes/ObjectModel.php:228 (load) /tools/profiling/ObjectModel.php:12 (__construct) /classes/Product.php:697 (__construct) /src/Adapter/Image/ImageRetriever.php:48 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:968 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:124 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:30 (__construct) /classes/controller/ProductListingFrontController.php:118 (present) /classes/controller/ProductListingFrontController.php:385 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (dispatch)
54	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `l4bas_feature` f INNER JOIN l4bas_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `l4bas_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `l4bas_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `l4bas_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	0.375 ms	3	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:161 /modules/ps_facetedsearch/src/Filters/Converter.php:408 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:167 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:363 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:403 (getStructuredData) /classes/controller/FrontController.php:557 (getStructuredData) /classes/controller/FrontController.php:632 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:162 (initContent) /tools/profiling/Controller.php:45 (initContent) /classes/Dispatcher.php:508 (run) /index.php:66 (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/var-dumper/Resources/functions/dump.php
16	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
18	/vendor/twig/twig/src/Resources/core.php
19	/vendor/twig/twig/src/Resources/debug.php
20	/vendor/twig/twig/src/Resources/escaper.php
21	/vendor/twig/twig/src/Resources/string_loader.php
22	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.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/symfony/polyfill-php84/bootstrap.php
32	/vendor/ircmaxell/password-compat/lib/password.php
33	/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
34	/vendor/symfony/polyfill-php73/bootstrap.php
35	/vendor/symfony/translation/Resources/functions.php
36	/src/Core/Version.php
37	/config/alias.php
38	/vendor/prestashop/autoload/src/PrestashopAutoload.php
39	/vendor/prestashop/autoload/src/LegacyClassLoader.php