Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"addyston-oh"}, [] ).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":"midway-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	32
4	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"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":"midway-ky"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	14	3
7	db.events_cache.find( {"_id":"78f16cbf0b813bd1b138a3d8a0a3cb3b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	10
8	db.events_radius_cache.find( {"_id":"5321b90cf45eda7ee6392fc23533874e"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-84.68280029296875,38.153499603271484],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	230
10	db.events_cache.count( {"_id":"78f16cbf0b813bd1b138a3d8a0a3cb3b"} )	0	1
11	db.events_cache.count( {"_id":"78f16cbf0b813bd1b138a3d8a0a3cb3b"} )	0	1
12	db.events_cache.insert( {"_id":"78f16cbf0b813bd1b138a3d8a0a3cb3b","town_sef_url":"midway-ky","data_key":["685913acfb5e4bed1fd9a1f8","68e86e1dc3af739f25218b74","68bbd366c3af739f25973797","685a65b5fb5e4bed1f659ee1","68dde220c3af739f25c56a23","68dde220c3af739f25c56a40","68a14ec4fb5e4bed1fa18646","68dde220c3af739f25c56b01","685d0879fb5e4bed1f1a1253","68df339fc3af739f2509e8cf"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"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\":38.153499603271484,\"lng\":-84.68280029296875,\"latlng\":\"38.153499603271,-84.682800292969\",\"city\":\"Midway\",\"state\":\"KY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.43500000 1765824176)","created":"MongoDate(0.43500000 1765824176)"} , true)	0	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
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.towns.find( {"sef_url":"midway-ky"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.tokens.find( {"sef_url":{"$in":["usa","ky","woodford-county-ky","midway-ky"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
20	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
21	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2

Midway Groups and Organizations

Local Events