Skip to main content

Supplementation with B vitamins protects older people against dementia and Alzheimer’s disease

Supplementation with B vitamins protects older people against dementia and Alzheimer’s diseaseThe number of seniors worldwide is increasing and more and more are affected by Alzheimer’s disease, the leading cause of dementia. We should therefore focus much more on this health problem that comes with an enormous human and socio-economic price tag. According to a new meta-analysis, supplementation with B vitamins appears to prevent or delay mild cognitive impairment in older people, which is normally an early sign of Alzheimer’s disease. In fact, supplementation with B vitamins may even represent an inexpensive therapy form with a huge potential.

The risk of contracting Alzheimer’s disease goes up with age. It turns out that changes in the brain occur decades before the disease shows. In the early phases, there are signs of mild cognitive impairment with symptoms such as forgetfulness, loss of short-term memory, and an impaired ability to acquire new knowledge. The symptoms grow worse and eventually include aphasia (a condition that robs you of the ability to communicate), poor sense of direction, a tendency to get lost, and loss of motivation. The disease also results in personality change and it typically leads to death after 7-10 years.
Alzheimer’s disease is the leading cause of dementia. Fifty million people worldwide are believed to suffer from dementia and the number is expected to increase to 152 million by 2050. The human and socio-economic price tag, needless to say, increases as the disease progresses. Although mild cognitive impairment with poor memory and loss of cognitive skills is not necessarily a sign of Alzheimer’s disease, these symptoms may be preclinical. Enormous sums of money could be saved by preventing or delaying the mild cognitive impairment in the early stages. Therefore, the scientists behind the new study point out that we should focus more on timely intervention.

What does Alzheimer’s do to your brain?

Alzheimer’s disease causes neurons to slowly perish in several parts of the brain, and the brain shrinks (brain atrophy). Scientists have observed accumulation of plaque (β-amyloid peptides) and tau protein that is harmful for brain cells and associated with inflammation. It is also known that elevated blood levels of the amino acid homocysteine may cause accumulation of β-amyloid plaque in the brain and loss of brain tissue.
Homocysteine is a normal waste product that results from protein breakdown. Afterwards, homocysteine is converted into other amino acids with the help of vitamin B12, folic acid, and vitamin B6. If you lack these B vitamins in the blood, levels of homocysteine may go up. This can result in damaged blood vessels and damaged neurons and is linked to Alzheimer’s disease, cardiovascular disease, and stroke. On the other hand, vitamin B12, folic acid, and vitamin B6 have a homocysteine-lowering effect. Although studies have shown that supplementation with B vitamins can lower levels of homocysteine in the blood, it remains to be shown if this can prevent cognitive impairment in senior life.

The meta-analysis unveiled the B vitamins’ effect

In their new meta-analysis, the scientists looked at 21 randomized, controlled studies with a total of 7,571 patients aged 60-82 years. All patients suffered from mild cognitive impairment and had elevated blood levels of homocysteine.
They were given supplements of B vitamins or placebo. Eleven of the studies lasted less than a year, while 10 of the studies lasted longer than a year. The cognitive function of the participants was assessed with help from specific scales. It turned out that supplements of B vitamins significantly lowered blood levels of homocysteine, but they were also able to prevent loss of cognitive skills. The scientists concluded that supplementation with B vitamins can prevent or delay age-related cognitive impairment by lowering blood levels of homocysteine.
The new meta-analysis is published I BM Geriatrics. Earlier research suggests that vitamin B supplementation helps prevent inflammation and oxidative stress in the brain, which are also seen in connection with Alzheimer’s disease.

How do we get enough of the B vitamins – and why is this difficult for older people?

B vitamins are a group of vitamins that work together as a complicated biological team in the body. Because these vitamins are water-soluble and therefore not stored in the body (apart from vitamin B12) we need to get them regularly from our diet or from supplements.
The different B vitamins are typically found in foods such as whole grains, oats, legumes, vegetables, fruit, brown rice, garlic, nuts, seeds, kernels, and brewer’s yeast in particular. Moreover, you get B vitamins from liver, meat, fish, eggs, and dairy products.
It should be mentioned that vitamin B12 is only found in animal foods. B12 deficiency symptoms are insidious. Therefore, many older people, vegans and vegetarians fail to see link between their diet and their symptoms.
Ageing processes can also impair the uptake of vitamin B12 and other nutrients. In addition, seniors often don’t eat a very balanced diet and take medicine that can block the uptake and utilization of B vitamins. This is why lack of B12 vitamins in particular is often mistaken for dementia. A blood test can easily show if a person has too little vitamin B12.
There are high-dosed vitamin B supplements on the market and you can also get vitamin B12 in lozenges that enables absorption of the nutrient through the oral mucosa.

  • Alzheimer’s disease is associated with elevated homocysteine levels in the blood
  • A regular blood test can show your homocysteine levels
  • It is possible to lower elevated blood levels of homocysteine by taking supplements of vitamin B6, folic acid, and vitamin B12
  • Studies show that Alzheimer’s disease is linked to insulin resistance in the brain. This is why the disease is also called type 3 diabetes
  • It is important to look at other factors, as well, such as diet habits, blood sugar levels, and physical activity

References

Shufeng Li et al. The preventive efficacy of vitamin B supplements on the cognitive decline of elderly adults: a systematic review and meta-analysis. BMC Geriatrics 16 June 2021

Hui Chen et al. Folic Acid Supplementation Mitigates Alzheimer´s Disease by Reducing Inflammation: A Randomized Controlled Trial. Mediators of Inflammation. 2016

Sybille Hildebrandt. Insulinresistens i hjernen kan udløse Alzheimers. Dagens Medicin. 2016

Diabetes Health. Alzheimer’s new name: Type 3 Diabetes. 2014

  • Created on .
8.865MBMemory Usage486msRequest 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" => 1740246072 "last" => 1740246072...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-US" ]
  • afterLoad (456.53KB) (4.28ms)
  • afterInitialise (1.27MB) (38.91ms)
  • afterRoute (927.02KB) (32.39ms)
  • beforeRenderComponent com_content (23.38KB) (289μs)
  • Before Access::preloadComponents (all components) (35.84KB) (5.57ms)
  • After Access::preloadComponents (all components) (97.34KB) (7.24ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (15.41ms)
  • Before Access::getAssetRules (id:6507 name:com_content.article.3217) (130.65KB) (141μs)
  • After Access::getAssetRules (id:6507 name:com_content.article.3217) (7.38KB) (61μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (63.3ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (213μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (10.95KB) (3.13ms)
  • afterRenderComponent com_content (54.95KB) (38.82ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.22KB) (9.41ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (29μs)
  • afterDispatch (17.63KB) (700μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (1.73ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (139ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (35μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.02KB) (77.03ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (26μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (43μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (22μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.67KB) (10.08ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (26μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (38μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.69ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (66μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (25μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (21μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (16μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (22μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (9μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (21μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (8μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (419μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (3.43ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (61μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (4.81ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (12μs)
  • afterRenderRawModule mod_finder () (214.53KB) (3.17ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (142μs)
  • afterRenderRawModule mod_custom () (21.98KB) (2.97ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (52μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (106μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (630μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (3μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (44μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (664μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (30μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (1.38ms)
  • afterRenderRawModule mod_finder () (6.29KB) (3.84ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (49μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (179μs)
  • afterRenderRawModule mod_custom () (944B) (127μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (81μs)
  • afterRenderRawModule mod_custom () (896B) (89μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (21μs)
  • afterRender (170.19KB) (6.64ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (28.65%)
    139.32ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.02KB) (15.84%)
    77.03ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (13.02%)
    63.30ms
    1 x afterInitialise (1.27MB) (8%)
    38.91ms
    1 x afterRenderComponent com_content (54.95KB) (7.98%)
    38.82ms
    1 x afterRoute (927.02KB) (6.66%)
    32.39ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (3.17%)
    15.41ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.67KB) (2.07%)
    10.08ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.22KB) (1.94%)
    9.41ms
    1 x After Access::preloadComponents (all components) (97.34KB) (1.49%)
    7.24ms
    1 x afterRender (170.19KB) (1.37%)
    6.64ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (1.15%)
    5.57ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (0.99%)
    4.81ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (0.96%)
    4.69ms
    1 x afterLoad (456.53KB) (0.88%)
    4.28ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.79%)
    3.84ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.71%)
    3.43ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (0.65%)
    3.17ms
    1 x afterRenderModule mod_custom (Search for more information...) (10.95KB) (0.64%)
    3.13ms
    1 x afterRenderRawModule mod_custom () (21.98KB) (0.61%)
    2.97ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.36%)
    1.73ms
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.28%)
    1.38ms
    1 x afterDispatch (17.63KB) (0.14%)
    700μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.14%)
    664μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.13%)
    630μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.09%)
    419μs
    1 x beforeRenderComponent com_content (23.38KB) (0.06%)
    289μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.04%)
    213μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    179μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    142μs
    1 x Before Access::getAssetRules (id:6507 name:com_content.article.3217) (130.65KB) (0.03%)
    141μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    127μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    106μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    89μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    81μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    66μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    61μs
    1 x After Access::getAssetRules (id:6507 name:com_content.article.3217) (7.38KB) (0.01%)
    61μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    52μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    49μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    44μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    43μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    38μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    35μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    26μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    22μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    22μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    21μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    16μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    15μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    11μ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%)
    8μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique309ms1.33MB
  • SELECT @@SESSION.sql_mode;42μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?96μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1210μ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)4.02ms944BParams/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` = 1193μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`141μ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` = :guest2.25ms1.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`482μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC143μ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` = 1165μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config172μ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`5.35ms165.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`227μ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` = 14.43ms848B/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)2.93ms7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 05.15ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.18ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3217'2.59ms48B/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)2.01ms22.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`2.29ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)5.6ms4.08KBParams/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`367μ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.25ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id215μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id560μ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`6.67ms180.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 DESC32.72ms161.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`2.3ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1141μ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` = 0336μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id198μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.7ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-22 17:41:12') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-22 17:41:12') AND c2.state = 1283μ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 10133ms195.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `tag_date` > DATE_ADD('2025-02-22 17:41:12', 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 1074.33ms2.66KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray6,:preparedArray7) ORDER BY a.created ASC LIMIT 103.12ms159.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`2.72ms3.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` = :id2.21ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1176μ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)137μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.24ms4.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)916μ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` = 1128μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?1.06ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.26ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy