Load Time 476.950 ms
Querying Time 72 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 6.496 ms 6.496 ms 3.15 Mb 3.1 Mb
__construct 1.364 ms 7.860 ms 0.02 Mb 3.8 Mb
init 19.855 ms 27.715 ms 1.33 Mb 4.6 Mb
checkAccess 0.002 ms 27.717 ms - Mb 4.6 Mb
setMedia 1.485 ms 29.202 ms 0.13 Mb 4.6 Mb
postProcess 0.001 ms 29.203 ms - Mb 4.6 Mb
initHeader 0.001 ms 29.204 ms - Mb 4.6 Mb
initContent 32.378 ms 61.582 ms 3.04 Mb 7.7 Mb
initFooter 0.001 ms 61.583 ms - Mb 7.7 Mb
display 415.367 ms 476.950 ms 33.40 Mb 41.4 Mb
Hook Time Memory Usage
CETemplate 491.560 ms 39.76 Mb
DisplayHeader 11.673 ms 1.30 Mb
OverrideLayoutTemplate 1.214 ms 0.06 Mb
displaySearch 0.819 ms 0.13 Mb
DisplayBeforeBodyClosingTag 0.425 ms 0.02 Mb
ProductSearchProvider 0.338 ms 0.01 Mb
ActionFrontControllerSetMedia 0.318 ms 0.01 Mb
ActionCreativeElementsInit 0.187 ms 0.05 Mb
ModuleRoutes 0.039 ms 0.01 Mb
ActionFrontControllerInitAfter 0.019 ms - Mb
10 hook(s) 506.593 ms 41.34 Mb
Module Time Memory Usage
pkcompare 2.350 ms - Mb
pklookbook 1.076 ms 0.06 Mb
pkfavorites 1.761 ms 0.06 Mb
ph_simpleblog 2.087 ms 0.26 Mb
creativeelements 500.459 ms 40.95 Mb
blockreassurance 0.383 ms 0.04 Mb
ps_emailsubscription 0.213 ms 0.03 Mb
ps_emailalerts 0.223 ms 0.04 Mb
pkelements 0.781 ms 0.09 Mb
pkcaptcha 0.112 ms 0.02 Mb
pkinstagram 0.178 ms 0.03 Mb
pk_menu 0.235 ms 0.13 Mb
pkpopup 0.140 ms 0.02 Mb
pkthemesettings 1.889 ms 0.15 Mb
ps_shoppingcart 0.205 ms 0.02 Mb
ps_searchbar 1.174 ms 0.15 Mb
pkfacebook 0.439 ms 0.03 Mb
productcomments 0.209 ms 0.09 Mb
revsliderprestashop 2.910 ms 0.86 Mb
pkfrontpanel 0.098 ms 0.02 Mb
ps_facetedsearch 0.857 ms 0.11 Mb
psgdpr 0.189 ms 0.11 Mb
ps_linklist 0.256 ms 0.02 Mb
23 module(s) 518.225 ms 43.20 Mb

Stopwatch SQL - 216 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.284 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`)
2.912 ms 544 /classes/Configuration.php:180
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
2.513 ms 0 /classes/Hook.php:1292
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
2.313 ms 979 /classes/Hook.php:1332
61
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("459fc6a1135001f153590fbba8156876", "a:1:{s:7:\"filters\";a:0:{}}")
1.775 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
1.139 ms 979 /classes/Hook.php:1292
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>=31 AND c.nright<=32 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.980 ms 1134 Yes /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.896 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.853 ms 64 Yes /classes/Dispatcher.php:654
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>=31 AND c.nright<=32 GROUP BY p.id_product) p
0.833 ms 378 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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.770 ms 81 /classes/module/Module.php:345
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` < 31) AND (a0.`nright` > 32) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.749 ms 25 Yes /classes/PrestaShopCollection.php:383
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` = 24
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.732 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.697 ms 1 Yes /classes/shop/Shop.php:1364
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.677 ms 81 /classes/module/Module.php:345
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.660 ms 1 Yes /classes/shop/Shop.php:715
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.649 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.642 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.616 ms 1 /classes/Language.php:1216
53
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.570 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
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.548 ms 1 Yes /classes/Language.php:1004
54
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 24
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.534 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.528 ms 88 /classes/Hook.php:287
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.517 ms 1 /classes/Cart.php:4192
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` = 24) AND (b.`id_shop` = 1) LIMIT 1
0.503 ms 1 /src/Adapter/EntityMapper.php:71
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.501 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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.496 ms 1 /src/Adapter/EntityMapper.php:71
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.479 ms 1 /classes/shop/ShopUrl.php:182
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.470 ms 25 Yes /classes/Category.php:626
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.464 ms 1 /src/Adapter/EntityMapper.php:71
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.454 ms 1 /classes/shop/Shop.php:218
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.454 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.443 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
30
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.440 ms 1 /classes/Country.php:194
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.428 ms 1 /src/Adapter/EntityMapper.php:71
48
SELECT SQL_NO_CACHE *
FROM `ps_country` a
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.419 ms 1 /src/Adapter/EntityMapper.php:71
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` = 24  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 24
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.399 ms 1 Yes Yes /classes/Category.php:921
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.393 ms 1 /classes/Language.php:1080
150
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.390 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.381 ms 1 Yes /classes/Currency.php:709
45
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.381 ms 8 Yes /classes/ImageType.php:109
49
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
0.379 ms 1 /src/Adapter/EntityMapper.php:79
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.378 ms 1 /classes/shop/Shop.php:1183
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.378 ms 1 /src/Adapter/EntityMapper.php:71
98
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.378 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
43
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.376 ms 0 /classes/module/Module.php:2636
29
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.374 ms 1 /classes/Language.php:883
35
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.371 ms 1 /src/Adapter/EntityMapper.php:71
81
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.370 ms 1 /classes/module/Module.php:2636
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.365 ms 1 /src/Adapter/EntityMapper.php:71
36
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.364 ms 1 /src/Adapter/EntityMapper.php:79
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.361 ms 88 /classes/Hook.php:339
204
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.357 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
52
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.349 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
198
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_version' LIMIT 1
0.349 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
32
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
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.336 ms 1 /src/Adapter/EntityMapper.php:71
33
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
0.335 ms 1 /src/Adapter/EntityMapper.php:79
9
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.331 ms 1 /classes/ObjectModel.php:1729
26
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.329 ms 1 /classes/Language.php:883
144
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_page_settings' LIMIT 1
0.320 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.315 ms 1 /classes/Currency.php:893
50
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.312 ms 1 /classes/ObjectModel.php:1592
82
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.311 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
44
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.308 ms 0 /classes/module/Module.php:2109
40
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 24 AND ctg.`id_group` = 1 LIMIT 1
0.307 ms 1 /classes/Category.php:1751
145
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.306 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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.306 ms 2 /classes/Meta.php:193
7
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.299 ms 1 /src/Adapter/EntityMapper.php:71
110
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.298 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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.294 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
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` = 24) LIMIT 1
0.293 ms 1 /src/Adapter/EntityMapper.php:71
37
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.284 ms 1 /classes/ObjectModel.php:1729
38
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.284 ms 1 /classes/module/Module.php:2018
197
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.282 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
99
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.276 ms 1 /classes/module/Module.php:2636
46
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
0.274 ms 1 /classes/AddressFormat.php:656
34
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.272 ms 1 /classes/ObjectModel.php:1729
203
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 54) LIMIT 1
0.271 ms 1 /src/Adapter/EntityMapper.php:71
146
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.271 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
47
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
0.268 ms 1 /classes/Country.php:402
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.268 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.266 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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.265 ms 2 /classes/Meta.php:193
147
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.262 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
118
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.251 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
64
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24040101 AND name = '_elementor_page_settings' LIMIT 1
0.247 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
92
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_page_settings' LIMIT 1
0.246 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
106
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_page_settings' LIMIT 1
0.246 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
164
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` = 2) LIMIT 1
0.241 ms 1 /src/Adapter/EntityMapper.php:71
67
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.241 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
202
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.238 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
172
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.233 ms 1 /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.233 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
205
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
208
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_data' LIMIT 1
0.230 ms 4 /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.230 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
128
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_page_settings' LIMIT 1
0.229 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
72
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.229 ms 8 /classes/ImageType.php:161
213
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = '_u_elementor_preferences' LIMIT 1
0.229 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
93
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.227 ms 5 /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.227 ms 1 /classes/Meta.php:193
137
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.227 ms 6 /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.224 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
60
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 24
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.223 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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.223 ms 2 /classes/Meta.php:193
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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.222 ms 2 /classes/Meta.php:193
143
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 24) LIMIT 1
0.221 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.220 ms 2 /classes/Meta.php:193
108
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_css' LIMIT 1
0.220 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
94
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.220 ms 1 /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.219 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
210
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24040101 AND name = '_elementor_page_settings' LIMIT 1
0.217 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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
154
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.215 ms 1 /src/Adapter/EntityMapper.php:71
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.215 ms 1 /classes/Meta.php:193
199
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.214 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
206
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.213 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
151
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 45 LIMIT 1
0.213 ms 1 /classes/Hook.php:244
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.212 ms 1 /src/Adapter/EntityMapper.php:71
132
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.211 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
155
SELECT SQL_NO_CACHE *
FROM `ps_link_block_lang`
WHERE `id_link_block` = 1
0.210 ms 1 /src/Adapter/EntityMapper.php:79
201
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.210 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
71
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.208 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
70
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.208 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
211
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24040101 AND name = '_wp_page_template' LIMIT 1
0.208 ms 1 /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.208 ms 5 /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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.207 ms 2 /classes/Meta.php:193
95
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.207 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
130
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.207 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
141
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.207 ms 1 /classes/module/Module.php:2636
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 = "stores"
OR m.page = "stores"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.206 ms 1 /classes/Meta.php:193
62
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24040101 AND name = '_elementor_edit_mode' LIMIT 1
0.206 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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` = 2) LIMIT 1
0.205 ms 1 /src/Adapter/EntityMapper.php:71
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.204 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.204 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
190
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.203 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
200
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.200 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
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