Slingshot 324, May/June 2019

Containing articles on

  • Guardroom
  • DBA3 - Improving the Simulation - by Joe Collins
  • Coals to Newcastle: Playing Welsh DBA Lists in Wales - by Martin Smith
  • The Early Japanese Army: Reexamining the DBA 3.0 Army Lists - by Nicholas Spratt
  • Battle Day Reports - by Roy Boss and Duncan Head
  • Simple Campaign for Danelaw Britain: A Solo or Programmed Campaign for DBA 3, Part II - by Paul Stein
  • The Battle of Montgisard, 1177AD - by Nicholas Harbud
  • Slingshot Figure Reviews:
    • Baueda 40x40mm Isolated Tower
  • Slingshot Book & Game Reviews:
    • Two Handed Sword: History, Design and Use - reviewed by Anthony Clipsom
    • Antipater's Dynasty: Alexander the Great's Regent and his Successors - reviewed by Duncan Head
    • Roman Legionaries: Soldiers of Empire - reviewed by Aaron Bell
    • With Alexander in India & Central Asia: Moving East & Back to West - reviewed by Andreas Johansson

As well as all the usual features.

Out of Stock 

Click on 'read more' to see a list of the internet links appearing in articles in this edition.

 

Slingshot 324 Internet links

DBA3 - Improving the Simulation

DBA3 Reference sheet - http://soa.org.uk/joomla/publications

High King of Tara

http://soa.org.uk/joomla/18-games/50-high-king-of-tara

The Battle of Montgisard

http://www.pegasomodels.com

 

 

View cart

 

Online Payment

 

Payment is via Paypal; Paypal should automatically convert your currency. You do not need a pre-existing Paypal account to use the site; but you will need to create a PayPal account in order to make the payment - PayPal now requires this because of anti-money-laundering legislation. If you're in a territory not supported by Paypal, contact the Membership secretary using the form on the Contacts page and we'll try and work something out.

Buying by Post

 

If you don't want to buy the products online, please download the postal sales form. A third option (to using this cart, or to using the postal service) is to just go to Paypal and use the "Send Funds" function there to wire payments directly to membership AT soa.org.uk (replace the AT with an @); this may be helpful if you want to use the online service but are having problems with it.

Family Memberships

 

Family Memberships are memberships which provide all the benefits of membership except for a Slingshot subscription (e.g. a membership number, vendor discounts, forums access). They are available to individuals living at the same address as a full (Slingshot subscribing) Society member. They were previously made available on a chargeable basis. They are now free. To ask for a family membership, please submit your request via the contact form, setting the Topic to "Family Memberships" if it is not already that.

Worldwide Postage

 

Your membership subscription includes the Slingshot postage price, worldwide (yes, the price is the same for everyone). Other items from the store are charged for postage at cost, which is calculated during your checkout process.

J! InfoRequestSessionProfileQueries28Log
17.764MBMemory Usage3.41sRequest Duration
Joomla! Version4.4.10
PHP Version8.2.18
Identityguest
Response200
Templateb2brown
Database
Server
mysql
Version
11.4.5-MariaDB-deb12
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_uca1400_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:50 [ "UNIQUE_ID" => "Z@jZ8M1sztCq6bPhh8DypwAAAA8" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTP...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743313394 "last" => 1743313394...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.92MB) (493ms)
  • afterInitialise (5.81MB) (1.52s)
  • afterRoute (1.01MB) (322ms)
  • beforeRenderComponent com_content (877.32KB) (155ms)
  • Before Access::preloadComponents (all components) (457.8KB) (57.28ms)
  • After Access::preloadComponents (all components) (111.89KB) (5.81ms)
  • Before Access::preloadPermissions (com_content) (424B) (55μs)
  • After Access::preloadPermissions (com_content) (184.05KB) (9.99ms)
  • Before Access::getAssetRules (id:281 name:com_content.article.177) (10.65KB) (143μs)
  • After Access::getAssetRules (id:281 name:com_content.article.177) (25.52KB) (8.72ms)
  • afterRenderComponent com_content (3.49MB) (365ms)
  • afterDispatch (2.28KB) (1.13ms)
  • beforeRenderRawModule mod_jbcookies (JB Cookies) (181.83KB) (46.71ms)
  • afterRenderRawModule mod_jbcookies (JB Cookies) (581.7KB) (120ms)
  • beforeRenderModule mod_jbcookies (JB Cookies) (720B) (34μs)
  • afterRenderModule mod_jbcookies (JB Cookies) (1.23KB) (3.84ms)
  • beforeRenderRawModule mod_custom (Button Footer) (7.43KB) (200μs)
  • afterRenderRawModule mod_custom (Button Footer) (14.77KB) (26.63ms)
  • beforeRenderModule mod_custom (Button Footer) (720B) (37μs)
  • afterRenderModule mod_custom (Button Footer) (1.25KB) (1.39ms)
  • beforeRenderRawModule mod_custom (View Cart Footer) (712B) (192μs)
  • afterRenderRawModule mod_custom (View Cart Footer) (928B) (2.52ms)
  • beforeRenderModule mod_custom (View Cart Footer) (720B) (22μs)
  • afterRenderModule mod_custom (View Cart Footer) (1.25KB) (1.18ms)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (872B) (177μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (34.02KB) (31.02ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (17μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.82KB) (3.26ms)
  • beforeRenderRawModule mod_search (Search) (1.75KB) (209μs)
  • afterRenderRawModule mod_search (Search) (55.8KB) (28.11ms)
  • beforeRenderModule mod_search (Search) (704B) (42μs)
  • afterRenderModule mod_search (Search) (2.4KB) (1.95ms)
  • beforeRenderRawModule mod_menu (Main Menu) (32B) (201μs)
  • afterRenderRawModule mod_menu (Main Menu) (351.7KB) (94.66ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (19μs)
  • afterRenderModule mod_menu (Main Menu) (2.65KB) (1.3ms)
  • beforeRenderRawModule mod_menu (Slingshot Menu Module) (440B) (54μs)
  • afterRenderRawModule mod_menu (Slingshot Menu Module) (36.72KB) (16.79ms)
  • beforeRenderModule mod_menu (Slingshot Menu Module) (720B) (20μs)
  • afterRenderModule mod_menu (Slingshot Menu Module) (2.54KB) (1.83ms)
  • afterRender (257.46KB) (76.5ms)
  • 1 x afterInitialise (5.81MB) (44.47%)
    1.52s
    1 x afterLoad (3.92MB) (14.45%)
    493.22ms
    1 x afterRenderComponent com_content (3.49MB) (10.71%)
    365.39ms
    1 x afterRoute (1.01MB) (9.42%)
    321.54ms
    1 x beforeRenderComponent com_content (877.32KB) (4.55%)
    155.27ms
    1 x afterRenderRawModule mod_jbcookies (JB Cookies) (581.7KB) (3.51%)
    119.92ms
    1 x afterRenderRawModule mod_menu (Main Menu) (351.7KB) (2.77%)
    94.66ms
    1 x afterRender (257.46KB) (2.24%)
    76.50ms
    1 x Before Access::preloadComponents (all components) (457.8KB) (1.68%)
    57.28ms
    1 x beforeRenderRawModule mod_jbcookies (JB Cookies) (181.83KB) (1.37%)
    46.71ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (34.02KB) (0.91%)
    31.02ms
    1 x afterRenderRawModule mod_search (Search) (55.8KB) (0.82%)
    28.11ms
    1 x afterRenderRawModule mod_custom (Button Footer) (14.77KB) (0.78%)
    26.63ms
    1 x afterRenderRawModule mod_menu (Slingshot Menu Module) (36.72KB) (0.49%)
    16.79ms
    1 x After Access::preloadPermissions (com_content) (184.05KB) (0.29%)
    9.99ms
    1 x After Access::getAssetRules (id:281 name:com_content.article.177) (25.52KB) (0.26%)
    8.72ms
    1 x After Access::preloadComponents (all components) (111.89KB) (0.17%)
    5.81ms
    1 x afterRenderModule mod_jbcookies (JB Cookies) (1.23KB) (0.11%)
    3.84ms
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.82KB) (0.1%)
    3.26ms
    1 x afterRenderRawModule mod_custom (View Cart Footer) (928B) (0.07%)
    2.52ms
    1 x afterRenderModule mod_search (Search) (2.4KB) (0.06%)
    1.95ms
    1 x afterRenderModule mod_menu (Slingshot Menu Module) (2.54KB) (0.05%)
    1.83ms
    1 x afterRenderModule mod_custom (Button Footer) (1.25KB) (0.04%)
    1.39ms
    1 x afterRenderModule mod_menu (Main Menu) (2.65KB) (0.04%)
    1.30ms
    1 x afterRenderModule mod_custom (View Cart Footer) (1.25KB) (0.03%)
    1.18ms
    1 x afterDispatch (2.28KB) (0.03%)
    1.13ms
    1 x beforeRenderRawModule mod_search (Search) (1.75KB) (0.01%)
    209μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (32B) (0.01%)
    201μs
    1 x beforeRenderRawModule mod_custom (Button Footer) (7.43KB) (0.01%)
    200μs
    1 x beforeRenderRawModule mod_custom (View Cart Footer) (712B) (0.01%)
    192μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (872B) (0.01%)
    177μs
    1 x Before Access::getAssetRules (id:281 name:com_content.article.177) (10.65KB) (0%)
    143μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0%)
    55μs
    1 x beforeRenderRawModule mod_menu (Slingshot Menu Module) (440B) (0%)
    54μs
    1 x beforeRenderModule mod_search (Search) (704B) (0%)
    42μs
    1 x beforeRenderModule mod_custom (Button Footer) (720B) (0%)
    37μs
    1 x beforeRenderModule mod_jbcookies (JB Cookies) (720B) (0%)
    34μs
    1 x beforeRenderModule mod_custom (View Cart Footer) (720B) (0%)
    22μs
    1 x beforeRenderModule mod_menu (Slingshot Menu Module) (720B) (0%)
    20μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    19μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    17μs
28 statements were executed, 5 of which were duplicates, 23 unique54.67ms140.98KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;2.16ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jml_session` WHERE `session_id` = ?1.16ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jml_session` WHERE `session_id` = :session_id LIMIT 11.01ms1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jml_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.17ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jml_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 12.01ms1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jml_viewlevels`4.97ms656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jml_usergroups` AS `a` LEFT JOIN `jml_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest4.91ms1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jml_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.23ms3.98KBParams/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 `jml_menu` AS `m` LEFT JOIN `jml_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`1.8ms52.55KBParams/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 `jml_categories` AS `s` INNER JOIN `jml_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`2.67ms3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `jml_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.02ms1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jml_template_styles` AS `s` LEFT JOIN `jml_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` = 11000μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jml_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)3.39ms7.56KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jml_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 03.98ms25.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jml_content`2.68ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jml_content` SET `hits` = (`hits` + 1) WHERE `id` = '177'1.13ms48B/libraries/src/Table/Table.php:1325Copy
  • 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 `jml_content` AS `a` INNER JOIN `jml_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jml_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jml_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jml_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jml_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.45ms7.38KBParams/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 `jml_categories` AS `s` INNER JOIN `jml_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.76ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jml_contentitem_tag_map` AS `m` INNER JOIN `jml_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)2.52ms3.97KBParams/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 `jml_categories` AS `s` INNER JOIN `jml_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.58ms3.94KBParams/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 jml_fields AS a LEFT JOIN `jml_languages` AS l ON l.lang_code = a.language LEFT JOIN jml_users AS uc ON uc.id=a.checked_out LEFT JOIN jml_viewlevels AS ag ON ag.id = a.access LEFT JOIN jml_users AS ua ON ua.id = a.created_user_id LEFT JOIN jml_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jml_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,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC3.02ms4.75KBParams/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 `jml_categories` AS `s` INNER JOIN `jml_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.45ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jml_modules` AS `m` LEFT JOIN `jml_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jml_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`2.19ms1.94KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `jml_content` WHERE `id` = :id594μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jml_content` WHERE `id` = :id397μ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 `jml_scheduler_tasks` AS `a` WHERE `a`.`state` = 1748μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jml_session` WHERE `session_id` = ?720μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jml_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?958μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy