Skip to main content

Magnesium in our diet is important for healthy knees and for preventing osteoarthritis

Magnesium in our diet is important for healthy knees and for preventing osteoarthritisIncreased intake of magnesium from dietary sources or from supplements is associated with significantly healthier knees, including improvements like thicker cartilage. But many people lack magnesium and that most likely helps explain the widespread problems with knee osteoarthritis, according to a study that is published in the journal Nutrients. If you already have osteoarthritis, taking pharmaceutical-grade glucosamine may help.

We all want to stay physically active and full of vitality for as long as possible here in life, but the ageing process takes its toll, and osteoarthritis is one of the most commonly occurring disabilities among older people. Osteoarthritis has many causes, and overweight, gender, and chronic inflammation play a key role in the development of the disease. On a global scale, an estimated 10 percent of men and 20 percent of women from 60 years and older are believed to be affected by osteoarthritis. It is therefore essential to learn more about any mechanisms that can prevent or delay the onset of this disabling condition.

Magnesium deficiencies – a widespread and overlooked problem

A number of different minerals such as calcium, magnesium, sodium, potassium, selenium, zinc, and copper regulate cartilage function. However, according to the scientists behind the new study, lack of magnesium is an overlooked problem, especially when it comes to knee osteoarthritis.
An estimated 25% of the American population gets less dietary magnesium than expected, which is most likely a result of poor eating habits and too many processed foods.

  • Osteoarthritis causes a gradual breakdown of joint cartilage
  • Many people have early stages of osteoarthritis without pain
  • Bony spurs/growths (protrusions) may occur
  • Ligaments and joint capsules thicken, while muscles and tendons become weaker
  • The increased pressure on bones combined with inflammation of the mucosa cause pain

Magnesium deficiency and inflammation cause may chronic diseases

Several epidemiological studies suggest a link between magnesium deficiency and various diseases such as atherosclerosis, elevated blood pressure, osteoporosis, diabetes, and cancer of the breast and colon. Magnesium deficiency is believed to cause chronic inflammation that plays a key role in all of these conditions. Moreover, science believes that there is an inverse relation between magnesium intake and knee osteoarthritis, but more studies are needed before making conclusions.

Magnesium helps prevent knee osteoarthritis

The new study included 783 participants, 60 percent of which were women. The average age is 62.3 years. All study participants had been diagnosed with knee osteoarthritis. Dietary magnesium intake was assessed by means of food questionnaires. Magnesium’s impact on the knee osteoarthritis was determined by increasing the participants’ intake of magnesium by 100 mg daily, either through dietary intervention or the use of supplements. In the course of the study, the researchers studied MRI (magnesium resonance imaging) scans of the participants’ knee joints, as this method provides a more detailed picture of the structures of the different tissues, including the cartilage, the meniscus, the ligaments, the joint capsules, and fluid retentions. That way, the scientists could see that increased magnesium intake contributed to a significant increase in average cartilage thickness and cartilage volume in the different parts of the knee cartilage. This was even the case after adjusting for confounding factors such as age, BMI, physical activity level, and smoking, all of which are likely to affect the result.
The scientists therefore concluded that increased intake of magnesium from dietary sources or from supplements can help prevent and also improve knee osteoarthritis.

How magnesium prevents and helps osteoarthritis

The scientists behind the study describe the following mechanisms of action:

  • Magnesium helps counteract low-grade inflammation, which plays a key role in the development of osteoarthritis and pain associated with the condition
  • Magnesium counteracts oxidative stress and cellular damage caused by free radicals (reactive oxygen species or ROS) that are produced by the white blood cells (phagocytes)
  • Magnesium is required for the activation and utilization of vitamin D, which is important for bones and has anti-inflammatory properties
  • Magnesium sources, official recommendations, and increased need for the nutrient
  • Magnesium is mainly found in whole grain, almonds, nuts, seeds, beans and other vegetables. The majority of people in Western countries get less magnesium than the officially recommended intake level. This is primarily a result of nutrient-depleted soil, food refinement, and poor eating habits. Stress, stimulants, medicine, and the ageing process also increase your need for magnesium.

Important: Magnesium must be in the proper balance with calcium

Magnesium possesses a ”doorman” function in cell membranes by controlling the calcium flow. It makes sure to channel the major part of calcium into the cells in bones and teeth at the same time as limiting the calcium concentration inside cells of soft tissues like muscles. It is therefor vital to ingest magnesium and calcium in the proper balance. If we consume too much calcium from dairy products or supplements or become deficient in magnesium, there is a risk that the cells in our soft tissues absorb too much calcium (in the absence of magnesium to control the flow into the cells), causing stress and inflammation inside the cells.

Magnesium supplements, quality, and absorption

There are many different magnesium supplements on the market, and it is always a good idea to study the label and check the quality of the product before making your purchase. Some supplements contain a blend of organic and inorganic magnesium sources that give better utilization of the nutrient. Still, some magnesium supplements have better absorption than others. A simple yet rather convenient way of testing your magnesium supplement is by dropping a tablet in a glass of water to see how fast it dissolves. The faster it dissolves, the more certain you can be that its magnesium content is effectively absorbed in the small intestine. If you suffer from osteoarthritis, you may want to combine your magnesium with glucosamine sulphate to improve the effect.

Glucosamine sulphate as first line therapy for osteoarthritis

Glucosamine consists of an amino acid and glucose. Glucosamine sulphate is glucosamine where sulphate (sulfur) has been added. Glucosamine sulphate is a building block in larger sugar molecules such as hyalurone, chondroitin sulfate, and keratan sulfate, all of which are important molecules in articulate cartilage. The body’s cells are normally able to produce glucosamine, but increased age combined with a lack of key nutrients may impair this ability and speed up the progression of osteoarthritis.
According to a report issued by ESCEO (European Society for Clinical and Economic Aspects of Osteoarthritis), a financially independent group of experts, glucosamine sulfate should be first line therapy for osteoarthritis. Traditionally used painkillers and NSAID drugs to not stimulate cartilage synthesis and are also associated with serious side effects and even mortality. The scientists have also observed that glucosamine sulfate inhibits interleukin-1, which causes inflammation and joint damage. It is essential always to use pharmaceutical-grade glucosamine sulfate and not illegal supplements that are typically sold from web shops without documentation for their safety and effect.

  • Articulate cartilage is made of very special material.
  • Cartilage cells get their nutrients and get rid of toxic waste by means of passive transport (seepage and leakage).
  • It is therefore important to be physically active on a daily basis to stimulate the cartilage tissue and help nutrients such as magnesium and glucosamine sulfate into the cartilage cells in joints.

References

Nicola Veronese et al. The association between Dietary Magnesium Intake and Magnetic Resonance Parameters for Knee Osteoarthritis. Nutrients 2019

Gerry K. Schwalfenberg and Stephen J. Genuis. The Importance of Magnesium in Clinical Healthcare. Scientifica (Carro) 2017

Nelson AE et al.: A systematic review of recommendations and guidelines for the management of osteoarthritis: The Chronic Osteoarthritis Management Initiative of the U.S Bone and Joint initiative. PubMed 2014

Keld Østergaard. Glukosaminsulfat – den nye slidgigtmedicin. Medi-Com, 2003

  • Created on .
8.86MBMemory Usage148msRequest 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" => 1738590255 "last" => 1738590255...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-US" ]
  • afterLoad (456.63KB) (1.77ms)
  • afterInitialise (1.27MB) (18.47ms)
  • afterRoute (927.02KB) (4.97ms)
  • beforeRenderComponent com_content (24.37KB) (298μs)
  • Before Access::preloadComponents (all components) (35.84KB) (270μs)
  • After Access::preloadComponents (all components) (97.34KB) (594μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (13μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (5.08ms)
  • Before Access::getAssetRules (id:4725 name:com_content.article.2330) (130.65KB) (91μs)
  • After Access::getAssetRules (id:4725 name:com_content.article.2330) (7.38KB) (47μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (17.49ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (197μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (77μs)
  • afterRenderComponent com_content (66.79KB) (12.02ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.18KB) (1.87ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (28μs)
  • afterDispatch (17.67KB) (668μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (454μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (39.76ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (28μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.3KB) (25.58ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (23μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (45μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (22μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.75KB) (2.39ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (23μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (38μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (2.05ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (58μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (14μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (27μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (14μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (27μ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) (20μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (400μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.39ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (55μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (1.42ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (10μs)
  • afterRenderRawModule mod_finder () (214.53KB) (2.47ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (136μs)
  • afterRenderRawModule mod_custom () (22.3KB) (795μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (71μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (104μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (632μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (42μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (666μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (30μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (9μs)
  • afterRenderRawModule mod_finder () (6.09KB) (528μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (45μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (183μs)
  • afterRenderRawModule mod_custom () (944B) (127μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (26μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (93μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (42μs)
  • afterRender (170.08KB) (2.68ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (26.88%)
    39.76ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.3KB) (17.29%)
    25.58ms
    1 x afterInitialise (1.27MB) (12.48%)
    18.47ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (11.82%)
    17.49ms
    1 x afterRenderComponent com_content (66.79KB) (8.12%)
    12.02ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.43%)
    5.08ms
    1 x afterRoute (927.02KB) (3.36%)
    4.97ms
    1 x afterRender (170.08KB) (1.81%)
    2.68ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.67%)
    2.47ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.75KB) (1.61%)
    2.39ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.39%)
    2.05ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.18KB) (1.27%)
    1.87ms
    1 x afterLoad (456.63KB) (1.2%)
    1.77ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.09KB) (0.96%)
    1.42ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.94%)
    1.39ms
    1 x afterRenderRawModule mod_custom () (22.3KB) (0.54%)
    795μs
    1 x afterDispatch (17.67KB) (0.45%)
    668μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.45%)
    666μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.43%)
    632μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.4%)
    594μs
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.36%)
    528μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.31%)
    454μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.27%)
    400μs
    1 x beforeRenderComponent com_content (24.37KB) (0.2%)
    298μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.18%)
    270μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.13%)
    197μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.12%)
    183μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.09%)
    136μs
    1 x afterRenderRawModule mod_custom () (944B) (0.09%)
    127μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.07%)
    104μs
    1 x afterRenderRawModule mod_custom () (896B) (0.06%)
    93μs
    1 x Before Access::getAssetRules (id:4725 name:com_content.article.2330) (130.65KB) (0.06%)
    91μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.05%)
    80μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.05%)
    77μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.05%)
    71μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.04%)
    58μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.04%)
    55μs
    1 x After Access::getAssetRules (id:4725 name:com_content.article.2330) (7.38KB) (0.03%)
    47μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.03%)
    45μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.03%)
    45μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.03%)
    42μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.03%)
    42μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.03%)
    38μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.02%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.02%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.02%)
    28μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.02%)
    27μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.02%)
    27μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.02%)
    23μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.02%)
    23μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    22μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    20μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    20μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0.01%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    16μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0.01%)
    14μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    13μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0.01%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.01%)
    9μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0.01%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique90.14ms1.33MB
  • SELECT @@SESSION.sql_mode;177μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?404μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1254μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.02ms944BParams/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` = 1829μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`261μ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` = :guest528μ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`537μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC138μ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` = 1151μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config180μ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`751μ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`231μ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` = 1166μ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)360μ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` = 02.49ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`591μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2330'1.09ms48B/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)318μs22.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`330μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)1.28ms4.05KBParams/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`291μ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 ASC320μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id100μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id83μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `has_modules` AS `m` LEFT JOIN `has_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`2.16ms180.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 DESC8.9ms161.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`320μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1117μ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` = 0304μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id81μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id67μ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 13:44:15') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 13:44:15') AND c2.state = 1299μs3.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 1037.2ms195.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 13:44:15', 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 1023.74ms2.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 10612μ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`356μ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` = :id122μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1154μ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)129μ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 ASC286μ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)126μ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` = 1109μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?95μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.08ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy