Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"sandy-ut"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["events","events\/arts-and-entertainment"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"sandy-ut"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","ut","salt-lake-county-ut","sandy-ut"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
5	db.events_cache.find( {"_id":"0f11ca969dee944a83740d18c9d97ed5"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
6	db.events_radius_cache.find( {"_id":"8d2e07604dc8f7f80d86ee88cb99c848"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events.count( {"address.town_sef_url":"sandy-ut","start":{"$gte":"MongoDate(0.00000000 1765432800)","$lt":"MongoDate(0.00000000 1766037600)"}} )	10	2
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-111.87200164794922,40.5807991027832],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765432800)","$lt":"MongoDate(0.00000000 1766296800)"}} )	16	65
9	db.events_radius_cache.count( {"_id":"8d2e07604dc8f7f80d86ee88cb99c848"} )	0	1
10	db.events_radius_cache.insert( {"_id":"8d2e07604dc8f7f80d86ee88cb99c848","radius":7,"modified":"MongoDate(0.72500000 1765501684)","created":"MongoDate(0.72500000 1765501684)"} , true)	0	3
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765432800)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-111.87200164794922,40.5807991027832],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( 16 ).skip( 0 )	16	11
12	db.events_cache.count( {"_id":"0f11ca969dee944a83740d18c9d97ed5"} )	0	1
13	db.events_cache.count( {"_id":"0f11ca969dee944a83740d18c9d97ed5"} )	0	1
14	db.events_cache.insert( {"_id":"0f11ca969dee944a83740d18c9d97ed5","town_sef_url":"sandy-ut","data_key":["693320fb4389be6be56512d5","68a75b5603a70639b6cedad7","68a75b5703a70639b6cedfe0","68a75b5703a70639b6cee2a6","68a75b5903a70639b6ceebf1","68a75b5a03a70639b6cef0c3","68a75b5b03a70639b6cef47d","68a75b5d03a70639b6cf0465","68a75b5d03a70639b6cf083e","68a75b5f03a70639b6cf0daa","68a75b6003a70639b6cf14d8","68a75b6303a70639b6cf24b2","69036ae14389be6be5f603b0","68a75b6403a70639b6cf2724","68a75b6403a70639b6cf290e"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Sandy Featured Events<br>Arts And Entertainment\",\"keyword\":\"\",\"radius\":7,\"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.5807991027832,\"lng\":-111.87200164794922,\"latlng\":\"40.580799102783,-111.87200164795\",\"city\":\"Sandy\",\"state\":\"UT\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.76900000 1765501684)","created":"MongoDate(0.76900000 1765501684)"} , true)	0	2

Sandy

Utah

Sandy Featured Events
Arts And Entertainment

LARKIN LIVE NATIVITY FREE OPEN HOUSE AND FOOD DRIVE

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Frozen (Touring)

Hazy Days Last Minute Holiday Market

Frozen (Touring)

Frozen (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.

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

Sandy Featured Events
Arts And Entertainment

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