Skip to main content

Written by Field Horne  |  curators Ruby Marcotte & Susan McGrath

During work on the vast archive of the Saratoga Springs History Museum in 2016, a group of fifteen mounted photographs of Broadway businesses turned up in a box of random papers. There was no clear evidence of their provenance, but they may have been collected by photographer George S. Bolster (1913–1989). They carry no photographer’s stamp but a handwritten legend on one mount suggests they were taken by Patrick H. McKernon.

Born in Ireland about 1829, McKernon was in Saratoga Springs by 1860 when he was called an “artist.” In 1867 a reporter noted he “did a small business” and was considered honest; in the following year he had a studio at 130½ Broadway. The site is now 378 Broadway, occupied by the Funding Store. By 1876 he had moved to Fort Edward, but soon returned to Saratoga Springs.

The photographs provide us with an unparalleled look at the quotidian act of shopping in post-Civil War Saratoga Springs. From internal evidence we know they were taken in 1867 or 1868. All the businesses save one advertised in the Weekly Saratogian and/or the street directories. Many details were obtained from the R.G. Dun Credit Reporting Ledgers in the Baker Library, Harvard Business School, Boston.


1. L.L. Brintnall Groceries and Provisions 220 Broadway [now 472, Menges and Curtis]

Lorenzo L. Brintnall (c.1834–1890) came from Townshend, Vermont, opening his grocery store in the spring of 1867.
Later in life he ran the Waverley Hotel, a flatiron-shaped structure at North Broadway and the present Arterial.

On the building’s upper floors was the furniture warehouse
of George K. Krigger (1831–1889). By 1880 Krigger had removed to Chicago.

3. F.W. Fonda & Co., Dealers in staple and fancy dry goods 200 Broadway (Now 436, Lifestyles)

Saratoga native Ferdinand Wiggins Fonda (1839–1919) was in business by the late 1850s but in 1861 speculated in oil, losing big within a year, so he sold out to Wescott and Smith in 1863. By 1867 he was back in business and in 1874 was “doing the best business in town.” He later moved to New York City and died there.

5. Joseph G. Cooke, Hardware, Tin and Stoves 166 Broadway (Now 404, n.  Fox Jewelers)

Joseph Gardiner Cooke (1834–1886) was a native of Milford, Otsego County, and was brother-in-law of prominent Saratogian Charles S. Lester, president of the Commercial National Bank. In 1867 Cooke bought out his partner Henry R. Benedict; in the following year he bought the businesses of both Benedict and Terwilliger and knocked out a wall combining two storefronts. He was reported to be a “good businessman, the best hardware dealer in Saratoga Springs,” with net worth of $44,000 in 1874, equivalent to $1.25 million today. He erected a new building in 1873 but between 1875 and 1880 moved to Washington, D.C., where he died.

7. D.M Mcmaster, boots, shoes & rubbers. 176 Broadway (Now 410 Cantina)

David M. McMaster (b. ca. 1827), from Geneva, Ontario County, had been a canal captain, but opened his Broadway store shortly before March 1863. In 1870 he was reported to be “well insured and not overstocked.” His rubber boots were a relatively new invention, developed by Hiram Hutchinson after he bought the use of Charles Goodyear’s patent for vulcanizing (hardening) rubber in 1853.

9. E.W Ouderkirk Furniture and Upholstery. 171 Broadway ( Now 431, Putnam Market)

Edward W. Ouderkirk (1831–1874) started his business around 1863, described in 1866 as “a small trade.” He was reported as “character and habits good but has a crazy wife.” He took a new “stand” in 1869. Later “occasional sprees” were reported, but under-insured, he lost thousands in an 1872 fire.

11. C.R Brown Jewerler and Optician. 71 Broadway ( Now 297, Vision Center)

Charles R. Brown (1843–1882) came from Otsego County in 1859 and was soon in business selling jewelry and fancy goods and repairing watches. He also operated the Park House but was burned out in 1864. Brown was a “cripple” and “goes about town in a velocipede,” a primitive bicycle that operated like a scooter with a seat. By 1869 he owned an entire business block on Broadway. In 1871 he built the Park Place Hotel but it burned soon after the season ended. The following year he built a new hotel, the massive Grand Central, on the same site, but it, too, burned after the 1874 season ended.

13. James H. Wright, Merchant and Dealer in Gentlemen’s Furnishing Goods. 117–119 Broadway [now 365–367, The Rip Van Dam Hotel]

James Hewlett Wright (ca. 1830–1891) came from New York City in 1855 and worked for Chauncey Hathorn and A.F. Brown for several years. Brown failed in business and Wright took his “stand” in 1858. He was said to be “a very steady and industrious man and an excellent mechanic.” His business was largely made-to-order; in 1865 he reported producing 500 vests and 300 coats worth $15,000 ($278,000 in 2023 dollars), employing five men and four women. He served as village president in 1870 and county treasurer 1875–78. He left Saratoga in 1878.

15.  A.S. Hays Confectionery and Ice Cream Saloon .165 Broadway [now 425, iRun Local]

Galway native Alexander S. Hays (1825–1899) was in business on Broadway by 1860, an “honest, sober, industrious, attentive, prudent prompt businessman.” His shop may have operated seasonally for the tourist trade as an 1877 report noted he had “suspended trade until the next season.” 

2. Palmer and Waterbury, Dealer in groceries & provisions 208 Broadway ( Now 444, Wheatfields)

Hiram Palmer (1825–1909), a Malta native, lost an earlier store to fire in the summer of 1866. He entered into partnership with John Armstrong Waterbury (1839–1916) and soon reopened a new store. The two men were reported to be “men of intelligence and business experience” with a net worth of $26,500, equivalent to $540,000 today. In 1871 Waterbury decided he did not like the business and sold out to Palmer. Waterbury became a musician.

On the building’s upper floors was the furniture warehouse
of George K. Krigger (1831–1889). By 1880 Krigger had removed to Chicago.

4. Westcott  & Smith, Staple & fancy dry goods boots and shoes and groceries 188 Broadway (Now 424, Northshire books)

Warren B. B. Wescott (1820–1899) and Adam A. Smith (1842–1904) were clerking for F.W. Fonda when he failed,
so in 1863 they bought out his stock and entered business. Smith was reported to have “extraordinary business capacity and his character for probity is notorious.” In 1867 they were “doing a fair village and country trade.” They were out of business by 1876.

6. A, Hartwell, dealer in harness trunks & saddlery. 172 Broadway (Now 408, Cantina)

Austin Hartwell (1824–1890) was in business here by 1850. He was reported to be a “hardworking man” who was “tolerably honest but is encumbered by a large family and his prospects are not very promising.” He advertised “Saratoga Trunks made to order,” but was out of business by 1870, living in Springfield, Massachusetts.

Note the second-floor sign for the law office of George S. Batcheller who, five years later, built the extraordinary Batcheller Mansion on Circular Street.

8. J.M Pitney Grocer Brandies Gins and wines. 164 Broadway (Now 402, uncommon grounds)

Jacob W. Pitney (ca. 1817–1894) came from Arlington, Vermont. His brother Jonathan Pitney came as well, establishing a boarding house with a farm to supply fresh produce; today it is Pitney Meadows Community Farm. Jacob was out of business by 1872.

10. A.R Barrett Hat Store, 148 Broadway ( Now 392, Saratoga Saddlery)

New Hampshire native Artemas Raymond Barrett (1815–1904) had been in business on his own since 1844, “a married, honest, prudent businessman” who did “a safe, snug business.” In 1870 it was “the best in his line in the town.” In 1874 he was rebuilding his store “in elegant style.”

12. M.N McGuire Merchant Tailor and Clothier. 134 Broadway ( Now 380, The Furniture Store).

Irishman Michael N. McGuire (ca. 1822–1870) was in business by 1848. In 1867 he was reported to be “very intemperate and does not attend to his business at all regularly,” but soon was “reformed and doing better.” He failed at business, and it was sold at sheriff’s sale late in 1868. He died of typhoid fever a year later.

14. F.T. Hill and Company, Wholesale & Retail Druggists & Apothecaries. 162 Broadway [now 400, Uncommon Grounds]

Franklin T. Hill (1819–1875) came from Woodbury, Vermont, and was in business here by 1850. He was reported to be “a strictly honest upright man . . . a man of good repute steady temperate and doing good business.” He also sold U.S. Revenue Stamps, a Civil War-era tax assessment; in 1872 he purchased a soda fountain for his drugstore. When he died he was succeeded by his assistant, T.H. Sands Pennington, an African American druggist who was long a respected Broadway businessman.

8.434MBMemory Usage117msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.20
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" => "757" "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" => 1747099257 "last" => 1747099257...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (1.05ms)
  • afterInitialise (1.96MB) (19.05ms)
  • afterRoute (375.09KB) (3.84ms)
  • beforeRenderComponent com_content (48.95KB) (570μs)
  • Before Access::preloadComponents (all components) (47.72KB) (935μs)
  • After Access::preloadComponents (all components) (116.7KB) (802μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (13μs)
  • After Access::preloadPermissions (com_content) (510.94KB) (1.03ms)
  • Before Access::getAssetRules (id:932 name:com_content.article.757) (18.65KB) (25μs)
  • After Access::getAssetRules (id:932 name:com_content.article.757) (7.38KB) (62μs)
  • afterRenderComponent com_content (2.01MB) (64.53ms)
  • afterDispatch (21.42KB) (831μs)
  • beforeRenderRawModule mod_menu () (400.99KB) (10.09ms)
  • afterRenderRawModule mod_menu () (58.84KB) (1.18ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.73KB) (160μs)
  • beforeRenderRawModule mod_finder () (1.45KB) (11μs)
  • afterRenderRawModule mod_finder () (1.95MB) (5.45ms)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (2.82KB) (83μs)
  • beforeRenderRawModule mod_custom () (16B) (123μs)
  • afterRenderRawModule mod_custom () (320.11KB) (1.36ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.27KB) (75μs)
  • beforeRenderRawModule mod_menu () (24B) (77μs)
  • afterRenderRawModule mod_menu () (552B) (397μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (59μs)
  • beforeRenderRawModule mod_custom () (920B) (57μs)
  • afterRenderRawModule mod_custom () (1.03KB) (133μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (89μs)
  • afterRenderRawModule mod_menu () (4.45KB) (391μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (66μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.32KB) (589μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (85μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (129μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (52μs)
  • beforeRenderRawModule mod_custom () (5.95KB) (149μs)
  • afterRenderRawModule mod_custom () (1008B) (121μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (43μs)
  • beforeRenderRawModule mod_custom () (8B) (56μs)
  • afterRenderRawModule mod_custom () (1008B) (109μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (40μs)
  • afterRender (330.95KB) (2.68ms)
  • 1 x afterRenderComponent com_content (2.01MB) (55.15%)
    64.53ms
    1 x afterInitialise (1.96MB) (16.28%)
    19.05ms
    1 x beforeRenderRawModule mod_menu () (400.99KB) (8.62%)
    10.09ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (4.66%)
    5.45ms
    1 x afterRoute (375.09KB) (3.28%)
    3.84ms
    1 x afterRender (330.95KB) (2.29%)
    2.68ms
    1 x afterRenderRawModule mod_custom () (320.11KB) (1.16%)
    1.36ms
    1 x afterRenderRawModule mod_menu () (58.84KB) (1%)
    1.18ms
    1 x afterLoad (444.73KB) (0.9%)
    1.05ms
    1 x After Access::preloadPermissions (com_content) (510.94KB) (0.88%)
    1.03ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (0.8%)
    935μs
    1 x afterDispatch (21.42KB) (0.71%)
    831μs
    1 x After Access::preloadComponents (all components) (116.7KB) (0.69%)
    802μs
    1 x afterRenderRawModule mod_finder () (7.32KB) (0.5%)
    589μs
    1 x beforeRenderComponent com_content (48.95KB) (0.49%)
    570μs
    1 x afterRenderRawModule mod_menu () (552B) (0.34%)
    397μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.33%)
    391μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.2%)
    230μs
    1 x afterRenderModule mod_menu () (3.73KB) (0.14%)
    160μs
    1 x beforeRenderRawModule mod_custom () (5.95KB) (0.13%)
    149μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.11%)
    133μs
    1 x afterRenderRawModule mod_custom () (912B) (0.11%)
    129μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.11%)
    123μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.09%)
    108μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.08%)
    89μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    85μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.07%)
    83μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    77μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.06%)
    75μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    66μs
    1 x After Access::getAssetRules (id:932 name:com_content.article.757) (7.38KB) (0.05%)
    62μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    59μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.05%)
    57μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.05%)
    56μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    43μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    40μs
    1 x Before Access::getAssetRules (id:932 name:com_content.article.757) (18.65KB) (0.02%)
    25μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    13μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_finder () (1.45KB) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    7μs
54 statements were executed, 5 of which were duplicates, 49 unique12.52ms927.08KB
  • SELECT @@SESSION.sql_mode;98μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?269μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 179μ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`113μ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` = :guest182μ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"129μ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"89μ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"70μ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"68μ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"68μ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"69μ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"95μ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"103μ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"73μ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"68μ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"66μ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"65μ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"242μ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"107μ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"81μ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"68μ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"65μ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"90μ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"107μ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"86μ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"72μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`592μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'120μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1254μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'136μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1212μ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)401μ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` = 0453μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`622μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '757'307μ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)364μs102.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`297μ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)200μ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`277μ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 ASC314μ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.1ms3.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`284μ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`953μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"400μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 757 AND `component_type` = "content"151μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1317μ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)197μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1493μ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 ASC467μ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)176μ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` = 1150μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?108μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?294μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy