Load Time	484.012 ms
Querying Time	396 ms
Queries	309
Memory Peak Usage	11.5 Mb
Included Files	771 files - 9.63 Mb
PrestaShop Cache	- Mb
Global vars	0.03 Mb
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $smarty	3k
- global $exportPhpConfigFile	3k
- global $__composer_autoload_files	1k

PrestaShop Version	9.1.0
PHP Version	8.1.34
MySQL Version	8.4.7-7
Memory Limit	512M
Max Execution Time	60s
Smarty Cache	disabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	52.118 ms	52.118 ms	2.48 Mb	2.8 Mb
__construct	0.015 ms	52.133 ms	- Mb	2.8 Mb
init	13.322 ms	65.455 ms	0.45 Mb	3.5 Mb
checkAccess	0.001 ms	65.456 ms	- Mb	3.5 Mb
setMedia	6.413 ms	71.869 ms	0.44 Mb	3.5 Mb
postProcess	0.001 ms	71.870 ms	- Mb	3.5 Mb
initHeader	0.001 ms	71.871 ms	- Mb	3.5 Mb
initContent	350.450 ms	422.321 ms	4.16 Mb	8.7 Mb
initFooter	0.002 ms	422.323 ms	- Mb	8.7 Mb
display	61.689 ms	484.012 ms	2.92 Mb	11.5 Mb

Hook	Time	Memory Usage
displayLeftColumn	11.649 ms	0.63 Mb
=> ps_categorytree (widget)	11.649 ms	0.63 Mb
RotatorImg	6.328 ms	0.29 Mb
=> posrotatorimg	3.665 ms	0.08 Mb
=> posrotatorimg	0.954 ms	0.07 Mb
=> posrotatorimg	0.501 ms	0.07 Mb
=> posrotatorimg	1.208 ms	0.07 Mb
displayAfterBodyOpeningTag	5.737 ms	0.18 Mb
=> posquickmenu (widget)	5.737 ms	0.18 Mb
displayBeforeBodyClosingTag	5.025 ms	0.12 Mb
=> posfakeorder (widget)	1.511 ms	0.04 Mb
=> poscookielaw (widget)	0.534 ms	0.04 Mb
=> pospopup (widget)	2.980 ms	0.04 Mb
DisplayHeader	4.603 ms	0.14 Mb
=> posthemeoptions	2.208 ms	0.02 Mb
=> poswishlist	0.088 ms	- Mb
=> poscompare	0.047 ms	- Mb
=> posproductcomments	0.021 ms	- Mb
=> posrotatorimg	0.196 ms	0.01 Mb
=> possearchproducts	0.004 ms	- Mb
=> poscookielaw	0.089 ms	0.01 Mb
=> posfakeorder	0.139 ms	- Mb
=> posmegamenu	0.031 ms	- Mb
=> posvegamenu	0.053 ms	- Mb
=> posshoppingcart	1.390 ms	0.01 Mb
=> possizechart	0.033 ms	- Mb
=> smartblog	0.238 ms	0.07 Mb
=> stripe_official	0.061 ms	- Mb
=> nkmgls	0.001 ms	- Mb
=> ocpricetracker	0.004 ms	- Mb
DisplayLeftColumn	0.563 ms	0.43 Mb
=> ps_facetedsearch	0.563 ms	0.43 Mb
DisplayProductListFunctionalButtons	0.537 ms	- Mb
=> poswishlist	0.142 ms	- Mb
=> poswishlist	0.103 ms	- Mb
=> poswishlist	0.143 ms	- Mb
=> poswishlist	0.149 ms	- Mb
displayProductListCompare	0.495 ms	- Mb
=> poscompare (widget)	0.145 ms	- Mb
=> poscompare (widget)	0.098 ms	- Mb
=> poscompare (widget)	0.105 ms	- Mb
=> poscompare (widget)	0.147 ms	- Mb
ProductSearchProvider	0.272 ms	0.01 Mb
=> ps_facetedsearch	0.267 ms	0.01 Mb
=> possearchproducts	0.005 ms	- Mb
ActionFrontControllerSetMedia	0.172 ms	0.01 Mb
=> ps_socialfollow	0.034 ms	- Mb
=> ps_emailsubscription	0.081 ms	- Mb
=> ps_emailalerts	0.017 ms	- Mb
=> posquickmenu	0.037 ms	- Mb
=> nkmgls	0.003 ms	- Mb
Header	0.080 ms	0.01 Mb
=> posquickmenu	0.080 ms	0.01 Mb
ModuleRoutes	0.029 ms	0.01 Mb
=> smartblog	0.029 ms	0.01 Mb
ActionFrontControllerInitBefore	0.005 ms	- Mb
=> stripe_official	0.005 ms	- Mb
13 hook(s)	35.495 ms	1.83 Mb

Module	Time	Memory Usage
smartblog	4.486 ms	0.11 Mb
__construct	4.214 ms	0.03 Mb
hookModuleRoutes	0.032 ms	0.01 Mb
hookDisplayHeader	0.240 ms	0.07 Mb
stripe_official	1.233 ms	0.10 Mb
__construct	1.165 ms	0.10 Mb
hookActionFrontControllerInitBefore	0.007 ms	- Mb
hookDisplayHeader	0.061 ms	- Mb
ps_socialfollow	0.174 ms	0.01 Mb
__construct	0.138 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.036 ms	- Mb
ps_emailsubscription	0.132 ms	0.01 Mb
__construct	0.050 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.082 ms	- Mb
ps_emailalerts	0.084 ms	0.01 Mb
__construct	0.066 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.018 ms	- Mb
posquickmenu	5.944 ms	0.21 Mb
__construct	0.085 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.038 ms	- Mb
hookHeader	0.081 ms	0.01 Mb
displayAfterBodyOpeningTag	5.740 ms	0.18 Mb
nkmgls	5.387 ms	0.38 Mb
__construct	5.381 ms	0.38 Mb
hookActionFrontControllerSetMedia	0.005 ms	- Mb
hookDisplayHeader	0.001 ms	- Mb
posthemeoptions	2.306 ms	0.03 Mb
__construct	0.095 ms	0.01 Mb
hookDisplayHeader	2.211 ms	0.02 Mb
poswishlist	0.706 ms	0.02 Mb
__construct	0.073 ms	0.01 Mb
hookDisplayHeader	0.089 ms	- Mb
hookDisplayProductListFunctionalButtons	0.144 ms	- Mb
hookDisplayProductListFunctionalButtons	0.104 ms	- Mb
hookDisplayProductListFunctionalButtons	0.145 ms	- Mb
hookDisplayProductListFunctionalButtons	0.151 ms	- Mb
poscompare	0.590 ms	0.02 Mb
__construct	0.043 ms	0.01 Mb
hookDisplayHeader	0.047 ms	- Mb
displayProductListCompare	0.146 ms	- Mb
displayProductListCompare	0.099 ms	- Mb
displayProductListCompare	0.106 ms	- Mb
displayProductListCompare	0.149 ms	- Mb
posproductcomments	0.112 ms	0.01 Mb
__construct	0.090 ms	0.01 Mb
hookDisplayHeader	0.022 ms	- Mb
posrotatorimg	6.570 ms	0.31 Mb
__construct	0.035 ms	0.01 Mb
hookDisplayHeader	0.197 ms	0.01 Mb
hookRotatorImg	3.667 ms	0.08 Mb
hookRotatorImg	0.957 ms	0.07 Mb
hookRotatorImg	0.503 ms	0.07 Mb
hookRotatorImg	1.211 ms	0.07 Mb
possearchproducts	0.089 ms	0.01 Mb
__construct	0.078 ms	0.01 Mb
hookDisplayHeader	0.005 ms	- Mb
hookProductSearchProvider	0.006 ms	- Mb
poscookielaw	0.684 ms	0.05 Mb
__construct	0.059 ms	0.01 Mb
hookDisplayHeader	0.089 ms	0.01 Mb
displayBeforeBodyClosingTag	0.536 ms	0.04 Mb
posfakeorder	1.690 ms	0.05 Mb
__construct	0.037 ms	0.01 Mb
hookDisplayHeader	0.139 ms	- Mb
displayBeforeBodyClosingTag	1.514 ms	0.04 Mb
posmegamenu	0.089 ms	0.01 Mb
__construct	0.050 ms	0.01 Mb
hookDisplayHeader	0.039 ms	- Mb
posvegamenu	0.135 ms	0.01 Mb
__construct	0.081 ms	0.01 Mb
hookDisplayHeader	0.054 ms	- Mb
posshoppingcart	1.435 ms	0.02 Mb
__construct	0.043 ms	0.01 Mb
hookDisplayHeader	1.392 ms	0.02 Mb
possizechart	0.098 ms	0.01 Mb
__construct	0.065 ms	0.01 Mb
hookDisplayHeader	0.033 ms	- Mb
ocpricetracker	0.064 ms	0.01 Mb
__construct	0.060 ms	0.01 Mb
hookDisplayHeader	0.004 ms	- Mb
ps_facetedsearch	1.095 ms	0.45 Mb
__construct	0.260 ms	0.01 Mb
hookProductSearchProvider	0.269 ms	0.01 Mb
hookDisplayLeftColumn	0.566 ms	0.43 Mb
ps_categorytree	11.724 ms	0.64 Mb
__construct	0.070 ms	0.01 Mb
displayLeftColumn	11.654 ms	0.63 Mb
pospopup	3.046 ms	0.04 Mb
__construct	0.064 ms	0.01 Mb
displayBeforeBodyClosingTag	2.982 ms	0.04 Mb
23 module(s)	47.872 ms	2.50 Mb

64 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM myshop_product p LEFT JOIN myshop_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN myshop_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN myshop_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN myshop_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN myshop_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN myshop_category_product cp ON (p.id_product = cp.id_product) INNER JOIN myshop_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN myshop_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN myshop_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.date_add>'XX-XX-XX XX:XX:XX' GROUP BY p.id_product) p INNER JOIN myshop_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN myshop_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY fp.id_feature_value
25 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 `myshop_attribute_group` ag INNER JOIN `myshop_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `myshop_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `myshop_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN myshop_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 myshop_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `myshop_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
25 queries	SELECT pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM myshop_product p LEFT JOIN myshop_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN myshop_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN myshop_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN myshop_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN myshop_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN myshop_category_product cp ON (p.id_product = cp.id_product) INNER JOIN myshop_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN myshop_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN myshop_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.date_add>'XX-XX-XX XX:XX:XX' GROUP BY p.id_product) p LEFT JOIN myshop_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN myshop_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN myshop_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN myshop_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((a.id_attribute_group=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX))) GROUP BY pac.id_attribute
12 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 `myshop_feature_value` v LEFT JOIN `myshop_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `myshop_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
9 queries	SELECT SUM(quantity) FROM `myshop_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
8 queries	SELECT `id_module` FROM `myshop_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
7 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 `myshop_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 `myshop_cart_product` cp JOIN `myshop_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `myshop_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
7 queries	SELECT cl.`link_rewrite` FROM `myshop_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
5 queries	SELECT XX FROM `myshop_specific_price` WHERE id_product = XX LIMIT XX
4 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 `myshop_product` p INNER JOIN `myshop_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `myshop_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)
4 queries	SELECT `reduction` FROM `myshop_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
4 queries	SELECT * FROM `myshop_product` a LEFT JOIN `myshop_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `myshop_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
4 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `myshop_image` i INNER JOIN myshop_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `myshop_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
4 queries	SELECT * FROM `myshop_image` img LEFT JOIN `myshop_image_shop` imgs ON img.id_image = imgs.id_image where imgs.`id_shop` =XX AND img.`id_product` =XX AND imgs.`rotator` =XX
4 queries	SELECT * FROM `myshop_image` img where img.`rotator` =XX AND img.`id_product` =XX
4 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 `myshop_product_attribute` pa INNER JOIN myshop_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 `myshop_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `myshop_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `myshop_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `myshop_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 pa.`available_date` FROM `myshop_product` p LEFT JOIN `myshop_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN myshop_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN myshop_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 `myshop_attribute` a LEFT JOIN `myshop_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `myshop_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `myshop_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN myshop_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 `myshop_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `myshop_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
3 queries	SELECT * FROM `myshop_product_attribute` a LEFT JOIN `myshop_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 `myshop_product_attribute_lang` WHERE `id_product_attribute` = XX
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `myshop_product_attribute_image` pai LEFT JOIN `myshop_image_lang` il ON (il.`id_image` = pai.`id_image`) INNER JOIN `myshop_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 * FROM `myshop_product` a LEFT JOIN `myshop_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
3 queries	SELECT * FROM `myshop_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
3 queries	SELECT pa., product_attribute_shop. FROM `myshop_product_attribute` pa INNER JOIN myshop_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
2 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `myshop_module` m LEFT JOIN `myshop_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT `id_lang` FROM `myshop_lang` WHERE `locale` = 'de-de' OR `language_code` = 'de-de' LIMIT XX
2 queries	SELECT tr.* FROM `myshop_tax_rule` tr JOIN `myshop_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `myshop_product_attribute_combination` pac LEFT JOIN `myshop_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `myshop_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `myshop_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `myshop_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute

Name	Instances	Source
Product	11	/src/Adapter/Image/ImageRetriever.php:51 (__construct) [id: 1529] /src/Adapter/Image/ImageRetriever.php:51 (__construct) [id: 1515] /src/Adapter/Image/ImageRetriever.php:51 (__construct) [id: 611] /src/Adapter/Image/ImageRetriever.php:51 (__construct) [id: 568] /classes/Link.php:94 (__construct) [id: 1529] /classes/Link.php:94 (__construct) [id: 1515] /classes/Link.php:94 (__construct) [id: 611] /classes/Link.php:94 (__construct) [id: 568] /src/Adapter/Presenter/Product/ProductLazyArray.php:906 (__construct) [id: 1529] /src/Adapter/Presenter/Product/ProductLazyArray.php:906 (__construct) [id: 611] /src/Adapter/Presenter/Product/ProductLazyArray.php:906 (__construct) [id: 568]
Address	4	/classes/shop/Shop.php:467 (__construct) [id: ] /classes/Product.php:3431 (initialize) [id: ] /classes/Product.php:3550 (__construct) [id: ] /classes/Product.php:5706 (__construct) [id: ]
Category	4	/modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:371 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:364 (getParentsCategories) [id: 2]
Combination	3	/classes/Product.php:5654 (__construct) [id: 3048] /classes/Product.php:5654 (__construct) [id: 1908] /classes/Product.php:5654 (__construct) [id: 1842]
Language	3	/config/config.inc.php:200 (__construct) [id: 4] /classes/Tools.php:639 (__construct) [id: 4] /classes/Tools.php:533 (__construct) [id: 4]
Country	3	/config/config.inc.php:135 (__construct) [id: 8] /classes/AddressFormat.php:382 (__construct) [id: 8] /classes/controller/FrontController.php:1719 (__construct) [id: 8]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:81 (__construct) [id: 1] /classes/Tools.php:688 (getCurrencyInstance) [id: 1]
Tax	1	/classes/tax/TaxRulesTaxManager.php:93 (__construct) [id: 1]
State	1	/classes/controller/FrontController.php:1718 (__construct) [id: 0]
AddressFormat	1	/classes/controller/FrontController.php:1713 (generateAddress) [id: ]
Shop	1	/config/config.inc.php:103 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1639 (__construct) [id: ]
Group	1	/classes/Cart.php:261 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:439 (__construct) [id: ]
Customer	1	/config/config.inc.php:253 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:542 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1636 (__construct) [id: 0]

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/autoload_static.php
9	/vendor/symfony/deprecation-contracts/function.php
10	/vendor/symfony/polyfill-mbstring/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap80.php
12	/vendor/symfony/polyfill-ctype/bootstrap.php
13	/vendor/symfony/polyfill-ctype/bootstrap80.php
14	/vendor/symfony/polyfill-php83/bootstrap.php
15	/vendor/symfony/polyfill-php83/bootstrap81.php
16	/vendor/symfony/var-dumper/Resources/functions/dump.php
17	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
18	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
19	/vendor/twig/twig/src/Resources/core.php
20	/vendor/twig/twig/src/Resources/debug.php
21	/vendor/twig/twig/src/Resources/escaper.php
22	/vendor/twig/twig/src/Resources/string_loader.php
23	/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
24	/vendor/symfony/polyfill-intl-grapheme/bootstrap80.php
25	/vendor/symfony/string/Resources/functions.php
26	/vendor/symfony/polyfill-intl-idn/bootstrap.php
27	/vendor/symfony/clock/Resources/now.php
28	/vendor/symfony/polyfill-php80/bootstrap.php
29	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
30	/vendor/jakeasmith/http_build_url/src/http_build_url.php
31	/vendor/symfony/polyfill-intl-icu/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