Majority Voting as a Catalyst of Populism - Preferential Decision-making for an Inclusive Democracy

There are campaigners for a worthy cause who carry on week after week and even year after year. They pop up with an apposite comment whenever there is an event which provides them with an opening. Peter Emerson is one such campaigner and his current book sets out his case and recounts an amazing round trip from Northern Ireland to China and back, mainly by train, partly by bicycle and even some of it on foot. He manages to get into North Korea and, remarkably, succeeds in holding meetings on electoral reform in every country.

Over twenty years ago Peter Emerson established the de Borda Institute as a vehicle for the study and advocacy of the preferential voting system that he has advocated ever since. Its name comes from an eighteenth century French mathematician, Jean-Charles de Borda, who devised a voting system particularly aimed at bringing a consensual result that would be recognised as such in divisive situations. It is hardly accidental that Emerson is based in Northern Ireland, a region deeply divided by its history.

Essentially a decision taken under the Modified Borda Count (MBC) involves the individual voter's preferences being given the relevant number of points that accords to each preference. In decision making this allocation of points demonstrates the strength of support for the most preferred option and thus makes it more widely acceptable. In elections in a multiple vacancy seat, the Quote Borda System (QBS) allocates seats accurately and, it is argued, more acceptably. This system has essential similarities with the Single Transferable Vote, the system to which the long-established Electoral Reform Society is dedicated, but Emerson's de Borda Institute sees the much to be desired objective of the Borda methodogies as an all-party coalition government devoid of divisive party affiliations and certainly without any party whips. He states it explicitly in relation to areas suffering from political violence:

As is recognised by some in Northern Ireland and in other conflict zones .... the political choice of an economic policy or of a transport plan need not depend so immediately on an MP's confessional faith. Rather, decisions should depend upon the participants agreeing to express and discuss their preferences.

What is required, therefore, is a willingness amongst politicians and political scientists, firstly, to question the adversarial structure which is simple majority rule, and secondly, to consider a win-win polity founded on more inclusive voting procedures.

It sounds splendid but such a polity does not provide for the need for a group with some commonality of view of what kind of society it wishes to encourage and to legislate for. How else can there be any process of change, or any instructions to a civil service on which it can base an administration? Certainly Emerson is correct in wishing to expose politics that all too often lead to strife and even to violence but the answer to that must surely be better politics not no politics. As I know from my experience in thirty-five new and emerging countries on five continents, a democracy resulting from any electoral process will be ephemeral if the parties are based on tribe, region, religion, charismatic leader, an ancient "totem" or a liberation movement. To produce a sound basis for a political structure with a workable government and an effective opposition the parties have to be based on at least a semblance of political philosophy.

Peter Emerson expounds his case powerfully and certainly will not be at all inhibited by my criticism. His book applies his beliefs to the circumstances of each country he visits and he is impressively knowledgeable on each. His exposition of the Borda methodologies is supported by a great deal of mathematical equations, much of which, alas, I am not competent to follow. His book deserves serious consideration by all who are concerned at the dangerous political circumstances now evident in far too many countries and with the need to realise that a country's electoral system and, in consequence, and, more importantly, its decision-making system play a significant role in the way parties can manipulate power.

Majority Voting as a Catalyst of Populism - Preferential Decision-making for an Inclusive Democracy, by Peter Emerson, pub. Springer, 2020, 
ISBN 978-3-030-20218-7

7.516MBMemory Usage217msRequest Duration
Joomla! Version4.4.4
PHP Version8.2.28
Identityguest
Response200
Templatetp_advocat
Database
Server
mysql
Version
10.11.10-MariaDB-log
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:54 [ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1750241391 "last" => 1750241391...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (447.52KB) (4.45ms)
  • afterInitialise (1.11MB) (32.71ms)
  • afterRoute (820.79KB) (14.7ms)
  • beforeRenderComponent com_content (32.99KB) (623μs)
  • Before Access::preloadComponents (all components) (41.02KB) (1.53ms)
  • After Access::preloadComponents (all components) (114.45KB) (938μs)
  • Before Access::preloadPermissions (com_content) (1.66KB) (25μs)
  • After Access::preloadPermissions (com_content) (336.12KB) (1.57ms)
  • Before Access::getAssetRules (id:624 name:com_content.article.384) (18.65KB) (52μs)
  • After Access::getAssetRules (id:624 name:com_content.article.384) (7.06KB) (154μs)
  • afterRenderComponent com_content (409.53KB) (16.74ms)
  • afterDispatch (207.88KB) (2.98ms)
  • Before Access::getAssetRules (id:16 name:com_menus) (1.27MB) (33.78ms)
  • After Access::getAssetRules (id:16 name:com_menus) (5.7KB) (48μs)
  • beforeRenderRawModule mod_custom (In this section...) (4.5KB) (152μs)
  • afterRenderRawModule mod_custom (In this section...) (49.98KB) (3.78ms)
  • beforeRenderModule mod_custom (In this section...) (720B) (9μs)
  • afterRenderModule mod_custom (In this section...) (4.97KB) (256μs)
  • beforeRenderRawModule mod_custom (In this section mobile current affairs) (112B) (529μs)
  • afterRenderRawModule mod_custom (In this section mobile current affairs) (960B) (79μs)
  • beforeRenderModule mod_custom (In this section mobile current affairs) (736B) (5μs)
  • afterRenderModule mod_custom (In this section mobile current affairs) (3.38KB) (102μs)
  • beforeRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (2.61KB) (451μs)
  • afterRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (17.05KB) (1.05ms)
  • beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (736B) (6μs)
  • afterRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (4.38KB) (105μs)
  • beforeRenderRawModule mod_search (My search for top menu) (336B) (506μs)
  • afterRenderRawModule mod_search (My search for top menu) (36.25KB) (1.41ms)
  • beforeRenderModule mod_search (My search for top menu) (720B) (7μs)
  • afterRenderModule mod_search (My search for top menu) (3.56KB) (135μs)
  • beforeRenderRawModule mod_menu (Main Menu Mobile) (864B) (322μs)
  • afterRenderRawModule mod_menu (Main Menu Mobile) (12.29KB) (3.41ms)
  • beforeRenderModule mod_menu (Main Menu Mobile) (720B) (7μs)
  • afterRenderModule mod_menu (Main Menu Mobile) (11.4KB) (121μs)
  • afterRender (442.6KB) (93.95ms)
  • 1 x afterRender (442.6KB) (43.22%)
    93.95ms
    1 x Before Access::getAssetRules (id:16 name:com_menus) (1.27MB) (15.54%)
    33.78ms
    1 x afterInitialise (1.11MB) (15.05%)
    32.71ms
    1 x afterRenderComponent com_content (409.53KB) (7.7%)
    16.74ms
    1 x afterRoute (820.79KB) (6.76%)
    14.70ms
    1 x afterLoad (447.52KB) (2.05%)
    4.45ms
    1 x afterRenderRawModule mod_custom (In this section...) (49.98KB) (1.74%)
    3.78ms
    1 x afterRenderRawModule mod_menu (Main Menu Mobile) (12.29KB) (1.57%)
    3.41ms
    1 x afterDispatch (207.88KB) (1.37%)
    2.98ms
    1 x After Access::preloadPermissions (com_content) (336.12KB) (0.72%)
    1.57ms
    1 x Before Access::preloadComponents (all components) (41.02KB) (0.7%)
    1.53ms
    1 x afterRenderRawModule mod_search (My search for top menu) (36.25KB) (0.65%)
    1.41ms
    1 x afterRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (17.05KB) (0.48%)
    1.05ms
    1 x After Access::preloadComponents (all components) (114.45KB) (0.43%)
    938μs
    1 x beforeRenderComponent com_content (32.99KB) (0.29%)
    623μs
    1 x beforeRenderRawModule mod_custom (In this section mobile current affairs) (112B) (0.24%)
    529μs
    1 x beforeRenderRawModule mod_search (My search for top menu) (336B) (0.23%)
    506μs
    1 x beforeRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (2.61KB) (0.21%)
    451μs
    1 x beforeRenderRawModule mod_menu (Main Menu Mobile) (864B) (0.15%)
    322μs
    1 x afterRenderModule mod_custom (In this section...) (4.97KB) (0.12%)
    256μs
    1 x After Access::getAssetRules (id:624 name:com_content.article.384) (7.06KB) (0.07%)
    154μs
    1 x beforeRenderRawModule mod_custom (In this section...) (4.5KB) (0.07%)
    152μs
    1 x afterRenderModule mod_search (My search for top menu) (3.56KB) (0.06%)
    135μs
    1 x afterRenderModule mod_menu (Main Menu Mobile) (11.4KB) (0.06%)
    121μs
    1 x afterRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (4.38KB) (0.05%)
    105μs
    1 x afterRenderModule mod_custom (In this section mobile current affairs) (3.38KB) (0.05%)
    102μs
    1 x afterRenderRawModule mod_custom (In this section mobile current affairs) (960B) (0.04%)
    79μs
    1 x Before Access::getAssetRules (id:624 name:com_content.article.384) (18.65KB) (0.02%)
    52μs
    1 x After Access::getAssetRules (id:16 name:com_menus) (5.7KB) (0.02%)
    48μs
    1 x Before Access::preloadPermissions (com_content) (1.66KB) (0.01%)
    25μs
    1 x beforeRenderModule mod_custom (In this section...) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_search (My search for top menu) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Main Menu Mobile) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (In this section mobile current affairs) (736B) (0%)
    5μs
29 statements were executed, 5 of which were duplicates, 24 unique11.91ms277.48KB
  • SELECT @@SESSION.sql_mode;76μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jto7c_session` WHERE `session_id` = ?110μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jto7c_session` WHERE `session_id` = :session_id LIMIT 161μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jto7c_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)170μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jto7c_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1403μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jto7c_viewlevels`68μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jto7c_usergroups` AS `a` LEFT JOIN `jto7c_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest153μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jto7c_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`831μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `jto7c_menu` AS `m` LEFT JOIN `jto7c_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`977μs165.17KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`545μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `jto7c_content` WHERE `alias` = :alias AND `catid` = :catid310μs1.34KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jto7c_template_styles` AS `s` LEFT JOIN `jto7c_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` = 1436μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `jto7c_languages` WHERE `published` = 1 ORDER BY `ordering` ASC108μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jto7c_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)515μs7.56KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jto7c_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0547μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • 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 `jto7c_content` AS `a` INNER JOIN `jto7c_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jto7c_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jto7c_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jto7c_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jto7c_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)438μs22.17KBParams/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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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`353μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jto7c_contentitem_tag_map` AS `m` INNER JOIN `jto7c_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)708μs3.95KBParams/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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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`431μs3.91KBParams/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 jto7c_fields AS a LEFT JOIN `jto7c_languages` AS l ON l.lang_code = a.language LEFT JOIN jto7c_users AS uc ON uc.id=a.checked_out LEFT JOIN jto7c_viewlevels AS ag ON ag.id = a.access LEFT JOIN jto7c_users AS ua ON ua.id = a.created_user_id LEFT JOIN jto7c_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jto7c_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 ASC974μs4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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`389μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jto7c_categories` WHERE `id`=2878μs536B/libraries/astroid/framework/library/astroid/Article.php:677Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jto7c_modules` AS `m` LEFT JOIN `jto7c_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jto7c_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.46ms1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 jto7c_fields AS a LEFT JOIN `jto7c_languages` AS l ON l.lang_code = a.language LEFT JOIN jto7c_users AS uc ON uc.id=a.checked_out LEFT JOIN jto7c_viewlevels AS ag ON ag.id = a.access LEFT JOIN jto7c_users AS ua ON ua.id = a.created_user_id LEFT JOIN jto7c_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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.05ms4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `jto7c_content` WHERE `id` = :id156μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jto7c_content` WHERE `id` = :id108μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `jto7c_scheduler_tasks` AS `a` WHERE `a`.`state` = 1148μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jto7c_session` WHERE `session_id` = ?153μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jto7c_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?145μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy