Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"union-or"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"lillian-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":"9433d6c958119a606584a27a89e8252f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"082df26d6a7d512afc23237f84526cb6"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"lillian-al","start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770357600)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.43699645996094,30.40839958190918],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} )	0	19
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-87.43699645996094,30.40839958190918],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769752800)","$lt":"MongoDate(0.00000000 1770616800)"}} )	3	17
11	db.events_radius_cache.count( {"_id":"082df26d6a7d512afc23237f84526cb6"} )	0	1
12	db.events_radius_cache.count( {"_id":"082df26d6a7d512afc23237f84526cb6"} )	0	1
13	db.events_radius_cache.insert( {"_id":"082df26d6a7d512afc23237f84526cb6","radius":25,"modified":"MongoDate(0.33900000 1769768013)","created":"MongoDate(0.33900000 1769768013)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769752800)"},"geo":{"$geoWithin":{"$center":[[-87.43699645996094,30.40839958190918],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	168
15	db.events_cache.count( {"_id":"9433d6c958119a606584a27a89e8252f"} )	0	4
16	db.events_cache.count( {"_id":"9433d6c958119a606584a27a89e8252f"} )	0	5
17	db.events_cache.insert( {"_id":"9433d6c958119a606584a27a89e8252f","town_sef_url":"lillian-al","data_key":["68b260acc3af739f2549f94e","68b260acc3af739f2549f9b5","68ef05a0c3af739f254c0893","68dc90a1c3af739f25fd37e4","691d2a16de4ae56f5a437cfa","691eb3ddde4ae56f5a229d89","68edb41dc3af739f2514c8f6","691eb3ddde4ae56f5a229de0","68edb41dc3af739f2514c927","696c4416b1faf7c56a0476b5","68b260acc3af739f2549fab4","68b260acc3af739f2549fae9","68b7a6abc3af739f2571f962","693b7ca5de4ae56f5a5ac901","68b260acc3af739f2549fb94"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Lillian 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\":30.40839958190918,\"lng\":-87.43699645996094,\"latlng\":\"30.408399581909,-87.436996459961\",\"city\":\"Lillian\",\"state\":\"AL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.56300000 1769768013)","created":"MongoDate(0.56300000 1769768013)"} , true)	0	2
18	db.towns.find( {"sef_url":"lillian-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","al","baldwin-county-al","lillian-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

Lillian

Alabama

Lillian Featured Events

Pensacola Ice Flyers vs. Fayetteville Marksmen

Pensacola Ice Flyers vs. Fayetteville Marksmen

Heroes Off Duty Comedy Tour

BERT KREISCHER: PERMISSION TO PARTY

BERT KREISCHER: PERMISSION TO PARTY

Gary Clark Jr.

Meredith Willson's The Music Man

Gary Clark Jr.

Meredith Willson's The Music Man

Incantation

Pensacola Ice Flyers vs. Knoxville Ice Bears

Pensacola Ice Flyers vs. Knoxville Ice Bears

Pensacola Symphony Orchestra: Icon: The Voices that Changed Music

Waka Flocka Flame & Ying Yang Twins - Pensacola Mardi Gras Mambo

Pensacola Ice Flyers vs. Macon Mayhem

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.

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