Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.6028366088867E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00063300132751465 / seconds
host not found setting manual db connection
loadtime:0.0013141632080078 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0015480518341064 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0016679763793945 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0017170906066895 / seconds
zipcode:
loadtime:0.0017340183258057 / seconds
Query Executed:select * from search_referrer where page_hash='15162b1a5f21d141d17bae45d4c5b37e' limit 10 DB:ezrox_toadli
loadtime:0.0019030570983887 / seconds
Operation header executed (non global)
loadtime:0.0019450187683105 / seconds
Operation leaderboard executed (non global)
loadtime:0.00201416015625 / seconds
Operation square executed (non global)
loadtime:0.0020511150360107 / seconds
Operation square_bottom executed (non global)
loadtime:0.0020840167999268 / seconds
Operation smallsquare executed (non global)
loadtime:0.0021140575408936 / seconds
Operation headeradright executed (non global)
loadtime:0.0021419525146484 / seconds
Operation google_analytics executed (non global)
loadtime:0.0021700859069824 / seconds
Operation topstories executed (non global)
loadtime:0.0021979808807373 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0022280216217041 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0023031234741211 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0025551319122314 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0027029514312744 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0027530193328857 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0028131008148193 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0028581619262695 / seconds
Template key: archive_menu pushed
loadtime:0.0028631687164307 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0028691291809082 / seconds
Template key: get_gravatar pushed
loadtime:0.0028729438781738 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0028769969940186 / seconds
*10)-10)+1 | start:0
loadtime:0.0028979778289795 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.0029430389404297 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.0029749870300293 / seconds
DB connected to localhost business_master_new
loadtime:0.0032579898834229 / seconds
Query Executed:select * from `vt_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.059409141540527 / seconds
Query stored in cache : _QUERY_www.toadli.comf7ce4d5e68cc40ddd355a2c83f8d8dd7
loadtime:0.060197114944458 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.060240983963013 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='6021'DB:business_master_new
loadtime:0.062127113342285 / seconds
Query stored in cache : _QUERY_www.toadli.com5ba1585d90c0155b54fc08027124c9f8
loadtime:0.062152147293091 / seconds
321 / 11
loadtime:0.06218409538269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.062242984771729 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='6021'DB:business_master_new
loadtime:0.063306093215942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.063354969024658 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='6021'DB:business_master_new
loadtime:0.063797950744629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.063847064971924 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='6021'DB:business_master_new
loadtime:0.064172983169556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.064231157302856 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='6021'DB:business_master_new
loadtime:0.066251039505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.066297054290771 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='6021'DB:business_master_new
loadtime:0.066981077194214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.067028999328613 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='6021'DB:business_master_new
loadtime:0.067295074462891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.06733512878418 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='6021'DB:business_master_new
loadtime:0.067716121673584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.067832946777344 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='6021'DB:business_master_new
loadtime:0.069045066833496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.069180011749268 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='6021'DB:business_master_new
loadtime:0.070305109024048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.070435047149658 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='6021'DB:business_master_new
loadtime:0.071331024169922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.071439981460571 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='6021'DB:business_master_new
loadtime:0.34694814682007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.34702301025391 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='6021'DB:business_master_new
loadtime:0.34756398200989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.34761309623718 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='6021'DB:business_master_new
loadtime:0.34796714782715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.34802198410034 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.36024498939514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.36028003692627 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.36086797714233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.36092615127563 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='6021'DB:business_master_new
loadtime:0.36135411262512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.36140012741089 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='6021'DB:business_master_new
loadtime:0.36172103881836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.36176609992981 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='6021'DB:business_master_new
loadtime:0.36415696144104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.36420893669128 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='6021'DB:business_master_new
loadtime:0.36463904380798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.36469006538391 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='6021'DB:business_master_new
loadtime:0.36508512496948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.36511993408203 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='6021'DB:business_master_new
loadtime:0.36563014984131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.36568903923035 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.36600208282471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.36603903770447 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='6021'DB:business_master_new
loadtime:0.36643695831299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.36646294593811 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='6021'DB:business_master_new
loadtime:0.36692214012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.36698412895203 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='6021'DB:business_master_new
loadtime:0.36747312545776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.36751508712769 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='6021'DB:business_master_new
loadtime:0.36806917190552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.36812305450439 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='6021'DB:business_master_new
loadtime:0.37038516998291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.37044811248779 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='6021'DB:business_master_new
loadtime:0.3708930015564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.37093901634216 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='6021'DB:business_master_new
loadtime:0.37136912345886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.37141394615173 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='6021'DB:business_master_new
loadtime:0.37166213989258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.37169408798218 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='6021'DB:business_master_new
loadtime:0.37209296226501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.37212705612183 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='6021'DB:business_master_new
loadtime:0.37269806861877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.37275505065918 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='6021'DB:business_master_new
loadtime:0.37316107749939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.37320113182068 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='6021'DB:business_master_new
loadtime:0.37344694137573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.37348294258118 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='6021'DB:business_master_new
loadtime:0.3739070892334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.37395405769348 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='6021'DB:business_master_new
loadtime:0.37624001502991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.37630605697632 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='6021'DB:business_master_new
loadtime:0.37675213813782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.37679815292358 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='6021'DB:business_master_new
loadtime:0.3771800994873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.37723302841187 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='6021'DB:business_master_new
loadtime:0.37765908241272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.37769412994385 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='6021'DB:business_master_new
loadtime:0.37802314758301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.37806296348572 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='6021'DB:business_master_new
loadtime:0.37850999832153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.37856101989746 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='6021'DB:business_master_new
loadtime:0.37904405593872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.37910008430481 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='6021'DB:business_master_new
loadtime:0.37955713272095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.37959909439087 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='6021'DB:business_master_new
loadtime:0.38000798225403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.3800630569458 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='6021'DB:business_master_new
loadtime:0.3805730342865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.38062310218811 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='6021'DB:business_master_new
loadtime:0.38107109069824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.38111305236816 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='6021'DB:business_master_new
loadtime:0.38170003890991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.38175201416016 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='6021'DB:business_master_new
loadtime:0.38216996192932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.38221597671509 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='6021'DB:business_master_new
loadtime:0.38344717025757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.38351202011108 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='6021'DB:business_master_new
loadtime:0.38396215438843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.38401103019714 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='6021'DB:business_master_new
loadtime:0.38439416885376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.384437084198 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='6021'DB:business_master_new
loadtime:0.38482809066772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.3848819732666 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='6021'DB:business_master_new
loadtime:0.38527011871338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.38530302047729 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='6021'DB:business_master_new
loadtime:0.38553905487061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.38557696342468 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='6021'DB:business_master_new
loadtime:0.38596796989441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.38599896430969 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='6021'DB:business_master_new
loadtime:0.38642001152039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.38645815849304 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='6021'DB:business_master_new
loadtime:0.38687109947205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.38692998886108 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='6021'DB:business_master_new
loadtime:0.3873770236969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.38742113113403 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='6021'DB:business_master_new
loadtime:0.3879120349884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.38796615600586 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='6021'DB:business_master_new
loadtime:0.38839411735535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.38843297958374 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='6021'DB:business_master_new
loadtime:0.38890409469604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.38893795013428 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='6021'DB:business_master_new
loadtime:0.38918399810791 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.38921594619751 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='6021'DB:business_master_new
loadtime:0.38946509361267 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.38950705528259 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='6021'DB:business_master_new
loadtime:0.38990998268127 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.38995099067688 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='6021'DB:business_master_new
loadtime:0.39034700393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.39038801193237 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='6021'DB:business_master_new
loadtime:0.39428615570068 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.3943350315094 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='6021'DB:business_master_new
loadtime:0.39479613304138 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.39484310150146 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='6021'DB:business_master_new
loadtime:0.39524912834167 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.39529204368591 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='6021'DB:business_master_new
loadtime:0.39831709861755 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.39835214614868 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='6021'DB:business_master_new
loadtime:0.39876699447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.39883899688721 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='6021'DB:business_master_new
loadtime:0.39927005767822 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.39930295944214 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='6021'DB:business_master_new
loadtime:0.39969110488892 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.39974093437195 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='6021'DB:business_master_new
loadtime:0.39996409416199 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.3999969959259 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='6021'DB:business_master_new
loadtime:0.40037107467651 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.40040898323059 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='6021'DB:business_master_new
loadtime:0.40080904960632 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.40085697174072 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='6021'DB:business_master_new
loadtime:0.40397715568542 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.40403008460999 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='6021'DB:business_master_new
loadtime:0.40443396568298 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.40446996688843 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='6021'DB:business_master_new
loadtime:0.40492701530457 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.40497612953186 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='6021'DB:business_master_new
loadtime:0.4052140712738 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.40525197982788 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='6021'DB:business_master_new
loadtime:0.40554094314575 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.40558099746704 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='6021'DB:business_master_new
loadtime:0.40907502174377 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.4091100692749 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='6021'DB:business_master_new
loadtime:0.40951704978943 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.40956211090088 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='6021'DB:business_master_new
loadtime:0.4098949432373 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.40994095802307 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='6021'DB:business_master_new
loadtime:0.41036510467529 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.41040015220642 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='6021'DB:business_master_new
loadtime:0.41078805923462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.41084814071655 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='6021'DB:business_master_new
loadtime:0.41124701499939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.41128706932068 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='6021'DB:business_master_new
loadtime:0.42429995536804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.4243471622467 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.42508912086487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.42515397071838 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='6021'DB:business_master_new
loadtime:0.42560601234436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.42566514015198 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='6021'DB:business_master_new
loadtime:0.42798495292664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.4280309677124 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='6021'DB:business_master_new
loadtime:0.42857503890991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.42863607406616 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='6021'DB:business_master_new
loadtime:0.42912697792053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.42918300628662 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='6021'DB:business_master_new
loadtime:0.42961812019348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.42966604232788 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='6021'DB:business_master_new
loadtime:0.43014812469482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.43020701408386 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='6021'DB:business_master_new
loadtime:0.43046712875366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.43050408363342 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='6021'DB:business_master_new
loadtime:0.43088793754578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.4309561252594 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='6021'DB:business_master_new
loadtime:0.43381309509277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.43386197090149 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='6021'DB:business_master_new
loadtime:0.43428111076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.43431496620178 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='6021'DB:business_master_new
loadtime:0.4376060962677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.43766212463379 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='6021'DB:business_master_new
loadtime:0.44011616706848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.44016814231873 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='6021'DB:business_master_new
loadtime:0.44060707092285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.4406590461731 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='6021'DB:business_master_new
loadtime:0.44108510017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.44112205505371 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='6021'DB:business_master_new
loadtime:0.44141101837158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.4414370059967 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='6021'DB:business_master_new
loadtime:0.44186115264893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.44190907478333 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='6021'DB:business_master_new
loadtime:0.44231796264648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.44236302375793 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='6021'DB:business_master_new
loadtime:0.44274711608887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.44279503822327 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='6021'DB:business_master_new
loadtime:0.44319415092468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.4432430267334 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='6021'DB:business_master_new
loadtime:0.44363594055176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.4436891078949 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='6021'DB:business_master_new
loadtime:0.4441020488739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.44414710998535 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='6021'DB:business_master_new
loadtime:0.44457912445068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.44462609291077 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='6021'DB:business_master_new
loadtime:0.44486212730408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.44489908218384 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='6021'DB:business_master_new
loadtime:0.44526195526123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.44529795646667 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='6021'DB:business_master_new
loadtime:0.44574594497681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.4457950592041 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='6021'DB:business_master_new
loadtime:0.44619011878967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.44621515274048 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='6021'DB:business_master_new
loadtime:0.44668197631836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.44673705101013 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='6021'DB:business_master_new
loadtime:0.44699597358704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.44703412055969 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='6021'DB:business_master_new
loadtime:0.45012307167053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.45016312599182 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='6021'DB:business_master_new
loadtime:0.45061206817627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.45066404342651 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.45106410980225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.45109796524048 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='6021'DB:business_master_new
loadtime:0.45164513587952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.45169997215271 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='6021'DB:business_master_new
loadtime:0.45210909843445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.45215702056885 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='6021'DB:business_master_new
loadtime:0.45273303985596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.45279002189636 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='6021'DB:business_master_new
loadtime:0.45319795608521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.45324110984802 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='6021'DB:business_master_new
loadtime:0.45365810394287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.45370602607727 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='6021'DB:business_master_new
loadtime:0.45417213439941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.45423913002014 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='6021'DB:business_master_new
loadtime:0.45465016365051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.45470213890076 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='6021'DB:business_master_new
loadtime:0.45512413978577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.45516014099121 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='6021'DB:business_master_new
loadtime:0.45562601089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.45568299293518 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='6021'DB:business_master_new
loadtime:0.45593500137329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.45597004890442 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='6021'DB:business_master_new
loadtime:0.45641303062439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.45645308494568 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='6021'DB:business_master_new
loadtime:0.45693016052246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.45698714256287 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='6021'DB:business_master_new
loadtime:0.45724606513977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.45727896690369 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='6021'DB:business_master_new
loadtime:0.4577579498291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.45782113075256 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='6021'DB:business_master_new
loadtime:0.46144199371338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.46149206161499 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='6021'DB:business_master_new
loadtime:0.46197199821472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.46200203895569 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='6021'DB:business_master_new
loadtime:0.46239709854126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.46244215965271 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='6021'DB:business_master_new
loadtime:0.4626989364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.4627320766449 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='6021'DB:business_master_new
loadtime:0.46298694610596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.4630229473114 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='6021'DB:business_master_new
loadtime:0.4634690284729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.46351194381714 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='6021'DB:business_master_new
loadtime:0.46391415596008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.46396207809448 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='6021'DB:business_master_new
loadtime:0.46434807777405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.4643931388855 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='6021'DB:business_master_new
loadtime:0.46495795249939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.46501708030701 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='6021'DB:business_master_new
loadtime:0.46541309356689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.46544694900513 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='6021'DB:business_master_new
loadtime:0.46586012840271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.46590995788574 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='6021'DB:business_master_new
loadtime:0.46630907058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.46633696556091 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='6021'DB:business_master_new
loadtime:0.46689009666443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.46696209907532 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='6021'DB:business_master_new
loadtime:0.46744394302368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.46748614311218 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='6021'DB:business_master_new
loadtime:0.46867704391479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.46872997283936 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='6021'DB:business_master_new
loadtime:0.46900200843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.46904397010803 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='6021'DB:business_master_new
loadtime:0.46943116188049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.46946597099304 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='6021'DB:business_master_new
loadtime:0.46989107131958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.46993207931519 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.47025513648987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.47029900550842 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='6021'DB:business_master_new
loadtime:0.47254014015198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.47259998321533 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='6021'DB:business_master_new
loadtime:0.47287702560425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.47291493415833 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.47331595420837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.47335195541382 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='6021'DB:business_master_new
loadtime:0.47394609451294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.47399616241455 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='6021'DB:business_master_new
loadtime:0.47441506385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.47445797920227 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='6021'DB:business_master_new
loadtime:0.47485709190369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.47490215301514 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='6021'DB:business_master_new
loadtime:0.47530698776245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.47534203529358 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='6021'DB:business_master_new
loadtime:0.4756121635437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.47565007209778 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='6021'DB:business_master_new
loadtime:0.47790098190308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.47796416282654 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='6021'DB:business_master_new
loadtime:0.47839713096619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.47844314575195 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='6021'DB:business_master_new
loadtime:0.478835105896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.47888612747192 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='6021'DB:business_master_new
loadtime:0.4795241355896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.47958517074585 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='6021'DB:business_master_new
loadtime:0.4799530506134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.47999715805054 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='6021'DB:business_master_new
loadtime:0.48039507865906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.48043704032898 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='6021'DB:business_master_new
loadtime:0.48069715499878 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.48072195053101 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='6021'DB:business_master_new
loadtime:0.48108601570129 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.48111701011658 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='6021'DB:business_master_new
loadtime:0.48156094551086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.48160910606384 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='6021'DB:business_master_new
loadtime:0.48199415206909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.48203706741333 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='6021'DB:business_master_new
loadtime:0.4824550151825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.48249912261963 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='6021'DB:business_master_new
loadtime:0.4831600189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.48321509361267 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='6021'DB:business_master_new
loadtime:0.48362612724304 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.4836630821228 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='6021'DB:business_master_new
loadtime:0.48408102989197 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.4841320514679 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='6021'DB:business_master_new
loadtime:0.48438215255737 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.48441314697266 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='6021'DB:business_master_new
loadtime:0.48483204841614 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.48488402366638 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='6021'DB:business_master_new
loadtime:0.48519706726074 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.48523712158203 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='6021'DB:business_master_new
loadtime:0.48547410964966 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.48551511764526 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='6021'DB:business_master_new
loadtime:0.48587608337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.48590111732483 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='6021'DB:business_master_new
loadtime:0.48628211021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.48632097244263 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='6021'DB:business_master_new
loadtime:0.49094295501709 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.49099707603455 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='6021'DB:business_master_new
loadtime:0.49130511283875 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.49133801460266 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='6021'DB:business_master_new
loadtime:0.49174809455872 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.49179911613464 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='6021'DB:business_master_new
loadtime:0.49551510810852 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.49556398391724 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='6021'DB:business_master_new
loadtime:0.49598598480225 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.49602293968201 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='6021'DB:business_master_new
loadtime:0.49953413009644 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.49958300590515 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='6021'DB:business_master_new
loadtime:0.50001811981201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.50006198883057 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='6021'DB:business_master_new
loadtime:0.5006251335144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.50067400932312 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.50106906890869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.50111699104309 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='6021'DB:business_master_new
loadtime:0.5015389919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.50159096717834 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='6021'DB:business_master_new
loadtime:0.50212717056274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.50218415260315 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='6021'DB:business_master_new
loadtime:0.50244402885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.50248503684998 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='6021'DB:business_master_new
loadtime:0.50292205810547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.50297403335571 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='6021'DB:business_master_new
loadtime:0.50340700149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.50344705581665 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='6021'DB:business_master_new
loadtime:0.50371503829956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.50375294685364 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='6021'DB:business_master_new
loadtime:0.50414299964905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.50417804718018 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='6021'DB:business_master_new
loadtime:0.50458908081055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.50462603569031 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='6021'DB:business_master_new
loadtime:0.50505399703979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.50510406494141 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='6021'DB:business_master_new
loadtime:0.50552010536194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.5055730342865 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='6021'DB:business_master_new
loadtime:0.50597500801086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.50601816177368 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='6021'DB:business_master_new
loadtime:0.50650906562805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.50656294822693 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='6021'DB:business_master_new
loadtime:0.50701999664307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.50706815719604 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='6021'DB:business_master_new
loadtime:0.50745916366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.50750112533569 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='6021'DB:business_master_new
loadtime:0.50788497924805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.50794100761414 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='6021'DB:business_master_new
loadtime:0.5084011554718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.50843596458435 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='6021'DB:business_master_new
loadtime:0.50885510444641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.50890612602234 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='6021'DB:business_master_new
loadtime:0.50934314727783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.50939011573792 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='6021'DB:business_master_new
loadtime:0.50979208946228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.50983905792236 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='6021'DB:business_master_new
loadtime:0.51031804084778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.51035904884338 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='6021'DB:business_master_new
loadtime:0.51081895828247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.51087498664856 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='6021'DB:business_master_new
loadtime:0.51141810417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.51146411895752 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='6021'DB:business_master_new
loadtime:0.51187515258789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.51192402839661 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='6021'DB:business_master_new
loadtime:0.51232004165649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.51235294342041 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='6021'DB:business_master_new
loadtime:0.51276898384094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.51282405853271 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='6021'DB:business_master_new
loadtime:0.51325106620789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.51329708099365 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='6021'DB:business_master_new
loadtime:0.5138111114502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.51386094093323 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='6021'DB:business_master_new
loadtime:0.5324010848999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.5324490070343 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='6021'DB:business_master_new
loadtime:0.53292012214661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.53297305107117 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='6021'DB:business_master_new
loadtime:0.53338503837585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.53342604637146 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='6021'DB:business_master_new
loadtime:0.53898811340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.53904008865356 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='6021'DB:business_master_new
loadtime:0.5413179397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.54137516021729 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='6021'DB:business_master_new
loadtime:0.54170703887939 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.54176115989685 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='6021'DB:business_master_new
loadtime:0.54439401626587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.54444599151611 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='6021'DB:business_master_new
loadtime:0.54670906066895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.54676294326782 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.56769609451294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.56775903701782 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='6021'DB:business_master_new
loadtime:0.56881308555603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.56885814666748 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='6021'DB:business_master_new
loadtime:0.56928014755249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.5693199634552 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='6021'DB:business_master_new
loadtime:0.56976294517517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.56981015205383 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='6021'DB:business_master_new
loadtime:0.57020711898804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.57024693489075 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='6021'DB:business_master_new
loadtime:0.57069897651672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.5707471370697 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='6021'DB:business_master_new
loadtime:0.57116103172302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.57119417190552 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='6021'DB:business_master_new
loadtime:0.57160711288452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.57165503501892 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='6021'DB:business_master_new
loadtime:0.57229399681091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.57235312461853 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='6021'DB:business_master_new
loadtime:0.57276916503906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.57281494140625 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.57620406150818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.57626008987427 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='6021'DB:business_master_new
loadtime:0.57671713829041 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.57676601409912 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='6021'DB:business_master_new
loadtime:0.57717108726501 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.57720804214478 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='6021'DB:business_master_new
loadtime:0.57949495315552 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.5795590877533 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='6021'DB:business_master_new
loadtime:0.58005499839783 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.58010411262512 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='6021'DB:business_master_new
loadtime:0.58054494857788 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.58059501647949 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='6021'DB:business_master_new
loadtime:0.58356904983521 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.58360505104065 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='6021'DB:business_master_new
loadtime:0.5840311050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.58407998085022 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='6021'DB:business_master_new
loadtime:0.58456015586853 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.58460307121277 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='6021'DB:business_master_new
loadtime:0.5849871635437 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.58504104614258 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='6021'DB:business_master_new
loadtime:0.58542394638062 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.58547210693359 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='6021'DB:business_master_new
loadtime:0.58586502075195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.58591198921204 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='6021'DB:business_master_new
loadtime:0.58691716194153 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.58697199821472 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='6021'DB:business_master_new
loadtime:0.59039902687073 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.59045505523682 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.59081411361694 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.59085893630981 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='6021'DB:business_master_new
loadtime:0.59111714363098 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.5911500453949 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='6021'DB:business_master_new
loadtime:0.59159708023071 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.59164810180664 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='6021'DB:business_master_new
loadtime:0.5918710231781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.59190797805786 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='6021'DB:business_master_new
loadtime:0.59227299690247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.59229803085327 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='6021'DB:business_master_new
loadtime:0.59269404411316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.59275412559509 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='6021'DB:business_master_new
loadtime:0.59313607215881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.59317111968994 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='6021'DB:business_master_new
loadtime:0.59425711631775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.59431409835815 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='6021'DB:business_master_new
loadtime:0.59472393989563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.59477615356445 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='6021'DB:business_master_new
loadtime:0.59516596794128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.59520816802979 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='6021'DB:business_master_new
loadtime:0.59576106071472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.59580993652344 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='6021'DB:business_master_new
loadtime:0.59618997573853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.59624814987183 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='6021'DB:business_master_new
loadtime:0.59664702415466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.59668803215027 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='6021'DB:business_master_new
loadtime:0.59707713127136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.59711194038391 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='6021'DB:business_master_new
loadtime:0.59999704360962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.6000440120697 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='6021'DB:business_master_new
loadtime:0.60046100616455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.60049915313721 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='6021'DB:business_master_new
loadtime:0.60089707374573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.60093116760254 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='6021'DB:business_master_new
loadtime:0.60133409500122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.60137510299683 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='6021'DB:business_master_new
loadtime:0.60176205635071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.60179495811462 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='6021'DB:business_master_new
loadtime:0.60216307640076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.60219502449036 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='6021'DB:business_master_new
loadtime:0.60273313522339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.60277795791626 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='6021'DB:business_master_new
loadtime:0.60319304466248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.60323405265808 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='6021'DB:business_master_new
loadtime:0.60358810424805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.60362410545349 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='6021'DB:business_master_new
loadtime:0.60416197776794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.60420203208923 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='6021'DB:business_master_new
loadtime:0.60462999343872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.60466694831848 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='6021'DB:business_master_new
loadtime:0.60502409934998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.60505795478821 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='6021'DB:business_master_new
loadtime:0.6054949760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.6055281162262 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='6021'DB:business_master_new
loadtime:0.60589694976807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.60593008995056 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='6021'DB:business_master_new
loadtime:0.60648798942566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.60652112960815 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='6021'DB:business_master_new
loadtime:0.60692095756531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.60695910453796 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='6021'DB:business_master_new
loadtime:0.60735106468201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.60738515853882 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='6021'DB:business_master_new
loadtime:0.60776495933533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.60779905319214 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='6021'DB:business_master_new
loadtime:0.60814905166626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.60817193984985 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='6021'DB:business_master_new
loadtime:0.60856699943542 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.60861206054688 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='6021'DB:business_master_new
loadtime:0.60899901390076 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.6090259552002 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='6021'DB:business_master_new
loadtime:0.60938715934753 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.60942101478577 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='6021'DB:business_master_new
loadtime:0.609787940979 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.60981702804565 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='6021'DB:business_master_new
loadtime:0.61027216911316 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.61031198501587 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='6021'DB:business_master_new
loadtime:0.61329507827759 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.61334609985352 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='6021'DB:business_master_new
loadtime:0.61374306678772 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.61378407478333 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='6021'DB:business_master_new
loadtime:0.61402010917664 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.61406111717224 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='6021'DB:business_master_new
loadtime:0.61443901062012 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.61448407173157 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='6021'DB:business_master_new
loadtime:0.61487698554993 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.61492109298706 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='6021'DB:business_master_new
loadtime:0.61516213417053 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.61520409584045 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='6021'DB:business_master_new
loadtime:0.61815094947815 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.61821603775024 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='6021'DB:business_master_new
loadtime:0.61870002746582 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.61874413490295 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='6021'DB:business_master_new
loadtime:0.61912202835083 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.61916494369507 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='6021'DB:business_master_new
loadtime:0.61964201927185 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.61969113349915 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='6021'DB:business_master_new
loadtime:0.62006211280823 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.62010097503662 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='6021'DB:business_master_new
loadtime:0.62050294876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.6205530166626 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='6021'DB:business_master_new
loadtime:0.62094616889954 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.62098813056946 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='6021'DB:business_master_new
loadtime:0.62124013900757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.62127900123596 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='6021'DB:business_master_new
loadtime:0.62167096138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.62172102928162 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='6021'DB:business_master_new
loadtime:0.62213516235352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.62217712402344 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='6021'DB:business_master_new
loadtime:0.62260103225708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.62265205383301 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='6021'DB:business_master_new
loadtime:0.62288999557495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.62292695045471 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='6021'DB:business_master_new
loadtime:0.62330198287964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.62333202362061 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='6021'DB:business_master_new
loadtime:0.6237530708313 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.62380409240723 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='6021'DB:business_master_new
loadtime:0.62858104705811 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.62862205505371 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='6021'DB:business_master_new
loadtime:0.62934017181396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.62939310073853 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='6021'DB:business_master_new
loadtime:0.62979412078857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.62983012199402 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='6021'DB:business_master_new
loadtime:0.63023900985718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.63027811050415 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='6021'DB:business_master_new
loadtime:0.63069200515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.63072800636292 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='6021'DB:business_master_new
loadtime:0.63116908073425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.63121008872986 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='6021'DB:business_master_new
loadtime:0.63161516189575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.63165307044983 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='6021'DB:business_master_new
loadtime:0.63387799263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.63392901420593 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='6021'DB:business_master_new
loadtime:0.63444209098816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.6344850063324 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='6021'DB:business_master_new
loadtime:0.63501811027527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.63505697250366 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='6021'DB:business_master_new
loadtime:0.63561701774597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.63565802574158 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='6021'DB:business_master_new
loadtime:0.63607215881348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.63610696792603 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='6021'DB:business_master_new
loadtime:0.63650012016296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.63653707504272 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='6021'DB:business_master_new
loadtime:0.63714694976807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.63718795776367 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='6021'DB:business_master_new
loadtime:0.63764309883118 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.63772702217102 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.63790202140808 / seconds
Operation template executed (chunk cache operation)
loadtime:0.63798093795776 / seconds
template override:Default
loadtime:0.63799905776978 / 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.6389319896698 / seconds
Template Constructed, Array Rows:49
loadtime:0.63918113708496 / seconds
TOTAL EXECUTION TIME: 0.63899
loadtime:0.6392810344696 / 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] => national-commercial-banks [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.63928604125977
TOTAL KEY ARRAYS: 69