Show Guide: 'The Irrational'

Synopsis: The Irrational follows world-renowned professor of behavioral science Alec Mercer (Jesse L. Martin) as he lends his unique expertise to high-stakes cases and mysteries. His insight and unconventional approach to understanding human behavior lead him to work alongside varying clients ranging from the FBI to everyday people caught in perplexing situations desperate for answers. With the help of his trusted team and social-science experiments, Alec solves crimes and uncovers the truth to answer intriguing, and irrational, questions. (Courtesy NBC, 2024)

The Cast:
Jesse L. Martin as Alec Mercer
Maahra Hill as Marisa Clark
Travina Springer as Kylie Mercer
Molly Kunz as Phoebe Duncan
Arash DeMaxi as Rizwan Asadi
Max Lloyd-Jones as Simon Wylton
Karen David as Rose Dinshaw
Brian King as Jace Richards

Production Credits:
Arika Lisanne Mittman, Mark Goffman, Sam Baum, David Frankel and Robert Wolfe executive produce. The show is produced by Universal Television, a division of Universal Studio Group.

The Episodes:
Season One Episode Guide (NBC)
1-01 Pilot--09/25/2023
Professor of behavioral science Alec Mercer is called upon to investigate the murder of a fashion influencer whose boyfriend, a decorated soldier and senator's son, has confessed to the crime; however, Mercer suspects there's more to the story.
Written by: Arika Lisanne Mittman
Directed by: David Frankel

1-02 Dead Woman Walking--10/02/2023
Professor Mercer is approached by his old friend CJ, a prominent investigative journalist who asks for help after she's poisoned with a rare and deadly nerve agent; with time running out, Mercer pieces together scant clues.
Written by: Arika Lisanne Mittman
Directed by: Jesse Warn

1-03 The Barnum Effect--10/09/2023
After a passenger plane crashes into the Potomac River, suspicions focus immediately on the pilot. Professor Mercer and the team are asked to investigate the pilot's personal motivations and piece together clues in the hopes of revealing the truth.
Written by: Mark Goffman
Directed by: John Terlesky

1-04 Zero Sum--10/16/2023
Alec and the team take on a kidnapping case at the request of a desperate father; their investigation is hampered by a complicated family dynamic that slowly reveals everyone's hidden motivations.
Written by: Robert Hewitt Wolfe
Directed by: Janice Cooke-Leonard

1-05 Lucky Charms--10/23/2023
Alec and the team head to Las Vegas to help Camille, a former colleague turned expert poker player who's been lured into danger; they must take some risks to solve a gambling mystery before Camille gets hurt; Marisa makes a significant discovery.
Written by: Lydia Teffera
Directed by: Amanda Tapping

1-06 Point And Shoot--10/30/2023
Alec and the team head to Las Vegas to help Camille, a former colleague turned expert poker player who's been lured into danger; they must take some risks to solve a gambling mystery before Camille gets hurt; Marisa makes a significant discovery.
Story by: Jordan Rosenberg and Kirk A. Moore
Teleplay by: Kirk A. Moore
Directed by: Ernest Dickerson

1-07 The Real Deal--11/06/2023
Alec's first date with Rose turns into a 24-hour excursion when they find themselves taking on an investigation involving a forged masterpiece. Marisa and Kylie attempt to revive their friendship, which has faltered since Alec and Marisa's divorce.
Written by: Mira Z. Barnum
Directed by: Jesse Warn

1-08 Scorched Earth--01/29/2024
Alec's first date with Rose turns into a 24-hour excursion when they find themselves taking on an investigation involving a forged masterpiece. Marisa and Kylie attempt to revive their friendship, which has faltered since Alec and Marisa's divorce.
Written by: Jordan Rosenberg
Directed by: Maja Vrvilo

1-09 Cheating Life--02/05/2024
After witnessing a hit and run during a friend's livestream, Alec and Kylie aim to prove it wasn't an accident. As Marisa and Jace continue their investigation into the church bombing, they turn their sights on a prominent senator.
Written by: Jordan Rosenberg and Mira Z. Barnum
Directed by: Carl Seaton

1-10 Bombshell--02/12/2024
Alec and his team come face to face with the man who was put away for the church bombing 20 years earlier. Marisa and Kylie work together to save Alec, Phoebe and Rizwan. Jace makes a critical break in the case that changes everything.
Written by: Mark Goffman and Robert Hewitt Wolfe
Directed by: Jesse Warn

1-11 Reciprocity--02/19/2024
Alec and his team come face to face with the man who was put away for the church bombing 20 years earlier. Marisa and Kylie work together to save Alec, Phoebe and Rizwan. Jace makes a critical break in the case that changes everything.
Written by: Arika Lisanne Mittman
Directed by: Ernest Dickerson


Season Two Episode Guide (NBC)
2-01 Collateral Damage--10/08/2024
When Rose goes missing, Alec quickly discovers this is no ordinary kidnapping. While Rose plays a dangerous game to stall for time, Alec takes matters into his own hands to find her.
Written by: Arika Lisanne Mittman
Directed by: John Terlesky

2-02 A Kick In The Teeth--10/15/2024
The FBI needs Alec and his team to help stop a serial killer terrorizing the suburbs; as the bodies pile up, Alec helps the police uncover what's really driving this murderer to his choice of victims.
Written by: Lydia Teffera
Directed by: Ernest Dickerson

2-03 Bad Blood--10/22/2024
When a rising star on Wall Street is killed during her hockey game, Alex must determine if it was an accident or murder; Alex and Rose find themselves on opposite sides of the case as they try to get to the heart of the victim's cutthroat world.
Written by: Mark Goffman/Robert Hewitt Wolfe/Jojo S. Wright
Directed by: Jeffrey W. Byrd

2-04 Formal Ties--10/29/2024
When a rising star on Wall Street is killed during her hockey game, Alex must determine if it was an accident or murder; Alex and Rose find themselves on opposite sides of the case as they try to get to the heart of the victim's cutthroat world.
Written by: Katie Wech
Directed by: Jesse Warn

2-05 Anatomy Of A Fall--11/12/2024
When a rising star on Wall Street is killed during her hockey game, Alex must determine if it was an accident or murder; Alex and Rose find themselves on opposite sides of the case as they try to get to the heart of the victim's cutthroat world.
Written by: Mira Z. Barnum
Directed by: Darnell Martin

2-06 The Wrong Side Of Maybe--11/26/2024
Alec and the team work to prevent a looming locomotive catastrophe; Phoebe, Simon and Rizwan struggle to adjust to new power dynamics.
Written by: Jordan Rosenberg
Directed by: Holly Dale

2-07 Stan By Me--12/03/2024
Alec enters the world of K-pop fandom when a superfan is murdered, and the only suspect is the pop star the fan idolizes; Alec and Rose dig beneath the surface to uncover what happened and, in the process, he uncovers more about her past.
Written by: Kirk A. Moore
Directed by: Sarah Wayne Callies

2-08 Lost Souls--01/07/2025
When an acclaimed tennis player goes missing in a remote forest, Alec is called to help find her and bring her to safety; however, a medical emergency threatens to sideline Alec, leaving Marisa and Rose to race against time and rescue the woman.

2-09 Another Man's Treasure--01/14/2025
Alec and Marisa investigate a museum heist and a curator and his son might hold the key; the case raises ethical questions about the controversial practice of buying and selling cultural artifacts, which brings old memories for Marisa.

2-10 Now You Don't--01/21/2025
Alec brings Rose on a date to a magic club he frequents where a friend is the headliner; the evening turns deadly when an audience volunteer is inexplicably killed onstage, and seemingly by magic.


9.148MBMemory Usage441msRequest 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" => 1746095103 "last" => 1746095103...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (20.68ms)
  • afterInitialise (1.26MB) (187ms)
  • afterRoute (281.67KB) (53.58ms)
  • beforeRenderComponent com_content (38.29KB) (1.45ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.22ms)
  • After Access::preloadComponents (all components) (109.3KB) (21.09ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (36μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (13.13ms)
  • Before Access::getAssetRules (id:4032 name:com_content.article.3198) (258.8KB) (242μs)
  • After Access::getAssetRules (id:4032 name:com_content.article.3198) (8.47KB) (293μs)
  • beforeRenderRawModule mod_related_items (Read More) (870.57KB) (64.79ms)
  • Before Access::getAssetRules (id:8 name:com_content) (77.38KB) (11.76ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (30μs)
  • afterRenderRawModule mod_related_items (Read More) (39.41KB) (6.34ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (17μs)
  • afterRenderModule mod_related_items (Read More) (3.01KB) (288μs)
  • afterRenderComponent com_content (42.63KB) (119μs)
  • afterDispatch (3.53KB) (365μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (30.22ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (769μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (230μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (46μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (151μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (100μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (81μs)
  • afterRenderRawModule mod_finder (Head Search) (66.78KB) (4.63ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (244μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (61μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (422μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (4.88KB) (114μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (53μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (110μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (138μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (28μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (109μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (121μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (30μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (171μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (117μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.49ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (3.45ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (112μs)
  • afterRender (681.13KB) (14.26ms)
  • 1 x afterInitialise (1.26MB) (42.47%)
    187.45ms
    1 x beforeRenderRawModule mod_related_items (Read More) (870.57KB) (14.68%)
    64.79ms
    1 x afterRoute (281.67KB) (12.14%)
    53.58ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (6.85%)
    30.22ms
    1 x After Access::preloadComponents (all components) (109.3KB) (4.78%)
    21.09ms
    1 x afterLoad (528.29KB) (4.69%)
    20.68ms
    1 x afterRender (681.13KB) (3.23%)
    14.26ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (2.98%)
    13.13ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (77.38KB) (2.66%)
    11.76ms
    1 x afterRenderRawModule mod_related_items (Read More) (39.41KB) (1.44%)
    6.34ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.78KB) (1.05%)
    4.63ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (0.78%)
    3.45ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.34%)
    1.49ms
    1 x beforeRenderComponent com_content (38.29KB) (0.33%)
    1.45ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.28%)
    1.22ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.17%)
    769μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.1%)
    422μs
    1 x afterDispatch (3.53KB) (0.08%)
    365μs
    1 x After Access::getAssetRules (id:4032 name:com_content.article.3198) (8.47KB) (0.07%)
    293μs
    1 x afterRenderModule mod_related_items (Read More) (3.01KB) (0.07%)
    288μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.06%)
    244μs
    1 x Before Access::getAssetRules (id:4032 name:com_content.article.3198) (258.8KB) (0.05%)
    242μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.05%)
    230μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.04%)
    171μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.03%)
    151μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.03%)
    138μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.03%)
    121μs
    1 x afterRenderComponent com_content (42.63KB) (0.03%)
    119μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.03%)
    117μs
    1 x afterRenderModule mod_custom (Lead Info) (4.88KB) (0.03%)
    114μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.03%)
    112μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (0.02%)
    110μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.02%)
    109μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.02%)
    100μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.02%)
    81μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.01%)
    61μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.01%)
    53μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.01%)
    46μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    36μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    28μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    17μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
49 statements were executed, 3 of which were duplicates, 46 unique258ms446.77KB
  • SELECT @@SESSION.sql_mode;3.11ms1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?3.26ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 14.14ms1.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)48.69ms944BParams/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` = 14.76ms2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`213μ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` = :guest291μ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`2.26ms3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'34.68ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.84ms2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='3198-show-guide-the-irrational' AND published=1468μ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`6.25ms20.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`11.79ms5.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` = 15.62ms1.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)16.91ms7.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.19ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.24ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '3198'24.73ms48B/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)718μ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`789μ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.4ms5.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`823μ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 ASC542μ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 DESC2.51ms2.41KBParams/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`736μ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.id199μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'178μ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 ordering197μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.44ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid202μ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` = :muserid241μ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 ASC460μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'121μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51100μ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.22ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id224μ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 58.81ms1.76KBParams/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) 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 ASC771μs24.8KBParams/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) AND `t`.`access` IN (:preparedArray2,:preparedArray3)2.4ms5.27KBParams/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`779μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1641μ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)232μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration550μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'165μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field155μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'141μ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` = 1192μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?249μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?53.3ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy