Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.7949295043945E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00039982795715332 / seconds
host not found setting manual db connection
loadtime:0.00071597099304199 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00096988677978516 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011429786682129 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0011928081512451 / seconds
zipcode:
loadtime:0.0012099742889404 / seconds
Query Executed:select * from search_referrer where page_hash='281601f22f077f83d959c6570fc6d040' limit 10 DB:ezrox_toadli
loadtime:0.0014088153839111 / seconds
Operation header executed (non global)
loadtime:0.0014259815216064 / seconds
Operation leaderboard executed (non global)
loadtime:0.0014588832855225 / seconds
Operation square executed (non global)
loadtime:0.0014729499816895 / seconds
Operation square_bottom executed (non global)
loadtime:0.0014858245849609 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014967918395996 / seconds
Operation headeradright executed (non global)
loadtime:0.0015089511871338 / seconds
Operation google_analytics executed (non global)
loadtime:0.0015189647674561 / seconds
Operation topstories executed (non global)
loadtime:0.0015308856964111 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015418529510498 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0015518665313721 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017769336700439 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019268989562988 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0019629001617432 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0020229816436768 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0020599365234375 / seconds
Template key: archive_menu pushed
loadtime:0.002065896987915 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0020718574523926 / seconds
Template key: get_gravatar pushed
loadtime:0.0020759105682373 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.002079963684082 / seconds
*10)-10)+1 | start:0
loadtime:0.0021038055419922 / seconds
Query loaded from cache:select * from categories where cat_URLid='general-contractors-single-family-houses'
loadtime:0.0021469593048096 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.0021779537200928 / seconds
DB connected to localhost business_master_new
loadtime:0.0024099349975586 / seconds
Query Executed:select * from `vt_catmap` where sic='1521' order by city ascDB:business_master_new
loadtime:0.1082649230957 / seconds
Query stored in cache : _QUERY_www.toadli.com3a4fab5e32676c89f7a8d72f9e214269
loadtime:0.10916781425476 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.109219789505 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='1521'DB:business_master_new
loadtime:0.11416697502136 / seconds
Query stored in cache : _QUERY_www.toadli.com5783d79e1812a70d1f14f30787174b1b
loadtime:0.11421084403992 / seconds
321 / 11
loadtime:0.11426281929016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.11434698104858 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='1521'DB:business_master_new
loadtime:0.11961984634399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.11971592903137 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='1521'DB:business_master_new
loadtime:0.13079690933228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.13090085983276 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='1521'DB:business_master_new
loadtime:0.13380193710327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.13388395309448 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='1521'DB:business_master_new
loadtime:0.14037394523621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.14042091369629 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='1521'DB:business_master_new
loadtime:0.14278388023376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.14284086227417 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='1521'DB:business_master_new
loadtime:0.14309477806091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.14314389228821 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='1521'DB:business_master_new
loadtime:0.14509296417236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.14517593383789 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='1521'DB:business_master_new
loadtime:0.15292477607727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.15298295021057 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='1521'DB:business_master_new
loadtime:0.15477395057678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.15484690666199 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='1521'DB:business_master_new
loadtime:0.15664291381836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.15669178962708 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='1521'DB:business_master_new
loadtime:0.1648998260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.16498684883118 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='1521'DB:business_master_new
loadtime:0.16678500175476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.1668848991394 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='1521'DB:business_master_new
loadtime:0.16872191429138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.16875886917114 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.17177581787109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.17182278633118 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.17581391334534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.1758987903595 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='1521'DB:business_master_new
loadtime:0.18321084976196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.18328785896301 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='1521'DB:business_master_new
loadtime:0.18550586700439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.18555283546448 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='1521'DB:business_master_new
loadtime:0.21316599845886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.21323585510254 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='1521'DB:business_master_new
loadtime:0.21987080574036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.2199227809906 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='1521'DB:business_master_new
loadtime:0.22580599784851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.22585487365723 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='1521'DB:business_master_new
loadtime:0.22837495803833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.22841882705688 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='1521'DB:business_master_new
loadtime:0.23089098930359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.2309877872467 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='1521'DB:business_master_new
loadtime:0.23371887207031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.23376297950745 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='1521'DB:business_master_new
loadtime:0.23572182655334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.23578095436096 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='1521'DB:business_master_new
loadtime:0.23828077316284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.2383599281311 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='1521'DB:business_master_new
loadtime:0.2427978515625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.24285793304443 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='1521'DB:business_master_new
loadtime:0.25392580032349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.25399398803711 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='1521'DB:business_master_new
loadtime:0.25603294372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.25607800483704 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='1521'DB:business_master_new
loadtime:0.28648996353149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.28654479980469 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='1521'DB:business_master_new
loadtime:0.28707385063171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.28711485862732 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='1521'DB:business_master_new
loadtime:0.28803682327271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.28809380531311 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='1521'DB:business_master_new
loadtime:0.29327178001404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.29333877563477 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='1521'DB:business_master_new
loadtime:0.29428386688232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.29433393478394 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='1521'DB:business_master_new
loadtime:0.29458498954773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.29462289810181 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='1521'DB:business_master_new
loadtime:0.29546093940735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.29551792144775 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='1521'DB:business_master_new
loadtime:0.33541178703308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.33549189567566 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='1521'DB:business_master_new
loadtime:0.33729696273804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.3373429775238 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='1521'DB:business_master_new
loadtime:0.34517383575439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.34522485733032 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='1521'DB:business_master_new
loadtime:0.34891080856323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.34907197952271 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='1521'DB:business_master_new
loadtime:0.35323596000671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.35333299636841 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='1521'DB:business_master_new
loadtime:0.35522794723511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.35530686378479 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='1521'DB:business_master_new
loadtime:0.36037087440491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.36049389839172 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='1521'DB:business_master_new
loadtime:0.36203289031982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.36211085319519 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='1521'DB:business_master_new
loadtime:0.36318278312683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.3632698059082 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='1521'DB:business_master_new
loadtime:0.36891198158264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.36907577514648 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='1521'DB:business_master_new
loadtime:0.37064290046692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.37070298194885 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='1521'DB:business_master_new
loadtime:0.37599182128906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.37604284286499 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='1521'DB:business_master_new
loadtime:0.38490295410156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.38495993614197 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='1521'DB:business_master_new
loadtime:0.3973069190979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.39738082885742 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='1521'DB:business_master_new
loadtime:0.39823484420776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.39829277992249 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='1521'DB:business_master_new
loadtime:0.39888691902161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.39893198013306 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='1521'DB:business_master_new
loadtime:0.40235590934753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.40241885185242 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.40333485603333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.40342593193054 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='1521'DB:business_master_new
loadtime:0.40392899513245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.40402483940125 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='1521'DB:business_master_new
loadtime:0.41596794128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.41612887382507 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='1521'DB:business_master_new
loadtime:0.41765284538269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.4177029132843 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='1521'DB:business_master_new
loadtime:0.41860294342041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.41866183280945 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='1521'DB:business_master_new
loadtime:0.42069387435913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.42075181007385 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='1521'DB:business_master_new
loadtime:0.42510581016541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.42517995834351 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='1521'DB:business_master_new
loadtime:0.42731785774231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.42737483978271 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='1521'DB:business_master_new
loadtime:0.42887496948242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.4289219379425 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='1521'DB:business_master_new
loadtime:0.4294958114624 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.42954397201538 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.42978382110596 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.42981791496277 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='1521'DB:business_master_new
loadtime:0.44045877456665 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.44049382209778 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='1521'DB:business_master_new
loadtime:0.44217777252197 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.44227600097656 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='1521'DB:business_master_new
loadtime:0.44787287712097 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.44790887832642 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='1521'DB:business_master_new
loadtime:0.44910287857056 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.44917297363281 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='1521'DB:business_master_new
loadtime:0.45582699775696 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.45594596862793 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='1521'DB:business_master_new
loadtime:0.45983600616455 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.45988583564758 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='1521'DB:business_master_new
loadtime:0.46050977706909 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.46054577827454 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='1521'DB:business_master_new
loadtime:0.46115899085999 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.4612078666687 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='1521'DB:business_master_new
loadtime:0.46251392364502 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.46257090568542 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='1521'DB:business_master_new
loadtime:0.46279883384705 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.46282696723938 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='1521'DB:business_master_new
loadtime:0.46373581886292 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.46379590034485 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='1521'DB:business_master_new
loadtime:0.46511387825012 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.46517300605774 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='1521'DB:business_master_new
loadtime:0.46883487701416 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.46888399124146 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='1521'DB:business_master_new
loadtime:0.46951484680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.46955800056458 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='1521'DB:business_master_new
loadtime:0.4713568687439 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.4714138507843 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='1521'DB:business_master_new
loadtime:0.47165584564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.47168493270874 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='1521'DB:business_master_new
loadtime:0.4732608795166 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.47330784797668 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='1521'DB:business_master_new
loadtime:0.47463178634644 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.47468781471252 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='1521'DB:business_master_new
loadtime:0.4778778553009 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.47791385650635 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.47952580451965 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.47957587242126 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='1521'DB:business_master_new
loadtime:0.48060584068298 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.48065781593323 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='1521'DB:business_master_new
loadtime:0.48434281349182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.48439192771912 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='1521'DB:business_master_new
loadtime:0.48901391029358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.48911285400391 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='1521'DB:business_master_new
loadtime:0.49330186843872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.49337887763977 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.49511790275574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.49519085884094 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='1521'DB:business_master_new
loadtime:0.49648189544678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.4965398311615 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='1521'DB:business_master_new
loadtime:0.50264191627502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.50270199775696 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='1521'DB:business_master_new
loadtime:0.50436997413635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.50442790985107 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='1521'DB:business_master_new
loadtime:0.50736784934998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.50742888450623 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='1521'DB:business_master_new
loadtime:0.50829577445984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.50835490226746 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='1521'DB:business_master_new
loadtime:0.51007795333862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.51012492179871 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='1521'DB:business_master_new
loadtime:0.51039385795593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.51043891906738 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='1521'DB:business_master_new
loadtime:0.51524877548218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.51529788970947 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='1521'DB:business_master_new
loadtime:0.51758193969727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.51762890815735 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='1521'DB:business_master_new
loadtime:0.51879000663757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.51883387565613 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='1521'DB:business_master_new
loadtime:0.52197480201721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.52202177047729 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='1521'DB:business_master_new
loadtime:0.52322888374329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.52328181266785 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='1521'DB:business_master_new
loadtime:0.52389097213745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.5239429473877 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='1521'DB:business_master_new
loadtime:0.52458786964417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.52462482452393 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='1521'DB:business_master_new
loadtime:0.52525997161865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.52530789375305 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='1521'DB:business_master_new
loadtime:0.52715396881104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.52721285820007 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='1521'DB:business_master_new
loadtime:0.52782297134399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.52786588668823 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='1521'DB:business_master_new
loadtime:0.53163599967957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.53167986869812 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='1521'DB:business_master_new
loadtime:0.53225898742676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.53231477737427 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='1521'DB:business_master_new
loadtime:0.53627586364746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.53631997108459 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='1521'DB:business_master_new
loadtime:0.53770780563354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.53777098655701 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='1521'DB:business_master_new
loadtime:0.53836584091187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.53839492797852 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='1521'DB:business_master_new
loadtime:0.53862190246582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.5386598110199 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='1521'DB:business_master_new
loadtime:0.53921699523926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.53925085067749 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='1521'DB:business_master_new
loadtime:0.54091095924377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.5409688949585 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='1521'DB:business_master_new
loadtime:0.5416247844696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.54168391227722 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='1521'DB:business_master_new
loadtime:0.54574990272522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.54581093788147 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='1521'DB:business_master_new
loadtime:0.54607486724854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.5461049079895 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='1521'DB:business_master_new
loadtime:0.54777479171753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.54782295227051 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='1521'DB:business_master_new
loadtime:0.54873585700989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.54879379272461 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='1521'DB:business_master_new
loadtime:0.55492782592773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.55497193336487 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='1521'DB:business_master_new
loadtime:0.55782294273376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.55789089202881 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='1521'DB:business_master_new
loadtime:0.559161901474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.55922079086304 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='1521'DB:business_master_new
loadtime:0.56223297119141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.56227898597717 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='1521'DB:business_master_new
loadtime:0.56549382209778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.56554293632507 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='1521'DB:business_master_new
loadtime:0.5668089389801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.56685400009155 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='1521'DB:business_master_new
loadtime:0.56759095191956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.56764888763428 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='1521'DB:business_master_new
loadtime:0.57148885726929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.57154488563538 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='1521'DB:business_master_new
loadtime:0.57216787338257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.5722029209137 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='1521'DB:business_master_new
loadtime:0.57286477088928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.57291293144226 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='1521'DB:business_master_new
loadtime:0.57319498062134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.57323384284973 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='1521'DB:business_master_new
loadtime:0.57444477081299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.57450485229492 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='1521'DB:business_master_new
loadtime:0.57615280151367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.5762038230896 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='1521'DB:business_master_new
loadtime:0.5770149230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.57706499099731 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='1521'DB:business_master_new
loadtime:0.57774496078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.57780385017395 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='1521'DB:business_master_new
loadtime:0.57940578460693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.57944989204407 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='1521'DB:business_master_new
loadtime:0.58020782470703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.58025479316711 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='1521'DB:business_master_new
loadtime:0.58184599876404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.58190298080444 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='1521'DB:business_master_new
loadtime:0.58235597610474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.58239698410034 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='1521'DB:business_master_new
loadtime:0.58263993263245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.58267283439636 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:0.58361887931824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.58367800712585 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='1521'DB:business_master_new
loadtime:0.58456492424011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.58460998535156 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='1521'DB:business_master_new
loadtime:0.58781695365906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.58786392211914 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='1521'DB:business_master_new
loadtime:0.58963680267334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.58969187736511 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='1521'DB:business_master_new
loadtime:0.59076881408691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.59082579612732 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='1521'DB:business_master_new
loadtime:0.59145879745483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.59150791168213 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='1521'DB:business_master_new
loadtime:0.59451484680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.59455895423889 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='1521'DB:business_master_new
loadtime:0.59617686271667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.59623694419861 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='1521'DB:business_master_new
loadtime:0.59696984291077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.59702277183533 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='1521'DB:business_master_new
loadtime:0.59874677658081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.59879994392395 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='1521'DB:business_master_new
loadtime:0.5990788936615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.59912085533142 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='1521'DB:business_master_new
loadtime:0.59975600242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.5998067855835 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='1521'DB:business_master_new
loadtime:0.60046195983887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.60051894187927 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.6016788482666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.601726770401 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='1521'DB:business_master_new
loadtime:0.60434794425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.60439491271973 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='1521'DB:business_master_new
loadtime:0.60503196716309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.60507988929749 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='1521'DB:business_master_new
loadtime:0.60569977760315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.60573697090149 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='1521'DB:business_master_new
loadtime:0.6089448928833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.60900783538818 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='1521'DB:business_master_new
loadtime:0.61127090454102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.61131978034973 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='1521'DB:business_master_new
loadtime:0.6121199131012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.61216688156128 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='1521'DB:business_master_new
loadtime:0.61284279823303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.61288380622864 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='1521'DB:business_master_new
loadtime:0.61341595649719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.61345481872559 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='1521'DB:business_master_new
loadtime:0.61594295501709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.61599278450012 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='1521'DB:business_master_new
loadtime:0.61717486381531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.61723589897156 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='1521'DB:business_master_new
loadtime:0.62006783485413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.62012481689453 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='1521'DB:business_master_new
loadtime:0.62208795547485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.62216687202454 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='1521'DB:business_master_new
loadtime:0.62254786491394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.62259888648987 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='1521'DB:business_master_new
loadtime:0.62348794937134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.62353277206421 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='1521'DB:business_master_new
loadtime:0.62405681610107 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.62410688400269 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='1521'DB:business_master_new
loadtime:0.62540292739868 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.6254608631134 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='1521'DB:business_master_new
loadtime:0.62651896476746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.62658190727234 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='1521'DB:business_master_new
loadtime:0.6271858215332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.62723088264465 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='1521'DB:business_master_new
loadtime:0.62787294387817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.6279308795929 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='1521'DB:business_master_new
loadtime:0.62999176979065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.63005495071411 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='1521'DB:business_master_new
loadtime:0.63068294525146 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.6307327747345 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='1521'DB:business_master_new
loadtime:0.63162899017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.63168478012085 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='1521'DB:business_master_new
loadtime:0.63192677497864 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.63195490837097 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='1521'DB:business_master_new
loadtime:0.63291478157043 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.63297295570374 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='1521'DB:business_master_new
loadtime:0.63377380371094 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.6338198184967 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='1521'DB:business_master_new
loadtime:0.63406991958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.63409781455994 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='1521'DB:business_master_new
loadtime:0.63598299026489 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.63603281974792 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='1521'DB:business_master_new
loadtime:0.63708591461182 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.6371488571167 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='1521'DB:business_master_new
loadtime:0.63827776908875 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.63832688331604 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='1521'DB:business_master_new
loadtime:0.63864398002625 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.63868093490601 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='1521'DB:business_master_new
loadtime:0.64470481872559 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.64476084709167 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='1521'DB:business_master_new
loadtime:0.64551877975464 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.64555478096008 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='1521'DB:business_master_new
loadtime:0.6461808681488 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.64623284339905 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='1521'DB:business_master_new
loadtime:0.64691185951233 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.64696383476257 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='1521'DB:business_master_new
loadtime:0.64759397506714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.64764380455017 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='1521'DB:business_master_new
loadtime:0.64916586875916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.64921689033508 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='1521'DB:business_master_new
loadtime:0.65092277526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.65097379684448 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='1521'DB:business_master_new
loadtime:0.65247392654419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.65252089500427 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='1521'DB:business_master_new
loadtime:0.65349578857422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.65355587005615 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='1521'DB:business_master_new
loadtime:0.65381288528442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.65384793281555 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='1521'DB:business_master_new
loadtime:0.65449690818787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.65455293655396 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='1521'DB:business_master_new
loadtime:0.65519785881042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.65524482727051 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='1521'DB:business_master_new
loadtime:0.65576887130737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.65581679344177 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='1521'DB:business_master_new
loadtime:0.65647792816162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.65652394294739 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='1521'DB:business_master_new
loadtime:0.65809178352356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.65815186500549 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='1521'DB:business_master_new
loadtime:0.65881681442261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.65887689590454 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='1521'DB:business_master_new
loadtime:0.66058087348938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.66062498092651 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='1521'DB:business_master_new
loadtime:0.66120600700378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.66125392913818 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='1521'DB:business_master_new
loadtime:0.66327500343323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.66333389282227 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='1521'DB:business_master_new
loadtime:0.66680479049683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.66686391830444 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='1521'DB:business_master_new
loadtime:0.66747093200684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.66751194000244 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='1521'DB:business_master_new
loadtime:0.66903185844421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.66912698745728 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='1521'DB:business_master_new
loadtime:0.67107892036438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.67123794555664 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='1521'DB:business_master_new
loadtime:0.67277383804321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.67293190956116 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='1521'DB:business_master_new
loadtime:0.67484283447266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.67501497268677 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='1521'DB:business_master_new
loadtime:0.67662000656128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.67666482925415 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='1521'DB:business_master_new
loadtime:0.67857098579407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.67874097824097 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='1521'DB:business_master_new
loadtime:0.68058180809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.68063879013062 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='1521'DB:business_master_new
loadtime:0.68265581130981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.68281483650208 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='1521'DB:business_master_new
loadtime:0.68453884124756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.68459677696228 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='1521'DB:business_master_new
loadtime:0.68637180328369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.68648982048035 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='1521'DB:business_master_new
loadtime:0.68942785263062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.68948483467102 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='1521'DB:business_master_new
loadtime:0.69123077392578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.69135880470276 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='1521'DB:business_master_new
loadtime:0.69405388832092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.69422698020935 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='1521'DB:business_master_new
loadtime:0.69604992866516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.69610500335693 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='1521'DB:business_master_new
loadtime:0.69738388061523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.6975359916687 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='1521'DB:business_master_new
loadtime:0.70020079612732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.70029783248901 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='1521'DB:business_master_new
loadtime:0.70266079902649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.70270895957947 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='1521'DB:business_master_new
loadtime:0.70458793640137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.70465493202209 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='1521'DB:business_master_new
loadtime:0.70532178878784 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.7053599357605 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:0.70575380325317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.70580196380615 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='1521'DB:business_master_new
loadtime:0.71467089653015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.71473598480225 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='1521'DB:business_master_new
loadtime:0.71515297889709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.71518993377686 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.71628785133362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.7163507938385 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='1521'DB:business_master_new
loadtime:0.71795582771301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.71805882453918 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='1521'DB:business_master_new
loadtime:0.72021484375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.72037196159363 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='1521'DB:business_master_new
loadtime:0.72207593917847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.72211980819702 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.72346782684326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.72362399101257 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='1521'DB:business_master_new
loadtime:0.72504377365112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.72523498535156 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='1521'DB:business_master_new
loadtime:0.72854089736938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.72858500480652 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='1521'DB:business_master_new
loadtime:0.73131895065308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.73138380050659 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='1521'DB:business_master_new
loadtime:0.73274779319763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.73283195495605 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='1521'DB:business_master_new
loadtime:0.73324179649353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.73326992988586 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='1521'DB:business_master_new
loadtime:0.73469281196594 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.73484587669373 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='1521'DB:business_master_new
loadtime:0.73655080795288 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.73659491539001 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='1521'DB:business_master_new
loadtime:0.74239993095398 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.74258685112 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='1521'DB:business_master_new
loadtime:0.74458384513855 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.74463200569153 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='1521'DB:business_master_new
loadtime:0.74671983718872 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.74687600135803 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='1521'DB:business_master_new
loadtime:0.74789381027222 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.74802899360657 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='1521'DB:business_master_new
loadtime:0.74978685379028 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.74989891052246 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='1521'DB:business_master_new
loadtime:0.75225591659546 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.7524209022522 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='1521'DB:business_master_new
loadtime:0.75690698623657 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.75695896148682 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='1521'DB:business_master_new
loadtime:0.75757193565369 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.7576208114624 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='1521'DB:business_master_new
loadtime:0.75870585441589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.7587559223175 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='1521'DB:business_master_new
loadtime:0.760657787323 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.76071786880493 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='1521'DB:business_master_new
loadtime:0.76107597351074 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.76113486289978 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='1521'DB:business_master_new
loadtime:0.76166892051697 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.76170492172241 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='1521'DB:business_master_new
loadtime:0.76196694374084 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.76200795173645 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='1521'DB:business_master_new
loadtime:0.76264500617981 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.76268076896667 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='1521'DB:business_master_new
loadtime:0.76291179656982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.76295399665833 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='1521'DB:business_master_new
loadtime:0.76384687423706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.76389193534851 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='1521'DB:business_master_new
loadtime:0.76451897621155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.7645628452301 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='1521'DB:business_master_new
loadtime:0.76506280899048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.7650899887085 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='1521'DB:business_master_new
loadtime:0.7660129070282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.76605892181396 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='1521'DB:business_master_new
loadtime:0.76682186126709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.76685380935669 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='1521'DB:business_master_new
loadtime:0.7675838470459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.7676248550415 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='1521'DB:business_master_new
loadtime:0.76847696304321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.76852488517761 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='1521'DB:business_master_new
loadtime:0.76946091651917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.76948881149292 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='1521'DB:business_master_new
loadtime:0.77005290985107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.77046585083008 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='1521'DB:business_master_new
loadtime:0.77109599113464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.77115797996521 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='1521'DB:business_master_new
loadtime:0.77230286598206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.77233386039734 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='1521'DB:business_master_new
loadtime:0.77308583259583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.77312397956848 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='1521'DB:business_master_new
loadtime:0.77372193336487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.77376484870911 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='1521'DB:business_master_new
loadtime:0.77437686920166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.77440977096558 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='1521'DB:business_master_new
loadtime:0.77568292617798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.77572798728943 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='1521'DB:business_master_new
loadtime:0.77614092826843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.77617287635803 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='1521'DB:business_master_new
loadtime:0.77701282501221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.77705883979797 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='1521'DB:business_master_new
loadtime:0.77771186828613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.77775382995605 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='1521'DB:business_master_new
loadtime:0.77816987037659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.77819585800171 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='1521'DB:business_master_new
loadtime:0.77904891967773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.77909588813782 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='1521'DB:business_master_new
loadtime:0.77976584434509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.77981185913086 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='1521'DB:business_master_new
loadtime:0.78084087371826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.78087592124939 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='1521'DB:business_master_new
loadtime:0.78158497810364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.78162789344788 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='1521'DB:business_master_new
loadtime:0.78220891952515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.78223395347595 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='1521'DB:business_master_new
loadtime:0.7830798625946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.78312397003174 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='1521'DB:business_master_new
loadtime:0.78375482559204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.78379583358765 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='1521'DB:business_master_new
loadtime:0.78451490402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.78454494476318 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='1521'DB:business_master_new
loadtime:0.78560900688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.78564476966858 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='1521'DB:business_master_new
loadtime:0.78623700141907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.78627681732178 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='1521'DB:business_master_new
loadtime:0.78684878349304 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.78687381744385 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='1521'DB:business_master_new
loadtime:0.78748393058777 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.78752279281616 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='1521'DB:business_master_new
loadtime:0.78861784934998 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.78865885734558 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='1521'DB:business_master_new
loadtime:0.7892529964447 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.78928279876709 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='1521'DB:business_master_new
loadtime:0.79034090042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.79038381576538 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='1521'DB:business_master_new
loadtime:0.7907018661499 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.79072690010071 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='1521'DB:business_master_new
loadtime:0.79115080833435 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.79118990898132 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='1521'DB:business_master_new
loadtime:0.79142594337463 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.79144978523254 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='1521'DB:business_master_new
loadtime:0.79215478897095 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.79218888282776 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='1521'DB:business_master_new
loadtime:0.79410791397095 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.79414391517639 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='1521'DB:business_master_new
loadtime:0.79439091682434 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.79442381858826 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='1521'DB:business_master_new
loadtime:0.79506993293762 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.79510498046875 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='1521'DB:business_master_new
loadtime:0.79563593864441 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.79566597938538 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='1521'DB:business_master_new
loadtime:0.79604196548462 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.79607486724854 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='1521'DB:business_master_new
loadtime:0.79678678512573 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.79682087898254 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='1521'DB:business_master_new
loadtime:0.79727292060852 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.79730677604675 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='1521'DB:business_master_new
loadtime:0.79771494865417 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.79774498939514 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='1521'DB:business_master_new
loadtime:0.79902291297913 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.79906392097473 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='1521'DB:business_master_new
loadtime:0.79932284355164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.79934692382812 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='1521'DB:business_master_new
loadtime:0.79992485046387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.79996490478516 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='1521'DB:business_master_new
loadtime:0.80064177513123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.80068778991699 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='1521'DB:business_master_new
loadtime:0.8013288974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.80137300491333 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='1521'DB:business_master_new
loadtime:0.80161380767822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.80164384841919 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='1521'DB:business_master_new
loadtime:0.80205297470093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.802081823349 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='1521'DB:business_master_new
loadtime:0.8026909828186 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.80273294448853 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='1521'DB:business_master_new
loadtime:0.8030788898468 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.80310297012329 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='1521'DB:business_master_new
loadtime:0.80446100234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.80450487136841 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='1521'DB:business_master_new
loadtime:0.80501484870911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.80503988265991 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='1521'DB:business_master_new
loadtime:0.80636787414551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.80640697479248 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='1521'DB:business_master_new
loadtime:0.80716681480408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.80720782279968 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='1521'DB:business_master_new
loadtime:0.80785083770752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.80788683891296 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='1521'DB:business_master_new
loadtime:0.80898284912109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.8090078830719 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='1521'DB:business_master_new
loadtime:0.81059980392456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.81065583229065 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='1521'DB:business_master_new
loadtime:0.81141877174377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.81146287918091 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='1521'DB:business_master_new
loadtime:0.8122398853302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.81228280067444 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='1521'DB:business_master_new
loadtime:0.81301283836365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.81304979324341 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='1521'DB:business_master_new
loadtime:0.81367897987366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.81371784210205 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='1521'DB:business_master_new
loadtime:0.81415987014771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.81419992446899 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='1521'DB:business_master_new
loadtime:0.81509494781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.81514286994934 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='1521'DB:business_master_new
loadtime:0.81563591957092 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.81571578979492 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.81588792800903 / seconds
Operation template executed (chunk cache operation)
loadtime:0.81596899032593 / seconds
template override:Default
loadtime:0.81598782539368 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.81680583953857 / seconds
Template Constructed, Array Rows:49
loadtime:0.81703877449036 / seconds
TOTAL EXECUTION TIME: 0.81685
loadtime:0.81716799736023 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => general-contractors-single-family-houses [stateURLid] => vermont )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


Array ( [0] => cache [1] => query [2] => output [3] => session [4] => db [5] => db2 [6] => dbnew [7] => sphinxsearch [8] => sphinx [9] => dbConn [10] => functions [11] => sphinx_search [12] => template_operations [13] => buildtemplate [14] => syndication_handler [15] => directorystate )


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.8171718120575
TOTAL KEY ARRAYS: 69