Too Much TV: Your TV Talking Points For Tuesday, October 1st, 2024

Here's everything you need to know about the world of television for Tuesday, October 1st, 2024:

PRODUCTION NOTES
You're right, there wasn't a newsletter yesterday. It was a pretty last minute decision, but I decided to take a mental health day. I was sitting around with a few friends of mine - basically a Dad's group - and I decided I didn't want to bail early in order to drive back home and work. I am especially bad about taking time out for me and I felt mentally refreshed today. Maybe someday I'll take an actual vacation...

A DEEP DIVE ON THE DIGITAL MEDIA EFFORTS AT PBS
I really enjoy talking about the inner workings of the television and streaming video business. Deep diving into the strategy behind the decisions that affect what you watch and on what platforms you watch them. But it can be challenging to get access to top executives. In part because they're busy and convincing their people to carve out time to talk to me is tough. But also because they don't want to waste their time and if truth be told, not every reporter has the same level of knowledge about the industry.

Ira Rubenstein is Chief Digital and Marketing Officer at PBS and since he joined the network in 2014, he's led the expansion of PBS’ general audience and children’s content to mobile devices, over-the-top (OTT) services and other digital platforms. Before he came to PBS, he spent more than 12 years at Sony, most recently as Executive Vice President, Content Strategy and Acquisitions. He also led the establishment of Movielink, a first-of-its-kind online, video on-demand service, and managed the digital growth of the studio’s most important brands, including Wheel of FortuneJEOPARDY! and Seinfeld.

After he left Sony, he was Executive Vice President of Marvel Entertainment’s Global Digital Media Group. During his tenure there, he led strategic global digital initiatives related to websites, digital comics, games, digital video distribution, and launched the award-winning Marvel Digital Comics iPad app. He later served as Executive Vice President, Digital Marketing for 20th Century Fox where he established the Digital Marketing organization and led the team behind ground breaking social and mobile campaigns for PrometheusChronicleRise of the Planet of the ApesX-Men: First Class, and other major motion pictures.

Given his wide range of experience, I was interested in speaking with him about how he sees the streaming and digital world, along with finding out more about PBS' approach to the current multi-platform world.

We spoke for about 30 minutes and I'll post the complete interview tomorrow. In the meantime, here's an excerpt to give you an idea of what to expect. I love this conversation, because it's not the type of in-depth interview you're likely to read in one of the Hollywood trades:

We've talked a bit about PBS Kids and YouTube. But how does YouTube fit in with the content strategy for PBS' news programming and documentaries?

The most effective approach is to get content up and have it stay up. NewsHour is particularly aggressive. They're constantly going live on a lot of social platforms, including YouTube, when there's some sort of press conference at the White House or whatever.

Aa an example, before this last debate, they did an after show that was only on YouTube. And so I do know from an audience perspective, both Frontline and NewsHour, their largest audiences might be on those platforms. And they benefit from the YouTube algorithm.

I'll give Frontline for an example. There's a lot of docs on Putin. And every time Putin's in the news, that YouTube algorithm kicks in, and YouTube has a whole news initiative where they're trying to elevate trusted, factual content.

So we get elevated, and it just kind of self-runs and you get these bumps. On shows like Antiques Roadshow, Nova, Ken Burns. I think we're doing a lot experimenting with those shows.

It's a little harder because to do YouTube well, you really need to leave it up for awhile. And sometimes we don't have the rights for months and months and months for those shows. And also the way the algorithm works, an Antiques Roadshow, which is covering lots of topics, might be better if it was re-jiggered to a specific type of content.

So if you watch the Roadshow, here's all the baseball stuff. And you kind of fed it in that way. But get back to your first point.

YouTube is definitely a priority for us. We're working with a system now where we're in the process of bringing everyone onto a single CMS so that everyone can benefit from the algorithm and lift all boats.

We have a few stations who are on our pilot group who are in there, and they're already seeing a 30% lift. So I'm fairly confident as we get more stations onto our single CMS, which is basically kind of those multi-channel networks that used to be in the past, we're going to be able to leverage everybody. The real trick is, how does that help a station monetize? How do they tie that together? And if anyone from Google, YouTube is reading this, I will once again ask for donations.

My hope is that at some point they can tie into our one-click donation platform that we have running today on Amazon and soon to be running on Xfinity, which basically ties into the wallet system on the Amazon Fire platform. So as you're watching the show, you can click yes to donate, charges your credit card, the money goes right to the station. And that has a 12% conversion rate.

So I'm pretty optimistic that these platforms get more and more sophisticated as they tie in their wallets to their platforms and enable us to tie in ours, that there's a bright future for public media. Because again, going back to the past, it used to be a pledge show, call this number and donate. And you can just think about, if all they have to do is click a button on their remote and they can donate, I think there's a much cleaner path to supporting stations.

But the key is really being educating people what that local station does for their community, what it means for the country, and getting that kind of messaging to drive that support across all these different platforms. Especially given that younger people don't watch any TV. They're are barely
 on broadcast TV.

It's a really fascinating interview and I'll have the entire thing up tomorrow morning on AllYourScreens.com. I'll also link to the full interview in tomorrow's newsletter. We talk a lot about the PBS streaming platform Passport, as well as PBS Masterpiece, the Amazon Channels subscription-based service.

ODDS AND SODS
*
The new limited series Say Nothing, based on the book by Patrick Radden Keefe, tells a gripping story of murder and memory in Northern Ireland during The Troubles. It premieres Thursday, November 14th on Hulu.

* MGM+ has ordered a third and final season of Billy The Kid.

* Frequent users of CNN.com will begin seeing a paywall asking them to subscribe to the sit's new subscription service. It's not clear how many visits will trigger the request, although the company says most users won't see the option. The new CNN.com subscription service costs $3.99 per month or $29.99 a year.

* Prime Video’s Pop Culture Jeopardy! with host Colin Jost will premiere Wednesday, December 4th.

* Prime Video has ordered a Reacher spinoff starring Maria Sten. In the untitled series, Sten will reprise her role as Frances Neagley, who is now a private investigator living in Chicago.

* Frank Fritz, former American Pickers star, has died at age 60. He had been suffering from ill-health for the past several years, but complained in recent interviews that he had been removed from the show after taking time off for back surgery. 

* The new documentary Music by John Williams will premiere Friday, November 1st on Disney+

WHAT'S NEW TONIGHT AND TOMORROW

TUESDAY, OCTOBER 1ST, 2024:
* Accused Season Premiere (Fox)
* American Experience: The American Vice President (PBS)
* Chopped: Legends Finale (Food)
* I'll Become A Villainess Who Goes Down In History Series Premiere (Crunchyroll)
* Let This Grieving Soul Retire Series Premiere (Crunchyroll)
* Making It In Marbella Series Premiere (Netflix)
* The Boulet Brothers' Dragula Season Premiere (Shudder)
* The Irrational Season Premiere (NBC)
* The Real Housewives Of New York City Season Premiere (Bravo)
* The Vice Presidential Debate (Various Outlets)
* Tim Dillon: This Is Your Country (Netflix)
* Tying The Knot With An Amagami Sister Series Premiere (Crunchyroll)
* WWE Next Season Premiere (The CW)


WEDNESDAY, OCTOBER 2ND, 2024:
* Acro Trip (Crunchyroll)
* Big Freedia Means Business Season Premiere (Fuse)
* Chef's Table Noodles Season Premiere (Netflix)
* Destinations Of The Damned Series Premiere (Discovery)
* Forged In Fire Season Premiere (History)
* Guy's Grocery Games All-Star Relay Rumble Finale (Food)
* Joan Series Premiere (The CW)
* KamiErabi GOD.app (Crunchyroll)
* Nova: The Solar System (PBS)
* Re:ZERO -Starting Life In Another World (Crunchyroll)
* Secrets Of The Dead (PBS)
* Sullivan's Crossing Season Premiere (The CW)
* The Last Days Of The Space Age Series Premiere (Hulu)
* The Prince Of Tennis II
(Crunchyroll)
* Unsolved Mysteries Season Premiere (Netflix)
* Where's Wanda? Series Premiere (Apple TV+)


SEE YOU ON WEDNESDAY!



8.678MBMemory Usage316msRequest 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" => 1743469029 "last" => 1743469029...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (9.41ms)
  • afterInitialise (1.27MB) (77.18ms)
  • afterRoute (227.03KB) (10.26ms)
  • beforeRenderComponent com_content (38.63KB) (1.4ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.21ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.26ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (21μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (12.2ms)
  • Before Access::getAssetRules (id:3350 name:com_content.article.2517) (130.8KB) (286μs)
  • After Access::getAssetRules (id:3350 name:com_content.article.2517) (8.47KB) (284μs)
  • beforeRenderRawModule mod_related_items (Read More) (879.05KB) (91.28ms)
  • Before Access::getAssetRules (id:8 name:com_content) (81.13KB) (5.31ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (19μs)
  • afterRenderRawModule mod_related_items (Read More) (13.52KB) (6.66ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (12μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (269μs)
  • afterRenderComponent com_content (43.25KB) (128μs)
  • afterDispatch (3.53KB) (341μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (61.12ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (792μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (7μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (266μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (55μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (160μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (122μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (98μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (13.64ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (12μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (262μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (95μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (471μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (142μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (31μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (112μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (127μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (30μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (191μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (118μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.52ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.19ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (7μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (118μs)
  • afterRender (701.13KB) (14.36ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (879.05KB) (28.91%)
    91.28ms
    1 x afterInitialise (1.27MB) (24.44%)
    77.18ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (19.36%)
    61.12ms
    1 x afterRender (701.13KB) (4.55%)
    14.36ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (4.32%)
    13.64ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (3.86%)
    12.20ms
    1 x afterRoute (227.03KB) (3.25%)
    10.26ms
    1 x afterLoad (528.29KB) (2.98%)
    9.41ms
    1 x afterRenderRawModule mod_related_items (Read More) (13.52KB) (2.11%)
    6.66ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (81.13KB) (1.68%)
    5.31ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.01%)
    3.19ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.48%)
    1.52ms
    1 x beforeRenderComponent com_content (38.63KB) (0.44%)
    1.40ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.4%)
    1.26ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.38%)
    1.21ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.25%)
    792μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.15%)
    471μs
    1 x afterDispatch (3.53KB) (0.11%)
    341μs
    1 x Before Access::getAssetRules (id:3350 name:com_content.article.2517) (130.8KB) (0.09%)
    286μs
    1 x After Access::getAssetRules (id:3350 name:com_content.article.2517) (8.47KB) (0.09%)
    284μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.09%)
    269μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.08%)
    266μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.08%)
    262μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.06%)
    191μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.05%)
    160μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.04%)
    142μs
    1 x afterRenderComponent com_content (43.25KB) (0.04%)
    128μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.04%)
    127μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.04%)
    122μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.04%)
    118μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.04%)
    118μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.04%)
    112μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.03%)
    98μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.03%)
    95μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    55μ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%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    21μ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%)
    12μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (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
48 statements were executed, 3 of which were duplicates, 45 unique67.46ms590.05KB
  • SELECT @@SESSION.sql_mode;105μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?151μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1107μ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)3.59ms944BParams/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` = 1378μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`147μ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` = :guest169μ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`1.02ms3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'8.59ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.96ms2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1247μ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`563μ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`484μ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` = 1252μ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)639μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 05.03ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.82ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2517'2.94ms48B/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)708μs48.62KBParams/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`487μ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.12ms5.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`468μ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 ASC485μ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 DESC10.5ms58.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`3.27ms5.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.id204μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'170μ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 ordering225μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.46ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid182μ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 ASC419μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'104μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5178μ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.46ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id322μ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 52.41ms1.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.22ms113.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.07ms5.53KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 17.51ms976B/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)209μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration845μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'140μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field130μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'106μ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` = 1161μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?129μ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