Holy Trinity churchyard c. 1880
Holy Trinity churchyard c. 1880. Pic: Sutton Library

On Thursday, January 27, 1887, Robert Green, aged 58, became a resident of the churchyard of Holy Trinity.

It was said that 'no man living within the radius of the parish (was) more widely known or more genuinely esteemed and beloved for uprightness of character and geniality of disposition: By this time the churchyard was almost full. In 1876 it was decided that interments would soon need to end, but that it 'should not be peremptorily closed but that the closing of the ground should be done quietly and gradually.’ No headstone for Green survives; in fact most of the memorials were cleared in the early 1950s.

So who was the much-admired man? He was the son of William Green, who owned saw mills in Birmingham. Robert became a publican. He held the licence to sell beer (but not spirits or wine) at the Red Lion in Lancaster Street. He was married to Elizabeth, who helped run the beer house. In January 1865 Green gave up the licence of the Red Lion. He was moving - to the Emmanuel College Arms at the top of Mill Street in Sutton Coldfield. The Emmanuel College Arms was so known because the site (and much other land in Sutton) was owned by Emmanuel College, Cambridge. The tavern was built in the 18th century and was known at that time as the Sun.

For many years the landlord was Robert Betts who, after his death, was succeeded by his widow Martha: she died in April 1865. Between them Robert and Elizabeth Green were to run the College Arms for 33 years. This was to be the heyday of the tavern. Elizabeth Green had an excellent reputation as a caterer, and many clubs held their annual dinners there, enjoying meals 'of a substantial character ... being very well cooked: It was also the meeting place of a club devoted to killing sparrows on the grounds that they damaged crops.

Green had to be prepared to eject men who were drunk - otherwise he would have lost his licence. If they re-fused to leave he summoned a police constable. After Elizabeth Green left, the College Arms went into decline. Built in the 18th century, its rooms were deemed too small. By 1909 it was dilapidated and was demolished. A dental practice now standson the site.

• Glimpses into Sutton's Past Parts I-Ill by Stephen Roberts are available from Amazon, £4.99-£5.49.

Associate Professor
Stephen Roberts

Settings10.38MBMemory Usage467msRequest 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
[]
$_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" => 1744963987 "last" => 1744963987...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (339.64KB) (52.33ms)
  • afterInitialise (3.3MB) (172ms)
  • afterRoute (613.14KB) (24.67ms)
  • beforeRenderComponent com_content (106.7KB) (9.27ms)
  • Before Access::preloadComponents (all components) (34.49KB) (4.04ms)
  • After Access::preloadComponents (all components) (142.09KB) (765μs)
  • Before Access::preloadPermissions (com_content) (1.95KB) (12μs)
  • After Access::preloadPermissions (com_content) (733.91KB) (2.08ms)
  • Before Access::getAssetRules (id:3705 name:com_content.article.3253) (34.65KB) (63μs)
  • After Access::getAssetRules (id:3705 name:com_content.article.3253) (71.25KB) (638μs)
  • afterRenderComponent com_content (1.47MB) (70.43ms)
  • afterDispatch (72.47KB) (2.47ms)
  • beforeRenderRawModule mod_footer (Copyright) (216.48KB) (9.39ms)
  • afterRenderRawModule mod_footer (Copyright) (10.14KB) (1.62ms)
  • beforeRenderModule mod_footer (Copyright) (720B) (5μs)
  • afterRenderModule mod_footer (Copyright) (3.56KB) (544μs)
  • beforeRenderRawModule mod_menu (Support) (2.52KB) (299μs)
  • afterRenderRawModule mod_menu (Support) (127.24KB) (4.95ms)
  • beforeRenderModule mod_menu (Support) (704B) (5μs)
  • afterRenderModule mod_menu (Support) (3.08KB) (234μs)
  • beforeRenderRawModule mod_articles_categories (Serendipity) (2.2KB) (55μs)
  • afterRenderRawModule mod_articles_categories (Serendipity) (234.98KB) (6.63ms)
  • beforeRenderModule mod_articles_categories (Serendipity) (720B) (5μs)
  • afterRenderModule mod_articles_categories (Serendipity) (5.22KB) (331μs)
  • beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (61μs)
  • afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (98.3KB) (2.91ms)
  • beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (5μs)
  • afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (276μs)
  • beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (59μs)
  • afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (1ms)
  • beforeRenderModule mod_icmsocial (Social Links) (720B) (4μs)
  • afterRenderModule mod_icmsocial (Social Links) (6.98KB) (287μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (55μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.04KB) (1.14ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.19KB) (119μs)
  • beforeRenderRawModule mod_menu (NavBar) (1.18KB) (54μs)
  • afterRenderRawModule mod_menu (NavBar) (469.44KB) (8.83ms)
  • beforeRenderModule mod_menu (NavBar) (704B) (5μs)
  • afterRenderModule mod_menu (NavBar) (6.64KB) (119μs)
  • beforeRenderRawModule mod_login (Members) (2.83KB) (18μs)
  • afterRenderRawModule mod_login (Members) (25.23KB) (4.96ms)
  • beforeRenderModule mod_login (Members) (704B) (4μs)
  • afterRenderModule mod_login (Members) (4.83KB) (121μs)
  • beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (20μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (117.72KB) (7.4ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (5μs)
  • afterRenderModule mod_finder (Smart Search Module) (3.11KB) (135μs)
  • afterRender (1.44MB) (75.17ms)
  • 1 x afterInitialise (3.3MB) (36.82%)
    172ms
    1 x afterRender (1.44MB) (16.1%)
    75.17ms
    1 x afterRenderComponent com_content (1.47MB) (15.08%)
    70.43ms
    1 x afterLoad (339.64KB) (11.21%)
    52.33ms
    1 x afterRoute (613.14KB) (5.28%)
    24.67ms
    1 x beforeRenderRawModule mod_footer (Copyright) (216.48KB) (2.01%)
    9.39ms
    1 x beforeRenderComponent com_content (106.7KB) (1.99%)
    9.27ms
    1 x afterRenderRawModule mod_menu (NavBar) (469.44KB) (1.89%)
    8.83ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (117.72KB) (1.58%)
    7.40ms
    1 x afterRenderRawModule mod_articles_categories (Serendipity) (234.98KB) (1.42%)
    6.63ms
    1 x afterRenderRawModule mod_login (Members) (25.23KB) (1.06%)
    4.96ms
    1 x afterRenderRawModule mod_menu (Support) (127.24KB) (1.06%)
    4.95ms
    1 x Before Access::preloadComponents (all components) (34.49KB) (0.87%)
    4.04ms
    1 x afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (98.3KB) (0.62%)
    2.91ms
    1 x afterDispatch (72.47KB) (0.53%)
    2.47ms
    1 x After Access::preloadPermissions (com_content) (733.91KB) (0.45%)
    2.08ms
    1 x afterRenderRawModule mod_footer (Copyright) (10.14KB) (0.35%)
    1.62ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.04KB) (0.24%)
    1.14ms
    1 x afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (0.22%)
    1.00ms
    1 x After Access::preloadComponents (all components) (142.09KB) (0.16%)
    765μs
    1 x After Access::getAssetRules (id:3705 name:com_content.article.3253) (71.25KB) (0.14%)
    638μs
    1 x afterRenderModule mod_footer (Copyright) (3.56KB) (0.12%)
    544μs
    1 x afterRenderModule mod_articles_categories (Serendipity) (5.22KB) (0.07%)
    331μs
    1 x beforeRenderRawModule mod_menu (Support) (2.52KB) (0.06%)
    299μs
    1 x afterRenderModule mod_icmsocial (Social Links) (6.98KB) (0.06%)
    287μs
    1 x afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (0.06%)
    276μs
    1 x afterRenderModule mod_menu (Support) (3.08KB) (0.05%)
    234μs
    1 x afterRenderModule mod_finder (Smart Search Module) (3.11KB) (0.03%)
    135μs
    1 x afterRenderModule mod_login (Members) (4.83KB) (0.03%)
    121μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.19KB) (0.03%)
    119μs
    1 x afterRenderModule mod_menu (NavBar) (6.64KB) (0.03%)
    119μs
    1 x Before Access::getAssetRules (id:3705 name:com_content.article.3253) (34.65KB) (0.01%)
    63μs
    1 x beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (0.01%)
    61μs
    1 x beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (0.01%)
    59μs
    1 x beforeRenderRawModule mod_articles_categories (Serendipity) (2.2KB) (0.01%)
    55μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (0.01%)
    55μs
    1 x beforeRenderRawModule mod_menu (NavBar) (1.18KB) (0.01%)
    54μs
    1 x beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_login (Members) (2.83KB) (0%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (1.95KB) (0%)
    12μs
    1 x beforeRenderModule mod_footer (Copyright) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Support) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_articles_categories (Serendipity) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (NavBar) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_icmsocial (Social Links) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_login (Members) (704B) (0%)
    4μs
61 statements were executed, 16 of which were duplicates, 45 unique14.93ms305.36KB
  • SELECT @@SESSION.sql_mode;97μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `mnjcl_session` WHERE `session_id` = ?125μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = :session_id LIMIT 177μ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)354μ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` = 1283μs17.86KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mnjcl_viewlevels`87μ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` = :guest107μ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`670μs5.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `mnjcl_admintools_storage` WHERE `key` = 'cparams'139μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `mnjcl_admintools_wafexceptions`106μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'189μ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;80μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:53Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.217.228.61' AND `hackcount` >= 393μs536B/plugins/system/marcosinterceptor/marcosinterceptor.php:61Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.217.228.61' AND `hackcount` >= 355μ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`717μ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`302μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `mnjcl_content` WHERE `alias` = :segment AND `catid` = :id806μs2.59KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `mnjcl_languages` WHERE `published` = 1 ORDER BY `ordering` ASC104μs1.59KB/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` = 1162μ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)443μ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` = 0821μs69.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `mnjcl_content`408μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `mnjcl_content` SET `hits` = (`hits` + 1) WHERE `id` = '3253'268μ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)255μ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`291μ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)205μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `name` FROM `mnjcl_extensions` WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'106μ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`298μ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 ASC670μs4.81KBParams/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`296μ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)198μs4.55KB/plugins/system/picasaupdater/src/Extension/PicasaUpdater.php:79Copy
  • SELECT `alias`,`catid` FROM mnjcl_content WHERE `id` = :key359μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM mnjcl_content WHERE `id` = :key89μs3.87KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • 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`526μ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`324μs4.06KBParams/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`294μ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`271μ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`280μ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`267μ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`268μ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`266μ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`266μ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`272μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • select SUM(count) from mnjcl_visitors_country123μs536B/modules/mod_jsvisit_counter/helper.php:73Copy
  • select count(*) from mnjcl_visitors_country where count>087μs536B/modules/mod_jsvisit_counter/helper.php:81Copy
  • SELECT country, name, count FROM mnjcl_visitors_country ORDER BY count DESC LIMIT 5238μs720B/modules/mod_jsvisit_counter/helper.php:85Copy
  • select count from mnjcl_visitors where id = '7'63μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'55μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '1'53μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '1'56μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '7'54μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'54μ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`281μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1268μ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)118μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `mnjcl_schemaorg` WHERE `itemId` = :itemId AND `context` = :context97μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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)234μ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)226μ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` = 1109μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = ?151μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `mnjcl_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?367μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch