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 297 Gäste und keine Mitglieder online

Drop2Number+kopieren - Mehrfach Umbenennen

Details
Geschrieben von: admin
Kategorie: Programme
Zugriffe: 2436

System: Haiku 

System: Haiku Alpha 2
D2N+C Version 1.1
Modules: libncurses.so

Drop2Number and Copy ist eine kleine Anwendung, mit welcher man Dateien und Ordner durchnummerieren und umbenennen kann.

d2nc dropzone

Vorlage für dieses Programm ist eine Funktion von ACDSee (Windows), welche alle markierten Dateien über eine Rename Funktion durchnummerieren und umbenenne kann. Solch ein Programm wollte ich schon zu Zeiten von Zeta erstellen, jedoch hat jemand anderes ein solches bereits gemacht gehabt (Rename). Der Aufbau dieses Programms ist allerdings ganz anders. Hier werden alle in eine Dropbox gezogenen Dateien und Ordner nummeriert und/oder umbenannt. Hierzu hat der Benutzer mehrere Einstellungsmöglichkeiten.

1. Installation

Zur Installation des Programms benötigst Du nur die libncurses Librarie, da die Anwendung in yab geschrieben wurde und das Haiku System diese bis dato nicht als Standard Librarie mit Ausliefert. Die Librarie war in der von uns verwendeten Version von D2N+C enthalten. Sollte diese nicht dabei sein beziehe sie am besten über Haikuware. Um die Librarie zu installieren, kopieren/verschiebe diese einfach nach /boot/home/config/lib.

2. Einstellungen

d2nc settings

D2N+C bietet eine Vielzahl an Einstellungsmöglichkeiten rund um umbenennen und nummerieren. Hierzu gehören Nummernposition, Trennzeichen, Zahlenwerte und vieles mehr.

2.1 Target Folder

Bei Target Folder geben sie das Verzeichnis an, in welches die bearbeiteten Dateien abgelegt werden sollen. Drücke dazu einfach den "set" Knopf und durchsuche das System nach den Zielordner deiner Wahl. Diesen musst du dann markieren und auf "Open" drücken. Wurde das Verzeichnis richtig erkannt, wird dessen Pfad in der Adresszeile des Target Folders angezeigt.

2.2 Change Filename

Wenn man die Checkbox bei "Change Filename" aktiviert, werden alle Dateien die mit D2N+C bearbeitet werden auf diesen Namen geändert. Um einen Namen anzugeben, gebe diesen einfach in das Eingabefeld ein.

2.3 Copy/Move File

Bei "Copy File" und "Move File" kann man einstellen, was mit der Originaldatei geschehen soll. Entwerder diese wird kopiert (copy) oder sie wird Verschoben (Move). Oftmals ist es ratsam die Originaldateien beizubehalten, daher ist die "Copy File" Funktion als Standard ausgewählt.

2.4 Number at first/end position

Hier kann man angeben, wo die angefügte Nummer positioniert werden soll. Entweder am Anfang (first position) einer jeden Datei oder am Ende(end position). Wie dies in etwa aussieht wird neben dieser Einstellungsmöglichkeit live dargestellt.

2.5 Use Seperator

Wer zwischen der Datei und der Nummerierung ein Trennzeichen haben möchte, kann dies machen, indem er die "Use Seperator" Funktion aktiviert. Nach der Aktivierung kann in der dahinter angezeigten Dropbox eines von mehreren Zeichen ausgewählt werden.

2.6 Starting with number

Bei "Starting with numer" kann man angeben, mit welcher Nummer die Umbenennung beginnen soll. Außerdem kann man angeben wie viele Stellen die Nummerierung haben soll 1,01,001,0001, dies ermöglicht bei großen Dateimengen eine bessere Übersicht.

Um alle Einstellungen zu Übernehmen drücke auf "take over".

3. Bedienung

d2nc proceed

Die Bedienung der Anwendung ist denkbar einfach. Markiere eine oder mehrere Dateien und verschiebe diese mit Hilfe der Mouse auf die "Dropzone". Dabei werden die Dateien vom Programm in das angegebene Zielverzeichnis kopiert oder verschoben. Während dieses Vorganges werden dann die Dateien umbenannt und nummeriert. Jede Datei die auf die Dropzone geschoben wird, wird mit dessen originalen Namen in der "Doppped Files" Liste aufgeführt. Dies dient zur Kontrolle, falls man die Namen Ändert und sich unsicher ist, welche Datei zuvor verschoben wurde.

Tutorial by Christian Albrecht (Lelldorin) März 2011
Made available by BeSly, the BeOS, Haiku and Zeta knowledge base.

J! InfoRequestSessionProfileQueries39
Settings24.129MBMemory Usage486msRequest 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" => 1750713749 "last" => 1750713749...
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) (43.09ms)
  • afterInitialise (7.4MB) (120ms)
  • afterRoute (1.92MB) (21.58ms)
  • beforeRenderComponent com_content (1.1MB) (20.63ms)
  • Before Access::preloadComponents (all components) (725.15KB) (15.04ms)
  • After Access::preloadComponents (all components) (113.55KB) (3.6ms)
  • Before Access::preloadPermissions (com_content) (424B) (30μs)
  • After Access::preloadPermissions (com_content) (409.86KB) (2.9ms)
  • Before Access::getAssetRules (id:1355 name:com_content.article.312) (18.65KB) (80μs)
  • After Access::getAssetRules (id:1355 name:com_content.article.312) (27.66KB) (1.24ms)
  • Before Access::getAssetRules (id:8 name:com_content) (1.06MB) (30.42ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (24μs)
  • afterRenderComponent com_content (1.61MB) (72.48ms)
  • afterDispatch (184.83KB) (4.43ms)
  • beforeRenderRawModule mod_languages (Language) (699.45KB) (17.79ms)
  • afterRenderRawModule mod_languages (Language) (92.07KB) (13.01ms)
  • beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (35μs)
  • afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (19.12ms)
  • beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (672B) (35μs)
  • afterRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (1.79MB) (34.74ms)
  • beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (33μs)
  • afterRenderRawModule mod_custom (How to help us?) (9.27KB) (1.5ms)
  • beforeRenderRawModule mod_whosonline (Who is online) (576B) (20μs)
  • afterRenderRawModule mod_whosonline (Who is online) (27.36KB) (2.35ms)
  • beforeRenderRawModule mod_finder (Search) (1.49KB) (67μs)
  • afterRenderRawModule mod_finder (Search) (605.09KB) (18.69ms)
  • beforeRenderRawModule mod_custom (Imprint) (464B) (180μs)
  • afterRenderRawModule mod_custom (Imprint) (1.08KB) (707μs)
  • beforeRenderModule mod_custom (Imprint) (20.98KB) (1.9ms)
  • afterRenderModule mod_custom (Imprint) (18.66KB) (1.55ms)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (89μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (112.41KB) (2.16ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.56KB) (433μs)
  • beforeRenderModule mod_languages (Language) (488B) (53μs)
  • afterRenderModule mod_languages (Language) (6.44KB) (200μs)
  • beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (28μs)
  • afterRenderModule mod_accordeonmenuck (User Menu) (2.94KB) (183μs)
  • beforeRenderModule mod_accordeonmenuck (Accordeon Menu DE) (912B) (27μs)
  • afterRenderModule mod_accordeonmenuck (Accordeon Menu DE) (70.45KB) (180μs)
  • beforeRenderModule mod_custom (How to help us?) (59.55KB) (32μs)
  • afterRenderModule mod_custom (How to help us?) (3.19KB) (201μs)
  • beforeRenderModule mod_whosonline (Who is online) (64.98KB) (20μs)
  • afterRenderModule mod_whosonline (Who is online) (2.75KB) (175μs)
  • beforeRenderModule mod_finder (Search) (1.13KB) (45μs)
  • afterRenderModule mod_finder (Search) (2.92KB) (106μs)
  • afterRender (853.89KB) (31.5ms)
  • 1 x afterInitialise (7.4MB) (24.68%)
    120ms
    1 x afterRenderComponent com_content (1.61MB) (14.92%)
    72.48ms
    1 x afterLoad (3.58MB) (8.87%)
    43.09ms
    1 x afterRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (1.79MB) (7.15%)
    34.74ms
    1 x afterRender (853.89KB) (6.48%)
    31.50ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (1.06MB) (6.26%)
    30.42ms
    1 x afterRoute (1.92MB) (4.44%)
    21.58ms
    1 x beforeRenderComponent com_content (1.1MB) (4.25%)
    20.63ms
    1 x afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (3.94%)
    19.12ms
    1 x afterRenderRawModule mod_finder (Search) (605.09KB) (3.85%)
    18.69ms
    1 x beforeRenderRawModule mod_languages (Language) (699.45KB) (3.66%)
    17.79ms
    1 x Before Access::preloadComponents (all components) (725.15KB) (3.1%)
    15.04ms
    1 x afterRenderRawModule mod_languages (Language) (92.07KB) (2.68%)
    13.01ms
    1 x afterDispatch (184.83KB) (0.91%)
    4.43ms
    1 x After Access::preloadComponents (all components) (113.55KB) (0.74%)
    3.60ms
    1 x After Access::preloadPermissions (com_content) (409.86KB) (0.6%)
    2.90ms
    1 x afterRenderRawModule mod_whosonline (Who is online) (27.36KB) (0.48%)
    2.35ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (112.41KB) (0.44%)
    2.16ms
    1 x beforeRenderModule mod_custom (Imprint) (20.98KB) (0.39%)
    1.90ms
    1 x afterRenderModule mod_custom (Imprint) (18.66KB) (0.32%)
    1.55ms
    1 x afterRenderRawModule mod_custom (How to help us?) (9.27KB) (0.31%)
    1.50ms
    1 x After Access::getAssetRules (id:1355 name:com_content.article.312) (27.66KB) (0.25%)
    1.24ms
    1 x afterRenderRawModule mod_custom (Imprint) (1.08KB) (0.15%)
    707μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.56KB) (0.09%)
    433μs
    1 x afterRenderModule mod_custom (How to help us?) (3.19KB) (0.04%)
    201μs
    1 x afterRenderModule mod_languages (Language) (6.44KB) (0.04%)
    200μs
    1 x afterRenderModule mod_accordeonmenuck (User Menu) (2.94KB) (0.04%)
    183μs
    1 x beforeRenderRawModule mod_custom (Imprint) (464B) (0.04%)
    180μs
    1 x afterRenderModule mod_accordeonmenuck (Accordeon Menu DE) (70.45KB) (0.04%)
    180μs
    1 x afterRenderModule mod_whosonline (Who is online) (2.75KB) (0.04%)
    175μs
    1 x afterRenderModule mod_finder (Search) (2.92KB) (0.02%)
    106μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (0.02%)
    89μs
    1 x Before Access::getAssetRules (id:1355 name:com_content.article.312) (18.65KB) (0.02%)
    80μs
    1 x beforeRenderRawModule mod_finder (Search) (1.49KB) (0.01%)
    67μs
    1 x beforeRenderModule mod_languages (Language) (488B) (0.01%)
    53μs
    1 x beforeRenderModule mod_finder (Search) (1.13KB) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (0.01%)
    35μs
    1 x beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu DE) (672B) (0.01%)
    35μs
    1 x beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (0.01%)
    33μs
    1 x beforeRenderModule mod_custom (How to help us?) (59.55KB) (0.01%)
    32μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    30μs
    1 x beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (0.01%)
    28μs
    1 x beforeRenderModule mod_accordeonmenuck (Accordeon Menu DE) (912B) (0.01%)
    27μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0%)
    24μs
    1 x beforeRenderRawModule mod_whosonline (Who is online) (576B) (0%)
    20μs
    1 x beforeRenderModule mod_whosonline (Who is online) (64.98KB) (0%)
    20μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    6μs
39 statements were executed, 8 of which were duplicates, 31 unique58.69ms738.28KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;160μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `haisly_session` WHERE `session_id` = ?810μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = :session_id LIMIT 199μ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)754μ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` = 12.95ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `haisly_viewlevels`400μ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` = :guest591μ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`774μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `haisly_languages` WHERE `published` = 1 ORDER BY `ordering` ASC929μ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` = 1452μ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`7.75ms555.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` = 11.39ms848B/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)3.01ms7.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` = 0637μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `haisly_content`986μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `haisly_content` SET `hits` = (`hits` + 1) WHERE `id` = '312'647μ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)1.9ms23.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`1.45ms3.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)1.7ms3.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-23 21:22:29') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-23 21:22:29') AND c2.state = 1780μ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`849μ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 ASC2.42ms4.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 DESC16.25ms1.81KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT `language`,`id` FROM `haisly_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0586μs736B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias`,`catid` FROM haisly_content WHERE `id` = :key135μ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` = :id399μ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`3.04ms1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id499μ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 = 1558μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id489μ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 = 1230μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT guest, client_id FROM haisly_session WHERE client_id = 0482μs8.56KB/modules/mod_whosonline/src/Helper/WhosonlineHelper.php:51Copy
  • SELECT `name`,`element` FROM `haisly_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1304μ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)1.49ms648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `haisly_schemaorg` WHERE `itemId` = :itemId AND `context` = :context716μ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)691μ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` = 1966μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = ?181μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `haisly_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?227μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy