Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"diagonal-ia"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
3	db.towns.find( {"sef_url":"trinity-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	11
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	18
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	13
6	db.events_cache.find( {"_id":"e104f3863cdfe74527bc149ea9a7c28d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"09cc1a73c258a38c2bbd1e0fba2c9726"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"trinity-al","start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766296800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.08419799804688,34.59090042114258],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} )	1	28
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.08419799804688,34.59090042114258],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765692000)","$lt":"MongoDate(0.00000000 1766556000)"}} )	1	28
11	db.events_radius_cache.count( {"_id":"09cc1a73c258a38c2bbd1e0fba2c9726"} )	0	1
12	db.events_radius_cache.count( {"_id":"09cc1a73c258a38c2bbd1e0fba2c9726"} )	0	1
13	db.events_radius_cache.insert( {"_id":"09cc1a73c258a38c2bbd1e0fba2c9726","radius":25,"modified":"MongoDate(0.70600000 1765722058)","created":"MongoDate(0.70600000 1765722058)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-87.08419799804688,34.59090042114258],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	227
15	db.events_cache.count( {"_id":"e104f3863cdfe74527bc149ea9a7c28d"} )	0	1
16	db.events_cache.count( {"_id":"e104f3863cdfe74527bc149ea9a7c28d"} )	0	1
17	db.events_cache.insert( {"_id":"e104f3863cdfe74527bc149ea9a7c28d","town_sef_url":"trinity-al","data_key":["69200555de4ae56f5af2c773","6933cbd7de4ae56f5a4a6cc2","691427dade4ae56f5a80db7e","68e1b706c3af739f2549d502","68e30881c3af739f25769140","68e459fdc3af739f258c596f","68f03780c3af739f25706c45","68f188ffc3af739f25bbe07a","68f2da7dc3af739f250d6b4d","68f42c00c3af739f258f79ee","68f57d7fc3af739f25039ab1","68f6cefcc3af739f255e6535","691427dcde4ae56f5a80e6c3","6902ac7b3394d74e78f27ea2","6903fdf8de4ae56f5ab34898"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Trinity 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\":34.59090042114258,\"lng\":-87.08419799804688,\"latlng\":\"34.590900421143,-87.084197998047\",\"city\":\"Trinity\",\"state\":\"AL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.16700000 1765722059)","created":"MongoDate(0.16700000 1765722059)"} , true)	0	1
18	db.towns.find( {"sef_url":"trinity-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","al","morgan-county-al","trinity-al"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	1
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	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Trinity

Alabama

Trinity Featured Events

Suzy Bogguss

The Cleverlys

Charlie Starr

Rocket City Trash Pandas vs. Biloxi Shuckers

Rocket City Trash Pandas vs. Biloxi Shuckers

Rocket City Trash Pandas vs. Biloxi Shuckers

Rocket City Trash Pandas vs. Birmingham Barons

Rocket City Trash Pandas vs. Birmingham Barons

Rocket City Trash Pandas vs. Birmingham Barons

Rocket City Trash Pandas vs. Birmingham Barons

Rocket City Trash Pandas vs. Birmingham Barons

Rocket City Trash Pandas vs. Birmingham Barons

Taj Mahal

Rocket City Trash Pandas vs. Knoxville Smokies

Rocket City Trash Pandas vs. Knoxville Smokies

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.

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