| 1 | db.towns.find( {"sef_url":"eucha-ok"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 4 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 3 | db.towns.find( {"sef_url":"sierra-madre-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 4 | db.pages.find( {"type":"town","slug":{"$in":["home"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 6 | db.ttd_towns.find( {"town_sef_url":"sierra-madre-ca","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 7 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 8 | db.modules.find( {"module_id":"1022"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-118.05000305175781,34.16189956665039],"distanceField":"distance","distanceMultiplier":3963.2,"maxDistance":0.025232135647961243,"spherical":true,"query":{"tags":"at-bt-articles-home","state":"CA"}}},{"$project":{"title":1,"homepage_title":1,"tags":1,"image_url":1,"distance":1,"page_path":1,"path":1,"article_hostname":1,"text":1,"publish_date":1,"site_canonical":1,"sections.title":1,"sections.geo":1,"sections.text":1}},{"$addFields":{"days_since":{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769850833873)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769850833873)","$publish_date"]},86400000]}]}}},{"$sort":{"relevance_score":1,"_id":1}},{"$skip":0},{"$limit":11}]}, ["article_id","title","homepage_title","tags","image_url","path","article_hostname","sef_tail","page_path","text","publish_date","site_canonical","sections.title","sections.text"] ).sort( {"relevance_score":1,"_id":1} ).limit( 11 ).skip( 0 ) | | 0 | 11 | 28 |
| 11 | db.ttd_towns.find( {"town_sef_url":"sierra-madre-ca","name":"Article Slideshow"}, {"TtdTown._id":1} ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 0 | 1 |
| 12 | db.ttd.find( {"name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 13 | db.events_cache.find( {"_id":"37a2651402e9c6f4aeadfa66036cf4c5"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],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( 2 ).skip( 0 ) | | 0 | 2 | 38 |
| 15 | db.events_cache.count( {"_id":"37a2651402e9c6f4aeadfa66036cf4c5"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"37a2651402e9c6f4aeadfa66036cf4c5"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"37a2651402e9c6f4aeadfa66036cf4c5","town_sef_url":"sierra-madre-ca","data_key":["69757e98b1faf7c56a25e9bb"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":true}","modified":"MongoDate(0.97800000 1769850833)","created":"MongoDate(0.97800000 1769850833)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"b0dddd2bf162bd10d2624805e6e719ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770530399)"},"event_id":{"$nin":[76469075]},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],0.14492753623188406]}}}, ["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( 2 ).skip( 0 ) | | 0 | 0 | 4 |
| 20 | db.events_cache.count( {"_id":"b0dddd2bf162bd10d2624805e6e719ca"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"b0dddd2bf162bd10d2624805e6e719ca"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"b0dddd2bf162bd10d2624805e6e719ca","town_sef_url":"sierra-madre-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":false}","modified":"MongoDate(0.00300000 1769850834)","created":"MongoDate(0.00300000 1769850834)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"02d9dfa221c311542a45e3ccaab27917"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771135199)"},"event_id":{"$nin":[76469075]},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],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( 2 ).skip( 0 ) | | 0 | 2 | 5 |
| 25 | db.events_cache.count( {"_id":"02d9dfa221c311542a45e3ccaab27917"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"02d9dfa221c311542a45e3ccaab27917"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"02d9dfa221c311542a45e3ccaab27917","town_sef_url":"sierra-madre-ca","data_key":["6922a856de4ae56f5af6a01e"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":true}","modified":"MongoDate(0.02500000 1769850834)","created":"MongoDate(0.02500000 1769850834)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"5792bc9145051913014c34195229d19f"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770184799)"},"event_id":{"$nin":[76469075,76367601]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],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( 2 ).skip( 0 ) | | 0 | 0 | 1 |
| 30 | db.events_cache.count( {"_id":"5792bc9145051913014c34195229d19f"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"5792bc9145051913014c34195229d19f"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"5792bc9145051913014c34195229d19f","town_sef_url":"sierra-madre-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":false}","modified":"MongoDate(0.04300000 1769850834)","created":"MongoDate(0.04300000 1769850834)"} , true) | | 0 | 0 | 1 |
| 33 | db.events_cache.find( {"_id":"c9cef226ee8fa236401ec139488fae8c"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1772517599)"},"event_id":{"$nin":[76469075,76367601]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],0.8695652173913043]}}}, ["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( 2 ).skip( 0 ) | | 0 | 0 | 1 |
| 35 | db.events_cache.count( {"_id":"c9cef226ee8fa236401ec139488fae8c"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"c9cef226ee8fa236401ec139488fae8c"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"c9cef226ee8fa236401ec139488fae8c","town_sef_url":"sierra-madre-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":false}","modified":"MongoDate(0.06000000 1769850834)","created":"MongoDate(0.06000000 1769850834)"} , true) | | 0 | 0 | 2 |
| 38 | db.events_cache.find( {"_id":"6f413dfcbb30eb7ccb8301b14fbc8371"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770357599)"},"event_id":{"$nin":[76469075,76367601]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],0.14492753623188406]}}}, ["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( 2 ).skip( 0 ) | | 0 | 0 | 11 |
| 40 | db.events_cache.count( {"_id":"6f413dfcbb30eb7ccb8301b14fbc8371"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"6f413dfcbb30eb7ccb8301b14fbc8371"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"6f413dfcbb30eb7ccb8301b14fbc8371","town_sef_url":"sierra-madre-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":false}","modified":"MongoDate(0.09600000 1769850834)","created":"MongoDate(0.09600000 1769850834)"} , true) | | 0 | 0 | 1 |
| 43 | db.events_cache.find( {"_id":"e09363ef61cc86d1129ca79d507d0706"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 44 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771221599)"},"event_id":{"$nin":[76469075,76367601]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],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( 2 ).skip( 0 ) | | 0 | 2 | 31 |
| 45 | db.events_cache.count( {"_id":"e09363ef61cc86d1129ca79d507d0706"} ) | | 0 | 0 | 1 |
| 46 | db.events_cache.count( {"_id":"e09363ef61cc86d1129ca79d507d0706"} ) | | 0 | 0 | 1 |
| 47 | db.events_cache.insert( {"_id":"e09363ef61cc86d1129ca79d507d0706","town_sef_url":"sierra-madre-ca","data_key":["68f6ee9cc3af739f25829ba1"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"15\",\"days\":\"15\",\"show\":1,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":true}","modified":"MongoDate(0.14600000 1769850834)","created":"MongoDate(0.14600000 1769850834)"} , true) | | 0 | 0 | 1 |
| 48 | db.events_cache.find( {"_id":"f9e2e2546ab069d7f75a41ed6d40df86"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 49 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1771739999)"},"event_id":{"$nin":[76469075,76367601,76258132]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],1.4492753623188406]}}}, ["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( 51 ).skip( 0 ) | | 0 | 51 | 7 |
| 50 | db.events_cache.count( {"_id":"f9e2e2546ab069d7f75a41ed6d40df86"} ) | | 0 | 0 | 1 |
| 51 | db.events_cache.count( {"_id":"f9e2e2546ab069d7f75a41ed6d40df86"} ) | | 0 | 0 | 1 |
| 52 | db.events_cache.insert( {"_id":"f9e2e2546ab069d7f75a41ed6d40df86","town_sef_url":"sierra-madre-ca","data_key":["68911579fb5e4bed1fbe4e2e","694b4e8fde4ae56f5a55a231","690c0699de4ae56f5a9c11c4","68ca1ba4c3af739f25d82223","694b4e8fde4ae56f5a55a237","68e5cb20c3af739f25c785c0","691bd895de4ae56f5a7c0ea9","694b4e8fde4ae56f5a55a23d","6902cc1c3394d74e7810c5aa","69339393de4ae56f5aea2f62","68bf8fa6c3af739f25b38190","695c720ede4ae56f5a66514e","68b7a6abc3af739f2571f79c","68917cc1fb5e4bed1f5901af","6938d995de4ae56f5aaaa1c9","68917cc1fb5e4bed1f59023e","68917cc1fb5e4bed1f5902cf","68ec62a5c3af739f25df9f80","69081219de4ae56f5af7c703","691fcd1ade4ae56f5a67f633","69378813de4ae56f5aecead5","693a2b13de4ae56f5a8b0c73","69509491de4ae56f5a6f4c91","69684f9ab1faf7c56a24a71e","69718d9eb1faf7c56a497d29","6979769db1faf7c56a2a042c","68917cc1fb5e4bed1f59031b","68d89c25c3af739f2531a21e","68bb9b27c3af739f2533ab09","68d4a7a5c3af739f25451cb6","68edb41dc3af739f2514c7fb","68ef05a0c3af739f254c08df","68f84021c3af739f25e005f1","68fc34a1c3af739f25227011","6909639ade4ae56f5a1c0de6","690ab51fde4ae56f5a841809","690d581bde4ae56f5ac125c9","69266495de4ae56f5ae4902f","69363696de4ae56f5a26aebe","69421412de4ae56f5ac6abd7","68917cc1fb5e4bed1f59054b","69017a9cc3af739f25e3ff28","6967019cb1faf7c56a6c9a17","6969a117b1faf7c56adbece5","68917cc1fb5e4bed1f590574","68e08523c3af739f25467ad0","691d2a16de4ae56f5a437c7d","693cce12de4ae56f5ae98358","6961b80eb1faf7c56a229a61","68f991a1c3af739f2535ae31"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-118.05000305175781,34.16189956665039],\"has_next_page\":true}","modified":"MongoDate(0.17200000 1769850834)","created":"MongoDate(0.17200000 1769850834)"} , true) | | 0 | 0 | 1 |
| 53 | db.ttd_towns.insert( {"name":"Article Slideshow","main_slot_type":"module","main_slot_module_id":"1022","main_slot_html":"<div id=\"atCarousel\" class=\"carousel slide\" data-interval=\"5000\" data-ride=\"carousel\">\n\t<ol class=\"carousel-indicators\">\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"0\" class=\"active\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"1\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"2\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"3\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"4\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"5\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"6\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"7\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"8\" class=\"\"><\/li>\n\t\t\t\t<li data-target=\"#atCarousel\" data-slide-to=\"9\" class=\"\"><\/li>\n\t\t\t<\/ol> \n\t<div class=\"carousel-inner\">\n\t\t\t\t<div class=\"item active\" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-burger-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/burgers\/\" target=\"_blank\">10 Best Burgers in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/burgers\/\" target=\"_blank\">Pie N\u2019 Burger, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Pasadena claims to be the birthplace of the cheeseburger. The spot known for the creation is no longer around, but you can get an approximation at Pie N’ Burger, a local secret that is poorly… <a href=\"https:\/\/bestthingsca.com\/burgers\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-furniture-store-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/furniture-stores\/\" target=\"_blank\">The 10 Best Furniture Stores in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/furniture-stores\/\" target=\"_blank\">Gold Bug, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Gold Bug in Pasadena isn’t your average antiques mall. The shop if filled with curious finds from days of yore including everything from jewelry to furniture and creative ways to display it.… <a href=\"https:\/\/bestthingsca.com\/furniture-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-italian-restaurant-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/italian-restaurants\/\" target=\"_blank\">10 Best Italian Restaurants in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/italian-restaurants\/\" target=\"_blank\">Grano Italian Restaurant & Wine Bar, Duarte, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-chira,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Grano Italian Restaurant and Wine Bar is a thing of class and beauty. Not only does the restaurant have a lovely atmosphere but the chef has an abundant menu of inclusive options too, like vegan,… <a href=\"https:\/\/bestthingsca.com\/italian-restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-antique-stores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/antique-stores\/\" target=\"_blank\">5 Best Antique Stores in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/antique-stores\/\" target=\"_blank\">Pasadena Antique Mall, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">The Pasadena Antique Mall is a vast place where you can find everything from crazy paintings to Polaroid cameras. Typewriters, odds and ends, entire dishware collections and bigger pieces fill every… <a href=\"https:\/\/bestthingsca.com\/antique-stores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-sports-bar-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/sports-bars\/\" target=\"_blank\">The 9 Best Sports Bars in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/sports-bars\/\" target=\"_blank\">T. Boyle\u2019s Tavern, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">T. Boyle’s Tavern is kind of like a hidden gem that everyone knows about. Just off of Colorado Boulevard, T. Boyle’s Tavern has cold beers and the kind of special events that only a… <a href=\"https:\/\/bestthingsca.com\/sports-bars\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-pubs-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/pubs\/\" target=\"_blank\">8 Best Pubs in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/pubs\/\" target=\"_blank\">Lucky Baldwins, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Transformed from a run-down business into a thriving and living pub and haven for English beer lovers, Lucky Baldwin Pubs are conveniently located in Pasadena and Sierra Madre, California. This is a… <a href=\"https:\/\/bestthingsca.com\/pubs\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-museums-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/museums\/\" target=\"_blank\">The 10 Best Museums in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/museums\/\" target=\"_blank\">The Huntington, San Marino, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,entertainment-bt,entertainment-p300,at-bt-articles-home,at-bt-articles-entertainment<\/div>\n\t\t\t\t<p class=\"small\"><p>The Huntington is a vast estate just outside of Pasadena that features a historic home, art collections, library and vast gardens that are artfully arranged.<\/p> <a href=\"https:\/\/bestthingsca.com\/museums\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-bookstores-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/bookstores\/\" target=\"_blank\">10 Best Bookstores in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/bookstores\/\" target=\"_blank\">Vroman\u2019s, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,directory-bt,directory-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-directory<\/div>\n\t\t\t\t<p class=\"small\">Vroman’s is an easily accessible bookstore right on Colorado Boulevard, Pasadena’s main drag. Easily organized into sections like all the major chain stores, Vroman’s also offers a… <a href=\"https:\/\/bestthingsca.com\/bookstores\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-big-food-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/big-food\/\" target=\"_blank\">8 Best Places for BIG Food in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/big-food\/\" target=\"_blank\">Fair Oaks Pharmacy, South Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\">Fair Oaks Pharmacy is a landmark old-school soda fountain that packs a generous portion into the entire menu. Go beyond the pint of ice cream found in the shakes and malts and head straight for the… <a href=\"https:\/\/bestthingsca.com\/big-food\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"item \" style=\"background-image:url(https:\/\/cdn-p300.americantowns.com\/img\/article\/ca-restaurants-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/restaurants\/\" target=\"_blank\">14 Best Restaurants in California!<\/a><\/h4>\n\t\t\t\t<div class=\"small\">Featuring<\/div>\n\t\t\t\t<h2><a href=\"https:\/\/bestthingsca.com\/restaurants\/\" target=\"_blank\">The Royce, Pasadena, CA<\/a><\/h2>\n\t\t\t\t<div class=\"d-none hidden\">evergreen,food-drink-bt,food-drink-p300,edited-cynthia,at-bt-articles-home,at-bt-articles-restaurant<\/div>\n\t\t\t\t<p class=\"small\"><p>Located in the stunning historic Langham Pasadena Hotel, The Royce is a modern steakhouse that showcases Pasadena's history of formal dining with a modern twist.<\/p> <a href=\"https:\/\/bestthingsca.com\/restaurants\/\" target=\"_blank\" class=\"text-nowrap\"><b>Read More<\/b><\/a><\/p>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t<\/div>\n<\/div>\n\n\n","town_sef_url":"sierra-madre-ca","title":"Hiking!","subtitle":"Maps, directions and reviews for hiking around {local_city_state}!","image_url":"{\"0\":{\"content_type\":\"movie\",\"movie\":\"\/movie\/black-panther-wakanda-forever-297863\/\",\"title\":\"Black Panther: Wakanda Forever\",\"thumbnail\":\"https:\/\/www.movienewsletters.net\/photos\/297863R4.jpg\"},\"1\":{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster","url":"\/{town_sef_url}\/hiking\/","slots":[{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769854433,"type":"Event","id":76469075,"title":"Los Angeles Dodgers Fanfest","url":"\/event\/los-angeles-dodgers-fanfest-2026-01-31-tm-los-angeles-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/c\/093\/c74cfd95-af21-4e64-9f85-47677b951093_105651_TABLET_LANDSCAPE_LARGE_16_9.jpg"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"15\",\"days\":\"14\",\"ttl\":\"2\",\"isempty\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1769858034,"type":"Event","id":76367601,"title":"The Album Leaf","url":"\/event\/the-album-leaf-2026-01-31-jb-los-angeles-ca.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2017\/04\/the-album-leaf-the-album-leaf-2312add8-22d5-421c-b0fb-0a6e49fed05f_204811_TABLET_LANDSCAPE_16_9-980x551.jpg"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"15\",\"days\":\"15\",\"ttl\":\"2\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/arts-2.jpg\"}","expiration":1769858034,"type":"Event","id":76258132,"title":"Cate","url":"\/event\/cate-2026-01-31-tm-los-angeles-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/e\/0a7\/ef21e683-46e0-40e4-a2c0-8b63f25d50a7_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"ttl\":\"4\",\"israndom\":1,\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-1.jpg\"}","expiration":1769865234,"type":"Event","id":76391650,"title":"Depeche Mode, The Cure, Pet Shop Boys Tributes - British Invasion at Garden Amp","url":"\/event\/depeche-mode-the-cure-pet-shop-boys-tributes-british-invasion-at-garden-amp-2026-01-31-tm-garden-grove-ca.html","image_url":"https:\/\/i.ticketweb.com\/i\/00\/12\/72\/97\/74_Edp.jpg?v=13"}],"modified":"MongoDate(0.17500000 1769850834)","created":"MongoDate(0.17500000 1769850834)","_id":ObjectId ("697dc7d238dbdd144305cc68")} , true) | | 0 | 0 | 1 |
| 54 | db.events_cache.find( {"_id":"d4a4c946edd3afbfbeabdb043a87c6b1"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 55 | db.events_radius_cache.find( {"_id":"d1f46822ff2958bbbb8a4ef29dd7d1cb"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 56 | db.events.count( {"address.town_sef_url":"sierra-madre-ca","start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770444000)"}} ) | | 0 | 0 | 1 |
| 57 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 8 | 17 |
| 58 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769839200)","$lt":"MongoDate(0.00000000 1770703200)"}} ) | | 0 | 22 | 17 |
| 59 | db.events_radius_cache.count( {"_id":"d1f46822ff2958bbbb8a4ef29dd7d1cb"} ) | | 0 | 0 | 1 |
| 60 | db.events_radius_cache.count( {"_id":"d1f46822ff2958bbbb8a4ef29dd7d1cb"} ) | | 0 | 0 | 1 |
| 61 | db.events_radius_cache.insert( {"_id":"d1f46822ff2958bbbb8a4ef29dd7d1cb","radius":15,"modified":"MongoDate(0.23500000 1769850834)","created":"MongoDate(0.23500000 1769850834)"} , true) | | 0 | 0 | 1 |
| 62 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769839200)"},"event_id":{"$nin":[76469075,76367601,76258132,76391650]},"geo":{"$geoWithin":{"$center":[[-118.05000305175781,34.16189956665039],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( 6 ).skip( 0 ) | | 0 | 6 | 44 |
| 63 | db.events_cache.count( {"_id":"d4a4c946edd3afbfbeabdb043a87c6b1"} ) | | 0 | 0 | 1 |
| 64 | db.events_cache.count( {"_id":"d4a4c946edd3afbfbeabdb043a87c6b1"} ) | | 0 | 0 | 1 |
| 65 | db.events_cache.insert( {"_id":"d4a4c946edd3afbfbeabdb043a87c6b1","town_sef_url":"sierra-madre-ca","data_key":["690c0699de4ae56f5a9c11c4","68f991a1c3af739f2535ae31","690c0699de4ae56f5a9c123c","69718d9eb1faf7c56a497e55","690ee1d9de4ae56f5a2912c7"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around Sierra Madre\",\"keyword\":\"\",\"radius\":15,\"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\":34.16189956665039,\"lng\":-118.05000305175781,\"latlng\":\"34.16189956665,-118.05000305176\",\"city\":\"Sierra Madre\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.30100000 1769850834)","created":"MongoDate(0.30100000 1769850834)"} , true) | | 0 | 0 | 1 |
| 66 | db.news.find( {"broadcast":{"$in":["usa","sierra-madre-ca","ca","los-angeles-county-ca"]},"$and":[{"tags":{"$ne":"at-p-opinion"}},{"tags":{"$ne":"p-opinion"}}]}, [] ).sort( {"publish_date":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 2 |
| 67 | db.places.find( {"address.town_sef_url":"sierra-madre-ca","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 1 |
| 68 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 1 |
| 69 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 70 | db.towns.find( {"sef_url":"sierra-madre-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 71 | db.tokens.find( {"sef_url":{"$in":["usa","ca","los-angeles-county-ca","sierra-madre-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 1 |
| 72 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 73 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 74 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 75 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 76 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 77 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 78 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
