Catégorie : Bâtiments et hangars

Load Time 2617 ms
Querying Time 797 ms
Queries 361
Memory Peak Usage 61.6 Mb
Included Files 1239 files - 14.70 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 45 ms 45 ms 18.50 Mb 18.8 Mb
__construct 0 ms 46 ms - Mb 18.8 Mb
init 300 ms 345 ms 9.16 Mb 28.6 Mb
checkAccess 0 ms 345 ms - Mb 28.6 Mb
setMedia 44 ms 390 ms 2.83 Mb 30.6 Mb
postProcess 0 ms 390 ms - Mb 30.6 Mb
initHeader 0 ms 390 ms - Mb 30.6 Mb
initContent 1244 ms 1634 ms 23.28 Mb 53.8 Mb
initFooter 0 ms 1634 ms - Mb 53.8 Mb
display 983 ms 2617 ms 7.31 Mb 61.6 Mb
Hook Time Memory Usage
DisplayHeader 381 ms 3.38 Mb
displayMainMenu 109 ms 2.03 Mb
DisplayGform 106 ms 0.64 Mb
DisplayFooter 71 ms 0.67 Mb
displayProductListReviews 53 ms 0.56 Mb
Header 44 ms 0.30 Mb
displayNav1 39 ms 0.19 Mb
displayLeftColumn 23 ms 0.11 Mb
DisplayAfterBodyOpeningTag 15 ms 0.02 Mb
ModuleRoutes 15 ms 0.74 Mb
displayNav2 14 ms 0.21 Mb
ActionFrontControllerSetMedia 13 ms 0.66 Mb
displayAboveMobileMenu 12 ms 0.08 Mb
displaySearch 7 ms 0.05 Mb
DisplayGDPRConsent 6 ms 0.03 Mb
ActionOutputHTMLBefore 6 ms - Mb
DisplayLeftColumn 5 ms 0.01 Mb
ProductSearchProvider 4 ms 0.18 Mb
displayAfterBreadcrumb 3 ms 0.03 Mb
displayFooter 3 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
ActionProductSearchAfter 0 ms - Mb
ActionDispatcher 0 ms - Mb
Top 0 ms - Mb
28 hook(s) 930 ms 9.93 Mb
Module Time Memory Usage
configurator 96 ms 4.91 Mb
gformbuilderpro 115 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 49 ms 1.68 Mb
ps_facebook 38 ms 1.32 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 365 ms 3.67 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 60 ms 6.76 Mb
iqitcontactpage 1 ms 0.06 Mb
iqitcountdown 1 ms 0.04 Mb
iqitlinksmanager 51 ms 0.44 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.20 Mb
ets_recaptcha_free 1 ms 0.23 Mb
ps_searchbar 8 ms 0.08 Mb
iqitelementor 26 ms 1.14 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 114 ms 2.77 Mb
iqitreviews 56 ms 0.71 Mb
iqitsizecharts 2 ms 0.18 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 19 ms 0.20 Mb
ps_facetedsearch 15 ms 0.63 Mb
psgdpr 8 ms 0.22 Mb
ps_languageselector 3 ms 0.13 Mb
ps_currencyselector 2 ms 0.08 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 21 ms 0.14 Mb
37 module(s) 1100 ms 29.88 Mb

Stopwatch SQL - 361 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
39194 ms 35022 /modules/gformbuilderpro/gformbuilderpro.php:380
SELECT SQL_NO_CACHE p.id_product, p.price, psi.price_min, psi.price_max FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales FROM cdf_product p LEFT JOIN cdf_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN cdf_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN cdf_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN cdf_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN cdf_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN cdf_category_product cp ON (p.id_product = cp.id_product) INNER JOIN cdf_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN cdf_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND p.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=25 AND c.nright<=30 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
25434 ms 402 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
20826 ms 1 /classes/Hook.php:239
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 (154) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
15550 ms 1 Yes Yes /classes/Product.php:4479
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
15470 ms 1 /classes/Cart.php:4218
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `cdf_module` m
INNER JOIN cdf_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `cdf_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `cdf_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `cdf_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `cdf_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
15437 ms 2100 Yes Yes /classes/Hook.php:1183
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
13783 ms 0 /classes/Hook.php:1243
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
11976 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`)
11271 ms 1308 /classes/Configuration.php:160
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
10357 ms 28 Yes Yes /classes/Category.php:793
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` = 14) AND (b.`id_shop` = 1) LIMIT 1
10195 ms 1 /src/Adapter/EntityMapper.php:76
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 >= 25 AND nright <= 30
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
10011 ms 28 Yes /modules/ps_categorytree/ps_categorytree.php:166
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
9767 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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
9700 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE a.*, b.`name`, b.`description`
FROM `cdf_lgcookieslaw_purpose` a
LEFT JOIN `cdf_lgcookieslaw_purpose_lang` `b` ON (b.`id_lgcookieslaw_purpose` = a.`id_lgcookieslaw_purpose` AND b.`id_lang` = 1)
WHERE (a.`id_shop` = 1) AND (a.`active` = 1)
9518 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
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
9494 ms 1 Yes /classes/shop/Shop.php:1350
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
9262 ms 502 /classes/Hook.php:504
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
9181 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
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 = 154
ORDER BY f.position ASC
9181 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM cdf_layered_category
WHERE controller = 'category'
AND id_category = 14
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
9056 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
7951 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215
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)
7947 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
7011 ms 67 /modules/configurator/configurator.php:1373
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
6730 ms 1 Yes /classes/Currency.php:709
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
6573 ms 65 Yes /classes/Dispatcher.php:643
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
6566 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
6538 ms 854 /classes/Hook.php:1283
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 = 151
LIMIT 1
6450 ms 1 /classes/ProductAssembler.php:95
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
6396 ms 1 /classes/Currency.php:1126
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`
6223 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
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)
6141 ms 1 /classes/Language.php:1049
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
5944 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
5603 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
5394 ms 1 /classes/module/Module.php:2328
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
5218 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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)
5050 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
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`
5004 ms 1 Yes /classes/CMS.php:151
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 = 158
LIMIT 1
4974 ms 1 /classes/ProductAssembler.php:95
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
4820 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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
4759 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
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
4685 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
4656 ms 1 /classes/AddressFormat.php:672
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)
4509 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177
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` = 154 LIMIT 1
4386 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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` = 151 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` = 151 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
4224 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
4128 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
3944 ms 8 /classes/ImageType.php:147
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
3900 ms 1 /classes/ObjectModel.php:1510
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` = 151
AND image_shop.`cover` = 1 LIMIT 1
3840 ms 3 /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 = 155
LIMIT 1
3780 ms 1 /classes/ProductAssembler.php:95
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` = 154
ORDER BY `position`
3596 ms 3 Yes /classes/Product.php:3508
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 (158) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3469 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` = 152 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` = 152 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3427 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
3283 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
3269 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
3263 ms 1 /classes/module/Module.php:2237
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 = 157
LIMIT 1
3263 ms 1 /classes/ProductAssembler.php:95
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` = 155
ORDER BY `position`
3206 ms 3 Yes /classes/Product.php:3508
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 = 152
ORDER BY f.position ASC
3071 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 = 155
ORDER BY f.position ASC
2962 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` = 154 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` = 154 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2956 ms 0 /classes/Cart.php:1429
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
2913 ms 1 /classes/Language.php:1198
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>=25 AND c.nright<=30 GROUP BY p.id_product) p
2861 ms 402 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
2817 ms 1 /src/Adapter/EntityMapper.php:84
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` = 154
AND image_shop.`cover` = 1 LIMIT 1
2813 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
2777 ms 88 /classes/Hook.php:301
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` = 157
AND image_shop.`cover` = 1 LIMIT 1
2773 ms 3 /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 = 154
LIMIT 1
2743 ms 1 /classes/ProductAssembler.php:95
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 (159) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2735 ms 1 Yes Yes /classes/Product.php:4479
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
2717 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 (156) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2705 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
2700 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 151
ORDER BY f.position ASC
2696 ms 1 Yes /classes/Product.php:5897
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
2649 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 = 153
ORDER BY f.position ASC
2616 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
2502 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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` = 155) AND (b.`id_shop` = 1) LIMIT 1
2471 ms 1 /src/Adapter/EntityMapper.php:76
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` = 155 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` = 155 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2461 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
2408 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
2404 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 (157) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2362 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 (151) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2318 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 (152) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2307 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
2304 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) LIMIT 1
2279 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` = 154)
2247 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 152 AND id_shop=1 LIMIT 1
2223 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` = 155
AND image_shop.`cover` = 1 LIMIT 1
2222 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (155) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2219 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 (153) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2204 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
2159 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 154 AND `id_group` = 1 LIMIT 1
2142 ms 0 /classes/GroupReduction.php:156
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 = 152
LIMIT 1
2113 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
2111 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE ctg.`id_group`
FROM cdf_category_group ctg
WHERE ctg.`id_category` = 14 AND ctg.`id_group` = 1 LIMIT 1
2109 ms 1 /classes/Category.php:1730
SELECT SQL_NO_CACHE data FROM cdf_layered_filter_block WHERE hash="6011537b45ecd976be0b349374c1099b" LIMIT 1
2094 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:182
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 545) LIMIT 1
2060 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
2050 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category` a0
LEFT JOIN `cdf_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 25) AND (a0.`nright` > 30) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
2015 ms 28 Yes /classes/PrestaShopCollection.php:381
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` = 158 LIMIT 1
2012 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 154
AND `required` = 1 AND `is_deleted` = 0
1951 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 151
ORDER BY `position`
1929 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
1911 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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` = 157)
1909 ms 1 /override/classes/Product.php:442
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 = 156
LIMIT 1
1899 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` = 156 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` = 156 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1886 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
1882 ms 1 /classes/Product.php:5614
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` = 151) AND (b.`id_shop` = 1) LIMIT 1
1863 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_cms` a
LEFT JOIN `cdf_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `cdf_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
1861 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
1856 ms 1 /classes/Hook.php:239
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 = 156
ORDER BY f.position ASC
1843 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
1843 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 151 AND `id_group` = 1 LIMIT 1
1833 ms 0 /classes/GroupReduction.php:156
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` = 153
ORDER BY `position`
1833 ms 3 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` = 159) AND (b.`id_shop` = 1) LIMIT 1
1830 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 153
AND `required` = 1 AND `is_deleted` = 0
1827 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` = 158) AND (b.`id_shop` = 1) LIMIT 1
1782 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
1754 ms 1 /classes/Product.php:5614
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 = 153
LIMIT 1
1745 ms 1 /classes/ProductAssembler.php:95
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
1738 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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
1707 ms 1 Yes /classes/Language.php:974
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
1663 ms 105 /classes/module/Module.php:340
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` = 157) AND (b.`id_shop` = 1) LIMIT 1
1659 ms 1 /src/Adapter/EntityMapper.php:76
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 = 159
ORDER BY f.position ASC
1652 ms 1 Yes /classes/Product.php:5897
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 = 159
LIMIT 1
1629 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1609 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
1598 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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` = 153 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` = 153 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1588 ms 0 /classes/Cart.php:1429
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` = 156 LIMIT 1
1556 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
1551 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
1531 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
1527 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 152
AND `required` = 1 AND `is_deleted` = 0
1507 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 157 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` = 157 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1472 ms 0 /classes/Cart.php:1429
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` = 151 LIMIT 1
1453 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `cdf_module` m
LEFT JOIN `cdf_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1436 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1432 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
1430 ms 854 /classes/Hook.php:1243
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
1429 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
1414 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` = 159 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` = 159 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1414 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 157 AND `id_group` = 1 LIMIT 1
1393 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 158
AND image_shop.`cover` = 1 LIMIT 1
1376 ms 3 /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` = 155)
1362 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 158)
1359 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 151
AND `required` = 1 AND `is_deleted` = 0
1356 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
1355 ms 1 /classes/module/Module.php:2328
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` = 153 LIMIT 1
1351 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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` = 158
ORDER BY `position`
1327 ms 3 Yes /classes/Product.php:3508
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` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1317 ms 2 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 155
1305 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1289 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
1285 ms 1 /classes/Language.php:853
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` = 152
ORDER BY `position`
1278 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 151) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1268 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` = 155 LIMIT 1
1245 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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` = 156
ORDER BY `position`
1241 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 3
1230 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` = 158 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` = 158 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1220 ms 0 /classes/Cart.php:1429
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` = 153) AND (b.`id_shop` = 1) LIMIT 1
1215 ms 1 /src/Adapter/EntityMapper.php:76
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 = 158
ORDER BY f.position ASC
1212 ms 1 Yes /classes/Product.php:5897
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` = 152 LIMIT 1
1208 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 = 157
ORDER BY f.position ASC
1201 ms 1 Yes /classes/Product.php:5897
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` = 157 LIMIT 1
1197 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
1179 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 152) AND (b.`id_shop` = 1) LIMIT 1
1169 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ybc_blog" LIMIT 1
1168 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
1167 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_categorytree" LIMIT 1
1162 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_upack" LIMIT 1
1151 ms 0 /classes/module/Module.php:2840
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` = 159
ORDER BY `position`
1149 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
1136 ms 1 /classes/shop/Shop.php:1171
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` = 157
ORDER BY `position`
1126 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 155 AND `id_group` = 1 LIMIT 1
1105 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
1105 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 151
1095 ms 1 /classes/Product.php:2875
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
1092 ms 1 /src/Adapter/EntityMapper.php:76
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` = 154) AND (b.`id_shop` = 1) LIMIT 1
1089 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`
1089 ms 1 Yes /classes/CMS.php:151
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` = 151)
1085 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 155) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1084 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 154 AND id_shop=1 LIMIT 1
1047 ms 1 /classes/Product.php:6751
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
1044 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
1044 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_hook` a
WHERE (a.`id_hook` = 583) LIMIT 1
1042 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
1035 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
1031 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
1000 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
999 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 154
995 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 152
993 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
980 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 104 AND `id_shop` = 1 LIMIT 1
970 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` = 19) LIMIT 1
954 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
954 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ets_bestselling" LIMIT 1
953 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` = 159
AND image_shop.`cover` = 1 LIMIT 1
941 ms 3 /classes/Product.php:3533
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` = 159 LIMIT 1
933 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
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
926 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
926 ms 1 /classes/order/Order.php:1203
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` = 152
AND image_shop.`cover` = 1 LIMIT 1
924 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
918 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
904 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
900 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
894 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
891 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 159
AND `required` = 1 AND `is_deleted` = 0
873 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
861 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_languageselector" LIMIT 1
855 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 152 AND `id_group` = 1 LIMIT 1
845 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 156
841 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 151 AND id_shop=1 LIMIT 1
819 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
815 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
810 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
809 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 153) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
805 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 156
AND `required` = 1 AND `is_deleted` = 0
797 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 155 AND id_shop=1 LIMIT 1
796 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 152)
791 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
783 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 156) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
769 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 152) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
768 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
767 ms 1 /classes/module/Module.php:2328
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
762 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
747 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_currencyselector" LIMIT 1
746 ms 1 /classes/module/Module.php:2840
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
746 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `cdf_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
741 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "homeslider" LIMIT 1
740 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE id_shop
FROM `cdf_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
739 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
739 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 155
AND `required` = 1 AND `is_deleted` = 0
735 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
732 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
730 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 157) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
730 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
728 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "mpcleanurls" LIMIT 1
721 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1
721 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` = 159)
721 ms 1 /override/classes/Product.php:442
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` = 156) AND (b.`id_shop` = 1) LIMIT 1
718 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 153
717 ms 1 /classes/Product.php:2875
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` = 153
AND image_shop.`cover` = 1 LIMIT 1
710 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE name, alias FROM `cdf_hook_alias`
709 ms 88 /classes/Hook.php:353
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
706 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_imageslider" LIMIT 1
704 ms 1 /classes/module/Module.php:2840
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`
700 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
694 ms 1 /classes/order/Order.php:1203
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`
685 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 158
678 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 5) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
677 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
676 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
675 ms 1 /classes/Image.php:510
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` = 153)
674 ms 1 /override/classes/Product.php:442
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
673 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "psseobooster" LIMIT 1
670 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 158
AND `required` = 1 AND `is_deleted` = 0
662 ms 3 /classes/Product.php:6494
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 157
659 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` = 17) LIMIT 1
638 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
636 ms 1 /classes/Product.php:5614
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` = 156
AND image_shop.`cover` = 1 LIMIT 1
635 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
635 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
629 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 154) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
628 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1
628 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 158) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
620 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_designer" LIMIT 1
617 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "blockbanner" LIMIT 1
616 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 159) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
615 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 3) LIMIT 1
614 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 157 AND id_shop=1 LIMIT 1
611 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE c.id_currency
FROM `cdf_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
604 ms 1 /classes/Currency.php:893
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
600 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
596 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 158 AND `id_group` = 1 LIMIT 1
595 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_banner" LIMIT 1
586 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 157
AND `required` = 1 AND `is_deleted` = 0
585 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
584 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
582 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 159
581 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
578 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 5) LIMIT 1
576 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_shop
FROM `cdf_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
574 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 84 AND `id_shop` = 1 LIMIT 1
567 ms 1 /classes/module/Module.php:2328
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
566 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 153 AND `id_group` = 1 LIMIT 1
565 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_group`
WHERE `id_group` = 1 LIMIT 1
565 ms 1 /classes/Group.php:154
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 5 AND `id_shop` = 1
563 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
558 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
556 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) LIMIT 1
551 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` = 156)
539 ms 1 /override/classes/Product.php:442
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
523 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
515 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` = 11) LIMIT 1
515 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
510 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE name FROM cdf_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
503 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 156 AND `id_group` = 1 LIMIT 1
497 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
497 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 158 AND id_shop=1 LIMIT 1
497 ms 1 /classes/Product.php:6751
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` = 15) AND (b.`id_shop` = 1) LIMIT 1
489 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block` a
WHERE (a.`id_iqit_link_block` = 4) LIMIT 1
486 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) LIMIT 1
481 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
475 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
475 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
473 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
461 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
456 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193