­

What Would You Like to Know

Book Review: The Locust Effect
Why the end of poverty requires the end of violence
Gary Haugen & Victor Boutros
OUP 2014.

In 1875 trillions of locusts weighing 27 million tons bore down on 200,000 square miles of the American Midwest and wiped out every living plant. Gary Haugen and Victor Boutros show that a similar effect is happening to the world’s poor. As much as they try to work, save for their children’s education, buy small houses (or rooms) to live in, their efforts are consistently and effectively thwarted by an epidemic of violence.

The authors don’t focus on war zones or civil conflicts, although these are devastating enough. They illustrate in pitiful detail the ordinary criminal violence that afflicts the world’s poor – especially in developing countries.

Sexual violence (a “medical emergency” according to Medicine Sans Frontiers), slavery (there are more slaves in the world now than there were during the whole period of the 18th century slave trade), land grabbing, arbitrary detention and torture are some of the features of this violence.

One of the chief reasons it continues mostly unabated is that the poor do not live under the protection of the law. For a number of reasons: the public justice system in the developing world is broken. The police are under trained, under resourced, under paid, and scarce. There are too few prosecutors. There are not enough judges and the court systems are dysfunctional and hopelessly back logged.
Numerous reports by the United Nations, the World Bank and others, report the locust effect on  real capital earnings (GDP reduced by up to 14%); human capital (9 million years of disability adjusted life years lost each year); social capital (destroys social fabric and relationships); mental illness.

One big reason the criminal justice systems of the developing world are dysfunctional is that they are carry-overs from the colonial era when police forces were developed to protect the colonial powers, not to care for the ordinary people. The amazing thing is that in many countries no changes have been made after independence.

Private justice systems, (private security, alternative dispute resolution) are being used by elites in the developing world to protect their people and property. Public justice systems continue to decline in usefulness. The biggest obstacle to change is that the elites benefit from the broken public justice system because it protects them from being held accountable.

The massive global movement to address poverty in the developing world over the last 50 years has not made a meaningful effort to address the problem of criminal violence against the poor.  Overall almost nothing has been spent on helping criminal justice systems that benefit the poor. So it hasn't been tried and found wanting it has been found hard and left untried.

However there is good news (sort of). The kind of corruption and dysfunction at present in the criminal justice systems of developing countries is pretty much the same as it was in US Japan France and other countries 100 years ago. This is normal. But change happened because of: local ownership and leadership of intentional efforts to change; each situation needed its own specific solutions; community leaders and reform minded elites played a critical role; the priority was to prevent violence; building a well resourced law enforcement capacity was risky; change can happen quickly but usually in punctuated bursts. So there is hope.

The authors provide worked examples of changes that have happened. The authors are part of the International Justice Mission which arose out of a Christian conscience but works with all kinds of people in all sorts of communities. Structural Transformation is one of its methods where coalitions of local people work together to bring about change. Collaborative Casework is an aspect of this. IJM and others have seen wonderful changes take place in a variety of countries. This part of the book is a very encouraging contrast to the horror of the first few chapters.

The authors say that what needs to happen now is to transform the conversation about global poverty so that violence is seen to be a devastating factor; integrate expertise about criminal justice into the conversation; experiment with Projects of Hope which will provide models, examples, and hope for other communities. Especially using versions of Collaborative Casework. 
An amazing book. Worth reading, discussing and working out what to do.

Dale Appleby, Willeton WA

­
11.275MBMemory Usage201msRequest 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" => 1743983855 "last" => 1743983855...
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.222.240.84" => "US" ] ]
  • afterLoad (94.88KB) (577μs)
  • afterInitialise (1.54MB) (36.26ms)
  • afterRoute (2.32MB) (18.81ms)
  • beforeRenderComponent com_content (196.41KB) (2.34ms)
  • Before Access::preloadComponents (all components) (46.98KB) (588μs)
  • After Access::preloadComponents (all components) (126.38KB) (3.36ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (11μs)
  • After Access::preloadPermissions (com_content) (585.58KB) (6.49ms)
  • Before Access::getAssetRules (id:652 name:com_content.article.532) (34.8KB) (50μs)
  • After Access::getAssetRules (id:652 name:com_content.article.532) (8.47KB) (81μs)
  • afterRenderComponent com_content (574.05KB) (52.22ms)
  • afterDispatch (13.21KB) (1.56ms)
  • beforeRenderRawModule mod_custom (footer) (393.09KB) (9.44ms)
  • afterRenderRawModule mod_custom (footer) (4.25KB) (427μs)
  • beforeRenderModule mod_custom (footer) (704B) (7μs)
  • afterRenderModule mod_custom (footer) (4.24KB) (195μs)
  • beforeRenderRawModule mod_menu (Publications) (1.29KB) (54μs)
  • afterRenderRawModule mod_menu (Publications) (3.5MB) (19.76ms)
  • beforeRenderModule mod_menu (Publications) (720B) (14μs)
  • afterRenderModule mod_menu (Publications) (10.98KB) (243μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (85μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (5.7KB) (497μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (174μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (56μs)
  • afterRenderRawModule mod_menu (Main Menu) (553.68KB) (10.81ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (12μs)
  • afterRenderModule mod_menu (Main Menu) (11.32KB) (298μs)
  • beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (76μs)
  • afterRenderRawModule mod_finder (What Would You Like to Know) (61.17KB) (4.66ms)
  • beforeRenderModule mod_finder (What Would You Like to Know) (736B) (5μs)
  • afterRenderModule mod_finder (What Would You Like to Know) (3.75KB) (154μs)
  • afterRender (256.76KB) (31.03ms)
  • 1 x afterRenderComponent com_content (574.05KB) (26.03%)
    52.22ms
    1 x afterInitialise (1.54MB) (18.08%)
    36.26ms
    1 x afterRender (256.76KB) (15.47%)
    31.03ms
    1 x afterRenderRawModule mod_menu (Publications) (3.5MB) (9.85%)
    19.76ms
    1 x afterRoute (2.32MB) (9.37%)
    18.81ms
    1 x afterRenderRawModule mod_menu (Main Menu) (553.68KB) (5.39%)
    10.81ms
    1 x beforeRenderRawModule mod_custom (footer) (393.09KB) (4.7%)
    9.44ms
    1 x After Access::preloadPermissions (com_content) (585.58KB) (3.24%)
    6.49ms
    1 x afterRenderRawModule mod_finder (What Would You Like to Know) (61.17KB) (2.32%)
    4.66ms
    1 x After Access::preloadComponents (all components) (126.38KB) (1.68%)
    3.36ms
    1 x beforeRenderComponent com_content (196.41KB) (1.16%)
    2.34ms
    1 x afterDispatch (13.21KB) (0.78%)
    1.56ms
    1 x Before Access::preloadComponents (all components) (46.98KB) (0.29%)
    588μs
    1 x afterLoad (94.88KB) (0.29%)
    577μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (5.7KB) (0.25%)
    497μs
    1 x afterRenderRawModule mod_custom (footer) (4.25KB) (0.21%)
    427μs
    1 x afterRenderModule mod_menu (Main Menu) (11.32KB) (0.15%)
    298μs
    1 x afterRenderModule mod_menu (Publications) (10.98KB) (0.12%)
    243μs
    1 x afterRenderModule mod_custom (footer) (4.24KB) (0.1%)
    195μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.73KB) (0.09%)
    174μs
    1 x afterRenderModule mod_finder (What Would You Like to Know) (3.75KB) (0.08%)
    154μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.02KB) (0.04%)
    85μs
    1 x After Access::getAssetRules (id:652 name:com_content.article.532) (8.47KB) (0.04%)
    81μs
    1 x beforeRenderRawModule mod_finder (What Would You Like to Know) (2.38KB) (0.04%)
    76μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.81KB) (0.03%)
    56μs
    1 x beforeRenderRawModule mod_menu (Publications) (1.29KB) (0.03%)
    54μs
    1 x Before Access::getAssetRules (id:652 name:com_content.article.532) (34.8KB) (0.02%)
    50μs
    1 x beforeRenderModule mod_menu (Publications) (720B) (0.01%)
    14μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    12μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0.01%)
    11μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (What Would You Like to Know) (736B) (0%)
    5μs
47 statements were executed, 7 of which were duplicates, 40 unique78.49ms1.1MB
  • SELECT @@SESSION.sql_mode;167μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `vax0y_session` WHERE `session_id` = ?225μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = :session_id LIMIT 1198μ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)1.21ms944BParams/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` = 1456μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vax0y_viewlevels`220μ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` = :guest297μ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`2.32ms4.27KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM vax0y_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'199μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM vax0y_rsfirewall_hashes WHERE `type`='protect'564μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM vax0y_rsfirewall_configuration400μs2.19KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `vax0y_rsfirewall_logs`9.42ms2.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-06 23:57:35' LIMIT 1518μ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`5.62ms820.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)483μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM vax0y_rsfirewall_snapshots WHERE `type`='protect'200μs1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.222.240.84' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'303μs3.38KB/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM vax0y_rsfirewall_lists WHERE (`ip`='18.222.240.84' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'4.81ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM vax0y_rsfirewall_exceptions WHERE `published`='1'210μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `vax0y_languages` WHERE `published` = 1 ORDER BY `ordering` ASC298μ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` = 1372μ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)2.83ms8.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` = 03.78ms81.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `vax0y_content`9.62ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `vax0y_content` SET `hits` = (`hits` + 1) WHERE `id` = '532'2.5ms48B/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)887μ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`842μs5.14KBParams/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)452μ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`863μs5.14KBParams/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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (: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.15ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SHOW FULL COLUMNS FROM `vax0y_users`8.69ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `vax0y_users` WHERE `id` = :userid294μ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` = :muserid284μs12.7KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1436μs1.22KB/plugins/system/rsjuno/helper.php:23Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1315μ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.58ms35.59KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `vax0y_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1610μ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)370μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `vax0y_schemaorg` WHERE `itemId` = :itemId AND `context` = :context503μ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)1.04ms24.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)786μ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` = 1290μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `template` FROM `vax0y_template_styles` WHERE `client_id` = 0 AND `home` = 1278μs856B/plugins/system/rsmatias/helper.php:62Copy
  • SHOW FULL COLUMNS FROM `vax0y_template_styles`9.5ms2.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `vax0y_template_styles` WHERE `id` = '23'272μs1.22KB/libraries/src/Table/Table.php:780Copy
  • SELECT `session_id` FROM `vax0y_session` WHERE `session_id` = ?231μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vax0y_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.58ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy