Show Guide: 'The Brokenwood Mysteries'

Synopsis: From seemingly supernatural incidents in the idyllic community of Brokenwood to mysterious murders with hidden motives, Shepherd (Neill Rea, The Warrior’s Way), and his team plunge into a web of deception, greed, and dark secrets as they tackle their most perplexing cases yet. (Courtesy Acorn TV, 2025)

The Cast:
Neill Rea as DS Mike Shepherd
Fern Sutherland as Det. Kristin Sims
Pana Hema Taylor as Jared Morehu
Nic Sampson as DC Sam Breen
Cristina Serban Ionda as Dr. Gina Kadinsky

Production Credits:

The Episodes:
Season One Episode Guide
1-01 Blood And Water--09/28/2014
When two fishermen find the body of a local farmer in the river, Detective Inspector Mike Shepherd is sent to the small rural town of Brokenwood to investigate the death. Is this the suicide of a man guilty of his own wife's murder or is he the victim of foul play? As Mike uncovers a family's tragedies and secrets he also learns that Brokenwood is a place where shadows lurk just beneath the surface.
Written by: Philip Dalkin & Timothy Balme
Directed by: Mike Smith

1-02 Sour Grapes--10/05/2014
With Brokenwood touted for its burgeoning merlot, the annual wine show is a major event. Having bought a 10-acre block with maturing grapes, no one is looking forward to it more than DI Mike Shepherd. But when a guest judge and wine critic is found dead, drowned inside a fermenting vat, the show takes second place to the murder investigation.
Written by: Timothy Balme
Directed by: Joshua Frizzell

1-03 Playing The Lie--10/12/2014
A group of erstwhile members of the Brokenwood Golf Club, committee members no less, have gathered for their regular Wednesday morning round. They are playing their approaches to the first green when a zombie-like figure lurches from the early-morning gloom, coming towards them. It takes the golfers a moment or two (apparently) to realise this is actually Adele Stone, the Club owner - her face red and blistering; gasping desperately for breath. Then she falls from sight, into a greenside bunker. By the time the guys get to her, Ms Stone is very much dead. And so Mike and Kristin are called to investigate what appears to be homicide by poisoning.
Written by: James Griffin
Directed by: Michael Hurst

1-04 Hunting The Stag--10/19/2014
Four close friends go hunting in the bush on a stag trip. But the groom-to-be never comes back - he was shot through the head. Initially this would seem to be just another tragic hunting accident amidst picturesque New Zealand bush. The only problem is neither of the remaining two friends own up to pulling the trigger that fired the lethal bullet - yet all three had discharged their rifles - with no deer to prove it. The question is - who shot Hayden Renner? Was he mistaken for a real stag or was there something more sinister at play?
Written by: Phillip Dalkin & Timothy Balme
Directed by: Mike Smith


Season Two Episode Guide
2-01 Leather & Lace--09/27/2015
The Brokenwood Cheetahs are a local rugby team of legendary status. Their losing streak of 50 straight games has broken national records. So when their hapless coach, Arnie Langstone, is found dead - stripped naked and strapped to a goalpost - some think it might be blessing in disguise - perhaps now they might start winning again. But amidst this DSS Mike Shepherd is perplexed by several other issues. Firstly, why was a pair of women's underwear stuffed down Arnie's throat? And what do the neatly embroidered initials ‘G.G.' signify? Then a second body is discovered and Mike and his team are stretched to the limit. Is this the work of a serial killer or merely a puzzling co-incidence?
Written by: Timothy Balme & Nick Ward
Directed by: Mike Smith

2-02 To Die Or Not To Die--10/04/2015
When a young cast member of The Brokenwood Theatre Society collapses and dies at the end of a performance of Hamlet, the initial belief is that it was from natural causes. However, Mike detects there is ‘something rotten in the state of Brokenwood' when he gets a whiff of a lethal poison. In doing so he uncovers a complex web of ego driven dissention amongst the troupe. Was Ben Faulkner expended to create opportunity for another young rising star? Or can his death be linked to the words of the Bard himself? And how did Jared end up playing the lead role? As Mike and his team investigate the hidden secrets of this curious group of thespians ‘To be or not to be' takes on a whole new meaning.
Written by: Timothy Balme
Directed by: Murray Keane

2-03 Catch Of The Day--10/10/2015
The bucolic coastal waters off Brokenwood support a thriving fishing industry. But when Jared discovers a severed human hand in a crayfish pot it appears to be harboring something far more sinister. Who does the hand belong to and are they still alive? The finger is pointed at the Keely family; fishermen for generations who are very protective of their patch. But what about the deceased's wife who was out at sea, out of cell phone range and out for a good time? And the volunteer fisheries officer seems to be a man who is doing God's work as much as protecting the marine life. As Mike, Kristin and Breen set about fathoming the dark undercurrents of the coastal sea they will be surprised by what lies beneath.
Written by: Greg McGee
Directed by: Mike Smith

2-04 Blood Pink--10/18/2015
Holly Collins is not only DSS Mike Shepherd's favorite country musician she's also playing in Brokenwood. Unfortunately it turns out to be her final gig. When she is found electrocuted it appears to be a rock'n'roll suicide. But then again it could have been a drunken accident - or, as Mike suspects, it is perhaps something less obvious. With a careless note scrawled in lipstick the only clue, Mike has to set aside his personal interest in the victim and strike the right note with Holly's dysfunctional band members: Slim Fingers, Waylon Strings and Jesse James. But the more he finds out, the more he needs to know and the less he likes what he learns.
Written by: Timothy Balme
Directed by: Joshua Frizzell



9.055MBMemory Usage148msRequest 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" => 1746159135 "last" => 1746159135...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (7.21ms)
  • afterInitialise (1.26MB) (27.43ms)
  • afterRoute (281.69KB) (9.22ms)
  • beforeRenderComponent com_content (38.25KB) (1.42ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.21ms)
  • After Access::preloadComponents (all components) (109.3KB) (863μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (19μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (11.79ms)
  • Before Access::getAssetRules (id:4668 name:com_content.article.3834) (258.8KB) (203μs)
  • After Access::getAssetRules (id:4668 name:com_content.article.3834) (8.47KB) (278μs)
  • beforeRenderRawModule mod_related_items (Read More) (862.02KB) (34.31ms)
  • afterRenderRawModule mod_related_items (Read More) (38.52KB) (8.22ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (9μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (192μs)
  • afterRenderComponent com_content (49.04KB) (81μs)
  • afterDispatch (2.28KB) (248μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (22.99ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (608μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (224μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (49μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (131μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (92μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (69μs)
  • afterRenderRawModule mod_finder (Head Search) (69.37KB) (4.25ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (176μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (44μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (337μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (4μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (83μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (38μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (80μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (3μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (92μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (21μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (78μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (3μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (85μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (21μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (123μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (4μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (95μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.4ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (3.13ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (120μs)
  • afterRender (673.13KB) (10.22ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (862.02KB) (23.13%)
    34.31ms
    1 x afterInitialise (1.26MB) (18.49%)
    27.43ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (15.5%)
    22.99ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (7.95%)
    11.79ms
    1 x afterRender (673.13KB) (6.89%)
    10.22ms
    1 x afterRoute (281.69KB) (6.22%)
    9.22ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.52KB) (5.54%)
    8.22ms
    1 x afterLoad (528.29KB) (4.86%)
    7.21ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.37KB) (2.87%)
    4.25ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.11%)
    3.13ms
    1 x beforeRenderComponent com_content (38.25KB) (0.95%)
    1.42ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.94%)
    1.40ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.81%)
    1.21ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.58%)
    863μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.41%)
    608μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.23%)
    337μs
    1 x After Access::getAssetRules (id:4668 name:com_content.article.3834) (8.47KB) (0.19%)
    278μs
    1 x afterDispatch (2.28KB) (0.17%)
    248μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.15%)
    224μs
    1 x Before Access::getAssetRules (id:4668 name:com_content.article.3834) (258.8KB) (0.14%)
    203μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.13%)
    192μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.12%)
    176μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.09%)
    131μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.08%)
    123μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.08%)
    120μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.06%)
    95μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    92μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.06%)
    92μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    85μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.06%)
    83μs
    1 x afterRenderComponent com_content (49.04KB) (0.05%)
    81μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.05%)
    80μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.05%)
    78μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    69μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    49μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.03%)
    44μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    38μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    9μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    3μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    3μs
46 statements were executed, 3 of which were duplicates, 43 unique32.91ms411.9KB
  • SELECT @@SESSION.sql_mode;95μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?142μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 181μ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)1.6ms944BParams/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` = 1361μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`208μ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` = :guest205μ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`746μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'449μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC177μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='3834-show-guide-the-brokenwood-mysteries' AND published=1185μ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`552μ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`652μ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` = 1205μ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)504μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 04.01ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.93ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '3834'376μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `tvlfg_content` AS `a` INNER JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `tvlfg_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)621μ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`759μ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.35ms5.23KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `tvlfg_categories` AS `s` INNER JOIN `tvlfg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`692μ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 ASC499μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC2.55ms2.78KBParams/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`708μ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.id136μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'129μ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 ordering150μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.11ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid136μ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` = :muserid155μ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 ASC353μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'90μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5178μs856B/plugins/system/t4/src/t4/MVC/Router/T4.php:288Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tvlfg_modules` AS `m` LEFT JOIN `tvlfg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tvlfg_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`747μs18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id119μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 56.26ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1694μ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)216μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration318μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'137μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field109μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'102μ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` = 1268μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?123μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?815μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy