Skip to main content

WRITTEN BY BILL ORZELL 

Saratoga Springs, with its unique location, flowing waters, and the summer horse racing spectacle, attracted many who created homes and gardens to be admired. One unique public house offered a beer garden, on the east side of Broadway, directly opposite the intersection of Division Street.

This site was also directly across the Broadway thoroughfare from the legendary United States Hotel and Worden House, and known as the Hotel Todd. This establishment would be easily spotted by those seeking the spirit of Gambrinus to slake their thirst, after arriving in the Spa City at the nearby D&H train station.

The 398 Broadway location had previously been operated as the Hotel Voullieme until the famous brewer David G. Yuengling, Jr. gained possession. He formed a consortium in 1887 with the Honorable Hiram Todd, a former Saratoga Springs attorney, and his son V.L. Todd to operate a public house which included both a cigar store and a liquor outlet. The opening was announced in the Saratogian, which wrote,

“V.L. Todd, the new occupant of the Yuengling building, on Broadway, will serve clam chowder at his cigar and refreshment headquarters this evening.”

Many later historians conjectured this operation, as well as Caleb Mitchell’s establishment next door, also conducted back-room games of chance. Illicit, yet much sought after entertainment of the time.

The main attraction at the Hotel Todd was the summer garden where noted singers provided entertainment in the fashion of a nightclub to the dining patrons. The New York Times wrote in 1888,

“the only drinking place in town with a summer garden attachment. . .the Hotel Todd is principally patronized by race-horse people, men of sporting proclivities, and politicians. They are all men of means, and it is not a place for 'cheap' people. There are 16 rooms in the hotel. The Summer Garden is very prettily arranged, having a huge fountain in its centre. The walls and ceiling are decorated in Japanese fashion. In this garden ladies and gentlemen may drink beer on draught or any of the fancy Summer drinks, and have a cold lunch at any time of the day or night. There are hundreds of places where all this may be obtained in New York, but this is the only place in Saratoga of the kind.”

The garden delivered a delight for many of the senses.

D.G. Yuengling Jr.’s father, who spelled his name Jüngling in the old country, had numerous older siblings, necessitating relocation to strike out on his own. He brought his old world brewing skills from Germany to America in 1828 and established several breweries, the largest being in New York City, at the intersection of Amsterdam Avenue and 128th Street. This Manhattan location, very near the piers of the Hudson, or North River, brewed the lager beer, ale and porter and was supplied from an artesian well on site. Prior to electrification, Gotham received much of its ice for refrigeration from upstate lakes and ponds, shipped by canal boats. It is likely the barrels of Yuengling Beer were ‘back-hauled’ to the Schuylerville docks on the Champlain Canal, and onto Saratoga Springs for bottling and distribution.

Saratogian, August 11, 1887

Upstate New York saw many of David G. Yuengling, Jr.’s enterprises, as he built a recreation home and development on Brant Lake in northern Warren County, was involved in horse sports, and also operated the Hotel Germania on Mitchell Ave, present day site of the parking lot for the National Museum of Racing and Hall of Fame. Those who knew Yuengling well found him good natured and humorous, fondly calling him Rex, and were his guests at lavish entertainments he staged in Saratoga, where his libations flowed liberally. His wife and daughter were frequently reported by the local daily where their fashion of dress was admired. His son Fred, however, had been more than a bit of a troublemaker on three continents, and cause for financial woes. D.G. Yuengling Jr. sought financial relief from a fellow brewer, who also happened to be an uncle, John F. Betz. When Yuengling’s obligations could not be met his uncle foreclosed, and this also lead to the change in possession of his upstate properties.

Saratogian, January 19, 1888

The beer distributor operating at the Hotel Todd switched to Beverwyck Ale brewed in Albany, and the management of the facility and the popular Summer Garden transferred to the Kirkpatrick Family. By 1900 the operation at 398 Broadway had become known as Hotel Beverwyck. Many years later, in 1957, this location was one of eight businesses destroyed by fire in Saratoga Springs early on a Sunday morning. Unfortunately, Saratoga Police officer Fred E. Pettit, who was attempting to rouse residents of the upper stories, was killed when a section of brick wall collapsed. Ruined in the fire were E.D. Starbuck, F.W. Woolworth, Saratoga Men’s Shop, Saratoga Appliance, Mac Finn Drugs, Palace Recreation, Endicott-Johnson Shoes and Liggett Drugs. Water damaged other shops and several law firms were also marred.

Historic artifacts remaining from this period are presently sought after by bottle collectors. The embossed glass identifies the Yuengling product as being bottled in Saratoga Springs, and the transparent vessel is heavy with a strong neck.  The champagne ale bottles required even more strength, as the beverage was finished in the same methods as Champagne, yielding a highly carbonated brew.  Interestingly, the former Yuengling brewery’s Manhattan location was closed following the Prohibition of alcohol sales by the eighteenth amendment in 1919, and its refrigeration rooms were converted into a storage house for fur coats and wraps. This structure has only recently been repurposed again, as a mixed use office and residential complex known as the Mink Building.

The spirit of the unique Summer Garden at Hotel Todd lives on in so many of the present day establishments of Saratoga Springs, which perform at an excellent level of entertainment, fare and drink, many also providing accommodations of the best kind. Several of these public houses offer gardens, or adjoining outdoor patios to enhance the enjoyment of their products. It is a pleasure to find and sample these offerings of the Spa City, some of which still serve that liquid link to the past, Yuengling Beer.

Summer 1888. The facade of the building at 398 Broadway reads:
"D.G. Yuengling, Jr. Champagne Ale, Porter, Lager Beer."
Photo courtesy of the George S. Bolster Collection 

7.949MBMemory Usage117msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.23
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.4.6
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "8" "id" => "285" "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" => 1753950650 "last" => 1753950650...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.47ms)
  • afterInitialise (1.96MB) (33.56ms)
  • afterRoute (375.98KB) (5.04ms)
  • beforeRenderComponent com_content (49.11KB) (867μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.71ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.79ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (16μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (1.74ms)
  • Before Access::getAssetRules (id:440 name:com_content.article.285) (18.65KB) (25μs)
  • After Access::getAssetRules (id:440 name:com_content.article.285) (7.38KB) (93μs)
  • afterRenderComponent com_content (1.57MB) (39.73ms)
  • afterDispatch (29.42KB) (1.01ms)
  • beforeRenderRawModule mod_finder () (378.73KB) (10.15ms)
  • afterRenderRawModule mod_finder () (1.95MB) (7.54ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (148μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (373μs)
  • afterRenderRawModule mod_menu () (12.58KB) (637μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (3.63KB) (99μs)
  • beforeRenderRawModule mod_custom () (920B) (60μs)
  • afterRenderRawModule mod_custom () (320.07KB) (942μs)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (52μs)
  • beforeRenderRawModule mod_menu () (24B) (66μs)
  • afterRenderRawModule mod_menu () (552B) (333μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (57μs)
  • beforeRenderRawModule mod_custom () (920B) (50μs)
  • afterRenderRawModule mod_custom () (1.03KB) (119μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (68μs)
  • afterRenderRawModule mod_menu () (4.45KB) (336μs)
  • beforeRenderModule mod_menu () (696B) (2μs)
  • afterRenderModule mod_menu () (1.34KB) (67μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (7.28KB) (477μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (73μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (122μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_custom () (10.27KB) (133μs)
  • afterRenderRawModule mod_custom () (1008B) (106μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (39μs)
  • beforeRenderRawModule mod_custom () (472B) (50μs)
  • afterRenderRawModule mod_custom () (1008B) (129μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (42μs)
  • afterRender (290.95KB) (3.07ms)
  • 1 x afterRenderComponent com_content (1.57MB) (34.08%)
    39.73ms
    1 x afterInitialise (1.96MB) (28.79%)
    33.56ms
    1 x beforeRenderRawModule mod_finder () (378.73KB) (8.71%)
    10.15ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (6.47%)
    7.54ms
    1 x afterRoute (375.98KB) (4.32%)
    5.04ms
    1 x afterLoad (444.73KB) (2.97%)
    3.47ms
    1 x afterRender (290.95KB) (2.64%)
    3.07ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.53%)
    1.79ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.49%)
    1.74ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.46%)
    1.71ms
    1 x afterDispatch (29.42KB) (0.87%)
    1.01ms
    1 x afterRenderRawModule mod_custom () (320.07KB) (0.81%)
    942μs
    1 x beforeRenderComponent com_content (49.11KB) (0.74%)
    867μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.55%)
    637μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.41%)
    477μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.32%)
    373μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.29%)
    336μs
    1 x afterRenderRawModule mod_menu () (552B) (0.29%)
    333μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.2%)
    235μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.13%)
    148μs
    1 x beforeRenderRawModule mod_custom () (10.27KB) (0.11%)
    133μs
    1 x afterRenderRawModule mod_custom () (912B) (0.1%)
    122μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.1%)
    119μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.09%)
    110μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.09%)
    109μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.08%)
    99μs
    1 x After Access::getAssetRules (id:440 name:com_content.article.285) (7.38KB) (0.08%)
    93μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.06%)
    73μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.06%)
    68μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    67μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.06%)
    66μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    57μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.04%)
    52μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.04%)
    50μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    42μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    39μs
    1 x Before Access::getAssetRules (id:440 name:com_content.article.285) (18.65KB) (0.02%)
    25μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    16μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    7μs
53 statements were executed, 5 of which were duplicates, 48 unique23.72ms860.02KB
  • SELECT @@SESSION.sql_mode;83μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?661μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 164μ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)661μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`304μ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` = :guest447μ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"479μ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"68μ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"67μ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"53μ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"63μ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"58μ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"246μ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"62μ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"59μ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"68μ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"56μ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"60μ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"53μ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"54μ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"56μ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"60μ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"54μ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"66μ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"59μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`885μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'93μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1429μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'212μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 191μ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.09ms9.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.03ms49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`892μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '285'843μ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)996μ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`578μ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)647μ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`240μ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 ASC605μ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 DESC5.02ms3.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`258μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"1.04ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 285 AND `component_type` = "content"119μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1249μ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)540μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 12.28ms688.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 ASC272μ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)113μ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` = 1370μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?80μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?661μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy