Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"harper-or"}, [] ).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":"birmingham-mi"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/arts-and-entertainment"]},"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":"birmingham-mi","tags":"arts-and-entertainment"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	16	1
7	db.events_cache.find( {"_id":"b17313a442474ce979ebf9a71b91be4e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"330bbb411120dce6d5e58cff363880ce"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-83.21430206298828,42.54669952392578],0.21739130434782608]}}}, ["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	112
10	db.events_cache.count( {"_id":"b17313a442474ce979ebf9a71b91be4e"} )	0	1
11	db.events_cache.count( {"_id":"b17313a442474ce979ebf9a71b91be4e"} )	0	1
12	db.events_cache.insert( {"_id":"b17313a442474ce979ebf9a71b91be4e","town_sef_url":"birmingham-mi","data_key":["6853cdfdfb5e4bed1f55db5f","68c11965c3af739f259e2d70","68e86e1dc3af739f252188e2","685bb755fb5e4bed1fb69da3","68ccf6e6c3af739f259f6398","685670d6fb5e4bed1f3b2849","6857c259fb5e4bed1f86f868","692f9103de4ae56f5a376377","692f6042de4ae56f5ada9664","690207401e2cec194a046993"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"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.54669952392578,\"lng\":-83.21430206298828,\"latlng\":\"42.546699523926,-83.214302062988\",\"city\":\"Birmingham\",\"state\":\"MI\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.99300000 1765852462)","created":"MongoDate(0.99300000 1765852462)"} , 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	2
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

Birmingham

Michigan

Birmingham Groups and Organizations

Adcraft Detroit Oktoberfest

Birmingham Bloomfield Art Center

Birmingham Concert Band

Birmingham Principal Shopping District

Birmingham Street Art Fair

Birmingham-Bloomfield Symphony Orchestra

David Klein Gallery

Harvest Festival

Manhattan Short Film Festival at Baldwin Public Library

OktoberFest

Robert Kidd Gallery

The Birmingham Fine Art Festival

The Community House

The Robot Garage

The Village Players

Whimsical Occasions Wedding Event Shows

Local Events

The Grover Washington Jr. Tribute ft. Shelby Brown (The Preservation of Jazz Monday Night Music Series)

The Gilmour Project

The Gilmour Project

Chris Isaak

Sarah Kroger and Matt Maher

A Christmas Carol

A Christmas Carol

Little Donut Truck At The Village Of Rochester Hills

Strolling Carolers

Canterbury Holiday Stroll