Load Time 1908 ms
Querying Time 623 ms
Queries 272
Memory Peak Usage 59.5 Mb
Included Files 1240 files - 14.68 Mb
PrestaShop Cache - Mb
Global vars 1.01 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 243 ms 291 ms 9.14 Mb 28.6 Mb
checkAccess 0 ms 291 ms - Mb 28.6 Mb
setMedia 43 ms 334 ms 2.83 Mb 30.6 Mb
postProcess 0 ms 334 ms - Mb 30.6 Mb
initHeader 0 ms 334 ms - Mb 30.6 Mb
initContent 896 ms 1229 ms 21.96 Mb 52.5 Mb
initFooter 0 ms 1229 ms - Mb 52.5 Mb
display 678 ms 1908 ms 6.69 Mb 59.5 Mb
Hook Time Memory Usage
displayMainMenu 127 ms 2.03 Mb
DisplayHeader 119 ms 3.39 Mb
DisplayGform 70 ms 0.64 Mb
DisplayFooter 41 ms 0.67 Mb
displayProductListReviews 36 ms 0.29 Mb
Header 33 ms 0.30 Mb
displayNav1 30 ms 0.21 Mb
ModuleRoutes 16 ms 0.74 Mb
displayLeftColumn 16 ms 0.10 Mb
ActionFrontControllerSetMedia 14 ms 0.66 Mb
DisplayLeftColumn 13 ms 0.01 Mb
displayNav2 10 ms 0.21 Mb
displaySearch 8 ms 0.05 Mb
DisplayAfterBodyOpeningTag 7 ms 0.02 Mb
displayAboveMobileMenu 5 ms 0.09 Mb
ActionOutputHTMLBefore 5 ms - Mb
ProductSearchProvider 4 ms 0.18 Mb
DisplayGDPRConsent 4 ms 0.03 Mb
displayFooter 2 ms 0.03 Mb
displayAfterBreadcrumb 1 ms 0.03 Mb
DisplayTop 1 ms 0.01 Mb
ActionDispatcherBefore 1 ms - Mb
DisplayBeforeBodyClosingTag 0 ms - Mb
DisplayProductPriceBlock 0 ms - Mb
displayVerticalMenu 0 ms - Mb
ActionProductSearchAfter 0 ms - Mb
ActionDispatcher 0 ms - Mb
Top 0 ms - Mb
28 hook(s) 562 ms 9.68 Mb
Module Time Memory Usage
configurator 72 ms 4.89 Mb
gformbuilderpro 79 ms 1.40 Mb
ps_mbo 5 ms 0.26 Mb
iqitthemeeditor 4 ms 0.53 Mb
ps_emailsubscription 5 ms 0.38 Mb
ps_checkout 36 ms 1.68 Mb
ps_facebook 32 ms 1.32 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 99 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 65 ms 6.76 Mb
iqitcontactpage 1 ms 0.06 Mb
iqitcountdown 2 ms 0.04 Mb
iqitlinksmanager 40 ms 0.45 Mb
iqitsociallogin 1 ms 0.07 Mb
productcomments 3 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 8 ms 0.20 Mb
ets_recaptcha_free 1 ms 0.23 Mb
ps_searchbar 9 ms 0.08 Mb
iqitelementor 17 ms 1.15 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 133 ms 2.77 Mb
iqitreviews 39 ms 0.44 Mb
iqitsizecharts 2 ms 0.18 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 20 ms 0.21 Mb
ps_facetedsearch 23 ms 0.63 Mb
psgdpr 6 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 2 ms 0.23 Mb
ps_categorytree 11 ms 0.14 Mb
37 module(s) 739 ms 29.61 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 272 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
 34503 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>=47 AND c.nright<=48 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
 19265 ms 402 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
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
 16828 ms 1 /classes/Cart.php:4218 
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
 16021 ms 1 /src/Adapter/EntityMapper.php:76 
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)
 15487 ms 1 /classes/Language.php:1049 
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`)
 14686 ms 1308 /classes/Configuration.php:160 
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`
 12090 ms 2100 Yes Yes /classes/Hook.php:1183 
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
 11662 ms 1 /src/Adapter/EntityMapper.php:76 
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)
 11094 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355 
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` = 30) AND (b.`id_shop` = 1) LIMIT 1
 10346 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 (160) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 9977 ms 1 Yes Yes /classes/Product.php:4479 
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
 8995 ms 65 Yes /classes/Dispatcher.php:643 
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`
 8316 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
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
 8094 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174 
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)
 7909 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355 
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
 7725 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
 7524 ms 67 /modules/configurator/configurator.php:1373 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=160 AND c.active= 1 LIMIT 1
 7513 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
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
 7306 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178 
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 = 160
ORDER BY f.position ASC
 7274 ms 1 Yes /classes/Product.php:5897 
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
 7135 ms 1 Yes /classes/shop/Shop.php:711 
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
 6982 ms 854 /classes/Hook.php:1283 
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
 6868 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
 6754 ms 1 /classes/AddressFormat.php:672 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 30
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 6684 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61 
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`
 6634 ms 1 Yes /classes/CMS.php:151 
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
 6584 ms 1 Yes /classes/shop/Shop.php:1350 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
 6262 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
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
 5731 ms 502 /classes/Hook.php:504 
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
 5546 ms 0 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
 5355 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
 4984 ms 1 /classes/ObjectModel.php:1510 
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)
 4974 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
 4881 ms 1 /src/Adapter/EntityMapper.php:84 
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
 4838 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
 4751 ms 1 Yes /classes/Currency.php:709 
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
 4684 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215 
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)
 4522 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25 
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 = 162
LIMIT 1
 4402 ms 1 /classes/ProductAssembler.php:95 
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
 4127 ms 28 Yes Yes /classes/Category.php:793 
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` = 160 LIMIT 1
 4113 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
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 = 161
LIMIT 1
 4104 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
 3975 ms 1 /src/Adapter/EntityMapper.php:84 
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` = 160
AND image_shop.`cover` = 1 LIMIT 1
 3970 ms 2 /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
 3959 ms 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 30 AND ctg.`id_group` = 1 LIMIT 1
 3789 ms 1 /classes/Category.php:1730 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
 3373 ms 1 /classes/module/Module.php:2840 
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` = 162 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` = 162 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 3372 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
 3308 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132 
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
 2997 ms 1 /classes/module/Module.php:2237 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 2945 ms 1 /classes/order/Order.php:1203 
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` = 160 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` = 160 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2726 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
 2652 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127 
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 = 162
ORDER BY f.position ASC
 2643 ms 1 Yes /classes/Product.php:5897 
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` = 160
ORDER BY `position`
 2568 ms 2 Yes /classes/Product.php:3508 
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` = 162
ORDER BY `position`
 2501 ms 2 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 47) AND (a0.`nright` > 48) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 2497 ms 5 Yes /classes/PrestaShopCollection.php:381 
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` = 161 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` = 161 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2484 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>=47 AND c.nright<=48 GROUP BY p.id_product) p
 2456 ms 402 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
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` = 160)
 2452 ms 1 /override/classes/Product.php:442 
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` <= 6
AND nleft >= 47 AND nright <= 48
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
 2427 ms 4 Yes /modules/ps_categorytree/ps_categorytree.php:166 
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 (161) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2425 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="8ad6b5ef1060b757914f75beb1ccc98b" LIMIT 1
 2420 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182 
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
 2417 ms 105 /classes/module/Module.php:340 
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` = 30) LIMIT 1
 2393 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` = 162) AND (b.`id_shop` = 1) LIMIT 1
 2318 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` = 161) AND (b.`id_shop` = 1) LIMIT 1
 2255 ms 1 /src/Adapter/EntityMapper.php:76 
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
 2237 ms 1 /classes/Currency.php:1126 
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 2114 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
 2052 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 = 161
ORDER BY f.position ASC
 2024 ms 1 Yes /classes/Product.php:5897 
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
 2001 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
 1957 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 66) LIMIT 1
 1924 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 = 160
LIMIT 1
 1894 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1879 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=161 AND c.active= 1 LIMIT 1
 1859 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
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` = 30
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 1849 ms 1 Yes Yes /classes/Category.php:919 
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` = 161
AND image_shop.`cover` = 1 LIMIT 1
 1791 ms 2 /classes/Product.php:3533 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1786 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 1779 ms 1 /classes/Language.php:853 
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` = 162
AND image_shop.`cover` = 1 LIMIT 1
 1759 ms 2 /classes/Product.php:3533 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 160 AND `id_group` = 1 LIMIT 1
 1756 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
 1721 ms 88 /classes/Hook.php:301 
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
 1694 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 66 AND `id_shop` = 1
 1687 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
 1656 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 67) LIMIT 1
 1603 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
 1585 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 30 AND `id_shop` = 1
 1585 ms 1 /src/Adapter/EntityMapper.php:84 
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 (162) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1530 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 162
AND `required` = 1 AND `is_deleted` = 0
 1529 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
 1508 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 1486 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
 1479 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 1475 ms 1 /classes/shop/ShopUrl.php:182 
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` = 161)
 1464 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=162 AND c.active= 1 LIMIT 1
 1458 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 67 AND `id_shop` = 1
 1455 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
 1449 ms 1 /classes/Country.php:401 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 162) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1411 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 161 AND id_shop=1 LIMIT 1
 1411 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
 1380 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
 1353 ms 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
 1352 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 161) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1266 ms 1 /classes/stock/StockAvailable.php:453 
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
 1252 ms 105 /classes/module/Module.php:340 
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` = 161
ORDER BY `position`
 1245 ms 2 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 1240 ms 0 /classes/module/Module.php:2840 
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
 1240 ms 1 /classes/Language.php:1198 
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` = 160) AND (b.`id_shop` = 1) LIMIT 1
 1238 ms 1 /src/Adapter/EntityMapper.php:76 
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`
 1225 ms 1 Yes /classes/CMS.php:151 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
 1222 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` = 162 LIMIT 1
 1214 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 1212 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
 1208 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
 1207 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
 1205 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
 1188 ms 8 /classes/ImageType.php:147 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
 1185 ms 1 /classes/module/Module.php:2840 
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
 1178 ms 1 /src/Adapter/EntityMapper.php:76 
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
 1171 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 162 AND id_shop=1 LIMIT 1
 1170 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 68) LIMIT 1
 1153 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 1151 ms 1 /src/Adapter/EntityMapper.php:76 
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
 1121 ms 1 /classes/Category.php:1371 
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 1118 ms 1 /classes/shop/Shop.php:1171 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
 1111 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 1091 ms 1 /classes/Country.php:193 
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` = 162)
 1084 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
 1083 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
 1073 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
 1068 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
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` = 161 LIMIT 1
 1066 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
 1057 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
 1050 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
 1040 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 161 AND `id_group` = 1 LIMIT 1
 1025 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
 1010 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
 1006 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
 1004 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 162 AND `id_group` = 1 LIMIT 1
 998 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
 994 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 160 AND id_shop=1 LIMIT 1
 987 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
 973 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 969 ms 1 /classes/Language.php:853 
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
 967 ms 88 /classes/Hook.php:353 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
 965 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 68 AND `id_shop` = 1
 961 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
 957 ms 1 /classes/module/Module.php:2840 
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
 954 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 954 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
 949 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
 943 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 160
AND `required` = 1 AND `is_deleted` = 0
 929 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
 914 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
 910 ms 1 /classes/module/Module.php:2840 
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
 907 ms 1 /classes/shop/Shop.php:205 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
 907 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
 901 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
 899 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'home_default' LIMIT 1
 888 ms 1 /classes/Image.php:510 
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
 885 ms 1 Yes /classes/Language.php:974 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
 883 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 162
 872 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 161
AND `required` = 1 AND `is_deleted` = 0
 867 ms 1 /classes/Product.php:6494 
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
 854 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
 844 ms 854 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 161
 841 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
 825 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
 818 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` = 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
 816 ms 0 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 809 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
 804 ms 0 /classes/module/Module.php:2840 
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`
 794 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-typewriter-addon/revslider-typewriter-addon.php' LIMIT 1
 772 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
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`
 765 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
 759 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
 757 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
 723 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
 715 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
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`
 710 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
 709 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
 709 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` = 26) LIMIT 1
 702 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
 697 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
 686 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
 682 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
 673 ms 1 /classes/Image.php:510 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
 662 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
 660 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
 655 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` = 35) LIMIT 1
 643 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 160
 633 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
 628 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
 627 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 627 ms 1 /classes/Currency.php:893 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 160) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 626 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT 1
 625 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
 614 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` = 11) LIMIT 1
 611 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1
 608 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1
 604 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
 603 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
 602 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
 597 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
 595 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
 594 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
 587 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` = 33) LIMIT 1
 574 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` = 6) LIMIT 1
 570 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
 567 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
 566 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
 566 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT 1
 563 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
 557 ms 1 /classes/Group.php:154 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
 556 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` = 5) LIMIT 1
 556 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 33 AND `id_shop` = 1
 555 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` = 2) LIMIT 1
 554 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` = 34) LIMIT 1
 553 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
 552 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
 552 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
 548 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
 542 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
 539 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 533 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
 522 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
 513 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` = 12) LIMIT 1
 498 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
 497 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
 497 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
 490 ms 1 /classes/module/Module.php:2328 
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
 484 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
 476 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
 476 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 35 AND `id_shop` = 1
 475 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
 474 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 36 AND `id_shop` = 1
 474 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
 465 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` = 17) LIMIT 1
 464 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
 463 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
 454 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 371 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` = 28) LIMIT 1
 450 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
 450 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
 448 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` = 36) LIMIT 1
 444 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 442 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
 441 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
 438 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` = 25) LIMIT 1
 436 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_advancedformula" LIMIT 1
 433 ms 0 /classes/module/Module.php:2840 
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` = 24) LIMIT 1
 431 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
 429 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
 419 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198 
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` = 27) LIMIT 1
 417 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` = 16) LIMIT 1
 414 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
 413 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` = 13) LIMIT 1
 411 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 408 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 29 AND `id_shop` = 1
 404 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_designer" LIMIT 1
 404 ms 0 /classes/module/Module.php:2840 
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
 403 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
 399 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` = 29) LIMIT 1
 388 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
 387 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` = 41) LIMIT 1
 382 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` = 40) LIMIT 1
 375 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` = 14) LIMIT 1
 374 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
 370 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 355 ms 1 /classes/ObjectModel.php:1647

Doubles

25 queries 
SELECT *
							FROM `cdf_category_lang`
							WHERE `id_category` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span>
25 queries 
SELECT *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_category` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
14 queries 
SELECT `id_module` FROM `cdf_module_shop` WHERE `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
6 queries 
SELECT option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT <span style="color:blue">XX</span>
4 queries 
SELECT 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` = <span style="color:blue">XX</span>)
WHERE (a.`id_lgcookieslaw_purpose` = <span style="color:blue">XX</span>) AND (a.`id_shop` = <span style="color:blue">XX</span>) AND (a.`active` = <span style="color:blue">XX</span>)
ORDER BY a.`name`
4 queries 
                SELECT 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` = <span style="color:blue">XX</span>
3 queries 
							SELECT `name`
							FROM `cdf_hook`
							WHERE `id_hook` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,<span style="color:blue">XX</span>) 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 = <span style="color:blue">XX</span>)
LEFT JOIN `cdf_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = <span style="color:blue">XX</span>)
WHERE (p.`id_product` = <span style="color:blue">XX</span>)
3 queries 
SELECT * FROM `cdf_configurator` c
                        WHERE c.id_product=<span style="color:blue">XX</span> AND c.active= <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT name FROM cdf_category_lang WHERE id_shop = <span style="color:blue">XX</span> AND id_lang = <span style="color:blue">XX</span> AND id_category = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT 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 = <span style="color:blue">XX</span>)
                    WHERE i.`id_product` = <span style="color:blue">XX</span>
                    AND image_shop.`cover` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT
                    p.*,
                    ps.*,
                    pl.*,
                    sa.out_of_stock,
                    IFNULL(sa.quantity, <span style="color:blue">XX</span>) as quantity,
                    (DATEDIFF(
                        p.`date_add`,
                        DATE_SUB(
                            '<span style="color:blue">XX</span>-<span style="color:blue">XX</span>-<span style="color:blue">XX</span> <span style="color:blue">XX</span>:<span style="color:blue">XX</span>:<span style="color:blue">XX</span>',
                            INTERVAL <span style="color:blue">XX</span> DAY
                        )
                    ) > <span style="color:blue">XX</span>) as new
                FROM cdf_product p
                LEFT JOIN cdf_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = <span style="color:blue">XX</span>
                    AND pl.id_lang = <span style="color:blue">XX</span>
                LEFT JOIN cdf_stock_available sa
			        ON sa.id_product = p.id_product
			        AND sa.id_shop = <span style="color:blue">XX</span>
                LEFT JOIN cdf_product_shop ps
			        ON ps.id_product = p.id_product
			        AND ps.id_shop = <span style="color:blue">XX</span>
			    WHERE p.id_product = <span style="color:blue">XX</span>
			    LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT `id_product_attribute`
            FROM `cdf_product_attribute`
            WHERE `id_product` = <span style="color:blue">XX</span>
3 queries 
            SELECT 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 = <span style="color:blue">XX</span>)
            LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = <span style="color:blue">XX</span>)
            WHERE i.`id_product` = <span style="color:blue">XX</span>
            ORDER BY `position`
3 queries 
            SELECT `id_customization_field`, `type`
            FROM `cdf_customization_field`
            WHERE `id_product` = <span style="color:blue">XX</span>
            AND `required` = <span style="color:blue">XX</span> AND `is_deleted` = <span style="color:blue">XX</span>
3 queries 
                SELECT 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 = <span style="color:blue">XX</span>)
                LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>)
                 INNER JOIN cdf_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = <span style="color:blue">XX</span>)
                WHERE pf.id_product = <span style="color:blue">XX</span>
                ORDER BY f.position ASC
3 queries 
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), <span style="color:blue">XX</span>) as deep_quantity,
            COALESCE(SUM(first_level_quantity), <span style="color:blue">XX</span>) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, <span style="color:blue">XX</span> as pack_quantity
          FROM `cdf_cart_product` cp
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND cp.`id_product` = <span style="color:blue">XX</span> UNION SELECT <span style="color:blue">XX</span> 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` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND p.`id_product_item` = <span style="color:blue">XX</span> AND (pr.`pack_stock_type` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) OR (
            pr.`pack_stock_type` = <span style="color:blue">XX</span>
            AND <span style="color:blue">XX</span> = <span style="color:blue">XX</span>
        ))) as q LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT `id_order`
            FROM `cdf_orders`
            WHERE `id_cart` = <span style="color:blue">XX</span> AND id_shop IN (<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = <span style="color:blue">XX</span>) AND (id_product_attribute = <span style="color:blue">XX</span>) AND (id_shop = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT *
							FROM `cdf_customization_field_lang`
							WHERE `id_customization_field` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span>
3 queries 
				SELECT (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
				FROM `cdf_iqitreviews_products` pr
				WHERE pr.`status` = <span style="color:blue">XX</span>  AND pr.`id_product` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
            SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, <span style="color:blue">XX</span> 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 = <span style="color:blue">XX</span>)
            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` = <span style="color:blue">XX</span>)
            JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (<span style="color:blue">XX</span>) AND ag.`is_color_group` = <span style="color:blue">XX</span>
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
3 queries 
			SELECT `reduction`
			FROM `cdf_product_group_reduction_cache`
			WHERE `id_product` = <span style="color:blue">XX</span> AND `id_group` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
                            SELECT `id_tax_rules_group`
                            FROM `cdf_product_shop`
                            WHERE `id_product` = <span style="color:blue">XX</span> AND id_shop=<span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
3 queries 
SELECT *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = <span style="color:blue">XX</span>
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_product` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT `id_lang` FROM `cdf_lang`
                    WHERE `locale` = 'fr-fr'
                    OR `language_code` = 'fr-fr' LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT 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` = <span style="color:blue">XX</span>)
WHERE (a.`id_shop` = <span style="color:blue">XX</span>) AND (a.`active` = <span style="color:blue">XX</span>)
2 queries 
SELECT *
FROM `cdf_hook` a
WHERE (a.`id_hook` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = <span style="color:blue">XX</span> AND c.hook = <span style="color:blue">XX</span>
2 queries 
SELECT 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` = <span style="color:blue">XX</span>
                    AND cs.`id_shop` = <span style="color:blue">XX</span>
                    ORDER BY cb.position ASC
2 queries 
SELECT *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
2 queries 
SELECT *
							FROM `cdf_iqit_link_block_lang`
							WHERE `id_iqit_link_block` = <span style="color:blue">XX</span>
2 queries 
				SELECT 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` = <span style="color:blue">XX</span>
				AND tr.`id_country` = <span style="color:blue">XX</span>
				AND tr.`id_tax_rules_group` = <span style="color:blue">XX</span>
				AND tr.`id_state` IN (<span style="color:blue">XX</span>, <span style="color:blue">XX</span>)
				AND ('<span style="color:blue">XX</span>' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = <span style="color:blue">XX</span> AND tr.`zipcode_from` IN(<span style="color:blue">XX</span>, '<span style="color:blue">XX</span>')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 queries 
SELECT option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT <span style="color:blue">XX</span>
2 queries 
		SELECT 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 = <span style="color:blue">XX</span> AND cl.id_shop = <span style="color:blue">XX</span>)
		 INNER JOIN cdf_cms_shop cms_shop
        ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = <span style="color:blue">XX</span>)
		WHERE <span style="color:blue">XX</span>
		 AND c.id_cms IN (<span style="color:blue">XX</span>) AND c.`active` = <span style="color:blue">XX</span> GROUP BY c.id_cms
		ORDER BY c.`position`

Tables stress

34 category_lang
33 category
32 module
29 category_shop
27 revslider_options
20 module_shop
15 product
15 product_shop
11 hook
8 product_attribute
8 stock_available
7 product_lang
7 cart_product
6 image
6 image_shop
6 product_attribute_shop
6 category_group
6 lang
6 customization_field
5 currency
5 shop
5 product_attribute_combination
5 country
4 image_type
4 iqit_link_block
4 lgcookieslaw_cookie
4 shop_url
4 lgcookieslaw_cookie_lang
4 currency_shop
4 lang_shop
3 orders
3 hook_alias
3 configurator
3 pack
3 feature_product
3 feature_lang
3 feature_value_lang
3 feature
3 feature_shop
3 image_lang
3 customization_field_lang
3 product_group_reduction_cache
3 cms
3 cms_lang
3 cms_shop
3 iqitreviews_products
3 attribute
3 attribute_lang
3 attribute_group
2 configuration
2 iqit_link_block_lang
2 iqit_elementor_content
2 shop_group
2 group_shop
2 iqit_link_block_shop
2 category_product
2 tax_rules_group
2 country_shop
2 lgcookieslaw_purpose_lang
2 lgcookieslaw_purpose
2 hook_module
2 product_sale
2 country_lang
2 currency_lang
2 tax_rule
2 group
1 hook_module_exceptions
1 address_format
1 revslider_sliders
1 required_field
1 iqitmegamenu_tabs_lang
1 iqitmegamenu_tabs
1 iqitmegamenu_tabs_shop
1 iqitmenulinks_lang
1 iqitmenulinks
1 meta_lang
1 meta
1 pscheckout_funding_source
1 layered_category
1 tax
1 psgdpr_consent
1 gformbuilderprofields
1 gform_analytics
1 gformbuilderpro_shop
1 gformbuilderpro_lang
1 gformbuilderpro
1 module_group
1 layered_price_index
1 layered_filter_block
1 configuration_lang
1 tax_lang
1 group_lang

ObjectModel instances

Name Instances Source
Category 31 /controllers/front/listing/CategoryController.php [89]
/classes/Meta.php [380]
/classes/PrestaShopCollection.php [383]
/classes/PrestaShopCollection.php [383]
/modules/ps_facetedsearch/src/Product/Search.php [353]
/modules/iqitmegamenu/iqitmegamenu.php [3437]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/iqitmegamenu/iqitmegamenu.php [3434]
/modules/ps_categorytree/ps_categorytree.php [338]
Product 10 /classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/src/Adapter/Image/ImageRetriever.php [66]
/classes/Link.php [114]
/classes/Link.php [114]
/classes/Link.php [114]
/modules/configurator/classes/ConfiguratorCartDetailModel.php [1122]
Address 4 /classes/shop/Shop.php [469]
/classes/Product.php [3654]
/override/classes/Product.php [396]
/classes/Product.php [5840]
Country 4 /config/config.inc.php [157]
/classes/controller/FrontController.php [374]
/classes/AddressFormat.php [404]
/classes/controller/FrontController.php [1677]
Combination 3 /classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
CustomizationField 3 /modules/configurator/classes/ConfiguratorModel.php [129]
/modules/configurator/classes/ConfiguratorModel.php [129]
/modules/configurator/classes/ConfiguratorModel.php [129]
ConfiguratorModel 3 /override/classes/Product.php [70]
/override/classes/Product.php [70]
/override/classes/Product.php [70]
Language 2 /config/config.inc.php [222]
/classes/Tools.php [581]
Hook 2 /modules/iqitlinksmanager/src/IqitLinkBlockPresenter.php [33]
/modules/iqitlinksmanager/src/IqitLinkBlockPresenter.php [33]
Currency 2 /src/Adapter/Currency/CurrencyDataProvider.php [101]
/classes/Tools.php [704]
IqitLinkBlock 2 /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php [178]
/modules/iqitlinksmanager/src/IqitLinkBlockRepository.php [178]
Configuration 2 /src/Core/Addon/Theme/Theme.php [42]
/src/Core/Addon/Theme/Theme.php [42]
ConfiguratorCartDetailModel 1 /modules/configurator/configurator.php [1687]
gformbuilderproModel 1 /modules/gformbuilderpro/gformbuilderpro.php [828]
Tax 1 /classes/tax/TaxRulesTaxManager.php [116]
Shop 1 /config/config.inc.php [128]
State 1 /classes/controller/FrontController.php [1676]
AddressFormat 1 /classes/controller/FrontController.php [1671]
Risk 1 /classes/controller/FrontController.php [1609]
Gender 1 /classes/controller/FrontController.php [1606]
Group 1 /classes/Cart.php [248]
Cart 1 /classes/controller/FrontController.php [443]
Customer 1 /config/config.inc.php [249]
ShopGroup 1 /classes/shop/Shop.php [557]
CMS 1 /classes/Link.php [560]

Included Files

# Filename
0 /index.php
1 /config/config.inc.php
2 /config/defines.inc.php
3 /config/autoload.php
4 /vendor/autoload.php
5 /vendor/composer/autoload_real.php
6 /vendor/composer/platform_check.php
7 /vendor/composer/ClassLoader.php
8 /vendor/composer/include_paths.php
9 /vendor/composer/autoload_static.php
10 /vendor/paragonie/random_compat/lib/random.php
11 /vendor/symfony/polyfill-php70/bootstrap.php
12 /vendor/symfony/polyfill-php72/bootstrap.php
13 /vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14 /vendor/symfony/polyfill-intl-idn/bootstrap.php
15 /vendor/react/promise/src/functions_include.php
16 /vendor/react/promise/src/functions.php
17 /vendor/symfony/polyfill-ctype/bootstrap.php
18 /vendor/symfony/polyfill-mbstring/bootstrap.php
19 /vendor/symfony/polyfill-iconv/bootstrap.php
20 /vendor/swiftmailer/swiftmailer/lib/swift_required.php
21 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
22 /vendor/symfony/polyfill-php73/bootstrap.php
23 /vendor/symfony/polyfill-php56/bootstrap.php
24 /vendor/symfony/polyfill-intl-icu/bootstrap.php
25 /vendor/symfony/polyfill-apcu/bootstrap.php
26 /vendor/markbaker/matrix/classes/src/functions/adjoint.php
27 /vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
28 /vendor/markbaker/matrix/classes/src/functions/cofactors.php
29 /vendor/markbaker/matrix/classes/src/functions/determinant.php
30 /vendor/markbaker/matrix/classes/src/functions/diagonal.php
31 /vendor/markbaker/matrix/classes/src/functions/identity.php
32 /vendor/markbaker/matrix/classes/src/functions/inverse.php
33 /vendor/markbaker/matrix/classes/src/functions/minors.php
34 /vendor/markbaker/matrix/classes/src/functions/trace.php
35 /vendor/markbaker/matrix/classes/src/functions/transpose.php
36 /vendor/markbaker/matrix/classes/src/operations/add.php
37 /vendor/markbaker/matrix/classes/src/operations/directsum.php
38 /vendor/markbaker/matrix/classes/src/operations/subtract.php
39 /vendor/markbaker/matrix/classes/src/operations/multiply.php
40 /vendor/markbaker/matrix/classes/src/operations/divideby.php
41 /vendor/markbaker/matrix/classes/src/operations/divideinto.php
42 /vendor/markbaker/complex/classes/src/functions/abs.php
43 /vendor/markbaker/complex/classes/src/functions/acos.php
44