Skip to main content

PRESERVING SARATOGA
1870 Huldah & Deyoe Lohnas House -

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

In 1869, Leonard Farr purchased a vacant lot on Union Avenue, the portion of Congress Street that after the Civil War was renamed in commemoration of the Union Army, and immediately granted it to his daughter, Huldah Lohnas. Huldah and her husband Deyoe, owned a grocery store on Church Street. He was noted for being the first person to establish a dressed beef cooler and refrigerator.  

In 1870, the Lohnases built a large house in the Italianate style. According to the 1875 New York State Census, Huldah and Deyoe lived in the house with their two daughters, Nellie and Harriet; Huldah’s parents, Leonard and Amanda Farr; and two servants, a 40-year-old Irish woman and a 24-year-old man who was listed as a laborer and recorded as a former slave.  

In 1876, Deyoe was elected the Village president and the following year the Lohnas’ sold 104 Union Avenue. In 1917, the Business Men’s Association hosted a dinner in honor of Deyoe’s 81st birthday. Deyoe gave a speech about how Saratoga Springs had changed over the years. He recalled, “Since 1866 Broadway has been practically rebuilt. All the large hotels except the Union have been burned and reconstructed, and all the old wooden business blocks have been replaced by modern structures. The town has grown from a small village into a city.” Deyoe passed away in 1926. 

Judge Charles Smith Lester acquired the house from Deyoe. He and his wife Lucy and their children resided in the house until 1883 when he sold the property to Emelina and Mira Rood.  

In 1886, Harvey Leonard of Oberlin, Ohio, bought the property and lived there with his wife, Helen. By 1910, Leonard encountered financial troubles. Miriam Leslie acquired the property after foreclosing on three mortgages she gave to the Leonard family.  

Miriam met Frank Leslie, a publisher who was best known for “Frank Leslie’s Illustrated Newspaper,” when her second husband, Ephraim Squires, was the editor of Frank’s “Lady Magazine.” When Empraim fell ill, she permanently took over as editor. In 1873, she divorced her ill husband and shortly thereafter married Frank.  Frank and Miriam summered in Saratoga Springs and entertained many guests at their residence, Interlaken, on Saratoga Lake. In 1877, Miriam and Frank took a lavish train trip from New York to San Francisco. Miriam wrote “A Pleasure Trip from Gotham to the Golden Gate,” a book about their luxurious train excursion with colorful source of vignettes of western life—its Indians, scouts, and miners. Between the expense of the lavish trip and the effects of the economic depression of the 1870s, Frank's business was badly in debt. Upon his death in 1880, Frank left Miriam in a pile of lawsuits and with $300,000 of debt (today’s equivalent of nearly $9 million). Miriam legally changed her name to Frank Leslie, took over the publishing company, and rescued it from bankruptcy, which earned her the nickname “Empress of Journalism.” She later married and divorced Willie Wilde, the older brother of playwright Oscar Wilde.  

Mrs. Frank Leslie owned 104 Union Avenue for only one year and the house was listed as vacant.  In 1914, she passed away and left $130,000 to be divided among family and friends. She left her remaining $2 million estate to the women’s suffrage movement, one of the largest gifts to the movement. This was a surprise because she was never a visible supporter of the women’s right to vote. Her will was contested by many for years.  Ultimately, the suffragists received $1 million towards their cause.

In 1911, George and Margaret Shevlin moved into the residence with their three children and Margaret’s sister, Mary Foley. George was the owner of the Baker and Shevlin Company, a large foundry and machine works on Ballston Avenue. On May 9, 1911, The Saratogian announced George Shevlin’s purchase of the property and that he planned to “extensively improve” it. On August 8, 1911, The Saratogian reported “George F. Shevlin has a force of workmen making extensive changes … the old gable has been removed and a broad piazza built around the house.” 

Unfortunately, the Baker and Shevlin Company went bankrupt in 1917. Shevlin transferred the property to his sister-in-law Mary. However, the trustee for the bankruptcy successfully acquired the property after it was proven that Shevlin had transferred the property to Mary to shield the asset from his creditors.  

In 1917, Bertha Schwabe acquired 104 Union Avenue. Her husband, Max, had extensive glove knowledge and was the manager of the local Clark Textile. During a strike at the mill, Max “flourished a revolver” while he tried to break up a fight between strikers and Clark Textile employees, according to the July 23, 1919, The Saratogian. Although no one was hurt, the strikers went to court to get Max’s permit to carry a revolver revoked. They were only partially successful. The July 26, 1919, Schenectady Gazette, reported that after a “lengthy hearing,” Max’s license was revoked, but was issued a different license that “limited the use of the revolver to his own home or when he was taking the company’s payroll from the bank.”  

Mac Finn, proprietor of Mac Finn Drug Company at 396 Broadway, and his wife Mary purchased 104 Union Avenue on August 10, 1929, just a few months before the stock market crashed. However, they never lived there. They rented it out to others, including Wallace F. MacNaughton, a physician who lived and operated MacNaughton Sanatorium at the residence.  In 1941, Mac Finn transferred 104 Union Avenue and several properties on Broadway to James A. Leary, Finn’s business partner, in return for canceling promissory notes in excess of $300,000.

In 1944, Skidmore College acquired 104 Union Avenue and for 30 years it was known as the Kimball House, a dormitory. Upon Skidmore College relocating to its North Broadway campus, Verrazzano College acquired the building in 1972. Shortly after, Verrazzano College declared bankruptcy.  

In 1977, it was returned to a single-family residence by Shelley D. Corwin. Three years later, Alexander and Phyllis Aldrich purchased the property where they raised their children. Alexander “Sam” Aldrich was an attorney who chose public service and was a civil rights advocate who marched with Martin Luther King in Selma, Alabama. He was the first director of the Hudson River Valley Commission and later the commissioner of the New York State Office of Parks, Recreation and Historic Preservation. Later in life, he served as the attorney for the City of Saratoga Springs, SPAC, and Yaddo.  His wife Phyllis was an educator who was committed to establishing and advocating programs for gifted children. She established programs in 31 school districts and enrichment programs that benefitted over 2,000 students. 

In 1997, the Aldrichs sold the house to Stephan A. Jenkins and Katherine Malaga. In 2007, Richard and Leslie Ryall acquired the property and did an extensive rehabilitation of the deteriorated carriage house that was being used as a single-car garage. In 2010, the Ryalls lifted the building and temporarily moved it to allow for excavation of a new foundation to be constructed to adaptively reuse it as a three-bedroom guest house.   

In 2018, Zane and Brady Carruth, of Houston, Texas acquired the property. To learn more about Zane and Brady and their ownership of the property see Architecturally Speaking, page 93. Their home was recently featured on the Saratoga Springs Preservation Foundation’s Historic Homes Tour and hosted the annual Porch Party in June

7.949MBMemory Usage111msRequest 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" => "536" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749504523 "last" => 1749504523...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.31ms)
  • afterInitialise (1.96MB) (34.57ms)
  • afterRoute (375.48KB) (3.66ms)
  • beforeRenderComponent com_content (49.15KB) (710μs)
  • Before Access::preloadComponents (all components) (43.72KB) (1.79ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.29ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (23μs)
  • After Access::preloadPermissions (com_content) (516.75KB) (1.39ms)
  • Before Access::getAssetRules (id:706 name:com_content.article.536) (18.65KB) (42μs)
  • After Access::getAssetRules (id:706 name:com_content.article.536) (11.38KB) (69μs)
  • afterRenderComponent com_content (1.6MB) (38.24ms)
  • afterDispatch (21.42KB) (868μs)
  • beforeRenderRawModule mod_finder () (383.92KB) (8.77ms)
  • afterRenderRawModule mod_finder () (1.95MB) (6.18ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (138μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (213μs)
  • afterRenderRawModule mod_menu () (12.58KB) (775μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (105μs)
  • beforeRenderRawModule mod_custom () (920B) (68μs)
  • afterRenderRawModule mod_custom () (320.07KB) (1.39ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (60μs)
  • beforeRenderRawModule mod_menu () (24B) (75μs)
  • afterRenderRawModule mod_menu () (552B) (393μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (59μs)
  • beforeRenderRawModule mod_custom () (920B) (56μs)
  • afterRenderRawModule mod_custom () (1.03KB) (161μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (60μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (78μs)
  • afterRenderRawModule mod_menu () (4.45KB) (462μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (70μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (542μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (74μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (131μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (147μs)
  • afterRenderRawModule mod_custom () (1008B) (123μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (472B) (55μs)
  • afterRenderRawModule mod_custom () (1008B) (131μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (42μs)
  • afterRender (298.95KB) (2.96ms)
  • 1 x afterRenderComponent com_content (1.6MB) (34.6%)
    38.24ms
    1 x afterInitialise (1.96MB) (31.28%)
    34.57ms
    1 x beforeRenderRawModule mod_finder () (383.92KB) (7.94%)
    8.77ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.59%)
    6.18ms
    1 x afterRoute (375.48KB) (3.32%)
    3.66ms
    1 x afterLoad (444.73KB) (3%)
    3.31ms
    1 x afterRender (298.95KB) (2.68%)
    2.96ms
    1 x Before Access::preloadComponents (all components) (43.72KB) (1.62%)
    1.79ms
    1 x After Access::preloadPermissions (com_content) (516.75KB) (1.26%)
    1.39ms
    1 x afterRenderRawModule mod_custom () (320.07KB) (1.26%)
    1.39ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.17%)
    1.29ms
    1 x afterDispatch (21.42KB) (0.79%)
    868μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.7%)
    775μs
    1 x beforeRenderComponent com_content (49.15KB) (0.64%)
    710μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.49%)
    542μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.42%)
    462μs
    1 x afterRenderRawModule mod_menu () (552B) (0.36%)
    393μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.23%)
    254μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.19%)
    213μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.15%)
    161μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.13%)
    147μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.12%)
    138μs
    1 x afterRenderRawModule mod_custom () (912B) (0.12%)
    131μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.11%)
    124μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.1%)
    115μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.09%)
    105μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.07%)
    78μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    75μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    74μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    70μs
    1 x After Access::getAssetRules (id:706 name:com_content.article.536) (11.38KB) (0.06%)
    69μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    60μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    59μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    55μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    45μs
    1 x Before Access::getAssetRules (id:706 name:com_content.article.536) (18.65KB) (0.04%)
    42μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    42μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    23μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    14μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
53 statements were executed, 5 of which were duplicates, 48 unique19.05ms868.02KB
  • SELECT @@SESSION.sql_mode;160μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?337μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1282μ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)336μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`145μ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` = :guest252μ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"297μ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"2.79ms520B/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"205μ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"186μ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"233μ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"176μ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"183μ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"421μ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"140μ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"130μ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"115μ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"150μ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"118μ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"126μ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"132μ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"136μ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"115μ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"195μ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"122μ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"108μ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"97μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`648μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'115μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1151μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'121μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1134μ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)794μ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` = 0821μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`613μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '536'2.53ms48B/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)406μ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`288μ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)211μ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`294μ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 ASC298μ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 DESC962μs3.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`285μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 119 AND `component_type` = "menu"302μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 536 AND `component_type` = "content"149μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1229μ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)201μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1713μ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 ASC438μ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)150μ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` = 1133μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?105μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?266μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy