knowledge base (Haiku only)
How to help us?

Who wants to help this project, can do this writing their own tutorials, descriptions or translations. Also ideas or criticisms are welcome.

To make your own tutorials you have some helpful informtions and opportunities. The easiest way is, you write your tutorial and send it to: webmaster(at)besly.de. It is important that this is really an own tutorial, as there could be legal problems to the original authors otherwise.

Aktuell sind 27 Gäste und keine Mitglieder online

Datensicherung mit LBackup

Details
Geschrieben von: admin
Kategorie: Programme
Zugriffe: 2142

System: Haiku

LBackup ist ein kleines in yab geschriebenes Backup Programm, welches auf einfache Weise bedient und konfiguriert werden kann. Die Standard Konfiguration beinhaltet viele Einstellungen von in Haiku enthaltene Programmen, Systemeinstellungen und Persönliche Daten. Somit kann man ohne viel einzustellen, sofort ein Backup vom System erstellen.
Dabei verwendet LBackup die Zip- Komprimierung und legt für jede ausgewählte Einstellung eine eigene Zipdatei an, sowie die Information von dessen Dateipfad im System. Somit kann jede Datei wahlweise entpackt und an die richtige Stelle zurück in System kopiert werden, ohne alle in einem Backup erstellten Dateien installieren zu müssen.
Jedes Backup wird in einen entsprechend bezeichneten Ordner abgelegt welche das Erstelldatum und Uhrzeit des Backups beinhaltet.

Installation

LBackup kann über unseren Repository Server bezogen werden: BeSly Software Solutions

Um LBackup zu Installieren, lade dieses von unserer Webseite (siehe oberen Link) herunter oder fügen unseren Repository Server in HaikuDepot hinzu und installiere hier drüber.

pkgman add-repo http://software.besly.de/repo

Wenn die Installation beendet ist, kann das Programm über das Aplications Menü gestartet werden.

Wenn man nun das Programm zum ersten mal startet, werden alle benötigten Verzeichnisse im Programmordner und Dateien von LBackup selber erstellt.

Konfiguration

LBackup ist vollständig konfigurierbar, das heißt man hat die Möglichkeit alle im Programm aufgelisteten Inhalte selber fest zu legen. So kann man sich z.B. ein Konfiguration erstellen, die alle vom Benutzer installierten Programme und dessen Einstellungen beinhaltet. Dies ist z.B. dann interessant, wenn man wie ich, oftmals eine neue Haiku Version installiert und man jedes Mal alle Programme installieren und Einstellen muss.

Um eine eigene Konfigurationsdatei zu erstellen, muss man eine neue Datei im info Ordner des LBackup Verzeichnisses anlegen. Wahlweise kann man in LBackup auf den Menüpunkt "Settings" gehen und dort über "Edit" eine vorhandene Konfigurationsdatei öffnen. Nachdem die Datei geöffnet wurde, hierbei handelt es sich um eine einfache Textdatei, kann man den Inhalt anpassen und dann über "Speichern als neue Datei" (Save As) diese als neue Konfigurationsdatei abspeichern. Diese wird dann nach einen Neustart von LBackup (falls geöffnet) im Settings- Menü aufgeführt.

Nun zum Aufbau der Konfigurationsdatei. Jeder Eintrag "title" ist eine Angabe dafür, dass hier eine neue Überschrift (Bereich) angegeben wird. Wer diese Einträge mit der Ansicht des LBackup Programms vergleicht wird die Parallelen sehen und den Aufbau schnell verstehen. Nach den Trennzeichen "|" wird die $Uuml;berschrift angegeben und nach dem nächsten Trennzeichen die Anzahl der dazugehörenden Einträge. Alle darauf folgenden Zeilen sind dann die auswählbaren Einträge (entsprechend der Anzahl der Einträge). Zuerst kommt der Name des Eintrages und hinter dem Trennzeichen der Pfad zu der dazugehörigen Datei. Dabei ist es egal ob der Zielpfad zu einer Datei oder Verzeichnis führt.

Wenn später das Programm das Backup durchführt, vergleicht dieses die ausgewälten Einträge mit denen der Konfigurationsdatei. Stimmen diese überein, wird die Angabe hinter dem Trennzeichen ausgelesen und dann mit Hilfe des Zip Programms gepackt.

Datensicherung (Backup)

Um ein Backup durchzuführen, markieren wir alle aufgeführten Einträge die wir Sichern möchten und drücken dann auf "Backup!". Eine Statusanzeige zeigt während des Backup- Vorganges den Fortschritt der Datensicherung.

Zuerst werden alle Daten in einem Temporären Verzeichnis gespeichert. Am Ende des Speichervorganges wird der Benutzer aufgefordert anzugeben, wie dieser mit dene Daten verfahren möchte.

Hier hat dieser zwei Möglichkeiten. Zum einen kann er die Backupdateien einfach Exportieren ("Export File") oder eine ISO Image Datei daraus erstellen ("Create ISO image") lassen um diese dann später mit einem Brennerprogramm auf CD zu sichern.

Bei beiden Möglichkeiten wählt man das Zielverzeichnis aus und drückt anschließend auf "Open".



Eine weitere Statusanzeige zeigt den Fortschritt der Speicherung an.

Anleitung erstellt durch Christian Albrecht (Lelldorin) März 2011
Bereitgestellt durch BeSly, der BeOS, Haiku & Zeta Wissensbasis.

J! InfoRequestSessionProfileQueries39
Settings24.139MBMemory Usage298msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.1
PHP Version8.2.28
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.6.22-MariaDB-0ubuntu0.22.04.1
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:53 [ "USER" => "lorglaser" "HOME" => "/var/www/vhosts/101.19982.vn.2-host.de" "PATH_TRAN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1751295330 "last" => 1751295330...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "de-DE" ]
  • afterLoad (3.58MB) (28.37ms)
  • afterInitialise (7.4MB) (73.4ms)
  • afterRoute (1.92MB) (13.04ms)
  • beforeRenderComponent com_content (1.1MB) (11.06ms)
  • Before Access::preloadComponents (all components) (725.15KB) (7.75ms)
  • After Access::preloadComponents (all components) (113.55KB) (1.07ms)
  • Before Access::preloadPermissions (com_content) (424B) (18μs)
  • After Access::preloadPermissions (com_content) (409.86KB) (1.54ms)
  • Before Access::getAssetRules (id:1358 name:com_content.article.315) (18.65KB) (41μs)
  • After Access::getAssetRules (id:1358 name:com_content.article.315) (27.66KB) (532μs)
  • Before Access::getAssetRules (id:8 name:com_content) (1.06MB) (15.58ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (22μs)
  • afterRenderComponent com_content (1.62MB) (35.48ms)
  • afterDispatch (184.78KB) (4.57ms)
  • beforeRenderRawModule mod_languages (Language) (699.45KB) (12.27ms)
  • afterRenderRawModule mod_languages (Language) (92.1KB) (7.42ms)
  • beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (48μs)
  • afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (12.55ms)
  • beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (672B) (34μs)
  • afterRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (1.79MB) (32.2ms)
  • beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (32μs)
  • afterRenderRawModule mod_custom (How to help us?) (9.27KB) (751μs)
  • beforeRenderRawModule mod_whosonline (Who is online) (576B) (18μs)
  • afterRenderRawModule mod_whosonline (Who is online) (27.36KB) (1.29ms)
  • beforeRenderRawModule mod_finder (Search) (1.49KB) (60μs)
  • afterRenderRawModule mod_finder (Search) (605.09KB) (10.8ms)
  • beforeRenderRawModule mod_custom (Imprint) (464B) (85μs)
  • afterRenderRawModule mod_custom (Imprint) (1.08KB) (194μs)
  • beforeRenderModule mod_custom (Imprint) (20.98KB) (763μs)
  • afterRenderModule mod_custom (Imprint) (18.66KB) (656μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (86μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (111.3KB) (1.34ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.44KB) (266μs)
  • beforeRenderModule mod_languages (Language) (488B) (48μs)
  • afterRenderModule mod_languages (Language) (6.44KB) (200μs)
  • beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (27μs)
  • afterRenderModule mod_accordeonmenuck (User Menu) (2.94KB) (178μs)
  • beforeRenderModule mod_accordeonmenuck (Accordeon Menu DE) (912B) (26μs)
  • afterRenderModule mod_accordeonmenuck (Accordeon Menu DE) (70.45KB) (203μs)
  • beforeRenderModule mod_custom (How to help us?) (59.55KB) (32μs)
  • afterRenderModule mod_custom (How to help us?) (3.19KB) (175μs)
  • beforeRenderModule mod_whosonline (Who is online) (64.98KB) (19μs)
  • afterRenderModule mod_whosonline (Who is online) (2.75KB) (173μs)
  • beforeRenderModule mod_finder (Search) (1.13KB) (44μs)
  • afterRenderModule mod_finder (Search) (2.92KB) (105μs)
  • afterRender (853.39KB) (21.55ms)
  • 1 x afterInitialise (7.4MB) (24.65%)
    73.40ms
    1 x afterRenderComponent com_content (1.62MB) (11.91%)
    35.48ms
    1 x afterRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (1.79MB) (10.81%)
    32.20ms
    1 x afterLoad (3.58MB) (9.53%)
    28.37ms
    1 x afterRender (853.39KB) (7.24%)
    21.55ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (1.06MB) (5.23%)
    15.58ms
    1 x afterRoute (1.92MB) (4.38%)
    13.04ms
    1 x afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (4.21%)
    12.55ms
    1 x beforeRenderRawModule mod_languages (Language) (699.45KB) (4.12%)
    12.27ms
    1 x beforeRenderComponent com_content (1.1MB) (3.72%)
    11.06ms
    1 x afterRenderRawModule mod_finder (Search) (605.09KB) (3.63%)
    10.80ms
    1 x Before Access::preloadComponents (all components) (725.15KB) (2.6%)
    7.75ms
    1 x afterRenderRawModule mod_languages (Language) (92.1KB) (2.49%)
    7.42ms
    1 x afterDispatch (184.78KB) (1.53%)
    4.57ms
    1 x After Access::preloadPermissions (com_content) (409.86KB) (0.52%)
    1.54ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (111.3KB) (0.45%)
    1.34ms
    1 x afterRenderRawModule mod_whosonline (Who is online) (27.36KB) (0.43%)
    1.29ms
    1 x After Access::preloadComponents (all components) (113.55KB) (0.36%)
    1.07ms
    1 x beforeRenderModule mod_custom (Imprint) (20.98KB) (0.26%)
    763μs
    1 x afterRenderRawModule mod_custom (How to help us?) (9.27KB) (0.25%)
    751μs
    1 x afterRenderModule mod_custom (Imprint) (18.66KB) (0.22%)
    656μs
    1 x After Access::getAssetRules (id:1358 name:com_content.article.315) (27.66KB) (0.18%)
    532μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.44KB) (0.09%)
    266μs
    1 x afterRenderModule mod_accordeonmenuck (Accordeon Menu DE) (70.45KB) (0.07%)
    203μs
    1 x afterRenderModule mod_languages (Language) (6.44KB) (0.07%)
    200μs
    1 x afterRenderRawModule mod_custom (Imprint) (1.08KB) (0.07%)
    194μs
    1 x afterRenderModule mod_accordeonmenuck (User Menu) (2.94KB) (0.06%)
    178μs
    1 x afterRenderModule mod_custom (How to help us?) (3.19KB) (0.06%)
    175μs
    1 x afterRenderModule mod_whosonline (Who is online) (2.75KB) (0.06%)
    173μs
    1 x afterRenderModule mod_finder (Search) (2.92KB) (0.04%)
    105μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (0.03%)
    86μs
    1 x beforeRenderRawModule mod_custom (Imprint) (464B) (0.03%)
    85μs
    1 x beforeRenderRawModule mod_finder (Search) (1.49KB) (0.02%)
    60μs
    1 x beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (0.02%)
    48μs
    1 x beforeRenderModule mod_languages (Language) (488B) (0.02%)
    48μs
    1 x beforeRenderModule mod_finder (Search) (1.13KB) (0.01%)
    44μs
    1 x Before Access::getAssetRules (id:1358 name:com_content.article.315) (18.65KB) (0.01%)
    41μs
    1 x beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (672B) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (0.01%)
    32μs
    1 x beforeRenderModule mod_custom (How to help us?) (59.55KB) (0.01%)
    32μs
    1 x beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (0.01%)
    27μs
    1 x beforeRenderModule mod_accordeonmenuck (Accordeon Menu DE) (912B) (0.01%)
    26μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    22μs
    1 x beforeRenderModule mod_whosonline (Who is online) (64.98KB) (0.01%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_whosonline (Who is online) (576B) (0.01%)
    18μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
39 statements were executed, 8 of which were duplicates, 31 unique21.37ms730.72KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;170μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `haisly_session` WHERE `session_id` = ?264μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = :session_id LIMIT 1149μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `haisly_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)229μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `haisly_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1647μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `haisly_viewlevels`240μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `haisly_usergroups` AS `a` LEFT JOIN `haisly_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest210μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `haisly_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`945μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `haisly_languages` WHERE `published` = 1 ORDER BY `ordering` ASC216μs2.52KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `haisly_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1321μs1.55KB/libraries/src/Language/LanguageHelper.php:252Copy
  • 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 `haisly_menu` AS `m` LEFT JOIN `haisly_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`3.37ms555.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `haisly_template_styles` AS `s` LEFT JOIN `haisly_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` = 1352μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `haisly_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)717μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `haisly_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0525μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `haisly_content`354μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `haisly_content` SET `hits` = (`hits` + 1) WHERE `id` = '315'222μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `haisly_content` AS `a` INNER JOIN `haisly_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `haisly_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `haisly_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `haisly_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `haisly_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)552μs23.44KBParams/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 `haisly_categories` AS `s` INNER JOIN `haisly_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`753μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `haisly_contentitem_tag_map` AS `m` INNER JOIN `haisly_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)470μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `haisly_content` AS `c` INNER JOIN `haisly_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `haisly_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `haisly_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `haisly_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'de-DE' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-06-30 14:55:30') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-30 14:55:30') AND c2.state = 1299μs1.47KBParams/libraries/src/Language/Associations.php:145Copy
  • 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 `haisly_categories` AS `s` INNER JOIN `haisly_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`514μs3.98KBParams/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 haisly_fields AS a LEFT JOIN `haisly_languages` AS l ON l.lang_code = a.language LEFT JOIN haisly_users AS uc ON uc.id=a.checked_out LEFT JOIN haisly_viewlevels AS ag ON ag.id = a.access LEFT JOIN haisly_users AS ua ON ua.id = a.created_user_id LEFT JOIN haisly_fields_groups AS g ON g.id = a.group_id LEFT JOIN `haisly_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 AND `a`.`language` IN (:preparedArray7,:preparedArray8) ORDER BY a.ordering ASC1.06ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `haisly_content` AS `a` LEFT JOIN `haisly_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) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC972μs1.81KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT `language`,`id` FROM `haisly_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0657μs736B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias`,`catid` FROM haisly_content WHERE `id` = :key156μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `haisly_menu` AS `c` INNER JOIN `haisly_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `haisly_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `haisly_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id321μs1.38KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `haisly_modules` AS `m` LEFT JOIN `haisly_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `haisly_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`2.87ms1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id404μs19.27KB/administrator/components/com_accordeonmenuck/helpers/ckfof.php:165Copy
  • SELECT a.layoutcss, a.customcss FROM haisly_accordeonmenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 1242μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id370μs19.27KB/administrator/components/com_accordeonmenuck/helpers/ckfof.php:165Copy
  • SELECT a.layoutcss, a.customcss FROM haisly_accordeonmenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 1158μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT guest, client_id FROM haisly_session WHERE client_id = 0228μs1KB/modules/mod_whosonline/src/Helper/WhosonlineHelper.php:51Copy
  • SELECT `name`,`element` FROM `haisly_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1562μs3.14KB/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `haisly_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)284μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `haisly_schemaorg` WHERE `itemId` = :itemId AND `context` = :context185μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `haisly_content` AS `a` INNER JOIN `haisly_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `haisly_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `haisly_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `haisly_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `haisly_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)665μs22.23KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `haisly_scheduler_tasks` AS `a` WHERE `a`.`state` = 1296μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = ?162μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `haisly_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?258μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy