Skip to main content

Is lack of vitamin C a global problem?

Is lack of vitamin C a global problem?Vitamin C is important for the immune system, the nervous system, energy turnover, connective tissue, hormone production, and numerous biochemical processes. Vitamin C is also an important antioxidant that protects cells and tissues against oxidative stress and hyperinflammation that cause virus infections to become dangerous. According to a new review article that is published in Nutrients, lack of vitamin C is widespread in underdeveloped, low-income countries but also occurs in industrialized countries with higher income levels. Also, the majority of Danes fail to consume the recommended amount of fruit and vegetables that are rich in vitamin C, plus a number of factors can increase the need for the nutrient.

Vitamin C, also known as ascorbic acid, is a nutrient that most animals are able to synthesize as needed. But humans, apes, bats, and certain other animals have lost this ability through evolution. Vitamin C is water-soluble and can therefore not be stored in the body. This is why we need to ingest it regularly.
We use vitamin C to make collagen that is needed for the connective tissue in blood vessels, skin, gums, and bones. In old days, thousands of sailors died of scurvy, which is the extreme consequence of vitamin C deficiency and causes internal bleeding. Today, we know how to prevent scurvy with lemon juice or any other vitamin C source, and it is a very rare condition. On the other hand, subclinical scurvy is a rather common but overlooked problem that gives our connective tissue a loose structure, which can cause bruising, bleeding gums, nosebleed, and poor wound healing. Lack of vitamin C can also give impaired immune resistance, anemia, cardiovascular disease, or affect the development and function of the brain.
Furthermore, vitamin C is a powerful antioxidant that protects the brain against oxidative stress caused by free radicals. The need for vitamin C increases during infection and stress. Vitamin C also helps counteract hyperinflammation, which is when the immune defense overreacts and attacks healthy tissue. This is particularly dangerous in cases with blood poisoning (sepsis), influenza, and coronavirus infections.

Lack of vitamin C is quite common – and we need more research

According to the new review article, we need more studies of the prevalence of vitamin C deficiency worldwide, even though vitamin C is already known to play a vital role in various types of disease. The study authors looked closer at the available science and conditions that are caused by too little vitamin C. They also looked at the dietary vitamin C intake in different populations. Still, valid epidemiological studies are missing from numerous countries, but based on the available data the authors are able to conclude that vitamin C deficiency is more widespread in underdeveloped low-income countries, and they even occur in industrialized, high-income countries.
They point out that more epidemiological studies are needed to confirm their findings and to understand what consequences the widespread vitamin C deficiencies may have for global health.

Vitamin C content in mg/100 gram

Hiprose, raw 840
Kale, raw 169
Red bell pepper, raw 163
Cauliflower, 76
Orange, 54
Strawberry, 40
Potato, 22
Apple, 8

How do we make sure to get enough vitamin C – and what causes deficiencies?

Fruit and vegetables are good sources of vitamin C, and if you stick with the dietary guidelines you are certain to get enough of the nutrient. Still, most Danes eat far too little fruit and vegetables, especially coarse vegetables like cabbage.
In addition, stress, high-performance sports, ageing, smoking, poisoning, lacerations, and overconsumption of alcohol and narcotic drugs increase your need for vitamin C. The same goes for sugar, which is because sugar and vitamin C compete for the same channels that lead into the cells. The more sugar you eat, the more it reduces the effect of vitamin C. Therefore, it is wise to limit your intake of sugar and other empty calories. Exposed groups such as older people, individuals with stress, smokers, drug abusers, and pregnant and breastfeeding women may need more than the recommended amount of vitamin C.
Normal multivitamins contain around 80-100 mg of vitamin C, whereas vitamin C supplements typically contain 500-1,000 mg. You may want to choose non-acidic forms of vitamin C like calcium ascorbate that are gentle towards the stomach lining.

A small example

In order to get the same amount of vitamin C as in a tablet (750 mg), you would need to eat around 12 oranges or 53 apples.

References

Sam Rowe and Anitra C. Carr. Global Vitamin C Status and Prevalence of Deficiency: A cause for Concern? Nutrients 6 July 2020

Yazdani Shaik BD and Pio Conti. Relation between Vitamin C, Mast cells and Inflammation. Journal of Nutrition & Food Sciences. 2016

Lester Packer, Jürgen Fuchs. Vitamin C in Health and Disease. University of California

Carr AC et al. Hypovitaminosis C and vitamin C deficiency in critically ill patients despite recommended enteral and parenteral intakes. Crit Care 2017

https://ernaeringsfokus.dk/raavarer/groentsager-og-frugt

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

  • Created on .
8.742MBMemory Usage416msRequest 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" => 1738541760 "last" => 1738541760...
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.38KB) (955μs)
  • afterInitialise (1.27MB) (31.41ms)
  • afterRoute (897.2KB) (12.15ms)
  • beforeRenderComponent com_content (24.01KB) (320μs)
  • Before Access::preloadComponents (all components) (33.23KB) (2.88ms)
  • After Access::preloadComponents (all components) (97.34KB) (1.67ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (23μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (16.95ms)
  • Before Access::getAssetRules (id:5491 name:com_content.article.2712) (130.65KB) (116μs)
  • After Access::getAssetRules (id:5491 name:com_content.article.2712) (7.38KB) (94μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (47.9ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (230μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (1.58ms)
  • afterRenderComponent com_content (52.26KB) (34.32ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.66KB) (5.48ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (30μs)
  • afterDispatch (17.78KB) (1.57ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (447μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.56KB) (96.97ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (28μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (46μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (13μs)
  • afterRenderRawModule mod_tags_popular (Search) (4.68KB) (120ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (26μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (44μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (12μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (24μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (6.71ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (105μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (26μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (88μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (20μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (35μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (16μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (28μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (12μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (25μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (2.94ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (192.54KB) (5.03ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (65μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift) (20.91KB) (3.55ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (7μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (23μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (12μs)
  • afterRenderRawModule mod_finder () (128.95KB) (3.78ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (160μs)
  • afterRenderRawModule mod_custom () (22.23KB) (3.63ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (54μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (115μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (2.86ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (51μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (21μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.19ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.09KB) (2.15ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.73KB) (50μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (227μs)
  • afterRenderRawModule mod_custom () (944B) (172μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (29μs)
  • beforeRenderRawModule mod_custom () (688B) (84μs)
  • afterRenderRawModule mod_custom () (896B) (97μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (23μs)
  • afterRender (192KB) (5.83ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (4.68KB) (28.77%)
    119.65ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.56KB) (23.32%)
    96.97ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (11.52%)
    47.90ms
    1 x afterRenderComponent com_content (52.26KB) (8.25%)
    34.32ms
    1 x afterInitialise (1.27MB) (7.55%)
    31.41ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (4.08%)
    16.95ms
    1 x afterRoute (897.2KB) (2.92%)
    12.15ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.61%)
    6.71ms
    1 x afterRender (192KB) (1.4%)
    5.83ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.66KB) (1.32%)
    5.48ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (192.54KB) (1.21%)
    5.03ms
    1 x afterRenderRawModule mod_finder () (128.95KB) (0.91%)
    3.78ms
    1 x afterRenderRawModule mod_custom () (22.23KB) (0.87%)
    3.63ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (20.91KB) (0.85%)
    3.55ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.71%)
    2.94ms
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.69%)
    2.88ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.69%)
    2.86ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.53%)
    2.19ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.52%)
    2.15ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.4%)
    1.67ms
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.38%)
    1.58ms
    1 x afterDispatch (17.78KB) (0.38%)
    1.57ms
    1 x afterLoad (456.38KB) (0.23%)
    955μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.11%)
    447μs
    1 x beforeRenderComponent com_content (24.01KB) (0.08%)
    320μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.06%)
    230μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.05%)
    227μs
    1 x afterRenderRawModule mod_custom () (944B) (0.04%)
    172μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.04%)
    160μs
    1 x Before Access::getAssetRules (id:5491 name:com_content.article.2712) (130.65KB) (0.03%)
    116μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.03%)
    115μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.03%)
    105μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    97μs
    1 x After Access::getAssetRules (id:5491 name:com_content.article.2712) (7.38KB) (0.02%)
    94μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.02%)
    88μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    84μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.02%)
    65μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    54μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    51μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.01%)
    50μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    46μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    44μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    35μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    34μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    30μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    28μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.01%)
    26μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0.01%)
    25μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0.01%)
    24μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    23μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    21μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    19μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    16μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
44 statements were executed, 9 of which were duplicates, 35 unique273ms1.19MB
  • SELECT @@SESSION.sql_mode;38μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?108μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 170μ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)2.02ms944BParams/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` = 1717μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`492μ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` = :guest4.31ms1.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`494μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC127μ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` = 1159μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config296μ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.44ms165.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`291μ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` = 1334μ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)415μ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.39ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`718μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2712'876μs48B/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.19ms22.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.63ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)4.18ms4.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`841μ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 ASC378μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id105μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id63μ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`5.46ms180.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 DESC23.69ms161.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`901μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1556μ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` = 0331μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id299μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id145μ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-03 00:16:00') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:16:00') AND c2.state = 1599μs3.97KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 1092.25ms215.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `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 15116ms2.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` = :id230μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1185μs640B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)136μ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 ASC805μ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)165μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `has_scheduler_tasks` AS `a` WHERE `a`.`state` = 1137μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `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`413μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?93μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.06ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy