The Royal Town of Sutton Coldfield was governed by the Warden and Society, a body of twenty-five men equivalent to a Mayor and Corporation. Their rule came under the scrutiny of the Court of Chancery, and the court issued an order in 1824 setting out how the income of the town was to be spent in the best interests of the populace. This order included a provision that £31 per annum must be paid for the services of a surgeon to vaccinate the children.

Parish registers for Sutton were kept from 1565, recording all the baptisms, marriages and burials. For two and a half centuries, every third burial recorded was that of a child, and this was a relatively healthy town - in many places the rate of infant mortality was higher still. The appointment of the surgeon in 1824 improved the situation in Sutton, along with some of the other provisions of the Order - “childbed linen is provided for the use of the poor married women, and a surgeon to attend them in childbed” declared the Town Clerk in 1855.

As the population of Sutton grew, so public health became more of an issue, with declining water quality and the town’s stream, the E Brook, resembling an open sewer in the 1870s. When the Borough of Sutton Coldfield was established with a new Charter and an elected corporation in 1885, a Medical Officer of Health was appointed, and his annual reports show that pure water, good drainage and dry houses were achieving much better public health.

Illness created great misery for those who could not afford doctors’ fees or the price of drugs, but from the late Victorian period most Suttonians paid an annual subscription to the Provident Dispensary. Many of the Sutton doctors gave part of their time to consultations at the dispensary, which stood on the corner of Rectory Road and Coleshill Road, and the medicines they prescribed were dispensed there. Finally, in 1946, a maternity hospital was set up in a converted mansion at Oakhurst in Anchorage Road, and high rates of infant mortality became a thing of the past.

oakhurst.png
Oakhurst maternity hospital.
10.663MBMemory Usage679msRequest Duration
Joomla! Version5.2.5
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
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743910675 "last" => 1743910675...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (342.71KB) (57.16ms)
  • afterInitialise (3.37MB) (284ms)
  • afterRoute (597.51KB) (24ms)
  • beforeRenderComponent com_content (170.8KB) (10.13ms)
  • Before Access::preloadComponents (all components) (34.8KB) (4.19ms)
  • After Access::preloadComponents (all components) (141.78KB) (1.11ms)
  • Before Access::preloadPermissions (com_content) (1.95KB) (17μs)
  • After Access::preloadPermissions (com_content) (733.91KB) (2.67ms)
  • Before Access::getAssetRules (id:2241 name:com_content.article.1952) (34.65KB) (70μs)
  • After Access::getAssetRules (id:2241 name:com_content.article.1952) (7.25KB) (744μs)
  • afterRenderComponent com_content (1.58MB) (81.21ms)
  • afterDispatch (8.47KB) (2.82ms)
  • beforeRenderRawModule mod_footer (Copyright) (229.12KB) (12.41ms)
  • afterRenderRawModule mod_footer (Copyright) (6.14KB) (2.75ms)
  • beforeRenderModule mod_footer (Copyright) (720B) (12μs)
  • afterRenderModule mod_footer (Copyright) (71.88KB) (946μs)
  • beforeRenderRawModule mod_menu (Support) (2.52KB) (426μs)
  • afterRenderRawModule mod_menu (Support) (63.12KB) (7.6ms)
  • beforeRenderModule mod_menu (Support) (704B) (12μs)
  • afterRenderModule mod_menu (Support) (3.08KB) (224μs)
  • beforeRenderRawModule mod_articles_categories (History Spot) (2.2KB) (111μs)
  • afterRenderRawModule mod_articles_categories (History Spot) (329.88KB) (12.81ms)
  • beforeRenderModule mod_articles_categories (History Spot) (720B) (11μs)
  • afterRenderModule mod_articles_categories (History Spot) (5.67KB) (596μs)
  • beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (102μs)
  • afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (162.3KB) (5.23ms)
  • beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (5μs)
  • afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (300μs)
  • beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (71μs)
  • afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (3.26ms)
  • beforeRenderModule mod_icmsocial (Social Links) (720B) (6μs)
  • afterRenderModule mod_icmsocial (Social Links) (6.98KB) (286μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (68μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.04KB) (1.23ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.19KB) (103μs)
  • beforeRenderRawModule mod_menu (NavBar) (1.18KB) (59μs)
  • afterRenderRawModule mod_menu (NavBar) (405.81KB) (10.45ms)
  • beforeRenderModule mod_menu (NavBar) (704B) (5μs)
  • afterRenderModule mod_menu (NavBar) (6.64KB) (135μs)
  • beforeRenderRawModule mod_login (Members) (2.83KB) (19μs)
  • afterRenderRawModule mod_login (Members) (98.14KB) (5.19ms)
  • beforeRenderModule mod_login (Members) (704B) (5μs)
  • afterRenderModule mod_login (Members) (4.83KB) (127μs)
  • beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (22μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (59.12KB) (9.56ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (6μs)
  • afterRenderModule mod_finder (Smart Search Module) (3.11KB) (140μs)
  • afterRender (1.55MB) (135ms)
  • 1 x afterInitialise (3.37MB) (41.86%)
    284ms
    1 x afterRender (1.55MB) (19.82%)
    135ms
    1 x afterRenderComponent com_content (1.58MB) (11.96%)
    81.21ms
    1 x afterLoad (342.71KB) (8.42%)
    57.16ms
    1 x afterRoute (597.51KB) (3.53%)
    24.00ms
    1 x afterRenderRawModule mod_articles_categories (History Spot) (329.88KB) (1.89%)
    12.81ms
    1 x beforeRenderRawModule mod_footer (Copyright) (229.12KB) (1.83%)
    12.41ms
    1 x afterRenderRawModule mod_menu (NavBar) (405.81KB) (1.54%)
    10.45ms
    1 x beforeRenderComponent com_content (170.8KB) (1.49%)
    10.13ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (59.12KB) (1.41%)
    9.56ms
    1 x afterRenderRawModule mod_menu (Support) (63.12KB) (1.12%)
    7.60ms
    1 x afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (162.3KB) (0.77%)
    5.23ms
    1 x afterRenderRawModule mod_login (Members) (98.14KB) (0.76%)
    5.19ms
    1 x Before Access::preloadComponents (all components) (34.8KB) (0.62%)
    4.19ms
    1 x afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (0.48%)
    3.26ms
    1 x afterDispatch (8.47KB) (0.41%)
    2.82ms
    1 x afterRenderRawModule mod_footer (Copyright) (6.14KB) (0.41%)
    2.75ms
    1 x After Access::preloadPermissions (com_content) (733.91KB) (0.39%)
    2.67ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.04KB) (0.18%)
    1.23ms
    1 x After Access::preloadComponents (all components) (141.78KB) (0.16%)
    1.11ms
    1 x afterRenderModule mod_footer (Copyright) (71.88KB) (0.14%)
    946μs
    1 x After Access::getAssetRules (id:2241 name:com_content.article.1952) (7.25KB) (0.11%)
    744μs
    1 x afterRenderModule mod_articles_categories (History Spot) (5.67KB) (0.09%)
    596μs
    1 x beforeRenderRawModule mod_menu (Support) (2.52KB) (0.06%)
    426μs
    1 x afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (0.04%)
    300μs
    1 x afterRenderModule mod_icmsocial (Social Links) (6.98KB) (0.04%)
    286μs
    1 x afterRenderModule mod_menu (Support) (3.08KB) (0.03%)
    224μs
    1 x afterRenderModule mod_finder (Smart Search Module) (3.11KB) (0.02%)
    140μs
    1 x afterRenderModule mod_menu (NavBar) (6.64KB) (0.02%)
    135μs
    1 x afterRenderModule mod_login (Members) (4.83KB) (0.02%)
    127μs
    1 x beforeRenderRawModule mod_articles_categories (History Spot) (2.2KB) (0.02%)
    111μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.19KB) (0.02%)
    103μs
    1 x beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (0.02%)
    102μs
    1 x beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (0.01%)
    71μs
    1 x Before Access::getAssetRules (id:2241 name:com_content.article.1952) (34.65KB) (0.01%)
    70μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (0.01%)
    68μs
    1 x beforeRenderRawModule mod_menu (NavBar) (1.18KB) (0.01%)
    59μs
    1 x beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_login (Members) (2.83KB) (0%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.95KB) (0%)
    17μs
    1 x beforeRenderModule mod_footer (Copyright) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (Support) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_articles_categories (History Spot) (720B) (0%)
    11μs
    1 x beforeRenderModule mod_icmsocial (Social Links) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (NavBar) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_login (Members) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    4μs
67 statements were executed, 17 of which were duplicates, 50 unique22.31ms334.95KB
  • SELECT @@SESSION.sql_mode;79μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `mnjcl_session` WHERE `session_id` = ?126μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = :session_id LIMIT 187μ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)381μs944BParams/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` = 1400μs17.86KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mnjcl_viewlevels`173μ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` = :guest174μ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`1.01ms5.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `mnjcl_admintools_storage` WHERE `key` = 'cparams'154μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `mnjcl_admintools_wafexceptions`124μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'215μ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;102μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:53Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.191.148.200' AND `hackcount` >= 3127μs536B/plugins/system/marcosinterceptor/marcosinterceptor.php:61Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.191.148.200' AND `hackcount` >= 3137μ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`776μ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`416μs4.08KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `mnjcl_content` WHERE `alias` = :segment AND `catid` = :id151μs2.59KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM `mnjcl_languages` WHERE `published` = 1 ORDER BY `ordering` ASC161μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • 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` = 1265μs848B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • 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)618μ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` = 01.06ms69.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `mnjcl_content`532μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `mnjcl_content` SET `hits` = (`hits` + 1) WHERE `id` = '1952'424μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `mnjcl_content` AS `a` INNER JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_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)338μs6.12KBParams/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 `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`569μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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)242μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `name` FROM `mnjcl_extensions` WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'147μ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`398μ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 ASC807μ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` = :itemid229μ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`450μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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)280μs4.55KB/plugins/system/picasaupdater/src/Extension/PicasaUpdater.php:79Copy
  • SELECT `alias` FROM `mnjcl_content` WHERE `id` = :id130μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `mnjcl_content` WHERE `id` = :id76μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `mnjcl_content` WHERE `id` = :id129μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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`830μs18.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`508μs4.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`389μ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`283μ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`317μ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`305μ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`322μ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`369μ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`346μ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`279μ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`278μ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`349μ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`371μ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`323μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • select SUM(count) from mnjcl_visitors_country210μs536B/modules/mod_jsvisit_counter/helper.php:73Copy
  • select count(*) from mnjcl_visitors_country where count>0105μs536B/modules/mod_jsvisit_counter/helper.php:81Copy
  • SELECT country, name, count FROM mnjcl_visitors_country ORDER BY count DESC LIMIT 5243μs720B/modules/mod_jsvisit_counter/helper.php:85Copy
  • select count from mnjcl_visitors where id = '7'544μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'81μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '1'59μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '1'69μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '7'188μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'266μ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`552μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 11.13ms672B/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)268μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `mnjcl_schemaorg` WHERE `itemId` = :itemId AND `context` = :context307μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `mnjcl_content` AS `a` INNER JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_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)399μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `mnjcl_content` AS `a` INNER JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_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)269μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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` = 1188μs12.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` = ?483μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch