Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00017905235290527 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011000633239746 / seconds
host not found setting manual db connection
loadtime:0.0015389919281006 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018081665039062 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0020120143890381 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0020670890808105 / seconds
zipcode:
loadtime:0.0020849704742432 / seconds
Query Executed:select * from search_referrer where page_hash='4ccc138602b52d8564139263213896f0' limit 10 DB:ezrox_toadli
loadtime:0.0022950172424316 / seconds
Operation header executed (non global)
loadtime:0.0023131370544434 / seconds
Operation leaderboard executed (non global)
loadtime:0.0023550987243652 / seconds
Operation square executed (non global)
loadtime:0.0023810863494873 / seconds
Operation square_bottom executed (non global)
loadtime:0.0023951530456543 / seconds
Operation smallsquare executed (non global)
loadtime:0.0024070739746094 / seconds
Operation headeradright executed (non global)
loadtime:0.002418041229248 / seconds
Operation google_analytics executed (non global)
loadtime:0.0024290084838867 / seconds
Operation topstories executed (non global)
loadtime:0.0024411678314209 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0024521350860596 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0024621486663818 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0026991367340088 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0028519630432129 / seconds
Operation categories executed (global stored into APC)
loadtime:0.002892017364502 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0029599666595459 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0029990673065186 / seconds
Template key: archive_menu pushed
loadtime:0.0030050277709961 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0030109882354736 / seconds
Template key: get_gravatar pushed
loadtime:0.0030150413513184 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0030190944671631 / seconds
*10)-10)+1 | start:0
loadtime:0.0030419826507568 / seconds
Query loaded from cache:select * from categories where cat_URLid='eating-places'
loadtime:0.00307297706604 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.0030980110168457 / seconds
DB connected to localhost business_master_new
loadtime:0.0036861896514893 / seconds
Query Executed:select * from `vt_catmap` where sic='5812' order by city ascDB:business_master_new
loadtime:0.061817169189453 / seconds
Query stored in cache : _QUERY_www.toadli.comba4aba2670dca24138ee89abdc8b9036
loadtime:0.062662124633789 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='vermont'
loadtime:0.062702178955078 / seconds
Query Executed:select sum(totalcount) as totalsum from `vt_catmap` where sic='5812'DB:business_master_new
loadtime:0.064764976501465 / seconds
Query stored in cache : _QUERY_www.toadli.com156321dad40d91e7f06662f13350baaf
loadtime:0.064790964126587 / seconds
321 / 11
loadtime:0.064823150634766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamant' limit 1
loadtime:0.064870119094849 / seconds
Query Executed:select id FROM `vt` where city='Adamant' && SIC_code='5812'DB:business_master_new
loadtime:0.066612005233765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.066660165786743 / seconds
Query Executed:select id FROM `vt` where city='Albany' && SIC_code='5812'DB:business_master_new
loadtime:0.067124128341675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburg' limit 1
loadtime:0.067157983779907 / seconds
Query Executed:select id FROM `vt` where city='Alburg' && SIC_code='5812'DB:business_master_new
loadtime:0.067429065704346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.067461013793945 / seconds
Query Executed:select id FROM `vt` where city='Arlington' && SIC_code='5812'DB:business_master_new
loadtime:0.068380117416382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ascutney' limit 1
loadtime:0.068418025970459 / seconds
Query Executed:select id FROM `vt` where city='Ascutney' && SIC_code='5812'DB:business_master_new
loadtime:0.069198131561279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.069243192672729 / seconds
Query Executed:select id FROM `vt` where city='Athens' && SIC_code='5812'DB:business_master_new
loadtime:0.069480180740356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Averill' limit 1
loadtime:0.069513082504272 / seconds
Query Executed:select id FROM `vt` where city='Averill' && SIC_code='5812'DB:business_master_new
loadtime:0.069792032241821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersfield' limit 1
loadtime:0.069816112518311 / seconds
Query Executed:select id FROM `vt` where city='Bakersfield' && SIC_code='5812'DB:business_master_new
loadtime:0.070234060287476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.070268154144287 / seconds
Query Executed:select id FROM `vt` where city='Barnard' && SIC_code='5812'DB:business_master_new
loadtime:0.070891141891479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnet' limit 1
loadtime:0.070923089981079 / seconds
Query Executed:select id FROM `vt` where city='Barnet' && SIC_code='5812'DB:business_master_new
loadtime:0.071640968322754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.071675062179565 / seconds
Query Executed:select id FROM `vt` where city='Barre' && SIC_code='5812'DB:business_master_new
loadtime:0.073395967483521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton' limit 1
loadtime:0.07346510887146 / seconds
Query Executed:select id FROM `vt` where city='Barton' && SIC_code='5812'DB:business_master_new
loadtime:0.074313163757324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beebe Plain' limit 1
loadtime:0.074357986450195 / seconds
Query Executed:select id FROM `vt` where city='Beebe Plain' && SIC_code='5812'DB:business_master_new
loadtime:0.074666023254395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beecher Falls' limit 1
loadtime:0.074692010879517 / seconds
Query Executed:select id FROM `vt` where city='Beecher Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.074999094009399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellows Falls' limit 1
loadtime:0.075038194656372 / seconds
Query Executed:select id FROM `vt` where city='Bellows Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.0870201587677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.087082147598267 / seconds
Query Executed:select id FROM `vt` where city='Belmont' && SIC_code='5812'DB:business_master_new
loadtime:0.087543964385986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere Center' limit 1
loadtime:0.087581157684326 / seconds
Query Executed:select id FROM `vt` where city='Belvidere Center' && SIC_code='5812'DB:business_master_new
loadtime:0.087905168533325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.087952136993408 / seconds
Query Executed:select id FROM `vt` where city='Bennington' && SIC_code='5812'DB:business_master_new
loadtime:0.08962607383728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.089708089828491 / seconds
Query Executed:select id FROM `vt` where city='Benson' && SIC_code='5812'DB:business_master_new
loadtime:0.090129137039185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.090185165405273 / seconds
Query Executed:select id FROM `vt` where city='Berlin' && SIC_code='5812'DB:business_master_new
loadtime:0.090620994567871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.090667009353638 / seconds
Query Executed:select id FROM `vt` where city='Bethel' && SIC_code='5812'DB:business_master_new
loadtime:0.091541051864624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton Valley' limit 1
loadtime:0.091587066650391 / seconds
Query Executed:select id FROM `vt` where city='Bolton Valley' && SIC_code='5812'DB:business_master_new
loadtime:0.091919183731079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomoseen' limit 1
loadtime:0.091967105865479 / seconds
Query Executed:select id FROM `vt` where city='Bomoseen' && SIC_code='5812'DB:business_master_new
loadtime:0.092777013778687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondville' limit 1
loadtime:0.09282112121582 / seconds
Query Executed:select id FROM `vt` where city='Bondville' && SIC_code='5812'DB:business_master_new
loadtime:0.093619108200073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.093677043914795 / seconds
Query Executed:select id FROM `vt` where city='Bradford' && SIC_code='5812'DB:business_master_new
loadtime:0.094640016555786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.094705104827881 / seconds
Query Executed:select id FROM `vt` where city='Brandon' && SIC_code='5812'DB:business_master_new
loadtime:0.095694065093994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brattleboro' limit 1
loadtime:0.095755100250244 / seconds
Query Executed:select id FROM `vt` where city='Brattleboro' && SIC_code='5812'DB:business_master_new
loadtime:0.097881078720093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.097977161407471 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater' && SIC_code='5812'DB:business_master_new
loadtime:0.098678112030029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Corners' limit 1
loadtime:0.098726034164429 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Corners' && SIC_code='5812'DB:business_master_new
loadtime:0.099297046661377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater Cors' limit 1
loadtime:0.099354982376099 / seconds
Query Executed:select id FROM `vt` where city='Bridgewater Cors' && SIC_code='5812'DB:business_master_new
loadtime:0.099622964859009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridport' limit 1
loadtime:0.099652051925659 / seconds
Query Executed:select id FROM `vt` where city='Bridport' && SIC_code='5812'DB:business_master_new
loadtime:0.10042500495911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.10047912597656 / seconds
Query Executed:select id FROM `vt` where city='Bristol' && SIC_code='5812'DB:business_master_new
loadtime:0.10152101516724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.10158514976501 / seconds
Query Executed:select id FROM `vt` where city='Brookfield' && SIC_code='5812'DB:business_master_new
loadtime:0.1022469997406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.10229301452637 / seconds
Query Executed:select id FROM `vt` where city='Brookline' && SIC_code='5812'DB:business_master_new
loadtime:0.10253119468689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.1025710105896 / seconds
Query Executed:select id FROM `vt` where city='Brownsville' && SIC_code='5812'DB:business_master_new
loadtime:0.10324907302856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.10329914093018 / seconds
Query Executed:select id FROM `vt` where city='Burlington' && SIC_code='5812'DB:business_master_new
loadtime:0.10812902450562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabot' limit 1
loadtime:0.1082661151886 / seconds
Query Executed:select id FROM `vt` where city='Cabot' && SIC_code='5812'DB:business_master_new
loadtime:0.10947918891907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calais' limit 1
loadtime:0.10958003997803 / seconds
Query Executed:select id FROM `vt` where city='Calais' && SIC_code='5812'DB:business_master_new
loadtime:0.11032104492188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.1103720664978 / seconds
Query Executed:select id FROM `vt` where city='Cambridge' && SIC_code='5812'DB:business_master_new
loadtime:0.11225199699402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridgeport' limit 1
loadtime:0.11230802536011 / seconds
Query Executed:select id FROM `vt` where city='Cambridgeport' && SIC_code='5812'DB:business_master_new
loadtime:0.11275196075439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.11285400390625 / seconds
Query Executed:select id FROM `vt` where city='Canaan' && SIC_code='5812'DB:business_master_new
loadtime:0.11475706100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.11488008499146 / seconds
Query Executed:select id FROM `vt` where city='Castleton' && SIC_code='5812'DB:business_master_new
loadtime:0.11700105667114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavendish' limit 1
loadtime:0.11716413497925 / seconds
Query Executed:select id FROM `vt` where city='Cavendish' && SIC_code='5812'DB:business_master_new
loadtime:0.11912512779236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Rutland' limit 1
loadtime:0.11924505233765 / seconds
Query Executed:select id FROM `vt` where city='Center Rutland' && SIC_code='5812'DB:business_master_new
loadtime:0.12069296836853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.12085604667664 / seconds
Query Executed:select id FROM `vt` where city='Charlotte' && SIC_code='5812'DB:business_master_new
loadtime:0.12327098846436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.12342500686646 / seconds
Query Executed:select id FROM `vt` where city='Chelsea' && SIC_code='5812'DB:business_master_new
loadtime:0.12537813186646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.12554097175598 / seconds
Query Executed:select id FROM `vt` where city='Chester' && SIC_code='5812'DB:business_master_new
loadtime:0.12820315361023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chittenden' limit 1
loadtime:0.12825202941895 / seconds
Query Executed:select id FROM `vt` where city='Chittenden' && SIC_code='5812'DB:business_master_new
loadtime:0.1293261051178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.12945699691772 / seconds
Query Executed:select id FROM `vt` where city='Colchester' && SIC_code='5812'DB:business_master_new
loadtime:0.133052110672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.13312697410583 / seconds
Query Executed:select id FROM `vt` where city='Concord' && SIC_code='5812'DB:business_master_new
loadtime:0.13510417938232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.13526105880737 / seconds
Query Executed:select id FROM `vt` where city='Corinth' && SIC_code='5812'DB:business_master_new
loadtime:0.136803150177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.1368579864502 / seconds
Query Executed:select id FROM `vt` where city='Coventry' && SIC_code='5812'DB:business_master_new
loadtime:0.13724517822266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury' limit 1
loadtime:0.13728904724121 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.13792896270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Cmn' limit 1
loadtime:0.13798499107361 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Cmn' && SIC_code='5812'DB:business_master_new
loadtime:0.13821911811829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craftsbury Common' limit 1
loadtime:0.13824701309204 / seconds
Query Executed:select id FROM `vt` where city='Craftsbury Common' && SIC_code='5812'DB:business_master_new
loadtime:0.13872003555298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttingsville' limit 1
loadtime:0.13875603675842 / seconds
Query Executed:select id FROM `vt` where city='Cuttingsville' && SIC_code='5812'DB:business_master_new
loadtime:0.13956999778748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danby' limit 1
loadtime:0.13963317871094 / seconds
Query Executed:select id FROM `vt` where city='Danby' && SIC_code='5812'DB:business_master_new
loadtime:0.14043617248535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.14049506187439 / seconds
Query Executed:select id FROM `vt` where city='Danville' && SIC_code='5812'DB:business_master_new
loadtime:0.14136505126953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.14142417907715 / seconds
Query Executed:select id FROM `vt` where city='Derby' && SIC_code='5812'DB:business_master_new
loadtime:0.14237999916077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby Line' limit 1
loadtime:0.14244198799133 / seconds
Query Executed:select id FROM `vt` where city='Derby Line' && SIC_code='5812'DB:business_master_new
loadtime:0.1432991027832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorset' limit 1
loadtime:0.14335608482361 / seconds
Query Executed:select id FROM `vt` where city='Dorset' && SIC_code='5812'DB:business_master_new
loadtime:0.14418196678162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummerston' limit 1
loadtime:0.14421701431274 / seconds
Query Executed:select id FROM `vt` where city='Dummerston' && SIC_code='5812'DB:business_master_new
loadtime:0.14445400238037 / seconds
Query loaded from cache:select * from geodata_geocity where city='E St Johnsbury' limit 1
loadtime:0.14449715614319 / seconds
Query Executed:select id FROM `vt` where city='E St Johnsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.14473700523376 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.14477205276489 / seconds
Query Executed:select id FROM `vt` where city='East Arlington' && SIC_code='5812'DB:business_master_new
loadtime:0.14524912834167 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Barre' limit 1
loadtime:0.14529418945312 / seconds
Query Executed:select id FROM `vt` where city='East Barre' && SIC_code='5812'DB:business_master_new
loadtime:0.14605712890625 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berkshire' limit 1
loadtime:0.14610505104065 / seconds
Query Executed:select id FROM `vt` where city='East Berkshire' && SIC_code='5812'DB:business_master_new
loadtime:0.14646196365356 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Burke' limit 1
loadtime:0.14649796485901 / seconds
Query Executed:select id FROM `vt` where city='East Burke' && SIC_code='5812'DB:business_master_new
loadtime:0.14727115631104 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Calais' limit 1
loadtime:0.14733004570007 / seconds
Query Executed:select id FROM `vt` where city='East Calais' && SIC_code='5812'DB:business_master_new
loadtime:0.14778614044189 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Charleston' limit 1
loadtime:0.14781999588013 / seconds
Query Executed:select id FROM `vt` where city='East Charleston' && SIC_code='5812'DB:business_master_new
loadtime:0.14813208580017 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Corinth' limit 1
loadtime:0.14817309379578 / seconds
Query Executed:select id FROM `vt` where city='East Corinth' && SIC_code='5812'DB:business_master_new
loadtime:0.14871215820312 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dorset' limit 1
loadtime:0.14873814582825 / seconds
Query Executed:select id FROM `vt` where city='East Dorset' && SIC_code='5812'DB:business_master_new
loadtime:0.14951014518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dover' limit 1
loadtime:0.14956617355347 / seconds
Query Executed:select id FROM `vt` where city='East Dover' && SIC_code='5812'DB:business_master_new
loadtime:0.15056419372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dummerston' limit 1
loadtime:0.15063118934631 / seconds
Query Executed:select id FROM `vt` where city='East Dummerston' && SIC_code='5812'DB:business_master_new
loadtime:0.15085315704346 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fairfield' limit 1
loadtime:0.1508800983429 / seconds
Query Executed:select id FROM `vt` where city='East Fairfield' && SIC_code='5812'DB:business_master_new
loadtime:0.15137910842896 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hardwick' limit 1
loadtime:0.15142798423767 / seconds
Query Executed:select id FROM `vt` where city='East Hardwick' && SIC_code='5812'DB:business_master_new
loadtime:0.15204906463623 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.15208411216736 / seconds
Query Executed:select id FROM `vt` where city='East Haven' && SIC_code='5812'DB:business_master_new
loadtime:0.15242099761963 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Middlebury' limit 1
loadtime:0.15246105194092 / seconds
Query Executed:select id FROM `vt` where city='East Middlebury' && SIC_code='5812'DB:business_master_new
loadtime:0.15301108360291 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Montpelier' limit 1
loadtime:0.15304613113403 / seconds
Query Executed:select id FROM `vt` where city='East Montpelier' && SIC_code='5812'DB:business_master_new
loadtime:0.15385603904724 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.15390396118164 / seconds
Query Executed:select id FROM `vt` where city='East Orange' && SIC_code='5812'DB:business_master_new
loadtime:0.15413403511047 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Poultney' limit 1
loadtime:0.1541600227356 / seconds
Query Executed:select id FROM `vt` where city='East Poultney' && SIC_code='5812'DB:business_master_new
loadtime:0.154452085495 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Randolph' limit 1
loadtime:0.15448403358459 / seconds
Query Executed:select id FROM `vt` where city='East Randolph' && SIC_code='5812'DB:business_master_new
loadtime:0.15480709075928 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ryegate' limit 1
loadtime:0.15484118461609 / seconds
Query Executed:select id FROM `vt` where city='East Ryegate' && SIC_code='5812'DB:business_master_new
loadtime:0.15527415275574 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Saint Johnsbury' limit 1
loadtime:0.15530896186829 / seconds
Query Executed:select id FROM `vt` where city='East Saint Johnsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.15559196472168 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Thetford' limit 1
loadtime:0.15564298629761 / seconds
Query Executed:select id FROM `vt` where city='East Thetford' && SIC_code='5812'DB:business_master_new
loadtime:0.15644502639771 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wallingford' limit 1
loadtime:0.15649199485779 / seconds
Query Executed:select id FROM `vt` where city='East Wallingford' && SIC_code='5812'DB:business_master_new
loadtime:0.15691900253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.15697503089905 / seconds
Query Executed:select id FROM `vt` where city='Eden' && SIC_code='5812'DB:business_master_new
loadtime:0.15742206573486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden Mills' limit 1
loadtime:0.15746307373047 / seconds
Query Executed:select id FROM `vt` where city='Eden Mills' && SIC_code='5812'DB:business_master_new
loadtime:0.15778398513794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enosburg Falls' limit 1
loadtime:0.15781116485596 / seconds
Query Executed:select id FROM `vt` where city='Enosburg Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.15880703926086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.15886807441711 / seconds
Query Executed:select id FROM `vt` where city='Essex' && SIC_code='5812'DB:business_master_new
loadtime:0.15963101387024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Junction' limit 1
loadtime:0.15968012809753 / seconds
Query Executed:select id FROM `vt` where city='Essex Junction' && SIC_code='5812'DB:business_master_new
loadtime:0.16152596473694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.16161704063416 / seconds
Query Executed:select id FROM `vt` where city='Fair Haven' && SIC_code='5812'DB:business_master_new
loadtime:0.16257405281067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.16265106201172 / seconds
Query Executed:select id FROM `vt` where city='Fairfax' && SIC_code='5812'DB:business_master_new
loadtime:0.16351008415222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.16356301307678 / seconds
Query Executed:select id FROM `vt` where city='Fairfield' && SIC_code='5812'DB:business_master_new
loadtime:0.16432809829712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlee' limit 1
loadtime:0.16438317298889 / seconds
Query Executed:select id FROM `vt` where city='Fairlee' && SIC_code='5812'DB:business_master_new
loadtime:0.16527199745178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrisburg' limit 1
loadtime:0.16532015800476 / seconds
Query Executed:select id FROM `vt` where city='Ferrisburg' && SIC_code='5812'DB:business_master_new
loadtime:0.16556715965271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.16562509536743 / seconds
Query Executed:select id FROM `vt` where city='Florence' && SIC_code='5812'DB:business_master_new
loadtime:0.16633605957031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Dale' limit 1
loadtime:0.1663830280304 / seconds
Query Executed:select id FROM `vt` where city='Forest Dale' && SIC_code='5812'DB:business_master_new
loadtime:0.1668381690979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.16687607765198 / seconds
Query Executed:select id FROM `vt` where city='Franklin' && SIC_code='5812'DB:business_master_new
loadtime:0.16800713539124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaysville' limit 1
loadtime:0.16805100440979 / seconds
Query Executed:select id FROM `vt` where city='Gaysville' && SIC_code='5812'DB:business_master_new
loadtime:0.16850996017456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.16855812072754 / seconds
Query Executed:select id FROM `vt` where city='Gilman' && SIC_code='5812'DB:business_master_new
loadtime:0.16896915435791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glover' limit 1
loadtime:0.16901803016663 / seconds
Query Executed:select id FROM `vt` where city='Glover' && SIC_code='5812'DB:business_master_new
loadtime:0.17033410072327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.17038297653198 / seconds
Query Executed:select id FROM `vt` where city='Grafton' && SIC_code='5812'DB:business_master_new
loadtime:0.17118096351624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.17121601104736 / seconds
Query Executed:select id FROM `vt` where city='Granby' && SIC_code='5812'DB:business_master_new
loadtime:0.17151212692261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Isle' limit 1
loadtime:0.171550989151 / seconds
Query Executed:select id FROM `vt` where city='Grand Isle' && SIC_code='5812'DB:business_master_new
loadtime:0.1723690032959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graniteville' limit 1
loadtime:0.1724259853363 / seconds
Query Executed:select id FROM `vt` where city='Graniteville' && SIC_code='5812'DB:business_master_new
loadtime:0.17299914360046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.17304611206055 / seconds
Query Executed:select id FROM `vt` where city='Granville' && SIC_code='5812'DB:business_master_new
loadtime:0.17346000671387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.17349600791931 / seconds
Query Executed:select id FROM `vt` where city='Greensboro' && SIC_code='5812'DB:business_master_new
loadtime:0.17408514022827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro Bend' limit 1
loadtime:0.17413306236267 / seconds
Query Executed:select id FROM `vt` where city='Greensboro Bend' && SIC_code='5812'DB:business_master_new
loadtime:0.17455101013184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.17458605766296 / seconds
Query Executed:select id FROM `vt` where city='Groton' && SIC_code='5812'DB:business_master_new
loadtime:0.17540216445923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guildhall' limit 1
loadtime:0.17546010017395 / seconds
Query Executed:select id FROM `vt` where city='Guildhall' && SIC_code='5812'DB:business_master_new
loadtime:0.17603206634521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.17607617378235 / seconds
Query Executed:select id FROM `vt` where city='Guilford' && SIC_code='5812'DB:business_master_new
loadtime:0.17631316184998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.17635607719421 / seconds
Query Executed:select id FROM `vt` where city='Hancock' && SIC_code='5812'DB:business_master_new
loadtime:0.1768901348114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.17694616317749 / seconds
Query Executed:select id FROM `vt` where city='Hardwick' && SIC_code='5812'DB:business_master_new
loadtime:0.17783403396606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.17789506912231 / seconds
Query Executed:select id FROM `vt` where city='Hartford' && SIC_code='5812'DB:business_master_new
loadtime:0.17868709564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:0.17874717712402 / seconds
Query Executed:select id FROM `vt` where city='Hartland' && SIC_code='5812'DB:business_master_new
loadtime:0.17956113815308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland 4 Cors' limit 1
loadtime:0.17962598800659 / seconds
Query Executed:select id FROM `vt` where city='Hartland 4 Cors' && SIC_code='5812'DB:business_master_new
loadtime:0.17987012863159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland Four Corners' limit 1
loadtime:0.17989802360535 / seconds
Query Executed:select id FROM `vt` where city='Hartland Four Corners' && SIC_code='5812'DB:business_master_new
loadtime:0.18023109436035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Center' limit 1
loadtime:0.18028616905212 / seconds
Query Executed:select id FROM `vt` where city='Highgate Center' && SIC_code='5812'DB:business_master_new
loadtime:0.1811261177063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highgate Springs' limit 1
loadtime:0.1811830997467 / seconds
Query Executed:select id FROM `vt` where city='Highgate Springs' && SIC_code='5812'DB:business_master_new
loadtime:0.18162298202515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinesburg' limit 1
loadtime:0.18165016174316 / seconds
Query Executed:select id FROM `vt` where city='Hinesburg' && SIC_code='5812'DB:business_master_new
loadtime:0.18259000778198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.18266701698303 / seconds
Query Executed:select id FROM `vt` where city='Huntington' && SIC_code='5812'DB:business_master_new
loadtime:0.18344116210938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.18349504470825 / seconds
Query Executed:select id FROM `vt` where city='Hyde Park' && SIC_code='5812'DB:business_master_new
loadtime:0.1843740940094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hydeville' limit 1
loadtime:0.18441700935364 / seconds
Query Executed:select id FROM `vt` where city='Hydeville' && SIC_code='5812'DB:business_master_new
loadtime:0.18489217758179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irasburg' limit 1
loadtime:0.1849479675293 / seconds
Query Executed:select id FROM `vt` where city='Irasburg' && SIC_code='5812'DB:business_master_new
loadtime:0.1857590675354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Pond' limit 1
loadtime:0.18580412864685 / seconds
Query Executed:select id FROM `vt` where city='Island Pond' && SIC_code='5812'DB:business_master_new
loadtime:0.18666195869446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle La Motte' limit 1
loadtime:0.18672204017639 / seconds
Query Executed:select id FROM `vt` where city='Isle La Motte' && SIC_code='5812'DB:business_master_new
loadtime:0.18720316886902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.18725609779358 / seconds
Query Executed:select id FROM `vt` where city='Jacksonville' && SIC_code='5812'DB:business_master_new
loadtime:0.18803715705872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.18808007240295 / seconds
Query Executed:select id FROM `vt` where city='Jamaica' && SIC_code='5812'DB:business_master_new
loadtime:0.18893098831177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay' limit 1
loadtime:0.18898916244507 / seconds
Query Executed:select id FROM `vt` where city='Jay' && SIC_code='5812'DB:business_master_new
loadtime:0.18923902511597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonville' limit 1
loadtime:0.18928813934326 / seconds
Query Executed:select id FROM `vt` where city='Jeffersonville' && SIC_code='5812'DB:business_master_new
loadtime:0.19020915031433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho' limit 1
loadtime:0.19026803970337 / seconds
Query Executed:select id FROM `vt` where city='Jericho' && SIC_code='5812'DB:business_master_new
loadtime:0.19116711616516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jericho Center' limit 1
loadtime:0.19121408462524 / seconds
Query Executed:select id FROM `vt` where city='Jericho Center' && SIC_code='5812'DB:business_master_new
loadtime:0.19145917892456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:0.19150018692017 / seconds
Query Executed:select id FROM `vt` where city='Johnson' && SIC_code='5812'DB:business_master_new
loadtime:0.19243311882019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.19249296188354 / seconds
Query Executed:select id FROM `vt` where city='Jonesville' && SIC_code='5812'DB:business_master_new
loadtime:0.19282913208008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killington' limit 1
loadtime:0.19286799430847 / seconds
Query Executed:select id FROM `vt` where city='Killington' && SIC_code='5812'DB:business_master_new
loadtime:0.19412612915039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Elmore' limit 1
loadtime:0.19419002532959 / seconds
Query Executed:select id FROM `vt` where city='Lake Elmore' && SIC_code='5812'DB:business_master_new
loadtime:0.19461798667908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemington' limit 1
loadtime:0.19466114044189 / seconds
Query Executed:select id FROM `vt` where city='Lemington' && SIC_code='5812'DB:business_master_new
loadtime:0.19491410255432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.19495105743408 / seconds
Query Executed:select id FROM `vt` where city='Lincoln' && SIC_code='5812'DB:business_master_new
loadtime:0.19518208503723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.19521307945251 / seconds
Query Executed:select id FROM `vt` where city='Londonderry' && SIC_code='5812'DB:business_master_new
loadtime:0.19611310958862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.19617414474487 / seconds
Query Executed:select id FROM `vt` where city='Lowell' && SIC_code='5812'DB:business_master_new
loadtime:0.1971390247345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Waterford' limit 1
loadtime:0.19718408584595 / seconds
Query Executed:select id FROM `vt` where city='Lower Waterford' && SIC_code='5812'DB:business_master_new
loadtime:0.19757103919983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.19762206077576 / seconds
Query Executed:select id FROM `vt` where city='Ludlow' && SIC_code='5812'DB:business_master_new
loadtime:0.19886803627014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.19893002510071 / seconds
Query Executed:select id FROM `vt` where city='Lunenburg' && SIC_code='5812'DB:business_master_new
loadtime:0.19954419136047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:0.19959402084351 / seconds
Query Executed:select id FROM `vt` where city='Lyndon' && SIC_code='5812'DB:business_master_new
loadtime:0.20040202140808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Center' limit 1
loadtime:0.20045804977417 / seconds
Query Executed:select id FROM `vt` where city='Lyndon Center' && SIC_code='5812'DB:business_master_new
loadtime:0.20091009140015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndonville' limit 1
loadtime:0.20094609260559 / seconds
Query Executed:select id FROM `vt` where city='Lyndonville' && SIC_code='5812'DB:business_master_new
loadtime:0.20202612876892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.20209002494812 / seconds
Query Executed:select id FROM `vt` where city='Manchester' && SIC_code='5812'DB:business_master_new
loadtime:0.203045129776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Center' limit 1
loadtime:0.20310616493225 / seconds
Query Executed:select id FROM `vt` where city='Manchester Center' && SIC_code='5812'DB:business_master_new
loadtime:0.20451712608337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Ctr' limit 1
loadtime:0.20457696914673 / seconds
Query Executed:select id FROM `vt` where city='Manchester Ctr' && SIC_code='5812'DB:business_master_new
loadtime:0.20484304428101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:0.20488405227661 / seconds
Query Executed:select id FROM `vt` where city='Marlboro' && SIC_code='5812'DB:business_master_new
loadtime:0.20564007759094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:0.2056770324707 / seconds
Query Executed:select id FROM `vt` where city='Marshfield' && SIC_code='5812'DB:business_master_new
loadtime:0.20645904541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Indoe Falls' limit 1
loadtime:0.20651412010193 / seconds
Query Executed:select id FROM `vt` where city='Mc Indoe Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.20685315132141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.2068920135498 / seconds
Query Executed:select id FROM `vt` where city='Middlebury' && SIC_code='5812'DB:business_master_new
loadtime:0.20833802223206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Spgs' limit 1
loadtime:0.20839619636536 / seconds
Query Executed:select id FROM `vt` where city='Middletown Spgs' && SIC_code='5812'DB:business_master_new
loadtime:0.20866203308105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown Springs' limit 1
loadtime:0.20870399475098 / seconds
Query Executed:select id FROM `vt` where city='Middletown Springs' && SIC_code='5812'DB:business_master_new
loadtime:0.20946502685547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.20951008796692 / seconds
Query Executed:select id FROM `vt` where city='Milton' && SIC_code='5812'DB:business_master_new
loadtime:0.21066212654114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monkton' limit 1
loadtime:0.21072506904602 / seconds
Query Executed:select id FROM `vt` where city='Monkton' && SIC_code='5812'DB:business_master_new
loadtime:0.21128010749817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.21132516860962 / seconds
Query Executed:select id FROM `vt` where city='Montgomery' && SIC_code='5812'DB:business_master_new
loadtime:0.21172714233398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Center' limit 1
loadtime:0.21175408363342 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Center' && SIC_code='5812'DB:business_master_new
loadtime:0.21256518363953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery Ctr' limit 1
loadtime:0.21263599395752 / seconds
Query Executed:select id FROM `vt` where city='Montgomery Ctr' && SIC_code='5812'DB:business_master_new
loadtime:0.21290707588196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.21294498443604 / seconds
Query Executed:select id FROM `vt` where city='Montpelier' && SIC_code='5812'DB:business_master_new
loadtime:0.21472501754761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moretown' limit 1
loadtime:0.21478700637817 / seconds
Query Executed:select id FROM `vt` where city='Moretown' && SIC_code='5812'DB:business_master_new
loadtime:0.21556997299194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.21563196182251 / seconds
Query Executed:select id FROM `vt` where city='Morgan' && SIC_code='5812'DB:business_master_new
loadtime:0.21608304977417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.21614217758179 / seconds
Query Executed:select id FROM `vt` where city='Morrisville' && SIC_code='5812'DB:business_master_new
loadtime:0.21730613708496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.21737217903137 / seconds
Query Executed:select id FROM `vt` where city='Moscow' && SIC_code='5812'DB:business_master_new
loadtime:0.21771812438965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.21775603294373 / seconds
Query Executed:select id FROM `vt` where city='Mount Holly' && SIC_code='5812'DB:business_master_new
loadtime:0.21840405464172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.21844816207886 / seconds
Query Executed:select id FROM `vt` where city='Mt Holly' && SIC_code='5812'DB:business_master_new
loadtime:0.21872401237488 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Springfield' limit 1
loadtime:0.21876406669617 / seconds
Query Executed:select id FROM `vt` where city='N Springfield' && SIC_code='5812'DB:business_master_new
loadtime:0.21914196014404 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.21918797492981 / seconds
Query Executed:select id FROM `vt` where city='New Haven' && SIC_code='5812'DB:business_master_new
loadtime:0.22005200386047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.22012114524841 / seconds
Query Executed:select id FROM `vt` where city='Newbury' && SIC_code='5812'DB:business_master_new
loadtime:0.22070002555847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfane' limit 1
loadtime:0.2207350730896 / seconds
Query Executed:select id FROM `vt` where city='Newfane' && SIC_code='5812'DB:business_master_new
loadtime:0.22153806686401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.22159814834595 / seconds
Query Executed:select id FROM `vt` where city='Newport' && SIC_code='5812'DB:business_master_new
loadtime:0.22286605834961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport Center' limit 1
loadtime:0.22293305397034 / seconds
Query Executed:select id FROM `vt` where city='Newport Center' && SIC_code='5812'DB:business_master_new
loadtime:0.22366309165955 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bennington' limit 1
loadtime:0.22370004653931 / seconds
Query Executed:select id FROM `vt` where city='North Bennington' && SIC_code='5812'DB:business_master_new
loadtime:0.22454214096069 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chittenden' limit 1
loadtime:0.2245991230011 / seconds
Query Executed:select id FROM `vt` where city='North Chittenden' && SIC_code='5812'DB:business_master_new
loadtime:0.22483706474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Clarendon' limit 1
loadtime:0.22486710548401 / seconds
Query Executed:select id FROM `vt` where city='North Clarendon' && SIC_code='5812'DB:business_master_new
loadtime:0.22568702697754 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Concord' limit 1
loadtime:0.22574400901794 / seconds
Query Executed:select id FROM `vt` where city='North Concord' && SIC_code='5812'DB:business_master_new
loadtime:0.22608017921448 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Ferrisburg' limit 1
loadtime:0.22612500190735 / seconds
Query Executed:select id FROM `vt` where city='North Ferrisburg' && SIC_code='5812'DB:business_master_new
loadtime:0.22636604309082 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hartland' limit 1
loadtime:0.22639417648315 / seconds
Query Executed:select id FROM `vt` where city='North Hartland' && SIC_code='5812'DB:business_master_new
loadtime:0.22675514221191 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hero' limit 1
loadtime:0.22679114341736 / seconds
Query Executed:select id FROM `vt` where city='North Hero' && SIC_code='5812'DB:business_master_new
loadtime:0.22753810882568 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hyde Park' limit 1
loadtime:0.22757411003113 / seconds
Query Executed:select id FROM `vt` where city='North Hyde Park' && SIC_code='5812'DB:business_master_new
loadtime:0.2279531955719 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Montpelier' limit 1
loadtime:0.2280011177063 / seconds
Query Executed:select id FROM `vt` where city='North Montpelier' && SIC_code='5812'DB:business_master_new
loadtime:0.22832107543945 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pomfret' limit 1
loadtime:0.2283570766449 / seconds
Query Executed:select id FROM `vt` where city='North Pomfret' && SIC_code='5812'DB:business_master_new
loadtime:0.22881603240967 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pownal' limit 1
loadtime:0.22885608673096 / seconds
Query Executed:select id FROM `vt` where city='North Pownal' && SIC_code='5812'DB:business_master_new
loadtime:0.22921895980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Springfield' limit 1
loadtime:0.22925496101379 / seconds
Query Executed:select id FROM `vt` where city='North Springfield' && SIC_code='5812'DB:business_master_new
loadtime:0.23006510734558 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Thetford' limit 1
loadtime:0.23012113571167 / seconds
Query Executed:select id FROM `vt` where city='North Thetford' && SIC_code='5812'DB:business_master_new
loadtime:0.23046207427979 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Troy' limit 1
loadtime:0.2304961681366 / seconds
Query Executed:select id FROM `vt` where city='North Troy' && SIC_code='5812'DB:business_master_new
loadtime:0.23136496543884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.23142600059509 / seconds
Query Executed:select id FROM `vt` where city='Northfield' && SIC_code='5812'DB:business_master_new
loadtime:0.23243999481201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield Falls' limit 1
loadtime:0.23248910903931 / seconds
Query Executed:select id FROM `vt` where city='Northfield Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.23290514945984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.23296403884888 / seconds
Query Executed:select id FROM `vt` where city='Norton' && SIC_code='5812'DB:business_master_new
loadtime:0.23345518112183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.23350715637207 / seconds
Query Executed:select id FROM `vt` where city='Norwich' && SIC_code='5812'DB:business_master_new
loadtime:0.23445105552673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.23451209068298 / seconds
Query Executed:select id FROM `vt` where city='Orange' && SIC_code='5812'DB:business_master_new
loadtime:0.23477911949158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:0.23481798171997 / seconds
Query Executed:select id FROM `vt` where city='Orleans' && SIC_code='5812'DB:business_master_new
loadtime:0.23563504219055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orwell' limit 1
loadtime:0.23569297790527 / seconds
Query Executed:select id FROM `vt` where city='Orwell' && SIC_code='5812'DB:business_master_new
loadtime:0.23650407791138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passumpsic' limit 1
loadtime:0.23654913902283 / seconds
Query Executed:select id FROM `vt` where city='Passumpsic' && SIC_code='5812'DB:business_master_new
loadtime:0.23682308197021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawlet' limit 1
loadtime:0.23686814308167 / seconds
Query Executed:select id FROM `vt` where city='Pawlet' && SIC_code='5812'DB:business_master_new
loadtime:0.23778009414673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peacham' limit 1
loadtime:0.2378261089325 / seconds
Query Executed:select id FROM `vt` where city='Peacham' && SIC_code='5812'DB:business_master_new
loadtime:0.23832607269287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinsville' limit 1
loadtime:0.23838210105896 / seconds
Query Executed:select id FROM `vt` where city='Perkinsville' && SIC_code='5812'DB:business_master_new
loadtime:0.2391951084137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.23925018310547 / seconds
Query Executed:select id FROM `vt` where city='Peru' && SIC_code='5812'DB:business_master_new
loadtime:0.23973298072815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.23976016044617 / seconds
Query Executed:select id FROM `vt` where city='Pittsfield' && SIC_code='5812'DB:business_master_new
loadtime:0.24035906791687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:0.24041509628296 / seconds
Query Executed:select id FROM `vt` where city='Pittsford' && SIC_code='5812'DB:business_master_new
loadtime:0.24134397506714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.24140405654907 / seconds
Query Executed:select id FROM `vt` where city='Plainfield' && SIC_code='5812'DB:business_master_new
loadtime:0.2422411441803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.2422981262207 / seconds
Query Executed:select id FROM `vt` where city='Plymouth' && SIC_code='5812'DB:business_master_new
loadtime:0.242830991745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Post Mills' limit 1
loadtime:0.24286603927612 / seconds
Query Executed:select id FROM `vt` where city='Post Mills' && SIC_code='5812'DB:business_master_new
loadtime:0.24330806732178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poultney' limit 1
loadtime:0.24336409568787 / seconds
Query Executed:select id FROM `vt` where city='Poultney' && SIC_code='5812'DB:business_master_new
loadtime:0.24428105354309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pownal' limit 1
loadtime:0.24432611465454 / seconds
Query Executed:select id FROM `vt` where city='Pownal' && SIC_code='5812'DB:business_master_new
loadtime:0.24513101577759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.24519014358521 / seconds
Query Executed:select id FROM `vt` where city='Proctor' && SIC_code='5812'DB:business_master_new
loadtime:0.24605011940002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorsville' limit 1
loadtime:0.24610805511475 / seconds
Query Executed:select id FROM `vt` where city='Proctorsville' && SIC_code='5812'DB:business_master_new
loadtime:0.24690008163452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putney' limit 1
loadtime:0.24693608283997 / seconds
Query Executed:select id FROM `vt` where city='Putney' && SIC_code='5812'DB:business_master_new
loadtime:0.24787211418152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quechee' limit 1
loadtime:0.24793004989624 / seconds
Query Executed:select id FROM `vt` where city='Quechee' && SIC_code='5812'DB:business_master_new
loadtime:0.24885511398315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.2489161491394 / seconds
Query Executed:select id FROM `vt` where city='Randolph' && SIC_code='5812'DB:business_master_new
loadtime:0.24995803833008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph Center' limit 1
loadtime:0.25001811981201 / seconds
Query Executed:select id FROM `vt` where city='Randolph Center' && SIC_code='5812'DB:business_master_new
loadtime:0.25078105926514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:0.25083017349243 / seconds
Query Executed:select id FROM `vt` where city='Reading' && SIC_code='5812'DB:business_master_new
loadtime:0.2514340877533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readsboro' limit 1
loadtime:0.25147819519043 / seconds
Query Executed:select id FROM `vt` where city='Readsboro' && SIC_code='5812'DB:business_master_new
loadtime:0.25206804275513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richford' limit 1
loadtime:0.25212812423706 / seconds
Query Executed:select id FROM `vt` where city='Richford' && SIC_code='5812'DB:business_master_new
loadtime:0.25301909446716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.25307607650757 / seconds
Query Executed:select id FROM `vt` where city='Richmond' && SIC_code='5812'DB:business_master_new
loadtime:0.25400996208191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripton' limit 1
loadtime:0.25405597686768 / seconds
Query Executed:select id FROM `vt` where city='Ripton' && SIC_code='5812'DB:business_master_new
loadtime:0.25441908836365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.25446796417236 / seconds
Query Executed:select id FROM `vt` where city='Rochester' && SIC_code='5812'DB:business_master_new
loadtime:0.25530910491943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.25536417961121 / seconds
Query Executed:select id FROM `vt` where city='Roxbury' && SIC_code='5812'DB:business_master_new
loadtime:0.25589418411255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.25593018531799 / seconds
Query Executed:select id FROM `vt` where city='Rupert' && SIC_code='5812'DB:business_master_new
loadtime:0.25633096694946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.25637912750244 / seconds
Query Executed:select id FROM `vt` where city='Rutland' && SIC_code='5812'DB:business_master_new
loadtime:0.25899600982666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryegate' limit 1
loadtime:0.25911116600037 / seconds
Query Executed:select id FROM `vt` where city='Ryegate' && SIC_code='5812'DB:business_master_new
loadtime:0.25952911376953 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Londonderry' limit 1
loadtime:0.25957012176514 / seconds
Query Executed:select id FROM `vt` where city='S Londonderry' && SIC_code='5812'DB:business_master_new
loadtime:0.26013708114624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.26018500328064 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans' && SIC_code='5812'DB:business_master_new
loadtime:0.2639331817627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans Bay' limit 1
loadtime:0.26401305198669 / seconds
Query Executed:select id FROM `vt` where city='Saint Albans Bay' && SIC_code='5812'DB:business_master_new
loadtime:0.26459503173828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury' limit 1
loadtime:0.26466202735901 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.26637101173401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johnsbury Center' limit 1
loadtime:0.26644206047058 / seconds
Query Executed:select id FROM `vt` where city='Saint Johnsbury Center' && SIC_code='5812'DB:business_master_new
loadtime:0.2668890953064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.26692819595337 / seconds
Query Executed:select id FROM `vt` where city='Salisbury' && SIC_code='5812'DB:business_master_new
loadtime:0.26769113540649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxtons River' limit 1
loadtime:0.26774001121521 / seconds
Query Executed:select id FROM `vt` where city='Saxtons River' && SIC_code='5812'DB:business_master_new
loadtime:0.26857113838196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsbury' limit 1
loadtime:0.268630027771 / seconds
Query Executed:select id FROM `vt` where city='Shaftsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.26950407028198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.2695620059967 / seconds
Query Executed:select id FROM `vt` where city='Sharon' && SIC_code='5812'DB:business_master_new
loadtime:0.27038216590881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.2704451084137 / seconds
Query Executed:select id FROM `vt` where city='Sheffield' && SIC_code='5812'DB:business_master_new
loadtime:0.27092003822327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.27095699310303 / seconds
Query Executed:select id FROM `vt` where city='Shelburne' && SIC_code='5812'DB:business_master_new
loadtime:0.27232098579407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.27238607406616 / seconds
Query Executed:select id FROM `vt` where city='Sheldon' && SIC_code='5812'DB:business_master_new
loadtime:0.27320599555969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon Springs' limit 1
loadtime:0.2732629776001 / seconds
Query Executed:select id FROM `vt` where city='Sheldon Springs' && SIC_code='5812'DB:business_master_new
loadtime:0.27364611625671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoreham' limit 1
loadtime:0.27367997169495 / seconds
Query Executed:select id FROM `vt` where city='Shoreham' && SIC_code='5812'DB:business_master_new
loadtime:0.27450513839722 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:0.27456116676331 / seconds
Query Executed:select id FROM `vt` where city='South Barre' && SIC_code='5812'DB:business_master_new
loadtime:0.27535104751587 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Burlington' limit 1
loadtime:0.27539610862732 / seconds
Query Executed:select id FROM `vt` where city='South Burlington' && SIC_code='5812'DB:business_master_new
loadtime:0.27754902839661 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hero' limit 1
loadtime:0.27765798568726 / seconds
Query Executed:select id FROM `vt` where city='South Hero' && SIC_code='5812'DB:business_master_new
loadtime:0.27854800224304 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Londonderry' limit 1
loadtime:0.27859616279602 / seconds
Query Executed:select id FROM `vt` where city='South Londonderry' && SIC_code='5812'DB:business_master_new
loadtime:0.27943897247314 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newfane' limit 1
loadtime:0.27949500083923 / seconds
Query Executed:select id FROM `vt` where city='South Newfane' && SIC_code='5812'DB:business_master_new
loadtime:0.27983117103577 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pomfret' limit 1
loadtime:0.27986812591553 / seconds
Query Executed:select id FROM `vt` where city='South Pomfret' && SIC_code='5812'DB:business_master_new
loadtime:0.28035402297974 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Royalton' limit 1
loadtime:0.28039002418518 / seconds
Query Executed:select id FROM `vt` where city='South Royalton' && SIC_code='5812'DB:business_master_new
loadtime:0.28130102157593 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Ryegate' limit 1
loadtime:0.28136014938354 / seconds
Query Executed:select id FROM `vt` where city='South Ryegate' && SIC_code='5812'DB:business_master_new
loadtime:0.28188705444336 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Strafford' limit 1
loadtime:0.28193211555481 / seconds
Query Executed:select id FROM `vt` where city='South Strafford' && SIC_code='5812'DB:business_master_new
loadtime:0.28245115280151 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.28249907493591 / seconds
Query Executed:select id FROM `vt` where city='South Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:0.28300809860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.28306698799133 / seconds
Query Executed:select id FROM `vt` where city='Springfield' && SIC_code='5812'DB:business_master_new
loadtime:0.284264087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.28431606292725 / seconds
Query Executed:select id FROM `vt` where city='St Albans' && SIC_code='5812'DB:business_master_new
loadtime:0.28467917442322 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans Bay' limit 1
loadtime:0.28472113609314 / seconds
Query Executed:select id FROM `vt` where city='St Albans Bay' && SIC_code='5812'DB:business_master_new
loadtime:0.28506803512573 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.28510308265686 / seconds
Query Executed:select id FROM `vt` where city='St George' && SIC_code='5812'DB:business_master_new
loadtime:0.28534317016602 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury' limit 1
loadtime:0.28537917137146 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.28604006767273 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johnsbury Ctr' limit 1
loadtime:0.28608417510986 / seconds
Query Executed:select id FROM `vt` where city='St Johnsbury Ctr' && SIC_code='5812'DB:business_master_new
loadtime:0.286297082901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.28633904457092 / seconds
Query Executed:select id FROM `vt` where city='Stamford' && SIC_code='5812'DB:business_master_new
loadtime:0.28681516647339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starksboro' limit 1
loadtime:0.28685116767883 / seconds
Query Executed:select id FROM `vt` where city='Starksboro' && SIC_code='5812'DB:business_master_new
loadtime:0.28761410713196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:0.28767108917236 / seconds
Query Executed:select id FROM `vt` where city='Stockbridge' && SIC_code='5812'DB:business_master_new
loadtime:0.28817415237427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stowe' limit 1
loadtime:0.28821897506714 / seconds
Query Executed:select id FROM `vt` where city='Stowe' && SIC_code='5812'DB:business_master_new
loadtime:0.28971600532532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.2897961139679 / seconds
Query Executed:select id FROM `vt` where city='Strafford' && SIC_code='5812'DB:business_master_new
loadtime:0.29028606414795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.29033398628235 / seconds
Query Executed:select id FROM `vt` where city='Sutton' && SIC_code='5812'DB:business_master_new
loadtime:0.2907931804657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanton' limit 1
loadtime:0.29083299636841 / seconds
Query Executed:select id FROM `vt` where city='Swanton' && SIC_code='5812'DB:business_master_new
loadtime:0.29183912277222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftsville' limit 1
loadtime:0.29190015792847 / seconds
Query Executed:select id FROM `vt` where city='Taftsville' && SIC_code='5812'DB:business_master_new
loadtime:0.29229617118835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford' limit 1
loadtime:0.29233407974243 / seconds
Query Executed:select id FROM `vt` where city='Thetford' && SIC_code='5812'DB:business_master_new
loadtime:0.29333209991455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thetford Center' limit 1
loadtime:0.29338717460632 / seconds
Query Executed:select id FROM `vt` where city='Thetford Center' && SIC_code='5812'DB:business_master_new
loadtime:0.29418015480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsham' limit 1
loadtime:0.2942361831665 / seconds
Query Executed:select id FROM `vt` where city='Topsham' && SIC_code='5812'DB:business_master_new
loadtime:0.29457402229309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townshend' limit 1
loadtime:0.29461407661438 / seconds
Query Executed:select id FROM `vt` where city='Townshend' && SIC_code='5812'DB:business_master_new
loadtime:0.29541802406311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.29547500610352 / seconds
Query Executed:select id FROM `vt` where city='Troy' && SIC_code='5812'DB:business_master_new
loadtime:0.29604697227478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunbridge' limit 1
loadtime:0.29611611366272 / seconds
Query Executed:select id FROM `vt` where city='Tunbridge' && SIC_code='5812'DB:business_master_new
loadtime:0.29690003395081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill' limit 1
loadtime:0.29693508148193 / seconds
Query Executed:select id FROM `vt` where city='Underhill' && SIC_code='5812'DB:business_master_new
loadtime:0.29768705368042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underhill Center' limit 1
loadtime:0.29773616790771 / seconds
Query Executed:select id FROM `vt` where city='Underhill Center' && SIC_code='5812'DB:business_master_new
loadtime:0.29816603660583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vergennes' limit 1
loadtime:0.29821014404297 / seconds
Query Executed:select id FROM `vt` where city='Vergennes' && SIC_code='5812'DB:business_master_new
loadtime:0.29924702644348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.29930710792542 / seconds
Query Executed:select id FROM `vt` where city='Vernon' && SIC_code='5812'DB:business_master_new
loadtime:0.3001720905304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vershire' limit 1
loadtime:0.3002290725708 / seconds
Query Executed:select id FROM `vt` where city='Vershire' && SIC_code='5812'DB:business_master_new
loadtime:0.30065011978149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waitsfield' limit 1
loadtime:0.30067801475525 / seconds
Query Executed:select id FROM `vt` where city='Waitsfield' && SIC_code='5812'DB:business_master_new
loadtime:0.30179309844971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.30185914039612 / seconds
Query Executed:select id FROM `vt` where city='Wallingford' && SIC_code='5812'DB:business_master_new
loadtime:0.30272102355957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardsboro' limit 1
loadtime:0.30278205871582 / seconds
Query Executed:select id FROM `vt` where city='Wardsboro' && SIC_code='5812'DB:business_master_new
loadtime:0.30326819419861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.30332016944885 / seconds
Query Executed:select id FROM `vt` where city='Warren' && SIC_code='5812'DB:business_master_new
loadtime:0.30424118041992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.30430316925049 / seconds
Query Executed:select id FROM `vt` where city='Washington' && SIC_code='5812'DB:business_master_new
loadtime:0.30509519577026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.30514216423035 / seconds
Query Executed:select id FROM `vt` where city='Waterbury' && SIC_code='5812'DB:business_master_new
loadtime:0.3063440322876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury Center' limit 1
loadtime:0.30641198158264 / seconds
Query Executed:select id FROM `vt` where city='Waterbury Center' && SIC_code='5812'DB:business_master_new
loadtime:0.30724501609802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.30730199813843 / seconds
Query Executed:select id FROM `vt` where city='Waterville' && SIC_code='5812'DB:business_master_new
loadtime:0.3078019618988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Websterville' limit 1
loadtime:0.30783009529114 / seconds
Query Executed:select id FROM `vt` where city='Websterville' && SIC_code='5812'DB:business_master_new
loadtime:0.30830502510071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:0.30836296081543 / seconds
Query Executed:select id FROM `vt` where city='Wells' && SIC_code='5812'DB:business_master_new
loadtime:0.30911898612976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells River' limit 1
loadtime:0.30916714668274 / seconds
Query Executed:select id FROM `vt` where city='Wells River' && SIC_code='5812'DB:business_master_new
loadtime:0.31001615524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burke' limit 1
loadtime:0.31006217002869 / seconds
Query Executed:select id FROM `vt` where city='West Burke' && SIC_code='5812'DB:business_master_new
loadtime:0.31084299087524 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Charleston' limit 1
loadtime:0.31089901924133 / seconds
Query Executed:select id FROM `vt` where city='West Charleston' && SIC_code='5812'DB:business_master_new
loadtime:0.31137919425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Danville' limit 1
loadtime:0.31142401695251 / seconds
Query Executed:select id FROM `vt` where city='West Danville' && SIC_code='5812'DB:business_master_new
loadtime:0.31203413009644 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dover' limit 1
loadtime:0.31206202507019 / seconds
Query Executed:select id FROM `vt` where city='West Dover' && SIC_code='5812'DB:business_master_new
loadtime:0.31313896179199 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dummerston' limit 1
loadtime:0.31320405006409 / seconds
Query Executed:select id FROM `vt` where city='West Dummerston' && SIC_code='5812'DB:business_master_new
loadtime:0.31353616714478 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Fairlee' limit 1
loadtime:0.31356406211853 / seconds
Query Executed:select id FROM `vt` where city='West Fairlee' && SIC_code='5812'DB:business_master_new
loadtime:0.31401610374451 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Glover' limit 1
loadtime:0.31406307220459 / seconds
Query Executed:select id FROM `vt` where city='West Glover' && SIC_code='5812'DB:business_master_new
loadtime:0.31430006027222 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Halifax' limit 1
loadtime:0.31432700157166 / seconds
Query Executed:select id FROM `vt` where city='West Halifax' && SIC_code='5812'DB:business_master_new
loadtime:0.31469416618347 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.31473016738892 / seconds
Query Executed:select id FROM `vt` where city='West Hartford' && SIC_code='5812'DB:business_master_new
loadtime:0.31511211395264 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Marlboro' limit 1
loadtime:0.31514716148376 / seconds
Query Executed:select id FROM `vt` where city='West Marlboro' && SIC_code='5812'DB:business_master_new
loadtime:0.31540012359619 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:0.31543517112732 / seconds
Query Executed:select id FROM `vt` where city='West Newbury' && SIC_code='5812'DB:business_master_new
loadtime:0.31575918197632 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Pawlet' limit 1
loadtime:0.31579399108887 / seconds
Query Executed:select id FROM `vt` where city='West Pawlet' && SIC_code='5812'DB:business_master_new
loadtime:0.31632113456726 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rupert' limit 1
loadtime:0.31635618209839 / seconds
Query Executed:select id FROM `vt` where city='West Rupert' && SIC_code='5812'DB:business_master_new
loadtime:0.31671619415283 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Rutland' limit 1
loadtime:0.31675601005554 / seconds
Query Executed:select id FROM `vt` where city='West Rutland' && SIC_code='5812'DB:business_master_new
loadtime:0.31761503219604 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Topsham' limit 1
loadtime:0.31766200065613 / seconds
Query Executed:select id FROM `vt` where city='West Topsham' && SIC_code='5812'DB:business_master_new
loadtime:0.31809306144714 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townshend' limit 1
loadtime:0.31814098358154 / seconds
Query Executed:select id FROM `vt` where city='West Townshend' && SIC_code='5812'DB:business_master_new
loadtime:0.31856298446655 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wardsboro' limit 1
loadtime:0.318598985672 / seconds
Query Executed:select id FROM `vt` where city='West Wardsboro' && SIC_code='5812'DB:business_master_new
loadtime:0.31910514831543 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:0.31915402412415 / seconds
Query Executed:select id FROM `vt` where city='West Windsor' && SIC_code='5812'DB:business_master_new
loadtime:0.31939601898193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.31942296028137 / seconds
Query Executed:select id FROM `vt` where city='Westfield' && SIC_code='5812'DB:business_master_new
loadtime:0.31992816925049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:0.31997203826904 / seconds
Query Executed:select id FROM `vt` where city='Westford' && SIC_code='5812'DB:business_master_new
loadtime:0.32073616981506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:0.32078719139099 / seconds
Query Executed:select id FROM `vt` where city='Westminster' && SIC_code='5812'DB:business_master_new
loadtime:0.32155513763428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Sta' limit 1
loadtime:0.32161998748779 / seconds
Query Executed:select id FROM `vt` where city='Westminster Sta' && SIC_code='5812'DB:business_master_new
loadtime:0.32186198234558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster Station' limit 1
loadtime:0.32189011573792 / seconds
Query Executed:select id FROM `vt` where city='Westminster Station' && SIC_code='5812'DB:business_master_new
loadtime:0.32230997085571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.32236504554749 / seconds
Query Executed:select id FROM `vt` where city='Weston' && SIC_code='5812'DB:business_master_new
loadtime:0.32315516471863 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Jct' limit 1
loadtime:0.32320117950439 / seconds
Query Executed:select id FROM `vt` where city='White River Jct' && SIC_code='5812'DB:business_master_new
loadtime:0.32354617118835 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River Junction' limit 1
loadtime:0.32357311248779 / seconds
Query Executed:select id FROM `vt` where city='White River Junction' && SIC_code='5812'DB:business_master_new
loadtime:0.32488012313843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.3249340057373 / seconds
Query Executed:select id FROM `vt` where city='Whiting' && SIC_code='5812'DB:business_master_new
loadtime:0.32546806335449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitingham' limit 1
loadtime:0.32550597190857 / seconds
Query Executed:select id FROM `vt` where city='Whitingham' && SIC_code='5812'DB:business_master_new
loadtime:0.32606506347656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilder' limit 1
loadtime:0.32611203193665 / seconds
Query Executed:select id FROM `vt` where city='Wilder' && SIC_code='5812'DB:business_master_new
loadtime:0.32694101333618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:0.32699203491211 / seconds
Query Executed:select id FROM `vt` where city='Williamstown' && SIC_code='5812'DB:business_master_new
loadtime:0.32782101631165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:0.3278660774231 / seconds
Query Executed:select id FROM `vt` where city='Williamsville' && SIC_code='5812'DB:business_master_new
loadtime:0.32837319374084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:0.3284170627594 / seconds
Query Executed:select id FROM `vt` where city='Williston' && SIC_code='5812'DB:business_master_new
loadtime:0.32993412017822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:0.32999610900879 / seconds
Query Executed:select id FROM `vt` where city='Wilmington' && SIC_code='5812'DB:business_master_new
loadtime:0.33114504814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.33121514320374 / seconds
Query Executed:select id FROM `vt` where city='Windsor' && SIC_code='5812'DB:business_master_new
loadtime:0.33224201202393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winooski' limit 1
loadtime:0.33230519294739 / seconds
Query Executed:select id FROM `vt` where city='Winooski' && SIC_code='5812'DB:business_master_new
loadtime:0.33341097831726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.33347606658936 / seconds
Query Executed:select id FROM `vt` where city='Wolcott' && SIC_code='5812'DB:business_master_new
loadtime:0.33429408073425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.33435201644897 / seconds
Query Executed:select id FROM `vt` where city='Woodbury' && SIC_code='5812'DB:business_master_new
loadtime:0.33476901054382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.33481407165527 / seconds
Query Executed:select id FROM `vt` where city='Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:0.33593416213989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:0.33598518371582 / seconds
Query Executed:select id FROM `vt` where city='Worcester' && SIC_code='5812'DB:business_master_new
loadtime:0.33652400970459 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.33663105964661 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.3367931842804 / seconds
Operation template executed (chunk cache operation)
loadtime:0.33686399459839 / seconds
template override:Default
loadtime:0.3368821144104 / 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.33795309066772 / seconds
Template Constructed, Array Rows:49
loadtime:0.33818507194519 / seconds
TOTAL EXECUTION TIME: 0.338
loadtime:0.33827710151672 / 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] => eating-places [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.33828115463257
TOTAL KEY ARRAYS: 69