Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"smyrna-ga"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"hampton-va"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"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.places.find( {"address.town_sef_url":"hampton-va","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	9	2
7	db.events_cache.find( {"_id":"30a6b75b5402adba2c43a3a86908ec1e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	14
8	db.events_radius_cache.find( {"_id":"56824fd2470ceec2d16588b9047703ee"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-76.36589813232422,37.05970001220703],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( 11 ).skip( 0 )	11	222
10	db.events_cache.count( {"_id":"30a6b75b5402adba2c43a3a86908ec1e"} )	0	16
11	db.events_cache.count( {"_id":"30a6b75b5402adba2c43a3a86908ec1e"} )	0	10
12	db.events_cache.insert( {"_id":"30a6b75b5402adba2c43a3a86908ec1e","town_sef_url":"hampton-va","data_key":["68f2cdb707edb82851099c21","68527c95fb5e4bed1f028516","68a5433dfb5e4bed1febbf64","68a5433dfb5e4bed1febbf92","68e5cb1ec3af739f25c775cd","68e0bd60c3af739f2576654d","693cce0fde4ae56f5ae975da","68fc349fc3af739f25225fa1","68fa44a16be57e660e0f24f4","68639fd9fb5e4bed1fa5b2b5"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":37.05970001220703,\"lng\":-76.36589813232422,\"latlng\":\"37.059700012207,-76.365898132324\",\"city\":\"Hampton\",\"state\":\"VA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.03200000 1765766680)","created":"MongoDate(0.03200000 1765766680)"} , true)	0	10
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	17
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	18
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11

Hampton

Virginia

Hampton Groups and Organizations

Bethel Manor Elementary School

Hampton City Schools

Hampton High School

Hampton Public Library

Hampton University

Northhampton Branch Library

Phoebus Branch Library

Thomas Nelson Community College

Willow Oaks Branch Library

Local Events

Grand Holiday Bazaar

Hampton Roads Philharmonic: HOLIDAY CLASSICS!

Virginia Symphony: PB&J Jingle Bell Jam

Virginia Symphony: Holiday Pops!

A Charlie Brown Christmas: The Music of Vince Guaraldi feat. R4ND4ZZO

late night drive home

Old Dominion Monarchs Womens Basketball vs. Troy Trojans Womens Basketball

Old Dominion Monarchs Mens Basketball vs. James Madison Dukes Mens Basketball

Whoville Christmas

Handel's Messiah with Eric Jacobsen