| 1 | db.towns.find( {"sef_url":"philadelphia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 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 | 1 |
| 3 | db.towns.find( {"sef_url":"philadelphia-pa"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.tokens.find( {"sef_url":{"$in":["usa","pa","philadelphia-county-pa","philadelphia-pa"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 5 | db.events_cache.find( {"_id":"44944eb246e9745fa67601fdec9948a1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 6 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765087200)"},"tags":"halloween-event","geo":{"$geoWithin":{"$center":[[-75.16380310058594,39.95159912109375],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 | 1 |
| 7 | db.events_cache.count( {"_id":"44944eb246e9745fa67601fdec9948a1"} ) | | 0 | 0 | 1 |
| 8 | db.events_cache.insert( {"_id":"44944eb246e9745fa67601fdec9948a1","town_sef_url":"philadelphia-pa","data_key":[],"sort_order":{"start":1},"params":"{\"show\":10,\"title\":\"Find Pennsylvania 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\":39.95159912109375,\"lng\":-75.16380310058594,\"latlng\":\"39.951599121094,-75.163803100586\",\"city\":\"Philadelphia\",\"state\":\"PA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":false}","modified":"MongoDate(0.88700000 1765118922)","created":"MongoDate(0.88700000 1765118922)"} , true) | | 0 | 0 | 8 |
| 9 | db.places.find( {"geo":{"$near":[-75.16380310058594,39.95159912109375],"$maxDistance":1.0869565217391304},"tags":"haunted"}, [] ).sort( [] ).limit( 11 ).skip( 0 ) | | 0 | 11 | 23 |
| 10 | db.news.find( {"broadcast":{"$in":["usa","philadelphia-pa","pa","philadelphia-county-pa"]}}, [] ).sort( {"publish_date":-1} ).limit( 4 ).skip( 0 ) | | 0 | 4 | 1 |