Skip to main content

Vitamin D prevents influenza and respiratory infections

Vitamin D prevents influenza and respiratory infectionsIt is hardly a coincidence that so many of us contract virus infections in the course of the winter. It is because we lack vitamin D, which we are unable to synthesize when the sun sits too low in the sky. Danish scientists have discovered how vitamin D activates the immune system, and a comprehensive meta-analysis shows how vitamin D supplements can prevent colds, flus, and related complications.

Vitamin D can even counteract inflammatory conditions such as bronchitis and aching joints that affect many people during the winter period. The question is, how much do we need?

Our diets only provide minimal amounts of vitamin D, and regular multivitamin supplements are not likely to deliver the amounts of vitamin D that are needed for optimal immune functioning. Too much time spent indoors, ageing processes, having dark skin, overusing sunscreen, being overweight, having type 2-diabetes and kidney diseases, and overconsuming calcium and cholesterol-lowering medicine can all increase our risk of lacking vitamin D all year round.
A vitamin D deficiency goes unnoticed in the beginning, yet it affects the “storm troops” of our immune system, leaving us increasingly vulnerable to virus infections and other complications such as bronchitis, and infected sinuses, ears, and lungs.

The non-specific (or innate) immune system is comparable to storm troops consisting of various proteins and a major part of our white blood cells. It combats most types of pathogens without us even knowing about it. Our specific (or adaptive) immune defense comprises of T and B cells plus antibodies that are like special troops that come to our rescue in situations where our non-specific immune system comes up short. Afterwards, the body develops a type of immunity towards the threat.

Vitamin D is determining for the activation of our immune defense

Vitamin D activates both the non-specific and the specific immune defense. Our respiratory tract harbors particularly many white blood cells called macrophages that depend on vitamin D in order to be able to attack pathogens. Vitamin D also boosts certain antibiotic peptides in our lungs.
Danish researchers have discovered how different T cells depend entirely on vitamin D. According to Carsten Geisler from the Faculty of Health and Medical Sciences at the University of Copenhagen, vitamin D helps activate the initial stage of the T cells’ attack, which is crucial.
Once T cells are exposed to virus and bacteria, they launch an immediate chemical reaction and deploy signals or “antennae” (more accurately called vitamin D receptors – or VDR) that T cells use to locate vitamin D in the bloodstream. T cells depend on extra vitamin D to help them divide and form an entire T cell army that can direct a very effective attack of the enemy.

When specific T cells are to attack a virus or a cancer cell, they take on one of several forms:

T helper cells are like officers that send out signaling substances telling what to attack. They also instruct B cells to produce antibodies.

T killer cells obey the command and destroy virus-infected cells and cancer cells using cytotoxic substances.

Regulatory T cells help pull the brake on T killer cells, once the enemy is defeated. That way, unnecessary tissue damage is avoided.

Memory T cells serve to remember (recognize) microorganisms by identifying specific characteristics (antigens) and mobilizing some sort of immunity.

Vitamin D needs to get all the way into the T killer cells

The scientists from the Faculty of Health and Medical Sciences made their groundbreaking discovery by isolating T cells from human blood in the laboratory. They found that T cells, which had never been in action, required vitamin D in order to get started. Once vitamin D has attached to a receptor in the T killer cells, the vitamin is carried way into the nucleus that is then instructed to produce a protein called PLC-gl (5,6). This is the protein that T killer cells need so they can divide into an entire army that can kill off intruding microorganisms and cancer cells. However, if T cells are not able to absorb enough vitamin D from the blood, they are unable to collaborate, attack, or develop immunity.
The groundbreaking Danish study is published in the science journal Nature, and the discovery sheds a whole new light on the general lack of vitamin D, which is something that needs to be addressed.

IMPORTANT

You will probably not notice if you are running low on vitamin D. However, you can be sure that your immune defense will.

A vitamin D deficiency increases the risk of TB and many other infections

Before the discovery of antibiotics, doctors gave tuberculosis patients vitamin D therapy by placing them outdoors in the sun or by giving them cod liver oil. However, science did not know anything about the underlying mechanisms.
Meanwhile, a number of studies have shown that low levels of vitamin D are linked to an increased risk of infections. A study of 19,000 people carried out during the period from 1988-1994 demonstrated that those with low vitamin D levels in their blood were more likely to get respiratory infections, even when the scientists adjusted for confounding factors such as the time of year, age, genes, BMI, and race.
Another study (of 800 Finnish soldiers) showed that those who had the lowest levels of vitamin D in their blood had more sick days due to respiratory infections compared with those who had the highest vitamin D levels.

Vitamin D supplements reduce influenza by 42-50 per cent

The use of vitamin D supplements as a means of prevention of influenza and other infections has produced contradictory results and caused confusion. Nonetheless, a meta-analysis conducted by scientists at the Queen Mary University of London has clarified matters. It turns out that those who have the lowest levels of vitamin D in their blood to begin with, benefit the most from taking a vitamin D supplement.
According to Professor Adrian Martineau, who headed the research, the greatest effect is seen with daily use of vitamin D. Vitamin D supplements have the potential to reduce the risk of acute respiratory infections by 50% in those who already have low levels of vitamin D.
The meta-analysis is published The BMJ, one of the world’s leading journals. It reveals how effective vitamin D supplements are, even when compared to vaccines. In fact, vaccines are only able to address one single type of influenza, whereas vitamin D strengthens the immune response against all microbes.
A double-blind, placebo-controlled study published in the American Journal of Clinical Nutrition in 2010 showed that school children had a 42% lower flu rate when they took supplements of vitamin D.

A blood sample can determine your vitamin D status

Blood levels of vitamin D are measured as 25-hydroxyvitamin. The official lower threshold value is 50 ng/ml, but many scientists believe this is insufficient and recommend as much as 75-100 ng/ml for optimal disease prevention.

Vitamin D also protects against inflammatory conditions like bronchitis, asthma, and aching joints

Vitamin D protects against bronchitis and asthma by means of two mechanisms: It strengthens the immune system, and it counteracts inflammation.
It is necessary for the body to be able to fight an infection. However, the immune system must not react too violently. If it does, we risk chronic conditions and tissue damage. Therefore, vitamin D is vital for preventing bronchitis, asthma, aching joints, and many other conditions that involve inflammatory response.
A study that is published in Nutrients in 2015 shows that vitamin D is both directly and indirectly involved in regulating T cells and their production of various signaling substances such as interferon and interleukin.

How much vitamin D do we need?

The reference intake (RI) for vitamin D varies slightly, depending on the country. However, health authorities generally recommend vitamin D supplements to children aged 0-2 years, pregnant women, children and adults with dark skin, people who do not spend time outdoors or are veiled, and residents at senior homes or people older than 70 years. New studies have shown that overweight individuals and diabetics also have an increased need for vitamin D.
Many researchers claim that the actual need for vitamin D is way above the reference intake level and suggest daily intake levels in the range of 30-100 micrograms. It is easy to synthesize this amount of vitamin D on a hot summer day, but during the winter we need supplements, as even a healthy and balanced diet only contributes with minimal amounts of the nutrient.

An overview of the immune system

Defense Non-specific (innate) Specific (adaptive)
Functions as Storm troops, messengers and trash collector.
Innate
Special troops that develop immunity.
Mature after birth.
Mechanical and biological Skin and mucosa.
Microflora
 
Specific compounds in the ”acute” phase Interferon
Complementary system
 
Direct cellular destruction Dendritic cells
NK cells
Phagocytes:
Granulocytes
Monocytes
Macrophages
T cells. Primarily responsible for virus, fungi, and abnormal cells.
B cells and antibodies. Primarily responsible for bacteria and toxins.

 

IMPORTANT

Echinacea, garlic, and other herbs may also strengthen the immune system, but they can never replace vitamin D. Our primary source of this nutrient is the sun (during the spring and summer season).

References

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

University of Copenhagen. Vitamin D crucial to activating immune Defences. 2010
http://news.ku.dk/all_news/2010/2010.3/d_vitamin/

Margherita T. Cantona et al. Vitamin D and 1,25 (OH)2D Regulation of T-cells. Nutrients 2015
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4425186/

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

University of Colorado Anschultz Medical Campus. Vitamin D reduces respiratory infections. ScienceDaily November 2016
https://www.sciencedaily.com/releases/2016/11/161116103005.htm

Cynthia Aranow. Vitamin D and the Immune system. J Investig Med. 2011
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3166406/

http://videnskab.dk/krop-sundhed/d-vitamin-er-immunforsvarets-batteri

Pernille Lund. Immunforsvarets nye ABC. Hovedland. 2012

  • Created on .
8.897MBMemory Usage471msRequest 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" => 1738540320 "last" => 1738540320...
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.41KB) (3.6ms)
  • afterInitialise (1.27MB) (78.92ms)
  • afterRoute (927.02KB) (25.57ms)
  • beforeRenderComponent com_content (22.94KB) (332μs)
  • Before Access::preloadComponents (all components) (35.84KB) (5.39ms)
  • After Access::preloadComponents (all components) (97.34KB) (839μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (26.48ms)
  • Before Access::getAssetRules (id:2700 name:com_content.article.1326) (130.65KB) (97μs)
  • After Access::getAssetRules (id:2700 name:com_content.article.1326) (7.38KB) (61μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (63.84ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (233μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (2.17ms)
  • afterRenderComponent com_content (67.95KB) (53.62ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.03KB) (17.59ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (36μs)
  • afterDispatch (29.84KB) (7.96ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (417μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (75.48KB) (93.52ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (31μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.65KB) (45.26ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (28μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (51μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (22μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.66KB) (6.34ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (38μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (41μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (7.16ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (56μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (16μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (1.69ms)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (25μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (48μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (21μ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) (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) (445μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (3.01ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (6μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (53μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift) (25.38KB) (6.65ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.16KB) (4.61ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (36μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (145μs)
  • afterRenderRawModule mod_custom () (21.95KB) (2.17ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (49μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (107μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.12ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (49μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.13ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.29KB) (555μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (42μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (179μs)
  • afterRenderRawModule mod_custom () (944B) (423μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.43KB) (31μs)
  • beforeRenderRawModule mod_custom () (688B) (94μs)
  • afterRenderRawModule mod_custom () (896B) (108μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (23μs)
  • afterRender (181.54KB) (5.45ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (75.48KB) (19.86%)
    93.52ms
    1 x afterInitialise (1.27MB) (16.76%)
    78.92ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (13.56%)
    63.84ms
    1 x afterRenderComponent com_content (67.95KB) (11.39%)
    53.62ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.65KB) (9.61%)
    45.26ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (5.63%)
    26.48ms
    1 x afterRoute (927.02KB) (5.43%)
    25.57ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.03KB) (3.74%)
    17.59ms
    1 x afterDispatch (29.84KB) (1.69%)
    7.96ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.52%)
    7.16ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (25.38KB) (1.41%)
    6.65ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.66KB) (1.35%)
    6.34ms
    1 x afterRender (181.54KB) (1.16%)
    5.45ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (1.14%)
    5.39ms
    1 x afterRenderRawModule mod_finder () (214.16KB) (0.98%)
    4.61ms
    1 x afterLoad (456.41KB) (0.76%)
    3.60ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.64%)
    3.01ms
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.46%)
    2.17ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.46%)
    2.17ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.45%)
    2.13ms
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.36%)
    1.69ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.24%)
    1.12ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.18%)
    839μs
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.12%)
    555μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.09%)
    445μs
    1 x afterRenderRawModule mod_custom () (944B) (0.09%)
    423μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.09%)
    417μs
    1 x beforeRenderComponent com_content (22.94KB) (0.07%)
    332μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.05%)
    233μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    179μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    145μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    108μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    107μs
    1 x Before Access::getAssetRules (id:2700 name:com_content.article.1326) (130.65KB) (0.02%)
    97μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    94μs
    1 x After Access::getAssetRules (id:2700 name:com_content.article.1326) (7.38KB) (0.01%)
    61μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    56μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    53μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    51μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    49μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    49μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    48μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    42μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    41μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    38μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    36μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    36μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    31μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    28μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    25μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0.01%)
    25μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    22μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    16μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    16μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    11μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique253ms1.35MB
  • SELECT @@SESSION.sql_mode;2ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?4ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 11.98ms1.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)5.01ms944BParams/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` = 1244μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`69μ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` = :guest137μ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`4.86ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.48ms2.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` = 13.34ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config1.94ms1.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`3ms165.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`268μ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` = 14.96ms848B/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)579μ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` = 011.34ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.05ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1326'3.96ms48B/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.77ms38.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`375μ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)4.57ms4.08KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`895μ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 ASC329μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id191μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id67μ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`8.66ms180.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 DESC39.56ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.41ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.65ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0893μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.99ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.98ms1.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-02 23:52:00') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-02 23:52:00') AND c2.state = 13.97ms4KBParams/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 1082.72ms195.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-02 23:52:00', 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 1043.79ms2.66KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray6,:preparedArray7) ORDER BY a.created ASC LIMIT 102.44ms159.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`1.1ms3.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` = :id133μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1185μ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)140μ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 ASC350μ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)132μ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` = 1143μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?100μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.12ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy