­

Search

God offers to take our hurt and give us comfort. But he also asks us to pass that comfort on to others who are hurting
Duration:20 mins 34 secs

Give God your hurt and receive God’s healing

2 Corinthians 1:3-7

When my kids finished Primary school one of their favourite movies was Thunderpants. It’s the story of a boy named Patrick who has an unfortunately high capacity for flatulence and aspired to be an astronaut. It’s a laugh-out-loud kids’ comedy. But it also raised the opportunity for conversation with our kids about how to cope with the worst days of our lives.

At the end of each day, Patrick would declare aloud to the universe, “this has been the best day of my life… ever!” OR alternatively he would say, “this has been the worst day of my life… ever!”

We are exploring in this series promises of God to the “children” of God – if you give to God your blank, God will give to you blank. We’re not talking about an exchange that’s like a day-to-day commercial transaction. Instead, think of the gift exchanges you’ve witnessed over Christmas within families. At such gatherings, gifts are shared with those who are loved, accepted and assured of their place in the family. In a similar sense, the Bible presents a variety of gift exchanges for those adopted into God’s “family” by grace, through faith in Jesus Christ. We have assurance in Christ that God is eager to grant us gifts that bless. The Bible urges us to give and receive what God promises.
For example, last week we looked at the gift exchange of our worry and God’s peace. In today’s gift exchange, if we give God our hurt, our troubles, the Bible promises that God will eagerly grant us comfort and help.

Two caveats before I continue:

i. Firstly, I’m not talking here about why some people get healed when we pray, and others appear not to. That sermon is for another day.

ii. Secondly, I’m not talking about healing for long-term suffering from the likes of domestic violence, or military occupation, or terminal illness. These and similar conditions of life require professional care, advocacy, and compassionate support, not a sermon.

Instead, today I’m talking about when we face unexpected trouble on any ordinary day. You know those days in 2021 – you woke up, you set about your normal day, and then, at some point in that day you received very bad news:

• a tragedy in the family, a close friend’s marriage breakup, a loved one losing their job, and so on [you fill in the blank]. Or

• perhaps the calamity affected you personally - a bad prognosis from a medical test, an accident or injury, a love that was lost, or a failure at work that was your fault, or [you fill in the blank].

We’re talking about those days when even your coffee needed a coffee!

The Apostle Paul was no armchair expert on this topic. Check out Paul’s list of “worst days of his life …ever!” in 2 Corinthians 11:23-27. Paul writes…
I …[was] put in prison…, whipped times without number, and faced death again and again. Five different times [I received] …thirty-nine lashes. Three times I was beaten with rods. Once I was punished by stoning. Three times I was shipwrecked. Once I spent a whole night and a day adrift at sea … I have faced danger from rivers and from robbers. I have faced danger from my own people …as well as from [others]. I have faced danger in the cities, in the deserts, and on the seas. And I have faced danger from [those] who claim to be believers but are not. I have worked hard and long, enduring many sleepless nights. I have been hungry and thirsty and have often gone without food. I have shivered in the cold, without enough clothing to keep me warm. (2 Corinthians 11:23-27 NLT)

This undoubtedly Spirit-filled Christian knew what it meant to have many a bad day. That’s a lesson right there in itself for us all.

But more than this, earlier in the same Epistle Paul reveals how to get through our worst days through the gift God promises. Paul writes:

…God is our merciful Father and the source of all comfort. God comforts us in all our troubles so that we can comfort others. When they are troubled, we will be able to give them the same comfort God has given us. For the more we suffer for Christ, the more God will shower us with God’s comfort through Christ. Even when we are weighed down with troubles, it is for your comfort and salvation! For when we ourselves are comforted, we will certainly comfort you. Then you can patiently endure the same things we suffer. We are confident that as you share in our sufferings, you will also share in the comfort God gives us. (2 Corinthians 1:3-7 NLT)

1. Give God your trouble, receive God’s comfort

Paul says, give your troubles and hurt to God, and the God who comforts will be there in amidst your pain, your loneliness, your brokenness. Paul says, “When I hurt, I know the God who comforts”.

In fact, you’ll see the word “comfort” some 9 times in just 7 verses of Scripture! On any of the worst days of his own life, the darkest days, with the deepest valleys, he was able to get through because he worshipped the “God who comforts”.

Colin Kruse, in his commentary, points out the rare use of a single Greek word in verse 3 which appears to be like one of Paul’s names for God – “God, the comforter”. This should not surprise us since this is how Jesus spoke to his disciples about the Holy Spirit whom he would send to be with them.

For some of us, this is the hardest thing to imitate from Paul’s life –

i. Firstly, we don’t even think about God as “comforter” – we think of God as “almighty” as “judge” or “creator” or “Father”. Some of us approach God as a dispenser of solutions for various troubles. But Paul knows God as “Comforter”. That is, God’s presence with him is the comfort he needs.

ii. The second reason this is hard for us is that we find it difficult to “talk” to God in prayer. Paul wants us to give our trouble and hurt to God that we might receive comfort in exchange. We find it hard to be open with loved ones. They say, “How are you?” and we say, “I’m fine”! How will we be able to give over our hurt, our fear, even our anger, which God desires to take on board in exchange for blessings.

We must learn that prayer is relational, not transactional. We see this in the honest pouring out of emotions by the Psalmist. David often rails at God, cries to God, expresses fear and doubt to God. The New Testament urges us to boldly enter into the very presence of God through Christ, and to find grace and help in our time of need.
From a practical point of view, prayers to God can be practiced in a myriad of valid ways; we should not feel that our style of praying honestly and openly must comply with a certain tradition or church culture. For some, walking along a beach alone might be a good setting to openly “speak” with God and share our hurts, fears, and regrets. For others it may be kneeling in a cathedral, engaging in a form of Christian meditation, or closing the door of your own private space. Whether silent, sung or spoken, whether extemporary or formal or verses of Scripture, don’t be constricted. Instead, start to become familiar with prayer as a means of being relational with God, whom the Scriptures say, through Christ, we can address intimately.

We can give over our troubles and the hurt that comes with it, and God will be our comfort.

Australian journalist, Leigh Sales, wrote Any Ordinary Day – interviews with various people who were blindsided on just a normal day of their week by a terrible, unpredictable calamity.

Louisa Hope, survivor of the Lindt Café hostage siege in Sydney in 2014, blindsided the author. Sales, an agnostic herself, was blown away by how Hope’s humble faith in a crisis. “How did faith in God help you in that terrible moment?” Sales asked. Louisa, a Christian, spoke of how she prayed moment to moment and was able to look to the needs of others in the crisis. Hope said to Sales, “This is the reality of the grace of God. It’s indeed a mystery, but when one lives in relationship with God, that’s just part of how every day goes.”

You see, prior to the hostage crisis, Hope speaks of how she had been diagnosed with MS, turned 40, and been divorced by her husband.9 – Louisa had already learned to lean in on God’s comfort through prayer, and the help of her Christian community for many years.

Like the Apostle Paul, Louisa had come to know God as the God of “all” comfort – for all circumstances, all troubles, all trials.
We too can come know God, not as the fixer, but as “Comforter”. We too can learn to experience this gift exchange of our hurt for God’s divine comfort and help on our very bad days.

2. Give comfort to others, as we received from God

Did you notice that there are two gift exchanges in this passage of Scripture?

The second gift exchange (and the two go hand in hand) is that when God gives us comfort, we can give comfort to others.

God comforts us in all our troubles so that we can comfort others (2 Cor. 1:3)

When asked about life after the Lindt Cafe siege, Louisa Hope said: “…my life purpose [now] is to serve God by loving and bringing encouragement to people wherever I can...”

Today Louisa speaks to groups far and wide about her ordeal and her faith, including in our Common Grace network. She acknowledges the help and comfort her church community provided practically and spiritually. But most of all, she knows through what she’s learned that she can offer comfort to others who suffer bad days – even as bad as those she experienced.

Our Bible reading today encourages us in the same way. Give God your troubles, your hurt, and in exchange receive God’s comfort, God’s healing. But then, as receivers of God’s comfort, we can learn to be comforters to others who hurt. God wants to shape us into comfort-givers as a result of knowing God’s comfort.

In Romans 15:5 Paul writes:

Now may the God of patience and comfort grant you to be like-minded toward one another, according to Christ Jesus, that you may with one mind and one mouth glorify the God and Father of our Lord Jesus Christ.

Steve Webster St Michaels North Carlton January 2022
With acknowledgment to 
 Pastor Brandon A Cox for the series concept

Leave a reply

Submit
Powered by: Preachitsuite
­
7.866MBMemory Usage826msRequest Duration
Joomla! Version4.4.13
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:60 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "CONTENT_LEN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745700469 "last" => 1745700469...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
com_rsfirewall
array:1 [ "geoip" => array:1 [ "3.135.200.168" => "US" ] ]
plg_system_webauthn
array:1 [ "returnUrl" => "https://expopreaching.org.au/index.php/sermons-3/message/the-gift-exchan...
  • afterLoad (814.74KB) (50.63ms)
  • afterInitialise (2.47MB) (193ms)
  • afterRoute (648.88KB) (104ms)
  • beforeRenderComponent com_preachit (245.39KB) (62ms)
  • Before Access::preloadComponents (all components) (923.05KB) (152ms)
  • After Access::preloadComponents (all components) (122.96KB) (3.39ms)
  • Before Access::getAssetRules (id:439 name:com_preachit) (2.45KB) (28μs)
  • After Access::getAssetRules (id:439 name:com_preachit) (8.02KB) (936μs)
  • afterRenderComponent com_preachit (854.07KB) (117ms)
  • afterDispatch (108.42KB) (3.18ms)
  • beforeRenderRawModule mod_custom (Copyright) (160.94KB) (16.23ms)
  • afterRenderRawModule mod_custom (Copyright) (5.78KB) (2.31ms)
  • beforeRenderModule mod_custom (Copyright) (720B) (5μs)
  • afterRenderModule mod_custom (Copyright) (1.41KB) (304μs)
  • beforeRenderRawModule mod_custom (Terms and Conditions) (520B) (39μs)
  • afterRenderRawModule mod_custom (Terms and Conditions) (992B) (52μs)
  • beforeRenderModule mod_custom (Terms and Conditions) (720B) (3μs)
  • afterRenderModule mod_custom (Terms and Conditions) (2.5KB) (127μs)
  • beforeRenderRawModule mod_banners (Donate) (3.01KB) (33μs)
  • afterRenderRawModule mod_banners (Donate) (33.72KB) (26.53ms)
  • beforeRenderModule mod_banners (Donate) (704B) (7μs)
  • afterRenderModule mod_banners (Donate) (3.88KB) (400μs)
  • beforeRenderRawModule mod_login (Login Form) (1.34KB) (29μs)
  • afterRenderRawModule mod_login (Login Form) (185.59KB) (11.18ms)
  • beforeRenderModule mod_login (Login Form) (720B) (5μs)
  • afterRenderModule mod_login (Login Form) (9.91KB) (57μs)
  • beforeRenderRawModule mod_piadmin (Preachit - Admin Module) (5.16KB) (19μs)
  • afterRenderRawModule mod_piadmin (Preachit - Admin Module) (5.84KB) (678μs)
  • beforeRenderModule mod_piadmin (Preachit - Admin Module) (736B) (5μs)
  • afterRenderModule mod_piadmin (Preachit - Admin Module) (2.18KB) (43μs)
  • beforeRenderRawModule mod_piseries (Preachit - Series module) (7.77KB) (17μs)
  • afterRenderRawModule mod_piseries (Preachit - Series module) (55.52KB) (4.17ms)
  • beforeRenderModule mod_piseries (Preachit - Series module) (736B) (5μs)
  • afterRenderModule mod_piseries (Preachit - Series module) (7.45KB) (47μs)
  • beforeRenderRawModule mod_piteachers (Preachit - Teachers module) (3.27KB) (18μs)
  • afterRenderRawModule mod_piteachers (Preachit - Teachers module) (26.28KB) (5.6ms)
  • beforeRenderModule mod_piteachers (Preachit - Teachers module) (736B) (5μs)
  • afterRenderModule mod_piteachers (Preachit - Teachers module) (4.45KB) (46μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.83KB) (46μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.38KB) (1.6ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.23KB) (109μs)
  • beforeRenderRawModule mod_menu (RSJuno! Main Menu) (2.3KB) (37μs)
  • afterRenderRawModule mod_menu (RSJuno! Main Menu) (72.28KB) (30.67ms)
  • beforeRenderModule mod_menu (RSJuno! Main Menu) (720B) (6μs)
  • afterRenderModule mod_menu (RSJuno! Main Menu) (3.58KB) (229μs)
  • beforeRenderRawModule mod_finder (Search) (1.84KB) (46μs)
  • afterRenderRawModule mod_finder (Search) (139.12KB) (15.52ms)
  • beforeRenderModule mod_finder (Search) (704B) (9μs)
  • afterRenderModule mod_finder (Search) (3.51KB) (515μs)
  • afterRender (215.56KB) (22.87ms)
  • 1 x afterInitialise (2.47MB) (23.37%)
    193.01ms
    1 x Before Access::preloadComponents (all components) (923.05KB) (18.36%)
    151.63ms
    1 x afterRenderComponent com_preachit (854.07KB) (14.13%)
    116.66ms
    1 x afterRoute (648.88KB) (12.58%)
    103.91ms
    1 x beforeRenderComponent com_preachit (245.39KB) (7.51%)
    62.00ms
    1 x afterLoad (814.74KB) (6.13%)
    50.63ms
    1 x afterRenderRawModule mod_menu (RSJuno! Main Menu) (72.28KB) (3.71%)
    30.67ms
    1 x afterRenderRawModule mod_banners (Donate) (33.72KB) (3.21%)
    26.53ms
    1 x afterRender (215.56KB) (2.77%)
    22.87ms
    1 x beforeRenderRawModule mod_custom (Copyright) (160.94KB) (1.97%)
    16.23ms
    1 x afterRenderRawModule mod_finder (Search) (139.12KB) (1.88%)
    15.52ms
    1 x afterRenderRawModule mod_login (Login Form) (185.59KB) (1.35%)
    11.18ms
    1 x afterRenderRawModule mod_piteachers (Preachit - Teachers module) (26.28KB) (0.68%)
    5.60ms
    1 x afterRenderRawModule mod_piseries (Preachit - Series module) (55.52KB) (0.5%)
    4.17ms
    1 x After Access::preloadComponents (all components) (122.96KB) (0.41%)
    3.39ms
    1 x afterDispatch (108.42KB) (0.39%)
    3.18ms
    1 x afterRenderRawModule mod_custom (Copyright) (5.78KB) (0.28%)
    2.31ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.38KB) (0.19%)
    1.60ms
    1 x After Access::getAssetRules (id:439 name:com_preachit) (8.02KB) (0.11%)
    936μs
    1 x afterRenderRawModule mod_piadmin (Preachit - Admin Module) (5.84KB) (0.08%)
    678μs
    1 x afterRenderModule mod_finder (Search) (3.51KB) (0.06%)
    515μs
    1 x afterRenderModule mod_banners (Donate) (3.88KB) (0.05%)
    400μs
    1 x afterRenderModule mod_custom (Copyright) (1.41KB) (0.04%)
    304μs
    1 x afterRenderModule mod_menu (RSJuno! Main Menu) (3.58KB) (0.03%)
    229μs
    1 x afterRenderModule mod_custom (Terms and Conditions) (2.5KB) (0.02%)
    127μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.23KB) (0.01%)
    109μs
    1 x afterRenderModule mod_login (Login Form) (9.91KB) (0.01%)
    57μs
    1 x afterRenderRawModule mod_custom (Terms and Conditions) (992B) (0.01%)
    52μs
    1 x afterRenderModule mod_piseries (Preachit - Series module) (7.45KB) (0.01%)
    47μs
    1 x afterRenderModule mod_piteachers (Preachit - Teachers module) (4.45KB) (0.01%)
    46μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.83KB) (0.01%)
    46μs
    1 x beforeRenderRawModule mod_finder (Search) (1.84KB) (0.01%)
    46μs
    1 x afterRenderModule mod_piadmin (Preachit - Admin Module) (2.18KB) (0.01%)
    43μs
    1 x beforeRenderRawModule mod_custom (Terms and Conditions) (520B) (0%)
    39μs
    1 x beforeRenderRawModule mod_menu (RSJuno! Main Menu) (2.3KB) (0%)
    37μs
    1 x beforeRenderRawModule mod_banners (Donate) (3.01KB) (0%)
    33μs
    1 x beforeRenderRawModule mod_login (Login Form) (1.34KB) (0%)
    29μs
    1 x Before Access::getAssetRules (id:439 name:com_preachit) (2.45KB) (0%)
    28μs
    1 x beforeRenderRawModule mod_piadmin (Preachit - Admin Module) (5.16KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_piteachers (Preachit - Teachers module) (3.27KB) (0%)
    18μs
    1 x beforeRenderRawModule mod_piseries (Preachit - Series module) (7.77KB) (0%)
    17μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    9μs
    1 x beforeRenderModule mod_banners (Donate) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (RSJuno! Main Menu) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Copyright) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_login (Login Form) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_piadmin (Preachit - Admin Module) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_piseries (Preachit - Series module) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_piteachers (Preachit - Teachers module) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Terms and Conditions) (720B) (0%)
    3μs
76 statements were executed, 22 of which were duplicates, 54 unique169ms274.97KB
  • SELECT @@SESSION.sql_mode;191μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `nxhcq_session` WHERE `session_id` = ?678μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `nxhcq_session` WHERE `session_id` = :session_id LIMIT 1204μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `nxhcq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.62ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `nxhcq_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 12.53ms2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `nxhcq_viewlevels`808μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `nxhcq_usergroups` AS `a` LEFT JOIN `nxhcq_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest879μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `nxhcq_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.12ms4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM nxhcq_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'248μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM nxhcq_rsfirewall_hashes WHERE `type`='protect'799μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM nxhcq_rsfirewall_configuration476μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `nxhcq_rsfirewall_logs`10.81ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • 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 `nxhcq_menu` AS `m` LEFT JOIN `nxhcq_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`2.75ms20.92KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id` FROM `nxhcq_pistudies` WHERE `alias` = 'the-gift-exchange-hurt-for-healing';4.18ms856B/libraries/teweb/details/standard.php:386Copy
  • SELECT * FROM nxhcq_rsfirewall_hashes WHERE (`type`='4.4.13' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)259μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM nxhcq_rsfirewall_snapshots WHERE `type`='protect'396μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM nxhcq_rsfirewall_lists WHERE (`ip`='3.135.200.168' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'620μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM nxhcq_rsfirewall_lists WHERE (`ip`='3.135.200.168' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'672μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM nxhcq_rsfirewall_exceptions WHERE `published`='1'985μs2.06KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT * FROM `nxhcq_languages` WHERE `published` = 1 ORDER BY `ordering` ASC2.06ms2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `nxhcq_template_styles` AS `s` LEFT JOIN `nxhcq_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` = 1885μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pistudies`16.19ms3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_pistudies` WHERE `id` = '457'636μs45.5KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `nxhcq_tags` AS `t` INNER JOIN `nxhcq_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)3.59ms1.68KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `id` FROM `nxhcq_pitemplate` WHERE `def` = '1';724μs856B/components/com_preachit/helpers/additional.php:78Copy
  • SELECT `params` FROM `nxhcq_pitemplate` WHERE `id` = '1';352μs856B/components/com_preachit/helpers/additional.php:157Copy
  • SELECT `template` FROM `nxhcq_pitemplate` WHERE `id` = '1';1.31ms856B/components/com_preachit/helpers/additional.php:114Copy
  • SELECT `link` FROM `nxhcq_menu` WHERE `id` = '623';337μs856B/components/com_preachit/helpers/additional.php:479Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '47';525μs856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '47';217μs856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '0';532μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '0';314μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SHOW FULL COLUMNS FROM `nxhcq_piteachers`10.67ms13.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '10'1.74ms4.03KB/libraries/src/Table/Table.php:755Copy
  • SHOW FULL COLUMNS FROM `nxhcq_piseries`10.65ms2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_piseries` WHERE `id` = '44'1.22ms4.03KB/libraries/src/Table/Table.php:755Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pimediaplayers`11.92ms2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_pimediaplayers` WHERE `id` = '8'466μs2.28KB/libraries/src/Table/Table.php:755Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `nxhcq_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)1.76ms7.88KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `cssoverride` FROM `nxhcq_pitemplate` WHERE `id` = '1';255μs856B/components/com_preachit/helpers/additional.php:634Copy
  • SELECT `client_id` FROM `nxhcq_pitemplate` WHERE `id` = '1';179μs856B/components/com_preachit/helpers/additional.php:640Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '10'374μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM `nxhcq_piseries` WHERE `id` = '44'288μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '47';225μs856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '47';171μs856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '0';213μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '0';248μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `nxhcq_contentitem_tag_map` AS `m` INNER JOIN `nxhcq_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.18ms5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pishare`10.36ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_pishare` WHERE `id` = '1'431μs1.22KB/libraries/src/Table/Table.php:755Copy
  • SELECT COUNT(*) FROM nxhcq_pistudies WHERE asmedia =457653μs856B/components/com_preachit/helpers/info-builder.php:632Copy
  • SELECT count(*) FROM nxhcq_picomments WHERE study_id = '457' AND published = 1540μs856B/libraries/teweb/messages/comments.php:524Copy
  • SELECT * FROM `nxhcq_pishare` WHERE `id` = '1'230μs1.22KB/libraries/src/Table/Table.php:755Copy
  • 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 nxhcq_fields AS a LEFT JOIN `nxhcq_languages` AS l ON l.lang_code = a.language LEFT JOIN nxhcq_users AS uc ON uc.id=a.checked_out LEFT JOIN nxhcq_viewlevels AS ag ON ag.id = a.access LEFT JOIN nxhcq_users AS ua ON ua.id = a.created_user_id LEFT JOIN nxhcq_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC3.32ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '10'477μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '10'221μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pifilepath`13.2ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `server`,`folder`,`type`,`awsbucket`,`aws_region` FROM `nxhcq_pifilepath` WHERE `id` = '1'1.05ms1.06KB/libraries/teweb/file/urlbuilder.php:88Copy
  • SELECT * FROM `nxhcq_pistudies` WHERE `id` = '457'1.17ms37.5KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `nxhcq_tags` AS `t` INNER JOIN `nxhcq_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)1.5ms1.68KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT full_name, comment_date, comment_text FROM nxhcq_picomments WHERE study_id = '457' AND published = 1227μs960B/libraries/teweb/messages/comments.php:40Copy
  • 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 nxhcq_fields AS a LEFT JOIN `nxhcq_languages` AS l ON l.lang_code = a.language LEFT JOIN nxhcq_users AS uc ON uc.id=a.checked_out LEFT JOIN nxhcq_viewlevels AS ag ON ag.id = a.access LEFT JOIN nxhcq_users AS ua ON ua.id = a.created_user_id LEFT JOIN nxhcq_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC5.18ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `nxhcq_template_styles` WHERE `client_id` = 0 AND `home` = 1548μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `nxhcq_template_styles` WHERE `client_id` = 0 AND `home` = 1453μ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 `nxhcq_modules` AS `m` LEFT JOIN `nxhcq_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `nxhcq_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.61ms10.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `title` FROM `nxhcq_template_styles` WHERE `id` = '16'461μs856B/templates/rsjuno/classes/template.php:517Copy
  • SELECT * FROM `nxhcq_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)2.64ms7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `nxhcq_banners` AS `a` LEFT JOIN `nxhcq_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`cid` = :clientId AND `cl`.`state` = 1 AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 52.17ms2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `nxhcq_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)8.39ms856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • SELECT * FROM nxhcq_piseries WHERE (access IN (1,5) OR access = 0) AND language IN ('en-GB','*') AND published = 1 ORDER BY ordering ASC LIMIT 20590μs4.28KB/modules/mod_piseries/helper.php:95Copy
  • SELECT * FROM nxhcq_piteachers WHERE language IN ('en-GB','*') AND published = 1 AND teacher_view = 1 ORDER BY ordering ASC LIMIT 103.89ms4.17KB/modules/mod_piteachers/helper.php:72Copy
  • SELECT `name`,`element` FROM `nxhcq_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1459μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `nxhcq_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)1.34ms904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • 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 `nxhcq_scheduler_tasks` AS `a` WHERE `a`.`state` = 16.52ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `nxhcq_session` WHERE `session_id` = ?375μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `nxhcq_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.02ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy