Sutton Coldfield Local History Research Group

Regular meeting, Tuesday - Sutton Coldfield Library (2.00pm to 4.30pm)
Title Published Date Author Hits
sdc10681.png
Machin & Co

Machin And Co Council House [263]

A Select Committee of the House of Commons inquired into the merits of two proposed railway lines from the fourth to the seventh of July 1859. Witnesses from Sutton and Erdington came and testified, giving evidence in favour either the “Birmingham...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 262
sdc10735_edited.png
Mill Pools

Mill Pools [273]

When first built, the mill pond at New Hall Mill was fed by water from a leat which carried the whole flow of the E brook. The next mill down the valley, at Penns, built at about the same time in the 1580s, almost certainly used the same method, d...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 162
sdc10665.png
New Hall Mill 1825

New Hall Mill 1825 [256]

Shortly after Charles Chadwick inherited the New Hall Estate a survey was taken. The property surveyed included three farms, some cottages, and New Hall Mill. This was in February 1795, when William Twamley held the lease of the mill, the third of...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 218
119_horse-drawn-omnibus_1895.png
Omnibuses And Wagons

Omnibuses [271]

For most people wishing to go from Sutton to Birmingham in 1814 the choice was either to walk or to ride in someone’s cart. Sarah Holbeche noted “1814 the carter’s cart became a caravan (i.e. a covered wagon) - the only conveyanc...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 153
park_1779_edited.png
Park Gates

Park Gates [245]

A survey of Sutton Park, made in 1779, shows that the boundary fence had nine gates. Only four of the gates lead into the park from Sutton, the other five give access from the neighbouring Staffordshire parishes of Perry Barr and Great Barr - op...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 167
hunting_sutton_park_edited.png
Parkies

Parkies [269]

Sutton Coldfield was still a rural place in 1800 with a population of 2,800. This was almost double the estimated figure for the year 1700, but not enough to change the rural character of the town - the population of the nearby industrial towns wa...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 172
2013-03-28-2148-44.png
Private Schools

Private Schools [254]

Allerton College was the largest secondary school for girls in Sutton in 1900, most of the others being private houses adapted for use as schools. On the opposite side of Lichfield Road from Allerton College was Iona Cottage, now 69 Lichfield Road...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 169
sdc10747.png
Reading Room

Reading Room [277]

The old town hall (or moot hall) of Sutton Coldfield, built by Bishop Vesey in 1529, stood at the junction of Mill Street, High Street and Coleshill Street. It was declared unsafe and demolished in 1854, when Sarah Holbeche commented in her diary,...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 163
sdc10475.png
Red Way Cop

Red Way Cop [249]

Langley Hall was an important place in the thirteenth century, home of the De Bereford family, statesmen who often had to travel. Bulls Lane and Ox Leys Road were their routes to Coleshill, Warwick, and London, while in the other direction their r...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 159
town_hall.png
Riot

Riot [279]

The Corporation (Warden and Society) of Sutton Coldfield held its monthly meetings in the Moot Hall. By the 1850s the ancient structure was showing signs of collapse, and the Warden’s Minutes for 1854 show increasing concern; in April it was...

  • History Spot
  • Articles 241-280
(SCLHRG) Hits: 173
J! InfoRequestSessionProfileQueries73Log2
Settings11.209MBMemory Usage903msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.28
Identityguest
Response200
Templatesclhrg_2024
Database
Server
mysql
Version
10.6.21-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "start" => "20" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:59 [ "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745630788 "last" => 1745630788...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (339.64KB) (94.87ms)
  • afterInitialise (3.3MB) (345ms)
  • afterRoute (658.18KB) (24.51ms)
  • beforeRenderComponent com_content (103.58KB) (10.96ms)
  • Before Access::preloadComponents (all components) (106.41KB) (8.18ms)
  • After Access::preloadComponents (all components) (142.83KB) (1.15ms)
  • Before Access::preloadPermissions (com_content) (1.95KB) (16μs)
  • After Access::preloadPermissions (com_content) (734.65KB) (2.32ms)
  • Before Access::getAssetRules (id:632 name:com_content.category.107) (34.65KB) (72μs)
  • After Access::getAssetRules (id:632 name:com_content.category.107) (7.25KB) (744μs)
  • afterRenderComponent com_content (2.06MB) (161ms)
  • afterDispatch (11.46KB) (3.6ms)
  • beforeRenderRawModule mod_footer (Copyright) (194.98KB) (17.58ms)
  • afterRenderRawModule mod_footer (Copyright) (70.14KB) (1.75ms)
  • beforeRenderModule mod_footer (Copyright) (720B) (6μs)
  • afterRenderModule mod_footer (Copyright) (3.56KB) (615μs)
  • beforeRenderRawModule mod_menu (Support) (2.52KB) (308μs)
  • afterRenderRawModule mod_menu (Support) (127.24KB) (6.49ms)
  • beforeRenderModule mod_menu (Support) (704B) (11μs)
  • afterRenderModule mod_menu (Support) (3.08KB) (221μs)
  • beforeRenderRawModule mod_articles_categories (History Spot) (2.2KB) (111μs)
  • afterRenderRawModule mod_articles_categories (History Spot) (331.3KB) (28.11ms)
  • beforeRenderModule mod_articles_categories (History Spot) (720B) (12μs)
  • afterRenderModule mod_articles_categories (History Spot) (5.67KB) (651μs)
  • beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (119μs)
  • afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (113.05KB) (4.76ms)
  • beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (8μs)
  • afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (450μs)
  • beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (117μs)
  • afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (1.51ms)
  • beforeRenderModule mod_icmsocial (Social Links) (720B) (8μs)
  • afterRenderModule mod_icmsocial (Social Links) (6.98KB) (387μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (102μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.79KB) (1.74ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (8μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (171μs)
  • beforeRenderRawModule mod_menu (NavBar) (1.18KB) (104μs)
  • afterRenderRawModule mod_menu (NavBar) (474.08KB) (21.38ms)
  • beforeRenderModule mod_menu (NavBar) (704B) (14μs)
  • afterRenderModule mod_menu (NavBar) (6.64KB) (230μs)
  • beforeRenderRawModule mod_login (Members) (2.83KB) (36μs)
  • afterRenderRawModule mod_login (Members) (24.68KB) (33.69ms)
  • beforeRenderModule mod_login (Members) (704B) (25μs)
  • afterRenderModule mod_login (Members) (4.33KB) (185μs)
  • beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (31μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (117.72KB) (11.45ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (8μs)
  • afterRenderModule mod_finder (Smart Search Module) (3.11KB) (171μs)
  • afterRender (1.45MB) (116ms)
  • 1 x afterInitialise (3.3MB) (38.22%)
    345ms
    1 x afterRenderComponent com_content (2.06MB) (17.88%)
    161ms
    1 x afterRender (1.45MB) (12.8%)
    116ms
    1 x afterLoad (339.64KB) (10.51%)
    94.87ms
    1 x afterRenderRawModule mod_login (Members) (24.68KB) (3.73%)
    33.69ms
    1 x afterRenderRawModule mod_articles_categories (History Spot) (331.3KB) (3.11%)
    28.11ms
    1 x afterRoute (658.18KB) (2.71%)
    24.51ms
    1 x afterRenderRawModule mod_menu (NavBar) (474.08KB) (2.37%)
    21.38ms
    1 x beforeRenderRawModule mod_footer (Copyright) (194.98KB) (1.95%)
    17.58ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (117.72KB) (1.27%)
    11.45ms
    1 x beforeRenderComponent com_content (103.58KB) (1.21%)
    10.96ms
    1 x Before Access::preloadComponents (all components) (106.41KB) (0.91%)
    8.18ms
    1 x afterRenderRawModule mod_menu (Support) (127.24KB) (0.72%)
    6.49ms
    1 x afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (113.05KB) (0.53%)
    4.76ms
    1 x afterDispatch (11.46KB) (0.4%)
    3.60ms
    1 x After Access::preloadPermissions (com_content) (734.65KB) (0.26%)
    2.32ms
    1 x afterRenderRawModule mod_footer (Copyright) (70.14KB) (0.19%)
    1.75ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.79KB) (0.19%)
    1.74ms
    1 x afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (0.17%)
    1.51ms
    1 x After Access::preloadComponents (all components) (142.83KB) (0.13%)
    1.15ms
    1 x After Access::getAssetRules (id:632 name:com_content.category.107) (7.25KB) (0.08%)
    744μs
    1 x afterRenderModule mod_articles_categories (History Spot) (5.67KB) (0.07%)
    651μs
    1 x afterRenderModule mod_footer (Copyright) (3.56KB) (0.07%)
    615μs
    1 x afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (0.05%)
    450μs
    1 x afterRenderModule mod_icmsocial (Social Links) (6.98KB) (0.04%)
    387μs
    1 x beforeRenderRawModule mod_menu (Support) (2.52KB) (0.03%)
    308μs
    1 x afterRenderModule mod_menu (NavBar) (6.64KB) (0.03%)
    230μs
    1 x afterRenderModule mod_menu (Support) (3.08KB) (0.02%)
    221μs
    1 x afterRenderModule mod_login (Members) (4.33KB) (0.02%)
    185μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (0.02%)
    171μs
    1 x afterRenderModule mod_finder (Smart Search Module) (3.11KB) (0.02%)
    171μs
    1 x beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (0.01%)
    119μs
    1 x beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (0.01%)
    117μs
    1 x beforeRenderRawModule mod_articles_categories (History Spot) (2.2KB) (0.01%)
    111μs
    1 x beforeRenderRawModule mod_menu (NavBar) (1.18KB) (0.01%)
    104μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (0.01%)
    102μs
    1 x Before Access::getAssetRules (id:632 name:com_content.category.107) (34.65KB) (0.01%)
    72μs
    1 x beforeRenderRawModule mod_login (Members) (2.83KB) (0%)
    36μs
    1 x beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (0%)
    31μs
    1 x beforeRenderModule mod_login (Members) (704B) (0%)
    25μs
    1 x Before Access::preloadPermissions (com_content) (1.95KB) (0%)
    16μs
    1 x beforeRenderModule mod_menu (NavBar) (704B) (0%)
    14μs
    1 x beforeRenderModule mod_articles_categories (History Spot) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (Support) (704B) (0%)
    11μs
    1 x beforeRenderModule mod_icmsocial (Social Links) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (0%)
    8μs
    1 x beforeRenderModule mod_footer (Copyright) (720B) (0%)
    6μs
73 statements were executed, 11 of which were duplicates, 62 unique71.47ms415.77KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;2.92ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `mnjcl_session` WHERE `session_id` = ?158μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = :session_id LIMIT 1945μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `mnjcl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)24.04ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `mnjcl_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1883μs17.86KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mnjcl_viewlevels`609μs672B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `mnjcl_usergroups` AS `a` LEFT JOIN `mnjcl_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest252μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `mnjcl_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`3.08ms5.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `mnjcl_admintools_storage` WHERE `key` = 'cparams'475μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `mnjcl_admintools_wafexceptions`291μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'663μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • DELETE FROM `mnjcl_mi_iptable` WHERE DATE_ADD(`lasthacktime`, INTERVAL 300 SECOND) < NOW() AND `autodelete`=1;495μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:53Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.117.194.238' AND `hackcount` >= 3157μs536B/plugins/system/marcosinterceptor/marcosinterceptor.php:61Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.117.194.238' AND `hackcount` >= 3514μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:65Copy
  • 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 `mnjcl_menu` AS `m` LEFT JOIN `mnjcl_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`746μs68.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`419μs4.08KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `mnjcl_languages` WHERE `published` = 1 ORDER BY `ordering` ASC207μs2.84KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `mnjcl_template_styles` AS `s` LEFT JOIN `mnjcl_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` = 1302μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `mnjcl_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51)590μs7.94KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `mnjcl_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0948μs69.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` FROM `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`397μs3.89KBParams/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 `mnjcl_content` AS `a` LEFT JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_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`.`catid` = :categoryId OR `a`.`catid` IN ( SELECT `sub`.`id` FROM `mnjcl_categories` AS `sub` INNER JOIN `mnjcl_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt` WHERE `this`.`id` = :subCategoryId)) 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.title, a.created LIMIT 20, 105.07ms71.16KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `mnjcl_contentitem_tag_map` AS `m` INNER JOIN `mnjcl_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,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `t`.`access` IN (:preparedArray11,:preparedArray12)360μs4.84KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT COUNT(*) FROM `mnjcl_content` AS `a` LEFT JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_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`.`catid` = :categoryId OR `a`.`catid` IN ( SELECT `sub`.`id` FROM `mnjcl_categories` AS `sub` INNER JOIN `mnjcl_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt` WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)2.9ms5.59KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:197Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `mnjcl_contentitem_tag_map` AS `m` INNER JOIN `mnjcl_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)281μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `name` FROM `mnjcl_extensions` WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'219μs536B/administrator/components/com_eventgallery/version.php:26Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`2.97ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `mnjcl_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC889μs4.83KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid233μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid200μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid192μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid215μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid195μs3.88KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid183μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid150μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid194μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid178μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `field_id`,`value` FROM `mnjcl_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid113μs1.38KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`372μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT article.id,'https://sclhrg.jonessoft.co.uk/history-spot/articles-241-280.html?start=20\n[150] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.getResults\n[ 80] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `mnjcl_content` AS `article` WHERE `article`.`catid` = 107 AND `article`.`state` = 1338μs1.19KB/plugins/system/articlesanywhere/src/Database.php:115Copy
  • 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 mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,: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 ASC1.02ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`474μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `mnjcl_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC728μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT folder.* FROM `mnjcl_eventgallery_folder` AS folder LEFT JOIN `mnjcl_eventgallery_file` AS file ON folder.folder = file.folder and file.published=1 and file.ismainimage=0 WHERE file.file IS NULL AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4 OR folder.foldertypeid=5)307μs4.55KB/plugins/system/picasaupdater/src/Extension/PicasaUpdater.php:79Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `mnjcl_modules` AS `m` LEFT JOIN `mnjcl_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `mnjcl_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`1.02ms18.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`4.03ms4.13KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.24ms3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`386μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`426μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`466μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`459μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`445μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`432μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`442μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`601μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`444μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`461μs3.94KBParams/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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`428μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • select SUM(count) from mnjcl_visitors_country227μs536B/modules/mod_jsvisit_counter/helper.php:73Copy
  • select count(*) from mnjcl_visitors_country where count>0156μs536B/modules/mod_jsvisit_counter/helper.php:81Copy
  • SELECT country, name, count FROM mnjcl_visitors_country ORDER BY count DESC LIMIT 5188μs720B/modules/mod_jsvisit_counter/helper.php:85Copy
  • select count from mnjcl_visitors where id = '7'111μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'83μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '1'99μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '1'88μs11.04KB/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '7'105μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'78μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_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`589μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1531μs672B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `mnjcl_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)275μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • 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 `mnjcl_scheduler_tasks` AS `a` WHERE `a`.`state` = 1224μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = ?181μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `mnjcl_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?394μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch