Load Time 1612 ms
Querying Time 561 ms
Queries 262
Memory Peak Usage 66.6 Mb
Included Files 1289 files - 14.85 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 47 ms 47 ms 18.33 Mb 18.7 Mb
__construct 0 ms 47 ms - Mb 18.7 Mb
init 252 ms 299 ms 9.04 Mb 28.3 Mb
checkAccess 0 ms 299 ms - Mb 28.3 Mb
setMedia 41 ms 340 ms 2.83 Mb 30.4 Mb
postProcess 0 ms 340 ms - Mb 30.4 Mb
initHeader 0 ms 340 ms - Mb 30.4 Mb
initContent 369 ms 709 ms 17.85 Mb 48.3 Mb
initFooter 0 ms 709 ms - Mb 48.3 Mb
display 903 ms 1612 ms 18.17 Mb 66.6 Mb
Hook Time Memory Usage
displayCMSDisputeInformation 405 ms 11.51 Mb
DisplayHeader 140 ms 3.47 Mb
displayMainMenu 108 ms 2.83 Mb
DisplayGform 65 ms 0.64 Mb
Header 37 ms 0.36 Mb
displayNav1 34 ms 0.35 Mb
displayProductListReviews 31 ms 0.29 Mb
DisplayFooter 29 ms 0.74 Mb
ModuleRoutes 15 ms 0.74 Mb
ActionFrontControllerSetMedia 13 ms 0.72 Mb
displayNav2 13 ms 0.22 Mb
displayAboveMobileMenu 10 ms 0.11 Mb
displaySearch 8 ms 0.05 Mb
displayAfterBreadcrumb 7 ms 0.04 Mb
DisplayAfterBodyOpeningTag 5 ms 0.02 Mb
ActionOutputHTMLBefore 5 ms - Mb
DisplayGDPRConsent 3 ms 0.04 Mb
DisplayTop 1 ms 0.01 Mb
displayFooter 1 ms 0.02 Mb
ActionDispatcherBefore 1 ms - Mb
DisplayBeforeBodyClosingTag 0 ms - Mb
DisplayProductPriceBlock 0 ms - Mb
ActionDispatcher 0 ms - Mb
Top 0 ms - Mb
24 hook(s) 929 ms 22.16 Mb
Module Time Memory Usage
configurator 66 ms 4.88 Mb
gformbuilderpro 74 ms 1.39 Mb
ps_mbo 5 ms 0.26 Mb
iqitthemeeditor 5 ms 0.52 Mb
ps_emailsubscription 4 ms 0.44 Mb
ps_checkout 36 ms 1.74 Mb
ps_facebook 35 ms 1.31 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 112 ms 3.71 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 57 ms 6.70 Mb
iqitcontactpage 1 ms 0.12 Mb
iqitcountdown 2 ms 0.04 Mb
iqitlinksmanager 46 ms 0.60 Mb
iqitsociallogin 2 ms 0.07 Mb
productcomments 3 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 2 ms 0.17 Mb
ets_recaptcha_free 1 ms 0.17 Mb
ps_searchbar 8 ms 0.08 Mb
iqitelementor 428 ms 12.68 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 114 ms 3.57 Mb
iqitreviews 34 ms 0.38 Mb
iqitsizecharts 3 ms 0.24 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 18 ms 0.22 Mb
psgdpr 5 ms 0.22 Mb
ps_languageselector 2 ms 0.13 Mb
ps_currencyselector 2 ms 0.07 Mb
pagesnotfound 2 ms 0.21 Mb
sekeywords 1 ms 0.14 Mb
iqitsearch 1 ms - Mb
ps_customersignin 0 ms 0.02 Mb
iqitproductsnav 8 ms 0.23 Mb
35 module(s) 1094 ms 41.32 Mb

Stopwatch SQL - 262 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
35728 ms 35022 /modules/gformbuilderpro/gformbuilderpro.php:380
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
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 (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `cdf_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `cdf_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `cdf_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `cdf_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `cdf_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN cdf_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (171) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY FIELD(product_shop.id_product, 171)
27040 ms 0 /modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php:753
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`
23881 ms 2100 Yes Yes /classes/Hook.php:1183
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
18246 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 (171) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
15175 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `cdf_contact` c
LEFT JOIN cdf_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `cdf_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 1
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
11996 ms 2 Yes Yes /classes/Contact.php:99
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
11925 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
10190 ms 1 /classes/Cart.php:4218
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
9625 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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`)
9011 ms 1308 /classes/Configuration.php:160
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` = 43) AND (b.`id_shop` = 1) LIMIT 1
8743 ms 1 /src/Adapter/EntityMapper.php:76
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
7936 ms 65 Yes /classes/Dispatcher.php:643
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 = 171
ORDER BY f.position ASC
7851 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
7564 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
7168 ms 854 /classes/Hook.php:1283
SELECT SQL_NO_CACHE *
FROM `cdf_cms_category` a
LEFT JOIN `cdf_cms_category_shop` `c` ON a.`id_cms_category` = c.`id_cms_category` AND c.`id_shop` = 1
WHERE (a.`id_cms_category` = 1) LIMIT 1
6848 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)
6701 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
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
6626 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
6615 ms 67 /modules/configurator/configurator.php:1373
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
6336 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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
6324 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)
6106 ms 1 /classes/Language.php:1049
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
5828 ms 1 Yes /classes/shop/Shop.php:1350
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` = 171 LIMIT 1
5638 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
5501 ms 1 /classes/module/Module.php:2840
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
5309 ms 0 /classes/Hook.php:1243
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
4784 ms 1 /src/Adapter/EntityMapper.php:84
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
4771 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
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)
4769 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
4702 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
4666 ms 502 /classes/Hook.php:504
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
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 (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `cdf_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `cdf_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `cdf_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `cdf_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `cdf_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN cdf_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (170) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY FIELD(product_shop.id_product, 170)
4592 ms 0 /modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php:753
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`
4531 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
4347 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
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
4281 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
4243 ms 1 /classes/ObjectModel.php:1510
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
4205 ms 1 Yes /classes/shop/Shop.php:711
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
4172 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)
4017 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177
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)
3839 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
3774 ms 1 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE *
FROM `cdf_configurator` a
LEFT JOIN `cdf_configurator_shop` `c` ON a.`id_configurator` = c.`id_configurator` AND c.`id_shop` = 1
WHERE (a.`id_configurator` = 78) LIMIT 1
3707 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
3587 ms 1 /classes/module/Module.php:2237
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` = 170) AND (b.`id_shop` = 1) LIMIT 1
3481 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_tab, class_name FROM `cdf_tab`
3408 ms 200 /classes/Tab.php:359
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` = 171 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` = 171 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3401 ms 0 /classes/Cart.php:1429
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 (170) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3390 ms 1 Yes Yes /classes/Product.php:4479
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`
3311 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE *
FROM `cdf_cms_category_lang`
WHERE `id_cms_category` = 1 AND `id_shop` = 1
3181 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 171 LIMIT 1
2918 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
2887 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
2349 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
2325 ms 88 /classes/Hook.php:301
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
2246 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215
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` = 170 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` = 170 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2240 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
2228 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
2228 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 170 LIMIT 1
2188 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 70 AND `id_shop` = 1
2108 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 = 170
ORDER BY f.position ASC
2057 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` = 171
AND image_shop.`cover` = 1 LIMIT 1
2045 ms 4 /classes/Product.php:3533
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
2016 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 70) LIMIT 1
2011 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
1992 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 171 AND `id_group` = 1 LIMIT 1
1989 ms 0 /classes/GroupReduction.php:156
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
1981 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
1977 ms 1 /classes/Group.php:154
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
1923 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
1890 ms 8 /classes/ImageType.php:147
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1884 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
1832 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` = 170)
1813 ms 1 /override/classes/Product.php:442
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
1672 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1579 ms 1 /classes/shop/ShopUrl.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
1579 ms 105 /classes/module/Module.php:340
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
1577 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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` = 170
ORDER BY `position`
1570 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
1558 ms 1 /classes/module/Module.php:2840
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` = 170 LIMIT 1
1521 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
1513 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
1439 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1432 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 102 AND `id_shop` = 1 LIMIT 1
1377 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
1362 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
1347 ms 0 /classes/module/Module.php:2840
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
1284 ms 1 /classes/Currency.php:1126
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` = 171) AND (b.`id_shop` = 1) LIMIT 1
1245 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
1243 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
1236 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
1234 ms 1 /classes/module/Module.php:2840
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
1229 ms 105 /classes/module/Module.php:340
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
1220 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE id_shop
FROM `cdf_cms_shop`
WHERE `id_cms` = 43
AND id_shop = 1 LIMIT 1
1217 ms 1 /classes/ObjectModel.php:1647
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
1211 ms 1 /src/Adapter/EntityMapper.php:76
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` = 170
AND image_shop.`cover` = 1 LIMIT 1
1210 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
1185 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` = 171
ORDER BY `position`
1171 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
1160 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 170) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1158 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
1090 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
1084 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
1070 ms 1 /classes/module/Module.php:2328
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
1067 ms 1 /classes/Language.php:1198
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
1045 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1037 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1
1029 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 (18) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
1005 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
1005 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
1003 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE *
FROM `cdf_configurator` a
LEFT JOIN `cdf_configurator_shop` `c` ON a.`id_configurator` = c.`id_configurator` AND c.`id_shop` = 1
WHERE (a.`id_configurator` = 77) LIMIT 1
1002 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 171) LIMIT 1
994 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
982 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
977 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
964 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
963 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
961 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 170 AND `id_group` = 1 LIMIT 1
952 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
917 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
916 ms 854 /classes/Hook.php:1243
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
907 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
905 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
905 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
886 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 170
880 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `cdf_product_lang`
WHERE `id_product` = 170 AND `id_shop` = 1
875 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
874 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 170) LIMIT 1
866 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 170
AND `required` = 1 AND `is_deleted` = 0
849 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
845 ms 0 /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` = 171)
844 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
828 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "revsliderprestashop" LIMIT 1
801 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
795 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
792 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
785 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 170 AND id_shop=1 LIMIT 1
775 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
768 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 69) LIMIT 1
762 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-typewriter-addon/revslider-typewriter-addon.php' LIMIT 1
761 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
746 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
739 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
737 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
726 ms 0 /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` = 15) LIMIT 1
726 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 171
723 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
723 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
721 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
715 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
713 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
710 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
707 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 69 AND `id_shop` = 1
703 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
692 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
676 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
673 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
670 ms 1 /classes/module/Module.php:2840
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
662 ms 1 Yes /classes/Language.php:974
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
658 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
657 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 171) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
655 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
654 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
653 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
652 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
652 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "contactform" LIMIT 1
652 ms 1 /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
641 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE *
FROM `cdf_product_lang`
WHERE `id_product` = 171 AND `id_shop` = 1
641 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
636 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
636 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` = 17) LIMIT 1
630 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
616 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
616 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
605 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` = 2) LIMIT 1
598 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
597 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` = 5) LIMIT 1
596 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 171
AND `required` = 1 AND `is_deleted` = 0
592 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
592 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 67 AND `id_shop` = 1 LIMIT 1
589 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
585 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_currencyselector" LIMIT 1
583 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
578 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'home_default' LIMIT 1
578 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
576 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
565 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1
560 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
559 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 90 AND `id_shop` = 1 LIMIT 1
551 ms 0 /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` = 34) LIMIT 1
548 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `cdf_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
546 ms 0 /classes/Category.php:1371
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_designer" LIMIT 1
546 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
543 ms 1 /src/Adapter/EntityMapper.php:76
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`
538 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
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
537 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
537 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 33 AND `id_shop` = 1
537 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
534 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
532 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` = 16) LIMIT 1
528 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ph_simpleblog" LIMIT 1
527 ms 1 /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` = 6) LIMIT 1
527 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1
526 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` = 36) LIMIT 1
525 ms 1 /src/Adapter/EntityMapper.php:76
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`
521 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812