Skip to main content

Vitamin A supports the lungs’ immune defense against tuberculosis

Vitamin A supports the lungs’ immune defense against tuberculosisTuberculosis is one of the most common diseases in the world and costs millions of lives, especially in the underdeveloped countries. Tuberculosis typically goes hand in hand with malnutrition, and now a group of scientists from Dublin in Ireland has found that vitamin A helps the lungs’ immune defense fight the disease. Their research is published in the esteemed Journal of Respiratory Cell and Molecular Biology.

Tuberculosis, TB or MTB, is the infectious disease that kills most people worldwide. The disease is caused by different strains of mycobacteria that are particularly likely to attack the lungs. Tuberculosis is airborne, and most TB infections are latent and have no symptoms. However, it may become active in people with compromised immune systems, causing classic symptoms such as chronic cough with blood-containing sputum, fever, night sweats, and weight loss. Experts assume that a third of the world’s population is infected with TB. In 2016, the disease caused 1.7 millions deaths. TB is difficult to treat, among other reasons because the bacteria are able to survive for years inside the white blood cells. Because of the increasing problem with antibiotic resistance, which is caused by multi-resistant bacteria, new strategies for prevention and treatment are needed.

Widespread vitamin A deficiency keeps a global epidemic going

There is widespread vitamin A deficiency worldwide, and this in itself can cause a tenfold increase in the risk of developing the disease. It is very common for TB patients to have low vitamin A levels. This problem makes it difficult to fight the global epidemic, but science has still not managed to find the exact mechanisms through which vitamin A offers protection against the disease. Apparently, new findings shed a light on this.

According to a WHO report, 190 million people worldwide suffer from vitamin A deficiency, which can result in blindness, tuberculosis, and chronic damage to the lungs and other organs. Liver, eggs, and oily fish are good vitamin A sources, but a daily carrot can actually cover your need for the nutrient.

How vitamin A counteracts TB

The team of scientists from Trinity College and St. James’s Hospital in Dublin have shown for the very first time how vitamin A effectively supports the lungs’ immune defense and helps it fight against TB. Inside the lungs are some white blood cells called macrophages. Their task is to attack and break down airborne infectious germs that we breathe in. As mentioned before, tuberculosis bacteria are rather resistant and are able to survive inside the white blood cells, which means that the disease can easily remain latent for a long time without causing any symptoms. The scientists have now managed to identify those mechanisms that vitamin A uses to support a process inside the vacuoles (small spherical cavities) of the macrophages. The process is called autophagy (self-digestion), and what happens is that bacteria such as TB and other infectious germs are engulfed and broken down. Autophagy is an immune-stimulating and self-cleansing process inside the macrophages, which is essential for us humans and for our ability to effectively resist and fight infections. The discovery of how vitamin A supports autophagy inside the macrophages may lead to better prevention and treatment of TB in the future.

Vitamin A also counteracts other infections and inflammation

The immune system is designed to fight infections swiftly and effectively. However, it is important that the immune defense does not overreact, as that may increase the risk of chronic inflammation and local tissue damage (autoimmune reaction). The scientists from Trinity College and St. James’s Hospital in Dublin have demonstrated on an earlier occasion how vitamin A helps the immune defense fight other respiratory infections such as whooping cough, and counteract inflammation.

Autophagy is like cellular detox

All cells are able to carry out autophagy when cleansing themselves. The process is particularly important for macrophages, as they serve as the “street patrols” and “garbage collectors” in the lungs and in the blood.

From lab tests to global treatment of vitamin A deficiency

According to Dr. Sharee Badeo, who headed the Irish study, tuberculosis is still a global problem that affects millions of people worldwide. At the same time, vitamin A deficiency is very common and a major cause of the TB epidemic. Therefore, what is needed now is to take the results from the lab to the next level, and the scientists plan to include vitamin A supplements as part of the current medical treatment for TB.

Vitamin A sources

Retinol
Pure vitamin A from the animal kingdom

Beta-carotene
Vitamin A precursor from the plant kingdom
Is found in animal sources such as cod liver, liver, butter, cheese, egg yolk, and oily fish Found in vegetable sources like carrots, rosehips, parsley, green cabbage, spinach, tomatoes, and bell pepper
The strongest type of vitamin A
12 times stronger effect than with beta-carotene. Can be overdosed.
The weakest type of vitamin A, but a powerful antioxidant.
The need for beta-carotene is correspondingly greater. Cannot be overdosed.

Deficiencies and poor utilization of vitamin A may be caused by:

  • Unhealthy diet
  • HIV and chronic infections
  • Ageing processes
  • Alcoholism
  • Impaired lipid absorption due to gastrointestinal disease or the use of medical drugs
  • Diabetes and a lacking ability to convert beta-carotene into retinol
  • Prolonged use of antacids
  • Pregnancy and lactation

References

New study shows how vitamin A effectively supports lung immunity against TB. News Medical Life Sciences June 14, 2018
https://www.news-medical.net/news/20180614/New-study-shows-how-vitamin-A-effectively-supports-lung-immunity-against-TB.aspx

Lama A et al. Role of apoptosis and autophagy in tuberculosis. PubMed.gov 2017
https://www.ncbi.nlm.nih.gov/pubmed/28495854

https://en.wikipedia.org/wiki/Autophagy

Kristian Sjøgren. A-vitamin: Derfor er den helt rette mængde essentiel. Videnskab.dk 2017
https://videnskab.dk/krop-sundhed/historien-om-a-vitamin-derfor-er-den-helt-rette-maengde-essentiel

https://da.wikipedia.org/wiki/Tuberkulose

Pernille Lund. Immunforsvarets nye ABC. Hovedland 2012

  • Created on .
8.821MBMemory Usage447msRequest 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" => 1743423443 "last" => 1743423443...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.5KB) (798μs)
  • afterInitialise (1.27MB) (43.12ms)
  • afterRoute (897.2KB) (13.59ms)
  • beforeRenderComponent com_content (22.58KB) (323μs)
  • Before Access::preloadComponents (all components) (33.23KB) (260μs)
  • After Access::preloadComponents (all components) (97.34KB) (5.16ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (27μs)
  • After Access::preloadPermissions (com_content) (3.23MB) (13.34ms)
  • Before Access::getAssetRules (id:3546 name:com_content.article.1761) (130.65KB) (130μs)
  • After Access::getAssetRules (id:3546 name:com_content.article.1761) (7.38KB) (69μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (72.43ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (235μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (4.7KB) (99μs)
  • afterRenderComponent com_content (56.86KB) (42.29ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (9.56ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (37μs)
  • afterDispatch (24.8KB) (3.59ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (516μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (69.88KB) (107ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (43μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (918μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Search) (45.65KB) (94.6ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (1.05ms)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (59μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (14μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (52μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (4.38ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (64μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (15μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (25μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (22μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (10μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (21μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (20μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (601μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (3.84ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (3μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (61μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift) (19.78KB) (2.54ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (7μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (26μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (15μs)
  • afterRenderRawModule mod_finder () (128.59KB) (4.96ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (3.29KB) (43μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (268μs)
  • afterRenderRawModule mod_custom () (21.95KB) (2.07ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.23KB) (77μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (139μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.19ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (6μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (72μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (24μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (3.37ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (52μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (11μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.39ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (3.73KB) (69μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (201μs)
  • afterRenderRawModule mod_custom () (944B) (172μs)
  • beforeRenderModule mod_custom () (704B) (15μs)
  • afterRenderModule mod_custom () (2.43KB) (31μs)
  • beforeRenderRawModule mod_custom () (688B) (83μs)
  • afterRenderRawModule mod_custom () (896B) (919μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.71KB) (31μs)
  • afterRender (195.54KB) (6.66ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (69.88KB) (23.96%)
    107.00ms
    1 x afterRenderRawModule mod_tags_popular (Search) (45.65KB) (21.18%)
    94.60ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (16.22%)
    72.43ms
    1 x afterInitialise (1.27MB) (9.66%)
    43.12ms
    1 x afterRenderComponent com_content (56.86KB) (9.47%)
    42.29ms
    1 x afterRoute (897.2KB) (3.04%)
    13.59ms
    1 x After Access::preloadPermissions (com_content) (3.23MB) (2.99%)
    13.34ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (2.14%)
    9.56ms
    1 x afterRender (195.54KB) (1.49%)
    6.66ms
    1 x After Access::preloadComponents (all components) (97.34KB) (1.15%)
    5.16ms
    1 x afterRenderRawModule mod_finder () (128.59KB) (1.11%)
    4.96ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (0.98%)
    4.38ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.86%)
    3.84ms
    1 x afterDispatch (24.8KB) (0.8%)
    3.59ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.75%)
    3.37ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (19.78KB) (0.57%)
    2.54ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.46%)
    2.07ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.31%)
    1.39ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.27%)
    1.19ms
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.24%)
    1.05ms
    1 x afterRenderRawModule mod_custom () (896B) (0.21%)
    919μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.21%)
    918μs
    1 x afterLoad (456.5KB) (0.18%)
    798μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.13%)
    601μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.12%)
    516μs
    1 x beforeRenderComponent com_content (22.58KB) (0.07%)
    323μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.06%)
    268μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.06%)
    260μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.05%)
    235μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.05%)
    201μs
    1 x afterRenderRawModule mod_custom () (944B) (0.04%)
    172μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.03%)
    139μs
    1 x Before Access::getAssetRules (id:3546 name:com_content.article.1761) (130.65KB) (0.03%)
    130μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.7KB) (0.02%)
    99μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    83μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    77μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.02%)
    72μs
    1 x After Access::getAssetRules (id:3546 name:com_content.article.1761) (7.38KB) (0.02%)
    69μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.02%)
    69μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    64μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    61μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    59μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0.01%)
    52μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    52μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    43μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    43μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    37μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    31μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    31μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0.01%)
    26μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    24μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    15μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    14μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique290ms1.12MB
  • SELECT @@SESSION.sql_mode;147μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?189μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1141μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)4.81ms944BParams/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` = 1289μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`894μ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` = :guest1.09ms1.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`570μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC212μ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` = 1166μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config198μ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`5.34ms165.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`504μ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` = 1352μ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)424μ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` = 08.24ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`3.72ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1761'3.06ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)1.56ms22.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.99ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)7.58ms4.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`460μ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 ASC511μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id608μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id179μ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`7.77ms180.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 DESC33.05ms161.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`403μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.42ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0434μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.61ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id110μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-03-31 12:17:23') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-31 12:17:23') AND c2.state = 11.6ms3.98KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 10100ms135.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`576μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray5,:preparedArray6) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 1591.97ms2.75KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id376μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1287μ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)264μ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 ASC584μ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)802μ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` = 1256μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`590μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?144μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?4.04ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy