Constellation: Cassiopeia, Corona Borealis, Delphinus, Scorpius, Ursa Major, Virgo
Asterism: Keystone of Hercules, Square of Pegasus, Teapot
Messier Object
: M6 (Butterfly Cluster), M8 (Lagoon Nebula), M11 (Wild Duck Cluster), M13 (Hercules Cluster), M20 (Trifid Nebula), M21, M22, M25 (IC4725)
Planets: Jupiter, Saturn
Satellites: (2)
Failed Attempt to Find:
M54, M58, M69, M70, Sagitta

Location: St. Croix Observatory (SCO)
Date: 2017-06-26 - 2017-06-27
Time: 9:50 PM - 1:30 AM
Temperature: 20° C - 18° C 
Instrument: Visual + Binoculars 10x30 IS + Binoculars 15x70
Magnification: x10 + x15
Transparency: Excellent (5)
Seeing: Excellent (5)

Clear skies with only a few clouds. No wind. A few fireflies in the greenery near the shore. While Jerry was setting up his time lapse equipment, I was getting my bearings and determining the stars that rose in the night sky visually first.

However, my first order of business was to look at the Moon while it was still up high enough above the tree line at SCO. Not much time for Explore the Moon (Binocular) - June 26, 2017.

M70
Time: 9:50 PM ADT
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 67, 69
Tried to find M70 again with binoculars by slowly going along the imaginary line in the Teapot between Ascella and Kaus Australis. Did not succeed.

  

10:00 PM
We looked up, straight up to find the Keystone of Hercules. Looked for the backwards "C" known as Corona Borealis. All 7 of the brightest stars forming the Corona were easily seen. After pointing this out to Jerry, I used two methods to find M13 (Hercules Cluster):
   1- Went down 1/3 distance from η to ζ on the NW border of the Keystone; and
   2- Use the Corona Borealis, following the arc counter-clockwise to point right to it. 

Given sky conditions on any given night, we appreciated that only one of these methods might be used. Tonight's excellent seeing and transparency meant both could successfully be used.

 

10:10 PM
For the second time in a month, Scorpius was well above the horizon and at about a 45° angle in the sky. θ and η were about 5° to 10° above the horizon; this was the brightest and highest I can recall seeing this constellation at home in Nova Scotia!

Adjacent to Scorpius was the Teapot (the asterism in Sagittarius). It, too, was at about 5° to 10° declination and was completely horizontal! Ascella and Kaus Borealis were level with the horizon and Kaus Borealis pointed straight up. Never saw it level before. Came close in Utah. All stars within the asterism were very easily located and identified. 

10:15 PM - 10:26 PM
According to SkySafariPro, Jupiter was located in Virgo. Located Spica. Jupiter was bright and at a similar declination to Spica. Virgo seemingly wrapped her arm around the planet. 
Saturn was also visible this evening. Found Saturn adjacent to Antares in Scorpius.

10:42 PM
I noticed a satellite going across my visual field from West to East. My phone identified it as Taingong.

11:02 PM
Was looking in the general area of Virgo when an iridium flare caught my eye travelling SW to NE above Spica towards Jupiter.

11:16 PM
With the Teapot so high and level against the horizon, it was easy to find M6 (Butterfly Cluster) by going 1.5 FOV from Kaus Borealis.

11:18 PM
I decided that given Spica was so bright, I would use my S&T Pocket Atlas to identify the other stars in this constellation. 

Not disappointed!
   a) 109, τ, &mu:, and Syrma/ι were the first stars in addition to Spica that I could see.
   b) Next came ξ, Vindemiatrix, Porrima. Vindemiatrix was particularly bright.

10:30 PM
Started at Kaus Borealis and followed a line to the midpoint in the spout, then the same distance to M8. M20 was just a little above M8 in the same FOV. This was not difficult to find given the excellent sky conditions.

10:37 PM
Could see all the stars in the Big Dipper naked eye; did not use binoculars. Polaris was easily found using the Dipper's pointer stars. I did not attempt to find Ursa Minor stars this evening.

11:28 PM
I knew Delphinus was near Altair and Cygnus. Found the stars naked eye but it did take a while to locate all 5 star. When I tried using my binoculars, there were too many stars for these untrained eyes to single out the 5 stars of Delphinus.

11:38 PM
I turned around toward the Warm Room and storage shed to see Cassiopeia and 3 of the 4 stars in the Square of Pegasus. I visually drew a line from Schedar towards Alpheratz and guessed where M31 was located. I was lucky in that I found it as soon as I held up my binoculars. The oval shape of the Galaxy was grey with a slightly brighter centre. I did not look for the remaining parts of Pegasus at this time.

12:02 AM
M22 was easy to find using the lid of the Teapot. Using the 10x30 IS binoculars, I went left of the top of the lid of the Teapot (Kaus Borealis) about 30° to a small group of stars shaped like a "Y" then went past them to M22. It appeared as a grey fuzzy object with no discernible stars.

12:05 AM
I visually drew a line from Kaus Australis to Kaus Borealis, then extended the line 3/4 of the distance more. M25 appeared as a grey fuzzy round object in the binoculars.

1:40 AM
Jerry and I knew M11 was somewhere near Aquila, at or near the edge of what we referred to as the bright bay above the Teapot. He found it with the 15x70 binoculars mounted on my tripod. The open cluster was small, grey and compact. To find M11, we located the semi-circle of stars (similar in configuration to Corona Borealis). We followed the stars counter-clockwise and they pointed to M11.

NOTE: Later on June 27, 2017, Dave Chapman told us M11 is sometimes referred to as the "golf ball" as some of the stars adjacent to it seemingly form a "golf club". In reviewing the photos Jerry took earlier, we were easily able to identify both the ball and the club. Note that the club is upside-down so to speak.

 

Similar Items

Settings4.053MBMemory Usage85.04msRequest 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" => 1745767658 "last" => 1745767658...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (83.09KB) (1.03ms)
  • afterInitialise (1.34MB) (19.21ms)
  • afterRoute (235.23KB) (4.55ms)
  • beforeRenderComponent com_content (32.99KB) (1.75ms)
  • Before Access::preloadComponents (all components) (33.52KB) (536μs)
  • After Access::preloadComponents (all components) (121.39KB) (1.11ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (23μs)
  • After Access::preloadPermissions (com_content) (347.26KB) (1.28ms)
  • Before Access::getAssetRules (id:287 name:com_content.article.89) (18.65KB) (38μs)
  • After Access::getAssetRules (id:287 name:com_content.article.89) (8.3KB) (97μs)
  • Before Access::getAssetRules (id:1 name:root.1) (204.36KB) (8.07ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (36μs)
  • afterRenderComponent com_content (299.45KB) (12.53ms)
  • afterDispatch (648B) (759μs)
  • beforeRenderRawModule mod_menu (Main Menu) (61.86KB) (1.5ms)
  • afterRenderRawModule mod_menu (Main Menu) (181.31KB) (2.38ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (8μs)
  • afterRenderModule mod_menu (Main Menu) (6.86KB) (224μs)
  • beforeRenderRawModule mod_finder (Search) (2KB) (94μs)
  • afterRenderRawModule mod_finder (Search) (370.85KB) (4.97ms)
  • beforeRenderModule mod_finder (Search) (704B) (10μs)
  • afterRenderModule mod_finder (Search) (3.28KB) (153μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (536μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (14KB) (1.1ms)
  • beforeRenderModule mod_articles_archive (Archived Articles) (720B) (9μs)
  • afterRenderModule mod_articles_archive (Archived Articles) (2.95KB) (214μs)
  • beforeRenderRawModule mod_syndicate (Syndication) (848B) (21μs)
  • afterRenderRawModule mod_syndicate (Syndication) (3.46KB) (142μs)
  • beforeRenderModule mod_syndicate (Syndication) (704B) (4μs)
  • afterRenderModule mod_syndicate (Syndication) (2.47KB) (67μs)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (128B) (101μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (104.07KB) (10.74ms)
  • beforeRenderModule mod_tags_similar (Similar Items) (704B) (13μs)
  • afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (210μs)
  • beforeRenderRawModule mod_footer (Footer) (504B) (102μs)
  • afterRenderRawModule mod_footer (Footer) (4.84KB) (437μs)
  • beforeRenderModule mod_footer (Footer) (704B) (8μs)
  • afterRenderModule mod_footer (Footer) (2.97KB) (123μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (592B) (24μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.44KB) (148μs)
  • beforeRenderModule mod_menu (Bottom Menu) (720B) (5μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.38KB) (70μs)
  • afterRender (213.8KB) (10.05ms)
  • 1 x afterInitialise (1.34MB) (22.59%)
    19.21ms
    1 x afterRenderComponent com_content (299.45KB) (14.73%)
    12.53ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (104.07KB) (12.63%)
    10.74ms
    1 x afterRender (213.8KB) (11.82%)
    10.05ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (204.36KB) (9.49%)
    8.07ms
    1 x afterRenderRawModule mod_finder (Search) (370.85KB) (5.85%)
    4.97ms
    1 x afterRoute (235.23KB) (5.35%)
    4.55ms
    1 x afterRenderRawModule mod_menu (Main Menu) (181.31KB) (2.8%)
    2.38ms
    1 x beforeRenderComponent com_content (32.99KB) (2.06%)
    1.75ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (61.86KB) (1.77%)
    1.50ms
    1 x After Access::preloadPermissions (com_content) (347.26KB) (1.51%)
    1.28ms
    1 x After Access::preloadComponents (all components) (121.39KB) (1.3%)
    1.11ms
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (14KB) (1.29%)
    1.10ms
    1 x afterLoad (83.09KB) (1.21%)
    1.03ms
    1 x afterDispatch (648B) (0.89%)
    759μs
    1 x Before Access::preloadComponents (all components) (33.52KB) (0.63%)
    536μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (0.63%)
    536μs
    1 x afterRenderRawModule mod_footer (Footer) (4.84KB) (0.51%)
    437μs
    1 x afterRenderModule mod_menu (Main Menu) (6.86KB) (0.26%)
    224μs
    1 x afterRenderModule mod_articles_archive (Archived Articles) (2.95KB) (0.25%)
    214μs
    1 x afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (0.25%)
    210μs
    1 x afterRenderModule mod_finder (Search) (3.28KB) (0.18%)
    153μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.44KB) (0.17%)
    148μs
    1 x afterRenderRawModule mod_syndicate (Syndication) (3.46KB) (0.17%)
    142μs
    1 x afterRenderModule mod_footer (Footer) (2.97KB) (0.14%)
    123μs
    1 x beforeRenderRawModule mod_footer (Footer) (504B) (0.12%)
    102μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (128B) (0.12%)
    101μs
    1 x After Access::getAssetRules (id:287 name:com_content.article.89) (8.3KB) (0.11%)
    97μs
    1 x beforeRenderRawModule mod_finder (Search) (2KB) (0.11%)
    94μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.38KB) (0.08%)
    70μs
    1 x afterRenderModule mod_syndicate (Syndication) (2.47KB) (0.08%)
    67μs
    1 x Before Access::getAssetRules (id:287 name:com_content.article.89) (18.65KB) (0.04%)
    38μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.04%)
    36μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (592B) (0.03%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.03%)
    23μs
    1 x beforeRenderRawModule mod_syndicate (Syndication) (848B) (0.02%)
    21μs
    1 x beforeRenderModule mod_tags_similar (Similar Items) (704B) (0.02%)
    13μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_articles_archive (Archived Articles) (720B) (0.01%)
    9μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    8μs
    1 x beforeRenderModule mod_footer (Footer) (704B) (0.01%)
    8μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0.01%)
    5μs
    1 x beforeRenderModule mod_syndicate (Syndication) (704B) (0%)
    4μs
46 statements were executed, 5 of which were duplicates, 41 unique28.58ms193.43KB
  • SELECT @@SESSION.sql_mode;136μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `lb8l6_session` WHERE `session_id` = ?142μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = :session_id LIMIT 182μ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.46ms944BParams/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` = 1424μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lb8l6_viewlevels`208μ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` = :guest162μ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`626μ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`568μ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`430μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lb8l6_content` WHERE `alias` = :segment AND `catid` = :id188μs1.34KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `lb8l6_languages` WHERE `published` = 1 ORDER BY `ordering` ASC198μ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` = 1313μ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)592μ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` = 0586μs29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lb8l6_content`460μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `lb8l6_content` SET `hits` = (`hits` + 1) WHERE `id` = '89'534μ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)545μ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`465μ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)429μs4KBParams/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.id191μ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`438μ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 ASC912μ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` = :itemid682μ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`600μ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.id213μ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`457μs1.94KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `lb8l6_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1338μ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)251μ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 10249μ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.35KBParams/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) AND `t`.`access` IN (:preparedArray3,:preparedArray4) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray5,:preparedArray6) 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.01ms3.11KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:206Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key154μs3.87KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key158μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key186μs1.37KBParams/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` = :key93μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `lb8l6_schemaorg` WHERE `itemId` = :itemId AND `context` = :context280μ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)473μ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` = 1231μ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.id230μ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.id158μ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.id172μs1.48KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key187μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = ?299μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `lb8l6_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?556μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy