Show Guide: 'Celebrity IOU'

Synopsis: In the heartwarming one-hour episodes, Hollywood A-listers will put into action their deep thanks for special friends and mentors by surprising them with stunning home renovations alongside HGTV superstars and series’ executive producers Drew and Jonathan Scott. The celebrities’ personal stories of gratitude will inspire them to demo through walls and floors, make customized design decisions and ultimately dream big to deliver spectacular home overhauls for the extraordinary people in their lives. (Courtesy HGTV, 2022)

The Cast:

Production Credits:
Celebrity IOU is produced by Scott Brothers Entertainment. 

The Episodes:
Season One Episode Guide (HGTV)
1-01 Brad Pitt's Gifting A Backyard Pad
Brad Pitt recruits Drew and Jonathan Scott to help him surprise his friend and makeup artist of 30 years by renovating her detached garage. They turn her 400-square-foot unit into a showstopping guest suite, makeup station and storage area.

1-02 Melissa McCarthy's Hero Home Makeover--04/20/2020
Melissa and her cousin Jenna will roll up their sleeves to surprise her aunt Connie and uncle Jim, who were Chicago police officers for 30 years. The home’s overhaul will result in a stylish, comfortable and functional main living area perfect for Jim, who was critically injured on the job and has difficulty walking. 

1-03 Viola Davis Delivers A Dream Home--04/27/2020
Viola will surprise Michelle, her best friend of 30 years, with a dream transformation for her Minneapolis home. Michelle, who was Viola’s roommate during their years at The Julliard School, is a mom and cancer survivor who Viola describes as "someone who puts the needs of others ahead of her own.” Viola, Drew and Jonathan will give Michelle a stunning modern kitchen, an open floor plan perfect for entertaining, and a Zen room where she can relax and rejuvenate.

1-04 Michael Buble's Shocking Surprise!--05/04/2020
Michael Bublé will execute a life-changing home renovation for his late grandpa’s former caretaker, Minette. Minette not only cared for Michael’s grandfather, Demetrio—aka “Mitch” as he was fondly called by family and friends—for many years, but she remains a special part of the family. She also supports her own family in the Philippines with her income. Now, with help from the network’s immensely popular twin brothers Drew and Jonathan Scott, Michael will honor the last wish of his grandpa—who also was his best friend and an inspiration behind his music career—by giving Demetrio’s former home to Minette to call her own. Michael spent a great deal of time during his childhood at his grandparents’ home. And, before he hands over the keys to the house, Michael will work with Drew and Jonathan to overhaul the 1970s home into a bright, modern showplace that features a high-end kitchen with a waterfall island and a custom fireplace hearth in the living room.

1-05 Rainn Wilson's Surprise Outdoor Oasis--05/11/2020
Rainn says he credits his son's former nanny Leslie with being an integral teacher and friend to his son and a blessing to his entire family. Leslie now has three children of her own and the two families are still close. On demo day, Rainn will stun Drew and Jonathan when he arrives both shirtless and wielding a two-sided axe and other medieval weapons—a nod to his character Dwight Schrute from The Office. He will work with HGTV’s famous twins to completely update Leslie’s home, including the addition of an open floor plan with a stunning updated kitchen, collapsible glass doors that open to a large deck and a custom kids’ playhouse.

1-06 A Mom Renner-vation!--05/18/2020
Jeremy Renner is moving his mom to Los Angeles to be closer to her family. He calls on Drew and Jonathan Scott to transform her dated condo into a modern-meets-cozy oasis where she can entertain the family and host sleepovers with her grandchildren.


Season Two Episode Guide (HGTV)
2-01 Zoey Deschanel's Stunner For Her BFF--12/14/2020
Actress Zooey Deschanel joins Jonathan and Drew Scott to surprise her best friend, Sarah, with a life-changing renovation. The family feels cramped after the arrival of their second baby, so Zooey and the Brothers give them a functional open concept.

2-02 Allison Janney Gifts A Showstopper--12/21/2020
Actress Allison Janney teams up with Jonathan and Drew Scott to give back to her assistant and close friend of 20 years, Ilana. Allison and the Brothers flip Ilana's kitchen and dining room to create a stylish and functional space to cook and entertain.

2-03 Justin Hartley's Backyard Bombshell--12/28/2020
Actor Justin Hartley wants to give back to his buddy, Mat, who he credits for being the rock that saved him in rough times. Justin teams up with Jonathan and Drew Scott to transform Mat's dated backyard into a stunning outdoor oasis for his entire family.

2-04 Rainn Wilson Surprises His Nanny--01/04/2021
Actor Rainn Wilson surprises his son's nanny, Leslie, with a home makeover. After wielding Viking weapons for demolition, Rainn works with Drew and Jonathan Scott to completely update her home, including adding a new kitchen, deck and more.


Season Three Episode Guide (HGTV)
3-01 Kris Jenner's Backyard Retreat Surprise--06/21/2021
Kris Jenner and daughters Kim Kardashian West and Kendall Jenner want to surprise a family friend looking to start over. Jonathan and Drew look back as they share what it was like to help Kris, Kim and Kendall transform her backyard into a stunning oasis.

3-02 Leeann Rimes' Lifesaving Thank You--06/28/2021

3-03 Kevin Hart's Heartfelt Thanks--07/05/2021
After helping him through a critical injury, Kevin Hart wants to thank his trainer and friend, Boss, by transforming his backhouse into a sleek man cave. Jonathan and Drew look back as they reveal what went into creating Boss' stylish space.

3-04 Gwyneth Paltrow's Forever Home Update--07/12/2021
Gwyneth Paltrow says her assistant, Kevin, is more like a brother than a colleague, and she wants to transform his dated condo into a stylish forever home. Jonathan and Drew look back at how they turned an impractical layout into an entertainer's dream.

3-05 Darren Criss Makes Over His Manager's Garage--07/19/2021
Darren Criss credits his manager and friend, Ricky, for helping him get to where he is today. Jonathan and Drew look back as they reveal what it was really like helping Darren turn a detached garage into a five-star flex space.

3-06 Josh Groban's Life-Changing Gift To His Bandmate--07/26/2021
Josh Groban wants to give his bandmate and friend, Mark, a well-deserved renovation. Jonathan and Drew look back to reveal what it was really like helping Josh surprise his friend with a high-tech recording studio renovation.


Season Four Episode Guide (HGTV)

Rebel Wilson--2020
will roll up her sleeves and hop on an excavator to help the network’s immensely popular twin brothers Drew and Jonathan Scott transform a barren backyard into a beautiful oasis. Newlyweds Nicole and Josh have no extra cash to renovate the exterior of their new Southern California home, so Rebel, Drew and Jonathan will give them the outdoor space of their dreams.


Cindy Crawford--2022
Cindy Crawford will show appreciation to Sarah, her best friend and personal trainer of more than 15 years, by gifting her a major renovation of her family’s first home featuring a luxurious kitchen, living area and guest bathroom. The season will promise additional breathtaking transformations as the celebrities roll up their sleeves with Drew and Jonathan, including a modern southwestern-style main floor overhaul, an underused garage turned multi-function personal retreat and guest suite and a dream backyard that boasts a professional-grade outdoor gym.


--Mandy Moore--08/12/2024
Mandy Moore will take on a new leading role as a builder and designer when she gifts a showstopping backyard makeover to Celina, her 15-year friend who she says is like family and like a surrogate mother to her children. Mandy, Drew and Jonathan will tour the outdated space where Celina loves to entertain and discover an unsafe covered patio. To give her friend an upgraded oasis, Mandy will roll up her sleeves with the Brothers and push through weeks of unexpected rain to jackhammer cracked concrete, tear off old shingles and man a power saw. The emotional final reveal will showcase a state-of-the-art outdoor kitchen, a luxe lounge area featuring new seating and a fire table, and an electronic metal pergola that provides both sun and shade.  


--Rob Lowe--02/03/2025
Rob Lowe will knock on Carol’s door with a mariachi band and the Scott Brothers in tow to surprise his dear friend and assistant of 27 years who he says is an integral part of his family. Although Carol has made some improvements to her home, Rob, Drew and Jonathan will work together to give her the stylish and functional kitchen and living areas she’s always wanted. When Jonathan unexpectedly falls ill, the popular actor will step out of his comfort zone and go full throttle with Drew to lay new flooring, hang stunning white oak cabinets and install high-end porcelain countertops. During the emotional reveal, Rob will show Carol the many custom features in her new spaces, including a pass-through window to the backyard and a built-in banquette.  

9.069MBMemory Usage173msRequest 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" => 1746083407 "last" => 1746083407...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (8.03ms)
  • afterInitialise (1.26MB) (27.78ms)
  • afterRoute (281.67KB) (8.81ms)
  • beforeRenderComponent com_content (38.72KB) (1.15ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.14ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.22ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (17μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (12.47ms)
  • Before Access::getAssetRules (id:4204 name:com_content.article.3370) (258.8KB) (225μs)
  • After Access::getAssetRules (id:4204 name:com_content.article.3370) (8.47KB) (254μs)
  • beforeRenderRawModule mod_related_items (Read More) (870.12KB) (45.07ms)
  • afterRenderRawModule mod_related_items (Read More) (38.48KB) (10ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (9μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (229μs)
  • afterRenderComponent com_content (41.04KB) (64μs)
  • afterDispatch (2.28KB) (284μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (28.76ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (743μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (237μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (49μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (139μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (111μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (100μs)
  • afterRenderRawModule mod_finder (Head Search) (69.38KB) (4.22ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (257μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (69μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (471μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (7μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (117μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (52μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (112μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (130μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (28μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (108μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (124μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (30μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (203μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (122μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.61ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (3.62ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (8μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (129μs)
  • afterRender (681.13KB) (13.99ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (870.12KB) (25.98%)
    45.07ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (16.58%)
    28.76ms
    1 x afterInitialise (1.26MB) (16.02%)
    27.78ms
    1 x afterRender (681.13KB) (8.07%)
    13.99ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (7.19%)
    12.47ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.48KB) (5.77%)
    10.00ms
    1 x afterRoute (281.67KB) (5.08%)
    8.81ms
    1 x afterLoad (528.29KB) (4.63%)
    8.03ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.38KB) (2.43%)
    4.22ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.09%)
    3.62ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.93%)
    1.61ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.71%)
    1.22ms
    1 x beforeRenderComponent com_content (38.72KB) (0.66%)
    1.15ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.66%)
    1.14ms
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.43%)
    743μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.27%)
    471μs
    1 x afterDispatch (2.28KB) (0.16%)
    284μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.15%)
    257μs
    1 x After Access::getAssetRules (id:4204 name:com_content.article.3370) (8.47KB) (0.15%)
    254μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.14%)
    237μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.13%)
    229μs
    1 x Before Access::getAssetRules (id:4204 name:com_content.article.3370) (258.8KB) (0.13%)
    225μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.12%)
    203μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    139μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.07%)
    130μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.07%)
    129μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.07%)
    124μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.07%)
    122μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.07%)
    117μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.06%)
    112μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    111μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    108μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.06%)
    100μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.04%)
    69μs
    1 x afterRenderComponent com_content (41.04KB) (0.04%)
    64μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    52μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    49μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    9μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0.01%)
    9μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
46 statements were executed, 3 of which were duplicates, 43 unique37.32ms411.9KB
  • SELECT @@SESSION.sql_mode;103μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?142μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 181μ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)471μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1288μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`149μ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` = :guest211μ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`769μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'430μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC164μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='3370-show-guide-celebrity-iou' AND published=1170μ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`574μ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`695μ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` = 1238μ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)877μ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.37ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.51ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '3370'2.1ms48B/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)666μ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`688μ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.91ms5.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`684μ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 ASC386μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC1.8ms2.78KBParams/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`592μ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.id138μ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 ordering195μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.41ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid294μ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` = :muserid217μ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 ASC454μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'113μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5185μ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.04ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id145μ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.81ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1430μ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)151μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration268μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'150μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field327μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'113μ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` = 1150μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?137μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?463μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy