Too Much TV: Here's How Comcast Spent $40 Billion Over The Past Five Years

Here's everything you need to know about the world of television for Monday, June 16th 2025:

PRODUCTION NOTES
Tonight's newsletter is even later than normal and I apologize for that. Today was my son's 20th birthday and we spent much of the day hanging out with my wife and then spent some quality time tonight watching old episodes of "Vintage" Antiques Roadshow and competing to see which one of us could better predict if the value of an item had went up or down over the years.

So this is late, but it was worth it.

On another note, I've had a few people ask how my health is doing. I've been purposely vague because honestly, half the time I don't have an answer. It's been months of tests and new medicines and days when I just want to curl up. And it's all been complicated by the fact that there are a couple of things going on at the same time. But it's being handled and I feel cautiously optimistic for the future. 

Doing this newsletter has helped keep me sane and motivated. And I appreciate all of your concerns. It means a lot.

EVERY DOLLAR A COMPANY SPENDS ON STOCK BUYBACKS HAS TO COME FROM SOMEWHERE
Until the law changed in 1982 under the Reagan Administration, it was illegal for a company to buy back shares of its own stock. It was considered stock manipulation, because the only real reason to buy back stock is in order to reduce the number of publicly traded shares. Which in theory, should increase the price of the company's stock, assuming nothing else changes.

Changes in the law also made it easier for companies to tie the price of its shares to executive compensation and bonuses. So over the years, the result was that many companies spent money that should have gone to things such as product development, marketing and employee pay and used the funds to buy back billions of dollars worth of their outstanding shares. This approach often damaged the company's long-term ability to compete, but that didn't matter much to the executives who earned millions (or tens of millions) in bonuses before they went on to the next company.

As you might imagine, the recent trends in American media have left most big entertainment companies without the free cash flow to spend on stock buybacks. While Netflix has bought back $3.185 billion of its own shares over the past five years, rivals such as Paramount Global have had to show restraint. 

Over the past five years, Paramount Global has not engaged in any stock buybacks. And Warner Bros. Discovery has not done any stock buybacks since the merger closed in 2022.

On the other hand, while AMC Networks has been struggling in recent years, that hasn't prevented the company from doing a series of steady buybacks over the past five years. The biggest buyback by far was one in December 2020 for $260,780,000. But in most fiscal quarters since, the company has bought back small amounts of stock, at least some of it from company executives. Overall, the company has done just over $343 million in stock buybacks over the past five years.

Fox Corporation takes a very different approach when it comes to stock buybacks. Since June 2023, it spends $250,000,000 each quarter. No more, no less. However, in March 2023, the company reported it had bought back $1.25 billion worth of stock in the previous quarter. Overall, the company's five-year total is a staggering $6 billion in stock buybacks.

And The Walt Disney Corp. has also invested heavily in stock buybacks, spending $4,777,000,000 over the past five years. To put that into context, you could produce around nine seasons of Andor with that money.

However, no media company has been more aggressive with its stock buyback program than Comcast, which has repurchased 988 million shares for a total expenditure of $40.6 billion. Which is just a staggering sum.

Now none of these companies are doing anything wrong. At least, not legally. But I think it's fair to suggest some of these company's could have put these funds to better use.

TO BE HONEST, I DON'T REMEMBER THIS EPISODE OF 'DOCTOR WHO'


ODDS AND SODS
*
Over the years I have seen a LOT of competition shows come and go. It's a tough and unpredictable genre and I am wise enough to know there is no predicting what audiences might like. But there are some ideas that make me think "Hmm. I wonder how this is going to work?" And I certainly have that feeling with the upcoming Netflix series All The Sharks. Here is the premise: 'All the Sharks is a thrilling new competition series where four teams of passionate shark experts embark on the ultimate adventure to find and photograph the most sharks. Racing against time - and each other - teams dive deep into the world's most spectacular shark habitats, all in hopes of winning a $50,000 prize for their chosen marine charity." And here is a first look at the trailer.

* A group of California journalists have filed a lawsuit against the Los Angeles Police Department, alleging unlawful use of force.

*
Netflix has announced the latest regional edition of its Love Is Blind dating franchise, this one set in Italy. Here is the official logline of the series: "Falling in love sight unseen: that’s the challenge awaiting the participants of Love is Blind: Italy. Leading them through this unique experiment are two exceptional hosts: Fabio Caressa and Benedetta Parodi. He’s a beloved sports commentator, she’s a popular TV personality — married for over 25 years and still going strong. Now, they're guiding singles on their own journey to find true love. Who will say the fateful “I do”?" And here is a first look at the trailer.

* Tucci In Italy has been renewed for a second season by NatGeo.

* The comedy special Nate Jackson: Super Funny will premiere Tuesday, July 8th on Netflix.

TWEET OF THE DAY


WHAT'S NEW TONIGHT AND TOMORROW

TUESDAY, JUNE 17TH:
* Chopper Cops Season Two Premiere (Paramount+)
* Hell Motel (AMC+/Shudder)
* Justin Willman: Magic Lover (Netflix)
* Kaulitz & Kaulitz (Netflix)
* Surviving Ohio State (HBO)
* Trainwreck: Mayor Of Mayhem (Netflix)

WEDNESDAY, JUNE 18TH:
* America's Sweethearts: Dallas Cowboys Cheerleaders Season Premiere (Netflix)
* Children Ruin Everything Season Premiere (The CW)
* Expedition Unknown Season Premiere (Discovery)
* Mystery At Blind Frog Ranch Season Premiere (History)
* Outrageous (BritBox)
* Rosario Tijeras (Mexico) (Netflix)
* Somebody Feed Phil Season Eight Premiere (Netflix)
* Sports Gone Wrong Series Premiere (Vice)
* The Buccaneers Season Two Premiere (Apple TV+)
* We Were Liars Series (Prime Video)
* Yolanthe Series Premiere (Netflix)

SEE YOU ON TUESDAY!

9.194MBMemory Usage114msRequest 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
array:1 [ "86b2c08b2c9b2adb30aa621284b55eb4" => "l8r2t2vol7ge8s87n8oecah3db" ]
$_SERVER
array:49 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1750790959 "last" => 1750790959...
registry
array:3 [ "data" => array:1 [ "com_content" => array:1 [ "author" => array:1 [ "...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.41KB) (4.74ms)
  • afterInitialise (1.27MB) (19ms)
  • afterRoute (227.06KB) (5.98ms)
  • beforeRenderComponent com_content (38.3KB) (867μs)
  • Before Access::preloadComponents (all components) (34.7KB) (806μs)
  • After Access::preloadComponents (all components) (109.3KB) (827μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (13μs)
  • After Access::preloadPermissions (com_content) (3.02MB) (8ms)
  • Before Access::getAssetRules (id:4999 name:com_content.article.4165) (258.8KB) (134μs)
  • After Access::getAssetRules (id:4999 name:com_content.article.4165) (8.47KB) (162μs)
  • beforeRenderRawModule mod_related_items (Read More) (854.69KB) (28.22ms)
  • Before Access::getAssetRules (id:8 name:com_content) (81.13KB) (4.31ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (14μs)
  • afterRenderRawModule mod_related_items (Read More) (40.48KB) (5.3ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (6μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (190μs)
  • afterRenderComponent com_content (43.31KB) (68μs)
  • afterDispatch (3.53KB) (191μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (19.04ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (483μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (157μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (36μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (101μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (76μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (71μs)
  • afterRenderRawModule mod_finder (Head Search) (67.05KB) (2.95ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (143μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (48μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (247μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (83μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (18μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (71μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (85μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (20μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (103μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (3μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (75μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (955μs)
  • afterRenderRawModule mod_menu (magazine-menu-3) (115.98KB) (2.21ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (5μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (78μs)
  • afterRender (680.95KB) (7.65ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (854.69KB) (24.8%)
    28.22ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (16.73%)
    19.04ms
    1 x afterInitialise (1.27MB) (16.7%)
    19.00ms
    1 x After Access::preloadPermissions (com_content) (3.02MB) (7.03%)
    8.00ms
    1 x afterRender (680.95KB) (6.73%)
    7.65ms
    1 x afterRoute (227.06KB) (5.25%)
    5.98ms
    1 x afterRenderRawModule mod_related_items (Read More) (40.48KB) (4.65%)
    5.30ms
    1 x afterLoad (528.41KB) (4.16%)
    4.74ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (81.13KB) (3.79%)
    4.31ms
    1 x afterRenderRawModule mod_finder (Head Search) (67.05KB) (2.59%)
    2.95ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (115.98KB) (1.94%)
    2.21ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.84%)
    955μs
    1 x beforeRenderComponent com_content (38.3KB) (0.76%)
    867μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.73%)
    827μs
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.71%)
    806μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.42%)
    483μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.22%)
    247μs
    1 x afterDispatch (3.53KB) (0.17%)
    191μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.17%)
    190μs
    1 x After Access::getAssetRules (id:4999 name:com_content.article.4165) (8.47KB) (0.14%)
    162μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.14%)
    157μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.13%)
    143μs
    1 x Before Access::getAssetRules (id:4999 name:com_content.article.4165) (258.8KB) (0.12%)
    134μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.09%)
    103μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.09%)
    101μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.07%)
    85μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.07%)
    83μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.07%)
    78μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.07%)
    76μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.07%)
    75μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.06%)
    71μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    71μs
    1 x afterRenderComponent com_content (43.31KB) (0.06%)
    68μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.04%)
    48μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    36μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    20μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    18μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    14μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    13μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    6μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0.01%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    3μs
49 statements were executed, 3 of which were duplicates, 46 unique28.56ms571.37KB
  • SELECT @@SESSION.sql_mode;65μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?170μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 176μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `tvlfg_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id482μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1383μs2.19KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`218μ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` = :guest221μ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`692μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'392μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC133μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1167μ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`441μ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`285μ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` = 1191μ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)488μ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.68ms249.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` = '4165'684μ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)590μ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`469μ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.8ms5.28KBParams/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`407μ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 ASC429μ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.54ms58.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`350μ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.id116μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'123μ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 ordering123μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.06ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid219μ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` = :muserid132μ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 ASC300μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'85μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5160μ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`797μs2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id114μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3 OR `a`.`metakey` LIKE :preparedArray4)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 52.51ms1.85KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC855μs89.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.36ms5.59KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `tvlfg_categories` AS `s` INNER JOIN `tvlfg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`354μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1437μ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)143μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration244μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'120μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field112μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'73μ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` = 1148μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?101μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.04ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy