Skip to main content

Unhealthy diet habits cause the majority of deaths

- and people are misguided

Unhealthy diet habits cause the majority of deathsUnhealthy eating habits account for one in five deaths globally and are now considered the single most life-threatening risk factor. In most countries, people could reap a lot of health benefits and live longer by eating healthier diets, but it would be wrong to hold each individual responsible because there is an urgent need for international collaboration that involves politicians, agriculture, the food industry, and the health sector, according to a new study (The Global Burden of Disease) that is published in The Lancet. An earlier and larger Czech study published in the science journal Nutrients calls for a paradigm shift with regard to diet recommendations, claiming that the scaremongering about saturated fat and cholesterol should never have been introduced.

The new diet study, The Global Burden of Disease, includes 195 countries and covers the period between 1990 and 2017. According to this study, every fifth death is related to unhealthy diets and accompanying diseases such as cancer, type 2 diabetes, and cardiovascular disease.
With regard to international diet recommendations, experts have been particularly focused on telling people to avoid eating too much sugar, salt, cholesterol, and trans-fatty acids. Now, they tell us to make sure to eat more of the nutritious foods like fish, whole-grain, vegetables, fruit, and nuts. But because unhealthy food choices and sweetened beverages are available everywhere, and because it can be difficult to read and understand food labels, scientists call for international collaboration that involves politicians, agriculture, the food industry, and the health sector. Otherwise, we will never see an end to the unhealthy diets and the increasing food addiction that is associated with that much disease and death that one can easily refer to it as a global epidemic that is completely out of control.

Unhealthy diets and food addiction combined cause more deaths than alcohol abuse, smoking, and car accidents

Global variations

The scientists behind the study looked closer at the 15 most common food items in the 195 countries included. What they did, more specifically, was to combine and analyze data from a number of epidemiological studies to find the relation between diet and disease. The researchers looked at diets with low intake of whole grain, fish, vegetables, fruit, legumes, seeds, kernels, fiber and dairy products and diets with high intake of red meat, processed meat, soft drinks, sweetened beverages, trans-fatty acid, and salt.
At the end of the study in 2017, the scientists could see that none of the chosen countries had optimal diets, and that every fifth death (approximately 11 million lives) was a result of unhealthy eating habits. They say that too much salt, too little wholegrain, and too little fruit and vegetables caused half of the diet-related deaths.
The study revealed a tenfold difference between the country with the highest number of diet-related deaths and the country with the fewest. Countries like Israel, France, Spain, Japan, and Andorra had the lowest number of diet-related deaths, while places like Uzbekistan, Afghanistan, Papua New Guinea, China, and India had the most. Great Britain came in as number 23 on the list. Sweden was number 25, and the United States was number 43 right after Rwanda and Nigeria.

Statistical uncertainty

The researchers explain that there is a lot of different data that increases the statistical uncertainty. For instance, populations eat different diets depending on the climate, vegetation, and animal life. A large part of the world’s population does not consume dairy products due to lactose intolerance, and people get along fine without these foods. So the Japanese can expect to live a long time by eating traditional diets with a lot of fish and vegetables. People from Iceland also belong to the populations that can expect to live long, although their traditional diet has very little fruit and vegetables in it. On the other hand, they consume quite a lot of fish.
The study also looks at the intake of salt, which is a specific risk factor in China, Japan, and Thailand. Other studies, however, suggest that salt is not harmful. What makes it dangerous, the studies say, is if your daily sodium consumption exceeds five grams and you also get too little potassium, which helps regulate the electrolyte balance.
The agricultural soil also matters. The soil in Europe, for instance, contains very little selenium, and American grain contains far more selenium than Danish grain does. Selenium is a trace element with a host of essential functions, and through decades, Danish farmers have given supplements of selenium to their livestock as a way of preventing an array of serious deficiency diseases.
The sun, which is our primary source of vitamin D, is also vital for our health. In the Northern hemisphere, however, it is only possible to synthesize vitamin D in our skin during the summer period where the sun sits sufficiently high in the sky, so people easily become deficient of vitamin D in this part of the world.

Official dietary guidelines do not work as expected

The many diet-related diseases like cancer, type 2 diabetes, and cardiovascular diseases indicate that the existing dietary guidelines are not working quite as expected. Therefore, science calls for new strategies to improve diets all over the world.
In January 2019, The Lancet published a report about the first scientific goal for healthy diets and sustainable food production. The report involves data from the before-mentioned study (The Global Burden of Disease) to make an assessment of how far away the world’s populations are from the optimal diet. The authors behind the diet study acknowledge, however, that it has certain limitations, simply because factors such as overweight, smoking, stress, medicine, and environmental toxins can also cause health problems.
In addition, it is a huge challenge to try to change people’s diets because of factors like feelings, habits, and financial status. Therefore, politicians, the agriculture and food industry, and the health sector should all be included to help make it easier and less expensive to eat a healthy diet and to avoid being tempted by unnecessary ads for the wrong food choices. The scientists say that it is an international problem that must be solved across country borders, but as long as scientists are unable to agree on the exact definition of a healthy diet, there is a challenge.

High carbohydrate intake and lack of omega-3 increases your risk of cardiovascular disease

In in earlier and far more comprehensive study, a team of Czech scientists studied which global diet factors contribute the most to deaths and cardiovascular disease. The scientists collected diet data from 158 countries during the years 1993-2011. The data included consumption of 60 different food items such as grain products, meat, fish, eggs, dairy products, fruit and vegetables, different plant oils, soft drinks, sugar, alcohol, tea, and coffee. They also calculated the total calorie intake from carbohydrate, protein and fats from animal and vegetable sources.
It turned out that the single diet factor that came with the highest risk of developing cardiovascular disease was high intake of carbohydrates, primarily in the form of sugar and grain products such as wheat. In contrast, the scientists observed that total intake of animal fat, animal protein, and vegetable protein was associated with a lowered risk of developing cardiovascular disease. In other words, the more protein and animal fat is in your diet, the lower your risk of developing cardiovascular disease and dying of blood clots caused by atherosclerosis.
Having said that, there is a limit to how much protein we should ingest. The scientists did also discover that too much omega-6 from plant oils in combination with too little omega-3 from oily fish increased the risk of elevated blood pressure and other cardiovascular diseases.
The Czech study is published in the science journal Nutrients, and in the beginning the researchers write about how the widespread warnings against cholesterol are based on unsustainable data.

A request for the health authorities

As the Czech scientists see it, the warnings about saturated fat and cholesterol should never have been introduced, and they say that we need a paradigm shift with regard to diet recommendations and the underlying causes of cardiovascular disease.

References

The Lancet. Globally, on in five deaths are associated with poor diet. ScienceDaily, April 3, 2019

Andrew Mente et al. Urinary sodium excretion, blood pressure, cardiovascular disease, and mortality: a community-level prospective epidemiological cohort study. The Lancet, 2018

Grasgruber P, Cacek J Hrazdira E et al. Global correlates of cardiovascular risk: a comparison of 158 countries. Nutrients 2018 Mar 26

Gerad D. Jones. Selenium deficiency risk predicted to increase under future climate change. PNAS 2017

D-vitamin behov og mangel I Danmark 2009. Biokemisk forening.

https://www.globalis.dk/Statistik/Levealder

  • Created on .
8.892MBMemory Usage762msRequest 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
array:1 [ "8c48c4b25e7bfaf1e1e1af15958abb70" => "tc94tua7k0qeltrrei6kr7pjlp" ]
$_SERVER
array:47 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI"...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1741929174 "last" => 1741929174...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-US" ]
  • afterLoad (456.59KB) (629μs)
  • afterInitialise (1.28MB) (72.32ms)
  • afterRoute (926.49KB) (27.78ms)
  • beforeRenderComponent com_content (23.25KB) (5.64ms)
  • Before Access::preloadComponents (all components) (35.84KB) (358μs)
  • After Access::preloadComponents (all components) (97.34KB) (4.76ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (21μs)
  • After Access::preloadPermissions (com_content) (3.22MB) (30.93ms)
  • Before Access::getAssetRules (id:4394 name:com_content.article.2164) (130.65KB) (122μs)
  • After Access::getAssetRules (id:4394 name:com_content.article.2164) (7.38KB) (62μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (110ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (282μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (5μs)
  • afterRenderModule mod_custom (Search for more information...) (4.95KB) (148μs)
  • afterRenderComponent com_content (60.67KB) (68.43ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.02KB) (11.75ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (40μs)
  • afterDispatch (17.71KB) (7.79ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (506μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (203ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (41μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.27KB) (97.38ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (30μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (50μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (24μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.66KB) (14.58ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (34μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (45μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (12μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (17.52ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (1.07ms)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (23μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (41μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (14μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (25μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (20μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (20μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (11μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (10μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (20μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (1.88ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (2.93ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (8μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (74μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (24μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (13.87ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (24μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (13μs)
  • afterRenderRawModule mod_finder () (214.53KB) (20.52ms)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (3.29KB) (41μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (157μs)
  • afterRenderRawModule mod_custom () (21.95KB) (7.77ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.23KB) (65μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (135μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (778μs)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (51μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (10.33ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (8μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (53μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (17μs)
  • afterRenderRawModule mod_finder () (6.29KB) (6.22ms)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (1.23KB) (65μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (215μs)
  • afterRenderRawModule mod_custom () (944B) (171μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (27μs)
  • beforeRenderRawModule mod_custom () (688B) (5.47ms)
  • afterRenderRawModule mod_custom () (896B) (194μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.71KB) (38μs)
  • afterRender (169.81KB) (14.88ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (26.61%)
    202.78ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (14.43%)
    109.94ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.27KB) (12.78%)
    97.38ms
    1 x afterInitialise (1.28MB) (9.49%)
    72.32ms
    1 x afterRenderComponent com_content (60.67KB) (8.98%)
    68.43ms
    1 x After Access::preloadPermissions (com_content) (3.22MB) (4.06%)
    30.93ms
    1 x afterRoute (926.49KB) (3.65%)
    27.78ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (2.69%)
    20.52ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (2.3%)
    17.52ms
    1 x afterRender (169.81KB) (1.95%)
    14.88ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.66KB) (1.91%)
    14.58ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.18KB) (1.82%)
    13.87ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.02KB) (1.54%)
    11.75ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.36%)
    10.33ms
    1 x afterDispatch (17.71KB) (1.02%)
    7.79ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (1.02%)
    7.77ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.82%)
    6.22ms
    1 x beforeRenderComponent com_content (23.25KB) (0.74%)
    5.64ms
    1 x beforeRenderRawModule mod_custom () (688B) (0.72%)
    5.47ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.62%)
    4.76ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.38%)
    2.93ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.25%)
    1.88ms
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.14%)
    1.07ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.1%)
    778μs
    1 x afterLoad (456.59KB) (0.08%)
    629μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.07%)
    506μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.05%)
    358μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.04%)
    282μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    215μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    194μs
    1 x afterRenderRawModule mod_custom () (944B) (0.02%)
    171μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.02%)
    157μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.95KB) (0.02%)
    148μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    135μs
    1 x Before Access::getAssetRules (id:4394 name:com_content.article.2164) (130.65KB) (0.02%)
    122μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    74μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    65μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    65μs
    1 x After Access::getAssetRules (id:4394 name:com_content.article.2164) (7.38KB) (0.01%)
    62μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    53μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    51μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    50μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    41μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    41μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    41μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    40μs
    1 x afterRenderModule mod_custom () (2.71KB) (0.01%)
    38μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0%)
    34μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0%)
    30μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    27μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    25μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    24μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    24μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    23μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    22μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    21μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    20μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    18μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    17μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    16μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    14μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    12μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    10μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
45 statements were executed, 9 of which were duplicates, 36 unique440ms1.33MB
  • SELECT @@SESSION.sql_mode;79μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?126μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 183μs1.31KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `has_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id3.57ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `has_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 13.04ms1.56KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`123μ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` = :guest2.53ms1.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`698μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC3.76ms2.33KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `has_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 11.84ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config774μ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`6.44ms165.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`314μ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` = 1290μ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)2.22ms7.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` = 012.71ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`5.26ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2164'6.21ms48B/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)3.64ms22.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`404μ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)11.25ms4.08KBParams/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`3.35ms3.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 ASC1.04ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id132μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id69μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `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`12.85ms180.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 DESC46.24ms161.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`430μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.87ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0414μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id211μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id82μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-03-14 05:13:01') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-14 05:13:01') AND c2.state = 1719μs3.97KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.title ASC LIMIT 10195ms195.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `tag_date` > DATE_ADD('2025-03-14 05:13:01', INTERVAL -1 YEAR) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray5,:preparedArray6) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 1090.99ms2.66KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray6,:preparedArray7) ORDER BY a.created ASC LIMIT 108.68ms159.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`454μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id643μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 13.23ms640B/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)1.77ms584B/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.2ms4.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)587μ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` = 1544μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?148μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?4.24ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy