Name: Randall's Annual Christmas Fair
Start: 2025-12-20T14:00:00-05:00
End: 2025-12-20T18:00:00-05:00
Location: Randall's

Nr	Query	Num. rows	Took (ms)
1	db.towns.find( {"sef_url":"hawleyville-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	4
2	db.sites.find( {"hostname":{"$in":["bestthingsct.com","localword"]}}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	3
3	db.towns.find( {"sef_url":"stamford-ct"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
4	db.pages.find( {"type":"town","slug":{"$in":["festivals"]},"site.hostname":"bestthingsct.com"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
5	db.modules.find( {"name":{"$in":["BTS - Main Header","header script","footer menu","footer script"]}}, [] ).sort( [] ).limit( 0 ).skip( 0 )	4	1
6	db.events_cache.find( {"_id":"ead88078c010e0e4a55a76297204601c"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
7	db.events.find( {"_id":{"$in":[ObjectId ("68fc755fb71bc004bd06ba97"),ObjectId ("69008894fc7e8813900448c3")]},"address.state":"CT"}, [] ).sort( {"start":1} ).limit( 16 ).skip( 0 )	2	1
8	db.modules.find( {"name":"BTS - State Towns"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
9	db.states.find( {"sef_url":"ct"}, ["name","sef_url","towns"] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
10	db.modules.find( {"name":"BTS - Ad"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
11	db.modules.find( {"name":"footer menu"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
12	db.modules.find( {"name":"BTS - State List"}, [] ).sort( [] ).limit( 1 ).skip( 0 )	1	1
13	db.states.find( {"state":{"$nin":["DC"]}}, ["sef_url","name"] ).sort( {"name":1} ).limit( 0 ).skip( 0 )	50	1