Christmas lunch at Mad Hatters
 

Our Ex-Bobbies annual pre-Christmas lunch was held at Mad Hatters restaurant in the Mariner’s Club on Tuesday 5th December 2024, thanks to the organizational skills of stalwarts Bill Butterworth and Dave Cooper.  

The dining room was packed to the gills with a total of some 45 former bobbies, including three from “abroad” (more about them in a moment).  There’s always a “buzz” at these events which have been going on for as long as anyone present could remember.  And judging from the atmosphere, the camaraderie, the excellent menu, and top-class service thanks to Ed Barnes and his staff, a good time was had by all.

Gerry Lyons, Phil Scarcliffe and Wayne Perinchief

Roger Brydon, Geoff Piggott and Dave Cooper
 

This year we had three “attendees” from overseas.  Two of our former colleagues, Roger Brydon and Phil Scarcliffe, joined us at the lunch. Roger was on one of his regular visits to the Island  while Phil has recently re-domiciled back here.  

Ray Bell, Joe Tildesley and Bill Butterworth
 

Our third overseas attendee was a visitor from the West Midlands Police - retired Inspector Joe Tildesley who is Secretary of the Birmingham Branch of the National Association of Retired Police Officers which has over 2,000 members. Joe and his wife, Joan, who is also a retired West Midlands police officer, are presently visiting their daughter who lives here, and Joe is planning to write an article about his Bermuda visit for the Birmingham Branch NARPO newsletter. CLICK HERE to see a previous article we have published about Joe’s visit in our Latest News column.  

Wayne Perinchief, Paul Singh and Vendal Bridgeman
 
John Dale, Oliver Bain, Dave Purcell and Stan Francis
 
Neil Halliday, Pat Hamlett and Rex Osborne
  
George Rose, Paul Towlson and Kevin Knight
 
Terry Spencer, Carlton Adams and John Skinner
 

Joe chatted to quite a few of the guys at our lunch and was interested to know many of us had previously served in other Police departments elsewhere.  For that reason we’ve produced below a quick list of our attendees together with their previous police service, or country of origin which might also be of interest to our own colleagues.

Louis Griffith and Ken Shillingford
 
Andy Wright, Norman Wilson and Larry Fox
 
Roger Kendall and Mike Chlebek
 
Ernie McCreight, Roger Sherratt, Roddy Barclay and Charlie Mooney
 
Ian McMillan and Mark Bothello
 
Keith Cassidy and Mike Shaw
 
Mike Shaw, Peter Borland and Scott Pacheco
 
Dave Cooper, Ernie McCreight, Roddy Barclay,
Charlie Mooney, Moby Pett and Pete Shaw
 

On a sad note, Bill asked for a moment of silence for those of our colleagues who passed away during the past 12 months. They are Steve Dunleavy, Mike Cherry, Graham Alderson, Braxton Stowe, Tony Smith and Darren Marcano.

On a more positive note, Bill pointed out that although we wouldn’t be entertained this year by “Fast Eddie” Davies who revels in joke-telling when he happens to be on Island for this gathering, but we were about to be treated to a musical interlude by our good friend John Dale.  

John  Dale in full voice
 

John gave a moving rendition of “Let there be Peace on Earth”, after which he serenaded Joe Tildesley with a rendition of “Bermuda is Another World” accompanied, with a little encouragement, by some of our attendees who had been members of the Police Choir, although it has to be said the accompaniment also included voices that clearly had never sang in a choir of any description!   

John serenades Joe Tildesley with
"Bermuda is Another World"
 

When asked about this year’s event Bill said, “I think it went off smoothly, it‘s always good to see former colleagues that you don’t come across in the normal course of your day. Our thanks to Ed Barnes and the rest of the staff at Mad Hatters,  the food was really good and service good as usual.  Also thanks to John Dale for the impromptu concert. ”

Bill pointed out that our two elder statesmen at the lunch were Wayne Perinchief and Stan Francis who were both born 83  years ago in 1941.

LIST OF ATTENDEES

Here’s our list of attendees with their former police forces or countries of origin.  Experienced police officers recruited abroad – from either the UK or the West Indies would normally undertake a two week Familiarisation Course on arrival in Bermuda.  Overseas recruits with no prior police experience, together with Bermudian recruits would attend  3 month Basic Training Courses along very similar lines to those in the UK. 

Carlton Adams          Bermuda Police
Oliver Bain                 Royal Grenada Police Force
Roddy Barclay          Edinburgh City Police
Ray Bell                     Durham Constabulary
Peter Borland            recruited from UK Liverpool
Mark Bothello            Bermuda Police
Vendal Bridgeman    recruited from WI Barbados
Roger Brydon           Northumberland
Bill Butterworth         Sunderlamd Boro, Durham County Police
Keith Cassidy            Liverpool Police
Mike Chlebek            recruited from UK Bolton
Dave Cooper             Hampshire Police
John Dale                  Salford City and Manchester Police
Larry Fox                   Merseyside Police
Stanley Francis         Grenada Police Force
Louis Griffiths            recruited from WI Barbados
Neil Halliday              recruited from UK Wales
Patrick Hamlett         recruited from WI St. Vincent
Roger Kendall           Leics and Rutland Police
Kevin Knights            Suffolk Police
Gerry Lyons               recruited from UK Bonny Scotland
Ernie McCreight        Glasgow Police – ardent Rangers fan!
Ian McMillan              Strathclyde Police
Charles Mooney        recruited from UK Scotland
Rex Osbourne          Gloucestershire Constabulary
Scott Pacheco          Bermuda Civilian
Wayne Perinchief      Bermuda Police
“Moby” Pett              Staffs County Police
Geoff Piggott            Cambridgeshire Police
Dave Purcell              recruited from WI Grenada
George Rose             Birmingham City Police
Phil Scarcliffe            Lincolnshire Police
Mike Shaw                recruited from UK ex Royal Navy
Peter Shaw               Thames Valley Police
Roger Sherratt          Staffs County Police
Ken Shillingford         recruited from WI Dominica
Paul Singh                 recruited from WI Trinidad
John Skinner             East Sussex Police
Terry Spencer            Bermuda Police 
Joe Tildesley             West Midland Police (Vaitor)
Paul Towlson             Nottinghamshire Constabulary
Norman Wilson         recruited from NI County Antrim

 


 

 

 

 

 

21.422MBMemory Usage357msRequest 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" => "" "DOC...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747386559 "last" => 1747386559...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (61.26ms)
  • afterInitialise (7.21MB) (121ms)
  • afterRoute (1.94MB) (38.07ms)
  • beforeRenderComponent com_content (401.42KB) (6.23ms)
  • Before Access::preloadComponents (all components) (483.67KB) (6.45ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.62ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (35μs)
  • After Access::preloadPermissions (com_content) (938.34KB) (4.67ms)
  • Before Access::getAssetRules (id:1680 name:com_content.article.1427) (34.65KB) (118μs)
  • After Access::getAssetRules (id:1680 name:com_content.article.1427) (25.52KB) (552μs)
  • afterRenderComponent com_content (3.8MB) (59.62ms)
  • afterDispatch (4.59KB) (400μs)
  • beforeRenderModule mod_custom (Spacer) (312.34KB) (6.71ms)
  • afterRenderRawModule mod_custom (Spacer) (99.21KB) (2.23ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (17μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (1.25ms)
  • beforeRenderModule mod_finder (Smart Search) (648B) (115μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.09KB) (16.07ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (20μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (313μs)
  • afterRender (1.55MB) (29.32ms)
  • 1 x afterInitialise (7.21MB) (33.81%)
    121ms
    1 x afterLoad (3.65MB) (17.15%)
    61.26ms
    1 x afterRenderComponent com_content (3.8MB) (16.69%)
    59.62ms
    1 x afterRoute (1.94MB) (10.66%)
    38.07ms
    1 x afterRender (1.55MB) (8.21%)
    29.32ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.09KB) (4.5%)
    16.07ms
    1 x beforeRenderModule mod_custom (Spacer) (312.34KB) (1.88%)
    6.71ms
    1 x Before Access::preloadComponents (all components) (483.67KB) (1.8%)
    6.45ms
    1 x beforeRenderComponent com_content (401.42KB) (1.74%)
    6.23ms
    1 x After Access::preloadPermissions (com_content) (938.34KB) (1.31%)
    4.67ms
    1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.62%)
    2.23ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.45%)
    1.62ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.35%)
    1.25ms
    1 x After Access::getAssetRules (id:1680 name:com_content.article.1427) (25.52KB) (0.15%)
    552μs
    1 x afterDispatch (4.59KB) (0.11%)
    400μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.09%)
    313μs
    1 x Before Access::getAssetRules (id:1680 name:com_content.article.1427) (34.65KB) (0.03%)
    118μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.03%)
    115μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    35μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0.01%)
    20μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    17μs
35 statements were executed, 6 of which were duplicates, 29 unique18.98ms574.69KB
  • SELECT @@SESSION.sql_mode;131μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?261μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1220μ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)453μ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` = 1525μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`147μ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` = :guest193μ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`799μ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.12ms52.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`461μ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` = 1475μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC209μ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)918μ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.1ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`529μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '1427'354μ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)598μs47.38KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`408μ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)301μ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`456μ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 ASC702μ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.88ms21.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`411μ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`980μs146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1553μ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 = 1239μ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)1ms1.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)283μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering406μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context213μ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)454μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)375μs46.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `dztir_scheduler_tasks` AS `a` WHERE `a`.`state` = 1206μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?183μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?431μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy