Skip to main content

New analysis of historic study indicates that we need more vitamin C

New analysis of historic study indicates that we need more vitamin CDuring World War II, food supplies were scarce. At one point, English researchers wanted to find out how little vitamin C it would take to prevent the potentially lethal disease, scurvy. In order to do that, they carried out a drastic experiment that later served as basis for our current vitamin C recommendations. However, a recent analysis of this old study has revealed that the actual need for vitamin C is a lot greater than previously thought, suggesting that WHO raise the recommended daily intake level. The question is how much vitamin C do we really need and what good does the vitamin do?

Vitamin C is an important constituent of collagen, a protein with structural importance for our blood vessels, gums, bones, and skin. Vitamin C is also important for the immune defense and for wound healing. Moreover, vitamin C serves as an important antioxidant that protects cells and tissues against free radicals. Most animals are able to synthesize enough vitamin C to meet their own needs. Humans, on the other hand, have lost this ability to evolution. We depend on vitamin C from our diets, mainly from sources like fruit and vegetables. The most serious consequence of a vitamin C deficiency is scurvy, a condition that typically includes symptoms such as fatigue, bleeding gums, bruising and impaired immunity.

World War II had far-reaching consequences for vitamin C recommendations

During World War II, the most basic foods were scarce. For that reason, British scientists wanted to find out if the limited food rations in the navy’s lifeboats were sufficient for people to survive. Also, they wanted to know how much vitamin C the general population needed in order to avoid scurvy, which is the classic vitamin C deficiency disease.
In one of the experiments that took place at Sorby Research Institute in Sheffield, a team of volunteers were fed only what the navy had in its lifeboats. This grueling experiment resulted in more water and less food being carried in lifeboats.
Another extreme experiment that took place at Sorby Research Institute was carried out as a vitamin C depletion study. The experiment was initiated in 1944 and had far-reaching consequences for future vitamin C recommendations. The study included 20 people who were already living in the building where the studies took place. They were fed a diet with either 0, 10, or 70 mg of vitamin D daily for a period of nine months on average. Afterwards, their vitamin C stores were repleted.
Because of the scarcity of foods with high vitamin C during the war period, the purpose of this experiment was not as much to find out how much vitamin C is needed for optimal health as to establish how little it would take to avoid scurvy.
During the course of the study, the scientists inflicted experimental wounds upon the participants. Afterwards, they studied the strength of the scar tissue to assess vitamin C levels, as it is known that being vitamin C-deficient impairs wound healing and scar tissue formation. It was also known that prolonged problems with bleeding gums may be a sign of scurvy.
The researchers ended up concluding that 10 mg of vitamin C daily was a sufficient intake to ward off any signs of scurvy. Later on, their experiment served as basis for WHO’s recommendations that called for 45 mg of vitamin C per day.

A shocking study with life-threatening consequences

Philippe Hujoel, who is a practicing dentist and professor at the UW School of Dentistry in Washington, USA, calls the old vitamin C experiment shocking. In fact, Hujoel is behind a new analysis that has revealed that the provoked vitamin C deficiency ended up causing life-threatening conditions in some of the participants. Today, an experiment like that would never be allowed.
In collaboration with a researcher from Brigham and Women’s Hospital/Harward Medical School, Hujoel has conducted what can best be described as scientific detective work by exposing the old data to modern techniques and analyses that were unavailable to scientists in old days. The result of this work has just been published in The American Journal of Clinical Nutrition.

We need more vitamin C

Philippe Hujoel found that the old data from the historic vitamin C study, the one that served as basis for WHO’s recommendations, needs to be reevaluated. He suggests 90 milligrams of vitamin C daily (twice as much as WHO recommends) as an appropriate average intake for preventing poor wound healing and weak scar tissue formation.
Hujoel’s study also showed that it takes a long time to recover from severe vitamin C depletion and that it requires an even higher intake than the recommended one. Even daily ingestion of 90 milligrams of vitamin C was not enough to restore normal scar tissue strength in those participants that were exposed to massive vitamin C depletion.

How do we get enough vitamin C – and what causes deficiency?

In Denmark, the daily reference intake (RI) level for vitamin C for adults and children older than 11 years is 80 mg per day. According to the new study, that level needs to be increased. It should also be added that factors such as smoking, suffering from chronic disease, stress, ageing processes, poisoning, lesions, and an overconsumption of stimulants can increase the need for the nutrient. The same is the case with a large sugar intake. Vitamin C and sugar compete for the same channels that lead into the cells. The more sugar one eats, the more this can reduce the effect of vitamin C.
The best way to ensure an adequate intake of vitamin C is by eating a balanced diet with plenty of fruit and vegetables. Vitamin C supplements typically contain 500-1,000 mg of vitamin C, and it is a good idea to choose non-acidic forms of vitamin C such as calcium ascorbate that are gentle on the stomach.

A small calculation

In order to get the same amount of vitamin C as one tablet with 750 mg of the nutrient, you would have to eat around 12 oranges or 53 apples.

References

Philippe P Hujoel, et al. Vitamin C and scar strength: analysis of a historical trial and implications for collagen-related pathologies. The American Journal of Clinical Nutrition. 2021

University of Washington. New analysis of landmark scurvy study leads to update on vitamin C needs. ScienceDaily August 16, 2021

Frida - Fødevare ID: 2 (fooddata.dk)

  • Created on .
8.815MBMemory Usage711msRequest 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" => 1743426327 "last" => 1743426327...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.5KB) (1.86ms)
  • afterInitialise (1.27MB) (25.54ms)
  • afterRoute (897.2KB) (10.11ms)
  • beforeRenderComponent com_content (22.58KB) (827μs)
  • Before Access::preloadComponents (all components) (33.23KB) (533μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.55ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (23μs)
  • After Access::preloadPermissions (com_content) (3.23MB) (12.18ms)
  • Before Access::getAssetRules (id:6473 name:com_content.article.3201) (130.65KB) (135μs)
  • After Access::getAssetRules (id:6473 name:com_content.article.3201) (7.38KB) (79μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (41.72ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (186μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (80μs)
  • afterRenderComponent com_content (55.95KB) (25.61ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.88KB) (4.72ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (35μs)
  • afterDispatch (17.68KB) (2.45ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (517μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (97.74KB) (138ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (35μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (68μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (14μs)
  • afterRenderRawModule mod_tags_popular (Search) (46.28KB) (375ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (33μ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) (24μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (10.74ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (87μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (15μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (27μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (12μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (24μ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) (22μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (21μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (3.64ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (8.02ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (7μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (89μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (22μs)
  • afterRenderRawModule mod_languages (Sprogskift) (20.61KB) (7.8ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (7μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (25μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (15μs)
  • afterRenderRawModule mod_finder () (128.95KB) (8.11ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (3.29KB) (44μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (168μs)
  • afterRenderRawModule mod_custom () (21.95KB) (5.22ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.23KB) (77μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (144μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (3.03ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (8μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (79μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (24μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.04ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (7μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (48μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (15μs)
  • afterRenderRawModule mod_finder () (6.29KB) (10.03ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (3.73KB) (69μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (224μs)
  • afterRenderRawModule mod_custom () (944B) (1.26ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (2.43KB) (50μs)
  • beforeRenderRawModule mod_custom () (688B) (136μs)
  • afterRenderRawModule mod_custom () (896B) (154μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (25μs)
  • afterRender (165.84KB) (6.43ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (46.28KB) (52.75%)
    375.30ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (97.74KB) (19.4%)
    138.04ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (5.86%)
    41.72ms
    1 x afterRenderComponent com_content (55.95KB) (3.6%)
    25.61ms
    1 x afterInitialise (1.27MB) (3.59%)
    25.54ms
    1 x After Access::preloadPermissions (com_content) (3.23MB) (1.71%)
    12.18ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.51%)
    10.74ms
    1 x afterRoute (897.2KB) (1.42%)
    10.11ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (1.41%)
    10.03ms
    1 x afterRenderRawModule mod_finder () (128.95KB) (1.14%)
    8.11ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (1.13%)
    8.02ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (20.61KB) (1.1%)
    7.80ms
    1 x afterRender (165.84KB) (0.9%)
    6.43ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.73%)
    5.22ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.88KB) (0.66%)
    4.72ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (0.51%)
    3.64ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.43%)
    3.03ms
    1 x afterDispatch (17.68KB) (0.35%)
    2.45ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.29%)
    2.04ms
    1 x afterLoad (456.5KB) (0.26%)
    1.86ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.22%)
    1.55ms
    1 x afterRenderRawModule mod_custom () (944B) (0.18%)
    1.26ms
    1 x beforeRenderComponent com_content (22.58KB) (0.12%)
    827μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.07%)
    533μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.07%)
    517μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    224μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.03%)
    186μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.02%)
    168μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    154μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.02%)
    144μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    136μs
    1 x Before Access::getAssetRules (id:6473 name:com_content.article.3201) (130.65KB) (0.02%)
    135μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    89μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    87μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.01%)
    80μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    79μs
    1 x After Access::getAssetRules (id:6473 name:com_content.article.3201) (7.38KB) (0.01%)
    79μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    77μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.01%)
    69μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    68μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    52μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    50μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    48μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    44μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0%)
    35μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    35μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    33μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    27μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    25μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    25μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    24μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    23μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    21μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    20μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    15μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    15μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    14μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique569ms1.17MB
  • SELECT @@SESSION.sql_mode;137μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?189μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 169μ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)1.91ms944BParams/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` = 1296μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`543μ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` = :guest201μ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`787μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC268μ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` = 11.9ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config432μ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.45ms165.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`333μ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` = 1902μ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)1.12ms7.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` = 07.03ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.26ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3201'2.69ms48B/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)913μ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`507μ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)5.06ms4.06KBParams/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`468μ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 ASC1.15ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.29ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id158μ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.39ms180.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 DESC18.36ms161.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.88ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1171μ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` = 0396μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id88μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id175μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-03-31 13:05:27') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-31 13:05:27') AND c2.state = 1417μ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 10120ms183.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`3.3ms4KBParams/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`726μs3.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 15371ms2.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.23ms1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1269μ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)219μ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 ASC461μ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)4.2ms584B/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` = 1189μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?140μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?10.74ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy