MAGISTRATE’S WARNING FOR
TREASURE HUNTERS ON THE PROWL

 

The Treasure Hunters Guide!

At 1.15 a.m. Friday 23 February 1968 in company with Captain Gilbert ‘Shore Patrol’ Pitman and another civilian, I commenced surveillance of the Motor Yacht ‘Romay’ berthed at its dock at the Sherwood Manor Hotel, Mill Creek, Pembroke Parish. The M.Y. Romay, owned by His Excellency the Governor, Lord Martonmere had, for some weeks previously, been the subject of unwanted boarding and the theft of liquor from the galley.

From our concealed position within the hotel’s dance hall we had a wide view of all approaches to the Romay including the tourist cottages, gardens and waters of Mill Creek.   At 4.35 a.m. Captain Pitman drew my attention to a male figure creeping along the wall bordering the bandstand patio located in front of the cottages.  The man moved slowly and was hunched down. He lingered in the bandstand area for some 18 minutes moving from one side to another observing both the main hotel building and all of the cottages behind him. I saw the hotel night watchman – who was unaware of our presence – cross the patio on his rounds. He did not see the intruder who remained motionless and hidden behind a pillar.

In company with ‘Shore Patrol’ I left our concealed position and walked to the rear of Jones cottage. I saw a lighted bathroom window at the rear of Jones cottage. I saw no one in the bathroom.  I later saw the intruder in a crouched position – walking slowly away from the window behind a low hedge.  I watched him for some minutes and saw him again resume his crouching position near the bandstand. 

At no time did this man go anywhere near the M.Y. Romay.

At 5.20 a.m. I went to this man and said, “I am a police officer. What are you doing here?”

He replied, “Just sitting, aren’t I.”

I said, “I have been watching you for some considerable time and I believe you are prowling. Is that right?”

He replied. “Seven to one I wouldn’t get caught. I took a chance.”

I arrested and cautioned him for prowling to which he replied, “I took a chance on getting caught. I’ve been casing this place for three weeks. I’m not prowling.”

I took him inside the dance hall and learned his name was Clifford Hamilton Leach. Whilst searching his person I asked him, “What were you hoping to see sitting there?’

He replied, “I was looking for the treasure. Look I have the clues.”

He produced a slip of paper from a pocket with alleged clues written thereon.

I said, “I do not believe that.”

He replied, “Fair enough. I was looking for my mate, my brother-in-law B.C.” 

I said, “Is he here?”

Reply, “No, he didn’t come tonight.”

I asked, “Do you have a car?”

Reply, “It’s down the road.”

I accompanied Leach to his private car on Fairyland Road. It was legally parked with lights on, and some 500 yards from the hotel. Empty parking spaces in the hotel car park were plentiful.

When formally charged and cautioned with the offence of prowling Leach replied, “Definitely I didn’t prowl round a house.” 

Taking the stand in his own defence Leach said he had been following the treasure hunt clues over the air and one clue, “alley route,” led him to enter the hotel premises by that route.

He said he was searching in a pillar on the bandstand with a comb when he heard the watchman’s footsteps. He said he remained out of sight until the watchman had passed. He was later arrested by Dc Rose.

Asked by Inspector Thomas Doyle, prosecuting, why he did not want to be seen, Leach said he wanted his comings and goings to be secret because he was looking for treasure.

He said he had all the clues and was led to Fairylands by the clue, “to tomb,” after searching in two churchyards a metal plate in one churchyard led him to Fairylands, he said. 

Said Leach, “I put my head on a chopping block that the treasure was between two palms on the walkway of Sherwood Manor”

Said Mr. Maddocks, “No doubt the craze has gripped people over the island but no-one has the right to enter private property.”  He said he was prepared to accept that Leach was looking for treasure and imposed the six months conditional discharge.

A police official later stressed that wherever the treasure is located it is NOT on private property.

A spokesman for ZBM radio who are operating the hunt said the treasure was easily accessible and not on private property which would entail trespass.

Editors note -  

Although I can only vaguely recall details of this court case I was personally directly involved in it, along with my old friend and fellow colleague the Late Sgt. George Rushe.

Some of you "old timers" may remember the time when most of Bermuda's Road had finally been named, some 1200 of them,  but apart from a huge Ordnance Survey Map the public had no idea where to find the newly named roads, and that included taxi drivers, delivery drivers, and of course, emergency services - Police, Ambulance and Fire Department. I was working at the time in Operations (Traffic) on a Watch with fellow constable George Rushe, and while working on nights in the Ops Room we started a list of all the new roads together with a literal description of their location, We used the City of Hamilton as the base and described in words how to find the roads in question e.g.  "Hesitation Lane  -  Travel east along Middle Road from Hamilton, turn left onto Montpelier Road, Hesitation Lane is 2nd on the left".  We then hit on the idea of producing a little booklet which we might be able to sell to the the public.  After obtaining official approval we went ahead and published a booklet called "The Bermuda Gazeteer" which was an instant success.

We then decided to go one better and obtained permission to publish a more sophisticated booklet. complete with illustrative maps of the whole Island, and an index that included not only roads, but also hotels and guest houses, churches, restaurants, bus and ferry routes, gas stations, islands, bays, bridges and places on interest.  You will see above the front cover which was specially painted for us by the designer who produced all the 24 maps.  The booklet took about 2 years to complete and it was called "Bermuda Islands Guide - The COMPLETE  Map and Information Guide to Bermuda.

So what does this have to do with George Rose's prowler story?  Well, as a means of promoting our booklet, George and I came up with the idea of creating a weekly "Treasure Hunt" using  20 clues each week taken from our booklet. If you did not have the book you would not be able to follow the clues.  We successfully ran the Treasure Hunt for several years on ZBM and it certainly helped our sales.

Each week we would write the 20 clues that would lead the successful treasuer hunter to a small metal box in which they would find a key and a note to declare that the finder was successful in finding that week's treasure key which they would then take to ZBM to claim their reward.

At that time I was living in an apartment in Fairylands,  and wrote a series of clues which led to a hiding place near the entrance to Sherwood Manor.  We always stipulated that the key would NEVER be hidden on private property, but it seems as though this young man didn't believe it !

I should add that George Rushe was an exceptionally talented guy with a great sense of humour and always a pleasure to work with.  He went on to perform on stage with BMDS, and for several years he was the Quiz Master in the Brains of Bermuda annual general knowledge quiz shows.  Sadly, he died far too young.


 

 

 

 

 

21.441MBMemory Usage349msRequest Duration
Joomla! Version5.2.6
PHP Version8.2.28
Identityguest
Response200
Templatepurity_iii
Database
Server
mysql
Version
10.6.21-MariaDB-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "CONTEXT_DOCUMENT_ROOT" => "/home/bermyxpo/public_html" "CONTEXT_PREFIX" => "" "DOC...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746441726 "last" => 1746441726...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (49.43ms)
  • afterInitialise (7.21MB) (108ms)
  • afterRoute (1.94MB) (34.66ms)
  • beforeRenderComponent com_content (401.42KB) (6.89ms)
  • Before Access::preloadComponents (all components) (483.66KB) (7.39ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.66ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (35μs)
  • After Access::preloadPermissions (com_content) (936.38KB) (5.75ms)
  • Before Access::getAssetRules (id:706 name:com_content.article.593) (34.65KB) (168μs)
  • After Access::getAssetRules (id:706 name:com_content.article.593) (25.52KB) (691μs)
  • afterRenderComponent com_content (3.81MB) (70.5ms)
  • afterDispatch (4.59KB) (441μs)
  • beforeRenderModule mod_custom (Spacer) (312.34KB) (8ms)
  • afterRenderRawModule mod_custom (Spacer) (99.21KB) (2.42ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (16μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (1.35ms)
  • beforeRenderModule mod_finder (Smart Search) (648B) (133μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.09KB) (15.34ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (18μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (275μs)
  • afterRender (1.56MB) (34.82ms)
  • 1 x afterInitialise (7.21MB) (30.94%)
    108ms
    1 x afterRenderComponent com_content (3.81MB) (20.19%)
    70.50ms
    1 x afterLoad (3.65MB) (14.16%)
    49.43ms
    1 x afterRender (1.56MB) (9.97%)
    34.82ms
    1 x afterRoute (1.94MB) (9.93%)
    34.66ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.09KB) (4.39%)
    15.34ms
    1 x beforeRenderModule mod_custom (Spacer) (312.34KB) (2.29%)
    8.00ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (2.12%)
    7.39ms
    1 x beforeRenderComponent com_content (401.42KB) (1.97%)
    6.89ms
    1 x After Access::preloadPermissions (com_content) (936.38KB) (1.65%)
    5.75ms
    1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.69%)
    2.42ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.48%)
    1.66ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.39%)
    1.35ms
    1 x After Access::getAssetRules (id:706 name:com_content.article.593) (25.52KB) (0.2%)
    691μs
    1 x afterDispatch (4.59KB) (0.13%)
    441μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.08%)
    275μs
    1 x Before Access::getAssetRules (id:706 name:com_content.article.593) (34.65KB) (0.05%)
    168μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.04%)
    133μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    35μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    16μs
35 statements were executed, 6 of which were duplicates, 29 unique21.93ms574.69KB
  • SELECT @@SESSION.sql_mode;127μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?187μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1177μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `dztir_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)374μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `dztir_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1530μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`149μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `dztir_usergroups` AS `a` LEFT JOIN `dztir_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest201μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `dztir_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`673μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `dztir_menu` AS `m` LEFT JOIN `dztir_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`980μs52.67KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`576μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `dztir_template_styles` AS `s` LEFT JOIN `dztir_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` = 1431μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC248μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `dztir_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41)1.02ms7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `dztir_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 02.51ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`684μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '593'420μ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 `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)684μs47.38KBParams/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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`599μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `dztir_contentitem_tag_map` AS `m` INNER JOIN `dztir_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)374μs3.95KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`586μs3.89KBParams/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 dztir_fields AS a LEFT JOIN `dztir_languages` AS l ON l.lang_code = a.language LEFT JOIN dztir_users AS uc ON uc.id=a.checked_out LEFT JOIN dztir_viewlevels AS ag ON ag.id = a.access LEFT JOIN dztir_users AS ua ON ua.id = a.created_user_id LEFT JOIN dztir_fields_groups AS g ON g.id = a.group_id LEFT JOIN `dztir_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.06ms4.06KBParams/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 `dztir_content` AS `a` LEFT JOIN `dztir_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC3.39ms21.69KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`568μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `dztir_modules` AS `m` LEFT JOIN `dztir_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `dztir_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)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.66ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1421μs704B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT f.data, f.params FROM `dztir_finder_filters` AS f WHERE f.filter_id = 1137μs592B/administrator/components/com_finder/src/Indexer/Query.php:514Copy
  • SELECT t1.id, t1.title, t2.title AS branch FROM `dztir_finder_taxonomy` AS t1 LEFT JOIN `dztir_finder_taxonomy` AS t2 ON t2.lft < t1.lft AND t1.rgt < t2.rgt AND t2.level = 1 WHERE t1.state = 1 AND t1.access IN (1) AND t1.id IN (4,39,57,58,59,60,74,41,46,66,67,71,43,47,49,50,51,52,61,62,63,64,65,68,72,69,70,73,75) AND t2.state = 1 AND t2.access IN (1)560μs1.13KB/administrator/components/com_finder/src/Indexer/Query.php:566Copy
  • SELECT `title` FROM `dztir_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)156μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering392μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context228μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)643μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)501μs46.17KBParams/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 `dztir_scheduler_tasks` AS `a` WHERE `a`.`state` = 1197μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?135μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?354μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy