Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hargill-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.towns.find( {"sef_url":"hargill-tx"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.tokens.find( {"sef_url":{"$in":["usa","tx","hidalgo-county-tx","hargill-tx"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
4	db.events_cache.find( {"_id":"d34c9ac596205b6a3c5b9d19c16b9577"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
5	db.events_radius_cache.find( {"_id":"80150a6be70cac9eee3b8196fa791229"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
6	db.events.count( {"address.town_sef_url":"hargill-tx","start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768370400)"}} )	0	2
7	db.events.count( {"geo":{"$geoWithin":{"$center":[[-98.01349639892578,26.442800521850586],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768629600)"}} )	0	21
8	db.events.count( {"geo":{"$geoWithin":{"$center":[[-98.01349639892578,26.442800521850586],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1767765600)","$lt":"MongoDate(0.00000000 1768629600)"}} )	2	21
9	db.events_radius_cache.count( {"_id":"80150a6be70cac9eee3b8196fa791229"} )	0	1
10	db.events_radius_cache.insert( {"_id":"80150a6be70cac9eee3b8196fa791229","radius":25,"modified":"MongoDate(0.39000000 1767796893)","created":"MongoDate(0.39000000 1767796893)"} , true)	0	2
11	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1767765600)"},"geo":{"$geoWithin":{"$center":[[-98.01349639892578,26.442800521850586],0.36231884057971014]}}}, ["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( 16 ).skip( 0 )	16	9
12	db.events_cache.count( {"_id":"d34c9ac596205b6a3c5b9d19c16b9577"} )	0	1
13	db.events_cache.count( {"_id":"d34c9ac596205b6a3c5b9d19c16b9577"} )	0	1
14	db.events_cache.insert( {"_id":"d34c9ac596205b6a3c5b9d19c16b9577","town_sef_url":"hargill-tx","data_key":["6933210a4389be6be5656f94","69036aef4389be6be5f65147","6933210b4389be6be5657488","6933210b4389be6be56574a7","6933210d4389be6be5658467","6933210e4389be6be5658bdb","69036af44389be6be5f67ac3","6933210e4389be6be5658f78","6933210f4389be6be565980d","69036af84389be6be5f699e6","693321114389be6be565a734","69036afa4389be6be5f6a6f2","68a75b7803a70639b6cfb47c","69036afc4389be6be5f6b9a4","693321144389be6be565bf66"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Hargill Featured Events\",\"keyword\":\"\",\"radius\":25,\"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\":26.442800521850586,\"lng\":-98.01349639892578,\"latlng\":\"26.442800521851,-98.013496398926\",\"city\":\"Hargill\",\"state\":\"TX\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.41800000 1767796893)","created":"MongoDate(0.41800000 1767796893)"} , true)	0	1

Hargill

Texas

Hargill Featured Events

Rio Grande Valley Vipers vs. Greensboro Swarm

Rehash

Rio Grande Valley Vipers vs. Greensboro Swarm

TDJ

Rio Grande Valley Vipers vs. South Bay Lakers

Rio Grande Valley Vipers vs. South Bay Lakers

Pianomania - Rockin' the 1950s with Jared Freidburg

Rio Grande Valley Vipers vs. Rip City Remix

Rio Grande Valley Vipers vs. Rip City Remix

Parker McCollum

Las Alucines - "Tu Nuevo Estilo de Vida" US Tour

Liverpool Legends

Tres Lagos Farmers' Market

Star Wars + Four Hands - Valley Symphony Orchestra

Rio Grande Valley Vipers vs. Austin Spurs

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million people
rely on AmericanTowns each year to find & share local information.

Hargill Featured Events

COVID-19 Resources

List Your Organization

Post An Event

Submit A News Release

Free: See How You're Listed

Improve Your Listing

New Businesses

20 million peoplerely on AmericanTowns each year to find & share local information.

20 million people
rely on AmericanTowns each year to find & share local information.