Skip to main content

COVID-19: Vitamin D supplements may lower the mortality rate by 82 percent

COVID-19: Vitamin D supplements may lower the mortality rate by 82 percentAn estimated one billion people around the world lack vitamin D, which increases their risk of COVID-19 infections and new strains of the virus that become complicated and potentially life-threatening. In November 2020, the authorities of Andalusia, a Spanish province, started giving vulnerable groups of people supplements of a particularly active form of vitamin D. The result of this intervention showed quickly. The number of patients in intensive care plummeted and the death rate dropped by 82 percent. Meanwhile, the death rate in Great Britain and many other countries went up, most likely because vitamin D deficiencies are more common during the winter period. A British politician has therefore urged Prime Minister Boris Johnson to follow the Andalusian method, which is both effective and inexpensive. Furthermore, a Spanish study shows that supplementing hospitalized COVID-19 patients with active vitamin D can save lives. How much vitamin D do we need and how does the body activate vitamin D from sun exposure or from supplements?

Vaccines are being touted as our most powerful weapon in the battle against COVID-19, yet they are not sufficiently effective when it comes to protecting against new virus strains because RNA viruses like COVID-19 can easily mutate. We must also bolster our immune defense that is designed to attack many different microorganisms. Vitamin D, which our skin produces when we spend time in the sun during the summer period plays a key role in several ways, and it stands to reason that we experience new corona waves when it is winter. Older people, dark-skinned individuals, chronically ill, and nursing home residents also risk being permanently vitamin D-deficient and that makes them vulnerable all year round.

  • Lack of vitamin D is a pandemic
  • Vitamin D helps the immune defense so it can direct swift and effective attacks on the virus
  • Vitamin D also prevents the immune defense from overreacting with cytokine storm and hyperinflammation, which make virus infections complicated and potentially life-threatening

Politics, vitamin D, and new strategies for fighting COVID-19

In England, the conservative parliament member, David Davis, has urged Prime Minister Boris Johnson to follow “the Andalusian method” in the battle against COVID-19 because vitamin D has been shown to make a significant difference.
David Davis points to the fact that around eight million people live in the Andalusia. In November 2020, there were 189 deaths per 1,000,000,000 inhabitants – which at that point was a higher death rate than in England. A rapid effect was seen after the Andalusians started giving nursing home residents and certain groups of patients supplements of an active form of vitamin D called calcifediol. Far fewer people were put in intensive care and the death rate dropped to 11 people in the beginning of January, which is an 82 percent reduction. Meanwhile, the death rate in England doubled, probably due to the increasing vitamin D deficiency problem during the winter period
David Davis also mentions that for decades, doctors and scientists have warned against the global vitamin D deficiency problem that is believed to affect around one billion people. These warning flags are still being ignored and were even ignored long before WHO declared COVID-19 a pandemic in March last year.
In the ongoing battle against this catastrophe, governments worldwide have introduced numerous lockdowns that come with an enormous price tag – not just in terms of finances but also in terms of mental health. Lockdowns even limit our individual freedom, and many other diseases and subsequent deaths may follow in the wake of closed-down societies and health care systems that don’t operate and function properly.
On earlier occasions, David Davis has suggested vitamin D supplementation for vulnerable groups. He now suggests giving calcifediol, the active form of vitamin D, to nursing home residents. Calcifediol is also known as 25-hydroxyvitamin D3 and is the form of vitamin D that is measured in blood. It is the form of vitamin D that the body utilizes the best and the fastest. The intervention is inexpensive and has no side effects plus it strengthens the immune defense against a variety of coronavirus types and other pathogens.

  • The form of vitamin D that we synthesize from sun exposure is called cholecalciferol and is the same form that you get from regular supplements
  • In the liver, cholecalciferol is converted into calcifediol with help from enzymes. This form of vitamin D is also known as 25-hydroxyvitamin D3 and is what is measured in the blood
  • In the kidneys and other tissues, calcifediol is converted into calcitriol (1,25-dihydroxycholecalciferol D3), the biologically active form of vitamin D

New studies are on their way

David Davis has been heavily criticized because the Andalusian method has not quite met the normal scientific standards for randomized, controlled studies. For instance, the group of 551 individuals that got calcifediol and the control group of 379 were not properly balanced.
Professor Adrian Martineau from Queen Mary University of London therefore calls for more randomized, controlled studies of vitamin D, although he did actually head a meta-analysis where vitamin D supplements were shown to lower the number of acute respiratory infections by up to 42 percent. And he is currently conducting a large randomized, clinical study called CORONAVIT that is looking into vitamin D and COVID-19.

Vitamin D supplementation of COVID-19 patients reduces the number of intensive care patients and the death rate

As mentioned earlier, vitamin D supplements have a prophylactic effect on COVID-19 infections and related deaths. Treating COVID-19 patients with high-dosed vitamin D supplements can also save lives, according to a randomized clinical pilot study that was carried out at the University Hospital in Córdoba in Spain. Seventy-six hospitalized COVID-19 patients were either given standard treatment alone or in combination with high-dosed vitamin D supplements. In this study, the scientists also chose calcifediol, which the body can utilize better and faster.
Only two percent of the patients in the vitamin D group required intensive care, compared with 50 percent of the patients in the non-supplemented group. There were no recorded deaths in the vitamin D group and all patients were discharged without any complications. The study was published online in The Journal of Steroid Biochemistry and Molecular Biology in October 2020.

  • Earlier randomized studies have shown that vitamin D supplements are particularly effective at protecting against respiratory infections.
  • Still, you can only expect to see an effect if the person is vitamin D-deficient and if the dose is sufficiently high to optimize the vitamin D levels

You need magnesium in order to utilize vitamin D

Calcifediol was used in the Andalusian model with nursing home residents and (in large doses) in the study of COVID-19 patients at the Córdoba University Hospital. This form of vitamin D works much faster than the form of vitamin that we produce from sun exposure or get from regular supplements
However, one should also be aware that many magnesium-containing enzymes are involved in the conversion of cholecalciferol into calcifediol and the biologically active form, calcitriol 1,25-dihydrocholecalciferol D3). Therefore, if you lack magnesium you will not get the full benefit of vitamin D from sunlight or from normal supplements.

Vitamin D synthesis Form of vitamin D
The skin Cholecalciferol, vitamin D3
Produced from the form of cholesterol called 7-dihydroxycholesterol and UBV rays from the sun.
This form is also found in normal supplements
The liver Calcifediol/ calcidiol
25-hydroxyvitamin D3 that is measured in blood.
(the conversion requires magnesium)
The kidneys immune system and other tissues
Calcitriol (biologically active)
1,25-dihydroxycholecalciferol D3
(the conversion requires magnesium)

Optimize your vitamin D levels before it is too late

Lack of vitamin D is common and many scientists have argued for years that is important to optimize levels of the nutrient.
The official recommendations for vitamin D do not seem to be able to optimize blood levels of the nutrient – which should ideally be at least 50 nmol/L. Levels between 60-100 nmol/L are likely to be even better. If you live at northern latitudes and want to reach these levels, you need to take a high-dosed vitamin D supplement from October through April. If you don’t get enough sun during the summer period you need to take a supplement all year round.
It is possible to buy supplements that contain 20-80 micrograms of vitamin D. Our actual need for the nutrient depends on factors like genes, skin type, BMI, and chronic diseases like e.g. diabetes. According to the European Food Safety Authority (EFSA), the safe upper intake level for vitamin D is 100 micrograms per day. Vitamin D is lipid-soluble, which means that you get the highest level of bioavailability by taking vitamin D dissolved in oil in gelatin capsules.

  • The capacity of our immune defense determines if we can avoid getting infected, develop a mild infection, or get life-threatening complications.
  • No less than 80 percent of hospitalized COVID-19 patients lack vitamin D, according to a study that is published in The Journal of Clinical Endocrinology & Metabolism.
  • Vitamin D-deficient patients are twice as likely to develop life-threatening complications, according to a study from Northwestern University in Illinois, USA.

References:

Will Chu. UK Prime minister urged, “Look to Andalusia´s vitamin D use in tackling covid-19.” NUTRAingredients.com 09-Feb-2021

Laurence Dollimore. Watch: British MP praises Andalucía for using vitamin D to treat COVID-19 patients and ask PM Boris Johnson to follow Spain´s example. The Olive Press February 16, 2021

David Davis. Vitamin D: Covid-19. In the House of Commons 14th January 2021

Marta Entrenas Castillo et al. Effect of calciferol treatment and best available therapy versus best available therapy on intensive care unit admission and mortality among patients hospitalized for COVID-19: A pilot randomized clinical study. The Journal of Steroid Biochemistry and Molecular Biology. October 2020

David A Jolliffe et al. Vitamin D supplementation to prevent acute respiratory infections: systematic review and meta-analysis of aggregate data from randomised controlled trials. MedRxiv. BMJ Yale. 2020

Molly Campel. Talking Vitamin D and COVID-19 with professor Adrian Martineau. Technology Networks Jan 15 2020

Andrea Rosanoff et al. Essential Nutrient Interactions: Does Low or Suboptimal Magnesium Interact with Vitamin D and/or Calcium status. Advances in Nutrition 2016

José L Hernandez et al. Vitamin D Status in Hospitalized Patients with SARS-CoV2- Infection. The Journal of Clinical Endocrinology & Metabolism. October 2020

Northwestern University. Vitamin D levels appear to play role in COVID-19 mortality rates. Science Daily. May 2020

  • Created on .
8.942MBMemory Usage135msRequest 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" => 1741977811 "last" => 1741977811...
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.53KB) (1.69ms)
  • afterInitialise (1.27MB) (16.01ms)
  • afterRoute (927.02KB) (4.98ms)
  • beforeRenderComponent com_content (23.25KB) (285μs)
  • Before Access::preloadComponents (all components) (35.84KB) (344μs)
  • After Access::preloadComponents (all components) (97.34KB) (586μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (14μs)
  • After Access::preloadPermissions (com_content) (3.22MB) (4.96ms)
  • Before Access::getAssetRules (id:5955 name:com_content.article.2946) (130.65KB) (111μs)
  • After Access::getAssetRules (id:5955 name:com_content.article.2946) (7.38KB) (50μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (17.84ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (195μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (88μs)
  • afterRenderComponent com_content (68.14KB) (12.32ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.13KB) (1.83ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (28μs)
  • afterDispatch (17.66KB) (621μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (445μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (34.02ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (39μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.04KB) (20.06ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (23μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (42μ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.64KB) (2.36ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (25μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (37μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.97ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (52μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (26μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (21μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (24μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (34μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (25μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (11μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (10μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (393μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.34ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (51μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (1.86ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (10μs)
  • afterRenderRawModule mod_finder () (214.53KB) (1.99ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (149μs)
  • afterRenderRawModule mod_custom () (21.98KB) (761μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (49μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (104μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (638μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (42μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (660μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (30μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (9μs)
  • afterRenderRawModule mod_finder () (6.29KB) (530μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (47μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (188μs)
  • afterRenderRawModule mod_custom () (944B) (128μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (81μs)
  • afterRenderRawModule mod_custom () (896B) (97μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (206.65KB) (3.37ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (25.2%)
    34.02ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.04KB) (14.86%)
    20.06ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (13.21%)
    17.84ms
    1 x afterInitialise (1.27MB) (11.86%)
    16.01ms
    1 x afterRenderComponent com_content (68.14KB) (9.13%)
    12.32ms
    1 x afterRoute (927.02KB) (3.69%)
    4.98ms
    1 x After Access::preloadPermissions (com_content) (3.22MB) (3.67%)
    4.96ms
    1 x afterRender (206.65KB) (2.5%)
    3.37ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.64KB) (1.75%)
    2.36ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.48%)
    1.99ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.46%)
    1.97ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (1.38%)
    1.86ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.13KB) (1.36%)
    1.83ms
    1 x afterLoad (456.53KB) (1.25%)
    1.69ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1%)
    1.34ms
    1 x afterRenderRawModule mod_custom () (21.98KB) (0.56%)
    761μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.49%)
    660μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.47%)
    638μs
    1 x afterDispatch (17.66KB) (0.46%)
    621μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.43%)
    586μs
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.39%)
    530μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.33%)
    445μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.29%)
    393μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.25%)
    344μs
    1 x beforeRenderComponent com_content (23.25KB) (0.21%)
    285μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.14%)
    195μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.14%)
    188μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.11%)
    149μs
    1 x afterRenderRawModule mod_custom () (944B) (0.09%)
    128μs
    1 x Before Access::getAssetRules (id:5955 name:com_content.article.2946) (130.65KB) (0.08%)
    111μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.08%)
    104μs
    1 x afterRenderRawModule mod_custom () (896B) (0.07%)
    97μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.07%)
    88μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.06%)
    81μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.04%)
    52μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.04%)
    51μs
    1 x After Access::getAssetRules (id:5955 name:com_content.article.2946) (7.38KB) (0.04%)
    50μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.04%)
    49μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.03%)
    47μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.03%)
    42μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.03%)
    42μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.03%)
    39μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.03%)
    37μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0.03%)
    34μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.03%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.02%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.02%)
    28μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.02%)
    25μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.02%)
    25μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.02%)
    25μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.02%)
    24μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.02%)
    23μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.02%)
    22μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.02%)
    22μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.02%)
    22μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.02%)
    21μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0.02%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    20μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0.01%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    14μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    12μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0.01%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.01%)
    9μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    3μs
47 statements were executed, 9 of which were duplicates, 38 unique82.86ms1.35MB
  • SELECT @@SESSION.sql_mode;186μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?385μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1296μ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.85ms944BParams/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` = 1213μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`79μ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` = :guest130μ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`454μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC145μ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` = 1130μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config162μ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`750μs165.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`238μ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` = 1194μ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)349μ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` = 02.47ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`625μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2946'1.35ms48B/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)354μs38.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`332μ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)1.36ms4.03KBParams/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`320μ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 ASC324μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id101μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id74μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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`2.13ms180.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 DESC9.11ms161.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`317μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1116μ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` = 0295μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id84μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id56μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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-03-14 18:43:31') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-14 18:43:31') AND c2.state = 1288μ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 1032.4ms195.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-03-14 18:43:31', 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 1018.98ms2.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 10610μs159.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`395μ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` = :id124μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1158μ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)158μ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 ASC268μ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)131μ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` = 1140μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`350μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?90μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.94ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy
  • DELETE FROM `has_session` WHERE `time` < ?1.85ms440BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:80Copy