Load Time 471.963 ms
Querying Time 70 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.802 ms 6.802 ms 3.15 Mb 3.1 Mb
__construct 1.311 ms 8.113 ms 0.02 Mb 3.8 Mb
init 21.580 ms 29.693 ms 1.33 Mb 4.6 Mb
checkAccess 0.002 ms 29.695 ms - Mb 4.6 Mb
setMedia 1.765 ms 31.460 ms 0.13 Mb 4.6 Mb
postProcess 0.001 ms 31.461 ms - Mb 4.6 Mb
initHeader 0.046 ms 31.507 ms - Mb 4.6 Mb
initContent 35.196 ms 66.703 ms 3.04 Mb 7.7 Mb
initFooter 0.035 ms 66.738 ms - Mb 7.7 Mb
display 405.225 ms 471.963 ms 33.41 Mb 41.4 Mb
Hook Time Memory Usage
CETemplate 482.325 ms 39.77 Mb
DisplayHeader 12.400 ms 1.30 Mb
OverrideLayoutTemplate 1.325 ms 0.06 Mb
displaySearch 0.721 ms 0.12 Mb
ProductSearchProvider 0.442 ms 0.01 Mb
ActionFrontControllerSetMedia 0.425 ms 0.01 Mb
DisplayBeforeBodyClosingTag 0.409 ms 0.02 Mb
ActionCreativeElementsInit 0.193 ms 0.05 Mb
ModuleRoutes 0.043 ms 0.01 Mb
ActionFrontControllerInitAfter 0.020 ms - Mb
10 hook(s) 498.303 ms 41.34 Mb
Module Time Memory Usage
pkcompare 2.326 ms - Mb
pklookbook 1.208 ms 0.06 Mb
pkfavorites 1.899 ms 0.06 Mb
ph_simpleblog 2.072 ms 0.26 Mb
creativeelements 492.194 ms 40.95 Mb
blockreassurance 0.568 ms 0.04 Mb
ps_emailsubscription 0.228 ms 0.03 Mb
ps_emailalerts 0.240 ms 0.04 Mb
pkelements 0.830 ms 0.09 Mb
pkcaptcha 0.114 ms 0.02 Mb
pkinstagram 0.176 ms 0.03 Mb
pk_menu 0.301 ms 0.13 Mb
pkpopup 0.105 ms 0.02 Mb
pkthemesettings 1.834 ms 0.15 Mb
ps_shoppingcart 0.181 ms 0.02 Mb
ps_searchbar 1.000 ms 0.15 Mb
pkfacebook 0.429 ms 0.03 Mb
productcomments 0.210 ms 0.09 Mb
revsliderprestashop 3.278 ms 0.86 Mb
pkfrontpanel 0.132 ms 0.02 Mb
ps_facetedsearch 0.977 ms 0.11 Mb
psgdpr 0.151 ms 0.11 Mb
ps_linklist 0.181 ms 0.02 Mb
23 module(s) 510.635 ms 43.21 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`
4.036 ms 964 Yes Yes /classes/Hook.php:1233
61
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("f0921fb66fdfbe298d86992c7da3e286", "a:1:{s:7:\"filters\";a:0:{}}")
1.857 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
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.679 ms 0 /classes/Hook.php:1292
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.561 ms 979 /classes/Hook.php:1332
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.524 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>=36 AND c.nright<=37 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.398 ms 1134 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
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>=36 AND c.nright<=37 GROUP BY p.id_product) p
1.272 ms 378 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
1.238 ms 979 /classes/Hook.php:1292
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
1.085 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` < 36) AND (a0.`nright` > 37) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.954 ms 25 Yes /classes/PrestaShopCollection.php:383
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.856 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` = 26
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.832 ms 1 Yes Yes /classes/Category.php:921
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.728 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.696 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.671 ms 64 Yes /classes/Dispatcher.php:654
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.666 ms 1 /classes/Language.php:1216
53
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.631 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
54
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 26
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.631 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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.546 ms 1 Yes /classes/shop/Shop.php:1364
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.540 ms 1 /classes/Cart.php:4192
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.536 ms 25 Yes /classes/Category.php:626
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.532 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.521 ms 81 /classes/module/Module.php:345
45
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.514 ms 8 Yes /classes/ImageType.php:109
38
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.508 ms 1 /classes/module/Module.php:2018
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.501 ms 1 /src/Adapter/EntityMapper.php:71
36
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.485 ms 1 /src/Adapter/EntityMapper.php:79
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.482 ms 1 /src/Adapter/EntityMapper.php:71
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.470 ms 88 /classes/Hook.php:339
43
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.457 ms 0 /classes/module/Module.php:2636
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.456 ms 1 /classes/shop/ShopUrl.php:182
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.453 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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` <= 7
AND nleft >= 17 AND nright <= 38
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.448 ms 23 Yes /modules/creativeelements/includes/base/widget-category-base.php:170
47
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
0.446 ms 1 /classes/Country.php:402
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.433 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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.432 ms 1 /src/Adapter/EntityMapper.php:71
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.420 ms 1 /src/Adapter/EntityMapper.php:71
30
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.420 ms 1 /classes/Country.php:194
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` = 26) AND (b.`id_shop` = 1) LIMIT 1
0.419 ms 1 /src/Adapter/EntityMapper.php:71
29
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.404 ms 1 /classes/Language.php:883
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.404 ms 1 Yes /classes/Currency.php:709
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` = 26) LIMIT 1
0.397 ms 1 /src/Adapter/EntityMapper.php:71
46
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
0.396 ms 1 /classes/AddressFormat.php:656
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.395 ms 88 /classes/Hook.php:287
40
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 26 AND ctg.`id_group` = 1 LIMIT 1
0.393 ms 1 /classes/Category.php:1751
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.378 ms 1 Yes /classes/shop/Shop.php:715
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.376 ms 1 Yes /classes/Language.php:1004
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.375 ms 1 /src/Adapter/EntityMapper.php:71
49
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
0.375 ms 1 /src/Adapter/EntityMapper.php:79
44
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.372 ms 0 /classes/module/Module.php:2109
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.368 ms 1 /classes/shop/Shop.php:1183
26
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.360 ms 1 /classes/Language.php:883
34
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.359 ms 1 /classes/ObjectModel.php:1729
33
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
0.352 ms 1 /src/Adapter/EntityMapper.php:79
37
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.349 ms 1 /classes/ObjectModel.php:1729
9
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.346 ms 1 /classes/ObjectModel.php:1729
204
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.345 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
52
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.341 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
50
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.333 ms 1 /classes/ObjectModel.php:1592
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` = 26  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 26
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.333 ms 1 Yes Yes /classes/Category.php:921
27
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.316 ms 1 /classes/Currency.php:893
67
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.308 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
66
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 25) LIMIT 1
0.306 ms 1 /src/Adapter/EntityMapper.php:71
62
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 26040101 AND name = '_elementor_edit_mode' LIMIT 1
0.304 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.303 ms 1 /classes/module/Module.php:2636
98
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.288 ms 5 /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.282 ms 2 /classes/Meta.php:193
106
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_page_settings' LIMIT 1
0.279 ms 1 /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.277 ms 2 /classes/Meta.php:193
64
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 26040101 AND name = '_elementor_page_settings' LIMIT 1
0.276 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 = 26
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.269 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
81
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.269 ms 1 /classes/module/Module.php:2636
56
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1
0.267 ms 1 /src/Adapter/EntityMapper.php:79
69
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.265 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.264 ms 5 /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.257 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
136
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facetedsearch" LIMIT 1
0.257 ms 1 /classes/module/Module.php:2636
210
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 26040101 AND name = '_elementor_page_settings' LIMIT 1
0.251 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
213
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = '_u_elementor_preferences' LIMIT 1
0.248 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.247 ms 1 /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.247 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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.247 ms 1 /src/Adapter/EntityMapper.php:71
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.242 ms 2 /classes/Meta.php:193
198
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_version' LIMIT 1
0.242 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
71
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
65
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 26040101 AND name = '_wp_page_template' LIMIT 1
0.236 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
63
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 26040101 AND name = '_wp_page_template' LIMIT 1
0.236 ms 1 /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.235 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
82
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.235 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.234 ms 6 /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.233 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
111
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.233 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
150
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.232 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
72
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.229 ms 8 /classes/ImageType.php:161
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.229 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
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.229 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
207
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.224 ms 1 /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.223 ms 1 /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.222 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.221 ms 1 /classes/Meta.php:193
205
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_page_settings' LIMIT 1
0.219 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
206
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.218 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.217 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.216 ms 1 /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.216 ms 1 /classes/Meta.php:193
146
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
130
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.213 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.213 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.213 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
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.211 ms 1 /classes/shop/Shop.php:218
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.209 ms 2 /classes/Meta.php:193
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.208 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.208 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
131
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
107
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.208 ms 6 /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.207 ms 2 /classes/Meta.php:193
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.206 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.205 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
125
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.205 ms 6 /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.204 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
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.204 ms 1 /classes/Language.php:1080
137
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.203 ms 6 /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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.202 ms 2 /classes/Meta.php:193
101
SELECT SQL_NO_CACHE mr.*
FROM ps_pk_menu_row_shop mr
WHERE mr.`id_shop` = 1 AND mr.id_pkmenu = 3 AND mr.`active` = 1
0.202 ms 1 /modules/pk_menu/pk_menu.php:1110
119
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.202 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
203
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 54) LIMIT 1
0.199 ms 1 /src/Adapter/EntityMapper.php:71
208
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_data' LIMIT 1
0.198 ms 4 /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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.196 ms 2 /classes/Meta.php:193
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.196 ms 2 /classes/Meta.php:193
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.196 ms 1 /src/Adapter/EntityMapper.php:71
201
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.194 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
109
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_version' LIMIT 1
0.193 ms 6 /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
211
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 26040101 AND name = '_wp_page_template' LIMIT 1
0.190 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
149
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.190 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
7
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.189 ms 1 /src/Adapter/EntityMapper.php:71
212
SELECT SQL_NO_CACHE id_ce_revision FROM ps_ce_revision WHERE parent = 26040101 AND active = 0 AND id_employee = 0 LIMIT 1
0.188 ms 1 /modules/creativeelements/classes/wrappers/Post.php:510
199
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.187 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
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.187 ms 2 /classes/Meta.php:193
100
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.187 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
59
SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="f0921fb66fdfbe298d86992c7da3e286" LIMIT 1
0.187 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
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.186 ms 1 /src/Adapter/EntityMapper.php:71