Too Much TV: Your TV Talking Points For Thursday, January 4th, 2024

Here's everything you need to know about the world of television for Thursday, January 4th, 2023. 

DOES BRANDING MATTER IN THE STREAMING VIDEO BUSINESS?
Branding businesses is a complex calculation and how much branding matters to your business depends on part on what you're selling. If you're selling lightbulbs, branding is not so important. If you're selling hamburgers, what potential customers think about your brand matters a lot.

And after covering the streaming video business since its inception, I get the sense that when it comes to branding a platform, a lot more attention is paid to fonts and taglines than some of the nuts-and-bolts branding decisions that are a high priority in other industries. Top executives don't seem to have a real sense of how branding works, other than a bit of "wow, our studio sure has a long history, huh?"

But one of the reasons why branding is important is because it can help provide value to the streamer. I have written a great deal in recent years about the idea of a streaming service's "perceived value." Simply put, perceived value is a customer's opinion of a product's value to him or her. It may have little or nothing to do with the product's market price, and depends on the product's ability to satisfy his or her needs or requirements. In other words, a streaming service is worth what most customers consider to be a fair price for what they're receiving when they subscribe.

There are a lot of factors that influence that perceived value and one of them is the streamer's library. The size, the content mix, the freshness. It's a mushy metric, but it really gets down to the ability of a streamer to answer the subscriber's question about whether the platform has enough of the right shows and movies.

One place content availability and branding cross is when it comes to content a service is expected to have. Peacock spent a relatively insane amount of money for the U.S. rights to The Office. Because their calculation was that the show was one of those core programs subscribers would expect to see on the service. Whether or not they intended to watch episodes any time soon.

Which is why I was interested to see that Paramount Global has licensed its roster of Star Trek movies to Max. And they have now disappeared from Paramount+. Which is an interesting decision, given that I suspect if you asked the average streaming customer to list five titles they associate with Paramount+, Star Trek would be near the top.

To be clear, there's nothing wrong with licensing out the Star Trek movies. Paramount has been doing it for years and those Star Trek titles have appeared at one point or another on just about every competing SVOD. Licensing the films on a non-exclusive basis would make sense. But while removing them from Paramount+ likely made Paramount a bit more money, it feels like a unforced branding error. Whether subscribers intend on watching them or not, having the Star Trek films unavailable to Paramount+ subscribers certainly doesn't help the service's already challenging issues with perceived value.

SPEAKING OF PARAMOUNT
Deadline has a column from veteran film executive Bill Mechanic, who had success runs at Paramount, Disney and Fox. The column is pretty much what you would expect to read, arguing that the studios have lost their way by chasing the streaming business and the success of Netflix.

He also takes some shots at Jason Kilar, although in typical Hollywood fashion, he doesn't mention him by name:

When WB disappeared into the smothering embrace of AT&T, they put someone in charge who was too clever for his own good, in much the same way that MLB owners hired a bunch of book-smart but street-dumb Ivy League analytics experts who used statistics to run their teams into the ground. The AT&T/WB exec chased the White Whale of streaming and myopically put a dagger in the film world while dragging down WB’s own finances to the point it was wiped away by an opportunistic Discovery — the same one now trying to absorb Paramount clearly for reasons that have nothing to do with movies. The studio is simply collateral damage.

Mechanic complains about Kilar's decision to release movies on a day-and-date schedule, seeming to forget that the decision was driven by a pandemic that had shut down theaters. 

At the end of the piece, Mechanic longingly notes that Skydance is interested in acquiring the studio and executive David Ellison "grew up loving films." Which might be helpful if Skydance was able to get access to just the studio. But that would involve chopping Paramount up for parts, which is the very thing Mechanic argues against in the rest of his piece. He seems to forget that Paramount Global is more than a movie studio, some buildings and a catalog of IP. It's linear TV channels, several streaming services and all sorts of ancillary businesses. And the only way to break out that studio (and likely the studio lot and the library) is to chop up and sell off the company like it was a stolen sports car.

READER FEEDBACK
I received some interesting comments about my piece yesterday on short TV seasons. Someone named Wise Sage posted these thoughts:

The problem with your argument defending smaller TV seasons is that it presumes that the best version of TV involves the serialized story arc. You joke about the pointlessness of episodes which slow down or veer away from the all-important reveals and cliff-hangers of some big unfolding uber-narrative. However this was not even something TV did for the first fifty years of its existence -- except maybe on soap operas. Individual episodes stood alone for the most part. The network could (and often did) air them out of shooting order. The viewer could miss a few shows and not feel lost and not need a two minutes spread-sheet of re-cap at the top to jump back in.

Shows were designed to be little standalone one act plays with human-sized stakes and complications -- never big manic rollicking plots with the fate of our entire universe and several other quantum universes on the line. The idea of watching a TV show was to bond each week with characters and immerse yourself in their interesting world. If the show survived a few seasons you would naturally get to know these folks better, see new facets and watch them develop a bit as people, but rampaging ever-forward toward some "important" plot culmination was not the priority -- and I think the shows were better for it.

The current TV landscape is a frenetic glut of disposable sameness -- "This slick new show didn't grab you? Not to worry. We'll throw another one at you next week, and then ten more the week after that. Anything to keep you engaged." New confusing limited-episode programs constantly thrust at us, many of which undoubtedly started out as unsold screenplays, which got diced into breathless eight-episode sassy slam-a-roos. And if you actually make it to the final chapter of these plot-driven little novels for TV how many actually serve up an ending worth all the bother? I'll answer this one: Not many.

And Catterbu had this feedback:

I agree that the piece desiring longer seasons was poorly reasoned. I think I would advocate for "right-sizing" based on the nature of the show and streamer. X-Files is a good example of one show where shorter seasons probably would have benefited the show overall. Of course there are the great standalone episodes, but arguably part of why the mythology became so non-sensical was because 20+ episodes needed to be churned out each year (also, there were a lot of BAD episodes that were standalone). My argument is that more shows need to consider something like what Slow Horses does. Especially more episodic shows (sitcoms, but also shows like Poker Face) benefit from getting to put out more episodes as that allows writers and viewers to better understand and build relationships with characters.

Slow Horses releases its seasons every 6-9 months. My argument is that streamers should look at making some cheaper shows designed to run 6-10 episodes every 6-9 months. The Netflix belief that longer seasons tend to have lower completion rates does not really come into play with that much time in between, but viewers still get greater regularity, which can minimize cost in promotion since viewers are less likely to have forgotten about the show over a shorter time period.

I will note that Slow Horses has been able to release seasons every 5-9 months because they have been shooting two seasons back-to-back. So seasons one and two were shot at the same time, although Apple TV+ didn't mention this to anyone publicly when the show premiered.

This is the same approach streamers (particularly Netflix) take with animated shows. They order a full season of episodes and then split them up into smaller "chapters," all the while announcing they've picked up the show for another group of episodes. Even though the episodes have already been completed.

WHAT'S NEW TONIGHT AND TOMORROW

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)

FRIDAY, JANUARY 5TH, 2024:
*Ancient Aliens Season Premiere (History)
*Foe (Prime Video)
*Good Grief (Netflix)
*James May: Our Man In India (Prime Video)
*LOL: Last One Laughing Quebec (Prime Video)
*Man On The Run (Netflix)
*RuPaul’s Drag Race Season Premiere (MTV)
*Sasaki And Peeps Series Premiere (Crunchyroll)
*The Demon Prince Of Momochi House (Crunchyroll)
*The Prison Confessions Of Gypsy Rose Blanchard (Lifetime)
*The Unwanted Undead Adventurer Series Premiere (Crunchyroll)
*The Wrong Way To Use Healing Magic Series Premiere (Crunchyroll)
*Where The Devil Roams (Tubi)

SEE YOU FRIDAY!

8.651MBMemory Usage313msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.31
Identityguest
Response200
Templateja_blockk
Database
Server
mysql
Version
8.0.39-cll-lve
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743469745 "last" => 1743469745...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (8.76ms)
  • afterInitialise (1.27MB) (51.76ms)
  • afterRoute (227.03KB) (39.09ms)
  • beforeRenderComponent com_content (38.63KB) (1.33ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.15ms)
  • After Access::preloadComponents (all components) (109.3KB) (8.93ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (38μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (14.42ms)
  • Before Access::getAssetRules (id:1899 name:com_content.article.1076) (130.8KB) (283μs)
  • After Access::getAssetRules (id:1899 name:com_content.article.1076) (8.47KB) (262μs)
  • beforeRenderRawModule mod_related_items (Read More) (844.3KB) (68.03ms)
  • Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (4.43ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (21μs)
  • afterRenderRawModule mod_related_items (Read More) (14.41KB) (7.55ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (15μs)
  • afterRenderModule mod_related_items (Read More) (4.07KB) (294μs)
  • afterRenderComponent com_content (35.56KB) (129μs)
  • afterDispatch (3.53KB) (349μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (77.63ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (783μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (259μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (56μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (162μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (6μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (132μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (101μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (5.26ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (249μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (88μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (479μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (7μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (132μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (29μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (115μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (124μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (29μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (176μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (118μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.56ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.89ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (8μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (125μs)
  • afterRender (685.13KB) (13.98ms)
  • 1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (24.76%)
    77.63ms
    1 x beforeRenderRawModule mod_related_items (Read More) (844.3KB) (21.7%)
    68.03ms
    1 x afterInitialise (1.27MB) (16.51%)
    51.76ms
    1 x afterRoute (227.03KB) (12.47%)
    39.09ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (4.6%)
    14.42ms
    1 x afterRender (685.13KB) (4.46%)
    13.98ms
    1 x After Access::preloadComponents (all components) (109.3KB) (2.85%)
    8.93ms
    1 x afterLoad (528.29KB) (2.8%)
    8.76ms
    1 x afterRenderRawModule mod_related_items (Read More) (14.41KB) (2.41%)
    7.55ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (1.68%)
    5.26ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (1.41%)
    4.43ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.24%)
    3.89ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.5%)
    1.56ms
    1 x beforeRenderComponent com_content (38.63KB) (0.42%)
    1.33ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.37%)
    1.15ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.25%)
    783μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.15%)
    479μs
    1 x afterDispatch (3.53KB) (0.11%)
    349μs
    1 x afterRenderModule mod_related_items (Read More) (4.07KB) (0.09%)
    294μs
    1 x Before Access::getAssetRules (id:1899 name:com_content.article.1076) (130.8KB) (0.09%)
    283μs
    1 x After Access::getAssetRules (id:1899 name:com_content.article.1076) (8.47KB) (0.08%)
    262μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.08%)
    259μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.08%)
    249μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.06%)
    176μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.05%)
    162μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.04%)
    132μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.04%)
    132μs
    1 x afterRenderComponent com_content (35.56KB) (0.04%)
    129μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.04%)
    125μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.04%)
    124μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.04%)
    118μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.04%)
    115μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.03%)
    101μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.03%)
    88μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.02%)
    56μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    38μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    29μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    15μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    7μ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_menu (Off Canvas) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
48 statements were executed, 3 of which were duplicates, 45 unique64.03ms541.9KB
  • SELECT @@SESSION.sql_mode;311μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?138μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1138μ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)3.54ms944BParams/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` = 1543μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`201μ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` = :guest265μ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'2.66ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC575μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1270μ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`679μ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`16.88ms5.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` = 1554μ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)4.05ms7.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.56ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.15ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1076'842μs48B/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)847μ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`510μ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.9ms5.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`622μ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 ASC609μ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.24ms58.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`681μ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.id251μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'208μ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 ordering267μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.6ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid375μ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` = :muserid780μ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 ASC755μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'214μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51129μ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.52ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id224μ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 51.11ms1.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.71ms89.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.38ms5.42KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1680μ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)293μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration513μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'190μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field179μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'143μ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` = 1224μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?217μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?508μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy