Load Time 463.096 ms
Querying Time 55 ms
Queries 219
Memory Peak Usage 41.4 Mb
Included Files 1044 files - 13.28 Mb
PrestaShop Cache 0.87 Mb
Global vars 0.82 Mb
PrestaShop Version 8.1.2
PHP Version 7.4.3-4ubuntu2.19
MySQL Version 8.0.35-0ubuntu0.20.04.1
Memory Limit 128M
Max Execution Time 30s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 4.065 ms 4.065 ms 3.15 Mb 3.1 Mb
__construct 1.001 ms 5.066 ms 0.02 Mb 3.8 Mb
init 14.534 ms 19.600 ms 1.37 Mb 4.6 Mb
checkAccess 0.001 ms 19.601 ms - Mb 4.6 Mb
setMedia 1.030 ms 20.631 ms 0.13 Mb 4.7 Mb
postProcess 0.001 ms 20.632 ms - Mb 4.7 Mb
initHeader 0.000 ms 20.632 ms - Mb 4.7 Mb
initContent 26.647 ms 47.279 ms 3.05 Mb 7.8 Mb
initFooter 0.002 ms 47.281 ms - Mb 7.8 Mb
display 415.815 ms 463.096 ms 33.36 Mb 41.4 Mb
Hook Time Memory Usage
CETemplate 500.844 ms 39.73 Mb
DisplayHeader 7.600 ms 1.30 Mb
OverrideLayoutTemplate 1.232 ms 0.05 Mb
displaySearch 0.733 ms 0.13 Mb
DisplayBeforeBodyClosingTag 0.415 ms 0.02 Mb
ActionFrontControllerSetMedia 0.220 ms 0.01 Mb
ProductSearchProvider 0.210 ms 0.01 Mb
ActionCreativeElementsInit 0.121 ms 0.05 Mb
ModuleRoutes 0.037 ms 0.01 Mb
ActionFrontControllerInitAfter 0.013 ms - Mb
10 hook(s) 511.425 ms 41.30 Mb
Module Time Memory Usage
pkcompare 1.335 ms - Mb
pklookbook 0.692 ms 0.06 Mb
pkfavorites 1.066 ms 0.06 Mb
ph_simpleblog 1.300 ms 0.26 Mb
creativeelements 507.313 ms 40.91 Mb
blockreassurance 0.274 ms 0.04 Mb
ps_emailsubscription 0.133 ms 0.03 Mb
ps_emailalerts 0.153 ms 0.04 Mb
pkelements 0.532 ms 0.09 Mb
pkcaptcha 0.074 ms 0.02 Mb
pkinstagram 0.101 ms 0.03 Mb
pk_menu 0.145 ms 0.13 Mb
pkpopup 0.063 ms 0.02 Mb
pkthemesettings 1.214 ms 0.15 Mb
ps_shoppingcart 0.096 ms 0.02 Mb
ps_searchbar 0.890 ms 0.15 Mb
pkfacebook 0.287 ms 0.03 Mb
productcomments 0.125 ms 0.09 Mb
revsliderprestashop 1.746 ms 0.86 Mb
pkfrontpanel 0.081 ms 0.02 Mb
ps_facetedsearch 0.573 ms 0.11 Mb
psgdpr 0.172 ms 0.11 Mb
ps_linklist 0.206 ms 0.02 Mb
23 module(s) 518.572 ms 43.16 Mb

Stopwatch SQL - 219 queries

# Query Time (ms) Rows Filesort Group By Location
65
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("0a42d4fbcdbc6b583b663915747cf5cc", "a:1:{s:7:\"filters\";a:0:{}}")
2.449 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:211
14
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
1.949 ms 964 Yes Yes /classes/Hook.php:1233
155
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.568 ms 0 /classes/Hook.php:1292
2
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1.498 ms 544 /classes/Configuration.php:180
61
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>=26 AND c.nright<=35 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.041 ms 1134 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
62
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>=26 AND c.nright<=35 GROUP BY p.id_product) p
0.870 ms 378 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
0.812 ms 979 /classes/Hook.php:1332
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
0.635 ms 979 /classes/Hook.php:1292
101
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.603 ms 25 Yes /classes/Category.php:626
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` = 21
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.508 ms 23 Yes Yes /classes/Category.php:921
87
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.488 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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.477 ms 1 Yes /classes/shop/Shop.php:1364
142
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` = 21  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 21
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.469 ms 23 Yes Yes /classes/Category.php:921
143
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.449 ms 23 Yes /modules/creativeelements/includes/base/widget-category-base.php:170
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.435 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.403 ms 1 /classes/Language.php:1216
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.399 ms 81 /classes/module/Module.php:345
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.390 ms 81 /classes/module/Module.php:345
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.388 ms 81 /classes/module/Module.php:345
55
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 26) AND (a0.`nright` > 35) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.378 ms 25 Yes /classes/PrestaShopCollection.php:383
116
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.375 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
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.369 ms 81 /classes/module/Module.php:345
102
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.362 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
207
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.358 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
1
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.351 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.338 ms 81 /classes/module/Module.php:345
103
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.338 ms 1 /classes/module/Module.php:2636
122
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.330 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
97
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.307 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
117
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.307 ms 1 /classes/Meta.php:193
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` = 21) AND (b.`id_shop` = 1) LIMIT 1
0.297 ms 1 /src/Adapter/EntityMapper.php:71
85
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.297 ms 1 /classes/module/Module.php:2636
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 = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.282 ms 1 /classes/Meta.php:193
86
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.274 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
88
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.274 ms 1 /classes/Meta.php:193
71
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.274 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
153
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.270 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
74
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.269 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
58
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 21
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
123
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_version' LIMIT 1
0.265 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
73
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.264 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
68
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 21040101 AND name = '_elementor_page_settings' LIMIT 1
0.262 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
42
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) AND (b.`id_shop` = 1) LIMIT 1
0.258 ms 1 /src/Adapter/EntityMapper.php:71
76
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.257 ms 8 /classes/ImageType.php:161
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 = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.256 ms 2 /classes/Meta.php:193
96
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
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.254 ms 1 /src/Adapter/EntityMapper.php:71
132
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_page_settings' LIMIT 1
0.249 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
110
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_page_settings' LIMIT 1
0.246 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
57
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.246 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.244 ms 88 /classes/Hook.php:339
209
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.243 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
111
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.243 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
162
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.243 ms 2 /classes/Meta.php:193
46
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.242 ms 1 /classes/Cart.php:4192
208
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_page_settings' LIMIT 1
0.242 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
201
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
75
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.241 ms 6 /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 = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.238 ms 2 /classes/Meta.php:193
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.234 ms 1 /classes/shop/Shop.php:218
47
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.232 ms 0 /classes/module/Module.php:2636
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.232 ms 88 /classes/Hook.php:287
112
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_css' LIMIT 1
0.231 ms 1 /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.231 ms 1 /src/Adapter/EntityMapper.php:71
156
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.231 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
98
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.228 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
134
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.228 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
67
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 21040101 AND name = '_wp_page_template' LIMIT 1
0.227 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.226 ms 1 Yes /classes/Currency.php:709
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.226 ms 1 /classes/shop/ShopUrl.php:182
66
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 21040101 AND name = '_elementor_edit_mode' LIMIT 1
0.226 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
12
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.226 ms 1 Yes /classes/Language.php:1004
49
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.225 ms 8 Yes /classes/ImageType.php:109
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.224 ms 1 /classes/shop/Shop.php:1183
147
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_page_settings' LIMIT 1
0.222 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_css' LIMIT 1
0.221 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
114
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.220 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 = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.217 ms 2 /classes/Meta.php:193
180
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.217 ms 2 /classes/Meta.php:193
194
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.215 ms 2 /classes/Meta.php:193
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.215 ms 1 /src/Adapter/EntityMapper.php:71
150
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.212 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
210
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.211 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
43
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.207 ms 1 /src/Adapter/EntityMapper.php:71
64
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 21
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.207 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
190
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.207 ms 1 /classes/Meta.php:193
148
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.206 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.205 ms 1 /src/Adapter/EntityMapper.php:71
44
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) AND (b.`id_shop` = 1) LIMIT 1
0.205 ms 1 /src/Adapter/EntityMapper.php:71
216
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = '_u_elementor_preferences' LIMIT 1
0.204 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 = "stores"
OR m.page = "stores"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.204 ms 1 /classes/Meta.php:193
129
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.204 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
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 = "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
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 = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.201 ms 2 /classes/Meta.php:193
178
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps_link_block lb
INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 45 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
0.200 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
124
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.200 ms 0 /modules/ph_simpleblog/models/SimpleBlogCategory.php:442
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.200 ms 1 /classes/Language.php:1080
118
SELECT SQL_NO_CACHE mr.*
FROM ps_pk_menu_row_shop mr
WHERE mr.`id_shop` = 1 AND mr.id_pkmenu = 1 AND mr.`active` = 1
0.200 ms 1 /modules/pk_menu/pk_menu.php:1110
45
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) AND (b.`id_shop` = 1) LIMIT 1
0.199 ms 1 /src/Adapter/EntityMapper.php:71
206
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
120
SELECT SQL_NO_CACHE mr.*
FROM ps_pk_menu_row_shop mr
WHERE mr.`id_shop` = 1 AND mr.id_pkmenu = 2 AND mr.`active` = 1
0.198 ms 1 /modules/pk_menu/pk_menu.php:1110
163
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.198 ms 2 /classes/Meta.php:193
27
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.197 ms 1 /classes/Currency.php:893
157
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.197 ms 1 /src/Adapter/EntityMapper.php:71
72
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.195 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.195 ms 1 /src/Adapter/EntityMapper.php:71
211
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_data' LIMIT 1
0.194 ms 4 /modules/creativeelements/classes/wrappers/Post.php:273
99
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.193 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
105
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.193 ms 1 /modules/pk_menu/pk_menu.php:1110
213
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 21040101 AND name = '_elementor_page_settings' LIMIT 1
0.193 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.192 ms 1 /src/Adapter/EntityMapper.php:71
59
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` = 21) LIMIT 1
0.191 ms 1 /src/Adapter/EntityMapper.php:71
205
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.190 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
195
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.190 ms 2 /classes/Meta.php:193
70
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 25) LIMIT 1
0.189 ms 1 /src/Adapter/EntityMapper.php:71
141
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.189 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
113
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_version' LIMIT 1
0.189 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
164
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.188 ms 2 /classes/Meta.php:193
197
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.187 ms 1 /classes/Meta.php:193
131
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 48) LIMIT 1
0.187 ms 1 /src/Adapter/EntityMapper.php:71
175
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.187 ms 1 /classes/Meta.php:193
196
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.186 ms 2 /classes/Meta.php:193
60
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1
0.186 ms 1 /src/Adapter/EntityMapper.php:79
40
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 21 AND ctg.`id_group` = 1 LIMIT 1
0.186 ms 1 /classes/Category.php:1751
152
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.186 ms 6 /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 = "stores"
OR m.page = "stores"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.186 ms 1 /classes/Meta.php:193
193
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.185 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87