Skip to main content

WRITTEN BY CAROL GODETTE | PHOTOS PROVIDED

 George S. Bolster Collection
ABOVE: The high school in 1955.
Photo courtesy of George S. Bolster Collection

"Live as long as you may, the first twenty years are the longest half of your life.  They appear so while they are passing; they seem to have been so when we look back on them; and they take up more room in our memory than all the years that succeed them."

- Robert Southey, poet

The school we today know as Lake Avenue Elementary has inspired generations of memories. Set in the heart of Saratoga Springs, between Marion Place and Regent Street, this spot has been an incubator for success.

The property, purchased in the 1840s, became the Andrews Homestead. The Andrews men had distinguished military careers. Captain James Madison Andrews fought on the front lines of the Civil War and became an active agent of the "Underground Railroad." A 1911 H. B. Settle photograph shows the Anderson attic, complete with a bed, candle, fireplace, and cooking utensils to hide southern slaves.

Captain Andrews' son, Colonel James M. Andrews Jr., graduated from West Point, became a lieutenant in the Spanish American War, and later commanded the 27th Division in the World War.

The wood-framed summer "cottage"-style house was reportedly the first villa erected for a summer residence. Other cottages that followed - and remain today - are in keeping with the style and size of the Andrews Homestead. After Mrs. Andrews' death, James and his sister, Ella Breckenridge, became executors of their mother's will. On August 11, 1922, they sold the Andrews Homestead to the Board of Education of Saratoga Springs for $13,195. Colonel Andrews' childhood home was razed, and the construction of a new three-story brick high school began in 1923.

Dedicated on November 25, 1924, the school housed the superintendent's office, as well as students from grades 9-12. The building and its experiences yielded generations of fond school memories - dances, after-school clubs, successful sports teams, and a beloved faculty.

Locals who attended high school in the ‘50s and ‘60s remember firm-handed principal John Sexton. His daughter, Elizabeth, recalls, "Claude Van Wie was superintendent and did NOT want my father to be principal.

My father's office was on the right as you came in the front door, and Van Wie's office was on the left. In art school, I did a painting of Saratoga High at night and Van Wie's office was dark, but my father's was lit up. My father spent many evenings working late, just to get it right." 

The Recorder Yearbook from Sexton's time captures a "Happy Days" time of innocence and a close-knit community. Colorful neighborhood character Bill McKelvey's booming, gravelly voice greeted students at the front door each morning. The community embraced students as they regularly ran to the Eastside Rec field for P.E. classes; they joined them to cheer for the Blue Streak’s football team on Friday nights at the Eastside field; they filled the seats of Convention Hall for basketball games; and local businesses like Nichol's garage opened their doors for metal shop classes.

Sexton retired in 1964, escaping the difficult challenges administration and students faced in the 1965-66 school year. Partly due to the July 1963 formation of the enlarged Saratoga City School District (13 rural school districts from Wilton, Milton, and Greenfield joined our city school district), the high school and junior high school were bursting at the seams. 

While waiting for the new West Avenue High School campus to open in January 1966, split sessions were necessary. Senior high students attended classes from 7:30 a.m. to 12:30 p.m. The junior high students attended classes for the second shift of the day. The 1966 Recorder yearbook eloquently describes it: "Split sessions and the transition to the new school have made this year's arrangement of activities both unique and unforgettable. This year has meant readjustment for the whole school, especially the faculty. While on split sessions, some teachers had to take all possessions usually kept in a desk and transport them in attaché cases. The result has been several cases of lopsidedness."

From January 1966 until the fall of 1972, the school operated as a junior high school. In September 1966, I was a pupil in the first class to attend sixth grade at the facility.  Fellow classmate Michael Prosch describes, “First and foremost, it was imposing and HUGE coming from Caroline St. School. It had multiple stories and stairways which in itself was daunting. It was the first time we were faced with dealing with a much larger population of kids from the entire district.”

We adapted to walking up two flights of stairs to our third-floor classrooms, feeling adult as we fumbled with our lockers or sat in the plush seats of the auditorium for a school-wide assembly and relished after school stops at nearby Kaye’s drugs for “Hit Parade” magazines.

Since the fall of 1972, hundreds of neighborhood elementary-aged "Lake Avenue Leopards" have identified this spot as, "my kind of school." Three excellent female principals - Rita Finnegan, Marcia Henze, and Barbara Messier - have taken the helm of the highly successful elementary school. In 2012, it was one of 19 New York State elementary schools to receive a National Blue Ribbon School Award.

Fond memories of Lake Avenue school linger. Leona Beck, a mother of two college-aged boys, recalls, "I remember the first day I walked my oldest son, then 6, to his first day of school at Lake Ave. We had just moved to Saratoga, and I was nervous about the transition to our new city, new school, new everything. I didn't know that the tradition at Lake was to line up by grade, and then at the designated time, each grade would file in starting with kindergarten. As the school days wore on, we learned the traditions of "walkers" very well. We fell right into the community, and my kids still have good friends from Lake."

Writer and former Lake Avenue parent Amy Godine enthuses, "We loved this school. It was out of central casting. Long windows and old brick walls and halls that echoed and a maple gym floor that gleamed. The principal's office, right next to the front entrance. I appreciated noble teachers who were energetic, funny, focused and so ambitious for the kids. The two-square court saw even more instructive use than the classroom, steeping kids from every grade in the finer arts of adjudication and valor in disgrace before they knew what hit 'em. Lake Avenue had it all."

As the Lake Avenue school theme song proclaims, "Lake Avenue is my kind of school" for every age population it serves.

(Author's full disclosure: Lake Avenue always will hold a special place in my heart. I live in former principal Sexton's house and regularly correspond with his daughter, Elizabeth. My grown children are still close friends with many of their Lake Avenue classmates. And, I ended a memorable career with five glorious years as a teacher of fourth and fifth graders in a spot that will remain forever dear to me.)

7.872MBMemory Usage113msRequest 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" => "182" "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" => 1746900283 "last" => 1746900283...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.04ms)
  • afterInitialise (1.96MB) (26.65ms)
  • afterRoute (375.09KB) (4.97ms)
  • beforeRenderComponent com_content (48.95KB) (1.22ms)
  • Before Access::preloadComponents (all components) (47.72KB) (1.66ms)
  • After Access::preloadComponents (all components) (116.7KB) (985μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (15μs)
  • After Access::preloadPermissions (com_content) (507.06KB) (1.38ms)
  • Before Access::getAssetRules (id:335 name:com_content.article.182) (18.65KB) (25μs)
  • After Access::getAssetRules (id:335 name:com_content.article.182) (7.38KB) (96μs)
  • afterRenderComponent com_content (1.57MB) (33.74ms)
  • afterDispatch (21.42KB) (977μs)
  • beforeRenderRawModule mod_menu () (397.89KB) (22.7ms)
  • afterRenderRawModule mod_menu () (13.13KB) (986μs)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.73KB) (182μs)
  • beforeRenderRawModule mod_finder () (1.45KB) (12μs)
  • afterRenderRawModule mod_finder () (1.95MB) (6.28ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (2.82KB) (122μs)
  • beforeRenderRawModule mod_custom () (16B) (214μs)
  • afterRenderRawModule mod_custom () (320.11KB) (1.18ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.27KB) (55μs)
  • beforeRenderRawModule mod_menu () (24B) (78μs)
  • afterRenderRawModule mod_menu () (552B) (461μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (66μs)
  • beforeRenderRawModule mod_custom () (920B) (59μs)
  • afterRenderRawModule mod_custom () (1.03KB) (147μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (61μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (118μs)
  • afterRenderRawModule mod_menu () (4.45KB) (419μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (84μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.32KB) (543μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (73μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (131μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (54μs)
  • beforeRenderRawModule mod_custom () (5.95KB) (172μs)
  • afterRenderRawModule mod_custom () (1008B) (124μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (44μs)
  • beforeRenderRawModule mod_custom () (8B) (75μs)
  • afterRenderRawModule mod_custom () (1008B) (118μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (46μs)
  • afterRender (290.9KB) (2.96ms)
  • 1 x afterRenderComponent com_content (1.57MB) (29.74%)
    33.74ms
    1 x afterInitialise (1.96MB) (23.49%)
    26.65ms
    1 x beforeRenderRawModule mod_menu () (397.89KB) (20.01%)
    22.70ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.54%)
    6.28ms
    1 x afterRoute (375.09KB) (4.39%)
    4.97ms
    1 x afterLoad (444.73KB) (2.68%)
    3.04ms
    1 x afterRender (290.9KB) (2.61%)
    2.96ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.46%)
    1.66ms
    1 x After Access::preloadPermissions (com_content) (507.06KB) (1.22%)
    1.38ms
    1 x beforeRenderComponent com_content (48.95KB) (1.07%)
    1.22ms
    1 x afterRenderRawModule mod_custom () (320.11KB) (1.04%)
    1.18ms
    1 x afterRenderRawModule mod_menu () (13.13KB) (0.87%)
    986μs
    1 x After Access::preloadComponents (all components) (116.7KB) (0.87%)
    985μs
    1 x afterDispatch (21.42KB) (0.86%)
    977μs
    1 x afterRenderRawModule mod_finder () (7.32KB) (0.48%)
    543μs
    1 x afterRenderRawModule mod_menu () (552B) (0.41%)
    461μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.37%)
    419μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.21%)
    242μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.19%)
    214μs
    1 x afterRenderModule mod_menu () (3.73KB) (0.16%)
    182μs
    1 x beforeRenderRawModule mod_custom () (5.95KB) (0.15%)
    172μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.13%)
    147μs
    1 x afterRenderRawModule mod_custom () (912B) (0.12%)
    131μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.11%)
    122μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.1%)
    118μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.1%)
    115μs
    1 x After Access::getAssetRules (id:335 name:com_content.article.182) (7.38KB) (0.08%)
    96μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.07%)
    84μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    78μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.07%)
    75μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.06%)
    73μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.06%)
    66μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.05%)
    59μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.05%)
    55μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    46μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    44μs
    1 x Before Access::getAssetRules (id:335 name:com_content.article.182) (18.65KB) (0.02%)
    25μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    15μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    14μs
    1 x beforeRenderRawModule mod_finder () (1.45KB) (0.01%)
    12μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    12μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
53 statements were executed, 5 of which were duplicates, 48 unique10.94ms860.03KB
  • SELECT @@SESSION.sql_mode;84μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?207μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 183μ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)230μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`111μ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` = :guest259μ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"165μ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"91μ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"102μ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"81μ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"98μ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"81μ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"133μ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"84μ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"83μ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"82μ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"79μ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"80μ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"94μ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"83μ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"78μ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"95μ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"86μ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"93μ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"80μ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"85μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`463μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'85μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1141μ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 1118μ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)428μ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` = 0608μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`589μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '182'205μ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)458μs54.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`304μ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)245μ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`289μ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 ASC325μ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.13ms3.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`286μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"270μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 182 AND `component_type` = "content"122μs536B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1216μ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)154μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1575μ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 ASC355μ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)131μ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` = 1142μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?85μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?180μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy