Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"rock-point-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"union-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
6	db.events_cache.find( {"_id":"d8da8e2e9c194a52679b777b44fedb5f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"8a14e5d682a2bb30eb201b52a5796ed3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765864800)"},"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	231
9	db.events_cache.count( {"_id":"d8da8e2e9c194a52679b777b44fedb5f"} )	0	1
10	db.events_cache.count( {"_id":"d8da8e2e9c194a52679b777b44fedb5f"} )	0	1
11	db.events_cache.insert( {"_id":"d8da8e2e9c194a52679b777b44fedb5f","town_sef_url":"union-sc","data_key":["68e1b706c3af739f2549d537","68e30881c3af739f2576918e","68e459fdc3af739f258c59a4","68e6fd02c3af739f25c7f433","68e84e81c3af739f25fa5a32","68e99ffec3af739f254af756","68eaf183c3af739f257ba593","68ec4301c3af739f25be47c3","68ed947ec3af739f25f75cfd","68f971fdc3af739f251215ea","68fac37fc3af739f25ba0e05","68fc14fec3af739f2504147a","68fd6681c3af739f2535f1cd","68feb800c3af739f25554b2d","6900097fc3af739f257c154b"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Union Featured Events\",\"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,\"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.49600000 1765895457)","created":"MongoDate(0.49600000 1765895457)"} , true)	0	1
12	db.towns.find( {"sef_url":"union-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
13	db.tokens.find( {"sef_url":{"$in":["usa","sc","union-county-sc","union-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

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

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

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.