Dennis Franklyn Preece was a well-known heroin dealer and user. He went by the nickname ‘Junkie’ and lived in premises at Dock Hill, Devonshire.

 

Acting on information received, Detective Sergeant Dennis Ramsay in company with another officer commenced watching Preece’s house in the early morning hours of a February day in 1980. From their concealed position nearby the officers saw a man arrive on a scooter and then walk towards the bathroom window. They heard words spoken after which the louver of the window opened and the officers’ saw money pass through the screen. A silver tin foil deck was returned from inside through the window.

 

Later that same morning, the detectives watched other people approach the same window where similar transactions took place. On one occasion, one of the buyers opened the foil deck in the yard, put his thumb into the foil, and snorted from it.

 
 
Detective Sergeant Dennis Ramsay
 

At precisely 11 a.m. that same morning the officers’ observations were thwarted when two people came towards them from the direction of the defendant’s residence. In D.S. Ramsay’s words, “They observed who we were. At that time I got on the radio and summoned the entire narcotics section who responded immediately.”

Narcotics squad officers entered Preece’s residence through the kitchen door. They were armed with a search warrant and immediately confronted the defendant in the company of two other men. Preece was seen to be holding a small container with a bit of masking tape wrapped around it. Before Detective Constable Chris Moyse had a chance to speak to him, Preece ran from the kitchen through the house and entered the children’s bedroom. He jumped through a glass window above a bed, crossing his hands over his head with his arms as he went to protect his face.

 
D.C. Chris Moyse
 

D.C. Moyse later told a Supreme Court jury that he followed Preece through the window and landed on top of him on the ground five feet below. A struggle ensued during which time Preece threw away a container the contents of which were found to be 67 foil wraps later analyzed to contain heroin. A partially smoked cigarette from the kitchen floor contained a mixture of cannabis and tobacco. Powder scraped from two glass plates was later found by the Government analyst, Mrs. E.W., to contain traces of heroin. Traces of drugs were also discovered in a razor blade, an ashtray and in a straw.

 

Follow-up arrests were later made, he said, inclusive of those who had halted the observations prematurely.

At his trial in October 1980 Preece pled not guilty to a total of four charges:- 

possession of heroin; possession of cannabis; supply of heroin; and obstructing a Police officer in the execution of his duty. Mr. Tony Palmer appeared for the defendant.

 

The case was heard before the Acting Puisne Judge, the Hon. Mr. Justice Barcilon.

 

Opening evidence from D.S. Ramsay and Dc Moyse was heard by the jury before the case was adjourned for Mr. Justice Barcilon to hear legal submissions concerning the accused’s statement of confession to the police, that he had supplied between 50 and 60 customers in the 10 days before he was arrested on February 15. He also claimed that about 300 bags of the drugs are sold in Bermuda every day.

 

As the Detective Inspector and OIC of the drug squad, I was the last of the Prosecution witnesses to give evidence. In answer to defence counsel, I told the court that I had good reason to believe Preece was a heroin user and that when I interviewed his client in company with another officer, he had not mentioned that he was suffering from withdrawal symptoms. I agreed with Mr. Palmer that during the course of my interview, his client had named his supplier which he had earlier refused to do.

 

Preece was found guilty of possession of heroin with intent to supply – (10 years); supplying heroin – (15 years); possession of cannabis – (one year); and obstructing Police – (one year).

He had earlier pled guilty to allowing his house to be used for the taking of drugs (five years) and possessing equipment for the use of drugs (five years).

Preece was sentenced to a total of 15 years on six offences including supplying heroin. 

All sentences ran concurrently.

After his conviction, the court was told that Preece was jailed for four years in 1975 for possession of heroin with intent to supply.

 

His lawyer, Mr. Tony Palmer, said Preece had only been selling heroin for five to ten days before he was arrested and he only sold the drugs to people he knew. “There has been no suggestion that he attempted to corrupt young people or that he sold it to people who did not previously use the drug,” said Mr. Palmer. “He was no more than a tool for the big fish. He also tried to hold on to a job but couldn’t. The whole thing is quite tragic.”

Before sentencing Preece, Mr. Justice Barcilon said to Dc Moyse, who had previously left the Bermuda Police Force in August to go back to England:

“I must commend you on your conduct during this case and the way you gave your evidence. I hope you will have a good long career in England and Bermuda is sorry she has lost you.”

 

In sentencing Preece to the 15 year stretch in Casemates, the Acting Puisne Judge, the Hon. Mr. Justice Barcilon told him:

“People like you should be punished severely. I had a man up here about a month ago by the name of [Dennis Webster] Warner and he got 15 years for exactly the same thing. And you also have a previous conviction for this (supplying heroin).”

 ______________________________________________

 

Preece later appealed before the Court of Appeal to have his 15-year jail sentence reduced for dealing in drugs. He first appealed against conviction but later decided to appeal against sentence only. The appellant had argued that his sentence was excessive in light of the fact that at the time of his arrest he was in possession of only 1.563 grams of 34 percent strength heroin and 10.461 grams of cannabis.

In a written statement, the Appeal Court judges said that the trial judge had correctly taken a serious view of the offences committed by Preece who admitted more than two years ago to selling about 600 bags of heroin in a ten-day period. The three judges wrote:

“When deciding on a sentence, a court must take into account all the circumstances and, on his own admission, this appellant was selling heroin and cannabis to a very considerable number of addicts.”

 

But the Appeal Court judges said the amount seized at the moment of arrest was only one factor in deciding a sentence. And they pointed to Preece’s own admission that he was selling a large amount of heroin.

 

When asked how much he had sold over the previous ten days, Preece had replied:

“About five or six hundred bags …… Let me tell you mate, you don’t realize, about 300 bags a day get sold in Bermuda.”

 

It was also noted by the Judges that Preece had told Police before confessing:

“Look, I’ll tell you the truth. I don’t want to do no ten years.”

 

The 34-year old former employee of the Hamilton Princess failed in his appeal to have his 15-year jail sentence reduced.

 

REFERENCES:

The Royal Gazette 27 October 1980

COURT HEARS HOW ACCUSED JUMPED THROUGH WINDOW

DRUGS DEFENCE BEGINS TODAY

The Royal Gazette 28 October 1980

HEROIN PUSHER GETS 15 YEARS

The Royal Gazette 29 October 1980

HEROIN DEALER LOSES APPEAL ON SENTENCE

The Royal Gazette 

 

Editors notes -

This article was written by retired Detective Superintendent George Rose, who was a Detective Inspector in Narcotics at the time of this case.

 

Dennis Ramsay served in the Bermuda Police from 1967 until 1993, and spent most of his service as a very experienced detective in C.I.D. and Narcotics retiring as a Detective Chief Inspector.

 

D.C. Chris Moyse joined the Bermuda Police in 1973, after first serving in the Hampshire Constabulary for 6 years.  He was transferred into CID after just 5 months in uniform and was then moved to Narcotics.  Chris left the BPS after serving here for 7 years following which we lost contact with him.  Sadly we received news earlier this year that Chris had died in Boston, Mass. on 26th July 2016 after a lengthy illness.  You can view more information about his death on our website at http://expobermuda.com/index.php/latest-news/661-sad-death-of-chris-moyse-in-2016


 

 

 

 

 

21.456MBMemory Usage253msRequest Duration
Joomla! Version5.2.3
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" => "" "DOC...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1740395334 "last" => 1740395334...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (34.54ms)
  • afterInitialise (7.2MB) (77.44ms)
  • afterRoute (1.93MB) (24.78ms)
  • beforeRenderComponent com_content (401.38KB) (5.16ms)
  • Before Access::preloadComponents (all components) (483.66KB) (5.17ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.15ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (25μs)
  • After Access::preloadPermissions (com_content) (924.12KB) (3.27ms)
  • Before Access::getAssetRules (id:778 name:com_content.article.665) (34.65KB) (100μs)
  • After Access::getAssetRules (id:778 name:com_content.article.665) (25.52KB) (490μs)
  • afterRenderComponent com_content (3.83MB) (51.87ms)
  • afterDispatch (4.59KB) (377μs)
  • beforeRenderModule mod_custom (Spacer) (312.37KB) (6.53ms)
  • afterRenderRawModule mod_custom (Spacer) (99.21KB) (1.55ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (9μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (874μs)
  • beforeRenderModule mod_finder (Smart Search) (648B) (70μs)
  • afterRenderRawModule mod_finder (Smart Search) (478.77KB) (11.19ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (12μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (187μs)
  • afterRender (1.54MB) (27.33ms)
  • 1 x afterInitialise (7.2MB) (30.6%)
    77.44ms
    1 x afterRenderComponent com_content (3.83MB) (20.5%)
    51.87ms
    1 x afterLoad (3.65MB) (13.65%)
    34.54ms
    1 x afterRender (1.54MB) (10.8%)
    27.33ms
    1 x afterRoute (1.93MB) (9.79%)
    24.78ms
    1 x afterRenderRawModule mod_finder (Smart Search) (478.77KB) (4.42%)
    11.19ms
    1 x beforeRenderModule mod_custom (Spacer) (312.37KB) (2.58%)
    6.53ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (2.04%)
    5.17ms
    1 x beforeRenderComponent com_content (401.38KB) (2.04%)
    5.16ms
    1 x After Access::preloadPermissions (com_content) (924.12KB) (1.29%)
    3.27ms
    1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.61%)
    1.55ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.45%)
    1.15ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.35%)
    874μs
    1 x After Access::getAssetRules (id:778 name:com_content.article.665) (25.52KB) (0.19%)
    490μs
    1 x afterDispatch (4.59KB) (0.15%)
    377μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.07%)
    187μs
    1 x Before Access::getAssetRules (id:778 name:com_content.article.665) (34.65KB) (0.04%)
    100μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.03%)
    70μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    25μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    9μs
35 statements were executed, 6 of which were duplicates, 29 unique16.56ms622.69KB
  • SELECT @@SESSION.sql_mode;83μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?249μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1132μ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)356μ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` = 1321μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`93μ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` = :guest144μ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`816μ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`709μ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`541μ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` = 1303μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC309μ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)656μ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.26ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`418μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '665'381μ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)485μ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`374μ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)241μ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`471μ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 ASC705μ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.79ms21.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`333μ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.54ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1532μ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)805μ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)167μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering437μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context192μ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)494μ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)313μ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` = 1213μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?164μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?416μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy