Skip to main content

Magnesium supplements can relieve anxiety, stress, and depression

Magnesium supplements can relieve anxiety, stress, and depression Magnesium takes part in over 300 different enzyme processes, some of which are relevant for the nervous system. Magnesium deficiencies are common, and there is a link to the increased prevalence of subjective anxiety and stress. Researchers from the University of Leeds in Great Britain have reviewed a number of studies that show how supplementation with magnesium may help in cases of mild anxiety, stress, and depression. Magnesium appears to be a precondition of a healthy and sturdy nervous system, and getting enough of this nutrient is therefore important for preventing these conditions.

Anxiety-related conditions are among the most common psychological diseases, which 15 percent of people experience at some time during their life. It is commonly known that stress can trigger anxiety and depression. In many cases, it is a vicious cycle. The relation between low magnesium and anxiety is something that interests scientists because of the serious side effects that are seen with benzodiazepines.
The team of researchers from the University of Leeds reviewed 18 earlier studies from different databases. They looked at how supplements of magnesium, alone or in combination with other nutrients, affected mild anxiety and other symptoms.

Widespread magnesium deficiency and known physical diseases

The intake of magnesium has fallen drastically in Western societies such as the United States and Europe. For instance, 68 percent of Americans and 72 percent of Frenchmen get less than the recommended amount of magnesium from their diets, and a similar pattern is expected to be found in other countries. At the same time, our modern lifestyle with stress, stimulant use, and medicine depletes the body’s magnesium stores.
It is already known that a low intake of magnesium is associated with different physical diseases such as hypertension, cardiovascular disease, and diabetes. Getting too little magnesium is also linked to psychological disorders.

Psychological diseases

Feelings in both humans and animals are rooted in the limbic system of the brain. An axis passes through the limbic system, hypothalamus, the pituitary gland and the adrenal gland, and it functions as the body’s emergency call center. All parts of this axis are sensitive to magnesium and need sufficient amounts of the mineral to function optimally.
For instance, magnesium affects the pituitary gland’s production off ACTH (adrenocorticotropic hormone), which promotes the production of corticosteroids.
In mouse studies, provoked magnesium deficiency has resulted in conditions that resemble depression. These were effectively cured with anti-depressive drugs. Other mouse studies have shown that magnesium supplements could also reduce conditions that resembled depression, and it turns out that magnesium supplements are an effective adjuvant.

When we are stressed, the brain sends signals to the adrenal glands, which prepare the body for an instant fight-or-flight reaction and have done so for as long as humans have existed. This process is highly energy-demanding. Modern lifestyle with chronic stress is extremely tough on the nervous system.

Treating humans with magnesium

According to the studies, which the researchers from the University of Leeds reviewed, magnesium deficiency is associated with depression and suicide among humans. Studies conducted on older people with depression and diabetes show that daily supplementation with 450 mg of magnesium for four weeks was every bit effective at reducing symptoms of depression as the anti-depressive drug, Imipramine.
Other studies have shown that magnesium has a positive effect on mania, bipolar disorder, and symptoms of chronic fatigue, but more research is needed (also with regard to finding the optimal magnesium dosage). If the dosage is too low, magnesium therapy is not likely to produce good results. It is also vital to use high-quality magnesium supplements so the nutrient is absorbed properly and reaches the cells.

Blood samples and the distribution of magnesium in the body

60% of the body’s magnesium is stored in the bones, while 27% is found in muscle tissue. Only 1-2 percent is found outside the cells (extra-cellular magnesium). Only a so-called whole blood analysis is able to provide a reliable picture of the body’s magnesium status, where one can see how much magnesium is inside the cells.

Stress, anxiety, and depression

As mentioned before, there is often a relation between stress, anxiety, and depression. In mouse studies, provoked magnesium deficiency increases the amount of anxiety symptoms. Low levels of magnesium in the blood and brain are directly associated with anxiety-related behavior in mice. Supplements of magnesium have managed to reduce these symptoms.
Also, there is a clear link between low magnesium status and anxiety symptoms in humans. It has been demonstrated that individuals with a fear of exams excrete more magnesium in their urine, and that leads to lower levels of magnesium in their blood.

When we are stressed, we excrete more magnesium in the urine.

Magnesium prevents calcium poisoning of nerve cells

Scientific literature describes different biochemical relations between the nervous system, anxiety, and magnesium. Glutamate is known as a neurotransmitter in the science of neurology. A neurotransmitter is a chemical signaling substance, which nerve cells use to signal other cells.
All major nerve pathways use glutamate, and the substance is used in different parts of the brain’s network for cognitive functions like memory and language.
Glutamate binds to the NMDA (N-Methyl-D-aspartate) receptors of cell membranes, thereby increasing cellular calcium uptake. This is not always desirable. Ninety-nine percent of the body’s calcium should be stored in our bones and teeth, while cells in our soft tissues like the muscles and the brain must be practically devoid of calcium to prevent them from convulsing and stressing. In fact, NMDA is involved in anxiety and panicky conditions because calcium literally “poisons” the nerve cells. We need sufficient quantities of magnesium, because the mineral counteracts the activity of the NMDA receptors in cell membranes, thereby preventing cells in the soft tissues from taking up more calcium than necessary.

It is very important to have the right balance between calcium and magnesium. If the balance is disturbed, there is a risk that the nerve cells absorb too much calcium, which stresses them and increases the risk of anxiety and panicky conditions.

Magnesium corrects imbalances between neurotransmitters

Scientists also believe that magnesium can relieve anxiety by increasing levels of GABA (gamma-aminobutyric acid), which is the primary inhibitory neurotransmitter in the brain and central nervous system.
Imbalances characterized by too much glutamate in relation to GABA are associated with neurological tension, a condition linked to morbid fear.
Magnesium is also determining for the activity of other receptors such as mGluRs-G-protein, which is involved in reactions to fear, anxiety and panic.
Magnesium generally appears to correct several biochemical imbalances in the nervous system, and it lowers the risk of morbid fear, referred to earlier as “bad nerves”.
In most studies, magnesium supplements have been administered for 6-12 weeks.

Magnesium inhibits inflammation that is often seen with depression and anxiety

Depressive patients often have elevated levels of a protein called CRP (C-Reactive Protein) that is a biomarker for inflammation. During brain inflammation, which is not felt directly, the production of serotonin is blocked. Serotonin is vital for our good mood and well-being. Instead, something called quinolinic acid is produced, and that may trigger anxiety and irritability.
A study published in Current Pharmaceutical Design reveals that magnesium reduces levels of CRP and therefore has an anti-inflammatory role.

Some of magnesium’s biochemical effects on the nervous system

  • Transmission of nerve impulses
  • Influences the production of ACTH and corticosteroids
  • Counteracts imbalances between the two neurotransmitters, glutamate and GABA
  • Vital for the activity of mGluRs-G-protein
  • Reduces calcium intake in the nerve cells
  • Counteracts brain inflammation

Magnesium sources and things that deplete your magnesium levels

Good sources of magnesium are kernels, whole-grain, almonds, nuts, seeds, beans, cabbage and other vegetables, dark chocolate, and seaweed. Most people are unable to get enough magnesium from eating fruit and vegetables, and whole-grain is often replaced by white flour. The modern lifestyle with stress and a large intake of alcohol, tea and other stimulants depletes the body’s magnesium stores. The same is the case with birth control pills, diuretics, and various other kinds of medicine.

How much magnesium do we need?

As mentioned, there is a very intricate interplay between magnesium and calcium, which is why it is vital to ingest the minerals in the right balance. In a country like Denmark, the official recommendations (Reference Intake) for magnesium and calcium are 375 mg and 800 respectively. In other words, a 1:2 ratio (approximately). However, the Danish diet provides the two minerals in what looks more like a 1:4 ratio, which means that we get far too little magnesium and far too much calcium.
In Asia where the majority of people do not consume dairy product but tend to eat more vegetables, the ratio is more like 1:1 (500 mg of magnesium and 500 mg of calcium). Newer studies suggest that this distribution of calcium and magnesium is not only better for bone health but also for the nervous system.

Important note: Because milk contains 11 more calcium than magnesium, and cheese contains 23 more calcium than magnesium, eating a lot of dairy products creates an imbalance between the two minerals. This may affect the nervous system, among other things.

References:

Neil Bernard Boyle, Clare Lawton and Louise Dye. The Effects of magnesium Supplementation on Subjective Anxiety and Stress – A systematic Review. Nutrients 2017
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5452159/

https://en.wikipedia.org/wiki/Glutamate_(neurotransmitter)

https://da.wikipedia.org/wiki/GABA

With health care cuts looming, low-cost magnesium a welcome option for treating depression – ScienceDaily
https://www.sciencedaily.com/releases/2017/06/170627152621.htm

Role of magnesium supplementation in the treatment of depression: A randomized clinical trial
http://journals.plos.org/plosone/article?id=10.1371/journal.pone.0180067

Fujita T, Fukase M. Comparison of osteoporosis and calcium intake between Japan and United States. PubMed. 2002
http://ebm.sagepub.com/content/200/2/149.short

http://frida.fooddata.dk/

  • Created on .
8.904MBMemory Usage529msRequest 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" => 1738541501 "last" => 1738541501...
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.5KB) (4.14ms)
  • afterInitialise (1.27MB) (41.82ms)
  • afterRoute (927.02KB) (19.92ms)
  • beforeRenderComponent com_content (24.37KB) (243μs)
  • Before Access::preloadComponents (all components) (35.84KB) (250μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.92ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (14μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (19.04ms)
  • Before Access::getAssetRules (id:3021 name:com_content.article.1485) (130.65KB) (93μs)
  • After Access::getAssetRules (id:3021 name:com_content.article.1485) (7.38KB) (42μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (64.45ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (210μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (72μs)
  • afterRenderComponent com_content (66.71KB) (58.29ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.05KB) (14.87ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (29μs)
  • afterDispatch (34.5KB) (5.26ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (446μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (75.74KB) (128ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (28μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.29KB) (80.19ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (32μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (45μ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.73KB) (14.8ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (25μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (37μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (9.97ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (4.54ms)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (23μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (45μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (24μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (19μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (442μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (8.92ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (49μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift) (24.45KB) (6.7ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (20μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.16KB) (9.67ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (33μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (140μs)
  • afterRenderRawModule mod_custom () (22.27KB) (4.43ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (44μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (104μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (627μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (41μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (4.27ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (31μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.09KB) (5.12ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (45μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (178μs)
  • afterRenderRawModule mod_custom () (944B) (128μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (24μs)
  • beforeRenderRawModule mod_custom () (688B) (79μs)
  • afterRenderRawModule mod_custom () (896B) (89μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (20μs)
  • afterRender (181.73KB) (15.83ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (75.74KB) (24.23%)
    128.30ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.29KB) (15.15%)
    80.19ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (12.17%)
    64.45ms
    1 x afterRenderComponent com_content (66.71KB) (11.01%)
    58.29ms
    1 x afterInitialise (1.27MB) (7.9%)
    41.82ms
    1 x afterRoute (927.02KB) (3.76%)
    19.92ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.6%)
    19.04ms
    1 x afterRender (181.73KB) (2.99%)
    15.83ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.05KB) (2.81%)
    14.87ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.73KB) (2.79%)
    14.80ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.88%)
    9.97ms
    1 x afterRenderRawModule mod_finder () (214.16KB) (1.83%)
    9.67ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.68%)
    8.92ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (24.45KB) (1.27%)
    6.70ms
    1 x afterDispatch (34.5KB) (0.99%)
    5.26ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.97%)
    5.12ms
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.86%)
    4.54ms
    1 x afterRenderRawModule mod_custom () (22.27KB) (0.84%)
    4.43ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.81%)
    4.27ms
    1 x afterLoad (456.5KB) (0.78%)
    4.14ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.36%)
    1.92ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.12%)
    627μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.08%)
    446μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.08%)
    442μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.05%)
    250μs
    1 x beforeRenderComponent com_content (24.37KB) (0.05%)
    243μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.04%)
    210μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    178μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    140μs
    1 x afterRenderRawModule mod_custom () (944B) (0.02%)
    128μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    104μs
    1 x Before Access::getAssetRules (id:3021 name:com_content.article.1485) (130.65KB) (0.02%)
    93μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    89μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    79μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.01%)
    72μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    49μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    45μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    45μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    45μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    44μs
    1 x After Access::getAssetRules (id:3021 name:com_content.article.1485) (7.38KB) (0.01%)
    42μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    41μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    37μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    33μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    32μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    31μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0%)
    25μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    24μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    24μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (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%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    20μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    19μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    16μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    14μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μ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_languages (Sprogskift Mobil) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique316ms1.33MB
  • SELECT @@SESSION.sql_mode;98μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?158μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1114μ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.28ms944BParams/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` = 12.15ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`72μ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` = :guest134μ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`444μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC131μ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` = 1136μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config3.24ms1.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`3.91ms165.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`929μ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` = 12.87ms848B/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)552μ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` = 07.99ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.89ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1485'1.68ms48B/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.15ms22.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`1.3ms3.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)4.82ms4.06KBParams/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`332μ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 ASC2.43ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.24ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id97μ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`4.43ms180.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 DESC43.95ms161.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`1.02ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.1ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 02.98ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.83ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id87μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-03 00:11:41') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:11:41') AND c2.state = 13.16ms4.02KBParams/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 10124ms195.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-03 00:11:41', 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 1073.95ms2.66KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray6,:preparedArray7) ORDER BY a.created ASC LIMIT 104.2ms159.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`440μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id1.95ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 11.99ms640B/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)2.41ms584B/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 ASC296μ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)142μ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` = 1112μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?1.19ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.2ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy