Show Guide: 'Night Court' (2023)

Synopsis: Court is back in session!  When the perpetually sunny judge Abby Stone (Melissa Rauch) takes the night shift in her father’s old courtroom, she presides over some of New York’s most unique and unusual cases – with an oddball cast of characters by her side. This includes former night court District Attorney Dan FieIding (John Larroquette), who now serves as the court’s public defender. (Courtesy NBC, 2023)

The Cast:
Melissa Rauch as Judge Abby Stone
John Larroquette as Dan Fielding
India de Beaufort as Olivia
Kapil Talwalkar as Neil
Lacretta as Donna "Gurgs" Gurganous

Production Credits:
From executive producer and writer Dan Rubin, Night Court is based on the original hit series that ran for nine seasons on NBC.  Melissa Rauch and Winston Rauch executive produce through their After January Productions. Mona Garcea oversees for After January Productions and John Larroquette also serves as an executive producer.

Night Court is produced by Rauch’s After January Productions in association with Warner Bros. Television and Universal Television, a division of Universal Studio Group.

The Episodes:
Season One Episode Guide (NBC)
1-01 Pilot--01/17/2023
Judge Abby Stone follows in the footsteps of her late father Judge Harry Stone as she takes over the night shift of a Manhattan arraignment court. When the court finds itself in need of a public defender, Abby sees potential in an unlikely candidate from her father's past: former night court prosecutor Dan Fielding.
Written by: Dan Rubin
Directed by: Pamela Fryman

1-02 The Nighthawks--01/17/2023
Abby pushes Dan to embrace his new role as public defender. Neil gets on board with Abby's quest to improve the courtroom and quickly realizes why trying is for the birds.
Written by: Dan Rubin
Directed by: Pamela Fryman

1-03 Just Tuesday--01/24/2023
After Abby makes a mistake in the courtroom, she decides to adopt an all-business approach to get things back on track, but her new style catches everyone off-guard.   
Written by: Mathew Harawitz
Directed by: Anthony Rich

1-04 Dan v. Dating--01/31/2023
With Abby's encouragement, Dan attempts to get venture back into the dating world, but reigniting his love life proves more complicated than he anticipated. Gurgs and Olivia search for a new office and find something they weren't expecting.  
Written by: Lon Zimmet
Directed by: Anthony Rich

1-05 The Apartment--02/07/2023
In desperate need of a new apartment, Abby turns to Gurgs and her unconventional real estate skills. Dan helps Olivia prepare for the biggest case of her career and a shot at redemption.
Written by: Leila Strachan
Directed by: Mark Cendrowski

1-06 Justice Buddies--02/14/2023
Gurgs's tween nephew and some of his fellow students visit the court for a school project. Things get out of hand for Abby, Dan and the night court team when the kids reveal their true motive is to grind the wheels of justice to a halt.
Written by: Azie Dungey
Directed by: Anthony Rich

1-07 Train Court--02/21/2023
When a train delay causes issues, Abby sees an opportunity to serve underground justice. Gurgs tries to stall the proceedings so Abby can meet her two favorite celebrities (Johnny Weir and Tara Lipinski), but Dan has dinner reservations he won't give up.  
Written by: Lon Zimmet & Julianne Turkel
Directed by: Leonard R. Garner, Jr.

1-08 Blood Moon Binga--02/28/2023
A blood moon brings out some of the weirdest cases New York City has to offer along with a surprise visitor: Abby's mom, who is carrying some long-kept secrets. Gurgs suspects Dan knows more than he's letting on, while Olivia and Neil stumble on the truth.
Written by: Rebecca Delgado SmithJessica Elaina Eason
Directed by: Pamela Fryman

1-09 Two Peas On A Pod--03/07/2023
Abby tries to get the court featured on a popular podcast, but the host only has eyes for Dan, who soon learns that being the center of attention can have its downsides.
Written by: Mathew Harawitz & Lon Zimmet
Directed by: Kelly Park

1-10 Marathon-Thon-Thon-Thon-Thon--03/14/2023
When Abby's fiancé, Rand, learns she's struggling to connect with Olivia, he encourages Abby to embrace a side of herself she rarely shows. Dan and Gurgs team up to save his favorite thing in the courthouse: a bench.
Teleplay by: Rebecca Delgado Smith & Jessica Elaina Eason
Directed by: Shawn Parikh

1-11 Ready Or Knot--03/28/2023
When the court is overrun with cases from a wedding expo gone awry, the team looks to help Abby plan her wedding. A wedding planner shows Dan the finer things in life. Olivia and Gurgs wrestle over who will serve as maid of honor.

1-12 Da Club--04/04/2023
When Abby lands a meeting with the New York City district attorney to talk about her ideas for reform, Dan invites himself along to share his expertise in the art of "backroom dealing." Gurgs teaches Neil a lesson in confidence.
Written by: Bennett Webber
Directed by: Lynda Tarryk

1-13 Past Apps--04/11/2023
A tech entrepreneur in court has Dan and the gang seeing a chance to get in on the ground floor of the next billion-dollar idea. When Abby stumbles on the young CEO's history of fraud in a sealed file, can she warn her friends without breaking the law?
Written by: Brian Kratz & Josh Corey
Directed by: Betsy Thomas

1-14 When Abby Met Gabby--04/25/2023
Neil's crush on Abby is making things uncomfortable for everyone, but Abby sees a way out when she meets an unrequited love from his past who just happens to be newly available. Meanwhile, Gurgs fails to protect Dan from an unruly member of the gallery and vows never to let him down again.
Written by: Azie Dungey & Stacy Adelman
Directed by: Joanna Kerns

1-15 The Honorable Dan Fielding (Part One)--05/02/2023
Dan ponders his future after being offered the opportunity of a lifetime. Abby can't find time for her fiancé, Rand, and her heart lands her in some trouble. Olivia makes it a personal mission to help Gurgs pass the bailiff supervisor exam.
Written by: Leila Strachan & Marc Carusiello
Directed by: Pamela Fryman

1-16 The Honorable Dan Fielding (Part Two)--05/09/2023
Abby is on trial, and she and Dan are fighting for her professional life. D.A. Jeff Dewitt returns and forces Olivia to choose sides. Abby and Rand find their relationship at a crossroads.
Written by: Caroline Fox & Bennett Webber
Directed by: Joanna Kerns




9.051MBMemory Usage169msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.32
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" => 1746071370 "last" => 1746071370...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (9.11ms)
  • afterInitialise (1.26MB) (54.85ms)
  • afterRoute (281.67KB) (8.19ms)
  • beforeRenderComponent com_content (38.25KB) (1.04ms)
  • Before Access::preloadComponents (all components) (34.69KB) (945μs)
  • After Access::preloadComponents (all components) (109.3KB) (922μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (16μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (10.17ms)
  • Before Access::getAssetRules (id:1818 name:com_content.article.995) (258.8KB) (177μs)
  • After Access::getAssetRules (id:1818 name:com_content.article.995) (8.47KB) (226μs)
  • beforeRenderRawModule mod_related_items (Read More) (860.26KB) (33.54ms)
  • afterRenderRawModule mod_related_items (Read More) (38.48KB) (7.31ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (10μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (216μs)
  • afterRenderComponent com_content (49.04KB) (69μs)
  • afterDispatch (2.28KB) (226μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (21.76ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (589μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (222μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (40μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (116μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (95μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (75μs)
  • afterRenderRawModule mod_finder (Head Search) (69.02KB) (3.53ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (7μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (182μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (41μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (319μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (4μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (84μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (38μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (79μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (88μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (20μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (78μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (3μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (86μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (21μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (134μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (4μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (93μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.2ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.87KB) (2.51ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (5μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (99μs)
  • afterRender (673.13KB) (9.59ms)
  • 1 x afterInitialise (1.26MB) (32.41%)
    54.85ms
    1 x beforeRenderRawModule mod_related_items (Read More) (860.26KB) (19.82%)
    33.54ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (12.86%)
    21.76ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (6.01%)
    10.17ms
    1 x afterRender (673.13KB) (5.66%)
    9.59ms
    1 x afterLoad (528.29KB) (5.39%)
    9.11ms
    1 x afterRoute (281.67KB) (4.84%)
    8.19ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.48KB) (4.32%)
    7.31ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.02KB) (2.09%)
    3.53ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.87KB) (1.48%)
    2.51ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.71%)
    1.20ms
    1 x beforeRenderComponent com_content (38.25KB) (0.62%)
    1.04ms
    1 x Before Access::preloadComponents (all components) (34.69KB) (0.56%)
    945μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.54%)
    922μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.35%)
    589μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.19%)
    319μs
    1 x afterDispatch (2.28KB) (0.13%)
    226μs
    1 x After Access::getAssetRules (id:1818 name:com_content.article.995) (8.47KB) (0.13%)
    226μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.13%)
    222μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.13%)
    216μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.11%)
    182μs
    1 x Before Access::getAssetRules (id:1818 name:com_content.article.995) (258.8KB) (0.1%)
    177μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.08%)
    134μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.07%)
    116μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.06%)
    99μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    95μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.05%)
    93μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.05%)
    88μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.05%)
    86μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.05%)
    84μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.05%)
    79μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.05%)
    78μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    75μs
    1 x afterRenderComponent com_content (49.04KB) (0.04%)
    69μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.02%)
    41μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    40μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.02%)
    38μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    20μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    3μs
46 statements were executed, 3 of which were duplicates, 43 unique56.46ms411.4KB
  • SELECT @@SESSION.sql_mode;103μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?128μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 189μ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)23.95ms944BParams/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` = 1470μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`114μ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` = :guest205μ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`687μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'381μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC139μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='995-show-guide-night-court-2023' AND published=1168μ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`519μ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`620μ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` = 1202μ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)621μ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` = 04.56ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.7ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '995'5.32ms48B/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)681μ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`732μ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.57ms5.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`504μ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 ASC378μ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 DESC1.36ms2.28KBParams/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`520μ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.id121μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'136μ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 ordering148μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.03ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid112μ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` = :muserid161μ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 ASC331μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'76μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5171μ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`726μ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 55.59ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1419μ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)147μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration229μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'108μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field90μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'98μ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` = 1124μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?103μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?798μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy