Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"pitkin-co"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"springfield-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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":"springfield-ma","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	13
7	db.events_cache.find( {"_id":"a7f513877b8cbd441baa21b864003a2e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"268e3ea5313299de9f9ebc68d628c3c4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1770012000)"},"geo":{"$geoWithin":{"$center":[[-72.58509826660156,42.10260009765625],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	34
10	db.events_cache.count( {"_id":"a7f513877b8cbd441baa21b864003a2e"} )	0	1
11	db.events_cache.count( {"_id":"a7f513877b8cbd441baa21b864003a2e"} )	0	1
12	db.events_cache.insert( {"_id":"a7f513877b8cbd441baa21b864003a2e","town_sef_url":"springfield-ma","data_key":["68e5cb20c3af739f25c786b4","6979769db1faf7c56a2a0509","693a6355de4ae56f5a0dae0e","68d4dfe7c3af739f258d98eb","68fc6cdfc3af739f25508640","68f1e0dec3af739f251703be","68ce4865c3af739f256143a2","68f1a89fc3af739f25dd7ca6","68f9c9dfc3af739f258515bc","689ab73ffb5e4bed1fdedef3"],"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\":42.10260009765625,\"lng\":-72.58509826660156,\"latlng\":\"42.102600097656,-72.585098266602\",\"city\":\"Springfield\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.42400000 1770023948)","created":"MongoDate(0.42400000 1770023948)"} , true)	0	2
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

Springfield

Massachusetts

Springfield Groups and Organizations

American International College

Brightwood Branch Library

East Forest Park Branch Library

East Springfield Branch Library

Forest Park Branch Library

Mano Amiga Homeschoolers

Mason Square Branch Library

Pine Point Branch Library

Sixteen Acres Branch Library

Springfield City Library

Springfield College

Springfield Public Schools

Springfield Technical Community College

Western New England University

Local Events

UConn Huskies Mens Basketball vs. Xavier Musketeers Mens Basketball

UMass Minutemen Mens Basketball vs. Central Michigan Chippewas Mens Basketball

Bobby Rush

Jackopierce

FJ – A Tribute To Foreigner and Journey

Tom Hamilton

Ricardo Arjona

ROAR! Comedy: Mo Mandel

Umphrey’s McGee

UMass Minutemen Hockey vs. UMass Lowell River Hawks Hockey