Skip to main content

Vitamin A (retinol and beta-carotene)

Vitamin A (retinol and beta-carotene)Pure vitamin A (retinol) is a lipid-soluble vitamin. It is primarily found in animal sources that contain fat. Vegetable sources contain a lipid-soluble precursor of vitamin A called beta-carotene. Pure vitamin A is primarily stored in the liver and in fatty tissue, for which reason we do not need a daily supply of the nutrient. Vitamin A and zinc work together. A deficiency in one nutrient will therefore affect the other. On a global scale, vitamin A deficiencies are widespread. In Western countries vitamin A deficiency is normally seen in connection with chronic disease. Vitamin A is destroyed when exposed to oxygen or heat, for instance during cooking.

Functions and importance

  • Eyes and light perception: Needed for the synthesis of rhodopsin which we humans need in order to see during twilight and in the dark.
  • Immune defence and protection against infections
  • Mucous membranes
  • The condition and moisture level of skin
  • Hormonal system, reproduction, and formation of new sperm cells
  • Genetic coding, fetal growth and development
  • Antioxidant function (especially beta-carotene)
  • Protection against harmful impact from free radicals (from sunlight, tobacco smoke, inflammation, etc.)

Deficiencies and poor utilisation may be caused by:

  • Impaired fat absorption caused by gastro-intestinal disease or medical drugs
  • Diabetes and subsequent lack of ability to convert beta-carotene
  • Long-term use of antacids
  • Unbalanced diets, alcoholism, and old age 
  • Pregnancy and lactation

Deficiency symptoms

  • Night blindness, dry eyes, and conjunctivitis 
  • Dry, flaky skin and other skin conditions
  • Dry and sensitive mucous membranes
  • Impaired immunity
  • Fragile hair and nails that crack or split
  • Reduced ability to hear, smell and taste
  • Abnormal fetal development

A vitamin A deficiency is detectable by means of a blood test that measures the blood content of retinol.

Animal and plant sources

The two most important sources are:

Retinol
Pure vitamin A from animal sources
Beta-carotene
Precursor from plant sources
Found in animal sources such as cod liver oil, liver, liver pate, kidneys, butter, cheese, egg yolk, and oily fish Found in green/red/yellow vegetable sources such as carrots, rosehips, parsley, kale, spinach, tomatoes, bell pepper, and melon.
Lipid-soluble
Stored in the liver and in fatty tissue for future need.
Requires zinc to be released from the liver.
Stays a relatively long time in the body.
Lipid-soluble
Gets converted to retinol in the intestinal mucous membrane as needed.
Does not get stored.
A particularly powerful antioxidant.
The most potent type of vitamin A.
12 times stronger effect than seen with beta-carotene.
Possible to overdose.
The weakest type of vitamin A.
The need is correspondingly greater. Practically impossible to overdose, which makes it safer for supplementation.


Measuring units for retinol and beta-carotene

The content of vitamin A is specified in RE (retinol equivalents) that corresponds with the total vitamin A effect.
Recent studies have shown that the effect of beta-carotene is not as great as previously assumed. For that reason, the vitamin A effect of beta-carotene has been halved in the new food listings.

1 RE= 1 microgram of retinol = 12 micrograms of beta-carotene
The former declaration known as IU (International Units) is still seen.
1 IU = 0.3 micrograms of retinol

Vitamin A content in selected foods (per 100 grams).

The content of retinol and beta-carotene is listed both in micrograms and in RE:

Cod liver oil (retinol)

30,000 micrograms/ RE
Pork liver (retinol) 14,125 micrograms /RE
Carrots (beta-carotene) 9,790 micrograms = 816 RE
Spinach (beta-carotene) 4,186 micrograms = 349 RE


Recomended daily allowance

Adults: 11 years of age and older: 800 micrograms/RE
Children: 1-10 years of age: 400 micrograms/RE.

Supplements are available both with retinol (pure vitamin A) and beta-carotene.

Always remember to take supplements together with a meal, as the fat content increases nutrient absorption.

Increased need

  • In connection with the mentioned deficiency symptoms
  • Pregnancy and lactation
  • Gastro-intestinal diseases with impaired fat absorption
  • Diabetics who in contrast to healthy people are unable to convert beta-carotene
  • Unbalanced diets, extended periods of dieting, and pure vegetarianism (vegans)
  • Old age
  • Large alcohol consumption

Precautions

  • Women who are pregnant or lactating should not ingest over 1,000 micrograms/ RE daily
  • Women who are pregnant or lactating should avoid ingesting large quantities of vitamin A, as this may cause fetal damage or harm the infant via the breast milk. Also, pregnant and lactating women must refrain from eating pure liver or taking supplements, unless the preparations are designed to be used during pregnancy and/or lactation
  • In case of seriously compromised renal function, special caution must be exercised with large dosages
  • It is safer to take beta-carotene, as this nutrient cannot be overdosed
  • Contraceptive pills increase blood levels of vitamin A and therefore the need for this nutrient is reduced
  • Large amounts of beta-carotene (from e.g. carrots) may cause the skin to turn yellowish, but this is completely harmless
  • People who use prescription medicine such as Roacutane (chemical vitamin A in pill form) and retinoic acid cream should avoid taking vitamin A supplements. There is a risk of side effects from these treatments.

Beta-carotene and smokers

Nutritional supplements with beta-carotene must carry a warning stating that these products are not suited for smokers. This warning is a consequence of two American studies that were conducted with synthetically manufactured beta-carotene. When ingested in excessive amounts, this may slightly increase the risk of lung cancer in heavy smokers. In contrast, Chinese research has shown that beta-carotene combined with selenium and vitamin E reduces the risk of lung cancer.

Overdosing and side effects

  • Overdosing is rarely seen and only occurs when the depots in the liver are saturated and the intake of large amounts of vitamin A (retinol) continues
  • If ingested on an empty stomach, transient side effects such as nausea may occur
  • Acute poisoning may occur if more than 100 milligrams of vitamin A are ingested. This is more than 100 times the RDA level of 800 micrograms (RE)
  • The symptoms include nausea, vomiting, elevated brain pressure and headache. Also, cramps, itching, and dry and flaky skin may occur in the case of very large single doses.
  • Chronic poisoning only occurs after several months of ingesting daily dosages of several thousand micrograms (RE)
  • Symptoms include nausea, headache, aching joints, dry and flaky skin, and constipation
  • Increased risk of fetal damage may be seen in pregnant women who ingest over 3,000 micrograms (RE) daily
  • Pregnant women should not ingest over 1,000 micrograms (RE) daily

 

8.598MBMemory Usage172msRequest 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" => 1739349368 "last" => 1739349368...
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.41KB) (1.64ms)
  • afterInitialise (1.27MB) (24.4ms)
  • afterRoute (902.3KB) (15.62ms)
  • beforeRenderComponent com_content (28.67KB) (212μs)
  • Before Access::preloadComponents (all components) (33.22KB) (186μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.87ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (15μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (10.87ms)
  • Before Access::getAssetRules (id:897 name:com_content.article.466) (130.65KB) (84μs)
  • After Access::getAssetRules (id:897 name:com_content.article.466) (7.38KB) (50μs)
  • afterRenderComponent com_content (1.1MB) (46.06ms)
  • Before Access::getAssetRules (id:8 name:com_content) (48.89KB) (12.75ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (25μs)
  • afterDispatch (13.07KB) (3.18ms)
  • beforeRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (336.26KB) (13.88ms)
  • afterRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (16.2KB) (1.24ms)
  • beforeRenderModule mod_custom (Are you getting enough vitamins and minerals?) (265.5KB) (6.66ms)
  • afterRenderModule mod_custom (Are you getting enough vitamins and minerals?) (1.98KB) (69μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (14.46KB) (149μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (199.65KB) (4.42ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (5.23KB) (56μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (16μs)
  • afterRenderRawModule mod_languages (Sprogskift) (9.87KB) (8.76ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (20μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (9μs)
  • afterRenderRawModule mod_finder () (65.58KB) (5.84ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (31μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (129μs)
  • afterRenderRawModule mod_custom () (21.95KB) (2.7ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (2.48KB) (51μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (94μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.72ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (50μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.67ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (45μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.29KB) (471μs)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (44μs)
  • beforeRenderRawModule mod_custom () (12.13KB) (171μs)
  • afterRenderRawModule mod_custom () (944B) (123μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (22μs)
  • beforeRenderRawModule mod_custom () (688B) (86μs)
  • afterRenderRawModule mod_custom () (896B) (88μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (21μs)
  • afterRender (183.59KB) (6.36ms)
  • 1 x afterRenderComponent com_content (1.1MB) (26.71%)
    46.06ms
    1 x afterInitialise (1.27MB) (14.15%)
    24.40ms
    1 x afterRoute (902.3KB) (9.06%)
    15.62ms
    1 x beforeRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (336.26KB) (8.05%)
    13.88ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (48.89KB) (7.4%)
    12.75ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (6.31%)
    10.87ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (9.87KB) (5.08%)
    8.76ms
    1 x beforeRenderModule mod_custom (Are you getting enough vitamins and minerals?) (265.5KB) (3.86%)
    6.66ms
    1 x afterRender (183.59KB) (3.69%)
    6.36ms
    1 x afterRenderRawModule mod_finder () (65.58KB) (3.39%)
    5.84ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (199.65KB) (2.56%)
    4.42ms
    1 x afterDispatch (13.07KB) (1.84%)
    3.18ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (1.57%)
    2.70ms
    1 x After Access::preloadComponents (all components) (97.34KB) (1.09%)
    1.87ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1%)
    1.72ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.97%)
    1.67ms
    1 x afterLoad (456.41KB) (0.95%)
    1.64ms
    1 x afterRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (16.2KB) (0.72%)
    1.24ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.27%)
    471μs
    1 x beforeRenderComponent com_content (28.67KB) (0.12%)
    212μs
    1 x Before Access::preloadComponents (all components) (33.22KB) (0.11%)
    186μs
    1 x beforeRenderRawModule mod_custom () (12.13KB) (0.1%)
    171μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (14.46KB) (0.09%)
    149μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.07%)
    129μs
    1 x afterRenderRawModule mod_custom () (944B) (0.07%)
    123μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.05%)
    94μs
    1 x afterRenderRawModule mod_custom () (896B) (0.05%)
    88μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.05%)
    86μs
    1 x Before Access::getAssetRules (id:897 name:com_content.article.466) (130.65KB) (0.05%)
    84μs
    1 x afterRenderModule mod_custom (Are you getting enough vitamins and minerals?) (1.98KB) (0.04%)
    69μs
    1 x afterRenderModule mod_menu (Main Menu - English) (5.23KB) (0.03%)
    56μs
    1 x afterRenderModule mod_custom () (2.48KB) (0.03%)
    51μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.03%)
    50μs
    1 x After Access::getAssetRules (id:897 name:com_content.article.466) (7.38KB) (0.03%)
    50μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.03%)
    45μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.03%)
    44μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.02%)
    31μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    25μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    22μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    21μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    17μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0.01%)
    16μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    15μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0.01%)
    9μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
41 statements were executed, 9 of which were duplicates, 32 unique47.09ms858.18KB
  • SELECT @@SESSION.sql_mode;540μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?84μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 152μ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)2.26ms944BParams/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` = 1178μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`59μ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` = :guest300μ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`615μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC138μ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` = 1361μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config379μ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.31ms165.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.47ms3.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` = 12.57ms848B/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)332μ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.83ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`549μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '466'924μ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.39ms22.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`336μs4KBParams/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)5.22ms4.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`2.43ms4KBParams/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 ASC587μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id809μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id62μ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` END366μs2.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`344μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 196μ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` = 0457μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.98ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.99ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-12 08:36:08') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-12 08:36:08') AND c2.state = 11.28ms1.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`6.64ms199.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` = :id129μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1176μ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)144μ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 ASC1.22ms4.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)128μ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` = 1305μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?89μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?960μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy