Erinnerungen

Nach mehr als 25 Jahren Schwermetall, ist es an der Zeit, einmal zurückzublicken. Nicht etwa um sich auf der Vergangenheit auszuruhen, sondern um zu sehen, was sich alles getan hat und was aus der einst knapp 20 Seiten umfassenden Website geworden ist. Nur wer sich an die Vergangenheit erinnert, hat eine Zukunft!

Version 1.0 im Sommer 1998

Vom Design her noch recht schlicht und noch mit Corel Photopaint designt, war die erste Version auch zugleich die erste Website, die Morgenstern entworfen hat. Blitze waren das tragenende Element des verhältnismässig farbenfrohen Layouts.
Inhaltlich ging es mehr um den Metal im Allgemeinen. Das zeigen Rubriken wie Metalhistory und Stile. Dazu gab es jede Menge Bandbiografien, von mehrheitlich bekannten Bands.

Version 2.0

Dynamik trat an die Stelle von Farben. Die Flash - Technik sollte diese und die nächsten Versionen von Schwermetall dominieren. Das wichtigste, was sich geändert hat seht ihr links. Das Menu zeigt, worauf beim Design immer Wert gelegt wurde: Eigenständigkeit und vor allem Eigenkreation. Alle Grafiken der Website sind seit dieser Version selber designt.
Inhaltlich näherte sich Schwermetall mehr und mehr einem online Magazin. Dennoch sind die metalgeschichtlichen und die nachschlagewerklichen Elemente noch vorhanden: Es gibt neben der Geschichtsrubrik, und den Bandhistories auch Stile und etliche Lyrics und Übersetzungen.
Eines hat sich damals erstmals abezeichnet: Der enge Bezug zum Metalunderground. Die Rubrik Underground enthält erstmals wenige Interviews und einige Reviews.

Version 3.0

Neues Jahr, neue Zeit, neues Design. Im Jahr 2000 zeichnete sich der Wandel von Nachschlagewerk zum online Magazin deutlich ab. Die Berichte und die Kritiken bekamen ihre eigene Rubrik. Dazu wurde der multimediale Bereich deutlich ausgebaut. Mit Flash-Clips und Galerien, wurde neben der textlichen Ebene auch Wert auf den optischen Inhalt gelegt.
Dennoch blieb der Persönliche Charakter erhalten, was Rubriken wie "Persönlich" oder die Auswahl der damaligen Verweise zeigt.
In dieser Zeit entdeckte Morgenstern die Faszination der grafischen Schlichtheit. Dies zeigte sich in der praktisch nur in schwarz und weiss gehalteten grafischen Oberfläche. Der Text wurde in weiss gehalten, während der Hintergrund vorwiegend schwarz war.
Noch etwas zeichnete sich in dieser Version ab: Die Updates häuften sich immer mehr!

Version 4.0

Die Vierte Version von Schwermetall brachte eine Orientiertung an der Vertikalen. Das Ziel war es hier, vor allem die Aktualität der Site ins Zentrum zu rücken. So zeigten sich auf der Startsite die aktuellen Konzerte und die letzten Updates. Mit den Updates stieg auch die Besucherzahl stetig und zeitenweise auch sprunghaft!

Version 5.0

Die fünfte Version von Schwermetall brachte nicht nur ein komplett neues Layout, sondern auch erstmals eine Datenbankanbindung, die Updates weiter erleichterte und eine noch höhere Aktualität ermöglichte.

Version 6.0

Die fünfte Version wies allerdings noch eingie Schwächen auf. So waren viele Sachen erst über mehrere Klicks erreichbar und die Übersicht war nicht immer gewährleistet. Mit der Version sechs sollten diese Mängel verbessert worden sein.

Version 7.0

Das Ziel war bei dieser Version, alle wichtigen Sachen mit einem Klick erreichbar zu machen und die Übersichtlichkeit des gewachsenen Inhalts zu erhöhen. Dazu war es erforderlich eine komplette Neugestaltung des Layouts vorzunehmen. Das Layout ist mittlerweile recht geradelinig. Die grösste Herausforderung dabei war, dass der Charakter von Schwermetall erhalten bleibt.

Version 8.0

Inhaltlich kam neben der Rubrik "Voe-Daten" und den "DVD-Kritiken" eine Aufsplittung der Berichte in Interviews, Konzertberichte und Dossiers dazu. Zudem wurde die Community weiter gefördert und integriert.
Technisch wurde diese Version von Grund auf neu konzeptioniert und in objektorientiert in PHP5 umgesetzt. Das Layout wurde überwiegend mittels <div>-Containern realisiert und das gesamte Projekt für Suchmaschinen optimiert. Das Layout ist nun komplett mit Templates umgesetzt und wurde verbreitert.

Version 9.0

Die Version kam mit einem komplett neuen Layout daher, hielt sich aber immer noch an die früheren Vorgaben. Soziale Medien wurden integriert und das Forum erweitert.

Version 10.0

Version 10 stand voll im Zeichen der Reduktion. Viele Rubriken wurden reduziert und das Layout stark vereinfacht. Die wichtigste Änderung ist jedoch, dass Schwermetall nun komplett Mobil-tauglich war. Darüber hinaus war Schwermetall ab dann komplett werbefrei.

Version 11.0

Nachdem der Hoster von Schwermetall, sich entschieden hatte, dass die Server in der Art nicht erhalten werden, musste Schwermetall kurzfristig auf ein neuen Server umziehen. Da die selbstgeschriebene Software nicht mehr mit der neuen Infrastruktur zurecht kam (PHP7), musste die Seite komplett neu aufgebaut werden. Dies ist auf Basis einer Standardsoftware innerhalb von kürzester Zeit realisiert worden.

 

5MBMemory Usage188msRequest 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" => 1748639005 "last" => 1748639005...
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/geschic...
  • afterLoad (552.91KB) (6.38ms)
  • afterInitialise (1.6MB) (48.73ms)
  • afterRoute (75.48KB) (3.37ms)
  • beforeRenderComponent com_content (429.79KB) (7.53ms)
  • Before Access::preloadComponents (all components) (71.4KB) (2.96ms)
  • After Access::preloadComponents (all components) (102.56KB) (2.71ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (28μs)
  • After Access::preloadPermissions (com_content) (212.72KB) (2.16ms)
  • Before Access::getAssetRules (id:135 name:com_content.article.228) (18.8KB) (29μs)
  • After Access::getAssetRules (id:135 name:com_content.article.228) (9.73KB) (193μs)
  • afterRenderComponent com_content (575.11KB) (41.54ms)
  • afterDispatch (3.14KB) (251μs)
  • beforeRenderRawModule mod_menu (Info Menu) (294.52KB) (8.52ms)
  • afterRenderRawModule mod_menu (Info Menu) (35.56KB) (3.44ms)
  • beforeRenderModule mod_menu (Info Menu) (704B) (13μs)
  • afterRenderModule mod_menu (Info Menu) (2.96KB) (348μs)
  • beforeRenderRawModule mod_login (Anmeldung) (832B) (68μs)
  • afterRenderRawModule mod_login (Anmeldung) (146.55KB) (5.43ms)
  • beforeRenderModule mod_login (Anmeldung) (720B) (9μs)
  • afterRenderModule mod_login (Anmeldung) (9.91KB) (165μs)
  • beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (26μs)
  • afterRenderRawModule mod_tags_popular (Tags) (40.84KB) (8.58ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (12μs)
  • afterRenderModule mod_tags_popular (Tags) (3.43KB) (236μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (70μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.58KB) (1.19ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.84KB) (268μs)
  • beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (46μs)
  • afterRenderRawModule mod_menu (Hauptmenü) (225.27KB) (5.37ms)
  • beforeRenderModule mod_menu (Hauptmenü) (720B) (7μs)
  • afterRenderModule mod_menu (Hauptmenü) (3.68KB) (134μs)
  • beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (303.97KB) (17.74ms)
  • Before Access::getAssetRules (id:8 name:com_content) (72.04KB) (4.49ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (20μs)
  • afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (5.21KB) (1.91ms)
  • beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (9μs)
  • afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (2.36KB) (231μs)
  • afterRender (59.9KB) (943μs)
  • 1 x afterInitialise (1.6MB) (25.96%)
    48.73ms
    1 x afterRenderComponent com_content (575.11KB) (22.13%)
    41.54ms
    1 x beforeRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (303.97KB) (9.45%)
    17.74ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (40.84KB) (4.57%)
    8.58ms
    1 x beforeRenderRawModule mod_menu (Info Menu) (294.52KB) (4.54%)
    8.52ms
    1 x beforeRenderComponent com_content (429.79KB) (4.01%)
    7.53ms
    1 x afterLoad (552.91KB) (3.4%)
    6.38ms
    1 x afterRenderRawModule mod_login (Anmeldung) (146.55KB) (2.89%)
    5.43ms
    1 x afterRenderRawModule mod_menu (Hauptmenü) (225.27KB) (2.86%)
    5.37ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (72.04KB) (2.39%)
    4.49ms
    1 x afterRenderRawModule mod_menu (Info Menu) (35.56KB) (1.83%)
    3.44ms
    1 x afterRoute (75.48KB) (1.8%)
    3.37ms
    1 x Before Access::preloadComponents (all components) (71.4KB) (1.57%)
    2.96ms
    1 x After Access::preloadComponents (all components) (102.56KB) (1.44%)
    2.71ms
    1 x After Access::preloadPermissions (com_content) (212.72KB) (1.15%)
    2.16ms
    1 x afterRenderRawModule mod_ruxin_related_articles (Ruxin Related Articles) (5.21KB) (1.02%)
    1.91ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (12.58KB) (0.64%)
    1.19ms
    1 x afterRender (59.9KB) (0.5%)
    943μs
    1 x afterRenderModule mod_menu (Info Menu) (2.96KB) (0.19%)
    348μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs Top) (3.84KB) (0.14%)
    268μs
    1 x afterDispatch (3.14KB) (0.13%)
    251μs
    1 x afterRenderModule mod_tags_popular (Tags) (3.43KB) (0.13%)
    236μs
    1 x afterRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (2.36KB) (0.12%)
    231μs
    1 x After Access::getAssetRules (id:135 name:com_content.article.228) (9.73KB) (0.1%)
    193μs
    1 x afterRenderModule mod_login (Anmeldung) (9.91KB) (0.09%)
    165μs
    1 x afterRenderModule mod_menu (Hauptmenü) (3.68KB) (0.07%)
    134μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs Top) (1.13KB) (0.04%)
    70μs
    1 x beforeRenderRawModule mod_login (Anmeldung) (832B) (0.04%)
    68μs
    1 x beforeRenderRawModule mod_menu (Hauptmenü) (1.13KB) (0.02%)
    46μs
    1 x Before Access::getAssetRules (id:135 name:com_content.article.228) (18.8KB) (0.02%)
    29μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_tags_popular (Tags) (1.12KB) (0.01%)
    26μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_menu (Info Menu) (704B) (0.01%)
    13μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0.01%)
    12μs
    1 x beforeRenderModule mod_ruxin_related_articles (Ruxin Related Articles) (736B) (0%)
    9μs
    1 x beforeRenderModule mod_login (Anmeldung) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Hauptmenü) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs Top) (720B) (0%)
    5μs
28 statements were executed, 4 of which were duplicates, 24 unique54.65ms250.37KB
  • SELECT @@SESSION.sql_mode;109μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `sm_session` WHERE `session_id` = ?1.18ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `sm_session` WHERE `session_id` = :session_id LIMIT 1154μ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.93ms944BParams/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.23ms20.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `sm_viewlevels`546μ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` = :guest755μ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`2.74ms16.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-05-30 21:03:25' LIMIT 1189μ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 * FROM `sm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC551μ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.59ms1.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)2.16ms10.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.47ms49.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `sm_content`549μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `sm_content` SET `hits` = (`hits` + 1) WHERE `id` = '228'5.2ms48B/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.64ms27.88KBParams/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`537μs6.03KBParams/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.38ms5.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`426μs6.03KBParams/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)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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.36ms6KBParams/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 DESC7.35ms2.47KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • 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`3.07ms2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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.56ms3.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.05ms4.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` asc718μs20.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.29ms5.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.24ms9.5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy