Skip to main content

Vitamin C for the brain and the cognitive skills

Vitamin C for the brain and the cognitive skillsMost people think of vitamin C in connection with the immune defense, but as it turns out, the largest concentration of vitamin C is actually found in the brain. This is because vitamin C is enormously important for the energy turnover, the nervous system, and the cognitive skills, and this is described in a new review article. There is also evidence of widespread vitamin C deficiency, which may eventually impair cognitive skills and increase the risk of dementia and Alzheimer’s disease. If a pregnant woman lacks vitamin C, it can disrupt the development of the baby’s brain. There is a number of factors that increase our need for the nutrient, so the big question is how much do we need to secure optimal brain function throughout life?

The human brain consumes massive amounts of vitamin C. The nutrient is important for the energy turnover, and it helps the neurons produce thoughts and feelings and supports movements and other functions. Vitamin C is also an important antioxidant that protects the neurons against oxidative stress. It has many other functions that relate to our physical and mental health, and many of these functions became known after Linus Pauling and W. A. Havorth were awarded the Nobel Prize in 1937 for the discovery and extraction of this essential vitamin.

Vitamin C’s many roles in the nervous system

Vitamin C is involved in the maturation of various neurons and the formation of lipid-containing myelin sheaths that protect our neurons and enhance the transmission of impulses between neurons. That is why vitamin C is so important for our cognitive skills.
Vitamin C is also important for the synthesis of neurotransmitters and the conversion of dopamine to serotonin that is crucial for our feeling of well-being and positively motivated actions. Science has known for a long time that vitamin C is a constituent of the collagen in connective tissue that is essential for the structure of our blood vessels, skin, gums, and bones. In the old days, thousands of sailors died of scurvy, which is the extreme consequence of being vitamin C-deficient and manifests itself as internal bleeding. The initial symptoms of scurvy are fatigue, mood swings, and depression, and these symptoms are rooted in the brain and nervous system.

  • Vitamin C is also called ascorbic acid
  • The brain contains around 100 times more vitamin C than the blood
  • The brain has a formidable ability to fetch vitamin C from the bloodstream

Blood levels of vitamin C are related to cognitive skills

During the period between 1980 and 2017, Australian scientists reviewed 50 studies that compared blood levels of vitamin C with cognitive functions such as language, learning skills, concentration, memory and orientation. The scientists took blood samples and measured the different cognitive functions, using a questionnaire called Mini Mental State Examination (MMSE). They found a significant correlation. First of all, those study participants whose cognitive skills remained intact, had significantly higher levels of vitamin C in their blood compared to study participants with cognitive impairment.
Other studies have shown that impaired immune defense, fatigue, depression, bruising, and poor wound healing are a sign of being vitamin C-deficient. A Danish research article published in the journal Aktuel Videnskab has suggested that maternal vitamin D deficiency may harm the development of the fetus.

Most animals are able to synthesize vitamin C, but humans, apes, guinea pigs, and bats have lost this ability due to evolutionary changes and depend on getting the nutrient from their diets.

Even minor deficiencies may harm the nervous system in the long run

According to the Australian review article, even minor deficiencies of vitamin C in the blood may result in weakened cognitive skills, whereas increasing your vitamin C levels may have the opposite effect. Study participants with insufficient levels of vitamin C in their blood were twice as likely to develop cognitive impairment compared with the participants that had enough vitamin C.
Several studies of short-term vitamin C supplementation have showed conflicting results, so it seems likely that it is primarily a chronic vitamin C deficiency that causes loss of neurons in connection with dementia and other psychiatric disorders.

It is interesting to consider that fatigue, bad mood, and depression are known as early but non-specific signs of being vitamin C-deficient.

Vitamin C protects against oxidative stress, dementia, and Alzheimer’s disease

Oxidative stress is when the balance between harmful free radicals and protective antioxidants is disturbed. Free radicals are aggressive molecules that attack the lipids in cell membranes, setting off a chain reaction. The myelin sheaths of the neurons are particularly vulnerable to such attacks. We are all exposed to free radicals, and the free radical burden is heavily increased by stress, poisoning, ageing processes, and radiation. Both dementia and Alzheimer’s disease are conditions that are characterized by oxidative damage to brain cells caused by free radicals.
Oxidative stress activates certain enzymes that promote the formation and accumulation of beta-amyloid plaque, a type of protein that is involved in the development of Alzheimer’s disease.
Oxidative stress prevents the clearance of toxic compounds and metabolic waste products from the brain, thereby increasing the risk of inflammation and cellular death. At the same time, it reduces the ability of neurons to burn glucose, which is their primary fuel. Our only way of protecting ourselves against oxidative damage is by getting enough antioxidants such as vitamins A, C, and E plus selenium, zinc, and various plant compounds.

Lack of vitamin C is rather common

There is widespread vitamin C deficiency. The CHALICE study from New Zealand showed that 62 percent of 50-year-olds from all income levels have too little vitamin C in their blood. The scientists also found a relation between cognitive functioning and blood levels of vitamin C.
Deficiency and poor utilization of vitamin C may be caused by unhealthy diets, stress, smoking, poisoning, lesions, ageing processes, and abuse of alcohol and narcotic drugs. Consuming too much sugar is also a risk factor, as sugar and vitamin C compete for the same channels that lead into the cells. The more sugar you consume, the more it reduces the effect of vitamin C.

Vitamin C content in mg/100 grams

  • Parsley 308
  • Red bell pepper, raw 191
  • Broccoli, raw 121/frozen 56
  • Orange 60
  • Apple and carrot 8

How much do we need?

Fresh fruit, vegetables, herbs, and berries are good sources of vitamin C. However, a large amount of the nutrient is lost when you freeze, cook, or fry the food or store it for a long time. The reference intake (RI) for vitamin C in Denmark is 80 mg for adults and children older than 11 years of age. This may not be enough to cover our actual need though. If you have a healthy lifestyle without too much stress, tobacco, and stimulants, eating six daily servings of fruit and vegetables or a daily multivitamin is considered enough. Still, studies of more recent date show that even minor vitamin C deficiencies can cause serious changes to the brain. Vulnerable groups such people with chronic stress, smokers, older people, substance abusers, pregnant and breastfeeding women, and children with smoking parents should consume more than the officially recommended amount of vitamin C. Most multivitamins contain around 80-100 mg of vitamin C, whereas vitamin C supplements are more likely to contain 500-750 mg – or more. Make sure to choose a supplement with non-acidic vitamin C (calcium ascorbate) that is gentle towards the stomach.

Vitamin C in the brain

  • Vitamin C is primarily concentrated in the cerebral cortex
  • Vitamin C is important for the conversion of glucose into energy
  • Vitamin C helps mature neurons and form myelin sheaths
  • Vitamin C is a co-factor in the synthesis of neurotransmitters
  • Vitamin C modulates the release and reuptake of neurotransmitters
  • Vitamin C helps convert serotonin to dopamine
  • Vitamin C prevents glutamate from causing neural overstimulation
  • Vitamin C helps maintain healthy blood vessels
  • Vitamin C is an antioxidant that protects the brain against oxidative stress

 

Important: Our brain function depends on many factors such as diet, physical activity, and mental challenges.

References:

Hara Estroff Marano. Psychology Today 2018

Pernille Tveden-Nyborg og Jens Lykkesfeldt. Vitaminer til hjernen. Aktuel Naturvidenskab, nr. 4 2016

http://www.medicinnoter.dk/dopamin-systemet/

http://www.b.dk/nationalt/danskerne-spiser-mindre-frugt-og-groent

  • Created on .
8.905MBMemory Usage646msRequest 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
array:1 [ "8c48c4b25e7bfaf1e1e1af15958abb70" => "mjp5mfhbdf2vcqi1pmn32bk9i2" ]
$_SERVER
array:47 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1741928490 "last" => 1741928490...
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-US" ]
  • afterLoad (456.53KB) (2.45ms)
  • afterInitialise (1.28MB) (32.54ms)
  • afterRoute (926.49KB) (12.72ms)
  • beforeRenderComponent com_content (23.25KB) (428μs)
  • Before Access::preloadComponents (all components) (35.84KB) (1.43ms)
  • After Access::preloadComponents (all components) (97.34KB) (1.46ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (22μs)
  • After Access::preloadPermissions (com_content) (3.22MB) (10.52ms)
  • Before Access::getAssetRules (id:4130 name:com_content.article.2040) (130.65KB) (114μs)
  • After Access::getAssetRules (id:4130 name:com_content.article.2040) (7.38KB) (78μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (112ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (260μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (92μs)
  • afterRenderComponent com_content (63.98KB) (71.16ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.02KB) (17.88ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (35μs)
  • afterDispatch (17.71KB) (1.94ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (2.38ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (170ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (28μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.29KB) (158ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (31μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (54μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (23μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.64KB) (11.13ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (31μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (43μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (26μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (26μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.47ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (71μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (25μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (22μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (17μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (19μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (1.52ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.61ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (6μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (64μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (3.41ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (23μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (12μs)
  • afterRenderRawModule mod_finder () (214.53KB) (8.28ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (38μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (145μs)
  • afterRenderRawModule mod_custom () (21.95KB) (1.35ms)
  • beforeRenderModule mod_custom () (704B) (7μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (115μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.73ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (60μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (724μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (30μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (9μs)
  • afterRenderRawModule mod_finder () (6.29KB) (3.5ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (56μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (189μs)
  • afterRenderRawModule mod_custom () (944B) (141μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (27μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (108μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (23μs)
  • afterRender (173.73KB) (8.59ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (26.39%)
    170.43ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.29KB) (24.45%)
    157.89ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (17.39%)
    112.35ms
    1 x afterRenderComponent com_content (63.98KB) (11.02%)
    71.16ms
    1 x afterInitialise (1.28MB) (5.04%)
    32.54ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.02KB) (2.77%)
    17.88ms
    1 x afterRoute (926.49KB) (1.97%)
    12.72ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.64KB) (1.72%)
    11.13ms
    1 x After Access::preloadPermissions (com_content) (3.22MB) (1.63%)
    10.52ms
    1 x afterRender (173.73KB) (1.33%)
    8.59ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.28%)
    8.28ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (0.69%)
    4.47ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.54%)
    3.50ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (0.53%)
    3.41ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.4%)
    2.61ms
    1 x afterLoad (456.53KB) (0.38%)
    2.45ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.37%)
    2.38ms
    1 x afterDispatch (17.71KB) (0.3%)
    1.94ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.27%)
    1.73ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.23%)
    1.52ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.23%)
    1.46ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.22%)
    1.43ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.21%)
    1.35ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.11%)
    724μs
    1 x beforeRenderComponent com_content (23.25KB) (0.07%)
    428μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.04%)
    260μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    189μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.02%)
    145μs
    1 x afterRenderRawModule mod_custom () (944B) (0.02%)
    141μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    115μs
    1 x Before Access::getAssetRules (id:4130 name:com_content.article.2040) (130.65KB) (0.02%)
    114μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    108μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.01%)
    92μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    80μs
    1 x After Access::getAssetRules (id:4130 name:com_content.article.2040) (7.38KB) (0.01%)
    78μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    71μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    64μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    60μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    56μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    56μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    54μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    43μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    38μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    35μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0%)
    31μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0%)
    31μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0%)
    30μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0%)
    28μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    27μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    26μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    26μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    25μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    23μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    23μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    22μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    19μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    18μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    17μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    15μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    13μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    12μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique421ms1.33MB
  • SELECT @@SESSION.sql_mode;79μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?181μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1176μs1.31KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `has_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id2.86ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `has_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1303μs1.56KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`132μ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` = :guest202μ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`639μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC242μ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` = 1177μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config247μ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`937μ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`317μ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` = 1296μ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.11ms7.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` = 05.54ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`797μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2040'2.48ms48B/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)557μ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`422μ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.22ms4.09KBParams/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`767μ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.78ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.99ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id4.38ms1.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.24ms180.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 DESC48.57ms161.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`900μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1647μ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` = 04.79ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id129μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id99μ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-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-03-14 05:01:33') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-14 05:01:33') AND c2.state = 11.57ms3.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 a.title ASC LIMIT 10161ms195.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 `tag_date` > DATE_ADD('2025-03-14 05:01:33', INTERVAL -1 YEAR) 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 10153ms2.66KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • 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`.`catid` IN (:preparedArray5) 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 (:preparedArray6,:preparedArray7) ORDER BY a.created ASC LIMIT 104.87ms159.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.38ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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` = :id171μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1196μ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)1.18ms584B/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 ASC763μ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)163μ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` = 12.53ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?130μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.87ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy