Too Much TV: Your TV Talking Points For Tuesday, August 20th, 2024

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

A COUPLE OF SHOWS TO PUT ON YOUR RADAR
If you're looking for something a bit off the radar to watch this week, I have a couple of suggestions:

* The Tyrant (Hulu)
It isn't often that I finish watching a series and think to myself "Wow, I like a lot of things in this show, but I have absolutely no clue what I just watched." But that was certainly the case with this four-episode South Korean series that premiered on Hulu last week.

I was originally attracted to the show because it is helmed by Park Hoon Jung, who was able to create complex worlds that blurred the lines between good and evil in previous projects such as V.I.P and The Witch. The Tyrant also has that same stylish look wrapped in a lot of unsettling plot uncertainty. And in fact, parts of the plot of The Tyrant may or may not be set in the world of The Witch. I might be able to answer at least that question if I had a clue about what was going on in The Tyrant.

From what I can tell Jo Yoon So plays Ja Kyung, a killer for hire (maybe?) who also has a dissociative personality disorder that has her sharing her body with her twin brother. Kim Seon-ho returns to TV for the first time since Hometown Cha-Cha-Cha playing the Director Choi of Korea’s National Intelligence Service (NIS) and he goes rogue after some super soldier program he is running is lost during delivery. There are multiple intelligence agencies shooting it out - including one that is supposedly American - while Ja Kyung strolls through the landscape killing people in some admittedly entertaining ways. 

Then the final minutes of the four-episode series include a flashback which pretty much made the previous four hours even more confusing. A task I thought was impossible at that point. 

The weird thing is that I enjoyed The Tyrant, even with the grandmaster level amount of ambiguity. It's a stylish, often incomprehensible series. But it also engaged me in a way that I appreciated. It's not for everyone - especially since it's subtitled but not dubbed into English. I can't say that I can recommend it exactly. But it might be worth checking out if South Korean spy noir is your thing. Here is a look at the trailer, which honestly makes the show seem a lot more coherent than it feels while you're watching it.

* Cursed Gold: A Shipwreck Scandal (NatGeo)
I'll have a full review of this up tomorrow on AllYourScreens when it premieres, but if you're a fan of true crime stories (or even tales of treasure hunting) with one insane twist after another, this will be right in your sweet spot. 

A scientist named Tommy Thompson became obsessed with tracking down the location of the famous 1857 shipwreck SS Central America, which was reported to be carrying three tons of gold when it sunk during a storm. The machinations Thompson went through to locate it (and convince people to invest in his idea) was one challenge. But you won't be surprised to learn that finding the gold in 1989 led to a cascading series of events that left Thomson an international fugitive headed for jail. It's a fun watch and at three episodes, there isn't a lot of filler.

THE CASE AGAINST MERGERS
The mysteriously-named Entertainment Strategy guy writes a must-read newsletter as well as a column the The Ankler. And while I don't always agree with him (most notably on the case for the value of doing theatrical releases for more streaming movie titles), he's one of those people who puts together such a good case that it forces me to up my game if I disagree with him. 

ESG posted a piece today about the need for the Hollywood Unions to step up and use their political pressure to oppose further large mergers and acquisitions in the entertainment sector. And I think he makes a good point:

So that’s my recommendation to Hollywood workers: influence the current administration by any means necessary. Specifically…

  • Make the case online. The Harris campaign reads Twitter. If many Hollywood celebrities advocate for breaking up Hollywood/Big Tech, they’ll listen.

  • The unions need to put out specific policy positions advocating for more competition in Hollywood across the board.

  • Hollywood talent should fundraise for the campaign, but make sure antitrust is on the agenda.

  • Advocate for FTC Chair Lina Khan and DoJ Antitrust head Jonathan Kanter to keep their jobs too.

At the height of the strikes, Hollywood talent spoke with remarkable unanimity on the need for reforms to help talent and workers. I think they could unite again, and strategically, that’s what they should do.

And while ESG is right about the fact that Hollywood's biggest media analysts spend a lot more listening to Wall Street than the media industry's employees, I have to push back a bit about his statement that no one agrees with his thoughts about industry mergers:

As I laid out last week, I think that the best way to improve Hollywood is to make it more competitive. Full stop.

Raise your hand if you agree with me.

Okay, keep your hand up if you also host/write/record a newsletter/column/podcast?

Anyone?

It certainly isn’t the people I listen to around town. When I read articles or newsletters from almost every other reporter/pundit/analyst in Hollywood, to be clear, I don’t read anyone who agrees with me.

I can only speak for myself, but I've been very vocal about my distrust of mergers that seem to be more about extracting fees and shifting around debt than improving the future of the affected companies. I've been covering media mergers since the days of the AOL/Time Warner merger. And they have almost always turned out to be a financial disappointment if not a disaster. Merging two struggling companies doesn't turn everything into one vibrant success. It is more likely to result in a lots of layoffs, some executive golden chute payouts and a slightly bigger company that is still struggling.

AD BREAK


For a limited time, Paramount+ annual plans start at $29.99/yr. That’s like $2.50/mo for 12 months. Cancel anytime, effective at end of billing cycle. New & former subscribers only. 18+. T&Cs apply. Offer only valid through this link

STREAMING IS NOT LINEAR TV, PART 226
I am old enough that I remember working in digital news back in the day when it was still some new fangled thing that most legacy print publications still thought of as a fad or at most, a brand extension of their traditional business. 

It was a frustrating time to be in the business, especially because that fundamental misunderstanding of digital news led those old media organizations to make key decisions that would come back to haunt them. Like, for instance, not training readers early on that they were going to have to pay for digital access. 

I see that trend a lot in the television and movie industries. Many incredibly smart people don't understand the economics of streaming. And it's their fault, because to be honest, I've talked to plenty of executives who grew up in the linear TV world who don't understand it either. But it's frustrating for me, because we can't solve the problems Hollywood is going through right now unless we agree on the fundamental framework we are working under.

I spent hours last night on the social media site formerly known as Twitter going back and forth with people who disagreed with this tweet:



And I have this disagreement with people on the creative side all of the time. I understand why they think television should revert back to the 22-24 episode broadcast and cable model that was the industry standard even ten years ago. But it's just not economically justifiable for linear TV networks to do that anymore. A collapsing audience, fewer places to syndicate successful shows, and rising production costs just make it impossible. Even on the broadcast side, you are seeing an increase in 13-episode seasons coupled with reductions in cast size. And it's the same scenario in what is left of cable television.

It's the same situation when it comes to streaming, although the economic incentives are different. While linear television is governed by ratings (and to a lesser extent, costs), the primary incentives in streaming are to lower subscriber acquisition costs as much as possible while also retaining as many subscribers as possible for as long as possible. While it varies by streamer, the general rule of thumb is that once you hit the 6-8 month subscription timeframe, you're finally making money off the subscriber. 

So how many viewers is important. But it's even more important to have the right viewers. A show that attracts new subscribers and/or helps retain current subscribers is more important to a streamer than a super popular show that doesn't spawn subscriber engagement. As an example, while this piece of mine is a couple of years old, it lays out some of the parameters of this.

And yet, so many people in the industry refuse to believe it. They point to the success of a show such as Suits on Netflix and say "See! Netflix should order shows with longer seasons, this is what people want!" But this comparison isn't even apples to oranges. It's more like apples to coffee tables. Yes, Suits was popular. But it was also a show that was successful during its original run, making it much more likely audiences would watch it in 2024. It's an old enough show that many younger viewers hadn't seen it and Netflix was able to license it at a reasonable price. None of that corresponds to order more episodes of an untried original series.

It's also important to note that streaming executives will tell you that longer episodes don't translate into increased subscriber engagement. While many people in Hollywood don't want to believe it, three new originals with eight-episode seasons are better for subscriber numbers than one show with 24 episodes. Especially because three different shows provides more of a chance you'll have one that breaks out with audiences. 

And yet, many people just refuse to believe any of this is true.....

TWEET OF THE DAY



ODDS AND SODS
* So Pop Crave is at the DNC this week.

WHAT'S NEW TONIGHT AND TOMORROW

TUESDAY, AUGUST 20TH:
* Divided By Design Series Premiere (HGTV)
* Face To Face With Scott Peterson (Peacock)
* Langston Kerman: Bad Poetry (Netflix)
* Spiral Season Eight Premiere (MHz Choice)
* Terror Tuesday: Extreme (Netflix)
* TouTouYouTou Series Premiere (MHz Choice)
* Untold: The Murder Of Air McNair (Netflix)

WEDNESDAY, AUGUST 21ST:
* Back To 15 (Netflix)
* Cursed Gold: A Shipwreck Scandal (NatGeo)
* Icons Unearthed: Harry Potter (Vice)
* Like A Girl (Fuse)
* Nice Girls (Netflix)
* PBS News Special: Democratic National Convention (PBS)
* Pop Star Academy: KATSEYE Series Premiere (Netflix)
* The Accident Series Premiere (Netflix)
* Time Bandits Season One Finale (Apple TV+)
* Wyatt Earp And The Cowboy War (Netflix)


SEE YOU ON WEDNESDAY!

8.692MBMemory Usage290msRequest 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" => 1743469745 "last" => 1743469745...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (5.23ms)
  • afterInitialise (1.27MB) (68.82ms)
  • afterRoute (227.03KB) (15.46ms)
  • beforeRenderComponent com_content (38.63KB) (835μs)
  • Before Access::preloadComponents (all components) (34.7KB) (862μs)
  • After Access::preloadComponents (all components) (109.3KB) (789μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (19μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (7.29ms)
  • Before Access::getAssetRules (id:3097 name:com_content.article.2268) (130.8KB) (119μs)
  • After Access::getAssetRules (id:3097 name:com_content.article.2268) (8.47KB) (165μs)
  • beforeRenderRawModule mod_related_items (Read More) (858.31KB) (44.48ms)
  • Before Access::getAssetRules (id:8 name:com_content) (82.48KB) (4.35ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (16μs)
  • afterRenderRawModule mod_related_items (Read More) (40.32KB) (6.97ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (11μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (271μs)
  • afterRenderComponent com_content (35.31KB) (116μs)
  • afterDispatch (3.53KB) (315μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (63.16ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (659μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (252μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (52μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (159μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (166μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (91μs)
  • afterRenderRawModule mod_finder (Head Search) (66.42KB) (6.51ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (246μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (106μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (431μ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) (29μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (111μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (121μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (28μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (210μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (122μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.52ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.42ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (8μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (131μs)
  • afterRender (689.13KB) (55.47ms)
  • 1 x afterInitialise (1.27MB) (23.75%)
    68.82ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (21.8%)
    63.16ms
    1 x afterRender (689.13KB) (19.15%)
    55.47ms
    1 x beforeRenderRawModule mod_related_items (Read More) (858.31KB) (15.35%)
    44.48ms
    1 x afterRoute (227.03KB) (5.34%)
    15.46ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (2.52%)
    7.29ms
    1 x afterRenderRawModule mod_related_items (Read More) (40.32KB) (2.41%)
    6.97ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.42KB) (2.25%)
    6.51ms
    1 x afterLoad (528.66KB) (1.81%)
    5.23ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (82.48KB) (1.5%)
    4.35ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.18%)
    3.42ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.52%)
    1.52ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.3%)
    862μs
    1 x beforeRenderComponent com_content (38.63KB) (0.29%)
    835μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.27%)
    789μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.23%)
    659μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.15%)
    431μs
    1 x afterDispatch (3.53KB) (0.11%)
    315μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.09%)
    271μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.09%)
    252μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.08%)
    246μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.07%)
    210μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    166μs
    1 x After Access::getAssetRules (id:3097 name:com_content.article.2268) (8.47KB) (0.06%)
    165μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.05%)
    159μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.05%)
    141μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.05%)
    131μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.04%)
    122μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.04%)
    121μs
    1 x Before Access::getAssetRules (id:3097 name:com_content.article.2268) (130.8KB) (0.04%)
    119μs
    1 x afterRenderComponent com_content (35.31KB) (0.04%)
    116μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.04%)
    111μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.04%)
    106μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.03%)
    91μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    52μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    19μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    11μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (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 (Other Content) (720B) (0%)
    5μs
49 statements were executed, 3 of which were duplicates, 46 unique62.24ms571.26KB
  • SELECT @@SESSION.sql_mode;3.96ms1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?156μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 184μ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)1.29ms944BParams/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` = 1408μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`168μ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` = :guest253μ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`623μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'7.55ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC209μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1196μ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`504μ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`369μ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` = 1250μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39)497μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 03.56ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.56ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2268'15.11ms48B/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)516μ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`381μ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.51ms5.27KBParams/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`388μ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 ASC411μ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.25ms58.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`472μ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.id123μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'122μ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 ordering137μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.35ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid133μ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` = :muserid144μ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 ASC340μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'74μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5159μ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`803μs2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id162μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3 OR `a`.`metakey` LIKE :preparedArray4 OR `a`.`metakey` LIKE :preparedArray5)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 52.29ms1.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.18ms113.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.8ms5.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`489μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 12.15ms976B/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)251μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration317μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'168μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field144μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'133μ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` = 1185μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?178μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?5.83ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy