Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"south-hackensack-nj"}, [] ).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":"andover-ks"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/birdseye-solequence-and-more-2025-12-31-jb-fort-wayne-in.html"]},"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":"3c07afc7fb75c42e61a50d6141f039ad"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"e9dc0fb891bef7ac2622c098b1e0921f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-97.13520050048828,37.694000244140625],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	229
9	db.events_cache.count( {"_id":"3c07afc7fb75c42e61a50d6141f039ad"} )	0	1
10	db.events_cache.count( {"_id":"3c07afc7fb75c42e61a50d6141f039ad"} )	0	1
11	db.events_cache.insert( {"_id":"3c07afc7fb75c42e61a50d6141f039ad","town_sef_url":"andover-ks","data_key":["6901d0c9bf28de9b07092f8d","68b10f28c3af739f25c5c504","687f4f98fb5e4bed1f73e006","68b10f28c3af739f25c5c5a4","69211e98de4ae56f5af9c099","691bd894de4ae56f5a7c07ff","68b10f28c3af739f25c5c71b","6868e5b5fb5e4bed1f644f3b","691bd894de4ae56f5a7c0862","68b10f28c3af739f25c5c76d","68b10f28c3af739f25c5c7d3","69211e98de4ae56f5af9c31c","69211e98de4ae56f5af9c361","68b10f28c3af739f25c5c8af","68b10f28c3af739f25c5c8c5"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Andover Featured Events\",\"keyword\":\"\",\"radius\":25,\"limit\":15,\"page\":1,\"sef\":\"birdseye-solequence-and-more-2025-12-31-jb-fort-wayne-in.html\",\"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\":37.694000244140625,\"lng\":-97.13520050048828,\"latlng\":\"37.694000244141,-97.135200500488\",\"city\":\"Andover\",\"state\":\"KS\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.65900000 1766331262)","created":"MongoDate(0.65900000 1766331262)"} , true)	0	2
12	db.towns.find( {"sef_url":"andover-ks"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","ks","butler-county-ks","andover-ks"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
14	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
20	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Andover

Kansas

Andover Featured Events

Wichita Flea Market

Wichita Thunder vs. Allen Americans

Mannheim Steamroller Christmas

Wichita Thunder vs. Tulsa Oilers - Hockey

Wings v Blizzard

Aaron Tippin

Wichita Thunder vs. Utah Grizzlies

Paramount: 80's Rock Night NYE at The Cotillion

LOCASH

Wichita Thunder vs. Utah Grizzlies

Wichita Thunder vs. Utah Grizzlies

Wings vs Kings

Wings vs Kings

Wichita Thunder vs. Allen Americans

Wichita Thunder vs. Allen Americans

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.

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