Skip to main content

Vitamin D’s role in children’s mental health

vitdmentalhealthchildVitamin D is involved in the development of the brain structure and in brain functions. According to a review article that is published in Nutrients, vitamin D is of particularly great importance to the mental health of children and teenagers due to its long-term effect. This subject is highly topical as it is known that the widespread lack of vitamin D among children increases their risk of anxiety, depression, aggressive behavior, and other mental problems. It is vital for children and teenagers to get plenty of sun and supplements if necessary so they are sure to meet the new guidelines for vitamin D.

Vitamin D is looked upon as a neuroactive steroid hormone with a key role in the nervous system, our mood, and our cognitive skills. Most studies of vitamin D and its role in mental health have been carried out on adults. However, it is especially important for children and teenagers to get enough vitamin D because of its long-term effect. The scientists behind the new study wanted to analyze the relation between children’s mental health and their vitamin D status by making a systematic review of already published science literature in this area. Their material included intervention studies and observational studies until October 2019 that were collected from PubMed, Web of Sciences and other databases.

  • More and more children and teenagers are affected by anxiety, depression, and behavioral problems
  • Many factors are involved. Vitamin D deficiency appears to be one of them

The link between lack of vitamin D in children and mental diseases

The scientists included 24 suited studies that looked at children and their intake of vitamin D or their blood levels of the nutrient. The studies were divided into groups dealing with the mental health of children, including such categories as healthy children or children with mental problems such as violent behavior, anxiety, depressive symptoms/depression, psychotic disorders, bipolar disorder (manic depression), OCD, and suicidal thoughts. They also looked at the general mental health of the children with focus on stress, quality of life, mood, and sleep pattern.
The majority of studies revealed that vitamin D has a potentially positive role in pediatric mental health. Now, the scientists want more studies that delve into this matter
However, even at this point, they point out that getting adequate vitamin D from safe sun exposure or supplements combined with healthy eating habits should be implemented as an important strategy for supporting the mental health of children. Another thing the scientists refer to is that it takes optimal blood levels of vitamin D to avoid developing mental problems.

Blood levels of vitamin D

  • Blood levels of vitamin D are categorized as actual deficiency (below 30 nmol/L), insufficiency (30-50 nmol/L), and sufficiency (above 50 nmol/L)
  • Many leading scientists believe the optimal level is between 60-100 nmol/L

Vitamin D has many functions in the brain

In their review article, the scientists look at vitamin D’s different mechanisms in the brain and nervous system. For example, we have vitamin D receptors (VDR) in several areas of the brain such as the hypothalamus, the cerebral cortex, the cerebellum, and the limbic system that controls our feelings and short-term memory. Here, vitamin D regulates the on-off switches of several genes and controls neurotransmitters such as acetylcholine, dopamine, and serotonin. Vitamin D even counteracts inflammation that can cause depression.
The scientists describe a host of different studies about vitamin D’s role in mental health and the fact that children with psychiatric disorders often lack vitamin D.

The vicious cycle

They also refer to other connections between vitamin D and mental health. It is a fact that many people with mental health problems such as depression, chronic fatigue, and social anxiety tend to stay indoors, they have poor appetites or eat unhealthy diets and that limits their access to vitamin D from sun exposure or dietary sources. These people may already have an increased need for vitamin D due to genetic factors or a disrupted calcium metabolism. That way, a vitamin D deficiency and its effect on mental health can easily turn into a vicious cycle. Although there are many reasons why people get mental disorders it is important in any case that the brain and nervous system have plenty of vitamin D to work with. If not, targeted therapies may even fail to work properly.

New vitamin D recommendations from the Danish Veterinary and Food Administration

Because new studies have revealed widespread vitamin D deficiency in children and the general population, the Danish Veterinary and Food Administration has issued new guidelines:

Infants and small children under the age of 4 years:
10 micrograms daily all year, from two weeks of age until the age of four

Children from 4 years of age and adults:
5-10 micrograms per day during the winter period (from October to April)

Specific population groups
10 micrograms per day all year round for:

  • Children and adults with dark skin
  • Children and adults who are veiled during the summer period
  • People who do not go outdoors daily or who avoid sun exposure
  • Pregnant women

Individual needs and safe upper limit

Studies show that the need for vitamin D can vary because of genetic differences, which means some people may need more vitamin D than the officially recommended amount. EU’s Scientific Committee on Food has established a safe, daily, upper intake level for vitamin D that is as follows: 25 micrograms for infants aged 0-6 months, 50 micrograms for children aged 6 months to 10 years, and 100 micrograms for children older than 11 years plus adults (including pregnant and breastfeeding women).

  • Around 15 percent of Danish children will have received treatment for a mental disorder before they turn 18
  • Mental disorders represent the single largest disease burden among children and young people from the ages 1 through 24 years.
  • There are many factors that contribute to mental disorders but it is important to be aware of vitamin D and to compensate for deficiencie

Other studies and more information

More and more children and young people are affected by mental health disorders. The following article looks closer at how lack of vitamin D increases the risk of anxiety, depression, aggressive behavior, and other mental disorders

»School children who lack vitamin D have increased risk of anxiety, depression, and aggressive behavior later in life«

References

Dominika Glabska et al. The Influence of Vitamin D Intake and Status on Mental Health in Children: A Systematic Review. Nutrients 2021

Sonia L. Robinson et al. Vitamin D Deficiency in Middle Childhood is related to Behavior Problems in Adolescence. The Journal of Nutrition, 2019

University of Michigan. Low levels of vitamin D in elementary school could spell trouble in adolescence. ScienceDaily. August. 2019

Helene Sandström. Den optimala D-vitamindosen i vinter? Det beror på dina genar. Nordic Nutrition Council. Sep. 3 2020

VitaminD.net. Interview mit Dr. Carlberg: Vitamin D, epigenetik und der respons-index. Hämtad. 2020-09-03

https://www.psykiatrifonden.dk/viden/fakta.aspx

  • Created on .
8.902MBMemory Usage210msRequest Duration
Joomla! Version4.4.4
PHP Version8.3.6
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.40-0ubuntu0.24.04.1
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:46 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745405862 "last" => 1745405862...
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.34KB) (2.31ms)
  • afterInitialise (1.27MB) (19.16ms)
  • afterRoute (927.02KB) (6.81ms)
  • beforeRenderComponent com_content (22.63KB) (261μs)
  • Before Access::preloadComponents (all components) (35.84KB) (506μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.12ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (14μs)
  • After Access::preloadPermissions (com_content) (3.24MB) (11.3ms)
  • Before Access::getAssetRules (id:6153 name:com_content.article.3044) (130.65KB) (93μs)
  • After Access::getAssetRules (id:6153 name:com_content.article.3044) (7.38KB) (48μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (30.27ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (211μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (89μs)
  • afterRenderComponent com_content (60.19KB) (23.33ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.95KB) (3.62ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (26μs)
  • afterDispatch (17.73KB) (519μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (389μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (60ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (23μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.37KB) (32.91ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (22μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (39μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (20μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.63KB) (2.28ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (23μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (35μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (10μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (20μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.87ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (47μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (23μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (10μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (18μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (15μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (18μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (9μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (17μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (17μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (371μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.2ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (73μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.21KB) (1.34ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (19μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (10μs)
  • afterRenderRawModule mod_finder () (214.53KB) (1.77ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (31μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (129μs)
  • afterRenderRawModule mod_custom () (21.95KB) (742μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (44μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (94μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (599μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (3μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (38μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (589μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (2μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (26μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (8μs)
  • afterRenderRawModule mod_finder () (6.29KB) (492μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (41μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (160μs)
  • afterRenderRawModule mod_custom () (944B) (116μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (23μs)
  • beforeRenderRawModule mod_custom () (688B) (72μs)
  • afterRenderRawModule mod_custom () (896B) (84μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (24μs)
  • afterRender (167.06KB) (2.46ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (28.57%)
    60.00ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.37KB) (15.67%)
    32.91ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (14.41%)
    30.27ms
    1 x afterRenderComponent com_content (60.19KB) (11.11%)
    23.33ms
    1 x afterInitialise (1.27MB) (9.12%)
    19.16ms
    1 x After Access::preloadPermissions (com_content) (3.24MB) (5.38%)
    11.30ms
    1 x afterRoute (927.02KB) (3.24%)
    6.81ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.95KB) (1.72%)
    3.62ms
    1 x afterRender (167.06KB) (1.17%)
    2.46ms
    1 x afterLoad (456.34KB) (1.1%)
    2.31ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.63KB) (1.08%)
    2.28ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (0.89%)
    1.87ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (0.84%)
    1.77ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.21KB) (0.64%)
    1.34ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.57%)
    1.20ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.53%)
    1.12ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.35%)
    742μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.29%)
    599μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.28%)
    589μs
    1 x afterDispatch (17.73KB) (0.25%)
    519μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.24%)
    506μs
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.23%)
    492μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.19%)
    389μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.18%)
    371μs
    1 x beforeRenderComponent com_content (22.63KB) (0.12%)
    261μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.1%)
    211μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.08%)
    160μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.06%)
    129μs
    1 x afterRenderRawModule mod_custom () (944B) (0.06%)
    116μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.04%)
    94μs
    1 x Before Access::getAssetRules (id:6153 name:com_content.article.3044) (130.65KB) (0.04%)
    93μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.04%)
    89μs
    1 x afterRenderRawModule mod_custom () (896B) (0.04%)
    84μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.03%)
    73μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.03%)
    72μs
    1 x After Access::getAssetRules (id:6153 name:com_content.article.3044) (7.38KB) (0.02%)
    48μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    47μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    44μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.02%)
    41μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.02%)
    39μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.02%)
    38μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.02%)
    35μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    31μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    26μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    24μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    23μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    23μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    20μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    19μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    18μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    17μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    17μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    16μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0.01%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0.01%)
    13μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    8μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    2μs
45 statements were executed, 9 of which were duplicates, 36 unique129ms1.33MB
  • SELECT @@SESSION.sql_mode;186μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?169μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 157μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.61ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `has_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1185μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`2.23ms656B/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` = :guest127μ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`401μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC312μ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` = 1183μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config253μ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`675μ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`226μ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` = 1202μ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)593μ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` = 04.54ms401.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`585μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3044'1.16ms48B/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)474μ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`314μ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.67ms4.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`254μ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.08ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id97μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id58μ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.95ms180.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 DESC15.91ms161.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`299μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1123μ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` = 0276μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id99μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id102μ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-04-23 10:57:42') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-23 10:57:42') AND c2.state = 1236μ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 1056.77ms195.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-04-23 10:57:42', 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 1030.8ms2.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 10594μs159.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`357μ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` = :id116μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1140μ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)122μ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 ASC247μ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)135μ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` = 1106μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?99μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.47ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy