Catégorie : Abris Camping-car

Load Time 2027 ms
Querying Time 697 ms
Queries 292
Memory Peak Usage 60.0 Mb
Included Files 1241 files - 14.71 Mb
PrestaShop Cache - Mb
Global vars 1.02 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 62 ms 62 ms 18.50 Mb 18.8 Mb
__construct 0 ms 62 ms - Mb 18.8 Mb
init 253 ms 314 ms 9.26 Mb 28.6 Mb
checkAccess 0 ms 314 ms - Mb 28.6 Mb
setMedia 44 ms 358 ms 2.83 Mb 30.8 Mb
postProcess 0 ms 358 ms - Mb 30.8 Mb
initHeader 0 ms 358 ms - Mb 30.8 Mb
initContent 1049 ms 1407 ms 22.21 Mb 52.9 Mb
initFooter 0 ms 1407 ms - Mb 52.9 Mb
display 620 ms 2027 ms 6.80 Mb 60.0 Mb
Hook Time Memory Usage
DisplayHeader 136 ms 3.39 Mb
displayMainMenu 109 ms 2.04 Mb
DisplayGform 68 ms 0.58 Mb
Header 65 ms 0.30 Mb
DisplayFooter 40 ms 0.67 Mb
displayProductListReviews 31 ms 0.34 Mb
ModuleRoutes 25 ms 0.74 Mb
displayNav1 25 ms 0.27 Mb
displayLeftColumn 15 ms 0.10 Mb
displayNav2 15 ms 0.21 Mb
ActionFrontControllerSetMedia 14 ms 0.66 Mb
displayAboveMobileMenu 10 ms 0.09 Mb
displaySearch 6 ms 0.05 Mb
ActionOutputHTMLBefore 5 ms - Mb
DisplayAfterBodyOpeningTag 5 ms 0.02 Mb
DisplayLeftColumn 4 ms 0.01 Mb
ProductSearchProvider 4 ms 0.18 Mb
DisplayGDPRConsent 3 ms 0.03 Mb
displayAfterBreadcrumb 3 ms 0.03 Mb
displayFooter 1 ms 0.03 Mb
DisplayTop 1 ms 0.07 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayBeforeBodyClosingTag 0 ms - Mb
DisplayProductPriceBlock 0 ms 0.01 Mb
displayVerticalMenu 0 ms - Mb
ActionDispatcher 0 ms - Mb
ActionProductSearchAfter 0 ms - Mb
Top 0 ms - Mb
28 hook(s) 587 ms 9.79 Mb
Module Time Memory Usage
configurator 86 ms 4.89 Mb
gformbuilderpro 77 ms 1.34 Mb
ps_mbo 5 ms 0.26 Mb
iqitthemeeditor 5 ms 0.53 Mb
ps_emailsubscription 4 ms 0.38 Mb
ps_checkout 39 ms 1.68 Mb
ps_facebook 35 ms 1.32 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 120 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 55 ms 6.76 Mb
iqitcontactpage 1 ms 0.06 Mb
iqitcountdown 2 ms 0.04 Mb
iqitlinksmanager 38 ms 0.51 Mb
iqitsociallogin 1 ms 0.07 Mb
productcomments 2 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 5 ms 0.26 Mb
ets_recaptcha_free 1 ms 0.17 Mb
ps_searchbar 6 ms 0.08 Mb
iqitelementor 23 ms 1.15 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 115 ms 2.84 Mb
iqitreviews 34 ms 0.43 Mb
iqitsizecharts 2 ms 0.18 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 44 ms 0.21 Mb
ps_facetedsearch 15 ms 0.63 Mb
psgdpr 5 ms 0.22 Mb
ps_languageselector 3 ms 0.07 Mb
ps_currencyselector 2 ms 0.07 Mb
pagesnotfound 2 ms 0.27 Mb
sekeywords 1 ms 0.14 Mb
iqitsearch 1 ms - Mb
ps_customersignin 0 ms 0.02 Mb
iqitproductsnav 4 ms 0.23 Mb
ps_categorytree 13 ms 0.14 Mb
37 module(s) 764 ms 29.60 Mb

Stopwatch SQL - 292 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
33550 ms 35022 /modules/gformbuilderpro/gformbuilderpro.php:380
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`
18436 ms 2100 Yes Yes /classes/Hook.php:1183
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>=7 AND c.nright<=8 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
17140 ms 18 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE *
FROM `cdf_gformbuilderpro` a
LEFT JOIN `cdf_gformbuilderpro_lang` `b` ON a.`id_gformbuilderpro` = b.`id_gformbuilderpro` AND b.`id_lang` = 1
LEFT JOIN `cdf_gformbuilderpro_shop` `c` ON a.`id_gformbuilderpro` = c.`id_gformbuilderpro` AND c.`id_shop` = 1
WHERE (a.`id_gformbuilderpro` = 6) LIMIT 1
16526 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
16205 ms 67 /modules/configurator/configurator.php:1373
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
12881 ms 65 Yes /classes/Dispatcher.php:643
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
12851 ms 1 /classes/Cart.php:4218
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 (121) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
12825 ms 1 Yes Yes /classes/Product.php:4479
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)
11597 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE *
FROM `cdf_country` a
LEFT JOIN `cdf_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `cdf_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
11171 ms 1 /src/Adapter/EntityMapper.php:76
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`)
8844 ms 1308 /classes/Configuration.php:160
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
8802 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 121
ORDER BY f.position ASC
8703 ms 1 Yes /classes/Product.php:5897
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
8320 ms 0 /classes/Hook.php:1243
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` = 5) AND (b.`id_shop` = 1) LIMIT 1
8221 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=121 AND c.active= 1 LIMIT 1
7856 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
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
7716 ms 1 Yes /classes/shop/Shop.php:1350
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` = 121)
7634 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
7568 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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` = 121 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` = 121 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
7264 ms 0 /classes/Cart.php:1429
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
7122 ms 502 /classes/Hook.php:504
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)
7109 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
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)
7055 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 5
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
7023 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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
6948 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
6773 ms 1 /classes/AddressFormat.php:672
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
6508 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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 = 123
ORDER BY f.position ASC
6495 ms 1 Yes /classes/Product.php:5897
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
6453 ms 28 Yes Yes /classes/Category.php:793
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 24 AND `id_shop` = 1
6185 ms 1 /src/Adapter/EntityMapper.php:84
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
6124 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` = 1) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
6102 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` = 121 LIMIT 1
6027 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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`
5716 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
5676 ms 854 /classes/Hook.php:1283
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
5670 ms 1 /classes/order/Order.php:1203
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)
5373 ms 1 /classes/Language.php:1049
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
5319 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 121
ORDER BY `position`
5199 ms 4 Yes /classes/Product.php:3508
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 = 122
LIMIT 1
5085 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
4996 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
4825 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
4517 ms 1 /src/Adapter/EntityMapper.php:84
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 = 120
LIMIT 1
4428 ms 1 /classes/ProductAssembler.php:95
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
4398 ms 1 Yes /classes/shop/Shop.php:711
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)
4385 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177
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
4368 ms 1 /classes/Currency.php:1126
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` = 122 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` = 122 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
4053 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` = 123 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` = 123 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3984 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 24) LIMIT 1
3820 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
3775 ms 88 /classes/Hook.php:301
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
3720 ms 1 /classes/ObjectModel.php:1510
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 = 121
LIMIT 1
3690 ms 1 /classes/ProductAssembler.php:95
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 = 123
LIMIT 1
3543 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
3402 ms 8 /classes/ImageType.php:147
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` = 121
AND image_shop.`cover` = 1 LIMIT 1
3224 ms 4 /classes/Product.php:3533
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
3180 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
2992 ms 8 Yes /classes/ImageType.php:109
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` = 121) AND (b.`id_shop` = 1) LIMIT 1
2965 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
2877 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
2874 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215
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 >= 7 AND nright <= 8
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
2829 ms 3 Yes /modules/ps_categorytree/ps_categorytree.php:166
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 = 122
ORDER BY f.position ASC
2800 ms 1 Yes /classes/Product.php:5897
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` = 120 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` = 120 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2740 ms 0 /classes/Cart.php:1429
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` = 122
ORDER BY `position`
2710 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
2661 ms 1 /classes/module/Module.php:2237
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` = 122
AND image_shop.`cover` = 1 LIMIT 1
2633 ms 4 /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 (123) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2615 ms 1 Yes Yes /classes/Product.php:4479
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` = 120) AND (b.`id_shop` = 1) LIMIT 1
2614 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 5 AND ctg.`id_group` = 1 LIMIT 1
2572 ms 1 /classes/Category.php:1730
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
2557 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM cdf_iqit_link_block cb
INNER JOIN cdf_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 583
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
2525 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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
2485 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="e4c3efd2b2ad2b0554c3a1b8584e03a5" LIMIT 1
2477 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
2471 ms 1 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
2396 ms 854 /classes/Hook.php:1243
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
2317 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 122
AND `required` = 1 AND `is_deleted` = 0
2314 ms 1 /classes/Product.php:6494
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` = 122) AND (b.`id_shop` = 1) LIMIT 1
2262 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
2212 ms 1 /src/Adapter/EntityMapper.php:76
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>=7 AND c.nright<=8 GROUP BY p.id_product) p
2203 ms 18 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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 = 120
ORDER BY f.position ASC
2200 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
2199 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 121 AND `id_group` = 1 LIMIT 1
2133 ms 0 /classes/GroupReduction.php:156
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 (120) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2120 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 49 AND `id_shop` = 1
2093 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 123) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2051 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
2006 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
1994 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 7) AND (a0.`nright` > 8) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
1978 ms 4 /classes/PrestaShopCollection.php:381
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
1975 ms 105 /classes/module/Module.php:340
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 (122) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1968 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
1918 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1912 ms 1 /classes/Country.php:401
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
1903 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1901 ms 1 /classes/Country.php:274
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` = 120
ORDER BY `position`
1891 ms 4 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
1840 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` = 41) LIMIT 1
1834 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
1824 ms 1 /classes/order/Order.php:1203
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
1823 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 122
1801 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 123)
1795 ms 1 /override/classes/Product.php:442
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` = 123
AND image_shop.`cover` = 1 LIMIT 1
1772 ms 4 /classes/Product.php:3533
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` = 120)
1755 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1698 ms 105 /classes/module/Module.php:340
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
1689 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 120
AND image_shop.`cover` = 1 LIMIT 1
1684 ms 4 /classes/Product.php:3533
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
1666 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
1661 ms 1 /classes/module/Module.php:2840
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` = 123) AND (b.`id_shop` = 1) LIMIT 1
1589 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 123 AND `id_group` = 1 LIMIT 1
1589 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=120 AND c.active= 1 LIMIT 1
1582 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
1570 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
1546 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
1538 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=122 AND c.active= 1 LIMIT 1
1484 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 123 AND id_shop=1 LIMIT 1
1484 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=123 AND c.active= 1 LIMIT 1
1479 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
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`
1460 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
1455 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_shop
FROM `cdf_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
1454 ms 1 /classes/ObjectModel.php:1647
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` = 122)
1405 ms 1 /override/classes/Product.php:442
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` = 5
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1382 ms 1 Yes Yes /classes/Category.php:919
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
1373 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
1363 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 122 AND id_shop=1 LIMIT 1
1352 ms 1 /classes/Product.php:6751
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` = 123
ORDER BY `position`
1345 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 122) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1299 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 120 AND id_shop=1 LIMIT 1
1298 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
1295 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` = 371) LIMIT 1
1288 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 121
1278 ms 1 /classes/Product.php:2875
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` = 122 LIMIT 1
1258 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
1254 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1250 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
1221 ms 1 /classes/Product.php:5614
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`
1214 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
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
1203 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
1199 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` = 30) LIMIT 1
1199 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 47 AND `id_shop` = 1
1190 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 120
1185 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
1175 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 49) LIMIT 1
1162 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 123
AND `required` = 1 AND `is_deleted` = 0
1156 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
1138 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
1124 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 120) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1110 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 121
AND `required` = 1 AND `is_deleted` = 0
1108 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
1080 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
1072 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
1063 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 47) LIMIT 1
1046 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 120
AND `required` = 1 AND `is_deleted` = 0
1040 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
1028 ms 1 /src/Adapter/EntityMapper.php:84
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
1027 ms 1 Yes /classes/Language.php:974
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
1024 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 48 AND `id_shop` = 1
996 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
995 ms 0 /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
994 ms 1 /classes/Language.php:1198
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
993 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` = 33) LIMIT 1
991 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
978 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
972 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
966 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
965 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 122 AND `id_group` = 1 LIMIT 1
962 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 120 AND `id_group` = 1 LIMIT 1
961 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
949 ms 1 /src/Adapter/EntityMapper.php:84
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` = 120 LIMIT 1
936 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
929 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 121 AND id_shop=1 LIMIT 1
924 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
921 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
914 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
905 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
901 ms 1 /src/Adapter/EntityMapper.php:84
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`
892 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
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
890 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 36 AND `id_shop` = 1
878 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
876 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
837 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
836 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
819 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
804 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
796 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
789 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_advancedformula" LIMIT 1
789 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
784 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
783 ms 1 /src/Adapter/EntityMapper.php:76
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` = 123 LIMIT 1
779 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
776 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 48) LIMIT 1
760 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 30 AND `id_shop` = 1
753 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
748 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 123
741 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 371 AND `id_shop` = 1
735 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` = 12) LIMIT 1
724 ms 1 /src/Adapter/EntityMapper.php:76
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
723 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
720 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
720 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`
715 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` = 19) LIMIT 1
707 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
693 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
672 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` = 34) LIMIT 1
670 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
668 ms 1 /classes/Currency.php:893
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 33 AND `id_shop` = 1
664 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 121) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
662 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
656 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
652 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
649 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
649 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
643 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
640 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
638 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
638 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` = 24) LIMIT 1
637 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
627 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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
626 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
599 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
590 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
585 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
583 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
573 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
571 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
570 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
567 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
566 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
561 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
560 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
553 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
552 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
539 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
538 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
538 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
537 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
536 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
531 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
530 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
527 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
527 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
521 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_designer" LIMIT 1
520 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
513 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
513 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
509 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
502 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
499 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
497 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
495 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
492 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
490 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` = 29) LIMIT 1
471 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
469 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
466 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
452 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
452 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
452 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'home_default' LIMIT 1
448 ms 1 /classes/Image.php:510
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
443 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
443 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
436 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
432 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
429 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
417 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 24 AND `id_shop` = 1
415 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
410 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
406 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
402 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
388 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
387 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) LIMIT 1
386 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 29 AND `id_shop` = 1
383 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` = 14) LIMIT 1
382 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_currencyselector" LIMIT 1
374 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_shop
FROM `cdf_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
366 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
363 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
362 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
349 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
349 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
341 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 35 AND `id_shop` = 1
340 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1
335 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
331 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
329 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
328 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
319 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
316 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
315 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
315 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
296 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 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
4 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>
4 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=&quo