Too Much TV: Your TV Talking Points For Tuesday, July 30th, 2024

Here's everything you need to know about the world of television for Tuesday, July 30th, 2024:

AN APPLE TV+ EXECUTIVE TALKS ABOUT BRANDING, CONTENT SPEND AND LICENSED MOVIES
There have been several stories over the past weeks arguing that Apple TV+ is cutting back and seems poised to move towards a more restrained streaming future. I decided to reach out to a source I've spoken with in the past to see if I could get a bit of insight. I was asked to describe the person as a "senior executive with direct knowledge of content strategy, but not one of the final decision-makers."

Reading some of the recent reporting about Apple TV+, I've been reminded of these comments from our last discussion earlier this year:

Q: But can you talk about what success does look like at Apple TV+? I think most outsiders could define what a successful business at Peacock or Max would look like. However, Apple TV+ and Amazon Prime are a lot more challenging because of the way they're integrated into the mothership business.

A: It's interesting that you brought up Amazon because although they have a very different business than we do, we both have similar challenges. The video business is graded both on how it is doing on a standalone business and also on how effectively it is contributing to the entire business. And that can be complicated to discern even on an internal basis.

I liked the point you made a week or two ago about the reasons why Prime Video is adding a surcharge to its new ad-free business. Because there isn't a separate fee for video, it's one of the few ways Amazon can drive more revenue for its video product without increasing the overall cost of its Prime product. All of that integration comes with its own challenges.

And we have similar challenges. Apple TV+ has a separate subscriber fee, but the integration with other Apple products is a mixed blessing. We're expected to drive business and revenue to the entire Apple ecosystem and that brings its own unique set of goals and roadblocks.

I don't think there is any major streaming service that isn't expected to carry its own weight. But how that success is defined does look very different, depending on the overall business model of the parent company.

I brought up those comments in our email discussion earlier today and that kicked off quite a back-and-forth on Apple TV+'s place in the streaming universe.

Do you still think a lot of people fundamentally misunderstand what success looks like for Apple TV+? I think people in the industry are beginning to realize that the success metrics for streaming aren't the same as for linear TV. But what do you think critics are getting wrong about Apple TV+ and the streaming TV business at large?

Wow, I almost don't know where to start. First of all, I would be skeptical when I read that we've spent X on original content. I know specifics on some of the budgets and have a good sense of the content spend overall and without getting into specifics, I'll just describe the published numbers as "somewhat informed best guesses." 

Part of the problem is that spending at any streaming service is more complicated than someone just cutting a check. There can be co-producing partners, or third-party producers can be responsible for more of the costs that outsiders might realize. I'm not minimizing the fact we spend a lot. But sometimes a figure gets out there and every reporter just runs with it.

Is it accurate to say that there is a belt-tightening going on at Apple TV+? 

Sure, and some of that is the function of our growth maybe not being where we had hoped. But it's also a reflection of the budget constraints at rival streamers. If they are getting more proactive about spending, then we would be insane to continue operating the way everyone was doing 18 months ago. This is a business that requires near-constant pivoting, but sometimes outsiders read too much into it.

One of the strategic moves that is receiving a lot of attention is Apple TV+'s move to license some outside movies for the service. That has led to all sorts of speculation about what comes next. What is your take on the move?

I hate these stories. Look, as far as I know - and I should know - no one here ever said "We're never licensing movies." What we did say is that we had no plans to do so early on and we were focused on our original slate. We did buy or license one-offs, but strategically it was more important to be seen as a home for distinctive programming. 

So what changed?

I mentioned before about constant pivoting and this is probably a good example. One way we can restrain spending is by taking advantage of select licensing opportunities. But if you notice, we're very strategic about the titles we're licensing. They tend to be familiar films, with familiar stars attached. If Paramount has a package of 100 films, there might only be 20-25 that we are interested in. So we'll carve those out into a separate non-exclusive package that has a limited run time. And that generally works for the people licensing the films, because they tend to prefer shorter licensing windows.

When it comes to licensing, we have more in common with Netflix than other platforms. Our licensing reinforces the Apple TV+ branding: star-driven, prestige movies. We're very on-point with the licensing deals and unless something drastically changes, you're not going to see us licensing films simply to juice the catalog size. That's why you haven't seen a big move yet into licensing TV shows. The titles that might be on brand for us are either tied up somewhere else or ones we can't license on the terms we need. 

I suspect even people working there would admit that subscriber growth hasn't been what the company hoped it would be. Is that something you can talk about?

It's a complex problem and I think that each service has its own unique set of issues. One unexpected challenge for us is that an amazing number of people think you somehow have to own a bunch of Apple devices to use Apple TV+. I had someone tell me they wanted to subscribe, but they only owned a Roku stick. It's tough because we want to keep people in the Apple universe and we would prefer they use something like an Apple TV. But I think that desire has sometimes gotten in the way of overall growth. But that's not my call.

In the coming year, you're going to see an increased emphasis on international growth as well as more telco partnerships. And while I don't have any first-hand knowledge about a timeline, I won't be surprised to see an ad-supported tier rollout. It helps maximize revenue from a smaller subscriber base and our demographics make the audience valuable. But I think Amazon's rate-cutting right now might push that timeline back a bit. 

Are you optimistic about the future?

I would be a terrible executive if I said no. But I am. We have a unique niche and while we can argue about content spend and strategic priorities. But we also have a strong brand and some of the best originals in the business.

ODDS AND SODS
*  CNN Originals has ordered the six-episode travel series  My Happy Place, featuring different celebrity hosts as “they venture to a personally meaningful place in their lives.” It is set to premiere next year.

* Disney+ has canceled Renegade Nell after one season.

* Apple TV+ has set the two-episode premiere date for the Spanish-language medical drama Midnight Family for Wednesday, September 25th. According to the streamer, "Midnight Family follows Marigaby Tamayo (Renata Vaca), an ambitious and gifted medical student by day, who spends her nights saving lives throughout a sprawling, contrasted and fascinating Mexico City aboard her family’s privately owned ambulance. Along with her father Ramón (Joaquín Cosío) and her siblings Marcus (Diego Calva) and Julito (Sergio Bautista), Marigaby serves a population of millions by tackling extreme medical emergencies to make a living."

* Erica Ash, the Mad TV alum who also starred in Real Husbands Of Hollywood and Survivor’s Remorse, has died after a long battle with cancer. She was 46.

* The Apple TV+ Spanish-language medical drama Midnight Family will premiere on November 20th. The series is based on the documentary of the same name and follows the story of a privately-owned family-run ambulance business.

* Acorn TV has renewed the Jane Seymour Irish mystery series Harry Wild for a fourth season.

* CBS Evening News anchor Norah O'Donnell announced today that she is leaving her anchor role after the 2024 presidential election to become a senior correspondent and host her own interview-style show that will air on CBS and Paramount+.

* The part three premiere of Netflix's That 90s Show has been moved up from to August 22nd from October 24th. I am assuming that means the show likely won't be renewed.

* 90 Day Fiance: Before The 90 Days returns for a new season premiering Sunday, September 1st on TLC.

* Hulu announced Tuesday it will release Fanatical: The Catfishing of Tegan and Sara, a new documentary investigating the 2011 file hacking of the musical duo Tegan and Sara. 

WHAT'S NEW TONIGHT AND TOMORROW

TUESDAY, JULY 30TH:
* Betrayal (Hulu)
* Frontline: Germany's Enemy Within (PBS)
* Grand Tour Of Switzerland Series Premiere (MHz Choice)
* Legendary Grand Hotels Series Premiere (MHz Choice)
* Murder In...Season Thirteen Premiere (MHz Choice)
* Under The Radar: Secrets Of A Swedish Serial Killer Series Premiere (Viaplay)

WEDNESDAY, JULY 31ST:
* Mountain Queen: The Summits Of Lhakpa Sherpa (Netflix)
* Ms. Pat Settles It Season Two Premiere (BET)
* Unsolved Mysteries Season Premiere (Netflix)
* Women In Blue (Las Azules) Series Premiere (Apple TV+)

SEE YOU ON WEDNESDAY


9.106MBMemory Usage172msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.32
Identityguest
Response200
Templateja_blockk
Database
Server
mysql
Version
8.0.39-cll-lve
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746677403 "last" => 1746677403...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.95ms)
  • afterInitialise (1.27MB) (31.43ms)
  • afterRoute (227.06KB) (9.32ms)
  • beforeRenderComponent com_content (38.63KB) (1.31ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.15ms)
  • After Access::preloadComponents (all components) (109.3KB) (999μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (20μs)
  • After Access::preloadPermissions (com_content) (2.93MB) (13.18ms)
  • Before Access::getAssetRules (id:3007 name:com_content.article.2178) (258.8KB) (250μs)
  • After Access::getAssetRules (id:3007 name:com_content.article.2178) (8.47KB) (289μs)
  • beforeRenderRawModule mod_related_items (Read More) (872.98KB) (47.73ms)
  • Before Access::getAssetRules (id:8 name:com_content) (81.12KB) (3.69ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (18μs)
  • afterRenderRawModule mod_related_items (Read More) (41.2KB) (7.23ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (11μs)
  • afterRenderModule mod_related_items (Read More) (4.07KB) (277μs)
  • afterRenderComponent com_content (51.5KB) (126μs)
  • afterDispatch (3.53KB) (371μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (25.6ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (569μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (187μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (41μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (118μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (105μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (71μs)
  • afterRenderRawModule mod_finder (Head Search) (66.42KB) (3.59ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (5μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (167μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (55μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (337μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (95μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (21μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (81μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (86μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (21μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (116μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (85μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.12ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (2.59ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (90μs)
  • afterRender (689.13KB) (9.99ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (872.98KB) (27.82%)
    47.73ms
    1 x afterInitialise (1.27MB) (18.32%)
    31.43ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (14.93%)
    25.60ms
    1 x After Access::preloadPermissions (com_content) (2.93MB) (7.69%)
    13.18ms
    1 x afterRender (689.13KB) (5.83%)
    9.99ms
    1 x afterRoute (227.06KB) (5.43%)
    9.32ms
    1 x afterLoad (528.29KB) (4.64%)
    7.95ms
    1 x afterRenderRawModule mod_related_items (Read More) (41.2KB) (4.21%)
    7.23ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (81.12KB) (2.15%)
    3.69ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.42KB) (2.09%)
    3.59ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.51%)
    2.59ms
    1 x beforeRenderComponent com_content (38.63KB) (0.77%)
    1.31ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.67%)
    1.15ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.65%)
    1.12ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.58%)
    999μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.33%)
    569μs
    1 x afterDispatch (3.53KB) (0.22%)
    371μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.2%)
    337μs
    1 x After Access::getAssetRules (id:3007 name:com_content.article.2178) (8.47KB) (0.17%)
    289μs
    1 x afterRenderModule mod_related_items (Read More) (4.07KB) (0.16%)
    277μs
    1 x Before Access::getAssetRules (id:3007 name:com_content.article.2178) (258.8KB) (0.15%)
    250μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.11%)
    187μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.1%)
    167μs
    1 x afterRenderComponent com_content (51.5KB) (0.07%)
    126μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.07%)
    118μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.07%)
    116μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    105μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.06%)
    95μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.05%)
    90μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.05%)
    86μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.05%)
    85μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.05%)
    81μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    71μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.03%)
    55μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    41μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    20μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    11μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    6μ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 (Off Canvas) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μ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
49 statements were executed, 3 of which were duplicates, 46 unique43.17ms543.24KB
  • SELECT @@SESSION.sql_mode;94μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?187μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 178μ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)622μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1366μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`123μ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` = :guest184μ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`615μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'2.44ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC198μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1227μ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`511μ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`317μ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` = 1249μ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)616μ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.73ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.62ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2178'9.5ms48B/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)832μs40.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`649μ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.64ms5.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`576μ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 ASC592μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC2.62ms58.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`488μ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.id201μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'181μ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 ordering188μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.12ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid193μ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` = :muserid205μ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 ASC409μ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=5198μ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.11ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id179μ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.06ms1.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.09ms65.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.21ms5.53KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `tvlfg_categories` AS `s` INNER JOIN `tvlfg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`399μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1580μ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)191μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration261μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'122μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field114μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'102μ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` = 1145μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?176μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?631μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy