Skip to main content

Birth control pills deplete your vitamin and mineral stores and may cause side effects

Birth control pills deplete your vitamin and mineral stores and may cause side effectsBirth control pills are commonly used as a source of prevention. Most women seem to tolerate the pills rather well, but there are known side effects such as headaches, mood swings, and a slightly increased risk of blood clots and breast cancer. The different side effects are a result of the birth control pills and their disturbing impact on various enzyme processes, which depend on most B vitamins, vitamin C, magnesium, selenium, and zinc. Vitamin C, zinc, and selenium also serve as effective antioxidants that protect our cells and cardiovascular system against oxidative stress. It is therefore essential to get plenty of these nutrients in order to lower the risk of side effects.

Twenty-five to 30 percent of women of childbearing age use birth control pills. Since the 1960s, these preparations have contained synthetically manufactured estrogen in the form of ethinylestradiol, which is chemically related to estradiol, a natural estrogen form. Birth control pills also contain synthetically manufactured gestagens that replace natural progesterone. Depending on what type of gestagen is in the pill, the preparations are categorized in different generations. The two hormones in birth control pills put a woman’s own hormone production on pause, thereby terminating her ovulation so she is unable to conceive.
Ever since the birth control pill entered the market, the hormone content and the risk of side effects have been reduced. Most importantly, the risk of getting a blood clot has gone down, but it remains and there are also other side effects as shown in the following.

The birth control pill was co-invented in the 1960s by the American scientist, Gregory Pincus.

Be careful – there is a risk of blood clots

Blood clots are extremely rare among young women of childbearing age, but birth control pills quadruple their risk. The risk is largest during the first six to 12 months after you start taking the pills, and if you don’t have any problems during this period, you most likely do not belong to the group of women at risk of having one.
Women should make sure to inform their physicians about any family history of diabetes, heart disease, or similar conditions, and they must also have their blood pressure measured before and three months after starting on the pill. Any precautions concerning whether or not to prescribe birth control pills are linked to the risk of a blood clot.

Breast cancer

Although there are many factors involved in breast cancer, it has been known for long that the risk of this cancer form increases when you use birth control pills. The link was demonstrated in a large Danish study, which is published in New England Journal of Medicine. Here, researchers compared the statistics for 15-49 year-old women in Denmark. They found 13 more cases of breast cancer in a group of 100,000 women who took the pills than in a group of 100,000 women who did not take the pills. It is a slightly increased risk, and the disease is rare among women younger than 30 years. Still, one must bear in mind that it takes many years for breast cancer to develop.
If you cut out the birth control pills, the risk of breast cancer drops again. However, it is also important to realize that there are other risk factors such as overweight, lack of exercise, too little sleep, too much alcohol, and low levels of vitamin D and selenium.

Did you know that birth control pills are able to deplete your body’s stores of selenium and vitamin B12, both of which are nutrients with anti-cancer properties?

Cervical cancer

In women who are infected with HPV (human papillomavirus), birth control pills can slightly increase their risk of cervical cancer. According to an article published in American Journal of Epidemiology, birth control pills and smoking increase the risk of cellular changes caused by HPV. The author specifies that birth control pills and smoking have a negative effect on the body’s folic acid and vitamin B12 status. Similarly, another study that is published in International Journal of Women’s Health shows that Indian women with higher blood levels of folic acid and vitamin B12 have a lower risk of HPV-induced cellular changes.
It appears that vitamin B12 and folic acid in sufficient amounts help to protect users of birth control pills against cervical cancer. Vegetarians should also make sure to get plenty of vitamin B12.

Other side effects from birth control pills

Some side effects occur rather soon, while other are insidious and show a long time after you start using the pills, which can make it difficult to link the side effects to the pills.
Some of the most important adverse effects are:

  • Headaches
  • Nausea
  • Weight gain
  • Mood swings and depression
  • Brown pigmentation and stains – mainly in the face
  • Spotting
  • Hypertension
  • Vaginal dryness and lowered libido
  • Overgrowth of the Candida albicans fungus, which is found naturally in the vaginal and gastrointestinal mucosa. Symptoms include white, grainy discharge, digestive problems, and sensitive blood sugar
  • Smokers from 35 years and older have an increased risk of cerebral hemorrhage

The many side effects may be a result of vitamin and mineral deficiencies

Birth control pills interfere with numerous enzyme processes, which depend on the presence of certain vitamins and minerals. This may account for many of the different side effects. Birth control pills specifically increase your need for vitamin B6, folic acid, vitamin B12, vitamin C, magnesium, selenium, and zinc. The following overview shows the importance and function of some of these nutrients. Lacking one or several of the following nutrients may have a negative effect on the listed functions.

Vitamin B6

  • Energy turnover
  • Nervous system and mental balance
  • Hormone system
  • Immune system
  • Antioxidant

Folic acid (vitamin B9)

  • Energy turnover
  • Blood formation
  • Mental balance
  • Regulation of homocysteine in the blood. Elevated homocysteine levels increase the risk of blood clots

Vitamin B12

  • Energy turnover
  • Nervous system and cognitive functions
  • Blood formation
  • Immune system

Vitamin C

  • Immune defense
  • Collagen (connective tissue)
  • Cardiovascular system
  • Wound healing
  • Stress threshold
  • Antioxidant

Magnesium

  • Energy turnover
  • Nervous system and mental balance
  • Muscles and relaxation
  • Blood pressure and heart
  • Bones

Selenium

  • Thyroid gland and metabolism
  • Cardiovascular system
  • Immune defense
  • Fertility
  • Antioxidant
  • Various anti-cancer properties

Zinc

  • Skin, hair, and nails
  • Vision, hearing, taste sense, appetite
  • Immune defense
  • Fertility
  • Antioxidant

Birth control pills increase your risk of oxidative stress – antioxidants protect the cells

As shown, birth control pills can increase your need for vitamin C, vitamin B6, selenium, and zinc. These nutrients are some of the most powerful antioxidants and work by protecting our cells and cardiovascular system against harmful free radicals. Free radicals are highly aggressive molecules that set the stage for atherosclerosis, cell damage, DNA mutations, disease, and decay. Free radicals are a byproduct of our own respiration. Moreover, stress, inflammation, poisoning, smoking, radiation, and ageing processes generate an increased amount of free radicals.
When the delicate between harmful free radicals and protective antioxidants is upset, the body is exposed to something called oxidative stress. Birth control pills can increase the risk of oxidative stress, especially if levels of vitamin C, vitamin B6, selenium, and zinc are too low.

Birth control pills are less suited for

  • Women who smoke a lot
  • Young women, who have still not fully matured
  • Breastfeeding women
  • Women who have not had regular periods for some time
  • Women with elevated blood pressure, diabetes, migraine headaches, and heart diseases
  • Women with elevated cholesterol levels
  • Women with a BMI higher than 30

Birth control pills are not suited for

  • Women, who smoke and are older than 35 years of age
  • Women who have had blood clots or inflammation of the veins (phlebitis)
  • Women with breast cancer
  • Women with liver diseases

If your birth control pills disagree with you, try changing brands or choose another source of birth control

Users of birth control pills should make sure under all circumstances to get enough folic acid, vitamin B12, vitamin C, magnesium, zinc, and selenium in order to lower their risk of short-term and long-term side effects.

References

Thomas Hoffmann. Skal jeg lægge p-pillerne på hylden for at undgå brystkræft? www.videnskab.dk, December 2017
https://videnskab.dk/krop-sundhed/skal-jeg-laegge-p-pillerne-paa-hylden-for-at-undgaa-brystkraeft

Catherine A. Hendricks: Genital human papilloma-virus infection: incidence and risk factors in a cohort of female university students. American Journal of Epidemiology. 2003
https://www.ncbi.nlm.nih.gov/pubmed/12543621

Chandrika J P. et al. Indian women with higher serum concentrations of folate and vitamin B12 are significantly less likely to be infected with carcinogenic or high-risk (HR) types of human papillomaviruses (HPVs)
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2971743/

https://www.cancer.dk/hjaelp-viden/fakta-om-kraeft/aarsager-til-kraeft/hormoner/

https://www.apoteket.dk/sundhed/praevention/p-piller

https://www.netdoktor.dk/sunderaad/fakta/p-piller.htm

https://www.netdoktor.dk/sex_samliv/naturlige_kunstige_oestrogener.htm

https://www.netdoktor.dk/vitaminer/vitaminb6.htm

https://www.netdoktor.dk/vitaminer/folinsyre.htm

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3410054/

https://www.scientificamerican.com/article/how-birth-control-pills-affect-your-nutritional-needs/

De Sousa Almeida-Filho B et al. Vitamin D is associated with poor breast cancer prognostic features. J Steroid Biochem Mol Biol 2017
https://www.ncbi.nlm.nih.gov/pubmed/29031688

Harris HR, et al. Selenium intake and breast cancer mortality in a cohort of Swedish women. Breast Cancer Res Treat. 2012.
https://www.ncbi.nlm.nih.gov/pubmed/22736377

 

  • Created on .
8.92MBMemory Usage460msRequest 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" => 1738589434 "last" => 1738589434...
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) (531μs)
  • afterInitialise (1.27MB) (36.99ms)
  • afterRoute (927.02KB) (14.62ms)
  • beforeRenderComponent com_content (24.37KB) (253μs)
  • Before Access::preloadComponents (all components) (35.84KB) (251μs)
  • After Access::preloadComponents (all components) (97.34KB) (3.38ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (14μs)
  • After Access::preloadPermissions (com_content) (3.19MB) (23.11ms)
  • Before Access::getAssetRules (id:3468 name:com_content.article.1719) (130.65KB) (100μs)
  • After Access::getAssetRules (id:3468 name:com_content.article.1719) (7.38KB) (45μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (69.73ms)
  • afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (241μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (10.95KB) (80μs)
  • afterRenderComponent com_content (70.55KB) (51.86ms)
  • Before Access::getAssetRules (id:8 name:com_content) (50.18KB) (7.67ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (42μs)
  • afterDispatch (30.07KB) (2.34ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (435μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (126ms)
  • beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (29μs)
  • afterRenderRawModule mod_tags_popular (Search) (19.26KB) (78.63ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (29μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (53μs)
  • beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (22μs)
  • afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.76KB) (9.15ms)
  • beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (28μs)
  • afterRenderRawModule mod_custom (Antiaging) (1KB) (43μs)
  • beforeRenderRawModule mod_custom (Exercise) (720B) (11μs)
  • afterRenderRawModule mod_custom (Exercise) (1.02KB) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (4.88ms)
  • afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (64μs)
  • beforeRenderModule mod_tags_popular (Search) (5.17KB) (15μs)
  • afterRenderModule mod_tags_popular (Search) (2.52KB) (25μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (12μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (21μs)
  • beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (16μs)
  • afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (20μs)
  • beforeRenderModule mod_custom (Antiaging) (7.33KB) (10μs)
  • afterRenderModule mod_custom (Antiaging) (1.27KB) (20μs)
  • beforeRenderModule mod_custom (Exercise) (336B) (12μs)
  • afterRenderModule mod_custom (Exercise) (1.25KB) (26μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (465μs)
  • afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (3.03ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (5μs)
  • afterRenderModule mod_menu (Main menu-US) (4.61KB) (56μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (17μs)
  • afterRenderRawModule mod_languages (Sprogskift) (25.29KB) (4.54ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (6μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (22μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (11μs)
  • afterRenderRawModule mod_finder () (214.16KB) (4.41ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (3.29KB) (35μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (147μs)
  • afterRenderRawModule mod_custom () (22.3KB) (854μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (49μs)
  • beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (107μs)
  • afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (1.82ms)
  • beforeRenderModule mod_menu (Main menu-US) (720B) (4μs)
  • afterRenderModule mod_menu (Main menu-US) (1.25KB) (47μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (1.71ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (34μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (10μs)
  • afterRenderRawModule mod_finder () (6.09KB) (2.03ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (43μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (180μs)
  • afterRenderRawModule mod_custom () (944B) (136μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (26μs)
  • beforeRenderRawModule mod_custom () (688B) (84μs)
  • afterRenderRawModule mod_custom () (896B) (91μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.71KB) (1.05ms)
  • afterRender (185.68KB) (6.29ms)
  • 1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.05KB) (27.38%)
    126.00ms
    1 x afterRenderRawModule mod_tags_popular (Search) (19.26KB) (17.09%)
    78.63ms
    1 x beforeRenderRawModule mod_custom (Search for more information...) (1.34MB) (15.15%)
    69.73ms
    1 x afterRenderComponent com_content (70.55KB) (11.27%)
    51.86ms
    1 x afterInitialise (1.27MB) (8.04%)
    36.99ms
    1 x After Access::preloadPermissions (com_content) (3.19MB) (5.02%)
    23.11ms
    1 x afterRoute (927.02KB) (3.18%)
    14.62ms
    1 x afterRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (45.76KB) (1.99%)
    9.15ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (50.18KB) (1.67%)
    7.67ms
    1 x afterRender (185.68KB) (1.37%)
    6.29ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.63KB) (1.06%)
    4.88ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (25.29KB) (0.99%)
    4.54ms
    1 x afterRenderRawModule mod_finder () (214.16KB) (0.96%)
    4.41ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.73%)
    3.38ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (152.11KB) (0.66%)
    3.03ms
    1 x afterDispatch (30.07KB) (0.51%)
    2.34ms
    1 x afterRenderRawModule mod_finder () (6.09KB) (0.44%)
    2.03ms
    1 x afterRenderRawModule mod_menu (Main menu-US) (6.02KB) (0.4%)
    1.82ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.37%)
    1.71ms
    1 x afterRenderModule mod_custom () (2.71KB) (0.23%)
    1.05ms
    1 x afterRenderRawModule mod_custom () (22.3KB) (0.19%)
    854μs
    1 x afterLoad (456.63KB) (0.12%)
    531μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (22.38KB) (0.1%)
    465μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.3KB) (0.09%)
    435μs
    1 x beforeRenderComponent com_content (24.37KB) (0.05%)
    253μs
    1 x Before Access::preloadComponents (all components) (35.84KB) (0.05%)
    251μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (4.7KB) (0.05%)
    241μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.04%)
    180μs
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.03%)
    147μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    136μs
    1 x beforeRenderRawModule mod_menu (Main menu-US) (5.07KB) (0.02%)
    107μs
    1 x Before Access::getAssetRules (id:3468 name:com_content.article.1719) (130.65KB) (0.02%)
    100μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    91μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.02%)
    84μs
    1 x afterRenderModule mod_custom (Search for more information...) (10.95KB) (0.02%)
    80μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (1.25KB) (0.01%)
    64μs
    1 x afterRenderModule mod_menu (Main menu-US) (4.61KB) (0.01%)
    56μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    53μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    49μs
    1 x afterRenderModule mod_menu (Main menu-US) (1.25KB) (0.01%)
    47μs
    1 x After Access::getAssetRules (id:3468 name:com_content.article.1719) (7.38KB) (0.01%)
    45μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    43μs
    1 x afterRenderRawModule mod_custom (Antiaging) (1KB) (0.01%)
    43μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    42μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    35μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (960B) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (4.81KB) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_custom (Antiaging) (6.97KB) (0.01%)
    28μs
    1 x afterRenderModule mod_custom (Exercise) (1.25KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.01%)
    26μs
    1 x afterRenderModule mod_tags_popular (Search) (2.52KB) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_articles_category (Get additionel and more detailed knowledge about) (8.41KB) (0%)
    22μs
    1 x afterRenderRawModule mod_custom (Exercise) (1.02KB) (0%)
    22μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    22μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    21μs
    1 x afterRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (1.31KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (Antiaging) (1.27KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    18μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.69KB) (0%)
    17μs
    1 x beforeRenderModule mod_articles_category (Get additionel and more detailed knowledge about) (8.03KB) (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 beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.31KB) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Exercise) (336B) (0%)
    12μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (Exercise) (720B) (0%)
    11μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Antiaging) (7.33KB) (0%)
    10μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main menu-US) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
45 statements were executed, 9 of which were duplicates, 36 unique301ms1.33MB
  • SELECT @@SESSION.sql_mode;322μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?64μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1113μ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.5ms944BParams/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` = 1316μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`65μ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` = :guest616μ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`4.47ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC133μ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` = 11.07ms1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config150μ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.04ms165.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`269μ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` = 1183μs848B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `has_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)2.39ms7.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` = 011.05ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`1.3ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '1719'4.37ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `has_content` AS `a` INNER JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)3.22ms22.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`412μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2) AND `language` IN (:preparedArray3,:preparedArray4)10.68ms4.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`300μ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 ASC766μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id102μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id74μ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.68ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC36.88ms161.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`4.75ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1629μ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` = 0763μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id515μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id66μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-US' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-03 13:30:34') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-03 13:30:34') AND c2.state = 11.65ms4KBParams/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 10121ms195.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 13:30:34', 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 1076.06ms2.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 102.24ms159.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`388μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id1.08ms1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1175μ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)181μ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 ASC313μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `has_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)142μ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` = 1123μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?101μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.73ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy