Skip to main content

{From the 2024 Spring Magazine}

Written by Carol Godette  |  Photos provided (Unless Noted)

When faced with an aging building, much like a beloved grandparent in decline, we often turn a blind eye to the signs of deterioration —

crumbling brick and mortar, uneven floors, leaky roofs, and peeling paint. Our emotional attachment leads us to believe things will persist as they always have, even as the structural integrity fades.

Such was the fate of 35 Church Street, known as The Hub, before its demolition on Nov. 15, 2004. Although this spot wasn’t known as The Hub until 1955, it was the center of Saratoga Springs’ activity in its early existence.

At the turn of the twentieth century, Saratoga Coal Companies' office and coal storage silo was directly next door. They supplied most residents with coal heat. Across the street, the bustling railroad depot station welcomed hundreds of visitors to the city each day.

1931 photo of neighbor Saratoga Coal Company. Courtesy of Minnie Bolster

In the early 1900s, rather than being a bar, the downstairs commercial front of 35 Church Street was McAllister and Remington’s Plumbing and Steamfitters shop. Legend has it that the back of the 137-foot building operated as a gin mill where laborers congregated after a hard day's work. Meanwhile, the upper floors accommodated tenants in its six narrow, shotgun-style apartments.

By the 1930s, the commercial front became a cigar and billiards room, known as the Recreation Association Inc., the beginnings of a series of many workingman’s taverns built around the train station.

Today, most native Saratogians fondly remember this spot as The Hub, a once thriving bar at the heart of many locals’ and Skidmore students’ coming of age.

In 1955, Helene Cogan Heinz and her husband, Charlie, returned to the area from Hollywood. Having frequented a bar called The Hub during their time in California, they purchased the 35 Church Street building, moved into the upstairs residence, and commenced operating the downstairs bar, renaming it The Hub after their favorite haunt. Thus began the Cogan family's  34-year tenure, during which they played an integral role in shaping The Hub into a cherished and enduring institution in Saratoga’s renowned bar scene. At that time, grandson Jack jokes, “It was an old man’s neighborhood bar.”

The clientele changed when Helene sold the Hub to her son-in-law, Bill Eddy Sr., and her grandsons, Bill Eddy Jr. and Jack Cogan, in 1969. Jack became the sole owner in the mid-1970s and had it for nearly 20 years.

Skidmore female bartenders (Mara King, a well-known local real estate agent, bartended for six months) and males from Union College began serving drinks to a young crowd packed ten-deep, there to connect with old friends and perhaps meet a new love interest.

The Cogan family all helped in some capacity, bartending or pitching in as needed.

Even though the drinking age was 18, minors tried to sneak in, and fines were hefty. Jack’s cousin Pam Talbot, the bouncer, was a force to be reckoned with. Pam, stationed at the front door, knew most locals, and few tried to sneak by her. She confiscated drawers full of fake IDs. Pam's keen eye knew that the last three numbers of an ID were the year you were born. In the pre-photo era, she knew an ID was counterfeit if the date of birth and the last three numbers didn’t match.

Jack promoted camaraderie by engaging customers who became extended family. Regulars were painted into one of two murals commissioned by local artist Hud Armstrong. He lived upstairs rent-free for a year, wandering in daily to paint in a few regulars. The colorful mural of about 90 patrons, selected mainly by Hud, recreated the iconic bar and proudly hung in the back by the kitchen. The other mural was a sepia-tone 1919 historical scene set in front of the old railroad station, depicting the day Upset defeated Man O’War in Saratoga. Today, this mural hangs inside the Mabee Building, complete with a key identifying most of the 236 locals. Local history buffs could enjoy the mural for the better part of an afternoon. I smiled, seeing my favorite mailman, Pete Cahill, and city character; Johnny “Up n Down.”

Jack created magic by trying new things. Theme nights such as February’s “Tuxedo Night” or April’s “Beach Boy” day, where the floor was lined with sawdust, were favorite events that broke up a long winter.

Even a regular night playing table shuffleboard could turn into a lifelong memory. In the mid-70s, “Some guys from Greenfield pulled into the parking lot with a pig for sale. For some crazy reason, I decided to jump on the pig and ride it through the bar crowd. The pig ended up under the shuffleboard table. Most impressive,” said Jack. The pig was returned to its owners in the lot.

In 1989, after twenty extraordinary years of trying to keep things fresh, Jack decided to sell his bar to James Doyle. The building needed constant upkeep and Jack was not ready to tackle all the new code regulations needed. Jack misses the people he served every week but is still in contact with many of the lifelong friends he made.

Throughout the 1990s, the bar was renamed the Saratoga Clam and Oyster Bar, The Hub Club, and Dougans. In 1999, Serge Shishik bought the business and renamed it the Hub, perhaps to recreate the magic that once existed in this iconic establishment.

The aging building, then exposed to the elements and devoid of neighbors on either side, had numerous structural issues.

In 2002, the Adirondack Trust Company acquired the building and applied to the Design Review Commission to demolish it.

There was heated debate and discussion on the architectural and historical significance of the building. Since nothing within the building met current code standards, it was determined that renovation of the 1850 building would be cost prohibitive.

The building was demolished on November 15, 2004. Yet, while the physical structure may have disappeared, the spirit of The Hub lives on in the memories of those who knew and loved it.

The five-story office and retail Mabee Building now breathes new life into 35 Church Street while paying tribute to its past. The beautifully framed 15-foot-long mural from the Hub is a reminder of what once stood on this spot.

Author’s note: Thanks to Mitch Cohen for his deed research and Jack Cogan for his extensive materials and first-hand accounts.

8.002MBMemory Usage126msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.21
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.42
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "8" "id" => "693" "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" => 1747483726 "last" => 1747483726...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (1.99ms)
  • afterInitialise (1.96MB) (21.65ms)
  • afterRoute (375.98KB) (4.21ms)
  • beforeRenderComponent com_content (49.15KB) (752μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.35ms)
  • After Access::preloadComponents (all components) (116.7KB) (725μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (11μs)
  • After Access::preloadPermissions (com_content) (514.33KB) (1.13ms)
  • Before Access::getAssetRules (id:864 name:com_content.article.693) (18.65KB) (28μs)
  • After Access::getAssetRules (id:864 name:com_content.article.693) (7.38KB) (87μs)
  • afterRenderComponent com_content (1.64MB) (72.33ms)
  • afterDispatch (29.42KB) (1.05ms)
  • beforeRenderRawModule mod_finder () (375.67KB) (7.82ms)
  • afterRenderRawModule mod_finder () (1.95MB) (5.41ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (143μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (124μs)
  • afterRenderRawModule mod_menu () (12.58KB) (664μs)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.63KB) (100μs)
  • beforeRenderRawModule mod_custom () (920B) (64μs)
  • afterRenderRawModule mod_custom () (320.07KB) (1.09ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (53μs)
  • beforeRenderRawModule mod_menu () (24B) (74μs)
  • afterRenderRawModule mod_menu () (552B) (342μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (58μs)
  • beforeRenderRawModule mod_custom () (920B) (71μs)
  • afterRenderRawModule mod_custom () (1.03KB) (150μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (57μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (76μs)
  • afterRenderRawModule mod_menu () (4.45KB) (400μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (1.34KB) (76μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (472μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (71μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (128μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (53μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (145μs)
  • afterRenderRawModule mod_custom () (1008B) (123μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (472B) (56μs)
  • afterRenderRawModule mod_custom () (1008B) (121μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (61μs)
  • afterRender (306.95KB) (2.42ms)
  • 1 x afterRenderComponent com_content (1.64MB) (57.31%)
    72.33ms
    1 x afterInitialise (1.96MB) (17.15%)
    21.65ms
    1 x beforeRenderRawModule mod_finder () (375.67KB) (6.2%)
    7.82ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (4.29%)
    5.41ms
    1 x afterRoute (375.98KB) (3.33%)
    4.21ms
    1 x afterRender (306.95KB) (1.92%)
    2.42ms
    1 x afterLoad (444.73KB) (1.58%)
    1.99ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.07%)
    1.35ms
    1 x After Access::preloadPermissions (com_content) (514.33KB) (0.89%)
    1.13ms
    1 x afterRenderRawModule mod_custom () (320.07KB) (0.86%)
    1.09ms
    1 x afterDispatch (29.42KB) (0.83%)
    1.05ms
    1 x beforeRenderComponent com_content (49.15KB) (0.6%)
    752μs
    1 x After Access::preloadComponents (all components) (116.7KB) (0.57%)
    725μs
    1 x afterRenderRawModule mod_menu () (12.58KB) (0.53%)
    664μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.37%)
    472μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.32%)
    400μs
    1 x afterRenderRawModule mod_menu () (552B) (0.27%)
    342μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.19%)
    244μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.12%)
    150μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.11%)
    145μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.11%)
    143μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.11%)
    135μs
    1 x afterRenderRawModule mod_custom () (912B) (0.1%)
    128μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.1%)
    124μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.09%)
    110μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.08%)
    100μs
    1 x After Access::getAssetRules (id:864 name:com_content.article.693) (7.38KB) (0.07%)
    87μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    76μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.06%)
    76μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.06%)
    74μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.06%)
    71μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.05%)
    61μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    58μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.04%)
    56μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.04%)
    53μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    45μs
    1 x Before Access::getAssetRules (id:864 name:com_content.article.693) (18.65KB) (0.02%)
    28μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    16μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    13μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    11μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
53 statements were executed, 5 of which were duplicates, 48 unique10.34ms868.02KB
  • SELECT @@SESSION.sql_mode;66μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?191μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 158μ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)271μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`110μ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` = :guest189μ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"173μ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"59μ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"57μ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"57μ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"63μ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"107μ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"64μ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"58μ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"55μ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"57μ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"63μ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"67μ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"61μ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"54μ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"63μ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"58μ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"59μ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"57μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`494μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'76μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1145μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'122μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 197μ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)436μ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` = 0533μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`664μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '693'302μ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)410μ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`332μ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)215μ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`237μ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 ASC337μ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.24ms3.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`275μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"229μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 693 AND `component_type` = "content"115μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1164μ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)255μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1450μ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 ASC337μ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)133μ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` = 1130μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?78μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?242μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy