Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"albany-vt"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"hunker-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	2
6	db.events_cache.find( {"_id":"260491e9bc3382d6114e94422729f060"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"356f95cbdc3c3b6df9e92e1f7ba71b0f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"hunker-pa","start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770530400)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.61530303955078,40.20399856567383],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} )	0	25
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-79.61530303955078,40.20399856567383],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} )	3	24
11	db.events_radius_cache.count( {"_id":"356f95cbdc3c3b6df9e92e1f7ba71b0f"} )	0	1
12	db.events_radius_cache.count( {"_id":"356f95cbdc3c3b6df9e92e1f7ba71b0f"} )	0	2
13	db.events_radius_cache.insert( {"_id":"356f95cbdc3c3b6df9e92e1f7ba71b0f","radius":25,"modified":"MongoDate(0.17700000 1769994641)","created":"MongoDate(0.17700000 1769994641)"} , true)	0	2
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)"},"geo":{"$geoWithin":{"$center":[[-79.61530303955078,40.20399856567383],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	28
15	db.events_cache.count( {"_id":"260491e9bc3382d6114e94422729f060"} )	0	1
16	db.events_cache.count( {"_id":"260491e9bc3382d6114e94422729f060"} )	0	2
17	db.events_cache.insert( {"_id":"260491e9bc3382d6114e94422729f060","town_sef_url":"hunker-pa","data_key":["6892ce41fb5e4bed1f90b6ea","6896c2c5fb5e4bed1f1b5678","689c08bffb5e4bed1f1f9cef","689ffd45fb5e4bed1f956cf2","68a5433ffb5e4bed1febce24","68a9068ac3af739f250a4aae","68ae4c88c3af739f258232c1","68e754e2c3af739f2514da9f","68b24109c3af739f2526f11f","692f9f14de4ae56f5a523cad","68b78709c3af739f2540c18a","68bb7b85c3af739f25f922c5","68e20ee2c3af739f259b6f16","68c0c185c3af739f2501d34d","68c4b52bc3af739f2551f58f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hunker 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.20399856567383,\"lng\":-79.61530303955078,\"latlng\":\"40.203998565674,-79.615303039551\",\"city\":\"Hunker\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.26000000 1769994641)","created":"MongoDate(0.26000000 1769994641)"} , true)	0	2
18	db.towns.find( {"sef_url":"hunker-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","pa","westmoreland-county-pa","hunker-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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

Hunker

Pennsylvania

Hunker Featured Events

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Karaoke with Big Al

Steve Kimock, Jackie Greene and more

Karaoke with Big Al

SOLD OUT! The Left It In The River Tour - Pittsburgh (West Mifflin), PA

Karaoke with Big Al

Karaoke with Big Al

Sheena Easton

Karaoke with Big Al

Karaoke with Big Al

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.

Hunker 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.