Die Avantgarde Black Metal-Band Porta Nigra aus Koblenz hat mit "Weltende" ihr viertes Album veröffentlicht, und es ist zweifellos ein kraftvolles und eindringliches Werk. Die Band präsentiert uns hier ein düsteres Konzeptalbum, das sich einem der dunkelsten Kapitel der Geschichte widmet - den Schlachtfeldern des Ersten Weltkrieges. Dabei schaffen sie es, die Aspekte des Krieges und die daraus resultierenden emotionalen Turbulenzen perfekt zu transportieren.

Die Idee, sich von der expressionistischen Kunst und Literatur dieser Zeit inspirieren zu lassen, ist faszinierend und ergibt eine beeindruckende musikalische Reise in die Vergangenheit. Porta Nigra würdigen Autoren wie Georg Heym, Jakob van Hoddis, Georg Trakl und Gottfried Benn, die in ihren Werken drastische Metaphern von Krieg, Tod und Verfall zeichneten und somit das morbide Bild einer bedrohlichen Welt schufen. Das Album zollt diesen talentierten Künstlern und ihren düsteren Visionen einen respektvollen Tribut.

Musikalisch bietet "Weltende" ein modernes Klangbild des Avantgarde Black Metal. Die Band verbindet eisige Gitarrenriffs, rasende Drums und düstere Melodien zu einer atmosphärischen Gesamtkomposition. Dabei werden auch unerwartete Elemente geschickt eingebaut, wie beispielsweise der kurze Einsatz eines dezenten Piano-Parts, der das Panzerfeuer kurzzeitig aufbricht und die Hörer überrascht. Die Produktion des Albums, die von Markus Stock (bekannt für Empyrium und The Vision Bleak) übernommen wurde, ist bemerkenswert. Jedes Instrument ist klar und kraftvoll abgemischt, und die Gesangsdarbietung von André Meyrink ist gleichermassen fesselnd wie verstörend. Das Cover-Artwork, entlehnt von der expressionistischen Künstlerin Käthe Kollwitz (1867 - 1945), passt perfekt zu den düsteren Themen des Albums und rundet das Gesamtpaket gekonnt ab.

Insgesamt ist "Weltende" von Porta Nigra ein beeindruckendes Album, das durch seine konzeptionelle Tiefe und künstlerische Herangehensweise herausragt. Die Verbindung von Avantgarde Black Metal mit dem expressionistischen Erbe ist ein wahrer Hörgenuss für Fans des Genres und bietet eine intensive, emotionale Erfahrung. Seit 28. Juli 2023 ist das Album über Soulseller Records veröffentlicht, und kann es allen Freunden des düsteren und anspruchsvollen Metal nur wärmstens empfohlen werden. Porta Nigra haben hier ein eindrucksvolles Werk geschaffen, das sowohl musikalisch als auch konzeptionell überzeugt.

Albuminfo

Punkte

 

4/5

Label

 

Soulseller

Veröffentlichung

 

07/2023

Format

 

CD

Land

  Deutschland

Genre

 

Black Metal

 

Tracklist

1. Es ist Krieg
2. Götterblut
3. Völkerbrand
4. Verlorene Paradiese
5. Bestienschlund
6. Die himmlische Revolution
7. Weltende
8. Triebgeschwärme
9. Hora Mortis

8MBMemory Usage415msRequest 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" => 1749640437 "last" => 1749640437...
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.21KB) (12.28ms)
  • afterInitialise (1.61MB) (53.44ms)
  • afterRoute (246.41KB) (9.24ms)
  • beforeRenderComponent com_content (320.61KB) (7.09ms)
  • Before Access::preloadComponents (all components) (120.59KB) (1.98ms)
  • After Access::preloadComponents (all components) (102.56KB) (2.33ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (22μs)
  • After Access::preloadPermissions (com_content) (212.72KB) (2.09ms)
  • Before Access::getAssetRules (id:508 name:com_content.article.5078) (18.8KB) (34μs)
  • After Access::getAssetRules (id:508 name:com_content.article.5078) (9.73KB) (279μs)
  • afterRenderComponent com_content (587.34KB) (198ms)
  • afterDispatch (3.14KB) (154μs)
  • beforeRenderRawModule mod_menu (Info Menu) (291.38KB) (7.32ms)
  • afterRenderRawModule mod_menu (Info Menu) (38.98KB) (2.86ms)
  • beforeRenderModule mod_menu (Info Menu) (704B) (7μs)
  • afterRenderModule mod_menu (Info Menu) (2.9KB) (252μs)
  • beforeRenderRawModule mod_login (Anmeldung) (832B) (43μs)
  • afterRenderRawModule mod_login (Anmeldung) (163.77KB) (5.25ms)
  • beforeRenderModule mod_login (Anmeldung) (720B) (6μs)
  • afterRenderModule mod_login (Anmeldung) (9.91KB) (254μs)
  • beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Tags) (42.52KB) (8.74ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (8μs)
  • afterRenderModule mod_tags_popular (Tags) (3.45KB) (160μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (57μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.7KB) (1.11ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.66KB) (254μs)
  • beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (69μs)
  • afterRenderRawModule mod_menu (Hauptmenü) (221.19KB) (5.86ms)
  • beforeRenderModule mod_menu (Hauptmenü) (720B) (9μs)
  • afterRenderModule mod_menu (Hauptmenü) (3.68KB) (208μs)
  • beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (287.97KB) (14.3ms)
  • Before Access::getAssetRules (id:8 name:com_content) (76.45KB) (3.73ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (14μs)
  • afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (17.68KB) (66.8ms)
  • beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (11μs)
  • afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (14.41KB) (179μs)
  • afterRender (75.84KB) (722μs)
  • 1 x afterRenderComponent com_content (587.34KB) (47.81%)
    198.27ms
    1 x afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (17.68KB) (16.11%)
    66.80ms
    1 x afterInitialise (1.61MB) (12.89%)
    53.44ms
    1 x beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (287.97KB) (3.45%)
    14.30ms
    1 x afterLoad (553.21KB) (2.96%)
    12.28ms
    1 x afterRoute (246.41KB) (2.23%)
    9.24ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (42.52KB) (2.11%)
    8.74ms
    1 x beforeRenderRawModule mod_menu (Info Menu) (291.38KB) (1.76%)
    7.32ms
    1 x beforeRenderComponent com_content (320.61KB) (1.71%)
    7.09ms
    1 x afterRenderRawModule mod_menu (Hauptmenü) (221.19KB) (1.41%)
    5.86ms
    1 x afterRenderRawModule mod_login (Anmeldung) (163.77KB) (1.27%)
    5.25ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (76.45KB) (0.9%)
    3.73ms
    1 x afterRenderRawModule mod_menu (Info Menu) (38.98KB) (0.69%)
    2.86ms
    1 x After Access::preloadComponents (all components) (102.56KB) (0.56%)
    2.33ms
    1 x After Access::preloadPermissions (com_content) (212.72KB) (0.5%)
    2.09ms
    1 x Before Access::preloadComponents (all components) (120.59KB) (0.48%)
    1.98ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.7KB) (0.27%)
    1.11ms
    1 x afterRender (75.84KB) (0.17%)
    722μs
    1 x After Access::getAssetRules (id:508 name:com_content.article.5078) (9.73KB) (0.07%)
    279μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.66KB) (0.06%)
    254μs
    1 x afterRenderModule mod_login (Anmeldung) (9.91KB) (0.06%)
    254μs
    1 x afterRenderModule mod_menu (Info Menu) (2.9KB) (0.06%)
    252μs
    1 x afterRenderModule mod_menu (Hauptmenü) (3.68KB) (0.05%)
    208μs
    1 x afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (14.41KB) (0.04%)
    179μs
    1 x afterRenderModule mod_tags_popular (Tags) (3.45KB) (0.04%)
    160μs
    1 x afterDispatch (3.14KB) (0.04%)
    154μs
    1 x beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (0.02%)
    69μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (0.01%)
    57μs
    1 x beforeRenderRawModule mod_login (Anmeldung) (832B) (0.01%)
    43μs
    1 x Before Access::getAssetRules (id:508 name:com_content.article.5078) (18.8KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (0.01%)
    26μ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%)
    14μs
    1 x beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (0%)
    11μs
    1 x beforeRenderModule mod_menu (Hauptmenü) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (Info Menu) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_login (Anmeldung) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (0%)
    6μs
33 statements were executed, 7 of which were duplicates, 26 unique270ms1.18MB
  • SELECT @@SESSION.sql_mode;104μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `sm_session` WHERE `session_id` = ?800μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `sm_session` WHERE `session_id` = :session_id LIMIT 192μ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.55ms944BParams/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` = 13.53ms20.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `sm_viewlevels`399μ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` = :guest673μ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`3.02ms16.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-11 11:13:57' LIMIT 1798μ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`1.93ms28.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`1.63ms6.62KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `sm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC447μ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` = 11.66ms1.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)1.82ms10.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` = 01.29ms49.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sm_content`424μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `sm_content` SET `hits` = (`hits` + 1) WHERE `id` = '5078'1.63ms2.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)1.69ms25.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`947μ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)6.85ms6.25KBParams/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`398μ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.94ms6.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 DESC160ms918.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`469μ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`2.9ms2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id183μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id87μ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 106.79ms3.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` asc1.38ms4.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` asc999μ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.75ms6.25KBParams/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 ( SELECT DISTINCT `content_item_id` FROM `sm_contentitem_tag_map` WHERE `tag_id` IN (:preparedArray6,:preparedArray7) AND `type_alias` = 'com_content.article') AS `tagmap` ON `tagmap`.`content_item_id` = `a`.`id` 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) ORDER BY RAND() ASC LIMIT 360.41ms28.08KBParams/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.4ms18.38KBParams/libraries/src/Helper/TagsHelper.php:448Copy