Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"elko-mn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	12
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"bird-in-hand-pa"}, [] ).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":"bird-in-hand-pa","tags":"arts-and-entertainment"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	6	1
7	db.events_cache.find( {"_id":"6ede12a61ab5a792a05ed8d114a6ca63"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"29e5860ec7eed48a5cacb0711e5c4540"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-76.17890167236328,40.03960037231445],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	159
10	db.events_cache.count( {"_id":"6ede12a61ab5a792a05ed8d114a6ca63"} )	0	1
11	db.events_cache.count( {"_id":"6ede12a61ab5a792a05ed8d114a6ca63"} )	0	1
12	db.events_cache.insert( {"_id":"6ede12a61ab5a792a05ed8d114a6ca63","town_sef_url":"bird-in-hand-pa","data_key":["68e5cb1ec3af739f25c77937","690ba0a5de4ae56f5a0b27bb","685e5a0ffb5e4bed1f621116","68e5cb1ec3af739f25c77a1d","690ba0a5de4ae56f5a0b27bd","68e5cb1ec3af739f25c77a84","690ba0a5de4ae56f5a0b27c7","690ba0a5de4ae56f5a0b27ca","68624e8bfb5e4bed1f2f6ce3","68624e8bfb5e4bed1f2f6dfd"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"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\":40.03960037231445,\"lng\":-76.17890167236328,\"latlng\":\"40.039600372314,-76.178901672363\",\"city\":\"Bird in Hand\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.43900000 1766358573)","created":"MongoDate(0.43900000 1766358573)"} , 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

Bird in Hand

Pennsylvania

Bird in Hand Groups and Organizations

Amish Experience Theater

Lancaster Hot Air Balloon Festival

Lancaster Hot Air Balloon Festival and Country Fair

New Year's Eve With the Smuckers

The Americana Museum of Bird-in-Hand

US Hot Air Balloon Team

Local Events

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Lancaster Central Market

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Elf - The Musical

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Lancaster Central Market

Green Dragon Farmers Market