Meet the Members of the Orchestra : Cape Ann Symphony

Meet the Orchestra

Violin I

Alan Hawryluk, Helen Gordon chair, Concertmaster
David Rubin
Oksana Gorokhovskiy
Olga Kradenova
Lyudmila Maslyakova
Anthony Morales
Joanne Sadler
Sarah Skinner
Judy Takata

Violin II

Susanne Powers, principal
Shadwa Mussad
Nivedita Sarnath
Margaret Leddy
Eric Mrugala
Emily Mullaney
Stephanie Skor
Oliver Klein

Viola

Rebecca Hallowell, principal
Carrol Lee
Min Choi
Lu Yu
Evan Perry
Stephen Grasberger
Emma Lemeshova

Cello

Scott Lesser, principal
Mary-Jane Febonio, co-principal, principal
Meredith Browne
Cheryl Campbell
Simon Linn-Gerstein
Laura Messina
Timothy Paek
Robert Cornell

Double Bass

Richey Tally, principal
Stephen Clark
Lello Molinari
Kyle Olmstead

Flute

Stephanie Stathos, principal
Barbara Clement
Meghan Jacoby, piccolo

Oboe

Izumi Sakamoto, principal
Jessica Warren

Clarinet

William Kirkley, principal
Marguerite Levin

Bassoon

Becky McCatty, principal
Margaret Hook

French Horn

Janet Harrison, principal
Amelia Careghini
Sarah Sutherland
Derek Lewis

Trumpet

Matt Repucci, principal, Helen Gordon chair
Kyle Spraker
Ryan Noe

Trombone

Justin Callahan, principal
Joseph Walsh

Bass Trombone

Dan Walker, principal

Tuba

Michael Stephan, principal

Timpani

Mark Pilkanis, principal

Time	Δ	Debug Message - Perch Runway 3.1.2
0.0016	0	[43] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
0.005	0.0033	Matched page: /about/orchestra, so not using routes.
0.005	0	Using master page: /templates/pages/orchestra.php
0.0051	0.0001	[1] SELECT * FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1
0.0059	0.0008	[68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.0066	0.0007	[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.0069	0.0002	INSERT INTO perch2_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',142,'standard','[]')
0.0077	0.0008	[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384
0.008	0.0003	[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384
0.0083	0.0003	[nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 17:14:00' AND saleTo>'2026-01-12 17:14:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
0.0093	0.001	[6] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/about/orchestra' OR regionPage='*' ORDER BY regionPage DESC
0.0099	0.0006	Using template: /templates/pages/attributes/default.html
0.0101	0.0002	Using sub-template: /templates/pages/attributes/seo.html
0.0102	0.0001	Using sub-template: /templates/pages/attributes/facebook.html
0.0103	0.0001	Using sub-template: /templates/pages/attributes/twitter.html
0.0104	0.0001	Using sub-template: /templates/pages/attributes/page_settings.html
0.0114	0.001	[15] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/') OR (idx.indexKey='_category' AND idx.indexValue LIKE 'products/2019-musicians-unleashed/%' OR idx.indexKey='_category' AND idx.indexValue='products/2019-musicians-unleashed/'))
0.0129	0.0015	[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main., idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('433', '436', '439', '229', '102', '106', '84', '95', '230', '231', '232', '550', '536', '541', '563') WHERE 1=1 AND ((idx.indexKey='sell_until' AND idx.indexValue >= '2026-01-12 12:14:17') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 12:14:17')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval HAVING count()=2 ORDER BY sortval ASC
0.0175	0.0047	Using template: /templates/shop/products/products_navigation.html
0.0177	0.0002	[15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
0.0183	0.0006	[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1
0.0186	0.0003	[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-002-006', '000-002', '000') ORDER BY pageTreePosition DESC
0.019	0.0004	Using template: /templates/navigation/navigation-main.html
0.0191	0.0001	[7] Using template: /templates/navigation/navigation-main-2.html
0.0212	0.0021	------------------------------ Calculating cart ------------------------------
0.0212	0	[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384
0.0218	0.0006	[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384
0.0222	0.0004	[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.0226	0.0004	[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.0228	0.0003	[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.0232	0.0003	[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
0.0235	0.0004	[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1020384
0.0242	0.0006	Tax mode: exc
0.0242	0	[nil] SELECT * FROM perch2_shop_cart_items WHERE cartID=1020384 ORDER BY itemID ASC
0.0247	0.0005	Using template: /templates/shop/cart/mini.html
0.0251	0.0004	[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Orchestra Members' AND (regionPage='/about/orchestra' OR regionPage='*')
0.0256	0.0005	[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=34 AND idx.itemRev=20)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.0277	0.0021	[1] Using template: /templates/content/_orchestra_members.html
0.0346	0.007	[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' OR pageSortPath='/about/orchestra' LIMIT 1
0.0352	0.0005	[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageID=31 LIMIT 1
0.0355	0.0003	[8] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
0.0362	0.0007	[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1
0.0366	0.0004	[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-002-006', '000-002', '000') ORDER BY pageTreePosition DESC
0.0371	0.0006	[7] Using template: /templates/navigation/section_menu.html
0.0378	0.0007	[12] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
0.0392	0.0013	[8] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='product_order' AND idx.itemID IN ('229', '102', '106', '84', '95', '230', '231', '232', '550', '536', '541', '563') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
0.0471	0.0079	[8] Using template: /templates/shop/products/concert_blocks_sidebar_notext.html
0.0476	0.0005	[12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0488	0.0012	[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0494	0.0006	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0497	0.0003	[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0502	0.0005	[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0504	0.0002	[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0509	0.0004	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0511	0.0002	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.0515	0.0004	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0519	0.0004	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0524	0.0005	[4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=536 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0526	0.0003	[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=536 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0529	0.0003	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0531	0.0002	[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='536' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0537	0.0006	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.054	0.0003	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0548	0.0007	[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0553	0.0005	[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0557	0.0004	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0561	0.0004	[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0567	0.0006	[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.057	0.0003	[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0577	0.0007	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.058	0.0003	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0586	0.0006	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0594	0.0008	[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0599	0.0005	[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0603	0.0005	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0607	0.0003	[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0613	0.0006	[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0616	0.0003	[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0623	0.0007	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0626	0.0003	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0632	0.0006	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.064	0.0008	[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=229 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0646	0.0006	[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=229 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.065	0.0004	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0654	0.0004	[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='229' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.066	0.0006	[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=13 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0663	0.0003	[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='229' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='13' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.067	0.0007	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0673	0.0003	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0679	0.0005	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.0686	0.0008	[12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=230 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0693	0.0007	[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=230 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0697	0.0004	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0701	0.0003	[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='230' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0707	0.0006	[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=14 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.071	0.0003	[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='230' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='14' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0717	0.0007	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0721	0.0004	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.0727	0.0006	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0733	0.0006	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0741	0.0008	[4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=231 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0748	0.0007	[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=231 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0753	0.0005	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0756	0.0003	[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='231' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0763	0.0007	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0766	0.0003	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0773	0.0007	[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=232 AND productDeleted IS NULL ORDER BY productOrder ASC
0.0779	0.0005	[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=232 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
0.0783	0.0005	[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0787	0.0003	[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='232' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0794	0.0007	[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=15 AND valueDeleted IS NULL ORDER BY valueOrder ASC
0.0797	0.0003	[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='232' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='15' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
0.0804	0.0007	[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1
0.0808	0.0003	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22
0.0813	0.0005	[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23
0.0823	0.001	[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/about/orchestra' OR regionPage='*')
0.0826	0.0003	[10] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=18 AND idx.itemRev=24)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.0885	0.0059	[10] Using template: /templates/content/sponsors/_footer_logos.html
0.0901	0.0016	Using template: /templates/mailchimp/subscribe_email_address.html
0.0908	0.0007	[7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
0.0913	0.0005	[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1
0.0917	0.0005	[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-002-006', '000-002', '000') ORDER BY pageTreePosition DESC
0.0924	0.0006	[7] Using template: /templates/navigation/navigation-footer.html
0.0926	0.0003	Using cart from cache.
0.0927	0	Using template: /templates/shop/cart/your_cart.html
0.0928	0.0001	[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/about/orchestra' OR regionPage='*')
0.0931	0.0004	[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.0955	0.0024	[1] Using template: /templates/content/globals/_phone_number.html
0.0956	0.0001	[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.0971	0.0015	[1] Using template: /templates/content/globals/_email_address_main.html
0.0974	0.0003	[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.0991	0.0016	[1] Using template: /templates/content/globals/_social_footer.html
0.0995	0.0004	[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/about/orchestra' OR regionPage='*')
0.0999	0.0004	[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=81 AND idx.itemRev=4)) AND ((idx.indexKey='start_date' AND idx.indexValue <= '2026-01-12 12:14:17') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 12:14:17') OR (idx.indexKey='showModal' AND idx.indexValue='true')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID HAVING count(*)=3 ORDER BY sortval ASC
0.1011	0.0012	Using template: /templates/content/messages/_modal.html
0.1013	0.0002	[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=81 AND idx.itemRev=4)) AND ((idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.1021	0.0009	Using template: /templates/content/messages/_message_output.html
0.1023	0.0001	Request time: 0.1023
0.1023	0	Process time: 0.1021
0.1023	0	Memory: 1.4635
0.1023	0	Array ( [type] => 8192 [message] => implode(): Passing glue string after array is deprecated. Swap the parameters [file] => /home/capeannsymphony/dev.capeannsymphony.org/perch/core/apps/content/PerchContent.class.php [line] => 352 )

Time

Debug Message - Perch Runway 3.1.2

0.0016

[43] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC

0.005

0.0033

Matched page: /about/orchestra, so not using routes.

0.005

Using master page: /templates/pages/orchestra.php

0.0051

0.0001

[1] SELECT * FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1

0.0059

0.0008

[68] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0

0.0066

0.0007

[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1

0.0069

0.0002

INSERT INTO perch2_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',142,'standard','[]')

0.0077

0.0008

[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384

0.008

0.0003

[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384

0.0083

0.0003

[nil] SELECT * FROM perch2_shop_sales WHERE saleFrom<='2026-01-12 17:14:00' AND saleTo>'2026-01-12 17:14:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC

0.0093

0.001

[6] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/about/orchestra' OR regionPage='*' ORDER BY regionPage DESC

0.0099

0.0006

Using template: /templates/pages/attributes/default.html

0.0101

0.0002

Using sub-template: /templates/pages/attributes/seo.html

0.0102

0.0001

Using sub-template: /templates/pages/attributes/facebook.html

0.0103

0.0001

Using sub-template: /templates/pages/attributes/twitter.html

0.0104

0.0001

Using sub-template: /templates/pages/attributes/page_settings.html

0.0114

0.001

[15] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/') OR (idx.indexKey='_category' AND idx.indexValue LIKE 'products/2019-musicians-unleashed/%' OR idx.indexKey='_category' AND idx.indexValue='products/2019-musicians-unleashed/'))

0.0129

0.0015

[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='sell_until' AND idx.itemID IN ('433', '436', '439', '229', '102', '106', '84', '95', '230', '231', '232', '550', '536', '541', '563') WHERE 1=1 AND ((idx.indexKey='sell_until' AND idx.indexValue >= '2026-01-12 12:14:17') OR (idx.indexKey='sell_from' AND idx.indexValue <= '2026-01-12 12:14:17')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval HAVING count(*)=2 ORDER BY sortval ASC

0.0175

0.0047

Using template: /templates/shop/products/products_navigation.html

0.0177

0.0002

[15] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC

0.0183

0.0006

[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1

0.0186

0.0003

[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-002-006', '000-002', '000') ORDER BY pageTreePosition DESC

0.019

0.0004

Using template: /templates/navigation/navigation-main.html

0.0191

0.0001

[7] Using template: /templates/navigation/navigation-main-2.html

0.0212

0.0021

------------------------------ Calculating cart ------------------------------

0.0212

[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384

0.0218

0.0006

[1] SELECT * FROM perch2_shop_cart WHERE cartID=1020384

0.0222

0.0004

[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1

0.0226

0.0004

[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1

0.0228

0.0003

[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1

0.0232

0.0003

[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1

0.0235

0.0004

[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=1020384

0.0242

0.0006

Tax mode: exc

0.0242

[nil] SELECT * FROM perch2_shop_cart_items WHERE cartID=1020384 ORDER BY itemID ASC

0.0247

0.0005

Using template: /templates/shop/cart/mini.html

0.0251

0.0004

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Orchestra Members' AND (regionPage='/about/orchestra' OR regionPage='*')

0.0256

0.0005

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=34 AND idx.itemRev=20)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

0.0277

0.0021

[1] Using template: /templates/content/_orchestra_members.html

0.0346

0.007

[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' OR pageSortPath='/about/orchestra' LIMIT 1

0.0352

0.0005

[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pageID=31 LIMIT 1

0.0355

0.0003

[8] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC

0.0362

0.0007

[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1

0.0366

0.0004

[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-002-006', '000-002', '000') ORDER BY pageTreePosition DESC

0.0371

0.0006

[7] Using template: /templates/navigation/section_menu.html

0.0378

0.0007

[12] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'products/subscription-concert/%' OR idx.indexKey='_category' AND idx.indexValue='products/subscription-concert/')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1

0.0392

0.0013

[8] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='product_order' AND idx.itemID IN ('229', '102', '106', '84', '95', '230', '231', '232', '550', '536', '541', '563') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC

0.0471

0.0079

[8] Using template: /templates/shop/products/concert_blocks_sidebar_notext.html

0.0476

0.0005

[12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=550 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0488

0.0012

[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=550 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0494

0.0006

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0497

0.0003

[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0502

0.0005

[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=20 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0504

0.0002

[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='550' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='20' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0509

0.0004

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.0511

0.0002

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23

0.0515

0.0004

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0519

0.0004

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0524

0.0005

[4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=536 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0526

0.0003

[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=536 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0529

0.0003

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0531

0.0002

[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='536' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0537

0.0006

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.054

0.0003

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0548

0.0007

[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=541 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0553

0.0005

[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=541 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0557

0.0004

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0561

0.0004

[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0567

0.0006

[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=22 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.057

0.0003

[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='541' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='22' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0577

0.0007

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.058

0.0003

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0586

0.0006

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0594

0.0008

[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=563 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0599

0.0005

[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=563 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0603

0.0005

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0607

0.0003

[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0613

0.0006

[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=19 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0616

0.0003

[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='563' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='19' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0623

0.0007

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.0626

0.0003

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0632

0.0006

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23

0.064

0.0008

[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=229 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0646

0.0006

[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=229 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.065

0.0004

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0654

0.0004

[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='229' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.066

0.0006

[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=13 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0663

0.0003

[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='229' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='13' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.067

0.0007

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.0673

0.0003

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0679

0.0005

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23

0.0686

0.0008

[12] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=230 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0693

0.0007

[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=230 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0697

0.0004

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0701

0.0003

[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='230' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0707

0.0006

[3] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=14 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.071

0.0003

[3] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='230' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='14' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0717

0.0007

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.0721

0.0004

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23

0.0727

0.0006

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0733

0.0006

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0741

0.0008

[4] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=231 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0748

0.0007

[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=231 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0753

0.0005

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0756

0.0003

[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='231' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0763

0.0007

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.0766

0.0003

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0773

0.0007

[8] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=232 AND productDeleted IS NULL ORDER BY productOrder ASC

0.0779

0.0005

[2] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=232 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC

0.0783

0.0005

[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=9 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0787

0.0003

[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='232' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='9' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0794

0.0007

[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=15 AND valueDeleted IS NULL ORDER BY valueOrder ASC

0.0797

0.0003

[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='232' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='15' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC

0.0804

0.0007

[1] SELECT * FROM perch2_collections WHERE collectionKey='Venues' LIMIT 1

0.0808

0.0003

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=22

0.0813

0.0005

[1] SELECT * FROM perch2_collection_items ci, perch2_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=3 AND ci.itemRev=r.itemRev AND ci.itemID=23

0.0823

0.001

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Sponsors' AND (regionPage='/about/orchestra' OR regionPage='*')

0.0826

0.0003

[10] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=18 AND idx.itemRev=24)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

0.0885

0.0059

[10] Using template: /templates/content/sponsors/_footer_logos.html

0.0901

0.0016

Using template: /templates/mailchimp/subscribe_email_address.html

0.0908

0.0007

[7] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC

0.0913

0.0005

[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/about/orchestra' LIMIT 1

0.0917

0.0005

[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-002-006', '000-002', '000') ORDER BY pageTreePosition DESC

0.0924

0.0006

[7] Using template: /templates/navigation/navigation-footer.html

0.0926

0.0003

Using cart from cache.

0.0927

Using template: /templates/shop/cart/your_cart.html

0.0928

0.0001

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Globals' AND (regionPage='/about/orchestra' OR regionPage='*')

0.0931

0.0004

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

0.0955

0.0024

[1] Using template: /templates/content/globals/_phone_number.html

0.0956

0.0001

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

0.0971

0.0015

[1] Using template: /templates/content/globals/_email_address_main.html

0.0974

0.0003

[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=21 AND idx.itemRev=8)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

0.0991

0.0016

[1] Using template: /templates/content/globals/_social_footer.html

0.0995

0.0004

[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Messages' AND (regionPage='/about/orchestra' OR regionPage='*')

0.0999

0.0004

[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=81 AND idx.itemRev=4)) AND ((idx.indexKey='start_date' AND idx.indexValue <= '2026-01-12 12:14:17') OR (idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 12:14:17') OR (idx.indexKey='showModal' AND idx.indexValue='true')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID HAVING count(*)=3 ORDER BY sortval ASC

0.1011

0.0012

Using template: /templates/content/messages/_modal.html

0.1013

0.0002

[nil] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=81 AND idx.itemRev=4)) AND ((idx.indexKey='show_until' AND idx.indexValue >= '2026-01-12 23:59:59')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC

0.1021

0.0009

Using template: /templates/content/messages/_message_output.html

0.1023

0.0001

Request time: 0.1023

0.1023

Process time: 0.1021

0.1023

Memory: 1.4635

0.1023

Array
(
    [type] => 8192
    [message] => implode(): Passing glue string after array is deprecated. Swap the parameters
    [file] => /home/capeannsymphony/dev.capeannsymphony.org/perch/core/apps/content/PerchContent.class.php
    [line] => 352
)

Meet the Orchestra

Violin I

Violin II

Viola

Cello

Double Bass

Flute

Oboe

Clarinet

Bassoon

French Horn

Trumpet

Trombone

Bass Trombone

Tuba

Timpani

Menu

Upcoming Concerts