Nr	Query	Num. rows	Took (ms)
1	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	9
2	db.towns.find( {"sef_url":"hilliard-oh"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	7
3	db.pages.find( {"type":"town","slug":{"$in":["organizations","organizations\/schools-and-libraries"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
5	db.places.find( {"address.town_sef_url":"hilliard-oh","tags":"schools-and-libraries"}, [] ).sort( {"name":1} ).limit( 21 ).skip( 0 )	21	2
6	db.events_cache.find( {"_id":"8bca35cd372d1d20ff92aee0497f11cc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	6
7	db.events_radius_cache.find( {"_id":"4d371229be42631c2c19f88f2db3fae8"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
8	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766296800)"},"geo":{"$geoWithin":{"$center":[[-83.14649963378906,40.03110122680664],0.21739130434782608]}}}, ["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( 11 ).skip( 0 )	11	83
9	db.events_cache.count( {"_id":"8bca35cd372d1d20ff92aee0497f11cc"} )	0	2
10	db.events_cache.count( {"_id":"8bca35cd372d1d20ff92aee0497f11cc"} )	0	2
11	db.events_cache.insert( {"_id":"8bca35cd372d1d20ff92aee0497f11cc","town_sef_url":"hilliard-oh","data_key":["687f4f95fb5e4bed1f73da26","686cda2ffb5e4bed1f7212bb","690d5819de4ae56f5ac11e67","687f4f95fb5e4bed1f73db31","692e4d91de4ae56f5ae92b67","68e71ca0c3af739f25e5964d","68dde220c3af739f25c56ba8","68b10f28c3af739f25c5c432","6900291bc3af739f259ba96c","69460891de4ae56f5aeccd6e"],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Local Events\",\"images\":false,\"empty-message\":\"no\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"schools-and-libraries\",\"tags\":\"\",\"tags_logical\":\"\",\"terms\":\"\",\"show_limit\":3,\"sort\":\"\",\"days\":\"\",\"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\":\"\",\"ad_slots\":\"\",\"see-more-title\":\"\",\"searchdate\":\"\",\"searchenddate\":\"\",\"lat\":40.03110122680664,\"lng\":-83.14649963378906,\"latlng\":\"40.031101226807,-83.146499633789\",\"city\":\"Hilliard\",\"state\":\"OH\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.88600000 1766335035)","created":"MongoDate(0.88700000 1766335035)"} , true)	0	9
12	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
14	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
15	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
16	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
17	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
18	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Hilliard

Ohio

Hilliard Groups and Organizations

Alton Darby Elementary School

Avery Elementary School

Beacon Elementary School

Britton Elementary School

Brown Elementary School

Darby Creek Elementary School

Educate Hilliard

HCSD Preschool

Hilliard Branch Library

Hilliard Crossing Elementary School

Hilliard Darby High School

Hilliard Davidson High School

Hilliard Education Foundation

Hilliard Memorial Middle School

Hilliard Station 6th Grade School

Hilliard Tharp Sixth Grade School

Hilliard Weaver Middle School

Hoffman Trails Elementary School

J W Reason Elementary School

Norwich Elementary School

Local Events

SIX (Touring)

The Wiz (Touring)

The Everlasting Happiness - Christmas Show w/ Oswald and the Herringbones, The Neal Havener Band and Prophecy at Woodlands Tavern

SIX (Touring)

Hoodoo Soul Band

Ohio State Buckeyes Womens Basketball vs. Western Michigan Broncos Women's Basketball

Ohio State Buckeyes Men's Basketball vs. Grambling State Tigers

Trans-Siberian Orchestra - The Ghosts Of Christmas Eve

Happy Hour w/ So Peachy at Woodlands Tavern

Colin and The Bowlers annual XMAS eve eve show Live at Woodlands Tavern