When considering the history of the Red House it is important to start with a brief summary of the two important Great Barr families with links to the Red House. The following information has been out together from varous sources and any corrections would be welcomed.

The Scott family has been living in the area since about 1332, although it was not until 1791 that a Scott became Lord of the Manor when Joseph Scott inherited the Manor from the Hoo family. The Scott Arms had been granted in 1663. Joseph resided at Great Barr Hall which was originally called the ‘Netherhouse’ and had been in the Scott family since the early 17th century when Richard Scott moved there. Joseph re-built and extended the Hall in 1777. Joseph Scott was created a baronet in 1806. Great Barr Hall was the main Scott residence (apart from in the late 1700’s when it was leased to Samuel Galton) until the death of Lady Mildred Scott in 1909. It is mainly the Scotts who lived at Stourbridge and Ratlinghope (Shropshire) who owned the Red House and numerous estates in Great Barr. The Scotts are still remembered by the Scott Arms shopping centre and public house.

The Addyes’s (also sometimes given as Addis or Addys) who have links with Great Barr since the early 1500’s when Sir Degory Addyes (c.1465-1521) was resident in the area.

The Red House appears to have formed part of the original Addyes estate and became linked with the Scotts by marriage. The family links are given here.

John Addyes of Great Barr married Mary Hopkins of Moor Hall, Warwickshire and had three children:

  •  Thomas Addyes, who married Ann Hopkins and had two children
    •  John Addyes who died young and
    •  Mary Addyes who died unmarried on the 3rd April 1786
  •  Mary Addyes, who married the Rev. John Tonkes of Harbourne, who had one daughter
    •  Anne Tonkes (1731-1813) who married William Scott of Stourbridge
  •  Ann Addyes who married Richard Scott of Little Aston

It would appear that the Red House was probably under the ownership of Thomas Addyes. When he died the estate passed to his daughter Mary and when she died single in 1786 the estate passed to  Anne Scott neé Tonkes.

Anne Scott neé Tonkes (1731 - 8/1/1813)

The earliest written record we have of the Red House is in Anne’s obituary of 1813 from “The Gentleman’s Magazine” which stated “Her remains were interred, Jan. 18, with deserved honours and real grief, at Great Barr, in Staffordshire ; the Red House in which village had long been her country residence”. Thus it appears from 1786 to 1813 the Red House was extensively used as a summer residence, inherited by Anne Scott through her maternal line from the Addyes family. Anne Scott was a benevolent lady well liked in Great Barr and her obituary gave clear indications of her generousness.

“The greater the abundance bestowed on her by a liberal Providence, the more freely did she give to others. Every augmentation of her paternal fortune she employed as an instrument of advancing the happiness of mankind. Her language was, "I am a steward for my Heavenly Master:" and, as she approached the close of a life extended to nearly 83 years, she repeatedly said, " Let it be my care, while I continue here, to do all the service in my power to my fellow-creatures." Her bounty flowed perpetually in almost every conceivable channel. Pure and refreshing, it gladdened the eyes of beholders as well as the feelings of the subjects of it”

Ann Scott died on 8th January 1813. Having no children the estate passed to John Scott.

John Scott (10/1/1763 - 3/1/1832)

Born 10th January 1763 he married Sarah Kettle (born about 1772) in 1795. They had one daughter, Sarah born 10th June 1800. When John Scott died on 3rd January 1832 the estate passed to his wife Sarah and when she died on 7th October 1836 to his daughter, Sarah.

Sarah Scott (10/6/1800 - 21/03/1874)

Sarah Scott married Robert Wellbeloved (15/7/1803 - 21/2/1856) in 1830. Robert changed his name to Scott by deed poll.

It was Robert who built the current Red House. He was the Liberal member member for Walsall, and retained his seat in Parliament until 1847.

They had four children:

  •  Sarah Emma Scott (c.1830 - ?)
  •  John Charles Addyes Scott (29/12/1830 - 15/1/1888)
  •  Mary Laetitia Scott (c.8/3/1834 - (c.9/4/1835)
  • Elizabeth Anne Scott ( 31/5/1863) - 18/5/1870)

In 1856 on Roberts death the estate passed to John Charles Addyes Scott

John Charles Addyes Scott (29/12/1830 - 15/1/1888)

John Charles Addyes Scott succeeded his father, Robert Wellbeloved Scott, as Lord of the Manor of Ratlinghope and patron of the living. John Charles was a merchant dealing in nails and chains. He may have been what was known in the Black Country as a 'fogger', who supplied iron sheet or rod to backyard workshops in the region and then collected, and paid for the finished product.

Tradition has it that one day, when walking in Cradley, he heard a woman singing. Her voice was so sweet and beautiful that it tempted him to seek her out and it was Mahlah Homer, singing as she worked in her father's nailshop. She and John Charles became friends, their friendship turned to love and they married on 1 July 1863, when Mahlah was 29. Their only child, James Robert, was born on 31 October 1864. [Information from www.cradleylinks.co.uk]

They had one child James Robert in 1864.

John Charles died in Italy in 1888 and Mahlah died almost 20 years later, in tragic circumstances at Bournemouth. When out driving in a coach with friends on Sunday 2 June 1907, one of the horses stumbled. Mahlah jumped out and fell, being struck on the head by the door. She died two days later, aged 73, and is buried in the churchyard at Ratlinghope.

[Information and photograph from www.cradleylinks.co.uk]

James Robert Addyes Scott (31/10/1864 - 28/2/1912)

who married in 1890 Kate Castelli (c. 1867 - 12/10/1916) . They are both buried at Ratlinghope.

Robert Scott
Picture of John Addyes courtesy www.cradleylinks.co.uk

Following their deaths the estate was sold by auction on 30th June 1920

Copyright 2009-2025 Anthony Lewis www.b43.co.uk

17.683MBMemory Usage100msRequest Duration
Joomla! Version4.4.11
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" => 1743806516 "last" => 1743806516...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.11MB) (13.44ms)
  • afterInitialise (6.91MB) (35.59ms)
  • afterRoute (324.46KB) (2.45ms)
  • beforeRenderComponent com_content (856.65KB) (5.38ms)
  • Before Access::preloadComponents (all components) (595.97KB) (2.77ms)
  • After Access::preloadComponents (all components) (113.5KB) (1.25ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (12μs)
  • After Access::preloadPermissions (com_content) (79.94KB) (464μs)
  • Before Access::getAssetRules (id:62 name:com_content.article.5) (6.8KB) (13μs)
  • After Access::getAssetRules (id:62 name:com_content.article.5) (26.84KB) (162μs)
  • afterRenderComponent com_content (2.53MB) (20.47ms)
  • afterDispatch (2.28KB) (54μs)
  • beforeRenderRawModule mod_menu (Main Menu) (728.65KB) (4.75ms)
  • afterRenderRawModule mod_menu (Main Menu) (172.8KB) (1.66ms)
  • beforeRenderRawModule mod_menu (History Timeline) (784B) (28μs)
  • afterRenderRawModule mod_menu (History Timeline) (371.38KB) (2.07ms)
  • beforeRenderRawModule mod_articles_latest (Latest updates) (848B) (25μs)
  • afterRenderRawModule mod_articles_latest (Latest updates) (249.23KB) (5.01ms)
  • beforeRenderRawModule mod_custom (Copyright ) (448B) (17μs)
  • afterRenderRawModule mod_custom (Copyright ) (8.54KB) (217μs)
  • beforeRenderModule mod_articles_latest (Latest updates) (23.78KB) (307μs)
  • afterRenderModule mod_articles_latest (Latest updates) (4.37KB) (101μs)
  • beforeRenderModule mod_custom (Copyright ) (616B) (11μs)
  • afterRenderModule mod_custom (Copyright ) (2.2KB) (60μs)
  • beforeRenderModule mod_menu (History Timeline) (2.98KB) (35μs)
  • afterRenderModule mod_menu (History Timeline) (5.95KB) (54μs)
  • beforeRenderModule mod_menu (Main Menu) (32B) (18μs)
  • afterRenderModule mod_menu (Main Menu) (3.59KB) (36μs)
  • afterRender (266.95KB) (3.29ms)
  • 1 x afterInitialise (6.91MB) (35.58%)
    35.59ms
    1 x afterRenderComponent com_content (2.53MB) (20.46%)
    20.47ms
    1 x afterLoad (4.11MB) (13.44%)
    13.44ms
    1 x beforeRenderComponent com_content (856.65KB) (5.38%)
    5.38ms
    1 x afterRenderRawModule mod_articles_latest (Latest updates) (249.23KB) (5.01%)
    5.01ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (728.65KB) (4.75%)
    4.75ms
    1 x afterRender (266.95KB) (3.29%)
    3.29ms
    1 x Before Access::preloadComponents (all components) (595.97KB) (2.77%)
    2.77ms
    1 x afterRoute (324.46KB) (2.45%)
    2.45ms
    1 x afterRenderRawModule mod_menu (History Timeline) (371.38KB) (2.07%)
    2.07ms
    1 x afterRenderRawModule mod_menu (Main Menu) (172.8KB) (1.66%)
    1.66ms
    1 x After Access::preloadComponents (all components) (113.5KB) (1.25%)
    1.25ms
    1 x After Access::preloadPermissions (com_content) (79.94KB) (0.46%)
    464μs
    1 x beforeRenderModule mod_articles_latest (Latest updates) (23.78KB) (0.31%)
    307μs
    1 x afterRenderRawModule mod_custom (Copyright ) (8.54KB) (0.22%)
    217μs
    1 x After Access::getAssetRules (id:62 name:com_content.article.5) (26.84KB) (0.16%)
    162μs
    1 x afterRenderModule mod_articles_latest (Latest updates) (4.37KB) (0.1%)
    101μs
    1 x afterRenderModule mod_custom (Copyright ) (2.2KB) (0.06%)
    60μs
    1 x afterDispatch (2.28KB) (0.05%)
    54μs
    1 x afterRenderModule mod_menu (History Timeline) (5.95KB) (0.05%)
    54μs
    1 x afterRenderModule mod_menu (Main Menu) (3.59KB) (0.04%)
    36μs
    1 x beforeRenderModule mod_menu (History Timeline) (2.98KB) (0.04%)
    35μs
    1 x beforeRenderRawModule mod_menu (History Timeline) (784B) (0.03%)
    28μs
    1 x beforeRenderRawModule mod_articles_latest (Latest updates) (848B) (0.03%)
    25μs
    1 x beforeRenderModule mod_menu (Main Menu) (32B) (0.02%)
    18μs
    1 x beforeRenderRawModule mod_custom (Copyright ) (448B) (0.02%)
    17μs
    1 x Before Access::getAssetRules (id:62 name:com_content.article.5) (6.8KB) (0.01%)
    13μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.01%)
    12μs
    1 x beforeRenderModule mod_custom (Copyright ) (616B) (0.01%)
    11μs
29 statements were executed, 2 of which were duplicates, 27 unique11.21ms195.53KB
  • SELECT @@SESSION.sql_mode;81μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `redhouse_session` WHERE `session_id` = ?93μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `redhouse_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1296μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `redhouse_viewlevels`101μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `redhouse_usergroups` AS `a` LEFT JOIN `redhouse_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest265μs2.27KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `redhouse_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`813μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `redhouse_admintools_storage` WHERE `key` = 'cparams'79μs840B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `redhouse_admintools_wafexceptions`95μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `redhouse_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'137μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • 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 `redhouse_menu` AS `m` LEFT JOIN `redhouse_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`609μs53.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `redhouse_languages` WHERE `published` = 1 ORDER BY `ordering` ASC113μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `redhouse_template_styles` AS `s` LEFT JOIN `redhouse_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` = 1182μs1.13KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `redhouse_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)437μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `redhouse_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0305μs19.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `redhouse_content`1.2ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `redhouse_content` SET `hits` = (`hits` + 1) WHERE `id` = '5'427μ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 `redhouse_content` AS `a` INNER JOIN `redhouse_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `redhouse_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `redhouse_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `redhouse_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `redhouse_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)397μs27.13KBParams/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 `redhouse_categories` AS `s` INNER JOIN `redhouse_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`365μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `redhouse_contentitem_tag_map` AS `m` INNER JOIN `redhouse_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)236μs5.22KBParams/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 `redhouse_categories` AS `s` INNER JOIN `redhouse_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`342μ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 redhouse_fields AS a LEFT JOIN `redhouse_languages` AS l ON l.lang_code = a.language LEFT JOIN redhouse_users AS uc ON uc.id=a.checked_out LEFT JOIN redhouse_viewlevels AS ag ON ag.id = a.access LEFT JOIN redhouse_users AS ua ON ua.id = a.created_user_id LEFT JOIN redhouse_fields_groups AS g ON g.id = a.group_id LEFT JOIN `redhouse_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 ASC301μs6KBParams/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 `redhouse_content` AS `a` LEFT JOIN `redhouse_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY `a`.`title`448μs2.47KBParams/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 `redhouse_modules` AS `m` LEFT JOIN `redhouse_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `redhouse_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`610μ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 `redhouse_content` AS `a` LEFT JOIN `redhouse_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `redhouse_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `redhouse_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `redhouse_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `redhouse_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `redhouse_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) 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 32.01ms24.89KBParams/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 `redhouse_categories` AS `s` INNER JOIN `redhouse_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`339μs5.17KBParams/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 `redhouse_categories` AS `s` INNER JOIN `redhouse_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`319μs5.19KBParams/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 `redhouse_scheduler_tasks` AS `a` WHERE `a`.`state` = 1129μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `redhouse_session` WHERE `session_id` = ?94μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • INSERT INTO `redhouse_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)387μs864BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy