Sidebar

This is the first of what could become a series of articles written by our former colleagues about interesting or unusual cases you have dealt with during your time as a Bermuda Police officer.  

Working on Beach Squad must surely have been one of the most sought after postings in the Bermuda Police, especially when College Weeks was in full flow!  What better way to spend your summer that wandering around the Warwick beaches keeping a watchful eye on tourists!  But there was a serious side to being on Beach Squad, and in this article George Rose looks back on his time in Beach Squad in 1966, and recalls one particular case resulting in a man being convicted for what the Acting Chief Justice described as "A Viciously Brutal Act".

------------------------------------------------------

George Rose
 

Beach Squad duties for the year 1966 commenced for Pc 235 Thomas Hill and myself with a briefing at Operations from Inspector Robert Ball on Monday 21st March. Almost immediately matters concerning the use by local males of the courtesy cards issued to visiting college students became an issue of concern. Many students sold their cards to local youths who would then abuse the intent of the cards by entering clubs and attending functions intended only for participating college students. A U.S. serviceman was soon found selling the numbered cards for $3 each from a stash he had possession of and, on at least one occasion known to us, cards were bought for as much as 10/- each.

 

The summary offence of ‘intruding on the privacy of a female’ was a useful tool employed on occasions by Beach Squad during the summer of 1966. Elbow Beach and the adjacent Coral Beach were two of the busiest beaches in this regard. It was customary to have to intervene in ‘scenes’ between lone sunbathing females and an overenthusiastic ‘suitor’ of sorts who invariably turned out to be a crewmember of European descent on one of the cruise liners berthed in Hamilton.

 

One such event ended up in Magistrates’ Court when the learned magistrate gave sage advice to an Italian crewmember standing before him. The magistrate advised that whereas he understood that courting rituals could sometimes be onerous on the male suitor he must understand that when a pretty girl says ‘No, - she means No! End of matter.   The crew member was fined ₤5 that day.

 

At about 12 noon on Thursday 9th June 1966 I was on plain clothes duties as Beach Squad in company with Pc Hill. At this time we had driven down a sandy track leading from South Road, Warwick opposite Warwick Camp onto a small grassy area near the beach known as Chaplin Bay. Parked on this grassy area were two auxiliary cycles and an auto-cycle. All were parked roughly alongside each other.

I knew at this time that the livery cycle was usually ridden by a Somerset man by the name of SIMONS.

 

Together with Pc Hill I left the vehicle and proceeded to find SIMONS sitting on a nearby cliff top. He was observed by both of us talking to a white woman. Both persons were seated side by side and appeared to be engaged in conversation. Without allowing SIMONS to see us at any time since we were both well known by him, we retraced our steps back to the police vehicle which had been parked out of their sight. On our way back I saw in the basket of the auxiliary cycle a white crash helmet lying upside down. The helmet had red lining and appeared quite new. It was not touched. I saw that the cycle was painted a light pink colour and I assumed that it likely belonged to the woman whom SIMONS was talking to.

A general patrol was conducted westward and on our return to Warwick Beaches at 12.45 p.m. SIMONS was observed from South Shore Road with binoculars. He was still in the same position and still talking with the woman.

 

A few hours later we were directed by Control to the Huntley Towers property in Paget where it was alleged that a female had been assaulted. Arriving first on the scene the woman was immediately identified by us as the woman we had earlier seen talking to SIMONS at Chaplin Bay. An immediate descriptive circulation of him was transmitted over the car radio to Pc Alex Forbes at Control. From there it was broadcast to other cars and an immediate search was commenced.

 

The victim was taken to KEMH by Pc Adrian Brindle in a police car. She appeared to have been hit about the head with a hard object and was bleeding from the front right forehead. She was seen to be in a distressed condition but when I asked her if she had been assaulted sexually she said not.

 

Other police officers began arriving and whilst Pc Ron Wallace attended the actual scene of the attack, Pc Hill and I left the area and began a close search of South Shore Road between Elbow Beach and Horseshoe Bay. It was clear at the time that we were the only persons who actually knew SIMONS by sight and the areas he frequented. A further broadcast was made describing in detail the clothing worn by him and suggesting that he might be riding livery cycle with the number we had observed as he had never been seen by us to ride any other transport.

At 4.30p.m. we returned to Huntley Towers without having located SIMONS. Whilst Pc Hill took a statement from a witness who was first to be approached by the victim I continued to search the surrounding area for items reported missing by her. A general patrol along South Shore beaches was again conducted but with negative results.

 

SIMONS was later arrested by other officers and in early August he pled guilty to causing grievous bodily harm to the American visitor on June 9th. He was remanded in custody by the Supreme Court pending a medical report.

 

He plead not guilty to a charge of attempting to have unlawful carnal knowledge of the woman.  Solicitor General Mr. A.W. Sedgwick told Puisne Judge Mr. Justice Barcilon the Crown did not intend to pursue the attempted rape charge because the woman was not in the colony at the moment.

 

Giving the facts of the case before the court, Mr. Sedgwick said on June 9 the victim, who was staying in Smith’s Parish, went to a beach on the South Shore Road to do some painting. At about 11.45 a.m. while she was painting the accused approached her and they got into conversation. The victim loaned Simons her brushes and let him paint and later they had a discussion about the United States.

After a time the victim decided to go for a swim and SIMONS carried her clothes down a cliff to the sea. The woman later told police the accused “invited himself” along for a swim. During the swim SIMONS suggested they go to another cove. There were other people on the beach.  The victim became tired of this attention and went away on her cycle at about 3 p.m.  SIMONS followed and the woman stopped a couple of times in the hope SIMONS would overtake her and go on.

 

Eventually, she turned into an entrance near Huntley Towers and SIMONS rode up alongside. She told him he must not misinterpret the events of the afternoon and he got off his cycle. She dropped her cycle and ran down a hill. SIMONS pulled her into the long grass and held her by her throat. He then made a threat to her and hit her with a cycle helmet. As a result of her injuries she ran off.

The woman went to a nearby house and complained to the police. She had lacerations and bruises.

The police soon found SIMONS because his painting activities of the afternoon had been watched by the police beach patrol who made a note of the cycle he was riding. Mr. Sedgwick said SIMONS was convicted in 1959 of an assault on a woman and in 1965 he assaulted an unknown woman tourist at Fort Scaur.

 

SIMONS’ counsel, Mr. Charles Vaucrosson, said his client had suggested the behaviour was motivated by “some sort of compulsion” and suggested his client be examined by a psychiatrist.  SIMONS had said he considered the attitude of the woman led him to the conclusion she was friendly. “All the more reason not to attack her isn’t it,” observed Mr. Barcilon.

Mr. Vaucrosson said his client had told him the woman mentioned something about not believing in the mixing of the races, “and that sparked him off.”

 

At sentencing it was noted that psychiatric reports on SIMONS gave no grounds to support the theory that there might be something mentally wrong with him. His attack on a woman was simply a vicious brutal act, said the acting Chief Justice, the Hon. Mr. Justice Barcilon, at the Supreme Court when he sentenced Simons to two years’ imprisonment.  …....“The doctor calls your act crassly stupid. I think he was too kind. You were viciously brutal. Just because you did not get what you wanted you decided to use violence. This kind of behaviour will not be tolerated.”

 

COMMISSIONER’S COMMENDATION:

Awarded to P.C. 112 G.F. Rose

For acquisition of detailed knowledge of beach offenders and keen observation in meticulously noting the cycle number resulting in Simons being sentenced to two years imprisonment for assault of a woman tourist.

Dated: 10th August 1966                    


 

 

 

 

 

21.424MBMemory Usage244msRequest Duration
Joomla! Version5.2.6
PHP Version8.2.28
Identityguest
Response200
Templatepurity_iii
Database
Server
mysql
Version
10.6.22-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" => 1747126015 "last" => 1747126015...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (33.66ms)
  • afterInitialise (7.21MB) (78.05ms)
  • afterRoute (1.94MB) (23.47ms)
  • beforeRenderComponent com_content (401.42KB) (4.6ms)
  • Before Access::preloadComponents (all components) (483.66KB) (4.95ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.26ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (24μs)
  • After Access::preloadPermissions (com_content) (938.34KB) (3.3ms)
  • Before Access::getAssetRules (id:493 name:com_content.article.410) (34.65KB) (99μs)
  • After Access::getAssetRules (id:493 name:com_content.article.410) (25.52KB) (445μs)
  • afterRenderComponent com_content (3.8MB) (49.77ms)
  • afterDispatch (4.6KB) (367μs)
  • beforeRenderModule mod_custom (Spacer) (312.59KB) (6.32ms)
  • afterRenderRawModule mod_custom (Spacer) (99.21KB) (1.51ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (8μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (809μs)
  • beforeRenderModule mod_finder (Smart Search) (648B) (68μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.18KB) (9.59ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (9μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (166μs)
  • afterRender (1.55MB) (24.85ms)
  • 1 x afterInitialise (7.21MB) (31.96%)
    78.05ms
    1 x afterRenderComponent com_content (3.8MB) (20.38%)
    49.77ms
    1 x afterLoad (3.65MB) (13.78%)
    33.66ms
    1 x afterRender (1.55MB) (10.17%)
    24.85ms
    1 x afterRoute (1.94MB) (9.61%)
    23.47ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.18KB) (3.93%)
    9.59ms
    1 x beforeRenderModule mod_custom (Spacer) (312.59KB) (2.59%)
    6.32ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (2.03%)
    4.95ms
    1 x beforeRenderComponent com_content (401.42KB) (1.88%)
    4.60ms
    1 x After Access::preloadPermissions (com_content) (938.34KB) (1.35%)
    3.30ms
    1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.62%)
    1.51ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.52%)
    1.26ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.33%)
    809μs
    1 x After Access::getAssetRules (id:493 name:com_content.article.410) (25.52KB) (0.18%)
    445μs
    1 x afterDispatch (4.6KB) (0.15%)
    367μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.07%)
    166μs
    1 x Before Access::getAssetRules (id:493 name:com_content.article.410) (34.65KB) (0.04%)
    99μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.03%)
    68μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    24μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    8μs
35 statements were executed, 6 of which were duplicates, 29 unique13.94ms502.69KB
  • SELECT @@SESSION.sql_mode;89μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?112μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1115μ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)300μ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` = 1348μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`92μ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` = :guest145μ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`626μ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`625μ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`346μ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` = 1258μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC149μ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)890μ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` = 01.27ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`404μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '410'279μ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)365μs23.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`315μ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)229μ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`331μ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 ASC651μ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.77ms21.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`355μ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`962μs146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1336μ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 = 188μ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)513μ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)146μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering309μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context142μ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)369μs22.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)299μs22.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` = 1157μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?147μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?407μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy