Terrasses sur pilotis

Terrasses

Créez l’espace extérieur idéal avec nos terrasses sur pilotis en bois.

Choisissez parmi nos modèles standards, sélectionnez le format qui vous convient, et personnalisez votre terrasse avec les options disponibles.

Pour des dimensions spécifiques ou un design unique, utilisez notre formulaire pour une terrasse sur mesure, parfaitement adaptée à votre espace.

Terrasses

Load Time 2178 ms
Querying Time 782 ms
Queries 293
Memory Peak Usage 68.2 Mb
Included Files 1289 files - 14.85 Mb
PrestaShop Cache - Mb
Global vars 1.05 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 47 ms 47 ms 18.33 Mb 18.7 Mb
__construct 0 ms 47 ms - Mb 18.7 Mb
init 260 ms 307 ms 9.03 Mb 28.3 Mb
checkAccess 0 ms 307 ms - Mb 28.3 Mb
setMedia 41 ms 349 ms 2.83 Mb 30.4 Mb
postProcess 0 ms 349 ms - Mb 30.4 Mb
initHeader 0 ms 349 ms - Mb 30.4 Mb
initContent 376 ms 725 ms 17.85 Mb 48.3 Mb
initFooter 0 ms 725 ms - Mb 48.3 Mb
display 1453 ms 2178 ms 19.76 Mb 68.2 Mb
Hook Time Memory Usage
displayCMSDisputeInformation 925 ms 13.11 Mb
DisplayHeader 157 ms 3.47 Mb
displayMainMenu 130 ms 2.83 Mb
DisplayGform 83 ms 0.64 Mb
displayProductListReviews 62 ms 0.35 Mb
DisplayFooter 51 ms 0.73 Mb
Header 38 ms 0.36 Mb
displayNav1 33 ms 0.35 Mb
displayFooter 17 ms 0.02 Mb
ModuleRoutes 16 ms 0.74 Mb
ActionFrontControllerSetMedia 13 ms 0.72 Mb
displayAboveMobileMenu 11 ms 0.11 Mb
displayNav2 11 ms 0.22 Mb
displaySearch 7 ms 0.05 Mb
DisplayAfterBodyOpeningTag 6 ms 0.02 Mb
ActionOutputHTMLBefore 5 ms - Mb
DisplayGDPRConsent 4 ms 0.04 Mb
displayAfterBreadcrumb 4 ms 0.04 Mb
DisplayTop 1 ms 0.01 Mb
ActionDispatcherBefore 0 ms - Mb
DisplayBeforeBodyClosingTag 0 ms - Mb
DisplayProductPriceBlock 0 ms - Mb
ActionDispatcher 0 ms - Mb
Top 0 ms - Mb
24 hook(s) 1571 ms 23.81 Mb
Module Time Memory Usage
configurator 64 ms 4.88 Mb
gformbuilderpro 91 ms 1.39 Mb
ps_mbo 5 ms 0.26 Mb
iqitthemeeditor 10 ms 0.52 Mb
ps_emailsubscription 4 ms 0.44 Mb
ps_checkout 37 ms 1.74 Mb
ps_facebook 44 ms 1.31 Mb
paybox 11 ms 0.68 Mb
lgcookieslaw 121 ms 3.70 Mb
ps_accounts 1 ms 0.05 Mb
revsliderprestashop 77 ms 6.70 Mb
iqitcontactpage 1 ms 0.12 Mb
iqitcountdown 2 ms 0.04 Mb
iqitlinksmanager 43 ms 0.60 Mb
iqitsociallogin 2 ms 0.07 Mb
productcomments 3 ms 0.18 Mb
ps_shoppingcart 1 ms 0.05 Mb
ets_bestselling 2 ms 0.17 Mb
ets_recaptcha_free 1 ms 0.17 Mb
ps_searchbar 8 ms 0.08 Mb
iqitelementor 963 ms 14.28 Mb
iqitfreedeliverycount 1 ms 0.06 Mb
iqitmegamenu 136 ms 3.57 Mb
iqitreviews 65 ms 0.43 Mb
iqitsizecharts 3 ms 0.24 Mb
iqitextendedproduct 3 ms 0.13 Mb
ets_superspeed 17 ms 0.22 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.14 Mb
iqitsearch 1 ms - Mb
ps_customersignin 0 ms 0.02 Mb
iqitproductsnav 5 ms 0.23 Mb
35 module(s) 1734 ms 42.97 Mb

Stopwatch SQL - 293 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
37816 ms 35022 /modules/gformbuilderpro/gformbuilderpro.php:380
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
22271 ms 28 Yes Yes /classes/Category.php:793
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (144) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
19353 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 35
16902 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
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`
16682 ms 2100 Yes Yes /classes/Hook.php:1183
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`)
16172 ms 1308 /classes/Configuration.php:160
SELECT SQL_NO_CACHE lower(name) as name
FROM `cdf_hook` h
WHERE (h.active = 1)
15854 ms 854 /classes/Hook.php:1283
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
14488 ms 1 /classes/Cart.php:4218
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)
14317 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE *
FROM `cdf_contact` c
LEFT JOIN cdf_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `cdf_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 1
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
14230 ms 2 Yes Yes /classes/Contact.php:99
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
13671 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` = 45) AND (b.`id_shop` = 1) LIMIT 1
13061 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
12108 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
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 (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `cdf_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `cdf_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `cdf_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `cdf_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `cdf_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN cdf_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (144) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY FIELD(product_shop.id_product, 144)
10934 ms 0 /modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php:753
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 144
ORDER BY f.position ASC
10770 ms 1 Yes /classes/Product.php:5897
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
9870 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_accounts" LIMIT 1
9694 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE * FROM `cdf_configurator_cart_detail` ccd
WHERE ccd.id_configurator=64
AND ccd.id_guest = 0 
AND ccd.added_in_cart = 0 LIMIT 1
9680 ms 2 /modules/configurator/classes/ConfiguratorCartDetailModel.php:1989
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
9286 ms 65 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE *
FROM `cdf_configurator_step` cs
INNER JOIN `cdf_configurator_step_lang` `csl` ON cs.id_configurator_step = csl.id_configurator_step
WHERE (cs.id_configurator_step = 293)
9168 ms 1 /modules/configurator/classes/step/ConfiguratorStepFactory.php:82
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
8688 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
8434 ms 1 /src/Adapter/EntityMapper.php:76
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
8397 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE `id_product` FROM `cdf_product_lang` WHERE `link_rewrite` = "" AND `id_lang` = 1 AND `id_shop` = 1 LIMIT 1
8156 ms 67 /modules/configurator/configurator.php:1373
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
7691 ms 1 /src/Adapter/EntityMapper.php:76
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)
7563 ms 1 /modules/iqitmegamenu/models/IqitMenuLinks.php:25
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
7490 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
7374 ms 105 /classes/module/Module.php:340
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
7322 ms 3 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
SELECT SQL_NO_CACHE * FROM cdf_revslider_sliders
7122 ms 5 /modules/revsliderprestashop/includes/revslider_db.class.php:215
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)
6825 ms 4 /modules/gformbuilderpro/classes/gformbuilderprofieldsModel.php:177
SELECT SQL_NO_CACHE *
FROM `cdf_configurator_step` cs
INNER JOIN `cdf_configurator_step_lang` `csl` ON cs.id_configurator_step = csl.id_configurator_step
WHERE (cs.id_configurator_step = 292)
6751 ms 1 /modules/configurator/classes/step/ConfiguratorStepFactory.php:82
SELECT SQL_NO_CACHE c.id_elementor FROM cdf_iqit_elementor_content c WHERE c.active = 1 AND c.hook = 652
6640 ms 2 /modules/iqitelementor/src/IqitElementorContent.php:127
SELECT SQL_NO_CACHE *
FROM `cdf_cms_category` a
LEFT JOIN `cdf_cms_category_shop` `c` ON a.`id_cms_category` = c.`id_cms_category` AND c.`id_shop` = 1
WHERE (a.`id_cms_category` = 1) LIMIT 1
6517 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 1) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
6461 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
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
6424 ms 0 /classes/Hook.php:1243
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
6108 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `cdf_pscheckout_funding_source`
WHERE `id_shop` = 1
5977 ms 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `cdf_product_attribute` pa
INNER JOIN cdf_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `cdf_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `cdf_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `cdf_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `cdf_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (145) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
5704 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 145 AND `id_group` = 1 LIMIT 1
5568 ms 0 /classes/GroupReduction.php:156
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
5406 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
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)
5121 ms 1 /classes/Language.php:1049
SELECT SQL_NO_CACHE *
FROM `cdf_configurator` a
LEFT JOIN `cdf_configurator_shop` `c` ON a.`id_configurator` = c.`id_configurator` AND c.`id_shop` = 1
WHERE (a.`id_configurator` = 64) LIMIT 1
5111 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` = 144 LIMIT 1
5034 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
5014 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
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 (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `cdf_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `cdf_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `cdf_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `cdf_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `cdf_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN cdf_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (145) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY FIELD(product_shop.id_product, 145)
4897 ms 0 /modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php:753
SELECT SQL_NO_CACHE `name`, `alias` FROM `cdf_hook_alias`
4790 ms 88 /classes/Hook.php:301
SELECT SQL_NO_CACHE * FROM `cdf_configurator_cart_detail` ccd
WHERE ccd.id_configurator=25
AND ccd.id_guest = 0 
AND ccd.added_in_cart = 0 LIMIT 1
4766 ms 3 /modules/configurator/classes/ConfiguratorCartDetailModel.php:1989
SELECT SQL_NO_CACHE * FROM `cdf_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
4678 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
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 (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `cdf_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `cdf_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `cdf_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `cdf_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `cdf_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN cdf_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (146) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
ORDER BY FIELD(product_shop.id_product, 146)
4560 ms 0 /modules/iqitelementor/src/widgets/IqitElementorWidget_ProductsList.php:753
SELECT SQL_NO_CACHE * FROM `cdf_currency` c ORDER BY `iso_code` ASC
4553 ms 1 Yes /classes/Currency.php:709
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`
4386 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE id_tab, class_name FROM `cdf_tab`
4369 ms 200 /classes/Tab.php:359
SELECT SQL_NO_CACHE format
FROM `cdf_address_format`
WHERE `id_country` = 8 LIMIT 1
4365 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
4222 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
4091 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 144 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 144 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
4084 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM cdf_required_field
3998 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 146 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 146 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3983 ms 0 /classes/Cart.php:1429
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)
3781 ms 6 /modules/lgcookieslaw/classes/LGCookiesLawPurpose.php:355
SELECT SQL_NO_CACHE * FROM `cdf_hook_module_exceptions`
WHERE `id_shop` IN (1)
3633 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE psgdpr.active FROM `cdf_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 102 LIMIT 1
3348 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
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
3125 ms 502 /classes/Hook.php:504
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 144) AND (b.`id_shop` = 1) LIMIT 1
2979 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_cms_category_lang`
WHERE `id_cms_category` = 1 AND `id_shop` = 1
2930 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 (146) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2922 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 146
ORDER BY f.position ASC
2883 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 144
AND image_shop.`cover` = 1 LIMIT 1
2780 ms 3 /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` = 145
ORDER BY `position`
2773 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `cdf_iqit_link_block_lang`
WHERE `id_iqit_link_block` = 4
2772 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_configurator_step` cs
INNER JOIN `cdf_configurator_step_lang` `csl` ON cs.id_configurator_step = csl.id_configurator_step
WHERE (cs.id_configurator_step = 302)
2689 ms 1 /modules/configurator/classes/step/ConfiguratorStepFactory.php:82
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 144 LIMIT 1
2627 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE *
FROM `cdf_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
2566 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_configurator_step` cs
INNER JOIN `cdf_configurator_step_lang` `csl` ON cs.id_configurator_step = csl.id_configurator_step
WHERE (cs.id_configurator_step = 297)
2478 ms 1 /modules/configurator/classes/step/ConfiguratorStepFactory.php:82
SELECT SQL_NO_CACHE *
FROM `cdf_group_lang`
WHERE `id_group` = 1
2477 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 56) LIMIT 1
2448 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` = 146
ORDER BY `position`
2420 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `cdf_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 145 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `cdf_cart_product` cp JOIN `cdf_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `cdf_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 145 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2420 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 831 LIMIT 1
2394 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE * FROM `cdf_configurator_cart_detail` ccd
WHERE ccd.id_configurator=65
AND ccd.id_guest = 0 
AND ccd.added_in_cart = 0 LIMIT 1
2262 ms 4 /modules/configurator/classes/ConfiguratorCartDetailModel.php:1989
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 82 AND `id_shop` = 1 LIMIT 1
2227 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_facebook" LIMIT 1
2214 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `iso_code`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
2212 ms 1 /classes/Country.php:274
SELECT SQL_NO_CACHE *
FROM `cdf_tax_lang`
WHERE `id_tax` = 1
2180 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 56 AND `id_shop` = 1
2162 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM cdf_feature_product pf
LEFT JOIN cdf_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN cdf_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN cdf_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN cdf_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 145
ORDER BY f.position ASC
2101 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `cdf_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 144
ORDER BY `position`
2033 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `reduction`
FROM `cdf_product_group_reduction_cache`
WHERE `id_product` = 144 AND `id_group` = 1 LIMIT 1
1993 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 144) LIMIT 1
1934 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` = 145 LIMIT 1
1928 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 145 LIMIT 1
1888 ms 1 /classes/Product.php:1037
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
1882 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `cdf_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 146 LIMIT 1
1876 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 145) AND (b.`id_shop` = 1) LIMIT 1
1785 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE a.*, b.`cookie_purpose`, b.`expiry_time`, b.`script_code`
FROM `cdf_lgcookieslaw_cookie` a
LEFT JOIN `cdf_lgcookieslaw_cookie_lang` `b` ON (b.`id_lgcookieslaw_cookie` = a.`id_lgcookieslaw_cookie` AND b.`id_lang` = 1)
WHERE (a.`id_lgcookieslaw_purpose` = 3) AND (a.`id_shop` = 1) AND (a.`active` = 1)
ORDER BY a.`name`
1757 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 146 LIMIT 1
1727 ms 1 /classes/Product.php:1037
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
1715 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 1 AND `id_shop` = 1 LIMIT 1
1701 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `cdf_configurator` a
LEFT JOIN `cdf_configurator_shop` `c` ON a.`id_configurator` = c.`id_configurator` AND c.`id_shop` = 1
WHERE (a.`id_configurator` = 65) LIMIT 1
1695 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitelementor" LIMIT 1
1663 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 146) AND (b.`id_shop` = 1) LIMIT 1
1625 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `cdf_currency` c
LEFT JOIN cdf_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
1605 ms 1 /classes/Currency.php:1126
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitreviews" LIMIT 1
1598 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_viewer2d" LIMIT 1
1586 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `cdf_hook`
1561 ms 854 /classes/Hook.php:1243
SELECT SQL_NO_CACHE *
FROM `cdf_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
1548 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 75 AND `id_shop` = 1 LIMIT 1
1517 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `cdf_image` i
INNER JOIN cdf_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 145
AND image_shop.`cover` = 1 LIMIT 1
1510 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM `cdf_product_lang`
WHERE `id_product` = 145 AND `id_shop` = 1
1508 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "contactform" LIMIT 1
1508 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 146) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1487 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_order`
FROM `cdf_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
1477 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
1473 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_configurator_step` cs
INNER JOIN `cdf_configurator_step_lang` `csl` ON cs.id_configurator_step = csl.id_configurator_step
WHERE (cs.id_configurator_step = 303)
1472 ms 1 /modules/configurator/classes/step/ConfiguratorStepFactory.php:82
SELECT SQL_NO_CACHE * FROM `cdf_image_type`
1412 ms 8 /classes/ImageType.php:147
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitproductsnav" LIMIT 1
1402 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
1384 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "dm_advancedformula" LIMIT 1
1346 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 145
1338 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
1331 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 36 AND `id_shop` = 1
1326 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 65 AND `id_shop` = 1 LIMIT 1
1275 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_country`
FROM `cdf_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
1266 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
1260 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE SUM(quantity)
FROM `cdf_stock_available`
WHERE (id_product = 145) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1259 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "gformbuilderpro" LIMIT 1
1248 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
1234 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 146) LIMIT 1
1228 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
1209 ms 105 /classes/module/Module.php:340
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 536 LIMIT 1
1193 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE *
FROM `cdf_product` a
LEFT JOIN `cdf_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 145) LIMIT 1
1176 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE value FROM `cdf_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
1154 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE *
FROM `cdf_country_lang`
WHERE `id_country` = 8
1147 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1
1143 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 90 AND `id_shop` = 1 LIMIT 1
1140 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE domain, domain_ssl
FROM cdf_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1105 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE *
FROM `cdf_configurator_step` cs
INNER JOIN `cdf_configurator_step_lang` `csl` ON cs.id_configurator_step = csl.id_configurator_step
WHERE (cs.id_configurator_step = 298)
1102 ms 1 /modules/configurator/classes/step/ConfiguratorStepFactory.php:82
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 36) LIMIT 1
1091 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` = 146
AND image_shop.`cover` = 1 LIMIT 1
1086 ms 3 /classes/Product.php:3533
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
1082 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_currency` a
LEFT JOIN `cdf_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
1065 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_configurator` a
LEFT JOIN `cdf_configurator_shop` `c` ON a.`id_configurator` = c.`id_configurator` AND c.`id_shop` = 1
WHERE (a.`id_configurator` = 25) LIMIT 1
1065 ms 1 /src/Adapter/EntityMapper.php:76
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
1064 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE id_shop
FROM `cdf_cms_shop`
WHERE `id_cms` = 45
AND id_shop = 1 LIMIT 1
1056 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
1053 ms 1 /classes/module/Module.php:2328
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`
1053 ms 3 Yes /modules/lgcookieslaw/classes/LGCookiesLawCookie.php:812
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 102 AND `id_shop` = 1 LIMIT 1
1053 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 146
AND `required` = 1 AND `is_deleted` = 0
1051 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE *
FROM `cdf_product_lang`
WHERE `id_product` = 146 AND `id_shop` = 1
1035 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
1033 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `cdf_product` p
INNER JOIN `cdf_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `cdf_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 145)
1028 ms 1 /override/classes/Product.php:442
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 146 AND id_shop=1 LIMIT 1
1025 ms 1 /classes/Product.php:6751
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `cdf_product_attribute`
WHERE `id_product` = 146
1023 ms 1 /classes/Product.php:2875
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
1013 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field_lang`
WHERE `id_customization_field` = 57 AND `id_shop` = 1
1011 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_customization_field` a
WHERE (a.`id_customization_field` = 57) LIMIT 1
997 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_product_lang`
WHERE `id_product` = 144 AND `id_shop` = 1
992 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category` a
LEFT JOIN `cdf_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) LIMIT 1
987 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
982 ms 0 /classes/module/Module.php:2328
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
974 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
965 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "ps_searchbar" LIMIT 1
954 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
934 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module` WHERE `name` = "iqitmegamenu" LIMIT 1
930 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` = 371) LIMIT 1
928 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1
919 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `cdf_category_lang`
WHERE `id_category` = 34 AND `id_shop` = 1
917 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `need_identification_number`
FROM `cdf_country`
WHERE `id_country` = 8 LIMIT 1
903 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE *
FROM `cdf_currency_lang`
WHERE `id_currency` = 1
881 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `cdf_customization_field`
WHERE `id_product` = 145
AND `required` = 1 AND `is_deleted` = 0
878 ms 1 /classes/Product.php:6494
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
873 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `width`, `height`
FROM cdf_image_type
WHERE `name` = 'small_default' LIMIT 1
869 ms 1 /classes/Image.php:510
SELECT SQL_NO_CACHE `name`
FROM `cdf_hook`
WHERE `id_hook` = 538 LIMIT 1
867 ms 1 /classes/Hook.php:239
SELECT SQL_NO_CACHE `id_module` FROM `cdf_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
861 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE option_value FROM `cdf_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
860 ms 13 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `cdf_product_shop`
WHERE `id_product` = 145 AND id_shop=1 LIMIT 1
858 ms 1 /classes/Product.php:6751
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`
854 ms 1 Yes /classes/CMS.php:151
SELECT SQL_NO_CACHE `id_lang` FROM `cdf_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
827 ms 1 /classes/Language.php:853
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
826 ms 1 /src/Adapter/EntityMapper.php:76