Show Guide: 'The Hat Squad'

Synopsis: Police officer Mike Ragland and his wife Kitty have adopted three boys whose parents' lives were taken by violence; having been told stories about the police "hat squads" of the past, the three boys grew up to become an elite police unit called The Hat Squad, dressed in street clothes and fedoras. They consist of Buddy, who was just a baby when his father died; Rafael, who doesn't carry a firearm and uses a wide variety of methods to subdue criminals; and Matty, who is studying to become a lawyer. (Courtesy CBS, 1992)

The Cast:
Don Michael Paul as Buddy
Nestor Serrano as Rafael
Billy Warlock as Matty
James Tolkan as Mike Ragland
Janet Carroll as Kitty Ragland

Production Credits:
Produced by Stephen J. Cannell Productions

The Episodes:
Season One Episode Guide (CBS)
1-01 Pilot--09/16/1992
The Squad's first case involves catching a murderer who is terrorizing the only witness, a young boy.
Written by: Stephen J. Cannell
Directed by: Rob Bowman

1-02 The Widow Maker--09/23/1992
Matty is beaten up by a cop who moonlights as a killer. They devise a plan to capture this killer, but things are not a clear-cut as they seem to be.
Written by: Stephen J. Cannell
Directed by: Rob Bowman

1-03 92 Seconds To Midnight--09/30/1992
Raffi goes undercover to protect a little girl when her father is forced out of his retirement from crime by a robber planning a two-million-dollar subway heist.
Written by: Bill Nuss
Directed by: Rob Bowman

1-04 Family Business--10/28/1992
It's a family feud when the Hats clash with a family of extortionists that uses strong-arm tactics. An additional obstacle: saving the family's tormented youngest member from a life of crime.
Written by: Stephen J. Cannell
Directed by: Kim Manners

1-05 Phoenix Rising--11/04/1992
The guys must act quickly when a deranged explosives expert escapes from prison and targets Mike, the cop who put him behind bars for murder.
Written by: Charles Grant Craig
Directed by: Vern Gillum

1-06 Ten--11/11/1992
Bad brothers blow away Buddy's buddy, leaving a young boy fatherless, so the Hats scramble to confront the hit men before they leave town.
Written by: Charles Grant Craig
Directed by: Tucker Gates

1-07 Rest In Peace--12/09/1992
Buddy travels to Las Vegas as he tracks a mob boss he thinks murdered his natural father. But the killer is closer to home, as is someone who has a contract to kill Buddy.
Written by: Charles Grant Craig, Bill Nuss
Directed by: Bruce Kessler

1-08 Lifestyles Of The Rich And Infamous--01/02/1993
The team must protect a murder witness from a killer who is also the heir to a fortune. Meanwhile, Rafael is mistaken for the "Kissing Bandit."
Written by: Bill Nuss
Directed by: Kim Manners

1-09 A Dog's Life--01/09/1993
Frustrated by a canine capable of detecting smuggled drugs, a drug lord puts a bounty on the dog's life. The DEA sniffs out The Hat Squad to protect the dog, but the brothers can't help but sink their teeth into the larger case.
Written by: Bill Nuss
Directed by: Rob Bowman

1-10 Dead Man Walking--01/16/1993
The Hats get a tip from a death row inmate about some bad cops. They must get the evidence against the cops before the cops find them.
Story by: Stephen J. Cannell
Teleplay by: Charles Grant Craig, Bill Nuss
Directed by: Kim Manners

1-11 The Liquidator--01/23/1993
The Hats are called on to protect a woman from a mob-hired hit man.
Written by: Stephen J. Cannell
Directed by: Brad Turner

1-12 Frankie Stein--Unaired
Matty gets in trouble when he tries to prove that recently released criminal Frankie Stein is committing armed robberies.
Written by: David Greenwalt
Directed by: Kim Manners

1-13 The Twelfth Victim--Unaired
A serial killer threatens a blind psychiatrist, and the team is assigned to protect her.




8.636MBMemory Usage187msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.31
Identityguest
Response200
Templateja_blockk
Database
Server
mysql
Version
8.0.39-cll-lve
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743424989 "last" => 1743424989...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.67ms)
  • afterInitialise (1.26MB) (31.2ms)
  • afterRoute (281.64KB) (10.69ms)
  • beforeRenderComponent com_content (38.2KB) (1.23ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.1ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.14ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (19μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (11.32ms)
  • Before Access::getAssetRules (id:2740 name:com_content.article.1911) (130.8KB) (318μs)
  • After Access::getAssetRules (id:2740 name:com_content.article.1911) (8.47KB) (283μs)
  • beforeRenderRawModule mod_related_items (Read More) (859.15KB) (29.73ms)
  • afterRenderRawModule mod_related_items (Read More) (38.48KB) (9.76ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (16μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (474μs)
  • afterRenderComponent com_content (57.04KB) (99μs)
  • afterDispatch (2.28KB) (320μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (60.87ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (619μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (201μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (43μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (119μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (3μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (91μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (83μs)
  • afterRenderRawModule mod_finder (Head Search) (69.34KB) (3.57ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (178μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (40μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (363μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (110μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (39μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (85μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (92μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (21μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (79μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (88μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (20μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (120μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (4μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (88μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.34ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.52KB) (2.65ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (106μs)
  • afterRender (669.13KB) (9.16ms)
  • 1 x beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (32.63%)
    60.87ms
    1 x afterInitialise (1.26MB) (16.72%)
    31.20ms
    1 x beforeRenderRawModule mod_related_items (Read More) (859.15KB) (15.94%)
    29.73ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (6.07%)
    11.32ms
    1 x afterRoute (281.64KB) (5.73%)
    10.69ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.48KB) (5.23%)
    9.76ms
    1 x afterRender (669.13KB) (4.91%)
    9.16ms
    1 x afterLoad (528.29KB) (4.11%)
    7.67ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.34KB) (1.91%)
    3.57ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.52KB) (1.42%)
    2.65ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.72%)
    1.34ms
    1 x beforeRenderComponent com_content (38.2KB) (0.66%)
    1.23ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.61%)
    1.14ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.59%)
    1.10ms
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.33%)
    619μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.25%)
    474μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.19%)
    363μs
    1 x afterDispatch (2.28KB) (0.17%)
    320μs
    1 x Before Access::getAssetRules (id:2740 name:com_content.article.1911) (130.8KB) (0.17%)
    318μs
    1 x After Access::getAssetRules (id:2740 name:com_content.article.1911) (8.47KB) (0.15%)
    283μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.11%)
    201μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.1%)
    178μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.06%)
    120μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.06%)
    119μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.06%)
    110μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.06%)
    106μs
    1 x afterRenderComponent com_content (57.04KB) (0.05%)
    99μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.05%)
    92μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.05%)
    91μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.05%)
    88μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.05%)
    88μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.05%)
    85μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    83μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.04%)
    79μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    43μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.02%)
    40μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.02%)
    39μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    20μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    16μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    3μs
46 statements were executed, 3 of which were duplicates, 43 unique31.25ms407.59KB
  • SELECT @@SESSION.sql_mode;108μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?163μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1114μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `tvlfg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)708μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1322μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`107μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `tvlfg_usergroups` AS `a` LEFT JOIN `tvlfg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest170μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `tvlfg_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`531μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'2.63ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC247μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='1911-show-guide-the-hat-squad' AND published=1230μs4.08KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352Copy
  • 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 `tvlfg_menu` AS `m` LEFT JOIN `tvlfg_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`665μs20.92KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_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`757μs5.33KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `tvlfg_template_styles` AS `s` LEFT JOIN `tvlfg_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` = 1276μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_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)685μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 03.69ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.45ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1911'833μs48B/libraries/src/Table/Table.php:1325Copy
  • 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 `tvlfg_content` AS `a` INNER JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `tvlfg_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_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)515μs24.63KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`540μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_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,:preparedArray2)1.47ms5.23KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`526μs5.19KBParams/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 tvlfg_fields AS a LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id LEFT JOIN tvlfg_fields_groups AS g ON g.id = a.group_id LEFT JOIN `tvlfg_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,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC397μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) 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 DESC561μs2.47KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`540μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT u.id, u.name, u.username, u.params FROM tvlfg_users AS u LEFT JOIN tvlfg_user_usergroup_map AS g ON g.user_id = u.id WHERE u.id = '51' GROUP BY u.id140μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'141μs856B/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:467Copy
  • SELECT profile_key, profile_value FROM tvlfg_user_profiles WHERE user_id = 51 AND profile_key LIKE 'profile.%' ORDER BY ordering149μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.15ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid130μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `tvlfg_usergroups` AS `g` INNER JOIN `tvlfg_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid168μs1.7KBParams/libraries/src/Table/User.php:132Copy
  • 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 tvlfg_fields AS a LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id LEFT JOIN tvlfg_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,: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 ASC425μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'106μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5169μs856B/plugins/system/t4/src/t4/MVC/Router/T4.php:288Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tvlfg_modules` AS `m` LEFT JOIN `tvlfg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tvlfg_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,:preparedArray2)) 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`802μs18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id123μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 57.61ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1418μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `tvlfg_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)173μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration230μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'107μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field88μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'87μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • 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 `tvlfg_scheduler_tasks` AS `a` WHERE `a`.`state` = 1125μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?89μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?686μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy