System: Haiku

zip GUI is a user interface for the command line tool zip.

Long time i miss a GUI for the command line tool zip, that set a password to it. Then I take a near look at the zip command and finally get created a zip file with password. Since the idea to create a own GUI for the zip command are born.

structure

The structure of the program is based on the haiku Expander. I like this program due to its simplicity.

zipgui01



To add files to the program use the Source button or Drag and Drop to the program. All files are listed into the source list.

You can enter at Target the output folder.

Use the buttons zip and unzip to compressed or decompressed a specified tar archive.

zipgui02



If you want to list all entries of a zip archive, select a archive in the source list and activate the check box contents.



Then you activate the check box all files, all files of the source list will be compressed or decompressed.



To enter the preferences use the File menu and then the option Preferences.

  • You can specify a different default output folder at default target folder.
  • If you mark "-1": "compress archive faster", it compress the zip file quickly.
  • If you mark "-9": "compress archive better", it compress the zip file faster.
  • If you mark "-A": "adjust "self-extracting exe", it creates a self extracting archive.
  • If you mark "-e": "set "password" to zip file", it add a password to the zip file.

     

    If this function is enabled, the password is requested twice to avoid misrepresentation.

    ../../../..

  • If you mark "-f": "freshen": add only changed files", be added to an existing archive only changed files.
    If this function is activated, an existing file when you press on the "zip", are requested.
  • If you mark "-u": "update": add only changed or new files", be added to an existing archive only changed or new files.
    If this function is activated, an existing file when you press on the "zip", are requested.
  • If you mark "-y": "store "symbolic links" as link instead of the referenced file", all add links, there added as correct directories and files.

 

All settings are as they were changed, effective immediately.

 

Documentation by Christian Albrecht (Lelldorin) Juni 2014
Made available by BeSly, the Haiku, BeOS and Zeta knowledge base.

Settings23.561MBMemory Usage286msRequest 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" => 1751263736 "last" => 1751263736...
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" => "en-GB" ]
  • afterLoad (3.58MB) (29.2ms)
  • afterInitialise (7.4MB) (70.46ms)
  • afterRoute (1.55MB) (8.03ms)
  • beforeRenderComponent com_content (1.1MB) (11.06ms)
  • Before Access::preloadComponents (all components) (724.44KB) (7.79ms)
  • After Access::preloadComponents (all components) (113.55KB) (1.19ms)
  • Before Access::preloadPermissions (com_content) (424B) (17μs)
  • After Access::preloadPermissions (com_content) (409.86KB) (1.6ms)
  • Before Access::getAssetRules (id:1183 name:com_content.article.160) (18.65KB) (37μs)
  • After Access::getAssetRules (id:1183 name:com_content.article.160) (27.66KB) (373μs)
  • Before Access::getAssetRules (id:8 name:com_content) (1.05MB) (17.13ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (20μs)
  • afterRenderComponent com_content (1.61MB) (33.31ms)
  • afterDispatch (184.52KB) (4.54ms)
  • beforeRenderRawModule mod_languages (Language) (699.45KB) (10.17ms)
  • afterRenderRawModule mod_languages (Language) (90.09KB) (7.38ms)
  • beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (34μs)
  • afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (11.59ms)
  • beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (672B) (55μs)
  • afterRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (1.66MB) (31.68ms)
  • beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (40μs)
  • afterRenderRawModule mod_custom (How to help us?) (9.02KB) (1ms)
  • beforeRenderRawModule mod_whosonline (Who is online) (576B) (28μs)
  • afterRenderRawModule mod_whosonline (Who is online) (27.11KB) (2.01ms)
  • beforeRenderRawModule mod_finder (Search) (1.49KB) (80μs)
  • afterRenderRawModule mod_finder (Search) (603.16KB) (10.52ms)
  • beforeRenderRawModule mod_custom (Imprint) (464B) (135μs)
  • afterRenderRawModule mod_custom (Imprint) (1.08KB) (303μs)
  • beforeRenderModule mod_custom (Imprint) (20.98KB) (1.16ms)
  • afterRenderModule mod_custom (Imprint) (18.66KB) (729μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (86μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (32.16KB) (1.24ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.56KB) (270μs)
  • beforeRenderModule mod_languages (Language) (488B) (71μs)
  • afterRenderModule mod_languages (Language) (6.44KB) (216μs)
  • beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (29μs)
  • afterRenderModule mod_accordeonmenuck (User Menu) (2.88KB) (181μs)
  • beforeRenderModule mod_accordeonmenuck (Accordeon Menu EN) (912B) (27μs)
  • afterRenderModule mod_accordeonmenuck (Accordeon Menu EN) (66.45KB) (205μs)
  • beforeRenderModule mod_custom (How to help us?) (55.61KB) (21μs)
  • afterRenderModule mod_custom (How to help us?) (3.19KB) (179μs)
  • beforeRenderModule mod_whosonline (Who is online) (64.98KB) (17μs)
  • afterRenderModule mod_whosonline (Who is online) (2.69KB) (170μs)
  • beforeRenderModule mod_finder (Search) (1.07KB) (43μs)
  • afterRenderModule mod_finder (Search) (2.92KB) (116μs)
  • afterRender (913KB) (19.93ms)
  • 1 x afterInitialise (7.4MB) (24.64%)
    70.46ms
    1 x afterRenderComponent com_content (1.61MB) (11.65%)
    33.31ms
    1 x afterRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (1.66MB) (11.08%)
    31.68ms
    1 x afterLoad (3.58MB) (10.21%)
    29.20ms
    1 x afterRender (913KB) (6.97%)
    19.93ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (1.05MB) (5.99%)
    17.13ms
    1 x afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (4.05%)
    11.59ms
    1 x beforeRenderComponent com_content (1.1MB) (3.87%)
    11.06ms
    1 x afterRenderRawModule mod_finder (Search) (603.16KB) (3.68%)
    10.52ms
    1 x beforeRenderRawModule mod_languages (Language) (699.45KB) (3.56%)
    10.17ms
    1 x afterRoute (1.55MB) (2.81%)
    8.03ms
    1 x Before Access::preloadComponents (all components) (724.44KB) (2.72%)
    7.79ms
    1 x afterRenderRawModule mod_languages (Language) (90.09KB) (2.58%)
    7.38ms
    1 x afterDispatch (184.52KB) (1.59%)
    4.54ms
    1 x afterRenderRawModule mod_whosonline (Who is online) (27.11KB) (0.7%)
    2.01ms
    1 x After Access::preloadPermissions (com_content) (409.86KB) (0.56%)
    1.60ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (32.16KB) (0.43%)
    1.24ms
    1 x After Access::preloadComponents (all components) (113.55KB) (0.42%)
    1.19ms
    1 x beforeRenderModule mod_custom (Imprint) (20.98KB) (0.41%)
    1.16ms
    1 x afterRenderRawModule mod_custom (How to help us?) (9.02KB) (0.35%)
    1.00ms
    1 x afterRenderModule mod_custom (Imprint) (18.66KB) (0.25%)
    729μs
    1 x After Access::getAssetRules (id:1183 name:com_content.article.160) (27.66KB) (0.13%)
    373μs
    1 x afterRenderRawModule mod_custom (Imprint) (1.08KB) (0.11%)
    303μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.56KB) (0.09%)
    270μs
    1 x afterRenderModule mod_languages (Language) (6.44KB) (0.08%)
    216μs
    1 x afterRenderModule mod_accordeonmenuck (Accordeon Menu EN) (66.45KB) (0.07%)
    205μs
    1 x afterRenderModule mod_accordeonmenuck (User Menu) (2.88KB) (0.06%)
    181μs
    1 x afterRenderModule mod_custom (How to help us?) (3.19KB) (0.06%)
    179μs
    1 x afterRenderModule mod_whosonline (Who is online) (2.69KB) (0.06%)
    170μs
    1 x beforeRenderRawModule mod_custom (Imprint) (464B) (0.05%)
    135μs
    1 x afterRenderModule mod_finder (Search) (2.92KB) (0.04%)
    116μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (0.03%)
    86μs
    1 x beforeRenderRawModule mod_finder (Search) (1.49KB) (0.03%)
    80μs
    1 x beforeRenderModule mod_languages (Language) (488B) (0.02%)
    71μs
    1 x beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (672B) (0.02%)
    55μs
    1 x beforeRenderModule mod_finder (Search) (1.07KB) (0.02%)
    43μs
    1 x beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (0.01%)
    40μs
    1 x Before Access::getAssetRules (id:1183 name:com_content.article.160) (18.65KB) (0.01%)
    37μs
    1 x beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (0.01%)
    34μs
    1 x beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_whosonline (Who is online) (576B) (0.01%)
    28μs
    1 x beforeRenderModule mod_accordeonmenuck (Accordeon Menu EN) (912B) (0.01%)
    27μs
    1 x beforeRenderModule mod_custom (How to help us?) (55.61KB) (0.01%)
    21μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_whosonline (Who is online) (64.98KB) (0.01%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    17μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    6μs
39 statements were executed, 8 of which were duplicates, 31 unique20.36ms738.23KB
  • SELECT @@SESSION.sql_mode;127μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `haisly_session` WHERE `session_id` = ?819μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = :session_id LIMIT 1101μ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)184μ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` = 1413μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `haisly_viewlevels`103μ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` = :guest183μ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`513μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `haisly_languages` WHERE `published` = 1 ORDER BY `ordering` ASC203μ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` = 1268μ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`2.25ms555.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` = 1371μ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)796μ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` = 0608μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `haisly_content`393μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `haisly_content` SET `hits` = (`hits` + 1) WHERE `id` = '160'178μ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.06ms23.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`825μ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)535μ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 != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-06-30 06:08:56') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-30 06:08:56') AND c2.state = 1349μ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`716μ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,: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 AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC1.46ms4.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 DESC620μs1.77KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT `language`,`id` FROM `haisly_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0639μs736B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias`,`catid` FROM haisly_content WHERE `id` = :key133μ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` = :id312μ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`1.94ms1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id247μ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 = 1157μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id349μ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 = 1611μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT guest, client_id FROM haisly_session WHERE client_id = 0425μs8.56KB/modules/mod_whosonline/src/Helper/WhosonlineHelper.php:51Copy
  • SELECT `name`,`element` FROM `haisly_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1431μ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)242μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `haisly_schemaorg` WHERE `itemId` = :itemId AND `context` = :context556μ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)610μ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` = 1225μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = ?145μ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