Courses for Policy, Projects & Programmes

Data Visualisation in R Using ggplot 2

Courses Summary
  • Duration : 1 Day
  • Price : £490 + VAT
  • Start Dates : Please get in touch.
Book Now
Details
Category: Policy, Projects & Programmes
Published: Tuesday, 07 July 2020 09:48
Written by: Matt Pye - HWD

Overview

Data visualisation is an important part of quantitative analysis that allows us to explore data and communicate our findings. ggplot2 is part of the ‘Tidyverse’ family of packages that aim to make data management, analysis and visualisation more user-friendly. It contains a wide range of options to customise plots and can be used for all types of data. This course will discuss good practice when preparing data to plot and introduce a range of commonly used plots within the ggplot package. Users will be shown how to customise plots to convey the message they need in the clearest, most informative way. Please note that this course is only recommended for those that have learned the basics of R elsewhere. The course assumes a basic knowledge of R programming (please get in touch if you’d like information on our ‘Intro to R’ online or face-to-face course).

Learning Objectives

  1. Understand the importance of data visualisation in quantitative analysis and its role in exploring data and effectively communicating findings.

  2. Gain proficiency in using the ggplot2 package in R for data visualisation, including loading data, preparing data for plotting, and creating basic plots.

  3. Explore a variety of commonly used plots in ggplot2, such as scatter plots, bar charts, line graphs, histograms, and boxplots, and understand their applications and interpretation.

  4. Learn how to customise and enhance plots in ggplot2 to effectively convey information and insights, including adjusting axis labels, titles, colors, legends, and annotations.

  5. Develop an understanding of good practices for preparing data for visualisation, including data cleaning, transformation, and aggregation techniques, to ensure accurate and meaningful visual representations.

  6. Acquire skills in creating advanced visualisations in ggplot2, such as faceted plots, heatmaps, and interactive plots, to handle more complex and multidimensional datasets.

  7. Apply principles of visual design and data storytelling to create visually compelling and informative plots that effectively communicate key messages and insights from the data.

  8. Practice hands-on exercises and real-world examples using ggplot2 in R to gain practical experience in creating, customising, and interpreting data visualisations, and to be able to apply these skills to their own data analysis projects.

Related Courses

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

Contact Us

J! InfoRequestSessionProfileQueries44
5MBMemory Usage154msRequest 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" => 1742948295 "last" => 1742948295...
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.61ms)
  • afterInitialise (882.31KB) (31.66ms)
  • afterRoute (380.72KB) (9.71ms)
  • beforeRenderComponent com_content (99.57KB) (6.63ms)
  • Before Access::preloadComponents (all components) (105.68KB) (3.77ms)
  • After Access::preloadComponents (all components) (115.83KB) (1.09ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (32μs)
  • After Access::preloadPermissions (com_content) (58.01KB) (674μs)
  • Before Access::getAssetRules (id:162 name:com_content.article.111) (6.8KB) (31μs)
  • After Access::getAssetRules (id:162 name:com_content.article.111) (8.47KB) (258μs)
  • Before Access::getAssetRules (id:8 name:com_content) (626.44KB) (38.08ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (23μs)
  • afterRenderComponent com_content (118.15KB) (5.4ms)
  • afterDispatch (2.28KB) (235μs)
  • beforeRenderRawModule mod_custom (Social Options) (427.59KB) (3.66ms)
  • afterRenderRawModule mod_custom (Social Options) (4.12KB) (1.26ms)
  • beforeRenderModule mod_custom (Social Options) (720B) (8μs)
  • afterRenderModule mod_custom (Social Options) (4.36KB) (268μs)
  • beforeRenderRawModule mod_custom (Footer) (360B) (56μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (264μs)
  • beforeRenderModule mod_custom (Footer) (704B) (5μs)
  • afterRenderModule mod_custom (Footer) (3.16KB) (104μs)
  • beforeRenderRawModule mod_custom (Contact CTA) (328B) (31μs)
  • afterRenderRawModule mod_custom (Contact CTA) (960B) (241μs)
  • beforeRenderModule mod_custom (Contact CTA) (720B) (3μs)
  • afterRenderModule mod_custom (Contact CTA) (2.52KB) (100μs)
  • beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (59μs)
  • afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.04KB) (18.7ms)
  • beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (23μs)
  • afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (226μs)
  • beforeRenderRawModule mod_menu (All Page) (6.59KB) (50μs)
  • afterRenderRawModule mod_menu (All Page) (4.28KB) (934μs)
  • beforeRenderModule mod_menu (All Page) (704B) (8μs)
  • afterRenderModule mod_menu (All Page) (4.15KB) (100μs)
  • beforeRenderRawModule mod_search (Search our courses) (1.2KB) (74μs)
  • afterRenderRawModule mod_search (Search our courses) (14.27KB) (1.24ms)
  • beforeRenderModule mod_search (Search our courses) (720B) (8μs)
  • afterRenderModule mod_search (Search our courses) (3.05KB) (122μs)
  • afterRender (249.27KB) (9.2ms)
  • 1 x Before Access::getAssetRules (id:8 name:com_content) (626.44KB) (24.7%)
    38.08ms
    1 x afterInitialise (882.31KB) (20.53%)
    31.66ms
    1 x afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.04KB) (12.12%)
    18.70ms
    1 x afterRoute (380.72KB) (6.3%)
    9.71ms
    1 x afterLoad (539.87KB) (6.23%)
    9.61ms
    1 x afterRender (249.27KB) (5.97%)
    9.20ms
    1 x beforeRenderComponent com_content (99.57KB) (4.3%)
    6.63ms
    1 x afterRenderComponent com_content (118.15KB) (3.5%)
    5.40ms
    1 x Before Access::preloadComponents (all components) (105.68KB) (2.45%)
    3.77ms
    1 x beforeRenderRawModule mod_custom (Social Options) (427.59KB) (2.37%)
    3.66ms
    1 x afterRenderRawModule mod_custom (Social Options) (4.12KB) (0.81%)
    1.26ms
    1 x afterRenderRawModule mod_search (Search our courses) (14.27KB) (0.8%)
    1.24ms
    1 x After Access::preloadComponents (all components) (115.83KB) (0.71%)
    1.09ms
    1 x afterRenderRawModule mod_menu (All Page) (4.28KB) (0.61%)
    934μs
    1 x After Access::preloadPermissions (com_content) (58.01KB) (0.44%)
    674μs
    1 x afterRenderModule mod_custom (Social Options) (4.36KB) (0.17%)
    268μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.17%)
    264μs
    1 x After Access::getAssetRules (id:162 name:com_content.article.111) (8.47KB) (0.17%)
    258μs
    1 x afterRenderRawModule mod_custom (Contact CTA) (960B) (0.16%)
    241μs
    1 x afterDispatch (2.28KB) (0.15%)
    235μs
    1 x afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (0.15%)
    226μs
    1 x afterRenderModule mod_search (Search our courses) (3.05KB) (0.08%)
    122μs
    1 x afterRenderModule mod_custom (Footer) (3.16KB) (0.07%)
    104μs
    1 x afterRenderModule mod_menu (All Page) (4.15KB) (0.06%)
    100μs
    1 x afterRenderModule mod_custom (Contact CTA) (2.52KB) (0.06%)
    100μs
    1 x beforeRenderRawModule mod_search (Search our courses) (1.2KB) (0.05%)
    74μs
    1 x beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (0.04%)
    59μs
    1 x beforeRenderRawModule mod_custom (Footer) (360B) (0.04%)
    56μs
    1 x beforeRenderRawModule mod_menu (All Page) (6.59KB) (0.03%)
    50μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.02%)
    32μs
    1 x Before Access::getAssetRules (id:162 name:com_content.article.111) (6.8KB) (0.02%)
    31μs
    1 x beforeRenderRawModule mod_custom (Contact CTA) (328B) (0.02%)
    31μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    23μs
    1 x beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (0.01%)
    23μs
    1 x beforeRenderModule mod_custom (Social Options) (720B) (0.01%)
    8μs
    1 x beforeRenderModule mod_menu (All Page) (704B) (0.01%)
    8μs
    1 x beforeRenderModule mod_search (Search our courses) (720B) (0.01%)
    8μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Contact CTA) (720B) (0%)
    3μs
44 statements were executed, 2 of which were duplicates, 42 unique17.37ms321.07KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;182μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ldoa_session` WHERE `session_id` = ?211μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ldoa_session` WHERE `session_id` = :session_id LIMIT 1118μ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.31ms944BParams/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` = 1424μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ldoa_viewlevels`125μ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` = :guest154μ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`661μ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.21ms136.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `ldoa_languages` WHERE `published` = 1 ORDER BY `ordering` ASC233μ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` = 1352μ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)475μ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` = 0305μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ldoa_content`523μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ldoa_content` SET `hits` = (`hits` + 1) WHERE `id` = '111'165μ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)466μ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`380μ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)247μ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`342μ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.22ms6.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` = :itemid185μ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.28ms2.19KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • select catid from ldoa_content where id=111138μs856B/templates/echo/html/com_content/article/default.php:13Copy
  • select title from ldoa_categories where id=26103μs856B/templates/echo/html/com_content/article/default.php:15Copy
  • SHOW FULL COLUMNS FROM `ldoa_categories`475μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '26'198μ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)192μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '24'134μ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)941μ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 20922μ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)262μs6.09KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id95μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id78μs12.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id63μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id103μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id60μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id63μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id70μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id91μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id80μ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`498μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM ldoa_extensions WHERE element='mod_djmegamenu' LIMIT 1319μ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` asc436μ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` asc483μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy