Skip to main content

[From the 2023 Holiday Magazine]

WRITTEN by Samantha Bosshart, Saratoga Springs Preservation Foundation
Photos provided (unless Noted)


As you drive north on Broadway on a snowy day, you most likely will be stopped at the long light where Broadway intersects with Route 50, Van Dam Street, and North Broadway. Take a moment to go back in time, nearly 200 years ago. Imagine trains slowly passing through that intersection, not cars. Imagine rolling hills as you look north, not grand mansions. One of the first houses built north of that intersection is 581 North Broadway. Today, it is considered the oldest house that remains on North Broadway.  

The two-story Greek Revival style residence was built on the land that had been previously owned by Judge Henry Walton. Walton, who was born in New York City and studied law under Aaron Burr, came to Saratoga Springs in 1816 to take possession of real estate that "descended to him from his father and uncle," who had received this land as part of the Kayaderosseras Patent in the Partition of 1792. Within a few years he became one of the largest landholders in Saratoga Springs, and his real estate "included all of the present village, except that portion lying south of Congress Street and the mineral fountains." Walton was the first Surrogate Judge of Saratoga County, and he built “Wood Lawn,” a "beautiful country-seat," today the site of Skidmore College.  

A historic photograph showing the Gothic Revival style porch that was added after the house was built. The Gothic Revival style was popular from 1840 to 1880.

A 1976 photo showing the porch
removed. In 1999 the front porch was
restored based on the historic photograph.

According to Reminiscences of Saratoga, Isaac Taylor purchased several lots, including what today is 581 North Broadway, from Henry Walton in November 1828. Taylor enlarged an existing farmhouse and established a boarding house named Washington Hall. In 1836, Taylor sold Washington Hall and the property at 581 North Broadway to Joel Root. Unfortunately, early tax assessments do not provide specific addresses for taxes paid. Therefore, it is difficult to determine the exact date of construction and who built the house. Most likely, Joel Root built the house at the time he purchased 581 North Broadway. 

The house was built in the Greek Revival style, the dominant style of American domestic architecture between 1830 – 1850. The front gable with a wide band of trim forms a pediment that gives it the appearance of a small Greek temple. Typical of the style, it has a symmetrical design, engaged pilasters at the corners, and a front door surrounded by narrow sidelights and transom above.  

Joel Root was born in 1790 in Connecticut.  In 1815, he married his wife Piera, also from Connecticut. He owned Washington Hall that was located north of 581 North Broadway. Reminiscences of Saratoga described Root as someone who “retained his vigor of mind and body to the close of a long life, studded with many charitable acts. He was strictly temperate in every sense of the word, and to this is owing the hardiness of his later years.” According to the deed records, Joel and Piera Root and Chauncey Ives and his wife Amanda sold 581 North Broadway in 1850.  

The property then had a series of owners between 1850 and 1858, including DeWitt C. Hay, a bank-note engraver and landscape artist who in 1850 was one of the founding members of the New York Watercolor Society; John A. Dake, a produce and commission merchant; Chauncey Kilmer, owner of a large paper mill in Rock City Falls; Stella and Gideon Putnam and Henry and Sarah Munsell, residents of New York City. John H. White acquired the property in 1858 and owned it for 20 years until he defaulted on his mortgage in 1878. 

That year, Samuel Freeburn acquired the property. Samuel Freeburn was born in Ireland in 1819. He moved to Saratoga Springs in or around 1850. He was a mason who is known for discovering the Hathorn Spring in 1868 while he was employed to excavate and build the foundation for the new ballroom for the Congress Hall, a grand hotel that was located across Spring Street. The spring was named in honor of Henry H. Hathorn, the owner of Congress Hall who developed the spring. According to 1878 Nathaniel Bartlett Sylvester’s History of Saratoga County, New York, the Hathorn Spring became “one of the most valuable springs in Saratoga” and large quantities of water were bottled and sold in the “leading towns and cities of the United States and Canada.”  

Freeburn was married to Jane, who was also from Ireland, and together they raised their two daughters, Eliza and Margaret, at 581 North Broadway. On April 29, 1890, Eliza married Lewis H. Hays of A.S. Hays & Son, a confectionery shop at 425 Broadway, at the residence. Two years later, Samuel passed away at the house. His death notice in The Argus, an Albany newspaper, dated December 27, 1892, said he had “accumulated a modest competence and did much practically to build Saratoga.”  

Following Samuel’s death in 1892, Jane continued to reside in the house. According to the City Directories, Eliza and her husband Lewis moved into the house in 1895 with their two young daughters, Margaret and Katherine. After several illnesses, Jane died in the home at age 85. Her death notice in the Daily Saratogian on December 4, 1909, noted that she was one of the oldest members of the First Presbyterian Church, where in her younger years she took active interest in the societies of the church. 

Eliza and Lewis, who continued to operate the confectionary store at 425 Broadway, remained at 581 North Broadway. Margaret, a high school teacher, appears to have always lived with her parents. A year after Eliza and Lewis celebrated their 50th wedding anniversary, Eliza passed away on April 15, 1941, at the house where she was raised and married. Lewis passed away in 1948. Margaret continued to live in the house until 1952 when the property was acquired by Murray and Eta Teig, ending the 74-year history of the Freeburn family owning the home.  

Murray and Eta lived and operated Teig's Guest House, a boarding house, at 581 North Broadway. In addition, Murray sold paint and wallpaper at this address as indicated by classifieds listed in the Saratogian. In 1969, the Teigs sold the house. There were a series of subsequent owners: Edward and Mildred Hellmich, Martin and Nancy Rosenkranz, David Ash, and Lance and Shannon Bell. For periods of time the house was vacant or rented out to others.  

Jessica Niles, who was raised in the area, purchased the house in 2020 and lives there with her two dogs – Beau and Murphy. “I love the architecture and history of Saratoga Springs. Our city would not be what it is without preservation, which was why I was attracted to this house. It is one of the earliest houses in Saratoga and has great historic character – the fireplaces, the trim, wood floors, and the windows,” shared Jessica.  

The house needed extensive work. “With the knowledge I had gained from my time serving on the board of directors of the Saratoga Springs Preservation Foundation and the guidance I knew the Foundation could provide during the work, I had the confidence to take on the challenge of a historic house,” said Jessica. It was through the Foundation that she learned about the New York State Historic Homeownership Rehabilitation Credit program, which provides a tax credit equal to 20% of qualified rehabilitation expenses. “I have saved thousands of dollars through this program,” continued Jessica. 

In 2022, Jessica received a Preservation Recognition Award from the Foundation for her efforts restoring the historic wood windows, significant character-defining features of the house. “I love the wavy glass and how the natural light comes into the house. Given the condition of the windows, restoring them was an immediate priority. I had custom wood storm windows made, which has substantially reduced noise and my energy bills,” she shared.  

Jessica plans to do more work to the house, but for now she is looking forward to cozying up with her dogs by the fireplace during the holiday season in her beautiful historic home. Thank you, Jessica, for being a wonderful steward of this home that has such a rich history.  

A photo looking north at the railroad crossing at Van Dam Street and
North Broadway, date unknown. George S. Bolster Collection, Saratoga Springs History Museum.  

7.998MBMemory Usage9.9sRequest Duration
Joomla! Version4.4.13
PHP Version8.3.21
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.42
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "8" "id" => "605" "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" => 1747375523 "last" => 1747375523...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (2.05ms)
  • afterInitialise (1.96MB) (8.68s)
  • afterRoute (375.98KB) (126ms)
  • beforeRenderComponent com_content (49.15KB) (907μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.63ms)
  • After Access::preloadComponents (all components) (116.7KB) (121ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (45μs)
  • After Access::preloadPermissions (com_content) (514.33KB) (138ms)
  • Before Access::getAssetRules (id:776 name:com_content.article.605) (18.65KB) (47μs)
  • After Access::getAssetRules (id:776 name:com_content.article.605) (7.38KB) (160μs)
  • afterRenderComponent com_content (1.64MB) (306ms)
  • afterDispatch (21.42KB) (1.02ms)
  • beforeRenderRawModule mod_finder () (375.81KB) (280ms)
  • afterRenderRawModule mod_finder () (1.95MB) (62.6ms)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (1.44KB) (238μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (182μs)
  • afterRenderRawModule mod_menu () (12.58KB) (799μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (113μs)
  • beforeRenderRawModule mod_custom () (920B) (78μs)
  • afterRenderRawModule mod_custom () (320.07KB) (99.21ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (3.15KB) (90μs)
  • beforeRenderRawModule mod_menu () (24B) (164μs)
  • afterRenderRawModule mod_menu () (552B) (566μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (80μs)
  • beforeRenderRawModule mod_custom () (920B) (90μs)
  • afterRenderRawModule mod_custom () (1.03KB) (212μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (73μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (109μs)
  • afterRenderRawModule mod_menu () (4.45KB) (524μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (1.34KB) (81μs)
  • beforeRenderRawModule mod_finder () (96B) (10μs)
  • afterRenderRawModule mod_finder () (7.28KB) (3.61ms)
  • beforeRenderModule mod_finder () (704B) (10μs)
  • afterRenderModule mod_finder () (1.34KB) (163μs)
  • beforeRenderRawModule mod_custom () (288B) (20μs)
  • afterRenderRawModule mod_custom () (912B) (255μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (59μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (233μs)
  • afterRenderRawModule mod_custom () (1008B) (168μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (53μs)
  • beforeRenderRawModule mod_custom () (472B) (66μs)
  • afterRenderRawModule mod_custom () (1008B) (118μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (46μs)
  • afterRender (298.95KB) (66.3ms)
  • 1 x afterInitialise (1.96MB) (87.74%)
    8.68s
    1 x afterRenderComponent com_content (1.64MB) (3.09%)
    306.31ms
    1 x beforeRenderRawModule mod_finder () (375.81KB) (2.83%)
    280.00ms
    1 x After Access::preloadPermissions (com_content) (514.33KB) (1.4%)
    138.27ms
    1 x afterRoute (375.98KB) (1.27%)
    126.14ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.22%)
    120.65ms
    1 x afterRenderRawModule mod_custom () (320.07KB) (1%)
    99.21ms
    1 x afterRender (298.95KB) (0.67%)
    66.30ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (0.63%)
    62.60ms
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.04%)
    3.61ms
    1 x afterLoad (444.73KB) (0.02%)
    2.05ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (0.02%)
    1.63ms
    1 x afterDispatch (21.42KB) (0.01%)
    1.02ms
    1 x beforeRenderComponent com_content (49.15KB) (0.01%)
    907μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.01%)
    799μs
    1 x afterRenderRawModule mod_menu () (552B) (0.01%)
    566μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.01%)
    524μs
    2 x afterRenderRawModule mod_custom () (1008B) (0%)
    286μs
    1 x afterRenderRawModule mod_custom () (912B) (0%)
    255μs
    1 x afterRenderModule mod_finder () (1.44KB) (0%)
    238μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0%)
    233μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0%)
    212μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0%)
    182μs
    2 x beforeRenderRawModule mod_custom () (920B) (0%)
    168μs
    1 x beforeRenderRawModule mod_menu () (24B) (0%)
    164μs
    1 x afterRenderModule mod_finder () (1.34KB) (0%)
    163μs
    1 x After Access::getAssetRules (id:776 name:com_content.article.605) (7.38KB) (0%)
    160μs
    2 x afterRenderModule mod_custom () (1.23KB) (0%)
    132μs
    1 x afterRenderModule mod_menu () (3.63KB) (0%)
    113μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0%)
    109μs
    1 x afterRenderModule mod_custom () (3.15KB) (0%)
    90μs
    1 x afterRenderModule mod_menu () (1.34KB) (0%)
    81μs
    1 x afterRenderModule mod_menu () (2.76KB) (0%)
    80μs
    1 x beforeRenderRawModule mod_custom () (472B) (0%)
    66μs
    1 x afterRenderModule mod_custom () (2.77KB) (0%)
    53μs
    1 x Before Access::getAssetRules (id:776 name:com_content.article.605) (18.65KB) (0%)
    47μs
    1 x afterRenderModule mod_custom () (2.43KB) (0%)
    46μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0%)
    45μs
    5 x beforeRenderModule mod_custom () (704B) (0%)
    20μs
    1 x beforeRenderRawModule mod_custom () (288B) (0%)
    20μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    18μs
    3 x beforeRenderModule mod_menu () (696B) (0%)
    12μs
    1 x beforeRenderRawModule mod_finder () (96B) (0%)
    10μs
53 statements were executed, 5 of which were duplicates, 48 unique10.11s876.02KB
  • SELECT @@SESSION.sql_mode;93μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?8.49s1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1937μ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)193μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`679μ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` = :guest9.24ms1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_k2" AND e.type = "component"163μ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"90μ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"71μ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"78μ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"70μ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"71μ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"97μ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"89μ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"83μ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"67μ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"69μ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"70μ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"80μ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"73μ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"68μ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"71μ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"74μ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"75μ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"69μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`459μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'95μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1145ms592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'207μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1120ms536B/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)119ms9.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` = 0134ms49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`757μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '605'11.92ms48B/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)107ms70.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`5.79ms3.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)301μ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`337μ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 ASC126ms4.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 DESC1.46ms3.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`6.41ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"140ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 605 AND `component_type` = "content"124ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 15.99ms592B/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)41.19ms584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 18.19ms688.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 ASC95.02ms4.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)1.79ms584B/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` = 163.01ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?337ms1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?8.2ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy