J.C.P. “Jim” Hanlon

This Hall of Fame article about the Late former Assistant Commissioner of Police, James Christopher Patrick “JCP” or “Jim” Hanlon, has been compiled with valuable input and assistance from JCP’s wife, Elizabeth “Liz” who made a recent visit to Bermuda in early October 2023. 

 Elizabeth “Liz” Hanlon visits Bermuda - 2023 

James Christopher Patrick  Hanlon was born  on the 19th December 1929, the eldest child of Alice and Joseph Hanlon, in Drogheda, County Louth, Ireland.  He was brother to Nick, Marie, Bernie, Tony and Vera, all now unfortunately deceased.

Liz recalls that Jim always said he owed the Christian Brothers a debt of gratitude for the education he received, which he put to good use. He had a good brain and a phenomenal memory.

As a child, playing “soldiers “ was his favourite game. He did confess he was always “in charge“ so it was almost inevitable that he should enter a disciplined profession.

Police Forces in Ireland, neither North nor South, were recruiting in 1952 so Jim decided to apply to join the Colonial Police. This could have been Palestine, Hong Kong or Rhodesia, but after an interview in London he was accepted as a “Constable Third Class” in the Bermuda Police Force, with a salary of £510 per year rising to £550. 

Royal Gazette article

Jim arrived in Bermuda by BOAC on 15th February 1952, and he was one of ten new recruits, all of whom were from Ireland. The Royal Gazette heralded their arrival with a headline, “10 NEW POLICEMEN HERE – ALL FROM IRELAND, and the article read as follows:-   

“Bermuda’s Police Force will have to find a nickname other than “Paddy” for their Irish members, otherwise they may find themselves in trouble.

Last night ten “Paddies” arrived here by BOAC from the Emerald Isle to augment the Colony’s police establishment. Oddly enough, not one of their names is Patrick.  They were recruited by Police Commissioner J.S. McBeath who is still in the United Kingdom.

All ten have three things in common. They are Irish, six feet tall or over, and none of them has served in a police force before.

There are the brothers Daly, Ralph and Leo from Limerick; George Wright and Christopher Murphy, also from Limerick; Jim Walsh and Frank Walsh from Kilkenny; John Sheehy from Cork; John O’Brien from Wicklow; James Hanlon, from Drogheda; and Michael Boylen, from Kerry.

Leaving Shannon Airport on Thursday afternoon. They flew here via Boston and New York. They were met last night by Inspector John Brown.

It was stated last night that the new recruits will go through a training period lasting several weeks before being assigned to duty.”

Training Course for new recruits held in March 1952
Standing (l-r)  Percy Miller (Instructor),  Thomas D. "Tommy" Doyle
Back row seated:-  (l-r)  F. Walsh, L. Daly, R. Daly, and J.C.P. "Jim"Hanlon
Middle Row:-  Clement "Clem" O'Brien, C.N. Murphy, G. Wright. and Jim Walsh
Front Row:-  C. King, John Joseph Sheehy, Terry Moody, and M.J. "Mike" Boylan 
 

The ten Irish officers attended what was probably the first ever group training course for new recruits. Prior to that any new recruits without previous police experience would usually spend a few days at Hamilton Police Station under the supervision of a senior officer who would  brief them on police procedures and the law.  

On completion of the training course, young Jim was posted to general duties in Hamilton where the Police Station was located on Parliament Street opposite the House of Assembly (where the Government Administration building now stands).  He would have started on the beat but in 1953 he worked as Station Constable in Hamilton, and in the same year he was transferred to the Administration Office. Jim’s administrative skills were already coming to the fore.

In 1954 Jim transferred to C.I.D. and worked for a while in the Criminal Records Office.  He received a Commendation in 1955 following his investigation of larceny cases resulting in the clearance of a series of crimes committed by a group of juveniles.  While serving in CID Jim attended a CID Course at Bishopgarth in Wakefield, Yorkshire, in 1957, and was placed third in the final examination; very commendable as he was competing with experienced officers from England.

Liz described Jim as a lover of words, and it was Jim who started the Police Magazine in 1955.  He was the driving force behind the magazine  and was its Editor until his retirement in 1984 during which time some 35 magazines were published. The first magazine was published in July 1955,  and for many years there would be quarterly issues  complete with numerous articles,  along with photographs usually provided  by the police photographers in CRO.  Regular features were “Divisional Notes” submitted by individual contributors, reports on sporting and social events, details of new recruits, promotions and retirements.  

Jim wrote numerous magazine articles, and an example of the excellent  quality of his penmanship  can be viewed in our ExPo website article “RCMP visit Bermuda” describing a historic visit by the RCMP mounted musical ride team in 1968.  This was the first time the RCMP had ever performed in a British Colony and also the first occasion for which they had transported their horses by air. CLICK HERE to review JCP’s superb  article as it appeared in the police magazine, 

Royal Canadian Mounted Police Musical Ride and
Bermuda Police Motor Cycle Display Team
performed at BAA Field in November 1968
 

Jim was posted to Prosecutions in 1958, and Liz recalls Jim would later relate tales from his time in the courts such as  “when a well known gentleman broke a window or threatened to do so every Christmas Eve in order to get into Casemates for Christmas dinner The same gentleman when offered a suit of clothes by the equally well known Magistrate,  (no doubt the Wor. Minty) requested the Magistrate to have them dry cleaned first!  I presume this tale to be true.”

Hamilton Magistrates Court on Parliament Street next to Hamilton
Police Station circa 1958.  On the bench is The Wor. Leonard Minty
Seated are P.C. Jimmy Woodward (centre) and P.C. JCP Hanlon (right)
 
The irrepressible “Weatherbird” Mills
 

Editors note – There is no doubt that the gentleman in question was Bermuda’s legendary Rummy, “Weatherbird” Mills.

While in Prosecutions, Jim found himself involved in one of the most serious incidents in Bermuda’s History -  the Dockworkers Strike - in September 1959. Young P.C. Mike Cherry had arrived in Bermuda only two months earlier when Hamilton’s dock workers went on strike.  After several days of unrest, and with the docks empty and at a standstill,  Mike described how “a handful of policemen were issued with ex-army tin helmets, wicker shields, and long wooden batons, and marched down Front Street led by Superintendent Percy Miller, to be met by an unruly mob of dockworkers supplemented by others, all seemingly armed with an assortment of ugly weapons.”  

Dock workers armed with a variety of weapons
in confrontation with police officers in attendance
 

In his account of that day Mike says, “No formal training in the use of wicker shields and wooden batons had yet been organized, but as most of us were military trained we at least gave an indication that we knew what we were doing. Although I do not think that the wooden batons would have lasted long against some of the nasty looking swords and pieces of rebar that were apparent. Fortunately after being read the “Riot Act” by magistrate Ronnie Grey from the balcony of H A & E Smith's store, ably assisted by Sergeant JCP Hanlon, the mob dispersed without serious incident, and also due to the efforts of longshoreman ‘Pork Chop’ Mills.“ 

CLICK HERE to view Mike Cherry’s “Then and Now” article on our ExPo website.

Jim, in his capacity as the Sergeant in Prosecutions, would no doubt have been directly involved in the drafting of the relevant section of the Riot Act read by Magistrate Grey and he was present when it was read to those congregated on Front Street.  This is probably the only time in Bermuda’s history where the “Riot Act” has been read in order to quell a riot.

While serving in Prosecutions Jim had been promoted to Sergeant in December 1958, and two years later, in 1960, he was one of 4 officers posted to the newly created Special Branch. The four officers were Superintendent John MacGregor, and Sergeants Ian Morrison, JCP “Jim” Hanlon,  and Peter Stubbs.

Jim was promoted to Inspector while serving in Special Branch where he served until his transfer to Somerset in July 1963 as the Officer in Charge of Western Division.

Although he was not actively involved in sports, Jim was a member of the Police Shooting Team.  Their practice range was located at Prospect behind the Police Headquarters building.  He was a member of the Police Pistol Team which took part in, and won,  the Caribbean Pistol Competition in 1964.  The team comprised Detective Inspector JCP Hanlon, Detective Sergeant Leslie Waddell, Sergeant Tim Willis, and Constables Nick Hall and Colin Jowett.

Caribbean Police Pistol Competition – 1964
Standing (l-r)  Sgt Tim Willis, D/Inspector JCP Hanlon and D/Sgt Les Waddell
Kneeling -  Colin Jowett and Nick Hall
 

One of the most significant events in Jim’s police career occurred in June 1964 when he was seconded to the Administration Department by then located at the Police Headquarters building, Prospect, at the former Military Garrison.  Three months later he was made OIC of “A” Department (Administration).  He spent 3 years in Special Branch  from June 1965 - October 1968, then, apart from a  brief stint at Travel Control at the airport in June 1969,  Jim spent most of the rest of his career in Administration where he was promoted to Chief Inspector in November 1970, and to Superintendent in December 1973 at which time he was made OIC of both “A” Department (Administration) and “B” Department  (Finance). 

1970 was a very special year in Jim’s life.  According to a most reliable source, Jim saw an attractive young lady while attending the annual Floral Festival, and took the number of her auxiliary cycle.  The rest, as they say, is history.  The young lady was Miss Hester Elizabeth “Liz” Hyndman from Northern Ireland who came to Bermuda as a nurse at King Edward Hospital.  Jim and Liz fell in love and were married in Coleraine, Northern Island, on 18thSeptember 1971.

Jim and Liz on their wedding day in 1971
 

There is no question that JCP “Jim” Hanlon, with his exceptional administration skills, had a highly successful career as a Bermuda Police Officer, rising through the ranks to his final promotion as Assistant Commissioner (Crime) on 21st December 1981, a position he held until his official retirement in  February 1985.   

Bermuda Police Senior Officers -  Late 1981
Back Row (l-r) Edward "Boxhead" C Foggo*, Dave Barber, Mike Burke, Alan Bissell, Dave Chew, 
George Rose, Tom Cassin*, Jean Vickers, John "Barry" Smith*, Geoff Sanders*, Neil Cox, Derek Jenkinson
Middle Row -  Ed Bailey, Brian Flook*, Custerfield "Custy" Crockwell*, John Williams*, Sinclair "Brinky" Tucker, 
Gerry James*, Andy Bermingham, Lawrence Jackson*, Hilton B Wingood, Tim Willis*, Alex Forbes*,
Robin Henagulph ,Larry Smith, Cal Christopher*, Ian Scotland*, Wayne Perinchief
Bottom Row -  Bill Bryan*, Gerry Harvey*, JCP Hanlon*, Clive Donald, COP Frederick "Penny" Bean*,
Harold  Moniz*John Joe Sheehy*, Lennet "Lenny" Edwards*, and George Garrod*.
 
Assistant Commissioner James "JCP" Hanlon
 

Jim was awarded the Colonial Police Medal for Meritorious Service in 1967, the Colonial Police Long Service and Good Conduct Medal in 1970,  the CPM clasp for 25 years service in 1977, and the 30 year clasp in 1982. 

On the occasion of Jim’s retirement  the then Commissioner Mr Fred “Penny” Bean sincerely thanked him for his outstanding service to the Bermuda Police Service and paid tribute to his “dependability, integrity, enthusiasm, sense of justice, and unselfishness."

Liz says that she and Jim returned to Ireland in 1985 to live on Minnistown Road, Laytown, in County Meath, where  neighbours became friends and he became Jimmy to the children of the road. He stayed involved with their community in Neighbourhood Watch, Probus, reorganising the library of the local hospital, and as  President of The Past Pupils Union of the Christian Brothers.

Jim and Liz enjoying retirement in Ireland

 

Sadly, his retirement was cut short by the onset of Alzheimer’s Disease which he described as a “Robbing Disease”.  The hobbies he loved most - reading, writing to friends, visiting friends, listening to music, travelling, and “using words” -  were gradually taken away from him.

JCP died on 27th  March 2002. However his funeral was held on Easter Sunday in St Mary’s Church Drogheda, with all the most wonderful, joyous, up-lifting, celebratory music, full of pomp and circumstance!  He would have appreciated and enjoyed all of it.

Editors Note  -  I had the pleasure of meeting Liz Hanlon here in Bermuda in October 2023, while she was on holiday staying at the Rosedon Hotel.  While reminiscing about good times in Bermuda, Liz indicated she had retained some of JCP’s files which she kindly sent to me for inclusion in this Hall of Fame article.

Having spent the past 11 years operating and editing our ExPo website, I have a great appreciation for the enormous amount of time and effort and energy that JCP clearly devoted to producing and editing the Police Magazines for almost 30 years. 

Perusing through old copies of the Police Magazine is fascinating for anyone who served in the Bermuda Police during the years it was published. It is an invaluable resource for anyone interested in researching our history.  A complete set of all the police magazines is now housed in the Police Museum in the Officers Mess at Prospect, and in this regard it’s a pleasure to report that through the generosity of Mr. Rees Fletcher -  son of the Late retired Sergeant Derek Fletcher -  the National Museum of Bermuda is currently embarked on a project to scan all of the magazines with the intention of being able to host a searchable data base  so they can be readily accessible through the internet.

It will be a lasting legacy to JCP “Jim” Hanlon if one day soon we can provide internet access to all of the contents of our Bermuda Police Magazines.

Roger Sherratt
Editor
October 2023

 

 

 

 

 

21.54MBMemory Usage264msRequest 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" => 1743527886 "last" => 1743527886...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (35.46ms)
  • afterInitialise (7.2MB) (76.28ms)
  • afterRoute (1.94MB) (24.81ms)
  • beforeRenderComponent com_content (401.36KB) (4.93ms)
  • Before Access::preloadComponents (all components) (483.67KB) (5.44ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.63ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (22μs)
  • After Access::preloadPermissions (com_content) (929.48KB) (4.64ms)
  • Before Access::getAssetRules (id:1463 name:com_content.article.1272) (34.65KB) (102μs)
  • After Access::getAssetRules (id:1463 name:com_content.article.1272) (25.52KB) (567μs)
  • afterRenderComponent com_content (3.85MB) (61.85ms)
  • afterDispatch (23.66KB) (1.01ms)
  • beforeRenderModule mod_custom (Spacer) (370.12KB) (6.55ms)
  • afterRenderRawModule mod_custom (Spacer) (35.21KB) (1.51ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (9μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (860μs)
  • beforeRenderModule mod_finder (Smart Search) (648B) (73μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.12KB) (10.17ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (11μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (195μs)
  • afterRender (1.57MB) (26.73ms)
  • 1 x afterInitialise (7.2MB) (28.92%)
    76.28ms
    1 x afterRenderComponent com_content (3.85MB) (23.45%)
    61.85ms
    1 x afterLoad (3.65MB) (13.44%)
    35.46ms
    1 x afterRender (1.57MB) (10.13%)
    26.73ms
    1 x afterRoute (1.94MB) (9.4%)
    24.81ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.12KB) (3.86%)
    10.17ms
    1 x beforeRenderModule mod_custom (Spacer) (370.12KB) (2.48%)
    6.55ms
    1 x Before Access::preloadComponents (all components) (483.67KB) (2.06%)
    5.44ms
    1 x beforeRenderComponent com_content (401.36KB) (1.87%)
    4.93ms
    1 x After Access::preloadPermissions (com_content) (929.48KB) (1.76%)
    4.64ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.62%)
    1.63ms
    1 x afterRenderRawModule mod_custom (Spacer) (35.21KB) (0.57%)
    1.51ms
    1 x afterDispatch (23.66KB) (0.38%)
    1.01ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.33%)
    860μs
    1 x After Access::getAssetRules (id:1463 name:com_content.article.1272) (25.52KB) (0.21%)
    567μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.07%)
    195μs
    1 x Before Access::getAssetRules (id:1463 name:com_content.article.1272) (34.65KB) (0.04%)
    102μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.03%)
    73μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    22μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    9μs
35 statements were executed, 6 of which were duplicates, 29 unique16.01ms627.69KB
  • SELECT @@SESSION.sql_mode;132μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?152μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1113μ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)390μ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` = 1294μ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` = :guest152μ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`618μ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`635μ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`386μ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` = 1423μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC271μ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)1.07ms7.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.5ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`666μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '1272'466μ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)602μs71.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`419μ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)305μ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`453μ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 ASC768μ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 DESC796μs2.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`352μ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.02ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1340μ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 = 195μ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)495μ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)130μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering318μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context141μ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)482μs70.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)355μs70.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` = 1147μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?143μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?298μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy