Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"mount-summit-in"}, [] ).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":"patriot-in"}, [] ).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":"2efd2c54c9f6c915271563800cf180e4"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"cf964ac82d5cc6564b88ac3015c1d88f"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"patriot-in","start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766556000)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-84.8270034790039,38.838401794433594],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	41
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-84.8270034790039,38.838401794433594],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765951200)","$lt":"MongoDate(0.00000000 1766815200)"}} )	0	32
11	db.events_radius_cache.count( {"_id":"cf964ac82d5cc6564b88ac3015c1d88f"} )	0	1
12	db.events_radius_cache.count( {"_id":"cf964ac82d5cc6564b88ac3015c1d88f"} )	0	1
13	db.events_radius_cache.insert( {"_id":"cf964ac82d5cc6564b88ac3015c1d88f","radius":25,"modified":"MongoDate(0.64700000 1766015813)","created":"MongoDate(0.64700000 1766015813)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765951200)"},"geo":{"$geoWithin":{"$center":[[-84.8270034790039,38.838401794433594],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	434
15	db.events_cache.count( {"_id":"2efd2c54c9f6c915271563800cf180e4"} )	0	1
16	db.events_cache.count( {"_id":"2efd2c54c9f6c915271563800cf180e4"} )	0	11
17	db.events_cache.insert( {"_id":"2efd2c54c9f6c915271563800cf180e4","town_sef_url":"patriot-in","data_key":["691d2a14de4ae56f5a436eb5","691d2a14de4ae56f5a436f0d","691d2a14de4ae56f5a436f8f","6901ba5bf632dfbd2b069988","691d2a14de4ae56f5a437035","691d2a13de4ae56f5a436ca9","691d2a14de4ae56f5a437204","691d2a14de4ae56f5a437299","691d2a15de4ae56f5a437464","691d2a15de4ae56f5a43747a","691d2a15de4ae56f5a4374d6","691d2a15de4ae56f5a43755d","691d2a15de4ae56f5a43756e","691d2a15de4ae56f5a4375ab","691d2a15de4ae56f5a43762d"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Patriot 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\":38.838401794433594,\"lng\":-84.8270034790039,\"latlng\":\"38.838401794434,-84.827003479004\",\"city\":\"Patriot\",\"state\":\"IN\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.19300000 1766015814)","created":"MongoDate(0.19300000 1766015814)"} , true)	0	1
18	db.towns.find( {"sef_url":"patriot-in"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
19	db.tokens.find( {"sef_url":{"$in":["usa","in","switzerland-county-in","patriot-in"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
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

Patriot

Indiana

Patriot Featured Events

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Holiday Makers Market

Turfway Park Live Horse Racing

Live Horse Racing - Synthetic Championship Day

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

Turfway Park Live Horse Racing

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.

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