Skip to main content

Written & Photographed By Theresa St. John

[From the 2025 Home & Garden Magazine]

A Summer’s Day Visit to Lincoln’s Ancestral Home

 

I love that Vermont is only an hour or so from downtown Saratoga. It makes it easy to spend a leisurely day exploring an area filled with all the classic New England charm one could hope for: boutiques, churches, graveyards, museums, restaurants, country stores, and the place I love the most… Hildene.

I arrived before the museum and gardens opened, so I relaxed over a light breakfast at The Little Rooster Café, right down the street. After a bowl of fresh seasonal fruit and a piping hot cup of coffee, I ventured back and spent time photographing headstones and monuments while walking along the sunny paths of Manchester’s historic rural Dellwood Cemetery, established in 1865.

I grew up in New England and adore historic places, but I just recently learned that Robert Todd Lincoln, eldest son of President Abraham Lincoln and Mary Todd Lincoln, owned a beautiful home in the hills of Vermont.

How on earth can I be in my 60s before discovering that, in the summer of 1864, First Lady Mary Lincoln traveled with her sons Robert and Tad to Manchester, Vermont, from

Washington, D.C., to enjoy a stay at The Equinox Hotel—where I’ve enjoyed an overnight stay myself? Robert, the only one of four children to make it to adulthood, must have loved the beauty of this Green Mountain State, as he bought several hundred acres (412 remain intact today) and built the estate some 40 years later! 

Looking at the grand architecture of this sprawling Georgian revival mansion, it is hard to believe this was a ‘summer home’ for the Lincoln family. I think the name is beautiful. Hildene is formed from two English words – Hil (meaning hill) and dene (meaning ‘valley with stream’). Robert and his wife Mary gave their Vermont home this name as it sat proudly on a hill that overlooked the Taconic Mountains to the west, the Green Mountains to the east, and the Battenkill River, which flowed through the Battenkill Valley below them.   

In 1975, the next-to-last Lincoln descendent who had lived there passed away. The mansion wasn’t in good shape, but thankfully, a local non-profit, “Friends of Hildene,” was passionate about raising money to purchase and restore the property to its former glory. 

The Hildene Staff greet visitors inside the Oscar V. Johnson Welcome Center, which was once the carriage house. There are still many signs of yesteryear there, including horse stalls and feed bins. The floors in some sections are original. The gift shop has unique nature-centric items displayed on the walls and tables. They sell a variety of items, including food, cheese made from their cows and goats, Vermont-made products, children's items, gorgeous greeting cards, and ornaments, among other things.  I was thrilled—and curious—to see several cute designs of felt soap holders. Put your favorite bar inside, and I think the felt acts as a natural exfoliant. Honestly, they were so adorable I’d use them for show! I bought my ticket to tour the mansion and gardens and then moved outside. However, on my next visit, I need to spend more time (and money) in the shop. I'm already thinking Christmas! 

Inside the mansion, well, it takes your breath away. All the rooms are impeccable – you can tell where the family’s living quarters end and the help’s living and working areas begin. I was told that 90% of everything inside is original – not reproduced, not something period-like, such as what they might have had there. Several small side tables showcased members of the Lincoln family – they were a handsome bunch. There’s a stunning grandfather clock in the entryway, one of only three known stovepipe hats belonging to President Abraham Lincoln, one of his bibles, the 1908 Aeolian pipe organ Robert gave to his wife, and all the original music rolls still in their boxes. (And it’s still working!)

A formal garden lies out behind the mansion – designed by Robert’s daughter, Jessie Lincoln, and gifted to her mother one birthday. It was interesting to note that one could view the beauty from numerous windows on that side of the home. Many plantings from the 1908 garden still thrive there. In June, more than 1,000 fragrant peony blossoms draw visitors from near and far to enjoy their large, ruffled petals, stunning array of vibrant colors, heady fragrances, and symbolic meanings of love, honor, and wealth. There is evidence, as indicated by letters dated 1905, that the peonies planted here are over one hundred years old, making them centennial cultivars. Excellent, if you ask me!

Robert was an astronomy enthusiast – and his observatory is situated at the top of a small hill overlooking the Green Mountains, which are gorgeous in the fall season when bursts of brilliant color adorn the tree branches.

Another fascinating aspect of the estate is the Sunbeam Pullman Car, situated off to the side and down an embankment that leads to the train tracks. It dates back to 1888 and was restored before being brought to Hildene in 2011. Robert Lincoln was Secretary of War under Rutherford B. Hayes and later became president of the Pullman Company. They manufactured railroad cars. This one is a beauty! I walked through it and was amazed at the details – from the lighting to the beds that pulled down from overhead to the dining areas and then the kitchen, where the porters would cook for their elite guests during the journey. There could be up to eighteen people at a time, and the porters were responsible for ensuring they had everything they needed.  I was shocked to learn how many people traveled on rail cars like the Sunbeam – more than 100,000 folks, and all were waited on (hand and foot!) by overworked and highly underpaid African American ‘Pullman Porters.’ I picked up a book covering this subject when I returned to the gift shop and am anxious to read it. I thought about President Lincoln’s convictions and actions concerning slavery compared to his son’s attitude – they were so opposite each other that it was disturbing!

The newest addition to the massive Hildene property is Lincoln Hall, which opened in 2024. It is stunning. The building can accommodate up to 220 people, and this gracious setting frames Mount Equinox in its floor-to-ceiling windows, offering breathtaking views. I can only imagine the stunning sunsets you might witness there. It’s a perfect place to host a wedding, holiday party, shower, or corporate event.

Hildene is open from Thursday to Monday, 10:00 a.m. to 4:30 p.m. Each year, tens of thousands of visitors are welcomed by friendly, knowledgeable staff for self-guided tours, scheduled guided tours of the house, Behind the Scenes Archive Tours, motorcoach tours, and school group tours. On their website, they suggest planning three to six hours exploring the property, farm, and trails. I agree. There’s so much to see, do, and learn about here that you’ll want to visit more than once. Promise.         

8.13MBMemory Usage95.39msRequest 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" => "11" "id" => "844" "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" => 1749585860 "last" => 1749585860...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (1.14ms)
  • afterInitialise (1.96MB) (22.89ms)
  • afterRoute (375.98KB) (4.24ms)
  • beforeRenderComponent com_content (49.15KB) (795μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.22ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.02ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (17μs)
  • After Access::preloadPermissions (com_content) (516.75KB) (1.82ms)
  • Before Access::getAssetRules (id:1019 name:com_content.article.844) (18.65KB) (27μs)
  • After Access::getAssetRules (id:1019 name:com_content.article.844) (7.38KB) (71μs)
  • afterRenderComponent com_content (1.76MB) (39.03ms)
  • afterDispatch (21.42KB) (2.03ms)
  • beforeRenderRawModule mod_finder () (383.3KB) (7.72ms)
  • afterRenderRawModule mod_finder () (1.95MB) (5.49ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (135μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (181μs)
  • afterRenderRawModule mod_menu () (12.64KB) (682μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.69KB) (93μs)
  • beforeRenderRawModule mod_custom () (920B) (62μs)
  • afterRenderRawModule mod_custom () (320.1KB) (1000μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (54μs)
  • beforeRenderRawModule mod_menu () (24B) (72μs)
  • afterRenderRawModule mod_menu () (552B) (370μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (58μs)
  • beforeRenderRawModule mod_custom () (920B) (55μs)
  • afterRenderRawModule mod_custom () (1.03KB) (166μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (73μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (79μs)
  • afterRenderRawModule mod_menu () (4.45KB) (410μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (69μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (7.28KB) (489μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (72μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (128μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (52μs)
  • beforeRenderRawModule mod_custom () (4.23KB) (145μs)
  • afterRenderRawModule mod_custom () (1008B) (122μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (472B) (93μs)
  • afterRenderRawModule mod_custom () (1008B) (159μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (44μs)
  • afterRender (306.95KB) (2.62ms)
  • 1 x afterRenderComponent com_content (1.76MB) (40.92%)
    39.03ms
    1 x afterInitialise (1.96MB) (23.99%)
    22.89ms
    1 x beforeRenderRawModule mod_finder () (383.3KB) (8.09%)
    7.72ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.76%)
    5.49ms
    1 x afterRoute (375.98KB) (4.45%)
    4.24ms
    1 x afterRender (306.95KB) (2.74%)
    2.62ms
    1 x afterDispatch (21.42KB) (2.13%)
    2.03ms
    1 x After Access::preloadPermissions (com_content) (516.75KB) (1.91%)
    1.82ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.28%)
    1.22ms
    1 x afterLoad (444.73KB) (1.2%)
    1.14ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.07%)
    1.02ms
    1 x afterRenderRawModule mod_custom () (320.1KB) (1.05%)
    1000μs
    1 x beforeRenderComponent com_content (49.15KB) (0.83%)
    795μs
    1 x afterRenderRawModule mod_menu () (12.64KB) (0.72%)
    682μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.51%)
    489μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.43%)
    410μs
    1 x afterRenderRawModule mod_menu () (552B) (0.39%)
    370μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.29%)
    281μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.19%)
    181μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.17%)
    166μs
    1 x beforeRenderRawModule mod_custom () (4.23KB) (0.15%)
    145μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.14%)
    135μs
    1 x afterRenderRawModule mod_custom () (912B) (0.13%)
    128μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.13%)
    125μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.12%)
    117μs
    1 x afterRenderModule mod_menu () (3.69KB) (0.1%)
    93μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.1%)
    93μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.08%)
    79μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.08%)
    72μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.08%)
    72μs
    1 x After Access::getAssetRules (id:1019 name:com_content.article.844) (7.38KB) (0.07%)
    71μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.07%)
    69μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.06%)
    58μ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.05%)
    44μs
    1 x Before Access::getAssetRules (id:1019 name:com_content.article.844) (18.65KB) (0.03%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    17μs
    5 x beforeRenderModule mod_custom () (704B) (0.02%)
    16μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    10μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    7μs
53 statements were executed, 5 of which were duplicates, 48 unique12.32ms898.27KB
  • SELECT @@SESSION.sql_mode;51μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?118μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 172μ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`96μ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` = :guest198μ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"146μ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"115μ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"117μ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"109μ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"104μ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"112μ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"112μ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"122μ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"109μ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"102μ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"101μ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"102μ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"113μ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"103μ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"107μ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"106μ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"132μ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"109μ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"112μ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"124μ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"129μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`628μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'99μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1366μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'167μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1136μ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)558μ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` = 0928μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`551μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '844'228μ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)407μ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`301μ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)202μ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`315μ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 ASC296μ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.95ms41.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`301μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 123 AND `component_type` = "menu"160μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 844 AND `component_type` = "content"106μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1170μ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)142μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1360μ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 ASC316μ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)125μ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` = 193μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?70μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?207μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy