Skip to main content

           Written by Megin Potter  |  Photos by Super Source Media Studios

Once again, on a sunny day this spring, Lake Avenue second graders marched the short distance from their school to one of the oldest structures in Saratoga Springs, the Olde Bryan Inn on Maple Avenue. 

Awaiting their arrival is John Kosek, who worked in the building for 20 years. In late 1979, the Olde Bryan Inn restaurant opened at the site, and by January 1980, Kosek started as a line cook, later becoming their General Manager. 

Although he’s now worked at Longfellows Restaurant for a decade, and is currently General Manager there, for the past thirty years he has returned to the Olde Bryan Inn as a volunteer, hosting tours of the property for students in the Saratoga and Schuylerville school districts. 

“I grew up in a family of historians and I’ve always enjoyed history,” said Kosek. “I think it’s important for young students to get a feel for their local history and an appreciation for the people who came before us that built our city into what it is today.”

Starting at the Beginning

Guide John Kosek’s enthusiasm is visible as he begins an hour-long tour of the Olde Bryan Inn. 

The children respond to it immediately. 

They eagerly answer questions about the wording used on the historical marker in front of the building before hearing how, in the 1770s, colonists and Native Americans both had dwellings located near what was then called the “Medicine Spring of the Great Spirit,” the rocky cone in the valley below that spouted mineral water (now known as High Rock Spring). 

Even at such a young age, the students recognize the names of George Washington, General Phillip Schuyler, and his son-in-law Alexander Hamilton, who would come to be counted among the spring’s many visitors. 

“Saratoga was the summer place to be even when the Native Americans were here,” said Kosek.

A Peek into the Past

The group learns that previously, a log tavern and inn stood on this spot, built by Revolutionary War hero Alexander Bryan. Alexander’s son, John Bryan, built the stone structure that stands there today. 

While explaining some of the features of the federal style architecture, Kosek shows them a photo of the covered porch once attached to the building. When he points out the expressive oval “eyebrow windows” that look out onto Rock Street, it brings the house to life for the children. 

He also explains the patriotic symbolism painted by artist Frankie Flores on the “Saratoga Stripes” fiberglass horse sculpture perched by its main entrance. 

The Families Who Lived Here

Once inside, the children learn more about the Bryan family, as well as the Burnham Family, who built a brick addition onto the home and founded Burnham’s Hand Laundry there. Wealthy summer guests (including the Vanderbilt and the Whitney families) joined the local clientele in trusting the Burnhams to launder their finest things. 

The building was passed down to the Burnham’s daughter, Mrs. Pearl LaMontain, and then to her daughter, Mrs. Beatrice Veitch, who continued to operate the laundry with her husband until her death in 1953. The business closed the following year. 

The Veitch family remained at the residence until 1979. In 1981, the Olde Bryan Inn as we know it today was born when Steve Sullivan joined the building’s new owners, Dave Powers and Joe Wilkinson. Today, Sullivan and Powers also own Longfellows Inn and Restaurant on Union Avenue.

Stories of Strange Happenings

While sitting in the front bar area, the children are told how this space was originally the home’s kitchen. The large fireplace and its two side toasting ovens were later sealed over, then found again during renovations.

Moving into the front dining room, Kosek asks the students to imagine the house as it once was - heated by fireplaces that are still there; people coming and going through the front door (which is now blocked by a dining table), along the hallway and staircase that no longer remain.  

He then shares ghostly stories of furniture moving on its own, visions of a wandering woman in green, and other strange encounters that are said to have occurred since. 

Upstairs, they learn that where once there were bedrooms, now is office space and restrooms. They take turns looking down to the dining area below before venturing further up the building’s winding staircase into the former attic area to peek through those interesting eyebrow windows they saw from outside. 

History for the Future

To conclude the tour, visitors peruse a table of artifacts discovered at the site over the years, including; oyster and clam shells that were likely ground up to use as mortar, a clay pipe, coins, ceramic plate shards, weathered nails, animal bones, and more. 

Over a lunch of grilled cheese sandwiches, students Wesley George and Brodie Macejka agree with many of their classmates - hearing ghost stories and seeing through the eyebrow windows was their favorite part of the tour.

“Seeing upstairs made me feel like it was an actual house and that I’m in it with the people that lived here,” added Georgia Zansie.

Their teacher, Polly O’Connell has been bringing her students on the field trip for more than 15 years.

“They enjoy the ghost lore,” she said, adding, “It’s important children know how the country formed and about the hard work and bravery of our founding fathers and the colonists to gain independence.” 

Parent chaperone Nora Pellegrino and her son, Jack, already enjoy dining at the Old Bryan Inn and were curious about its history. 

“It gives it a whole other layer,” she said. “Learning about history is more important than ever for children. Learning about past mistakes and not making the same again is so important. In today’s fast-paced society, we need to make sure kids have the time to reflect on things rather than just act.”

Learn more about the history of the Olde Bryan Inn,
123 Maple Ave, Saratoga Springs, on Facebook
@OldeBryanInn@40

8.11MBMemory Usage124msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.20
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.42
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "14" "id" => "377" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:74 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747018923 "last" => 1747018923...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.75ms)
  • afterInitialise (1.96MB) (30.84ms)
  • afterRoute (375.09KB) (5.42ms)
  • beforeRenderComponent com_content (48.95KB) (1.01ms)
  • Before Access::preloadComponents (all components) (47.72KB) (1.75ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.23ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (15μs)
  • After Access::preloadPermissions (com_content) (507.06KB) (1.33ms)
  • Before Access::getAssetRules (id:536 name:com_content.article.377) (18.65KB) (25μs)
  • After Access::getAssetRules (id:536 name:com_content.article.377) (7.38KB) (98μs)
  • afterRenderComponent com_content (1.7MB) (46.12ms)
  • afterDispatch (29.42KB) (1.1ms)
  • beforeRenderRawModule mod_menu () (399.31KB) (11.6ms)
  • afterRenderRawModule mod_menu () (58.91KB) (1.41ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.79KB) (226μs)
  • beforeRenderRawModule mod_finder () (1.52KB) (11μs)
  • afterRenderRawModule mod_finder () (1.95MB) (7.08ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (2.82KB) (90μs)
  • beforeRenderRawModule mod_custom () (16B) (227μs)
  • afterRenderRawModule mod_custom () (320.14KB) (1.3ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.27KB) (57μs)
  • beforeRenderRawModule mod_menu () (24B) (77μs)
  • afterRenderRawModule mod_menu () (552B) (566μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (66μs)
  • beforeRenderRawModule mod_custom () (920B) (60μs)
  • afterRenderRawModule mod_custom () (1.03KB) (140μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (60μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (138μs)
  • afterRenderRawModule mod_menu () (4.45KB) (439μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (87μs)
  • beforeRenderRawModule mod_finder () (96B) (9μs)
  • afterRenderRawModule mod_finder () (7.32KB) (539μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (83μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (131μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (5.95KB) (166μs)
  • afterRenderRawModule mod_custom () (1008B) (132μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (8B) (58μs)
  • afterRenderRawModule mod_custom () (1008B) (110μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (43μs)
  • afterRender (314.95KB) (4.79ms)
  • 1 x afterRenderComponent com_content (1.7MB) (37.2%)
    46.12ms
    1 x afterInitialise (1.96MB) (24.87%)
    30.84ms
    1 x beforeRenderRawModule mod_menu () (399.31KB) (9.36%)
    11.60ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.71%)
    7.08ms
    1 x afterRoute (375.09KB) (4.37%)
    5.42ms
    1 x afterRender (314.95KB) (3.86%)
    4.79ms
    1 x afterLoad (444.73KB) (3.02%)
    3.75ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.41%)
    1.75ms
    1 x afterRenderRawModule mod_menu () (58.91KB) (1.14%)
    1.41ms
    1 x After Access::preloadPermissions (com_content) (507.06KB) (1.08%)
    1.33ms
    1 x afterRenderRawModule mod_custom () (320.14KB) (1.05%)
    1.30ms
    1 x After Access::preloadComponents (all components) (116.7KB) (0.99%)
    1.23ms
    1 x afterDispatch (29.42KB) (0.88%)
    1.10ms
    1 x beforeRenderComponent com_content (48.95KB) (0.81%)
    1.01ms
    1 x afterRenderRawModule mod_menu () (552B) (0.46%)
    566μs
    1 x afterRenderRawModule mod_finder () (7.32KB) (0.43%)
    539μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.35%)
    439μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.19%)
    242μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.18%)
    227μs
    1 x afterRenderModule mod_menu () (3.79KB) (0.18%)
    226μs
    1 x beforeRenderRawModule mod_custom () (5.95KB) (0.13%)
    166μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.11%)
    140μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.11%)
    138μs
    1 x afterRenderRawModule mod_custom () (912B) (0.11%)
    131μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.09%)
    115μs
    1 x After Access::getAssetRules (id:536 name:com_content.article.377) (7.38KB) (0.08%)
    98μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.07%)
    90μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.07%)
    87μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    83μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.06%)
    77μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    66μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.05%)
    60μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.05%)
    58μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.05%)
    57μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    45μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    43μs
    1 x Before Access::getAssetRules (id:536 name:com_content.article.377) (18.65KB) (0.02%)
    25μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    15μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_finder () (1.52KB) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
54 statements were executed, 5 of which were duplicates, 49 unique12.49ms886.08KB
  • SELECT @@SESSION.sql_mode;121μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?169μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 169μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)274μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`130μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest215μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_k2" AND e.type = "component"182μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_virtuemart" AND e.type = "component"84μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_easyblog" AND e.type = "component"75μs1.13KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jomclassifieds" AND e.type = "component"82μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_hikashop" AND e.type = "component"66μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rseventspro" AND e.type = "component"66μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_zoo" AND e.type = "component"110μs536B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jticketing" AND e.type = "component"74μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_icagenda" AND e.type = "component"71μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eventbooking" AND e.type = "component"71μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eshop" AND e.type = "component"79μs1.76KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rsblog" AND e.type = "component"77μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_mijovideos" AND e.type = "component"61μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_opencart" AND e.type = "component"67μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jcart" AND e.type = "component"62μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_djclassifieds" AND e.type = "component"66μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"63μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_phocacart" AND e.type = "component"64μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jshopping" AND e.type = "component"67μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_igallery" AND e.type = "component"64μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_dpcalendar" AND e.type = "component"64μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`563μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'91μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1172μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'117μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1107μs536B/plugins/system/yooessentials/modules/platform-joomla/src/Database.php:52Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_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)427μs9.94KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0527μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`927μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '377'345μs48B/libraries/src/Table/Table.php:1325Copy
  • 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 `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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)527μs62.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 `jos_categories` AS `s` INNER JOIN `jos_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`320μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)262μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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`289μ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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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 ASC350μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `jos_content` AS `a` LEFT JOIN `jos_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC765μs2.47KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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`309μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_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`924μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 130 AND `component_type` = "menu"306μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 377 AND `component_type` = "content"136μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1186μs592B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)220μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1841μs688.52KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • 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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC372μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)145μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • 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 `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1163μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?107μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?394μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy