Show Guide: 'Jack & Bobby'

Synopsis: What if you could watch the next great American president grow up? That compelling question propels a powerful drama from master storytellers Greg Berlanti, Mickey Liddell and Emmy Award winner Thomas Schlamme.

Jack and Bobby McCallister are two bright young brothers growing up in Hart, Missouri, under the watchful eye of their eccentric single mother Grace, a college professor whose strong personality helps shape both of these young men's lives and secure one a place in the history books - as President of the United States. Grace and Jack's temperamental mother/son relationship takes a dangerous toll on Bobby as he gets caught in their rival forces, prompting a major change in the McCallister household. The arrival of a new college president, Peter Benedict, and his daughter, Courtney, makes an impression on the McCallister boys. In the year 2049, a documentary about the life of President McCallister examines the photograph that would come to define his presidency. (Courtesy The WB, 2024)

The Cast:

Production Credits:

The Episodes:
Season One Episode Guide (The WB)
1-01 Pilot--09/17/2004
In flash-forwards to the year 2049, White House staffers and the First Lady are interviewed, giving a midcentury perspective on the man who beat the odds and became one of the greatest leaders of his time.

1-02 Better Days--0/18/2004
Jack angrily explodes after catching his mother, Grace, smoking pot again and gives her an ultimatum. However, after a particularly trying day, Grace seeks refuge in her old habit and is unprepared for the price she must pay.

2-03 The Kindness Of Strangers--09/25/2004
Bobby joins the "challenge program" at school and learns a powerful lesson. Meanwhile, Grace is startled by news that Bobby's teacher gives her regarding Jack.

1-04 A Man Of Faith--10/02/2004
Grace is accused by Hebba (Lina Patel), a female Arab-American student, of letting her individual beliefs about religion influence her lectures.

1-05 The First Lady--10/09/2004
The future reveals a dark secret about the First Lady. In the present, Jack offers to escort a depressed Courtney to her father's work fund-raiser--leading to an unexpected confession and kiss.

1-06 An Innocent Man--10/16/2004
Grace is stunned after Peter informs her that her colleague and good friend has been accused of sexually harassing a student. Grace immediately defends her co-worker but must rethink her loyalty when new evidence arises.

1-07 Valentino--10/26/2004
Bobby's relationship with Dex (recurring guest star Jeanette Brox) continues to grow until Grace walks in on them kissing. After failing to convince Bobby to end his relationship with Dex, Grace and Jack take matters into their own hands.

1-08 Election Night--11/02/2004
Heartbroken after his relationship with Dex (recurring guest star Jeanette Brox) ends, Bobby decides to retaliate against Jack when he learns his brother is responsible for their breakup.

1-09 Chess Lessons--11/09/2004
Grace promises to be on her best behavior when she and Jack go to Missy's (recurring guest star Keri Lynn Pratt) house for dinner but loses her temper after Missy's father, Reverend Belknap (recurring guest star Ed Begley Jr.), attacks her ideals.

1-10 Lost Boys--11/16/2004
After the suicide of a friend, Jack is haunted by the thought that he should have done more to help. Meanwhile, Grace's warm, intelligent, gay younger brother, Jimmy (recurring guest star Tom Cavenaugh), makes a surprise visit for Thanksgiving.

1-11 Today I Am A Man
Jack is mortified after Grace catches him buying condoms in preparation for his big night with Missy (recurring guest star Keri Lynn Pratt).

1-12 Running Scared--01/25/2005
Jack tries to resume a sense of normalcy after a brutal attack but finds that the injury may keep him from returning to his old life. Grace is blackmailed by a student who caught her leaving Tom's (recurring guest star Bradley Cooper) room.

1-13 A New Frontier--02/01/2005
Bobby becomes suspicious of Grace's relationship with Tom (recurring guest star Bradley Cooper) after Tom coincidentally shows up during a camping trip.

1-14 Into The Woods--02/08/2005
Jack catches Grace and Tom (recurring guest star Bradley Cooper) in a compromising situation and tells Grace he disapproves of her romance.

1-15 Time Out Of Life--02/15/2005
Grace and Tom's (recurring guest star Bradley Cooper) relationship is exposed when a fellow professor catches them kissing in Grace's office.

1-16 And Justice For All--02/22/2005
Peter is forced to take action after learning about the relationship between Grace and Tom (recurring guest star Bradley Cooper). Meanwhile, Bobby and Warren decide to make some cash by doing yard work in their neighborhood.

1-17 Querida Grace--03/01/2005
Jack and Katie's (recurring guest star Kate Mara) relationship progresses, while Courtney's comes to a screeching halt after Jack discovers Nate (recurring guest star Mike Erwin) is cheating on her with another girl.

1-18 Friends With Benefits--04/12/2005
Jack finds out that Bobby has secretly decided to try out for the track team, and Jack instantly shows his disapproval. Later, Jack realizes that his relationship with Katie (recurring guest star Kate Mara) isn't what he thought it was.

1-19 Child Of God--04/19/2005
Missy (recurring guest star Keri Lynn Pratt) reveals a secret to Jack that could change their lives forever.

1-20 Under The Influence--04/26/2005
Jack, Courtney, Marcus, Missy (recurring guest star Keri Lynn Pratt) and Randy (recurring guest star Cam Gigandet) leave a boring school dance and drive to an after-hours party, but a deadly car accident prevents them from making it to their destination.

1-21 Stand By Me--05/03/2005
To protect Marcus, Jack tells the police that he was driving the car the night Missy died. The guilt becomes too much for Marcus, and he confesses to his dad, who immediately calls Grace.

1-22 Legacy--05/10/2005
In the season finale, Jack and Bobby discover that Grace plans to visit their father, Juan (Lou Diamond Phillips), in a Texas prison.

 

8.645MBMemory Usage221msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.31
Identityguest
Response200
Templateja_blockk
Database
Server
mysql
Version
8.0.39-cll-lve
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743481628 "last" => 1743481628...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (8.27ms)
  • afterInitialise (1.26MB) (30.19ms)
  • afterRoute (281.64KB) (9.95ms)
  • beforeRenderComponent com_content (38.25KB) (1.24ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.21ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.05ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (41μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (11.51ms)
  • Before Access::getAssetRules (id:2739 name:com_content.article.1910) (130.8KB) (287μs)
  • After Access::getAssetRules (id:2739 name:com_content.article.1910) (8.47KB) (30.59ms)
  • beforeRenderRawModule mod_related_items (Read More) (859.17KB) (35.35ms)
  • afterRenderRawModule mod_related_items (Read More) (38.48KB) (10.13ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (18μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (326μs)
  • afterRenderComponent com_content (49.04KB) (103μs)
  • afterDispatch (2.28KB) (374μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (59.11ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (638μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (205μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (41μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (119μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (92μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (82μs)
  • afterRenderRawModule mod_finder (Head Search) (69.34KB) (3.67ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (264μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (44μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (368μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (84μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (40μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (82μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (90μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (21μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (78μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (86μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (22μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (133μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (4μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (87μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.21ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.81ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (5μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (94μs)
  • afterRender (673.13KB) (9.89ms)
  • 1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (26.74%)
    59.11ms
    1 x beforeRenderRawModule mod_related_items (Read More) (859.17KB) (15.99%)
    35.35ms
    1 x After Access::getAssetRules (id:2739 name:com_content.article.1910) (8.47KB) (13.84%)
    30.59ms
    1 x afterInitialise (1.26MB) (13.65%)
    30.19ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (5.21%)
    11.51ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.48KB) (4.58%)
    10.13ms
    1 x afterRoute (281.64KB) (4.5%)
    9.95ms
    1 x afterRender (673.13KB) (4.47%)
    9.89ms
    1 x afterLoad (528.29KB) (3.74%)
    8.27ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.34KB) (1.66%)
    3.67ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (1.27%)
    2.81ms
    1 x beforeRenderComponent com_content (38.25KB) (0.56%)
    1.24ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.55%)
    1.21ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.55%)
    1.21ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.47%)
    1.05ms
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.29%)
    638μs
    1 x afterDispatch (2.28KB) (0.17%)
    374μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.17%)
    368μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.15%)
    326μs
    1 x Before Access::getAssetRules (id:2739 name:com_content.article.1910) (130.8KB) (0.13%)
    287μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.12%)
    264μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.09%)
    205μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.06%)
    133μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.05%)
    119μs
    1 x afterRenderComponent com_content (49.04KB) (0.05%)
    103μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.04%)
    94μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.04%)
    92μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.04%)
    90μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.04%)
    87μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.04%)
    86μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.04%)
    84μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    82μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.04%)
    82μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.04%)
    78μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.02%)
    44μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.02%)
    41μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    41μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.02%)
    40μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    22μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    21μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    18μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    4μs
46 statements were executed, 3 of which were duplicates, 43 unique31.18ms407.4KB
  • SELECT @@SESSION.sql_mode;95μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?89μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 171μ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)1.98ms944BParams/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` = 1291μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`90μ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` = :guest154μ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`554μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'389μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC352μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='1910-show-guide-jack-bobby' AND published=1188μ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`550μ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`495μ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` = 1176μ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)634μ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.99ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.63ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1910'401μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `tvlfg_content` AS `a` INNER JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `tvlfg_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)438μ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`546μ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.75ms5.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`520μ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 ASC395μ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 DESC477μs2.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`621μ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.id130μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'132μ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 ordering157μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.14ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid134μ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 ASC365μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'85μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5156μ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.23ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id128μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 57.7ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1468μ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)171μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration218μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'140μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field103μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'97μ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` = 1134μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?109μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?453μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy