Skip to main content

COVID-19, sense of smell, and zinc

COVID-19, sense of smell, and zincCOVID-19, sense of smell, and zincIf you lose your sense of smell all of a sudden, it is most likely a sign that you have been infected with the coronavirus, according two large, international studies published in the science journal Chemical Senses. Many COVID-19 patients also lose their sense of taste and even if there are no other complications, it can affect their quality of life. The big question is if there is a link between zinc deficiency, corona infection, and these symptoms. It is already an established fact that zinc is important for our immune defense, for our sense of taste and smell, and as an antioxidant that protects our cells. Also, it is known that zinc deficiencies are rather common and people with unhealthy eating habits, vegetarians, vegans, older people, and diabetics are at increased risk. Birth control pills and certain types of medicine also increase the risk of lacking zinc.

There can be different reasons why you lose your sense of smell, but it has been known for some time that the loss of this sense often follows in the wake of a COVID-19 infection. Two large, international studies published in Chemical Senses confirm that there is a very big chance that the sudden loss of your sense of smell can be caused by a coronavirus infection. According to associate professor Dr. Alexander Wieck Fjældstad, from the Department of Clinical Medicine at Aarhus University, who headed the Danish arm of the study, you should think of yourself as being infected until proven otherwise. In other words, if you have lost your sense of smell and are unable to get a COVID-19 test immediately to find out if you have COVID-19, you should isolate.
As it turns out, a lot of people infected with COVID-19 do not just suffer a mildly reduced sense of smell but lose it, altogether. In most cases, their sense of smell returns after around 40 days or so. Furthermore, many COVID-19 patients lose their sense of taste and their sense of touch in the mouth. This destroys their ability to enjoy food and life in general. Also, they risk eating food that has spoiled because they are unable to taste or smell it.
It is commonly known that COVID-19 infections cause people to cough and have breathing difficulty. Still, many corona patients just experience taste and smell disturbances. It is therefore important for these people to get tested so they do not pass on the infection to others.

Why does COVID-19 affect your sense of smell and taste?

Our olfactory system (sense of smell) that features around 40 million olfactory cells is located in the upper part of the nasal cavity. The mucous traps fragrances that are registered by the olfactory cells. From here, information is passed on to the brain. That is why our sense of smell, mood, and memory are closely connected. Olfactory cells have a lifespan of around 6-8 weeks. When the die, they are replaced by new cells. Therefore, our sense of smell is restored if our mucosae are damaged.
It is rather common to lose your sense of smell if you have an upper respiratory infection, including colds and flus that are caused by different types of coronavirus. For that reason, it is believed that the link between a COVID-19 infection and losing your sense of smell or taste is rooted in the mucosae, not in the brain. Previous studies have shown that COVID-19 gains access to the host cells by binding to ACE2 receptors. ACE2 (angiotensin-converting enzyme) is found in the membranes of cells in e.g. the respiratory system.
A COVID-19 infection generally begins with virus infecting cells in the nose by way of the ACE2 receptors. A well-functioning immune system is able to destroy the virus before it can replicate and spread. However, it the immune system does not function optimally, COVID-19 replicates in the nasal cells and spreads to surrounding cells through the ACE2 receptors in the airways, arteries, heart, small intestine, and kidneys.
The presence of virus in the respiratory tract can therefore make you lose your sense of smell and taste. Also, sensory cells may be damaged by exaggerated immune reactions, including inflammation.

Zinc’s role in the immune defense and the sensory system

All cells in the body depend on zinc, a nutrient that is involved in well over 300 different enzyme processes. Zinc is important for our sense of taste and smell and it is commonly known that lack of zinc can impair these senses. Zinc also helps stabilize cell membranes against virus attacks. As soon as you can an infection, the zinc levels in your blood drop because both your innate and adaptive immune defense use the nutrient to carry out swift and targeted attacks.
The immune defense also mobilizes cascades of free radicals as part of these attacks. It is vital to prevent these free radicals from causing oxidative stress, which is an imbalance between harmful free radicals and protective antioxidants. Zinc is a constituent of a powerful antioxidant called SOD (superoxide dismutase) that counteracts cell damage caused by free radicals and oxidative stress.
Zinc-containing proteins also code for around 10 percent of our genes and that is essential in order to enable the cells in the immune defense and other tissues to carry out their tasks correctly.
A zinc deficiency therefore results in weak cell membranes and a malfunctioning immune defense that makes us more susceptible to infection, unwanted inflammation, and local damage to cells and tissue.
Earlier studies have shown that zinc deficiency is quite widespread among COVID-19 patients and that increases the risk of spreading the infection. Although more research is needed, it is possible that having too little zinc can increase the risk of losing your sense of smell and taste in connection with COVID-19 because the cells become more vulnerable to virus attacks and because the immune defense consumes large amounts of zinc, thereby leaving too little zinc for other functions that depend on the nutrient.

  • Clinical zinc deficiency is very common among people with type 2 diabetes and kidney diseases
  • There is also a very large grey zone of people with sub-clinical zinc deficiency

Zinc supplements are useful against infections with different types of coronavirus

Cold infections are often caused by different types of coronavirus. A Finnish meta-analysis has shown that taking large doses of zinc for a short period of time can shorten the duration of a cold. Several studies suggest that it is best if you start taking zinc supplements soon after contracting an acute respiratory infection. This may also be the case with COVID-19.

Why are zinc deficiencies so common?

There is a lot of zinc in oysters and shellfish, fish, dairy products, nuts, kernels, and beans. Animal sources of zinc have better absorption in the body. Although clinical zinc deficiency is rather rare in our part of the world, subclinical zinc deficiency is widespread and can easily affect your health.
Lack of zinc and poor utilization of the nutrient may be a result of poor eating habits, lack of animal protein, high calcium intake, excessive consumption of alcohol, ageing, celiac disease (gluten intolerance), diarrhea, diabetes, and kidney diseases. The same goes for several kinds of medicine such as diuretics, ACE inhibitors, antacids, corticosteroids, antibiotics, and birth control pills.

Official recommendations and safe upper intake level

  • The reference intake (RI) level (in Denmark) is 10 mg
  • The European Food Safety Authority (EFSA) has established a safe upper intake level of 25 mg/day for adults and pregnant women
  • It is safe to ingest even larger doses from e.g. oysters or supplements for a brief period

Zinc content per 100 grams

Raw oysters 84
Crab claws 18
Meat 3-6
Kernels and seeds 3-5
Cheese 4
Oats 3
White beans 3
Ryebread
and potatoes 1
Spinach and red
Beets 1

Zinc supplements are easier for the body to utilize

It is vital to get enough zinc from dietary sources and to make sure that the zinc you get is absorbed properly. With regard to supplements, pay attention to the fact that many zinc preparations contain inorganic zinc sources like zinc sulphate and zinc oxide, which the body cannot absorb all that well. Look carefully at the label to see what is in the tablets. Zinc gluconate and zinc acetate are both organic zinc sources that the body can easily absorb and utilize.

Important

In the case of acute virus infections like COVID-19 you also need vitamin D, vitamin C and selenium.

References

Anne Sophie Thingsted. Mistet lugtesans er det sikreste symptom på COVID-19. Videnskab.dk 19. januar 2021

Ozlem Equils et al. Proposed mechanism for anosmia during COVID-19: The role of local zinc distribution. Oat. 2020

Nikki Hancocks. Diet and supplements: Swiss panel publishes COVID-19 recommendations. 2020

Luke Maxfield, Jonathan S. Crane. Zinc Deficiency. NCBI March 18, 2019

University of Helsinki. Zink acetate lozenges may increase the recovery rate from the common cold by three-fold. ScienceDaily May 11, 2017

Zink for Colds, Rashes and the Immune system. WebMD. 2017

Frida - Parametre (fooddata.dk)

  • Created on .
8.883MBMemory Usage419msRequest 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" => 1741906912 "last" => 1741906912...
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.38KB) (1.71ms)
  • afterInitialise (1.27MB) (36.12ms)
  • afterRoute (927.02KB) (16.36ms)
  • beforeRenderComponent com_content (23.42KB) (342μs)
  • Before Access::preloadComponents (all components) (35.84KB) (3.38ms)
  • After Access::preloadComponents (all components) (97.34KB) (692μs)
  • Before Access::preloadPermissions (com_content) (1.6KB) (31μs)
  • After Access::preloadPermissions (com_content) (3.22MB) (15.65ms)
  • Before Access::getAssetRules (id:5897 name:com_content.article.2917) (130.65KB) (119μs)
  • After Access::getAssetRules (id:5897 name:com_content.article.2917) (7.38KB) (64μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (52.08ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (237μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (4.7KB) (79μs)
  • afterRenderComponent com_content (56.86KB) (39.35ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.94KB) (7.38ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (27μs)
  • afterDispatch (17.74KB) (832μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (2.47ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (127ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Search) (6.32KB) (68.32ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (24μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (41μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (20μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.64KB) (9.33ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (22μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (34μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (10μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (20μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (3.83ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (45μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (21μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (11μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (18μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (15μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (18μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (8μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (18μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (7μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (18μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (2.4ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (4.2ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (47μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.21KB) (2.22ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (18μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (10μs)
  • afterRenderRawModule mod_finder () (214.53KB) (6.95ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (30μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (122μs)
  • afterRenderRawModule mod_custom () (21.92KB) (4.58ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (44μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (94μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.61ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (2μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (34μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (15μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (570μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (3μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (25μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (8μs)
  • afterRenderRawModule mod_finder () (6.29KB) (2.32ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (41μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (159μs)
  • afterRenderRawModule mod_custom () (944B) (112μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (23μs)
  • beforeRenderRawModule mod_custom () (688B) (70μs)
  • afterRenderRawModule mod_custom () (896B) (83μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (19μs)
  • afterRender (169.78KB) (7.11ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (88.83KB) (30.24%)
    126.65ms
    1 x afterRenderRawModule mod_tags_popular (Search) (6.32KB) (16.31%)
    68.32ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.33MB) (12.43%)
    52.08ms
    1 x afterRenderComponent com_content (56.86KB) (9.4%)
    39.35ms
    1 x afterInitialise (1.27MB) (8.62%)
    36.12ms
    1 x afterRoute (927.02KB) (3.91%)
    16.36ms
    1 x After Access::preloadPermissions (com_content) (3.22MB) (3.74%)
    15.65ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.64KB) (2.23%)
    9.33ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.94KB) (1.76%)
    7.38ms
    1 x afterRender (169.78KB) (1.7%)
    7.11ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (1.66%)
    6.95ms
    1 x afterRenderRawModule mod_custom () (21.92KB) (1.09%)
    4.58ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1%)
    4.20ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (0.92%)
    3.83ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.81%)
    3.38ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.59%)
    2.47ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.57%)
    2.40ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.55%)
    2.32ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.21KB) (0.53%)
    2.22ms
    1 x afterLoad (456.38KB) (0.41%)
    1.71ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.38%)
    1.61ms
    1 x afterDispatch (17.74KB) (0.2%)
    832μs
    1 x After Access::preloadComponents (all components) (97.34KB) (0.17%)
    692μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.14%)
    570μs
    1 x beforeRenderComponent com_content (23.42KB) (0.08%)
    342μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.06%)
    237μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    159μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    122μs
    1 x Before Access::getAssetRules (id:5897 name:com_content.article.2917) (130.65KB) (0.03%)
    119μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    112μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    94μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    83μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.7KB) (0.02%)
    79μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    70μs
    1 x After Access::getAssetRules (id:5897 name:com_content.article.2917) (7.38KB) (0.02%)
    64μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    47μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    45μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    44μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    41μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    41μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    34μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    34μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0.01%)
    31μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    26μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    24μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    23μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    22μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    20μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    20μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    19μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    18μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    17μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    15μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    13μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    10μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    7μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique268ms1.33MB
  • SELECT @@SESSION.sql_mode;173μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?127μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1956μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `has_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.96ms944BParams/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` = 1353μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`103μ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` = :guest172μ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.29ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC209μ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` = 1488μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config1.18ms1.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`856μs165.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.23ms3.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` = 1195μ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)405μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 05.33ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`663μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2917'3.51ms48B/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)543μs22.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`308μ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)4.68ms4.05KBParams/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`347μ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 ASC1.03ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id101μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id60μ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`4.68ms180.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 DESC33.03ms161.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`274μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 199μs536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 01.87ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id76μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id50μ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-13 23:01:52') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-13 23:01:52') AND c2.state = 1324μ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 10123ms195.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-13 23:01:52', 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 1064.54ms2.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 10615μs159.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`2.3ms3.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` = :id842μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 12.51ms640B/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)120μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.22ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)117μ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` = 1971μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?93μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.56ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy