Load Time 452.755 ms
Querying Time 55 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.852 ms 3.852 ms 3.15 Mb 3.1 Mb
__construct 0.776 ms 4.628 ms 0.02 Mb 3.8 Mb
init 10.912 ms 15.540 ms 1.33 Mb 4.6 Mb
checkAccess 0.001 ms 15.541 ms - Mb 4.6 Mb
setMedia 0.856 ms 16.397 ms 0.13 Mb 4.6 Mb
postProcess 0.001 ms 16.398 ms - Mb 4.6 Mb
initHeader 0.000 ms 16.398 ms - Mb 4.6 Mb
initContent 19.599 ms 35.997 ms 3.04 Mb 7.7 Mb
initFooter 0.001 ms 35.998 ms - Mb 7.7 Mb
display 416.757 ms 452.755 ms 33.40 Mb 41.4 Mb
Hook Time Memory Usage
CETemplate 493.059 ms 39.76 Mb
DisplayHeader 6.319 ms 1.30 Mb
OverrideLayoutTemplate 1.128 ms 0.06 Mb
displaySearch 0.704 ms 0.13 Mb
DisplayBeforeBodyClosingTag 0.446 ms 0.02 Mb
ProductSearchProvider 0.319 ms 0.01 Mb
ActionFrontControllerSetMedia 0.179 ms 0.01 Mb
ActionCreativeElementsInit 0.105 ms 0.05 Mb
ModuleRoutes 0.023 ms 0.01 Mb
ActionFrontControllerInitAfter 0.016 ms - Mb
10 hook(s) 502.298 ms 41.34 Mb
Module Time Memory Usage
pkcompare 1.105 ms - Mb
pklookbook 0.720 ms 0.06 Mb
pkfavorites 1.147 ms 0.06 Mb
ph_simpleblog 1.156 ms 0.26 Mb
creativeelements 498.260 ms 40.95 Mb
blockreassurance 0.210 ms 0.04 Mb
ps_emailsubscription 0.143 ms 0.03 Mb
ps_emailalerts 0.129 ms 0.04 Mb
pkelements 0.494 ms 0.09 Mb
pkcaptcha 0.058 ms 0.02 Mb
pkinstagram 0.120 ms 0.03 Mb
pk_menu 0.121 ms 0.13 Mb
pkpopup 0.055 ms 0.02 Mb
pkthemesettings 1.091 ms 0.15 Mb
ps_shoppingcart 0.119 ms 0.02 Mb
ps_searchbar 0.868 ms 0.15 Mb
pkfacebook 0.312 ms 0.03 Mb
productcomments 0.109 ms 0.09 Mb
revsliderprestashop 1.813 ms 0.86 Mb
pkfrontpanel 0.052 ms 0.02 Mb
ps_facetedsearch 0.746 ms 0.11 Mb
psgdpr 0.152 ms 0.11 Mb
ps_linklist 0.187 ms 0.02 Mb
23 module(s) 509.167 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`
2.403 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.681 ms 0 /classes/Hook.php:1292
61
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("b2239231ea5b7629ede53a41c0c6f6d7", "a:1:{s:7:\"filters\";a:0:{}}")
1.532 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
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.494 ms 544 /classes/Configuration.php:180
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.026 ms 979 /classes/Hook.php:1332
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>=27 AND c.nright<=28 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.952 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>=27 AND c.nright<=28 GROUP BY p.id_product) p
0.838 ms 378 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.637 ms 979 /classes/Hook.php:1292
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.575 ms 81 /classes/module/Module.php:345
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.545 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.522 ms 23 Yes /modules/creativeelements/includes/base/widget-category-base.php:170
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.481 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` = 22  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 22
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.454 ms 1 Yes Yes /classes/Category.php:921
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.438 ms 64 Yes /classes/Dispatcher.php:654
41
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 22
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.430 ms 1 Yes Yes /classes/Category.php:921
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.421 ms 81 /classes/module/Module.php:345
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.412 ms 1 Yes /classes/shop/Shop.php:1364
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.402 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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.401 ms 81 /classes/module/Module.php:345
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.391 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
197
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.374 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
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.371 ms 1 Yes /classes/shop/Shop.php:715
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.357 ms 81 /classes/module/Module.php:345
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.348 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
198
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_version' LIMIT 1
0.332 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
98
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.328 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
204
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.324 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
150
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.315 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
54
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 22
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.314 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
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.306 ms 1 /classes/Language.php:1216
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.299 ms 1 /classes/shop/Shop.php:218
144
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_page_settings' LIMIT 1
0.298 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
199
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.297 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
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` < 27) AND (a0.`nright` > 28) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.296 ms 25 Yes /classes/PrestaShopCollection.php:383
62
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 22040101 AND name = '_elementor_edit_mode' LIMIT 1
0.295 ms 1 /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` = 22) AND (b.`id_shop` = 1) LIMIT 1
0.292 ms 1 /src/Adapter/EntityMapper.php:71
71
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.290 ms 6 /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.286 ms 2 /classes/Meta.php:193
130
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.285 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
53
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.280 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
146
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.269 ms 1 /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.268 ms 1 /src/Adapter/EntityMapper.php:71
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.267 ms 2 /classes/Meta.php:193
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.263 ms 1 /classes/Language.php:1080
171
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 5 AND `id_shop` = 1
0.262 ms 1 /src/Adapter/EntityMapper.php:79
99
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.258 ms 1 /classes/module/Module.php:2636
137
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.256 ms 6 /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.256 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.255 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.254 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
202
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.253 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
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.252 ms 2 /classes/Meta.php:193
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.252 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
200
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.249 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
82
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.246 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.243 ms 5 /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.241 ms 1 Yes /classes/Language.php:1004
131
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.240 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 = 22
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.237 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.236 ms 2 /classes/Meta.php:193
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.232 ms 1 /classes/Meta.php:193
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.232 ms 1 /classes/Meta.php:193
110
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.231 ms 6 /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.231 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
201
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.230 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
94
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.230 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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` = 22) LIMIT 1
0.230 ms 1 /src/Adapter/EntityMapper.php:71
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.229 ms 1 /src/Adapter/EntityMapper.php:71
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.229 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.229 ms 2 /classes/Meta.php:193
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.227 ms 2 /classes/Meta.php:193
96
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
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.227 ms 2 /classes/Meta.php:193
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.225 ms 2 /classes/Meta.php:193
30
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.224 ms 1 /classes/Country.php:194
147
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.223 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.223 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
125
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.222 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.221 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.221 ms 1 Yes /classes/Currency.php:709
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.221 ms 1 /classes/Meta.php:193
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.221 ms 1 /src/Adapter/EntityMapper.php:71
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.220 ms 88 /classes/Hook.php:287
145
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.219 ms 6 /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.219 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.218 ms 1 /src/Adapter/EntityMapper.php:71
69
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.216 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
205
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_page_settings' LIMIT 1
0.216 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.215 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.213 ms 2 /classes/Meta.php:193
127
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 48) LIMIT 1
0.212 ms 1 /src/Adapter/EntityMapper.php:71
206
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.210 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
64
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 22040101 AND name = '_elementor_page_settings' LIMIT 1
0.209 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.208 ms 2 /classes/Meta.php:193
111
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.208 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.208 ms 88 /classes/Hook.php:339
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.207 ms 1 /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.207 ms 2 /classes/Meta.php:193
67
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.206 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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.205 ms 1 /classes/Meta.php:193
81
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.204 ms 1 /classes/module/Module.php:2636
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.204 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.203 ms 1 /classes/shop/Shop.php:1183
208
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_data' LIMIT 1
0.202 ms 4 /modules/creativeelements/classes/wrappers/Post.php:273
28
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.202 ms 1 /src/Adapter/EntityMapper.php:71
133
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_data' LIMIT 1
0.201 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
188
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.201 ms 1 /classes/Meta.php:193
108
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_css' LIMIT 1
0.201 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
194
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.200 ms 1 /classes/Meta.php:193
149
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.200 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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.199 ms 1 /src/Adapter/EntityMapper.php:71
136
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facetedsearch" LIMIT 1
0.199 ms 1 /classes/module/Module.php:2636
70
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.199 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
183
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.198 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
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.197 ms 1 /classes/Cart.php:4192
151
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 45 LIMIT 1
0.197 ms 1 /classes/Hook.php:244
91
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 38) LIMIT 1
0.196 ms 1 /src/Adapter/EntityMapper.php:71