Skip to main content

Vitamin D prevents cancer on several accounts

Vitamin D prevents cancer on several accounts- are you getting enough, though?

Studies that have been published over the past decades reveal how vitamin D plays an important role in cancer prevention. Studies also show that most of us lack vitamin D. Nonetheless, vitamin D supplements can make a difference, and research suggests that we need more than the official recommendations.

Vitamin D influences most cells and more than 200 genes. The nutrient it considered a very potent hormone that is known to control cell growth and prevent cancer by means of the following mechanisms:

  • It inhibits the formation of new blood vessels in tumors (angiogenesis)
  • It causes diseased cells to self-destruct (apoptosis)
  • It reduces uncontrollable cell division and metastases
  • It supports a well-functioning immune defense that is able to destroy cancer cells
  • It counteracts local inflammation that is a common trait of many cancer forms

When the body's vitamin D status is low it may affect many of those genes that are responsible for protein coding and the control of cell division. Over time, this may increase your risk of cancer or make it difficult to recover completely after cancer therapy.

More cancers in our sun-deprived, northern part of the world

Sunshine is the single most important source of vitamin D. However, during the winter period the sun sits too low in the sky for humans to be able to synthesize vitamin D, at least in our part of the world. For that reason, we automatically produce far less vitamin D than people in southern countries who get a lot more sunshine.
Way back in the 1940s, researchers discovered a link between UVB exposure from sunlight and cancer mortality. People who lived in the northern hemisphere had an increased risk of Hodgkin's lymphoma and colorectal cancer, breast cancer, and ovary cancer compared with people who lived closer to Equator.

Lack of vitamin D causes cancer

If you have low blood levels of vitamin D, your risk of cancer and early death is increased by 30-40 per cent. This was demonstrated in a large, Danish study that is published in the esteemed British Medical Journal. According to lead investigator Børge Nordestgaard, professor at the University of Copenhagen, a person with vitamin D levels of 33 nmol for every liter of blood (which is 20 nmol below the official recommendation) is 40 per cent more likely to die of cancer.

Skin cancer is on the rise

Despite strong warnings about avoiding the sun and remembering to use sun cream, the rate of skin cancer has not gone down. On the contrary.
Many experts claim that the primary cause of malignant skin cancer (the dangerous kind) is skin traumas such as accidentally cutting into a mole when shaving, or burns from a stove, a sunbed, or the sun. In other words, it is not the sun itself that it is the problem but the traumas/burns. Interestingly, many scientists assume that the sun, which is the primary source of vitamin D, actually protects against the dangerous type of skin cancer - as long as we expose ourselves to healthy amounts of sunshine without getting burned.

Colon cancer

A comprehensive European study has demonstrated a link between low blood levels of vitamin D (less than 50 nmol per liter) and an increased risk of colon cancer. At the same time, people with higher levels of vitamin D in their blood were 40 per cent less likely to develop intestinal cancer.

Breast cancer

Women who expose themselves to a lot of sunshine are only half as likely to develop breast cancer as those who get little sunshine.
Another study divided 1,179 postmenopausal women into three groups. One group got "dummy pills" (placebo), another got a calcium tablet, and the third group got tablets with calcium and vitamin D. The women were monitored for four years. During that period the scientists observed 20 cases of cancer in the placebo group, 17 cases of cancer in the calcium group, and 13 cases of cancer in the vitamin D plus calcium group.
Long-term shift work and working night shifts also increases the risk of breast cancer. This may be a result of low vitamin D and lack of the natural "sleep hormone" melatonin that works as a powerful antioxidant.

80% reduced risk of breast cancer 
80% reduced risk of breast cancer
 In order to maximize the potential for cancer prevention, one must increase serum levels of vitamin D to at least 40-60 ng/ml (100-150 nmol/L) or more.
For breast cancer specifically, the levels must be 80 ng/ml (200 nmol/L)

Alarming vitamin D deficiency

A recent study conducted on employees from a travel agency showed that nearly half of the participants lacked vitamin D. The National Food Institute of Denmark says that 90% of Danes get too little vitamin D from their diet. An Australian study revealed that 58% lacked vitamin D. This is interesting, as it shows that living in a hot climate is no guarantee of adequate vitamin D levels, if you fail to get enough sunshine.

Why do we lack vitamin D?

Vitamin D deficiency has become more widespread through the past decades due to more time spent indoors, fear of the sun, fear of fat, the use of sun factor cream, and long-term use of cholesterol-lowering medicine. Also, older people and dark-skinned individuals have greater difficulty with synthesizing vitamin D in their skin.

New threshold levels require the use of supplements during winter

The lack of vitamin D and the health consequences that this entails appear to be worse than assumed. When measuring levels of vitamin D in the blood the official threshold values are 50 nmol per liter, but leading scientists fear that this is not enough. Instead, they recommend 75-100 nmol per liter to obtain the right levels for optimal disease prevention.
Chief Physician at Hvidovre Hospital, Dr. Jens-Erik Beck Jensen, does not believe that people can obtain these higher levels of vitamin D by following the official dietary guidelines. Actually, more and more researchers recommend daily vitamin D supplementation through the entire winter period.

Vitamin D, supplements, and absorption

Vitamin D is a lipid-soluble vitamin. For that reason, we utilize this nutrient the most effectively when we take small gelatin capsules with vitamin D dissolved in oil. It is completely safe to take strong supplements of vitamin D with e.g. 38 micrograms in each capsule (1-2 capsules daily)

Facts about official recommendations and the increase in cancer rates

Many people who follow the official dietary guidelines, maintain their ideal weight, limit their alcohol intake, exercise, and avoid smoking still develop cancer

According to the Nordic NORDCAN database, the number of cancers will increase by over 50% in the years to follow

Cancer is currently the leading cause of death among people younger than 65 years

Lack of vitamin D is an overlooked factor. Luckily, we can correct this problem with vitamin D supplements.

The same is the case with lack of selenium, another overlooked factor

References

Sundhedsmagasinet på DR - om D-vitamin mangel 18. 01.2016

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

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

https://www.cancer.dk/fagfolk/forebyggelse/sol/hudkraeft/hudkraeft-i-tal/


  • Created on .
8.909MBMemory Usage248msRequest 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" => 1743655006 "last" => 1743655006...
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.34KB) (1.33ms)
  • afterInitialise (1.27MB) (20.81ms)
  • afterRoute (927.02KB) (9.58ms)
  • beforeRenderComponent com_content (23.42KB) (257μs)
  • Before Access::preloadComponents (all components) (35.84KB) (263μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.71ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (14μs)
  • After Access::preloadPermissions (com_content) (3.23MB) (9.31ms)
  • Before Access::getAssetRules (id:1516 name:com_content.article.765) (130.65KB) (123μs)
  • After Access::getAssetRules (id:1516 name:com_content.article.765) (7.47KB) (82μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (31.25ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (185μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (70μs)
  • afterRenderComponent com_content (60.34KB) (23.84ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.95KB) (3.21ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (27μs)
  • afterDispatch (34.13KB) (1.32ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (450μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.52KB) (65.06ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (33μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.45KB) (40.25ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (18μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (37μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (21μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.61KB) (6.11ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (26μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (37μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.14ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (55μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (14μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (25μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (11μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (21μ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) (19μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (19μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (19μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (390μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (3.36ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (6μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (58μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (20μs)
  • afterRenderRawModule mod_languages (Sprogskift) (24.52KB) (3.68ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (21μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.16KB) (6.95ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (33μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (1.85ms)
  • afterRenderRawModule mod_custom () (21.95KB) (1.37ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (104μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (621μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (3μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (39μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.3ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (12μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.91ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.23KB) (46μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (179μs)
  • afterRenderRawModule mod_custom () (944B) (128μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (80μs)
  • afterRenderRawModule mod_custom () (896B) (91μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (23μs)
  • afterRender (169.51KB) (4.76ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.52KB) (26.18%)
    65.06ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.45KB) (16.2%)
    40.25ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (12.58%)
    31.25ms
    1 x afterRenderComponent com_content (60.34KB) (9.6%)
    23.84ms
    1 x afterInitialise (1.27MB) (8.38%)
    20.81ms
    1 x afterRoute (927.02KB) (3.85%)
    9.58ms
    1 x After Access::preloadPermissions (com_content) (3.23MB) (3.75%)
    9.31ms
    1 x afterRenderRawModule mod_finder () (214.16KB) (2.8%)
    6.95ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.61KB) (2.46%)
    6.11ms
    1 x afterRender (169.51KB) (1.91%)
    4.76ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.67%)
    4.14ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (24.52KB) (1.48%)
    3.68ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.35%)
    3.36ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.95KB) (1.29%)
    3.21ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.93%)
    2.30ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.77%)
    1.91ms
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.74%)
    1.85ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.69%)
    1.71ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.55%)
    1.37ms
    1 x afterLoad (456.34KB) (0.54%)
    1.33ms
    1 x afterDispatch (34.13KB) (0.53%)
    1.32ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.25%)
    621μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.18%)
    450μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.16%)
    390μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.11%)
    263μs
    1 x beforeRenderComponent com_content (23.42KB) (0.1%)
    257μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.07%)
    185μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.07%)
    179μs
    1 x afterRenderRawModule mod_custom () (944B) (0.05%)
    128μs
    1 x Before Access::getAssetRules (id:1516 name:com_content.article.765) (130.65KB) (0.05%)
    123μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.04%)
    104μs
    1 x afterRenderRawModule mod_custom () (896B) (0.04%)
    91μs
    1 x After Access::getAssetRules (id:1516 name:com_content.article.765) (7.47KB) (0.03%)
    82μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.03%)
    80μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.03%)
    70μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.02%)
    58μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    55μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    53μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.02%)
    46μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.02%)
    39μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    37μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    37μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    33μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    33μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    26μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    25μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0.01%)
    23μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    21μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0.01%)
    20μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0.01%)
    19μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0.01%)
    19μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    19μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    18μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0.01%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    16μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0.01%)
    14μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    12μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (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_menu (Main menu-US) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique149ms1.33MB
  • SELECT @@SESSION.sql_mode;47μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?106μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 173μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.99ms944BParams/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` = 1206μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`79μ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` = :guest144μ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`480μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.59ms2.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` = 1139μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config161μs1.06KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `has_menu` AS `m` LEFT JOIN `has_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.79ms165.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`335μ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` = 1186μ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)350μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 05.45ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.27ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '765'1000μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)1.08ms22.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`308μ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)1.34ms4.06KBParams/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`317μ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 ASC340μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id99μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id65μ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`4.37ms180.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 DESC16.35ms161.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`2.16ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1101μ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` = 0396μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id185μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id111μ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-04-03 04:36:46') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-03 04:36:46') AND c2.state = 1409μs4.02KBParams/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 1061.77ms195.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-04-03 04:36:46', 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 1037.22ms2.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 101.28ms159.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`403μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id1.41ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1162μ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)159μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC773μ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)969μ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` = 1117μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?92μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.85ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy