Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"cortland-ny"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	6
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
3	db.towns.find( {"sef_url":"clearwater-fl"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["events","events\/shops-and-stores"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["Header Menu Main","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"0bf5450ca4819a42a31b42cc8efaadae"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"f6d760d98e9fc12ccbcf003329b95442"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"clearwater-fl","start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767420000)"}} )	6	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-82.74620056152344,27.981300354003906],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	14	19
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-82.74620056152344,27.981300354003906],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1766815200)","$lt":"MongoDate(0.00000000 1767679200)"}} )	16	17
11	db.events_radius_cache.count( {"_id":"f6d760d98e9fc12ccbcf003329b95442"} )	0	1
12	db.events_radius_cache.count( {"_id":"f6d760d98e9fc12ccbcf003329b95442"} )	0	1
13	db.events_radius_cache.insert( {"_id":"f6d760d98e9fc12ccbcf003329b95442","radius":15,"modified":"MongoDate(0.06200000 1766830782)","created":"MongoDate(0.06200000 1766830782)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1766815200)"},"tags":"shops-and-stores","geo":{"$geoWithin":{"$center":[[-82.74620056152344,27.981300354003906],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( 16 ).skip( 0 )	16	3
15	db.events_cache.count( {"_id":"0bf5450ca4819a42a31b42cc8efaadae"} )	0	1
16	db.events_cache.count( {"_id":"0bf5450ca4819a42a31b42cc8efaadae"} )	0	1
17	db.events_cache.insert( {"_id":"0bf5450ca4819a42a31b42cc8efaadae","town_sef_url":"clearwater-fl","data_key":["6864f195fb5e4bed1f3a30b0","686e2c01fb5e4bed1fcfab1f","6877666efb5e4bed1fb4d13b","6880a144fb5e4bed1f9552e5","6889db8afb5e4bed1fad47f1","6892ce40fb5e4bed1f90b277","689c08befb5e4bed1f1f9975","68a5433ffb5e4bed1febcab2","68ae4c87c3af739f25822c87","68b78708c3af739f2540bb20","68c0c185c3af739f2501cd78","68c9fc02c3af739f259842eb","68d33681c3af739f25c72b1c","68dc7101c3af739f25c0f18e","68e5ab7cc3af739f25a9ffde"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Clearwater Featured Events<br>Shops And Stores\",\"keyword\":\"\",\"radius\":15,\"limit\":15,\"page\":1,\"sef\":\"shops-and-stores\",\"tags\":\"shops-and-stores\",\"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\":27.981300354003906,\"lng\":-82.74620056152344,\"latlng\":\"27.981300354004,-82.746200561523\",\"city\":\"Clearwater\",\"state\":\"FL\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.08800000 1766830782)","created":"MongoDate(0.08800000 1766830782)"} , true)	0	1
18	db.towns.find( {"sef_url":"clearwater-fl"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","fl","pinellas-county-fl","clearwater-fl"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	2
21	db.modules.find( {"name":"AT - Header Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
22	db.modules.find( {"name":"AT - Nearby Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
23	db.modules.find( {"name":"AT - Nav Bar"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
24	db.modules.find( {"name":"CV Cancel"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
25	db.modules.find( {"name":"AT - Footer Section"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
26	db.modules.find( {"name":"AT - Footer Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1

Clearwater

Florida

Clearwater Featured Events
Shops And Stores

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

Sunday Market in the Park

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.

Clearwater Featured EventsShops And Stores

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.

Clearwater Featured Events
Shops And Stores

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