Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"porter-ranch-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"normal-al"}, [] ).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	1
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":"e29e0474cf1690eb71c5efe70a8f4e90"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"daded7d2c652df03a98af271500d6218"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"normal-al","start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1770184800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-86.5719985961914,34.79280090332031],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769580000)","$lt":"MongoDate(0.00000000 1770444000)"}} )	18	23
10	db.events_radius_cache.count( {"_id":"daded7d2c652df03a98af271500d6218"} )	0	1
11	db.events_radius_cache.count( {"_id":"daded7d2c652df03a98af271500d6218"} )	0	1
12	db.events_radius_cache.insert( {"_id":"daded7d2c652df03a98af271500d6218","radius":7,"modified":"MongoDate(0.08000000 1769665007)","created":"MongoDate(0.08000000 1769665007)"} , true)	0	1
13	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769580000)"},"geo":{"$geoWithin":{"$center":[[-86.5719985961914,34.79280090332031],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	105
14	db.events_cache.count( {"_id":"e29e0474cf1690eb71c5efe70a8f4e90"} )	0	1
15	db.events_cache.count( {"_id":"e29e0474cf1690eb71c5efe70a8f4e90"} )	0	1
16	db.events_cache.insert( {"_id":"e29e0474cf1690eb71c5efe70a8f4e90","town_sef_url":"normal-al","data_key":["688d8d11fb5e4bed1f4d3856","68911579fb5e4bed1fbe47c6","689ffd44fb5e4bed1f956821","691bd895de4ae56f5a7c0e3c","68911579fb5e4bed1fbe4ca5","691bd895de4ae56f5a7c0e72","68917cc1fb5e4bed1f59006b","691bd895de4ae56f5a7c0eb7","689ffd44fb5e4bed1f956879","68917cc1fb5e4bed1f5903bb","691bd895de4ae56f5a7c0ef3","6892ce41fb5e4bed1f90b38e","691bd895de4ae56f5a7c0f34","6892ce41fb5e4bed1f90b5e6","68f6ee9cc3af739f25829cc1"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Normal Featured Events\",\"keyword\":\"\",\"radius\":7,\"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\":34.79280090332031,\"lng\":-86.5719985961914,\"latlng\":\"34.79280090332,-86.571998596191\",\"city\":\"Normal\",\"state\":\"AL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.22400000 1769665007)","created":"MongoDate(0.22400000 1769665007)"} , true)	0	1
17	db.towns.find( {"sef_url":"normal-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.tokens.find( {"sef_url":{"$in":["usa","al","madison-county-al","normal-al"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
19	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
21	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11

Normal

Alabama

Normal Featured Events

The Sound of Music (Touring)

The Sound of Music (Touring)

Huntsville Havoc vs. Peoria Riverman

Kountry Wayne

The Sound of Music (Touring)

Kountry Wayne

The Sound of Music (Touring)

Kountry Wayne

Huntsville Havoc vs. Peoria Riverman

The Sound of Music (Touring)

Kountry Wayne

The Sound of Music (Touring)

Kountry Wayne

The Sound of Music (Touring)

An All-Star Salute 90's Country - Honky Tonk Time Machine

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.

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