­
Chris Appleby Ministries

Chris Appleby Ministries

 

Search

Chris Appleby's Photos

Living in the Now and Not Yet

audio

Romans 7:14-25

When John writes his first letter to the churches in Asia- minor he reminds them that God loves us so much that he’s made us his children; and then he says “3:2Beloved, we are God's children now; what we will be has not yet been revealed. What we do know is this: when he is revealed, we will be like him, for we will see him as he is. 3And all who have this hope in him purify themselves, just as he is pure.” In other words our future life has to shape our present life. If we’re to live with God in the future then we need to start learning to live now in a way that pleases God.

So how are you at living a god pleasing life? You don’t need to answer that out loud. Nor do you need to give yourself a score. But my guess is that if you’re like me you may regularly find yourself thinking back on something you’ve done and realising that you should have done the exact opposite if you wanted to please God? How often do you realise that you’re repeating those mistakes over and over again?  And if so, what do you do about it?

Here’s what happens to some people. They realise they have a problem with a particular behaviour that they know God won’t like, so they decide to do something about it. They read something like Romans 6 that we read a couple of weeks ago and they decide that from now on they’ll be slaves of right living. Or they read that verse in 1 John and decide they need to raise their level of purity of life. So whenever they feel tempted to disobey God they’ll resist. They remember God’s promise to provide a way of escape and they resolve to ask him to provide it next time they’re tempted. Except that the next time that happens they somehow forget to ask for that way out. They fall into the same thing they’ve been doing for years. And they can’t understand it. It’s like they have a split personality. It’s like there’s a war going on in their brain. One moment they’re winning the war and the next they’re failing. Does that sound familiar? Does it ring true in your experience? It’s apparently how Paul felt, often. It’s a major reason why he puts such an emphasis on the importance of grace for the Christian. He’s very much aware of how often we fail to live up to our hopes and aspirations to Godliness.

What he’s found in his own experience, with depending on following the law to prepare himself for eternal life, is that inevitably it leads to death, rather than life. You’ll see that in the first part of this chapter. He’s worked out that the law can never help us. On the contrary, turning to the law only gives an opportunity to our sinful natures to rebel and that rebellion then leads to death. Only living under grace can lead to life.
Is there something wrong with God’s law?

But then that conclusion leads him to ask whether there’s something wrong with the law. Did God make a mistake perhaps? Or was this just a bad joke by God on us humans? He says: “What then should we say? That the law is sin?” Is that why we need to escape from its power? Is that why we’re told not to rely on it? Because it just provides our weak human nature with a reason to rebel once again? His answer is “By no means!” It’s not the law that’s the problem. The problem isn’t the law but our own weakness.

Why is the law a problem for me?

Can you see why he spends so much time warning us about trying to following a set of rules that will make us right with God?  Why he tells us to forget the law and concentrate on grace? Well, he says, having a set of rules for life becomes a problem for me because all those rules do is show up my rebellious nature.

Back in Romans 5:13 Paul points out that sin had been in the world even before the law was given, but no-one recognised it until they had God’s law before them to highlight their failings. Now the problem is worse because when we’re told how to behave our natural human response is to want to do the opposite. He takes the example of covetousness. It’s a pretty good example because it’s one sin that everyone falls into from time to time. He suggests that covetousness wasn’t really a problem for us until we were told that it was wrong. But as soon as the law was given, sin began to produce all sorts of desires in the human heart. 

It might be that Paul is thinking here of the covetousness that was at the root of the first sin, by Adam and Eve. If you remember back to Genesis 3, the devil pointed out to Eve that the tree was good for food, was a delight to the eyes and was desired to make one wise. It would make them like God. But it was even more subtle than that. The mechanism that the devil used to tempt them was to distort the commandment of God. To make it sound like God’s commandment was meant to limit their freedom. He was trying to provoke in them a desire to rebel against God’s rightful authority; to convince them they needed to throw off the shackles of his authoritarian rule; to assert their right to choose what was good for them, what would please them. Never mind that God had provided everything they could ever need. Never mind that God had provided them with the tree of life that fruits all year round. This commandment of God was there to rebel against. And they fell for it. 

Now can you see that if there had been no commandment not to eat of the fruit of that tree there would have been nothing for Satan to tempt them with? There would have been no power in the temptation. The power of temptation comes from the idea that God’s law somehow limits us; that we’d be happier if we could have or do those things that he’s said no to. Notice that our whole economic system is built around that idea: of us being encouraged to see how we’re missing out; to want to have what successful people have; to want more than we have or even need; or to believe that we’d be happier if we could do certain things.  

So as he says, if the coming of the law is the means by which sin is roused in me, if it’s the trigger for my rebellious character to rise up, then, paradoxically, the law that was given, apparently, to bring life, actually brings death. This is the paradox of every religious system that seeks to instruct us in the way of godly living, in the way to God. In the end, our fallen human nature prevents us from doing what that system requires, no matter how good its law may be. In the end, as we read in v11, sin will deceive us. It’ll tell us that following our religious system will bring us salvation, or happiness, or closeness to God. It’ll tell us that if we just do the right thing, God will owe us; that our obedience will put God under obligation to us. You may have noticed how this sort of thinking has been weaponised in American politics of late.

Even if we avoid that mistake and simply take God’s law as a framework for living what we find in practice is that at the very moment that we reach out to grasp what we’re seeking, to reach the level of obedience to God that we desire, our failed human nature will trip us up. It’ll make us fail the very commandment we’re seeking to follow.

So then, why did God give us the law in the first place? If the law itself is good, as we’re told by God’s word, what’s good about it?

What is Good about the Law?

In v13 we discover that the law has one significant and vital purpose. Its good and right purpose is to show us where we go wrong, where we fall down, where we need to change. It’s all very well to say no-one knew about sin before the law came in but it was still a problem. Humanity was separated from God from the moment Adam and Eve were expelled from the garden. So it’s a good thing to be reminded that we have a way to go before we can meet the standards that God expects even if it doesn’t help us get there. 
And not only that: the law acts in our lives in such a way that our inability to reach God’s standards on our own becomes obvious and we’re driven back to our need for something beyond ourselves, to our need for grace. That’s where Paul goes in the passage we heard today, where he thinks about the way the law affects us.

How does the law affect me?

So how does the law affect me? How does the law help me to rely on God rather than on myself?
Now there’s been much discussion by theologians about who Paul is thinking of in these verses from 14-24. Is he talking about the Jew trying to obey the law? Is he talking about his own experience prior to becoming a Christian? Or is it his current experience? Or is he saying this is the experience of all Christians as they seek to obey God. Well, we haven’t got the time to go into the various arguments, but let me just say that I believe he’s talking about his own experience both as a Jew following the law to the letter and as a Christian, as an example of what every Christian experiences as they seek to live lives as slaves of righteousness. 

First he explains the problem. The law is actually a spiritual thing. To truly obey the law requires me to do so from the inmost heart, from the spirit. But I’m naturally unspiritual and I live in an unspiritual body. So I have a problem. I know what I want to do, but I can’t do it. In fact what I find is that over and over again I do the very things I hate. So what does that prove? 

The Law is Good

Well, it proves that deep down I believe that God’s law is good. The very fact that I hate being unable to consistently do the right thing means that I understand that the thing I’m aiming at is good.  

There is a war within me

But it also shows that there’s a duality at work within me. There are two forces warring with each other within me. In my inmost self I delight in God’s law. God’s Spirit who dwells within me has changed the way I see things. I no longer delight in wrongdoing. Rather I delight in the things the law requires. 

But at the same time I find that my old sinful body, the old me, continues to choose the wrong thing whenever I let it. And this is so frustrating. I know what’s right. I want to do it, but the moment I choose the right thing to do, evil lies close at hand, he says. In fact this is like a law within me, like the law of gravity. It’s as though I can’t choose to do something right without the possibility of wrongdoing being presented to me. It’s like my old self is so affected that whatever I do ends up crooked. It’s like you get out your favourite plane to smooth a piece of wood and discover that there’s a chip in the blade, so that no matter how hard you try, the wood never gets completely smooth. Or you get out the broom to sweep the floor and discover there’s a clump of bristles missing, so that no matter how much you sweep, there’s always a line of dirt left behind. 

And then you get into this spiral of frustration. You can hear it coming out as Paul recounts his own experience. The harder you try, the more you fail. The more you try to suppress your sinful nature the more it asserts itself. The more you try to give yourself over to the service of God, the more sin takes you captive. And in the end you feel like screaming, as Paul does: “24Wretched man that I am! Who will rescue me from this body of death?”

And so the law achieves its purpose. It drives us back to God. And the answer rings out as clearly as the plea: “25Thanks be to God through Jesus Christ our Lord!” 

The only answer to the plight of humanity is this: that Jesus Christ would rescue us from our own fallen nature; that God would give us his Holy Spirit to dwell within us and enable us to keep this spiritual law in our inmost hearts; that he might take our unspiritual bodies and transform them. In fact that he might give us new bodies and minds that’ll be able to serve him as he desires. That’s what we’ll see over the next couple of week as we look at Romans ch8 and life in the Spirit. God in his grace has provided a way that we can be right with him.

Only Jesus Christ and his Holy Spirit living within me can rescue me from this body of death. And that will be an ongoing struggle while ever I live in this old fallen body. But in the meantime even if my flesh remains enslaved to sin I’ll seek to be a slave to the law of God in my mind. And with God’s help in the end I will conquer. But that will probably have to wait until that day when Christ returns. 

Contact Details

Phone: 0422187127
 
­
9.45MBMemory Usage426msRequest Duration
Joomla! Version5.2.5
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" => 1743878037 "last" => 1743878037...
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.190.159.202" => "US" ] ]
  • afterLoad (95.33KB) (437μs)
  • afterInitialise (1.52MB) (37.14ms)
  • afterRoute (2.07MB) (47.32ms)
  • beforeRenderComponent com_content (175.05KB) (4.96ms)
  • Before Access::preloadComponents (all components) (135.37KB) (5.47ms)
  • After Access::preloadComponents (all components) (143.13KB) (3.8ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (13μs)
  • After Access::preloadPermissions (com_content) (153.71KB) (2.35ms)
  • Before Access::getAssetRules (id:372 name:com_content.article.691) (18.8KB) (19μs)
  • After Access::getAssetRules (id:372 name:com_content.article.691) (5.1KB) (689μs)
  • afterRenderComponent com_content (815.45KB) (155ms)
  • afterDispatch (109.03KB) (7.47ms)
  • beforeRenderRawModule mod_custom (footer) (509.86KB) (28.09ms)
  • afterRenderRawModule mod_custom (footer) (5.52KB) (2.19ms)
  • beforeRenderModule mod_custom (footer) (704B) (6μs)
  • afterRenderModule mod_custom (footer) (2.07KB) (745μs)
  • beforeRenderRawModule mod_banners (Dreamhost Banner) (5.06KB) (776μs)
  • afterRenderRawModule mod_banners (Dreamhost Banner) (109.8KB) (21.2ms)
  • beforeRenderModule mod_banners (Dreamhost Banner) (704B) (5μs)
  • afterRenderModule mod_banners (Dreamhost Banner) (4.13KB) (326μs)
  • beforeRenderRawModule mod_custom (Contact Details) (3.12KB) (966μs)
  • afterRenderRawModule mod_custom (Contact Details) (39.07KB) (2.66ms)
  • beforeRenderModule mod_custom (Contact Details) (720B) (5μs)
  • afterRenderModule mod_custom (Contact Details) (2.88KB) (59μs)
  • beforeRenderRawModule mod_addtoany (AddToAny Buttons) (22.04KB) (271μs)
  • afterRenderRawModule mod_addtoany (AddToAny Buttons) (4.85KB) (996μs)
  • beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (5μs)
  • afterRenderModule mod_addtoany (AddToAny Buttons) (2.75KB) (62μs)
  • beforeRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (8.1KB) (49μs)
  • afterRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (189.79KB) (19.08ms)
  • beforeRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (752B) (6μs)
  • afterRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (14.44KB) (86μs)
  • beforeRenderRawModule mod_menu (Main Menu) (16.62KB) (815μs)
  • afterRenderRawModule mod_menu (Main Menu) (1.7MB) (34.95ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (11μs)
  • afterRenderModule mod_menu (Main Menu) (47.4KB) (316μs)
  • beforeRenderRawModule mod_finder (Search) (67.62KB) (343μs)
  • afterRenderRawModule mod_finder (Search) (74.49KB) (14.82ms)
  • beforeRenderModule mod_finder (Search) (704B) (6μs)
  • afterRenderModule mod_finder (Search) (3.73KB) (284μs)
  • beforeRenderRawModule mod_custom (Chris Appleby Ministries) (20.43KB) (860μs)
  • afterRenderRawModule mod_custom (Chris Appleby Ministries) (1000B) (80μs)
  • beforeRenderModule mod_custom (Chris Appleby Ministries) (736B) (4μs)
  • afterRenderModule mod_custom (Chris Appleby Ministries) (2.75KB) (50μs)
  • afterRender (434.04KB) (31.59ms)
  • 1 x afterRenderComponent com_content (815.45KB) (36.27%)
    155ms
    1 x afterRoute (2.07MB) (11.1%)
    47.32ms
    1 x afterInitialise (1.52MB) (8.71%)
    37.14ms
    1 x afterRenderRawModule mod_menu (Main Menu) (1.7MB) (8.2%)
    34.95ms
    1 x afterRender (434.04KB) (7.41%)
    31.59ms
    1 x beforeRenderRawModule mod_custom (footer) (509.86KB) (6.59%)
    28.09ms
    1 x afterRenderRawModule mod_banners (Dreamhost Banner) (109.8KB) (4.97%)
    21.20ms
    1 x afterRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (189.79KB) (4.48%)
    19.08ms
    1 x afterRenderRawModule mod_finder (Search) (74.49KB) (3.48%)
    14.82ms
    1 x afterDispatch (109.03KB) (1.75%)
    7.47ms
    1 x Before Access::preloadComponents (all components) (135.37KB) (1.28%)
    5.47ms
    1 x beforeRenderComponent com_content (175.05KB) (1.16%)
    4.96ms
    1 x After Access::preloadComponents (all components) (143.13KB) (0.89%)
    3.80ms
    1 x afterRenderRawModule mod_custom (Contact Details) (39.07KB) (0.62%)
    2.66ms
    1 x After Access::preloadPermissions (com_content) (153.71KB) (0.55%)
    2.35ms
    1 x afterRenderRawModule mod_custom (footer) (5.52KB) (0.51%)
    2.19ms
    1 x afterRenderRawModule mod_addtoany (AddToAny Buttons) (4.85KB) (0.23%)
    996μs
    1 x beforeRenderRawModule mod_custom (Contact Details) (3.12KB) (0.23%)
    966μs
    1 x beforeRenderRawModule mod_custom (Chris Appleby Ministries) (20.43KB) (0.2%)
    860μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (16.62KB) (0.19%)
    815μs
    1 x beforeRenderRawModule mod_banners (Dreamhost Banner) (5.06KB) (0.18%)
    776μs
    1 x afterRenderModule mod_custom (footer) (2.07KB) (0.17%)
    745μs
    1 x After Access::getAssetRules (id:372 name:com_content.article.691) (5.1KB) (0.16%)
    689μs
    1 x afterLoad (95.33KB) (0.1%)
    437μs
    1 x beforeRenderRawModule mod_finder (Search) (67.62KB) (0.08%)
    343μs
    1 x afterRenderModule mod_banners (Dreamhost Banner) (4.13KB) (0.08%)
    326μs
    1 x afterRenderModule mod_menu (Main Menu) (47.4KB) (0.07%)
    316μs
    1 x afterRenderModule mod_finder (Search) (3.73KB) (0.07%)
    284μs
    1 x beforeRenderRawModule mod_addtoany (AddToAny Buttons) (22.04KB) (0.06%)
    271μs
    1 x afterRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (14.44KB) (0.02%)
    86μs
    1 x afterRenderRawModule mod_custom (Chris Appleby Ministries) (1000B) (0.02%)
    80μs
    1 x afterRenderModule mod_addtoany (AddToAny Buttons) (2.75KB) (0.01%)
    62μs
    1 x afterRenderModule mod_custom (Contact Details) (2.88KB) (0.01%)
    59μs
    1 x afterRenderModule mod_custom (Chris Appleby Ministries) (2.75KB) (0.01%)
    50μs
    1 x beforeRenderRawModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (8.1KB) (0.01%)
    49μs
    1 x Before Access::getAssetRules (id:372 name:com_content.article.691) (18.8KB) (0%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    13μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_rsmediagallery_responsive_slider (Chris Appleby's Photos) (752B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_banners (Dreamhost Banner) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Chris Appleby Ministries) (736B) (0%)
    4μs
44 statements were executed, 7 of which were duplicates, 37 unique91.64ms505.63KB
  • SELECT @@SESSION.sql_mode;334μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `J30_session` WHERE `session_id` = ?357μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = :session_id LIMIT 1304μ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.19ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `J30_viewlevels`228μ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` = :guest330μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `path` FROM J30_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'461μs840B/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM J30_rsfirewall_hashes WHERE `type`='protect'346μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM J30_rsfirewall_configuration433μs3.44KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `J30_rsfirewall_logs`10.09ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM J30_rsfirewall_hashes WHERE (`type`='5.2.5' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)422μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM J30_rsfirewall_snapshots WHERE `type`='protect'745μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='18.190.159.202' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'365μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='18.190.159.202' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'230μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM J30_rsfirewall_exceptions WHERE `published`='1'974μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT * FROM `J30_languages` WHERE `published` = 1 ORDER BY `ordering` ASC779μs2.22KB/libraries/src/Language/LanguageHelper.php:177Copy
  • 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.21ms10.63KBParams/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` = 0649μs25.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `J30_content`13.18ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `J30_content` SET `hits` = (`hits` + 1) WHERE `id` = '691'11.79ms48B/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)2.76ms24.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`1.16ms5.19KBParams/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)2.21ms5.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`1.13ms5.19KBParams/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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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.51ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `J30_users`14.69ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `J30_users` WHERE `id` = :userid776μ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` = :muserid1.44ms1.68KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `J30_template_styles` WHERE `client_id` = 0 AND `home` = 1960μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `J30_template_styles` WHERE `client_id` = 0 AND `home` = 1559μ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 `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`3.47ms298.13KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT * FROM `J30_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)587μs7.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 `J30_banners` AS `a` LEFT JOIN `J30_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`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 51.08ms13.91KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `J30_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)2.12ms856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • 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 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 ASC553μs5.27KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT DISTINCT(i.id), i.filename, i.title, i.url, i.description, i.params, i.hits, i.created, i.modified FROM J30_rsmediagallery_items i LEFT JOIN J30_rsmediagallery_tags t ON (i.id=t.item_id) WHERE i.published='1' AND (t.tag='Chris A' OR t.tag='Chris') ORDER BY i.ordering asc LIMIT 252.4ms2.27KB/administrator/components/com_rsmediagallery/helpers/helper.php:56Copy
  • SELECT `name`,`element` FROM `J30_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1489μ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)1.07ms968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `J30_schemaorg` WHERE `itemId` = :itemId AND `context` = :context439μ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 `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)821μ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)642μ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.71ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = ?224μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `J30_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.45ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy