­

Search

Sun, Sep 22, 2019

1 John 2:3-27 - Real or Fake

Here are 4 tests of the authenticity of your faith. Are you obeying God? Are you showing love to your Christian brother and sister? Are your values those of the Kingdom of God or those of the world? Are you sticking with the truth of the gospel?
Series:1 John
Duration:17 mins 43 secs

How do you spot a fake? You see a post on social media telling you about some new discovery, some whizz bang way of making money, or sure fire way of getting fit, being healthy, living longer, but how do you know if it’s real. How many times have you had a friend request on Facebook and realised that that person was already your friend? Steve sent out a text message last week saying be careful because someone was pretending to be him on email. We live in a world of fakes and sometimes it can be hard to recognise them from reality.

Well, clearly, from today’s reading, you don’t need to have Facebook to be faced with fakes. John writes to his friends to warn them about fake Christians and to help them be sure that they themselves are the real thing.

I’ve met people over the years who were not quite sure if they were up to the mark as Christians. They weren’t sure that they believed enough or understood enough or were faithful enough. And no doubt the people John was writing to here had similar worries. So he gives them four tests to apply to their lives to reassure them, but also to warn them about certain people who wished to lead them astray.

The Test of Christian obedience (2:3-6)

His first test is a simple one: do we obey his commandments? He says “whoever obeys his word, truly in this person the love of God has reached perfection.” Now clearly from what he’s just written he doesn’t actually expect us to have reached the level of perfection. He’s just written “8If we say that we have no sin, we deceive ourselves, and the truth is not in us.” (1 John 1:8) He seems to be saying two opposite things. It’s a bit like those proverbs that give you instructions that appear to be opposites. e.g. “4Do not answer fools according to their folly, or you will be a fool yourself. 5Answer fools according to their folly, or they will be wise in their own eyes.” (Proverbs 26:4-5) So what’s he thinking of here? I think what he’s saying is that the intention of our hearts is what matters. It’s those times when we voluntarily turn to follow Christ, to obey God’s commandments, that assure us of our place in God’s kingdom. So he talks about those who abide in God walking in his ways. That is, those who’ve placed their lives in God’s hands, who then choose to follow him.

You know, there are plenty of people who are only ever aware of their failings as Christians; who maybe feel they’re such a failure that they’ll never make it as a Christian. That’s what Satan will tell you.” “You might as well give up now.” “What a hypocrite!” he’ll say. “How can you call yourself a Christian?” But no, we mustn’t give up when we fail. John has just reminded us that if anyone sins, we have an advocate with the Father, Jesus Christ the righteous; and he is the atoning sacrifice for our sins. Sin is the universal Christian failing. As Paul tells us in Romans 7 we want to do what’s right, but in our weakness we end up doing wrong. So what will we focus on? Well, John says, focus on that desire of the heart to do what God wants. This is the sign that God has sent his Spirit to dwell within us. It’s what God promised through Jeremiah when he said (Jer 31:33) “This is the covenant that I will make with the house of Israel after those days, says the LORD: I will put my law within them, and I will write it on their hearts.” So the first sign of whether God has a place in our lives is this: it’s whether we have that inner desire, given by the Holy Spirit, to obey God’s words just as Jesus did. If we don’t, we can’t claim to know God, but if we do, if we’re seeking to walk as Jesus did, that is, in obedience to the Father, then we’ll know that God’s love is being made complete in us.

The Test of Christian Affections  (2:7-14)

The second test of our authenticity is the test of our affections. That is, how do we relate to our brothers and sisters? Do we love them or hate them. This is a primary sign, he says, of whether we’re walking in the light or the darkness. You see, there’s this paradigm shift that takes place with the coming of Jesus. That’s what he says in vs 7&8. In one sense this isn’t a new commandment. The command to love our neighbour has always been there. Right from the very beginning God’s law has been directed towards people showing love to others. That’s why Jesus could quote Lev 19:18 when asked about the greatest commandment. The OT law was an expression of the character and will of its giver, of the God of love. Paul, in Gal 5:14 says the entire law is summed up in this single command, “Love your neighbour as yourself.” Yet at the same time this is something new. Jesus said “A new commandment I give you.” Here John says (v. 8)  “Yet I am writing you a new commandment that is true in him and in you, because the darkness is passing away and the true light is already shining.” This is the sign of the new age. Jesus has driven a wedge into history. What before was the impossible dream has now become possible.

You know, people have always dreamed of living in a Utopia where people loved one another. Some have even tried to create such a society. But the darkness of sin in various forms has always prevented them from achieving their aims (Check out Utopian Communities online if you're interested). But now, in the Church, through Christ, it’s becoming possible. Do you see what he says? This is an amazing statement really: “I am writing you a new commandment that is true in him and in you.” Of course it was true in Jesus, but it’s also true in us! Why?  Because the darkness is passing away and the true light is already shining. The true light of the Kingdom of God has begun to shine into the world through us, God’s people, through the Church, as we show the love of Christ to each other. Isn’t that exciting? Have you ever thought of yourself as exhibiting the true light of Christ in the love you show to your Christian brothers and sisters? What a great incentive to love one another! And what a great gospel message that is! Churches have always been a collection of a broad variety of people, irrespective of class, education, ethnicity. Why? Because we accept and love each other without condition.

But notice how the converse applies. If you fail to love another believer you’re walking in darkness. You’ve lost your way. He says you’re blind.

Notice how he encourages the whole Christian community to think about this in vs 12-14. It doesn’t matter whether you’re young or old, in a position of authority or not, experienced or still growing. Each of us has something to thank God for. Each of us has experienced the love of God in different ways: All of us have had our sins forgiven. Those who are older have the advantage of years of getting to know God the Father. Those who are young have the strength of youth, the experience of overcoming the power of Satan fresh in their minds and the word of God alive in them. Perhaps what he means there is that there’s an enthusiasm about learning from God’s word that’s especially present in those who are new to the faith. And of course it’s the power of God’s word that enables us to be strong.

The Test of Christian values  2:15-17

The third test of our authenticity and perhaps, for us today, the hardest, is the test of our Christian values. He says: “Do not love the world or the things in the world. The love of the Father is not in those who love the world (v15)”. Now he isn’t talking here about some form of asceticism. He isn’t talking about denying the flesh in order to be more godly. That in fact was one of the false teachings of his time. Nor does he mean avoiding the world, escaping from it by some form of monasticism or by only ever associating with other Christians so you avoid any chance of being polluted by the world. No he isn’t talking about that. We need to be in the world so we can share the gospel. So what does he mean? What should we avoid? Well, he tells us, doesn’t he? “The desire of the flesh, the desire of the eyes, the pride in riches” That’s what he’s talking about. There’s a very 21st century feel about that isn’t there? He’s talking about the kind of worldliness that indulges the body: gluttony, greed, addictions of one sort or another, lust, covetousness. He’s talking about the way we love to indulge our aesthetic side. The way some people will give anything to possess a great painting or even a rare stamp. The way some people are obsessed with how their house looks, or their garden, or their car. With the way some people will spend hours in the gym or the beauty parlour sculpting their body to perfection. He’s talking about the kind of worldliness that boasts about its wealth, that prides itself in the possession of status symbols. (Have you ordered the iPhone 11 Pro yet?)

In other words the sort of worldliness he’s talking about is the sort that’s focussed on satisfying ‘me’. That puts ‘me’ at the centre of the universe rather than God. But the futility of this way of life is this: It seeks to accumulate things from this world, but in the end the things of this world, even the desires we have in this world, will pass away, and all that’ll be left will be God and those who are his, i.e. those who seek to do his will. (v17).

The Test of Christian faithfulness (2:18-23)

Finally, the fourth test of our authenticity is the test of Christian faithfulness. He says, “You have heard that antichrist is coming, so now many antichrists have come. From this we know that it is the last hour.” It isn’t easy to be a Christian in the last days. There are people all around trying to convince us that they have a new truth, whether it’s the Mormons, or the JWs knocking on our doors, or those so-called Progressive Christians with a liberal theology who’ll question whether Jesus really rose from the dead, or whether he really did the miracles that the gospels report: people who’ve accepted the fake news that our understanding of science rules out the belief in miracles or the supernatural and certainly of the bodily resurrection of Jesus. There are all sorts of beliefs being bandied around as alternatives to Christianity. And you’ll find that people will believe them. G.K. Chesterton once wrote, ‘When people abandon the truth, they don’t believe in nothing, they believe in anything.’ The great danger for the Christian Church today isn’t scepticism or atheism, it’s gullibility. It’s the willingness to believe the claims of new age sects, of pseudo sciences, or the modern superstitious beliefs that people cling to rather than accepting the gospel. And notice that the ones he describes as antichrists have gone out from the very membership of the Church. Sadly these former believers now deny that Jesus is the Christ, in effect denying both the Father and the Son. I find it very sad when I meet or hear Christian leaders in particular, who deny the divinity of Christ; who are happy to believe in his humanity, but can’t accept his deity.

But don’t let them deceive you, he says. You’ve been anointed by the Holy one. That is, you’ve received the Holy Spirit, the Spirit of truth. So stick with the truth which you heard from the beginning, which he’s placed in your heart. That is, the truth about Jesus Christ, truly human and truly divine. If that truth remains in you, you will remain in the Son and in the Father.

So here are 4 tests of the authenticity of your faith. Are you obeying God? Is your heart prompting you to obey him and to turn to him for forgiveness when you fail? Are you showing love to your Christian brother and sister? Even to those you find unlovable? Is that love of God shining out in your life as you interact with non-Christians you come into contact with? Are your values those of the Kingdom of God or those of the world? Are you sticking with the truth of the gospel? Is your heart set on God and the things he promises or are you being swayed by the imaginings of human minds? Those are questions we could well ask ourselves every day. Why? So we will continue in fellowship with one another and with the Father, and so we’ll have confidence that we do indeed have eternal life.

And let’s not miss the final encouragement of the passage:

“But as his anointing teaches you about all things, and is true and is not a lie, and just as it has taught you, abide in him.”

Leave a reply

Submit
Powered by: Preachitsuite
­
7.743MBMemory Usage861msRequest 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" => 1745557012 "last" => 1745557012...
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.143.246.80" => "US" ] ]
  • afterLoad (814.9KB) (54.06ms)
  • afterInitialise (2.47MB) (197ms)
  • afterRoute (648.88KB) (117ms)
  • beforeRenderComponent com_preachit (244.63KB) (25.5ms)
  • Before Access::preloadComponents (all components) (928.25KB) (138ms)
  • After Access::preloadComponents (all components) (122.96KB) (5.48ms)
  • Before Access::getAssetRules (id:439 name:com_preachit) (2.45KB) (19μs)
  • After Access::getAssetRules (id:439 name:com_preachit) (8.02KB) (668μs)
  • afterRenderComponent com_preachit (864.45KB) (176ms)
  • afterDispatch (108.42KB) (2.02ms)
  • beforeRenderRawModule mod_custom (Copyright) (158.77KB) (18.93ms)
  • afterRenderRawModule mod_custom (Copyright) (5.78KB) (2.19ms)
  • beforeRenderModule mod_custom (Copyright) (720B) (6μs)
  • afterRenderModule mod_custom (Copyright) (1.41KB) (313μs)
  • beforeRenderRawModule mod_custom (Terms and Conditions) (520B) (37μs)
  • afterRenderRawModule mod_custom (Terms and Conditions) (992B) (49μs)
  • beforeRenderModule mod_custom (Terms and Conditions) (720B) (3μs)
  • afterRenderModule mod_custom (Terms and Conditions) (2.5KB) (102μs)
  • beforeRenderRawModule mod_banners (Donate) (3.01KB) (32μs)
  • afterRenderRawModule mod_banners (Donate) (33.72KB) (21.49ms)
  • beforeRenderModule mod_banners (Donate) (704B) (7μs)
  • afterRenderModule mod_banners (Donate) (3.88KB) (401μs)
  • beforeRenderRawModule mod_piadmin (Preachit - Admin Module) (2.57KB) (24μs)
  • afterRenderRawModule mod_piadmin (Preachit - Admin Module) (5.84KB) (854μs)
  • beforeRenderModule mod_piadmin (Preachit - Admin Module) (736B) (5μs)
  • afterRenderModule mod_piadmin (Preachit - Admin Module) (2.18KB) (53μs)
  • beforeRenderRawModule mod_piseries (Preachit - Series module) (488B) (17μs)
  • afterRenderRawModule mod_piseries (Preachit - Series module) (55.61KB) (4.08ms)
  • beforeRenderModule mod_piseries (Preachit - Series module) (736B) (8μs)
  • afterRenderModule mod_piseries (Preachit - Series module) (5.95KB) (88μs)
  • beforeRenderRawModule mod_piteachers (Preachit - Teachers module) (5.77KB) (26μs)
  • afterRenderRawModule mod_piteachers (Preachit - Teachers module) (90.89KB) (4.88ms)
  • beforeRenderModule mod_piteachers (Preachit - Teachers module) (736B) (7μs)
  • afterRenderModule mod_piteachers (Preachit - Teachers module) (6.95KB) (85μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.83KB) (57μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.57KB) (2.51ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.23KB) (345μs)
  • beforeRenderRawModule mod_menu (RSJuno! Main Menu) (2.3KB) (57μs)
  • afterRenderRawModule mod_menu (RSJuno! Main Menu) (138.15KB) (11.33ms)
  • beforeRenderModule mod_menu (RSJuno! Main Menu) (720B) (7μs)
  • afterRenderModule mod_menu (RSJuno! Main Menu) (3.58KB) (773μs)
  • beforeRenderRawModule mod_finder (Search) (1.84KB) (54μs)
  • afterRenderRawModule mod_finder (Search) (76.2KB) (56.67ms)
  • beforeRenderModule mod_finder (Search) (704B) (7μs)
  • afterRenderModule mod_finder (Search) (3.51KB) (536μs)
  • afterRender (205.26KB) (18.12ms)
  • 1 x afterInitialise (2.47MB) (22.85%)
    196.73ms
    1 x afterRenderComponent com_preachit (864.45KB) (20.43%)
    175.88ms
    1 x Before Access::preloadComponents (all components) (928.25KB) (16.08%)
    138.39ms
    1 x afterRoute (648.88KB) (13.58%)
    116.88ms
    1 x afterRenderRawModule mod_finder (Search) (76.2KB) (6.58%)
    56.67ms
    1 x afterLoad (814.9KB) (6.28%)
    54.06ms
    1 x beforeRenderComponent com_preachit (244.63KB) (2.96%)
    25.50ms
    1 x afterRenderRawModule mod_banners (Donate) (33.72KB) (2.5%)
    21.49ms
    1 x beforeRenderRawModule mod_custom (Copyright) (158.77KB) (2.2%)
    18.93ms
    1 x afterRender (205.26KB) (2.11%)
    18.12ms
    1 x afterRenderRawModule mod_menu (RSJuno! Main Menu) (138.15KB) (1.32%)
    11.33ms
    1 x After Access::preloadComponents (all components) (122.96KB) (0.64%)
    5.48ms
    1 x afterRenderRawModule mod_piteachers (Preachit - Teachers module) (90.89KB) (0.57%)
    4.88ms
    1 x afterRenderRawModule mod_piseries (Preachit - Series module) (55.61KB) (0.47%)
    4.08ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.57KB) (0.29%)
    2.51ms
    1 x afterRenderRawModule mod_custom (Copyright) (5.78KB) (0.25%)
    2.19ms
    1 x afterDispatch (108.42KB) (0.23%)
    2.02ms
    1 x afterRenderRawModule mod_piadmin (Preachit - Admin Module) (5.84KB) (0.1%)
    854μs
    1 x afterRenderModule mod_menu (RSJuno! Main Menu) (3.58KB) (0.09%)
    773μs
    1 x After Access::getAssetRules (id:439 name:com_preachit) (8.02KB) (0.08%)
    668μs
    1 x afterRenderModule mod_finder (Search) (3.51KB) (0.06%)
    536μs
    1 x afterRenderModule mod_banners (Donate) (3.88KB) (0.05%)
    401μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.23KB) (0.04%)
    345μs
    1 x afterRenderModule mod_custom (Copyright) (1.41KB) (0.04%)
    313μs
    1 x afterRenderModule mod_custom (Terms and Conditions) (2.5KB) (0.01%)
    102μs
    1 x afterRenderModule mod_piseries (Preachit - Series module) (5.95KB) (0.01%)
    88μs
    1 x afterRenderModule mod_piteachers (Preachit - Teachers module) (6.95KB) (0.01%)
    85μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.83KB) (0.01%)
    57μs
    1 x beforeRenderRawModule mod_menu (RSJuno! Main Menu) (2.3KB) (0.01%)
    57μs
    1 x beforeRenderRawModule mod_finder (Search) (1.84KB) (0.01%)
    54μs
    1 x afterRenderModule mod_piadmin (Preachit - Admin Module) (2.18KB) (0.01%)
    53μs
    1 x afterRenderRawModule mod_custom (Terms and Conditions) (992B) (0.01%)
    49μs
    1 x beforeRenderRawModule mod_custom (Terms and Conditions) (520B) (0%)
    37μs
    1 x beforeRenderRawModule mod_banners (Donate) (3.01KB) (0%)
    32μs
    1 x beforeRenderRawModule mod_piteachers (Preachit - Teachers module) (5.77KB) (0%)
    26μs
    1 x beforeRenderRawModule mod_piadmin (Preachit - Admin Module) (2.57KB) (0%)
    24μs
    1 x Before Access::getAssetRules (id:439 name:com_preachit) (2.45KB) (0%)
    19μs
    1 x beforeRenderRawModule mod_piseries (Preachit - Series module) (488B) (0%)
    17μs
    1 x beforeRenderModule mod_piseries (Preachit - Series module) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_banners (Donate) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_piteachers (Preachit - Teachers module) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (RSJuno! Main Menu) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Copyright) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_piadmin (Preachit - Admin Module) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Terms and Conditions) (720B) (0%)
    3μs
76 statements were executed, 22 of which were duplicates, 54 unique181ms275.03KB
  • SELECT @@SESSION.sql_mode;252μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `nxhcq_session` WHERE `session_id` = ?314μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `nxhcq_session` WHERE `session_id` = :session_id LIMIT 1885μ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.33ms944BParams/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` = 1703μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `nxhcq_viewlevels`441μ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` = :guest1.37ms1.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.59ms4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM nxhcq_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'260μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM nxhcq_rsfirewall_hashes WHERE `type`='protect'832μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM nxhcq_rsfirewall_configuration365μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `nxhcq_rsfirewall_logs`10.45ms2.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.26ms20.92KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id` FROM `nxhcq_pistudies` WHERE `alias` = '1-john-2-3-27-real-or-fake';3.92ms856B/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)225μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM nxhcq_rsfirewall_snapshots WHERE `type`='protect'404μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM nxhcq_rsfirewall_lists WHERE (`ip`='3.143.246.80' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'451μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM nxhcq_rsfirewall_lists WHERE (`ip`='3.143.246.80' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'371μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM nxhcq_rsfirewall_exceptions WHERE `published`='1'384μs2.06KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT * FROM `nxhcq_languages` WHERE `published` = 1 ORDER BY `ordering` ASC365μs2.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` = 1777μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pistudies`17.33ms3.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_pistudies` WHERE `id` = '33'949μ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)545μs1.71KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `id` FROM `nxhcq_pitemplate` WHERE `def` = '1';265μs856B/components/com_preachit/helpers/additional.php:78Copy
  • SELECT `params` FROM `nxhcq_pitemplate` WHERE `id` = '1';251μs856B/components/com_preachit/helpers/additional.php:157Copy
  • SELECT `template` FROM `nxhcq_pitemplate` WHERE `id` = '1';169μs856B/components/com_preachit/helpers/additional.php:114Copy
  • SELECT `link` FROM `nxhcq_menu` WHERE `id` = '624';235μs856B/components/com_preachit/helpers/additional.php:479Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '62';833μs856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '62';1.29ms856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '0';160μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '0';162μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SHOW FULL COLUMNS FROM `nxhcq_piteachers`14.37ms13.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '1'1.97ms4.03KB/libraries/src/Table/Table.php:755Copy
  • SHOW FULL COLUMNS FROM `nxhcq_piseries`9.89ms2.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_piseries` WHERE `id` = '7'1.14ms4.03KB/libraries/src/Table/Table.php:755Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pimediaplayers`10.34ms2.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_pimediaplayers` WHERE `id` = '8'1.17ms2.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)2.64ms7.88KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `cssoverride` FROM `nxhcq_pitemplate` WHERE `id` = '1';376μs856B/components/com_preachit/helpers/additional.php:634Copy
  • SELECT `client_id` FROM `nxhcq_pitemplate` WHERE `id` = '1';188μs856B/components/com_preachit/helpers/additional.php:640Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '1'682μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM `nxhcq_piseries` WHERE `id` = '7'621μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '62';1.56ms856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '62';446μs856B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `display_name` FROM `nxhcq_pibooks` WHERE `id` = '0';296μs840B/components/com_preachit/helpers/scripture.php:323Copy
  • SELECT `book_name` FROM `nxhcq_pibooks` WHERE `id` = '0';149μ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.36ms5.3KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pishare`21.67ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `nxhcq_pishare` WHERE `id` = '1'673μs1.22KB/libraries/src/Table/Table.php:755Copy
  • SELECT COUNT(*) FROM nxhcq_pistudies WHERE asmedia =33482μs856B/components/com_preachit/helpers/info-builder.php:632Copy
  • SELECT count(*) FROM nxhcq_picomments WHERE study_id = '33' AND published = 11.14ms856B/libraries/teweb/messages/comments.php:524Copy
  • SELECT * FROM `nxhcq_pishare` WHERE `id` = '1'317μ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 ASC6.24ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '1'567μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SELECT * FROM `nxhcq_piteachers` WHERE `id` = '1'606μs4.03KB/libraries/src/Table/Table.php:755Copy
  • SHOW FULL COLUMNS FROM `nxhcq_pifilepath`23.07ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `server`,`folder`,`type`,`awsbucket`,`aws_region` FROM `nxhcq_pifilepath` WHERE `id` = '1'2.74ms1.06KB/libraries/teweb/file/urlbuilder.php:88Copy
  • SELECT * FROM `nxhcq_pistudies` WHERE `id` = '33'1.35ms37.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)977μs1.71KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT full_name, comment_date, comment_text FROM nxhcq_picomments WHERE study_id = '33' AND published = 13.89ms960B/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 ASC1.08ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `nxhcq_template_styles` WHERE `client_id` = 0 AND `home` = 1459μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `nxhcq_template_styles` WHERE `client_id` = 0 AND `home` = 1267μ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`2.66ms10.28KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `title` FROM `nxhcq_template_styles` WHERE `id` = '16'212μ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)3.12ms7.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 51.97ms2.92KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `nxhcq_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)2.99ms856BParams/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 20584μ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 101.93ms4.17KB/modules/mod_piteachers/helper.php:72Copy
  • SELECT `name`,`element` FROM `nxhcq_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1579μ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)471μs904B/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` = 11.4ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `nxhcq_session` WHERE `session_id` = ?240μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `nxhcq_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.85ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy