Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"plainview-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/arts-and-entertainment"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
3	db.towns.find( {"sef_url":"plainview-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ny","nassau-county-ny","plainview-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"0c303a7e3f95a3c0aabb9cd86b21c1f8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"57a994b4688a069c92b4e9a5dbd5b0b0"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"plainview-ny","start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1766988000)"}} )	0	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.47270202636719,40.783199310302734],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	6	32
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-73.47270202636719,40.783199310302734],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766383200)","$lt":"MongoDate(0.00000000 1767247200)"}} )	28	23
10	db.events_radius_cache.count( {"_id":"57a994b4688a069c92b4e9a5dbd5b0b0"} )	0	2
11	db.events_radius_cache.insert( {"_id":"57a994b4688a069c92b4e9a5dbd5b0b0","radius":15,"modified":"MongoDate(0.62400000 1766383840)","created":"MongoDate(0.62400000 1766383840)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766383200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-73.47270202636719,40.783199310302734],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( 16 ).skip( 0 )	16	34
13	db.events_cache.count( {"_id":"0c303a7e3f95a3c0aabb9cd86b21c1f8"} )	0	1
14	db.events_cache.count( {"_id":"0c303a7e3f95a3c0aabb9cd86b21c1f8"} )	0	1
15	db.events_cache.insert( {"_id":"0c303a7e3f95a3c0aabb9cd86b21c1f8","town_sef_url":"plainview-ny","data_key":["68a75b6703a70639b6cf3b65","68a75b6703a70639b6cf3c1e","68a75b6703a70639b6cf3d88","68a75b6803a70639b6cf3fe9","68a75b6803a70639b6cf4075","68a75b6803a70639b6cf448f","68a75b6803a70639b6cf455b","68a75b6903a70639b6cf4731","68a75b6903a70639b6cf47f5","68a75b6903a70639b6cf480a","68a75b6903a70639b6cf4825","68a75b6a03a70639b6cf5021","68a75b6a03a70639b6cf51af","68a75b6a03a70639b6cf51ce","68a75b6b03a70639b6cf544f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Plainview Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"arts-and-entertainment\",\"tags\":\"arts-and-entertainment\",\"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.783199310302734,\"lng\":-73.47270202636719,\"latlng\":\"40.783199310303,-73.472702026367\",\"city\":\"Plainview\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.70900000 1766383840)","created":"MongoDate(0.70900000 1766383840)"} , true)	0	1

Plainview

New York

Plainview Featured Events
Arts And Entertainment

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Harry Connick Jr's The Happy Elf

Annie (Touring)

Annie (Touring)

Get the Led Out

Yellow Brick Joel: Piano Men

A Christmas Carol The Musical

Harry Connick Jr's The Happy Elf

A Christmas Carol The Musical

Annie (Touring)

Annie (Touring)

COVID-19 Resources

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.

Plainview Featured EventsArts And Entertainment

COVID-19 Resources

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.

Plainview Featured Events
Arts And Entertainment

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