Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"roselle-il"}, [] ).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	1
3	db.towns.find( {"sef_url":"roselle-il"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.tokens.find( {"sef_url":{"$in":["usa","il","dupage-county-il","roselle-il"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.events_cache.find( {"_id":"e58a307ae18f6341fcfdc60c90986004"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events_radius_cache.find( {"_id":"77801715ed2332d8b9bb1d5f45c45729"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.count( {"address.town_sef_url":"roselle-il","start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768284000)"}} )	0	1
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.08999633789062,41.98310089111328],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	6	19
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-88.08999633789062,41.98310089111328],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767679200)","$lt":"MongoDate(0.00000000 1768543200)"}} )	20	19
10	db.events_radius_cache.count( {"_id":"77801715ed2332d8b9bb1d5f45c45729"} )	0	1
11	db.events_radius_cache.insert( {"_id":"77801715ed2332d8b9bb1d5f45c45729","radius":15,"modified":"MongoDate(0.99500000 1767700034)","created":"MongoDate(0.99500000 1767700034)"} , true)	0	2
12	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767679200)"},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-88.08999633789062,41.98310089111328],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	26
13	db.events_cache.count( {"_id":"e58a307ae18f6341fcfdc60c90986004"} )	0	1
14	db.events_cache.count( {"_id":"e58a307ae18f6341fcfdc60c90986004"} )	0	1
15	db.events_cache.insert( {"_id":"e58a307ae18f6341fcfdc60c90986004","town_sef_url":"roselle-il","data_key":["68a75b7003a70639b6cf76f8","68a75b7003a70639b6cf791a","68a75b7003a70639b6cf79e8","68a75b7003a70639b6cf7bff","6933210a4389be6be5657046","6933210b4389be6be565726d","68a75b7103a70639b6cf7f56","6933210b4389be6be565750d","68a75b7103a70639b6cf8198","6933210b4389be6be565774f","68a75b7103a70639b6cf83ab","6933210b4389be6be56578bd","68a75b7103a70639b6cf844f","6933210c4389be6be5657db6","6933210c4389be6be565804c"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Roselle 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\":41.98310089111328,\"lng\":-88.08999633789062,\"latlng\":\"41.983100891113,-88.089996337891\",\"city\":\"Roselle\",\"state\":\"IL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.09600000 1767700035)","created":"MongoDate(0.09600000 1767700035)"} , true)	0	1

Roselle

Illinois

Roselle Featured Events
Arts And Entertainment

Sister Act at Drury Lane

Sister Act at Drury Lane

Sister Act at Drury Lane

Sister Act at Drury Lane

Jamie Kennedy

Jamie Kennedy

Sister Act at Drury Lane

Jamie Kennedy

Sister Act at Drury Lane

Jamie Kennedy

Sister Act at Drury Lane

Jamie Kennedy

Sister Act at Drury Lane

DeRay Davis

DeRay Davis

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.

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

Roselle Featured Events
Arts And Entertainment

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