Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"thompson-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"campbell-hall-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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":"c7fd54f5825a046bc57aa68a7bcb3a23"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"b6929d2a02b64811ee087f6ed60e69aa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-74.26270294189453,41.455501556396484],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	268
9	db.events_cache.count( {"_id":"c7fd54f5825a046bc57aa68a7bcb3a23"} )	0	1
10	db.events_cache.count( {"_id":"c7fd54f5825a046bc57aa68a7bcb3a23"} )	0	1
11	db.events_cache.insert( {"_id":"c7fd54f5825a046bc57aa68a7bcb3a23","town_sef_url":"campbell-hall-ny","data_key":["68dde220c3af739f25c56bae","6860fc97fb5e4bed1fe8c95f","686a3731fb5e4bed1fc011ef","6895714afb5e4bed1fd77276","68dde220c3af739f25c56f6b","686e2c04fb5e4bed1fcfb0cb","69351d54de4ae56f5ae250e9","68dde220c3af739f25c5706d","687371b4fb5e4bed1f4b6776","687e27a5fb5e4bed1f727d26","6895714afb5e4bed1fd774cd","69277742de4ae56f5aeaefbd","6895714afb5e4bed1fd774f3","68dde221c3af739f25c5741d","6885e69ffb5e4bed1feb4d2d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Campbell Hall 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\":41.455501556396484,\"lng\":-74.26270294189453,\"latlng\":\"41.455501556396,-74.262702941895\",\"city\":\"Campbell Hall\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.97800000 1766544993)","created":"MongoDate(0.97900000 1766544993)"} , true)	0	2
12	db.towns.find( {"sef_url":"campbell-hall-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ny","orange-county-ny","campbell-hall-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Campbell Hall

New York

Campbell Hall Featured Events

Army Black Knights Mens Basketball vs. Binghamton Bearcats Mens Basketball

Abbott House Foster Parent Orientation

Abbott House Foster Parent Orientation

Army Black Knights Hockey vs. Northeastern Huskies Hockey

Army Black Knights Mens Basketball vs. Colgate University Raiders Mens Basketball

Contact Improvisation

Tom Swoope

Army Black Knights Mens Basketball vs. Loyola Maryland Greyhounds Mens Basketball

Abbott House Foster Parent Orientation

Abbott House Foster Parent Orientation

Army Black Knights Hockey vs. Robert Morris Colonials Hockey

Let's Groove Tonight: The Nation's #1 Earth Wind & Fire Tribute Band

Army Black Knights Hockey vs. Robert Morris Colonials Hockey

Army Black Knights Mens Basketball vs. American University Eagles Mens Basketball

Abbott House Foster Parent Orientation

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.

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