Too Much TV: Your TV Talking Points For Wednesday, January 3rd, 2024

Here's everything you need to know about the world of television for Wednesday, January 3rd, 2023. 

SHORT TV SEASONS ARE OKAY. REALLY.
There are certain topics that fall into the sweet spot of easy to write and likely to be shared a lot. Because when you're writing something that plays into readers preconceived notions, you're on your way to creating a clickfest.

One topic that definitely falls into the clickbait category is writing a piece arguing that streaming platforms need to release more original shows with 20 or more episodes. An idea that sounds reasonable at first glance. 

For instance, The AV Club's Kaleigh Dray makes that very argument today and I must have had a dozen people send it to me today. It's exactly what you would expect, which is either great or terrible, depending on your perspective:

Well, sometimes it would be nice to be able to relax while watching a series, rather than panicking that we’re going to miss a teeny yet oh-so-significant detail in one of those every-second-counts episodes. Because, seriously, every second counts. There’s no time to even glance away, not even to suss out where the bowl of snacks is balanced on the sofa, because that’ll be when a metaphorical Easter egg will roll across the screen. Gah.

This burning desire for a little TV-induced R&R likely comes from the fact that we’ve been eyeball-deep in a nostalgia rut of late. (Yes, we’ve been streaming our favorite ’90s and ’00s series like nobody’s business. What of it?). And, honestly, almost all of these shows enjoy such lovely long season runs, which means that the stakes aren’t always the highest. In fact, you can usually get away with missing the odd episode if you fancy it, because the next episode will always give you a 30-second recap regardless—and maybe even a longer one, depending on how much shit has gone down.

And this just seems like a crazy argument. We want more shows that are casually written and have episodes you can miss if you need to?

But here is the biggest problem with the "shows should have 20+ episode season" argument. People who make it always cite the most successful shows in history as examples of what TV should look like. But Friends or NCIS are not the norm - even on broadcast television. Yes, Seinfeld had a lot of episodes. But so did Coach

And that's the thing about nostalgia. We tend to best remember the highlights. TV fans wax poetic about the great stand-alone episode of The X-Files. But no one is saying "Oh, remember those four episode of NCIS: Los Angeles when it focused on finding someone a new apartment?"

Streaming TV has a lot of challenges and there a number of things I would change. But the argument for longer seasons is a fun, but pointless dead end.

SPEAKING OF JUNK ARGUMENTS
Apparently I am beginning 2024 in a cranky mood. But I continue to push back against weak arguments and bad metrics because we live in a world where most of what you read in the entertainment press is aggregated from other sites. So one badly-framed piece can end up being aggregated on dozens of other sites. And once readers see a story referenced in enough places, they'll believe the argument, even if it's later disproven.

NextTV posted a piece early Wednesday with the provacative title "Netflix Viewing Declined By 17% in 2023." And as you might imagine, the story has been popping up all over the entertainment news industrial complex throughout the day. In part, because you can never go wrong writing a story that makes Netflix look bad.

The subhead on the story certainly sounds authoritative: "Based on Netflix's own data, viewers spent over 7 billion hours less last year watching the platform than they did in 2022." Wow, based on Netflix's own data? Tell me more!

The comparison was made using data from Netflix's weekly "Global Top 10" rankings. And as you might suspect, that is not exactly the most precise way to calculate total viewing data. Because while it's true that the majority of viewing on any streamer is concentrated in the top titles, there's no way to know what is going on outside of that top ten. And those differences can skew the year-on-year data to the point of being useless.

But there are bigger problems with the comparison, which NextTV admits in the article:

Around the time of our June report, Netflix tweaked its metrics, ranking shows based not on total engagement but on number of "views." This skewed direct YoY comparisons, but the shows that wind up at the top of Netflix's rankings are still those that command the most viewing hours.

So...it would be more accurate to have the headline read "Netflix Viewing Of Top Ten Shows Declined 17% In 2023"?

And then there is this disclaimer:

Netflix wouldn't comment to Next TV on this story. But an individual familiar with company's metrics said that, because the streamer now considers views as the primary qualifier -- rather than watch-time -- the datasets are incomparable.

And while it is true that the new methodology could result in the faulty omission -- or inclusion -- of shows that could skew the data, according to Netflix, over 60% of titles released by the streamer made one of its four weekly top 10 rankers, demonstrating that comparing year-over-year iterations of these lists provides some indicator of how Netflix's overall viewership performance is trending.

Which may be why the article then veers into some word salad discussion about subscriber numbers and password crackdowns. Neither of which would have any real impact on viewing numbers:

“Most of their new subs, especially in the U.S., are from password sharers transitioning to paying subs because of Netflix's account-sharing lockdown,” noted Evan Shapiro, a TMT analyst. “So far, this hasn't increased churn for Netflix. But they did just raise their prices. If their viewing continues to fall, I would expect more subscribers to cancel more often."

But, as the article notes, Netflix is adding subscribers. And if there was indeed a drop in viewing hours, there is no way to know which group of subscribers is leading that change. 

These are the stories that frustrate me. Badly framed pieces that hit some viral sweet spot. Suddenly a bad premise is everywhere and once that happens, it's embedded in everyone's memories forever.

ODDS AND SODS
* After a WGA protest, the Television Academy and Fox reverse an earlier plan and return the Emmy for variety series outstanding writing to the Emmys telecast

* I'll have more to say about this in the coming days. But it's worth noting that while some networks have been paring back their TV Everywhere apps or shutting them down completely, ABC has added 20 FAST channels to its TV Everywhere app and ABC.com. The channels are free to everyone and while most of them are similar to ones you'll find elsewhere - themed channels built around shows such as Wicked Tuna and Press Your Luck - they've also added a 24-hour-a-day ESPN8: The Ocho. A goofball channel that is tempting enough that I'll have to check it out ASAP.

* I also write a five-day-a-week morning wrap-up of important global TV stories and sometimes I run across random facts I have no space to use. For instance, today I learned that the most watched TV series on the Spanish SVOD FilmIn in 2023 was the show Doctor In Alaska. Which turns out to be an alternative name for reruns of the 1990s series Northern Exposure.

TWEET OF THE DAY



WHAT'S NEW TONIGHT AND TOMORROW

WEDNESDAY, JANUARY 3RD:
*Bottom-Tier Character Tomozaki (Crunchyroll)
*Classroom Of The Elite (Crunchyroll)
*Delicious In Dungeon Series Premiere (Netflix)
*I Can See Your Voice Season Premiere (Fox)
*Ishura Series Premiere (Hulu)
*Sistas Season Premiere (BET)
*We Are Family Series Premiere (Fox)

THURSDAY, JANUARY 4TH:
*Barnwood Builders Season Premiere (Magnolia)
*Boy Swallows Universe Series Premiere (Netflix)
*Reyka (Britbox)
*Casey Anthony's Parents Speak: The Lie Detector Test (A&E)
*Daughters Of The Cult (Hulu)
*Delicious In Dungeon Series Premiere (Netflix)
*Dying For Fame (LMN)
*General Hospital: 60 Years Of Stars And Storytelling (ABC)
*Hudson & Rex (UP tv)
*One Night Stay (BET+)
*Reyka (Britbox)
*Sanctuary: A Witch's Tale Series Premiere (Sundance Now)
*Society Of The Snow (Netflix) - [first look video]
*Swamp Mysteries With Troy Landry Series Premiere (History)
*Swamp People Season Premiere (History)
*The Bachelor: The Golden Wedding (ABC)
*The Brothers Sun Series Premiere (Netflix)
*The First 48 Season Premiere (A&E)
*The Power Of Film (TCM)

SEE YOU THURSDAY!

9.061MBMemory Usage451msRequest 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" => 1746708102 "last" => 1746708102...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (11.67ms)
  • afterInitialise (1.27MB) (241ms)
  • afterRoute (227.06KB) (18ms)
  • beforeRenderComponent com_content (38.63KB) (1.32ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.14ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.22ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (18μs)
  • After Access::preloadPermissions (com_content) (2.93MB) (13.56ms)
  • Before Access::getAssetRules (id:1896 name:com_content.article.1073) (258.8KB) (222μs)
  • After Access::getAssetRules (id:1896 name:com_content.article.1073) (8.47KB) (271μs)
  • beforeRenderRawModule mod_related_items (Read More) (846.41KB) (80.85ms)
  • Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (3.34ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (18μs)
  • afterRenderRawModule mod_related_items (Read More) (14.41KB) (6.51ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (12μs)
  • afterRenderModule mod_related_items (Read More) (4.07KB) (256μs)
  • afterRenderComponent com_content (43.5KB) (88μs)
  • afterDispatch (3.53KB) (295μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (30.68ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (633μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (227μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (53μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (148μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (6μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (120μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (90μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (4.23ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (251μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (80μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (470μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (131μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (27μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (106μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (115μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (28μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (189μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (117μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.54ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (15.25ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (13μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (149μs)
  • afterRender (685.13KB) (15.1ms)
  • 1 x afterInitialise (1.27MB) (53.51%)
    241.37ms
    1 x beforeRenderRawModule mod_related_items (Read More) (846.41KB) (17.92%)
    80.85ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (6.8%)
    30.68ms
    1 x afterRoute (227.06KB) (3.99%)
    18.00ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.38%)
    15.25ms
    1 x afterRender (685.13KB) (3.35%)
    15.10ms
    1 x After Access::preloadPermissions (com_content) (2.93MB) (3.01%)
    13.56ms
    1 x afterLoad (528.29KB) (2.59%)
    11.67ms
    1 x afterRenderRawModule mod_related_items (Read More) (14.41KB) (1.44%)
    6.51ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (0.94%)
    4.23ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (0.74%)
    3.34ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.34%)
    1.54ms
    1 x beforeRenderComponent com_content (38.63KB) (0.29%)
    1.32ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.27%)
    1.22ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.25%)
    1.14ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.14%)
    633μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.1%)
    470μs
    1 x afterDispatch (3.53KB) (0.07%)
    295μs
    1 x After Access::getAssetRules (id:1896 name:com_content.article.1073) (8.47KB) (0.06%)
    271μs
    1 x afterRenderModule mod_related_items (Read More) (4.07KB) (0.06%)
    256μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.06%)
    251μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.05%)
    227μs
    1 x Before Access::getAssetRules (id:1896 name:com_content.article.1073) (258.8KB) (0.05%)
    222μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.04%)
    189μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.03%)
    149μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.03%)
    148μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.03%)
    131μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.03%)
    120μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.03%)
    117μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.03%)
    115μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.02%)
    106μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.02%)
    90μs
    1 x afterRenderComponent com_content (43.5KB) (0.02%)
    88μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.02%)
    80μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.01%)
    53μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    27μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0%)
    18μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    13μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (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%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
48 statements were executed, 3 of which were duplicates, 45 unique309ms545.9KB
  • SELECT @@SESSION.sql_mode;96μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?140μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1122μ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)85.62ms944BParams/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` = 1891μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`344μ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` = :guest380μ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`797μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'50.6ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC24.18ms2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1410μ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`685μ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`432μ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` = 1271μ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)686μ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.54ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.33ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1073'41.13ms48B/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)773μ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`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.33ms5.23KBParams/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`688μ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 ASC528μ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.43ms58.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`605μ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.id208μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'186μ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 ordering210μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.69ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid203μ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` = :muserid249μ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 ASC476μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'122μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51102μ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.48ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id173μ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 5839μ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.23ms89.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.22ms5.42KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1580μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `tvlfg_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)215μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration366μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'165μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field151μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'138μ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` = 1186μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?163μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?73.14ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy