Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.towns.find( {"sef_url":"merrick-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":"merrick-ny","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	3
6	db.events_cache.find( {"_id":"6a3bca9a7196e5290903a9f79b6d3c69"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"49fe5542df519a4ff3b84a213069c582"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-73.55359649658203,40.65420150756836],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	240
9	db.events_cache.count( {"_id":"6a3bca9a7196e5290903a9f79b6d3c69"} )	0	6
10	db.events_cache.count( {"_id":"6a3bca9a7196e5290903a9f79b6d3c69"} )	0	1
11	db.events_cache.insert( {"_id":"6a3bca9a7196e5290903a9f79b6d3c69","town_sef_url":"merrick-ny","data_key":["6942c44ede4ae56f5aabcfcb","685a86c07573f157b833c839","685670d7fb5e4bed1f3b2a7a","69289e95de4ae56f5a0cf738","6857c25bfb5e4bed1f86fc61","68917cbffb5e4bed1f58f66f","68b10f28c3af739f25c5c128","6878b7ebfb5e4bed1fd98743","685913b2fb5e4bed1fd9a9c7","69096398de4ae56f5a1c02dc"],"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\":40.65420150756836,\"lng\":-73.55359649658203,\"latlng\":\"40.654201507568,-73.553596496582\",\"city\":\"Merrick\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.54900000 1766000642)","created":"MongoDate(0.54900000 1766000642)"} , 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	2
15	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
16	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Merrick

New York

Merrick Groups and Organizations

Bellmore-Merrick Central High School District

Friends of The Merrick Library

JFI Stone Family Hebrew School at Ohav Sholom

Merrick Library

Merrick Union Free School District

North Merrick UFSD

Local Events

Elixir Packaging

Roslyn North Hills Farmers Market

Annie (Touring)

SNOW GLOBE MAKING - FREE DRINK - Winter Wonderland Family Event

Annie (Touring)

It Must Be Christmas - An Acoustic Evening with Chris Young

Trans-Siberian Orchestra - The Ghosts Of Christmas Eve

New York Islanders vs. Vancouver Canucks

Annie (Touring)

80s vs. 90s Christmas Party feat. Decadia