Too Much TV: Your TV Talking Points For Friday, August 2nd, 2024

Here's everything you need to know about the world of television for Friday, August 2nd, 2024:

WARNER BROS DISCOVERY'S THREE-CARD MONTE APPROACH TO SUBSCRIBER NUMBERS
You might have seen the news that Warner Bros Discovery is shutting down its animation-centric streaming service Boomerang, although the linear network of the same name will continue.

However, the important thing to watch here isn't the WBD is shutting down the service - that decision likely makes a lot of financial sense.

I wanted to highlight the little three-card monte trick WBD is doing with its subscriber numbers. Following its completed merger two years ago, it announced that subscriber numbers for a number of its niche services would no longer be publicly released or included in the company's overall direct-to-consumer streaming numbers. The suspicion was the move would make it more difficult to track the overall reach of the company's niche streamers. And given those services were likely shedding subscribers, the losses wouldn't count against WBD's overall streaming numbers.

But the interesting twist in this Boomerang shutdown is the current Boomerang subscribers are being automatically moved from Boomerang to the ad-free version of Max. Which is quite a deal, given that it costs $6 a month for Boomerang and $17 per month for ad-free Max.

So why would the executives as Warner Bros. Discovery make such a generous deal to current Boomerang subscribers? My hunch is that because it allows the company to add these "new" Max subscribers to the service's overall fourth quarter subscriber numbers, potentially adding hundreds of thousands of subscribers to Max's total, at little or no costs for marketing or customer acquisition. Max needs a win right now and this is a too-clever-for-their-own-good way to juice the subscriber numbers. Now you see them, now you don't.

JOE ROGAN'S VICTORY LAP FOR RIGHT-WING COMEDY
Seth Simon has been perhaps the clearest voice out there highlighting the weird right-wing, post-COVD turn many stand-up comedians have taken, thanks in large part to the support of Joe Rogan. Rogan has a live comedy special airing Saturday on Netflix and Simon writes in The Daily Beast about how Rogan's success has not only lifted the careers of comedians who think like he does. It's given them cover to say pretty much what they want. Because at the end of the day, they'll make companies such as Netflix a lot of money:

Almost across the board, comedians in this milieu are obsessed with trans people, often using the usual slur to express their disgust with the community and its onerous, incessant, unyielding demands for basic rights and dignity. Many of these comics have a penchant for mocking Asian people; some are fed up with the immigrants they think are gobbling up our public resources; nearly all of them harbor a deep disdain for women. They use their platforms to host conspiracy theorists like Alex Jones, far-right ideologues like Tucker Carlson, public health threats like Robert F. Kennedy Jr., and violent misogynists like Andrew Tate, exposing their audiences to a steady torrent of extremist thought.

They are also immensely lucrative investments. Comedians by night and propagandists by day, they just happen to be the industry’s most bankable talents—in no small part thanks to Joe Rogan.

Consider Tim Dillon. A podcaster and Joe Rogan Experience regular, Dillon has devoted considerable airtime to railing against immigration, going so far as to embrace the white nationalist great replacement theory in a JRE appearance last year. In other segments, he has questioned whether America can really “absorb” any more people, argued against gender-affirming care for trans youth, and complained about trans athletes. A longtime fan of Alex Jones, Dillon has hosted the disgraced Sandy Hook truther on multiple episodes, including a 2020 New Year’s Eve live-stream where Jones raved about election fraud and promoted the upcoming rally he helped organize in Washington, D.C. (Yes, the one you’re thinking of.) In addition to all of this, he is an incredibly popular comedian. Netflix released his last hour in 2022 and just announced his next one, a “talk-show style special” out this fall.

For all the talk from Rogan about the "cancel culture" and how comedians are afraid to say anything right now, these chuckleheads are making a fortune saying whatever crazy, racist thing pops into their head. And because they have a dedicated fanbase, companies such as Netflix are willing to trade a bit of bad press for big viewer numbers.

WEEKEND VIEWING TIPS
It is a remarkably slow weekend for premieres, unless you're interested in watching the R-rated director's cuts of the two Rebel Moon movies on Netflix. But one docuseries I want to highlight is Cowboy Cartel, which premiered today on Apple TV+. 

The name might be a bit goofy, but it is the fascinating story of a rookie FBI agent who is assigned to the Laredo, Texas office. It is not considered a plum assignment and given his lack of experience, no one is expecting much from him. But he ends up stumbling into a case which ultimately took down the Treviño brothers, the leaders of Los Zetas, one of the most powerful cartels in Mexico. 

He notices that one of the other Trevino brothers is buying race horses in Texas and uncovers a complicated international money laundering operation.  The resulting cases not only send dozens of people to jail, but the arrest destabilize the Los Zetas enough to eventually collapse that cartel.

It is an absolutely crazy story and it's complicated enough to justify its four-episode length. 

The documentary also reminded me that I would love to see a similar deep dive on the Mexican cartel's control of the Mexican avocado industry. Several cartels not only control the production and distribution of most of the crops, they've used violence and bribery to illegally harvest hundreds of miles of protected forests. Which they then turn into avocado fields after selling off the prized old-growth woods.

And once you've watched Cowboy Cartel, check out this video interview I did with executive producers Dan Johnstone and Castor Fernandez. It doesn't include spoilers, per se. But the interview will make more sense once you've see the series.

TWEET OF THE DAY



ODDS AND SODS
* The Gay Supermarket Sweep “Business Partners” from the ’90s have a wilder story than you know.

* The Federal Trade Commission is giving $12 million in refund payments to those duped by a Utah company associated with multiple HGTV stars.

* The "Fool In Love" festival has a great lineup of classic soul, R&B and soft rock acts. But I don't think that I've ever seen a festival that encouraged people to buy the weekend tickets on layaway.

WHAT'S NEW TONIGHT AND THIS WEEKEND

FRIDAY, AUGUST 2ND:
* Cowboy Cartel (Apple TV+)
* Jazz Ramsey: A K-9 Mystery (Hallmark Mystery)
* Modern Masters: SS Rajamouli (Netflix)
* Rebel Moon – Chapter One: Chalice of Blood (Netflix)
* Rebel Moon – Chapter Two: Curse of Forgiveness (Netflix)
* Saving Bikini Bottom: The Sandy Cheeks Movie (Paramount+)


SATURDAY, AUGUST 3RD:
* Elizabeth Taylor: The Lost Tapes (HBO)
* I Thought My Husband's Wife Was Dead (Lifetime)
* Joe Rogan: Burn The Boats (Netflix)
* Johnson (Bounce)
* Junebug (Hallmark)
* Single Mom Missing (Investigation Discovery)
* 30 For 30: Dude Perfect: A Very Long Shot (ESPN)


SUNDAY, AUGUST 4TH:
* Granchester On Masterpiece Season Finale (PBS)
* Fully Torqued Season Four Premiere (fyi)
* 73rd Miss USA Pageant (The CW)
* The Neighbor Who Saw Too Much (Lifetime)
* 39th Annual Stellar Gospel Music Awards (BET)


MONDAY, AUGUST 5TH:
* Gabby's Dollhouse Season Premiere (Netflix)
* Judy Justice Season Premiere (Freevee/Prime Video)
* POV: Fauna (PBS)



SEE YOU ON MONDAY

9.064MBMemory Usage191msRequest 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" => 1746677403 "last" => 1746677403...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.47ms)
  • afterInitialise (1.27MB) (27.58ms)
  • afterRoute (227.06KB) (9.55ms)
  • beforeRenderComponent com_content (38.63KB) (1.35ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.24ms)
  • After Access::preloadComponents (all components) (109.3KB) (5.14ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (28μs)
  • After Access::preloadPermissions (com_content) (2.93MB) (12.65ms)
  • Before Access::getAssetRules (id:3024 name:com_content.article.2195) (258.8KB) (236μs)
  • After Access::getAssetRules (id:3024 name:com_content.article.2195) (8.47KB) (253μs)
  • beforeRenderRawModule mod_related_items (Read More) (849.42KB) (54.34ms)
  • Before Access::getAssetRules (id:8 name:com_content) (81.11KB) (4.34ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (21μs)
  • afterRenderRawModule mod_related_items (Read More) (13.53KB) (6.84ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (11μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (304μs)
  • afterRenderComponent com_content (43.25KB) (111μs)
  • afterDispatch (3.53KB) (345μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (30.14ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (803μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (7μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (265μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (61μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (184μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (6μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (127μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (104μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (5.34ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (12μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (278μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (100μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (529μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (7μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (146μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (31μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (119μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (145μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (32μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (206μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (125μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.65ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.63ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (9μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (132μs)
  • afterRender (681.13KB) (14.01ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (849.42KB) (28.41%)
    54.34ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (15.76%)
    30.14ms
    1 x afterInitialise (1.27MB) (14.42%)
    27.58ms
    1 x afterRender (681.13KB) (7.33%)
    14.01ms
    1 x After Access::preloadPermissions (com_content) (2.93MB) (6.61%)
    12.65ms
    1 x afterRoute (227.06KB) (4.99%)
    9.55ms
    1 x afterLoad (528.29KB) (3.91%)
    7.47ms
    1 x afterRenderRawModule mod_related_items (Read More) (13.53KB) (3.58%)
    6.84ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (2.79%)
    5.34ms
    1 x After Access::preloadComponents (all components) (109.3KB) (2.69%)
    5.14ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (81.11KB) (2.27%)
    4.34ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.9%)
    3.63ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.86%)
    1.65ms
    1 x beforeRenderComponent com_content (38.63KB) (0.71%)
    1.35ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.65%)
    1.24ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.42%)
    803μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.28%)
    529μs
    1 x afterDispatch (3.53KB) (0.18%)
    345μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.16%)
    304μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.15%)
    278μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.14%)
    265μs
    1 x After Access::getAssetRules (id:3024 name:com_content.article.2195) (8.47KB) (0.13%)
    253μs
    1 x Before Access::getAssetRules (id:3024 name:com_content.article.2195) (258.8KB) (0.12%)
    236μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.11%)
    206μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.1%)
    184μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.08%)
    146μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.08%)
    145μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.07%)
    132μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.07%)
    127μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.07%)
    125μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    119μs
    1 x afterRenderComponent com_content (43.25KB) (0.06%)
    111μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    104μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.05%)
    100μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    61μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    31μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0.01%)
    12μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    11μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    6μs
48 statements were executed, 3 of which were duplicates, 45 unique45.1ms570.05KB
  • SELECT @@SESSION.sql_mode;95μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?128μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 186μ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)475μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1444μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`105μ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` = :guest191μ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`706μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'910μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC254μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1250μ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`600μ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`327μ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` = 1179μ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)636μ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` = 04.61ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.05ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2195'10.49ms48B/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)606μ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`476μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)2.36ms5.25KBParams/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`605μ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 ASC479μ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.4ms58.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`537μ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.id153μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'228μ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 ordering244μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.4ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid171μ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` = :muserid192μ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 ASC410μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'80μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5178μ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.74ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id134μ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 51.93ms1.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 ASC982μs113.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.49ms5.53KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1785μ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)362μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration469μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'167μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field151μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'132μ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` = 1205μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?244μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.35ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy