Crawford Notch Beach. ©Judy Black. iPhone 6s Plus. ISO 25,1/1800 sec @f/2.2

Constellations: Capricornus, Cassiopeia, Delphinus, Lyra, Ursa Major
Asterism: Coathanger/Collinder 399/Brocchi's Cluster, Keystone of Hercules, Square of Pegasus, Teapot
Satellite: (1)
Messier Objects: M8, M13, M20, M21, M31 

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

No wind and light clouds occasionally. High humidity and light pollution to the E-SE. We did our viewing from the rocky beach of the shallow, cold water river. There was a steep cliff directly across from us that cut off our view to the East.

Teapot (in Sagittarius)
Time: 9:07 PM EDT
Again, because of the trees, could only see the handle and lid of the Teapot.

 
 
Delphinus
Time: not recorded
S&T Chart Reference: 64
The 5 stars of Delphinus could be easily seen but they were not as bright the evening before. Showed it to Steve (a photographer on the beach).

Lyra
Time: 9:18 PM EDT
S&T Chart Reference:63
Instrument: Visual + Binoculars
Found Vega then Lyra visually then viewed them with binoculars. Showed the constellation to a fellow on the beach taking photographs and shared the binoculars with I'm to view the double stars in Lyra - ε and δ.

Keystone of Hercules (in Hercules)
Time: 9:42 PM EDT
S&T Chart Reference: 52, 54
Instrument: Binoculars
The Keystone was located almost directly overhead. I found M13.

Satellite
Time: 9:42 PM EDT
Instrument: Binoculars
While viewing the Keystone, caught sight of a satellite. Followed it to above Scorpius where it then disappeared in the trees.

Cassiopeia
Time: 9:48 PM EDT
S&T Chart Reference: 1, 3, 72
Instrument: Visual + Binoculars
Could identify all 5 stars of the constellation due to their magnitude. Surrounding stars not easily seen naked eye but could be seen with binoculars.

Ursa Major
Time: 9:43 PM EDT
S&T Chart Reference: 31, 32, 33, 43, F
Instrument: Visual + Binoculars
Could make out all 7 stars naked eye and used binoculars to see the double stars Mizar and Alcor. Could see Polaris but it was faint to the naked eye.

Capricornus
Time: 9:55 PM EDT
S&T Chart Reference: 66, 68, 77
Instrument: Visual + Binoculars
Saw 2 stars in vertical alignment and used my binoculars to confirm it was Capricornus α and β. Could not easily see the other stars in this constellation due to the light pollution.

Square of Pegasus (in Pegasus)
Time: 10:00 PM EDT
S&T Chart Reference: 74, 75
Instrument: Visual
Just before leaving the beach, 3 of the 4 stars in the Square (Scheat, Algenib and Alpheratz) were visible above the cliffs across the river from us.

Coathanger /Collinder 399 / Brocchi's Cluster
Time: 10:25 PM EDT
S&T Chart Reference: 65
Instrument: Visual + Binoculars
Could not locate Albireo earlier in this session so decided to use Altair as the start point. Success! All 10 stars easily found with the binoculars. Showed this to Steve as well.

Messier Objects

M8 (Lagoon Nebula)
Time: not recorded
S&T Chart Reference: 67, 69, I
Instrument: Visual + Binoculars
The hazy skies and the tree line it made for difficult to find the spout of the Teapot; however, knowing where the lid was located,  I was able to find the nebula. The line of stars plus the grey fuzzy area around and mostly above the line were easily seen in the binoculars.

M13 (Hercules Cluster)
Time: not recorded
S&T Chart Reference: 67, 69, I
Instrument: Visual + Binoculars
I had found the Keystone earlier in this session. Locating it again, I looked 1/3 off the way from η Hercules to ζ Hercules to find the small, grey, round cluster with the binoculars.

 

M31 (open cluster)
Time: not recorded
S&T Chart Reference: 3, 72
Instrument: Visual + Binoculars
Used Cassiopeia to locate Andromeda as we couldn't see the Square of Pegasus. It was a grey fuzzy of indeterminant shape and better seen with averted vision.

 

M20 (Trifid Nebula)
Time: not recorded
S&T Chart Reference: 67, 69, I
Instrument: Binoculars
Having found M8, it was easy to look in the upper portion of my binocular FOV to see this nebula. A central bright area but not  able to discern individual stars.

M21 (open cluster)
Time: not recorded
S&T Chart Reference: 67, 69, I
Instrument: Binoculars
M21 was found in the same FOV as M20 but a little up and to the left in the FOV.

 

 

 

Similar Items

Settings4.072MBMemory Usage43.71msRequest 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" => 1741996300 "last" => 1741996300...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (84.88KB) (429μs)
  • afterInitialise (1.35MB) (11.63ms)
  • afterRoute (235.05KB) (3.87ms)
  • beforeRenderComponent com_content (33.27KB) (681μs)
  • Before Access::preloadComponents (all components) (33.52KB) (220μs)
  • After Access::preloadComponents (all components) (111.1KB) (378μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (8μs)
  • After Access::preloadPermissions (com_content) (356.31KB) (765μs)
  • Before Access::getAssetRules (id:688 name:com_content.article.293) (18.65KB) (21μs)
  • After Access::getAssetRules (id:688 name:com_content.article.293) (8.3KB) (40μs)
  • Before Access::getAssetRules (id:1 name:root.1) (207.04KB) (3.53ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (16μs)
  • afterRenderComponent com_content (301.81KB) (4.97ms)
  • afterDispatch (104B) (211μs)
  • beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (546μs)
  • afterRenderRawModule mod_menu (Main Menu) (197.42KB) (1.15ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (3μs)
  • afterRenderModule mod_menu (Main Menu) (6.86KB) (90μs)
  • beforeRenderRawModule mod_finder (Search) (2KB) (36μs)
  • afterRenderRawModule mod_finder (Search) (355.55KB) (2.45ms)
  • beforeRenderModule mod_finder (Search) (704B) (5μs)
  • afterRenderModule mod_finder (Search) (3.28KB) (73μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (184μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (325μs)
  • beforeRenderModule mod_articles_archive (Archived Articles) (720B) (2μs)
  • afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (42μs)
  • beforeRenderRawModule mod_syndicate (Syndication) (880B) (6μs)
  • afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (48μs)
  • beforeRenderModule mod_syndicate (Syndication) (704B) (1μs)
  • afterRenderModule mod_syndicate (Syndication) (2.5KB) (20μs)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (28μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (104.76KB) (7.04ms)
  • beforeRenderModule mod_tags_similar (Similar Items) (704B) (6μs)
  • afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (87μs)
  • beforeRenderRawModule mod_footer (Footer) (504B) (39μs)
  • afterRenderRawModule mod_footer (Footer) (4.84KB) (166μs)
  • beforeRenderModule mod_footer (Footer) (704B) (2μs)
  • afterRenderModule mod_footer (Footer) (2.97KB) (60μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (592B) (10μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (63μs)
  • beforeRenderModule mod_menu (Bottom Menu) (720B) (2μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.41KB) (27μs)
  • afterRender (205.23KB) (3.52ms)
  • 1 x afterInitialise (1.35MB) (26.59%)
    11.63ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (104.76KB) (16.11%)
    7.04ms
    1 x afterRenderComponent com_content (301.81KB) (11.36%)
    4.97ms
    1 x afterRoute (235.05KB) (8.85%)
    3.87ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (207.04KB) (8.08%)
    3.53ms
    1 x afterRender (205.23KB) (8.05%)
    3.52ms
    1 x afterRenderRawModule mod_finder (Search) (355.55KB) (5.6%)
    2.45ms
    1 x afterRenderRawModule mod_menu (Main Menu) (197.42KB) (2.64%)
    1.15ms
    1 x After Access::preloadPermissions (com_content) (356.31KB) (1.75%)
    765μs
    1 x beforeRenderComponent com_content (33.27KB) (1.56%)
    681μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (1.25%)
    546μs
    1 x afterLoad (84.88KB) (0.98%)
    429μs
    1 x After Access::preloadComponents (all components) (111.1KB) (0.86%)
    378μs
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (0.74%)
    325μs
    1 x Before Access::preloadComponents (all components) (33.52KB) (0.5%)
    220μs
    1 x afterDispatch (104B) (0.48%)
    211μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (0.42%)
    184μs
    1 x afterRenderRawModule mod_footer (Footer) (4.84KB) (0.38%)
    166μs
    1 x afterRenderModule mod_menu (Main Menu) (6.86KB) (0.21%)
    90μs
    1 x afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (0.2%)
    87μs
    1 x afterRenderModule mod_finder (Search) (3.28KB) (0.17%)
    73μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (0.14%)
    63μs
    1 x afterRenderModule mod_footer (Footer) (2.97KB) (0.14%)
    60μs
    1 x afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (0.11%)
    48μs
    1 x afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (0.1%)
    42μs
    1 x After Access::getAssetRules (id:688 name:com_content.article.293) (8.3KB) (0.09%)
    40μs
    1 x beforeRenderRawModule mod_footer (Footer) (504B) (0.09%)
    39μs
    1 x beforeRenderRawModule mod_finder (Search) (2KB) (0.08%)
    36μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (0.06%)
    28μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.41KB) (0.06%)
    27μs
    1 x Before Access::getAssetRules (id:688 name:com_content.article.293) (18.65KB) (0.05%)
    21μs
    1 x afterRenderModule mod_syndicate (Syndication) (2.5KB) (0.05%)
    20μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.04%)
    16μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (592B) (0.02%)
    10μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    8μs
    1 x beforeRenderRawModule mod_syndicate (Syndication) (880B) (0.01%)
    6μs
    1 x beforeRenderModule mod_tags_similar (Similar Items) (704B) (0.01%)
    6μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0.01%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    3μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%)
    2μs
    1 x beforeRenderModule mod_articles_archive (Archived Articles) (720B) (0%)
    2μs
    1 x beforeRenderModule mod_footer (Footer) (704B) (0%)
    2μs
    1 x beforeRenderModule mod_syndicate (Syndication) (704B) (0%)
    1μs
44 statements were executed, 5 of which were duplicates, 39 unique17.32ms825.64KB
  • SELECT `data` FROM `lb8l6_session` WHERE `session_id` = ?176μs17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = :session_id LIMIT 1136μ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)941μs1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `lb8l6_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1518μs16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lb8l6_viewlevels`182μ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` = :guest190μ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`964μ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.14ms50.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`517μs19.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lb8l6_content` WHERE `alias` = :segment AND `catid` = :id99μs17.1KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `lb8l6_languages` WHERE `published` = 1 ORDER BY `ordering` ASC91μ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` = 1142μ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)285μ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` = 0382μs45.19KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lb8l6_content`462μs16.85KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:442Copy
  • UPDATE `lb8l6_content` SET `hits` = (`hits` + 1) WHERE `id` = '293'418μ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)428μ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`269μ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)210μ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.id85μ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`161μ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 ASC697μ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` = :itemid164μ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`260μ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.id88μ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`271μs18.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `lb8l6_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1290μ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)154μ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 10153μ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)154μ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 55.84ms20.14KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:206Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key145μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key54μs19.45KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key70μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key42μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key44μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `lb8l6_schemaorg` WHERE `itemId` = :itemId AND `context` = :context95μ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)272μ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` = 1129μ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.id86μ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.id54μ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` = ?348μs1.53KBParamsCopy