Load Time 450.135 ms
Querying Time 62 ms
Queries 218
Memory Peak Usage 41.4 Mb
Included Files 1044 files - 13.28 Mb
PrestaShop Cache 0.87 Mb
Global vars 0.82 Mb
PrestaShop Version 8.1.2
PHP Version 7.4.3-4ubuntu2.19
MySQL Version 8.0.35-0ubuntu0.20.04.1
Memory Limit 128M
Max Execution Time 30s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 4.180 ms 4.180 ms 3.16 Mb 3.2 Mb
__construct 0.779 ms 4.959 ms 0.02 Mb 3.8 Mb
init 11.834 ms 16.793 ms 1.36 Mb 4.6 Mb
checkAccess 0.001 ms 16.794 ms - Mb 4.6 Mb
setMedia 0.796 ms 17.590 ms 0.13 Mb 4.7 Mb
postProcess 0.001 ms 17.591 ms - Mb 4.7 Mb
initHeader 0.001 ms 17.592 ms - Mb 4.7 Mb
initContent 20.206 ms 37.798 ms 3.05 Mb 7.7 Mb
initFooter 0.002 ms 37.800 ms - Mb 7.7 Mb
display 412.335 ms 450.135 ms 33.36 Mb 41.4 Mb
Hook Time Memory Usage
CETemplate 487.963 ms 39.73 Mb
DisplayHeader 6.562 ms 1.30 Mb
OverrideLayoutTemplate 0.992 ms 0.05 Mb
displaySearch 0.758 ms 0.13 Mb
DisplayBeforeBodyClosingTag 0.424 ms 0.02 Mb
ProductSearchProvider 0.211 ms 0.01 Mb
ActionFrontControllerSetMedia 0.165 ms 0.01 Mb
ActionCreativeElementsInit 0.103 ms 0.05 Mb
ModuleRoutes 0.026 ms 0.01 Mb
ActionFrontControllerInitAfter 0.011 ms - Mb
10 hook(s) 497.215 ms 41.30 Mb
Module Time Memory Usage
pkcompare 1.718 ms - Mb
pklookbook 0.965 ms 0.06 Mb
pkfavorites 1.006 ms 0.06 Mb
ph_simpleblog 1.164 ms 0.26 Mb
creativeelements 493.186 ms 40.91 Mb
blockreassurance 0.216 ms 0.04 Mb
ps_emailsubscription 0.112 ms 0.03 Mb
ps_emailalerts 0.118 ms 0.04 Mb
pkelements 0.532 ms 0.09 Mb
pkcaptcha 0.058 ms 0.02 Mb
pkinstagram 0.107 ms 0.03 Mb
pk_menu 0.124 ms 0.13 Mb
pkpopup 0.056 ms 0.02 Mb
pkthemesettings 1.061 ms 0.15 Mb
ps_shoppingcart 0.092 ms 0.02 Mb
ps_searchbar 0.906 ms 0.15 Mb
pkfacebook 0.339 ms 0.03 Mb
productcomments 0.126 ms 0.09 Mb
revsliderprestashop 1.810 ms 0.86 Mb
pkfrontpanel 0.061 ms 0.02 Mb
ps_facetedsearch 0.571 ms 0.11 Mb
psgdpr 0.163 ms 0.11 Mb
ps_linklist 0.210 ms 0.02 Mb
23 module(s) 504.700 ms 43.16 Mb

Stopwatch SQL - 218 queries

# Query Time (ms) Rows Filesort Group By Location
14
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_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 `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_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`
3.354 ms 964 Yes Yes /classes/Hook.php:1233
2
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
3.046 ms 544 /classes/Configuration.php:180
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.838 ms 979 /classes/Hook.php:1332
64
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("8dad55ae920401f45f683ed432f64120", "a:1:{s:7:\"filters\";a:0:{}}")
1.786 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
154
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.650 ms 0 /classes/Hook.php:1292
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
1.173 ms 979 /classes/Hook.php:1292
60
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=18 AND c.nright<=25 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC LIMIT 0, 12
0.977 ms 1134 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.alarmemaison.com' OR su.domain_ssl = 'www.alarmemaison.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.924 ms 1 Yes /classes/shop/Shop.php:1364
61
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, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=18 AND c.nright<=25 GROUP BY p.id_product) p
0.880 ms 378 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
17
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.773 ms 81 /classes/module/Module.php:345
11
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.766 ms 1 /classes/Language.php:1216
1
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 ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_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
0.714 ms 1 Yes /classes/shop/Shop.php:715
19
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.620 ms 81 /classes/module/Module.php:345
6
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.608 ms 1 /src/Adapter/EntityMapper.php:71
100
SELECT SQL_NO_CACHE *
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
0.559 ms 25 Yes /classes/Category.php:626
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_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
0.558 ms 1 /classes/shop/Shop.php:218
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.530 ms 1 /classes/Language.php:1080
8
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.495 ms 1 /src/Adapter/EntityMapper.php:71
141
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 20  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 20
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.495 ms 23 Yes Yes /classes/Category.php:921
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.491 ms 1 /classes/shop/ShopUrl.php:182
23
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.474 ms 64 Yes /classes/Dispatcher.php:654
41
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 20
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.463 ms 23 Yes Yes /classes/Category.php:921
142
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_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` <= 8
AND nleft >= 18 AND nright <= 25
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
0.450 ms 23 Yes /modules/creativeelements/includes/base/widget-category-base.php:170
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.449 ms 1 /src/Adapter/EntityMapper.php:71
86
SELECT SQL_NO_CACHE pk.*, wl.*
FROM ps_pk_menu_shop pk
LEFT JOIN `ps_pk_menu_lang` wl ON (wl.`id_pkmenu` = pk.`id_pkmenu` AND pk.`id_shop` = wl.`id_shop`)
WHERE pk.active = 1 AND wl.id_shop = 1 AND wl.id_lang=1 ORDER BY pk.position ASC, pk.id_pkmenu ASC
0.444 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.439 ms 88 /classes/Hook.php:287
115
SELECT SQL_NO_CACHE pk.*, wl.*
FROM ps_pk_menu_shop pk
LEFT JOIN `ps_pk_menu_lang` wl ON (wl.`id_pkmenu` = pk.`id_pkmenu` AND pk.`id_shop` = wl.`id_shop`)
WHERE pk.active = 1 AND wl.id_shop = 1 AND wl.id_lang=1 ORDER BY pk.position ASC, pk.id_pkmenu ASC
0.425 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
7
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.419 ms 1 /src/Adapter/EntityMapper.php:71
22
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.403 ms 81 /classes/module/Module.php:345
12
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.401 ms 1 Yes /classes/Language.php:1004
9
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.379 ms 1 /classes/ObjectModel.php:1729
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.361 ms 88 /classes/Hook.php:339
20
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.355 ms 81 /classes/module/Module.php:345
54
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 18) AND (a0.`nright` > 25) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.346 ms 25 Yes /classes/PrestaShopCollection.php:383
39
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.341 ms 81 /classes/module/Module.php:345
206
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.339 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
97
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.330 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
101
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.324 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
200
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_version' LIMIT 1
0.314 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
152
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.312 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
24
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1
0.299 ms 1 /src/Adapter/EntityMapper.php:71
199
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.294 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
84
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.280 ms 1 /classes/module/Module.php:2636
57
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 20
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.272 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
133
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.266 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
155
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps_link_block lb
INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 45 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
0.261 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
85
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.261 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
146
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_page_settings' LIMIT 1
0.257 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
147
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.248 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
121
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.243 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
161
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.242 ms 2 /classes/Meta.php:193
95
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_page_settings' LIMIT 1
0.241 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
201
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.239 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
113
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.239 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
205
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 54) LIMIT 1
0.238 ms 1 /src/Adapter/EntityMapper.php:71
109
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_page_settings' LIMIT 1
0.235 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
42
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) AND (b.`id_shop` = 1) LIMIT 1
0.235 ms 1 /src/Adapter/EntityMapper.php:71
203
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.234 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
207
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_page_settings' LIMIT 1
0.232 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
56
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.230 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
63
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 20
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.230 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
87
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.228 ms 1 /classes/Meta.php:193
96
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.228 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
123
SELECT SQL_NO_CACHE l.link_rewrite
FROM `ps_simpleblog_category_lang` l
WHERE (l.id_simpleblog_category = 0 AND l.id_lang = 1) LIMIT 1
0.226 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
132
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_data' LIMIT 1
0.225 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
204
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.225 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
102
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.225 ms 1 /classes/module/Module.php:2636
140
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.224 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
28
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.224 ms 1 /src/Adapter/EntityMapper.php:71
193
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.224 ms 2 /classes/Meta.php:193
162
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.223 ms 2 /classes/Meta.php:193
44
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) AND (b.`id_shop` = 1) LIMIT 1
0.223 ms 1 /src/Adapter/EntityMapper.php:71
134
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.222 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
116
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.222 ms 1 /classes/Meta.php:193
163
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.221 ms 2 /classes/Meta.php:193
202
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.221 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
45
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.220 ms 1 /classes/Cart.php:4192
131
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_page_settings' LIMIT 1
0.220 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
215
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = '_u_elementor_preferences' LIMIT 1
0.218 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
208
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.217 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
151
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.215 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
148
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.214 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
178
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.212 ms 2 /classes/Meta.php:193
210
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_data' LIMIT 1
0.211 ms 4 /modules/creativeelements/classes/wrappers/Post.php:273
149
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.209 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
186
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.208 ms 2 /classes/Meta.php:193
212
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 20040101 AND name = '_elementor_page_settings' LIMIT 1
0.207 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
58
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) LIMIT 1
0.206 ms 1 /src/Adapter/EntityMapper.php:71
98
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.206 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.205 ms 1 /classes/shop/Shop.php:1183
99
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.203 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.203 ms 1 Yes /classes/Currency.php:709
43
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
0.201 ms 1 /src/Adapter/EntityMapper.php:71
62
SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="8dad55ae920401f45f683ed432f64120" LIMIT 1
0.201 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
48
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.200 ms 8 Yes /classes/ImageType.php:109
192
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps_link_block lb
INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 45 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
0.200 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
26
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.199 ms 1 /classes/Language.php:883
111
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_css' LIMIT 1
0.199 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
128
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.197 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
209
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.196 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
27
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.195 ms 1 /classes/Currency.php:893
181
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.195 ms 1 /classes/Meta.php:193
189
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.194 ms 1 /classes/Meta.php:193
156
SELECT SQL_NO_CACHE *
FROM `ps_link_block` a
LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 1) LIMIT 1
0.194 ms 1 /src/Adapter/EntityMapper.php:71
179
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.192 ms 2 /classes/Meta.php:193
174
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.192 ms 1 /classes/Meta.php:193
122
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.191 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
214
SELECT SQL_NO_CACHE id_ce_revision FROM ps_ce_revision WHERE parent = 20040101 AND active = 0 AND id_employee = 0 LIMIT 1
0.190 ms 1 /modules/creativeelements/classes/wrappers/Post.php:510
114
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.190 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
65
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 20040101 AND name = '_elementor_edit_mode' LIMIT 1
0.190 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
145
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 24) LIMIT 1
0.189 ms 1 /src/Adapter/EntityMapper.php:71
143
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.189 ms 1 /classes/module/Module.php:2636
31
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.188 ms 1 /src/Adapter/EntityMapper.php:71
180
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.188 ms 2 /classes/Meta.php:193
187
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.188 ms 2 /classes/Meta.php:193
70
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.188 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
194
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.188 ms 2 /classes/Meta.php:193
188
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.187 ms 2 /classes/Meta.php:193
169
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
0.187 ms 1 /src/Adapter/EntityMapper.php:79
195
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.186 ms 2 /classes/Meta.php:193
72
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.185 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
177
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps_link_block lb
INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 45 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
0.184 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
168
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) LIMIT 1
0.184 ms 1 /src/Adapter/EntityMapper.php:71
59
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 20 AND `id_shop` = 1
0.183 ms 1 /src/Adapter/EntityMapper.php:79
213
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 20040101 AND name = '_wp_page_template' LIMIT 1
0.183 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
110
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.182 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
75
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.182 ms 8 /classes/ImageType.php:161