Ruïms erstes Solowerk "Black Royal Spiritism" ist ein wahrhaftig beeindruckendes und einzigartiges Album. Die Tatsache, dass Rune "Blasphemer" Eriksen, der heimliche musikalische Triebfeder von Mayhem, dieses Projekt leitet, macht es noch faszinierender. Als Mitbegründer von Aura Noir, einer der langlebigsten Black-Thrash-Combos, zeigt Eriksen erneut seine aussergewöhnliche kreative Fähigkeit.

"Black Royal Spiritism" präsentiert einen Black Metal-Sound mit hoher Dissonanz und einigen überraschenden harmonischen Elementen. Die musikalische Atmosphäre, die Ruïm geschaffen hat, ist düster und beklemmend, sie zieht den Hörer unmittelbar in ihren Bann. Es ist eine wahre Achterbahnfahrt der Emotionen, die einen in eine Welt des Chaos und der Zerstörung entführt.

Dieses Album ist der erste Teil einer geplanten Trilogie, und die Texte wurden von der mystisch-spirituellen Umbanda-Religion inspiriert. Diese Einflüsse verleihen "Black Royal Spiritism" eine mystische und spirituelle Tiefe, die es von anderen Veröffentlichungen abhebt. Die düsteren und verstörenden Gesänge, zusammen mit der hypnotischen Instrumentierung, erzeugen eine beunruhigende Atmosphäre, die das gesamte Werk durchzieht.

Es ist unvermeidlich, Vergleiche mit Grössen wie Deathspell Omega, Farsot und natürlich Mayhem anzustellen. Doch Ruïm gelingt es, einen einzigartigen Sound zu kreieren, der seine eigene Identität hat. Die Komplexität und technische Raffinesse auf "Black Royal Spiritism" sind atemberaubend. Jeder Song ist eine Symphonie des Chaos, mit rasenden Blast Beats, wütenden Gitarrenriffs und einer düsteren, bedrohlichen Stimmung.

Dieses Album ist zweifellos ein Meisterwerk des Black Metal-Genres. Ruïm hat die Grenzen dieser musikalischen Ausdrucksform erweitert und eine aussergewöhnliche Platte geschaffen, die gleichermaßen intensiv und fesselnd ist. "Black Royal Spiritism" ist ein einzigartiger Hörgenuss, der den Hörer mit seiner unglaublichen Energie und Leidenschaft erfüllt.

Wenn du nach Musik suchst, die dich in eine andere Dimension des Black Metal entführt, dann ist "Black Royal Spiritism" ein absolutes Muss. Ruïm hat mit diesem Album eine herausragende Leistung erbracht und lässt uns voller Vorfreude auf die Fortsetzung der Trilogie warten. Tauche ein in die düstere Welt von Ruïm und lasse dich von der Brillanz dieses Werks überwältigen.

Albuminfo

Punkte

 

4/5

Label

 

Peaceville

Veröffentlichung

 

05/2023

Format

 

CD

Land

  Norwegen/Portugal

Genre

 

Black Metal

 

Tracklist

1. Blood.Sacrifice.Enthronement
2. The Triumph (Of Night & Fire)
3. The Black House
4. Black Royal Spiritism
5. Evig Dissonans
6. Fall Of Seraphs
7. Ao Rio
8. O Sino da Igreja

8MBMemory Usage283msRequest Duration
Joomla! Version4.3.4
PHP Version8.0.30
Identityguest
Response200
Templatea4joomla-dark
Database
Server
mysql
Version
10.6.18-MariaDB-0ubuntu0.22.04.1
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:51 [ "USER" => "flamboyant" "HOME" => "/var/www/vhosts/flamboyant-hertz.92-205-176-165.ple...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749925415 "last" => 1749925415...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://www.flamboyant-hertz.92-205-176-165.plesk.page/index.php/kritike...
  • afterLoad (553.37KB) (6.3ms)
  • afterInitialise (1.61MB) (48.5ms)
  • afterRoute (246.41KB) (11.04ms)
  • beforeRenderComponent com_content (320.61KB) (8.64ms)
  • Before Access::preloadComponents (all components) (120.59KB) (2.88ms)
  • After Access::preloadComponents (all components) (102.56KB) (1.57ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (22μs)
  • After Access::preloadPermissions (com_content) (212.72KB) (1.51ms)
  • Before Access::getAssetRules (id:500 name:com_content.article.5074) (18.8KB) (33μs)
  • After Access::getAssetRules (id:500 name:com_content.article.5074) (9.73KB) (311μs)
  • afterRenderComponent com_content (585.26KB) (63.54ms)
  • afterDispatch (3.14KB) (142μs)
  • beforeRenderRawModule mod_menu (Info Menu) (291.38KB) (5.19ms)
  • afterRenderRawModule mod_menu (Info Menu) (38.98KB) (3.2ms)
  • beforeRenderModule mod_menu (Info Menu) (704B) (7μs)
  • afterRenderModule mod_menu (Info Menu) (2.9KB) (245μs)
  • beforeRenderRawModule mod_login (Anmeldung) (832B) (43μs)
  • afterRenderRawModule mod_login (Anmeldung) (163.83KB) (5.73ms)
  • beforeRenderModule mod_login (Anmeldung) (720B) (9μs)
  • afterRenderModule mod_login (Anmeldung) (9.91KB) (165μs)
  • beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (55μs)
  • afterRenderRawModule mod_tags_popular (Tags) (42.51KB) (7.57ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (12μs)
  • afterRenderModule mod_tags_popular (Tags) (3.45KB) (274μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (81μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.7KB) (1.44ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (8μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.66KB) (423μs)
  • beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (63μs)
  • afterRenderRawModule mod_menu (Hauptmenü) (221.19KB) (7.82ms)
  • beforeRenderModule mod_menu (Hauptmenü) (720B) (15μs)
  • afterRenderModule mod_menu (Hauptmenü) (3.68KB) (261μs)
  • beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (287.97KB) (13.58ms)
  • Before Access::getAssetRules (id:8 name:com_content) (74.41KB) (3.61ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (16μs)
  • afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (19.15KB) (75.63ms)
  • beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (12μs)
  • afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (14.41KB) (208μs)
  • afterRender (75.84KB) (704μs)
  • 1 x afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (19.15KB) (26.72%)
    75.63ms
    1 x afterRenderComponent com_content (585.26KB) (22.45%)
    63.54ms
    1 x afterInitialise (1.61MB) (17.13%)
    48.50ms
    1 x beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (287.97KB) (4.8%)
    13.58ms
    1 x afterRoute (246.41KB) (3.9%)
    11.04ms
    1 x beforeRenderComponent com_content (320.61KB) (3.05%)
    8.64ms
    1 x afterRenderRawModule mod_menu (Hauptmenü) (221.19KB) (2.76%)
    7.82ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (42.51KB) (2.67%)
    7.57ms
    1 x afterLoad (553.37KB) (2.23%)
    6.30ms
    1 x afterRenderRawModule mod_login (Anmeldung) (163.83KB) (2.02%)
    5.73ms
    1 x beforeRenderRawModule mod_menu (Info Menu) (291.38KB) (1.83%)
    5.19ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (74.41KB) (1.27%)
    3.61ms
    1 x afterRenderRawModule mod_menu (Info Menu) (38.98KB) (1.13%)
    3.20ms
    1 x Before Access::preloadComponents (all components) (120.59KB) (1.02%)
    2.88ms
    1 x After Access::preloadComponents (all components) (102.56KB) (0.56%)
    1.57ms
    1 x After Access::preloadPermissions (com_content) (212.72KB) (0.53%)
    1.51ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.7KB) (0.51%)
    1.44ms
    1 x afterRender (75.84KB) (0.25%)
    704μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.66KB) (0.15%)
    423μs
    1 x After Access::getAssetRules (id:500 name:com_content.article.5074) (9.73KB) (0.11%)
    311μs
    1 x afterRenderModule mod_tags_popular (Tags) (3.45KB) (0.1%)
    274μs
    1 x afterRenderModule mod_menu (Hauptmenü) (3.68KB) (0.09%)
    261μs
    1 x afterRenderModule mod_menu (Info Menu) (2.9KB) (0.09%)
    245μs
    1 x afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (14.41KB) (0.07%)
    208μs
    1 x afterRenderModule mod_login (Anmeldung) (9.91KB) (0.06%)
    165μs
    1 x afterDispatch (3.14KB) (0.05%)
    142μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (0.03%)
    81μs
    1 x beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (0.02%)
    63μs
    1 x beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (0.02%)
    55μs
    1 x beforeRenderRawModule mod_login (Anmeldung) (832B) (0.02%)
    43μs
    1 x Before Access::getAssetRules (id:500 name:com_content.article.5074) (18.8KB) (0.01%)
    33μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    22μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_menu (Hauptmenü) (720B) (0.01%)
    15μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (0%)
    12μs
    1 x beforeRenderModule mod_login (Anmeldung) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (Info Menu) (704B) (0%)
    7μs
33 statements were executed, 7 of which were duplicates, 26 unique120ms1.18MB
  • SELECT @@SESSION.sql_mode;1.3ms1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `sm_session` WHERE `session_id` = ?227μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `sm_session` WHERE `session_id` = :session_id LIMIT 180μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `sm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.07ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `sm_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1429μs20.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `sm_viewlevels`103μs1.11KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `sm_usergroups` AS `a` LEFT JOIN `sm_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest130μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `sm_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`617μs16.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT id FROM sm_yendifvideoshare_imports WHERE state = 1 AND next_import_date IS NOT NULL AND next_import_date != '0000-00-00 00:00:00' AND next_import_date <= '2025-06-14 18:23:35' LIMIT 1270μs2.07KB/plugins/system/yendifvideoshare/yendifvideoshare.php:75Copy
  • 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 `sm_menu` AS `m` LEFT JOIN `sm_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`580μs28.92KBParams/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 `sm_categories` AS `s` INNER JOIN `sm_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`508μs6.62KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `sm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC219μs2.44KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `sm_template_styles` AS `s` LEFT JOIN `sm_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` = 1357μs1.33KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `sm_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,:preparedArray41)654μs10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `sm_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0556μs49.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sm_content`905μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `sm_content` SET `hits` = (`hits` + 1) WHERE `id` = '5074'1.87ms2.55KB/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 `sm_content` AS `a` INNER JOIN `sm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sm_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sm_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) 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 (:preparedArray1,:preparedArray2)816μs25.38KBParams/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 `sm_categories` AS `s` INNER JOIN `sm_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`723μs6.67KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_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)1.75ms5.73KBParams/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 `sm_categories` AS `s` INNER JOIN `sm_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`660μs6.67KBParams/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 sm_fields AS a LEFT JOIN `sm_languages` AS l ON l.lang_code = a.language LEFT JOIN sm_users AS uc ON uc.id=a.checked_out LEFT JOIN sm_viewlevels AS ag ON ag.id = a.access LEFT JOIN sm_users AS ua ON ua.id = a.created_user_id LEFT JOIN sm_fields_groups AS g ON g.id = a.group_id LEFT JOIN `sm_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 ORDER BY a.ordering ASC1.32ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `sm_content` AS `a` LEFT JOIN `sm_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) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC24.31ms918.03KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • 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 `sm_categories` AS `s` INNER JOIN `sm_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`471μs6.67KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `sm_modules` AS `m` LEFT JOIN `sm_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `sm_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) ORDER BY `m`.`position`,`m`.`ordering`623μs2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id260μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id120μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `sm_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `sm_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `sm_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 `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray3,:preparedArray4) 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 `count` DESC LIMIT 105.59ms3.53KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `sm_scheduler_tasks` AS `a` LEFT JOIN `sm_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc352μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `sm_scheduler_tasks` AS `a` LEFT JOIN `sm_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc250μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_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)1.58ms5.73KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `sm_content` AS `a` LEFT JOIN `sm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sm_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `sm_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `sm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sm_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` INNER JOIN `sm_contentitem_tag_map` AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id` AND `tagmap`.`type_alias` = 'com_content.article' WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` NOT IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `tagmap`.`tag_id` = :tagId ORDER BY RAND() ASC LIMIT 369.67ms28.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `sm_contentitem_tag_map` AS `m` INNER JOIN `sm_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `t`.`access` IN (:preparedArray4,:preparedArray5)1.35ms17.86KBParams/libraries/src/Helper/TagsHelper.php:448Copy