General Session - October 10-11, 2024 (Aurora Borealis)

Aurora Borealis
1st Quarter Moon
Located, but not observed through the Aurora: Boötes, Cassiopeia, Big Dipper, Little Dipper, Venus

Observation #1:
Location: Stargaze Nova Scotia, near McGrath's Cove Road, Halifax
Date: 2024-10-10
Time: 6:55 PM – 10:10 PM ADT
Equipment: Visual, iPhone 13 Pro Max
Seeing: not recorded
Transparency: not recorded

We drove to Stargaze Nova Scotia and were joined by its proprietor, John Read, as well as Blair MacDonald and 3 other of John's friends; others arrived throughout the evening. He took us along a path that one of his students had made over the summer to a high point overlooking a small lake. En route there were several 360° views of the horizon. Absolutely incredible.

The 'show' began a little after 7:30 PM with faint glimpses of colour to the naked eye; pictures confirmed it had started. A bull frog's croak seems to confirm that was so.

At 8:14 PM, I texted our daughters: "If you aren’t outside, looking up, do so right now. The Aurora are absolutely incredible!!!" We had to laugh at the response: "Oak Ridge Memorial Gardens (graveyard) was the place to be! We were just approaching it as Mom texted to look up. Worked out perfect coming home from a school event! It was the boys first time seeing the northern lights, and my first time being in a packed graveyard at night lol"

Aurora from Kentville
Aurora in Kentville
Aurora from graveyard
Aurora from Graveyard

Over the next two hours at Stargaze Nova Scotia, we had an indescribable show of the Aurora! The aurora's corona was indescribably beautiful with its full range of colour visible to the eye - red, yellow, greens, blues and violet. Not only did the 4 of us at our location on site exclaim "oh, wow!" at various times when the aurora was at its fullest, but you could also hear John and Blair closer to the ARO and some children at a nearby cottage. 

The wind on the ridge was cool for a period of time but once the wind died down, it was comfortable enough to go without winter mitts. Jerry had 2 cameras taking time-lapse and I had my iPhone in a tripod holder (sometimes) or handheld (most times). It was difficult determining in which direction to look! West? East? North? Straight up? Even the Halifax light dome did not diminish the aurora's intensity. 

By the light of the silvery 1st Quarter Moon

One view that I just loved was looking towards the Moon to see the clouds illuminated so brightly and the aurora's edge seemingly attempting to catch up to it.

The image of the Moon was blown because it was so bright compared to all else in the sky.

Many other images were captured but do not do justice to what we actually saw.

Jerry produced a video of his time-lapse captures via camera and his iPhone 15 Pro Max - https://vimeo.com/1018703128. 
Aurora starts
...and so it starts!
Aurora 1
Aurora with lake reflections
  
 
Height of the Aurora
Aurora Corona
Aurora Corona
Aurora and ARO
Aurora and the ARO
Corona colours

Observation #2:
Location: Home
Date: 2024-10-10/11
Time: 11:00 PM – 12:10 PM ADT
Equipment: Visual, iPhone 13 Pro Max
Seeing: not recorded
Transparency: not recorded

We knew there was to be a second show of the aurora and we were far from disappointed when we reached home. Again a 180° view of the aurora but this time it did not extend over our heads as it had at Stargaze Nova Scotia earlier in the evening. So disappointing when it faded to almost nothing just after midnight.

The two photos below were taken at 11:04 PM ADT.

 
Corona Borealis above our neighbour's home
Radiating Northern Lights

       

Details
Hits: 314

Similar Items

J! InfoRequestSessionProfileQueries45
Settings4.053MBMemory Usage79.95msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.3.11
Identityguest
Response200
Templatelightning
Database
Server
mysql
Version
11.4.5-MariaDB-0ubuntu0.24.10.1
Collation
utf8mb4_uca1400_ai_ci
Conn Collation
utf8mb4_uca1400_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:42 [ "HTTPS" => "on" "SSL_TLS_SNI" => "sciencedowneast.com" "HTTP_HOST" => "sciencedowne...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745457538 "last" => 1745457538...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (83.22KB) (1.03ms)
  • afterInitialise (1.34MB) (20.08ms)
  • afterRoute (235.27KB) (4.5ms)
  • beforeRenderComponent com_content (32.97KB) (1.83ms)
  • Before Access::preloadComponents (all components) (33.52KB) (568μs)
  • After Access::preloadComponents (all components) (121.39KB) (1.11ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (21μs)
  • After Access::preloadPermissions (com_content) (347.26KB) (1.62ms)
  • Before Access::getAssetRules (id:1031 name:com_content.article.508) (18.65KB) (40μs)
  • After Access::getAssetRules (id:1031 name:com_content.article.508) (8.3KB) (98μs)
  • Before Access::getAssetRules (id:1 name:root.1) (202.59KB) (7.53ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (35μs)
  • afterRenderComponent com_content (298.63KB) (11.26ms)
  • afterDispatch (648B) (780μs)
  • beforeRenderRawModule mod_menu (Main Menu) (61.86KB) (1.45ms)
  • afterRenderRawModule mod_menu (Main Menu) (181.31KB) (2.53ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (10μs)
  • afterRenderModule mod_menu (Main Menu) (6.86KB) (223μs)
  • beforeRenderRawModule mod_finder (Search) (2KB) (96μs)
  • afterRenderRawModule mod_finder (Search) (370.85KB) (5.23ms)
  • beforeRenderModule mod_finder (Search) (704B) (10μs)
  • afterRenderModule mod_finder (Search) (3.28KB) (156μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (541μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (14KB) (1.16ms)
  • beforeRenderModule mod_articles_archive (Archived Articles) (720B) (22μs)
  • afterRenderModule mod_articles_archive (Archived Articles) (2.95KB) (176μs)
  • beforeRenderRawModule mod_syndicate (Syndication) (848B) (22μs)
  • afterRenderRawModule mod_syndicate (Syndication) (3.46KB) (143μs)
  • beforeRenderModule mod_syndicate (Syndication) (704B) (4μs)
  • afterRenderModule mod_syndicate (Syndication) (2.47KB) (68μs)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (128B) (100μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (103.88KB) (7.14ms)
  • beforeRenderModule mod_tags_similar (Similar Items) (704B) (11μs)
  • afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (195μs)
  • beforeRenderRawModule mod_footer (Footer) (504B) (107μs)
  • afterRenderRawModule mod_footer (Footer) (4.84KB) (508μs)
  • beforeRenderModule mod_footer (Footer) (704B) (8μs)
  • afterRenderModule mod_footer (Footer) (2.97KB) (130μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (592B) (25μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.44KB) (153μs)
  • beforeRenderModule mod_menu (Bottom Menu) (720B) (6μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.38KB) (69μs)
  • afterRender (203.63KB) (8.64ms)
  • 1 x afterInitialise (1.34MB) (25.12%)
    20.08ms
    1 x afterRenderComponent com_content (298.63KB) (14.09%)
    11.26ms
    1 x afterRender (203.63KB) (10.81%)
    8.64ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (202.59KB) (9.42%)
    7.53ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (103.88KB) (8.93%)
    7.14ms
    1 x afterRenderRawModule mod_finder (Search) (370.85KB) (6.54%)
    5.23ms
    1 x afterRoute (235.27KB) (5.62%)
    4.50ms
    1 x afterRenderRawModule mod_menu (Main Menu) (181.31KB) (3.16%)
    2.53ms
    1 x beforeRenderComponent com_content (32.97KB) (2.29%)
    1.83ms
    1 x After Access::preloadPermissions (com_content) (347.26KB) (2.02%)
    1.62ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (61.86KB) (1.82%)
    1.45ms
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (14KB) (1.45%)
    1.16ms
    1 x After Access::preloadComponents (all components) (121.39KB) (1.39%)
    1.11ms
    1 x afterLoad (83.22KB) (1.28%)
    1.03ms
    1 x afterDispatch (648B) (0.98%)
    780μs
    1 x Before Access::preloadComponents (all components) (33.52KB) (0.71%)
    568μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (0.68%)
    541μs
    1 x afterRenderRawModule mod_footer (Footer) (4.84KB) (0.64%)
    508μs
    1 x afterRenderModule mod_menu (Main Menu) (6.86KB) (0.28%)
    223μs
    1 x afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (0.24%)
    195μs
    1 x afterRenderModule mod_articles_archive (Archived Articles) (2.95KB) (0.22%)
    176μs
    1 x afterRenderModule mod_finder (Search) (3.28KB) (0.2%)
    156μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.44KB) (0.19%)
    153μs
    1 x afterRenderRawModule mod_syndicate (Syndication) (3.46KB) (0.18%)
    143μs
    1 x afterRenderModule mod_footer (Footer) (2.97KB) (0.16%)
    130μs
    1 x beforeRenderRawModule mod_footer (Footer) (504B) (0.13%)
    107μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (128B) (0.13%)
    100μs
    1 x After Access::getAssetRules (id:1031 name:com_content.article.508) (8.3KB) (0.12%)
    98μs
    1 x beforeRenderRawModule mod_finder (Search) (2KB) (0.12%)
    96μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.38KB) (0.09%)
    69μs
    1 x afterRenderModule mod_syndicate (Syndication) (2.47KB) (0.08%)
    68μs
    1 x Before Access::getAssetRules (id:1031 name:com_content.article.508) (18.65KB) (0.05%)
    40μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.04%)
    35μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (592B) (0.03%)
    25μs
    1 x beforeRenderRawModule mod_syndicate (Syndication) (848B) (0.03%)
    22μs
    1 x beforeRenderModule mod_articles_archive (Archived Articles) (720B) (0.03%)
    22μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.03%)
    21μs
    1 x beforeRenderModule mod_tags_similar (Similar Items) (704B) (0.01%)
    11μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_footer (Footer) (704B) (0.01%)
    8μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0.01%)
    6μs
    1 x beforeRenderModule mod_syndicate (Syndication) (704B) (0.01%)
    4μs
45 statements were executed, 5 of which were duplicates, 40 unique24.9ms192.03KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;206μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `lb8l6_session` WHERE `session_id` = ?201μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = :session_id LIMIT 1148μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `lb8l6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)6.55ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `lb8l6_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1381μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lb8l6_viewlevels`219μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `lb8l6_usergroups` AS `a` LEFT JOIN `lb8l6_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest237μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `lb8l6_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`605μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `lb8l6_menu` AS `m` LEFT JOIN `lb8l6_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`560μs36.67KBParams/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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`476μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lb8l6_content` WHERE `alias` = :segment AND `catid` = :id198μs1.34KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `lb8l6_languages` WHERE `published` = 1 ORDER BY `ordering` ASC199μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `lb8l6_template_styles` AS `s` LEFT JOIN `lb8l6_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` = 1251μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `lb8l6_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)597μs7.69KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `lb8l6_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0726μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lb8l6_content`439μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `lb8l6_content` SET `hits` = (`hits` + 1) WHERE `id` = '508'604μs1.3KB/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 `lb8l6_content` AS `a` INNER JOIN `lb8l6_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `lb8l6_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `lb8l6_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `lb8l6_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `lb8l6_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)483μs22.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`501μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `lb8l6_contentitem_tag_map` AS `m` INNER JOIN `lb8l6_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)479μs3.98KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'articles') ORDER BY r.ordering, r.id267μs1.48KB/plugins/system/rereplacer/src/Items.php:95Copy
  • 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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`562μs3.91KBParams/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 lb8l6_fields AS a LEFT JOIN `lb8l6_languages` AS l ON l.lang_code = a.language LEFT JOIN lb8l6_users AS uc ON uc.id=a.checked_out LEFT JOIN lb8l6_viewlevels AS ag ON ag.id = a.access LEFT JOIN lb8l6_users AS ua ON ua.id = a.created_user_id LEFT JOIN lb8l6_fields_groups AS g ON g.id = a.group_id LEFT JOIN `lb8l6_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC956μs4.77KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `lb8l6_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid269μ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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`592μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'component') ORDER BY r.ordering, r.id196μs1.48KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `lb8l6_modules` AS `m` LEFT JOIN `lb8l6_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `lb8l6_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`441μs1.94KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `lb8l6_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1451μs656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `lb8l6_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)196μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year FROM `lb8l6_content` AS `c` WHERE `c`.`state` = 2 GROUP BY YEAR(`c`.`created`), MONTH(`c`.`created`) ORDER BY YEAR(`c`.`created`) DESC, MONTH(`c`.`created`) DESC LIMIT 10308μs640B/modules/mod_articles_archive/src/Helper/ArticlesArchiveHelper.php:69Copy
  • SELECT `t`.`id` FROM `lb8l6_tags` AS `t` INNER JOIN `lb8l6_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)405μs1.34KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,COUNT( `tag_id`) AS `count`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` FROM `lb8l6_contentitem_tag_map` AS `m` INNER JOIN `lb8l6_tags` AS `t` ON `m`.`tag_id` = `t`.`id` INNER JOIN `lb8l6_ucm_content` AS `cc` ON `m`.`core_content_id` = `cc`.`core_content_id` INNER JOIN `lb8l6_content_types` AS `ct` ON `m`.`type_alias` = `ct`.`type_alias` WHERE ( ( ( (`m`.`tag_id` IN (:preparedArray1) AND `t`.`access` IN (:preparedArray2,:preparedArray3) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray4,:preparedArray5) OR `cc`.`core_access` = 0)) AND (`m`.`content_item_id` <> :currentId OR `m`.`type_alias` <> :prefix)) AND (`cc`.`core_publish_up` IS NULL OR `cc`.`core_publish_up` = :nullDateUp OR `cc`.`core_publish_up` <= :nowDateUp)) AND (`cc`.`core_publish_down` IS NULL OR `cc`.`core_publish_down` = :nullDateDown OR `cc`.`core_publish_down` >= :nowDateDown) GROUP BY `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` ORDER BY `count` DESC LIMIT 53.57ms3.11KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:206Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key143μs3.87KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key105μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key103μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key90μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key92μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `lb8l6_schemaorg` WHERE `itemId` = :itemId AND `context` = :context187μ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 `lb8l6_content` AS `a` INNER JOIN `lb8l6_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `lb8l6_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `lb8l6_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `lb8l6_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `lb8l6_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)420μs22.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 `lb8l6_scheduler_tasks` AS `a` WHERE `a`.`state` = 1196μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'head') ORDER BY r.ordering, r.id203μs1.48KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'body') ORDER BY r.ordering, r.id148μs1.48KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'everywhere') ORDER BY r.ordering, r.id140μs1.48KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = ?191μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `lb8l6_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?601μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy