Dies ist nicht verwunderlich, werden doch sowohl Metal als auch Tattoos mit einer Rebellion gegen die Gesellschaft in Verbindung gebracht.

Die beiden Basler Buchautoren Nando Rohner und Alessandro Bertolotti haben sich in den letzten Jahren eingehend mit der Verbindung von Metal und Tattoos befasst. Das Resultat ist das umfassende Interviewwerk "Under the Skin of Rock `n` Roll" mit über 350 Seiten Bild und Schrift.

In einem ersten Teil nähern sich die Autoren mit einer Schwerpunktreportage dem Thema. In einfacher Lesekost sind die Hintergründe aufbereitet: Warum lassen sich Menschen tätowieren? Was sind die Risiken und weshalb sind Tattoos negativ konnotiert? Eine mehr oder weniger ausführliche Geschichte der Tattoos führt den Leser an deren Verbindung mit dem Rock `n` Roll und schliesslich mit dem Metal heran. Inhaltlich kratzt der Text lediglich an der Oberfläche und statt wissenschaftlich wirkt diese erste Session eher zusammengewürfelt aber dennoch unterhaltend. Wer sich also eingehend mit der Geschichte von Metal und Tattoos beschäftigen will, kriegt hier erste Anhaltspunkte zum Weiterforschen.

Der erste Interviewteil folgt gleich im Anschluss. Verschiedenste mehr und weniger bekannte Truppen aus mannigfaltigsten Metal und Rockgenres werden zum Kernthema befragt. Viele Kernfragen werden allen Bands gestellt. Dies bringt einerseits eine gute Vergleichbarkeit mit. Andererseits hat man nach fünf Interviews mit praktisch den gleichen Antworten reichlich genug gehört zu Fragen wie "welches Tattoo hast du dir als erstes machen lassen?", "was sind deine Pläne für künftige Tattoos?". Interessanter sind allerdings Fragen zu der Verbindung zwischen Metal und Tattoo und was die einzelnen Musiker darüber denken. Denn genau in diesen Antworten sehe ich den Neuigkeitsgehalt des Buches. Genau diese Antworten hätte man fokussieren und eingehender aufbereiten sollen. Denn ein Leser erwartet auf Grund des Titels und des Rückentextes eine aufbereitete Antwort auf diese Fragen, welche Schlussendlich fehlt. Darüber hinaus wird dieser rote Faden durch zahlreiche Nebenfragen zu gut kaschiert.

Die Bandwahl ist dabei ausgesprochen vielseitig und lässt zu, die einen oder anderen unbekannten Truppen zu überspringen. Mit Bands wie Requiem, Rotting Christ, Exodus, Dark Funeral, Trollfest, Dismember, Hypocrisy, Excruciation, Cradle of Filth, Punish, Illdisposed, Kreator, Destruction und Primordial und so weiter ist allerdings genug Lesestoff für die Zielgruppen von Schwermetall vorhanden. Wie jedoch die Auswahl zu Stande gekommen ist, wirkt genau so wie deren Anordnung willkürlich.

In den letzten beiden Kapitel kommen einerseits die internationalen Tattoo-Künstler zu Wort und andererseits weitere, die in einer Art und Weise zum Thema beitragen können. So wird unter anderem der christliche Pastor Bob, ein Buchautor und Missy Suicide von Suicide Girls befragt.

Danach fehlt leider eine abschliessende Zusammenfassung oder eine Aufbereitung des Gesagten.

Insgesamt ist "Under the Skin of Rock `n` Roll" bestimmt das umfassendste Werk zum Thema und hat deshalb eine Daseinsberechtigung. Allerdings sind die Interviewmitschriften eher als Grundlage für eine eingehendere Analyse und Aufbereitung zu betrachten. Denn eigene Gedanken der Autoren fehlen weitgehend. Hintergründe zur Bandwahl bleiben aus. So wirkt das Buch zwar wie eine sehr umfassende, aber leider auch willkürlich zusammengewürfelte Sammlung von Interviews. Das Buch krankt deshalb etwas an innerem Zusammenhalt und einem roten Faden. Manchmal wünscht man sich eher Klasse statt Masse. Wer jedoch eine unterhaltende Interviewsammlung zum Thema Tattoo und Metal sucht, ist mit "Under the Skin of Rock `n` Roll" goldrichtig.

Zu bestellen gibt es das Buch im Fachhandel (ISBN 9783837092851). Zusätzliche Informationen sind unter www.myspace.com/rockandtattoo erhältlich.

 

5MBMemory Usage119msRequest 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
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "74eafe29d6280af5ed80b499e8ee081d" => "h2bqt8d75fklkg2p46quetstn4" ]
$_SERVER
array:52 [ "USER" => "flamboyant" "HOME" => "/var/www/vhosts/flamboyant-hertz.92-205-176-165.ple...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1749056968 "last" => 1749056969...
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 (554.24KB) (5.78ms)
  • afterInitialise (1.61MB) (27.93ms)
  • afterRoute (246.44KB) (5.62ms)
  • beforeRenderComponent com_content (326.13KB) (4.31ms)
  • Before Access::preloadComponents (all components) (120.58KB) (1.36ms)
  • After Access::preloadComponents (all components) (102.56KB) (778μs)
  • Before Access::preloadPermissions (com_content) (3.85KB) (15μs)
  • After Access::preloadPermissions (com_content) (212.72KB) (1.06ms)
  • Before Access::getAssetRules (id:193 name:com_content.article.652) (18.8KB) (24μs)
  • After Access::getAssetRules (id:193 name:com_content.article.652) (9.73KB) (143μs)
  • afterRenderComponent com_content (519.66KB) (16.95ms)
  • afterDispatch (3.14KB) (199μs)
  • beforeRenderRawModule mod_menu (Info Menu) (271.81KB) (5.08ms)
  • afterRenderRawModule mod_menu (Info Menu) (58.98KB) (2.56ms)
  • beforeRenderModule mod_menu (Info Menu) (704B) (6μs)
  • afterRenderModule mod_menu (Info Menu) (2.9KB) (265μs)
  • beforeRenderRawModule mod_login (Anmeldung) (832B) (40μs)
  • afterRenderRawModule mod_login (Anmeldung) (163.27KB) (7.95ms)
  • beforeRenderModule mod_login (Anmeldung) (720B) (11μs)
  • afterRenderModule mod_login (Anmeldung) (9.91KB) (178μs)
  • beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (28μs)
  • afterRenderRawModule mod_tags_popular (Tags) (50.27KB) (4.64ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (7μs)
  • afterRenderModule mod_tags_popular (Tags) (3.43KB) (176μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (60μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (13.54KB) (1.07ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.78KB) (208μs)
  • beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (39μs)
  • afterRenderRawModule mod_menu (Hauptmenü) (215.71KB) (5.1ms)
  • beforeRenderModule mod_menu (Hauptmenü) (720B) (10μs)
  • afterRenderModule mod_menu (Hauptmenü) (3.68KB) (148μs)
  • beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (296.41KB) (14.78ms)
  • Before Access::getAssetRules (id:8 name:com_content) (72.04KB) (2.77ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (14μs)
  • afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (5.21KB) (2.17ms)
  • beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (16μs)
  • afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (2.36KB) (226μs)
  • afterRender (55.9KB) (531μs)
  • 1 x afterInitialise (1.61MB) (23.43%)
    27.93ms
    1 x afterRenderComponent com_content (519.66KB) (14.23%)
    16.95ms
    1 x beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (296.41KB) (12.4%)
    14.78ms
    1 x afterRenderRawModule mod_login (Anmeldung) (163.27KB) (6.67%)
    7.95ms
    1 x afterLoad (554.24KB) (4.85%)
    5.78ms
    1 x afterRoute (246.44KB) (4.72%)
    5.62ms
    1 x afterRenderRawModule mod_menu (Hauptmenü) (215.71KB) (4.28%)
    5.10ms
    1 x beforeRenderRawModule mod_menu (Info Menu) (271.81KB) (4.27%)
    5.08ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (50.27KB) (3.89%)
    4.64ms
    1 x beforeRenderComponent com_content (326.13KB) (3.62%)
    4.31ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (72.04KB) (2.32%)
    2.77ms
    1 x afterRenderRawModule mod_menu (Info Menu) (58.98KB) (2.15%)
    2.56ms
    1 x afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (5.21KB) (1.82%)
    2.17ms
    1 x Before Access::preloadComponents (all components) (120.58KB) (1.14%)
    1.36ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (13.54KB) (0.9%)
    1.07ms
    1 x After Access::preloadPermissions (com_content) (212.72KB) (0.89%)
    1.06ms
    1 x After Access::preloadComponents (all components) (102.56KB) (0.65%)
    778μs
    1 x afterRender (55.9KB) (0.45%)
    531μs
    1 x afterRenderModule mod_menu (Info Menu) (2.9KB) (0.22%)
    265μs
    1 x afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (2.36KB) (0.19%)
    226μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.78KB) (0.17%)
    208μs
    1 x afterDispatch (3.14KB) (0.17%)
    199μs
    1 x afterRenderModule mod_login (Anmeldung) (9.91KB) (0.15%)
    178μs
    1 x afterRenderModule mod_tags_popular (Tags) (3.43KB) (0.15%)
    176μs
    1 x afterRenderModule mod_menu (Hauptmenü) (3.68KB) (0.12%)
    148μs
    1 x After Access::getAssetRules (id:193 name:com_content.article.652) (9.73KB) (0.12%)
    143μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (0.05%)
    60μs
    1 x beforeRenderRawModule mod_login (Anmeldung) (832B) (0.03%)
    40μs
    1 x beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (0.03%)
    39μs
    1 x beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (0.02%)
    28μs
    1 x Before Access::getAssetRules (id:193 name:com_content.article.652) (18.8KB) (0.02%)
    24μs
    1 x beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (0.01%)
    16μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    15μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_login (Anmeldung) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_menu (Hauptmenü) (720B) (0.01%)
    10μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0.01%)
    7μs
    1 x beforeRenderModule mod_menu (Info Menu) (704B) (0.01%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (0%)
    5μs
32 statements were executed, 7 of which were duplicates, 25 unique16.73ms252.63KB
  • SELECT @@SESSION.sql_mode;89μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `sm_session` WHERE `session_id` = ?157μs1.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `sm_session` WHERE `session_id` = :session_id LIMIT 1102μs1.64KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `sm_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id236μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `sm_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1391μs20.69KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `sm_viewlevels`121μ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` = :guest137μ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`580μ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-04 17:09:29' LIMIT 1380μ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`558μ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`349μs6.62KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `sm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC152μ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` = 1220μ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)418μ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` = 0499μs49.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sm_content`477μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `sm_content` SET `hits` = (`hits` + 1) WHERE `id` = '652'923μs2.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)339μ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`327μ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.01ms5.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`356μ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 ASC713μs6.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 DESC287μs2.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`271μ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`610μs2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id174μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `sm_content` WHERE `id` = :id111μ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 102.29ms3.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.93ms4.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` asc244μ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.1ms5.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 31.18ms9.5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy