Skip to main content

Vitamin D (calciferol)

Vitamin D (calciferol)There are several kinds of vitamin D with the two most important being:

  • D2, ergocalciferol, that is found naturally in the plant kingdom.
  • Vitamin D3, cholecalciferol, that is found naturally in the animal kingdom.

Humans synthesise vitamin D (cholecalciferol) from sunlight (UV-B rays) and a cholesterol compound in the skin, which is converted to active vitamins by means of processes in the liver and kidneys. We humans are only able to synthesise vitamin D during the summer season when the sun is high in the sky. Excess amounts of the nutrient are stored in the liver for future use. Light skin produces substantially larger amounts of vitamin D than dark skin. In contrast, dark skin protects against vitamin D overproduction. As we grow older, our vitamin D production decreases. Vitamin D is also called a provitamin or hormone, simply because we are easily able to make it ourselves, and all cells in the body have vitamin D receptors.
Vitamin D is fat-soluble and is stored in the body's fat tissue when ingested in large amounts. Vitamin D is destroyed by light and heat from cooking.

Functions and importance for

  • Physical and psychological stress
  • The body's uptake and utilisation of calcium and phosphor
  • The blood's calcium balance together with the thyroid hormone calcitonin
  • Strong bones and teeth (especially together with calcium, magnesium, and vitamin K2)
  • Muscle function
  • Immune system
  • Counteracts inflammation that is also seen with autoimmune diseases
  • Normal cell division
  • Energy levels and mood
  • Cancer prevention (according to some studies)

Vitamin D3 is 56-87% more effective than vitamin D2 in terms of increasing blood levels of the nutrient. Also, it is stored more effectively in the liver.

Deficiencies and poor utilisation may be caused by

  • Too little sun exposure during the summer season
  • Veiling and dark skin
  • Impaired lipid absorption
  • Low-fat diets without sources such as oily fish and eggs
  • Alcoholism
  • Menopause
  • Old age, especially in combination with an unbalanced diet, lack of sunlight, and thin skin
  • Kidney failure or liver failure (these organs activate vitamin D)
  • Genetic defects. Identified in people who are unable to synthesise vitamin D in their skin
  • Sunscreen with more than factor 8 blocks the synthesis of vitamin D in the skin
  • Long-term use of medical drugs such as:

Cholesterol-lowering medicine

Drugs against epilepsy

  • Long-term use of paraffin oil against constipation
  • Weight loss products such as Orlistat/Xenical that inhibit the uptake of fat and fat-soluble vitamins

Deficiency symptoms

  • Osteoporosis and bone deformities
  • Bone fractures
  • Tooth decay
  • Loss of muscle strength and muscle cramps
  • Cardiovascular disease
  • Impaired immunity
  • Autoimmune diseases and perhaps type 1 diabetes and sclerosis
  • Fatigue and mood swings
  • Psychological and neurological diseases such as depression, schizophrenia, and Alzheimer's disease (according to several newer studies)

Children: The classic deficiency disease rickets (rachitis) with its characteristic symptoms that include soft and deformed bones and underdeveloped tooth enamel.

Many vitamin D deficiency symptoms are a result of the accompanying calcium deficit.

Sources

  • Primarily sunlight. Other sources are cod liver oil, cod liver, cod roe, and (oily) fish. Smaller amounts of the vitamin are found in eggs, meat, avocado, oils, dairy products, and breastmilk. Vitamin D is bound to lipids and oils.

Please note: Plants also need sunlight in order to produce vitamin D (D2). For that reason, a sun-ripened avocados contain far more vitamin D than avocados that have not been sun-ripened.

Vitamin D content in micrograms per 100 grams

Cod liver oil 250
Fresh salmon and eel 30
Pickled herring 10
Egg yolk 4
(whole eggs 1.75)
Cream 0.2


Vitamin D from sunlight

During the summer season we are able to get enough vitamin D simply by being outdoors and exposing our face, forearms, and lower legs to sunlight for 5-30 minutes a few times per week. Sun exposure should never result in erythema, as this may increase the risk of skin cancer. If you prolong your stay in the sun it is advisable to apply protective sunscreen once the skin has been exposed to sufficient amounts of sunlight for being able to produce vitamin D.

