Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mc-lain-ms"}, [] ).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":"concord-nh"}, [] ).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":"concord-nh","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	9	2
7	db.events_cache.find( {"_id":"a1a683c4f5b07b653f4bd0bc550c6953"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"18f3760bc752a16592813e0d80a9c33e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765605600)"},"geo":{"$geoWithin":{"$center":[[-71.55970001220703,43.23139953613281],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	301
10	db.events_cache.count( {"_id":"a1a683c4f5b07b653f4bd0bc550c6953"} )	0	1
11	db.events_cache.count( {"_id":"a1a683c4f5b07b653f4bd0bc550c6953"} )	0	1
12	db.events_cache.insert( {"_id":"a1a683c4f5b07b653f4bd0bc550c6953","town_sef_url":"concord-nh","data_key":["68f14d5b69adceb60507b89c","68f13ae724609126960d8993","688889d4fb5e4bed1f8d082a","68db3f20c3af739f25853cab","68f393ddfd969f5f110551bd","68f3a0541f575976390b77f9","68fab4e21f575976390b781d","68fab69db71bc004bd06ba8f","68faadd352e740588700434c","68fab4e21f575976390b781e"],"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\":43.23139953613281,\"lng\":-71.55970001220703,\"latlng\":\"43.231399536133,-71.559700012207\",\"city\":\"Concord\",\"state\":\"NH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.51300000 1765689756)","created":"MongoDate(0.51300000 1765689756)"} , true)	0	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	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Concord

New Hampshire

Concord Groups and Organizations

Bishop Brady High School

Community College System of New Hampshire

Concord Public Library

Concord School District

Granite State College

Little Saints Christian School

New Hampshire Law Library

New Hampshire State Library

University of New Hampshire School of Law

Local Events

Spartan Winter Music Festival

3rd Annual Winter Wonderland Craft Market and Psychic Fair

PBR: Unleash the Beast

Jonas Brothers: JONAS20 Greetings From Your Hometown

Holiday Craft Fair

A Holiday Concert with Clay Cook

Encore of the Lights

Gift of Lights

A Christmas Carol

Encore of the Lights