Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"decatur-ar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"melrose-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"99f1a1b6e537b1b1da4316b1e4f9d3da"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"1e180ff7bdfc48335ab3c9a428e332e9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	14
8	db.events.count( {"address.town_sef_url":"melrose-ia","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} )	0	2
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.04900360107422,40.977699279785156],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} )	0	33
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-93.04900360107422,40.977699279785156],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} )	0	37
11	db.events_radius_cache.count( {"_id":"1e180ff7bdfc48335ab3c9a428e332e9"} )	0	1
12	db.events_radius_cache.count( {"_id":"1e180ff7bdfc48335ab3c9a428e332e9"} )	0	1
13	db.events_radius_cache.insert( {"_id":"1e180ff7bdfc48335ab3c9a428e332e9","radius":25,"modified":"MongoDate(0.54500000 1769917006)","created":"MongoDate(0.54500000 1769917006)"} , true)	0	3
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"geo":{"$geoWithin":{"$center":[[-93.04900360107422,40.977699279785156],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	6
15	db.events_cache.count( {"_id":"99f1a1b6e537b1b1da4316b1e4f9d3da"} )	0	1
16	db.events_cache.count( {"_id":"99f1a1b6e537b1b1da4316b1e4f9d3da"} )	0	1
17	db.events_cache.insert( {"_id":"99f1a1b6e537b1b1da4316b1e4f9d3da","town_sef_url":"melrose-ia","data_key":["68941fc1fb5e4bed1fb94ab3","689d5a3ffb5e4bed1f4b0d23","68a694bdc3af739f251730bb","68af9e06c3af739f250c9adb","68b8d885c3af739f251bc071","68c21302c3af739f252e8420","68cb4d81c3af739f2545c05c","68d487ffc3af739f25116087","68ddc27fc3af739f25a3dcf2","68e6fd02c3af739f25c7f10a","68f03780c3af739f257069db","68f971fdc3af739f25121333","6902ac7a3394d74e78f27d0f","690be6f7de4ae56f5a6c051f","69152174de4ae56f5a6ccaab"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Melrose 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.977699279785156,\"lng\":-93.04900360107422,\"latlng\":\"40.977699279785,-93.049003601074\",\"city\":\"Melrose\",\"state\":\"IA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.57300000 1769917006)","created":"MongoDate(0.57300000 1769917006)"} , true)	0	2
18	db.towns.find( {"sef_url":"melrose-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","ia","monroe-county-ia","melrose-ia"]}}, [] ).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	2
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	2
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Melrose

Iowa

Melrose Featured Events

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

NAMI Family Support Group

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.

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