The amount of vitamin D synthesised either from sunlight or artificial UV radiation depends on our skin colour, the sun's position on the sky, and how soon after sun exposure we bathe. It may take as long as 48 hours for newly synthesised vitamin D precursors in the epidermis to reach the bloodstream. Before these precursors effectively penetrate through the skin layers and into to the blood, a large amount of them may vanish when we apply soap and water to our skin. It is factors like these that make it difficult to assess how much vitamin D we get from sun exposure.

Recommended daily allowance (RDA)

Adults: 11 years of age and older: 5 micrograms
Children: 1-10 years of age: 10 micrograms

Infants: Breastmilk alone is not enough to ensure optimal amounts of vitamin D. According to the Danish Health and Medicines Authority, infants with light skin must be supplemented with 10 micrograms of vitamin D daily from the age of two weeks until the end of their first year. Dark-skinned infants are advised to take supplements until they are three years of age.

Increased need and recommendation of supplements

  • The above mentioned deficiency symptoms
  • The health authorities recommend a daily supplement to:
  • Children in the age group 0-2 years
  • Pregnant women
  • Children and adults with dark skin
  • Children and adults who wear fully covering clothing during the summer period
  • Individuals who normally don't go outdoors on a daily basis or who avoid sunlight
  • Nursing home residents
  • People older than 70 years of age
  • Vegans and vegetarians are advised to follow the official guidelines concerning sun exposure and possibly discontinue vitamin D supplementation during the winter period.

Detection of vitamin D deficiency

In order to determine the body's vitamin D status, blood levels of the natural 25-hydroxyvitamin 3 are measured. The content is measured in nmol/l and graduated in the following way:

Less than 12 nmol/l Severely deficient
12-25 nmol/l: Deficient
25-50 nmol/l Insufficient
Above 50 nmol/l: Sufficient
75-150: nmol/l: Optimal level in people with osteoporosis and in kidney patients
Over 200 nmol/l: Risk of toxicity


According to the Danish Health and Medicines Authority, the following people should have their vitamin D status checked:

  • People with clinical signs of vitamin D deficiency
  • People whose lifestyle may give reason to suspect a vitamin D deficiency

Overdosing - side effects

It is not possible to overdose on vitamin D through excessive sun exposure or by eating too much fish.
Very large vitamin D levels may lead to elevated blood calcium levels, and elevated calcium levels may cause:

  • Nausea
  • Headache
  • Constipation

Extreme dosages (e.g. 100 more than the RDA) over longer periods of time may cause calcium to deposit in the kidneys and bladder and may also lead to kidney stones.

8.609MBMemory Usage297msRequest 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" => 1738275904 "last" => 1738275904...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.44KB) (2.72ms)
  • afterInitialise (1.27MB) (48.42ms)
  • afterRoute (902.3KB) (20.63ms)
  • beforeRenderComponent com_content (28.4KB) (214μs)
  • Before Access::preloadComponents (all components) (33.22KB) (200μs)
  • After Access::preloadComponents (all components) (97.34KB) (10.05ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (13μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (35.51ms)
  • Before Access::getAssetRules (id:908 name:com_content.article.477) (130.65KB) (94μs)
  • After Access::getAssetRules (id:908 name:com_content.article.477) (7.38KB) (48μs)
  • afterRenderComponent com_content (1.12MB) (78.21ms)
  • Before Access::getAssetRules (id:8 name:com_content) (48.82KB) (19.66ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (28μs)
  • afterDispatch (13.09KB) (633μs)
  • beforeRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (336.26KB) (32.2ms)
  • afterRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (16.2KB) (195μs)
  • beforeRenderModule mod_custom (Are you getting enough vitamins and minerals?) (265.5KB) (9.48ms)
  • afterRenderModule mod_custom (Are you getting enough vitamins and minerals?) (1.98KB) (1.1ms)
  • beforeRenderRawModule mod_menu (Main Menu - English) (14.46KB) (205μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (199.65KB) (2.07ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (5.23KB) (60μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (9.9KB) (6.72ms)
  • 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 () (65.58KB) (3.88ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (143μs)
  • afterRenderRawModule mod_custom () (21.92KB) (1.29ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (2.48KB) (49μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (102μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (754μs)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (3μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (43μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (3.71ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (33μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (11μs)
  • afterRenderRawModule mod_finder () (6.29KB) (6.3ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (47μs)
  • beforeRenderRawModule mod_custom () (12.13KB) (186μs)
  • afterRenderRawModule mod_custom () (944B) (127μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (1.01ms)
  • afterRenderRawModule mod_custom () (896B) (141μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (29μs)
  • afterRender (187.57KB) (7.76ms)
  • 1 x afterRenderComponent com_content (1.12MB) (26.34%)
    78.21ms
    1 x afterInitialise (1.27MB) (16.31%)
    48.42ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (11.96%)
    35.51ms
    1 x beforeRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (336.26KB) (10.85%)
    32.20ms
    1 x afterRoute (902.3KB) (6.95%)
    20.63ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (48.82KB) (6.62%)
    19.66ms
    1 x After Access::preloadComponents (all components) (97.34KB) (3.38%)
    10.05ms
    1 x beforeRenderModule mod_custom (Are you getting enough vitamins and minerals?) (265.5KB) (3.19%)
    9.48ms
    1 x afterRender (187.57KB) (2.61%)
    7.76ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (9.9KB) (2.26%)
    6.72ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (2.12%)
    6.30ms
    1 x afterRenderRawModule mod_finder () (65.58KB) (1.31%)
    3.88ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.25%)
    3.71ms
    1 x afterLoad (456.44KB) (0.92%)
    2.72ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (199.65KB) (0.7%)
    2.07ms
    1 x afterRenderRawModule mod_custom () (21.92KB) (0.43%)
    1.29ms
    1 x afterRenderModule mod_custom (Are you getting enough vitamins and minerals?) (1.98KB) (0.37%)
    1.10ms
    1 x beforeRenderRawModule mod_custom () (688B) (0.34%)
    1.01ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.25%)
    754μs
    1 x afterDispatch (13.09KB) (0.21%)
    633μs
    1 x beforeRenderComponent com_content (28.4KB) (0.07%)
    214μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (14.46KB) (0.07%)
    205μs
    1 x Before Access::preloadComponents (all components) (33.22KB) (0.07%)
    200μs
    1 x afterRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (16.2KB) (0.07%)
    195μs
    1 x beforeRenderRawModule mod_custom () (12.13KB) (0.06%)
    186μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.05%)
    143μs
    1 x afterRenderRawModule mod_custom () (896B) (0.05%)
    141μs
    1 x afterRenderRawModule mod_custom () (944B) (0.04%)
    127μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.03%)
    102μs
    1 x Before Access::getAssetRules (id:908 name:com_content.article.477) (130.65KB) (0.03%)
    94μs
    1 x afterRenderModule mod_menu (Main Menu - English) (5.23KB) (0.02%)
    60μs
    1 x afterRenderModule mod_custom () (2.48KB) (0.02%)
    49μs
    1 x After Access::getAssetRules (id:908 name:com_content.article.477) (7.38KB) (0.02%)
    48μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.02%)
    47μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    43μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    33μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    29μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    28μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (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%)
    13μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    6μs
41 statements were executed, 9 of which were duplicates, 32 unique92.06ms858.27KB
  • SELECT @@SESSION.sql_mode;444μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?101μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1501μ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)927μs944BParams/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` = 1269μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`211μ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` = :guest1.25ms1.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`647μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC3.04ms2.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` = 11.28ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config279μ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.17ms165.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`282μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `has_template_styles` AS `s` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 11.2ms848B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)4.27ms7.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` = 018.47ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`2.57ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '477'4.13ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)2.15ms22.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`3.6ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)10.1ms4.16KBParams/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`650μs4KBParams/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 ASC3.74ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id115μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id69μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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` END1.16ms2.38KBParams/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`392μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1146μ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` = 01.23ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.74ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id176μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-01-30 22:25:04') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-01-30 22:25:04') AND c2.state = 1278μs1.47KBParams/libraries/src/Language/Associations.php:145Copy
  • 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`15.67ms199.34KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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.48ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 11.14ms640B/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)134μ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 ASC299μ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)129μ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` = 1723μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?127μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?5.77ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy