Show Guide: 'Leverage: Redemption'

Synopsis: A group of reformed crooks reunite to use their unique skills to fight injustices inflicted by powerful corporate and governmental interests on common citizens. (Courtesy, Prime Video, 2025)

The Cast:
Gina Bellman as Sophie Devereaux
Christian Kane as Eliot Spencer
Beth Riesgraf as Parker
Noah Wyle as Harry Wilson
Aleyse Shannon as Breanna Casey
Aldis Hodge as Alec Hardison

Production Credits:

The Episodes:
Season One Episode Guide (Freevee)
1-01 The Too Many Rembrandts Job--07/09/2021
When the team comes together to help Sophie, they intercept guilt-ridden corporate fixer Harry and decide to help him take down an evil billionaire making money on the back of an opioid crisis.
Story by: Chris Downey/John Rogers/Dean Devlin
Teleplay by: Chris Downey & John Rogers
Directed by: Dean Devlin

1-02 The Panamanian Monkeys Job--07/09/2021
With a new team member on board plus the arrival of Hardison's genius foster sister, the team heads to Panama to pull an elaborate heist before an evil billionaire can get his money and flee to a non-extradition country.
Written by: Chris Downey & John Rogers
Directed by: Dean Devlin

1-03 The Rollin' On The River Job--07/09/2021
The Leverage team takes on a greedy riverboat casino owner, before he can bulldoze the homes of longtime New Orleans natives for his planned expansion.
Written by: Jill Weinberger
Directed by: Marc Roskin

1-04 The Tower Job--07/09/2021
One member of the team seeks redemption and justice by convincing Leverage to con a developer out of an entire luxury apartment building.
Written by: Marque Franklin-Williams & John Timothy
Directed by: Noah Wyle

1-05 The Paranormal Hacktivity Job--07/09/2021
When a woman believes she is being haunted and runs from her home in terror, Sophie leads Breanna and Parker through a con to convince the two real estate scammers responsible to target Leverage HQ.
Written by: Josh Schaer & Alayna Heim
Directed by: Marc Roskin

1-06 The Card Game Job--07/09/2021
The Leverage team dives into the world of a high fantasy collectible card game with a devoted following to take down a pharmaceutical bad boy who is price-gouging drugs to fund his own house of cards.
Written by: Marque Franklin-Williams
Directed by: Francis Dela Torre

1-07 The Double-Edged Sword Job--07/09/2021
The team takes on a brilliant software developer who is selling a groundbreaking facial recognition system that threatens everyone's privacy except his own.
Written by: Josh Schaer
Directed by: Jonathan Frakes

1-08 The Mastermind Job--07/09/2021
Sophie must keep her feelings in check when she discovers that someone has written a memoir of the team, casting himself as Nate – which leads an exiled criminal to kidnap Harry and "Fake Nate," forcing the Leverage team to pull a heist.
Written by: Kate Rorick
Directed by: Dean Devlin

1-09 The Bucket Job--10/18/2021
The Leverage team's Holiday good deed goes awry when their attempt to give a small-town librarian the spy-thriller adventure of a lifetime is interrupted by a shadowy spy organization.
Written by: Chris Downey & Jill Weinberger
Directed by: Beth Riesgraf

1-10 The Unwellness Job--10/18/2021
The Leverage team sets out to discredit a lifestyle and wellness guru targeting desperate people and peddling snake oil instead of actual medicine.
Written by: Teagan Wall & Matt Okumura
Directed by: Noah Wyle

1-11 The Jackal Job--10/18/2021
The Leverage team explores the failing memory of a legendary grifter to try and find her greatest score before her abusive Elder Guardian gets his hands on it and takes over her life.
Written by: Teagan Wall & Matt Okumura
Directed by: Marc Roskin

1-12 The Golf Job--10/08/2021
An old friend visits, sparking a self-doubting Harry to uncover an unlikely client on the links at his exclusive golf club.
Written by: Chris Downey
Directed by: Noah Wyle

1-13 The Hurricane Job--10/18/2021
Stuck together during a massive hurricane, Eliot and Parker must stop a band of corrupt cops who have taken over a small hotel, and find what the cops are searching for, before it's too late.
Written by: Josh Schaer
Directed by: Marc Roskin

1-14 The Great Train Job--10/18/2021
Two local farmers are targeted by a hate group, but something more poisonous on the farm leads Team Leverage to a crooked green energy innovator and an old-fashioned Train Heist.
Written by: Christine Boylan
Directed by: Beth Riesgraf

1-15 The Muddy Waters Job--10/08/2021
The Leverage team infiltrates an oil rig and a small-town trial to find evidence that a corrupt oil CEO is hiding a dangerous oil leak in the gulf, causing illnesses along the spill zone.
Written by: John Timothy
Directed by: Marc Roskin

1-16 The Harry Wilson Job--10/08/2021
The team has to infiltrate the shadowy R.I.Z. to stop it from unleashing a worm that can take down the entire electrical grid, and they must use Harry to do it.
Written by: John Rogers & Kate Rorick
Directed by: Dean Devlin


Season Two Episode Guide (Freevee)
2-01 The Debutante Job--11/16/2022
The team pulls Harry back into the fold to help a journalist investigating the corrupt president of a small eastern European nation. But when the journalist is grabbed, our team has to infiltrate a London Ball to extract him.
Written by: John Rogers & Kate Rorick
Directed by: Dean Devlin

2-02 The One Man's Trash Job--11/16/2022
The crew finds out that a shady plastics exporter whose dumping threatens local waters is smuggling black market antiquities on his barges, and plots to relieve him of his ill-gotten gains.
Written by: Josh Schaer
Directed by: Marc Roskin

2-03 The Tournament Job--11/16/2022
The team has to infiltrate an e-sports tournament to stop a ruthless team owner from mentally and physically abusing his young players.
Written by: Mel Cowan & Chuck Maa
Directed by: Beth Riesgraf

2-04 The Date Night Job--11/23/2022
While staging a date-night experience for Parker & Hardison at an ultra-secure freeport facility, the team comes across another heist in progress and must stop it to save the life of a 13-year-old boy.

2-05 The Walk In The Woods Job--11/30/2022
While investigating the mysterious death of Eliot's friend, the Leverage team infiltrate an infamous enclave of power to take down the corrupt head of a Private Security Company.
Written by: Noah Wyle
Directed by: Noah Wyle

2-06 The Fractured Job--12/07/2022
Eliot returns to his hometown and discovers that the run-off from an oil fracking company is now poisoning the water and the crew plots to take down the powerful man behind it all.
Written by: Dean Devlin & Alayna Heim
Directed by: Dean Devlin

2-07 The Big Rig Job--12/14/2022
The team infiltrates a trucking company to stop a pair of siblings from stealing their father's company and forcing his employees into indentured servitude.
Written by: Danielle Nicki
Directed by: Milena Govich

2-08 The Turkish Prisoner Job--12/21/2022
The team uses the true story of a World War I P.O.W. escape to free an innocent man framed by a pair of dirty cops.
Written by: Chris Downey
Directed by: Beth Riesgraf

2-09 The Pyramid Job--12/28/2022
Prompted by and old friend of Sophie's, the team takes on a husband-wife couple who run a multi-level marketing pyramid scheme that preys on young mothers, emotionally and financially.
Written by: Mel Cowan & Chuck Maa
Directed by: Noah Wyle

2-10 The Work Study Job--01/04/2023
After a college professor steals a discovery from his grad student, the Leverage team has to take him down, returning the credit and reputation to the brilliant young woman in the process.
Written by: Teagan Wall
Directed by: Marshall Tyler

2-11 The Belly Of The Beast Job--01/11/2023
The team reluctantly enlists the help of a naïve but ambitious assistant to take down a predatory music producer, in an episode told entirely from the POV of a regular person.
Written by: Jill Weinberger
Directed by: Milena Govich

2-12 The Museum Makeover Job--01/18/2023
When a Leverage International team's museum heist goes awry, our crew goes in to finish the job, ultimately realizing they've been lured into a trap by a treacherous old friend.
Written by: Josh Schaer
Directed by: Marc Roskin

2-13 The Crowning Acheivement Job--01/25/2023
When a formidable enemy steals the Maharaja's Crown and traps the crew in the museum, the Leverage team must find a way out and the crown before they go down for the crime.
Written by: Kate Rorick
Directed by: Marc Roskin


Season Three Episode Guide (Prime Video)
3-01 The Weekend In Paris Job--04/17/2025

3-02

3-03

3-04 The Hustler Job--04/17/2025
The crew takes on a phone scamming ring using deepfake technology to con their marks, run by an old school hustler who came up via the pool hall circuit. To infiltrate his organization, they have to best him on and off the felt.

3-05 The Grand Complication Job--04/17/2025
Triggered by text messages that Sophie’s been abducted, rivals Parker and Astrid are forced into a desperate race against time to steal/protect the elusive “Grand Complication” Marie Antoinette watch. Unaware of each other’s involvement, they embark on a quest to save Sophie, but as pressure mounts, they’re forced to collaborate, just as a mysterious third person enters the fold who may or may not be thwarting the mission.

3-06 The Swipe Right Job--04/17/2025
Sophie’s return to dating goes awry when she discovers her newest flame is a phony billionaire, swindling men and women on dating apps to fund his lavish lifestyle. To dismantle his million dollar scheme, the team must create the perfect romantic specimen and bait the ultimate catfish.

3-07 The Shakedown In Clone-Town Job--04/17/2025
Sophie, Eliot, and Parker get caught in a small-town speed trap run by a corrupt mayor who is also the local judge, endeavoring to help the oppressed townspeople wrest power from his hungry clutches.

3-08 The Cooling Off The Mark Job--04/17/2025
Old friend Hurley arrives for a meeting and stumbles into the path of a Mark out for vengeance on the crew. He must take point on one of the most delicate parts of the con, one we rarely see — the Cool Off. Despite the crew’s help, the situation spins out of control into a brand new con, with a brand new victim.

3-09 The Polygeist Job--04/17/2025
The crew pull a “Cabin in the Woods” con to take down a corrupt tech guru claiming to better the world using “effective altruism.” They use horror to kindle paranoia and betrayal within his company’s close-knit group of executives to get them to flip on him, but things get complicated when the group turns out to be much closer than they anticipated.

3-10 The Side Job--04/17/2025
In a story told from two POV’s - the mark’s told from inside the neo-noir story Parker’s constructed, and the true story of the con around the con - Parker decides to take down a local factory kingpin using child labor. While the villain spins his own version of how he was wrongfully destroyed, the team tries to unravel a con Parker’s running as a solo side job… or is she? The team must play catch up as they find themselves drafted into her machinations.

9.062MBMemory Usage168msRequest 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" => 1746144156 "last" => 1746144156...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (8.37ms)
  • afterInitialise (1.26MB) (31.09ms)
  • afterRoute (281.69KB) (9.61ms)
  • beforeRenderComponent com_content (38.63KB) (1.35ms)
  • Before Access::preloadComponents (all components) (34.7KB) (960μs)
  • After Access::preloadComponents (all components) (109.3KB) (1.09ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (19μs)
  • After Access::preloadPermissions (com_content) (2.92MB) (12.3ms)
  • Before Access::getAssetRules (id:4481 name:com_content.article.3647) (258.8KB) (180μs)
  • After Access::getAssetRules (id:4481 name:com_content.article.3647) (8.47KB) (206μs)
  • beforeRenderRawModule mod_related_items (Read More) (878.4KB) (36.48ms)
  • afterRenderRawModule mod_related_items (Read More) (12.58KB) (1.91ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (10μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (259μs)
  • afterRenderComponent com_content (33.04KB) (78μs)
  • afterDispatch (2.28KB) (296μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (27.83ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (736μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (7μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (272μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (50μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (133μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (91μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (69μs)
  • afterRenderRawModule mod_finder (Head Search) (75.91KB) (16.04ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (11μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (281μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (85μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (457μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (5μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (87μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (41μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (84μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (3μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (100μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (21μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (135μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (4μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (94μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (21μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (142μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (3μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (88μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.51ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.99ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (8μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (122μs)
  • afterRender (689.13KB) (11.33ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (878.4KB) (21.7%)
    36.48ms
    1 x afterInitialise (1.26MB) (18.49%)
    31.09ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (16.56%)
    27.83ms
    1 x afterRenderRawModule mod_finder (Head Search) (75.91KB) (9.54%)
    16.04ms
    1 x After Access::preloadPermissions (com_content) (2.92MB) (7.32%)
    12.30ms
    1 x afterRender (689.13KB) (6.74%)
    11.33ms
    1 x afterRoute (281.69KB) (5.72%)
    9.61ms
    1 x afterLoad (528.29KB) (4.98%)
    8.37ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (1.78%)
    2.99ms
    1 x afterRenderRawModule mod_related_items (Read More) (12.58KB) (1.14%)
    1.91ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.9%)
    1.51ms
    1 x beforeRenderComponent com_content (38.63KB) (0.8%)
    1.35ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.65%)
    1.09ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.57%)
    960μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.44%)
    736μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.27%)
    457μs
    1 x afterDispatch (2.28KB) (0.18%)
    296μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.17%)
    281μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.16%)
    272μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.15%)
    259μs
    1 x After Access::getAssetRules (id:4481 name:com_content.article.3647) (8.47KB) (0.12%)
    206μs
    1 x Before Access::getAssetRules (id:4481 name:com_content.article.3647) (258.8KB) (0.11%)
    180μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.08%)
    142μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.08%)
    135μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    133μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.07%)
    122μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.06%)
    100μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    94μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.05%)
    91μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.05%)
    88μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.05%)
    87μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.05%)
    85μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.05%)
    84μs
    1 x afterRenderComponent com_content (33.04KB) (0.05%)
    78μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    69μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    50μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.02%)
    41μ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_finder (Head Search) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    3μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    3μs
45 statements were executed, 3 of which were duplicates, 42 unique53.58ms409.91KB
  • SELECT @@SESSION.sql_mode;92μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?136μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 186μ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)423μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1386μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`120μ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` = :guest204μ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`749μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'571μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC192μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='3647-show-guide-leverage-redemption' AND published=1210μ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`577μ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`725μ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` = 1248μ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)689μ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.54ms229.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.01ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '3647'963μ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)686μ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`740μ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.24ms5.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`673μ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 ASC475μ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.17ms2.53KBParams/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`683μ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.id159μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'169μ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 ordering152μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.42ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid177μ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` = :muserid212μ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 ASC400μ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=5163μs856B/plugins/system/t4/src/t4/MVC/Router/T4.php:288Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tvlfg_modules` AS `m` LEFT JOIN `tvlfg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tvlfg_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.07ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id151μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1415μ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)306μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration274μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'136μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field119μ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` = 1165μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?207μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?26.2ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy