Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"huslia-ak"}, [] ).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":"canal-winchester-oh"}, [] ).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":"canal-winchester-oh","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	2
7	db.events_cache.find( {"_id":"f97a9205bbed8aaac7e6352757ff3fcc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"0ee0dbf3e843f89c0369f4b05fe74246"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-82.8145980834961,39.844600677490234],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	91
10	db.events_cache.count( {"_id":"f97a9205bbed8aaac7e6352757ff3fcc"} )	0	1
11	db.events_cache.count( {"_id":"f97a9205bbed8aaac7e6352757ff3fcc"} )	0	1
12	db.events_cache.insert( {"_id":"f97a9205bbed8aaac7e6352757ff3fcc","town_sef_url":"canal-winchester-oh","data_key":["6940c28ede4ae56f5a9dc7be","69041d9cde4ae56f5ae0e634","68e08521c3af739f254668fb","687f4f90fb5e4bed1f73d15d","6901b2dbc3af739f25187e86","6942140fde4ae56f5ac69efa","68e71ca0c3af739f25e5945f","686cda2dfb5e4bed1f720f31","6878b7eafb5e4bed1fd9862c","6930f091de4ae56f5aa6e656"],"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\":39.844600677490234,\"lng\":-82.8145980834961,\"latlng\":\"39.84460067749,-82.814598083496\",\"city\":\"Canal Winchester\",\"state\":\"OH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.03900000 1765976368)","created":"MongoDate(0.03900000 1765976368)"} , 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

Canal Winchester

Ohio

Canal Winchester Groups and Organizations

Canal Winchester High School

Canal Winchester Local School District

Canal Winchester Middle School

Canal Winchester Middle School

Indian Trail Elementary School

Winchester Trail Elementary School

Local Events

Happy Hour w/ JT Hillier & Brian Douglas Day at Woodlands Tavern

Supersuckers & Scott H. Biram w/ King Sickabilly

Supersuckers w/ Scott H. Biram

SIX (Touring)

Primer 55

Happy Hour w/ Shane Piasecki & The Lone Wolf Hippies at Woodlands Tavern

Ohio State Buckeyes Womens Basketball vs. Norfolk State Spartans Womens Basketball

The Wiz (Touring)

Columbus Blue Jackets vs. Minnesota Wild

The Spikedrivers Holiday Happy Hour Show