Skip to main content

Lack of vitamin C increases the risk of osteoporosis – especially in patients with inflammatory bowel diseases

Lack of vitamin C increases the risk of osteoporosis – especially in patients with inflammatory bowel diseasesVitamin C is important for bone density. A deficiency of the nutrient actually increases the risk of osteoporosis. Patients suffering from Crohn’s disease, ulcerative colitis, and other inflammatory bowel diseases often lack vitamin C and that adds even more to their risk. It is also a problem when normal, healthy people eat a vitamin C-deficient diet, and it becomes even more critical when people with chronic bowel diseases eat a diet with too little vitamin C. Vitamin C has a number of other functions in the body that are of importance to the immune system and the gut flora. Also, our genes for utilizing vitamin C play a role, according to a new study from Poznan University and Human Genetics Polish Academy of Sciences in Poland.

When it comes to bone health, the major focus is concentrated on calcium and vitamin D, but vitamin C – also known as ascorbic acid – should also be included. Vitamin C is a constituent of collagen in connective tissue that is important for the structure of bones, blood vessels, gums, and skin. Vitamin C is also important for macronutrient turnover, the nervous system, iron uptake, the immune defense and wound healing. Vitamin C even functions as an important antioxidant that protects cells and the cardiovascular system against oxidative stress caused by free radicals. Good sources of vitamin C include cabbage, broccoli, red bell pepper, citrus fruits, kiwi, berries, new potatoes, horse radish, spinach, garlic, and herbs. Just for the record, cooking or storing food reduces its vitamin C content.
In Denmark, the so-called daily reference intake level for vitamin C is 80 mg for adults. According to the new Polish study, other recommendations go up as high as 200 mg or more because they take into account the fact that only part of the vitamin C from food or supplements is absorbed in the body.
Most animals have the ability to synthesize their own vitamin C. In the case of infections or stress, their endogenous production can increase manyfold. Correspondingly, it is likely that we humans are able to absorb more vitamin C in situations where have increased need for the nutrient.
The final consequence of vitamin C deficiency is scurvy. It is also known that lack of vitamin C may result in fatigue, bruising, bleeding gums, iron deficiency, impaired immunity, and cardiovascular disease. The Polish scientists have looked at how lack of vitamin C can cause changes in the extracellular matrix of bones and in blood vessels and tendons, all of which contribute to fragile bones. The new study is published in the science journal Nutrients.

The link between vitamin C deficiency, inflammatory bowel disease, and osteoporosis

Scientists, when looking at children and adults with inflammatory bowel diseases, have observed that the diets often contain less fruit and vegetables, which are good sources of vitamin C. In addition, these patients are more likely to become vitamin C-deficient because both their disease and the local inflammation impair the body’s nutrient uptake. It has been shown that patients with inflammatory bowel disease have lower levels of vitamin C in their blood than healthy individuals. This is a problem because vitamin C counteracts oxidative stress and accompanying inflammation.
The lack of vitamin C may also impair bone density and increase the risk of osteoporosis. On the other hand, a meta-analysis has shown that higher intake of vitamin C is associated with increased bone density in the femoral neck and the lumbar vertebrae. Similarly, higher intake of vitamin C may lower the risk of osteoporosis by 33 percent, according to other studies.
As mentioned, the daily reference intake level for vitamin C is 80 mg in Denmark. According to the Food and Nutrition Board (FNB), the safe upper intake level for vitamin C is 2,000 mg. Although most people tolerate vitamin C rather well, excessive intake may cause loose stools, diarrhea, and nausea. A good way to avoid this is by taking a supplement with a vitamin C source that is non-acidic and therefore gentle towards the gastrointestinal mucosa.

Medical therapy for treating inflammatory bowel diseases harm the bones

Various types of medicine are used to treat inflammatory bowel diseases. Corticosteroids are commonly used but they can decrease bone density, damage the bone structure, and thereby increase the risk of osteoporosis and bone fractures. Other types of medicine are also associated with side effects but their direct impact on bone tissue remains unclear.

Genetic background for lacking vitamin C

The body’s vitamin C supply depends on how much of the nutrient you get from the diet. The body’s ability to absorb and utilize the nutrient, however, is also a determining factor. This may hinge on factors like genes, enzyme activities, and chronic diseases. In their new article, the Polish scientists look closer at those proteins that carry vitamin C to different tissues in the body, they look at various antioxidant enzymes, and the metabolic processes of vitamin C that take place in the liver and kidneys. If the ability to utilize vitamin C is poor it may increase a person’s need for the nutrient, but we need more research to fully understand this.

Vitamin C and its effect on gut flora and inflammation in the bowel

The microorganisms keep each other in check in a very delicate balance. This is vital because certain types of microorganisms can cause disease if their number is too high or if they spread to areas where they do not belong. There is increasing awareness of the gut flora and its impact o inflammatory bowel disease. It has been seen that imbalances in the body’s microorganisms can influence the grade of inflammation and the autoimmune processes where the immune system attacks the intestinal mucosa.
On the other hand, it turns out that increased vitamin C intake may reduce the number of E. Coli bacteria at the same time as stimulating the growth of beneficial lactic acid bacteria such as Lactobacillus and Bifidobacterium in the intestines. Vitamin C also has a positive influence on the gut flora in pre-diabetic patients.
Studies show that vitamin C helps limit the production of pro-inflammatory cytokines in the intestines. As mentioned earlier, vitamin C is a structural component of the collagen in connective tissue and that also goes for the connective tissue in the intestines. As an antioxidant, vitamin C helps protect the local tissue against oxidative stress.

Conclusion

The scientists behind the new Polish study conclude that vitamin C has numerous roles in the body. It is directly involved in the structure and function of cells and tissues, while it has an indirect role as an antioxidant and a regulator of genes. Vitamin C is vital for the structure of bone tissue and for preventing osteoporosis.
Vitamin C is of particular importance to patients suffering from inflammatory bowel diseases, as they have an increased need for the nutrient. Still, more research is needed to close in on the vitamin doses that can give the best results.

Other useful tips for healthy bones

  • Eat a coarse, green and balanced diet
  • Make sure to get enough vitamin D, vitamin K2, calcium, and magnesium
  • Exercise regularly – preferably high-impact, weight-bearing exercises

References:

Alicja Eea Rataczak et al. Vitamin C Deficiency and the Risk of Osteoporosis in Patients with an Inflammatory Bowel Disease. Nutrients 2020

Johns Hopkins Medicine. Calcium supplements may damage the heart. ScienceDaily. 2016

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

Hara Estroff Marano. The Cognitive Benefits of Vitamin C. Psychology Today 2018

https://frida.fooddata.dk/food/lists/parameters/47?page=5#parameter47

  • Created on .
8.81MBMemory Usage1.45sRequest 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" => 1740281540 "last" => 1740281540...
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.75KB) (8.21ms)
  • afterInitialise (1.27MB) (109ms)
  • afterRoute (897.2KB) (30.64ms)
  • beforeRenderComponent com_content (24.01KB) (311μs)
  • Before Access::preloadComponents (all components) (33.23KB) (4.44ms)
  • After Access::preloadComponents (all components) (97.34KB) (5.03ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (22μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (46.27ms)
  • Before Access::getAssetRules (id:5635 name:com_content.article.2785) (130.65KB) (92μs)
  • After Access::getAssetRules (id:5635 name:com_content.article.2785) (7.38KB) (49μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (153ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (188μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (6.04KB) (171μs)
  • afterRenderComponent com_content (60.59KB) (148ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.04KB) (22.82ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (27μs)
  • afterDispatch (17.61KB) (3.43ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (553μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (96.41KB) (491ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (25μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (37μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (12μs)
  • afterRenderRawModule mod_tags_popular (Search) (46.21KB) (260ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (23μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (38μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (11μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (20μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (39.08ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (51μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (15μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (23μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (11μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (20μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (9μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (18μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (18μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (7.47ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (14.09ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (60μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (20.6KB) (13.41ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (31μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (10μs)
  • afterRenderRawModule mod_finder () (128.95KB) (25.14ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (3.29KB) (38μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (154μs)
  • afterRenderRawModule mod_custom () (22.33KB) (8.71ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (50μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (113μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (736μs)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (3μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (9.07ms)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (23μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (675μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (28μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (8μs)
  • afterRenderRawModule mod_finder () (6.09KB) (16.46ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.73KB) (50μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (206μs)
  • afterRenderRawModule mod_custom () (944B) (137μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (24μs)
  • beforeRenderRawModule mod_custom () (688B) (74μs)
  • afterRenderRawModule mod_custom () (896B) (83μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (20μs)
  • afterRender (174.14KB) (24.7ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (96.41KB) (33.74%)
    490.73ms
    1 x afterRenderRawModule mod_tags_popular (Search) (46.21KB) (17.88%)
    260.08ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (10.54%)
    153.33ms
    1 x afterRenderComponent com_content (60.59KB) (10.19%)
    148.29ms
    1 x afterInitialise (1.27MB) (7.48%)
    108.76ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (3.18%)
    46.27ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (2.69%)
    39.08ms
    1 x afterRoute (897.2KB) (2.11%)
    30.64ms
    1 x afterRenderRawModule mod_finder () (128.95KB) (1.73%)
    25.14ms
    1 x afterRender (174.14KB) (1.7%)
    24.70ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.04KB) (1.57%)
    22.82ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (1.13%)
    16.46ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.97%)
    14.09ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (20.6KB) (0.92%)
    13.41ms
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.62%)
    9.07ms
    1 x afterRenderRawModule mod_custom () (22.33KB) (0.6%)
    8.71ms
    1 x afterLoad (456.75KB) (0.56%)
    8.21ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.51%)
    7.47ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.35%)
    5.03ms
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.3%)
    4.44ms
    1 x afterDispatch (17.61KB) (0.24%)
    3.43ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.05%)
    736μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.05%)
    675μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.04%)
    553μs
    1 x beforeRenderComponent com_content (24.01KB) (0.02%)
    311μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.01%)
    206μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.01%)
    188μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.04KB) (0.01%)
    171μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.01%)
    154μs
    1 x afterRenderRawModule mod_custom () (944B) (0.01%)
    137μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.01%)
    113μs
    1 x Before Access::getAssetRules (id:5635 name:com_content.article.2785) (130.65KB) (0.01%)
    92μs
    1 x afterRenderRawModule mod_custom () (896B) (0.01%)
    83μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    74μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0%)
    60μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0%)
    51μs
    1 x afterRenderModule mod_custom () (1.23KB) (0%)
    50μs
    1 x afterRenderModule mod_finder () (3.73KB) (0%)
    50μs
    1 x After Access::getAssetRules (id:5635 name:com_content.article.2785) (7.38KB) (0%)
    49μs
    1 x afterRenderModule mod_finder () (3.29KB) (0%)
    38μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0%)
    38μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0%)
    37μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    31μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    27μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0%)
    25μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    23μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    23μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    23μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    22μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    20μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    20μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    18μ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%)
    12μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    9μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    8μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique989ms1.13MB
  • SELECT @@SESSION.sql_mode;48μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?511μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 186μ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)10.06ms944BParams/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` = 11.91ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`3.76ms656B/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.91ms1.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`529μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.98ms2.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` = 1137μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config2.44ms1.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`723μs165.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.97ms3.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` = 1181μ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)3.34ms7.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` = 024.02ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`3.99ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2785'6.78ms48B/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)895μ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`4.97ms3.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)19.58ms4.11KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`2ms3.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 ASC1.34ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.93ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.47ms1.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`21.13ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC101ms161.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.99ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 17.98ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 05.99ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.11ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.36ms1.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-23 03:32:21') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-23 03:32:21') AND c2.state = 12ms3.97KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 10460ms147.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`11.97ms4KBParams/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`1.94ms3.97KBParams/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 15250ms2.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` = :id1.02ms1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 12.83ms640B/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)2.91ms584B/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 ASC4.22ms4.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)4.55ms584B/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` = 12.02ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?1.27ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.42ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy