Catégorie : Kiosques 4 pans

Load Time 2000 ms
Querying Time 618 ms
Queries 263
Memory Peak Usage 59.4 Mb
Included Files 1238 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 42 ms 42 ms 18.50 Mb 18.8 Mb
__construct 0 ms 42 ms - Mb 18.8 Mb
init 248 ms 290 ms 9.14 Mb 28.6 Mb
checkAccess 0 ms 290 ms - Mb 28.6 Mb
setMedia 41 ms 331 ms 2.83 Mb 30.6 Mb
postProcess 0 ms 331 ms - Mb 30.6 Mb
initHeader 0 ms 331 ms - Mb 30.6 Mb
initContent 723 ms 1054 ms 21.86 Mb 52.4 Mb
initFooter 0 ms 1054 ms - Mb 52.4 Mb
display 946 ms 2000 ms 6.70 Mb 59.4 Mb
Hook Time Memory Usage
DisplayHeader 108 ms 3.39 Mb
displayMainMenu 99 ms 2.03 Mb
DisplayGform 94 ms 0.64 Mb
Header 61 ms 0.30 Mb
displayProductListReviews 41 ms 0.35 Mb
DisplayFooter 37 ms 0.67 Mb
displayNav1 33 ms 0.21 Mb
DisplayLeftColumn 23 ms 0.01 Mb
displayLeftColumn 22 ms 0.10 Mb
displaySearch 16 ms 0.05 Mb
displayNav2 14 ms 0.27 Mb
ModuleRoutes 13 ms 0.74 Mb
ActionFrontControllerSetMedia 13 ms 0.66 Mb
ActionOutputHTMLBefore 5 ms - Mb
displayAboveMobileMenu 4 ms 0.09 Mb
ProductSearchProvider 4 ms 0.18 Mb
DisplayAfterBodyOpeningTag 4 ms 0.02 Mb
DisplayGDPRConsent 4 ms 0.03 Mb
displayAfterBreadcrumb 3 ms 0.03 Mb
displayFooter 2 ms 0.03 Mb
DisplayTop 1 ms 0.01 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) 601 ms 9.81 Mb
Module Time Memory Usage
configurator 67 ms 4.89 Mb
gformbuilderpro 101 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 44 ms 1.68 Mb
ps_facebook 32 ms 1.32 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 86 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 57 ms 6.76 Mb
iqitcontactpage 2 ms 0.06 Mb
iqitcountdown 1 ms 0.04 Mb
iqitlinksmanager 45 ms 0.51 Mb
iqitsociallogin 2 ms 0.07 Mb
productcomments 2 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 6 ms 0.20 Mb
ets_recaptcha_free 1 ms 0.23 Mb
ps_searchbar 16 ms 0.08 Mb
iqitelementor 17 ms 1.15 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 105 ms 2.77 Mb
iqitreviews 44 ms 0.51 Mb
iqitsizecharts 3 ms 0.18 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 35 ms 0.22 Mb
ps_facetedsearch 33 ms 0.63 Mb
psgdpr 6 ms 0.22 Mb
ps_languageselector 3 ms 0.06 Mb
ps_currencyselector 2 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 4 ms 0.23 Mb
ps_categorytree 19 ms 0.14 Mb
37 module(s) 767 ms 29.68 Mb

Stopwatch SQL - 263 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
44513 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>=44 AND c.nright<=45 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
33630 ms 670 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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`
29563 ms 2100 Yes Yes /classes/Hook.php:1183
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 (131) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
21587 ms 1 Yes Yes /classes/Product.php:4479
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
13311 ms 1 /src/Adapter/EntityMapper.php:76
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
11561 ms 28 Yes Yes /classes/Category.php:793
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
10574 ms 1 /classes/Cart.php:4218
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`)
9824 ms 1308 /classes/Configuration.php:160
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 29
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
8627 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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)
8524 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
8438 ms 854 /classes/Hook.php:1283
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)
8231 ms 1 /classes/Language.php:1049
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` = 29) AND (b.`id_shop` = 1) LIMIT 1
8178 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
8166 ms 8 /classes/ImageType.php:147
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)
7593 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
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
7584 ms 1 /src/Adapter/EntityMapper.php:76
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
7514 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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 = 131
ORDER BY f.position ASC
7374 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
7223 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
6555 ms 67 /modules/configurator/configurator.php:1373
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
6536 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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
6476 ms 1 /src/Adapter/EntityMapper.php:76
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
6359 ms 1 Yes /classes/shop/Shop.php:1350
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
6272 ms 65 Yes /classes/Dispatcher.php:643
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
6105 ms 502 /classes/Hook.php:504
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`
6066 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
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`
6023 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `cdf_category` c
INNER JOIN `cdf_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `cdf_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 7
AND nleft >= 44 AND nright <= 45
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
5949 ms 5 Yes /modules/ps_categorytree/ps_categorytree.php:166
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
5905 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
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>=44 AND c.nright<=45 GROUP BY p.id_product) p
5832 ms 670 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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
5754 ms 1 /classes/Currency.php:1126
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
5751 ms 1 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
5541 ms 1 /classes/ObjectModel.php:1510
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)
5139 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
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 = 133
LIMIT 1
4960 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 131
AND image_shop.`cover` = 1 LIMIT 1
4942 ms 3 /classes/Product.php:3533
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
4791 ms 0 /classes/Hook.php:1243
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)
4752 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177
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
4733 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
4722 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
4714 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
4694 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
4202 ms 8 Yes /classes/ImageType.php:109
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 (132) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3711 ms 1 Yes Yes /classes/Product.php:4479
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
3678 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="3d71db65755e0781aa0c5e1ad73fd508" LIMIT 1
3592 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
3539 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215
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` = 131
ORDER BY `position`
3273 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
3140 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
3073 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM cdf_product p
LEFT JOIN cdf_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN cdf_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN cdf_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 132
LIMIT 1
3042 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
2926 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
2881 ms 88 /classes/Hook.php:301
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
2823 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` = 133) AND (b.`id_shop` = 1) LIMIT 1
2752 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
2694 ms 105 /classes/module/Module.php:340
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` = 131)
2645 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 131 LIMIT 1
2558 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 44) AND (a0.`nright` > 45) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
2480 ms 28 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
2422 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
2421 ms 1 /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 = 131
LIMIT 1
2404 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` = 131 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` = 131 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2389 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
2376 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 29 AND ctg.`id_group` = 1 LIMIT 1
2366 ms 1 /classes/Category.php:1730
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` = 132) AND (b.`id_shop` = 1) LIMIT 1
2224 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
2221 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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
1964 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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 (133) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1962 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 131
AND `required` = 1 AND `is_deleted` = 0
1944 ms 1 /classes/Product.php:6494
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` = 132 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` = 132 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1920 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 133 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` = 133 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1893 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
1877 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
1869 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` = 29) LIMIT 1
1869 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 131 AND `id_group` = 1 LIMIT 1
1863 ms 0 /classes/GroupReduction.php:156
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` = 133
AND image_shop.`cover` = 1 LIMIT 1
1796 ms 3 /classes/Product.php:3533
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` = 132
AND image_shop.`cover` = 1 LIMIT 1
1795 ms 3 /classes/Product.php:3533
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 = 132
ORDER BY f.position ASC
1762 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
1710 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
1689 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
1678 ms 1 /classes/module/Module.php:2840
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 = 133
ORDER BY f.position ASC
1621 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
1619 ms 1 /classes/module/Module.php:2840
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
1531 ms 1 /src/Adapter/EntityMapper.php:76
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
1502 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
1478 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
1467 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
1451 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1439 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
1438 ms 1 /classes/module/Module.php:2328
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
1413 ms 105 /classes/module/Module.php:340
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` = 132 LIMIT 1
1411 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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
1402 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
1292 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1277 ms 1 /classes/Country.php:401
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
1275 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
1255 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
1225 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
1210 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
1208 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
1202 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
1196 ms 1 /classes/Product.php:5614
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` = 29
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1191 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 132
ORDER BY `position`
1179 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1172 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 131) AND (b.`id_shop` = 1) LIMIT 1
1154 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
1143 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
1131 ms 1 /classes/Language.php:1198
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` = 133
ORDER BY `position`
1103 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
1100 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
1090 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 133) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1090 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
1088 ms 854 /classes/Hook.php:1243
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` = 133 LIMIT 1
1027 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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
1017 ms 105 /classes/module/Module.php:340
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` = 132)
1015 ms 1 /override/classes/Product.php:442
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` = 133)
1005 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
992 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
983 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
966 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
955 ms 1 /src/Adapter/EntityMapper.php:84
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
949 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
903 ms 1 /classes/shop/Shop.php:1171
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`
901 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
879 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 29 AND `id_shop` = 1
863 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
858 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
854 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
848 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 132) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
823 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
819 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 132
AND `required` = 1 AND `is_deleted` = 0
813 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
810 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
801 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
793 ms 1 /classes/Hook.php:239
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
791 ms 1 /classes/Category.php:1371
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
785 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
783 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 132
780 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
777 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
768 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
764 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
763 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_advancedformula" LIMIT 1
746 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
744 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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
744 ms 1 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
742 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_currencyselector" LIMIT 1
738 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
738 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
735 ms 1 /classes/Country.php:274
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
721 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
717 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
712 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
706 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 131 AND id_shop=1 LIMIT 1
697 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 132 AND `id_group` = 1 LIMIT 1
697 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_designer" LIMIT 1
693 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
689 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 133
AND `required` = 1 AND `is_deleted` = 0
686 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 133 AND `id_group` = 1 LIMIT 1
674 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
670 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
665 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
663 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
657 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-typewriter-addon/revslider-typewriter-addon.php' LIMIT 1
656 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 133
630 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
625 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
615 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
605 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
604 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 131) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
595 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
594 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
589 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
589 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 131
587 ms 1 /classes/Product.php:2875
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`
572 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
569 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
569 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
568 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` = 132 AND id_shop=1 LIMIT 1
563 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'home_default' LIMIT 1
544 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 133 AND id_shop=1 LIMIT 1
543 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
535 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
534 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
530 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
530 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
527 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
522 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
521 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
520 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) LIMIT 1
517 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
516 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
515 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
512 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 5) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
509 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
500 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) LIMIT 1
488 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
486 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT 1
484 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
482 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` = 27) LIMIT 1
478 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
474 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
474 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
471 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
470 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
465 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
464 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_shop
FROM `cdf_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
461 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
461 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
459 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
458 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
456 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
455 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) LIMIT 1
453 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
452 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT 1
450 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
448 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 371 AND `id_shop` = 1
445 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 36) LIMIT 1
443 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` = 28) LIMIT 1
441 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
437 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
437 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
436 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
435 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
433 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 36 AND `id_shop` = 1
431 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
428 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
427 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 35) LIMIT 1
426 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 34) LIMIT 1
424 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
421 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
421 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
420 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` = 19) LIMIT 1
418 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 35 AND `id_shop` = 1
417 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 33 AND `id_shop` = 1
417 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` = 33) LIMIT 1
416 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
411 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1
402 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
400 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
399 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) LIMIT 1
398 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` = 41) LIMIT 1
395 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` = 25) LIMIT 1
394 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
393 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` = 6) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
389 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 30 AND `id_shop` = 1
386 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
386 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` = 30) LIMIT 1
382 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) LIMIT 1
377 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` = 24) LIMIT 1
374 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) LIMIT 1
374 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
373 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
368 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
367 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` = 371) LIMIT 1
365 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
364 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
359 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
351 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1
351 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
349 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
315 ms 1 /classes/module/Module.php:2328

Doubles

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>
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>
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 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
                    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 *
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>
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 `id_product_attribute`
            FROM `cdf_product_attribute`
            WHERE `id_product` = <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 name, value, pf.id_feature, f.position
                FROM cdf_feature_product pf
                LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = <span style="color:blue">XX</span>)
                LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = <span style="color:blue">XX</span>)
                 INNER JOIN cdf_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = <span style="color:blue">XX</span>)
                WHERE pf.id_product = <span style="color:blue">XX</span>
                ORDER BY f.position ASC
3 queries
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), <span style="color:blue">XX</span>) as deep_quantity,
            COALESCE(SUM(first_level_quantity), <span style="color:blue">XX</span>) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, <span style="color:blue">XX</span> as pack_quantity
          FROM `cdf_cart_product` cp
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND cp.`id_product` = <span style="color:blue">XX</span> UNION SELECT <span style="color:blue">XX</span> as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND p.`id_product_item` = <span style="color:blue">XX</span> AND (pr.`pack_stock_type` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) OR (
            pr.`pack_stock_type` = <span style="color:blue">XX</span>
            AND <span style="color:blue">XX</span> = <span style="color:blue">XX</span>
        ))) as q LIMIT <span style="color:blue">XX</span>
3 queries
SELECT `id_order`
            FROM `cdf_orders`
            WHERE `id_cart` = <span style="color:blue">XX</span> AND id_shop IN (<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
3 queries
SELECT SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = <span style="color:blue">XX</span>) AND (id_product_attribute = <span style="color:blue">XX</span>) AND (id_shop = <span style="color:blue">XX</span>) AND (id_shop_group = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
3 queries
				SELECT (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 `name`
							FROM `cdf_hook`
							WHERE `id_hook` = <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>
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 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 `id_lang` FROM `cdf_lang`
                    WHERE `locale` = 'fr-fr'
                    OR `language_code` = 'fr-fr' 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 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 *
							FROM `cdf_iqit_link_block_lang`
							WHERE `id_iqit_link_block` = <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 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 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 *
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

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

ObjectModel instances

Name Instances Source
Category 32 /controllers/front/listing/CategoryController.php [89]
/classes/Meta.php [380]
/classes/PrestaShopCollection.php [383]
/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]
Country 4 /config/config.inc.php [157]
/classes/controller/FrontController.php [374]
/classes/AddressFormat.php [404]
/classes/controller/FrontController.php [1677]
Address 4 /classes/shop/Shop.php [469]
/classes/Product.php [3654]
/override/classes/Product.php [396]
/classes/Product.php [5840]
Combination 3 /classes/Product.php [5802]
/classes/Product.php [5802]
/classes/Product.php [5802]
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]
Shop 1 /config/config.inc.php [128]
ConfiguratorCartDetailModel 1 /modules/configurator/configurator.php [1687]
gformbuilderproModel 1 /modules/gformbuilderpro/gformbuilderpro.php [828]
Tax 1 /classes/tax/TaxRulesTaxManager.php [116]
Risk 1 /classes/controller/FrontController.php [1609]
State 1 /classes/controller/FrontController.php [1676]
AddressFormat 1 /classes/controller/FrontController.php [1671]
Gender 1 /classes/controller/FrontController.php [1606]
Group 1 /classes/Cart.php [248]
Cart 1 /classes/controller/FrontController.php [443]
Customer 1 /config/config.inc.php [249]
ShopGroup 1 /classes/shop/Shop.php [557]
CMS 1 /classes/Link.php [560]

Included Files

# Filename
0 /index.php
1 /config/config.inc.php
2 /config/defines.inc.php
3 /config/autoload.php
4 /vendor/autoload.php
5 /vendor/composer/autoload_real.php
6 /vendor/composer/platform_check.php
7 /vendor/composer/ClassLoader.php
8 /vendor/composer/include_paths.php
9 /vendor/composer/autoload_static.php
10 /vendor/paragonie/random_compat/lib/random.php
11 /vendor/symfony/polyfill-php70/bootstrap.php
12 /vendor/symfony/polyfill-php72/bootstrap.php
13 /vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14 /vendor/symfony/polyfill-intl-idn/bootstrap.php
15 /vendor/react/promise/src/functions_include.php
16 /vendor/react/promise/src/functions.php
17 /vendor/symfony/polyfill-ctype/bootstrap.php
18 /vendor/symfony/polyfill-mbstring/bootstrap.php
19 /vendor/symfony/polyfill-iconv/bootstrap.php
20 /vendor/swiftmailer/swiftmailer/lib/swift_required.php
21 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
22 /vendor/symfony/polyfill-php73/bootstrap.php
23 /vendor/symfony/polyfill-php56/bootstrap.php
24 /vendor/symfony/polyfill-intl-icu/bootstrap.php
25 /vendor/symfony/polyfill-apcu/bootstrap.php
26 /vendor/markbaker/matrix/classes/src/functions/adjoint.php
27 /vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
28 /vendor/markbaker/matrix/classes/src/functions/cofactors.php
29 /vendor/markbaker/matrix/classes/src/functions/determinant.php
30 /vendor/markbaker/matrix/classes/src/functions/diagonal.php
31 /vendor/markbaker/matrix/classes/src/functions/identity.php
32 /vendor/markbaker/matrix/classes/src/functions/inverse.php
33 /vendor/markbaker/matrix/classes/src/functions/minors.php
34 /vendor/markbaker/matrix/classes/src/functions/trace.php
35 /vendor/markbaker/matrix/classes/src/functions/transpose.php
36 /vendor/markbaker/matrix/classes/src/operations/add.php
37 /vendor/markbaker/matrix/classes/src/operations/directsum.php
38 /vendor/markbaker/matrix/classes/src/operations/subtract.php
39 /vendor/markbaker/matrix/classes/src/operations/multiply.php
40 /vendor/markbaker/matrix/classes/src/operations/divideby.php
41 /vendor/markbaker/matrix/classes/src/operations/divideinto.php
42 /vendor/markbaker/complex/classes/src/functions/abs.php
43 /vendor/markbaker/complex/classes/src/functions/acos.php
44 /vendor/markbaker/complex/classes/src/functions/acosh.php
45 /vendor/markbaker/complex/classes/src/functions/acot.php
46 /vendor/markbaker/complex/classes/src/functions/acoth.php
47 /vendor/markbaker/complex/classes/src/functions/acsc.php
48 /vendor/markbaker/complex/classes/src/functions/acsch.php
49 /vendor/markbaker/complex/classes/src/functions/argument.php
50 /vendor/markbaker/complex/classes/src/functions/asec.php
51 /vendor/markbaker/complex/classes/src/functions/asech.php
52 /vendor/markbaker/complex/classes/src/functions/asin.php
53 /vendor/markbaker/complex/classes/src/functions/asinh.php
54 /vendor/markbaker/complex/classes/src/functions/atan.php
55 /vendor/markbaker/complex/classes/src/functions/atanh.php
56 /vendor/markbaker/complex/classes/src/functions/conjugate.php
57 /vendor/markbaker/complex/classes/src/functions/cos.php
58 /vendor/markbaker/complex/classes/src/functions/cosh.php
59 /vendor/markbaker/complex/classes/src/functions/cot.php
60 /vendor/markbaker/complex/classes/src/functions/coth.php
61 /vendor/markbaker/complex/classes/src/functions/csc.php
62 /vendor/markbaker/complex/classes/src/functions/csch.php
63 /vendor/markbaker/complex/classes/src/functions/exp.php
64 /vendor/markbaker/complex/classes/src/functions/inverse.php
65 /vendor/markbaker/complex/classes/src/functions/ln.php
66 /vendor/markbaker/complex/classes/src/functions/log2.php
67 /vendor/markbaker/complex/classes/src/functions/log10.php
68 /vendor/markbaker/complex/classes/src/functions/negative.php
69 /vendor/markbaker/complex/classes/src/functions/pow.php
70 /vendor/markbaker/complex/classes/src/functions/rho.php
71 /vendor/markbaker/complex/classes/src/functions/sec.php
72 /vendor/markbaker/complex/classes/src/functions/sech.php
73 /vendor/markbaker/complex/classes/src/functions/sin.php
74 /vendor/markbaker/complex/classes/src/functions/sinh.php
75 /vendor/markbaker/complex/classes/src/functions/sqrt.php
76 /vendor/markbaker/complex/classes/src/functions/tan.php
77 /vendor/markbaker/complex/classes/src/functions/tanh.php
78 /vendor/markbaker/complex/classes/src/functions/theta.php
79 /vendor/markbaker/complex/classes/src/operations/add.php
80 /vendor/markbaker/complex/classes/src/operations/subtract.php
81 /vendor/markbaker/complex/classes/src/operations/multiply.php
82 /vendor/markbaker/complex/classes/src/operations/divideby.php
83 /vendor/markbaker/complex/classes/src/operations/divideinto.php
84 /vendor/jakeasmith/http_build_url/src/http_build_url.php
85 /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
86 /vendor/ircmaxell/password-compat/lib/password.php
87 /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
88 /app/AppKernel.php
89 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
90 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
91 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php
92 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/RebootableInterface.php
93 /vendor/symfony/symfony/src/Symfony/Component/HttpKernel/TerminableInterface.php
94 /config/alias.php
95 /classes/PrestaShopAutoload.php
96 /var/cache/prod/class_index.php
97 /config/bootstrap.php
98 /src/Core/ContainerBuilder.php
99 /src/Core/Foundation/IoC/Container.php
100 /src/Adapter/ServiceLocator.php
101 /vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
102 /var/cache/prod/appParameters.php
105 /classes/controller/Controller.php
107 /classes/ObjectModel.php
108 /src/Core/Foundation/Database/EntityInterface.php
110 /classes/db/Db.php
112 /classes/Hook.php
114 /classes/module/Module.php
115 /src/Core/Module/ModuleInterface.php
117 /classes/Tools.php
118 /classes/Context.php
119 /classes/shop/Shop.php
120 /classes/db/DbPDO.php
121 /classes/AddressFormat.php
122 /classes/Configuration.php
123 /classes/Validate.php
124 /classes/cache/Cache.php
125 /src/Adapter/EntityMapper.php
126 /classes/db/DbQuery.php
127 /src/Core/Addon/Theme/ThemeManagerBuilder.php
128 /src/Adapter/Configuration.php
129 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
130 /src/Core/Domain/Configuration/ShopConfigurationInterface.php
131 /src/Core/ConfigurationInterface.php
132 /src/Core/Addon/Theme/ThemeRepository.php
133 /src/Core/Addon/AddonRepositoryInterface.php
134 /src/Core/Domain/Shop/ValueObject/ShopConstraint.php
135 /src/Core/Addon/Theme/Theme.php
136 /src/Core/Addon/AddonInterface.php
137 /src/Core/Util/File/YamlParser.php
138 /classes/PrestaShopCollection.php
139 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php