Skip to main content

Written by Carol Godette  |  Photos provided (Unless Noted)

[From the 2025 Summer Magazine]

 

Beginning in 1893 Mary Brockway’s salon and lending library operated at 417 Broadway.

At the intersection of Broadway and Division Street, to me the epicenter of Broadway, an unassuming three-story brick building at 417 Broadway has witnessed two centuries of change and outlived nearly everything around it.

As its closest neighbors evolved and disappeared, the core structure of 417 Broadway has remained remarkably unchanged. It has stood as a silent witness to a downtown in flux.  It survived as the United States Hotel at the intersection of Broadway and Division Street was demolished and replaced with an ever-changing stream of neighbors: the Red Barn restaurant, Pope’s Pizza, Borders Bookstore, and the Fingerpaint offices. This stately building experienced the shift to a 1960s "automobile architecture,*” with the construction of the low-rise Downtowner Motel with a drive-up parking lot as its adjacent neighbor.

Portrait of Gideon Davison, the original owner of 417 Broadway, at the Saratoga History Museum.

One of the earliest maps of Saratoga Springs is a memory map from the Skidmore Mapping Collection. This 1820 map done from memory shows Gideon Davison‘s house as being one of the few structures on Broadway at that time.

The Other Gideon: A Building, A Printer, A Legacy

Much has been written about Gideon Putnam, Saratoga Springs's first entrepreneur. However, this building was the brainchild of a lesser-known Gideon who also impacted Saratoga Springs: Gideon Davison. Constructed in 1825, Davison's residence was one of the few brick buildings in Saratoga. It reflected his foresight and permanence and offered fire protection in the wooden structures of Broadway in the 1830s.

A native of Vermont, Davison apprenticed in the art of printing before refining his skills in New York City. When he arrived in Saratoga, the village had no newspaper. After consulting with local leaders, he set out to fill that void. In 1818, he launched The Saratoga Sentinel, the city's first newspaper. The weekly Sentinel was an immediate success, and today, its early editions offer a vivid window into the 19th-century life of a growing resort town.

For nearly 25 years—until 1842—he published the Sentinel from a small press in the rear of his sturdy three-story brick home.

In the great fire of 1865, flames swept through the wooden Marvin House next door and the original United States Hotel across the street. But 417's sturdy brick and stone construction effectively acted as a firewall, halting the fire's advance and sparing the rest of the block.

According to the 1899 Saratogian special issue Our County and Its People, "Mr. Davison was a man of great public spirit, being especially interested in the establishment and extension of railroads, to which several of the most active years of his life were devoted. He died October 1, 1869, aged seventy-eight. During the funeral, business on Broadway was suspended, and the bells of all the churches were rung."

Bible published in 1826 by Gideon Davison at his shop in the back of 417 Broadway. Davison published several types of books including tour guide books, a book analyzing the content of mineral waters, and a spelling book.

Two Centuries at the Heart of Saratoga

At the end of the 19th century, 417 Broadway continued to adapt to the changing rhythm of downtown Saratoga. Although the printing press no longer operated, the building remained in service to the public, adapting to the needs of the Gilded Age.

In the 1890s, the building housed a basement millinery shop and a second-story salon run by Mary L. Brockway, a resident chiropodist and beauty specialist. Her business reflected the growing popularity of wellness and grooming in Saratoga's resort era. Brockway offered services catering to locals and visitors, including hairdressing, manicures, facial massage, and scalp treatments. A 1906 ad boasts she was a "Marcel Waving specialist." Another ad invited readers to "meet their favorite author” by borrowing one of her 12,000 books for a 5-cent per week rental fee. I have to think some of these books were once part of the same library that Gideon had operated from his home.

As Saratoga Springs moved through the mid-20th century, 417 Broadway again adapted to meet the community's needs through medicine. The building became home to the office of Dr. Jacob Feynman, a World War II veteran who established a medical practice in his postwar years.

During Feynman's ownership in January 1957, the building again witnessed destruction—this time from across the street. A fierce blaze consumed most of the neighboring buildings on the Eastside of Broadway, but the flames did not leap across the road. Once more, 417 survived unscathed, a quiet constant amid chaos and loss.

At first, Dr. Feynman rented offices to other healthcare professionals, such as optometrist Dr. Lewis Taub, meeting healthcare needs in the heart of downtown. Like Gideon Davison before him, Dr. Feynman was deeply invested in the well-being of Saratoga Springs. He was a founding member of Temple Sinai, helping shape the city's growing Jewish community.

Local funeral director Mark Phillips recalls Dr. Feynman as a "coroner's physician." Funeral homes called upon him to certify and sign death certificates, particularly in cases where the deceased was not under active medical care—a quiet but essential role in the community's life (and death).

After Dr. Feynman's retirement in 1982, Broadway was in transition. The brick building became home to a rotating cast of small businesses. Over the next two decades, 417 Broadway housed a travel agency, a sewing center, and a hair and nail salon, all catering to the daily needs and rhythms of the downtown community.

In an ironic full-circle moment, the building that once housed Saratoga's first newspaper press under Gideon Davison became home to the Schenectady Gazette's Saratoga office.

 

An 1800s photo of the building. Photo courtesy of the Saratoga History Museum’s George S. Bolster Collection.

The building served as the office of Dr.  Jacob Feynman and the Schenectady Gazette. Photo courtesy of the George S Bolster Collection.

 

A New Vintage for an Old Address

In 1998, Melissa Evans was inspired by the wine bars she had discovered in New York City. She sensed a similar concept would fill a niche in Saratoga Springs—a sophisticated, relaxed setting for adults in the heart of downtown. While walking with her mother along Broadway that fall, she noticed a "For Sale" sign in the window of 417 Broadway. Gene and Lois Collins, longtime owners of the building and the adjacent Downtowner Motel, were ready to retire and move on.

The Evans family purchased the building and immediately began a million-dollar restoration and updating, after which Evans’ dream became a reality with the opening of The Wine Bar. Owning the building, she has said, protected the business from the escalating rents that have challenged many downtown restaurants. Her father handled much of the maintenance, and it remains a true hands-on family operation.

From the beginning, Melissa set a tone of intention and quality. "Nothing good happens after midnight," she often says—so the bar closes just after midnight each evening, a philosophy that has helped maintain its atmosphere and longevity. Over the past 25 years, adaptability has been key to The Wine Bar's success. The business has reinvented itself time and again, offering everything from a ventilated cigar lounge and live jazz downstairs (complete with baby grand piano) to date nights and even karaoke, always keeping pace with the evolving tastes of its loyal patrons.

And now, another transformation may be on the horizon. In May 2025, after 25 years of stewardship, the Evans family listed the building for sale, opening the door for a new chapter in the life of 417 Broadway. Whatever its future holds, one thing is sure: this unassuming brick building will continue to echo the spirit of Saratoga—resilient, evolving, and deeply rooted in history.

Author's note: Information courtesy of Saratoga Springs Preservation Foundation files; Broadway buildings file at the Saratoga Room, Saratoga Springs Public Library; The Saratoga Springs History Museum; research from Mitch Cohen; and interviews with Melissa Evans

Today this building is home to the successful business, The Wine Bar.

Saratoga Springs Preservation plaque verifying the 1825 date of the building.

8.162MBMemory Usage133msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.22
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.4.5
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "8" "id" => "885" "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" => 1751808506 "last" => 1751808506...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.69KB) (2.85ms)
  • afterInitialise (1.96MB) (32.65ms)
  • afterRoute (380.32KB) (4.78ms)
  • beforeRenderComponent com_content (48.96KB) (837μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.48ms)
  • After Access::preloadComponents (all components) (112.32KB) (5.52ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (40μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (1.79ms)
  • Before Access::getAssetRules (id:1060 name:com_content.article.885) (18.65KB) (58μs)
  • After Access::getAssetRules (id:1060 name:com_content.article.885) (7.38KB) (164μs)
  • afterRenderComponent com_content (1.76MB) (52.74ms)
  • afterDispatch (21.42KB) (1.01ms)
  • beforeRenderRawModule mod_finder () (396KB) (10.85ms)
  • afterRenderRawModule mod_finder () (1.95MB) (8.54ms)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (1.44KB) (186μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (229μs)
  • afterRenderRawModule mod_menu () (56.49KB) (1.23ms)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (108μs)
  • beforeRenderRawModule mod_custom () (920B) (70μs)
  • afterRenderRawModule mod_custom () (319.76KB) (1.32ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (51μs)
  • beforeRenderRawModule mod_menu () (24B) (66μs)
  • afterRenderRawModule mod_menu () (552B) (340μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (73μs)
  • beforeRenderRawModule mod_custom () (920B) (54μs)
  • afterRenderRawModule mod_custom () (1.03KB) (137μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (74μs)
  • afterRenderRawModule mod_menu () (4.45KB) (351μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (1.34KB) (66μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (530μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (70μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (112μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (51μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (142μs)
  • afterRenderRawModule mod_custom () (1008B) (108μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (40μs)
  • beforeRenderRawModule mod_custom () (472B) (51μs)
  • afterRenderRawModule mod_custom () (1008B) (93μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (61μs)
  • afterRender (306.95KB) (3.24ms)
  • 1 x afterRenderComponent com_content (1.76MB) (39.51%)
    52.74ms
    1 x afterInitialise (1.96MB) (24.46%)
    32.65ms
    1 x beforeRenderRawModule mod_finder () (396KB) (8.13%)
    10.85ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (6.4%)
    8.54ms
    1 x After Access::preloadComponents (all components) (112.32KB) (4.14%)
    5.52ms
    1 x afterRoute (380.32KB) (3.58%)
    4.78ms
    1 x afterRender (306.95KB) (2.43%)
    3.24ms
    1 x afterLoad (444.69KB) (2.14%)
    2.85ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.34%)
    1.79ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.11%)
    1.48ms
    1 x afterRenderRawModule mod_custom () (319.76KB) (0.99%)
    1.32ms
    1 x afterRenderRawModule mod_menu () (56.49KB) (0.92%)
    1.23ms
    1 x afterDispatch (21.42KB) (0.76%)
    1.01ms
    1 x beforeRenderComponent com_content (48.96KB) (0.63%)
    837μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.4%)
    530μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.26%)
    351μs
    1 x afterRenderRawModule mod_menu () (552B) (0.25%)
    340μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.17%)
    229μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.15%)
    201μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.14%)
    186μs
    1 x After Access::getAssetRules (id:1060 name:com_content.article.885) (7.38KB) (0.12%)
    164μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.11%)
    142μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.1%)
    137μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.09%)
    124μs
    1 x afterRenderRawModule mod_custom () (912B) (0.08%)
    112μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.08%)
    108μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.08%)
    106μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.06%)
    74μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    73μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.05%)
    70μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.05%)
    66μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.05%)
    66μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.05%)
    61μs
    1 x Before Access::getAssetRules (id:1060 name:com_content.article.885) (18.65KB) (0.04%)
    58μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.04%)
    51μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.04%)
    51μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.03%)
    40μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    40μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    11μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
55 statements were executed, 5 of which were duplicates, 50 unique30.61ms891.06KB
  • SELECT @@SESSION.sql_mode;75μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?597μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 185μ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)517μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`267μ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` = :guest450μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.36ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_k2" AND e.type = "component"289μ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"82μs1.13KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_easyblog" AND e.type = "component"75μs520B/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"95μ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"79μ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"76μ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"96μ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"78μ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"75μ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"87μs1.76KB/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"74μs520B/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"74μ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"77μ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"76μ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"72μ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"88μ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"84μ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"75μ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"73μ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"74μ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"81μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`990μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'81μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1416μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'100μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1107μs3.02KB/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)4.77ms7.44KBParams/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` = 0991μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`946μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '885'875μ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)1.01ms62.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`705μ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)580μ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`334μ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 ASC635μ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 DESC5.34ms3.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`273μ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`1.5ms19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"955μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 885 AND `component_type` = "content"131μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1152μ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)525μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 12.59ms688.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 ASC426μ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)148μ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` = 1288μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?77μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?446μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy