Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hamilton-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"hamilton-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
4	db.tokens.find( {"sef_url":{"$in":["usa","oh","butler-county-oh","hamilton-oh"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"afc0d092b08883a90084299643f18cd1"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"3ea017aaaaaa53c0699b035c2657d920"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events.count( {"address.town_sef_url":"hamilton-oh","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	3
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-84.5602035522461,39.39929962158203],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	33
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-84.5602035522461,39.39929962158203],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	1	40
10	db.events_radius_cache.count( {"_id":"3ea017aaaaaa53c0699b035c2657d920"} )	0	1
11	db.events_radius_cache.insert( {"_id":"3ea017aaaaaa53c0699b035c2657d920","radius":25,"modified":"MongoDate(0.36200000 1765779171)","created":"MongoDate(0.36200000 1765779171)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-84.5602035522461,39.39929962158203],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	56
13	db.events_cache.count( {"_id":"afc0d092b08883a90084299643f18cd1"} )	0	7
14	db.events_cache.count( {"_id":"afc0d092b08883a90084299643f18cd1"} )	0	1
15	db.events_cache.insert( {"_id":"afc0d092b08883a90084299643f18cd1","town_sef_url":"hamilton-oh","data_key":["68a75b5d03a70639b6cf04d8","69036add4389be6be5f5eb81","69036add4389be6be5f5ecec","68a75b5e03a70639b6cf0ac1","68a75b5e03a70639b6cf0be9","69036add4389be6be5f5eea7","68a75b5f03a70639b6cf0c85","69036add4389be6be5f5ef6b","69036ade4389be6be5f5f069","68a75b5f03a70639b6cf0db0","69036ade4389be6be5f5f17b","68a75b5f03a70639b6cf1093","68a75b6003a70639b6cf1451","68a75b6003a70639b6cf14f4","69036ade4389be6be5f5f57c"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hamilton 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.39929962158203,\"lng\":-84.5602035522461,\"latlng\":\"39.399299621582,-84.560203552246\",\"city\":\"Hamilton\",\"state\":\"OH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.46800000 1765779171)","created":"MongoDate(0.46800000 1765779171)"} , true)	0	2

Hamilton

Ohio

Hamilton Featured Events

Monday Karaoke + Industry Night @ MOTR Pub

Cincinnati Bearcats Women's Basketball vs. Howard Bison Women's Basketball

Hamilton (Touring)

Ornament Blow

Fort Thomas Farmers' Market

Xavier Musketeers Mens Basketball vs. Creighton Blue Jays Mens Basketball

Open Mic Show & Tell with Adam Flaig

Cincinnati Bearcats Mens Basketball vs. Alabama State Hornets Mens Basketball

Hamilton (Touring)

Irish Christmas in America

Cursive

Ornament Blow

Noah Smith's Crooner Circus

Dailey & Vincent

Hamilton (Touring)

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.

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