| 1 | db.towns.find( {"sef_url":"north-andover-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 14 |
| 2 | db.pages.find( {"type":"town","slug":{"$in":["trick-or-treat-halloween-events-haunted-houses"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 3 | db.towns.find( {"sef_url":"north-andover-ma"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 9 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","ma","essex-county-ma","north-andover-ma"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 3 |
| 5 | db.events_cache.find( {"_id":"b7a739375294d1e87e7e7aea4e3685fa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 6 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765519200)"},"tags":"halloween-event","geo":{"$geoWithin":{"$center":[[-71.13729858398438,42.69540023803711],1.0869565217391304]}}}, ["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 ) | | 0 | 0 | 7 |
| 7 | db.events_cache.count( {"_id":"b7a739375294d1e87e7e7aea4e3685fa"} ) | | 0 | 0 | 12 |
| 8 | db.events_cache.insert( {"_id":"b7a739375294d1e87e7e7aea4e3685fa","town_sef_url":"north-andover-ma","data_key":[],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Find Massachusetts Halloween Events!\",\"tags\":\"halloween-event\",\"radius\":75,\"keyword\":\"\",\"limit\":15,\"page\":1,\"sef\":\"\",\"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\":42.69540023803711,\"lng\":-71.13729858398438,\"latlng\":\"42.695400238037,-71.137298583984\",\"city\":\"North Andover\",\"state\":\"MA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.77400000 1765564519)","created":"MongoDate(0.77400000 1765564519)"} , true) | | 0 | 0 | 3 |
| 9 | db.places.find( {"geo":{"$near":[-71.13729858398438,42.69540023803711],"$maxDistance":1.0869565217391304},"tags":"haunted"}, [] ).sort( [] ).limit( 11 ).skip( 0 ) | | 0 | 11 | 41 |
| 10 | db.news.find( {"broadcast":{"$in":["usa","north-andover-ma","ma","essex-county-ma"]}}, [] ).sort( {"publish_date":-1} ).limit( 4 ).skip( 0 ) | | 0 | 4 | 2 |