Great Barr Past and Present

Scott Arms - Shopping Centre

Walsall Road 936-970(Sandwell) B42 1LS

The Scott Arms Shopping Centre was created after the demolition of the old Scott Arms in the 1970's.

Coop at Scott Arms

936

  • Iceland
  • Kwik Save

 

938-40

  • Well+ Pharmacy (Bestway group purchased the Co-op pharmacy chain in July 2014. Store rebranded to Well in September 2015)
  • Co-op Pharmacy

 

942

  • Acorns, charity shop

 

944

  • Greggs, cakes and sandwiches

 

946-8

  • Ladbrokes Betting Office (7th August 2010-)

946 

  • empty (end March 2010-July 2010 ) then combined with 948
  • Walter Smith, butcher (to March 2010)

948

  • empty (December 2009-July 2010) then combined with 946
  • Super Sava Stores (November 2005-December 2009)
  • Supercigs

 

950

  • Salon 950 (September 2022-)
  • Rashae, hairdresser (April 2009-September 2022)
  • Kyle James, hairdresser (-April 2009)

 

Kyle James

 ,

952

  • Cashino Amusement Arcade (by 2010)
  • Shipleys Amusement Arcade (2008-)
  • Tranters - Jewellers (From opening of centre to 21st January 2006)

 

954

  • Turkish barbers (May 2019-)
  • Scott Furnishings - Carpets (-2017)

 

956

  • XC Nails and Spa (23 March 2024-)
  • Cross Point Hub (January 2017-) http://www.crosspointchurchbham.org/
  • Loan Against Your Car (March 2013-) financial services
  • Munchy Mo's (September 2010-) takeaway
  • B&M Kebabs (Aug 2009-) takeaway
  • Mimmo, Fish and Chips (May 2009-Jul 2009 - may have never opened)
  • Al Fresco pizzas, (Fitted out March 2008, may have opened September 2008)
  • Midland Schoolwear (to May 2007) - moved across Walsall Road

Al-Freaco Takaway being fitted out March 2008

 

958

  • Sue Ryder - Charity Shop (3rd February 2011-) opened by Blind Dave Heeley
  •  Empty (June 2010-January 2011)
  • Wilkinsons - hardware (- June 2010)

 

960

  • Bet Fred, betting shop
  • Cagneys, Cafe (April 2012-late 2013)
  • Planned Domino Pizza, takeaway (May 2011), never opened
  • 1st Choice - greengrocers (April 2007-September 2010)
  • Stokes - greengrocers (-March 2007)


 

962

  • Combined with 964 Domino's Pizza (8th September 2017-)
  • Oxfam - charity shop (to May 2017)


 

964

  • Combined with 962 June 2017
  • Colin Lee - opticians (-2014) moved to Newton Road

 

 

966

  • Card Factory (September 2017-)
  • Subway- sandwiches (October 2006-c.June2017)
  • Firkins - bakers (to June 2006), was previously on opposite side of Walsall Road.

subway

 

968

  • Kings, hairdresser (June 2013-March 2015)
  • empty (Oct 2012-June 2013)
  • BTG - Bowen Travel Group (2012- October 2012)
  • First Choice, travel agent, (re-signed 20/12/06)
  • Bowens, travel agent
  • ---- Travel, travel agent

 

970

  • Dignity- funeral directors (June 2017 planned)
  • Money Shop (October 2010-)
  • empty (August/September 2010)
  • Ladbrokes, betting shop (to 6/8/2010 when moved to 946-8)

Ladbrooks

 

Scott Arms Public House

see The Scott Arms Public House

Latest updated pages

J! InfoRequestSessionProfileQueries28Log2
19.772MBMemory Usage92.86msRequest Duration
Joomla! Version4.4.6
PHP Version8.1.32
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:49 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743482628 "last" => 1743482628...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.13MB) (13.05ms)
  • afterInitialise (7.43MB) (31.82ms)
  • afterRoute (1.29MB) (4.1ms)
  • beforeRenderComponent com_content (1MB) (5ms)
  • Before Access::preloadComponents (all components) (449.18KB) (2.16ms)
  • After Access::preloadComponents (all components) (114.05KB) (611μs)
  • Before Access::preloadPermissions (com_content) (3.98KB) (9μs)
  • After Access::preloadPermissions (com_content) (410.45KB) (986μs)
  • Before Access::getAssetRules (id:155 name:com_content.article.78) (34.8KB) (30μs)
  • After Access::getAssetRules (id:155 name:com_content.article.78) (26.93KB) (194μs)
  • afterRenderComponent com_content (2.52MB) (15.38ms)
  • afterDispatch (7.11KB) (115μs)
  • beforeRenderRawModule mod_menu (Main Menu) (634.72KB) (3.44ms)
  • afterRenderRawModule mod_menu (Main Menu) (365.2KB) (3.03ms)
  • beforeRenderRawModule mod_menu (Shops) (832B) (28μs)
  • afterRenderRawModule mod_menu (Shops) (464.92KB) (1.95ms)
  • beforeRenderRawModule mod_articles_latest (Latest updated pages) (880B) (22μs)
  • Before Access::getAssetRules (id:8 name:com_content) (208.41KB) (1.08ms)
  • After Access::getAssetRules (id:8 name:com_content) (7.05KB) (20μs)
  • afterRenderRawModule mod_articles_latest (Latest updated pages) (75.49KB) (6.12ms)
  • beforeRenderRawModule mod_custom (copyright) (480B) (31μs)
  • afterRenderRawModule mod_custom (copyright) (8.48KB) (226μs)
  • beforeRenderModule mod_custom (copyright) (39.59KB) (289μs)
  • afterRenderModule mod_custom (copyright) (2.84KB) (79μs)
  • beforeRenderModule mod_articles_latest (Latest updated pages) (288B) (21μs)
  • afterRenderModule mod_articles_latest (Latest updated pages) (4.66KB) (80μs)
  • beforeRenderModule mod_menu (Shops) (2.71KB) (34μs)
  • afterRenderModule mod_menu (Shops) (2.93KB) (58μs)
  • beforeRenderModule mod_menu (Main Menu) (96B) (18μs)
  • afterRenderModule mod_menu (Main Menu) (5.93KB) (25μs)
  • afterRender (245.97KB) (2.47ms)
  • 1 x afterInitialise (7.43MB) (34.27%)
    31.82ms
    1 x afterRenderComponent com_content (2.52MB) (16.56%)
    15.38ms
    1 x afterLoad (4.13MB) (14.06%)
    13.05ms
    1 x afterRenderRawModule mod_articles_latest (Latest updated pages) (75.49KB) (6.59%)
    6.12ms
    1 x beforeRenderComponent com_content (1MB) (5.38%)
    5.00ms
    1 x afterRoute (1.29MB) (4.42%)
    4.10ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (634.72KB) (3.7%)
    3.44ms
    1 x afterRenderRawModule mod_menu (Main Menu) (365.2KB) (3.27%)
    3.03ms
    1 x afterRender (245.97KB) (2.66%)
    2.47ms
    1 x Before Access::preloadComponents (all components) (449.18KB) (2.33%)
    2.16ms
    1 x afterRenderRawModule mod_menu (Shops) (464.92KB) (2.09%)
    1.95ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (208.41KB) (1.17%)
    1.08ms
    1 x After Access::preloadPermissions (com_content) (410.45KB) (1.06%)
    986μs
    1 x After Access::preloadComponents (all components) (114.05KB) (0.66%)
    611μs
    1 x beforeRenderModule mod_custom (copyright) (39.59KB) (0.31%)
    289μs
    1 x afterRenderRawModule mod_custom (copyright) (8.48KB) (0.24%)
    226μs
    1 x After Access::getAssetRules (id:155 name:com_content.article.78) (26.93KB) (0.21%)
    194μs
    1 x afterDispatch (7.11KB) (0.12%)
    115μs
    1 x afterRenderModule mod_articles_latest (Latest updated pages) (4.66KB) (0.09%)
    80μs
    1 x afterRenderModule mod_custom (copyright) (2.84KB) (0.09%)
    79μs
    1 x afterRenderModule mod_menu (Shops) (2.93KB) (0.06%)
    58μs
    1 x beforeRenderModule mod_menu (Shops) (2.71KB) (0.04%)
    34μs
    1 x beforeRenderRawModule mod_custom (copyright) (480B) (0.03%)
    31μs
    1 x Before Access::getAssetRules (id:155 name:com_content.article.78) (34.8KB) (0.03%)
    30μs
    1 x beforeRenderRawModule mod_menu (Shops) (832B) (0.03%)
    28μs
    1 x afterRenderModule mod_menu (Main Menu) (5.93KB) (0.03%)
    25μs
    1 x beforeRenderRawModule mod_articles_latest (Latest updated pages) (880B) (0.02%)
    22μs
    1 x beforeRenderModule mod_articles_latest (Latest updated pages) (288B) (0.02%)
    21μs
    1 x After Access::getAssetRules (id:8 name:com_content) (7.05KB) (0.02%)
    20μs
    1 x beforeRenderModule mod_menu (Main Menu) (96B) (0.02%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (3.98KB) (0.01%)
    9μs
28 statements were executed, 2 of which were duplicates, 26 unique12.83ms572.59KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;50μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `greatbarr_session` WHERE `session_id` = ?95μ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` = 1207μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `greatbarr_viewlevels`64μ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` = :guest107μ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`403μ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.47ms396.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `greatbarr_languages` WHERE `published` = 1 ORDER BY `ordering` ASC114μ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` = 1158μ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)348μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `greatbarr_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0454μs45.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `greatbarr_content`974μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `greatbarr_content` SET `hits` = (`hits` + 1) WHERE `id` = '78'681μs48B/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 `greatbarr_content` AS `a` INNER JOIN `greatbarr_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `greatbarr_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `greatbarr_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `greatbarr_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `greatbarr_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)298μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `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`361μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_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 `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1)236μs5.2KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `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`366μs7.66KBParams/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 ASC224μs5.97KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `greatbarr_content` AS `a` LEFT JOIN `greatbarr_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY `a`.`title`452μs3.25KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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`682μs2.25KBParams/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 43.61ms24.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`317μ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`188μ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`178μ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`260μ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` = 1206μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `greatbarr_session` WHERE `session_id` = ?72μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • INSERT INTO `greatbarr_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)258μs864BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch
info