Die Magisterarbeit von Philip Akoto wurde vom Telos Verlag aufgegriffen und veröffentlicht, dementsprechend wissenschaftlich gibt sich die Arbeit...

Die Magisterarbeit von Philip Akoto wurde vom Telos Verlag aufgegriffen und veröffentlicht, dementsprechend wissenschaftlich gibt sich die Arbeit. Ziel seiner Untersuchung ist es, herauszufinden, welche Rolle die thematische und ästhetische Todesfokussierung als ein tragendes Hauptmotiv von Gothic, Industrial und in gewissen Subgenres des Heavy Metal tatsächlich dort spielt, wo szeneintern von gegenkultureller Praxis die Rede sein kann, sowie, wofür und wogegen mittels der Ästhetisierung von Gewalt, Tod und Sterben protestiert wird. Dazu werden insbesondere die Musiker als geistige Leitfiguren ihrer Genres auf ihre Kompatibilität mit dem Profil eines Subkulturalisten untersucht.

In einem ersten Schritt wird in einem überblickenden Teil aufgezeigt, inwiefern in der Medienlandschaft die Todesfaszination abgebildet wird. Akoto bleibt hier oberflächlich und zeigt nur exemplarisch auf, in welchen Bereichen (Film, Literatur, Bildkunst), die Todesfaszination eine Rolle spielt, nicht aber wie sich diese im Detail manifestiert. Insbesondere die meines Erachtens willkürliche Beispielwahl zeigt, dass eine tiefer gehende Untersuchung zu einem vollständigeren Bild geführt hätte. Trotzdem zeigt Akoto auf wenigen Seiten einen passablen Einblick in die Geschichte der Todesfaszination in der Kunst und Kulturwelt.

In einer zweiten Phase untersucht der Soziologe den Subkultur-Begriff und kommt vereinfacht gesagt in einem argumentativen Diskurs zum Schluss, dass insbesondere die Subversion einen konstitutiven Charakter für eine Subkultur bildet. Zu Deutsch: Erst wenn ein Musikgenre und die umliegende Lebenswelt umstürzlerische Tendenzen aufweist, kann von einer Subkultur geredet werden.

Gerade diese subversiven Elemente sucht Akoto nun in den Genres Gothic/Industrial sowie in den extremen Metalspielarten. In seinem kleinen Genreguide wagt er sich meines Erachtens zu weit aus dem Fenster hinaus und vertut sich des Öfteren bei der Auflistung wichtiger Bands eines Genres. Auch bei der Gewichtung und Nennung von wichtigen Bands zeigt sich, dass er sich nicht in jedem Stil ganz zu Hause fühlt. Nichtsdestotrotz gibt es für jeden interessierten Metaller, der sich noch nicht mit der Geschichte seiner Musikkultur befasst hat, einen schnellen Überblick, der jedoch von anderen Autoren schon besser, vollständiger und akkurater vollzogen worden ist.

Der Hauptteil des Buches ist zugleich derjenige, der am meisten neue wissenschaftliche Erkenntnisse bringt. Akoto untersucht die Gothic Band Thanateros, die Industrial Band The Grey Wolves, die Thrash Metal Formation Sacred Reich, die Death / Grind Formation Misery Index, die Todesmetaller Cattle Decapitation sowie Dissection auf ihren subversiven Gehalt. Die Bandauswahl scheint mir zu unbegründet, gar willkürlich. Es stellt sich die Frage der Repräsentativität der Bands.

Akoto kommt zum Schluss, dass diese Subversivität in den genannten Genres zwar einen Platz findet, jedoch Gothic, Industrial und die extremen Metalspielarten nicht a priori subkulturell geprägt sind. Dennoch erkennt er die subversiven Geister innerhalb der Szene, die in ihrem Ansatz mittels konsequenter Kritik an den herrschenden Verhältnissen Veränderungen anregen wollen. Dennoch würden erst Konsumenten, die sich intensiv mit dieser Musik beschäftigen mit dieser Subversivität in Kontakt kommen, währenddem komplett Aussenstehende, diese Potentiale kaum wahrnehmen.

Insgesamt liegt die Schwäche des Buches in der fehlenden Tiefe, die sich in einer mageren Seitenzahl manifestiert sowie in der scheinbaren Willkürlichkeit der Beispielauswahl. Erstaunlich ist auch, dass ein Genre wie der Pagan Metal gänzlich ausgeschlossen wurde, obwohl dessen Subversivcharakter wohl noch am offensichtlichsten wäre. Zudem fehlt eine Analyse der Subversivkräfte aus dem rechtsradikalen Bereich im Metal fast gänzlich. Besonders kritische Geister könnten Akoto eine Verharmlosung des revolutionären Charakters der behandelten Stile vorwerfen. Dennoch liest sich das Buch gut und bringt interessante Einzelanalysen, die insbesondere für Fans dieser Bands von Belang sein dürften.

5MBMemory Usage162msRequest 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" => 1749293601 "last" => 1749293601...
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.27KB) (6.76ms)
  • afterInitialise (1.61MB) (41.77ms)
  • afterRoute (246.44KB) (7.93ms)
  • beforeRenderComponent com_content (326.13KB) (6.89ms)
  • Before Access::preloadComponents (all components) (120.58KB) (1.39ms)
  • After Access::preloadComponents (all components) (102.56KB) (2.28ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (19μs)
  • After Access::preloadPermissions (com_content) (212.72KB) (2.11ms)
  • Before Access::getAssetRules (id:194 name:com_content.article.416) (18.8KB) (30μs)
  • After Access::getAssetRules (id:194 name:com_content.article.416) (9.73KB) (160μs)
  • afterRenderComponent com_content (519.09KB) (31.15ms)
  • afterDispatch (3.14KB) (146μs)
  • beforeRenderRawModule mod_menu (Info Menu) (271.81KB) (7.16ms)
  • afterRenderRawModule mod_menu (Info Menu) (58.98KB) (3.38ms)
  • beforeRenderModule mod_menu (Info Menu) (704B) (12μs)
  • afterRenderModule mod_menu (Info Menu) (2.9KB) (331μs)
  • beforeRenderRawModule mod_login (Anmeldung) (832B) (65μs)
  • afterRenderRawModule mod_login (Anmeldung) (163.75KB) (5.38ms)
  • beforeRenderModule mod_login (Anmeldung) (720B) (8μs)
  • afterRenderModule mod_login (Anmeldung) (9.91KB) (150μs)
  • beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (22μs)
  • afterRenderRawModule mod_tags_popular (Tags) (50.4KB) (8.05ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (9μs)
  • afterRenderModule mod_tags_popular (Tags) (3.43KB) (162μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (64μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (13.66KB) (1.11ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.91KB) (204μs)
  • beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (40μs)
  • afterRenderRawModule mod_menu (Hauptmenü) (215.71KB) (5.24ms)
  • beforeRenderModule mod_menu (Hauptmenü) (720B) (8μs)
  • afterRenderModule mod_menu (Hauptmenü) (3.68KB) (189μs)
  • beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (296.09KB) (13.92ms)
  • Before Access::getAssetRules (id:8 name:com_content) (72.04KB) (3.8ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (14μs)
  • afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (5.21KB) (1.61ms)
  • beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (8μs)
  • afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (2.36KB) (173μs)
  • afterRender (55.9KB) (804μs)
  • 1 x afterInitialise (1.61MB) (25.78%)
    41.77ms
    1 x afterRenderComponent com_content (519.09KB) (19.22%)
    31.15ms
    1 x beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (296.09KB) (8.59%)
    13.92ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (50.4KB) (4.97%)
    8.05ms
    1 x afterRoute (246.44KB) (4.89%)
    7.93ms
    1 x beforeRenderRawModule mod_menu (Info Menu) (271.81KB) (4.42%)
    7.16ms
    1 x beforeRenderComponent com_content (326.13KB) (4.25%)
    6.89ms
    1 x afterLoad (553.27KB) (4.17%)
    6.76ms
    1 x afterRenderRawModule mod_login (Anmeldung) (163.75KB) (3.32%)
    5.38ms
    1 x afterRenderRawModule mod_menu (Hauptmenü) (215.71KB) (3.23%)
    5.24ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (72.04KB) (2.34%)
    3.80ms
    1 x afterRenderRawModule mod_menu (Info Menu) (58.98KB) (2.08%)
    3.38ms
    1 x After Access::preloadComponents (all components) (102.56KB) (1.41%)
    2.28ms
    1 x After Access::preloadPermissions (com_content) (212.72KB) (1.3%)
    2.11ms
    1 x afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (5.21KB) (0.99%)
    1.61ms
    1 x Before Access::preloadComponents (all components) (120.58KB) (0.86%)
    1.39ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (13.66KB) (0.68%)
    1.11ms
    1 x afterRender (55.9KB) (0.5%)
    804μs
    1 x afterRenderModule mod_menu (Info Menu) (2.9KB) (0.2%)
    331μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.91KB) (0.13%)
    204μs
    1 x afterRenderModule mod_menu (Hauptmenü) (3.68KB) (0.12%)
    189μs
    1 x afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (2.36KB) (0.11%)
    173μs
    1 x afterRenderModule mod_tags_popular (Tags) (3.43KB) (0.1%)
    162μs
    1 x After Access::getAssetRules (id:194 name:com_content.article.416) (9.73KB) (0.1%)
    160μs
    1 x afterRenderModule mod_login (Anmeldung) (9.91KB) (0.09%)
    150μs
    1 x afterDispatch (3.14KB) (0.09%)
    146μs
    1 x beforeRenderRawModule mod_login (Anmeldung) (832B) (0.04%)
    65μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (0.04%)
    64μs
    1 x beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (0.02%)
    40μs
    1 x Before Access::getAssetRules (id:194 name:com_content.article.416) (18.8KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (0.01%)
    22μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    19μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_menu (Info Menu) (704B) (0.01%)
    12μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0.01%)
    9μs
    1 x beforeRenderModule mod_menu (Hauptmenü) (720B) (0.01%)
    8μs
    1 x beforeRenderModule mod_login (Anmeldung) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (0%)
    5μs
32 statements were executed, 7 of which were duplicates, 25 unique48.99ms252.57KB
  • SELECT @@SESSION.sql_mode;178μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `sm_session` WHERE `session_id` = ?1.12ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `sm_session` WHERE `session_id` = :session_id LIMIT 1115μ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.59ms944BParams/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.08ms20.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `sm_viewlevels`946μ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` = :guest1.03ms1.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`2.45ms16.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-07 10:53:21' LIMIT 1765μ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.66ms28.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.44ms6.62KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `sm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC610μ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.33ms1.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.83ms10.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.35ms49.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sm_content`414μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `sm_content` SET `hits` = (`hits` + 1) WHERE `id` = '416'1.6ms2.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.71ms25.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`650μ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)5.36ms5.22KBParams/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`392μ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.69ms6.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 DESC5.5ms2.75KBParams/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`463μ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.25ms2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id159μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id90μ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` asc866μ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` asc498μ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.36ms5.22KBParams/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 3921μs9.5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy