Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"pembroke-nh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"lancaster-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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":"lancaster-pa","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	3
7	db.events_cache.find( {"_id":"d02b69bb9d67ae2d32533afc0d84688b"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events_radius_cache.find( {"_id":"1a2431ba62aac53555d2a209c0ea07fb"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-76.29989624023438,40.04180145263672],0.10144927536231885]}}}, ["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	216
10	db.events_cache.count( {"_id":"d02b69bb9d67ae2d32533afc0d84688b"} )	0	2
11	db.events_cache.count( {"_id":"d02b69bb9d67ae2d32533afc0d84688b"} )	0	2
12	db.events_cache.insert( {"_id":"d02b69bb9d67ae2d32533afc0d84688b","town_sef_url":"lancaster-pa","data_key":["68551f3dfb5e4bed1fd10165","68e5cb1ec3af739f25c77684","68e5cb1ec3af739f25c776be","68e5cb1ec3af739f25c77710","68e5cb1ec3af739f25c77735","685913a4fb5e4bed1fd994eb","68e5cb1ec3af739f25c777d7","685a658dfb5e4bed1f655878","685e5a0dfb5e4bed1f620e3b","68e5cb1ec3af739f25c7785c"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":7,\"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.04180145263672,\"lng\":-76.29989624023438,\"latlng\":\"40.041801452637,-76.299896240234\",\"city\":\"Lancaster\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.71500000 1765795866)","created":"MongoDate(0.71500000 1765795866)"} , true)	0	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
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	9
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	8

Lancaster

Pennsylvania

Lancaster Groups and Organizations

32nd Degree Masonic Learning Centers for Children, Inc.

Conestoga Valley High School

Conestoga Valley School District

Franklin and Marshall College

Hamilton Elementary Recycling Program

Harrisburg Area Community College - Lancaster Campus

J.P. McCaskey High School

Lampeter-Strasburg High School

Lampeter-Strasburg School District

Lancaster Bible College

Lancaster General College of Nursing and Health Sciences

Lancaster Mennonite High School

Lancaster Public Library

Lancaster Theological Seminary

Manheim Township High School

Penn Manor School District

Pennsylvania College of Art and Design

Schaeffer Elementary School

School District Of Lancaster

Smoketown Elementary School

Local Events

Lancaster Central Market

Elf - The Musical

Elf - The Musical

Elf - The Musical

Elf - The Musical

Lancaster Central Market

Elf - The Musical

Lancaster Central Market

Deck the Halls

Elf - The Musical