U.S

Phil Donahue's MSNBC Show Was One Of The First Casualties Of The Iraq War

Hearing the news that Phil Donahue has died brings up a lot of complicated feelings with me. Donahue came to prominence in my teens and twenties and it's easy to forget just how impactful his daytime talker was in those days. It was just that his show essentially created the template for the later success of Oprah and dozens of other daytime talk shows.

Phil Donahue was also a template for what it meant to be a certain type of man in the 1970s. He was articulate, passionate, and had strong political feelings that were liberal but also still grounded in a Midwestern sensibility. The Phil Donahue Show (then based in Dayton, Ohio) went into national syndication in January 1970 and after moves to Chicago in 1974 and New York ten years later, it wrapped up in 1996 after nearly 7,000 shows.

While every daytime talk show is a reflection of the personality of the host, The Phil Donahue Show was also a representation of Donahue's limitless intellectual curiosity and desire to expose himself (and his audience) to new topics and to ideas that at the time might be out of the mainstream. Show topics covered everything from abortion and homosexuality to mixed marriages and socialism. His politics were obviously liberal, but he had the ability to talk to guests in a way that was more about exploring their stories than pushing some personal agenda.

However, Phil Donahue definitely had strong opinions that he was willing to put forward in a different context. In the 1908s, Donahue and Soviet journalist Vladimir Posner co-hosted a series of televised roundtables, called the U.S.–Soviet Space Bridge, which allowed live audiences in the United States and Russia to ask each other questions about their lives. And in the early 1990s, the two men co-hosted Posner/Donahue, a weekly, issues-oriented roundtable program, which aired both on CNBC and in syndication.

The shows tended to be more interesting in the abstract than when you watched them and in retrospect, I suspect Donahue was a bit naive when it came to the editorial independence Posner had from the Soviet government. But it was an interesting experiment and the fact he put so much personal capital into the idea is a reflection of Donahue's desire to expose American audiences to uncomfortable ideas.

After seven years off television, Phil Donahue returned in July 2002 with an MSNBC entitled Phil. At the time, the network was cycling through a series of unsuccessful personality-based talk shows including Allan Keyes Is Making Sense, Buchanan & Press (featuring conservative Pat Buchanan), and Jesse Ventura's America. MSNBC was also in the midst of an internal battle for its editorial soul, as executives from NBC News wrestled with network executives and MSNBC head Erik Sorenson over the channel's editorial mix. That tension between what was perceived as hard news vs. opinion would ultimately determine the fate of Donahue's new show, which lasted less than eight months.

When MSNBC canceled Phil Donahue's primetime show on Tuesday, February 25th, 2003, it wasn't exactly a shocker to industry watchers. Executives at the cable network had been privately grumbling about the show to reporters for weeks, complaining that the show was struggling in the ratings, Donahue was difficult to deal with and the network felt the very competitive timeslot needed some new blood in order to compete against Fox News Channel powerhouse Bill O'Reilly.

And when I reported on the move the following day, I did include those observations. But I also focused on a primary reason why Donahue had exited the cable news network: executives felt that Donahue's anti-Iraq War stance would be a problem for advertisers and would cripple the network's hopes of building a successful alternative to Fox News and CNN as the country moved towards war.

And in fact, if you look at the raw ratings numbers, the struggling news channel may have a point. Originally conceived as a liberal alternative to the popular O'Reilly Factor, the show started slow and never recovered. During this month, a "sweeps" period in which ratings are watched closely to set advertising rates, Donahue averaged 446,000 viewers. O'Reilly drew 2.7 million viewers, up 28 percent from February 2002, according to Nielsen Media Research.

But as it turns out, the picture isn't as clear as it initially seems. While Donahue does badly trail both O'Reilly and CNN's Connie Chung in the ratings, those numbers have improved in recent weeks. So much so that the program is the top-rated show on MSNBC, beating even the highly promoted Hardball With Chris Matthews.

Although Donahue didn't know it at the time, his fate was sealed a number of weeks ago after NBC News executives received the results of a study commissioned to provide guidance on the future of the news channel.

That report--shared with me by an NBC news insider--gives an excruciatingly painful assessment of the channel and its programming. Some of the recommendations, such as dropping the "America's News Channel," have already been implemented. But the harshest criticism was leveled at Donahue, whom the authors of the study described as "a tired, left-wing liberal out of touch with the current marketplace."

The study went on to claim that Donahue presented a "difficult public face for NBC in a time of war......He seems to delight in presenting guests who are anti-war, anti-Bush and skeptical of the administration's motives." The report went on to outline a possible nightmare scenario where the show becomes "a home for the liberal antiwar agenda at the same time that our competitors are waving the flag at every opportunity."

A source close to Donahue claims that while he wasn't aware of the specific study, the tone and outcome aren't surprising.

"It's not a coincidence that this decision comes the same week that MSNBC announces it has hired Dick Armey as a commentator and has both Jesse Ventura and Michael Savage joining the network as hosts. They're scared, and they decided to take the coward's road and slant towards the conservative crowd that watches Fox News."

While it wasn't public knowledge at the time, Donahue had been battling network executives for months over the direction of his show, particularly as it became increasingly clear that the Bush Administration was moving closer to an invasion of Iraq.

When MSNBC launched Donahue in 2002, network executives were clearly hoping for some modern-day incarnation of his long-running syndicated daytime talker. Albeit with a focus on the news of the day as opposed to cheating housewives and sports figures battling depression. And while that was certainly part of the mix in the early months of the show, as talk of a possible war increased Donahue leaned increasingly into his liberal inclinations. He had guests on to talk about the Patriot Act, the costs of a possible invasion and warned of what might be the dangers from other countries in the Middle East. Donahue had guests on to pushback against administration claims that Iraq harbored weapons of mass destruction and other than the show Buchanan and Press (hosted by conservative Pat Buchanan and liberal Bill Press), Donahue was often the only MSNBC host to show any real skepticism about a possible war with Iraq.

It's important to take a minute and reflect upon the mood of the country in 2002 and early 2003. The events of 9/11 were still razor sharp in the minds of Americans and that translated into a general sense of patriotism and a desire among many to support the Bush Administration. Bush began his presidency with approval ratings near 50%. But following the September 11th attacks, Bush held approval ratings of greater than 85%, among the highest for any President in history.  And while that number had dipped some by early 2003, it hovered around 60-65%, which is still historically quite high. Most Americans were not in the mood to hear about moderation towards any country that might be involved with terrorism against the United States.

But it wasn't just average Americans who were leery of criticizing the war buildup. After Donahue was pushed out of MSNBC, I spoke to a number of people at the network and heard the same story from several of them. According to scuttlebutt inside the network, former GE chairman and CEO Jack Welch called a top executive at the network more than once to complain about Donahue's skepticism over the Iraq War. While Welch had retired at this point, he still held enormous sway at GE. This was a problem given that they owned NBC, which owned MSNBC.

The story I heard was that Welch had called to complain after he had been playing golf with some buddies and they began asking why MSNBC had some "anti-war kooks" on the air. I was never able to officially confirm the story, but the fact MSNBC employees believed it is an indication of the pressure they felt to conform to the national narrative.

And even before the pressure of coverage of the Iraq War, there were a lot of animosities between NBC News employees and executives at the cable news network. NBC News executives felt the cable news side of the business was there primarily to give the NBC News coverage another outlet. Personality-driven programming could be tolerated in small doses, but it wasn't appropriate for a channel associated with the "serious" reporters of NBC News. The other part of this angst was more unspoken. But there was a fear in most media organizations at the time that appearing as if you weren't supporting a possible war effort 100 percent, it could be bad for the company's bottom line.

Add to all of this the problems brought on by Donahue himself. By late 2002, he certainly wasn't doing the show he had promised the network and that might not have been a problem if he could have delivered a program that was lively and groundbreaking. But given that few journalists were inclined to publicly speculate about the need for an invasion of Iraq, there were few journalists Donahue's producers could convince to appear on the show. In fact, the pool of possible war-skeptical guests relied heavily on old 1960s anti-war faces and a collection of other very left-wing critics of any war effort. The result were shows that were often not just ponderous, but also predictable.

That predictability seemed to worry MSNBC executives less than the prospect of having the network seen as being not sufficiently supportive of the war effort. A worry I wrote about in a piece posted a couple of weeks after Donahue exited the network:

But many of the show's biggest boosters felt that the guidelines hamstrung a format that was being challenged by critics from the right. Rather than "letting Phil be Phil," imposing a "quota system on guests" resulted in shows that often degenerated into shouting matches between liberals and conservatives. A person hired by the network approved the booking decisions and often insisted that there be two conservative guests for every one that was perceived to be liberal. "Sometimes the show ended up being some warped version of 'Crossfire,' which wasn't what we (the network) wanted," explained one high-placed NBC News official. "And it wasn't doing Donahue any favors, either."

One of the high-ranking production people on the show recounted the number of times potential show ideas were shot down, or watered down to the point where the original pitch didn't make any sense. "We wanted to do more stories about Iraq and other foreign policy issues and at one point I was told that we needed to limit those segments to no more than one every few days," he described. "I was never told not to book someone, but at some point you find yourself falling back to the position of picking your battles. Unfortunately, that means a lot of good people didn't get heard on our show."

Ironically, while liberals may have found the show's editorial mix unsatisfying, those inside the network often felt the show still leaned too far left for advertiser's comfort. One email from that period discussed the "challenges" faced by MSNBC as it attempted to promote the show. "...and after watching last night's show, I'm not sure what type of show we're doing....forget the constant braying back and forth between guests," complained one network insider. "Tell me, are we reaching our core audience? Sometimes, I feel as if I'm watching MSNPR, rather than a network associated with NBC News."

All of this was going on at the same time as a frustrating stall in the ratings of the show. By late August, network executives had begun to discuss ways to boost the numbers, and for many, that meant moving the show towards a more "centrist, women-friendly environment." In fact, NBC executives have consistently claimed that they had hoped for a show that was attractive to an "underserved demographic...women, libertarians, the Middle American Silent Majority that should be the core of our audience."

All of this angst and second-guessing led the network to commission several focus groups in hopes of fine-tuning changes to Donahue. And according to results I saw from the sessions, it's clear there were perception problems with the show - whether or not they were accurate:

The battle for the heart and soul of the show escalated after the results of an October focus group further convinced network news executives that Phil needed "some help" turning the show around. That focus group led to a series of additional "fine-tuning" moves, with special attention being given to Phil himself. "I personally like Donahue, but our numbers were telling us that viewers thought he was too combative, and often said things that some respondents considered almost unpatriotic," says one network insider. "In retrospect, I think we may have overreacted, but I honestly thought we were doing what was best for the show."

By the time January began, the pressure from executives at NBC and GE had reportedly become so persistent that the normally private Donahue began making veiled references to the situation during his show.

"I believe that the drumbeat has been so powerful, so everywhere, that it has literally intimidated people who might want to dissent from the war," he said during a January 6th show called "Is There A Conservative Bias In The Media?" "They’re going to be called unpatriotic. I was called unpatriotic by a person in this very NBC-MSNBC family. This is very difficult out there. At a time when we need dissent the most, everybody is sitting back and afraid."

Whether it was fear or business that drove the move toward Donahue's cancellation, the process was moving along behind the scenes. One email from this period discusses the look of a postwar, post-Donahue, MSNBC. The executive noted that the war with Iraq would be a chance for the network to "reinvent itself" and take advantage of the "anticipated larger audience who will tune in during a time of war."

The email went on to note that the war coverage would give the network an opportunity to "cross-pollinate our programming," by fitting network personalities into the wall-to-wall war coverage. "It's unlikely that we can use Phil in this way, particularly given his public stance on the advisability of the war effort." The author went on to explain that the network needed additional voices who were comfortable and knowledgeable in "both an environment of war and of peace."

While it's unclear just when the decision was made to cancel Donahue, nearly everyone interviewed for this piece believes that the reasons are more complex than just liberal vs. conservative. "This is a ratings-driven business, and it's important not to lose track of that in this discussion," one CNN executive told me on Monday. "But I won't lie and tell you that your public beliefs and persona don't matter to viewers....There are a lot of people out there who believe that the press is inherently liberal. And I would be an idiot if I did anything to encourage that conversation."

So Donahue lost his show and was ironically replaced a month later by Keith Olbermann, who was rehired by the network to host a new incarnation of Countdown: Iraq called Countdown With Keith Olbermann. Within months, Olbermann's mix of news and pointed commentary was much more critical of the Bush Administration and the war effort than Donahue had ever attempted. The difference was that by the fall of 2003, public sentiment about the war effort was quickly turning skeptical, which gave Olbermann breathing room Donahue never had from network executives.

As for me, after writing a series of pieces about the dispute that were referenced everywhere from Vanity Fair and The Nation to NPR and the NY Times, I found myself unable to continue reporting. At the time that I was reporting out the story, I was an unemployed journalist reporting the story for my own personal site. 

Which was a problem, because this was before the time of Google Adsense and back in the days when web owners had to pay a metered cost for bandwidth. After my first bill for $1,200, it was clear the effort wasn't financially sustainable.

And when I found a new job (ironically, working for NBC), I put the media reporting on a back burner for more than a decade. 

But Donahue's experience at MSNBC was a formative part of my career and his approach to balancing political passion and intellectual curiosity remains an inspiration for me.



9.404MBMemory Usage531msRequest 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" => 1744864684 "last" => 1744864684...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (14.69ms)
  • afterInitialise (1.27MB) (219ms)
  • afterRoute (227.02KB) (15.5ms)
  • beforeRenderComponent com_content (38.17KB) (1.4ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.11ms)
  • After Access::preloadComponents (all components) (109.3KB) (14.37ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (37μs)
  • After Access::preloadPermissions (com_content) (2.59MB) (16.16ms)
  • Before Access::getAssetRules (id:3095 name:com_content.article.2266) (130.8KB) (374μs)
  • After Access::getAssetRules (id:3095 name:com_content.article.2266) (8.47KB) (234μs)
  • beforeRenderRawModule mod_related_items (Read More) (1.11MB) (84.33ms)
  • Before Access::getAssetRules (id:8 name:com_content) (88.19KB) (11.13ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (19μs)
  • afterRenderRawModule mod_related_items (Read More) (81.16KB) (10.37ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (14μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (311μs)
  • beforeRenderRawModule mod_articles_latest (Recent Post) (376B) (251μs)
  • afterRenderRawModule mod_articles_latest (Recent Post) (126.13KB) (46.54ms)
  • beforeRenderModule mod_articles_latest (Recent Post) (704B) (12μs)
  • afterRenderModule mod_articles_latest (Recent Post) (5.93KB) (212μs)
  • beforeRenderRawModule mod_jacontentlisting (Press Releases) (2.23KB) (59μs)
  • afterRenderRawModule mod_jacontentlisting (Press Releases) (279.36KB) (34.63ms)
  • beforeRenderModule mod_jacontentlisting (Press Releases) (736B) (10μs)
  • afterRenderModule mod_jacontentlisting (Press Releases) (9.93KB) (219μs)
  • afterRenderComponent com_content (62.21KB) (191μs)
  • afterDispatch (2.28KB) (331μs)
  • beforeRenderRawModule mod_menu (Newsletters) (156.63KB) (30.82ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.28KB) (691μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (7μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (245μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (56μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (164μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (3.8KB) (123μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (101μs)
  • afterRenderRawModule mod_finder (Head Search) (76.97KB) (4.4ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (279μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (91μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (456μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (152μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (30μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (111μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (123μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (30μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (186μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (121μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.61ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (117.2KB) (3.6ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (9μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (171μs)
  • afterRender (715.84KB) (14.71ms)
  • 1 x afterInitialise (1.27MB) (41.21%)
    218.67ms
    1 x beforeRenderRawModule mod_related_items (Read More) (1.11MB) (15.89%)
    84.33ms
    1 x afterRenderRawModule mod_articles_latest (Recent Post) (126.13KB) (8.77%)
    46.54ms
    1 x afterRenderRawModule mod_jacontentlisting (Press Releases) (279.36KB) (6.53%)
    34.63ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (156.63KB) (5.81%)
    30.82ms
    1 x After Access::preloadPermissions (com_content) (2.59MB) (3.05%)
    16.16ms
    1 x afterRoute (227.02KB) (2.92%)
    15.50ms
    1 x afterRender (715.84KB) (2.77%)
    14.71ms
    1 x afterLoad (528.29KB) (2.77%)
    14.69ms
    1 x After Access::preloadComponents (all components) (109.3KB) (2.71%)
    14.37ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (88.19KB) (2.1%)
    11.13ms
    1 x afterRenderRawModule mod_related_items (Read More) (81.16KB) (1.95%)
    10.37ms
    1 x afterRenderRawModule mod_finder (Head Search) (76.97KB) (0.83%)
    4.40ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (117.2KB) (0.68%)
    3.60ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.3%)
    1.61ms
    1 x beforeRenderComponent com_content (38.17KB) (0.26%)
    1.40ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.21%)
    1.11ms
    1 x afterRenderRawModule mod_menu (Newsletters) (15.28KB) (0.13%)
    691μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.09%)
    456μs
    1 x Before Access::getAssetRules (id:3095 name:com_content.article.2266) (130.8KB) (0.07%)
    374μs
    1 x afterDispatch (2.28KB) (0.06%)
    331μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.06%)
    311μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.05%)
    279μs
    1 x beforeRenderRawModule mod_articles_latest (Recent Post) (376B) (0.05%)
    251μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.05%)
    245μs
    1 x After Access::getAssetRules (id:3095 name:com_content.article.2266) (8.47KB) (0.04%)
    234μs
    1 x afterRenderModule mod_jacontentlisting (Press Releases) (9.93KB) (0.04%)
    219μs
    1 x afterRenderModule mod_articles_latest (Recent Post) (5.93KB) (0.04%)
    212μs
    1 x afterRenderComponent com_content (62.21KB) (0.04%)
    191μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.04%)
    186μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.03%)
    171μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.03%)
    164μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.03%)
    152μs
    1 x afterRenderModule mod_menu (Other Content) (3.8KB) (0.02%)
    123μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.02%)
    123μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.02%)
    121μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.02%)
    111μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.02%)
    101μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.02%)
    91μs
    1 x beforeRenderRawModule mod_jacontentlisting (Press Releases) (2.23KB) (0.01%)
    59μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.01%)
    56μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    37μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    19μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    14μs
    1 x beforeRenderModule mod_articles_latest (Recent Post) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_jacontentlisting (Press Releases) (736B) (0%)
    10μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    9μ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%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
62 statements were executed, 8 of which were duplicates, 54 unique223ms616.33KB
  • SELECT @@SESSION.sql_mode;24.48ms1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?7.8ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 18.81ms1.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)27.94ms944BParams/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` = 18.37ms2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`6.04ms976B/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` = :guest243μ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`1.08ms3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'691μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC180μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1210μ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`587μ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`2.37ms5.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` = 1561μ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)7.37ms7.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` = 08.03ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`6.04ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2266'8.76ms48B/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)1.27ms48.62KBParams/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`767μ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.66ms5.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`626μ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 ASC653μ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 DESC4.24ms38.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`1.75ms5.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.id227μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'224μ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 ordering216μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.78ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid244μ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` = :muserid329μ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 ASC504μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'136μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51106μ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.31ms2.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id254μ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 OR `a`.`metakey` LIKE :preparedArray5 OR `a`.`metakey` LIKE :preparedArray6)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 57.93ms2.51KBParams/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.23ms57.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.69ms5.53KBParams/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`900μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`540μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19) 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.publish_up DESC LIMIT 539.98ms27.17KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`937μs5.22KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`576μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`,( SELECT COUNT(`i`.`id`) FROM `tvlfg_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` 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`1.33ms5.22KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`.`catid` IN (:preparedArray5) 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.created DESC LIMIT 33.07ms24.83KBParams/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) AND `t`.`access` IN (:preparedArray4,:preparedArray5)3.32ms5.38KBParams/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`611μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`529μ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 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 ASC535μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT username FROM tvlfg_users WHERE id = 51 AND block = 014.08ms856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29Copy
  • SELECT username FROM tvlfg_users WHERE id = 51 AND block = 0162μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29Copy
  • SELECT username FROM tvlfg_users WHERE id = 51 AND block = 0127μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1343μ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)207μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration328μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'184μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field158μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'136μ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` = 1199μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?164μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?4.73ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy