Skip to main content

The link between magnesium deficiency, overweight, diabetes, and metabolic disorders

The link between magnesium deficiency, overweight, diabetes, and metabolic disordersMagnesium supports hundreds of different enzyme processes that are involved in energy turnover, sugar metabolism, nerves, and several other basic functions. Unfortunately, magnesium deficiency is rather common and more and more studies suggest that this may be related to a host of metabolic disturbances such as overweight, insulin resistance, type 2 diabetes, hypertension, elevated cholesterol, and chronic low-grade inflammation that is seen in connection with most chronic diseases. On the other and, it appears that high intake of magnesium from the diet or from supplements may help. In a new review article that is published in Nutrients, the authors look at magnesium deficiency and its role in the development of metabolic disorders. They also look at factors such as nutrient-depleted farmland, unhealthy diets, poor nutrient uptake, insulin resistance, the use of medicine, alcohol abuse, and stress that can potentially result in a magnesium deficiency.

Magnesium is one of the minerals that we need in the greatest quantities. We primarily get it from coarse greens, whole grain, kernels, almonds, nuts, bananas, cabbage, spinach, avocado and other vegetables, tofu, and dark chocolate. Around half the body’s magnesium is stored in bone tissue. The remaining part is found in muscles and soft tissues like nerves and blood vessels where it supports over 300 different enzyme processes. Magnesium is needed for the following functions:

  • RNA and DNA synthesis
  • Carbohydrate and lipid metabolism
  • Insulin sensitivity
  • Cell membrane stability
  • Calcium and bone metabolism
  • The nervous system
  • The immune system

Activation and utilization of vitamin D

The European Food Safety Authority (EFSA) recommends women to get 300 mg of magnesium daily, while men are advised to get 350 mg. Nonetheless, magnesium deficiencies are rather common in the western world due to farming methods, food refinement, and unhealthy diets. Poor nutrient uptake, bowel diseases, insulin resistance, diabetes, impaired renal function, pregnancy, alcohol abuse, diuretics, and stress can also result in a magnesium deficiency. It is difficult to measure magnesium levels in the blood because the lion’s share of the mineral is stored inside our cells. A whole blood analysis is the best way to determine a person’s magnesium status.
Early signs of a magnesium deficiency are fatigue, muscle twitching, constipation, cramps, or insomnia. Magnesium deficiency is also shown to have a relation to cardiovascular disease (arrhythmias, heart failure, and stroke), headaches, respiratory diseases, and depression. Over the past years, there has been increasing focus on magnesium deficiencies and their link to various metabolic disorders such as overweight, insulin resistance, type 2 diabetes, hypertension, changes in the body’s lipid metabolism, atherosclerosis, and higher risk of cardiovascular diseases. These pathologies are all characterized by chronic low-grade inflammation. In their new review article, the authors look closer at magnesium’s role in these metabolic disorders.

  • Around 30-50 percent of people in the Western world are believed to get too little magnesium from their diets
  • Overweight, diuretics, alcohol abuse, stress, insulin resistance, diabetes, and other chronic diseases may increase the need for magnesium

Magnesium and overweight

According to WHO, two billion people worldwide are overweight, while 650 million people are obese and have a BMI that is higher than 30. Obesity is also characterized by a large waist circumference and dangerous visceral fat around the vital organs.
Studies suggest an inverse relation between magnesium intake and the risk of becoming overweight – in both children and adults. Studies have also shown that overweight women with polycystic ovary syndrome (PCOS) have lower levels of magnesium in their body.
Being magnesium-deficient can negatively affect a host of different metabolic processes that control blood sugar levels, weight, and hormone balance.
There is already quite a lot of research that points to magnesium supplementation as a way to help overweight people reduce their waist circumference and protect them against additional weight gain, but more research is needed to confirm these findings. In connection with weight loss, it pays to stick with coarse and green foods that contain fewer carbohydrates, provide healthy fats and plenty of protein to stabilize blood sugar levels.

Magnesium and elevated blood pressure

Elevated blood pressure increases the risk of heart failure and stroke. According to WHO, 1.9 billion people in the age group 30-79 years suffer from hypertension, and the number is on the rise. Around half of these people are unaware that they have elevated blood pressure, and their problem is a ticking health for their health. Magnesium’s ability to regulate blood pressure is due to its function in cell membranes where it regulates the calcium uptake in cells. This is how magnesium makes sure to channel nearly all calcium into bone cells, while it makes sure to keep calcium concentrations in soft tissues down to a minimum. Soft tissues include blood vessels, muscles, and nerves. If cells in soft tissues are flooded by calcium ions, they become overstimulated. This cases muscles cramps and cellular stress. Patients with hypertension often have too much calcium and too little magnesium in the cell membranes in soft tissues.
In their review article, the authors mention different studies where supplementation with magnesium has been shown to lower both the systolic and the diastolic blood pressure.

  • The calcium-magnesium ratio is of vital importance
  • Too much calcium and too little magnesium increases the risk of cellular stress and many metabolic disturbances.

Magnesium, metabolic syndrome, and diabetes

Metabolic syndrome is a widespread metabolic disease that is insidious and is characterized by insulin resistance, hypertension, elevated blood lipid levels, enlarged waist circumference, and increased risk of type 2 diabetes. The risk of metabolic syndrome increases with age. When people are in their twenties, there risk of metabolic syndrome is around 10 percent, but when they reach their sixties, their risk goes up to 40 percent. According to studies, magnesium deficiencies are seen in up to half the cases (13.5 – 47.7%) of type 2 diabetes. It’s believed that lack of magnesium contributes to the metabolic disturbances because magnesium is important for insulin sensitivity and macronutrient metabolism. Studies also show that low magnesium levels in blood serum have a negative impact on BMI and diabetes variables such as insulin levels, insulin resistance, fasting blood sugar, and long-term blood sugar (HbA1c).
In their review article, the authors mention a meta-analysis that showed how increased magnesium intake was linked to a lower risk of developing metabolic syndrome. It also appears that patients with type 2 diabetes have a tendency to excrete too much magnesium in their urine, which turns it into a vicious cycle. For that reason, diabetics may need more magnesium than the officially recommended intake level.

Magnesium, cholesterol, and lipid metabolism

Metabolic syndrome is characterized by elevated levels of triglycerides and LDL cholesterol. This typically happens when the liver is flooded by carbohydrates, which turns it into a virtual fat factory. Metabolic syndrome is also characterized by insulin resistance and elevated insulin levels that can lead to chronic low-grade inflammation. This condition generates excessive amounts of free radicals. One of the really harmful effects of free radicals is when they attack cholesterol and oxidize it, making it useless for building cell membranes and producing steroid hormones, vitamin D, and coenzyme Q10. The oxidized cholesterol is devoured by white blood cells (macrophages) that then turn into foam cell and are embedded in the blood vessel walls. Cholesterol is only dangerous when it is oxidized and has the potential to form atherosclerotic plaque.
Many studies have demonstrated a direct link between low magnesium and disturbances in the body’s lipid metabolism. For example, scientists have found that 65.5 percent of patients with metabolic syndrome have low magnesium levels in their blood, where only 4.9 percent of healthy controls lacked magnesium. It is believed that magnesium can improve the body’s lipid metabolism in several different ways.

Magnesium and inflammation

Acute inflammation is a natural immune reaction to infections and cellular damage. However, inflammation involves the formation of free radicals, so it is imperative for the body to keep its free radical attacks on a short leash. Ageing, metabolic syndrome, type 2 diabetes, and the majority of chronic diseases are linked to chronic low-grade inflammation that is very harmful. Chronic inflammation means that the body is constantly exposed to an excess of free radicals that attack cholesterol and other lipids and can start chain reactions that can damage healthy cells and tissues. With chronic low-grade inflammation, levels of inflammation markers such as CRP, white blood cells, fibrinogen, IL-6, and TNF-α are typically elevated. Numerous studies have shown that the levels of these markers are linked to the body’s magnesium status.
Apparently, magnesium affects inflammation through different mechanisms. One mechanism is to block the calcium channels in cell membranes to prevent calcium ions from flooding the cells. If cells contain too many calcium ions, they may release a surplus of pro-inflammatory markers like CRP, IL-6, and TNF-α.
Magnesium deficiency can also result in systemic stress in the body which affects the nervous system and other systems such as the renin-angiotensin system (RAAS). In the new meta-analysis that is published in Nutrients, the authors mention various studies where magnesium supplementation has been shown to have a positive effect on inflammation.
It should also be noted that magnesium-containing enzymes are needed to help the body activate the kind of vitamin that we get through sun exposure of from supplements. That way, magnesium also helps prevent chronic low-grade inflammation. The effect of magnesium is better if you also get plenty of vitamin D.

  • It’s best to get magnesium from a coarse, green diet because this also provides fibers and other nutrients
  • Make sure to choose a high-quality magnesium supplement that the body is able to absorb and utilize
  • You need plenty of vitamin D if you want to benefit from taking magnesium

References:

Ligia J Dominguez et al. The Role of Magnesium in the Pathogenesis of Metabolic Disorders. Nutrients 2022 May

Nicola Veronese et al. Effect of Magnesium Supplementation on Inflammatory Parameters: A Meta-Analysis of Randomized Controlled Trials. Nutrients 2022.

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

Metabolisk syndrom - Patienthåndbogen på sundhed.dk

Samfundsøkonomien og diabetes | Forskning | Samfund

  • Created on .
8.894MBMemory Usage498msRequest 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" => 1738540945 "last" => 1738540945...
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.63KB) (8.8ms)
  • afterInitialise (1.27MB) (36.36ms)
  • afterRoute (927.02KB) (20.93ms)
  • beforeRenderComponent com_content (24.37KB) (209μs)
  • Before Access::preloadComponents (all components) (35.84KB) (286μs)
  • After Access::preloadComponents (all components) (97.34KB) (2.71ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (17μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (22.31ms)
  • Before Access::getAssetRules (id:7423 name:com_content.article.3677) (130.65KB) (111μs)
  • After Access::getAssetRules (id:7423 name:com_content.article.3677) (7.38KB) (56μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (75.05ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (182μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (75μs)
  • afterRenderComponent com_content (66.73KB) (50.22ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.16KB) (9.81ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (31μs)
  • afterDispatch (17.69KB) (6.02ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (951μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (145ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (3.04ms)
  • afterRenderRawModule mod_tags_popular (Search) (19.24KB) (69.47ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (24μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (42μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (23μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.76KB) (7.1ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (27μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (47μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (24μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (3.53ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (59μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (27μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (11μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (22μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (17μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (22μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (9μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (21μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (21μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (397μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (3.47ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (62μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (3.77ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.53KB) (12.09ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (139μs)
  • afterRenderRawModule mod_custom () (22.3KB) (1.84ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (103μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.66ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (52μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (674μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (1.05ms)
  • beforeRenderRawModule mod_finder () (2.3KB) (11μs)
  • afterRenderRawModule mod_finder () (6.09KB) (521μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.23KB) (44μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (177μs)
  • afterRenderRawModule mod_custom () (944B) (129μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (98μs)
  • afterRenderRawModule mod_custom () (896B) (92μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (181.95KB) (6.49ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (29.01%)
    144.55ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (15.06%)
    75.05ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.24KB) (13.94%)
    69.47ms
    1 x afterRenderComponent com_content (66.73KB) (10.08%)
    50.22ms
    1 x afterInitialise (1.27MB) (7.3%)
    36.36ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (4.48%)
    22.31ms
    1 x afterRoute (927.02KB) (4.2%)
    20.93ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (2.43%)
    12.09ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.16KB) (1.97%)
    9.81ms
    1 x afterLoad (456.63KB) (1.77%)
    8.80ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.76KB) (1.42%)
    7.10ms
    1 x afterRender (181.95KB) (1.3%)
    6.49ms
    1 x afterDispatch (17.69KB) (1.21%)
    6.02ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (0.76%)
    3.77ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (0.71%)
    3.53ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.7%)
    3.47ms
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.61%)
    3.04ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.54%)
    2.71ms
    1 x afterRenderRawModule mod_custom () (22.3KB) (0.37%)
    1.84ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.33%)
    1.66ms
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.21%)
    1.05ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.19%)
    951μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.14%)
    674μs
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.1%)
    521μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.08%)
    397μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.06%)
    286μs
    1 x beforeRenderComponent com_content (24.37KB) (0.04%)
    209μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.04%)
    182μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    177μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    139μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    129μs
    1 x Before Access::getAssetRules (id:7423 name:com_content.article.3677) (130.65KB) (0.02%)
    111μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    103μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    98μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    92μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.02%)
    75μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    62μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    59μs
    1 x After Access::getAssetRules (id:7423 name:com_content.article.3677) (7.38KB) (0.01%)
    56μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    55μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    52μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    47μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    44μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    42μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    35μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    31μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0%)
    24μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    23μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    22μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    21μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    17μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    17μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    11μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique313ms1.33MB
  • SELECT @@SESSION.sql_mode;417μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?101μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 168μ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)2.29ms944BParams/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` = 1280μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`2.14ms656B/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` = :guest142μ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`520μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC141μ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` = 1133μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config173μ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`752μ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`4.02ms3.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` = 1263μ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)601μ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` = 010.62ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`590μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3677'2.42ms48B/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.28ms22.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`300μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)2.24ms4.11KBParams/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`363μ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.74ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id105μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id76μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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.07ms180.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 DESC45.22ms161.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`325μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1133μ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` = 03.27ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.47ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id218μ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:02:25') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:02:25') AND c2.state = 12.77ms3.97KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.title ASC LIMIT 10142ms195.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:02:25', 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 1068.01ms2.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 101.17ms159.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`395μ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` = :id670μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 15.2ms640B/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.99ms584B/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 ASC487μ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)141μ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` = 1130μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?100μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.79ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy