Skip to main content

Vitamin D in large doses lowers your cancer risk

Vitamin D in large doses lowers your cancer riskHaving high blood levels of vitamin D lowers the risk of several cancer forms, according to a new study of Japanese adults. The study is the first to take a closer look at how vitamin D affects an Asian population. Over the past decades, numerous studies have pointed to vitamin D’s role in cancer prevention. Meanwhile, other studies have demonstrated that there is widespread vitamin D deficiency. There is even evidence suggesting that our need for the nutrient exceeds the official recommendations, at least if we want to protect ourselves against cancer.

Around 30 percent of the Danish population gets cancer. Even with nationwide cancer fundraising projects coupled with cancer awareness TV shows, we still have not been able to break the curve. On the contrary. According to the Nordic cancer database, Nordcan, the cancer rate is believed to increase by more than 50 percent within the near future and many of those people who otherwise follow the official diet and exercise guidelines are also at risk.
Although many things can cause cancer, it looks as if vitamin D plays a both significant and somewhat overlooked role.
The sun is the primary source of vitamin D, but many people avoid the sun, and during the winter period, the sun sits too low in the sky to enable vitamin D synthesis in the skin of people living at northern latitudes.
As far back as in the 1940s, researchers noticed a link between UVB exposure from sunrays and cancer mortality. People who lived in the northern hemisphere had an increased risk of several different cancer forms compared with people who lived closer to Equator.

New study of vitamin D’s cancer preventive effect on Asians

According to the Japanese scientists, their new study supports earlier studies in showing that vitamin D has the potential to protect against several cancer forms. Vitamin D is primarily known for its role in calcium uptake, which is important for bones, teeth, and muscles. However, research conducted over the past decades has unveiled that vitamin D is also important for preventing an array of chronic diseases, including cancer. The majority of these studies is carried out on white, Caucasian populations of Europe and the United States, leaving only limited focus on Asian population groups.
Because the synthesis and the activation of vitamin D plus blood levels of the nutrient can vary from one ethnic group to another, the Japanese scientists decided that it was important to investigate whether the vitamin had similar anti-cancer properties in a non-Caucasian population.
An international team of scientists based in Japan therefore looked at whether vitamin D deficiency is linked to cancer in general, and if there is a link to specific cancer forms.

Vitamin D offers 20-50 percent cancer protection

The scientists analyzed data from a large Japanese health study (JPHC), which included 33,736 men and women aged 40-69 years. At baseline, the participants were asked to provide detailed information about their medical history, diet, and lifestyle, and blood samples were taken in order to determine levels of vitamin D in their blood.
The vitamin D levels were higher during summer and autumn and lower during winter and spring, which corresponds with the sun’s location in the sky at different times of the year. The researchers therefore adjusted for these season-related differences, and then they categorized the participants in four groups, ranging from lowest to highest in terms of vitamin D levels in the blood.
The study participants were followed for approximately 16 years. During this period, 3,301 new cases of cancer were diagnosed. After adjusting for several known cancer risk factors such as smoking, alcohol, age, BMI, physical activity level, and diet, the researchers observed that a high vitamin D content in the blood lowered the risk of cancer by around 20 percent in men and women. With liver cancer specifically, the risk reduction was 30-50 percent, with the largest reduction in men.
The scientists did not find a relation between vitamin D levels and lung cancer or prostate cancer. They said that the study has certain limitations in that the number of participants was too small to study the relation between blood levels of vitamin D and more rare cancer forms. Nonetheless, this Japanese study supports several other trials that have shown how vitamin D protects against cancer. The researchers call for future studies in order to pinpoint the optimal levels blood levels of vitamin D for cancer prevention.

Did you know that vitamin D influences most cells in the body and more than 200 genes?

Previous Danish study: Lack of vitamin D causes cancer

Having low levels of vitamin D in the blood increases your risk of cancer and premature death by 30-40 percent, according to a large Danish study that is published in the esteemed British Medical Journal. Lead investigator, Børge Nordestgaard, professor at the University of Copenhagen and chief physician at Herlev Hospital, says that a person with only 30 nmol/l of vitamin D in the blood (20 nmol/l below the official recommendation) has a 40 percent increased risk of dying of cancer.

Did you know that women who are out in the sun a lot are half as likely to develop breast cancer as are those who get less sun?

Colon cancer

A comprehensive European study has shown a relation between low vitamin D levels in the blood (less than 50 nmol/l) and an increased risk of colon cancer. Also, people with higher blood levels of the nutrient had a 40 percent lower risk of colon cancer.

Alarming vitamin D deficiency

DTU Food (The National Food Institute) of Denmark reckons that nine out of 10 Danes get too little vitamin D from the diet. Also, an Australian study has shown that 58 percent of the Australians lack vitamin D, so living in a warm climate is no guarantee of having adequate vitamin D in the blood. You need to expose your skin to the sun.
Vitamin D deficiencies have become increasingly common over the past decades because people are spending more time indoors, avoiding the sun, staying off dietary fats, using sunscreen, and taking cholesterol-lowering drugs for prolonged periods. In addition, older people, diabetics, and people with dark skin may have difficulty with synthesizing vitamin D in their skin.

New threshold values urge wintertime supplementation

The recommended threshold value for vitamin D (measured as 25-hydroxy vitamin D) in the blood is 50 nmol/l. Still, leading experts claim the values should be higher, suggesting 75-100 nmol/l for optimal disease prevention. According to Dr. Jens-Erik Beck Jensen, chief physician at Hvidovre Hospital in Denmark, the diet alone is unable to provide that much vitamin D.

Many scientists recommend going beyond the official vitamin D recommendations

Many experts claim that the actual need for vitamin D is way beyond the official recommendation (reference intake level) and suggest (for adults) anywhere from 30 to 100 micrograms daily. It is easy to synthesize that amount on a hot summer’s day, provided your skin is light. The darker your skin is, the longer it takes for it to produce the vitamin. As mentioned earlier, even a healthy diet only contributes with limited amounts of vitamin D, so during the entire winter period and in other situations where it is not possible to get vitamin D from sunlight, supplements are necessary. We also need magnesium to help the body convert vitamin D from sunlight and supplements (in the form of cholecalciferol) to 25-hydroxy vitamin D and one other active form. Because vitamin D is lipid-soluble, we are best able to utilize it by taking it as a supplement in capsules with oil.

Vitamin D and its anti-cancer properties

  • Vitamin D is able to prevent cancer by means of the following mechanisms:
  • It influences an array of gene activities
  • It inhibits the formation of blood vessels in tumors (angiogenesis)
  • It causes diseased cells to self-destruct (apoptosis)
  • It reduces uncontrolled cell division and metastases
  • It contributes to a well-functioning immune defense that can destroy cancer cells
  • It counteracts local inflammation, which is a common trait for many cancer forms

References

Sanjeev Budhathoki et all. 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
http://www.bmj.com/content/360/bmj.k671

Science News. Higher Vitamin D levels may be linked to lower risk of cancer. ScienceDaily March 2018
https://www.sciencedaily.com/releases/2018/03/180307230406.htm

Shoaib Afzal et al. Genetically low vitamin D concentration and increased mortality: mendelian randomization analysis in three large cohorts. BMJ 2015
http://www.bmj.com/content/349/bmj.g6330

Densie Webb, PhD, RD: Vitamin D and Cancer – Evidence Suggest This Vital
Nutrient may Cut Risk. Today´s Dietician. 2012

Grant WB et al. The association of solar ultraviolet (UVB) with reducing risk of cancer: multifactorial ecologic analysis of geographic variation in age-adjusted cancer mortality rates. Anticancer Res 2006

WU K et al. A nested case control study of plasma 25-hydroxyvitamin D concentrations and risk of colorectal cancer. J Natl Cancer Inst 2007

Andreas R Raven: Langvarigt skifteholdsarbejde giver dobbelt kræftrisiko. Videnskab.dk 2013

http://healthandscience.eu/index.php?option=com_content&view=article&id=361:d-vitamin-taender-for-immunsystemet&catid=20&lang=da&Itemid=269

  • Created on .
8.819MBMemory Usage1.48sRequest 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" => 1738540523 "last" => 1738540523...
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) (611μs)
  • afterInitialise (1.27MB) (119ms)
  • afterRoute (897.2KB) (66.99ms)
  • beforeRenderComponent com_content (22.58KB) (326μs)
  • Before Access::preloadComponents (all components) (33.23KB) (265μs)
  • After Access::preloadComponents (all components) (97.34KB) (14.74ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (24μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (45.8ms)
  • Before Access::getAssetRules (id:3238 name:com_content.article.1605) (130.65KB) (124μs)
  • After Access::getAssetRules (id:3238 name:com_content.article.1605) (7.38KB) (71μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (165ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (657μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (11μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (1.01ms)
  • afterRenderComponent com_content (64.11KB) (116ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.72KB) (13.26ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (30μs)
  • afterDispatch (29.25KB) (8.79ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (1.71ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (96.26KB) (391ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (28μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (45μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (13μs)
  • afterRenderRawModule mod_tags_popular (Search) (45.95KB) (492ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (29μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (44μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (11μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (4.87ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (68μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (15μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (27μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (12μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (31μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (17μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (22μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (10μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (21μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (1.03ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (8.08ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (78μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift) (19.09KB) (7.55ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (23μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (128.59KB) (5.93ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (146μs)
  • afterRenderRawModule mod_custom () (21.95KB) (4.06ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (105μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.79ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (52μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.09ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (35μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.51ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.73KB) (49μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (229μs)
  • afterRenderRawModule mod_custom () (944B) (135μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (24μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (90μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (1.04ms)
  • afterRender (177.65KB) (4.75ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (45.95KB) (33.15%)
    491.78ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (96.26KB) (26.33%)
    390.57ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (11.1%)
    164.74ms
    1 x afterInitialise (1.27MB) (8.04%)
    119.32ms
    1 x afterRenderComponent com_content (64.11KB) (7.83%)
    116.24ms
    1 x afterRoute (897.2KB) (4.52%)
    66.99ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.09%)
    45.80ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.99%)
    14.74ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.72KB) (0.89%)
    13.26ms
    1 x afterDispatch (29.25KB) (0.59%)
    8.79ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.54%)
    8.08ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (19.09KB) (0.51%)
    7.55ms
    1 x afterRenderRawModule mod_finder () (128.59KB) (0.4%)
    5.93ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (0.33%)
    4.87ms
    1 x afterRender (177.65KB) (0.32%)
    4.75ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.27%)
    4.06ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.12%)
    1.79ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.12%)
    1.71ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.1%)
    1.51ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.07%)
    1.09ms
    1 x afterRenderModule mod_custom () (2.71KB) (0.07%)
    1.04ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.07%)
    1.03ms
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.07%)
    1.01ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.04%)
    657μs
    1 x afterLoad (456.34KB) (0.04%)
    611μs
    1 x beforeRenderComponent com_content (22.58KB) (0.02%)
    326μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.02%)
    265μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.02%)
    229μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.01%)
    146μs
    1 x afterRenderRawModule mod_custom () (944B) (0.01%)
    135μs
    1 x Before Access::getAssetRules (id:3238 name:com_content.article.1605) (130.65KB) (0.01%)
    124μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.01%)
    105μs
    1 x afterRenderRawModule mod_custom () (896B) (0.01%)
    90μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    80μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    78μs
    1 x After Access::getAssetRules (id:3238 name:com_content.article.1605) (7.38KB) (0%)
    71μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0%)
    68μs
    1 x afterRenderModule mod_custom () (1.23KB) (0%)
    56μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0%)
    52μs
    1 x afterRenderModule mod_finder () (3.73KB) (0%)
    49μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0%)
    45μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0%)
    44μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0%)
    35μs
    1 x afterRenderModule mod_finder () (3.29KB) (0%)
    35μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    31μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    30μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    29μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0%)
    28μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    24μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    24μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    23μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    22μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    21μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    18μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    17μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    13μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    11μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
45 statements were executed, 9 of which were duplicates, 36 unique1.15s1.14MB
  • SELECT @@SESSION.sql_mode;711μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?108μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1108μ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)9.87ms944BParams/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` = 11.67ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`148μ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` = :guest171μ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`5.47ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC643μ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` = 13.91ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config2.12ms1.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`7.3ms165.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`6.06ms3.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` = 14.86ms848B/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)4.44ms7.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` = 031.81ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`10.58ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1605'6.72ms48B/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.2ms22.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`4.49ms3.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)26.37ms4.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`1.98ms3.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 ASC448μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id167μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id81μ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`34.29ms180.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 DESC94.96ms161.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`806μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 12.66ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0345μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id6.81ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id77μ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:55:23') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-02 23:55:23') AND c2.state = 18.13ms4KBParams/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 10379ms151.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`439μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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.44ms4KBParams/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 15484ms2.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` = :id237μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1271μ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.98ms584B/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 ASC297μ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)148μ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` = 1151μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?117μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.35ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy