Skip to main content

Vitamin D and its importance for the prevention of breast cancer - and after the diagnosis

Vitamin D and its importance for the prevention of breast cancer - and after the diagnosisLow blood levels of vitamin D are associated with an increased risk of breast cancer. Also, breast cancer patients with optimal levels of vitamin D in their blood can expect to live longer than breast cancer patients with low blood levels of the nutrient. But how much vitamin D is needed to prevent the dreaded disease?

Breast cancer is one of the most common cancer forms with Belgium, Denmark, France, and The Netherlands as the four top-ranking countries in the world in terms of prevalence. Although screening methods have improved over the years, the statistics certainly have not. On the contrary. Therefore, we have every reason in the world to focus more on how to prevent breast cancer. Here, our lifestyle and intake of nutrients like vitamin D, selenium, iodine, and omega-3 fatty acids appears to play a vital role, provided we supply our bloodstream and cells with optimal levels of the nutrient.

Vitamin D protects our cells at several different levels

Vitamin D is primarily known for its role in bone health. Nonetheless, all cells in the body depend on vitamin D. In terms of cancer prevention, vitamin D's primary role is its normalizing effect on genes, cells, and tissues. The secondary role of vitamin D relates to insulin levels, cardiovascular system, immune defense, inflammation processes, and other factors, all of which are also important for the way cells thrive.

Did you know that our primary source of vitamin D is the sun, and that women who get exposed to a lot of sunlight are only half as likely to develop breast cancer compared with those who get less sunshine?

Genes determine how well we utilize vitamin D

Vitamin D's influence on breast cancer prevention depends on our genes, especially a cellular vitamin D receptor known as VDR. Women can have different versions of the VDR gene, which determines how effectively vitamin D binds to the cell. This genetic difference alone may enable some women to be better than others at utilizing the vitamin.
Vitamin D's effect in terms of preventing breast cancer is also related to the intake of calcium. A study has demonstrated that a particular version of the VDR gene is associated with lower risk of breast cancer in women who consume large amounts of calcium. Also, it is important to recall that calcium and magnesium work closely together.

As a part of the follow-up treatment of breast cancer women are offered tamoxifen, which is an anti-estrogen. In laboratory studies, vitamin D has been shown to counteract the growth of tamoxifen-resistant breast cancer cells. This, most likely, is a VDR-related mechanism.
There is also evidence suggesting that vitamin D can reduce the amount of circulating estrogen in the blood by reducing a process called aromatase.

Vitamin D counteracts the following, which is related to the development of breast cancer

  • Inflammation
  • Gene activity - including VDR
  • Cell differentiation
  • Cell growth
  • Angiogenesis (the forming of new blood vessels)
  • Circulating estrogen via aromatase

Population studies reveal a correlation between vitamin D and breast cancer

Several population studies have looked at the relation between vitamin D and breast cancer. Most, but not all, studies show that low vitamin D levels increase the risk of breast cancer, while higher levels seem to protect against the disease. Also, there is evidence pointing to vitamin D as having the greatest effect on breast cancer prevention when women synthesize or consume large amounts of the vitamin early in life. Because of this and other factors, scientists have not always been able to prove a direct relation between actual vitamin D levels in the blood and the risk of breast cancer. When individual studies have failed to show that vitamin D supplements have a protective effect on breast cancer, it may be because the amounts that were consumed were not large enough to make a difference. Here are some studies of interest:

  • According to an Italian study, the risk of breast cancer is significantly lower among women who rank in the top-10 group for intake of vitamin D. The same was seen in a Chinese study.
  • A Canadian study links increased sun exposure from the age of 10-19 years to a reduced risk of breast cancer
  • 1,179 post-menopausal women were divided in three groups in a study. One group got a placebo (dummy pill), one group got a calcium tablet, and one group got a pill with calcium and vitamin D. The women were monitored for four years. The researchers observed 20 cancer cases in the placebo group, 17 cases in the calcium group, and 13 cases in the group that got vitamin D and calcium.
  • A study has shown that 2/3 of breast cancer patients have low vitamin D levels in their blood, especially dark-skinned individuals who produce less vitamin D from sunlight. High-dosed vitamin D supplements increased plasma levels of the nutrient, which was not the case with low-dosed supplements. The researchers therefore concluded that normal vitamin pills with 5-10 micrograms of vitamin D are not effective for preventing breast cancer.
  • A laboratory study has shown that the combination of a vitamin D supplement and radiation therapy increased the death of breast cancer cells from 30 to 75 per cent.
  • A Norwegian study revealed that women who were diagnosed with breast cancer during the summer period where blood levels of vitamin D peak, had the lowest risk of dying of their disease. The researchers concluded that the relatively high vitamin D level at the time where the diagnosis was made helped improve the outcome of conventional therapy.
  • A German study found a relation between low vitamin D levels at the time of the breast cancer diagnosis and initiation of the conventional treatment and an increased risk of the disease flaring up again within the next five years.
  • A mouse study has shown that lack of vitamin D increases the growth of bone metastases

How do we get vitamin D?

The sun is our primary vitamin D source, and the amount of vitamin D that we humans are able to synthesize on a hot summer day can easily be between 10 and 100 times greater than the daily reference intake level.
In the northern parts of Europe it is only possible to synthesize vitamin D in the skin during the summer period where the sun sits sufficiently high in the sky. It therefore makes absolutely no sense to encourage people to stay out of the sun or to cover up in the middle of the day. Even though it is possible to get too much sun, we cannot synthesize too much vitamin D, as the synthesis is self-regulating.
It is a good idea slowly to get used to the sun during the spring period. If you are worried about getting a sunburn, limit your unprotected sun exposure to 20 or 30 minutes daily. After that, apply sunscreen if you plan to spend more time in the sun.
In terms of diet, the highest concentrations of vitamin D are found in cod liver and oily fish such as herring, salmon, mackerel, and sardines. Smaller amounts of vitamin D are found in egg yolk, meat, avocado, plant oils, and high-fat dairy products. The amount of vitamin D that we get from our diet is rather limited.

Vitamin D synthesis on a sunny summer day

  • Indoor activities: 0 micrograms
  • Brief lunch break in the sun: 25 micrograms
  • At the beach in bathing clothes: 250-500 micrograms

The listed figures are merely indicative. A human's vitamin D synthesis depends on many factors such as age, skin type, the time of day etc.

Why do we lack vitamin D?

Vitamin D deficiencies have become increasingly common in the past decades as a result of spending too much time indoors, worrying about sun exposure, shying away from fats in our diet, using sun cream, and using cholesterol-lowering medication for extended lengths of time. Also, older people and individuals with dark skin pigmentation produce less vitamin D than others.
Another problem is the rapidly growing number of overweight people and diabetics, who also have difficulty with synthesizing and utilizing vitamin D and who therefore have an increased need for the vitamin.

New threshold levels call for supplementation during the winter period

The lack of vitamin D and the health complications that follow in its wake are far worse than originally believed. The official guidelines for blood levels of vitamin D suggest 50 nmol per liter as being adequate, but according to leading vitamin D experts, it takes as much as 75-100 nmol per liter to provide optimal disease prevention. Although vitamin D levels are determined by means of blood samples, these are no guarantee of proportionally similar levels in e.g. breast tissue. According to Dr. Jens-Erik Beck Jensen, a chief physician at Hvidovre Hospital, it is not realistic to obtain such high levels of vitamin D by following the official dietary guidelines. In fact, more and more researchers recommend vitamin D supplements during the winter period - and they even recommend all-year supplementation to those who fail to get enough sunlight during the summer.

Vitamin D, supplements, and absorption

Vitamin D is lipid-soluble Therefore, we humans are best able to utilize supplements that contain vitamin D in vegetable oil in capsules. Many scientists claim that it is perfectly responsible to consume supplements that provide 30-100 micrograms of vitamin D daily. This is not more than the amount, which our skin is able to synthesize on a sunny summer day.

Facts on breast cancer

  • Even people who stick with the official dietary guidelines, maintain their ideal weight, limit their alcohol intake, exercise, and avoid smoking can get breast cancer
  • Lack of vitamin D is an overlooked risk factor, which we can fortunately correct by means of sun exposure, diet, and the use of supplements
  • Birth control pills and hormone therapy after menopause increase the risk of breast cancer
  • About one in seven breast cancers is caused by excessive alcohol consumption
  • Obesity and physical inactivity increase the risk (possibly because of the influence on estrogen levels)
  • Shift work and working at night increase your risk
  • The risk for Danish women is five times greater than for Chinese and Japanese women
  • Asian women who shift to western diet habits have the same relative risk as other women of developing breast cancer
  • Lack of selenium, iodine, and omega-3 fatty acids also increase the risk
When the body's vitamin D status is too low, it may affect many of those genes that are responsible for protein coding and the regulation of cell division. Over time, this may increase the risk of cancer or make it difficult to recover completely after receiving treatment.

References:

http://foodforbreastcancer.com/articles/how-important-is-vitamin-d-before-and-after-breast-cancer-diagnosis%3F

Densie Webb, PhD, RD: Vitamin D and Cancer - Evidence Suggest This Vital
Nutrient may Cut Risk. Today´s Dietitian. 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

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

http://www.netdoktor.dk/sygdomme/fakta/brystkraeft.htm

Pernille Lund. Sund og smuk - hele livet. Ny videnskab 2016


  • Created on .
9.092MBMemory Usage665msRequest 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" => 1740279183 "last" => 1740279183...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-US" ]
  • afterLoad (456.63KB) (5.54ms)
  • afterInitialise (1.27MB) (53.18ms)
  • afterRoute (930.85KB) (22.92ms)
  • beforeRenderComponent com_content (24.37KB) (452μs)
  • Before Access::preloadComponents (all components) (35.84KB) (2.57ms)
  • After Access::preloadComponents (all components) (97.34KB) (2.89ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (21.65ms)
  • Before Access::getAssetRules (id:1916 name:com_content.article.946) (130.65KB) (2.29ms)
  • After Access::getAssetRules (id:1916 name:com_content.article.946) (7.47KB) (67μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (68.75ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (329μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (6.04KB) (226μs)
  • afterRenderComponent com_content (68.34KB) (47.11ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.18KB) (16.26ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (39μs)
  • afterDispatch (30.26KB) (8.55ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (1.65ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (89.4KB) (215ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (32μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.05KB) (86.03ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (30μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (55μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (22μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (19.72ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (29μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (44μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (23.59ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (77μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (23μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (29μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (13μ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) (17μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (22μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (19μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (5.66ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (6.65ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (6μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (64μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift) (25.29KB) (7.54ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (12μs)
  • afterRenderRawModule mod_finder () (214.16KB) (11.15ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (147μs)
  • afterRenderRawModule mod_custom () (22.3KB) (3.82ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (51μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (107μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (658μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (3μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (42μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (5.74ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (11μs)
  • afterRenderRawModule mod_finder () (6.09KB) (582μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.23KB) (43μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (3.18ms)
  • afterRenderRawModule mod_custom () (944B) (146μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.43KB) (31μs)
  • beforeRenderRawModule mod_custom () (688B) (93μs)
  • afterRenderRawModule mod_custom () (896B) (94μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (277.63KB) (17.78ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (89.4KB) (32.27%)
    214.55ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.05KB) (12.94%)
    86.03ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.35MB) (10.34%)
    68.75ms
    1 x afterInitialise (1.27MB) (8%)
    53.18ms
    1 x afterRenderComponent com_content (68.34KB) (7.09%)
    47.11ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (3.55%)
    23.59ms
    1 x afterRoute (930.85KB) (3.45%)
    22.92ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (3.26%)
    21.65ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (2.97%)
    19.72ms
    1 x afterRender (277.63KB) (2.67%)
    17.78ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.18KB) (2.45%)
    16.26ms
    1 x afterRenderRawModule mod_finder () (214.16KB) (1.68%)
    11.15ms
    1 x afterDispatch (30.26KB) (1.29%)
    8.55ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (25.29KB) (1.13%)
    7.54ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1%)
    6.65ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.86%)
    5.74ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.85%)
    5.66ms
    1 x afterLoad (456.63KB) (0.83%)
    5.54ms
    1 x afterRenderRawModule mod_custom () (22.3KB) (0.57%)
    3.82ms
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.48%)
    3.18ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.44%)
    2.89ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.39%)
    2.57ms
    1 x Before Access::getAssetRules (id:1916 name:com_content.article.946) (130.65KB) (0.34%)
    2.29ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.25%)
    1.65ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.1%)
    658μs
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.09%)
    582μs
    1 x beforeRenderComponent com_content (24.37KB) (0.07%)
    452μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.05%)
    329μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.04KB) (0.03%)
    226μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.02%)
    147μs
    1 x afterRenderRawModule mod_custom () (944B) (0.02%)
    146μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    107μs
    1 x afterRenderRawModule mod_custom () (896B) (0.01%)
    94μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    93μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    77μs
    1 x After Access::getAssetRules (id:1916 name:com_content.article.946) (7.47KB) (0.01%)
    67μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    64μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    55μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    51μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    44μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    43μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    42μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    39μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    35μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0%)
    32μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    31μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0%)
    30μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0%)
    29μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    29μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    23μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    22μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    22μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    19μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    13μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
45 statements were executed, 9 of which were duplicates, 36 unique384ms1.37MB
  • SELECT @@SESSION.sql_mode;1.56ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?149μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1144μ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)4.11ms944BParams/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.6ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`133μ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` = :guest317μ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`2.26ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC205μ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` = 1192μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config413μ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`3.56ms165.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`354μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `has_template_styles` AS `s` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1280μ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)1.7ms7.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` = 04.32ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`759μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '946'3.53ms48B/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.72ms62.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`483μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)2.83ms4.08KBParams/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`370μ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 ASC1.22ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id164μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id181μ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`6.67ms180.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 DESC25.57ms161.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.67ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1166μ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` = 05.97ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.66ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id926μ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-23 02:53:03') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-23 02:53:03') AND c2.state = 16.16ms4KBParams/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 10205ms195.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-23 02:53:03', 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 1081.65ms2.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 104.01ms159.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`3.82ms3.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` = :id148μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1188μ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)2.96ms584B/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 ASC337μ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)136μ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` = 11.11ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?91μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy