Skip to main content

Where Every Elegant Detail Speaks Perfection

Written & Photographed (unless Noted) By Theresa St. John

[From the 2025 Summer Magazine]

Photo provided

“Elegance is not about
being noticed, it’s about being remembered.”

- Georgio Armani

Built in 1870 by Loren Putnam, a grandson of Gideon Putnam, this Second Empire brick hotel, Saratoga Arms, is a luxury 31-room hotel that seamlessly blends historic elegance and charm with modern amenities. During its 150-plus-year history, the building has carried many names. It was first called The Putnam, then The Walton, and finally The Windsor before it eventually became The Saratoga Arms in 1997.

Yet, it wasn’t always a hotel. Alice Bode, a woman from Brooklyn, inherited the structure and ran it as a boarding house from the 1950s through 1995, when she passed away at 93. At the time, rooms were rundown, with one bathroom per floor. The men who lived there paid $42 per month in rent.

Today, the Saratoga Arms is comprised of two adjoining buildings. Shortly after Alice died, Kathleen and Noel Smith purchased two structures—one at #495 Broadway and the other, #497, which was a building directly next to the first. Once they obtained a building permit in February 1998, the couple oversaw extensive, sometimes unexpected, renovations. When it reopened to the public in February 1999, it was a luxurious 16-room inn. Over the years, with more design, remodeling, and the completion of its second building by 2005, those 16 became the 31 rooms of the elegant boutique hotel we celebrate today.

There’s also a fitness center, several offices, and state-of-the-art conference facilities. They serve breakfast (it’s scrumptious!) from 7:30-10:30 a.m. Monday through Friday, and 7:30-11:30 a.m. Saturday and Sunday to guests and the public.

“Guests can be vocal when they make a reservation,” Kathleen laughs over the phone. She’s away on a buying trip at the moment (Florida is a great place to buy fabric), but took time to hop on a call with Amy and me. “Some say, ‘That’s my room,’ and book the same every time they visit. Others are determined to stay in a different space each time they reserve with us.” I have to smile myself; I never express a preference when I stay here, but somehow end up with a different suite each time. Pretty cool!

I ask the mother-daughter hoteliers if rooms are really all that different from one another. They tell me the rooms and suites change periodically, needing updates, paint, sometimes a total makeover. “The hotel certainly honors history,” Amy states. “But every suite has a vibe that says ‘we’re not your grandmother’s house.’ We’re modern, luxurious, boasting up-to-date décor trends and have plenty of hot water!” I nod in agreement – the hot water and shower pressure are fantastic!

Amy asked if I noticed the small, upholstered chairs in the hallway on the third floor. I grinned and told her I had taken a picture of them – they were charming. She explained they were called ‘Ladies Chairs’ because they were so tiny. “My mother bought them from a doctor’s estate in the mid-90s.”

Kathleen pipes in, momentarily drawing attention to a couple of her many friends. “Michaela Baruzzi of Carriage House Interiors and Pamela Whitney of Whitney Interiors are fabulous!” I can almost hear her smiling through the phone. “They help me choose just the right pieces, exquisite fabrics, and warm, cheery colors for each room throughout the hotel. We bounce ideas off each other and all have an eye for the elegance, charm, and ease we want to bring to Saratoga Arms.”

Everywhere I look, I see nods to the past: plaster and tin ceilings, gorgeous grand staircases leading up to other floors, and the fireplace in the main common area—one of fourteen originals, eleven of which have been restored. I fell in love with the call box (annunciator) behind the front desk. Amy told me it comes from the former Excelsior Springs Hotel (long gone) here in Saratoga Springs.

During the year, many packages/events are offered to entice folks to visit – and they all sound interesting! Reading Retreat, Reconnection Retreat, Deep Sleep Packages, Hatchlorette Getaways, a Saratoga Date Night Package, and a Me, Myself, and I Package are just a few. They also feature beer pairing weekends and breakfasts, VIP racing packages, and Foodie nights at the hotel. “Mommy and Me was such a big hit, some people actually flew in to attend!” Amy exclaims. It was a weekend centered around mothers, daughters, and an American Girl Doll. “Our staff is fantastic – they came up with the idea and implemented all of these wonderful details, making it a special time for our guests. We can’t wait to run that sold-out event again.” 

Theresa St John Flowers

Theresa St John Ladies Chairs

The mother-daughter-run boutique hotel was named the best hotel in Saratoga Springs in U.S. News & World Report’s 2024 Best Hotel Rankings. (2nd year in a row!) The hotel was also named the winner in Condé Nast Traveler’s 2024 Readers' Choice Award – the only hotel in the Capital District to be named a winner (for the 2nd year in a row), landing #14 in the Mid-Atlantic Hotels category. And, if those weren’t enough accolades, they also received  AAA’s 4 Diamond Designation in 2017. I’m sure there are some awards I missed, and I’m sure there are many more to come.

Theresa St John Fireplace Main Common Room

Theresa St John Pillows

I will say the crown jewel of this hotel is their beautiful wraparound Saratoga porch. It ties everything together with a bow. No matter the time of year, catching sight of it stops anyone walking by in their tracks. You can almost hear it whisper a warm welcome, extending an invitation to walk up the stairs and take a seat, drink a glass of wine or chilled craft beer, and people-watch the day go by. Because it is a common, open space for guests, complemented with wicker furniture, it’s easy to imagine speaking freely to strangers about everyday events, where they’re from, and what brought them to the Spa City.

“We’re more than an overnight stay, a comfortable place to rest your head,” Amy tells me as I prepare to leave. “We work extremely hard to stand out, to offer an elevated experience and concierge-level service that starts before our guests arrive, and lasts long after they’ve left. We want to be remembered.”  Oh, believe me, Saratoga Arms, you are. You most definitely are.

8.3MBMemory Usage115msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.23
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.4.5
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "11" "id" => "866" "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" => 1752987333 "last" => 1752987333...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (522μs)
  • afterInitialise (1.96MB) (13.49ms)
  • afterRoute (375.98KB) (3.23ms)
  • beforeRenderComponent com_content (49KB) (677μs)
  • Before Access::preloadComponents (all components) (47.63KB) (872μs)
  • After Access::preloadComponents (all components) (116.7KB) (2.23ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (19μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (2.11ms)
  • Before Access::getAssetRules (id:1041 name:com_content.article.866) (18.65KB) (27μs)
  • After Access::getAssetRules (id:1041 name:com_content.article.866) (7.38KB) (99μs)
  • afterRenderComponent com_content (1.93MB) (59.08ms)
  • afterDispatch (29.42KB) (1.02ms)
  • beforeRenderRawModule mod_finder () (369.16KB) (12.91ms)
  • afterRenderRawModule mod_finder () (1.95MB) (9.5ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (153μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (245μs)
  • afterRenderRawModule mod_menu () (12.64KB) (679μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.69KB) (97μs)
  • beforeRenderRawModule mod_custom () (920B) (59μs)
  • afterRenderRawModule mod_custom () (320.1KB) (1.06ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (3.15KB) (56μs)
  • beforeRenderRawModule mod_menu () (24B) (67μs)
  • afterRenderRawModule mod_menu () (552B) (326μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (54μs)
  • beforeRenderRawModule mod_custom () (920B) (50μs)
  • afterRenderRawModule mod_custom () (1.03KB) (117μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (67μs)
  • afterRenderRawModule mod_menu () (4.45KB) (357μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (69μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (504μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (71μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (113μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (71μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (140μs)
  • afterRenderRawModule mod_custom () (1008B) (123μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (63μs)
  • beforeRenderRawModule mod_custom () (472B) (70μs)
  • afterRenderRawModule mod_custom () (1008B) (123μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (43μs)
  • afterRender (314.95KB) (3.8ms)
  • 1 x afterRenderComponent com_content (1.93MB) (51.5%)
    59.08ms
    1 x afterInitialise (1.96MB) (11.76%)
    13.49ms
    1 x beforeRenderRawModule mod_finder () (369.16KB) (11.25%)
    12.91ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (8.28%)
    9.50ms
    1 x afterRender (314.95KB) (3.31%)
    3.80ms
    1 x afterRoute (375.98KB) (2.82%)
    3.23ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.94%)
    2.23ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.84%)
    2.11ms
    1 x afterRenderRawModule mod_custom () (320.1KB) (0.92%)
    1.06ms
    1 x afterDispatch (29.42KB) (0.89%)
    1.02ms
    1 x Before Access::preloadComponents (all components) (47.63KB) (0.76%)
    872μs
    1 x afterRenderRawModule mod_menu () (12.64KB) (0.59%)
    679μs
    1 x beforeRenderComponent com_content (49KB) (0.59%)
    677μs
    1 x afterLoad (444.73KB) (0.45%)
    522μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.44%)
    504μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.31%)
    357μs
    1 x afterRenderRawModule mod_menu () (552B) (0.28%)
    326μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.21%)
    246μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.21%)
    245μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.13%)
    153μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.12%)
    140μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.11%)
    127μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.1%)
    117μs
    1 x afterRenderRawModule mod_custom () (912B) (0.1%)
    113μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.09%)
    109μs
    1 x After Access::getAssetRules (id:1041 name:com_content.article.866) (7.38KB) (0.09%)
    99μs
    1 x afterRenderModule mod_menu () (3.69KB) (0.08%)
    97μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.06%)
    71μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.06%)
    70μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    69μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.06%)
    67μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.06%)
    67μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.05%)
    63μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    56μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    54μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    43μs
    1 x Before Access::getAssetRules (id:1041 name:com_content.article.866) (18.65KB) (0.02%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    19μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    16μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
53 statements were executed, 5 of which were duplicates, 48 unique25.53ms906.27KB
  • SELECT @@SESSION.sql_mode;56μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?230μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 153μ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)264μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`85μ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` = :guest137μ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"93μ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"64μ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"74μ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"66μ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"58μ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"56μ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"63μ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"55μ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"53μ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"52μ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"52μ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"52μ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"61μ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"53μ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"77μ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"63μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"55μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_phocacart" AND e.type = "component"55μ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"53μ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"55μ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"52μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`403μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'102μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1127μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'98μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1122μ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)1.46ms9.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` = 01.31ms49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.23ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '866'874μ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)967μ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`592μ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)645μ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`283μ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 ASC614μ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 DESC10.58ms41.72KBParams/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`326μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 123 AND `component_type` = "menu"1.26ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 866 AND `component_type` = "content"159μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1359μ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)547μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1340μ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 ASC295μ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)121μ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` = 1354μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?86μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?177μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy