Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"bogota-tn"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["americantowns.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.towns.find( {"sef_url":"pinopolis-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	8
4	db.pages.find( {"type":"town","slug":{"$in":["events"]},"site.hostname":"americantowns.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	5
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":"4fb3efa20bdea81d3a69bbf33dee86c3"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	2
7	db.events_radius_cache.find( {"_id":"5637810b0d8413551cc6e96e1892afd2"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	0	1
8	db.events.count( {"address.town_sef_url":"pinopolis-sc","start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766383200)"}} )	0	1
9	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.03780364990234,33.226200103759766],0.10144927536231885]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	0	25
10	db.events.count( {"geo":{"$geoWithin":{"$center":[[-80.03780364990234,33.226200103759766],0.21739130434782608]}},"start":{"$gte":"MongoDate(0.00000000 1765778400)","$lt":"MongoDate(0.00000000 1766642400)"}} )	1	27
11	db.events_radius_cache.count( {"_id":"5637810b0d8413551cc6e96e1892afd2"} )	0	1
12	db.events_radius_cache.count( {"_id":"5637810b0d8413551cc6e96e1892afd2"} )	0	1
13	db.events_radius_cache.insert( {"_id":"5637810b0d8413551cc6e96e1892afd2","radius":25,"modified":"MongoDate(0.76600000 1765798926)","created":"MongoDate(0.76600000 1765798926)"} , true)	0	1
14	db.events.find( {"start":{"$gte":"MongoDate(0.00000000 1765778400)"},"geo":{"$geoWithin":{"$center":[[-80.03780364990234,33.226200103759766],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	214
15	db.events_cache.count( {"_id":"4fb3efa20bdea81d3a69bbf33dee86c3"} )	0	1
16	db.events_cache.count( {"_id":"4fb3efa20bdea81d3a69bbf33dee86c3"} )	0	1
17	db.events_cache.insert( {"_id":"4fb3efa20bdea81d3a69bbf33dee86c3","town_sef_url":"pinopolis-sc","data_key":["6857c25cfb5e4bed1f86ff29","685a65b0fb5e4bed1f6595cb","68a7d4adc3af739f25823907","68bf8fa5c3af739f25b37206","68a7d4adc3af739f25823965","691fcd18de4ae56f5a67e7f0","691fcd18de4ae56f5a67e7fe","68a7d4adc3af739f25823aa9","68a7d4aec3af739f25823c8a","68c8ca22c3af739f25291943","68c8ca22c3af739f2529199e","68c8ca22c3af739f252919e2","68d35625c3af739f25020b2b","68a7d4aec3af739f25823e1e","68a7d4aec3af739f25823e5f"],"sort_order":{"start":1},"params":"{\"show\":15,\"title\":\"Pinopolis 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\":33.226200103759766,\"lng\":-80.03780364990234,\"latlng\":\"33.22620010376,-80.037803649902\",\"city\":\"Pinopolis\",\"state\":\"SC\",\"theme\":\"\",\"page_type\":\"town\",\"grouped\":false,\"has_next_page\":true}","modified":"MongoDate(0.06400000 1765798927)","created":"MongoDate(0.06400000 1765798927)"} , true)	0	1
18	db.towns.find( {"sef_url":"pinopolis-sc"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
19	db.tokens.find( {"sef_url":{"$in":["usa","sc","berkeley-county-sc","pinopolis-sc"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
20	db.modules.find( {"name":"AT - Header Script"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
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	12
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	4

Pinopolis

South Carolina

Pinopolis Featured Events

Justin Willman: One For The Ages Tour

Goose Creek Farmers and Artisans Market

South Carolina Stingrays vs. Orlando Solar Bears

North Charleston Pops! Sounds of the Season

South Carolina Stingrays vs. Orlando Solar Bears

NUTCRACKER! Magical Christmas Ballet

NUTCRACKER! Magical Christmas Ballet

South Carolina Stingrays vs. Orlando Solar Bears

South Carolina Stingrays vs. Greensboro Gargoyles

PBR Two-Day Package - Ticket Includes Access to all days

PBR Pendleton Whisky Velocity Tour

PBR Pendleton Whisky Velocity Tour

MANILOW: The Last Charleston Concert

South Carolina Stingrays vs. Savannah Ghost Pirates

South Carolina Stingrays vs. Savannah Ghost Pirates

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.

Pinopolis Featured Events

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.