Skip to main content

the Vitamin and Mineral Guide

the Vitamin and Mineral Guide

What are vitamins and minerals

What are vitamins and mineralsWhy do we need supplements in some situations?

We humans depend on an array of different nutrients in order to thrive and be able to prevent various diseases. However, even with a healthy and balanced diet there may be circumstances that call for the use of supplements:

  • Depleted soil typically lacks minerals and trace elements
  • The process of refining, boiling, frying, and exposing food to other types of thorough preparation reduces its content of many different nutrients
  • In our part of the world, we are unable to synthesise vitamin D from sunlight during the winter period 
  • Environmental pollution, stimulant abuse, and the use of medicine challenges the body's immune defence and cleansing organs
  • Stress, pregnancy, lactation, age, disease, and high-performance sports activities often increase the need for a number of different nutrients

Continue reading

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.

Continue reading

B vitamins in general

B vitamins in generalB vitamins are water-soluble and because they do not get stored in the body, we humans depend on regular intake of them. B vitamins work in synergy in a highly complicated teamwork setup. They take part in most of the body's enzymatic processes, some more actively than others. The uptake of B vitamins depends on gastric acid and digestion.

Continue reading

Vitamin B1 (thiamine)

Vitamin B1 (thiamine) Vitamin B1 is water-soluble and because it does not get stored in the body we depend on regular intake of the nutrient. In the 1920s, the Japanese scientist Umetaro Suzuki discovered vitamin B1 in rice shells and observed that this nutrient counteracted the classic deficiency symptom beriberi. Vitamin B1 is destroyed by alkaline substances and heating but not by freezing

Continue reading

Vitamin B2 (riboflavin)

Vitamin B2 (riboflavin)Vitamin B2 is water-soluble and because it does not get stored in the body we depend on regular intake of the nutrient. Vitamin B2 is also known as lactoflavin and is used as a yellow colouring agent/additive in various foods. When ingested in very large quantities vitamin B2 causes the urine to turn highly yellow. Vitamin B2 is destroyed by light, heating, and alcohol.

Continue reading

Vitamin B3 (niacin)

Vitamin B3 (niacin)Vitamin B3 is water-soluble and because it does not get stored in the body we depend on regular intake of the nutrient. Niacin is a common term for nicotinic acid and nicotinamide. The body's metabolism is able to synthesise part of its required niacin from vitamin B6 and tryptophan, an amino acid which is primarily found in meat. Vitamin B3 is destroyed by heating.

Continue reading

Vitamin B5 (pantothenic acid)

Pantothenic acid originates from the Greek word pantos, which means everywhere. As the word suggests, this vitamins is found in both plants and animals. Vitamin B5 is water-soluble and because it does not get stored in the body we depend on regular intake of the nutrient. Vitamin B5 is destroyed by heating and freezing.

Continue reading

Vitamin B6 (pyridoxine)

Vitamin B6 (pyridoxine)Vitamin B6, also known as pyridoxine, is converted to the active forms, pyridoxal phosphate and pyridoxamine phosphate. Vitamin B6 is water-soluble and because it does not get stored in the body we depend on regular intake of the nutrient. Vitamin B6 is destroyed by heating and light.

Continue reading

Biotin (Vitamin B7, vitamin B8, vitamin H)

There are various forms of biotin and they all belong to the family of B vitamins. Biotin is synthesised from bacteria (including gut bacteria) and mold and yeast fungus, algae, and certain plants. Biotin is water-soluble and because it does not get stored in the body we depend on regular intake/production of the nutrient. Biotin is removed when boiled in water.

Continue reading

More Articles …

J! InfoRequestSessionProfileQueries34
9.006MBMemory Usage399msRequest 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
array:6 [ "option" => "com_content" "view" => "category" "layout" => "blog" "id" => "54" "...
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:41 [ "HTTP_AUTHORIZATION" => "" "HTTPS" => "on" "SSL_TLS_SNI" => "healthandscience.eu" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1752134158 "last" => 1752134158...
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 (455.8KB) (5.63ms)
  • afterInitialise (1.27MB) (64.04ms)
  • afterRoute (827.11KB) (20.18ms)
  • beforeRenderComponent com_content (35.34KB) (277μs)
  • Before Access::preloadComponents (all components) (67.27KB) (7.6ms)
  • After Access::preloadComponents (all components) (98.07KB) (1.74ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (12μs)
  • After Access::preloadPermissions (com_content) (3.29MB) (48.21ms)
  • Before Access::getAssetRules (id:895 name:com_content.category.54) (130.65KB) (140μs)
  • After Access::getAssetRules (id:895 name:com_content.category.54) (7.38KB) (68μs)
  • Before Access::getAssetRules (id:8 name:com_content) (57KB) (6.35ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (36μs)
  • afterRenderComponent com_content (1.32MB) (98.18ms)
  • afterDispatch (39.5KB) (22.9ms)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (342.59KB) (25.05ms)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (4.54KB) (182μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (736B) (4μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.89KB) (43μs)
  • beforeRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (3.42KB) (544μs)
  • afterRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (944B) (35μs)
  • beforeRenderRawModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (768B) (11μs)
  • afterRenderRawModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (960B) (7.92ms)
  • beforeRenderModule mod_custom (Are you getting enough vitamins and minerals?) (258.93KB) (10.03ms)
  • afterRenderModule mod_custom (Are you getting enough vitamins and minerals?) (1.28KB) (44μs)
  • beforeRenderModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (384B) (12μs)
  • afterRenderModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (1.31KB) (8.06ms)
  • beforeRenderRawModule mod_menu (Main Menu - English) (27.66KB) (314μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.64KB) (9.4ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (7.26ms)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (21μs)
  • afterRenderRawModule mod_languages (Sprogskift) (18.7KB) (1.6ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (6.56KB) (19μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (9μs)
  • afterRenderRawModule mod_finder () (58.23KB) (23.96ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (132μs)
  • afterRenderRawModule mod_custom () (26.52KB) (7.48ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (1.23KB) (48μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (100μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.3KB) (2.5ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (49μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (32μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.76ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (11μs)
  • afterRenderRawModule mod_finder () (6.29KB) (769μs)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.23KB) (46μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (167μs)
  • afterRenderRawModule mod_custom () (904B) (129μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (23μs)
  • beforeRenderRawModule mod_custom () (688B) (1.77ms)
  • afterRenderRawModule mod_custom () (896B) (417μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.71KB) (29μs)
  • afterRender (256.13KB) (11.33ms)
  • 1 x afterRenderComponent com_content (1.32MB) (24.63%)
    98.18ms
    1 x afterInitialise (1.27MB) (16.07%)
    64.04ms
    1 x After Access::preloadPermissions (com_content) (3.29MB) (12.1%)
    48.21ms
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (342.59KB) (6.29%)
    25.05ms
    1 x afterRenderRawModule mod_finder () (58.23KB) (6.01%)
    23.96ms
    1 x afterDispatch (39.5KB) (5.74%)
    22.90ms
    1 x afterRoute (827.11KB) (5.06%)
    20.18ms
    1 x afterRender (256.13KB) (2.84%)
    11.33ms
    1 x beforeRenderModule mod_custom (Are you getting enough vitamins and minerals?) (258.93KB) (2.52%)
    10.03ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.64KB) (2.36%)
    9.40ms
    1 x afterRenderModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (1.31KB) (2.02%)
    8.06ms
    1 x afterRenderRawModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (960B) (1.99%)
    7.92ms
    1 x Before Access::preloadComponents (all components) (67.27KB) (1.91%)
    7.60ms
    1 x afterRenderRawModule mod_custom () (26.52KB) (1.88%)
    7.48ms
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (1.82%)
    7.26ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (57KB) (1.59%)
    6.35ms
    1 x afterLoad (455.8KB) (1.41%)
    5.63ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.69%)
    2.76ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.3KB) (0.63%)
    2.50ms
    1 x beforeRenderRawModule mod_custom () (688B) (0.44%)
    1.77ms
    1 x After Access::preloadComponents (all components) (98.07KB) (0.44%)
    1.74ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (18.7KB) (0.4%)
    1.60ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.19%)
    769μs
    1 x beforeRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (3.42KB) (0.14%)
    544μs
    1 x afterRenderRawModule mod_custom () (896B) (0.1%)
    417μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (27.66KB) (0.08%)
    314μs
    1 x beforeRenderComponent com_content (35.34KB) (0.07%)
    277μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (4.54KB) (0.05%)
    182μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    167μs
    1 x Before Access::getAssetRules (id:895 name:com_content.category.54) (130.65KB) (0.04%)
    140μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    132μs
    1 x afterRenderRawModule mod_custom () (904B) (0.03%)
    129μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.03%)
    100μs
    1 x After Access::getAssetRules (id:895 name:com_content.category.54) (7.38KB) (0.02%)
    68μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    49μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    48μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    46μs
    1 x afterRenderModule mod_custom (Are you getting enough vitamins and minerals?) (1.28KB) (0.01%)
    44μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.89KB) (0.01%)
    43μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    36μs
    1 x afterRenderRawModule mod_custom (Are you getting enough vitamins and minerals?) (944B) (0.01%)
    35μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    34μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    32μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    29μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0.01%)
    21μs
    1 x afterRenderModule mod_languages (Sprogskift) (6.56KB) (0%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (384B) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (Overview of vitamins, minerals, and essential fatty acids) (768B) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (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%)
    9μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    4μs
34 statements were executed, 4 of which were duplicates, 30 unique85.43ms999.91KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;42μ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)1.04ms944BParams/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` = 12.34ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`71μ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` = :guest160μ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`1.38ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC146μ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` = 1136μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config435μ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`4.99ms165.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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.59ms848B/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)443μ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` = 013.27ms417.48KBParams/libraries/src/Access/Access.php:301Copy
  • 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`,( SELECT COUNT(`i`.`id`) FROM `has_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1 AND `i`.`language` IN (:preparedArray3,:preparedArray4)) AS `numitems` 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`489μs4.03KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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` = :categoryId 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 CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END , a.created LIMIT 133.56ms152.5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT 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` = :categoryId 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)410μs6.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199Copy
  • 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.12ms4.03KBParams/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`4.9ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id LEFT JOIN `has_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC1.35ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.95ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`370μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 03.98ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • 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` = :id4.97ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `has_categories` 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_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension31.97ms1.42KBParams/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`10.84ms196.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 13.92ms640B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)2.09ms584B/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 ASC4.08ms4.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)153μ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` = 1171μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?1.98ms3.5KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?5.94ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy