Skip to main content

Autism may be caused by deficiencies in several nutrients

Autism may be caused by deficiencies in several nutrientsDuring fetal development and childhood, the brain requires a range of nutrients to build the nervous system and support cognitive development. According to a new review article published in Nutrients, widespread deficiencies in vitamins C, D, and A, as well as iron, iodine, selenium, zinc, and other nutrients, may contribute to the development of autism.

Individuals with autism experience significant impairments in social imagination, behavior, communication, and interaction. The condition is thought to result from changes in brain development, with symptoms often appearing in childhood and leading to lifelong challenges of varying severity. The term autism spectrum disorder (ASD) is also used, which includes variants such as infantile autism and Asperger’s syndrome. Around 20 percent receive the diagnosis as adults, and many also suffer from co-occurring conditions such as ADHD, depression, anxiety, and eating disorders.
Although genes may play a role, environmental factors are believed to be the primary cause of the sharp rise in autism rates. In the U.S., the prevalence of autism has quadrupled over the past 20 years, and the same trend is seen in other countries. One contributing factor appears to be unbalanced diets and nutrient deficiencies. It has been reported that 89% of children with autism have restrictive eating habits, which makes them more vulnerable during development. Vitamin C deficiency has previously been linked to an increased risk, and the new meta-analysis aimed to examine whether deficiencies in other nutrients may also raise the risk.

Widespread nutrient deficiencies worsen the issue

Using the PubMed and ScienceDirect databases and relevant search terms, the researchers analyzed 27 articles involving children and adolescents (aged 2 - 18) with autism and their deficiencies in various nutrients. The study revealed widespread deficiencies in the following:

  • Vitamin D (25%)
  • Vitamin A (25%)
  • B vitamins (18%)
  • Calcium (11%)
  • Iron (10%)
  • Mild deficiencies in iodine, zinc, vitamin E, selenium, and others

The authors also found that all cases of calcium deficiency were accompanied by vitamin D deficiency, and all cases of iron deficiency were accompanied by vitamin C deficiency. Additionally, 25% of those with vitamin A deficiency also lacked vitamin B12. The authors highlight that these combined deficiencies are problematic, as nutrients interact and support each other’s absorption and function in the body.
Deficiency diseases such as rickets, goiter, pellagra, and xerophthalmia (an eye disorder) were also reported. Seventy percent of individuals with autism had multiple deficiencies, all of which were linked to poor or restrictive diets due to pickiness, sensitivities, or other aversions. These diets often consisted of refined carbohydrates and empty calories. Over 50% of the participants had a high BMI, and none were underweight.
The researchers conclude that children and adolescents with autism are at high risk of nutrient deficiencies - even if their growth and BMI appear to be normal. Therefore, further research is needed to understand how early intervention with proper nutrition can help prevent complications associated with autism.

The brain's nutritional needs during growth and development

The brain contains the highest concentration of vitamin C in the body. This is because vitamin C is essential for collagen production and numerous enzyme functions of importance to the nervous system. It also acts as a powerful antioxidant that protects nerve cells from damage caused by free radicals. Among individuals with autism, vitamin C deficiency is common due to low intake of fruits and vegetables.
The review article also discusses how vitamin D and calcium are essential for bone development. Moreover, most cells (including those in the brain and nervous system) have vitamin D receptors. The risk of developing autism is particularly high in boys whose mothers lacked vitamin D during pregnancy, according to a study from the University of Queensland in Australia.
Vitamin D deficiency is widespread due to limited sun exposure and excessive use of sunscreen, which blocks the skin's ability to produce the vitamin. Many pregnant women, children, and adolescents do not receive the recommended vitamin D supplements, and many require higher doses to optimize blood levels.
A study published in the Journal of Child Psychology and Psychiatry showed that vitamin D supplementation can improve autism symptoms such as hyperactivity, social withdrawal, and functional impairments.
Although vitamin A deficiency is rare in the general population, it is common among individuals with autism. Vitamin A is particularly important for eye health, mucous membranes, skin, and the immune system. Good sources of true vitamin A (retinol) include liver, liver pâté, eggs, fish, and full-fat dairy products - foods often avoided by people with autism. Carrots and green vegetables contain beta-carotene, a precursor to vitamin A (retinol).
B vitamins are a group of water-soluble vitamins crucial for energy metabolism, blood formation, and nervous system function. Good sources include whole grains and green vegetables, while vitamin B12 is only found in animal products.
It is recommended that pregnant women take higher doses of folic acid (vitamin B9) early in pregnancy to prevent neural tube defects. A Canadian study has shown that folic acid supplementation throughout pregnancy reduces the risk of the child developing neurological damage and autistic behaviors due to lead exposure.
Iron is vital for transporting oxygen in the blood to all cells, and it supports growth, vitality, and learning ability. Good sources include meat, eggs, and other animal-based foods. Iron absorption is vitamin C-dependent. Diets dominated by foods like pizza, bread, fries, and ultra-processed products contribute to widespread iron deficiency, especially in individuals with autism. Calcium supplements and excessive dairy intake can inhibit iron absorption.
Iodine, mainly found in fish, shellfish, and seaweed, is essential for the production of thyroid hormones. Selenium is needed to activate these hormones. It also supports brain function and helps detoxify heavy metals like mercury, which can harm the nervous system. Selenium is found in organ meats, meat, eggs, Brazil nuts, and grains, but deficiencies are common in Europe due to mineral-depleted soil, which affects the entire food chain.
Zinc plays a vital role in growth and mental balance. Researchers have now identified a connection between zinc, genes, and the abnormal neurological pathways associated with autism. Good sources of zinc include shellfish, liver, meat, eggs, dairy, nuts, seeds, and beans. Zinc from animal sources is more easily absorbed.
In short, the brain and nervous system require a broad spectrum of nutrients that work together in numerous biochemical processes. Therefore, widespread deficiencies in one or more nutrients can have serious consequences for the brain, nervous system, and overall health.
Although magnesium deficiency was not covered in this review, other studies suggest that it may also contribute to the development of autism and ADHD. It is also important to remember that the brain needs a substantial amount of cholesterol and other high-quality fats.

The role of omega-3 fatty acids in brain health

Oily fish and fish oil supplements contain the omega-3 fatty acids EPA and DHA, which are crucial for the brain, nervous system, and mental health throughout life. Deficiencies in EPA and DHA are widespread and increase the risk of numerous conditions, including autism, ADHD, depression, and bipolar disorder. Fish oil supplements may therefore hold promise in preventing and supporting the treatment of various mental health disorders, according to a previous review published in Nutrients.
Another review article published by Cambridge University Press has also shown that fish oil supplementation can reduce hyperactivity and incoherent speech in young children with autism.

References:

Kamsiyochukwu S Daniel et al. The Increasing Prevalence of Autism Spectrum Disorder in the U.S. and Its implications for Pediatric Micronutrient Status. A narrative Review of Case Reports and Series. Nutrients 2025

Joshua D et al. Combined Exposure to Folate and Lead during Pregnancy and Autistic-Like Behaviors among Canadian Children from the MIREC Pregnancy and Birth Cohort. Environmental Health Perspective, 2024

Ali, A. A. et al. Developmental vitamin D deficiency increases foetal exposure to testosterone. Molecular Autism. 2020

Khaled Sall et al. Randomized controlled trial of vitamin D supplementation in children with autism spectrum disorder. Journal of Child Psychology and Psychiatry. 2016

Anatoly v Skalny. Magnesium Status in Children with Atten-Deficit/hyperactivity Disorder and/or Autism Spectrum Disorder. Child and Adolescent Psychiatry. 2020

Hamid Abbasi et al. Impact of omega-3 fatty acid supplementation on clinical manifestations in autism spectrum disorder: an umbrella review of meta-analysis. Cambridge University Press. 2024

Pablo Roman et al. Exposure to Environmental Pesticides and the Risk of Autism Spectrum Disorders: A Population-Based Case Control Study. ResearchGate 2024


 

 

  • Created on .
9.472MBMemory Usage176msRequest 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" => "fbur6hcv5rsrq8gbcr0e8kggkj" ]
$_SERVER
array:47 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1751923618 "last" => 1751923618...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.69KB) (635μs)
  • afterInitialise (1.28MB) (11.15ms)
  • afterRoute (896.66KB) (4.96ms)
  • beforeRenderComponent com_content (22.21KB) (320μs)
  • Before Access::preloadComponents (all components) (33.23KB) (245μs)
  • After Access::preloadComponents (all components) (97.34KB) (709μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.29MB) (5.78ms)
  • Before Access::getAssetRules (id:9100 name:com_content.article.4902) (130.65KB) (96μs)
  • After Access::getAssetRules (id:9100 name:com_content.article.4902) (7.38KB) (53μs)
  • beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.36MB) (19.78ms)
  • afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (559.08KB) (16.33ms)
  • beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (9μs)
  • afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (117μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (392B) (45μs)
  • afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (191μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (5.07KB) (43μs)
  • afterRenderComponent com_content (47.58KB) (11.85ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (1.83ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (32μs)
  • afterDispatch (43.05KB) (1.01ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (457μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (68.7KB) (36.03ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (31μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (46μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (14μs)
  • afterRenderRawModule mod_tags_popular (Search) (26.8KB) (47.86ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (33μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (50μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (12μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (2.25ms)
  • afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (63μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (16μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (32μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (14μs)
  • afterRenderModule mod_tags_popular (Search) (1.27KB) (23μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (11μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (21μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (20μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (392μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (196.16KB) (1.57ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (52μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (81.98KB) (1.64ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (64.59KB) (1.61ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (141μs)
  • afterRenderRawModule mod_custom () (21.95KB) (869μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (51μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (103μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (827μs)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (3μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (43μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (683μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (31μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (9μs)
  • afterRenderRawModule mod_finder () (6.29KB) (570μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (45μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (197μs)
  • afterRenderRawModule mod_custom () (944B) (133μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (90μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (21μs)
  • afterRender (207.54KB) (3.7ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (26.8KB) (27.21%)
    47.86ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (68.7KB) (20.48%)
    36.03ms
    1 x beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.36MB) (11.25%)
    19.78ms
    1 x afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (559.08KB) (9.28%)
    16.33ms
    1 x afterRenderComponent com_content (47.58KB) (6.74%)
    11.85ms
    1 x afterInitialise (1.28MB) (6.34%)
    11.15ms
    1 x After Access::preloadPermissions (com_content) (3.29MB) (3.29%)
    5.78ms
    1 x afterRoute (896.66KB) (2.82%)
    4.96ms
    1 x afterRender (207.54KB) (2.1%)
    3.70ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.28%)
    2.25ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (1.04%)
    1.83ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (81.98KB) (0.93%)
    1.64ms
    1 x afterRenderRawModule mod_finder () (64.59KB) (0.92%)
    1.61ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (196.16KB) (0.89%)
    1.57ms
    1 x afterDispatch (43.05KB) (0.58%)
    1.01ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.49%)
    869μs
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.47%)
    827μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.4%)
    709μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.39%)
    683μs
    1 x afterLoad (456.69KB) (0.36%)
    635μs
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.32%)
    570μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.26%)
    457μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (0.22%)
    392μs
    1 x beforeRenderComponent com_content (22.21KB) (0.18%)
    320μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.14%)
    245μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.11%)
    197μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (0.11%)
    191μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.08%)
    141μs
    1 x afterRenderRawModule mod_custom () (944B) (0.08%)
    133μs
    1 x afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (0.07%)
    117μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.06%)
    103μs
    1 x Before Access::getAssetRules (id:9100 name:com_content.article.4902) (130.65KB) (0.05%)
    96μs
    1 x afterRenderRawModule mod_custom () (896B) (0.05%)
    90μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.05%)
    80μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (0.04%)
    63μs
    1 x After Access::getAssetRules (id:9100 name:com_content.article.4902) (7.38KB) (0.03%)
    53μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.03%)
    52μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.03%)
    51μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.03%)
    50μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.03%)
    46μs
    1 x beforeRenderRawModule mod_custom (Search for more information...) (392B) (0.03%)
    45μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.03%)
    45μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.07KB) (0.02%)
    43μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.02%)
    43μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.02%)
    34μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.02%)
    33μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.02%)
    32μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.02%)
    31μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.02%)
    31μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x afterRenderModule mod_tags_popular (Search) (1.27KB) (0.01%)
    23μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    22μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0.01%)
    22μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0.01%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0.01%)
    14μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0.01%)
    14μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0.01%)
    12μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (0.01%)
    9μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.01%)
    9μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
76 statements were executed, 39 of which were duplicates, 37 unique122ms1.26MB
  • SELECT @@SESSION.sql_mode;70μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?247μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 193μ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_id970μs992BParams/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` = 1245μs1.56KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`74μ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` = :guest162μ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`658μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC163μ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` = 1143μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config154μ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`958μ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`257μ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` = 1221μ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)407μ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` = 03.34ms417.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`671μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '4902'884μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)412μ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`339μ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)2.2ms4.13KBParams/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`484μ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 ASC486μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id116μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id85μ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`1.99ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `t`.`id` FROM `has_tags` AS `t` INNER JOIN `has_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)4.01ms1.41KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,COUNT( `tag_id`) AS `count`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `cc` ON `m`.`core_content_id` = `cc`.`core_content_id` INNER JOIN `has_content_types` AS `ct` ON `m`.`type_alias` = `ct`.`type_alias` WHERE ( ( ( (`m`.`tag_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6) AND `t`.`access` IN (:preparedArray7,:preparedArray8) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray9,:preparedArray10) OR `cc`.`core_access` = 0)) AND (`m`.`content_item_id` <> :currentId OR `m`.`type_alias` <> :prefix)) AND (`cc`.`core_publish_up` IS NULL OR `cc`.`core_publish_up` = :nullDateUp OR `cc`.`core_publish_up` <= :nowDateUp)) AND (`cc`.`core_publish_down` IS NULL OR `cc`.`core_publish_down` = :nullDateDown OR `cc`.`core_publish_down` >= :nowDateDown) AND `cc`.`core_language` IN (:preparedArray11,:preparedArray12) GROUP BY `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` ORDER BY `count` DESC, RAND() LIMIT 155.9ms20.66KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:200Copy
  • 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`339μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `alias` FROM `has_content` WHERE `id` = :id67μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id52μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id56μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id47μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id65μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id51μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id50μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id76μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id62μ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 `alias` FROM `has_content` WHERE `id` = :id52μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id60μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id59μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id55μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id54μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id52μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id54μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id51μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id64μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id45μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id47μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id56μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id50μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id66μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id52μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id46μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id59μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id48μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 DESC9.36ms177.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1152μ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` = 0393μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id90μ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 `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-07-07 21:27:01') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-07-07 21:27:01') AND c2.state = 1386μs12.52KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 1034.31ms175.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray5,:preparedArray6) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 1546.43ms2.75KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id244μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1186μ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)144μ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 ASC316μ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)137μ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` = 1119μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`405μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?120μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.45ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy