Depuis plus de 25 ans à votre service. Nous sommes situés à Souchez dans le Pas-de-Calais (62) entre Arras et Béthune. Spécialiste dans le matériel de la motoculture de plaisance et des espaces verts. (2)

Nous utilisons des cookies sur notre site pour améliorer votre expérience de navigation et vous fournir des contenus et services adaptés à vos intérêts. En continuant à naviguer sur notre site, vous acceptez l'utilisation de ces cookies. Si vous souhaitez en savoir plus sur l'utilisation que nous faisons des cookies ou comment les gérer, vous pouvez consulter notre politique de confidentialité.

La tondeuse robot Next Tech LX6 - 6000 m² - BEAUCAMP MOTOCULTURE

Next Tech Techline LX6

4 470,00 €

Next Tech Techline LX6

4 470,00 €

Next Tech Techline LX6

Les tondeuses robot

Le modèle Techline L X6 combine les caractéristiques de flexibilité et de modularité avec l’innovation technologique pour des surfaces jusqu'à 6 000m². Il est équipé du dispositif ZCS Connect : technologies GPS - Bluetooth et GSM, permet la connexion du...

4 470,00 €

Aperçu rapide

Next Tech Techline LX6

Les tondeuses robot

4 470,00 €

Aperçu rapide

Load Time	2789 ms
Querying Time	2817 ms
Queries	2073
Memory Peak Usage	62.5 Mb
Included Files	1146 files - 11.51 Mb
PrestaShop Cache	- Mb
Global vars	0.77 Mb
- global $_MODULES	565k
- global $context	185k
- global $_SERVER	8k
- global $_ENV	8k
- global $__composer_autoload_files	5k
- global $config	5k
- global $exportPhpConfigFile	4k
- global $_COOKIE	2k
- global $_REQUEST	2k
- global $_MODULE	2k
- global $legacyContainer	1k

PrestaShop Version	8.2.0
PHP Version	7.4.33
MySQL Version	8.0.39-30
Memory Limit	512M
Max Execution Time	165s
Smarty Cache	enabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	16.004 ms	16.004 ms	7.54 Mb	7.8 Mb
__construct	0.011 ms	16.015 ms	- Mb	7.8 Mb
init	48.416 ms	64.431 ms	1.78 Mb	9.5 Mb
checkAccess	0.002 ms	64.433 ms	- Mb	9.5 Mb
setMedia	5.527 ms	69.960 ms	0.25 Mb	9.6 Mb
postProcess	0.001 ms	69.961 ms	- Mb	9.6 Mb
initHeader	0.001 ms	69.962 ms	- Mb	9.6 Mb
initContent	450.665 ms	520.627 ms	5.15 Mb	14.8 Mb
initFooter	0.001 ms	520.628 ms	- Mb	14.8 Mb
display	2268 ms	2789 ms	47.43 Mb	62.5 Mb

Hook	Time	Memory Usage
DisplayLeftColumn	2060 ms	39.54 Mb
=> tvcmsnewproducts	22.374 ms	0.68 Mb
=> tvcmscustomerservices	0.292 ms	0.06 Mb
=> tvcmsspecialproducts	1827 ms	35.59 Mb
=> tvcmsfeaturedproducts	73.811 ms	1.76 Mb
=> tvcmsbestsellerproducts	135.833 ms	1.46 Mb
DisplayAfterBodyOpeningTag	130.939 ms	2.42 Mb
=> tvcmscookiesnotice	0.202 ms	0.02 Mb
=> blockreassurance	0.004 ms	- Mb
=> tvcmsproductpopup	130.550 ms	2.38 Mb
=> cdc_googletagmanager	0.183 ms	0.02 Mb
DisplayHeader	19.197 ms	0.31 Mb
=> ps_searchbar	0.113 ms	- Mb
=> ps_shoppingcart	0.019 ms	- Mb
=> tvcmstabproducts	0.080 ms	- Mb
=> tvcmscustomerservices	0.049 ms	- Mb
=> tvcmscustomsetting	0.285 ms	0.01 Mb
=> tvcmsfooterlogo	0.001 ms	- Mb
=> tvcmsfooterproduct	0.032 ms	- Mb
=> tvcmsmultibanner1	0.048 ms	- Mb
=> tvcmspaymenticon	0.001 ms	- Mb
=> tvcmsslider	0.059 ms	- Mb
=> tvcmswishlist	0.066 ms	- Mb
=> tvcmscategorychainslider	0.043 ms	- Mb
=> tvcmsnewsletterpopup	0.086 ms	- Mb
=> tvcmscookiesnotice	0.045 ms	- Mb
=> tvcmsproductcomments	0.137 ms	- Mb
=> tvcmsbrandlist	0.043 ms	- Mb
=> tvcmsproductpopup	0.042 ms	- Mb
=> tvcmscategoryslider	0.042 ms	- Mb
=> tvcmsbestsellerproducts	0.028 ms	- Mb
=> tvcmsfeaturedproducts	0.026 ms	- Mb
=> tvcmsnewproducts	0.024 ms	- Mb
=> tvcmsproductcompare	0.041 ms	- Mb
=> tvcmssearch	0.096 ms	- Mb
=> tvcmsspecialproducts	0.025 ms	- Mb
=> tvcmsthemeoptions	0.122 ms	- Mb
=> cdc_googletagmanager	0.035 ms	- Mb
=> ganalyticspro	17.598 ms	0.26 Mb
=> ets_advancedcaptcha	0.011 ms	- Mb
Header	12.167 ms	0.32 Mb
=> tvcmsstockinfo	0.052 ms	- Mb
=> alma	2.630 ms	0.24 Mb
=> tvcmsinfinitescroll	9.264 ms	0.06 Mb
=> tvcmsofferbanner	0.054 ms	- Mb
=> tvcmstwoofferbanner	0.047 ms	- Mb
=> tvcmsmegamenu	0.060 ms	- Mb
=> tvcmscategoryproduct	0.060 ms	- Mb
displayLeftColumn	10.088 ms	0.48 Mb
=> ps_categorytree (widget)	7.948 ms	0.38 Mb
=> ps_brandlist (widget)	1.234 ms	0.05 Mb
=> ps_supplierlist (widget)	0.906 ms	0.06 Mb
DisplayAfterTitleTag	9.597 ms	0.35 Mb
=> cdc_googletagmanager	9.596 ms	0.35 Mb
=> cdc_googletagmanager	0.001 ms	- Mb
displayNav1	5.571 ms	0.09 Mb
=> ps_contactinfo (widget)	5.571 ms	0.09 Mb
DisplayReviewProductList	5.346 ms	0.49 Mb
=> tvcmsproductcomments	1.995 ms	0.14 Mb
=> tvcmsproductcomments	1.122 ms	0.09 Mb
=> tvcmsproductcomments	1.153 ms	0.16 Mb
=> tvcmsproductcomments	1.076 ms	0.09 Mb
DisplayFooterCategory	5.236 ms	0.26 Mb
=> tvcmsfootercategory	5.236 ms	0.26 Mb
DisplayMegamenu	5.019 ms	0.32 Mb
=> tvcmsmegamenu	5.019 ms	0.32 Mb
DisplayCustomsocialblock	3.328 ms	0.24 Mb
=> tvcmscustomsetting	3.328 ms	0.24 Mb
displayNavShoppingCartBlock	3.322 ms	0.18 Mb
=> ps_shoppingcart (widget)	3.322 ms	0.18 Mb
DisplayNavSearchBlock	2.713 ms	0.25 Mb
=> tvcmssearch	2.713 ms	0.25 Mb
DisplayNavWishlistBlock	2.635 ms	0.11 Mb
=> tvcmswishlist	1.145 ms	0.06 Mb
=> tvcmswishlist	1.490 ms	0.05 Mb
displaySocialMediaBlock	1.246 ms	0.07 Mb
=> ps_socialfollow (widget)	1.246 ms	0.07 Mb
displayNavCustomerSignInBlock	1.241 ms	0.06 Mb
=> ps_customersignin (widget)	1.241 ms	0.06 Mb
displayNavLanguageBlock	1.239 ms	0.05 Mb
=> ps_languageselector (widget)	1.239 ms	0.05 Mb
DisplayPaymentIcon	1.225 ms	0.06 Mb
=> tvcmspaymenticon	1.225 ms	0.06 Mb
displayFooterPart1	1.176 ms	0.06 Mb
=> ps_linklist (widget)	1.176 ms	0.06 Mb
displayMyaccountcblock	1.167 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	1.167 ms	0.06 Mb
DisplayNavWishlistBlocksticky	1.097 ms	0.06 Mb
=> tvcmswishlist	1.097 ms	0.06 Mb
displayNavCurrencyBlock	0.888 ms	0.05 Mb
=> ps_currencyselector (widget)	0.888 ms	0.05 Mb
displayContactCinfo	0.809 ms	0.04 Mb
=> ps_contactinfo (widget)	0.809 ms	0.04 Mb
DisplayWishlistBtnProductList	0.722 ms	0.06 Mb
=> tvcmswishlist	0.200 ms	0.02 Mb
=> tvcmswishlist	0.175 ms	0.01 Mb
=> tvcmswishlist	0.176 ms	0.01 Mb
=> tvcmswishlist	0.171 ms	0.01 Mb
DisplayProductCompareProductList	0.696 ms	0.12 Mb
=> tvcmsproductcompare	0.197 ms	0.08 Mb
=> tvcmsproductcompare	0.171 ms	0.01 Mb
=> tvcmsproductcompare	0.167 ms	0.01 Mb
=> tvcmsproductcompare	0.161 ms	0.01 Mb
DisplayProductPriceBlock	0.395 ms	0.03 Mb
=> cdc_googletagmanager	0.002 ms	- Mb
=> alma	0.245 ms	0.03 Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.015 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.021 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.010 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.020 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.011 ms	- Mb
=> cdc_googletagmanager	0.000 ms	- Mb
=> alma	0.009 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.022 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.012 ms	- Mb
=> cdc_googletagmanager	0.001 ms	- Mb
=> alma	0.009 ms	- Mb
DisplayNavProductCompareBlock	0.355 ms	0.02 Mb
=> tvcmsproductcompare	0.194 ms	0.01 Mb
=> tvcmsproductcompare	0.161 ms	0.01 Mb
ProductSearchProvider	0.316 ms	0.07 Mb
=> ps_facetedsearch	0.316 ms	0.07 Mb
DisplayProductComparesticky	0.197 ms	0.01 Mb
=> tvcmsproductcompare	0.197 ms	0.01 Mb
ActionFrontControllerSetMedia	0.187 ms	0.01 Mb
=> blockreassurance	0.119 ms	- Mb
=> ps_socialfollow	0.030 ms	- Mb
=> ps_emailalerts	0.038 ms	- Mb
DisplayFooterPart2	0.181 ms	0.03 Mb
=> tvcmsfooterlogo	0.181 ms	0.03 Mb
DisplayFacetedSearchBlock	0.180 ms	0.07 Mb
=> ps_facetedsearch	0.180 ms	0.07 Mb
DisplayCopyRightText	0.136 ms	0.02 Mb
=> tvcmscustomsetting	0.136 ms	0.02 Mb
ModuleRoutes	0.071 ms	- Mb
=> alma	0.071 ms	- Mb
DisplayProductListStockIndicator	0.022 ms	- Mb
=> tvcmsstockinfo	0.014 ms	- Mb
=> tvcmsstockinfo	0.008 ms	- Mb
DisplayTopOfferText	0.013 ms	- Mb
=> tvcmscustomsetting	0.009 ms	- Mb
=> tvcmscustomsetting	0.004 ms	- Mb
DisplayBeforeBodyClosingTag	0.008 ms	- Mb
=> cdc_googletagmanager	0.008 ms	- Mb
DisplayCustomCss	0.006 ms	- Mb
=> tvcmscustomcssjs	0.006 ms	- Mb
DisplayNavFullWidth	0.005 ms	- Mb
=> blockreassurance	0.005 ms	- Mb
DisplayOverrideTemplate	0.005 ms	- Mb
=> ets_advancedcaptcha	0.005 ms	- Mb
DisplayCustomJs	0.005 ms	- Mb
=> tvcmscustomcssjs	0.005 ms	- Mb
DisplayFooter	0.004 ms	- Mb
=> ganalyticspro	0.004 ms	- Mb
42 hook(s)	2288 ms	46.33 Mb

238 queries	SELECT XX FROM `preXX_specific_price` WHERE id_product = XX LIMIT XX
237 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 `preXX_product` p INNER JOIN `preXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `preXX_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)
237 queries	SELECT `reduction` FROM `preXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
237 queries	SELECT `id_tax_rules_group` FROM `preXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
231 queries	SELECT `priority`, `id_specific_price_priority` FROM `preXX_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
223 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `preXX_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
216 queries	SELECT product_attribute_shop.id_product_attribute FROM preXX_product_attribute pa INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
22 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 preXX_product p LEFT JOIN preXX_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN preXX_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN preXX_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
22 queries	SELECT `id_product_attribute` FROM `preXX_product_attribute` WHERE `id_product` = XX
22 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `preXX_image` i INNER JOIN preXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `preXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
20 queries	SELECT SUM(quantity) FROM `preXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
20 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `preXX_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `preXX_cart_product` cp JOIN `preXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `preXX_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
18 queries	SELECT name FROM preXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
18 queries	SELECT * FROM `preXX_product` a LEFT JOIN `preXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `preXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
18 queries	SELECT image_shop.`id_image` FROM `preXX_image` i INNER JOIN preXX_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
16 queries	SELECT `id_module` FROM `preXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
15 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM preXX_feature_product pf LEFT JOIN preXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN preXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN preXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN preXX_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
13 queries	SELECT cl.`link_rewrite` FROM `preXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
10 queries	SELECT mr.* FROM preXX_tvcmsmegamenu_row_shop mr WHERE mr.`id_shop` = XX AND mr.id_tvcmsmegamenu = XX AND mr.`active` = XX
9 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
9 queries	SELECT * FROM `preXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
9 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 `preXX_feature_value` v LEFT JOIN `preXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `preXX_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
8 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `preXX_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` IN (XX, XX) AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
7 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, cp.position FROM preXX_product p LEFT JOIN preXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN preXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN preXX_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 preXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN preXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN preXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN preXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN preXX_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (XX, XX, XX, XX, XX))) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN preXX_feature_product fp_XX ON (p.id_product = fp_XX.id_product) WHERE ((fp.id_feature=XX)) AND ((fp_XX.id_feature_value IN (XX, XX, XX, XX, XX))) GROUP BY fp.id_feature_value
7 queries	SELECT `id_country` FROM `preXX_country` WHERE `iso_code` = 'FR' LIMIT XX
7 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `preXX_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
5 queries	SELECT `name` FROM `preXX_country_lang` WHERE `id_lang` = XX AND `id_country` = XX LIMIT XX
5 queries	SELECT * FROM `preXX_country` a LEFT JOIN `preXX_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
5 queries	SELECT * FROM `preXX_country_lang` WHERE `id_country` = XX
5 queries	SELECT quantity, reserved_quantity FROM `preXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
4 queries	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `preXX_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 `preXX_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 `preXX_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT count(id_wishlist_product) FROM preXX_wishlist w, preXX_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=XX LIMIT XX
3 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `preXX_module` m LEFT JOIN `preXX_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
3 queries	SELECT tr.* FROM `preXX_tax_rule` tr JOIN `preXX_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 `id_lang` FROM `preXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
2 queries	SELECT ctg.`id_group` FROM preXX_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT id_module as id, active FROM preXX_module WHERE name = "pm_advancedcookiebanner" AND active = XX
2 queries	SELECT `id_category` FROM `preXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `preXX_attribute` a LEFT JOIN `preXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `preXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN preXX_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 `preXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `preXX_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
2 queries	SELECT * FROM preXX_product_attachment pa LEFT JOIN preXX_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN preXX_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX) WHERE pa.id_product = XX
2 queries	SELECT * FROM `preXX_product_attribute_lang` WHERE `id_product_attribute` = XX
2 queries	SELECT * FROM `preXX_product_attribute` a LEFT JOIN `preXX_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
2 queries	SELECT product_attribute_shop.`price` FROM `preXX_product_attribute` pa INNER JOIN preXX_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
2 queries	SELECT pa.`available_date` FROM `preXX_product` p LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN preXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN preXX_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
2 queries	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, XX) 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( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute FROM `preXX_product` p INNER JOIN preXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `preXX_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = XX LEFT JOIN `preXX_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `preXX_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = XX LEFT JOIN `preXX_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `preXX_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX LEFT JOIN preXX_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX AND stock.id_shop_group = XX ) WHERE (product_shop.`active` = XX) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "XX-XX-XX XX:XX:XX", INTERVAL XX DAY ) ) > XX) AND (EXISTS(SELECT XX FROM `preXX_category_product` cp JOIN `preXX_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =XX) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT XX

Next Tech Techline LX6

Next Tech Techline LX6

Next Tech Techline LX6

Next Tech Techline LX6

Stopwatch SQL - 2073 queries

Doubles

Tables stress

ObjectModel instances

Included Files

Module	Time	Memory Usage
gmerchantcenter	111.463 ms	2.28 Mb
__construct	111.463 ms	2.28 Mb
alma	12.052 ms	1.59 Mb
__construct	8.955 ms	1.31 Mb
hookModuleRoutes	0.074 ms	0.01 Mb
hookHeader	2.632 ms	0.24 Mb
hookDisplayProductPriceBlock	0.246 ms	0.03 Mb
hookDisplayProductPriceBlock	0.015 ms	- Mb
hookDisplayProductPriceBlock	0.022 ms	- Mb
hookDisplayProductPriceBlock	0.012 ms	- Mb
hookDisplayProductPriceBlock	0.011 ms	- Mb
hookDisplayProductPriceBlock	0.020 ms	- Mb
hookDisplayProductPriceBlock	0.012 ms	- Mb
hookDisplayProductPriceBlock	0.009 ms	- Mb
hookDisplayProductPriceBlock	0.022 ms	- Mb
hookDisplayProductPriceBlock	0.012 ms	- Mb
hookDisplayProductPriceBlock	0.010 ms	- Mb
blockreassurance	2.325 ms	0.15 Mb
__construct	2.193 ms	0.14 Mb
hookActionFrontControllerSetMedia	0.122 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.004 ms	- Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
ps_socialfollow	1.337 ms	0.09 Mb
__construct	0.058 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.031 ms	- Mb
displaySocialMediaBlock	1.248 ms	0.07 Mb
ps_emailalerts	0.165 ms	0.06 Mb
__construct	0.126 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.039 ms	- Mb
ps_searchbar	0.185 ms	0.02 Mb
__construct	0.071 ms	0.02 Mb
hookDisplayHeader	0.114 ms	- Mb
ps_shoppingcart	3.400 ms	0.20 Mb
__construct	0.056 ms	0.02 Mb
hookDisplayHeader	0.020 ms	- Mb
displayNavShoppingCartBlock	3.324 ms	0.18 Mb
tvcmstabproducts	0.307 ms	0.09 Mb
__construct	0.226 ms	0.09 Mb
hookDisplayHeader	0.081 ms	- Mb
tvcmscustomerservices	0.519 ms	0.11 Mb
__construct	0.176 ms	0.05 Mb
hookDisplayHeader	0.050 ms	- Mb
hookDisplayLeftColumn	0.293 ms	0.06 Mb
tvcmscustomsetting	4.035 ms	0.32 Mb
__construct	0.266 ms	0.05 Mb
hookDisplayHeader	0.286 ms	0.01 Mb
hookDisplayTopOfferText	0.011 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayCustomsocialblock	3.329 ms	0.24 Mb
hookDisplayCopyRightText	0.137 ms	0.02 Mb
tvcmsfooterlogo	0.354 ms	0.07 Mb
__construct	0.169 ms	0.05 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayFooterPart2	0.183 ms	0.03 Mb
tvcmsfooterproduct	0.136 ms	0.04 Mb
__construct	0.103 ms	0.03 Mb
hookDisplayHeader	0.033 ms	- Mb
tvcmsmultibanner1	0.213 ms	0.05 Mb
__construct	0.165 ms	0.04 Mb
hookDisplayHeader	0.048 ms	- Mb
tvcmspaymenticon	1.385 ms	0.17 Mb
__construct	0.157 ms	0.11 Mb
hookDisplayHeader	0.002 ms	- Mb
hookDisplayPaymentIcon	1.226 ms	0.06 Mb
tvcmsslider	0.244 ms	0.05 Mb
__construct	0.185 ms	0.05 Mb
hookDisplayHeader	0.059 ms	- Mb
tvcmsstockinfo	0.179 ms	0.03 Mb
__construct	0.102 ms	0.03 Mb
hookHeader	0.053 ms	- Mb
hookDisplayProductListStockIndicator	0.015 ms	- Mb
hookDisplayProductListStockIndicator	0.009 ms	- Mb
tvcmswishlist	4.645 ms	0.29 Mb
__construct	0.114 ms	0.04 Mb
hookDisplayHeader	0.067 ms	- Mb
hookDisplayNavWishlistBlock	1.146 ms	0.06 Mb
hookDisplayNavWishlistBlock	1.492 ms	0.05 Mb
hookDisplayWishlistBtnProductList	0.201 ms	0.03 Mb
hookDisplayWishlistBtnProductList	0.176 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.177 ms	0.01 Mb
hookDisplayWishlistBtnProductList	0.173 ms	0.01 Mb
hookDisplayNavWishlistBlocksticky	1.099 ms	0.07 Mb
tvcmscategorychainslider	0.220 ms	0.11 Mb
__construct	0.176 ms	0.11 Mb
hookDisplayHeader	0.044 ms	- Mb
tvcmsnewsletterpopup	0.256 ms	0.04 Mb
__construct	0.169 ms	0.04 Mb
hookDisplayHeader	0.087 ms	- Mb
tvcmscookiesnotice	0.411 ms	0.07 Mb
__construct	0.161 ms	0.05 Mb
hookDisplayHeader	0.046 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.204 ms	0.02 Mb
tvcmsproductcomments	5.635 ms	0.55 Mb
__construct	0.146 ms	0.06 Mb
hookDisplayHeader	0.138 ms	- Mb
hookDisplayReviewProductList	1.997 ms	0.14 Mb
hookDisplayReviewProductList	1.123 ms	0.09 Mb
hookDisplayReviewProductList	1.154 ms	0.16 Mb
hookDisplayReviewProductList	1.077 ms	0.09 Mb
tvcmsbrandlist	0.212 ms	0.05 Mb
__construct	0.168 ms	0.05 Mb
hookDisplayHeader	0.044 ms	- Mb
tvcmsproductpopup	130.647 ms	2.41 Mb
__construct	0.051 ms	0.03 Mb
hookDisplayHeader	0.043 ms	- Mb
hookDisplayAfterBodyOpeningTag	130.553 ms	2.38 Mb
tvcmscategoryslider	0.211 ms	0.12 Mb
__construct	0.168 ms	0.11 Mb
hookDisplayHeader	0.043 ms	- Mb
tvcmsbestsellerproducts	135.954 ms	1.47 Mb
__construct	0.089 ms	0.01 Mb
hookDisplayHeader	0.029 ms	- Mb
hookDisplayLeftColumn	135.836 ms	1.46 Mb
tvcmsfeaturedproducts	73.919 ms	1.78 Mb
__construct	0.079 ms	0.02 Mb
hookDisplayHeader	0.026 ms	- Mb
hookDisplayLeftColumn	73.814 ms	1.76 Mb
tvcmsnewproducts	22.482 ms	0.70 Mb
__construct	0.081 ms	0.02 Mb
hookDisplayHeader	0.024 ms	- Mb
hookDisplayLeftColumn	22.377 ms	0.68 Mb
tvcmsproductcompare	1.382 ms	0.17 Mb
__construct	0.082 ms	0.02 Mb
hookDisplayHeader	0.042 ms	- Mb
hookDisplayNavProductCompareBlock	0.195 ms	0.01 Mb
hookDisplayNavProductCompareBlock	0.162 ms	0.01 Mb
hookDisplayProductCompareProductList	0.199 ms	0.08 Mb
hookDisplayProductCompareProductList	0.172 ms	0.01 Mb
hookDisplayProductCompareProductList	0.169 ms	0.01 Mb
hookDisplayProductCompareProductList	0.162 ms	0.01 Mb
hookDisplayProductComparesticky	0.199 ms	0.01 Mb
tvcmssearch	2.884 ms	0.28 Mb
__construct	0.074 ms	0.02 Mb
hookDisplayHeader	0.096 ms	- Mb
hookDisplayNavSearchBlock	2.714 ms	0.26 Mb
tvcmsspecialproducts	1827 ms	35.61 Mb
__construct	0.077 ms	0.02 Mb
hookDisplayHeader	0.026 ms	- Mb
hookDisplayLeftColumn	1827 ms	35.59 Mb
tvcmsthemeoptions	0.208 ms	0.02 Mb
__construct	0.085 ms	0.02 Mb
hookDisplayHeader	0.123 ms	- Mb
cdc_googletagmanager	10.183 ms	0.53 Mb
__construct	0.335 ms	0.14 Mb
hookDisplayHeader	0.036 ms	- Mb
hookDisplayAfterTitleTag	9.598 ms	0.35 Mb
hookDisplayAfterTitleTag	0.002 ms	- Mb
hookDisplayAfterBodyOpeningTag	0.185 ms	0.02 Mb
hookDisplayProductPriceBlock	0.003 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.002 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayProductPriceBlock	0.001 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.010 ms	- Mb
ganalyticspro	17.847 ms	0.35 Mb
__construct	0.242 ms	0.09 Mb
hookDisplayHeader	17.600 ms	0.26 Mb
hookDisplayFooter	0.005 ms	- Mb
pm_advancedcookiebanner	0.271 ms	0.04 Mb
__construct	0.271 ms	0.04 Mb
ets_advancedcaptcha	0.174 ms	0.10 Mb
__construct	0.155 ms	0.10 Mb
hookDisplayHeader	0.012 ms	- Mb
hookDisplayOverrideTemplate	0.007 ms	- Mb
tvcmsinfinitescroll	9.380 ms	0.08 Mb
__construct	0.114 ms	0.02 Mb
hookHeader	9.266 ms	0.06 Mb
tvcmsofferbanner	0.230 ms	0.03 Mb
__construct	0.174 ms	0.03 Mb
hookHeader	0.056 ms	- Mb
tvcmstwoofferbanner	0.196 ms	0.04 Mb
__construct	0.148 ms	0.03 Mb
hookHeader	0.048 ms	- Mb
tvcmsmegamenu	5.272 ms	0.46 Mb
__construct	0.190 ms	0.13 Mb
hookHeader	0.061 ms	- Mb
hookDisplayMegamenu	5.021 ms	0.32 Mb
tvcmscategoryproduct	0.240 ms	0.05 Mb
__construct	0.179 ms	0.05 Mb
hookHeader	0.061 ms	- Mb
ps_facetedsearch	0.995 ms	0.19 Mb
__construct	0.495 ms	0.05 Mb
hookProductSearchProvider	0.318 ms	0.07 Mb
hookDisplayFacetedSearchBlock	0.182 ms	0.07 Mb
tvcmscustomcssjs	0.238 ms	0.03 Mb
__construct	0.225 ms	0.03 Mb
hookDisplayCustomCss	0.007 ms	- Mb
hookDisplayCustomJs	0.006 ms	- Mb
ps_languageselector	1.317 ms	0.07 Mb
__construct	0.077 ms	0.02 Mb
displayNavLanguageBlock	1.240 ms	0.05 Mb
ps_currencyselector	0.958 ms	0.07 Mb
__construct	0.069 ms	0.02 Mb
displayNavCurrencyBlock	0.889 ms	0.05 Mb
ps_customersignin	1.304 ms	0.08 Mb
__construct	0.062 ms	0.02 Mb
displayNavCustomerSignInBlock	1.242 ms	0.06 Mb
ps_contactinfo	6.459 ms	0.15 Mb
__construct	0.076 ms	0.02 Mb
displayNav1	5.573 ms	0.09 Mb
displayContactCinfo	0.810 ms	0.04 Mb
ps_categorytree	8.020 ms	0.40 Mb
__construct	0.070 ms	0.02 Mb
displayLeftColumn	7.950 ms	0.38 Mb
ps_brandlist	1.320 ms	0.07 Mb
__construct	0.084 ms	0.02 Mb
displayLeftColumn	1.236 ms	0.05 Mb
ps_supplierlist	0.976 ms	0.07 Mb
__construct	0.069 ms	0.02 Mb
displayLeftColumn	0.907 ms	0.06 Mb
tvcmsfootercategory	5.466 ms	0.29 Mb
__construct	0.227 ms	0.03 Mb
hookDisplayFooterCategory	5.239 ms	0.26 Mb
ps_linklist	1.417 ms	0.09 Mb
__construct	0.239 ms	0.03 Mb
displayFooterPart1	1.178 ms	0.06 Mb
ps_customeraccountlinks	1.232 ms	0.08 Mb
__construct	0.064 ms	0.02 Mb
displayMyaccountcblock	1.168 ms	0.07 Mb
52 module(s)	2418 ms	52.26 Mb

Name	Instances	Source
Category	36	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 37] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 36] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 42] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 49] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 58] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ganalyticspro/lib/gtag/categoryTag.php:57 (__construct) [id: 2] /modules/ganalyticspro/lib/moduleTools.php:141 (__construct) [id: 2] /modules/ganalyticspro/lib/moduleTools.php:141 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 2] /modules/cdc_googletagmanager/classes/gtm/DataLayerItem.php:109 (__construct) [id: 111] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1374 (__construct) [id: 2] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 110] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 37] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1323 (__construct) [id: 110] /modules/cdc_googletagmanager/cdc_googletagmanager.php:1313 (__construct) [id: 2] /modules/tvcmssearch/tvcmssearch.php:100 (getNestedCategories) [id: 2] /modules/ps_categorytree/ps_categorytree.php:368 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:361 (getParentsCategories) [id: 2] /modules/tvcmstabproducts/tvcmstabproducts.php:2683 (__construct) [id: 118] /classes/Link.php:402 (__construct) [id: 118] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 37] /classes/Link.php:402 (__construct) [id: 37] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 36] /classes/Link.php:402 (__construct) [id: 36] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 42] /classes/Link.php:402 (__construct) [id: 42] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 49] /classes/Link.php:402 (__construct) [id: 49] /modules/tvcmsfootercategory/tvcmsfootercategory.php:401 (__construct) [id: 58] /classes/Link.php:402 (__construct) [id: 58]
Product	30	/src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 570] /modules/cdc_googletagmanager/services/Gtm_Product.php:164 (__construct) [id: 570] /classes/Link.php:113 (__construct) [id: 799] /classes/Link.php:113 (__construct) [id: 798] /classes/Link.php:113 (__construct) [id: 788] /classes/Link.php:113 (__construct) [id: 783] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 799] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 797] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 788] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 783] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 799] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 798] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 797] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 788] /classes/Link.php:113 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 543] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 389] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 321] /classes/Link.php:113 (__construct) [id: 612] /classes/Link.php:113 (__construct) [id: 453] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 612] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 178] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 351] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 453] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 281] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 300] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 347] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 136]
Country	18	/config/config.inc.php:146 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 8] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 19] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 4] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 3] /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) [id: 188] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1779 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Language	13	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:183 (__construct) [id: 1]
Currency	10	/modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 1] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 0] /modules/gmerchantcenter/lib/moduleTools.php:193 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /classes/Tools.php:690 (getCurrencyInstance) [id: 1]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5964 (__construct) [id: ]
State	3	/classes/controller/FrontController.php:1778 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
AddressFormat	3	/classes/controller/FrontController.php:1773 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Combination	2	/classes/Product.php:5912 (__construct) [id: 37] /classes/Product.php:5912 (__construct) [id: 50]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
TvcmsMegaMenuClass	1	/modules/tvcmsmegamenu/tvcmsmegamenu.php:1384 (__construct) [id: ]
Image	1	/modules/alma/lib/Services/ImageService.php:46 (__construct) [id: ]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1705 (__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]
Gender	1	/classes/controller/FrontController.php:1702 (__construct) [id: 0]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
119	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=12)) GROUP BY fp.id_feature_value	118.284 ms	2300	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1997	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2024-11-11 00:00:00", INTERVAL 1000 DAY)) > 0 AS new FROM `pre2469_product_sale` ps LEFT JOIN `pre2469_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN pre2469_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_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 `pre2469_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `pre2469_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 `pre2469_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pre2469_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `pre2469_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 8 AND tr.`id_state` = 0 LEFT JOIN `pre2469_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN pre2469_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 `pre2469_category_product` cp JOIN `pre2469_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	60.832 ms	575	Yes		/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:74 (getBestSales) /modules/tvcmstabproducts/tvcmstabproducts.php:2879 (runQuery) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1922	SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value FROM pre2469_feature_product pf LEFT JOIN pre2469_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN pre2469_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN pre2469_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN pre2469_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 321 ORDER BY f.position ASC	29.845 ms	6	Yes		/classes/Product.php:6021 /classes/Product.php:5824 (getFrontFeaturesStatic) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3404 (getProductsProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1925	SELECT SQL_NO_CACHE * FROM `pre2469_product_attribute_lang` WHERE `id_product_attribute` = 37	21.236 ms	1			/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:5912 (__construct) /classes/Product.php:5875 (computeUnitPriceRatio) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3404 (getProductsProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
121	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=13)) AND ((fp_1.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) GROUP BY fp.id_feature_value	21.063 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
295	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, DATEDIFF( p.`date_add`, DATE_SUB( "2024-11-11 00:00:00", INTERVAL 1000 DAY ) ) > 0 AS new FROM `pre2469_product` p INNER JOIN pre2469_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_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 pre2469_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 `pre2469_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `pre2469_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 `pre2469_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pre2469_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) WHERE product_shop.`active` = 1 AND product_shop.`show_price` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.`id_product` IN (288, 193, 289, 145, 297, 290, 212, 329, 48, 192, 249, 354, 165, 50, 20, 427, 89, 304, 63, 170, 144, 197, 343, 103, 330, 380, 140, 366, 428, 281, 150, 231, 376, 244, 390, 393, 400, 199, 345, 105, 77, 250, 158, 295, 332, 347, 300, 107, 143, 49, 246, 264, 24, 194, 125, 31, 381, 410, 47, 191, 97, 344, 227, 372, 132, 429, 101, 151, 98, 243, 389, 382, 92, 211, 308, 407, 169, 70, 216, 342, 196, 121, 267, 27, 172, 434, 315, 439, 213, 431, 441, 442, 178, 454, 13, 456, 136, 455, 460, 472, 476, 483, 478, 479, 486, 487, 488, 489, 461, 78, 299, 204, 349, 109, 188, 44, 426, 74, 220, 52, 512, 513, 514, 503, 338, 195, 341, 515, 517, 516, 534, 540, 541, 386, 543, 544, 545, 546, 242, 337, 518, 554, 296, 452, 578, 235, 582, 473, 585, 164, 260, 311, 581, 594, 598, 599, 600, 71, 217, 606, 607, 614, 255, 15, 287, 108, 586, 61, 58, 526, 524, 527, 525, 588, 589, 111, 26, 391, 632, 356, 362, 597, 668, 669, 88, 671, 672, 666, 361, 601, 175, 30, 280, 321, 573, 677, 679, 142, 699, 67, 701, 702, 312, 704, 351, 622, 595, 711, 257, 179, 720, 721, 722, 723, 724, 725, 726, 727, 729, 731, 753, 754, 700, 273, 65, 438, 542, 610, 611, 608, 799, 224, 251, 485, 713, 457, 612) AND EXISTS(SELECT 1 FROM `pre2469_category_product` cp JOIN `pre2469_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)	18.552 ms	575			/classes/Product.php:3393 /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
117	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=11)) AND ((fp_1.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) GROUP BY fp.id_feature_value	18.130 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	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 `pre2469_feature_value` v LEFT JOIN `pre2469_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre2469_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` = 20 ORDER BY vl.`value` ASC	17.029 ms	3	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
115	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=8)) AND ((fp_1.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) GROUP BY fp.id_feature_value	16.658 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1283	SELECT SQL_NO_CACHE 1 FROM `pre2469_specific_price` WHERE id_product = 439 LIMIT 1	15.997 ms	1			/classes/SpecificPrice.php:435 /classes/SpecificPrice.php:523 (couldHaveSpecificPrice) /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
127	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=16)) AND ((fp_1.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) GROUP BY fp.id_feature_value	15.724 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1285	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `pre2469_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 439 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	15.397 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /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 `pre2469_module` m INNER JOIN pre2469_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 `pre2469_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `pre2469_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pre2469_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`	14.864 ms	2145	Yes	Yes	/classes/Hook.php:1267 /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)
491	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pre2469_product_shop` WHERE `id_product` = 98 AND id_shop=1 LIMIT 1	14.579 ms	1			/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2034	SELECT SQL_NO_CACHE `id_product_attribute` FROM `pre2469_product_attribute` WHERE `id_product` = 347	14.065 ms	1			/classes/Product.php:2902 /src/Adapter/Image/ImageRetriever.php:90 (getCombinationImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2913 (present) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tvcmsbestsellerproducts/tvcmsbestsellerproducts.php:269 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
123	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=14)) AND ((fp_1.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) GROUP BY fp.id_feature_value	13.558 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
131	REPLACE INTO pre2469_layered_filter_block (hash, data) VALUES ("2701b80a8aab06f173cac79717e5be84", "a:1:{s:7:\"filters\";a:10:{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:8:{i:111;a:2:{s:4:\"name\";s:19:\"Les tondeuses robot\";s:3:\"nbr\";s:1:\"1\";}i:131;a:2:{s:4:\"name\";s:25:\"Gamme urbaine - essential\";s:3:\"nbr\";s:1:\"1\";}i:133;a:2:{s:4:\"name\";s:27:\"Gamme grand espace - expert\";s:3:\"nbr\";s:1:\"1\";}i:160;a:2:{s:4:\"name\";s:19:\"Tondeuses thermique\";s:3:\"nbr\";s:1:\"6\";}i:162;a:2:{s:4:\"name\";s:21:\"Tondeuses à batterie\";s:3:\"nbr\";s:1:\"2\";}i:164;a:2:{s:4:\"name\";s:10:\"Les riders\";s:3:\"nbr\";s:1:\"4\";}i:184;a:2:{s:4:\"name\";s:11:\"Gamme Stiga\";s:3:\"nbr\";s:1:\"1\";}i:190;a:2:{s:4:\"name\";s:11:\"Gamme Stiga\";s:3:\"nbr\";s:1:\"1\";}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:1;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:8300;s:3:\"min\";d:469;s:4:\"unit\";s:3:\"€\";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:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";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:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:13;s:5:\"value\";N;}i:2;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:1:\"8\";s:6:\"values\";a:4:{i:13985;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:6:\"Dormak\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:37;a:4:{s:3:\"nbr\";s:1:\"6\";s:4:\"name\";s:11:\"Outils-Wolf\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:35;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"Stiga\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:41;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:18:\"Zucchetti Techline\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:14:\"Marque Machine\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:3;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"11\";s:6:\"values\";a:2:{i:43;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:8:\"Batterie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:44;a:4:{s:3:\"nbr\";s:2:\"10\";s:4:\"name\";s:7:\"Essence\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:12:\"Alimentation\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:4;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"12\";s:6:\"values\";a:68:{i:20980;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21970;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20981;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21165;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21886;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22204;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"18 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22191;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20383;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21718;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21676;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21675;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21552;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21138;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21139;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"20 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22201;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"22 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22202;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"22 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22206;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"22 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22263;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"22 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21252;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"25 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21436;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"25 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20988;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"25 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20989;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"25 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21888;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"26 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21887;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"26 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21801;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"29 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21441;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"29 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20986;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"29 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20987;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"29 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14657;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"30 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14658;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"34 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:15122;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"35 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22200;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"35 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21066;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"35 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22199;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"35 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21167;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"36 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:14659;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"37 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14660;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"41 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14681;a:5:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"42 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:14661;a:4:{s:3:\"nbr\";s:2:\"18\";s:4:\"name\";s:5:\"46 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14662;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:5:\"48 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14663;a:4:{s:3:\"nbr\";s:2:\"11\";s:4:\"name\";s:5:\"51 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22059;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"51 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22065;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"51 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22062;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"51 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22068;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"51 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21513;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"52 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21510;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"52 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21258;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"52 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14664;a:5:{s:3:\"nbr\";s:1:\"7\";s:4:\"name\";s:5:\"53 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:14666;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"66 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14667;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"72 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14779;a:5:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"80 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}i:14668;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"84 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14669;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"85 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14670;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"92 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22010;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"92 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22007;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:5:\"92 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14671;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:5:\"95 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14673;a:4:{s:3:\"nbr\";s:1:\"9\";s:4:\"name\";s:5:\"98 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14672;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:6:\"100 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14674;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:6:\"102 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22033;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"105 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:21762;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"108 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14675;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:6:\"108 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14676;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"110 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14680;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"121 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14677;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"122 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14678;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:6:\"125 cm\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:16:\"Largeur de coupe\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:5;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"13\";s:6:\"values\";a:2:{i:52;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Electrique\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:51;a:4:{s:3:\"nbr\";s:1:\"5\";s:4:\"name\";s:7:\"Lanceur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Démarrage\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"14\";s:6:\"values\";a:3:{i:56;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:3:\"Non\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:54;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:3:\"Oui\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:55;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:18:\"Oui avec variateur\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:8:\"Tractée\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:7;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"15\";s:6:\"values\";a:4:{i:57;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:5:\"Acier\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:58;a:4:{s:3:\"nbr\";s:1:\"2\";s:4:\"name\";s:16:\"Acier galvanisé\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:59;a:4:{s:3:\"nbr\";s:1:\"3\";s:4:\"name\";s:9:\"Aluminium\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:60;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:10:\"Composites\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:14:\"Type de carter\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:8;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"16\";s:6:\"values\";a:1:{i:69;a:4:{s:3:\"nbr\";s:1:\"1\";s:4:\"name\";s:2:\"XL\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:7:\"Surface\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}i:9;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";s:2:\"20\";s:6:\"values\";a:1:{i:133;a:4:{s:3:\"nbr\";s:1:\"4\";s:4:\"name\";s:13:\"Hydrostatique\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:10:\"Avancement\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";s:1:\"0\";}}}")	12.942 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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
120	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 `pre2469_feature_value` v LEFT JOIN `pre2469_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre2469_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` = 12 ORDER BY vl.`value` ASC	12.631 ms	81	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE id_product, name, value, pf.id_feature FROM pre2469_feature_product pf LEFT JOIN pre2469_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN pre2469_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN pre2469_feature f ON (f.id_feature = pf.id_feature) INNER JOIN pre2469_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE `id_product` IN (799,798,797,788,783) ORDER BY f.position ASC	12.491 ms	11	Yes		/classes/Product.php:4904 /classes/Product.php:3125 (cacheFrontFeatures) /modules/tvcmsproductpopup/tvcmsproductpopup.php:368 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:253 (getNewProducts) /modules/tvcmsproductpopup/tvcmsproductpopup.php:547 (prevHook) /classes/Hook.php:1077 (hookdisplayAfterBodyOpeningTag) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:116 (__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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:54 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
124	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 `pre2469_feature_value` v LEFT JOIN `pre2469_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre2469_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` = 14 ORDER BY vl.`value` ASC	12.356 ms	3	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
6	SELECT SQL_NO_CACHE * FROM `pre2469_country` a LEFT JOIN `pre2469_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `pre2469_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 8) LIMIT 1	12.272 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /config/config.inc.php:146 (__construct) /index.php:27 (require)
106	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `pre2469_feature` f INNER JOIN pre2469_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `pre2469_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `pre2469_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `pre2469_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	11.222 ms	40	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
49	SELECT SQL_NO_CACHE * FROM `pre2469_country_lang` WHERE `id_country` = 4	11.203 ms	1			/src/Adapter/EntityMapper.php:79 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /modules/gmerchantcenter/lib/moduleTools.php:188 (__construct) /modules/gmerchantcenter/gmerchantcenter.php:87 (getLangCurrencyCountry) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
19	show tables like "pre2469_gmc_feeds"	10.266 ms	1			/modules/gmerchantcenter/lib/moduleTools.php:1711 /modules/gmerchantcenter/gmerchantcenter.php:85 (checkTableExist) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
41	SELECT SQL_NO_CACHE c.id_currency FROM `pre2469_currency` c WHERE (deleted = 0) AND (iso_code = 'MAD') LIMIT 1	10.242 ms	1			/classes/Currency.php:893 /modules/gmerchantcenter/lib/moduleTools.php:192 (getIdByIsoCode) /modules/gmerchantcenter/gmerchantcenter.php:87 (getLangCurrencyCountry) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
128	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 `pre2469_feature_value` v LEFT JOIN `pre2469_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre2469_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` = 16 ORDER BY vl.`value` ASC	10.180 ms	9	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
62	SELECT SQL_NO_CACHE * FROM `pre2469_category` a LEFT JOIN `pre2469_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `pre2469_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1	9.603 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:78 (__construct) /tools/profiling/Controller.php:41 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1336	SELECT SQL_NO_CACHE `reduction` FROM `pre2469_product_group_reduction_cache` WHERE `id_product` = 457 AND `id_group` = 1 LIMIT 1	9.430 ms	0			/classes/GroupReduction.php:156 /classes/Product.php:3990 (getValueForProduct) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
125	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN pre2469_feature_product fp_1 ON (p.id_product = fp_1.id_product) WHERE ((fp.id_feature=15)) AND ((fp_1.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) GROUP BY fp.id_feature_value	9.252 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1583	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `pre2469_product` p INNER JOIN `pre2469_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 581)	8.998 ms	1			/classes/Product.php:3860 /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1927	SELECT SQL_NO_CACHE * FROM `pre2469_product` a LEFT JOIN `pre2469_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `pre2469_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 543) AND (b.`id_shop` = 1) LIMIT 1	8.974 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:688 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/tvcmstabproducts/tvcmstabproducts.php:2851 (present) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `pre2469_configuration` c LEFT JOIN `pre2469_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	8.900 ms	1616			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
1923	SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `pre2469_attribute` a LEFT JOIN `pre2469_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `pre2469_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `pre2469_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN pre2469_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1) LEFT JOIN `pre2469_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 321 AND pac.`id_product_attribute` = 37 AND agl.`id_lang` = 1	8.899 ms	1			/classes/Product.php:7534 /classes/Product.php:5857 (getAttributesParams) /classes/Product.php:5990 (getProductProperties) /classes/Product.php:3404 (getProductsProperties) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
110	SELECT SQL_NO_CACHE p.id_product 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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	8.743 ms	60	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
113	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, cp.position FROM pre2469_product p LEFT JOIN pre2469_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre2469_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre2469_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 pre2469_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157 GROUP BY p.id_product) p INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND cg.id_group='1' AND c.nleft>2 AND c.nright<157 GROUP BY cp.id_category	8.087 ms	240	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:778 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM pre2469_product p INNER JOIN pre2469_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 = 8) INNER JOIN pre2469_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre2469_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre2469_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre2469_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN pre2469_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (20992, 21167, 14681, 14664, 14779))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=157	8.057 ms	15			/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:57 (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:139 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1265	SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `pre2469_product` p INNER JOIN `pre2469_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre2469_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 429)	7.339 ms	1			/classes/Product.php:3860 /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1287	SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `pre2469_product_shop` WHERE `id_product` = 439 AND id_shop=1 LIMIT 1	6.997 ms	1			/classes/Product.php:6876 /classes/Product.php:3925 (getIdTaxRulesGroupByIdProduct) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1138	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `pre2469_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 362 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-11-11 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	6.946 ms	1	Yes		/classes/SpecificPrice.php:576 /classes/Product.php:3827 (getSpecificPrice) /classes/Product.php:3717 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tvcmstabproducts/tvcmstabproducts.php:2817 (getPricesDrop) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:157 (displaySpecialProducts) /modules/tvcmsspecialproducts/tvcmsspecialproducts.php:268 (showFrontSideResult) /classes/Hook.php:1077 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:983 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/prod/smarty/compile/v1_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_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_gardenia_11layouts_layout_left_column_tpl/1a/89/a7/1a89a734d096f5ad14ad4dbb33891e0facb00120_2.file.layout-both-columns.tpl.php:74 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29f16874_07033251) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/6d/33/66/6d33663adfbf67f07eddb2df7d930f4c5287edb8_2.file.layout-left-column.tpl.php:28 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29efacf3_58320531) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/82/55/0e/82550e22f895f1760ff1e1a0c2d6c8c47e0de299_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29eea393_23821434) /vendor/smarty/smarty/libs/sysplugins/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_gardenia_11layouts_layout_left_column_tpl/37/3d/2c/373d2ce4c1a83676f8228aca20a47aac483b040b_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_67293b29ed0a52_43895681) /vendor/smarty/smarty/libs/sysplugins/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:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
21	SELECT SQL_NO_CACHE * FROM `pre2469_gmc_feeds` ff WHERE (ff.id_shop=1)	6.762 ms	370			/modules/gmerchantcenter/models/Feeds.php:59 /modules/gmerchantcenter/lib/moduleTools.php:176 (getAvailableFeeds) /modules/gmerchantcenter/gmerchantcenter.php:87 (getLangCurrencyCountry) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1258 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1237 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
13	/vendor/symfony/polyfill-intl-idn/bootstrap.php
14	/vendor/symfony/deprecation-contracts/function.php
15	/vendor/ralouphie/getallheaders/src/getallheaders.php
16	/vendor/symfony/polyfill-ctype/bootstrap.php
17	/vendor/symfony/polyfill-php80/bootstrap.php
18	/vendor/guzzlehttp/promises/src/functions_include.php
19	/vendor/guzzlehttp/promises/src/functions.php
20	/vendor/guzzlehttp/guzzle/src/functions_include.php
21	/vendor/guzzlehttp/guzzle/src/functions.php
22	/vendor/symfony/polyfill-iconv/bootstrap.php
23	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
24	/vendor/jakeasmith/http_build_url/src/http_build_url.php
25	/vendor/lcobucci/jwt/compat/class-aliases.php
26	/vendor/lcobucci/jwt/src/Token.php
27	/vendor/lcobucci/jwt/src/Signature.php
28	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
29	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
30	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
31	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
32	/vendor/symfony/polyfill-intl-icu/bootstrap.php
33	/vendor/symfony/polyfill-php73/bootstrap.php
34	/vendor/symfony/polyfill-php81/bootstrap.php
35	/vendor/api-platform/core/src/deprecation.php
36	/vendor/api-platform/core/src/Api/FilterInterface.php
37	/vendor/api-platform/core/src/Api/ResourceClassResolverInterface.php
38	/vendor/api-platform/core/src/deprecated_interfaces.php
39	/vendor/api-platform/core/src/Metadata/Property/Factory/PropertyNameCollectionFactoryInterface.php

Oleo Mac OM109L-16K

Sécateur KP 280

Sécateur KP 295

Kress KG163E.9

Kress KA3713

Panier

Next Tech Techline LX6

Next Tech Techline LX6

Next Tech Techline LX6

Next Tech Techline LX6

Stopwatch SQL - 2073 queries

Doubles

Tables stress

ObjectModel instances

Included Files