Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"lemoyne-ne"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
3	db.towns.find( {"sef_url":"claymont-de"}, [] ).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	3
6	db.events_cache.find( {"_id":"e10ed72c452bfdaa1916aa541b732285"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"c3c563ee61b39eeaa42006b869ffbbb9"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"claymont-de","start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770616800)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.45999908447266,39.800899505615234],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	8	28
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.45999908447266,39.800899505615234],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1770012000)","$lt":"MongoDate(0.00000000 1770876000)"}} )	14	22
11	db.events_radius_cache.count( {"_id":"c3c563ee61b39eeaa42006b869ffbbb9"} )	0	1
12	db.events_radius_cache.count( {"_id":"c3c563ee61b39eeaa42006b869ffbbb9"} )	0	1
13	db.events_radius_cache.insert( {"_id":"c3c563ee61b39eeaa42006b869ffbbb9","radius":25,"modified":"MongoDate(0.09200000 1770033562)","created":"MongoDate(0.09200000 1770033562)"} , true)	0	2
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1770012000)"},"geo":{"$geoWithin":{"$center":[[-75.45999908447266,39.800899505615234],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	58
15	db.events_cache.count( {"_id":"e10ed72c452bfdaa1916aa541b732285"} )	0	1
16	db.events_cache.count( {"_id":"e10ed72c452bfdaa1916aa541b732285"} )	0	1
17	db.events_cache.insert( {"_id":"e10ed72c452bfdaa1916aa541b732285","town_sef_url":"claymont-de","data_key":["68941fc1fb5e4bed1fb94a2d","690ea998de4ae56f5ac287ee","6895714afb5e4bed1fd777c2","6895714afb5e4bed1fd7792c","6896c2c4fb5e4bed1f1b5382","6896c2c5fb5e4bed1f1b5486","690c0699de4ae56f5a9c12a0","6896c2c5fb5e4bed1f1b551f","68fae321c3af739f25d95755","697ac81cb1faf7c56a7b44a9","6896c2c5fb5e4bed1f1b561d","6933cbd9de4ae56f5a4a7bce","68981448fb5e4bed1f56111d","68e08523c3af739f25467bea","68981448fb5e4bed1f56121f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Claymont 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\":39.800899505615234,\"lng\":-75.45999908447266,\"latlng\":\"39.800899505615,-75.459999084473\",\"city\":\"Claymont\",\"state\":\"DE\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.17400000 1770033562)","created":"MongoDate(0.17400000 1770033562)"} , true)	0	1
18	db.towns.find( {"sef_url":"claymont-de"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","de","new-castle-county-de","claymont-de"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	2
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
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	2
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

Claymont

Delaware

Claymont Featured Events

Linvilla Orchard's Garden Center

WWE Monday Night RAW

Linvilla Orchard's Garden Center

Philadelphia Flyers vs. Washington Capitals

Linvilla Orchard's Garden Center

Walnut Street Theatre's Sherlock Holmes: The Great Detective

Villanova Wildcats Mens Basketball vs. Seton Hall Pirates Mens Basketball

Complications in Sue

St. Joseph's Hawks Mens Basketball vs. George Washington Revolutionaries Mens Basketball

Delaware Blue Hens Mens Basketball vs. Liberty University Flames Mens Basketball

Walnut Street Theatre's Sherlock Holmes: The Great Detective

Venus & the Flytraps

Linvilla Orchard's Garden Center

Delaware Blue Coats vs. Wisconsin Herd

Walnut Street Theatre's Sherlock Holmes: The Great Detective

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.

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