Úvodná stránka

Tento eshop používa na poskytovanie služieb, personalizáciu reklám a analýze návštevnosti súbory cookie. Prehlásenie o použití cookies

Obuv LOWA Zephyr GTX MID TF, tanger green

0/5

Obuv LOWA Zephyr GTX MID TF, ranger green

175,95 €

0/5

Obuv LOWA Zephyr GTX MID TF, ranger green

175,95 €

Obuv LOWA Zephyr GTX MID TF, ranger green

Stredná

Moderná ľahká stredne vysoká obuv najvyššej kvality s GORE-texovou podšívkou. Je vhodná do ľahkého terénu.

0/5

175,95 €

Obuv LOWA Zephyr GTX MID TF, ranger green

Stredná

Moderná ľahká stredne vysoká obuv najvyššej kvality s GORE-texovou podšívkou. Je vhodná do ľahkého terénu.

0/5

175,95 €

Load Time	1944 ms
Querying Time	1615 ms
Queries	2145
Memory Peak Usage	60.9 Mb
Included Files	938 files - 11.95 Mb
PrestaShop Cache	- Mb
Global vars	0.36 Mb
- global $_MODULES	182k
- global $context	151k
- global $_SERVER	13k
- global $_ENV	7k
- global $exportPhpConfigFile	4k
- global $__composer_autoload_files	3k
- global $config	3k

PrestaShop Version	8.0.4
PHP Version	7.3.33
MySQL Version	10.5.23-MariaDB-0+deb11u1
Memory Limit	256M
Max Execution Time	30s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	6.319 ms	6.319 ms	3.81 Mb	4.1 Mb
__construct	0.022 ms	6.341 ms	- Mb	4.1 Mb
init	20.679 ms	27.020 ms	1.53 Mb	5.8 Mb
checkAccess	0.001 ms	27.021 ms	- Mb	5.8 Mb
setMedia	2.805 ms	29.826 ms	0.23 Mb	5.8 Mb
postProcess	0.002 ms	29.828 ms	- Mb	5.8 Mb
initHeader	0.001 ms	29.829 ms	- Mb	5.8 Mb
initContent	262.333 ms	292.162 ms	5.14 Mb	10.8 Mb
initFooter	0.002 ms	292.164 ms	- Mb	10.8 Mb
display	1652 ms	1944 ms	49.85 Mb	60.9 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	1459 ms	41.44 Mb
=> tvcmsnewproducts	88.171 ms	2.42 Mb
=> tvcmscustomerservices	0.237 ms	0.02 Mb
=> tvcmsfeaturedproducts	143.516 ms	2.17 Mb
=> tvcmsbestsellerproducts	89.465 ms	2.39 Mb
=> tvcmsspecialproducts	1138 ms	34.45 Mb
DisplayNavFullWidth	78.346 ms	3.68 Mb
=> blockreassurance	0.007 ms	- Mb
=> tvcmsverticalmenu	78.339 ms	3.68 Mb
DisplayFooterCategory	18.970 ms	0.52 Mb
=> tvcmsfootercategory	18.970 ms	0.52 Mb
DisplayMegamenu	14.610 ms	0.68 Mb
=> tvcmsmegamenu	14.610 ms	0.68 Mb
displayLeftColumn	12.949 ms	0.29 Mb
=> ps_categorytree (widget)	10.641 ms	0.19 Mb
=> ps_brandlist (widget)	1.588 ms	0.05 Mb
=> ps_supplierlist (widget)	0.720 ms	0.05 Mb
DisplayReviewProductList	8.116 ms	0.33 Mb
=> tvcmsproductcomments	1.877 ms	0.12 Mb
=> tvcmsproductcomments	1.060 ms	0.07 Mb
=> tvcmsproductcomments	4.046 ms	0.07 Mb
=> tvcmsproductcomments	1.133 ms	0.07 Mb
DisplayNavSearchBlock	6.105 ms	0.35 Mb
=> tvcmssearch	6.105 ms	0.35 Mb
DisplayHeader	6.062 ms	0.08 Mb
=> ps_shoppingcart	0.119 ms	- Mb
=> ps_searchbar	0.383 ms	- Mb
=> productcomments	0.232 ms	- Mb
=> ps_googleanalytics	0.587 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.110 ms	- Mb
=> tvcmsblog	0.303 ms	- Mb
=> tvcmsblogdisplayposts	0.204 ms	- Mb
=> tvcmsbrandlist	0.128 ms	- Mb
=> tvcmscategorychainslider	0.168 ms	- Mb
=> tvcmscategoryslider	0.186 ms	- Mb
=> tvcmscookiesnotice	0.116 ms	- Mb
=> tvcmscustomerservices	0.172 ms	- Mb
=> tvcmscustomsetting	0.959 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.113 ms	- Mb
=> tvcmsfooterlogo	0.002 ms	- Mb
=> tvcmsfooterproduct	0.109 ms	- Mb
=> tvcmsnewproducts	0.094 ms	- Mb
=> tvcmsnewsletterpopup	0.248 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsproductcomments	0.341 ms	- Mb
=> tvcmssearch	0.253 ms	- Mb
=> tvcmssizechart	0.159 ms	- Mb
=> tvcmsslider	0.107 ms	- Mb
=> tvcmsspecialproducts	0.085 ms	- Mb
=> tvcmstabproducts	0.144 ms	- Mb
=> tvcmstestimonial	0.112 ms	- Mb
=> tvcmsthemeoptions	0.340 ms	- Mb
=> tvcmswishlist	0.160 ms	- Mb
=> ecardvub	0.113 ms	- Mb
=> dm_cashondelivery	0.013 ms	- Mb
displayContactCinfo	5.061 ms	0.08 Mb
=> ps_contactinfo (widget)	5.061 ms	0.08 Mb
DisplayBeforeBodyClosingTag	3.774 ms	0.20 Mb
=> statsdata	3.761 ms	0.20 Mb
=> tvcmsblog	0.004 ms	- Mb
=> bonrecaptcha	0.009 ms	- Mb
Header	3.342 ms	0.05 Mb
=> tvcmsstockinfo	0.130 ms	- Mb
=> bonrecaptcha	0.003 ms	- Mb
=> tvcmsinfinitescroll	2.217 ms	0.04 Mb
=> tvcmstwoofferbanner	0.190 ms	- Mb
=> tvcmscategoryproduct	0.245 ms	- Mb
=> tvcmsmegamenu	0.192 ms	- Mb
=> tvcmsverticalmenu	0.256 ms	- Mb
=> tvcmssliderofferbanner	0.110 ms	- Mb
DisplayCustomsocialblock	2.918 ms	0.16 Mb
=> tvcmscustomsetting	2.918 ms	0.16 Mb
displayNavCustomerSignInBlock	1.715 ms	0.05 Mb
=> ps_customersignin (widget)	1.715 ms	0.05 Mb
displayMyaccountcblock	1.386 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.386 ms	0.06 Mb
displayNavLanguageBlock	1.191 ms	0.06 Mb
=> ps_languageselector (widget)	1.191 ms	0.06 Mb
displayNavCurrencyBlock	0.990 ms	0.05 Mb
=> ps_currencyselector (widget)	0.990 ms	0.05 Mb
displayNavShoppingCartBlock	0.982 ms	0.11 Mb
=> ps_shoppingcart (widget)	0.982 ms	0.11 Mb
DisplayNavWishlistBlock	0.915 ms	0.04 Mb
=> tvcmswishlist	0.915 ms	0.04 Mb
LeftColumn	0.900 ms	0.16 Mb
=> ecardvub	0.900 ms	0.16 Mb
DisplayWishlistBtnProductList	0.856 ms	0.01 Mb
=> tvcmswishlist	0.276 ms	0.01 Mb
=> tvcmswishlist	0.190 ms	- Mb
=> tvcmswishlist	0.213 ms	- Mb
=> tvcmswishlist	0.177 ms	- Mb
displayFooterPart1	0.822 ms	0.06 Mb
=> ps_linklist (widget)	0.822 ms	0.06 Mb
DisplayNavWishlistBlocksticky	0.800 ms	0.05 Mb
=> tvcmswishlist	0.800 ms	0.05 Mb
DisplayAfterBodyOpeningTag	0.751 ms	0.01 Mb
=> tvcmscookiesnotice	0.742 ms	0.01 Mb
=> blockreassurance	0.009 ms	- Mb
DisplayPaymentIcon	0.648 ms	0.04 Mb
=> tvcmspaymenticon	0.648 ms	0.04 Mb
ActionDispatcherBefore	0.629 ms	0.01 Mb
=> ps_mbo	0.629 ms	0.01 Mb
ActionFrontControllerSetMedia	0.507 ms	0.01 Mb
=> blockreassurance	0.243 ms	0.01 Mb
=> ps_emailsubscription	0.116 ms	- Mb
=> ps_socialfollow	0.069 ms	- Mb
=> ps_emailalerts	0.079 ms	- Mb
ProductSearchProvider	0.387 ms	0.01 Mb
=> ps_facetedsearch	0.387 ms	0.01 Mb
DisplayFacetedSearchBlock	0.224 ms	0.02 Mb
=> ps_facetedsearch	0.224 ms	0.02 Mb
DisplayCopyRightText	0.173 ms	0.01 Mb
=> tvcmscustomsetting	0.173 ms	0.01 Mb
DisplayProductListStockIndicator	0.062 ms	- Mb
=> tvcmsstockinfo	0.035 ms	- Mb
=> tvcmsstockinfo	0.027 ms	- Mb
ModuleRoutes	0.024 ms	0.01 Mb
=> tvcmsblog	0.024 ms	0.01 Mb
DisplayTopOfferText	0.019 ms	- Mb
=> tvcmscustomsetting	0.014 ms	- Mb
=> tvcmscustomsetting	0.005 ms	- Mb
DisplayCustomCss	0.012 ms	- Mb
=> tvcmscustomcssjs	0.012 ms	- Mb
DisplayDownloadApps	0.011 ms	- Mb
=> tvcmscustomsetting	0.011 ms	- Mb
DisplayCustomJs	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
35 hook(s)	1634 ms	48.65 Mb

257 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
256 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
256 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
256 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 `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_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)
249 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
249 queries	SELECT *, ( IF (`id_shop` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
80 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_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
61 queries	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
38 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
26 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = 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
19 queries	SELECT mr.* FROM ps_tvcmsverticalmenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsverticalmenu = XX AND mr.`active` = XX
18 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
17 queries	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
17 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
17 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
17 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product = XX LIMIT XX
17 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
17 queries	SELECT name, value, pf.id_feature, f.position FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
17 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
15 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
11 queries	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
11 queries	SELECT smi.,smil. FROM ps_tvcmsverticalmenu_item_shop smi LEFT JOIN ps_tvcmsverticalmenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop) WHERE smi.id_column = XX AND smil.id_shop = XX AND smil.id_lang = XX AND smi.`active` = XX ORDER BY smi.position ASC, smi.id_item ASC
10 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
10 queries	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
10 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 `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_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 ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_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
9 queries	SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
9 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN ps_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 `ps_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
9 queries	SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN ps_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
9 queries	SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_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
5 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, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((pac.id_attribute=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND 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 ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((pac_XX.id_attribute=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) GROUP BY pac.id_attribute
5 queries	SELECT mc.* FROM ps_tvcmsverticalmenu_column_shop mc WHERE mc.`id_shop` = XX AND mc.id_row = XX AND mc.`active` = XX ORDER BY mc.position ASC, mc.id_column ASC
4 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
4 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `ps_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
2 queries	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_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 XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT count(id_wishlist_product) FROM ps_wishlist w, ps_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
2 queries	SELECT `active` FROM `ps_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT `name` FROM `ps_hook` WHERE `id_hook` = XX LIMIT XX
2 queries	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'sk-sk' OR `language_code` = 'sk-sk' LIMIT XX
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`

Obuv LOWA Zephyr GTX MID TF, ranger green

Obuv LOWA Zephyr GTX MID TF, ranger green

Obuv LOWA Zephyr GTX MID TF, ranger green

Obuv LOWA Zephyr GTX MID TF, ranger green

Stopwatch SQL - 2145 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Module	Time	Memory Usage
tvcmsblog	4.716 ms	0.17 Mb
__construct	4.375 ms	0.16 Mb
hookModuleRoutes	0.030 ms	0.01 Mb
hookDisplayHeader	0.305 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.006 ms	- Mb
ps_mbo	4.019 ms	0.23 Mb
__construct	3.385 ms	0.23 Mb
hookActionDispatcherBefore	0.634 ms	0.01 Mb
blockreassurance	1.450 ms	0.13 Mb
__construct	1.053 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.247 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.011 ms	- Mb
hookDisplayNavFullWidth	0.139 ms	- Mb
ps_emailsubscription	0.241 ms	0.03 Mb
__construct	0.123 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.118 ms	- Mb
ps_socialfollow	0.166 ms	0.02 Mb
__construct	0.094 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.072 ms	- Mb
ps_emailalerts	0.301 ms	0.04 Mb
__construct	0.220 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.081 ms	- Mb
ps_shoppingcart	1.706 ms	0.14 Mb
__construct	0.595 ms	0.02 Mb
hookDisplayHeader	0.124 ms	- Mb
displayNavShoppingCartBlock	0.987 ms	0.12 Mb
ps_searchbar	0.504 ms	0.02 Mb
__construct	0.117 ms	0.02 Mb
hookDisplayHeader	0.387 ms	- Mb
productcomments	0.360 ms	0.09 Mb
__construct	0.125 ms	0.09 Mb
hookDisplayHeader	0.235 ms	- Mb
ps_googleanalytics	0.750 ms	0.05 Mb
__construct	0.159 ms	0.03 Mb
hookDisplayHeader	0.591 ms	0.02 Mb
tvcmsbestsellerproducts	89.862 ms	2.45 Mb
__construct	0.279 ms	0.06 Mb
hookDisplayHeader	0.113 ms	- Mb
hookDisplayLeftColumn	89.470 ms	2.39 Mb
tvcmsblogdisplayposts	0.506 ms	0.05 Mb
__construct	0.300 ms	0.05 Mb
hookDisplayHeader	0.206 ms	- Mb
tvcmsbrandlist	0.414 ms	0.05 Mb
__construct	0.283 ms	0.05 Mb
hookDisplayHeader	0.131 ms	- Mb
tvcmscategorychainslider	0.417 ms	0.12 Mb
__construct	0.247 ms	0.11 Mb
hookDisplayHeader	0.170 ms	- Mb
tvcmscategoryslider	0.386 ms	0.05 Mb
__construct	0.197 ms	0.05 Mb
hookDisplayHeader	0.189 ms	- Mb
tvcmscookiesnotice	1.056 ms	0.06 Mb
__construct	0.191 ms	0.04 Mb
hookDisplayHeader	0.118 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.747 ms	0.01 Mb
tvcmscustomerservices	0.615 ms	0.07 Mb
__construct	0.201 ms	0.05 Mb
hookDisplayHeader	0.174 ms	- Mb
hookDisplayLeftColumn	0.240 ms	0.02 Mb
tvcmscustomsetting	4.279 ms	0.23 Mb
__construct	0.180 ms	0.04 Mb
hookDisplayHeader	0.963 ms	0.01 Mb
hookDisplayTopOfferText	0.018 ms	- Mb
hookDisplayTopOfferText	0.009 ms	- Mb
hookDisplayDownloadApps	0.014 ms	- Mb
hookDisplayCustomsocialblock	2.920 ms	0.16 Mb
hookDisplayCopyRightText	0.175 ms	0.02 Mb
tvcmsfeaturedproducts	143.841 ms	2.20 Mb
__construct	0.205 ms	0.02 Mb
hookDisplayHeader	0.115 ms	- Mb
hookDisplayLeftColumn	143.521 ms	2.17 Mb
tvcmsfooterlogo	0.169 ms	0.11 Mb
__construct	0.165 ms	0.11 Mb
hookDisplayHeader	0.004 ms	- Mb
tvcmsfooterproduct	0.291 ms	0.04 Mb
__construct	0.179 ms	0.04 Mb
hookDisplayHeader	0.112 ms	- Mb
tvcmsnewproducts	88.414 ms	2.44 Mb
__construct	0.140 ms	0.02 Mb
hookDisplayHeader	0.097 ms	- Mb
hookDisplayLeftColumn	88.177 ms	2.42 Mb
tvcmsnewsletterpopup	0.401 ms	0.05 Mb
__construct	0.151 ms	0.05 Mb
hookDisplayHeader	0.250 ms	- Mb
tvcmspaymenticon	0.848 ms	0.09 Mb
__construct	0.194 ms	0.04 Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayPaymentIcon	0.651 ms	0.04 Mb
tvcmsproductcomments	8.691 ms	0.41 Mb
__construct	0.196 ms	0.07 Mb
hookDisplayHeader	0.343 ms	- Mb
hookDisplayReviewProductList	1.882 ms	0.12 Mb
hookDisplayReviewProductList	1.064 ms	0.07 Mb
hookDisplayReviewProductList	4.051 ms	0.07 Mb
hookDisplayReviewProductList	1.155 ms	0.07 Mb
tvcmssearch	6.486 ms	0.37 Mb
__construct	0.122 ms	0.01 Mb
hookDisplayHeader	0.256 ms	- Mb
hookDisplayNavSearchBlock	6.108 ms	0.36 Mb
tvcmssizechart	0.424 ms	0.04 Mb
__construct	0.262 ms	0.03 Mb
hookDisplayHeader	0.162 ms	- Mb
tvcmsslider	0.306 ms	0.12 Mb
__construct	0.197 ms	0.11 Mb
hookDisplayHeader	0.109 ms	- Mb
tvcmsspecialproducts	1138 ms	34.47 Mb
__construct	0.140 ms	0.02 Mb
hookDisplayHeader	0.087 ms	- Mb
hookDisplayLeftColumn	1138 ms	34.45 Mb
tvcmsstockinfo	0.339 ms	0.03 Mb
__construct	0.138 ms	0.03 Mb
hookHeader	0.133 ms	- Mb
hookDisplayProductListStockIndicator	0.038 ms	- Mb
hookDisplayProductListStockIndicator	0.030 ms	- Mb
tvcmstabproducts	0.269 ms	0.01 Mb
__construct	0.122 ms	0.01 Mb
hookDisplayHeader	0.147 ms	- Mb
tvcmstestimonial	0.278 ms	0.05 Mb
__construct	0.164 ms	0.04 Mb
hookDisplayHeader	0.114 ms	- Mb
tvcmsthemeoptions	0.479 ms	0.02 Mb
__construct	0.137 ms	0.02 Mb
hookDisplayHeader	0.342 ms	- Mb
tvcmswishlist	2.938 ms	0.15 Mb
__construct	0.179 ms	0.05 Mb
hookDisplayHeader	0.163 ms	- Mb
hookDisplayNavWishlistBlock	0.920 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.281 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.194 ms	- Mb
hookDisplayWishlistBtnProductList	0.216 ms	- Mb
hookDisplayWishlistBtnProductList	0.180 ms	- Mb
hookDisplayNavWishlistBlocksticky	0.805 ms	0.05 Mb
bonrecaptcha	0.142 ms	0.02 Mb
__construct	0.126 ms	0.02 Mb
hookHeader	0.005 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.011 ms	- Mb
ecardvub	6.890 ms	0.67 Mb
__construct	5.868 ms	0.50 Mb
hookDisplayHeader	0.117 ms	- Mb
hookLeftColumn	0.905 ms	0.17 Mb
dm_cashondelivery	6.130 ms	0.03 Mb
__construct	6.113 ms	0.02 Mb
hookDisplayHeader	0.017 ms	- Mb
tvcmsinfinitescroll	2.735 ms	0.10 Mb
__construct	0.437 ms	0.06 Mb
hookHeader	2.298 ms	0.04 Mb
tvcmstwoofferbanner	0.536 ms	0.04 Mb
__construct	0.343 ms	0.03 Mb
hookHeader	0.193 ms	- Mb
tvcmscategoryproduct	0.607 ms	0.05 Mb
__construct	0.360 ms	0.05 Mb
hookHeader	0.247 ms	- Mb
tvcmsmegamenu	15.173 ms	0.81 Mb
__construct	0.364 ms	0.13 Mb
hookHeader	0.194 ms	- Mb
hookDisplayMegamenu	14.615 ms	0.68 Mb
tvcmsverticalmenu	78.840 ms	3.70 Mb
__construct	0.237 ms	0.01 Mb
hookHeader	0.259 ms	- Mb
hookDisplayNavFullWidth	78.344 ms	3.68 Mb
tvcmssliderofferbanner	0.278 ms	0.04 Mb
__construct	0.166 ms	0.03 Mb
hookHeader	0.112 ms	- Mb
ps_facetedsearch	1.055 ms	0.14 Mb
__construct	0.438 ms	0.11 Mb
hookProductSearchProvider	0.390 ms	0.01 Mb
hookDisplayFacetedSearchBlock	0.227 ms	0.02 Mb
tvcmscustomcssjs	0.418 ms	0.03 Mb
__construct	0.394 ms	0.03 Mb
hookDisplayCustomCss	0.016 ms	- Mb
hookDisplayCustomJs	0.008 ms	- Mb
ps_languageselector	1.338 ms	0.07 Mb
__construct	0.143 ms	0.02 Mb
displayNavLanguageBlock	1.195 ms	0.06 Mb
ps_currencyselector	1.267 ms	0.07 Mb
__construct	0.273 ms	0.02 Mb
displayNavCurrencyBlock	0.994 ms	0.05 Mb
ps_customersignin	1.846 ms	0.07 Mb
__construct	0.126 ms	0.02 Mb
displayNavCustomerSignInBlock	1.720 ms	0.05 Mb
ps_categorytree	10.770 ms	0.21 Mb
__construct	0.125 ms	0.02 Mb
displayLeftColumn	10.645 ms	0.20 Mb
ps_brandlist	1.702 ms	0.07 Mb
__construct	0.111 ms	0.02 Mb
displayLeftColumn	1.591 ms	0.05 Mb
ps_supplierlist	0.817 ms	0.07 Mb
__construct	0.093 ms	0.02 Mb
displayLeftColumn	0.724 ms	0.05 Mb
tvcmsfootercategory	19.235 ms	0.56 Mb
__construct	0.261 ms	0.03 Mb
hookDisplayFooterCategory	18.974 ms	0.53 Mb
ps_linklist	1.110 ms	0.15 Mb
__construct	0.284 ms	0.09 Mb
displayFooterPart1	0.826 ms	0.06 Mb
ps_customeraccountlinks	1.534 ms	0.08 Mb
__construct	0.142 ms	0.02 Mb
displayMyaccountcblock	1.392 ms	0.06 Mb
ps_contactinfo	5.207 ms	0.09 Mb
__construct	0.141 ms	0.02 Mb
displayContactCinfo	5.066 ms	0.08 Mb
statsdata	3.848 ms	0.22 Mb
__construct	0.081 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	3.767 ms	0.20 Mb
56 module(s)	1666 ms	51.86 Mb

Name	Instances	Source
Category	205	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 139] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 160] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 174] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 189] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 4] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 231] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 294] /controllers/front/listing/CategoryController.php:201 (__construct) [id: 296] /classes/Meta.php:380 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 139] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 139] /classes/Link.php:402 (__construct) [id: 160] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 160] /classes/Link.php:402 (__construct) [id: 174] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 189] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 189] /classes/Link.php:402 (__construct) [id: 4] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 296] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 296] /classes/Link.php:402 (__construct) [id: 227] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1697 (__construct) [id: 227] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 139] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 139] /classes/Link.php:402 (__construct) [id: 146] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 146] /classes/Link.php:402 (__construct) [id: 142] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 142] /classes/Link.php:402 (__construct) [id: 255] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 143] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 143] /classes/Link.php:402 (__construct) [id: 256] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 256] /classes/Link.php:402 (__construct) [id: 258] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 258] /classes/Link.php:402 (__construct) [id: 144] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 287] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 287] /classes/Link.php:402 (__construct) [id: 288] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 288] /classes/Link.php:402 (__construct) [id: 145] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 145] /classes/Link.php:402 (__construct) [id: 232] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 232] /classes/Link.php:402 (__construct) [id: 147] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 147] /classes/Link.php:402 (__construct) [id: 148] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 148] /classes/Link.php:402 (__construct) [id: 251] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 251] /classes/Link.php:402 (__construct) [id: 295] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 295] /classes/Link.php:402 (__construct) [id: 150] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 150] /classes/Link.php:402 (__construct) [id: 140] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 140] /classes/Link.php:402 (__construct) [id: 289] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 289] /classes/Link.php:402 (__construct) [id: 176] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 176] /classes/Link.php:402 (__construct) [id: 175] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 175] /classes/Link.php:402 (__construct) [id: 155] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 155] /classes/Link.php:402 (__construct) [id: 157] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 157] /classes/Link.php:402 (__construct) [id: 158] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 158] /classes/Link.php:402 (__construct) [id: 253] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 253] /classes/Link.php:402 (__construct) [id: 149] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 149] /classes/Link.php:402 (__construct) [id: 154] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 154] /classes/Link.php:402 (__construct) [id: 156] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 156] /classes/Link.php:402 (__construct) [id: 153] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 153] /classes/Link.php:402 (__construct) [id: 160] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 160] /classes/Link.php:402 (__construct) [id: 161] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 161] /classes/Link.php:402 (__construct) [id: 165] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 165] /classes/Link.php:402 (__construct) [id: 166] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 166] /classes/Link.php:402 (__construct) [id: 169] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 169] /classes/Link.php:402 (__construct) [id: 170] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 170] /classes/Link.php:402 (__construct) [id: 174] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 178] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 178] /classes/Link.php:402 (__construct) [id: 179] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 179] /classes/Link.php:402 (__construct) [id: 182] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 182] /classes/Link.php:402 (__construct) [id: 185] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 185] /classes/Link.php:402 (__construct) [id: 189] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 189] /classes/Link.php:402 (__construct) [id: 190] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 190] /classes/Link.php:402 (__construct) [id: 191] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 191] /classes/Link.php:402 (__construct) [id: 192] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 192] /classes/Link.php:402 (__construct) [id: 193] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 193] /classes/Link.php:402 (__construct) [id: 277] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 277] /classes/Link.php:402 (__construct) [id: 194] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 194] /classes/Link.php:402 (__construct) [id: 291] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 291] /classes/Link.php:402 (__construct) [id: 292] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 292] /classes/Link.php:402 (__construct) [id: 195] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 195] /classes/Link.php:402 (__construct) [id: 250] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 250] /classes/Link.php:402 (__construct) [id: 267] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 4] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 213] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 213] /classes/Link.php:402 (__construct) [id: 207] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 207] /classes/Link.php:402 (__construct) [id: 280] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 280] /classes/Link.php:402 (__construct) [id: 233] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 233] /classes/Link.php:402 (__construct) [id: 218] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 218] /classes/Link.php:402 (__construct) [id: 210] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 210] /classes/Link.php:402 (__construct) [id: 203] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 203] /classes/Link.php:402 (__construct) [id: 245] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 245] /classes/Link.php:402 (__construct) [id: 202] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 202] /classes/Link.php:402 (__construct) [id: 205] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 205] /classes/Link.php:402 (__construct) [id: 217] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 217] /classes/Link.php:402 (__construct) [id: 234] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 234] /classes/Link.php:402 (__construct) [id: 212] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 212] /classes/Link.php:402 (__construct) [id: 209] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 209] /classes/Link.php:402 (__construct) [id: 208] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 208] /classes/Link.php:402 (__construct) [id: 201] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 201] /classes/Link.php:402 (__construct) [id: 211] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 211] /classes/Link.php:402 (__construct) [id: 220] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 220] /classes/Link.php:402 (__construct) [id: 219] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 219] /classes/Link.php:402 (__construct) [id: 204] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 204] /classes/Link.php:402 (__construct) [id: 296] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 296] /classes/Link.php:402 (__construct) [id: 231] /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1705 (__construct) [id: 231] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 139] /classes/Link.php:402 (__construct) [id: 139] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 160] /classes/Link.php:402 (__construct) [id: 160] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 174] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 189] /classes/Link.php:402 (__construct) [id: 189] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 4] /classes/Link.php:402 (__construct) [id: 4] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 227] /classes/Link.php:402 (__construct) [id: 227] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 231] /classes/Link.php:402 (__construct) [id: 231] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 294] /classes/Link.php:402 (__construct) [id: 294] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 296] /classes/Link.php:402 (__construct) [id: 296]
Product	36	/classes/Link.php:113 (__construct) [id: 1629] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 1629] /classes/Link.php:113 (__construct) [id: 1629] /classes/Link.php:113 (__construct) [id: 2504] /classes/Link.php:113 (__construct) [id: 2503] /classes/Link.php:113 (__construct) [id: 2502] /classes/Link.php:113 (__construct) [id: 2501] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2504] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2503] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2502] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2501] /classes/Link.php:113 (__construct) [id: 446] /classes/Link.php:113 (__construct) [id: 591] /classes/Link.php:113 (__construct) [id: 1686] /classes/Link.php:113 (__construct) [id: 749] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 446] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 591] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 1686] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 749] /classes/Link.php:113 (__construct) [id: 158] /classes/Link.php:113 (__construct) [id: 90] /classes/Link.php:113 (__construct) [id: 188] /classes/Link.php:113 (__construct) [id: 2152] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 158] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 90] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 188] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2152] /classes/Link.php:113 (__construct) [id: 2271] /classes/Link.php:113 (__construct) [id: 1091] /classes/Link.php:113 (__construct) [id: 588] /classes/Link.php:113 (__construct) [id: 593] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2271] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 1091] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 588] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 593] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 1629]
Combination	9	/classes/Product.php:5743 (__construct) [id: 12630] /classes/Product.php:5743 (__construct) [id: 13068] /classes/Product.php:5743 (__construct) [id: 13046] /classes/Product.php:5743 (__construct) [id: 13032] /classes/Product.php:5743 (__construct) [id: 13020] /classes/Product.php:5743 (__construct) [id: 2163] /classes/Product.php:5743 (__construct) [id: 838] /classes/Product.php:5743 (__construct) [id: 11198] /classes/Product.php:5743 (__construct) [id: 9749]
Country	6	/config/config.inc.php:146 (__construct) [id: 37] /classes/controller/FrontController.php:345 (__construct) [id: 37] /classes/AddressFormat.php:404 (__construct) [id: 37] /classes/controller/FrontController.php:1652 (__construct) [id: 37] /classes/AddressFormat.php:404 (__construct) [id: 37] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 37]
Address	4	/classes/shop/Shop.php:479 (__construct) [id: ] /classes/Product.php:3622 (initialize) [id: ] /classes/Product.php:3730 (__construct) [id: ] /classes/Product.php:5797 (__construct) [id: ]
CMS	3	/classes/Link.php:551 (__construct) [id: 14] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1706 (__construct) [id: 14] /classes/Link.php:551 (__construct) [id: 3]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:577 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:700 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:414 (__construct) [id: ] /classes/controller/FrontController.php:484 (__construct) [id: ]
AddressFormat	2	/classes/controller/FrontController.php:1646 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
State	2	/classes/controller/FrontController.php:1651 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 30] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 30]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
TvcmsVerticalMenuClass	1	/modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1410 (__construct) [id: ]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1382 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1579 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1576 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:554 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
93	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (406, 748))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=245 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((a.id_attribute_group=4)) AND ((pac_1.id_attribute IN (406, 748))) GROUP BY pac.id_attribute	52.690 ms	132	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
357	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-05-14 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 4	49.573 ms	1077	Yes		/classes/Category.php:1035 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
524	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2024-05-14 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE product_shop.`active` = 1 AND product_shop.`show_price` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN (1419, 653, 986, 764, 1713, 1819, 1091, 1813, 1826, 2154, 2157, 2158, 2161, 2475, 119, 149, 150, 165, 28, 158, 174, 175, 176, 177, 179, 187, 188, 189, 190, 192, 196, 345, 346, 369, 398, 414, 415, 416, 422, 423, 426, 427, 431, 436, 437, 439, 444, 445, 488, 540, 557, 576, 607, 613, 622, 625, 626, 632, 643, 648, 697, 711, 724, 803, 808, 804, 807, 811, 812, 813, 824, 826, 841, 844, 845, 851, 854, 855, 927, 929, 959, 985, 987, 992, 994, 995, 996, 1017, 1039, 1040, 1055, 1062, 1065, 1089, 1090, 1092, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1117, 1121, 1126, 1130, 1131, 1145, 1147, 1148, 1151, 1152, 1161, 1166, 1179, 1182, 1197, 1200, 1201, 1202, 1219, 1235, 1256, 1257, 1310, 1312, 1372, 1373, 397, 1382, 1383, 1384, 173, 352, 1420, 1421, 1422, 1423, 1424, 1429, 1431, 1434, 146, 1478, 1381, 884, 1480, 1203, 1209, 90, 124, 183, 265, 1115, 194, 193, 118, 1487, 216, 1491, 372, 409, 1492, 1493, 1494, 1496, 1498, 1501, 1504, 1505, 1503, 1502, 1508, 1509, 1510, 1511, 1512, 1518, 1523, 1524, 1525, 1527, 1495, 1531, 1533, 1540, 1499, 1500, 1532, 1542, 1507, 1516, 1517, 1522, 867, 1550, 1553, 1554, 1555, 1557, 1560, 1561, 1695, 1701, 1702, 1698, 1546, 1521, 1706, 1707, 1708, 1710, 1717, 1788, 1789, 1809, 1810, 1816, 1817, 541, 59, 1976, 1998, 1997, 2062, 2065, 2072, 2073, 2074, 2102, 2130, 2131, 2142, 2152, 2269, 2271, 2335, 2336, 2337, 2338, 2339, 2340, 2421, 2474, 1912, 1911, 298, 128, 2455, 2462, 2460, 2459, 2458, 2457, 1207, 1057, 1195, 970, 417, 182, 181, 178, 167, 1477, 377, 301, 299, 17, 328, 323, 302, 139, 91, 82, 81, 63, 61, 738, 96, 102, 834, 406, 140, 304, 1136, 775, 774, 1000, 655, 657, 982, 999, 1005, 1012, 252, 74, 1484, 284, 76, 75, 73, 70, 69, 68, 18, 72, 13, 752, 340, 14, 80, 86, 87, 88, 89, 704, 587, 658, 57, 58, 523, 934, 1064, 751, 1548, 47, 384, 46, 45, 44, 43, 42, 247, 245, 244, 593, 592, 591, 590, 589, 588, 948, 945, 801, 797, 239, 238, 236, 297, 468, 308, 339, 21, 1022, 798, 126, 40, 36, 37, 756, 1008, 1007, 663, 24, 805, 767, 32, 27, 26, 25, 806, 749, 373, 264, 746, 784, 839, 1006, 1010, 964, 33, 172, 988, 262, 455, 454, 453, 343, 324, 303, 271, 268, 266, 270, 269, 267, 1084, 327, 260, 635, 577) AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	28.395 ms	1937988			/classes/Product.php:3324 /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
423	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 591 ORDER BY `position`	16.032 ms	2	Yes		/classes/Product.php:3476 /src/Adapter/Image/ImageRetriever.php:69 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:672 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2742 (present) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
100	SELECT SQL_NO_CACHE 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, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute=96)) AND ((pac_1.id_attribute IN (406, 748))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=245 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=7)) AND ((pac_1.id_attribute=96)) AND ((pac_2.id_attribute IN (406, 748))) GROUP BY fp.id_feature_value	15.318 ms	8	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1626	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1010 ORDER BY `id_specific_price_priority` DESC LIMIT 1	13.995 ms	1			/classes/SpecificPrice.php:259 /classes/SpecificPrice.php:239 (getPriority) /classes/SpecificPrice.php:565 (_getScoreQuery) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute=96)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=245 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((a.id_attribute_group=5)) AND ((pac_1.id_attribute=96)) GROUP BY pac.id_attribute	13.971 ms	72	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	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 `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_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 ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 6 ORDER BY agl.`name` ASC, a.`position` ASC	13.947 ms	8	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
349	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2024-05-14 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product = 2502 LIMIT 1	13.521 ms	8			/classes/ProductAssembler.php:106 /classes/ProductAssembler.php:125 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2796 (assembleProduct) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1586	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 992 AND id_shop=1 LIMIT 1	12.720 ms	1			/classes/Product.php:6704 /classes/Product.php:3851 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
875	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 176 ORDER BY `id_specific_price_priority` DESC LIMIT 1	12.551 ms	1			/classes/SpecificPrice.php:259 /classes/SpecificPrice.php:239 (getPriority) /classes/SpecificPrice.php:565 (_getScoreQuery) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
432	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2024-05-14 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 37 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	12.118 ms	4797			/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
113	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	11.105 ms	0			/classes/Hook.php:1231 /classes/Hook.php:218 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3851 (getManager) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/ProductAssembler.php:130 (getProductProperties) /classes/controller/ProductListingFrontController.php:80 (assembleProduct) :undefined (prepareProductForTemplate) /classes/controller/ProductListingFrontController.php:102 (array_map) /classes/controller/ProductListingFrontController.php:357 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1496	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 839 LIMIT 1	10.475 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1780	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 1480 AND id_shop=1 LIMIT 1	10.012 ms	1			/classes/Product.php:6704 /classes/Product.php:3851 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1478	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 813 LIMIT 1	9.508 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
274	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-05-14 00:00:00", INTERVAL 1000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2024-05-14 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 4	9.443 ms	4797			/classes/Product.php:3041 /modules/tvcmstabproducts/tvcmstabproducts.php:2761 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
418	SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 2 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1	9.189 ms	1077			/classes/Category.php:964 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:106 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
422	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2024-05-14 00:00:00', INTERVAL 1000 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product = 591 LIMIT 1	9.000 ms	1			/classes/ProductAssembler.php:106 /classes/ProductAssembler.php:125 (addMissingProductFields) /modules/tvcmstabproducts/tvcmstabproducts.php:2741 (assembleProduct) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2053	SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1091) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1	8.863 ms	1			/classes/stock/StockAvailable.php:452 /classes/Product.php:4235 (getQuantityAvailableByProduct) /classes/Product.php:5642 (getQuantity) /classes/Product.php:5823 (getProductProperties) /classes/Product.php:3335 (getProductsProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2109	SELECT SQL_NO_CACHE * FROM `ps_category_lang` WHERE `id_category` = 139 AND `id_shop` = 1	8.229 ms	2			/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:276 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) /modules/tvcmsfootercategory/tvcmsfootercategory.php:443 (getFooterCategoryResult) /classes/Hook.php:983 (hookdisplayFooterCategory) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/76/0f/f4/760ff47d780e186816e0990346fd414ecc1f0f28_2.file.footer-5.tpl.php:54 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/76/0f/f4/760ff47d780e186816e0990346fd414ecc1f0f28_2.file.footer-5.tpl.php:33 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654577a253_46032884) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/65/45/60/6545608b60e74da8d183d988e2ae18e69449a8e8_2.file.footer.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654576ba11_69524654) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:280 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:85 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1251	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 541 LIMIT 1	7.593 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
376	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-05-14 00:00:00' AND '2024-05-14 23:59:59' LIMIT 1	7.573 ms	1			/classes/SpecificPrice.php:377 /classes/SpecificPrice.php:548 (computeExtraConditions) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Product.php:5537 (getPriceStatic) /classes/Product.php:5823 (getProductProperties) /classes/Category.php:1047 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tvcmstabproducts/tvcmstabproducts.php:2708 (runQuery) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:158 (displayFeaturedProducts) /modules/tvcmsfeaturedproducts/tvcmsfeaturedproducts.php:281 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
273	SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 2 AND nright <= 245 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (1) ) ORDER BY `level_depth` ASC, cs.`position` ASC	7.507 ms	123	Yes		/modules/ps_categorytree/ps_categorytree.php:166 /modules/ps_categorytree/ps_categorytree.php:350 (getCategories) /modules/ps_categorytree/ps_categorytree.php:330 (getWidgetVariables) /classes/Hook.php:994 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:938 (coreRenderWidget) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	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 `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_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 ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC	7.368 ms	609	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` INNER JOIN `ps_module_shop` `mshop` ON mshop.`id_module` = m.`id_module` LEFT JOIN `ps_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`	7.307 ms	208	Yes	Yes	/classes/Hook.php:1172 /classes/Hook.php:689 (getAllHookRegistrations) /classes/Hook.php:793 (getHookModuleExecList) /classes/Dispatcher.php:586 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
2086	SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `ps_product_attribute_combination` pac LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pac.id_product_attribute IN (12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12630,12699,12998) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute	7.135 ms	26			/classes/Product.php:2683 /src/Adapter/Presenter/Product/ProductLazyArray.php:651 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:500 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getFlags) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/a0/8a/af/a08aafc0220f5ee0f6c706cc17bd31877efaa889_2.file.product-grid-view.tpl.php:55 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/a0/8a/af/a08aafc0220f5ee0f6c706cc17bd31877efaa889_2.file.product-grid-view.tpl.php:157 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/a0/8a/af/a08aafc0220f5ee0f6c706cc17bd31877efaa889_2.file.product-grid-view.tpl.php:30 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436545516257_87177622) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/b6/3b/40/b63b404abfcd0fddd8d9b5d3e944c8f3a5ef542e_2.file.product.tpl.php:50 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/b6/3b/40/b63b404abfcd0fddd8d9b5d3e944c8f3a5ef542e_2.file.product.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365454c6b26_35061931) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/6f/3c/6b/6f3c6b3796d3122da3acf96a7088a0000be04eba_2.file.products.tpl.php:50 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/6f/3c/6b/6f3c6b3796d3122da3acf96a7088a0000be04eba_2.file.products.tpl.php:34 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365454b66b8_03281987) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:78 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:133 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:76 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1782	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1484 LIMIT 1	7.062 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1281	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 588)	6.846 ms	1			/classes/Product.php:3786 /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
671	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 61 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	6.689 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1611	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 1006 AND id_shop=1 LIMIT 1	6.471 ms	1			/classes/Product.php:6704 /classes/Product.php:3851 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
830	SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 140 AND `id_group` = 1 LIMIT 1	6.367 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3916 (getValueForProduct) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1597	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 1000 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	6.353 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
73	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 `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_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 ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 4 ORDER BY agl.`name` ASC, a.`position` ASC	6.048 ms	609	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:96 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:335 (runQuery) /classes/controller/ProductListingFrontController.php:613 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:137 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1388	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 746 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	5.951 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
933	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 244 AND id_shop=1 LIMIT 1	5.849 ms	1			/classes/Product.php:6704 /classes/Product.php:3851 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1734	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 1195 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	5.751 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
767	SELECT SQL_NO_CACHE *, ( IF (`id_shop` = 1, 2, 0) + IF (`id_country` = 37, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_group` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 37) AND `id_group` IN (0, 1) AND `id_product` = 89 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-05-14 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	5.724 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3753 (getSpecificPrice) /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
798	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 119)	5.663 ms	3			/classes/Product.php:3786 /classes/Product.php:3643 (priceCalculation) /classes/Tools.php:1721 (getPriceStatic) /classes/Product.php:3331 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2815 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:983 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:409 (coreCallHook) /classes/Hook.php:918 (callHookOn) /config/smarty.config.inc.php:187 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:192 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/27/99/02/279902a48bb54d9e0fd1248f39b298c259dab40f_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_664365443bb737_19013300) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/f8/02/26/f802269b029a72cfa62c0b63519c60337e29d845_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654439bd53_11506784) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/5c/fa/c7/5cfac7eca23882373dbb6939fc033860352125ed_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544394878_83127658) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/v1_sport_61layouts_layout_left_column_tpl/97/40/d9/9740d9bf5a927a959d0c531b0625e54784a41e20_2.file.category.tpl.php:31 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654437fd61_63459851) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:701 (fetch) /classes/controller/FrontController.php:683 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	5.615 ms	903			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:309 (get) /classes/shop/Shop.php:394 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)

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

Nákupný košík

Obuv LOWA Zephyr GTX MID TF, ranger green

Obuv LOWA Zephyr GTX MID TF, ranger green

Obuv LOWA Zephyr GTX MID TF, ranger green

Obuv LOWA Zephyr GTX MID TF, ranger green