Summer Roster Singles Champions

Below are records of Singles Champions dating back to 2003 -04 Season, as time permits and information is provided more years will be added

If you can help fill in any missing information or add years to the list then please drop us an email with the information

Details
Parent Category: Past 8Ball Results
Category: Summer Roster Singles Champions
Hits: 4334
Summer Roster Singles Champions
2009 - 10 Winner Runner Up
Div 1 Andrew Johnson Bradley Grant
Div 2 Paul Styles Steve Collins
Div 3 Simon Thomas Sharon Worthington
2008 - 09 Winner Runner Up
Div 1 Scott Kopriva 3 Adrian White ?
Div 2 Phil Aird 3 Andrew Rainbow 1
Div 3 Phil Doble 3 Robin Murfet 0
2007 - 08 Winner Runner Up
Div 1 Kris Cherry Peter Wallace
Div 2 Bradley Flack Wayne Purdon
Div 3 Hilton Purcell Robin Murfet
Div 4 Luke Young David Murfet
2006 - 07 Winner Runner Up
Div 1 Peter Miller Duncan Campbell
Div 2 John Saggers ?
Div 3 ? ?
Div 4 David Cocran Andrew Zammit
2005 - 06 Winner Runner Up
Div 1 Barry Adams Geoff Stonehouse
Div 2 Phil Aird Richard Austin
Div 3 Tim Bullock Ricki Baker
Div 4 Paul Suidgeest Ray Stone
2004 - 05 Winner Runner Up
Div 1 Bruce Lockley Scott Kopriva
Div 2 Wayne Purdon Richard Austin
Div 3 Steve Moorhouse Robin Murfet
Div 4 Jeremy Pyke John Zammit
2003 - 04 Winner Runner Up
Div 1 Andrew Saltmarsh Colin Crook
Div 2 Gordon Smith George Zammit
Div 3 David Rowbottom Anthony Thomas
Div 4 Dean Wilson ?
J! InfoRequestSessionProfileQueries32Log
25.703MBMemory Usage358msRequest Duration
Joomla! Version4.4.2
PHP Version8.2.28
Identityguest
Response200
Templatert_acronym
Database
Server
mysql
Version
10.6.20-MariaDB-cll-lve
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:51 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:2 [ "counter" => 1 "timer" => array:3 [ "start" => 1745759706 "last" => 1745759706...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.99MB) (37ms)
  • afterInitialise (7.16MB) (84.74ms)
  • afterRoute (4.01MB) (39.72ms)
  • beforeRenderComponent com_content (320.43KB) (4.35ms)
  • Before Access::preloadComponents (all components) (746.45KB) (10.49ms)
  • After Access::preloadComponents (all components) (112.02KB) (715μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (24μs)
  • After Access::preloadPermissions (com_content) (382.69KB) (1.2ms)
  • Before Access::getAssetRules (id:35 name:com_content.category.10) (18.65KB) (54μs)
  • After Access::getAssetRules (id:35 name:com_content.category.10) (21.46KB) (527μs)
  • Before Access::getAssetRules (id:8 name:com_content) (349.43KB) (4.66ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.17KB) (40μs)
  • afterRenderComponent com_content (1.68MB) (41.4ms)
  • afterDispatch (1.88KB) (69μs)
  • beforeRenderRawModule mod_djmegamenu (Main Menu) (3.41MB) (39.2ms)
  • afterRenderRawModule mod_djmegamenu (Main Menu) (709.55KB) (30.02ms)
  • beforeRenderModule mod_djmegamenu (Main Menu) (720B) (20μs)
  • afterRenderModule mod_djmegamenu (Main Menu) (15.59KB) (470μs)
  • beforeRenderRawModule mod_djmegamenu (Events n Results) (134.53KB) (3.47ms)
  • afterRenderRawModule mod_djmegamenu (Events n Results) (97.94KB) (5ms)
  • beforeRenderModule mod_djmegamenu (Events n Results) (720B) (14μs)
  • afterRenderModule mod_djmegamenu (Events n Results) (3.6KB) (334μs)
  • beforeRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (24.54KB) (65μs)
  • afterRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (3.69KB) (390μs)
  • beforeRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (752B) (12μs)
  • afterRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (2.1KB) (323μs)
  • afterRender (2.01MB) (53.74ms)
  • 1 x afterInitialise (7.16MB) (23.65%)
    84.74ms
    1 x afterRender (2.01MB) (14.99%)
    53.74ms
    1 x afterRenderComponent com_content (1.68MB) (11.55%)
    41.40ms
    1 x afterRoute (4.01MB) (11.08%)
    39.72ms
    1 x beforeRenderRawModule mod_djmegamenu (Main Menu) (3.41MB) (10.94%)
    39.20ms
    1 x afterLoad (3.99MB) (10.32%)
    37.00ms
    1 x afterRenderRawModule mod_djmegamenu (Main Menu) (709.55KB) (8.38%)
    30.02ms
    1 x Before Access::preloadComponents (all components) (746.45KB) (2.93%)
    10.49ms
    1 x afterRenderRawModule mod_djmegamenu (Events n Results) (97.94KB) (1.4%)
    5.00ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (349.43KB) (1.3%)
    4.66ms
    1 x beforeRenderComponent com_content (320.43KB) (1.21%)
    4.35ms
    1 x beforeRenderRawModule mod_djmegamenu (Events n Results) (134.53KB) (0.97%)
    3.47ms
    1 x After Access::preloadPermissions (com_content) (382.69KB) (0.33%)
    1.20ms
    1 x After Access::preloadComponents (all components) (112.02KB) (0.2%)
    715μs
    1 x After Access::getAssetRules (id:35 name:com_content.category.10) (21.46KB) (0.15%)
    527μs
    1 x afterRenderModule mod_djmegamenu (Main Menu) (15.59KB) (0.13%)
    470μs
    1 x afterRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (3.69KB) (0.11%)
    390μs
    1 x afterRenderModule mod_djmegamenu (Events n Results) (3.6KB) (0.09%)
    334μs
    1 x afterRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (2.1KB) (0.09%)
    323μs
    1 x afterDispatch (1.88KB) (0.02%)
    69μs
    1 x beforeRenderRawModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (24.54KB) (0.02%)
    65μs
    1 x Before Access::getAssetRules (id:35 name:com_content.category.10) (18.65KB) (0.02%)
    54μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.17KB) (0.01%)
    40μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    24μs
    1 x beforeRenderModule mod_djmegamenu (Main Menu) (720B) (0.01%)
    20μs
    1 x beforeRenderModule mod_djmegamenu (Events n Results) (720B) (0%)
    14μs
    1 x beforeRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button) (752B) (0%)
    12μs
32 statements were executed, 3 of which were duplicates, 29 unique22.3ms479.32KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;155μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `joom_session` WHERE `session_id` = ?263μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `joom_session` WHERE `session_id` = :session_id LIMIT 1159μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)223μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 189μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `joom_viewlevels`96μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `joom_usergroups` AS `a` LEFT JOIN `joom_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest83μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `joom_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`169μs59.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM joom_rsform_config87μs1.69KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • 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 `joom_menu` AS `m` LEFT JOIN `joom_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.88ms215.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `joom_template_styles` AS `s` LEFT JOIN `joom_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` = 1108μs912B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM joom_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_acronym' ORDER BY s.id94μs784B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `joom_languages` WHERE `published` = 1 ORDER BY `ordering` ASC138μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_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)174μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0251μs61.48KBParams/libraries/src/Access/Access.php:301Copy
  • 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`,( SELECT COUNT(`i`.`id`) FROM `joom_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `joom_categories` AS `s` INNER JOIN `joom_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`796μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `joom_content` AS `a` LEFT JOIN `joom_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `joom_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `joom_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `joom_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `joom_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `joom_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN ( SELECT `sub`.`id` FROM `joom_categories` AS `sub` INNER JOIN `joom_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt` WHERE `this`.`id` = :subCategoryId AND `sub`.`level` <= `this`.`level` + :levels)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY c.lft, a.ordering, a.created LIMIT 93.88ms71.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `joom_contentitem_tag_map` AS `m` INNER JOIN `joom_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1) AND `t`.`access` IN (:preparedArray2)344μs3.98KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT COUNT(*) FROM `joom_content` AS `a` LEFT JOIN `joom_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `joom_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `joom_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `joom_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `joom_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `joom_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN ( SELECT `sub`.`id` FROM `joom_categories` AS `sub` INNER JOIN `joom_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt` WHERE `this`.`id` = :subCategoryId AND `sub`.`level` <= `this`.`level` + :levels)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)2.76ms4.54KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `joom_contentitem_tag_map` AS `m` INNER JOIN `joom_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)306μ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 `joom_categories` AS `s` INNER JOIN `joom_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`537μ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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_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 ASC1.16ms4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_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.06ms4.03KBParams/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 `joom_categories` AS `s` INNER JOIN `joom_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`140μ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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_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 ASC1.36ms4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_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.22ms4.03KBParams/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 `joom_categories` AS `s` INNER JOIN `joom_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`168μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `joom_modules` AS `m` LEFT JOIN `joom_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `joom_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`2.52ms1.84KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM joom_extensions WHERE element='mod_djmegamenu' LIMIT 1104μs536B/modules/mod_djmegamenu/helpers/helper.php:404Copy
  • 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 `joom_scheduler_tasks` AS `a` WHERE `a`.`state` = 1145μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `joom_session` WHERE `session_id` = ?304μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `joom_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.52ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy