Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"painesville-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"charlotte-nc"}, [] ).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":"3027e1ca7ffebdfb30de0e4b35865375"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767506400)"},"geo":{"$geoWithin":{"$center":[[-80.8458023071289,35.23139953613281],0.07246376811594203]}}}, ["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	46
8	db.events_cache.count( {"_id":"3027e1ca7ffebdfb30de0e4b35865375"} )	0	1
9	db.events_cache.count( {"_id":"3027e1ca7ffebdfb30de0e4b35865375"} )	0	1
10	db.events_cache.insert( {"_id":"3027e1ca7ffebdfb30de0e4b35865375","town_sef_url":"charlotte-nc","data_key":["68cd2fef302db3bbce02ae09","68b7a6aac3af739f2571f11c","68cd2fda1f575976390b76cc","68cd2fdb1f575976390b76cd","68cd2fdb1f575976390b76ce","689eabbefb5e4bed1f7b399c","68cd2fdb1f575976390b76cf","689eabbefb5e4bed1f7b39f2","68cd2fdb1f575976390b76d0","68b7a6aac3af739f2571f1d3","6913ef95de4ae56f5a16b6de","689ab73ffb5e4bed1fded88c","691eb3dade4ae56f5a2292e3","691eb3dade4ae56f5a229359","6913ef95de4ae56f5a16b6f8"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Charlotte Featured Events\",\"keyword\":\"\",\"radius\":5,\"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\":35.23139953613281,\"lng\":-80.8458023071289,\"latlng\":\"35.231399536133,-80.845802307129\",\"city\":\"Charlotte\",\"state\":\"NC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.29400000 1767551463)","created":"MongoDate(0.29400000 1767551463)"} , true)	0	1
11	db.towns.find( {"sef_url":"charlotte-nc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
12	db.tokens.find( {"sef_url":{"$in":["usa","nc","mecklenburg-county-nc","charlotte-nc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
13	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Charlotte

North Carolina

Charlotte Featured Events

Exhibition: Above and Beyond

Hot Wheels Monster Trucks™ Live Glow-N-Fire

Exhibition: Above and Beyond

Exhibition: Above and Beyond

Exhibition: Above and Beyond

Charlotte Hornets vs. Toronto Raptors

Exhibition: Above and Beyond

Charlotte Hornets vs. Indiana Pacers

Exhibition: Above and Beyond

Charlotte Checkers vs. Wilkes Barre Scranton Penguins

Sherri Shepherd

Toughest Monster Truck Tour FRI

Abbey Road LIVE! and Radio Free Athens

Hey LA

Sherri Shepherd

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.

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