Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"columbia-al"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"lorraine-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	10
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":"ce01365c0fb84fe4925033d1bbb3c4b2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
7	db.events_radius_cache.find( {"_id":"f325cad6523d8735ac2dce484901168d"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"lorraine-ny","start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767074400)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.95929718017578,43.7661018371582],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	0	27
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-75.95929718017578,43.7661018371582],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766469600)","$lt":"MongoDate(0.00000000 1767333600)"}} )	0	24
11	db.events_radius_cache.count( {"_id":"f325cad6523d8735ac2dce484901168d"} )	0	1
12	db.events_radius_cache.count( {"_id":"f325cad6523d8735ac2dce484901168d"} )	0	1
13	db.events_radius_cache.insert( {"_id":"f325cad6523d8735ac2dce484901168d","radius":25,"modified":"MongoDate(0.05600000 1766523593)","created":"MongoDate(0.05600000 1766523593)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766469600)"},"geo":{"$geoWithin":{"$center":[[-75.95929718017578,43.7661018371582],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	371
15	db.events_cache.count( {"_id":"ce01365c0fb84fe4925033d1bbb3c4b2"} )	0	1
16	db.events_cache.count( {"_id":"ce01365c0fb84fe4925033d1bbb3c4b2"} )	0	1
17	db.events_cache.insert( {"_id":"ce01365c0fb84fe4925033d1bbb3c4b2","town_sef_url":"lorraine-ny","data_key":["69041d9dde4ae56f5ae0e7f6","69041d9dde4ae56f5ae0e844","69041d9dde4ae56f5ae0e946","69041d9dde4ae56f5ae0e989","69041d9ede4ae56f5ae0ebbd","69041d9ede4ae56f5ae0ed1f","69041d9ede4ae56f5ae0ee06","69041d9ede4ae56f5ae0ee3e","69041d9fde4ae56f5ae0f09d","69041d9fde4ae56f5ae0f0e1","69041d9fde4ae56f5ae0f281","69041d9fde4ae56f5ae0f2cc","69041d9fde4ae56f5ae0f3af","69041d9fde4ae56f5ae0f40f","69041d9fde4ae56f5ae0f435"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Lorraine 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\":43.7661018371582,\"lng\":-75.95929718017578,\"latlng\":\"43.766101837158,-75.959297180176\",\"city\":\"Lorraine\",\"state\":\"NY\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.73500000 1766523593)","created":"MongoDate(0.73500000 1766523593)"} , true)	0	1
18	db.towns.find( {"sef_url":"lorraine-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","ny","jefferson-county-ny","lorraine-ny"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	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

Lorraine

New York

Lorraine Featured Events

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Danbury Hat Tricks

Watertown Wolves vs. Port Huron Prowlers

Watertown Wolves vs. Port Huron Prowlers

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Binghamton Black Bears

Watertown Wolves vs. Danbury Hat Tricks

Watertown Wolves vs. Port Huron Prowlers

Watertown Wolves vs. Port Huron Prowlers

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.

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