Skip to main content

 

PART ONE OF A TWO-PART SERIES

The following essay is the result of numerous discussions and debates among local historians but most of all between my business partner, Dave Patterson and myself. The exercise was designed to debate and arrive at a list of just ten people who were most pivotal in the development of this great city of Saratoga Springs. The debate had only one ground rule and that was that any person mentioned must have passed away. No living Saratogian could be considered for this list.  We wanted the nominated people to have a clear list of contributions and as you might think, the living would still be producing and therefore be harder to judge fairly. 

So here it is. Due to article space this is my first five of the top ten list. Some may disagree, but it is my list and my attempt to define our history. This is part 1 of 2 articles.

1 & 2: Gideon & Doanda Putnam

I wanted to list the Putnams as a pair and not in the usual style of only mentioning Gideon. Close examination of Doanda’s life and contributions make her a great person for this list. The Putnams came to Saratoga Springs in 1789 rather poor and rented land to start businesses.  When the Putnams first arrived, they built a very productive sawmill on the outskirts of town. Gideon was very good at supplying early residents with lumber for all the construction needs to build a village. As I frequently say, Gideon and Doanda did not have to walk through a corn field in Iowa to understand the saying, “If you build it, they will come.” They immediately knew our mineral springs were a huge asset that needed to be supported and advertised. One of the best ways to ensure success was to provide a hotel that would afford visitors a comfortable stay while “taking the waters.” In 1802 the Putnams opened the first hotel in the village called Putnam’s Tavern and Boarding House. It stood on the northwest corner of Broadway and Congress Street. Area peoples laughed at the size of the structure that could house 70 people at a time. The Putnams proved their critics wrong and at the end of the first season they put an addition on the building to accommodate more guests. The Putnams advertised the mineral springs as a cure for many medical problems and the village grew as a health resort. They cleaned up the area around the Congress Spring and discovered the Columbia Spring at the same time. The accommodations provided by the Putnam family made a visit to Saratoga a delightful experience.

The Putnam’s hotel would grow and be such a huge success that they decided to expand by building a very large second hotel across Broadway from the Tavern and named it Congress Hall. The Congress Spring was so well known in the country that it was logical to name the new hotel Congress. Unfortunately, during construction, Gideon fell from the scaffolding and died months later from those injuries.

The Putnam’s Tavern and Boarding House would last well beyond the early death of Gideon in 1812 under the watchful eye of Doanda. She ran the business and raised the family of nine children to become future village leaders. The original Tavern and Boarding House would become Union Hall and then after the family sold it the name would change to Grand Union Hotel, once the largest hotel in the world. Many historians like to say that Gideon was the “Founding Father” of the village, I prefer to say Gideon and Doanda were the “Founding Family” of the village.

3: John Clarke

Mr. Clark was the first person to bottle the waters of Saratoga Springs. In June of 1811, Gideon posted a list of “rules” concerning the springs. Most were very common-sense based, but one was revolutionary for the village. The rule read, “The water at the springs would always be free” which made for a curious business model for the owners of the mineral springs. Since the water was free at the spring, the only options for revenue would be from the offering of mineral baths and the bottling of the waters for sale beyond the village.

John Clarke began to bottle the famous waters in 1823 with business partner Thomas Lynch. Clarke designed the first bottles and determined the quart and pint sizes for sale while opting for colored glass of browns and green. Interestingly enough, the colored glass was slightly less in cost than clear and provided for a higher profit margin and strengthened the belief that the medicinal properties of the water needed to be protected from degradation by sunlight. Clarke’s bottling would continue to grow until in 1880 the village was selling about 8 million bottles of our famed mineral water to most American cities and as far away as China. The raised letter glass bottles displayed the name of the spring as well as the location “Saratoga Springs N.Y.” These bottles become the calling cards for the city. They were sold everywhere and reminded people of our fame as the source for the desired waters. I might therefore consider him our first President of the Chamber of Commerce.

Clarke also paid for the first water tower in the city as well as starting a depository for donated furniture and household items to help residents suffering from house fires. Clarke also decided to lay out a Circular Street, that was very different in the country. At this time in history most cities were laid out with streets following a “grid” pattern. A curved or circular street was the first of its kind in the country. He began construction but was halted in the shape by land owners west of Broadway who refused to sell land to complete the development of that shape street.

Another major impact on the village was that Clarke proposed a 46-cent reduction in people’s highway tax for every tree they planted. This was quickly embraced by residents and the village developed a beautiful tree lined streetscape. John Clarke impacted so much in the early village he must have spot on this list. 

4: John Morrissey

John Morrissey helped to make Saratoga Springs a “fun” place for visitors. Morrissey came to the village in 1861 and opened a small gaming house on Woodlawn Avenue. It didn’t take long for him to realize that the wealthy visitors were not always here for their health. In August of 1863 he along with John Hunter, Leonard Jerome and William Travers would open the Saratoga Racetrack. The experiment was short lived that year but was a huge success. That success would have them buy acreage across the street from the original track and lay out the present-day Saratoga Race Course.

Morrissey would continue his hand with new ventures when he built and opened a premier gaming house that debuted as the Saratoga Clubhouse to be known today as the Canfield Casino in Congress Park. 

5: Madame Jumel

Born in Providence Rhode Island in 1774 as Elizabeth Bowen, she was the daughter of a prostitute and a sailor. A hard and unstable early life lead her to move to New York City at age 18. Seeking stability and acceptance she began a relationship with a Captain Brown who made numerous trips to France. Since France was thought to be the epicenter of culture in the world at the time, she worked to learn many French phrases and know the ways of cultured people. When Captain Brown died accidently at sea, Eliza began to search for a husband of means. She eventually met and married Stephen Jumel, a wine merchant with holdings in France and the USA. 

After her marriage, the Jumels sought social acceptance in NYC. After hosting a large party for the society of the city, she was still snubbed by them. Stephen died accidently in 1832 from a fall from a carriage and Ms. Jumel took control of the business and became very successful. She again searched for a husband that would provide stability and social elevation. She marries the former Vice-President Aaron Burr in 1835. Aaron Burr sought her money and Eliza sought his social status. The marriage didn’t last long as Burr spent her money and social connections were limited. She manages to divorce Burr on his death bed using a very talented lawyer who was a son of Alexander Hamilton. After Burr killed Hamilton in a duel, Hamilton’s son needed little motivation to win this case.

Madame Jumel was a tremendous business woman and was regularly at the center of social gatherings in the hotels of Saratoga. She fostered the daily ritual of carriage rides to Saratoga Lake and upon her death in 1865 she was the largest land-owning woman in the village. She served as a model for other woman and added tremendously to the society of the early village. 

This is the first five members of my Top Ten People in Saratoga History. I hope you enjoyed it! 


  

Congress Hall Porch

This is a marvelous image that reminds us of the number of summer visitors to Saratoga Springs in the 1800s. Congress Hall was one of the “Big Four” hotels in the city and was on the east side of Broadway stretching from Spring Street south to the entrance to Congress Park.   

 

 

Bandstand in Congress Park

Congress Park was a magnet for summer visitors. Bands began playing at 7 a.m. in the bandstand to entertain visitors that were in the park to visit the famed Congress Spring every morning for their daily dose of mineral water.  

 

 

Pine Grove

Pine Grove was the home for the famous Walworth family. Judge Reuben Hyde Walworth bought the building in the 1820s and the family lived there for generations until it was razed in the 1950s. This was the home of Ellen Hardin Walworth, one of the four founders of the Daughters of the American Revolution.

 

7.94MBMemory Usage94msRequest 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" => "267" "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" => 1748222185 "last" => 1748222185...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (2.58ms)
  • afterInitialise (1.96MB) (26.36ms)
  • afterRoute (375.95KB) (4.61ms)
  • beforeRenderComponent com_content (49.04KB) (653μs)
  • Before Access::preloadComponents (all components) (47.72KB) (2.43ms)
  • After Access::preloadComponents (all components) (116.7KB) (906μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (13μs)
  • After Access::preloadPermissions (com_content) (514.33KB) (1.09ms)
  • Before Access::getAssetRules (id:422 name:com_content.article.267) (18.65KB) (24μs)
  • After Access::getAssetRules (id:422 name:com_content.article.267) (7.38KB) (79μs)
  • afterRenderComponent com_content (1.58MB) (32ms)
  • afterDispatch (29.42KB) (1.02ms)
  • beforeRenderRawModule mod_finder () (373.66KB) (8.39ms)
  • afterRenderRawModule mod_finder () (1.95MB) (5.25ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (154μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (129μs)
  • afterRenderRawModule mod_menu () (12.58KB) (863μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (107μs)
  • beforeRenderRawModule mod_custom () (920B) (71μs)
  • afterRenderRawModule mod_custom () (320.07KB) (1.2ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (54μs)
  • beforeRenderRawModule mod_menu () (24B) (75μs)
  • afterRenderRawModule mod_menu () (552B) (383μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (59μs)
  • beforeRenderRawModule mod_custom () (920B) (55μs)
  • afterRenderRawModule mod_custom () (1.03KB) (137μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (57μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (78μs)
  • afterRenderRawModule mod_menu () (4.45KB) (397μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (67μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (7.28KB) (544μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (69μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (126μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (167μs)
  • afterRenderRawModule mod_custom () (1008B) (133μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (472B) (56μs)
  • afterRenderRawModule mod_custom () (1008B) (108μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (40μs)
  • afterRender (298.95KB) (2.88ms)
  • 1 x afterRenderComponent com_content (1.58MB) (34.04%)
    32.00ms
    1 x afterInitialise (1.96MB) (28.05%)
    26.36ms
    1 x beforeRenderRawModule mod_finder () (373.66KB) (8.93%)
    8.39ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.59%)
    5.25ms
    1 x afterRoute (375.95KB) (4.91%)
    4.61ms
    1 x afterRender (298.95KB) (3.06%)
    2.88ms
    1 x afterLoad (444.73KB) (2.74%)
    2.58ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (2.59%)
    2.43ms
    1 x afterRenderRawModule mod_custom () (320.07KB) (1.28%)
    1.20ms
    1 x After Access::preloadPermissions (com_content) (514.33KB) (1.16%)
    1.09ms
    1 x afterDispatch (29.42KB) (1.09%)
    1.02ms
    1 x After Access::preloadComponents (all components) (116.7KB) (0.96%)
    906μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.92%)
    863μs
    1 x beforeRenderComponent com_content (49.04KB) (0.69%)
    653μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.58%)
    544μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.42%)
    397μs
    1 x afterRenderRawModule mod_menu () (552B) (0.41%)
    383μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.26%)
    241μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.18%)
    167μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.16%)
    154μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.15%)
    137μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.14%)
    129μs
    1 x afterRenderRawModule mod_custom () (912B) (0.13%)
    126μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.13%)
    126μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.12%)
    110μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.11%)
    107μs
    1 x After Access::getAssetRules (id:422 name:com_content.article.267) (7.38KB) (0.08%)
    79μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.08%)
    78μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.08%)
    75μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    69μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.07%)
    67μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.06%)
    59μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.06%)
    56μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.06%)
    54μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.05%)
    45μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    40μs
    1 x Before Access::getAssetRules (id:422 name:com_content.article.267) (18.65KB) (0.03%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    13μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    13μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    7μs
53 statements were executed, 5 of which were duplicates, 48 unique12.77ms876.02KB
  • SELECT @@SESSION.sql_mode;140μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?321μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1150μ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)281μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`104μ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` = :guest167μ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"281μ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"92μ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"68μ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"65μ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"67μ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"77μ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"115μs536B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jticketing" AND e.type = "component"74μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_icagenda" AND e.type = "component"67μ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"64μ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"62μ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"62μ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"64μ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"64μ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"63μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_djclassifieds" AND e.type = "component"66μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"62μ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"65μ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"64μ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"65μ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"76μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`616μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'207μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1142μ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 1214μ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)476μ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` = 0531μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`587μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '267'337μ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)508μs70.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`341μ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)528μ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`397μ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 ASC444μ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.62ms3.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`336μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"299μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 267 AND `component_type` = "content"117μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1239μ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)143μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1568μ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 ASC399μ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)153μ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` = 1191μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?96μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?324μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy