Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"monroe-ia"}, [] ).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":"hamlin-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"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.events_cache.find( {"_id":"7d10d8154951466277194fc093bd1d05"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"abd11185ca1588859f22beb475e9f929"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"hamlin-pa","start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1766901600)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.37870025634766,40.45610046386719],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	0	25
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-76.37870025634766,40.45610046386719],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766296800)","$lt":"MongoDate(0.00000000 1767160800)"}} )	1	20
11	db.events_radius_cache.count( {"_id":"abd11185ca1588859f22beb475e9f929"} )	0	1
12	db.events_radius_cache.count( {"_id":"abd11185ca1588859f22beb475e9f929"} )	0	1
13	db.events_radius_cache.insert( {"_id":"abd11185ca1588859f22beb475e9f929","radius":25,"modified":"MongoDate(0.67000000 1766369792)","created":"MongoDate(0.67000000 1766369792)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-76.37870025634766,40.45610046386719],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( 16 ).skip( 0 )	16	189
15	db.events_cache.count( {"_id":"7d10d8154951466277194fc093bd1d05"} )	0	1
16	db.events_cache.count( {"_id":"7d10d8154951466277194fc093bd1d05"} )	0	1
17	db.events_cache.insert( {"_id":"7d10d8154951466277194fc093bd1d05","town_sef_url":"hamlin-pa","data_key":["68917cc0fb5e4bed1f58f84e","690ba0a5de4ae56f5a0b27bb","690ba0a5de4ae56f5a0b27bd","690ba0a5de4ae56f5a0b27c7","690ba0a5de4ae56f5a0b27ca","68624e8bfb5e4bed1f2f6de1","68624e8bfb5e4bed1f2f6dfd","690ba0a5de4ae56f5a0b27cd","68fc01e1a2ba490b380eb16c","68639fe1fb5e4bed1fa5bffd","68639fe1fb5e4bed1fa5c021","68639fe2fb5e4bed1fa5c03e","68fc020b24609126960d89b0","68d4a7a4c3af739f25451544","68bf8fa6c3af739f25b37594"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hamlin Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"images\":true,\"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\":\"\",\"empty-message\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":40.45610046386719,\"lng\":-76.37870025634766,\"latlng\":\"40.456100463867,-76.378700256348\",\"city\":\"Hamlin\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.89100000 1766369792)","created":"MongoDate(0.89100000 1766369792)"} , true)	0	1
18	db.towns.find( {"sef_url":"hamlin-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","pa","wayne-county-pa","hamlin-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Hamlin

Pennsylvania

Hamlin Featured Events

Penn State Nittany Lion Basketball Vs. Pitt Panthers Men's Basketball

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Refreshing Mountain Christmas Light Adventures

Farmstead Farmers Market

Green Dragon Farmers Market

Refreshing Mountain Christmas Light Adventures

Koziar's Christmas Village

Lebanon Farmers Market

Mount Carmel Farmers Market

Farmstead Farmers Market

Koziar's Christmas Village

Christmas With Absolute Adele

Hershey Bears vs. Charlotte Checkers

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Hamlin Featured Events

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.