Skip to main content

Nutritionally poor diets increase your cancer risk

- but specific nutrients protect you

Nutritionally poor diets increase your cancer riskPeople, who eat nutrient-depleted diets, have an increased risk of contracting cancer, according to a French study that is published in PLoS Medicine. The scientists therefore recommend labeling food to help consumers make healthier choices. In the Nordic countries, we already have the “Keyhole label” on certain healthy food items, but even if you follow the official dietary guidelines, it may be difficult to get enough vitamin D and selenium, both of which are nutrients with several anti-cancer mechanisms.

One in three Danes gets cancer, and the curve has not been broken, on the contrary. Because diet plays such a great role, the British health authorities have introduced a special diet index (FSAm-NPS) that ranks food by its lack of nutrients. The higher the score, the lower their nutritional value. Mélenie Deschasaux and her team of researchers from the French Institute of Health and Medical Research in collaboration with WHO have used this system in their new study, and they see it as a potential tool for helping people make the right food choices, thereby lowering their cancer risk.

Nutritionally poor food increases the risk of most cancers

Mélanie Deschasaux and her colleagues analyzed data concerning food intake and cancer occurrence among 471,495 adults during the period 1992-2014. The data was gathered from a large European population study (EPIC). According to the study, 49,794 cases of cancer (primarily breast, prostate and colon cancer) were detected during that period. The scientists rated the diets of the participants using the special FSAm-NPS dietary index to see what types of food gave the highest risk of cancer.
They found a statistically significant relation between a high score (indicating that the food lacked nutrients) and an increased risk of breast cancer in menopausal women. Also, these foods increased the risk of cancer in the liver, colon, rectum, stomach, and lungs.
However, the study was limited by the fact that people’s food intake was self-reported and therefore not very accurate. Still, Mélanie Deschasaux believes that the study is sufficiently reliable to advocate for a better health policy, one where food items are labeled to show their content (or lack of) of nutrients.

Keyhole-labeling is useful – but not for cancer prevention

Denmark, Norway, and Sweden have introduced the so-called Keyhole label to help guide consumers to healthier food choices. The Keyhole concept, which food manufacturers can sign up for voluntarily, requires that foods meet certain requirements in terms of ingredient health. Only food that contributes to a healthy and balanced diet is eligible for this labeling system. In other words, candy, soft drinks, chips, and similar unhealthy foods are not included.
Unfortunately, cancer also affects those people, who follow the official dietary guidelines and stick with Keyhole-labeled foods. Apparently, it is difficult to get sufficient amounts of vitamin D and selenium from the diet, and these two nutrients have anti-cancer mechanisms.

Lack of vitamin D increases the risk of cancer and early death by 30-40 percent

The summer sun is our primary source of vitamin D, yet vitamin D deficiency has become an increasingly common problem over the past decades due to people spending too much time indoors, overusing sun factor cream, and taking cholesterol-lowering drugs (that block the body’s vitamin D synthesis). Moreover, older people, diabetics, and dark-skinned individuals do not synthesize vitamin D as effectively as others do.
Low blood levels of vitamin D increase the risk of several cancer forms and premature death by up to 30-40 percent, according to a large Danish study that is published in the British Medical Journal.

Blood levels of vitamin D are determining for prevention

On the other hand, having high levels of vitamin D in the blood can lower the risk of several cancer forms, which was shown in a large study of Japanese adults. Over the past decades, numerous studies have revealed that vitamin D plays a role in the prevention of breast cancer, colon cancer, and several other cancer forms. It appears that we need a higher intake of the nutrient than officially recommended in order to obtain a preventative effect on cancer.

Did you know that women who spend a lot of time in the sun and synthesize more vitamin D are only half as likely to develop breast cancer as those who get less sun?

We need more vitamin D than officially recommended

The official recommendation for daily intake of vitamin D is too low, according to many experts who claim that the recommendations should lie in the range of 30-100 micrograms daily. It is easy to synthesize this amount of vitamin D by exposing your skin to direct sunlight on a bright summer day. The amount of vitamin D that we get from our diets is very limited, so it is a good idea to take a supplement during the winter period or in situations where one is unable to get enough of the nutrient from sun exposure. Vitamin D is lipid-soluble, and the best way to take it is in an oil-based formula in capsules.

  • Vitamin D inhibits cancer through the following mechanisms:
  • Controls a number of genetic activities
  • Blocks the formation of new blood vessels in tumors (angiogenesis)
  • Causes diseased cells to self-destruct (apoptosis)
  • Counteracts uncontrolled cell division and metastases
  • Contributes to a well-functioning immune defense and helps the body destroy cancer cells
  • Counteracts local inflammation, which occurs in many cancer forms

Even if you eat healthily, it is difficult to get enough selenium

Selenium supports around 30 different selenium-dependent proteins (selenoproteins) that are important for our energy turnover and also serve as antioxidants by protecting cells against oxidative stress and DNA damage.
Selenium is primarily found in fish, shellfish, organ meat, eggs, dairy products, and Brazil nuts. European crops, however, are generally low in selenium, as there are very limited quantities of the nutrient in the agricultural soil. Research has even demonstrated that it is impossible to get enough selenium by eating fish and shellfish five days per week.

Selenium yeast lower cancer mortality by 50 percent

In 1996, Professor Larry C. Clark, an American cancer researcher, published the result of his groundbreaking NPC study (National Prevention of Cancer), showing that supplementation with organic selenium yeast lowered the risk of several cancer forms. In the group of study participants that got selenium yeast, there were:

  • 58 % fewer cases of colorectal cancer
  • 63% fewer cases of prostate cancer
  • 46% fewer cases of lung cancer
  • A 50% reduction of all-cause cancer mortality

Ever since the study was published (in the Journal of the American Medical Association), other studies have shown that lack of dietary selenium increases the risk of many different cancer forms, and supplementation with selenium yeast has a protective effect.

Selenium also lowers the risk of breast cancer

Large studies have revealed differences in blood levels of selenium in healthy women and breast cancer patients long before the diseases are diagnosed. This knowledge is highly relevant, as cancer often takes many years to develop.

Selenomethionine supplements do not work – and studies are misguiding

The researchers behind the so-called SELECT trial tested supplements of selenium and vitamin E but failed to find a protective effect on cancer. This was partly because they used selenomethionine, which, contrary to selenium yeast, has no documented anti-cancer properties. Moreover, the vitamin E that they used in the study was from a synthetic source. It is therefore misleading to use the SELECT trial as a scientific reference and as leverage for discouraging people from using selenium as part of their cancer prevention strategy. Instead, one should inform consumers that selenomethionine does not appear to have much of an effect and to recommend selenium yeast as a better alternative.

Selenium yeast protects against prostate cancer

A study conducted by scientists at the Technical University of Denmark shows that daily supplementation with 200 micrograms of selenium yeast lowers the risk of prostate cancer. That amount is far higher than the recommended intake level for selenium (55 micrograms in Denmark).

Selenium supplementation is necessary for cancer preveniton

An estimated 20 percent of the Danish population has a dietary selenium intake that is below the reference intake level (RI). However, according to research, even the RI level of 55 micrograms is not sufficient to saturate selenoprotein P, which is an important marker of selenium status in the human body. In order to saturate this selenoprotein properly, one would need to consume 100-125 micrograms of selenium every day, or twice as much as the current recommendations.
When buying selenium preparations, make sure to choose selenium yeast with a blend of different organic selenium species. This is how you get the same variety of selenium compounds as you get from eating a balanced diet with many different selenium sources,

Effective cancer prevention requires an adequate intake of selenium to saturate the different selenoproteins, which have the following functions:

  • They are powerful antioxidants that protect cells against free radicals
  • They repair DNA damage
  • They neutralize mercury and other environmental toxinx
  • They prevent the formation of new blood vessels in tumors (angiogenesis)
  • They cause diseased cells to self-destruct (apoptosis)
  • They contribute to a well-functioning immune system
  • They counteract inflammation

References

Mélanie Deschasaux et al. Nutritional quality of foods as represented by the FSAm-NPS nutrient profiling system underlying the Nutri-Score label and cancer risk in Europe: Results from the EPIC prospective cohort study. PLOS Medicine 2018

Sanjeev Budhathoki et al. Plasma 25-hydroxyvitamin D concentration and subsequent risk of total and site specific cancers in Japanese population: large case-cohort study within Japan Public Health Center-based Prospective Study cohort. BMJ, 2018

Science News. Higher Vitamin D levels may be linked to lower risk of cancer. ScienceDaily March 2018

Shoaib Afzal et al. Genetically low vitamin D concentration and increased mortality: Mendelian randomization analysis in three large cohorts. BMJ 2015

New Links between selenium and cancer prevention. HRB. December 2017

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.

Schrauzer GN, et al. Selenium in the blood of Japanese and American women with and without breast cancer and fibrocystic disease. Jpn J Cancer res. 1985

http://seleniumfacts.com/selenium-antioxidants-combination-cancer/

Lutz Shomburg. Dietary Selenium and Human Health. Nutrients 2017

https://www.cancer.dk/hjaelp-viden/fakta-om-kraeft/kraeft-i-tal/nogletal/

  • Created on .
8.819MBMemory Usage563msRequest 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" => 1738540169 "last" => 1738540169...
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-GB" ]
  • afterLoad (456.34KB) (406μs)
  • afterInitialise (1.27MB) (38.39ms)
  • afterRoute (897.2KB) (13.49ms)
  • beforeRenderComponent com_content (22.58KB) (246μs)
  • Before Access::preloadComponents (all components) (33.23KB) (264μs)
  • After Access::preloadComponents (all components) (97.34KB) (2.65ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (16.09ms)
  • Before Access::getAssetRules (id:3726 name:com_content.article.1841) (130.65KB) (102μs)
  • After Access::getAssetRules (id:3726 name:com_content.article.1841) (7.38KB) (54μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.37MB) (72.05ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (1.3ms)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (9μs)
  • afterRenderModule mod_custom (Search for more information...) (4.2KB) (104μs)
  • afterRenderComponent com_content (69.45KB) (32.53ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.72KB) (7.35ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (34μs)
  • afterDispatch (24.74KB) (1.66ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (2.77ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (74.84KB) (162ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (40μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (61μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (15μs)
  • afterRenderRawModule mod_tags_popular (Search) (46.15KB) (170ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (37μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (62μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (12μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (5.73ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (92μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (16μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (25μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (23μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (11μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (20μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (10μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (20μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (472μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (4.07ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (7μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (1.1ms)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (27μs)
  • afterRenderRawModule mod_languages (Sprogskift) (19.81KB) (5.17ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (9μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (38μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (16μs)
  • afterRenderRawModule mod_finder () (128.59KB) (3.24ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (3.29KB) (43μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (163μs)
  • afterRenderRawModule mod_custom () (21.95KB) (3.21ms)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (1.23KB) (86μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (140μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.86ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (8μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (70μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (24μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (810μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (1.06ms)
  • beforeRenderRawModule mod_finder () (2.3KB) (22μs)
  • afterRenderRawModule mod_finder () (6.29KB) (973μs)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (3.73KB) (59μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (245μs)
  • afterRenderRawModule mod_custom () (944B) (182μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (31μs)
  • beforeRenderRawModule mod_custom () (688B) (84μs)
  • afterRenderRawModule mod_custom () (896B) (91μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (182.69KB) (9.63ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (46.15KB) (30.19%)
    169.99ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (74.84KB) (28.71%)
    161.67ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.37MB) (12.8%)
    72.05ms
    1 x afterInitialise (1.27MB) (6.82%)
    38.39ms
    1 x afterRenderComponent com_content (69.45KB) (5.78%)
    32.53ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (2.86%)
    16.09ms
    1 x afterRoute (897.2KB) (2.4%)
    13.49ms
    1 x afterRender (182.69KB) (1.71%)
    9.63ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.72KB) (1.3%)
    7.35ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.02%)
    5.73ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (19.81KB) (0.92%)
    5.17ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.72%)
    4.07ms
    1 x afterRenderRawModule mod_finder () (128.59KB) (0.58%)
    3.24ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.57%)
    3.21ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.49%)
    2.77ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.47%)
    2.65ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.33%)
    1.86ms
    1 x afterDispatch (24.74KB) (0.29%)
    1.66ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.23%)
    1.30ms
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.19%)
    1.10ms
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.19%)
    1.06ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.17%)
    973μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.14%)
    810μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.08%)
    472μs
    1 x afterLoad (456.34KB) (0.07%)
    406μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.05%)
    264μs
    1 x beforeRenderComponent com_content (22.58KB) (0.04%)
    246μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    245μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    182μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    163μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.02%)
    140μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.2KB) (0.02%)
    104μs
    1 x Before Access::getAssetRules (id:3726 name:com_content.article.1841) (130.65KB) (0.02%)
    102μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    92μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    91μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    86μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    84μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    70μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    62μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    61μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.01%)
    59μs
    1 x After Access::getAssetRules (id:3726 name:com_content.article.1841) (7.38KB) (0.01%)
    54μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    43μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    40μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    38μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.01%)
    37μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    34μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    27μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    25μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    24μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    23μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    20μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    16μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    16μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    16μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    15μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    15μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    15μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    11μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
44 statements were executed, 9 of which were duplicates, 35 unique418ms1.16MB
  • SELECT @@SESSION.sql_mode;1.04ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?577μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1124μ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)3.77ms944BParams/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` = 1192μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`2.07ms656B/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` = :guest205μ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`472μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC136μ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` = 1600μ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`1.59ms165.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.05ms3.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` = 1194μ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)550μ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` = 07.95ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.68ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1841'2.79ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)1.59ms46.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.23ms3.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)10.34ms4.19KBParams/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`337μ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 ASC375μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id4.96ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id776μ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`9.27ms180.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 DESC24.87ms161.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`326μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.62ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0357μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id152μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id131μ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-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-02 23:49:29') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-02 23:49:29') AND c2.state = 1424μs3.98KBParams/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 RAND() ASC LIMIT 10154ms151.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`1.21ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `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 15166ms2.75KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • 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` = :id795μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1248μ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)214μ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 ASC443μ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)242μ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` = 1258μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?5.16ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?6.18ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy