Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"union-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/keyshia-cole-the-way-it-is-20th-anniversary-tour-2026-01-16-tm-wallingford-ct.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
3	db.towns.find( {"sef_url":"union-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","sc","union-county-sc","union-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	13
5	db.events_cache.find( {"_id":"77dd148edb57a830af249f55d4f7876d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"8a14e5d682a2bb30eb201b52a5796ed3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"union-sc","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-81.6260986328125,34.72119903564453],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	34
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-81.6260986328125,34.72119903564453],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	31
10	db.events_radius_cache.count( {"_id":"8a14e5d682a2bb30eb201b52a5796ed3"} )	0	1
11	db.events_radius_cache.insert( {"_id":"8a14e5d682a2bb30eb201b52a5796ed3","radius":25,"modified":"MongoDate(0.09800000 1766325645)","created":"MongoDate(0.09800000 1766325645)"} , true)	0	4
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-81.6260986328125,34.72119903564453],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 )	16	287
13	db.events_cache.count( {"_id":"77dd148edb57a830af249f55d4f7876d"} )	0	1
14	db.events_cache.count( {"_id":"77dd148edb57a830af249f55d4f7876d"} )	0	26
15	db.events_cache.insert( {"_id":"77dd148edb57a830af249f55d4f7876d","town_sef_url":"union-sc","data_key":["69036b234389be6be5f7c1b8","69036b244389be6be5f7c634","69036b254389be6be5f7ccba","69036b264389be6be5f7d14f","69036b264389be6be5f7d42c","69036b264389be6be5f7d777","69036b274389be6be5f7dacf","69036b284389be6be5f7df2e","69036b294389be6be5f7e60a","69036b2e4389be6be5f805d8","69036b2f4389be6be5f8083b","69036b2f4389be6be5f80b16","69036b304389be6be5f80e0c","69036b304389be6be5f811d3","69036b314389be6be5f8175c"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Union Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"keyshia-cole-the-way-it-is-20th-anniversary-tour-2026-01-16-tm-wallingford-ct.html\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"max-days\":365,\"max-miles\":45,\"message\":\"[message to follow]\",\"min\":50,\"prompt\":\"\",\"height\":\"\",\"width\":\"\",\"data_id\":\"\",\"more\":true,\"type\":\"\",\"autoshowmore\":false,\"link\":\"\",\"showdesc\":\"\",\"rankby\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":34.72119903564453,\"lng\":-81.6260986328125,\"latlng\":\"34.721199035645,-81.626098632812\",\"city\":\"Union\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.44400000 1766325645)","created":"MongoDate(0.44400000 1766325645)"} , true)	0	2

Union

South Carolina

Union Featured Events

Hub City Spartanburgers

Hub City Spartanburgers

Hub City Spartanburgers

Hub City Spartanburgers vs. Greenville Drive

Hub City Spartanburgers vs. Greenville Drive

Hub City Spartanburgers vs. Greenville Drive

Hub City Spartanburgers vs. Greenville Drive

Hub City Spartanburgers vs. Greenville Drive

Hub City Spartanburgers vs. Greenville Drive

Hub City Spartanburgers vs. Winston-Salem Dash

Hub City Spartanburgers vs. Winston-Salem Dash

Hub City Spartanburgers vs. Winston-Salem Dash

Hub City Spartanburgers vs. Winston-Salem Dash

Hub City Spartanburgers vs. Winston-Salem Dash

Hub City Spartanburgers vs. Winston-Salem Dash

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 people
rely on AmericanTowns each year to find & share local information.

Union Featured Events

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.