Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"strafford-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
3	db.towns.find( {"sef_url":"hamilton-square-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/performance-disneys-frozen-2025-12-21-1-des-moines-ia.html"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
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":"7db22fb181168ab03184563d7ae2db1d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"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	87
8	db.events_cache.count( {"_id":"7db22fb181168ab03184563d7ae2db1d"} )	0	1
9	db.events_cache.count( {"_id":"7db22fb181168ab03184563d7ae2db1d"} )	0	1
10	db.events_cache.insert( {"_id":"7db22fb181168ab03184563d7ae2db1d","town_sef_url":"hamilton-square-nj","data_key":["6941a393de4ae56f5ac9a49b","685670d4fb5e4bed1f3b264a","69273783de4ae56f5a6b0dac","690cf933de4ae56f5a29ab56","690aed57de4ae56f5ae02141","68e00001c3af739f25d18731","69273784de4ae56f5a6b0e25","68f94be9c4766aed420deaa2","6857c25dfb5e4bed1f86ffd9","690cf933de4ae56f5a29ab73","68ae6c28c3af739f25a98977","69273784de4ae56f5a6b0e70","690cf933de4ae56f5a29ab97","69324210de4ae56f5af02a7c","685913aefb5e4bed1fd9a57d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hamilton Square Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"performance-disneys-frozen-2025-12-21-1-des-moines-ia.html\",\"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\":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.09600000 1765974451)","created":"MongoDate(0.09600000 1765974451)"} , true)	0	2
11	db.towns.find( {"sef_url":"hamilton-square-nj"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.tokens.find( {"sef_url":{"$in":["usa","nj","mercer-county-nj","hamilton-square-nj"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	21
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Hamilton Square

New Jersey

Hamilton Square Featured Events

Desmo Travel

Mill Creek Farm Farmers Market

Guided Wine Tasting Experience at Old York Cellars

Diggerland USA Holiday Light Show!

Kevin Devine

An American Christmas Songbook

Guided Wine Tasting Experience at Old York Cellars

An American Christmas Songbook

Fairmount Farmers Market

Diggerland USA Holiday Light Show!

WXPN Welcomes: Samantha Fish - Shake Em' On Down Tour

Guided Wine Tasting Experience at Old York Cellars

Diggerland USA Holiday Light Show!

Rider Broncs Womens Basketball vs. Fairfield University Stags Womens Basketball

Aaron Lewis & The Stateliners (21+ Event)

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