Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"gilbert-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.pages.find( {"type":"town","slug":{"$in":["organizations"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"gilbert-az"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
4	db.tokens.find( {"sef_url":{"$in":["usa","az","maricopa-county-az","gilbert-az"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"gilbert-az"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"896ab533d248399ba15c815444ec1646"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"cd7967f555558cc04322be4c4b60ba35"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"gilbert-az","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	12	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-111.75599670410156,33.350101470947266],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	24	36
10	db.events_radius_cache.count( {"_id":"cd7967f555558cc04322be4c4b60ba35"} )	0	1
11	db.events_radius_cache.insert( {"_id":"cd7967f555558cc04322be4c4b60ba35","radius":7,"modified":"MongoDate(0.44800000 1765801597)","created":"MongoDate(0.44800000 1765801597)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-111.75599670410156,33.350101470947266],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	122
13	db.events_cache.count( {"_id":"896ab533d248399ba15c815444ec1646"} )	0	1
14	db.events_cache.count( {"_id":"896ab533d248399ba15c815444ec1646"} )	0	1
15	db.events_cache.insert( {"_id":"896ab533d248399ba15c815444ec1646","town_sef_url":"gilbert-az","data_key":["68a75b5d03a70639b6cf04ad","68a75b5e03a70639b6cf08e5","68a75b5e03a70639b6cf08d9","68a75b5f03a70639b6cf0de1","693321014389be6be56532d5","68a75b5f03a70639b6cf0e7b","68a75b6003a70639b6cf1517","68a75b6003a70639b6cf15ef","69036adf4389be6be5f5f94b","68a75b6203a70639b6cf1bec"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":7,\"limit\":15,\"page\":1,\"sef\":\"\",\"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\":33.350101470947266,\"lng\":-111.75599670410156,\"latlng\":\"33.350101470947,-111.7559967041\",\"city\":\"Gilbert\",\"state\":\"AZ\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.60500000 1765801597)","created":"MongoDate(0.60500000 1765801597)"} , true)	0	1

Gilbert

Arizona

Gilbert Groups and Organizations

AHU Peewee White Knights

AYSO Region 688

Actor's Youth Theatre

Actor's Youth Theatre

American Leadership Academy

AmerisleepGilbert

Arizona Craft Spirits Festival

Arizona Eid Festival

Arizona Wilderness Brewing Company - Gilbert Brewpub

Art Intersection

Art of Chocolate A'Fair

Az Ice Gilbert

Banner Gateway Medical Center

Banner Neuro Wellness

BoSa Donuts

Bronctoberfest

Caldwell County BBQ

Campo Verde High School

Cat Video Fest

Celebrate Recovery

Local Events

A Christmas Carol

Living Legends, Souls of Mischief and more

A Christmas Carol

Hi-Fi Holiday Concert

Dave Koz

A Christmas Carol

Hi-Fi Holiday Concert

A Christmas Carol

Mesa Temple Christmas Lights

Hi-Fi Holiday Concert

COVID-19 Resources