­

What Would You Like to Know

Book Review: The Word of His Grace: A guide to teaching and preaching from Acts

By Chris Green. Leicester: Inter-Varsity, 2005, 978-84474-075-7,189pp., $A19.99, paper.

Many factors conspire against creating and sustaining an evangelistic culture in our Christian communities. In my experience, one of the key antidotes is the regular preaching and teaching of Acts. To this end, Chris Green, Vice-Principal of Oak Hill College in London has written an overview of the book specifically for the preacher, and this serves as a very helpful foundational tool.

This book is not a commentary. Green begins by outlining key principles for understanding Acts in toto, then in Section 2 breaks the book into 7 "panels", examining in more detail the themes conveyed. A particular strength in these two sections is Green's outlining of Luke's careful narrative structure, and the various narrative devices he uses, such as parallelism, escalation and contrast. Green is keen to show that Luke has not simply written a chronology, but has carefully structured his account with theological purpose. This exposes and highlights key truths and helps answer some of the recurring theological and pastoral issues raised by the book.


Green is always writing with the preacher in mind and his third section is comprised of 6 sample sermons. A fourth section contains an extended summative overview of the content of the gospel in Acts, and a synoptic discussion of 7 other major themes: Evangelism, Church planting, Discipling, Suffering, Prayer, Preaching, and Leadership.

Green argues that Jesus' promise to the disciples in Acts 1:8 "gives a fourfold pattern to the book" (15), with geographical markers that "tell a theological story too" (15): "a worldwide evangelistic message of the kingdom of God for today" (19). The ascended Jesus is continuing his work (30, 174), and the Holy Spirit's role "is to push the churches outwards into new missionary activity...This activity is focussed on telling people about Jesus" (26).

Green's focus on the word of God is a strength. He demonstrates how God's word is fulfilled and how it forms, teaches, disciplines, frees and encourages the first Christian communities. Green also argues that "Luke has an understanding that everyone is to be involved in the task of spreading the message; hence he deliberately puts centre stage in evangelism those whom we might think he has disqualified" (61) - Stephen and Phillip, elected as deacons to administer the distribution to the widows. Of fresh interest was Green's comparison of the Lord's passion with Paul's own determined, yet turbulent journey to Rome, arguing that the shipwreck story is "a kind of passion narrative" (114).

Although Green outlines well the narrative architecture in the expansion of the gospel, more could be made of the narrative elements in its climactic triumph on reaching Rome, the heart of the empire, despite the conspiring of Jew and Greek, storm, shipwreck and snake. Green states that the purpose of the final panel (chapters 22-28) is "to commend the reasonableness of the gospel" (113). Surely it is much more than this. God's word has triumphed in its extension, just as Jesus promised. Related to this, Green is unclear, and perhaps unfair, when he argues that "it would be an overstatement to say that we live in 'Acts 29'" (18) and that "we live, still, in Acts 1-28" (19). While in one sense an era is ended when the gospel reaches Rome, the expanding narrative structure of Acts clearly implies and expects that the gospel will continue out despite opposition. As such it ought to be normative for all Christians to participate in it. Participation in this dynamic expanding core work of God is exciting, though difficult. This is the work at God's heart, and we are in tune with God's purposes when we are fully in cooperation.

I would have preferred a clearer statement on the relationship in Acts between the three persons of the Trinity and the Word of God. Green initially argues that "if Acts has a hero at all, it is God" (10, also 97). But later he argues that "the real hero of the book of Acts is the word of God" (183). He also states that we must read "Acts as the continuing work of the risen and ascended Jesus" (30, also 42). And although Green notes that the key work of the Holy Spirit in Acts is "to push the churches outwards into new missionary activity" (26), one senses an unnecessary minimisation or defensiveness about the place and work of the Spirit.

The sermons are an excellent idea, but I found them variable. Green acknowledges that the sermons are "very condensed" and need "warming up" (116), with contextualisation, notably in their introductions for various audiences. But this means they read more as essay texts, rather than as oral texts. In particular, I did not feel Green's evident understanding of Luke's numerous narrative devices has carried over into the sermons' design and content. With regard to application, Green's view that "the Bible's world is our world" (119) and that "there is no great gap to be bridged, because God had this Sunday, this congregation and this sermon in mind when he inspired the original passage" (119) needs some nuancing. Nevertheless, the sermons contain useful and stimulating material and serve well as an early port of call in a reader's preparation.

A worthwhile addition to the preacher's library!

Adrian Lane is Lecturer in Ministry Skills and Church History at Ridley Melbourne.

­
13.462MBMemory Usage500msRequest Duration
Joomla! Version5.2.6
PHP Version8.1.31
Identityguest
Response200
Templatersjuno
Database
Server
mysql
Version
8.0.28-0ubuntu0.20.04.3
Collation
utf8_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "CONTENT_LEN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744798021 "last" => 1744798021...
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.117.114.128" => "US" ] ]
tpl_rsjuno
array:1 [ "queue" => array:5 [ "components/com_content.css" => true "modules/mod_finder.cs...
  • afterLoad (363.01KB) (47.63ms)
  • afterInitialise (2.76MB) (148ms)
  • afterRoute (2.32MB) (32.74ms)
  • beforeRenderComponent com_content (392.4KB) (21.24ms)
  • Before Access::preloadComponents (all components) (115.07KB) (8.94ms)
  • After Access::preloadComponents (all components) (126.38KB) (2.41ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (12μs)
  • After Access::preloadPermissions (com_content) (585.58KB) (3.05ms)
  • Before Access::getAssetRules (id:154 name:com_content.article.107) (34.8KB) (52μs)
  • After Access::getAssetRules (id:154 name:com_content.article.107) (8.63KB) (628μs)
  • afterRenderComponent com_content (980.04KB) (118ms)
  • afterDispatch (2.42KB) (217μs)
  • beforeRenderRawModule mod_custom (footer) (466.66KB) (21ms)
  • afterRenderRawModule mod_custom (footer) (5.38KB) (1.88ms)
  • beforeRenderModule mod_custom (footer) (704B) (5μs)
  • afterRenderModule mod_custom (footer) (4.66KB) (857μs)
  • beforeRenderRawModule mod_menu (Publications) (1.29KB) (47μs)
  • afterRenderRawModule mod_menu (Publications) (3.48MB) (15.79ms)
  • beforeRenderModule mod_menu (Publications) (720B) (7μs)
  • afterRenderModule mod_menu (Publications) (7.08KB) (308μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (51μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (70.43KB) (1.51ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (113μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (42μs)
  • afterRenderRawModule mod_menu (Main Menu) (542.87KB) (7.11ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (11.4KB) (221μs)
  • beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (43μs)
  • afterRenderRawModule mod_finder (What Would You Like to Know) (64.29KB) (12.24ms)
  • beforeRenderModule mod_finder (What Would You Like to Know) (736B) (5μs)
  • afterRenderModule mod_finder (What Would You Like to Know) (3.84KB) (277μs)
  • afterRender (391.89KB) (53.63ms)
  • 1 x afterInitialise (2.76MB) (29.66%)
    148ms
    1 x afterRenderComponent com_content (980.04KB) (23.6%)
    118ms
    1 x afterRender (391.89KB) (10.72%)
    53.63ms
    1 x afterLoad (363.01KB) (9.52%)
    47.63ms
    1 x afterRoute (2.32MB) (6.55%)
    32.74ms
    1 x beforeRenderComponent com_content (392.4KB) (4.25%)
    21.24ms
    1 x beforeRenderRawModule mod_custom (footer) (466.66KB) (4.2%)
    21.00ms
    1 x afterRenderRawModule mod_menu (Publications) (3.48MB) (3.16%)
    15.79ms
    1 x afterRenderRawModule mod_finder (What Would You Like to Know) (64.29KB) (2.45%)
    12.24ms
    1 x Before Access::preloadComponents (all components) (115.07KB) (1.79%)
    8.94ms
    1 x afterRenderRawModule mod_menu (Main Menu) (542.87KB) (1.42%)
    7.11ms
    1 x After Access::preloadPermissions (com_content) (585.58KB) (0.61%)
    3.05ms
    1 x After Access::preloadComponents (all components) (126.38KB) (0.48%)
    2.41ms
    1 x afterRenderRawModule mod_custom (footer) (5.38KB) (0.38%)
    1.88ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (70.43KB) (0.3%)
    1.51ms
    1 x afterRenderModule mod_custom (footer) (4.66KB) (0.17%)
    857μs
    1 x After Access::getAssetRules (id:154 name:com_content.article.107) (8.63KB) (0.13%)
    628μs
    1 x afterRenderModule mod_menu (Publications) (7.08KB) (0.06%)
    308μs
    1 x afterRenderModule mod_finder (What Would You Like to Know) (3.84KB) (0.06%)
    277μs
    1 x afterRenderModule mod_menu (Main Menu) (11.4KB) (0.04%)
    221μs
    1 x afterDispatch (2.42KB) (0.04%)
    217μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (0.02%)
    113μs
    1 x Before Access::getAssetRules (id:154 name:com_content.article.107) (34.8KB) (0.01%)
    52μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (0.01%)
    51μs
    1 x beforeRenderRawModule mod_menu (Publications) (1.29KB) (0.01%)
    47μs
    1 x beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (0.01%)
    43μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (0.01%)
    42μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    12μs
    1 x beforeRenderModule mod_menu (Publications) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (What Would You Like to Know) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    4μs
45 statements were executed, 5 of which were duplicates, 40 unique104ms1.1MB
  • SELECT @@SESSION.sql_mode;160μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `vax0y_session` WHERE `session_id` = ?990μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = :session_id LIMIT 1196μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `vax0y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.12ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `vax0y_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1542μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vax0y_viewlevels`212μs960B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `vax0y_usergroups` AS `a` LEFT JOIN `vax0y_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest561μs1.63KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `vax0y_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`1.62ms4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM vax0y_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'217μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM vax0y_rsfirewall_hashes WHERE `type`='protect'5.89ms840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM vax0y_rsfirewall_configuration332μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `vax0y_rsfirewall_logs`12.6ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT id FROM vax0y_yendifvideoshare_imports WHERE state = 1 AND next_import_date IS NOT NULL AND next_import_date != '0000-00-00 00:00:00' AND next_import_date <= '2025-04-16 10:07:01' LIMIT 1395μs840B/plugins/system/yendifvideoshare/yendifvideoshare.php:75Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `vax0y_menu` AS `m` LEFT JOIN `vax0y_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`10.87ms820.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM vax0y_rsfirewall_hashes WHERE (`type`='5.2.6' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)789μs1.14KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM vax0y_rsfirewall_snapshots WHERE `type`='protect'190μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.117.114.128' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'285μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.117.114.128' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'4.03ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM vax0y_rsfirewall_exceptions WHERE `published`='1'329μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT * FROM `vax0y_languages` WHERE `published` = 1 ORDER BY `ordering` ASC327μs2.22KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `vax0y_template_styles` AS `s` LEFT JOIN `vax0y_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1761μs17.16KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `vax0y_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)1.35ms8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `vax0y_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.58ms81.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `vax0y_content`17.04ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `vax0y_content` SET `hits` = (`hits` + 1) WHERE `id` = '107'1.68ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `vax0y_content` AS `a` INNER JOIN `vax0y_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vax0y_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vax0y_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vax0y_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vax0y_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)871μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `vax0y_categories` AS `s` INNER JOIN `vax0y_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`607μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `vax0y_contentitem_tag_map` AS `m` INNER JOIN `vax0y_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1)406μs5.2KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `vax0y_categories` AS `s` INNER JOIN `vax0y_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`639μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM vax0y_fields AS a LEFT JOIN `vax0y_languages` AS l ON l.lang_code = a.language LEFT JOIN vax0y_users AS uc ON uc.id=a.checked_out LEFT JOIN vax0y_viewlevels AS ag ON ag.id = a.access LEFT JOIN vax0y_users AS ua ON ua.id = a.created_user_id LEFT JOIN vax0y_fields_groups AS g ON g.id = a.group_id LEFT JOIN `vax0y_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC782μs5.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `vax0y_users`14.43ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_users` WHERE `id` = :userid267μs4.41KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `vax0y_usergroups` AS `g` INNER JOIN `vax0y_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid880μs12.7KBParams/libraries/src/Table/User.php:134Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `vax0y_modules` AS `m` LEFT JOIN `vax0y_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `vax0y_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.83ms35.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `vax0y_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1586μs992B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `vax0y_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)399μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `vax0y_schemaorg` WHERE `itemId` = :itemId AND `context` = :context985μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `vax0y_content` AS `a` INNER JOIN `vax0y_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vax0y_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vax0y_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vax0y_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vax0y_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)760μs24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `vax0y_content` AS `a` INNER JOIN `vax0y_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vax0y_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vax0y_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vax0y_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vax0y_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)639μs24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `vax0y_scheduler_tasks` AS `a` WHERE `a`.`state` = 1297μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `template` FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1299μs856B/plugins/system/rsmatias/helper.php:62Copy
  • SHOW FULL COLUMNS FROM `vax0y_template_styles`12.12ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `id` = '23'314μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = ?266μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vax0y_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.85ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy