Catégorie : Terrasses

Load Time 2285 ms
Querying Time 584 ms
Queries 274
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 43 ms 43 ms 18.50 Mb 18.8 Mb
__construct 0 ms 43 ms - Mb 18.8 Mb
init 242 ms 285 ms 9.16 Mb 28.6 Mb
checkAccess 0 ms 285 ms - Mb 28.6 Mb
setMedia 39 ms 324 ms 2.83 Mb 30.6 Mb
postProcess 0 ms 324 ms - Mb 30.6 Mb
initHeader 0 ms 324 ms - Mb 30.6 Mb
initContent 1003 ms 1328 ms 21.98 Mb 52.5 Mb
initFooter 0 ms 1328 ms - Mb 52.5 Mb
display 957 ms 2285 ms 6.70 Mb 59.5 Mb
Hook Time Memory Usage
displayMainMenu 166 ms 2.03 Mb
DisplayHeader 138 ms 3.38 Mb
DisplayFooter 82 ms 0.67 Mb
Header 60 ms 0.30 Mb
DisplayGform 57 ms 0.64 Mb
displayNav1 33 ms 0.20 Mb
displayProductListReviews 23 ms 0.29 Mb
displayLeftColumn 16 ms 0.11 Mb
displayNav2 13 ms 0.21 Mb
ActionFrontControllerSetMedia 12 ms 0.66 Mb
ModuleRoutes 12 ms 0.74 Mb
DisplayLeftColumn 8 ms 0.01 Mb
displaySearch 8 ms 0.05 Mb
displayAboveMobileMenu 8 ms 0.08 Mb
ActionOutputHTMLBefore 5 ms - Mb
DisplayAfterBodyOpeningTag 5 ms 0.02 Mb
ProductSearchProvider 4 ms 0.18 Mb
DisplayGDPRConsent 4 ms 0.03 Mb
displayAfterBreadcrumb 2 ms 0.03 Mb
DisplayTop 1 ms 0.01 Mb
displayFooter 1 ms 0.03 Mb
ActionDispatcherBefore 0 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) 660 ms 9.67 Mb
Module Time Memory Usage
configurator 58 ms 4.89 Mb
gformbuilderpro 65 ms 1.40 Mb
ps_mbo 5 ms 0.26 Mb
iqitthemeeditor 4 ms 0.53 Mb
ps_emailsubscription 4 ms 0.38 Mb
ps_checkout 51 ms 1.68 Mb
ps_facebook 30 ms 1.32 Mb
paybox 10 ms 0.68 Mb
lgcookieslaw 174 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 51 ms 6.76 Mb
iqitcontactpage 1 ms 0.06 Mb
iqitcountdown 1 ms 0.04 Mb
iqitlinksmanager 44 ms 0.45 Mb
iqitsociallogin 2 ms 0.07 Mb
productcomments 2 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 5 ms 0.20 Mb
ets_recaptcha_free 1 ms 0.23 Mb
ps_searchbar 9 ms 0.08 Mb
iqitelementor 21 ms 1.14 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 172 ms 2.77 Mb
iqitreviews 26 ms 0.44 Mb
iqitsizecharts 2 ms 0.18 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 26 ms 0.22 Mb
ps_facetedsearch 19 ms 0.63 Mb
psgdpr 6 ms 0.22 Mb
ps_languageselector 3 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 3 ms 0.23 Mb
ps_categorytree 14 ms 0.14 Mb
37 module(s) 822 ms 29.61 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 274 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
 29552 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>=35 AND c.nright<=40 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
 20968 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
 17171 ms 1 /classes/Cart.php:4218 
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`
 15692 ms 2100 Yes Yes /classes/Hook.php:1183 
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`
 12872 ms 1 Yes /classes/CMS.php:151 
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 (144) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 12587 ms 1 Yes Yes /classes/Product.php:4479 
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
 12217 ms 28 Yes Yes /classes/Category.php:793 
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 = 144
ORDER BY f.position ASC
 11851 ms 1 Yes /classes/Product.php:5897 
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
 10705 ms 1 /src/Adapter/EntityMapper.php:76 
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` = 24) AND (b.`id_shop` = 1) LIMIT 1
 9672 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
 8410 ms 1 /classes/Currency.php:1126 
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
 8117 ms 0 /classes/Hook.php:1243 
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)
 8112 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`)
 7938 ms 1308 /classes/Configuration.php:160 
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)
 7936 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355 
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
 7897 ms 854 /classes/Hook.php:1283 
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
 7780 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
 7634 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178 
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
 7602 ms 65 Yes /classes/Dispatcher.php:643 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=144 AND c.active= 1 LIMIT 1
 7116 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
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
 7029 ms 1 /src/Adapter/EntityMapper.php:76 
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
 6826 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM cdf_iqit_link_block cb
INNER JOIN cdf_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 545
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
 6723 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 56 AND `id_shop` = 1
 6094 ms 1 /src/Adapter/EntityMapper.php:84 
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)
 6059 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25 
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` = 144 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` = 144 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 5787 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
 5499 ms 8 /classes/ImageType.php:147 
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
 5330 ms 1 /src/Adapter/EntityMapper.php:76 
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
 5316 ms 1 /src/Adapter/EntityMapper.php:76 
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
 5273 ms 502 /classes/Hook.php:504 
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
 5001 ms 67 /modules/configurator/configurator.php:1373 
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
 4625 ms 1 Yes /classes/shop/Shop.php:1350 
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 = 145
LIMIT 1
 4435 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
 4415 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127 
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)
 4374 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355 
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` = 144
AND image_shop.`cover` = 1 LIMIT 1
 4350 ms 3 /classes/Product.php:3533 
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)
 4322 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 4150 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
 4041 ms 1 Yes /classes/Currency.php:709 
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`
 3764 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
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` = 144 LIMIT 1
 3662 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 24 AND ctg.`id_group` = 1 LIMIT 1
 3426 ms 1 /classes/Category.php:1730 
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 = 146
LIMIT 1
 3398 ms 1 /classes/ProductAssembler.php:95 
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
 3391 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132 
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
 3359 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 56) LIMIT 1
 3359 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 144
AND `required` = 1 AND `is_deleted` = 0
 3324 ms 1 /classes/Product.php:6494 
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 3204 ms 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
 3122 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215 
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
 3103 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 24
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 3074 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
 3050 ms 0 /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` = 145 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` = 145 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2981 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
 2890 ms 1 /classes/AddressFormat.php:672 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
 2876 ms 1 /src/Adapter/EntityMapper.php:84 
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
 2795 ms 1 Yes /classes/shop/Shop.php:711 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 145
 2697 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
 2688 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
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 = 145
ORDER BY f.position ASC
 2682 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` = 144
ORDER BY `position`
 2673 ms 3 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
 2622 ms 1 /classes/module/Module.php:2237 
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
 2527 ms 1 /src/Adapter/EntityMapper.php:84 
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>=35 AND c.nright<=40 GROUP BY p.id_product) p
 2495 ms 402 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86 
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 35) AND (a0.`nright` > 40) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
 2491 ms 28 Yes /classes/PrestaShopCollection.php:381 
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` = 144)
 2450 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
 2434 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85 
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` = 145
ORDER BY `position`
 2363 ms 3 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 145
AND image_shop.`cover` = 1 LIMIT 1
 2341 ms 3 /classes/Product.php:3533 
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
 2319 ms 88 /classes/Hook.php:301 
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 (146) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 2271 ms 1 Yes Yes /classes/Product.php:4479 
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 >= 35 AND nright <= 40
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
 2196 ms 28 Yes /modules/ps_categorytree/ps_categorytree.php:166 
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
 2153 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="292509f83aa3a104f3587641f2a3cc07" LIMIT 1
 2138 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
 2087 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'home_default' LIMIT 1
 2073 ms 1 /classes/Image.php:510 
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
 2070 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 144 AND id_shop=1 LIMIT 1
 2009 ms 1 /classes/Product.php:6751 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
 1997 ms 1 /classes/ObjectModel.php:1510 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 144 AND `id_group` = 1 LIMIT 1
 1935 ms 0 /classes/GroupReduction.php:156 
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` = 146) AND (b.`id_shop` = 1) LIMIT 1
 1909 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `cdf_category` c
INNER JOIN cdf_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `cdf_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `cdf_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 24
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 1840 ms 2 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` = 146
AND image_shop.`cover` = 1 LIMIT 1
 1825 ms 3 /classes/Product.php:3533 
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 (145) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 1802 ms 1 Yes Yes /classes/Product.php:4479 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
 1683 ms 1 /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
 1552 ms 1 /classes/Language.php:1198 
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
 1529 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 1497 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
 1497 ms 1 /classes/Group.php:154 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 1496 ms 0 /classes/module/Module.php:2328 
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 = 144
LIMIT 1
 1484 ms 1 /classes/ProductAssembler.php:95 
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` = 146 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` = 146 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1466 ms 0 /classes/Cart.php:1429 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 145 AND id_shop=1 LIMIT 1
 1446 ms 1 /classes/Product.php:6751 
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 = 146
ORDER BY f.position ASC
 1436 ms 1 Yes /classes/Product.php:5897 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 1432 ms 1 /classes/order/Order.php:1203 
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
 1420 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
 1419 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 145) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1401 ms 1 /classes/stock/StockAvailable.php:453 
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
 1373 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
 1360 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 1325 ms 1 /src/Adapter/EntityMapper.php:76 
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
 1265 ms 0 /classes/tax/TaxRulesTaxManager.php:109 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
 1261 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
 1244 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` = 146 LIMIT 1
 1202 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
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` = 144) AND (b.`id_shop` = 1) LIMIT 1
 1202 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
 1188 ms 88 /classes/Hook.php:353 
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
 1170 ms 1 /classes/shop/Shop.php:205 
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` = 146)
 1163 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
 1152 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=145 AND c.active= 1 LIMIT 1
 1140 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 144) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1134 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 1115 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 1106 ms 1 /classes/shop/ShopUrl.php:182 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 145 AND `id_group` = 1 LIMIT 1
 1086 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
 1072 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` = 41) LIMIT 1
 1066 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
 1050 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 1047 ms 1 /classes/Product.php:5614 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 145
AND `required` = 1 AND `is_deleted` = 0
 1045 ms 1 /classes/Product.php:6494 
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` = 146
ORDER BY `position`
 1036 ms 3 Yes /classes/Product.php:3508 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
 1033 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
 1021 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 1016 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
 1006 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
 1006 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
 1002 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 57 AND `id_shop` = 1
 993 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
 992 ms 854 /classes/Hook.php:1243 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
 975 ms 1 /src/Adapter/EntityMapper.php:84 
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`
 969 ms 1 Yes /classes/CMS.php:151 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
 954 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
 952 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
 941 ms 1 /classes/module/Module.php:2328 
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` = 145) AND (b.`id_shop` = 1) LIMIT 1
 932 ms 1 /src/Adapter/EntityMapper.php:76 
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
 926 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
 925 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
 889 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 875 ms 1 /classes/Language.php:853 
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=146 AND c.active= 1 LIMIT 1
 855 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366 
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
 843 ms 105 /classes/module/Module.php:340 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
 836 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 36 AND `id_shop` = 1
 832 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 830 ms 1 /classes/Country.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` = 145 LIMIT 1
 819 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
 818 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 371 AND `id_shop` = 1
 815 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 57) LIMIT 1
 811 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
 808 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
 805 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
 799 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
 794 ms 1 /classes/order/Order.php:1203 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
 786 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 780 ms 1 /classes/shop/Shop.php:1171 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
 773 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
 745 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 146) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 743 ms 1 /classes/stock/StockAvailable.php:453 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
 738 ms 1 /classes/ObjectModel.php:1647 
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
 738 ms 1 Yes /classes/Language.php:974 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 728 ms 1 /classes/ObjectModel.php:1647 
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
 725 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
 708 ms 1 /classes/Hook.php:239 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
 707 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
 705 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
 704 ms 1 /classes/Language.php:853 
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 36) LIMIT 1
 696 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 146 AND id_shop=1 LIMIT 1
 696 ms 1 /classes/Product.php:6751 
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` = 145)
 695 ms 1 /override/classes/Product.php:442 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 144
 689 ms 1 /classes/Product.php:2875 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
 687 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
 686 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
 668 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
 667 ms 1 /classes/Country.php:274 
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
 663 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
 662 ms 1 /classes/Image.php:510 
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
 646 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 146
 635 ms 1 /classes/Product.php:2875 
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` = 25) AND (b.`id_shop` = 1) LIMIT 1
 628 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 146
AND `required` = 1 AND `is_deleted` = 0
 626 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
 615 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
 613 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
 610 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
 607 ms 1 /classes/Country.php:401 
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` = 26) AND (b.`id_shop` = 1) LIMIT 1
 599 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
 586 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
 579 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 146 AND `id_group` = 1 LIMIT 1
 558 ms 0 /classes/GroupReduction.php:156 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
 554 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
 554 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
 554 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
 542 ms 0 /classes/module/Module.php:2840 
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
 539 ms 1 /classes/Category.php:1371 
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
 537 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
 536 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT 1
 536 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` = 6) LIMIT 1
 528 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` = 5) LIMIT 1
 520 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
 519 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` = 3) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
 518 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` = 29) LIMIT 1
 516 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_currencyselector" LIMIT 1
 511 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` = 19) LIMIT 1
 510 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
 506 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
 506 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
 503 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
 500 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` = 30) LIMIT 1
 495 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
 489 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` = 35) LIMIT 1
 486 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` = 26) LIMIT 1
 477 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
 476 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
 472 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` = 15) LIMIT 1
 465 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
 460 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 29 AND `id_shop` = 1
 454 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
 447 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 445 ms 1 /classes/Currency.php:893 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
 443 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
 442 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
 440 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
 440 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
 439 ms 1 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
 435 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` = 34) LIMIT 1
 435 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
 433 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
 431 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
 428 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
 427 ms 1 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
 427 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
 422 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
 422 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
 417 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
 414 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 35 AND `id_shop` = 1
 414 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 30 AND `id_shop` = 1
 403 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
 403 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` = 36) LIMIT 1
 400 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
 398 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
 396 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
 394 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`
 386 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
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`
 383 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
 382 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
 380 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
 372 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` = 14) LIMIT 1
 371 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_advancedformula" LIMIT 1
 371 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT 1
 370 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` = 27) LIMIT 1
 369 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
 369 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_designer" LIMIT 1
 367 ms 0 /classes/module/Module.php:2840 
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
 366 ms 1 /classes/Product.php:5614 
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
 363 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
 358 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
 357 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
 357 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` = 28) LIMIT 1
 356 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` = 13) LIMIT 1
 356 ms 1 /src/Adapter/EntityMapper.php:76 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
 355 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE id_shop
FROM `cdf_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 352 ms 1 /classes/ObjectModel.php:1647 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
 350 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
 349 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
 348 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
 347 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1
 347 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 36 AND `id_shop` = 1
 346 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
 346 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
 344 ms 0 /classes/module/Module.php:2328 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
 340 ms 1 /src/Adapter/EntityMapper.php:84 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
 340 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
 329 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
 324 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
 322 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193 
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 33 AND `id_shop` = 1
 320 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
 311 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193

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 `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 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 *
FROM `cdf_category` a
LEFT JOIN `cdf_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = <span style="color:blue">XX</span>
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>) AND (b.`id_shop` = <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 *
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 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 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 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 `name`
							FROM `cdf_hook`
							WHERE `id_hook` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
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 option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' 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 option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT <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 `id_lang` FROM `cdf_lang`
                    WHERE `locale` = 'fr-fr'
                    OR `language_code` = 'fr-fr' LIMIT <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 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 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`
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 *
							FROM `cdf_iqit_link_block_lang`
							WHERE `id_iqit_link_block` = <span style="color:blue">XX</span>
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>

Tables stress

36 category_lang
35 category
32 module
31 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 33 /controllers/front/listing/CategoryController.php [89]
/controllers/front/listing/CategoryController.php [211]
/controllers/front/listing/CategoryController.php [211]
/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/func