Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00010299682617188 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00059199333190918 / seconds
host not found setting manual db connection
loadtime:0.0010159015655518 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0012459754943848 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0015339851379395 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0016191005706787 / seconds
zipcode:
loadtime:0.00164794921875 / seconds
Query Executed:select * from search_referrer where page_hash='56ddf6855a0c1078ac8cbff0b6fae63d' limit 10 DB:ezrox_toadli
loadtime:0.0019841194152832 / seconds
Operation header executed (non global)
loadtime:0.0020129680633545 / seconds
Operation leaderboard executed (non global)
loadtime:0.0020999908447266 / seconds
Operation square executed (non global)
loadtime:0.0021159648895264 / seconds
Operation square_bottom executed (non global)
loadtime:0.002129077911377 / seconds
Operation smallsquare executed (non global)
loadtime:0.002140998840332 / seconds
Operation headeradright executed (non global)
loadtime:0.0021519660949707 / seconds
Operation google_analytics executed (non global)
loadtime:0.0021629333496094 / seconds
Operation topstories executed (non global)
loadtime:0.002173900604248 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0021851062774658 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0021951198577881 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0024991035461426 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0027499198913574 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0028140544891357 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0029170513153076 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.002979040145874 / seconds
Template key: archive_menu pushed
loadtime:0.0029869079589844 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0029981136322021 / seconds
Template key: get_gravatar pushed
loadtime:0.0030050277709961 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.00301194190979 / seconds
*10)-10)+1 | start:0
loadtime:0.00307297706604 / seconds
Query loaded from cache:select * from categories where cat_URLid='real-estate-agents-and-managers'
loadtime:0.003140926361084 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.0031850337982178 / seconds
DB connected to localhost business_master_new
loadtime:0.0035529136657715 / seconds
Query Executed:select * from `vt_catmap` where sic='6531' order by city ascDB:business_master_new
loadtime:0.03958797454834 / seconds
Query stored in cache : _QUERY_www.toadli.com06f207fd1058c6b4ba5dfa9111bab74f
loadtime:0.040395975112915 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.04048490524292 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='6531'DB:business_master_new
loadtime:0.042444944381714 / seconds
Query stored in cache : _QUERY_www.toadli.comae339a47fc95b7b94e1deefe60742e24
loadtime:0.042470932006836 / seconds
321 / 11
loadtime:0.042511940002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.042561054229736 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='6531'DB:business_master_new
loadtime:0.044591903686523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.044640064239502 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='6531'DB:business_master_new
loadtime:0.045149087905884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.045196056365967 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='6531'DB:business_master_new
loadtime:0.045511960983276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.045555114746094 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='6531'DB:business_master_new
loadtime:0.046389102935791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.046435117721558 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='6531'DB:business_master_new
loadtime:0.047070026397705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.047126054763794 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='6531'DB:business_master_new
loadtime:0.047377109527588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.047411918640137 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='6531'DB:business_master_new
loadtime:0.047718048095703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.047753095626831 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='6531'DB:business_master_new
loadtime:0.048233032226562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.048274040222168 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='6531'DB:business_master_new
loadtime:0.04889702796936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.048938989639282 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='6531'DB:business_master_new
loadtime:0.049566030502319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.049613952636719 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='6531'DB:business_master_new
loadtime:0.051394939422607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.05146312713623 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='6531'DB:business_master_new
loadtime:0.052138090133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.052273035049438 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='6531'DB:business_master_new
loadtime:0.052665948867798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.05272102355957 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.053137063980103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.053210020065308 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.054074048995972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.054131031036377 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='6531'DB:business_master_new
loadtime:0.054728031158447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.054825067520142 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='6531'DB:business_master_new
loadtime:0.055202960968018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.055241107940674 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='6531'DB:business_master_new
loadtime:0.056484937667847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.056550979614258 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='6531'DB:business_master_new
loadtime:0.056977033615112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.057023048400879 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='6531'DB:business_master_new
loadtime:0.057536125183105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.057671070098877 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='6531'DB:business_master_new
loadtime:0.058451890945435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.058494091033936 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='6531'DB:business_master_new
loadtime:0.058806896209717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.058851003646851 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='6531'DB:business_master_new
loadtime:0.05955696105957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.059674978256226 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='6531'DB:business_master_new
loadtime:0.060497999191284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.060559034347534 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='6531'DB:business_master_new
loadtime:0.061325073242188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.061384916305542 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='6531'DB:business_master_new
loadtime:0.062206983566284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.062266111373901 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='6531'DB:business_master_new
loadtime:0.063827991485596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.063899040222168 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='6531'DB:business_master_new
loadtime:0.06456995010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.064614057540894 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='6531'DB:business_master_new
loadtime:0.06517505645752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.065215110778809 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='6531'DB:business_master_new
loadtime:0.065458059310913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.065483093261719 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='6531'DB:business_master_new
loadtime:0.0660719871521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.066106081008911 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='6531'DB:business_master_new
loadtime:0.066889047622681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.066942930221558 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='6531'DB:business_master_new
loadtime:0.067589998245239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.067637920379639 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='6531'DB:business_master_new
loadtime:0.067884922027588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.067923069000244 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='6531'DB:business_master_new
loadtime:0.06862211227417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.068759918212891 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='6531'DB:business_master_new
loadtime:0.071100950241089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.071191072463989 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='6531'DB:business_master_new
loadtime:0.071845054626465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.071891069412231 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='6531'DB:business_master_new
loadtime:0.072386980056763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.07244610786438 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='6531'DB:business_master_new
loadtime:0.073065042495728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.073112964630127 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='6531'DB:business_master_new
loadtime:0.07352089881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.073637962341309 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='6531'DB:business_master_new
loadtime:0.074338912963867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.074388027191162 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='6531'DB:business_master_new
loadtime:0.07505202293396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.075099945068359 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='6531'DB:business_master_new
loadtime:0.075766086578369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.075814008712769 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='6531'DB:business_master_new
loadtime:0.076457023620605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.076527118682861 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='6531'DB:business_master_new
loadtime:0.077238082885742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.077282905578613 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='6531'DB:business_master_new
loadtime:0.077953100204468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.078007936477661 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='6531'DB:business_master_new
loadtime:0.079476118087769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.079523086547852 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='6531'DB:business_master_new
loadtime:0.080079078674316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.080123901367188 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='6531'DB:business_master_new
loadtime:0.081295967102051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.081361055374146 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='6531'DB:business_master_new
loadtime:0.082021951675415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.082092046737671 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='6531'DB:business_master_new
loadtime:0.082690954208374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.082735061645508 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='6531'DB:business_master_new
loadtime:0.0831139087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.083147048950195 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.083744049072266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.083792924880981 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='6531'DB:business_master_new
loadtime:0.08404803276062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.084074974060059 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='6531'DB:business_master_new
loadtime:0.084589958190918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.084639072418213 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='6531'DB:business_master_new
loadtime:0.085263967514038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.085292100906372 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='6531'DB:business_master_new
loadtime:0.085947036743164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.086004972457886 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='6531'DB:business_master_new
loadtime:0.086728096008301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.086829900741577 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='6531'DB:business_master_new
loadtime:0.087544918060303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.08760404586792 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='6531'DB:business_master_new
loadtime:0.088229894638062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.088274002075195 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='6531'DB:business_master_new
loadtime:0.089037895202637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.089086055755615 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='6531'DB:business_master_new
loadtime:0.089334964752197 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.089375019073486 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.089601993560791 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.089634895324707 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='6531'DB:business_master_new
loadtime:0.090101003646851 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.090126037597656 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='6531'DB:business_master_new
loadtime:0.090729951858521 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.090776920318604 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='6531'DB:business_master_new
loadtime:0.091147899627686 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.09118390083313 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='6531'DB:business_master_new
loadtime:0.09181809425354 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.091875076293945 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='6531'DB:business_master_new
loadtime:0.092381000518799 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.092427015304565 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='6531'DB:business_master_new
loadtime:0.092781066894531 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.092827081680298 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='6531'DB:business_master_new
loadtime:0.093465089797974 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.093559980392456 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='6531'DB:business_master_new
loadtime:0.094208002090454 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.094245910644531 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='6531'DB:business_master_new
loadtime:0.094841003417969 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.094893932342529 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='6531'DB:business_master_new
loadtime:0.095135927200317 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.095163106918335 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='6531'DB:business_master_new
loadtime:0.095743894577026 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.095792055130005 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='6531'DB:business_master_new
loadtime:0.096441030502319 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.096484899520874 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='6531'DB:business_master_new
loadtime:0.096827983856201 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.096867084503174 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='6531'DB:business_master_new
loadtime:0.097554922103882 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.097641944885254 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:0.098340034484863 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.098396062850952 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='6531'DB:business_master_new
loadtime:0.098634004592896 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.098700046539307 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='6531'DB:business_master_new
loadtime:0.099062919616699 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.099100112915039 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='6531'DB:business_master_new
loadtime:0.09948992729187 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.099606990814209 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='6531'DB:business_master_new
loadtime:0.10011506080627 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.10014295578003 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.10047507286072 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.10052394866943 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='6531'DB:business_master_new
loadtime:0.1012179851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.1012589931488 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='6531'DB:business_master_new
loadtime:0.10167694091797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.10172390937805 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='6531'DB:business_master_new
loadtime:0.10218000411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.10222601890564 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='6531'DB:business_master_new
loadtime:0.10262489318848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.10272312164307 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.1036639213562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.10382103919983 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='6531'DB:business_master_new
loadtime:0.1046290397644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.10479211807251 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='6531'DB:business_master_new
loadtime:0.10627102851868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.10633611679077 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='6531'DB:business_master_new
loadtime:0.10705709457397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.10711407661438 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='6531'DB:business_master_new
loadtime:0.10782194137573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.10787391662598 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='6531'DB:business_master_new
loadtime:0.10851907730103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.10856699943542 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='6531'DB:business_master_new
loadtime:0.10924792289734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.10928511619568 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='6531'DB:business_master_new
loadtime:0.10952997207642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.10956811904907 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='6531'DB:business_master_new
loadtime:0.10999298095703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.110023021698 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='6531'DB:business_master_new
loadtime:0.11038398742676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.1105101108551 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='6531'DB:business_master_new
loadtime:0.11118793487549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.11122298240662 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='6531'DB:business_master_new
loadtime:0.11156010627747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.11160898208618 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='6531'DB:business_master_new
loadtime:0.11193704605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.11196994781494 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='6531'DB:business_master_new
loadtime:0.1126549243927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.1128089427948 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='6531'DB:business_master_new
loadtime:0.11356210708618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.11360502243042 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='6531'DB:business_master_new
loadtime:0.11390089988708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.11394095420837 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='6531'DB:business_master_new
loadtime:0.11464190483093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.11479997634888 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='6531'DB:business_master_new
loadtime:0.11547112464905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.11551809310913 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='6531'DB:business_master_new
loadtime:0.11592292785645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.11595010757446 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='6531'DB:business_master_new
loadtime:0.11665201187134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.11680889129639 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='6531'DB:business_master_new
loadtime:0.11733412742615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.11737704277039 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='6531'DB:business_master_new
loadtime:0.11797690391541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.11801791191101 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='6531'DB:business_master_new
loadtime:0.11868500709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.1187789440155 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='6531'DB:business_master_new
loadtime:0.11910700798035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.11914896965027 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='6531'DB:business_master_new
loadtime:0.11975789070129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.11988091468811 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='6531'DB:business_master_new
loadtime:0.12075901031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.12091994285583 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='6531'DB:business_master_new
loadtime:0.12166905403137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.12172698974609 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='6531'DB:business_master_new
loadtime:0.12242197990417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.12247896194458 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='6531'DB:business_master_new
loadtime:0.12272310256958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.12278389930725 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='6531'DB:business_master_new
loadtime:0.12316107749939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.12319612503052 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='6531'DB:business_master_new
loadtime:0.1238260269165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.12387800216675 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.12435102462769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.12438702583313 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='6531'DB:business_master_new
loadtime:0.12514305114746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.12520599365234 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='6531'DB:business_master_new
loadtime:0.12582802772522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.12587094306946 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='6531'DB:business_master_new
loadtime:0.12662196159363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.12673807144165 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='6531'DB:business_master_new
loadtime:0.12726211547852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.1273090839386 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='6531'DB:business_master_new
loadtime:0.12793493270874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.12797808647156 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='6531'DB:business_master_new
loadtime:0.12871098518372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.12886190414429 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='6531'DB:business_master_new
loadtime:0.12944889068604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.1294960975647 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='6531'DB:business_master_new
loadtime:0.1301109790802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.13014507293701 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='6531'DB:business_master_new
loadtime:0.13084006309509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.13095808029175 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='6531'DB:business_master_new
loadtime:0.13122701644897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.13126707077026 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='6531'DB:business_master_new
loadtime:0.13198399543762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.13205003738403 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='6531'DB:business_master_new
loadtime:0.1328239440918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.13294506072998 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='6531'DB:business_master_new
loadtime:0.13329005241394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.13333010673523 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='6531'DB:business_master_new
loadtime:0.13401794433594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.13408803939819 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='6531'DB:business_master_new
loadtime:0.13444089889526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.13448905944824 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='6531'DB:business_master_new
loadtime:0.13543105125427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.1354820728302 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='6531'DB:business_master_new
loadtime:0.135910987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.13595104217529 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='6531'DB:business_master_new
loadtime:0.1362190246582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.13625812530518 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='6531'DB:business_master_new
loadtime:0.13650393486023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.13653707504272 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='6531'DB:business_master_new
loadtime:0.13720202445984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.13725399971008 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='6531'DB:business_master_new
loadtime:0.13784503936768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.1378800868988 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='6531'DB:business_master_new
loadtime:0.13827204704285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.13830995559692 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='6531'DB:business_master_new
loadtime:0.13946604728699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.13963103294373 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='6531'DB:business_master_new
loadtime:0.14033508300781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.14038300514221 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='6531'DB:business_master_new
loadtime:0.14101099967957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.14107799530029 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='6531'DB:business_master_new
loadtime:0.14151906967163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.14155507087708 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='6531'DB:business_master_new
loadtime:0.14242911338806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.14248895645142 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='6531'DB:business_master_new
loadtime:0.14321994781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.14326500892639 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='6531'DB:business_master_new
loadtime:0.14444994926453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.14450407028198 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='6531'DB:business_master_new
loadtime:0.14476895332336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.14480900764465 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='6531'DB:business_master_new
loadtime:0.14543509483337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.14547204971313 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='6531'DB:business_master_new
loadtime:0.14610409736633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.14616012573242 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.14653611183167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.14665508270264 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='6531'DB:business_master_new
loadtime:0.14791893959045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.14796996116638 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='6531'DB:business_master_new
loadtime:0.14824199676514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.14828205108643 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.14892292022705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.14896702766418 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='6531'DB:business_master_new
loadtime:0.14987397193909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.1499330997467 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='6531'DB:business_master_new
loadtime:0.15059804916382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.15065312385559 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='6531'DB:business_master_new
loadtime:0.15106892585754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.15109610557556 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='6531'DB:business_master_new
loadtime:0.15178489685059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.15193605422974 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='6531'DB:business_master_new
loadtime:0.15229892730713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.15233898162842 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:0.15387606620789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.15393304824829 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='6531'DB:business_master_new
loadtime:0.15467691421509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.15483593940735 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='6531'DB:business_master_new
loadtime:0.1554000377655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.15544700622559 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='6531'DB:business_master_new
loadtime:0.15643191337585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.15649390220642 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='6531'DB:business_master_new
loadtime:0.15685391426086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.15688800811768 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='6531'DB:business_master_new
loadtime:0.15753602981567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.15757894515991 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='6531'DB:business_master_new
loadtime:0.15785503387451 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.15789294242859 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='6531'DB:business_master_new
loadtime:0.15826606750488 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.15830397605896 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='6531'DB:business_master_new
loadtime:0.15895009040833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.15899801254272 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='6531'DB:business_master_new
loadtime:0.15960693359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.15964293479919 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='6531'DB:business_master_new
loadtime:0.16032600402832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.16038489341736 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='6531'DB:business_master_new
loadtime:0.16135597229004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.16141605377197 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='6531'DB:business_master_new
loadtime:0.1620180606842 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.16207194328308 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='6531'DB:business_master_new
loadtime:0.1627631187439 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.16289496421814 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='6531'DB:business_master_new
loadtime:0.16320610046387 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.16323494911194 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='6531'DB:business_master_new
loadtime:0.16387605667114 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.1639289855957 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='6531'DB:business_master_new
loadtime:0.16426396369934 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.16430711746216 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='6531'DB:business_master_new
loadtime:0.16455602645874 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.16461300849915 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='6531'DB:business_master_new
loadtime:0.16504812240601 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.16509008407593 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='6531'DB:business_master_new
loadtime:0.1657440662384 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.16585993766785 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='6531'DB:business_master_new
loadtime:0.16632795333862 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.1663761138916 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:0.16670107841492 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.16678595542908 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='6531'DB:business_master_new
loadtime:0.16734910011292 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.16740489006042 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='6531'DB:business_master_new
loadtime:0.16776204109192 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.16778898239136 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='6531'DB:business_master_new
loadtime:0.16843795776367 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.16848492622375 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='6531'DB:business_master_new
loadtime:0.1688289642334 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.16886210441589 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='6531'DB:business_master_new
loadtime:0.16957092285156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.16962909698486 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='6531'DB:business_master_new
loadtime:0.17041897773743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.17046904563904 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='6531'DB:business_master_new
loadtime:0.17085289955139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.17089605331421 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='6531'DB:business_master_new
loadtime:0.17140603065491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.17145490646362 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='6531'DB:business_master_new
loadtime:0.17227602005005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.17232799530029 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='6531'DB:business_master_new
loadtime:0.1725959777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.1726291179657 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='6531'DB:business_master_new
loadtime:0.17323803901672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.17327189445496 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='6531'DB:business_master_new
loadtime:0.17390704154968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.17394304275513 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='6531'DB:business_master_new
loadtime:0.17422795295715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.17426705360413 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='6531'DB:business_master_new
loadtime:0.17492699623108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.17497301101685 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='6531'DB:business_master_new
loadtime:0.17552304267883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.17565298080444 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='6531'DB:business_master_new
loadtime:0.17645597457886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.17658400535583 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='6531'DB:business_master_new
loadtime:0.1771559715271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.17718291282654 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='6531'DB:business_master_new
loadtime:0.17780494689941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.1778609752655 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='6531'DB:business_master_new
loadtime:0.17865109443665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.17881798744202 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='6531'DB:business_master_new
loadtime:0.17957091331482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.17962694168091 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='6531'DB:business_master_new
loadtime:0.1802499294281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.18028712272644 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='6531'DB:business_master_new
loadtime:0.18071603775024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.18076395988464 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='6531'DB:business_master_new
loadtime:0.18150591850281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.18155002593994 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='6531'DB:business_master_new
loadtime:0.18218207359314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.18222999572754 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='6531'DB:business_master_new
loadtime:0.1828761100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.18292903900146 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='6531'DB:business_master_new
loadtime:0.1835720539093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.18362092971802 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='6531'DB:business_master_new
loadtime:0.18433594703674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.18438291549683 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='6531'DB:business_master_new
loadtime:0.18517398834229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.18523502349854 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='6531'DB:business_master_new
loadtime:0.18607711791992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.18613696098328 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='6531'DB:business_master_new
loadtime:0.18676590919495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.1868200302124 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='6531'DB:business_master_new
loadtime:0.18744802474976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.1874840259552 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.18809294700623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.18813991546631 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='6531'DB:business_master_new
loadtime:0.18881392478943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.18886590003967 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='6531'DB:business_master_new
loadtime:0.18968892097473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.18973398208618 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='6531'DB:business_master_new
loadtime:0.19009399414062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.19013595581055 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='6531'DB:business_master_new
loadtime:0.19080305099487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.19085502624512 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='6531'DB:business_master_new
loadtime:0.19140100479126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.19143605232239 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='6531'DB:business_master_new
loadtime:0.19183707237244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.1918830871582 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='6531'DB:business_master_new
loadtime:0.21243190765381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.21251392364502 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='6531'DB:business_master_new
loadtime:0.21284794807434 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.21289110183716 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='6531'DB:business_master_new
loadtime:0.21329307556152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.21334004402161 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='6531'DB:business_master_new
loadtime:0.21452903747559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.21459007263184 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='6531'DB:business_master_new
loadtime:0.21499705314636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.21504306793213 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.21618890762329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.21625399589539 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='6531'DB:business_master_new
loadtime:0.21671104431152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.21674799919128 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='6531'DB:business_master_new
loadtime:0.21742105484009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.21747899055481 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='6531'DB:business_master_new
loadtime:0.21810293197632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.21814608573914 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.21883511543274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.21888995170593 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='6531'DB:business_master_new
loadtime:0.21954607963562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.21961092948914 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='6531'DB:business_master_new
loadtime:0.22006106376648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.22008800506592 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='6531'DB:business_master_new
loadtime:0.22111797332764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.22118091583252 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='6531'DB:business_master_new
loadtime:0.22180509567261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.22184896469116 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.22223901748657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.22226595878601 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='6531'DB:business_master_new
loadtime:0.22294211387634 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.22299909591675 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='6531'DB:business_master_new
loadtime:0.22365808486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.22371506690979 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='6531'DB:business_master_new
loadtime:0.2255539894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.22564005851746 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='6531'DB:business_master_new
loadtime:0.22641706466675 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.22646498680115 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='6531'DB:business_master_new
loadtime:0.23760509490967 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.23766207695007 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='6531'DB:business_master_new
loadtime:0.23801493644714 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.23806500434875 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='6531'DB:business_master_new
loadtime:0.23855400085449 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.23859000205994 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='6531'DB:business_master_new
loadtime:0.23925709724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.23930597305298 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='6531'DB:business_master_new
loadtime:0.23993611335754 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.23998689651489 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='6531'DB:business_master_new
loadtime:0.24060297012329 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.2406530380249 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='6531'DB:business_master_new
loadtime:0.24115490913391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.24120306968689 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='6531'DB:business_master_new
loadtime:0.24220108985901 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.24225211143494 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='6531'DB:business_master_new
loadtime:0.24265003204346 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.24270510673523 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='6531'DB:business_master_new
loadtime:0.24304795265198 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.24307489395142 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='6531'DB:business_master_new
loadtime:0.2433180809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.24335503578186 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='6531'DB:business_master_new
loadtime:0.24401903152466 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.24411106109619 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='6531'DB:business_master_new
loadtime:0.24433398246765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.24437594413757 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='6531'DB:business_master_new
loadtime:0.24498105049133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.24504590034485 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='6531'DB:business_master_new
loadtime:0.24566698074341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.24572205543518 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='6531'DB:business_master_new
loadtime:0.24620604515076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.24623894691467 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='6531'DB:business_master_new
loadtime:0.24751400947571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.24771499633789 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='6531'DB:business_master_new
loadtime:0.24831509590149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.24835896492004 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='6531'DB:business_master_new
loadtime:0.24886012077332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.24890804290771 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='6531'DB:business_master_new
loadtime:0.24976706504822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.24991989135742 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='6531'DB:business_master_new
loadtime:0.2503969669342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.25043797492981 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='6531'DB:business_master_new
loadtime:0.25106310844421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.25111889839172 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='6531'DB:business_master_new
loadtime:0.25178599357605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.25184011459351 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='6531'DB:business_master_new
loadtime:0.25216794013977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.25219511985779 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='6531'DB:business_master_new
loadtime:0.25283288955688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.25288796424866 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='6531'DB:business_master_new
loadtime:0.25358295440674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.25373411178589 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='6531'DB:business_master_new
loadtime:0.25445008277893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.25448489189148 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='6531'DB:business_master_new
loadtime:0.25512099266052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.25516891479492 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='6531'DB:business_master_new
loadtime:0.25563097000122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.25572800636292 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='6531'DB:business_master_new
loadtime:0.25666904449463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.25672912597656 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='6531'DB:business_master_new
loadtime:0.25750494003296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.25756311416626 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='6531'DB:business_master_new
loadtime:0.25799894332886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.25802612304688 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='6531'DB:business_master_new
loadtime:0.25901007652283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.25909090042114 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='6531'DB:business_master_new
loadtime:0.25980401039124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.25985908508301 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.26037502288818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.26043295860291 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='6531'DB:business_master_new
loadtime:0.261225938797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.26129007339478 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='6531'DB:business_master_new
loadtime:0.26190209388733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.26193904876709 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='6531'DB:business_master_new
loadtime:0.26281809806824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.26287508010864 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='6531'DB:business_master_new
loadtime:0.26357293128967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.26369190216064 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='6531'DB:business_master_new
loadtime:0.26427412033081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.26430106163025 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='6531'DB:business_master_new
loadtime:0.26477694511414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.26482796669006 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='6531'DB:business_master_new
loadtime:0.26548504829407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.26554203033447 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='6531'DB:business_master_new
loadtime:0.26618695259094 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.26622295379639 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='6531'DB:business_master_new
loadtime:0.26685690879822 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.26691198348999 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='6531'DB:business_master_new
loadtime:0.2674241065979 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.26747298240662 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='6531'DB:business_master_new
loadtime:0.26808309555054 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.26812505722046 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='6531'DB:business_master_new
loadtime:0.26905107498169 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.26911807060242 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='6531'DB:business_master_new
loadtime:0.26951193809509 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.269611120224 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='6531'DB:business_master_new
loadtime:0.27012300491333 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.27016305923462 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='6531'DB:business_master_new
loadtime:0.27040195465088 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.2704770565033 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='6531'DB:business_master_new
loadtime:0.27092790603638 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.27095890045166 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='6531'DB:business_master_new
loadtime:0.27136397361755 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.27139902114868 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='6531'DB:business_master_new
loadtime:0.2716429233551 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.27173495292664 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='6531'DB:business_master_new
loadtime:0.27213406562805 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.2721700668335 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='6531'DB:business_master_new
loadtime:0.27278900146484 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.27283000946045 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='6531'DB:business_master_new
loadtime:0.27320909500122 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.27324891090393 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='6531'DB:business_master_new
loadtime:0.27393412590027 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.27398300170898 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='6531'DB:business_master_new
loadtime:0.27443599700928 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.27448296546936 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='6531'DB:business_master_new
loadtime:0.27491307258606 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.27494502067566 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.27561497688293 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.27576494216919 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='6531'DB:business_master_new
loadtime:0.27610802650452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.27613496780396 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='6531'DB:business_master_new
loadtime:0.27678394317627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.27691006660461 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='6531'DB:business_master_new
loadtime:0.27768397331238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.27784895896912 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='6531'DB:business_master_new
loadtime:0.27857303619385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.27862811088562 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='6531'DB:business_master_new
loadtime:0.27887296676636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.2788999080658 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='6531'DB:business_master_new
loadtime:0.27936911582947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.27941608428955 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='6531'DB:business_master_new
loadtime:0.28006100654602 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.2801079750061 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='6531'DB:business_master_new
loadtime:0.28048610687256 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.2805290222168 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='6531'DB:business_master_new
loadtime:0.28153991699219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.28160309791565 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='6531'DB:business_master_new
loadtime:0.28220200538635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.28222990036011 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='6531'DB:business_master_new
loadtime:0.28284096717834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.28288793563843 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='6531'DB:business_master_new
loadtime:0.2835578918457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.28361511230469 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='6531'DB:business_master_new
loadtime:0.28427505493164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.28431010246277 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='6531'DB:business_master_new
loadtime:0.2848060131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.28484892845154 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='6531'DB:business_master_new
loadtime:0.28665208816528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.28684091567993 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='6531'DB:business_master_new
loadtime:0.28780007362366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.28794097900391 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='6531'DB:business_master_new
loadtime:0.28885889053345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.28901791572571 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='6531'DB:business_master_new
loadtime:0.28988599777222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.28994512557983 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='6531'DB:business_master_new
loadtime:0.29061889648438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.29067492485046 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='6531'DB:business_master_new
loadtime:0.291100025177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.29113793373108 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='6531'DB:business_master_new
loadtime:0.29211902618408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.29217290878296 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='6531'DB:business_master_new
loadtime:0.29281497001648 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.29290008544922 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.29308199882507 / seconds
Operation template executed (chunk cache operation)
loadtime:0.29316306114197 / seconds
template override:Default
loadtime:0.2931809425354 / 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.29396390914917 / seconds
Template Constructed, Array Rows:49
loadtime:0.29421901702881 / seconds
TOTAL EXECUTION TIME: 0.29401
loadtime:0.29437303543091 / 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] => real-estate-agents-and-managers [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.29437708854675
TOTAL KEY ARRAYS: 69