Show Guide: 'Grantchester'

Synopsis: A jazz-loving village clergyman starts working with the local police chief to solve crimes in 1950s England. Based on the books by James Runcie.

The Cast:
Robson Green as Det. Insp. Geordie Keating
James Norton as Rev. Sidney Chambers
Tom Brittney as Rev. Will Davenport
Al Weaver as Leonard Finch
Tessa Peake-Jones as Mrs. Maguire/Chapman
Kacey Ainsworth as Cathy Keating
Nick Brimble as Jack Chapman
Oliver Dimsdale as Daniel Marlowe
Gary Beadle as Archdeacon Gabriel Atubo
Bradley Hall as Larry Peters
Morven Christie as Amanda Kendall/Hopkins
Selin Hizli as Margaret Ward
Lorne MacFadyen as Phil Wilkinson
Tom Austen as Guy Hopkins

Production Credits:

The Episodes:
Season One Episode Guide (PBS)
1-01 Episode 1--
Detective drama set in a 1950s Cambridgeshire village, where local vicar Sidney Chambers (James Norton) develops a sideline in sleuthing - with the initially reluctant help of grumpy DI Geordie Keating (Robson Green). The cleric's first case finds him presiding over the funeral of a solicitor, who is believed to have taken his own life. However, the dead man's mistress has a different theory - and feeling unable to go to the police, she asks Sidney to examine it for her. He uncovers evidence that the suicide was staged, but while he's busy delving into the personal life of the victim, will the vicar miss his own big chance with Amanda Kendall (Morven Christie), the woman he secretly loves?
Written by: Daisy Coulam
Directed by: Harry Bradbeer

1-02 Episode 2--
Poor Sidney. His sister Jen bullies him into attending Amanda's engagement dinner - seeing the love of his life celebrate her betrothal to another man is the last thing the village vicar wants. He sinks a few too many drinks in a bid to make the evening more palatable, but it doesn't work - in fact, nobody at the event seems happy. Tensions rise between Amanda and Jen's old school friends, and then matters erupt when Jen's boyfriend Johnny (Ukweli Roach, Starlings) is accused of stealing Amanda's engagement ring. Later, the unfortunate chap is accused of murdering one of his fellow guests, and evidence at the scene of the crime seems to back up the theory. But Sidney isn't convinced - can he unmask the real killer?
Written by: Daisy Coulam
Directed by: Harry Bradbeer

1-03 Episode 3--
A heartbroken Sidney agrees to help parishioner Isabel prepare for her wedding to Arthur, the new man in town, but the bride's stubborn mother, Daisy, proves to be a big impediment to the occasion as she believes the groom is out to kill her. When Daisy is then found dead, Mrs Maguire calls in Geordie to investigate, and Sidney finds himself dragged into the case - despite vowing to leave police business behind. While the victim seems to have died of natural causes, Arthur and Isabel are pushing for a fast cremation, suggesting the couple have something to hide.
Written by: Daisy Coulam
Directed by: Jill Robertson

1-04 Episode 4--
Sidney is woken in the early hours by a fire in the village and, putting his life on the line, races to rescue Marion Taylor from the burning house, much to the relief of her husband Dominic. But there are questions surrounding the blaze - was it really an accident, and why was Marion so reluctant to leave? Normally Sidney would turn to Geordie to help solve a mystery like this, but he finds the detective is far from his usual self. When Dominic is then found stabbed to death, it's Geordie's junior, Atkins, who is sent to head up the case - and he's not exactly a fan of interfering vicars.
Written by: Daisy Coulam
Directed by: Jill Robertson

1-05 Episode 5--
Sidney takes Geordie to Johnny Johnson's London jazz club, hoping to leave their worries in Grantchester for the night, but the backstage murder of Johnny's sister Claudette puts paid to that. When Archie, the victim's father and owner of the club, calls in a police officer pal to crack the case, Geordie immediately detects the copper is corrupt, while Sidney makes an important discovery about Claudette that she had kept hidden from all but those closest to her. As every lead seems to come back to Archie's violent past, recriminations within the family begin to play out.
Written by: Daisy Coulam
Directed by: Tim Fywell

1-06 Episode 6--
With Amanda and Guy's wedding fast approaching, and his betrayal of Hildegard still fresh in his mind, Sidney is thrown deep into crisis, and the murder of a local cop doesn't help matters as he allows himself to become drawn into another case with Geordie. However, tragedy strikes as the duo close in on the killer, and with Geordie's life hanging in the balance, the clergyman finds himself cut out of the investigation as the police close ranks. But that doesn't stop him enlisting the help of Mrs Maguire and Leonard in a daring mission to gather information on the man who shot his partner.
Written by: Daisy Coulam
Directed by: Tim Fywell


Season Two Episode Guide (PBS)
2-01 Episode 1--
2-02 Episode 2--
2-03 Episode 3--
2-04 Episode 4--
2-05 Episode 5--
2-06 Episode 6--


Season Three Episode Guide (PBS)
3-01 Episode 1--
3-02 Episode 2--
3-03 Episode 3--
3-04 Episode 4--
3-05 Episode 5--
3-06 Episode 6


Season Four Episode Guide (PBS)
4-01 Episode 1--
4-02 Episode 2--
4-03 Episode 3--
4-04 Episode 4--
4-05 Episode 5--
4-06 Episode 6--


Season Five Episode Guide (PBS)
5-01 Episode 1--
5-02 Episode 2--
5-03 Episode 3--
5-04 Episode 4--
5-05 Episode 5--
5-06 Episode 6--


Season Six Episode Guide (PBS)
6-01 Episode 1--
6-02 Episode 2--
6-03 Episode 3--
6-04 Episode 4--
6-05 Episode 5--
6-06 Episode 6--
Will and Geordie investigate an audacious bank robbery, which sees Geordie unexpectedly cross paths with an old friend from his army days.
6-07 Episode 7--
6-08 Episode 8--
When a student falls to her death, Will and Geordie are drawn into campus politics. The Bishop introduces a new face at the vicarage.


Season Seven Episode Guide (PBS)
7-01 Episode 1--
7-02 Episode 2--
7-03 Episode 3--
7-04 Episode 4--
7-05 Episode 5--
7-06 Episode 6--


Season Eight Episode Guide (PBS)
8-01 Episode 1--
8-02 Episode 2--
8-03 Episode 3--
At one of Cambridge’s most prestigious colleges, a man is murdered and a valuable painting is stolen, leaving Geordie to determine if the two crimes are linked.
8-04 Episode 4--
8-05 Episode 5--
8-06 Episode 6--


Season Nine Episode Guide (PBS)
9-01 Episode 1--
9-02 Episode 2--
9-03 Episode 3--
9-04 Episode 4--
9-05 Episode 5--
9-06 Episode 6--
9-07 Episode 7--
9-08 Episode 8--


9.053MBMemory Usage161msRequest 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" => 1746053187 "last" => 1746053187...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (5.15ms)
  • afterInitialise (1.26MB) (36.65ms)
  • afterRoute (281.67KB) (7.26ms)
  • beforeRenderComponent com_content (38.3KB) (891μs)
  • Before Access::preloadComponents (all components) (34.7KB) (744μs)
  • After Access::preloadComponents (all components) (109.3KB) (764μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (18μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (10.15ms)
  • Before Access::getAssetRules (id:2789 name:com_content.article.1960) (258.8KB) (197μs)
  • After Access::getAssetRules (id:2789 name:com_content.article.1960) (8.47KB) (274μs)
  • beforeRenderRawModule mod_related_items (Read More) (861.48KB) (38.22ms)
  • afterRenderRawModule mod_related_items (Read More) (38.48KB) (10.2ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (19μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (312μs)
  • afterRenderComponent com_content (49.04KB) (125μs)
  • afterDispatch (2.28KB) (356μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (24.83ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (492μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (214μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (41μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (117μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (89μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (70μs)
  • afterRenderRawModule mod_finder (Head Search) (69.34KB) (3.46ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (6μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (245μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (60μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (401μ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) (52μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (114μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (149μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (31μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (117μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (135μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (29μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (173μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (6μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (130μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.55ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (3.64ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (11μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (172μs)
  • afterRender (673.13KB) (12.33ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (861.48KB) (23.8%)
    38.22ms
    1 x afterInitialise (1.26MB) (22.83%)
    36.65ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (15.46%)
    24.83ms
    1 x afterRender (673.13KB) (7.68%)
    12.33ms
    1 x afterRenderRawModule mod_related_items (Read More) (38.48KB) (6.35%)
    10.20ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (6.32%)
    10.15ms
    1 x afterRoute (281.67KB) (4.52%)
    7.26ms
    1 x afterLoad (528.66KB) (3.21%)
    5.15ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.26%)
    3.64ms
    1 x afterRenderRawModule mod_finder (Head Search) (69.34KB) (2.15%)
    3.46ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.96%)
    1.55ms
    1 x beforeRenderComponent com_content (38.3KB) (0.55%)
    891μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.48%)
    764μs
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.46%)
    744μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.31%)
    492μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.25%)
    401μs
    1 x afterDispatch (2.28KB) (0.22%)
    356μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.19%)
    312μs
    1 x After Access::getAssetRules (id:2789 name:com_content.article.1960) (8.47KB) (0.17%)
    274μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.15%)
    245μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.13%)
    214μs
    1 x Before Access::getAssetRules (id:2789 name:com_content.article.1960) (258.8KB) (0.12%)
    197μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.11%)
    173μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.11%)
    172μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.09%)
    149μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.08%)
    135μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.08%)
    130μs
    1 x afterRenderComponent com_content (49.04KB) (0.08%)
    125μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.07%)
    117μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.07%)
    117μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.07%)
    115μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.07%)
    114μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    89μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    70μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.04%)
    60μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    52μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    41μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    31μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    29μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    6μ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 (Off Canvas) (720B) (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 (Other Content) (720B) (0%)
    4μs
46 statements were executed, 3 of which were duplicates, 43 unique49.86ms411.52KB
  • SELECT @@SESSION.sql_mode;99μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?178μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 199μ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.33ms944BParams/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` = 1403μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`111μ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` = :guest206μ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`748μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'9.88ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC162μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='1960-show-guide-grantchester' AND published=1179μ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`638μ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`507μ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` = 1194μ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)469μ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` = 03.66ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.59ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1960'876μ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)531μ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`649μ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.42ms5.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`813μ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 ASC562μ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 DESC734μs2.41KBParams/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`733μ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.id331μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'214μ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 ordering217μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.77ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid245μ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` = :muserid254μ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 ASC529μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'157μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51109μ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`997μs18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id156μ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 58.32ms1.74KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1509μ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)204μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration284μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'140μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field128μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'119μ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` = 1141μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?128μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?7.14ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy