Skip to main content

Selenium and calcium protect against colorectal cancer

Selenium and calcium protect against colorectal cancerColorectal cancer is one of the most common cancer types. Although the diet is of huge importance, the understanding of minerals and their interactions and preventative effect is limited. Earlier studies have shown that calcium and selenium have protective roles. It also looks as if having more selenium in the blood can improve the effect of calcium. This was demonstrated in a new Polish study that is published in BMC Nutrition. The scientists point out that there is widespread selenium deficiency in Europe and that supplementation may be needed.

Colorectal cancer is a collective name for cancer in the colon, rectum, and appendix. Although health authorities have introduced different types of screening procedures and various treatments, colorectal cancer is at the top of the list of cancer-related mortality. It is believed that diet and lifestyle account for around 70 percent of the cases. The risk is increased by consuming processed meats such as bacon, sausages, and cold cuts that have been cured, smoked, or had preservatives such as nitrite added to them for improved taste or shelf life.
Lack of exercise, overweight, excessive alcohol consumption, and ageing are some of the other factors that increase your risk. Lack of nutrients also plays a role, and science is particularly focused on selenium and calcium.

  • Every year, 5,000 Danes are diagnosed with colorectal cancer
  • Most patients are older than 50 years of age, and the risk of dying of the disease goes up with increasing age
  • Diet and lifestyle play a crucial role

Selenium’s anti-cancer mechanisms

Selenium is a trace element that supports a host of different selenoproteins and their essential functions. We get selenium from offal, meat, eggs, and seafood. The selenium content in wheat and other crops is determined by the selenium content in the soil. In Europe and many other parts of the world, the farmland is selenium-depleted and that is why selenium deficiency is so widespread. Scientists are aware of this problem and it has their attention, as selenium has the following anti-cancer mechanisms:

  • Affects gene activities, including Bcl-2
  • Bcl-2 controls programmed cell death (apoptosis), a mechanism that helps abnormal and worn-out cells self-destruct
  • Supports powerful antioxidants such as GPX that neutralizes potentially harmful free radicals
  • Boosts the immune defense
  • Dials down interleukin-2 and harmful inflammatory processes
  • Helps to activate thyroid hormones
  • Neutralizes the harmful effect of environmental toxins such as mercury

Several studies and meta-analyses have shown that selenium protects against colorectal cancer. Back in 1996, the American cancer researcher, Larry C. Clark, documented that daily supplementation with 200 micrograms of selenium yeast could lower the risk of colorectal by nearly 60 percent.
In 2017, scientists at the University College Dublin conducted a large selenium study where they looked at data from the so-called EPIC study. In this study, around half a million people had given blood samples and provided information about their diet and lifestyle. The scientists found that having more selenium in the blood was related to a significantly lower risk of developing colorectal cancer. The study suggests that a higher selenium intake may be relevant for most Europeans, simply because the average European selenium intake is below the optimal level.
There are conflicting results, however, as some studies have failed to demonstrate a statistically significant link between selenium intake and the risk of getting colorectal cancer. According to the authors of the new Polish study, this may be down to different dietary and lifestyle factors and different analytical methods.
The Polish scientists therefore wanted to look closer at calcium intake to see if this could possibly influence the effect of selenium. Apparently, dietary calcium is involved in the protection of the intestinal epithelium that serves as a gut barrier with a number of physiological functions. More precisely, calcium protects the epithelial cells through its effect on the synthesis of calcium-phosphate bile. Because selenium has other anti-cancer mechanisms that are related to the antioxidant defense, immune defense, and apoptosis, the scientists wanted to study them closer in relation to their ability to prevent colorectal cancer.

Optimal selenium levels offer the highest level of protection

The scientists looked at the diets of 683 patients diagnosed with colorectal cancer and 759 hospitalized patients with other diseases. They found an inverse relation between selenium intake and colorectal cancer risk. The cancer risk decreased by 30 percent in patients that got 60-80 micrograms of selenium every day. In patients who consumed more than 80 micrograms daily, the cancer risk decreased by as much as 60 percent.
The scientists also observed that low calcium intake impaired the effect of selenium and its anti-cancer effect. On the other hand, a higher calcium intake did not seem to have much effect on selenium and its ability to prevent cancer.
The researchers therefore suggest increasing the intake of selenium and calcium among people who don’t get enough of these two minerals.
This study supports earlier studies, and it appears that selenium’s protective effect on colorectal cancer peaks at intake doses of around 81-145 micrograms daily. There is no evidence to suggest an increased level of protection if you consume more than that. The European Food Safety Authority (EFSA) has established a safe upper intake level for selenium at 300 micrograms daily. The Polish study is published in BMC Nutrition.

How to compensate for low selenium intake and poor supplement quality

The official selenium recommendation in Denmark is around 55 micrograms daily. According to the new study, however, this is not enough to provide optimal protection against colorectal cancer. In fact, if you double or triple your selenium intake it may help reduce the risk of colorectal cancer and other cancer forms.
The best source of selenium for supplementation is selenium yeast that contains a variety of different organic selenium types, just like you get by eating a balanced diet with many different selenium sources. Interestingly, the so-called SELECT study where the study participants only got one type of selenium (selenomethionine) failed to demonstrate a protective effect on cancer. The selenium used for research is therefore of vital importance.

References

Malgorzata Augustyniak & Aleksander Galas. Calcium intake may explain the reduction of colorectal cancer odds by dietary selenium – a case control-study in Poland. BMC Nutrition. 2022

Clark LC et al: Effects of Selenium Supplementation for Cancer Prevention in Patients with Carcinoma of the Skin. JAMA: 1997.

Klein EA et al. Vitamin E and the risk of prostate cancer: The Selenium and Vitamin E Cancer Prevention Trial (SELECT). JAMA 2011.

Lutz Shomburg. Dietary Selenium and Human Health. Nutrients 2017

  • Created on .
8.84MBMemory Usage437msRequest 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" => 1739350838 "last" => 1739350838...
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.41KB) (3.79ms)
  • afterInitialise (1.27MB) (30.05ms)
  • afterRoute (927.02KB) (16.68ms)
  • beforeRenderComponent com_content (23.21KB) (313μs)
  • Before Access::preloadComponents (all components) (35.84KB) (334μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.31ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (13μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (22.5ms)
  • Before Access::getAssetRules (id:7201 name:com_content.article.3565) (130.65KB) (94μs)
  • After Access::getAssetRules (id:7201 name:com_content.article.3565) (7.38KB) (42μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (58.11ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (1.43ms)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (4.2KB) (101μs)
  • afterRenderComponent com_content (57.42KB) (40.36ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.03KB) (5.44ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (31μs)
  • afterDispatch (17.7KB) (656μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (545μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (75.48KB) (142ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.7KB) (62.29ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (41μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (69μ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.61KB) (7.61ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (27μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (40μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (22μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (34μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (9.27ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (63μ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) (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) (18μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (11μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (19μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (2.6ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.54ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (58μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (1.68ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (21μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.53KB) (7.23ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (138μs)
  • afterRenderRawModule mod_custom () (21.95KB) (1.88ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (49μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (105μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (647μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (41μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.03ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (11μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.65ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (44μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (181μs)
  • afterRenderRawModule mod_custom () (944B) (135μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (26μs)
  • beforeRenderRawModule mod_custom () (688B) (1.36ms)
  • afterRenderRawModule mod_custom () (896B) (125μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (27μs)
  • afterRender (161.94KB) (5.45ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (75.48KB) (32.63%)
    142.46ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.7KB) (14.27%)
    62.29ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (13.31%)
    58.11ms
    1 x afterRenderComponent com_content (57.42KB) (9.24%)
    40.36ms
    1 x afterInitialise (1.27MB) (6.88%)
    30.05ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (5.15%)
    22.50ms
    1 x afterRoute (927.02KB) (3.82%)
    16.68ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (2.12%)
    9.27ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.61KB) (1.74%)
    7.61ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.66%)
    7.23ms
    1 x afterRender (161.94KB) (1.25%)
    5.45ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.03KB) (1.25%)
    5.44ms
    1 x afterLoad (456.41KB) (0.87%)
    3.79ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.6%)
    2.60ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.58%)
    2.54ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.46%)
    2.03ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.43%)
    1.88ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (0.38%)
    1.68ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.38%)
    1.65ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.33%)
    1.43ms
    1 x beforeRenderRawModule mod_custom () (688B) (0.31%)
    1.36ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.3%)
    1.31ms
    1 x afterDispatch (17.7KB) (0.15%)
    656μs
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.15%)
    647μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.12%)
    545μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.08%)
    334μs
    1 x beforeRenderComponent com_content (23.21KB) (0.07%)
    313μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    181μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    138μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    135μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    125μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    105μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.2KB) (0.02%)
    101μs
    1 x Before Access::getAssetRules (id:7201 name:com_content.article.3565) (130.65KB) (0.02%)
    94μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.02%)
    69μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    63μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    58μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    49μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    44μs
    1 x After Access::getAssetRules (id:7201 name:com_content.article.3565) (7.38KB) (0.01%)
    42μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    41μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    41μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    40μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    34μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    34μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    27μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    26μ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 (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0.01%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    21μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    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%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    14μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    13μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    11μ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_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique281ms1.33MB
  • SELECT @@SESSION.sql_mode;215μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?101μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1287μ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.7ms944BParams/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` = 1189μ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` = :guest218μ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`560μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC185μ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` = 1126μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config192μ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.35ms165.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`1.2ms3.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` = 11.36ms848B/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)570μ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` = 09.87ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.37ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '3565'905μ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)2.05ms22.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.31ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)6.94ms4.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`772μ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 ASC329μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.93ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id108μ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`3.96ms180.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 DESC31.26ms161.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.26ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1464μ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` = 0348μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id710μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id79μ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-12 09:00:38') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-12 09:00:38') AND c2.state = 1281μ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 10139ms195.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-12 09:00:38', 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 1059.83ms2.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.76ms159.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`427μ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` = :id155μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1164μ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)1.45ms584B/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 ASC332μ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)1.22ms584B/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` = 1123μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?103μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.44ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy