Skip to main content

Calcium supplements are associated with cancer and atherosclerosis

Calcium supplements are associated with cancer and atherosclerosisWe all know that calcium is good for your bones, and many people actually supplement with calcium to prevent osteoporosis. But even without supplementation, we get plenty of calcium from dairy products, and too much calcium from supplements can lead to a tenfold increase in the risk of dying of cancer, according to a new study that is published in Annals of Internal Medicine.
Earlier studies reveal that too much calcium also increases your risk of atherosclerosis and inflammation, a common thread in most chronic illnesses. It is also important to know that your calcium ingestion should be properly balanced with magnesium. If the balance is right, most of the calcium ends up in the bones where it belongs instead of wreaking havoc in the blood vessels and in other soft tissues where calcium essentially does not belong.

Calcium is an essential mineral. Ninety-nine percent of the body’s calcium is stored in hard tissues like bones and teeth together with magnesium, phosphorous, and several trace elements. The remaining one percent of our calcium is involved in many other vital functions, including nerve transmission, muscle contraction, cardiac function, and blood pressure. Other than the small quantity needed to undertake these functions, cells in all of these soft tissues should ideally be nearly devoid of calcium. Otherwise, they overreact and trigger inflammation, oxidative stress and cell death.

  • Oxidative stress is an imbalance between free radicals and antioxidants
  • Free radicals are generated by our own metabolism as well as by environmental factors
  • If there is oxidative stress, we risk that free radicals attack our cells, our DNA, and cholesterol

Too much calcium in supplement form works like a cancerous toxin

Most calcium supplements also contain vitamin D, which is needed for proper absorption of calcium in the body. However, if you take more than 1,000 mg of calcium daily it may increase your risk of dying of cancer, according to a new study from Tufts University in Boston, USA. A total of 27,000 American adults participated in the study, and the whole purpose was to look closer at the relation between diet, nutritional supplements, and deaths related to cancer and cardiovascular disease.
A 12-year follow-up of the study showed that, among the participants who had taken more than 1,000 mg of calcium daily, 24 cancer-related deaths had occurred. Among those who had not taken calcium supplements, 12 had died of cancer. In other words, there were twice as many cancer-related deaths in the group that took calcium supplements.
The scientists also found that adequate dietary intake of magnesium and vitamin K was associated with a lower risk of premature death. They did not find a similar relation with nutritional supplements. This is most likely because the majority of supplements with magnesium and vitamin K have such inferior quality that the nutrients are not properly absorbed in the small intestine. With regard to magnesium, it is generally a good idea to choose a supplement with organic magnesium.
The researchers admit that their study has certain limitations. For instance, it was only a short-term study, plus it was based on the participants self-reported information about diet and supplement use. Still, their findings support earlier research showing that calcium taken as a stand-alone supplement may be bad for you. In fact, the widespread use of stand-alone calcium supplements in Western countries may be part of the reason why cancer rates are higher and we have not been able to bend the cancer curve. The study is published in the Annals of Internal Medicine.

High-dosed calcium supplements increase the risk of atherosclerosis

There also appears to be a link between calcium supplementation and the risk of developing atherosclerosis, according to a large, randomized, controlled study (Women’s Health Initiative). The scientists observed more deaths among the women that took more than 1,400 mg of calcium daily, just like the other study showed. In the 10-year Multi-Ethnic Study of Atherosclerosis (MESA), researchers also looked at how calcium from the diet and from supplements increases the risk of atherosclerosis. They studied 5,448 adult men and women aged 45-84 years, who had not been diagnosed with atherosclerosis earlier. Their calcium intake from the diet was assessed by means of questionnaires. Daily calcium intake was divided into five groups in the range 300 – 2,100 mg. The degree of atherosclerotic progression was measured at baseline and after 10 years in 2,742 of the participants. The scientists noted that high dietary calcium intake was associated with reduced atherosclerosis. On the other hand, they found that calcium supplementation increased the risk. They therefore recommend that people primarily get their calcium from dietary sources such as vegetables, almonds, nuts, dairy products and fish, also because these foods contain other nutrients. Water also contains calcium, especially “hard water”. Soup bones that have simmered for hours are particularly rich in calcium plus other minerals and trace elements.
According to the scientists behind the new study, too much calcium from supplements may result in atherosclerosis and cardiovascular disease by way of various mechanisms such as the lipid metabolism, insulin sensitivity, blood clotting, and inflammation. A very import yet overlooked factor is the interplay between calcium and magnesium

  • Many people get far too much calcium from their diets and from supplements
  • It is a good idea to read the label on your supplement(s) to find out what your total calcium intake is
  • Remember that calcium should be balanced carefully with magnesium

Magnesium’s interaction with calcium is vital for your bones and health

The way calcium and magnesium interact is fundamentally important for all living cells, and you should never take calcium on its own for bone health. You risk doing more harm than good, and it can even be life-threatening in extreme cases. Magnesium functions like a door bolt in the calcium channels of our cell membranes. By virtue of this ability to control calcium levels in all cells, magnesium makes sure to channel nearly all calcium into bones and teeth, while it only allows very little calcium into the cells of soft tissues such as nerve, muscles, blood vessels, and internal organs.
If you lack magnesium, you have no guarantee that the calcium enters the cells in your bones and teeth, and that increases the risk of osteoporosis. You also risk that too many calcium ions enter the cells of soft tissues. This calcium flooding of the cells works like a tsunami and stresses the cells, causing them to produce pro-inflammatory cytokines. It is not felt directly, but it may cause low-grade, chronic inflammation and oxidative stress that is typically seen in diseases like cancer, atherosclerosis, type 2 diabetes, depression, ADHD, Alzheimer’s disease and other neurological disorders. If too many calcium ions flood the nerve cells, it may trigger changes to the synaptic bridges, which overstimulates the cells and causes them to cramp. This may even destroy the mitochondria, which are the energy-producing powerhouses in the cells. An array of different diseases, including cancer and certain neurological disorders, are characterized by mitochondrial defects.

  • We need vitamin D to take up calcium
  • Calcium supplements can increase bone density, although studies show that calcium taken as a stand-alone supplement does not increase bone strength
  • It is bone strength that is of most importance for avoiding fractured bones as a result of falls or other types of impact
  • To boost bone strength, you also need magnesium and vitamin K2
  • Moreover, strong bones depend on exercise and a healthy diet and lifestyle without too many “magnesium robbers” such as sugar, candy, soft drinks, Coca-Cola, and other energy beverages

The essential balance between calcium and magnesium in diet and supplements

In the Western world, the diet typically contains around four times as much calcium as magnesium, which means that we get calcium and magnesium in a 4:1 ratio. This is because we eat a lot of dairy products and not so many vegetables. If people take calcium supplements in addition to this, the balance becomes even more skewed.
In countries like Japan, the calcium-magnesium ratio is closer to 1:1, which is because the typical Japanese does not consume dairy products and therefore only gets around 400-500 mg of calcium daily. On the other hand, the Japanese get far more magnesium from their vegetable consumption. It is most likely because of their diet that the Japanese have a lower rate of osteoporosis. But they also have a higher life expectancy due to a lower rate of cancer and atherosclerosis, which are two of the major killers.
The big question is therefore if we really need less calcium and more magnesium than the dietary guidelines recommend in order to stay healthy and maintain strong bones. It is also worth mentioning that cow’s milk is intended for calves and not for human consumption. After all, other mammals such as shrewmice, monkeys, blue whales etc. have strong bones and they do not consume milk from other species.
In other words, it is not just calcium that is determining for bone strength. In fact, calcium taken in the wrong amount and without being accompanied by relevant micronutrients can actually be harmful.

  • Facts about the calcium/magnesium ratio and about supplements
  • The calcium/magnesium ratio according to the guidelines should ideally be 2:1
  • The calcium/magnesium ratio in the Nordic diet is close to 4:1
  • The calcium/magnesium ratio in the Japanese diet is around 1:1
  • Milk contains nine times more calcium than magnesium
  • Solid cheese contains around 35 times more calcium than magnesium
  • Too much calcium inhibits the uptake/utilization of iron, zinc, and magnesium
  • Too much calcium increases the risk of constipation
  • Too much calcium combined with too little magnesium is very harmful
  • Never take a calcium supplement without taking magnesium, as well
  • It is not a problem if you take a stand-alone magnesium supplement
  • The quality of a supplement is determining for its bioavailability
  • Health authorities warn against taking calcium supplements if people suffer from hypercalcemia, impaired renal function, or tend to form kidney stones

References:

Fan Chen et al. Association Among Dietary Supplements Use, Nutrient Intake, and Mortality Among U.S. Adults. Annals of Internal Medicine 2019

Tufts University, Health Sciences Campus. Nutrients from food, not supplements, linked to lower risks of death, cancer. ScienceDaily 2019

Forrest H Nielsen. Magnesium deficiency and increased inflammation; current perspectives. J Inflamm Res 2018

Helen Sauil Case. Magnesium demper hyperaktivitet blant AD/HD-barn. Helsemagasinet Vitenskap og Fornuft. N1 2017

Fujita T, Fukase M. Comparison of osteoporosis and calcium intake between Japan and the United States. Procb Soc Exp Biol Med 1992

Travis Christoffersen. Når man snubler over sandheden. Ny behandling af kræft. Hovedland 2019

https://frida.fooddata.dk/CntList.php

  • Created on .
8.897MBMemory Usage623msRequest 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" => 1738587495 "last" => 1738587495...
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.63KB) (425μs)
  • afterInitialise (1.27MB) (44.55ms)
  • afterRoute (927.02KB) (27.38ms)
  • beforeRenderComponent com_content (24.37KB) (1.41ms)
  • Before Access::preloadComponents (all components) (35.84KB) (1.31ms)
  • After Access::preloadComponents (all components) (97.34KB) (2.12ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (14μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (26.13ms)
  • Before Access::getAssetRules (id:4915 name:com_content.article.2433) (130.65KB) (91μs)
  • After Access::getAssetRules (id:4915 name:com_content.article.2433) (7.38KB) (48μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (86.53ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (218μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (3μs)
  • afterRenderModule mod_custom (Search for more information...) (6.95KB) (74μs)
  • afterRenderComponent com_content (74.49KB) (63.29ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.07KB) (9.27ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (27μs)
  • afterDispatch (17.72KB) (625μs)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (439μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (162ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (29μs)
  • afterRenderRawModule mod_tags_popular (Search) (18.99KB) (94.24ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (24μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (45μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (21μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (22.98ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (25μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (39μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (23μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (12.16ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (60μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (27μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (18μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (23μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (17μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (21μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (9μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (27μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (3.73ms)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (6.77ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (55μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (9.29ms)
  • 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 () (214.53KB) (14.2ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (3.29KB) (34μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (140μs)
  • afterRenderRawModule mod_custom () (22.27KB) (9.69ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (350μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (116μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (5.08ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (50μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.05ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (993μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (16μs)
  • afterRenderRawModule mod_finder () (6.09KB) (7.91ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (50μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (184μs)
  • afterRenderRawModule mod_custom () (944B) (134μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (27μs)
  • beforeRenderRawModule mod_custom () (688B) (1.12ms)
  • afterRenderRawModule mod_custom () (896B) (140μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (31μs)
  • afterRender (181.83KB) (5.29ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (25.99%)
    161.76ms
    1 x afterRenderRawModule mod_tags_popular (Search) (18.99KB) (15.14%)
    94.24ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (13.9%)
    86.53ms
    1 x afterRenderComponent com_content (74.49KB) (10.17%)
    63.29ms
    1 x afterInitialise (1.27MB) (7.16%)
    44.55ms
    1 x afterRoute (927.02KB) (4.4%)
    27.38ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (4.2%)
    26.13ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.77KB) (3.69%)
    22.98ms
    1 x afterRenderRawModule mod_finder () (214.53KB) (2.28%)
    14.20ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.95%)
    12.16ms
    1 x afterRenderRawModule mod_custom () (22.27KB) (1.56%)
    9.69ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (27.15KB) (1.49%)
    9.29ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.07KB) (1.49%)
    9.27ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (1.27%)
    7.91ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (1.09%)
    6.77ms
    1 x afterRender (181.83KB) (0.85%)
    5.29ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.82%)
    5.08ms
    1 x beforeRenderRawModule mod_menu (Main menu-US) (18.38KB) (0.6%)
    3.73ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.34%)
    2.12ms
    1 x beforeRenderComponent com_content (24.37KB) (0.23%)
    1.41ms
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.21%)
    1.31ms
    1 x beforeRenderRawModule mod_custom () (688B) (0.18%)
    1.12ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.17%)
    1.05ms
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.16%)
    993μs
    1 x afterDispatch (17.72KB) (0.1%)
    625μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.07%)
    439μs
    1 x afterLoad (456.63KB) (0.07%)
    425μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.06%)
    350μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.04%)
    218μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    184μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.02%)
    140μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    140μs
    1 x afterRenderRawModule mod_custom () (944B) (0.02%)
    134μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    116μs
    1 x Before Access::getAssetRules (id:4915 name:com_content.article.2433) (130.65KB) (0.01%)
    91μs
    1 x afterRenderModule mod_custom (Search for more information...) (6.95KB) (0.01%)
    74μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    60μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    55μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    50μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    50μs
    1 x After Access::getAssetRules (id:4915 name:com_content.article.2433) (7.38KB) (0.01%)
    48μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    45μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    39μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    34μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    31μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0%)
    29μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    27μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0%)
    27μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0%)
    27μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    27μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0%)
    25μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0%)
    24μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    23μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    21μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    20μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    19μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    18μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (0%)
    17μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Search) (5.17KB) (0%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    14μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    3μs
45 statements were executed, 9 of which were duplicates, 36 unique393ms1.35MB
  • SELECT @@SESSION.sql_mode;163μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?362μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1529μ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.11ms944BParams/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` = 11.25ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`436μ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` = :guest519μ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`2.37ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC138μs2.33KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `has_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1142μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config164μ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`3.27ms165.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`3.49ms3.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` = 1212μ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)344μ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` = 014.54ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.63ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '2433'4.84ms48B/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)968μ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`2.21ms3.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)1.13ms4.06KBParams/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`880μ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 ASC336μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id106μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id160μ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.98ms180.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 DESC56.91ms161.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`350μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1143μ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` = 0718μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.98ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.8ms1.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-02-03 12:58:15') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 12:58:15') AND c2.state = 1273μ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 10158ms195.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-02-03 12:58:15', 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 1088.69ms2.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 106.97ms159.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`5.98ms3.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` = :id4.98ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 13.35ms640B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)1.21ms584B/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.78ms4.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)3.35ms584B/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` = 1137μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?1.32ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.87ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy