Too Much TV: Your TV Talking Points For Thursday, October 17th, 2024

Here's everything you need to know about the world of television for Thursday, October 17th, 2024:

PRODUCTION NOTES
I've added a large number of new free subscribers in the past couple of weeks. So it seems like a good time to remind everyone that there is a paid subscription option available. I know that there are a lot of newsletters asking for your time and money. But if you are so inclined, I would really appreciate the financial support. As you might imagine, writing five of these a week is a lot of work and your support makes it possible.

If you aren't ready to make that leap, I'd also like to ask if you'd forward this email to anyone you think might find it interesting. Or like or restack the newsletter, which helps tell Substack this is a newsletter they should be recommending more often. It's a cluttered media world right now and I appreciate all the help, no matter what it might be.

NETFLIX'S QUARTERLY EARNINGS
I'm not going to recap the Netflix quarterly numbers at this point of the day. I suspect if you're interested, you have at least seen the highlights by now.

I did want to touch on a couple of things I found interesting.

According to the investor letter, Netflix users watch an average of two hours a day of the service and that number keep growing. Which tells us a couple of things. When the average user is regularly watching that much of a service, they'll drop a lot of other streaming options before they drop Netflix. That is incredibly valuable when it comes to subscriber retention and it's likely a primary reason why Netflix's churn rate continues to be lower than any of its major competitors.

Netflix's customer acquisition costs (CAC) are a bit harder to figure out. In the streaming industry, at least part of content spend can be attributed primarily as a way to acquire new customers. But there is no way from the outside to figure out how Netflix slices that pie. And it's even more complicated by the fact that Netflix has a global business and that means different territories have different spending and content priorities.

One way to get a sense of how CAC costs are headed is to look at marketing costs (which also includes PR, etc) and compare that quarterly spend to how many new subscribers were added. Granted, that is a very rough metric and it is also complicated by the different challenges in different territories. And it's also tough to determine how much of any marketing increase is just attributable to the fact that overall subscriber base is larger quarter-over-quarter.

But as an FYI, if you make that comparison, Netflix's marketing costs per new subscriber has risen in the third quarter for each of the last three years:

2024 Q3: $126 per new subscriber
2023 Q3: $110 per new subscriber
2022 Q3: $96 per new subscriber

So that points to Netflix's average CAC slowly increasing, which makes sense given that several of its bigger markets are likely hitting a ceiling for possible new subscribers. The good news for Netflix is that at least for now, they can afford it.

One last point. A lot of industry critics point to Netflix's stock price as being "insane," especially given the much lower prices of Disney and the sad sack Warner Bros Discovery. They point to those media company's diverse IP and holdings and argue those assets are undervalued. And there's a lot of truth to that. But that diversity also makes for a much more challenging way forward to grow revenue and not make any major strategic mistakes.

Netflix is being rewarded by Wall Street for being the leader in a business that even competitors will admit is the future of entertainment. It is making money, it's managed a difficult executive transition and continues to expand globally in a way that will only increase its revenue and reach. It's not perfect, but for investor purposes it's as close to a sure bet as you can get. The bet by investors is that even though Netflix's stock price might have some volatility at times, it's now a market leader and that makes it worth it. That high stock price doesn't necessarily reflect Netflix's worth, but its stability.

READER FEEDBACK
In yesterday's newsletter I asked whether any of you were paying attention to the fall broadcast TV primetime premiere week/month, and I received a lot of great feedback. Here is some of it.

"tbh, I don't think I've watched broadcast TV aside from live sports in maybe 4-5 years. I'll usually catch up with some of the shows on Peacock or Paramount+. But I can't tell you the last time I watched a show live when it aired."

--Debbie S.

"New network tv season? I don't pay close attention to network tv. Survivor and the Amazing Race are the only network tv shows we watch anymore. I subscribe to Netflix, Amazon, Hulu Live, ESPN, Disney, Peacock, and Paramount Plus. Most of these choices are because I'm a soccer fan. I wouldn't pay for Amazon except it's free with a Prime subscription. I watch the streamers when not watching soccer but YouTube through our Roku is what is on the most (my wife's choice). I look at Netflix first and bounce around a lot for series and movies. "

--Joe L.

"I’m not watching nearly as much broadcast TV these days (and when I do, it’s on their streamers/Hulu/etc.). Looks like I’ve only got 4 on my radar this fall: “High Potential,” “Doctor Odyssey,” “Happy’s Place” and “Matlock.”

--Chip C.

"My dad watches a lot of live broadcast TV and when I come to visit, I'll sit with him and watch. The thing I notice most is the number of ads on primetime television. I'm not against commercials, I have streaming packages with ads and I even switched down to Netflix with ads. But the networks seem to have more ads than anyone and I just don't have the patience for that amount anymore."

--Cynthia K.

You asked so, here: I recently found your newsletter and I'm addicted. I read every word every day. I knit and watch TV a good bit of every day (I'm 75). I no longer have a subscription to a multi channel service. But I have no-ad subscriptions to about 7 or 8 different streams at any one time. Once a day, I catch Jeopardy on YouTube and also, usually, network evening news there. The down side of my system is just keeping track (also UI roulette - my poor remote feels battered) of what's on what, when and where am I episode wise. That's how I found you - your list of tonight and tomorrow. BUT it's your commentary that now has me hooked. For my money (which, i'll admit, isn't worth squat yet), your content is spot on and very much appreciated. 

--Susan D.

ODDS AND SODS
*
This is a really good overview of some of the challenges facing the FAST ad business, with some enlightening comments from executives at NBCU, Scripps and CBS.

* Apple TV+ has picked up a third season of Shrinking.

* The Food Network has announced its November holiday premiere schedule.

* OWN will premiere three original holiday movies in December.

* Adult Swim has greenlit seasons eleven and twelve of Rick and Morty. As a bit of perspective, season eight of the show isn't set to debut until 2025.

* Apple TV+ announced today that it has ordered a three-episode documentary that will highlight "all of the most powerful moments of the 2024 World Series." Although by "ordered," what Apple TV+ really means is that they publicly revealed its existence today, since the series is already in production. BTW, the project is produced in partnership with MLB and Imagine Documentaries (Apple’s The Dynasty: New England Patriots and The Super Models), R.J. Cutler’s This Machine (Apple TV's Billie Eilish: The World’s a Little Blurry, Dear…, Martha, Elton John: Never Too Late) and five-time World Series Champion, executive producer Derek Jeter, alongside his production company, Cap 2 Productions. 

* FX’s new documentary The New York Times Presents: Weight of the World follows "three people on their own GLP-1 journeys and explores how decades of diet culture and society's relentless pursuit of thinness paved the way for their rise." It premieres Friday, November 22nd on FX.

* Project Runway has been off the air since last year, but it is returning, albeit on a new network with a different on-air cast. The show will move to Freeform, with host and mentor Christian Siriano and judges Nina Garcia, fashion designer Brandon Maxwell and journalist Elaine Welteroth all exiting the show.

* Season two of Mayfair Witches is premiering January 5th, 2025 on AMC.

WHAT'S NEW TONIGHT AND TOMORROW

THURSDAY, OCTOBER 17TH:
* Brothers (Prime Video)
* Elsbeth Season Two Premiere (CBS)
* Georgie & Mandy's First Marriage Series Premiere (CBS)
* Ghosts Season Four Premiere (CBS)
* Gundam: Requiem For Vengeance Series Premiere (Netflix)
* Jurassic World: Chaos Theory Season Premiere (Netflix)
* Louder: The Soundtrack Of Change (Max)
* Love Stuck (Prime Video)
* My Professor's Deadly Secret (LMN)
* Outside (Netflix)
* Passenger (Britbox)
* Shane Smith Has Questions Series Premiere (Vice)
* Star Trek: Lower Decks Season Premiere (Paramount+)
* Superman & Lois Season Premiere (The CW) 
* The Devil's Climb (NatGeo)
* The Lincoln Lawyer Season Three Premiere (Netflix)
* The Midwich Cuckoos: Village Of The Damned (Acorn TV)
* The Pradeeps Of Pittsburgh Series Premiere (Prime Video) 
* The Shadow Strays (Netflix)
* Wicked City Season Premiere (ALLBLK)

FRIDAY, OCTOBER 18TH:
* Best Bite Wins Series Premiere (The Roku Channel)
* Blue Bloods Season Premiere (CBS)
* Culte Series Premiere (Prime Video)
* Fanatical: The Catfishing Of Tegan And Sara (Hulu)
* Fire Country Season Three Premiere (CBS)
* Happiness Is Series Premiere (Netflix)
* Happy's Place Series Premiere (NBC)
* Hysteria! Series Premiere (Peacock)
* It's Florida, Man Series Premiere (Max)
* LEGO Marvel Avengers: Mission Demolition (Disney+)
* Lopez vs. Lopez Season Three Premiere (NBC)
* MadS (Shudder)
* Rivals Series Premiere (Hulu)
* Self-Portrait As A Coffee-Pot Series Premiere (Mubi)
* Shark Tank Season Sixteen Premiere (ABC)
* S.W.A.T. Season Eight Premiere (CBS)
* The Devil's Hour (Prime Video)
* The Fabulous Lives Of Bollywood Wives Season Premiere (Netflix)
* The Man Who Loved UFOs (Netflix)
* The Park Maniac (Prime Video)
* The Turnaround (Netflix)
'* Twas the Date Before Christmas (Hallmark)
* Woman Of The Hour (Netflix)
* Yintah (Netflix)

SEE YOU ON FRIDAY!


8.688MBMemory Usage186msRequest 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" => 1743473475 "last" => 1743473475...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (6.37ms)
  • afterInitialise (1.27MB) (29.4ms)
  • afterRoute (227.03KB) (7.99ms)
  • beforeRenderComponent com_content (38.25KB) (1.14ms)
  • Before Access::preloadComponents (all components) (34.7KB) (981μs)
  • After Access::preloadComponents (all components) (109.3KB) (979μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (21μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (13.1ms)
  • Before Access::getAssetRules (id:3447 name:com_content.article.2614) (130.8KB) (214μs)
  • After Access::getAssetRules (id:3447 name:com_content.article.2614) (8.47KB) (160μs)
  • beforeRenderRawModule mod_related_items (Read More) (854.63KB) (56.88ms)
  • Before Access::getAssetRules (id:8 name:com_content) (79.64KB) (5.46ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (19μs)
  • afterRenderRawModule mod_related_items (Read More) (41.7KB) (6.94ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (10μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (228μs)
  • afterRenderComponent com_content (35.25KB) (106μs)
  • afterDispatch (3.53KB) (285μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (28.15ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (690μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (7μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (250μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (56μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (169μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (6μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (131μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (95μs)
  • afterRenderRawModule mod_finder (Head Search) (66.42KB) (4.49ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (223μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (85μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (446μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (141μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (30μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (122μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (133μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (32μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (192μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (129μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.51ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.53ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (125μs)
  • afterRender (689.13KB) (13.73ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (854.63KB) (30.63%)
    56.88ms
    1 x afterInitialise (1.27MB) (15.83%)
    29.40ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (15.16%)
    28.15ms
    1 x afterRender (689.13KB) (7.4%)
    13.73ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (7.06%)
    13.10ms
    1 x afterRoute (227.03KB) (4.3%)
    7.99ms
    1 x afterRenderRawModule mod_related_items (Read More) (41.7KB) (3.74%)
    6.94ms
    1 x afterLoad (528.29KB) (3.43%)
    6.37ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (79.64KB) (2.94%)
    5.46ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.42KB) (2.42%)
    4.49ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.9%)
    3.53ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.81%)
    1.51ms
    1 x beforeRenderComponent com_content (38.25KB) (0.62%)
    1.14ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.53%)
    981μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.53%)
    979μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.37%)
    690μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.24%)
    446μs
    1 x afterDispatch (3.53KB) (0.15%)
    285μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.13%)
    250μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.12%)
    228μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.12%)
    223μs
    1 x Before Access::getAssetRules (id:3447 name:com_content.article.2614) (130.8KB) (0.12%)
    214μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.1%)
    192μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.09%)
    169μs
    1 x After Access::getAssetRules (id:3447 name:com_content.article.2614) (8.47KB) (0.09%)
    160μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.08%)
    141μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.07%)
    133μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.07%)
    131μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.07%)
    129μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.07%)
    125μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.07%)
    122μs
    1 x afterRenderComponent com_content (35.25KB) (0.06%)
    106μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    95μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.05%)
    85μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    56μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    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.01%)
    10μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (Head Search) (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%)
    6μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    6μs
49 statements were executed, 3 of which were duplicates, 46 unique54.62ms547.27KB
  • SELECT @@SESSION.sql_mode;87μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?172μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1104μ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)4.46ms944BParams/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` = 1433μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`103μ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` = :guest291μ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`710μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'640μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC180μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1205μ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`586μ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`382μ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` = 1207μ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)640μ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.08ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.89ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2614'12.96ms48B/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)750μ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`504μ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)5.97ms5.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`613μ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 ASC507μ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.35ms58.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`520μ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.id166μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'173μ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.84ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid168μ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` = :muserid213μ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 ASC403μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'124μ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.06ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id191μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 52.8ms1.82KBParams/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 ASC974μs89.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)2.02ms5.59KBParams/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`387μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1567μ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)205μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration387μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'151μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field192μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'116μ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` = 1177μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?202μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?502μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy