Skip to main content

Lack of vitamin D increases your risk of virus infections and sequela

Lack of vitamin D increases your risk of virus infections and sequelaIt is hardly a coincidence that sore throats, colds, flus, and related complications such as sinus infections and pneumonia typically circulate during the winter period. They are primarily a result of having low vitamin D levels. During the winter, the sun sits too low in the sky to enable vitamin D synthesis in our skin, and we only have a limited amount of the nutrient stored in the liver. Good hand hygiene, warm soup, garlic, echinacea and other immune-boosting herbs alone will not deal with the problem, as they can never compensate for our lack of essential vitamin D, which the white blood cells of our immune system need in order to silently kill of virus. But how much vitamin D do we need, is it possible to get too much, and which mineral is necessary for activating the vitamin?

Many people mistakenly believe that it is both natural and inevitable to catch influenza or colds, have a sore throat, or contract other virus infections during the cold season. What they do not realize is that infections require two things: Being infected and having a weakened immune system. Proper hygiene is relevant, of course. Still, the immune system requires a host of different nutrients in order to function optimally. Even if you stick with the official guidelines for healthy eating, you may be hard pressed to get enough vitamin D, according to leading experts. The risk of being chronically vitamin D-deficient is increased by such factors as spending too much time indoors, being old, having dark skin, being overweight, having type 2 diabetes, and using cholesterol-lowering medication. In beginning, a deficiency goes unnoticed, but it makes us more vulnerable to virus infections and sequela that may be potentially life-threatening, at least for older people or immunocompromised individuals.

Vitamin D activates the entire immune defense

The immune system consists of different proteins, antibodies, and white blood cells that work around the clock to protect the body against infection. All cells in the body have vitamin D receptors (VDR) that should be viewed as hormones because they are made from cholesterol, just like all other steroid hormones (sex hormones, stress hormones etc.).
In our airways, we have particularly many white blood cells (macrophages) that require vitamin D in order to attack germs. Vitamin D also boosts certain antibiotic peptides in the lungs.
Scientists from the University of Copenhagen have observed that vitamin D plays a crucial role in the activation of the immune system’s vanguard, the so-called T cells. When there are no imminent threats, billions of T cells circulate in the blood in “sleep mode”, but they are alert. As soon as an inactive T cell detects the slightest trace of a foreign body, it deploys its antennas and awaits activation.
This was when the scientists noticed that the first antennas, which the T cells deploy, are their vitamin D-binding receptors. This switches on a certain gene that enables the T cells to replicate and form an entire army, which can direct its swift attacks at virus and microbes. Vitamin D works like a battery in the T cells. Without vitamin D, the immune defense remains dormant and passive, leaving us susceptible to many different infections.
The Danish researchers’ groundbreaking discovery is published in Nature Immunology and sheds new light on the widespread vitamin D deficiency, which is a problem that needs to be addressed.

  • Factors such as the time of year, modern lifestyle, and overweight play a role in the widespread problems with vitamin D deficiency
  • You are unlikely to notice if your body’s vitamin D levels are depleted, but the immune defense will soon find out

A vitamin D supplement can reduce your flu risk by 40-50 percent

Studies of vitamin D supplementation as a means of preventing influenza and other infections show conflicting results, which is due to the way these studies are designed. According to Professor Adrian Martineau, who conducted a large meta-analysis, it is only relevant to give vitamin D supplements to people who are in need of the nutrient, and the best effect is seen when the supplements are taken on a daily basis. In people that already have low blood levels of vitamin D, supplementation with the nutrient can reduce by 50 percent their risk of influenza and acute respiratory tract infections (RTI).
The daily supplementation dose is also important for the study result, as regular vitamin pills rarely contain enough vitamin D to optimize blood levels of the nutrient.
Scientists from the University of Colorado Anschultz Medical Campus studied older patients who were supplemented with different vitamin D doses for a year. They found that the participants that got the highest doses (82-107 micrograms) had the largest reduction of acute RTIs, including pneumonia. Their risk was reduced by 40 percent.

Many older people, cancer patients, and people who are weak die of pneumonia caused by a virus infection. Therefore, high-dosed vitamin D supplements have the potential to save millions of lives.

Vitamin D also protects against bronchitis and asthma

Bronchitis and asthma often follow in the wake of virus infections such as colds and influenza. Studies show that vitamin D has two mechanisms that protect against bronchitis and asthma. Firstly, it strengthens the immune defense. Secondly, it prevents undesirable, persistent inflammation.
It is vital that we humans can fight an infection swiftly and effectively. At the same time, it is important that the immune defense does not overreact, as this will cause chronic inflammation. That is why vitamin D is so crucial for preventing bronchitis, asthma, and other conditions where inflammation plays a key role. According to a study that was published in Nutrients in 2015, vitamin D is both directly and indirectly involved in the regulation of T cells and their production of various cytokines (inflammation markers).

The discomfort that we feel with an influenza is not caused by the virus but by the cytokines that the immune defense produces.

How much vitamin D can we humans produce?

It is relatively easy to produce between 20 and 100 micrograms of vitamin D if you spend time outdoors in light clothing on a hot summer’s day. Older people and individuals with dark skin have more difficulty with synthesizing the vitamin. Excess vitamin D is stored in the liver for later use, but these stores are easily depleted in the winter and early spring. If you do not get enough sunshine in the summer period and use too much factor cream, you risk a chronic deficiency.

RI levels and the actual need for vitamin D

In Denmark, normal vitamin pills only contain around five micrograms of vitamin D, which is the reference intake (RI) level for adults up to 70 years of age. Many scientists claim that we need much more in order to ensure optimal immune function.
High-dosed vitamin D supplements with as much as 20-80 micrograms are available. The actual need depends on your age, BMI, chronic diseases such as diabetes, and the use of cholesterol-lowering medication.
It should also be mentioned that magnesium is required in order to activate the form of vitamin D that we get from sun exposure or from supplements.
Vitamin D is lipid-soluble, which means that the best way to take the nutrient in supplement form is in capsules where it is bound to oil.

It takes a supplement to optimize your blood levels of vitamin D

Vitamin D in the blood is measured as 25-hydroxyvitamin D3. In Denmark, the lower threshold for vitamin D in the blood is 50 ng/ml. Leading scientists believe that we most aim as high as 60-100 ng/ml to obtain optimal disease prevention. At our latitudes, this would require taking a vitamin D supplement during the winter period.

Is it possible to get too much vitamin D?

You cannot produce too much vitamin D from sun exposure. When it comes to supplements, the European Food Safety Authority (EFSA) has set an upper safe daily limit for vitamin D intake, which is 25 micrograms for infants, 50 micrograms for children aged 1-10 years, and 100 micrograms for older children and adults, including pregnant and breastfeeding women.
Long-term intake of vitamin D doses that are more than 100 times the RI level may result in calcium precipitation within the kidneys and bladder, and there is a risk of kidney stones. Too much calcium in the blood may cause nausea, headaches, and constipation. In connection with pregnancy, elevated amounts in the blood may lead to fetal damage.
Don’t take vitamin D supplements, if you suffer from hypercalcemia (elevated blood levels of calcium) or have elevated phosphate levels in your blood, because it may worsen your condition. Magnesium and vitamin K2 help drain calcium from the blood and store it in bone tissue. People with sarcoidosis should be careful with vitamin D supplementation when their disease is active. If in doubt, ask your physician.

References

D-vitamin – hvad er det og kan man få for meget d-vitamin. Illustreret Videnskab 2019

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

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

Martineau Adrian et al. Vitamin D supplementation to prevent acute respiratory tract infections: systematic review and meta-analysis of individual participant data. The BMJ 2017

Urashima M, et al. Randomized trial of Vitamin D supplementation to prevent seasonal influenza A in schoolchildren. Am J Clin Nutr 2010

University of Colorado Anschultz Medical Campus. Vitamin D reduces respiratory infections. ScienceDaily November 2016

Cynthia Aranow. Vitamin D and the Immune system. J Investig Med. 2011

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

https://netdoktor.dk/vitaminer/vitamind.htm

Pernille Lund. Immunforsvarets nye ABC. Hovedland. 2012

  • Created on .
8.874MBMemory Usage369msRequest 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" => 1738542057 "last" => 1738542057...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-US" ]
  • afterLoad (456.63KB) (910μs)
  • afterInitialise (1.27MB) (15.92ms)
  • afterRoute (927.02KB) (7.4ms)
  • beforeRenderComponent com_content (24.37KB) (360μs)
  • Before Access::preloadComponents (all components) (35.84KB) (1.44ms)
  • After Access::preloadComponents (all components) (97.34KB) (2.18ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (11.38ms)
  • Before Access::getAssetRules (id:4979 name:com_content.article.2458) (130.65KB) (108μs)
  • After Access::getAssetRules (id:4979 name:com_content.article.2458) (7.38KB) (58μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (57.03ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (314μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (103μs)
  • afterRenderComponent com_content (64.24KB) (43.31ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.09KB) (8.08ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (31μs)
  • afterDispatch (17.7KB) (2.76ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (1.07ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (111ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (30μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.26KB) (66.02ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (23μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (44μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (21μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (6.86ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (27μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (43μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (13μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (34μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (5.18ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (69μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (14μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (28μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (23μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (17μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (21μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (1.52ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (3.8ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (72μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (1.62ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (1.14ms)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (30μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (13μs)
  • afterRenderRawModule mod_finder () (214.53KB) (3.32ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (36μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (149μs)
  • afterRenderRawModule mod_custom () (22.27KB) (3.01ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (54μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (118μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.99ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (48μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (955μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (41μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (12μs)
  • afterRenderRawModule mod_finder () (6.09KB) (1.6ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (48μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (187μs)
  • afterRenderRawModule mod_custom () (944B) (150μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (897μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.71KB) (27μs)
  • afterRender (174.02KB) (5.97ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (30.02%)
    110.92ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.26KB) (17.87%)
    66.02ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (15.44%)
    57.03ms
    1 x afterRenderComponent com_content (64.24KB) (11.72%)
    43.31ms
    1 x afterInitialise (1.27MB) (4.31%)
    15.92ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.08%)
    11.38ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.09KB) (2.19%)
    8.08ms
    1 x afterRoute (927.02KB) (2%)
    7.40ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (1.86%)
    6.86ms
    1 x afterRender (174.02KB) (1.62%)
    5.97ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.4%)
    5.18ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.03%)
    3.80ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (0.9%)
    3.32ms
    1 x afterRenderRawModule mod_custom () (22.27KB) (0.81%)
    3.01ms
    1 x afterDispatch (17.7KB) (0.75%)
    2.76ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.59%)
    2.18ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.54%)
    1.99ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (0.44%)
    1.62ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.43%)
    1.60ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.41%)
    1.52ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.39%)
    1.44ms
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0.31%)
    1.14ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.29%)
    1.07ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.26%)
    955μs
    1 x afterLoad (456.63KB) (0.25%)
    910μs
    1 x afterRenderRawModule mod_custom () (896B) (0.24%)
    897μs
    1 x beforeRenderComponent com_content (24.37KB) (0.1%)
    360μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.08%)
    314μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.05%)
    187μs
    1 x afterRenderRawModule mod_custom () (944B) (0.04%)
    150μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.04%)
    149μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.03%)
    118μs
    1 x Before Access::getAssetRules (id:4979 name:com_content.article.2458) (130.65KB) (0.03%)
    108μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.03%)
    103μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    80μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.02%)
    72μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    69μs
    1 x After Access::getAssetRules (id:4979 name:com_content.article.2458) (7.38KB) (0.02%)
    58μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    54μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    48μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    48μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    44μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    43μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    41μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    36μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    34μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    31μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    30μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    23μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    21μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    18μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    14μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    13μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    13μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    13μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
45 statements were executed, 9 of which were duplicates, 36 unique234ms1.33MB
  • SELECT @@SESSION.sql_mode;59μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?175μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1126μ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.67ms944BParams/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` = 1407μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`133μ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` = :guest235μ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`999μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC131μ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` = 1152μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config161μ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`748μ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`389μ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` = 1232μ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)423μ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` = 04.92ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.36ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2458'1.64ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)1.31ms22.19KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.18ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)2.28ms4.11KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`593μ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 ASC338μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id93μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id124μ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`4.08ms180.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 DESC30.45ms161.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`551μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1128μ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` = 0328μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id136μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id102μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-03 00:20:57') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:20:57') AND c2.state = 1376μ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 10105ms195.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `tag_date` > DATE_ADD('2025-02-03 00:20:57', 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 1063.75ms2.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 103.58ms159.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`385μ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` = :id192μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1208μ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)141μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.29ms4.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)178μ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` = 1137μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?112μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.75ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy