Skip to main content

The Saratoga Spa State Park conjures up images of large New Deal-era buildings surrounding spacious lawns and reflecting pools; pleasant walks along Geyser Creek cascading past the Island Spouter; picnic areas, swimming pools and golf courses. Possibly the most iconic symbol of the Park may be the Saratoga Performing Arts Center, attracting visitors to its diverse musical programs for almost sixty years.

However, it was not always so... 

Hidden beneath the contemporary vision of the Park is a long and varied history. That history reflects a local version of the experiences of many communities in the early days of our nation, influenced by one unique feature of the landscape – the springs.

European settlement of the area began in earnest in 1792 when Robert Ellis, Sr. purchased and developed a 600-acre parcel of land in the 16th allotment of the Kayderosseras Patent, today extending from South Road in the park northward to West Avenue. Ellis, with a keen eye for property, recognized that his purchase was prime real estate for two of the most significant economic activities in early rural America; farming and milling. Ignoring the mineral springs oozing out of the ground, Ellis concentrated on developing a large farm and supplementing his income by constructing a dam and a sawmill. After 220 years, the modern version of the dam remains in the same location holding back the waters of Geyser Creek. The sawmill has long since disappeared.

Adjacent to the sawmill, Ellis’ son-in-law George Peck developed a small scythe factory powered by a trip hammer around 1801, which he operated until his death in 1838.  Several hundred yards downstream at another mill seat, Robert Ellis, Jr. constructed a gristmill in 1818 located where the creek today emerges from the old railroad stone culvert. That mill continued to operate throughout the 19th century, later owned by David Gibbs and his son William, who sold the flour produced there at their store in Saratoga Springs.

Champion #1 Spring - 1871

These businesses were typical of early industrial pursuits in ante-bellum America – small scale operations with few employees, selling most of their products to the local market. During this period another small factory was established by Willis Hurlburt, who arrived from Litchfield, Connecticut in 1841. Initially taking over George Peck’s scythe business, in the 1850s Hurlburt converted the facility to a small nut and bolt factory, still employing only a few workers.

The Civil War changed all that, and Hulbert recognized the opportunity to expand to meet the demands of the war effort. However, to do that he needed partners with money. He found them in two local entrepreneurs, Arthur Dodge Seavey and Deman Vail. Seavey, born in Maine, and Vail, a lifelong Saratoga resident, made their fortune during the California gold rush, not by mining, but by selling merchandise to the eager prospectors. Together in 1862, they purchased a two-thirds share of Hurlbert’s small factory for $12,000, which was immediately invested in expanding the business; constructing a large factory building on the site of the old scythe mill. By 1866 the factory employed fifty men producing 20,000 finished nuts and bolts per day. 

 

Champion Spring Company Carbonie Gas Works - 1911

However, business declined in the post-civil war years, and in February 1870 the trio turned to Jessie Button who was well known for his skills in drilling deep wells in the area. The partners, aware of the untapped potential of the springs along the creek, retained Button who struck a large vein of mineral water at a depth of 180 feet. 

Almost overnight, the future of Robert Ellis’ 1792 land purchase was forever changed. Within a month the mineral water was spouting upwards to a height of 20 feet, immediately drawing large numbers of curiosity seekers from Saratoga Springs, two miles to the north.  The three men lost no time in promoting both the curiosity of the spouting spring and the water itself, bottling and marketing it under the names of “Geyser Spring” and “Geyser Water.” Manufacturing of nuts and bolts were now a thing of the past, the factory building signage now proudly trumpeting its new mission. Other springs appeared, drilled by Button.  One of the most famous, the Champion Spouting Spring, was located on the property of Gibbs’ gristmill on the grounds of today’s Saratoga Performing Arts Center, entertaining travelers on the railroad as they passed by.

Geyser Spring Bottling Plant - 1912

New ventures require new investments, and in 1872, George Batcheller and Jacob Adams invested in Geyser Springs, eventually purchasing the business outright. For Batcheller, Civil War officer and son-in-law of prominent Ballston banker James Cook, 1872 was a busy year. In addition to his interest in Geyser Springs, he was immersed in the construction of his mansion on Circular Street in the resort village. But it was Adams, who soon bought out Batcheller, and whose vision resulted in the expansion of Geyser Springs into Geyser Park. Images show the idyllic paths and landscape of the park, with rustic bridges crisscrossing Geyser Creek and its tributaries. Successful for a time, Adams eventually faced financial difficulties and during the 1880s the park declined. 

The twenty-year focus on springs and parks for tourists was soon followed by a twenty-year period of exploitation.  It began with the discovery that Carbonic Acid Gas could be extracted from the springs, captured in steel tubes and sold to create carbonated water for the growing beverage market. The process was perfected by Jules Formel, a native of Cuba and a graduate of the New York College of Pharmacy. He and two other New York City businessmen, John Minor and Harry Pettee, seized the opportunity to convert Saratoga’s springs in a financial bonanza. 

Sometimes working together and sometimes operating independently, beginning in 1889 they purchased much of the land along Geyser Creek from willing local landowners, and during the 1890s formed several Carbonic Acid Gas companies. From a modest beginning, these companies aggressively increased production through excessive pumping practices based on a process developed by Minor. The process resulted in such a large extraction of water that all the area springs experienced a decline in flow.

After a successful 1907 court case involving Frank Hathorn’s spring in downtown Saratoga, a Committee of Concerned Citizens, led by Spenser Trask, owner of the Yaddo Estate, lobbied for an anti-pumping law that was passed by the State Legislature the following year. The gas companies refused to suspend their pumping activities, and sued the State, seeking to overturn the law. Faced with a long court battle, the State stepped in, forming the State Reservation with the authority to buy up the gas companies’ property, halt the pumping and restore the springs to their natural state.  The Reservation was also given the task of recreating the park around the restored springs, the first step in the development of the Saratoga Spa State Park we enjoy today. 

8.122MBMemory Usage91.59msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.22
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" => "298" "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" => 1750095239 "last" => 1750095239...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (1.77ms)
  • afterInitialise (1.96MB) (19.83ms)
  • afterRoute (375.98KB) (3.93ms)
  • beforeRenderComponent com_content (50.08KB) (614μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.3ms)
  • After Access::preloadComponents (all components) (116.7KB) (667μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (12μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (1.11ms)
  • Before Access::getAssetRules (id:453 name:com_content.article.298) (18.65KB) (24μs)
  • After Access::getAssetRules (id:453 name:com_content.article.298) (7.38KB) (75μs)
  • afterRenderComponent com_content (1.73MB) (38.02ms)
  • afterDispatch (21.42KB) (1.06ms)
  • beforeRenderRawModule mod_finder () (396.66KB) (9.51ms)
  • afterRenderRawModule mod_finder () (1.95MB) (5.68ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.44KB) (136μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (134μs)
  • afterRenderRawModule mod_menu () (56.49KB) (1.06ms)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (100μs)
  • beforeRenderRawModule mod_custom () (920B) (63μs)
  • afterRenderRawModule mod_custom () (319.41KB) (1ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (54μs)
  • beforeRenderRawModule mod_menu () (24B) (72μs)
  • afterRenderRawModule mod_menu () (552B) (388μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (60μs)
  • beforeRenderRawModule mod_custom () (920B) (56μs)
  • afterRenderRawModule mod_custom () (1.03KB) (148μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (57μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (78μs)
  • afterRenderRawModule mod_menu () (4.45KB) (391μs)
  • beforeRenderModule mod_menu () (696B) (22μs)
  • afterRenderModule mod_menu () (1.34KB) (69μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.04KB) (470μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (69μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (134μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (150μs)
  • afterRenderRawModule mod_custom () (1008B) (139μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (44μs)
  • beforeRenderRawModule mod_custom () (472B) (58μs)
  • afterRenderRawModule mod_custom () (1008B) (111μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (44μs)
  • afterRender (299.06KB) (2.47ms)
  • 1 x afterRenderComponent com_content (1.73MB) (41.51%)
    38.02ms
    1 x afterInitialise (1.96MB) (21.65%)
    19.83ms
    1 x beforeRenderRawModule mod_finder () (396.66KB) (10.38%)
    9.51ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (6.2%)
    5.68ms
    1 x afterRoute (375.98KB) (4.29%)
    3.93ms
    1 x afterRender (299.06KB) (2.69%)
    2.47ms
    1 x afterLoad (444.73KB) (1.93%)
    1.77ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.42%)
    1.30ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.21%)
    1.11ms
    1 x afterDispatch (21.42KB) (1.16%)
    1.06ms
    1 x afterRenderRawModule mod_menu () (56.49KB) (1.16%)
    1.06ms
    1 x afterRenderRawModule mod_custom () (319.41KB) (1.1%)
    1.00ms
    1 x After Access::preloadComponents (all components) (116.7KB) (0.73%)
    667μs
    1 x beforeRenderComponent com_content (50.08KB) (0.67%)
    614μs
    1 x afterRenderRawModule mod_finder () (7.04KB) (0.51%)
    470μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.43%)
    391μs
    1 x afterRenderRawModule mod_menu () (552B) (0.42%)
    388μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.27%)
    250μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.16%)
    150μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.16%)
    148μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.15%)
    136μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.15%)
    134μs
    1 x afterRenderRawModule mod_custom () (912B) (0.15%)
    134μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.13%)
    119μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.12%)
    110μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.11%)
    100μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.09%)
    78μs
    1 x After Access::getAssetRules (id:453 name:com_content.article.298) (7.38KB) (0.08%)
    75μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.08%)
    72μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.08%)
    69μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.08%)
    69μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.07%)
    60μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.06%)
    58μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.06%)
    54μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.05%)
    44μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.05%)
    44μs
    3 x beforeRenderModule mod_menu () (696B) (0.03%)
    29μs
    1 x Before Access::getAssetRules (id:453 name:com_content.article.298) (18.65KB) (0.03%)
    24μs
    5 x beforeRenderModule mod_custom () (704B) (0.02%)
    14μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    12μ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%)
    8μs
54 statements were executed, 5 of which were duplicates, 49 unique10.76ms887.08KB
  • SELECT @@SESSION.sql_mode;63μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?172μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 155μ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)223μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`71μ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` = :guest132μ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"96μ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"65μ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"71μ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"56μ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"56μ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"55μ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"118μ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"62μ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"56μ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"54μ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"69μ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"59μ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"54μ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"71μ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"56μ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"52μ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"63μ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"58μ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"54μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`393μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'71μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=199μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'94μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 181μ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)379μ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` = 0508μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`488μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '298'609μ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)374μ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`278μ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)185μ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`275μ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 ASC272μ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.52ms3.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`296μ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`934μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"160μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 298 AND `component_type` = "content"123μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1153μ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)124μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1442μ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 ASC278μ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)117μ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` = 199μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?82μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?276μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy