Skip to main content

Magnesium in large, bioavailable doses can relieve headaches and migraine

Magnesium in large, bioavailable doses can relieve headaches and migraineMagnesium deficiencies are rather common and can easily occur if you get too little magnesium from your daily diet. It has been known for a long time that lack of magnesium can cause tension headache and migraine. In fact, many randomized, double-blind studies show that high-dose magnesium supplements can relieve both migraine and headaches, provided the supplements have good bioavailability so the magnesium can enter the cells, where it controls a dozen of enzyme processes. A review article written by Italian scientists from Milan and published in the journal Nutrients takes a closer look at this.

In most cases, headaches and migraine occur independently of other conditions or diseases. This is also the case with Horton’s disease (cluster headache). It is well-known that these types of headache and migraine headaches are often triggered by stress and hormonal changes associated with PMS and menopause. According to the authors behind the new review article, magnesium supplements may be a useful alternative to traditional painkillers that are associated with side effects. What is more, a magnesium supplement compensates for the deficiency that is the underlying cause of the of the headache or the migraine. Magnesium is a simple and rather obvious type of therapy, which most people (including children, pregnant women, and seniors) can take without any problems.

Magnesium has many functions and is concentrated primarily inside the cells

Magnesium is one of the minerals that we need in the greatest quantities. It is of vital importance to nerve impulses, muscle contraction, blood pressure, blood sugar, bones, DNA synthesis, maintenance of the electrolyte balance, vitamin D activation, and many other things.
Around half of the body’s magnesium is stored in our bones. The remaining part is found in nerve cells, muscle cells, the liver and other soft tissues. We have nearly all of our magnesium inside the cells, where it fuels well over 300 different enzyme processes.
For over 20 years, science has described the different magnesium transporters and magnesium channels in the cell membranes, but it remains a mystery how magnesium works inside the cells. This is what the authors have taken a closer look in their article in Nutrients.

Absorption and regulation of magnesium levels in the blood

Magnesium is absorbed in the small intestine. In the kidneys, 80 percent of the magnesium in our blood is filtered by the glomerulus, which is a network of blood capillaries, through which our urine is excreted. More than 95 percent of the filtered magnesium is reabsorbed by this system. If there is too little magnesium, a higher quantity of the nutrient is reabsorbed, whereas less is reabsorbed if magnesium levels are adequate. In the case of severe magnesium deficiency, the bones serve as a mineral bank, from where magnesium is withdrawn and circulated in the bloodstream.
That way, magnesium levels in the blood are carefully managed in a concept that involves the uptake in the small intestine and excretion from the kidneys, with the bones serving as a buffer. But even though the body has several mechanisms for regulating its magnesium levels in the blood, deficiencies are surprisingly common.

Sources of magnesium and reasons why deficiencies are widespread

You get magnesium from kernels, almonds, nuts, seeds, beans, whole grain, cabbage, and many other vegetables. Most people in the Western countries do not reach the recommended intake levels for magnesium (375 mg/day in Denmark), which is primarily due to nutrient-depleted soil, refined foods, and unhealthy eating habits. Deficiencies may also be caused by poor absorption or increased magnesium excretion from the kidneys. Stress, stimulants, and medicine may also increase the need for magnesium.
It is difficult to measure the body’s magnesium levels, as only approximately one percent of the nutrient is found in our blood, while the remainder is concentrated inside our cells. The best way to determine the body’s magnesium status is to conduct a so-called whole blood analysis that measures the intracellular magnesium content. In some cases, a magnesium deficiency may be masked if the bones are able to deliver magnesium to the blood. This may continue for a period, but the risk of osteoporosis eventually increases because the bones need magnesium for their absorption of calcium.

Why use magnesium supplements if you have headaches or migraine?

Magnesium helps prevent or relieve headaches and migraine by way of several mechanisms. As mentioned earlier, magnesium is involved in over 300 different enzyme processes that are vital for proper functioning of cells, including nerve cells. A lack of magnesium may disrupt the body’s release of certain neurotransmitters, the constriction of blood vessels, muscle contraction etc., thereby resulting in headaches and migraine, including migraine with aura.
One of magnesium’s main functions is to serve as a door bolt in the calcium channels of the cell membranes. In bone cells, magnesium makes sure that most of the calcium is channeled into the cells. However, in cells in soft tissues like muscles and nerves, where the calcium concentration must be limited to a minimum, magnesium does the opposite by making sure that most of the calcium stays on the outside. If you lack magnesium, the calcium channels are left open and you risk that the nerve cells (and cells in other soft tissues) are flooded by calcium ions. This may overstimulate the nerve cells and cause them to cramp or malfunction in other ways.
Magnesium is involved in the control of NDMA glutamate (N-methyl-D-aspartate) receptors in the nerve cells that are important for pain transmission in the nervous system. Magnesium also helps regulate the cerebral blood flow and prevent local inflammation. Magnesium deficiencies are therefore involved in a host of neurological diseases, including Alzheimer’s disease and Parkinson’s disease.

Magnesium supplement as an effective therapy

Multiple studies show that patients with headaches and migraine have too little magnesium in their blood, spinal fluid, and certain parts of the brain. This also goes for patients suffering from migraine with aura. Researchers have pointed out that these patients may have systemic magnesium deficiency. The therapeutic effect of giving magnesium supplements to patients suffering from headaches has been documented in numerous double-blind, placebo-controlled, randomized studies.
It is already known that magnesium levels in the red blood cells of women suffering from premenstrual syndrome (PMS) are lower than in women without this condition. In a study of 20 women with PMS-related migraine, one half got 360 mg of magnesium from the time of ovulation until the beginning of their menstrual period over two cycles, while the other half got placebo. Magnesium turned out to reduce both the frequency and severity of headaches when evaluated through a pain index.
In another study, 81 migraine patients were either given 600 mg of magnesium daily or matching placebo for a period 12 weeks. In the period between the ninth and 12th week, the migraine attacks were reduced by 41.6% in the magnesium group and only 15.8% in the placebo group.
A study of children and youngsters aged 2-17 years, where the participants got magnesium in a daily dose of 9 mg per kilogram of body weight or matching placebo, revealed that the supplement had significantly reduced the number of days with headache.
A meta-analysis from 2016 also showed that magnesium supplementation had a therapeutic effect. The meta-analysis included 11 studies, in which patients with acute migraine attacks received intravenous magnesium, and 10 studies where the scientists looked at magnesium’s preventive effect on migraine. By and large, the meta-analysis demonstrated that magnesium has a positive effect in the acute and preventive treatment of migraine, and that magnesium supplementation is able to reduce the number of days with migraine by 22-43 percent.
According to the recent review article in Nutrients, several studies suggest that magnesium supplements not only reduce the number of days with headaches and migraine attacks but also their duration and severity, and it even helps reduce the need for acute medication.
Usually, daily doses of 360-600 mg are given to adults, and the optimal effect is normally seen after a few weeks.
The authors also mention a study where magnesium given to migraine patients did not have any effect and actually caused side effects such as diarrhea, but that was due to the fact that the supplement had poor absorption. It is imperative always to take high-quality magnesium supplements that are easily absorbed in the small intestine, so the magnesium can enter the cells.

The quality of supplements is crucial

Magnesium deficiency is normally treated with magnesium salts that are either organic or inorganic as listed below:

Inorganic magnesium salts:

  • Magnesium carbonate, magnesium chloride, magnesium oxide, magnesium sulphate

Organic magnesium salts:

  • Magnesium acetate, magnesium aspartate, magnesium citrate, magnesium gluconate, magnesium lactate, magnesium pidolate

Some magnesium supplements contain a blend of organic and inorganic magnesium sources, which gives better utilization. Some magnesium supplements are absorbed better than others. If the tablets pass through the digestive system without dissolving, you cannot expect them to work. A good way to test this is to drop a magnesium tablet into a glass of water to see how fast it dissolves. If it dissolves within less than a minute, you are pretty much guaranteed that the body can absorb the magnesium content in the small intestine.
Just for the record, magnesium oxide that is found in various supplements and in the laxative called Magnesia has poor bioavailability.
According to the listed studies, migraine patients can take a 200 mg supplement of magnesium three times daily with a main meal for 12 weeks or longer if it appears to have a positive effect.

Beware of other factors that can trigger a migraine effect:

  • Histamine-containing or histamine-releasing foods such as cheese, red wine, marinated and pickled foods, chocolate, and monosodium glutamate (MSG)
  • Low blood sugar levels and dehydration
  • Misaligned teeth (crooked bite)

References:

Jeanette A. Maier et al. Headaches and Magnesium: Mechanisms, Bioavailability, Therapeutic Efficacy and Potential Advantage of Magnesium Pidolate. Nutrients. 2020

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

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

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

A Peikert et al. Prophylaxis of Migraine with Oral Magnesium: Results from a Prospective, Multi-Center, Placebo-Controlled and Double-blind Study. Cephalalgia 1996

https://politiken.dk/forbrugogliv/livsstil/art5041849/Et-skævt-bid-kan-give-dig-migræne

 

  • Created on .
8.889MBMemory Usage398msRequest Duration
Joomla! Version4.4.4
PHP Version8.3.6
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.40-0ubuntu0.24.04.1
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "8c48c4b25e7bfaf1e1e1af15958abb70" => "u9g0krq5r5jq19c4ueuimnc1c4" ]
$_SERVER
array:47 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1738542268 "last" => 1738542268...
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.81KB) (475μs)
  • afterInitialise (1.28MB) (43.78ms)
  • afterRoute (926.49KB) (16.33ms)
  • beforeRenderComponent com_content (24.37KB) (284μs)
  • Before Access::preloadComponents (all components) (35.84KB) (3.3ms)
  • After Access::preloadComponents (all components) (97.34KB) (3.39ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (17μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (30.77ms)
  • Before Access::getAssetRules (id:5621 name:com_content.article.2775) (130.65KB) (97μs)
  • After Access::getAssetRules (id:5621 name:com_content.article.2775) (7.38KB) (53μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (69.7ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (233μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (81μs)
  • afterRenderComponent com_content (66.74KB) (36.31ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.09KB) (8.23ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (30μs)
  • afterDispatch (17.7KB) (3.02ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (485μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (106ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.21KB) (38.92ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (26μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (46μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (22μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (4.78ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (25μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (40μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (21μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (5.06ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (60μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (16μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (25μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (21μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (17μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (19μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (8μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (19μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (1.47ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.42ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (51μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (2.45ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (21μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.53KB) (4.53ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (1.12ms)
  • afterRenderRawModule mod_custom () (22.3KB) (869μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (60μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (106μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.44ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (48μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.69ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (33μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.09KB) (707μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.23KB) (43μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (177μs)
  • afterRenderRawModule mod_custom () (944B) (132μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (26μs)
  • beforeRenderRawModule mod_custom () (688B) (83μs)
  • afterRenderRawModule mod_custom () (896B) (91μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (177.95KB) (6.42ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (26.65%)
    106.12ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (17.5%)
    69.70ms
    1 x afterInitialise (1.28MB) (10.99%)
    43.78ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.21KB) (9.77%)
    38.92ms
    1 x afterRenderComponent com_content (66.74KB) (9.12%)
    36.31ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (7.73%)
    30.77ms
    1 x afterRoute (926.49KB) (4.1%)
    16.33ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.09KB) (2.07%)
    8.23ms
    1 x afterRender (177.95KB) (1.61%)
    6.42ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.27%)
    5.06ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (1.2%)
    4.78ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.14%)
    4.53ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.85%)
    3.39ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.83%)
    3.30ms
    1 x afterDispatch (17.7KB) (0.76%)
    3.02ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (0.62%)
    2.45ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.61%)
    2.42ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.42%)
    1.69ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.37%)
    1.47ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.36%)
    1.44ms
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.28%)
    1.12ms
    1 x afterRenderRawModule mod_custom () (22.3KB) (0.22%)
    869μs
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.18%)
    707μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.12%)
    485μs
    1 x afterLoad (456.81KB) (0.12%)
    475μs
    1 x beforeRenderComponent com_content (24.37KB) (0.07%)
    284μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.06%)
    233μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    177μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    132μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.03%)
    106μs
    1 x Before Access::getAssetRules (id:5621 name:com_content.article.2775) (130.65KB) (0.02%)
    97μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    91μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    83μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.02%)
    81μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    60μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    60μs
    1 x After Access::getAssetRules (id:5621 name:com_content.article.2775) (7.38KB) (0.01%)
    53μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    51μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    48μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    46μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    43μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    40μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    33μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    26μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    25μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    22μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    22μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    21μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    21μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    19μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    19μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    17μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique241ms1.33MB
  • SELECT @@SESSION.sql_mode;49μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?107μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 11.34ms1.31KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `has_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id1.69ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `has_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1278μs1.56KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`72μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `has_usergroups` AS `a` LEFT JOIN `has_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest780μ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`761μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.9ms2.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` = 12.32ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config177μ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`4.8ms165.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`330μ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` = 1216μ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)482μ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` = 016.04ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.41ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2775'3.03ms48B/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)3.17ms22.19KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.2ms3.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)6.4ms4.06KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.25ms3.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 ASC3.99ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.98ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.98ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `has_modules` AS `m` LEFT JOIN `has_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`6.73ms180.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 DESC26.89ms161.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`629μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1229μ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` = 0797μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.47ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id738μ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:24:30') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:24:30') AND c2.state = 12.67ms3.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 10102ms195.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:24:30', 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 1036.16ms2.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.84ms159.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`401μ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` = :id149μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1281μ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)145μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC310μ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)148μ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` = 1136μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?112μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.51ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy