Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"hamburg-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"hamburg-ny","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	5	2
6	db.events_cache.find( {"_id":"c891c027fed842d8aa3395745ce16484"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"9ae390655bd370332244d3152b4ceb66"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"geo":{"$geoWithin":{"$center":[[-78.83899688720703,42.72330093383789],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	99
9	db.events_cache.count( {"_id":"c891c027fed842d8aa3395745ce16484"} )	0	1
10	db.events_cache.count( {"_id":"c891c027fed842d8aa3395745ce16484"} )	0	1
11	db.events_cache.insert( {"_id":"c891c027fed842d8aa3395745ce16484","town_sef_url":"hamburg-ny","data_key":["69157955de4ae56f5a227b77","687f4f96fb5e4bed1f73dd11","687f4f97fb5e4bed1f73ddeb","69103356de4ae56f5a25fff5","687f4f97fb5e4bed1f73de14","687f4f97fb5e4bed1f73de30","687f4f98fb5e4bed1f73deca","687f4f98fb5e4bed1f73df78","689965cefb5e4bed1f953e45","687f4f99fb5e4bed1f73e142"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"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.72330093383789,\"lng\":-78.83899688720703,\"latlng\":\"42.723300933838,-78.838996887207\",\"city\":\"Hamburg\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.85400000 1766431688)","created":"MongoDate(0.85500000 1766431688)"} , true)	0	2
12	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
17	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
18	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Hamburg

New York

Hamburg Groups and Organizations

Frontier Central School District

Hamburg Central School District

Hamburg Public Library

Hilbert College

Saint Francis High School

Local Events

FINICK

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

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

Silver Maple and Gimme Gimme

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

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

'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