Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"elrosa-mn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"clover-sc"}, [] ).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":"a8cccf116fae3d5581febddd1f56dcae"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"a09e434fcb4292e0086482ac61da3240"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765692000)"},"geo":{"$geoWithin":{"$center":[[-81.22650146484375,35.11119842529297],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	225
9	db.events_cache.count( {"_id":"a8cccf116fae3d5581febddd1f56dcae"} )	0	1
10	db.events_cache.count( {"_id":"a8cccf116fae3d5581febddd1f56dcae"} )	0	1
11	db.events_cache.insert( {"_id":"a8cccf116fae3d5581febddd1f56dcae","town_sef_url":"clover-sc","data_key":["6904b84bde4ae56f5ab7f148","6904b84bde4ae56f5ab7f14e","6904b84bde4ae56f5ab7f194","6904b84bde4ae56f5ab7f199","68f95d2d0118f5e48e0f6b0b","6904b84bde4ae56f5ab7f1ad","68f95d2d0118f5e48e0f6b0c","6904b84bde4ae56f5ab7f1ba","68f95d2d0118f5e48e0f6b0d","68f95e5007edb82851099c36","6904b84bde4ae56f5ab7f1e6","68f95e5007edb82851099c37","6904b84bde4ae56f5ab7f20f","6904b84bde4ae56f5ab7f21a","6904b84bde4ae56f5ab7f21d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clover 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\":35.11119842529297,\"lng\":-81.22650146484375,\"latlng\":\"35.111198425293,-81.226501464844\",\"city\":\"Clover\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.22200000 1765721578)","created":"MongoDate(0.22200000 1765721578)"} , true)	0	1
12	db.towns.find( {"sef_url":"clover-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.tokens.find( {"sef_url":{"$in":["usa","sc","york-county-sc","clover-sc"]}}, [] ).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

Clover

South Carolina

Clover Featured Events

Christmas at the Library

Christmas at the Library

Christmas at the Library

Christmas at the Library

The Nutcracker

Christmas at the Library

The Nutcracker

Christmas at the Library

The Nutcracker

The Nutcracker

Christmas at the Library

The Nutcracker

Christmas at the Library

Christmas at the Library

Christmas at the Library

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.

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