Too Much TV: Your TV Talking Points For Wednesday, June 26th, 2024:

Here's everything you need to know about the world of television for Wednesday, June 26th, 2024:

ONE MORE THING ABOUT DISCOVERY+
My piece in yesterday's newsletter about my love of Discovery+ sparked a lot of feedback from readers, most along the lines of "yes, I feel the same way." Several people mentioned that of all of the major streaming services, Discovery+ has the best "Continue Watching" section. 

"If I save a show and watch an episode, the next new episode will automatically drop in when it's available," wrote Kim. "Which is an idea that seems to be too difficult for a lot of streaming services. That section is also very prominent on the home page. I don't have to scroll down through endless rows to get to it."

I agree with that assessment, although I wish the service would drop new episodes into the continue watching section whenever a new season begins of some show I've saved. The service seems to forget shows once the season ends, which isn't helpful. But otherwise, it's a solid feature.

I also received some additional data about this comment I made yesterday:

"The overall size of the catalog has slowly been decreased and while I don't have a firm figure, based on what I've seen as a subscriber, somewhere around 25% of the shows have either been removed from Discovery+ and/or licensed exclusively elsewhere. The service also seems to be licensing a much smaller group of shows from rivals such as A&E Networks."

I heard from someone at Parrot Analytics, who passed along this factoid:

Since Q3 2022, Discovery+ has seen its library shrink by nearly 18%, according to Parrot Analytics' Content Panorama.

So my 25% estimate wasn't too far off. My hunch is that Max and Paramount+ have both seen sizeable drops in the same period. 

WHAT'S GOING ON AT THE HOLLYWOOD REPORTER?
The Penske Media Corporation-owned trade outlet The Hollywood Reporter (THR) announced on Tuesday that Elisabeth Rabishaw, an industry veteran and current THR executive VP and publisher is leaving after spending 14 years at the outlet. According to a story announcing the move, she will stay on at the company in a consulting role. This follows the recent round of layoffs at THR, which included TV editor Lesley Goldberg, who had been with the outlet since 2003. Other layoffs included senior editor of diversity and inclusion Rebecca Sun, THR’s vice president of business development and consumer partnerships Cathy Field and what was described to me as a "handful" of other editorial and business employees. 

The Hollywood Reporter had an earlier round of layoffs in June 2023, which affected less than five employees.

Penske Media Corporation is a private company, so it's not clear how the ongoing changes in the industry have affected the outlet (or any of the other trades also owned by PMC). But given the soft ad market (aside from FYC ads) and changes in search that have impacted traffic across the board, it's likely that THR has been hit with the same challenges as other news organizations inside and outside Hollywood.

But the layoffs are interesting to me in the context of something I have heard from multiple people: that executives at PMC have been quietly telling some studios, advertisers and other interested figures that they are considering shifting the focus of THR to a more entertainment lifestyle direction.

In the past, THR has covered much of the same editorial ground as sister trade publications Deadline and Variety. According to several people I've spoken with in recent days, one plan under consideration within PMC is to make moves to further differentiate the three top titles. Deadline is already seen as more consumer-facing than the other sites, with Variety being seen as more industry-oriented (especially given efforts such as the subscription-based Variety+). 

THR would shift to what was described to me as a "Rolling Stone of the TV and movie industry." Shopping and sponsored product pages have been rolled out over the past few months and sources tell me that while THR would still include a TV and movie industry bent, there would be an increase in entertainment lifestyle coverage. One person who works in the marketing arm of a major studio told me on Wednesday that the potential shift had been described to them as seeking to frame THR as being the home for "aspirational Hollywood."

No, I'm not quite sure what that means, either. 

THE CHANGING STATE OF HOLLYWOOD ENTERTAINMENT ACROSS THE GLOBE
I frequently write that a lot of people in Hollywood don't have a real sense of how the global television industry is changing underneath them and the impact it has on their careers.

There is still this sense that Hollywood-produced entertainment shows are the bread-and-butter choice across the globe. That has been the case for the past few decades and it's true that familiar American titles are still an important component of any foreign broadcast network or streamer. 

But what has changed is that the importance of American titles have changed and one example is these comments from a NATPE Budapest panel of CEOs, who were quizzed on how U.S. studio fare performs for them:

Stella Litou runs CME-owned broadcasters Pro Plus in Slovenia and RTL in Croatia. “This content, especially the evergreen procedurals and comedies, they are for our secondary, not for our main channel,” she said when asked about the role for U.S. content on her services. “But for our secondary channels, these are our bread-and-butter. It’s very important to consolidate the numbers for the group and to populate the bouquet of channels that we offer.”

Ralf Litou is CEO of Bulgaria’s bTV group, also part of CME. He was also at German commercial giant ProSiebenSat.1 during the era when it was forking out huge sums for studio shows. In Bulgaria, his strategy is to pick and choose even though competitors still look for output deals. “We are happy not to have those anymore,” he said. “You want to be more focused on local and local content, and in the end, local always beats the [U.S.] series. So yes, we have them still sometimes, especially in low season they are important, but not that important anymore.”

This shift of American titles from the primary networks overseas to secondary ones has a direct impact on the American television industry. The shift results in smaller licensing fees and that means the revenue stream on the average title is reduced. That means a reduction in revenue for the studios, which results in budgets being cut and some marginal shows getting canceled or never ordered at all because the budgets no longer make sense with less international licensing money available.

As I keep saying, this is a very interconnected world and decisions made in Budapest or Australia can have an impact on whether your American-produced show gets the green light. That increased emphasis on local productions also means that more content spend is shifting from American projects to ones produced in local global markets. All of which leads to a reduction of production in Hollywood.

Which is why I remind people that "post peak TV" has more to do with the specifics in Hollywood, instead of the state of the industry across the globe.

ODDS AND SODS
* NBC will air two-hour Toby Keith tribute concert special this August, with a guest line-up to include Luke Bryan, Eric Church, Ashley McBryde, Carrie Underwood, Parker McCollum, Jelly Roll, Darius Rucker, Lainey Wilson, and The War And Treaty. Toby Keith: American Icon will premiere Wednesday, August 28th.

* For the deeply tech-minded of you, this is an interesting look by Enterprise WordPress, which examines how Penske Media (which owns Variety, The Hollywood Reporter, Deadline and more) uses WordPress to streamline its content production process.

* A new season of Alex vs America will premiere Sunday, July 14th, 2024 on the Food Network. I enjoy the show, but I'm not thrilled about the changes for the upcoming season, which include adding a number of familiar Food Network personalities to the competitor list instead of having Chef Alex Guarnaschelli compete against talented chefs with less TV experience. The season premiere pits her against Michael Symon, Stephanie Izard and Jose Garces, which sounds like about a half dozen other shows also on the network. Other competitors this season will include Duff Goldman, Antonia Lofaso, Simon Majumdar, Marcus Samuelsson, Jet Tila, Brooke Williamson, Michael Voltaggio, and Geoffrey Zakarian. Sigh.

* Apple TV+ has announced the new six-part docuseries Vietnam: The War That Changed America, which will premiere next year.

* Paramount+ will premiere season two of the Sylvester Stallone drama The Tulsa King on Sunday, September 15th in the U.S. and Canada and across Paramount+ international markets beginning Monday, September 16th. 

* Anne Rice's Interview with the Vampire has been renewed for a third season by AMC Networks ahead of the show’s season two finale airing on June 30th. 

TWEET OF THE DAY

WHAT'S NEW TONIGHT AND TOMORROW

WEDNESDAY, JUNE 26TH:
* Acapulco Season Three Finale (Apple TV+)
* Fear Thy Neighbor Season Premiere (Investigation Discovery)
* Land Of Women Series Premiere (Apple TV+)
* Northern Lights (Britbox)
* The Real CSI: Miami Series Premiere (CBS)
* The Strongest Magician In The Demon Lord's Army Was A Human (Crunchyroll)
* Worst Roommate Ever Season Two Premiere (Netflix)

THURSDAY, JUNE 27TH:
* Diane Von Furstenberg: Woman In Charge (Hulu)
* Domino Day: Lone Witch Series Premiere (Sundance Now)
* Drawing Close (Netflix)
* My Lady Jane Series Premiere (Prime Video)
* That 90s Show Season One Part Two Premiere (Netflix) - [first look video]
* The Bear Season Three Premiere (Hulu)
* Young. Wild. Free. (BET+) - [first look video]

SEE YOU ON THURSDAY!

8.682MBMemory Usage380msRequest 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" => 1743469237 "last" => 1743469237...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.5ms)
  • afterInitialise (1.27MB) (33.43ms)
  • afterRoute (227.03KB) (36.25ms)
  • beforeRenderComponent com_content (38.63KB) (1.48ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.28ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.06ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (40μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (10.47ms)
  • Before Access::getAssetRules (id:2839 name:com_content.article.2010) (130.8KB) (298μs)
  • After Access::getAssetRules (id:2839 name:com_content.article.2010) (8.47KB) (292μs)
  • beforeRenderRawModule mod_related_items (Read More) (847.15KB) (97.53ms)
  • Before Access::getAssetRules (id:8 name:com_content) (82.4KB) (4.52ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (18μs)
  • afterRenderRawModule mod_related_items (Read More) (40.34KB) (7.45ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (11μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (258μs)
  • afterRenderComponent com_content (35.25KB) (102μs)
  • afterDispatch (3.53KB) (338μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (83.83ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (779μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (257μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (53μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (162μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (6μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (121μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (279μs)
  • afterRenderRawModule mod_finder (Head Search) (66.42KB) (10.75ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (15μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (269μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (101μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (565μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (134μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (31μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (117μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (117μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (28μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (202μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (117μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.58ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (63.92ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (18μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (175μs)
  • afterRender (685.13KB) (13.06ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (847.15KB) (25.65%)
    97.53ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (22.05%)
    83.83ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (16.81%)
    63.92ms
    1 x afterRoute (227.03KB) (9.54%)
    36.25ms
    1 x afterInitialise (1.27MB) (8.79%)
    33.43ms
    1 x afterRender (685.13KB) (3.43%)
    13.06ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.42KB) (2.83%)
    10.75ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (2.76%)
    10.47ms
    1 x afterLoad (528.29KB) (1.97%)
    7.50ms
    1 x afterRenderRawModule mod_related_items (Read More) (40.34KB) (1.96%)
    7.45ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (82.4KB) (1.19%)
    4.52ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.42%)
    1.58ms
    1 x beforeRenderComponent com_content (38.63KB) (0.39%)
    1.48ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.34%)
    1.28ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.28%)
    1.06ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.2%)
    779μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.15%)
    565μs
    1 x afterDispatch (3.53KB) (0.09%)
    338μs
    1 x Before Access::getAssetRules (id:2839 name:com_content.article.2010) (130.8KB) (0.08%)
    298μs
    1 x After Access::getAssetRules (id:2839 name:com_content.article.2010) (8.47KB) (0.08%)
    292μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.07%)
    279μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.07%)
    269μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.07%)
    258μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.07%)
    257μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.05%)
    202μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.05%)
    175μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.04%)
    162μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.04%)
    134μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.03%)
    121μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.03%)
    117μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.03%)
    117μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.03%)
    117μs
    1 x afterRenderComponent com_content (35.25KB) (0.03%)
    102μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.03%)
    101μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.01%)
    53μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    40μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    18μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    18μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    15μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    11μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
49 statements were executed, 3 of which were duplicates, 46 unique61.58ms571.24KB
  • SELECT @@SESSION.sql_mode;148μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?173μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1119μ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)352μ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` = 1438μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`183μ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` = :guest286μ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`809μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'2.4ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC193μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1409μs4.09KB/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`489μ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`345μs5.14KBParams/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` = 1217μ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)630μ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.28ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.08ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2010'16.25ms48B/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)837μ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`560μ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.02ms5.25KBParams/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`552μ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 ASC1.17ms6.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.99ms58.03KBParams/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`502μ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.id149μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'174μ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 ordering165μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.47ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid155μ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` = :muserid199μ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 ASC474μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'97μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5175μ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.08ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id138μ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 OR `a`.`metakey` LIKE :preparedArray4 OR `a`.`metakey` LIKE :preparedArray5)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 52.15ms1.85KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) 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 ASC1.15ms113.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7)3.04ms5.53KBParams/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`579μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 14.62ms976B/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)1.31ms904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration284μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'127μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field108μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'98μ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` = 1151μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?123μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?6.24ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy