| 1 | db.towns.find( {"sef_url":"cope-co"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 5 |
| 2 | db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 3 | db.towns.find( {"sef_url":"san-gabriel-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 | 2 |
| 5 | db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
| 6 | db.ttd_towns.find( {"town_sef_url":"san-gabriel-ca","name":"Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 2 |
| 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 | 3 |
| 9 | db.modules.find( {"name":"AT - Article Slideshow"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 10 | db.articles.find( {"aggregate":[{"$geoNear":{"near":[-118.0999984741211,34.094200134277344],"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(1769983518299)","$publish_date"]},86400000]},"relevance_score":{"$add":[{"$multiply":["$distance",10]},{"$divide":[{"$subtract":["MongoDB\\BSON\\UTCDateTime(1769983518299)","$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 | 53 |
| 11 | db.ttd_towns.find( {"town_sef_url":"san-gabriel-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":"fa467396d5a4f1e04d1368ba7640f269"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 3 |
| 14 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770616799)"},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 54 |
| 15 | db.events_cache.count( {"_id":"fa467396d5a4f1e04d1368ba7640f269"} ) | | 0 | 0 | 1 |
| 16 | db.events_cache.count( {"_id":"fa467396d5a4f1e04d1368ba7640f269"} ) | | 0 | 0 | 1 |
| 17 | db.events_cache.insert( {"_id":"fa467396d5a4f1e04d1368ba7640f269","town_sef_url":"san-gabriel-ca","data_key":["690c0699de4ae56f5a9c123c"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"15\",\"days\":\"7\",\"show\":1,\"geo\":[-118.0999984741211,34.094200134277344],\"has_next_page\":true}","modified":"MongoDate(0.44500000 1769983518)","created":"MongoDate(0.44500000 1769983518)"} , true) | | 0 | 0 | 2 |
| 18 | db.events_cache.find( {"_id":"f6f1c34bf3be13db75760a4d6451f9ac"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 19 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770616799)"},"event_id":{"$nin":[76305013]},"tags":"music","geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 2 | 5 |
| 20 | db.events_cache.count( {"_id":"f6f1c34bf3be13db75760a4d6451f9ac"} ) | | 0 | 0 | 1 |
| 21 | db.events_cache.count( {"_id":"f6f1c34bf3be13db75760a4d6451f9ac"} ) | | 0 | 0 | 1 |
| 22 | db.events_cache.insert( {"_id":"f6f1c34bf3be13db75760a4d6451f9ac","town_sef_url":"san-gabriel-ca","data_key":["690ee1d9de4ae56f5a2912c7"],"sort_order":{"start":1},"params":"{\"tags\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"show\":1,\"geo\":[-118.0999984741211,34.094200134277344],\"has_next_page\":true}","modified":"MongoDate(0.47400000 1769983518)","created":"MongoDate(0.47400000 1769983518)"} , true) | | 0 | 0 | 1 |
| 23 | db.events_cache.find( {"_id":"9f9035cb10201583792e5281b0cc8cc7"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 24 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770271199)"},"event_id":{"$nin":[76305013,76313630]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 2 |
| 25 | db.events_cache.count( {"_id":"9f9035cb10201583792e5281b0cc8cc7"} ) | | 0 | 0 | 1 |
| 26 | db.events_cache.count( {"_id":"9f9035cb10201583792e5281b0cc8cc7"} ) | | 0 | 0 | 1 |
| 27 | db.events_cache.insert( {"_id":"9f9035cb10201583792e5281b0cc8cc7","town_sef_url":"san-gabriel-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"15\",\"days\":\"3\",\"show\":1,\"geo\":[-118.0999984741211,34.094200134277344],\"has_next_page\":false}","modified":"MongoDate(0.49500000 1769983518)","created":"MongoDate(0.49500000 1769983518)"} , true) | | 0 | 0 | 1 |
| 28 | db.events_cache.find( {"_id":"3e511540a05bd4beb4b9780d84bd8726"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 29 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1772603999)"},"event_id":{"$nin":[76305013,76313630]},"tags":"festivals","geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 2 |
| 30 | db.events_cache.count( {"_id":"3e511540a05bd4beb4b9780d84bd8726"} ) | | 0 | 0 | 1 |
| 31 | db.events_cache.count( {"_id":"3e511540a05bd4beb4b9780d84bd8726"} ) | | 0 | 0 | 1 |
| 32 | db.events_cache.insert( {"_id":"3e511540a05bd4beb4b9780d84bd8726","town_sef_url":"san-gabriel-ca","data_key":[],"sort_order":{"start":1},"params":"{\"tags\":\"festivals\",\"radius\":\"60\",\"days\":\"30\",\"show\":1,\"geo\":[-118.0999984741211,34.094200134277344],\"has_next_page\":false}","modified":"MongoDate(0.51800000 1769983518)","created":"MongoDate(0.51800000 1769983518)"} , true) | | 0 | 0 | 2 |
| 33 | db.events_cache.find( {"_id":"ad606f23695f661ee3b79c74a1b9eb5b"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 34 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770443999)"},"event_id":{"$nin":[76305013,76313630]},"tags":"arts-and-entertainment","geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 2 | 17 |
| 35 | db.events_cache.count( {"_id":"ad606f23695f661ee3b79c74a1b9eb5b"} ) | | 0 | 0 | 1 |
| 36 | db.events_cache.count( {"_id":"ad606f23695f661ee3b79c74a1b9eb5b"} ) | | 0 | 0 | 1 |
| 37 | db.events_cache.insert( {"_id":"ad606f23695f661ee3b79c74a1b9eb5b","town_sef_url":"san-gabriel-ca","data_key":["69718d9eb1faf7c56a497e55"],"sort_order":{"start":1},"params":"{\"tags\":\"arts-and-entertainment\",\"radius\":\"10\",\"days\":\"5\",\"show\":1,\"geo\":[-118.0999984741211,34.094200134277344],\"has_next_page\":true}","modified":"MongoDate(0.56800000 1769983518)","created":"MongoDate(0.56800000 1769983518)"} , true) | | 0 | 0 | 1 |
| 38 | db.events_cache.find( {"_id":"6c13af6026799781bf5c9c31202389ce"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 39 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1771826399)"},"event_id":{"$nin":[76305013,76313630,76464673]},"tags":"ticketmaster","geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 13 |
| 40 | db.events_cache.count( {"_id":"6c13af6026799781bf5c9c31202389ce"} ) | | 0 | 0 | 1 |
| 41 | db.events_cache.count( {"_id":"6c13af6026799781bf5c9c31202389ce"} ) | | 0 | 0 | 1 |
| 42 | db.events_cache.insert( {"_id":"6c13af6026799781bf5c9c31202389ce","town_sef_url":"san-gabriel-ca","data_key":["6967019cb1faf7c56a6c9a40","68ca1ba4c3af739f25d822be","690c0699de4ae56f5a9c1240","69460893de4ae56f5aecd8a4","69378813de4ae56f5aeceb32","693cce12de4ae56f5ae9835f","68bf8fa6c3af739f25b3829c","6892ce41fb5e4bed1f90b503","68afbdafc3af739f2536a186","69017a9cc3af739f25e3ff7c","693a2b11de4ae56f5a8b01ff","69757e99b1faf7c56a25ea39","691fcd1ade4ae56f5a67f6c4","693cce12de4ae56f5ae98365","6944b711de4ae56f5ab96ab2","6892ce41fb5e4bed1f90b5ed","694b4e90de4ae56f5a55a315","68a7d4aec3af739f25824175","692f9f13de4ae56f5a52361d","69460893de4ae56f5aecd8c9","69718d9eb1faf7c56a497def","69378813de4ae56f5aeceb44","68e86e1dc3af739f2521842d","69587d8ede4ae56f5af46cf8","6972df1eb1faf7c56a4b8465","689eabbefb5e4bed1f7b4040","68f6ee9cc3af739f25829c38","692baa93de4ae56f5a18b049","6955da90de4ae56f5aaa02c0","69718d9eb1faf7c56a497e22","68a7d4aec3af739f25824199","695f150eb1faf7c56aac1406","6955da90de4ae56f5aaa02ca","695dc38db1faf7c56a6c0bf4","6972df1eb1faf7c56a4b8482","69757e99b1faf7c56a25ea63","68e5cb20c3af739f25c786ab","6895714afb5e4bed1fd7793a","68dc90a0c3af739f25fd3353","6902cc1c3394d74e7810c670","6944b711de4ae56f5ab96aed","68a7d4aec3af739f258241ad","68d35626c3af739f250210cd","69757e99b1faf7c56a25ea82","6900291dc3af739f259bb84e","691e7b9ade4ae56f5a810bd8","6944b711de4ae56f5ab96afd","69757e99b1faf7c56a25ea8d","6896c2c5fb5e4bed1f1b54d5","69460893de4ae56f5aecd928"],"sort_order":{"start":1},"params":"{\"tags\":\"ticketmaster\",\"radius\":\"100\",\"days\":\"21\",\"show\":50,\"geo\":[-118.0999984741211,34.094200134277344],\"has_next_page\":true}","modified":"MongoDate(0.61100000 1769983518)","created":"MongoDate(0.61100000 1769983518)"} , true) | | 0 | 0 | 1 |
| 43 | 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-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-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-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-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-milkshake-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/milkshakes\/\" target=\"_blank\">8 Best Milkshakes 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\/milkshakes\/\" target=\"_blank\">Fair Oaks Pharmacy & Soda Fountain, 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 & Soda Fountain is an homage to a simpler time with counter seating, a few tables and some of the best milkshakes around, with no less than a pint of the good stuff in each… <a href=\"https:\/\/bestthingsca.com\/milkshakes\/\" 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-wings-1.jpg);\">\n\n\t\t\t\t\t<div class=\"carousel-caption\">\n\t\t\t\t<h4><a href=\"https:\/\/bestthingsca.com\/wings\/\" target=\"_blank\">The 9 Best Spots for Wings 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\/wings\/\" target=\"_blank\">Broaster Kitchen, Montebello, 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\">Broaster Kitchen is one of those locals only spots that when you find it, you’ll want to keep the secret too. Using a broaster cooking technique, the chicken is succulent and juicy every… <a href=\"https:\/\/bestthingsca.com\/wings\/\" 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<\/div>\n<\/div>\n\n\n","town_sef_url":"san-gabriel-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":1769987118,"type":"Event","id":76305013,"title":"Live Racing at Santa Anita Park","url":"\/event\/live-racing-at-santa-anita-park-2026-02-01-tm-arcadia-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/103\/d3d93213-268e-4079-89e8-45806314b103_SOURCE"},{"rule":"{\"content_type\":\"event_tag\",\"searchtag\":\"music\",\"radius\":\"10\",\"days\":\"7\",\"ttl\":\"1\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/music-3.jpg\"}","expiration":1769987118,"type":"Event","id":76313630,"title":"Hatchie","url":"\/event\/hatchie-2026-02-05-jb-los-angeles-ca.html","image_url":"https:\/\/www.jambase.com\/wp-content\/uploads\/2023\/03\/hatchie-5-980x551.png"},{"rule":"{\"content_type\":\"event_category\",\"radius\":\"10\",\"days\":\"5\",\"ttl\":\"1\",\"isempty\":1,\"event_category\":\"arts-and-entertainment\",\"thumbnail\":\"https:\\\/imgcdn.americantowns.com\\\/img\\\/uploads\\\/banner-images\\\/festivals-1.jpg\"}","expiration":1769987118,"type":"Event","id":76464673,"title":"ELI - THE ONE WOMAN SHOW","url":"\/event\/eli-the-one-woman-show-2026-02-03-tm-los-angeles-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/ce3\/680764fc-4c1f-46da-b0a1-19951c90fce3_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":1769997918,"type":"Event","id":76184845,"title":"The Book of Mormon (Touring)","url":"\/event\/the-book-of-mormon-touring-2026-02-03-tm-los-angeles-ca.html","image_url":"https:\/\/s1.ticketm.net\/dam\/a\/70c\/f8408501-c120-4b57-a857-a1711722970c_SOURCE"}],"modified":"MongoDate(0.61400000 1769983518)","created":"MongoDate(0.61400000 1769983518)","_id":ObjectId ("697fce1ee45461143503605e")} , true) | | 0 | 0 | 2 |
| 44 | db.events_cache.find( {"_id":"d46a33aa95a65de9e0005663d1329d27"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 45 | db.events_radius_cache.find( {"_id":"c51717b953a868593eb4e06f1c9b7e41"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 0 | 1 |
| 46 | db.events.count( {"address.town_sef_url":"san-gabriel-ca","start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770530400)"}} ) | | 0 | 0 | 2 |
| 47 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} ) | | 0 | 10 | 22 |
| 48 | db.events.count( {"geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1769925600)","$lt":"MongoDate(0.00000000 1770789600)"}} ) | | 0 | 79 | 22 |
| 49 | db.events_radius_cache.count( {"_id":"c51717b953a868593eb4e06f1c9b7e41"} ) | | 0 | 0 | 1 |
| 50 | db.events_radius_cache.count( {"_id":"c51717b953a868593eb4e06f1c9b7e41"} ) | | 0 | 0 | 1 |
| 51 | db.events_radius_cache.insert( {"_id":"c51717b953a868593eb4e06f1c9b7e41","radius":15,"modified":"MongoDate(0.68600000 1769983518)","created":"MongoDate(0.68600000 1769983518)"} , true) | | 0 | 0 | 1 |
| 52 | db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1769925600)"},"event_id":{"$nin":[76305013,76313630,76464673,76184845]},"geo":{"$geoWithin":{"$center":[[-118.0999984741211,34.094200134277344],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 | 175 |
| 53 | db.events_cache.count( {"_id":"d46a33aa95a65de9e0005663d1329d27"} ) | | 0 | 0 | 1 |
| 54 | db.events_cache.count( {"_id":"d46a33aa95a65de9e0005663d1329d27"} ) | | 0 | 0 | 1 |
| 55 | db.events_cache.insert( {"_id":"d46a33aa95a65de9e0005663d1329d27","town_sef_url":"san-gabriel-ca","data_key":["693cce12de4ae56f5ae9835f","6906f8d9de4ae56f5a377633","6933cbd9de4ae56f5a4a7b1b","68a7d4aec3af739f25824175","692f9f13de4ae56f5a52361d"],"sort_order":{"start":1},"params":"{\"show\":5,\"title\":\"Events Around San Gabriel\",\"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.094200134277344,\"lng\":-118.0999984741211,\"latlng\":\"34.094200134277,-118.09999847412\",\"city\":\"San Gabriel\",\"state\":\"CA\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.88300000 1769983518)","created":"MongoDate(0.88300000 1769983518)"} , true) | | 0 | 0 | 1 |
| 56 | db.news.find( {"broadcast":{"$in":["usa","san-gabriel-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 | 3 |
| 57 | db.places.find( {"address.town_sef_url":"san-gabriel-ca","group_type":"organization"}, [] ).sort( {"created":-1} ).limit( 6 ).skip( 0 ) | | 0 | 6 | 3 |
| 58 | db.answerbook.find( {"featured":true,"category_sef_tail":"home"}, [] ).sort( {"answers":-1,"modified":-1} ).limit( 15 ).skip( 0 ) | | 0 | 0 | 2 |
| 59 | db.answerbook_categories.find( [], ["sef_tail","name"] ).sort( {"category_sequence":1} ).limit( 0 ).skip( 0 ) | | 0 | 40 | 1 |
| 60 | db.towns.find( {"sef_url":"san-gabriel-ca"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 61 | db.tokens.find( {"sef_url":{"$in":["usa","ca","los-angeles-county-ca","san-gabriel-ca"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 ) | | 0 | 4 | 2 |
| 62 | db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 2 |
| 63 | db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 64 | db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 65 | db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 66 | db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 67 | db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
| 68 | db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 ) | | 0 | 1 | 1 |
