Poľovníci, rybári

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

0/5

Zimná obuv BEAR-MAN snehule + Akcia

87,92 €-20%109,90 €

0/5

Zimná obuv BEAR-MAN snehule + Akcia

87,92 €109,90 €-20%vypnuté

Zimná obuv BEAR-MAN snehule + Akcia

Vysoká

Kvalitná zimná kožená obuv so špeciálnymi termoreflexnými vložkami je určená pre použitie v podmienkach s mínusovými teplotami, ale i do mokrého a blatistého jesenného a zimného terénu.

0/5

87,92 €109,90 €-20%vypnuté

Zimná obuv BEAR-MAN snehule + Akcia

Vysoká

0/5

87,92 €109,90 €-20%vypnuté

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	1027 ms
Querying Time	783 ms
Queries	2202
Memory Peak Usage	62.5 Mb
Included Files	938 files - 11.95 Mb
PrestaShop Cache	- Mb
Global vars	0.38 Mb
- global $_MODULES	182k
- global $context	176k
- global $_SERVER	14k
- global $_ENV	8k
- global $exportPhpConfigFile	4k
- global $__composer_autoload_files	3k
- global $config	3k
- global $_COOKIE	1k

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	4.799 ms	4.799 ms	3.82 Mb	4.1 Mb
__construct	0.017 ms	4.816 ms	- Mb	4.1 Mb
init	13.091 ms	17.907 ms	1.44 Mb	5.8 Mb
checkAccess	0.002 ms	17.909 ms	- Mb	5.8 Mb
setMedia	2.038 ms	19.947 ms	0.23 Mb	5.8 Mb
postProcess	0.002 ms	19.949 ms	- Mb	5.8 Mb
initHeader	0.000 ms	19.949 ms	- Mb	5.8 Mb
initContent	157.641 ms	177.590 ms	5.56 Mb	11.1 Mb
initFooter	0.002 ms	177.592 ms	- Mb	11.1 Mb
display	849 ms	1027 ms	51.11 Mb	62.5 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	737.554 ms	41.74 Mb
=> tvcmsnewproducts	41.362 ms	2.45 Mb
=> tvcmscustomerservices	0.145 ms	0.02 Mb
=> tvcmsfeaturedproducts	69.045 ms	2.39 Mb
=> tvcmsbestsellerproducts	44.916 ms	2.38 Mb
=> tvcmsspecialproducts	582.086 ms	34.50 Mb
DisplayNavFullWidth	44.969 ms	3.72 Mb
=> blockreassurance	0.005 ms	- Mb
=> tvcmsverticalmenu	44.964 ms	3.72 Mb
DisplayMegamenu	12.614 ms	0.89 Mb
=> tvcmsmegamenu	12.614 ms	0.89 Mb
DisplayFooterCategory	6.400 ms	0.55 Mb
=> tvcmsfootercategory	6.400 ms	0.55 Mb
DisplayReviewProductList	6.195 ms	0.64 Mb
=> tvcmsproductcomments	1.088 ms	0.12 Mb
=> tvcmsproductcomments	0.685 ms	0.07 Mb
=> tvcmsproductcomments	0.613 ms	0.07 Mb
=> tvcmsproductcomments	0.666 ms	0.07 Mb
=> tvcmsproductcomments	1.023 ms	0.11 Mb
=> tvcmsproductcomments	0.783 ms	0.07 Mb
=> tvcmsproductcomments	0.637 ms	0.07 Mb
=> tvcmsproductcomments	0.700 ms	0.06 Mb
displayLeftColumn	3.897 ms	0.16 Mb
=> ps_categorytree (widget)	1.338 ms	0.06 Mb
=> ps_brandlist (widget)	0.945 ms	0.05 Mb
=> ps_supplierlist (widget)	1.614 ms	0.05 Mb
DisplayNavSearchBlock	3.329 ms	0.39 Mb
=> tvcmssearch	3.329 ms	0.39 Mb
DisplayHeader	3.120 ms	0.08 Mb
=> ps_shoppingcart	0.061 ms	- Mb
=> ps_searchbar	0.134 ms	- Mb
=> productcomments	0.077 ms	- Mb
=> ps_googleanalytics	0.299 ms	0.02 Mb
=> tvcmsbestsellerproducts	0.061 ms	- Mb
=> tvcmsblog	0.121 ms	- Mb
=> tvcmsblogdisplayposts	0.074 ms	- Mb
=> tvcmsbrandlist	0.057 ms	- Mb
=> tvcmscategorychainslider	0.092 ms	- Mb
=> tvcmscategoryslider	0.103 ms	- Mb
=> tvcmscookiesnotice	0.106 ms	- Mb
=> tvcmscustomerservices	0.091 ms	- Mb
=> tvcmscustomsetting	0.581 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.052 ms	- Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.049 ms	- Mb
=> tvcmsnewproducts	0.042 ms	- Mb
=> tvcmsnewsletterpopup	0.111 ms	- Mb
=> tvcmspaymenticon	0.002 ms	- Mb
=> tvcmsproductcomments	0.192 ms	- Mb
=> tvcmssearch	0.141 ms	- Mb
=> tvcmssizechart	0.059 ms	- Mb
=> tvcmsslider	0.068 ms	- Mb
=> tvcmsspecialproducts	0.052 ms	- Mb
=> tvcmstabproducts	0.082 ms	- Mb
=> tvcmstestimonial	0.060 ms	- Mb
=> tvcmsthemeoptions	0.186 ms	- Mb
=> tvcmswishlist	0.090 ms	- Mb
=> ecardvub	0.065 ms	- Mb
=> dm_cashondelivery	0.011 ms	- Mb
DisplayProductListStockIndicator	2.812 ms	0.20 Mb
=> tvcmsstockinfo	1.387 ms	0.06 Mb
=> tvcmsstockinfo	0.505 ms	0.05 Mb
=> tvcmsstockinfo	0.423 ms	0.05 Mb
=> tvcmsstockinfo	0.497 ms	0.05 Mb
Header	2.403 ms	0.05 Mb
=> tvcmsstockinfo	0.074 ms	- Mb
=> bonrecaptcha	0.002 ms	- Mb
=> tvcmsinfinitescroll	1.729 ms	0.04 Mb
=> tvcmstwoofferbanner	0.085 ms	- Mb
=> tvcmscategoryproduct	0.139 ms	- Mb
=> tvcmsmegamenu	0.094 ms	- Mb
=> tvcmsverticalmenu	0.177 ms	- Mb
=> tvcmssliderofferbanner	0.103 ms	- Mb
DisplayCustomsocialblock	1.905 ms	0.16 Mb
=> tvcmscustomsetting	1.905 ms	0.16 Mb
DisplayWishlistBtnProductList	1.457 ms	- Mb
=> tvcmswishlist	0.226 ms	0.01 Mb
=> tvcmswishlist	0.140 ms	- Mb
=> tvcmswishlist	0.201 ms	- Mb
=> tvcmswishlist	0.123 ms	- Mb
=> tvcmswishlist	0.268 ms	- Mb
=> tvcmswishlist	0.137 ms	- Mb
=> tvcmswishlist	0.182 ms	- Mb
=> tvcmswishlist	0.180 ms	- Mb
DisplayBeforeBodyClosingTag	1.228 ms	0.07 Mb
=> statsdata	1.217 ms	0.06 Mb
=> tvcmsblog	0.003 ms	- Mb
=> bonrecaptcha	0.008 ms	- Mb
displayNavLanguageBlock	1.174 ms	0.05 Mb
=> ps_languageselector (widget)	1.174 ms	0.05 Mb
DisplayPaymentIcon	0.932 ms	0.04 Mb
=> tvcmspaymenticon	0.932 ms	0.04 Mb
displayContactCinfo	0.927 ms	0.14 Mb
=> ps_contactinfo (widget)	0.927 ms	0.14 Mb
displayFooterPart1	0.747 ms	0.06 Mb
=> ps_linklist (widget)	0.747 ms	0.06 Mb
displayMyaccountcblock	0.682 ms	0.08 Mb
=> ps_customeraccountlinks (widget)	0.682 ms	0.08 Mb
displayNavShoppingCartBlock	0.681 ms	0.05 Mb
=> ps_shoppingcart (widget)	0.681 ms	0.05 Mb
DisplayNavWishlistBlocksticky	0.665 ms	0.05 Mb
=> tvcmswishlist	0.665 ms	0.05 Mb
LeftColumn	0.662 ms	0.16 Mb
=> ecardvub	0.662 ms	0.16 Mb
displayNavCustomerSignInBlock	0.653 ms	0.05 Mb
=> ps_customersignin (widget)	0.653 ms	0.05 Mb
DisplayNavWishlistBlock	0.605 ms	0.04 Mb
=> tvcmswishlist	0.605 ms	0.04 Mb
displayNavCurrencyBlock	0.390 ms	0.05 Mb
=> ps_currencyselector (widget)	0.390 ms	0.05 Mb
ActionFrontControllerSetMedia	0.371 ms	0.01 Mb
=> blockreassurance	0.199 ms	0.01 Mb
=> ps_emailsubscription	0.074 ms	- Mb
=> ps_socialfollow	0.044 ms	- Mb
=> ps_emailalerts	0.054 ms	- Mb
ActionDispatcherBefore	0.368 ms	0.01 Mb
=> ps_mbo	0.368 ms	0.01 Mb
ProductSearchProvider	0.262 ms	0.01 Mb
=> ps_facetedsearch	0.262 ms	0.01 Mb
DisplayAfterBodyOpeningTag	0.212 ms	0.01 Mb
=> tvcmscookiesnotice	0.208 ms	0.01 Mb
=> blockreassurance	0.004 ms	- Mb
DisplayCopyRightText	0.170 ms	0.01 Mb
=> tvcmscustomsetting	0.170 ms	0.01 Mb
DisplayFacetedSearchBlock	0.139 ms	0.04 Mb
=> ps_facetedsearch	0.139 ms	0.04 Mb
ModuleRoutes	0.016 ms	0.01 Mb
=> tvcmsblog	0.016 ms	0.01 Mb
DisplayTopOfferText	0.014 ms	- Mb
=> tvcmscustomsetting	0.010 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayDownloadApps	0.009 ms	- Mb
=> tvcmscustomsetting	0.009 ms	- Mb
DisplayCustomCss	0.009 ms	- Mb
=> tvcmscustomcssjs	0.009 ms	- Mb
DisplayCustomJs	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
35 hook(s)	838 ms	49.54 Mb

258 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
257 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)
257 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
257 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT 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
45 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
30 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 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
18 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
18 queries	SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
18 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
18 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
18 queries	SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = XX
18 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`
18 queries	SELECT mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
15 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
15 queries	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
12 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
12 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
12 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
12 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
11 queries	SELECT * FROM `ps_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
11 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
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
9 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
8 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
8 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
6 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) WHERE ((pac.id_attribute IN (XX, 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) WHERE ((a.id_attribute_group=XX)) AND ((pac_XX.id_attribute IN (XX, 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 count(pa.`id_product_attribute`) as `total` from `ps_product_attribute` pa inner join `ps_product_attribute_shop` pas on pa.id_product_attribute = pas.id_product_attribute where pas.`id_shop` = XX and pa.`id_product` = 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
3 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) AND il.`id_lang` = XX ORDER by i.`position`
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 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`
2 queries	SELECT `name` FROM `ps_hook` WHERE `id_hook` = XX LIMIT XX
2 queries	SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = XX LIMIT XX
2 queries	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
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 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 pa., product_attribute_shop. 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 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
2 queries	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = 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) AND il.`id_lang` = XX ORDER by i.`position`
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_tvcmsproduct_comment`) AS "nbr" FROM `ps_tvcmsproduct_comment` pc WHERE `id_product` = XX AND `validate` = 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 `active` FROM `ps_module` WHERE `name` = "ps_mbo" LIMIT XX
2 queries	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
2 queries	SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX

Zimná obuv BEAR-MAN snehule + Akcia

Zimná obuv BEAR-MAN snehule + Akcia

Zimná obuv BEAR-MAN snehule + Akcia

Zimná obuv BEAR-MAN snehule + Akcia

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 - 2202 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Module	Time	Memory Usage
tvcmsblog	1.974 ms	0.17 Mb
__construct	1.827 ms	0.16 Mb
hookModuleRoutes	0.019 ms	0.01 Mb
hookDisplayHeader	0.123 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.005 ms	- Mb
ps_mbo	2.681 ms	0.23 Mb
__construct	2.309 ms	0.23 Mb
hookActionDispatcherBefore	0.372 ms	0.01 Mb
blockreassurance	0.975 ms	0.13 Mb
__construct	0.760 ms	0.12 Mb
hookActionFrontControllerSetMedia	0.202 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.005 ms	- Mb
hookDisplayNavFullWidth	0.008 ms	- Mb
ps_emailsubscription	0.151 ms	0.03 Mb
__construct	0.075 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.076 ms	- Mb
ps_socialfollow	0.138 ms	0.02 Mb
__construct	0.092 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.046 ms	- Mb
ps_emailalerts	0.199 ms	0.04 Mb
__construct	0.143 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.056 ms	- Mb
ps_shoppingcart	0.876 ms	0.07 Mb
__construct	0.126 ms	0.02 Mb
hookDisplayHeader	0.065 ms	- Mb
displayNavShoppingCartBlock	0.685 ms	0.05 Mb
ps_searchbar	0.203 ms	0.02 Mb
__construct	0.067 ms	0.02 Mb
hookDisplayHeader	0.136 ms	- Mb
productcomments	0.141 ms	0.09 Mb
__construct	0.062 ms	0.09 Mb
hookDisplayHeader	0.079 ms	- Mb
ps_googleanalytics	0.392 ms	0.05 Mb
__construct	0.091 ms	0.03 Mb
hookDisplayHeader	0.301 ms	0.02 Mb
tvcmsbestsellerproducts	45.148 ms	2.44 Mb
__construct	0.166 ms	0.06 Mb
hookDisplayHeader	0.063 ms	- Mb
hookDisplayLeftColumn	44.919 ms	2.38 Mb
tvcmsblogdisplayposts	0.178 ms	0.05 Mb
__construct	0.103 ms	0.05 Mb
hookDisplayHeader	0.075 ms	- Mb
tvcmsbrandlist	0.159 ms	0.05 Mb
__construct	0.101 ms	0.05 Mb
hookDisplayHeader	0.058 ms	- Mb
tvcmscategorychainslider	0.199 ms	0.12 Mb
__construct	0.104 ms	0.11 Mb
hookDisplayHeader	0.095 ms	- Mb
tvcmscategoryslider	0.263 ms	0.05 Mb
__construct	0.157 ms	0.05 Mb
hookDisplayHeader	0.106 ms	- Mb
tvcmscookiesnotice	0.441 ms	0.06 Mb
__construct	0.123 ms	0.04 Mb
hookDisplayHeader	0.108 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.210 ms	0.01 Mb
tvcmscustomerservices	0.385 ms	0.07 Mb
__construct	0.145 ms	0.05 Mb
hookDisplayHeader	0.093 ms	- Mb
hookDisplayLeftColumn	0.147 ms	0.02 Mb
tvcmscustomsetting	2.835 ms	0.23 Mb
__construct	0.142 ms	0.04 Mb
hookDisplayHeader	0.584 ms	0.01 Mb
hookDisplayTopOfferText	0.013 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayDownloadApps	0.011 ms	- Mb
hookDisplayCustomsocialblock	1.907 ms	0.16 Mb
hookDisplayCopyRightText	0.172 ms	0.02 Mb
tvcmsfeaturedproducts	69.239 ms	2.41 Mb
__construct	0.136 ms	0.02 Mb
hookDisplayHeader	0.054 ms	- Mb
hookDisplayLeftColumn	69.049 ms	2.39 Mb
tvcmsfooterlogo	0.152 ms	0.11 Mb
__construct	0.149 ms	0.11 Mb
hookDisplayHeader	0.003 ms	- Mb
tvcmsfooterproduct	0.186 ms	0.04 Mb
__construct	0.134 ms	0.04 Mb
hookDisplayHeader	0.052 ms	- Mb
tvcmsnewproducts	41.504 ms	2.48 Mb
__construct	0.094 ms	0.02 Mb
hookDisplayHeader	0.044 ms	- Mb
hookDisplayLeftColumn	41.366 ms	2.45 Mb
tvcmsnewsletterpopup	0.215 ms	0.05 Mb
__construct	0.102 ms	0.05 Mb
hookDisplayHeader	0.113 ms	- Mb
tvcmspaymenticon	1.041 ms	0.09 Mb
__construct	0.103 ms	0.04 Mb
hookDisplayHeader	0.003 ms	- Mb
hookDisplayPaymentIcon	0.935 ms	0.04 Mb
tvcmsproductcomments	6.539 ms	0.72 Mb
__construct	0.127 ms	0.07 Mb
hookDisplayHeader	0.194 ms	- Mb
hookDisplayReviewProductList	1.091 ms	0.12 Mb
hookDisplayReviewProductList	0.687 ms	0.07 Mb
hookDisplayReviewProductList	0.615 ms	0.07 Mb
hookDisplayReviewProductList	0.669 ms	0.07 Mb
hookDisplayReviewProductList	1.027 ms	0.11 Mb
hookDisplayReviewProductList	0.786 ms	0.07 Mb
hookDisplayReviewProductList	0.640 ms	0.07 Mb
hookDisplayReviewProductList	0.703 ms	0.06 Mb
tvcmssearch	3.555 ms	0.41 Mb
__construct	0.078 ms	0.01 Mb
hookDisplayHeader	0.143 ms	- Mb
hookDisplayNavSearchBlock	3.334 ms	0.39 Mb
tvcmssizechart	0.167 ms	0.04 Mb
__construct	0.107 ms	0.03 Mb
hookDisplayHeader	0.060 ms	- Mb
tvcmsslider	0.192 ms	0.12 Mb
__construct	0.123 ms	0.11 Mb
hookDisplayHeader	0.069 ms	- Mb
tvcmsspecialproducts	582.229 ms	34.52 Mb
__construct	0.085 ms	0.02 Mb
hookDisplayHeader	0.053 ms	- Mb
hookDisplayLeftColumn	582.091 ms	34.50 Mb
tvcmsstockinfo	2.989 ms	0.23 Mb
__construct	0.086 ms	0.03 Mb
hookHeader	0.076 ms	- Mb
hookDisplayProductListStockIndicator	1.392 ms	0.06 Mb
hookDisplayProductListStockIndicator	0.508 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.427 ms	0.05 Mb
hookDisplayProductListStockIndicator	0.500 ms	0.05 Mb
tvcmstabproducts	0.176 ms	0.01 Mb
__construct	0.092 ms	0.01 Mb
hookDisplayHeader	0.084 ms	- Mb
tvcmstestimonial	0.171 ms	0.05 Mb
__construct	0.109 ms	0.04 Mb
hookDisplayHeader	0.062 ms	- Mb
tvcmsthemeoptions	0.280 ms	0.02 Mb
__construct	0.091 ms	0.02 Mb
hookDisplayHeader	0.189 ms	- Mb
tvcmswishlist	2.960 ms	0.15 Mb
__construct	0.109 ms	0.05 Mb
hookDisplayHeader	0.091 ms	- Mb
hookDisplayNavWishlistBlock	0.608 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.230 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.142 ms	- Mb
hookDisplayWishlistBtnProductList	0.204 ms	- Mb
hookDisplayWishlistBtnProductList	0.125 ms	- Mb
hookDisplayWishlistBtnProductList	0.273 ms	- Mb
hookDisplayWishlistBtnProductList	0.140 ms	- Mb
hookDisplayWishlistBtnProductList	0.186 ms	- Mb
hookDisplayWishlistBtnProductList	0.183 ms	- Mb
hookDisplayNavWishlistBlocksticky	0.669 ms	0.05 Mb
bonrecaptcha	0.096 ms	0.02 Mb
__construct	0.084 ms	0.02 Mb
hookHeader	0.003 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.009 ms	- Mb
ecardvub	3.720 ms	0.66 Mb
__construct	2.987 ms	0.50 Mb
hookDisplayHeader	0.068 ms	- Mb
hookLeftColumn	0.665 ms	0.17 Mb
dm_cashondelivery	2.991 ms	0.03 Mb
__construct	2.977 ms	0.02 Mb
hookDisplayHeader	0.014 ms	- Mb
tvcmsinfinitescroll	1.925 ms	0.10 Mb
__construct	0.193 ms	0.06 Mb
hookHeader	1.732 ms	0.04 Mb
tvcmstwoofferbanner	0.334 ms	0.04 Mb
__construct	0.247 ms	0.03 Mb
hookHeader	0.087 ms	- Mb
tvcmscategoryproduct	0.315 ms	0.05 Mb
__construct	0.173 ms	0.05 Mb
hookHeader	0.142 ms	- Mb
tvcmsmegamenu	12.909 ms	1.03 Mb
__construct	0.196 ms	0.13 Mb
hookHeader	0.095 ms	- Mb
hookDisplayMegamenu	12.618 ms	0.90 Mb
tvcmsverticalmenu	45.376 ms	3.73 Mb
__construct	0.228 ms	0.01 Mb
hookHeader	0.179 ms	- Mb
hookDisplayNavFullWidth	44.969 ms	3.72 Mb
tvcmssliderofferbanner	0.264 ms	0.04 Mb
__construct	0.158 ms	0.03 Mb
hookHeader	0.106 ms	- Mb
ps_facetedsearch	0.817 ms	0.16 Mb
__construct	0.409 ms	0.11 Mb
hookProductSearchProvider	0.266 ms	0.01 Mb
hookDisplayFacetedSearchBlock	0.142 ms	0.04 Mb
tvcmscustomcssjs	0.190 ms	0.03 Mb
__construct	0.171 ms	0.03 Mb
hookDisplayCustomCss	0.011 ms	- Mb
hookDisplayCustomJs	0.008 ms	- Mb
ps_languageselector	1.319 ms	0.07 Mb
__construct	0.142 ms	0.02 Mb
displayNavLanguageBlock	1.177 ms	0.06 Mb
ps_currencyselector	0.518 ms	0.07 Mb
__construct	0.126 ms	0.02 Mb
displayNavCurrencyBlock	0.392 ms	0.05 Mb
ps_customersignin	0.717 ms	0.07 Mb
__construct	0.061 ms	0.02 Mb
displayNavCustomerSignInBlock	0.656 ms	0.05 Mb
ps_categorytree	1.426 ms	0.08 Mb
__construct	0.086 ms	0.02 Mb
displayLeftColumn	1.340 ms	0.06 Mb
ps_brandlist	1.047 ms	0.07 Mb
__construct	0.097 ms	0.02 Mb
displayLeftColumn	0.950 ms	0.05 Mb
ps_supplierlist	1.756 ms	0.07 Mb
__construct	0.138 ms	0.02 Mb
displayLeftColumn	1.618 ms	0.05 Mb
tvcmsfootercategory	6.624 ms	0.59 Mb
__construct	0.219 ms	0.03 Mb
hookDisplayFooterCategory	6.405 ms	0.55 Mb
ps_linklist	1.027 ms	0.09 Mb
__construct	0.277 ms	0.03 Mb
displayFooterPart1	0.750 ms	0.06 Mb
ps_customeraccountlinks	0.797 ms	0.09 Mb
__construct	0.112 ms	0.02 Mb
displayMyaccountcblock	0.685 ms	0.08 Mb
ps_contactinfo	1.031 ms	0.16 Mb
__construct	0.101 ms	0.02 Mb
displayContactCinfo	0.930 ms	0.14 Mb
statsdata	1.343 ms	0.08 Mb
__construct	0.121 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	1.222 ms	0.07 Mb
56 module(s)	855 ms	52.68 Mb

Name	Instances	Source
Category	198	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 224] /classes/Meta.php:380 (__construct) [id: 224] /classes/Link.php:402 (__construct) [id: 224] /classes/Link.php:402 (__construct) [id: 224] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:383 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 224] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 224] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 224] /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: 224] /classes/Link.php:402 (__construct) [id: 224] /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: 224] /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	40	/classes/Link.php:113 (__construct) [id: 417] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 417] /classes/Link.php:113 (__construct) [id: 1629] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 1629] /classes/Link.php:113 (__construct) [id: 417] /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: 1206] /classes/Link.php:113 (__construct) [id: 279] /classes/Link.php:113 (__construct) [id: 2455] /classes/Link.php:113 (__construct) [id: 261] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 1206] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 279] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 2455] /src/Adapter/Image/ImageRetriever.php:66 (__construct) [id: 261] /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: 417] /src/Adapter/Presenter/Product/ProductLazyArray.php:646 (__construct) [id: 1629]
Combination	12	/classes/Product.php:5743 (__construct) [id: 1459] /classes/Product.php:5743 (__construct) [id: 12998] /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: 1021] /classes/Product.php:5743 (__construct) [id: 12656] /classes/Product.php:5743 (__construct) [id: 12990] /classes/Product.php:5743 (__construct) [id: 838] /classes/Product.php:5743 (__construct) [id: 11198] /classes/Product.php:5743 (__construct) [id: 9749]
Country	5	/config/config.inc.php:146 (__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: ]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:654 (__construct) [id: 1] /classes/Tools.php:577 (__construct) [id: 1]
CMS	3	/classes/Link.php:551 (__construct) [id: 14] /modules/tvcmsmegamenu/tvcmsmegamenu.php:1706 (__construct) [id: 14] /classes/Link.php:551 (__construct) [id: 3]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 30] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 30]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:697 (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]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
TvcmsVerticalMenuClass	1	/modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1410 (__construct) [id: ]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1382 (__construct) [id: ]
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
387	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	28.093 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)
561	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`)	21.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)
2047	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 2458 AND id_shop=1 LIMIT 1	13.717 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)
69	SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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) WHERE ((pac.id_attribute IN (81, 90, 95)))	13.710 ms	2088			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Products.php:94 (count) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /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)
74	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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) WHERE ((pac.id_attribute IN (81, 90, 95))) GROUP BY p.id_manufacturer	12.224 ms	2088	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:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /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)
469	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	9.545 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)
83	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 ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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) WHERE ((a.id_attribute_group=4)) GROUP BY pac.id_attribute	8.040 ms	87048	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)
85	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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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 IN (81, 90, 95))) GROUP BY pac.id_attribute	7.763 ms	13456	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)
72	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (81, 90, 95))) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>226 AND c.nright<227 GROUP BY cp.id_category	7.343 ms	161472	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:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /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)
301	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	6.349 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)
453	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	5.206 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)
68	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 12	4.961 ms	26912	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:187 (getProductByFilters) /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)
938	SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 192 LIMIT 1	4.310 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)
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`)	4.298 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)
82	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	4.196 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)
64	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	3.991 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)
981	SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 247 ORDER BY `id_specific_price_priority` DESC LIMIT 1	3.813 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)
2006	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` = 2337 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	3.649 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)
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`	3.513 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)
853	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` = 128)	3.444 ms	5			/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)
287	SELECT SQL_NO_CACHE mr.* FROM ps_tvcmsverticalmenu_row_shop mr WHERE mr.`id_shop` = 1 AND mr.id_tvcmsverticalmenu = 6 AND mr.`active` = 1	3.338 ms	5			/modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1222 /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1332 (getRowInfo) /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1455 (getSubMenu) /modules/tvcmsverticalmenu/tvcmsverticalmenu.php:1367 (showVerticalMenuData) /classes/Hook.php:983 (hookdisplayNavFullWidth) /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/e3/89/e1/e389e10bd14ee3b0c0ca89894c3dfdfdd4c4f8ac_2.file.desk-header-7.tpl.php:44 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654444d798_02541317) /vendor/smarty/smarty/libs/sysplugins/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/ca/30/d3/ca30d35562d1ae399abe32217a2ef6af36cd8abf_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544441f69_21577982) /vendor/smarty/smarty/libs/sysplugins/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/0a/51/ef/0a51efa507d5d560d44af7ee82fc7533365509f7_2.file.header.tpl.php:55 (_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/0a/51/ef/0a51efa507d5d560d44af7ee82fc7533365509f7_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654443daf3_89262965) /vendor/smarty/smarty/libs/sysplugins/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:144 (_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:64 (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)
1117	SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 327 AND `id_group` = 1 LIMIT 1	3.300 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)
89	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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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=7)) AND ((pac_1.id_attribute IN (81, 90, 95))) GROUP BY pac.id_attribute	3.197 ms	1944	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)
87	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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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=6)) AND ((pac_1.id_attribute IN (81, 90, 95))) GROUP BY pac.id_attribute	2.975 ms	1728	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)
90	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) WHERE ((pac.id_attribute IN (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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) WHERE ((fp.id_feature=7)) AND ((pac_1.id_attribute IN (81, 90, 95))) GROUP BY fp.id_feature_value	2.834 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: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)
110	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	2.702 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)
75	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 37) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) 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 pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) WHERE ((pac.id_attribute IN (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227	2.472 ms	116			/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php: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)
77	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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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=1)) AND ((pac_1.id_attribute IN (81, 90, 95))) GROUP BY pac.id_attribute	2.450 ms	2088	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)
111	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.323 ms	516			/classes/Hook.php:447 /classes/Hook.php:484 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /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)
79	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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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=2)) AND ((pac_1.id_attribute IN (81, 90, 95))) GROUP BY pac.id_attribute	2.244 ms	2088	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)
81	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, 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 (81, 90, 95))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=226 AND c.nright<=227 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=3)) AND ((pac_1.id_attribute IN (81, 90, 95))) GROUP BY pac.id_attribute	2.188 ms	216	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)
84	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 = 5 ORDER BY agl.`name` ASC, a.`position` ASC	2.130 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)
1963	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` = 2157 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	2.074 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)
681	SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 46 AND `id_group` = 1 LIMIT 1	2.018 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)
1116	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 327 AND id_shop=1 LIMIT 1	1.982 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)
1623	SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 988 AND `id_group` = 1 LIMIT 1	1.929 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)
540	SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE product_shop.`active` = 1 LIMIT 1	1.843 ms	380			/classes/ProductSale.php:60 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:79 (getNbSales) /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)
2019	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` = 2339 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	1.776 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)
793	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` = 87)	1.775 ms	2			/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)
176	SELECT SQL_NO_CACHE mr.* FROM ps_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = 1 AND mr.id_tvcmsmegamenu = 8 AND mr.`active` = 1	1.720 ms	6			/modules/tvcmsmegamenu/tvcmsmegamenu.php:1200 /modules/tvcmsmegamenu/tvcmsmegamenu.php:1325 (getRowInfo) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1426 (getSubMenu) /modules/tvcmsmegamenu/tvcmsmegamenu.php:1360 (getWidgetVariables) /classes/Hook.php:983 (hookdisplayMegamenu) /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/e3/89/e1/e389e10bd14ee3b0c0ca89894c3dfdfdd4c4f8ac_2.file.desk-header-7.tpl.php:29 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654444d798_02541317) /vendor/smarty/smarty/libs/sysplugins/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/ca/30/d3/ca30d35562d1ae399abe32217a2ef6af36cd8abf_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_66436544441f69_21577982) /vendor/smarty/smarty/libs/sysplugins/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/0a/51/ef/0a51efa507d5d560d44af7ee82fc7533365509f7_2.file.header.tpl.php:55 (_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/0a/51/ef/0a51efa507d5d560d44af7ee82fc7533365509f7_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6643654443daf3_89262965) /vendor/smarty/smarty/libs/sysplugins/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:144 (_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:64 (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)

#	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

Zimná obuv BEAR-MAN snehule + Akcia

Zimná obuv BEAR-MAN snehule + Akcia

Zimná obuv BEAR-MAN snehule + Akcia

Zimná obuv BEAR-MAN snehule + Akcia

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