Show Guide: 'Only Murders In The Building'

Synopsis:  From the minds of Steve Martin, Dan Fogelman and John Hoffman comes a comedic murder-mystery series for the ages. Only Murders In The Building follows three strangers (Steve Martin, Martin Short and Selena Gomez) who share an obsession with true crime and suddenly find themselves wrapped up in one.

In season four of Only Murders In The Building, Charles, Oliver & Mabel wrestle with the shocking events at the end of season three surrounding Charles’ stunt double & friend Sazz Pataki. Questioning whether Sazz or Charles was the intended victim, our trio’s investigation leads them all the way to Los Angeles where a Hollywood studio is readying a film about the Only Murders podcast. As our amateur sleuths race back to New York, they embark on an even more epic journey — traversing their building’s courtyard to delve into the twisted lives of the Arconia’s West Tower residents. (Courtesy Hulu, 2024)

The Cast:
Steve Martin as Charles-Haden Savage
Martin Short as Oliver Putnam
Selena Gomez as Mabel Mora
Amy Ryan as Jan Bellows
Aaron Dominguez as Oscar Torres
Cara Delevingne as Alice Banks

Productions Credits:
John Hoffman (EP)
Dan Fogelman (EP)

The Episodes:
Season One Episode Guide (Hulu)
When a grisly death occurs inside their exclusive Upper West Side apartment building, the trio suspects murder and employs their precise knowledge of true crime to investigate the truth. As they record a podcast of their own to document the case, the three unravel the complex secrets of the building which stretch back years. Perhaps even more explosive are the lies they tell one another. Soon, the endangered trio comes to realize a killer might be living amongst them as they race to decipher the mounting clues before it’s too late.
1-01 True Crime--08/31/2021
Upper West Side neighbors Charles, Oliver & Mabel bond over a shared love of true crime. When a fellow resident dies in their building, the trio determine to solve the mystery and record an accompanying podcast.
Written by: John Hoffman & Steve Martin
Directed by: Jamie Babbit

1-02 Who Is Tim Kono?--08/31/2021
The group begins researching the victim. Meanwhile, Mabel's secretive past starts to be unraveled.
Written by: Kirker Butler
Directed by: Jamie Babbit

1-03 How Well Do You Know Your Neighbors?--08/31/2021
Oliver employs his theater director skills to analyze the case. Charles & Mabel question an obsessive cat lover.
Written by: Ben Smith
Directed by: Gillian Robespierre

1-04 The Sting--09/07/2021
Believing the murderer might be a famous resident whom is difficult to access, the group seeks advice from a renowned podcasting host.
Written by: Kristin Newman
Directed by: Gillian Robespierre

1-05 Twist--09/14/2021
Mabel slips away on a solo mission tracking the victim's final days. Suspicious, Charles & Oliver follow her.
Written by: Thembi Banks
Directed by: Dan Scardino

1-06 To Protect And Serve--09/21/2021
Mabel brings her new friends (and an old one) to her childhood home to meet her mother. Meanwhile, Detective Williams starts to have her own doubts about the case as she prepares for motherhood.
Written by: Kim Rosenstock & Madeleine George
Directed by: Dan Scardino

1-07 The Boy from 6B--09/28/2021
With the investigation scratching at a web of old crimes originating inside the building, a mysterious young man turns the tables to spy on Charles, Oliver & Mabel.
Written by: Stephen Markley & Ben Philippe
Directed by: Cherien Dabis

1-08 Fan Fiction--10/05/2021
Hitting a dead end, the group calls for reinforcements in the form of their podcast's Superfans.
Written by: Matteo Borghese & Rob Turbovsky
Directed by: Cherien Dabis

1-09 Double Time--10/21/2021
With the residents growing upset at the building's negative publicity, the trio faces a revolt. Charles is visited by an old colleague who sheds light on his past.
Written by: John Hoffman & Kristin Newman
Directed by: Jamie Babbit

1-10 Open And Shut--10/19/2021
In the season finale, the trio races toward a resolution while their own lives are put in danger.
Written by: John Hoffman & Rachel Burger
Directed by: Jamie Babbit


Season Two Episode Guide (Hulu)
2-01 Persons Of Interest--06/28/2022
2-02 Framed--06/28/2022
2-03 The Last Day Of Bunny Folger--07/05/2022
2-04 Here's Looking At You--07/12/2022
2-05 The Tell--07/19/2022
2-06 Performance Review--07/26/2022
2-07 Flipping The Pieces--08/02/2022
2-08 Hello, Darkness--08/09/2022
2-09 Sparring Partners--08/16/2022
2-10 I Know Who Did It--08/23/2022


Season Three Episode Guide (Hulu)
Season three finds Charles, Oliver & Mabel (played by Steve Martin, Martin Short & Selena Gomez) investigating a murder behind the scenes of a Broadway show. Ben Glenroy (Paul Rudd) is a Hollywood action star whose Broadway debut is cut short by his untimely death. Aided by co-star Loretta Durkin (Meryl Streep), our trio embarks on their toughest case yet, all while director Oliver desperately attempts to put his show back together. Curtains up! 
3-01 The Show Must…08/08/2023
After Ben Glenroy’s collapse on stage, Charles, Oliver & Mabel piece together the show’s first days with a suspicious cast & crew to determine if foul play was involved. Spoiler alert…
Directed by: John Hoffman
Written by: John Hoffman and Sas Goldberg

3-02 The Beat Goes On--08/08/2023
Mabel, Oliver & Charles attend Ben’s lavish memorial full of fans and those with more dubious motives. As the actor’s sudden death is mourned, Oliver works to revive his shaky Broadway show.
Directed by: John Hoffman
Written by: Ben Smith and Joshua Allen Griffith
        
3-03 Grab Your Hankies--08/15/2023
Oliver races to bring new life to his show as Mabel’s investigation into the actual murder collides with a surprising ally. Charles bonds with the cast, and Loretta proves her voice is invaluable.
Directed by: Adam Shankman
Written by: Matteo Borghese and Rob Turbovsky

3-04 The White Room--08/22/2023
Charles’s stage fright reaches unimaginable heights, involving a break from reality and multiple baby dolls.  Mabel is confronted by a mysterious individual from her past with a pivotal proposal. 
Directed by: Adam Shankman
Written by: JJ Philbin

3-05 Ah, Love!--08/29/2023
Date night! New York proves itself both a jewel box and a fish tank of romance as Charles, Mabel & Oliver take their relationships to the next stage. And dating can reveal many hidden secrets, too...
Directed by: Chris Koch
Written by: Tess Morris and Noah Levine

3-06 Ghost Light--09/05/2023
All roads lead the trio back to the Goosebury Theater during a nerve-rattling thunderstorm. With Howard as their jittery guide, they track a legendary ghost who’s haunted the theater for generations. Boo.
Directed by: Chris Koch
Written by: Madeleine George

3-07  CoBro--09/12/2023
Charles finds an unexpected source for a major clue. A Broadway icon comes knocking at Oliver’s door. And Mabel forms an alternate trio to pursue a lead that sheds light on Ben’s bro and CoBro history. 
Directed by: Cherien Dabis
Written by: Ben Philippe and Jake Schnesel

3-08 Sitzprobe--09/19/2023
On the day of the show’s most critical rehearsal, the pressure mounts. A familiar official returns to upend the case, Loretta’s complex past threatens to upend all else and Charles must finally sing his number without losing his marbles.
Directed by: Cherien Dabis
Written by: Pete Swanson and Siena Streiber


Season Four Episode Guide (Hulu)
4-01

4-02

4-03

4-04

4-05

4-06

4-07

4-08 Lifeboat--10/15/2024
Charles, Oliver & Mabel combine forces with the film actors in an epic showdown against the Westies. You can't handle the truth.

9.212MBMemory Usage245msRequest 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" => 1746947044 "last" => 1746947044...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.41KB) (5.35ms)
  • afterInitialise (1.26MB) (114ms)
  • afterRoute (281.69KB) (9.08ms)
  • beforeRenderComponent com_content (38.3KB) (1.17ms)
  • Before Access::preloadComponents (all components) (34.7KB) (963μs)
  • After Access::preloadComponents (all components) (109.3KB) (1.13ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (19μs)
  • After Access::preloadPermissions (com_content) (2.93MB) (12ms)
  • Before Access::getAssetRules (id:3111 name:com_content.article.2282) (258.8KB) (177μs)
  • After Access::getAssetRules (id:3111 name:com_content.article.2282) (8.47KB) (187μs)
  • beforeRenderRawModule mod_related_items (Read More) (871.38KB) (47.39ms)
  • Before Access::getAssetRules (id:8 name:com_content) (77.93KB) (10.64ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (19μs)
  • afterRenderRawModule mod_related_items (Read More) (87.93KB) (7.42ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (7μs)
  • afterRenderModule mod_related_items (Read More) (3.2KB) (180μs)
  • afterRenderComponent com_content (42.94KB) (84μs)
  • afterDispatch (3.53KB) (208μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (18.07ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (454μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (158μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (36μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (103μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (3μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (77μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (64μs)
  • afterRenderRawModule mod_finder (Head Search) (66.73KB) (3.2ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (5μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (147μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (37μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (253μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (4μs)
  • afterRenderModule mod_custom (Lead Info) (4.88KB) (73μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (34μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (69μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (75μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (18μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (67μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (73μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (17μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (113μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (3μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (76μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (960μs)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.09ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (4μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (81μs)
  • afterRender (681.04KB) (8.39ms)
  • 1 x afterInitialise (1.26MB) (46.49%)
    113.88ms
    1 x beforeRenderRawModule mod_related_items (Read More) (871.38KB) (19.35%)
    47.39ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (7.38%)
    18.07ms
    1 x After Access::preloadPermissions (com_content) (2.93MB) (4.9%)
    12.00ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (77.93KB) (4.34%)
    10.64ms
    1 x afterRoute (281.69KB) (3.71%)
    9.08ms
    1 x afterRender (681.04KB) (3.42%)
    8.39ms
    1 x afterRenderRawModule mod_related_items (Read More) (87.93KB) (3.03%)
    7.42ms
    1 x afterLoad (528.41KB) (2.18%)
    5.35ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.73KB) (1.31%)
    3.20ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (0.85%)
    2.09ms
    1 x beforeRenderComponent com_content (38.3KB) (0.48%)
    1.17ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.46%)
    1.13ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.39%)
    963μs
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.39%)
    960μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.19%)
    454μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.1%)
    253μs
    1 x afterDispatch (3.53KB) (0.08%)
    208μs
    1 x After Access::getAssetRules (id:3111 name:com_content.article.2282) (8.47KB) (0.08%)
    187μs
    1 x afterRenderModule mod_related_items (Read More) (3.2KB) (0.07%)
    180μs
    1 x Before Access::getAssetRules (id:3111 name:com_content.article.2282) (258.8KB) (0.07%)
    177μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.06%)
    158μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.06%)
    147μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.05%)
    113μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.04%)
    103μs
    1 x afterRenderComponent com_content (42.94KB) (0.03%)
    84μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.03%)
    81μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.03%)
    77μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.03%)
    76μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.03%)
    75μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.03%)
    73μs
    1 x afterRenderModule mod_custom (Lead Info) (4.88KB) (0.03%)
    73μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (0.03%)
    69μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.03%)
    67μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.03%)
    64μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.02%)
    37μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.01%)
    36μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.01%)
    34μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    19μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    19μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    3μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    3μs
50 statements were executed, 3 of which were duplicates, 47 unique258ms452.51KB
  • SELECT @@SESSION.sql_mode;83μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?200μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1115μ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)31.8ms944BParams/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` = 1674μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`158μ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` = :guest223μ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`836μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'51.85ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC322μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='2282-show-guide-only-murders-in-the-building' AND published=1271μ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`611μ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`711μ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` = 1319μ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)711μ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` = 05.89ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.51ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2282'17.81ms48B/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)969μ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`875μ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)2.48ms5.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`733μ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 ASC513μ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 DESC542μs2.19KBParams/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`657μ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.id177μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'148μ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 ordering159μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.52ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid168μ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` = :muserid175μ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 ASC392μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'84μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5163μ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`1.12ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id131μ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 59.1ms1.77KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` IN (:preparedArray5,:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC854μs25.47KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_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 `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2) AND `t`.`access` IN (:preparedArray3,:preparedArray4)3.4ms5.31KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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`451μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`673μs5.22KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1672μ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)189μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration247μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'114μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field102μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'127μ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` = 1165μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?110μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?117ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy