Catégorie : Charpente 2 pans

Load Time 2602 ms
Querying Time 783 ms
Queries 386
Memory Peak Usage 61.8 Mb
Included Files 1240 files - 14.68 Mb
PrestaShop Cache - Mb
Global vars 1.03 Mb
PrestaShop Version 1.7.8.5
PHP Version 7.4.33
MySQL Version 8.0.39-30
Memory Limit 512M
Max Execution Time 165s
Smarty Cache disabled
Smarty Compilation force compile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 48 ms 48 ms 18.50 Mb 18.8 Mb
__construct 0 ms 48 ms - Mb 18.8 Mb
init 256 ms 305 ms 9.14 Mb 28.6 Mb
checkAccess 0 ms 305 ms - Mb 28.6 Mb
setMedia 42 ms 346 ms 2.83 Mb 30.6 Mb
postProcess 0 ms 346 ms - Mb 30.6 Mb
initHeader 0 ms 346 ms - Mb 30.6 Mb
initContent 1681 ms 2028 ms 23.55 Mb 54.1 Mb
initFooter 0 ms 2028 ms - Mb 54.1 Mb
display 574 ms 2602 ms 7.31 Mb 61.8 Mb
Hook Time Memory Usage
displayMainMenu 103 ms 2.03 Mb
DisplayHeader 99 ms 3.39 Mb
DisplayGform 77 ms 0.64 Mb
displayProductListReviews 53 ms 0.56 Mb
Header 47 ms 0.30 Mb
DisplayFooter 32 ms 0.67 Mb
displayAboveMobileMenu 22 ms 0.09 Mb
displayNav1 17 ms 0.19 Mb
displayLeftColumn 16 ms 0.10 Mb
ActionFrontControllerSetMedia 13 ms 0.66 Mb
ModuleRoutes 13 ms 0.74 Mb
displayNav2 11 ms 0.21 Mb
ActionOutputHTMLBefore 7 ms - Mb
displaySearch 6 ms 0.05 Mb
ProductSearchProvider 4 ms 0.18 Mb
displayAfterBreadcrumb 4 ms 0.03 Mb
DisplayLeftColumn 4 ms 0.01 Mb
DisplayAfterBodyOpeningTag 4 ms 0.02 Mb
DisplayGDPRConsent 3 ms 0.03 Mb
displayFooter 1 ms 0.03 Mb
DisplayTop 1 ms 0.01 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayBeforeBodyClosingTag 0 ms - Mb
DisplayProductPriceBlock 0 ms 0.01 Mb
displayVerticalMenu 0 ms - Mb
ActionDispatcher 0 ms - Mb
ActionProductSearchAfter 0 ms - Mb
Top 0 ms - Mb
28 hook(s) 538 ms 9.93 Mb
Module Time Memory Usage
configurator 59 ms 4.91 Mb
gformbuilderpro 85 ms 1.40 Mb
ps_mbo 6 ms 0.26 Mb
iqitthemeeditor 6 ms 0.53 Mb
ps_emailsubscription 4 ms 0.38 Mb
ps_checkout 32 ms 1.68 Mb
ps_facebook 31 ms 1.32 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 80 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 56 ms 6.76 Mb
iqitcontactpage 1 ms 0.06 Mb
iqitcountdown 1 ms 0.04 Mb
iqitlinksmanager 27 ms 0.44 Mb
iqitsociallogin 1 ms 0.07 Mb
productcomments 3 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 6 ms 0.20 Mb
ets_recaptcha_free 1 ms 0.23 Mb
ps_searchbar 6 ms 0.08 Mb
iqitelementor 35 ms 1.15 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 109 ms 2.77 Mb
iqitreviews 56 ms 0.71 Mb
iqitsizecharts 3 ms 0.18 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 37 ms 0.21 Mb
ps_facetedsearch 14 ms 0.63 Mb
psgdpr 5 ms 0.22 Mb
ps_languageselector 2 ms 0.13 Mb
ps_currencyselector 1 ms 0.07 Mb
pagesnotfound 2 ms 0.21 Mb
sekeywords 1 ms 0.21 Mb
iqitsearch 1 ms - Mb
ps_customersignin 0 ms 0.02 Mb
iqitproductsnav 5 ms 0.23 Mb
ps_categorytree 13 ms 0.14 Mb
37 module(s) 706 ms 29.88 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 386 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE id_gform_analytics 
FROM `cdf_gform_analytics` 
WHERE id_gformbuilderpro = 6 AND 
ip_address = "18.97.14.88" AND 
id_customer = 0 AND 
browser = "unknown" AND 
platform = "unknown" AND 
DAY(date_add) ="16" AND  
MONTH(date_add) ="01" AND 
YEAR(date_add) ="2025" LIMIT 1
 38681 ms 35022 /modules/gformbuilderpro/gformbuilderpro.php:380 
SELECT SQL_NO_CACHE p.id_product, p.price, psi.price_min, psi.price_max FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM cdf_product p LEFT JOIN cdf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cdf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cdf_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 cdf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cdf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cdf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cdf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cdf_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=16 AND c.nright<=17 GROUP BY p.id_product) p INNER JOIN cdf_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) GROUP BY p.id_product ORDER BY psi.price_min ASC, p.id_product DESC LIMIT 0, 12
 20519 ms 402 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE *
FROM `cdf_gformbuilderpro` a
LEFT JOIN `cdf_gformbuilderpro_lang` `b` ON a.`id_gformbuilderpro` = b.`id_gformbuilderpro` AND b.`id_lang` = 1
LEFT JOIN `cdf_gformbuilderpro_shop` `c` ON a.`id_gformbuilderpro` = c.`id_gformbuilderpro` AND c.`id_shop` = 1
WHERE (a.`id_gformbuilderpro` = 6) LIMIT 1
 18238 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE 1 FROM cdf_cart_product cp INNER JOIN cdf_product p
ON (p.id_product = cp.id_product) INNER JOIN cdf_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 16571 ms 1 /classes/Cart.php:4218 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 56
LIMIT 1
 14155 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 34) AND (b.`id_shop` = 1) LIMIT 1
 12527 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `cdf_module` m
INNER JOIN cdf_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 `cdf_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `cdf_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `cdf_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `cdf_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`
 11989 ms 2100 Yes Yes /classes/Hook.php:1183 
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
 11786 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127 
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 `cdf_configuration` c
LEFT JOIN `cdf_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 11721 ms 1308 /classes/Configuration.php:160 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `cdf_lang` l
LEFT JOIN `cdf_lang_shop` ls ON (l.id_lang = ls.id_lang)
 11202 ms 1 /classes/Language.php:1049 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 53
LIMIT 1
 10478 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 104 LIMIT 1
 9459 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE a.*, b.`name`, b.`description`
FROM `cdf_lgcookieslaw_purpose` a
LEFT JOIN `cdf_lgcookieslaw_purpose_lang` `b` ON (b.`id_lgcookieslaw_purpose` = a.`id_lgcookieslaw_purpose` AND b.`id_lang` = 1)
WHERE (a.`id_shop` = 1) AND (a.`active` = 1)
 9307 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (104) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 8935 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE *
FROM `cdf_country` a
LEFT JOIN `cdf_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `cdf_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 8923 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM cdf_iqitmegamenu_tabs_shop hs
LEFT JOIN cdf_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN cdf_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 1
ORDER BY hss.position
 8531 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178 
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 1) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
 8505 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 104
ORDER BY f.position ASC
 8481 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `cdf_meta` m
LEFT JOIN `cdf_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 8193 ms 65 Yes /classes/Dispatcher.php:643 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM cdf_shop_url su
LEFT JOIN cdf_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'charpentedefrance.eetek.tech' OR su.domain_ssl = 'charpentedefrance.eetek.tech')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 8073 ms 1 Yes /classes/shop/Shop.php:1350 
SELECT SQL_NO_CACHE *
FROM `cdf_currency` a
LEFT JOIN `cdf_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `cdf_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 7737 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE a.*,b.label
FROM cdf_gformbuilderprofields as a,
cdf_gformbuilderprofields_lang as b,
cdf_gformbuilderprofields_shop as c
WHERE a.id_gformbuilderprofields = b.id_gformbuilderprofields
AND a.id_gformbuilderprofields = c.id_gformbuilderprofields
AND c.id_shop = 1
AND b.id_lang = 1
AND a.id_gformbuilderprofields IN(122,125,124,126)
 7271 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177 
SELECT SQL_NO_CACHE l.id_iqitmenulinks, l.new_window, s.name, ll.link, ll.label
FROM cdf_iqitmenulinks l
LEFT JOIN cdf_iqitmenulinks_lang ll ON (l.id_iqitmenulinks = ll.id_iqitmenulinks AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN cdf_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_iqitmenulinks = "5"
AND l.id_shop IN (0, 1)
 7107 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25 
SELECT SQL_NO_CACHE *
FROM `cdf_group` a
LEFT JOIN `cdf_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 6910 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
 6436 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM cdf_cms c
LEFT JOIN cdf_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1 AND cl.id_shop = 1)
INNER JOIN cdf_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (24) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
 6209 ms 1 Yes /classes/CMS.php:151 
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
 5657 ms 67 /modules/configurator/configurator.php:1373 
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
 5176 ms 1 Yes /classes/Currency.php:709 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM cdf_shop_group gs
LEFT JOIN cdf_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN cdf_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 5135 ms 1 Yes /classes/shop/Shop.php:711 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 51
LIMIT 1
 5096 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 34
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 5078 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61 
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
 5020 ms 1 /classes/module/Module.php:2237 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 5014 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
 4708 ms 854 /classes/Hook.php:1283 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 54
ORDER BY f.position ASC
 4570 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
 4373 ms 1 /classes/AddressFormat.php:672 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
 4362 ms 1 /classes/ObjectModel.php:1510 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `cdf_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `cdf_hook_alias` ha
INNER JOIN `cdf_hook` h ON ha.name = h.name
 4346 ms 0 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `cdf_hook_module` hm
STRAIGHT_JOIN `cdf_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `cdf_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 4302 ms 502 /classes/Hook.php:504 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 41) LIMIT 1
 4248 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
 4169 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE tr.*
FROM `cdf_tax_rule` tr
JOIN `cdf_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 4080 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM cdf_iqit_link_block cb
INNER JOIN cdf_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 545
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
 4030 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 105
AND image_shop.`cover` = 1 LIMIT 1
 3867 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 55 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 55 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 3783 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 105
LIMIT 1
 3728 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=104 AND c.active= 1 LIMIT 1
 3687 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 53) AND (b.`id_shop` = 1) LIMIT 1
 3672 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
 3636 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 34 AND ctg.`id_group` = 1 LIMIT 1
 3628 ms 1 /classes/Category.php:1730 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 29) LIMIT 1
 3593 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `cdf_category` c
INNER JOIN `cdf_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `cdf_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 7
AND nleft >= 16 AND nright <= 17
AND c.id_category IN (
SELECT id_category
FROM `cdf_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 3585 ms 7 Yes /modules/ps_categorytree/ps_categorytree.php:166 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 41 AND `id_shop` = 1
 3579 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 55
ORDER BY f.position ASC
 3504 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 51
AND image_shop.`cover` = 1 LIMIT 1
 3444 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 54
LIMIT 1
 3307 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 104
AND image_shop.`cover` = 1 LIMIT 1
 3259 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 3222 ms 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 56 AND `id_group` = 1 LIMIT 1
 3147 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
 3109 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=105 AND c.active= 1 LIMIT 1
 3076 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 3073 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 106
LIMIT 1
 3046 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 3017 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 53
AND image_shop.`cover` = 1 LIMIT 1
 2956 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 105 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 105 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2912 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 104 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 104 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2895 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
 2890 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
 2884 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (51) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2867 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 54 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 54 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2760 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM cdf_product p LEFT JOIN cdf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cdf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cdf_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 cdf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cdf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cdf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cdf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cdf_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=16 AND c.nright<=17 GROUP BY p.id_product) p
 2756 ms 402 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 105) AND (b.`id_shop` = 1) LIMIT 1
 2661 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 52
LIMIT 1
 2549 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 105
ORDER BY f.position ASC
 2528 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 2528 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 2451 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 51) AND (b.`id_shop` = 1) LIMIT 1
 2441 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `cdf_category` c
INNER JOIN cdf_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `cdf_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `cdf_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 34
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 2371 ms 1 Yes Yes /classes/Category.php:919 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 104
ORDER BY `position`
 2367 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `cdf_category` c
INNER JOIN cdf_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `cdf_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `cdf_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `cdf_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 2303 ms 28 Yes Yes /classes/Category.php:793 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (55) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2294 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 55
LIMIT 1
 2293 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
 2291 ms 88 /classes/Hook.php:301 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 55
ORDER BY `position`
 2243 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
 2233 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 16) AND (a0.`nright` > 17) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 2221 ms 28 Yes /classes/PrestaShopCollection.php:381 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
 2220 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
 2215 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (56) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2209 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="d94bdcaa429f5a251a94bfd5a280841e" LIMIT 1
 2128 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2122 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 105
ORDER BY `position`
 2088 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 106 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 106 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2078 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE *
FROM `cdf_cms` a
LEFT JOIN `cdf_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `cdf_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
 2020 ms 1 /src/Adapter/EntityMapper.php:76 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 105)
 2016 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1983 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 1983 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 56
ORDER BY f.position ASC
 1965 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 52
ORDER BY f.position ASC
 1949 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=54 AND c.active= 1 LIMIT 1
 1943 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=52 AND c.active= 1 LIMIT 1
 1922 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
 1914 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
 1892 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 51 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 51 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1883 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1880 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 104
LIMIT 1
 1879 ms 1 /classes/ProductAssembler.php:95 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 104)
 1875 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 1865 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 56 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 56 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1828 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 106
ORDER BY f.position ASC
 1809 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 56
AND image_shop.`cover` = 1 LIMIT 1
 1808 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 105) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1786 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 54
ORDER BY `position`
 1774 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1758 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1758 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 52 AND id_shop=1 LIMIT 1
 1747 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (105) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1742 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=51 AND c.active= 1 LIMIT 1
 1716 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 51
ORDER BY f.position ASC
 1670 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54) AND (b.`id_shop` = 1) LIMIT 1
 1657 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 1629 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 104
 1622 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE a.*, b.`name`, b.`description`
FROM `cdf_lgcookieslaw_purpose` a
LEFT JOIN `cdf_lgcookieslaw_purpose_lang` `b` ON (b.`id_lgcookieslaw_purpose` = a.`id_lgcookieslaw_purpose` AND b.`id_lang` = 1)
WHERE (a.`id_shop` = 1) AND (a.`active` = 1)
 1603 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 104 AND `id_group` = 1 LIMIT 1
 1586 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
 1569 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 25) LIMIT 1
 1565 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 106
ORDER BY `position`
 1555 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 106) AND (b.`id_shop` = 1) LIMIT 1
 1545 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
 1469 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 56
ORDER BY `position`
 1467 ms 4 Yes /classes/Product.php:3508 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 51)
 1434 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 55 LIMIT 1
 1412 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 51
ORDER BY `position`
 1391 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 105 AND id_shop=1 LIMIT 1
 1388 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
 1374 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 52
AND image_shop.`cover` = 1 LIMIT 1
 1345 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
 1337 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 53
ORDER BY f.position ASC
 1333 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 1332 ms 1 /classes/shop/Shop.php:1171 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 28) LIMIT 1
 1325 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
 1323 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1314 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 52 AND `id_group` = 1 LIMIT 1
 1313 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 55
AND `required` = 1 AND `is_deleted` = 0
 1304 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 54
AND image_shop.`cover` = 1 LIMIT 1
 1300 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=106 AND c.active= 1 LIMIT 1
 1292 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
 1280 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 25 AND `id_shop` = 1
 1274 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
 1273 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
 1273 ms 1 /classes/Hook.php:239 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 52)
 1273 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 55
 1267 ms 1 /classes/Product.php:2875 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 53)
 1265 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 42) LIMIT 1
 1262 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1257 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 106
AND image_shop.`cover` = 1 LIMIT 1
 1234 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 56 LIMIT 1
 1234 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
 1232 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 52
ORDER BY `position`
 1230 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 55
AND image_shop.`cover` = 1 LIMIT 1
 1225 ms 4 /classes/Product.php:3533 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 1214 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 42 AND `id_shop` = 1
 1208 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 105 AND `id_group` = 1 LIMIT 1
 1207 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
 1205 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 1202 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 53 AND id_shop=1 LIMIT 1
 1199 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 55 AND id_shop=1 LIMIT 1
 1192 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 1180 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 1178 ms 1 /classes/Country.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_lang` a
LEFT JOIN `cdf_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 1167 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 56) AND (b.`id_shop` = 1) LIMIT 1
 1163 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
 1160 ms 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 34) LIMIT 1
 1155 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=53 AND c.active= 1 LIMIT 1
 1146 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 54)
 1139 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 54 AND id_shop=1 LIMIT 1
 1137 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
 1132 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (106) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1114 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 53
ORDER BY `position`
 1110 ms 4 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 104) AND (b.`id_shop` = 1) LIMIT 1
 1105 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 105
 1103 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 1101 ms 1 /classes/Language.php:853 
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 55) AND (b.`id_shop` = 1) LIMIT 1
 1098 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_country` a
LEFT JOIN `cdf_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
 1096 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 28 AND `id_shop` = 1
 1095 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
 1094 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_currency` a
LEFT JOIN `cdf_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 1078 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1052 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
 1050 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
 1050 ms 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
 1049 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 54
AND `required` = 1 AND `is_deleted` = 0
 1048 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 105
AND `required` = 1 AND `is_deleted` = 0
 1042 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1040 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM cdf_cms c
LEFT JOIN cdf_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1 AND cl.id_shop = 1)
INNER JOIN cdf_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (18) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
 1026 ms 1 Yes /classes/CMS.php:151 
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
 1024 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 106
AND `required` = 1 AND `is_deleted` = 0
 1007 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
 1006 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 104
AND `required` = 1 AND `is_deleted` = 0
 1000 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 56) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 999 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `cdf_lang` l
JOIN cdf_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 999 ms 1 /classes/Language.php:1198 
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 994 ms 1 /classes/Language.php:853 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
 987 ms 854 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 104 AND id_shop=1 LIMIT 1
 982 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 981 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 51 LIMIT 1
 976 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
 970 ms 1 /classes/Hook.php:239 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 106)
 960 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 943 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 19 AND `id_shop` = 1
 943 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 19) LIMIT 1
 935 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 931 ms 1 /classes/shop/ShopUrl.php:182 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 54 AND `id_group` = 1 LIMIT 1
 927 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 52
 923 ms 1 /classes/Product.php:2875 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 56)
 915 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM cdf_iqit_link_block cb
INNER JOIN cdf_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 583
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
 912 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
 911 ms 1 /classes/module/Module.php:2840 
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
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_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` = 55)
 909 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 56
AND `required` = 1 AND `is_deleted` = 0
 908 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 56 AND id_shop=1 LIMIT 1
 885 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 3) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
 884 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=56 AND c.active= 1 LIMIT 1
 884 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 51 AND id_shop=1 LIMIT 1
 882 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 54) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 875 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 871 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 106 AND id_shop=1 LIMIT 1
 869 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 862 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 861 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 106) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 839 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 5) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
 839 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 51
 831 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 29 AND `id_shop` = 1
 826 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=55 AND c.active= 1 LIMIT 1
 824 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 6) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
 822 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
 821 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 814 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `cdf_currency` c
LEFT JOIN cdf_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
 812 ms 1 /classes/Currency.php:1126 
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `cdf_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
 806 ms 1 Yes /classes/Language.php:974 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
 800 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
 800 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 51) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 794 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 54 LIMIT 1
 788 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
 775 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 106
 774 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 51
AND `required` = 1 AND `is_deleted` = 0
 771 ms 2 /classes/Product.php:6494 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
 767 ms 1 /classes/Group.php:154 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 766 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 759 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE tr.*
FROM `cdf_tax_rule` tr
JOIN `cdf_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 759 ms 0 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
 754 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
 751 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
 751 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 726 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 53) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 725 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 52
AND `required` = 1 AND `is_deleted` = 0
 722 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
 721 ms 88 /classes/Hook.php:353 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 52 LIMIT 1
 720 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 105 LIMIT 1
 720 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 73 AND `id_shop` = 1
 711 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 706 ms 1 /classes/Currency.php:893 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 705 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
 705 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
 702 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 702 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
 701 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM cdf_shop s
LEFT JOIN cdf_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 698 ms 1 /classes/shop/Shop.php:205 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 43) LIMIT 1
 693 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 685 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 55 AND `id_group` = 1 LIMIT 1
 684 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
 680 ms 1 /classes/Image.php:510 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 53 LIMIT 1
 674 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 26) LIMIT 1
 669 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 56
 662 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 43 AND `id_shop` = 1
 660 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 55) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 660 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 647 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
 641 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
 640 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 73) LIMIT 1
 638 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 53 AND `id_group` = 1 LIMIT 1
 636 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
 635 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 51 AND `id_group` = 1 LIMIT 1
 628 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
 615 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 106 AND `id_group` = 1 LIMIT 1
 615 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
 614 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 104) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 614 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 26 AND `id_shop` = 1
 614 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 53
 614 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
 613 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `cdf_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
 606 ms 1 /classes/Category.php:1371 
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
 605 ms 8 /classes/ImageType.php:147 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 604 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
 599 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
 588 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
 588 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 106 LIMIT 1
 580 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 54
 579 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
 551 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'home_default' LIMIT 1
 550 ms 1 /classes/Image.php:510 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 544 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
 543 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
 538 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 519 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 53
AND `required` = 1 AND `is_deleted` = 0
 515 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 5) LIMIT 1
 507 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 371) LIMIT 1
 492 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
 491 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1
 479 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
 472 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
 471 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
 471 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
 465 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
 463 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
 459 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
 457 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) LIMIT 1
 457 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
 457 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
 457 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
 450 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
 450 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
 450 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) LIMIT 1
 448 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
 444 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) LIMIT 1
 442 ms 1 /src/Adapter/EntityMapper.php:76