Skip to main content

Vitamin B6 supports many functions

- but is heavily overrated in energy beverages and breakfast cereals

Vitamin B6 supports many functions Vitamin B6 is essential for the energy turnover, nervous system, hormone balance, and a number of other important functions. Vitamin B6 has been added to many energy beverages and breakfast cereals as an “energy booster” or a way of telling consumers that the product is healthy. But don’t be fooled. The same products often contain loads of sugar and caffeine, which burdens the blood sugar balance and the nervous system. It is therefore far better to get vitamin B6 by eating a balanced and healthy diet, possibly topped off with a supplement if necessary. Those who are likely to benefit from a supplement are strict vegetarians and vegans, pregnant and breastfeeding women, and seniors.

The consumption of energy beverages is ever increasing, especially among younger people. Red Bull is the top-selling product of all. Vitamin B6 has been added to many energy beverages. A single 250 ml can of Red Bull contains 5.6 mg of the nutrient, which is four times more than the daily reference intake (RI) level of 1.4 mg. Vitamin B6 and other B vitamins are marketed as being very important for the body’s energy turnover, but the actual energy boost comes from the massive amounts of sugar and caffeine that affect the blood sugar balance and the nervous system. When blood sugar plummet afterwards, it is followed by a drastic reduction of the energy levels, which vitamin B6 is unable to compensate for. Then comes the sudden need for quick “energy fix”, and before you know it you are in the middle of a vicious cycle.
Breakfast cereals such as Frosties also contain loads of sugar. In order to cover this up and make the product look healthy, vitamin B6 and a few other vitamins and minerals have been added. That does not change the fact that the product is unhealthy, low in fiber and high in sugar, and it puts a massive strain on the blood sugar balance, thereby leeching the body’s stores of chromium and other nutrients.
Most people are normally able to get sufficient amounts of vitamin B6 by eating a healthy and balanced diet. Let’s take a look at this nutrient, what sources we get it from, its functions in the body, and who may benefit from taking a supplement.

Did you know that a single can of Red Bull contains around 14 sugar cubes and the same amount of caffeine as a cup of coffee? Also, did you know that a package of Frosties contains the same amount of sugar as you get from 87 sugar cubes?

Vitamin B6 has many essential functions

Vitamin B6 is also called pyridoxine and is converted to its active forms (pyridoxal phosphate and pyridoxamine phosphate). Vitamin B6 was isolated in 1930 for the very first time. The nutrient is water-soluble and does not get stored in the body, which means we depend on a regular intake of this vitamin. Vitamin B6 supports over 100 different enzyme processes, which are primarily related to the body’s energy turnover. Vitamin B6 is also important for cognitive functions via the biosynthesis of neurotransmitters. Vitamin B6 is destroyed by heat and exposure to light.

Vitamin B6 is important for

  • The energy turnover – especially protein and glycogen (sugar stored in the liver and muscles)
  • Blood levels of the amino acid homocysteine
  • The nervous system and the mental balance
  • The immune system
  • The hormone system
  • Utilization of magnesium

Reference intake and primary sources

The official reference intake (RI) level for vitamin B6 in Denmark is 1.4 mg for children aged 11 years and older and for adults. In the United States, the Recommended Daily Allowance (RDA) is slightly lower, whereas it is a little higher for pregnant (1.9 mg) and breastfeeding (2 mg) women. People older than 51 years of age are also advised to consume more vitamin B6, yet this is not the case in Denmark. Anyone who eats a balanced diet with liver, meat, fish, eggs, legumes and other good sources should be able to get enough vitamin B6. It is also important to prepare the food carefully, as large amounts of the nutrient are lost when you cook, bake or heat your food. It can be a challenge for strict vegetarians and vegans to get enough vitamin B6 from their diets.

Content of vitamin B6 (pyridoxine) in mg per 100 gram of food

  • Wheat bran 1.38
  • Garlic 1.24
  • Cold smoked salmon and raw beef liver 1.0
  • Chicken, raw 0.8
  • Egg yolk 0.5
  • Cabbage, avocado, broccoli, red bell pepper, banana, sunflower seeds 0.3
  • Cheese and rye bread 0.2
  • Apple 0.05

Does vitamin B6 really give you energy?

As told, vitamin B6 is added to many energy beverages, breakfast cereals, and other products, and the nutrient is also found in food supplements. It is allowed to make health claims that are approved by the European Food Safety Authority (EFSA). However, it is often heavily overrated and misleading when manufacturers claim that various B vitamins, including vitamin B6, contribute to normal energy-yielding metabolism. The energy-providing substances are calories such as carbohydrates, fats, and protein, and the process of metabolizing these into energy requires not only B vitamins but a host of different nutrients such as iron, chromium, selenium, and coenzyme Q10. Each and every one of these nutrients helps oxygen and calories into the cells, where a myriad of enzyme processes take place before calories can be converted into ATP, the molecule that stores energy in its chemical form.
It therefore does not make much sense so focus on vitamin B6 alone, although it is trendy to add this nutrient to all kinds of foods that are stripped of nutrients. If you really lack energy, you are better off eating a balanced diet and perhaps taking a vitamin B6 supplement.

Do you lack vitamin B6?

There are certain factors that may increase your need for vitamin B6 such as pregnancy, stress, birth control pills, and alcohol abuse. The same goes for antibiotics, chemotherapy, and the use of hydralazine (anti-hypertensive drug) and anti-epileptic drugs. A vitamin B6-deficiency increases the risk of

  • fatigue
  • mouth ulcers and glossitis (tongue inflammation)
  • confusion and depression
  • monocytic anemia
  • compromised immune defense
  • convulsions as seen with seizures
  • various symptoms caused by poor utilization of magnesium
  • digestive problems (children)

Did you know that magnesium is important for your bones, nervous system, and blood sugar balance – and that vitamin B6 is important for your ability to utilize vitamin magnesium?

Different studies of vitamin B6

Blood sugar

Vitamin B6 controls blood sugar levels and insulin levels in laboratory mice, according to a study published in Diabetes Research (in 2015)

Immune system

Vitamin B6 is involved in the production of white blood cells, which fight infections in the body. A study from Taiwan shows that vitamin B6 supplements help improve the immune system in critically ill patients.

Crohn’s disease and rheumatoid arthritis

Studies show that patients with Crohn’s disease and rheumatoid arthritis, both of which are autoimmune conditions, may be deficient in vitamin B6. This may be a contributing factor to the chronic inflammation that characterizes both ailments.

Brain health

Studies of pregnant and breastfeeding women have shown that maternal vitamin B6 deficiency may have a negative impact on neurotransmitters that are important for the child’s ability to learn and remember. A study from 2012 suggests that being deficient in vitamin B6 and folic acid is associated with depression in old age.

Hip fracture

Large quantities of vitamin B6 (40 mg daily) may lower the risk of sustaining a hip fracture by 42%, according to a study from 2017. The study is published in the Journal of Bone and Mineral Research.

Protects against oxidative stress

Vitamin B6 even functions as an antioxidant that protects against oxidative stress caused by free radicals. Oxidative stress is involved in e.g. atherosclerosis and many other diseases.

Pregnancy

Studies suggest that high doses of vitamin B6 taken orally may counteract nausea and vomiting during pregnancy. Such supplements must be prescribed by a physician or the midwife.

PMS

Vitamin B6 supplementation may reduce PMS and subsequent depression

Diet and supplementation

It is best to cover your need for vitamin B6 by eating a balanced diet. Supplements may be necessary for those, who are deficient. It is normally advisable to take vitamin B6 supplements in conjunction with other B vitamins and not together with antacids. If you take large quantities of vitamin B6, make sure to even them out with several meals, as all B vitamins are water-soluble. Excess vitamin B6 in the bloodstream is easily excreted in the urine.

Overdosing – side effects

Overdosing is rarely seen with vitamin B6, as the nutrient is water-soluble and not stored in the body. In cases where very large doses (10 grams or more) are ingested at once, it may cause reduced coordination of movement and reduced sensation in arms and legs. The same symptoms may also occur after prolonged use of daily doses of 100-200 mg of vitamin B6.

References

Anprisninger af vitaminer og mineraler. Miljø- og Fødevareministeriet.

U.S. Department of agriculture National Nutrient Database, Energy Drink Red Bull 2018.

Vudhivai N el al. Vitamin B1, B2, and B6 status of vegetarians. Europe PMC 1991

Liu Z et al. Vitamin B6 Prevents Endothelial Dysfunction, Insulin Resistance, and Hepatic Lipid Accumulation in Apoe (-/-) mice with High-fat Diet. J. Diabetes Res 2016

Maria Garcia Lopez, B Vitamins and Hip Fracture: Secondary Analyses and Extends Follow-up of Two Large Randomized Controlled Trials. JBMR 2017

Effects of Vitamin B6 (Pyridoxine) and B Complex Preparation on Dreaming and Sleep. Perceptual and Motor Skills 2018

Binqjun Qian et al. Effects of Vitamin B6 Deficiency on the Composition and Functional Potential of T Celle Populations. Journal of Immunology Research 2017

Krishnaswamy, Sushil K Jain. Effect on vitamin B6 on oxygen radicals, mitochondrial membrane potential, and lipid peroxidation in H2O2-trreated U937 monocytes.

Pan WH et al. Co-occurrence of anemia, marginal vitamin B6, and folate status and depressive symptoms in older adults. J Geriatr Psychiatry Neurol 2012

Sahakian V et al. Vitamin B6 is effective therapy for nausea and vomiting of pregnancy: a Randomized, double-blind placebo-controlled study. Obstet Gynecol 1991

Wyat KM et al Efficacy of vitamin B-6 in the treatment of premenstrual syndrome: systematic review. BMJ 1999

https://altomkost.dk/fakta/naeringsindhold-i-maden/vitaminer-og-mineraler/anprisninger-af-vitaminer-og-mineraler/

https://da.wikipedia.org/wiki/Red_Bull

http://energydrink-dk.redbull.com/red-bull-b-vitamin

https://frida.fooddata.dk/ShowList.php?compid=4

  • Created on .
8.872MBMemory Usage273msRequest 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" => 1739351953 "last" => 1739351953...
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.28KB) (483μs)
  • afterInitialise (1.27MB) (19.33ms)
  • afterRoute (897.2KB) (7.1ms)
  • beforeRenderComponent com_content (22.85KB) (731μs)
  • Before Access::preloadComponents (all components) (33.23KB) (1.26ms)
  • After Access::preloadComponents (all components) (97.34KB) (662μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (15μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (9.77ms)
  • Before Access::getAssetRules (id:3690 name:com_content.article.1823) (130.65KB) (96μs)
  • After Access::getAssetRules (id:3690 name:com_content.article.1823) (7.38KB) (53μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.36MB) (30.79ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (162μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (10.95KB) (67μs)
  • afterRenderComponent com_content (70.47KB) (21.27ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.64KB) (1.67ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (27μs)
  • afterDispatch (24.74KB) (1.5ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (391μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (70.06KB) (45.43ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (44μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (48μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (21μs)
  • afterRenderRawModule mod_tags_popular (Search) (46.05KB) (102ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (23μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (41μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (11μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (20μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (4.05ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (60μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (14μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (23μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (11μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (20μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (9μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (19μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (8μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (18μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (1.42ms)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (2.46ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (58μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (20KB) (4.87ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (20μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (128.59KB) (2.49ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (33μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (136μs)
  • afterRenderRawModule mod_custom () (21.92KB) (774μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (49μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (96μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.31ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (4μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (47μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.69ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.98ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.73KB) (47μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (172μs)
  • afterRenderRawModule mod_custom () (944B) (148μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (25μs)
  • beforeRenderRawModule mod_custom () (688B) (76μs)
  • afterRenderRawModule mod_custom () (896B) (88μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (21μs)
  • afterRender (223.26KB) (5.93ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (46.05KB) (37.5%)
    102.24ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (70.06KB) (16.66%)
    45.43ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.36MB) (11.29%)
    30.79ms
    1 x afterRenderComponent com_content (70.47KB) (7.8%)
    21.27ms
    1 x afterInitialise (1.27MB) (7.09%)
    19.33ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (3.58%)
    9.77ms
    1 x afterRoute (897.2KB) (2.6%)
    7.10ms
    1 x afterRender (223.26KB) (2.18%)
    5.93ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (20KB) (1.78%)
    4.87ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.49%)
    4.05ms
    1 x afterRenderRawModule mod_finder () (128.59KB) (0.91%)
    2.49ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (0.9%)
    2.46ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.73%)
    1.98ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.62%)
    1.69ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.64KB) (0.61%)
    1.67ms
    1 x afterDispatch (24.74KB) (0.55%)
    1.50ms
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.52%)
    1.42ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.48%)
    1.31ms
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.46%)
    1.26ms
    1 x afterRenderRawModule mod_custom () (21.92KB) (0.28%)
    774μs
    1 x beforeRenderComponent com_content (22.85KB) (0.27%)
    731μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.24%)
    662μs
    1 x afterLoad (456.28KB) (0.18%)
    483μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.14%)
    391μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.06%)
    172μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.06%)
    162μs
    1 x afterRenderRawModule mod_custom () (944B) (0.05%)
    148μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.05%)
    136μs
    1 x Before Access::getAssetRules (id:3690 name:com_content.article.1823) (130.65KB) (0.04%)
    96μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.04%)
    96μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    88μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.03%)
    76μs
    1 x afterRenderModule mod_custom (Search for more information...) (10.95KB) (0.02%)
    67μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.02%)
    60μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.02%)
    58μs
    1 x After Access::getAssetRules (id:3690 name:com_content.article.1823) (7.38KB) (0.02%)
    53μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.02%)
    49μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.02%)
    48μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.02%)
    47μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.02%)
    47μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.02%)
    44μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.02%)
    41μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    34μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    33μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    27μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.01%)
    23μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0.01%)
    21μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    21μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0.01%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0.01%)
    20μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    20μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0.01%)
    19μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0.01%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    15μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    8μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    8μ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 (Search for more information...) (736B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique184ms1.16MB
  • SELECT @@SESSION.sql_mode;50μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?94μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1796μ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.39ms944BParams/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` = 1174μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`70μ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` = :guest181μ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`501μ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` = 1117μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config182μ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`1ms165.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`224μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `has_template_styles` AS `s` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1171μs848B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)459μ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` = 04.13ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`581μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1823'788μ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)430μs46.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`313μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)2.49ms4.11KBParams/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`921μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id LEFT JOIN `has_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC316μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id120μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id84μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `has_modules` AS `m` LEFT JOIN `has_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `has_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`3.71ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC15.39ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`429μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 189μ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` = 0299μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id167μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id57μ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-02-12 09:19:13') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-12 09:19:13') AND c2.state = 1448μs3.98KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 1040.91ms151.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`609μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray5,:preparedArray6) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 15101ms2.75KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • 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.14ms1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1158μ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)151μ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 ASC283μ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)143μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `has_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.3ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • 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`707μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?107μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?805μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy