­

What Would You Like to Know

A Doubter’s Guide to the Bible: Inside History’s Bestseller for Believers and Skeptics Dickson A Doubter’s Guide to the Bible
By John Dickson
Zondervan, 2015

Reviewed by Bishop Tim Harris
Tim Harris is Assistant Bishop in Adelaide.

Let me say at the outset that I think this is a terrific book. It is written in winsome style with candour, clarity and character. Even more impressively, it achieves a depth of thought and engagement that is particularly challenging to attain when writing a primer genre of book. It will stimulate and provoke many of the right sorts of questions for those genuinely seeking to understand the Bible’s great narrative and the worldview it reflects.

In many ways, I am the wrong person to review this book. I would love to hear feedback and reflections from the book’s intended audience. I know well the theological framework Dickson articulates, a biblical theology framework that comes with an extensive and sophisticated in-house terminology and short hand. The extent to which John has successfully stepped outside this and employed accessible language and explanations is for others to determine, but my impression is that he has made an excellent attempt to do so.

Firstly, a brief overview. The chapter titles pretty much flag Dickson’s narrative approach: How everything is good (the creation story); Why so much is bad (Adam’s story and ours); Life in three dimensions (the blessings of Father Abraham); The good life (Moses and his law); Justice for all (The violence of Joshua and the love of God); Kingdom come (the promise and failure of King David); Hope against hope (the Christmas story); The wait is over (almost): (Jesus and his gospel); The great work (the “Church” after Jesus); and finally, How everything is good again (the re-creation story). Those familiar with paradigmic biblical theology (as with Graeme Goldsworthy, Gospel and Kingdom, and many others) will quickly recognise the contours of this narrative.

A good many sections stand out as particularly well-presented. The literary character of Genesis 1 as a type of prose-poetic ode, located in the world of ancient near eastern creation narratives, is expressed with clarity and sufficient reference to other ancient texts without overdoing things. Similarly, the explanation of ‘the tree of determination of good and evil’ (39) is very well handled.

Interwoven through all this is an effective selection of citations, giving candid expression to challenges relating to many passages, together with some pertinent quotes which speak profoundly (and concisely) into such debates. Dickson reads widely, and is abreast of many contemporary contributions for and against sceptical arguments.

Something I especially appreciate is the fairness Dickson demonstrates in hearing and presenting alternative views. I didn’t detect any proverbial straw men in this regard, but a respect for questions and challenges where they have something to say (the use of the scathing West Wing exchange in the words of (fictional) President Jed Bartlett regarding Old Testament law codes and homosexuality is but one stand out example, 81-82).

The chapter on Abraham is excellent. As Dickson notes, an understanding of the promises to Abraham and God’s work in reversing the damage of prolific sin in and through Abraham and his family is absolutely vital to perceiving the greater biblical narrative. Dickson’s explanation of the Abrahamic promises in the context of contemporary hopes, desires and dreams just nails it.

As one would hope, the stand out chapter is the one concerning Jesus and the gospel. These types of chapters are deceptively difficult to write; what to include, what to leave to one side, which debates to comment upon. I think Dickson gets the balance pretty much right (with justifiable cross reference to his more historically orientated books for more detail). Especially engaging is the ‘Crib Notes to the Gospel’, 161-171), with a wonderfully succinct overview of Jesus’ teaching on the Kingdom, miracles, discipleship, the cross and resurrection (although a pity the ascension seems to have been largely left out).

You may have noticed my review to this point has been singularly positive! Are there points at which I might offer a stronger critique? Well, a few. Along with a few other reviewers, I think Dickson tiptoes around the Six-Day Creationists just a little too much. Better to name and articulate a position (as Dickson does well), without the need to anticipate the reactions from one particular quarter. Other groups will react critically at other points, so why single out one perspective to critique quite so guardedly? However, this is a minor quibble.

Notwithstanding the undoubted strengths of this book, it did read as being shaped around the author’s particular agenda, and less around questions a sceptical reader might raise when trying to read scripture on its own terms. For instance, some introduction regarding the languages of the Bible would be helpful, and also the nature of the biblical canon as a mini-library in a book, written and compiled over a considerable period of time and reflecting a diversity of authors, styles and even personalities. Dickson emphasises the greater narrative development and coherence of Scripture, but others would be struck by its diversity.

More particular questions are absent, such as what to make of the large numbers encountered at various points (e.g. the ages of various figures in Genesis, and the population numbers in Numbers etc.), which some readers view with some scepticism). The chapter on Joshua, touching on holy war and the judgement of God upon the Canaanites, explains some elements (judgement arises out of God’s love and righteousness), but doesn’t address why innocent individuals are caught up in corporate acts of judgement – again, a common question from readers troubled by these passages.

Other questions curious readers might wonder about regarding the four Gospels might have been addressed, even if only briefly: what are we to make of the relationship between Matthew, Mark and Luke, and where does John’s Gospel fit in?

Having noted the above, I want to affirm the clarity of all that is addressed, and my admiration for Dickson’s self-discipline as an author in not trying to cram in too much in a book of this nature. The ‘crib notes’ summary of the apostles’ teaching (189-199) is a great case in point. So much more might have been added (I would have liked to see some reference to the game-changing role of the Holy Spirit in transforming the believer’s mindset, e.g. Romans 8:1-11), but Dickson otherwise maintains admirable restraint and keeps on task with the major narrative.

The final chapter draws various threads together, most importantly the biblical movement from creation to new creation. A measure of good writing is the capacity to finish well, and Dickson again delivers, highlighting the Bible’s relevance to the big questions of life and its diverse experiences, blended with some very poignant personal anecdotes and reflections.

John Dickson is to be commended in providing a great resource shaped effectively for its intended audience. I hope thought will be given to developing small group resources to accompany this, or even some bite-sized video clips.

­
13.504MBMemory Usage693msRequest 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" => 1744024998 "last" => 1744024998...
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 [ "3.19.239.158" => "US" ] ]
  • afterLoad (363.2KB) (47.74ms)
  • afterInitialise (2.76MB) (165ms)
  • afterRoute (2.32MB) (68.15ms)
  • beforeRenderComponent com_content (393.63KB) (21.19ms)
  • Before Access::preloadComponents (all components) (115.07KB) (9.06ms)
  • After Access::preloadComponents (all components) (126.38KB) (1.48ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (13μs)
  • After Access::preloadPermissions (com_content) (585.58KB) (2.42ms)
  • Before Access::getAssetRules (id:686 name:com_content.article.563) (34.8KB) (54μs)
  • After Access::getAssetRules (id:686 name:com_content.article.563) (8.63KB) (1.64ms)
  • afterRenderComponent com_content (992.37KB) (154ms)
  • afterDispatch (13.31KB) (6.99ms)
  • beforeRenderRawModule mod_custom (footer) (463.06KB) (19.7ms)
  • afterRenderRawModule mod_custom (footer) (5.38KB) (2.12ms)
  • beforeRenderModule mod_custom (footer) (704B) (6μs)
  • afterRenderModule mod_custom (footer) (4.66KB) (861μs)
  • beforeRenderRawModule mod_menu (Publications) (1.29KB) (48μs)
  • afterRenderRawModule mod_menu (Publications) (3.51MB) (55.32ms)
  • beforeRenderModule mod_menu (Publications) (720B) (8μs)
  • afterRenderModule mod_menu (Publications) (11.08KB) (548μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (67μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.43KB) (2.14ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (264μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (50μs)
  • afterRenderRawModule mod_menu (Main Menu) (618.2KB) (12.11ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (8μs)
  • afterRenderModule mod_menu (Main Menu) (11.4KB) (517μs)
  • beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (82μs)
  • afterRenderRawModule mod_finder (What Would You Like to Know) (62.75KB) (15.34ms)
  • beforeRenderModule mod_finder (What Would You Like to Know) (736B) (9μs)
  • afterRenderModule mod_finder (What Would You Like to Know) (3.84KB) (359μs)
  • afterRender (396.68KB) (103ms)
  • 1 x afterInitialise (2.76MB) (23.89%)
    165ms
    1 x afterRenderComponent com_content (992.37KB) (22.26%)
    154ms
    1 x afterRender (396.68KB) (14.88%)
    103ms
    1 x afterRoute (2.32MB) (9.84%)
    68.15ms
    1 x afterRenderRawModule mod_menu (Publications) (3.51MB) (7.99%)
    55.32ms
    1 x afterLoad (363.2KB) (6.89%)
    47.74ms
    1 x beforeRenderComponent com_content (393.63KB) (3.06%)
    21.19ms
    1 x beforeRenderRawModule mod_custom (footer) (463.06KB) (2.84%)
    19.70ms
    1 x afterRenderRawModule mod_finder (What Would You Like to Know) (62.75KB) (2.22%)
    15.34ms
    1 x afterRenderRawModule mod_menu (Main Menu) (618.2KB) (1.75%)
    12.11ms
    1 x Before Access::preloadComponents (all components) (115.07KB) (1.31%)
    9.06ms
    1 x afterDispatch (13.31KB) (1.01%)
    6.99ms
    1 x After Access::preloadPermissions (com_content) (585.58KB) (0.35%)
    2.42ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.43KB) (0.31%)
    2.14ms
    1 x afterRenderRawModule mod_custom (footer) (5.38KB) (0.31%)
    2.12ms
    1 x After Access::getAssetRules (id:686 name:com_content.article.563) (8.63KB) (0.24%)
    1.64ms
    1 x After Access::preloadComponents (all components) (126.38KB) (0.21%)
    1.48ms
    1 x afterRenderModule mod_custom (footer) (4.66KB) (0.12%)
    861μs
    1 x afterRenderModule mod_menu (Publications) (11.08KB) (0.08%)
    548μs
    1 x afterRenderModule mod_menu (Main Menu) (11.4KB) (0.07%)
    517μs
    1 x afterRenderModule mod_finder (What Would You Like to Know) (3.84KB) (0.05%)
    359μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (0.04%)
    264μs
    1 x beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (0.01%)
    82μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (0.01%)
    67μs
    1 x Before Access::getAssetRules (id:686 name:com_content.article.563) (34.8KB) (0.01%)
    54μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (0.01%)
    50μs
    1 x beforeRenderRawModule mod_menu (Publications) (1.29KB) (0.01%)
    48μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    13μs
    1 x beforeRenderModule mod_finder (What Would You Like to Know) (736B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Publications) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
47 statements were executed, 7 of which were duplicates, 40 unique88.44ms1.1MB
  • SELECT @@SESSION.sql_mode;160μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `vax0y_session` WHERE `session_id` = ?231μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = :session_id LIMIT 1209μ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)4.91ms944BParams/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` = 1603μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vax0y_viewlevels`452μ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` = :guest766μ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.27ms4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM vax0y_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'233μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM vax0y_rsfirewall_hashes WHERE `type`='protect'659μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM vax0y_rsfirewall_configuration350μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `vax0y_rsfirewall_logs`8.72ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • 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-07 11:23:18' LIMIT 1428μs840B/plugins/system/yendifvideoshare/yendifvideoshare.php:74Copy
  • 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`7.11ms820.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM vax0y_rsfirewall_hashes WHERE (`type`='5.2.5' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)606μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM vax0y_rsfirewall_snapshots WHERE `type`='protect'208μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='3.19.239.158' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'228μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='3.19.239.158' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'4.29ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM vax0y_rsfirewall_exceptions WHERE `published`='1'261μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `vax0y_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.85ms2.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` = 1600μ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)799μs8.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.27ms81.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `vax0y_content`13.2ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `vax0y_content` SET `hits` = (`hits` + 1) WHERE `id` = '563'1.42ms48B/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)1.58ms24.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`1.87ms5.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)366μ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`851μ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 ASC819μs5.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `vax0y_users`9.74ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `vax0y_users` WHERE `id` = :userid972μ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` = :muserid580μs12.7KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1463μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1278μ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 `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.26ms35.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `vax0y_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1495μs976B/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)294μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `vax0y_schemaorg` WHERE `itemId` = :itemId AND `context` = :context1.08ms1.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)667μ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)620μ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` = 1246μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `template` FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1231μs856B/plugins/system/rsmatias/helper.php:62Copy
  • SHOW FULL COLUMNS FROM `vax0y_template_styles`12.36ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `id` = '23'707μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = ?580μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vax0y_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.56ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy