­

What Would You Like to Know

In the summer, after the Christmas season, I have noted that many churches turn to preach from the Psalms. A number of factors may influence this choice. Psalms are often seen as stand-alone units, so useful in a season when members may be coming and going, away from church for reasons of rest and recreation or mission and ministry. CMS Summer Schools, SU Beach Missions and the like are some excellent reasons why people may not be on church on a particular Sunday. This can make preaching problematic, if each seeks to build on and connect with those which have gone before. Preaching a series of psalms may avoid this. Visiting or occasional preachers may more readily accept an invitation if they have a Psalm sermon or two in their preaching kitbag. However one problem with this approach is that the psalms are removed from their canonical context. This serves to denature important developmental themes, such as the interplay between lament and trust. See for example the placement of Psalm 23 affirming the Lord as protector provider, immediately following Psalm 22’s lament ‘My God, my God why have you abandoned me?’ It also ignores the arrangement of the Psalter into five books. So I want to consider Psalm 96 first of all in its canonical context.

Psalm 96 is one of a group of “the Lord reigns” or “Kingship of Yahweh” psalms which occur early in Book IV of the Psalter. These have been seen by some scholars as enthronement psalms. The evidence for this as a psalm category is not strong, but most of this particular psalm is used (reused?) in 1 Chronicles 16 to accompany the celebration of the ark being taken into Jerusalem. Kidner observed, ‘The symbolism of the march, in which God crowned his victories by planting his throne in the enemy’s former citadel, is matched by the theme of the psalm.’ (Derek Kidner, Psalms 73–150: An Introduction and Commentary, vol. 16, TOTC (Downers Grove: IVP, 1975), 379.)

Another characteristic of the psalm in its canonical context is the more universal view, beyond the community of God’s OT people, Israel and Judah. This psalm belongs with a group (92-101) which explicitly refer to singing and call on people(s) to worship the Lord (Yhwh).

It can aid our interpretation to also consider this psalm from the perspective of its use in the worship of God’s people, both from its use before and after the coming of Jesus the Christ. Often Psalms used liturgically can be read antiphonally, and if we consider the first three verses, the psalm reads like a conversation of mutual encouragement. Paul seems to have something like this in mind when he urges Christians to speak to one another with psalms, hymns, and spiritual songs (Eph. 5:19). The first part of these Psalm verse, has a comparable and developing response in the second half.

  1. Sing to the Lord a new song;
    sing to the Lord, all the earth.
  2. Sing to the Lord, praise his name;
    proclaim his salvation day after day.
  3. Declare his glory among the nations,
    his marvellous deeds among all peoples.

The verses begin with a series of imperatives, and urging to sing and worship the Lord (Yhwh). Note the thrice repeated Yhwh, the specific Name of the revealed God of Israel. There is a development in the verses. God’s people are not just urging each other on in song and words of worship and praise, but further into proclamation and declaration among the nations and all peoples (Christians could use the language of evangelism and mission). This wider view was actually implicitly present in verse 1 where all the earth was called to sing to the Lord.

The next three verses give reasons for singing, worship and declaration. The Lord is great, worthy, and to be feared in contrast to all other rival ‘gods’. It is the Lord who is creator of the heavens. Use of the heavens may help users of this psalm to see the wider scope of God as Lord of all who are under the heavens. He also created the land but this would possibly narrow our view, a more human and particular perspective.

Verse seven begins to call on all the families of nations to join in this great corporate recognition of the Lord’s glory and strength. The vision is of all peoples flowing to the Lord’s sanctuary (temple?), bringing offerings in worship and recognition of God’s glory and holiness.

Who is being addressed in verse 10 is open to interpretation. Is it God’s people, or the nations / all the earth? I lean to thinking this psalm is calling on all peoples to be affirming to one another that the Lord is reigning. The rationale for the call is the solidity of the created world and God’s equitable judgment of the peoples. These are reasons which apply more broadly than with Israel and Judah of the OT or the church of the NT era and beyond until the Lord’s return. It is verse 10 which unites this psalm with others nearby as a “Lord reigns” psalm.

The final verses of the psalm are a continuing call to worship, but now the call goes out beyond all humanity. Every aspect of creation: heavens, earth, sea, fields and all living things they contain, the trees of the bush are called to worship, in fact ‘Let all creation rejoice before the Lord.’ God coming as judge is the reason appended to this final call to worship the Lord.

As Christians we read this psalm through the lens of Christ and his coming. It is the salvation brought by Jesus’ death and resurrection, which we proclaim and which is our reason for worship and gospel proclamation. Jesus’ return, his coming as Lord and righteous judge, is our ultimate perspective. When we use this psalm, we should call on one another, the whole world, and indeed all peoples, to acknowledge the one true God and saviour. We are called to worship this God and to declare his greatness and glory in mission. This call and the mission of God’s people goes beyond our own local gathering and looks to all that God has made resounding in the worship and celebration of God.

Len Firth is Lecturer in Professional Supervision for Ridley College; Pastoral Supervisor and Ministry Coach; Associate Minister St John’s West Brunswick. Former Archdeacon for Multi-cultural Ministry in the Anglican Diocese of Melbourne.

­
11.337MBMemory Usage256msRequest 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" => 1744235641 "last" => 1744235641...
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.222.240.84" => "US" ] ]
  • afterLoad (94.7KB) (1.63ms)
  • afterInitialise (1.54MB) (42.27ms)
  • afterRoute (2.32MB) (30.87ms)
  • beforeRenderComponent com_content (196.51KB) (5.26ms)
  • Before Access::preloadComponents (all components) (47.96KB) (2.17ms)
  • After Access::preloadComponents (all components) (126.38KB) (2.91ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (14μs)
  • After Access::preloadPermissions (com_content) (585.58KB) (2.57ms)
  • Before Access::getAssetRules (id:1079 name:com_content.article.913) (34.8KB) (38μs)
  • After Access::getAssetRules (id:1079 name:com_content.article.913) (8.47KB) (99μs)
  • afterRenderComponent com_content (652.41KB) (71.99ms)
  • afterDispatch (13.2KB) (1.44ms)
  • beforeRenderRawModule mod_custom (footer) (393.09KB) (10.79ms)
  • afterRenderRawModule mod_custom (footer) (4.25KB) (560μs)
  • beforeRenderModule mod_custom (footer) (704B) (4μs)
  • afterRenderModule mod_custom (footer) (4.24KB) (317μs)
  • beforeRenderRawModule mod_menu (Publications) (1.29KB) (41μs)
  • afterRenderRawModule mod_menu (Publications) (3.49MB) (14.82ms)
  • beforeRenderModule mod_menu (Publications) (720B) (9μs)
  • afterRenderModule mod_menu (Publications) (10.98KB) (192μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (53μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.12KB) (1.59ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (110μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (42μs)
  • afterRenderRawModule mod_menu (Main Menu) (553.68KB) (7.74ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (11.32KB) (239μ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) (4.13ms)
  • beforeRenderModule mod_finder (What Would You Like to Know) (736B) (4μs)
  • afterRenderModule mod_finder (What Would You Like to Know) (3.75KB) (232μs)
  • afterRender (326.99KB) (53.77ms)
  • 1 x afterRenderComponent com_content (652.41KB) (28.09%)
    71.99ms
    1 x afterRender (326.99KB) (20.98%)
    53.77ms
    1 x afterInitialise (1.54MB) (16.49%)
    42.27ms
    1 x afterRoute (2.32MB) (12.04%)
    30.87ms
    1 x afterRenderRawModule mod_menu (Publications) (3.49MB) (5.78%)
    14.82ms
    1 x beforeRenderRawModule mod_custom (footer) (393.09KB) (4.21%)
    10.79ms
    1 x afterRenderRawModule mod_menu (Main Menu) (553.68KB) (3.02%)
    7.74ms
    1 x beforeRenderComponent com_content (196.51KB) (2.05%)
    5.26ms
    1 x afterRenderRawModule mod_finder (What Would You Like to Know) (61.17KB) (1.61%)
    4.13ms
    1 x After Access::preloadComponents (all components) (126.38KB) (1.14%)
    2.91ms
    1 x After Access::preloadPermissions (com_content) (585.58KB) (1%)
    2.57ms
    1 x Before Access::preloadComponents (all components) (47.96KB) (0.85%)
    2.17ms
    1 x afterLoad (94.7KB) (0.64%)
    1.63ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.12KB) (0.62%)
    1.59ms
    1 x afterDispatch (13.2KB) (0.56%)
    1.44ms
    1 x afterRenderRawModule mod_custom (footer) (4.25KB) (0.22%)
    560μs
    1 x afterRenderModule mod_custom (footer) (4.24KB) (0.12%)
    317μs
    1 x afterRenderModule mod_menu (Main Menu) (11.32KB) (0.09%)
    239μs
    1 x afterRenderModule mod_finder (What Would You Like to Know) (3.75KB) (0.09%)
    232μs
    1 x afterRenderModule mod_menu (Publications) (10.98KB) (0.07%)
    192μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (0.04%)
    110μs
    1 x After Access::getAssetRules (id:1079 name:com_content.article.913) (8.47KB) (0.04%)
    99μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (0.02%)
    53μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (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 Before Access::getAssetRules (id:1079 name:com_content.article.913) (34.8KB) (0.01%)
    38μ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_menu (Main Menu) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    4μ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 unique97.95ms1.1MB
  • SELECT @@SESSION.sql_mode;582μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `vax0y_session` WHERE `session_id` = ?300μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = :session_id LIMIT 1274μ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.47ms944BParams/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` = 1461μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vax0y_viewlevels`227μ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` = :guest367μ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`1.28ms4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM vax0y_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'198μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM vax0y_rsfirewall_hashes WHERE `type`='protect'471μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM vax0y_rsfirewall_configuration302μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `vax0y_rsfirewall_logs`10.51ms2.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-09 21:54:01' LIMIT 1470μ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`7.54ms820.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)969μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM vax0y_rsfirewall_snapshots WHERE `type`='protect'229μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.222.240.84' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'410μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.222.240.84' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'3.83ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM vax0y_rsfirewall_exceptions WHERE `published`='1'234μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `vax0y_languages` WHERE `published` = 1 ORDER BY `ordering` ASC491μ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` = 1638μ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.48ms8.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.43ms81.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `vax0y_content`9.64ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `vax0y_content` SET `hits` = (`hits` + 1) WHERE `id` = '913'2.19ms48B/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)2.09ms24.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`652μs5.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)1.78ms5.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`928μ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 ASC798μs5.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `vax0y_users`8.74ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_users` WHERE `id` = :userid259μ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` = :muserid528μs12.7KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1377μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1364μ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.62ms35.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `vax0y_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1404μ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)284μ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)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)883μ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` = 1316μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `template` FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1303μs856B/plugins/system/rsmatias/helper.php:62Copy
  • SHOW FULL COLUMNS FROM `vax0y_template_styles`26.31ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `id` = '23'272μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = ?281μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vax0y_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.71ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy