Skip to main content

COVID-19: Four meta-analyses confirm vitamin D’s protective effect

COVID-19: Four meta-analyses confirm vitamin D’s protective effectSince December of 2021, two large meta-analyses have revealed that having low levels of vitamin D in your blood increases the risk of COVID-19 infections, severe disease, admission to intensive care, and death. A third meta-analysis has shown that only 12 percent of COVID-19 patients who took supplements of vitamin D were admitted to intensive care, compared to 26 percent of the non-supplemented. Finally, a fourth meta-analysis shows that supplementation with vitamin D significantly lowers the risk of life-threatening COVID-19 infections. This is particularly relevant during the winter period and among people at risk of being vitamin D-deficient, including groups such as seniors, people with dark skin, overweight people, and the chronically ill. There is an alarming need for increased focus on vitamin D supplements to prevent and treat COVID-19 and other virus infections by optimizing blood levels of the nutrient. It is also important to get plenty of magnesium, a nutrient the body needs to activate vitamin D.

Coronavirus is a family of RNA viruses that constantly mutate, and this limits the effect of vaccines. The most common coronavirus is the one that causes the simple cold. COVID-19 is a more recent variant that attacks the lower respiratory tract and can lead to bronchitis and pneumonia combined with fever. In most cases, COVID-19 develops mild to moderate symptoms or no symptoms at all. In severe cases, the immune system overreacts with cytokine storm and hyperinflammation that can cause acute respiratory distress syndrome (ARDS). This potentially life-threatening condition is the reason why the weakest patients succumb.
Most people who develop serious complications because of COVID-19 are above the age of 80 years or already suffer from comorbidities such as hypertension, diabetes, or other chronic diseases. A thing that both ageing and a variety of chronic diseases have in common is chronic low-grade inflammation in the body. It is therefore a weak and derailed immune defense that makes COVID-19 dangerous, not the coronavirus itself.

Vitamin D’s role in the immune defense

Vitamin D is considered a hormone. It regulates around 10 percent of our genes by way of different on-off switches that also include our highly-developed immune defense. Vitamin D is of vital importance to our innate immune system that handles most germs without us noticing. In our airways, we have many white blood cells (macrophages) and antibiotic peptides that need vitamin D to kill off virus. Our T cells, the special troops of our immune defense, also need vitamin D to help them divide explosively, attack virus, and establish effective immunity afterwards. If we lack vitamin D, we are much more vulnerable to infections. Also, a vitamin D deficiency may disrupt the communication between white blood cells, causing them to launch a cytokine storm and hyperinflammation, both of which make infections complicated and, in worst case, life-threatening.

Vitamin D’s therapeutic role in COVID-19

The first of the four meta-analyses (“Prognostic and Therapeutic Role of Vitamin D in COVID-19: Systematic Review and Meta-analysis”) was published on December 11th, 2021. The scientists wanted to study how vitamin D deficiency affected the severity and mortality of COVID-19. They also wanted to look at vitamin D’s therapeutic potential. The meta-analysis included 72 observational studies and 1,976,099 patients who were eligible for inclusion. Compared with patients who had plenty of vitamin D in the blood, those patients who lacked vitamin D had a:

  • 1.46 times greater risk of getting COVID-19
  • 1.9 times greater risk of serious complications
  • 2.7 times greater risk of death

Because the studies had different ways of defining vitamin D deficiency and severe complications, it was difficult for the scientists to make proper comparisons. Nonetheless, the multitude of observational studies with nearly two million patients revealed that, not only does being vitamin D-deficient increase the risk of a COVID-19 infection, it also increases the risk of it becoming complicated and life-threatening. Apparently, more than half of those who died of COVID-19 lacked vitamin D.

Vitamin D status and COVID-19 severity

The other meta-analysis (“Vitamin D Status and SARS-CoV-2 Infection and COVID-19 Clinical Outcomes”) was published on December 22th, 2021. Here, the researchers wanted to study if blood levels of vitamin D were related to severe COVID-19 symptoms (ARDS), admission to intensive care, and death. Their meta-analysis included 54 observational studies and 1,403,715 patients. Blood levels of vitamin D were categorized as:

  • Insufficiency – less than 75 nmol/L
  • Deficiency – less than 50 nmol/L
  • Severe deficiency – less than 25 nmol/L

Seventeen of the 54 studies reported a relation between low vitamin D status and COVID-19 infection. Nine of the studies reported a relation between low vitamin D status and hospitalization. 27 of the studies reported a relation between low vitamin D status and admission to intensive care. The relation between the degree of vitamin D deficiency and the risk of being admitted to intensive care was as follows:

  • Severe deficiency – 2.63 times higher risk
  • Deficiency – 2.16 times higher risk
  • Insufficiency – 2.83 times higher risk

The scientists conclude that in patients with low levels of vitamin D in their blood, the COVID-19 infection is more likely to develop into ARDS that requires admission to intensive care. The risk of dying of the infection is also much higher.

The effect of vitamin D supplements is convincing

The third study (“The Effect of Vitamin D Supplementation on Mortality and Intensive Care Unit Admission of COVID-19 Patients: Systematic Review, Meta-Analysis, and Meta-Regression”) was published in May, 2022. Six of the included studies involved 860 COVID-19 patients in intensive care. Three hundred and sixty-nine of the patients were given vitamin D, while 491 patients did not receive vitamin supplementation. Among the supplemented patients, 12 percent were admitted to intensive care, compared with 26 percent of the non-supplemented. In other words, supplementation more than halved the risk of being admitted to intensive care. All the data from the six studies revealed that vitamin D supplementation has a positive effect on the treatment of patients with severe COVID-19. It is, needless to say, essential to optimize blood levels of vitamin D as fast as possible, but the optimal vitamin D dose has not yet been established. In some studies, scientists have started by administering very high doses, while other studies have used supplements with calcidiol (25-hydroxyvitamin D3) that is both easier and faster for the body to absorb and utilize.

Vitamin D, COVID-19, severity, and mortality

The fourth and last meta-analysis (“Vitamin D and SARS-CoV-2 Infection, Severity and Mortality: A Systematic Review and Meta-analysis”) was published on July 6th, 2022, in PLoS One. Here, the researchers looked at levels of vitamin D in the blood and supplementation. The meta-analysis included 38 studies, two of which were randomized, controlled studies. The meta-analysis included more than 200,000 patients and showed that vitamin D supplementation was significantly related to a lower risk of severe COVID-19 complications and subsequent death. The scientists observed a particularly positive effect on older patients living at northern latitudes.

Vitamin D and comorbidities

The multitude of data shows that factors like old age, overweight, diabetes, hypertension, and other chronic illnesses make it more likely for COVID-19 to become complicated and life-threatening. As a result of the different comorbidities, patients die with – and not of – COVID-19. The scientists assume that being vitamin D-deficient is also a comorbidity. A host of studies show that ageing and the above-mentioned diseases are linked to chronic vitamin D deficiency.

Vitamin D supplementation and optimal utilization

The official recommendations for vitamin D call for daily intake of 5-20 micrograms, where the vulnerable groups should strive to have the highest intake. These are older recommendations that primarily aim at preventing osteoporosis. However, they are not guaranteed to provide the optimal vitamin D intake for immune defense and other body functions. It is therefore better to try to have optimal blood levels of vitamin D all year round and throughout life. According to leading scientists, the vitamin D blood level should lie in the range of 100-120 nmol/L.
There are different high-dosed vitamin D supplements that contain up to 100 micrograms of vitamin D and are perfectly safe to take. Make sure to get plenty of magnesium, as well. Different magnesium-dependent enzymes are needed for the body’s conversion of inactive cholecalciferol from sun exposure and supplements into the active form of vitamin D (1,25 dihydroxyvitamin D3). You make better use of your vitamin D supplement if you get plenty of magnesium from coarse and green foods or from supplements.
It takes some time for levels of vitamin D to reach their optimum in the blood and in cells. Also, beware that we are not able to synthesize vitamin D in the skin during the winter period, at least not at northern latitudes

Vitamin D’s mechanisms in relation to COVID-19

  • Strengthens the innate immune defense that tackles germs without us noticing
  • Strengthens the T cells that provide us with the best immunity against virus
  • Strengthens the B cells that produce antibodies
  • Regulates cytokines and inflammation
  • Maintains the integrity of endothelial cells. Dysfunctional endothelial cells contribute to inflammation in the blood vessels and disruptions of the coagulation processes that are hallmarks of completed COVID-19 infections
  • Increases the concentration of ACE2 (angiotensin-converting enzyme 2) that prevents virus from entering cells via the ACE2-receptors

References:

Harsha Anuruddhika Dissanayake et al. Prognostic and Therapeutic Role of Vitamin D in COVID-19: Systematic Review and Meta-analysis. The Journal of Clinical Endocrinology & Metabolism. 11 December 2021

Lacopo Chiodini et al. Vitamin D Status and SARS-CoV-2 Infection and COVID-19 Clinical Outcomes. Frontiers 22. December 2021

Nikolaus Tentolouris et al. The effect of vitamin D supplementation on mortality and intensive care unit admission of COVID-19 patients. A systematic review, meta-analysis and meta-regression. Diabetes Metab. Res Rev. 2022 May

Constanza Gavioli et al. ” Vitamin D and SARS-CoV-2 Infection, Severity and Mortality: A systematic Review and Meta-Analysis. PLOS ONE. July 6, 2022

Mercola. Meta-Analyses Confirm Vitamin D Defends Against COVID. www.mercola.com. September 05, 2022

Mohsen Nabi-Afjadi et al. The effect of vitamin D, magnesium and zinc supplements on interferon signaling pathways and their relationship to control SARS-CoV-2 infection. Clinical and Molecular Allergy. 2021

Daniel Chauss et al. Autocrine vitamin D signaling switches off pro-inflammatory programs of TH1 cells. Nature Immunology. 2021

Purdue University. Researchers study the link between vitamin D and inflammation. ScienceDaily 2021.

Krishna Sriram et al. What is the ACE2 receptor, how is it connected to coronavirus and why might it be key to treating COVID-19? The Conversation. 2020

Qi Dai et al. Magnesium status and supplements influence vitamin D status and metabolism: results from a randomized trial. The American Journal of Clinical Nutrition. 2018

Nikki Hancocks. Diet and supplements: Swiss panel publishes COVID-19 recommendations. 2020

  • Created on .
8.835MBMemory Usage1.31sRequest 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" => 1740231042 "last" => 1740231042...
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) (5.54ms)
  • afterInitialise (1.27MB) (35.32ms)
  • afterRoute (897.2KB) (20.77ms)
  • beforeRenderComponent com_content (23.02KB) (1.46ms)
  • Before Access::preloadComponents (all components) (33.23KB) (317μs)
  • After Access::preloadComponents (all components) (97.34KB) (4.5ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (22μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (51.77ms)
  • Before Access::getAssetRules (id:7475 name:com_content.article.3704) (130.65KB) (109μs)
  • After Access::getAssetRules (id:7475 name:com_content.article.3704) (7.38KB) (2.27ms)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (131ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (196μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (13.01ms)
  • afterRenderComponent com_content (68.14KB) (38.59ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (29.54ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (30μs)
  • afterDispatch (17.7KB) (610μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (513μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (71.19KB) (397ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (36μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (44μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (15μs)
  • afterRenderRawModule mod_tags_popular (Search) (45.98KB) (421ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (24μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (46μ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) (17.21ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (52μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (14μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (1.17ms)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (26μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (1.25ms)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (18μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (40μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (11μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (24μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (5.64ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (7.63ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (76μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (41μs)
  • afterRenderRawModule mod_languages (Sprogskift) (20.87KB) (17.14ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (32μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (12μs)
  • afterRenderRawModule mod_finder () (128.95KB) (16.44ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (32μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (145μs)
  • afterRenderRawModule mod_custom () (21.95KB) (8.19ms)
  • beforeRenderModule mod_custom () (704B) (7μs)
  • afterRenderModule mod_custom () (1.23KB) (47μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (210μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (16.01ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (52μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (696μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (29μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (12.03ms)
  • afterRenderRawModule mod_finder () (6.29KB) (2.23ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (3.73KB) (49μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (186μs)
  • afterRenderRawModule mod_custom () (944B) (138μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (26μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (89μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (209.48KB) (43.9ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (45.98KB) (32.1%)
    420.67ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (71.19KB) (30.26%)
    396.61ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (9.97%)
    130.70ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (3.95%)
    51.77ms
    1 x afterRender (209.48KB) (3.35%)
    43.90ms
    1 x afterRenderComponent com_content (68.14KB) (2.94%)
    38.59ms
    1 x afterInitialise (1.27MB) (2.69%)
    35.32ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (2.25%)
    29.54ms
    1 x afterRoute (897.2KB) (1.58%)
    20.77ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.31%)
    17.21ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (20.87KB) (1.31%)
    17.14ms
    1 x afterRenderRawModule mod_finder () (128.95KB) (1.25%)
    16.44ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.22%)
    16.01ms
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.99%)
    13.01ms
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.92%)
    12.03ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.63%)
    8.19ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.58%)
    7.63ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.43%)
    5.64ms
    1 x afterLoad (456.41KB) (0.42%)
    5.54ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.34%)
    4.50ms
    1 x After Access::getAssetRules (id:7475 name:com_content.article.3704) (7.38KB) (0.17%)
    2.27ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.17%)
    2.23ms
    1 x beforeRenderComponent com_content (23.02KB) (0.11%)
    1.46ms
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.1%)
    1.25ms
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.09%)
    1.17ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.05%)
    696μs
    1 x afterDispatch (17.7KB) (0.05%)
    610μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.04%)
    513μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.02%)
    317μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.02%)
    210μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.01%)
    196μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.01%)
    186μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.01%)
    145μs
    1 x afterRenderRawModule mod_custom () (944B) (0.01%)
    138μs
    1 x Before Access::getAssetRules (id:7475 name:com_content.article.3704) (130.65KB) (0.01%)
    109μs
    1 x afterRenderRawModule mod_custom () (896B) (0.01%)
    89μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    80μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    76μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0%)
    52μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0%)
    52μs
    1 x afterRenderModule mod_finder () (3.73KB) (0%)
    49μs
    1 x afterRenderModule mod_custom () (1.23KB) (0%)
    47μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0%)
    46μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0%)
    44μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    41μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    40μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0%)
    36μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    32μs
    1 x afterRenderModule mod_finder () (3.29KB) (0%)
    32μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    30μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0%)
    29μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    26μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    26μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    24μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    24μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    23μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    22μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    20μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    15μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    14μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    11μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique914ms1.14MB
  • SELECT @@SESSION.sql_mode;77μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?131μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 187μ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)1.73ms944BParams/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` = 1402μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`96μ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` = :guest133μ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`547μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC424μ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` = 1157μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config430μ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`3.02ms165.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`1.05ms3.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` = 11.62ms848B/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)377μ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` = 016.05ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.23ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3704'3.06ms48B/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)2.37ms22.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`298μ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.3ms4.08KBParams/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`1.13ms3.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.4ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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` = :id305μ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`16.82ms180.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 DESC17.59ms161.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`1.05ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1659μ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` = 03.95ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id4.24ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id111μ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-22 13:30:42') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-22 13:30:42') AND c2.state = 1277μ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 RAND() ASC LIMIT 10378ms151.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`687μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 15417ms2.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` = :id3.96ms1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1838μ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)7.98ms584B/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 ASC806μ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)1.77ms584B/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` = 16.1ms1.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`2.95ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?2.98ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.19ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy