­

What Would You Like to Know

Last year Essentials published my article, ‘Homiletical Health Check’, a survey of sermons in 20 churches from different denominations. In that article we heard the preachers speak. Now it’s time to hear the listeners. Essentials decided to conduct a follow-up survey, asking congregational members what they thought of the preaching in their churches. 47 churches were asked to participate; nine responded. Out of those nine churches 53 people filled in the survey. All the churches are evangelical, and just over one-half are Anglican. Nearly all the respondents live in urban areas, with most living along the eastern seaboard: 72% live in Melbourne, Sydney, or Brisbane.

The obvious weakness in the survey is the small data set. Nevertheless, the survey still works as a qualitative assessment of what value members of evangelical churches place on preaching. As such, there are valuable insights for people who preach regularly.

The survey asked 12 questions. We’ll briefly summarise the response to each question.

1: WHAT IS THE FOCAL POINT DURING YOUR SUNDAY GATHERING?

The focal point of most of these services is the sermon.

2: ON A SCALE OF 1 - 10, WITH 1 BEING THE LOWEST, AND 10 THE HIGHEST, HOW IMPORTANT IS PREACHING FOR YOU PERSONALLY?

91% of people surveyed answered the question between 8 and 10. And the lowest score chosen was 7. And those who chose 7 did so because they understood that the other parts of the service were also important to them.

3: WHY DID YOU CHOOSE THAT PARTICULAR RATING IN QUESTION TWO?

Those who responded to question two with a “10” all answered that preaching helps them to know the word of God better, and grow spiritually.

4: WHAT DIFFERENT TYPES OF SERMONS ARE THERE AT YOUR CHURCH?

The most common type is expositional. The next most common are evangelistic and thematic.

5: HOW FREQUENTLY IS A SERMON IN YOUR CHURCH GIVEN IN A MANNER THAT YOU CAN EITHER TAKE SOMETHING CONCRETE FROM IT, OR THE APPLICATION IS CLEAR?

The majority of respondents (46 out of 53) felt that out of every four sermons at least three had something applicable to their lives.

6: WHEN THERE IS APPLICATION HOW OFTEN IS IT EITHER: "TELL SOMEONE ABOUT JESUS", "READ YOUR BIBLE", "PRAY MORE FREQUENTLY" OR SOMETHING ALONG THOSE LINES.

60% of respondents felt there is an appropriate balance of application in the sermons. 32% felt the application was always one of those three applications.

7: HOW OFTEN DOES THE PREACHING AFFIRM OR ENCOURAGE THE CONGREGATION FOR THEIR FAITHFULNESS AS CHRISTIANS?

81% of respondents felt that the preaching regularly affirms the congregation for their faithfulness as Christians.

8: WHAT'S THE TYPICAL LENGTH OF SERMONS AT YOUR CHURCH?

About one-third of respondents hear sermons which are between 21-25 minutes long. About another one third are hearing sermons up to 40 minutes long. That means about one-third are hearing sermons between 16-20 minutes, or up to an hour in length.

9: ARE YOU SATISFIED WITH THE LENGTH OF THE SERMONS? ARE THEY: TOO SHORT, TOO LONG OR ABOUT RIGHT?

89% of respondents felt that they were satisfied with the length of the sermons at their church. This was regardless of whether the sermons were 16 minutes long, or longer than an hour.

10: WHAT DO YOU ENJOY MOST ABOUT THE PREACHING AT YOUR CHURCH?

The most consistent comment is that people appreciate preaching which is based on the Bible (36%), is clearly and engagingly delivered, and which they can apply to their lives. People also mentioned that they appreciate well researched sermons.

11: WHAT PARTS OF THE PREACHING AT YOUR CHURCH MIGHT NEED MORE ATTENTION?

The majority said ‘nothing’ (30 %). Those who did comment would like more depth to the sermons, better application, and would like more variety in delivery and style.

12: ARE THERE ANY PARTICULAR COMMENTS YOU WOULD LIKE TO MAKE IN RELATION TO THE PREACHING AT YOUR CHURCH?

Here’s a sample of the comments:

  • “They are Bible-centric, relevant to the sermon series theme, well researched and delivered.”
  • “We are blessed with three ministers…with various styles of preaching and all keep us on our toes as they deliver God’s message”.
  • “It’s consistently very good.”
  • “I look forward to it”.
  • “I like longer sermons that go deeper.”
  • “We are truly blessed by the standard of preaching”.

There were many other similar comments.

GENERAL OBSERVATIONS

Again, we need to bear in mind that this is a small sample. Perhaps preachers who are less confident about their preaching or were concerned about what their people might say, decided not to distribute the survey. Or, perhaps, in the busyness of church life it just was too far down the priority list. But a few things stand out.

People value good preaching. One of my (Mike’s) observations over many years is that a good sermon covers a multitude of – not sins - but perhaps deficiencies in other areas. The pastor may not be the best administrator, or a great counsellor, or even a less committed visitor of the people, but if a spiritually tasty and nutritious meal is served up on Sunday then people will thank God for the ministry.

People are receiving solid application. When I ask preachers where they struggle, the most common response is in application. On the one hand, the survey suggests that people feel the Biblical expositions they hear are well applied to their lives. On the other hand, a number also feel that application needs to be a constant focus in the sermons.

People are happy with the length of the sermon.

While ‘how long should a sermon be?’ is a hot debate amongst preachers, if this survey is anything to go by, it’s less of an issue for the people. Most have been trained to listen to a sermon of a certain length and are content with that. The key issue isn’t length but faithfulness to the Bible and good application.

People appreciate sermons that ‘go deep’ and are well-researched. If I can put this in my own words, most people can discern when a sermon has been thoroughly prepared and not just hurriedly written the night before. And they like new insights, perhaps into the text or how the Bible speaks into our contemporary situation. In short, they appreciate sermons that are intellectually stimulating.

Well done! The last lesson to take home from this survey is that many (most?) evangelical preachers are serving God’s people well in their preaching, and so honouring the God who has set them apart for this work. The people really appreciate it (even if they don’t always tell you). Let this be a stimulus to us, not to sit back on any laurels, but continue to grow as preachers to the glory of God and the edification of the saints.

Michael Raiter is the Director of the Centre for Biblical Preaching. Tim Collison is Assistant Minister St Marks’ Camberwell and Secretary of EFAC Australia

­
13.489MBMemory Usage606msRequest Duration
Joomla! Version5.2.6
PHP Version8.1.31
Identityguest
Response200
Templatersjuno
Database
Server
mysql
Version
8.0.28-0ubuntu0.20.04.3
Collation
utf8_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "CONTENT_LEN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744582816 "last" => 1744582816...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
com_rsfirewall
array:1 [ "geoip" => array:1 [ "18.218.121.8" => "US" ] ]
  • afterLoad (363.07KB) (52.09ms)
  • afterInitialise (2.76MB) (170ms)
  • afterRoute (2.32MB) (51.91ms)
  • beforeRenderComponent com_content (393.52KB) (25.28ms)
  • Before Access::preloadComponents (all components) (115.08KB) (10.78ms)
  • After Access::preloadComponents (all components) (126.38KB) (4.97ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (16μs)
  • After Access::preloadPermissions (com_content) (585.58KB) (4.45ms)
  • Before Access::getAssetRules (id:1226 name:com_content.article.1039) (34.8KB) (58μs)
  • After Access::getAssetRules (id:1226 name:com_content.article.1039) (8.63KB) (787μs)
  • afterRenderComponent com_content (989.8KB) (143ms)
  • afterDispatch (13.31KB) (2.04ms)
  • beforeRenderRawModule mod_custom (footer) (463.06KB) (27.15ms)
  • afterRenderRawModule mod_custom (footer) (5.38KB) (2.19ms)
  • beforeRenderModule mod_custom (footer) (704B) (5μs)
  • afterRenderModule mod_custom (footer) (4.66KB) (1.12ms)
  • beforeRenderRawModule mod_menu (Publications) (1.29KB) (47μs)
  • afterRenderRawModule mod_menu (Publications) (3.5MB) (18.91ms)
  • beforeRenderModule mod_menu (Publications) (720B) (8μs)
  • afterRenderModule mod_menu (Publications) (11.08KB) (743μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (58μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (70.43KB) (2.69ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (304μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (44μs)
  • afterRenderRawModule mod_menu (Main Menu) (554.2KB) (11.17ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (11.4KB) (744μs)
  • beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (47μs)
  • afterRenderRawModule mod_finder (What Would You Like to Know) (62.75KB) (16.05ms)
  • beforeRenderModule mod_finder (What Would You Like to Know) (736B) (6μs)
  • afterRenderModule mod_finder (What Would You Like to Know) (3.84KB) (640μs)
  • afterRender (396.68KB) (56.34ms)
  • 1 x afterInitialise (2.76MB) (28%)
    170ms
    1 x afterRenderComponent com_content (989.8KB) (23.69%)
    143ms
    1 x afterRender (396.68KB) (9.3%)
    56.34ms
    1 x afterLoad (363.07KB) (8.6%)
    52.09ms
    1 x afterRoute (2.32MB) (8.57%)
    51.91ms
    1 x beforeRenderRawModule mod_custom (footer) (463.06KB) (4.48%)
    27.15ms
    1 x beforeRenderComponent com_content (393.52KB) (4.17%)
    25.28ms
    1 x afterRenderRawModule mod_menu (Publications) (3.5MB) (3.12%)
    18.91ms
    1 x afterRenderRawModule mod_finder (What Would You Like to Know) (62.75KB) (2.65%)
    16.05ms
    1 x afterRenderRawModule mod_menu (Main Menu) (554.2KB) (1.84%)
    11.17ms
    1 x Before Access::preloadComponents (all components) (115.08KB) (1.78%)
    10.78ms
    1 x After Access::preloadComponents (all components) (126.38KB) (0.82%)
    4.97ms
    1 x After Access::preloadPermissions (com_content) (585.58KB) (0.74%)
    4.45ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (70.43KB) (0.44%)
    2.69ms
    1 x afterRenderRawModule mod_custom (footer) (5.38KB) (0.36%)
    2.19ms
    1 x afterDispatch (13.31KB) (0.34%)
    2.04ms
    1 x afterRenderModule mod_custom (footer) (4.66KB) (0.19%)
    1.12ms
    1 x After Access::getAssetRules (id:1226 name:com_content.article.1039) (8.63KB) (0.13%)
    787μs
    1 x afterRenderModule mod_menu (Main Menu) (11.4KB) (0.12%)
    744μs
    1 x afterRenderModule mod_menu (Publications) (11.08KB) (0.12%)
    743μs
    1 x afterRenderModule mod_finder (What Would You Like to Know) (3.84KB) (0.11%)
    640μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (0.05%)
    304μs
    1 x Before Access::getAssetRules (id:1226 name:com_content.article.1039) (34.8KB) (0.01%)
    58μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (0.01%)
    58μs
    1 x beforeRenderRawModule mod_menu (Publications) (1.29KB) (0.01%)
    47μs
    1 x beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (0.01%)
    47μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (0.01%)
    44μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    16μs
    1 x beforeRenderModule mod_menu (Publications) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_finder (What Would You Like to Know) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    5μs
47 statements were executed, 7 of which were duplicates, 40 unique128ms1.1MB
  • SELECT @@SESSION.sql_mode;175μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `vax0y_session` WHERE `session_id` = ?754μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = :session_id LIMIT 1237μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `vax0y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)3.12ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `vax0y_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.79ms2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vax0y_viewlevels`488μs960B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `vax0y_usergroups` AS `a` LEFT JOIN `vax0y_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest652μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `vax0y_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`2.27ms4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM vax0y_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'259μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM vax0y_rsfirewall_hashes WHERE `type`='protect'522μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM vax0y_rsfirewall_configuration555μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `vax0y_rsfirewall_logs`11.79ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT id FROM vax0y_yendifvideoshare_imports WHERE state = 1 AND next_import_date IS NOT NULL AND next_import_date != '0000-00-00 00:00:00' AND next_import_date <= '2025-04-13 22:20:16' LIMIT 11.79ms840B/plugins/system/yendifvideoshare/yendifvideoshare.php:74Copy
  • 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 `vax0y_menu` AS `m` LEFT JOIN `vax0y_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`18.51ms820.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM vax0y_rsfirewall_hashes WHERE (`type`='5.2.6' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)616μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM vax0y_rsfirewall_snapshots WHERE `type`='protect'341μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.218.121.8' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'458μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.218.121.8' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'5.15ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM vax0y_rsfirewall_exceptions WHERE `published`='1'973μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `vax0y_languages` WHERE `published` = 1 ORDER BY `ordering` ASC870μs2.22KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `vax0y_template_styles` AS `s` LEFT JOIN `vax0y_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` = 1864μs17.16KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `vax0y_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,:preparedArray41,:preparedArray42,:preparedArray43)1.72ms8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `vax0y_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 02.39ms81.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `vax0y_content`11.32ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `vax0y_content` SET `hits` = (`hits` + 1) WHERE `id` = '1039'3.5ms48B/libraries/src/Table/Table.php:1348Copy
  • 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 `vax0y_content` AS `a` INNER JOIN `vax0y_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vax0y_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vax0y_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vax0y_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vax0y_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)4.63ms24.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 `vax0y_categories` AS `s` INNER JOIN `vax0y_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.07ms5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `vax0y_contentitem_tag_map` AS `m` INNER JOIN `vax0y_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)2.21ms5.2KBParams/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 `vax0y_categories` AS `s` INNER JOIN `vax0y_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`617μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM vax0y_fields AS a LEFT JOIN `vax0y_languages` AS l ON l.lang_code = a.language LEFT JOIN vax0y_users AS uc ON uc.id=a.checked_out LEFT JOIN vax0y_viewlevels AS ag ON ag.id = a.access LEFT JOIN vax0y_users AS ua ON ua.id = a.created_user_id LEFT JOIN vax0y_fields_groups AS g ON g.id = a.group_id LEFT JOIN `vax0y_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5)) 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 ASC2.15ms5.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `vax0y_users`12.51ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_users` WHERE `id` = :userid328μs4.41KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `vax0y_usergroups` AS `g` INNER JOIN `vax0y_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid299μs12.7KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1586μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1357μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `vax0y_modules` AS `m` LEFT JOIN `vax0y_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `vax0y_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)) 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`3.38ms35.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `vax0y_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1616μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `vax0y_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)506μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `vax0y_schemaorg` WHERE `itemId` = :itemId AND `context` = :context385μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `vax0y_content` AS `a` INNER JOIN `vax0y_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vax0y_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vax0y_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vax0y_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vax0y_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)1.1ms24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `vax0y_content` AS `a` INNER JOIN `vax0y_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vax0y_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vax0y_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vax0y_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vax0y_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)720μs24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `vax0y_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.13ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `template` FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1322μs856B/plugins/system/rsmatias/helper.php:62Copy
  • SHOW FULL COLUMNS FROM `vax0y_template_styles`10.24ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `id` = '23'524μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = ?7.88ms1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vax0y_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?5.25ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy