Courses for Leadership Skills

Preparing for Grade 7 in Government

Overview

This course is for experienced members of the Analytical Service (GES, GSR, GSS, GORS and GO Science), who are, or will soon be, responsible for managing staff and starting to have a representation role for in the Analytical Service.  The aim of this course is to equip participants with many of the key skills needed to perform effectively at this level in the government analytical service.  It is a highly engaging programme, comprising of 2x2 day modules, each focusing on a different aspect of the skills required to attain high performance at this level.  Each participant will receive personalised feedback on his or her impact and approach and coaching.

Key Features 

  • 121 Coaching and feedback on personal approach
  • Practice sessions tailored to your profession and the wider analytical environment
  • Practice of critical interactions you find yourself in at this level with feedback and support
  • Networking with colleagues

Module 1: Essential Skills for Stepping into Management

This 2-day module has a focus on the challenges of managing junior Analysts within the wider analytical environment.  Being able to harness potential from your team to maximise performance both as individual contributors and as a team with a common purpose.  The module explores key challenges in motivation and performance management, how to set Analysts up for considerations around engagement and motivation.  The programme is delivered in a highly interactive environment using case studies, discussion, facilitator input and practice with ‘real life’ scenarios.  Each participant receives personal 121 coaching and feedback on their approach and leaves with an action plan specific to their team to implement and see results first hand. 

  • What it means to have a High Performance mindset within the Analytical Service
  • Conducting effective 121s with Analysts that lead to engagement and performance
  • How to navigate difficult performance conversations with Analysts
  • Understanding and harnessing staff motivation
  • Bespoke practice session

Learning Objectives

  1. Understand the unique challenges and dynamics involved in managing junior analysts within an analytical environment.
  2. Develop strategies to maximise the potential of junior analysts as individual contributors and as a cohesive team with a shared purpose.
  3. Gain knowledge and techniques for effectively motivating and managing the performance of junior analysts.
  4. Learn how to set up junior analysts for success by considering their engagement and motivation factors.
  5. Acquire skills for fostering an interactive and engaging learning environment through the use of case studies, discussions, and facilitator input.
  6. Practice and receive personalised coaching and feedback on individual approaches to managing junior analysts, and develop an actionable plan to implement with their own teams.

 

 Module 2: Presence, Impact, and Negotiation Skills

The focus of module 2 encourages the delegates to extend their focus beyond their teams to the skills needed to maximise their effectiveness in the wider analytical community.  Over 2 days the programme explores negotiating with contractors, getting a voice in the room when meeting Ministers and senior government officials and presenting at events.  It is highly interactive with chances to practice new skills and techniques in a variety of settings and learn from both the course facilitators and each other.  The programme concludes with a chance to design their own tailored role-play and receive feedback on a live interaction that they need to have with a key stakeholder.  

  • Identifying stakeholders within the internal and external environment
  • How to negotiate effectively with Contractors and external stakeholders to achieve win:win outcomes
  • Working with senior stakeholders whist communicating with impact and presence
  • How to engage an audience in meetings, presentations and conferences
  • Bespoke practice session

Learning Objectives

  1. Develop a comprehensive understanding of negotiation strategies and techniques when working with contractors in the analytical community.
  2. Acquire the skills and confidence to effectively present and network at events and conferences, maximising visibility and influence within the analytical community.
  3. Learn strategies for gaining a voice in high-level meetings with Ministers and senior government officials, ensuring active participation and contribution.
  4. Explore effective communication and influencing techniques to effectively engage with key stakeholders in the analytical community.
  5. Practice and refine skills through interactive sessions and role-plays, applying newly learned techniques in realistic scenarios.
  6. Receive personalised feedback and guidance on designing and conducting a tailored role-play for a live interaction with a key stakeholder, enabling practical application and skill development.

How our virtual classrooms work

Our Virtual Classroom courses allows you to attend our classroom training without leaving your home or office. We use the ‘Microsoft Teams’ meeting software. Before you attend, please check that you meet the system requirements. If it doesn’t work, try adjusting your settings or contact your IT department to ask about permitting the website.

You are also welcome to use your personal laptop, tablet or even your smart phone. Please just forward our course invite to your personal email, or just copy and paste the link into your browser.

If you encounter any problems, please feel free to get in touch. We can set up a test meeting before the course.

For more information, to book or to register your interest in future course dates

Contact Us

5MBMemory Usage165msRequest Duration
Joomla! Version4.3.1
PHP Version8.1.32
Identityguest
Response200
Templateecho
Database
Server
mysql
Version
10.4.34-MariaDB
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:59 [ "USER" => "lsr-training" "HOME" => "/var/www/vhosts/lsr-training.co.uk" "SCRIPT_NAM...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748773806 "last" => 1748773806...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (539.71KB) (10.93ms)
  • afterInitialise (882.14KB) (34.43ms)
  • afterRoute (380.72KB) (10.52ms)
  • beforeRenderComponent com_content (99.57KB) (6.63ms)
  • Before Access::preloadComponents (all components) (105.63KB) (4.13ms)
  • After Access::preloadComponents (all components) (115.83KB) (1.09ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (31μs)
  • After Access::preloadPermissions (com_content) (58.01KB) (684μs)
  • Before Access::getAssetRules (id:142 name:com_content.article.136) (6.8KB) (30μs)
  • After Access::getAssetRules (id:142 name:com_content.article.136) (8.47KB) (271μs)
  • Before Access::getAssetRules (id:8 name:com_content) (640.48KB) (42.06ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (23μs)
  • afterRenderComponent com_content (33.29KB) (4.16ms)
  • afterDispatch (2.28KB) (252μs)
  • beforeRenderRawModule mod_custom (Social Options) (427.44KB) (4.17ms)
  • afterRenderRawModule mod_custom (Social Options) (4.12KB) (1.3ms)
  • beforeRenderModule mod_custom (Social Options) (720B) (12μs)
  • afterRenderModule mod_custom (Social Options) (4.36KB) (285μs)
  • beforeRenderRawModule mod_custom (Footer) (360B) (50μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (254μs)
  • beforeRenderModule mod_custom (Footer) (704B) (4μs)
  • afterRenderModule mod_custom (Footer) (3.16KB) (104μs)
  • beforeRenderRawModule mod_custom (Contact CTA) (328B) (31μs)
  • afterRenderRawModule mod_custom (Contact CTA) (960B) (248μs)
  • beforeRenderModule mod_custom (Contact CTA) (720B) (4μs)
  • afterRenderModule mod_custom (Contact CTA) (2.52KB) (110μs)
  • beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (66μs)
  • afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.04KB) (19.45ms)
  • beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (25μs)
  • afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (238μs)
  • beforeRenderRawModule mod_menu (All Page) (6.59KB) (51μs)
  • afterRenderRawModule mod_menu (All Page) (4.28KB) (871μs)
  • beforeRenderModule mod_menu (All Page) (704B) (8μs)
  • afterRenderModule mod_menu (All Page) (4.15KB) (123μs)
  • beforeRenderRawModule mod_search (Search our courses) (1.2KB) (75μs)
  • afterRenderRawModule mod_search (Search our courses) (13.95KB) (1.31ms)
  • beforeRenderModule mod_search (Search our courses) (720B) (6μs)
  • afterRenderModule mod_search (Search our courses) (3.05KB) (123μs)
  • afterRender (256.65KB) (9.83ms)
  • 1 x Before Access::getAssetRules (id:8 name:com_content) (640.48KB) (25.52%)
    42.06ms
    1 x afterInitialise (882.14KB) (20.88%)
    34.43ms
    1 x afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.04KB) (11.8%)
    19.45ms
    1 x afterLoad (539.71KB) (6.63%)
    10.93ms
    1 x afterRoute (380.72KB) (6.38%)
    10.52ms
    1 x afterRender (256.65KB) (5.96%)
    9.83ms
    1 x beforeRenderComponent com_content (99.57KB) (4.02%)
    6.63ms
    1 x beforeRenderRawModule mod_custom (Social Options) (427.44KB) (2.53%)
    4.17ms
    1 x afterRenderComponent com_content (33.29KB) (2.53%)
    4.16ms
    1 x Before Access::preloadComponents (all components) (105.63KB) (2.5%)
    4.13ms
    1 x afterRenderRawModule mod_search (Search our courses) (13.95KB) (0.8%)
    1.31ms
    1 x afterRenderRawModule mod_custom (Social Options) (4.12KB) (0.79%)
    1.30ms
    1 x After Access::preloadComponents (all components) (115.83KB) (0.66%)
    1.09ms
    1 x afterRenderRawModule mod_menu (All Page) (4.28KB) (0.53%)
    871μs
    1 x After Access::preloadPermissions (com_content) (58.01KB) (0.41%)
    684μs
    1 x afterRenderModule mod_custom (Social Options) (4.36KB) (0.17%)
    285μs
    1 x After Access::getAssetRules (id:142 name:com_content.article.136) (8.47KB) (0.16%)
    271μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.15%)
    254μs
    1 x afterDispatch (2.28KB) (0.15%)
    252μs
    1 x afterRenderRawModule mod_custom (Contact CTA) (960B) (0.15%)
    248μs
    1 x afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (0.14%)
    238μs
    1 x afterRenderModule mod_menu (All Page) (4.15KB) (0.07%)
    123μs
    1 x afterRenderModule mod_search (Search our courses) (3.05KB) (0.07%)
    123μs
    1 x afterRenderModule mod_custom (Contact CTA) (2.52KB) (0.07%)
    110μs
    1 x afterRenderModule mod_custom (Footer) (3.16KB) (0.06%)
    104μs
    1 x beforeRenderRawModule mod_search (Search our courses) (1.2KB) (0.05%)
    75μs
    1 x beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (0.04%)
    66μs
    1 x beforeRenderRawModule mod_menu (All Page) (6.59KB) (0.03%)
    51μs
    1 x beforeRenderRawModule mod_custom (Footer) (360B) (0.03%)
    50μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.02%)
    31μs
    1 x beforeRenderRawModule mod_custom (Contact CTA) (328B) (0.02%)
    31μs
    1 x Before Access::getAssetRules (id:142 name:com_content.article.136) (6.8KB) (0.02%)
    30μs
    1 x beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (0.02%)
    25μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    23μs
    1 x beforeRenderModule mod_custom (Social Options) (720B) (0.01%)
    12μs
    1 x beforeRenderModule mod_menu (All Page) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_search (Search our courses) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Contact CTA) (720B) (0%)
    4μs
38 statements were executed, 2 of which were duplicates, 36 unique18.68ms293.5KB
  • SELECT @@SESSION.sql_mode;177μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ldoa_session` WHERE `session_id` = ?172μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ldoa_session` WHERE `session_id` = :session_id LIMIT 179μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ldoa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.14ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ldoa_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1450μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ldoa_viewlevels`181μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ldoa_usergroups` AS `a` LEFT JOIN `ldoa_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest176μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ldoa_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`846μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • 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 `ldoa_menu` AS `m` LEFT JOIN `ldoa_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`2.41ms136.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `ldoa_languages` WHERE `published` = 1 ORDER BY `ordering` ASC288μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ldoa_template_styles` AS `s` LEFT JOIN `ldoa_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` = 1372μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ldoa_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,:preparedArray40)491μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ldoa_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0317μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ldoa_content`508μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ldoa_content` SET `hits` = (`hits` + 1) WHERE `id` = '136'228μ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 `ldoa_content` AS `a` INNER JOIN `ldoa_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ldoa_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ldoa_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ldoa_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ldoa_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 `ldoa_categories` AS `s` INNER JOIN `ldoa_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`476μs7.69KBParams/libraries/src/Categories/Categories.php:363Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ldoa_contentitem_tag_map` AS `m` INNER JOIN `ldoa_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)298μs5.22KBParams/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 `ldoa_categories` AS `s` INNER JOIN `ldoa_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`496μs5.19KBParams/libraries/src/Categories/Categories.php:363Copy
  • 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 ldoa_fields AS a LEFT JOIN `ldoa_languages` AS l ON l.lang_code = a.language LEFT JOIN ldoa_users AS uc ON uc.id=a.checked_out LEFT JOIN ldoa_viewlevels AS ag ON ag.id = a.access LEFT JOIN ldoa_users AS ua ON ua.id = a.created_user_id LEFT JOIN ldoa_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ldoa_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 ASC1.34ms6.19KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `ldoa_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7) AND `item_id` = :itemid262μs1.89KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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 `ldoa_content` AS `a` LEFT JOIN `ldoa_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 DESC829μs2.06KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • select catid from ldoa_content where id=136271μs856B/templates/echo/html/com_content/article/default.php:13Copy
  • select title from ldoa_categories where id=35206μs856B/templates/echo/html/com_content/article/default.php:15Copy
  • SHOW FULL COLUMNS FROM `ldoa_categories`772μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '35'320μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ldoa_tags` AS `t` INNER JOIN `ldoa_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)324μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '31'242μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ldoa_tags` AS `t` INNER JOIN `ldoa_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)209μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • select content from ldoa_modules where id=101161μs856B/templates/echo/html/com_content/article/default.php:242Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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` FROM `ldoa_content` AS `a` LEFT JOIN `ldoa_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ldoa_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `ldoa_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `ldoa_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ldoa_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC LIMIT 201.06ms24.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `ldoa_contentitem_tag_map` AS `m` INNER JOIN `ldoa_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2) AND `t`.`access` IN (:preparedArray3,:preparedArray4)414μs5.28KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id159μs12.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id170μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ldoa_modules` AS `m` LEFT JOIN `ldoa_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ldoa_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`800μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM ldoa_extensions WHERE element='mod_djmegamenu' LIMIT 1405μs856B/modules/mod_djmegamenu/helpers/helper.php:404Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `ldoa_scheduler_tasks` AS `a` LEFT JOIN `ldoa_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc551μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `ldoa_scheduler_tasks` AS `a` LEFT JOIN `ldoa_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc547μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy