Great Barr Past and Present

Latest site news

Welcome to Great Barr, Past and Present that brings together historic and current information on Great Barr and its surroundings.

The site can still be accessed using its original addresses of www.b43.co.uk and www.b43.uk as well as the new www.great-barr.uk address.

This site has been updated to be responsive so it provides a better experience on mobile phones and tablet devices.

The sister site for www.redhousepark.org.uk as also been updated  and hamstead colliery site is in progress of being updated,

I an aware that some of the navigation is missing and this is being corrected. Please let me know if you find anything that is not being presented correctly or any improvements by emailing greatbarr@b43.co.uk. Thank You, Anthony Lewis.

Great Barr Past and Present

This web site is dedicated to presenting past, and present, information on Great Barr. The area is quite loosely defined around the 'B43' post code area but includes Hamstead, Gorse Farm, Newton, Grove Vale, Pear Tree, Scott Arms, Queslett and Pheasey. There are a number of significant historic areas, including the Great Barr Hall estate, Red House Park, Bishop Asburys House and Hamstead Colliery.

The site is organised in two ways. First by geographic area covering each part of Great Barr, and secondly by theme categorising features. Follow the navigation links  to access individual pages.

Astbury cottage

There are also the separate sites covering The Red House, Hamstead Colliery and Great Barr Hall which can be accessed via the 'Other Sites' menu. The Red House is to be sold by Sandewell Council and developed to contain flats , more details about the Red House and Red House Park can be found on the Friends of Red House Park site. Great Barr Hall is under new ownership and ideas for the future are being handled by Lapworth Architects .

Information about Great Barr is continually being added - there is a backlog of historic information to be added, completely new pages will be shown as Recent Additions in the bottom area of this page. Updating the site is a slow process, feel free to email me any problems you find and any contributions or articles are always welcome. I am adding individual pages for every road in B43 and welcome contributions about 'your' roads, why they got their name or any other information or photographs.

This site is very grateful to the residents, past and present, of Great Barr who have provided pictures and information about the area. If anyone can make a contribution to the sites content please let me know at the email address at the bottom of the page.

 Anthony Lewis, webmaster

Please use the menus or search facilities to find the information you require. Any information or pictures you have would be gratefully received, as well as any problems you find with the site. Email - greatbarr@b43.co.uk.

Latest updated pages

J! InfoRequestSessionProfileQueries26Log2
19.046MBMemory Usage113msRequest Duration
Joomla! Version4.4.6
PHP Version8.1.31
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
8.0.37
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:47 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1741682707 "last" => 1741682707...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.13MB) (14.65ms)
  • afterInitialise (7.43MB) (33.99ms)
  • afterRoute (1.28MB) (5.59ms)
  • beforeRenderComponent com_content (1MB) (7.25ms)
  • Before Access::preloadComponents (all components) (713.31KB) (3.72ms)
  • After Access::preloadComponents (all components) (115.15KB) (1.52ms)
  • Before Access::getAssetRules (id:8 name:com_content) (3.66KB) (18μs)
  • After Access::getAssetRules (id:8 name:com_content) (90.29KB) (233μs)
  • afterRenderComponent com_content (2.87MB) (26.03ms)
  • afterDispatch (7.73KB) (148μs)
  • beforeRenderRawModule mod_menu (Main Menu) (189.38KB) (3.58ms)
  • afterRenderRawModule mod_menu (Main Menu) (361.1KB) (3.65ms)
  • beforeRenderRawModule mod_articles_latest (Latest updated pages) (784B) (42μs)
  • afterRenderRawModule mod_articles_latest (Latest updated pages) (159.27KB) (7.61ms)
  • beforeRenderRawModule mod_custom (copyright) (480B) (33μs)
  • afterRenderRawModule mod_custom (copyright) (8.55KB) (266μs)
  • beforeRenderModule mod_custom (copyright) (25.43KB) (270μs)
  • afterRenderModule mod_custom (copyright) (4.09KB) (74μs)
  • beforeRenderModule mod_articles_latest (Latest updated pages) (288B) (28μs)
  • afterRenderModule mod_articles_latest (Latest updated pages) (4.7KB) (101μs)
  • beforeRenderModule mod_menu (Main Menu) (2.62KB) (42μs)
  • afterRenderModule mod_menu (Main Menu) (5.93KB) (28μs)
  • afterRender (310.19KB) (3.15ms)
  • 1 x afterInitialise (7.43MB) (30.21%)
    33.99ms
    1 x afterRenderComponent com_content (2.87MB) (23.13%)
    26.03ms
    1 x afterLoad (4.13MB) (13.02%)
    14.65ms
    1 x afterRenderRawModule mod_articles_latest (Latest updated pages) (159.27KB) (6.77%)
    7.61ms
    1 x beforeRenderComponent com_content (1MB) (6.45%)
    7.25ms
    1 x afterRoute (1.28MB) (4.97%)
    5.59ms
    1 x Before Access::preloadComponents (all components) (713.31KB) (3.31%)
    3.72ms
    1 x afterRenderRawModule mod_menu (Main Menu) (361.1KB) (3.25%)
    3.65ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (189.38KB) (3.18%)
    3.58ms
    1 x afterRender (310.19KB) (2.8%)
    3.15ms
    1 x After Access::preloadComponents (all components) (115.15KB) (1.35%)
    1.52ms
    1 x beforeRenderModule mod_custom (copyright) (25.43KB) (0.24%)
    270μs
    1 x afterRenderRawModule mod_custom (copyright) (8.55KB) (0.24%)
    266μs
    1 x After Access::getAssetRules (id:8 name:com_content) (90.29KB) (0.21%)
    233μs
    1 x afterDispatch (7.73KB) (0.13%)
    148μs
    1 x afterRenderModule mod_articles_latest (Latest updated pages) (4.7KB) (0.09%)
    101μs
    1 x afterRenderModule mod_custom (copyright) (4.09KB) (0.07%)
    74μs
    1 x beforeRenderRawModule mod_articles_latest (Latest updated pages) (784B) (0.04%)
    42μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.62KB) (0.04%)
    42μs
    1 x beforeRenderRawModule mod_custom (copyright) (480B) (0.03%)
    33μs
    1 x beforeRenderModule mod_articles_latest (Latest updated pages) (288B) (0.02%)
    28μs
    1 x afterRenderModule mod_menu (Main Menu) (5.93KB) (0.02%)
    28μs
    1 x Before Access::getAssetRules (id:8 name:com_content) (3.66KB) (0.02%)
    18μs
26 statements were executed, 2 of which were duplicates, 24 unique14.92ms531.4KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;66μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `greatbarr_session` WHERE `session_id` = ?99μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `greatbarr_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1232μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `greatbarr_viewlevels`117μs944B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `greatbarr_usergroups` AS `a` LEFT JOIN `greatbarr_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest148μs2.25KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `greatbarr_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`547μs3.77KBParams/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 `greatbarr_menu` AS `m` LEFT JOIN `greatbarr_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.9ms396.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `greatbarr_languages` WHERE `published` = 1 ORDER BY `ordering` ASC179μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `greatbarr_template_styles` AS `s` LEFT JOIN `greatbarr_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` = 1314μs2.41KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `greatbarr_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)559μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • 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 `greatbarr_content` AS `a` LEFT JOIN `greatbarr_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `greatbarr_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `greatbarr_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `greatbarr_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `greatbarr_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `greatbarr_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`featured` = 1 AND (`fp`.`featured_up` IS NULL OR `fp`.`featured_up` <= :frontpageUp) AND (`fp`.`featured_down` IS NULL OR `fp`.`featured_down` >= :frontpageDown) AND `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END , a.created DESC LIMIT 3795μs24.88KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `greatbarr_contentitem_tag_map` AS `m` INNER JOIN `greatbarr_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,:preparedArray2) AND `t`.`access` IN (:preparedArray3)268μs5.25KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT COUNT(*) FROM `greatbarr_content` AS `a` LEFT JOIN `greatbarr_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `greatbarr_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `greatbarr_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `greatbarr_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `greatbarr_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `greatbarr_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`featured` = 1 AND (`fp`.`featured_up` IS NULL OR `fp`.`featured_up` <= :frontpageUp) AND (`fp`.`featured_down` IS NULL OR `fp`.`featured_down` >= :frontpageDown) AND `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)404μs4.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199Copy
  • 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 `greatbarr_categories` AS `s` INNER JOIN `greatbarr_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.03ms5.42KBParams/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 greatbarr_fields AS a LEFT JOIN `greatbarr_languages` AS l ON l.lang_code = a.language LEFT JOIN greatbarr_users AS uc ON uc.id=a.checked_out LEFT JOIN greatbarr_viewlevels AS ag ON ag.id = a.access LEFT JOIN greatbarr_users AS ua ON ua.id = a.created_user_id LEFT JOIN greatbarr_fields_groups AS g ON g.id = a.group_id LEFT JOIN `greatbarr_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 ASC582μs5.31KBParams/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 `greatbarr_categories` AS `s` INNER JOIN `greatbarr_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`454μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM greatbarr_fields AS a LEFT JOIN `greatbarr_languages` AS l ON l.lang_code = a.language LEFT JOIN greatbarr_users AS uc ON uc.id=a.checked_out LEFT JOIN greatbarr_viewlevels AS ag ON ag.id = a.access LEFT JOIN greatbarr_users AS ua ON ua.id = a.created_user_id LEFT JOIN greatbarr_fields_groups AS g ON g.id = a.group_id LEFT JOIN `greatbarr_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 ASC346μs8.47KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `greatbarr_modules` AS `m` LEFT JOIN `greatbarr_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `greatbarr_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.15ms2.22KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 `greatbarr_content` AS `a` LEFT JOIN `greatbarr_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `greatbarr_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `greatbarr_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `greatbarr_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `greatbarr_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `greatbarr_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`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.modified DESC, a.created DESC LIMIT 44.2ms24.84KBParams/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 `greatbarr_categories` AS `s` INNER JOIN `greatbarr_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`374μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `greatbarr_categories` AS `s` INNER JOIN `greatbarr_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`201μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `greatbarr_categories` AS `s` INNER JOIN `greatbarr_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`187μs5.14KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `greatbarr_categories` AS `s` INNER JOIN `greatbarr_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`268μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `greatbarr_scheduler_tasks` AS `a` WHERE `a`.`state` = 1124μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `greatbarr_session` WHERE `session_id` = ?91μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • INSERT INTO `greatbarr_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)290μs864BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch
info