Too Much TV: Your TV Talking Points For Friday, June 28th, 2024

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

PRODUCTION NOTES
The next Television Critics Association gathering begins on Wednesday, July 10th, and runs through the 17th. I'll be flying in the day before and meeting with executives from one of the streamers and given how many people stopped me at the last TCAs to talk about the newsletter, I wanted to encourage all of you to reach out if you'd like to meet up that week. Or if you have someone you think I should be talking to. 

Too Much TV continues to grow and I'm up past 90,000 free subscribers. So between this newsletter and AllYourScreens, this is a good, independent platform to get the word out on whatever project you're working on right now.

SVOD LIBRARY GROWTH/DECLINES
I think the perception in Hollywood is that the libraries of the major streamers have substantially decreased over the past few years. Part of that has to do with the regular cullings of titles from services such as Max.

I recently asked the folks at Parrot Analytics if they could provide some data on the comparative changes in library size at the top eight subscription-based video services and the results were fascinating. Here is what they reported, although for technical reasons they were unable to provide data right now for Paramount+. The changes cover the period from Q1 2022 through Q1 2024 and include only the libraries in the U.S. versions of the various services:

Netflix

  • Film (-2%)
  • TV (+ 18%)
 
Amazon Prime Video
  • Film (+ 34%)
  • TV (+ 28%)
 
Disney+
  • Film (+ 14%)
  • TV (+ 34%)
 
Hulu
  • Film (-8%)
  • TV (+ 10%)
 
Max (Q2 2023-Q1 2024)*
  • Film (+ 4%)
  • TV (+ 25%)
 
Peacock
  • Film (+ 74%)
  • TV (+ 45%)
 
Apple TV+
  • Film (+ 138%)
  • TV (+ 166%)

A lot of these shifts make sense once you think about it. Apple TV+'s movie library expanded so much because it has begun licensing outside movie titles, albeit on very short-term deals. Likewise, adding content from Hulu onto Disney+ likely had a big impact on the latter's overall library numbers.

One thing pure numbers don't tell you is the types of library titles. While Max's TV library continues to grow, I suspect that a deep-dive of the specific titles would find that the regular addition of reality shows from WBD linear networks helps to mask an overall drop in scripted programming. 

As a reminder, I previously reported that the library of Discovery+ has dropped 18 percent in the same period, according to Parrot Analytics.

ONE MORE THING ABOUT THE HOLLYWOOD REPORTER
I have been writing over the past couple of days about the ongoing changes at The Hollywood Reporter and my original intention was to post a full-length updated story today. But in full disclosure, that's a bit delayed due to a couple of things. I wanted to make sure that I allowed the company an opportunity to directly address some questions I had asked. But I also have continued to hear from former and current THR and Penske employees. And I want to fully integrate that into my reporting.

However, I do have a couple of additional thoughts about the situation. First is this comment from someone I corresponded with today, who said something that will sound familiar to nearly everyone who has ever worked in the digital media world:

"I could never figure out what the hell we were supposed to be doing. I'm assuming Roshan (Maer Roshan, co-editor at THR) had some grand plan of where we going. It certainly seemed to me that he wasn't happy with what we were doing. But it always felt like he was better at blowing things up than communicating to the staff in a way that was productive."

There is also the larger question about corporate strategy and whether it aligns with what is happening in digital media in 2024. I've been told by several people that there was a lot of pressure from the Penske corporate people to hit challenging traffic numbers as well as pushing to maximize the number of daily posts. The problem is the approach - combined with a more aggressive digital ad strategy - is out of touch with what is happening in the marketplace right now. 

It reminds me of these comments I just read from GQ‘s European director of audience development, analytics and social, Neha-Tamara Patel:

She said: “It was apparent to me that we were doing a lot of what I call ‘feeding the algorithm content’: lots of short-form news, a lot of quick fashion news, all of which was still within GQ’s world but from an audience perspective wasn’t really serving us long term.

“It meant that we had a lot of churn, a lot of people coming in for that quickfire content and then leaving again without really accessing the broader spectrum of what we do as a brand.

“So we really made a conscious decision to slow things down, not necessarily feed the news cycle. We are a lifestyle magazine brand at the end of the day, not business of fashion or anything like that. So we obviously do touch on fashion news, but we try and think about where we can add to the conversation rather than it being like pure reportage. We’re not just about headlines. It’s like, how are we moving the story on and what else are we bringing to the table?”

In theory, moving THR to a more "let's add to the conversation" stance makes sense. And from what I can tell, that seems to be part of the motivation for recent changes. Although if that is the case, it's not being communicated clearly or executed coherently.

As always, if you have anything you think I should about this story, you can reach out on background or off-the-record at rick@allyourscreens.com. I can also be reached on Signal or WhatsApp at 612-207-2018.



A CONVERSATION WITH JEANINE MASON
The new animated series WondLa premiered today on Apple TV+, and it is an inventive show with a very distinctive worldview. I recently had the opportunity to speak with Jeanine Mason, who plays the lead character "Eva" in the show:

It's also an interesting acting challenge because you're playing a character who doesn't have any experience with other humans. Or really without anyone, other than a robot. And you have to find that space that makes sense, without veering too far one way or the other. Either being too extremely giddy and goofy and awkward. Did it take you a while to get to the point where you felt that you had it dialed in and were where you needed to be with Eva?

Yeah, of course. They would be so loving. We would start the session and they would say "We're just going to play this piece from our last session and see if you hear what's going on in this one little line here." (laughs).  It was to help me match what we were starting to settle on. And it was so helpful to be that honest about what a 16-year-old would sound like in that situation.

And it is a journey and throughout the season she just matures so much. I wanted her to feel close to me in terms of tone. In some of the previous animation work I've done, I've geeked out about it and really disguised my voice. But this felt like it was the opportunity to bring myself to it. And I am really glad I made that choice, because man, we had such a journey ahead for her. 

So she ends up sounding a lot closer to where my natural register lies. 


Most of the conversation ended up being about her acting approach to voice work, which was enlightening. 

THINKING LIKE AN OLD SCHOOL TV PROGRAMMER
VidCon, the annual creator convention held in Anaheim, CA. just wrapped up and the creator-oriented Publish Press has some good coverage of the highlights. This comment about how creators can adapt to the rise of YouTube TV is something I think even traditional TV producers with a YouTube channel should keep in mind:

Thinking like an old school TV programmer has its advantages,” Danyel Mendoza, director of content planning for Disney and National Geographic’s YouTube channels, said. “Consider seasonality, scheduling, and live content so there is always something going on when someone visits your channel.”

ODDS AND SODS
* Apple TV+ has canceled The Big Door Prize after two seasons. Which is a drag, since season two ended on a bit of a cliffhanger.

* Reality Blurred's Andy Dehnart writes that the problem with the Top Chef finale is a problem common across reality television.

* The ad-supported FAST Channel Ion Plus will also roll out as a linear diginet beginning July 1st. Its programming includes reruns of MacGyver, Scorpion, Murdoch Mysteries, Leverage, Hudson & Rex, and Private Eyes.

* According to Digital TV Research, Netflix's global subscription numbers will 313 Million by 2029.

* Here are some photos from the special Tokyo screening of the upcoming Apple TV+ drama Sunny.

TWEET OF THE DAY



WHAT'S NEW TONIGHT AND THIS WEEKEND

FRIDAY, JUNE 28TH:
* A Family Affair (Netflix)
* Beach Cottage Chronicles Series Premiere (Magnolia)
* Family Empire: Houston Series Premiere (OWN)
* Fancy Dance (Apple TV+)
* Guy's All-American Road Trip Season Finale (Food)
* Marvel's Moon Girl And Devil Dinosaur: Moon Girl's Lab (Disney+)
* Òlòtūré: The Journey Series Premiere (Netflix)
* Owning Manhattan Series Premiere (Netflix)
* The Devil's Bath (Shudder)
* The Mole Season Two Premiere (Netflix)
* The Proof Is Out There: Alien Edition Series Premiere (History)
* WondLa Series Premiere (Apple TV+) - [first look video] - [Jeanine Mason interview]
* Zombies: The Re-Animated Series Series Premiere (Disney)

SATURDAY, JUNE 29TH:
* Falling Like Snowflakes (Hallmark)
* Net Of Lies Season Premiere (Investigation Discovery)
* The Killer Inside: The Ruth Finley Story (Lifetime)

SUNDAY, JUNE 30TH:
* Anne Rice's Interview With The Vampire Season Two Finale (AMC)
* Biography: Sammy Hagar (A&E)
* Biography: Sebastian Bach (A&E)
* Little Girl In The Window (Lifetime)
* 100 Day Dream Home Season Premiere (HGTV)
* Shark Beach With Anthony Mackie: Gulf Coast (NatGeo)
* Shark Vs. Ross Edgeley (NatGeo)
* The Great Food Truck Race: Games On The Gulf (Food Network)
* 2024 BET Awards (BET)
* Watch What Happens Live With Andy Cohen 15th Anniversary Special (Bravo)

MONDAY, JULY 1ST:
* Basketball Wives Season Premiere (VH1)
* 90 Day Fiance: The Other Way (PBS)
* Outrageous Love With NeNe Leakes Series Premiere (Lifetime)
* Parents Gone Wild Series Premiere (Lifetime)
* POV: Hummingbirds (PBS)
* Sharks Gone Viral (NatGeo)
* Shy (Crunchyroll)
* Star Trek: Prodigy Season Premiere (Netflix)
* Supersized Sharks (NatGeo)
* The Ossan Newbie Adventurer, Trained To Death By The Most Powerful Party, Became Invincible Series Premiere (Crunchyroll)
* The Wall Season Premiere (NBC)
* 30 For 30: No Scope: The Story Of FaZe Clan (ESPN)

SEE YOU ON MONDAY!


8.658MBMemory Usage147msRequest 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" => 1743465174 "last" => 1743465174...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (4.21ms)
  • afterInitialise (1.27MB) (33.97ms)
  • afterRoute (227.06KB) (7.56ms)
  • beforeRenderComponent com_content (38.63KB) (1.08ms)
  • Before Access::preloadComponents (all components) (34.7KB) (990μs)
  • After Access::preloadComponents (all components) (109.3KB) (867μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (20μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (9.34ms)
  • Before Access::getAssetRules (id:2858 name:com_content.article.2029) (130.8KB) (175μs)
  • After Access::getAssetRules (id:2858 name:com_content.article.2029) (8.47KB) (185μs)
  • beforeRenderRawModule mod_related_items (Read More) (1.04MB) (40.54ms)
  • Before Access::getAssetRules (id:8 name:com_content) (81.18KB) (2.65ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (15μs)
  • afterRenderRawModule mod_related_items (Read More) (13.48KB) (5.84ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (9μs)
  • afterRenderModule mod_related_items (Read More) (4.07KB) (205μs)
  • afterRenderComponent com_content (51.5KB) (84μs)
  • afterDispatch (3.53KB) (267μs)
  • beforeRenderRawModule mod_menu (Newsletters) (156.52KB) (20.41ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (507μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (176μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (40μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (114μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (3μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (88μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (68μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (3.39ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (5μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (166μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (53μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (283μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (92μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (21μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (78μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (87μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (20μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (115μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (4μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (86μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.06ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (2.35ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (5μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (88μs)
  • afterRender (689.13KB) (9.65ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (1.04MB) (27.52%)
    40.54ms
    1 x afterInitialise (1.27MB) (23.06%)
    33.97ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (156.52KB) (13.85%)
    20.41ms
    1 x afterRender (689.13KB) (6.55%)
    9.65ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (6.34%)
    9.34ms
    1 x afterRoute (227.06KB) (5.13%)
    7.56ms
    1 x afterRenderRawModule mod_related_items (Read More) (13.48KB) (3.96%)
    5.84ms
    1 x afterLoad (528.66KB) (2.86%)
    4.21ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (2.3%)
    3.39ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (81.18KB) (1.8%)
    2.65ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.6%)
    2.35ms
    1 x beforeRenderComponent com_content (38.63KB) (0.74%)
    1.08ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.72%)
    1.06ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.67%)
    990μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.59%)
    867μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.34%)
    507μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.19%)
    283μs
    1 x afterDispatch (3.53KB) (0.18%)
    267μs
    1 x afterRenderModule mod_related_items (Read More) (4.07KB) (0.14%)
    205μs
    1 x After Access::getAssetRules (id:2858 name:com_content.article.2029) (8.47KB) (0.13%)
    185μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.12%)
    176μs
    1 x Before Access::getAssetRules (id:2858 name:com_content.article.2029) (130.8KB) (0.12%)
    175μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.11%)
    166μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.08%)
    115μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    114μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.06%)
    92μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    88μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.06%)
    88μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    87μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.06%)
    86μs
    1 x afterRenderComponent com_content (51.5KB) (0.06%)
    84μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.05%)
    78μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    68μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.04%)
    53μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    40μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    20μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    15μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    9μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    3μs
48 statements were executed, 3 of which were duplicates, 45 unique53.86ms541.93KB
  • SELECT @@SESSION.sql_mode;89μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?175μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 185μ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)7.7ms944BParams/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` = 1327μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`95μ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` = :guest170μ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`565μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'4.93ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC149μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1174μ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`392μ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`293μ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` = 1195μ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)497μ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.23ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.56ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2029'4.48ms48B/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)560μ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`598μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)1.43ms5.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`466μ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 ASC512μ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 DESC3.01ms58.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`481μ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.id145μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'163μ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 ordering162μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.55ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid163μ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` = :muserid175μ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 ASC396μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'84μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5166μ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.1ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id143μ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)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 51.02ms1.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.14ms89.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.06ms5.42KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1652μ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)177μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration256μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'138μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field120μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'93μ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` = ?116μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?10.62ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy