Too Much TV: Your TV Talking Points For Wednesday, December 13th, 2023

Here's everything you need to know about the world of television for Wednesday, December 13th, 2023. 

A COUPLE OF THOUGHTS ABOUT THAT NETFLIX ENGAGEMENT REPORT
A shout out to Netflix, which dropped its new Netflix Engagement Report (complete with presentation to the press) on the day that I was offline. I appreciate it.

I read a number of attempts from reporters trying to parse the information yesterday, and there's no point for me to rehash any of that. So instead, here are a few thoughts about the numbers and how it helps people get a clearer indication of how Netflix does business:

1) The reason why you thought Netflix wasn't sharing more specific viewing numbers probably isn't correct

In recent years I have heard all sorts of theories about why Netflix continued to keep most viewing data private. Some people speculated that releasing total viewing numbers would show that many of the Netflix originals were overhyped and viewed a lot less than the industry conventional wisdom. Others argued that releasing the numbers would show Netflix has canceled some heavily-viewed shows for reasons that they couldn't express. It was generally some variation of the streamer not having faith in diverse casts or LGBTQ storylines.

But when you look at the just-released data, one of the things that becomes clear is that while about 45% of the viewing in the first six months of 2023 came from licensed titles, nine of the top ten most-watched seasons of television were Netflix originals. Which I suspect is a fact that likely surprises a lot of streaming industry analysts. I haven't seen any smoking guns in the Netflix data that would verify any of the various theories about why the company has kept so much data private. As much as anything, Netflix appears to have waited until it had the numbers that allowed it to tell the story they wanted told. Both to the industry and to investors.

2) Pure viewing numbers aren't the only metric for deciding whether or not a show is renewed. Often, it's not even the primary one

During the WGA and SAG-AFTRA strikes, I had some heated conversations with members who argued for more data transparency. "Without more data, we can't be properly compensated for our success!"

And while there is some truth to that, I responded by suggesting that simple viewing numbers was only of limited help when it came to trying to determine why one show lived and another one did not.

About 18 months ago, Netflix canceled the YA series The Baby-Sitters Club and at the there were complaints about the decision from the series showrunner, fans and just observers of the streaming space. But as I wrote at the time, Netflix's renewal decision making process takes a number of factors into consideration and the number of viewers is only part of the equation:

A primary Netflix metric is called the "adjusted view share," which is a combination of more than 30 factors that attempt to assign an overall "value" for any piece of content. An example I was given was that it's possible to track which content was most watched by brand new subscribers last month. That content would be considered more valuable because it presumably was one of the reasons why viewers subscribed. But if those viewers exit after a month or two, that lessens the value of the content. The assumption being that some percentage of the canceled subscriptions came from people who subscribed primarily for a specific show.

It depends on where people are watching. A show that is more popular in a region such as the U.S., where the ARPU (average revenue per user) is higher has a greater value than one that tracks more in regions where the ARPU is lower. Although that indicator is weighted less than some others and whether the content is attracting subscribers in a territory where subscriber retention costs are high also factors into the equation. Netflix also tracks how many people complete a TV show within a week, the percentage of people who rewatch a series (although if the number is too high, it's discounted as possible fan manipulation). And there are many more. Each of the factors is weighted differently and the weighting can apparently change as the company's strategy evolves.

I'm seeing a lot of people trying to use the Netflix Engagement Report as a way to determine whether a show deserved to be renewed or canceled. And while that viewer data is helpful, using it to determine value to Netflix is a bit like trying to determine how much money someone has in their pocket by tracking how fast they're walking.

3) Here's the reason why I think Netflix is using 'hours viewed' as their Engagement Report metric

I've read a number of different theories as to why Netflix is ranking programs by the hours viewed, as opposed to the "views" metric they use for their "Top Ten" and "Most Popular" lists.  Netflix define views for a title as the total hours viewed divided by the total runtime. And as it the case with the hours viewed metric, values in the views totals are rounded to 100,000.

After hearing from a couple of people inside Netflix today, I suspect it's in part because using hours viewed is a way to best way to parse viewer data if the company want to highlight the strength of its Originals slate - which seems to be a primary driver releasing this Engagement Report. 

The average Netflix original episode of a scripted drama runs somewhere between 15-18 minutes longer than the average episode of a typical licensed broadcast series. That views calculation offsets that difference but by listing hours viewed, the list essentially treats all episodes of all programs as if they had the same length. Which is a huge advantage for Netflix in this case.

It's also part of the reason to separate the shows by season, instead of lumping the entire series run into one line. Licensed shows tend to have longer seasons and more episodes in general. Listing programs by series run would put Netflix's originals at a real disadvantage.

One perfect example of this is the licensed series Suits, which currently has nine seasons streaming on Netflix. If you look at individual seasons, season one was the most-watched on Netflix during the timeframe, and it hit #67 on the list, with 129,100,00 hours viewed. But combining all nine seasons into one listing gives the show 599,100,000 hours viewed, landing it #4 on the list.

The strategy behind releasing the new Engagement Report was that Netflix wanted to remind Hollywood about the strength of it originals lineup. And one of the best ways to do that is by releasing data that frames the narrative the way you want it to be told.

ODDS AND SODS
* The 2023 Emmys have been moved from its customary September date to January 15th, 2024.

* The documentary series Alexander: The Making Of A God premieres Wednesday, January 31st, 2024 on Netflix.

* Season nine of MasterChef Junior premieres Monday, March 4th, 2023 on Fox.

* Hulu continues its cross-promotion of Disney+ content with the new series Percy Jackson And The Olympians

WHAT'S NEW TODAY AND TOMORROW:

WEDNESDAY, DECEMBER 13TH, 2023:
* Car Masters: From Rust To Riches Season Five Premiere (Netflix)
* If I Were Luísa Sonza (Netflix)
* In The Kitchen With Harry Hamlin: A Holiday Special (IFC)
* 1670 (Netflix)
* The Influencer Series Premiere (Netflix)
* Tierra Incognita (Disney+)

THURSDAY, DECEMBER 14TH:
* An Ice Palace Romance (Hallmark Movies Now)
* As The Crow Flies Season Two Premiere (Netflix)
* CMA Christmas Show (ABC)
* Dragons: The Nine Realms Season Premiere (Hulu/Peacock)
* Heaven Down Here (Hallmark Movies And Mysteries)
* My Killer Reunion (LMN)
* That Clip Show: Holiday Edition (NBC)
* The Crown Series Finale (Netflix)
* The Real Housewives Ultimate Girls Trip Season Premiere (Peacock)
* Yu Yu Hakusho Series Premiere (Netflix)

Click Here to see the list of all of the upcoming premiere dates for the next few months.

SEE YOU THURSDAY!

If you have any feedback, send it along to Rick@AllYourScreens.com and follow me on Twitter @aysrick.

9.017MBMemory Usage154msRequest 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" => 1745693869 "last" => 1745693869...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.49ms)
  • afterInitialise (1.27MB) (27.86ms)
  • afterRoute (227.09KB) (8.66ms)
  • beforeRenderComponent com_content (38.63KB) (1.14ms)
  • Before Access::preloadComponents (all components) (34.69KB) (1.02ms)
  • After Access::preloadComponents (all components) (109.3KB) (943μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (16μs)
  • After Access::preloadPermissions (com_content) (2.9MB) (9.24ms)
  • Before Access::getAssetRules (id:1800 name:com_content.article.977) (258.8KB) (174μs)
  • After Access::getAssetRules (id:1800 name:com_content.article.977) (8.47KB) (246μs)
  • beforeRenderRawModule mod_related_items (Read More) (1.01MB) (41.19ms)
  • Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (2.81ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (17μs)
  • afterRenderRawModule mod_related_items (Read More) (14.41KB) (5.74ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (9μs)
  • afterRenderModule mod_related_items (Read More) (4.07KB) (224μs)
  • afterRenderComponent com_content (43.56KB) (88μs)
  • afterDispatch (3.53KB) (274μs)
  • beforeRenderRawModule mod_menu (Newsletters) (156.52KB) (23.16ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (690μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (196μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (40μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (117μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (103μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (69μs)
  • afterRenderRawModule mod_finder (Head Search) (66.54KB) (3.32ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (5μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (170μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (53μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (334μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μ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) (79μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (89μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (24μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (126μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (95μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (56.7KB) (1.17ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (122.12KB) (2.75ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (5μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (88μs)
  • afterRender (675.84KB) (12.59ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (1.01MB) (26.81%)
    41.19ms
    1 x afterInitialise (1.27MB) (18.13%)
    27.86ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (156.52KB) (15.08%)
    23.16ms
    1 x afterRender (675.84KB) (8.2%)
    12.59ms
    1 x After Access::preloadPermissions (com_content) (2.9MB) (6.01%)
    9.24ms
    1 x afterRoute (227.09KB) (5.64%)
    8.66ms
    1 x afterLoad (528.29KB) (4.87%)
    7.49ms
    1 x afterRenderRawModule mod_related_items (Read More) (14.41KB) (3.74%)
    5.74ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.54KB) (2.16%)
    3.32ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (1.83%)
    2.81ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (122.12KB) (1.79%)
    2.75ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (56.7KB) (0.76%)
    1.17ms
    1 x beforeRenderComponent com_content (38.63KB) (0.74%)
    1.14ms
    1 x Before Access::preloadComponents (all components) (34.69KB) (0.66%)
    1.02ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.61%)
    943μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.45%)
    690μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.22%)
    334μs
    1 x afterDispatch (3.53KB) (0.18%)
    274μs
    1 x After Access::getAssetRules (id:1800 name:com_content.article.977) (8.47KB) (0.16%)
    246μs
    1 x afterRenderModule mod_related_items (Read More) (4.07KB) (0.15%)
    224μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.13%)
    196μs
    1 x Before Access::getAssetRules (id:1800 name:com_content.article.977) (258.8KB) (0.11%)
    174μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.11%)
    170μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.08%)
    126μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    117μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.07%)
    103μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.06%)
    95μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.06%)
    95μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    89μs
    1 x afterRenderComponent com_content (43.56KB) (0.06%)
    88μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.06%)
    88μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.05%)
    79μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    69μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.03%)
    53μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    40μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    24μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    21μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    9μ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_custom ([Offcanvas] Custom banner) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
48 statements were executed, 3 of which were duplicates, 45 unique29.77ms545.88KB
  • SELECT @@SESSION.sql_mode;104μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?143μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 177μ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)591μ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` = 1303μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`90μ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` = :guest154μ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'484μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC154μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1181μ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`669μ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`360μ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` = 1228μ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)606μ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.36ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.58ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '977'2.78ms48B/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)635μ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`435μ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.54ms5.22KBParams/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`437μ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 ASC412μ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.65ms58.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`446μ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.id147μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'163μ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 ordering144μ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` = :userid136μ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` = :muserid173μ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 ASC429μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'83μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5172μ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.03ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id133μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 5747μs1.82KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC1.06ms89.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.94ms5.42KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1280μ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)173μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration205μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'119μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field103μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'94μ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` = 1127μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?107μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?718μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy