Skip to main content

Resident companies
The Philadelphia Orchestra, New York City Ballet, Chamber Music Society of Lincoln Center, and a host of world-renowned guest artists visit the cultural hub of the Capital Region for this summer’s EARTH-themed festival.

The Saratoga Performing Arts Center is a unique eco-cultural destination, a perfect confluence of human-made and natural beauty, enriching the cultural life of the region from its home in the heart of Spa State Park. Nestled among the hiking trails, geysers, and natural mineral springs, SPAC draws hundreds of thousands of visitors each Summer seeking world class artistic experiences and performances by resident companies New York City Ballet, The Philadelphia Orchestra, Chamber Music Society of Lincoln Center, the Freihofer’s Saratoga Jazz Festival, and best-in-class artists across virtually all genres of music. 

Among the highlights of this year’s festival are performances from the full company of the New York City Ballet in works like Swan Lake, Fancy Free and Firebird, as well as Copland Dance Episodes, a new work by NYCB star choreographer Justin Peck and the return of their more intimate “behind the curtain” experiences, NYCB On and Off Stage; Music Director Yannick Nézet-Séguin leading The Philadelphia Orchestra and a diverse roster of guest artists including cellist Yo-Yo Ma, violinist Gil Shaham, Pink Martini, pianists Isata Kanneh-Mason and Bruce Liu, and Emmy, GRAMMY®-, and Tony Award-winning icon Audra McDonald; and the popular film nights as the orchestra plays live to picture Harry Potter and the Goblet of Fire™ and Jurassic Park.  SPAC’s 2023 festival theme of EARTH will be integrated throughout the summer season, highlighted by The Philadelphia Orchestra’s presentations of Earth: An HD Odyssey, the SPAC premiere of Pulitzer-Prize winning composer John Luther Adams’ Vespers of the Blessed Earth and Stravinsky’s famed The Rite of Spring. 

“Our 2023 EARTH theme will showcase iconic works and premieres that honor the planet and its awe-inspiring beauty, an homage to SPAC’s exquisite location in the natural world,” says Elizabeth Sobol, President and CEO of Saratoga Performing Arts Center. “SPAC is not just an amphitheater, SPAC is a refuge, a place of healing, a place where the experience of connection to people and planet is sparked by profound beauty.” 

New York City Ballet 
The more than 90 dancers of the New York City Ballet return July 18 – 22 under the direction of Artistic Director Jonathan Stafford and Associate Artistic Director Wendy Whelan, accompanied by the NYCB Orchestra and Music Director Andrew Litton. 

NYCB On and Off Stage
July 18, 7:30 p.m.
Hosted by NYCB dancers, this is a unique “behind the curtain” experience featuring excerpts from the week’s ballet with full orchestra and dancers. Following the program, newcomers and aficionados alike are invited to a celebratory dance party in the Hall of Springs. 

SPAC Premieres 
July 19 & 20, 7:30 p.m. 
NYCB performs four works highlighted by the music of Solange Knowles, James Blake, and Arvo Pärt: Gianna Reisen’s Play Time, Kyle Abraham’s Love Letter (on shuffle), and Christopher Wheeldon’s Liturgy make their SPAC premieres. Justin Peck’s Scherzo Fantastique returns for the first time since its World Premiere in 2016.   

Peck & Copland 
July 20, 2 p.m. & July 22, 7:30 p.m. 
Resident NYCB Choreographer Justin Peck goes all-in with Aaron Copland, featuring four of his most acclaimed musical scores: Appalachian Spring, Billy the Kid, Fanfare for the Common Man, and Four Dance Episodes from Rodeo, creating an original full-evening work in collaboration with painter and sculptor Jeffrey Gibson.  

Swan Lake, Fancy Free & Firebird 
July 21, 7:30 p.m. & July 22, 2 p.m. 
Get swept away into worlds of magic, beauty, and celebration with three renowned story ballets featuring the choreography of George Balanchine and Jerome Robbins. 

THE PHILADELPHIA ORCHESTRA
August 2 – August 19 
Music Director Yannick Nézet-Séguin leads The Philadelphia Orchestra in two performances during their three-week summer residency at SPAC: A Rachmaninoff 150th birthday celebration featuring the 2021 Chopin International Piano Competition winner Bruce Liu (August 11), and a performance of Stravinsky’s Rite of Spring and John Luther Adams’ Vespers of the Blessed Earth, which includes the SPAC debut of Philadelphia-based choral group

The Crossing (August 12). 

Festive Fireworks 
August 2, 7:30 p.m. 
The Philadelphia Orchestra kicks off its summer residency showcasing concertmaster David Kim in a dazzling evening of Tchaikovsky, including the 
return of the 1812 Overture with live canon fire and a brilliant fireworks display. Making his SPAC debut for opening night is conductor Fabio Luisi, music director of the Dallas Symphony Orchestra.   

Schubert’s “Great” Symphony 
August 3, 7:30 p.m. 
Along with Schubert’s “Great” Symphony No. 9, pianist Isata Kannah-Mason makes her SPAC and Philadelphia Orchestra debut playing Mendelssohn’s Piano Concerto No. 1.  

Pink Martini and The Philadelphia Orchestra featuring China Forbes 
August 4, 7:30 p.m
Enrico Lopez-Yañez conducts as “little orchestra” Pink Martini joins The Philadelphia Orchestra for a night of world music spanning jazz to classical to vintage pop. Members of the Hollywood Bowl Hall of Fame, Pink Martini draws musical inspiration from across the globe, having performed on six continents and in over 25 languages.  

Beethoven’s Seventh 
August 9, 7:30 p.m. 
In an evening of classical favorites, Roderick Cox, 2018 winner of the Sir Georg Solti Conducting Award, makes his SPAC debut conducting Beethoven’s jubilant and exhilarating Symphony No. 7. Following is Mozart’s 
Oboe Concerto, played by Philippe Tondre. 

(left) Audra McDonald. Photo © Allison Michael Orenstein
(right) Gil Shaham. Photo © Chris Lee

An Evening with Audra McDonald 
August 10, 7:30 p.m. 

Andy Einhorn conducts The Philadelphia Orchestra and Emmy, GRAMMY®, and six-time Tony Award-winning icon Audra McDonald for a night of Broadway favorites by Rodgers and Hammerstein, George Gershwin, and Stephen Sondheim. The star of CBS’s The Good Fight and HBO’s The Gilded Age, McDonald was a recipient of the National Medal of the Arts from President Barack Obama and was named one of Time magazine’s 100 Most Influential People in 2015.   

The Four Seasons with Gil Shaham 
August 16, 7:30 p.m. 

One of the world’s great violinists, Gil Shaham returns to SPAC for the first time in a decade. Pulling double-duty, Shaham will lead the orchestra and perform as soloist in a special program of SPAC premieres, featuring Vivaldi’s iconic Four Seasons and Saint-Georges Violin Concerto No. 9 in G Major. 

Yo-Yo Ma Plays Dvořák 
August 17, 7:30 p.m. 

World renowned cellist Yo-Yo Ma returns to SPAC to perform Dvořák’s cello concerto, one of the most technically challenging pieces and a crown jewel of the repertoire. The evening begins with Prokofiev’s Symphony No. 5, led by conductor, Xian Zhang, making her SPAC debut. 

EARTH: An HD Odyssey 
August 18, 7:30 p.m. 
In celebration of this year’s festival theme, The Philadelphia Orchestra under the baton of Edwin Outwater performs Earth: An HD Odyssey, featuring ravishing images of our planet on a large LED screen, set to the music of John Adams and Richard Strauss. The opening notes of Strauss’s Also sprach Zarathustra are recognizable by anyone who has seen

2001: A Space Odyssey! 

FILM NIGHTS 
SPAC’s popular film nights return to delight audiences of all ages as The Philadelphia Orchestra accompanies, live to picture, Harry Potter and the Goblet of Fire™ in Concert (Aug 5) and Jurassic Park in Concert (Aug 19), celebrating the 30th anniversary of the film.          

CHAMBER MUSIC SOCIETY OF LINCOLN CENTER 
May 13 – August 20 
CMS is back this summer celebrating a decade of partnership with SPAC. Their 10th anniversary in residence opens with “From Classic to Modern,” showcasing works from Brahms and Beethoven to Bloch, Khachaturian and Milhaud (June 11), followed by “Great Quintets” of Mozart, Dohnányi and Dvořák (June 18); “From Vienna to Paris” (July 16); a program from guest artists The Miró String Quartet (July 23); and “Spanish Journey” (August 13). The season closes with “New Classics” (August 20), which includes quintets by Bloch and Suk that CMS has ushered into the standard chamber repertoire.  

Anchored by CMS Artistic Directors Wu Han (piano) and David Finckel (cello), this season’s guest artists also include violinists Arnaud Sussmann, Alexander Sitkovetsky, Ani Kavafian, Ida Kavafian, Stella Chen, Danbi Um, Kristin Lee, and Aaron Boyd; violists Paul Neubauer, James Thompson, Molly Carr, and Matthew Lipman; cellist Sihao He, pianists Wu Qian, Juho Pohjonen, Soyeon Kate Lee; clarinetist Ricardo Morales, guitarist Jason Vieaux, soprano Rihab Chaieb, and The Miró Quartet. 

Visit SPAC.org for full season schedule and tickets.

8.034MBMemory Usage149msRequest 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" => "11" "id" => "535" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746986924 "last" => 1746986924...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.73KB) (3.81ms)
  • afterInitialise (1.96MB) (32.89ms)
  • afterRoute (374.59KB) (7.51ms)
  • beforeRenderComponent com_content (48.95KB) (1.38ms)
  • Before Access::preloadComponents (all components) (43.72KB) (2.36ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.4ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (22μs)
  • After Access::preloadPermissions (com_content) (507.06KB) (1.42ms)
  • Before Access::getAssetRules (id:705 name:com_content.article.535) (18.65KB) (60μs)
  • After Access::getAssetRules (id:705 name:com_content.article.535) (11.38KB) (127μs)
  • afterRenderComponent com_content (1.69MB) (59.22ms)
  • afterDispatch (29.42KB) (1.36ms)
  • beforeRenderRawModule mod_menu () (396.2KB) (14.21ms)
  • afterRenderRawModule mod_menu () (13.13KB) (1.19ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.73KB) (207μs)
  • beforeRenderRawModule mod_finder () (1.45KB) (11μs)
  • afterRenderRawModule mod_finder () (1.95MB) (9.56ms)
  • beforeRenderModule mod_finder () (704B) (10μs)
  • afterRenderModule mod_finder () (2.82KB) (161μs)
  • beforeRenderRawModule mod_custom () (16B) (263μs)
  • afterRenderRawModule mod_custom () (320.14KB) (1.94ms)
  • beforeRenderModule mod_custom () (704B) (5μs)
  • afterRenderModule mod_custom () (3.27KB) (84μs)
  • beforeRenderRawModule mod_menu () (24B) (106μs)
  • afterRenderRawModule mod_menu () (552B) (572μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (65μs)
  • beforeRenderRawModule mod_custom () (920B) (60μs)
  • afterRenderRawModule mod_custom () (1.03KB) (157μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (66μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (130μs)
  • afterRenderRawModule mod_menu () (4.45KB) (457μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (1.34KB) (74μs)
  • beforeRenderRawModule mod_finder () (96B) (9μs)
  • afterRenderRawModule mod_finder () (7.32KB) (749μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (86μs)
  • beforeRenderRawModule mod_custom () (288B) (10μs)
  • afterRenderRawModule mod_custom () (912B) (139μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (5.95KB) (169μs)
  • afterRenderRawModule mod_custom () (1008B) (144μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (46μs)
  • beforeRenderRawModule mod_custom () (8B) (57μs)
  • afterRenderRawModule mod_custom () (1008B) (114μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (49μs)
  • afterRender (314.95KB) (4.68ms)
  • 1 x afterRenderComponent com_content (1.69MB) (39.84%)
    59.22ms
    1 x afterInitialise (1.96MB) (22.13%)
    32.89ms
    1 x beforeRenderRawModule mod_menu () (396.2KB) (9.56%)
    14.21ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (6.43%)
    9.56ms
    1 x afterRoute (374.59KB) (5.05%)
    7.51ms
    1 x afterRender (314.95KB) (3.15%)
    4.68ms
    1 x afterLoad (444.73KB) (2.56%)
    3.81ms
    1 x Before Access::preloadComponents (all components) (43.72KB) (1.59%)
    2.36ms
    1 x afterRenderRawModule mod_custom () (320.14KB) (1.3%)
    1.94ms
    1 x After Access::preloadPermissions (com_content) (507.06KB) (0.96%)
    1.42ms
    1 x After Access::preloadComponents (all components) (116.7KB) (0.94%)
    1.40ms
    1 x beforeRenderComponent com_content (48.95KB) (0.93%)
    1.38ms
    1 x afterDispatch (29.42KB) (0.91%)
    1.36ms
    1 x afterRenderRawModule mod_menu () (13.13KB) (0.8%)
    1.19ms
    1 x afterRenderRawModule mod_finder () (7.32KB) (0.5%)
    749μs
    1 x afterRenderRawModule mod_menu () (552B) (0.38%)
    572μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.31%)
    457μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.18%)
    263μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.17%)
    258μs
    1 x afterRenderModule mod_menu () (3.73KB) (0.14%)
    207μs
    1 x beforeRenderRawModule mod_custom () (5.95KB) (0.11%)
    169μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.11%)
    161μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.11%)
    157μs
    1 x afterRenderRawModule mod_custom () (912B) (0.09%)
    139μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.09%)
    130μs
    1 x After Access::getAssetRules (id:705 name:com_content.article.535) (11.38KB) (0.09%)
    127μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.08%)
    121μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    106μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.06%)
    86μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.06%)
    84μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.05%)
    74μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.04%)
    65μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.04%)
    60μs
    1 x Before Access::getAssetRules (id:705 name:com_content.article.535) (18.65KB) (0.04%)
    60μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.04%)
    57μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.03%)
    49μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    46μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    22μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    17μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    14μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_finder () (1.45KB) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    9μs
53 statements were executed, 5 of which were duplicates, 48 unique15.25ms922.27KB
  • SELECT @@SESSION.sql_mode;124μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?160μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 160μ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)232μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`124μ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` = :guest250μ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"174μ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"71μ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"58μs1.13KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jomclassifieds" AND e.type = "component"56μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_hikashop" AND e.type = "component"55μ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"67μ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"112μ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"60μ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"56μ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"58μ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"59μ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"59μ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"60μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_djclassifieds" AND e.type = "component"56μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"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"73μ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"57μ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`609μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'82μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1334μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'152μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1132μ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)473μ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` = 0557μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`958μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '535'355μ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)557μ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`361μ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)269μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`277μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC335μ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 DESC2.98ms41.72KBParams/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`593μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 119 AND `component_type` = "menu"625μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 535 AND `component_type` = "content"203μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1424μ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)326μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1889μ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 ASC554μ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)249μ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` = 1193μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?100μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?294μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy