Skip to main content

Many people with chronic diseases lack magnesium

- and a regular blood test cannot reveal it

 Many people with chronic diseases lack magnesiumAlthough humans generally live longer now, an increasing number of people suffer from chronic diseases. Our medicine consumption is steadily increasing, yet the underlying causes are not addressed, and it is often down to a lack of essential nutrients. Just think of magnesium, a nutrient that is involved in more than 300 different enzyme processes that are important for our nervous system, digestion, muscle function, heart function, blood pressure, bone health, pregnancy, and utilization of vitamin D. This also means that lack of magnesium may be involved in the development of asthma, stress, insomnia, constipation, migraines, neurological diseases, cardiovascular diseases, breast cancer, premature deliveries etc. A recent review article published in Scientifica looks at the importance of magnesium in clinical therapy, and it is vital that magnesium supplements are in a form that the body can absorb and utilize.

According to medical science, there are two concurrent phenomena: A neglect of the fact that chronic diseases are spreading like a bushfire, and the problem with widespread deficiency of specific nutrients. Although the scientific literature reveals a comprehensive insight into the different functions of the nutrients and their importance for human health, this knowledge is rarely used in medical practice. The blatant neglect may easily make things worse, because the underlying causes are not addressed, and a lot of the medicine that is used to control the symptoms has serious side effects. It is therefore important for us to get sufficient amounts of magnesium throughout life, as it may help us prevent a host of different diseases and conditions. Magnesium supplements can be taken separately or integrated as part of a medical treatment.

Magnesium and its many functions

Magnesium is one of the minerals that we humans need in the largest quantities. An adult person contains around 25 grams of magnesium. We have 53% in our bone tissue, 27% in muscle tissue, 19% in other soft tissues and less than 1% in our blood serum. Because only one percent is present in our serum, a normal blood test will not be able to give us a clear picture of our magnesium status.
Most of our magnesium is stored inside the cells, where it is involved in the energy turnover. Large magnesium concentrations are found inside our mitochondria, which are the cellular powerhouses. It is important to make sure to have the right balance between magnesium and calcium for the sake of bones and the cells in soft tissues.

Magnesium supports more than 300 different enzyme processes that are important for:

  • Energy turnover and energy levels
  • Protein synthesis
  • Muscle function and muscle contraction
  • Nerve function
  • Digestion
  • Blood sugar control
  • The hormone system
  • Heart and blood pressure
  • Proper control of the calcium channels in cell membranes
  • Strong bones. Magnesium (plus calcium and phosphorous) constitute the solid matter of bones
  • The activation of vitamin D, which all cells need

Why magnesium deficiency is so common

An estimated 56-58% of Americans do not get enough magnesium from their diets, if you look at the official recommendations, which are similar to those in Denmark (RI – reference intake – for adults is about 375 mg). The widespread magnesium deficiency problem, which is also seen among children and adults in Denmark, may be caused by several factors:

  • Fertilizers and pesticides reduce the magnesium content in crops
  • There is less magnesium in non-organic and refined foods
  • Regular staples like meat, white flour, and white rice provide less than 20% of the recommended daily intake of magnesium
  • Cooking, frying and baking lowers the magnesium content in food
  • Lack of vitamin D, which is quite common, impairs the body’s uptake of magnesium
  • Normal ageing can lower your magnesium uptake by up to 30%
  • Pregnancy increases the need for magnesium
  • Stress increases your need for magnesium
  • A large alcohol consumption increases the body’s magnesium excretion
  • Insulin resistance and type 1 and type 2 diabetes increase the body’s magnesium excretion
  • Diarrhea and Crohn’s disease increase your magnesium excretion
  • Your magnesium uptake may be impaired by diuretics, certain types of antibiotics, antacids, and anti-hypertensive medicine
  • Other types of medicine such as antihistamines, antacids, laxatives, hormone pills with estradiol, certain types of blood pressure medication, corticosteroids, anti-depressive medicine etc. may also reduce the body’s magnesium levels

A chronic magnesium imbalance can be a result of these general factors:

1: Reduced intake
Soil depletion combined with a diet that is not properly balanced and is too refined

2: Impaired uptake
Lack of vitamin D, gastro-intestinal disease, and consumption of certain types of medicine

3: Increased loss
Heavy sweating, diarrhea, use of laxatives, diabetes, alcohol, and medicine

4: Increased need
Stress, pregnancy, ageing processes, and deficiency diseases

Magnesium is involved in a host of different enzyme processes. Therefore, moderate to severe deficiency may cause different clinical symptoms. The following is just a brief review of the extensive research in this area.

Magnesium activates vitamin D

Humans synthesize vitamin D in the form of cholecalciferol by means of sunlight. It is also cholecalciferol that is found in vitamin D supplements. Aided by magnesium-containing enzymes, the liver converts cholecalciferol to 25-hydroxycholecalciferol D3 (also known as 25(OH)D) , which is the form of vitamin D that is measured in blood. When the body needs vitamin D, it converts 25(OH)D into the active form called 1,25-dihydroxycholecalciferol D3 with help from other magnesium-containing enzymes. This process takes place inside the kidneys. Being magnesium deficient can therefore lead to an array of diseases caused by a lack of active vitamin D. For example, if you attempt to treat Rickets by giving massive doses of vitamin D to a patient, who already lacks magnesium, the therapy will not work. This is because of magnesium’s role in several of the functions that are of relevance to the building of bones.

We need vitamin D to be able to absorb calcium, magnesium, and phosphorous.

Magnesium ensures the correct distribution of calcium to bones and soft tissues

Magnesium works like a door bolt in the calcium channel of cells. Here, it makes sure that the major share of calcium is channeled into the bone cells, while at the same time ensuring a very small calcium concentration in soft tissues such as nerves, muscles, and internal organs.
According to a number of studies, higher magnesium intake among older men and women is associated with increased bone density and a lower risk of osteoporosis. In contrast, a magnesium deficiency is linked to a greater risk of osteoporosis. Lack of magnesium also increases the risk of calcium flooding of the cells in soft tissues. Too much calcium tends to stress cells in soft tissues, and it may cause local inflammation, tension, cramps, atherosclerosis, and several other serious conditions.

Therefore, it is essential to have the right balance between calcium and magnesium

  • Facts about the relation between calcium and magnesium
  • According to the RI (reference intake) level, the relation should ideally be 2:1 (800 mg calcium/375 mg magnesium)
  • The actual ratio in Nordic diets is around 4:1
  • The ratio in Japanese diets is around 1:1
  • Milk contains around nine times more calcium than magnesium
  • Too little magnesium in relation to calcium has a number of negative effects on our health

Magnesium and asthma

The exact mechanisms have not yet been mapped out, but it looks as if lack of magnesium may cause severe bronchial spasms that make it difficult to breathe. The spasms typically occur in connection with asthma and bronchitis. To begin with, too little magnesium, especially if combined with a calcium overload, may stress the bronchial cells. Moreover, a magnesium deficiency may cause a lack of active vitamin D, which impairs the body’s ability to control inflammation.

Magnesium and pregnancy

Magnesium deficiencies are widespread among pregnant women, who have an increased need for the nutrient in the first place. Studies show that magnesium supplements given before the 25th week of pregnancy lowers the risk of premature delivery and low birth weight. Magnesium supplements also help reduce the risk of preeclampsia, which is a combination of elevated blood pressure and protein excretion in the urine. Preeclampsia may lead to life-threatening conditions.

Magnesium and migraines

Not only can magnesium supplements reduce the number of days with migraine attacks, they can also reduce their duration and severity plus lower the need for acute medication. This was shown in a placebo-controlled study that is published in the journal Cephalalgia. In this study, patients were given 600 mg of magnesium daily or placebo (dummy pills) for a 12-week period. Magnesium is believed to relieve migraine by protecting the nerve cells against calcium poisoning.

Magnesium, insulin resistance, and diabetes

Insulin works by moving sugar from the bloodstream into the cells. Insulin resistance is when the cellular uptake of sugar is impaired, and insulin levels in the blood are persistently high. Insulin resistance is also a part of what is known as metabolic syndrome, which is an early stage of type 2 diabetes.
People with metabolic syndrome generally have lower magnesium levels. Part of the explanation may lie in the fact that normal diets are low in magnesium, and that people with metabolic syndrome have increased magnesium excretion via the kidneys. For that reason, magnesium is important both for prevention and in therapy. Another important thing is that magnesium activates vitamin D, a nutrient that is also involved in blood sugar regulation. A study of type 1 diabetics suffering from neuropathy showed that they were helped with a 300 mg daily magnesium supplement taken for a period of five years.
Magnesium, anxiety, stress, and depression
We humans depend on magnesium-containing coenzymes that help us convert tryptophan to serotonin, a neurotransmitter that is vital for our mental well-being. Scientists at the University of Leeds in England have reviewed several studies showing that magnesium supplements may be useful as add-on therapy against mild anxiety, stress, and depression. It appears that magnesium is a precondition for a healthy and strong nervous system, and it is vital to get enough of the nutrient to prevent and treat these problems.

Magnesium, sleep, and restless legs

An estimated 50 percent of adults have sleep problems. In a study where participants took 500 mg of magnesium before bedtime, they had an easier time falling asleep, their sleep was deeper, and they slept longer. Magnesium supplements have actually been shown to raise blood levels of melatonin, a sleep hormone that we humans synthesize from serotonin during the night. However, our endogenous production of melatonin decreases with age, and it appears that a magnesium deficiency can decrease our melatonin production additionally. Supplementation with magnesium has also been shown to reduce problems with restless legs at night.

Magnesium and inflammation

Researchers from Mexico, Iran, and Australia have gathered data from many studies and looked at a certain protein that is a marker of inflammation in the body. According to the scientists, magnesium supplements may significantly reduce levels of this specific protein.
As mentioned earlier, magnesium controls inflammation by regulating the distribution of calcium and by activating vitamin D. As it turns out, inflammation is the common thread among most chronic diseases, even those that are not felt directly. This is because inflammation virtually bombards the body with free radicals.

Magnesium, vitamin D, and cancer

Lack of magnesium reduces the magnesium content in cells, where the nutrient is needed for energy turnover. Also, there is a risk of calcium flooding of the cells of the soft tissues such as nerves, connective tissue, and internal organs. This can stress the cells and set the stage for cancer. It is shown that a high ratio of calcium compared to magnesium increases the risk of breast cancer. Too little vitamin D also increases the risk of breast cancer, and it has been seen that magnesium is important for both the uptake and activation of vitamin D.

Magnesium and cardiovascular diseases

Lack of calcium can cause cardiovascular disease by way of several mechanisms. As mentioned earlier, magnesium’s role is to channel the lion’s share of calcium into bone cells, while making sure that only a limited amount of calcium gets into the other cells. When magnesium levels are too low, there is a risk of calcium flooding of cells in the soft tissues. This increases the risk of inflammation that sets the stage for atherosclerosis. Too little magnesium may also lead to elevated insulin levels and elevated triglycerides levels in the blood. A study shows that the quartile of patients with the highest magnesium intake had a 77% lower risk of dying of heart failure. Lack of magnesium may also result in atrial fibrillation.

Magnesium, AHDH, sclerosis, dementia, and Parkinson’s disease

Magnesium also has several roles in the nervous system, which is why the nutrient is important for our mental well-being. Most children with ADHD lack magnesium, and supplements have been shown to improve their symptoms significantly. Magnesium supplements can also reduce fatigue in patients with sclerosis, and they improve the memory of patients with dementia. In patients with Parkinson’s disease, scientists have observed lower levels of magnesium combined with elevated levels of aluminum, which is believed to contribute to the disease.

Deteting magnesium deficiencies

Although science has demonstrated that magnesium is vital for our health, it is difficult to measure, whether we get enough. It is also difficult to establish optimal levels for daily intake or for optimal blood levels. This is because most of our magnesium is stored inside our bone cells and other tissues. Moreover, a regular blood test only shows the magnesium content in serum. But because we have most of our magnesium inside our cells, full blood analyses are more accurate, as they measure the magnesium content inside and outside the cells.

Magnesium sources, supplements, and medicine

Some of the best sources of magnesium are kernels, almonds, nuts, whole grain, cabbage, and other compact vegetables. There are also nutritional supplements and certain types of medicine that contain magnesium. Among the magnesium types that are absorbed the best are magnesium carbonate, magnesium acetate, magnesium orotate, and magnesium amino acid chelate.
Magnesium oxide, a tablet excipient that is normally found in inexpensive magnesium supplements, is not very bioavailable and does not affect the body’s magnesium status. Magnesium oxide (Magnesia) is commonly used to treat heart burn and constipation.
There are magnesium supplements that contain not one but several types of magnesium to improve the highest level of bioavailability and utilization of the nutrient. High-dosed magnesium supplements are not associated with side effects. Rare cases of diarrhea have been observed, and the best way to avoid this is through a gradual dosage increase rather than a sudden one, or by lowering the dosage in the case of adverse effects. Many people actually find that magnesium supplements help their digestion.

References

Gerry K Schwalfenberg and Stephen J. Genius. The Importance of Magnesium in Clinical healthcare. Scientifica (Cairo). 2017

Kristian Sjøgren. Kroppen vælter I magnesium, men forskere kan ikke finde det. Videnskab.dk 2018

Helen Sauil Case. Magnesium demper hyperaktivitet blant AD/HD-barn. Helsemagasinet Vitenskap og Fornuft. N1 2017

Andrea Rosanoff et al. Essential Nutrient Interactions: Does Low or Suboptimal Magnesium Interact with Vitamin D and/or Calcium status. Advances in Nutrition 2016

Anna E. Kirkland et al. The Role of Magnesium in Neurological Disorders. Nutrients 2018

Mauskop A, Varughese J. : Why all migraine patients should be treated with magnesium. Journal of Neural Transmission 2012

Neil Bernard Boyle, Clare Lawton and Louise Dye. The Effects of magnesium Supplementation on Subjective Anxiety and Stress – A systematic Review. Nutrients 2017

L-.E. Simental-Mendia et al. Effects of magnesium supplementation on plasma C-reactive protein concentrations: A systematic review and meta-analysis of randomized controlled trials. Current Pharmaceutical Design. 2017

https://frida.fooddata.dk/

  • Created on .
8.906MBMemory Usage558msRequest 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" => 1743321369 "last" => 1743321369...
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.44KB) (3.32ms)
  • afterInitialise (1.27MB) (32.87ms)
  • afterRoute (897.2KB) (9.21ms)
  • beforeRenderComponent com_content (22.58KB) (247μs)
  • Before Access::preloadComponents (all components) (33.23KB) (3.73ms)
  • After Access::preloadComponents (all components) (97.34KB) (618μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (15μs)
  • After Access::preloadPermissions (com_content) (3.23MB) (10.47ms)
  • Before Access::getAssetRules (id:3825 name:com_content.article.1890) (130.65KB) (91μs)
  • After Access::getAssetRules (id:3825 name:com_content.article.1890) (7.38KB) (50μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.37MB) (45.81ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (174μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (108μs)
  • afterRenderComponent com_content (82.62KB) (31.57ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.72KB) (4.99ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (28μs)
  • afterDispatch (24.74KB) (1.8ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (433μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (74.73KB) (152ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (27μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (42μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (13μs)
  • afterRenderRawModule mod_tags_popular (Search) (46.1KB) (203ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (29μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (52μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (12μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (9.93ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (59μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (15μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (25μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (22μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (10μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (20μ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) (18.53KB) (1.43ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (2.62ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (62μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift) (19.97KB) (2.37ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (2.8ms)
  • beforeRenderRawModule mod_finder () (6.34KB) (17μs)
  • afterRenderRawModule mod_finder () (128.59KB) (6.5ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (141μs)
  • afterRenderRawModule mod_custom () (21.95KB) (7.81ms)
  • beforeRenderModule mod_custom () (704B) (7μs)
  • afterRenderModule mod_custom () (1.23KB) (54μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (105μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (744μs)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (3μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (42μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (4.6ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (36μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (12μs)
  • afterRenderRawModule mod_finder () (6.29KB) (593μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.73KB) (48μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (3.39ms)
  • afterRenderRawModule mod_custom () (944B) (155μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.43KB) (32μs)
  • beforeRenderRawModule mod_custom () (688B) (104μs)
  • afterRenderRawModule mod_custom () (896B) (98μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (23μs)
  • afterRender (197.63KB) (9.14ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (46.1KB) (36.33%)
    202.55ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (74.73KB) (27.28%)
    152.10ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.37MB) (8.22%)
    45.81ms
    1 x afterInitialise (1.27MB) (5.9%)
    32.87ms
    1 x afterRenderComponent com_content (82.62KB) (5.66%)
    31.57ms
    1 x After Access::preloadPermissions (com_content) (3.23MB) (1.88%)
    10.47ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.78%)
    9.93ms
    1 x afterRoute (897.2KB) (1.65%)
    9.21ms
    1 x afterRender (197.63KB) (1.64%)
    9.14ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (1.4%)
    7.81ms
    1 x afterRenderRawModule mod_finder () (128.59KB) (1.17%)
    6.50ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.72KB) (0.9%)
    4.99ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.82%)
    4.60ms
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.67%)
    3.73ms
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.61%)
    3.39ms
    1 x afterLoad (456.44KB) (0.6%)
    3.32ms
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.5%)
    2.80ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.47%)
    2.62ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (19.97KB) (0.43%)
    2.37ms
    1 x afterDispatch (24.74KB) (0.32%)
    1.80ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.26%)
    1.43ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.13%)
    744μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.11%)
    618μs
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.11%)
    593μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.08%)
    433μs
    1 x beforeRenderComponent com_content (22.58KB) (0.04%)
    247μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.03%)
    174μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    155μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    141μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.02%)
    108μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.02%)
    105μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    104μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    98μs
    1 x Before Access::getAssetRules (id:3825 name:com_content.article.1890) (130.65KB) (0.02%)
    91μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    62μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    59μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    54μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    52μs
    1 x After Access::getAssetRules (id:3825 name:com_content.article.1890) (7.38KB) (0.01%)
    50μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.01%)
    48μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    42μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    42μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    36μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    35μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    32μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.01%)
    29μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0%)
    27μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    25μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    23μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    23μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    16μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    15μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    15μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    14μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    13μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
44 statements were executed, 9 of which were duplicates, 35 unique407ms1.13MB
  • SELECT @@SESSION.sql_mode;299μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?403μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1203μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.88ms944BParams/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` = 1528μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`839μ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` = :guest101μ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`479μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC126μ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` = 11.11ms1008B/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`753μ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`270μ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` = 1201μ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)358μ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` = 06.13ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`934μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1890'1.88ms48B/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)728μs54.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`363μ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)3.16ms4.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`2.65ms3.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 ASC725μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id103μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id63μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `has_modules` AS `m` LEFT JOIN `has_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`2.9ms180.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 DESC24.37ms161.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.29ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1118μ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` = 0305μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id100μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id61μ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-03-30 07:56:09') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-30 07:56:09') AND c2.state = 11.36ms3.98KBParams/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 10142ms119.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.36ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 15198ms2.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` = :id190μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1834μ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)1.13ms584B/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 ASC3.35ms4.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)104μ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` = 11.62ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?1.27ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.23ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy