Constellations: Capricornus, Cassiopeia, Corona Borealis, Delphinus, Sagitta, Ursa Major, Ursa Minor
Asterism: Keystone of Hercules, Teapot
Satellite: (1)
Messier Objects: M8 (Lagoon Nebula), M11 (Wild Duck Cluster), M13 (Hercules Cluster), M20 (Trifid), M22, M31 (Andromeda Galaxy) 

Location: Crawford Notch Campground on the Saco, White Mountain National Forest, New Hampshire
Date: 2017-08-26
Time: 9:15 PM - 10:45 PM EDT
Instrument: Visual + Binoculars (10x30 IS + 15x70)
Transparency: Fair (2) - Poor (1)
Seeing: Fair (2) - Poor (1)
Temperature: 16º C - 14º C

Similar sky conditions as the night before at this site. It started out partly cloudy in the N and NW but cleared up.

Capricornus
Time: 9:25 PM EDT
S&T Chart Reference: 66, 68, 77
I could faintly see the 7 stars of this constellation naked eye. I used the 10x30 binoculars to view Deneb Algeidi, α Cap and β Cap.

Cassiopeia
Time: 9:27 PM EDT
S&T Chart Reference: 1, 3, 72
There were some clouds earlier but they cleared out. Consequently, all 5 stars of the constellation could be seen above the cliff.

Satellite
Time: 9:27 PM EDT
(10x30 Binocular) Caught sight of it above Altair then it crossed the corner of γ Delphinus before disappearing from view.

Ursa Major
Time: 9:29 PM EDT
S&T Chart Reference: 31, 32, 33, 43, F
All 7 stars readily seen in the sky. Used my 10x30 binoculars to locate and view the pair Mizar and Alcor in the handle.

Ursa Minor
Time: not recorded
S&T Chart Reference: 41, 51
Tonight could actually identify all 7 stars in this smaller Bear, including η.

Keystone of Hercules 
Time: 10:20 PM EDT
S&T Chart Reference: 52, 54
The Keystone was almost directly above and could be seen visually. 

Corona Borealis
Time: not recorded
S&T Chart Reference: 53, 55
All 7 stars of the Corona were readily found west of Ursa Major. I used the curve of the Corona to locate M13 visually.

M13 (Hercules Cluster) 
Time: not recorded
S&T Chart Reference: 52, 54
I was able to locate M13 visually between η Hercules and ζ Hercules then used both pairs of binoculars to obtain a better view. 

Teapot
Time: not recorded
S&T Chart Reference: 66, 67, 68, 69, I
The Teapot's star were all visible at the beginning of this session. By 10 PM, Kaus Borealis, Kaus Media, Almasa and Kaus Australis had disappeared behind the trees.

M8 (Lagoon Nebula) 
Time: not recorded
S&T Chart Reference: 67, 69, I
Having found the Teapot, I again guessed the location of this nebula and was successful.

M20 (Trifid Nebula) 
Time: not recorded
S&T Chart Reference:67, 69, I
This evening I used both binoculars. Much brighter in the 15x70 but couldn't discern the 3 segments of the nebula in any way.

M22 (Globular Cluster) 
Time: not recorded
S&T Chart Reference: 67, 69, I
Kaus Borealis couldn't be seen but guessed where it was located to find M22. Note: I cold see all 4 stars in the Teapot handle.

M11 (Wild Duck Cluster) 
Time: not recorded
S&T Chart Reference: 67
I looked up in the Milky Way for an upside-down golf club with a fuzzy golf ball beside the head of the club. Found it below lambda Aquila. Used the 10x30  binoculars first then the 15x70. The latter showed a bigger and brighter fuzzy round object.

Sagitta & Delphinus
Time: not recorded
S&T Chart Reference: 64
Despite the haze and light pollution, the 4 stars in this very small constellation Sagitta were located below Albireo in Cygnus. Not very high magnitude stars but they could still be seen.

Not too far away, the 5 stars of Delphinus could easily be seen visually and they appeared brighter than the evening before. A slight twinkling was noted.

M31 (Andromeda Galaxy) 
Time: not recorded
S&T Chart Reference:
I located this using Cassiopeia and used both pairs of binoculars to obtain a better view. WOW to the larger view of the 15x70! The centre of the oval-shaped galaxy was so much brighter.

 

 

 

 

Similar Items

Settings4.045MBMemory Usage59.9msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0-beta2
PHP Version8.3.6
Identityguest
Response200
Templatelightning
Database
Server
mysql
Version
10.11.8-MariaDB-0ubuntu0.24.04.1
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_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" => 1742050605 "last" => 1742050605...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (84.76KB) (2.08ms)
  • afterInitialise (1.35MB) (19.07ms)
  • afterRoute (234.7KB) (4.12ms)
  • beforeRenderComponent com_content (33.63KB) (1.27ms)
  • Before Access::preloadComponents (all components) (33.52KB) (372μs)
  • After Access::preloadComponents (all components) (111.1KB) (1.08ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (24μs)
  • After Access::preloadPermissions (com_content) (356.31KB) (1.03ms)
  • Before Access::getAssetRules (id:690 name:com_content.article.294) (18.65KB) (28μs)
  • After Access::getAssetRules (id:690 name:com_content.article.294) (8.3KB) (87μs)
  • Before Access::getAssetRules (id:1 name:root.1) (199.29KB) (5.39ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (26μs)
  • afterRenderComponent com_content (301.93KB) (5.98ms)
  • afterDispatch (104B) (298μs)
  • beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (809μs)
  • afterRenderRawModule mod_menu (Main Menu) (197.27KB) (1.23ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (4μs)
  • afterRenderModule mod_menu (Main Menu) (7.17KB) (125μs)
  • beforeRenderRawModule mod_finder (Search) (2KB) (48μs)
  • afterRenderRawModule mod_finder (Search) (355.55KB) (2.56ms)
  • beforeRenderModule mod_finder (Search) (704B) (4μs)
  • afterRenderModule mod_finder (Search) (3.28KB) (68μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (3.49KB) (242μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (460μs)
  • beforeRenderModule mod_articles_archive (Archived Articles) (720B) (3μs)
  • afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (67μs)
  • beforeRenderRawModule mod_syndicate (Syndication) (880B) (11μs)
  • afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (83μs)
  • beforeRenderModule mod_syndicate (Syndication) (704B) (2μs)
  • afterRenderModule mod_syndicate (Syndication) (2.5KB) (30μs)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (46μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (105.09KB) (8.67ms)
  • beforeRenderModule mod_tags_similar (Similar Items) (704B) (4μs)
  • afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (91μs)
  • beforeRenderRawModule mod_footer (Footer) (504B) (40μs)
  • afterRenderRawModule mod_footer (Footer) (4.84KB) (129μs)
  • beforeRenderModule mod_footer (Footer) (704B) (2μs)
  • afterRenderModule mod_footer (Footer) (2.97KB) (41μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (592B) (11μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (61μs)
  • beforeRenderModule mod_menu (Bottom Menu) (720B) (2μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.41KB) (26μs)
  • afterRender (197.23KB) (3.23ms)
  • 1 x afterInitialise (1.35MB) (31.84%)
    19.07ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (105.09KB) (14.47%)
    8.67ms
    1 x afterRenderComponent com_content (301.93KB) (9.99%)
    5.98ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (199.29KB) (8.99%)
    5.39ms
    1 x afterRoute (234.7KB) (6.87%)
    4.12ms
    1 x afterRender (197.23KB) (5.39%)
    3.23ms
    1 x afterRenderRawModule mod_finder (Search) (355.55KB) (4.28%)
    2.56ms
    1 x afterLoad (84.76KB) (3.48%)
    2.08ms
    1 x beforeRenderComponent com_content (33.63KB) (2.12%)
    1.27ms
    1 x afterRenderRawModule mod_menu (Main Menu) (197.27KB) (2.05%)
    1.23ms
    1 x After Access::preloadComponents (all components) (111.1KB) (1.81%)
    1.08ms
    1 x After Access::preloadPermissions (com_content) (356.31KB) (1.72%)
    1.03ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (1.35%)
    809μs
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (0.77%)
    460μs
    1 x Before Access::preloadComponents (all components) (33.52KB) (0.62%)
    372μs
    1 x afterDispatch (104B) (0.5%)
    298μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (3.49KB) (0.4%)
    242μs
    1 x afterRenderRawModule mod_footer (Footer) (4.84KB) (0.22%)
    129μs
    1 x afterRenderModule mod_menu (Main Menu) (7.17KB) (0.21%)
    125μs
    1 x afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (0.15%)
    91μs
    1 x After Access::getAssetRules (id:690 name:com_content.article.294) (8.3KB) (0.15%)
    87μs
    1 x afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (0.14%)
    83μs
    1 x afterRenderModule mod_finder (Search) (3.28KB) (0.11%)
    68μs
    1 x afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (0.11%)
    67μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (0.1%)
    61μs
    1 x beforeRenderRawModule mod_finder (Search) (2KB) (0.08%)
    48μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (0.08%)
    46μs
    1 x afterRenderModule mod_footer (Footer) (2.97KB) (0.07%)
    41μs
    1 x beforeRenderRawModule mod_footer (Footer) (504B) (0.07%)
    40μs
    1 x afterRenderModule mod_syndicate (Syndication) (2.5KB) (0.05%)
    30μs
    1 x Before Access::getAssetRules (id:690 name:com_content.article.294) (18.65KB) (0.05%)
    28μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.04%)
    26μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.41KB) (0.04%)
    26μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.04%)
    24μs
    1 x beforeRenderRawModule mod_syndicate (Syndication) (880B) (0.02%)
    11μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (592B) (0.02%)
    11μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0.01%)
    4μs
    1 x beforeRenderModule mod_tags_similar (Similar Items) (704B) (0.01%)
    4μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    4μs
    1 x beforeRenderModule mod_articles_archive (Archived Articles) (720B) (0%)
    3μs
    1 x beforeRenderModule mod_footer (Footer) (704B) (0%)
    2μs
    1 x beforeRenderModule mod_syndicate (Syndication) (704B) (0%)
    2μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%)
    2μs
44 statements were executed, 5 of which were duplicates, 39 unique23.76ms825.64KB
  • SELECT `data` FROM `lb8l6_session` WHERE `session_id` = ?820μs17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = :session_id LIMIT 1452μs16.98KBParams/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)2.29ms1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `lb8l6_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1458μs16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lb8l6_viewlevels`92μs16.44KB/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` = :guest154μs17.03KBParams/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`573μs19.82KBParams/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`1.07ms50.91KBParams/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`705μs19.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lb8l6_content` WHERE `alias` = :segment AND `catid` = :id132μs17.1KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `lb8l6_languages` WHERE `published` = 1 ORDER BY `ordering` ASC246μs16.39KB/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` = 1302μs16.19KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • 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)924μs26.08KBParams/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` = 0595μs45.19KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lb8l6_content`978μs16.85KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:442Copy
  • UPDATE `lb8l6_content` SET `hits` = (`hits` + 1) WHERE `id` = '294'977μs56BCopy
  • 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)385μs37.55KBParams/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`329μs18.92KBParams/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)336μs18.33KBParams/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.id130μs16.31KB/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`262μs18.92KBParams/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 ASC964μs20.3KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `lb8l6_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid241μs17.14KBParams/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`388μs18.92KBParams/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.id128μs16.31KB/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`452μs18.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `lb8l6_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1227μs16.13KB/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)114μs16.15KB/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 10173μs16.16KB/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)214μs17.24KBParams/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,:preparedArray2,:preparedArray3,:preparedArray4) AND `t`.`access` IN (:preparedArray5,:preparedArray6) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray7,:preparedArray8) 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 57.26ms20.14KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:206Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key74μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key58μs19.45KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key51μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key85μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key50μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `lb8l6_schemaorg` WHERE `itemId` = :itemId AND `context` = :context79μs17.19KBParams/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)269μs36.35KBParams/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` = 1101μs17.1KBParams/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.id81μs16.31KB/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.id53μs16.31KB/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.id51μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = ?63μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `lb8l6_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?380μs1.53KBParamsCopy