Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hamilton-square-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"hamilton-square-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.tokens.find( {"sef_url":{"$in":["usa","nj","mercer-county-nj","hamilton-square-nj"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
4	db.events_cache.find( {"_id":"43fb7e85fd633e7e11a383fe91b5a24f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
5	db.events_radius_cache.find( {"_id":"4a3f5fb3dc58629edf02526adaf2357a"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"hamilton-square-nj","start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.76419830322266,40.22019958496094],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	5	26
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-74.76419830322266,40.22019958496094],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	13	30
9	db.events_radius_cache.count( {"_id":"4a3f5fb3dc58629edf02526adaf2357a"} )	0	1
10	db.events_radius_cache.insert( {"_id":"4a3f5fb3dc58629edf02526adaf2357a","radius":25,"modified":"MongoDate(0.30200000 1766495142)","created":"MongoDate(0.30200000 1766495142)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-74.76419830322266,40.22019958496094],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	60
12	db.events_cache.count( {"_id":"43fb7e85fd633e7e11a383fe91b5a24f"} )	0	1
13	db.events_cache.count( {"_id":"43fb7e85fd633e7e11a383fe91b5a24f"} )	0	1
14	db.events_cache.insert( {"_id":"43fb7e85fd633e7e11a383fe91b5a24f","town_sef_url":"hamilton-square-nj","data_key":["69036ae54389be6be5f618bd","693321054389be6be5654a39","693321054389be6be5654b77","693321054389be6be5654bb7","693321054389be6be5654c83","693321054389be6be5654ca2","693321054389be6be5654d9a","69036ae64389be6be5f61efe","693321054389be6be5654df1","69036ae64389be6be5f62181","693321064389be6be56550e2","68a75b6a03a70639b6cf5086","69036ae74389be6be5f62564","69036ae84389be6be5f62834","693321064389be6be565553e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hamilton Square Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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\":40.22019958496094,\"lng\":-74.76419830322266,\"latlng\":\"40.220199584961,-74.764198303223\",\"city\":\"Hamilton Square\",\"state\":\"NJ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.41100000 1766495142)","created":"MongoDate(0.41100000 1766495142)"} , true)	0	1

Hamilton Square

New Jersey

Hamilton Square Featured Events
Arts And Entertainment

An American Christmas Songbook

Diggerland USA Holiday Light Show!

Guided Wine Tasting Experience at Old York Cellars

Diggerland USA Holiday Light Show!

Guided Wine Tasting Experience at Old York Cellars

Diggerland USA Holiday Light Show!

Guided Wine Tasting Experience at Old York Cellars

Holiday Light Show

Diggerland USA Holiday Light Show!

Buddy Fitzpatrick

Guided Wine Tasting Experience at Old York Cellars

Company Town Walking Tour

Holiday Light Show

Buddy Fitzpatrick

Guided Wine Tasting Experience at Old York Cellars

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 Square Featured EventsArts And Entertainment

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.

Hamilton Square Featured Events
Arts And Entertainment

20 million people
rely on AmericanTowns each year to find & share local information.