Courses for Personal Effectiveness

Preparing for Interview

Overview

A practical one day or half day workshop which will assist attendees in preparing for interviews.

What does it cover?

The course can be designed around a specific organisation's recruitment and selection process or cover techniques which would apply to a range of organisations. Depending on the length of course selected it will cover the following areas:

Assessment of your current situation
Consultation to identify what is important to you at work
A checklist to identify your current work skills and any skills gaps
Confidence boosters

Job search
Where to find the jobs you are interested in

CVs and application forms
How to write a professional CV
How to fill in an application form effectively

Preparation for Interview
Preparing for the interview
Creating a positive first impression
Predictable areas of questioning
Additional forms of assessment
Competency based questions
Using the STAR technique

Interview practice
Preparation of answers to positive and contrary questions
Dealing with poor interviewers and bad questions
Practice answering questions 
Questions you should ask

What will I learn?

By the end of the workshop, you will:

  • Have assessed what is important to you at work 
  • Have identified your current skills 
  • Have explored ways of filling any skills gaps and boosting your confidence 
  • Know how to prepare a professional CV and/or complete an application form effectively 
  • Have identified what you need to do to prepare for an interview 
  • Know how to answer a range of interview questions 
  • Have explored other methods of assessment used by organisations 
  • Have prepared answers to likely interview questions 
  • Have practised answering questions by being 'interviewed' by another attendee 
  • Have identified questions you could ask in interview

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

Contact Us

5MBMemory Usage160msRequest 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" => 1747472627 "last" => 1747472627...
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.79KB) (10.9ms)
  • afterInitialise (882.2KB) (35ms)
  • afterRoute (380.72KB) (9.81ms)
  • beforeRenderComponent com_content (99.57KB) (7ms)
  • Before Access::preloadComponents (all components) (105.68KB) (3.89ms)
  • After Access::preloadComponents (all components) (115.83KB) (1.23ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (31μs)
  • After Access::preloadPermissions (com_content) (58.01KB) (631μs)
  • Before Access::getAssetRules (id:156 name:com_content.article.144) (6.8KB) (29μs)
  • After Access::getAssetRules (id:156 name:com_content.article.144) (8.47KB) (260μs)
  • Before Access::getAssetRules (id:8 name:com_content) (614.3KB) (38.46ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (22μs)
  • afterRenderComponent com_content (62.05KB) (4.43ms)
  • afterDispatch (2.28KB) (227μs)
  • beforeRenderRawModule mod_custom (Social Options) (427.6KB) (3.6ms)
  • afterRenderRawModule mod_custom (Social Options) (4.12KB) (1.26ms)
  • beforeRenderModule mod_custom (Social Options) (720B) (11μs)
  • afterRenderModule mod_custom (Social Options) (4.36KB) (268μs)
  • beforeRenderRawModule mod_custom (Footer) (360B) (43μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (249μs)
  • beforeRenderModule mod_custom (Footer) (704B) (4μs)
  • afterRenderModule mod_custom (Footer) (3.16KB) (104μs)
  • beforeRenderRawModule mod_custom (Contact CTA) (328B) (30μs)
  • afterRenderRawModule mod_custom (Contact CTA) (960B) (263μs)
  • beforeRenderModule mod_custom (Contact CTA) (720B) (4μs)
  • afterRenderModule mod_custom (Contact CTA) (2.52KB) (103μs)
  • beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (62μs)
  • afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.35KB) (18.67ms)
  • beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (23μs)
  • afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (231μs)
  • beforeRenderRawModule mod_menu (All Page) (6.59KB) (48μs)
  • afterRenderRawModule mod_menu (All Page) (4.28KB) (847μs)
  • beforeRenderModule mod_menu (All Page) (704B) (8μs)
  • afterRenderModule mod_menu (All Page) (4.15KB) (104μs)
  • beforeRenderRawModule mod_search (Search our courses) (1.2KB) (77μs)
  • afterRenderRawModule mod_search (Search our courses) (13.62KB) (1.27ms)
  • beforeRenderModule mod_search (Search our courses) (720B) (7μs)
  • afterRenderModule mod_search (Search our courses) (3.05KB) (123μs)
  • afterRender (249.27KB) (9.37ms)
  • 1 x Before Access::getAssetRules (id:8 name:com_content) (614.3KB) (24.11%)
    38.46ms
    1 x afterInitialise (882.2KB) (21.94%)
    35.00ms
    1 x afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.35KB) (11.7%)
    18.67ms
    1 x afterLoad (539.79KB) (6.83%)
    10.90ms
    1 x afterRoute (380.72KB) (6.15%)
    9.81ms
    1 x afterRender (249.27KB) (5.87%)
    9.37ms
    1 x beforeRenderComponent com_content (99.57KB) (4.39%)
    7.00ms
    1 x afterRenderComponent com_content (62.05KB) (2.78%)
    4.43ms
    1 x Before Access::preloadComponents (all components) (105.68KB) (2.44%)
    3.89ms
    1 x beforeRenderRawModule mod_custom (Social Options) (427.6KB) (2.26%)
    3.60ms
    1 x afterRenderRawModule mod_search (Search our courses) (13.62KB) (0.8%)
    1.27ms
    1 x afterRenderRawModule mod_custom (Social Options) (4.12KB) (0.79%)
    1.26ms
    1 x After Access::preloadComponents (all components) (115.83KB) (0.77%)
    1.23ms
    1 x afterRenderRawModule mod_menu (All Page) (4.28KB) (0.53%)
    847μs
    1 x After Access::preloadPermissions (com_content) (58.01KB) (0.4%)
    631μs
    1 x afterRenderModule mod_custom (Social Options) (4.36KB) (0.17%)
    268μs
    1 x afterRenderRawModule mod_custom (Contact CTA) (960B) (0.17%)
    263μs
    1 x After Access::getAssetRules (id:156 name:com_content.article.144) (8.47KB) (0.16%)
    260μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.16%)
    249μs
    1 x afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (0.14%)
    231μs
    1 x afterDispatch (2.28KB) (0.14%)
    227μs
    1 x afterRenderModule mod_search (Search our courses) (3.05KB) (0.08%)
    123μs
    1 x afterRenderModule mod_custom (Footer) (3.16KB) (0.07%)
    104μs
    1 x afterRenderModule mod_menu (All Page) (4.15KB) (0.07%)
    104μs
    1 x afterRenderModule mod_custom (Contact CTA) (2.52KB) (0.06%)
    103μs
    1 x beforeRenderRawModule mod_search (Search our courses) (1.2KB) (0.05%)
    77μs
    1 x beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (0.04%)
    62μs
    1 x beforeRenderRawModule mod_menu (All Page) (6.59KB) (0.03%)
    48μs
    1 x beforeRenderRawModule mod_custom (Footer) (360B) (0.03%)
    43μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.02%)
    31μs
    1 x beforeRenderRawModule mod_custom (Contact CTA) (328B) (0.02%)
    30μs
    1 x Before Access::getAssetRules (id:156 name:com_content.article.144) (6.8KB) (0.02%)
    29μs
    1 x beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (0.01%)
    23μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    22μs
    1 x beforeRenderModule mod_custom (Social Options) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_menu (All Page) (704B) (0.01%)
    8μs
    1 x beforeRenderModule mod_search (Search our courses) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Contact CTA) (720B) (0%)
    4μs
40 statements were executed, 2 of which were duplicates, 38 unique17.41ms281.63KB
  • SELECT @@SESSION.sql_mode;164μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ldoa_session` WHERE `session_id` = ?207μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ldoa_session` WHERE `session_id` = :session_id LIMIT 1142μ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` = 1445μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ldoa_viewlevels`128μ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` = :guest187μ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`839μ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.62ms136.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `ldoa_languages` WHERE `published` = 1 ORDER BY `ordering` ASC353μ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` = 1408μ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)534μ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` = 0297μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ldoa_content`609μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ldoa_content` SET `hits` = (`hits` + 1) WHERE `id` = '144'190μ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)689μs8.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`467μs7.67KBParams/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)246μ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`428μs5.17KBParams/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)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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.32ms6.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` = :itemid201μs1.86KBParams/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 DESC1.2ms2.11KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • select catid from ldoa_content where id=144122μs856B/templates/echo/html/com_content/article/default.php:13Copy
  • select title from ldoa_categories where id=3097μs856B/templates/echo/html/com_content/article/default.php:15Copy
  • SHOW FULL COLUMNS FROM `ldoa_categories`510μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '30'201μ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)251μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '10'206μ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)155μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • 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 20850μs24.86KBParams/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,:preparedArray3,:preparedArray4,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7)274μs5.34KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id92μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id75μs12.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id76μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id81μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id69μ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`505μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM ldoa_extensions WHERE element='mod_djmegamenu' LIMIT 1247μ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` asc428μ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` asc350μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy