Skip to main content

Vitamin A’s key role in wound healing and stem cell biology

Vitamin A’s key role in wound healing and stem cell biologyIn the case of wounds or skin lesions, an active form of vitamin A regulates how stem cells initiate healing processes and produce new skin. This was demonstrated in a study from Rockefeller University that is published in the journal Science. In the future, researchers plan to look closer at how active vitamin A can be used to regulate stem cells as a way of preventing and treating skin cancer.

The outer skin layer (epidermis) contains stem cells that gradually develop the other protective skin layers within a period of a month. If you fall and scrape your knee or elbow against the ground, the body immediately begins a healing process to seal off the injured skin and repair the damaged epidermis. Some of the stem cells from the epidermis enter the sore to support the healing process. Previous stem cells from hair follicles that are normally responsible for hair growth, also participate in the healing process. In order to do this, however, the hair follicle stem cells have to enter a special development phase through a process known as linear plasticity.
The team of scientists from Rockefeller University found that the biologically active form of vitamin A known as retinoic acid plays a key role in the linear plasticity and development of stem cells in connection with healing processes.

Wound healing and cell division must be controlled

Earlier studies have looked at linear plasticity as a natural response to wound healing, and it is particularly easy to study this phenomenon in skin injuries. Scientists have found that stem cells from hair follicles are the first to participate in the healing process.
When the scientists from Rockefeller University looked closer at the processes, they found that linear plasticity can be both beneficial and harmful. As mentioned earlier, linear plasticity is useful for wound healing, but if the process is not carefully regulated, the cell division risks spinning out control so different cancer forms can develop.
To get a better understanding of how linear plasticity works, the researchers studied hair follicle stem cells from mice under conditions that resembled a wound healing process. They were surprised to see that retinoic acid played such a crucial role in helping the stem cells carry out linear plasticity correctly.
It is commonly known that vitamin A contributes to skin health, and the researchers conducted both in vitro- and in vivo-studies to see how the vitamin affected wound healing. Diet and genetic factors can also affect the body’s ability to utilize vitamin A and influence how stem cells initiate healing processes and hair growth.
In addition, the active form of vitamin A collaborates with other molecules such as BMP (bone morphogenetic protein) and WNT (wingless-related integration site). This affects whether stem cells remain inactive or participate actively in wound healing and hair growth.
Still, vitamin A therapy has shown conflicting results. Treatment with retinoic acid can stimulate new hair growth in connection with wound healing, whereas too much retinoic acid can cause alopecia. In the future, researchers therefore want to look closer at how much vitamin A we need to help stem cells and wound healing function optimally. Also, they want to see how vitamin A affects other tissues.

Vitamin A from food and in its active form

In animal foods like butter, egg yolks, and oily fish, vitamin A occurs as retinol, which is considered pure vitamin A. Vegetable sources like carrots and spinach contain beta-carotene, a vitamin A precursor that is converted into retinol in the body. Retinol is stored in the liver. Our skin and many other tissues receive retinol and convert it into retinoic acid, which is needed for stem cells and their linear plasticity and for wound healing.

Cancer and regulation of linear plasticity

In the future, scientists also want to see how active vitamin A affects linear plasticity in connection with cancer, especially basal cell carcinoma and squamous cell cancer.
Cancer stem cells are derailed. According to the scientists, this may be a result of errors in the coding of the stem cells’ linear plasticity.
In basal cell carcinoma, which is far less aggressive than squamous cell cancer, the linear plasticity is relatively limited. The researchers therefore see a therapeutic potential if future studies demonstrate that retinoic acid can help inhibit linear plasticity. This process may be a key factor in the battle against cancer cells. Also, inhibiting linear plasticity may improve the prognosis.

References:

Matthew T. Tierny et al. Vitamin A resolves lineage plasticity to orchestrate stem cell lineage choices. Science, 2024

Rockefeller University. Vitamin A may play a central role in stem cell biology and wound repair. ScienceDaily 2024


  • Created on .
9.375MBMemory Usage632msRequest 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" => 1744576938 "last" => 1744576938...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (456.5KB) (3.65ms)
  • afterInitialise (1.27MB) (55.55ms)
  • afterRoute (897.2KB) (22.11ms)
  • beforeRenderComponent com_content (23.1KB) (3.76ms)
  • Before Access::preloadComponents (all components) (33.23KB) (312μs)
  • After Access::preloadComponents (all components) (97.34KB) (1.56ms)
  • Before Access::preloadPermissions (com_content) (1.6KB) (16μs)
  • After Access::preloadPermissions (com_content) (3.23MB) (21.54ms)
  • Before Access::getAssetRules (id:8625 name:com_content.article.4429) (130.65KB) (2.6ms)
  • After Access::getAssetRules (id:8625 name:com_content.article.4429) (7.38KB) (75μs)
  • beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.34MB) (65.79ms)
  • afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (581.63KB) (61.18ms)
  • beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (11μs)
  • afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (124μs)
  • beforeRenderRawModule mod_custom (Search for more information...) (3.62KB) (47μs)
  • afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (1.35ms)
  • beforeRenderModule mod_custom (Search for more information...) (736B) (8μs)
  • afterRenderModule mod_custom (Search for more information...) (4.32KB) (63μs)
  • afterRenderComponent com_content (36.5KB) (33.69ms)
  • Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (7.96ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (42μs)
  • afterDispatch (27.45KB) (3.8ms)
  • beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (568μs)
  • afterRenderRawModule mod_articles_category (READ MORE...) (93.05KB) (146ms)
  • beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (38μs)
  • afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (54μs)
  • beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (14μs)
  • afterRenderRawModule mod_tags_popular (Search) (45.5KB) (154ms)
  • beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (29μs)
  • afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (56μs)
  • beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (11μs)
  • afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (33μs)
  • beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (10.81ms)
  • afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (68μs)
  • beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (16μs)
  • afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (26μs)
  • beforeRenderModule mod_tags_popular (Search) (1.98KB) (13μs)
  • afterRenderModule mod_tags_popular (Search) (1.27KB) (21μs)
  • beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (11μs)
  • afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (20μs)
  • beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (10μs)
  • afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (19μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (435μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (190.66KB) (5.86ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (6μs)
  • afterRenderModule mod_menu (Main Menu - English) (4.86KB) (72μs)
  • beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (24μs)
  • afterRenderRawModule mod_languages (Sprogskift) (90.2KB) (4.97ms)
  • beforeRenderModule mod_languages (Sprogskift) (720B) (7μs)
  • afterRenderModule mod_languages (Sprogskift) (5.31KB) (24μs)
  • beforeRenderRawModule mod_finder () (6.34KB) (14μs)
  • afterRenderRawModule mod_finder () (64.95KB) (6.18ms)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (3.29KB) (45μs)
  • beforeRenderRawModule mod_custom () (6.62KB) (943μs)
  • afterRenderRawModule mod_custom () (21.95KB) (1.54ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.23KB) (63μs)
  • beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (419μs)
  • afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (2.06ms)
  • beforeRenderModule mod_menu (Main Menu - English) (720B) (8μs)
  • afterRenderModule mod_menu (Main Menu - English) (1.25KB) (71μs)
  • beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (24μs)
  • afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (2.2ms)
  • beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (9μs)
  • afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (45μs)
  • beforeRenderRawModule mod_finder () (2.3KB) (15μs)
  • afterRenderRawModule mod_finder () (6.29KB) (1.03ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (1.23KB) (59μs)
  • beforeRenderRawModule mod_custom () (8.66KB) (216μs)
  • afterRenderRawModule mod_custom () (944B) (187μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (27μs)
  • beforeRenderRawModule mod_custom () (688B) (87μs)
  • afterRenderRawModule mod_custom () (896B) (96μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.71KB) (22μs)
  • afterRender (156.41KB) (7.9ms)
  • 1 x afterRenderRawModule mod_tags_popular (Search) (45.5KB) (24.31%)
    153.73ms
    1 x afterRenderRawModule mod_articles_category (READ MORE...) (93.05KB) (23.13%)
    146.26ms
    1 x beforeRenderRawModule mod_tags_similar (TIP! See also the related articles) (1.34MB) (10.4%)
    65.79ms
    1 x afterRenderRawModule mod_tags_similar (TIP! See also the related articles) (581.63KB) (9.67%)
    61.18ms
    1 x afterInitialise (1.27MB) (8.79%)
    55.55ms
    1 x afterRenderComponent com_content (36.5KB) (5.33%)
    33.69ms
    1 x afterRoute (897.2KB) (3.5%)
    22.11ms
    1 x After Access::preloadPermissions (com_content) (3.23MB) (3.41%)
    21.54ms
    1 x beforeRenderModule mod_articles_category (READ MORE...) (276.94KB) (1.71%)
    10.81ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (49.8KB) (1.26%)
    7.96ms
    1 x afterRender (156.41KB) (1.25%)
    7.90ms
    1 x afterRenderRawModule mod_finder () (64.95KB) (0.98%)
    6.18ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (190.66KB) (0.93%)
    5.86ms
    1 x afterRenderRawModule mod_languages (Sprogskift) (90.2KB) (0.79%)
    4.97ms
    1 x afterDispatch (27.45KB) (0.6%)
    3.80ms
    1 x beforeRenderComponent com_content (23.1KB) (0.6%)
    3.76ms
    1 x afterLoad (456.5KB) (0.58%)
    3.65ms
    1 x Before Access::getAssetRules (id:8625 name:com_content.article.4429) (130.65KB) (0.41%)
    2.60ms
    1 x afterRenderRawModule mod_languages (Sprogskift Mobil) (3.89KB) (0.35%)
    2.20ms
    1 x afterRenderRawModule mod_menu (Main Menu - English) (6.52KB) (0.33%)
    2.06ms
    1 x After Access::preloadComponents (all components) (97.34KB) (0.25%)
    1.56ms
    1 x afterRenderRawModule mod_custom () (21.95KB) (0.24%)
    1.54ms
    1 x afterRenderRawModule mod_custom (Search for more information...) (3.83KB) (0.21%)
    1.35ms
    1 x afterRenderRawModule mod_finder () (6.29KB) (0.16%)
    1.03ms
    1 x beforeRenderRawModule mod_custom () (6.62KB) (0.15%)
    943μs
    1 x beforeRenderRawModule mod_articles_category (READ MORE...) (32.27KB) (0.09%)
    568μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (22.53KB) (0.07%)
    435μs
    1 x beforeRenderRawModule mod_menu (Main Menu - English) (5.07KB) (0.07%)
    419μs
    1 x Before Access::preloadComponents (all components) (33.23KB) (0.05%)
    312μs
    1 x beforeRenderRawModule mod_custom () (8.66KB) (0.03%)
    216μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    187μs
    1 x afterRenderModule mod_tags_similar (TIP! See also the related articles) (6.93KB) (0.02%)
    124μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    96μs
    1 x beforeRenderRawModule mod_custom () (688B) (0.01%)
    87μs
    1 x After Access::getAssetRules (id:8625 name:com_content.article.4429) (7.38KB) (0.01%)
    75μs
    1 x afterRenderModule mod_menu (Main Menu - English) (4.86KB) (0.01%)
    72μs
    1 x afterRenderModule mod_menu (Main Menu - English) (1.25KB) (0.01%)
    71μs
    1 x afterRenderModule mod_articles_category (READ MORE...) (2.5KB) (0.01%)
    68μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    63μs
    1 x afterRenderModule mod_custom (Search for more information...) (4.32KB) (0.01%)
    63μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    59μs
    1 x afterRenderRawModule mod_custom (Check this before you buy a Q10 product) (928B) (0.01%)
    56μs
    1 x afterRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (912B) (0.01%)
    54μs
    1 x beforeRenderRawModule mod_custom (Search for more information...) (3.62KB) (0.01%)
    47μs
    1 x afterRenderModule mod_languages (Sprogskift Mobil) (3.77KB) (0.01%)
    45μs
    1 x afterRenderModule mod_finder () (3.29KB) (0.01%)
    45μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    42μs
    1 x beforeRenderRawModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.45KB) (0.01%)
    38μs
    1 x afterRenderRawModule mod_custom (the Vitamin and Mineral Guide) (992B) (0.01%)
    33μs
    1 x beforeRenderRawModule mod_custom (Check this before you buy a Q10 product) (944B) (0%)
    29μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    27μs
    1 x afterRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (1.28KB) (0%)
    26μs
    1 x beforeRenderRawModule mod_languages (Sprogskift) (3.94KB) (0%)
    24μs
    1 x afterRenderModule mod_languages (Sprogskift) (5.31KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_languages (Sprogskift Mobil) (912B) (0%)
    24μs
    1 x afterRenderModule mod_custom () (2.71KB) (0%)
    22μs
    1 x afterRenderModule mod_tags_popular (Search) (1.27KB) (0%)
    21μs
    1 x afterRenderModule mod_custom (Check this before you buy a Q10 product) (1.28KB) (0%)
    20μs
    1 x afterRenderModule mod_custom (the Vitamin and Mineral Guide) (1.28KB) (0%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.6KB) (0%)
    16μs
    1 x beforeRenderModule mod_custom (BOOST YOUR IMMUNE DEFENSE) (6.81KB) (0%)
    16μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    15μs
    1 x beforeRenderRawModule mod_finder () (2.3KB) (0%)
    15μs
    1 x beforeRenderRawModule mod_tags_popular (Search) (2.36KB) (0%)
    14μs
    2 x beforeRenderModule mod_menu (Main Menu - English) (720B) (0%)
    14μs
    1 x beforeRenderRawModule mod_finder () (6.34KB) (0%)
    14μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    14μs
    1 x beforeRenderModule mod_tags_popular (Search) (1.98KB) (0%)
    13μs
    1 x beforeRenderModule mod_tags_similar (TIP! See also the related articles) (752B) (0%)
    11μs
    1 x beforeRenderRawModule mod_custom (the Vitamin and Mineral Guide) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Check this before you buy a Q10 product) (1.31KB) (0%)
    11μs
    1 x beforeRenderModule mod_custom (the Vitamin and Mineral Guide) (352B) (0%)
    10μs
    1 x beforeRenderModule mod_languages (Sprogskift Mobil) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Search for more information...) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_languages (Sprogskift) (720B) (0%)
    7μs
77 statements were executed, 37 of which were duplicates, 40 unique418ms1.21MB
  • SELECT @@SESSION.sql_mode;55μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `has_session` WHERE `session_id` = ?208μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = :session_id LIMIT 190μ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)5.06ms944BParams/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` = 12.53ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `has_viewlevels`1.81ms656B/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` = :guest193μ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`3.5ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `has_languages` WHERE `published` = 1 ORDER BY `ordering` ASC215μ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` = 1645μs1008B/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM has_rsform_config186μ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`2.69ms165.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`2.13ms3.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` = 12.08ms848B/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)443μ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` = 08.17ms397.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `has_content`5.29ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `has_content` SET `hits` = (`hits` + 1) WHERE `id` = '4429'4.61ms48B/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)1.45ms22.19KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`2.86ms3.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)6.51ms4.11KBParams/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`433μ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 ASC404μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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` = :id154μ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`7.47ms180.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)11.47ms1.4KBParams/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,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray8,:preparedArray9) 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 (:preparedArray10,:preparedArray11) 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 156.11ms20.66KBParams/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`407μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.64ms4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id124μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id129μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id93μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id329μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id162μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id284μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id192μ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 `alias` FROM `has_content` WHERE `id` = :id895μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.2ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id145μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id171μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id228μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.05ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id213μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id142μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id352μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id133μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.47ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id148μ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` = :id89μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id607μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id141μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id86μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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`448μs4KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id1.46ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id190μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id86μ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 DESC24.7ms161.75KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT custom_data FROM has_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 13.95ms536B/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `language`,`id` FROM `has_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 01.96ms704B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id134μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `has_content` WHERE `id` = :id196μ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-04-13 20:42:18') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-13 20:42:18') AND c2.state = 12.45ms12.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 10139ms151.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`630μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `has_categories` AS `s` INNER JOIN `has_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`658μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `has_contentitem_tag_map` AS `m` INNER JOIN `has_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `has_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `has_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `has_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `t`.`language` IN (:preparedArray3,:preparedArray4) AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray5,:preparedArray6) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 15150ms2.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` = :id269μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `has_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1213μ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)184μ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 ASC776μ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)208μ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` = 1192μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `has_session` WHERE `session_id` = ?117μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `has_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.61ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy