Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mentor-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
3	db.towns.find( {"sef_url":"somerville-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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":"f6236073a54fe4a2220af318d7094c5b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"ca3bcfbcb876cd2ef3545cff3ff688bc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"somerville-al","start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768024800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-86.80249786376953,34.4723014831543],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	22
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-86.80249786376953,34.4723014831543],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767420000)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	23
11	db.events_radius_cache.count( {"_id":"ca3bcfbcb876cd2ef3545cff3ff688bc"} )	0	1
12	db.events_radius_cache.count( {"_id":"ca3bcfbcb876cd2ef3545cff3ff688bc"} )	0	1
13	db.events_radius_cache.insert( {"_id":"ca3bcfbcb876cd2ef3545cff3ff688bc","radius":25,"modified":"MongoDate(0.03200000 1767422027)","created":"MongoDate(0.03200000 1767422027)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767420000)"},"geo":{"$geoWithin":{"$center":[[-86.80249786376953,34.4723014831543],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	174
15	db.events_cache.count( {"_id":"f6236073a54fe4a2220af318d7094c5b"} )	0	1
16	db.events_cache.count( {"_id":"f6236073a54fe4a2220af318d7094c5b"} )	0	1
17	db.events_cache.insert( {"_id":"f6236073a54fe4a2220af318d7094c5b","town_sef_url":"somerville-al","data_key":["69251313de4ae56f5a252539","68df33a0c3af739f2509ece3","68db3f21c3af739f258543a2","690137d1c3af739f25a50755","69251313de4ae56f5a252540","69251313de4ae56f5a25254e","691bd894de4ae56f5a7c09c2","689ffd44fb5e4bed1f9564fb","6933cbd7de4ae56f5a4a6cc2","6874c341fb5e4bed1f570861","68761552fb5e4bed1f7bbd1b","689ffd44fb5e4bed1f95652e","68761557fb5e4bed1f7bc608","6877666ffb5e4bed1fb4d1dc","68776671fb5e4bed1fb4d672"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Somerville 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.4723014831543,\"lng\":-86.80249786376953,\"latlng\":\"34.472301483154,-86.80249786377\",\"city\":\"Somerville\",\"state\":\"AL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.25700000 1767422027)","created":"MongoDate(0.25700000 1767422027)"} , true)	0	1
18	db.towns.find( {"sef_url":"somerville-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","al","morgan-county-al","somerville-al"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Somerville

Alabama

Somerville Featured Events

Clayton English

The Ultimate Elvis Birthday Experience

Sweet Baby James: The #1 James Taylor Tribute

Sweet Baby James - The #1 James Taylor Tribute (Huntsville, AL)

Clayton English

Clayton English

Jim Parkers Songwriters Series

Huntsville Havoc vs. Evansville Thunderbolts

The Cleverlys

Hadestown (Touring)

Hadestown (Touring)

Huntsville Havoc vs. Evansville Thunderbolts

Hadestown (Touring)

Hadestown (Touring)

Hadestown (Touring)

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.

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