Load Time 527.184 ms
Querying Time 91 ms
Queries 242
Memory Peak Usage 44.2 Mb
Included Files 1252 files - 14.58 Mb
PrestaShop Cache - Mb
Global vars 0.84 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.821 ms 6.821 ms 3.15 Mb 3.1 Mb
__construct 1.551 ms 8.372 ms 0.02 Mb 3.8 Mb
init 20.371 ms 28.743 ms 1.33 Mb 4.6 Mb
checkAccess 0.002 ms 28.745 ms - Mb 4.6 Mb
setMedia 1.494 ms 30.239 ms 0.13 Mb 4.6 Mb
postProcess 0.001 ms 30.240 ms - Mb 4.6 Mb
initHeader 0.001 ms 30.241 ms - Mb 4.6 Mb
initContent 64.195 ms 94.436 ms 4.32 Mb 9.0 Mb
initFooter 0.002 ms 94.438 ms - Mb 9.0 Mb
display 432.746 ms 527.184 ms 34.85 Mb 44.2 Mb
Hook Time Memory Usage
CETemplate 503.232 ms 41.17 Mb
DisplayHeader 11.868 ms 1.30 Mb
displayProductListReviews 6.446 ms 0.98 Mb
OverrideLayoutTemplate 2.178 ms 0.04 Mb
DisplayProductListTop 1.001 ms 0.01 Mb
DisplayProductButton 0.555 ms 0.09 Mb
DisplayBeforeBodyClosingTag 0.436 ms 0.08 Mb
ProductSearchProvider 0.356 ms 0.01 Mb
ActionFrontControllerSetMedia 0.330 ms 0.01 Mb
ActionCreativeElementsInit 0.187 ms 0.05 Mb
ModuleRoutes 0.061 ms 0.01 Mb
ActionFrontControllerInitAfter 0.018 ms - Mb
DisplayProductListReviews 0.002 ms - Mb
DisplayProductButtonFixed 0.001 ms - Mb
14 hook(s) 526.670 ms 43.75 Mb
Module Time Memory Usage
pkcompare 2.305 ms - Mb
pklookbook 1.165 ms 0.06 Mb
pkfavorites 2.181 ms 0.15 Mb
ph_simpleblog 2.356 ms 0.26 Mb
creativeelements 513.331 ms 42.34 Mb
blockreassurance 0.392 ms 0.04 Mb
ps_emailsubscription 0.221 ms 0.03 Mb
ps_emailalerts 0.224 ms 0.04 Mb
pkelements 0.810 ms 0.09 Mb
pkcaptcha 0.108 ms 0.02 Mb
pkinstagram 0.176 ms 0.03 Mb
pk_menu 0.217 ms 0.13 Mb
pkpopup 0.168 ms 0.08 Mb
pkthemesettings 2.743 ms 0.16 Mb
ps_shoppingcart 0.194 ms 0.02 Mb
ps_searchbar 0.354 ms 0.02 Mb
pkfacebook 0.476 ms 0.03 Mb
productcomments 6.660 ms 1.08 Mb
revsliderprestashop 3.047 ms 0.86 Mb
pkfrontpanel 0.101 ms 0.02 Mb
ps_facetedsearch 0.895 ms 0.11 Mb
psgdpr 0.154 ms 0.05 Mb
ps_linklist 0.167 ms 0.02 Mb
23 module(s) 538.445 ms 45.55 Mb

Stopwatch SQL - 242 queries

# Query Time (ms) Rows Filesort Group By Location
72
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
4.253 ms 0 /classes/Hook.php:1292
61
REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("e5bb2616acf5ec304c0165d3191f076f", "a:1:{s:7:\"filters\";a:0:{}}")
3.798 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`
3.427 ms 964 Yes Yes /classes/Hook.php:1233
73
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.266 ms 335 /classes/Hook.php:456
2
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.850 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>=49 AND c.nright<=50 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.640 ms 72 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.493 ms 979 /classes/Hook.php:1332
58
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=49 AND c.nright<=50 GROUP BY p.id_product) p
1.388 ms 24 /modules/ps_facetedsearch/src/Adapter/MySQL.php:86
16
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
1.132 ms 979 /classes/Hook.php:1292
62
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-01 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (20)
1.096 ms 1 /classes/ProductAssembler.php:95
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.902 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.884 ms 1 Yes /classes/shop/Shop.php:1364
81
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 20 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.857 ms 0 /classes/Cart.php:1410
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.814 ms 64 Yes /classes/Dispatcher.php:654
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.783 ms 81 /classes/module/Module.php:345
1
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.738 ms 1 Yes /classes/shop/Shop.php:715
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` = 16
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.736 ms 1 Yes Yes /classes/Category.php:921
66
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20) AND (b.`id_shop` = 1) LIMIT 1
0.719 ms 1 /src/Adapter/EntityMapper.php:71
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.710 ms 81 /classes/module/Module.php:345
20
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.677 ms 81 /classes/module/Module.php:345
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.677 ms 81 /classes/module/Module.php:345
74
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.656 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
82
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20
ORDER BY f.position ASC
0.648 ms 1 Yes /classes/Product.php:5993
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.607 ms 1 /classes/Language.php:1216
51
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 49) AND (a0.`nright` > 50) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.592 ms 25 Yes /classes/PrestaShopCollection.php:383
70
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 20)
0.575 ms 1 /classes/Product.php:3857
54
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 16
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.560 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
63
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 20
AND image_shop.`cover` = 1 LIMIT 1
0.547 ms 4 /classes/Product.php:3570
164
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` <= 6
AND nleft >= 2 AND nright <= 51
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.544 ms 23 Yes /modules/creativeelements/includes/base/widget-category-base.php:170
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` = 16) AND (b.`id_shop` = 1) LIMIT 1
0.517 ms 1 /src/Adapter/EntityMapper.php:71
83
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 20
ORDER BY `position`
0.515 ms 4 Yes /classes/Product.php:3545
92
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_page_settings' LIMIT 1
0.504 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.503 ms 1 /src/Adapter/EntityMapper.php:71
121
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.499 ms 25 Yes /classes/Category.php:626
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.498 ms 1 /classes/Cart.php:4192
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.496 ms 1 /src/Adapter/EntityMapper.php:71
53
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
0.491 ms 11 /modules/revsliderprestashop/includes/revslider_db.class.php:214
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.478 ms 1 /src/Adapter/EntityMapper.php:71
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.477 ms 1 /classes/shop/Shop.php:218
95
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.475 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
21
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.475 ms 1 /classes/shop/Shop.php:1183
45
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.469 ms 8 Yes /classes/ImageType.php:109
60
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 16
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.458 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
67
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 1
AND `active` = 1 LIMIT 1
0.449 ms 1 /classes/Manufacturer.php:316
93
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.448 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
94
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_css' LIMIT 1
0.444 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
68
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
0.444 ms 1 /classes/SpecificPrice.php:426
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` = 16) LIMIT 1
0.439 ms 1 /src/Adapter/EntityMapper.php:71
77
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.427 ms 0 /classes/tax/TaxRulesTaxManager.php:109
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.414 ms 1 /src/Adapter/EntityMapper.php:71
89
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 16040101 AND name = '_elementor_page_settings' LIMIT 1
0.414 ms 1 /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.412 ms 1 /classes/Language.php:1080
165
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (20) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.411 ms 1 Yes Yes /classes/Product.php:4504
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.410 ms 1 /src/Adapter/EntityMapper.php:71
40
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 16 AND ctg.`id_group` = 1 LIMIT 1
0.404 ms 1 /classes/Category.php:1751
136
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.403 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.400 ms 1 /src/Adapter/EntityMapper.php:71
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.396 ms 1 Yes /classes/Language.php:1004
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.390 ms 1 /src/Adapter/EntityMapper.php:71
96
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.388 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
107
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.386 ms 4 Yes /modules/pk_menu/classes/PkMenuClass.php:198
90
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 16040101 AND name = '_wp_page_template' LIMIT 1
0.384 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
56
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1
0.381 ms 1 /src/Adapter/EntityMapper.php:79
162
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` = 16  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 16
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.380 ms 1 Yes Yes /classes/Category.php:921
91
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 25) LIMIT 1
0.380 ms 1 /src/Adapter/EntityMapper.php:71
43
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.380 ms 0 /classes/module/Module.php:2636
87
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 16040101 AND name = '_elementor_edit_mode' LIMIT 1
0.379 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
15
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.374 ms 88 /classes/Hook.php:287
25
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.373 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.373 ms 1 /classes/shop/ShopUrl.php:182
122
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
49
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
0.361 ms 1 /src/Adapter/EntityMapper.php:79
38
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.358 ms 1 /classes/module/Module.php:2018
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.356 ms 1 /src/Adapter/EntityMapper.php:71
97
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1
0.355 ms 1 /classes/module/Module.php:2636
18
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.355 ms 88 /classes/Hook.php:339
30
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.354 ms 1 /classes/Country.php:194
88
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 16040101 AND name = '_wp_page_template' LIMIT 1
0.349 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
59
SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="e5bb2616acf5ec304c0165d3191f076f" LIMIT 1
0.348 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
69
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 20 LIMIT 1
0.347 ms 1 /classes/SpecificPrice.php:435
52
SELECT SQL_NO_CACHE * FROM `ps_ce_icon_set`
0.344 ms 1 /modules/creativeelements/classes/CEIconSet.php:69
78
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 20 LIMIT 1
0.343 ms 1 /classes/Pack.php:89
33
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
0.342 ms 1 /src/Adapter/EntityMapper.php:79
9
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.333 ms 1 /classes/ObjectModel.php:1729
46
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
0.330 ms 1 /classes/AddressFormat.php:656
230
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_wp_page_template' LIMIT 1
0.329 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
71
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 20 AND id_shop=1 LIMIT 1
0.329 ms 1 /classes/Product.php:6848
64
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
0.326 ms 1 /classes/Category.php:1375
50
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.326 ms 1 /classes/ObjectModel.php:1592
34
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.322 ms 1 /classes/ObjectModel.php:1729
80
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.321 ms 1 /classes/stock/StockAvailable.php:453
36
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.319 ms 1 /src/Adapter/EntityMapper.php:79
7
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.318 ms 1 /src/Adapter/EntityMapper.php:71
85
SELECT SQL_NO_CACHE state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
0.317 ms 1 /classes/FeatureFlag.php:105
65
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 2 LIMIT 1
0.315 ms 1 /classes/Product.php:5639
47
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
0.312 ms 1 /classes/Country.php:402
27
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.306 ms 1 /classes/Currency.php:893
44
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.305 ms 0 /classes/module/Module.php:2109
84
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 20
0.305 ms 1 /classes/Product.php:2902
37
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.304 ms 1 /classes/ObjectModel.php:1729
26
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.302 ms 1 /classes/Language.php:883
75
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20 AND `id_group` = 1 LIMIT 1
0.298 ms 0 /classes/GroupReduction.php:156
29
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
0.297 ms 1 /classes/Language.php:883
98
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 4 AND `id_shop` = 1 LIMIT 1
0.296 ms 1 /classes/module/Module.php:2109
79
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 20 LIMIT 1
0.292 ms 1 /classes/Pack.php:90
86
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.288 ms 8 /classes/ImageType.php:161
130
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_page_settings' LIMIT 1
0.277 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
76
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.263 ms 1 /classes/Group.php:154
177
SELECT SQL_NO_CACHE `id_hook` FROM ps_link_block
0.260 ms 2 /modules/pkelements/classes/WidgetPklinks.php:468
106
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.259 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
116
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_page_settings' LIMIT 1
0.257 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
228
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 19 LIMIT 1
0.256 ms 1 /modules/psgdpr/classes/GDPRConsent.php:132
134
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_data' LIMIT 1
0.244 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
167
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 1) LIMIT 1
0.240 ms 1 /src/Adapter/EntityMapper.php:71
137
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.238 ms 1 /classes/Meta.php:193
154
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.237 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
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 = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.237 ms 2 /classes/Meta.php:193
224
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_version' LIMIT 1
0.232 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
163
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` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.230 ms 1 /src/Adapter/EntityMapper.php:71
142
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.230 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
123
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
0.229 ms 1 /classes/module/Module.php:2636
179
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.227 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
171
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_page_settings' LIMIT 1
0.226 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
133
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_version' LIMIT 1
0.223 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
105
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pk_menu" LIMIT 1
0.223 ms 1 /classes/module/Module.php:2636
232
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.222 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_css' LIMIT 1
0.217 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
173
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.215 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
108
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.215 ms 1 /classes/Meta.php:193
152
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_page_settings' LIMIT 1
0.214 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
231
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_page_settings' LIMIT 1
0.214 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
239
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 0 AND name = '_u_elementor_preferences' LIMIT 1
0.214 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
149
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.212 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
170
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 24) LIMIT 1
0.212 ms 1 /src/Adapter/EntityMapper.php:71
236
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 16040101 AND name = '_elementor_page_settings' LIMIT 1
0.210 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
202
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
229
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 54) LIMIT 1
0.207 ms 1 /src/Adapter/EntityMapper.php:71
201
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.207 ms 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
161
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_version' LIMIT 1
0.207 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
119
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_css' LIMIT 1
0.204 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
172
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_data' LIMIT 1
0.203 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
131
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_data' LIMIT 1
0.202 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
117
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.202 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
212
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.200 ms 2 /classes/Meta.php:193
132
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_css' LIMIT 1
0.199 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
210
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.199 ms 2 /classes/Meta.php:193
217
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.199 ms 2 /classes/Meta.php:193
150
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 42010000 AND name = '_elementor_version' LIMIT 1
0.197 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 = "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
120
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 38010000 AND name = '_elementor_data' LIMIT 1
0.195 ms 5 /modules/creativeelements/classes/wrappers/Post.php:273
155
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_css' LIMIT 1
0.194 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
153
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 48010000 AND name = '_elementor_data' LIMIT 1
0.193 ms 6 /modules/creativeelements/classes/wrappers/Post.php:273
233
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 54010000 AND name = '_elementor_css' LIMIT 1
0.193 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
211
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.193 ms 2 /classes/Meta.php:193
199
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.192 ms 1 /classes/Meta.php:193
174
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 24010000 AND name = '_elementor_css' LIMIT 1
0.191 ms 1 /modules/creativeelements/classes/wrappers/Post.php:273
135
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 25010000 AND name = '_elementor_version' LIMIT 1
0.190 ms 6