Skip to main content

Zinc’s important role in the brain and nervous system

Zinc’s important role in the brain and nervous systemWe have relatively large quantities of zinc in our central nervous system where it plays a vital role in various physiological and pathological processes. Zinc is also important for brain development, various gene activities, the formation of new neurons, and the immune defense. What is more, zinc is a vital antioxidant that protects the brain against calcification and cell damage caused by oxidative stress. Zinc deficiency is a global problem and may be involved in a number of different neurological diseases – including stroke, cognitive impairment, Alzheimer’s disease, and depression, according to a new review article that is published in Biomolecules.

Zinc is involved in hundreds of different enzyme processes, countless transport proteins (ZIPs), and over 2,800 transcriptional factors that make sure that around 10 percent of the cells’ gene activities are activated at the exact right time. This is why zinc is of vital importance to a host of different physiological processes that include the nervous system, the immune system, the hormone system, and apoptosis (programmed self-destruction of cells). Zinc also supports the very important antioxidant enzyme called SOD (superoxide dismutase) that protects our cells and tissues against free radical damage. Zinc also helps the body in its utilization of vitamin D and vitamin A.
Zinc is one of the must abundant trace elements in the central nervous system where it has many essential roles – from supporting the development of the fetus’ brain to handling various neurological functions throughout life. The brain’s zinc homeostasis, which is a measure of the local zinc balance, is controlled through a complex interplay between different components, including the blood-brain barrier, the activity of the zinc-binding proteins, and the activity of different transport proteins (ZIPs in particular) that carry zinc into our cells.
In the brain, zinc occurs in different forms, for example as zinc ions that are important for regulating neurons, synaptic plasticity, mental balance, learning, and memory.
In their review article, the authors looked at zinc homeostasis and its role in connection with brain health, stroke, brain traumas, and common neurological diseases such as Alzheimer’s disease and depression.

Zinc’s role in the formation of neurons

The formation of new cells and neurons (neurogenesis) plays a vital role in fetal development, which is why zinc is highly important for brain development. Being zinc-deficient during pregnancy and breastfeeding may have a negative impact on the child’s growth and lead to impaired learning skills and memory. It is therefore very important for pregnant and breastfeeding women to get plenty of zinc. In some cases, zinc supplementation can help preterm babies to improved growth and development. Our ability to form new neurons is important throughout life because our brain is more plastic than previously assumed.

Zinc’s role in oxidative stress and chronic disease

Oxidative stress is an imbalance between harmful free radicals and protective antioxidants. We humans generate free radicals as a natural byproduct of different metabolic processes, and it is vital that these free radicals are effectively controlled in order to prevent them from causing cellular damage. It is also potentially harmful if free radicals attack our essential cholesterol and lead to lipid peroxidation, which causes the cholesterol to attach to the blood vessel wall where it triggers inflammation.
Many chronic diseases that are seen in old age such as atherosclerosis, cancer, and dementia are associated with oxidative stress. In this connection, zinc’s important role in supporting superoxide dismutase (SOD) is crucial because of this antioxidant’s ability to protect the cell membranes. Moreover, zinc supports another important antioxidant called glutathione. This is why being zinc-deficient increases your risk of oxidative stress and various diseases later in life.

  • Zinc deficiency is a global problem and a contributing factor in many chronic diseases.

Zinc’s role in the immune system of the central nervous system

Zinc-deficient patients have an increased risk of different infections, which is because zinc is of great importance to the innate as well as the adaptive immune systems. Zinc’s role in the immune defense is also linked to zinc transport proteins (ZIPs). Overall, zinc helps regulate inflammatory processes and even a minor zinc deficiency can increase the release of pro-inflammatory cytokines such as TNF-α, IL-1, and IL-6. Most chronic diseases are characterized by chronic low-grade inflammation that is linked to oxidative stress.
In the central nervous system, we have microglia – a type of cells that are part of the innate immune defense. If the brain is exposed to infections or potentially harmful molecules, the microglia produce free radicals and pro-inflammatory cytokines. Studies suggest that zinc can prevent damage to the neurons by controlling the activity of the microglia.
Zinc’s role in stroke
Acute ischemic stroke is the most common type of stroke. Next to heart attacks, they are the most common cause of death worldwide. Acute ischemic stroke occurs when the blood supply to the brain is blocked by thrombotic or embolic occlusion of a cerebral artery. Other processes have also been seen such as neuroinflammation, microglia activation, and overactivation of neurotransmitters such as glutamate.
In connection with ischemic stroke, neurons may release too much zinc, thereby disrupting the brain’s zinc balance. This can cause free radical damage to cells. A zinc imbalance can also result in too little zinc being available for the undertaking of antioxidant actions. Scientists have observed that the zinc concentration in stroke patients is notably lower than the zinc concentration in healthy controls. Studies have also shown that zinc deficiency is linked to more serious cases of brain hemorrhage.

  • Zinc’s role in the brain and the central nervous system is highly complex
  • All functions are related to the zinc homeostasis

Zinc’s role in Alzheimer’s disease

Alzheimer’s disease is a neurodegenerative disease that affects around 37 million people worldwide. It is characterized by accumulated proteins (amyloid plaque and tau) in the brain that cause local inflammation and a degeneration of cells in the hippocampus, the amygdala, and the neocortex. It takes years for the disease to develop and it results in memory loss, impaired sense of direction and loss of other cognitive skills. Death normally occurs after some years. It has been found that people with Alzheimer’s disease have a disrupted zinc balance in the brain, and zinc tends to accumulate in the late stages of the disease. Also, abnormal changes have been observed in different zinc transporters. It is even possible that zinc is underrepresented as an antioxidant. Imbalances in the zinc homeostasis may possibly play a critical role in the development of Alzheimer’s disease.

Zinc’s role in brain traumas and less mortality

Brain traumas represent a serious health problem that affect around 70 million people every year. The most common causes are accidents, blows, and other types of mechanical damage to the brain tissue. The initial phase of a brain trauma is characterized by reduced blood supply, while the second phase can lead to brain edema, neuroinflammation, oxidative stress, mitochondrial dysfunction, tissue loss, and other harmful chain reactions. Brain traumas can cause a host of mental and motor symptoms and may be life-threatening in worse case.
During brain traumas, zinc plays a vital role in different metabolic processes and as an antioxidant. Scientists have looked at zinc supplements and their potential role in brain traumas. In their review article, the authors refer to a clinical study of 68 people with brain traumas. The participants were divided into two groups, where one group was given 12 mg of zinc daily, while the other group received 2.5 mg of zinc. One month after the trauma, the participants in the group that got the high zinc dose fared better than the low-dose group. Their mortality rate had been reduced by more than 50% (26% versus 12%). Similarly, animal studies have shown that zinc supplementation can improve recovery from brain trauma – including things like mood, learning skills, and memory

Zinc’s role in depression

Depression is a widespread chronic ailment that affects more and more people. It causes symptoms like fatigue, despair, sleep disturbances, and appetite problems. Most people fail to function well socially, and untreated depression is one of the leading causes of suicide.
Studies show that most people suffering from depression have low serum levels of zinc. This may cause changes in the function of the hippocampus and imbalances in the hypothalamic–pituitary–adrenal axis. Depression is also typically associated with chronic brain inflammation.
Thirty years ago, the first hypotheses about a link between zinc and depression surfaced. Animal studies showed that zinc deficiency caused depression-like conditions. On the other hand, zinc supplements could eliminate the symptoms.
Studies of humans have found an inverse relation between zinc levels in serum and the severity of depression. It also appears that women who get too little dietary zinc are more likely than men to have a depression.

Zinc sources and causes of deficiencies

  • We get zinc from oysters, liver, meat, dairy products, nuts, seeds, kernels, and beans
  • Zinc from animal sources has the best absorption in the body
  • Zinc deficiencies can be a result of unhealthy eating habits, ageing, large intake of calcium and/or iron, the use of diuretics, antacids, and ACE inhibitors for treating hypertension and cardiac insufficiency.

References:

Che Li et al. The Important Role of Zinc in Neurological Diseases. Biomolecules. 2023

Ashton Amos, Mohammed S. Razzaque. Zinc and its role in vitamin D function. Current Research in Physiology. 2022

  • Created on .
8.884MBMemory Usage215msRequest 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" => "ob11gtcj0elck7quonf86lmtqd" ]
$_SERVER
array:47 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1740247294 "last" => 1740247299...
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.59KB) (820μs)
  • afterInitialise (1.28MB) (14.01ms)
  • afterRoute (926.49KB) (6.44ms)
  • beforeRenderComponent com_content (23.38KB) (398μs)
  • Before Access::preloadComponents (all components) (35.84KB) (333μs)
  • After Access::preloadComponents (all components) (97.34KB) (848μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (23μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (5.46ms)
  • Before Access::getAssetRules (id:8063 name:com_content.article.4000) (130.65KB) (161μs)
  • After Access::getAssetRules (id:8063 name:com_content.article.4000) (7.38KB) (69μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (22.35ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (262μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (4.7KB) (107μs)
  • afterRenderComponent com_content (56.84KB) (15.15ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.03KB) (2.28ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (38μs)
  • afterDispatch (17.7KB) (958μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (619μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (44.94ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (37μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.04KB) (50.31ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (72μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (58μ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.66KB) (7.79ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (32μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (47μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.76ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (81μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (27μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (1.03ms)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (38μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (1.51ms)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (32μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (30μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (11μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (24μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (551μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (4.86ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (7μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (76μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (22μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (4.54ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (8μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (26μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (14μs)
  • afterRenderRawModule mod_finder () (214.53KB) (4.6ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (3.29KB) (42μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (980μs)
  • afterRenderRawModule mod_custom () (21.95KB) (2ms)
  • beforeRenderModule mod_custom () (704B) (8μs)
  • afterRenderModule mod_custom () (1.23KB) (69μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (1.14ms)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (781μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (61μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.78ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (43μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (13μs)
  • afterRenderRawModule mod_finder () (6.29KB) (4.45ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.23KB) (63μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (204μs)
  • afterRenderRawModule mod_custom () (944B) (169μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (27μs)
  • beforeRenderRawModule mod_custom () (688B) (82μs)
  • afterRenderRawModule mod_custom () (896B) (94μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (173.73KB) (5.01ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (6.04KB) (23.41%)
    50.31ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (20.91%)
    44.94ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (10.4%)
    22.35ms
    1 x afterRenderComponent com_content (56.84KB) (7.05%)
    15.15ms
    1 x afterInitialise (1.28MB) (6.52%)
    14.01ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.66KB) (3.62%)
    7.79ms
    1 x afterRoute (926.49KB) (3%)
    6.44ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (2.54%)
    5.46ms
    1 x afterRender (173.73KB) (2.33%)
    5.01ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.26%)
    4.86ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (2.21%)
    4.76ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (2.14%)
    4.60ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (2.11%)
    4.54ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (2.07%)
    4.45ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.03KB) (1.06%)
    2.28ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.93%)
    2.00ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.83%)
    1.78ms
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.7%)
    1.51ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.53%)
    1.14ms
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.48%)
    1.03ms
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.46%)
    980μs
    1 x afterDispatch (17.7KB) (0.45%)
    958μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.39%)
    848μs
    1 x afterLoad (456.59KB) (0.38%)
    820μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.36%)
    781μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.29%)
    619μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.26%)
    551μs
    1 x beforeRenderComponent com_content (23.38KB) (0.19%)
    398μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.15%)
    333μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.12%)
    262μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.09%)
    204μs
    1 x afterRenderRawModule mod_custom () (944B) (0.08%)
    169μs
    1 x Before Access::getAssetRules (id:8063 name:com_content.article.4000) (130.65KB) (0.07%)
    161μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.7KB) (0.05%)
    107μs
    1 x afterRenderRawModule mod_custom () (896B) (0.04%)
    94μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.04%)
    82μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.04%)
    81μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.04%)
    76μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.03%)
    72μs
    1 x After Access::getAssetRules (id:8063 name:com_content.article.4000) (7.38KB) (0.03%)
    69μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.03%)
    69μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.03%)
    63μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.03%)
    61μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.03%)
    58μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.02%)
    47μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.02%)
    43μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.02%)
    42μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.02%)
    38μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0.02%)
    38μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.02%)
    37μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0.01%)
    32μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    32μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    30μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    27μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    22μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    20μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0.01%)
    15μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0.01%)
    14μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    14μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    13μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.01%)
    13μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0.01%)
    12μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0.01%)
    12μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0.01%)
    12μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0.01%)
    11μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
45 statements were executed, 9 of which were duplicates, 36 unique133ms1.33MB
  • SELECT @@SESSION.sql_mode;81μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?213μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1101μ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_id1.92ms992BParams/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` = 1328μs1.56KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`114μ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` = :guest204μ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`611μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC238μ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` = 1181μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config185μ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`963μ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`342μ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)474μ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` = 02.76ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`916μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '4000'1.58ms48B/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)495μ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`441μ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)1.72ms4.16KBParams/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`391μ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 ASC455μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id155μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id115μ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`2.28ms180.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 DESC11.27ms161.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`453μs3.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` = 0416μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id134μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id84μ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-02-22 18:01:39') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-22 18:01:39') AND c2.state = 1380μ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 a.title ASC LIMIT 1042.12ms195.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-02-22 18:01:39', 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 1047.84ms2.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 103.61ms159.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`609μs3.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` = :id763μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1247μ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)236μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.3ms4.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)3.34ms584B/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` = 1172μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?135μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.69ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy