Already at BeOS times I've heard of the game, but it never looked at it closer. I have trying to get it somewhere, but it was not available.

After i have read a report on the Blog by Pistooli, who report that the game is easily installable and playable on Haiku, I buy the game over eBay too.

The Story

The intro reports that the gangster Bernie Berckson was sentenced to death and he manages to escape during the execution.

First far away this action, the game begins in the home of the FBI agents Hopkins. This is called to a bank robbery with hostage-taking.

An eventful, exciting and agile story takes its course ...

The installation

Hopkins FBI comes as BeOS package file (pkg) and can be easily installed on this.



Put in the CD and mount it (if this does not mount automatically).

Do a double click on the Hopkins.pkg:



Make the installation according to the instructions of the installer.

Starting the game

After the installation the game is selectable over the Application menu.

 

To play the game, the CD must be insert

 



Start the game by selecting Play Game.

The controls

The game is controlled by the mouse. If you move your cursor over an object, you can see if an action is possible, one or more options. Choose the appropriate and click the left mouse button.

The inventory is just over an icon to open. Again, is selected with the mouse.
Combining inventory items is a bit awkward because you have selected an item from the inventory, the menu is automatically closed and then has to be reopened.

Some portions game played in first-person shooter style, here also the arrow keys are used in addition to the Mouse.

Avoid continuous use of the CD

As described above, the CD of the game must be inserted to play the game. With a little manual labor can prevent this however.

During installation, a directory is created with the start file and the SAVE- folder.

As the game tries to access the CD with the name HOPKINS we have to offer it a alternative.

We create an image file, which we later before playing mount instead of putting the CD. Open a terminal and enter the following command:

dd if=/dev/zero of=/boot/home/Desktop/hopkinsFBI.image bs=1024k count=510


Then we format the image file with the BFS file system (be file system) and rename the image file with the same name of the CD:

    • Haiku past changing to mkfs

      mkfs /boot/home/Desktop/hopkinsFBI.image /HOPKINS2

 

  • BeOS, Zeta, Haiku with mkbfs

    mkbfs 2048 "/boot/home/Desktop/hopkinsFBI.image"

    sync

    Now we have the image file to mount in order to rename it:

    mkdir /mnt

    mount -t bfs "/boot/home/Desktop/hopkinsFBI.image" /mnt

    Select the icon of the mounted image file and rename it to HOPKINS2.


Now mount the image file:

Under current Haiku versions, the mounting of image files is possible super easy as double-clicking on the image file.

Now insert the CD of the game and mount these too.



Now copy the directory HOPDATA of the CD into the image file.

Then unmount the CD and rename the mounted image file into HOPKINS. To do this click on the name of the desktop icon of the image file.

Then go to the copied folder in the image file and open the directory where is the startup file of the game.

    • Haiku with Package Management System

      /boot/system/non-packaged/apps/HOPKINS

 

  • BeOS, Zeta, and older Haiku versions

    /boot/apps/HOPKINS

 



Create out of the image file links of the folders LINK, SOUND and SYSTEM.

Now you can play the game without the CD with previous mount the image file start.

Tutorial by Christian Albrecht (Lelldorin) January 2016 | Translation June 2016
Made available by BeSly, the Haiku knowledge base.
Settings23.628MBMemory Usage372msRequest 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" => 1751009736 "last" => 1751009736...
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) (39.56ms)
  • afterInitialise (7.4MB) (85.67ms)
  • afterRoute (1.55MB) (13.57ms)
  • beforeRenderComponent com_content (1.1MB) (13.29ms)
  • Before Access::preloadComponents (all components) (724.44KB) (10.2ms)
  • After Access::preloadComponents (all components) (113.55KB) (3.53ms)
  • Before Access::preloadPermissions (com_content) (424B) (21μs)
  • After Access::preloadPermissions (com_content) (409.86KB) (2.24ms)
  • Before Access::getAssetRules (id:1093 name:com_content.article.78) (18.65KB) (50μs)
  • After Access::getAssetRules (id:1093 name:com_content.article.78) (27.66KB) (1.06ms)
  • Before Access::getAssetRules (id:8 name:com_content) (1.08MB) (33.93ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (22μs)
  • afterRenderComponent com_content (1.65MB) (61.91ms)
  • afterDispatch (184.42KB) (4.13ms)
  • beforeRenderRawModule mod_languages (Language) (699.45KB) (11.52ms)
  • afterRenderRawModule mod_languages (Language) (90.12KB) (7.96ms)
  • beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (35μs)
  • afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (12.89ms)
  • beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (672B) (51μs)
  • afterRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (1.66MB) (28.75ms)
  • beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (33μs)
  • afterRenderRawModule mod_custom (How to help us?) (9.02KB) (727μs)
  • beforeRenderRawModule mod_whosonline (Who is online) (576B) (22μs)
  • afterRenderRawModule mod_whosonline (Who is online) (27.11KB) (1.39ms)
  • beforeRenderRawModule mod_finder (Search) (1.49KB) (68μs)
  • afterRenderRawModule mod_finder (Search) (603.16KB) (10.57ms)
  • beforeRenderRawModule mod_custom (Imprint) (464B) (94μs)
  • afterRenderRawModule mod_custom (Imprint) (1.08KB) (294μs)
  • beforeRenderModule mod_custom (Imprint) (20.98KB) (1.14ms)
  • afterRenderModule mod_custom (Imprint) (18.66KB) (807μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (85μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (31.05KB) (1.21ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.44KB) (269μs)
  • beforeRenderModule mod_languages (Language) (488B) (48μs)
  • afterRenderModule mod_languages (Language) (6.44KB) (194μs)
  • beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (28μs)
  • afterRenderModule mod_accordeonmenuck (User Menu) (2.88KB) (180μs)
  • beforeRenderModule mod_accordeonmenuck (Accordeon Menu EN) (912B) (27μs)
  • afterRenderModule mod_accordeonmenuck (Accordeon Menu EN) (66.45KB) (225μs)
  • beforeRenderModule mod_custom (How to help us?) (55.61KB) (22μs)
  • afterRenderModule mod_custom (How to help us?) (3.19KB) (181μs)
  • beforeRenderModule mod_whosonline (Who is online) (64.98KB) (17μs)
  • afterRenderModule mod_whosonline (Who is online) (2.69KB) (172μs)
  • beforeRenderModule mod_finder (Search) (1.07KB) (45μs)
  • afterRenderModule mod_finder (Search) (2.92KB) (107μs)
  • afterRender (913KB) (22.43ms)
  • 1 x afterInitialise (7.4MB) (23.02%)
    85.67ms
    1 x afterRenderComponent com_content (1.65MB) (16.64%)
    61.91ms
    1 x afterLoad (3.58MB) (10.63%)
    39.56ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (1.08MB) (9.12%)
    33.93ms
    1 x afterRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (1.66MB) (7.73%)
    28.75ms
    1 x afterRender (913KB) (6.03%)
    22.43ms
    1 x afterRoute (1.55MB) (3.65%)
    13.57ms
    1 x beforeRenderComponent com_content (1.1MB) (3.57%)
    13.29ms
    1 x afterRenderRawModule mod_accordeonmenuck (User Menu) (1.17MB) (3.46%)
    12.89ms
    1 x beforeRenderRawModule mod_languages (Language) (699.45KB) (3.1%)
    11.52ms
    1 x afterRenderRawModule mod_finder (Search) (603.16KB) (2.84%)
    10.57ms
    1 x Before Access::preloadComponents (all components) (724.44KB) (2.74%)
    10.20ms
    1 x afterRenderRawModule mod_languages (Language) (90.12KB) (2.14%)
    7.96ms
    1 x afterDispatch (184.42KB) (1.11%)
    4.13ms
    1 x After Access::preloadComponents (all components) (113.55KB) (0.95%)
    3.53ms
    1 x After Access::preloadPermissions (com_content) (409.86KB) (0.6%)
    2.24ms
    1 x afterRenderRawModule mod_whosonline (Who is online) (27.11KB) (0.37%)
    1.39ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (31.05KB) (0.32%)
    1.21ms
    1 x beforeRenderModule mod_custom (Imprint) (20.98KB) (0.31%)
    1.14ms
    1 x After Access::getAssetRules (id:1093 name:com_content.article.78) (27.66KB) (0.28%)
    1.06ms
    1 x afterRenderModule mod_custom (Imprint) (18.66KB) (0.22%)
    807μs
    1 x afterRenderRawModule mod_custom (How to help us?) (9.02KB) (0.2%)
    727μs
    1 x afterRenderRawModule mod_custom (Imprint) (1.08KB) (0.08%)
    294μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (5.44KB) (0.07%)
    269μs
    1 x afterRenderModule mod_accordeonmenuck (Accordeon Menu EN) (66.45KB) (0.06%)
    225μs
    1 x afterRenderModule mod_languages (Language) (6.44KB) (0.05%)
    194μs
    1 x afterRenderModule mod_custom (How to help us?) (3.19KB) (0.05%)
    181μs
    1 x afterRenderModule mod_accordeonmenuck (User Menu) (2.88KB) (0.05%)
    180μs
    1 x afterRenderModule mod_whosonline (Who is online) (2.69KB) (0.05%)
    172μs
    1 x afterRenderModule mod_finder (Search) (2.92KB) (0.03%)
    107μs
    1 x beforeRenderRawModule mod_custom (Imprint) (464B) (0.03%)
    94μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (280B) (0.02%)
    85μs
    1 x beforeRenderRawModule mod_finder (Search) (1.49KB) (0.02%)
    68μs
    1 x beforeRenderRawModule mod_accordeonmenuck (Accordeon Menu EN) (672B) (0.01%)
    51μs
    1 x Before Access::getAssetRules (id:1093 name:com_content.article.78) (18.65KB) (0.01%)
    50μs
    1 x beforeRenderModule mod_languages (Language) (488B) (0.01%)
    48μs
    1 x beforeRenderModule mod_finder (Search) (1.07KB) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_accordeonmenuck (User Menu) (7.7KB) (0.01%)
    35μs
    1 x beforeRenderRawModule mod_custom (How to help us?) (6.41KB) (0.01%)
    33μs
    1 x beforeRenderModule mod_accordeonmenuck (User Menu) (6.17KB) (0.01%)
    28μs
    1 x beforeRenderModule mod_accordeonmenuck (Accordeon Menu EN) (912B) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_whosonline (Who is online) (576B) (0.01%)
    22μs
    1 x beforeRenderModule mod_custom (How to help us?) (55.61KB) (0.01%)
    22μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    22μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    21μs
    1 x beforeRenderModule mod_whosonline (Who is online) (64.98KB) (0%)
    17μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    6μs
39 statements were executed, 8 of which were duplicates, 31 unique56.95ms733.25KB
  • SELECT @@SESSION.sql_mode;146μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `haisly_session` WHERE `session_id` = ?929μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = :session_id LIMIT 1104μ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)1.1ms944BParams/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` = 13.14ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `haisly_viewlevels`341μ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` = :guest653μ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`987μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `haisly_languages` WHERE `published` = 1 ORDER BY `ordering` ASC455μ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` = 1486μ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`6.87ms555.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.34ms848B/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.03ms7.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` = 0835μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `haisly_content`520μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `haisly_content` SET `hits` = (`hits` + 1) WHERE `id` = '78'5.43ms48B/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)2.62ms23.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.56ms4.09KBParams/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.09ms3.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-27 07:35:36') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-27 07:35:36') AND c2.state = 1843μ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`978μs4.09KBParams/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.52ms4.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 DESC12.77ms2.06KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT `language`,`id` FROM `haisly_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0838μs736B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias`,`catid` FROM haisly_content WHERE `id` = :key144μ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` = :id268μ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.83ms1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id422μ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 = 1189μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT * FROM haisly_modules WHERE published=1 ORDER BY id256μ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 = 1152μs592B/administrator/components/com_accordeonmenuck/helpers/ckfof.php:174Copy
  • SELECT guest, client_id FROM haisly_session WHERE client_id = 0305μs3.06KB/modules/mod_whosonline/src/Helper/WhosonlineHelper.php:51Copy
  • SELECT `name`,`element` FROM `haisly_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1425μ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.2ms648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `haisly_schemaorg` WHERE `itemId` = :itemId AND `context` = :context379μ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)483μ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` = 1831μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `haisly_session` WHERE `session_id` = ?143μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `haisly_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?328μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy