It was a real pleasure attending the "Ex-Bobbies Christmas Bash" held at Mad Hatters Restaurant in the Mariners Club on Thursday lunch-time 8th December 2016.  There were about 30 of our former officers present for the occasion and a very good time was had by all.

Dave Cook opened the proceedings by welcoming all those present.  Dave gave a brief history of this popular annual event:-

Dave Cook welcomes everyone

"As best my memory serves me, back in 1992 after I retired and was working for Paul Field at Bermuda Alarm Company  I received a call from George Rushe inviting me to lunch around Christmas time. To the best of my recollection joining us were Barrie Meade, John Instone, Peter Duffy, maybe others but I can’t recall. This became a regular occurrence at Christmas time just with the four or five of us. Over the years the numbers steadily increased. We met at MR Onions Restaurant on Par-la-Ville Rd. When they closed we moved to Fisches Place, now the Mad Hatters Restaurant,  here at at the Mariners Club.  We have had as many as 40 attend the lunch which has become a regular yearly get together. "  At the conclusion of his remarks Dave asked everyone present to raise their glass in a toast to "absent friends" and listed all those guys who have left us since last December.

Attending todays "bash" were  Dave Ashurst, Oliver Bain, Dave Barber, Roddy Barclay, John Barnett, Reese Bartley, Arthur Bean, Ray Bell, Foster Burke, Bill Butterworth, Keith Cassidy, Dave Cook, John Dale, Orson Daisley, Eddie Davies, Steve Dunleavy, Alan Gorbutt, John Greatrex, Neil Halliday, Pat Hamlett, Gerry Lyons, Brian Malpas, John McConnie,  Rex Osborne, "Moby" Pett, Kevin Reeves, Mike Shaw, Pete Shaw, Roger Sherratt, John Skinner, Phil Taylor, and Norman Wilson.

We had assembled at the Mad Hatters at 12 noon for drinks before taking our seats for an excellent meal.  In recent years it has become the custom to have "Fast Eddie" Davies tell a few jokes during the proceedings and he never fails to bring the house down.  On a more sombre note,  Eddie announced that he was retiring from his position at the Monetary Authority at the end of January and he and his wife will be heading to the U.S. to settle there later in the year.   Most of us believe he is irreplaceable - as a comedian! 

The food was superb and camaraderie was first class.

Eddie Davies in full flow! 
...... and the smuttier the jokes - the louder the laughs!  Just ask Phil Taylor.

We had two of our former officers visiting from abroad. As we reported last week, John Greatrex, was visiting from South Wales,  and Orson Daisley had just arrived from Barbados. Our most senior man was probably Brian Malpas who had travelled all the way from Somerset, while Arthur Bean arrived from the east.

Mad Hatter - a great place for lunch
(l-r) Kevin Reeves, Foster Burke, Oliver Bain, Orsan Daisley, John McConnie, Reese Bartley and Dave Cook
(l-r) Pat Hamlett, Kavin Reeves, Foster Burke and Oliver Bain  
 (l-r) Dave Barber, Bill Butterworth, "Moby" Pett (hiding), Pete Shaw, Keith Cassidy, Phil Taylor,
Mike Shaw, Norman Wilson, Roddy Barclay, Alan Gorbutt and John Greatrex
(l-r) Bill Butterworth, "Moby" Pett, Pete Shaw, Keith Cassidy
Roger Sherratt and Dave Barber (Dave is getting new teeth soon)
 Roddy Barclay and Alan Gorbutt
 John Greatrex, Rex Osborne and "Fast Eddie" Davies
Neil Halliday, Dave Ashurst, Arthur Bean and Brian Malpas 
Gerry Lyons, Ray Bell and John "Flaps" Barnett 
 (l-r) Dave Ashurst, Arthur Bean, Brian Malpas, Neil Anderson and Steve Dunleavy
John Skinner, John Dale, Neil Anderson and Dave Ashurst 

Everyone who attended has been invited to write a quick note about where they are what they're doing these days for the information of our members abroad.  We will also endeavour to locate their old warrant card photos and post them with their replies, although some photos are missing and others have deteriorated - the photos that is!  If that is the case we'll try to find a photo in our ExPo collection. Here are the replies received so far:-

 

Oliver Bain

Oliver served from 1969-1995 and after retirement in1995, he was appointed Executive Officer of the United Bermuda until 1998 when the Progressive Labour Party became the government. I am sure you are aware that when one has a political appointment you become a casualty if your party is unsuccessful. Subsequently l worked  for Sun Life of Canada for three years selling life insurance. In 2003 a former colleague and l formed a taxi company and drove and organise transportation for corporate clients. I still do a bit in that regard so l consider myself semi retired. I play tennis three times a week but only doubles as l could always blame my partner if we lose. I am still very competitive. I travel frequently to NY to see my 96year old mother and to Grenada to see family members.

 
 
Young P.C. John "Flaps" Barnett
John Barnett a.k.a. ‘Flaps’
John was born on June 17 1939. He served in the BPS from 1961 to 1969. During this time he walked the beat in Hamilton, was in the Marine Section, served as a traffic officer and completed his service as a clerk in Police HQ when senior officers found he could type!   He married Sandra Jones on December 10 1964 so celebrated their 52nd wedding anniversary two days after the ex-bobbies bash. He has three children and seven grandchildren.  After leaving the BPS John entered the life insurance business with Sun Life of Canada. John and Sandra left Bermuda in 1981 while John was still with Sun Life, moving to Toronto for 10 months then to Vancouver until 1997 when he returned to Bermuda to set up a company, Life & Annuity Services Ltd., dealing with jumbo sized life insurance policies issued by Sun Life and Manulife.
John retired from L&A in 2014 at the age of 75 after handing over the reins of the company to his son Scott. He is the current President of the Gilbert & Sullivan Society of Bermuda, which produces quality musicals in Bermuda. Now that he’s retired he and Sandra spend as much time as possible traveling and have just completed a round the world trip.
Editors note -  John is also a Past President of our Ex-Bermuda Police Association who did a great job during his tenure as President.
 
Sergeant Dave Cook
Dave Cook
After retirement from the Police in 1992, Dave worked for an alarm company for 2 years then went to Butterfield Bank security depatment alongside former Sgt John Graham. During his 11 years at the bank  he was made Head of Security, retiring in December 2005.
Dave is now fully retired but he and his wife, Patsy, are very busy in retirement.  Dave has played a vital role in re-activating our Ex-Police Association. He and Patsy travel whenever possible, They have three lovely granddaughters aged 15,4 and 2  who give them a lot of pleasure, and Dave keeps fit by attending aqua aerobics at the National Sports Centre.  He is, of course, the organizer of this annual Ex-Bobby Bash
P.C. Alan Gorbutt
Alan Gorbutt
Alan retired from the Police in 2007 after 25 years.  He worked for 5 years  at an office furniture company and now coming up to 5 years as an assistant facilities manager for the Bermuda Hospital Board.   Alan has been married for over 25 years to Susan and they have a 24 year old daughter Alexandra.   He is still an avid collector of Royal Memorabilia and managed to be featured in a recent new book 'Royal Bermuda'.  Alan has promised faithfully to write an article for our website on his amazing memorabilia collection – if he can find somewhere to sit down at home!
P.C. John Greatrex
John Greatrex
Since return to the UK, John have travelled extensively, visiting 21 new countries, making a total of 73 in all  -  definitely a world traveller! John is an avid sports fan.  He attends the Oval cricket ground to watch England (not sure if he’s a member of the Balmy Army!),  He also follows the Welsh rugby team attending all their home games. Next year, he has plans to visit France, Jersey, Hong Kong, San Francisco, and plans on traveling to New Zealand to support the British Lions rugby team against the All Blacks.
 
Neil Halliday
After leaving the Force Neil  moved to the Bank of Bermuda then after qualifying as a lawyer he worked with MJM for a number of years and recently moved to Winchester Global Trust – still working full-time.
 
Kevin Reeves
Kevin left  the Police in 2001 after 25 years. He worked at the Bank of Butterfield for eight years and has been at the Bermuda Monetary Authority for seven years. He will be retiring next year and he and his wife Susan, who has just retired from nursing,  plan to move to the Dordogne area in France.
 
Mike Shaw
Mike Shaw
Mike Shaw - retired from the Police in 2003 after 27 years service and went to work for Will Cox running The Waterfront Marina, at Barr’s Bay. Mike retired again in 2011 to look after an estate for some friends. Enjoys golf days  with like minded ex-police colleagues, and travel to UK on a fairly regular basis.
 
John and Sheila Skinner in happier times at an ExPo function
John Skinner
I joined the Bermuda Police in 1972 after service in Sussex Police. I retired from the Police in 2003 .  I later joined the Bank of Bermuda, then a real estate company before joining AF Smith from where I 'finally' retired in 2014 to look after my wife Sheila.  I have since returned twice for short term contracts.  Sheila and I were married for 37 years.  She passed away in December 2014.  I have one daughter Claire and two grandchildren, Chelsea (10) and Santi (6), who all live in Bermuda.

 

 

 

 

 

21.439MBMemory Usage342msRequest 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" => "" "DOC...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743826950 "last" => 1743826950...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (54.66ms)
  • afterInitialise (7.2MB) (109ms)
  • afterRoute (1.94MB) (34.56ms)
  • beforeRenderComponent com_content (401.38KB) (6.94ms)
  • Before Access::preloadComponents (all components) (483.66KB) (7.38ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.64ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (30μs)
  • After Access::preloadPermissions (com_content) (929.48KB) (6.07ms)
  • Before Access::getAssetRules (id:647 name:com_content.article.534) (34.65KB) (162μs)
  • After Access::getAssetRules (id:647 name:com_content.article.534) (25.52KB) (664μs)
  • afterRenderComponent com_content (3.81MB) (62.29ms)
  • afterDispatch (4.59KB) (382μs)
  • beforeRenderModule mod_custom (Spacer) (376.37KB) (6.49ms)
  • afterRenderRawModule mod_custom (Spacer) (35.21KB) (1.52ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (9μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (849μs)
  • beforeRenderModule mod_finder (Smart Search) (648B) (75μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.12KB) (11.99ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (17μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (250μs)
  • afterRender (1.55MB) (35.8ms)
  • 1 x afterInitialise (7.2MB) (31.8%)
    109ms
    1 x afterRenderComponent com_content (3.81MB) (18.22%)
    62.29ms
    1 x afterLoad (3.65MB) (15.99%)
    54.66ms
    1 x afterRender (1.55MB) (10.47%)
    35.80ms
    1 x afterRoute (1.94MB) (10.11%)
    34.56ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.12KB) (3.51%)
    11.99ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (2.16%)
    7.38ms
    1 x beforeRenderComponent com_content (401.38KB) (2.03%)
    6.94ms
    1 x beforeRenderModule mod_custom (Spacer) (376.37KB) (1.9%)
    6.49ms
    1 x After Access::preloadPermissions (com_content) (929.48KB) (1.77%)
    6.07ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.48%)
    1.64ms
    1 x afterRenderRawModule mod_custom (Spacer) (35.21KB) (0.44%)
    1.52ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.25%)
    849μs
    1 x After Access::getAssetRules (id:647 name:com_content.article.534) (25.52KB) (0.19%)
    664μs
    1 x afterDispatch (4.59KB) (0.11%)
    382μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.07%)
    250μs
    1 x Before Access::getAssetRules (id:647 name:com_content.article.534) (34.65KB) (0.05%)
    162μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.02%)
    75μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    30μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0.01%)
    17μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    9μs
35 statements were executed, 6 of which were duplicates, 29 unique19.04ms574.69KB
  • SELECT @@SESSION.sql_mode;109μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?129μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1114μ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)372μ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` = 1330μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`123μ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` = :guest172μ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`647μ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`619μ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`427μ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` = 1351μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC235μ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)970μ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.24ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`604μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '534'282μ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)597μ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`541μ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)369μ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`438μ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 ASC789μ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`360μ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.71ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1464μ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 = 1123μ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)795μ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)196μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering505μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context217μ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)641μ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)482μ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` = 1462μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?261μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?490μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy