Skip to main content

WRITTEN by Samantha Bosshart, Saratoga Springs Preservation Foundation
Photos provided by Saratoga Springs Preservation Foundation

I met Commissioner of Public Works Anthony “Skip” Scirocco in May of 2009, when as part of National Preservation Month, the Saratoga Springs Preservation Foundation recognized his efforts to restore the granite stairs of City Hall and return the lions that had once graced them. The lions were placed in front of City Hall when Saratoga Springs was incorporated as a city in 1915, but they were later removed. The project to enhance the front entrance included the removal of the existing deteriorating concrete stairs, installing radiant sidewalks, replacing the modern glass front doors with wood doors that incorporated a historic window above that the staff had found in City Hall, and adding a vestibule. Skip beamed with pride, humbly accepted the award, and thanked his staff for their efforts.  

The Spirit of Life & Spencer Trask Memorial after the 2015 restoration. Inset, Skip Scirocco and Samantha Bosshart kicking-off the start of work in 2014.

Being born and raised in Saratoga Springs, Skip had a strong appreciation for our city’s history. This was the first of many preservation projects that the City of Saratoga Springs would be recognized for under his leadership.  

It was not until concerned citizens approached the Saratoga Springs Preservation Foundation about the poor condition of the white pine trees that served as the backdrop to the Spirit of Life & Spencer Trask Memorial in Congress Park that I got to know Skip. People feared that the trees might fall in a storm and irreparably damage the bronze sculpture that serves as the unofficial symbol of our city. In 2011, I approached the then Mayor, Scott Johnson, and Skip about establishing a formal partnership to restore the Spirit of Life & Spencer Trask Memorial. The Foundation and the City would raise the necessary funds and together oversee the project to restore the locally and nationally significant memorial. 

Sculptor Daniel Chester French and architect Henry Bacon, who would later become most well known for their collaboration of the Lincoln Memorial, were hired by Katrina Trask and George Foster Peabody to design a memorial to recognize Spencer Trask’s contributions to preserving the spring waters of Saratoga Springs after his tragic death in a train accident. In 1915, Walter P. Butler accepted the Memorial on behalf of the city as one of his first public acts as the first mayor of the newly incorporated City of Saratoga Springs. 

A committee was formed that regularly met with Skip and his staff at the time, Donna Buckley and Debbie LaBreche, to undertake the project. The initial scope was only focused on the bronze sculpture, the architectural surround, and immediate landscaping. However, as more was learned about Charles Leavitt’s original landscape design, encompassing the entire northwest quadrant of Congress Park, the scope and budget for the project grew exponentially – which at first, I do not believe Skip was particularly excited about. The final project included not only the original scope of work  – removal of the white pines that had reached the end of their life cycle and planting of new pines, replacing the overgrown arborvitae along the reflecting pool, but also the restoration of the rambling stone creek, landscaping surrounding the pond, adding plantings along the south side of Saratoga Arts, replacing the asphalt walkways with more appropriate concrete sidewalks that were ADA compliant, and installing eight benches and ten light fixtures.  

Skip, who got his nickname because he was born on leap year, loved to cruise around in his 1957 Ford Thunderbird with his wife Corinne.

In the early evenings, I regularly checked in on the progress of the project while I was walking my dog and that was when I would often see him smiling with his wife Corinne as they cruised through Congress Park in their yellow 1957 Thunderbird convertible. It was these moments that I got to know him better. “He always liked to drive around to check on things throughout the city,” shared Corinne. 

A fond memory of the project we shared was the two of us seeing the Spirit of Life wrapped head to toe in protective bubble wrap. A less fond memory was discovering the thousands of bricks from the former Congress Hotel that lay buried and needed to be removed to trench the electrical wiring for the light fixtures. There were also moments of panic as to whether the project would be completed on time - June 26, 2015, the 100th anniversary of the original dedication, especially as new sod was being rolled out just hours before the ceremony.  It was at the rededication ceremony that we both had the joy of seeing more than 500 people come out to celebrate and spontaneously sing “Happy Birthday” to our Spirit of Life.  

It was not until after the project was complete that we both saw the tremendous impact of the project - a relatively unused, overgrown, dark part of the park was now full of activity throughout the seasons.  It is the place of community gatherings, picnics, engagements, weddings, and family photos of residents and visitors, as well as a place for quiet inspiration and contemplation.  

Not long after seeing that transformation, Skip began the restoration of the 1922 Katrina Trask Memorial Gateway. “On his own initiative he took on that restoration and carried through the lengthy project after the conditions were discovered to be much worse than expected,” shared Rumara Jewett, a local artist who has done extensive research about Katrina and Spencer Trask. “The Commissioner said ‘I want the rededication ceremony to be just like the original’ so we studied the historical record to re-create as much as possible of the original November 15 heartfelt dedication in the snow.” 

Skip with his staff in front of Deer Park Spring following its restoration.
He was proud of his work at City Hall and his efforts to restore the Civil War monument in Congress Park. 

“He loved Congress Park and the Canfield Casino,” shared Corinne, his wife of 54 years. Under his leadership, many projects were completed at the Canfield Casino.  The front entrance of the building was enhanced – the stairs were restored; the dogs, reproductions based on the originals in the Saratoga Springs History Museum, returned; and brick sidewalks with radiant heating were installed.  In addition, significant structural repairs were made, the skylights and laylights in the ballroom were restored, the plaster ceilings were repaired, the wood floors were refinished, and lighting and sound equipment were greatly improved.  

In Congress Park, Skip was also responsible for the restoration of the Deer Park Spring and the continued maintenance of the historic, hand-carved Marcus Illion horses of the Carousel. Unfortunately, he was often faced with acts of vandalism in the park – the “Day” and “Night” urns, the Morrissey Fountain, and the Civil War monument in honor of the 77th Infantry Regiment. Each time he ensured that they were restored.  

Other projects he oversaw included the restoration of High Rock Spring and the roof of the City Landmark Drink Hall. “Commissioner Scirocco was very committed to the City's preservation and his instincts steered many challenging projects to success. You would often find him in the midst of a dusty project site asking questions and offering helpful insights,” shared Debbie LaBreche, City Engineer.  

Skip was also proud of the 1871 City Hall renovation that took place after the lightning strike in 2018.  He saw it as an opportunity to improve the entire building, a Local Landmark.  Working with Mike Veitch, Business Manager for the Department of Public Works, spaces were reconfigured; handicap accessibility was improved; electrical wiring and plumbing were updated; and central air conditioning was installed –removing unattractive window air conditioners.  The hall of the first floor and Music Hall received appropriate period treatments, making for more welcoming spaces. 

Unfortunately, due to Covid the completion of City Hall was not publicly celebrated as Skip had hoped.  To mark the 150th anniversary of City Hall, we requested that he host a tour of the building for Foundation members in December 2021. 
He was surprised by the overwhelming response to the tour. I remember him smiling ear to ear as he gave the tour and shared about the project.  Sadly, this turned out to be the last time I saw Skip. He passed away on April 6, 2022.   

Skip made a lasting impact by preserving the historic architecture and landscaped heritage of Saratoga Springs for future generations. Deservedly, Skip was posthumously inducted into the Saratoga Springs History Museum Hall of Fame in October 2022. I was honored to be asked to speak at the induction ceremony and I am grateful for the opportunity to have worked with him.  

To see a video of all the projects he undertook, please visit the Saratoga Springs Preservation Foundation’s YouTube channel. 

Middle: In 2020, Samantha giving Skip a Preservation Recognition Award for the restoration of the Katrina Trask Memorial Gateway.
Right: The ballroom of the Canfield Casino. Photos provided by the City of Saratoga Springs.  

8.113MBMemory Usage123msRequest 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" => "453" "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" => 1750125090 "last" => 1750125090...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.77ms)
  • afterInitialise (1.96MB) (30.96ms)
  • afterRoute (375.98KB) (5.36ms)
  • beforeRenderComponent com_content (50.08KB) (925μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.76ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.55ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (13μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (1.3ms)
  • Before Access::getAssetRules (id:618 name:com_content.article.453) (18.65KB) (27μs)
  • After Access::getAssetRules (id:618 name:com_content.article.453) (7.38KB) (87μs)
  • afterRenderComponent com_content (1.66MB) (49.42ms)
  • afterDispatch (21.42KB) (1.04ms)
  • beforeRenderRawModule mod_finder () (425.86KB) (10.76ms)
  • afterRenderRawModule mod_finder () (1.95MB) (5.73ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (65.44KB) (165μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (191μs)
  • afterRenderRawModule mod_menu () (56.49KB) (1.14ms)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (3.63KB) (117μs)
  • beforeRenderRawModule mod_custom () (920B) (68μs)
  • afterRenderRawModule mod_custom () (319.37KB) (1.08ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (57μs)
  • beforeRenderRawModule mod_menu () (24B) (92μs)
  • afterRenderRawModule mod_menu () (552B) (383μs)
  • beforeRenderModule mod_menu () (696B) (2μs)
  • afterRenderModule mod_menu () (2.76KB) (60μs)
  • beforeRenderRawModule mod_custom () (920B) (56μs)
  • afterRenderRawModule mod_custom () (1.03KB) (134μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (72μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (80μs)
  • afterRenderRawModule mod_menu () (4.45KB) (413μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (69μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (7.04KB) (526μs)
  • beforeRenderModule mod_finder () (704B) (3μs)
  • afterRenderModule mod_finder () (1.34KB) (74μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (150μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (56μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (150μs)
  • afterRenderRawModule mod_custom () (1008B) (124μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.77KB) (45μs)
  • beforeRenderRawModule mod_custom () (472B) (57μs)
  • afterRenderRawModule mod_custom () (1008B) (111μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (42μs)
  • afterRender (243.06KB) (3.45ms)
  • 1 x afterRenderComponent com_content (1.66MB) (40.15%)
    49.42ms
    1 x afterInitialise (1.96MB) (25.15%)
    30.96ms
    1 x beforeRenderRawModule mod_finder () (425.86KB) (8.74%)
    10.76ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (4.66%)
    5.73ms
    1 x afterRoute (375.98KB) (4.35%)
    5.36ms
    1 x afterLoad (444.73KB) (3.06%)
    3.77ms
    1 x afterRender (243.06KB) (2.81%)
    3.45ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.43%)
    1.76ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.26%)
    1.55ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.06%)
    1.30ms
    1 x afterRenderRawModule mod_menu () (56.49KB) (0.93%)
    1.14ms
    1 x afterRenderRawModule mod_custom () (319.37KB) (0.88%)
    1.08ms
    1 x afterDispatch (21.42KB) (0.84%)
    1.04ms
    1 x beforeRenderComponent com_content (50.08KB) (0.75%)
    925μs
    1 x afterRenderRawModule mod_finder () (7.04KB) (0.43%)
    526μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.34%)
    413μs
    1 x afterRenderRawModule mod_menu () (552B) (0.31%)
    383μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.19%)
    235μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.16%)
    191μs
    1 x afterRenderModule mod_finder () (65.44KB) (0.13%)
    165μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.12%)
    150μs
    1 x afterRenderRawModule mod_custom () (912B) (0.12%)
    150μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.11%)
    134μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.1%)
    128μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.1%)
    124μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.1%)
    117μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    92μs
    1 x After Access::getAssetRules (id:618 name:com_content.article.453) (7.38KB) (0.07%)
    87μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.07%)
    80μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.06%)
    74μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.06%)
    69μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.05%)
    60μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    57μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    57μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    45μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    42μs
    1 x Before Access::getAssetRules (id:618 name:com_content.article.453) (18.65KB) (0.02%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    13μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    13μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    8μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    7μs
54 statements were executed, 5 of which were duplicates, 49 unique12.21ms903.08KB
  • SELECT @@SESSION.sql_mode;100μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?164μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 180μ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)225μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`132μ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` = :guest206μ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"145μ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"81μ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"84μ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"62μ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"65μ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"98μ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"69μ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"64μ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"79μ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"65μ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"76μ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"64μ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"68μ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"61μ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"63μ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"61μ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"82μ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"88μ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"68μ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"63μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`615μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'103μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1151μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'244μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1126μ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)530μ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` = 0562μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.04ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '453'352μ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)494μs78.12KBParams/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`327μ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)280μ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`257μ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.34ms3.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`266μ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`854μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 120 AND `component_type` = "menu"204μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 453 AND `component_type` = "content"111μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1159μ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)143μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1323μ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 ASC288μ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)130μ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` = 1138μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?90μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?289μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy