Skip to main content

Make sure to get enough vitamin C to prevent and fight infections

Make sure to get enough vitamin C to prevent and fight infectionsNowadays, fruit, potatoes, and vegetables in general contain very little vitamin C, and the majority of people fail to eat the recommended amount of these foods, in the first place. Unhealthy diets and lack of vitamin C increase the risk of colds, influenza, and other infections, simply because the immune system consumes large amounts of vitamin C in connection with the first explosive attacks that prevent virus from causing an infection. Vitamin C also has an important role in battling infections and preventing them from dragging on and leading to complications such as bronchitis or pneumonia.

During the winter period, many people catch a cold or the flu, and there is a lot of focus on vitamin D as a source of prevention. However, we also need vitamin C, as this nutrient has a number of anti-viral properties and helps the immune system fight infections in different ways. Vitamin C is also known as ascorbic acid, and is a nutrient that most mammals are able to produce on their own. It is only humans, anthropoids, and certain other species that have lost this ability as a result of evolution. Because vitamin C is water-soluble, it does not get stored in the body, which is why we need to consume it regularly. In that connection, it is important to bear in mind that our need for the nutrient increases in situations with infections and various types of stress.

Did you know that...

  • the largest concentration of vitamin C is found in the white blood cells?
  • the concentration of vitamin C can increase ten-fold during an infection?
  • vitamin C is destroyed by light, heating, overboiling, deepfreezing, preservation, and winter storage of fruit and vegetables                                                              

The non-specific (innate) immune system should be able to handle most infections without us noticing anything

Vitamin C increases the number and effectivity of the around 500 billion white blood cells that work around the clock throughout the entire body. There are particularly many white blood cells in our airways, and they need vitamin C to protect us against airborne pathogens such as cold germs and influenza virus.
The immune system is divided in two types with different kinds of white blood cells. The innate, non-specific immune system is our “storm troops” that handle most infections without us even noticing it. The non-specific immune system also includes some signaling proteins called cytokines. The most important cytokine is interferon.

Vitamin C and interferon both have central anti-viral properties

Interferons are produced by virus-infected cells. The word interferon is related to “interfere” that means to be or create a hindrance or an obstacle. Interferons work by preventing virus from reproducing inside cells. This is kind of like a factory worker pushing the emergency button to stop the conveyor belt when something goes wrong. Studies of so-called Gulo mice that are unable to produce vitamin C show that vitamin C supplementation has anti-viral effects by stimulating interferon production during the early stages of an infection, especially with influenza. Interferons are also able to attract white blood cells that function as storm troops. That way, the immune defense works from different angles.

Proteins tackle most infections

Vitamin C boosts the production of interferon that has several anti-viral effects. It turns out that 90% of bacteria injected into laboratory animals are killed by proteins from the non-specific (innate) immune defense.

Storm troops fire with free radicals with help from vitamin C

The moment we get an infection, our storm troops of white blood cells swiftly absorb a generous amount of oxygen that is converted into free radicals, which are fired off like lethal missiles to destroy bacteria and other potentially harmful compounds. This process, also known as the “respiratory burst reaction”, is virtually a respiratory explosion.
During these rapid frontal attacks, large quantities of vitamin C are needed to help the white blood cells fire off free radicals against the microbes. Scientists, studying a specific type of white blood cells called neutrophil granulocytes, have found levels of vitamin C to be ten times higher than normal, which says something about the magnitude of the explosive processes and the role of vitamin C.
Vitamin C stimulates the production of free radicals targeted at the intruding microbes. At the same time, vitamin C is a powerful antioxidant that protects the surrounding cells and tissues against the damage caused by the free radicals. At the first signs of an infection, it may be a good idea to take extra supplements of selenium and zinc, as these minerals also contribute to the explosive immune processes and function as antioxidants at the same time.

Free radicals and antioxidants

Free radicals are a byproduct of our own respiration. They increase in number during infections, stress, ageing processes, poisoning, exposure to tobacco smoke, and radiation. Free radicals are aggressive molecules that attack and damage cell membranes and bacteria. The only thing that can protect us against free radicals is various kinds of antioxidants. The diet contributes with the vitamins A, C, and E plus selenium, zinc, and different plant compounds.

Vitamin C can prevent complications

In situations where the non-specific immune system and the storm troops are unable to deal with the problems, the specific immune defense is activated. However, it takes a few days to mobilize it. Once this happens, we normally become noticeably ill. What we feel is not the microbes as such but the immune-triggered release of cytokines and other active compounds.
It is therefore highly important to have well-functioning storm troops that can effectively reject any type of contamination.
Vitamin C cannot treat a cold or a bout of the flu, once the virus has gained a foothold and you have a runny nose and sore throat. Still, the vitamin, which also strengthens the specific immune defense, contributes to faster recovery and prevents subsequent infections such as bronchitis, middle ear infection, and pneumonia. Such infections typically occur when our resistance is low, and bacteria from the natural microflora in the throat spread to areas where they normally don’t belong

Vitamin C is effective against many virus infections

In 2005, Orthomolecular Medicine News Service (a non-profit scientific information service) wrote that vitamin C is effective for treating bird flu. Numerous studies show that vitamin C is effective for treating all kinds of infectious diseases, including different types of influenza, encephalitis, and measles. In complicated cases, large doses of vitamin C have been administered intravenously to rapidly provide the immune system with a larger supply of the vitamin to make it function more effectively.

Subclinical scurvy is a sign of vitamin C deficiency

A tendency to bruise easily, bleeding gums, nosebleed, and poor wound healing are signs of “subclinical scurvy”. Full-blown scurvy is the final consequence of vitamin C deficiency with lethal internal hemorrhaging, fatigue, joint pain, allergies, low stress threshold, and several other problems.
The fact that smaller doses of vitamin C are able to prevent scurvy, however, is no guarantee that the body is properly supplied with the nutrient. Some scientists compare vitamin C to a water-soluble hormone with countless essential functions.

The need for vitamin C is especially great in connection with

  • Physical and mental stress
  • Beginning infections
  • Poor immune defense and chronic disease
  • A tendency to bruise easily, bleed from the gums, or other signs of “subclinical scurvy”
  • Detoxification and working with harmful substances
  • Abuse of sugar, tobacco, alcohol and other stimulants, and junk-food
  • The use of birth control pills, aspirin, painkillers, and antibiotics
  • Pregnancy and lactation                                                                                                                                                                       

Vitamin C sources and RI (reference intake)

Vitamin C is mainly found in fruit, berries, and vegetables like cabbage, bell pepper, horseradish, spinach, garlic, ginger, and other herbs. Fresh produce contains the highest amount of vitamin C. The reference intake for vitamin C is 80 mg and prevents scurvy, which is the classical vitamin C deficiency syndrome. Nonetheless, the RI level is far below the amounts of vitamin C, which animals are able to produce. In fact, they can double or even triple their production of the vitamin in situations with stress or infections.

Vitamin C and supplements

It is generally a good idea to consume a diet that is rich in vitamin C because such a diet is bound to contribute with other essential nutrients, as well. When it comes to choosing supplements, it is normally best to stick with non-acidic vitamin C that is gentle towards the stomach lining. A supplement with 500-750 mg of vitamin C corresponds with the amount of vitamin C found in 10-15 oranges or 50-75 apples.
At the initial signs of an infection, it is possible to boost the immune defense by taking a high dosage of non-acidic vitamin C several times a day. It is important, however, to avoid mega-dosages on a daily basis, as this may eventually displace copper, another nutrient that is also important for proper immune functioning.

It is a good idea…

have strong, non-acidic vitamin C at home and to bring it along on travels as a way of giving the immune system a quick boost in situations where an infection is on its way.                  

Remember to wash your hands and make to follow other rules of hygiene to avoid unnecessary contamination

References:

Lester Packer, Jürgen Fuchs. Vitamin C in Health and Disease. University of California

Kim Y et al. Vitamin C Is an Essential Factor on the Anti-viral Immune Responses through the Production of Interferon-α/β at the Initial stage of influenza A Virus (H3N2) Infection. Immune Netw. 2013

Orthomolecular Medicine News Service October 26, 2005

H. Clay Gorton, Kelly Jarvis. The effectiveness of vitamin C in preventing and relieving the symptoms of virus-induces respiratory infections. Journal of Manipulative and Physiological Therapeutics 1999

Frederik R. Klenner. Clinical Guide to the use of Vitamin C

Pernille Lund. Immunforsvarets nye ABC. Hovedland. 2012

https://www.ncbi.nlm.nih.gov/pubmed/11389953

http://www.b.dk/nationalt/danskerne-spiser-mindre-frugt-og-groent

 

  • Created on .
8.875MBMemory Usage483msRequest 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" => 1738589385 "last" => 1738589385...
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.5KB) (2.85ms)
  • afterInitialise (1.27MB) (40.63ms)
  • afterRoute (897.2KB) (12.8ms)
  • beforeRenderComponent com_content (24.01KB) (286μs)
  • Before Access::preloadComponents (all components) (33.23KB) (276μs)
  • After Access::preloadComponents (all components) (97.34KB) (2.08ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (20μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (17.15ms)
  • Before Access::getAssetRules (id:2219 name:com_content.article.1088) (130.65KB) (2.1ms)
  • After Access::getAssetRules (id:2219 name:com_content.article.1088) (7.47KB) (65μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.36MB) (54.83ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (2.6ms)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (6μs)
  • afterRenderModule mod_custom (Search for more information...) (5.45KB) (102μs)
  • afterRenderComponent com_content (72.02KB) (38.94ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.76KB) (6.71ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (29μs)
  • afterDispatch (29.45KB) (1.96ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (506μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (91.69KB) (109ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (31μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (59μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (15μs)
  • afterRenderRawModule mod_tags_popular (Search) (46.05KB) (135ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (29μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (49μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (12μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (21μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (7.3ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (60μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (15μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (25μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (11μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (21μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (10μ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) (9μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (20μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (482μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (7.83ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (59μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift) (19.05KB) (8.8ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (20μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (128.59KB) (8.2ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (33μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (140μs)
  • afterRenderRawModule mod_custom () (22.27KB) (3.34ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (46μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (103μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.79ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (47μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (649μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (29μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.09KB) (4.07ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.73KB) (48μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (184μs)
  • afterRenderRawModule mod_custom () (944B) (130μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (26μs)
  • beforeRenderRawModule mod_custom () (688B) (79μs)
  • afterRenderRawModule mod_custom () (896B) (93μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (23μs)
  • afterRender (214.39KB) (9.97ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (46.05KB) (27.89%)
    134.68ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (91.69KB) (22.6%)
    109.12ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.36MB) (11.36%)
    54.83ms
    1 x afterInitialise (1.27MB) (8.41%)
    40.63ms
    1 x afterRenderComponent com_content (72.02KB) (8.07%)
    38.94ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (3.55%)
    17.15ms
    1 x afterRoute (897.2KB) (2.65%)
    12.80ms
    1 x afterRender (214.39KB) (2.06%)
    9.97ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (19.05KB) (1.82%)
    8.80ms
    1 x afterRenderRawModule mod_finder () (128.59KB) (1.7%)
    8.20ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (191.29KB) (1.62%)
    7.83ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.51%)
    7.30ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.76KB) (1.39%)
    6.71ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.84%)
    4.07ms
    1 x afterRenderRawModule mod_custom () (22.27KB) (0.69%)
    3.34ms
    1 x afterLoad (456.5KB) (0.59%)
    2.85ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.29KB) (0.54%)
    2.60ms
    1 x Before Access::getAssetRules (id:2219 name:com_content.article.1088) (130.65KB) (0.43%)
    2.10ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.43%)
    2.08ms
    1 x afterDispatch (29.45KB) (0.41%)
    1.96ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.37%)
    1.79ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.13%)
    649μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.1%)
    506μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (18.53KB) (0.1%)
    482μs
    1 x beforeRenderComponent com_content (24.01KB) (0.06%)
    286μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.06%)
    276μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    184μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    140μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    130μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.02%)
    103μs
    1 x afterRenderModule mod_custom (Search for more information...) (5.45KB) (0.02%)
    102μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    93μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    79μs
    1 x After Access::getAssetRules (id:2219 name:com_content.article.1088) (7.47KB) (0.01%)
    65μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    60μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    59μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    59μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    49μs
    1 x afterRenderModule mod_finder () (3.73KB) (0.01%)
    48μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    47μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    46μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    33μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0.01%)
    29μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (1.27KB) (0.01%)
    29μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    29μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0.01%)
    25μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    23μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    21μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    19μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    15μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    12μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
46 statements were executed, 9 of which were duplicates, 37 unique311ms1.18MB
  • SELECT @@SESSION.sql_mode;56μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?185μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 178μ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.48ms944BParams/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` = 1659μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`494μ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` = :guest200μ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` ASC154μ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` = 1124μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config154μ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`1.76ms165.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`280μ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` = 1278μ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)584μ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` = 07.31ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.97ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1088'2.18ms48B/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)365μ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`1.27ms3.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)5.61ms4.09KBParams/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`331μ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 ASC869μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id936μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id75μ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`6.76ms180.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 DESC28.54ms161.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`304μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1105μ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.9ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id75μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id697μ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-03 13:29:45') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 13:29:45') AND c2.state = 1338μs4KBParams/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 10101ms167.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`366μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`1.47ms3.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 15132ms2.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.97ms1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1840μ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)147μ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 ASC2.77ms4.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)123μ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` = 1108μs1.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`1.02ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?92μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.26ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy