Catégorie : Charpente 1 pan

Load Time 2775 ms
Querying Time 850 ms
Queries 377
Memory Peak Usage 61.7 Mb
Included Files 1240 files - 14.68 Mb
PrestaShop Cache - Mb
Global vars 1.03 Mb
PrestaShop Version 1.7.8.5
PHP Version 7.4.33
MySQL Version 8.0.39-30
Memory Limit 512M
Max Execution Time 165s
Smarty Cache disabled
Smarty Compilation force compile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 49 ms 49 ms 18.50 Mb 18.8 Mb
__construct 0 ms 49 ms - Mb 18.8 Mb
init 269 ms 318 ms 9.14 Mb 28.6 Mb
checkAccess 0 ms 318 ms - Mb 28.6 Mb
setMedia 41 ms 360 ms 2.83 Mb 30.6 Mb
postProcess 0 ms 360 ms - Mb 30.6 Mb
initHeader 0 ms 360 ms - Mb 30.6 Mb
initContent 1718 ms 2078 ms 23.46 Mb 54.0 Mb
initFooter 0 ms 2078 ms - Mb 54.0 Mb
display 697 ms 2775 ms 7.31 Mb 61.7 Mb
Hook Time Memory Usage
DisplayHeader 137 ms 3.39 Mb
displayMainMenu 123 ms 2.03 Mb
DisplayGform 65 ms 0.64 Mb
Header 57 ms 0.30 Mb
displayProductListReviews 53 ms 0.56 Mb
DisplayFooter 34 ms 0.67 Mb
displayNav1 31 ms 0.19 Mb
displayLeftColumn 21 ms 0.10 Mb
ModuleRoutes 13 ms 0.74 Mb
ActionFrontControllerSetMedia 13 ms 0.66 Mb
displayNav2 12 ms 0.21 Mb
displayAboveMobileMenu 10 ms 0.09 Mb
displaySearch 7 ms 0.05 Mb
ActionOutputHTMLBefore 6 ms - Mb
DisplayAfterBodyOpeningTag 5 ms 0.02 Mb
DisplayLeftColumn 5 ms 0.01 Mb
DisplayGDPRConsent 4 ms 0.03 Mb
ProductSearchProvider 4 ms 0.18 Mb
displayAfterBreadcrumb 3 ms 0.03 Mb
displayFooter 1 ms 0.03 Mb
DisplayTop 1 ms 0.01 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) 607 ms 9.93 Mb
Module Time Memory Usage
configurator 70 ms 4.91 Mb
gformbuilderpro 73 ms 1.40 Mb
ps_mbo 6 ms 0.26 Mb
iqitthemeeditor 5 ms 0.53 Mb
ps_emailsubscription 4 ms 0.38 Mb
ps_checkout 43 ms 1.68 Mb
ps_facebook 32 ms 1.32 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 105 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 59 ms 6.76 Mb
iqitcontactpage 1 ms 0.06 Mb
iqitcountdown 2 ms 0.04 Mb
iqitlinksmanager 43 ms 0.44 Mb
iqitsociallogin 1 ms 0.07 Mb
productcomments 12 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 7 ms 0.08 Mb
iqitelementor 22 ms 1.15 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 128 ms 2.77 Mb
iqitreviews 56 ms 0.71 Mb
iqitsizecharts 2 ms 0.18 Mb
iqitextendedproduct 4 ms 0.13 Mb
ets_superspeed 36 ms 0.21 Mb
ps_facetedsearch 15 ms 0.63 Mb
psgdpr 6 ms 0.22 Mb
ps_languageselector 2 ms 0.13 Mb
ps_currencyselector 1 ms 0.07 Mb
pagesnotfound 2 ms 0.21 Mb
sekeywords 1 ms 0.21 Mb
iqitsearch 1 ms - Mb
ps_customersignin 0 ms 0.02 Mb
iqitproductsnav 4 ms 0.23 Mb
ps_categorytree 18 ms 0.14 Mb
37 module(s) 786 ms 29.88 Mb

Stopwatch SQL - 377 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
35219 ms 35022 /modules/gformbuilderpro/gformbuilderpro.php:380
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`)
25386 ms 1308 /classes/Configuration.php:160
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>=14 AND c.nright<=15 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
24378 ms 402 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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` = 33) AND (b.`id_shop` = 1) LIMIT 1
19267 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 1 FROM cdf_cart_product cp INNER JOIN cdf_product p
ON (p.id_product = cp.id_product) INNER JOIN cdf_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
19111 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 (101) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
16646 ms 1 Yes Yes /classes/Product.php:4479
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`
16183 ms 2100 Yes Yes /classes/Hook.php:1183
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` = 63
AND image_shop.`cover` = 1 LIMIT 1
11500 ms 4 /classes/Product.php:3533
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 = 64
LIMIT 1
10621 ms 1 /classes/ProductAssembler.php:95
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
9694 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM cdf_cms c
LEFT JOIN cdf_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1 AND cl.id_shop = 1)
INNER JOIN cdf_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (24) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
9453 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM cdf_shop_url su
LEFT JOIN cdf_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'charpentedefrance.eetek.tech' OR su.domain_ssl = 'charpentedefrance.eetek.tech')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
9229 ms 1 Yes /classes/shop/Shop.php:1350
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
9197 ms 0 /classes/Hook.php:1243
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 = 101
ORDER BY f.position ASC
8889 ms 1 Yes /classes/Product.php:5897
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)
8685 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
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)
8599 ms 1 /classes/Language.php:1049
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
8566 ms 65 Yes /classes/Dispatcher.php:643
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)
8463 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
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
8174 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 33
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
7266 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
7113 ms 1 Yes /classes/Currency.php:709
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
6961 ms 28 Yes Yes /classes/Category.php:793
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 101 LIMIT 1
6784 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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
6751 ms 502 /classes/Hook.php:504
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
6496 ms 1 /classes/module/Module.php:2237
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)
6385 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
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
6240 ms 1 /classes/Currency.php:1126
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
6134 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
5912 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
5899 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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` = 101)
5802 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
5547 ms 67 /modules/configurator/configurator.php:1373
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=61 AND c.active= 1 LIMIT 1
5514 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
5450 ms 1 /classes/AddressFormat.php:672
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 = 63
LIMIT 1
5280 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 = 61
LIMIT 1
5274 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
5259 ms 854 /classes/Hook.php:1283
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
5227 ms 1 /classes/Product.php:5614
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
5220 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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`
5202 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
5157 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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
5048 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
4861 ms 1 /classes/Hook.php:239
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 = 62
LIMIT 1
4827 ms 1 /classes/ProductAssembler.php:95
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)
4692 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177
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
4639 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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
4545 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 30 AND `id_shop` = 1
4441 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 101
AND `required` = 1 AND `is_deleted` = 0
4343 ms 1 /classes/Product.php:6494
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
4310 ms 1 /src/Adapter/EntityMapper.php:76
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
4247 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` = 101
AND image_shop.`cover` = 1 LIMIT 1
4214 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 (64) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3985 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
3978 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
3853 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
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` = 62 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` = 62 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3713 ms 0 /classes/Cart.php:1429
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 = 61
ORDER BY f.position ASC
3707 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
3699 ms 88 /classes/Hook.php:301
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` = 65) AND (b.`id_shop` = 1) LIMIT 1
3660 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
3586 ms 8 Yes /classes/ImageType.php:109
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 = 65
LIMIT 1
3551 ms 1 /classes/ProductAssembler.php:95
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>=14 AND c.nright<=15 GROUP BY p.id_product) p
3462 ms 402 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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 = 66
LIMIT 1
3449 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 = 101
LIMIT 1
3382 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` = 65 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` = 65 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3366 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` = 61 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` = 61 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3283 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
3202 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 101 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` = 101 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3129 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
3039 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="bd2bc05f6f5c0961a6c0d193aafce829" LIMIT 1
2981 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
2942 ms 8 /classes/ImageType.php:147
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` = 101) AND (b.`id_shop` = 1) LIMIT 1
2918 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
2765 ms 1 /classes/order/Order.php:1203
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 = 62
ORDER BY f.position ASC
2723 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=66 AND c.active= 1 LIMIT 1
2616 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
2603 ms 1 /src/Adapter/EntityMapper.php:84
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` = 66 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` = 66 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2577 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (102) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2561 ms 1 Yes Yes /classes/Product.php:4479
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` = 101
ORDER BY `position`
2503 ms 4 Yes /classes/Product.php:3508
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
2499 ms 105 /classes/module/Module.php:340
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
2429 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 33 AND ctg.`id_group` = 1 LIMIT 1
2425 ms 1 /classes/Category.php:1730
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
2382 ms 105 /classes/module/Module.php:340
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 = 65
ORDER BY f.position ASC
2321 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
2267 ms 1 /src/Adapter/EntityMapper.php:84
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` = 61
ORDER BY `position`
2252 ms 4 Yes /classes/Product.php:3508
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` = 61) AND (b.`id_shop` = 1) LIMIT 1
2226 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
2219 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (62) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2202 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` = 63) AND (b.`id_shop` = 1) LIMIT 1
2181 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
2171 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (103) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2162 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 101 AND `id_group` = 1 LIMIT 1
2126 ms 0 /classes/GroupReduction.php:156
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 = 102
ORDER BY f.position ASC
2101 ms 1 Yes /classes/Product.php:5897
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 = 66
ORDER BY f.position ASC
2100 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
2085 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
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` = 65
AND image_shop.`cover` = 1 LIMIT 1
2080 ms 4 /classes/Product.php:3533
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` = 62) AND (b.`id_shop` = 1) LIMIT 1
2057 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
2052 ms 1 /classes/module/Module.php:2840
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` = 61
AND image_shop.`cover` = 1 LIMIT 1
2049 ms 4 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
2036 ms 1 /classes/module/Module.php:2840
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 (61) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2032 ms 1 Yes Yes /classes/Product.php:4479
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 (63) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2028 ms 1 Yes Yes /classes/Product.php:4479
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
2018 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
1971 ms 105 /classes/module/Module.php:340
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 = 103
LIMIT 1
1944 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` = 102 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` = 102 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1932 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
1921 ms 854 /classes/Hook.php:1243
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
1905 ms 0 /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` = 66) AND (b.`id_shop` = 1) LIMIT 1
1863 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
1850 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 14) AND (a0.`nright` > 15) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
1820 ms 28 Yes /classes/PrestaShopCollection.php:381
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` = 66
AND image_shop.`cover` = 1 LIMIT 1
1818 ms 4 /classes/Product.php:3533
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` = 62
ORDER BY `position`
1814 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
1765 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
1752 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 103 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` = 103 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1750 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` = 102
ORDER BY `position`
1747 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 65
ORDER BY `position`
1745 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
1721 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
1721 ms 1 /classes/shop/Shop.php:1171
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 = 102
LIMIT 1
1717 ms 1 /classes/ProductAssembler.php:95
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 = 103
ORDER BY f.position ASC
1704 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1700 ms 1 /classes/order/Order.php:1203
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 = 63
ORDER BY f.position ASC
1694 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 65) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1669 ms 1 /classes/stock/StockAvailable.php:453
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 (65) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1664 ms 1 Yes Yes /classes/Product.php:4479
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` = 64 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` = 64 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1649 ms 0 /classes/Cart.php:1429
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 >= 14 AND nright <= 15
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
1631 ms 6 Yes /modules/ps_categorytree/ps_categorytree.php:166
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
1621 ms 1 /classes/Hook.php:239
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` = 62
AND image_shop.`cover` = 1 LIMIT 1
1621 ms 4 /classes/Product.php:3533
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` = 63 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` = 63 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1611 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 63 AND id_shop=1 LIMIT 1
1578 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
1578 ms 1 /classes/Product.php:5614
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` = 66
ORDER BY `position`
1574 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
1573 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=63 AND c.active= 1 LIMIT 1
1571 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
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
1557 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` = 64
AND image_shop.`cover` = 1 LIMIT 1
1551 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` = 66)
1542 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1540 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 33 AND `id_shop` = 1
1523 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1519 ms 1 /classes/order/Order.php:1203
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` = 65)
1516 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
1514 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 65 AND id_shop=1 LIMIT 1
1505 ms 1 /classes/Product.php:6751
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 (66) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1499 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 62) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1468 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
1468 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=62 AND c.active= 1 LIMIT 1
1453 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
1452 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
1443 ms 1 /src/Adapter/EntityMapper.php:84
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` = 62)
1442 ms 1 /override/classes/Product.php:442
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
1438 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
1431 ms 0 /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` = 64) AND (b.`id_shop` = 1) LIMIT 1
1424 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 66 AND id_shop=1 LIMIT 1
1423 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
1422 ms 1 /classes/module/Module.php:2328
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` = 33
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1409 ms 1 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 61) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1394 ms 1 /classes/stock/StockAvailable.php:453
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` = 65 LIMIT 1
1381 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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 = 64
ORDER BY f.position ASC
1373 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=65 AND c.active= 1 LIMIT 1
1343 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 66) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1341 ms 1 /classes/stock/StockAvailable.php:453
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` = 61)
1328 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 61
AND `required` = 1 AND `is_deleted` = 0
1328 ms 1 /classes/Product.php:6494
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
1315 ms 1 /classes/shop/Shop.php:205
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` = 102 LIMIT 1
1291 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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` = 63)
1288 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 102
1261 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` = 64 LIMIT 1
1257 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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` = 61 LIMIT 1
1256 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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
1242 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
1236 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
1217 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 64) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1200 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1185 ms 1 /classes/Country.php:401
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` = 64)
1171 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` = 63 LIMIT 1
1162 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 32) LIMIT 1
1160 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
1160 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` = 102) AND (b.`id_shop` = 1) LIMIT 1
1159 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
1159 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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
1158 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` = 103 LIMIT 1
1153 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 65 AND `id_group` = 1 LIMIT 1
1153 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
1152 ms 1 /classes/Product.php:5614
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` = 62 LIMIT 1
1140 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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
1133 ms 1 /src/Adapter/EntityMapper.php:76
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` = 63
ORDER BY `position`
1130 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
1126 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
1118 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 30) LIMIT 1
1118 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 63) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1116 ms 1 /classes/stock/StockAvailable.php:453
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` = 103
ORDER BY `position`
1107 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 75) LIMIT 1
1101 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
1097 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1086 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 62
AND `required` = 1 AND `is_deleted` = 0
1078 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 62 AND id_shop=1 LIMIT 1
1077 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 65
1063 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 102
AND `required` = 1 AND `is_deleted` = 0
1056 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 31 AND `id_shop` = 1
1056 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 75 AND `id_shop` = 1
1049 ms 1 /src/Adapter/EntityMapper.php:84
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
1049 ms 1 /classes/Language.php:1198
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
1048 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 63 AND `id_group` = 1 LIMIT 1
1031 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 74 AND `id_shop` = 1
1029 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
1028 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
1024 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 64
ORDER BY `position`
1019 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 62
1011 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 74) LIMIT 1
1006 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
1003 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` = 11) LIMIT 1
995 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM cdf_cms c
LEFT JOIN cdf_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1 AND cl.id_shop = 1)
INNER JOIN cdf_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (18) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
992 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 62 AND `id_group` = 1 LIMIT 1
978 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
973 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
968 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 61 AND `id_group` = 1 LIMIT 1
963 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 61
949 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 31) LIMIT 1
948 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` = 66 LIMIT 1
942 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 66
AND `required` = 1 AND `is_deleted` = 0
936 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 101 AND id_shop=1 LIMIT 1
930 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
930 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 65
AND `required` = 1 AND `is_deleted` = 0
921 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
918 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
909 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 102) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
890 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 61 AND id_shop=1 LIMIT 1
871 ms 1 /classes/Product.php:6751
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` = 102
AND image_shop.`cover` = 1 LIMIT 1
870 ms 4 /classes/Product.php:3533
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
861 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 66
855 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1
854 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 66 AND `id_group` = 1 LIMIT 1
844 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 103) AND (b.`id_shop` = 1) LIMIT 1
843 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
837 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 32 AND `id_shop` = 1
829 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
827 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
825 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` = 5) LIMIT 1
823 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 102 AND `id_group` = 1 LIMIT 1
817 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
809 ms 1 /classes/order/Order.php:1203
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
803 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
801 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
798 ms 1 /classes/module/Module.php:2840
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` = 103
AND image_shop.`cover` = 1 LIMIT 1
790 ms 4 /classes/Product.php:3533
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
786 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 64 AND id_shop=1 LIMIT 1
783 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE * FROM `cdf_configurator` c
WHERE c.id_product=64 AND c.active= 1 LIMIT 1
777 ms 1 /modules/configurator/classes/ConfiguratorModel.php:366
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
776 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
767 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 33) LIMIT 1
765 ms 1 /src/Adapter/EntityMapper.php:76
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` = 102)
764 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
755 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
748 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` = 34) LIMIT 1
740 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
739 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
734 ms 0 /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
732 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
727 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) LIMIT 1
726 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 103) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
725 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
724 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 103
722 ms 1 /classes/Product.php:2875
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
721 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` = 12) LIMIT 1
721 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_advancedformula" LIMIT 1
709 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
707 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
705 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
701 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
691 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
690 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 63
AND `required` = 1 AND `is_deleted` = 0
690 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 63
690 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
687 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
685 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 64
674 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
674 ms 1 /classes/shop/ShopUrl.php:182
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
673 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
672 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
666 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 101) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
665 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
663 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
658 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
657 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 64
AND `required` = 1 AND `is_deleted` = 0
656 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 101
655 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
655 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
653 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
652 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
649 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1
645 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
642 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 35 AND `id_shop` = 1
642 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 41 AND `id_shop` = 1
620 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
620 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 33 AND `id_shop` = 1
618 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
616 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 103
AND `required` = 1 AND `is_deleted` = 0
613 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
611 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT 1
610 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
605 ms 1 /src/Adapter/EntityMapper.php:84
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` = 103)
605 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
604 ms 0 /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
596 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
595 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` = 26) LIMIT 1
595 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
591 ms 1 /src/Adapter/EntityMapper.php:84