Skip to main content

More sun exposure means longer lifespan and better mood

More sun exposure means longer lifespan and better moodFor decades, we’ve been told how dangerous the sun is and how important it is to protect ourselves. Now, a large British population study of more than half a million participants reveals that getting more sun exposure – even using tanning beds – is linked to fewer deaths from cardiovascular disease, cancer, and other things. The explanation lies in the UVB rays, which are the best way to get essential vitamin D, but only when the sun sits sufficiently high in the sky. It appears that all the sun awareness campaigns have done more harm than good, because it is vital to get enough sunlight, as long as we don’t get burned. The British study supports an earlier Swedish population study that revealed that lack of sun is every bit as harmful as smoking. People should take a vitamin D supplement during the winter period, and those who don’t get enough sun or who have difficulty with synthesizing vitamin D should supplement all year round.

The new British study is a prospective population study with more than half a million participants from England, Wales, and Scotland. It looked at the diet habits, lifestyle, and health of people recruited from the UK Biobank. The study revealed an inverse relation between exposure to UV radiation and the risk of dying early from cardiovascular disease, cancer, and other ailments. Apparently, sun exposure and UV radiation have a highly positive impact on health in northern-European regions like the UK and Scandinavia, primarily during the summer period where the sun sits high in the sky. The study also showed that people who used tanning beds had a lower risk of cardiovascular disease and cancer.
The study is published in Health & Place and supports an earlier Swedish population study where researchers monitored nearly 30,000 women aged 25-64 years for 20 years to find out more about their sun habits. The study, which is published in Journal of Internal Medicine, showed that women who got plenty of sun had a lower risk of dying of cardiovascular disease and generally lived longer than women who did not get out in the sun on a regular basis. The researchers even found that women who avoided the sun and did not smoke had the same life expectancy as the women who smoked and got out in the sun. Apparently, avoiding the sun is just as bad for you as smoking.

  • Excessive sunbathing, especially if you get burned, increases the risk of the dangerous type of skin cancer called melanoma
  • During the period between 2017-2019, melanoma only accounted for one percent of all cancer-related deaths
  • Sunbathing lowers the risk of several other cancer forms, cardiovascular disease and other diseases, and early death
  • The health benefits of regular sunbathing outweigh the disadvantages

The biological mechanisms that involve sunlight, health, mood, and sleep quality

In their introduction, the study authors describe the biological effect the sun’s UVA and UVB rays have on our health. UVB rays are necessary for our ability to synthesize vitamin D in our skin with help from a cholesterol precursor. Most cells in the body have vitamin D receptors (VDR). Vitamin D is viewed as a steroid hormone, and it controls a host of different gene activities. Numerous studies have shown that having higher blood levels of vitamin D (above 75 nmol/L) is linked to a lower risk of infections, circulatory diseases, cancer, and many other ailments.
The UVA rays in sunlight penetrate into the deeper skin layers. This increases the production of nitric oxide that has a blood pressure lowering effect. Nitric oxide can also inhibit chronic inflammation that is involved in type 2 diabetes, atherosclerosis, and most other chronic diseases. Newer studies show that the sun’s UVA rays protect against heart infarction and the risk of dying of COVID-19, independently of the UVB rays.
Also, sunlight affects our pineal gland, causing us to produce more serotonin during the day. This is good for our mood. When it gets dark outside, serotonin influences our melatonin synthesis, and this hormone helps us sleep. Melatonin also has other essential functions, and science is currently focusing on the prevention of cancer, Alzheimer’s disease, depression, and many other ailments. According to a previous review article published in Nutrients, vitamin D and melatonin appear to work as a hormonal team that is important for many essential processes.

  • At northern latitudes, we are only able to synthesize vitamin D during the summer period where the sun sits high in the sky
  • It is impossible to produce too much vitamin D through dermal synthesis (the natural vitamin D production in the skin)
  • Dark skin, sunscreen use, ageing, type 2 diabetes, and having a high BMI impairs the body’s absorption and utilization of vitamin D
  • People living at northern latitudes are advised to take vitamin D during the winter period. Those who don’t get enough sun exposure of have difficulty with synthesizing vitamin D should take a supplement all year round.
  • The recommended vitamin D intake level is no guarantee of optimizing blood levels of the nutrient
  • Blood levels of vitamin D should ideally be above 75 nmol/L

References:

Andrew C. Stevenson et al. Higher ultraviolet light exposure is associated with lower mortality: An analysis of data from the UK biobank cohort study. Health & Place 2024

Lindquist PG, Epstein E, Nielsen K et al. Avoidance of sun exposure as a risk factor for major causes of death: a competing risk analysis of the melanoma in Southern Sweden cohort. Journal of Internal Medicine. 2016

Deanna M. Minich et al. Is Melatonin the ”Next Vitamin D”?: A review of Emerging Science, Clinical Uses, Safety, and Dietary Supplements. Nutrients 2022

 



  • Created on .
9.314MBMemory Usage717msRequest Duration
Joomla! Version4.4.4
PHP Version8.3.6
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.40-0ubuntu0.24.04.1
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:46 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1738539781 "last" => 1738539781...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.41KB) (6.16ms)
  • afterInitialise (1.27MB) (43.15ms)
  • afterRoute (897.2KB) (20.41ms)
  • beforeRenderComponent com_content (22.58KB) (246μs)
  • Before Access::preloadComponents (all components) (33.23KB) (5.27ms)
  • After Access::preloadComponents (all components) (97.34KB) (631μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (15.8ms)
  • Before Access::getAssetRules (id:8798 name:com_content.article.4600) (130.65KB) (91μs)
  • After Access::getAssetRules (id:8798 name:com_content.article.4600) (7.38KB) (49μs)
  • beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.35MB) (79.21ms)
  • afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (558.52KB) (70.37ms)
  • beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (7μs)
  • afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (135μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (392B) (42μs)
  • afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (170μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (5.07KB) (30μs)
  • afterRenderComponent com_content (39.83KB) (57.48ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.78KB) (4.24ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (32μs)
  • afterDispatch (27.46KB) (4.16ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (477μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (71.27KB) (173ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (26μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (41μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (13μs)
  • afterRenderRawModule mod_tags_popular (Search) (23.93KB) (192ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (29μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (43μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (12μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (8.9ms)
  • afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (258μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (20μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (28μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (1.27KB) (22μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (10μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (21μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (20μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (663μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (190.66KB) (5.38ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (63μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (90.37KB) (6.56ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (18μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (9μs)
  • afterRenderRawModule mod_finder () (64.95KB) (5.87ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (33μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (143μs)
  • afterRenderRawModule mod_custom () (21.95KB) (1.77ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (54μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (104μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (760μs)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (45μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (4.86ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (38μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (12μs)
  • afterRenderRawModule mod_finder () (6.29KB) (559μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.23KB) (471μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (220μs)
  • afterRenderRawModule mod_custom () (944B) (137μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (29μs)
  • beforeRenderRawModule mod_custom () (688B) (85μs)
  • afterRenderRawModule mod_custom () (896B) (110μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (121μs)
  • afterRender (194.31KB) (5.97ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (23.93KB) (26.73%)
    191.64ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (71.27KB) (24.12%)
    172.91ms
    1 x beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.35MB) (11.05%)
    79.21ms
    1 x afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (558.52KB) (9.82%)
    70.37ms
    1 x afterRenderComponent com_content (39.83KB) (8.02%)
    57.48ms
    1 x afterInitialise (1.27MB) (6.02%)
    43.15ms
    1 x afterRoute (897.2KB) (2.85%)
    20.41ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (2.2%)
    15.80ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.24%)
    8.90ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (90.37KB) (0.92%)
    6.56ms
    1 x afterLoad (456.41KB) (0.86%)
    6.16ms
    1 x afterRender (194.31KB) (0.83%)
    5.97ms
    1 x afterRenderRawModule mod_finder () (64.95KB) (0.82%)
    5.87ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (190.66KB) (0.75%)
    5.38ms
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.73%)
    5.27ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.68%)
    4.86ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.78KB) (0.59%)
    4.24ms
    1 x afterDispatch (27.46KB) (0.58%)
    4.16ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.25%)
    1.77ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.11%)
    760μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (0.09%)
    663μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.09%)
    631μs
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.08%)
    559μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.07%)
    477μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.07%)
    471μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (0.04%)
    258μs
    1 x beforeRenderComponent com_content (22.58KB) (0.03%)
    246μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    220μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (0.02%)
    170μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.02%)
    143μs
    1 x afterRenderRawModule mod_custom () (944B) (0.02%)
    137μs
    1 x afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (0.02%)
    135μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.02%)
    121μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    110μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.01%)
    104μs
    1 x Before Access::getAssetRules (id:8798 name:com_content.article.4600) (130.65KB) (0.01%)
    91μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    85μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    63μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    54μs
    1 x After Access::getAssetRules (id:8798 name:com_content.article.4600) (7.38KB) (0.01%)
    49μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    45μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    43μs
    1 x beforeRenderRawModule mod_custom (Search for more information...) (392B) (0.01%)
    42μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    41μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    38μs
    1 x afterRenderModule mod_finder () (3.29KB) (0%)
    33μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    32μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.07KB) (0%)
    30μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    29μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    29μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    28μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0%)
    26μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    23μs
    1 x afterRenderModule mod_tags_popular (Search) (1.27KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    21μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    9μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (0%)
    7μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    3μs
76 statements were executed, 39 of which were duplicates, 37 unique512ms1.22MB
  • SELECT @@SESSION.sql_mode;139μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?184μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1121μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.3ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `has_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1693μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`434μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `has_usergroups` AS `a` LEFT JOIN `has_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest167μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `has_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`584μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC158μs2.33KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `has_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1128μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config4.55ms1.06KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `has_menu` AS `m` LEFT JOIN `has_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.78ms165.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`873μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `has_template_styles` AS `s` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 12.67ms848B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)394μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 09.02ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`4.5ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '4600'970μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)351μs22.19KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`494μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)7.01ms4.11KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`552μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id LEFT JOIN `has_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC2.52ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id104μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id968μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `has_modules` AS `m` LEFT JOIN `has_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`3.19ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `t`.`id` FROM `has_tags` AS `t` INNER JOIN `has_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)17.97ms1.4KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,COUNT( `tag_id`) AS `count`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `cc` ON `m`.`core_content_id` = `cc`.`core_content_id` INNER JOIN `has_content_types` AS `ct` ON `m`.`type_alias` = `ct`.`type_alias` WHERE ( ( ( (`m`.`tag_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray8,:preparedArray9) OR `cc`.`core_access` = 0)) AND (`m`.`content_item_id` <> :currentId OR `m`.`type_alias` <> :prefix)) AND (`cc`.`core_publish_up` IS NULL OR `cc`.`core_publish_up` = :nullDateUp OR `cc`.`core_publish_up` <= :nowDateUp)) AND (`cc`.`core_publish_down` IS NULL OR `cc`.`core_publish_down` = :nullDateDown OR `cc`.`core_publish_down` >= :nowDateDown) AND `cc`.`core_language` IN (:preparedArray10,:preparedArray11) GROUP BY `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` ORDER BY `count` DESC, RAND() LIMIT 1520.12ms20.66KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:200Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`322μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id107μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id74μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id64μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id59μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id73μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id54μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id56μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id69μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id54μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id50μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id103μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.03ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.45ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id94μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id78μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id74μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id59μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id51μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id60μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id51μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.23ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id57μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id90μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id69μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id55μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id57μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id52μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id70μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.05ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC50.06ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 12.14ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0359μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id120μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id87μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-02 23:43:01') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-02 23:43:01') AND c2.state = 12.7ms12.47KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 10170ms167.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray5,:preparedArray6) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 15188ms2.75KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id711μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1242μs640B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)1.23ms584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC298μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)164μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `has_scheduler_tasks` AS `a` WHERE `a`.`state` = 1114μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`533μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?108μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.11ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy