Skip to main content

Saratoga Hotels By the Numbers

(left) Grand Central Hotel. (right) Putnam’s Tavern and Boarding House

[From the Fall 2023 Showcase of Homes Magazine]

Written By Charlie Kuenzel  |  Photos Courtesy of the George S. Bolster Collection

The history of Saratoga Springs has so many aspects and topics in the long timeline of the city. One of my favorite topics is the discussion of the grand hotels that flourished during the 1800s in the number one tourist destination in the country, Saratoga Springs.

Saratoga Springs was initially defined as a health resort because of the vision and work of Doanda and Gideon Putnam. In 1802 they built the first hotel, known as Putnam’s Tavern and Boarding House. That hotel had a capacity to serve 70 guests within its walls and area residents were amused by the venture and laughed thinking that a hotel built in a total wilderness could be successful. But successful it was. After the first season the demand was there to visit Saratoga Springs and the Putnams added additional rooms to prepare for the next season. 

Gideon and Doanda also enhanced the area around Congress Spring for easier access, discovered the Columbian Spring and added a bathhouse. These additions and more allowed the visitor to experience the health aspects of the city and the lodging in their hotel made for a more comfortable visit to our village. The Putnams had discovered the key aspects to success in the early 1800s… good food, good lodging and the elements for a health resort experience that allowed Saratoga Springs to begin growing immediately. It took a few years to demonstrate the need for even more hotels, but the Putnam family was ready and when the need for such was demonstrated they started construction of another very large hotel called Congress Hall across the street from their original tavern and boarding house. 

In the summer of 1832 only the second rail line in the State of New York would begin to bring summer visitors to our city. The increase in transportation speed and comfort because of that train service would cause a need to build more and more hotels in the next few years and begin to define a summer visit to the Spa. Grand hotels would become the norm and truly define this great destination for more than the next one hundred years. The need for the best of everything to be served in Saratoga helped to make this little village attract some of the biggest personalities in our country during the 1800s and beyond. It was all about the hotels and the accommodation and activities they provided.

(pictured above) Congress Hall Dining Room

One interesting comparison between present day Saratoga Springs and the city in the 1800s is the number of hotel rooms. Although difficult to get a true count, we estimate that in the later years of the 1800s Saratoga Springs offered between 10,000 to 15,000 rooms counting all the hotels, boarding houses, and private room rentals. Today Saratoga County has about 4,000 rooms. Why the smaller number today? Transportation is the answer to the number of rooms today versus 150 years ago. In the nineteenth century transportation was slow and people that had made long trips to arrive in Saratoga spent weeks if not months in the city on vacation. The automobile drastically changed travel habits and the very large hotels had become too large to accommodate this more transient population. The large hotels were taken down and more efficient hotels with fewer rooms replaced them in our landscape.

Even though those large hotels of years ago don’t exist today, the numbers associated with them are very interesting to consider as we try to understand the history of this great city. First is the knowledge that for a short time in our history we had four very large hotel properties that eclipsed the many smaller properties. The Grand Union, United States, Congress Hall and the Grand Central were the big four. The last year the big four graced our skyline was 1874. A fire on October 1, 1874, destroyed Grand Central, which was never rebuilt. From 1874 on, the big three anchored the list of visitor options to our city. Many people had favorite properties since each hotel had seemed to attract a distinct demographic. Some hotels were more religious, some more political and the people they attracted seemed to be very loyal to their hotel for repeat bookings year after year. 

Those numbers tell a very interesting story, let’s look at the number of hotel rooms… The Grand Union was the largest hotel with just under 1,000 rooms, the United States Hotel at 800, Congress Hall at 600 and the Grand Central at about 500 rooms. Even the so-called smaller hotels were impressive in room numbers with the Clarendon at 250 rooms, Windsor at 150, Columbian at 125 and the Adelphi at 75. I’m reminded when I travel today that properties that seem large to me usually have 125 to 250 rooms. The size of these Saratoga hotels that don’t even exist today were huge. There were countless boarding houses and private rooms in local residences that rounded out the list of possible lodging spots, as well as many smaller hotels that have not been listed here.

The largest hotels were large in every respect. The Grand Union Hotel had 500 rocking chairs on the front porch alone and had a dining room that could serve 1,500 people in one sitting. The Grand Union Hotel occupied 7 acres of property and had 1.5 miles of interior hallways. When the hotel was remodeled in 1872 it required three acres of carpeting and one and a half acres of marble counter-tops to complete the work. The Grand Union had an Opera House that seated 1,500 people and employed Victor Herbert as its general music director. Not to be outdone the United States Hotel countered by hiring John Phillip Sousa as its music director!

All the large hotels offered the American plan which gave you a room but also provided three meals a day. To feed the masses of visitors was a huge daily job. Many locals were in the business of supplying vegetables, fish, livestock, chickens, and more on a daily basis. The railroad brought much needed supplies to the city daily from the Atlantic coast and beyond. We were entertaining the wealthiest people in the country, and they demanded the best that could be supplied at the time. The food demands were staggering. The Saratogian newspaper reported that on one day in August of 1892 guests at the United States Hotel required the following food items for their dining pleasure. The list included 400 dozen eggs, 500 pounds of butter, 700 quarts of milk, 340 chickens, 220 quarts of ice cream, 2,000 ears of corn, 10 barrels of potatoes, 4,000 tea biscuits, 30, 3.5 lbs. bluefish, 10, 30 lb. salmon, 2, 80-pound turtles for soup, and various cuts of beef, pork and lamb. That was consumed in one day, at one hotel.

The Saratoga hotels were the life blood of the city. These large hotels were very much like the cruise ships of today. Once a guest was checked in, they were supplied with their meals, entertainment and sleeping accommodation for their stay. It was a one stop destination for all that people desired daily. But Americans did eventually desire more entertainment and the residents of Saratoga Springs were very kind to provide horse racing, casino gambling, alcohol, and nightly dances that further enhanced their visit to the city. All these elements helped to propel Saratoga Springs to become the number one tourist destination in America in the 1800s.  ...And still a great destination today!

7.911MBMemory Usage126msRequest 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" => "598" "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" => 1749464186 "last" => 1749464186...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.9ms)
  • afterInitialise (1.96MB) (32.92ms)
  • afterRoute (375.98KB) (5.7ms)
  • beforeRenderComponent com_content (49.15KB) (1.11ms)
  • Before Access::preloadComponents (all components) (47.72KB) (1.89ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.54ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (19μs)
  • After Access::preloadPermissions (com_content) (514.33KB) (2.09ms)
  • Before Access::getAssetRules (id:769 name:com_content.article.598) (18.65KB) (29μs)
  • After Access::getAssetRules (id:769 name:com_content.article.598) (7.38KB) (103μs)
  • afterRenderComponent com_content (1.56MB) (44.63ms)
  • afterDispatch (29.42KB) (1.24ms)
  • beforeRenderRawModule mod_finder () (383.2KB) (11.66ms)
  • afterRenderRawModule mod_finder () (1.95MB) (6.86ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (191μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (209μs)
  • afterRenderRawModule mod_menu () (56.49KB) (1.44ms)
  • beforeRenderModule mod_menu () (696B) (6μs)
  • afterRenderModule mod_menu () (3.63KB) (131μs)
  • beforeRenderRawModule mod_custom () (920B) (100μs)
  • afterRenderRawModule mod_custom () (319.76KB) (1.16ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (60μs)
  • beforeRenderRawModule mod_menu () (24B) (76μs)
  • afterRenderRawModule mod_menu () (552B) (430μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (62μs)
  • beforeRenderRawModule mod_custom () (920B) (73μs)
  • afterRenderRawModule mod_custom () (1.03KB) (174μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (64μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (82μs)
  • afterRenderRawModule mod_menu () (4.45KB) (423μs)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (1.34KB) (72μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (807μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (92μs)
  • beforeRenderRawModule mod_custom () (288B) (10μs)
  • afterRenderRawModule mod_custom () (912B) (146μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (69μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (201μs)
  • afterRenderRawModule mod_custom () (1008B) (148μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (2.77KB) (47μs)
  • beforeRenderRawModule mod_custom () (472B) (60μs)
  • afterRenderRawModule mod_custom () (1008B) (114μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (42μs)
  • afterRender (290.95KB) (4.13ms)
  • 1 x afterRenderComponent com_content (1.56MB) (35.45%)
    44.63ms
    1 x afterInitialise (1.96MB) (26.15%)
    32.92ms
    1 x beforeRenderRawModule mod_finder () (383.2KB) (9.26%)
    11.66ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.45%)
    6.86ms
    1 x afterRoute (375.98KB) (4.52%)
    5.70ms
    1 x afterRender (290.95KB) (3.28%)
    4.13ms
    1 x afterLoad (444.73KB) (3.1%)
    3.90ms
    1 x After Access::preloadPermissions (com_content) (514.33KB) (1.66%)
    2.09ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.5%)
    1.89ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.22%)
    1.54ms
    1 x afterRenderRawModule mod_menu () (56.49KB) (1.14%)
    1.44ms
    1 x afterDispatch (29.42KB) (0.98%)
    1.24ms
    1 x afterRenderRawModule mod_custom () (319.76KB) (0.92%)
    1.16ms
    1 x beforeRenderComponent com_content (49.15KB) (0.88%)
    1.11ms
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.64%)
    807μs
    1 x afterRenderRawModule mod_menu () (552B) (0.34%)
    430μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.34%)
    423μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.21%)
    262μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.17%)
    209μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.16%)
    201μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.15%)
    191μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.14%)
    174μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.14%)
    173μs
    1 x afterRenderRawModule mod_custom () (912B) (0.12%)
    146μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.11%)
    133μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.1%)
    131μs
    1 x After Access::getAssetRules (id:769 name:com_content.article.598) (7.38KB) (0.08%)
    103μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    92μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.07%)
    82μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.06%)
    76μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    72μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    62μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    60μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    60μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    47μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    42μs
    1 x Before Access::getAssetRules (id:769 name:com_content.article.598) (18.65KB) (0.02%)
    29μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    19μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    16μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    15μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
54 statements were executed, 5 of which were duplicates, 49 unique14ms879.08KB
  • SELECT @@SESSION.sql_mode;114μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?229μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 182μ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)220μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`132μ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` = :guest249μ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"215μ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"104μ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"101μ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"64μ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"62μ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"62μ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"127μ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"70μ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"64μ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"73μ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"58μ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"61μ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"58μ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"99μ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"61μ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"60μ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"64μ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"61μ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"74μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`721μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'195μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1172μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'138μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1130μ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)562μ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` = 0591μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.11ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '598'368μ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)584μs54.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`335μ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)333μ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`286μ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 ASC387μ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.58ms3.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 `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`1ms19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"268μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 598 AND `component_type` = "content"121μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1171μ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)206μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1685μ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 ASC324μ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)237μ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` = 1147μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?95μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?220μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy