Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"piedmont-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"piedmont-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","sc","greenville-county-sc","piedmont-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"9cb653b60b2e9e09078e179be2bd3dc4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"634e8bfe2392b39e5408ba7625c83eb0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
6	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767938400)","$lt":"MongoDate(0.00000000 1768197599)"},"geo":{"$geoWithin":{"$center":[[-82.46810150146484,34.709800720214844],0.36231884057971014]}}}, ["location_string","event_id","partner_id","address","sef_tail","tags","title","start","end","date_string","time_string","image_url","group_id","group_name","group_sef_tail","venue_name"] ).sort( {"start":1} ).limit( 16 ).skip( 0 )	5	9
7	db.events_cache.count( {"_id":"9cb653b60b2e9e09078e179be2bd3dc4"} )	0	1
8	db.events_cache.insert( {"_id":"9cb653b60b2e9e09078e179be2bd3dc4","town_sef_url":"piedmont-sc","data_key":["6933210a4389be6be565703d","69036aef4389be6be5f65597","69036af04389be6be5f65766","68a75b7103a70639b6cf804d","69036af04389be6be5f65b74"],"sort_order":{"start":1},"params":"{\"show\":15,\"type\":\"next-weekend\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"title\":\"{local_city} Events for 1\\\/9\\\/2026 to 1\\\/11\\\/2026\",\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"2026-01-09\",\"searchenddate\":\"2026-01-11\",\"lat\":34.709800720214844,\"lng\":-82.46810150146484,\"latlng\":\"34.709800720215,-82.468101501465\",\"city\":\"Piedmont\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.51300000 1767084637)","created":"MongoDate(0.51300000 1767084637)"} , true)	0	2

Piedmont Events for 1/9/2026 to 1/11/2026

Clemson University Tigers Women's Gymnastics vs. Alabama Crimson Tide Gymnastics

Harry Potter and the Goblet of Fire in Concert

Harry Potter and the Goblet of Fire in Concert

Greenville Swamp Rabbits vs. South Carolina Stingrays

Harry Potter and the Goblet of Fire in Concert

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.