Skip to main content

Magnesium is vital for the immune defense and for fighting cancer

Magnesium is vital for the immune defense and for fighting cancerLevels of magnesium in the blood are determining for the immune system’s ability to attack pathogens and cancer cells, according to a new study from the University of Basel and the University Hospital Basel. The scientists have discovered that the T cells of the immune system need magnesium in order to carry out proper attacks. According to the scientists, these results are extremely important because magnesium has a potential role in new immunotherapies targeted at cancer patients. It is generally important to get plenty of magnesium because this nutrient is vital for the body’s calcium distribution and for supporting hundreds of enzyme processes.

The immune system is designed to carry out swift and effective attacks o pathogens and toxins. Also, it is designed to attack abnormal cells and cancer cells that pose a threat to our health. Here, the so-called T cells play the most important role. Cancer is a blanket term for different diseases characterized by uncontrollable cell growth, in some cases growths that are malignant. Although cancer therapies have improved the rate of cancer continues to rise and it comes with a huge human and socioeconomic price tag. Chemotherapy and radiation therapy is often associated with side effects so science is looking for other therapies that can fight cancer naturally.
According to the Swizz scientists, lack of magnesium is often linked to a host of diseases, including infections and cancer. Earlier studies of mice with cancer have already shown that cancer tumors grow faster if the mice are fed a magnesium-depleted diet. Also, they are more susceptible towards viral infections such as influenza. So far, however, the number of studies of magnesium’s specific impact on the immune system is very limited.

The T cells of the immune system

  • The T cells mainly target virus-infected cells, abnormal cells, and cancer cells
  • Helper T cells (CD4+) are like “officers” that give instructions
  • Helper T cells (CD8+) carry out chemical attacks
  • Regulatory T cells harness the killer T cells once the mission is completed

The study shows that magnesium primes T cells for their attack

The science team, headed by Professor Christoph Hess, found that the killer T cells (CD8+) are only able to attack and eliminate infected cells and abnormal cells such as cancer cells if there is enough magnesium present. Magnesium is essential for the functioning of a certain protein (LFA-1) on the surface of killer T cells. The scientists observed that killer T cells attach to infected cells and abnormal cells via the LFA-1 protein on the surface. However, the killer T cells are not activated before magnesium also attaches to the LFA-1 protein, and that is why it is vital that there is enough magnesium in the affected tissue. After magnesium has attached to LFA-1, the killer T cells can carry out “chemical warfare” by using cell toxins such as perforin and granulysin that dissolve the cells or cause them to carry out programmed self-destruction – also called apoptosis.

Magnesium’s potential in cancer therapy

Because of magnesium’s essential role in helping T cells function properly, the scientists assume that magnesium may have a potential in future immunotherapies targeted at cancer patients. These therapies can mobilize the immune defense and the killer T cells in particular. Experimental animal studies have already demonstrated that increasing the magnesium concentration in tumor tissue strengthens the killer T cells’ attacks on cancer cells.
The researchers want to carry out new clinical studies where they increase magnesium levels in tumors to see if this confirms their previous observations. They have also looked at data from earlier studies that show how immunotherapies used on cancer patients became less effective if there was too little magnesium in the blood.
Based on the existing data, the scientists still do not know if consuming larger quantities of magnesium lowers the risk of cancer but they plan to carry out more studies to learn about magnesium’s role in the immune system. The new study is published in the science journal Cell.

Facts about magnesium

  • Magnesium is one of the minerals we need in the largest quantities
  • Around half the body’s magnesium reserves are stored in bone tissue. The rest is found in muscles and other soft tissues.
  • Magnesium is important for the body’s calcium distribution. This keeps bones healthy and prevents calcium ions from flooding cells in the soft tissues.
  • If cells in soft tissues are flooded by calcium, they become stressed
  • Magnesium supports well over 300 different enzyme processes
  • Magnesium helps activate vitamin D
  • Magnesium activates killer T cells

Magnesium requirements and supplementation

Before the industrialization, the average daily intake of magnesium was around 500 mg and was obtained by eating coarse greens. Today, most people in Western countries get less than the recommended daily intake of magnesium (in Denmark, it is 375 mg/day).
When supplementing with magnesium, preferably choose sources like magnesium carbonate, magnesium acetate, or magnesium citrate. They are readily absorbable magnesium compounds and have the right quality. Magnesium oxide that is found in some supplements and in Magnesia (against constipation) has very poor absorption. It primarily has a local effect in the intestine.

References

Jonas Lötscher et al. Magnesium sensing via LFA-1 regulates CD8+T cell effector function. Cell, 19 January 2022

University of Basel. Magnesium is essential for the Immune System - Important in the Fight against Cancer. Scitecdaily.com January 20, 2022

Megan Ware. Why do we need magnesium? Medical News Today. 2020

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

  • Created on .
8.854MBMemory Usage438msRequest 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" => 1738539604 "last" => 1738539604...
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.53KB) (370μs)
  • afterInitialise (1.27MB) (32.55ms)
  • afterRoute (927.02KB) (16.92ms)
  • beforeRenderComponent com_content (22.94KB) (215μs)
  • Before Access::preloadComponents (all components) (35.84KB) (233μs)
  • After Access::preloadComponents (all components) (97.34KB) (5.04ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (13μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (14.18ms)
  • Before Access::getAssetRules (id:6923 name:com_content.article.3425) (130.65KB) (312μs)
  • After Access::getAssetRules (id:6923 name:com_content.article.3425) (7.38KB) (45μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (61.18ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (2.74ms)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (92μs)
  • afterRenderComponent com_content (58.64KB) (46.45ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.11KB) (6.96ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (26μs)
  • afterDispatch (17.68KB) (2.23ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (413μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (75.48KB) (114ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (2.15ms)
  • afterRenderRawModule mod_tags_popular (Search) (19.63KB) (68.84ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (38μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (52μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (20μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.65KB) (12.6ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (22μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (35μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (10μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (20μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.49ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (62μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (24μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (10μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (20μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (14μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (19μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (9μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (18μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (8μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (18μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (375μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (10.32ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (59μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (5.81ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (2μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (15μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (7μs)
  • afterRenderRawModule mod_finder () (214.53KB) (4.16ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (30μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (126μs)
  • afterRenderRawModule mod_custom () (21.95KB) (6.31ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (1.23KB) (51μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (94μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (582μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (3μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (37μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (15μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (5.73ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (32μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (9μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.2ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.23KB) (44μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (161μs)
  • afterRenderRawModule mod_custom () (944B) (119μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (22μs)
  • beforeRenderRawModule mod_custom () (688B) (73μs)
  • afterRenderRawModule mod_custom () (896B) (81μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (28μs)
  • afterRender (169.91KB) (10.41ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (75.48KB) (25.91%)
    113.58ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.63KB) (15.7%)
    68.84ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (13.96%)
    61.18ms
    1 x afterRenderComponent com_content (58.64KB) (10.6%)
    46.45ms
    1 x afterInitialise (1.27MB) (7.42%)
    32.55ms
    1 x afterRoute (927.02KB) (3.86%)
    16.92ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.24%)
    14.18ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.65KB) (2.88%)
    12.60ms
    1 x afterRender (169.91KB) (2.37%)
    10.41ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.35%)
    10.32ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.11KB) (1.59%)
    6.96ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (1.44%)
    6.31ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (1.32%)
    5.81ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.31%)
    5.73ms
    1 x After Access::preloadComponents (all components) (97.34KB) (1.15%)
    5.04ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.02%)
    4.49ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (0.95%)
    4.16ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.63%)
    2.74ms
    1 x afterDispatch (17.68KB) (0.51%)
    2.23ms
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.49%)
    2.15ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.27%)
    1.20ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.13%)
    582μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.09%)
    413μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.09%)
    375μs
    1 x afterLoad (456.53KB) (0.08%)
    370μs
    1 x Before Access::getAssetRules (id:6923 name:com_content.article.3425) (130.65KB) (0.07%)
    312μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.05%)
    233μs
    1 x beforeRenderComponent com_content (22.94KB) (0.05%)
    215μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    161μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    126μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    119μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    94μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.02%)
    92μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    81μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    73μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    62μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    59μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    52μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    51μs
    1 x After Access::getAssetRules (id:6923 name:com_content.article.3425) (7.38KB) (0.01%)
    45μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    44μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    38μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    37μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    35μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    32μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    30μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    26μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    24μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    22μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    20μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    20μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    19μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    17μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    15μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    14μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    13μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    13μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    8μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    8μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    7μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    2μs
45 statements were executed, 9 of which were duplicates, 36 unique254ms1.33MB
  • SELECT @@SESSION.sql_mode;78μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?130μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1122μ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.94ms944BParams/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` = 1242μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`235μ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` = :guest233μ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`1.53ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC100μs2.33KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `has_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 11.04ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config142μ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`2.82ms165.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`368μ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` = 1629μ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)296μ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` = 05.02ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.9ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3425'728μs48B/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)460μ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`753μ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)5.7ms4.09KBParams/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`304μ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 ASC271μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.35ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id90μ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`5.62ms180.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 DESC33.16ms161.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`667μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1455μ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` = 0607μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id257μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id95μ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-02 23:40:04') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-02 23:40:04') AND c2.state = 1842μ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 10109ms195.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-02 23:40:04', 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 1067.19ms2.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 102.55ms159.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`3.29ms3.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` = :id132μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1168μ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)122μ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 ASC229μ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)134μ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` = 197μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?78μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.41ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy