Smartphone & Mobile

SMARTPHONE VIVO Y1S 2G 32G BLEU

399,000 TND

SMARTPHONE VIVO Y1S 2G 32G BLEU

399,000 TND

SMARTPHONE VIVO Y1S 2G 32G BLEU

Smartphones

Ecran : 6,22" Full-incell (720 × 1520 Pixels) Processeur : MT6765 Octa-core Mémoire RAM : 2Go Stockage : 32Go Appareil Photo Arrière : 13 MP Appareil Photo Avant : 5 MP Batterie : 4030 mAh, Li-polymère Couleur...

399,000 TND

Aperçu rapide

SMARTPHONE VIVO Y1S 2G 32G BLEU

Smartphones

399,000 TND

Aperçu rapide

Load Time	747.159 ms
Querying Time	599 ms
Queries	913
Memory Peak Usage	30.2 Mb
Included Files	772 files - 9.43 Mb
PrestaShop Cache	- Mb
Global vars	0.12 Mb
- global $_MODULES	86k
- global $_MODULE	11k
- global $_SERVER	6k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k

PrestaShop Version	8.1.4
PHP Version	8.1.32
MySQL Version	10.11.11-MariaDB-0+deb12u1
Memory Limit	256M
Max Execution Time	300s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	0.005 ms	0.005 ms	1.92 Mb	2.0 Mb
__construct	0.457 ms	0.462 ms	0.07 Mb	2.5 Mb
init	9.041 ms	9.503 ms	0.51 Mb	2.9 Mb
checkAccess	0.001 ms	9.504 ms	- Mb	2.9 Mb
setMedia	2.505 ms	12.009 ms	0.23 Mb	2.9 Mb
postProcess	0.001 ms	12.010 ms	- Mb	2.9 Mb
initHeader	0.001 ms	12.011 ms	- Mb	2.9 Mb
initContent	153.599 ms	165.610 ms	3.79 Mb	6.8 Mb
initFooter	0.002 ms	165.612 ms	- Mb	6.8 Mb
display	581.547 ms	747.159 ms	23.22 Mb	30.2 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	290.774 ms	5.33 Mb
=> tvcmsnewproducts	112.576 ms	1.90 Mb
=> tvcmsfeaturedproducts	152.703 ms	1.78 Mb
=> tvcmsbestsellerproducts	25.495 ms	1.65 Mb
DisplayNavFullWidth	252.858 ms	15.36 Mb
=> ets_megamenu	252.858 ms	15.36 Mb
DisplayHeader	6.142 ms	1.22 Mb
=> ps_shoppingcart	0.036 ms	- Mb
=> ps_searchbar	0.179 ms	- Mb
=> ps_googleanalytics	0.013 ms	- Mb
=> tvcmsbestsellerproducts	0.071 ms	- Mb
=> tvcmscategoryslider	0.084 ms	- Mb
=> tvcmscustomsetting	0.332 ms	0.01 Mb
=> tvcmsfeaturedproducts	0.038 ms	- Mb
=> tvcmsmultibanner1	0.074 ms	- Mb
=> tvcmsnewproducts	0.062 ms	- Mb
=> tvcmsproductcomments	0.200 ms	- Mb
=> tvcmsproductcompare	0.060 ms	- Mb
=> tvcmssearch	0.146 ms	- Mb
=> tvcmsslider	0.132 ms	- Mb
=> tvcmsthemeoptions	0.202 ms	- Mb
=> tvcmswishlist	0.110 ms	- Mb
=> ets_megamenu	4.403 ms	1.18 Mb
DisplayNavSearchBlock	4.172 ms	0.51 Mb
=> tvcmssearch	4.172 ms	0.51 Mb
displayNavCurrencyBlock	4.158 ms	0.08 Mb
=> ps_currencyselector (widget)	4.158 ms	0.08 Mb
DisplayReviewProductList	3.270 ms	0.33 Mb
=> tvcmsproductcomments	1.134 ms	0.12 Mb
=> tvcmsproductcomments	0.890 ms	0.07 Mb
=> tvcmsproductcomments	0.630 ms	0.07 Mb
=> tvcmsproductcomments	0.616 ms	0.07 Mb
DisplayFooterCategory	2.460 ms	0.24 Mb
=> tvcmsfootercategory	2.460 ms	0.24 Mb
displayLeftColumn	2.054 ms	0.06 Mb
=> ps_categorytree (widget)	2.054 ms	0.06 Mb
displayNav1	1.997 ms	0.08 Mb
=> ps_contactinfo (widget)	1.997 ms	0.08 Mb
DisplayBeforeBodyClosingTag	1.401 ms	0.05 Mb
=> statsdata	1.401 ms	0.05 Mb
Header	1.020 ms	0.05 Mb
=> tvcmsinfinitescroll	0.902 ms	0.04 Mb
=> tvcmsofferbanner	0.061 ms	- Mb
=> tvcmsleftsideofferbanner	0.001 ms	- Mb
=> tvcmstwoofferbanner	0.056 ms	- Mb
DisplayCustomsocialblock	0.785 ms	0.09 Mb
=> tvcmscustomsetting	0.785 ms	0.09 Mb
DisplayProductCompareProductList	0.690 ms	0.01 Mb
=> tvcmsproductcompare	0.191 ms	0.01 Mb
=> tvcmsproductcompare	0.226 ms	- Mb
=> tvcmsproductcompare	0.138 ms	- Mb
=> tvcmsproductcompare	0.135 ms	- Mb
displayNewslettersubscription	0.675 ms	0.06 Mb
=> ps_emailsubscription (widget)	0.675 ms	0.06 Mb
displayFooterPart1	0.671 ms	0.06 Mb
=> ps_linklist (widget)	0.671 ms	0.06 Mb
displayMyaccountcblock	0.626 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	0.626 ms	0.06 Mb
DisplayWishlistBtnProductList	0.574 ms	0.01 Mb
=> tvcmswishlist	0.172 ms	0.01 Mb
=> tvcmswishlist	0.142 ms	- Mb
=> tvcmswishlist	0.135 ms	- Mb
=> tvcmswishlist	0.125 ms	- Mb
displaySocialMediaBlock	0.542 ms	0.07 Mb
=> ps_socialfollow (widget)	0.542 ms	0.07 Mb
displayContactCinfo	0.537 ms	0.03 Mb
=> ps_contactinfo (widget)	0.537 ms	0.03 Mb
DisplayNavWishlistBlock	0.462 ms	0.03 Mb
=> tvcmswishlist	0.462 ms	0.03 Mb
displayNavLanguageBlock	0.339 ms	0.05 Mb
=> ps_languageselector (widget)	0.339 ms	0.05 Mb
displayNavShoppingCartBlock	0.243 ms	- Mb
=> ps_shoppingcart (widget)	0.243 ms	- Mb
ActionFrontControllerSetMedia	0.204 ms	0.01 Mb
=> ps_emailsubscription	0.115 ms	- Mb
=> ps_socialfollow	0.040 ms	- Mb
=> ps_emailalerts	0.049 ms	- Mb
ProductSearchProvider	0.178 ms	- Mb
=> ps_facetedsearch	0.178 ms	- Mb
displayNavCustomerSignInBlock	0.168 ms	- Mb
=> ps_customersignin (widget)	0.168 ms	- Mb
DisplayFacetedSearchBlock	0.166 ms	0.01 Mb
=> ps_facetedsearch	0.166 ms	0.01 Mb
DisplayCopyRightText	0.149 ms	0.01 Mb
=> tvcmscustomsetting	0.149 ms	0.01 Mb
DisplayNavProductCompareBlock	0.145 ms	0.01 Mb
=> tvcmsproductcompare	0.145 ms	0.01 Mb
DisplayTopOfferText	0.013 ms	- Mb
=> tvcmscustomsetting	0.009 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayCustomCss	0.007 ms	- Mb
=> tvcmscustomcssjs	0.007 ms	- Mb
DisplayCustomJs	0.007 ms	- Mb
=> tvcmscustomcssjs	0.007 ms	- Mb
DisplayMegamenu	0.005 ms	- Mb
=> ets_megamenu	0.005 ms	- Mb
32 hook(s)	577.491 ms	23.81 Mb

Module	Time	Memory Usage
ps_emailsubscription	1.367 ms	0.14 Mb
__construct	0.572 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.118 ms	0.01 Mb
displayNewslettersubscription	0.677 ms	0.06 Mb
ps_socialfollow	0.643 ms	0.07 Mb
__construct	0.056 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.042 ms	- Mb
displaySocialMediaBlock	0.545 ms	0.07 Mb
ps_emailalerts	0.120 ms	0.01 Mb
__construct	0.070 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.050 ms	- Mb
ps_shoppingcart	0.409 ms	0.01 Mb
__construct	0.125 ms	0.01 Mb
hookDisplayHeader	0.038 ms	- Mb
displayNavShoppingCartBlock	0.246 ms	0.01 Mb
ps_searchbar	0.234 ms	0.01 Mb
__construct	0.054 ms	0.01 Mb
hookDisplayHeader	0.180 ms	- Mb
ps_googleanalytics	0.097 ms	0.01 Mb
__construct	0.083 ms	0.01 Mb
hookDisplayHeader	0.014 ms	- Mb
tvcmsbestsellerproducts	25.737 ms	1.68 Mb
__construct	0.165 ms	0.03 Mb
hookDisplayHeader	0.073 ms	- Mb
hookDisplayLeftColumn	25.499 ms	1.65 Mb
tvcmscategoryslider	0.197 ms	0.01 Mb
__construct	0.111 ms	0.01 Mb
hookDisplayHeader	0.086 ms	- Mb
tvcmscustomsetting	1.377 ms	0.13 Mb
__construct	0.088 ms	0.01 Mb
hookDisplayHeader	0.333 ms	0.01 Mb
hookDisplayTopOfferText	0.011 ms	- Mb
hookDisplayTopOfferText	0.005 ms	- Mb
hookDisplayCustomsocialblock	0.788 ms	0.10 Mb
hookDisplayCopyRightText	0.152 ms	0.01 Mb
tvcmsfeaturedproducts	152.849 ms	1.79 Mb
__construct	0.102 ms	0.01 Mb
hookDisplayHeader	0.040 ms	- Mb
hookDisplayLeftColumn	152.707 ms	1.78 Mb
tvcmsmultibanner1	0.150 ms	0.01 Mb
__construct	0.075 ms	0.01 Mb
hookDisplayHeader	0.075 ms	- Mb
tvcmsnewproducts	112.789 ms	1.91 Mb
__construct	0.145 ms	0.01 Mb
hookDisplayHeader	0.064 ms	- Mb
hookDisplayLeftColumn	112.580 ms	1.90 Mb
tvcmsproductcomments	3.587 ms	0.36 Mb
__construct	0.104 ms	0.02 Mb
hookDisplayHeader	0.202 ms	- Mb
hookDisplayReviewProductList	1.137 ms	0.12 Mb
hookDisplayReviewProductList	0.892 ms	0.07 Mb
hookDisplayReviewProductList	0.633 ms	0.07 Mb
hookDisplayReviewProductList	0.619 ms	0.07 Mb
tvcmsproductcompare	1.001 ms	0.02 Mb
__construct	0.095 ms	- Mb
hookDisplayHeader	0.061 ms	- Mb
hookDisplayNavProductCompareBlock	0.146 ms	0.01 Mb
hookDisplayProductCompareProductList	0.194 ms	0.01 Mb
hookDisplayProductCompareProductList	0.229 ms	- Mb
hookDisplayProductCompareProductList	0.140 ms	- Mb
hookDisplayProductCompareProductList	0.137 ms	- Mb
tvcmssearch	4.446 ms	0.52 Mb
__construct	0.123 ms	0.01 Mb
hookDisplayHeader	0.148 ms	- Mb
hookDisplayNavSearchBlock	4.175 ms	0.51 Mb
tvcmsslider	0.318 ms	0.01 Mb
__construct	0.184 ms	0.01 Mb
hookDisplayHeader	0.134 ms	- Mb
tvcmsthemeoptions	0.305 ms	0.01 Mb
__construct	0.100 ms	0.01 Mb
hookDisplayHeader	0.205 ms	0.01 Mb
tvcmswishlist	1.267 ms	0.07 Mb
__construct	0.108 ms	0.02 Mb
hookDisplayHeader	0.112 ms	- Mb
hookDisplayNavWishlistBlock	0.464 ms	0.04 Mb
hookDisplayWishlistBtnProductList	0.175 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.144 ms	- Mb
hookDisplayWishlistBtnProductList	0.137 ms	- Mb
hookDisplayWishlistBtnProductList	0.127 ms	- Mb
ets_megamenu	257.390 ms	16.59 Mb
__construct	0.117 ms	0.05 Mb
hookDisplayHeader	4.405 ms	1.19 Mb
hookDisplayMegamenu	0.006 ms	- Mb
hookDisplayNavFullWidth	252.862 ms	15.36 Mb
ps_customersignin	0.229 ms	0.01 Mb
__construct	0.059 ms	0.01 Mb
displayNavCustomerSignInBlock	0.170 ms	- Mb
tvcmsinfinitescroll	1.004 ms	0.09 Mb
__construct	0.100 ms	0.05 Mb
hookHeader	0.904 ms	0.04 Mb
tvcmsofferbanner	0.158 ms	- Mb
__construct	0.095 ms	- Mb
hookHeader	0.063 ms	- Mb
tvcmsleftsideofferbanner	0.081 ms	0.01 Mb
__construct	0.079 ms	0.01 Mb
hookHeader	0.002 ms	- Mb
tvcmstwoofferbanner	0.141 ms	0.01 Mb
__construct	0.084 ms	0.01 Mb
hookHeader	0.057 ms	- Mb
ps_facetedsearch	0.499 ms	0.03 Mb
__construct	0.150 ms	0.01 Mb
hookProductSearchProvider	0.180 ms	- Mb
hookDisplayFacetedSearchBlock	0.169 ms	0.01 Mb
tvcmscustomcssjs	0.217 ms	0.01 Mb
__construct	0.198 ms	0.01 Mb
hookDisplayCustomCss	0.010 ms	- Mb
hookDisplayCustomJs	0.009 ms	- Mb
ps_languageselector	0.433 ms	0.06 Mb
__construct	0.068 ms	0.01 Mb
displayNavLanguageBlock	0.365 ms	0.05 Mb
ps_currencyselector	4.247 ms	0.08 Mb
__construct	0.086 ms	0.01 Mb
displayNavCurrencyBlock	4.161 ms	0.08 Mb
ps_contactinfo	2.610 ms	0.12 Mb
__construct	0.071 ms	0.01 Mb
displayNav1	1.999 ms	0.09 Mb
displayContactCinfo	0.540 ms	0.03 Mb
ps_categorytree	2.153 ms	0.07 Mb
__construct	0.096 ms	0.01 Mb
displayLeftColumn	2.057 ms	0.06 Mb
tvcmsfootercategory	2.661 ms	0.24 Mb
__construct	0.198 ms	0.01 Mb
hookDisplayFooterCategory	2.463 ms	0.24 Mb
ps_linklist	0.836 ms	0.07 Mb
__construct	0.162 ms	0.01 Mb
displayFooterPart1	0.674 ms	0.06 Mb
ps_customeraccountlinks	0.707 ms	0.07 Mb
__construct	0.078 ms	0.01 Mb
displayMyaccountcblock	0.629 ms	0.06 Mb
statsdata	1.480 ms	0.05 Mb
__construct	0.076 ms	0.01 Mb
hookDisplayBeforeBodyClosingTag	1.404 ms	0.05 Mb
34 module(s)	581.737 ms	24.21 Mb

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

Stopwatch SQL - 913 queries

Doubles

Tables stress

ObjectModel instances

Included Files

193 queries	SELECT * FROM `mb_category` a LEFT JOIN `mb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `mb_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
143 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY cl.name ASC,c.id_category ASC
42 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, pa.id_product_attribute, cp.position FROM mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((pac.id_attribute IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value=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 INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) LEFT JOIN mb_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((pac_XX.id_attribute IN (XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX))) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) AND ((fp_XX.id_feature_value=XX)) GROUP BY fp.id_feature_value
41 queries	SELECT `id_image_type` FROM `mb_image_type` WHERE `name` = 'home'
31 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY cl.name DESC,c.id_category ASC
27 queries	SELECT b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image FROM `mb_ets_mm_block` b LEFT JOIN `mb_ets_mm_block_lang` bl ON b.id_block=bl.id_block AND bl.id_lang=XX WHERE XX AND b.id_column=XX ORDER BY b.sort_order asc
17 queries	SELECT SUM(quantity) FROM `mb_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
16 queries	SELECT `id_module` FROM `mb_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
16 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 `mb_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 `mb_cart_product` cp JOIN `mb_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mb_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
14 queries	SELECT XX FROM `mb_specific_price` WHERE id_product = XX LIMIT XX
13 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 mb_product p LEFT JOIN mb_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN mb_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN mb_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
13 queries	SELECT image_shop.`id_image` FROM `mb_image` i INNER JOIN mb_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
13 queries	SELECT name FROM mb_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
13 queries	SELECT * FROM `mb_product` a LEFT JOIN `mb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `mb_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
13 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 `mb_product` p INNER JOIN `mb_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `mb_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)
13 queries	SELECT `id_tax_rules_group` FROM `mb_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
13 queries	SELECT `reduction` FROM `mb_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
13 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `mb_image` i INNER JOIN mb_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `mb_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
13 queries	SELECT `id_product_attribute` FROM `mb_product_attribute` WHERE `id_product` = XX
12 queries	SELECT cl.`link_rewrite` FROM `mb_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
10 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `mb_feature_value` v LEFT JOIN `mb_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `mb_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
10 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM mb_feature_product pf LEFT JOIN mb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN mb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN mb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN mb_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
9 queries	SELECT * FROM `mb_ets_mm_column` WHERE XX AND id_tab=XX ORDER BY sort_order asc
8 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category =cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX AND cl.id_shop=XX WHERE c.active = XX AND c.id_parent=XX AND c.id_category!=XX ORDER BY c.id_category DESC
6 queries	SELECT * FROM `mb_category` a LEFT JOIN `mb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
6 queries	SELECT * FROM `mb_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
6 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
5 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
5 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
4 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`, pal.`available_now`, pal.`available_later` FROM `mb_attribute` a LEFT JOIN `mb_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `mb_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `mb_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN mb_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 `mb_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `mb_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
4 queries	SELECT * FROM `mb_ets_mm_column` WHERE XX AND id_menu=XX ORDER BY sort_order asc
4 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
4 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
4 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `mb_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
4 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `mb_tvcmsproduct_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX
3 queries	SELECT `need_identification_number` FROM `mb_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT product_attribute_shop.`price` FROM `mb_product_attribute` pa INNER JOIN mb_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
3 queries	SELECT pa.`available_date` FROM `mb_product` p LEFT JOIN `mb_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN mb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
3 queries	SELECT * FROM `mb_product_attribute` a LEFT JOIN `mb_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
3 queries	SELECT * FROM `mb_product_attribute_lang` WHERE `id_product_attribute` = XX
2 queries	SELECT `id_lang` FROM `mb_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT ctg.`id_group` FROM mb_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT XX FROM `mb_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 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 `mb_attribute_group` ag INNER JOIN `mb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `mb_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `mb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN mb_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 mb_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `mb_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
2 queries	SELECT tr.* FROM `mb_tax_rule` tr JOIN `mb_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX) GROUP BY c.id_category ORDER BY cl.name DESC,c.id_category ASC
2 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name DESC,c.id_category ASC
2 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name DESC,c.id_category ASC
2 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name DESC,c.id_category ASC
2 queries	SELECT c.*, cl.name,cl.link_rewrite FROM `mb_category` c INNER JOIN `mb_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=XX) LEFT JOIN `mb_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=XX INNER JOIN `mb_category_group` cg ON c.`id_category` = cg.`id_category` AND cg.id_group IN (XX) WHERE c.active=XX AND c.id_category IN(XX,XX,XX,XX) GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
2 queries	SELECT id_lang FROM `mb_lang` WHERE is_rtl=XX AND active=XX LIMIT XX
2 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `mb_product_attribute_image` pai LEFT JOIN `mb_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `mb_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`

Name	Instances	Source
Category	225	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 129] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 130] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 147] /controllers/front/listing/CategoryController.php:215 (__construct) [id: 269] /classes/Meta.php:380 (__construct) [id: 129] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 129] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 129] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 129] /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) [id: 2] /classes/Link.php:402 (__construct) [id: 258] /classes/Link.php:402 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 292] /classes/Link.php:402 (__construct) [id: 17] /classes/Link.php:402 (__construct) [id: 16] /classes/Link.php:402 (__construct) [id: 20] /classes/Link.php:402 (__construct) [id: 270] /classes/Link.php:402 (__construct) [id: 330] /classes/Link.php:402 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 145] /classes/Link.php:402 (__construct) [id: 257] /classes/Link.php:402 (__construct) [id: 232] /classes/Link.php:402 (__construct) [id: 76] /classes/Link.php:402 (__construct) [id: 111] /classes/Link.php:402 (__construct) [id: 56] /classes/Link.php:402 (__construct) [id: 303] /classes/Link.php:402 (__construct) [id: 304] /classes/Link.php:402 (__construct) [id: 306] /classes/Link.php:402 (__construct) [id: 234] /classes/Link.php:402 (__construct) [id: 241] /classes/Link.php:402 (__construct) [id: 118] /classes/Link.php:402 (__construct) [id: 334] /classes/Link.php:402 (__construct) [id: 333] /classes/Link.php:402 (__construct) [id: 176] /classes/Link.php:402 (__construct) [id: 174] /classes/Link.php:402 (__construct) [id: 149] /classes/Link.php:402 (__construct) [id: 100] /classes/Link.php:402 (__construct) [id: 99] /classes/Link.php:402 (__construct) [id: 84] /classes/Link.php:402 (__construct) [id: 106] /classes/Link.php:402 (__construct) [id: 169] /classes/Link.php:402 (__construct) [id: 121] /classes/Link.php:402 (__construct) [id: 122] /classes/Link.php:402 (__construct) [id: 45] /classes/Link.php:402 (__construct) [id: 110] /classes/Link.php:402 (__construct) [id: 43] /classes/Link.php:402 (__construct) [id: 109] /classes/Link.php:402 (__construct) [id: 260] /classes/Link.php:402 (__construct) [id: 47] /classes/Link.php:402 (__construct) [id: 46] /classes/Link.php:402 (__construct) [id: 72] /classes/Link.php:402 (__construct) [id: 119] /classes/Link.php:402 (__construct) [id: 66] /classes/Link.php:402 (__construct) [id: 48] /classes/Link.php:402 (__construct) [id: 71] /classes/Link.php:402 (__construct) [id: 85] /classes/Link.php:402 (__construct) [id: 108] /classes/Link.php:402 (__construct) [id: 112] /classes/Link.php:402 (__construct) [id: 86] /classes/Link.php:402 (__construct) [id: 87] /classes/Link.php:402 (__construct) [id: 59] /classes/Link.php:402 (__construct) [id: 195] /classes/Link.php:402 (__construct) [id: 124] /classes/Link.php:402 (__construct) [id: 155] /classes/Link.php:402 (__construct) [id: 267] /classes/Link.php:402 (__construct) [id: 265] /classes/Link.php:402 (__construct) [id: 266] /classes/Link.php:402 (__construct) [id: 185] /classes/Link.php:402 (__construct) [id: 268] /classes/Link.php:402 (__construct) [id: 140] /classes/Link.php:402 (__construct) [id: 172] /classes/Link.php:402 (__construct) [id: 154] /classes/Link.php:402 (__construct) [id: 143] /classes/Link.php:402 (__construct) [id: 142] /classes/Link.php:402 (__construct) [id: 139] /classes/Link.php:402 (__construct) [id: 242] /classes/Link.php:402 (__construct) [id: 243] /classes/Link.php:402 (__construct) [id: 240] /classes/Link.php:402 (__construct) [id: 256] /classes/Link.php:402 (__construct) [id: 325] /classes/Link.php:402 (__construct) [id: 291] /classes/Link.php:402 (__construct) [id: 152] /classes/Link.php:402 (__construct) [id: 335] /classes/Link.php:402 (__construct) [id: 191] /classes/Link.php:402 (__construct) [id: 193] /classes/Link.php:402 (__construct) [id: 194] /classes/Link.php:402 (__construct) [id: 332] /classes/Link.php:402 (__construct) [id: 192] /classes/Link.php:402 (__construct) [id: 147] /classes/Link.php:402 (__construct) [id: 130] /classes/Link.php:402 (__construct) [id: 269] /classes/Link.php:402 (__construct) [id: 131] /classes/Link.php:402 (__construct) [id: 37] /classes/Link.php:402 (__construct) [id: 34] /classes/Link.php:402 (__construct) [id: 41] /classes/Link.php:402 (__construct) [id: 177] /classes/Link.php:402 (__construct) [id: 135] /classes/Link.php:402 (__construct) [id: 233] /classes/Link.php:402 (__construct) [id: 126] /classes/Link.php:402 (__construct) [id: 180] /classes/Link.php:402 (__construct) [id: 231] /classes/Link.php:402 (__construct) [id: 181] /classes/Link.php:402 (__construct) [id: 319] /classes/Link.php:402 (__construct) [id: 293] /classes/Link.php:402 (__construct) [id: 324] /classes/Link.php:402 (__construct) [id: 322] /classes/Link.php:402 (__construct) [id: 329] /classes/Link.php:402 (__construct) [id: 327] /classes/Link.php:402 (__construct) [id: 321] /classes/Link.php:402 (__construct) [id: 323] /classes/Link.php:402 (__construct) [id: 300] /classes/Link.php:402 (__construct) [id: 296] /classes/Link.php:402 (__construct) [id: 295] /classes/Link.php:402 (__construct) [id: 297] /classes/Link.php:402 (__construct) [id: 299] /classes/Link.php:402 (__construct) [id: 298] /classes/Link.php:402 (__construct) [id: 190] /classes/Link.php:402 (__construct) [id: 248] /classes/Link.php:402 (__construct) [id: 96] /classes/Link.php:402 (__construct) [id: 95] /classes/Link.php:402 (__construct) [id: 97] /classes/Link.php:402 (__construct) [id: 94] /classes/Link.php:402 (__construct) [id: 226] /classes/Link.php:402 (__construct) [id: 92] /classes/Link.php:402 (__construct) [id: 227] /classes/Link.php:402 (__construct) [id: 90] /classes/Link.php:402 (__construct) [id: 89] /classes/Link.php:402 (__construct) [id: 246] /classes/Link.php:402 (__construct) [id: 245] /classes/Link.php:402 (__construct) [id: 247] /classes/Link.php:402 (__construct) [id: 70] /classes/Link.php:402 (__construct) [id: 68] /classes/Link.php:402 (__construct) [id: 67] /classes/Link.php:402 (__construct) [id: 69] /classes/Link.php:402 (__construct) [id: 156] /classes/Link.php:402 (__construct) [id: 151] /classes/Link.php:402 (__construct) [id: 136] /classes/Link.php:402 (__construct) [id: 235] /classes/Link.php:402 (__construct) [id: 133] /classes/Link.php:402 (__construct) [id: 137] /classes/Link.php:402 (__construct) [id: 54] /classes/Link.php:402 (__construct) [id: 52] /classes/Link.php:402 (__construct) [id: 78] /classes/Link.php:402 (__construct) [id: 79] /classes/Link.php:402 (__construct) [id: 163] /classes/Link.php:402 (__construct) [id: 236] /classes/Link.php:402 (__construct) [id: 77] /classes/Link.php:402 (__construct) [id: 141] /classes/Link.php:402 (__construct) [id: 75] /classes/Link.php:402 (__construct) [id: 178] /classes/Link.php:402 (__construct) [id: 80] /classes/Link.php:402 (__construct) [id: 82] /classes/Link.php:402 (__construct) [id: 81] /classes/Link.php:402 (__construct) [id: 83] /classes/Link.php:402 (__construct) [id: 238] /classes/Link.php:402 (__construct) [id: 239] /classes/Link.php:402 (__construct) [id: 63] /classes/Link.php:402 (__construct) [id: 62] /classes/Link.php:402 (__construct) [id: 173] /classes/Link.php:402 (__construct) [id: 114] /classes/Link.php:402 (__construct) [id: 144] /classes/Link.php:402 (__construct) [id: 171] /classes/Link.php:402 (__construct) [id: 65] /classes/Link.php:402 (__construct) [id: 113] /classes/Link.php:402 (__construct) [id: 170] /classes/Link.php:402 (__construct) [id: 166] /classes/Link.php:402 (__construct) [id: 159] /classes/Link.php:402 (__construct) [id: 228] /classes/Link.php:402 (__construct) [id: 229] /classes/Link.php:402 (__construct) [id: 230] /classes/Link.php:402 (__construct) [id: 160] /classes/Link.php:402 (__construct) [id: 158] /classes/Link.php:402 (__construct) [id: 165] /classes/Link.php:402 (__construct) [id: 161] /classes/Link.php:402 (__construct) [id: 164] /classes/Link.php:402 (__construct) [id: 311] /classes/Link.php:402 (__construct) [id: 310] /classes/Link.php:402 (__construct) [id: 309] /classes/Link.php:402 (__construct) [id: 30] /classes/Link.php:402 (__construct) [id: 175] /classes/Link.php:402 (__construct) [id: 98] /classes/Link.php:402 (__construct) [id: 40] /classes/Link.php:402 (__construct) [id: 39] /classes/Link.php:402 (__construct) [id: 237] /classes/Link.php:402 (__construct) [id: 316] /classes/Link.php:402 (__construct) [id: 317] /classes/Link.php:402 (__construct) [id: 318] /classes/Link.php:402 (__construct) [id: 314] /classes/Link.php:402 (__construct) [id: 312] /classes/Link.php:402 (__construct) [id: 315] /classes/Link.php:402 (__construct) [id: 277] /classes/Link.php:402 (__construct) [id: 123] /classes/Link.php:402 (__construct) [id: 276] /classes/Link.php:402 (__construct) [id: 285] /classes/Link.php:402 (__construct) [id: 284] /classes/Link.php:402 (__construct) [id: 286] /classes/Link.php:402 (__construct) [id: 287] /classes/Link.php:402 (__construct) [id: 274] /classes/Link.php:402 (__construct) [id: 331] /classes/Link.php:402 (__construct) [id: 192] /classes/Link.php:402 (__construct) [id: 332] /classes/Link.php:402 (__construct) [id: 194] /classes/Link.php:402 (__construct) [id: 193] /classes/Link.php:402 (__construct) [id: 191] /classes/Link.php:402 (__construct) [id: 335] /classes/Link.php:402 (__construct) [id: 153] /classes/Link.php:402 (__construct) [id: 256] /classes/Link.php:402 (__construct) [id: 325] /classes/Link.php:402 (__construct) [id: 291] /classes/Link.php:402 (__construct) [id: 152] /classes/Link.php:402 (__construct) [id: 326] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 129] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 258] /classes/Link.php:402 (__construct) [id: 258] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 255] /classes/Link.php:402 (__construct) [id: 255] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 14] /classes/Link.php:402 (__construct) [id: 14] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 292] /classes/Link.php:402 (__construct) [id: 292]
Product	30	/classes/Link.php:113 (__construct) [id: 6912] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 10542] /classes/Link.php:113 (__construct) [id: 10543] /classes/Link.php:113 (__construct) [id: 10540] /classes/Link.php:113 (__construct) [id: 10539] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10542] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10543] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10540] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10539] /classes/Link.php:113 (__construct) [id: 9661] /classes/Link.php:113 (__construct) [id: 9012] /classes/Link.php:113 (__construct) [id: 9653] /classes/Link.php:113 (__construct) [id: 8405] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9661] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9012] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9653] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 8405] /classes/Link.php:113 (__construct) [id: 6191] /classes/Link.php:113 (__construct) [id: 9243] /classes/Link.php:113 (__construct) [id: 6365] /classes/Link.php:113 (__construct) [id: 3424] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 6191] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 9243] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 6365] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3424] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 6912] /classes/Link.php:113 (__construct) [id: 6912]
Country	7	/config/config.inc.php:146 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /classes/controller/FrontController.php:1760 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 208]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5945 (__construct) [id: ]
State	3	/classes/controller/FrontController.php:1759 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Combination	3	/classes/Product.php:5893 (__construct) [id: 271] /classes/Product.php:5893 (__construct) [id: 1034] /classes/Product.php:5893 (__construct) [id: 1037]
AddressFormat	3	/classes/controller/FrontController.php:1754 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Currency	2	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Cart	2	/classes/controller/FrontController.php:465 (__construct) [id: ] /classes/controller/FrontController.php:534 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
CMS	1	/classes/Link.php:555 (__construct) [id: 4]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 7]
Gender	1	/classes/controller/FrontController.php:1684 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1687 (__construct) [id: ]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
753	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("2025-07-28 00:00:00", INTERVAL 1000 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `mb_category_product` cp LEFT JOIN `mb_product` p ON p.`id_product` = cp.`id_product` INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_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 mb_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 `mb_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `mb_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `mb_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 `mb_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `mb_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	102.696 ms	8092	Yes		/classes/Category.php:1062 /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:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (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 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( "2025-07-28 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 `mb_product` p INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `mb_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 `mb_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `mb_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `mb_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 mb_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-07-28 00:00:00", INTERVAL 1000 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `mb_category_product` cp JOIN `mb_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	80.682 ms	100696848	Yes		/classes/Product.php:3110 /modules/tvcmstabproducts/tvcmstabproducts.php:2763 (getNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:157 (displayNewProducts) /modules/tvcmsnewproducts/tvcmsnewproducts.php:266 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
799	SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `mb_product` p INNER JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_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	23.189 ms	5664			/classes/Category.php:991 /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:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
134	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=43)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	3.377 ms	384	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
96	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=6)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) GROUP BY fp.id_feature_value	3.364 ms	211600	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
179	SELECT SQL_NO_CACHE `id_module` FROM `mb_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1	3.266 ms	1			/classes/module/Module.php:2109 /classes/Hook.php:1049 (isEnabled) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1000 (coreRenderWidget) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/61/ed/c3/61edc3eb579de51f40a524f7e0cb944dbe3715bc_2.file.desk-header-2.tpl.php:42 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b74e556_49315661) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/52/ff/b8/52ffb8ccea06a016c919abddded2a0d83090fa82_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b743099_20373169) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b73ee58_88544922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
74	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) INNER JOIN mb_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	3.177 ms	87616	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
70	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `mb_feature_value` v LEFT JOIN `mb_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `mb_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC	2.705 ms	141	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Converter.php:402 (getFeatureValues) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
140	REPLACE INTO mb_layered_filter_block (hash, data) VALUES ("0332bdc2b34559f97886bc353e63f382", "a:1:{s:7:\"filters\";a:12:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Catégories\";s:6:\"values\";a:1:{i:130;a:2:{s:4:\"name\";s:11:\"Smartphones\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:1;a:7:{s:9:\"type_lite\";s:6:\"extras\";s:4:\"type\";s:6:\"extras\";s:6:\"id_key\";i:0;s:4:\"name\";s:10:\"Selections\";s:6:\"values\";a:3:{s:4:\"sale\";a:2:{s:4:\"name\";s:8:\"En promo\";s:3:\"nbr\";i:0;}s:3:\"new\";a:2:{s:4:\"name\";s:15:\"Nouveau produit\";s:3:\"nbr\";i:0;}s:8:\"discount\";a:2:{s:4:\"name\";s:10:\"Discounted\";s:3:\"nbr\";i:0;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:2;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:1:{i:239;a:2:{s:4:\"name\";s:4:\"VIVO\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:3;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Prix\";s:3:\"max\";d:399;s:3:\"min\";d:399;s:4:\"unit\";s:3:\"TND\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"TND\";s:14:\"currencySymbol\";s:3:\"TND\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:3;s:17:\"minFractionDigits\";i:3;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:1;s:5:\"value\";N;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:3;s:4:\"name\";s:7:\"Couleur\";s:14:\"is_color_group\";b:1;s:6:\"values\";a:2:{i:11;a:6:{s:4:\"name\";s:4:\"Noir\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#434A54\";s:7:\"checked\";b:1;}i:14;a:5:{s:4:\"name\";s:4:\"Bleu\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:5:\"color\";s:7:\"#5D9CEC\";}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:1;s:6:\"values\";a:2:{i:177;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:3:\"5 \"\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1639;a:5:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"6.3\"\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:6:\"Écran\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:2;s:6:\"values\";a:1:{i:12992;a:5:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"MediaTek\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:4:\"name\";s:10:\"Processeur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:3;s:6:\"values\";a:1:{i:43;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"2 Go\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Mémoire\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:8;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:6;s:6:\"values\";a:6:{i:1106;a:5:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"32 Go\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:1120;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:5:\"64 Go\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:1822;a:4:{s:3:\"nbr\";i:20;s:4:\"name\";s:6:\"128 GO\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:171;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"250 Go\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:13882;a:4:{s:3:\"nbr\";i:8;s:4:\"name\";s:6:\"256 GO\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:24139;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"512 GB\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Stockage\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:8;s:6:\"values\";a:1:{i:27572;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"4030mAh\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Batterie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:10;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:15;s:6:\"values\";a:1:{i:214;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:13:\"5 Mégapixels\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:16:\"Camera frontale \";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}i:11;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:16;s:6:\"values\";a:1:{i:274;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:14:\"13 Mégapixels\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:15:\"Camera Arriére\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:0;}}}")	2.576 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:211 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
172	SELECT SQL_NO_CACHE c., cl. FROM `mb_category` c INNER JOIN mb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `mb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC	2.361 ms	245	Yes		/classes/Category.php:799 /modules/tvcmssearch/tvcmssearch.php:102 (getNestedCategories) /modules/tvcmssearch/tvcmssearch.php:213 (getAllCategories) /classes/Hook.php:1043 (hookdisplayNavSearchBlock) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/61/ed/c3/61edc3eb579de51f40a524f7e0cb944dbe3715bc_2.file.desk-header-2.tpl.php:29 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b74e556_49315661) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/52/ff/b8/52ffb8ccea06a016c919abddded2a0d83090fa82_2.file.desktop-header.tpl.php:25 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b743099_20373169) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b73ee58_88544922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((fp.id_feature_value IN (1639, 13080, 13094))) AND ((fp_1.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_2.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mb_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((a.id_attribute_group=3)) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) GROUP BY pac.id_attribute	2.217 ms	700928	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND cg.id_group='1' AND c.level_depth<=4 AND c.nleft>188 AND c.nright<195 GROUP BY cp.id_category	2.180 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `mb_manufacturer` m INNER JOIN mb_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `mb_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	2.174 ms	290	Yes		/classes/Manufacturer.php:211 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE data FROM mb_layered_filter_block WHERE hash="0332bdc2b34559f97886bc353e63f382" LIMIT 1	2.107 ms	1			/modules/ps_facetedsearch/src/Filters/Block.php:186 /modules/ps_facetedsearch/src/Product/SearchProvider.php:210 (getFromCache) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
510	SELECT SQL_NO_CACHE * FROM `mb_category` a LEFT JOIN `mb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `mb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 67) AND (b.`id_shop` = 1) LIMIT 1	2.084 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /classes/Link.php:402 (__construct) /classes/Link.php:458 (getCategoryObject) /var/cache/prod/smarty/compile/v1_electron_1/6f/9c/42/6f9c420c78e41b76983150f533ea10395e7c3d28_2.file.categories-tree.tpl.php:37 (getCategoryLink) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b99946667_78958891) /vendor/smarty/smarty/libs/sysplugins/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) /modules/ets_megamenu/ets_megamenu.php:4629 (fetch) /modules/ets_megamenu/ets_megamenu.php:3319 (display) /modules/ets_megamenu/ets_megamenu.php:2671 (displayCategories) /modules/ets_megamenu/ets_megamenu.php:2579 (convertBlockProperties) /var/cache/prod/smarty/compile/v1_electron_1/0d/33/c4/0d33c448146e5de9429dcae3809bb001ed5763be_2.file.menu-html.tpl.php:256 (hookDisplayBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b99937787_61535144) /vendor/smarty/smarty/libs/sysplugins/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) /modules/ets_megamenu/ets_megamenu.php:4629 (fetch) /modules/ets_megamenu/ets_megamenu.php:3551 (display) /modules/ets_megamenu/ets_megamenu.php:3473 (displayMegaMenu) /modules/ets_megamenu/ets_megamenu.php:3505 (displayMenuFrontend) /classes/Hook.php:1043 (hookDisplayNavFullWidth) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:61 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b73ee58_88544922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
812	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("2025-07-28 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `mb_product_sale` ps LEFT JOIN `mb_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN mb_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mb_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 `mb_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `mb_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 `mb_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `mb_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `mb_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 208 AND tr.`id_state` = 0 LEFT JOIN `mb_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN mb_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 `mb_category_product` cp JOIN `mb_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 4	1.949 ms	4			/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:268 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
136	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=49)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.927 ms	1792	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=3)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.891 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
88	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_2.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=1)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.839 ms	87616	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
133	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=42)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.744 ms	8960	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
83	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) GROUP BY p.id_manufacturer	1.714 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
75	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106))	1.702 ms	4736			/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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((fp.id_feature=2)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.699 ms	87616	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
153	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 `mb_hook_module` hm STRAIGHT_JOIN `mb_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `mb_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	1.627 ms	426			/classes/Hook.php:456 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM mb_product p INNER JOIN mb_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 = 208) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195	1.621 ms	296			/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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
81	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_specific_price sp ON ( sp.id_product = p.id_product AND sp.id_shop IN (0, 1) AND sp.id_currency IN (0, 1) AND sp.id_country IN (0, 208) AND sp.id_group IN (0, 1) AND sp.from_quantity = 1 AND sp.reduction > 0 AND sp.id_customer = 0 AND sp.id_cart = 0 AND (sp.from = '0000-00-00 00:00:00' OR '2025-07-28 23:54:43' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-07-28 23:54:43' <= sp.to) ) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((sp.reduction>0)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106))	1.605 ms	4736			/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/Block.php:605 (count) /modules/ps_facetedsearch/src/Filters/Block.php:143 (getHighlightsBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
94	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=4)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.600 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
412	SELECT SQL_NO_CACHE `id_image_type` FROM `mb_image_type` WHERE `name` = 'home'	1.596 ms	1			/classes/ImageType.php:145 /modules/ets_megamenu/ets_megamenu.php:601 (typeAlreadyExists) /modules/ets_megamenu/ets_megamenu.php:2729 (getMmType) /modules/ets_megamenu/ets_megamenu.php:2689 (displayProducts) /modules/ets_megamenu/ets_megamenu.php:2579 (convertBlockProperties) /var/cache/prod/smarty/compile/v1_electron_1/0d/33/c4/0d33c448146e5de9429dcae3809bb001ed5763be_2.file.menu-html.tpl.php:256 (hookDisplayBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b99937787_61535144) /vendor/smarty/smarty/libs/sysplugins/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) /modules/ets_megamenu/ets_megamenu.php:4629 (fetch) /modules/ets_megamenu/ets_megamenu.php:3551 (display) /modules/ets_megamenu/ets_megamenu.php:3473 (displayMegaMenu) /modules/ets_megamenu/ets_megamenu.php:3505 (displayMenuFrontend) /classes/Hook.php:1043 (hookDisplayNavFullWidth) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:61 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b73ee58_88544922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
105	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=14)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.583 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
152	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `mb_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `mb_hook_alias` ha INNER JOIN `mb_hook` h ON ha.name = h.name	1.536 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5675 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
395	SELECT SQL_NO_CACHE `id_image_type` FROM `mb_image_type` WHERE `name` = 'home'	1.532 ms	1			/classes/ImageType.php:145 /modules/ets_megamenu/ets_megamenu.php:601 (typeAlreadyExists) /modules/ets_megamenu/ets_megamenu.php:2729 (getMmType) /modules/ets_megamenu/ets_megamenu.php:2689 (displayProducts) /modules/ets_megamenu/ets_megamenu.php:2579 (convertBlockProperties) /var/cache/prod/smarty/compile/v1_electron_1/0d/33/c4/0d33c448146e5de9429dcae3809bb001ed5763be_2.file.menu-html.tpl.php:256 (hookDisplayBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b99937787_61535144) /vendor/smarty/smarty/libs/sysplugins/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) /modules/ets_megamenu/ets_megamenu.php:4629 (fetch) /modules/ets_megamenu/ets_megamenu.php:3551 (display) /modules/ets_megamenu/ets_megamenu.php:3473 (displayMegaMenu) /modules/ets_megamenu/ets_megamenu.php:3505 (displayMenuFrontend) /classes/Hook.php:1043 (hookDisplayNavFullWidth) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:61 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/1e/d1/c2/1ed1c2bd038ee59c289bc0dfa862939f4ace5853_2.file.header.tpl.php:29 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b73ee58_88544922) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/7b/20/9b/7b209b8ad3a4b959ee700fbabff63490fd8dfb7e_2.file.layout-both-columns.tpl.php:64 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6d7dd3_62298143) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/59/27/34/592734f8f890bb342f82010dedfdefdfb102af18_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b85a3_55565069) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/89/73/cd/8973cd33287e2cbf8397bbeb9d03e6e024e12e8e_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6b26f3_29067136) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php: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/prod/smarty/compile/v1_electron_1layouts_layout_left_column_tpl/ad/e7/9e/ade79eb0f0f9f51d33a9ae668beef9fcff755b39_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_68816b9b6a1a00_79340852) /vendor/smarty/smarty/libs/sysplugins/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/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
137	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=55)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.525 ms	640	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `mb_module` m INNER JOIN mb_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 `mb_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `mb_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `mb_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`	1.482 ms	76	Yes	Yes	/classes/Hook.php:1233 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
124	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=33)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.481 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
139	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=106)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.468 ms	512	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
95	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=5)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.437 ms	8448	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=7)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.432 ms	8704	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN mb_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((a.id_attribute_group=4)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY pac.id_attribute	1.421 ms	7680	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
106	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=15)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.408 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
118	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 mb_product p LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN mb_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 mb_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN mb_category_product cp ON (p.id_product = cp.id_product) INNER JOIN mb_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN mb_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN mb_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN mb_feature_product fp_1 ON (p.id_product = fp_1.id_product) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) WHERE ((pac.id_attribute IN (11, 25))) AND ((fp_1.id_feature_value IN (1639, 13080, 13094))) AND ((fp_2.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_3.id_feature_value=1106)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=188 AND c.nright<=195 GROUP BY p.id_product) p INNER JOIN mb_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN mb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN mb_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN mb_feature_product fp_2 ON (p.id_product = fp_2.id_product) LEFT JOIN mb_feature_product fp_3 ON (p.id_product = fp_3.id_product) LEFT JOIN mb_feature_product fp_4 ON (p.id_product = fp_4.id_product) WHERE ((fp.id_feature=27)) AND ((pac_1.id_attribute IN (11, 25))) AND ((fp_2.id_feature_value IN (1639, 13080, 13094))) AND ((fp_3.id_feature_value IN (12992, 12993, 27024, 24312, 23697))) AND ((fp_4.id_feature_value=1106)) GROUP BY fp.id_feature_value	1.400 ms	4736	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:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:138 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /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-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php

Panier

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

SMARTPHONE VIVO Y1S 2G 32G BLEU

Stopwatch SQL - 913 queries

Doubles

Tables stress

ObjectModel instances

Included Files