­
Chris Appleby Ministries

Chris Appleby Ministries

 

Search

A Psalm of Yearning audio (5MB)

Psalm 27

There’s an old story of a young man who grew up on the wrong side of town.  He was bright and full of good intentions, but down on his luck.  Until one day, through a series of events he came into possession of a magic lamp that could grant his wishes.  If you believe the Disney version, he was only allowed three wishes.  And he couldn’t wish for more wishes, couldn't wish for someone to die, and couldn’t wish for someone to fall in love with him.  I wonder if you had Aladdin’s lamp, what would you wish for?

What are your deepest desires?  Would you wish for fame, fortune, happiness?  Maybe a good job, a happy family, and long life?  A packet of Tim-Tams that never runs out?  What would you wish for?

 

The writer of Psalm 27 could do with a few wishes.  Right from the start of the Psalm we see trouble.  Verse 1 is a bold expression of confidence:

1The Lord is my light and my salvation;

Whom shall I fear?

The Lord is the stronghold of my life;

Of whom should I be afraid?

But there’s also the hint that there is something to be afraid of.  The next two verses use great poetical license to describe the situation.  The Psalmist is surrounded by people who have it in for him.  There’s a bloodthirsty horde out to get him:

2When evildoers assail me

to devour my flesh—

my adversaries and foes—

they shall stumble and fall.

3Though an army encamp against me,

my heart shall not fear;

though war rise up against me,

yet I will be confident.

Towards the end of the Psalm we see that the attacks come from those around him too!  Look at verse 12:

12Do not give me up to the will of my adversaries,

for false witnesses have risen against me,

and they are breathing out violence.

The false witnesses aren’t foreign foes.  They’re likely to be fellow Israelites who are trying to accuse him of blasphemy or some other capital offence.  There’s no shortage of people out to get him!

The introduction to Psalm 27 tells us that the writer is David.  If you’re familiar with his story you know this reflects David’s early life.  He faced no shortage of confrontations!  At times you could say he was without a friend in the world.  Even his King and best friend were against him!

In this situation there are plenty of things that David might’ve wished for.  He might wish for the downfall of his enemies.  He might wish for his own protection.  He might wish that he could live happily ever after.

But David only wishes for one thing!  He doesn’t need three wishes.  There’s only one thing he’s longing for.  Look at verse 4:

4One thing I asked of the LORD,

that will I seek after:

to live in the house of the LORD

all the days of my life,

to behold the beauty of the LORD,

and to inquire in his temple.

The only thing David is longing for is to dwell in God’s house.  The temple is the place where God had especially promised to dwell.  It was where God’s people could seek his presence.  As Chris reminded us last week, coming into the sanctuary, coming into God’s presence helps us readjust to the reality of the world.  It helps put things into perspective.  In Psalm 27, we see it gives a sense of peace, of comfort and security.

Faced with all, sorts of trouble, it’s no wonder that David wants to dwell in the temple forever.  But I don’t think we’re to take this literally.  He’s not wishing that he could live in the temple 24 hours a day, seven days a week, 52 weeks of the year!  Sometimes that’s how much it feels like I’m at church, but it’s not something I wish for!

Instead, what David is yearning for, is for God to be with him always, no matter where he is.  He wants God to be present in his everyday life, just as he’s present in the temple.  He wants to be able to see God’s beauty all around him.  He wants to delight in what God is doing in his people, as his plans are fulfilled.  And David wants God to be with him, guiding him in his life.  He wants to be able to inquire of God, to be taught and led on level paths as verse 11 puts it.  He wants to God to be present with him as he journeys through life.

You may have heard of Brother Lawrence.  Though maybe not, because liven in the seventeenth century, and spent most his life in the kitchen in his monastery.  He sought to know God’s presence with him, every moment of every day, no matter what he was doing.  There was nothing else he desired.

Of course in this, Brother Lawrence and David are just echoing a longing that’s present throughout the Psalms.  It’s something we’re all encouraged to yearn for, as Psalm 105:4 says:

Seek the LORD and his strength;

seek his presence continually.

The Psalms tell us that there’s nothing better than being in God’s presence.  You might recognizing the words of Psalm 84, through one of the songs we sing;

Psa. 84:10

For a day in your courts is better

than a thousand elsewhere.

I would rather be a doorkeeper in the house of my God

than live in the tents of wickedness.

In this the Psalm’s are just picking up a theme that’s present through the whole bible.

Remember back in Genesis 3.  After they’d sinned Adam and Eve heard God walking in the garden and they hid from his presence. Likewise when he rebelled Jonah tried to flee from God’s presence.  The Bible tells us that sin separates us from being with God.  It cuts us of from the blessing that comes from being in his presence.  Psalm 51, reminds us that the worst thing that could ever happen to us, is for God to remove withdraw his presence:

Psa. 51:11

Do not cast me away from your presence,

and do not take your holy spirit from me.

Why is this so bad?  We read in the Bible that God’s presence is where we find peace and joy.  Moses knew that without God’s presence there was no point in the people going on after the Exodus. And think of that great picture that we are given at the end of Revelations.  In his vision John sees the new heaven and the new earth as a place where we dwell in God’s presence forever:

Rev. 21:3-4

3And I heard a loud voice from the throne saying, “See, the home of God is among mortals. He will dwell with them as their God; they will be his peoples, and God himself will be with them; 4he will wipe every tear from their eyes. Death will be no more; mourning and crying and pain will be no more, for the first things have passed away.”

The one thing that he wants, more than anything else, is to be with God, and to be with God.  David yearns to dwell with God forever.  But he also longs for God to be with him in the present, in the here and now.  That’s why he believes that he will see God at work in the land of the living, as verse 13 says.

Of course we have seen God present in the land of the living.  John tells us that God came to dwell with his people.

John 1:14

And the Word became flesh and lived among us, (lit. dwelt among us), and we have seen his glory, the glory of a father’s only son, full of grace and truth.

 

Here’s the beauty, the fullness of God’s presence!  We see it in Jesus.  And now of course, God dwells within us!  We heard in our series on Ephesians that Christ dwells in our hearts by faith.  That God the Spirit dwells within us, strengthening us in our inmost parts!  And, God’s Spirit is making us into a holy temple, the church is the dwelling place of God!

It’s the promise of God’s presence that gives David confidence in Psalm 27.  David knows that no matter how numerous, or how ferocious his enemies are, if God is with him they will not ultimately prevail.  And did you notice that the thought of God’s presence doesn’t just give him confidence, it makes him overflow with joy.  Verse 6 could be translated as making a noisy sacrifice.  God’s presence leads us to make a holy din!  David’s bursting with praise, because God is with him.

6Now my head is lifted up

above my enemies all around me,

and I will offer in his tent

sacrifices with shouts of joy;

I will sing and make melody to the LORD.

It would be nice and easy if the Psalm ended here, wouldn’t it?  On this confident note of praise.  But did you notice how the second half of the Psalm goes?  From verse 7 we see that yearning after God doesn’t mean the end of all our problems.  God’s presence doesn’t make the bad things in life go away.  In verse 12, the adversaries and foes are still there, still seeking violence.

So while he has renewed confidence and joy, he’s still yearning.  He cries all the more strongly to God.  It’s almost as if his yearning has gotten stronger, more passionate, more desperate.  The more he knows of God’s goodness, the more he thinks about the blessings that come from being in God’s presence, the more he realizes he needs it in the here and now, so the more strongly he keeps calling out for it.

Desiring God’s presence is something we need to keep urging ourselves to do.  In verse 8, David has to keep reminding himself to seek God’s face.  Through verses 7-9, David pleas with God six times not to desert him.  He might not fear his enemies, but what he does fear is that God’s presence will be removed.  His greatest fear is total abandonment.  Even having his mother and father forsake him would be tolerable, just so long as God remains with him.  There’s just one thing that David has asked for, but it’s something he continually seeks, day after day.  We have to be persistent in desiring God to be with us.

Yet in the end, the Psalm returns to that note of confidence and encouragement.  It ends with a reminder that despite all distractions, despite all discouragements, the one thing we’re to long for above anything else is God’s presence.  We’re to wait for the Lord.  We’re to wait, to look for, to long for, to yearn for God’s presence.  We’re to look to God for strength and courage.  And we’re to have strength and courage as we persist in our desire for God to be with us.

What are you waiting for?  What do you wish for?  What does your heart long for?  Psalm 27 tells us that the first thing, the most important thing, the only thing we should be yearning for, is God’s presence.  We should desire nothing else than that God would dwell with us and that we might dwell with him.  Would you trade in all your other wishes for this?  Will you, as Jesus said, ‘Seek first the Kingdom of Heaven?’

 

Contact Details

Phone: 0422187127
 
­
Settings9.173MBMemory Usage322msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
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" => 1747623324 "last" => 1747623324...
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.116.61.169" => "US" ] ]
tpl_rsjuno
array:1 [ "queue" => array:6 [ "components/com_content.css" => true "modules/mod_custom.cs...
  • afterLoad (93.11KB) (2.22ms)
  • afterInitialise (1.51MB) (34.15ms)
  • afterRoute (2.21MB) (56.92ms)
  • beforeRenderComponent com_content (164.48KB) (1.32ms)
  • Before Access::preloadComponents (all components) (125.27KB) (5.12ms)
  • After Access::preloadComponents (all components) (139.2KB) (3.82ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (13μs)
  • After Access::preloadPermissions (com_content) (153.71KB) (1.28ms)
  • Before Access::getAssetRules (id:163 name:com_content.article.396) (18.8KB) (19μs)
  • After Access::getAssetRules (id:163 name:com_content.article.396) (2.82KB) (363μs)
  • afterRenderComponent com_content (788.01KB) (110ms)
  • afterDispatch (98.14KB) (946μs)
  • beforeRenderRawModule mod_addtoany (AddToAny Buttons) (497.13KB) (22.35ms)
  • afterRenderRawModule mod_addtoany (AddToAny Buttons) (5.88KB) (2ms)
  • beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (5μs)
  • afterRenderModule mod_addtoany (AddToAny Buttons) (3.77KB) (762μs)
  • beforeRenderRawModule mod_menu (Main Menu) (24.05KB) (690μs)
  • afterRenderRawModule mod_menu (Main Menu) (1.71MB) (37.33ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (10μs)
  • afterRenderModule mod_menu (Main Menu) (47.4KB) (337μs)
  • beforeRenderRawModule mod_finder (Search) (66.97KB) (401μs)
  • afterRenderRawModule mod_finder (Search) (140.83KB) (14.1ms)
  • beforeRenderModule mod_finder (Search) (704B) (5μs)
  • afterRenderModule mod_finder (Search) (3.73KB) (316μs)
  • afterRender (367.47KB) (27.05ms)
  • 1 x afterRenderComponent com_content (788.01KB) (34.27%)
    110ms
    1 x afterRoute (2.21MB) (17.65%)
    56.92ms
    1 x afterRenderRawModule mod_menu (Main Menu) (1.71MB) (11.58%)
    37.33ms
    1 x afterInitialise (1.51MB) (10.59%)
    34.15ms
    1 x afterRender (367.47KB) (8.39%)
    27.05ms
    1 x beforeRenderRawModule mod_addtoany (AddToAny Buttons) (497.13KB) (6.93%)
    22.35ms
    1 x afterRenderRawModule mod_finder (Search) (140.83KB) (4.37%)
    14.10ms
    1 x Before Access::preloadComponents (all components) (125.27KB) (1.59%)
    5.12ms
    1 x After Access::preloadComponents (all components) (139.2KB) (1.18%)
    3.82ms
    1 x afterLoad (93.11KB) (0.69%)
    2.22ms
    1 x afterRenderRawModule mod_addtoany (AddToAny Buttons) (5.88KB) (0.62%)
    2.00ms
    1 x beforeRenderComponent com_content (164.48KB) (0.41%)
    1.32ms
    1 x After Access::preloadPermissions (com_content) (153.71KB) (0.4%)
    1.28ms
    1 x afterDispatch (98.14KB) (0.29%)
    946μs
    1 x afterRenderModule mod_addtoany (AddToAny Buttons) (3.77KB) (0.24%)
    762μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (24.05KB) (0.21%)
    690μs
    1 x beforeRenderRawModule mod_finder (Search) (66.97KB) (0.12%)
    401μs
    1 x After Access::getAssetRules (id:163 name:com_content.article.396) (2.82KB) (0.11%)
    363μs
    1 x afterRenderModule mod_menu (Main Menu) (47.4KB) (0.1%)
    337μs
    1 x afterRenderModule mod_finder (Search) (3.73KB) (0.1%)
    316μs
    1 x Before Access::getAssetRules (id:163 name:com_content.article.396) (18.8KB) (0.01%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    13μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    5μs
39 statements were executed, 6 of which were duplicates, 33 unique58.26ms493.68KB
  • SELECT @@SESSION.sql_mode;149μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `J30_session` WHERE `session_id` = ?246μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = :session_id LIMIT 1242μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `J30_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.07ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `J30_viewlevels`202μs1.58KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `J30_usergroups` AS `a` LEFT JOIN `J30_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest394μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `path` FROM J30_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'181μs840B/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM J30_rsfirewall_hashes WHERE `type`='protect'408μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM J30_rsfirewall_configuration406μs3.44KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `J30_rsfirewall_logs`8.57ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • 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 `J30_categories` AS `s` INNER JOIN `J30_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`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.67ms5.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `J30_content` WHERE `id` = :id1.9ms1.63KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM J30_rsfirewall_hashes WHERE (`type`='5.3.0' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)198μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM J30_rsfirewall_snapshots WHERE `type`='protect'204μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='18.116.61.169' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'352μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='18.116.61.169' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'210μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM J30_rsfirewall_exceptions WHERE `published`='1'1.1ms4.55KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `J30_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.54ms8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `J30_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0715μs25.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `J30_content`8.69ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `J30_content` SET `hits` = (`hits` + 1) WHERE `id` = '396'1.36ms48B/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 `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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.84ms24.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 `J30_categories` AS `s` INNER JOIN `J30_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`634μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `J30_contentitem_tag_map` AS `m` INNER JOIN `J30_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)1.8ms5.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 `J30_categories` AS `s` INNER JOIN `J30_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`759μs5.17KBParams/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 J30_fields AS a LEFT JOIN `J30_languages` AS l ON l.lang_code = a.language LEFT JOIN J30_users AS uc ON uc.id=a.checked_out LEFT JOIN J30_viewlevels AS ag ON ag.id = a.access LEFT JOIN J30_users AS ua ON ua.id = a.created_user_id LEFT JOIN J30_fields_groups AS g ON g.id = a.group_id LEFT JOIN `J30_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,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC4.59ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `J30_categories` AS `s` INNER JOIN `J30_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`838μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SHOW FULL COLUMNS FROM `J30_users`9.79ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `J30_users` WHERE `id` = :userid619μs4.41KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `J30_usergroups` AS `g` INNER JOIN `J30_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid581μs1.66KBParams/libraries/src/Table/User.php:134Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `J30_modules` AS `m` LEFT JOIN `J30_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `J30_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`1.54ms298.13KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `name`,`element` FROM `J30_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1410μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `J30_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)649μs11.95KB/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `J30_schemaorg` WHERE `itemId` = :itemId AND `context` = :context534μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)733μ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 `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)586μ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 `J30_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.13ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = ?187μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `J30_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.23ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy