Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"quinn-sd"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"gainesville-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	2
6	db.events_cache.find( {"_id":"c23674e5a287a2ab2e8c187ddec298c9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"31c774d070f913d880c9a67b671fbf97"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"gainesville-ga","start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770530400)"}} )	2	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-83.82969665527344,34.29399871826172],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} )	2	35
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-83.82969665527344,34.29399871826172],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} )	2	33
11	db.events_radius_cache.count( {"_id":"31c774d070f913d880c9a67b671fbf97"} )	0	1
12	db.events_radius_cache.count( {"_id":"31c774d070f913d880c9a67b671fbf97"} )	0	1
13	db.events_radius_cache.insert( {"_id":"31c774d070f913d880c9a67b671fbf97","radius":25,"modified":"MongoDate(0.99300000 1769955020)","created":"MongoDate(0.99300000 1769955020)"} , true)	0	2
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)"},"geo":{"$geoWithin":{"$center":[[-83.82969665527344,34.29399871826172],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	25
15	db.events_cache.count( {"_id":"c23674e5a287a2ab2e8c187ddec298c9"} )	0	1
16	db.events_cache.count( {"_id":"c23674e5a287a2ab2e8c187ddec298c9"} )	0	2
17	db.events_cache.insert( {"_id":"c23674e5a287a2ab2e8c187ddec298c9","town_sef_url":"gainesville-ga","data_key":["689965cffb5e4bed1f954443","693a6355de4ae56f5a0daf57","693a6356de4ae56f5a0db280","6901b2ddc3af739f25188ab5","68b0ef89c3af739f25a4de96","68b39288c3af739f2599180d","690c3edbde4ae56f5afba25d","68e8a660c3af739f255b9550","68d87c86c3af739f250fe761","68df1406c3af739f25e821b3","691427dcde4ae56f5a80e5aa","697976a1b1faf7c56a2a1c02","697976a1b1faf7c56a2a1c8e","697976a1b1faf7c56a2a1d12","6903fdf8de4ae56f5ab34629"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Gainesville 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.29399871826172,\"lng\":-83.82969665527344,\"latlng\":\"34.293998718262,-83.829696655273\",\"city\":\"Gainesville\",\"state\":\"GA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.07400000 1769955021)","created":"MongoDate(0.07400000 1769955021)"} , true)	0	2
18	db.towns.find( {"sef_url":"gainesville-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","ga","hall-county-ga","gainesville-ga"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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

Gainesville

Georgia

Gainesville Featured Events

Doug Stone

The Boss Project: A Bruce Springsteen Tribute

Randall King

Shelly Belly

Support Group For Families Living With Parkinson’s

Dementia Caregiver Support Group

Sister Hazel

Gregorian

Dementia Caregiver Support Group

Support Group For Families Living With Parkinson’s

End Of The Line

MotoAmerica

MotoAmerica

MotoAmerica

Support Group For Families Living With Parkinson’s

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.

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