Skip to main content

Magnesium supplements counteract inflammation

- that is involved in atherosclerosis, rheumatism, and most other chronic diseases

Magnesium supplements counteract inflammationScientists from Mexico, Iran, and Australia have gathered data from several studies and focused on a certain protein that is a marker of inflammation in the body. According to the researchers, magnesium supplements can significantly reduce levels of this protein. Because magnesium deficiencies are widespread, it seems obvious to administer magnesium supplements as part of the anti-inflammatory treatment, especially because inflammation is not always easy to detect and may even set the stage for a host of other chronic diseases. It is important, however, to balance magnesium with calcium. This is a general rule both in the prevention and treatment of all chronic inflammatory conditions.

Magnesium is a co-factor of more than 350 different enzyme processes that control such things as the body’s energy turnover, the nervous system, our muscle function, blood pressure, blood sugar levels, the fluid balance, and bone health. The new study, which is published in the journal Current Pharmaceutical Design, reveals that magnesium has an anti-inflammatory role. This is backed by earlier studies showing that too little magnesium in the body, especially if there is also too much calcium, increases the risk of inflammation.

Magnesium deficiencies are widespread

We get most of our magnesium from sources like kernels, almonds, nuts, whole-grain, cabbage, and other solid vegetables. An estimated 70-80% of Americans lack magnesium, but magnesium deficiencies are also common in Denmark, and the problem mainly results from eating an unbalanced diet with too many refined foods. A large consumption of sugar, alcohol, and other stimulants plus diuretics and stress may also deplete the body’s levels of this essential nutrient. Insulin resistance that is characterized by impaired uptake of glucose in the cells may also deplete our magnesium levels, and in many cases, the above listed factors aggravate each other.

The meta-analysis

The researchers from Mexico, Iran, and Australia looked at 11 randomized, controlled studies. They focused on how the use of magnesium supplements affected blood levels of C-reactive protein (CRP), which is a marker of inflammation in the body.
When looking at the overall data, magnesium supplements did not seem to affect levels of CRP. However, when the scientists only looked at those study participants, who had elevated CRP levels, magnesium supplementation was associated with a significant reduction in levels of CRP. According to the researchers, this indicates that magnesium supplements may reduce levels of CRP in individuals with inflammation in the body. It is therefore obvious to use magnesium supplements as part of the anti-inflammatory therapy.

Magnesium, calcium, and inflammation

Magnesium’s anti-inflammatory effect is involved in several mechanisms. This was seen in earlier studies published in the Archives of Biochemistry and Biophysics. When researchers depleted magnesium levels in rats, they could see after a few days that the rats developed clinical inflammatory syndromes that were characterized by an activation of white blood cells (lymphocytes and macrophages) and an increased production of cytokines and free radicals. On the other side, the inflammatory processes decreased as soon as the rats were fed sufficient amounts of magnesium.
Magnesium and calcium are antagonists, and it is therefore believed that the molecular basis for inflammation may be associated with too many calcium ions inside the cells. This “stresses” the cells and causes them to release different pro-inflammatory substances. Focus has traditionally been aimed at getting enough calcium to build strong bones and teeth, as these tissues contain around 99% of the body’s calcium. However, it is every bit as important to make sure that the amount of calcium in muscles, the liver, nerve tissue and other soft tissues is extremely small.

It is believed that the molecular basis for inflammation may be associated with too little magnesium and too much calcium inside the cells of soft tissue.

Magnesium controls the distribution of calcium

Magnesium is located in the cellular membrane where it functions as a “doorman” that controls how much or how little calcium enters the cell. Magnesium makes sure to maximize the calcium content in bones and teeth and minimize the calcium content in all the soft tissues. However, if we have a magnesium deficiency, we may not get enough calcium into our bone cells, leaving us at an increased risk of osteoporosis. At the same time, a lack of magnesium may increase our risk of having too much calcium in the cells of soft tissues. As mentioned earlier, this may stress the cells and cause inflammation. We may also experience tensions, cramps, and other serious conditions when there is too much calcium in the soft tissue.

Did you know that

  • there is nine times more calcium than magnesium in milk
  • too much calcium and too little magnesium can be bad for your health for a number of reasons

Inflammation, atherosclerosis, rheumatism, diabetes, and other chronic diseases

Chronic inflammation causes free radicals to assail the body. Free radicals are aggressive molecules with the ability to cause chain reactions that damage cells and cause disease and decay. Although inflammation is not something that you feel directly, it may wreak havoc in the entire body and set the stage for atherosclerosis, rheumatic diseases, diabetes, and other metabolic imbalances.
Both the new study and the earlier study on rats show that lack of magnesium may help account for the onset of inflammation and the development of many chronic diseases.

The balance between magnesium and calcium

As described, there is an intricate interplay between calcium and magnesium inside the cells. For that reason, it is vital to have the proper balance between the two nutrients. The calcium-magnesium ratio should ideally be 2:1. In Asia, however, where most people do not consume dairy products but eat more vegetables, the ratio is probably closer to 1:1. Not only does this balance seem to be better for bone health, it also seems to be effective for preventing inflammation and an array of chronic diseases rarely seen in Asia.

Important

There is no problem in taking a magnesium supplement alone. However, never take a calcium supplement without including magnesium

A simple quality test of magnesium supplements

Some magnesium supplements contain a blend of organic and inorganic magnesium compounds to give a better effect. Still, this is no guarantee of their bioavailability. A good way to test your magnesium product is by putting a magnesium tablet in a glass of water and watching it dissolve. If it has dissolved in the water within a minute, you can be sure that it will have dissolved in the same amount of time – or faster – in your stomach. The fast dissolution of the tablet gives you a better guarantee that the body can absorb the nutrient.

Magnesium status measurements are often misleading

It is difficult to measure the body’s magnesium status, as one percent of our magnesium is found in the blood. The most accurate measurement is a so-called whole blood analysis that also measures the magnesium content inside the blood cells.

References:

L-.E. Simental-Mendia et al. Effects of magnesium supplementation on plasma C-reactive protein concentrations: A systematic review and meta-analysis of randomized controlled trials. Current Pharmaceutical Design. 2017
https://www.ncbi.nlm.nih.gov/pubmed/28545353

Stephen Daniels. Magnesium supplements show potential anti-inflammatory effects: Meta-analysis. 2017
http://www.nutraingredients.com/Research/Magnesium-supplements-show-potential-anti-inflammatory-effects-Meta-analysis

Andrzej Mazura et al. Highlight Issus on cellular Regulation of Magnesium. Archives of Biochemistry and Biophysics 2007

http://www.sciencedirect.com/science/article/pii/S0003986106001366

http://www.nutritionalmagnesium.org/magnesium-calcium-and-inflammation/

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

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

  • Created on .
8.878MBMemory Usage365msRequest 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" => 1738541049 "last" => 1738541049...
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.44KB) (416μs)
  • afterInitialise (1.27MB) (33.71ms)
  • afterRoute (927.02KB) (13.5ms)
  • beforeRenderComponent com_content (24.37KB) (279μs)
  • Before Access::preloadComponents (all components) (35.84KB) (259μs)
  • After Access::preloadComponents (all components) (97.34KB) (2.75ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (13ms)
  • Before Access::getAssetRules (id:2495 name:com_content.article.1225) (130.65KB) (90μs)
  • After Access::getAssetRules (id:2495 name:com_content.article.1225) (7.47KB) (49μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (50.62ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (1.26ms)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (90μs)
  • afterRenderComponent com_content (66.73KB) (37.95ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.96KB) (3.85ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (41μs)
  • afterDispatch (34.2KB) (3.27ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (1.78ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (75.74KB) (116ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.32KB) (50.61ms)
  • 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) (23μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.73KB) (4.4ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (25μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (39μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.12ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (64μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (14μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (26μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μ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) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (22μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (22μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (2ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.8ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (60μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (24.48KB) (2.42ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (21μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (12μs)
  • afterRenderRawModule mod_finder () (214.16KB) (5.23ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (140μs)
  • afterRenderRawModule mod_custom () (22.27KB) (1.68ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (104μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.66ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (51μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.73ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (38μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.09KB) (557μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (45μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (176μs)
  • afterRenderRawModule mod_custom () (944B) (142μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (23μs)
  • beforeRenderRawModule mod_custom () (688B) (83μs)
  • afterRenderRawModule mod_custom () (896B) (99μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.71KB) (29μs)
  • afterRender (169.79KB) (5.61ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (75.74KB) (31.85%)
    116.33ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (13.86%)
    50.62ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.32KB) (13.86%)
    50.61ms
    1 x afterRenderComponent com_content (66.73KB) (10.39%)
    37.95ms
    1 x afterInitialise (1.27MB) (9.23%)
    33.71ms
    1 x afterRoute (927.02KB) (3.7%)
    13.50ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.56%)
    13.00ms
    1 x afterRender (169.79KB) (1.54%)
    5.61ms
    1 x afterRenderRawModule mod_finder () (214.16KB) (1.43%)
    5.23ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.73KB) (1.21%)
    4.40ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.13%)
    4.12ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.96KB) (1.05%)
    3.85ms
    1 x afterDispatch (34.2KB) (0.9%)
    3.27ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.77%)
    2.80ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.75%)
    2.75ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (24.48KB) (0.66%)
    2.42ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.55%)
    2.00ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.49%)
    1.78ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.47%)
    1.73ms
    1 x afterRenderRawModule mod_custom () (22.27KB) (0.46%)
    1.68ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.45%)
    1.66ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.34%)
    1.26ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.15%)
    557μs
    1 x afterLoad (456.44KB) (0.11%)
    416μs
    1 x beforeRenderComponent com_content (24.37KB) (0.08%)
    279μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.07%)
    259μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.05%)
    176μs
    1 x afterRenderRawModule mod_custom () (944B) (0.04%)
    142μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.04%)
    140μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.03%)
    104μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    99μs
    1 x Before Access::getAssetRules (id:2495 name:com_content.article.1225) (130.65KB) (0.02%)
    90μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.02%)
    90μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    83μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    64μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.02%)
    60μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    55μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    51μs
    1 x After Access::getAssetRules (id:2495 name:com_content.article.1225) (7.47KB) (0.01%)
    49μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    46μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    45μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    41μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    39μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    38μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    35μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    29μ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_tags_popular (Search) (2.52KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    23μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    23μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    22μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    22μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    22μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    22μ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 beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    18μ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%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    14μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    13μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
45 statements were executed, 9 of which were duplicates, 36 unique236ms1.33MB
  • SELECT @@SESSION.sql_mode;351μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?806μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1160μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.97ms944BParams/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` = 1295μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`108μ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` = :guest1.12ms1.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`1.06ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC129μ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` = 1184μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config169μ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`747μ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`736μ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` = 1173μ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)1.68ms7.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` = 04.96ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.64ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1225'1.94ms48B/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)1.82ms22.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.75ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)3.26ms4.08KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`937μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id LEFT JOIN `has_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC2.43ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id113μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id70μ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.38ms180.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 DESC30.66ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.99ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1385μ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` = 0353μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id91μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id63μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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:04:09') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 00:04:09') AND c2.state = 12.35ms4.02KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.title ASC LIMIT 10112ms195.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:04:09', 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 1048.58ms2.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 10849μs159.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`409μ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` = :id147μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1169μ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)139μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.02ms4.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)163μ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` = 1164μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?107μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.77ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy