Sidebar

 

Kindly submitted by retired Superintendent George Rose

 

George Rose  
   

When browsing recently through documents in my possession I came across a four page pamphlet described as a ‘Supplement 1989’ inserted inside the 110th Anniversary Issue of the October 1989 Bermuda Police Magazine. On the colourful front cover of the magazine under the words “IMAGES PAST AND PRESENT” could be seen a photographic representation of “our two latest recruits, W.P.C. Shacolbi Smith and P.C. Calon Hollis, with one of our first constables, Thomas J. Powell”. Constable Powell was depicted in full winter uniform with the letters HPC clearly depicted on the forward collar of his tunic along with a trio of medals on his left breast. Three stripes can be seen ringing his lower left sleeve above the wrist. The photo is credited to D/Sgt. Howard Cutts.

 

The four page Supplement insert carried inside of it *IN MEMORIUM* the obituaries of the following four officers.

 

Serving Constable George Howard Kirkham (1945 – 1989); Retired Chief Superintendent Oliver Salsbury W. Trott, QPM CPM (1914 – 1989) Please click on the following to read our 'Hall of Fame' article on "Chief Trott" http://expobermuda.com/index.php/hof2/184-olivertrott ; Retired Detective Constable Earl Sinclair Hazel (1915 – 1989) and Retired Police Constable Murdoch Ferguson (1903 – 1989).

 

In respect of Constable Murdoch Ferguson about whom this article is written, his obituary read as follows:

“Pc Murdoch Ferguson (retired) (1903 – 1989)

Murdoch Ferguson who died on August 28th 1989 in his native Scotland was one of the Bermuda Police’s oldest pensioners. Murdoch was born in Benbecula, Outer Hebrides, one of the remotest parts of the British Isles, and was a farm worker prior to joining the Bermuda Police in 1935. The references he received from his parish priest, headmaster and solicitor testified to his strength of character and obliging nature.

 

Murdoch’s entire career was spent in Central Division where he worked for many years as the Paget District  Constable. He was described as a “firm, straight forward Police Officer with an eye to detail and of quiet disposition. Murdoch Ferguson retired from the Bermuda Police in 1958, and was employed at Bellevue, Paget. He made his home on Bostock Hill. Murdoch served Bermuda faithfully and deepest condolences are extended to his family”. Author: Unknown.

 

Since my own Celtic bloodline heritage is that from the Scottish Highlands (with a 3 x Great Grandfather born in Ardclach, Nairnshire in 1779), I decided to research Murdoch’s history in an attempt to determine how and why he had entered into the service of the Bermuda Police in 1935. It seemed to me that he was a character worthy of my time and research effort in an attempt to answer these fundamental questions. He originated from ‘one of the remotest parts of the British Isles’ and his upbringing must have been tough and solitary. I was intrigued to learn by what manner of circumstance he had found himself resident on another such isolated island as Bermuda. Who or what was the magnet that drew Murdoch to Bermuda. Who was his Island contact and by what means did he travel here? Clearly, travel to Bermuda in those pre-war days was long and difficult and just didn’t occur by happenstance.

    

Using the details written in his obituary I commenced a search of the available online Scottish Statutory records which produced an early lead.

 
The 1911 Census at Hacklet, Grimsay, Benbecula, (District) of Inverness-shire gave the following useful information:
 
Donald Ferguson         Head      aged 57        G       Crofter                    Employer   Born Inverness-shire, South District
 
Mary Ferguson            Wife       aged 52        G                                                                “                  
 
Mary C Ferguson         Dau        aged 12    G & E    School                                             “                  
 
Fergus Ferguson          Son         aged 10    G & E    School                                            “  
              
Murdoch Ferguson       Son         aged    8        G       School                                            “  
             
Joanna C. MacRury     Visitor    aged 18    G & E     Farm Servant         Worker
                         
References above to G and to G & E refer to the languages spoken;   G = Gaelic, G & E = Gaelic and English
 

So, here was Murdoch aged 8 years and recorded as speaking only Gaelic. He had an older brother Fergus and an older sister May C. Ferguson. We now have a family unit upon which to build. Let’s put some flesh on the bones. 

       

A thorough search in the Statutory Birth Registration records for Scotland revealed that Murdoch was born at the 3rd hour and 11th minute on the 2nd March 1903 in Hacklet, Benbecula, an island in the Outer Hebrides, Inverness-shire, Scotland. His birth registration record his father as Donald Ferguson, Crofter, who was present at birth and made his mark thus – X. His mother is shown as Mary Ferguson, whose maiden name was MacLeod.

 
Benbecula, Outer Hebrides
 

Nothing more can yet be found about Murdoch’s early life in the Outer Hebrides but on the 24th December 1934 he migrated to New York on board the S.S. ‘Transylvania’ out of Glasgow, Scotland. We know this from the ‘LIST OR MANIFEST OF ALIEN PASSENGERS FOR THE UNITED STATES’ which records Murdoch’s age as 31 years with an occupation as that of ‘Crofter’. It describes him as being a single man who can read and write English with a place of birth given as Benbecula, Scotland.

       

Murdoch’s life to this point is best reflected in the written contents of his obituary describing him as a farm worker together with references he received from his parish priest, headmaster and solicitor testifying as to his strength of character and obliging nature. The next Census report – at his age of 18 – and one which would have identified him further is that for 1921, but there is extant ‘the 100 year rule’ which prevents the release of this census until the year 2021.

 

We know from his obituary that on 14th January 1935 Murdoch, at the age of 32, joined the Bermuda Police Force and later became the Paget Parish (District) Constable.  Roger Sherratt reached out to retired Bermuda Police Assistant Commissioner (Crime) Ian Morrison – a fellow Scotsman who knew Murdoch in Bermuda and had served on the job with him. Ian told Roger that Murdoch was married to an [unknown] employee of the big house where they both lived. [Could that big house have been ‘Bellevue’, Paget?]

 

In 1946 Murdoch is recorded in the Bermuda Blue Book as a 1st Class Constable earning £475 per annum plus a uniform allowance in lieu of quarters of £48 per annum. Source: Roger Sherratt – Blue Book references.

 

In 1958 Murdoch retired from Bermuda Police and was employed at ‘Bellevue’, Paget, Bermuda - and later at the Belco showrooms on Reid Street, Hamilton. He resided in Bostock Hill, Paget, Bermuda.

Source: Ian Morrison email 16 Sept 2016 

      

Murdoch died on 20th August 1989 in New Kilpatrick, East Dunbartonshire, Scotland [City of Glasgow]. His place of burial has not yet been recovered from either of the two cemeteries at this location since they are only partially recorded to date. His marriage details and any children he may have had are proving difficult to find at present. The date and place of marriage remain unknown at present and, in any event, the marriage may not necessarily have been in Bermuda or to a local female.

 

AND THEN, out of the blue, along came a nugget of information from Ian Morrison who said, almost as an aside:

 

“I understand that Murdoch’s brother was an Inspector on the job but before my time. Murdoch has a daughter living on the Island name and whereabouts unknown to me but ……..”   Source: Ian Morrison email 16 Sept 2016

 

So there, for now, lie the results of the investigation into Murdoch’s life. More work is planned in the weeks ahead.

 

At least we now know from census records that Murdoch had an older brother by the name of Fergus Ferguson.

 

Could it be this Fergus to whom Ian Morrison is referring when he wrote? – “I understand that Murdoch’s brother was an Inspector on the job but before my time”.

 

Turning our attention now to Fergus Ferguson, a search in the Statutory Birth Registration records for Scotland revealed that Fergus was born at 12 noon on the 23rd January 1901 at Hacklet, in the District of Benbecula, County of Inverness-shire, Scotland. His birth registration records his father as Donald Ferguson, Crofter, who was present at birth and who made his mark thus – X. His mother is shown as Mary Ferguson nee MacLeod.

The 1911 Census at Hacklet, Grimsay, Benbecula, (District) of Inverness-shire records Fergus Ferguson as aged 10 and being a speaker of the Gaelic and English languages.

 

 

On 1st May 1927 at the age of 26, Fergus is next seen in the Bermuda Blue Book as joining the Bermuda Police Force. Some two years later on the 15th September 1929 in the ‘LIST OR MANIFEST OF ALIEN PASSENGERS FOR THE UNITED STATES’ Fergus is recorded as travelling to New York on board the S.S. “Albertic” which had departed Greenock (Tail of the Bank), Scotland. The record gave his age as 28 years and 5 months stating that he was an unmarried Police Constable who could read. He further declared himself to be British and of the Scots race having been born in Benbecula, Scotland. Interestingly, in the source document he gave Bermuda as his last country of residence and there is seen the notation *In transit to Bermuda*. These last two entries tend to confirm that Fergus was a returning resident of Bermuda in 1929 and was en route to the island from Scotland.

 

In 1946 Fergus is last seen in the Bermuda Blue Book as holding the rank of Inspector and earning £650 per annum plus £96 allowance.

 

It is now clear that Murdoch had arrived in Bermuda and joined the Bermuda Police with the assistance of his elder brother Fergus. Enquiries are under way to locate and speak with any surviving relatives Murdoch may still have on the island.

 

Questions arise in relation to Fergus however and research is ongoing to determine the circumstances leading to his first arrival in Bermuda in 1927. Who and what drew him to the island? Did he marry and raise a family here? When did he retire from the Bermuda Police and what happened to him afterwards?  When did he pass away and where is he buried?  Does an obituary exist for him? Are there any case histories listed for him during his career as a Bermuda police officer? And what of the brothers’ eldest sister Mary C. ?  Did she play a role in Fergus’ relocation to Bermuda, or can she be eliminated from the equation?

 

It is a fact that in earlier centuries the Scots were predominant throughout the colonial world including the Caribbean and in the Isthmus of Panama. But what of their early presence in Bermuda and of their connections back home in Scotland? What were the recruiting policies of the Bermuda Police / Government in the early decades of the 20th Century?

 

In keeping with Police traditions this is a continuing team effort to gain more information about these two former police colleagues and retirees. I would be grateful to receive information from anyone who can add to the biography of Fergus and Murdoch Ferguson.

    


 

 

 

 

 

21.537MBMemory Usage287msRequest Duration
Joomla! Version5.2.5
PHP Version8.2.27
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" => "/~bermyx...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743877857 "last" => 1743877857...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (38.52ms)
  • afterInitialise (7.2MB) (82.97ms)
  • afterRoute (1.94MB) (30.71ms)
  • beforeRenderComponent com_content (401.42KB) (5.12ms)
  • Before Access::preloadComponents (all components) (483.66KB) (5.5ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.18ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (26μs)
  • After Access::preloadPermissions (com_content) (929.48KB) (4.4ms)
  • Before Access::getAssetRules (id:631 name:com_content.article.518) (34.65KB) (112μs)
  • After Access::getAssetRules (id:631 name:com_content.article.518) (25.52KB) (541μs)
  • afterRenderComponent com_content (3.85MB) (58.48ms)
  • afterDispatch (4.6KB) (642μs)
  • beforeRenderModule mod_custom (Spacer) (376.59KB) (10.04ms)
  • afterRenderRawModule mod_custom (Spacer) (35.21KB) (2.37ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (16μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (1.32ms)
  • beforeRenderModule mod_finder (Smart Search) (648B) (127μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.18KB) (14.84ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (13μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (209μs)
  • afterRender (1.57MB) (28.7ms)
  • 1 x afterInitialise (7.2MB) (28.92%)
    82.97ms
    1 x afterRenderComponent com_content (3.85MB) (20.39%)
    58.48ms
    1 x afterLoad (3.65MB) (13.43%)
    38.52ms
    1 x afterRoute (1.94MB) (10.71%)
    30.71ms
    1 x afterRender (1.57MB) (10%)
    28.70ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.18KB) (5.17%)
    14.84ms
    1 x beforeRenderModule mod_custom (Spacer) (376.59KB) (3.5%)
    10.04ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (1.92%)
    5.50ms
    1 x beforeRenderComponent com_content (401.42KB) (1.79%)
    5.12ms
    1 x After Access::preloadPermissions (com_content) (929.48KB) (1.53%)
    4.40ms
    1 x afterRenderRawModule mod_custom (Spacer) (35.21KB) (0.83%)
    2.37ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.46%)
    1.32ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.41%)
    1.18ms
    1 x afterDispatch (4.6KB) (0.22%)
    642μs
    1 x After Access::getAssetRules (id:631 name:com_content.article.518) (25.52KB) (0.19%)
    541μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.07%)
    209μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.04%)
    127μs
    1 x Before Access::getAssetRules (id:631 name:com_content.article.518) (34.65KB) (0.04%)
    112μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0.01%)
    16μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)
    13μs
35 statements were executed, 6 of which were duplicates, 29 unique19.06ms622.69KB
  • SELECT @@SESSION.sql_mode;125μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?222μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1151μ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)424μ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` = 1345μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`109μ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` = :guest181μ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`775μ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`1.28ms52.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`553μ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` = 1298μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC264μ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)648μs7.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.28ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`514μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '518'441μ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)646μs63.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`573μ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)276μ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`407μ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 ASC740μs4.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 DESC1.91ms21.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`399μ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.73ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1436μ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 = 1115μ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)585μ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)152μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering323μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context176μ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)632μs62.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)436μs62.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` = 1200μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?204μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?498μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy