Skip to main content

Are vitamin D supplements able to protect against COVID-19 and other infections?

Are vitamin D supplements able to protect against COVID-19 and other infections?Lack of vitamin D is rather common and taking large quantities of the nutrient can not only protect against virus infections like COVID-19 but even counteract the life-threatening complications in those affected with the disease, according to a new, comprehensive, Irish report (TILDA) from Trinity College Dublin (University of Dublin in Ireland). The TILDA report supports many other published studies showing that the immune system is unable to function without vitamin D. The main focus in the battle against COVID-19 is hygiene, isolation, and delayed immunization with vaccines. However, it is also essential to bolster the immune defense, as this determines the difference between being able to ward off the infection, suffer mild symptoms only, or succumb. The scientists recommend that all adults take a high-dosed vitamin D supplement, especially older people, nursing home residents, chronically ill people, hospital patients, health professionals and other exposed groups. That way, we are better protected against future epidemics.

Sun exposure during the summer period is the primary way to get vitamin D, and it is no coincidence that virus infections like COVID-19 typically occur during the winter period and taper off when the weather gets warmer. Still, there are many people who suffer from chronic vitamin D deficiency for various reasons, which we will take a closer look at. Eamon Laird and Rose Anne Kelly, two researchers affiliated with Trinity College Dublin, recently published a comprehensive report called TILDA, in which they describe vitamin D’s essential role in the immune defense and explain how widespread vitamin D deficiency among older people and other vulnerable groups contribute to problems like COVID-19. The accompanying complications cause a lot of suffering, they place an enormous burden on intensive care units, the death toll rises, and there are huge socioeconomic costs that follow in the wake of disease and lockdown.

  • Health authorities recommend high-dosed vitamin D supplements to older people, pregnant women, nursing home residents, dark-skinned individuals, and people that fail to get enough sun exposure.
  • The problem is that there are no official vitamin D awareness campaigns or control measures to make sure that these exposed groups in society take their vitamin D supplements

Vitamin D activates the entire immune system

Vitamin D is primarily recognized for its role in bones and muscles but most cells in the body have vitamin D receptors that activate and control various genes and a host of different biochemical processes in the body. Vitamin D is essential for activation of the white blood cells that the immune system uses to attack microscopic enemies such as COVID-19. In our respiratory tract, we have a particularly large concentration of white blood cells that depend on vitamin D for being able to combat germs. Vitamin D also boosts certain antibiotic peptides in our lungs. If we lack vitamin D, the immune system remains passive. In other words, even if we have plenty of white blood cells they never go into action because they don’t receive the signals from their vitamin D receptors (VDR).

  • You probably won’t feel if you are vitamin D-deficient but your immune system most certainly will.
  • Lack of vitamin D causes a weak and derailed immune defense that increases your risk of infections and sequelae.

Vitamin D counteracts life-threatening inflammation and cytokine storm

Vitamin D inhibits the production of proinflammatory cytokines (e.g. interferon gamma and interleukin-6) that prevent the immune system from overreacting and causing tissue damage. According to the TILDA report that is based on a larger population study of people from 50 years of age and older, the ageing process changes the way our immune system reacts. What is often seen is low-grade inflammation, a characteristic trait of many chronic diseases like diabetes, asthma, and cancer. This chronic, low-grade inflammation makes patients more vulnerable.
When COVID-19 becomes complicated and life-threatening it is not due to the virus itself. It is because the immune defense sets in with a cytokine storm and hyperinflammation that cause acute respiratory distress syndrome (ARDS) and secondary damage to the cardiovascular system and other tissues. In other words, it is not COVID-19 that is the culprit, it is the overreactive immune defense that causes the weakest patients to succumb.
It is relevant to make a note of the fact that having adequate amounts of vitamin D in your blood helps protect against virus infections at the same time as counteracting the potentially harmful inflammatory processes that are seen with ageing and various chronic diseases and when influenza and COVID-19 become life-threatening.
According to a large meta-analysis of 25 studies with 10,933 participants from 15 different countries, vitamin D supplements help prevent colds (that are often caused by a different type of coronavirus), influenza, and acute respiratory tract infections such as bronchitis and pneumonia.
Vitamin D has a significant protective effect when taken on a daily basis or once a week in very large doss. The scientists behind the above-mentioned meta-analysis say that it is safe to take vitamin D and the nutrient is especially effective for protecting against virus and respiratory tract infections in people who are vitamin D-deficient to begin with.
A meta-analysis from 2019 with 21,000 participants from eight studies showed that participants with low blood levels of vitamin D were 64 percent more likely to contract pneumonia, which is a complication that is seen in connection with influenza. The scientists therefore say that having sufficient amounts of vitamin D in your blood may be an advantage for preventing COVID-19 and any complications in the respiratory tract or other places, in cases you catch the virus.

The TILDA report reveals widespread vitamin D deficiency

The TILDA report uses data from a population study called The Irish Longitudinal Study on Ageing. Since 2009, this study has followed 8,172 home-living people from the age of 50 years and older. The scientists have collected various types of information about the participants and their physical and mental health, genetic conditions, living conditions, diet habits, weight, smoking habits, exercise habits, and lung function. The participants’ use of vitamin D and other nutritional supplements was also registered. Blood levels of vitamin D were measured and divided into three categories: deficiency (less than 30 nmol/L), insufficiency (30-50 nmol/L) and sufficient (over 50 nmol/L). The results showed that:

  • Eight percent of all participants older than 55 lacked vitamin D during the summer period
  • Thirteen percent of all participants older than 55 years were vitamin D-deficient all year round
  • Twenty-seven percent of participants older than 70, who primarily stayed indoors, had deficiencies
  • Forty-seven percent of participants older than 85 years were deficient during the winter period

In Denmark, studies have revealed that around 50 percent of the population has minor vitamin D deficiency while around 15 percent of people are moderately vitamin D-deficient

Risk factors of deficiency and poor utilization of vitamin D

As mentioned earlier, the sun during the summer period is our main source of vitamin D. We synthesize the nutrient in our skin through conversion of a cholesterol precursor. We start by producing a vitamin D precursor that is activated in the body by the liver and kidneys. This activation requires the presence of magnesium-containing enzymes, which means that being magnesium-deficient can impair the body’s utilization of vitamin D. Ageing processes, being dark- skinned, using too much sun factor creme, being overweight, having diabetes, and using certain types of medicine such as cholesterol-lowering statins can also lower the body’s vitamin D status. Similarly, smoking and being physically inactive increases the risk of being vitamin D-deficient.
According to the TILDA report, those participants that suffered from chronic lung diseases (like bronchitis, asthma, and emphysema) had significantly lower vitamin D levels both during the summer and winter period. This widespread lack of vitamin D therefore contributes to making COVID-19 far more dangerous for senior citizens, dark-skinned individuals, overweight people, smokers, nursing home residents, and the chronically ill.

  • You can easily synthesize 20-100 micrograms of vitamin D if you are outdoors on a sunny summer’s day in light clothing
  • You may have difficulty with producing enough vitamin D if your skin is old and thin, if you have dark skin, if you are overweight, or if you have diabetes
  • Excess vitamin D is stored in the liver for later use
  • The body’s vitamin D stores are normally emptied more or less during the winter and spring

Scientists call for new health policy concerning vitamin D

According to the researchers behind the TILDA report, there is no official health policy for vitamin D in Ireland, and they refer to the United States and Canada where many foods are enriched with vitamin D. They also mention Finland where the vitamin D-enrichment of foods and a more systematic health policy concerning supplements helped lower vitamin D deficiency to a point where it affects less than one percent of the Finnish population.
In a new article that is published in Irish Medical Journal, the scientists recommend that adults take 20-50 micrograms of vitamin D every day to reap the same benefits. This is a very important recommendation while we await an effective vaccination. Taking high-dosed vitamin D supplements is also important to help protect us against new coronavirus strains. Dr. Declan Byrne from St. James Hospital and School of Medicine at the Trinity College in Dublin also mentions how important vitamin D supplementation is, especially for older Irish people, hospital patients, nursing home residents, and health professionals. The same goes for the normal, healthy population.
Blood levels of vitamin D should be at least 50 nmol/L, and levels of 75-120 nmol/L may be even better. In order to reach these levels, you need to take a daily vitamin D supplement from October to May. If you do not get enough sun during the summer period, you must take vitamin D all year round. The actual need for vitamin D depends on things like age, skin type, BMI, smoking habits, chronic illnesses like asthma and diabetes, and the use of cholesterol-lowering statins. According to the European Food Safety Authority (EFSA), the upper safe intake level for vitamin D is 100 micrograms daily.
Vitamin D is a lipid-soluble vitamin, which means that the best absorption and utilization of the nutrient is obtained with supplements where vitamin D is dispersed in oil. Also make sure to eat plenty of green, coarse foods that contain a lot of magnesium because different magnesium-dependent enzymes are needed to activate the form of the vitamin D that we get from sun exposure and from supplements.

  • An estimated one billion people worldwide have minor to moderate vitamin D deficiency
  • In order to limit the spread of current and future epidemics and control their severity, we must focus a lot on addressing the vitamin D topic

References:

Eamon Laird, Rose Anne Kenny. Vitamin D deficiency in Ireland – implications for COVID 19. Results from the Irish Longitudinal Study on Ageing (TILDA) April 2020

Will Chu. Could vitamin D play a role in coronavirus resistance? Research thinks so. NUTRA ingredients.com April 2020

William B. Grant et al. Evidence that Vitamin D Supplementation Could Reduce Risk of Influenza and Covid-19 Infections and Deaths. Nutrients 2020

William B. Grant. Vitamin D Supplementation Could Prevent and Treat Influenza, Coronavirus, and Pneumonia Infections. Nutrients 2020

D.M McCartney, D. G. Byrne. Optimisation of Vitamin D Status for Enhanced Immuno-protection Against Covid-19. Irish Medical Journal. 2020

Essen MR et al. Vitamin D controls T cell antigen receptor signaling and activation of human T cells. Nat Immunol 2010

University of Copenhagen. Vitamin D crucial to activating immune Defences. 2010

Qi Dai el al. Abstract CT093: Bimodal relationship between magnesium supplementation and vitamin D status and metabolism: Results from randomized trial. Cancer Research July 2018

https://www.sundhed.dk/sundhedsfaglig/laegehaandbogen/endokrinologi/tilstande-og-sygdomme/knoglevaev-og-vitamin-d/d-vitamin-mangel/

  • Created on .
8.902MBMemory Usage264msRequest 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" => 1738542056 "last" => 1738542056...
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-US" ]
  • afterLoad (456.63KB) (1.66ms)
  • afterInitialise (1.27MB) (23.38ms)
  • afterRoute (927.02KB) (12.46ms)
  • beforeRenderComponent com_content (24.37KB) (734μs)
  • Before Access::preloadComponents (all components) (35.84KB) (1.28ms)
  • After Access::preloadComponents (all components) (97.34KB) (1.97ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (20μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (17.01ms)
  • Before Access::getAssetRules (id:5167 name:com_content.article.2548) (130.65KB) (175μs)
  • After Access::getAssetRules (id:5167 name:com_content.article.2548) (7.38KB) (59μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (40.07ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (289μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (6μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (97μs)
  • afterRenderComponent com_content (76.21KB) (25.25ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.15KB) (4.1ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (26μs)
  • afterDispatch (17.7KB) (1.47ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (382μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (64ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.29KB) (35.69ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (25μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (44μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (21μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.76KB) (5.24ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (23μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (49μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (21μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (5.26ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (63μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (22μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (11μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (18μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (15μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (18μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (9μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (17μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (8μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (18μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (372μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (4.33ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (60μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (1.38ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (19μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (10μs)
  • afterRenderRawModule mod_finder () (214.53KB) (4.11ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (31μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (128μs)
  • afterRenderRawModule mod_custom () (22.3KB) (2.43ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (1.23KB) (48μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (92μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (565μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (2μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (36μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (14μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (620μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (27μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (8μs)
  • afterRenderRawModule mod_finder () (6.09KB) (2.49ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.23KB) (43μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (157μs)
  • afterRenderRawModule mod_custom () (944B) (120μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (23μs)
  • beforeRenderRawModule mod_custom () (688B) (70μs)
  • afterRenderRawModule mod_custom () (896B) (82μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (19μs)
  • afterRender (177.95KB) (5.35ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (24.23%)
    64.00ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (15.17%)
    40.07ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.29KB) (13.51%)
    35.69ms
    1 x afterRenderComponent com_content (76.21KB) (9.56%)
    25.25ms
    1 x afterInitialise (1.27MB) (8.85%)
    23.38ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (6.44%)
    17.01ms
    1 x afterRoute (927.02KB) (4.72%)
    12.46ms
    1 x afterRender (177.95KB) (2.02%)
    5.35ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.99%)
    5.26ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.76KB) (1.98%)
    5.24ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.64%)
    4.33ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.55%)
    4.11ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.15KB) (1.55%)
    4.10ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.94%)
    2.49ms
    1 x afterRenderRawModule mod_custom () (22.3KB) (0.92%)
    2.43ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.75%)
    1.97ms
    1 x afterLoad (456.63KB) (0.63%)
    1.66ms
    1 x afterDispatch (17.7KB) (0.56%)
    1.47ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (0.52%)
    1.38ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.49%)
    1.28ms
    1 x beforeRenderComponent com_content (24.37KB) (0.28%)
    734μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.23%)
    620μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.21%)
    565μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.14%)
    382μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.14%)
    372μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.11%)
    289μs
    1 x Before Access::getAssetRules (id:5167 name:com_content.article.2548) (130.65KB) (0.07%)
    175μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.06%)
    157μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.05%)
    128μs
    1 x afterRenderRawModule mod_custom () (944B) (0.05%)
    120μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.04%)
    97μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.03%)
    92μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    82μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.03%)
    70μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    63μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.02%)
    60μs
    1 x After Access::getAssetRules (id:5167 name:com_content.article.2548) (7.38KB) (0.02%)
    59μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.02%)
    49μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    48μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.02%)
    44μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.02%)
    43μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    36μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    31μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    27μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    25μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    23μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    21μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    19μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    19μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    18μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    18μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    18μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0.01%)
    15μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    8μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    6μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique152ms1.35MB
  • SELECT @@SESSION.sql_mode;55μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?86μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 175μ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)4.15ms944BParams/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` = 1317μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`77μ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` = :guest147μ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`948μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC143μ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` = 11.26ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config501μs1.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.69ms165.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`426μ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` = 1231μs848B/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)797μ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` = 05.96ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`736μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2548'2.04ms48B/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)1.27ms46.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`1.24ms3.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)2.99ms4.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`386μ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 ASC380μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id119μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id91μ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.49ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 DESC19.63ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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`343μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1122μs536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0318μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id87μ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 `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-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-03 00:20:56') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:20:56') AND c2.state = 1260μs3.97KBParams/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 a.title ASC LIMIT 1060.39ms195.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 `tag_date` > DATE_ADD('2025-02-03 00:20:56', INTERVAL -1 YEAR) 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 1033.5ms2.66KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • 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`.`catid` IN (:preparedArray5) 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 (:preparedArray6,:preparedArray7) ORDER BY a.created ASC LIMIT 102.14ms159.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 (: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`354μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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` = :id120μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1161μ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)128μs584B/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 ASC1.24ms4.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)127μ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` = 1234μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?437μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.46ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy