Show Guide: 'Above Suspicion'

Synopsis: From award-winning writer Lynda La Plante, Above Suspicion follows the detective careers of DC Anna Travis (Kelly Reilly, Yellowstone) and her police partner DCI James Langton (Ciaran Hinds, Game of Thrones) as they investigate shocking crimes and seek to bring sadistic and merciless killers to justice. Under the unorthodox guidance of Langton, rookie Travis must negotiate a series of killings shocking even to the most hardened detective and defy the challenges of these brutal crimes to rise up the ranks of the police force. While investigating the mutilated body of a young woman whose death seems to echo that of a notorious unsolved murder from the 1940s, Travis and Langton will have their detective skills pushed to the limits as they seek to bring those above suspicion to justice.

The Cast:

Production Credits:

The Episodes:
Season One Episode Guide (BritBox)
1-01 Above Suspicion (Part 1)--08/22/2023
For eight years, someone has been murdering women, following the same brutal ritual each time. The most recent victim doesn't fit the profile, but evidence links her to the others. Anna volunteers to go undercover to crack the case.
Written by: Linda La Plante
Directed by: Christopher Menaul

1-02 Above Suspicion (Part 2)--08/22/2023
Langton permits rookie Anna Travis to go on a date to the ballet with actor Alan Daniels, the prime suspect in serial killings involving low-rent prostitutes to gain information and mislead him.
Written by: Linda La Plante
Directed by: Christopher Menaul


Season Two Episode Guide (Britbox)
2-01 The Real Dahlia (Part 1)--08/22/2023
When a dismembered and mutilated body of a beautiful young woman is found, the copycat murderer contacts a journalist to point out similarities to the infamous Black Dahlia murder in Los Angeles in 1947.
Written by: Linda La Plante
Directed by: Gillies MacKinnon

2-02 The Real Dahlia (Part 2)--08/22/2023
Anna becomes involved romantically with the tabloid journalist covering the murder, and an anonymous phone call leads LBangton to an aristocratic ex-army surgeon as the chief suspect in the murders.
Written by: Linda La Plante
Directed by: Gillies MacKinnon

2-03 The Real Dahlia (Part 3)--08/22/2023
Langton is sure arrogant, aristocratic Charles Wickenham , aided and abetted by his incestuous family is guilty of the horrific copycat murders.
Written by: Linda La Plante
Directed by: Gillies MacKinnon


Season Three Episode Guide (Britbox)
3-01 Deadly Intent (Part 1)--08/22/2023
In Mexico someone is having plastic surgery. On a London estate disgraced ex-cop Frank Brandon is found shot dead in a crack den and Anna,now an inspector,joins the hunt for the killer. Frank had a girl-friend but had recently married Julia Larson,a wealthy Danish woman for whom he has briefly worked as her chauffeur.
Written by: Linda La Plante and Noel Farragher
Directed by: Gillies MacKinnon

3-02 Deadly Intent (Part 2)--08/22/2023
Whilst Roache admits to shooting Frank in a panic he denies killing Danny. Middle-class drop-out and user Julian D'Anton's prints are on Danny's car though Langton considers him too small-time to be a murderer. From a photograph Anna identifies Julia's ex-husband Collingwood as an international criminal and asks Sam Power to contact the FBI for details of his crimes in America,though Julia denies all knowledge,even after her accountant,Rushton,is found dead
Written by: Linda La Plante and Noel Farragher
Directed by: Gillies MacKinnon

3-03 Deadly Intent (Part 3)--08/22/2023
Julia's husband Anthony Collingwood is an alternate identity for international drug dealer Alexander Fitzpatrick, who only seems to care about his son.
Written by: Linda La Plante and Noel Farragher
Directed by: Gillies MacKinnon


Season Four Episode Guide (Britbox)
4-01 Silent Scream (Part 1)--08/22/2023
Langton suspects that the reasons he lost out on a promotion to commander is affirmative action and someone resurrecting the Fitzpatrick Case. He takes on the murder of a young actress in order to resolve these questions.
Written by: Linda La Plante
Directed by: Catherine Morshead

4-02 Silent Scream (Part 2)--08/22/2023
Three of Amanda's lovers fall under suspicion, and Lamgton confronts Anna to find out if she is the one who cost him his promotion.
Written by: Linda La Plante
Directed by: Catherine Morshead

4-03 Silent Scream (Part 3)--08/22/2023
Felicity's dead body is found in the mirror and it's revealed that Jeanie Bale was blackmailing Amanda's parents with her diary.
Written by: Linda La Plante
Directed by: Catherine Morshead

9.215MBMemory Usage177msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.32
Identityguest
Response200
Templateja_blockk
Database
Server
mysql
Version
8.0.39-cll-lve
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "86b2c08b2c9b2adb30aa621284b55eb4" => "e3drtjac2tdonj51dnqrbnt9l6" ]
$_SERVER
array:49 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1753656375 "last" => 1753656377...
registry
array:3 [ "data" => array:1 [ "com_content" => array:1 [ "author" => array:1 [ "...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (5.05ms)
  • afterInitialise (1.27MB) (33.82ms)
  • afterRoute (281.67KB) (8.62ms)
  • beforeRenderComponent com_content (38.25KB) (1.02ms)
  • Before Access::preloadComponents (all components) (34.7KB) (893μs)
  • After Access::preloadComponents (all components) (109.3KB) (1.14ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (18μs)
  • After Access::preloadPermissions (com_content) (3.07MB) (12.32ms)
  • Before Access::getAssetRules (id:5033 name:com_content.article.4199) (258.8KB) (220μs)
  • After Access::getAssetRules (id:5033 name:com_content.article.4199) (8.47KB) (272μs)
  • beforeRenderRawModule mod_related_items (Read More) (861.5KB) (58.91ms)
  • afterRenderRawModule mod_related_items (Read More) (38.5KB) (9.71ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (14μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (241μs)
  • afterRenderComponent com_content (49.04KB) (107μs)
  • afterDispatch (2.28KB) (260μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (21.3ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (554μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (214μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (50μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (150μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (118μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (91μs)
  • afterRenderRawModule mod_finder (Head Search) (69.33KB) (6ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (12μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (247μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (87μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (443μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (115μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (53μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (108μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (127μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (29μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (106μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (115μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (27μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (191μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (113μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.2ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.64ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (90μs)
  • afterRender (673.04KB) (9.53ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (861.5KB) (33.33%)
    58.91ms
    1 x afterInitialise (1.27MB) (19.14%)
    33.82ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.23KB) (12.05%)
    21.30ms
    1 x After Access::preloadPermissions (com_content) (3.07MB) (6.97%)
    12.32ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.5KB) (5.5%)
    9.71ms
    1 x afterRender (673.04KB) (5.39%)
    9.53ms
    1 x afterRoute (281.67KB) (4.88%)
    8.62ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.33KB) (3.4%)
    6.00ms
    1 x afterLoad (528.66KB) (2.86%)
    5.05ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (1.5%)
    2.64ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.68%)
    1.20ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.65%)
    1.14ms
    1 x beforeRenderComponent com_content (38.25KB) (0.58%)
    1.02ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.51%)
    893μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.31%)
    554μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.25%)
    443μs
    1 x After Access::getAssetRules (id:5033 name:com_content.article.4199) (8.47KB) (0.15%)
    272μs
    1 x afterDispatch (2.28KB) (0.15%)
    260μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.14%)
    247μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.14%)
    241μs
    1 x Before Access::getAssetRules (id:5033 name:com_content.article.4199) (258.8KB) (0.12%)
    220μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.12%)
    214μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.11%)
    191μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    150μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.07%)
    127μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.07%)
    118μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.07%)
    115μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.07%)
    115μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.06%)
    113μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.06%)
    108μs
    1 x afterRenderComponent com_content (49.04KB) (0.06%)
    107μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    106μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.05%)
    91μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.05%)
    90μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.05%)
    87μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    53μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    50μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    29μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    14μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0.01%)
    12μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (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%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
46 statements were executed, 3 of which were duplicates, 43 unique65.58ms431.93KB
  • SELECT @@SESSION.sql_mode;70μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?134μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1123μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `tvlfg_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id599μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1472μs2.19KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`2.81ms976B/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` = :guest293μ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`812μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'6.8ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC355μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='4199-show-guide-above-suspicion' AND published=1255μ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`728μ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`748μ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` = 1274μ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)679μ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.72ms249.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.23ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '4199'17.27ms48B/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)920μ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`2.82ms5.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.75ms5.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`854μ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 ASC561μ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.09ms2.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`738μ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.id194μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'181μ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 ordering192μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.22ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid264μ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` = :muserid242μ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 ASC398μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'110μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5182μ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`2.02ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id260μ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 57.28ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1547μ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)290μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration244μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'118μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field107μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'107μ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` = 1144μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?137μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?336μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy