Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sunspot-nm"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"clayton-oh"}, [] ).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	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"4fc50a346d03ce15a58b478cf60aae51"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"ae33758ebd0fcf3f015e896355fa1b2d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)"},"geo":{"$geoWithin":{"$center":[[-84.36080169677734,39.86130142211914],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	166
9	db.events_cache.count( {"_id":"4fc50a346d03ce15a58b478cf60aae51"} )	0	1
10	db.events_cache.count( {"_id":"4fc50a346d03ce15a58b478cf60aae51"} )	0	1
11	db.events_cache.insert( {"_id":"4fc50a346d03ce15a58b478cf60aae51","town_sef_url":"clayton-oh","data_key":["68d74abec3af739f25e1ef97","68d74abec3af739f25e1efde","6927b614de4ae56f5a59f931","6927b614de4ae56f5a59f963","68d4a7a5c3af739f25451d40","6927b614de4ae56f5a59f979","6927b614de4ae56f5a59f9b5","68d4a7a5c3af739f25451da4","6927b614de4ae56f5a59f9ce","68d4a7a5c3af739f25451dcd","6927b614de4ae56f5a59fa04","6927b614de4ae56f5a59fa2d","6927b614de4ae56f5a59fa5d","68d74abec3af739f25e1f1cf","68a14ec5fb5e4bed1fa18a67"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clayton 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\":39.86130142211914,\"lng\":-84.36080169677734,\"latlng\":\"39.861301422119,-84.360801696777\",\"city\":\"Clayton\",\"state\":\"OH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.91700000 1769788777)","created":"MongoDate(0.91700000 1769788777)"} , true)	0	2
12	db.towns.find( {"sef_url":"clayton-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","oh","montgomery-county-oh","clayton-oh"]}}, [] ).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

Clayton

Ohio

Clayton Featured Events

Dayton Flyers Women's Basketball v. George Washington

Dayton Flyers Men's Basketball v. St. Bonaventure

Les Miserables (Touring)

Les Miserables (Touring)

Wright State Raiders Women's Basketball vs. Indiana-Purdue Fort Wayne Womens Basketball

Les Miserables (Touring)

Les Miserables (Touring)

Wright State Raiders Women's Basketball vs. IU Indianapolis Jaguars Women's Basketball

Les Miserables (Touring)

Wright State Raiders Mens Basketball vs. Indiana-Purdue Fort Wayne Mens Basketball

Les Miserables (Touring)

Les Miserables (Touring)

Les Miserables (Touring)

Dayton Flyers Women's Basketball v. George Mason

Launch Pad

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.

Clayton 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.