Too Much TV: Your TV Talking Points For Wednesday, June 12th, 2024

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

I LOVE A GOOD TROLLING MOVE
Marketing television and/or streaming is expensive and to be honest, it's not always that successful. In a ideal world, a media company figures out some stunt that garners what is known as "earned media." Which is essentially free advertising. But coming up with an effective stunt that doesn't cost much but gets national or international attention is almost a unicorn effort.

So kudos to Netflix for its just-announced live special Chestnut vs. Kobayashi: Unfinished Beef. Just one day after the 16-time Nathan’s winner announced he would not be able to participate this year after inking a sponsorship agreement with Impossible Foods, Netflix announced the Labor Day special, which pits Chestnut against his long-time rival Takeru Kobayashi.

It is a perfect storm of trolling. Both eaters have been barred from the Nathan's competition and they last competed against each other in 2009, when Chestnut beat Kobayashi in a five hot dog sudden death eat-off.

The announcement of the special highlighted that the competition would feature "100% beef hot dogs," despite Chestnut's endorsement deal. I suspect that also opens up the possibility of a hot dog sponsor hoping to get in on a little Nathan's magic.

One testament to how smart the event is for marketing purposes is that when I received the press release announcing the special, I laughed out loud. And I suspect a lot of other people had the same reaction.

THE PROBLEM WITH BUNDLES
People in the TV industry love the idea of bundles. They have convinced themselves their customers want multiple streaming services bundled into one package, like some Frankenstein-like take on cable television.

The problem is that isn't what a lot of their customers are looking for in a bundle. 

Hub Research just issued the results of its latest "Battle Royale" study, which interviews with 3,000 US entertainment decision-makers age 18-74 and asks them questions about their bundling preferences. 



Here's what Hub has to say about the results:

In our April survey, respondents completed a “build your own bundle” exercise to find out which content and services they would combine if given the chance. First, we showed consumers a list of 16 potential bundle “ingredients” – everything from streaming subscriptions to high-speed internet to news aggregators, and even hardware subscriptions (like a game console or smart TV). Then we asked them to choose any 5 of those 16 to build their “ideal” bundle. Their choices ran the gamut of content and providers. Here’s what we discovered:

  • 71% included high-speed internet in their bundle. It was the most-requested ingredient of all 16 items.

  • 65% included Netflix. It was the only SVOD subscription to appear in the top 5.

  • An MVPD/vMVPD network bundle with live TV made the top 5 (40%) – but more people chose mobile phone service (52%) or a streaming music subscription (43%).

This is why Netflix is focusing so much of its attention on gaming. I don't know that the company believes it will be a huge gaming player anytime soon. But they recognize it's a space where they need to be. 

This also has to be bad news for industry analysts who have convinced themselves that consumers are looking for some consolidation in the SVOD business. I think it's becoming increasingly clear that David Zaslav's hope of combining Max with perhaps Peacock or Paramount+ isn't going to move the bar all that much. In a world where 65% of men asked choose Netflix as the only major must-have SVOD, how are the smaller services going to compete? The only way is to make themselves more indispensable, and that plan doesn't appear to be working all that well right now.

WHY CAN'T THEY FIX HULU LIVE TV'S DVR?
I've written before about the frustrating user experience that comes with the Hulu Live TV DVR service. For instance, it randomly refuses to allow me to stop recording a show, no matter how many times I try. I made the mistake of once recording an episode of Mom when it was airing on CBS and now every time CMT runs a marathon of episodes, they're all dumped onto my DVR. Yes, I just delete them and yes, the DVR has unlimited storage. But it's still annoying.

The latest wrinkle is what I've come to call the "Property Brothers Glitch." A few week's ago, I spotted a show titled Don't Hate Your House With The Property Brothers. I decided to record it, but when I went back to watch the episode, instead what I discovered was a random three-hour block of programming from the NFL Network. And now I can't stop the recordings, which just seem to be random two or three-hour blocks of programming from a variety of cable networks.  



All of this would be less annoying if it wasn't for the fact that Hulu's DVR problems have been going on for years.  And if the company has made any effort to improve things, it isn't obvious from the outside.

HAVE YOU HEARD OF KAI CENAT?
The definition of TV continues to expand in all sorts of unexpected ways, and I am trying to highlight some people you should know who might be off your radar.

Kai Cenat is a Twitch streamer who has won a number of "streamer of the year" awards since 2022 and last year became the most subscribed to Twitch streamer of all-time, with more than 300,000 subscribers. One of his things are these all-night sleepover streams, featuring celebrities like Nicki Minaj. He reportedly makes more than $20,000 a month for his streams and in February, became the first streamer to sign a deal with Nike.

If you're heard of him at all, it might be for the infamous 2023 Union Square Riot. In August, he announced a giveaway of Playstation 2's and gift cards in Manhattan's Union Square. The stunt drew thousand of followers and after the event spiraled into a riot, police arrested 65 people, including Cenat.

I mention all of this as a bit of background, because I noticed that Monday night's Sleepover Stream - which included Kevin Hart, Druski and Facetime appearance by LeBron James - set a new record for Cenat. The stream topped out at more than 720,000 concurrent viewers. Which is pretty impressive, no matter how you crunch the numbers.

There is a whole world of entertainment happening out there and the first legacy media company that figure out how to draw some of these people into their business model is going to make a fortune.

WHAT'S NEW TONIGHT AND TOMORROW

WEDNESDAY, JUNE 12TH:
* King Of Collectibles: The Goldin Touch Season Two Premiere (Netflix)
* My Next Guest Needs No Introduction With David Letterman (Netflix)
* Mysteries Of The Terracotta Warriors (Netflix) - [first look video]
* Presumed Innocent (Apple TV+) - [first look video]
* Real Estate King Series Premiere (fyi)

THURSDAY, JUNE 13TH:
* Alone Season Eleven Premiere (History)
* Blue Lights Season Two Premiere (Britbox)
* Bridgerton Season 3b Premiere (Netflix)
* Brats (Hulu)
* Death Down The Aisle (LMN)
* Doctor Climax Series Premiere (Netflix)
* Faithful Planet Series Premiere (Curiosity Stream)
* Hannah Einbinder: Everything Must Go (Max)
* The Boys Season Four Premiere (Prime Video)
* The Dirty D (Peacock)


SEE YOU ON THURSDAY!

8.651MBMemory Usage229msRequest 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" => 1743542785 "last" => 1743542785...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (5.32ms)
  • afterInitialise (1.27MB) (63.27ms)
  • afterRoute (227.06KB) (8.62ms)
  • beforeRenderComponent com_content (38.25KB) (1.07ms)
  • Before Access::preloadComponents (all components) (34.7KB) (940μs)
  • After Access::preloadComponents (all components) (109.3KB) (1.15ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (18μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (11.42ms)
  • Before Access::getAssetRules (id:2778 name:com_content.article.1949) (130.8KB) (242μs)
  • After Access::getAssetRules (id:2778 name:com_content.article.1949) (8.47KB) (271μs)
  • beforeRenderRawModule mod_related_items (Read More) (849.73KB) (54.56ms)
  • Before Access::getAssetRules (id:8 name:com_content) (82.34KB) (5.03ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (24μs)
  • afterRenderRawModule mod_related_items (Read More) (12.84KB) (6.73ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (12μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (238μs)
  • afterRenderComponent com_content (43.31KB) (118μs)
  • afterDispatch (3.53KB) (298μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (36.39ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (718μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (260μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (54μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (161μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (132μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (99μs)
  • afterRenderRawModule mod_finder (Head Search) (66.47KB) (9.82ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (10μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (265μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (87μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (416μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (135μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (30μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (347μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (7μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (144μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (31μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (189μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (120μ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) (7μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (123μs)
  • afterRender (681.13KB) (14.87ms)
  • 1 x afterInitialise (1.27MB) (27.61%)
    63.27ms
    1 x beforeRenderRawModule mod_related_items (Read More) (849.73KB) (23.81%)
    54.56ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (15.88%)
    36.39ms
    1 x afterRender (681.13KB) (6.49%)
    14.87ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (4.98%)
    11.42ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.47KB) (4.29%)
    9.82ms
    1 x afterRoute (227.06KB) (3.76%)
    8.62ms
    1 x afterRenderRawModule mod_related_items (Read More) (12.84KB) (2.94%)
    6.73ms
    1 x afterLoad (528.66KB) (2.32%)
    5.32ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (82.34KB) (2.2%)
    5.03ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.49%)
    3.42ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.67%)
    1.52ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.5%)
    1.15ms
    1 x beforeRenderComponent com_content (38.25KB) (0.46%)
    1.07ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.41%)
    940μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.31%)
    718μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.18%)
    416μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.15%)
    347μs
    1 x afterDispatch (3.53KB) (0.13%)
    298μs
    1 x After Access::getAssetRules (id:2778 name:com_content.article.1949) (8.47KB) (0.12%)
    271μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.12%)
    265μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.11%)
    260μs
    1 x Before Access::getAssetRules (id:2778 name:com_content.article.1949) (130.8KB) (0.11%)
    242μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.1%)
    238μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.08%)
    189μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.07%)
    161μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    144μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.06%)
    135μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    132μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.05%)
    123μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.05%)
    120μs
    1 x afterRenderComponent com_content (43.31KB) (0.05%)
    118μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    99μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.04%)
    87μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    54μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    12μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
48 statements were executed, 3 of which were duplicates, 45 unique68.02ms565.98KB
  • SELECT @@SESSION.sql_mode;108μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?197μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1110μ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)26.4ms944BParams/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` = 1521μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`125μ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` = :guest247μ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`802μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'2.06ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC266μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1271μ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`706μ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`383μ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` = 1307μ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)698μ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.92ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.07ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1949'2.06ms48B/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)1.03ms24.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`555μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)2.36ms5.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`692μ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 ASC676μ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.19ms58.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`1.07ms5.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.id185μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'185μ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 ordering209μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.55ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid213μ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` = :muserid230μ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 ASC1.03ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'132μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51107μ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.2ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id176μ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.6ms1.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.35ms113.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.1ms5.44KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1902μ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)420μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration299μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'167μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field157μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'134μ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` = 1170μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?146μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?523μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy