­

What Would You Like to Know

Every now and then I like to devise and preach a topical sermon series. Some of these have been some of the most memorable series to me, and have sometimes gotten more engagement and discussion among the congregation than is usual. I’m no master of the genre, but here are three series I have preached.

  creed                                                                                                            

THE APOSTLES’ CREED

I thought preaching through the creed would be good catechesis—a chance to present a mini-systematic theology, an overview of the gospel story. If people knew the bones of the creed, and through this sermon series could put some flesh on those bones, they might be clearer on the gospel themselves, and better equipped to explain it to others. The series went: Founding Father (Psalm 104, James 1:16-18), Incarnate Son (Luke 1:26-38, Col 1:15-20), Suffering Servant (Isaiah 53:1-6, Rom 3:21-26), Exalted King (Acts 17:22-31, Phil 2:5-11) and finally, Life-giving Spirit (Acts 2:1-21, 1 Corinthians 15:20-28). I did not expound any one of the readings, but preached sermons expounding the fatherhood of God, the incarnation of Christ, the atoning exchange of the suffering servant, his now and future reign, and the ways God is transforming the world to perfect Christ’s work. Years later a woman told me that when she had just come to church she arrived in time to hear these sermons and they were perfect for her as someone who needed a walk through the basics and the big picture. That was nice to hear.

 seven

THE SEVEN DEADLY SINS

Every so often someone writes a novel or makes a TV series based on the seven deadly sins: anger, pride, lust, greed, sloth, gluttony and envy. If they can give appeal to a TV series, why not to a sermon series? I developed these talks using a consistent set of questions to give structure, namely: 1) What is sin X, and why is it your enemy? 2) How is Jesus the remedy for sin X? 3) How is living by the Spirit the therapy for sin X? And 4) What do you need to do? This repetition (hopefully) hammers home the message that sin is your enemy, Jesus is the remedy and living by his Spirit is our therapy in this life, and that there are particular steps to take in escaping these sins. The individual sins bring out different sides of Jesus’ holiness of life and atoning work as they are opposed to all sin. His life and death are all humility, against all pride. His life and death for us are his faithful industry in God’s service, against all sloth. His life and death are his satisfaction in doing God’s will, against all gluttony and insatiability. After the gluttony sermon a group formed spontaneously to pursue the discussion. They read a book together and met several times. Food is a big deal, connected to a lot of personal issues, but it is not much talked about from the front of church (unless, for example, you preach through the seven deadly sins).

 paradox                                                                                                            

PARADOXES OF THE CHRISTIAN LIFE

Reading Allan Chapple’s book True Devotion, I came across his section regarding the paradoxical nature of our relationship with God, which seemed to me a rare discussion of a true characteristic of our walk of faith. I hankered to explore this through a series of sermons on paradoxes of the Christian life, which came to birth last year. The six paradoxes were: Christ crucified (1 Cor 1:18-31, Is 53:1-5); Love your life and lose it, hate your life and keep it (Mark 8:22-38, Is 53:5-12); Christ is both absent and present (2 Cor 5:1-10, Psalm 13); We are at once sinners and saints (1 John 1:8- 2:2, Psalm 65:1-4); We are perfectly free and wholly enslaved (1 Cor 7:17-24, Exodus 19:1-8) and When we are weak, then we are strong (2 Cor 4:5-12, Psalm 22:1-11). I sought to use the same talk structure each time: first, Exploring the Paradox, where I showed each side of the paradox as it appeared in the Bible, and perhaps somewhere the two sides were both expressed together. Second came Resolving the Paradox, where I tried to show how both sides of the paradox were true and made sense, so that the paradox was not a contradiction, but an insight into the Christian life. Lastly came the section Living with the Paradox, where I tried to show how the truth of that paradox might shape our expectations and actions as we follow Christ. I may have bitten off more than I could chew at some points here, and I don’t have a story of these sermons making an impact on people. But I was very glad to have given it a go, and I might come back to this one day to see if I can distil the best of this series into a simpler and better set of talks.

­
11.283MBMemory Usage214msRequest 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" => 1744347268 "last" => 1744347268...
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.118.171.28" => "US" ] ]
  • afterLoad (94.98KB) (1.79ms)
  • afterInitialise (1.54MB) (45.09ms)
  • afterRoute (2.32MB) (19.38ms)
  • beforeRenderComponent com_content (196.51KB) (5.15ms)
  • Before Access::preloadComponents (all components) (46.98KB) (1.75ms)
  • After Access::preloadComponents (all components) (126.38KB) (8.2ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (14μs)
  • After Access::preloadPermissions (com_content) (585.58KB) (2.54ms)
  • Before Access::getAssetRules (id:958 name:com_content.article.814) (34.8KB) (42μs)
  • After Access::getAssetRules (id:958 name:com_content.article.814) (8.47KB) (96μs)
  • afterRenderComponent com_content (584.27KB) (53.72ms)
  • afterDispatch (13.21KB) (1.46ms)
  • beforeRenderRawModule mod_custom (footer) (393.09KB) (11.41ms)
  • afterRenderRawModule mod_custom (footer) (4.25KB) (787μs)
  • beforeRenderModule mod_custom (footer) (704B) (5μs)
  • afterRenderModule mod_custom (footer) (4.24KB) (511μs)
  • beforeRenderRawModule mod_menu (Publications) (1.29KB) (41μs)
  • afterRenderRawModule mod_menu (Publications) (3.5MB) (15.74ms)
  • beforeRenderModule mod_menu (Publications) (720B) (9μs)
  • afterRenderModule mod_menu (Publications) (10.98KB) (355μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (58μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (5.7KB) (616μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (210μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (39μs)
  • afterRenderRawModule mod_menu (Main Menu) (553.68KB) (7.05ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (11.32KB) (164μs)
  • beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (40μs)
  • afterRenderRawModule mod_finder (What Would You Like to Know) (61.17KB) (5.05ms)
  • beforeRenderModule mod_finder (What Would You Like to Know) (736B) (4μs)
  • afterRenderModule mod_finder (What Would You Like to Know) (3.75KB) (354μs)
  • afterRender (264.77KB) (32.34ms)
  • 1 x afterRenderComponent com_content (584.27KB) (25.05%)
    53.72ms
    1 x afterInitialise (1.54MB) (21.03%)
    45.09ms
    1 x afterRender (264.77KB) (15.08%)
    32.34ms
    1 x afterRoute (2.32MB) (9.04%)
    19.38ms
    1 x afterRenderRawModule mod_menu (Publications) (3.5MB) (7.34%)
    15.74ms
    1 x beforeRenderRawModule mod_custom (footer) (393.09KB) (5.32%)
    11.41ms
    1 x After Access::preloadComponents (all components) (126.38KB) (3.83%)
    8.20ms
    1 x afterRenderRawModule mod_menu (Main Menu) (553.68KB) (3.29%)
    7.05ms
    1 x beforeRenderComponent com_content (196.51KB) (2.4%)
    5.15ms
    1 x afterRenderRawModule mod_finder (What Would You Like to Know) (61.17KB) (2.36%)
    5.05ms
    1 x After Access::preloadPermissions (com_content) (585.58KB) (1.18%)
    2.54ms
    1 x afterLoad (94.98KB) (0.84%)
    1.79ms
    1 x Before Access::preloadComponents (all components) (46.98KB) (0.81%)
    1.75ms
    1 x afterDispatch (13.21KB) (0.68%)
    1.46ms
    1 x afterRenderRawModule mod_custom (footer) (4.25KB) (0.37%)
    787μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (5.7KB) (0.29%)
    616μs
    1 x afterRenderModule mod_custom (footer) (4.24KB) (0.24%)
    511μs
    1 x afterRenderModule mod_menu (Publications) (10.98KB) (0.17%)
    355μs
    1 x afterRenderModule mod_finder (What Would You Like to Know) (3.75KB) (0.17%)
    354μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (0.1%)
    210μs
    1 x afterRenderModule mod_menu (Main Menu) (11.32KB) (0.08%)
    164μs
    1 x After Access::getAssetRules (id:958 name:com_content.article.814) (8.47KB) (0.04%)
    96μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (0.03%)
    58μs
    1 x Before Access::getAssetRules (id:958 name:com_content.article.814) (34.8KB) (0.02%)
    42μs
    1 x beforeRenderRawModule mod_menu (Publications) (1.29KB) (0.02%)
    41μs
    1 x beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (0.02%)
    40μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (0.02%)
    39μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_menu (Publications) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_finder (What Would You Like to Know) (736B) (0%)
    4μs
47 statements were executed, 7 of which were duplicates, 40 unique81.43ms1.1MB
  • SELECT @@SESSION.sql_mode;211μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `vax0y_session` WHERE `session_id` = ?262μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = :session_id LIMIT 1207μ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)1.63ms944BParams/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` = 1638μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vax0y_viewlevels`255μ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` = :guest440μ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.5ms4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM vax0y_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'229μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM vax0y_rsfirewall_hashes WHERE `type`='protect'735μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM vax0y_rsfirewall_configuration564μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `vax0y_rsfirewall_logs`9.38ms2.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-11 04:54:28' LIMIT 1870μs840B/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`6.41ms820.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)586μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM vax0y_rsfirewall_snapshots WHERE `type`='protect'149μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.118.171.28' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'387μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.118.171.28' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'2.28ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM vax0y_rsfirewall_exceptions WHERE `published`='1'178μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `vax0y_languages` WHERE `published` = 1 ORDER BY `ordering` ASC479μ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` = 1451μ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)7.23ms8.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` = 01.26ms81.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `vax0y_content`8.39ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `vax0y_content` SET `hits` = (`hits` + 1) WHERE `id` = '814'2.05ms48B/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)776μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `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)520μs5.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`947μ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 ASC936μs5.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `vax0y_users`9.21ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_users` WHERE `id` = :userid286μ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` = :muserid327μs12.71KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1465μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1354μ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`1.45ms35.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `vax0y_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1618μ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)401μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `vax0y_schemaorg` WHERE `itemId` = :itemId AND `context` = :context491μ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)673μs24.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)565μ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` = 1239μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `template` FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1334μs856B/plugins/system/rsmatias/helper.php:62Copy
  • SHOW FULL COLUMNS FROM `vax0y_template_styles`11.94ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `id` = '23'246μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = ?441μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vax0y_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.37ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy