Skip to main content

The omega-3 fatty acid, DHA, regulates dangerous molecular activity in breast cancer cells

The omega-3 fatty acid, DHA, regulates dangerous molecular activity in breast cancer cellsBreast cancer is most widespread in the western countries, and it is the leading cause of cancer-related deaths among women. Diet and lifestyle play a key role in the development of the disease. Earlier studies have shown that eating more oily fish or taking fish oil supplements that contain the omega-3 fatty acids, EPA and DHA, lowers the risk. A new study has shown that DHA supplements can be used as an adjuvant in cancer therapy. This particular omega-3 fatty acid inhibits the formation of some harmful molecules that stimulate the growth of breast cancer cells.

Breast cancer normally occurs in the glandular tissue or in the milk ducts. The cancer may be encapsulated in the glandular tissue, and it normally takes several years for the cancer cells to spread into the surrounding tissue. When this happens, the cancer has become invasive with the risk of cancer cells spreading to the adjacent lymph nodes and traveling through the bloodstream to other parts of the body, where it metastasizes.
Around 80 percent of breast cancer nodules are hormone-sensitive, and 13 percent of them carry a surface protein (HER2 ). These subtypes, also known as triple-positive breast cancer (TPBC) account for around 40 percent of cancer-related deaths. If the breast cancer is neither hormone-sensitive nor sensitive to HER2 antibodies, it is called triple-negative breast cancer (TNBC). This subtype accounts for around 15 percent of breast cancers. The TNBC subtype is also known to be the most aggressive one and has a high rate of recurrence within the first year after treatment. This results in a higher mortality rate, which is why there is an urgent need for new strategies for preventing and treating the different types of breast cancer.

The link between immune defense, molecules, and cancer

In the introduction to their study, the authors describe how the immune defense is tasked with destroying abnormal cells such as cancer cells. It is also important to have the right balance between the inflammatory and anti-inflammatory processes of the immune defense to prevent damage to healthy body tissues. This balance is called immune homeostasis. However, it appears that most types of cancer are characterized by disturbances in this delicate balance, including chronic low-grade inflammation.
It also appears that cancer cells are able to express so-called immune checkpoint molecules that prevent cancer cells from being attacked by the immune system. It is sort of like laying out a smoke screen that enables the cancer cells to hide from the immune defense.
Cancer cells can also develop disruptions in the regulation of miRNA (micro-RNA) that has importance for the cellular DNA expression and mobility. Micro-RNAs also have a role in helping worn-out or abnormal cells to carry out apoptosis, which is programmed self-destruction. In other words, cancer cells make use of several mechanisms to divert the immune defense and to proliferate uncontrollably.
In vivo studies (human studies) and in vitro studies (typically lab tests) have shown that omega-3 fatty acids, DHA in particular, counteract breast cancer. However, very few studies have looked at DHA’s potential in the treatment of breast cancer through regulation of the immune defense, the self-destructive immune reactions, and miRNA.

New insight into DHA’s potential in the treatment and prevention of breast cancer

In the new study, the researchers used two different breast cancer cell cultures (BT-474 and MDA-MB-231), which they obtained from the National Cell Bank of Iran. These cultures, which represented the TPBC and TNBC subtypes were cultivated using special methods at 37 degrees Celsius. Afterwards, they were treated with DHA for 24 hours. The study also included breast cancer cell cultures that were not treated with DHA. These served as a control group.
All the different cell cultures, which were initially cultivated in a special way, significantly expressed the so-called immune checkpoint molecules that protect cancer cells against being attacked by the immune system. However, the subsequent exposure to DHA resulted in a significant drop in immune checkpoint molecules, and the cells’ normal miRNA expression was upregulated.
Based on their findings, the scientists concluded that supplementation with DHA is useful as part of the treatment of breast cancer because DHA helps regulate several different molecules that are relevant for the pathogenic development of the disease.
The new study is published in BMC Nutrition, and the authors say their results provide new insight into DHA’s potential in breast cancer therapy.
EPA and DHA, which are found in oily fish and fish oil supplements, also help to prevent breast cancer.

  • Far fewer women in Northern Europe and USA get breast cancer compared with Asia and Africa
  • This is primarily because of western diets and lifestyles. If Asians and Africans move to Europe or the US, their risk of breast cancer increases correspondingly
  • Western diets contain too little omega-3 from oily fish and too much omega-6 from plant oils, margarine, deep-fried food, and ready meals. This increases the risk of chronic inflammation and other metabolic disturbances.
  • The omega-3 fatty acid, DHA, which is found in oily fish and fish oil supplements, has a preventative and therapeutic effect

Vitamin D, selenium, and iodine have other preventative mechanisms

Breast cancer seems to be a result of being deficient in one or several nutrients that are important for cellular gene expression, regulation of inflammation, hormone balance, and antioxidant defense.

Read more:
»Breast cancer: Common deficiencies of a few nutrients increase the risk of breast cancer and lethal metastases«

References:

Sepideh Maralbashi et al. Docosahexaenoic acid (DHA) impairs hypoxia-induced cellular and exosomal overexpression of immune-checkpoints and immunomodulatory molecules in different subtypes of breast cancer cells. BMC Nutrition 2024

Dorota Dydjow-Bendek and Pawel Zagozdzon. Total Dietary, Fatty Acids, and omega-3/omega-6 Ratio as Risk Factors of Breast Cancer in the Polish Population – a Case-Control study. In Vivo January-February 2020

Sarawoti Khadge et al. Long-chain omega-3 polysaturated fatty acids decrease mammary tumor growth, multiorgan metastatis and enhance survival. Clin Exp Metastasis. 2018




  • Created on .
9.357MBMemory Usage2.67sRequest 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" => 1740257083 "last" => 1740257083...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.53KB) (752μs)
  • afterInitialise (1.27MB) (124ms)
  • afterRoute (897.2KB) (32.79ms)
  • beforeRenderComponent com_content (23.02KB) (5.2ms)
  • Before Access::preloadComponents (all components) (33.23KB) (293μs)
  • After Access::preloadComponents (all components) (97.34KB) (3.06ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (23μs)
  • After Access::preloadPermissions (com_content) (3.2MB) (46.55ms)
  • Before Access::getAssetRules (id:8799 name:com_content.article.4601) (130.65KB) (8.42ms)
  • After Access::getAssetRules (id:8799 name:com_content.article.4601) (7.38KB) (66μs)
  • beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.35MB) (181ms)
  • afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (585.98KB) (343ms)
  • beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (332μs)
  • afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (191μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (3.62KB) (72μs)
  • afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (295μs)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (4μs)
  • afterRenderModule mod_custom (Search for more information...) (4.57KB) (40μs)
  • afterRenderComponent com_content (36.27KB) (234ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.98KB) (36.76ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (41μs)
  • afterDispatch (27.38KB) (6.26ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (2.42ms)
  • afterRenderRawModule mod_articles_category (READ MORE...) (76.71KB) (711ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (159μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (46μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (13μs)
  • afterRenderRawModule mod_tags_popular (Search) (18.74KB) (872ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (27μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (50μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (11μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (22μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (4.03ms)
  • afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (51μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (13μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (23μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (10μs)
  • afterRenderModule mod_tags_popular (Search) (1.27KB) (19μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (9μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (18μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (8μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (17μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (352μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (190.66KB) (2.99ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (52μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (18μs)
  • afterRenderRawModule mod_languages (Sprogskift) (90.29KB) (9.91ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (5μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (19μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (13μs)
  • afterRenderRawModule mod_finder () (64.95KB) (13.06ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (3.29KB) (31μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (1.17ms)
  • afterRenderRawModule mod_custom () (21.98KB) (4.03ms)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.23KB) (44μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (99μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (1.79ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (5μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (48μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (19μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (635μs)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (4μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (27μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (8μs)
  • afterRenderRawModule mod_finder () (6.29KB) (9.45ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.23KB) (43μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (171μs)
  • afterRenderRawModule mod_custom () (944B) (130μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (23μs)
  • beforeRenderRawModule mod_custom () (688B) (74μs)
  • afterRenderRawModule mod_custom () (896B) (1.33ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.71KB) (26μs)
  • afterRender (194.25KB) (11.16ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (18.74KB) (32.65%)
    872.29ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (76.71KB) (26.62%)
    711.31ms
    1 x afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (585.98KB) (12.85%)
    343.23ms
    1 x afterRenderComponent com_content (36.27KB) (8.76%)
    234.03ms
    1 x beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.35MB) (6.78%)
    181.24ms
    1 x afterInitialise (1.27MB) (4.65%)
    124.19ms
    1 x After Access::preloadPermissions (com_content) (3.2MB) (1.74%)
    46.55ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.98KB) (1.38%)
    36.76ms
    1 x afterRoute (897.2KB) (1.23%)
    32.79ms
    1 x afterRenderRawModule mod_finder () (64.95KB) (0.49%)
    13.06ms
    1 x afterRender (194.25KB) (0.42%)
    11.16ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (90.29KB) (0.37%)
    9.91ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.35%)
    9.45ms
    1 x Before Access::getAssetRules (id:8799 name:com_content.article.4601) (130.65KB) (0.32%)
    8.42ms
    1 x afterDispatch (27.38KB) (0.23%)
    6.26ms
    1 x beforeRenderComponent com_content (23.02KB) (0.19%)
    5.20ms
    1 x afterRenderRawModule mod_custom () (21.98KB) (0.15%)
    4.03ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (0.15%)
    4.03ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.11%)
    3.06ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (190.66KB) (0.11%)
    2.99ms
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.09%)
    2.42ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.07%)
    1.79ms
    1 x afterRenderRawModule mod_custom () (896B) (0.05%)
    1.33ms
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.04%)
    1.17ms
    1 x afterLoad (456.53KB) (0.03%)
    752μs
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.02%)
    635μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (0.01%)
    352μs
    1 x beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (0.01%)
    332μs
    1 x afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (0.01%)
    295μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.01%)
    293μs
    1 x afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (0.01%)
    191μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.01%)
    171μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    159μs
    1 x afterRenderRawModule mod_custom () (944B) (0%)
    130μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0%)
    99μs
    1 x beforeRenderRawModule mod_custom () (688B) (0%)
    74μs
    1 x beforeRenderRawModule mod_custom (Search for more information...) (3.62KB) (0%)
    72μs
    1 x After Access::getAssetRules (id:8799 name:com_content.article.4601) (7.38KB) (0%)
    66μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0%)
    52μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (0%)
    51μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0%)
    50μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0%)
    48μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0%)
    46μs
    1 x afterRenderModule mod_custom () (1.23KB) (0%)
    44μs
    1 x afterRenderModule mod_finder () (1.23KB) (0%)
    43μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0%)
    41μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.57KB) (0%)
    40μs
    1 x afterRenderModule mod_finder () (3.29KB) (0%)
    31μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    27μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0%)
    27μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    26μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    23μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    23μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    23μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0%)
    22μs
    1 x afterRenderModule mod_tags_popular (Search) (1.27KB) (0%)
    19μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    19μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    18μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    17μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    13μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    13μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    12μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    10μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    8μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    4μs
76 statements were executed, 39 of which were duplicates, 37 unique2.14s1.2MB
  • SELECT @@SESSION.sql_mode;69μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?2.18ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 1328μ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)6.98ms944BParams/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` = 1268μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`1.15ms656B/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` = :guest180μ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`956μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC6.56ms2.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` = 1213μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config4.04ms1.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`4.54ms165.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`405μ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` = 16.16ms848B/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)580μ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` = 016.63ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`7.54ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '4601'6.88ms48B/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)6.08ms22.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`429μ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)17.04ms4.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`3.57ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM has_fields AS a LEFT JOIN `has_languages` AS l ON l.lang_code = a.language LEFT JOIN has_users AS uc ON uc.id=a.checked_out LEFT JOIN has_viewlevels AS ag ON ag.id = a.access LEFT JOIN has_users AS ua ON ua.id = a.created_user_id LEFT JOIN has_fields_groups AS g ON g.id = a.group_id LEFT JOIN `has_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC1.43ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.79ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id7.52ms1.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`8.45ms180.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `t`.`id` FROM `has_tags` AS `t` INNER JOIN `has_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)68.08ms1.38KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,COUNT( `tag_id`) AS `count`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_tags` AS `t` ON `m`.`tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `cc` ON `m`.`core_content_id` = `cc`.`core_content_id` INNER JOIN `has_content_types` AS `ct` ON `m`.`type_alias` = `ct`.`type_alias` WHERE ( ( ( (`m`.`tag_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4) AND `t`.`access` IN (:preparedArray5,:preparedArray6) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray7,:preparedArray8) OR `cc`.`core_access` = 0)) AND (`m`.`content_item_id` <> :currentId OR `m`.`type_alias` <> :prefix)) AND (`cc`.`core_publish_up` IS NULL OR `cc`.`core_publish_up` = :nullDateUp OR `cc`.`core_publish_up` <= :nowDateUp)) AND (`cc`.`core_publish_down` IS NULL OR `cc`.`core_publish_down` = :nullDateDown OR `cc`.`core_publish_down` >= :nowDateDown) AND `cc`.`core_language` IN (:preparedArray9,:preparedArray10) GROUP BY `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` ORDER BY `count` DESC, RAND() LIMIT 1542.74ms19.34KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:200Copy
  • 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`10.96ms3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id242μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id9.72ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id5.69ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id156μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id7.86ms1.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 `alias` FROM `has_content` WHERE `id` = :id1.62ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id6.64ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id135μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id91μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.96ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.89ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.14ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.83ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id9.52ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.62ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id5.87ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id174μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id4.93ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id3.96ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id2.43ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id4.52ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id8.83ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id108μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id831μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.03ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id9.95ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.67ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id156μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id908μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 DESC205ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 15.92ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0809μs704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id10.14ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id179μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `has_content` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `has_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-02-22 20:44:43') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-02-22 20:44:43') AND c2.state = 15.59ms12.47KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `has_content` AS `a` LEFT JOIN `has_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `has_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `has_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `has_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `has_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `has_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY RAND() ASC LIMIT 10694ms151.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 `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 15862ms2.75KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `has_menu` AS `c` INNER JOIN `has_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `has_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `has_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id1.96ms1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1931μ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)135μ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 ASC805μ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)1.07ms584B/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` = 1117μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`5.47ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?129μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?10.77ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy