Show Guide: 'Rock The Block'

Synopsis: The fresh seven episodes will raise the stakes like never before when two seasoned veteran teams come back to the block to challenge two rookie teams hungry for a win. Popular carpenter, craftsman, design expert and series’ host Ty Pennington (Battle on the Beach) will charge the HGTV powerhouse duos to face-off in an epic renovation battle just outside Salt Lake City, Utah. Each team will have just six weeks and a budget of $250,000 to renovate identical modern properties that boast breathtaking mountain views, soaring interior spaces and the largest backyards in series’ history, transforming them with their signature vision and personalized design style. The team who clinches the highest appraised value for their home will claim coveted Rock the Block bragging rights and a street named in their honor.

Former competitors and judges returning to the block on the veteran teams will include star designer Alison Victoria (Sin City Rehab) with past Rock the Block champion and high-end designer Michel Smith Boyd (Luxe for Less) as well as home restoration dynamo Jonathan Knight (Farmhouse Fixer) and his New Kids on the Block bandmate and brother Jordan Knight (Farmhouse Fixer: Camp Revamp). Competing on the series for the first time, the rookie teams will feature married home reno pros Chelsea and Cole DeBoer (Down Home Fab) and flipping, renovation and real estate experts Kamohai and Tristyn Kalama (Renovation Aloha).

Throughout the season, HGTV stars will continue the blind judging, including former Rock the Block contender Mina Starsiak Hawk (Good Bones) and previous Rock the Block winner Jasmine Roth (Help! I Wrecked My House) who will review the appeal of additional first-floor areas, including the entry, mudroom, powder bath and den. Next up will be the main suite judging by married interior designers Ray and Eilyn Jimenez (Divided By Design), followed by the four teams evaluating their competitors’ second-floor bonus spaces such as a playroom, gaming room, office and wellness retreat. Later in the season, designer Kim Myles (Battle on the Mountain) will visit the multi-function lower levels, with show-stopping additions like a pickleball court, cold plunge and sauna, theater and wine room. Dynamic twin sisters, real estate and design experts, and last season’s Rock the Block champions Lyndsay Lamb and Leslie Davis (Unsellable Houses) will size up the decks and large backyards, and, finally, Property Brothers star and home renovation expert Jonathan Scott (Celebrity IOU) will survey the completed homes, including the newly revealed exteriors, guest rooms and balconies, before joining Ty to announce the winning team.

The winner of Rock the Block also will have a donation made on their behalf to No Kid Hungry, which can help provide 100,000 meals* to kids living with hunger. Since Season 1, funds raised by Rock the Block help provide over 500,000 meals* to kids.

The homes are built by Hamlet Homes based in Utah. (Courtesy HGTV, 2025)

The Cast:

Production Credits:
Rock the Block is produced by Big Table Media.

The Episodes:
Season One Episode Guide (HGTV)
1-01 Master Suite Masters--10/21/2019
Drew Scott kicks off the competition by assigning master suites to Leanne Ford, Jasmine Roth, Mina Starsiak Hawk and Alison Victoria. Some keep floor plans and fixtures to manage costs while others go high-end.

1-02 The Kitchens--10/28/2019
The competition continues as Alison, Jasmine, Leanne and Mina add their signature styles to the "moneymaker" of the home: the kitchen. Drew sends a special guest with a surprise delivery that throws a wrench in their plans.

1-03 The Great Room War--11/04/2019
The designers tackle their great rooms and outdoor living spaces by tearing down walls and adding fireplaces and pergolas to increase the homes' value. Later, Tiffany Brooks meets them at the Rose Bowl Flea Market.

1-04 The Decision--11/11/2019
The designers reach the final week and finish the remaining spaces. Drew and the appraisers inspect each home, and the designer with the biggest increased value earns bragging rights and a street named in her honor.


Season Two Episode Guide (HGTV)
2-01 Rock The Kitchens--03/08/2021
Each team tries to add the most value to their respective kitchens and dining rooms; Chopped's Ted Allen tests the teams' mettle with a design twist, while HGTV's Tarek El Moussa and Heather Rae Young judge.

2-02 Rock The Living Rooms--03/15/2021
The competition continues in week two as the teams tackle the first-floor living spaces.

2-03 Rock The Main Bedrooms--03/22/2021
The teams get down and dirty when they head upstairs to renovate the main bedroom and bath; Egypt Sherrod and Mike Jackson come to blind judge.

2-04 Rock The Basements--04/02/2021
Designing 1,400 square feet of unfinished space; two teams make big, expensive moves; a heavy metal band stops by for a Design Challenge.

2-05 Rock The Exteriors--04/05/2021
The teams head outside because it's all about exteriors and landscaping on the block this week; each designer knows the importance of curb appeal, and this challenge could be the difference between winning and losing the whole competition.

2-06 Rock The Finale--04/12/2021
After six weeks, a winner gets crowned, a street sign gets named and bragging rights get claimed in the finale; experts appraise the houses and the teams finally tour each other's beautiful work.


Season Three Episode Guide (HGTV)
3-01 Episode One--02/28/2022
Four all-star HGTV home design teams tackle weekly challenges to see which team can take a $225,000 budget to bring the highest assessed value to their finished Charleston-area home.

3-02 Living Room Showdown--03/07/2022
First impressions are everything as each team reimagines their home's living room and entryway to showcase their unique design styles; season one winner, Jasmine Roth, returns to judge the renovated spaces and choose a winning team.

3-03 Main Suites Showdown--03/14/2022
The master suite challenge pits the teams against each other. The first design challenge provides elements of coastal life the designers must incorporate into their designs.

3-04 F.R.O.G. Showdown--03/21/2022
The four design teams tackle the FROG: finished room over garage.

3-05 Exterior Showdown--03/28/2022
The teams complete their exterior spaces.

3-06 Finale Showdown--04/04/2022
The teams race to finish their houses before their money runs out and judgement day arrives; Drew Scott and previous winners Brian and Mika Kleinschmidt judge the entire homes while each team finally gets to see their competitions' spaces.

3-07 Behind The Block--04/11/2022


Season Four Episode Guide (HGTV)
Hosted by popular carpenter, craftsman and design expert Ty Pennington, the new six-episode season will feature the biggest houses and the biggest budgets in Rock the Block history, raising the stakes to an all-time high as four teams of HGTV’s powerhouse experts face-off in an epic home renovation battle in the picturesque town of Berthoud, Colorado. The teams will have just six weeks and a budget of $250,000 to renovate four identical 5,000-square-foot properties—each valued at $1.9 million before the renovations begin—and transform them into luxurious homes that reflect their signature vision and stunning design style. The team who adds the most value to their property will win the ultimate bragging rights as Rock the Block champions and receive a street named in their honor. 
Competitors: Bryan + Sarah Baeumler (Renovation Island); Michel Smith Boyd and Anthony Elle (Luxe For Less); Jonathan Knight + Kristina Crestin (Farmhouse Fixer); Page Turner + Mitch Glew (Fix My Flip)
4-01 Kitchen Face-Off--03/06/2023
Four teams of HGTV all-stars design kitchens as the ultimate renovation competition begins. After a hot-air balloon ride over the mountains offers inspiration, Fixer to Fabulous' Dave and Jenny Marrs judge the jaw-dropping finished spaces.

4-02 Living Room Face-Off--03/13/2023
In week two, the teams create stunning Living Rooms and Entryways for their homes. Fireplaces and Rocky Mountain views seem like a sure thing until Rock the Block alum Mina Starsiak-Hawk and HGTV's Jenn Todryk tour everyone's work and pick a winner.

4-03 Main Suite Face-Off--03/20/2023
The competition turns up as the teams renovate their main suite; elevated designs rule the day as Lyndsay Lamb and Leslie Davis come to blind judge and determine if any team left things too basic.

4-04 Lower Level Face-Off--03/27/2023
With the first floor complete, the teams head downstairs to tackle the biggest space ever seen on Rock the Block: the Lower Level, 1500 square feet of blank canvas to create some of the most outrageous spaces ever seen.

4-05 Exterior Face-Off--04/03/2023
Time to head outside as teams design their exterior spaces during a snowy week on the block.

4-06 Finale Face-Off--04/10/2023
With budgets dwindling and pressure mounting, everyone sprints to finish their houses. After six weeks, a winner will be named and bragging rights claimed. Plus, the teams get to see each other's homes for the first time.

4-07 Behind The Block--03/30/2023


Season Five Episode Guide (HGTV)
5-01 Kitchen Redemption--03/04/2024
Four teams of HGTV all-stars return, designing kitchens in a quest for redemption as the renovation competition begins; after battling an open floor plan, the teams are judged by "Married to Real Estate's" Egypt Sherrod and Mike Jackson.

5-02 Living Room Redemption--03/11/2024
The teams create their living room and first floor spaces in week two; it's a game of beds, baths and views plus a twist on judging as "100 Day Dream Home's" Brian and Mika Kleinschmidt assess the spaces and declare the winning team.

5-03 Main Suite Redemption--03/18/2024
The competition heads upstairs to the main suite where teams attempt to redeem themselves with their designs; "Farmhouse Fixer's" Kristina Crestin comes to judge and determine who's got first-rate taste.

5-04 Backyard Redemption--03/25/2024
Teams stay outside in week five as they design their docks, balconies and front exteriors; Ty asks everyone to get artsy in his latest Design Surprise before "Rock the Block" winner Michel Smith Boyd and Veronica Valencia judge.

5-05 Exteriors Redemption--04/01/2024
Teams stay outside in week five as they design their docks, balconies and front exteriors; Ty asks everyone to get artsy in his latest Design Surprise before "Rock the Block" winner Michel Smith Boyd and Veronica Valencia judge.

5-06 Surprise Bedroom Redemption--04/08/2024
Road to redemption isn't easy as Ty surprises the teams with their toughest challenge: completing a bedroom flex space in 48 hours; Jimmy Rollins teaches the teams to get an advantage; in a "Rock the Block" first, teams judge themselves.

5-07 Final Redemption--04/15/2024
The teams sprint to add the most value in their final spaces before a winner is named and redemption earned. Teams also tour each other's houses for the first time while Property Brother, Jonathan Scott judges their work.


Season Six Episode Guide (HGTV)
6-01 New Block, New Drama--04/14/2025



9.168MBMemory Usage156msRequest 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" => 1746090988 "last" => 1746090988...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (8.3ms)
  • afterInitialise (1.26MB) (27.94ms)
  • afterRoute (281.67KB) (9.63ms)
  • beforeRenderComponent com_content (38.29KB) (1.41ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.12ms)
  • After Access::preloadComponents (all components) (109.3KB) (843μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (19μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (9.36ms)
  • Before Access::getAssetRules (id:4698 name:com_content.article.3864) (258.8KB) (199μs)
  • After Access::getAssetRules (id:4698 name:com_content.article.3864) (8.47KB) (236μs)
  • beforeRenderRawModule mod_related_items (Read More) (893.51KB) (35.63ms)
  • Before Access::getAssetRules (id:8 name:com_content) (77.38KB) (6.87ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (19μs)
  • afterRenderRawModule mod_related_items (Read More) (44.27KB) (4.98ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (10μs)
  • afterRenderModule mod_related_items (Read More) (3.01KB) (266μs)
  • afterRenderComponent com_content (50.13KB) (124μs)
  • afterDispatch (3.53KB) (283μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (24.8ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (635μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (221μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (46μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (124μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (93μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (84μs)
  • afterRenderRawModule mod_finder (Head Search) (66.78KB) (3.62ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (208μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (60μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (415μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (4.88KB) (99μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (48μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (96μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (107μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (26μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (93μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (103μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (26μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (152μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (106μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.28ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.64ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (93μs)
  • afterRender (689.13KB) (12.51ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (893.51KB) (22.82%)
    35.63ms
    1 x afterInitialise (1.26MB) (17.9%)
    27.94ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (15.89%)
    24.80ms
    1 x afterRender (689.13KB) (8.02%)
    12.51ms
    1 x afterRoute (281.67KB) (6.17%)
    9.63ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (5.99%)
    9.36ms
    1 x afterLoad (528.29KB) (5.32%)
    8.30ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (77.38KB) (4.4%)
    6.87ms
    1 x afterRenderRawModule mod_related_items (Read More) (44.27KB) (3.19%)
    4.98ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.78KB) (2.32%)
    3.62ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (1.69%)
    2.64ms
    1 x beforeRenderComponent com_content (38.29KB) (0.91%)
    1.41ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.82%)
    1.28ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.72%)
    1.12ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.54%)
    843μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.41%)
    635μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.27%)
    415μs
    1 x afterDispatch (3.53KB) (0.18%)
    283μs
    1 x afterRenderModule mod_related_items (Read More) (3.01KB) (0.17%)
    266μs
    1 x After Access::getAssetRules (id:4698 name:com_content.article.3864) (8.47KB) (0.15%)
    236μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.14%)
    221μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.13%)
    208μs
    1 x Before Access::getAssetRules (id:4698 name:com_content.article.3864) (258.8KB) (0.13%)
    199μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.1%)
    152μs
    1 x afterRenderComponent com_content (50.13KB) (0.08%)
    124μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    124μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.07%)
    107μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.07%)
    106μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.07%)
    103μs
    1 x afterRenderModule mod_custom (Lead Info) (4.88KB) (0.06%)
    99μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (0.06%)
    96μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    93μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    93μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.06%)
    93μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    84μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.04%)
    60μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    48μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    46μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    26μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    19μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    10μ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 (magazine-menu-3) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
49 statements were executed, 3 of which were duplicates, 46 unique31.65ms430.73KB
  • SELECT @@SESSION.sql_mode;97μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?129μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1102μ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)453μ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` = 1369μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`111μ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` = :guest227μ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`781μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'529μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC184μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='3864-show-guide-rock-the-block' AND published=1206μ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`613μ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`674μ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` = 1211μ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)504μ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` = 03.35ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.69ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '3864'395μ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)503μ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`523μ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.19ms5.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`679μ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 ASC453μ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.02ms2.34KBParams/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`692μ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.id134μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'153μ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 ordering186μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.21ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid143μ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` = :muserid326μ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 ASC400μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'71μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5174μ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`798μs18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id99μ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 54.84ms1.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 ASC478μs8.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.25ms5.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`451μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1327μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `tvlfg_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)147μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration467μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'421μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field142μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'95μ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` = 1141μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?126μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?485μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy