Skip to main content

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

 

There is no question when you enter Sonny and Julie Bonacio’s house at 22 Greenfield Avenue that someone loves Christmas.  There is a uniquely decorated tree in nearly every room.  “I love the holidays!” exclaimed the always enthusiastic, bubbly Julie.  It should not be any surprise to anyone who knows Julie that if she loves something she goes big.  With a laugh, their daughter Gianna commented, “I thought my parent’s marriage would end over Christmas decorations.”  Sonny readily admits “I’m 0-30 in curtailing Julie’s Christmas decorating scope!”  

What may surprise most is that Sonny and Julie live in a historic house, not a new house that Bonacio Construction could have easily built.  In the first 10 years of their marriage, they moved 10 times as they moved from project to project.  After they sold their house on Lefferts Street, they were in need of a temporary place to live. “We had purchased two lots in Meadowbrook and were planning to build. Our attorney at the time, offered to rent his house to us,” explained Julie.  “We moved in, fell in love with it, and never left,” laughed Sonny.  “We love its architecture and the history,” he continued.  “The front porch, the beautiful woodwork, the carriage house, and the location close to downtown – all of it!” added Julie. 

Circa 1930 photo of 22 Greenfield Avenue.
The Queen Anne style house, built in 1886, was designed by prominent architect S. Gifford Slocum. Photo courtesy of "George S. Bolster Collection, Saratoga Springs History Museum." 

It is easy to see why they fell in love with the Queen Anne style house designed by prominent local architect S. Gifford Slocum.  The house, today hidden by trees, is much larger than it appears from Greenfield Avenue.  Unlike most houses in Saratoga Springs, the primary façade does not face the street.  The ornate front door and long porch face east out of view.  The asymmetrical house features gables, projecting bays, decorative shingles, and half-timber detailing.  Typical of Slocum's designs, the house features a foundation and first floor with rough-faced stone and pink mortar. 

Samuel Gifford Slocum opened his architecture practice in Saratoga Springs in 1881.  Three years later, Phoebe E. Slocum, S. Gifford Slocum’s wife, is listed on the deed for the vacant land located at 22 Greenfield Avenue.  The house that became their residence was constructed in 1886.  Slocum designed many houses throughout Saratoga Springs, including 1 Fifth Avenue, 605 North Broadway 795 North Broadway, and 107 and 115 Union Avenue.  He also designed several prominent commercial and public buildings – 358 Broadway; 510 Broadway, today the Algonquin; 511 Broadway; and the former fire house at 543 Broadway.

An 1886 advertisement in The Glens Falls Times, showed that Slocum had expanded, listing offices in Saratoga Springs and Glens Falls.  In 1888, the Slocums sold the house at 22 Greenfield Avenue, appearing to relocate to New York City, to Dr. Edward B. Atkins of Essex, New York, who may have summered in Saratoga Springs.  On February 19, 1890, The Troy Daily Times reported that Akins “sold his Greenfield Avenue cottage to Chauncey Kilmer, the millionaire papermaker of Rock City Falls.”  Kilmer is never listed as living at the house.  

Kilmer may have most likely purchased the residence as a wedding present for his granddaughter, Mary K. Kilmer.  She married Walter P. Butler on July 9, 1890, only months after the April 10, 1890, deed recorded his ownership.  The city directories list Walter and Mary as living in the house the year they were married. However, it was not until 1898 that Chauncey Kilmer and his wife deeded the property to Mary Butler.  Over time, Mary acquired the adjacent properties located at 178 Woodlawn Avenue and 26 Greenfield Avenue, which had a house that now longer exists. 

Walter P. Butler was a prominent attorney and president of Saratoga National Bank.  One of his landmark cases was when he served as the defense attorney for the Saratoga Vichy Spring Company when the La Republique of Francaise sought to prevent the company from using the name Vichy.  The case was taken to the Supreme Court of the United States where in 1903 it was decided in favor of the Saratoga Vichy Spring Company.

In 1915, Butler became the first mayor of the city of Saratoga Springs following its incorporation.  While serving as mayor, he took the lead in rewriting the City Charter, simplifying it, and clarifying various taxing districts; drafting city ordinances; and organizing city departments. He served one term and refused reelection.  

The Butlers would often travel for the summer season and rent their home.  In the late 1800s and early 1900s, Lillian Russell, a famous actress and singer known for her beauty and style, was known to occupy the Butler residence.  Millionaire Diamond Jim Brady, who was known for his many pieces of jewelry he wore, including his favorite 25.5 carat ring, rented the house for Lillian.  She was said to have graciously tossed pennies to the children who gathered outside her house to watch her.  

Both Walter and Mary were philanthropic.  He was the chairman of the Saratoga Springs branch of the American Red Cross from 1917 to 1939, a member of the Board of Trustees of the Presbyterian Church, and a member of the Saratoga Lodge of Elks.  Mary was a member of the board of Managers of the Saratoga Hospital for more than 35 years, serving as secretary for 33 years.  She was also an original member of the Board of Trustees for Skidmore School of Arts, which became Skidmore College in 1922.   She was manager and served as the first president of the Hawley Home for Children following the death of Reverend Hawley for which the home as named after.  She also was actively involved with the Presbyterian Church among many other activities.  She and her husband raised their two sons, Clarence Kilmer Butler and John Prentiss Butler at 22 Greenfield Avenue.  Mary passed away in 1938 and Walter died in 1942.  

In 1943, Elizabeth A. Winde acquired 22 Greenfield Avenue.  She owned 605 North Broadway and converted it to the Beverly Manor Rooming and Tourist Home. The city directories list the house as vacant until 1948 when it was listed as the Beverly Annex, which was advertised as having large and small apartments, furnished, and unfurnished to rent.  Winde operated the Beverly Manor and Annex until 1969 when she defaulted on her mortgage.  

The house had a series of owners prior to Sonny and Julie purchasing the house from Keith Ferrara in 2005.  “It was the perfect place to raise our three children – Gianna, Luca, and Will.  It was always filled with their friends.  The house continues to be a place for their friends to gather during the holidays,” said Julie.  Julie’s parents moved into the carriage house not long after, providing help with the children as Sonny and Julie built Bonacio Construction and Julie & Co. Realty into the successful businesses that they are today.   

"We understand that preserving architecture and history is important to the fabric of our community,” continued Sonny, who has not only been involved with many new large-scale developments, but also the rehabilitation of nearly 40 historic buildings throughout Saratoga Springs – the Algonquin, Caffé Lena, Van Raalte Mill, and Rip Van Dam as well many houses, including several on North Broadway.  

It was not until 2020 that Sonny and Julie did extensive work to the house.  The house was rewired, replumbed, insulated, and a new HVAC system was installed.  The exterior and interior were also repainted.  They made an effort to retain the original, historic windows, decorative woodwork, and fireplaces.  The focal point of the house, the kitchen where Sonny, his mom, and Gianna cook delicious meals, was expanded. A pool was installed, and a large garage addition was built.  The garage accommodates their fun cars – some of which include the 1972 Chevy K10 truck that Sonny had when he was 16 that his employees purchased and returned to him when he turned 50 as well as the 1958 Corvette convertible that Sonny bought Julie for her 40th birthday. 

This holiday season, the house will once again be filled with near and dear family and friends.  Wishing you and the Bonacio family a happy holiday season! 

8.119MBMemory Usage169msRequest 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" => "8" "id" => "367" "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" => 1747126450 "last" => 1747126450...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.76KB) (2.91ms)
  • afterInitialise (1.96MB) (27.63ms)
  • afterRoute (375.4KB) (4.83ms)
  • beforeRenderComponent com_content (50.17KB) (760μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.6ms)
  • After Access::preloadComponents (all components) (119.86KB) (1.36ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (13μs)
  • After Access::preloadPermissions (com_content) (511.16KB) (1.25ms)
  • Before Access::getAssetRules (id:526 name:com_content.article.367) (18.65KB) (31μs)
  • After Access::getAssetRules (id:526 name:com_content.article.367) (7.38KB) (89μs)
  • afterRenderComponent com_content (1.68MB) (98.11ms)
  • afterDispatch (21.42KB) (1.08ms)
  • beforeRenderRawModule mod_menu () (416.23KB) (12.24ms)
  • afterRenderRawModule mod_menu () (58.84KB) (1.32ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.73KB) (184μs)
  • beforeRenderRawModule mod_finder () (1.45KB) (11μs)
  • afterRenderRawModule mod_finder () (2.01MB) (5.55ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (2.82KB) (86μs)
  • beforeRenderRawModule mod_custom () (16B) (188μs)
  • afterRenderRawModule mod_custom () (318.97KB) (1.06ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (3.27KB) (56μs)
  • beforeRenderRawModule mod_menu () (24B) (77μs)
  • afterRenderRawModule mod_menu () (552B) (413μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (63μs)
  • beforeRenderRawModule mod_custom () (920B) (57μs)
  • afterRenderRawModule mod_custom () (1.03KB) (134μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (60μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (126μs)
  • afterRenderRawModule mod_menu () (4.45KB) (412μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (70μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (6.91KB) (909μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (72μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (158μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (5.95KB) (150μs)
  • afterRenderRawModule mod_custom () (1008B) (130μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (47μs)
  • beforeRenderRawModule mod_custom () (8B) (57μs)
  • afterRenderRawModule mod_custom () (1008B) (111μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (42μs)
  • afterRender (243.17KB) (4.4ms)
  • 1 x afterRenderComponent com_content (1.68MB) (58.01%)
    98.11ms
    1 x afterInitialise (1.96MB) (16.34%)
    27.63ms
    1 x beforeRenderRawModule mod_menu () (416.23KB) (7.24%)
    12.24ms
    1 x afterRenderRawModule mod_finder () (2.01MB) (3.28%)
    5.55ms
    1 x afterRoute (375.4KB) (2.86%)
    4.83ms
    1 x afterRender (243.17KB) (2.6%)
    4.40ms
    1 x afterLoad (444.76KB) (1.72%)
    2.91ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (0.94%)
    1.60ms
    1 x After Access::preloadComponents (all components) (119.86KB) (0.8%)
    1.36ms
    1 x afterRenderRawModule mod_menu () (58.84KB) (0.78%)
    1.32ms
    1 x After Access::preloadPermissions (com_content) (511.16KB) (0.74%)
    1.25ms
    1 x afterDispatch (21.42KB) (0.64%)
    1.08ms
    1 x afterRenderRawModule mod_custom () (318.97KB) (0.63%)
    1.06ms
    1 x afterRenderRawModule mod_finder () (6.91KB) (0.54%)
    909μs
    1 x beforeRenderComponent com_content (50.17KB) (0.45%)
    760μs
    1 x afterRenderRawModule mod_menu () (552B) (0.24%)
    413μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.24%)
    412μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.14%)
    241μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.11%)
    188μs
    1 x afterRenderModule mod_menu () (3.73KB) (0.11%)
    184μs
    1 x afterRenderRawModule mod_custom () (912B) (0.09%)
    158μs
    1 x beforeRenderRawModule mod_custom () (5.95KB) (0.09%)
    150μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.08%)
    134μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.07%)
    126μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.07%)
    115μs
    1 x After Access::getAssetRules (id:526 name:com_content.article.367) (7.38KB) (0.05%)
    89μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.05%)
    86μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.05%)
    77μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.04%)
    72μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.04%)
    70μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.04%)
    63μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.03%)
    57μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.03%)
    57μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.03%)
    56μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    47μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.02%)
    42μs
    1 x Before Access::getAssetRules (id:526 name:com_content.article.367) (18.65KB) (0.02%)
    31μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    13μs
    1 x beforeRenderRawModule mod_finder () (1.45KB) (0.01%)
    11μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0%)
    8μs
55 statements were executed, 5 of which were duplicates, 50 unique14.67ms903.51KB
  • SELECT @@SESSION.sql_mode;91μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?152μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 160μ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)253μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`114μ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` = :guest188μ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"142μ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"98μ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"76μ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"59μ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"59μ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"81μ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"62μ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"60μ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"80μ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"56μ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"58μ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"56μ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"63μ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"55μ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"55μ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"55μ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"58μ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"57μ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"55μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`712μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'90μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1137μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'111μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 198μ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)480μ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` = 0572μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`939μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '367'372μ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)588μs78.12KBParams/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`354μ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)281μ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`248μ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 ASC310μ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 DESC1.47ms3.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`275μ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`948μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"335μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 367 AND `component_type` = "content"114μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1173μ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)174μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1358μ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 ASC278μ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)515μ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` = 1251μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?109μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?305μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy
  • DELETE FROM `jos_session` WHERE `time` < ?1.8ms440BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:80Copy