Skip to main content

Vitamin D’s role in gut health and in the prevention of intestinal diseases

Vitamin D’s role in gut health and in the prevention of intestinal diseasesMultiple studies have shown that vitamin D plays a key role in gut health by supporting the protective mucosa, the massive gut flora, the intestinal immune defense, and the regulation of inflammatory processes. According to a new review article published in Nutrients, lack of vitamin D, which is quite common, may therefore result in an increased risk of irritable bowel syndrome (IBS) and inflammatory bowel disease (IBD), which more and more people are affected by.

The digestive tract is the body’s largest organ in our digestive system and harbors the major part of our immune defense, which helps kill off harmful microbes and food toxins while controlling the enormous gut flora that harbors billions of different microorganisms. The gut flora plays a major role in breaking down our food and synthesizing vitamins, enzymes, neurotransmitters, lactic acid, and other important compounds. The gut flora and the immune system of the host must maintain the right balance to prevent potentially harmful bacteria and fungi from becoming dominant. Also, it is vital to prevent the immune attacks and local inflammatory processes from going into overdrive. If this delicate balance between the gut flora and the immune system is disrupted, it may cause gut flora imbalances, irritable bowel syndrome (IBS), and inflammatory bowel diseases (IBD) such as ulcerative colitis, and Crohn’s disease.
It is well known that antibiotics, excess sugar intake, unhealthy diets, and ageing can have a negative impact on the gut flora. The same goes for nutrient deficiencies, because both the gut flora and the immune defense need nutrients to function properly.
In their review article in Nutrients, the authors look at vitamin D’s role in all of this. Deficiencies of this vitamin are widespread and contribute to the growing rate of digestive problems and intestinal diseases. The following shows how vitamin D works in the gut flora and the immune defense:

  • It is considered a steroid hormone and helps activate and regulate numerous gene activities
  • All cells in the digestive tract have vitamin D receptors (VDR), indicating that vitamin D plays a key role in gut health
  • Vitamin D is important for the maintenance and the integrity of the intestinal mucosa and the epithelial cells that form a protective barrier
  • Vitamin D helps support and control the enormous gut flora, thereby ensuring that the beneficial microorganisms such as lactic acid bacteria and Bifido bacteria dominate, at the same time as suppressing potentially harmful microorganisms such as E. Coli, Streptococcus, and Candia Albicans
  • Vitamin D regulates the gut flora, thereby relieving the immune defense
  • Vitamin D supports different parts of the immune defense, including macrophages, T cells, and B cells that are all important for enabling the immune defense to attack and destroy microbes and toxins by means of “blitz attacks” or inflammatory reactions
  • Once the harmful microbes and toxins have been eliminated, vitamin D controls and shuts down the inflammatory processes to prevent them from causing local tissue damage and chronic inflammatory gut diseases like ulcerative colitis and Crohn’s disease

Studies of vitamin D supplements and their impact on gut health

A healthy gut flora is able to synthesize lithocholic aid (LCA) that enhances the absorption of vitamin D from food. Supplementation with 1,250 (50,000 IU) of vitamin D once every week for 12 weeks has been shown to significantly improve the diversity of the gut flora. Studies of overweight individuals have found a positive relation between beneficial Bifido bacteria and vitamin D. On the other hand, researchers have observed that vitamin D receptors in several potentially harmful gut bacteria were dialed down. Genes play a huge role.
Patients with inflammatory bowel diseases have obtained a positive effect of taking 1,000 micrograms (40,000 IU) of vitamin D once every week for eight weeks. This also resulted in a reduction of CRP (C-reactive protein), which is an inflammation marker.
As described in the review article, several studies have been conducted where very large doses of vitamin D have been administered once weekly to patients with various gut disorders. This should always be done under the guidance of a health professional. The European Food Safety Authority (EFSA) has established a safe upper intake level of 100 micrograms of vitamin D daily.
Other studies of vitamin D supplementation have not shown similar results, but it is important to note that vitamin D only has a therapeutic effect on people who are deficient to begin with. Also, the dose that is used must be large enough to optimize blood levels of vitamin D. An optimal level should ideally be above 75 nmol/L, and it is even better if it is around 100 nmol/L.

Why vitamin D deficiency is so widespread in inflammatory bowel disease

The sun during the summer period is our primary source of vitamin D. We synthesize the nutrient in our skin when a cholesterol precursor is exposed to UV-rays. Interestingly, the highest rate of inflammatory bowel diseases is found at northern latitudes, where the sun during the winter period sits too low in the sky to enable vitamin D synthesis. Other factors that can reduce vitamin D levels are ageing, having dark skin, spending too much time indoors, overusing sun factor cream, genetic factors, overweight, type 2 diabetes, and the use of cholesterol-lowering drug (statins). It has also been found that patients with inflammatory bowel diseases have difficulty with absorbing vitamin D from oily fish, cod roe, eggs, dairy products, and other vitamin D sources. Therefore, these individuals have an increased need for this vitamin.

Inflammatory bowel diseases are associated with

  • A derailed immune defense
  • Dysbioses – which are imbalances in the gut flora
  • Structural changes to the intestinal mucosa
  • Unhealthy diets and the use of antibiotics
  • Lack of vitamin D and/or other relevant nutrients

Referencer:

Jiaxin Wang et al. Contemporary Perspectives on the Role of Vitamin D in Enhancing Gut Health and Its Implications for Preventing and Managing Intestinal Diseases. Nutrients 2024

Lintao Dan et al. Circulating 25-hydroxyvitamin D concentration can predict bowel resection risk among individuals with inflammatory bowel disease in a longitudinal cohort with 13 years of follow-up. International Journal of Surgery. 2024

Antonia Topalova-Dimitrova et al. Lower vitamin D levels are associated with the pathogenesis of inflammatory bowel diseases. Medicine. 2023

Gominak SC. Vitamin D deficiency changes the intestinal microbiome reducing B Vitamin production in the gut. The resulting lack of pantothenic acid adversely affects the immune system, producing a “pro-inflammatory” state associated with atherosclerosis and autoimmunity. Med Hypotheses 2016


  • Created on .
9.405MBMemory Usage362msRequest 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" => 1740203114 "last" => 1740203114...
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.53KB) (1.58ms)
  • afterInitialise (1.27MB) (21.4ms)
  • afterRoute (897.2KB) (10.24ms)
  • beforeRenderComponent com_content (23.02KB) (1.27ms)
  • Before Access::preloadComponents (all components) (33.23KB) (239μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.41ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (9.35ms)
  • Before Access::getAssetRules (id:8843 name:com_content.article.4645) (130.65KB) (101μs)
  • After Access::getAssetRules (id:8843 name:com_content.article.4645) (7.38KB) (49μs)
  • beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.35MB) (35.21ms)
  • afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (587.68KB) (44.74ms)
  • beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (8μs)
  • afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (105μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (3.62KB) (40μs)
  • afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (217μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (5.07KB) (34μs)
  • afterRenderComponent com_content (43.67KB) (19.86ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.89KB) (3.22ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (30μs)
  • afterDispatch (47.86KB) (2.57ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (439μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (96.48KB) (76.08ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (37μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (47μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (14μs)
  • afterRenderRawModule mod_tags_popular (Search) (44.66KB) (105ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (28μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (52μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (11μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (5.31ms)
  • afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (67μ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) (1.27KB) (21μ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) (20μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (19μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (401μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (196.16KB) (4.11ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (62μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift) (82.23KB) (3.12ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (6.31KB) (25μs)
  • beforeRenderRawModule mod_finder () (7.34KB) (12μs)
  • afterRenderRawModule mod_finder () (64.59KB) (3.01ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (149μs)
  • afterRenderRawModule mod_custom () (21.95KB) (2.03ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (50μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (107μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.88ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (52μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (4.89KB) (1.24ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (35μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (12μs)
  • afterRenderRawModule mod_finder () (6.29KB) (2.22ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.23KB) (61μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (190μs)
  • afterRenderRawModule mod_custom () (944B) (140μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (27μs)
  • beforeRenderRawModule mod_custom () (688B) (84μs)
  • afterRenderRawModule mod_custom () (896B) (95μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (168.1KB) (3.46ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (44.66KB) (28.95%)
    104.82ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (96.48KB) (21.01%)
    76.08ms
    1 x afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (587.68KB) (12.36%)
    44.74ms
    1 x beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.35MB) (9.73%)
    35.21ms
    1 x afterInitialise (1.27MB) (5.91%)
    21.40ms
    1 x afterRenderComponent com_content (43.67KB) (5.49%)
    19.86ms
    1 x afterRoute (897.2KB) (2.83%)
    10.24ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (2.58%)
    9.35ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.47%)
    5.31ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (196.16KB) (1.13%)
    4.11ms
    1 x afterRender (168.1KB) (0.95%)
    3.46ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.89KB) (0.89%)
    3.22ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (82.23KB) (0.86%)
    3.12ms
    1 x afterRenderRawModule mod_finder () (64.59KB) (0.83%)
    3.01ms
    1 x afterDispatch (47.86KB) (0.71%)
    2.57ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.61%)
    2.22ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.56%)
    2.03ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.52%)
    1.88ms
    1 x afterLoad (456.53KB) (0.44%)
    1.58ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.39%)
    1.41ms
    1 x beforeRenderComponent com_content (23.02KB) (0.35%)
    1.27ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (4.89KB) (0.34%)
    1.24ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.12%)
    439μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.11%)
    401μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.07%)
    239μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (0.06%)
    217μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.05%)
    190μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.04%)
    149μs
    1 x afterRenderRawModule mod_custom () (944B) (0.04%)
    140μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.03%)
    107μs
    1 x afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (0.03%)
    105μs
    1 x Before Access::getAssetRules (id:8843 name:com_content.article.4645) (130.65KB) (0.03%)
    101μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    95μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    84μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (0.02%)
    67μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.02%)
    62μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.02%)
    61μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    52μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    52μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    50μs
    1 x After Access::getAssetRules (id:8843 name:com_content.article.4645) (7.38KB) (0.01%)
    49μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    47μs
    1 x beforeRenderRawModule mod_custom (Search for more information...) (3.62KB) (0.01%)
    40μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    37μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    35μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    35μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.07KB) (0.01%)
    34μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.01%)
    28μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    25μs
    1 x afterRenderModule mod_languages (Sprogskift) (6.31KB) (0.01%)
    25μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0.01%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    22μs
    1 x afterRenderModule mod_tags_popular (Search) (1.27KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0.01%)
    20μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0.01%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0.01%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (7.34KB) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (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%)
    10μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    1 x beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (0%)
    8μ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%)
    3μs
77 statements were executed, 39 of which were duplicates, 38 unique252ms1.21MB
  • SELECT @@SESSION.sql_mode;57μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?133μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 11.06ms1.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)2.27ms944BParams/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` = 1224μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`73μ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` = :guest142μ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`507μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC141μ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` = 1125μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config229μ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`1.96ms165.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`254μ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` = 1192μ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)398μ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` = 03.98ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`671μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '4645'2.79ms48B/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)576μs22.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`542μ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)3.14ms4.13KBParams/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`337μ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 ASC306μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id116μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id728μ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.05ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `t`.`id` FROM `has_tags` AS `t` INNER JOIN `has_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)8.02ms1.41KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,COUNT( `tag_id`) AS `count`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `cc` ON `m`.`core_content_id` = `cc`.`core_content_id` INNER JOIN `has_content_types` AS `ct` ON `m`.`type_alias` = `ct`.`type_alias` WHERE ( ( ( (`m`.`tag_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6) AND `t`.`access` IN (:preparedArray7,:preparedArray8) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray9,:preparedArray10) OR `cc`.`core_access` = 0)) AND (`m`.`content_item_id` <> :currentId OR `m`.`type_alias` <> :prefix)) AND (`cc`.`core_publish_up` IS NULL OR `cc`.`core_publish_up` = :nullDateUp OR `cc`.`core_publish_up` <= :nowDateUp)) AND (`cc`.`core_publish_down` IS NULL OR `cc`.`core_publish_down` = :nullDateDown OR `cc`.`core_publish_down` >= :nowDateDown) AND `cc`.`core_language` IN (:preparedArray11,:preparedArray12) GROUP BY `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` ORDER BY `count` DESC, RAND() LIMIT 1517.71ms20.66KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:200Copy
  • 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`315μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id145μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id91μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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` = :id62μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id62μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id51μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id53μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id62μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id57μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id66μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id142μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id70μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id60μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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` = :id94μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id90μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id77μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id61μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id56μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id50μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id52μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id48μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id57μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id48μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id54μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id48μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id133μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id74μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id78μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.38ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 DESC16.77ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1100μ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` = 0564μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id491μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id88μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-22 05:45:14') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-22 05:45:14') AND c2.state = 1919μs12.53KBParams/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 1068.48ms151.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.44ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`350μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT 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 15103ms2.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` = :id512μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1163μ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)206μ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.12ms4.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)749μ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` = 1132μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?111μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.29ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy