Load Time 449.817 ms
Querying Time 52 ms
Queries 216
Memory Peak Usage 41.4 Mb
Included Files 1044 files - 13.28 Mb
PrestaShop Cache 0.86 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 3.339 ms 3.339 ms 3.15 Mb 3.1 Mb
__construct 0.681 ms 4.020 ms 0.02 Mb 3.8 Mb
init 10.141 ms 14.161 ms 1.33 Mb 4.6 Mb
checkAccess 0.002 ms 14.163 ms - Mb 4.6 Mb
setMedia 0.803 ms 14.966 ms 0.13 Mb 4.6 Mb
postProcess 0.001 ms 14.967 ms - Mb 4.6 Mb
initHeader 0.001 ms 14.968 ms - Mb 4.6 Mb
initContent 19.062 ms 34.030 ms 3.04 Mb 7.7 Mb
initFooter 0.001 ms 34.031 ms - Mb 7.7 Mb
display 415.786 ms 449.817 ms 33.40 Mb 41.4 Mb
Hook Time Memory Usage
CETemplate 495.784 ms 39.76 Mb
DisplayHeader 6.103 ms 1.30 Mb
OverrideLayoutTemplate 1.313 ms 0.06 Mb
displaySearch 0.747 ms 0.13 Mb
DisplayBeforeBodyClosingTag 0.377 ms 0.02 Mb
ProductSearchProvider 0.183 ms 0.01 Mb
ActionFrontControllerSetMedia 0.168 ms 0.01 Mb
ActionCreativeElementsInit 0.096 ms 0.05 Mb
ModuleRoutes 0.020 ms 0.01 Mb
ActionFrontControllerInitAfter 0.011 ms - Mb
10 hook(s) 504.802 ms 41.34 Mb
Module Time Memory Usage
pkcompare 1.126 ms - Mb
pklookbook 0.572 ms 0.06 Mb
pkfavorites 0.908 ms 0.06 Mb
ph_simpleblog 1.120 ms 0.26 Mb
creativeelements 501.169 ms 40.95 Mb
blockreassurance 0.204 ms 0.04 Mb
ps_emailsubscription 0.110 ms 0.03 Mb
ps_emailalerts 0.120 ms 0.04 Mb
pkelements 0.471 ms 0.09 Mb
pkcaptcha 0.058 ms 0.02 Mb
pkinstagram 0.101 ms 0.03 Mb
pk_menu 0.119 ms 0.13 Mb
pkpopup 0.056 ms 0.02 Mb
pkthemesettings 0.918 ms 0.15 Mb
ps_shoppingcart 0.089 ms 0.02 Mb
ps_searchbar 0.913 ms 0.15 Mb
pkfacebook 0.266 ms 0.03 Mb
productcomments 0.107 ms 0.09 Mb
revsliderprestashop 1.573 ms 0.86 Mb
pkfrontpanel 0.058 ms 0.02 Mb
ps_facetedsearch 0.441 ms 0.11 Mb
psgdpr 0.164 ms 0.11 Mb
ps_linklist 0.175 ms 0.02 Mb
23 module(s) 510.839 ms 43.20 Mb

Stopwatch SQL - 216 queries

# Query Time (ms) Rows Filesort Group By Location
61
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("895ac341046bc83678079e167bc9dd40", "a:1:{s:7:\"filters\";a:0:{}}")
1.949 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
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`
1.661 ms 964 Yes Yes /classes/Hook.php:1233
152
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.589 ms 0 /classes/Hook.php:1292
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`)
1.344 ms 544 /classes/Configuration.php:180
57
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>=33 AND c.nright<=34 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
1.134 ms 1134 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
0.752 ms 979 /classes/Hook.php:1332
58
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>=33 AND c.nright<=34 GROUP BY p.id_product) p
0.741 ms 378 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.581 ms 979 /classes/Hook.php:1292
97
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.515 ms 25 Yes /classes/Category.php:626
140
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 >= 26 AND nright <= 35
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.483 ms 23 Yes /modules/creativeelements/includes/base/widget-category-base.php:170
112
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.476 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
204
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.424 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
83
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.424 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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.423 ms 81 /classes/module/Module.php:345
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.422 ms 64 Yes /classes/Dispatcher.php:654
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.410 ms 81 /classes/module/Module.php:345
138
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` = 25  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 25
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.388 ms 1 Yes Yes /classes/Category.php:921
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.377 ms 1 Yes /classes/shop/Shop.php:1364
98
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.355 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
69
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.354 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.350 ms 81 /classes/module/Module.php:345
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.349 ms 81 /classes/module/Module.php:345
70
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.347 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.341 ms 81 /classes/module/Module.php:345
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` = 25
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.336 ms 1 Yes Yes /classes/Category.php:921
150
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.316 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
106
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_page_settings' LIMIT 1
0.310 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.303 ms 1 Yes /classes/shop/Shop.php:715
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.292 ms 1 /classes/Language.php:1216
51
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 33) AND (a0.`nright` > 34) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.288 ms 25 Yes /classes/PrestaShopCollection.php:383
71
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.274 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
54
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 25
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.274 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
118
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.270 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
144
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_page_settings' LIMIT 1
0.269 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
198
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_version' LIMIT 1
0.268 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
68
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.268 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.265 ms 1 /src/Adapter/EntityMapper.php:71
82
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.262 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
110
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.261 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
145
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.259 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
81
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.258 ms 1 /classes/module/Module.php:2636
62
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25040101 AND name = '_elementor_edit_mode' LIMIT 1
0.256 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
64
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25040101 AND name = '_elementor_page_settings' LIMIT 1
0.255 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
99
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.253 ms 1 /classes/module/Module.php:2636
206
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.249 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
113
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.249 ms 1 /classes/Meta.php:193
147
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.248 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
146
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.248 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.246 ms 1 Yes /classes/Language.php:1004
67
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.246 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
63
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25040101 AND name = '_wp_page_template' LIMIT 1
0.239 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
120
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.238 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
205
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_page_settings' LIMIT 1
0.237 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
128
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_page_settings' LIMIT 1
0.236 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
184
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.235 ms 2 /classes/Meta.php:193
159
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.234 ms 2 /classes/Meta.php:193
94
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.233 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
126
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_version' LIMIT 1
0.232 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
119
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.232 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
53
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.230 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
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.229 ms 1 /classes/shop/Shop.php:218
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.227 ms 88 /classes/Hook.php:287
92
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_page_settings' LIMIT 1
0.227 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.225 ms 1 Yes /classes/Currency.php:709
153
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.225 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
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
213
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = '_u_elementor_preferences' LIMIT 1
0.224 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
137
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.222 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
42
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.221 ms 1 /classes/Cart.php:4192
66
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 25) LIMIT 1
0.220 ms 1 /src/Adapter/EntityMapper.php:71
93
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.219 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
192
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.219 ms 2 /classes/Meta.php:193
160
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.218 ms 2 /classes/Meta.php:193
203
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 54) LIMIT 1
0.218 ms 1 /src/Adapter/EntityMapper.php:71
176
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.216 ms 2 /classes/Meta.php:193
139
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` = 21) AND (b.`id_shop` = 1) LIMIT 1
0.216 ms 1 /src/Adapter/EntityMapper.php:71
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.215 ms 1 /src/Adapter/EntityMapper.php:71
125
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.214 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
84
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.210 ms 1 /classes/Meta.php:193
130
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.208 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
72
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.208 ms 8 /classes/ImageType.php:161
173
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.207 ms 1 /classes/Meta.php:193
208
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_data' LIMIT 1
0.207 ms 4 /modules/creativeelements/classes/wrappers/Post.php:273
95
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.203 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
191
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.202 ms 2 /classes/Meta.php:193
131
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.202 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.201 ms 2 /classes/Meta.php:193
202
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.200 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
111
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.199 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
96
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.199 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
108
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
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.198 ms 1 /classes/shop/Shop.php:1183
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.196 ms 1 /src/Adapter/EntityMapper.php:71
185
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.195 ms 2 /classes/Meta.php:193
149
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.194 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.192 ms 1 /src/Adapter/EntityMapper.php:71
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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.192 ms 2 /classes/Meta.php:193
141
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.192 ms 1 /classes/module/Module.php:2636
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` = 4) LIMIT 1
0.192 ms 1 /src/Adapter/EntityMapper.php:71
107
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.192 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
207
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.191 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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 = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.191 ms 1 /classes/Meta.php:193
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 = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.190 ms 1 /classes/Meta.php:193
197
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.189 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
26
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.189 ms 1 /classes/Language.php:883
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.189 ms 1 /classes/Language.php:1080
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.189 ms 88 /classes/Hook.php:339
177
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
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 = "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
175
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.187 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
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 = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.187 ms 1 /classes/Meta.php:193
60
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 25
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.187 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
55
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` = 25) LIMIT 1
0.186 ms 1 /src/Adapter/EntityMapper.php:71
143
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 24) LIMIT 1
0.186 ms 1 /src/Adapter/EntityMapper.php:71
170
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` = 5) LIMIT 1
0.185 ms 1 /src/Adapter/EntityMapper.php:71
40
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 25 AND ctg.`id_group` = 1 LIMIT 1
0.185 ms 1 /classes/Category.php:1751
73
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1
0.185 ms 1 /classes/module/Module.php:2636
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 = "stores"
OR m.page = "stores"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.185 ms 1 /classes/Meta.php:193