Book Now | LSR Training



Please read the conditions of booking below.

Attendee Details

Course Details

Payment authorisation

Name and address for invoice (if different to above)

Your customer reference or purchase order number

If your organisation requires a customer reference or purchase order number, please include it here

N.B. We do not need a PO at this stage to confirm a booking. You may also pay by card. We issue an invoice following the event

Independent equal access

Where did you hear about this course?

Conditions of Booking

  • We will not accept any booking unless they have been authorised
  • We can issue invoices for advanced payment if you ask us to. Cheques and purchase orders should be made payable to LSR Training and Development Ltd. and we will send you an invoice acknowledging payment within one week.
  • Independent equal access
    If you indicate on the booking form that you have any requirements or any other reason, we will contact you before the programme starts to discuss your personal requirements.
  • When we have accepted the booking on this form, you are liable for the relevant programme fee or cancellation charge for payment.
  • We reserve the right to run programmes at different venues from the one specified, when necessary. If this is the case we will inform you as soon as possible as provide you with information about travel directions.
  • Privacy and data protection We do not give your personal information to others. We will add your details to our database to process your booking and so that we can keep you up to date with other courses that may be of interest. If you do not wish to receive this information, please let us know.
  • Where circumstances force us to cancel a programme, our liability will be will be limited to refunding any fees paid for that programme. We are not liable for any other loss occurred by you.
  • Please follow your internal procedures when applying for programmes.

Unless otherwise stated, these fees are:

Notice of cancellation or transfer Percentage programme price charged
29 days or more 10%
15 to 28 days 50%
4 to 14 days 90%
3 days or less 100%

(we include weekends in the above calculations)

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

Contact Us

J! InfoRequestSessionProfileQueries55
5MBMemory Usage183msRequest 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
array:1 [ "artid" => "141" ]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:60 [ "USER" => "lsr-training" "HOME" => "/var/www/vhosts/lsr-training.co.uk" "SCRIPT_NAM...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743486039 "last" => 1743486039...
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.87KB) (9.7ms)
  • afterInitialise (883.17KB) (34.36ms)
  • afterRoute (380.72KB) (10.59ms)
  • beforeRenderComponent com_content (99.62KB) (7.31ms)
  • Before Access::preloadComponents (all components) (105.68KB) (3.93ms)
  • After Access::preloadComponents (all components) (115.83KB) (1.36ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (44μs)
  • After Access::preloadPermissions (com_content) (58.01KB) (870μs)
  • Before Access::getAssetRules (id:117 name:com_content.article.131) (6.8KB) (30μs)
  • After Access::getAssetRules (id:117 name:com_content.article.131) (8.47KB) (274μs)
  • Before Access::getAssetRules (id:8 name:com_content) (519.83KB) (35.9ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (26μs)
  • afterRenderComponent com_content (325.3KB) (30.87ms)
  • afterDispatch (2.28KB) (297μs)
  • beforeRenderRawModule mod_custom (Social Options) (448.17KB) (4ms)
  • afterRenderRawModule mod_custom (Social Options) (4.12KB) (1.33ms)
  • beforeRenderModule mod_custom (Social Options) (720B) (9μs)
  • afterRenderModule mod_custom (Social Options) (4.36KB) (298μs)
  • beforeRenderRawModule mod_custom (Footer) (360B) (54μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (261μs)
  • beforeRenderModule mod_custom (Footer) (704B) (4μs)
  • afterRenderModule mod_custom (Footer) (3.16KB) (125μs)
  • beforeRenderRawModule mod_custom (Contact CTA) (328B) (34μs)
  • afterRenderRawModule mod_custom (Contact CTA) (960B) (239μs)
  • beforeRenderModule mod_custom (Contact CTA) (720B) (3μs)
  • afterRenderModule mod_custom (Contact CTA) (2.52KB) (108μs)
  • beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (63μs)
  • afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (608.41KB) (18.69ms)
  • beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (25μs)
  • afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (245μs)
  • beforeRenderRawModule mod_menu (All Page) (6.59KB) (52μs)
  • afterRenderRawModule mod_menu (All Page) (4.28KB) (881μs)
  • beforeRenderModule mod_menu (All Page) (704B) (24μs)
  • afterRenderModule mod_menu (All Page) (4.15KB) (105μs)
  • beforeRenderRawModule mod_search (Search our courses) (1.2KB) (78μs)
  • afterRenderRawModule mod_search (Search our courses) (13.89KB) (1.23ms)
  • beforeRenderModule mod_search (Search our courses) (720B) (8μs)
  • afterRenderModule mod_search (Search our courses) (3.05KB) (134μs)
  • afterRender (280.65KB) (9.36ms)
  • 1 x Before Access::getAssetRules (id:8 name:com_content) (519.83KB) (19.58%)
    35.90ms
    1 x afterInitialise (883.17KB) (18.74%)
    34.36ms
    1 x afterRenderComponent com_content (325.3KB) (16.84%)
    30.87ms
    1 x afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (608.41KB) (10.19%)
    18.69ms
    1 x afterRoute (380.72KB) (5.77%)
    10.59ms
    1 x afterLoad (539.87KB) (5.29%)
    9.70ms
    1 x afterRender (280.65KB) (5.11%)
    9.36ms
    1 x beforeRenderComponent com_content (99.62KB) (3.99%)
    7.31ms
    1 x beforeRenderRawModule mod_custom (Social Options) (448.17KB) (2.18%)
    4.00ms
    1 x Before Access::preloadComponents (all components) (105.68KB) (2.14%)
    3.93ms
    1 x After Access::preloadComponents (all components) (115.83KB) (0.74%)
    1.36ms
    1 x afterRenderRawModule mod_custom (Social Options) (4.12KB) (0.72%)
    1.33ms
    1 x afterRenderRawModule mod_search (Search our courses) (13.89KB) (0.67%)
    1.23ms
    1 x afterRenderRawModule mod_menu (All Page) (4.28KB) (0.48%)
    881μs
    1 x After Access::preloadPermissions (com_content) (58.01KB) (0.47%)
    870μs
    1 x afterRenderModule mod_custom (Social Options) (4.36KB) (0.16%)
    298μs
    1 x afterDispatch (2.28KB) (0.16%)
    297μs
    1 x After Access::getAssetRules (id:117 name:com_content.article.131) (8.47KB) (0.15%)
    274μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.14%)
    261μs
    1 x afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (0.13%)
    245μs
    1 x afterRenderRawModule mod_custom (Contact CTA) (960B) (0.13%)
    239μs
    1 x afterRenderModule mod_search (Search our courses) (3.05KB) (0.07%)
    134μs
    1 x afterRenderModule mod_custom (Footer) (3.16KB) (0.07%)
    125μs
    1 x afterRenderModule mod_custom (Contact CTA) (2.52KB) (0.06%)
    108μs
    1 x afterRenderModule mod_menu (All Page) (4.15KB) (0.06%)
    105μs
    1 x beforeRenderRawModule mod_search (Search our courses) (1.2KB) (0.04%)
    78μs
    1 x beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (0.03%)
    63μs
    1 x beforeRenderRawModule mod_custom (Footer) (360B) (0.03%)
    54μs
    1 x beforeRenderRawModule mod_menu (All Page) (6.59KB) (0.03%)
    52μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.02%)
    44μs
    1 x beforeRenderRawModule mod_custom (Contact CTA) (328B) (0.02%)
    34μs
    1 x Before Access::getAssetRules (id:117 name:com_content.article.131) (6.8KB) (0.02%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (0.01%)
    25μs
    1 x beforeRenderModule mod_menu (All Page) (704B) (0.01%)
    24μs
    1 x beforeRenderModule mod_custom (Social Options) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_search (Search our courses) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Contact CTA) (720B) (0%)
    3μs
55 statements were executed, 2 of which were duplicates, 53 unique29.61ms701.18KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;184μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ldoa_session` WHERE `session_id` = ?235μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ldoa_session` WHERE `session_id` = :session_id LIMIT 1151μ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.17ms944BParams/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` = 1441μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ldoa_viewlevels`134μ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` = :guest196μ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`871μ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.74ms136.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `ldoa_languages` WHERE `published` = 1 ORDER BY `ordering` ASC367μ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` = 1433μ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)565μ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` = 0404μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ldoa_content`614μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ldoa_content` SET `hits` = (`hits` + 1) WHERE `id` = '131'210μ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)599μ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`517μs7.66KBParams/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)327μ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`539μs5.16KBParams/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)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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.42ms6.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `ldoa_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2) AND `item_id` = :itemid277μs1.73KBParams/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.75ms2.41KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • select * from ldoa_categories where parent_id=10339μs4.3KB/templates/echo/html/com_content/article/default-20200723-134318.php:97Copy
  • select * from ldoa_categories where parent_id=24177μs4.3KB/templates/echo/html/com_content/article/default-20200723-134318.php:105Copy
  • 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 20588μs8.78KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 20803μs40.83KBParams/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) AND `t`.`access` IN (:preparedArray4,:preparedArray5)373μs5.31KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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 20925μs56.94KBParams/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,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) AND `t`.`access` IN (:preparedArray10,:preparedArray11)300μs6.09KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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 20589μs24.83KBParams/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) AND `t`.`access` IN (:preparedArray4,:preparedArray5)264μs5.31KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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 20738μs40.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)249μs16.34KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • select * from ldoa_categories where parent_id=29187μs4.23KB/templates/echo/html/com_content/article/default-20200723-134318.php:105Copy
  • 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 20786μs56.91KBParams/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,:preparedArray6,:preparedArray7,:preparedArray8) AND `t`.`access` IN (:preparedArray9,:preparedArray10)332μs6.09KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • select * from ldoa_categories where parent_id=30188μs4.23KB/templates/echo/html/com_content/article/default-20200723-134318.php:105Copy
  • 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 20762μ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)351μs5.34KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • select * from ldoa_categories where parent_id=31242μs4.3KB/templates/echo/html/com_content/article/default-20200723-134318.php:105Copy
  • 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 20501μs8.78KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 20845μs40.91KBParams/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,:preparedArray6,:preparedArray7) AND `t`.`access` IN (:preparedArray8,:preparedArray9)329μs6.03KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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 20755μs24.83KBParams/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) AND `t`.`access` IN (:preparedArray4,:preparedArray5)299μs5.31KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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 20923μs40.91KBParams/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,:preparedArray6,:preparedArray7) AND `t`.`access` IN (:preparedArray8,:preparedArray9)369μs6.03KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • 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 20716μs24.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)299μs5.28KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • select * from ldoa_fields_values where field_id="3" AND item_id=141270μs976B/templates/echo/html/com_content/article/default-20200723-134318.php:156Copy
  • select * from ldoa_fields_values where field_id="9" AND item_id=141206μs976B/templates/echo/html/com_content/article/default-20200723-134318.php:174Copy
  • 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`566μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM ldoa_extensions WHERE element='mod_djmegamenu' LIMIT 1326μ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` asc477μ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` asc388μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy