One Season TV: 'Thanks'

One Season TV: 'Thanks'

The 1960s and early 1970s were the golden age of television shows built around truly insane concepts. A mother reincarnated inside a car (My Mother The Car), a comedy set inside a German WWII prisoner-of-war camp (Hogan's Heroes), a show about a group of inept calvary men and the Native Americans who cheat and trick them (F-Troop). That type of television has mostly fell out of favor by the 1990s, but briefly resurfaced later in the decade with shows such as The Secret Diary Of Desmond Pfeiffer and the 1996 short-lived CBS comedy Thanks.

Thanks was created by Phoef Sutton and Mark Legan, both of whom had impressive TV credits. Legan was just coming off of stints on Dave's World and Grace Under Fire. And Sutton had previously worked on Bob and Cheers. So if anyone could pull off a comedy about the Puritans settling in America, these two guys could do it. And having watched all six episodes recently, the resulting show has some brilliant moments. But I also have a feeling that there was some network pushback about the execution, because there is definitely a shift in tone after episode four.

The series begins with the Pilgrim's first spring in the New World. There has been more snow and a lot less food than they had expected and a lot of the humor is based around the hunger and the group's puritan ways. Mark Dutton plays James Winthrop, who runs the local general store with his wife Polly (Kirsten Nelson). They have three children - Abigail (Erika Christensen), Elizabeth (Amy Centner) and William (Andrew Ducote). The family also includes James's mother Grammy Winthrop (played by Cloris Leachman). Jim Rash plays John Cotton, the self-described "village idiot," and the role feels as if it was originally written for Chris Elliott.

There are a couple of running jokes in the first group of episodes, including one involving a long-winded, the very religious Reverend Goodacre (Keith Szarabajka) who sees the hand of the devil in even the most everyday activities. There are lots of jokes about potential sinful behavior and the hypocritical behavior of the townspeople. When confronted with tobacco for the first time, the magistrate suggests it must be a sin and should be abolished. "But shouldn't we try something before we say it's a sin?," asks someone. "We never have before now," he replies. People are thrown into the stocks for dancing and in one episode Elizabeth is thrown into the stocks for seemingly predicting a future that sounds a lot like our modern-day lives.

In fact, ten-year old Elizabeth is part of one of the most consistent running gags in the show. She is constantly suggesting better ways of doing things or wondering out loud whether the world might someday change in an unexpected way. When examining the incredibly small carrots the villagers grew in their first harvest, she wonders out loud if someday someone might be able to sell the wee carrots for extra money by claiming that they are "gourmet." "Marketing," she explains to her father. "It's all about the marketing."

Cloris Leachman doesn't have much to do in the first couple of episodes, but episode three has her lobbying for her own room and it gives her a chance to show off her impressive ability to chew up scenery and deliver a punchline. She's also the center of episode five, in which she falls for a traveling salesman played by Orson Bean. That episode might have the funniest line in the series: "My mother always told me, you don't buy a mule before you ride it."

Episode six is the final episode and it is probably also the most consistent. Viewers are finally introduced to the local Native American tribe, who teaches them how to grow crops and catch turkeys. The episode ends with a Thanksgiving meal and a bunch of jokes that mock the impact the Pilgrims would eventually have on this new world (or at least, a world that is new to them).

The episodes do take a bit of a shift in tone midway through the season. A lot of the jokes about sinful behavior and the stocks go away, which makes me suspect that the network was concerned some viewers might be offended by the light-hearted mocking of religion. Regardless, Thanks has some funny moments and I suspect if it had received a longer episode order (and hadn't been burned off in August), it might have survived and lasted several seasons. 

Several of the cast later had memorable roles in other television shows. A decade later, Jim Rash played Dean Craig Pelton on the NBC sitcom Community. Kirsten Nelson went on to play police chief Karen Vick on Psych and Erika Christensen has appeared in a number of movies and television shows, ranging from Traffic to the character Julia Braverman-Graham on Parenthood. 

The entire premiere episode of the show is posted above and you can click here for an episode guide for the series.


One Season TV: 'Thanks'
Watch the video

The 1960s and early 1970s were the golden age of television shows built around truly insane concepts. A mother reincarnated inside a car (My Mother The Car), a comedy set inside a German WWII prisoner-of-war camp (Hogan's Heroes), a show about a group of inept calvary men and the Native Americans who cheat and trick them (F-Troop). That type of television has mostly fell out of favor by the 1990s, but briefly resurfaced later in the decade with shows such as The Secret Diary Of Desmond Pfeiffer and the 1996 short-lived CBS comedy Thanks.

Thanks was created by Phoef Sutton and Mark Legan, both of whom had impressive TV credits. Legan was just coming off of stints on Dave's World and Grace Under Fire. And Sutton had previously worked on Bob and Cheers. So if anyone could pull off a comedy about the Puritans settling in America, these two guys could do it. And having watched all six episodes recently, the resulting show has some brilliant moments. But I also have a feeling that there was some network pushback about the execution, because there is definitely a shift in tone after episode four.

The series begins with the Pilgrim's first spring in the New World. There has been more snow and a lot less food than they had expected and a lot of the humor is based around the hunger and the group's puritan ways. Mark Dutton plays James Winthrop, who runs the local general store with his wife Polly (Kirsten Nelson). They have three children - Abigail (Erika Christensen), Elizabeth (Amy Centner) and William (Andrew Ducote). The family also includes James's mother Grammy Winthrop (played by Cloris Leachman). Jim Rash plays John Cotton, the self-described "village idiot," and the role feels as if it was originally written for Chris Elliott.

There are a couple of running jokes in the first group of episodes, including one involving a long-winded, the very religious Reverend Goodacre (Keith Szarabajka) who sees the hand of the devil in even the most everyday activities. There are lots of jokes about potential sinful behavior and the hypocritical behavior of the townspeople. When confronted with tobacco for the first time, the magistrate suggests it must be a sin and should be abolished. "But shouldn't we try something before we say it's a sin?," asks someone. "We never have before now," he replies. People are thrown into the stocks for dancing and in one episode Elizabeth is thrown into the stocks for seemingly predicting a future that sounds a lot like our modern-day lives.

In fact, ten-year old Elizabeth is part of one of the most consistent running gags in the show. She is constantly suggesting better ways of doing things or wondering out loud whether the world might someday change in an unexpected way. When examining the incredibly small carrots the villagers grew in their first harvest, she wonders out loud if someday someone might be able to sell the wee carrots for extra money by claiming that they are "gourmet." "Marketing," she explains to her father. "It's all about the marketing."

Cloris Leachman doesn't have much to do in the first couple of episodes, but episode three has her lobbying for her own room and it gives her a chance to show off her impressive ability to chew up scenery and deliver a punchline. She's also the center of episode five, in which she falls for a traveling salesman played by Orson Bean. That episode might have the funniest line in the series: "My mother always told me, you don't buy a mule before you ride it."

Episode six is the final episode and it is probably also the most consistent. Viewers are finally introduced to the local Native American tribe, who teaches them how to grow crops and catch turkeys. The episode ends with a Thanksgiving meal and a bunch of jokes that mock the impact the Pilgrims would eventually have on this new world (or at least, a world that is new to them).

The episodes do take a bit of a shift in tone midway through the season. A lot of the jokes about sinful behavior and the stocks go away, which makes me suspect that the network was concerned some viewers might be offended by the light-hearted mocking of religion. Regardless, Thanks has some funny moments and I suspect if it had received a longer episode order (and hadn't been burned off in August), it might have survived and lasted several seasons. 

Several of the cast later had memorable roles in other television shows. A decade later, Jim Rash played Dean Craig Pelton on the NBC sitcom Community. Kirsten Nelson went on to play police chief Karen Vick on Psych and Erika Christensen has appeared in a number of movies and television shows, ranging from Traffic to the character Julia Braverman-Graham on Parenthood. 

The entire premiere episode of the show is posted above and you can click here for an episode guide for the series.


8.653MBMemory Usage169msRequest 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" => 1744289011 "last" => 1744289011...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.53ms)
  • afterInitialise (1.26MB) (33.52ms)
  • afterRoute (281.67KB) (9.64ms)
  • beforeRenderComponent com_content (38.16KB) (1.5ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.32ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.32ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (22μs)
  • After Access::preloadPermissions (com_content) (2.41MB) (13.6ms)
  • Before Access::getAssetRules (id:3755 name:com_content.article.2921) (130.8KB) (292μs)
  • After Access::getAssetRules (id:3755 name:com_content.article.2921) (8.47KB) (270μs)
  • beforeRenderRawModule mod_related_items (Read More) (865.85KB) (44.35ms)
  • afterRenderRawModule mod_related_items (Read More) (12.58KB) (1.84ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (9μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (269μs)
  • afterRenderComponent com_content (43.41KB) (84μs)
  • afterDispatch (2.28KB) (318μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (28.03ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (624μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (209μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (47μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (133μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (96μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (71μs)
  • afterRenderRawModule mod_finder (Head Search) (75.87KB) (3.82ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (9μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (242μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (64μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (504μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (109μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (50μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (106μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (126μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (29μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (107μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (129μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (47μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (184μ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.57ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.56ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (5μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (91μs)
  • afterRender (679.84KB) (12.82ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (865.85KB) (26.26%)
    44.35ms
    1 x afterInitialise (1.26MB) (19.85%)
    33.52ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (16.6%)
    28.03ms
    1 x After Access::preloadPermissions (com_content) (2.41MB) (8.05%)
    13.60ms
    1 x afterRender (679.84KB) (7.59%)
    12.82ms
    1 x afterRoute (281.67KB) (5.71%)
    9.64ms
    1 x afterLoad (528.29KB) (4.46%)
    7.53ms
    1 x afterRenderRawModule mod_finder (Head Search) (75.87KB) (2.26%)
    3.82ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (1.52%)
    2.56ms
    1 x afterRenderRawModule mod_related_items (Read More) (12.58KB) (1.09%)
    1.84ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.93%)
    1.57ms
    1 x beforeRenderComponent com_content (38.16KB) (0.89%)
    1.50ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.78%)
    1.32ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.78%)
    1.32ms
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.37%)
    624μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.3%)
    504μs
    1 x afterDispatch (2.28KB) (0.19%)
    318μs
    1 x Before Access::getAssetRules (id:3755 name:com_content.article.2921) (130.8KB) (0.17%)
    292μs
    1 x After Access::getAssetRules (id:3755 name:com_content.article.2921) (8.47KB) (0.16%)
    270μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.16%)
    269μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.14%)
    242μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.12%)
    209μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.11%)
    184μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    133μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.08%)
    129μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.07%)
    126μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.07%)
    121μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.06%)
    109μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    107μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.06%)
    106μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    96μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.05%)
    91μs
    1 x afterRenderComponent com_content (43.41KB) (0.05%)
    84μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    71μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.04%)
    64μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    50μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    47μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.03%)
    47μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    29μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    22μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0.01%)
    9μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    9μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
45 statements were executed, 3 of which were duplicates, 42 unique46.76ms405.45KB
  • SELECT @@SESSION.sql_mode;109μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?103μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 178μ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)547μ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` = 1268μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`88μ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` = :guest162μ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`750μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'444μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC4.98ms2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='2921-one-season-tv-thanks' AND published=1188μs4.08KB/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`573μ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`490μs5.33KBParams/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` = 1414μ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)815μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 05.62ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.91ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2921'12.36ms48B/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)658μ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`698μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)1.65ms5.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`632μ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 ASC404μ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 DESC392μs2.06KBParams/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`581μ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.id152μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'173μ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 ordering165μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.12ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid133μ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` = :muserid204μ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 ASC352μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'107μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5181μ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`862μs18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id139μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1254μ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)155μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration272μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'179μ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'138μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `tvlfg_scheduler_tasks` AS `a` WHERE `a`.`state` = 1189μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?147μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?6.88ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy