Skip to main content

Every city has a story, and every story has a beginning. The story of Saratoga Springs starts long before it was known as the “The Place to See and be Seen.”  Centuries before the thousands of summer guests visited the grand hotels and drank the famous mineral waters the Native Americans of this area, the Mohawk, used the springs, planted crops, and hunted the fields and forests of the area.

The Mohawk had named this area “Sarach-to-gue” which to them meant the area of the great salt springs or the hillside of the great river.  A city would not be found in this area for centuries until permanent European settlers came to the area in the later years of the 1700s. On November 2, 1708 Queen Anne, of England, granted 13 people land with the royal act called the Kayaderosseras Patent. According to the Mohawk, the name Kayaderosseras, meant “the country of the lake of the crooked stream,” and of course that crooked stream is what we now call, the Kayaderosseras Creek; that flows into Saratoga Lake. This patent was for a huge tract of about 400,000 acres of land that was located west of the Hudson River and north of the Mohawk River. The tract was not awarded until years later when it was somewhat reduced in size and finally surveyed in 1769-70 and broken into 25 allotments with 23 allotments that are each divided into 13 equal lots.
Two of the 25 allotments plus a five-mile square of land (5,029 acres) was given as payment to the surveyors and others that helped with the surveying and conveyance of the land. On October 22,1771 at the Brock Tavern in New York City, the grantees drew lots to determine ownership of the 13 lots in each of the 23 allotments. The most important allotment to Saratoga Springs’ history was lot #12 of the 16 allotments that would become most of the land making up the city today. Lot #12 was drawn in the name of Rip Van Dam and was 2,800 acres in size. When all 23 allotments were divided, Rip Van Dam had received about 30,000 acres which is the equivalent of 46.875 square miles of property. Since Rip Van Dam had died in 1749 the land went to his heirs.

The original thirteen patentees were Johannes Beekman, Rip Van Dam, Anne Bridges, Nanning Hermance, John Tudor, Johannes Fisher, Joris Hooglandt, John Stephens, John Tatham, Adrian Hooghlandt, Peter Fauconnier, May Bickley and Sampson Broughton. When the land was being surveyed it was a piece of the then very large Albany County. Saratoga County was not formed until February 7, 1791.

The area of the present-day city of Saratoga Springs was very sacred to the Mohawk mostly because of the healing waters that flowed from the springs. The Mohawk kept the waters of the High Rock secret and protected it from visitation by area settlers. The High Rock spring was referred to by the Mohawk as “The Medicine Spring of the Great Spirit.”  The story is that it was not until 1771 that the Mohawk allowed the first European to visit the area to take the waters. In that year an ill Sir William Johnson, who served as Agent for Indian Affairs for the British, was carried by the Mohawk on a litter to visit what many believe was the High Rock Spring. In Sir William’s account of the event, he refers to visiting a spring “northward of Schenectady.” Since the Mohawk respected Johnson as a friend and they knew he had been suffering from a lingering illness that they felt could be remedied with the use of the waters at a spring, they probably brought him to the High Rock. During his stay of four days at the spring, he drank and bathed with the waters and at the end of those days he felt stronger and walked most of the way back to his house in the Mohawk Valley. Soon after his arrival home he wrote to friends to tell the amazing story of the curing powers of the High Rock.

New knowledge of the mineral springs began a strong push by interested settlers to be able to buy land in the area and build near the springs. After deals with the Mohawk were arranged, the first area of the city to be settled was around the High Rock Spring which became known as the Upper Village. The city’s first permanent settler to the Upper Village was Alexander Bryan in1787. Eventually settlers would also build in the area around the Congress Spring that was discovered in 1792 and that became known as the Lower Village. Over time the two villages would grow to be one with the name Saratoga Springs.

When Gideon Putnam and his wife Doanda came to Saratoga Springs in 1789, the path of the city changed forever. They immediately began to see the wealth potential from harvesting the timber of the area and understood the concept of the saying “If you build it they will come.” Gideon built a sawmill and began to turn the native white pines into shingles, shakes and barrel staves. Gideon later recognized that the mineral springs were a draw for tourists to come to the city for their health. At first, Gideon and Doanda leased land and as their wealth increased, they bought 300 acres of land to start the Lower Village near the Congress Spring. He would build the first hotel in 1802, called Putnam’s Tavern and Boarding House, located on the northwest corner of Broadway and Congress Street. Area residents laughed at his initiative since the land around the boarding house was really in an unsettled thick pine forest with no other settlers in the immediate area.

As the Putnams’ success continued they continued to buy land, built a bath house, tubed the springs and donated land for a church, school and burial ground. Gideon and his wife Doanda laid out the early streets of the city including Broad Street at a width of 120 feet, to be later called Broadway. Washington Street and Phila Street were named after Putnam children. The Putnams’ vision changed the city forever.

One year after Putnam’s Tavern and Boarding House was opened, Gideon added an addition to the hotel because of its successful first year of operation. Eventually the expanding Tavern and Boarding House became known as Union Hall. The Putnam family owned the hotel until 1865 when it changed its name upon change of ownership to the Grand Union. By the 1870s the Grand Union would be one of the largest hotels in the world. In 1811 Gideon starts construction of another hotel across the street from the Union Hall and called it the Congress Hall. Unfortunately, Gideon fell from the scaffolding during construction and died in December of 1812. Doanda lived until 1835 and was a tremendous force in not only keeping the family together but in the daily business operations of two major hotels and assorted properties. A New York City social writer commented in his column after a visit to the Union Hotel, “I can’t understand if the name of Union Hotel describes the national union of the states or the quality of the Putnam family.”                           

Before Gideon died, he posted a list of the “rules of the springs.” It was Gideon who set forth the idea that the water would always be free at the spring. This custom set the stage for the social patterns for summer visitors for the rest of the 19th century and made Saratoga Springs a very different social experience from other summer destinations. People lining up without preferential treatment at the springs to “take the waters” each morning helped to define the social interactions of the summer. The vision of Gideon and Doanda Putnam helped to define the early years of the city as a health resort.  Saratoga Springs was now poised to grow from a wild pine forest to a unique city that would become the number one tourist destination in the United States in the 1800s.

Congress Spring

This is an image of the famed Congress Spring, the way it looked in 1877. In the 1800s our mineral springs were privately owned, and their architecture and appearance was at the discretion of the owner. This ornate version was designed for the country’s Centennial Year of 1876. 

The Adelphi Hotel

The Adelphi Hotel was built in the later part of the 1800s. Although it was not one of the four largest hotels in the city, it has survived the years and was renovated a few years ago, becoming a beautiful destination in the city.

Pavilion Hotel

One of the very early hotels in Saratoga Springs, the Pavilion was located on the northeast corner of Broadway and Lake Avenue. The hotel was razed years ago and is the site of the present-day City Hall.

7.882MBMemory Usage107msRequest 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" => "475" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746975109 "last" => 1746975109...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (2.18ms)
  • afterInitialise (1.96MB) (28.18ms)
  • afterRoute (374.59KB) (5.15ms)
  • beforeRenderComponent com_content (48.95KB) (857μs)
  • Before Access::preloadComponents (all components) (43.72KB) (1.65ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.26ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (17μs)
  • After Access::preloadPermissions (com_content) (507.06KB) (1.19ms)
  • Before Access::getAssetRules (id:640 name:com_content.article.475) (18.65KB) (28μs)
  • After Access::getAssetRules (id:640 name:com_content.article.475) (11.38KB) (107μs)
  • afterRenderComponent com_content (1.57MB) (39.56ms)
  • afterDispatch (29.42KB) (1.16ms)
  • beforeRenderRawModule mod_menu () (396.96KB) (10.16ms)
  • afterRenderRawModule mod_menu () (13.13KB) (1.04ms)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.73KB) (184μs)
  • beforeRenderRawModule mod_finder () (1.45KB) (13μs)
  • afterRenderRawModule mod_finder () (1.95MB) (5.85ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (2.82KB) (103μs)
  • beforeRenderRawModule mod_custom () (16B) (246μs)
  • afterRenderRawModule mod_custom () (320.11KB) (1.42ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.27KB) (57μs)
  • beforeRenderRawModule mod_menu () (24B) (80μs)
  • afterRenderRawModule mod_menu () (552B) (443μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (59μs)
  • beforeRenderRawModule mod_custom () (920B) (56μs)
  • afterRenderRawModule mod_custom () (1.03KB) (165μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (65μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (86μs)
  • afterRenderRawModule mod_menu () (4.45KB) (404μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (68μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (7.32KB) (615μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (72μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (130μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_custom () (3.91KB) (160μs)
  • afterRenderRawModule mod_custom () (1008B) (120μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.77KB) (44μs)
  • beforeRenderRawModule mod_custom () (8B) (74μs)
  • afterRenderRawModule mod_custom () (1008B) (126μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (54μs)
  • afterRender (298.95KB) (3.38ms)
  • 1 x afterRenderComponent com_content (1.57MB) (36.89%)
    39.56ms
    1 x afterInitialise (1.96MB) (26.28%)
    28.18ms
    1 x beforeRenderRawModule mod_menu () (396.96KB) (9.47%)
    10.16ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.45%)
    5.85ms
    1 x afterRoute (374.59KB) (4.8%)
    5.15ms
    1 x afterRender (298.95KB) (3.15%)
    3.38ms
    1 x afterLoad (444.73KB) (2.03%)
    2.18ms
    1 x Before Access::preloadComponents (all components) (43.72KB) (1.54%)
    1.65ms
    1 x afterRenderRawModule mod_custom () (320.11KB) (1.32%)
    1.42ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.17%)
    1.26ms
    1 x After Access::preloadPermissions (com_content) (507.06KB) (1.11%)
    1.19ms
    1 x afterDispatch (29.42KB) (1.08%)
    1.16ms
    1 x afterRenderRawModule mod_menu () (13.13KB) (0.97%)
    1.04ms
    1 x beforeRenderComponent com_content (48.95KB) (0.8%)
    857μs
    1 x afterRenderRawModule mod_finder () (7.32KB) (0.57%)
    615μs
    1 x afterRenderRawModule mod_menu () (552B) (0.41%)
    443μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.38%)
    404μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.23%)
    246μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.23%)
    246μs
    1 x afterRenderModule mod_menu () (3.73KB) (0.17%)
    184μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.15%)
    165μs
    1 x beforeRenderRawModule mod_custom () (3.91KB) (0.15%)
    160μs
    1 x afterRenderRawModule mod_custom () (912B) (0.12%)
    130μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.11%)
    118μs
    1 x After Access::getAssetRules (id:640 name:com_content.article.475) (11.38KB) (0.1%)
    107μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.1%)
    103μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.08%)
    86μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    80μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.07%)
    74μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    72μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    68μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.06%)
    59μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.05%)
    57μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.05%)
    56μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.05%)
    54μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    44μs
    1 x Before Access::getAssetRules (id:640 name:com_content.article.475) (18.65KB) (0.03%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    17μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    14μs
    1 x beforeRenderRawModule mod_finder () (1.45KB) (0.01%)
    13μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    8μ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.99ms868.02KB
  • SELECT @@SESSION.sql_mode;161μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?293μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 196μ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)278μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`115μ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` = :guest219μ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"213μ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"112μ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"102μ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"94μ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"95μ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"121μ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"131μ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"99μ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"90μ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"96μ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"103μ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"94μ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"88μ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"97μ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"94μ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"102μ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"96μ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"94μ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"88μ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"95μ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"99μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`559μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'100μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1229μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'155μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1218μ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)523μ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` = 0548μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`722μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '475'398μ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)487μs62.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`311μ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)187μ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`257μ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 ASC366μ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.53ms3.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`357μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 119 AND `component_type` = "menu"241μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 475 AND `component_type` = "content"166μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1210μ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)159μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1515μ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 ASC391μ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)170μ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` = 1172μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?281μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?370μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy