Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mc-lean-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"clarence-ny"}, [] ).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":"clarence-ny","tags":"arts-and-entertainment"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	3
7	db.events_cache.find( {"_id":"561ebad5122b18891458f21abf89983d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"fdeb3b8eea2345e9790be6221e622ed2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766556000)"},"geo":{"$geoWithin":{"$center":[[-78.59190368652344,42.98059844970703],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	64
10	db.events_cache.count( {"_id":"561ebad5122b18891458f21abf89983d"} )	0	5
11	db.events_cache.count( {"_id":"561ebad5122b18891458f21abf89983d"} )	0	1
12	db.events_cache.insert( {"_id":"561ebad5122b18891458f21abf89983d","town_sef_url":"clarence-ny","data_key":["687f4f97fb5e4bed1f73de14","687f4f97fb5e4bed1f73de30","685fab7dfb5e4bed1fb55bdf","687f4f98fb5e4bed1f73deca","687f4f98fb5e4bed1f73df78","689965cefb5e4bed1f953e45","687f4f99fb5e4bed1f73e142","68a9262bc3af739f252fd03a","69368e76de4ae56f5ad00e22","687f4f99fb5e4bed1f73e19a"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":25,\"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.98059844970703,\"lng\":-78.59190368652344,\"latlng\":\"42.980598449707,-78.591903686523\",\"city\":\"Clarence\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.66700000 1766564750)","created":"MongoDate(0.66700000 1766564750)"} , 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	11

Clarence

New York

Clarence Groups and Organizations

Clarence HollowFest

Gotta Have Art Festival

Great Pumpkin Farm Fall Festival

Museum Of European Art

Oinktoberfest

Taste of Clarence and Cruise Night

Local Events

'Twas the Night Before... by Cirque du Soleil

'Twas the Night Before... by Cirque du Soleil

Newfane United Methodist Church Farmers Market

'Twas the Night Before... by Cirque du Soleil

'Twas the Night Before... by Cirque du Soleil

Great Train Robbery

'Twas the Night Before... by Cirque du Soleil

Girls' Night Christmas

Sensory Friendly Inclusive Christmas Mass

'Twas the Night Before... by Cirque du Soleil